{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Volumetrics","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Volumetrics","index":0,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,7],[8,0,8,7],[0,8,0,11]]}
["Detergent Tracking",null,null,null,null,null,null,null,"Month End Use Only!"]
["Site",null,"Manager"]
["Date","2013-02-08","Prior Date","2013-02-01"]
[null,"Count","% of Total",null,null,null,null,null,null,"Cars since Month End"]
["Traditional",0,{"$f":"IF($B$8<>0,+B5/$B$8,0)","v":0},null,null,null,null,null,{"$f":"+A5","v":"Traditional"},368]
["Extra Service Cars",0,{"$f":"IF($B$8<>0,+B6/$B$8,0)","v":0},null,null,null,null,null,{"$f":"+A6","v":"Extra Service Cars"},95]
[null,null,null,null,null,null,null,null,{"$f":"+A7","v":0},274]
["Total",0,{"$f":"SUM(C5,C6)","v":0},null,null,null,"$/Car All",{"$f":"IF(B8 > 0, (H11*D11+G22*D22)/B8, 0)","v":0},{"$f":"+A8","v":"Total"},{"$f":"SUM(J5:J6)","v":463},null,null,"Below $0.55=Green"]
[null,null,null,null,null,null,null,null,"* SME means \"Since Month End\"",null,null,null,"Above $0.55=Red"]
["Detergent","Use","Pump/Orofice/Etc.","Cars","Gals Used","Oz/Car","Cents / Oz","Cost/Car","Cars SME","Gals SME"]
["Traditional Detergents",null,null,{"$f":"SUM(AllCars)","v":0},null,null,null,{"$f":"SUM(H13:H21)","v":{"$error":"#DIV/0!"}},null,null,null,null,"Below $0.48=Green"]
[null,null,null,{"$f":"+$B$5","v":0},null,{"$f":"+(Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]]","v":{"$error":"#DIV/0!"}},null,{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J$5:$J$6)","v":463},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":{"$error":"#DIV/0!"}}]
["BC Hi PH 380","Second Presoak","HM 530/ Pink",0,null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},22.65,{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},{"$f":"SUM($J$5:$J$6)","v":463},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0},null,null,"Above $0.48=Red"]
["Hand soap","Prep Gun","HM 530/  Blue",0,null,{"$f":"+(Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]]","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGEIF(Inventory[[#Data],[Product]],Volumetrics[[#This Row],[Detergent]],Inventory[[#Data],[Cost / Gal]])/128* 100","v":3.6171875},{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J$5:$J$6)","v":463},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":{"$error":"#DIV/0!"}}]
["BC Smart Shine","Front Presoak","HM 530/ Pink",0,null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},26.49,{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},{"$f":"SUM($J$5:$J$6)","v":463},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0}]
["BC Low Ph 180","CTA #1","HM 530/ Pink",{"$f":"+$B$5","v":0},null,{"$f":"+(Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]]","v":{"$error":"#DIV/0!"}},12.99,{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":{"$error":"#DIV/0!"}},{"$f":"SUM($J$5:$J$6)","v":463},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":{"$error":"#DIV/0!"}}]
["One Step"," CTA #2","HM 530/  Blue",0,null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},12.99,{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},463,{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0}]
["BC Hi PH 3618","Second Presoak","HM 530 / Yellow",0,null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},14.4,{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},463,{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0}]
["BC Cold Wax","Drying Agent","HM 530/ Pink",{"$f":"SUM(AllCars)","v":0},null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},18.170000000000002,{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},463,{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0}]
["Hand soap","Mitts","N/A",{"$f":"SUM(AllCars)","v":0},null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},{"$f":"AVERAGEIF(Inventory[[#Data],[Product]],Volumetrics[[#This Row],[Detergent]],Inventory[[#Data],[Cost / Gal]])/128* 100","v":3.6171875},{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},463,{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0}]
["A960 Tire Shine","Tire Shine","N/A",{"$f":"SUM(AllCars)","v":0},null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},{"$f":"AVERAGEIF(Inventory[[#Data],[Product]],Volumetrics[[#This Row],[Detergent]],Inventory[[#Data],[Cost / Gal]])/128* 100","v":8.421875},{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},463,{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0}]
["Extra Service Detergent",null,null,{"$f":"SUM(ExtraServiceCars)","v":0},null,"Extra",{"$f":"+Volumetrics[[#This Row],[Cost/Car]]-H11","v":{"$error":"#DIV/0!"}},{"$f":"+SUM(H23:H26)+H11","v":{"$error":"#DIV/0!"}},null,null,null,null,"Below $0.20/0.68=Green"]
["CW657 Blue Foam","Triple Foam","HM 530/ Pink",{"$f":"SUM(ExtraServiceCars)","v":0},null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},{"$f":"AVERAGEIF(Inventory[[#Data],[Product]],Volumetrics[[#This Row],[Detergent]],Inventory[[#Data],[Cost / Gal]])/128* 100","v":5.875},{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},{"$f":"SUM($J$6:$J$6)","v":95},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0},null,null,"Above $0.20/0.68=red"]
["CW659 Cherry Foam","Triple Foam","HM 530/ Pink",{"$f":"SUM(ExtraServiceCars)","v":0},null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},{"$f":"AVERAGEIF(Inventory[[#Data],[Product]],Volumetrics[[#This Row],[Detergent]],Inventory[[#Data],[Cost / Gal]])/128* 100","v":8.109375},{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},{"$f":"SUM($J$6:$J$6)","v":95},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0}]
["CW658 Polish Yellow","Triple Foam","HM 530/ Pink",{"$f":"SUM(ExtraServiceCars)","v":0},null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},{"$f":"AVERAGEIF(Inventory[[#Data],[Product]],Volumetrics[[#This Row],[Detergent]],Inventory[[#Data],[Cost / Gal]])/128* 100","v":6.125},{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},{"$f":"SUM($J$6:$J$6)","v":95},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":0}]
["Flash dry","Rain X","HM 530/ Pink",{"$f":"SUM(ExtraServiceCars)","v":0},null,{"$f":"+IF(Volumetrics[[#This Row],[Cars]] > 0, (Volumetrics[[#This Row],[Gals Used]]*128)/Volumetrics[[#This Row],[Cars]], 0)","v":0},8.1999999999999993,{"$f":"+Volumetrics[[#This Row],[Oz/Car]]*Volumetrics[[#This Row],[Cents / Oz]]/100","v":0},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"+Volumetrics[[#This Row],[Cars SME]]*Volumetrics[[#This Row],[Oz/Car]]/128","v":{"$error":"#REF!"}}]
["Product","Last Week","Deliveries","Now","Used","Error","Cost / Gal","Value","Used SME","Deliv SME","Inv @ ME","$ @ ME"]
["BC Cold Wax",16,0,12,4,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},14.9,{"$f":"+G28*D28","v":178.8},{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":12},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":178.8}]
["Rain X",17.5,0,17.5,0,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},22,{"$f":"+G29*D29","v":385},{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":17.5},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":385}]
["CW657 Blue Foam",110.5,0,109.5,1,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},7.52,823.43999999999994,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":109.5},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":823.43999999999994}]
["CW659 Cherry Foam",7.5,0,6,1.5,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},10.38,62.28,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":6},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":62.28}]
["CW658 Polish Yellow",30,0,30,0,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},7.84,{"$f":"+G32*D32","v":235.2},{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":30},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":235.2}]
["A960 Tire Shine",5,0,0,5,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},10.78,0,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":0},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":0}]
["Signature Clean",16,0,16,0,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},8.99,143.84,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":16},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":143.84}]
["Hand soap Prep Gun",32,0,26,6,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},4.63,120.38,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":26},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":120.38}]
["Hand soap",95,0,89,6,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},4.63,412.07,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":{"$error":"#DIV/0!"}},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":{"$error":"#DIV/0!"}},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":{"$error":"#DIV/0!"}}]
["BC Hi Ph 3600",0,0,0,0,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},18.41,0,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":0},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":0}]
["BC One Step ",43.5,0,36.5,7,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},16.63,606.995,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":36.5},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":606.995}]
["BC Hi PH 380",23,30,44,9,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},27.64,1216.1600000000001,{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":44},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":1216.1600000000001}]
["BC Hi Ph 3618",37,55,63,29,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},18.41,{"$f":"G40*D40","v":1159.83},{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":63},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":1159.83}]
["BC Low Ph 180",11.5,0,11.5,0,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},33.909999999999997,{"$f":"+G41*D41","v":389.96499999999997},{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":{"$error":"#DIV/0!"}},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":{"$error":"#DIV/0!"}},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":{"$error":"#DIV/0!"}}]
["BC Smart Shine 130",11.5,0,6,5.5,{"$f":"Inventory[[#This Row],[Last Week]]+Inventory[[#This Row],[Deliveries]]-Inventory[[#This Row],[Used]]-Inventory[[#This Row],[Now]]","v":0},33.909999999999997,{"$f":"+G42*D42","v":203.45999999999998},{"$f":"SUMIF(Volumetrics[[#Data],[Detergent]], Inventory[[#This Row],[Product]], Volumetrics[[#Data],[Gals SME]])","v":0},null,{"$f":"+Inventory[[#This Row],[Now]]+Inventory[[#This Row],[Used SME]]-Inventory[[#This Row],[Deliv SME]]","v":6},{"$f":"+Inventory[[#This Row],[Inv @ ME]]*Inventory[[#This Row],[Cost / Gal]]","v":203.45999999999998}]
["Total Inventory On Hand",null,null,null,null,null,null,{"$f":"SUM(Inventory[Value])","v":5937.42},null,null,null,{"$f":"SUM(Inventory[$ @ ME])","v":{"$error":"#DIV/0!"}}]

{"sheet":"Instructions","index":1,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Load the spreadsheet."]
["Switch to the Volumetrics tab at the bottom."]
["Hit the \"Prepare for Today's readings\" button, Save a copy to someplace where you can find it."]
["The spreadsheet is not \"ready\", dates are all set up, inventory numbers are copies, and all your \"today\" fields clear out."]
["Verify your site name, manager name, today and last dates."]
["Inventory your detergent.  Fill in inventory values."]
["Enter your deliveries."]
["Fill in your volumetrics / detergents used."]
["Check that you don't have any errors (red in the error column). "]
[]
["What to do if you have a red in the \"Error\" column."]
[" An error indicates your inventory is wrong or your volumetrics is wrong.  Check your inventory number."]
["If your inventory is right, then you may have forgotten about some detergent that was either used (leak/spill) or delivered."]
["If you forgot to enter a delivery (the Error number is a negative number), enter that."]
["If you used some detergent that's not listed in the Volumetrics section, you'll need to enter the "]
["corrected number in volumetrics.  A leak counts as use, as does a spill or similar."]
["If you transferred some detergent to another site, that should be entered in deliveries as a negative number."]