{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Water","Introduction"],"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":"Water","index":0,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Sample Worksheet to Determine if you have Enough Water"]
[]
[]
[]
["Description","Counted","How","On Hand","Total","# Gallons","Total # of Gallons","Description"]
[null,"by:","Packed?","Quantity","Units","per Unit","per Type of Container"]
[]
["One Gallon Water Jug","Individual 1 Gal. Jug",1,1,{"$f":"C8*D8","v":1},1,{"$f":"F8*E8","v":1},"One Gallon Water Jug"]
["2.5 Gallon Water Jug","Individual 2.5 Gal. Jug",1,1,{"$f":"C9*D9","v":1},2.5,{"$f":"F9*E9","v":2.5},"2.5 Gallon Water Jug"]
["Five Gallon Water Container","Individual \"FiGal\" Container",1,5,{"$f":"C10*D10","v":5},5,{"$f":"F10*E10","v":25},"Five Gallon Water Container"]
["700 ml Sports Bottle - CASE OF 35","Case - (FULL CASES ONLY!)",35,2,{"$f":"C11*D11","v":70},0.185,{"$f":"F11*E11","v":12.95},"700 ml Sports Bottle - CASE OF 35"]
["500 ml Water Bottle - CASE OF 24 ","Case - (FULL CASES ONLY!)",24,3,{"$f":"C12*D12","v":72},0.13200000000000001,{"$f":"F12*E12","v":9.5040000000000013},"500 ml Water Bottle - CASE OF 24 "]
[null,null,null,null,null,null,{"$f":"SUM(G8:G12)","v":50.954000000000008}]
[]
[]
[]
["Notes:","Notes:","Notes:","Notes:","Notes:","Notes:","Notes:"]
[]
["The DESCRIPTION  in Column A","Column B  displays how we count","Column C displays ","Column D shows our ","Column E","Column F","Column G"]
["provides 2 pieces of information:","each item","how the item is packed","physical count","contains the","contains the multiplier","contains the total number of gallons"]
[null,null,null,"of each item","total units","to convert each item","for each size container, as well"]
[null,"For example:","For example:","(By Unit or Case)","for each item","into gallons","as the TOTAL number of gallons that we"]
["1 The volume of the container","We count the GALLON container","Both the Jug and",null,null,null,"have on hand from all sources combined"]
["For example, 1 gallon, 5 gallon, 700ml, etc","by EACH ONE","Container are packed",null,"For example:","For example:"]
[null,null,"as single units.",null,"we have 2 cases","each 700 ml ","For example:"]
["2 How the item is received into our inventory","We count the 700 ML SPORTS BOTTLE",null,"For example:","which equals","Sports Bottle","our 72 bottles of 500ml"]
["For example: individual gallon, ","by the CASE","The Sports Bottles","we have 3 One Gallon Jugs","70 bottles","contains 0.185 gallons","Water Bottles is equal to"]
["or case of 35 bottles",null,"and Water Bottles","and 2 Cases of 700 ml","of  700 ml",null,"9.5 Gallons"]
[null,null,"are packed either in","Sports Bottle","Sports Bottle"]
[null,null,"35 per case, or 24 per case"]
[null,null,"respectively",null,null,null,"In Summary:"]
[]
[null,null,null,null,null,null,"Total # Gallons On Hand"]
[null,null,null,null,null,null,{"$f":"G13","v":50.954000000000008}]
[]
[null,null,null,null,null,null,"Number of People to Provide for"]
[null,null,null,null,null,null,"(In this example)"]
[null,null,null,null,null,null,3]
[]
[]
[null,null,null,null,null,null,"Total # of days (3 people)"]
[null,null,null,null,null,null,{"$f":"G34/3","v":16.984666666666669}]
[]
[null,null,null,null,null,null,"We have enough water on hand"]
[null,null,null,null,null,null,"for 17 days for 3 people"]

{"sheet":"Introduction","index":1,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do you have enough water to survive an emergency?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This Excel spreadsheet will illustrate how to determine if you have enough water available for an emergency."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most experts say an absolute minimum would be:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One gallon of drinkable water per person per day for a minimum of 3 days. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As an example, a family of 4 would need a minimum of 12 gallons to survive a 3 day emergency. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How much water do You have?"]