{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Customer Information","Savings Calculations","Dryer Inputs and Calculations","Desiccant Dryer","Explanation of Inputs","Master Outputs","Cooling Fan VFD","Weather","Correction Factors","Operating Power","Instructions"],"not_rendered":{"charts":10,"images":19,"macros":1,"external_links":2,"defined_names":162,"comments":3,"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":"Customer Information","index":0,"n_rows":252,"n_cols":46,"rows_kept":252,"cut":false,"hidden":false,"merged":[[3,22,4,31],[7,18,7,27],[7,3,7,17],[22,16,22,24],[9,17,9,31],[11,25,11,27],[13,2,13,7],[9,3,9,16],[20,3,20,15],[7,28,7,31],[22,3,22,15],[13,8,13,13],[20,25,20,31],[13,14,13,22],[22,25,22,27],[22,28,22,31],[60,3,60,31],[30,21,30,31],[20,16,20,24],[11,17,11,24],[11,3,11,16],[26,3,26,11],[30,3,30,5],[35,3,35,14],[24,3,24,11],[24,12,24,20],[35,15,35,23],[30,12,30,14],[35,24,35,31],[11,28,11,31],[13,23,13,31]]}
[]
[null,false]
[]
[null,null,null,"BPA Small Compressed Air Calculator"]
[null,null,null,"and Incentive Funding Application Tool"]
[null,null,null,"PARTICIPANT INFORMATION"]
[null,null,null,"Company Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prepared by:",null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,"Contact:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Title:"]
[]
[null,null,null,"Mailing Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,"State:",null,null,"Zip:"]
[]
[null,null,null,"Cell/Tel:",null,null,null,null,"Fax:",null,null,null,null,null,"Email:",null,null,null,null,null,null,null,null,"Business Type:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manufacturing"]
[]
[]
[null,null,null,"PROJECT INFORMATION"]
[]
[]
[null,null,null,"Utility name:",null,null,null,null,null,null,null,null,null,null,null,null,"BES:",null,null,null,null,null,null,null,null,"Average electric rate per kWh:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Master Outputs'!A92,'Master Outputs'!A93:C230,3,0),\"\")","v":"10170"},null,null,null,null,null,null,null,null,5.7099999999999998E-2]
[null,null,null,"Project Site Address, if different:",null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,"State:",null,null,"Zip:"]
[]
[null,null,null,"County:",null,null,null,null,null,null,null,null,"Type of Industry (select):",null,null,null,null,null,null,null,null,null,"Reason for project (check only one):"]
[null,null,null,"Lane"]
[null,null,null,"Sector (select):"]
[]
[]
[null,null,null,"UTILITY INCENTIVE PROGRAM INFORMATION"]
[null,null,null,"Incentive rate offered by utility:",null,null,null,null,null,null,null,null,"Incentive cap:",null,null,null,null,null,null,null,null,"Additional non-utility funding (if applicable):"]
[null,null,null,0.33,null,null,"per kWh annual savings",null,null,null,null,null,0.7,null,null,"of eligible project cost"]
[]
[]
[null,null,null,"VENDOR INFORMATION"]
[null,null,null,"Company:",null,null,null,null,null,null,null,null,null,null,null,"Sales representative:",null,null,null,null,null,null,null,null,"Cell/Tel:"]
[]
[]
[]
[]
[null,null,null,"TO APPLY FOR INCENTIVES FROM YOUR LOCAL ELECTRIC UTILITY:"]
[null,null,null,null,"1)","Check with your local utility regarding the availability of incentives for energy-efficient compressed air systems."]
[null,null,null,null,null,"The utility will help you get in touch with the people who handle administration of incentives."]
[null,null,null,null,"2)","Enter the information requested above about participant, project, vendor, baseline compressor, proposed"]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions."]
[null,null,null,null,"3)","Send this Excel file as an email attachment to the incentive administrator.  Include a copy of the proposal"]
[null,null,null,null,null,"or quotation for the new compressor.  "]
[null,null,null,null,"4)","The utility's incentive administrator will review the calculator's inputs and outputs, call with questions,"]
[null,null,null,null,null,"and request any additional documentation that may be necessary.  Once the technical aspects of the"]
[null,null,null,null,null,"proposed project have been approved and the estimated incentive amount has been confirmed, if"]
[null,null,null,null,null,"Participant wishes to move ahead with the project, the incentive administrator will secure funding"]
[null,null,null,null,null,"approval from the utility."]
[null,null,null,null,"5)","Once the funding agreement is in place, equipment may be ordered and installed.  Please note that"]
[null,null,null,null,null,"a utility will not offer funding for projects in which equipment has been ordered prior to the utility's"]
[null,null,null,null,null,"(and in some cases, BPA's) approval of funding."]
[null,null,null,null,"6)","When installation is complete, notify the utility's incentive administrator.  The administrator will"]
[null,null,null,null,null,"request copies of invoices, ask Participant to sign a completion certification form, and may inspect"]
[null,null,null,null,null,"the installation.  If conditions are significantly different from those represented in the analysis, the"]
[null,null,null,null,null,"amount of the incentive may be affected.  Incentive checks are typically mailed 4 to 6 weeks after"]
[null,null,null,null,null,"receipt of the completion form and invoices."]
[]
[null,null,null,"Please be advised that energy savings and costs represented herein are entirely dependent upon inputs provided by the user.  The calculation methods, while believed to be reasonably accurate, are estimates; actual results may vary.  Responsibility for all representations herein, input information as well as calculated output values, rests solely with the user.  Nothing in this electronic file or print document is to be construed as a guarantee of savings or performance or as an offer of funding.                                                                                                                                                                            "]
[null,{"$f":"\" Cascade Energy, Inc. © 2007 - \"& TEXT(Tool_Revision_Date,\"mmmm-dd-yyyy\")","v":" Cascade Energy, Inc. © 2007 - November-07-2023"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ToolName&\"   v\"&ToolVersion & \"  \"","v":"BPA Small Compressed Air Calculator   v5.1  "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TO APPLY FOR INCENTIVES FROM ENERGY TRUST OF OREGON:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for Energy Trust Projects"]
[null,null,null,null,"1)","Enter the information requested above about participant, project, vendor, baseline compressor, proposed"]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,"2)","Send this Excel file as an email attachment to smallindustrial@energytrust.org.  Include a copy of the proposal"]
[null,null,null,null,null,"or quotation for the new compressor."]
[null,null,null,null,"3)","Energy Trust will review inputs and outputs and call with any questions.  Upon approval, Energy Trust will then"]
[null,null,null,null,null,"provide an offer of funding for review and acceptance by Participant."]
[null,null,null,null,"4)","Participant completes the entries in the Energy Trust agreement, signs, and returns the agreement to Energy"]
[null,null,null,null,null,"Trust."]
[null,null,null,null,"5)","Order equipment and schedule the installation.  Please note that Energy Trust must approve funding"]
[null,null,null,null,null,"before equipment is ordered."]
[null,null,null,null,"6)","When installation is complete, notify Energy Trust.  Energy Trust will request copies of invoices, ask you to "]
[null,null,null,null,null,"sign a completion certification form, and may inspect the installation.  If conditions are significantly different"]
[null,null,null,null,null,"from those represented in the analysis, the amount of the incentive may be affected.  Incentive checks are "]
[null,null,null,null,null,"mailed 3 to 6 weeks after receipt of the completion form and invoices."]
[]
[]
[]
[]
[]
[null,null,null,"TO APPLY FOR INCENTIVES FROM YOUR LOCAL ELECTRIC 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,"for Oregon, non-Energy Trust projects"]
[null,null,null,null,"1)","Check with your local utility regarding the availability of incentives for energy-efficient compressed air systems."]
[null,null,null,null,null,"The utility will help you get in touch with the people who handle administration of incentives."]
[null,null,null,null,"2)","Enter the information requested above about participant, project, vendor, baseline compressor, proposed"]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions."]
[null,null,null,null,"3)","Send this Excel file as an email attachment to the incentive administrator.  Include a copy of the proposal"]
[null,null,null,null,null,"or quotation for the new compressor."]
[null,null,null,null,"4)","The utility's incentive administrator will review the calculator's inputs and outputs, call with questions,"]
[null,null,null,null,null,"and request any additional documentation that may be needed.  Once the technical aspects of the proposed"]
[null,null,null,null,null,"project have been approved and the estimated incentive amount has been confirmed, if Participant wishes"]
[null,null,null,null,null,"to move ahead with the project, the incentive administrator will secure funding approval from the utility."]
[null,null,null,null,"5)","Once the funding agreement is in place, equipment may be ordered and installed.  Please note that"]
[null,null,null,null,null,"a utility will not offer funding for projects in which equipment has been ordered prior to the utility's"]
[null,null,null,null,null,"(and in some cases, BPA's) approval of funding.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reason for project:"]
[null,null,null,null,"6)","When installation is complete, notify the utility's incentive administrator.  The administrator will",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"IF(AR137,10,1)","v":10},"Replace working compressor"]
[null,null,null,null,null,"request copies of invoices, ask Participant to sign a completion certification form, and may inspect",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"IF(AR138,10,2)","v":10},"End of life compressor replacement"]
[null,null,null,null,null,"the installation.  If conditions are significantly different from those represented in the analysis, the",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"IF(AR139,10,3)","v":10},"Add capacity to existing system"]
[null,null,null,null,null,"amount of the incentive may be affected.  Incentive checks are typically mailed 4 to 6 weeks after ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AR140,10,4)","v":4},"New compressor in new facility"]
[null,null,null,null,null,"receipt of the completion form and invoices.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(NOT(AR137),NOT(AR138),NOT(AR139),NOT(AR140)),10,5)","v":5},"unknown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(10,AS137:AT141,2,FALSE)","v":"Replace working compressor"}]
[null,null,null,"TO APPLY FOR INCENTIVES FROM YOUR LOCAL ELECTRIC 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,"for non-Oregon projects"]
[null,null,null,null,"1)","Check with your local utility regarding the availability of incentives for energy-efficient compressed air systems.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is \"Other Utility\"?",null,false]
[null,null,null,null,null,"The utility will help you get in touch with the people who handle administration of incentives.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is BPA Project?",null,true]
[null,null,null,null,"2)","Enter the information requested above about participant, project, vendor, baseline compressor, proposed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ETO Biz Type",null,""]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions."]
[null,null,null,null,"3)","Send this Excel file as an email attachment to the incentive administrator.  Include a copy of the proposal"]
[null,null,null,null,null,"or quotation for the new compressor.  "]
[null,null,null,null,"4)","The utility's incentive administrator will review the calculator's inputs and outputs, call with questions,"]
[null,null,null,null,null,"and request any additional documentation that may be necessary.  Once the technical aspects of the"]
[null,null,null,null,null,"proposed project have been approved and the estimated incentive amount has been confirmed, if"]
[null,null,null,null,null,"Participant wishes to move ahead with the project, the incentive administrator will secure funding"]
[null,null,null,null,null,"approval from the utility."]
[null,null,null,null,"5)","Once the funding agreement is in place, equipment may be ordered and installed.  Please note that"]
[null,null,null,null,null,"a utility will not offer funding for projects in which equipment has been ordered prior to the utility's"]
[null,null,null,null,null,"(and in some cases, BPA's) approval of funding."]
[null,null,null,null,"6)","When installation is complete, notify the utility's incentive administrator.  The administrator will"]
[null,null,null,null,null,"request copies of invoices, ask Participant to sign a completion certification form, and may inspect"]
[null,null,null,null,null,"the installation.  If conditions are significantly different from those represented in the analysis, the"]
[null,null,null,null,null,"amount of the incentive may be affected.  Incentive checks are typically mailed 4 to 6 weeks after"]
[null,null,null,null,null,"receipt of the completion form and invoices."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLANK CELLS IN THE NEXT 19 LINES FOR CLEARING INSTRUCTIONS."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TO APPLY FOR INCENTIVES FROM ROCKY MOUNTAIN POWER:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for Rocky Mountain Power projects"]
[null,null,null,null,"1)","Check with Rocky Mountain Power to get in touch with the people who handle the administration"]
[null,null,null,null,null,"of incentives for compressed air systems at www.rockymountainpower.net/wattsmart or 801-642-4472."]
[null,null,null,null,"2)","Enter the information requested above about participant, project, vendor, baseline compressor, proposed"]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions."]
[null,null,null,null,"3)","Send this Excel file as an email attachment to the incentive administrator.  Include a copy of the proposal"]
[null,null,null,null,null,"or quotation for the new compressor.  "]
[null,null,null,null,"4)","The incentive administrator will review the calculator's inputs and outputs, call with questions,"]
[null,null,null,null,null,"and request any additional documentation that may be necessary to establish the incentive estimate.  "]
[null,null,null,null,null,"While this step is not required in order to receive an incentive, it is recommended, because it provides an"]
[null,null,null,null,null,"opportunity for the incentive administrator to concur with the assumptions supporting the savings estimate"]
[null,null,null,null,null,"upon which the incentive will be based.  "]
[null,null,null,null,"5)","Order and install the equipment."]
[null,null,null,null,"6)","Complete the incentive application/agreement, which can be downloaded from the website given above."]
[null,null,null,null,null,"Send the completed application with a copy of dated invoices or receipts substantiating the project cost"]
[null,null,null,null,null,"to the address given on the application.  Please allow six weeks for your incentive check to arrive."]
[null,null,null,null,"7)","Please note that incentive qualifications and amounts are subject to change and termination at any time."]
[null,null,null,null,null,"Rocky Mountain Power reserves the right to conduct inspections to verify information provided in the application"]
[null,null,null,null,null,"and to inspect equipment after payment of incentives.  Inspections may  include a telephone survey,"]
[null,null,null,null,null,"site visit, and/or the installation of temporary monitoring equipment at any time up to 36 months after installation."]
[]
[null,null,null,"TO APPLY FOR INCENTIVES FROM PACIFIC POWER:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for Pacific Power projects"]
[null,null,null,null,"1)","Check with Pacific Power to get in touch with the people who handle the administration"]
[null,null,null,null,null,"of incentives for compressed air systems.  See http://www.pacificpower.net/wattsmart."]
[null,null,null,null,"2)","Enter the information requested above about participant, project, vendor, baseline compressor, proposed"]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions."]
[null,null,null,null,"3)","Send this Excel file as an email attachment to the incentive administrator.  Include a copy of the proposal"]
[null,null,null,null,null,"or quotation for the new compressor.  "]
[null,null,null,null,"4)","The incentive administrator will review the calculator's inputs and outputs, call with questions,"]
[null,null,null,null,null,"and request any additional documentation that may be necessary to establish the energy savings estimate.  "]
[null,null,null,null,null,"While this step is not required in order to receive an incentive, it is recommended because it provides an"]
[null,null,null,null,null,"opportunity for the incentive administrator to concur with the assumptions supporting the savings estimate upon"]
[null,null,null,null,null,"which the incentive will be based.  "]
[null,null,null,null,"5)","Order and install the equipment."]
[null,null,null,null,"6)","Complete the incentive application/agreement, which can be downloaded from the website given above."]
[null,null,null,null,null,"Send the completed application with a copy of dated invoices or receipts substantiating the project cost"]
[null,null,null,null,null,"to the address given on the application.  Please allow six weeks for your incentive check to arrive."]
[null,null,null,null,"7)","Please note that incentive qualifications and amounts are subject to change and termination at any time."]
[null,null,null,null,null,"Pacific Power reserves the right to conduct inspections to verify information provided in the application"]
[null,null,null,null,null,"and to inspect equipment after payment of incentives.  Inspections may  include a telephone survey,"]
[null,null,null,null,null,"site visit, and/or the installation of temporary monitoring equipment at any time up to 36 months after installation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculator Type List","Sector List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retrofit","Industrial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Construction","Commercial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Remodel","Agricultural"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,5]

{"sheet":"Savings Calculations","index":1,"n_rows":141,"n_cols":106,"rows_kept":141,"cut":false,"hidden":false,"merged":[[70,4,70,5],[70,7,70,9],[75,21,75,23],[75,15,75,20],[74,7,74,9],[72,7,72,9],[73,7,73,9],[12,9,12,12],[17,9,17,11],[18,9,18,11],[19,9,19,11],[4,16,6,25],[12,15,12,16],[68,21,68,23],[45,12,45,14],[43,12,43,14],[44,21,44,23],[20,9,20,11],[21,9,21,11],[40,21,40,23],[67,21,67,23],[66,21,66,23],[22,9,22,11],[41,12,41,14],[23,9,23,11],[24,9,24,11],[40,12,40,14],[44,12,44,14],[25,9,25,11],[26,9,26,11],[31,9,31,11],[41,21,41,23],[42,12,42,14],[42,21,42,23],[110,84,120,84],[90,101,90,102],[106,85,106,94],[90,99,90,100],[75,7,75,9],[77,7,77,9],[77,15,77,20],[76,7,76,9],[76,21,76,23],[76,15,76,20],[119,105,119,113],[116,104,116,105],[118,105,118,113],[107,95,107,96],[109,86,109,94],[70,24,70,26],[69,24,69,26],[73,21,73,23],[126,77,126,78],[114,77,114,78],[125,77,125,78],[70,21,70,23],[125,75,125,76],[69,21,69,23],[77,21,77,23],[113,75,113,76],[113,77,113,78],[72,21,72,23],[72,24,72,26],[73,24,73,26],[66,7,66,9],[66,4,66,5],[44,9,44,11],[43,9,43,11],[45,9,45,11],[69,7,69,9],[45,4,45,5],[40,4,40,5],[40,9,40,11],[42,4,42,5],[42,9,42,11],[69,4,69,5],[68,7,68,9],[41,4,41,5],[44,4,44,5],[41,9,41,11],[67,4,67,5],[67,7,67,9],[43,4,43,5],[46,4,46,5],[68,4,68,5],[40,24,40,25],[42,24,42,25],[46,24,46,25],[43,21,43,23],[43,24,43,25],[45,21,45,23],[44,24,44,25],[41,24,41,25],[45,24,45,25]]}
[]
[]
[null,null,"ESTIMATE OF ENERGY SAVINGS AND INCENTIVES"]
[]
[null,null,null,"Customer:",{"$f":"IF(ISBLANK(CompanyName),\"\",CompanyName&\" – \" &SiteCity&\", \"&SiteState)","v":" – , "}]
[null,null,null,"Vendor:",{"$f":"VendorCompany","v":""}]
[]
[null,null,"SELECTION OF OPTIONAL MEASURES"]
[null,null,"Select all that apply:"]
[]
[]
[null,null," INFORMATION ABOUT THE COMPRESSORS"]
[null,null,null,null,null,null,null,null,null,"Baseline Compressor",null,null,null,null,null,"Proposed Upgrade Compressor"]
[null,null,null,null,null,null,null,"Type of compressor:",null,null,null,1,null,null,null,null,1]
[null,null,null,null,null,null,null,"Type of part load control:",null,null,null,3,null,null,null,null,4]
[null,null,null,null,null,null,null,"If unloading control, unloaded sump pressure:",null,null,null,6,null,null,null,null,6]
[]
[null,null,null,null,null,null,null,"Compressor hp:",null,null,null,null," hp",null,null,null,"  hp"]
[null,null,null,null,null,null,null,"Rated flow:",null,null,null,null," acfm",null,null,null,"  acfm"]
[null,null,null,null,null,null,null,"Plant elevation:",null,null,null,null," ft"]
[null,null,null,null,null,null,null,"Corrected compressor flow (calculated):",null,{"$f":"CS79","v":0},null,null," scfm",null,null,{"$f":"CS80","v":0}," scfm"]
[null,null,null,null,null,null,null,"If known, compressor shaft bhp:",null,null,null,null," bhp",null,null,null,"  bhp"]
[null,null,null,null,null,null,null,"Performance check (calculated):",null,{"$f":"IFERROR(IF(ISTEXT(CF103),\"bhp error\", J19/CF103),\"\")","v":""},null,null," acfm/kW",null,null,{"$f":"IFERROR(IF(ISTEXT(CF104),\"bhp error\",P19/CF104),\"\")","v":""},"  acfm/kW"]
[null,null,null,null,null,null,null,"Pressure at rated flow:",null,null,null,null," psig",null,null,null,"  psig"]
[null,null,null,null,null,null,null,"Receiver volume:",null,null,null,null,null,null,null,null,"  gallons"]
[null,null,null,null,null,null,null,{"$f":"\"Equipment cost\" & IF(OR(ShowDryer,InstallFanVFD,FlowReductionEEM,ShowDesiccantDryer),\" (including optional measure costs)\",\"\") &\":\"","v":"Equipment cost:"},null,{"$f":"-SUMIF('Explanation of Inputs'!AC52:AE72,\"<0\")","v":0},null,null,null,null,null,{"$f":"SUMIF('Explanation of Inputs'!AC52:AE72,\">0\")","v":0},null,null,null,null,"*Enter costs on Explanation of Inputs Tab"]
[null,null,null,null,null,null,null,{"$f":"\"Installation cost, shipping, etc.\"","v":"Installation cost, shipping, etc."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Estimated annual reduction (increase) in operating or maintenance cost:",null,null,null,"  $/yr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Estimated annual value of project's non-energy benefits:",null,null,null,"  $/yr"]
[]
[null,null,null,null,null,null,null,"Cooling fan motor hp:",null,2,null,null," hp",null,null,2,"  hp"]
[]
[null,null," INFORMATION ABOUT THE SYSTEM AND ITS OPERATION"]
[]
[null,null,null,null,null,null,"Current average operating pressure:  ",null,null," psig"]
[null,null,null,null,null,null,"Average operating pressure after upgrade:  ",null,null," psig"]
[null,null,null,null,null,null,"Annual Hours of Operation:  ",null,null," hours/yr",null,null,null,null,null,null,null,"                      Airflow reduction in scfm"]
[]
[null,null,"Profile of Baseline Compressed Air Demand",null,null,null,null,null,null,"Baseline Energy Use",null,null,null,null,null,null,null,null,null,null,"Upgrade Energy Use"]
[null,null,"% time","% flow","hrs/yr",null,"scfm",null,null,"% Load",null,null,"kW",null,null,"kWh/yr",null,"Δ scfm","% Load after user flow reduction","dryer Δ scfm","% Load","kW",null,null,"kWh/yr"]
[null,null,null,null,{"$f":"C42*$H$38","v":0},null,{"$f":"D42*$CS$79","v":0},null,null,{"$f":"G42/$CS$79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$CF$103*(IF(J42<0.5,$CD$109+$CD$110*J42,$CE$109+$CE$110*J42)+IF(OR($L$15=3,$L$15=5),VLOOKUP($J$25/$J$19,$CH$111:$CQ$121,HLOOKUP(J42,$CH$108:$CQ$109,2,TRUE),TRUE),0))*((-$J$24+$H$36)/250+1)","v":{"$error":"#N/A"}},null,null,{"$f":"E42*M42","v":{"$error":"#N/A"}},null,null,{"$f":"(G42-R42)/$CS$80","v":{"$error":"#DIV/0!"}},{"$f":"IF(ShowDesiccantDryer,'Desiccant Dryer'!I59,0)","v":0},{"$f":"MAX(0,(G42-R42-T42)/$CS$80)","v":{"$error":"#DIV/0!"}},{"$f":"$CF$104*(IF(U42<0.5,$CD$120+$CD$121*U42,$CE$120+$CE$121*U42)+IF(OR($Q$15=3,$Q$15=5),VLOOKUP($P$25/$P$19,$CH$111:$CQ$121,HLOOKUP(U42,$CH$108:$CQ$109,2,TRUE),TRUE),0))*((-$P$24+$H$37)/250+1)","v":{"$error":"#N/A"}},null,null,{"$f":"E42*V42","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C43*$H$38","v":0},null,{"$f":"D43*$CS$79","v":0},null,null,{"$f":"G43/$CS$79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$CF$103*(IF(J43<0.5,$CD$109+$CD$110*J43,$CE$109+$CE$110*J43)+IF(OR($L$15=3,$L$15=5),VLOOKUP($J$25/$J$19,$CH$111:$CQ$121,HLOOKUP(J43,$CH$108:$CQ$109,2,TRUE),TRUE),0))*((-$J$24+$H$36)/250+1)","v":{"$error":"#N/A"}},null,null,{"$f":"E43*M43","v":{"$error":"#N/A"}},null,null,{"$f":"(G43-R43)/$CS$80","v":{"$error":"#DIV/0!"}},{"$f":"IF(ShowDesiccantDryer,'Desiccant Dryer'!I60,0)","v":0},{"$f":"MAX(0,(G43-R43-T43)/$CS$80)","v":{"$error":"#DIV/0!"}},{"$f":"$CF$104*(IF(U43<0.5,$CD$120+$CD$121*U43,$CE$120+$CE$121*U43)+IF(OR($Q$15=3,$Q$15=5),VLOOKUP($P$25/$P$19,$CH$111:$CQ$121,HLOOKUP(U43,$CH$108:$CQ$109,2,TRUE),TRUE),0))*((-$P$24+$H$37)/250+1)","v":{"$error":"#N/A"}},null,null,{"$f":"E43*V43","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C44*$H$38","v":0},null,{"$f":"D44*$CS$79","v":0},null,null,{"$f":"G44/$CS$79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$CF$103*(IF(J44<0.5,$CD$109+$CD$110*J44,$CE$109+$CE$110*J44)+IF(OR($L$15=3,$L$15=5),VLOOKUP($J$25/$J$19,$CH$111:$CQ$121,HLOOKUP(J44,$CH$108:$CQ$109,2,TRUE),TRUE),0))*((-$J$24+$H$36)/250+1)","v":{"$error":"#N/A"}},null,null,{"$f":"E44*M44","v":{"$error":"#N/A"}},null,null,{"$error":"#DIV/0!"},{"$f":"IF(ShowDesiccantDryer,'Desiccant Dryer'!I61,0)","v":0},{"$f":"MAX(0,(G44-R44-T44)/$CS$80)","v":{"$error":"#DIV/0!"}},{"$f":"$CF$104*(IF(U44<0.5,$CD$120+$CD$121*U44,$CE$120+$CE$121*U44)+IF(OR($Q$15=3,$Q$15=5),VLOOKUP($P$25/$P$19,$CH$111:$CQ$121,HLOOKUP(U44,$CH$108:$CQ$109,2,TRUE),TRUE),0))*((-$P$24+$H$37)/250+1)","v":{"$error":"#N/A"}},null,null,{"$f":"E44*V44","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C45*$H$38","v":0},null,{"$f":"D45*$CS$79","v":0},null,null,{"$f":"G45/$CS$79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$CF$103*(IF(J45<0.5,$CD$109+$CD$110*J45,$CE$109+$CE$110*J45)+IF(OR($L$15=3,$L$15=5),VLOOKUP($J$25/$J$19,$CH$111:$CQ$121,HLOOKUP(J45,$CH$108:$CQ$109,2,TRUE),TRUE),0))*((-$J$24+$H$36)/250+1)","v":{"$error":"#N/A"}},null,null,{"$f":"E45*M45","v":{"$error":"#N/A"}},null,null,{"$error":"#DIV/0!"},{"$f":"IF(ShowDesiccantDryer,'Desiccant Dryer'!I62,0)","v":0},{"$f":"MAX(0,(G45-R45-T45)/$CS$80)","v":{"$error":"#DIV/0!"}},{"$f":"$CF$104*(IF(U45<0.5,$CD$120+$CD$121*U45,$CE$120+$CE$121*U45)+IF(OR($Q$15=3,$Q$15=5),VLOOKUP($P$25/$P$19,$CH$111:$CQ$121,HLOOKUP(U45,$CH$108:$CQ$109,2,TRUE),TRUE),0))*((-$P$24+$H$37)/250+1)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($CF$74,V45*M51,E45*V45)","v":{"$error":"#N/A"}}]
[null,null,null,"timed out",{"$f":"C46*$H$38","v":0},null,0,null,null,0,null,null,0,null,null,{"$f":"E46*M46","v":0},null,null,0,null,0,0,null,null,{"$f":"IF($CF$74,V46*M52,E46*V46)","v":0}]
[null,null,{"$f":"SUM(C42:C46)","v":0},null,{"$f":"SUM(E42:E46)","v":0},null,null,null,null,null,null,null,"Total:",null,null,{"$f":"ROUND(SUM(P42:P46),0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Total:",null,{"$f":"ROUND(SUM(Y42:Y46),0)","v":{"$error":"#N/A"}}]
[]
[null,null,{"$f":"\"The baseline operating profile shows the compressor running unloaded \"&TEXT($C$45,\"0%\")&\" of the time.\"","v":"The baseline operating profile shows the compressor running unloaded 0% of the time."}]
[null,null,"If the new compressor has time-out controls, estimate the updated run-times for the upgrade compressor below."]
[null,null,null,0.05,"Running Unloaded (0% flow)",null,null,null,null,null,null,null,{"$f":"D51*$H$38","v":0},"Upgrade Annual Hours - Unloaded (0% flow)"]
[null,null,null,0.05,"Cycled Off (timed out)",null,null,null,null,null,null,null,{"$f":"D52*$H$38","v":0},"Upgrade Annual Hours -Cycled Off (timed out)"]
[null,null,null,{"$f":"SUM(D51:D52)","v":0.1},{"$f":"IF(D53=C45,\"Total\",\"The total must be equal to the total baseline compressor unloaded time of \"&TEXT(C45,\"0%\")&\".\")","v":"The total must be equal to the total baseline compressor unloaded time of 0%."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"SUMMARY OF RESULTS\"","v":"SUMMARY OF RESULTS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elevation, feet",null,null,null,{"$f":"J20","v":0}]
[null,null,null,null,"Comp.",null,"Dryer","Cooling Fan",null,null,null,null,null,null,null,null,null,null,null,null,"Total project cost:  ",{"$f":"UpgradeEquipmentCost+UpgradeLaborCost","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atmospheric Pressure, psia",null,null,null,{"$f":"local_Patm(CL66)","v":14.696999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incentive Calculation"]
[null,null,null,"Baseline energy use:",{"$f":"P47","v":{"$error":"#N/A"}},null,{"$f":"IF(ShowDryer,'Dryer Inputs and Calculations'!F59,IF(ShowDesiccantDryer,'Desiccant Dryer'!F67,\"N/A\"))","v":"N/A"},{"$f":"IF(InstallFanVFD,'Cooling Fan VFD'!I12,\"N/A\")","v":"N/A"},null,null," kWh/yr",null,null,null,null,null,null,null,null,null,"Baseline project cost:  ",{"$f":"BaselineEquipmentCost+BaselineLaborCost","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAGI Std Atmospheric Pressure, psia",null,null,null,14.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incentive Rate ($/kWh)",{"$f":"IncentiveRateCell","v":0.33}]
[null,null,null,"Upgrade energy use:",{"$f":"Y47","v":{"$error":"#N/A"}},null,{"$f":"IF(ShowDryer,'Dryer Inputs and Calculations'!F60,IF(ShowDesiccantDryer,'Desiccant Dryer'!F68,\"N/A\"))","v":"N/A"},{"$f":"IF(InstallFanVFD,'Cooling Fan VFD'!G28,\"N/A\")","v":"N/A"},null,null," kWh/yr",null,null,null,null,null,null,null,null,null,"Eligible project cost:  ",{"$f":"EstUtilEligibleCost","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"scfm per acfm",null,null,null,{"$f":"CL67/CL68","v":1.0135862068965518},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incentive Cost Cap (% of cost)",{"$f":"IncentiveCapCell","v":0.7}]
[null,null,null,"Site energy savings:",{"$f":"E68-E69","v":{"$error":"#N/A"}},null,{"$f":"IF(ISNUMBER(G68-G69),G68-G69,\"N/A\")","v":"N/A"},{"$f":"IF(ISNUMBER(H68-H69),H68-H69,\"N/A\")","v":"N/A"},null,null," kWh/yr",null,null,null,null,null,null,null,null,null,"Estimated Utility Incentive:",{"$f":"IF(ISERROR(DB76),\"\",ROUND(DB76,2))","v":""},null,null,{"$f":"IF(V70=\"\",\"\",IF(V70=0,\"(ineligible)\",\" (\"&TEXT(V70/V69,\"##%\")&\" of cost)\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site Savings (kWh)",{"$f":"'Savings Calculations'!H75","v":{"$error":"#N/A"}}]
[null,null,null,"Busbar energy savings:",{"$f":"E70*BPA_Busbar_Factor","v":{"$error":"#N/A"}},null,{"$f":"IF(ISNUMBER(G70*BPA_Busbar_Factor),G70*BPA_Busbar_Factor,\"N/A\")","v":"N/A"},{"$f":"IF(ISNUMBER(H70*BPA_Busbar_Factor),H70*BPA_Busbar_Factor,\"N/A\")","v":"N/A"},null,null," kWh/yr",null,null,null,null,null,null,null,null,null,"Net cost after incentives:",{"$f":"IF(ISERROR(V69-V70),\"\",V69-V70)","v":""},null,null,{"$f":"IF(V71=\"\",\"\",IF(V71=\"0\",\"(ineligible)\",\" (\"&TEXT(V71/V69,\"##%\")&\" of cost)\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eligible Project Cost",{"$f":"V69","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Incentive is based on site savings, per the utility's request",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Busbar Factor",{"$f":"BPA_Busbar_Factor","v":1.1118300000000001}]
[null,null,null,null,null,null,"Total Baseline Energy Use:",{"$f":"SUM(E68:J68)","v":{"$error":"#N/A"}},null,null," kWh/yr",null,null,null,null,null,null,null,null,null,"Simple Payback",{"$f":"IF(ISERROR(V71/(H78+P29+P30)),\"\",(V71/(H78+P29+P30)))","v":""},null,null," years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Double dryer error?: ",{"$f":"AND(ShowDesiccantDryer,ShowDryer)","v":false},null,"Updated Run-Times for Cycled of Compressor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Busbar Savings",{"$f":"DB70*DB72","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Total Upgraded Energy Use:",{"$f":"SUM(E69:J69)","v":{"$error":"#N/A"}},null,null," kWh/yr",null,null,null,null,null,null,null,null,null,"NPV over 10 years",{"$f":"IF(ISERROR(PV(DiscountRate,10,-ElectricityCostSavings-NonEnergyBenefits-OandMReduction)-V69+V70),\"\",PV(DiscountRate,10,-ElectricityCostSavings-NonEnergyBenefits-OandMReduction)-V69+V70)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compressor Running Unloaded:",{"$f":"IF(ISBLANK(D45),FALSE,D45)=0","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incentive based on savings",{"$f":"DB70*DB68","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Total site savings:",{"$f":"SUM(E70:J70)","v":{"$error":"#N/A"}},null,null," kWh/yr",null,null,null,null,"For BEETS Input:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Desiccant dryer improvements?",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incentive Based on cost cap",{"$f":"DB69*DB71","v":0}]
[null,null,null,null,null,null,"% Energy savings:",{"$f":"SUM(E70:H70)/SUM(E68:J68)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Site Savings",null,null,null,null,null,{"$f":"IFERROR(H75,\"\")","v":""},null,null,"kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Install cooling fan VFD?",false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Utility Incentive",{"$f":"MIN(DB74:DB75)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Energy rate:",{"$f":"ElectricRate","v":5.7099999999999998E-2},null,null," per kWh",null,null,null,null,"Project Cost",null,null,null,null,null,{"$f":"IF(V69=0,\"\",V69)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow reduction? ",false,null,"Is project a BPA ESI project?",null,null,null,true,"IsBPAProject"]
[null,null,null,null,null,null,"Avoided energy cost:",{"$f":"ElectricityCostSavings","v":{"$error":"#N/A"}},null,null," per year",null,null,null,null,"Incentive Amount",null,null,null,null,null,{"$f":"V70","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dryer add?",null,null,false]
[null,{"$f":"'Customer Information'!B62","v":" Cascade Energy, Inc. © 2007 - November-07-2023"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ToolName&\" v\"&ToolVersion & \"  \"","v":"BPA Small Compressed Air Calculator v5.1  "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baseline machine 100% flow corrected for difference between rated and operating pressure and site elevation:",{"$f":"J19*(1+0.00075*(J24-H36))*CL69","v":0},"scfm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upgrade machine 100% flow corrected for difference between rated and operating pressure and site elevation:",{"$f":"P19*(1+0.00075*(P24-H37))*CL69","v":0},"scfm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Corrected flow = Rated flow x (1 + 0.00075 (Rated Pressure - Operating Pressure)*Ratio(scfm/acfm)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corrected Baseline Power for discharge pressure",null,null,null,{"$f":"$CF$103*((-$J$24+$H$36)/250+1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corrected Upgraded Power for discharge pressure",null,null,null,{"$f":"$CF$104*((-$P$24+$H$37)/250+1)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List for combo box at E10 and G10"]
[null,null,"charting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motor efficiencies here",null,null,null,"Motor","Motor",null,1,"Screw"]
[null,null,"baseline points",null,null,null,"upgrade points",null,null,null,null,null,null,null,null,null,"Baseline kW",null,null,null,null,"Upgrade kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"are values for ",null,null,null,"hp","Eff",null,2,"Recip"]
[null,null,"% Cap","% Power",null,null,"% Cap","% Power",null,null,null,null,null,null,null,null,"Cap",null,null,null,"Power","Cap","Power",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEMA Premium motors,",null,null,null,5,0.89500000000000002,null,3,"Rotary Vane"]
[null,null,{"$f":"BZ116","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,{"$f":"BZ128","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,{"$f":"C88*$CS$79","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D88*$U$83","v":{"$error":"#DIV/0!"}},{"$f":"G88*$CS$80","v":{"$error":"#DIV/0!"}},{"$f":"H88*$U$84","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"which is the current",null,null,null,7.5,0.91700000000000004,null,4,"Other"]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEMA standard for the",null,null,null,10,0.91700000000000004,null,null,null,null,null,null,null,null,null,null,null,"List for combo box at E12 and G12"]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"energy efficient\" label.",null,null,null,15,0.92400000000000004,null,"List for combo box at E11 and G11"]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0.93,null,"Baseline",null,null,null,null,"below 50%",null,"above 50%",null,null,null,null,null,null,"Load/Unload",null,"Mod w/ Unloading"]
[null,null,0,{"$error":"#DIV/0!"},null,null,0,0.15,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0.93600000000000005,null,"#","Part Load Control Type",null,null,null,"x0","x1","x0","x1",1,"Not Applicable",null,1,null,0.3,0.7,0.3,{"$f":"(AVERAGE(0.84,CV92+0.5*CW92)-CX92)/0.5","v":0.88999999999999979}]
[null,null,0,{"$error":"#DIV/0!"},null,null,0,0.15,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0.93600000000000005,null,1,"Inlet Modulation",null,null,null,0.68,0.32,0.68,0.32,2,"0 psig",null,2,0,0.16,{"$f":"1-CV93","v":0.84},{"$f":"CV93","v":0.16},1.0999999999999999]
[null,null,0,{"$error":"#DIV/0!"},null,null,0,0.15,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.94099999999999995,null,2,"On/Off (recips)",null,null,null,0,1,0,1,3,"40 psig",null,3,40,{"$f":"(0.45-0.16)/60*CU94+0.16","v":0.35333333333333339},{"$f":"1-CV94","v":0.64666666666666661},{"$f":"CV94","v":0.35333333333333339},0.80999999999999983]
[null,null,"baseline line",null,null,null,"upgrade line",null,null,null,null,null,null,null,null,null,"Baseline line",null,null,null,null,"Upgrade Line",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.94499999999999995,null,3,"Load/Unload",null,null,null,{"$f":"VLOOKUP(L16,$CT$92:$CY$97,3,TRUE)","v":0.3},{"$f":"VLOOKUP(L16,$CT$92:$CY$97,4,TRUE)","v":0.7},{"$f":"VLOOKUP(L16,$CT$92:$CY$97,3,TRUE)","v":0.3},{"$f":"VLOOKUP(L16,$CT$92:$CY$97,4,TRUE)","v":0.7},4,"50 psig",null,4,50,{"$f":"(0.45-0.16)/60*CU95+0.16","v":0.40166666666666667},{"$f":"1-CV95","v":0.59833333333333338},{"$f":"CV95","v":0.40166666666666667},0.73750000000000016]
[null,null,{"$f":"BX116","v":1},{"$error":"#DIV/0!"},null,null,{"$f":"BX128","v":1},1.03,null,null,null,null,null,null,null,null,{"$f":"C96*$CS$79","v":0},null,null,null,{"$f":"D96*$U$83","v":{"$error":"#DIV/0!"}},{"$f":"G96*$CS$80","v":0},{"$f":"H96*$U$84","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.95,null,4,"VFD",null,null,null,0.15,0.73,0,1.03,5,"60 psig",null,5,60,{"$f":"(0.45-0.16)/60*CU96+0.16","v":0.45000000000000007},{"$f":"1-CV96","v":0.54999999999999993},{"$f":"CV96","v":0.45000000000000007},0.66499999999999981]
[null,null,0.75,{"$error":"#DIV/0!"},null,null,0.75,0.77249999999999996,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,0.95399999999999996,null,5,"Mod w/ Unloading",null,null,null,{"$f":"VLOOKUP(L16,$CT$92:$CY$97,5,TRUE)","v":0.3},{"$f":"VLOOKUP(L16,$CT$92:$CY$97,6,TRUE)","v":0.88999999999999979},0.68,0.32,6,"unknown",null,6,null,0.3,0.7,0.3,0.88999999999999979]
[null,null,0.51,{"$error":"#DIV/0!"},null,null,0.51,0.52529999999999999,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,0.95399999999999996]
[null,null,0.5,{"$error":"#DIV/0!"},null,null,0.5,0.51500000000000001,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,0.95399999999999996,null,"Upgrade",null,null,null,null,"below 50%",null,"above 50%"]
[null,null,0.49,{"$error":"#DIV/0!"},null,null,0.49,0.50769999999999993,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#","Part Load Control Type",null,null,null,"x0","x1","x0","x1"]
[null,null,0.25,{"$error":"#DIV/0!"},null,null,0.25,0.33250000000000002,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default calculated baseline compressor kW at full load:",null,null,null,null,null,null,{"$f":"J18*0.746/VLOOKUP(J18,$CE$87:$CF$99,2,TRUE)*1.1","v":{"$error":"#N/A"}},null,1,"Inlet Modulation",null,null,null,0.68,0.32,0.68,0.32]
[null,null,0,{"$error":"#DIV/0!"},null,null,0,0.15,null,null,null,null,null,null,null,null,0,null,null,null,{"$error":"#DIV/0!"},0,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default calculated upgrade compressor kW at full load:",null,null,null,null,null,null,{"$f":"P18*0.746/VLOOKUP(P18,$CE$87:$CF$99,2,TRUE)*1.1","v":{"$error":"#N/A"}},null,2,"On/Off (recips)",null,null,null,0,1,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full load kW to use, either default",null,null,null,"baseline:",null,null,{"$f":"IF(ISBLANK(J22),CF101,IF(AND(J22>=0.9*J18,J22<=1.18*J18),J22*0.746/VLOOKUP(J18,$CE$87:$CF$99,2,TRUE),\"bhp entry is unrealistic\"))","v":{"$error":"#N/A"}},null,3,"Load/Unload",null,null,null,{"$f":"VLOOKUP(Q16,$CT$92:$CY$97,3,TRUE)","v":0.3},{"$f":"VLOOKUP(Q16,$CT$92:$CY$97,4,TRUE)","v":0.7},{"$f":"VLOOKUP(Q16,$CT$92:$CY$97,3,TRUE)","v":0.3},{"$f":"VLOOKUP(Q16,$CT$92:$CY$97,4,TRUE)","v":0.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"or based on bhp, if given:",null,null,null,"upgrade:",null,null,{"$f":"IF(ISBLANK(P22),CF102,IF(AND(P22>=0.9*P18,P22<=1.18*P18),P22*0.746/VLOOKUP(P18,$CE$87:$CF$99,2,TRUE),\"bhp entry is unrealistic\"))","v":{"$error":"#N/A"}},null,4,"VFD",null,null,null,0.15,0.73,0,1.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Mod w/ Unloading",null,null,null,{"$f":"VLOOKUP(Q16,$CT$92:$CY$97,5,TRUE)","v":0.3},{"$f":"VLOOKUP(Q16,$CT$92:$CY$97,6,TRUE)","v":0.88999999999999979},0.68,0.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lookup coefficients taken"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"from baseline table above",null,null,null,null,"% Capacity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<50%",">50%",null,null,0,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y-intercept",null,"x0",{"$f":"VLOOKUP($L$15,$CH$93:$CP$97,6,TRUE)","v":0.3},{"$f":"VLOOKUP($L$15,$CH$93:$CP$97,8,TRUE)","v":0.3},null,null,10,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"slope",null,"x1",{"$f":"VLOOKUP($L$15,$CH$93:$CP$97,7,TRUE)","v":0.7},{"$f":"VLOOKUP($L$15,$CH$93:$CP$97,9,TRUE)","v":0.7},null,null,null,"% Power Penalty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Receiver Ratio (gal/cfm)",0,0.1,0.11,0.11,9.5000000000000001E-2,0.08,6.5000000000000002E-2,4.4999999999999998E-2,0.02,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.1,0.11,0.11,9.5000000000000001E-2,0.08,6.5000000000000002E-2,4.4999999999999998E-2,0.02,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,6.5000000000000002E-2,7.2499999999999995E-2,7.4999999999999997E-2,6.7500000000000004E-2,5.7500000000000002E-2,4.7500000000000001E-2,3.5000000000000003E-2,1.4999999999999999E-2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(L15,CH93:CI97,2)","v":"Load/Unload"},null,"Operating",null,null,null,null,null,null,null,3,0.03,3.5000000000000003E-2,0.04,0.04,3.5000000000000003E-2,0.03,2.5000000000000001E-2,0.01,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cap","Power","Points",null,null,null,null,null,null,null,4,2.2499999999999999E-2,2.75E-2,0.03,0.03,2.75E-2,2.2499999999999999E-2,0.02,0.01,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"(IF(BX116<0.5,$CD$109+$CD$110*BX116,$CE$109+$CE$110*BX116)+IF(OR($L$15=3,$L$15=5),VLOOKUP($J$25/$J$19*IF($L$15=5,2,1),$CH$111:$CQ$121,HLOOKUP(BX116*IF($L$15=5,2,1),$CH$108:$CQ$109,2,TRUE),TRUE),0))","v":{"$error":"#DIV/0!"}},{"$f":"J42","v":{"$error":"#DIV/0!"}},{"$f":"(IF(BZ116<0.5,$CD$109+$CD$110*BZ116,$CE$109+$CE$110*BZ116)+IF(OR($L$15=3,$L$15=5),VLOOKUP($J$25/$J$19*IF($L$15=5,2,1),$CH$111:$CQ$121,HLOOKUP(BZ116*IF($L$15=5,2,1),$CH$108:$CQ$109,2,TRUE),TRUE),0))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,5,1.4999999999999999E-2,0.02,0.02,0.02,0.02,1.4999999999999999E-2,1.4999999999999999E-2,0.01,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,{"$error":"#DIV/0!"},{"$f":"J43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"lookup coefficients taken",null,null,null,null,6,1.4999999999999999E-2,0.02,0.02,0.02,0.02,1.4999999999999999E-2,1.4999999999999999E-2,0.01,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51,{"$error":"#DIV/0!"},{"$f":"J44","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"from upgrade table above",null,null,null,null,7,0.01,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,0.01,0.01,5.0000000000000001E-3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$error":"#DIV/0!"},{"$f":"J45","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,"<50%",">50%",null,null,8,0.01,0.01,0.01,0.01,0.01,0.01,0.01,5.0000000000000001E-3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49,{"$error":"#DIV/0!"},{"$f":"J46","v":0},{"$error":"#DIV/0!"},null,"x0",{"$f":"VLOOKUP($Q$15,$CH$101:$CP$105,6,TRUE)","v":0.15},{"$f":"VLOOKUP($Q$15,$CH$101:$CP$105,8,TRUE)","v":0},null,null,9,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,{"$error":"#DIV/0!"},{"$f":"L47","v":0},{"$error":"#DIV/0!"},null,"x1",{"$f":"VLOOKUP($Q$15,$CH$101:$CP$105,7,TRUE)","v":0.73},{"$f":"VLOOKUP($Q$15,$CH$101:$CP$105,9,TRUE)","v":1.03},null,null,10,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$f":"L54","v":0},{"$error":"#DIV/0!"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Q15,CH93:CI97,2)","v":"VFD"},null,"Operating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cap","Power","Points",null,null,null,null,null,null,null,"IndShift110",null,"1shft/5days",{"$f":"8*5*52","v":2080},0.51389815678859674,0.57271347457292288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"(IF(BX128<0.5,$CD$120+$CD$121*BX128,$CE$120+$CE$121*BX128)+IF(OR($Q$15=3,$Q$15=5),VLOOKUP($P$25/$P$19*IF($Q$15=5,2,1),$CH$111:$CQ$121,HLOOKUP(BX128*IF($Q$15=5,2,1),$CH$108:$CQ$109,2,TRUE),TRUE),0))","v":1.03},{"$f":"U42","v":{"$error":"#DIV/0!"}},{"$f":"(IF(BZ128<0.5,$CD$120+$CD$121*BZ128,$CE$120+$CE$121*BZ128)+IF(OR($Q$15=3,$Q$15=5),VLOOKUP($P$25/$P$19*IF($Q$15=5,2,1),$CH$111:$CQ$121,HLOOKUP(BZ128*IF($Q$15=5,2,1),$CH$108:$CQ$109,2,TRUE),TRUE),0))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"IndShift210",null,"2shft/5days",{"$f":"16*5*52","v":4160},0.49854018399431704,0.55735550177864313]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,0.77249999999999996,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,"IndShift310",null,"3shft/5days",{"$f":"24*5*52","v":6240},0.43906528706615056,0.49788060485047664]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51,0.52529999999999999,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,"FLAT-Elec10",null,"Constant",{"$f":"24*6*52","v":7488},0.41478197881029666,0.47359729659462274]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.51500000000000001,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,{"$f":"H38","v":0},{"$f":"VLOOKUP($H$38,$CK$127:$CM$130,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$38,$CK$127:$CM$130,3)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49,0.50769999999999993,0,0.15,null,null,null,null,null,null,null,null,null,null,{"$f":"CL131*H80/MIN(0.5*W80,0.15*H80)","v":{"$error":"#N/A"}},{"$f":"(CM131*H80+PV(0.03,10,-P30))/W80","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,0.33250000000000002,0,0.15,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CL132>1,\"Pass\",\"Fail\")","v":{"$error":"#N/A"}},{"$f":"IF(CM132>1,\"Pass\",\"Fail\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.15,{"$f":"U54","v":0},0.15]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compressor kW at any particular load level is calculated as full load kW times a % power factor, determined on the basis of control type and whether the part load level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"is in the lower half or the upper half of the capacity range, with a second order % power penalty added  - when unloading is involved - to the basic % power factor."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This adjusts for receiver capacity (gal per cfm of compressor capacity).  Finally, the result is multiplied by an adjustment factor for operating pressure setpoint,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"which compensates for the fact that the system operating pressure is often not the same as the rated pressure.  The adjustment is 0.4% increase (decrease) in power for each psi increase"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(decrease) in operating pressure, compared to rated pressure.  "]

{"sheet":"Dryer Inputs and Calculations","index":2,"n_rows":64,"n_cols":30,"rows_kept":64,"cut":false,"hidden":true,"merged":[[27,17,27,18],[31,5,31,6],[16,5,16,6],[16,7,16,10],[16,11,16,13],[20,5,20,6],[20,8,20,9],[63,13,63,14],[13,5,13,6],[13,8,13,9],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[33,2,34,5],[10,5,10,6],[10,8,10,9],[7,1,7,2],[8,5,8,7],[8,8,8,10],[9,4,9,6],[9,8,9,11]]}
[]
[]
[null,null,"ENERGY SAVINGS CALCULATOR FOR CYCLING REFRIGERATED AIR DRYERS"]
[null,null,null,"Customer:",{"$f":"IF(ISBLANK(CompanyName),\"\",CompanyName&\":  \" &SiteCity&\", \"&SiteState)","v":":  , "}]
[null,null,null,"Vendor:",{"$f":"VendorCompany","v":""}]
[]
[null,null," INFORMATION ABOUT THE AIR DRYERS"]
[]
[null,null,null,null,null,"    Baseline Dryer",null,null,"    Proposed Dryer"]
[null,null,"Type of air dryer:",null,"Air-cooled non-cycling",null,null,null,"Air-cooled cycling"]
[null,null,"Rated dryer capacity:",null,null,100,null,"scfm",100,null,"scfm"]
[]
[null,null,"Do you know the full load kW?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baseline Types",null,null,"upgrade types"]
[null,null,"If yes, enter full load kW",null,null,0.65,null,"kW",0.61,null,"kW",null,null,null,null,null,null,null,null,"Air-cooled non-cycling",null,null,"Air-cooled cycling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water-cooled non-cycling",null,null,"Water-cooled cycling"]
[null,null,null,null,"Dryer inlet air pressure:  ",{"$f":"'Savings Calculations'!H37","v":0},"psig"]
[null,null,null,null,"Compressor and dryer located:  ","indoors"]
[null,null,null,null,"Ambient air temp near compressor:  ",85,"°F",null,null,null,null,null,null,null,null,null,null,null,null,"indoors",null,null,"Location",null,null,null,"Season","Shift","Bin","DB °F"]
[null,null,null,null,"Estimated dryer inlet air temp:  ",{"$f":"IF(BaselineType=T14,InsideAirTemp+15,InsideAirTemp+25)+ IF(IndoorOutdoorSelection=\"outdoors\",T35,0)","v":100},"°F",{"$f":"IF(BaselineType=T14,\"(15 °F CDT from localized ambient)\",\"(25 °F CDT from localized ambient)\")","v":"(15 °F CDT from localized ambient)"},null,null,null,null,null,null,null,null,null,null,null,"outdoors",null,null,"ID - Boise",null,null,null,"winter",1,1,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC19-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID - Idaho Falls",null,null,null,"winter",2,2,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC20-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Corrected1 dryer capacity:  ",{"$f":"IF(ISNUMBER(T28),T28,\"\")","v":48.843193032758975},null,"scfm",{"$f":"IF(ISNUMBER(T29),T29,\"\")","v":48.843193032758975},null,"scfm",null,null,null,null,null,null,null,null,null,null,null,"ID - Lewiston",null,null,null,"winter",3,3,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC21-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,"Note 1:  Corrected capacity includes adjustment for ambient temperature as well as dryer inlet air temperature and pressure.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID - Malad City",null,null,null,"spring",1,4,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC22-1,6)","v":{"$error":"#N/A"}}]
[null,null," INFORMATION ABOUT THE AIR COMPRESSOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID - Pocatello",null,null,null,"spring",2,5,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC23-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID - Salmon",null,null,null,"spring",3,6,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC24-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Total compressor hp feeding dryer: ",{"$f":"'Savings Calculations'!P18","v":0},null,"hp",null,null,null,null,null,null,null,null,null,"Inlet air pressure correction:",null,{"$f":"F16^3*'Correction Factors'!L18+'Dryer Inputs and Calculations'!F16^2*'Correction Factors'!L17 +'Dryer Inputs and Calculations'!F16*inlet_p_intercept +inlet_p_slope","v":0.42193368380486151},null,null,"OR - Astoria",null,null,null,"summer",1,7,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC25-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Total rated flow: ",{"$f":"'Savings Calculations'!P19","v":0},null,"acfm",null,null,null,null,null,null,null,null,null,"Inlet air temp correction:",null,{"$f":"F19^3*'Correction Factors'!E18+'Dryer Inputs and Calculations'!F19^2*'Correction Factors'!E17+'Dryer Inputs and Calculations'!F19*'Correction Factors'!E16+'Correction Factors'!E15","v":1.0012493640469007},null,null,"OR - Baker City",null,null,null,"summer",2,8,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC26-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Site elevation above sea level: ",{"$f":"'Savings Calculations'!J20","v":0},null,"ft",null,null,null,null,null,null,null,null,null,"inside ambient corr.:",null,{"$f":"InsideAirTemp*ambient_slope+ambient_intercept","v":1.15615908661918},null,null,"OR - Bend",null,null,null,"summer",3,9,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC27-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Corrected flow: ",{"$f":"'Savings Calculations'!CS80","v":0},null,"scfm",null,null,null,null,null,null,null,null,null,"Corrected Baseline capacity:",null,{"$f":"BaselineRating*(T26*T39*T25)","v":48.843193032758975},null,null,"OR - Burns",null,null,null,"fall",1,10,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC28-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corrected Upgrade capacity",null,{"$f":"UpgradeRating*(T26*T39*T25)","v":48.843193032758975},null,null,"OR - Corvallis",null,null,null,"fall",2,11,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC29-1,6)","v":{"$error":"#N/A"}}]
[null,null," INFORMATION ABOUT THE SYSTEM AND ITS OPERATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Eugene",null,null,null,"fall",3,12,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocation,Weather!$A$1:$A$493,0)+AC30-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumption: facility operates year-round",null,null,null,null,"OR - Klamath Falls"]
[null,null,null,null,"Annual hours of operation: ",{"$f":"'Savings Calculations'!H38","v":0},null,"hours/yr",null,null,null,null,null,null,null,null,null,"number of shifts:",null,{"$f":"IF(F32>6000,3,IF(F32<3000,1,2))","v":1},null,null,"OR - Medford"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"average ambient temp",null,null,null,null,"OR - Pendleton"]
[null,null," Profile of Compressed Air Demand \nfor EEM Compressor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"during hours of operation:",null,{"$f":"IF(T32=3,AVERAGE(AD19:AD30),IF(T32=2,AVERAGE(AD19:AD20,AD22:AD23,AD25:AD26,AD28:AD29),AVERAGE(AD19,AD22,AD25,AD28)))","v":{"$error":"#N/A"}},"°F",null,"OR - Portland"]
[null,null,null,null,null,null,null,"Baseline Dryer Energy Use",null,null,null,"Upgrade Dryer Energy Use",null,null,null,null,null,"delta from ambient:",null,15,"°F",null,"OR - Roseburg"]
[null,null,"% time","% flow","hrs/yr","scfm",null,"% Load","kW","kWh/yr",null,"% Load","kW","kWh/yr",null,null,null,"ambient temp at dryer:",null,{"$f":"T35+T34","v":{"$error":"#N/A"}},"°F",null,"OR - The Dalles"]
[null,null,{"$f":"'Savings Calculations'!C42","v":0},{"$f":"'Savings Calculations'!U42","v":{"$error":"#DIV/0!"}},{"$f":"IF(C37=\"\",\"\",$F$32*C37)","v":0},{"$f":"D37*$F$28","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D37=\"\",\"\",F37/$F$21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(H37=\"\",\"\",MIN((H37*'Operating Power'!$Y$13+'Operating Power'!$Y$14)*BaselinekW,BaselinekW))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E37=\"\",\"\",I37*E37)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D37=\"\",\"\",F37/$I$21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(L37=\"\",\"\",MIN((L37*'Operating Power'!$Y$27+'Operating Power'!$Y$28)*UpgradekW,UpgradekW))","v":{"$error":"#DIV/0!"}},{"$f":"IF(M37=\"\",0,M37*E37)","v":{"$error":"#DIV/0!"}},null,null,null,"outside correction factor",null,{"$f":"T36*ambient_slope+ambient_intercept","v":{"$error":"#N/A"}},null,null,"UT - Delta"]
[null,null,{"$f":"'Savings Calculations'!C43","v":0},{"$f":"'Savings Calculations'!U43","v":{"$error":"#DIV/0!"}},{"$f":"IF(C38=\"\",\"\",$F$32*C38)","v":0},{"$f":"D38*$F$28-FlowReductionEEM*'Savings Calculations'!$R43","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D38=\"\",\"\",F38/$F$21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(H38=\"\",\"\",MIN((H38*'Operating Power'!$Y$13+'Operating Power'!$Y$14)*BaselinekW,BaselinekW))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E38=\"\",\"\",I38*E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D38=\"\",\"\",F38/$I$21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(L38=\"\",\"\",MIN((L38*'Operating Power'!$Y$27+'Operating Power'!$Y$28)*UpgradekW,UpgradekW))","v":{"$error":"#DIV/0!"}},{"$f":"IF(M38=\"\",0,M38*E38)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"UT - Hanksville"]
[null,null,{"$f":"'Savings Calculations'!C44","v":0},{"$f":"'Savings Calculations'!U44","v":{"$error":"#DIV/0!"}},{"$f":"IF(C39=\"\",\"\",$F$32*C39)","v":0},{"$f":"D39*$F$28-FlowReductionEEM*'Savings Calculations'!$R44","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D39=\"\",\"\",F39/$F$21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(H39=\"\",\"\",MIN((H39*'Operating Power'!$Y$13+'Operating Power'!$Y$14)*BaselinekW,BaselinekW))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E39=\"\",\"\",I39*E39)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D39=\"\",\"\",F39/$I$21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(L39=\"\",\"\",MIN((L39*'Operating Power'!$Y$27+'Operating Power'!$Y$28)*UpgradekW,UpgradekW))","v":{"$error":"#DIV/0!"}},{"$f":"IF(M39=\"\",0,M39*E39)","v":{"$error":"#DIV/0!"}},null,null,null,"actual ambient correction factor:",null,{"$f":"IF(IndoorOutdoorSelection=\"indoors\",T27,T37)","v":1.15615908661918},null,null,"UT - Moab"]
[null,null,{"$f":"'Savings Calculations'!C45","v":0},{"$f":"'Savings Calculations'!U45","v":{"$error":"#DIV/0!"}},{"$f":"IF(C40=\"\",\"\",$F$32*C40)","v":0},{"$f":"D40*$F$28-FlowReductionEEM*'Savings Calculations'!$R45","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D40=\"\",\"\",F40/$F$21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(H40=\"\",\"\",MIN((H40*'Operating Power'!$Y$13+'Operating Power'!$Y$14)*BaselinekW,BaselinekW))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E40=\"\",\"\",I40*E40)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D40=\"\",\"\",F40/$I$21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(L40=\"\",\"\",MIN((L40*'Operating Power'!$Y$27+'Operating Power'!$Y$28)*UpgradekW,UpgradekW))","v":{"$error":"#DIV/0!"}},{"$f":"IF(M40=\"\",0,M40*E40)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"UT - Ogden"]
[null,null,{"$f":"SUM(C37:C40)","v":0},null,{"$f":"SUM(E37:E40)","v":0},null,null,null,"Total:",{"$f":"ROUND(SUM(J37:J40),0)","v":{"$error":"#DIV/0!"}},null,null,"Total:",{"$f":"ROUND(SUM(N37:N40),0)","v":{"$error":"#DIV/0!"}},null,null,"No longer used, elevation is linked to compressor inputs pages",null,null,null,null,null,"UT - Provo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elevation, feet",null,null,null,{"$f":"F27","v":0},null,"UT - Saint George"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atmospheric Pressure, psia",null,null,null,{"$f":"local_Patm(U42)","v":14.696999999999999},null,"UT - Salt Lake City"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAGI Std Atmospheric Pressure, psia",null,null,null,14.5,null,"UT - Vernal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"scfm per acfm",null,null,null,{"$f":"U43/U44","v":1.0135862068965518},null,"UT -Wendover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA - Bellingham"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"machine room temps",null,"WA - Kelso"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rated outlet dew point is 33 - 39 °F",null,null,null,70,null,"WA - Moses Lake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,null,"WA - Pasco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,"WA - Quillayute"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,null,"WA - Seattle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,null,"WA - Snohomish"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,null,"WA - Spokane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,"WA - Tacoma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,null,"WA - Walla Walla"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,null,"WA - Wenatchee"]
[null,null," DRYER UPGRADE ENERGY SAVINGS ESTIMATE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,null,"WA - Yakima"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,null,"WY - Casper"]
[null,null,null,null,"Baseline energy use:",{"$f":"J41","v":{"$error":"#DIV/0!"}},"kWh/yr",null,null,"Demand savings:",null,{"$f":"IF(F61=0,\"\",ROUND((F61/E41)*0.75,1))","v":{"$error":"#DIV/0!"}},"kW/mo",null,null,null,null,null,null,null,null,null,"WY - Cody"]
[null,null,null,null,"Upgrade energy use:",{"$f":"N41","v":{"$error":"#DIV/0!"}},"kWh/yr"]
[null,null,null,null,"Annual site savings:",{"$f":"F59-F60","v":{"$error":"#DIV/0!"}},"kWh/yr"]
[null,null,null,null,"% site savings:",{"$f":"IF(F59=0,\"\",F61/F59*100)","v":{"$error":"#DIV/0!"}},"%"]
[]
[null,{"$f":"'Customer Information'!B62","v":" Cascade Energy, Inc. © 2007 - November-07-2023"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-07-31"}]

{"sheet":"Desiccant Dryer","index":3,"n_rows":80,"n_cols":30,"rows_kept":80,"cut":false,"hidden":true,"merged":[[10,5,10,6],[10,8,10,9],[7,1,7,2],[8,5,8,7],[8,8,8,10],[9,5,9,6],[9,8,9,9],[11,5,11,6],[11,8,11,9],[12,5,12,6],[12,8,12,9],[13,5,13,6],[13,8,13,9],[29,5,29,6],[15,2,15,4],[16,5,16,6],[16,8,16,9],[17,5,17,6],[17,8,17,9],[20,5,20,6],[20,7,20,10],[20,11,20,13],[24,5,24,6],[24,8,24,9],[27,17,27,18],[28,5,28,6],[48,6,48,7],[48,8,48,9],[48,10,48,11],[48,12,48,13],[30,5,30,6],[31,5,31,6],[35,2,36,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[46,12,46,13],[47,6,47,7],[47,8,47,9],[47,10,47,11],[47,12,47,13],[56,6,56,7],[56,9,56,10],[56,11,56,12],[49,6,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,13],[50,6,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,13],[51,6,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,13],[52,12,52,13],[57,6,57,7],[57,9,57,10],[57,11,57,12],[58,6,58,7],[58,9,58,10],[58,11,58,12],[61,6,61,7],[61,9,61,10],[61,11,61,12],[59,6,59,7],[59,9,59,10],[59,11,59,12],[60,6,60,7],[60,9,60,10],[60,11,60,12]]}
[]
[]
[null,null,"ENERGY SAVINGS CALCULATOR FOR DESICCANT AIR DRYERS"]
[null,null,null,"Customer:",{"$f":"IF(ISBLANK(CompanyName),\"\",CompanyName&\":  \" &SiteCity&\", \"&SiteState)","v":":  , "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"indoors"]
[null,null,null,"Vendor:",{"$f":"VendorCompany","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SiteState","v":""},null,null,"outdoors"]
[]
[null,null," INFORMATION ABOUT THE AIR DRYERS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dryer Types","Default Purge Rate"]
[null,null,null,null,null,"    Baseline Dryer",null,null,"    Proposed Dryer",null,null,null,null,null,null,null,null,null,null,"Heatless",0.15]
[null,null,"Type of air dryer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heated Purge",7.4999999999999997E-2]
[null,null,"Dewpoint controls?:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blower Purge",0.02]
[null,null,"Rated dryer capacity:",null,null,null,null,"scfm",null,null,"scfm"]
[null,null,"Heater Power:",null,null,null,null,"kW",null,null,"kW"]
[null,null,"Blower Power:",null,null,null,null,"kW",null,null,"kW",null,null,null,null,null,null,null,null,"Part-Load Coefficients"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Dewpoint Controls","With Dewpoint Controls","Baseline","Upgrade"]
[null,null,"Do you know the average purge rate (scfm)?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dryer purge rate at 0% Capacity:",1,0.1,{"$f":"IF($F$11=\"Yes\",V16,U16)","v":1},{"$f":"IF($I$11=\"Yes\",V16,U16)","v":1}]
[null,null,"If yes, enter full load purge scfm",null,null,187.5,null,"scfm",24,null,"scfm",null,null,null,null,null,null,null,null,"Part-load slope:",{"$f":"1-U16","v":0},{"$f":"1-V16","v":0.9},{"$f":"IF($F$11=\"Yes\",V17,U17)","v":0},{"$f":"IF($I$11=\"Yes\",V17,U17)","v":0}]
[null,null,"Percent flow in purge:",null,null,{"$f":"BaselinePurge/BaselineSCFM","v":{"$error":"#DIV/0!"}},null,null,{"$f":"UpgradePurge/UpgradeSCFM","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Season","Shift","Bin","DB °F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"winter",1,1,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC19-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Dryer inlet air pressure:  ",{"$f":"'Savings Calculations'!H37","v":0},"psig",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"winter",2,2,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC20-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Compressor and dryer located:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"winter",3,3,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC21-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Ambient air temp near compressor:  ",null,"°F",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"spring",1,4,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC22-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Estimated dryer inlet air temp:  ",{"$f":"InsideAirTemperature+25","v":25},"°F","25 °F CDT from localized ambient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location",null,null,null,"spring",2,5,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC23-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID - Boise",null,null,null,"spring",3,6,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC24-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Corrected1 dryer capacity:  ",{"$f":"T28","v":0},null,"scfm",{"$f":"T29","v":0},null,"scfm",null,null,null,null,null,null,"Inlet air pressure correction:",null,{"$f":"Local_LinInterp(W73:W80,X73:X80,F20,1,0)","v":0.78310058818147499},null,null,"ID - Idaho Falls",null,null,null,"summer",1,7,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC25-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,"Note 1:  Corrected capacity includes adjustment for ambient temperature as well as dryer inlet air temperature and pressure.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlet air temp correction:",null,{"$f":"Local_LinInterp(Z73:Z78,AA73:AA78,F23,1,0)","v":1.0734954469306299},null,null,"ID - Lewiston",null,null,null,"summer",2,8,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC26-1,6)","v":{"$error":"#N/A"}}]
[null,null," INFORMATION ABOUT THE AIR COMPRESSOR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inside ambient corr.:",null,null,null,null,"ID - Malad City",null,null,null,"summer",3,9,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC27-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corrected Baseline capacity:",null,{"$f":"BaselineSCFM*(T26*T25)","v":0},null,null,"ID - Pocatello",null,null,null,"fall",1,10,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC28-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Total compressor hp feeding dryer: ",{"$f":"'Savings Calculations'!P18","v":0},null,"hp",null,null,null,null,null,null,null,null,null,"Corrected Upgrade capacity",null,{"$f":"UpgradeSCFM*(T26*T25)","v":0},null,null,"ID - Salmon",null,null,null,"fall",2,11,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC29-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Total rated flow: ",{"$f":"'Savings Calculations'!P19","v":0},null,"acfm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Astoria",null,null,null,"fall",3,12,{"$f":"INDEX(Weather!$A$1:$F$493,MATCH(WeatherLocationDesiccant,Weather!$A$1:$A$493,0)+AC30-1,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,"Site elevation above sea level: ",{"$f":"'Savings Calculations'!J20","v":0},null,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Baker City"]
[null,null,null,null,"Corrected flow: ",{"$f":"'Savings Calculations'!CS80","v":0},null,"scfm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Bend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Burns"]
[null,null," INFORMATION ABOUT THE SYSTEM AND ITS OPERATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Corvallis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Eugene"]
[null,null," Profile of Compressed Air Demand \nfor EEM Compressor",null,null,null,null,"Annual hours of operation: ",null,null,null,{"$f":"'Savings Calculations'!H38","v":0},"hours/yr",null,null,null,null,null,null,null,null,null,"OR - Klamath Falls"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Medford"]
[null,null,"% time","% flow","hrs/yr","scfm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Pendleton"]
[null,null,{"$f":"'Savings Calculations'!C42","v":0},{"$f":"'Savings Calculations'!S42","v":{"$error":"#DIV/0!"}},{"$f":"IF(C39=\"\",\"\",$L$36*C39)","v":0},{"$f":"D39*$F$32","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Portland"]
[null,null,{"$f":"'Savings Calculations'!C43","v":0},{"$f":"'Savings Calculations'!S43","v":{"$error":"#DIV/0!"}},{"$f":"IF(C40=\"\",\"\",$L$36*C40)","v":0},{"$f":"D40*$F$32-FlowReductionEEM*'Savings Calculations'!$R45","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - Roseburg",null,null,null,"machine room temps"]
[null,null,{"$f":"'Savings Calculations'!C44","v":0},{"$f":"'Savings Calculations'!S44","v":{"$error":"#DIV/0!"}},{"$f":"IF(C41=\"\",\"\",$L$36*C41)","v":0},{"$f":"D41*$F$32-FlowReductionEEM*'Savings Calculations'!$R46","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR - The Dalles",null,null,null,70]
[null,null,{"$f":"'Savings Calculations'!C45","v":0},{"$f":"'Savings Calculations'!S45","v":{"$error":"#DIV/0!"}},{"$f":"IF(C42=\"\",\"\",$L$36*C42)","v":0},{"$f":"D42*$F$32-FlowReductionEEM*'Savings Calculations'!$R47","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT - Delta",null,null,null,75]
[null,null,{"$f":"SUM(C39:C42)","v":0},null,{"$f":"SUM(E39:E42)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT - Hanksville",null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT - Moab",null,null,null,85]
[null,null,"BASELINE DRYER OPERATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT - Ogden",null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT - Provo",null,null,null,95]
[null,null,"Total Compressor Flow","User Flow","Purge Air Flow","Dryer Percent Capacity","Dryer Purge Requirement",null,"Heater Power",null,"Blower Power",null,"Heater/Blower Energy",null,null,null,null,null,null,null,null,null,"UT - Saint George",null,null,null,100]
[null,null,"scfm","scfm","scfm","%","%",null,"kW",null,"kW",null,"kWh/yr",null,null,null,null,null,null,null,null,null,"UT - Salt Lake City",null,null,null,105]
[null,null,{"$f":"F39","v":{"$error":"#DIV/0!"}},{"$f":"(C49-BaselinePurge*$W$16)/(($W$17*BaselinePurge/$F$25)+1)","v":{"$error":"#DIV/0!"}},{"$f":"C49-D49","v":{"$error":"#DIV/0!"}},{"$f":"D49/$F$25","v":{"$error":"#DIV/0!"}},{"$f":"$W$16+$W$17*F49","v":{"$error":"#DIV/0!"}},null,{"$f":"$F$13*0.7*0.8*G49","v":{"$error":"#DIV/0!"}},null,{"$f":"$F$14*0.7*0.8*G49","v":{"$error":"#DIV/0!"}},null,{"$f":"E39*(I49+K49)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"UT - Vernal",null,null,null,110]
[null,null,{"$f":"F40","v":{"$error":"#DIV/0!"}},{"$f":"(C50-BaselinePurge*$W$16)/(($W$17*BaselinePurge/$F$25)+1)","v":{"$error":"#DIV/0!"}},{"$f":"C50-D50","v":{"$error":"#DIV/0!"}},{"$f":"D50/$F$25","v":{"$error":"#DIV/0!"}},{"$f":"$W$16+$W$17*F50","v":{"$error":"#DIV/0!"}},null,{"$f":"$F$13*0.7*0.8*G50","v":{"$error":"#DIV/0!"}},null,{"$f":"$F$14*0.7*0.8*G50","v":{"$error":"#DIV/0!"}},null,{"$f":"E40*(I50+K50)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"UT -Wendover",null,null,null,115]
[null,null,{"$f":"F41","v":{"$error":"#DIV/0!"}},{"$f":"(C51-BaselinePurge*$W$16)/(($W$17*BaselinePurge/$F$25)+1)","v":{"$error":"#DIV/0!"}},{"$f":"C51-D51","v":{"$error":"#DIV/0!"}},{"$f":"D51/$F$25","v":{"$error":"#DIV/0!"}},{"$f":"$W$16+$W$17*F51","v":{"$error":"#DIV/0!"}},null,{"$f":"$F$13*0.7*0.8*G51","v":{"$error":"#DIV/0!"}},null,{"$f":"$F$14*0.7*0.8*G51","v":{"$error":"#DIV/0!"}},null,{"$f":"E41*(I51+K51)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"WA - Bellingham",null,null,null,120]
[null,null,{"$f":"F42","v":{"$error":"#DIV/0!"}},{"$f":"(C52-BaselinePurge*$W$16)/(($W$17*BaselinePurge/$F$25)+1)","v":{"$error":"#DIV/0!"}},{"$f":"C52-D52","v":{"$error":"#DIV/0!"}},{"$f":"D52/$F$25","v":{"$error":"#DIV/0!"}},{"$f":"$W$16+$W$17*F52","v":{"$error":"#DIV/0!"}},null,{"$f":"$F$13*0.7*0.8*G52","v":{"$error":"#DIV/0!"}},null,{"$f":"$F$14*0.7*0.8*G52","v":{"$error":"#DIV/0!"}},null,{"$f":"E42*(I52+K52)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"WA - Kelso"]
[null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(M49:N52)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"WA - Moses Lake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA - Pasco"]
[null,null,"UPGRADE DRYER OPERATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA - Quillayute"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA - Seattle"]
[null,null,"User Flow","Dryer Percent Capacity","Dryer Purge Requirement","Purge Air Flow","Total Compressor Flow",null,"Flow Reduction","Heater Power",null,"Blower Power",null,"Heater/\nBlower Energy",null,null,null,null,null,null,null,null,"WA - Snohomish"]
[null,null,"scfm","%","%","scfm","scfm",null,"scfm","kW",null,"kW",null,"kWh/yr",null,null,null,null,null,null,null,null,"WA - Spokane"]
[null,null,{"$f":"D49","v":{"$error":"#DIV/0!"}},{"$f":"C59/$I$25","v":{"$error":"#DIV/0!"}},{"$f":"$X$16+$X$17*D59","v":{"$error":"#DIV/0!"}},{"$f":"E59*UpgradePurge","v":{"$error":"#DIV/0!"}},{"$f":"C59+F59","v":{"$error":"#DIV/0!"}},null,{"$f":"C49-G59","v":{"$error":"#DIV/0!"}},{"$f":"$I$13*0.7*0.8*E59","v":{"$error":"#DIV/0!"}},null,{"$f":"$I$14*0.7*0.8*E59","v":{"$error":"#DIV/0!"}},null,{"$f":"E39*(J59+L59)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"WA - Tacoma"]
[null,null,{"$f":"D50","v":{"$error":"#DIV/0!"}},{"$f":"C60/$I$25","v":{"$error":"#DIV/0!"}},{"$f":"$X$16+$X$17*D60","v":{"$error":"#DIV/0!"}},{"$f":"E60*UpgradePurge","v":{"$error":"#DIV/0!"}},{"$f":"C60+F60","v":{"$error":"#DIV/0!"}},null,{"$f":"C50-G60","v":{"$error":"#DIV/0!"}},{"$f":"$I$13*0.7*0.8*E60","v":{"$error":"#DIV/0!"}},null,{"$f":"$I$14*0.7*0.8*E60","v":{"$error":"#DIV/0!"}},null,{"$f":"E40*(J60+L60)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"WA - Walla Walla"]
[null,null,{"$f":"D51","v":{"$error":"#DIV/0!"}},{"$f":"C61/$I$25","v":{"$error":"#DIV/0!"}},{"$f":"$X$16+$X$17*D61","v":{"$error":"#DIV/0!"}},{"$f":"E61*UpgradePurge","v":{"$error":"#DIV/0!"}},{"$f":"C61+F61","v":{"$error":"#DIV/0!"}},null,{"$f":"C51-G61","v":{"$error":"#DIV/0!"}},{"$f":"$I$13*0.7*0.8*E61","v":{"$error":"#DIV/0!"}},null,{"$f":"$I$14*0.7*0.8*E61","v":{"$error":"#DIV/0!"}},null,{"$f":"E41*(J61+L61)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"WA - Wenatchee"]
[null,null,{"$f":"D52","v":{"$error":"#DIV/0!"}},{"$f":"C62/$I$25","v":{"$error":"#DIV/0!"}},{"$f":"$X$16+$X$17*D62","v":{"$error":"#DIV/0!"}},{"$f":"E62*UpgradePurge","v":{"$error":"#DIV/0!"}},{"$f":"C62+F62","v":{"$error":"#DIV/0!"}},null,{"$f":"C52-G62","v":{"$error":"#DIV/0!"}},{"$f":"$I$13*0.7*0.8*E62","v":{"$error":"#DIV/0!"}},null,{"$f":"$I$14*0.7*0.8*E62","v":{"$error":"#DIV/0!"}},null,{"$f":"E42*(J62+L62)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"WA - Yakima"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(N59:N62)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"WY - Casper"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY - Cody"]
[null,null," DRYER UPGRADE ENERGY SAVINGS ESTIMATE"]
[]
[null,null,null,null,"Baseline energy use:",{"$f":"M53","v":{"$error":"#DIV/0!"}},"kWh/yr"]
[null,null,null,null,"Upgrade energy use:",{"$f":"N63","v":{"$error":"#DIV/0!"}},"kWh/yr"]
[]
[null,{"$f":"'Customer Information'!B62","v":" Cascade Energy, Inc. © 2007 - November-07-2023"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-07-31"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inlet Pressure","Correction Factor",null,"Inlet Temperature","Correction Factor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,0.78310058818147499,null,90,1.0734954469306299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,0.89038917990066202,null,100,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,1,null,110,0.82922083043694494]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,1.0907974260093301,null,120,0.69018789627057398]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,1.19808980362752,null,130,0.56532011353490397]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,1.2835800302240901,null,140,0.45571875818306201]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,1.3810631435370999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,1.43821170957527]

{"sheet":"Explanation of Inputs","index":4,"n_rows":179,"n_cols":46,"rows_kept":179,"cut":false,"hidden":false,"merged":[[18,4,29,30],[34,4,45,30],[50,28,50,30],[59,28,59,30],[67,28,67,30],[64,11,64,27],[51,28,51,30],[50,5,50,10],[50,11,50,27],[58,28,58,30],[57,5,57,10],[58,5,58,10],[59,5,59,10],[60,5,60,10],[61,5,61,10],[62,5,62,10],[68,28,68,30],[60,28,60,30],[61,28,61,30],[62,28,62,30],[63,28,63,30],[64,28,64,30],[65,28,65,30],[66,28,66,30],[70,11,70,27],[69,28,69,30],[70,28,70,30],[71,28,71,30],[72,28,72,30],[72,7,72,9],[72,10,72,12],[72,13,72,15],[72,16,72,18],[71,11,71,27],[72,25,72,27],[72,19,72,21],[72,22,72,24],[73,4,74,30],[4,22,6,30],[56,28,56,30],[57,28,57,30],[54,28,54,30],[55,28,55,30],[52,28,52,30],[53,28,53,30],[10,4,13,30],[51,5,51,10],[52,5,52,10],[53,5,53,10],[54,5,54,10],[55,5,55,10],[56,5,56,10],[68,5,68,10],[57,11,57,27],[63,5,63,10],[64,5,64,10],[65,5,65,10],[66,5,66,10],[67,5,67,10],[63,11,63,27],[66,11,66,27],[67,11,67,27],[69,5,69,10],[70,5,70,10],[71,5,71,10],[51,11,51,27],[52,11,52,27],[53,11,53,27],[54,11,54,27],[55,11,55,27],[56,11,56,27],[65,11,65,27],[68,11,68,27],[69,11,69,27],[58,11,58,27],[59,11,59,27],[60,11,60,27],[61,11,61,27],[62,11,62,27]]}
[]
[null,false]
[]
[null,null,null," EXPLANATION OF INPUTS"]
[null,null,null,null,null,null,"Customer:",null,{"$f":"IF(ISBLANK(CompanyName),\"\",CompanyName&\":  \" &SiteCity&\", \"&SiteState)","v":":  , "}]
[null,null,null,null,null,null,"Vendor:",null,{"$f":"VendorCompany","v":""}]
[]
[null,null,null," HOURS OF OPERATION"]
[null,null,null," Please explain how the hours of operation was determined"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     "]
[]
[null,null,null," EXPLANATION OF COMPRESSOR LOAD PROFILE"]
[null,null,null," Please describe how the compressed air demand profile in the savings calculation was estimated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null," BENEFITS IN ADDITION TO ENERGY SAVINGS"]
[null,null,null," If a figure for non-energy benefits is entered in the Savings Calculations, please describe how this value was quantified."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null," EXPLANATION OF PROJECT COSTS"]
[null,null,null," This space is provided to detail the project costs.  Project costs summed here will appear on the \"Savings Calculations\" tab."]
[]
[null,null,null,null,"No.","Supplier",null,null,null,null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount*"]
[null,null,null,null,1]
[null,null,null,null,2]
[null,null,null,null,3]
[null,null,null,null,4]
[null,null,null,null,5]
[null,null,null,null,6]
[null,null,null,null,7]
[null,null,null,null,8]
[null,null,null,null,9]
[null,null,null,null,10]
[null,null,null,null,11]
[null,null,null,null,12]
[null,null,null,null,13]
[null,null,null,null,14]
[null,null,null,null,15]
[null,null,null,null,16]
[null,null,null,null,17]
[null,null,null,null,18]
[null,null,null,null,19]
[null,null,null,null,20]
[null,null,null,null,21]
[null,null,null,null,"Total Cost:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC52:AE72)","v":0}]
[null,null,null,null,"* For baseline costs, enter \"Baseline\" at the beginning of the  description and enter a negative cost. \n  For upgrade costs, enter \"Upgrade\" at the beginning of the description and enter a positive cost."]
[]
[null,{"$f":"'Customer Information'!B62","v":" Cascade Energy, Inc. © 2007 - November-07-2023"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ToolName&\" - \"&ToolVersion","v":"BPA Small Compressed Air Calculator - 5.1"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TO APPLY FOR INCENTIVES FROM ENERGY TRUST OF OREGON:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for Energy Trust Projects"]
[null,null,null,null,"1)","Enter the information requested above about Participant, Project, Vendor, baseline compressor, proposed"]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,"2)","Send this Excel file as an email attachment to smallindustrial@energytrust.org.  Include a copy of the proposal"]
[null,null,null,null,null,"or quotation for the new compressor."]
[null,null,null,null,"3)","Energy Trust will review inputs and outputs and call with any questions.  Upon approval, Energy Trust will then"]
[null,null,null,null,null,"provide an offer of funding for review and acceptance by Participant.  If the Oregon BETC box is checked, "]
[null,null,null,null,null,"a partially-completed BETC application will also be provided.  "]
[null,null,null,null,"4)","Participant completes the entries in the Energy Trust agreement, signs, and returns the agreement to Energy"]
[null,null,null,null,null,"Trust.  If applying for BETC, Participant completes the entries in the BETC application, signs, and sends with"]
[null,null,null,null,null,"application fee to Oregon Department of Energy in Salem."]
[null,null,null,null,"5)","Order equipment and schedule the installation.  When installation is complete, notify Energy Trust as well as"]
[null,null,null,null,null,"ODOE.  Each agency has its own brief process to close out the project and issue payment or final certification."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TO APPLY FOR INCENTIVES FROM YOUR LOCAL ELECTRIC 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,"for Oregon, non-Energy Trust projects"]
[null,null,null,null,"1)","Contact the utility that provides electric service to the project site and inquire about incentives for"]
[null,null,null,null,null,"compressed air.  Discuss this tool and what role it may play in analyzing the savings for a compressed"]
[null,null,null,null,null,"air project.  The utility's incentive rate and cap figures will be needed as inputs above."]
[null,null,null,null,"2)","Enter the information requested about Participant, Project, Vendor, baseline compressor, proposed"]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions."]
[null,null,null,null,"3)","Send this Excel file as an email attachment to the local utility.  Include a copy of the proposal or"]
[null,null,null,null,null,"quotation for the new compressor.  A printout of this analysis may also be used to apply for "]
[null,null,null,null,null,"the Business Energy Tax Credit (BETC) administered by the Oregon Department of Energy."]
[null,null,null,null,"4)","The utility will review inputs and outputs, call with any questions, and request any additional "]
[null,null,null,null,null,"documentation that may be necessary.  An incentive agreement or application form provided by the"]
[null,null,null,null,null,"utility will be completed at this point."]
[null,null,null,null,"5)","Once the funding agreement is in place, equipment may be ordered and installed.  Please note that"]
[null,null,null,null,null,"utilities will not offer funding for projects in which equipment has been ordered prior to signing an "]
[null,null,null,null,null,"agreement."]
[null,null,null,null,"6)","When installation is complete, notify the utility and follow the utility-specific closeout process."]
[null,null,null,null,null,"An inspection may be required before the incentive check is issued.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reason for project:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"IF(AR157,10,1)","v":10},"Replace working compressor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AR158,10,2)","v":2},"End of life compressor replacement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AR159,10,3)","v":3},"Add capacity to existing system"]
[null,null,null,"TO APPLY FOR INCENTIVES FROM YOUR LOCAL ELECTRIC 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,"for non-Oregon projects",null,null,null,null,null,null,null,null,null,null,true,{"$f":"IF(AR160,10,4)","v":10},"New compressor in new facility"]
[null,null,null,null,"1)","Contact the utility that provides electric service to the project site and inquire about incentives for",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(NOT(AR157),NOT(AR158),NOT(AR159),NOT(AR160)),10,5)","v":5},"unknown"]
[null,null,null,null,null,"compressed air.  Discuss this tool and what role it may play in analyzing the savings for a compressed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(10,AS157:AT161,2,FALSE)","v":"Replace working compressor"}]
[null,null,null,null,null,"air project.  The utility's incentive rate and cap figures will be needed as inputs above."]
[null,null,null,null,"2)","Enter the information requested about Participant, Project, Vendor, baseline compressor, proposed"]
[null,null,null,null,null,"new compressor, operating characteristics of the system, and assumptions."]
[null,null,null,null,"3)","Send this Excel file as an email attachment to the local utility.  Include a copy of the proposal or"]
[null,null,null,null,null,"quotation for the new compressor."]
[null,null,null,null,"4)","The utility will review inputs and outputs, call with any questions, and request any additional "]
[null,null,null,null,null,"documentation that may be necessary.  An incentive agreement or application form provided by the"]
[null,null,null,null,null,"utility will be completed at this point."]
[null,null,null,null,"5)","Once the funding agreement is in place, equipment may be ordered and installed.  Note that utilities"]
[null,null,null,null,null,"will not offer funding for projects where equipment has been ordered prior to signing an agreement."]
[null,null,null,null,"6)","When installation is complete, notify the utility and follow the utility-specific closeout process."]
[null,null,null,null,null,"An inspection may be required before the incentive check is issued."]
[]
[]
[]
[]
[null,null,null,"BLANK CELLS IN THE NEXT 20 LINES FOR CLEARING INSTRUCTIONS."]

{"sheet":"Master Outputs","index":5,"n_rows":288,"n_cols":17,"rows_kept":288,"cut":false,"hidden":true,"merged":[[90,4,90,5],[38,7,38,8],[38,1,38,2],[38,3,38,4],[38,5,38,6],[60,6,66,6]]}
["ASSEMBLY AREA FOR VALUES TO BE TRANSFERRED TO OUTPUT SHEETS, FORMS, AND APPLICATION TEMPLATES"]
["Participant Information","Values Transferred","Range Names",null,null,null,null,null,null,null,"Choices for Business Type:"]
["Contact Name:",{"$f":"IF('Customer Information'!D10=0,\"\",'Customer Information'!D10)","v":""},"ContactName",null,"orange type","VBA inserts the value",null,null,null,null,"Agriculture, Forestry, Fishing and Hunting",1,null,null,"Revision History"]
["Last Name:",{"$f":"IF(ISERR(FIND(\" \",ContactName,1+FIND(\" \",ContactName))),MID(ContactName,FIND(\" \",ContactName)+1,LEN(ContactName)),MID(ContactName,1+FIND(\" \",ContactName,1+FIND(\" \",ContactName)),LEN(ContactName)))","v":{"$error":"#VALUE!"}},"LastName",null,"blue type","the cell has undergone a special intermediary formatting step",null,null,null,null,"     Crop Production",null,null,null,"V2.00",null,"Initial Release"]
["Title:",{"$f":"IF($L$3=2,\"Ms.\",\"Mr.\")","v":"Mr."},"ContactGender",null,"violet type","the cell is hard coded",null,null,null,null,"           Greenhouse",null,null,null,"V2.01","2009-06-12","Fixed C/E checker cell B203"]
["Title:",{"$f":"IF('Customer Information'!R10=0,\"\",'Customer Information'!R10)","v":""},"Title",null,"green background","cell is a named range filled by copying a value from the tool",null,null,null,null,"           Field Crops",null,null,null,"V2.01","2009-06-12","Merged cells for explanation of Inputs field"]
["Company Name:",{"$f":"IF('Customer Information'!D8=0,\"\",'Customer Information'!D8)","v":""},"CompanyName",null,"orange type","cell is named range filled by VBA in tool",null,null,null,null,"           Indoor Agriculture",null,null,null,"V2.01","2009-06-12","Created print area around C/E checker"]
["Mailing Address:",{"$f":"IF('Customer Information'!D12=0,\"\",'Customer Information'!D12)","v":""},"MailStreet",null,"grey background","cell is named range filled by calculation - used by DocMaker, common to all tools",null,null,null,null,"     Animal Production and Aquaculture",null,null,null,"V2.01","2009-06-12","Changed many fields that reported \"0\" to \"\""]
["City:",{"$f":"IF('Customer Information'!R12=0,\"\",'Customer Information'!R12)","v":""},"MailCity",null,"no background","cell is used for interim calculations - tool specific may be named or unnamed",null,null,null,null,"     Forestry and Logging",null,null,null,"V2.01","2009-06-12","Fixed format on Estimated Energy Savings to \"#,###\""]
["State:",{"$f":"IF('Customer Information'!Z12=0,\"\",'Customer Information'!Z12)","v":""},"MailState",null,"yellow background","cell is hand entered every time",null,null,null,null,"     Support Activities for Agriculture and Forestry",null,null,null,"V2.01","2009-06-16","Fixed fix of 12 June - Company Name was referencing Contact when blank"]
["Zip:",{"$f":"IF('Customer Information'!AC12=0,\"\",'Customer Information'!AC12)","v":""},"MailZip",null,"orange background","review this cell - it may at times need a manual entry",null,null,null,null,"Mining, Quarrying, and Oil and Gas Extraction",null,null,null,"V2.01","2009-06-16","added reference to Version 2.01 at bottom of Customer Information and Savings Calcs pages"]
["Site Address:",{"$f":"IF(IF(ISBLANK('Customer Information'!D23),'Customer Information'!D12,'Customer Information'!D23)=0,\"\",IF(ISBLANK('Customer Information'!D23),'Customer Information'!D12,'Customer Information'!D23))","v":""},"SiteStreet",null,"light blue background","provides the name of the cell immediately to the left",null,null,null,null,"     Oil and Gas Extraction",null,null,null,"V2.02","2009-06-25","changed \"show license agmt\" so it shows every time upon opening file (for BPA purposes)"]
["Site City:",{"$f":"IF(IF(ISBLANK('Customer Information'!Q23),'Customer Information'!R12,'Customer Information'!Q23)=0,\"\",IF(ISBLANK('Customer Information'!Q23),'Customer Information'!R12,'Customer Information'!Q23))","v":""},"SiteCity",null,null,null,null,null,null,null,"     Mining (except Oil and Gas)",null,null,null,"V2.02","2009-06-25","left WA and \"other\" utility boxes checked in read only version so Energy Trust rates do not show upon opening"]
["Site State:",{"$f":"IF(ISBLANK('Customer Information'!Z23),MailState,'Customer Information'!Z23)","v":""},"SiteState",null,null,null,null,null,null,null,"     Support Activities for Mining",null,null,null,"V2.02","2009-06-25","changed the Energy Trust rates that show to 25 cents and 60% (from 20 cents and 50%)"]
["Site Zip:",{"$f":"IF(IF(ISBLANK('Customer Information'!AC23),'Customer Information'!AC12,'Customer Information'!AC23)=0,\"\",IF(ISBLANK('Customer Information'!AC23),'Customer Information'!AC12,'Customer Information'!AC23))","v":""},"SiteZip",null,null,null,null,null,null,null,"Utilities",null,null,null,"V2.03","2009-06-29","Added VBA so that focus moves to \"existing system pressure\" cell rather than jumping far down"]
["County:",{"$f":"IF(ISBLANK('Customer Information'!D25),\"\",'Customer Information'!D25)","v":"Lane"},"SiteCounty",null,null,null,null,null,null,null,"     Electric Power Generation, Transmission and Distribution",null,null,null,null,null,"and to the right when user leaves the non-energy-benefit cell."]
["Tel or Cell Phone:",{"$f":"IF('Customer Information'!C14=0,\"\",'Customer Information'!C14)","v":""},"TelOrCell",null,null,null,null,null,null,null,"     Natural Gas Distribution ",null,null,null,"V2.04","2010-02-15","Change Energy Trust cap from 60% to 50% in VB Module for Customer Information at top."]
["Fax:",{"$f":"IF('Customer Information'!I14=0,\"\",'Customer Information'!I14)","v":""},"Fax",null,null,null,null,null,null,null,"     Water, Sewage and Other Systems ",null,null,null,null,null,"Change \"Eligible for 60%\" pulldowns in line 200 to \"No\""]
["Email:",{"$f":"IF('Customer Information'!O14=0,\"\",'Customer Information'!O14)","v":""},"ContactEmail",null,null,null,null,null,null,null,"           Water Supply Systems",null,null,null,null,null,"Change copyright notice & date in footer of Savings Calculations and Customer Information pages"]
["Today's Date (presumed date of doc prep):",{"$f":"TEXT(NOW(),\"mmmm d,yyyy\")","v":"July 31,2024"},"DateOfPrep (today's date)",null,null,null,null,null,null,null,"           Sewage Treatment Facilities ",null,null,null,"V2.05","2010-03-19","BPA Credit & Cost Effectiveness calculator added by Tom Eckman."]
[null,null,null,null,null,null,null,null,null,null,"Manufacturing",null,null,null,null,null,"Cell B48 goes by two names:  kWhSavings and BETCElectricitySavedkWh"]
["Account Information",null,null,null,null,null,null,null,null,null,"     Food Manufacturing",null,null,null,null,null,"Instructions for creating the PTR upload file added."]
["Utility Name:",null,"UtilityName",null,"GasUtilityName",null,null,null,null,null,"     Beverage and Tobacco Product Manufacturing",null,null,null,"V2.1",null,"Updated ETO CE Checker"]
["Rate:",null,null,null,null,null,null,null,null,null,"           Brewery",null,null,null,"V2.2",null,"Updates to Master Outputs for DocMaker 2 compatibility"]
["Account Number:",{"$f":"IF(LEN(TEXT('Customer Information'!Q21,\"#\"))>2,'Customer Information'!Q21,\"\")","v":"10170"},"UtilAccountNumber",null,null,null,null,null,null,null,"           Winery",null,null,null,null,null,"Added ETO Bonus calculation"]
["Type of Industry:",{"$f":"IF('Customer Information'!M25=0,\"\",'Customer Information'!M25)","v":""},"IndustryType",null,null,null,null,null,null,null,"     Textile Mills",null,null,null,null,null,"Removed incentive rate auto-fill for BPA utilities"]
["Reason for Project:",{"$f":"'Customer Information'!AT142","v":"Replace working compressor"},"ReasonForProject",null,null,null,null,null,null,null,"     Apparel Manufacturing",null,null,null,null,null,"Removed BETC Calculations"]
[null,null,null,null,null,null,null,null,null,null,"     Leather and Allied Product Manufacturing",null,null,null,"V2.3","2011-11-23","fixed compatibility issues between excel 2003 and 2010"]
["Vendor Information",null,null,null,null,null,null,null,null,null,"     Wood Product Manufacturing",null,null,null,null,"2010-11-23","added legal language in pop-up form"]
["Vendor Company:",{"$f":"IF('Customer Information'!D36=0,\"\",'Customer Information'!D36)","v":""},"VendorCompany",null,null,null,null,null,null,null,"     Paper Manufacturing",null,null,null,null,"2010-11-29","fixed license agreement pop-up and cleaned up admin buttons"]
["Sales Representative:",{"$f":"IF('Customer Information'!P36=0,\"\",'Customer Information'!P36)","v":""},"SalesRep",null,null,null,null,null,null,null,"     Printing and Related Support Activities"]
["Tel/Cell:",{"$f":"IF('Customer Information'!Y36=0,\"\",'Customer Information'!Y36)","v":""},"VendorTel",null,null,null,null,null,null,null,"     Petroleum and Coal Products Manufacturing",null,null,null,"V2.4","2010-11-22","Added cycling dryer analysis as an extra page"]
[null,null,null,null,null,null,null,null,null,null,"     Chemical Manufacturing",null,null,null,null,null,"Updated cost inputs and savings outputs to reflect user-selected cycling dryer info"]
["Incentive Information",null,null,null,null,null,null,null,null,null,"     Plastics and Rubber Products Manufacturing",null,null,null,null,null,"Added admin buttons to protect and unprotect book"]
[" ",{"$f":"IncentiveRateCell","v":0.33},"UtilityIncentiveRate",null,null,null,null,null,null,null,"     Nonmetallic Mineral Product Manufacturing",null,null,null,null,"2010-11-29","Added language specific to cycling dryer replacement to the \"installed\" and \"BETC\" fields on the transition sheet"]
["Incentive Cap:",{"$f":"IncentiveCapCell","v":0.7},"UtilityIncentiveCap",null,null,null,null,null,null,null,"           Glass",null,null,null,null,"2011-04-11","Added cooling fan VFD and demand reduction calculations"]
["Amount of Federal Funding:",{"$f":"'Customer Information'!V31","v":0},"FederalFunding",null,null,null,null,null,null,null,"           Concrete",null,null,null,null,"2011-12-20","Removed \"Project Summary\" macro and reference text (this caused issues with old verions of MSOffice due to the use of the Word Object Library."]
[null,null,null,null,null,null,null,null,null,null,"     Primary Metal Manufacturing",null,null,null,null,null,"Changed Bonus Incentive to \"Kick Start Bonus\""]
["Project Energy Detail","Electricity",null,null,null,null,null,null,null,null,"     Fabricated Metal Product Manufacturing",null,null,null,null,null,"Removed extra captions under Reason for Project on the Customer Information tab"]
["Baseline Energy Use, energy unit",{"$f":"SUM('Savings Calculations'!E68:H68)","v":{"$error":"#N/A"}},"BaselineElectricityKwh",null,null,null,null,null,null,null,"     Machinery Manufacturing",null,null,null,null,null,"Changed ETO gas incentive to $2.00"]
["Baseline Energy Use, MMBTU",{"$f":"BaselineElectricityKwh*3413/1000000","v":{"$error":"#N/A"}},"BetcBaselineElectricityMMBTU",null,null,null,null,null,null,null,"     Computer and Electronic Product Manufacturing",null,null,null,null,"2012-01-06","Bonus Text was updated to reflect KB bonus vs. FB bonus"]
["Upgrade Energy Use, energy unit",{"$f":"SUM('Savings Calculations'!E69:H69)","v":{"$error":"#N/A"}},"UpgradeElectricityKwh",null,null,null,null,null,null,null,"     Electrical Equipment, Appliance, and Component Manufacturing",null,null,null,"v2.5","2012-03-05","Added data input on cover page"]
["Upgrade Energy Use, MMBTU",{"$f":"UpgradeElectricityKwh*3413/1000000","v":{"$error":"#N/A"}},"BetcUpgradeElectricityMMBTU",null,null,null,null,null,null,null,"     Transportation Equipment Manufacturing",null,null,null,null,null,"Added cost summary table on explanation of inputs"]
["Energy Saved, energy unit",{"$f":"BaselineElectricityKwh-UpgradeElectricityKwh","v":{"$error":"#N/A"}},"kWhSaved, ALSO BetcElectricitySavedKwh",null,null,null,null,null,null,null,"     Furniture and Related Product Manufacturing",null,null,null,null,null,"Fixed some minor protection macro issues from v2.4"]
["Energy Saved, MMBTU",{"$f":"BetcBaselineElectricityMMBTU-BetcUpgradeElectricityMMBTU","v":{"$error":"#N/A"}},"BetcElectricitySavedMMBTU",null,null,null,null,null,null,null,"Refrigerated Warehousing and Storage",null,null,"Never officially released this version","v2.6","2012-03-22","Added Calculator type and sector to PTR upload file"]
["Busbar Energy Saved, kWh",{"$f":"(BaselineElectricityKwh-UpgradeElectricityKwh)*B50","v":{"$error":"#N/A"}},"BusbarElectricitySavedkWh",null,null,null,null,null,null,null,"Waste Management and Remediation Services",null,null,null,null,null,"Changed all references of PTR to EE Central."]
["Energy Cost per Energy unit",{"$f":"ElectricRate","v":5.7099999999999998E-2},"ElectricityRate",null,null,null,null,null,null,null,"Other Industrial Services",null,null,null,null,null,"Updated EE Central output code to include additional items."]
["Value of Energy Savings",{"$f":"(BaselineElectricityKwh-UpgradeElectricityKwh)*ElectricityRate","v":{"$error":"#N/A"}},"ElectricityCostSavings",null,null,null,null,null,null,null,"     Repair and Maintenance",null,null,null,null,null,"Added Technical review section starting in cells D211 on Customer information tab."]
["Value Gas and Electric Savings",{"$f":"ElectricityCostSavings+BetcValueGasSavings","v":{"$error":"#N/A"}},"ValueGasElectricSavings",null,null,null,null,null,null,null,"     Industrial Laundry Services",null,null,null,null,null,"Added code to each State Check box to populate the site state when box is changed."]
["Busbar Multiplier for BPA projects",{"$f":"BPA_Busbar_Factor","v":1.1118300000000001},"LnLossAdj",null,null,null,null,null,null,null,null,null,null,null,null,null,"    - The old code only changed when the user selected another tab"]
["Energy savings Text",{"$f":"IF(BETCElectricitySavedkWh=0,CONCATENATE(TEXT(BetcGasSavedTherms,\"#,###\"),\" \",\" therms\"),CONCATENATE(TEXT(BETCElectricitySavedkWh,\"#,###\"),\"\",\" kWh\"))","v":{"$error":"#N/A"}},"EnergySavingsText",null,null,null,null,null,null,null,null,null,null,null,"v2.7","2012-04-24","Change the BPA cost/benefit ratio from 0.1 to 0.5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-07-02","Changed data validation on O&M and Non-energy benefits to allow for negative values."]
["Project Economic Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Removed references to Energy Trust Kick-Start Bonus."]
["Baseline Equipment Cost",{"$f":"'Savings Calculations'!J26","v":0},"BaselineEquipmentCost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Trust Bonus code commented out in VBA"]
["Baseline Installation, Shipping Cost:",{"$f":"'Savings Calculations'!J27","v":0},"BaselineLaborCost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Trust bonus hardcoded to False"]
["BETC Total Baseline Cost",{"$f":"BaselineEquipmentCost+BaselineLaborCost","v":0},"BetcTotalBaselineCost",null,null,"Text for Project Name based on selected Measures",null,null,null,null,null,null,null,null,null,null,"Energy Trust check box moved from main page to master outputs (near B170)."]
["Upgraded EquipmentCost",{"$f":"'Savings Calculations'!P26","v":0},"UpgradeEquipmentCost",null,null,{"$f":"ShowDryer","v":false},"Cycling Air Dryer","This represents the text associated with the Dryer measure",null,null,null,null,null,null,null,null,"Added Upgrade compressor time-out option"]
["Upgrade Installation, Shipping Cost",{"$f":"'Savings Calculations'!P27","v":0},"UpgradeLaborCost",null,null,{"$f":"InstallFanVFD","v":false},"Cooling Fan VFD","This represents the text associated with the Cooling Fan VFD measure",null,null,null,null,null,null,null,null,"If a value of 0% flow is added to the table additional rows are surfaced to allow for the user to enter a new % unloaded vs. % timed-out breakdown"]
["Energy Trust/Utility Eligible Cost",{"$f":"(UpgradeEquipmentCost+UpgradeLaborCost)-(BaselineEquipmentCost+BaselineLaborCost)","v":0},"EstUtilEligibleCost",null,null,{"$f":"FlowReductionEEM","v":false},"Flow Reduction","This represents the text associated with the Flow Reduction Measure measure",null,null,null,null,null,null,null,null,"This changes the annual hours for the last operating bin."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v3.0","2014-03-04","Fixed issue with cooling fan VFD savings.  If user entered 8760 hrs and used the timeout to zero out unpressurized hours (off time) the"]
[null,null,null,null,null,{"$f":"IF(AND(F57:F59),\", \"&G57&\", \"&G58&\", and \"&G59,F62)","v":""},"←When measures are toggled this cell will popluate with the correct text to add to the project name cell",{"$f":"F61","v":""},null,null,null,null,null,null,null,null,"savings would overpredict.  Made it so this method of specifying time would give same kWh fan savings as the usual method of making the entried."]
[null,null,null,null,null,{"$f":"IF(AND(F57:F58),\", \"&G57&\", and \"&G58,F63)","v":""},null,{"$f":"F62","v":""},null,null,null,null,null,null,null,null,"Added \"Prepared by\" field."]
[null,null,null,null,null,{"$f":"IF(AND(F58:F59),\", \"&G58&\", and \"&G59,F64)","v":""},null,"",null,null,null,null,null,null,null,null,"Changed copyright to 2014"]
[null,null,null,null,null,{"$f":"IF(AND(F57,F59),\", \"&G57&\", and \"&G59,F65)","v":""},null,"",null,null,null,null,null,null,null,null,"Removed hardwired code that fills in BPA incentive rate and cap because utilities will vary."]
[null,null,null,null,null,{"$f":"IF(F57,\" and \"&G57,F66)","v":""},null,"",null,null,null,null,null,null,null,null,"Removed hardwired code that fills in PacifiCorp incentive rate and cap because cap varies among states."]
[null,null,null,null,null,{"$f":"IF(F58,\" and \"&G58,F67)","v":""},null,"",null,null,null,null,null,null,null,null,"Added one year payback incentive constraint for Pacific Power and Rocky Mountain Power projects."]
[null,null,null,null,null,{"$f":"IF(F59,\" and \"&G59,\"\")","v":""},null,"",null,null,null,null,null,null,null,null,"Added rounding of baseline and upgrade kWh values to the nearest kWh."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Added rounding of incentive amount to nearest cent."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v3.0","2014-05-29","Commented out the note that would appear \"Energy savings includes BPA line loss factor.\" in 6 places."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The savings with the line loss multiplier used to appear in a separate cell, but it has not done so for a while.  So the note is misleading.  Got rid of it."]
["Annual value of non-energy benefits:",{"$f":"'Savings Calculations'!$P$30","v":0},"NonEnergyBenefits",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kept version number at v3.0 as requested by Erin 5/29/14.\\"]
["Annual reduction in operating and maintenance costs:",{"$f":"'Savings Calculations'!$P$29","v":0},"OandMReduction",null,null,null,null,null,null,null,null,null,null,null,"v3.01","2014-08-07","Added Access Data and updated protection. (KS)"]
["Assumed customer discount rate:",0.05,"DiscountRate","(hard coded value - change manually)",null,null,null,null,null,null,null,null,null,null,"v3.1","2014-12-30","Updated CE for new avoided Costs, discount rate, added revision history for avoided costs per Ted Light's request"]
["Project name:",{"$f":"IF(AND(F57:F59),\"Compressed Air Upgrades\",\"Air Compressor\"&F61&\" Upgrade\")","v":"Air Compressor Upgrade"},"ProjectName",null,null,null,null,null,null,null,null,null,null,null,"V3.2","2015-07-27","Added Business Type Chooser for Energy Trust. Revised AccessData tab for SharePoint integration"]
["Tool name:","BPA Small Compressed Air Calculator","ToolName","(hard coded value - change manually)",null,null,null,null,null,null,null,null,null,null,"V3.3","2015-09-04","Fixed Protection issue with Business Type selection box."]
["Tool version:","5.1","ToolVersion","(hard coded value - change manually)",null,null,null,null,null,null,null,null,null,null,"v3.4","2015-01-06","Updated the C/E Calculator for the 2016 A/C.  Added additional named ranges to make calcs easier to follow.  Changed max incentive for $499,999 (from $500,000).  Adjusted incentive calcs to calc incentive if a project had both electric and gas savings and the customer is self-directed. "]
["Measure name:",{"$f":"'Savings Calculations'!P18&\" hp \"&VLOOKUP('Savings Calculations'!Q15,'Savings Calculations'!$CH$93:$CI$97,2)&\" air compressor\"","v":" hp VFD air compressor"},"MeasureName",null,null,null,null,null,null,null,null,null,null,null,"v3.5","2016-03-11","Updated the NPV of the \"other savings\" to reflect the actual discount rate.  The cell was referencing a blank cell. "]
["Date of last Revision","2023-11-07","Tool_Revision_Date",null,null,null,null,null,null,null,null,null,null,"Doug Heredos","V4.0","2019-07-25","Added BPA list of utilities as a drop down w/lookup to BES.  Added notice if tool has not been through technical review. Removed hours-of-operation calculator and updated cost table. Added \"BPA\" to version number to prevent future confusion."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Doug Heredos","V5.0","2023-07-31","Added desiccant dryer. Removed references to other utility programs.  Greatly simplified Master Outputs Page. Changed BPA busbar factor from 1.09056 to 1.11183"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Doug Heredos","V5.1","2023-11-07","Corrected a hardcoded busbar factor.  Corrected error that would allow load to be negative on Savings Calcs U42-U45 when a dessicant dryer is installed.  This was causing an error on the fan VFD savings page."]
[]
["BPA Busbar Factor",1.1118300000000001]
[]
[]
[]
[]
[]
[]
[]
[]
["BPA Utility Lookup",null,null,null,"Used on Customer Information Tab"]
["EWEB",null,"BES_Number",null,"Industry Type","Sector List"]
["Choose Utility","Description",null,null,"Generic Plant with One Shift","Industrial"]
["Albion","City of Albion","10055",null,"Generic Plant with Two Shifts","Commercial"]
["Alder","Alder Mutual Light Company","10005",null,"Generic Plant with Three Shifts","Agricultural"]
["Ashland","City of Ashland","10057",null,"Chemical Processing"]
["Asotin PUD","Public Utility District No. 1 of Asotin County","10015",null,"Food Processing"]
["Bandon","City of Bandon","10059",null,"Lumber & Wood Products"]
["Benton PUD","Public Utility District No. 1 of Benton County","10024",null,"NonDSI Primary Metals"]
["Benton REA","Benton Rural Electric Association","10025",null,"Petroleum Refining"]
["Big Bend","Big Bend Electric Cooperative","10027",null,"Primary Aluminum Smelting"]
["Blachly-Lane","Blachly-Lane Electric Cooperative","10029",null,"Pulp & Paper"]
["Blaine","City of Blaine","10061",null,"Transportation"]
["Bonners Ferry","City of Bonners Ferry","10062",null,"Industrial - Other"]
["BPA","Bonneville Power Administration","13738"]
["Burley","City of Burley","10064"]
["Canby","Canby Utility Board","10044"]
["Cascade Locks","City of Cascade Locks","10065"]
["CEC","Central Electric Cooperative, Inc.","10046"]
["Central Lincoln","Central Lincoln People's Utility District","10047"]
["Centralia","City of Centralia","10066"]
["Cheney","City of Cheney","10067"]
["Chewelah","City of Chewelah","10068"]
["Clallam","Public Utility District No. 1 of Clallam County","10101"]
["Clark","Clark Public Utilities","10103"]
["Clatskanie","Clatskanie People's Utility District","10105"]
["Clearwater","Clearwater Power Company","10106"]
["Columbia Basin","Columbia Basin Electric Cooperative, Inc.","10109"]
["Columbia Power","Columbia Power Cooperative Association","10111"]
["Columbia REA","Columbia Rural Electric Association","10113"]
["Columbia River","Columbia River People's Utility District","10112"]
["Consolidated","Consolidated Irrigation District No. 19","10116"]
["Consumers","Consumers Power, Inc.","10118"]
["Coos-Curry","Coos-Curry Electric Cooperative, Inc.","10121"]
["Coulee Dam","Town of Coulee Dam","10378"]
["Cowlitz","Public Utility District No. 1 of Cowlitz County","10123"]
["Declo","City of Declo","10070"]
["DOE-RL","US Department of Energy - Richland Operations Office","10426"]
["Douglas Elec","Douglas Electric Cooperative, Inc.","10136"]
["Drain","City of Drain","10071"]
["East End","East End Mutual Electric Company, LTD","10142"]
["Eatonville","Town of Eatonville","10144"]
["Ellensburg","City of Ellensburg","10072"]
["Elmhurst","Elmhurst Mutual Power & Light Company","10156"]
["Emerald","Emerald People's Utility District","10157"]
["Energy Northwest","Energy Northwest","10158"]
["EWEB","Eugene Water & Electric Board","10170"]
["Fairchild","Fairchild Air Force Base","10172"]
["Fall River","Fall River Rural Electric Cooperative, Inc.","10173"]
["Farmers","Farmers Electric Company, LTD","10174"]
["Ferry","Public Utility District No. 1 of Ferry County","10177"]
["Flathead","Flathead Electric Cooperative, Inc.","10179"]
["Forest Grove","City of Forest Grove","10074"]
["Franklin County","Public Utility District No. 1 of Franklin County","10183"]
["Glacier","Glacier Electric Cooperative, Inc.","10186"]
["Grant","Public Utility District No. 2 of Grant County, Washington","10190"]
["Grays Harbor","Public Utility District No. 1 of Grays Harbor County Washington","10191"]
["Harney","Harney Electric Cooperative, Inc.","10197"]
["Hermiston","City of Hermiston","10597"]
["Heyburn","City of Heyburn","10076"]
["Hood River","Hood River Electric Cooperative","10202"]
["Idaho County","Idaho County Light & Power Cooperative Association, Inc.","10203"]
["Idaho Falls Power","City of Idaho Falls","10204"]
["Inland","Inland Power & Light Company","10209"]
["Jefferson","Public Utility District No.1 of Jefferson County","12026"]
["Kittitas","Public Utility District No. 1 of Kittitas County","10230"]
["Klickitat","Public Utility District No. 1 of Klickitat County","10231"]
["Kootenai","Kootenai Electric Cooperative, Inc.","10234"]
["KTU","Kalispel Indian Community of the Kalispel Reservation","13927"]
["Lakeview","Lakeview Light & Power Company","10235"]
["Lane Electric","Lane Electric Cooperative, Inc.","10236"]
["Lewis","Public Utility District No. 1 of Lewis County","10237"]
["Lincoln","Lincoln Electric Cooperative, Inc.","10239"]
["Lost River","Lost River Electric Cooperative, Inc.","10242"]
["Lower Valley","Lower Valley Energy, Inc.","10244"]
["Mason Co 1","Public Utility District No. 1 of Mason County","10246"]
["Mason Co 3","Public Utility District No. 3 of Mason County","10247"]
["McCleary","City of McCleary","10078"]
["McMinnville","The City of McMinnville","10079"]
["Midstate","Midstate Electric Cooperative, Inc.","10256"]
["Milton","City of Milton","10080"]
["Milton-Freewater","City of Milton-Freewater","10081"]
["Minidoka","City of Minidoka","10082"]
["Mission Valley","Mission Valley Power","10258"]
["Missoula","Missoula Electric Cooperative, Inc.","10259"]
["Modern","Modern Electric Water Company","10260"]
["Monmouth","City of Monmouth","10083"]
["Nespelem","Nespelem Valley Electric Cooperative, Inc.","10273"]
["NETL","US DOE Natl Energy Technology Lab","10406"]
["Northern Lights","Northern Lights, Inc.","10278"]
["Northern Wasco","Northern Wasco County People's Utility District","10279"]
["Ohop","Ohop Mutual Light Company","10284"]
["Okanogan Coop","Okanogan County Electric Cooperative, Inc.","10285"]
["Okanogan PUD","Okanogan County Public Utility District No. 1","10286"]
["OPALCO","Orcas Power & Light Cooperative","10288"]
["Oregon Trail","Oregon Trail Electric Consumers Cooperative, Inc.","10291"]
["Pacific","Public Utility District No. 2 of Pacific County","10294"]
["Parkland","Parkland Light & Water Company","10304"]
["Pend Oreille","Pend Oreille County PUD No. 1","10306"]
["Peninsula","Peninsula Light Company","10307"]
["Plummer","City of Plummer","10086"]
["PNGC","Pacific Northwest Generating Cooperative","10298"]
["Port","Port of Seattle - Seattle-Tacoma International Airport","10706"]
["Port Angeles","City of Port Angeles","10087"]
["Raft River","Raft River Rural Electric Cooperative, Inc.","10331"]
["Ravalli County","Ravalli County Electric Cooperative, Inc.","10333"]
["Richland","City of Richland, Washington","10089"]
["Riverside Electric","Riverside Electric Company, LTD","10338"]
["Rupert","City of Rupert","10091"]
["Salem","Salem Electric","10342"]
["Salmon River","Salmon River Electric Cooperative, Inc.","10343"]
["Seattle","City of Seattle, City Light Dept","10349"]
["Skamania","Public Utility District #1 of Skamania County","10352"]
["Snohomish PUD","Public Utility District No. 1 Of Snohomish County","10354"]
["Soda Springs","City of Soda Springs","10094"]
["South Side","South Side Electric, Inc.","10360"]
["Springfield","Springfield Utility Board","10363"]
["Steilacoom","Town of Steilacoom","10379"]
["Sumas","City of Sumas","10095"]
["Surprise Valley","Surprise Valley Electrification Corporation","10369"]
["Tacoma Power","Tacoma Power","10370"]
["Tanner","Tanner Electric Cooperative","10371"]
["Tillamook","Tillamook People's Utility District","10376"]
["Troy","City of Troy","10097"]
["UIUC","Umpqua Indian Utility Cooperative","10482"]
["Umatilla","Umatilla Electric Cooperative","10388"]
["United Electric","United Electric Co-op, Inc.","10391"]
["USBR General","USBR General","10400"]
["USN Bangor","USN Bangor","10409"]
["USN Bremerton","USN Bremerton","10326"]
["USN Everett","USN Everett-Jim Creek","10408"]
["Vera","Vera Water & Power","10434"]
["Vigilante","Vigilante Electric Cooperative, Inc.","10436"]
["Wahkiakum","Public Utility District No. 1 of Wahkiakum County","10440"]
["Wasco","Wasco Electric Cooperative, Inc.","10442"]
["Weiser","City of Weiser","11680"]
["West Oregon","West Oregon Electric Cooperative, Inc.","10448"]
["Whatcom Co 1","Public Utility District No 1 of Whatcom County","10451"]
["WREC","Wells Rural Electric Company","10446"]
["Yakama","Yakama Power","10502"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"These are used for the checkboxes on the customer information tab.  Moving them will screw up the macros…. These cells needs to remain unprotected."]
[]
[]
[null,null,null,null,false]
[null,null,null,null,false]
[null,null,null,null,false]
[null,null,null,null,false]

{"sheet":"Cooling Fan VFD","index":6,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Assumptions:",null,null,null,null,"Baseline"]
[null,null,"Baseline Fan motor hp:",{"$f":"'Savings Calculations'!J32","v":2},"hp"]
[null,null,"Upgrade fan motor hp:",{"$f":"'Savings Calculations'!P32","v":2},"hp",null,null,"run hours:",{"$f":"SUM('Savings Calculations'!E42:F45)","v":0},"hrs"]
[null,null,"Estimated load factor:",0.85,null,null,null,"Power:",{"$f":"D8*0.746*D10/D12","v":1.4930983240695197},"kW"]
[null,null,"Motor Family","efficient"]
[null,null,"Fan motor efficiency:",{"$f":"Local_MotorEfficiency(D9,D11,D10)","v":0.84937473946354236},null,null,null,"energy:",{"$f":"ROUND(I10*I9,0)","v":0},"kWh/yr"]
[null,null,"VFD exponent:",2.7]
[null,null,"VFD efficiency:",0.97,null,null,null,"upgrade power:",{"$f":"D9*0.746*D10/D12","v":1.4930983240695197}]
[null,null,"minimum VFD speed",0.2]
[]
[null,null,"Design temperature:",100,"F","(100 F is standard design temp)"]
[null,null,"Average ambient temperature:",70,"F","(conservative estimate for PNW)"]
[null,null,"normal air discharge temp:",140,"F","(from conversation with Jeff Yarnell of Rodgers')"]
[null,null,"Temperature correction factor:",{"$f":"1-(1-((D19-D17)/(D19-D18)))/4","v":0.89285714285714279},null,"(conservative estimate - takes the average temperature difference from discharge over design temperature difference and discounts by a factor of 4)"]
[]
[null,"UPGRADE"]
[null,"Bin","hrs/yr","load","Fan speed","Fan power (kW)","Fan energy (kWh/yr)"]
[null,1,{"$f":"'Savings Calculations'!E42","v":0},{"$f":"'Savings Calculations'!U42","v":{"$error":"#DIV/0!"}},{"$f":"(D24*$D$20*(1-$D$15) + $D$15)","v":{"$error":"#DIV/0!"}},{"$f":"$I$14*E24^$D$13/$D$14","v":{"$error":"#DIV/0!"}},{"$f":"F24*C24","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"'Savings Calculations'!E43","v":0},{"$f":"'Savings Calculations'!U43","v":{"$error":"#DIV/0!"}},{"$f":"(D25*$D$20*(1-$D$15) + $D$15)","v":{"$error":"#DIV/0!"}},{"$f":"$I$14*E25^$D$13/$D$14","v":{"$error":"#DIV/0!"}},{"$f":"F25*C25","v":{"$error":"#DIV/0!"}}]
[null,3,{"$f":"'Savings Calculations'!E44","v":0},{"$f":"'Savings Calculations'!U44","v":{"$error":"#DIV/0!"}},{"$f":"(D26*$D$20*(1-$D$15) + $D$15)","v":{"$error":"#DIV/0!"}},{"$f":"$I$14*E26^$D$13/$D$14","v":{"$error":"#DIV/0!"}},{"$f":"F26*C26","v":{"$error":"#DIV/0!"}}]
[null,4,{"$f":"'Savings Calculations'!E45","v":0},{"$f":"'Savings Calculations'!U45","v":{"$error":"#DIV/0!"}},{"$f":"(D27*$D$20*(1-$D$15) + $D$15)","v":{"$error":"#DIV/0!"}},{"$f":"$I$14*E27^$D$13/$D$14","v":{"$error":"#DIV/0!"}},{"$f":"F27*C27","v":{"$error":"#DIV/0!"}}]
[null,"sum",{"$f":"SUM(C24:C27)","v":0},null,null,null,{"$f":"ROUND(SUM(G24:G27),0)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,"savings:",{"$f":"I12-G28","v":{"$error":"#DIV/0!"}},"kWh/yr"]
[]
[]
[null,"BASELINE - NOT USED",null,"The question here is does the fan load factor change with the compressor % load?  For baseline I say no, the fan is on and running at the same load regardless of heat load or compressor capacity"]
[null,"Bin","hrs/yr","load",null,"Fan power (kW)","Fan energy (kWh/yr)"]
[null,1,{"$f":"'Savings Calculations'!E42","v":0},{"$f":"'Savings Calculations'!U42","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$8*0.746*D36/$D$12","v":{"$error":"#DIV/0!"}},{"$f":"F36*C36","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"'Savings Calculations'!E43","v":0},{"$f":"'Savings Calculations'!U43","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$8*0.746*D37/$D$12","v":{"$error":"#DIV/0!"}},{"$f":"F37*C37","v":{"$error":"#DIV/0!"}}]
[null,3,{"$f":"'Savings Calculations'!E44","v":0},{"$f":"'Savings Calculations'!U44","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$8*0.746*D38/$D$12","v":{"$error":"#DIV/0!"}},{"$f":"F38*C38","v":{"$error":"#DIV/0!"}}]
[null,4,{"$f":"'Savings Calculations'!E45","v":0},{"$f":"'Savings Calculations'!U45","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$8*0.746*D39/$D$12","v":{"$error":"#DIV/0!"}},{"$f":"F39*C39","v":{"$error":"#DIV/0!"}}]
[null,"sum",{"$f":"SUM(C36:C39)","v":0},null,null,null,{"$f":"SUM(G36:G39)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Weather","index":7,"n_rows":493,"n_cols":6,"rows_kept":493,"cut":false,"hidden":true,"merged":[]}
[null,"Location","Season","Shift","Bin","DB °F"]
[{"$f":"IF(B2=B1,\"\",B2)","v":"OR - Astoria"},"OR - Astoria","winter",1,1,48.875250000000008]
[{"$f":"IF(B3=B2,\"\",B3)","v":""},"OR - Astoria","winter",2,2,45.497999999999962]
["","OR - Astoria","winter",3,3,41.78399999999997]
["","OR - Astoria","spring",1,4,57.168351648351546]
["","OR - Astoria","spring",2,5,52.496263736263735]
["","OR - Astoria","spring",3,6,49.040412087912166]
["","OR - Astoria","summer",1,7,65.062038043478324]
["","OR - Astoria","summer",2,8,59.470054347826142]
["","OR - Astoria","summer",3,9,55.695679347826065]
["","OR - Astoria","fall",1,10,51.243124999999999]
["","OR - Astoria","fall",2,11,47.011902173912993]
["","OR - Astoria","fall",3,12,44.157092391304339]
["OR - Baker City","OR - Baker City","winter",1,1,36.511249999999997]
["","OR - Baker City","winter",2,2,30.551750000000002]
["","OR - Baker City","winter",3,3,25.890499999999978]
["","OR - Baker City","spring",1,4,60.575494505494504]
["","OR - Baker City","spring",2,5,51.094340659340681]
["","OR - Baker City","spring",3,6,43.40304945054941]
["","OR - Baker City","summer",1,7,77.328695652173835]
["","OR - Baker City","summer",2,8,64.359157608695682]
["","OR - Baker City","summer",3,9,52.696086956521796]
["","OR - Baker City","fall",1,10,44.876603260869459]
["","OR - Baker City","fall",2,11,35.547663043478167]
["","OR - Baker City","fall",3,12,30.030027173912977]
["OR - Bend","OR - Bend","winter",1,1,50.401999999999923]
["","OR - Bend","winter",2,2,47.204249999999988]
["","OR - Bend","winter",3,3,43.856000000000037]
["","OR - Bend","spring",1,4,57.887115384615392]
["","OR - Bend","spring",2,5,52.796181318681342]
["","OR - Bend","spring",3,6,49.566071428571433]
["","OR - Bend","summer",1,7,63.546711956521705]
["","OR - Bend","summer",2,8,58.270951086956572]
["","OR - Bend","summer",3,9,54.694429347825988]
["","OR - Bend","fall",1,10,53.514646739130434]
["","OR - Bend","fall",2,11,48.369239130434828]
["","OR - Bend","fall",3,12,45.990108695652175]
["OR - Burns","OR - Burns","winter",1,1,38.219000000000023]
["","OR - Burns","winter",2,2,32.172749999999986]
["","OR - Burns","winter",3,3,26.446000000000044]
["","OR - Burns","spring",1,4,60.445686813186832]
["","OR - Burns","spring",2,5,52.188681318681382]
["","OR - Burns","spring",3,6,42.088159340659324]
["","OR - Burns","summer",1,7,75.171141304347827]
["","OR - Burns","summer",2,8,63.822826086956454]
["","OR - Burns","summer",3,9,51.308668478260891]
["","OR - Burns","fall",1,10,43.486739130434806]
["","OR - Burns","fall",2,11,34.53198369565218]
["","OR - Burns","fall",3,12,29.188967391304342]
["OR - Pendleton","OR - Pendleton","winter",1,1,41.952500000000001]
["","OR - Pendleton","winter",2,2,38.160250000000019]
["","OR - Pendleton","winter",3,3,34.424500000000016]
["","OR - Pendleton","spring",1,4,64.121840659340691]
["","OR - Pendleton","spring",2,5,57.324862637362621]
["","OR - Pendleton","spring",3,6,50.098901098901067]
["","OR - Pendleton","summer",1,7,77.300570652173931]
["","OR - Pendleton","summer",2,8,70.26711956521747]
["","OR - Pendleton","summer",3,9,60.490624999999916]
["","OR - Pendleton","fall",1,10,47.829972826086966]
["","OR - Pendleton","fall",2,11,43.136032608695601]
["","OR - Pendleton","fall",3,12,40.394945652173867]
["OR - Portland","OR - Portland","winter",1,1,47.542499999999997]
["","OR - Portland","winter",2,2,45.166249999999998]
["","OR - Portland","winter",3,3,40.503499999999924]
["","OR - Portland","spring",1,4,62.67021978021976]
["","OR - Portland","spring",2,5,59.02991758241766]
[{"$f":"IF(B67=B66,\"\",B67)","v":""},"OR - Portland","spring",3,6,52.051950549450517]
["","OR - Portland","summer",1,7,71.669701086956479]
["","OR - Portland","summer",2,8,68.551739130434768]
["","OR - Portland","summer",3,9,58.953288043478196]
["","OR - Portland","fall",1,10,50.020543478260862]
["","OR - Portland","fall",2,11,47.345000000000084]
["","OR - Portland","fall",3,12,44.321195652173898]
["OR - Roseburg","OR - Roseburg","winter",1,1,49.729250000000086]
["","OR - Roseburg","winter",2,2,47.833499999999987]
["","OR - Roseburg","winter",3,3,42.506499999999924]
["","OR - Roseburg","spring",1,4,63.800412087911987]
["","OR - Roseburg","spring",2,5,59.86414835164836]
["","OR - Roseburg","spring",3,6,50.092967032967152]
["","OR - Roseburg","summer",1,7,72.780760869565242]
["","OR - Roseburg","summer",2,8,69.095896739130367]
["","OR - Roseburg","summer",3,9,57.696711956521632]
["","OR - Roseburg","fall",1,10,51.88999999999993]
["","OR - Roseburg","fall",2,11,48.600353260869504]
["","OR - Roseburg","fall",3,12,44.729864130434713]
["OR - Medford","OR - Medford","winter",1,1,46.776500000000034]
["","OR - Medford","winter",2,2,43.442749999999982]
["","OR - Medford","winter",3,3,36.181249999999999]
["","OR - Medford","spring",1,4,65.023571428571458]
["","OR - Medford","spring",2,5,59.335027472527457]
["","OR - Medford","spring",3,6,49.037445054945088]
["","OR - Medford","summer",1,7,76.58864130434786]
["","OR - Medford","summer",2,8,71.422201086956548]
["","OR - Medford","summer",3,9,57.956195652173847]
["","OR - Medford","fall",1,10,50.199076086956538]
["","OR - Medford","fall",2,11,46.163260869565171]
["","OR - Medford","fall",3,12,39.70209239130439]
["OR - Klamath Falls","OR - Klamath Falls","winter",1,1,39.655750000000019]
["","OR - Klamath Falls","winter",2,2,34.181000000000012]
["","OR - Klamath Falls","winter",3,3,29.365249999999978]
["","OR - Klamath Falls","spring",1,4,60.494642857142857]
["","OR - Klamath Falls","spring",2,5,52.984587912087903]
["","OR - Klamath Falls","spring",3,6,43.138489010988962]
["","OR - Klamath Falls","summer",1,7,74.197771739130417]
["","OR - Klamath Falls","summer",2,8,65.230298913043484]
["","OR - Klamath Falls","summer",3,9,51.861875000000062]
["","OR - Klamath Falls","fall",1,10,43.460326086956464]
["","OR - Klamath Falls","fall",2,11,36.252010869565204]
["","OR - Klamath Falls","fall",3,12,31.053777173913062]
["OR - Eugene","OR - Eugene","winter",1,1,46.508249999999961]
["","OR - Eugene","winter",2,2,43.048749999999998]
["","OR - Eugene","winter",3,3,39.03]
["","OR - Eugene","spring",1,4,61.903241758241727]
["","OR - Eugene","spring",2,5,56.17736263736262]
["","OR - Eugene","spring",3,6,48.481126373626324]
["","OR - Eugene","summer",1,7,73.659972826086999]
["","OR - Eugene","summer",2,8,66.555842391304239]
["","OR - Eugene","summer",3,9,55.244701086956439]
["","OR - Eugene","fall",1,10,49.544375000000002]
["","OR - Eugene","fall",2,11,45.069809782608651]
["","OR - Eugene","fall",3,12,41.012228260869549]
["OR - Corvallis","OR - Corvallis","winter",1,1,48.730499999999957]
["","OR - Corvallis","winter",2,2,45.942250000000008]
["","OR - Corvallis","winter",3,3,42.47949999999998]
["","OR - Corvallis","spring",1,4,63.948763736263771]
["","OR - Corvallis","spring",2,5,57.309780219780194]
["","OR - Corvallis","spring",3,6,48.62527472527475]
["","OR - Corvallis","summer",1,7,76.776956521739052]
["","OR - Corvallis","summer",2,8,68.130353260869583]
["","OR - Corvallis","summer",3,9,57.212961956521696]
[{"$f":"IF(B131=B130,\"\",B131)","v":""},"OR - Corvallis","fall",1,10,51.347065217391247]
["","OR - Corvallis","fall",2,11,46.587581521739132]
["","OR - Corvallis","fall",3,12,42.94111413043467]
["OR - The Dalles","OR - The Dalles","winter",1,1,45.604249999999979]
["","OR - The Dalles","winter",2,2,42.475000000000001]
["","OR - The Dalles","winter",3,3,37.117749999999987]
["","OR - The Dalles","spring",1,4,67.639505494505471]
["","OR - The Dalles","spring",2,5,61.872829670329679]
["","OR - The Dalles","spring",3,6,53.339890109890163]
["","OR - The Dalles","summer",1,7,78.98097826086962]
["","OR - The Dalles","summer",2,8,73.607146739130371]
["","OR - The Dalles","summer",3,9,63.169592391304356]
["","OR - The Dalles","fall",1,10,49.33038043478259]
["","OR - The Dalles","fall",2,11,44.663831521739091]
["","OR - The Dalles","fall",3,12,40.585951086956534]
["ID - Salmon","ID - Salmon","winter",1,1,32.132249999999971]
["","ID - Salmon","winter",2,2,30.103000000000005]
["","ID - Salmon","winter",3,3,23.518000000000004]
["","ID - Salmon","spring",1,4,60.217472527472538]
["","ID - Salmon","spring",2,5,57.264532967032977]
["","ID - Salmon","spring",3,6,44.631648351648344]
["","ID - Salmon","summer",1,7,73.103097826087065]
["","ID - Salmon","summer",2,8,68.621929347826182]
["","ID - Salmon","summer",3,9,51.394266304347816]
["","ID - Salmon","fall",1,10,38.148858695652166]
["","ID - Salmon","fall",2,11,34.470353260869558]
["","ID - Salmon","fall",3,12,27.85584239130435]
["ID - Pocatello","ID - Pocatello","winter",1,1,34.189250000000015]
["","ID - Pocatello","winter",2,2,30.984500000000004]
["","ID - Pocatello","winter",3,3,25.278499999999969]
["","ID - Pocatello","spring",1,4,63.210961538461468]
["","ID - Pocatello","spring",2,5,57.710576923076928]
["","ID - Pocatello","spring",3,6,46.101318681318681]
["","ID - Pocatello","summer",1,7,76.587663043478173]
["","ID - Pocatello","summer",2,8,69.248016304347814]
["","ID - Pocatello","summer",3,9,54.370869565217284]
["","ID - Pocatello","fall",1,10,40.688668478260844]
["","ID - Pocatello","fall",2,11,35.908396739130467]
["","ID - Pocatello","fall",3,12,30.063288043478284]
["ID - Malad City","ID - Malad City","winter",1,1,38.058250000000001]
["","ID - Malad City","winter",2,2,35.23599999999999]
["","ID - Malad City","winter",3,3,29.182250000000028]
["","ID - Malad City","spring",1,4,63.806840659340565]
["","ID - Malad City","spring",2,5,57.471483516483531]
["","ID - Malad City","spring",3,6,45.058653846153781]
["","ID - Malad City","summer",1,7,78.792663043478271]
["","ID - Malad City","summer",2,8,69.613152173912994]
["","ID - Malad City","summer",3,9,53.831114130434727]
["","ID - Malad City","fall",1,10,42.185163043478227]
["","ID - Malad City","fall",2,11,37.047826086956441]
["","ID - Malad City","fall",3,12,30.394184782608701]
["ID - Lewiston","ID - Lewiston","winter",1,1,40.350749999999941]
["","ID - Lewiston","winter",2,2,37.891249999999999]
["","ID - Lewiston","winter",3,3,33.816500000000048]
["","ID - Lewiston","spring",1,4,64.922939560439573]
["","ID - Lewiston","spring",2,5,59.848571428571432]
["","ID - Lewiston","spring",3,6,50.995439560439564]
["","ID - Lewiston","summer",1,7,79.085652173913061]
["","ID - Lewiston","summer",2,8,74.255733695652211]
["","ID - Lewiston","summer",3,9,62.427092391304335]
["","ID - Lewiston","fall",1,10,44.6564945652174]
["","ID - Lewiston","fall",2,11,41.391059782608629]
["","ID - Lewiston","fall",3,12,38.206086956521816]
["ID - Idaho Falls","ID - Idaho Falls","winter",1,1,27.943750000000001]
[{"$f":"IF(B195=B194,\"\",B195)","v":""},"ID - Idaho Falls","winter",2,2,25.82224999999999]
["","ID - Idaho Falls","winter",3,3,20.75024999999998]
["","ID - Idaho Falls","spring",1,4,61.748214285714212]
["","ID - Idaho Falls","spring",2,5,56.113324175824147]
["","ID - Idaho Falls","spring",3,6,44.278818681318668]
["","ID - Idaho Falls","summer",1,7,73.989157608695663]
["","ID - Idaho Falls","summer",2,8,67.182418478260885]
["","ID - Idaho Falls","summer",3,9,51.037445652173922]
["","ID - Idaho Falls","fall",1,10,40.115407608695591]
["","ID - Idaho Falls","fall",2,11,34.832065217391325]
["","ID - Idaho Falls","fall",3,12,29.203152173913058]
["ID - Boise","ID - Boise","winter",1,1,40.316000000000038]
["","ID - Boise","winter",2,2,37.06299999999996]
["","ID - Boise","winter",3,3,31.3325]
["","ID - Boise","spring",1,4,65.38208791208794]
["","ID - Boise","spring",2,5,62.337417582417665]
["","ID - Boise","spring",3,6,50.995192307692271]
["","ID - Boise","summer",1,7,76.661277173913078]
["","ID - Boise","summer",2,8,73.41907608695648]
["","ID - Boise","summer",3,9,59.76377717391302]
["","ID - Boise","fall",1,10,47.176005434782617]
["","ID - Boise","fall",2,11,42.780190217391301]
["","ID - Boise","fall",3,12,37.830923913043414]
["UT -Wendover","UT -Wendover","winter",1,1,38.622999999999884]
["","UT -Wendover","winter",2,2,33.871749999999906]
["","UT -Wendover","winter",3,3,29.730249999999906]
["","UT -Wendover","spring",1,4,68.545934065934048]
["","UT -Wendover","spring",2,5,63.857280219780208]
["","UT -Wendover","spring",3,6,55.829972527472577]
["","UT -Wendover","summer",1,7,80.652826086956651]
["","UT -Wendover","summer",2,8,74.794021739130315]
["","UT -Wendover","summer",3,9,65.768097826086986]
["","UT -Wendover","fall",1,10,43.114021739130401]
["","UT -Wendover","fall",2,11,37.426413043478185]
["","UT -Wendover","fall",3,12,33.411630434782545]
["UT - Vernal","UT - Vernal","winter",1,1,37.894249999999992]
["","UT - Vernal","winter",2,2,32.554749999999977]
["","UT - Vernal","winter",3,3,25.930250000000019]
["","UT - Vernal","spring",1,4,67.658791208791129]
["","UT - Vernal","spring",2,5,60.318104395604365]
["","UT - Vernal","spring",3,6,48.555549450549513]
["","UT - Vernal","summer",1,7,77.218641304347884]
["","UT - Vernal","summer",2,8,69.129402173913078]
["","UT - Vernal","summer",3,9,57.658559782608663]
["","UT - Vernal","fall",1,10,41.189538043478294]
["","UT - Vernal","fall",2,11,33.547608695652166]
["","UT - Vernal","fall",3,12,26.274239130434779]
["UT - Salt Lake City","UT - Salt Lake City","winter",1,1,41.491500000000059]
["","UT - Salt Lake City","winter",2,2,37.287500000000001]
["","UT - Salt Lake City","winter",3,3,32.922499999999999]
["","UT - Salt Lake City","spring",1,4,66.500906593406611]
["","UT - Salt Lake City","spring",2,5,60.689230769230761]
["","UT - Salt Lake City","spring",3,6,52.51381868131871]
["","UT - Salt Lake City","summer",1,7,82.258396739130447]
["","UT - Salt Lake City","summer",2,8,74.80698369565215]
["","UT - Salt Lake City","summer",3,9,66.01461956521743]
["","UT - Salt Lake City","fall",1,10,46.670244565217374]
["","UT - Salt Lake City","fall",2,11,41.207146739130458]
["","UT - Salt Lake City","fall",3,12,37.102119565217421]
["UT - Saint George","UT - Saint George","winter",1,1,52.769500000000008]
["","UT - Saint George","winter",2,2,52.916999999999916]
["","UT - Saint George","winter",3,3,43.190249999999928]
["","UT - Saint George","spring",1,4,80.812390109890131]
["","UT - Saint George","spring",2,5,79.609258241758297]
[{"$f":"IF(B259=B258,\"\",B259)","v":""},"UT - Saint George","spring",3,6,65.21024725274728]
["","UT - Saint George","summer",1,7,90.302391304347864]
["","UT - Saint George","summer",2,8,88.6628260869565]
["","UT - Saint George","summer",3,9,76.126902173913038]
["","UT - Saint George","fall",1,10,54.456222826086893]
["","UT - Saint George","fall",2,11,53.60855978260853]
["","UT - Saint George","fall",3,12,45.674374999999998]
["UT - Provo","UT - Provo","winter",1,1,39.616499999999988]
["","UT - Provo","winter",2,2,36.905499999999996]
["","UT - Provo","winter",3,3,31.949000000000083]
["","UT - Provo","spring",1,4,66.962280219780197]
["","UT - Provo","spring",2,5,61.745494505494477]
["","UT - Provo","spring",3,6,51.310192307692304]
["","UT - Provo","summer",1,7,79.537608695652182]
["","UT - Provo","summer",2,8,72.140978260869574]
["","UT - Provo","summer",3,9,60.540760869565226]
["","UT - Provo","fall",1,10,43.23679347826085]
["","UT - Provo","fall",2,11,38.927065217391281]
["","UT - Provo","fall",3,12,33.26097826086955]
["UT - Ogden","UT - Ogden","winter",1,1,36.576999999999977]
["","UT - Ogden","winter",2,2,34.74274999999998]
["","UT - Ogden","winter",3,3,30.311250000000001]
["","UT - Ogden","spring",1,4,63.773708791208811]
["","UT - Ogden","spring",2,5,60.16208791208787]
["","UT - Ogden","spring",3,6,51.215741758241734]
["","UT - Ogden","summer",1,7,78.897092391304312]
["","UT - Ogden","summer",2,8,74.171847826086918]
["","UT - Ogden","summer",3,9,63.924809782608662]
["","UT - Ogden","fall",1,10,43.710271739130548]
["","UT - Ogden","fall",2,11,39.945679347826122]
["","UT - Ogden","fall",3,12,36.432499999999997]
["UT - Moab","UT - Moab","winter",1,1,44.87524999999998]
["","UT - Moab","winter",2,2,39.463749999999997]
["","UT - Moab","winter",3,3,31.298499999999997]
["","UT - Moab","spring",1,4,72.82489010989012]
["","UT - Moab","spring",2,5,66.872032967032908]
["","UT - Moab","spring",3,6,56.596950549450575]
["","UT - Moab","summer",1,7,83.455543478260893]
["","UT - Moab","summer",2,8,76.902907608695671]
["","UT - Moab","summer",3,9,65.909945652173889]
["","UT - Moab","fall",1,10,46.999184782608779]
["","UT - Moab","fall",2,11,39.889673913043524]
["","UT - Moab","fall",3,12,33.067527173913078]
["UT - Hanksville","UT - Hanksville","winter",1,1,44.765999999999984]
["","UT - Hanksville","winter",2,2,40.812000000000012]
["","UT - Hanksville","winter",3,3,29.3675]
["","UT - Hanksville","spring",1,4,70.651785714285737]
["","UT - Hanksville","spring",2,5,65.943351648351666]
["","UT - Hanksville","spring",3,6,52.059120879120918]
["","UT - Hanksville","summer",1,7,86.929592391304269]
["","UT - Hanksville","summer",2,8,80.433940217391168]
["","UT - Hanksville","summer",3,9,63.961983695652286]
["","UT - Hanksville","fall",1,10,47.206576086956524]
["","UT - Hanksville","fall",2,11,40.308858695652127]
["","UT - Hanksville","fall",3,12,31.683777173913072]
["UT - Delta","UT - Delta","winter",1,1,43.828499999999977]
["","UT - Delta","winter",2,2,39.493749999999999]
["","UT - Delta","winter",3,3,31.404000000000021]
["","UT - Delta","spring",1,4,63.968791208791224]
["","UT - Delta","spring",2,5,56.910219780219698]
["","UT - Delta","spring",3,6,46.062005494505506]
["","UT - Delta","summer",1,7,80.936032608695655]
["","UT - Delta","summer",2,8,72.836032608695618]
["","UT - Delta","summer",3,9,58.431141304347847]
[{"$f":"IF(B323=B322,\"\",B323)","v":""},"UT - Delta","fall",1,10,45.407065217391334]
["","UT - Delta","fall",2,11,38.43304347826092]
["","UT - Delta","fall",3,12,29.513260869565226]
["WY - Cody","WY - Cody","winter",1,1,36.91075]
["","WY - Cody","winter",2,2,30.956499999999959]
["","WY - Cody","winter",3,3,26.37174999999997]
["","WY - Cody","spring",1,4,58.827912087912118]
["","WY - Cody","spring",2,5,53.494175824175805]
["","WY - Cody","spring",3,6,46.097609890109908]
["","WY - Cody","summer",1,7,73.976684782608629]
["","WY - Cody","summer",2,8,67.188777173913081]
["","WY - Cody","summer",3,9,58.515027173913033]
["","WY - Cody","fall",1,10,41.291032608695588]
["","WY - Cody","fall",2,11,35.269103260869535]
["","WY - Cody","fall",3,12,33.601413043478239]
["WY - Casper","WY - Casper","winter",1,1,32.061250000000001]
["","WY - Casper","winter",2,2,26.828500000000012]
["","WY - Casper","winter",3,3,21.989000000000008]
["","WY - Casper","spring",1,4,60.726318681318695]
["","WY - Casper","spring",2,5,52.939340659340644]
["","WY - Casper","spring",3,6,43.975686813186812]
["","WY - Casper","summer",1,7,77.501358695652229]
["","WY - Casper","summer",2,8,67.355570652173924]
["","WY - Casper","summer",3,9,56.322744565217462]
["","WY - Casper","fall",1,10,42.972418478260877]
["","WY - Casper","fall",2,11,36.127771739130424]
["","WY - Casper","fall",3,12,31.254076086956527]
["WA - Yakima","WA - Yakima","winter",1,1,41.849749999999986]
["","WA - Yakima","winter",2,2,36.206249999999997]
["","WA - Yakima","winter",3,3,30.557500000000001]
["","WA - Yakima","spring",1,4,67.833104395604366]
["","WA - Yakima","spring",2,5,59.607500000000002]
["","WA - Yakima","spring",3,6,49.501785714285731]
["","WA - Yakima","summer",1,7,76.92345108695649]
["","WA - Yakima","summer",2,8,67.145244565217439]
["","WA - Yakima","summer",3,9,55.87788043478254]
["","WA - Yakima","fall",1,10,44.003749999999997]
["","WA - Yakima","fall",2,11,36.836032608695682]
["","WA - Yakima","fall",3,12,32.393505434782618]
["WA - Wenatchee","WA - Wenatchee","winter",1,1,37.484749999999941]
["","WA - Wenatchee","winter",2,2,35.343249999999955]
["","WA - Wenatchee","winter",3,3,31.712749999999929]
["","WA - Wenatchee","spring",1,4,66.677692307692297]
["","WA - Wenatchee","spring",2,5,61.742032967033033]
["","WA - Wenatchee","spring",3,6,52.743763736263652]
["","WA - Wenatchee","summer",1,7,77.687472826086946]
["","WA - Wenatchee","summer",2,8,72.893994565217426]
["","WA - Wenatchee","summer",3,9,62.928940217391279]
["","WA - Wenatchee","fall",1,10,42.364429347825968]
["","WA - Wenatchee","fall",2,11,38.974755434782594]
["","WA - Wenatchee","fall",3,12,36.104538043478158]
["WA - Walla Walla","WA - Walla Walla","winter",1,1,45.070499999999988]
["","WA - Walla Walla","winter",2,2,41.298999999999971]
["","WA - Walla Walla","winter",3,3,37.330249999999978]
["","WA - Walla Walla","spring",1,4,64.456126373626375]
["","WA - Walla Walla","spring",2,5,58.962664835164851]
["","WA - Walla Walla","spring",3,6,51.715934065934078]
["","WA - Walla Walla","summer",1,7,78.664755434782677]
["","WA - Walla Walla","summer",2,8,73.171086956521762]
["","WA - Walla Walla","summer",3,9,64.208260869565208]
["","WA - Walla Walla","fall",1,10,47.018505434782675]
["","WA - Walla Walla","fall",2,11,42.783858695652242]
["","WA - Walla Walla","fall",3,12,40.282201086956576]
["WA - Tacoma","WA - Tacoma","winter",1,1,43.966249999999945]
[{"$f":"IF(B387=B386,\"\",B387)","v":""},"WA - Tacoma","winter",2,2,40.113999999999947]
["","WA - Tacoma","winter",3,3,35.278499999999923]
["","WA - Tacoma","spring",1,4,58.614038461538378]
["","WA - Tacoma","spring",2,5,53.617802197802121]
["","WA - Tacoma","spring",3,6,45.916373626373549]
["","WA - Tacoma","summer",1,7,70.69070652173906]
["","WA - Tacoma","summer",2,8,65.139809782608651]
["","WA - Tacoma","summer",3,9,56.011657608695579]
["","WA - Tacoma","fall",1,10,47.625271739130355]
["","WA - Tacoma","fall",2,11,42.26097826086955]
["","WA - Tacoma","fall",3,12,38.200461956521728]
["WA - Spokane","WA - Spokane","winter",1,1,36.292000000000037]
["","WA - Spokane","winter",2,2,32.831249999999997]
["","WA - Spokane","winter",3,3,29.006750000000007]
["","WA - Spokane","spring",1,4,61.334560439560434]
["","WA - Spokane","spring",2,5,55.923928571428576]
["","WA - Spokane","spring",3,6,47.045329670329721]
["","WA - Spokane","summer",1,7,73.834836956521698]
["","WA - Spokane","summer",2,8,66.932961956521623]
["","WA - Spokane","summer",3,9,56.72138586956531]
["","WA - Spokane","fall",1,10,40.715326086956509]
["","WA - Spokane","fall",2,11,36.970543478260886]
["","WA - Spokane","fall",3,12,33.591385869565237]
["WA - Snohomish","WA - Snohomish","winter",1,1,45.873499999999964]
["","WA - Snohomish","winter",2,2,43.851999999999961]
["","WA - Snohomish","winter",3,3,41.208500000000001]
["","WA - Snohomish","spring",1,4,56.029258241758235]
["","WA - Snohomish","spring",2,5,53.00881868131863]
["","WA - Snohomish","spring",3,6,48.239313186813192]
["","WA - Snohomish","summer",1,7,65.361630434782626]
["","WA - Snohomish","summer",2,8,61.48820652173918]
["","WA - Snohomish","summer",3,9,56.374103260869553]
["","WA - Snohomish","fall",1,10,48.154266304347829]
["","WA - Snohomish","fall",2,11,45.797391304347869]
["","WA - Snohomish","fall",3,12,43.986385869565211]
["WA - Seattle","WA - Seattle","winter",1,1,47.240750000000084]
["","WA - Seattle","winter",2,2,45.286000000000037]
["","WA - Seattle","winter",3,3,41.690999999999946]
["","WA - Seattle","spring",1,4,59.644340659340635]
["","WA - Seattle","spring",2,5,56.862252747252761]
["","WA - Seattle","spring",3,6,51.713956043955889]
["","WA - Seattle","summer",1,7,68.54293478260864]
["","WA - Seattle","summer",2,8,65.966929347826124]
["","WA - Seattle","summer",3,9,58.435298913043482]
["","WA - Seattle","fall",1,10,50.404266304347786]
["","WA - Seattle","fall",2,11,48.320326086956463]
["","WA - Seattle","fall",3,12,45.34519021739132]
["WA - Quillayute","WA - Quillayute","winter",1,1,45.542499999999997]
["","WA - Quillayute","winter",2,2,41.75174999999998]
["","WA - Quillayute","winter",3,3,39.168500000000066]
["","WA - Quillayute","spring",1,4,56.611785714285688]
["","WA - Quillayute","spring",2,5,51.201401098901094]
["","WA - Quillayute","spring",3,6,46.970412087912074]
["","WA - Quillayute","summer",1,7,63.741385869565242]
["","WA - Quillayute","summer",2,8,57.654402173912942]
["","WA - Quillayute","summer",3,9,53.663097826086918]
["","WA - Quillayute","fall",1,10,48.667853260869528]
["","WA - Quillayute","fall",2,11,44.631793478260896]
["","WA - Quillayute","fall",3,12,42.008097826086967]
["WA - Pasco","WA - Pasco","winter",1,1,45.555750000000053]
["","WA - Pasco","winter",2,2,39.974249999999977]
["","WA - Pasco","winter",3,3,33.958500000000058]
["","WA - Pasco","spring",1,4,71.340879120879123]
["","WA - Pasco","spring",2,5,63.24953296703292]
[{"$f":"IF(B451=B450,\"\",B451)","v":""},"WA - Pasco","spring",3,6,52.712115384615359]
["","WA - Pasco","summer",1,7,80.683641304347915]
["","WA - Pasco","summer",2,8,71.183505434782717]
["","WA - Pasco","summer",3,9,57.519891304347873]
["","WA - Pasco","fall",1,10,47.841467391304221]
["","WA - Pasco","fall",2,11,42.444157608695662]
["","WA - Pasco","fall",3,12,38.725298913043488]
["WA - Moses Lake","WA - Moses Lake","winter",1,1,42.719500000000039]
["","WA - Moses Lake","winter",2,2,38.150249999999971]
["","WA - Moses Lake","winter",3,3,32.585250000000002]
["","WA - Moses Lake","spring",1,4,68.779340659340647]
["","WA - Moses Lake","spring",2,5,61.528406593406636]
["","WA - Moses Lake","spring",3,6,50.584010989010942]
["","WA - Moses Lake","summer",1,7,78.796086956521691]
["","WA - Moses Lake","summer",2,8,71.712744565217292]
["","WA - Moses Lake","summer",3,9,59.092201086956493]
["","WA - Moses Lake","fall",1,10,45.022119565217437]
["","WA - Moses Lake","fall",2,11,40.039103260869609]
["","WA - Moses Lake","fall",3,12,35.891032608695681]
["WA - Kelso","WA - Kelso","winter",1,1,47.638000000000012]
["","WA - Kelso","winter",2,2,44.681749999999987]
["","WA - Kelso","winter",3,3,40.518999999999942]
["","WA - Kelso","spring",1,4,60.472637362637357]
["","WA - Kelso","spring",2,5,55.368846153846107]
["","WA - Kelso","spring",3,6,49.878846153846126]
["","WA - Kelso","summer",1,7,70.292554347826055]
["","WA - Kelso","summer",2,8,64.387038043478157]
["","WA - Kelso","summer",3,9,55.060298913043397]
["","WA - Kelso","fall",1,10,48.730951086956487]
["","WA - Kelso","fall",2,11,45.257146739130341]
["","WA - Kelso","fall",3,12,43.045788043478176]
["WA - Bellingham","WA - Bellingham","winter",1,1,42.309749999999994]
["","WA - Bellingham","winter",2,2,39.207250000000002]
["","WA - Bellingham","winter",3,3,36.222500000000053]
["","WA - Bellingham","spring",1,4,58.385329670329625]
["","WA - Bellingham","spring",2,5,53.971868131868177]
["","WA - Bellingham","spring",3,6,48.693269230769197]
["","WA - Bellingham","summer",1,7,64.892309782608677]
["","WA - Bellingham","summer",2,8,60.295461956521777]
["","WA - Bellingham","summer",3,9,54.881277173912977]
["","WA - Bellingham","fall",1,10,46.019211956521715]
["","WA - Bellingham","fall",2,11,43.250733695652194]
["","WA - Bellingham","fall",3,12,41.608967391304255]

{"sheet":"Correction Factors","index":8,"n_rows":89,"n_cols":22,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Correction factors for compressed air refrigerated dryers"]
[]
[null,null,null,"CORRECTION FACTOR FOR DRYER INLET AIR TEMPERATURE",null,null,null,null,null,null,"CORRECTION FACTOR FOR INLET AIR PRESSURE",null,null,null,null,null,null,"CORRECTION FACTOR FOR AMBIENT AIR TEMPERATURE"]
[]
[null,null,null,"Inlet air","Correction",null,null,null,null,null,"Inlet air","Correction",null,null,null,null,null,"Ambient","Correction"]
[null,null,null,"temp","factor",null,null,null,null,null,"pressure","factor",null,null,null,null,null,"temp","factor"]
[null,null,null,80,{"$f":"AVERAGE(F26,E37,E65)","v":1.5931147540983606},null,{"$f":"D7","v":80},{"$f":"G7^2","v":6400},{"$f":"G7^3","v":512000},null,50,{"$f":"AVERAGE(M26,L65)","v":0.78759689922480614},null,{"$f":"K7","v":50},{"$f":"N7^2","v":2500},{"$f":"N7^3","v":125000},null,80,{"$f":"AVERAGE(T26,S37,T49)","v":1.2066666666666668}]
[null,"averaged",null,90,{"$f":"AVERAGE(F27,E38,E66)","v":1.2519409282700422},null,{"$f":"D8","v":90},{"$f":"G8^2","v":8100},{"$f":"G8^3","v":729000},null,75,{"$f":"AVERAGE(M27,M37,L66)","v":0.90636363636363637},null,{"$f":"K8","v":75},{"$f":"N8^2","v":5625},{"$f":"N8^3","v":421875},null,90,{"$f":"AVERAGE(T27,S38,T50)","v":1.1011985018726593}]
[null,null,null,100,{"$f":"AVERAGE(F28,E39,E67)","v":1},null,{"$f":"D9","v":100},{"$f":"G9^2","v":10000},{"$f":"G9^3","v":1000000},null,100,{"$f":"AVERAGE(L28,N38,M67)","v":1},null,100,10000,1000000,null,100,{"$f":"AVERAGE(T28,S39,T51)","v":1}]
[null,null,null,110,{"$f":"AVERAGE(F29,E40,E68)","v":0.81766937669376694},null,{"$f":"D10","v":110},{"$f":"G10^2","v":12100},{"$f":"G10^3","v":1331000},null,125,{"$f":"AVERAGE(M29,M39,L68)","v":1.0875968992248064},null,125,15625,1953125,null,110,{"$f":"AVERAGE(T29,S40,T52)","v":0.88735632183908042}]
[null,null,null,120,{"$f":"AVERAGE(F30,E41,E69)","v":0.67075055187637966},null,{"$f":"D11","v":120},{"$f":"G11^2","v":14400},{"$f":"G11^3","v":1728000},null,150,{"$f":"AVERAGE(M30,M40,L69)","v":1.1586075949367087},null,150,22500,3375000,null,120,{"$f":"AVERAGE(T30,S41,T53)","v":0.76961538461538459}]
[null,null,null,null,null,null,null,null,null,null,225,{"$f":"AVERAGE(M41,L70)","v":1.22},null,225,50625,11390625]
[null,null,null,"SLOPE",{"$f":"SLOPE(E7:E11,D7:D11)","v":-2.2789999560202372E-2},"inlet_temp_slope",null,null,null,null,250,{"$f":"M30","v":1.2658227848101264},null,250,62500,15625000,null,"SLOPE",{"$f":"SLOPE(S7:S11,R7:R11)","v":-1.0879447441361432E-2},"ambient_slope"]
[null,null,null,"INTERCEPT:",{"$f":"INTERCEPT(E7:E11,D7:D11)","v":3.3456950782079473},"inlet_temp_intercept",null,null,null,null,null,null,null,null,null,null,null,"INTERCEPT:",{"$f":"INTERCEPT(S7:S11,R7:R11)","v":2.0809121191349016},"ambient_intercept"]
[null,null,null,"a0",{"$f":"INDEX(LINEST($E$7:$E$11,$G$7:$I$11),4)","v":10.885135702196909},null,null,null,null,null,"a0",{"$f":"INDEX(LINEST($L$7:$L$13,$N$7:$P$13),4)","v":0.42193368380486151}]
[null,null,null,"a1",{"$f":"INDEX(LINEST($E$7:$E$11,$G$7:$I$11),3)","v":-0.22126357423429127},null,null,null,null,null,"a1",{"$f":"INDEX(LINEST($L$7:$L$13,$N$7:$P$13),3)","v":8.7610721884601329E-3}]
[null,null,null,"a2",{"$f":"INDEX(LINEST($E$7:$E$11,$G$7:$I$11),2)","v":1.6727562674398405E-3},null,null,null,null,null,"a2",{"$f":"INDEX(LINEST($L$7:$L$13,$N$7:$P$13),2)","v":-3.3423018576220113E-5}]
[null,null,null,"a3",{"$f":"INDEX(LINEST($E$7:$E$11,$G$7:$I$11),1)","v":-4.4850915891192872E-6},null,null,null,null,null,"a3",{"$f":"INDEX(LINEST($L$7:$L$13,$N$7:$P$13),1)","v":4.6957836142729886E-8}]
[]
[]
[]
[null,null,null,"CORRECTION FACTOR FOR DRYER INLET AIR TEMPERATURE",null,null,null,null,null,null,"CORRECTION FACTOR FOR INLET AIR PRESSURE",null,null,null,null,null,null,"CORRECTION FACTOR FOR AMBIENT AIR TEMPERATURE"]
[]
[null,null,null,"Inlet air","Correction",null,null,null,null,null,"Inlet air","Correction",null,null,null,null,null,"Ambient","Correction"]
[null,null,null,"temp","factor","inverse",null,null,null,null,"pressure","factor","inverse",null,null,null,null,"temp","factor","inverse"]
[null,"Zeks",null,80,0.61,{"$f":"1/E26","v":1.639344262295082},{"$f":"SLOPE(E26:E30,D26:D30)","v":2.2400000000000003E-2},"= slope",null,null,50,1.29,{"$f":"1/L26","v":0.77519379844961234},{"$f":"SLOPE(L26:L30,K26:K30)","v":-2.2599999999999999E-3},"= slope",null,null,80,0.8,{"$f":"1/S26","v":1.25},{"$f":"SLOPE(S26:S30,R26:R30)","v":1.2699999999999999E-2},"= slope"]
[null,"Cycling",null,90,0.79,{"$f":"1/E27","v":1.2658227848101264},{"$f":"INTERCEPT(E26:E30,D26:D30)","v":-1.2120000000000002},"= intercept",null,null,75,1.1000000000000001,{"$f":"1/L27","v":0.90909090909090906},{"$f":"INTERCEPT(L26:L30,K26:K30)","v":1.2905},"= intercept",null,null,90,0.89,{"$f":"1/S27","v":1.1235955056179776},{"$f":"INTERCEPT(S26:S30,R26:R30)","v":-0.24000000000000021},"= intercept"]
[null,"and non-cycling",null,100,1,{"$f":"1/E28","v":1},null,null,null,null,100,1,{"$f":"1/L28","v":1},null,null,null,null,100,1,{"$f":"1/S28","v":1}]
[null,null,null,110,1.23,{"$f":"1/E29","v":0.81300813008130079},null,null,null,null,150,0.86,{"$f":"1/L29","v":1.1627906976744187},null,null,null,null,110,1.1599999999999999,{"$f":"1/S29","v":0.86206896551724144}]
[null,null,null,120,1.51,{"$f":"1/E30","v":0.66225165562913912},null,null,null,null,250,0.79,{"$f":"1/L30","v":1.2658227848101264},null,null,null,null,120,1.3,{"$f":"1/S30","v":0.76923076923076916}]
[]
[]
[null,null,null,"CORRECTION FACTOR FOR DRYER INLET AIR TEMPERATURE",null,null,null,null,null,null,"CORRECTION FACTOR FOR INLET AIR PRESSURE",null,null,null,null,null,null,"CORRECTION FACTOR FOR AMBIENT AIR TEMPERATURE"]
[]
[null,null,null,"Inlet air","Correction","Inverse",null,null,null,null,null,"Inlet air","Correction","Inverse",null,null,null,"Ambient","Correction","Inverse"]
[null,null,null,"temp","factor","(multiply by)",null,null,null,null,null,"pressure","factor","(multiply by)",null,null,null,"temp","factor","(multiply by)"]
[null,"Ingersoll:",null,80,1.64,{"$f":"1/E37","v":0.6097560975609756},null,null,null,null,null,75,0.91,{"$f":"1/M37","v":1.0989010989010988},null,null,null,80,1.25,{"$f":"1/S37","v":0.8}]
[null,"Cycling",null,90,1.27,{"$f":"1/E38","v":0.78740157480314954},null,null,null,null,null,100,1,{"$f":"1/M38","v":1},null,null,null,90,1.1200000000000001,{"$f":"1/S38","v":0.89285714285714279}]
[null,null,null,100,1,{"$f":"1/E39","v":1},null,null,null,null,null,125,1.08,{"$f":"1/M39","v":0.92592592592592582},null,null,null,100,1,{"$f":"1/S39","v":1}]
[null,null,null,110,0.81,{"$f":"1/E40","v":1.2345679012345678},null,null,null,null,null,150,1.1599999999999999,{"$f":"1/M40","v":0.86206896551724144},null,null,null,110,0.86,{"$f":"1/S40","v":1.1627906976744187}]
[null,null,null,120,0.66,{"$f":"1/E41","v":1.5151515151515151},null,null,null,null,null,225,1.22,{"$f":"1/M41","v":0.81967213114754101},null,null,null,120,0.77,{"$f":"1/S41","v":1.2987012987012987}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"inversed for multiplication"]
[null,null,null,null,null,"Inlet temp","(°F)",null,null,null,null,null,null,"Inlet temp","(°F)",null,null,null,"Ambient","Correction","Inverse"]
[null,null,null,"Inlet pressure",null,null,null,null,null,null,null,"Inlet pressure",null,null,null,null,null,null,"temp","factor","(multiply by)"]
[null,null,null,"(psig)",80,90,100,110,120,null,null,"(psig)",80,90,100,110,120,null,80,1.1200000000000001,{"$f":"1/T49","v":0.89285714285714279}]
[null,null,null,50,1.35,1.05,0.84,0.69,0.56000000000000005,null,null,50,{"$f":"1/E50","v":0.7407407407407407},0.95238095238095233,1.1904761904761905,1.4492753623188408,1.7857142857142856,null,90,1.06,{"$f":"1/T50","v":0.94339622641509424}]
[null,null,null,80,1.5,1.17,0.95,0.79,0.66,null,null,80,0.66666666666666663,0.85470085470085477,1.0526315789473684,1.2658227848101264,1.5151515151515151,null,100,1,{"$f":"1/T51","v":1}]
[null,"Hankinson",null,100,1.55,1.23,1,0.82,0.7,null,null,100,0.64516129032258063,0.81300813008130079,1,1.2195121951219512,1.4285714285714286,null,110,0.94,{"$f":"1/T52","v":1.0638297872340425}]
[null,"Cycling",null,125,1.63,1.31,1.07,0.91,0.74,null,null,125,0.61349693251533743,0.76335877862595414,0.93457943925233644,1.0989010989010988,1.3513513513513513]
[null,null,null,150,1.7,1.37,1.1299999999999999,0.95,0.8,null,null,150,0.58823529411764708,0.72992700729927007,0.88495575221238942,1.0526315789473684,1.25]
[null,null,null,175,null,1.42,1.18,0.99,0.84,null,null,175,null,0.70422535211267612,0.84745762711864414,1.0101010101010102,1.1904761904761905]
[null,null,null,200,null,1.47,1.22,1.03,0.89,null,null,200,null,0.68027210884353739,0.81967213114754101,0.970873786407767,1.1235955056179776]
[null,null,null,250,null,1.49,1.24,1.05,0.91,null,null,250,null,0.67114093959731547,0.80645161290322587,0.95238095238095233,1.0989010989010988]
[]
[]
[]
[null,null,null,"CORRECTION FACTOR FOR DRYER INLET AIR TEMPERATURE",null,null,null,null,null,null,"CORRECTION FACTOR FOR INLET AIR PRESSURE",null,null,null,null,null,null,"CORRECTION FACTOR FOR AMBIENT AIR TEMPERATURE"]
[]
[null,null,null,"Inlet air","Correction","Inverse",null,null,null,null,"Inlet air","Correction","Inverse",null,null,null,null,"Ambient","Correction","Inverse"]
[null,null,null,"temp","factor","(multiply by)",null,null,null,null,"pressure","factor","(multiply by)",null,null,null,null,"temp","factor","(multiply by)"]
[null,"Airtek",null,80,1.5,{"$f":"1/E65","v":0.66666666666666663},null,null,null,null,50,0.8,{"$f":"1/L65","v":1.25}]
[null,"E-series non-cycling",null,90,1.22,{"$f":"1/E66","v":0.81967213114754101},null,null,null,null,75,0.9,{"$f":"1/L66","v":1.1111111111111112},null,null,null,null,90,1.05,{"$f":"1/S66","v":0.95238095238095233}]
[null,null,null,100,1,{"$f":"1/E67","v":1},null,null,null,null,100,1,{"$f":"1/L67","v":1},null,null,null,null,100,1,{"$f":"1/S67","v":1}]
[null,null,null,110,0.83,{"$f":"1/E68","v":1.2048192771084338},null,null,null,null,125,1.02,{"$f":"1/L68","v":0.98039215686274506},null,null,null,null,110,0.9,{"$f":"1/S68","v":1.1111111111111112}]
[null,null,null,120,0.69,{"$f":"1/E69","v":1.4492753623188408},null,null,null,null,150,1.05,{"$f":"1/L69","v":0.95238095238095233}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"CORRECTION FACTOR FOR INLET AIR PRESSURE"]
[]
[null,"Airtek",null,null,null,null,null,null,null,null,"Inlet air","Correction","Inverse",null,null,null,null,null,"same"]
[null,"Cycling",null,null,"same",null,null,null,null,null,"pressure","factor","(multiply by)"]
[null,null,null,null,null,null,null,null,null,null,50,0.8,{"$f":"1/L77","v":1.25}]
[null,null,null,null,null,null,null,null,null,null,75,0.9,{"$f":"1/L78","v":1.1111111111111112}]
[null,null,null,null,null,null,null,null,null,null,100,1,{"$f":"1/L79","v":1}]
[null,null,null,null,null,null,null,null,null,null,125,1.1200000000000001,{"$f":"1/L80","v":0.89285714285714279}]
[null,null,null,null,null,null,null,null,null,null,150,1.1499999999999999,{"$f":"1/L81","v":0.86956521739130443}]
[]
[]
[]
[]
[null,"Elevation, feet",null,null,null,4300]
[null,"Atmospheric Pressure, psia",null,null,null,{"$f":"local_Patm(F86)","v":12.550196545265999}]
[null,"CAGI Std Atmospheric Pressure, psia",null,null,null,14.5]
[null,"scfm per acfm",null,null,null,{"$f":"F87/F88","v":0.86553079622524132}]

{"sheet":"Operating Power","index":9,"n_rows":146,"n_cols":38,"rows_kept":146,"cut":false,"hidden":true,"merged":[]}
[null,"Operating Power: Cycling and Non-Cycling"]
[]
[]
[null,"Cycling"]
[null,"Air cooled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Cooled"]
[null,"Nominal","operating",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal","operating",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ingersoll-Rand data"]
[null,"capacity,","kW",null,null,null,null,null,null,null,null,null,null,null,null,null,"capacity,","kW",null,null,null,null,null,null,"Non-cycling Dryer Part Load Performance",null,null,null,null,null,null,"model","full flow","10% flow","full power","10% power","%power at 10% flow"]
[null,"scfm @ 38F","air cool",null,null,"sorted","averaged",null,null,null,null,null,null,null,null,null,"scfm @ 38F","water cool",null,null,"sorted","averaged",null,null,null,null,null,null,null,null,null,"D340IN",200,20,1.7,1.6,{"$f":"AJ8/AI8","v":0.94117647058823539}]
[null,75,0.78,"Zek",null,20,0.26,null,null,null,null,null,null,null,null,null,0,0,"Hankinson",null,100,1,null,null,"% load","% rated power",null,null,null,null,null,"D420IN",250,25,1.8,1.7,{"$f":"AJ9/AI9","v":0.94444444444444442}]
[null,80,0.71,"Sullivan",null,75,0.78,null,null,null,null,null,null,null,null,null,200,1.06,"Zek",null,200,1.06,null,null,1,1,null,null,null,null,null,"D510IN",300,30,2.2000000000000002,2.1,0.95454545454545447]
[null,100,0.97,"Airtek",null,80,0.71,null,null,null,null,null,null,null,null,null,200,1.06,"Ingersoll-Rand",null,250,1.39,null,null,0,{"$f":"AVERAGE(AK15,AK65)","v":0.94515615701401501},null,null,null,null,null,"D680IN",400,40,3.5,3.3,0.94285714285714284]
[null,100,0.93,"Sullivan",null,100,0.95333333333333325,null,null,null,null,null,null,null,null,null,250,1.39,"Zek",null,300,1.65,null,null,null,null,null,null,null,null,null,"D850IN",500,50,3.6,3.4,0.94444444444444442]
[null,100,0.96,"Zek",null,125,1.17,null,null,null,null,null,null,null,null,null,300,1.65,"Zek",null,400,2.19,null,null,{"$f":"SLOPE(Z10:Z11,Y10:Y11)","v":5.4843842985984992E-2},"= slope",null,null,null,null,null,"D1020IN",600,60,4.5,4.2,0.93333333333333335]
[null,125,1.1299999999999999,"Airtek",null,150,1.29,null,null,null,null,null,null,null,null,null,300,1.65,"Ingersoll-Rand",null,500,2.8,null,null,{"$f":"INTERCEPT(Z10:Z11,Y10:Y11)","v":0.94515615701401501},"= intercept",null,null,null,null,null,"D1700",981,131,6.4,5.0999999999999996,0.79687499999999989,"not actually at 10%"]
[null,125,1.03,"Sullivan",null,165,1.27,null,null,null,null,null,null,null,null,null,400,2.19,"Zek",null,600,3.14,null,null,null,null,null,null,null,null,null,"cycling",null,null,null,null,{"$f":"AVERAGE(AK8:AK13)","v":0.94346688170217596}]
[null,125,1.35,"Zek",null,180,1.28,null,null,null,null,null,null,null,null,null,400,2.19,"Ingersoll-Rand",null,700,3.58,null,null,"Assumes non-cycling dryer uses 90% of rated power at 0% load,",null,null,null,null,null,null,"NVC200",200,20,1.7,0.31,0.18235294117647058]
[null,150,1.29,"Zek",null,200,1.66,null,null,null,null,null,null,null,null,null,500,2.8,"Zek",null,800,4.16,null,null,"100% rated power at 100% rated load, with straight line between.",null,null,null,null,null,null,"NVC300",300,30,2.5,0.39,0.156]
[null,165,1.27,"Airtek",null,220,1.9,null,null,null,null,null,null,null,null,null,500,2.8,"Ingersoll-Rand",null,1000,5.69,null,null,null,null,null,null,null,null,null,"NVC400",400,40,3.2,0.46,0.14374999999999999]
[null,180,1.28,"Sullivan",null,250,1.9123333333333334,null,null,null,null,null,null,null,null,null,600,3.14,"Zek",null,1200,6.74,null,null,null,null,null,null,null,null,null,"NVC500",500,50,4.5,0.59,0.13111111111111109]
[null,200,1.66,"Ingersoll-Rand",null,300,2.54,null,null,null,null,null,null,null,null,null,600,3.14,"Ingersoll-Rand",null,1600,7.87,null,null,null,null,null,null,null,null,null,"NVC600",600,60,4.8,0.62,0.12916666666666668]
[null,200,1.66,"Zek",null,325,2.3130000000000002,null,null,null,null,null,null,null,null,null,700,3.58,"Zek",null,2000,10.045,null,null,"Cycling Dryer Part Load Performance",null,null,null,null,null,null,"NVC700",700,70,5.8,0.75,0.12931034482758622]
[null,220,1.9,"Airtek",null,400,3.0266666666666668,null,null,null,null,null,null,null,null,null,700,3.58,"Ingersoll-Rand",null,2400,11.295,null,null,"under 300 scfm",null,null,"over 300 scfm",null,null,null,"NVC800",800,80,6.5,0.82,0.12615384615384614]
[null,250,2,"Airtek",null,500,4.3899999999999997,null,null,null,null,null,null,null,null,null,800,4.16,"Zek",null,4000,13.53,null,null,"% load","% rated power",null,"%load","%rated power",null,null,null,null,null,null,null,{"$f":"AVERAGE(AK16:AK22)","v":0.14254927284795438}]
[null,250,1.7270000000000001,"Sullivan",null,570,3.78,null,null,null,null,null,null,null,null,null,800,4.16,"Ingersoll-Rand",null,5000,14.2,null,null,1,1,null,1,1]
[null,250,2.0099999999999998,"Zek",null,600,4.82,null,null,null,null,null,null,null,null,null,1000,6.9,"Zek",null,6000,21.045000000000002,null,null,0.1,0.19,null,0.1,0.17]
[null,300,2.54,"Ingersoll-Rand",null,650,4.0999999999999996,null,null,null,null,null,null,null,null,null,1000,4.4800000000000004,"Ingersoll-Rand",null,8000,27.46,null,null,0,{"$f":"Y28","v":9.9999999999999922E-2},null,0,{"$f":"AB28","v":7.7777777777777724E-2}]
[null,300,2.54,"Zek",null,700,5.79,null,null,null,null,null,null,null,null,null,1200,8,"Zek",null,10000,33.5,null,null,{"$f":"SLOPE(Z24:Z25,Y24:Y25)","v":0.9},"= slope",null,{"$f":"SLOPE(AC24:AC25,AB24:AB25)","v":0.92222222222222217},"= slope",null,null,"Airtek Data"]
[null,325,2.3130000000000002,"Sullivan",null,800,5.6812500000000004,null,null,null,null,null,null,null,null,null,1200,5.48,"Ingersoll-Rand",null,12000,41.5,null,null,{"$f":"INTERCEPT(Z24:Z25,Y24:Y25)","v":9.9999999999999922E-2},"= intercept",null,{"$f":"INTERCEPT(AC24:AC25,AB24:AB25)","v":7.7777777777777724E-2},"= intercept",null,null,"model","full flow","10% flow","full power","10% power","%power at 10% flow"]
[null,400,2.6,"Airtek",null,1000,7.165,null,null,null,null,null,null,null,null,null,1600,8.4,"Zek",null,15000,48.8,null,null,null,null,null,null,null,null,null,"SCP220",210,21,1.8,0.4,{"$f":"AJ29/AI29","v":0.22222222222222224}]
[null,400,3.24,"Ingersoll-Rand",null,1200,8.6366666666666667,null,null,null,null,null,null,null,null,null,1600,7.34,"Ingersoll-Rand",null,null,null,null,null,"Assumes cycling dryer uses 20% of rated power at 0% load,",null,null,null,null,null,null,"SCP250",250,25,2,0.45,0.22500000000000001]
[null,400,3.24,"Zek",null,1350,9.6,null,null,null,null,null,null,null,null,null,2000,11,"Zek",null,null,null,null,null,"100% rated power at 100% rated load, with straight line between.",null,null,null,null,null,null,"SCP330",310,31.5,2.2999999999999998,0.5,0.21739130434782611]
[null,500,4,"Airtek",null,1600,12.29,null,null,null,null,null,null,null,null,null,2000,9.09,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,"SCP400",400,40,2.5,0.55000000000000004,0.22000000000000003]
[null,500,4.6500000000000004,"Ingersoll-Rand",null,1800,12.18,null,null,null,null,null,null,null,null,null,2400,13,"Zek",null,null,null,null,null,null,null,null,null,null,null,null,"SCP500",500,50,4,1.2,0.3]
[null,500,4.5199999999999996,"Zek",null,2000,12.96,null,null,null,null,null,null,null,null,null,2400,9.59,"Ingersoll-Rand",null,null,null,null,null,null,"choice:",null,null,null,null,null,"SCP800",820,82,5.0999999999999996,1.53,0.30000000000000004]
[null,570,3.78,"Sullivan",null,2400,15.045,null,null,null,null,null,null,null,null,null,4000,15.26,"Ingersoll-Rand",null,null,null,null,null,null,"% load","% rated power",null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AK29:AK34)","v":0.24743558776167474}]
[null,600,4.82,"Ingersoll-Rand",null,2500,14.79,null,null,null,null,null,null,null,null,null,4000,11.8,"Hankinson",null,null,null,null,null,null,{"$f":"IF(BaselineRating<=300,'Operating Power'!Y24,'Operating Power'!AB24)","v":1},{"$f":"IF(BaselineRating<=300,'Operating Power'!Z24,'Operating Power'!AC24)","v":1}]
[null,600,4.82,"Zek",null,3000,15.5,null,null,null,null,null,null,null,null,null,5000,14.2,"Hankinson",null,null,null,null,null,null,{"$f":"IF(BaselineRating<=300,'Operating Power'!Y25,'Operating Power'!AB25)","v":0.1},{"$f":"IF(BaselineRating<=300,'Operating Power'!Z25,'Operating Power'!AC25)","v":0.19},null,null,null,null,null,null,null,null,"average for both:",{"$f":"AVERAGE(AK16:AK22,AK29:AK34)","v":0.19095834126967143}]
[null,650,4.0999999999999996,"Airtek",null,3250,18.03,null,null,null,null,null,null,null,null,null,6000,22.89,"Ingersoll-Rand",null,null,null,null,null,null,{"$f":"IF(BaselineRating<=300,'Operating Power'!Y26,'Operating Power'!AB26)","v":0},{"$f":"IF(BaselineRating<=300,'Operating Power'!Z26,'Operating Power'!AC26)","v":9.9999999999999922E-2}]
[null,700,5.79,"Ingersoll-Rand",null,4000,21.77,null,null,null,null,null,null,null,null,null,6000,19.2,"Hankinson"]
[null,700,5.79,"Zek",null,4800,28.72,null,null,null,null,null,null,null,null,null,8000,30.52,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,"Zeks data"]
[null,800,5.0999999999999996,"Airtek",null,6000,32.65,null,null,null,null,null,null,null,null,null,8000,24.4,"Hankinson",null,null,null,null,null,null,null,null,null,null,null,null,"model","full flow","10% flow","full power","10% power","%power at 10% flow"]
[null,800,6.5,"Ingersoll-Rand",null,8000,43.54,null,null,null,null,null,null,null,null,null,10000,33.5,"Hankinson",null,null,null,null,null,null,null,null,null,null,null,null,"200HSGA",200,20,1.7,0.31,{"$f":"AJ42/AI42","v":0.18235294117647058}]
[null,800,4.625,"Sullivan",null,null,null,null,null,null,null,null,null,null,null,null,12000,41.5,"Hankinson",null,null,null,null,null,null,null,null,null,null,null,null,"400 HSGA",400,40,3.2,0.46,0.14374999999999999]
[null,800,6.5,"Zek",null,null,null,null,null,null,null,null,null,null,null,null,15000,48.8,"Hankinson",null,null,null,null,null,null,null,null,null,null,null,null,"600 HSFA",600,60,4.8,0.62,0.12916666666666668]
[null,1000,6.36,"Airtek",null,null,null,null,null,null,null,null,null,null,null,null,"SLOPE",{"$f":"SLOPE(R9:R43,Q9:Q43)","v":3.2594264327021902E-3},"cycling_water_slope",null,null,null,null,null,null,null,null,null,null,null,null,"800 HSFA",800,80,6.5,0.82,0.12615384615384614]
[null,1000,7.03,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,"INTERCEPT:",{"$f":"INTERCEPT(R9:R43,Q9:Q43)","v":1.504877131610149},"cycling_water_intercept",null,null,null,null,null,null,null,null,null,null,null,null,"1000HSFA",1014,160,8.9,1.6,0.1797752808988764]
[null,1000,6.37,"Sullivan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200HSGW",200,20,1.1000000000000001,0.21,0.19090909090909089]
[null,1000,8.9,"Zek",null,null,null,null,null,null,null,null,null,null,null,null,"Upgrade size:",{"$f":"UpgradeRating","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,"400HSGW",400,40,2.2000000000000002,0.33,0.15]
[null,1200,6.69,"Airtek",null,null,null,null,null,null,null,null,null,null,null,null,"base size:",{"$f":"BaselineRating","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,"600HSFW",600,60,3.2,0.43,0.13437499999999999]
[null,1200,8.7200000000000006,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,"Upgrade kW:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"800HSFW",800,80,4.2,0.53,0.12619047619047619]
[null,1200,10.5,"Zek",null,null,null,null,null,null,null,null,null,null,null,null,"air-cooled:",{"$f":"VLOOKUP(R48,F9:G42,2)","v":0.95333333333333325},"CyclingAirkW"]
[null,1350,9.6,"Sullivan",null,null,null,null,null,null,null,null,null,null,null,null,"water-cooled:",{"$f":"VLOOKUP(R48,U9:V29,2)","v":1},"CyclingWaterkW"]
[null,1600,11.48,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"under 300:",{"$f":"AVERAGE(AK16:AK17,AK29:AK30,AK42)","v":0.19358562091503267}]
[null,1600,13.1,"Zek",null,null,null,null,null,null,null,null,null,null,null,null,"Baseline kW:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"over 300:",{"$f":"AVERAGE(AK18:AK22,AK31:AK34,AI43:AI50)","v":2.1056990160651203}]
[null,1800,12.18,"Sullivan",null,null,null,null,null,null,null,null,null,null,null,null,"air-cooled:",{"$f":"VLOOKUP(R49,E77:F99,2)","v":1.02},"NcAirkW"]
[null,2000,11.7,"Airtek",null,null,null,null,null,null,null,null,null,null,null,null,"water-cooled:",{"$f":"VLOOKUP(R49,B124:C144,2)","v":1},"NcWaterkW"]
[null,2000,13.18,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zeks non-cycling"]
[null,2000,14,"Zek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"model","full flow","10% flow","full power","10% power","%power at 10% flow"]
[null,2400,14.29,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200NCGA",200,20,1.7,1.6,{"$f":"AJ59/AI59","v":0.94117647058823539}]
[null,2400,15.8,"Zek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"400NCGA",400,40,3.5,3.3,0.94285714285714284]
[null,2500,14.79,"Airtek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"800NCEA",800,80,5.6,5.3,0.94642857142857151]
[null,3000,15.5,"Airtek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200NCGW",200,20,1.4,1.3,0.92857142857142871]
[null,3250,18.03,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"400NCGW",400,40,2.9,2.8,0.96551724137931028]
[null,4000,21.77,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"800NCEW",800,80,4.5999999999999996,4.4000000000000004,0.95652173913043492]
[null,4800,28.72,"Ingersoll-Rand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avg:",{"$f":"AVERAGE(AK59:AK64)","v":0.94684543232585394}]
[null,6000,32.65,"Ingersoll-Rand"]
[null,8000,43.54,"Ingersoll-Rand"]
[]
[null,"SLOPE",{"$f":"SLOPE(C9:C67,B9:B67)","v":5.4564500528603418E-3},"cycling_air_slope"]
[null,"INTERCEPT:",{"$f":"INTERCEPT(C9:C67,B9:B67)","v":1.1701325138780643},"cycling_air_intercept"]
[]
[null,"Non-cycling"]
[]
["Air cooled","Nominal","operating"]
[null,"capacity,","kW"]
[null,"scfm @ 38F","air cool",null,"sorted ","averaged"]
[null,20,0.255,"Sullivan",20,0.255]
[null,25,0.36,"Sullivan",25,0.36]
[null,40,0.435,"Sullivan",40,0.435]
[null,50,0.56000000000000005,"Sullivan",50,0.56000000000000005]
[null,75,0.67,"Zek",75,0.71499999999999997]
[null,75,0.76,"Sullivan",100,1.02]
[null,100,1.03,"Zek",125,1.1850000000000001]
[null,100,1.01,"Sullivan",150,1.1850000000000001]
[null,125,1.27,"Zek",200,1.62]
[null,125,1.1000000000000001,"Sullivan",250,1.8166666666666667]
[null,150,1.27,"Zek",300,2.0866666666666664]
[null,150,1.1000000000000001,"Sullivan",400,2.8123333333333336]
[null,200,1.7,"Zek",500,3.872666666666666]
[null,200,1.8,"Zek",600,4.5]
[null,200,1.36,"Sullivan",625,4.2]
[null,250,1.6,"Zek",650,4.0279999999999996]
[null,250,2,"Airtek",700,5.38]
[null,250,1.85,"Sullivan",800,5.2949999999999999]
[null,300,2.11,"Zek",1000,6.5]
[null,300,2.2999999999999998,"Airtek",1200,9.5]
[null,300,1.85,"Sullivan",1600,11.3]
[null,400,3.48,"Zek",2000,13.8]
[null,400,2.5,"Airtek",2400,16.2]
[null,400,2.4569999999999999,"Sullivan"]
[null,500,3.59,"Zek"]
[null,500,4,"Airtek"]
[null,500,4.0279999999999996,"Sullivan"]
[null,600,4.5,"Zek"]
[null,625,4.2,"Airtek"]
[null,650,4.0279999999999996,"Sullivan"]
[null,700,5.38,"Zek"]
[null,800,5.59,"Zek"]
[null,800,5,"Sullivan"]
[null,1000,6.5,"Zek"]
[null,1200,9.5,"Zek"]
[null,1600,11.3,"Zek"]
[null,2000,13.8,"Zek"]
[null,2400,16.2,"Zek"]
[]
[]
[]
[null,"SLOPE",{"$f":"SLOPE(F77:F99,E77:E99)","v":6.8055109364451158E-3},"nc_air_slope"]
[null,"INTERCEPT:",{"$f":"INTERCEPT(F77:F99,E77:E99)","v":0.20183596960983863},"nc_air_intercept"]
[]
[null,"Nominal","operating"]
["Water Cooled","capacity,","kW"]
[null,"scfm @ 38F","water cool"]
[null,100,1]
[null,200,1.34,"Zek"]
[null,250,1.25]
[null,300,1.67]
[null,400,2.88]
[null,500,2.88]
[null,600,3.71]
[null,700,4.24]
[null,800,4.54]
[null,1000,6.1]
[null,1200,6.1]
[null,1600,7.7]
[null,2000,9]
[null,2400,11.7]
[null,4000,13.9]
[null,5000,16.399999999999999]
[null,6250,22.5]
[null,8250,28.9]
[null,10000,39.6]
[null,12000,49.6,"Hankinson"]
[null,15000,57.6]
[null,"SLOPE",{"$f":"SLOPE(C125:C144,B125:B144)","v":3.7677231051951431E-3},"nc_water_slope"]
[null,"INTERCEPT:",{"$f":"INTERCEPT(C125:C144,B125:B144)","v":0.93192305143059428},"nc_water_intercept"]

{"sheet":"Instructions","index":10,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Instructions for Using the BPA Small Compressed Air Calculator"]
[null,null,"Intended Use"]
[null,null,"The BPA Small Compressed Air Calculator provides a means of quickly estimating air compressor energy use and the savings associated with changing to a different compressor or compressor control method.  The output may be used to apply for incentive funding from utility efficiency programs for projects involving compressors 150 hp and below.  (Larger projects usually require a custom study.)  Call the energy efficiency department at your local electric utility for information on incentives and details on how to apply.   "]
[null,null,"General Instructions"]
[null,null,"Input fields are located on three worksheets in this Excel file.  Information about the customer, also called the program \"Participant\", is entered in the first tab; \"Customer Information.\"  Vendor contact information and utility incentive program details are also entered here.  Technical information about the project is requested on the second tab; \"Savings Calculations.\"  The third tab, \"Explanation of Inputs,\" asks for explanation of how some of the entries in \"Savings Calculations\" were derived.   A summary of results appears at the bottom of the \"Savings Calculations\" tab."]
[null,null,"Baseline Determination Considerations"]
[null,null,"Energy savings from a new compressor installation are calculated relative to \"baseline\" energy use.  Depending on circumstances, the appropriate baseline may be the existing compressor or a new, basic compressor without the energy-saving capabilities of a higher-end model.  These baseline options are described below."]
[null,null,"a)  The \"Retrofit\" scenario:  When the proposed upgrade compressor replaces a machine that is currently operating and isn't about to be replaced for end-of-life reasons or to add more capacity, the \"Baseline Compressor\" will be the machine that is currently in place.  The \"Proposed Upgrade\" will be the new, more efficient compressor.  Eligible project cost is the total installed cost of the new compressor.   "]
[null,null,"b)  The \"New Construction\" scenario:  When the proposed compressor is a new machine in a new facility, or when it is an addition of new capacity, or when the existing compressor is on its last legs and will need to be replaced shortly, the \"Baseline Compressor\" will be a new compressor at the low end of the cost scale that typically would be installed in similar circumstances.  The \"Proposed Upgrade\" will be a new, more efficient - and more costly - alternative.  Eligible project cost is the difference between the cost of the more efficient alternative and the cost of the basic, less efficient installation.  Typically the baseline control type for the new construction scenario should be load/unload."]
[null,null,"System Pressure"]
[null,null,"\"Current average operating pressure\" is the average discharge pressure the compressor sees while running loaded.\"  For load/unload and on/off operation, this would be the midpoint between the load pressure setpoint and the unload pressure setpoint.  \"System pressure after upgrade\" is typically the control pressure setpoint for the VFD compressor.  Note that this pressure is entirely separate from the rated pressures given above for the baseline and upgrade compressors.  Those pressures represent the pressure at which a compressor will deliver a corresponding rated flow, as given in the manufacturer's performance specification.  These rated figures are entirely separate from the pressure settings found on an actual operating unit.   "]
[null,null,"Profile of Compressed Air Demand"]
[null,null,"The profile of compressed air demand tells how heavily loaded a compressor is loaded throughout the work week.  Some systems are heavily loaded, delivering high output continuously throughout the entire week.  Others are more variable, working to capacity during periods of heavy air use, such as when the sand blaster is operating, but spending most of the time delivering minimal flow for air tools, air cylinders, and the ever-present leak load.   "]
[null,null,"To characterize the operation of a system, divide the operating time into natural categories that describe the system's operation.  For example, if a system is pressurized 16 hours every day, and the compressor barely meets the demand for air due to simultaneous occurrence of heavy loads during 4 of those hours, then for 4/16  (= 25%) of the time, the system can be considered to be 100% loaded.  Further, if during 8 hours of each day the compressor loads and unloads regularly, staying loaded about half the time, then 8/16 (= 50%) of the time the demand for air will be at 50% of capacity.  If during the remaining 4 hours per day there is little demand for air, but the compressor continues to run, loading up about 12 minutes per hour, then during that 4/16 (=25%) of the time the demand would be 12/60 = 20% of capacity, which could be mostly meeting leak load.  Our time bins now add to 100%, as they should (25% + 50% + 25%), and we have characterized the operation of the system.      "]
[null,null,"Note that the final line in the profile table is reserved for the special no-load operating condition when the system is pressurized and the compressor is enabled, but the load is so low that the compressor has timed out and switched off after \"idling\" in the unloaded state.  During these times, the compressor motor draws no power.  This situation is quite different from the no load condition when the compressor has unloaded, but is still spinning.  In this second case, significant power is consumed even though the air delivery rate is zero cfm.     "]
[null,null,"Interpretation of Project NPV"]
[null,null,"The Net Present Value (NPV) given at the bottom of the Savings Calculations sheet (Estimate of Energy Savings and Incentives) accounts for cashflows over a ten-year period using a discount rate of 5%. Non-energy benefits, if any have been entered in the Customer Information Sheet, are included in the NPV calculation.  Energy savings, and thus avoided energy costs, are assumed constant over the ten year period.  The rate paid for energy is also assumed constant; no inflation factor has been applied to energy rates."]
[null,null,"Creating the EE Central Upload File (for utility and administrator use)"]
[null,null,"To create the datafile for upload to the EE Central, press CTRL-P while viewing the Savings Calculation page.  The file will write immediately and a window will open asking for the filename.  The suggested filename is the same as the calculator filename, with \"_EE Central\" appended.  The default folder location is the same as that of the calculator file you are writing from.  Folder location and filename may be changed as desired.   "]
[null,{"$f":"\"Cascade Energy, Inc. © \"&YEAR(TODAY())","v":"Cascade Energy, Inc. © 2024"},null,{"$f":"ToolName&\" - \"&ToolVersion","v":"BPA Small Compressed Air Calculator - 5.1"}]