{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["WaterUse","Parameters","LU_Data","Templates","Import_Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"WaterUse","index":0,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,2,0,15],[1,8,1,15],[7,6,8,6],[2,3,2,6],[3,3,3,6],[7,4,8,4],[7,5,8,5]]}
[null,null,"If prompted Enable the Content before using this Template"]
[null,null,"Water User Input Table",null,null,null,null,null,"INSTRUCTIONS:"]
[null,null,"Organization",null,null,null,null,null,"1. Enter Start Date",null,null,null,"5. Make sure breakdown totals match Total Water Use.",null,null,null,null," "]
[null,null,"User Name",null,null,null,null,null,"2. Select the Reporting Interval",null,null,null,"6. Complete the Uncertainty and Explanation columns."]
[null,null,"Start Date",null,"(e.g. mm/dd/yyyy)",null,null,null,"3. Enter the Total Water Use data.",null,null,null,"7. Save the spreadsheet"]
[null,null,"Reporting Interval","Select …",null,null,null,null,"4. Enter the Water Usebreakdowns.",null,null,null,"8. Return to the SGMA web site to import your data."]
[]
[null,"ROW_KEYS","Peroid Start Date",{"$f":"nextDate(C8)","v":{"$error":"#N/A"}},"Total","Uncertainty","Explanation/Comment"]
[null,null,"Peroid End Date",{"$f":"nextDate(D8)-1","v":{"$error":"#N/A"}}]
[null,null,"Total Groundwater Extraction per Period (ac-ft)"]
[null,"WU_TOTAL",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B11,InputRowDef[Row_Key],0))","v":"Total Water Use"},null,{"$f":"SUM(IF(Input_RowKeys=$B11,Input_InputRng))","v":0},"Select …"]
[null,null,"Groundwater Extraction by Water Use Sector (if available)"]
[null,"WU_URBAN",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B13,InputRowDef[Row_Key],0))","v":"Urban Total"},{"$f":"SUM(D14:D17)","v":0},{"$f":"SUM(IF(Input_RowKeys=$B13,Input_InputRng))","v":0},"Select …"]
[null,"WU_LANDSCAPE",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B14,InputRowDef[Row_Key],0))","v":"   Large Landscape "},null,{"$f":"SUM(IF(Input_RowKeys=$B14,Input_InputRng))","v":0},"Select …"]
[null,"WU_COM",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B15,InputRowDef[Row_Key],0))","v":"   Commericial "},null,{"$f":"SUM(IF(Input_RowKeys=$B15,Input_InputRng))","v":0},"Select …"]
[null,"WU_IND",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B16,InputRowDef[Row_Key],0))","v":"   Industrial "},null,{"$f":"SUM(IF(Input_RowKeys=$B16,Input_InputRng))","v":0},"Select …"]
[null,"WU_RES",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B17,InputRowDef[Row_Key],0))","v":"   Residential "},null,{"$f":"SUM(IF(Input_RowKeys=$B17,Input_InputRng))","v":0},"Select …"]
[null,"WU_AG",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B18,InputRowDef[Row_Key],0))","v":"Agricultural "},null,{"$f":"SUM(IF(Input_RowKeys=$B18,Input_InputRng))","v":0},"Select …"]
[null,"WU_WETLANDS",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B19,InputRowDef[Row_Key],0))","v":"Managed Wetlands "},null,{"$f":"SUM(IF(Input_RowKeys=$B19,Input_InputRng))","v":0},"Select …"]
[null,"WU_RECHARGE",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B20,InputRowDef[Row_Key],0))","v":"Managed Recharge "},null,{"$f":"SUM(IF(Input_RowKeys=$B20,Input_InputRng))","v":0},"Select …"]
[null,"WU_OTHERS",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B21,InputRowDef[Row_Key],0))","v":"Other sector"},null,{"$f":"SUM(IF(Input_RowKeys=$B21,Input_InputRng))","v":0},"Select …"]
[null,null,"Sub-Total",{"$f":"SUM(D14:D21)","v":0},{"$f":"SUM(E14:E21)","v":0}]
[null,null,"Water Use by Source Type (if available)"]
[null,"WU_SRC_GW",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B24,InputRowDef[Row_Key],0))","v":"Groundwater"},null,{"$f":"SUM(IF(Input_RowKeys=$B24,Input_InputRng))","v":0},"Select …"]
[null,"WU_SRC_SW",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B25,InputRowDef[Row_Key],0))","v":"Surface Water"},null,{"$f":"SUM(IF(Input_RowKeys=$B25,Input_InputRng))","v":0},"Select …"]
[null,"WU_SRC_RECYCLED",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B26,InputRowDef[Row_Key],0))","v":"Recycled"},null,{"$f":"SUM(IF(Input_RowKeys=$B26,Input_InputRng))","v":0},"Select …"]
[null,"WU_SRC_OTHER",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B27,InputRowDef[Row_Key],0))","v":"Other"},null,{"$f":"SUM(IF(Input_RowKeys=$B27,Input_InputRng))","v":0},"Select …"]
[null,null,"Sub-Total",{"$f":"SUM(D24:D27)","v":0},{"$f":"SUM(E24:E27)","v":0}]

{"sheet":"Parameters","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Range Name","Parameter Value","Comment"]
["addin_version",{"$f":"SgmaVersion()","v":"v1.0.6"}]
["input_user_name",{"$f":"IF(ISBLANK(user_name),\"\",user_name)","v":""},"(Java Write In) period start date user entered from interface"]
["input_organization",{"$f":"IF(ISBLANK(organization),\"\",organization)","v":""},"(Java Write In) period start date user entered from interface"]
["input_startDt",{"$f":"SgmaStartDt()","v":"00:00:00"},"(Java Write In) period start date user entered from interface"]
["input_endDt",{"$f":"SgmaEndDt()","v":"00:00:00"},"(Java Write In) period start date user entered from interface"]
["freq_code",{"$f":"INDEX(FreqOptions[FREQ_CODE],MATCH(freq_option,FreqOptions[FREQ_OPTION],0))","v":0},"The code currently selected Report Interval Option"]
["has_freq",{"$f":"(freq_code <> 0)","v":false},"(fixed number for each type of template)"]
["validated",{"$f":"AND(OR((Input_LuTotal=0),(Input_LuTotal=Input_GrandTotal)),OR((Input_SrcTotal=0),(Input_SrcTotal=Input_GrandTotal)))","v":true},"(fixed number for each type of template)"]
["num_columns",1]
["process_error","UpdateColumns Error: Start Date is empty or invalid"]
["has_error",{"$f":"AND((ISBLANK(process_error) = FALSE),(TRIM(process_error) <> \"\"))","v":true},"true if range[process_error] <> blank"]

{"sheet":"LU_Data","index":2,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Table[FreqOptions]"]
["FREQ_OPTION","FREQ_CODE"]
["Select …",0]
["Monthly",1]
["Bi-Monthly",2]
["Quarterly",3]
["Semi-Annual",4]
["Annual",5]
[]
[]
["Table[UncertaintyOptions]"]
["UNCERTAINTY_OPTION","UNCERTAINTY_CODE"]
["Select …",0]
["High",1]
["Medium",2]
["Low",3]

{"sheet":"Templates","index":3,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,4,2,4],[1,5,2,5],[1,6,2,6]]}
[null,"GWT Template Settings",null,null,null,null,null,null,null,null,"Table[InputRowDef]"]
[null,"ROW_KEYS","Peroid Start Date",{"$f":"nextDate(C2)","v":{"$error":"#N/A"}},"Total","Uncertainty","Explanation/Comment",null,null,null,"Row_Key","Row_Caption"]
[null,null,"Peroid End Date",{"$f":"nextDate(D2)-1","v":{"$error":"#N/A"}},null,null,null,null,null,null,"WU_TOTAL","Total Water Use"]
[null,null,"Total Water User per Period (ac-ft)",null,null,null,null,null,null,null,"WU_URBAN","Urban Total"]
[null,"WU_TOTAL",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B5,InputRowDef[Row_Key],0))","v":"Total Water Use"},null,{"$f":"SUM(IF(Input_RowKeys=$B5,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_LANDSCAPE","   Large Landscape "]
[null,null,"Water Use by Water Use Sector (if available)",null,null,null,null,null,null,null,"WU_COM","   Commericial "]
[null,"WU_URBAN",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B7,InputRowDef[Row_Key],0))","v":"Urban Total"},{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(IF(Input_RowKeys=$B7,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_IND","   Industrial "]
[null,"WU_LANDSCAPE",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B8,InputRowDef[Row_Key],0))","v":"   Large Landscape "},null,{"$f":"SUM(IF(Input_RowKeys=$B8,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_RES","   Residential "]
[null,"WU_COM",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B9,InputRowDef[Row_Key],0))","v":"   Commericial "},null,{"$f":"SUM(IF(Input_RowKeys=$B9,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_AG","Agricultural "]
[null,"WU_IND",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B10,InputRowDef[Row_Key],0))","v":"   Industrial "},null,{"$f":"SUM(IF(Input_RowKeys=$B10,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_WETLANDS","Managed Wetlands "]
[null,"WU_RES",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B11,InputRowDef[Row_Key],0))","v":"   Residential "},null,{"$f":"SUM(IF(Input_RowKeys=$B11,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_RECHARGE","Managed Recharge "]
[null,"WU_AG",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B12,InputRowDef[Row_Key],0))","v":"Agricultural "},null,{"$f":"SUM(IF(Input_RowKeys=$B12,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_OTHERS","Other sector"]
[null,"WU_WETLANDS",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B13,InputRowDef[Row_Key],0))","v":"Managed Wetlands "},null,{"$f":"SUM(IF(Input_RowKeys=$B13,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_SRC_GW","Groundwater"]
[null,"WU_RECHARGE",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B14,InputRowDef[Row_Key],0))","v":"Managed Recharge "},null,{"$f":"SUM(IF(Input_RowKeys=$B14,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_SRC_SW","Surface Water"]
[null,"WU_OTHERS",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B15,InputRowDef[Row_Key],0))","v":"Other sector"},null,{"$f":"SUM(IF(Input_RowKeys=$B15,Input_InputRng))","v":0},"Select …",null,null,null,null,"WU_SRC_RECYCLED","Recycled"]
[null,null,"Sub-Total",{"$f":"SUM(D8:D15)","v":0},{"$f":"SUM(E8:E15)","v":0},null,null,null,null,null,"WU_SRC_OTHER","Other"]
[null,null,"Water Use by Source Type (if available)"]
[null,"WU_SRC_GW",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B18,InputRowDef[Row_Key],0))","v":"Groundwater"},null,{"$f":"SUM(IF(Input_RowKeys=$B18,Input_InputRng))","v":0},"Select …"]
[null,"WU_SRC_SW",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B19,InputRowDef[Row_Key],0))","v":"Surface Water"},null,{"$f":"SUM(IF(Input_RowKeys=$B19,Input_InputRng))","v":0},"Select …"]
[null,"WU_SRC_RECYCLED",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B20,InputRowDef[Row_Key],0))","v":"Recycled"},null,{"$f":"SUM(IF(Input_RowKeys=$B20,Input_InputRng))","v":0},"Select …"]
[null,"WU_SRC_OTHER",{"$f":"INDEX(InputRowDef[Row_Caption],MATCH(B21,InputRowDef[Row_Key],0))","v":"Other"},null,{"$f":"SUM(IF(Input_RowKeys=$B21,Input_InputRng))","v":0},"Select …"]
[null,null,"Sub-Total",{"$f":"SUM(D18:D21)","v":0},{"$f":"SUM(E18:E21)","v":0}]

{"sheet":"Import_Data","index":4,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":true,"merged":[[1,5,1,16]]}
["Import Data Exchange Table[range = \"ImportTable\"]"]
[null,null,null,null,null,"Col_Idx"]
["Row_Idx","Row_Key","ROW_TOTAL","UNCERTAINTY_CODE","EXPLANATION",1,{"$f":"F3+1","v":2},{"$f":"G3+1","v":3},4,5,6,7,8,9,10,11,12]
[null,"START_DT",null,null,null,{"$f":"IF(F$3>num_columns,\"\",INDEX(Input_InputRng,1,F$3))","v":{"$error":"#N/A"}},"","","","","","","","","","",""]
[null,"END_DT",null,null,null,{"$f":"IF(F$3>num_columns,\"\",INDEX(Input_InputRng,2,F$3))","v":{"$error":"#N/A"}},"","","","","","","","","","",""]
[{"$f":"MATCH(B6,Input_RowKeys,0)","v":4},"WU_TOTAL",{"$f":"INDEX(Input_Summary,A6,1)","v":0},{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A6,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},{"$f":"IF(ISBLANK(INDEX(Input_Summary,A6,3)),\"\",INDEX(Input_Summary,A6,3))","v":""},{"$f":"IF(ISNUMBER(INDEX(Input_InputRng,$A6,F$3)),INDEX(Input_InputRng,$A6,F$3),\"\")","v":""},"","","","","","","","","","",""]
[6,"WU_URBAN",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A7,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"",0,"","","","","","","","","","",""]
[7,"WU_LANDSCAPE",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A8,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[8,"WU_COM",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A9,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[9,"WU_IND",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A10,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[10,"WU_RES",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A11,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[11,"WU_AG",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A12,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[12,"WU_WETLANDS",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A13,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[13,"WU_RECHARGE",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A14,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[14,"WU_OTHERS",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A15,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[{"$f":"MATCH(B16,Input_RowKeys,0)","v":17},"WU_SRC_GW",{"$f":"INDEX(Input_Summary,A16,1)","v":0},{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A16,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},{"$f":"IF(ISBLANK(INDEX(Input_Summary,A16,3)),\"\",INDEX(Input_Summary,A16,3))","v":""},"","","","","","","","","","","",""]
[18,"WU_SRC_SW",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A17,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[19,"WU_SRC_RECYCLED",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A18,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]
[20,"WU_SRC_OTHER",0,{"$f":"INDEX(UncertaintyOptions[UNCERTAINTY_CODE],MATCH(INDEX(Input_Summary,A19,2),UncertaintyOptions[UNCERTAINTY_OPTION],0))","v":0},"","","","","","","","","","","","",""]