{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Indicator Summary","Data Entry","Data Storage"],"not_rendered":{"charts":5,"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":"Instructions","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,20,21]]}
[]
[null,"The goal of this spreadsheet is to simplify the use of common environmental indicators. There are four sheets in this workbook:\n    1. This Instructional page\n    2. The Indicator Summary page shows a graph of each of the recommended indicators over time\n    3. The Data Entry page, where you enter your current environmental data\n    4. The Data Storage page, where the full history of data from previous months is stored. Do not edit this page.\nTo use this spreadsheet:\n    1. Fill in each of the orange cells on the Data Entry page.\n    2. Select the appropriate units in the yellow cells (a drop-down menu will appear when you click in the cell). \n    3. Fill in the Normalization Factor cell with the appropriate value. Any of the cells other than the Normalization Factor can be left empty if you do not have the data to populate these cells. \n    4. Click the Save Data button. The data will be automatically copied to the Data Storage sheet, and the graphs will update (macros must be enabled for this to work).\nIt is important that each of the data points be recorded over the same time period, or they will not make sense. It is also important to use a consistent normalization factor to be able to compare data over time. If you enter a data point incorrectly, delete that line of data from the Data Storage sheet and reenter that data. \n"]

{"sheet":"Indicator Summary","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data Entry","index":2,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Date",null,"Enter year:",null,null,null,null,null,null,null,null,null,null,null,null,"Mass Unit",null,"Volume Units",null,"Normalization Units",null,null,null,null,null,{"$f":"DATEVALUE(B2&\" \"&C2)","v":"2017-05-01"}]
["Month that data is from","May",2017,null,null,null,null,null,null,null,null,null,null,null,null,"kg",null,"liter",null,"count of units",null,"day",null,"January"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ton",null,"m^3",null,"kg of product",null,"week",null,"February"]
["Data Type","Quantity","Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg",null,"m^3 of product",null,"month",null,"March"]
["Solid Waste Produced",9000,"ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"₡ of revenue",null,"year",null,"April"]
["Municipal Water Consumed",2200,"liter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"number of employees",null,null,null,"May"]
["Well Water Consumed",96.5,"m^3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June"]
["Waste Water Produced",850,"liter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July"]
["Electricity Consumed",56800,"kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August"]
["Fuel",null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September"]
["-Gasoline",65,"liter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October"]
["-Diesel",7153,"liter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November"]
["-LPG",320,"kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December"]
[]
["Normalization Factor",90,"m^3 of product"]
[]
["Indicator",null,null,"Normalized"]
["Solid Waste Production",{"$f":"B5*IF(C5=\"ton\", 1000, 1)","v":9000000},"kg",{"$f":"B18/B15","v":100000},{"$f":"CONCATENATE(C18, \" of \", A18, \"/\", IF($C$15=$T$2, \"unit\", $C$15))","v":"kg of Solid Waste Production/m^3 of product"}]
["Net Water Consumption",{"$f":"(B6*IF(C6=\"liter\", 0.001, 1))+(B7*IF(C7=\"liter\", 0.001, 1))-(B8*IF(C8=\"liter\", 0.001, 1))","v":97.850000000000009},"m^3",{"$f":"B19/B15","v":1.0872222222222223},"m^3 of Net Water Consumption/m^3 of product"]
["Electricity Consumption",{"$f":"B9","v":56800},"kWh",{"$f":"B20/B15","v":631.11111111111109},"kWh of Electricity Consumption/m^3 of product"]
["Gasoline Consumption",{"$f":"B11","v":65},"liter",{"$f":"B21/$B$15","v":0.72222222222222221},{"$f":"CONCATENATE(C21, \" of \", A21, \"/\", IF($C$15=$T$2, \"unit\", $C$15))","v":"liter of Gasoline Consumption/m^3 of product"}]
["Diesel Consumption",{"$f":"B12","v":7153},"liter",{"$f":"B22/$B$15","v":79.477777777777774},"liter of Diesel Consumption/m^3 of product"]
["LPG Consumption",{"$f":"B13","v":320},"m^3",{"$f":"B23/$B$15","v":3.5555555555555554},{"$f":"CONCATENATE(C23, \" of \", A23, \"/\", IF($C$15=$T$2, \"unit\", $C$15))","v":"m^3 of LPG Consumption/m^3 of product"}]

{"sheet":"Data Storage","index":3,"n_rows":5,"n_cols":25,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Date","Normalized Solid Waste Production","Normalized Net Water Consumption","Normalized Electricity Consumption","Normalized Gasoline Consumption","Normalized Diesel Consumption","Normalized LPG Consumption","Column4","Solid Waste Produced","Municipal Water Consumed","Wall Water Consumed","Waste Water Produced","Electricity Consumed","Gasoline","Diesel","LPG","Column1","Normalization Factor","Column2","Solid Waste Production","Net Water Consumption","Electricity Consumption","Gasoline Consumption","Diesel Consumption","LPG Consumption"]
["2017-02-01",112500,1.223125,710,0.8125,89.412499999999994,4,null,9000,2200,96.5,850,56800,65,7153,320,null,80,null,9000000,97.850000000000009,56800,65,7153,320]
["2017-03-01",100000,1.0872222222222223,631.11111111111109,0.72222222222222221,79.477777777777774,3.5555555555555554,null,9000,2200,96.5,850,56800,65,7153,320,null,90,null,9000000,97.850000000000009,56800,65,7153,320]
["2017-04-01",112500,1.223125,710,0.8125,89.412499999999994,4,null,9000,2200,96.5,850,56800,65,7153,320,null,80,null,9000000,97.850000000000009,56800,65,7153,320]
["2017-05-01",100000,1.0872222222222223,631.11111111111109,0.72222222222222221,79.477777777777774,3.5555555555555554,null,9000,2200,96.5,850,56800,65,7153,320,null,90,null,9000000,97.850000000000009,56800,65,7153,320]