{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Agreement","Help","Project Info","Summary","Inventory","Factor Tables","Notes","Utility Admin","Reader","Reader2"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":31,"comments":1,"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":"Agreement","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,2,16,11],[18,2,18,11],[20,2,20,11],[2,2,2,11],[24,2,24,11],[22,2,22,11],[4,2,4,11],[6,2,6,11],[8,2,8,11],[10,2,10,11],[12,2,12,11],[14,2,14,11]]}
[null,"\n\n\n\n\n\n",null,null,null,null,null,null,null,null,null,null,"\n\n\n\n\n\n"]
[]
[null,null,"Commercial Cool Roof Calculator"]
[]
[null,null,"[UTILITY] is making available a downloadable Software to facilitate project savings calculations. The Software is in a Microsoft Excel™ spreadsheet format. If the file does not open in your browser window, use the save file to disk option and open it within the application. In order to use the Software, users must accept the following license agreement:"]
[]
[null,null,"NOTICE TO USER: "]
[]
[null,null,"1. THIS IS A CONTRACT. PLEASE READ IT CAREFULLY. USE OF THIS SOFTWARE IS NOT REQUIRED FOR PARTICIPATION IN THIS UTILITY PROGRAM. BY USING THE SOFTWARE CONTAINED HEREIN YOU ARE INDICATING YOUR ACCEPTANCE OF ALL THE TERMS AND CONDITIONS OF THIS AGREEMENT. IF YOU DO NOT AGREE WITH THE TERMS AND CONDITIONS OF THIS AGREEMENT, PLEASE DECLINE WHERE INSTRUCTED, AND YOU WILL NOT BE ABLE TO USE THE SOFTWARE."]
[]
[null,null,"This [UTILITY] End User License Agreement (\"Agreement\") sets forth the terms and conditions under which you are licensed to use the Software. Software means (A) all of the contents of any disk(s), CD-ROM(s) or other media with which this Agreement is provided, including but not limited to (i) [UTILITY] or third party software; and (ii) related explanatory written materials (\"Documentation\")."]
[]
[null,null,"[UTILITY] grants to you a nonexclusive license to use the Software, provided that you agree to the following:"]
[]
[null,null,"2. DISCLAIMER OF WARRANTIES. You expressly acknowledge and agree that use of the accompanying Software is at your sole risk. The [UTILITY] Software is provided \"as is\" and without warranty of any kind and [UTILITY] and [UTILITY]'s suppliers expressly disclaim all warranties and/or conditions, expressed or implied, including, but not limited to, the implied warranties and/or conditions of merchantability or satisfactory quality and fitness for a particular purpose and noninfrigement of third party rights. [UTILITY] does not warrant that the functions contained in the [UTILITY] software will meet your requirements, or that the operation of the [UTILITY] software will be uninterrupted or error-free, or against defects in the use of the [UTILITY] software or related documentation in terms of their correctness, accuracy, reliability, or otherwise. No oral or written information or advice given by [UTILITY] or a [UTILITY] authorized representative, or a [UTILITY] supplier shall create a warranty or in any way decrease the scope of this disclaimer. Should the [UTILITY] software prove defective, you (and not [UTILITY] or a [UTILITY] authorized representative or supplier) assume the entire cost of necessary corrections. Some jurisdictions do not allow the exclusion of implied warranties, so the above exclusion may not apply to you. "]
[]
[null,null,"3. LIMITATION OF LIABILITY. In NO event will [UTILITY] or its suppliers be liable to you for any consequential, indirect, incidental, punitive, or special damages, including any lost profits or lost savings, even if a representative of [UTILITY] or any supplier has been advised of the possibility of such damages, or for any claim made by any third party. Some states or jurisdictions do not allow the exclusion or limitation of incidental or consequential damages, so the above limitations may not apply to you."]
[]
[null,null,"4. GOVERNING LAW AND GENERAL PROVISIONS. This Agreement will be governed by the laws in force in the State of Texas. This Agreement will not be governed by the United Nations Convention on Contracts for the International Sale of Goods, the application of which is expressly excluded. If any part of this Agreement is found void and unenforceable, it will not affect the validity of the balance of the Agreement, which shall remain valid and enforceable according to its terms. "]
[]
[null,null,"You agree that the Software will not be shipped, transferred or exported into any country or used in any manner prohibited by the United States Export Administration Act or any other export laws, restrictions or regulations. You further agree that the Software code, data, and outputs are proprietary and the property of [UTILITY] or Frontier Energy, and that you will not use this Software for commercial purposes, except as related to participation in [UTILITY]’s energy efficiency programs. Any modifications, alterations, or reverse engineering of the Software code or data is prohibited. This Agreement shall automatically terminate upon failure by you to comply with its terms, in which event you must destroy all copies of the Software. This Agreement may only be modified in writing signed by an authorized representative of [UTILITY], although [UTILITY] may vary the terms of this Agreement in connection with the licensing of any updates to you."]
[]
[null,null,"If the above agreement is acceptable to you, click \"Accept\" to use the Software."]
[]
[null,null,{"$f":"CONCATENATE(\"© \",LEFT(Summary!$C$18,4),\" Frontier Energy\")","v":"© 2024 Frontier Energy"}]

{"sheet":"Help","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,"The Cool Roof Calculator (CRC) is provided to facilitate the completion of Final Applications that involve commercial cool roof measures. Each unique application should be entered on a separate line within the survey. Information must be supplied for all installed commercial cool roof materials.  "]
[]
[null,"General Guidelines:"]
[]
[null,"Gray shaded cells are either automatically calculated, or no user input is required."]
[]
[null,"Section 1     Project Information tab"]
[null,"Fill out all required information as signified by a red \"Required Input\" message. This includes (but is not limited to) selecting the appropriate Utility Name and Weather Zone."]
[]
[null,"Section 2     Inventory tab"]
[null,"Choose the Building Type from the drop-down list.\n\nRoof Description section: Enter information for all non-shaded fields. Product model number and specs should match Cool Roof Rating Council (CRRC) qualified product listing: https://coolroofs.org/directory/roof. The shaded areas will automatically display details based on inputs (if applicable).\n\nInstalled Material section: Enter information for all non-shaded fields. The shaded areas will automatically display details based on inputs (if applicable).\n\nTotal kW/kWh Savings: Total project demand and energy savings are calculated for each individual line and for the project as a whole."]
[]
[null,"Section 3     Summary tab"]
[null,"Calculated savings and project information displays here based on user input. If project savings do not appear, check the Project Info and/or Inventory tabs to verify that all required inputs have been provided."]
[]
[null,"Section 4     Frequently Asked Questions (FAQs)"]
[null,"Question: Savings are not calculating for me. What went wrong?\nAnswer: Please make sure that you've selected the appropriate utility, weather zone, and program type in the \"Project Info\" tab in this workbook. Also, please make sure that you've selected a building type and responded to all non-shaded fields in the \"Inventory\" tab in this workbook."]

{"sheet":"Project Info","index":2,"n_rows":259,"n_cols":36,"rows_kept":259,"cut":false,"hidden":true,"merged":[[7,3,7,10],[10,3,10,10],[23,4,23,6],[32,3,32,5],[33,3,33,10],[23,7,23,10],[23,1,23,3],[22,4,22,6],[1,3,1,9],[2,3,2,9],[3,3,3,9],[22,1,22,3],[22,7,22,10],[5,3,5,10],[8,3,8,10],[17,8,17,10],[18,3,18,10],[12,3,12,10],[16,8,16,10],[16,3,16,5],[15,3,15,10],[17,3,17,4],[19,3,19,10],[20,3,20,5],[37,3,37,8],[36,1,36,10],[38,3,38,8],[28,3,28,10],[29,3,29,10],[30,3,30,4],[30,8,30,10],[31,3,31,10]]}
[]
[null,{"$f":"IF($D$6=\"\",\"\",VLOOKUP($D$6,PicTable,2,FALSE))","v":""},null,{"$f":"IF($D$6=\"\",\"Please Select Utility\",$D$6)","v":"Please Select Utility"},null,null,null,null,null,null,{"$f":"IF($D$6=\"\",\"\",VLOOKUP(Texas,PicTable,2,FALSE))","v":""},null,null,null,"Texas","Picture 1",null,"Utility",{"$f":"IF($D$6=\"\",\"-\",VLOOKUP($D$6,$R$3:$S$11,2,FALSE))","v":"-"},null,"SWEPCOProg","TCCProg","TNCProg","CNPProg","EPEProg","EntProg","OncorProg","TNMPProg","XcelProg",null,"County","Climate Zone","City",null,"Climate Zone","City"]
[null,null,null,{"$f":"IF($D$11=\"\",\"Please Select Program Type\",$D$11)","v":"Please Select Program Type"},null,null,null,null,null,null,null,null,null,null,"New Mexico","Picture 2",null,"AEP SWEPCO","SWEPCOProg",null,{"$f":"'Utility Admin'!K4","v":"Commercial SOP"},{"$f":"'Utility Admin'!K6","v":"Commercial SOP"},{"$f":"'Utility Admin'!K7","v":"Commercial SOP"},{"$f":"'Utility Admin'!K8","v":"Commercial SOP"},"N/a",{"$f":"'Utility Admin'!K10","v":"Commercial Solutions"},{"$f":"'Utility Admin'!K11","v":"Commercial SOP"},{"$f":"'Utility Admin'!K12","v":"Commercial Solutions"},{"$f":"'Utility Admin'!K15","v":"Commercial SOP"},null,"Anderson",2,{"$f":"VLOOKUP($AF3,$AI$3:$AJ$7,2,FALSE)","v":"Dallas"},null,1,"Amarillo"]
[null,null,null,{"$f":"CONCATENATE(LEFT(Summary!$C$18,4),\" Commercial Cool Roof Calculator\")","v":"2024 Commercial Cool Roof Calculator"},null,null,null,null,null,null,null,null,null,null,"AEP SWEPCO","Picture 3",null,"AEP Texas Central Division","TCCProg",null,{"$f":"'Utility Admin'!K5","v":"COMPASS"},null,null,{"$f":"'Utility Admin'!K9","v":"Commercial MTP"},null,null,null,{"$f":"'Utility Admin'!K13","v":"SCORE/CitySmart"},{"$f":"'Utility Admin'!K16","v":"Retro-Commissioning"},null,"Andrews",2,{"$f":"VLOOKUP($AF4,$AI$3:$AJ$7,2,FALSE)","v":"Dallas"},null,2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEP Texas Central Division","Picture 3",null,"AEP Texas North Division","TNCProg",null,null,null,null,null,null,null,null,{"$f":"'Utility Admin'!K14","v":"Small SCORE/CitySmart"},{"$f":"'Utility Admin'!K17","v":"Small Business Market Transformation"},null,"Angelina",2,"Dallas",null,3,"Houston"]
[null,null,"Utility:",null,null,null,null,null,null,null,null,null,"* Required Input",null,"AEP Texas North Division","Picture 3",null,"CenterPoint Energy","CNPProg",null,null,null,null,null,null,null,null,null,null,null,"Aransas",4,"Corpus Christi",null,4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CenterPoint Energy","Picture 4",null,"Entergy","EntProg",null,null,null,null,null,null,null,null,null,null,null,"Archer",1,"Amarillo",null,5,"El Paso"]
[null,null,"County:",null,null,null,null,null,null,null,null,null,"* Required Input",null,"El Paso Electric","Picture 5",null,"Oncor","OncorProg",null,null,null,null,null,null,null,null,null,null,null,"Armstrong",1,"Amarillo"]
[null,null,"Climate Zone:",{"$f":"IF($D$8=\"\",\"Select county in previous cell\",VLOOKUP($D$8,$AE:$AG,3,FALSE))","v":"Select county in previous cell"},null,null,null,null,null,null,null,null,null,null,"Entergy","Picture 6",null,"Texas-New Mexico Power","TNMPProg",null,null,null,null,null,null,null,null,null,null,null,"Atascosa",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oncor","Picture 7",null,"Xcel Energy","XcelProg",null,null,null,null,null,null,null,null,null,null,null,"Austin",3,"Houston"]
[null,null,"Program Type:",null,null,null,null,null,null,null,null,null,"* Required Input",null,"Sharyland","Picture 8",null,"El Paso Electric","EPEProg",null,null,null,null,null,null,null,null,null,null,null,"Bailey",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Texas-New Mexico Power","Picture 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bandera",2,"Dallas"]
[null,null,"Business Name:",null,null,null,null,null,null,null,null,null,"* Required Input",null,"Xcel Energy","Picture 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bastrop",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baylor",2,"Dallas"]
[null,"Customer Information",null,null,null,null,null,null,null,"Project ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bee",3,"Houston"]
[null,null,"Company Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bell",2,"Dallas"]
[null,null,"Contact Name:",null,null,null,"Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bexar",3,"Houston"]
[null,null,"Contact Phone:",null,null,null,"Contact Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanco",2,"Dallas"]
[null,null,"ESI ID or Account #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Borden",2,"Dallas"]
[null,null,"Service Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bosque",2,"Dallas"]
[null,null,"City:",null,null,null,"State:",null,{"$f":"IF($D$11=\"\",\"\",$D$11)","v":""},"ZIP Code:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bowie",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brazoria",3,"Houston"]
[null,"Peak kW Savings",null,null,"kWH Savings",null,null,"Estimated Incentive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brazos",3,"Houston"]
[null,{"$f":"IF($D$19=\"\",0,Inventory!$P$5)","v":0},null,null,{"$f":"IF($D$19=\"\",0,Inventory!$Q$5)","v":0},null,null,{"$f":"IF($D$19=\"\",0,Inventory!$R$5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brewster",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Briscoe",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brooks",4,"Corpus Christi"]
[null,"Payment Information (please provide an accompanying W9 if not currently on file with utility)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brown",2,"Dallas"]
[null,"PLEASE NOTE: The Company Name and Taxpayer ID # on W9 must match the Company Name on Federal tax return",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burleson",3,"Houston"]
[null,null,"Company Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burnet",2,"Dallas"]
[null,null,"Contact Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caldwell",3,"Houston"]
[null,null,"Contact Phone:",null,null,null,"Contact Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calhoun",4,"Corpus Christi"]
[null,null,"Payment Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Callahan",2,"Dallas"]
[null,null,"City:",null,null,null,"State:",null,null,"ZIP Code:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cameron",4,"Corpus Christi"]
[null,null,"License #:","(if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Camp",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carson",1,"Amarillo"]
[null,"Payment Release & Acknowledgement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cass",2,"Dallas"]
[null,{"$f":"CONCATENATE(\"By signing below, I acknowledge: \",\"(1) the authorization of the incentive to the payee named above in Payment Information; \",\"(2) that this project would not have been accomplished or would have been completed with less efficient equipment without the incentive provided by this program; \",\"(3) that the information provided by me in this application is accurate to the best of my knowledge; \",\"(4) that if contacted concerning this project, I agree to allow access to my property to inspect the equipment; \",\"(5) that \",$D$6,\" assumes no liability whatsoever relating to the equipment installed, its installation, or its performance.\")","v":"By signing below, I acknowledge: (1) the authorization of the incentive to the payee named above in Payment Information; (2) that this project would not have been accomplished or would have been completed with less efficient equipment without the incentive provided by this program; (3) that the information provided by me in this application is accurate to the best of my knowledge; (4) that if contacted concerning this project, I agree to allow access to my property to inspect the equipment; (5) that  assumes no liability whatsoever relating to the equipment installed, its installation, or its performance."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Castro",1,"Amarillo"]
[null,null,"Applicant Signature:",null,null,null,null,null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chambers",3,"Houston"]
[null,null,"Utility Authorization:",null,null,null,null,null,null,"Date Reserved:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cherokee",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Childress",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cochran",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coleman",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collin",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collingsworth",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colorado",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comal",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comanche",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concho",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooke",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coryell",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cottle",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crane",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crockett",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crosby",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Culberson (Van Horn)",5,"El Paso"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Culberson (All Other)",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallam",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dallas",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dawson",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De Witt",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deaf Smith",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delta",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Denton",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dewitt",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dickens",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dimmit",3,{"$f":"VLOOKUP($AF68,$AI$3:$AJ$7,2,FALSE)","v":"Houston"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Donley",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Duval",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastland",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ector",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edwards",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"El Paso",5,"El Paso"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ellis",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erath",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Falls",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fannin",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fayette",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fisher",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floyd",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Foard",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Bend",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Franklin",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freestone",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frio",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gaines",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Galveston",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garza",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gillespie",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glasscock",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goliad",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gonzales",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gray",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grayson",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gregg",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grimes",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guadalupe",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hale",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hall",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hamilton",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hansford",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardeman",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardin",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harris",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harrison",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hartley",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haskell",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hays",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hemphill",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Henderson",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidalgo",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hill",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hockley",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hood",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hopkins",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Houston",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Howard",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hudspeth",5,"El Paso"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hunt",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hutchinson",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irion",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jack",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jackson",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jasper",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jeff Davis",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jefferson",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jim Hogg",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jim Wells",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Johnson",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jones",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Karnes",3,{"$f":"VLOOKUP($AF132,$AI$3:$AJ$7,2,FALSE)","v":"Houston"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kaufman",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kendall",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kenedy",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kent",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kerr",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kimble",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"King",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kinney",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kleberg",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Knox",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La Salle",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lamar",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lamb",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lampasas",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lavaca",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lee",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leon",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liberty",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limestone",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lipscomb",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Live Oak",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Llano",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loving",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lubbock",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lynn",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Madison",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marion",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Martin",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mason",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matagorda",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maverick",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mcculloch",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mclennan",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mcmullen",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medina",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menard",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Midland",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milam",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mills",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mitchell",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montague",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montgomery",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moore",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morris",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motley",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nacogdoches",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Navarro",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newton",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nolan",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",5,"El Paso"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nueces",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ochiltree",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oldham",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palo Pinto",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Panola",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parker",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parmer",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pecos",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polk",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potter",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presidio",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rains",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Randall",1,{"$f":"VLOOKUP($AF196,$AI$3:$AJ$7,2,FALSE)","v":"Amarillo"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reagan",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Real",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red River",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reeves",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Refugio",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roberts",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robertson",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rockwall",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Runnels",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rusk",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sabine",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Augustine",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Jacinto",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Patricio",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"San Saba",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schleicher",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scurry",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shackelford",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shelby",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sherman",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smith",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somervell",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Starr",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stephens",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sterling",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stonewall",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sutton",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swisher",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarrant",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taylor",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terrell",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Terry",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Throckmorton",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Titus",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tom Green",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travis",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trinity",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyler",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upshur",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upton",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uvalde",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Val Verde",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Van Zandt",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Victoria",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walker",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waller",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ward",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Webb",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wharton",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheeler",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wichita",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilbarger",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Willacy",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Williamson",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilson",3,"Houston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winkler",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wise",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wood",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yoakum",1,"Amarillo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Young",2,"Dallas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zapata",4,"Corpus Christi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zavala",3,"Houston"]

{"sheet":"Summary","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[[14,1,15,1],[12,1,13,1],[10,1,10,5],[1,2,1,5],[5,2,5,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[4,2,4,5],[2,2,2,5],[3,2,3,5]]}
[{"$f":"$C$18","v":2024.1}]
[null,"Business Name:",{"$f":"IF('Project Info'!$D$13=\"\",\"\",'Project Info'!$D$13)","v":""}]
[null,"Project Site Address:",{"$f":"IF('Project Info'!$D$20=\"\",\"\",'Project Info'!$D$20)","v":""}]
[null,"City:",{"$f":"IF('Project Info'!$D$21=\"\",\"\",'Project Info'!$D$21)","v":""}]
[null,"State:",{"$f":"IF('Project Info'!$I$21=\"\",\"\",'Project Info'!$I$21)","v":""}]
[null,"ZIP Code:",{"$f":"IF('Project Info'!$K$21=\"\",\"\",'Project Info'!$K$21)","v":""}]
[null,"Sponsor Name:",{"$f":"IF('Project Info'!$D$29=\"\",\"\",'Project Info'!$D$29)","v":""}]
[null,"Utility Name:",{"$f":"IF('Project Info'!$D$6=\"\",\"\",'Project Info'!$D$6)","v":""}]
[null,"Climate Zone:",{"$f":"IF('Project Info'!$D$9=\"Select county in previous cell\",\"\",'Project Info'!$D$9)","v":""}]
[]
[null,"Savings Summary"]
[]
[null,"Total Calculated\nProject Savings","Total Summer\nkW Savings",null,null,"Total\nkWh Savings"]
[]
[null,"Claimed\nProject Savings","Total\nkW Savings","Total\nkWh Savings","Estimated\nIncentive","EUL"]
[null,null,{"$f":"Inventory!$P$5","v":0},{"$f":"Inventory!$Q$5","v":0},{"$f":"Inventory!$R$5","v":0},15]
[]
[null,"CRC Version",2024.1]

{"sheet":"Inventory","index":4,"n_rows":22,"n_cols":34,"rows_kept":22,"cut":false,"hidden":true,"merged":[[3,1,4,13],[7,4,8,4],[7,6,8,6],[7,10,8,10],[6,19,8,19],[6,23,8,23],[6,24,8,24],[6,16,8,16],[6,18,8,18],[6,17,8,17],[6,22,8,22],[6,21,8,21],[6,25,8,25],[6,26,8,26],[21,1,21,2],[6,2,8,2],[7,12,8,12],[7,5,8,5],[6,1,8,1],[7,7,8,7],[7,8,8,8],[7,3,8,3],[6,15,8,15],[7,13,8,13],[7,11,8,11],[7,9,8,9],[6,14,8,14],[6,20,8,20],[6,28,6,29],[6,30,8,30],[7,28,8,28],[7,29,8,29],[6,27,8,27]]}
[]
[null,{"$f":"LEFT(Summary!C18,4)","v":"2024"},{"$f":"IF(AND('Project Info'!$D$13<>\"\",'Project Info'!$D$20<>\"\"),CONCATENATE(\"Commercial Cool Roof Calculator (CRC): \",'Project Info'!$D$13,\" (\",'Project Info'!$D$20,\")\"),IF(AND('Project Info'!$D$13<>\"\",'Project Info'!$D$20=\"\"),CONCATENATE(\"Commercial Cool Roof Calculator (CRC): \",'Project Info'!$D$13),IF(AND('Project Info'!$D$13=\"\",'Project Info'!$D$20<>\"\"),CONCATENATE(\"Commercial Cool Roof Calculator (CRC): \",'Project Info'!$D$20),\"Commercial Cool Roof Calculator (CRC)\")))","v":"Commercial Cool Roof Calculator (CRC)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"v \",Summary!C18)","v":"v 2024.1"}]
[]
[null,"Please fill out one copy of this form for each customer site involved in the project where commercial cool roof materials are being installed.\nFrom left to right, fill in all non-shaded cells of the roof build-up inventory. Shaded (gray) values are either automatically calculated or not necessary. Use drop-down lists (if available).\nTo print this form click on File/Print/OK.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total kW\nSavings","Total kWh\nSavings","Estimated\nPayment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR($P$21,0)","v":0},{"$f":"IFERROR($Q$21,0)","v":0},{"$f":"IFERROR($R$21,0)","v":0}]
[]
[null,null,"Building Type\n(select from list)","Roof Description",null,null,null,null,"Installed Cool Roof Rating Council (CRRC) Material Description",null,null,null,null,null,"Measure\nLife","Total kW\nSavings","Total kWh\nSavings","Estimated\nPayment","R-Value\nLookup","Existing\nR-Value","Installed\nR-Value","Savings\nFactor\nLookup","PSDF","PWDF","ESF","Summer\nkW\nSavings","Winter\nkW\nSavings","kWh\nSavings","Incentive Rates",null,"Estimated\nPayment"]
[null,null,null,"Roof Slope","Treated\nRoof Surface Area\nover Conditioned\nSpace ONLY\n(ft2)","Percent of Total\nRoof Surface Area\nover Conditioned Space ONLY\n(Treated Area ÷\nTotal Area)","Existing Insulation\nR-Value\n(if known)","Year of Building Construction\n(if existing R-value unknown)","Manufacturer","Model","Installed Insulation\nR-Value\n(Defaults to\nExisting Insulation\nR-value)","Initial\nSolar\nReflectance","3-Year\nSolar\nReflectance","Rated Life\n(Years)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/kW","$/kWh"]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"ROUND(IF(OR($C10=\"\",$D10<>\"Low: 2:12 or less\",$E10=\"\",$F10=\"\",$F10<0.75,AND($G10=\"\",$H10=\"\"),$I10=\"\",$J10=\"\",$K10=\"\",$L10=\"\",$L10<0.65,$M10=\"\",$M10<0.5,$N10=\"\"),0,MAX(ABS($Z10),ABS($AA10))),2)","v":0},{"$f":"ROUND(IF(OR($C10=\"\",$D10<>\"Low: 2:12 or less\",$E10=\"\",$F10=\"\",$F10<0.75,AND($G10=\"\",$H10=\"\"),$I10=\"\",$J10=\"\",$K10=\"\",$L10=\"\",$L10<0.65,$M10=\"\",$M10<0.5,$N10=\"\"),0,$AB10),0)","v":0},{"$f":"IFERROR($AE10,0)","v":0},{"$f":"IF(AND($G10=\"\",$H10=\"\"),\"\",IF($G10<>\"\",VLOOKUP($G10,$AG$10:$AH$12,2,FALSE),VLOOKUP($T10,$AG$10:$AH$12,2,FALSE)))","v":""},{"$f":"IF(AND($G10=\"\",$H10=\"\"),\"\",IF(AND($G10=\"\",$H10<>\"\"),VLOOKUP($H10,$AG$14:$AH$16,2,FALSE),$G10))","v":""},{"$f":"IF($K10=\"\",\"\",$K10)","v":""},{"$f":"CONCATENATE(C10,\" \",T10,\" \",U10)","v":"  "},{"$f":"IFERROR(VLOOKUP($V10,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V10,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V10,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},{"$f":"$E10*$W10*0.00001","v":0},{"$f":"$E10*$X10*0.000001","v":0},{"$f":"$E10*$Y10","v":0},{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P10,2)*'Utility Admin'!$E$4+ROUND($Q10,0)*'Utility Admin'!$F$4,ROUND($P10,2)*'Utility Admin'!$E$4+ROUND($P10,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0},null,"R <= 13","PostRVal3"]
[null,2,{"$f":"IF($C10=\"\",\"\",$C10)","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(G11=\"\",H11=\"\"),\"\",T11)","v":""},null,null,null,15,{"$f":"ROUND(IF(OR($C11=\"\",$D11<>\"Low: 2:12 or less\",$E11=\"\",$F11=\"\",$F11<0.75,AND($G11=\"\",$H11=\"\"),$I11=\"\",$J11=\"\",$K11=\"\",$L11=\"\",$L11<0.65,$M11=\"\",$M11<0.5,$N11=\"\"),0,MAX(ABS($Z11),ABS($AA11))),2)","v":0},{"$f":"ROUND(IF(OR($C11=\"\",$D11<>\"Low: 2:12 or less\",$E11=\"\",$F11=\"\",$F11<0.75,AND($G11=\"\",$H11=\"\"),$I11=\"\",$J11=\"\",$K11=\"\",$L11=\"\",$L11<0.65,$M11=\"\",$M11<0.5,$N11=\"\"),0,$AB11),0)","v":0},{"$f":"IFERROR($AE11,0)","v":0},{"$f":"IF(AND($G11=\"\",$H11=\"\"),\"\",IF($G11<>\"\",VLOOKUP($G11,$AG$10:$AH$12,2,FALSE),VLOOKUP($T11,$AG$10:$AH$12,2,FALSE)))","v":""},{"$f":"IF(AND($G11=\"\",$H11=\"\"),\"\",IF(AND($G11=\"\",$H11<>\"\"),VLOOKUP($H11,$AG$14:$AH$16,2,FALSE),$G11))","v":""},{"$f":"IF($K11=\"\",\"\",$K11)","v":""},"  ",{"$f":"IFERROR(VLOOKUP($V11,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V11,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V11,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P11,2)*'Utility Admin'!$E$4+ROUND($Q11,0)*'Utility Admin'!$F$4,ROUND($P11,2)*'Utility Admin'!$E$4+ROUND($P11,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0},null,"13 < R <= 20","PostRVal2"]
[null,3,"",null,null,null,null,null,null,null,"",null,null,null,15,0,0,0,"","","","  ",{"$f":"IFERROR(VLOOKUP($V12,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V12,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V12,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P12,2)*'Utility Admin'!$E$4+ROUND($Q12,0)*'Utility Admin'!$F$4,ROUND($P12,2)*'Utility Admin'!$E$4+ROUND($P12,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0},null,"20 < R","PostRVal1"]
[null,4,"",null,null,null,null,null,null,null,"",null,null,null,15,0,0,0,"","","","  ",{"$f":"IFERROR(VLOOKUP($V13,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V13,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V13,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P13,2)*'Utility Admin'!$E$4+ROUND($Q13,0)*'Utility Admin'!$F$4,ROUND($P13,2)*'Utility Admin'!$E$4+ROUND($P13,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0}]
[null,5,"",null,null,null,null,null,null,null,"",null,null,null,15,0,0,0,"","","","  ",{"$f":"IFERROR(VLOOKUP($V14,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V14,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V14,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P14,2)*'Utility Admin'!$E$4+ROUND($Q14,0)*'Utility Admin'!$F$4,ROUND($P14,2)*'Utility Admin'!$E$4+ROUND($P14,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0},null,"Before 2011","R <= 13"]
[null,6,"",null,null,null,null,null,null,null,"",null,null,null,15,0,0,0,"","","","  ",{"$f":"IFERROR(VLOOKUP($V15,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V15,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V15,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P15,2)*'Utility Admin'!$E$4+ROUND($Q15,0)*'Utility Admin'!$F$4,ROUND($P15,2)*'Utility Admin'!$E$4+ROUND($P15,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0},null,"2011-2016","13 < R <= 20"]
[null,7,"",null,null,null,null,null,null,null,"",null,null,null,15,0,0,0,"","","","  ",{"$f":"IFERROR(VLOOKUP($V16,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V16,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V16,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P16,2)*'Utility Admin'!$E$4+ROUND($Q16,0)*'Utility Admin'!$F$4,ROUND($P16,2)*'Utility Admin'!$E$4+ROUND($P16,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0},null,"After 2016","20 < R"]
[null,8,"",null,null,null,null,null,null,null,"",null,null,null,15,0,0,0,"","","","  ",{"$f":"IFERROR(VLOOKUP($V17,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V17,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V17,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P17,2)*'Utility Admin'!$E$4+ROUND($Q17,0)*'Utility Admin'!$F$4,ROUND($P17,2)*'Utility Admin'!$E$4+ROUND($P17,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0}]
[null,9,"",null,null,null,null,null,null,null,"",null,null,null,15,0,0,0,"","","","  ",{"$f":"IFERROR(VLOOKUP($V18,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V18,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V18,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P18,2)*'Utility Admin'!$E$4+ROUND($Q18,0)*'Utility Admin'!$F$4,ROUND($P18,2)*'Utility Admin'!$E$4+ROUND($P18,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0}]
[null,10,"",null,null,null,null,null,null,null,"",null,null,null,15,0,0,0,"","","","  ",{"$f":"IFERROR(VLOOKUP($V19,'Factor Tables'!$E$265:$H$312,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V19,'Factor Tables'!$E$265:$H$312,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($V19,'Factor Tables'!$E$265:$H$312,2,FALSE),0)","v":0},0,0,0,{"$f":"'Utility Admin'!$E$4","v":0},{"$f":"'Utility Admin'!$F$4","v":0},{"$f":"IFERROR(IF(ABS(Summary!$D$16)<=ABS(Summary!$C$16)*'Utility Admin'!$G$4,ROUND($P19,2)*'Utility Admin'!$E$4+ROUND($Q19,0)*'Utility Admin'!$F$4,ROUND($P19,2)*'Utility Admin'!$E$4+ROUND($P19,2)*'Utility Admin'!$G$4*'Utility Admin'!$F$4),0)","v":0}]
[null,"If you need more rows, please contact program administrator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM($P$10:$P$19),0)","v":0},{"$f":"IFERROR(SUM($Q$10:$Q$19),0)","v":0},{"$f":"IFERROR(SUM($R$10:$R$19),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total kW Savings","Total kWh Savings","Estimated Payment"]

{"sheet":"Factor Tables","index":5,"n_rows":312,"n_cols":10,"rows_kept":312,"cut":false,"hidden":true,"merged":[[262,2,262,6],[2,1,3,1],[54,1,55,1],[106,1,107,1],[158,1,159,1],[210,1,211,1],[262,1,263,1],[2,2,2,6],[54,2,54,6],[106,2,106,6],[158,2,158,6],[210,2,210,6]]}
[]
[null,"Deemed Savings Coefficients",null,null,null,null,null,"Climate Zone 1: Amarillo"]
[null,"Building Type","Demand Factors"]
[null,null,"Pre R-Value","Post R-Value","Lookup","ESF","PSDF","PWDF"]
[null,"Retail","R <= 13","R <= 13",{"$f":"CONCATENATE(B5,\" \",C5,\" \",D5)","v":"Retail R <= 13 R <= 13"},0.72,19.28,31.74,null,"Education (Chiller)"]
[null,"Retail","R <= 13","13 < R <= 20","Retail R <= 13 13 < R <= 20",1.26,36.229999999999997,36.71,null,"Education (RTU)"]
[null,"Retail","R <= 13","20 < R","Retail R <= 13 20 < R",1.25,38.58,35.31,null,"Hotel"]
[null,"Retail","13 < R <= 20","13 < R <= 20","Retail 13 < R <= 20 13 < R <= 20",0.13,4.8099999999999996,1.88,null,"Office (Chiller)"]
[null,"Retail","13 < R <= 20","20 < R","Retail 13 < R <= 20 20 < R",0.12,6.47,0.48,null,"Office (RTU)"]
[null,"Retail","20 < R","20 < R","Retail 20 < R 20 < R",0.09,3.32,1.3,null,"Retail"]
[null,"Education (Chiller)","R <= 13","R <= 13","Education (Chiller) R <= 13 R <= 13",0.65,11.8,8.31,null,"Warehouse"]
[null,"Education (Chiller)","R <= 13","13 < R <= 20","Education (Chiller) R <= 13 13 < R <= 20",1.1000000000000001,21.76,31.52,null,"Other"]
[null,"Education (Chiller)","R <= 13","20 < R","Education (Chiller) R <= 13 20 < R",1.25,25.53,37.31]
[null,"Education (Chiller)","13 < R <= 20","13 < R <= 20","Education (Chiller) 13 < R <= 20 13 < R <= 20",0.26,4.8499999999999996,4.59]
[null,"Education (Chiller)","13 < R <= 20","20 < R","Education (Chiller) 13 < R <= 20 20 < R",0.38,7.8,9.1999999999999993]
[null,"Education (Chiller)","20 < R","20 < R","Education (Chiller) 20 < R 20 < R",0.17,3.4,1.17]
[null,"Education (RTU)","R <= 13","R <= 13","Education (RTU) R <= 13 R <= 13",0.26,8.26,2.62]
[null,"Education (RTU)","R <= 13","13 < R <= 20","Education (RTU) R <= 13 13 < R <= 20",0.43,15.47,12.49]
[null,"Education (RTU)","R <= 13","20 < R","Education (RTU) R <= 13 20 < R",0.49,18.2,14.02]
[null,"Education (RTU)","13 < R <= 20","13 < R <= 20","Education (RTU) 13 < R <= 20 13 < R <= 20",0.12,4.1100000000000003,2.0499999999999998]
[null,"Education (RTU)","13 < R <= 20","20 < R","Education (RTU) 13 < R <= 20 20 < R",0.18,6.67,3.58]
[null,"Education (RTU)","20 < R","20 < R","Education (RTU) 20 < R 20 < R",0.08,2.91,0.28000000000000003]
[null,"Office (Chiller)","R <= 13","R <= 13",{"$f":"CONCATENATE(B23,\" \",C23,\" \",D23)","v":"Office (Chiller) R <= 13 R <= 13"},0.21,6.8,1.43]
[null,"Office (Chiller)","R <= 13","13 < R <= 20","Office (Chiller) R <= 13 13 < R <= 20",0.31,3.44,3.5]
[null,"Office (Chiller)","R <= 13","20 < R","Office (Chiller) R <= 13 20 < R",0.33,19.3,3.87]
[null,"Office (Chiller)","13 < R <= 20","13 < R <= 20","Office (Chiller) 13 < R <= 20 13 < R <= 20",0.09,16.579999999999998,0.11]
[null,"Office (Chiller)","13 < R <= 20","20 < R","Office (Chiller) 13 < R <= 20 20 < R",0.11,5.94,0.47]
[null,"Office (Chiller)","20 < R","20 < R","Office (Chiller) 20 < R 20 < R",0.06,2.36,0.08]
[null,"Office (RTU)","R <= 13","R <= 13","Office (RTU) R <= 13 R <= 13",0.28000000000000003,7.46,11.88]
[null,"Office (RTU)","R <= 13","13 < R <= 20","Office (RTU) R <= 13 13 < R <= 20",0.87,15.48,168.51]
[null,"Office (RTU)","R <= 13","20 < R","Office (RTU) R <= 13 20 < R",1.1000000000000001,18.61,236.76]
[null,"Office (RTU)","13 < R <= 20","13 < R <= 20","Office (RTU) 13 < R <= 20 13 < R <= 20",0.15,4.12,-1.23]
[null,"Office (RTU)","13 < R <= 20","20 < R","Office (RTU) 13 < R <= 20 20 < R",0.38,6.73,67.02]
[null,"Office (RTU)","20 < R","20 < R","Office (RTU) 20 < R 20 < R",0.11,2.92,-2.61]
[null,"Hotel","R <= 13","R <= 13",{"$f":"CONCATENATE(B35,\" \",C35,\" \",D35)","v":"Hotel R <= 13 R <= 13"},7.0000000000000007E-2,1.33,-2.6]
[null,"Hotel","R <= 13","13 < R <= 20","Hotel R <= 13 13 < R <= 20",7.0000000000000007E-2,1.83,6.98]
[null,"Hotel","R <= 13","20 < R","Hotel R <= 13 20 < R",7.0000000000000007E-2,2.0299999999999998,11.77]
[null,"Hotel","13 < R <= 20","13 < R <= 20","Hotel 13 < R <= 20 13 < R <= 20",0.04,0.81,-1.45]
[null,"Hotel","13 < R <= 20","20 < R","Hotel 13 < R <= 20 20 < R",0.04,1,3.39]
[null,"Hotel","20 < R","20 < R","Hotel 20 < R 20 < R",0.03,0.6,-1.1200000000000001]
[null,"Warehouse","R <= 13","R <= 13","Warehouse R <= 13 R <= 13",0.04,3.83,-0.2]
[null,"Warehouse","R <= 13","13 < R <= 20","Warehouse R <= 13 13 < R <= 20",0.11,6.99,3.89]
[null,"Warehouse","R <= 13","20 < R","Warehouse R <= 13 20 < R",0.14000000000000001,8.07,5.35]
[null,"Warehouse","13 < R <= 20","13 < R <= 20","Warehouse 13 < R <= 20 13 < R <= 20",0.01,1.35,-0.1]
[null,"Warehouse","13 < R <= 20","20 < R","Warehouse 13 < R <= 20 20 < R",0.04,2.2400000000000002,1.36]
[null,"Warehouse","20 < R","20 < R","Warehouse 20 < R 20 < R",0.01,0.9,-7.0000000000000007E-2]
[null,"Other","R <= 13","R <= 13","Other R <= 13 R <= 13",0.04,1.33,-2.6]
[null,"Other","R <= 13","13 < R <= 20","Other R <= 13 13 < R <= 20",7.0000000000000007E-2,1.83,3.5]
[null,"Other","R <= 13","20 < R","Other R <= 13 20 < R",7.0000000000000007E-2,2.0299999999999998,3.87]
[null,"Other","13 < R <= 20","13 < R <= 20","Other 13 < R <= 20 13 < R <= 20",0.01,0.81,-1.45]
[null,"Other","13 < R <= 20","20 < R","Other 13 < R <= 20 20 < R",0.04,1,0.47]
[null,"Other","20 < R","20 < R","Other 20 < R 20 < R",0.01,0.6,-2.61]
[]
[null,"Deemed Savings Coefficients",null,null,null,null,null,"Climate Zone 2: Dallas"]
[null,"Building Type","Demand Factors"]
[null,null,"Pre R-Value","Post R-Value","Lookup","ESF","PSDF","PWDF"]
[null,"Retail","R <= 13","R <= 13",{"$f":"CONCATENATE(B57,\" \",C57,\" \",D57)","v":"Retail R <= 13 R <= 13"},0.61,22.03,13.53]
[null,"Retail","R <= 13","13 < R <= 20","Retail R <= 13 13 < R <= 20",0.97,37.67,17.3]
[null,"Retail","R <= 13","20 < R","Retail R <= 13 20 < R",0.98,40.54,17.32]
[null,"Retail","13 < R <= 20","13 < R <= 20","Retail 13 < R <= 20 13 < R <= 20",0.16,7.57,1.28]
[null,"Retail","13 < R <= 20","20 < R","Retail 13 < R <= 20 20 < R",0.17,9.67,1.29]
[null,"Retail","20 < R","20 < R","Retail 20 < R 20 < R",0.13,6.22,1.04]
[null,"Education (Chiller)","R <= 13","R <= 13","Education (Chiller) R <= 13 R <= 13",0.56000000000000005,10.49,5.1100000000000003]
[null,"Education (Chiller)","R <= 13","13 < R <= 20","Education (Chiller) R <= 13 13 < R <= 20",0.82,16.5,8.6]
[null,"Education (Chiller)","R <= 13","20 < R","Education (Chiller) R <= 13 20 < R",0.92,18.86,11.17]
[null,"Education (Chiller)","13 < R <= 20","13 < R <= 20","Education (Chiller) 13 < R <= 20 13 < R <= 20",0.28999999999999998,5.41,2.36]
[null,"Education (Chiller)","13 < R <= 20","20 < R","Education (Chiller) 13 < R <= 20 20 < R",0.36,7.28,4.55]
[null,"Education (Chiller)","20 < R","20 < R","Education (Chiller) 20 < R 20 < R",0.24,4.37,1.88]
[null,"Education (RTU)","R <= 13","R <= 13","Education (RTU) R <= 13 R <= 13",0.27,10.65,1.53]
[null,"Education (RTU)","R <= 13","13 < R <= 20","Education (RTU) R <= 13 13 < R <= 20",0.39,18.309999999999999,3.68]
[null,"Education (RTU)","R <= 13","20 < R","Education (RTU) R <= 13 20 < R",0.43,21.33,4.8899999999999997]
[null,"Education (RTU)","13 < R <= 20","13 < R <= 20","Education (RTU) 13 < R <= 20 13 < R <= 20",0.17,7.21,0.77]
[null,"Education (RTU)","13 < R <= 20","20 < R","Education (RTU) 13 < R <= 20 20 < R",0.21,10.08,1.97]
[null,"Education (RTU)","20 < R","20 < R","Education (RTU) 20 < R 20 < R",0.13,5.88,0.6]
[null,"Office (Chiller)","R <= 13","R <= 13",{"$f":"CONCATENATE(B75,\" \",C75,\" \",D75)","v":"Office (Chiller) R <= 13 R <= 13"},0.23,11.99,0.81]
[null,"Office (Chiller)","R <= 13","13 < R <= 20","Office (Chiller) R <= 13 13 < R <= 20",0.33,27.48,1.78]
[null,"Office (Chiller)","R <= 13","20 < R","Office (Chiller) R <= 13 20 < R",0.34,30.55,1.93]
[null,"Office (Chiller)","13 < R <= 20","13 < R <= 20","Office (Chiller) 13 < R <= 20 13 < R <= 20",0.13,6.68,0.1]
[null,"Office (Chiller)","13 < R <= 20","20 < R","Office (Chiller) 13 < R <= 20 20 < R",0.15,9.76,0.26]
[null,"Office (Chiller)","20 < R","20 < R","Office (Chiller) 20 < R 20 < R",0.1,6.01,0.08]
[null,"Office (RTU)","R <= 13","R <= 13","Office (RTU) R <= 13 R <= 13",0.27,12.14,14.86]
[null,"Office (RTU)","R <= 13","13 < R <= 20","Office (RTU) R <= 13 13 < R <= 20",0.52,24.53,84.63]
[null,"Office (RTU)","R <= 13","20 < R","Office (RTU) R <= 13 20 < R",0.62,29.45,112.16]
[null,"Office (RTU)","13 < R <= 20","13 < R <= 20","Office (RTU) 13 < R <= 20 13 < R <= 20",0.18,7.25,11.53]
[null,"Office (RTU)","13 < R <= 20","20 < R","Office (RTU) 13 < R <= 20 20 < R",0.28000000000000003,11.09,39.06]
[null,"Office (RTU)","20 < R","20 < R","Office (RTU) 20 < R 20 < R",0.15,6.03,8.66]
[null,"Hotel","R <= 13","R <= 13",{"$f":"CONCATENATE(B87,\" \",C87,\" \",D87)","v":"Hotel R <= 13 R <= 13"},7.0000000000000007E-2,1.71,-0.64]
[null,"Hotel","R <= 13","13 < R <= 20","Hotel R <= 13 13 < R <= 20",7.0000000000000007E-2,2.2999999999999998,0.78]
[null,"Hotel","R <= 13","20 < R","Hotel R <= 13 20 < R",7.0000000000000007E-2,2.56,1.39]
[null,"Hotel","13 < R <= 20","13 < R <= 20","Hotel 13 < R <= 20 13 < R <= 20",0.05,1.17,-0.46]
[null,"Hotel","13 < R <= 20","20 < R","Hotel 13 < R <= 20 20 < R",0.05,1.42,0.17]
[null,"Hotel","20 < R","20 < R","Hotel 20 < R 20 < R",0.05,1.01,-0.36]
[null,"Warehouse","R <= 13","R <= 13","Warehouse R <= 13 R <= 13",0.05,4.01,-7.0000000000000007E-2]
[null,"Warehouse","R <= 13","13 < R <= 20","Warehouse R <= 13 13 < R <= 20",0.09,6.54,1.47]
[null,"Warehouse","R <= 13","20 < R","Warehouse R <= 13 20 < R",0.16,11.16,2.38]
[null,"Warehouse","13 < R <= 20","13 < R <= 20","Warehouse 13 < R <= 20 13 < R <= 20",0.02,1.18,-0.05]
[null,"Warehouse","13 < R <= 20","20 < R","Warehouse 13 < R <= 20 20 < R",0.08,4.9400000000000004,0.86]
[null,"Warehouse","20 < R","20 < R","Warehouse 20 < R 20 < R",0.01,1.02,-0.03]
[null,"Other","R <= 13","R <= 13","Other R <= 13 R <= 13",0.05,1.71,-0.64]
[null,"Other","R <= 13","13 < R <= 20","Other R <= 13 13 < R <= 20",7.0000000000000007E-2,2.2999999999999998,0.78]
[null,"Other","R <= 13","20 < R","Other R <= 13 20 < R",7.0000000000000007E-2,2.56,1.39]
[null,"Other","13 < R <= 20","13 < R <= 20","Other 13 < R <= 20 13 < R <= 20",0.02,1.17,-0.46]
[null,"Other","13 < R <= 20","20 < R","Other 13 < R <= 20 20 < R",0.05,1.42,0.17]
[null,"Other","20 < R","20 < R","Other 20 < R 20 < R",0.01,1.01,-0.36]
[]
[null,"Deemed Savings Coefficients",null,null,null,null,null,"Climate Zone 3: Houston"]
[null,"Building Type","Demand Factors"]
[null,null,"Pre R-Value","Post R-Value","Lookup","ESF","PSDF","PWDF"]
[null,"Retail","R <= 13","R <= 13",{"$f":"CONCATENATE(B109,\" \",C109,\" \",D109)","v":"Retail R <= 13 R <= 13"},0.62,17.21,9.86]
[null,"Retail","R <= 13","13 < R <= 20","Retail R <= 13 13 < R <= 20",1,29.6,17.11]
[null,"Retail","R <= 13","20 < R","Retail R <= 13 20 < R",1.01,31.61,16.52]
[null,"Retail","13 < R <= 20","13 < R <= 20","Retail 13 < R <= 20 13 < R <= 20",0.41,10.43,7.67]
[null,"Retail","13 < R <= 20","20 < R","Retail 13 < R <= 20 20 < R",0.41,11.89,7.07]
[null,"Retail","20 < R","20 < R","Retail 20 < R 20 < R",0.14000000000000001,4.66,1.07]
[null,"Education (Chiller)","R <= 13","R <= 13","Education (Chiller) R <= 13 R <= 13",0.62,9.56,-0.28000000000000003]
[null,"Education (Chiller)","R <= 13","13 < R <= 20","Education (Chiller) R <= 13 13 < R <= 20",0.87,15.28,3.52]
[null,"Education (Chiller)","R <= 13","20 < R","Education (Chiller) R <= 13 20 < R",0.95,17.53,4.5199999999999996]
[null,"Education (Chiller)","13 < R <= 20","13 < R <= 20","Education (Chiller) 13 < R <= 20 13 < R <= 20",0.33,5.04,-0.28000000000000003]
[null,"Education (Chiller)","13 < R <= 20","20 < R","Education (Chiller) 13 < R <= 20 20 < R",0.39,6.81,0.5]
[null,"Education (Chiller)","20 < R","20 < R","Education (Chiller) 20 < R 20 < R",0.26,4.05,-0.28999999999999998]
[null,"Education (RTU)","R <= 13","R <= 13","Education (RTU) R <= 13 R <= 13",0.28999999999999998,9.39,-0.03]
[null,"Education (RTU)","R <= 13","13 < R <= 20","Education (RTU) R <= 13 13 < R <= 20",0.4,15.76,0.9]
[null,"Education (RTU)","R <= 13","20 < R","Education (RTU) R <= 13 20 < R",0.44,18.260000000000002,1.08]
[null,"Education (RTU)","13 < R <= 20","13 < R <= 20","Education (RTU) 13 < R <= 20 13 < R <= 20",0.18,6.21,-0.01]
[null,"Education (RTU)","13 < R <= 20","20 < R","Education (RTU) 13 < R <= 20 20 < R",0.22,8.58,0.16]
[null,"Education (RTU)","20 < R","20 < R","Education (RTU) 20 < R 20 < R",0.14000000000000001,5.08,-7.0000000000000007E-2]
[null,"Office (Chiller)","R <= 13","R <= 13",{"$f":"CONCATENATE(B127,\" \",C127,\" \",D127)","v":"Office (Chiller) R <= 13 R <= 13"},0.25,9.4499999999999993,0.7]
[null,"Office (Chiller)","R <= 13","13 < R <= 20","Office (Chiller) R <= 13 13 < R <= 20",0.33,21.39,1.26]
[null,"Office (Chiller)","R <= 13","20 < R","Office (Chiller) R <= 13 20 < R",0.34,23.54,1.23]
[null,"Office (Chiller)","13 < R <= 20","13 < R <= 20","Office (Chiller) 13 < R <= 20 13 < R <= 20",0.17,10.75,0.65]
[null,"Office (Chiller)","13 < R <= 20","20 < R","Office (Chiller) 13 < R <= 20 20 < R",0.18,12.84,0.61]
[null,"Office (Chiller)","20 < R","20 < R","Office (Chiller) 20 < R 20 < R",0.12,4.54,0.12]
[null,"Office (RTU)","R <= 13","R <= 13","Office (RTU) R <= 13 R <= 13",0.28000000000000003,8.3000000000000007,6.91]
[null,"Office (RTU)","R <= 13","13 < R <= 20","Office (RTU) R <= 13 13 < R <= 20",0.46,18.66,37.6]
[null,"Office (RTU)","R <= 13","20 < R","Office (RTU) R <= 13 20 < R",0.54,22.36,50.18]
[null,"Office (RTU)","13 < R <= 20","13 < R <= 20","Office (RTU) 13 < R <= 20 13 < R <= 20",0.19,5.42,4.29]
[null,"Office (RTU)","13 < R <= 20","20 < R","Office (RTU) 13 < R <= 20 20 < R",0.26,8.39,16.87]
[null,"Office (RTU)","20 < R","20 < R","Office (RTU) 20 < R 20 < R",0.15,4.3499999999999996,3.35]
[null,"Hotel","R <= 13","R <= 13",{"$f":"CONCATENATE(B139,\" \",C139,\" \",D139)","v":"Hotel R <= 13 R <= 13"},0.08,1.69,0.54]
[null,"Hotel","R <= 13","13 < R <= 20","Hotel R <= 13 13 < R <= 20",7.0000000000000007E-2,2.2599999999999998,0.17]
[null,"Hotel","R <= 13","20 < R","Hotel R <= 13 20 < R",7.0000000000000007E-2,2.5,-0.02]
[null,"Hotel","13 < R <= 20","13 < R <= 20","Hotel 13 < R <= 20 13 < R <= 20",0.06,1.21,0.37]
[null,"Hotel","13 < R <= 20","20 < R","Hotel 13 < R <= 20 20 < R",0.05,1.43,0.21]
[null,"Hotel","20 < R","20 < R","Hotel 20 < R 20 < R",0.05,1.03,0.32]
[null,"Warehouse","R <= 13","R <= 13","Warehouse R <= 13 R <= 13",0.05,2.96,-0.09]
[null,"Warehouse","R <= 13","13 < R <= 20","Warehouse R <= 13 13 < R <= 20",0.09,5.13,0.76]
[null,"Warehouse","R <= 13","20 < R","Warehouse R <= 13 20 < R",0.16,9.2100000000000009,1.26]
[null,"Warehouse","13 < R <= 20","13 < R <= 20","Warehouse 13 < R <= 20 13 < R <= 20",0.02,1.32,-7.0000000000000007E-2]
[null,"Warehouse","13 < R <= 20","20 < R","Warehouse 13 < R <= 20 20 < R",0.08,4.66,0.43]
[null,"Warehouse","20 < R","20 < R","Warehouse 20 < R 20 < R",0.01,0.79,0.08]
[null,"Other","R <= 13","R <= 13","Other R <= 13 R <= 13",0.05,1.69,-0.28000000000000003]
[null,"Other","R <= 13","13 < R <= 20","Other R <= 13 13 < R <= 20",7.0000000000000007E-2,2.2599999999999998,0.17]
[null,"Other","R <= 13","20 < R","Other R <= 13 20 < R",7.0000000000000007E-2,2.5,-0.02]
[null,"Other","13 < R <= 20","13 < R <= 20","Other 13 < R <= 20 13 < R <= 20",0.02,1.21,-0.28000000000000003]
[null,"Other","13 < R <= 20","20 < R","Other 13 < R <= 20 20 < R",0.05,1.43,0.16]
[null,"Other","20 < R","20 < R","Other 20 < R 20 < R",0.01,0.79,-0.28999999999999998]
[]
[null,"Deemed Savings Coefficients",null,null,null,null,null,"Climate Zone 4: Corpus Christi"]
[null,"Building Type","Demand Factors"]
[null,null,"Pre R-Value","Post R-Value","Lookup","ESF","PSDF","PWDF"]
[null,"Retail","R <= 13","R <= 13",{"$f":"CONCATENATE(B161,\" \",C161,\" \",D161)","v":"Retail R <= 13 R <= 13"},0.62,13.05,54.33]
[null,"Retail","R <= 13","13 < R <= 20","Retail R <= 13 13 < R <= 20",0.99,21.99,35.94]
[null,"Retail","R <= 13","20 < R","Retail R <= 13 20 < R",1,23.21,34.630000000000003]
[null,"Retail","13 < R <= 20","13 < R <= 20","Retail 13 < R <= 20 13 < R <= 20",0.41,8.08,16.2]
[null,"Retail","13 < R <= 20","20 < R","Retail 13 < R <= 20 20 < R",0.41,8.9499999999999993,14.89]
[null,"Retail","20 < R","20 < R","Retail 20 < R 20 < R",0.13,3.42,2.0499999999999998]
[null,"Education (Chiller)","R <= 13","R <= 13","Education (Chiller) R <= 13 R <= 13",0.6,8.4600000000000009,0.28000000000000003]
[null,"Education (Chiller)","R <= 13","13 < R <= 20","Education (Chiller) R <= 13 13 < R <= 20",0.83,13.55,17.329999999999998]
[null,"Education (Chiller)","R <= 13","20 < R","Education (Chiller) R <= 13 20 < R",0.9,15.49,30.14]
[null,"Education (Chiller)","13 < R <= 20","13 < R <= 20","Education (Chiller) 13 < R <= 20 13 < R <= 20",0.31,4.4800000000000004,-3.69]
[null,"Education (Chiller)","13 < R <= 20","20 < R","Education (Chiller) 13 < R <= 20 20 < R",0.36,6,6.37]
[null,"Education (Chiller)","20 < R","20 < R","Education (Chiller) 20 < R 20 < R",0.24,3.64,-0.06]
[null,"Education (RTU)","R <= 13","R <= 13","Education (RTU) R <= 13 R <= 13",0.28000000000000003,7.34,-0.41]
[null,"Education (RTU)","R <= 13","13 < R <= 20","Education (RTU) R <= 13 13 < R <= 20",0.38,11.78,5.15]
[null,"Education (RTU)","R <= 13","20 < R","Education (RTU) R <= 13 20 < R",0.41,13.53,8.09]
[null,"Education (RTU)","13 < R <= 20","13 < R <= 20","Education (RTU) 13 < R <= 20 13 < R <= 20",0.17,4.6399999999999997,-1.46]
[null,"Education (RTU)","13 < R <= 20","20 < R","Education (RTU) 13 < R <= 20 20 < R",0.2,6.29,1.47]
[null,"Education (RTU)","20 < R","20 < R","Education (RTU) 20 < R 20 < R",0.14000000000000001,3.77,-0.14000000000000001]
[null,"Office (Chiller)","R <= 13","R <= 13",{"$f":"CONCATENATE(B179,\" \",C179,\" \",D179)","v":"Office (Chiller) R <= 13 R <= 13"},0.22,6.44,2.33]
[null,"Office (Chiller)","R <= 13","13 < R <= 20","Office (Chiller) R <= 13 13 < R <= 20",0.31,13.55,2.86]
[null,"Office (Chiller)","R <= 13","20 < R","Office (Chiller) R <= 13 20 < R",0.32,15.3,2.4700000000000002]
[null,"Office (Chiller)","13 < R <= 20","13 < R <= 20","Office (Chiller) 13 < R <= 20 13 < R <= 20",0.17,6.34,1.78]
[null,"Office (Chiller)","13 < R <= 20","20 < R","Office (Chiller) 13 < R <= 20 20 < R",0.18,7.96,1.4]
[null,"Office (Chiller)","20 < R","20 < R","Office (Chiller) 20 < R 20 < R",0.1,3.27,0.45]
[null,"Office (RTU)","R <= 13","R <= 13","Office (RTU) R <= 13 R <= 13",0.26,5.0199999999999996,23.11]
[null,"Office (RTU)","R <= 13","13 < R <= 20","Office (RTU) R <= 13 13 < R <= 20",0.4,8.66,78.05]
[null,"Office (RTU)","R <= 13","20 < R","Office (RTU) R <= 13 20 < R",0.45,10.09,100.16]
[null,"Office (RTU)","13 < R <= 20","13 < R <= 20","Office (RTU) 13 < R <= 20 13 < R <= 20",0.18,3.61,15.1]
[null,"Office (RTU)","13 < R <= 20","20 < R","Office (RTU) 13 < R <= 20 20 < R",0.24,4.83,37.21]
[null,"Office (RTU)","20 < R","20 < R","Office (RTU) 20 < R 20 < R",0.15,2.95,10.35]
[null,"Hotel","R <= 13","R <= 13",{"$f":"CONCATENATE(B191,\" \",C191,\" \",D191)","v":"Hotel R <= 13 R <= 13"},7.0000000000000007E-2,1.1299999999999999,1.99]
[null,"Hotel","R <= 13","13 < R <= 20","Hotel R <= 13 13 < R <= 20",7.0000000000000007E-2,1.44,-1.23]
[null,"Hotel","R <= 13","20 < R","Hotel R <= 13 20 < R",7.0000000000000007E-2,1.57,-2.7]
[null,"Hotel","13 < R <= 20","13 < R <= 20","Hotel 13 < R <= 20 13 < R <= 20",0.05,0.78,1.36]
[null,"Hotel","13 < R <= 20","20 < R","Hotel 13 < R <= 20 20 < R",0.05,0.9,0]
[null,"Hotel","20 < R","20 < R","Hotel 20 < R 20 < R",0.04,0.67,1.19]
[null,"Warehouse","R <= 13","R <= 13","Warehouse R <= 13 R <= 13",0.05,2.1,0.22]
[null,"Warehouse","R <= 13","13 < R <= 20","Warehouse R <= 13 13 < R <= 20",0.09,3.51,1.39]
[null,"Warehouse","R <= 13","20 < R","Warehouse R <= 13 20 < R",0.16,6.54,1.35]
[null,"Warehouse","13 < R <= 20","13 < R <= 20","Warehouse 13 < R <= 20 13 < R <= 20",0.02,1.21,0.28000000000000003]
[null,"Warehouse","13 < R <= 20","20 < R","Warehouse 13 < R <= 20 20 < R",0.08,3.71,0.24]
[null,"Warehouse","20 < R","20 < R","Warehouse 20 < R 20 < R",0.01,0.7,-7.0000000000000007E-2]
[null,"Other","R <= 13","R <= 13","Other R <= 13 R <= 13",0.05,1.1299999999999999,-0.41]
[null,"Other","R <= 13","13 < R <= 20","Other R <= 13 13 < R <= 20",7.0000000000000007E-2,1.44,-1.23]
[null,"Other","R <= 13","20 < R","Other R <= 13 20 < R",7.0000000000000007E-2,1.57,-2.7]
[null,"Other","13 < R <= 20","13 < R <= 20","Other 13 < R <= 20 13 < R <= 20",0.02,0.78,-3.69]
[null,"Other","13 < R <= 20","20 < R","Other 13 < R <= 20 20 < R",0.05,0.9,0]
[null,"Other","20 < R","20 < R","Other 20 < R 20 < R",0.01,0.67,-0.14000000000000001]
[]
[null,"Deemed Savings Coefficients",null,null,null,null,null,"Climate Zone 5: El Paso"]
[null,"Building Type","Demand Factors"]
[null,null,"Pre R-Value","Post R-Value","Lookup","ESF","PSDF","PWDF"]
[null,"Retail","R <= 13","R <= 13",{"$f":"CONCATENATE(B213,\" \",C213,\" \",D213)","v":"Retail R <= 13 R <= 13"},0.67,16.55,42.72]
[null,"Retail","R <= 13","13 < R <= 20","Retail R <= 13 13 < R <= 20",1.01,26.85,67.8]
[null,"Retail","R <= 13","20 < R","Retail R <= 13 20 < R",1.02,28.78,65.27]
[null,"Retail","13 < R <= 20","13 < R <= 20","Retail 13 < R <= 20 13 < R <= 20",0.19,5.83,6.64]
[null,"Retail","13 < R <= 20","20 < R","Retail 13 < R <= 20 20 < R",0.19,7.24,4.12]
[null,"Retail","20 < R","20 < R","Retail 20 < R 20 < R",0.15,4.74,5.4]
[null,"Education (Chiller)","R <= 13","R <= 13","Education (Chiller) R <= 13 R <= 13",0.69,9.09,3.85]
[null,"Education (Chiller)","R <= 13","13 < R <= 20","Education (Chiller) R <= 13 13 < R <= 20",0.97,14.42,4.87]
[null,"Education (Chiller)","R <= 13","20 < R","Education (Chiller) R <= 13 20 < R",1.07,16.52,5.43]
[null,"Education (Chiller)","13 < R <= 20","13 < R <= 20","Education (Chiller) 13 < R <= 20 13 < R <= 20",0.36,4.8,1.87]
[null,"Education (Chiller)","13 < R <= 20","20 < R","Education (Chiller) 13 < R <= 20 20 < R",0.44,6.47,2.34]
[null,"Education (Chiller)","20 < R","20 < R","Education (Chiller) 20 < R 20 < R",0.28000000000000003,3.91,1.19]
[null,"Education (RTU)","R <= 13","R <= 13","Education (RTU) R <= 13 R <= 13",0.3,8.2100000000000009,3.09]
[null,"Education (RTU)","R <= 13","13 < R <= 20","Education (RTU) R <= 13 13 < R <= 20",0.42,13.43,4.0199999999999996]
[null,"Education (RTU)","R <= 13","20 < R","Education (RTU) R <= 13 20 < R",0.46,15.49,4.2699999999999996]
[null,"Education (RTU)","13 < R <= 20","13 < R <= 20","Education (RTU) 13 < R <= 20 13 < R <= 20",0.18,5.16,1.47]
[null,"Education (RTU)","13 < R <= 20","20 < R","Education (RTU) 13 < R <= 20 20 < R",0.22,7.09,1.72]
[null,"Education (RTU)","20 < R","20 < R","Education (RTU) 20 < R 20 < R",0.14000000000000001,4.1399999999999997,0.86]
[null,"Office (Chiller)","R <= 13","R <= 13",{"$f":"CONCATENATE(B231,\" \",C231,\" \",D231)","v":"Office (Chiller) R <= 13 R <= 13"},0.28999999999999998,9.7200000000000006,7.27]
[null,"Office (Chiller)","R <= 13","13 < R <= 20","Office (Chiller) R <= 13 13 < R <= 20",0.39,17.57,12.46]
[null,"Office (Chiller)","R <= 13","20 < R","Office (Chiller) R <= 13 20 < R",0.42,20.350000000000001,13.25]
[null,"Office (Chiller)","13 < R <= 20","13 < R <= 20","Office (Chiller) 13 < R <= 20 13 < R <= 20",0.17,6.68,0.12]
[null,"Office (Chiller)","13 < R <= 20","20 < R","Office (Chiller) 13 < R <= 20 20 < R",0.2,9.2200000000000006,0.79]
[null,"Office (Chiller)","20 < R","20 < R","Office (Chiller) 20 < R 20 < R",0.14000000000000001,5.39,2.02]
[null,"Office (RTU)","R <= 13","R <= 13","Office (RTU) R <= 13 R <= 13",0.31,9.93,24.02]
[null,"Office (RTU)","R <= 13","13 < R <= 20","Office (RTU) R <= 13 13 < R <= 20",0.55000000000000004,16.57,105.15]
[null,"Office (RTU)","R <= 13","20 < R","Office (RTU) R <= 13 20 < R",0.64,19.260000000000002,135.96]
[null,"Office (RTU)","13 < R <= 20","13 < R <= 20","Office (RTU) 13 < R <= 20 13 < R <= 20",0.2,5.75,16.21]
[null,"Office (RTU)","13 < R <= 20","20 < R","Office (RTU) 13 < R <= 20 20 < R",0.28999999999999998,7.78,47.02]
[null,"Office (RTU)","20 < R","20 < R","Office (RTU) 20 < R 20 < R",0.16,4.7,12.77]
[null,"Hotel","R <= 13","R <= 13",{"$f":"CONCATENATE(B243,\" \",C243,\" \",D243)","v":"Hotel R <= 13 R <= 13"},0.1,1.33,7.04]
[null,"Hotel","R <= 13","13 < R <= 20","Hotel R <= 13 13 < R <= 20",0.08,1.58,1.8]
[null,"Hotel","R <= 13","20 < R","Hotel R <= 13 20 < R",0.08,1.68,-0.78]
[null,"Hotel","13 < R <= 20","13 < R <= 20","Hotel 13 < R <= 20 13 < R <= 20",7.0000000000000007E-2,0.95,4.9800000000000004]
[null,"Hotel","13 < R <= 20","20 < R","Hotel 13 < R <= 20 20 < R",0.06,1.04,2.57]
[null,"Hotel","20 < R","20 < R","Hotel 20 < R 20 < R",0.06,0.81,4.2699999999999996]
[null,"Warehouse","R <= 13","R <= 13","Warehouse R <= 13 R <= 13",0.04,2.76,-0.61]
[null,"Warehouse","R <= 13","13 < R <= 20","Warehouse R <= 13 13 < R <= 20",0.09,4.91,1.33]
[null,"Warehouse","R <= 13","20 < R","Warehouse R <= 13 20 < R",0.15,8.27,2.06]
[null,"Warehouse","13 < R <= 20","13 < R <= 20","Warehouse 13 < R <= 20 13 < R <= 20",0.02,1.31,-0.42]
[null,"Warehouse","13 < R <= 20","20 < R","Warehouse 13 < R <= 20 20 < R",7.0000000000000007E-2,3.98,0.3]
[null,"Warehouse","20 < R","20 < R","Warehouse 20 < R 20 < R",0.01,0.76,-0.19]
[null,"Other","R <= 13","R <= 13","Other R <= 13 R <= 13",0.04,1.33,-0.61]
[null,"Other","R <= 13","13 < R <= 20","Other R <= 13 13 < R <= 20",0.08,1.58,1.33]
[null,"Other","R <= 13","20 < R","Other R <= 13 20 < R",0.08,1.68,-0.78]
[null,"Other","13 < R <= 20","13 < R <= 20","Other 13 < R <= 20 13 < R <= 20",0.02,0.95,-0.42]
[null,"Other","13 < R <= 20","20 < R","Other 13 < R <= 20 20 < R",0.06,1.04,0.3]
[null,"Other","20 < R","20 < R","Other 20 < R 20 < R",0.01,0.76,-0.19]
[]
[null,"Deemed Savings Coefficients",null,null,null,null,null,{"$f":"'Project Info'!$D9","v":"Select county in previous cell"}]
[null,"Building Type","Demand Factors"]
[null,null,"Pre R-Value","Post R-Value","Lookup","ESF","PSDF","PWDF"]
[null,"Retail","R <= 13","R <= 13",{"$f":"CONCATENATE(B265,\" \",C265,\" \",D265)","v":"Retail R <= 13 R <= 13"},{"$f":"IF($H$262=\"Amarillo\",F5,IF($H$262=\"Dallas\",F57, IF($H$262=\"Houston\",F109, IF($H$262=\"Corpus Christi\",F161,IF($H$262=\"El Paso\",F213,0)))))","v":0},{"$f":"IF($H$262=\"Amarillo\",G5,IF($H$262=\"Dallas\",G57, IF($H$262=\"Houston\",G109, IF($H$262=\"Corpus Christi\",G161,IF($H$262=\"El Paso\",G213,0)))))","v":0},{"$f":"IF($H$262=\"Amarillo\",H5,IF($H$262=\"Dallas\",H57, IF($H$262=\"Houston\",H109, IF($H$262=\"Corpus Christi\",H161,IF($H$262=\"El Paso\",H213,0)))))","v":0}]
[null,"Retail","R <= 13","13 < R <= 20","Retail R <= 13 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F6,IF($H$262=\"Dallas\",F58, IF($H$262=\"Houston\",F110, IF($H$262=\"Corpus Christi\",F162,IF($H$262=\"El Paso\",F214,0)))))","v":0},0,0]
[null,"Retail","R <= 13","20 < R","Retail R <= 13 20 < R",{"$f":"IF($H$262=\"Amarillo\",F7,IF($H$262=\"Dallas\",F59, IF($H$262=\"Houston\",F111, IF($H$262=\"Corpus Christi\",F163,IF($H$262=\"El Paso\",F215,0)))))","v":0},0,0]
[null,"Retail","13 < R <= 20","13 < R <= 20","Retail 13 < R <= 20 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F8,IF($H$262=\"Dallas\",F60, IF($H$262=\"Houston\",F112, IF($H$262=\"Corpus Christi\",F164,IF($H$262=\"El Paso\",F216,0)))))","v":0},0,0]
[null,"Retail","13 < R <= 20","20 < R","Retail 13 < R <= 20 20 < R",{"$f":"IF($H$262=\"Amarillo\",F9,IF($H$262=\"Dallas\",F61, IF($H$262=\"Houston\",F113, IF($H$262=\"Corpus Christi\",F165,IF($H$262=\"El Paso\",F217,0)))))","v":0},0,0]
[null,"Retail","20 < R","20 < R","Retail 20 < R 20 < R",{"$f":"IF($H$262=\"Amarillo\",F10,IF($H$262=\"Dallas\",F62, IF($H$262=\"Houston\",F114, IF($H$262=\"Corpus Christi\",F166,IF($H$262=\"El Paso\",F218,0)))))","v":0},0,0]
[null,"Education (Chiller)","R <= 13","R <= 13","Education (Chiller) R <= 13 R <= 13",{"$f":"IF($H$262=\"Amarillo\",F11,IF($H$262=\"Dallas\",F63, IF($H$262=\"Houston\",F115, IF($H$262=\"Corpus Christi\",F167,IF($H$262=\"El Paso\",F219,0)))))","v":0},0,0]
[null,"Education (Chiller)","R <= 13","13 < R <= 20","Education (Chiller) R <= 13 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F12,IF($H$262=\"Dallas\",F64, IF($H$262=\"Houston\",F116, IF($H$262=\"Corpus Christi\",F168,IF($H$262=\"El Paso\",F220,0)))))","v":0},0,0]
[null,"Education (Chiller)","R <= 13","20 < R","Education (Chiller) R <= 13 20 < R",{"$f":"IF($H$262=\"Amarillo\",F13,IF($H$262=\"Dallas\",F65, IF($H$262=\"Houston\",F117, IF($H$262=\"Corpus Christi\",F169,IF($H$262=\"El Paso\",F221,0)))))","v":0},0,0]
[null,"Education (Chiller)","13 < R <= 20","13 < R <= 20","Education (Chiller) 13 < R <= 20 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F14,IF($H$262=\"Dallas\",F66, IF($H$262=\"Houston\",F118, IF($H$262=\"Corpus Christi\",F170,IF($H$262=\"El Paso\",F222,0)))))","v":0},0,0]
[null,"Education (Chiller)","13 < R <= 20","20 < R","Education (Chiller) 13 < R <= 20 20 < R",{"$f":"IF($H$262=\"Amarillo\",F15,IF($H$262=\"Dallas\",F67, IF($H$262=\"Houston\",F119, IF($H$262=\"Corpus Christi\",F171,IF($H$262=\"El Paso\",F223,0)))))","v":0},0,0]
[null,"Education (Chiller)","20 < R","20 < R","Education (Chiller) 20 < R 20 < R",{"$f":"IF($H$262=\"Amarillo\",F16,IF($H$262=\"Dallas\",F68, IF($H$262=\"Houston\",F120, IF($H$262=\"Corpus Christi\",F172,IF($H$262=\"El Paso\",F224,0)))))","v":0},0,0]
[null,"Education (RTU)","R <= 13","R <= 13","Education (RTU) R <= 13 R <= 13",{"$f":"IF($H$262=\"Amarillo\",F17,IF($H$262=\"Dallas\",F69, IF($H$262=\"Houston\",F121, IF($H$262=\"Corpus Christi\",F173,IF($H$262=\"El Paso\",F225,0)))))","v":0},0,0]
[null,"Education (RTU)","R <= 13","13 < R <= 20","Education (RTU) R <= 13 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F18,IF($H$262=\"Dallas\",F70, IF($H$262=\"Houston\",F122, IF($H$262=\"Corpus Christi\",F174,IF($H$262=\"El Paso\",F226,0)))))","v":0},0,0]
[null,"Education (RTU)","R <= 13","20 < R","Education (RTU) R <= 13 20 < R",{"$f":"IF($H$262=\"Amarillo\",F19,IF($H$262=\"Dallas\",F71, IF($H$262=\"Houston\",F123, IF($H$262=\"Corpus Christi\",F175,IF($H$262=\"El Paso\",F227,0)))))","v":0},0,0]
[null,"Education (RTU)","13 < R <= 20","13 < R <= 20","Education (RTU) 13 < R <= 20 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F20,IF($H$262=\"Dallas\",F72, IF($H$262=\"Houston\",F124, IF($H$262=\"Corpus Christi\",F176,IF($H$262=\"El Paso\",F228,0)))))","v":0},0,0]
[null,"Education (RTU)","13 < R <= 20","20 < R","Education (RTU) 13 < R <= 20 20 < R",{"$f":"IF($H$262=\"Amarillo\",F21,IF($H$262=\"Dallas\",F73, IF($H$262=\"Houston\",F125, IF($H$262=\"Corpus Christi\",F177,IF($H$262=\"El Paso\",F229,0)))))","v":0},0,0]
[null,"Education (RTU)","20 < R","20 < R","Education (RTU) 20 < R 20 < R",{"$f":"IF($H$262=\"Amarillo\",F22,IF($H$262=\"Dallas\",F74, IF($H$262=\"Houston\",F126, IF($H$262=\"Corpus Christi\",F178,IF($H$262=\"El Paso\",F230,0)))))","v":0},0,0]
[null,"Office (Chiller)","R <= 13","R <= 13",{"$f":"CONCATENATE(B283,\" \",C283,\" \",D283)","v":"Office (Chiller) R <= 13 R <= 13"},{"$f":"IF($H$262=\"Amarillo\",F23,IF($H$262=\"Dallas\",F75, IF($H$262=\"Houston\",F127, IF($H$262=\"Corpus Christi\",F179,IF($H$262=\"El Paso\",F231,0)))))","v":0},0,0]
[null,"Office (Chiller)","R <= 13","13 < R <= 20","Office (Chiller) R <= 13 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F24,IF($H$262=\"Dallas\",F76, IF($H$262=\"Houston\",F128, IF($H$262=\"Corpus Christi\",F180,IF($H$262=\"El Paso\",F232,0)))))","v":0},0,0]
[null,"Office (Chiller)","R <= 13","20 < R","Office (Chiller) R <= 13 20 < R",{"$f":"IF($H$262=\"Amarillo\",F25,IF($H$262=\"Dallas\",F77, IF($H$262=\"Houston\",F129, IF($H$262=\"Corpus Christi\",F181,IF($H$262=\"El Paso\",F233,0)))))","v":0},0,0]
[null,"Office (Chiller)","13 < R <= 20","13 < R <= 20","Office (Chiller) 13 < R <= 20 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F26,IF($H$262=\"Dallas\",F78, IF($H$262=\"Houston\",F130, IF($H$262=\"Corpus Christi\",F182,IF($H$262=\"El Paso\",F234,0)))))","v":0},0,0]
[null,"Office (Chiller)","13 < R <= 20","20 < R","Office (Chiller) 13 < R <= 20 20 < R",{"$f":"IF($H$262=\"Amarillo\",F27,IF($H$262=\"Dallas\",F79, IF($H$262=\"Houston\",F131, IF($H$262=\"Corpus Christi\",F183,IF($H$262=\"El Paso\",F235,0)))))","v":0},0,0]
[null,"Office (Chiller)","20 < R","20 < R","Office (Chiller) 20 < R 20 < R",{"$f":"IF($H$262=\"Amarillo\",F28,IF($H$262=\"Dallas\",F80, IF($H$262=\"Houston\",F132, IF($H$262=\"Corpus Christi\",F184,IF($H$262=\"El Paso\",F236,0)))))","v":0},0,0]
[null,"Office (RTU)","R <= 13","R <= 13","Office (RTU) R <= 13 R <= 13",{"$f":"IF($H$262=\"Amarillo\",F29,IF($H$262=\"Dallas\",F81, IF($H$262=\"Houston\",F133, IF($H$262=\"Corpus Christi\",F185,IF($H$262=\"El Paso\",F237,0)))))","v":0},0,0]
[null,"Office (RTU)","R <= 13","13 < R <= 20","Office (RTU) R <= 13 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F30,IF($H$262=\"Dallas\",F82, IF($H$262=\"Houston\",F134, IF($H$262=\"Corpus Christi\",F186,IF($H$262=\"El Paso\",F238,0)))))","v":0},0,0]
[null,"Office (RTU)","R <= 13","20 < R","Office (RTU) R <= 13 20 < R",{"$f":"IF($H$262=\"Amarillo\",F31,IF($H$262=\"Dallas\",F83, IF($H$262=\"Houston\",F135, IF($H$262=\"Corpus Christi\",F187,IF($H$262=\"El Paso\",F239,0)))))","v":0},0,0]
[null,"Office (RTU)","13 < R <= 20","13 < R <= 20","Office (RTU) 13 < R <= 20 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F32,IF($H$262=\"Dallas\",F84, IF($H$262=\"Houston\",F136, IF($H$262=\"Corpus Christi\",F188,IF($H$262=\"El Paso\",F240,0)))))","v":0},0,0]
[null,"Office (RTU)","13 < R <= 20","20 < R","Office (RTU) 13 < R <= 20 20 < R",{"$f":"IF($H$262=\"Amarillo\",F33,IF($H$262=\"Dallas\",F85, IF($H$262=\"Houston\",F137, IF($H$262=\"Corpus Christi\",F189,IF($H$262=\"El Paso\",F241,0)))))","v":0},0,0]
[null,"Office (RTU)","20 < R","20 < R","Office (RTU) 20 < R 20 < R",{"$f":"IF($H$262=\"Amarillo\",F34,IF($H$262=\"Dallas\",F86, IF($H$262=\"Houston\",F138, IF($H$262=\"Corpus Christi\",F190,IF($H$262=\"El Paso\",F242,0)))))","v":0},0,0]
[null,"Hotel","R <= 13","R <= 13",{"$f":"CONCATENATE(B295,\" \",C295,\" \",D295)","v":"Hotel R <= 13 R <= 13"},{"$f":"IF($H$262=\"Amarillo\",F35,IF($H$262=\"Dallas\",F87, IF($H$262=\"Houston\",F139, IF($H$262=\"Corpus Christi\",F191,IF($H$262=\"El Paso\",F243,0)))))","v":0},0,0]
[null,"Hotel","R <= 13","13 < R <= 20","Hotel R <= 13 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F36,IF($H$262=\"Dallas\",F88, IF($H$262=\"Houston\",F140, IF($H$262=\"Corpus Christi\",F192,IF($H$262=\"El Paso\",F244,0)))))","v":0},0,0]
[null,"Hotel","R <= 13","20 < R","Hotel R <= 13 20 < R",{"$f":"IF($H$262=\"Amarillo\",F37,IF($H$262=\"Dallas\",F89, IF($H$262=\"Houston\",F141, IF($H$262=\"Corpus Christi\",F193,IF($H$262=\"El Paso\",F245,0)))))","v":0},0,0]
[null,"Hotel","13 < R <= 20","13 < R <= 20","Hotel 13 < R <= 20 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F38,IF($H$262=\"Dallas\",F90, IF($H$262=\"Houston\",F142, IF($H$262=\"Corpus Christi\",F194,IF($H$262=\"El Paso\",F246,0)))))","v":0},0,0]
[null,"Hotel","13 < R <= 20","20 < R","Hotel 13 < R <= 20 20 < R",{"$f":"IF($H$262=\"Amarillo\",F39,IF($H$262=\"Dallas\",F91, IF($H$262=\"Houston\",F143, IF($H$262=\"Corpus Christi\",F195,IF($H$262=\"El Paso\",F247,0)))))","v":0},0,0]
[null,"Hotel","20 < R","20 < R","Hotel 20 < R 20 < R",{"$f":"IF($H$262=\"Amarillo\",F40,IF($H$262=\"Dallas\",F92, IF($H$262=\"Houston\",F144, IF($H$262=\"Corpus Christi\",F196,IF($H$262=\"El Paso\",F248,0)))))","v":0},0,0]
[null,"Warehouse","R <= 13","R <= 13","Warehouse R <= 13 R <= 13",{"$f":"IF($H$262=\"Amarillo\",F41,IF($H$262=\"Dallas\",F93, IF($H$262=\"Houston\",F145, IF($H$262=\"Corpus Christi\",F197,IF($H$262=\"El Paso\",F249,0)))))","v":0},0,0]
[null,"Warehouse","R <= 13","13 < R <= 20","Warehouse R <= 13 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F42,IF($H$262=\"Dallas\",F94, IF($H$262=\"Houston\",F146, IF($H$262=\"Corpus Christi\",F198,IF($H$262=\"El Paso\",F250,0)))))","v":0},0,0]
[null,"Warehouse","R <= 13","20 < R","Warehouse R <= 13 20 < R",{"$f":"IF($H$262=\"Amarillo\",F43,IF($H$262=\"Dallas\",F95, IF($H$262=\"Houston\",F147, IF($H$262=\"Corpus Christi\",F199,IF($H$262=\"El Paso\",F251,0)))))","v":0},0,0]
[null,"Warehouse","13 < R <= 20","13 < R <= 20","Warehouse 13 < R <= 20 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F44,IF($H$262=\"Dallas\",F96, IF($H$262=\"Houston\",F148, IF($H$262=\"Corpus Christi\",F200,IF($H$262=\"El Paso\",F252,0)))))","v":0},0,0]
[null,"Warehouse","13 < R <= 20","20 < R","Warehouse 13 < R <= 20 20 < R",{"$f":"IF($H$262=\"Amarillo\",F45,IF($H$262=\"Dallas\",F97, IF($H$262=\"Houston\",F149, IF($H$262=\"Corpus Christi\",F201,IF($H$262=\"El Paso\",F253,0)))))","v":0},0,0]
[null,"Warehouse","20 < R","20 < R","Warehouse 20 < R 20 < R",{"$f":"IF($H$262=\"Amarillo\",F46,IF($H$262=\"Dallas\",F98, IF($H$262=\"Houston\",F150, IF($H$262=\"Corpus Christi\",F202,IF($H$262=\"El Paso\",F254,0)))))","v":0},0,0]
[null,"Other","R <= 13","R <= 13","Other R <= 13 R <= 13",{"$f":"IF($H$262=\"Amarillo\",F47,IF($H$262=\"Dallas\",F99, IF($H$262=\"Houston\",F151, IF($H$262=\"Corpus Christi\",F203,IF($H$262=\"El Paso\",F255,0)))))","v":0},0,0]
[null,"Other","R <= 13","13 < R <= 20","Other R <= 13 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F48,IF($H$262=\"Dallas\",F100, IF($H$262=\"Houston\",F152, IF($H$262=\"Corpus Christi\",F204,IF($H$262=\"El Paso\",F256,0)))))","v":0},0,0]
[null,"Other","R <= 13","20 < R","Other R <= 13 20 < R",{"$f":"IF($H$262=\"Amarillo\",F49,IF($H$262=\"Dallas\",F101, IF($H$262=\"Houston\",F153, IF($H$262=\"Corpus Christi\",F205,IF($H$262=\"El Paso\",F257,0)))))","v":0},0,0]
[null,"Other","13 < R <= 20","13 < R <= 20","Other 13 < R <= 20 13 < R <= 20",{"$f":"IF($H$262=\"Amarillo\",F50,IF($H$262=\"Dallas\",F102, IF($H$262=\"Houston\",F154, IF($H$262=\"Corpus Christi\",F206,IF($H$262=\"El Paso\",F258,0)))))","v":0},0,0]
[null,"Other","13 < R <= 20","20 < R","Other 13 < R <= 20 20 < R",{"$f":"IF($H$262=\"Amarillo\",F51,IF($H$262=\"Dallas\",F103, IF($H$262=\"Houston\",F155, IF($H$262=\"Corpus Christi\",F207,IF($H$262=\"El Paso\",F259,0)))))","v":0},0,0]
[null,"Other","20 < R","20 < R","Other 20 < R 20 < R",{"$f":"IF($H$262=\"Amarillo\",F52,IF($H$262=\"Dallas\",F104, IF($H$262=\"Houston\",F156, IF($H$262=\"Corpus Christi\",F208,IF($H$262=\"El Paso\",F260,0)))))","v":0},0,0]

{"sheet":"Notes","index":6,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Utility Admin use ONLY. Use this page to enter any project notes for the statewide evaluator."]

{"sheet":"Utility Admin","index":7,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,14,1,15],[1,12,1,13],[1,11,2,11],[1,4,1,5],[1,1,2,1],[1,8,2,8],[1,3,2,3],[1,10,2,10],[1,2,2,2],[1,9,2,9]]}
[]
[null,"Utility","State","Program","Rates",null,"LFC",null,"Utility","State","Program","Utility/Program\nDesignation","Rates",null,"Load Factor"]
[null,null,null,null,"Demand\n(kW)","Energy\n(kWh)","kWh/kW",null,null,null,null,null,"Demand\n(kW)","Energy\n(kWh)","%","kWh/kW"]
[null,{"$f":"IF('Project Info'!$D$6=\"\",\"Not Selected\",'Project Info'!$D$6)","v":"Not Selected"},"Texas",{"$f":"IF('Project Info'!$D$11=\"\",\"Not Selected\",'Project Info'!$D$11)","v":"Not Selected"},{"$f":"IF(OR($B$4=\"Not Selected\",$C$4=\"Not Selected\",$D$4=\"Not Selected\"),0,VLOOKUP(CONCATENATE($B$4,$C$4,$D$4),$L:$N,2,FALSE))","v":0},{"$f":"IF(OR($B$4=\"Not Selected\",$C$4=\"Not Selected\",$D$4=\"Not Selected\"),0,VLOOKUP(CONCATENATE($B$4,$C$4,$D$4),$L:$N,3,FALSE))","v":0},{"$f":"IF(OR($B$4=\"Not Selected\",$C$4=\"Not Selected\",$D$4=\"Not Selected\"),0,VLOOKUP(CONCATENATE($B$4,$C$4,$D$4),$L:$P,5,FALSE))","v":0},null,"AEP SWEPCO","Texas","Commercial SOP",{"$f":"CONCATENATE($I4,$J4,$K4)","v":"AEP SWEPCOTexasCommercial SOP"},240,0.08,1,999999999]
[null,null,null,null,null,null,null,null,"AEP SWEPCO","Texas","COMPASS","AEP SWEPCOTexasCOMPASS",400,0,1,999999999]
[null,null,null,null,null,null,null,null,"AEP Texas Central Division","Texas","Commercial SOP",{"$f":"CONCATENATE($I6,$J6,$K6)","v":"AEP Texas Central DivisionTexasCommercial SOP"},200,7.0000000000000007E-2,1,999999999]
[null,null,null,null,null,null,null,null,"AEP Texas North Division","Texas","Commercial SOP","AEP Texas North DivisionTexasCommercial SOP",200,7.0000000000000007E-2,1,999999999]
[null,null,null,null,null,null,null,null,"CenterPoint Energy","Texas","Commercial SOP","CenterPoint EnergyTexasCommercial SOP",240,0.09,1,999999999]
[null,null,null,null,null,null,null,null,"CenterPoint Energy","Texas","Commercial MTP","CenterPoint EnergyTexasCommercial MTP",240,0.09,1,999999999]
[null,null,null,null,null,null,null,null,"Entergy","Texas","Commercial Solutions","EntergyTexasCommercial Solutions",250,0.02,1,999999999]
[null,null,null,null,null,null,null,null,"Oncor","Texas","Commercial SOP","OncorTexasCommercial SOP",0,0,1,999999999]
[null,null,null,null,null,null,null,null,"Texas-New Mexico Power","Texas","Commercial Solutions","Texas-New Mexico PowerTexasCommercial Solutions",170,0.05,1,999999999]
[null,null,null,null,null,null,null,null,"Texas-New Mexico Power","Texas","SCORE/CitySmart","Texas-New Mexico PowerTexasSCORE/CitySmart",170,0.05,1,999999999]
[null,null,null,null,null,null,null,null,"Texas-New Mexico Power","Texas","Small SCORE/CitySmart","Texas-New Mexico PowerTexasSmall SCORE/CitySmart",270,0.05,1,999999999]
[null,null,null,null,null,null,null,null,"Xcel Energy","Texas","Commercial SOP","Xcel EnergyTexasCommercial SOP",220,7.0000000000000007E-2,1,999999999]
[null,null,null,null,null,null,null,null,"Xcel Energy","Texas","Retro-Commissioning","Xcel EnergyTexasRetro-Commissioning",220,7.0000000000000007E-2,1,999999999]
[null,null,null,null,null,null,null,null,"Xcel Energy","Texas","Small Business Market Transformation","Xcel EnergyTexasSmall Business Market Transformation",0,0.4,1,999999999]

{"sheet":"Reader","index":8,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[2024.1]
[null,"Business Name:"]
[null,"Project Site Address:"]
[null,"City:"]
[null,"State:"]
[null,"ZIP Code:"]
[null,"Sponsor Name:"]
[null,"Utility Name:"]
[null,"Climate Zone:"]
[]
[null,"Savings Summary"]
[]
[null,"Total Calculated\nProject Savings","Total Summer\nkW Savings",null,null,"Total\nkWh Savings"]
[]
[null,"Claimed\nProject Savings","Total\nkW Savings","Total\nkWh Savings","Estimated\nIncentive","EUL"]
[null,null,0,0,0,15]
[]
[null,"CRC Version",2024.1]

{"sheet":"Reader2","index":9,"n_rows":22,"n_cols":34,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Building Type\n(select from list)","Roof Description",null,null,null,null,"Installed Cool Roof Rating Council (CRRC) Material Description",null,null,null,null,null,"Measure\nLife","Total kW\nSavings","Total kWh\nSavings","Estimated\nPayment","R-Value\nLookup","Existing\nR-Value","Installed\nR-Value","Savings\nFactor\nLookup","PSDF","PWDF","ESF","Summer\nkW\nSavings","Winter\nkW\nSavings","kWh\nSavings","Incentive Rates",null,"Estimated\nPayment"]
[null,null,null,"Roof Slope","Treated\nRoof Surface Area\nover Conditioned\nSpace ONLY\n(ft2)","Percent of Total\nRoof Surface Area\nover Conditioned Space ONLY\n(Treated Area ÷\nTotal Area)","Existing Insulation\nR-Value\n(if known)","Year of Building Construction\n(if existing R-value unknown)","Manufacturer","Model","Installed Insulation\nR-Value\n(Defaults to\nExisting Insulation\nR-value)","Initial\nSolar\nReflectance","3-Year\nSolar\nReflectance","Rated Life\n(Years)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/kW","$/kWh"]
[]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0,null,"R <= 13","PostRVal3"]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0,null,"13 < R <= 20","PostRVal2"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0,null,"20 < R","PostRVal1"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0,null,"Before 2011","R <= 13"]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0,null,"2011-2016","13 < R <= 20"]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0,null,"After 2016","20 < R"]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,null,null,null,"  ",0,0,0,0,0,0,0,0,0]
[null,"If you need more rows, please contact program administrator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total kW Savings","Total kWh Savings","Estimated Payment"]