{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","CRRS Template","15 Year Example"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":10,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions for Completing KHC's Capital Reserve Replacement Schedule "]
[]
[null,"WHO SHOULD COMPLETE THIS WORKSHEET:"]
[null,"▪  Project Architect."]
[null,"▪  Someone otherwise qualified per KHC guidelines to complete a PCNA."]
[]
[null,"HOW THIS WORKSHEET WILL BE USED:"]
[null,"▪  This worksheet will be used by KHC during up-front project underwriting AND long-term asset management."]
[null,"▪  This spreadsheet must be consistent with the submitted PCNA or Capital Needs Assessment."]
[null,"▪  Applicants seeking KHC multifamily financing and funding will transfer the \"Total Capital Needs\" from this CRRS sheet to the KHC Underwriting Model.  These numbers must match."]
[]
[null,"FILLING OUT THE CRRS:"]
[null,"1) Project - Enter the project name."]
[null,"2) Address - Enter the project address."]
[null,"3) Number of Units - Enter the total number of units in the project.  "]
[null,"4) Number of Buildings - Total buildings in the project.  This would include non unit buildings such as standalone office buildings."]
[null,"5) Project age - The project's age since original construction.  If the project is to be new construction, enter \"0.\""]
[null,"6) KHC Loan Term - For KHC funding other than tax credits, enter the term of the KHC loan.  If you are requesting multiple loans, enter the term of the longest one.  Tax Credit-only projects should enter 15 years."]
[null,"7) Inflation Factor - Preset and is not to be changed."]
[null,"8) Annual Reserve Per Unit - The initial annual reserve payment to be paid each year.  This is not a monthly amount, even if you will make smaller monthly payments."]
[null,"9) % Increase in Annual Reserve Payment - A minimum of 3%.  Normally not adjusted but it does allow adjustment up if you want to propose a higher annual increase."]
[null,"10) Beginning Balance - Beginning balance of the reserve account.  Does not include the first year's annual payment.  This is an initial deposit to the account prior to start of operations."]
[null,"11) Name of Person Completing this Form - Self explanatory. "]
[null,"12) Qualifications/Credentials - Qualification requirements are located in the multifamily guidelines.  Enter how this person is qualified per the guidelines, and include the architect or engineer's license number and state in which the license was issued."]
[null,"13) Name of Company/Firm - Name of the company/firm for which the preparer works."]
[null,"14) Phone & Email - Enter this information for the person completing the form."]
[null,"15) Item - Enter specific items under the heading marked \"Item.\"  For example, you could enter \"Hot Water Heater.\""]
[null,"16) EUL - Enter the Estimated Useful Life of the item from the Fannie Mae Expected Useful Life tables."]
[null,"17) RUL - If this is a rehab and the listed item is not being replaced during rehab, list the Remaining Useful Life (RUL) as found in the PCNA.  If items (stoves, for example) have varying RULs, just enter them as different items."]
[null,"18) Quantity - Enter the quantity of the specific item."]
[null,"19) Cost Per - Enter cost of each unit of the specific item.  For example, if you have 24 stoves that cost $350 each, enter 350 (do not enter the dollar sign)."]
[null,"20) To add additional rows, Click the \"Insert\" button located in the heading row for the specifc section you are working on.  This will require you to \"Enable Content\" when prompted.  This will most likely be in a security warning at the top of the page and you will only have to do it once."]
[]
[null,"RESERVE ACCOUNT ANALYSIS (Section at botton of page):"]
[null,"17) Annual Interest on Reserve Account - This is preset to 2%.  KHC might consider allowing some change to this if we are not holding the account and you can verify why it should be different."]
[null,"18) General Notes - Enter any general, non cost-related notes that you feel are necessary for explanation purposes."]
[null,"19) Cost Notes - Enter any notes necessary to explain item costs, or refer to the PCNA or Capital Needs Assessment study."]
[]
[null,"RESERVE ACCOUNT ACCEPTABILITY:"]
[null,"▪  Specific requirements as to the acceptability of the projection balances are found in the current multifamily guidelines."]
[null,"▪  Variables that can be adjusted to produce an acceptable projection include:"]
[null," - KHC Loan Term"]
[null," - Annual Reserve Per Unit"]
[null," - Beginning Balance"]
[null," - Project specifics that create the need for the listed items."]
[null,"▪  In all cases where a Physical Capital Needs Assessment (PCNA) has been performed, it should be consistent with this projection."]

{"sheet":"CRRS Template","index":1,"n_rows":43,"n_cols":49,"rows_kept":43,"cut":false,"hidden":false,"merged":[[32,5,32,6],[42,1,42,6],[43,7,52,13],[43,15,52,21],[42,7,42,13],[42,15,42,21],[34,2,38,2],[9,1,10,2],[10,48,11,48],[31,5,31,6],[3,3,3,8],[3,17,3,21],[4,3,4,8],[4,17,4,21],[5,17,5,21],[6,17,6,18],[6,20,6,21],[5,7,5,8],[7,17,7,18],[7,19,7,20],[7,9,7,11],[7,12,7,13]]}
[]
[null,"Capital Reserve Replacement Schedule"]
[]
[null,null,"                                  Project:",null,null,null,null,null,null,null,null,"KHC Loan Term:",null,"Years",null,null,"Name of Person Completing this Form:"]
[null,null,"                                Address:",null,null,null,null,null,null,null,null,"Inflation Factor:",0.03,null,null,null,"Qualifications/Credentials:"]
[null,null,"Number of Units:",null,null,null,null,null,null,null,null,"Annual Reserve Per Unit:",null,null,null,null,"Name of Company/Firm:"]
[null,null,"Number of Buildings:",null,"(including office)",null,null,null,null,null,null,"% Increase in Annual Reserve Payment:",0.03,null,null,null,"Phone #:",null,null,"Email:"]
[null,null,"Project Age:",null,"(0 if new construction)",null,null,null,null,"Beginning Capital Reserve Balance:",null,null,null,null,null,null,"Professional License #:",null,null,"State of Licensure:"]
[]
[null,"\"Enable Content\" when Prompted"]
[null,null,null,null,null,null,"COST","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Total"]
[null,"#","ITEM","EUL","RUL","QUANTITY","PER",0,{"$f":"H12+1","v":1},{"$f":"I12+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,null,null,null,null,null,null,"Inflation Factor:",{"$f":"(1+$M$5)^(I12)","v":1.03},{"$f":"(1+$M$5)^(J12)","v":1.0609},1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,"Site Elements"]
[null,null,null,null,null,null,null,{"$f":"IF(E15>0,0,(F15*G15))","v":0},{"$f":"IF(OR((MOD(1-E15,D15)=0),E15=1),F15*G15*$I$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(2-E15,D15)=0),E15=2),F15*G15*$J$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(3-E15,D15)=0),E15=3),F15*G15*$K$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(4-E15,D15)=0),E15=4),F15*G15*$L$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(5-E15,D15)=0),E15=5),F15*G15*$M$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(6-E15,D15)=0),E15=6),F15*G15*$N$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(7-E15,D15)=0),E15=7),F15*G15*$O$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(8-E15,D15)=0),E15=8),F15*G15*$P$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(9-E15,D15)=0),E15=9),F15*G15*$Q$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(10-E15,D15)=0),E15=10),F15*G15*$R$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(11-E15,D15)=0),E15=11),F15*G15*$S$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(12-E15,D15)=0),E15=12),F15*G15*$T$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(13-E15,D15)=0),E15=13),F15*G15*$U$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(14-E15,D15)=0),E15=14),F15*G15*$V$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(15-E15,D15)=0),E15=15),F15*G15*$W$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(16-E15,D15)=0),E15=16),F15*G15*$X$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(17-E15,D15)=0),E15=17),F15*G15*$Y$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(18-E15,D15)=0),E15=18),F15*G15*$Z$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(19-E15,D15)=0),E15=19),F15*G15*$AA$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(20-E15,D15)=0),E15=20),F15*G15*$AB$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(21-E15,D15)=0),E15=21),F15*G15*$AC$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(22-E15,D15)=0),E15=22),F15*G15*$AD$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(23-E15,D15)=0),E15=23),F15*G15*$AE$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(24-E15,D15)=0),E15=24),F15*G15*$AF$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(25-E15,D15)=0),E15=25),F15*G15*$AG$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(26-E15,D15)=0),E15=26),F15*G15*$AH$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(27-E15,D15)=0),E15=27),F15*G15*$AI$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(28-E15,D15)=0),E15=28),F15*G15*$AJ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(29-E15,D15)=0),E15=29),F15*G15*$AK$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(30-E15,D15)=0),E15=30),F15*G15*$AL$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(31-E15,D15)=0),E15=31),F15*G15*$AM$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(32-E15,D15)=0),E15=32),F15*G15*$AN$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(33-E15,D15)=0),E15=33),F15*G15*$AO$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(34-E15,D15)=0),E15=34),F15*G15*$AP$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(35-E15,D15)=0),E15=35),F15*G15*$AQ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(36-E15,D15)=0),E15=36),F15*G15*$AR$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(37-E15,D15)=0),E15=37),F15*G15*$AS$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(38-E15,D15)=0),E15=38),F15*G15*$AT$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(39-E15,D15)=0),E15=39),F15*G15*$AU$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(40-E15,D15)=0),E15=40),F15*G15*$AV$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I15:AV15)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(E16>0,0,(F16*G16))","v":0},{"$f":"IF(OR((MOD(1-E16,D16)=0),E16=1),F16*G16*$I$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(2-E16,D16)=0),E16=2),F16*G16*$J$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(3-E16,D16)=0),E16=3),F16*G16*$K$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(4-E16,D16)=0),E16=4),F16*G16*$L$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(5-E16,D16)=0),E16=5),F16*G16*$M$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(6-E16,D16)=0),E16=6),F16*G16*$N$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(7-E16,D16)=0),E16=7),F16*G16*$O$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(8-E16,D16)=0),E16=8),F16*G16*$P$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(9-E16,D16)=0),E16=9),F16*G16*$Q$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(10-E16,D16)=0),E16=10),F16*G16*$R$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(11-E16,D16)=0),E16=11),F16*G16*$S$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(12-E16,D16)=0),E16=12),F16*G16*$T$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(13-E16,D16)=0),E16=13),F16*G16*$U$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(14-E16,D16)=0),E16=14),F16*G16*$V$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(15-E16,D16)=0),E16=15),F16*G16*$W$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(16-E16,D16)=0),E16=16),F16*G16*$X$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(17-E16,D16)=0),E16=17),F16*G16*$Y$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(18-E16,D16)=0),E16=18),F16*G16*$Z$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(19-E16,D16)=0),E16=19),F16*G16*$AA$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(20-E16,D16)=0),E16=20),F16*G16*$AB$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(21-E16,D16)=0),E16=21),F16*G16*$AC$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(22-E16,D16)=0),E16=22),F16*G16*$AD$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(23-E16,D16)=0),E16=23),F16*G16*$AE$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(24-E16,D16)=0),E16=24),F16*G16*$AF$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(25-E16,D16)=0),E16=25),F16*G16*$AG$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(26-E16,D16)=0),E16=26),F16*G16*$AH$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(27-E16,D16)=0),E16=27),F16*G16*$AI$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(28-E16,D16)=0),E16=28),F16*G16*$AJ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(29-E16,D16)=0),E16=29),F16*G16*$AK$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(30-E16,D16)=0),E16=30),F16*G16*$AL$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(31-E16,D16)=0),E16=31),F16*G16*$AM$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(32-E16,D16)=0),E16=32),F16*G16*$AN$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(33-E16,D16)=0),E16=33),F16*G16*$AO$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(34-E16,D16)=0),E16=34),F16*G16*$AP$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(35-E16,D16)=0),E16=35),F16*G16*$AQ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(36-E16,D16)=0),E16=36),F16*G16*$AR$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(37-E16,D16)=0),E16=37),F16*G16*$AS$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(38-E16,D16)=0),E16=38),F16*G16*$AT$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(39-E16,D16)=0),E16=39),F16*G16*$AU$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(40-E16,D16)=0),E16=40),F16*G16*$AV$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I16:AV16)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(E17>0,0,(F17*G17))","v":0},{"$f":"IF(OR((MOD(1-E17,D17)=0),E17=1),F17*G17*$I$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(2-E17,D17)=0),E17=2),F17*G17*$J$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(3-E17,D17)=0),E17=3),F17*G17*$K$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(4-E17,D17)=0),E17=4),F17*G17*$L$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(5-E17,D17)=0),E17=5),F17*G17*$M$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(6-E17,D17)=0),E17=6),F17*G17*$N$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(7-E17,D17)=0),E17=7),F17*G17*$O$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(8-E17,D17)=0),E17=8),F17*G17*$P$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(9-E17,D17)=0),E17=9),F17*G17*$Q$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(10-E17,D17)=0),E17=10),F17*G17*$R$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(11-E17,D17)=0),E17=11),F17*G17*$S$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(12-E17,D17)=0),E17=12),F17*G17*$T$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(13-E17,D17)=0),E17=13),F17*G17*$U$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(14-E17,D17)=0),E17=14),F17*G17*$V$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(15-E17,D17)=0),E17=15),F17*G17*$W$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(16-E17,D17)=0),E17=16),F17*G17*$X$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(17-E17,D17)=0),E17=17),F17*G17*$Y$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(18-E17,D17)=0),E17=18),F17*G17*$Z$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(19-E17,D17)=0),E17=19),F17*G17*$AA$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(20-E17,D17)=0),E17=20),F17*G17*$AB$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(21-E17,D17)=0),E17=21),F17*G17*$AC$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(22-E17,D17)=0),E17=22),F17*G17*$AD$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(23-E17,D17)=0),E17=23),F17*G17*$AE$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(24-E17,D17)=0),E17=24),F17*G17*$AF$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(25-E17,D17)=0),E17=25),F17*G17*$AG$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(26-E17,D17)=0),E17=26),F17*G17*$AH$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(27-E17,D17)=0),E17=27),F17*G17*$AI$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(28-E17,D17)=0),E17=28),F17*G17*$AJ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(29-E17,D17)=0),E17=29),F17*G17*$AK$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(30-E17,D17)=0),E17=30),F17*G17*$AL$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(31-E17,D17)=0),E17=31),F17*G17*$AM$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(32-E17,D17)=0),E17=32),F17*G17*$AN$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(33-E17,D17)=0),E17=33),F17*G17*$AO$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(34-E17,D17)=0),E17=34),F17*G17*$AP$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(35-E17,D17)=0),E17=35),F17*G17*$AQ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(36-E17,D17)=0),E17=36),F17*G17*$AR$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(37-E17,D17)=0),E17=37),F17*G17*$AS$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(38-E17,D17)=0),E17=38),F17*G17*$AT$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(39-E17,D17)=0),E17=39),F17*G17*$AU$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(40-E17,D17)=0),E17=40),F17*G17*$AV$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I17:AV17)","v":{"$error":"#DIV/0!"}}]
[null,"Exterior Building Elements"]
[null,null,null,null,null,null,null,{"$f":"IF(E19>0,0,(F19*G19))","v":0},{"$f":"IF(OR((MOD(1-E19,D19)=0),E19=1),F19*G19*$I$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(2-E19,D19)=0),E19=2),F19*G19*$J$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(3-E19,D19)=0),E19=3),F19*G19*$K$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(4-E19,D19)=0),E19=4),F19*G19*$L$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(5-E19,D19)=0),E19=5),F19*G19*$M$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(6-E19,D19)=0),E19=6),F19*G19*$N$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(7-E19,D19)=0),E19=7),F19*G19*$O$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(8-E19,D19)=0),E19=8),F19*G19*$P$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(9-E19,D19)=0),E19=9),F19*G19*$Q$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(10-E19,D19)=0),E19=10),F19*G19*$R$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(11-E19,D19)=0),E19=11),F19*G19*$S$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(12-E19,D19)=0),E19=12),F19*G19*$T$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(13-E19,D19)=0),E19=13),F19*G19*$U$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(14-E19,D19)=0),E19=14),F19*G19*$V$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(15-E19,D19)=0),E19=15),F19*G19*$W$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(16-E19,D19)=0),E19=16),F19*G19*$X$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(17-E19,D19)=0),E19=17),F19*G19*$Y$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(18-E19,D19)=0),E19=18),F19*G19*$Z$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(19-E19,D19)=0),E19=19),F19*G19*$AA$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(20-E19,D19)=0),E19=20),F19*G19*$AB$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(21-E19,D19)=0),E19=21),F19*G19*$AC$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(22-E19,D19)=0),E19=22),F19*G19*$AD$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(23-E19,D19)=0),E19=23),F19*G19*$AE$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(24-E19,D19)=0),E19=24),F19*G19*$AF$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(25-E19,D19)=0),E19=25),F19*G19*$AG$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(26-E19,D19)=0),E19=26),F19*G19*$AH$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(27-E19,D19)=0),E19=27),F19*G19*$AI$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(28-E19,D19)=0),E19=28),F19*G19*$AJ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(29-E19,D19)=0),E19=29),F19*G19*$AK$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(30-E19,D19)=0),E19=30),F19*G19*$AL$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(31-E19,D19)=0),E19=31),F19*G19*$AM$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(32-E19,D19)=0),E19=32),F19*G19*$AN$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(33-E19,D19)=0),E19=33),F19*G19*$AO$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(34-E19,D19)=0),E19=34),F19*G19*$AP$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(35-E19,D19)=0),E19=35),F19*G19*$AQ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(36-E19,D19)=0),E19=36),F19*G19*$AR$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(37-E19,D19)=0),E19=37),F19*G19*$AS$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(38-E19,D19)=0),E19=38),F19*G19*$AT$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(39-E19,D19)=0),E19=39),F19*G19*$AU$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(40-E19,D19)=0),E19=40),F19*G19*$AV$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I19:AV19)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Mechanical & Electrical"]
[null,null,null,null,null,null,null,{"$f":"IF(E22>0,0,(F22*G22))","v":0},{"$f":"IF(OR((MOD(1-E22,D22)=0),E22=1),F22*G22*$I$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(2-E22,D22)=0),E22=2),F22*G22*$J$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(3-E22,D22)=0),E22=3),F22*G22*$K$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(4-E22,D22)=0),E22=4),F22*G22*$L$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(5-E22,D22)=0),E22=5),F22*G22*$M$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(6-E22,D22)=0),E22=6),F22*G22*$N$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(7-E22,D22)=0),E22=7),F22*G22*$O$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(8-E22,D22)=0),E22=8),F22*G22*$P$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(9-E22,D22)=0),E22=9),F22*G22*$Q$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(10-E22,D22)=0),E22=10),F22*G22*$R$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(11-E22,D22)=0),E22=11),F22*G22*$S$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(12-E22,D22)=0),E22=12),F22*G22*$T$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(13-E22,D22)=0),E22=13),F22*G22*$U$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(14-E22,D22)=0),E22=14),F22*G22*$V$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(15-E22,D22)=0),E22=15),F22*G22*$W$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(16-E22,D22)=0),E22=16),F22*G22*$X$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(17-E22,D22)=0),E22=17),F22*G22*$Y$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(18-E22,D22)=0),E22=18),F22*G22*$Z$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(19-E22,D22)=0),E22=19),F22*G22*$AA$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(20-E22,D22)=0),E22=20),F22*G22*$AB$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(21-E22,D22)=0),E22=21),F22*G22*$AC$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(22-E22,D22)=0),E22=22),F22*G22*$AD$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(23-E22,D22)=0),E22=23),F22*G22*$AE$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(24-E22,D22)=0),E22=24),F22*G22*$AF$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(25-E22,D22)=0),E22=25),F22*G22*$AG$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(26-E22,D22)=0),E22=26),F22*G22*$AH$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(27-E22,D22)=0),E22=27),F22*G22*$AI$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(28-E22,D22)=0),E22=28),F22*G22*$AJ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(29-E22,D22)=0),E22=29),F22*G22*$AK$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(30-E22,D22)=0),E22=30),F22*G22*$AL$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(31-E22,D22)=0),E22=31),F22*G22*$AM$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(32-E22,D22)=0),E22=32),F22*G22*$AN$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(33-E22,D22)=0),E22=33),F22*G22*$AO$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(34-E22,D22)=0),E22=34),F22*G22*$AP$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(35-E22,D22)=0),E22=35),F22*G22*$AQ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(36-E22,D22)=0),E22=36),F22*G22*$AR$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(37-E22,D22)=0),E22=37),F22*G22*$AS$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(38-E22,D22)=0),E22=38),F22*G22*$AT$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(39-E22,D22)=0),E22=39),F22*G22*$AU$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(40-E22,D22)=0),E22=40),F22*G22*$AV$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I22:AV22)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(E23>0,0,(F23*G23))","v":0},{"$f":"IF(OR((MOD(1-E23,D23)=0),E23=1),F23*G23*$I$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(2-E23,D23)=0),E23=2),F23*G23*$J$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(3-E23,D23)=0),E23=3),F23*G23*$K$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(4-E23,D23)=0),E23=4),F23*G23*$L$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(5-E23,D23)=0),E23=5),F23*G23*$M$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(6-E23,D23)=0),E23=6),F23*G23*$N$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(7-E23,D23)=0),E23=7),F23*G23*$O$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(8-E23,D23)=0),E23=8),F23*G23*$P$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(9-E23,D23)=0),E23=9),F23*G23*$Q$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(10-E23,D23)=0),E23=10),F23*G23*$R$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(11-E23,D23)=0),E23=11),F23*G23*$S$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(12-E23,D23)=0),E23=12),F23*G23*$T$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(13-E23,D23)=0),E23=13),F23*G23*$U$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(14-E23,D23)=0),E23=14),F23*G23*$V$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(15-E23,D23)=0),E23=15),F23*G23*$W$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(16-E23,D23)=0),E23=16),F23*G23*$X$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(17-E23,D23)=0),E23=17),F23*G23*$Y$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(18-E23,D23)=0),E23=18),F23*G23*$Z$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(19-E23,D23)=0),E23=19),F23*G23*$AA$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(20-E23,D23)=0),E23=20),F23*G23*$AB$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(21-E23,D23)=0),E23=21),F23*G23*$AC$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(22-E23,D23)=0),E23=22),F23*G23*$AD$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(23-E23,D23)=0),E23=23),F23*G23*$AE$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(24-E23,D23)=0),E23=24),F23*G23*$AF$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(25-E23,D23)=0),E23=25),F23*G23*$AG$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(26-E23,D23)=0),E23=26),F23*G23*$AH$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(27-E23,D23)=0),E23=27),F23*G23*$AI$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(28-E23,D23)=0),E23=28),F23*G23*$AJ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(29-E23,D23)=0),E23=29),F23*G23*$AK$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(30-E23,D23)=0),E23=30),F23*G23*$AL$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(31-E23,D23)=0),E23=31),F23*G23*$AM$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(32-E23,D23)=0),E23=32),F23*G23*$AN$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(33-E23,D23)=0),E23=33),F23*G23*$AO$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(34-E23,D23)=0),E23=34),F23*G23*$AP$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(35-E23,D23)=0),E23=35),F23*G23*$AQ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(36-E23,D23)=0),E23=36),F23*G23*$AR$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(37-E23,D23)=0),E23=37),F23*G23*$AS$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(38-E23,D23)=0),E23=38),F23*G23*$AT$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(39-E23,D23)=0),E23=39),F23*G23*$AU$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(40-E23,D23)=0),E23=40),F23*G23*$AV$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I23:AV23)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Life, Safety & Fire Protection"]
[null,null,null,null,null,null,null,{"$f":"IF(E26>0,0,(F26*G26))","v":0},{"$f":"IF(OR((MOD(1-E26,D26)=0),E26=1),F26*G26*$I$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(2-E26,D26)=0),E26=2),F26*G26*$J$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(3-E26,D26)=0),E26=3),F26*G26*$K$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(4-E26,D26)=0),E26=4),F26*G26*$L$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(5-E26,D26)=0),E26=5),F26*G26*$M$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(6-E26,D26)=0),E26=6),F26*G26*$N$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(7-E26,D26)=0),E26=7),F26*G26*$O$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(8-E26,D26)=0),E26=8),F26*G26*$P$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(9-E26,D26)=0),E26=9),F26*G26*$Q$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(10-E26,D26)=0),E26=10),F26*G26*$R$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(11-E26,D26)=0),E26=11),F26*G26*$S$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(12-E26,D26)=0),E26=12),F26*G26*$T$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(13-E26,D26)=0),E26=13),F26*G26*$U$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(14-E26,D26)=0),E26=14),F26*G26*$V$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(15-E26,D26)=0),E26=15),F26*G26*$W$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(16-E26,D26)=0),E26=16),F26*G26*$X$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(17-E26,D26)=0),E26=17),F26*G26*$Y$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(18-E26,D26)=0),E26=18),F26*G26*$Z$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(19-E26,D26)=0),E26=19),F26*G26*$AA$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(20-E26,D26)=0),E26=20),F26*G26*$AB$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(21-E26,D26)=0),E26=21),F26*G26*$AC$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(22-E26,D26)=0),E26=22),F26*G26*$AD$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(23-E26,D26)=0),E26=23),F26*G26*$AE$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(24-E26,D26)=0),E26=24),F26*G26*$AF$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(25-E26,D26)=0),E26=25),F26*G26*$AG$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(26-E26,D26)=0),E26=26),F26*G26*$AH$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(27-E26,D26)=0),E26=27),F26*G26*$AI$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(28-E26,D26)=0),E26=28),F26*G26*$AJ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(29-E26,D26)=0),E26=29),F26*G26*$AK$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(30-E26,D26)=0),E26=30),F26*G26*$AL$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(31-E26,D26)=0),E26=31),F26*G26*$AM$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(32-E26,D26)=0),E26=32),F26*G26*$AN$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(33-E26,D26)=0),E26=33),F26*G26*$AO$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(34-E26,D26)=0),E26=34),F26*G26*$AP$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(35-E26,D26)=0),E26=35),F26*G26*$AQ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(36-E26,D26)=0),E26=36),F26*G26*$AR$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(37-E26,D26)=0),E26=37),F26*G26*$AS$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(38-E26,D26)=0),E26=38),F26*G26*$AT$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(39-E26,D26)=0),E26=39),F26*G26*$AU$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(40-E26,D26)=0),E26=40),F26*G26*$AV$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I26:AV26)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Interior Elements"]
[null,null,null,null,null,null,null,{"$f":"IF(E29>0,0,(F29*G29))","v":0},{"$f":"IF(OR((MOD(1-E29,D29)=0),E29=1),F29*G29*$I$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(2-E29,D29)=0),E29=2),F29*G29*$J$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(3-E29,D29)=0),E29=3),F29*G29*$K$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(4-E29,D29)=0),E29=4),F29*G29*$L$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(5-E29,D29)=0),E29=5),F29*G29*$M$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(6-E29,D29)=0),E29=6),F29*G29*$N$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(7-E29,D29)=0),E29=7),F29*G29*$O$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(8-E29,D29)=0),E29=8),F29*G29*$P$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(9-E29,D29)=0),E29=9),F29*G29*$Q$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(10-E29,D29)=0),E29=10),F29*G29*$R$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(11-E29,D29)=0),E29=11),F29*G29*$S$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(12-E29,D29)=0),E29=12),F29*G29*$T$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(13-E29,D29)=0),E29=13),F29*G29*$U$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(14-E29,D29)=0),E29=14),F29*G29*$V$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(15-E29,D29)=0),E29=15),F29*G29*$W$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(16-E29,D29)=0),E29=16),F29*G29*$X$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(17-E29,D29)=0),E29=17),F29*G29*$Y$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(18-E29,D29)=0),E29=18),F29*G29*$Z$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(19-E29,D29)=0),E29=19),F29*G29*$AA$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(20-E29,D29)=0),E29=20),F29*G29*$AB$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(21-E29,D29)=0),E29=21),F29*G29*$AC$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(22-E29,D29)=0),E29=22),F29*G29*$AD$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(23-E29,D29)=0),E29=23),F29*G29*$AE$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(24-E29,D29)=0),E29=24),F29*G29*$AF$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(25-E29,D29)=0),E29=25),F29*G29*$AG$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(26-E29,D29)=0),E29=26),F29*G29*$AH$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(27-E29,D29)=0),E29=27),F29*G29*$AI$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(28-E29,D29)=0),E29=28),F29*G29*$AJ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(29-E29,D29)=0),E29=29),F29*G29*$AK$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(30-E29,D29)=0),E29=30),F29*G29*$AL$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(31-E29,D29)=0),E29=31),F29*G29*$AM$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(32-E29,D29)=0),E29=32),F29*G29*$AN$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(33-E29,D29)=0),E29=33),F29*G29*$AO$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(34-E29,D29)=0),E29=34),F29*G29*$AP$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(35-E29,D29)=0),E29=35),F29*G29*$AQ$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(36-E29,D29)=0),E29=36),F29*G29*$AR$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(37-E29,D29)=0),E29=37),F29*G29*$AS$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(38-E29,D29)=0),E29=38),F29*G29*$AT$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(39-E29,D29)=0),E29=39),F29*G29*$AU$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR((MOD(40-E29,D29)=0),E29=40),F29*G29*$AV$13,0)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I29:AV29)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Transfer these totals to the KHC Underwriting Model:","Total Capital Needs:",null,{"$f":"SUM(H15:H31)","v":0},{"$f":"SUM(IF(ISERROR(I15:I31),0,I15:I31))","v":0},{"$f":"SUM(IF(ISERROR(J15:J31),0,J15:J31))","v":0},{"$f":"SUM(IF(ISERROR(K15:K31),0,K15:K31))","v":0},{"$f":"SUM(IF(ISERROR(L15:L31),0,L15:L31))","v":0},{"$f":"SUM(IF(ISERROR(M15:M31),0,M15:M31))","v":0},{"$f":"SUM(IF(ISERROR(N15:N31),0,N15:N31))","v":0},{"$f":"SUM(IF(ISERROR(O15:O31),0,O15:O31))","v":0},{"$f":"SUM(IF(ISERROR(P15:P31),0,P15:P31))","v":0},{"$f":"SUM(IF(ISERROR(Q15:Q31),0,Q15:Q31))","v":0},{"$f":"SUM(IF(ISERROR(R15:R31),0,R15:R31))","v":0},{"$f":"SUM(IF(ISERROR(S15:S31),0,S15:S31))","v":0},{"$f":"SUM(IF(ISERROR(T15:T31),0,T15:T31))","v":0},{"$f":"SUM(IF(ISERROR(U15:U31),0,U15:U31))","v":0},{"$f":"SUM(IF(ISERROR(V15:V31),0,V15:V31))","v":0},{"$f":"SUM(IF(ISERROR(W15:W31),0,W15:W31))","v":0},{"$f":"SUM(IF(ISERROR(X15:X31),0,X15:X31))","v":0},{"$f":"SUM(IF(ISERROR(Y15:Y31),0,Y15:Y31))","v":0},{"$f":"SUM(IF(ISERROR(Z15:Z31),0,Z15:Z31))","v":0},{"$f":"SUM(IF(ISERROR(AA15:AA31),0,AA15:AA31))","v":0},{"$f":"SUM(IF(ISERROR(AB15:AB31),0,AB15:AB31))","v":0},{"$f":"SUM(IF(ISERROR(AC15:AC31),0,AC15:AC31))","v":0},{"$f":"SUM(IF(ISERROR(AD15:AD31),0,AD15:AD31))","v":0},{"$f":"SUM(IF(ISERROR(AE15:AE31),0,AE15:AE31))","v":0},{"$f":"SUM(IF(ISERROR(AF15:AF31),0,AF15:AF31))","v":0},{"$f":"SUM(IF(ISERROR(AG15:AG31),0,AG15:AG31))","v":0},{"$f":"SUM(IF(ISERROR(AH15:AH31),0,AH15:AH31))","v":0},{"$f":"SUM(IF(ISERROR(AI15:AI31),0,AI15:AI31))","v":0},{"$f":"SUM(IF(ISERROR(AJ15:AJ31),0,AJ15:AJ31))","v":0},{"$f":"SUM(IF(ISERROR(AK15:AK31),0,AK15:AK31))","v":0},{"$f":"SUM(IF(ISERROR(AL15:AL31),0,AL15:AL31))","v":0},{"$f":"SUM(IF(ISERROR(AM15:AM31),0,AM15:AM31))","v":0},{"$f":"SUM(IF(ISERROR(AN15:AN31),0,AN15:AN31))","v":0},{"$f":"SUM(IF(ISERROR(AO15:AO31),0,AO15:AO31))","v":0},{"$f":"SUM(IF(ISERROR(AP15:AP31),0,AP15:AP31))","v":0},{"$f":"SUM(IF(ISERROR(AQ15:AQ31),0,AQ15:AQ31))","v":0},{"$f":"SUM(IF(ISERROR(AR15:AR31),0,AR15:AR31))","v":0},{"$f":"SUM(IF(ISERROR(AS15:AS31),0,AS15:AS31))","v":0},{"$f":"SUM(IF(ISERROR(AT15:AT31),0,AT15:AT31))","v":0},{"$f":"SUM(IF(ISERROR(AU15:AU31),0,AU15:AU31))","v":0},{"$f":"SUM(IF(ISERROR(AV15:AV31),0,AV15:AV31))","v":0},{"$f":"SUM(IF(ISERROR(AW15:AW31),0,AW15:AW31))","v":0}]
[null,null,null,null,null,"Per Unit Amount",null,{"$f":"H32/D6","v":{"$error":"#DIV/0!"}},{"$f":"I32/D6","v":{"$error":"#DIV/0!"}},{"$f":"J32/D6","v":{"$error":"#DIV/0!"}},{"$f":"K32/D6","v":{"$error":"#DIV/0!"}},{"$f":"L32/D6","v":{"$error":"#DIV/0!"}},{"$f":"M32/D6","v":{"$error":"#DIV/0!"}},{"$f":"N32/D6","v":{"$error":"#DIV/0!"}},{"$f":"O32/D6","v":{"$error":"#DIV/0!"}},{"$f":"P32/D6","v":{"$error":"#DIV/0!"}},{"$f":"Q32/D6","v":{"$error":"#DIV/0!"}},{"$f":"R32/D6","v":{"$error":"#DIV/0!"}},{"$f":"S32/D6","v":{"$error":"#DIV/0!"}},{"$f":"T32/D6","v":{"$error":"#DIV/0!"}},{"$f":"U32/D6","v":{"$error":"#DIV/0!"}},{"$f":"V32/D6","v":{"$error":"#DIV/0!"}},{"$f":"W32/D6","v":{"$error":"#DIV/0!"}},{"$f":"X32/D6","v":{"$error":"#DIV/0!"}},{"$f":"Y32/D6","v":{"$error":"#DIV/0!"}},{"$f":"Z32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AA32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AB32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AC32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AD32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AE32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AF32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AG32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AH32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AI32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AJ32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AK32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AL32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AM32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AN32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AO32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AP32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AQ32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AR32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AS32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AT32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AU32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AV32/D6","v":{"$error":"#DIV/0!"}},{"$f":"AW32/D6","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30","Year 31","Year 32","Year 33","Year 34","Year 35","Year 36","Year 37","Year 38","Year 39","Year 40"]
[null,null,"Reserve Account Analysis",null,null,null,"Beginning of the year balance:",{"$f":"M8","v":0},{"$f":"H41","v":0},{"$f":"I41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Annual reserve deposits:",null,{"$f":"$M$6*$D$6","v":0},{"$f":"$I$36*I13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Capital needs:",null,{"$f":"I32*-1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Annual net change:",null,{"$f":"I36+I37","v":0},{"$f":"J36+J37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Sub-Total:",{"$f":"H35+H36-H37","v":0},{"$f":"SUM(I35:I37)","v":0},{"$f":"SUM(J35:J37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Annual Interest on Reserve Account:",0.02,0,{"$f":"IF(H41>0,$G$40*H41,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(W41>0,$G$40*W41,0)","v":0},{"$f":"IF(X41>0,$G$40*X41,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"End of the year balance:",{"$f":"H39+H40","v":0},{"$f":"I39+I40","v":0},{"$f":"J39+J40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"General Notes",null,null,null,null,null,null,null,"Cost Notes"]

{"sheet":"15 Year Example","index":2,"n_rows":79,"n_cols":115,"rows_kept":79,"cut":false,"hidden":false,"merged":[[10,48,11,48],[66,5,66,6],[67,5,67,6],[9,1,10,2],[78,7,88,13],[77,7,77,13],[78,15,88,21],[77,15,77,21],[66,1,66,4],[1,1,1,6],[7,14,7,16],[7,17,7,18],[7,19,7,20],[69,2,73,2],[3,17,3,21],[4,17,4,21],[5,17,5,21],[5,7,5,8],[7,9,7,11],[7,12,7,13],[3,3,3,8],[4,3,4,8],[6,17,6,18],[6,20,6,21]]}
[]
[null,"Capital Reserve Replacement Schedule"]
[]
[null,null,"                                  Project:","Lexington Gardens Apartments",null,null,null,null,null,null,null,"KHC Loan Term:",15,"Years",null,null,"Name of Person Completing this Form:","John Doe, AIA"]
[null,null,"                                Address:","120 Garden Lane, Lexington, KY 40503",null,null,null,null,null,null,null,"Inflation Factor:",0.03,null,null,null,"Qualifications/Credentials:","Project architect, 25 years commercial/residential experience"]
[null,null,"Number of Units:",24,null,null,null,null,null,null,null,"Annual Reserve Per Unit:",470,null,null,null,"Name of Company/Firm:","DesignsRUs"]
[null,null,"Number of Buildings:",2,"(including office)",null,null,null,null,null,null,"% Increase in Annual Reserve Payment:",0.03,null,null,null,"Phone #:","859-265-1234",null,"Email:","john@designsrus.com"]
[null,null,"Project Age:",0,"(0 if new construction)",null,null,null,null,"Beginning Capital Reserve Balance:",null,null,75000,null,"Professional License #:",null,null,840,null,"State of Licensure:",null,"KY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor:"]
[null,"See Instructions tab for help adding rows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year"]
[null,null,null,null,null,null,"COST","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year","Total",null,null,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":"BX11+1","v":2},{"$f":"BY11+1","v":3},{"$f":"BZ11+1","v":4},5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,"#","ITEM","EUL","RUL","QUANTITY","PER",0,{"$f":"H12+1","v":1},{"$f":"I12+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,null,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":"$M$5","v":0.03},null,{"$f":"1*(1+BV12)^1","v":1.03},{"$f":"1*(1+BV12)^2","v":1.0609},{"$f":"1*(1+BV12)^3","v":1.092727},{"$f":"1*(1+BV12)^4","v":1.1255088099999999},{"$f":"1*(1+BV12)^5","v":1.1592740742999998},{"$f":"1*(1+BV12)^6","v":1.1940522965289999},{"$f":"1*(1+BV12)^7","v":1.22987386542487},{"$f":"1*(1+BV12)^8","v":1.2667700813876159},{"$f":"1*(1+BV12)^9","v":1.3047731838292445},{"$f":"1*(1+BV12)^10","v":1.3439163793441218},{"$f":"1*(1+BV12)^11","v":1.3842338707244455},{"$f":"1*(1+BV12)^12","v":1.4257608868461786},{"$f":"1*(1+BV12)^13","v":1.4685337134515639},{"$f":"1*(1+BV12)^14","v":1.512589724855111},{"$f":"1*(1+BV12)^15","v":1.5579674166007644},{"$f":"1*(1+BV12)^16","v":1.6047064390987871},{"$f":"1*(1+BV12)^17","v":1.6528476322717507},{"$f":"1*(1+BV12)^18","v":1.7024330612399032},{"$f":"1*(1+BV12)^19","v":1.7535060530771003},{"$f":"1*(1+BV12)^20","v":1.8061112346694133},{"$f":"1*(1+BV12)^21","v":1.8602945717094954},{"$f":"1*(1+BV12)^22","v":1.9161034088607805},{"$f":"1*(1+BV12)^23","v":1.973586511126604},{"$f":"1*(1+BV12)^24","v":2.0327941064604018},{"$f":"1*(1+BV12)^25","v":2.0937779296542138},{"$f":"1*(1+BV12)^26","v":2.1565912675438406},{"$f":"1*(1+BV12)^27","v":2.2212890055701555},{"$f":"1*(1+BV12)^28","v":2.2879276757372602},{"$f":"1*(1+BV12)^29","v":2.3565655060093778},{"$f":"1*(1+BV12)^30","v":2.4272624711896591},{"$f":"1*(1+BV12)^31","v":2.5000803453253493},{"$f":"1*(1+BV12)^32","v":2.5750827556851092},{"$f":"1*(1+BV12)^33","v":2.6523352383556626},{"$f":"1*(1+BV12)^34","v":2.7319052955063321},{"$f":"1*(1+BV12)^35","v":2.8138624543715225},{"$f":"1*(1+BV12)^36","v":2.898278328002668},{"$f":"1*(1+BV12)^37","v":2.9852266778427476},{"$f":"1*(1+BV12)^38","v":3.0747834781780301},{"$f":"1*(1+BV12)^39","v":3.1670269825233714},{"$f":"1*(1+BV12)^40","v":3.262037791999072}]
[null,null,null,null,null,null,null,"Inflation Factor:",{"$f":"(1+$M$5)^(I12)","v":1.03},{"$f":"(1+$M$5)^(J12)","v":1.0609},1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072,null,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":"$M$5","v":0.03},null,{"$f":"1*(1+BV13)^1","v":1.03},{"$f":"1*(1+BV13)^2","v":1.0609},{"$f":"1*(1+BV13)^3","v":1.092727},{"$f":"1*(1+BV13)^4","v":1.1255088099999999},{"$f":"1*(1+BV13)^5","v":1.1592740742999998},{"$f":"1*(1+BV13)^6","v":1.1940522965289999},{"$f":"1*(1+BV13)^7","v":1.22987386542487},{"$f":"1*(1+BV13)^8","v":1.2667700813876159},{"$f":"1*(1+BV13)^9","v":1.3047731838292445},{"$f":"1*(1+BV13)^10","v":1.3439163793441218},{"$f":"1*(1+BV13)^11","v":1.3842338707244455},{"$f":"1*(1+BV13)^12","v":1.4257608868461786},{"$f":"1*(1+BV13)^13","v":1.4685337134515639},{"$f":"1*(1+BV13)^14","v":1.512589724855111},{"$f":"1*(1+BV13)^15","v":1.5579674166007644},{"$f":"1*(1+BV13)^16","v":1.6047064390987871},{"$f":"1*(1+BV13)^17","v":1.6528476322717507},{"$f":"1*(1+BV13)^18","v":1.7024330612399032},{"$f":"1*(1+BV13)^19","v":1.7535060530771003},{"$f":"1*(1+BV13)^20","v":1.8061112346694133},{"$f":"1*(1+BV13)^21","v":1.8602945717094954},{"$f":"1*(1+BV13)^22","v":1.9161034088607805},{"$f":"1*(1+BV13)^23","v":1.973586511126604},{"$f":"1*(1+BV13)^24","v":2.0327941064604018},{"$f":"1*(1+BV13)^25","v":2.0937779296542138},{"$f":"1*(1+BV13)^26","v":2.1565912675438406},{"$f":"1*(1+BV13)^27","v":2.2212890055701555},{"$f":"1*(1+BV13)^28","v":2.2879276757372602},{"$f":"1*(1+BV13)^29","v":2.3565655060093778},{"$f":"1*(1+BV13)^30","v":2.4272624711896591},{"$f":"1*(1+BV13)^31","v":2.5000803453253493},{"$f":"1*(1+BV13)^32","v":2.5750827556851092},{"$f":"1*(1+BV13)^33","v":2.6523352383556626},{"$f":"1*(1+BV13)^34","v":2.7319052955063321},{"$f":"1*(1+BV13)^35","v":2.8138624543715225},{"$f":"1*(1+BV13)^36","v":2.898278328002668},{"$f":"1*(1+BV13)^37","v":2.9852266778427476},{"$f":"1*(1+BV13)^38","v":3.0747834781780301},{"$f":"1*(1+BV13)^39","v":3.1670269825233714},{"$f":"1*(1+BV13)^40","v":3.262037791999072}]
[null,"Site Elements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Re-grade and landscape",50,null,1,4800,{"$f":"IF(E15>0,0,(F15*G15))","v":4800},{"$f":"IF(OR((MOD(1-E15,D15)=0),E15=1),F15*G15*$I$13,0)","v":0},{"$f":"IF(OR((MOD(2-E15,D15)=0),E15=2),F15*G15*$J$13,0)","v":0},{"$f":"IF(OR((MOD(3-E15,D15)=0),E15=3),F15*G15*$K$13,0)","v":0},{"$f":"IF(OR((MOD(4-E15,D15)=0),E15=4),F15*G15*$L$13,0)","v":0},{"$f":"IF(OR((MOD(5-E15,D15)=0),E15=5),F15*G15*$M$13,0)","v":0},{"$f":"IF(OR((MOD(6-E15,D15)=0),E15=6),F15*G15*$N$13,0)","v":0},{"$f":"IF(OR((MOD(7-E15,D15)=0),E15=7),F15*G15*$O$13,0)","v":0},{"$f":"IF(OR((MOD(8-E15,D15)=0),E15=8),F15*G15*$P$13,0)","v":0},{"$f":"IF(OR((MOD(9-E15,D15)=0),E15=9),F15*G15*$Q$13,0)","v":0},{"$f":"IF(OR((MOD(10-E15,D15)=0),E15=10),F15*G15*$R$13,0)","v":0},{"$f":"IF(OR((MOD(11-E15,D15)=0),E15=11),F15*G15*$S$13,0)","v":0},{"$f":"IF(OR((MOD(12-E15,D15)=0),E15=12),F15*G15*$T$13,0)","v":0},{"$f":"IF(OR((MOD(13-E15,D15)=0),E15=13),F15*G15*$U$13,0)","v":0},{"$f":"IF(OR((MOD(14-E15,D15)=0),E15=14),F15*G15*$V$13,0)","v":0},{"$f":"IF(OR((MOD(15-E15,D15)=0),E15=15),F15*G15*$W$13,0)","v":0},{"$f":"IF(OR((MOD(16-E15,D15)=0),E15=16),F15*G15*$X$13,0)","v":0},{"$f":"IF(OR((MOD(17-E15,D15)=0),E15=17),F15*G15*$Y$13,0)","v":0},{"$f":"IF(OR((MOD(18-E15,D15)=0),E15=18),F15*G15*$Z$13,0)","v":0},{"$f":"IF(OR((MOD(19-E15,D15)=0),E15=19),F15*G15*$AA$13,0)","v":0},{"$f":"IF(OR((MOD(20-E15,D15)=0),E15=20),F15*G15*$AB$13,0)","v":0},{"$f":"IF(OR((MOD(21-E15,D15)=0),E15=21),F15*G15*$AC$13,0)","v":0},{"$f":"IF(OR((MOD(22-E15,D15)=0),E15=22),F15*G15*$AD$13,0)","v":0},{"$f":"IF(OR((MOD(23-E15,D15)=0),E15=23),F15*G15*$AE$13,0)","v":0},{"$f":"IF(OR((MOD(24-E15,D15)=0),E15=24),F15*G15*$AF$13,0)","v":0},{"$f":"IF(OR((MOD(25-E15,D15)=0),E15=25),F15*G15*$AG$13,0)","v":0},{"$f":"IF(OR((MOD(26-E15,D15)=0),E15=26),F15*G15*$AH$13,0)","v":0},{"$f":"IF(OR((MOD(27-E15,D15)=0),E15=27),F15*G15*$AI$13,0)","v":0},{"$f":"IF(OR((MOD(28-E15,D15)=0),E15=28),F15*G15*$AJ$13,0)","v":0},{"$f":"IF(OR((MOD(29-E15,D15)=0),E15=29),F15*G15*$AK$13,0)","v":0},{"$f":"IF(OR((MOD(30-E15,D15)=0),E15=30),F15*G15*$AL$13,0)","v":0},{"$f":"IF(OR((MOD(31-E15,D15)=0),E15=31),F15*G15*$AM$13,0)","v":0},{"$f":"IF(OR((MOD(32-E15,D15)=0),E15=32),F15*G15*$AN$13,0)","v":0},{"$f":"IF(OR((MOD(33-E15,D15)=0),E15=33),F15*G15*$AO$13,0)","v":0},{"$f":"IF(OR((MOD(34-E15,D15)=0),E15=34),F15*G15*$AP$13,0)","v":0},{"$f":"IF(OR((MOD(35-E15,D15)=0),E15=35),F15*G15*$AQ$13,0)","v":0},{"$f":"IF(OR((MOD(36-E15,D15)=0),E15=36),F15*G15*$AR$13,0)","v":0},{"$f":"IF(OR((MOD(37-E15,D15)=0),E15=37),F15*G15*$AS$13,0)","v":0},{"$f":"IF(OR((MOD(38-E15,D15)=0),E15=38),F15*G15*$AT$13,0)","v":0},{"$f":"IF(OR((MOD(39-E15,D15)=0),E15=39),F15*G15*$AU$13,0)","v":0},{"$f":"IF(OR((MOD(40-E15,D15)=0),E15=40),F15*G15*$AV$13,0)","v":0},{"$f":"SUM(I15:AV15)","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,0.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Parking lot repairs 7500 S.F.",5,3,1,1128,{"$f":"IF(E16>0,0,(F16*G16))","v":0},{"$f":"IF(OR((MOD(1-E16,D16)=0),E16=1),F16*G16*$I$13,0)","v":0},{"$f":"IF(OR((MOD(2-E16,D16)=0),E16=2),F16*G16*$J$13,0)","v":0},{"$f":"IF(OR((MOD(3-E16,D16)=0),E16=3),F16*G16*$K$13,0)","v":1232.5960560000001},{"$f":"IF(OR((MOD(4-E16,D16)=0),E16=4),F16*G16*$L$13,0)","v":0},{"$f":"IF(OR((MOD(5-E16,D16)=0),E16=5),F16*G16*$M$13,0)","v":0},{"$f":"IF(OR((MOD(6-E16,D16)=0),E16=6),F16*G16*$N$13,0)","v":0},{"$f":"IF(OR((MOD(7-E16,D16)=0),E16=7),F16*G16*$O$13,0)","v":0},{"$f":"IF(OR((MOD(8-E16,D16)=0),E16=8),F16*G16*$P$13,0)","v":1428.9166518052307},{"$f":"IF(OR((MOD(9-E16,D16)=0),E16=9),F16*G16*$Q$13,0)","v":0},{"$f":"IF(OR((MOD(10-E16,D16)=0),E16=10),F16*G16*$R$13,0)","v":0},{"$f":"IF(OR((MOD(11-E16,D16)=0),E16=11),F16*G16*$S$13,0)","v":0},{"$f":"IF(OR((MOD(12-E16,D16)=0),E16=12),F16*G16*$T$13,0)","v":0},{"$f":"IF(OR((MOD(13-E16,D16)=0),E16=13),F16*G16*$U$13,0)","v":1656.5060287733641},{"$f":"IF(OR((MOD(14-E16,D16)=0),E16=14),F16*G16*$V$13,0)","v":0},{"$f":"IF(OR((MOD(15-E16,D16)=0),E16=15),F16*G16*$W$13,0)","v":0},{"$f":"IF(OR((MOD(16-E16,D16)=0),E16=16),F16*G16*$X$13,0)","v":0},{"$f":"IF(OR((MOD(17-E16,D16)=0),E16=17),F16*G16*$Y$13,0)","v":0},{"$f":"IF(OR((MOD(18-E16,D16)=0),E16=18),F16*G16*$Z$13,0)","v":1920.3444930786109},{"$f":"IF(OR((MOD(19-E16,D16)=0),E16=19),F16*G16*$AA$13,0)","v":0},{"$f":"IF(OR((MOD(20-E16,D16)=0),E16=20),F16*G16*$AB$13,0)","v":0},{"$f":"IF(OR((MOD(21-E16,D16)=0),E16=21),F16*G16*$AC$13,0)","v":0},{"$f":"IF(OR((MOD(22-E16,D16)=0),E16=22),F16*G16*$AD$13,0)","v":0},{"$f":"IF(OR((MOD(23-E16,D16)=0),E16=23),F16*G16*$AE$13,0)","v":2226.2055845508094},{"$f":"IF(OR((MOD(24-E16,D16)=0),E16=24),F16*G16*$AF$13,0)","v":0},{"$f":"IF(OR((MOD(25-E16,D16)=0),E16=25),F16*G16*$AG$13,0)","v":0},{"$f":"IF(OR((MOD(26-E16,D16)=0),E16=26),F16*G16*$AH$13,0)","v":0},{"$f":"IF(OR((MOD(27-E16,D16)=0),E16=27),F16*G16*$AI$13,0)","v":0},{"$f":"IF(OR((MOD(28-E16,D16)=0),E16=28),F16*G16*$AJ$13,0)","v":2580.7824182316294},{"$f":"IF(OR((MOD(29-E16,D16)=0),E16=29),F16*G16*$AK$13,0)","v":0},{"$f":"IF(OR((MOD(30-E16,D16)=0),E16=30),F16*G16*$AL$13,0)","v":0},{"$f":"IF(OR((MOD(31-E16,D16)=0),E16=31),F16*G16*$AM$13,0)","v":0},{"$f":"IF(OR((MOD(32-E16,D16)=0),E16=32),F16*G16*$AN$13,0)","v":0},{"$f":"IF(OR((MOD(33-E16,D16)=0),E16=33),F16*G16*$AO$13,0)","v":2991.8341488651877},{"$f":"IF(OR((MOD(34-E16,D16)=0),E16=34),F16*G16*$AP$13,0)","v":0},{"$f":"IF(OR((MOD(35-E16,D16)=0),E16=35),F16*G16*$AQ$13,0)","v":0},{"$f":"IF(OR((MOD(36-E16,D16)=0),E16=36),F16*G16*$AR$13,0)","v":0},{"$f":"IF(OR((MOD(37-E16,D16)=0),E16=37),F16*G16*$AS$13,0)","v":0},{"$f":"IF(OR((MOD(38-E16,D16)=0),E16=38),F16*G16*$AT$13,0)","v":3468.3557633848181},{"$f":"IF(OR((MOD(39-E16,D16)=0),E16=39),F16*G16*$AU$13,0)","v":0},{"$f":"IF(OR((MOD(40-E16,D16)=0),E16=40),F16*G16*$AV$13,0)","v":0},{"$f":"SUM(I16:AV16)","v":17505.541144689651},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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Re-stripe parking 24 Stalls",10,null,1,240,{"$f":"IF(E17>0,0,(F17*G17))","v":240},0,0,0,0,0,0,0,0,0,322.53993104258922,0,0,0,0,0,0,0,0,0,433.4666963206592,0,0,0,0,0,0,0,0,0,582.54299308551822,0,0,0,0,0,0,0,0,0,782.8890700797773,2121.4386905285442,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Repave parking lots 7500 S. F.",25,null,1,5640,5640,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11808.907523249765,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11808.907523249765,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Handicap ramp maintenance",15,null,2,1500,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4673.9022498022932,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7281.7874135689772,0,0,0,0,0,0,0,0,0,0,11955.689663371271,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Replace 500 S.F. sidewalk",15,null,1,624,624,0,0,0,0,0,0,0,0,0,0,0,0,0,0,972.17166795887704,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1514.6117820223474,0,0,0,0,0,0,0,0,0,0,2486.7834499812243,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Building signage",15,null,1,750,750,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1168.4755624505733,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1820.4468533922443,0,0,0,0,0,0,0,0,0,0,2988.9224158428178,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Handicap signage",15,null,2,100,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,311.59348332015287,0,0,0,0,0,0,0,0,0,0,0,0,0,0,485.45249423793183,0,0,0,0,0,0,0,0,0,0,797.0459775580847,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Dumpster Enclosure 1000 L.F.",15,null,1,12000,12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18695.608999209173,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29127.149654275909,0,0,0,0,0,0,0,0,0,0,47822.758653485085,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Dumpster Pad 225 S. F.",20,null,1,912,912,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1647.1734460185048,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2974.9784663031537,4622.1519123216585,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Other",30,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,0.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,"Exterior Building Elements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Hardie Plank 11,575 S.F.",20,null,1,115752,{"$f":"IF(E27>0,0,(F27*G27))","v":115752},{"$f":"IF(OR((MOD(1-E27,D27)=0),E27=1),F27*G27*$I$13,0)","v":0},{"$f":"IF(OR((MOD(2-E27,D27)=0),E27=2),F27*G27*$J$13,0)","v":0},{"$f":"IF(OR((MOD(3-E27,D27)=0),E27=3),F27*G27*$K$13,0)","v":0},{"$f":"IF(OR((MOD(4-E27,D27)=0),E27=4),F27*G27*$L$13,0)","v":0},{"$f":"IF(OR((MOD(5-E27,D27)=0),E27=5),F27*G27*$M$13,0)","v":0},{"$f":"IF(OR((MOD(6-E27,D27)=0),E27=6),F27*G27*$N$13,0)","v":0},{"$f":"IF(OR((MOD(7-E27,D27)=0),E27=7),F27*G27*$O$13,0)","v":0},{"$f":"IF(OR((MOD(8-E27,D27)=0),E27=8),F27*G27*$P$13,0)","v":0},{"$f":"IF(OR((MOD(9-E27,D27)=0),E27=9),F27*G27*$Q$13,0)","v":0},{"$f":"IF(OR((MOD(10-E27,D27)=0),E27=10),F27*G27*$R$13,0)","v":0},{"$f":"IF(OR((MOD(11-E27,D27)=0),E27=11),F27*G27*$S$13,0)","v":0},{"$f":"IF(OR((MOD(12-E27,D27)=0),E27=12),F27*G27*$T$13,0)","v":0},{"$f":"IF(OR((MOD(13-E27,D27)=0),E27=13),F27*G27*$U$13,0)","v":0},{"$f":"IF(OR((MOD(14-E27,D27)=0),E27=14),F27*G27*$V$13,0)","v":0},{"$f":"IF(OR((MOD(15-E27,D27)=0),E27=15),F27*G27*$W$13,0)","v":0},{"$f":"IF(OR((MOD(16-E27,D27)=0),E27=16),F27*G27*$X$13,0)","v":0},{"$f":"IF(OR((MOD(17-E27,D27)=0),E27=17),F27*G27*$Y$13,0)","v":0},{"$f":"IF(OR((MOD(18-E27,D27)=0),E27=18),F27*G27*$Z$13,0)","v":0},{"$f":"IF(OR((MOD(19-E27,D27)=0),E27=19),F27*G27*$AA$13,0)","v":0},{"$f":"IF(OR((MOD(20-E27,D27)=0),E27=20),F27*G27*$AB$13,0)","v":209060.98763545393},{"$f":"IF(OR((MOD(21-E27,D27)=0),E27=21),F27*G27*$AC$13,0)","v":0},{"$f":"IF(OR((MOD(22-E27,D27)=0),E27=22),F27*G27*$AD$13,0)","v":0},{"$f":"IF(OR((MOD(23-E27,D27)=0),E27=23),F27*G27*$AE$13,0)","v":0},{"$f":"IF(OR((MOD(24-E27,D27)=0),E27=24),F27*G27*$AF$13,0)","v":0},{"$f":"IF(OR((MOD(25-E27,D27)=0),E27=25),F27*G27*$AG$13,0)","v":0},{"$f":"IF(OR((MOD(26-E27,D27)=0),E27=26),F27*G27*$AH$13,0)","v":0},{"$f":"IF(OR((MOD(27-E27,D27)=0),E27=27),F27*G27*$AI$13,0)","v":0},{"$f":"IF(OR((MOD(28-E27,D27)=0),E27=28),F27*G27*$AJ$13,0)","v":0},{"$f":"IF(OR((MOD(29-E27,D27)=0),E27=29),F27*G27*$AK$13,0)","v":0},{"$f":"IF(OR((MOD(30-E27,D27)=0),E27=30),F27*G27*$AL$13,0)","v":0},{"$f":"IF(OR((MOD(31-E27,D27)=0),E27=31),F27*G27*$AM$13,0)","v":0},{"$f":"IF(OR((MOD(32-E27,D27)=0),E27=32),F27*G27*$AN$13,0)","v":0},{"$f":"IF(OR((MOD(33-E27,D27)=0),E27=33),F27*G27*$AO$13,0)","v":0},{"$f":"IF(OR((MOD(34-E27,D27)=0),E27=34),F27*G27*$AP$13,0)","v":0},{"$f":"IF(OR((MOD(35-E27,D27)=0),E27=35),F27*G27*$AQ$13,0)","v":0},{"$f":"IF(OR((MOD(36-E27,D27)=0),E27=36),F27*G27*$AR$13,0)","v":0},{"$f":"IF(OR((MOD(37-E27,D27)=0),E27=37),F27*G27*$AS$13,0)","v":0},{"$f":"IF(OR((MOD(38-E27,D27)=0),E27=38),F27*G27*$AT$13,0)","v":0},{"$f":"IF(OR((MOD(39-E27,D27)=0),E27=39),F27*G27*$AU$13,0)","v":0},{"$f":"IF(OR((MOD(40-E27,D27)=0),E27=40),F27*G27*$AV$13,0)","v":377587.39849947655},{"$f":"SUM(I27:AV27)","v":586648.38613493042},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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Soffits 800 S.F.",15,null,1,3840,3840,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5982.5948797469355,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9320.6878893682915,0,0,0,0,0,0,0,0,0,0,15303.282769115227,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Breezeway 1100 S.F.",20,null,1,10992,10992,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19852.774691486189,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35856.319409653799,55709.094101139985,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Exterior Painting",5,null,1,12000,12000,0,0,0,0,13911.288891599997,0,0,0,0,16126.996552129462,0,0,0,0,18695.608999209173,0,0,0,0,21673.334816032959,0,0,0,0,25125.335155850567,0,0,0,0,29127.149654275909,0,0,0,0,33766.349452458271,0,0,0,0,39144.453503988865,197570.51702554521,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Roof replacement 9600 S.F.",20,null,2,9120,18240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32943.468920370098,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,59499.569326063072,92443.038246433163,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Refurbish stairs",15,null,2,6000,12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18695.608999209173,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29127.149654275909,0,0,0,0,0,0,0,0,0,0,47822.758653485085,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Replace stairs ",30,null,2,12000,24000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,58254.299308551817,0,0,0,0,0,0,0,0,0,0,58254.299308551817,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Awning ",10,null,4,4200,16800,0,0,0,0,0,0,0,0,0,22577.795172981245,0,0,0,0,0,0,0,0,0,30342.668742446142,0,0,0,0,0,0,0,0,0,40778.009515986276,0,0,0,0,0,0,0,0,0,54802.23490558441,148500.70833699807,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Exterior doors",15,null,48,175,8400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,13086.926299446421,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20389.004757993138,0,0,0,0,0,0,0,0,0,0,33475.931057439557,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Exterior Storm Screens",7,null,24,200,4800,0,0,0,0,0,0,5903.3945540393761,0,0,0,0,0,0,7260.4306793045325,0,0,0,0,0,0,8929.4139442055784,0,0,0,0,0,0,10982.05284353885,0,0,0,0,0,0,13506.539780983308,0,0,0,0,0,46581.831802071647,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Exterior windows per unit",20,null,24,1718,41232,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,74469.578427889253,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,134500.34223970573,208969.920667595,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Other",30,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,0.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,"Mechanical & Electrical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"HVAC Split System (3)",15,null,24,5000,{"$f":"IF(E40>0,0,(F40*G40))","v":120000},{"$f":"IF(OR((MOD(1-E40,D40)=0),E40=1),F40*G40*$I$13,0)","v":0},{"$f":"IF(OR((MOD(2-E40,D40)=0),E40=2),F40*G40*$J$13,0)","v":0},{"$f":"IF(OR((MOD(3-E40,D40)=0),E40=3),F40*G40*$K$13,0)","v":0},{"$f":"IF(OR((MOD(4-E40,D40)=0),E40=4),F40*G40*$L$13,0)","v":0},{"$f":"IF(OR((MOD(5-E40,D40)=0),E40=5),F40*G40*$M$13,0)","v":0},{"$f":"IF(OR((MOD(6-E40,D40)=0),E40=6),F40*G40*$N$13,0)","v":0},{"$f":"IF(OR((MOD(7-E40,D40)=0),E40=7),F40*G40*$O$13,0)","v":0},{"$f":"IF(OR((MOD(8-E40,D40)=0),E40=8),F40*G40*$P$13,0)","v":0},{"$f":"IF(OR((MOD(9-E40,D40)=0),E40=9),F40*G40*$Q$13,0)","v":0},{"$f":"IF(OR((MOD(10-E40,D40)=0),E40=10),F40*G40*$R$13,0)","v":0},{"$f":"IF(OR((MOD(11-E40,D40)=0),E40=11),F40*G40*$S$13,0)","v":0},{"$f":"IF(OR((MOD(12-E40,D40)=0),E40=12),F40*G40*$T$13,0)","v":0},{"$f":"IF(OR((MOD(13-E40,D40)=0),E40=13),F40*G40*$U$13,0)","v":0},{"$f":"IF(OR((MOD(14-E40,D40)=0),E40=14),F40*G40*$V$13,0)","v":0},{"$f":"IF(OR((MOD(15-E40,D40)=0),E40=15),F40*G40*$W$13,0)","v":186956.08999209173},{"$f":"IF(OR((MOD(16-E40,D40)=0),E40=16),F40*G40*$X$13,0)","v":0},{"$f":"IF(OR((MOD(17-E40,D40)=0),E40=17),F40*G40*$Y$13,0)","v":0},{"$f":"IF(OR((MOD(18-E40,D40)=0),E40=18),F40*G40*$Z$13,0)","v":0},{"$f":"IF(OR((MOD(19-E40,D40)=0),E40=19),F40*G40*$AA$13,0)","v":0},{"$f":"IF(OR((MOD(20-E40,D40)=0),E40=20),F40*G40*$AB$13,0)","v":0},{"$f":"IF(OR((MOD(21-E40,D40)=0),E40=21),F40*G40*$AC$13,0)","v":0},{"$f":"IF(OR((MOD(22-E40,D40)=0),E40=22),F40*G40*$AD$13,0)","v":0},{"$f":"IF(OR((MOD(23-E40,D40)=0),E40=23),F40*G40*$AE$13,0)","v":0},{"$f":"IF(OR((MOD(24-E40,D40)=0),E40=24),F40*G40*$AF$13,0)","v":0},{"$f":"IF(OR((MOD(25-E40,D40)=0),E40=25),F40*G40*$AG$13,0)","v":0},{"$f":"IF(OR((MOD(26-E40,D40)=0),E40=26),F40*G40*$AH$13,0)","v":0},{"$f":"IF(OR((MOD(27-E40,D40)=0),E40=27),F40*G40*$AI$13,0)","v":0},{"$f":"IF(OR((MOD(28-E40,D40)=0),E40=28),F40*G40*$AJ$13,0)","v":0},{"$f":"IF(OR((MOD(29-E40,D40)=0),E40=29),F40*G40*$AK$13,0)","v":0},{"$f":"IF(OR((MOD(30-E40,D40)=0),E40=30),F40*G40*$AL$13,0)","v":291271.49654275907},{"$f":"IF(OR((MOD(31-E40,D40)=0),E40=31),F40*G40*$AM$13,0)","v":0},{"$f":"IF(OR((MOD(32-E40,D40)=0),E40=32),F40*G40*$AN$13,0)","v":0},{"$f":"IF(OR((MOD(33-E40,D40)=0),E40=33),F40*G40*$AO$13,0)","v":0},{"$f":"IF(OR((MOD(34-E40,D40)=0),E40=34),F40*G40*$AP$13,0)","v":0},{"$f":"IF(OR((MOD(35-E40,D40)=0),E40=35),F40*G40*$AQ$13,0)","v":0},{"$f":"IF(OR((MOD(36-E40,D40)=0),E40=36),F40*G40*$AR$13,0)","v":0},{"$f":"IF(OR((MOD(37-E40,D40)=0),E40=37),F40*G40*$AS$13,0)","v":0},{"$f":"IF(OR((MOD(38-E40,D40)=0),E40=38),F40*G40*$AT$13,0)","v":0},{"$f":"IF(OR((MOD(39-E40,D40)=0),E40=39),F40*G40*$AU$13,0)","v":0},{"$f":"IF(OR((MOD(40-E40,D40)=0),E40=40),F40*G40*$AV$13,0)","v":0},{"$f":"SUM(I40:AV40)","v":478227.58653485077},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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Hot water heaters (3)",15,null,24,1500,36000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,56086.826997627519,0,0,0,0,0,0,0,0,0,0,0,0,0,0,87381.448962827722,0,0,0,0,0,0,0,0,0,0,143468.27596045524,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Range hoods",15,null,24,400,9600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14956.487199367339,0,0,0,0,0,0,0,0,0,0,0,0,0,0,23301.719723420727,0,0,0,0,0,0,0,0,0,0,38258.206922788064,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Exterior Lighting / Breezeways",25,null,2,500,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2093.7779296542139,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2093.7779296542139,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Interior Unit lighting",25,null,24,500,12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,25125.335155850567,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,25125.335155850567,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Other",30,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,0.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,"Life, Safety & Fire Protection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Smoke detectors",10,null,96,50,{"$f":"IF(E47>0,0,(F47*G47))","v":4800},{"$f":"IF(OR((MOD(1-E47,D47)=0),E47=1),F47*G47*$I$13,0)","v":0},{"$f":"IF(OR((MOD(2-E47,D47)=0),E47=2),F47*G47*$J$13,0)","v":0},{"$f":"IF(OR((MOD(3-E47,D47)=0),E47=3),F47*G47*$K$13,0)","v":0},{"$f":"IF(OR((MOD(4-E47,D47)=0),E47=4),F47*G47*$L$13,0)","v":0},{"$f":"IF(OR((MOD(5-E47,D47)=0),E47=5),F47*G47*$M$13,0)","v":0},{"$f":"IF(OR((MOD(6-E47,D47)=0),E47=6),F47*G47*$N$13,0)","v":0},{"$f":"IF(OR((MOD(7-E47,D47)=0),E47=7),F47*G47*$O$13,0)","v":0},{"$f":"IF(OR((MOD(8-E47,D47)=0),E47=8),F47*G47*$P$13,0)","v":0},{"$f":"IF(OR((MOD(9-E47,D47)=0),E47=9),F47*G47*$Q$13,0)","v":0},{"$f":"IF(OR((MOD(10-E47,D47)=0),E47=10),F47*G47*$R$13,0)","v":6450.7986208517841},{"$f":"IF(OR((MOD(11-E47,D47)=0),E47=11),F47*G47*$S$13,0)","v":0},{"$f":"IF(OR((MOD(12-E47,D47)=0),E47=12),F47*G47*$T$13,0)","v":0},{"$f":"IF(OR((MOD(13-E47,D47)=0),E47=13),F47*G47*$U$13,0)","v":0},{"$f":"IF(OR((MOD(14-E47,D47)=0),E47=14),F47*G47*$V$13,0)","v":0},{"$f":"IF(OR((MOD(15-E47,D47)=0),E47=15),F47*G47*$W$13,0)","v":0},{"$f":"IF(OR((MOD(16-E47,D47)=0),E47=16),F47*G47*$X$13,0)","v":0},{"$f":"IF(OR((MOD(17-E47,D47)=0),E47=17),F47*G47*$Y$13,0)","v":0},{"$f":"IF(OR((MOD(18-E47,D47)=0),E47=18),F47*G47*$Z$13,0)","v":0},{"$f":"IF(OR((MOD(19-E47,D47)=0),E47=19),F47*G47*$AA$13,0)","v":0},{"$f":"IF(OR((MOD(20-E47,D47)=0),E47=20),F47*G47*$AB$13,0)","v":8669.3339264131828},{"$f":"IF(OR((MOD(21-E47,D47)=0),E47=21),F47*G47*$AC$13,0)","v":0},{"$f":"IF(OR((MOD(22-E47,D47)=0),E47=22),F47*G47*$AD$13,0)","v":0},{"$f":"IF(OR((MOD(23-E47,D47)=0),E47=23),F47*G47*$AE$13,0)","v":0},{"$f":"IF(OR((MOD(24-E47,D47)=0),E47=24),F47*G47*$AF$13,0)","v":0},{"$f":"IF(OR((MOD(25-E47,D47)=0),E47=25),F47*G47*$AG$13,0)","v":0},{"$f":"IF(OR((MOD(26-E47,D47)=0),E47=26),F47*G47*$AH$13,0)","v":0},{"$f":"IF(OR((MOD(27-E47,D47)=0),E47=27),F47*G47*$AI$13,0)","v":0},{"$f":"IF(OR((MOD(28-E47,D47)=0),E47=28),F47*G47*$AJ$13,0)","v":0},{"$f":"IF(OR((MOD(29-E47,D47)=0),E47=29),F47*G47*$AK$13,0)","v":0},{"$f":"IF(OR((MOD(30-E47,D47)=0),E47=30),F47*G47*$AL$13,0)","v":11650.859861710363},{"$f":"IF(OR((MOD(31-E47,D47)=0),E47=31),F47*G47*$AM$13,0)","v":0},{"$f":"IF(OR((MOD(32-E47,D47)=0),E47=32),F47*G47*$AN$13,0)","v":0},{"$f":"IF(OR((MOD(33-E47,D47)=0),E47=33),F47*G47*$AO$13,0)","v":0},{"$f":"IF(OR((MOD(34-E47,D47)=0),E47=34),F47*G47*$AP$13,0)","v":0},{"$f":"IF(OR((MOD(35-E47,D47)=0),E47=35),F47*G47*$AQ$13,0)","v":0},{"$f":"IF(OR((MOD(36-E47,D47)=0),E47=36),F47*G47*$AR$13,0)","v":0},{"$f":"IF(OR((MOD(37-E47,D47)=0),E47=37),F47*G47*$AS$13,0)","v":0},{"$f":"IF(OR((MOD(38-E47,D47)=0),E47=38),F47*G47*$AT$13,0)","v":0},{"$f":"IF(OR((MOD(39-E47,D47)=0),E47=39),F47*G47*$AU$13,0)","v":0},{"$f":"IF(OR((MOD(40-E47,D47)=0),E47=40),F47*G47*$AV$13,0)","v":15657.781401595545},{"$f":"SUM(I47:AV47)","v":42428.77381057087},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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Other",30,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,0.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,"Interior Elements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Gypsum repair",15,null,24,150,{"$f":"IF(E50>0,0,(F50*G50))","v":3600},{"$f":"IF(OR((MOD(1-E50,D50)=0),E50=1),F50*G50*$I$13,0)","v":0},{"$f":"IF(OR((MOD(2-E50,D50)=0),E50=2),F50*G50*$J$13,0)","v":0},{"$f":"IF(OR((MOD(3-E50,D50)=0),E50=3),F50*G50*$K$13,0)","v":0},{"$f":"IF(OR((MOD(4-E50,D50)=0),E50=4),F50*G50*$L$13,0)","v":0},{"$f":"IF(OR((MOD(5-E50,D50)=0),E50=5),F50*G50*$M$13,0)","v":0},{"$f":"IF(OR((MOD(6-E50,D50)=0),E50=6),F50*G50*$N$13,0)","v":0},{"$f":"IF(OR((MOD(7-E50,D50)=0),E50=7),F50*G50*$O$13,0)","v":0},{"$f":"IF(OR((MOD(8-E50,D50)=0),E50=8),F50*G50*$P$13,0)","v":0},{"$f":"IF(OR((MOD(9-E50,D50)=0),E50=9),F50*G50*$Q$13,0)","v":0},{"$f":"IF(OR((MOD(10-E50,D50)=0),E50=10),F50*G50*$R$13,0)","v":0},{"$f":"IF(OR((MOD(11-E50,D50)=0),E50=11),F50*G50*$S$13,0)","v":0},{"$f":"IF(OR((MOD(12-E50,D50)=0),E50=12),F50*G50*$T$13,0)","v":0},{"$f":"IF(OR((MOD(13-E50,D50)=0),E50=13),F50*G50*$U$13,0)","v":0},{"$f":"IF(OR((MOD(14-E50,D50)=0),E50=14),F50*G50*$V$13,0)","v":0},{"$f":"IF(OR((MOD(15-E50,D50)=0),E50=15),F50*G50*$W$13,0)","v":5608.6826997627522},{"$f":"IF(OR((MOD(16-E50,D50)=0),E50=16),F50*G50*$X$13,0)","v":0},{"$f":"IF(OR((MOD(17-E50,D50)=0),E50=17),F50*G50*$Y$13,0)","v":0},{"$f":"IF(OR((MOD(18-E50,D50)=0),E50=18),F50*G50*$Z$13,0)","v":0},{"$f":"IF(OR((MOD(19-E50,D50)=0),E50=19),F50*G50*$AA$13,0)","v":0},{"$f":"IF(OR((MOD(20-E50,D50)=0),E50=20),F50*G50*$AB$13,0)","v":0},{"$f":"IF(OR((MOD(21-E50,D50)=0),E50=21),F50*G50*$AC$13,0)","v":0},{"$f":"IF(OR((MOD(22-E50,D50)=0),E50=22),F50*G50*$AD$13,0)","v":0},{"$f":"IF(OR((MOD(23-E50,D50)=0),E50=23),F50*G50*$AE$13,0)","v":0},{"$f":"IF(OR((MOD(24-E50,D50)=0),E50=24),F50*G50*$AF$13,0)","v":0},{"$f":"IF(OR((MOD(25-E50,D50)=0),E50=25),F50*G50*$AG$13,0)","v":0},{"$f":"IF(OR((MOD(26-E50,D50)=0),E50=26),F50*G50*$AH$13,0)","v":0},{"$f":"IF(OR((MOD(27-E50,D50)=0),E50=27),F50*G50*$AI$13,0)","v":0},{"$f":"IF(OR((MOD(28-E50,D50)=0),E50=28),F50*G50*$AJ$13,0)","v":0},{"$f":"IF(OR((MOD(29-E50,D50)=0),E50=29),F50*G50*$AK$13,0)","v":0},{"$f":"IF(OR((MOD(30-E50,D50)=0),E50=30),F50*G50*$AL$13,0)","v":8738.1448962827726},{"$f":"IF(OR((MOD(31-E50,D50)=0),E50=31),F50*G50*$AM$13,0)","v":0},{"$f":"IF(OR((MOD(32-E50,D50)=0),E50=32),F50*G50*$AN$13,0)","v":0},{"$f":"IF(OR((MOD(33-E50,D50)=0),E50=33),F50*G50*$AO$13,0)","v":0},{"$f":"IF(OR((MOD(34-E50,D50)=0),E50=34),F50*G50*$AP$13,0)","v":0},{"$f":"IF(OR((MOD(35-E50,D50)=0),E50=35),F50*G50*$AQ$13,0)","v":0},{"$f":"IF(OR((MOD(36-E50,D50)=0),E50=36),F50*G50*$AR$13,0)","v":0},{"$f":"IF(OR((MOD(37-E50,D50)=0),E50=37),F50*G50*$AS$13,0)","v":0},{"$f":"IF(OR((MOD(38-E50,D50)=0),E50=38),F50*G50*$AT$13,0)","v":0},{"$f":"IF(OR((MOD(39-E50,D50)=0),E50=39),F50*G50*$AU$13,0)","v":0},{"$f":"IF(OR((MOD(40-E50,D50)=0),E50=40),F50*G50*$AV$13,0)","v":0},{"$f":"SUM(I50:AV50)","v":14346.827596045525},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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Painting",5,null,24,800,19200,0,0,0,0,22258.062226559996,0,0,0,0,25803.194483407136,0,0,0,0,29912.974398734677,0,0,0,0,34677.335705652731,0,0,0,0,40200.536249360906,0,0,0,0,46603.439446841454,0,0,0,0,54026.159123933234,0,0,0,0,62631.125606382178,316112.82724087231,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Carpeting 500 S.F. ",7,null,24,1750,42000,0,0,0,0,0,0,51654.702347844541,0,0,0,0,0,0,63528.768443914661,0,0,0,0,0,0,78132.372011798812,0,0,0,0,0,0,96092.962380964935,0,0,0,0,0,0,118182.22308360394,0,0,0,0,0,407591.02826812689,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Water Closet ",20,null,24,450,10800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19506.001334429664,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35230.008153589974,54736.009488019641,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Tub/Shower Unit",20,null,24,900,21600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,39012.002668859328,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,70460.016307179947,109472.01897603928,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Interior bi-fold doors",15,null,24,150,3600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5608.6826997627522,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8738.1448962827726,0,0,0,0,0,0,0,0,0,0,14346.827596045525,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"New door hardware",15,null,24,40,960,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1495.6487199367339,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2330.1719723420729,0,0,0,0,0,0,0,0,0,0,3825.8206922788067,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Vinyl tile  200 S.F.",15,null,24,750,18000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,28043.413498813759,0,0,0,0,0,0,0,0,0,0,0,0,0,0,43690.724481413861,0,0,0,0,0,0,0,0,0,0,71734.137980227621,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Bath countertops & sink",10,null,24,300,7200,0,0,0,0,0,0,0,0,0,9676.1979312776766,0,0,0,0,0,0,0,0,0,13004.000889619776,0,0,0,0,0,0,0,0,0,17476.289792565545,0,0,0,0,0,0,0,0,0,23486.672102393317,63643.160715856313,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Kitchen countertops & sink",10,null,24,1000,24000,0,0,0,0,0,0,0,0,0,32253.993104258923,0,0,0,0,0,0,0,0,0,43346.669632065918,0,0,0,0,0,0,0,0,0,58254.299308551817,0,0,0,0,0,0,0,0,0,78288.90700797773,212143.86905285437,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Washers (3)",15,null,24,650,15600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,24304.291698971923,0,0,0,0,0,0,0,0,0,0,0,0,0,0,37865.294550558683,0,0,0,0,0,0,0,0,0,0,62169.586249530606,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Dryers",15,null,24,650,15600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,24304.291698971923,0,0,0,0,0,0,0,0,0,0,0,0,0,0,37865.294550558683,0,0,0,0,0,0,0,0,0,0,62169.586249530606,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Refrigerator (3)",15,null,24,900,21600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,33652.09619857651,0,0,0,0,0,0,0,0,0,0,0,0,0,0,52428.869377696639,0,0,0,0,0,0,0,0,0,0,86080.965576273156,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Stove",15,null,24,600,14400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22434.730799051009,0,0,0,0,0,0,0,0,0,0,0,0,0,0,34952.57958513109,0,0,0,0,0,0,0,0,0,0,57387.310384182099,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Dishwasher (3)",15,null,24,600,14400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22434.730799051009,0,0,0,0,0,0,0,0,0,0,0,0,0,0,34952.57958513109,0,0,0,0,0,0,0,0,0,0,57387.310384182099,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Garbage disposal",15,null,24,200,4800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7478.2435996836693,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11650.859861710363,0,0,0,0,0,0,0,0,0,0,19129.103461394032,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.03,null,1.03,1.0609,1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,null,"Window coverings (miniblinds)",5,null,48,60,2880,0,0,0,0,3338.7093339839994,0,0,0,0,3870.4791725110708,0,0,0,0,4486.9461598102016,0,0,0,0,5201.6003558479106,0,0,0,0,6030.0804374041354,0,0,0,0,6990.5159170262186,0,0,0,0,8103.9238685899845,0,0,0,0,9394.6688409573271,47416.92408613085,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.03,null,1.03,{"$f":"1*(1+BV66)^2","v":1.0609},1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003,1.8061112346694133,1.8602945717094954,1.9161034088607805,1.973586511126604,2.0327941064604018,2.0937779296542138,2.1565912675438406,2.2212890055701555,2.2879276757372602,2.3565655060093778,2.4272624711896591,2.5000803453253493,2.5750827556851092,2.6523352383556626,2.7319052955063321,2.8138624543715225,2.898278328002668,2.9852266778427476,3.0747834781780301,3.1670269825233714,3.262037791999072]
[null,"Tranfser these totals to the KHC Underwriting Model:",null,null,null,"Total Capital Needs:",null,{"$f":"SUM(H15:H66)","v":719862},0,0,1232.5960560000001,0,39508.060452143989,0,57558.096901883917,1428.9166518052307,0,117081.9949684599,0,0,1656.5060287733641,70789.199123219194,550046.62830056623,0,0,1920.3444930786109,0,553840.39788890618,87061.785956004387,0,2226.2055845508094,0,110383.97245137015,0,0,109655.79764273542,0,1043951.0252838453,0,0,2991.8341488651877,0,227585.19530956872,0,0,3468.3557633848181,0,1000297.3648409314,{"$f":"SUM(I67:AV67)","v":3982684.2778460924}]
[null,null,null,null,null,"Per Unit Amount",null,{"$f":"H67/D6","v":29994.25},{"$f":"I67/D6","v":0},{"$f":"J67/D6","v":0},{"$f":"K67/D6","v":51.358169000000004},{"$f":"L67/D6","v":0},{"$f":"M67/D6","v":1646.1691855059996},{"$f":"N67/D6","v":0},{"$f":"O67/D6","v":2398.2540375784965},{"$f":"P67/D6","v":59.538193825217945},{"$f":"Q67/D6","v":0},{"$f":"R67/D6","v":4878.4164570191624},{"$f":"S67/D6","v":0},{"$f":"T67/D6","v":0},{"$f":"U67/D6","v":69.021084532223497},{"$f":"V67/D6","v":2949.5499634674666},{"$f":"W67/D6","v":22918.609512523592},{"$f":"X67/D6","v":0},{"$f":"Y67/D6","v":0},{"$f":"Z67/D6","v":80.014353878275458},{"$f":"AA67/D6","v":0},{"$f":"AB67/D6","v":23076.683245371092},{"$f":"AC67/D6","v":3627.5744148335161},{"$f":"AD67/D6","v":0},{"$f":"AE67/D6","v":92.75856602295039},{"$f":"AF67/D6","v":0},{"$f":"AG67/D6","v":4599.332185473756},{"$f":"AH67/D6","v":0},{"$f":"AI67/D6","v":0},{"$f":"AJ67/D6","v":4568.991568447309},{"$f":"AK67/D6","v":0},{"$f":"AL67/D6","v":43497.959386826886},{"$f":"AM67/D6","v":0},{"$f":"AN67/D6","v":0},{"$f":"AO67/D6","v":124.65975620271615},{"$f":"AP67/D6","v":0},{"$f":"AQ67/D6","v":9482.71647123203},{"$f":"AR67/D6","v":0},{"$f":"AS67/D6","v":0},{"$f":"AT67/D6","v":144.51482347436743},{"$f":"AU67/D6","v":0},{"$f":"AV67/D6","v":41679.056868372143},{"$f":"AW67/D6","v":165945.17824358717}]
[null,null,null,null,null,null,null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30","Year 31","Year 32","Year 33","Year 34","Year 35","Year 36","Year 37","Year 38","Year 39","Year 40"]
[null,null,"Reserve Account Analysis",null,null,null,"Beginning of the year balance:",{"$f":"M8","v":75000},{"$f":"H76","v":75000},{"$f":"I76","v":87780},101154,113911.43594400001,128515.62522288,104273.61665199362,119435.70054313749,77735.227556963422,91733.992658289979,107857.83902950809,7650.8423552322383,22963.235961338578,39036.658742337087,54243.468692035356,1104.1992303905188,-531858.33298920223,-514284.46052994562,-496183.3718969113,-479459.59509796451,-460256.15016717842,-994316.99977737491,-1061005.8510063083,-1040021.7282374252,-1020634.2873700265,-998372.23152451834,-1085826.2864550152,-1062208.4714085157,-1037882.1219106212,-1122481.7795705253,-1096673.9553882091,-2114042.9217642685,-2086663.4010892492,-2058462.4947939792,-2032407.3954587164,-2002489.0539700645,-2199258.357546322,-2167517.9890610115,-2134825.4095211416,-2104620.4083584598,-2069936.8507246117,null,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":"M7","v":0.03},null,{"$f":"1*(1+BV70)^1","v":1.03},{"$f":"1*(1+BV70)^2","v":1.0609},{"$f":"1*(1+BV70)^3","v":1.092727},{"$f":"1*(1+BV70)^4","v":1.1255088099999999},{"$f":"1*(1+BV70)^5","v":1.1592740742999998},{"$f":"1*(1+BV70)^6","v":1.1940522965289999},{"$f":"1*(1+BV70)^7","v":1.22987386542487},{"$f":"1*(1+BV70)^8","v":1.2667700813876159},{"$f":"1*(1+BV70)^9","v":1.3047731838292445},{"$f":"1*(1+BV70)^10","v":1.3439163793441218},{"$f":"1*(1+BV70)^11","v":1.3842338707244455},{"$f":"1*(1+BV70)^12","v":1.4257608868461786},{"$f":"1*(1+BV70)^13","v":1.4685337134515639},{"$f":"1*(1+BV70)^14","v":1.512589724855111},{"$f":"1*(1+BV70)^15","v":1.5579674166007644},{"$f":"1*(1+BV70)^16","v":1.6047064390987871},{"$f":"1*(1+BV70)^17","v":1.6528476322717507},{"$f":"1*(1+BV70)^18","v":1.7024330612399032},{"$f":"1*(1+BV70)^19","v":1.7535060530771003},{"$f":"1*(1+BV70)^20","v":1.8061112346694133},{"$f":"1*(1+BV70)^21","v":1.8602945717094954},{"$f":"1*(1+BV70)^22","v":1.9161034088607805},{"$f":"1*(1+BV70)^23","v":1.973586511126604},{"$f":"1*(1+BV70)^24","v":2.0327941064604018},{"$f":"1*(1+BV70)^25","v":2.0937779296542138},{"$f":"1*(1+BV70)^26","v":2.1565912675438406},{"$f":"1*(1+BV70)^27","v":2.2212890055701555},{"$f":"1*(1+BV70)^28","v":2.2879276757372602},{"$f":"1*(1+BV70)^29","v":2.3565655060093778},{"$f":"1*(1+BV70)^30","v":2.4272624711896591},{"$f":"1*(1+BV70)^31","v":2.5000803453253493},{"$f":"1*(1+BV70)^32","v":2.5750827556851092},{"$f":"1*(1+BV70)^33","v":2.6523352383556626},{"$f":"1*(1+BV70)^34","v":2.7319052955063321},{"$f":"1*(1+BV70)^35","v":2.8138624543715225},{"$f":"1*(1+BV70)^36","v":2.898278328002668},{"$f":"1*(1+BV70)^37","v":2.9852266778427476},{"$f":"1*(1+BV70)^38","v":3.0747834781780301},{"$f":"1*(1+BV70)^39","v":3.1670269825233714},{"$f":"1*(1+BV70)^40","v":3.262037791999072}]
[null,null,null,null,null,null,"Annual reserve deposits:",null,{"$f":"$M$6*$D$6","v":11280},{"$f":"$I$71*I13","v":11618.4},{"$f":"$I$71*J13","v":11966.951999999999},12325.96056,12695.739376799998,13076.611558103998,13468.90990484712,13872.977201992533,14289.166518052307,14717.841513593878,15159.376759001694,15614.158061771745,16082.582803624895,16565.060287733642,17062.012096365652,17573.872459256621,18101.088633034316,18644.121292025349,19203.444930786107,19779.548278709692,20372.93472707098,20984.12276888311,21613.646451949604,22262.055845508094,22929.917520873332,23617.815046499531,24326.34949789452,25056.139982831355,25807.824182316293,26582.05890778578,27379.520675019354,28200.906295269939,29046.933484128032,29918.341488651873,30815.891733311426,31740.368485310773,32692.579539870094,33673.356926066197,34683.557633848177,35724.064362863632]
[null,null,null,null,null,null,"Capital needs:",null,{"$f":"I67*-1","v":0},0,-1232.5960560000001,0,-39508.060452143989,0,-57558.096901883917,-1428.9166518052307,0,-117081.9949684599,0,0,-1656.5060287733641,-70789.199123219194,-550046.62830056623,0,0,-1920.3444930786109,0,-553840.39788890618,-87061.785956004387,0,-2226.2055845508094,0,-110383.97245137015,0,0,-109655.79764273542,0,-1043951.0252838453,0,0,-2991.8341488651877,0,-227585.19530956872,0,0,-3468.3557633848181,0,-1000297.3648409314]
[null,null,null,null,null,null,"Annual net change:",null,{"$f":"I71+I72","v":11280},{"$f":"J71+J72","v":11618.4},10734.355943999999,12325.96056,-26812.321075343993,13076.611558103998,-44089.186997036799,12444.060550187303,14289.166518052307,-102364.15345486603,15159.376759001694,15614.158061771745,14426.076774851532,-54224.138835485552,-532984.61620420055,17573.872459256621,18101.088633034316,16723.776798946739,19203.444930786107,-534060.84961019654,-66688.851228933403,20984.12276888311,19387.440867398793,22262.055845508094,-87454.054930496815,23617.815046499531,24326.34949789452,-84599.657659904056,25807.824182316293,-1017368.9663760595,27379.520675019354,28200.906295269939,26055.099335262843,29918.341488651873,-196769.30357625728,31740.368485310773,32692.579539870094,30205.001162681379,34683.557633848177,-964573.30047806771]
[null,null,null,null,null,null,"Sub-Total:",{"$f":"H70+H71-H72","v":75000},{"$f":"SUM(I70:I72)","v":86280},{"$f":"SUM(J70:J72)","v":99398.399999999994},111888.35594400001,126237.396504,101703.30414753602,117350.22821009762,75346.513546100672,90179.288107150714,106023.15917634229,5493.685574642077,22810.219114233932,38577.394023110319,53462.735517188616,19.329856549811666,-531880.41697381006,-514284.46052994562,-496183.3718969113,-479459.59509796451,-460256.15016717842,-994316.99977737491,-1061005.8510063083,-1040021.7282374252,-1020634.2873700265,-998372.23152451834,-1085826.2864550152,-1062208.4714085157,-1037882.1219106212,-1122481.7795705253,-1096673.9553882091,-2114042.9217642685,-2086663.4010892492,-2058462.4947939792,-2032407.3954587164,-2002489.0539700645,-2199258.357546322,-2167517.9890610115,-2134825.4095211416,-2104620.4083584598,-2069936.8507246117,-3034510.1512026796]
[null,null,null,null,null,"Annual Interest on Reserve Account:",0.02,0,{"$f":"IF(H76>0,$G$75*H76,0)","v":1500},1755.6000000000001,2023.0800000000002,2278.2287188800001,2570.3125044576,2085.4723330398724,2388.7140108627495,1554.7045511392685,1834.6798531657996,2157.1567805901618,153.01684710464477,459.26471922677155,780.7331748467418,1084.8693738407071,22.083984607810375,{"$f":"IF(W76>0,$G$75*W76,0)","v":0},{"$f":"IF(X76>0,$G$75*X76,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"End of the year balance:",{"$f":"H74+H75","v":75000},{"$f":"I74+I75","v":87780},{"$f":"J74+J75","v":101154},113911.43594400001,128515.62522288,104273.61665199362,119435.70054313749,77735.227556963422,91733.992658289979,107857.83902950809,7650.8423552322383,22963.235961338578,39036.658742337087,54243.468692035356,1104.1992303905188,-531858.33298920223,-514284.46052994562,-496183.3718969113,-479459.59509796451,-460256.15016717842,-994316.99977737491,-1061005.8510063083,-1040021.7282374252,-1020634.2873700265,-998372.23152451834,-1085826.2864550152,-1062208.4714085157,-1037882.1219106212,-1122481.7795705253,-1096673.9553882091,-2114042.9217642685,-2086663.4010892492,-2058462.4947939792,-2032407.3954587164,-2002489.0539700645,-2199258.357546322,-2167517.9890610115,-2134825.4095211416,-2104620.4083584598,-2069936.8507246117,-3034510.1512026796]
[]
[null,null,null,null,null,null,null,"General Notes",null,null,null,null,null,null,null,"Cost Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking Lot Repairs: $0.75 S.F.                                              Carpet: $3.50 S.F.\nRestripe Parking Lot: $10/stall                                              Vinyl Flooring: $3.75 S.F.\nSidewalk Repair: $1.25 S.F.                                                    Cement Fiber Board: $10 S.F.\nSeal Parking Lot: $0.15 S.F.                                                    Soffit: $4.80 S.F.\nBuilding Signage: $750 Each                                                  Roofing: $1.90 S.F.\nDumpster Enclosure: $12 L.F.                                                Applicances: Unit Cost Plus Labor\nDumpster Pad Concrete: $4 S.F."]