{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Pivot","Template"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"Data","index":0,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["OBJECTID","MEAN","Type","Year","MONTH_NO"]

{"sheet":"Pivot","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of MEAN","Column Labels"]
[null,"(blank)"]
["Row Labels","(blank)"]
["(blank)"]

{"sheet":"Template","index":2,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["METRIC VALUES FROM GRIDED DATA"]
["MONTH_NO","MONTH","NORMAL_MEAN_PREC","NORMAL_MEAN_TEMP","2030_MEAN_PREC","2030_MEAN_TEMP","2050_MEAN_PREC","2050_MEAN_TEMP","2070_MEAN_PREC","2070_MEAN_TEMP"]
[1,"J",{"$f":"Pivot!B6","v":0},{"$f":"Pivot!C6","v":0},{"$f":"Pivot!D6","v":0},{"$f":"Pivot!E6","v":0},{"$f":"Pivot!F6","v":0},{"$f":"Pivot!G6","v":0},{"$f":"Pivot!H6","v":0},{"$f":"Pivot!I6","v":0}]
[2,"F",{"$f":"Pivot!B7","v":0},{"$f":"Pivot!C7","v":0},{"$f":"Pivot!D7","v":0},{"$f":"Pivot!E7","v":0},{"$f":"Pivot!F7","v":0},{"$f":"Pivot!G7","v":0},{"$f":"Pivot!H7","v":0},{"$f":"Pivot!I7","v":0}]
[3,"M",{"$f":"Pivot!B8","v":0},{"$f":"Pivot!C8","v":0},{"$f":"Pivot!D8","v":0},{"$f":"Pivot!E8","v":0},{"$f":"Pivot!F8","v":0},{"$f":"Pivot!G8","v":0},{"$f":"Pivot!H8","v":0},{"$f":"Pivot!I8","v":0}]
[4,"A",{"$f":"Pivot!B9","v":0},{"$f":"Pivot!C9","v":0},{"$f":"Pivot!D9","v":0},{"$f":"Pivot!E9","v":0},{"$f":"Pivot!F9","v":0},{"$f":"Pivot!G9","v":0},{"$f":"Pivot!H9","v":0},{"$f":"Pivot!I9","v":0}]
[5,"M",{"$f":"Pivot!B10","v":0},{"$f":"Pivot!C10","v":0},{"$f":"Pivot!D10","v":0},{"$f":"Pivot!E10","v":0},{"$f":"Pivot!F10","v":0},{"$f":"Pivot!G10","v":0},{"$f":"Pivot!H10","v":0},{"$f":"Pivot!I10","v":0}]
[6,"J",{"$f":"Pivot!B11","v":0},{"$f":"Pivot!C11","v":0},{"$f":"Pivot!D11","v":0},{"$f":"Pivot!E11","v":0},{"$f":"Pivot!F11","v":0},{"$f":"Pivot!G11","v":0},{"$f":"Pivot!H11","v":0},{"$f":"Pivot!I11","v":0}]
[7,"J",{"$f":"Pivot!B12","v":0},{"$f":"Pivot!C12","v":0},{"$f":"Pivot!D12","v":0},{"$f":"Pivot!E12","v":0},{"$f":"Pivot!F12","v":0},{"$f":"Pivot!G12","v":0},{"$f":"Pivot!H12","v":0},{"$f":"Pivot!I12","v":0}]
[8,"A",{"$f":"Pivot!B13","v":0},{"$f":"Pivot!C13","v":0},{"$f":"Pivot!D13","v":0},{"$f":"Pivot!E13","v":0},{"$f":"Pivot!F13","v":0},{"$f":"Pivot!G13","v":0},{"$f":"Pivot!H13","v":0},{"$f":"Pivot!I13","v":0}]
[9,"S",{"$f":"Pivot!B14","v":0},{"$f":"Pivot!C14","v":0},{"$f":"Pivot!D14","v":0},{"$f":"Pivot!E14","v":0},{"$f":"Pivot!F14","v":0},{"$f":"Pivot!G14","v":0},{"$f":"Pivot!H14","v":0},{"$f":"Pivot!I14","v":0}]
[10,"O",{"$f":"Pivot!B15","v":0},{"$f":"Pivot!C15","v":0},{"$f":"Pivot!D15","v":0},{"$f":"Pivot!E15","v":0},{"$f":"Pivot!F15","v":0},{"$f":"Pivot!G15","v":0},{"$f":"Pivot!H15","v":0},{"$f":"Pivot!I15","v":0}]
[11,"N",{"$f":"Pivot!B16","v":0},{"$f":"Pivot!C16","v":0},{"$f":"Pivot!D16","v":0},{"$f":"Pivot!E16","v":0},{"$f":"Pivot!F16","v":0},{"$f":"Pivot!G16","v":0},{"$f":"Pivot!H16","v":0},{"$f":"Pivot!I16","v":0}]
[12,"D",{"$f":"Pivot!B17","v":0},{"$f":"Pivot!C17","v":0},{"$f":"Pivot!D17","v":0},{"$f":"Pivot!E17","v":0},{"$f":"Pivot!F17","v":0},{"$f":"Pivot!G17","v":0},{"$f":"Pivot!H17","v":0},{"$f":"Pivot!I17","v":0}]
["total",null,{"$f":"SUM(C3:C14)","v":0},null,{"$f":"SUM(E3:E14)","v":0},null,{"$f":"SUM(G3:G14)","v":0},null,{"$f":"SUM(I3:I14)","v":0}]
[null,"calib. metric",20,10]
[]
["ENGLISH VALUES CONVERTED FROM ABOVE"]
["UNITE NAME"]
["Area Name Here","Climate:","Normal (1950-2000)",{"$f":"CONCATENATE($A$20&\" \"&$B$20&\" \"&C20)","v":"Area Name Here Climate: Normal (1950-2000)"},"2030s",{"$f":"CONCATENATE($A$20&\" \"&$B$20&\" \"&E20)","v":"Area Name Here Climate: 2030s"},"2050s",{"$f":"CONCATENATE($A$20&\" \"&$B$20&\" \"&G20)","v":"Area Name Here Climate: 2050s"},"2070s",{"$f":"CONCATENATE($A$20&\" \"&$B$20&\" \"&I20)","v":"Area Name Here Climate: 2070s"},null,{"$f":"CONCATENATE($A$20&\" \"&$B$20&\" \"&C20&\", \"&E20&\", \"&G20&\", and \"&I20)","v":"Area Name Here Climate: Normal (1950-2000), 2030s, 2050s, and 2070s"}]
[null,"MONTH","NORMAL PREC","NORMAL TEMP","2030 PREC","2030 TEMP","2050 PREC","2050 TEMP","2070 PREC","2070 TEMP"]
[1,"J",{"$f":"C3*0.0393701","v":0},{"$f":"(((D3*0.1)/5)*9)+32","v":32},{"$f":"E3*0.0393701","v":0},{"$f":"(((F3*0.1)/5)*9)+32","v":32},{"$f":"G3*0.0393701","v":0},{"$f":"(((H3*0.1)/5)*9)+32","v":32},{"$f":"I3*0.0393701","v":0},{"$f":"(((J3*0.1)/5)*9)+32","v":32}]
[2,"F",0,{"$f":"(((D4*0.1)/5)*9)+32","v":32},0,32,0,{"$f":"(((H4*0.1)/5)*9)+32","v":32},0,32]
[3,"M",0,32,0,32,0,32,0,32]
[4,"A",0,32,0,32,0,32,0,32]
[5,"M",0,32,0,32,0,32,0,32]
[6,"J",0,32,0,32,0,32,0,32]
[7,"J",0,32,0,32,0,32,0,32]
[8,"A",0,32,0,32,0,32,0,32]
[9,"S",0,32,0,32,0,32,0,32]
[10,"O",0,32,0,32,0,32,0,32]
[11,"N",0,32,0,32,0,32,0,32]
[12,"D",0,32,0,32,0,32,0,32]
[null,"Total/Average",0,{"$f":"AVERAGE(D22:D33)","v":32},0,{"$f":"AVERAGE(F22:F33)","v":32},0,{"$f":"AVERAGE(H22:H33)","v":32},0,{"$f":"AVERAGE(J22:J33)","v":32}]
[]
[null,"calib. English",{"$f":"C16*0.0393701","v":0.78740199999999994},{"$f":"(((D16*0.1)/5)*9)+32","v":33.799999999999997}]
[]
[]
[null,"Values for axis adjustments",null,null,null,"When the pivot table is updated, the values for axis adjustments will update with max and min information"]
[null,"Axis","Temp","Precip",null,"for the Temperature and Precipitation axes of the tables. A macro then uses the information to adjust"]
[null,"max",{"$f":"CEILING(MAX(D22:D33,F22:F33,H22:H33,J22:J33),5)","v":35},{"$f":"CEILING(MAX(C22:C33,E22:E33,G22:G33,I22:I33),1)","v":0},null,"the min and max values for the line graphs so that 50 degrees F is level with 0.787 inches precipitation."]
[null,"min",{"$f":"FLOOR(MIN(D22:D33,F22:F33,H22:H33,J22:J33), 5)","v":30},{"$f":"FLOOR(H43,1)","v":-1}]
[null,"major tick",5,1,null,null,"Precip min calc.",{"$f":"(((50-C42)/(C41-50)*(D41-0.787))-0.787)*-1","v":-0.2623333333333332}]
[null,"minor tick",1,1]