{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["READ ME","Hive Builder","Cost and Revenue Input","Payback Calc. (One-Product)","Payback Calc. (Multi-Product)","Profit_and_Loss","Price_List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"READ ME","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hive Builder","index":1,"n_rows":98,"n_cols":14,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Product Name","Product Cost ","Quantity ","Total Product Cost ",null,null,"NOTE: This sheet assumes a single super deep bee management setup"]
[null,"10 frame outer cover (metal capped telescoping outer cover)",{"$f":"VLOOKUP(B3,Price_List!$B:$C,2,FALSE)","v":29.95},{"$f":"$H$10","v":0},{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame top feeder",{"$f":"VLOOKUP(B4,Price_List!$B:$C,2,FALSE)","v":33.950000000000003},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame inner cover",{"$f":"VLOOKUP(B5,Price_List!$B:$C,2,FALSE)","v":17.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 Frame Medium honey super assembled",{"$f":"VLOOKUP(B6,Price_List!$B:$C,2,FALSE)","v":25.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Assembled medium wood frame with plastic wax foundation",{"$f":"VLOOKUP(B7,Price_List!$B:$C,2,FALSE)","v":5.05},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Wooden Frame Metal Queen Excluder",{"$f":"VLOOKUP(B8,Price_List!$B:$C,2,FALSE)","v":22.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame Deep Super brood chamber",{"$f":"VLOOKUP(B9,Price_List!$B:$C,2,FALSE)","v":27.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0},null,"Current Hives","Additional Hives"]
[null,"Assembled Deep wood frame with plastic wax foundation",{"$f":"VLOOKUP(B10,Price_List!$B:$C,2,FALSE)","v":5.15},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0},null,0,0]
[null,"10 frame solid bottom board",{"$f":"VLOOKUP(B11,Price_List!$B:$C,2,FALSE)","v":23.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame hive stand",{"$f":"VLOOKUP(B12,Price_List!$B:$C,2,FALSE)","v":19.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0},null,null,null,{"$f":"M12","v":"Total"},"Per Hive",null,null,"Total","Per hive"]
[null,"10 frame entrance reducer",{"$f":"VLOOKUP(B13,Price_List!$B:$C,2,FALSE)","v":4.75},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0},null,null,"Woodenware cost",{"$f":"J13*H10","v":{"$error":"#DIV/0!"}},{"$f":"(SUM(Table1[[Total Product Cost ]])-SUM(E17:E20)-E15)/H10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"J13*H10","v":{"$error":"#DIV/0!"}},{"$f":"J13","v":{"$error":"#DIV/0!"}}]
[null,"Galvanized Mouse Guard",{"$f":"VLOOKUP(B14,Price_List!$B:$C,2,FALSE)","v":7.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0},null,null,"Livestock/bee cost",{"$f":"J14*H10","v":{"$error":"#DIV/0!"}},{"$f":"(SUM(E17:E20)+E15)/H10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"J14*H10","v":{"$error":"#DIV/0!"}},{"$f":"J14","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"B17","v":"Local Bee Package"},{"$f":"C17","v":290},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0},null,null,"Construction cost",{"$f":"J15*H10","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J13:J14)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"J15*H10","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N13:N14)","v":{"$error":"#DIV/0!"}}]
[null,"Livestock / Bees"]
[null,"Local Bee Package",{"$f":"VLOOKUP(B17,Price_List!$B:$C,2,FALSE)","v":290},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Nuc colony - 4 frame",{"$f":"VLOOKUP(B18,Price_List!$B:$C,2,FALSE)","v":275},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Imported Mated Queen",50,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Outer Covers "]
[null,"8-frame outer cover ",{"$f":"VLOOKUP(B22,Price_List!$B:$C,2,FALSE)","v":34.950000000000003},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Garden top hive cover with metal cap (8 or 10 frame)",{"$f":"VLOOKUP(B23,Price_List!$B:$C,2,FALSE)","v":55.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Garden top hive cover (no metal) **",{"$f":"VLOOKUP(B24,Price_List!$B:$C,2,FALSE)","v":39.950000000000003},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame outer cover (metal capped telescoping outer cover)",{"$f":"VLOOKUP(B25,Price_List!$B:$C,2,FALSE)","v":29.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Metal Capped Telescoping Outer Cover**",{"$f":"VLOOKUP(B26,Price_List!$B:$C,2,FALSE)","v":29.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Inner Covers"]
[null,"8 – frame inner cover ",{"$f":"VLOOKUP(B29,Price_List!$B:$C,2,FALSE)","v":10.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame inner cover",{"$f":"VLOOKUP(B30,Price_List!$B:$C,2,FALSE)","v":17.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Deep inner cover (1-19) - 8 frame ",{"$f":"VLOOKUP(B31,Price_List!$B:$C,2,FALSE)","v":19.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Deep inner cover (20+) - 8 frame ",{"$f":"VLOOKUP(B32,Price_List!$B:$C,2,FALSE)","v":17.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Clear inner cover **",{"$f":"VLOOKUP(B33,Price_List!$B:$C,2,FALSE)","v":32.950000000000003},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"8 - frame Inner cover (1-19) ",{"$f":"VLOOKUP(B34,Price_List!$B:$C,2,FALSE)","v":17.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"8 - frame Inner cover (20+)",{"$f":"VLOOKUP(B35,Price_List!$B:$C,2,FALSE)","v":15.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Honey Supers"]
[null,"Shallow super (assembled)",{"$f":"VLOOKUP(B38,Price_List!$B:$C,2,FALSE)","v":22.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Shallow super (unassembled)",{"$f":"VLOOKUP(B39,Price_List!$B:$C,2,FALSE)","v":19.5},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 Frame Medium honey super assembled",{"$f":"VLOOKUP(B40,Price_List!$B:$C,2,FALSE)","v":25.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"medium super (assembled)",{"$f":"VLOOKUP(B41,Price_List!$B:$C,2,FALSE)","v":25.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"medium super (unassembled) ",{"$f":"VLOOKUP(B42,Price_List!$B:$C,2,FALSE)","v":18.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"8 – frame medium super unassembled ",{"$f":"VLOOKUP(B43,Price_List!$B:$C,2,FALSE)","v":25.35},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Queen Excluders"]
[null,"8-Frame Metal Queen Excluder",{"$f":"VLOOKUP(B46,Price_List!$B:$C,2,FALSE)","v":18.5},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Wooden Framed Metal Queen Excluder",{"$f":"VLOOKUP(B47,Price_List!$B:$C,2,FALSE)","v":22.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Plastic Queen Excluder",{"$f":"VLOOKUP(B48,Price_List!$B:$C,2,FALSE)","v":9.9499999999999993},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Hive Body (AKA Brood Box, Deep Super)"]
[null,"8-Frame Deep Super (assembled)**",{"$f":"VLOOKUP(B51,Price_List!$B:$C,2,FALSE)","v":31.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"deep super (assembled) 10 frame ",{"$f":"VLOOKUP(B52,Price_List!$B:$C,2,FALSE)","v":27.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Deep observation hive boxes (8 or 10 frame)",{"$f":"VLOOKUP(B53,Price_List!$B:$C,2,FALSE)","v":89.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"deep super (unassembled) 8 or 10 frame ",{"$f":"VLOOKUP(B54,Price_List!$B:$C,2,FALSE)","v":20.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame Deep Super brood chamber",{"$f":"VLOOKUP(B55,Price_List!$B:$C,2,FALSE)","v":27.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Bottom Boards"]
[null,"8-frame solid bottom board ",{"$f":"VLOOKUP(B58,Price_List!$B:$C,2,FALSE)","v":26.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"8 frame screened bottom board ",{"$f":"VLOOKUP(B59,Price_List!$B:$C,2,FALSE)","v":39.5},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Solid bottom board **",{"$f":"VLOOKUP(B60,Price_List!$B:$C,2,FALSE)","v":23.75},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame solid bottom board",{"$f":"VLOOKUP(B61,Price_List!$B:$C,2,FALSE)","v":23.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame Screened Bottom Board",{"$f":"VLOOKUP(B62,Price_List!$B:$C,2,FALSE)","v":34.950000000000003},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame entrance reducer",{"$f":"VLOOKUP(B63,Price_List!$B:$C,2,FALSE)","v":4.75},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"8-frame entrance reducer ",{"$f":"VLOOKUP(B64,Price_List!$B:$C,2,FALSE)","v":4.75},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Galvanized Mouse Guard",{"$f":"VLOOKUP(B65,Price_List!$B:$C,2,FALSE)","v":7.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"8-Frame Mouse Guard",{"$f":"VLOOKUP(B66,Price_List!$B:$C,2,FALSE)","v":10.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Slatted Rack (8 frame)",{"$f":"VLOOKUP(B67,Price_List!$B:$C,2,FALSE)","v":24.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Hive Stands"]
[null,"Hive Stand 8 or 10 frame ",{"$f":"VLOOKUP(B70,Price_List!$B:$C,2,FALSE)","v":19.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Hive Stand (with legs) - 8 or 10 frame ",{"$f":"VLOOKUP(B71,Price_List!$B:$C,2,FALSE)","v":27.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Frames & Foundations "]
[null,"Assembled medium wooden frame with wired wax foundation ",{"$f":"VLOOKUP(B74,Price_List!$B:$C,2,FALSE)","v":5.5},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Deep unassembled frames for plastic foundation **",{"$f":"VLOOKUP(B75,Price_List!$B:$C,2,FALSE)","v":22.5},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Pierco Deep Foundation ",{"$f":"VLOOKUP(B76,Price_List!$B:$C,2,FALSE)","v":19.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Unwaxed rite cell deep foundation ",{"$f":"VLOOKUP(B77,Price_List!$B:$C,2,FALSE)","v":1.9},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Permanent foundation deep ",{"$f":"VLOOKUP(B78,Price_List!$B:$C,2,FALSE)","v":1.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Assembled medium wood frame with plastic wax foundation",{"$f":"VLOOKUP(B79,Price_List!$B:$C,2,FALSE)","v":5.05},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Medium unassembled frames for plastic foundation (10 pack)",{"$f":"VLOOKUP(B80,Price_List!$B:$C,2,FALSE)","v":22},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Permanent foundation medium ",{"$f":"VLOOKUP(B81,Price_List!$B:$C,2,FALSE)","v":1.7},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Assembled deep rite cell wooden frame ",{"$f":"VLOOKUP(B82,Price_List!$B:$C,2,FALSE)","v":5.15},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Assembled medium wooden frame with plastic foundation ",{"$f":"VLOOKUP(B83,Price_List!$B:$C,2,FALSE)","v":5.05},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Assembled Deep wooden frame with wired wax foundation ",{"$f":"VLOOKUP(B84,Price_List!$B:$C,2,FALSE)","v":5.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Assembled Deep Wooden Frame with wax coated foundation (1)",{"$f":"VLOOKUP(B85,Price_List!$B:$C,2,FALSE)","v":5.15},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Assembled Deep Wooden Frame with wax coated foundation (20-199)",{"$f":"VLOOKUP(B86,Price_List!$B:$C,2,FALSE)","v":5.05},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Assembled Deep Wooden Frame with wax coated foundation (200+)",{"$f":"VLOOKUP(B87,Price_List!$B:$C,2,FALSE)","v":4.8499999999999996},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Foundation Rods 10 pack ",{"$f":"VLOOKUP(B88,Price_List!$B:$C,2,FALSE)","v":0.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Frame wire ",{"$f":"VLOOKUP(B89,Price_List!$B:$C,2,FALSE)","v":13.95},0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Other",0,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Feeders"]
[null,"Ceracell top feeder",32.950000000000003,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"Ceracell 5-frame Nuc top feeders",25.95,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"10 frame top feeder with super",33.950000000000003,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"8 frame top feeder with super",39.950000000000003,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"8-frame no drown top tray feeder",37.5,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"1 gallon cap and ladder feeder",18.95,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]
[null,"2 gallon cap and ladder feeder",22.95,0,{"$f":"SUM(Table1[[#This Row],[Product Cost ]]*Table1[[#This Row],[Quantity ]])","v":0}]

{"sheet":"Cost and Revenue Input","index":2,"n_rows":69,"n_cols":27,"rows_kept":69,"cut":false,"hidden":false,"merged":[[57,14,57,15],[56,14,56,15],[55,14,55,17],[42,10,42,12],[19,18,19,19],[20,18,20,19],[21,18,21,19],[22,18,22,19],[48,1,64,1],[2,6,2,22],[4,24,4,26],[48,14,48,15],[49,14,49,15],[2,2,2,4],[2,24,2,26],[11,18,11,22],[13,18,13,19],[15,18,15,19],[16,18,16,19],[17,18,17,19],[26,22,26,24],[42,14,42,18],[29,22,29,24],[18,18,18,19],[14,18,14,19],[0,2,0,24],[4,14,4,16],[4,10,4,12],[4,6,4,8],[4,2,4,4],[4,18,4,20]]}
[null,null,"Beekeeping Management Tool "]
[]
[null,null,"One-Time Costs ",null,null,null,"Operational Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miscellaneous Costs"]
[]
[null,null,"Fixed Costs (One-Time Costs)",null,null,null,"Mite Treatment ",null,null,null,"Feeding",null,null,null,"Pest Control ",null,null,null,"Fuel Costs",null,null,null,null,null,"Miscellaneous"]
[null,null,0,"Vented Bee Jacket ",{"$f":"C6*VLOOKUP(D6,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Apistan strips – box of 10 ",{"$f":"G6*VLOOKUP(H6,Price_List!$B:$C,2,FALSE)","v":0},null,0,"2kg bag of Sugar (Walmart) ",{"$f":"K6*VLOOKUP(L6,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Gallagher m60 fence Energizer ",{"$f":"O6*VLOOKUP(P6,Price_List!$B:$C,2,FALSE)","v":0},null,"Trip Distance (KM)",null,0,null,null,null,0,"Beginner kit ",{"$f":"Y6*VLOOKUP(Z6,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Bee Veil ",{"$f":"C7*VLOOKUP(D7,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Apivar strips – 4 pack ",{"$f":"G7*VLOOKUP(H7,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Ultra bee pollen pattie singles ",{"$f":"K7*VLOOKUP(L7,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Gallagher M120 Fence Energizer",{"$f":"O7*VLOOKUP(P7,Price_List!$B:$C,2,FALSE)","v":0},null,"Trips per Week",null,0,null,null,null,0,"Standard kit ",{"$f":"Y7*VLOOKUP(Z7,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Bee Gloves (leather)",{"$f":"C8*VLOOKUP(D8,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Apivar strips – 12 pack ",{"$f":"G8*VLOOKUP(H8,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Ultra bee pollen pattie (40)",{"$f":"K8*VLOOKUP(L8,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Gallagher s20 solar fence energizer ",{"$f":"O8*VLOOKUP(P8,Price_List!$B:$C,2,FALSE)","v":0},null,"Weeks ",null,0,null,null,null,0,"Deluxe Beginner Kit ",{"$f":"Y8*VLOOKUP(Z8,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Bee Gloves (cow skin)",{"$f":"C9*VLOOKUP(D9,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Formic Pro Strips (2 doses)",{"$f":"G9*VLOOKUP(H9,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Global Polen pattie ",{"$f":"K9*VLOOKUP(L9,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Gallagher S40 Solar Fence Energizer",{"$f":"O9*VLOOKUP(P9,Price_List!$B:$C,2,FALSE)","v":0},null,"Gas/Fuel Price ($/L)",null,0,null,null,null,0,"Queen rearing frame ",{"$f":"Y9*VLOOKUP(Z9,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Bee Gloves (goat skin) ",{"$f":"C10*VLOOKUP(D10,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Formic Pro Strips (10 doses)",{"$f":"G10*VLOOKUP(H10,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Global pollen pattie (40)",{"$f":"K10*VLOOKUP(L10,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Gallagher S100 Solar Fence Energizer",{"$f":"O10*VLOOKUP(P10,Price_List!$B:$C,2,FALSE)","v":0},null,"Fuel Efficiency (L/100KM)",null,0,null,null,null,0,"Wood cell bar ",{"$f":"Y10*VLOOKUP(Z10,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Hive tool ",{"$f":"C11*VLOOKUP(D11,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Formic Pro Strips (30 doses)",{"$f":"G11*VLOOKUP(H11,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Hive alive fondant patties ",{"$f":"K11*VLOOKUP(L11,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Turbo wire 2.5mm ",{"$f":"O11*VLOOKUP(P11,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,0,"Subcontract out honey extraction ",0]
[null,null,0,"Smoker & Shield (large)",{"$f":"C12*VLOOKUP(D12,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Thymovar (10 count)",{"$f":"G12*VLOOKUP(H12,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Pro Winter Feed - 10lb Bucket",{"$f":"K12*VLOOKUP(L12,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Turbo Braid Wire - 400m",{"$f":"O12*VLOOKUP(P12,Price_List!$B:$C,2,FALSE)","v":0},null,"Labour ",null,null,null,null,null,0,"Imported Queen ",0]
[null,null,0,"Smoker & Shield (medium)",{"$f":"C13*VLOOKUP(D13,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Oxalic Acid Dihydrate – 1 kg ",{"$f":"G13*VLOOKUP(H13,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Pro winter feed 50 lb bucket ",{"$f":"K13*VLOOKUP(L13,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Fibreglass Corner Posts",{"$f":"O13*VLOOKUP(P13,Price_List!$B:$C,2,FALSE)","v":0},null,"Employees ",null,"Wage/Hr","Hours","Total Cost ",null,0,"Bee Broker Services ",0]
[null,null,0,"Bee Brush ",{"$f":"C14*VLOOKUP(D14,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Foric Acid jug – 1 L ",{"$f":"G14*VLOOKUP(H14,Price_List!$B:$C,2,FALSE)","v":0},null,0,"2:1 feeding syrup (23L /32 kg)",{"$f":"K14*VLOOKUP(L14,Price_List!$B:$C,2,FALSE)","v":0},null,0,"6' Grounding Rod",{"$f":"O14*VLOOKUP(P14,Price_List!$B:$C,2,FALSE)","v":0},null,"Matthew ",null,0,0,{"$f":"U14*V14","v":0},null,0,"Other (E.g. Transportation costs)",0]
[null,null,0,"Oxalic acid vaporizer ",{"$f":"C15*VLOOKUP(D15,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Absorbent pads (<99)",{"$f":"G15*VLOOKUP(H15,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,0,"Electric Fence Warning Sign",{"$f":"O15*VLOOKUP(P15,Price_List!$B:$C,2,FALSE)","v":0},null,"Employee #2",null,0,0,{"$f":"U15*V15","v":0}]
[null,null,0,"Varox vapouriser ",{"$f":"C16*VLOOKUP(D16,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Absorbent pads (100-999)",{"$f":"G16*VLOOKUP(H16,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,0,"Other",0,null,"Employee #3",null,0,0,0]
[null,null,0,"Respirator",{"$f":"C17*VLOOKUP(D17,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Absorbent pads (>1000)",{"$f":"G17*VLOOKUP(H17,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,null,null,null,null,"Employee #4",null,0,0,0]
[null,null,0,"Respirator replacement cartridges ",{"$f":"C18*VLOOKUP(D18,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Varroa - Easy Check",{"$f":"G18*VLOOKUP(H18,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,null,null,null,null,"Employee #5",null,0,0,0]
[null,null,0,"Turbo Uncapping Fork",{"$f":"C19*VLOOKUP(D19,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Varroa sticky board ",{"$f":"G19*VLOOKUP(H19,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,null,null,null,null,"Employee #6",null,0,0,0]
[null,null,0,"Drip extraction: hobbyist uncapping kit ",{"$f":"C20*VLOOKUP(D20,Price_List!$B:$C,2,FALSE)","v":0},null,0,"American foulbrood test kit ",{"$f":"G20*VLOOKUP(H20,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,null,null,null,null,"Employee #7",null,0,0,0]
[null,null,0,"2-Frame Manual Hobby Extractor",{"$f":"C21*VLOOKUP(D21,Price_List!$B:$C,2,FALSE)","v":0},null,0,"European foulbrood Test kit ",{"$f":"G21*VLOOKUP(H21,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,null,null,null,null,"Employee #8",null,0,0,0]
[null,null,0,"4-Frame Manual Hobby Extractor",{"$f":"C22*VLOOKUP(D22,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Apistan strips – box of 100",{"$f":"G22*VLOOKUP(H22,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,null,null,null,null,"Employee #9",null,0,0,0]
[null,null,0,"Maxant 3100H 9-Frame Hand Extractor",{"$f":"C23*VLOOKUP(D23,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Apivar strips  – 60 pack ",{"$f":"G23*VLOOKUP(H23,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,null,null,null,null,"Employee #10",null,0,0,0]
[null,null,0,"Maxant 3100P 9-Frame Extractor",{"$f":"C24*VLOOKUP(D24,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Foric Acid jug – 20 L ",{"$f":"G24*VLOOKUP(H24,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,null,null,null,null,"Total Wages Paid ",null,null,null,{"$f":"SUM(W14:W23)","v":0}]
[null,null,0,"Industry membership ",{"$f":"C25*VLOOKUP(D25,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,0,"Other",0]
[null,null,0,"Hand dolly ",{"$f":"C26*VLOOKUP(D26,Price_List!$B:$C,2,FALSE)","v":0},null,0,"Other",0,null,0,"Other",0]
[null,null,0,"Folding hand truck",{"$f":"C27*VLOOKUP(D27,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Battery-operated vaporizer varrox eddy ",{"$f":"C28*VLOOKUP(D28,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"OxaVap ProVap 110 Vaporizer",{"$f":"C29*VLOOKUP(D29,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"OxaVap Cordless ProVap ",{"$f":"C30*VLOOKUP(D30,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"OxaVap ProVap EZ 110 vaporizer ",{"$f":"C31*VLOOKUP(D31,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Maxant Mobile Uncapping Tank ",{"$f":"C32*VLOOKUP(D32,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,{"$f":"IF(OR(SUM(E6:E69) = 0, SUM(I6:I26) = 0, SUM(M6:M26) = 0, SUM(Q6:Q16) = 0, SUM(U6:U10) = 0, SUM(AA6:AA14) = 0, W24 = 0), \"WARNING: One or more cost categories are blank! Review your cost categories to ensure the sheet is entirely complete.\", \"\")","v":"WARNING: One or more cost categories are blank! Review your cost categories to ensure the sheet is entirely complete."}]
[null,null,0,"Maxant 1400PL Extractor ",{"$f":"C33*VLOOKUP(D33,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Bottling tank (16 gallon)",{"$f":"C34*VLOOKUP(D34,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Bottling tank (25 gallon)",{"$f":"C35*VLOOKUP(D35,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"NSBA membership fees (0-49) ",{"$f":"C36*VLOOKUP(D36,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"NSBA membership fees (50-99) ",{"$f":"C37*VLOOKUP(D37,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"NSBA membership fees (100-499) ",{"$f":"C38*VLOOKUP(D38,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"NSBA membership fees (500+) ",{"$f":"C39*VLOOKUP(D39,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Fork Lift ",0]
[null,null,0,"Bee Crane/lift",0]
[null,null,0,"Hive Carrier",0]
[null,null,0,"Fork Lift ",0,null,null,null,null,null,"Beekeeping Costs (Do not edit these)",null,null,null,"Revenue "]
[null,null,0,"Bee Crane/lift",0,null,null,null,null,null,"Woodenware",null,{"$f":"'Hive Builder'!M13","v":{"$error":"#DIV/0!"}},null,null,"Source","Units Sold ","Selling Price/Unit ","Amount"]
[null,null,0,"Insurance Costs",0,null,null,null,null,null,"Bees/Livestock",null,{"$f":"'Hive Builder'!M14","v":{"$error":"#DIV/0!"}},null,"Nucleus Colonies",null,0,0,{"$f":"(Q45*R45)","v":0}]
[null,null,0,"Storage facility ",0,null,null,null,null,null,"One-time Costs",null,{"$f":"SUM(E6:E69)","v":0},null,"Pollination Services",null,0,0,{"$f":"(Q46*R46)","v":0}]
[null,null,0,"Utilities",0,null,null,null,null,null,"Mite Treatment",null,{"$f":"SUM(I6:I26)","v":0},null,"Honey Production",null,0,0,0]
[null,null,0,"Vehicle Costs",0,null,null,null,null,null,"Feeding",null,{"$f":"SUM(M6:M26)","v":0},null,"Full Colonies",null,0,0,0]
[null,"Overwintering & Hive Transportation Equipment",0,"Bee cozy double ",{"$f":"C49*VLOOKUP(D49,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,"Pest Control ",null,{"$f":"SUM(Q6:Q16)","v":0},null,"Wax crafts - Candles",null,0,0,0]
[null,null,0,"Bee cozy inner cover insulator ",{"$f":"C50*VLOOKUP(D50,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,"Fuel ",null,{"$f":"(U6*U7*U8*U9*(U10/100))","v":0},null,"Other",null,0,0,0]
[null,null,0,"Bee cozy single ",{"$f":"C51*VLOOKUP(D51,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,"Labour ",null,{"$f":"SUM(W14:W23)","v":0},null,"Total ",null,null,null,{"$f":"SUM(S45:S50)","v":0}]
[null,null,0,"Hogan double winter wrap ",{"$f":"C52*VLOOKUP(D52,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,"Miscellaneous",null,{"$f":"SUM(AA6:AA14)","v":0}]
[null,null,0,"Hogan single winter wrap ",{"$f":"C53*VLOOKUP(D53,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,"Total ",null,{"$f":"SUM(M44:M52)","v":{"$error":"#DIV/0!"}}]
[null,null,0,"Bee Dry double ",{"$f":"C54*VLOOKUP(D54,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Bee Dry Single",{"$f":"C55*VLOOKUP(D55,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Bee Dry Lid Insulation",{"$f":"C56*VLOOKUP(D56,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,"Product-Specific Costs"]
[null,null,0,"Quilting box",{"$f":"C57*VLOOKUP(D57,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,"Product-Specific Cost",null,"Per Unit","Total"]
[null,null,0,"Winter Rim sprucer ",{"$f":"C58*VLOOKUP(D58,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Additional costs per unit of \",O45,\" sold\")","v":"Additional costs per unit of Nucleus Colonies sold"},null,0,{"$f":"Q58*Q45","v":0}]
[null,null,0,"Migratory cover",{"$f":"C59*VLOOKUP(D59,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,"Additional costs per unit of Pollination Services sold",null,0,0]
[null,null,0,"Rachet straps – 1500lb (4 pack)",{"$f":"C60*VLOOKUP(D60,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,"Additional costs per unit of Honey Production sold",null,0,0]
[null,null,0,"Rachet straps – 300lb (4 pack)",{"$f":"C61*VLOOKUP(D61,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,"Additional costs per unit of Full Colonies sold",null,0,0]
[null,null,0,"Double 4-Frame Nuc Box",{"$f":"C62*VLOOKUP(D62,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,"Additional costs per unit of Wax crafts - Candles sold",null,0,0]
[null,null,0,"5 frame wood nuc box ",{"$f":"C63*VLOOKUP(D63,Price_List!$B:$C,2,FALSE)","v":0},null,null,null,null,null,null,null,null,null,"Additional costs per unit of Other sold",null,0,0]
[null,null,0,"Deluxe 4 frame nuc box kit ",{"$f":"C64*VLOOKUP(D64,Price_List!$B:$C,2,FALSE)","v":0}]
[null,null,0,"Wooden Pallet",0]
[null,null,0,"Other",0]
[null,null,0,"Other",0]
[null,null,0,"Other",0]
[null,null,0,"Other",0]

{"sheet":"Payback Calc. (One-Product)","index":3,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[[39,1,39,2],[39,4,39,5]]}
[]
[]
[]
[null,"Product being sold: ",1,null,null,null,null,null,null,null,{"$f":"B8","v":"Nucleus Colonies"},null,null,null,null,null,null,{"$f":"B8","v":"Nucleus Colonies"}]
[null,null,null,null,null,null,null,null,null,null,"Pollination Services (per hive)",null,null,null,null,null,null,"Pollination Services (per hive)"]
[null,null,null,null,null,null,null,null,null,null,"Honey Production",null,null,null,null,null,null,"Honey Production"]
[null,"Product Prices (Per Unit)",null,null,null,null,null,null,null,null,"Full Colonies",null,null,null,null,null,null,"Full Colonies"]
[null,{"$f":"'Cost and Revenue Input'!O45","v":"Nucleus Colonies"},0,null,null,null,null,null,null,null,"Wax crafts - Candles",null,null,null,null,null,null,"Wax crafts - Candles"]
[null,{"$f":"CONCATENATE('Cost and Revenue Input'!O46,\" (per hive)\")","v":"Pollination Services (per hive)"},0,null,null,null,null,null,null,null,"Other",null,null,null,null,null,null,"Other"]
[null,{"$f":"'Cost and Revenue Input'!O47","v":"Honey Production"},0,null,null,null,null,null,null,null,"Variable cost per colony"]
[null,{"$f":"'Cost and Revenue Input'!O48","v":"Full Colonies"},0,null,null,null,null,null,null,null,"Variable cost per hive"]
[null,{"$f":"'Cost and Revenue Input'!O49","v":"Wax crafts - Candles"},0]
[null,{"$f":"'Cost and Revenue Input'!O50","v":"Other"},{"$f":"'Cost and Revenue Input'!R50","v":0}]
[]
[null,"Number of Hives Required for Each Additional Unit Of:",null,null,null,null,null,null,null,null,"Hives to break even"]
[null,"Pollination Hive",1,null,null,null,null,null,null,null,"Barrels to break even"]
[null,{"$f":"B8","v":"Nucleus Colonies"},0,null,null,null,null,null,null,null,"Colonies to break even"]
[null,"Pollination Services (per hive)",0,null,null,null,null,null,null,null,"Colonies to break even"]
[null,"Honey Production",0]
[null,"Full Colonies",0]
[null,"Wax crafts - Candles",0]
[null,"Other",0]
[]
[null,"Additional cost per unit of production not already captured:"]
[]
[null,{"$f":"'Cost and Revenue Input'!O45","v":"Nucleus Colonies"},{"$f":"'Cost and Revenue Input'!Q58","v":0}]
[null,{"$f":"'Cost and Revenue Input'!O46","v":"Pollination Services"},{"$f":"'Cost and Revenue Input'!Q59","v":0}]
[null,{"$f":"'Cost and Revenue Input'!O47","v":"Honey Production"},{"$f":"'Cost and Revenue Input'!Q60","v":0}]
[null,{"$f":"'Cost and Revenue Input'!O48","v":"Full Colonies"},{"$f":"'Cost and Revenue Input'!Q61","v":0}]
[null,{"$f":"'Cost and Revenue Input'!O49","v":"Wax crafts - Candles"},{"$f":"'Cost and Revenue Input'!Q62","v":0}]
[null,{"$f":"'Cost and Revenue Input'!O50","v":"Other"},{"$f":"'Cost and Revenue Input'!Q63","v":0}]
[]
[]
[null,"Incremental Hives + Existing Hives",{"$f":"'Hive Builder'!H10+'Hive Builder'!G10","v":0}]
[]
[]
[null,"Product Name",{"$f":"CHOOSE($C$4,$R$4,$R$5,$R$6,$R$7,$R$8,$R$9)","v":"Nucleus Colonies"},null,"Product Price ",{"$f":"CHOOSE($C$4,$C$8,$C$9,$C$10,$C$11,$C$12,$C$13)","v":0}]
[]
[]
[null,"Variable Cost Summary (Hives Only)",null,null,"Break-Even Point Summary "]
[null,"Cost Type ","Amount ",null,{"$f":"CONCATENATE(\"Revenue per unit of \",CHOOSE($C$4,K4,K5,K6,K7,K8,K9))","v":"Revenue per unit of Nucleus Colonies"},{"$f":"F37","v":0}]
[null,"Mite Treatment",{"$f":"'Cost and Revenue Input'!M47","v":0},null,{"$f":"CONCATENATE(\"Variable cost per unit of \",CHOOSE($C$4,K4,K5,K6,K7,K8,K9))","v":"Variable cost per unit of Nucleus Colonies"},{"$f":"SUM((CHOOSE($C$4,C17,C18,C19,C20,C21,C22)*C50)+(CHOOSE($C$4,C26,C27,C28,C29,C30,C31)))","v":{"$error":"#DIV/0!"}}]
[null,"Feeding",{"$f":"'Cost and Revenue Input'!M48","v":0},null,"Contribution margin",{"$f":"F41-F42","v":{"$error":"#DIV/0!"}},"Note that if this number is not positive the calculator will not work as each unit is being sold at a loss."]
[null,"Pest Control ",{"$f":"'Cost and Revenue Input'!M49","v":0}]
[null,"Fuel ",{"$f":"'Cost and Revenue Input'!M50","v":0},null,"Total Incremental Fixed Cost ",{"$f":"(SUMPRODUCT('Cost and Revenue Input'!C6:C69,'Cost and Revenue Input'!E6:E69))+'Hive Builder'!M13+'Hive Builder'!M14","v":{"$error":"#DIV/0!"}}]
[null,"Labour ",{"$f":"'Cost and Revenue Input'!M51","v":0}]
[null,"Miscellaneous",{"$f":"'Cost and Revenue Input'!M52","v":0},null,"Years to break-even",{"$f":"F45/((C34*F37)-C48)","v":{"$error":"#DIV/0!"}}]
[null,"Total ",{"$f":"SUM(C42:C47)","v":0},null,"Total sales dollars to break even",{"$f":"F47*F37*C34","v":{"$error":"#DIV/0!"}}]
[null,"Hives",{"$f":"C34","v":0}]
[null,"Variable cost of hives",{"$f":"C48/C49","v":{"$error":"#DIV/0!"}}]

{"sheet":"Payback Calc. (Multi-Product)","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,2,12,3],[13,2,13,3]]}
[]
[]
[]
[null,"Product Name","Selling Price per Unit","Units sold","Annual Revenue"]
[null,{"$f":"'Cost and Revenue Input'!O45","v":"Nucleus Colonies"},{"$f":"'Cost and Revenue Input'!R45","v":0},{"$f":"'Cost and Revenue Input'!Q45","v":0},{"$f":"C5*D5","v":0}]
[null,{"$f":"'Cost and Revenue Input'!O46","v":"Pollination Services"},{"$f":"'Cost and Revenue Input'!R46","v":0},{"$f":"'Cost and Revenue Input'!Q46","v":0},0]
[null,{"$f":"'Cost and Revenue Input'!O47","v":"Honey Production"},{"$f":"'Cost and Revenue Input'!R47","v":0},{"$f":"'Cost and Revenue Input'!Q47","v":0},0]
[null,{"$f":"'Cost and Revenue Input'!O48","v":"Full Colonies"},{"$f":"'Cost and Revenue Input'!R48","v":0},{"$f":"'Cost and Revenue Input'!Q48","v":0},0]
[null,{"$f":"'Cost and Revenue Input'!O49","v":"Wax crafts - Candles"},{"$f":"'Cost and Revenue Input'!R49","v":0},{"$f":"'Cost and Revenue Input'!Q49","v":0},0]
[null,{"$f":"'Cost and Revenue Input'!O50","v":"Other"},{"$f":"'Cost and Revenue Input'!R50","v":0},{"$f":"'Cost and Revenue Input'!Q50","v":0},0]
[]
[]
[null,"Total Fixed Costs:",{"$f":"SUM('Cost and Revenue Input'!M44:M46)","v":{"$error":"#DIV/0!"}}]
[null,"Annual variable cost",{"$f":"'Payback Calc. (One-Product)'!C48","v":0}]
[]
[null,"Years to break-even",null,{"$f":"ROUNDUP(C13/(SUM(E5:E10)-C14),0)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"Number of units of \",B6,\" to sell\")","v":"Number of units of Pollination Services to sell"},null,{"$f":"ROUNDUP(D5*$D$16,0)","v":{"$error":"#DIV/0!"}}]
[null,"Number of units of Honey Production to sell",null,{"$error":"#DIV/0!"}]
[null,"Number of units of Full Colonies to sell",null,{"$error":"#DIV/0!"}]
[null,"Number of units of Wax crafts - Candles to sell",null,{"$error":"#DIV/0!"}]
[null,"Number of units of Other to sell",null,{"$error":"#DIV/0!"}]
[null,"Number of units of  to sell",null,{"$error":"#DIV/0!"}]

{"sheet":"Profit_and_Loss","index":5,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Company Name and Year (E.g. Siri's Beekeeping 2024)"]
["Projected Profit & Loss"]
[{"$f":"_xlfn.CONCAT(\"Produced on \", TEXT(TODAY(), \"dd/mm/yyyy\"))","v":"Produced on 12/12/2023"}]
["Revenues"]
[{"$f":"'Cost and Revenue Input'!O45","v":"Nucleus Colonies"},null,null,null,null,{"$f":"'Cost and Revenue Input'!S45","v":0},null,null,null,null,null,"Total variable expenses per hive",{"$f":"F21 / 40","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Cost and Revenue Input'!O46","v":"Pollination Services"},null,null,null,null,{"$f":"'Cost and Revenue Input'!S46","v":0},null,null,null,null,null,"Total fixed expenses per hive",{"$f":"F38 / 40","v":0}]
[{"$f":"'Cost and Revenue Input'!O47","v":"Honey Production"},null,null,null,null,{"$f":"'Cost and Revenue Input'!S47","v":0},null,null,null,null,null,"Total expenses per hive",{"$f":"M5 + M6","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Cost and Revenue Input'!O48","v":"Full Colonies"},null,null,null,null,{"$f":"'Cost and Revenue Input'!S48","v":0}]
[{"$f":"'Cost and Revenue Input'!O49","v":"Wax crafts - Candles"},null,null,null,null,{"$f":"'Cost and Revenue Input'!S49","v":0}]
[{"$f":"'Cost and Revenue Input'!O50","v":"Other"},null,null,null,null,{"$f":"'Cost and Revenue Input'!S50","v":0}]
["Total Revenues",null,null,null,null,{"$f":"SUM(F5:F10)","v":0}]
[]
["Expenses (Variable)"]
[{"$f":"'Cost and Revenue Input'!G5","v":"Mite Treatment "},null,null,null,null,{"$f":"'Cost and Revenue Input'!M47","v":0}]
[{"$f":"'Cost and Revenue Input'!K5","v":"Feeding"},null,null,null,null,{"$f":"'Cost and Revenue Input'!M48","v":0}]
[{"$f":"'Cost and Revenue Input'!O5","v":"Pest Control "},null,null,null,null,{"$f":"'Cost and Revenue Input'!M49","v":0}]
[{"$f":"'Cost and Revenue Input'!S5","v":"Fuel Costs"},null,null,null,null,{"$f":"'Cost and Revenue Input'!M50","v":0}]
[{"$f":"'Cost and Revenue Input'!S12","v":"Labour "},null,null,null,null,{"$f":"'Cost and Revenue Input'!M51","v":0}]
[{"$f":"'Cost and Revenue Input'!Y5","v":"Miscellaneous"},null,null,null,null,{"$f":"'Cost and Revenue Input'!M52","v":0}]
["Product-specific variable costs",null,null,null,null,{"$f":"'Cost and Revenue Input'!M53","v":{"$error":"#DIV/0!"}}]
["Total Variable Expenses",null,null,null,null,{"$f":"SUM(F14:F20)","v":{"$error":"#DIV/0!"}}]
[]
["Expenses (Fixed)",null,null,"Total Cost","# Of years of Use","Amount allocated to this year"]
[{"$f":"'Hive Builder'!H13","v":"Woodenware cost"},null,null,{"$f":"'Hive Builder'!M13","v":{"$error":"#DIV/0!"}},null,{"$f":"D24/E24","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Hive Builder'!H14","v":"Livestock/bee cost"},null,null,{"$f":"'Hive Builder'!M14","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]

{"sheet":"Price_List","index":6,"n_rows":169,"n_cols":3,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
["ID","Product Name","Cost"]
[null,"Fixed Costs"]
[1,"Vented Bee Jacket ",159.94999999999999]
[2,"Bee Veil ",33.950000000000003]
[3,"Bee Gloves (leather)",23.95]
[4,"Bee Gloves (cow skin)",36.950000000000003]
[5,"Bee Gloves (goat skin) ",38.25]
[6,"Hive tool ",9.9499999999999993]
[7,"Smoker & Shield (large)",46.95]
[8,"Smoker & Shield (medium)",39.950000000000003]
[9,"Bee Brush ",7.95]
[10,"Oxalic acid vaporizer ",119.95]
[11,"Varox vapouriser ",224.05]
[12,"Respirator",79.95]
[13,"Respirator replacement cartridges ",34.950000000000003]
[14,"Turbo Uncapping Fork",35.950000000000003]
[15,"Drip extraction: hobbyist uncapping kit ",229.95]
[16,"2-Frame Manual Hobby Extractor",385.99]
[17,"4-Frame Manual Hobby Extractor",485.99]
[18,"Maxant 3100H 9-Frame Hand Extractor",995]
[19,"Maxant 3100P 9-Frame Extractor",1595]
[20,"Industry membership ",115]
[21,"Hand dolly ",118]
[22,"Folding hand truck",79]
[23,"Battery-operated vaporizer varrox eddy ",729.95]
[24,"OxaVap ProVap 110 Vaporizer",735.95]
[25,"OxaVap Cordless ProVap ",854.95]
[26,"OxaVap ProVap EZ 110 vaporizer ",1095.95]
[27,"Maxant Mobile Uncapping Tank ",1995]
[28,"Maxant 1400PL Extractor ",2895]
[29,"Bottling tank (16 gallon)",2580]
[30,"Bottling tank (25 gallon)",3095]
[31,"NSBA membership fees (0-49) ",69]
[32,"NSBA membership fees (50-99) ",115]
[33,"NSBA membership fees (100-499) ",230]
[34,"NSBA membership fees (500+) ",402.5]
[35,"Fork Lift ","$20,000 – $45,000"]
[36,"Bee Crane/lift","$25,000 - $30,000"]
[null,"Mite Treatment "]
[37,"Apistan strips – box of 10 ",43.95]
[38,"Apivar strips – 4 pack ",25.95]
[39,"Apivar strips – 12 pack ",57.95]
[40,"Formic Pro Strips (2 doses)",26.95]
[41,"Formic Pro Strips (10 doses)",69.95]
[42,"Formic Pro Strips (30 doses)",189.95]
[43,"Thymovar (10 count)",48.5]
[44,"Oxalic Acid Dihydrate – 1 kg ",21.95]
[45,"Foric Acid jug – 1 L ",19]
[46,"absorbent pads (<99)",0.2]
[47,"absorbent pads (100-999)",0.15]
[48,"absorbent pads (>1000)",0.12]
[49,"Varroa - Easy Check",31.95]
[50,"Varroa sticky board ",6.95]
[51,"American foulbrood test kit ",24.95]
[52,"European foulbrood Test kit ",20.95]
[53,"Apistan strips – box of 100",354.95]
[54,"Apivar strips  – 60 pack ",215.95]
[55,"Foric Acid jug – 20 L ",138]
[null,"Feeding "]
[56,"2kg bag of Sugar (Walmart) ",3]
[57,"Ultra bee pollen pattie singles ",4.95]
[58,"Ultra bee pollen pattie (40)",170]
[59,"Global Polen pattie ",4.75]
[60,"Global pollen pattie (40)",144.94999999999999]
[61,"Hive alive fondant patties ",6.95]
[62,"Pro Winter Feed - 10lb Bucket",29.95]
[63,"Pro winter feed 50 lb bucket ",112.95]
[64,"Boardman Entrance Feeder",12.95]
[65,"Top Feeder - 10 frame ",33.950000000000003]
[66,"1-gallon cap and ladder feeder ",18.95]
[67,"Pail feeder 3.8 Litre",11.5]
[68,"2:1 feeding syrup (23L /32 kg)",49.95]
[null,"Over-Wintering & Hive Transportation"]
[69,"Bee cozy double ",21.25]
[70,"Bee cozy inner cover insulator ",4.95]
[71,"Bee cozy single ",18.25]
[72,"Hogan double winter wrap ",19.95]
[73,"Hogan single winter wrap ",18.95]
[74,"Bee Dry double ",19.95]
[75,"Bee Dry Single",16.95]
[76,"Bee Dry Lid Insulation",14.95]
[77,"Quilting box",21.75]
[78,"Winter Rim sprucer ",13.95]
[null,"Pest Control "]
[79,"Gallagher m60 fence energizer ",139.94999999999999]
[80,"Gallagher M120 Fence energizer",199.95]
[81,"Gallagher s20 solar fence energizer ",377.99]
[82,"Gallagher S40 Solar Fence Energizer",455.95]
[83,"Gallagher S100 Solar Fence Energizer",677.95]
[84,"Turbo wire 2.5mm ",80.489999999999995]
[85,"Turbo Braid Wire - 400m",149.99]
[86,"Fibreglass Corner Posts",12.5]
[87,"6' Grounding Rod",19.95]
[88,"Electric Fence Warning Sign",5.89]
[null,"Hive Costs (Fixed)"]
[89,"8-frame outer cover ",34.950000000000003]
[90,"Garden top hive cover with metal cap (8 or 10 frame)",55.95]
[91,"Garden top hive cover (no metal) **",39.950000000000003]
[92,"Metal Capped Telescoping Outer Cover**",29.95]
[93,"8 – frame inner cover ",10.95]
[94,"Deep inner cover (1-19) - 8 frame ",19.95]
[95,"Deep inner cover (20+) - 8 frame ",17.95]
[96,"Clear inner cover **",32.950000000000003]
[97,"8 - frame Inner cover (1-19) ",17.95]
[98,"8 - frame Inner cover (20+)",15.95]
[99,"Shallow super (assembled)",22.95]
[100,"Shallow super (unassembled)",19.5]
[101,"medium super (assembled)",25.95]
[102,"medium super (unassembled) ",18.95]
[103,"8 – frame medium super unassembled ",25.35]
[104,"8-Frame Metal Queen Excluder",18.5]
[105,"Wooden Framed Metal Queen Excluder",22.95]
[106,"Plastic Queen Excluder",9.9499999999999993]
[107,"8-Frame Deep Super (assembled)**",31.95]
[108,"deep super (assembled) 10 frame ",27.95]
[109,"Deep observation hive boxes (8 or 10 frame)",89.95]
[110,"deep super (unassembled) 8 or 10 frame ",20.95]
[111,"8-frame solid bottom board ",26.95]
[112,"8 frame screened bottom board ",39.5]
[113,"Solid bottom board **",23.75]
[114,"10 frame Screened Bottom Board",34.950000000000003]
[115,"8-frame entrance reducer ",4.75]
[116,"8-Frame Mouse Guard",10.95]
[117,"Slatted Rack (8 frame)",24.95]
[118,"Hive Stand 8 or 10 frame ",19.95]
[119,"Hive Stand (with legs) - 8 or 10 frame ",27.95]
[120,"Assembled medium wooden frame with wired wax foundation ",5.5]
[121,"Deep unassembled frames for plastic foundation **",22.5]
[122,"Pierco Deep Foundation ",19.95]
[123,"Unwaxed rite cell deep foundation ",1.9]
[124,"Permanent foundation deep ",1.95]
[125,"Medium unassembled frames for plastic foundation (10 pack)",22]
[126,"Permanent foundation medium ",1.7]
[127,"Assembled deep rite cell wooden frame ",5.15]
[128,"Assembled medium wooden frame with plastic foundation ",5.05]
[129,"Assembled Deep wooden frame with wired wax foundation ",5.95]
[130,"Assembled Deep Wooden Frame with wax coated foundation (1)",5.15]
[131,"Assembled Deep Wooden Frame with wax coated foundation (20-199)",5.05]
[132,"Assembled Deep Wooden Frame with wax coated foundation (200+)",4.8499999999999996]
[133,"Foundation Rods 10 pack ",0.95]
[134,"Frame wire ",13.95]
[135,"10 frame outer cover (metal capped telescoping outer cover)",29.95]
[136,"10 frame top feeder",33.950000000000003]
[137,"10 frame inner cover",17.95]
[138,"10 Frame Medium honey super assembled",25.95]
[139,"Assembled medium wood frame with plastic wax foundation",5.05]
[140,"Wooden Frame Metal Queen Excluder",22.95]
[141,"10 frame Deep Super brood chamber",27.95]
[142,"Assembled Deep wood frame with plastic wax foundation",5.15]
[143,"10 frame solid bottom board",23.95]
[144,"10 frame hive stand",19.95]
[145,"10 frame entrance reducer",4.75]
[146,"Galvanized Mouse Guard",7.95]
[null,"Other Costs"]
[147,"Local Bee Package",290]
[148,"Imported Queen ","$40 - $60 "]
[149,"Nuc colony - 4 frame",275]
[150,"Double 4-Frame Nuc Box",53]
[151,"Beginner kit ",159.94999999999999]
[152,"Standard kit ",319]
[153,"Deluxe Beginner Kit ",399.95]
[154,"5 frame wood nuc box ",65.95]
[155,"Deluxe 4 frame nuc box kit ",49.95]
[156,"Queen rearing frame ",14.95]
[157,"Wood cell bar ",2.0499999999999998]
[158,"Migratory cover",22.95]
[159,"Rachet straps – 1500lb (4 pack)",34.950000000000003]
[160,"Rachet straps – 300lb (4 pack)",39.99]
[161,"Subcontract out honey extraction ","$ 0.40 - $0.80 /lb"]