{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Inputs","Baseline Usage","Post Usage","Project Review","AEG Import","Calculations","CoC Data","Version Tracking"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"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":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[4,5,4,12],[6,4,6,7],[2,5,2,12],[3,5,3,12],[20,2,20,12],[15,3,15,12],[18,2,18,12],[32,5,32,6],[32,7,32,12],[33,3,33,4],[5,2,5,12],[31,3,31,4],[31,5,31,6],[31,7,31,12],[32,3,32,4],[26,3,26,4],[9,2,9,12],[13,3,13,12],[14,3,14,12],[16,3,16,12],[30,2,30,12],[27,3,27,4],[28,3,28,4],[25,2,25,12],[33,5,33,6],[33,7,33,12],[37,5,37,6],[36,7,36,12],[37,7,37,12],[35,2,35,12],[36,3,36,4],[37,3,37,4],[36,5,36,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[28,7,28,12],[27,7,27,12],[26,7,26,12],[39,2,39,12],[41,2,41,12],[44,2,44,12],[49,3,49,5],[48,3,48,5],[47,3,47,5],[46,3,46,5],[45,3,45,5],[45,6,45,7],[46,6,46,7],[47,6,47,7],[48,6,48,7],[49,6,49,7],[45,2,49,2],[42,3,42,12],[56,2,56,5],[56,6,56,7],[56,8,56,12],[47,8,47,12],[45,8,45,12],[46,8,46,12],[48,8,48,12],[49,8,49,12],[63,5,63,6],[11,3,11,12],[59,2,59,12],[63,3,63,4],[62,3,62,4],[61,3,61,4],[61,5,61,6],[62,5,62,6],[63,7,63,12],[62,7,62,12],[61,7,61,12],[50,2,50,5],[50,6,50,7],[50,8,50,12],[52,2,52,12],[54,3,54,12]]}
[]
[]
[null,null,null,null,null,"Cooling Tower Rebates"]
[null,null,null,null,null,"Equipment Information Workbook Instructions"]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Version \",'Version Tracking'!C4)","v":"Version 1.1"}]
[null,null,"This worksheet is required for all applications for cooling tower rebates. The worksheet must be completed and uploaded to the Application Portal"]
[null,null,"located at:",null,"Online Application Portal"]
[null,null,"Cooling tower technical requirements can be found on the Resources page of the Application Portal. ",null,null,null,null,null,null,null,null,"Resources Page"]
[]
[null,null,"Instructions"]
[]
[null,null,"1.","This worksheet should be used for information for a single chilled water plant or process cooling application - cannot be used where the tower directly cools the process water without a chiller."]
[]
[null,null,"2.","Enter the required project information in the shaded areas only. A description of this information is provided below."]
[null,null,null,"- All other information will be populated automatically."]
[null,null,"3.","Save file with a project name and date using the naming convention: project name_YY_MM_DD.xls"]
[null,null,"4.","Upload the this worksheet to the supporting documents section of your online application. "]
[]
[null,null,"Inputs Tab"]
[]
[null,null,"Customer and Project Information Section"]
[null,null,null,"Provide the requested information"]
[]
[null,null,"Cooling Tower and Chiller Plant Information Section"]
[]
[null,null,"Cooling Tower Information"]
[null,null,null,"Manufacturer",null,"Open Input",null,"Provide manufacturer's name"]
[null,null,null,"Model",null,"Open Input",null,"Provide Model Number"]
[null,null,null,"Capacity",null,"Open Input",null,"Provide rated Tons for towers serving chillers\nProvide gross MBTUH heat rejection capacity for towers serving non-chiller process loads"]
[]
[null,null,"Chiller Information"]
[null,null,null,"Manufacturer",null,"Open Input",null,"Provide manufacturer's name"]
[null,null,null,"Model",null,"Open Input",null,"Provide Model Number"]
[null,null,null,"Capacity",null,"Open Input",null,"Provide rated tons at AHRI standard conditions for chiller"]
[]
[null,null,"Tower Operating Schedule"]
[null,null,null,"Weeks / Year",null,"Open Input",null,"Number of weeks per year the system typically operates"]
[null,null,null,"Hours / Week",null,"Open Input",null,"Number of hours per week the system typically operates"]
[]
[null,null,"If more than three input rows are needed for Tower or Chiller information please contact the JEA Business Rebates Program at jeabusiness@icf.com or (844) 604-4393."]
[]
[null,null,"Proposed Cooling Tower Cycles of Concentration (CoC) Improvements Section"]
[null,null,null,"Provide a brief description how the proposed CoC increase will be achieved and maintained. Additional information and detail may be required during the project review and approval process."]
[]
[null,null,"Current Tower Conditions"]
[null,null,null,"CoC",null,null,"Open Input",null,"Current Cycles of Concentration for tower water"]
[null,null,null,"Sump Conductivity",null,null,"Open Input",null,"Conductivity of tower sump water in uS/cm"]
[null,null,null,"Sump TDS",null,null,"Open Input",null,"Equivalent total dissolved solids of sump water in PPM"]
[null,null,null,"MU Water Conductivity",null,null,"Open Input",null,"Conductivity of make-up water in uS/cm"]
[null,null,null,"MU Water TDS",null,null,"Open Input",null,"Equivalent total dissolved solids of make-up water in PPM"]
[null,null,"Target CoC",null,null,null,"Open Input",null,"Cycles of Concentration project is intended to meet"]
[]
[null,null,"Cooling Tower Water Usage Reductions Not Related to CoC Improvement Section"]
[]
[null,null,null,"Provide a brief description the  proposed cooling tower water usage reductions not related to CoC increase and how the reductions will be achieved and maintained. Additional information and detail may be required during the project review and approval process."]
[]
[null,null,"Projected Annual Cooling Tower Water Usage Reductions Not Related to CoC Improvement",null,null,null,"Open Input"]
[]
[null,null,"Baseline Usage and Post Usage Tabs"]
[null,null,"Provide water meter readings for make-up and blowdown water for minimum 30-day periods before any tower water reduction measures are installed and after all water reduction measures are installed and fully operational on the appropriate tab. Daily meter readings are preferred and no reading interval shall exceed four days.\nCompletely fill the lefthand data collection table before any entry of data in the right hand section. The righthand section header will automatically indicate when to use the righthand section."]
[]
[null,null,null,"Date",null,"Open Input",null,"Input date of meter reading in MM/DD/YYY format"]
[null,null,null,"Meter Reading",null,"Open Input",null,"Input meter reading in gallons. Do not calculate gallons difference of readings."]
[null,null,null,"GPD",null,"Calculated",null,"Calculated GPD usage based on date and meter reading values. \n'Invalid Date' Indicates associated date is out of chronological order."]

{"sheet":"Inputs","index":1,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,2,11,4],[11,5,11,7],[13,2,13,4],[2,5,2,15],[3,5,3,15],[10,5,10,7],[9,5,9,7],[8,5,8,7],[7,5,7,7],[6,1,6,12],[5,1,5,15],[8,2,8,4],[7,2,7,4],[9,2,9,4],[10,2,10,4],[11,9,11,11],[10,9,10,11],[9,9,9,11],[8,9,8,11],[7,9,7,11],[11,12,11,14],[10,12,10,14],[9,12,9,14],[8,12,8,14],[7,12,7,14],[18,6,18,7],[17,6,17,7],[20,4,20,5],[19,4,19,5],[14,1,14,15],[16,1,16,7],[18,4,18,5],[17,4,17,5],[20,1,20,3],[19,1,19,3],[18,1,18,3],[17,1,17,3],[16,9,16,15],[17,9,17,11],[17,12,17,13],[17,14,17,15],[18,9,18,11],[18,12,18,13],[18,14,18,15],[24,1,24,15],[19,9,19,11],[19,12,19,13],[19,14,19,15],[20,9,20,11],[20,12,20,13],[20,14,20,15],[20,6,20,7],[19,6,19,7],[21,1,21,15],[22,1,22,4],[22,5,22,6],[22,7,22,8],[22,11,22,12],[26,1,26,15],[25,1,25,15],[28,13,28,15],[28,1,29,2],[28,4,28,5],[29,4,29,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,29,12],[29,13,29,15],[29,10,29,11],[29,8,29,9],[29,6,29,7],[36,1,36,15],[40,1,40,15],[42,2,42,12],[31,1,31,15],[32,1,32,15],[33,1,33,15],[35,1,35,15],[37,1,37,15],[34,1,34,13],[34,14,34,15],[43,2,43,12],[43,13,43,14],[42,13,42,14],[46,2,46,14],[38,1,38,15],[39,1,39,15],[49,2,49,14],[44,2,44,12],[44,13,44,14],[48,2,48,14],[47,7,47,9],[47,2,47,6],[47,10,47,14]]}
[]
[]
[null,null,null,null,null,"Cooling Tower Rebates"]
[null,null,null,null,null,"Equipment Information"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Version \",'Version Tracking'!C4)","v":"Version 1.1"}]
[null,"Customer and Project Information"]
[]
[null,null,"Customer Name ",null,null,null,null,null,null,"Project Name "]
[null,null,"Customer Contact ",null,null,null,null,null,null,"Contractor Name"]
[null,null,"Customer Address",null,null,null,null,null,null,"Contractor Contact"]
[null,null,"Customer Phone",null,null,null,null,null,null,"Contactor Email"]
[null,null,"Customer Email",null,null,null,null,null,null,"Total Estimated Project Cost"]
[]
[null,null,"Input Cells - Blue Only"]
[null,"Cooling Tower and Chiller Plant Information"]
[]
[null,"Cooling Tower Information",null,null,null,null,null,null,null,"Chiller Information"]
[null,"Manufacturer",null,null,"Model",null,"Capacity\n(Tons or Gross MBTUH)",null,null,"Manufacturer",null,null,"Model",null,"Capacity\n(Tons)"]
[]
[]
[]
[]
[null,"Tower Operating Schedule",null,null,null,"Weeks / Year",null,null,null,"Hours / Week"]
[]
[null,"Proposed Cooling Tower Cycles of Concentration (CoC) Improvements"]
[null,"Provide a brief description how the proposed CoC increase will be achieved and maintained. Additional information and detail may be required during the project review and approval process."]
[]
[]
[null,"Current Tower Conditions",null,"CoC","Sump Conductivity",null,"Sump TDS",null,"MU Water Conductivity",null,"MU Water TDS",null,null,"Target CoC"]
[]
[]
[null,"Cooling Tower Water Usage Reductions Not Related to CoC Improvement"]
[null,"Provide a brief description the  proposed cooling tower water usage reductions not related to CoC increase and how the reductions will be achieved and maintained. Additional information and detail may be required during the project review and approval process."]
[]
[null,"Projected Annual Cooling Tower Water Usage Reductions Not Related to CoC Improvement"]
[null,"Baseline Cooling Tower Water Usage"]
[null,"Baseline cooling tower water usage must be based on a minimum 30-day monitoring of make-up and blowdown water quantities. If water meters will be installed as part of the water efficiency project no additional measures shall be installed until after the water meters have been installed and monitored for a minimum of 30 days and the data reported to JEA for review and approval. Enter the meter readings on the Baseline Usage tab."]
[]
[null,"Post Installation Cooling Tower Water Usage"]
[null,"Post installation cooling tower water usage must be based on a minimum 30-day monitoring of make-up and blowdown water usage after all water efficiency measures are installed and operational. Enter the post installation meter readings on the Post Usage tab and submit the completer Worksheet to JEA for review and approval."]
[null,"Projected Annual Water Usage Reductions and Estimated Rebate"]
[]
[null,null,"Projected Annual Water Savings from CoC Improvement (Million Gallons)",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(Calculations!E24/1000000,0)","v":0}]
[null,null,"Projected Annual Water Savings from Non-CoC Reductions (Million Gallons)",null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!O35/1000000","v":0}]
[null,null,"Projected Total Annual Water Savings Reductions (Million Gallons)",null,null,null,null,null,null,null,null,null,null,{"$f":"N43+N44","v":0}]
[]
[null,null,"Estimated Project Rebate Based On The Projected Savings Shown Above:"]
[null,null,null,null,null,null,null,{"$f":"IFERROR(Calculations!E29,0)","v":0}]
[null,null,{"$f":"IFERROR(IF(Calculations!E29<Calculations!E28,_xlfn.CONCAT(\"Rebate Has Been Capped at the $30,000 Project Rebate Cap\"),\"\"),\"\")","v":""}]
[null,null,"This estimated rebate amount is subject to adjustment based on actual post installation water usage reductions determined using baseline and post installation make-up water usage.\nThe rebate is also subject to a $30,000 per project rebate cap and maximum $30,000 per year water measures rebate per tax ID."]

{"sheet":"Baseline Usage","index":2,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,1,9,8],[9,9,9,16],[33,1,33,2],[32,1,32,2],[31,1,31,2],[30,1,30,2],[29,1,29,2],[28,1,28,2],[27,1,27,2],[26,1,26,2],[25,1,25,2],[24,1,24,2],[23,1,23,2],[22,1,22,2],[32,3,32,4],[31,3,31,4],[30,3,30,4],[29,3,29,4],[28,3,28,4],[21,1,21,2],[20,1,20,2],[19,1,19,2],[18,1,18,2],[12,3,12,4],[2,5,2,16],[4,5,4,16],[10,3,10,5],[10,6,10,8],[11,3,11,4],[11,6,11,7],[10,11,10,13],[17,1,17,2],[16,1,16,2],[10,14,10,16],[11,11,11,12],[11,14,11,15],[12,1,12,2],[13,3,13,4],[13,6,13,7],[12,6,12,7],[12,9,12,10],[15,9,15,10],[12,11,12,12],[12,14,12,15],[13,9,13,10],[13,11,13,12],[13,14,13,15],[14,9,14,10],[5,1,5,8],[33,6,33,7],[32,6,32,7],[31,6,31,7],[30,6,30,7],[29,6,29,7],[21,3,21,4],[20,3,20,4],[19,3,19,4],[18,3,18,4],[17,3,17,4],[16,3,16,4],[27,3,27,4],[26,3,26,4],[25,3,25,4],[24,3,24,4],[23,3,23,4],[22,3,22,4],[15,1,15,2],[14,1,14,2],[13,1,13,2],[33,3,33,4],[28,6,28,7],[27,6,27,7],[26,6,26,7],[25,6,25,7],[24,6,24,7],[23,6,23,7],[15,3,15,4],[14,3,14,4],[16,6,16,7],[15,6,15,7],[14,6,14,7],[22,6,22,7],[21,6,21,7],[20,6,20,7],[19,6,19,7],[18,6,18,7],[17,6,17,7],[14,11,14,12],[14,14,14,15],[20,11,20,12],[20,14,20,15],[21,9,21,10],[21,11,21,12],[21,14,21,15],[18,9,18,10],[18,11,18,12],[18,14,18,15],[19,9,19,10],[19,11,19,12],[19,14,19,15],[20,9,20,10],[15,11,15,12],[15,14,15,15],[16,9,16,10],[16,11,16,12],[16,14,16,15],[17,9,17,10],[17,11,17,12],[17,14,17,15],[24,9,24,10],[24,11,24,12],[24,14,24,15],[25,9,25,10],[25,11,25,12],[25,14,25,15],[22,9,22,10],[22,11,22,12],[22,14,22,15],[23,9,23,10],[23,11,23,12],[23,14,23,15],[28,9,28,10],[28,11,28,12],[28,14,28,15],[29,9,29,10],[29,11,29,12],[29,14,29,15],[26,9,26,10],[26,11,26,12],[26,14,26,15],[27,9,27,10],[27,11,27,12],[27,14,27,15],[6,2,6,5],[6,7,7,15],[3,5,3,16],[35,1,35,2],[35,3,35,4],[35,6,35,7],[35,9,35,10],[35,11,35,12],[35,14,35,15],[10,9,11,10],[10,1,11,2],[5,9,5,16],[32,9,32,10],[32,11,32,12],[32,14,32,15],[33,9,33,10],[33,11,33,12],[33,14,33,15],[30,9,30,10],[30,11,30,12],[30,14,30,15],[31,9,31,10],[31,11,31,12],[31,14,31,15]]}
[]
[]
[null,null,null,null,null,"Cooling Tower Rebates"]
[null,null,null,null,null,"Baseline Water Usage Data"]
[]
[]
[null,null,"Input Cells - Blue Only",null,null,null,null,"Provide Meter Readings for a 30-day minimum period.\nUpload the this worksheet to the supporting documents section of your online application when baseline usage information is complete."]
[]
[]
[null,"Completely Fill This Section First",null,null,null,null,null,null,null,{"$f":"IF(COUNT(B14:B35)<22,\"Complete Lefthand Section First\",\"This Section Can Be Used\")","v":"Complete Lefthand Section First"}]
[null,"Date \n(In chronolgical order)",null,"Make-Up water",null,null,"Blow-Down Water",null,null,"Date \n(In chronolgical order)",null,"Make-Up water",null,null,"Blow-Down Water"]
[null,null,null,"Meter Reading (Gallons)",null,"GPD","Meter Reading (Gallons)",null,"GPD",null,null,"Meter Reading (Gallons)",null,"GPD","Meter Reading (Gallons)",null,"GPD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(J13=\"\",\"\",IF(J13-B34<0,\"Invalid Date\",ROUND((D34-L13)/(B34-J13),0))),\"\")","v":""},null,null,{"$f":"IFERROR(IF(J13=\"\",\"\",IF(J13-B34<0,\"Invalid Date\",ROUND((O13-G34)/(J13-B34),0))),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(B14=\"\",\"\",IF(B14-B13<0,\"Invalid Date\",ROUND((D14-D13)/(B14-B13),0))),\"\")","v":""},null,null,{"$f":"IFERROR(IF(B14=\"\",\"\",IF(B14-B13<0,\"Invalid Date\",ROUND((G14-G13)/(B14-B13),0))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(J14=\"\",\"\",IF(J14-B35<0,\"Invalid Date\",ROUND((D35-L14)/(B35-J14),0))),\"\")","v":""},null,null,{"$f":"IFERROR(IF(J14=\"\",\"\",IF(J14-B35<0,\"Invalid Date\",ROUND((O14-G35)/(J14-B35),0))),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(B15=\"\",\"\",IF(B15-B14<0,\"Invalid Date\",ROUND((D15-D14)/(B15-B14),0))),\"\")","v":""},null,null,{"$f":"IFERROR(IF(B15=\"\",\"\",IF(B15-B14<0,\"Invalid Date\",ROUND((G15-G14)/(B15-B14),0))),\"\")","v":""},null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[]
[null,{"$f":"LOOKUP(2,1/(B13:B34<>\"\"),B13:B34)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(2,1/(D13:D34<>\"\"),D13:D34)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(2,1/(G13:G34<>\"\"),G13:G34)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(2,1/(J13:J34<>\"\"),J13:J34)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(2,1/(L13:L34<>\"\"),L13:L34)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(2,1/(O13:O34<>\"\"),O13:O34)","v":{"$error":"#N/A"}}]

{"sheet":"Post Usage","index":3,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[12,14,12,15],[13,1,13,2],[13,3,13,4],[13,14,13,15],[13,6,13,7],[13,9,13,10],[13,11,13,12],[12,11,12,12],[12,1,12,2],[12,3,12,4],[12,6,12,7],[12,9,12,10],[2,5,2,16],[3,5,3,16],[10,1,11,2],[10,3,10,5],[10,6,10,8],[10,9,11,10],[10,11,10,13],[10,14,10,16],[11,3,11,4],[11,6,11,7],[11,11,11,12],[11,14,11,15],[9,1,9,8],[9,9,9,16],[6,2,6,5],[5,1,5,16],[6,7,7,15],[14,14,14,15],[16,3,16,4],[16,6,16,7],[16,9,16,10],[16,11,16,12],[16,14,16,15],[15,1,15,2],[15,3,15,4],[15,6,15,7],[15,9,15,10],[15,11,15,12],[15,14,15,15],[16,1,16,2],[14,1,14,2],[14,3,14,4],[14,6,14,7],[14,9,14,10],[14,11,14,12],[17,9,17,10],[17,11,17,12],[17,14,17,15],[18,1,18,2],[18,3,18,4],[18,6,18,7],[18,9,18,10],[18,11,18,12],[18,14,18,15],[17,1,17,2],[17,3,17,4],[17,6,17,7],[19,1,19,2],[19,3,19,4],[19,6,19,7],[19,9,19,10],[19,11,19,12],[19,14,19,15],[20,1,20,2],[20,3,20,4],[20,6,20,7],[20,9,20,10],[20,11,20,12],[20,14,20,15],[21,1,21,2],[21,3,21,4],[21,6,21,7],[21,9,21,10],[21,11,21,12],[21,14,21,15],[22,1,22,2],[22,3,22,4],[22,6,22,7],[22,9,22,10],[22,11,22,12],[22,14,22,15],[25,1,25,2],[25,3,25,4],[25,6,25,7],[25,9,25,10],[25,11,25,12],[25,14,25,15],[23,1,23,2],[23,3,23,4],[23,6,23,7],[23,9,23,10],[23,11,23,12],[23,14,23,15],[24,1,24,2],[24,3,24,4],[24,6,24,7],[24,9,24,10],[24,11,24,12],[24,14,24,15],[28,1,28,2],[28,3,28,4],[28,6,28,7],[28,9,28,10],[28,11,28,12],[28,14,28,15],[27,1,27,2],[27,3,27,4],[27,6,27,7],[27,9,27,10],[27,11,27,12],[27,14,27,15],[26,1,26,2],[26,3,26,4],[26,6,26,7],[26,9,26,10],[26,11,26,12],[26,14,26,15],[30,1,30,2],[30,3,30,4],[30,6,30,7],[30,9,30,10],[30,11,30,12],[30,14,30,15],[29,1,29,2],[29,3,29,4],[29,6,29,7],[29,9,29,10],[29,11,29,12],[29,14,29,15],[32,1,32,2],[32,3,32,4],[32,6,32,7],[32,9,32,10],[32,11,32,12],[32,14,32,15],[31,1,31,2],[31,3,31,4],[31,6,31,7],[31,9,31,10],[31,11,31,12],[31,14,31,15],[35,1,35,2],[35,3,35,4],[35,6,35,7],[35,9,35,10],[35,11,35,12],[35,14,35,15],[33,1,33,2],[33,3,33,4],[33,6,33,7],[33,9,33,10],[33,11,33,12],[33,14,33,15]]}
[]
[]
[null,null,null,null,null,"Cooling Tower Rebates"]
[null,null,null,null,null,"Post Installation Water Usage Data"]
[]
[]
[null,null,"Input Cells - Blue Only",null,null,null,null,"Provide Meter Readings for a 30-day minimum period.\nUpload the this worksheet to the supporting documents section of your online application when post usage information is complete."]
[]
[]
[null,"Completely Fill This Section First",null,null,null,null,null,null,null,{"$f":"IF(COUNT(B14:B35)<22,\"Complete Lefthand Section First\",\"This Section Can Be Used\")","v":"Complete Lefthand Section First"}]
[null,"Date \n(In chronological order)",null,"Make-Up water",null,null,"Blow-Down Water",null,null,"Date \n(In chronological order)",null,"Make-Up water",null,null,"Blow-Down Water"]
[null,null,null,"Meter Reading (Gallons)",null,"GPD","Meter Reading (Gallons)",null,"GPD",null,null,"Meter Reading (Gallons)",null,"GPD","Meter Reading (Gallons)",null,"GPD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(J13=\"\",\"\",IF(J13-B34<0,\"Invalid Date\",ROUND((L13-D34)/(J13-B34),0))),\"\")","v":""},null,null,{"$f":"IFERROR(IF(J13=\"\",\"\",IF(J13-J12<0,\"Invalid Date\",ROUND((O13-G34)/(J13-B34),0))),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(B14=\"\",\"\",IF(B14-B13<0,\"Invalid Date\",ROUND((D14-D13)/(B14-B13),0))),\"\")","v":""},null,null,{"$f":"IFERROR(IF(B14=\"\",\"\",IF(B14-B13<0,\"Invalid Date\",ROUND((G14-G13)/(B14-B13),0))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(J14=\"\",\"\",IF(J14-B35<0,\"Invalid Date\",ROUND((L14-D35)/(J14-B35),0))),\"\")","v":""},null,null,{"$f":"IFERROR(IF(J14=\"\",\"\",IF(J14-J13<0,\"Invalid Date\",ROUND((O14-G35)/(J14-B35),0))),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(B15=\"\",\"\",IF(B15-B14<0,\"Invalid Date\",ROUND((D15-D14)/(B15-B14),0))),\"\")","v":""},null,null,{"$f":"IFERROR(IF(B15=\"\",\"\",IF(B15-B14<0,\"Invalid Date\",ROUND((G15-G14)/(B15-B14),0))),\"\")","v":""},null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[null,null,null,null,null,"",null,null,"",null,null,null,null,"",null,null,""]
[]
[null,{"$f":"LOOKUP(2,1/(B13:B34<>\"\"),B13:B34)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(2,1/(D13:D34<>\"\"),D13:D34)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(2,1/(G13:G34<>\"\"),G13:G34)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(2,1/(J13:J34<>\"\"),J13:J34)","v":{"$error":"#N/A"}},null,{"$f":"LOOKUP(2,1/(L13:L34<>\"\"),L13:L34)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(2,1/(O13:O34<>\"\"),O13:O34)","v":{"$error":"#N/A"}}]

{"sheet":"Project Review","index":4,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[[10,8,10,10],[9,8,9,10],[8,8,8,10],[7,8,7,10],[6,8,6,10],[3,0,7,0],[4,4,4,5],[3,4,3,5],[2,7,6,7],[7,7,10,7],[7,4,7,5],[7,2,7,3],[2,8,2,10],[5,2,5,3],[4,2,4,3],[3,2,3,3],[6,2,6,3],[5,8,5,10],[4,8,4,10],[3,8,3,10],[6,4,6,5],[5,4,5,5],[19,0,19,5],[16,0,16,2],[12,4,12,5],[11,4,11,5],[8,0,12,0],[14,0,14,2],[15,0,15,2],[18,0,18,5],[10,4,10,5],[9,4,9,5],[8,4,8,5],[12,2,12,3],[11,2,11,3],[10,2,10,3],[9,2,9,3],[8,2,8,3]]}
[]
["During Project Review Select Measures being Implemented",null,null,null,null,null,null,"Cooling Tower Related Measure Types"]
[null,"#","Measure Type",null,"Description if \"Other\"",null,null,"CoC Related","Automated Blow Down Control"]
["CoC Related",1,null,null,null,null,null,null,"Automated Chemical Feed "]
[null,2,null,null,null,null,null,null,"Side Stream Filtration"]
[null,3,null,null,null,null,null,null,"Water Softening"]
[null,4,null,null,null,null,null,null,"Other"]
[null,5,null,null,null,null,null,"Non-CoC Related","Sunlight Covers"]
["Non CoC Related",1,null,null,null,null,null,null,"Drift Eliminators"]
[null,2,null,null,null,null,null,null,"Use Recycled Water"]
[null,3,null,null,null,null,null,null,"Other"]
[null,4]
[null,5]
[]
["Project Status",null,null,"Open"]
["Final CoC"]
["Rebate Cap ",null,null,30000]
[]
["Check for Ice Machine and Green Restaurant rebates in current Program Year. Cooling Tower Project Cap may need to be modified in order to not exceed the $30,000 annual water rebate cap."]

{"sheet":"AEG Import","index":5,"n_rows":3,"n_cols":20,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Measure #","Import?","CAPACITY","building_type_sel","Elec_Util_cust_Incentive","Rebate_Per_Unit","GALLONS_WATER","WATER_CONSUMPTION","BASECASE_QUANTITY","HRS_PER_DAY","WATER_FACTOR","BASECASE_OTHERR","SUB_COMPONENT_1","SUB_COMPONENT_2","SUB_COMPONENT_3","SUB_COMPONENT_4","SUB_COMPONENT_5","PHASE_SEL","PROJECT_COST","quantity"]
["CoC",{"$f":"IF(G2>0,\"Yes\",\"No\")","v":"No"},{"$f":"Calculations!D12","v":0},null,{"$f":"F2","v":{"$error":"#N/A"}},{"$f":"IF(Project_Status=\"Final\",Calculations!F30,Calculations!E30)","v":{"$error":"#N/A"}},{"$f":"IF(Project_Status=\"Final\",Calculations!F23,Calculations!E23)","v":0},{"$f":"Calculations!F8","v":{"$error":"#N/A"}},{"$f":"Calculations!F7","v":{"$error":"#N/A"}},{"$f":"Calculations!D13*Calculations!D14","v":0},{"$f":"IF(Project_Status=\"final\",Calculations!D9,Calculations!D8)","v":0},{"$f":"Calculations!D7","v":0},{"$f":"IF('Project Review'!C4=\"Other\",'Project Review'!E4,'Project Review'!C4)","v":0},{"$f":"IF('Project Review'!C5=\"Other\",'Project Review'!E5,'Project Review'!C5)","v":0},{"$f":"IF('Project Review'!C6=\"Other\",'Project Review'!E6,'Project Review'!C6)","v":0},{"$f":"IF('Project Review'!C7=\"Other\",'Project Review'!E7,'Project Review'!C7)","v":0},{"$f":"IF('Project Review'!C8=\"Other\",'Project Review'!E8,'Project Review'!C8)","v":0},{"$f":"Project_Status","v":"Open"},{"$f":"Inputs!M12","v":0},1]
["Non_CoC",{"$f":"IF(G3>0,\"Yes\",\"No\")","v":"No"},{"$f":"Calculations!D12","v":0},null,{"$f":"F3","v":{"$error":"#N/A"}},{"$f":"IF(Project_Status=\"Final\",Calculations!F31,Calculations!E31)","v":{"$error":"#N/A"}},{"$f":"IF(Project_Status=\"Final\",Calculations!F25,Calculations!E25)","v":0},{"$f":"(Calculations!K11*365.25)-(Calculations!F8*365.25)-Inputs!O35","v":{"$error":"#DIV/0!"}},{"$f":"Calculations!K11-Calculations!F7","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF('Project Review'!C9=\"Other\",'Project Review'!E9,'Project Review'!C9)","v":0},{"$f":"IF('Project Review'!C10=\"Other\",'Project Review'!E10,'Project Review'!C10)","v":0},{"$f":"IF('Project Review'!C11=\"Other\",'Project Review'!E11,'Project Review'!C11)","v":0},{"$f":"IF('Project Review'!C12=\"Other\",'Project Review'!E12,'Project Review'!C12)","v":0},{"$f":"IF('Project Review'!C13=\"Other\",'Project Review'!E13,'Project Review'!C13)","v":0},{"$f":"Project_Status","v":"Open"},{"$f":"Inputs!M12","v":0},1]

{"sheet":"Calculations","index":6,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":true,"merged":[[1,2,1,4],[16,2,16,3],[17,2,17,3],[30,2,30,3],[29,2,29,3],[10,2,10,3],[9,2,9,3],[25,2,25,3],[26,2,26,3]]}
[]
[null,null,"Post Review Adjusted Values",null,null,null,null,null,null,"Rebate/1000g",8]
[]
[]
[null,null,"CoC Related Calculations",null,null,null,null,null,null,"Baseline Water Usage"]
[null,null,"CoC Type","CoC","Full GPD","Project GPD",null,null,null,null,"Date L Column","MU L Column","BD L Column","Date R Column","MU R Column","BD R Column"]
[null,null,"Baseline",{"$f":"Inputs!D30","v":0},{"$f":"VLOOKUP($D$12,CoC_data,HLOOKUP($D7,CoC_Conv,2,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"ROUND(E7*(D$13/52)*(D$14/168),0)","v":{"$error":"#N/A"}},null,null,null,"Initial Entry",{"$f":"'Baseline Usage'!B13","v":"00:00:00"},{"$f":"'Baseline Usage'!D13","v":0},{"$f":"'Baseline Usage'!G13","v":0},{"$f":"'Baseline Usage'!J13","v":"00:00:00"},{"$f":"'Baseline Usage'!L13","v":0},{"$f":"'Baseline Usage'!O13","v":0}]
[null,null,"Proposed",{"$f":"Inputs!N30","v":0},{"$f":"VLOOKUP($D$12,CoC_data,HLOOKUP($D8,CoC_Conv,2,FALSE),FALSE)","v":{"$error":"#N/A"}},{"$f":"ROUND(E8*(D$13/52)*(D$14/168),0)","v":{"$error":"#N/A"}},null,null,null,"Last Entry",{"$f":"IFERROR('Baseline Usage'!B36,0)","v":"00:00:00"},{"$f":"IFERROR('Baseline Usage'!D36,0)","v":0},{"$f":"IFERROR('Baseline Usage'!G36,0)","v":0},{"$f":"IFERROR('Baseline Usage'!J36,0)","v":"00:00:00"},{"$f":"IFERROR('Baseline Usage'!L36,0)","v":0},{"$f":"IFERROR('Baseline Usage'!O36,0)","v":0}]
[null,null,"Actual",{"$f":"'Project Review'!D16","v":0},{"$f":"IFERROR(VLOOKUP($D$12,CoC_data,HLOOKUP($D9,CoC_Conv,2,FALSE),FALSE),0)","v":0},{"$f":"ROUND(E9*(D$13/52)*(D$14/168),0)","v":0},null,null,null,"Delta",{"$f":"K8-K7","v":0},{"$f":"L8-L7","v":0},0,0,0,0]
[null,null,"GPD Reduction",null,{"$f":"IFERROR(E7-E9,0)","v":0},{"$f":"F7-IF(D9=0,F8,F9)","v":{"$error":"#N/A"}}]
[null,null,"GPY Reduction",null,{"$f":"E10*365.25","v":0},{"$f":"F10*365.25","v":{"$error":"#N/A"}},null,null,null,"Base MU GPD",{"$f":"(L9+O9)/(K9+N9)","v":{"$error":"#DIV/0!"}},null,null,null,"GPD","GPY"]
[null,null,"Tons",{"$f":"SUM(Inputs!O19:P21)","v":0},null,null,null,null,null,"Base BD GPD",{"$f":"(M9+P9)/(K9+N9)","v":{"$error":"#DIV/0!"}},null,"Water Usage not related to CoC",null,{"$f":"K11-K12","v":{"$error":"#DIV/0!"}},{"$f":"O12*365.25","v":{"$error":"#DIV/0!"}}]
[null,null,"Weeks",{"$f":"Inputs!H23","v":0}]
[null,null,"Hours",{"$f":"Inputs!L23","v":0}]
[null,null,null,null,null,null,null,null,null,"Post Installation Water Usage"]
[null,null,null,null,"Projected","Final",null,null,null,null,"Date L Column","MU L Column","BD L Column","Date R Column","MU R Column","BD R Column"]
[null,null,"CoC Rebate",null,{"$f":"ROUND((F7-F8)*365.25/1000*Incentive_1000g,0)","v":{"$error":"#N/A"}},{"$f":"IF(D9=0,0,ROUND((F7-F9)*365.25/1000*Incentive_1000g,0))","v":0},null,null,null,"Initial Entry",{"$f":"'Post Usage'!B13","v":"00:00:00"},{"$f":"'Post Usage'!D13","v":0},{"$f":"'Post Usage'!G13","v":0},{"$f":"'Post Usage'!J13","v":"00:00:00"},{"$f":"'Post Usage'!L13","v":0},{"$f":"'Post Usage'!O13","v":0}]
[null,null,null,null,null,null,null,null,null,"Last Entry",{"$f":"IFERROR('Post Usage'!B36,0)","v":"00:00:00"},{"$f":"IFERROR('Post Usage'!D36,0)","v":0},{"$f":"IFERROR('Post Usage'!G36,0)","v":0},{"$f":"IFERROR('Post Usage'!J36,0)","v":"00:00:00"},{"$f":"IFERROR('Post Usage'!L36,0)","v":0},{"$f":"IFERROR('Post Usage'!O36,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"Delta",{"$f":"K18-K17","v":0},{"$f":"L18-L17","v":0},{"$f":"M18-M17","v":0},{"$f":"N18-N17","v":0},{"$f":"O18-O17","v":0},{"$f":"P18-P17","v":0}]
[]
[null,null,"Rebate Calculations",null,null,null,null,null,null,"Post MU GPD",{"$f":"(L19+O19)/(K19+N19)","v":{"$error":"#DIV/0!"}},null,null,null,"GPD","GPY"]
[null,null,null,null,"Projected","Final",null,null,null,"Post BD GPD",{"$f":"(M19+P19)/(K19+N19)","v":{"$error":"#DIV/0!"}},null,"Water Usage not related to CoC",null,{"$f":"K21-K22","v":{"$error":"#DIV/0!"}},{"$f":"O22*365.25","v":{"$error":"#DIV/0!"}}]
[null,null,"Total MGY Savings",null,{"$f":"IFERROR(ROUND(((F7-F8)*365.25)+Inputs!O35,0),0)","v":0},{"$f":"IFERROR(ROUND(K30*365.25,0),0)","v":0}]
[null,null,"MGY from CoC",null,{"$f":"ROUND((F7-F8)*365.25,0)","v":{"$error":"#N/A"}},{"$f":"IF(D9=0,0,ROUND((F7-F9)*365.25,0))","v":0}]
[null,null,"MGY from Non-CoC",null,{"$f":"Inputs!O35","v":0},{"$f":"F23-F24","v":0},null,null,null,"Project Water Savings Based on Pre and Post meter readings"]
[null,null,"CoC Rebate",null,{"$f":"E24/1000*Incentive_1000g","v":{"$error":"#N/A"}},{"$f":"F24/1000*Incentive_1000g","v":0},null,null,null,"Make-up",null,null,"Blowdown"]
[null,null,"Non-CoC Rebate",null,{"$f":"E25/1000*Incentive_1000g","v":0},{"$f":"F25/1000*Incentive_1000g","v":0},null,null,null,"Base MU GPD",{"$f":"K11","v":{"$error":"#DIV/0!"}},null,"Base BD GPD",{"$f":"K12","v":{"$error":"#DIV/0!"}}]
[null,null,"Initial Rebate",null,{"$f":"E26+E27","v":{"$error":"#N/A"}},{"$f":"ROUND(F23/1000*Incentive_1000g,2)","v":0},null,null,null,"Post MU GPD",{"$f":"K21","v":{"$error":"#DIV/0!"}},null,"Post BD GPD",{"$f":"K22","v":{"$error":"#DIV/0!"}}]
[null,null,"Capped Rebate",null,{"$f":"IF(E28>Incentive_Cap,Incentive_Cap,E28)","v":{"$error":"#N/A"}},{"$f":"IF(F28>Incentive_Cap,Incentive_Cap,F28)","v":0},null,null,null,"Delta MU GPD",{"$f":"K27-K28","v":{"$error":"#DIV/0!"}},null,"Delta BD GPD",{"$f":"N27-N28","v":{"$error":"#DIV/0!"}}]
[null,null,"Capped Rebate CoC",null,{"$f":"E$29/E$28*E26","v":{"$error":"#N/A"}},{"$f":"IFERROR(F$29/F$28*F26,0)","v":0},null,null,null,"Annual MU GPY Reduction",{"$f":"K29*365.25","v":{"$error":"#DIV/0!"}},null,"Annual BD GPY Reduction",{"$f":"N29*365.25","v":{"$error":"#DIV/0!"}}]
[null,null,"Capped Rebate N-CoC",null,{"$f":"E$29/E$28*E27","v":{"$error":"#N/A"}},{"$f":"IFERROR(F$29/F$28*F27,0)","v":0}]

{"sheet":"CoC Data","index":7,"n_rows":39,"n_cols":27,"rows_kept":39,"cut":false,"hidden":true,"merged":[[2,1,2,12],[3,1,4,1],[3,2,3,12],[3,20,4,20],[3,21,3,26]]}
["Excerpt from EERE/FEMP \"Estimating Methods for Determining End-Use Water Consumption\" https://www.energy.gov/eere/femp/estimating-methods-determining-end-use-water-consumption"]
[null,null,null,null,null,null,null,null,null,null,null,null,1.3049999999999999,"avg delta of daily use per ton per 0.5 CoC for original FEMP data"]
[null,"DAILY COOLING TOWER WATER USE AT FULL LOAD (GALLONS PER DAY)"]
[null,"Chiller Nameplate Tonnage","CYCLES OF CONCENTRATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Move from 3 to 6 CoC 24 Hr Savings","Chiller Daily Operating Hours"]
[null,null,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8,8.5,9,9.5,10,null,null,null,null,10,12,14,16,18,24]
[null,null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
[null,100,5480,{"$f":"AVERAGE(C7,E7)","v":5205},4930,{"$f":"AVERAGE(E7,G7)","v":4795},4660,{"$f":"AVERAGE(G7,I7)","v":4520},4380,{"$f":"AVERAGE(I7,K7)","v":4380},4380,{"$f":"AVERAGE(K7,M7)","v":4245},4110,{"$f":"ROUND(M7-($B7*$M$2),0)","v":3980},{"$f":"ROUND(N7-($B7*$M$2),0)","v":3850},3720,3590,null,null,null,{"$f":"C7-I7","v":1100},{"$f":"V$5/24*$U7","v":458.33333333333337},{"$f":"W$5/24*$U7","v":550},641.66666666666674,733.33333333333326,825,1100]
[null,125,{"$f":"C$7+((C$11-C$7)*(($B8-$B$7)/($B$11-$B$7)))","v":6850},{"$f":"AVERAGE(C8,E8)","v":6506.25},{"$f":"E$7+((E$11-E$7)*(($B8-$B$7)/($B$11-$B$7)))","v":6162.5},{"$f":"AVERAGE(E8,G8)","v":5993.75},5825,{"$f":"AVERAGE(G8,I8)","v":5651.25},5477.5,{"$f":"AVERAGE(I8,K8)","v":5442.5},5407.5,{"$f":"AVERAGE(K8,M8)","v":5306.25},5205,{"$f":"ROUND(M8-($B8*$M$2),0)","v":5042},4879,4716,4553,null,null,null,{"$f":"C8-I8","v":1372.5},{"$f":"V$5/24*$U8","v":571.875},686.25,800.625,915,1029.375,1372.5]
[null,150,{"$f":"C$7+((C$11-C$7)*(($B9-$B$7)/($B$11-$B$7)))","v":8220},7807.5,7395,7192.5,6990,6782.5,6575,6505,6435,6367.5,6300,6104,5908,5712,5516,null,null,null,1645,685.41666666666674,822.5,959.58333333333337,1096.6666666666665,1233.75,1645]
[null,175,9590,9108.75,8627.5,8391.25,8155,7913.75,7672.5,7567.5,7462.5,7428.75,7395,7167,6939,6711,6483,null,null,null,1917.5,798.95833333333337,958.75,1118.5416666666667,1278.3333333333333,1438.125,1917.5]
[null,200,10960,10410,9860,9590,9320,9045,8770,8630,8490,8490,8490,8229,7968,7707,7446,null,null,null,2190,912.5,1095,1277.5,1460,1642.5,2190]
[null,225,{"$f":"C$11+((C$19-C$11)*(($B12-$B$11)/($B$19-$B$11)))","v":12330},11711.875,{"$f":"E$11+((E$19-E$11)*(($B12-$B$11)/($B$19-$B$11)))","v":11093.75},10771.875,10450,10157.5,9865,9725.625,9586.25,9551.875,9517.5,9224,8930,8636,8342,null,null,null,2465,1027.0833333333335,1232.5,1437.9166666666667,1643.3333333333333,1848.75,2465]
[null,250,{"$f":"C$11+((C$19-C$11)*(($B13-$B$11)/($B$19-$B$11)))","v":13700},13013.75,12327.5,11953.75,11580,11270,10960,10821.25,10682.5,10613.75,10545,10219,9893,9567,9241,null,null,null,2740,1141.6666666666667,1370,1598.3333333333335,1826.6666666666665,2055,2740]
[null,275,15070,14315.625,13561.25,13135.625,12710,12382.5,12055,11916.875,11778.75,11675.625,11572.5,11214,10855,10496,10137,null,null,null,3015,1256.25,1507.5,1758.75,2010,2261.25,3015]
[null,300,16440,15617.5,14795,14317.5,13840,13495,13150,13012.5,12875,12737.5,12600,12209,11818,11427,11036,null,null,null,3290,1370.8333333333335,1645,1919.1666666666667,2193.333333333333,2467.5,3290]
[null,325,17810,16919.375,16028.75,15499.375,14970,14607.5,14245,14108.125,13971.25,13799.375,13627.5,13203,12779,12355,11931,null,null,null,3565,1485.4166666666667,1782.5,2079.5833333333335,2376.6666666666665,2673.75,3565]
[null,350,19180,18221.25,17262.5,16681.25,16100,15720,15340,15203.75,15067.5,14861.25,14655,14198,13741,13284,12827,null,null,null,3840,1600,1920,2240,2560,2880,3840]
[null,375,20550,19523.125,18496.25,17863.125,17230,16832.5,16435,16299.375,16163.75,15923.125,15682.5,15193,14704,14215,13726,null,null,null,4115,1714.5833333333335,2057.5,2400.416666666667,2743.333333333333,3086.25,4115]
[null,400,21920,20825,19730,19045,18360,17945,17530,17395,17260,16985,16710,16188,15666,15144,14622,null,null,null,4390,1829.1666666666667,2195,2560.8333333333335,2926.6666666666665,3292.5,4390]
[null,450,{"$f":"AVERAGE(C19,C21)","v":24660},23357.5,{"$f":"AVERAGE(E19,E21)","v":22055},21370,20685,20205,19725,19520,19315,19110,18905,18318,17731,17144,16557,null,null,null,4935,2056.25,2467.5,2878.75,3290,3701.25,4935]
[null,500,27400,25890,24380,23695,23010,22465,21920,21645,21370,21235,21100,20448,19796,19144,18492,null,null,null,5480,2283.3333333333335,2740,3196.666666666667,3653.333333333333,4110,5480]
[null,550,{"$f":"AVERAGE(C21,C23)","v":30275},28562.5,{"$f":"AVERAGE(E21,E23)","v":26850},26027.5,25205,24727.5,24250,23905,23560,23357.5,23155,22437,21719,21001,20283,null,null,null,6025,2510.416666666667,3012.5,3514.5833333333335,4016.6666666666665,4518.75,6025]
[null,600,33150,31235,29320,28360,27400,26990,26580,26165,25750,25480,25210,24427,23644,22861,22078,null,null,null,6570,2737.5,3285,3832.5000000000005,4380,4927.5,6570]
[null,650,{"$f":"C$23+((C$27-C$23)*(($B24-$B$23)/($B$27-$B$23)))","v":35890},33837.5,{"$f":"E$23+((E$27-E$23)*(($B24-$B$23)/($B$27-$B$23)))","v":31785},30756.25,29727.5,29248.75,28770,28322.5,27875,27603.75,27332.5,26484,25636,24788,23940,null,null,null,7120,2966.666666666667,3560,4153.3333333333339,4746.6666666666661,5340,7120]
[null,700,{"$f":"C$23+((C$27-C$23)*(($B25-$B$23)/($B$27-$B$23)))","v":38630},36440,34250,33152.5,32055,31507.5,30960,30480,30000,29727.5,29455,28542,27629,26716,25803,null,null,null,7670,3195.8333333333335,3835,4474.166666666667,5113.333333333333,5752.5,7670]
[null,750,41370,39042.5,36715,35548.75,34382.5,33766.25,33150,32637.5,32125,31851.25,31577.5,30599,29620,28641,27662,null,null,null,8220,3425,4110,4795,5480,6165,8220]
[null,800,44110,41645,39180,37945,36710,36025,35340,34795,34250,33975,33700,32656,31612,30568,29524,null,null,null,8770,3654.166666666667,4385,5115.8333333333339,5846.6666666666661,6577.5,8770]
[null,850,{"$f":"C$27+((C$31-C$27)*(($B28-$B$27)/($B$31-$B$27)))","v":46850},44247.5,{"$f":"E$27+((E$31-E$27)*(($B28-$B$27)/($B$31-$B$27)))","v":41645},40342.5,39040,38286.25,37532.5,36952.5,36372.5,36063.75,35755,34646,33537,32428,31319,null,null,null,9317.5,3882.291666666667,4658.75,5435.2083333333339,6211.6666666666661,6988.125,9317.5]
[null,900,{"$f":"C$27+((C$31-C$27)*(($B29-$B$27)/($B$31-$B$27)))","v":49590},46850,44110,42740,41370,40547.5,39725,39110,38495,38152.5,37810,36636,35462,34288,33114,null,null,null,9865,4110.416666666667,4932.5,5754.5833333333339,6576.6666666666661,7398.75,9865]
[null,950,52330,49452.5,46575,45137.5,43700,42808.75,41917.5,41267.5,40617.5,40241.25,39865,38625,37385,36145,34905,null,null,null,10412.5,4338.541666666667,5206.25,6073.9583333333339,6941.6666666666661,7809.375,10412.5]
[null,1000,55070,52055,49040,47535,46030,45070,44110,43425,42740,42330,41920,40615,39310,38005,36700,null,null,null,10960,4566.666666666667,5480,6393.3333333333339,7306.6666666666661,8220,10960]
[null,1500,82740,78080,73420,71095,68770,67400,66030,65205,64380,63695,63010,61053,59096,57139,55182,null,null,null,16710,6962.5,8355,9747.5,11140,12532.5,16710]
[null,2000,110140,103975,97810,94795,91780,90000,88220,86850,85480,84660,83840,81230,78620,76010,73400,null,null,null,21920,9133.3333333333339,10960,12786.666666666668,14613.333333333332,16440,21920]
[null,2500,137810,130140,122470,118630,114790,112465,110140,108630,107120,106025,104930,101668,98406,95144,91882,null,null,null,27670,11529.166666666668,13835,16140.833333333334,18446.666666666664,20752.5,27670]
[null,3000,165210,156030,146850,142330,137810,135070,132330,130410,128490,127260,126030,122115,118200,114285,110370,null,null,null,32880,13700,16440,19180,21920,24660,32880]
[null,3500,192880,182195,171510,166030,160550,157400,154250,152055,149860,148355,146850,142283,137716,133149,128582,null,null,null,38630,16095.833333333334,19315,22534.166666666668,25753.333333333332,28972.5,38630]
[null,4000,220270,208080,195890,189725,183560,179860,176160,173835,171510,169730,167950,162730,157510,152290,147070,null,null,null,44110,18379.166666666668,22055,25730.833333333336,29406.666666666664,33082.5,44110]
[null,5000,275340,260410,245480,237535,229590,224930,220270,217260,214250,212055,209860,203335,196810,190285,183760,null,null,null,55070,22945.833333333336,27535,32124.166666666668,36713.333333333328,41302.5,55070]
[null,null,"Interpolated and Extrapolated Data"]

{"sheet":"Version Tracking","index":8,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,{"$f":"LOOKUP(2,1/(C1:C50001<>\"\"),C1:C50001)","v":"Edits based on JEA feedback (formatting, wordsmithing)"}]
[]
[null,"Current:",{"$f":"LOOKUP(2,1/(B1:B50001<>\"\"),B1:B50001)","v":1.1000000000000001}]
[null,"Version","Notes","Date","Updated By"]
[null,1,"Initial Creation","2022-03-17","CGO"]
[null,1.1000000000000001,"Edits based on JEA feedback (formatting, wordsmithing)","2022-04-14","RM"]