{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Intro","Instructions","Summary","Amoritized costs","Blank 1","Blank 2","Blank 3","Blank 4","Blank 5","Blank 6","Blank 7","Blank 8","Blank 9","Blank 10","Blank 11","Blank 12","Blank 13","Blank 14","Blank 15","Blank 16","Blank 17"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Intro","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[18,0,18,8],[19,0,19,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[0,1,0,7],[3,0,3,8],[4,0,4,8],[5,0,5,8],[6,0,6,8]]}
[null,"KSU Grower/Stocker Financial Record Spreadsheet V1"]
[]
["Introduction"]
["This speadsheet tool was developed for use by producers who would like to track the expenses"]
["and profitability of a limited number of groups of backgrounding/grower/stocker cattle."]
[]
["Instructions for use"]
["This spreadsheet contains macros, so you will need to \"Enable Content\" for it to work "]
["corectly.  Blue boxes are input cell and all others are calculated and protected."]
[]
["Developers"]
["This tool was developed by David Kehler, KSU Farm Analyst and Dale Blasi, Professor/Extension"]
["Specialist, Ruminant Nutrition/Beef."]
["A Thank You goes to Kathy Coffman Coffman Cattle who presented to idea of this tool to "]
["Dale and provided data and input to Dave."]

{"sheet":"Instructions","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[25,0,25,8],[26,0,26,8],[19,0,19,8],[20,0,20,8],[21,0,21,8],[22,0,22,8],[23,0,23,8],[24,0,24,8],[18,0,18,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[6,0,6,8],[0,2,0,4],[2,0,2,8],[3,0,3,8],[4,0,4,8],[5,0,5,8]]}
[null,null,"Instructions"]
[]
["This is version 1 of this tool.  It is currently designed to track 17 groups of cattle. As it is utilized  "]
["and the developers receive feedback, updates will be made."]
[]
["Summary page - This page is automatically populated and provides  summary of all groups."]
[]
["Amoritized costs page - this page will help you allot costs to multiple groups of cattle."]
["You will still need to transfer those costs to the individual groups costs."]
[]
["Groups pages - This is where you will input all costs associated with a group of cattle.  When "]
["in cell C4, it will automaticsally put the name on the page tab. The first page is where you will "]
["input general information and numbers.  On this page, you can calculate break-evens at any "]
["point in the period.  It will calculate actual sales data and performance data."]
["The second, third and fourth pages of each group is where the actual costs are to be recorded."]
["Do not forget to record any amoritized costs to these pages."]
[]
["This sheet will be updated as needed and the newest version will be on the KSUbeef.org site."]
["We would recommend downloading the newest version each year."]

{"sheet":"Summary","index":2,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[5,0,5,1],[3,2,3,6],[24,0,24,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[17,0,17,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1]]}
[]
[]
[]
[null,null,"Summary of the KSU Beef Stocker/Grower cost calclations as of "]
[]
[]
["Group Name",null,"# bought","Purchase $","Total expense","Total cost","Gross Sale $","Profit","# sold","Sale $/hd","Profit/ hd"]
[{"$f":"+'Blank 1'!C4","v":"Blank 1"},null,{"$f":"+'Blank 1'!C12","v":0},{"$f":"+'Blank 1'!F12","v":0},{"$f":"('Blank 1'!F13+'Blank 1'!F14+'Blank 1'!F15)","v":0},{"$f":"+D8+E8","v":0},{"$f":"+'Blank 1'!F25","v":0},{"$f":"+G8-F8","v":0},{"$f":"+'Blank 1'!C25","v":0},{"$f":"+G8/I8","v":{"$error":"#DIV/0!"}},{"$f":"+H8/I8","v":{"$error":"#DIV/0!"}}]
[{"$f":"+'Blank 2'!C4","v":"Blank 2"},null,{"$f":"+'Blank 2'!C12","v":0},{"$f":"+'Blank 2'!F12","v":0},{"$f":"+'Blank 2'!F13+'Blank 2'!F14+'Blank 2'!F15","v":0},{"$f":"+D9+E9","v":0},{"$f":"+'Blank 2'!F25","v":0},{"$f":"+G9-F9","v":0},{"$f":"+'Blank 2'!C25","v":0},{"$f":"+G9/I9","v":{"$error":"#DIV/0!"}},{"$f":"+H9/I9","v":{"$error":"#DIV/0!"}}]
[{"$f":"+'Blank 3'!C4","v":"Blank 3"},null,{"$f":"+'Blank 3'!C12","v":0},{"$f":"+'Blank 3'!F12","v":0},{"$f":"+'Blank 3'!F13+'Blank 3'!F14+'Blank 3'!F15","v":0},{"$f":"+D10+E10","v":0},{"$f":"+'Blank 3'!F25","v":0},0,{"$f":"+'Blank 3'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 4'!C4","v":"Blank 4"},null,{"$f":"+'Blank 4'!C12","v":0},{"$f":"+'Blank 4'!F12","v":0},{"$f":"+'Blank 4'!F13+'Blank 4'!F14+'Blank 4'!F15","v":0},0,{"$f":"+'Blank 4'!F25","v":0},0,{"$f":"+'Blank 4'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 5'!C4","v":"Blank 5"},null,{"$f":"+'Blank 5'!C12","v":0},{"$f":"+'Blank 5'!F12","v":0},{"$f":"+'Blank 5'!F13+'Blank 5'!F14+'Blank 5'!F15","v":0},0,{"$f":"+'Blank 5'!F25","v":0},0,{"$f":"+'Blank 5'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 6'!C4","v":"Blank 6"},null,{"$f":"+'Blank 6'!C12","v":0},{"$f":"+'Blank 6'!F12","v":0},{"$f":"+'Blank 6'!F13+'Blank 6'!F14+'Blank 6'!F15","v":0},0,{"$f":"+'Blank 6'!F25","v":0},0,{"$f":"+'Blank 6'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 7'!C4","v":"Blank 7"},null,{"$f":"+'Blank 7'!C12","v":0},{"$f":"+'Blank 7'!F12","v":0},{"$f":"+'Blank 7'!F13+'Blank 7'!F14+'Blank 7'!F15","v":0},0,{"$f":"+'Blank 7'!F25","v":0},0,{"$f":"+'Blank 7'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 8'!C4","v":"Blank 8"},null,{"$f":"+'Blank 8'!C12","v":0},{"$f":"+'Blank 8'!F12","v":0},{"$f":"+'Blank 8'!F13+'Blank 8'!F14+'Blank 8'!F15","v":0},0,{"$f":"+'Blank 8'!F25","v":0},0,{"$f":"+'Blank 8'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 9'!C4","v":"Blank 9"},null,{"$f":"+'Blank 9'!C12","v":0},{"$f":"+'Blank 9'!F12","v":0},{"$f":"+'Blank 9'!F13+'Blank 9'!F14+'Blank 9'!F15","v":0},0,{"$f":"+'Blank 9'!F25","v":0},0,{"$f":"+'Blank 9'!C20","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 10'!C4","v":"Blank 10"},null,{"$f":"+'Blank 10'!C12","v":0},{"$f":"+'Blank 10'!F12","v":0},{"$f":"+'Blank 10'!F13+'Blank 10'!F14+'Blank 10'!F15","v":0},0,{"$f":"+'Blank 10'!F25","v":0},0,{"$f":"+'Blank 10'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 11'!C4","v":"Blank 11"},null,{"$f":"+'Blank 11'!C12","v":0},{"$f":"+'Blank 11'!F12","v":0},{"$f":"+'Blank 11'!F13+'Blank 11'!F14+'Blank 11'!F15","v":0},0,{"$f":"+'Blank 11'!F25","v":0},0,{"$f":"+'Blank 11'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 12'!C4","v":"Blank 12"},null,{"$f":"+'Blank 12'!C12","v":0},{"$f":"+'Blank 12'!F12","v":0},{"$f":"+'Blank 12'!F13+'Blank 12'!F14+'Blank 12'!F15","v":0},0,{"$f":"+'Blank 12'!F25","v":0},0,{"$f":"+'Blank 12'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 13'!C4","v":"Blank 13"},null,{"$f":"+'Blank 13'!C12","v":0},{"$f":"'Blank 13'!F12","v":0},{"$f":"'Blank 13'!F13+'Blank 13'!F14+'Blank 13'!F15","v":0},0,{"$f":"'Blank 13'!F25","v":0},0,{"$f":"'Blank 13'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 14'!C4","v":"Blank 14"},null,{"$f":"+'Blank 14'!C12","v":0},{"$f":"'Blank 14'!F12","v":0},{"$f":"'Blank 14'!F13+'Blank 14'!F14+'Blank 14'!F15","v":0},0,{"$f":"'Blank 14'!F25","v":0},0,{"$f":"+'Blank 14'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 15'!C4","v":"Blank 15"},null,{"$f":"+'Blank 15'!C12","v":0},{"$f":"+'Blank 15'!F12","v":0},{"$f":"+'Blank 15'!F13+'Blank 15'!F14+'Blank 15'!F15","v":0},0,{"$f":"+'Blank 15'!F25","v":0},0,{"$f":"+'Blank 15'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 16'!C4","v":"Blank 16"},null,{"$f":"+'Blank 16'!C12","v":0},{"$f":"+'Blank 16'!F12","v":0},{"$f":"+'Blank 16'!F13+'Blank 16'!F14+'Blank 16'!F15","v":0},0,{"$f":"+'Blank 16'!F25","v":0},0,{"$f":"+'Blank 16'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"+'Blank 17'!C4","v":"Blank 17"},null,{"$f":"+'Blank 17'!C12","v":0},{"$f":"+'Blank 17'!F12","v":0},{"$f":"+'Blank 17'!F13+'Blank 17'!F14+'Blank 17'!F15","v":0},0,{"$f":"+'Blank 17'!F25","v":0},0,{"$f":"+'Blank 17'!C25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Totals",null,{"$f":"SUM(C8:C24)","v":0},{"$f":"SUM(D8:D24)","v":0},{"$f":"SUM(E8:E24)","v":0},{"$f":"SUM(F8:F24)","v":0},{"$f":"SUM(G8:G24)","v":0},0,{"$f":"SUM(I8:I24)","v":0},{"$f":"+G25/I25","v":{"$error":"#DIV/0!"}},{"$f":"+IF(I25=\"\",\"\",H25/I25)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Amoritized costs","index":3,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,3],[0,1,0,10],[24,1,24,3],[25,1,25,3],[26,1,26,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[8,1,8,3],[7,1,7,3],[6,1,6,3],[1,1,1,8],[3,1,3,2],[4,1,4,3],[5,1,5,3]]}
[null,"Amoritized costs  Use this page to calculate the amount of multiple group costs to assign to each group."]
[null,"You will need to enter the costs to the appropriate group in the correct category.  "]
[]
[]
["Date","Item",null,null,"Cost","# of units","$ per unit","Group","# of units","$ to assign"]
[null,null,null,null,null,null,{"$f":"+IF(E6=\"\",\"\",E6/F6)","v":""},null,null,{"$f":"+IF(I6=\"\",\"\",G6*I6)","v":""}]
[null,null,null,null,null,null,{"$f":"+IF(E7=\"\",\"\",E7/F7)","v":""},null,null,{"$f":"+IF(I7=\"\",\"\",G7*I7)","v":""}]
[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,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,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,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,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,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,"",null,null,""]

{"sheet":"Blank 1","index":4,"n_rows":133,"n_cols":9,"rows_kept":133,"cut":false,"hidden":false,"merged":[[40,6,40,7],[74,6,74,7],[108,6,108,7],[71,0,71,1],[71,2,71,6],[105,0,105,1],[105,2,105,6],[3,2,3,6],[3,0,3,1],[5,0,5,1],[9,0,9,1],[10,0,10,1],[6,2,6,6],[7,2,7,6],[24,0,24,1],[27,0,27,1],[26,0,26,1],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[23,0,23,1],[21,0,21,1],[22,0,22,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[12,0,12,1],[13,0,13,1],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[11,0,11,1],[14,0,14,2],[28,0,28,1],[29,0,29,1],[30,0,30,1],[37,0,37,1],[37,2,37,6],[41,6,41,7],[59,1,59,2],[60,1,60,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[63,1,63,2],[64,1,64,2],[61,1,61,2],[62,1,62,2],[52,6,52,7],[53,6,53,7],[57,6,57,7],[64,6,64,7],[47,6,47,7],[48,6,48,7],[49,6,49,7],[50,6,50,7],[51,6,51,7],[61,6,61,7],[62,6,62,7],[63,6,63,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[82,1,82,2],[83,1,83,2],[84,1,84,2],[82,6,82,7],[83,6,83,7],[84,6,84,7],[85,6,85,7],[86,6,86,7],[73,1,73,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[98,1,98,2],[96,1,96,2],[97,1,97,2],[90,1,90,2],[91,1,91,2],[92,1,92,2],[94,1,94,2],[95,1,95,2],[93,1,93,2],[92,6,92,7],[94,6,94,7],[95,6,95,7],[96,6,96,7],[97,6,97,7],[116,1,116,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[111,1,111,2],[115,6,115,7],[116,6,116,7],[131,1,131,2],[132,1,132,2],[109,6,109,7],[127,1,127,2],[128,1,128,2],[129,1,129,2],[130,1,130,2],[122,1,122,2],[123,1,123,2],[124,1,124,2],[125,1,125,2],[126,1,126,2],[117,1,117,2],[118,1,118,2],[119,1,119,2],[120,1,120,2],[121,1,121,2],[112,1,112,2],[113,1,113,2],[114,1,114,2],[115,1,115,2],[120,6,120,7],[121,6,121,7],[122,6,122,7],[132,6,132,7],[123,6,123,7],[124,6,124,7],[125,6,125,7],[126,6,126,7],[127,6,127,7],[128,6,128,7],[129,6,129,7],[130,6,130,7],[131,6,131,7],[117,6,117,7],[118,6,118,7],[119,6,119,7],[110,6,110,7],[111,6,111,7],[54,6,54,7],[55,6,55,7],[56,6,56,7],[112,6,112,7],[113,6,113,7],[114,6,114,7],[75,6,75,7],[76,6,76,7],[93,6,93,7],[77,6,77,7],[78,6,78,7],[79,6,79,7],[80,6,80,7],[81,6,81,7],[87,6,87,7],[88,6,88,7],[89,6,89,7],[90,6,90,7],[91,6,91,7]]}
[]
[]
[]
["Group name ",null,"Blank 1"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+D10/C10","v":{"$error":"#DIV/0!"}},{"$f":"+F10/C10","v":{"$error":"#DIV/0!"}}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+D11/C11","v":{"$error":"#DIV/0!"}},{"$f":"+F11/C11","v":{"$error":"#DIV/0!"}}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+F12/C12","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D40","v":0},null,{"$f":"+F13/C12","v":{"$error":"#DIV/0!"}}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D74","v":0},null,{"$f":"+F14/C12","v":{"$error":"#DIV/0!"}}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D108+G25","v":0},null,{"$f":"+F15/C12","v":{"$error":"#DIV/0!"}}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+F10+(H13*C10)+(H14*C10)+(H15*C10)","v":{"$error":"#DIV/0!"}},{"$f":"+F18/C18","v":{"$error":"#DIV/0!"}},{"$f":"+F18/E18","v":{"$error":"#DIV/0!"}}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+F11+(H13*C11)+(H14*C11)+(H15*C11)","v":{"$error":"#DIV/0!"}},{"$f":"+F19/C19","v":{"$error":"#DIV/0!"}},{"$f":"+F19/E19","v":{"$error":"#DIV/0!"}}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+C27-C6","v":0}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 1"}]
[]
[null,"Total",null,{"$f":"+D65+I65","v":0}]
["Date","Feed and Supplement",null,"Cost",null,"Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D42:D64)","v":0},null,null,"Total",null,{"$f":"SUM(I42:I64)","v":0}]
[]
[]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 1"}]
[]
[null,"Total",null,{"$f":"+D99+I99","v":0}]
["Date","Vet and medication",null,"Cost",null,"Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D76:D98)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 1"}]
[]
[null,"Total",null,{"$f":"+D133+I133","v":0}]
["Date","Misc.",null,"Cost",null,"Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D110:D132)","v":0},null,null,"Total",null,{"$f":"SUM(I110:I132)","v":0}]

{"sheet":"Blank 2","index":5,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6]]}
[]
[]
[]
["Group name ",null,"Blank 2"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70+G25","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 2"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 2"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 2"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 3","index":6,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6]]}
[]
[]
[]
["Group name ",null,"Blank 3"]
["Purchase date",null,"2023-03-07"]
["Arrival date",null,"2023-03-07"]
["Purchased from",null,"Rezak Livestock sale barn"]
["Shipped from",null,"St. Marys Kansas"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+G102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 3"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 3"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 3"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 4","index":7,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6]]}
[]
[]
[]
["Group name ",null,"Blank 4"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+G102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 4"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 4"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 4"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 5","index":8,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6]]}
[]
[]
[]
["Group name ",null,"Blank 5"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+G102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+IF(C29=\"\",\"\",F23/C23)","v":""},{"$f":"+IF(C29=\"\",\"\",G29-G18)","v":""}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+IF(C30=\"\",\"\",F24/C24)","v":""},{"$f":"+IF(C30=\"\",\"\",G30-G19)","v":""}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},"",""]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 5"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 5"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 5"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 6","index":9,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6]]}
[]
[]
[]
["Group name ",null,"Blank 6"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 6"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 6"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 6"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 7","index":10,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 7"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 7"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 7"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 7"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 8","index":11,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6]]}
[]
[]
[]
["Group name ",null,"Blank 8"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 8"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 8"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 8"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 9","index":12,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6]]}
[]
[]
[]
["Group name ",null,"Blank 9"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 9"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 9"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 9"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 10","index":13,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 10"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"0\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 10"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 10"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 10"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 11","index":14,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 11"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,"2023-08-02",{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":45140}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 11"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 11"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 11"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 12","index":15,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 12"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 12"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 12"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 12"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 13","index":16,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 13"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 13"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 13"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 13"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 14","index":17,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 14"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 14"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 14"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 14"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 15","index":18,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 15"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 15"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 15"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 15"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 16","index":19,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 16"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 16"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 16"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 16"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]

{"sheet":"Blank 17","index":20,"n_rows":127,"n_cols":9,"rows_kept":127,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[3,0,3,1],[3,2,3,6],[5,0,5,1],[6,0,6,1],[6,2,6,6],[7,0,7,1],[7,2,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[14,0,14,2],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[39,1,39,2],[39,6,39,7],[40,1,40,2],[40,6,40,7],[41,1,41,2],[41,6,41,7],[29,0,29,1],[30,0,30,1],[35,0,35,1],[35,2,35,6],[37,1,37,2],[38,1,38,2],[45,1,45,2],[45,6,45,7],[46,1,46,2],[46,6,46,7],[47,1,47,2],[47,6,47,7],[42,1,42,2],[42,6,42,7],[43,1,43,2],[43,6,43,7],[44,1,44,2],[44,6,44,7],[51,1,51,2],[51,6,51,7],[52,1,52,2],[52,6,52,7],[53,1,53,2],[53,6,53,7],[48,1,48,2],[48,6,48,7],[49,1,49,2],[49,6,49,7],[50,1,50,2],[50,6,50,7],[57,1,57,2],[57,6,57,7],[58,1,58,2],[58,6,58,7],[59,1,59,2],[59,6,59,7],[54,1,54,2],[54,6,54,7],[55,1,55,2],[55,6,55,7],[56,1,56,2],[56,6,56,7],[67,0,67,1],[67,2,67,6],[69,1,69,2],[70,1,70,2],[71,1,71,2],[71,6,71,7],[60,1,60,2],[60,6,60,7],[61,1,61,2],[61,6,61,7],[62,1,62,2],[62,6,62,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[81,1,81,2],[81,6,81,7],[82,1,82,2],[82,6,82,7],[83,1,83,2],[83,6,83,7],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,1,80,2],[80,6,80,7],[87,1,87,2],[87,6,87,7],[88,1,88,2],[88,6,88,7],[89,1,89,2],[89,6,89,7],[84,1,84,2],[84,6,84,7],[85,1,85,2],[85,6,85,7],[86,1,86,2],[86,6,86,7],[93,1,93,2],[93,6,93,7],[94,1,94,2],[99,0,99,1],[99,2,99,6],[101,1,101,2],[90,1,90,2],[90,6,90,7],[91,1,91,2],[91,6,91,7],[92,1,92,2],[92,6,92,7],[106,1,106,2],[106,6,106,7],[107,1,107,2],[107,6,107,7],[108,1,108,2],[108,6,108,7],[102,1,102,2],[103,1,103,2],[103,6,103,7],[104,1,104,2],[104,6,104,7],[105,1,105,2],[105,6,105,7],[112,1,112,2],[112,6,112,7],[113,1,113,2],[113,6,113,7],[114,1,114,2],[114,6,114,7],[109,1,109,2],[109,6,109,7],[110,1,110,2],[110,6,110,7],[111,1,111,2],[111,6,111,7],[118,1,118,2],[118,6,118,7],[119,1,119,2],[119,6,119,7],[120,1,120,2],[120,6,120,7],[115,1,115,2],[115,6,115,7],[116,1,116,2],[116,6,116,7],[117,1,117,2],[117,6,117,7],[124,1,124,2],[124,6,124,7],[125,1,125,2],[125,6,125,7],[126,1,126,2],[126,6,126,7],[121,1,121,2],[121,6,121,7],[122,1,122,2],[122,6,122,7],[123,1,123,2],[123,6,123,7]]}
[]
[]
[]
["Group name ",null,"Blank 17"]
["Purchase date"]
["Arrival date"]
["Purchased from"]
["Shipped from"]
[null,null,null,"Total lbs","Cost/lb","Total cost","Ave. lbs","cost/head"]
["# of steers",null,null,null,null,{"$f":"+D10*E10","v":0},{"$f":"+IF(C10=\"\",\"\",D10/C10)","v":""},{"$f":"+IF(C10=\"\",\"\",F10/C10)","v":""}]
["# of heifers",null,null,null,null,{"$f":"+D11*E11","v":0},{"$f":"+IF(D11=\"\",\"\",D11/C11)","v":""},{"$f":"+IF(C11=\"\",\"\",F11/C11)","v":""}]
["Total",null,{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"SUM(F10:F11)","v":0},null,{"$f":"+IF(C12=\"\",\"\",F12/C12)","v":{"$error":"#DIV/0!"}}]
["Feed cost",null,null,null,null,{"$f":"+D38","v":0},null,{"$f":"+IF(D40=\"\",\"\",F13/C12)","v":""}]
["Vet and Meds cost",null,null,null,null,{"$f":"+D70","v":0},null,{"$f":"+IF(D72=\"\",\"\",F14/C12)","v":""}]
["Misc. costs (including freight, sale fees, etc.)",null,null,null,null,{"$f":"+D102+G25","v":0},null,{"$f":"+IF(D104=\"\",\"\",F15/C12)","v":""}]
["Total cost",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},null,{"$f":"SUM(H12:H15)","v":{"$error":"#DIV/0!"}}]
[null,null,"Head","Ave lbs/hd","Total lbs","Total cost","Cost/hd","per lb."]
["Steer breakeven @",null,null,null,{"$f":"+C18*D18","v":0},{"$f":"+IF(C10=\"\",\"\",F10+(H13*C10)+(H14*C10)+(H15*C10))","v":""},{"$f":"+IF(C18=\"\",\"\",F18/C18)","v":""},{"$f":"+IF(C18=\"\",\"\",F18/E18)","v":""}]
["Heifer breakeven @",null,null,null,{"$f":"+C19*D19","v":0},{"$f":"+IF(C11=\"\",\"\",F11+(H13*C11)+(H14*C11)+(H15*C11))","v":""},{"$f":"+IF(F19=\"\",\"\",F19/C19)","v":""},{"$f":"+IF(C19=\"\",\"\",F19/E19)","v":""}]
["Group breakeven",null,{"$f":"SUM(C18:C19)","v":0},{"$f":"+E20/C20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:E19)","v":0},{"$f":"SUM(F18:F19)","v":0},{"$f":"+IF(F20=\"o\",\"\",F20/C20)","v":{"$error":"#DIV/0!"}},{"$f":"+F20/E20","v":{"$error":"#DIV/0!"}}]
[]
["Actual sales",null,"Head","Total lbs","Ave lbs/hd","Total gross sales","Sale Fees","Net sale/lb"]
["Steers",null,null,null,{"$f":"+IF(C23=\"\",\"\",D23/C23)","v":""},null,null,{"$f":"+IF(F23=\"\",\"\",(F23-G23)/D23)","v":""}]
["Heifers",null,null,null,{"$f":"+IF(C24=\"\",\"\",D24/C24)","v":""},null,null,{"$f":"+IF(F24=\"\",\"\",(F24-G24)/D24)","v":""}]
["Group",null,{"$f":"SUM(C23:C24)","v":0},{"$f":"SUM(D23:D24)","v":0},{"$f":"+IF(C25=0,\"\",D25/C25)","v":""},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"+IF(F25=0,\"\",(F25-G25)/D25)","v":""}]
[null,null,null,"Days"]
["Sale date",null,null,{"$f":"+IF(C27=\"\",\"\",C27-C6)","v":""}]
["Performance",null,"lbs gained","lbs/head","lbs./day","cost/lb. gain","Gross sale/hd","Profit/hd"]
["Steers",null,{"$f":"+IF(D23=\"\",\"\",D23-D10)","v":""},{"$f":"+IF(C23=\"\",\"\",C29/C23)","v":""},{"$f":"+IF(D29=\"\",\"\",D29/D27)","v":""},null,{"$f":"+F23/C23","v":{"$error":"#DIV/0!"}},{"$f":"+G29-G18","v":{"$error":"#DIV/0!"}}]
["Heifers",null,{"$f":"+IF(D24=\"\",\"\",D24-D11)","v":""},{"$f":"+IF(C24=\"\",\"\",C30/C24)","v":""},{"$f":"+IF(D30=\"\",\"\",D30/D27)","v":""},null,{"$f":"+F24/C24","v":{"$error":"#DIV/0!"}},{"$f":"+G30-G19","v":{"$error":"#DIV/0!"}}]
["Group",null,{"$f":"+IF(D25=0,\"\",D25-D12)","v":""},{"$f":"+IF(C25=0,\"\",C31/C25)","v":""},{"$f":"+IF(D31=\"\",\"\",D31/D27)","v":""},{"$f":"+IF(C31=\"\",\"\",(F13+F14+F15+G25)/C31)","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 17"}]
[]
[null,"Total",null,{"$f":"+D63+I63","v":0}]
["Date","Feed and Supplement",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D40:D62)","v":0},null,null,"Total",null,{"$f":"SUM(I40:I62)","v":0}]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 17"}]
[]
[null,"Total",null,{"$f":"+D95+I95","v":0}]
["Date","Vet and medication",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D72:D94)","v":0},null,null,null,"Total"]
[]
[]
[]
[]
["Group name ",null,{"$f":"+C4","v":"Blank 17"}]
[]
[null,"Total",null,{"$f":"+D127+I127","v":0}]
["Date","Misc.",null,"Cost"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D104:D126)","v":0},null,null,"Total",null,{"$f":"SUM(I104:I126)","v":0}]