{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["General","PID & Cash Flow","SIR Ratio","Discount Payback Period","Summary"],"not_rendered":{"charts":4},"read":"whole","date_system":"1900"}

{"sheet":"General","index":0,"n_rows":68,"n_cols":28,"rows_kept":68,"merged":[[1,0,1,2],[1,8,1,10],[2,8,2,9],[3,0,5,6],[3,8,4,8],[3,9,4,9],[3,10,4,10],[5,10,5,11],[7,0,8,6],[10,0,12,6],[10,8,10,9],[14,0,15,4],[17,0,17,6],[18,0,20,6],[20,8,21,11],[22,0,23,6],[25,0,27,6],[32,0,32,6],[33,0,34,6],[36,0,36,6],[37,0,38,6],[40,0,41,6],[44,0,44,2],[45,0,47,0],[45,1,47,6],[49,0,49,1],[49,3,49,6],[50,3,50,5],[63,3,63,5],[64,3,64,5],[65,3,65,5],[66,3,66,5],[67,3,67,5]]}
[]
["Instructions:",{"$nulls":7},"Gasline and Water Calculations:"]
[{"$nulls":8},"Gas Line Extension Calculations:",null,"Notes:"]
["This worksheet provides the LCCA comparison between two cases: Case A and Case B. The lifetime evalued is set at a maximum of 35 years. This worksheet is formatted to be printer-friendly, do not change this format. Only DOE projects may use this calculator (no OMB). The discount factors included for payback calcultions must be updated annually with the Annual Supplement to Handbook 135. ",{"$nulls":7},"Linear measurement of extension (in feet):",null,"For lines up to 10 inch diameter"]
[]
[{"$nulls":8},"Cost of line per linear foot:",{"$f":"400*(10^-3)","v":{"v":0.4,"d":"$0.40"}},"Includes cost of construction, quoted 5/28/19"]
[{"$nulls":8},"Cost per tie-in:",{"v":5,"d":"$5.00"}]
["User must fill in each applicable yellow field input area. Notes are provided for clarity when inputting values. White areas are coded to provide Life-Cycle Cost Analysis (LCCA), do not interfere with these calculations. ",{"$nulls":7},"Cost per reg station:",{"v":5,"d":"$5.00"}]
[{"$nulls":8},"Number of tie-ins:"]
[{"$nulls":8},"Number of reg stations:"]
["The following result can be concluded from this worksheet: General project identificaiton information, cash flow comparisons (visual and numerical),  savings-to-investment ratio, and discount payback period. ",{"$nulls":7},"Total Cost of Line Extension/Tie-Ins:",null,{"$f":"(J4*J6)+(J9*J7)+(J10*J8)","v":0},"Includes cost of construction, quoted 7/22/19"]
[]
[{"$nulls":8},"Annual Water Cost Calculations:",null,"Notes:"]
[{"$nulls":8},"Number of Office Workers:"]
["Terminology Clarifications:",{"$nulls":7},"Amount of Water Per Person (in kilo-gallons):",{"$f":"25*10^-3","v":0.025},"Quoted 5/28/19"]
[]
[{"$nulls":8},"Amount of Processes Water Needed (in kilo-gallons):"]
["\"Year in lifetime\" refers to the year at which the cost takes place. ",{"$nulls":7},"Cost of Water (per kgal)",{"$f":"3.4/(10^3)","v":{"v":0.0034,"d":"$0.00340000"}},"Cost in thousands, quoted 5/28/19 at $3.40 per kgal"]
["For costs not listed that occur annually, add to highlighted space in \"General & Cash Flow\" tab where \"all\" is listed. For costs not listed that occur once, add to highlighted space in \"General & Cash Flow\" tab where the year must be specified. Specify the year at which the cost takes place in the provided space.",{"$nulls":7},"Total Annual Cost of Water:",{"$f":"(J18*J17)+(J18*J14*J15)","v":0}]
[]
[{"$nulls":8},"Information Needed to Complete this Workbook:"]
[]
["\"One-Time Other Costs\" refers to investment and operational costs that do not occur annually. For these values, the user will also list the \"year in lifetime\" in the corresponding input cell. Examples of these costs include replacements such as roofing, mechanical equiptment, etc.",{"$nulls":7},"Case A Cost: (in Thousands)"]
[{"$nulls":8},"CATEGORY","YEAR # IN LIFETIME","COST PER YEAR","Notes"]
[{"$nulls":8},"Initial investment:",1,{"$f":"B68","v":0}]
["\"Lower-First-Cost Option\" refers to the cost in a category belonging to the option with the lowest initial investment. \"Higher-First-Cost Option\" refers to the cost in a category belonging to the option with the highest initial investment.",{"$nulls":7},"Total Electricity:","Annual",null,"(Usually $0.08 per kW/h)"]
[{"$nulls":8},"OM & R:","Annual",null,"Lifetime of 6 years = zero OM&R"]
[{"$nulls":8},"Total Natural Gas:","Annual",null,"(Usually $3.5 per million Btu)"]
[{"$nulls":8},"Water:","Annual",{"$f":"J19","v":0}]
[{"$nulls":8},"Resale value:",null,null,"End of Life Expectancy"]
["Citations:",{"$nulls":7},"Salvage Value:",null,null,"End of Life Expectancy"]
[]
["Life-Cycle Costing Manual for the Federal Energy Management Program, NIST Handbook 135, 1995 Edition:",{"$nulls":7},"Case B Cost: (in Thousands)"]
["https://www.nist.gov/publications/life-cycle-costing-manual-federal-energy-management-program-nist-handbook-135-1995 "]
[{"$nulls":8},"CATEGORY","YEAR # IN LIFETIME","COST PER YEAR","Notes"]
[{"$nulls":8},"Initial investment:",1,{"$f":"G68","v":0}]
["Energy Price Indices and Discount Factors LCCA 2019, Annual Supplement to Handbook 135: ",{"$nulls":7},"Total Electricity:","Annual",null,"(Usually $0.08 per kW/h)"]
["https://www.nist.gov/publications/energy-price-indices-and-discount-factors-life-cycle-cost-analysis-150-2019-annual",{"$nulls":7},"OM & R:","Annual",null,"Lifetime of 6 years = zero OM&R"]
[{"$nulls":8},"Total Natural Gas:","Annual",null,"(Usually $3.5 per million Btu)"]
[{"$nulls":8},"Water:","Annual",{"$f":"J19","v":0}]
["Utilities & Infrastructure Facility Operations, Los Alamos National Laboratory.                                                                                      Author: Matney Juntunen",{"$nulls":7},"Resale value:",null,null,"End of Life Expectancy"]
[{"$nulls":8},"Salvage Value:",null,null,"End of Life Expectancy"]
[]
[]
["Initial Investment Calculator:"]
["Instructions: ","Fill in the following values if applicable to the project. The initial investment should include all costs which allow the project to begin its lifetime. Note: Costs are in Thousands."]
[]
[]
[]
["CASE A INITIAL INVESTMENT:",null,null,"CASE B INITIAL INVESTMENT:"]
["TOPIC","COST",null,"TOPIC",null,null,"COST"]
[{"$nulls":27},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["All Materials:",null,null,"All Materials:"]
["All labor:",null,null,"All labor:"]
["TAB:",null,null,"TAB:"]
["BAS Controls:",null,null,"BAS Controls:"]
["Safety:",null,null,"Safety:"]
["Inspections:",null,null,"Inspections:"]
["Building Outage:",null,null,"Building Outage:"]
["Parking Lot:",null,null,"Parking Lot:"]
["Water Drainage:",null,null,"Water Drainage:"]
["Other Contruction Costs:",null,null,"Other Contruction Costs:"]
["Gas Extension Calulations:",null,null,"Gas Extension Calulations:"]
[]
[]
[]
[]
["Case A Initial Investment:",{"$f":"SUM(B53:B67)","v":0},null,"Case A Initial Investment:",null,null,{"$f":"SUM(G53:G67)","v":0}]

{"sheet":"PID & Cash Flow","index":1,"n_rows":67,"n_cols":30,"rows_kept":67,"merged":[[0,0,1,4],[0,8,0,9],[2,0,2,1],[2,6,2,8],[8,0,9,0],[8,1,9,1],[11,0,13,0],[11,1,13,1],[11,2,13,2],[13,9,15,9],[14,0,15,0],[14,1,15,1],[14,2,15,2],[17,0,17,1],[18,0,19,2],[20,0,29,2],[31,0,31,1],[32,1,32,2],[33,1,33,2],[38,2,39,2],[55,9,58,9]]}
["Cost of Gas vs. Electric LCC Analysis Calculator                             - See Appendix C in NIST Handbook 135 for Guidance",{"$nulls":7},"Cash Flows Last Updated 7/23/2017",{"$nulls":10},"Column1","Column2","Column3","Column4","Column5","Column6","Column63","Column62","Column7","Column16","Column17"]
[{"$nulls":19},"Data for Graphs - Case B"]
["PROJECT IDENTIFICATION",null,"Notes",{"$nulls":3},"CASH FLOWS (IN THOUSANDS) FOR CASE A"]
["Project ID No:",{"$nulls":18},"Year","Init. Inv.","Electricity","OMR","Gas","Water","Other1","Other2","Other3","Resale","Salvage"]
["Fiscal year:",{"$nulls":5},"CATEGORY","YEAR # IN LIFETIME","COST PER YEAR","Notes",{"$nulls":9},0,{"$f":"I6","v":0},{"$f":"$I$7","v":0},{"$f":"$I$8","v":0},{"$f":"$I$9","v":0},{"$f":"$I$10","v":0},{"$f":"$I$11","v":0},{"$f":"$I$12","v":0},{"$f":"$I$13","v":0}]
["Location: ",null,"DoE Region, LANL Building",{"$nulls":3},"Initial investment:",1,{"$f":"General!K25","v":0},{"$nulls":10},{"$f":"T5+3","v":3},null,{"$f":"$I$7","v":0},0,0,{"$f":"$I$10","v":0},{"$f":"$I$11","v":0},{"$f":"$I$12","v":0},{"$f":"$I$13","v":0}]
["Base Date (BD):",null,"MM/DD/YYYY (Start of study)",{"$nulls":3},"Total Electricity:","Annual",{"$f":"General!K26","v":0},"(Usually $0.08 per kW/h)",{"$nulls":9},{"$f":"T6+2","v":5},null,0,0,0,0,0,0,0]
["Service Date (SD):",null,"MM/DD/YYYY (Occupancy)",{"$nulls":3},"OM & R:","Annual",{"$f":"General!K27","v":0},{"$nulls":10},{"$f":"T7+2","v":7},null,0,0,0,0,0,0,0]
["Design Feature to be Evaluated:",{"$nulls":5},"Total Natural Gas:","Annual",{"$f":"General!K28","v":0},"(Usually $3.5 per million Btu)",{"$nulls":9},9,null,0,0,0,0,0,0,0]
[{"$nulls":6},"Water:","Annual",{"$f":"General!K29","v":0},{"$nulls":10},11,null,0,0,0,0,0,0,0]
["List Constraints:",null,"Attach page if needed",{"$nulls":4},"Annual",{"$nulls":11},13,null,0,0,0,0,0,0,0]
["Energy/Water Conservation Study? (FEMP)","No",{"$nulls":5},"Annual",{"$nulls":11},15,null,0,0,0,0,0,0,0]
[{"$nulls":7},"Annual",{"$nulls":11},17,null,0,0,0,0,0,0,0]
[{"$nulls":9},"Other One-Time Costs (replacements, disposal, etc.) ",{"$nulls":9},19,null,0,0,0,0,0,0,0]
["OMB A-94? ","No","Office of Management and Budget circular not at LANL",{"$nulls":16},21,null,0,0,0,0,0,0,0]
[{"$nulls":19},23,null,0,0,0,0,0,0,0]
[{"$nulls":19},25,null,0,0,0,0,0,0,0]
["BASE CASE AND ALTERNATIVES",{"$nulls":18},27,null,0,0,0,0,0,0,0]
["Name and describe base case (lower initial investment) and alternatives to be analyzed. Include any relevent assumptions:",{"$nulls":5},"Resale value:",{"$f":"General!J30","v":0},{"$f":"General!K30","v":0},"End of Life Expectancy",{"$nulls":9},29,null,0,0,0,0,0,0,0]
[{"$nulls":6},"Salvage Value:",{"$f":"General!J31","v":0},{"$f":"General!K31","v":0},"End of Life Expectancy",{"$nulls":9},31,null,0,0,0,0,0,0,0]
[{"$nulls":19},33,null,0,0,0,0,0,0,0]
[{"$nulls":19},35,{"$nulls":8},{"$f":"-I19","v":0},{"$f":"-I20","v":0}]
{"$rows_empty":9}
["GENERAL INFORMATION:"]
["Name of Analyst:"]
["Phone Number:"]
["Z-Number:"]
["Date of Study Completion:",null,"MM/DD/YYYY"]
[]
["KEY DATES",null,"Notes"]
["Years of Life:",null,"Quantity (commonly 25-30 years)"]
["BD:",{"$f":"B7","v":"00:00:00"}]
["SD:",{"$f":"B8","v":"00:00:00"}]
["End of Study:",{"$f":"B36","v":"00:00:00"}]
[]
[]
[{"$nulls":6},"CASH FLOWS (IN THOUSANDS) FOR CASE B"]
[{"$nulls":19},"Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11"]
[{"$nulls":6},"CATEGORY","YEAR # IN LIFETIME","COST","Notes",{"$nulls":9},"Data for Graphs - Case B"]
[{"$nulls":6},"Initial investment:",1,{"$f":"General!K36","v":0}]
[{"$nulls":6},"Total Electricity:","Annual",{"$f":"General!K37","v":0},"(Usually $0.08 per kW/h)",{"$nulls":9},"Year","Init. Inv.","Electricity","OMR","Water","Other1","Other2","Other3","Resale","Salvage","Nat Gas"]
[{"$nulls":6},"OM & R:","Annual",{"$f":"General!K38","v":0},{"$nulls":10},0,{"$f":"I48","v":0},{"$f":"$I$49","v":0},{"$f":"$I$50","v":0},{"$f":"$I$52","v":0},{"$f":"$I$53","v":0},{"$f":"$I$54","v":0},{"$f":"$I$55","v":0},null,null,{"$f":"$I$51","v":0}]
[{"$nulls":6},"Total Natural Gas:","Annual",{"$f":"General!K39","v":0},"(Usually $3.5 per million Btu)",{"$nulls":9},{"$f":"T50+3","v":3},null,0,0,0,0,0,0,null,null,{"$f":"$I$51","v":0}]
[{"$nulls":6},"Water","Annual",{"$f":"General!K40","v":0},{"$nulls":10},{"$f":"T51+2","v":5},null,0,0,0,0,0,0,null,null,0]
[{"$nulls":7},"Annual",{"$nulls":11},{"$f":"T52+2","v":7},null,0,0,0,0,0,0,null,null,0]
[{"$nulls":7},"Annual",{"$nulls":11},{"$f":"T53+2","v":9},null,0,0,0,0,0,0,null,null,0]
[{"$nulls":7},"Annual",{"$nulls":11},{"$f":"T54+2","v":11},null,0,0,0,0,0,0,null,null,0]
[{"$nulls":9},"Other One-Time Costs (replacements, disposal, etc.) ",{"$nulls":9},13,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},15,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},17,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},19,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},21,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},23,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},25,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":6},"Resale value:",{"$f":"General!J41","v":0},{"$f":"General!K41","v":0},"End of Life Expectancy",{"$nulls":9},27,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":6},"Salve Value:",{"$f":"General!J42","v":0},{"$f":"General!K42","v":0},"End of Life Expectancy",{"$nulls":9},29,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},31,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},33,null,0,0,0,0,0,0,null,null,0]
[{"$nulls":19},35,{"$nulls":7},{"$f":"-I63","v":0},{"$f":"-I64","v":0}]

{"sheet":"SIR Ratio","index":2,"n_rows":120,"n_cols":7,"rows_kept":120,"merged":[[2,0,2,3],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[5,5,15,5],[8,2,13,2],[17,3,17,5],[20,0,21,0],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6],[22,5,32,5],[26,2,30,2],[34,3,34,5],[36,0,36,4],[36,5,36,6],[38,0,39,6],[41,0,41,6],[47,0,47,3],[48,0,49,0],[48,1,49,1],[48,2,49,2],[48,3,49,3],[48,4,49,4],[48,5,49,5],[48,6,49,6],[50,5,60,5],[53,2,58,2],[62,2,62,4],[65,0,66,0],[65,1,66,1],[65,2,66,2],[65,3,66,3],[65,4,66,4],[65,5,66,5],[65,6,66,6],[67,5,77,5],[71,2,75,2],[79,2,79,4],[81,0,81,4],[81,5,81,6],[83,0,84,6],[86,0,86,6],[96,0,96,4],[97,2,99,2],[97,3,99,3],[98,4,99,4],[99,0,99,1],[100,0,100,1],[101,0,101,1],[102,0,102,1],[103,0,103,1],[105,0,105,3],[106,2,108,2],[106,3,108,3],[107,4,108,4],[108,0,108,1],[109,0,109,1],[110,0,110,1],[111,0,111,1],[113,0,113,3],[115,0,115,3],[119,0,121,4]]}
[]
[]
["Specify Case A Investment-Related Costs: (in Thousands)"]
["CATEGORY","AMOUNT","Notes","Year in Lifetime","DISCOUNT FACTOR (SPV)","Notes","PRESENT VALUE"]
[]
["Initial Investment:",{"$f":"'PID & Cash Flow'!I6","v":0},null,1,null," (Rates included in NIST Handbook 135 Annual Suppliment discount factors. Must discount to ending year of occurance).",{"$f":"B6*E6","v":0}]
["Resale:",{"$f":"-'PID & Cash Flow'!I19","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
["Salvage:",{"$f":"-'PID & Cash Flow'!I20","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
[null,null,"See previous sheet values and parts",{"$nulls":3},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
[]
[]
[{"$nulls":3},"Total Investment-Related Costs:",null,null,{"$f":"SUM(G6:G14)","v":0}]
[]
["Specify Case A Operation-Related Costs: (in Thousands)"]
["CATEGORY","AMOUNT","Notes","Year in lifetime/end year of occurances","DISCOUNT FACTOR (UPV or SPV)","Notes","PRESENT VALUE"]
[]
["Total Electricity:",{"$f":"'PID & Cash Flow'!I7","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null," (Rates included in NIST Handbook 135 Annual Suppliment discount factors. Must discount to ending year of occurance).",{"$f":"B23*E23","v":0}]
["OM & R:",{"$f":"'PID & Cash Flow'!I8","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
["Total Natural Gas:",{"$f":"'PID & Cash Flow'!I9","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
["Water:",{"$f":"'PID & Cash Flow'!I10","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
[null,null,"See previous sheet values and parts",{"$nulls":3},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
[]
[]
[{"$nulls":3},"Total Operation-Related Costs:",null,null,{"$f":"SUM(G23:G31)","v":0}]
[]
["Total Case A Present Value Life Cycle Costs:",{"$nulls":4},{"$f":"G35+G18","v":0}]
[]
["Note: See Tables from the Energy Price Indices and Discount Factors LCCA 2019, Annual Supplement to Handbook 135 to find discount factors."]
[]
[]
["UPV is for uniform/annual costs, while SPV is for single expense/one-time  costs.  "]
[]
[]
[]
[]
[]
["Specify Case B Investment-Related Costs: (in Thousands)"]
["CATEGORY","AMOUNT","Notes","Year in Lifetime","DISCOUNT FACTOR (SPV)","FACTOR TABLE NO.","PRESENT VALUE"]
[]
["Initial Investment:",{"$f":"'PID & Cash Flow'!I48","v":0},null,1,null," (Rates included in NIST Handbook 135 Annual Suppliment discount factors. Must discount to ending year of occurance).",{"$f":"B51*E51","v":0}]
["Resale:",{"$f":"-'PID & Cash Flow'!I63","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
["Salvage:",{"$f":"-'PID & Cash Flow'!I64","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
[null,null,"See previous sheet values and parts",{"$nulls":3},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
[]
[]
[null,null,"Total Investment-Related Costs:",{"$nulls":3},{"$f":"SUM(G51:G59)","v":0}]
[]
["Specify Case B Operation-Related Costs: (in Thousands)"]
["CATEGORY","AMOUNT","Notes","Year in lifetime/end year of occurances","DISCOUNT FACTOR (SPV or UPV)","FACTOR TABLE NO.","PRESENT VALUE"]
[]
["Total Electricity:",{"$f":"'PID & Cash Flow'!I49","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null," (Rates included in NIST Handbook 135 Annual Suppliment discount factors. Must discount to ending year of occurance).",{"$f":"B68*E68","v":0}]
["OM & R:",{"$f":"'PID & Cash Flow'!I50","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
["Natural Gas",{"$f":"'PID & Cash Flow'!I51","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,{"$f":"B70*E70","v":0}]
["Water",{"$f":"'PID & Cash Flow'!I52","v":0},null,{"$f":"'PID & Cash Flow'!$B$39","v":0},null,null,0]
[null,null,"See previous sheet values and parts",{"$nulls":3},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
[]
[]
[null,null,"Total Operation-Related Costs:",{"$nulls":3},{"$f":"SUM(G68:G76)","v":0}]
[]
["Total Case B Present Value Life Cycle Costs:",{"$nulls":4},{"$f":"G80+G63","v":0}]
[]
["Note: See Tables from the Energy Price Indices and Discount Factors LCCA 2019, Annual Supplement to Handbook 135 to find discount factors."]
[]
[]
["UPV is for uniform/annual costs, while SPV is for single expense/one-time  costs.  "]
{"$rows_empty":9}
["Calculate Savings-to-Investment Ratio:"]
[null,null,"Lower-First-Cost Option","Higher-First-Cost Option"]
[{"$nulls":4},"Savings"]
["Operational-Related Costs:"]
["Total Energy:",null,{"$f":"IF(B6>B51,(G68+G70),(G23+G25))","v":0},{"$f":"IF(B6>B51,(G23+G25),(G68+G70))","v":0},{"$f":"C101-D101","v":0}]
["OM & R:",null,{"$f":"IF(B6>B51,G69,G24)","v":0},{"$f":"IF(B6>B51,G24,G69 )","v":0},{"$f":"C102-D102","v":0}]
["Water:",null,{"$f":"IF(B6>B51,G71,G26 )","v":0},{"$f":"IF(B6>B51,G26,G71 )","v":0},{"$f":"C103-D103","v":0}]
["Sum of Other Costs:",null,{"$f":"IF(B6>B51,SUM(G72:G76),SUM(G27:G31))","v":0},{"$f":"IF(B6>B51,SUM(G27:G31),SUM(G72:G76))","v":0},{"$f":"C104-D104","v":0}]
[]
["Total Op. Savings (in Thousands):",{"$nulls":3},{"$f":"SUM(E101:E104)","v":0}]
[null,null,"Higher-First-Cost Option","Lower-First-Cost Option"]
[{"$nulls":4},"Savings"]
["Investment-Related Costs:"]
["Initial Investment:",null,{"$f":"IF(B6>B51, G6,G51 )","v":0},{"$f":"IF(B6>B51, G51,G6 )","v":0},{"$f":"C110-D110","v":0}]
["Resale+Salvage:",null,{"$f":"IF(B6>B51, SUM(G7:G8),SUM(G52:G53))","v":0},{"$f":"IF(B6>B51,SUM(G52:G53), SUM(G7:G8))","v":0},{"$f":"C111-D111","v":0}]
["Sum of Other Costs:",null,{"$f":"IF(B6>B51, SUM(G9:G14),SUM(G54:G59))","v":0},{"$f":"IF(B6>B51,SUM(G54:G59),SUM(G9:G14))","v":0},{"$f":"C112-D112","v":0}]
[]
["Total Additional Investment (in Thousands):",{"$nulls":3},{"$f":"SUM(E110:E112)","v":0}]
[]
["Savings-to-Investments Ratio (SIR):",{"$nulls":3},{"$f":"(E106/E114)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["SIR is cost effective if the ratio is greater than 1. This measure is relative to the base case."]

{"sheet":"Discount Payback Period","index":3,"n_rows":130,"n_cols":11,"rows_kept":130,"merged":[[0,0,0,4],[0,8,0,12],[2,0,2,5],[2,8,2,9],[3,0,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,8,3,9],[5,0,5,1],[5,5,7,5],[6,0,6,1],[6,8,7,12],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[10,5,15,5],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,5],[17,0,17,5],[18,0,18,1],[45,0,45,4],[84,1,85,7],[86,1,86,7],[91,0,91,6],[94,5,99,5],[101,5,110,5],[129,0,131,6]]}
["Discount Payback Period Calculation:",{"$nulls":7},"Discount Payback Period Result: FEMP Project"]
[{"$nulls":8},"First Positive Savings:",null,{"$f":"MIN(IF(H49:H82>0, H49:H82))","v":0}]
["Table DPP1: CALCULATION OF DIFFERENTIAL AMOUNTS (IN THOUSANDS)",{"$nulls":7},"PAYBACK PERIOD:",null,{"$f":"MATCH(K2,H49:H82,1)","v":31}]
["Category:",null,"Lower-First-Cost Option","Higher-First-Cost Option","Differential Amount","Notes",null,null,"FISCAL YEAR OF DISCOUNT PAYBACK:",null,{"$f":"'PID & Cash Flow'!B5+'Discount Payback Period'!K3","v":31}]
[]
["Initial Investment:",null,{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,'PID & Cash Flow'!I48, 'PID & Cash Flow'!I6)","v":0},{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,'PID & Cash Flow'!I6, 'PID & Cash Flow'!I48)","v":0},{"$f":"C6-D6","v":0},"In dollars at time of Base Date (BD)."]
["Total Energy:",null,{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,('PID & Cash Flow'!I49+'PID & Cash Flow'!I51),('PID & Cash Flow'!I7+'PID & Cash Flow'!I9))","v":0},{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,('PID & Cash Flow'!I7+'PID & Cash Flow'!I9),('PID & Cash Flow'!I49+'PID & Cash Flow'!I51))","v":0},{"$f":"C7-D7","v":0},{"$nulls":3},"Note: Discount payback period measures the time of recovery to meet initial investment costs."]
["OM & R:",null,{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,'PID & Cash Flow'!I50,'PID & Cash Flow'!I8)","v":0},{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,'PID & Cash Flow'!I8,'PID & Cash Flow'!I50)","v":0},0]
["Water:",null,{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,'PID & Cash Flow'!I52,'PID & Cash Flow'!I10)","v":0},{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,'PID & Cash Flow'!I10,'PID & Cash Flow'!I52)","v":0},0]
["Sum of Other Annual Costs:",null,{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,SUM('PID & Cash Flow'!I53:I55),SUM('PID & Cash Flow'!I11:I13))","v":0},{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,SUM('PID & Cash Flow'!I11:I13),SUM('PID & Cash Flow'!I53:I55))","v":0},0,"Gas/Elec Cost includes natural gas."]
[{"$nulls":4},0,"User fills in one-time cost of same type. Place name in category column, and cost in appropriate column."]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Resale/Salvage",null,{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48,SUM('PID & Cash Flow'!I63:I64),SUM('PID & Cash Flow'!I19:I20))","v":0},{"$f":"IF('PID & Cash Flow'!I6>'PID & Cash Flow'!I48, SUM('PID & Cash Flow'!I19:I20),SUM('PID & Cash Flow'!I63:I64))","v":0},0]
[]
["Note: The differential amounts above will be used in Table DPP3 below"]
{"$rows_empty":27}
["Table DPP2: DOE CALCULATIONS (IN THOUSANDS)"]
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8"]
["Service Year","Annual Energy Savings","Change in OM&R, Water, and Other","Change in Capital Replacements","Present Value (PV) Savings DOE","Cumulative PV Savings","Change in PV Initial Investment","PV net savings"]
[{"$f":"'PID & Cash Flow'!B5","v":0},{"$f":"IF(AND(General!$K$28>0,General!K39>0),B95*AVERAGE(C95,D95),B95*C95)","v":0},{"$f":"($E$8+$E$9+$E$10)*H95","v":0},{"$f":"E95*G95","v":0},{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"Table3[[#This Row],[Column5]]","v":0},{"$f":"$E$6*G95","v":0},{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[{"$f":"A49+1","v":1},{"$f":"IF(AND(General!$K$28>0,General!K40>0),B96*AVERAGE(C96,D96),B96*C96)","v":0},{"$f":"($E$8+$E$9+$E$10)*H96","v":0},{"$f":"E96*G96","v":0},{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F49+Table3[[#This Row],[Column5]]","v":0},{"$f":"$E$6*G96","v":0},{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[{"$f":"A50+1","v":2},{"$f":"IF(AND(General!$K$28>0,General!K41>0),B97*AVERAGE(C97,D97),B97*C97)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F50+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[3,{"$f":"IF(AND(General!$K$28>0,General!K42>0),B98*AVERAGE(C98,D98),B98*C98)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F51+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[4,{"$f":"IF(AND(General!$K$28>0,General!K43>0),B99*AVERAGE(C99,D99),B99*C99)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F52+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[5,{"$f":"IF(AND(General!$K$28>0,General!K44>0),B100*AVERAGE(C100,D100),B100*C100)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F53+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[6,{"$f":"IF(AND(General!$K$28>0,General!K45>0),B101*AVERAGE(C101,D101),B101*C101)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F54+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[7,{"$f":"IF(AND(General!$K$28>0,General!K46>0),B102*AVERAGE(C102,D102),B102*C102)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F55+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[8,{"$f":"IF(AND(General!$K$28>0,General!K47>0),B103*AVERAGE(C103,D103),B103*C103)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F56+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[9,{"$f":"IF(AND(General!$K$28>0,General!K48>0),B104*AVERAGE(C104,D104),B104*C104)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F57+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[10,{"$f":"IF(AND(General!$K$28>0,General!K49>0),B105*AVERAGE(C105,D105),B105*C105)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F58+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[11,{"$f":"IF(AND(General!$K$28>0,General!K50>0),B106*AVERAGE(C106,D106),B106*C106)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F59+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[12,{"$f":"IF(AND(General!$K$28>0,General!K51>0),B107*AVERAGE(C107,D107),B107*C107)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F60+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[13,{"$f":"IF(AND(General!$K$28>0,General!K52>0),B108*AVERAGE(C108,D108),B108*C108)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F61+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[14,{"$f":"IF(AND(General!$K$28>0,General!K53>0),B109*AVERAGE(C109,D109),B109*C109)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F62+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[15,{"$f":"IF(AND(General!$K$28>0,General!K54>0),B110*AVERAGE(C110,D110),B110*C110)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F63+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[16,{"$f":"IF(AND(General!$K$28>0,General!K55>0),B111*AVERAGE(C111,D111),B111*C111)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F64+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[17,{"$f":"IF(AND(General!$K$28>0,General!K56>0),B112*AVERAGE(C112,D112),B112*C112)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F65+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[18,{"$f":"IF(AND(General!$K$28>0,General!K57>0),B113*AVERAGE(C113,D113),B113*C113)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F66+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[19,{"$f":"IF(AND(General!$K$28>0,General!K58>0),B114*AVERAGE(C114,D114),B114*C114)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F67+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[20,{"$f":"IF(AND(General!$K$28>0,General!K59>0),B115*AVERAGE(C115,D115),B115*C115)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F68+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[21,{"$f":"IF(AND(General!$K$28>0,General!K60>0),B116*AVERAGE(C116,D116),B116*C116)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F69+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[22,{"$f":"IF(AND(General!$K$28>0,General!K61>0),B117*AVERAGE(C117,D117),B117*C117)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F70+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[{"$f":"A71+1","v":23},{"$f":"IF(AND(General!$K$28>0,General!K62>0),B118*AVERAGE(C118,D118),B118*C118)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F71+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[24,{"$f":"IF(AND(General!$K$28>0,General!K63>0),B119*AVERAGE(C119,D119),B119*C119)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F72+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[25,{"$f":"IF(AND(General!$K$28>0,General!K64>0),B120*AVERAGE(C120,D120),B120*C120)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F73+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[26,{"$f":"IF(AND(General!$K$28>0,General!K65>0),B121*AVERAGE(C121,D121),B121*C121)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F74+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[27,{"$f":"IF(AND(General!$K$28>0,General!K66>0),B122*AVERAGE(C122,D122),B122*C122)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F75+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[28,{"$f":"IF(AND(General!$K$28>0,General!K67>0),B123*AVERAGE(C123,D123),B123*C123)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F76+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[{"$f":"A77+1","v":29},{"$f":"IF(AND(General!$K$28>0,General!K68>0),B124*AVERAGE(C124,D124),B124*C124)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F77+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[30,{"$f":"IF(AND(General!$K$28>0,General!K69>0),B125*AVERAGE(C125,D125),B125*C125)","v":0},0,0,{"$f":"SUM(Table3[[#This Row],[Column2]:[Column4]])","v":0},{"$f":"F78+Table3[[#This Row],[Column5]]","v":0},0,{"$f":"SUM(Table3[[#This Row],[Column6]:[Column7]])","v":0}]
[]
[]
[]
["End of Lifetime"]
[]
["Notes:","Use tables Ca-4 through Ca-5 of the Energy Price Indices and Discount Factors LCCA 2019, Annual Supplement to Handbook 135 (page 39) to calculate annual energy savings."]
[]
[null,"https://www.nist.gov/publications/energy-price-indices-and-discount-factors-life-cycle-cost-analysis-150-2019-annual"]
[]
[]
[]
[]
["Table DPP3: CALCULATE COMPONENTS OF DPP CALCULATION TABLE ABOVE"]
[]
["Year","Energy Savings","Fuel Index - Commercial Electricity (2019)","Fuel Index - Commercial Natural Gas (2019)","Other One-Time Cost Differentials","<-- Notes","SPV Factor Index DOE Discount Rate (2019)","UPV Factor Index DOE Discount Rate (2019)"]
[2019,{"$f":"$E$7","v":0},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},null,"User enters differential amount (Table DPP1, Column E) into correct year. ",0.971,0.971]
[{"$f":"A95+1","v":2020},0,0.96,1.01,null,null,0.971,0.971]
[{"$f":"A96+1","v":2021},0,0.93,1.02,null,null,0.943,1.913]
[2022,0,0.94,1.03,null,null,0.915,2.829]
[2023,0,0.95,1.05,null,null,0.888,3.717]
[2024,0,0.96,1.06,null,null,0.863,{"v":4.58,"d":"4.580"}]
[2025,0,0.98,1.09,null,null,0.837,5.417]
[2026,0,{"v":1,"d":"1.00"},{"v":1.1,"d":"1.10"},null,"A negative value is shown inside parentheses, and must be entered as negative in the input section.",0.813,{"v":6.23,"d":"6.230"}]
[2027,0,{"v":1,"d":"1.00"},1.11,null,null,0.789,{"v":1.02,"d":"1.020"}]
[2028,0,{"v":1,"d":"1.00"},1.12,null,null,0.766,7.786]
[2029,0,{"v":1,"d":"1.00"},1.23,null,null,0.744,{"v":8.53,"d":"8.530"}]
[2030,0,1.01,1.27,null,null,0.722,9.253]
[2031,0,1.02,1.29,null,null,0.701,9.954]
[2032,0,1.02,{"v":1.3,"d":"1.30"},null,null,0.681,10.635]
[2033,0,1.03,1.31,null,null,0.661,11.296]
[2034,0,1.02,1.32,null,null,0.642,11.938]
[2035,0,1.02,1.33,null,null,0.623,12.561]
[2036,0,1.03,1.34,null,null,0.605,13.166]
[2037,0,1.03,1.34,null,null,0.587,13.754]
[2038,0,1.03,1.35,null,null,{"v":0.57,"d":"0.570"},14.324]
[2039,0,1.02,1.35,null,null,0.554,14.877]
[2040,0,1.02,1.36,null,null,0.538,15.415]
[2041,0,1.02,1.36,null,null,0.522,15.937]
[2042,0,1.01,1.37,null,null,0.507,16.444]
[{"$f":"A118+1","v":2043},0,1.01,1.38,null,null,0.492,16.936]
[2044,0,{"v":1,"d":"1.00"},1.39,null,null,0.478,17.413]
[2045,0,{"v":1,"d":"1.00"},{"v":1.4,"d":"1.40"},null,null,0.464,17.877]
[2046,0,{"v":1,"d":"1.00"},1.41,null,null,{"v":0.45,"d":"0.450"},18.327]
[2047,0,{"v":1,"d":"1.00"},1.42,null,null,0.437,18.764]
[2048,0,{"v":1,"d":"1.00"},1.43,null,null,0.424,19.188]
[2049,0,0.99,1.45,null,null,0.412,{"v":19.6,"d":"19.600"}]
[]
[]
[]
[]
["Use Tables od Section A of the Energy Price Indices and Discount Factors LCCA 2019, Annual Supplement to Handbook 135 (page 8) to find SPV and UPV factors."]

{"sheet":"Summary","index":4,"n_rows":139,"n_cols":6,"rows_kept":139,"merged":[[0,0,0,2],[2,0,2,1],[8,0,9,0],[8,1,9,1],[11,0,13,0],[11,1,13,1],[16,0,16,1],[17,0,18,2],[19,0,28,2],[31,0,31,1],[32,1,32,2],[33,1,33,2],[38,2,39,2],[66,0,66,1],[89,0,89,1],[93,0,93,1],[94,0,94,1],[97,0,97,1],[98,0,98,1],[99,0,99,1]]}
["SUMMARY OF LIFE-CYCLE COST ANALYSIS"]
[]
["PROJECT IDENTIFICATION"]
["Project Name:",{"$f":"'PID & Cash Flow'!B4","v":0}]
["Fiscal year:",{"$f":"'PID & Cash Flow'!B5","v":0}]
["Location: ",{"$f":"'PID & Cash Flow'!B6","v":0}]
["Base Date (BD):",{"$f":"'PID & Cash Flow'!B7","v":"00:00:00"}]
["Service Date (SD):",{"$f":"'PID & Cash Flow'!B8","v":"00:00:00"}]
["Design feature to be Evaluated:",{"$f":"'PID & Cash Flow'!B9:B10","v":0}]
[]
["List Constraints:",{"$f":"'PID & Cash Flow'!B11","v":0}]
["Energy/Water Conservation Study? (FEMP)","Yes"]
[]
[]
[]
[]
["BASE CASE AND ALTERNATIVES"]
["Name and describe base case and alternatives to be analyzed. Include any relevent assumptions:"]
[]
[{"$f":"'PID & Cash Flow'!A21","v":0}]
{"$rows_empty":11}
["GENERAL INFORMATION:"]
["Name of Analyst:",{"$f":"'PID & Cash Flow'!B33:C33","v":0}]
["Phone Number:",{"$f":"'PID & Cash Flow'!B34:C34","v":0}]
["Z-Number:",{"$f":"'PID & Cash Flow'!B35","v":0}]
["Date of Study Completion:",{"$f":"'PID & Cash Flow'!B36","v":"00:00:00"}]
[]
["KEY DATES"]
["Years of Life:",{"$f":"'PID & Cash Flow'!B39","v":0}]
["BD:",{"$f":"'PID & Cash Flow'!B40","v":"00:00:00"}]
["SD:",{"$f":"'PID & Cash Flow'!B41","v":"00:00:00"}]
["End of Study:",{"$f":"'PID & Cash Flow'!B42","v":"00:00:00"}]
[]
[]
[{"$nulls":5},1]
{"$rows_empty":21}
["Total Case A Present Value Life Cycle Costs:",null,{"$f":"'SIR Ratio'!F37","v":0}]
{"$rows_empty":22}
["Total Case B Present Value Life Cycle Costs:",null,{"$f":"'SIR Ratio'!F82","v":0}]
[]
[{"$nulls":5},2]
[]
["SAVINGS-TO-INVESTMENT RATIO:"]
["Savings-to-Investments Ratio (SIR):",null,{"$f":"'SIR Ratio'!E116","v":{"$error":"#DIV/0!"}}]
[]
[]
["DISCOUNT PAYBACK PERIOD: FEMP"]
["Discount Payback Period:",null,{"$f":"'Discount Payback Period'!K3","v":31}]
["Fiscal year of Discount Payback:",null,{"$f":"'Discount Payback Period'!K4","v":31}]
{"$rows_empty":38}
[{"$nulls":5},3]