{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Costing Form Template","Scones","Pankcakes"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Costing Form Template","index":0,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,1,5,4],[6,1,6,4],[7,1,7,4]]}
[]
[null,"Ingredients","Quantity required","Quantity purchased","Cost per quantity purchased (ZAR)","Cost per quantity required (ZAR)"]
[{"$nulls":5},{"$f":"E3/D3*C3","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"E4/D4*C4","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$error":"#DIV/0!"}]
[null,"TOTAL",null,null,null,{"$f":"SUM(F3:F5)","v":{"$error":"#DIV/0!"}}]
[null,"NUMBER OF SERVINGS"]
[null,"PER SERVING",null,null,null,{"$f":"F6/F7","v":{"$error":"#DIV/0!"}}]

{"sheet":"Scones","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,9,4],[10,1,10,4]]}
[]
[null,"Ingredients","Quantity required","Quantity purchased","Cost per quantity purchased (ZAR)","Cost per quantity required (ZAR)"]
[null,"280 g cake flour",280,2500,30,{"$f":"E3/D3*C3","v":3.36}]
[null,"20 g baking powder",20,200,35,{"$f":"E4/D4*C4","v":3.5}]
[null,"2,5 ml salt",2.5,125,12,0.24]
[null,"50 g sugar",50,1000,17,0.85000000000000009]
[null,"100 g butter",100,500,50,10]
[null,"1 egg",1,12,36,3]
[null,"100 ml milk",100,2000,30,1.5]
[null,"TOTAL",null,null,null,{"$f":"SUM(F3:F9)","v":22.45}]
[null,"PER SERVING",null,null,null,{"$f":"F10/12","v":1.8708333333333333}]

{"sheet":"Pankcakes","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,1,5,4],[7,1,7,4],[6,1,6,4]]}
[]
[null,"Ingredients","Quantity required","Quantity purchased","Cost per quantity purchased (ZAR)","Cost per quantity required (ZAR)"]
[null,"Flour",{"$f":"250*6","v":1500},2500,30,{"$f":"E3/D3*C3","v":18}]
[null,"Egg",{"$f":"1*6","v":6},24,{"$f":"36*2","v":72},{"$f":"E4/D4*C4","v":18}]
[null,"Milk",{"$f":"300*6","v":1800},2000,30,27]
[null,"TOTAL",null,null,null,{"$f":"SUM(F3:F5)","v":63}]
[null,"NUMBER OF SERVINGS",null,null,null,{"$f":"12*6","v":72}]
[null,"PER SERVING",null,null,null,{"$f":"F6/F7","v":0.875}]