{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instruction","Intro","Introduction","Inputs","BreedingSystems","PerformancebySystem","Sheet1","PreliminaryCompare"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":31,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instruction","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Welcome To The Comparison of Beef Natural Service to Estrus Synchronization and Artificial Insemination "]
[null,"This Workbook includes a number of spreadsheets that allows YOU, the reader, to compare the expected results from the use of estrus synchronization and artificial insemination (AI) with that of natural service for a beef herd."]
[null,"Workbook Tabs:\n• ‘Instruction’: Overview of the workings of this workbook\n• ‘Intro’: the purpose of this partial budgeting tool, considerations in the analysis, and a description of the 10 breeding systems selected for comparison purposes\n• ‘Inputs’: the input spreadsheet allowing you to provide a description of your beef operation (breeding size, weaning weight, bull costs, labor costs, semen costs, and pharmaceutical costs)  and allows you to select a protocol from a series of 10 breeding systems for comparison. Based on the selected breeding system, a series of target performances are suggested. You can use these target performances as a guideline for estimating the performance of your herd - OR - you can adjust these guidelines to reflect YOUR own experience or best estimate. All input information is highlighted in BLUE.   Upon completion of your input, press the 'proceed to Partial Budget Analysis Results' button. The results look at key input factors required under natural service and how these may change. \nFactors that impact revenue:\no Increases in productivity resulting from changes in weaning weights and weaning rates; \no Decreases resulting from fewer culled bulls and open cows;\nFactors Impacting costs:\no Bulls are a major cost factor (price and maintenance). Decreases as a result of requiring fewer bulls (feed & yardage, veterinarian costs, maintenance...); fewer replacement animals needed with improved pregnancy rates; labour requirements for heat detection \no Increases as a result of semen costs, AI technician, labour with handling cattle; cost of drugs and supplies for the AI treatments, AI equipment maintenance and depreciation.\n • ‘PerformancebySystem’: provides a guideline of recommended performance targets for each breeding system under consideration. "]
[null,"Breeding Systems:  Considerable research and field data support the use and refinement of protocols. These protocols draw on those recommended by the Beef Reproduction Task Force: Beef Cow Protocols - 2018 (www.beefrepro.unl.edu/resources).  Analysis focuses on ten proven systems which can be categorized to three groupings based on the general requirements for estrus detection:\n1) estrus detection over a 7-8 day period following synchronization treatment (4 options), \n2) estrus detection  over a 3 day period with timed AI of all remaining animals not previously detected in estrus (clean-up timed AI) (3 options) \n3) strict fixed-time AI following the prescribed hormonal treatment (3 options).\nHormones recommended in the protocols include prostaglandin F2a (PG), gonadotropin releasing hormone (GnRH), and progestins (like MGA (melengestrol acetate) or CIDR (progesterone))."]

{"sheet":"Intro","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[24,1,24,13],[18,1,18,13],[1,0,1,13],[2,1,2,13],[3,1,3,13],[12,1,12,13],[4,1,4,13],[6,1,6,13],[8,1,8,13],[10,1,10,13],[14,1,14,13],[16,1,16,13],[20,1,20,13],[22,1,22,13],[4,0,24,0]]}
[]
["Partial Budget Comparison of Natural Service vs Synchronized AI Programs for Beef Cattle"]
["Proposed Comparison: ","This partial budget is designed as a tool to help producers and industry stakeholders compare between options of use of artificial insemination (AI) to that of using natural service bulls for cow-calf operations.  Although AI is widely used in the dairy industry, the current standard practice in beef is that of relying solely on bull breeding.  There are trade-offs when comparing the breeding programs, specifically, differences in costs,  conception rates and synchronization methods."]
["Considerations:  ","Protocol comparisons (based primarily on those recommended by the Beef Reproduction Task Force: Beef Cow Protocols - 2018, www.beefrepro.unl.edu/resource) look at three protocol groupings based on time required for estrus detection: estrus detection and AI; AI for 3 days after observed estrus and then fixed-timed AI of all nonresponders (cleanup-timed AI); or strict, fixed-time AI.     \nAdvantages of synchronized AI may include:\n• Shortening and concentrating the calving and breeding season \n• Increasing the time needed for postpartum recovery in cows and first-calf heifers \n• The ability to induce anestrous cows and prepubertal heifers to cycle \n• Moving the breeding season to an earlier time of year \n• Introducing new genetics into the herd \n• Improving the uniformity of a calf crop (weight, color, disposition) \n• Increasing calf performance and weaning weights with earlier birthdates"]
["Breeding Systems","a. Natural Service - herd bulls limited on the number of cows serviced during the breeding season\n1) Estrus Detection\nb. Select Synch- Gonadotropin-releasing hormone (GnRH) is injected intramuscular (i.m.) day 0 and Prostaglandin (PG) is injected i.m. day 7. Cows are observed for estrus and AI days 6-13."]
[]
[null,"c. Select Synch +Controlled internal drug release (CIDR) - GnRH is injected i.m. day 0, PG is injected i.m. day 7, and a CIDR is inserted intravaginal at the time of GnRH injection and is removed at the time of PG injection. Cows are observed for estrus and AI days 7-13."]
[]
[null,"d. Prostaglandin F2a (PG) 6-day CIDR - PG  on day 0. Heat detect and AI days 0 to 3. Insert CIDR and give GnRH to nonresponders on day 3 and remove it on day 9 along with PG i.m. Heat detect and AI days 9 to 12. "]
[]
[null,"e. Melengestrol acetate (MGA)+PG- for use with heifers - MGA is fed days 1-14 and PG is injected i.m. day 33. Heifers are observed for estrus and AI days 33-39."]
[]
[null,"2) Estrus Detection with Cleanup AI\na. Select Synch +Timed AI (TAI) - GnRH is injected i.m. day 0 and PG is injected i.m. day 7. Cows are observed for estrus and AI days 6-10 followed by GnRH and TAI day 10 for all cows not AI by day 10. \n"]
[]
[null,"\nb. Select Synch+CIDR+TAI - GnRH is injected i.m. day 0, PG is injected i.m. day 7, and a CIDR is inserted intravaginal at the time of GnRH injection and is removed at the time of PG injection. Cows and heifers are observed for estrus and AI days 7-10 followed by GnRH and TAI day 10 for all cows and heifers not AI by day 10. "]
[]
[null,"c. PG 6-day CIDR +TAI- PG  on day 0. Heat detect & AI days 0 to 3. Insert CIDR and give GnRH to non-responders on day 3 and remove it on day 9 along with PG i.m. Heat detect and AI days 9 to 12. TAI non-responders 72 - 84 hr after CIDR removal with GnRH at AI."]
[]
[null,"3) Fixed-time AI\na. 7-day CO-Synch+CIDR - GnRH is administered at CIDR insertion on day 0, followed by CIDR removal, and PGF2α. Insemination is performed 56 (heifers) - 66 (cows) hours after CIDR removal and PGF2α, with GnRH administered at AI.\n"]
[]
[null,"b. 5-day CO-Synch+CIDR- GnRH is administered at CIDR insertion on day 0, followed by CIDR removal, and PG i.m. on day 5. A second injection of PG is administered 8 ± 2 hours after first PG. Insemination is performed 72 hours after CIDR removal , with GnRH administered at AI."]
[]
[null,"\nc. 7-day Estradiol+CIDR-administration of Estradiol at CIDR insertion on day 0, PG upon removal of CIDR on day 7, and Estradiol on day 8. AI 30-34 hours after 2nd estradiol treatment."]

{"sheet":"Introduction","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Inputs","index":3,"n_rows":145,"n_cols":22,"rows_kept":145,"cut":false,"hidden":false,"merged":[[143,1,143,13],[7,5,7,6],[131,8,131,10],[130,8,130,10],[126,1,126,3],[133,8,133,10],[117,8,117,10],[127,1,127,3],[133,1,133,3],[117,1,117,3],[118,1,118,3],[119,8,119,10],[118,8,118,10],[122,1,122,3],[124,1,124,3],[114,1,114,13],[128,8,128,10],[8,7,8,8],[134,1,134,3],[141,1,141,13],[142,1,142,13],[134,8,134,10],[122,8,122,10],[132,8,132,10],[129,8,129,10],[124,8,124,10]]}
[]
[null,"Comparison:"]
[null,null,null,null,"vs",null,"Select one of the following:"]
[null,"Breeding system:","Estrus_Detection",null,null,"Breeding system:","Estrus_Detection"]
[null,"Protocol: ","Natural Service",null,null,"Protocol: ","Select Synch +CIDR"]
[{"$f":"+C5","v":"Natural Service"},"Code:",{"$f":"VLOOKUP(C5,R99:S109,2,FALSE)","v":1},null,null,"Code:",{"$f":"VLOOKUP(G5,R99:S109,2,FALSE)","v":3}]
[]
[null,null,{"$f":"+C5","v":"Natural Service"},null,null,{"$f":"+G5","v":"Select Synch +CIDR"}]
[null,null,null,"Your Estimate",null,"Your Estimate",null,"Target Performance"]
[null,"Number of cows in the herd",null,100,"head",100,"head",{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D20,IF(Inputs!$G$6=3,PerformancebySystem!E20,IF(Inputs!$G$6=4,PerformancebySystem!F20,IF(Inputs!$G$6=5,PerformancebySystem!G20, IF(Inputs!$G$6=6,PerformancebySystem!H20,IF(Inputs!$G$6=7,PerformancebySystem!I20,IF(Inputs!$G$6=8,PerformancebySystem!J20,IF(Inputs!$G$6=9,PerformancebySystem!K20,IF(Inputs!$G$6=10,PerformancebySystem!L20,IF(Inputs!$G$6=11,PerformancebySystem!M20,0))))))))))","v":100}]
[null,"Cows/bull ",null,25,null,25,null,{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D21,IF(Inputs!$G$6=3,PerformancebySystem!E21,IF(Inputs!$G$6=4,PerformancebySystem!F21,IF(Inputs!$G$6=5,PerformancebySystem!G21, IF(Inputs!$G$6=6,PerformancebySystem!H21,IF(Inputs!$G$6=7,PerformancebySystem!I21,IF(Inputs!$G$6=8,PerformancebySystem!J21,IF(Inputs!$G$6=9,PerformancebySystem!K21,IF(Inputs!$G$6=10,PerformancebySystem!L21,IF(Inputs!$G$6=11,PerformancebySystem!M21,0))))))))))","v":25}]
[null,"Breeding season days",null,83,null,60,null,{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D22,IF(Inputs!$G$6=3,PerformancebySystem!E22,IF(Inputs!$G$6=4,PerformancebySystem!F22,IF(Inputs!$G$6=5,PerformancebySystem!G22, IF(Inputs!$G$6=6,PerformancebySystem!H22,IF(Inputs!$G$6=7,PerformancebySystem!I22,IF(Inputs!$G$6=8,PerformancebySystem!J22,IF(Inputs!$G$6=9,PerformancebySystem!F22,IF(Inputs!$G$6=10,PerformancebySystem!L22,IF(Inputs!$G$6=11,PerformancebySystem!M22,0))))))))))","v":60}]
[null,"Bulls needed",null,{"$f":"+D10/D11","v":4},"head",{"$f":"H13","v":2},"head",{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D23,IF(Inputs!$G$6=3,PerformancebySystem!E23,IF(Inputs!$G$6=4,PerformancebySystem!F23,IF(Inputs!$G$6=5,PerformancebySystem!G23, IF(Inputs!$G$6=6,PerformancebySystem!H23,IF(Inputs!$G$6=7,PerformancebySystem!I23,IF(Inputs!$G$6=8,PerformancebySystem!J23,IF(Inputs!$G$6=9,PerformancebySystem!F23,IF(Inputs!$G$6=10,PerformancebySystem!L23,IF(Inputs!$G$6=11,PerformancebySystem!M23,0))))))))))","v":2}]
[null,"End of season pregnancy rate*",null,90,"%",95,"%",{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D27,IF(Inputs!$G$6=3,PerformancebySystem!E27,IF(Inputs!$G$6=4,PerformancebySystem!F27,IF(Inputs!$G$6=5,PerformancebySystem!G27, IF(Inputs!$G$6=6,PerformancebySystem!H27,IF(Inputs!$G$6=7,PerformancebySystem!I27,IF(Inputs!$G$6=8,PerformancebySystem!J27,IF(Inputs!$G$6=9,PerformancebySystem!F27,IF(Inputs!$G$6=10,PerformancebySystem!L27,IF(Inputs!$G$6=11,PerformancebySystem!M27,0))))))))))","v":95}]
[null,"Percent calving rate*",null,98,"%",93,"%",{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D29,IF(Inputs!$G$6=3,PerformancebySystem!E29,IF(Inputs!$G$6=4,PerformancebySystem!F29,IF(Inputs!$G$6=5,PerformancebySystem!G29, IF(Inputs!$G$6=6,PerformancebySystem!H29,IF(Inputs!$G$6=7,PerformancebySystem!I29,IF(Inputs!$G$6=8,PerformancebySystem!J29,IF(Inputs!$G$6=9,PerformancebySystem!F29,IF(Inputs!$G$6=10,PerformancebySystem!L29,IF(Inputs!$G$6=11,PerformancebySystem!M29,0))))))))))","v":93}]
[null,"calving span, days*",null,93,"days",64,"days",{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D31,IF(Inputs!$G$6=3,PerformancebySystem!E31,IF(Inputs!$G$6=4,PerformancebySystem!F31,IF(Inputs!$G$6=5,PerformancebySystem!G31, IF(Inputs!$G$6=6,PerformancebySystem!H31,IF(Inputs!$G$6=7,PerformancebySystem!I31,IF(Inputs!$G$6=8,PerformancebySystem!J31,IF(Inputs!$G$6=9,PerformancebySystem!F31,IF(Inputs!$G$6=10,PerformancebySystem!L31,IF(Inputs!$G$6=11,PerformancebySystem!M31,0))))))))))","v":64}]
[null,"calf birth weight, lbs*",null,85,null,85,null,{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D30,IF(Inputs!$G$6=3,PerformancebySystem!E30,IF(Inputs!$G$6=4,PerformancebySystem!F30,IF(Inputs!$G$6=5,PerformancebySystem!G30, IF(Inputs!$G$6=6,PerformancebySystem!H30,IF(Inputs!$G$6=7,PerformancebySystem!I30,IF(Inputs!$G$6=8,PerformancebySystem!J30,IF(Inputs!$G$6=9,PerformancebySystem!F30,IF(Inputs!$G$6=10,PerformancebySystem!L30,IF(Inputs!$G$6=11,PerformancebySystem!M30,0))))))))))","v":85}]
[null,"calf crop, %*",null,84,null,89,null,{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D32,IF(Inputs!$G$6=3,PerformancebySystem!E32,IF(Inputs!$G$6=4,PerformancebySystem!F32,IF(Inputs!$G$6=5,PerformancebySystem!G32, IF(Inputs!$G$6=6,PerformancebySystem!H32,IF(Inputs!$G$6=7,PerformancebySystem!I32,IF(Inputs!$G$6=8,PerformancebySystem!J32,IF(Inputs!$G$6=9,PerformancebySystem!F32,IF(Inputs!$G$6=10,PerformancebySystem!L32,IF(Inputs!$G$6=11,PerformancebySystem!M32,0))))))))))","v":89}]
[null,"Calf 205-d adjusted weaning wt",null,488,null,496.8,null,{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D33,IF(Inputs!$G$6=3,PerformancebySystem!E33,IF(Inputs!$G$6=4,PerformancebySystem!F33,IF(Inputs!$G$6=5,PerformancebySystem!G33, IF(Inputs!$G$6=6,PerformancebySystem!H33,IF(Inputs!$G$6=7,PerformancebySystem!I33,IF(Inputs!$G$6=8,PerformancebySystem!J33,IF(Inputs!$G$6=9,PerformancebySystem!F33,IF(Inputs!$G$6=10,PerformancebySystem!L33,IF(Inputs!$G$6=11,PerformancebySystem!M33,0))))))))))","v":496.824816}]
[]
[null,"Time spent / observation (min.) for AI",null,0,null,30,null,{"$f":"BreedingSystems!N27","v":30}]
[null,"Heat observations /day for AI",null,0,null,2,null,{"$f":"BreedingSystems!N28","v":2}]
[]
[null,"heat detection with AI",null,"-",null,0.8,null,{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D24,IF(Inputs!$G$6=3,PerformancebySystem!E24,IF(Inputs!$G$6=4,PerformancebySystem!F24,IF(Inputs!$G$6=5,PerformancebySystem!G24, IF(Inputs!$G$6=6,PerformancebySystem!H24,IF(Inputs!$G$6=7,PerformancebySystem!I24,IF(Inputs!$G$6=8,PerformancebySystem!J24,IF(Inputs!$G$6=9,PerformancebySystem!K24,IF(Inputs!$G$6=10,PerformancebySystem!L24,IF(Inputs!$G$6=11,PerformancebySystem!M24,0))))))))))*100","v":80},"%"]
[null,"conception rate with AI",null,"-",null,0.55000000000000004,null,{"$f":"IF(Inputs!$G$6=2, PerformancebySystem!D25,IF(Inputs!$G$6=3,PerformancebySystem!E25,IF(Inputs!$G$6=4,PerformancebySystem!F25,IF(Inputs!$G$6=5,PerformancebySystem!G25, IF(Inputs!$G$6=6,PerformancebySystem!H25,IF(Inputs!$G$6=7,PerformancebySystem!I25,IF(Inputs!$G$6=8,PerformancebySystem!J25,IF(Inputs!$G$6=9,PerformancebySystem!K25,IF(Inputs!$G$6=10,PerformancebySystem!L25,IF(Inputs!$G$6=11,PerformancebySystem!M25,0))))))))))*100","v":55.000000000000007},"%"]
[null,"# of services",null,3,null,1]
[null,"AI (yes-1/no-0)",null,0,null,1]
[null,"steer 5-600 price",null,{"$f":"(200+225)/2","v":212.5},"/cwt"]
[null,"heifer 5-600 price",null,{"$f":"(185+209)/2","v":197},"/cwt"]
[null,"D1,2 cow",null,{"$f":"(85+100)/2","v":92.5},"/cwt"]
[null,"interest rate",null,5,"%"]
[null,"Herd Replacement  (Bulls)",null,25,"%"]
[null,"Bull Replacement Rate",null,5000,"/bull"]
[null,"Original Cost",null,3500,"/bull"]
[null,"Bad bull loss",null,5,"%"]
[null,"Bull death loss",null,2,"%"]
[null,"Cull bull sale weight",null,2050,"lbs"]
[null,"Cull bull sale price",null,{"$f":"(108+131)/2","v":119.5},"per cwt"]
[null,"Cull value",null,{"$f":"+D37*D38/100","v":2449.75}]
[]
[null,"Feed Prices:"]
[null,"Barley grain1",{"$f":"(230+235)/2","v":232.5},"/tonne","Blue Salt5",9.49,"/55 lb block"]
[null,"barley straw2",{"$f":"0.034*2000","v":68},"/ton","Mineral",35,"/55 lb block"]
[null,"barley silage3",{"$f":"C42/45.93*12","v":60.744611365120832},"/ton"]
[null,"alfalfa-brome hay4",{"$f":"0.075*2204","v":165.29999999999998},"/tonne"]
[]
[null,"Feed Requirement Per Bull"]
[null,"        Barley",null,null,7," lbs/day"]
[null,"        Days/Year on Barley",null,null,120," days"]
[null,"        Hay (Good Quality)",null,null,4," tons/yr"]
[null,"Pasture",null,null,{"$f":"0.9*180","v":162},"/bull"]
[null,"Feed for Bulls"]
[null,"Feed Type","$/unit","lbs/Unit","$/lb","lbs feed","Total Cost/bull"]
[null,"alfalfa-brome hay4",{"$f":"+C45","v":165.29999999999998},2204,{"$f":"+C54/D54","v":7.4999999999999997E-2},{"$f":"+E50*2000","v":8000},{"$f":"+E54*F54","v":600}]
[null,"Barley grain1",{"$f":"+C42","v":232.5},2204,{"$f":"+C55/D55","v":0.10549001814882032},{"$f":"+E48*E49","v":840},{"$f":"+F55*E55","v":88.611615245009077}]
[]
[]
[null,"OTHER COST"]
[null,"Labour & Management",2000,"total","Annual Purchases Minus Culls"]
[null,"Marketing culls",50,"/bull","Injury Loss",{"$f":"D35/100*((D33+D39)/2-D39)","v":63.756250000000001}]
[null,"Insurance",4.75,"/bull","Death Loss",{"$f":"D36/100*(D33+D39)/2","v":74.497500000000002}]
[null,"Veterinarian",50,"/bull","Feed",{"$f":"+G54+G55+E51","v":850.61161524500903}]
[null,"Miscellaneous",6.5,"/bull"]
[null,"Building Costs",3.5,"/bull"]
[null,"Bedding",30,"/bull"]
[null,"depreciation ",{"$f":"(D33-D39)/4","v":637.5625},"/bull"]
[]
[null,"Costs of AI:",null,null,null,null,null,"cows/hr"]
[null,"prostaglandin ($/dose)",5,null,"materials ($/cow)",1,"insert CIDR",50]
[null,"GnRH ($/dose)",3.5,null," ($/cow)",12.5,"remove CIDR",100]
[null,"CIDR",18,null,"wage rate ($/hr)",20,"AI treating",50]
[null,"Cost of pregnancy diagnosis",3,null,null,null,"hormone dosing",100]
[null,"Semen ($/unit):",25]
[null,"Estradiol ($/dose)",2]
[null,"AI Technician $/cow",12.5]
[null,"MGA ($/cow)",0.11]
[]
[]
[]
[null,null,"Beg. Value","End Value","Life (yr)","Annual Maintenance"]
[null,"AI Corrals and Chutes",20000,5000,15,300]
[null,"Nitrogen Tank",500,200,15]
[null,null,{"$f":"+C81+C82","v":20500},{"$f":"+D81+D82","v":5200}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Breeding System"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estrus_Detection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estrus_Detection_with_CleanUp_AI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed_time_AI"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Code","Estrus Detection","Code",{"$f":"+Q88","v":"Estrus_Detection_with_CleanUp_AI"},"Code",{"$f":"+Q89","v":"Fixed_time_AI"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Select Synch",6,"Select Synch + TAI",9,"7 day Co-Synch + CIDR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Select Synch +CIDR",7,"Select Synch + CIDR + TAI",10,"5 day Co-Synch + CIDR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"PG 6-day CIDR",8,"PG 6 Day CIDR + TAI",11,"7 day Estradiol + CIDR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"MGA+PG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Natural Service"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"System","Code"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Service",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Synch",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Synch +CIDR",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PG 6-day CIDR",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MGA+PG",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Synch + TAI",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Synch + CIDR + TAI",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PG 6 Day CIDR + TAI",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 day Co-Synch + CIDR",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 day Co-Synch + CIDR",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 day Estradiol + CIDR",11]
[]
[]
[]
[]
[]
[null,"Partial Budget Analysis"]
[null,null,{"$f":"+C5","v":"Natural Service"},null,null,null,"vs",{"$f":"+G5","v":"Select Synch +CIDR"}]
[null,"GAINS",null,null,null,null,null,null,"LOSSES"]
[null,"Increased revenue from proposed change",null,null,"Change",null,"Total",null,"Decreased revenue from proposed change",null,null,"change","unit","Total"]
[null,"value of additional beef production:",null,null,null,null,null,null,"reduced cull bull sales",null,null,{"$f":"+(D13/4)-(F13/4)","v":0.5},"bull",{"$f":"+L119*D39","v":1224.875}]
[null,"- change in wean weight",null,null,{"$f":"(F10*F18/100*F19)-(D10*D18/100*D19)","v":3223.2000000000044},"lbs",{"$f":"+E120*((D28+D29)/2)/100","v":6599.5020000000086},null,"fewer open cull sales",null,null,{"$f":"+F14-D14","v":5},"%",{"$f":"L120/100*F10*D30/100*850","v":3931.25}]
[null,"- change in wean rate",null,null,{"$f":"+F18-D18","v":5},"%"]
[]
[null,"Sub-total increased revenue  ( A )",null,null,null,null,{"$f":"SUM(G119:G122)","v":6599.5020000000086},null,"Sub-total decreased revenue  ( C )",null,null,null,null,{"$f":"SUM(N119:N122)","v":5156.125}]
[]
[null,"Decreased costs from proposed change",null,null,"change","units","Total",null,"Increased costs from proposed change",null,null,"change","unit","Total"]
[null,null,null,null,null,null,null,null,"Semen costs",null,null,{"$f":"IF(AND(C6=1,G6=2),BreedingSystems!K54,IF(AND(C6=1,G6=3),BreedingSystems!K55,IF(AND(C6=1,G6=4),BreedingSystems!K56,IF(AND(C6=1,G6=5),BreedingSystems!K57,IF(AND(C6=1,G6=6),BreedingSystems!K58,IF(AND(C6=1,G6=7),BreedingSystems!K59,IF(AND(C6=1,G6=8),BreedingSystems!K60,IF(AND(C6=1,G6=9),BreedingSystems!K61,IF(AND(C6=1,G6=10),BreedingSystems!K62,IF(AND(C6=1,G6=11),BreedingSystems!K63,0))))))))))","v":92},"inseminations",{"$f":"L126*C73","v":2300}]
[null,"Fewer bulls required (reduced cost/bull)",null,null,{"$f":"D13-F13","v":2},"bulls",{"$f":"(E127*((C59/D13)+SUM(C60:C66)+F60+F61+F62))","v":4542.3557304900178},null,"AI technician",null,null,{"$f":"IF(AND(C6=1,G6=2),BreedingSystems!K54,IF(AND(C6=1,G6=3),BreedingSystems!K55,IF(AND(C6=1,G6=4),BreedingSystems!K56,IF(AND(C6=1,G6=5),BreedingSystems!K57,IF(AND(C6=1,G6=6),BreedingSystems!K58,IF(AND(C6=1,G6=7),BreedingSystems!K59,IF(AND(C6=1,G6=8),BreedingSystems!K60,IF(AND(C6=1,G6=9),BreedingSystems!K61,IF(AND(C6=1,G6=10),BreedingSystems!K62,IF(AND(C6=1,G6=11),BreedingSystems!K63,0))))))))))","v":92},"inseminations",{"$f":"L127*C75","v":1150}]
[null,"fewer replacements needed",null,null,{"$f":"((D13/4-F13/4))+((F14-D14)/100*F10)","v":5.5},"bulls + heifers",{"$f":"((D13/4-F13/4)*D33)+((F14-D14)/100*F10*D29/100*800)","v":10380}]
[null,"heat detection labour",null,null,{"$f":"IF(AND(C6=1,G6=2),BreedingSystems!AA35,IF(AND(C6=1,G6=3),BreedingSystems!AB35,IF(AND(C6,G6=4),BreedingSystems!AC35,IF(AND(C6=1,G6=5),BreedingSystems!AD35,IF(AND(C6=1,G6=6),BreedingSystems!AE35,IF(AND(C6=1,G6=7),BreedingSystems!AF35,IF(AND(C6=1,G6=8),BreedingSystems!AG35,IF(AND(C6=1,G6=9),BreedingSystems!AH35,IF(AND(C6=1,G6=10),BreedingSystems!AI35,IF(AND(C6=1,G6=11),BreedingSystems!AJ35,0))))))))))","v":0.06},"hr/cow",{"$f":"-E129*F10*F71","v":-120},null,"labour - AI treatment",null,null,{"$f":"IF(AND(C6=1,G6=2),BreedingSystems!AA50,IF(AND(C6=1,G6=3),BreedingSystems!AB50,IF(AND(C6=1,G6=4),BreedingSystems!AC50,IF(AND(C6=1,G6=5),BreedingSystems!AD50,IF(AND(C6=1,G6=6),BreedingSystems!AE50,IF(AND(C6=1,G6=7),BreedingSystems!AF50,IF(AND(C6=1,G6=8),BreedingSystems!AG50,IF(AND(C6=1,G6=9),BreedingSystems!AH50,IF(AND(C6=1,G6=10),BreedingSystems!AI50,IF(AND(C6=1,G6=11),BreedingSystems!AJ50,0))))))))))","v":0.27},"hr/cow",{"$f":"L129*F71*F10","v":540}]
[null,null,null,null,null,null,null,null,"breeding system treatment cost (drugs)",null,null,{"$f":"IF(AND(C6=1,G6=2),BreedingSystems!Z4,IF(AND(C6=1,G6=3),BreedingSystems!AA4,IF(AND(C6=1,G6=4),BreedingSystems!AB4,IF(AND(C6=1,G6=5),BreedingSystems!AC4,IF(AND(C6=1,G6=6),BreedingSystems!AD4,IF(AND(C6=1,G6=7),BreedingSystems!AE4,IF(AND(C6=1,G6=8),BreedingSystems!AF4,IF(AND(C6=1,G6=9),BreedingSystems!AG4,IF(AND(C6=1,G6=10),BreedingSystems!AH4,IF(AND(C6=1,G6=11),BreedingSystems!AI4,0))))))))))","v":2650},"/herd",{"$f":"+L130","v":2650}]
[null,null,null,null,null,null,null,null,"AI supplies (syringes, etc.)",null,null,{"$f":"(F10*F69*F27)-(D10*D27*F69)","v":100},"/herd",{"$f":"+L131","v":100}]
[null,null,null,null,null,null,null,null,"AI Equipment maintenance",null,null,{"$f":"+F81*F27","v":300},"/herd",300]
[null,null,null,null,null,null,null,null,"Depreciation & interest on AI Equipment",null,null,{"$f":"(((C83-D83)/E81)+(D31/100*((C83+D83)/2)))*F27","v":1662.5},"/herd",1662.5]
[null,"Sub-total Decreased Costs  ( B )",null,null,null,null,{"$f":"SUM(G126:G133)","v":14802.355730490017},null,"Sub-total Increased Costs  ( D )",null,null,null,null,{"$f":"SUM(N126:N133)","v":8702.5}]
[null,"Total Gains  ( A + B = E )",null,null,null,null,{"$f":"G123+G134","v":21401.857730490025},null,"Total Losses  ( C + D = F )",null,null,null,null,{"$f":"N123+N134","v":13858.625}]
[]
[null,null,null,null,null,null,null,null,"Expected Net Gain",null,null,null,null,{"$f":"+G135-N135","v":7543.2327304900246}]
[null,null,null,null,null,null,null,null,null,null,null,null,"per cow",{"$f":"+N137/F10","v":75.432327304900241}]
[]
[null,"Weekly Livestock Market Review - July 20, 2018, Alberta Agriculture and Forestry"]
[null,"1.   Weekly Crop Market Review - July 20, 2018, feed grain bids - feedmills, feedlots, cash grain brokers"]
[null,"2. Central Silage (60% moisture) and straw, April to June AFSC Commodity Prices, 7/18/2018"]
[null,"3. Agriculture and Forestry website: 'What is My Cereal Silage Crop Worth?'  that estimates a multiplier of 12 times the barley price per bushel for the value of a ton of silage \"at the pit\" i.e. harvested and delivered by the grower"]
[null,"4. Central Alfalfa Hay 1st cut, April to June AFSC Commodity Prices, 17/18/2018"]
[null,"5. July estimated price for Blue Salt and mineral blocks (55 lb units) as reported by several commercial feed suppliers.  "]

{"sheet":"BreedingSystems","index":4,"n_rows":64,"n_cols":36,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Breeding system",null,null,null,null,null,null,"System 1",null,null,"Insemination method:",null,null,"Code","Estrus AI:","Code","Estrus AI with Cleanup AI","Code","Fixed-time AI"]
[null,null,null,null,null,null,null,"cows ",{"$f":"Inputs!D10","v":100},null,"estrus AI",null,null,2,"Select Synch",5,"Select Synch +TAI",8,"7-day CO-Synch + CIDR",null,null,null,null," Difference",null,"Treatment costs"]
["Costs of AI:",null,null,"Labour / working",null,null,null,null,null,null,"estrus AI with cleanup AI",null,null,3,"Select Synch +CIDR",6,"Select Synch+CIDR+TAI",9,"5-day CO-Synch + CIDR",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11]
["Cost of prostaglandin/dose",5.25,null,"hours",{"$f":"+#REF!/23","v":{"$error":"#REF!"}},null,null,"System 2",null,null,"fixed-time AI",null,null,4,"PGF2α 6-day CIDR",7,"PGF2α 6 Day CIDR +TAI",10,"7-day Co-synch + CIDR with Estradiol",null,null,null,null,1,0,{"$f":"P11-P59","v":850},{"$f":"P23-P59","v":2650},{"$f":"+P36-P59","v":2752.5},{"$f":"P48-P59","v":654},{"$f":"R11-P59","v":850.69999999999993},{"$f":"R23-P59","v":2720},{"$f":"R36-P59","v":2822.5},{"$f":"T11-P59","v":3000},{"$f":"T23-P59","v":3500},{"$f":"T36-P59","v":2700}]
["Cost of GnRH",3,null,"workers",{"$f":"#REF!/#REF!","v":{"$error":"#REF!"}},null,null,"cows ",{"$f":"Inputs!F10","v":100},null,null,null,null,1,"MGA+PGF2α",null,null,null,null,null,null,null,null,2,null,0,{"$f":"P23-P11","v":1800},{"$f":"P36-P11","v":1902.5},{"$f":"P48-P11","v":-196},{"$f":"R11-P11","v":0.69999999999993179},{"$f":"R23-P11","v":1870},{"$f":"R36-P11","v":1972.5},{"$f":"T11-P11","v":2150},{"$f":"T23-P11","v":2650},{"$f":"T36-P11","v":1850}]
["CIDR",15,null,"wage rate",20,null,null,null,null,null,"Input Costs",null,null,null,"Natural Service",null,null,null,null,null,null,null,null,3,null,null,0,{"$f":"P36-P23","v":102.5},{"$f":"P48-P23","v":-1996},{"$f":"R11-P23","v":-1799.3000000000002},{"$f":"R23-P23","v":70},{"$f":"R36-P23","v":172.5},{"$f":"T11-P23","v":350},{"$f":"T23-P23","v":850},{"$f":"T36-P23","v":50}]
["Cost of pregnancy diagnosis",3,null,null,null,null,null,null,null,null,"Labor costs ($/hr):",null,{"$f":"Inputs!F71","v":20},null,"Select Synch",null,{"$f":"+Q2","v":"Select Synch +TAI"},null,{"$f":"+S2","v":"7-day CO-Synch + CIDR"},null,55,null,null,4,null,null,null,0,{"$f":"P48-P36","v":-2098.5},{"$f":"R11-P36","v":-1901.8000000000002},{"$f":"R23-P36","v":-32.5},{"$f":"R36-P36","v":70},{"$f":"T11-P36","v":247.5},{"$f":"T23-P36","v":747.5},{"$f":"T36-P36","v":-52.5}]
[null,null,"Drugs, Supplies ($)","Required Workings","Materials ($)","Technician ($)","Semen ($)",null,null,null,"PG ($/dose):",null,{"$f":"Inputs!C69","v":5},null,"handling",3,"handling",3,"handling",3,null,null,null,5,null,null,null,null,0,{"$f":"R11-P48","v":196.69999999999993},{"$f":"R23-P48","v":2066},{"$f":"R36-P48","v":2168.5},{"$f":"T11-P48","v":2346},{"$f":"T23-P48","v":2846},{"$f":"T36-P48","v":2046}]
["synchronization (per herd)",null,1250,null,{"$f":"0.92*#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"GnRH ($/dose):",null,{"$f":"Inputs!C70","v":3.5},null,"labour hrs /cow (not HD)",{"$f":"P15+P16","v":0.27999999999999997},"labour hrs",{"$f":"R15+R16","v":0.28899999999999998},"labour hrs",{"$f":"T15+T16","v":0.28999999999999998},null,null,null,6,null,null,null,null,null,0,{"$f":"R23-R11","v":1869.3000000000002},{"$f":"R36-R11","v":1971.8000000000002},{"$f":"T11-R11","v":2149.3000000000002},{"$f":"R11","v":850.69999999999993},{"$f":"R11","v":850.69999999999993}]
["heat detection (per cow)",null,null,1,null,null,null,null,null,null,"CIDR ($/insert):",null,{"$f":"Inputs!C71","v":18},null,"treatment cost/cow",{"$f":"(M9+(M8))","v":8.5},"cost/cow",{"$f":"(M9+M8)+(((1-$J$50)/100)*(M9))","v":8.5069999999999997},"cost/cow",{"$f":"(M9+M10+M8+M9)","v":30},null,null,null,7,null,null,null,null,null,null,0,{"$f":"R36-R23","v":102.5},{"$f":"T11-R23","v":280},{"$f":"T23-R23","v":780},{"$f":"T36-R23","v":-20}]
["1st service (per cow)",null,null,1,null,20,26.6,null,null,null,"Semen ($/unit):",null,{"$f":"Inputs!C73","v":25},null,"total",{"$f":"(P10*I5)","v":850},"total",{"$f":"(R10*I5)","v":850.69999999999993},"total",{"$f":"+T10*I5","v":3000},null,null,null,8,null,null,null,null,null,null,null,0,{"$f":"T11-R36","v":177.5},{"$f":"-R36","v":-2822.5},{"$f":"T36-R36","v":-122.5}]
["2nd service (per cow)",null,null,1,null,20,26.6,null,null,null,"Estradiol",null,{"$f":"+Inputs!C74","v":2},null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,0,{"$f":"T23-T11","v":500},{"$f":"T36-T11","v":-300}]
["3rd service (per cow)",null,null,null,null,null,null,null,null,null,"MGA",null,{"$f":"+Inputs!C76","v":0.11},null,"Cleanup bulls",{"$f":"((1-N39)*I5)/PerformancebySystem!D21","v":2.46},"Cleanup bulls",{"$f":"((1-N43)*I5)/PerformancebySystem!H21","v":2.12},"Cleanup bulls",{"$f":"(I5-(I5*PerformancebySystem!K26/100))/PerformancebySystem!K21","v":1.7999999999999998},null,null,null,10,null,null,null,null,null,null,null,null,null,0,{"$f":"T36-T23","v":-800}]
[null,null,null,null,null,null,null,null,null,null,null,"cows/hr",null,null,"heat detection ",{"$f":"+L22","v":7.0000000000000007E-2},"heat detection ",{"$f":"(4*M27/60*M28)/$I$2","v":0.04},"heat detection ",0,null,null,null,11,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"insert CIDR",{"$f":"Inputs!H69","v":50},null,null,"handling time(2 doses)",{"$f":"(2*I5/L17)/I5","v":0.04},"handling time(3 doses)",{"$f":"((2+(1-K43))*(I5/L17))/I5","v":4.9000000000000002E-2},"handling time(3 doses)",{"$f":"((2*I5/L17)+(I5/L18))/I5","v":0.05}]
[null,null,null,null,null,null,null,null,null,null,"remove CIDR",{"$f":"Inputs!H70","v":100},null,null,"insemination",{"$f":"1/L19","v":0.24},"insemination",{"$f":"1/L19","v":0.24},"insemination",{"$f":"+I5/L19/I5","v":0.24}]
[null,null,null,null,null,null,null,null,null,null,"AI treating",{"$f":"Inputs!H71","v":50},null,null,null,{"$f":"($I$5*$J$39)+((1-$J$39)*$I$5)*$L$39","v":88}]
[null,null,null,null,null,null,null,null,null,"1 time","hormone dosing",{"$f":"Inputs!H72","v":100},null,null,null,null,null,null,null,null,null,null,null,null,"LookUp"]
[null,null,null,null,null,null,null,null,null,null,"Insemination:",{"$f":"25/6","v":4.166666666666667},"/3 hr twice a day",null,{"$f":"+O3","v":"Select Synch +CIDR"},null,{"$f":"+Q3","v":"Select Synch+CIDR+TAI"},null,{"$f":"+S3","v":"5-day CO-Synch + CIDR"},null,60,null,null,null,"Code","Protocol"]
[null,null,null,null,null,null,null,null,null,"Extra Time with HD AI",null,null,null,null,"handling",3,"handling",3,"handling",4,null,null,null,null,1,"Natural Service"]
[null,null,null,null,null,null,null,null,null,"HD based",null,null,null,null,"labour hrs",{"$f":"P27+P28","v":0.27},"labour hrs",{"$f":"R27+R28","v":0.27899999999999997},"labour hrs",{"$f":"T27+T28","v":0.31},null,null,null,null,2,"Select Synch"]
[null,null,null,null,null,null,null,null,null,null,"AI - 7day",{"$f":"(($M$27/60)*$M$28*7)/Inputs!$F$10","v":7.0000000000000007E-2},{"$f":"(1/L$19*$I$5)/$I$5","v":0.24},null,"treatment cost/cow",{"$f":"+(M9+M10+M8)","v":26.5},"cost/cow",{"$f":"+((M9+M10+M8))+((1-J50)*(M9))","v":27.2},"cost/cow",{"$f":"(M9+M10+M8+M8+M9)","v":35},null,null,null,null,3,"Select Synch +CIDR"]
[null,null,null,null,null,null,null,null,null,null,"AI - 6day",{"$f":"(($M$27/60)*$M$28*6)/Inputs!$F$10","v":0.06},{"$f":"($I$5/L19*6)/$I$5","v":1.44},null,"total",{"$f":"(P22*I5)","v":2650},"total",{"$f":"R22*I5","v":2720},"total",{"$f":"+T22*I5","v":3500},null,null,null,null,4,"PG 6-day CIDR"]
[null,null,null,null,null,null,null,null,null,null,"AI - 4day",{"$f":"(($M$27/60)*$M$28*4)/Inputs!$F$10","v":0.04},{"$f":"($I$5/L19*4)/$I$5","v":0.96},null,null,null,null,null,null,null,null,null,null,null,5,"MGA+PG"]
[null,null,null,null,null,null,null,null,null,null,"AI - 3day",{"$f":"(($M$27/60)*$M$28*3)/Inputs!$F$10","v":0.03},{"$f":"($I$5/L19*3)/$I$5","v":0.72},null,"Cleanup bulls",{"$f":"((1-N40)*I5)/PerformancebySystem!E21","v":2.2399999999999998},"Cleanup bulls",{"$f":"((1-N43)*I5)/PerformancebySystem!I21","v":2.12},"Cleanup bulls",{"$f":"((I5-(I5*PerformancebySystem!L26/100))/PerformancebySystem!L21)","v":1.6},null,null,null,null,6,"Select Synch +TAI"]
[null,null,null,null,null,null,null,null,null,null,"natural service",null,"System","target","heat detection ",{"$f":"+L23","v":0.06},"heat detection ",{"$f":"(4*M27/60*M28)/$I$2","v":0.04},"heat detection ",0,null,null,null,null,7,"Select Synch+CIDR+TAI"]
[null,null,null,null,null,null,null,null,"Time spent / observation (min.)",null,{"$f":"Inputs!D21","v":0},null,{"$f":"Inputs!F21","v":30},30,"handling time(2 doses)",{"$f":"((I5/L17)+(I5/L18))/I5","v":0.03},"handling time(3 doses)",{"$f":"((I5/L17)+(I5/L18)+((1-K44)*(I5/L17)))/I5","v":3.9E-2},"handling time(4 doses)",{"$f":"(I5/L17+I5/L18+I5/L17+I5/L17)/I5","v":7.0000000000000007E-2},null,null,null,null,8,"PG 6 Day CIDR +TAI"]
[null,null,null,null,null,null,null,null,"Heat observations /day",null,{"$f":"Inputs!D22","v":0},null,{"$f":"Inputs!F22","v":2},2,"insemination",{"$f":"1/L19","v":0.24},"insemination",{"$f":"1/L19","v":0.24},"insemination",{"$f":"+I5/L19/I5","v":0.24},null,null,null,null,9,"Co-synch_CIDRwithGnRH-7day"]
[null,null,null,null,null,null,null,null,"cycles",null,{"$f":"Inputs!D26","v":3},null,null,null,null,{"$f":"($I$5*$J$40)+((1-$J$40)*$I$5)*$L$40","v":92},null,null,null,null,null,null,null,null,10,"CO-Synch-CIDR-5day"]
[null,null,null,null,null,null,null,null,null,"days/cycle",21,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Co-synch-CIDRwithEstradiol-7day"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+O4","v":"PGF2α 6-day CIDR"},null,{"$f":"+Q4","v":"PGF2α 6 Day CIDR +TAI"},null,{"$f":"S4","v":"7-day Co-synch + CIDR with Estradiol"}]
[null,null,null,null,null,null,null,"non-synchronized",null,null,null,null,null,null,"handling",3,"handling",{"$f":"((1-M45)*I5)/20","v":2.7500000000000004},"handling",4,null,null,null,null," Difference",null,"heat detection"]
[null,null,null,null,null,null,null,null,"1st cycle","2nd cycle","3rd cycle",null,null,null,"labour hrs",{"$f":"P40+P41","v":0.28999999999999998},"labour hrs",{"$f":"R40+R41","v":0.29899999999999999},"labour hrs",{"$f":"T40+T41","v":0.27},null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cost/cow",{"$f":"(M8)+(0.85*(M9+M10+M8))","v":27.524999999999999},"cost/cow",{"$f":"(M8)+(0.85*(M9+M10+M8))+((1-J50)*(M9))","v":28.224999999999998},"cost/cow",{"$f":"(M12*2)+M8+M10","v":27},null,null,null,null,1,null,{"$f":"P14-P62","v":7.0000000000000007E-2},{"$f":"P26-P62","v":0.06},{"$f":"P39-P62","v":0.06},{"$f":"P51-P62","v":0.06},{"$f":"R14-P62","v":0.04},{"$f":"R26-P62","v":0.04},{"$f":"R39-P62","v":0.06},{"$f":"T14-P62","v":0},{"$f":"T26-P62","v":0},{"$f":"T39-P62","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total",{"$f":"+P35*I5","v":2752.5},"total",{"$f":"(R35*I5)","v":2822.5},"total",{"$f":"+T35*I5","v":2700},null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Early Estrus","CR","Remaining Estrus","CR","Preg",null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,1,{"$f":"Inputs!R99","v":"Natural Service"},null,null,null,null,null,"Cleanup bulls",{"$f":"+((1-N41)*I5)/PerformancebySystem!F21","v":2.2399999999999998},"Cleanup bulls",{"$f":"((1-N45)*I5)/PerformancebySystem!J21","v":1.92},"Cleanup bulls",{"$f":"(I5-(I5*PerformancebySystem!M26/100))/PerformancebySystem!M21","v":1.7200000000000002},null,null,null,null,4]
[null,null,null,null,null,null,null,2,{"$f":"Inputs!R100","v":"Select Synch"},0.7,0.55000000000000004,0.6,{"$f":"L39*K39","v":0.33},{"$f":"K39*J39","v":0.38500000000000001},"heat detection ",{"$f":"+L23","v":0.06},"heat detection ",{"$f":"(6*M27/60*M28)/$I$2","v":0.06},"heat detection ",0,null,null,null,null,5]
[null,null,null,null,null,null,null,3,{"$f":"Inputs!R101","v":"Select Synch +CIDR"},0.8,0.55000000000000004,0.6,{"$f":"L40*K40","v":0.33},{"$f":"J40*K40","v":0.44000000000000006},"handling time(3 doses)",{"$f":"((I5/L17)+(I5/L17)+(I5/L18))/I5","v":0.05},"handling time(3 doses)",{"$f":"(((2+(1-K45))*I5/L17)+(I5/L18))/I5","v":5.9000000000000004E-2},"handling time(2 doses)",{"$f":"((I5/L17)+(I5/L16))/I5","v":0.03},null,null,null,null,6]
[null,null,null,null,null,null,null,4,{"$f":"Inputs!R102","v":"PG 6-day CIDR"},0.8,0.55000000000000004,0.6,{"$f":"L41*K41","v":0.33},{"$f":"J41*K41","v":0.44000000000000006},"insemination",{"$f":"1/L19","v":0.24},"insemination",{"$f":"1/L19","v":0.24},"insemination",{"$f":"I5/L19/I5","v":0.24},null,null,null,null,7]
[null,null,null,null,null,null,null,5,{"$f":"Inputs!R103","v":"MGA+PG"},0.8,0.6,0.6,{"$f":"L42*K42","v":0.36},0.48,null,{"$f":"($I$5*$J$41)+((1-$J$41)*$I$5)*$L$41","v":92},null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,6,{"$f":"Inputs!R104","v":"Select Synch + TAI"},0.6,0.55000000000000004,{"$f":"1-J43","v":0.4},0.35,{"$f":"(J43*K43)+(L43*M43)","v":0.47},null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,7,{"$f":"Inputs!R105","v":"Select Synch + CIDR + TAI"},0.65,0.55000000000000004,{"$f":"1-J44","v":0.35},0.4,{"$f":"(J44*K44)+(L44*M44)","v":0.49750000000000005},{"$f":"+O5","v":"MGA+PGF2α"},null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,8,{"$f":"Inputs!R106","v":"PG 6 Day CIDR + TAI"},0.7,0.55000000000000004,{"$f":"1-J45","v":0.30000000000000004},0.45,{"$f":"(J45*K45)+(L45*M45)","v":0.52},"handling",4,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,9,{"$f":"Inputs!R107","v":"7 day Co-Synch + CIDR"},null,null,null,null,0.55000000000000004,"labour hrs",{"$f":"P52+P53","v":0.26}]
[null,null,null,null,null,null,null,10,{"$f":"Inputs!R108","v":"5 day Co-Synch + CIDR"},null,null,null,null,0.6,"cost/cow",{"$f":"(M13*14)+M8","v":6.54}]
[null,null,null,null,null,null,null,11,{"$f":"Inputs!R109","v":"7 day Estradiol + CIDR"},null,null,null,null,0.56999999999999995,"total",{"$f":"+P47*I5","v":654},null,null,null,null,null,null,null,null," Difference",null,"AI treatment labour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,null,null,null,"Prod. HD",{"$f":"Inputs!F24","v":0.8},null,null,null,null,"Cleanup bulls",{"$f":"+((1-N42)*I5)/PerformancebySystem!G21","v":2.08},null,null,null,null,null,null,null,null,1,null,{"$f":"P9-P57","v":0.27999999999999997},{"$f":"P21-P57","v":0.27},{"$f":"P34-P57","v":0.28999999999999998},{"$f":"P46-P57","v":0.26},{"$f":"R9-P57","v":0.28899999999999998},{"$f":"R21-P57","v":0.27899999999999997},{"$f":"R34-P57","v":0.29899999999999999},{"$f":"T9-P57","v":0.28999999999999998},{"$f":"T21-P57","v":0.31},{"$f":"T34-P57","v":0.27}]
[null,null,null,null,null,null,null,null,"Prod. CR",{"$f":"Inputs!F25","v":0.55000000000000004},null,null,null,null,"heat detection ",{"$f":"+L23","v":0.06},null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,"semen use",null,null,null,null,null,"handling time(1 dose)",{"$f":"(I5/(L17))/I5","v":0.02},null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,1,"Natural Service",null,null,null,null,null,"insemination",{"$f":"1/L19","v":0.24},null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,2,"Select Synch",null,{"$f":"($I$5*J39)+(($I$5-($I5*J39))*L39)","v":88},{"$f":"($I$5*J39)+(($I$5-($I5*J39))*L39)","v":88},null,null,null,{"$f":"($I$5*$J$42)+((1-$J$42)*$I$5)*$L$42","v":92},null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,3,"Select Synch +CIDR",null,{"$f":"($I$5*J40)+(($I$5-($I$5*J40))*L40)","v":92},{"$f":"($I$5*J40)+(($I$5-($I5*J40))*L40)","v":92},null,null,{"$f":"O6","v":"Natural Service"},null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,4,"PG 6-day CIDR",null,{"$f":"($I$5*J41)+(($I$5-($I$5*J41))*L41)","v":92},{"$f":"($I$5*J41)+(($I$5-($I5*J41))*L41)","v":92},null,null,"handling",0,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,5,"MGA+PG",null,{"$f":"($I$5*J42)+(($I$5-($I$5*J42))*L42)","v":92},{"$f":"($I$5*J42)+(($I$5-($I5*J42))*L42)","v":92},null,null,"labour hrs",{"$f":"P63+P64","v":0},null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,6,"Select Synch +TAI",null,{"$f":"$I$5","v":100},{"$f":"$I$5","v":100},null,null,"cost/cow",0,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,7,"Select Synch+CIDR+TAI",null,100,100,null,null,"total",{"$f":"P58*I2","v":0},null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,8,"PG 6 Day CIDR +TAI",null,100,100,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,9,"Co-synch_CIDR with GnRH-7day",null,100,100,null,null,"Cleanup bulls"]
[null,null,null,null,null,null,null,10,"CO-Synch-CIDR-5day",null,100,100,null,null,"heat detection ",{"$f":"((K27/60)*K28*K29*K30)/Inputs!D10","v":0}]
[null,null,null,null,null,null,null,11,"Co-synch-CIDR with Estradiol-7day",null,100,100,null,null,"handling time(3 doses)",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"insemination",0]

{"sheet":"PerformancebySystem","index":5,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[17,3,17,7],[17,8,17,10],[17,11,17,13],[35,2,38,2]]}
[]
[]
[null,"Code","Protocol"]
[null,1,{"$f":"Inputs!R99","v":"Natural Service"}]
[null,2,"Select Synch"]
[null,3,"Select Synch +CIDR"]
[null,4,"PG 6-day CIDR"]
[null,5,"MGA+PG"]
[null,6,"Select Synch +TAI"]
[null,7,"Select Synch+CIDR+TAI"]
[null,8,"PG 6 Day CIDR +TAI"]
[null,9,"Co-synch_CIDR with GnRH-7day"]
[null,10,"CO-Synch-CIDR-5day"]
[null,11,"Co-synch-CIDR with Estradiol-7day"]
[]
[]
[]
[null,null,null,"Estrus Detection",null,null,null,null,"Estrus AI with Cleanup AI",null,null,"Fixed-time AI"]
[null,null,{"$f":"+C4","v":"Natural Service"},{"$f":"Inputs!R100","v":"Select Synch"},{"$f":"Inputs!R101","v":"Select Synch +CIDR"},{"$f":"Inputs!R102","v":"PG 6-day CIDR"},{"$f":"Inputs!R103","v":"MGA+PG"},{"$f":"Inputs!R104","v":"Select Synch + TAI"},{"$f":"Inputs!R105","v":"Select Synch + CIDR + TAI"},{"$f":"Inputs!R106","v":"PG 6 Day CIDR + TAI"},{"$f":"Inputs!R107","v":"7 day Co-Synch + CIDR"},{"$f":"Inputs!R108","v":"5 day Co-Synch + CIDR"},{"$f":"Inputs!R109","v":"7 day Estradiol + CIDR"}]
[null,"cows",{"$f":"Inputs!D10","v":100},{"$f":"C20","v":100},{"$f":"D20","v":100},100,100,100,100,100,100,100,100]
[null,"cows/bull",{"$f":"Inputs!D11","v":25},25,25,25,25,25,25,25,25,25,25]
[null,"Breeding season days",83,60,60,60,60,60,60,60,60,60,60]
[null,"Bulls needed",{"$f":"C20/C21","v":4},{"$f":"ROUND(BreedingSystems!P13,0)","v":2},{"$f":"ROUND(BreedingSystems!P25,0)","v":2},{"$f":"ROUND(BreedingSystems!P38,0)","v":2},{"$f":"ROUND(BreedingSystems!P50,0)","v":2},{"$f":"ROUND(BreedingSystems!R13,0)","v":2},{"$f":"ROUND(BreedingSystems!R25,0)","v":2},{"$f":"ROUND(BreedingSystems!R38,0)","v":2},{"$f":"ROUND((K20-(K20*K26/100))/K21,0)","v":2},2,2]
[null,"heat detection",0,{"$f":"BreedingSystems!J39","v":0.7},{"$f":"BreedingSystems!J40","v":0.8},{"$f":"BreedingSystems!J41","v":0.8},{"$f":"BreedingSystems!J42","v":0.8},{"$f":"BreedingSystems!J43","v":0.6},{"$f":"BreedingSystems!J44","v":0.65},{"$f":"BreedingSystems!J45","v":0.7},0,0,0]
[null,"conception rate",null,{"$f":"BreedingSystems!K39","v":0.55000000000000004},{"$f":"BreedingSystems!K40","v":0.55000000000000004},{"$f":"BreedingSystems!K41","v":0.55000000000000004},{"$f":"BreedingSystems!K42","v":0.6},{"$f":"BreedingSystems!K43","v":0.55000000000000004},{"$f":"BreedingSystems!K44","v":0.55000000000000004},{"$f":"BreedingSystems!K45","v":0.55000000000000004}]
[null,"pregnancy rate to AI",0,{"$f":"+BreedingSystems!N39*100","v":38.5},{"$f":"+BreedingSystems!N40*100","v":44.000000000000007},{"$f":"+BreedingSystems!N41*100","v":44.000000000000007},{"$f":"+BreedingSystems!N42*100","v":48},{"$f":"+BreedingSystems!N43*100","v":47},{"$f":"+BreedingSystems!N44*100","v":49.750000000000007},{"$f":"+BreedingSystems!N45*100","v":52},{"$f":"BreedingSystems!N46*100","v":55.000000000000007},{"$f":"BreedingSystems!N47*100","v":60},{"$f":"BreedingSystems!N48*100","v":56.999999999999993}]
[null,"End of season pregnancy rate*",90,90,95,95,95,90,95,95,95,95,95]
[null,"heat detection efficiency (where AI is used)"]
[null,"Percent calving rate*",88,88,93,{"$f":"E29","v":93},{"$f":"E29","v":93},88,93,{"$f":"I29","v":93},{"$f":"I29","v":93},{"$f":"I29","v":93},{"$f":"I29","v":93}]
[null,"Calf birth wt,lbs*",85,85,85,85,85,85,85,85,85,85,85]
[null,"calving span, days*",93,64,64,64,64,64,64,64,64,64,64]
[null,"calf crop, %*",{"$f":"Inputs!D18","v":84},84,{"$f":"D32+5","v":89},{"$f":"E32","v":89},{"$f":"F32","v":89},{"$f":"D32","v":84},{"$f":"H32+5","v":89},{"$f":"I32","v":89},{"$f":"I32","v":89},{"$f":"I32","v":89},{"$f":"I32","v":89}]
[null,"Calf 205-d adjusted weaning wt",{"$f":"Inputs!D19","v":488},{"$f":"D36","v":495.72171400000002},{"$f":"E36","v":496.824816},496.824816,497.627072,497.42650800000001,497.97805900000003,498.429328,499.03102000000001,500.03384,499.43214799999998]
[null,null,null,"205-d WW = (((WW – actual BW) / wean age, days) x 205) + actual BW"]
[null,null,null,{"$f":"(D33-$C$33)/2.204","v":3.5035000000000087},4.0039999999999987,4.0039999999999987,4.3679999999999986,4.2770000000000055,4.5272500000000138,4.7319999999999984,5.0050000000000052,5.4599999999999982,5.1869999999999923]
[null,null,null,{"$f":"$C$33+((D26)/100*9.1*2.204)","v":495.72171400000002},{"$f":"$C$33+((E26)/100*9.1*2.204)","v":496.824816},496.824816,497.627072,497.42650800000001,497.97805900000003,498.429328,499.03102000000001,500.03384,499.43214799999998]
[null,{"$f":"159/187","v":0.85026737967914434}]
[null,{"$f":"181/214","v":0.84579439252336452},null,{"$f":"D27/100*D29/100","v":0.79200000000000004},0.88349999999999995,0.88349999999999995,0.88349999999999995,0.79200000000000004,0.88349999999999995,0.88349999999999995,0.88349999999999995,0.88349999999999995,0.88349999999999995]
[null,{"$f":"153/187","v":0.81818181818181823}]
[null,{"$f":"153/187","v":0.81818181818181823},null,null,{"$f":"E32-D32","v":5}]
[null,{"$f":"207/247","v":0.83805668016194335}]

{"sheet":"Sheet1","index":6,"n_rows":90,"n_cols":32,"rows_kept":90,"cut":false,"hidden":true,"merged":[[78,22,80,23],[78,26,80,26],[79,25,80,25],[79,27,80,27],[70,27,73,27],[71,25,73,25],[70,22,73,22],[70,26,73,26],[73,1,75,9],[76,4,77,4],[76,5,77,5],[76,6,77,6],[56,1,58,9],[59,5,61,5],[59,6,61,6],[60,8,61,8],[45,27,46,27],[52,22,54,27],[55,22,57,22],[55,25,57,25],[55,26,57,26],[55,27,57,27],[44,26,46,26],[43,22,45,24],[36,26,37,26],[44,1,46,1],[44,2,46,2],[44,3,46,3],[44,4,46,4],[44,5,46,5],[27,22,29,23],[28,26,29,26],[30,1,32,1],[30,2,32,2],[30,3,32,3],[30,4,32,4],[30,5,32,5],[30,6,32,6],[30,7,32,7],[30,8,32,8],[30,9,32,9],[30,11,32,11],[31,13,32,13],[31,14,32,14],[18,7,18,8],[18,22,20,25],[19,7,19,8],[19,26,20,26],[21,1,23,1],[21,2,23,2],[21,3,23,3],[21,4,23,4],[21,5,23,5],[21,6,23,6],[0,1,0,9],[0,22,0,27],[1,1,3,3],[1,22,3,26],[10,22,12,23],[11,1,13,1],[11,26,12,26]]}
[null,"Natural Service Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AI Costs"]
[null,"GENERAL: Natural Service Only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GENERAL: AI and  cleanup natural service"]
[]
[]
[null,"Number of cows in the herd",null,100,"head",{"$f":"IF(NatPregRate=0,\"\",IF(NatWeanRate>NatPregRate,\"WARNING: Calving Rate is greater than End of Season Pregnancy Rate\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of cows in the herd",null,{"$f":"HerdSize","v":100},"head"]
[null,"Bulls needed",null,4,"head",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clean-up Bulls needed",null,1,"head",{"$f":"IF(AISystemPregRate=0,\"\",IF(AIWeanRate>AISystemPregRate,\"WARNING: Weaning Rate is greater than Pregnancy Rate\",\"\"))","v":""}]
[null,"End of season pregnancy rate",null,93,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End of season pregnancy rate",null,95,"%"]
[null,"Percent calf crop",null,93,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent calf crop",null,94,"%"]
[null,"Interest rate",null,5,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wage rate for AI activities",null,12,"$ / Hr"]
[null,"Calf value",null,900,"$ / head"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYNCHRONIZATION",null,null,null,null,null,null,"head","all cows","non-bred cow"]
[null,"BULL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per Cow per Year",null,null,"bull","all bulls"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor",10,"hours per","all cows",{"$f":"IF(HerdSize=0,0,X14*WageRate/IF(Z14=\"all cows\",HerdSize,1))","v":1.2}]
[null,"Bull cost (including delivery)",null,3500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drugs, CIDR, supplies",1250,"dollars per","all cows",{"$f":"IF(HerdSize=0,0,X15/IF(Z15=\"all cows\",HerdSize,1))","v":12.5}]
[null,"Average years bulls used",null,4,"years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dollars per","all cows",{"$f":"IF(HerdSize=0,0,X16/IF(Z16=\"all cows\",HerdSize,1))","v":0}]
[null,"Bad bull loss",null,5,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dollars per","all cows",{"$f":"IF(HerdSize=0,0,X17/IF(Z17=\"all cows\",HerdSize,1))","v":0}]
[null,"Bull death loss",null,2,"%"]
[null,"Cull bull sale weight",null,2050,"pounds",null,"Cull Value",{"$f":"D19*D20/100","v":2316.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEAT DETECTION (for all breeding periods)"]
[null,"Cull bull sale price",null,113,"$/cwt",null,"Average Value",{"$f":"(D15+H19)/2","v":2908.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per Cow per Year"]
[]
[null,"GRAZING COST              (per bull)","Time","Period","Price","per Period","per Bull per year",null,null,null,null,"Days","$ / Day","Total $",null,null,null,null,null,null,null,null,"Labour",0.5,"hours per","head",{"$f":"IF(HerdSize=0,0,X22*WageRate/IF(Z22=\"all cows\",HerdSize,1))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dollars per","head",{"$f":"IF(HerdSize=0,0,X23/IF(Z23=\"all cows\",HerdSize,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dollars per","head",{"$f":"IF(HerdSize=0,0,X24/IF(Z24=\"all cows\",HerdSize,1))","v":0}]
[null,"Growing season",180,"days",30,"per month",{"$f":"L25*M25","v":177.53424657534245},null,null,null,null,{"$f":"ROUND(C25*IF(D25=\"days\",1,IF(D25=\"months\",365/12,IF(D25=\"year\",365,0))),0)","v":180},{"$f":"IFERROR(E25/IF(F25=\"per day\",1,IF(F25=\"per month\",365/12,IF(F25=\"per year\",365,0))),0)","v":0.98630136986301364},{"$f":"L25*M25*NatBulls","v":710.1369863013698},null,null,null,"days","months","year",null,null,null,null,"dollars per","head",{"$f":"IF(HerdSize=0,0,X25/IF(Z25=\"all cows\",HerdSize,1))","v":0}]
[null,"Dormant season",null,null,null,"per year",{"$f":"L26*M26","v":0},null,null,null,null,{"$f":"ROUND(C26*IF(D26=\"days\",1,IF(D26=\"months\",365/12,IF(D26=\"year\",365,0))),0)","v":0},{"$f":"IFERROR(E26/IF(F26=\"per day\",1,IF(F26=\"per month\",365/12,IF(F26=\"per year\",365,0))),0)","v":0},{"$f":"L26*M26*NatBulls","v":0},null,null,null,"per day","per month","per year",null,null,null,null,"dollars per","head",{"$f":"IF(HerdSize=0,0,X26/IF(Z26=\"all cows\",HerdSize,1))","v":0}]
[null,null,null,"months",null,"per month",{"$f":"L27*M27","v":0},null,null,null,null,{"$f":"ROUND(C27*IF(D27=\"days\",1,IF(D27=\"months\",365/12,IF(D27=\"year\",365,0))),0)","v":0},{"$f":"IFERROR(E27/IF(F27=\"per day\",1,IF(F27=\"per month\",365/12,IF(F27=\"per year\",365,0))),0)","v":0},{"$f":"L27*M27*NatBulls","v":0}]
[null,null,null,null,null,"per day",{"$f":"L28*M28","v":0},null,null,null,null,{"$f":"ROUND(C28*IF(D28=\"days\",1,IF(D28=\"months\",365/12,IF(D28=\"year\",365,0))),0)","v":0},{"$f":"IFERROR(E28/IF(F28=\"per day\",1,IF(F28=\"per month\",365/12,IF(F28=\"per year\",365,0))),0)","v":0},{"$f":"L28*M28*NatBulls","v":0},null,null,null,null,null,null,null,null,"FIRST SERVICE"]
[null,null,null,null,null,"per day",{"$f":"L29*M29","v":0},null,null,null,null,{"$f":"ROUND(C29*IF(D29=\"days\",1,IF(D29=\"months\",365/12,IF(D29=\"year\",365,0))),0)","v":0},{"$f":"IFERROR(E29/IF(F29=\"per day\",1,IF(F29=\"per month\",365/12,IF(F29=\"per year\",365,0))),0)","v":0},{"$f":"L29*M29*NatBulls","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"per Cow per Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Grazing",{"$f":"SUM(N25:N29)","v":710.1369863013698},null,null,null,"per pound","per cwt","per ton","per bushel","total"]
[null,"OTHER FEED COST","Amount","Measure","Per Head or Total","Time","Period","Price","per Unit","per Bull per year",null,"Pounds per Bull per Day",null,null,null,null,null,"pounds","cwt","tons","bushel","total","Labour",8,"hours per","all cows",{"$f":"IF(HerdSize=0,0,X31*WageRate/IF(Z31=\"all cows\",HerdSize,1))","v":0.96}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Price per Pound","Herd Total",null,null,null,null,null,null,null,"Materials",2,"dollars per","head",{"$f":"IF(HerdSize=0,0,X32/IF(Z32=\"all cows\",HerdSize,1))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Days",null,null,null,null,null,null,null,null,null,"Technician",15,"dollars per","head",{"$f":"IF(HerdSize=0,0,X33/IF(Z33=\"all cows\",HerdSize,1))","v":15}]
[null,"Hay",45,"pounds","per head",212,"days",115,"per ton",{"$f":"N34*M34*L34","v":548.55000000000007},null,{"$f":"C34*IF(D34=\"bushel\",U34,IF(D34=\"tons\",2000,IF(D34=\"cwt\",100,IF(D34=\"pounds\",1,0))))*IF(E34=\"per head\",1,IF(E34=\"total\",1/NatBulls,0))*IF(G34=\"days\",1,IF(G34=\"months\",12/365,IF(G34=\"year\",1/365,0)))","v":45},{"$f":"F34*IF(G34=\"days\",1,IF(G34=\"months\",365/12,IF(G34=\"year\",365,0)))","v":212},{"$f":"H34/IF(I34=\"per pound\",1,IF(I34=\"per ton\",2000,IF(I34=\"per cwt\",100,IF(I34=\"per bushel\",U34,IF(I34=\"total\",O34,\"Calc Error\")))))","v":5.7500000000000002E-2},{"$f":"J34*NatBulls","v":2194.2000000000003},null,null,"per head","total",null,56,null,"Semen",20,"dollars per","head",{"$f":"IF(HerdSize=0,0,X34/IF(Z34=\"all cows\",HerdSize,1))","v":20}]
[null,"Supplement",60,"pounds","total",3,"months",70,"per ton",{"$f":"N35*M35*L35","v":1.575},null,0.49315068493150682,91.25,3.5000000000000003E-2,6.3,null,null,null,null,null,56,null,null,null,null,"Cows Bred after First Service",60,"%"]
[null,"Salt and Mineral",60,"pounds","total",1,"year",120,"per ton",0.89999999999999991,null,4.1095890410958902E-2,365,0.06,3.5999999999999996,null,null,null,null,null,56,null,"SECOND SERVICE"]
[null,"barley grain",7,"pounds","per head",120,"days",{"$f":"(3.25*48)/1.102","v":141.56079854809437},"per ton",59.455535390199628,null,7,120,7.0780399274047182E-2,237.82214156079851,null,null,null,null,null,56,null,null,null,null,null,"per Cow per Year"]
[null,null,null,null,null,null,null,null,"per pound",0,null,0,0,0,0,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,"per pound",0,null,0,0,0,0,null,null,null,null,null,56,null,"Labour",5,"hours per","all cows",{"$f":"IF(HerdSize=0,0,X39*WageRate*IF(Z39=\"all cows\",1,IF(Z39=\"non-bred cow\",(1-FirstAIPregRate/100)*HerdSize,HerdSize))/HerdSize)","v":0.6}]
[null,null,null,null,null,null,null,null,"per pound",0,null,0,0,0,0,null,null,null,null,null,56,null,"Materials",2,"dollars per","non-bred cow",{"$f":"IF(HerdSize=0,0,X40*IF(Z40=\"all cows\",1,IF(Z40=\"non-bred cow\",HerdSize*(1-FirstAIPregRate/100),HerdSize))/HerdSize)","v":0.8}]
[null,null,null,null,null,null,null,null,"per pound",0,null,0,0,0,0,null,null,null,null,null,56,null,"Technician",15,"dollars per","non-bred cow",{"$f":"IF(HerdSize=0,0,X41*IF(Z41=\"all cows\",1,IF(Z41=\"non-bred cow\",HerdSize*(1-FirstAIPregRate/100),HerdSize))/HerdSize)","v":6},null,null,{"$f":"IF(SecondAIPregRate=0,IF(FirstAIPregRate=0,0,FirstAIPregRate),SecondAIPregRate)","v":80}]
[null,null,null,null,null,null,null,null,"per pound",0,null,0,0,0,0,null,null,null,null,null,56,null,"Semen",20,"dollars per","non-bred cow",{"$f":"IF(HerdSize=0,0,X42*IF(Z42=\"all cows\",1,IF(Z42=\"non-bred cow\",HerdSize*(1-FirstAIPregRate/100),HerdSize))/HerdSize)","v":8},null,{"$f":"IF(SecondAIPregRate=0,\"\",IF(FirstAIPregRate>SecondAIPregRate,\"COWS BRED AFTER 2ND SERVICE INCLUDES THOSE BRED IN 1ST SERVICE SO THIS VALUE MUST BE HIGHER THAN 1ST SERVICE\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,"per ton",0,null,0,0,0,0,null,null,null,null,null,56,null,null,null,null,"Total Cows Bred in First and Second Service",80,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AI EQUIPMENT AND FACILITIES"]
[null,"OTHER COST","Amount","Per Head or Total","One Time or Annually","per Bull per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Maint-enance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per Cow per Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Description","Beg. Value","End Value","Life"]
[null,"Labour and management",2000,"total","annually",{"$f":"IFERROR(IF(D48=\"total\",C48/NatBulls,C48)/IF(E48=\"one time\",$D$16,1),0)","v":500},null,null,null,null,null,null,"Herd Total",null,null,null,null,"one time","annually",null,null,null,"AI Corrals and Chutes",20000,5000,15,300,{"$f":"IF(HerdSize=0,0,IF(Z48=0,0,(X48-Y48)/Z48/HerdSize))","v":10}]
[null,"Marketing culls",50,"per head","one time",12.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nitrogen Tank",500,200,15,null,{"$f":"IF(HerdSize=0,0,IF(Z49=0,0,(X49-Y49)/Z49/HerdSize))","v":0.2}]
[null,"Insurance",4.75,"per head","annually",{"$f":"IFERROR(IF(D50=\"total\",C50/NatBulls,C50)/IF(E50=\"one time\",$D$16,1),0)","v":4.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(HerdSize=0,0,IF(Z50=0,0,(X50-Y50)/Z50/HerdSize))","v":0}]
[null,"Veterinarian",50,"per head","one time",12.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(HerdSize=0,0,IF(Z51=0,0,(X51-Y51)/Z51/HerdSize))","v":0}]
[null,"Miscellaneous",6.5,"per head","annually",6.5]
[null,"Building Costs",3.5,"per head","annually",3.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BREEDING COST SUMMARY (Per Year)"]
[null,"bedding - straw",30,"per head","annually",30]
[null,null,null,null,null,{"$f":"IFERROR(IF(D55=\"total\",C55/NatBulls,C55)/IF(E55=\"one time\",$D$16,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AI",null,null,"per Cow Inseminated","per Cow Bred Using AI"]
[null,"BULL COST SUMMARY (Per Year)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Herd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sychronization",null,{"$f":"IF(HerdSize=0,0,Z59*HerdSize)","v":1370},{"$f":"SUM(AA14:AA17)","v":13.7},{"$f":"IF(AIPregRate=0,0,Z59/(AIPregRate/100))","v":17.124999999999996}]
[null,null,null,null,null,"per Cow in the Herd","per Pregnant Cow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat Detection",null,{"$f":"IF(HerdSize=0,0,Z60*HerdSize)","v":600},{"$f":"SUM(AA22:AA26)","v":6},{"$f":"IF(AIPregRate=0,0,Z60/(AIPregRate/100))","v":7.5}]
[null,null,null,null,null,null,null,null,"per Calf Produced"]
[null,null,null,"All Bulls","per Bull"]
[null,"Annual Purchases Minus Culls",null,{"$f":"E63*$D$6","v":1183.5},{"$f":"(D15-H19)/D16","v":295.875},{"$f":"IF(HerdSize=0,0,D63/HerdSize)","v":11.835000000000001},{"$f":"IF(HerdSize=0,0,IF(NatPregRate=0,0,D63/(HerdSize*NatPregRate/100)))","v":12.725806451612904},null,{"$f":"IF(HerdSize=0,0,IF(NatWeanRate=0,0,D63/(HerdSize*NatWeanRate/100)))","v":12.725806451612904},null,null,null,null,null,null,null,null,null,null,null,null,null,"AI Service",null,{"$f":"IF(HerdSize=0,0,Z63*HerdSize)","v":5336},{"$f":"SUM(AA39:AA42,AA31:AA34)","v":53.36},{"$f":"IF(AIPregRate=0,0,Z63/(AIPregRate/100))","v":66.699999999999989}]
[null,"Injury Loss",null,{"$f":"E64*$D$6","v":118.35},{"$f":"D17*(H20-H19)/100","v":29.587499999999999},{"$f":"IF(HerdSize=0,0,D64/HerdSize)","v":1.1835},{"$f":"IF(HerdSize=0,0,IF(NatPregRate=0,0,D64/(HerdSize*NatPregRate/100)))","v":1.2725806451612902},null,{"$f":"IF(HerdSize=0,0,IF(NatWeanRate=0,0,D64/(HerdSize*NatWeanRate/100)))","v":1.2725806451612902},null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment and Facilities",null,{"$f":"IF(HerdSize=0,0,Z64*HerdSize)","v":300},{"$f":"IF(HerdSize=0,0,SUM(AA48:AA51)/HerdSize)","v":3},{"$f":"IF(AIPregRate=0,0,Z64/(AIPregRate/100))","v":3.75}]
[null,"Death Loss",null,{"$f":"E65*$D$6","v":232.66},{"$f":"D18*H20/100","v":58.164999999999999},{"$f":"IF(HerdSize=0,0,D65/HerdSize)","v":2.3266},{"$f":"IF(HerdSize=0,0,IF(NatPregRate=0,0,D65/(HerdSize*NatPregRate/100)))","v":2.5017204301075266},null,{"$f":"IF(HerdSize=0,0,IF(NatWeanRate=0,0,D65/(HerdSize*NatWeanRate/100)))","v":2.5017204301075266},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cash",null,{"$f":"SUM(Y59:Y64)","v":7606},{"$f":"IF(HerdSize=0,0,SUM(Z59:Z64))","v":76.06},{"$f":"IF(AIPregRate=0,0,Z65/(AIPregRate/100))","v":95.075000000000003}]
[null,"Feed",null,{"$f":"E66*$D$6","v":3152.0591278621687},{"$f":"SUM(G25:G29,J34:J43)","v":788.01478196554217},{"$f":"IF(HerdSize=0,0,D66/HerdSize)","v":31.520591278621687},{"$f":"IF(HerdSize=0,0,IF(NatPregRate=0,0,D66/(HerdSize*NatPregRate/100)))","v":33.893108901743751},null,{"$f":"IF(HerdSize=0,0,IF(NatWeanRate=0,0,D66/(HerdSize*NatWeanRate/100)))","v":33.893108901743751}]
[null,"Other Cash",null,{"$f":"E67*$D$6","v":2279},{"$f":"SUM(F48:F55)","v":569.75},{"$f":"IF(HerdSize=0,0,D67/HerdSize)","v":22.79},{"$f":"IF(HerdSize=0,0,IF(NatPregRate=0,0,D67/(HerdSize*NatPregRate/100)))","v":24.50537634408602},null,{"$f":"IF(HerdSize=0,0,IF(NatWeanRate=0,0,D67/(HerdSize*NatWeanRate/100)))","v":24.50537634408602},null,null,null,null,null,null,null,null,null,null,null,null,null,"Depreciation on Equipment and Facilities",null,{"$f":"IF(HerdSize=0,0,Z67*HerdSize)","v":1019.9999999999999},{"$f":"SUM(AB48:AB51)","v":10.199999999999999},{"$f":"IF(AIPregRate=0,0,Z67/(AIPregRate/100))","v":12.749999999999998}]
[null,null,"Total Cash",{"$f":"SUM(D63:D67)","v":6965.5691278621689},{"$f":"SUM(E63:E67)","v":1741.3922819655422},{"$f":"SUM(F63:F67)","v":69.655691278621688},{"$f":"SUM(G63:G67)","v":74.898592772711496},null,{"$f":"SUM(I63:I67)","v":74.898592772711496},null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest on AI Equipment Investment",null,{"$f":"InterestRate/100*(SUM(X48:X51)+SUM(Y48:Y51))/2","v":642.5},{"$f":"IF(HerdSize=0,0,Y68/HerdSize)","v":6.4249999999999998},{"$f":"IF(AIPregRate=0,0,Z68/(AIPregRate/100))","v":8.03125}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"Y65+SUM(Y67:Y68)","v":9268.5},{"$f":"SUM(Z65:Z68)","v":92.685000000000002},{"$f":"IF(AIPregRate=0,0,Z69/(AIPregRate/100))","v":115.85625}]
[null,"Interest on Investment",null,{"$f":"E70*$D$6","v":581.65},{"$f":"H20*InterestRate/100","v":145.41249999999999},{"$f":"IF(HerdSize=0,0,D70/HerdSize)","v":5.8164999999999996},{"$f":"IF(HerdSize=0,0,IF(NatPregRate=0,0,D70/(HerdSize*NatPregRate/100)))","v":6.2543010752688168},null,{"$f":"IF(HerdSize=0,0,IF(NatWeanRate=0,0,D70/(HerdSize*NatWeanRate/100)))","v":6.2543010752688168}]
[null,null,"Total",{"$f":"D68+D70","v":7547.2191278621685},{"$f":"E68+E70","v":1886.8047819655421},{"$f":"F68+F70","v":75.472191278621693},{"$f":"G68+G70","v":81.152893847980309},null,{"$f":"I68+I70","v":81.152893847980309},null,null,null,null,null,null,null,null,null,null,null,null,null,"CLEAN-UP BULLS",null,null,null,"per Cow Bred Using Clean-up Bulls"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per Cow in the Herd"]
[]
[null,"PARTIAL BUDGET ANALYSIS SHOWING AI COSTS COMPARED TO NATURAL SERVICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Herd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Cost",null,{"$f":"E68*CleanupBulls","v":1741.3922819655422},{"$f":"IF(HerdSize=0,0,Y75/HerdSize)","v":17.413922819655422},{"$f":"IF((AISystemPregRate-AIPregRate)=0,0,Z75/((AISystemPregRate-AIPregRate)/100))","v":116.09281879770282}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest on Bull Investment",null,{"$f":"E70*CleanupBulls","v":145.41249999999999},{"$f":"IF(HerdSize=0,0,Y76/HerdSize)","v":1.4541249999999999},{"$f":"IF((AISystemPregRate-AIPregRate)=0,0,Z76/((AISystemPregRate-AIPregRate)/100))","v":9.6941666666666659}]
[null,null,null,null,"per Calf Produced","per Cow","Herd       Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(Y75:Y76)","v":1886.8047819655421},{"$f":"SUM(Z75:Z76)","v":18.868047819655423},{"$f":"SUM(AA75:AA76)","v":125.78698546436948}]
[]
[null,"Increased Value from AI",null,null,30,{"$f":"IF(HerdSize=0,0,G79/HerdSize)","v":37.200000000000003},{"$f":"E79*HerdSize*AIWeanRate/100+IF(AIWeanRate>NatWeanRate,(AIWeanRate-NatWeanRate)*HerdSize/100*(CalfValue),0)","v":3720},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL BREEDING COST",null,null,null,"per Pregnant Cow"]
[null,"Cost of AI",null,null,{"$f":"IF(AIWeanRate=0,0,F80/(AIWeanRate/100))","v":98.601063829787236},{"$f":"IF(HerdSize=0,0,G80/HerdSize)","v":92.685000000000002},{"$f":"Y69","v":9268.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per Cow in the Herd",null,"per Calf Produced"]
[null,"Reduced Income if Pregnancy Rate Decreases with AI ",null,null,{"$f":"IF(NatWeanRate=0,0,F81/(NatWeanRate/100))","v":0},{"$f":"IF(HerdSize=0,0,G81/HerdSize)","v":0},{"$f":"IF(AIWeanRate=0,0,IF(NatWeanRate>AIWeanRate,(NatWeanRate-AIWeanRate)*HerdSize/100*CalfValue,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Herd"]
[null,"Reduced Cost for Fewer Bulls",null,null,{"$f":"IF(AIWeanRate=0,0,F82/(AIWeanRate/100))","v":60.217173892517302},{"$f":"IF(HerdSize=0,0,G82/HerdSize)","v":56.604143458966263},{"$f":"IF(AIWeanRate=0,0,E71*(NatBulls-CleanupBulls))","v":5660.4143458966264},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Cash Costs",null,{"$f":"Y65+Y75","v":9347.3922819655418},{"$f":"IF(HerdSize=0,0,Y82/HerdSize)","v":93.473922819655414},{"$f":"IF(AISystemPregRate=0,0,$Z82/(AISystemPregRate/100))","v":98.393602968058332},{"$f":"IF(AIWeanRate=0,0,$Z82/(AIWeanRate/100))","v":99.440343425165338}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Interest and Depreciation Costs",null,{"$f":"Y67+Y76+Y68","v":1807.9124999999999},{"$f":"IF(HerdSize=0,0,Y83/HerdSize)","v":18.079124999999998},{"$f":"IF(AISystemPregRate=0,0,$Z83/(AISystemPregRate/100))","v":19.030657894736841},{"$f":"IF(AIWeanRate=0,0,$Z83/(AIWeanRate/100))","v":19.233111702127658}]
[null,null,"Expected Net Gain from AI",null,{"$f":"IF($Y$8=0,0,F84/($Y$8/100))","v":1.1905781478364506},{"$f":"F79-F80+F82-F81","v":1.1191434589662634},{"$f":"G79-G80+G82-G81","v":111.9143458966264},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(Y82:Y83)","v":11155.304781965542},{"$f":"SUM(Z82:Z83)","v":111.5530478196554},{"$f":"SUM(AA82:AA83)","v":117.42426086279517},{"$f":"SUM(AB82:AB83)","v":118.673455127293}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($Y$84-$D$71+(NatWeanRate-AIWeanRate)*CalfValue)/(AIWeanRate*HerdSize/100)<=0,\"Cost advantage per calf of using AI\",\"Increased value per calf needed to cover AI costs.\")","v":"Increased value per calf needed to cover AI costs."},{"$f":"($Y$84-$D$71+(NatWeanRate-AIWeanRate)*CalfValue)/(AIWeanRate*HerdSize/100)*IF(($Y$84-$D$71+(NatWeanRate-AIWeanRate)*CalfValue)/(AIWeanRate*HerdSize/100)<=0,-1,1)","v":28.809421852163549}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per cow","per calf","total"]

{"sheet":"PreliminaryCompare","index":7,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":true,"merged":[[3,7,3,10],[3,11,3,18],[19,7,19,10],[19,11,19,18]]}
[]
[]
[null,null,null,null,null,null," VS Natural Service"]
[null,null,null,null,null,null,null,"GAINS",null,null,null,"LOSSES"]
[null,null,null,"Expected Net Gain",null,null,"Expected Net Gain",{"$f":"Inputs!B118","v":"Increased revenue from proposed change"},{"$f":"Inputs!B127","v":"Fewer bulls required (reduced cost/bull)"},{"$f":"Inputs!B128","v":"fewer replacements needed"},{"$f":"Inputs!B129","v":"heat detection labour"},{"$f":"Inputs!I118","v":"Decreased revenue from proposed change"},{"$f":"Inputs!I126","v":"Semen costs"},{"$f":"Inputs!I127","v":"AI technician"},{"$f":"Inputs!I129","v":"labour - AI treatment"},{"$f":"Inputs!I130","v":"breeding system treatment cost (drugs)"},{"$f":"Inputs!I131","v":"AI supplies (syringes, etc.)"},{"$f":"Inputs!I132","v":"AI Equipment maintenance"},{"$f":"Inputs!I133","v":"Depreciation & interest on AI Equipment"}]
[null,null,null,"Select Synch",257.47954621898407,-162.52045378101502,-202.23155880218837,1314.1985999999902,4120.9448411978219,2500,-140.00000000000003,1224.875,2200,1100,560,850,100,300,1662.5]
[null,null,null,"Select Synch +CIDR",8428.075212885662,8008.075212885662,8444.7576911978194,7658.6878499999993,4120.9448411978219,9985,-120,4497.375,2300,1150,540,2650,100,300,1662.5]
[null,null,null,"PG 6-day CIDR",8292.2418795523281,7872.2418795523281,8302.2576911978213,7658.6878499999993,4120.9448411978219,9985,-120,4497.375,2300,1150,580,2752.5,100,300,1662.5]
[null,null,null,"MGA+PG",10440.74187955233,10020.74187955233,10460.757691197821,7658.6878499999993,4120.9448411978219,9985,-120,4497.375,2300,1150,520,654,100,300,1662.5]
[null,null,null,"Select Synch with E-AI and Cleanup AI",269.54954621898469,-11.85045378101313,-301.67905880218768,1624.1510999999903,4120.9448411978219,2500,-80,1224.875,2500,1250,577.99999999999989,851.4,100,300,1662.5]
[null,null,null,"Select Synch + CIDR with E-AI and Cleanup AI",8441.3052128856616,8021.3052128856616,8211.155191197824,7825.5853499999994,4120.9448411978219,9985,-80,4497.375,2500,1250,557.99999999999989,2772.5,100,300,1662.5]
[null,null,null,"PG 6 Day CIDR with E-AI and Cleanup AI",8521.9938795523212,8101.9938795523212,8279.8116911978177,8059.2418499999958,4120.9448411978219,9985,-120,4497.375,2500,1250,598,2857.5,100,300,1662.5]
[null,null,null,"Co-synch_CIDRwithGnRH-7day",8264.7418795523281,7844.7418795523281,7874.7576911978213,7658.6878499999993,4120.9448411978219,9985,0,4497.375,2500,1250,580,3000,100,300,1662.5]
[null,null,null,"CO-Synch-CIDR-5day",8311.8905462189923,7891.8905462189923,7902.2091911978205,8226.1393499999958,4120.9448411978219,9985,0,4497.375,2500,1250,620,3500,100,300,1662.5]
[null,null,null,"Co-synch-CIDRwithEstradiol-7day",9007.8272128856552,8587.8272128856552,8615.3116911978177,8059.2418499999958,4120.9448411978219,9985,0,4497.375,2500,1250,540,2700,100,300,1662.5]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"GAINS",null,null,null,"LOSSES"]
[null,null,null,"Expected Net Gain"," VS Natural Service",null,null,{"$f":"Inputs!B134","v":"Sub-total Decreased Costs  ( B )"},{"$f":"Inputs!B143","v":"3. Agriculture and Forestry website: 'What is My Cereal Silage Crop Worth?'  that estimates a multiplier of 12 times the barley price per bushel for the value of a ton of silage \"at the pit\" i.e. harvested and delivered by the grower"},{"$f":"Inputs!B144","v":"4. Central Alfalfa Hay 1st cut, April to June AFSC Commodity Prices, 17/18/2018"},{"$f":"Inputs!B145","v":"5. July estimated price for Blue Salt and mineral blocks (55 lb units) as reported by several commercial feed suppliers.  "},{"$f":"Inputs!I134","v":"Sub-total Increased Costs  ( D )"},{"$f":"Inputs!I142","v":0},{"$f":"Inputs!I143","v":0},{"$f":"Inputs!I145","v":0},{"$f":"Inputs!I146","v":0},{"$f":"Inputs!I147","v":0},{"$f":"Inputs!I148","v":0},{"$f":"Inputs!I149","v":0}]
[null,null,null,"Select Synch",257.47954621898407,-162.52045378101502,{"$f":"IF(Inputs!$G$6=2,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=2, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=2,Inputs!$N$133)","v":false}]
[null,null,null,"Select Synch +CIDR",8428.075212885662,8008.075212885662,{"$f":"IF(Inputs!$G$6=3,Inputs!$N$137)","v":7543.2327304900246},{"$f":"IF(Inputs!$G$6=3,Inputs!$G$123)","v":6599.5020000000086},{"$f":"IF(Inputs!$G$6=3,Inputs!$G$127)","v":4542.3557304900178},{"$f":"IF(Inputs!$G$6=3,Inputs!$G$128)","v":10380},{"$f":"IF(Inputs!$G$6=3,Inputs!$G$129)","v":-120},{"$f":"IF(Inputs!$G$6=3, Inputs!$N$123)","v":5156.125},{"$f":"IF(Inputs!$G$6=3,Inputs!$N$126)","v":2300},{"$f":"IF(Inputs!$G$6=3,Inputs!$N$127)","v":1150},{"$f":"IF(Inputs!$G$6=3,Inputs!$N$129)","v":540},{"$f":"IF(Inputs!$G$6=3,Inputs!$N$130)","v":2650},{"$f":"IF(Inputs!$G$6=3,Inputs!$N$131)","v":100},{"$f":"IF(Inputs!$G$6=3,Inputs!$N$132)","v":300},{"$f":"IF(Inputs!$G$6=3,Inputs!$N$133)","v":1662.5}]
[null,null,null,"PG 6-day CIDR",8292.2418795523281,7872.2418795523281,{"$f":"IF(Inputs!$G$6=4,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=4, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=4,Inputs!$N$133)","v":false}]
[null,null,null,"MGA+PG",10440.74187955233,10020.74187955233,{"$f":"IF(Inputs!$G$6=5,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=5, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=5,Inputs!$N$133)","v":false}]
[null,null,null,"Select Synch with E-AI and Cleanup AI",269.54954621898469,-11.85045378101313,{"$f":"IF(Inputs!$G$6=6,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=6, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=6,Inputs!$N$133)","v":false}]
[null,null,null,"Select Synch + CIDR with E-AI and Cleanup AI",8441.3052128856616,8021.3052128856616,{"$f":"IF(Inputs!$G$6=7,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=7, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=7,Inputs!$N$133)","v":false}]
[null,null,null,"PG 6 Day CIDR with E-AI and Cleanup AI",8521.9938795523212,8101.9938795523212,{"$f":"IF(Inputs!$G$6=8,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=8, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=8,Inputs!$N$133)","v":false}]
[null,null,null,"Co-synch_CIDRwithGnRH-7day",8264.7418795523281,7844.7418795523281,{"$f":"IF(Inputs!$G$6=9,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=9, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=9,Inputs!$N$133)","v":false}]
[null,null,null,"CO-Synch-CIDR-5day",8311.8905462189923,7891.8905462189923,{"$f":"IF(Inputs!$G$6=10,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=10, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=10,Inputs!$N$133)","v":false}]
[null,null,null,"Co-synch-CIDRwithEstradiol-7day",9007.8272128856552,8587.8272128856552,{"$f":"IF(Inputs!$G$6=11,Inputs!$N$137)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$G$123)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$G$127)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$G$128)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$G$129)","v":false},{"$f":"IF(Inputs!$G$6=11, Inputs!$N$123)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$N$126)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$N$127)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$N$129)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$N$130)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$N$131)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$N$132)","v":false},{"$f":"IF(Inputs!$G$6=11,Inputs!$N$133)","v":false}]