{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Computation","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,2],[0,0,0,2],[1,0,1,2],[11,0,11,2],[12,0,12,2],[13,0,13,2]]}
["National Housing Bank"]
["Subsidy Calculator for Pradhan Mantri Awas Yojana – Credit Linked Subsidy Scheme "]
["First Disbursement Date","2015-07-01","Date should be on or after 17-Jun-2015"]
["Current Disbursement Date (for which subsidy claimed)","2015-07-01","Date should  be on or after first disbursement date"]
["Loan Tenure (in months)",180,"Numeric Integer only"]
["Amount Disbursed before this installment (in Rs.)",0,"Numeric Integer only"]
["Current Disbursement Installment (in Rs.)",600000,"Numeric Integer only"]
["Applied Interest Rate for subsidy calculation (in % p.a)",6.5,"NO input data"]
["Subsidy Amount",220187.06414651513]
[]
["Assumptions:"]
["1. Monthly Interest for calculation of subsidy is arrived at by applying @ 6.5% p.a. on the disbursed amount, for a maximum tenure of 15 years."]
["2. NPV is discounted @9% and calculated on monthly rest basis."]
["3. Paise in Total is rounded off to the nearest rupee"]
["4. For calculation purpose month is treated as 30 days."]

{"sheet":"Computation","index":1,"n_rows":183,"n_cols":14,"rows_kept":183,"cut":false,"hidden":true,"merged":[]}
["Parameters",null,"Loan Amount",{"$f":"IF((Data!B6+Data!B7)>600000,600000-Data!B6,Data!B7)","v":600000},"Loan Tenure",{"$f":"IF(Data!B5>180,180,Data!B5)","v":180},"Cur Inst Tenure",{"$f":"IF(Data!B4=\"\",0, F1-((YEAR(Data!B4)-YEAR(Data!B3))*12+MONTH(Data!B4)-MONTH(Data!B3)))","v":180},"Int Rate",{"$f":"IF(Data!B8>6.5,6.5,Data!B8)","v":6.5},"r ",{"$f":"J1/1200","v":5.4166666666666669E-3},"(1+r)^n-1",{"$f":"((1+L1)^H1)-1","v":1.6442008195042987}]
[null,"BALANCE","EMI","INTEREST","principal repayment","CL BALANCE","NPV(By Formula)","Days in Month",{"$f":"DAY(DATE(YEAR(Data!B4),MONTH(Data!B4)+1,1)-1)","v":31},"EMI",{"$f":"IF($N$1=0,0,($D$1*$L$1)*((1+$L$1)^$H$1)/$N$1)","v":5226.6441917842039}]
[1,{"$f":"D1","v":600000},{"$f":"K2","v":5226.6441917842039},{"$f":"B3*$J$1*I3/(1200*I2)","v":3250},{"$f":"C3-D3","v":1976.6441917842039},{"$f":"B3-E3","v":598023.3558082158},{"$f":"D3/POWER(1+9/1200,A3)","v":3225.8064516129029},"Days for Int First Mth",{"$f":"VALUE(I2-DAY(Data!B4)+1)","v":31}]
[{"$f":"A3+1","v":2},{"$f":"IF(F3>0,F3,0)","v":598023.3558082158},{"$f":"IF(B4>0,C3,0)","v":5226.6441917842039},{"$f":"B4*$J$1/1200","v":3239.2931772945021},{"$f":"C4-D4","v":1987.3510144897018},{"$f":"B4-E4","v":596036.00479372614},{"$f":"D4/POWER(1+9/1200,A4)","v":3191.2449948409276}]
[{"$f":"A4+1","v":3},{"$f":"IF(F4>0,F4,0)","v":596036.00479372614},{"$f":"IF(B5>0,C4,0)","v":5226.6441917842039},{"$f":"B5*$J$1/1200","v":3228.5283592993496},1998.1158324848543,594037.88896124123,3156.9626308183747]
[4,594037.88896124123,5226.6441917842039,3217.7052318733899,2008.938959910814,592028.95000133046,3122.9572368295048]
[5,592028.95000133046,5226.6441917842039,3206.8234791738732,2019.8207126103307,590009.12928872008,3089.2267060536965]
[6,590009.12928872008,5226.6441917842039,3195.8827836472337,2030.7614081369702,587978.36788058316,3055.7689474469257]
[7,587978.36788058316,5226.6441917842039,3184.8828260198256,2041.7613657643783,585936.60651481873,3022.5818856241353]
[8,585936.60651481873,5226.6441917842039,3173.8232852886017,2052.8209064956022,583883.78560832317,2989.6634607424658]
[9,583883.78560832317,5226.6441917842039,3162.7038387117504,2063.9403530724535,581819.84525525069,2957.0116283853736]
[10,581819.84525525069,5226.6441917842039,3151.5241617992747,2075.1200299849293,579744.72522526572,2924.6243594475973,"Total NPV as per Manual Formula",{"$f":"SUM(G3:G182)","v":220187.06414651513}]
[11,579744.72522526572,5226.6441917842039,3140.2839283035228,2086.3602634806812,577658.36496178503,2892.4996400209916,"NPV by Excel Formula",{"$f":"NPV(9/1200,D3:D182)","v":220187.06414651548}]
[12,577658.36496178503,5226.6441917842039,3128.982810209669,2097.661381574535,575560.70358021045,2860.6354712812049]
[13,575560.70358021045,5226.6441917842039,3117.6204777261396,2109.0237140580643,573451.67986615235,2829.0298693752034]
[14,573451.67986615235,5226.6441917842039,3106.1965992749915,2120.4475925092124,571331.23227364314,2797.68086530963]
[15,571331.23227364314,5226.6441917842039,3094.7108414822337,2131.9333503019702,569199.29892334121,2766.5865048400028]
[16,569199.29892334121,5226.6441917842039,3083.162869168098,2143.4813226161059,567055.8176007251,2735.7448483607268]
[17,567055.8176007251,5226.6441917842039,3071.5523453372607,2155.0918464469432,564900.72575427813,2705.1539707959337]
[18,564900.72575427813,5226.6441917842039,3059.8789311690066,2166.7652606151973,562733.96049366298,2674.8119614911325]
[19,562733.96049366298,5226.6441917842039,3048.1422860073412,2178.5019057768627,560555.45858788607,2644.7169241056677]
[20,560555.45858788607,5226.6441917842039,3036.3420673510495,2190.3021244331544,558365.15646345296,2614.8669765059726]
[21,558365.15646345296,5226.6441917842039,3024.4779308437037,2202.1662609405003,556162.99020251248,2585.2602506596299]
[22,556162.99020251248,5226.6441917842039,3012.5495302636091,2214.0946615205949,553948.89554099191,2555.8948925302047]
[23,553948.89554099191,5226.6441917842039,3000.5565175137062,2226.0876742704977,551722.80786672141,2526.7690619728792]
[24,551722.80786672141,5226.6441917842039,2988.4985426114076,2238.1456491727963,549484.66221754858,2497.8809326308469]
[25,549484.66221754858,5226.6441917842039,2976.3752536783882,2250.2689381058158,547234.3932794428,2469.2286918324926]
[26,547234.3932794428,5226.6441917842039,2964.1862969303152,2262.4578948538888,544971.9353845889,2440.8105404893317]
[27,544971.9353845889,5226.6441917842039,2951.9313166665233,2274.7128751176806,542697.22250947123,2412.6246929947079]
[28,542697.22250947123,5226.6441917842039,2939.6099552596361,2287.0342365245679,540410.18827294663,2384.669377123249]
[29,540410.18827294663,5226.6441917842039,2927.2218531451276,2299.4223386390763,538110.76593430759,2356.9428339310739]
[30,538110.76593430759,5226.6441917842039,2914.7666488108325,2311.8775429733714,535798.88839133421,2329.4433176567318]
[31,535798.88839133421,5226.6441917842039,2902.2439787863937,2324.4002129978103,533474.48817833641,2302.1690956228963]
[32,533474.48817833641,5226.6441917842039,2889.6534776326557,2336.9907141515482,531137.49746418488,2275.1184481387754]
[33,531137.49746418488,5226.6441917842039,2876.9947779310014,2349.6494138532025,528787.8480503317,2248.2896684032557]
[34,528787.8480503317,5226.6441917842039,2864.2675102726298,2362.3766815115741,526425.47136882017,2221.6810624087702]
[35,526425.47136882017,5226.6441917842039,2851.4713032477762,2375.1728885364278,524050.29848028376,2195.2909488458799]
[36,524050.29848028376,5226.6441917842039,2838.6057834348703,2388.0384083493336,521662.26007193443,2169.1176590085615]
[37,521662.26007193443,5226.6441917842039,2825.6705753896449,2400.973616394559,519261.28645553987,2143.1595367002069]
[38,519261.28645553987,5226.6441917842039,2812.6653016341743,2413.9788901500297,516847.30756538984,2117.4149381403217]
[39,516847.30756538984,5226.6441917842039,2799.5895826458618,2427.0546091383421,514420.2529562515,2091.8822318719158]
[40,514420.2529562515,5226.6441917842039,2786.4430368463622,2440.2011549378417,511980.05180131365,2066.5597986695857]
[41,511980.05180131365,5226.6441917842039,2773.2252805904491,2453.4189111937549,509526.63289011992,2041.446031448281]
[42,509526.63289011992,5226.6441917842039,2759.9359281548163,2466.7082636293876,507059.92462649051,2016.5393351727514]
[43,507059.92462649051,5226.6441917842039,2746.5745917268237,2480.0696000573803,504579.85502643313,1991.8381267676662]
[44,504579.85502643313,5226.6441917842039,2733.1408813931794,2493.5033103910246,502086.35171604209,1967.3408350284053]
[45,502086.35171604209,5226.6441917842039,2719.6344051285614,2507.0097866556425,499579.34192938643,1943.0459005325135]
[46,499579.34192938643,5226.6441917842039,2706.0547687841768,2520.5894230000272,497058.75250638637,1918.9517755518134]
[47,497058.75250638637,5226.6441917842039,2692.4015760762595,2534.2426157079444,494524.50989067846,1895.0569239651761]
[48,494524.50989067846,5226.6441917842039,2678.6744285745085,2547.9697632096954,491976.54012746876,1871.3598211719388]
[49,491976.54012746876,5226.6441917842039,2664.8729256904558,2561.7712660937482,489414.76886137499,1847.8589540059666]
[50,489414.76886137499,5226.6441917842039,2650.9966646657808,2575.6475271184231,486839.12133425655,1824.552820650357]
[51,486839.12133425655,5226.6441917842039,2637.0452405605561,2589.5989512236479,484249.52238303289,1801.4399305527809]
[52,484249.52238303289,5226.6441917842039,2623.0182462414282,2603.6259455427758,481645.89643749013,1778.5188043414471]
[53,481645.89643749013,5226.6441917842039,2608.9152723697384,2617.7289194144655,479028.16751807567,1755.787973741702]
[54,479028.16751807567,5226.6441917842039,2594.7359073895768,2631.9082843946271,476396.25923368102,1733.2459814932422]
[55,476396.25923368102,5226.6441917842039,2580.4797375157723,2646.1644542684317,473750.09477941261,1710.8913812679511]
[56,473750.09477941261,5226.6441917842039,2566.1463467218182,2660.4978450623857,471089.59693435021,1688.7227375883422]
[57,471089.59693435021,5226.6441917842039,2551.7353167277302,2674.9088750564738,468414.68805929372,1666.7386257466108]
[58,468414.68805929372,5226.6441917842039,2537.2462269878411,2689.3979647963629,465725.29009449738,1644.9376317242914]
[59,465725.29009449738,5226.6441917842039,2522.6786546785274,2703.9655371056765,463021.32455739169,1623.3183521125102]
[60,463021.32455739169,5226.6441917842039,2508.0321746858717,2718.6120170983322,460302.71254029335,1601.8793940328337]
[61,460302.71254029335,5226.6441917842039,2493.3063595932554,2733.3378321909486,457569.37470810238,1580.6193750587067]
[62,457569.37470810238,5226.6441917842039,2478.5007796688878,2748.1434121153161,454821.23129598703,1559.5369231374732]
[63,454821.23129598703,5226.6441917842039,2463.6150028532629,2763.029188930941,452058.2021070561,1538.6306765129823]
[64,452058.2021070561,5226.6441917842039,2448.648594746554,2777.99559703765,449280.20651001844,1517.8992836487678]
[65,449280.20651001844,5226.6441917842039,2433.6011185959333,2793.0430731882707,446487.16343683016,1497.3414031517968]
[66,446487.16343683016,5226.6441917842039,2418.4721352828301,{"$f":"C68-D68","v":2808.1720565013738},{"$f":"B68-E68","v":443678.99138032878},{"$f":"D68/POWER(1+9/1200,A68)","v":1476.9557036967956}]
[{"$f":"A68+1","v":67},{"$f":"IF(F68>0,F68,0)","v":443678.99138032878},{"$f":"IF(B69>0,C68,0)","v":5226.6441917842039},{"$f":"B69*$J$1/1200","v":2403.2612033101141},2823.3829884740899,440855.60839185468,1456.7408639511302]
[68,440855.60839185468,5226.6441917842039,2387.967878789213,2838.6763129949909,438016.93207885971,1436.695572500251]
[69,438016.93207885971,5226.6441917842039,2372.5917154271565,2854.0524763570475,435162.87960250268,1416.8185277736898]
[70,435162.87960250268,5226.6441917842039,2357.132264513556,2869.5119272706479,432293.36767523206,1397.1084379716126]
[71,432293.36767523206,5226.6441917842039,2341.589074907507,2885.055116876697,429408.31255835539,1377.5640209919147]
[72,429408.31255835539,5226.6441917842039,2325.9616930244251,2900.6824987597788,426507.63005959563,1358.1840043578622]
[73,426507.63005959563,5226.6441917842039,2310.2496628228096,2916.3945289613944,423591.23553063424,1338.9671251462698]
[74,423591.23553063424,5226.6441917842039,2294.4525257909354,2932.1916659932685,420659.04386464099,1319.9121299162164]
[75,420659.04386464099,5226.6441917842039,2278.5698209334719,2948.0743708507321,417710.96949379024,1301.0177746382906]
[76,417710.96949379024,5226.6441917842039,2262.6010847580305,2964.0431070261734,414746.92638676404,1282.282824624361]
[77,414746.92638676404,5226.6441917842039,2246.5458512616387,2980.0983405225652,411766.82804624148,1263.706054457874]
[78,411766.82804624148,5226.6441917842039,2230.4036519171414,2996.2405398670626,408770.5875063744,1245.2862479246658]
[79,408770.5875063744,5226.6441917842039,2214.1740156595279,3012.4701761246761,405758.11733024975,1227.0221979442963]
[80,405758.11733024975,5226.6441917842039,2197.8564688721863,3028.7877229120177,402729.32960733771,1208.912706501887]
[81,402729.32960733771,5226.6441917842039,2181.4505353730792,3045.1936564111247,399684.13595092657,1190.9565845804711]
[82,399684.13595092657,5226.6441917842039,2164.9557364008519,3061.688455383352,396622.44749554322,1173.1526520938485]
[83,396622.44749554322,5226.6441917842039,2148.3715906008592,3078.2726011833447,393544.17489435989,1155.4997378199382]
[84,393544.17489435989,5226.6441917842039,2131.697614011116,3094.9465777730879,390449.22831658681,1137.9966793346264]
[85,390449.22831658681,5226.6441917842039,2114.9333200481788,3111.7108717360252,387337.51744485076,1120.6423229461129]
[86,387337.51744485076,5226.6441917842039,2098.0782194929416,3128.5659722912624,384208.95147255948,1103.4355236297386]
[87,384208.95147255948,5226.6441917842039,2081.1318204763638,3145.5123713078401,381063.43910125166,1086.3751449633075]
[88,381063.43910125166,5226.6441917842039,2064.0936284651129,3162.550563319091,377900.88853793259,1069.4600590628816]
[89,377900.88853793259,5226.6441917842039,2046.963146247135,3179.6810455370687,374721.20749239554,1052.6891465190602]
[90,374721.20749239554,5226.6441917842039,2029.7398739171424,3196.9043178670618,371524.30317452847,1036.0612963337312]
[91,371524.30317452847,5226.6441917842039,2012.423308862029,3214.220882922175,368310.08229160629,1019.5754058572959]
[92,368310.08229160629,5226.6441917842039,1995.0129457462008,3231.6312460380032,365078.45104556828,1003.2303807263577]
[93,365078.45104556828,5226.6441917842039,1977.5082764968281,3249.1359152873756,361829.31513028091,987.02513480187849]
[94,361829.31513028091,5226.6441917842039,1959.9087902890215,3266.7354014951825,358562.57972878573,970.95859010779384]
[95,358562.57972878573,5226.6441917842039,1942.2139735309229,3284.4302182532811,355278.14951053244,955.02967677008701]
[96,355278.14951053244,5226.6441917842039,1924.4233098487175,3302.2208819354864,351975.92862859694,939.23733295631428]
[97,351975.92862859694,5226.6441917842039,1906.536280071567,3320.1079117126369,348655.82071688428,923.58050481558314]
[98,348655.82071688428,5226.6441917842039,1888.5523622164565,3338.0918295677475,345317.72888731654,908.05814641897712]
[99,345317.72888731654,5226.6441917842039,1870.4710314729646,3356.1731603112394,341961.5557270053,892.66921970042506]
[100,341961.5557270053,5226.6441917842039,1852.2917601879453,3374.3524315962586,338587.20329540904,877.4126943980076]
[101,338587.20329540904,5226.6441917842039,1834.0140178501322,3392.6301739340715,335194.57312147494,862.28754799570481]
[102,335194.57312147494,5226.6441917842039,1815.6372710746557,3411.0069207095485,331783.56620076537,847.29276566557678]
[103,331783.56620076537,5226.6441917842039,1797.160983587479,3429.4832081967252,328354.08299256867,832.4273402103737]
[104,328354.08299256867,5226.6441917842039,1778.5846162097471,3448.0595755744571,324906.0234169942,817.69027200657456]
[105,324906.0234169942,5226.6441917842039,1759.907626842052,3466.7365649421517,321439.28685205203,803.08056894784909]
[106,321439.28685205203,5226.6441917842039,1741.1294704486152,3485.5147213355885,317953.77213071642,788.59724638894295]
[107,317953.77213071642,5226.6441917842039,1722.2495990413806,3504.3945927428231,314449.37753797357,774.23932708997984]
[108,314449.37753797357,5226.6441917842039,1703.2674616640236,3523.3767301201806,310926.00080785342,760.00584116117716]
[109,310926.00080785342,5226.6441917842039,1684.1825043758727,3542.4616874083313,307383.53912044509,745.89582600797564]
[110,307383.53912044509,5226.6441917842039,1664.9941702357444,3561.6500215484593,303821.88909889665,731.90832627657721]
[111,303821.88909889665,5226.6441917842039,1645.7018992856902,3580.9422924985138,300240.9468063981,718.04239379988769]
[112,300240.9468063981,5226.6441917842039,1626.3051285346564,3600.3390632495475,296640.60774314858,704.29708754386365]
[113,296640.60774314858,5226.6441917842039,1606.8032919420548,3619.8408998421492,293020.76684330642,690.67147355425755]
[114,293020.76684330642,5226.6441917842039,1587.1958204012433,3639.4483713829604,289381.31847192347,677.16462490376091]
[115,289381.31847192347,5226.6441917842039,1567.4821417229189,3659.1620500612853,285722.15642186219,663.7756216395403]
[116,285722.15642186219,5226.6441917842039,1547.6616806184202,3678.9825111657838,282043.17391069641,650.5035507311643]
[117,282043.17391069641,5226.6441917842039,1527.7338586829389,3698.9103331012648,278344.26357759512,637.34750601892017]
[118,278344.26357759512,5226.6441917842039,1507.6980943786402,3718.9460974055637,274625.31748018955,624.30658816251173]
[119,274625.31748018955,5226.6441917842039,1487.5538030176933,3739.0903887665108,270886.22709142306,611.37990459014429]
[120,270886.22709142306,5226.6441917842039,1467.3003967452082,3759.3437950389957,267126.88329638407,598.56656944798488]
[121,267126.88329638407,5226.6441917842039,1446.9372845220805,3779.7069072621234,263347.17638912192,585.86570355000106]
[122,263347.17638912192,5226.6441917842039,1426.4638721077438,3800.1803196764604,259546.99606944545,573.27643432817274]
[123,259546.99606944545,5226.6441917842039,1405.8795620428295,3820.7646297413744,255726.23143970408,560.79789578307623]
[124,255726.23143970408,5226.6441917842039,1385.1837536317305,3841.4604381524732,251884.77100155159,548.42922843483404]
[125,251884.77100155159,5226.6441917842039,1364.3758429250711,3862.2683488591329,248022.50265269246,536.16957927443286]
[126,248022.50265269246,5226.6441917842039,1343.4552227020843,3883.1889690821199,244139.31368361035,524.01810171540114]
[127,244139.31368361035,5226.6441917842039,1322.4212824528893,3904.2229093313144,240235.09077427903,511.97395554585069]
[128,240235.09077427903,5226.6441917842039,1301.2734083606781,3925.3707834235256,236309.71999085549,500.03630688087219]
[129,236309.71999085549,5226.6441917842039,1280.0109832838004,3946.6332085004033,232363.08678235509,488.20432811528582]
[130,232363.08678235509,5226.6441917842039,1258.6333867377566,{"$f":"C132-D132","v":3968.0108050464473},{"$f":"B132-E132","v":228395.07597730865},{"$f":"D132/POWER(1+9/1200,A132)","v":476.4771978767464}]
[{"$f":"A132+1","v":131},{"$f":"IF(F132>0,F132,0)","v":228395.07597730865},{"$f":"IF(B133>0,C132,0)","v":5226.6441917842039},{"$f":"B133*$J$1/1200","v":1237.1399948770884},3989.5041969071153,224405.57178040154,464.85410097919521]
[132,224405.57178040154,5226.6441917842039,1215.530180477175,4011.1140113070287,220394.4577690945,453.33422837665984]
[133,220394.4577690945,5226.6441917842039,1193.8033129159285,4032.8408788682755,216361.61689022623,441.91677711739783]
[134,216361.61689022623,5226.6441917842039,1171.9587581553922,4054.6854336288116,212306.93145659741,430.60095029838283]
[135,212306.93145659741,5226.6441917842039,1149.995878723236,4076.6483130609677,208230.28314353645,419.38595702012879]
[136,208230.28314353645,5226.6441917842039,1127.9140336941557,4098.7301580900485,204131.55298544641,408.27101234185147]
[137,204131.55298544641,5226.6441917842039,1105.7125786711681,4120.9316131130363,200010.62137233338,397.25533723696361]
[138,200010.62137233338,5226.6441917842039,1083.3908657668057,4143.2533260173986,195867.36804631597,386.33815854890202]
[139,195867.36804631597,5226.6441917842039,1060.9482435842115,4165.6959481999929,191701.67209811599,375.51870894728376]
[140,191701.67209811599,5226.6441917842039,1038.3840571981282,4188.2601345860758,187513.41196352991,364.79622688438889]
[141,187513.41196352991,5226.6441917842039,1015.6976481357871,4210.946543648417,183302.46541988151,354.16995655196763]
[142,183302.46541988151,5226.6441917842039,992.88835435769147,4233.7558374265127,179068.70958245499,343.63914783836861]
[143,179068.70958245499,5226.6441917842039,969.95551023829785,4256.6886815459056,174812.02090090909,333.20305628598817]
[144,174812.02090090909,5226.6441917842039,946.89844654659078,4279.7457452376129,170532.27515567146,322.86094304903514]
[145,170532.27515567146,5226.6441917842039,923.71649042655383,4302.9277013576502,166229.34745431383,312.61207485161094]
[146,166229.34745431383,5226.6441917842039,900.40896537753326,4326.2352264066703,161903.11222790717,302.45572394610213]
[147,161903.11222790717,5226.6441917842039,876.97519123449729,4349.6690005497067,157553.44322735746,292.39116807188316]
[148,157553.44322735746,5226.6441917842039,853.41448414818626,4373.2297076360173,153180.21351972144,282.41769041432582]
[149,153180.21351972144,5226.6441917842039,829.72615656515779,4396.918035219046,148783.29548450239,272.53457956411586]
[150,148783.29548450239,5226.6441917842039,805.90951720772125,4420.7346745764826,144362.5608099259,262.74112947687092]
[151,144362.5608099259,5226.6441917842039,781.96387105376527,4444.6803207304383,139917.88048919546,253.03663943306088]
[152,139917.88048919546,5226.6441917842039,757.88851931647548,4468.7556724677288,135449.12481672774,243.42041399822565]
[153,135449.12481672774,5226.6441917842039,733.68275942394189,4492.9614323602618,130956.16338436748,233.8917629834902]
[154,130956.16338436748,5226.6441917842039,709.3458849986572,4517.2983067855466,126438.86507758193,224.45000140637384]
[155,126438.86507758193,5226.6441917842039,684.87718583690207,4541.7670059473021,121897.09807163462,215.09444945189077]
[156,121897.09807163462,5226.6441917842039,660.27594788802094,4566.3682438961832,117330.72982773844,205.82443243394141]
[157,117330.72982773844,5226.6441917842039,635.54145323358318,4591.1027385506204,112739.62708918782,196.63928075699081]
[158,112739.62708918782,5226.6441917842039,610.67298006643409,4615.9712117177696,108123.65587747005,187.53832987803287]
[159,108123.65587747005,5226.6441917842039,585.66980266962946,4640.9743891145745,103482.68148835548,178.52092026883798]
[160,103482.68148835548,5226.6441917842039,560.53119139525882,4666.1130003889448,98816.568487966535,169.58639737848208]
[161,98816.568487966535,5226.6441917842039,535.25641264315209,4691.3877791410523,94125.180708825486,160.73411159615452]
[162,94125.180708825486,5226.6441917842039,509.84472883947137,4716.799462944733,89408.381245880752,151.96341821424369]
[163,89408.381245880752,5226.6441917842039,484.29539841518738,4742.3487933690167,84666.032452511732,143.27367739169739]
[164,84666.032452511732,5226.6441917842039,458.60767578443853,4768.0365159997655,79897.995936511972,134.66425411765618]
[165,79897.995936511972,5226.6441917842039,432.78081132277316,4793.863380461431,75104.132556050536,126.1345181753579]
[166,75104.132556050536,5226.6441917842039,406.8140513452737,4819.8301404389304,70284.302415611601,117.68384410631106]
[167,70284.302415611601,5226.6441917842039,380.70663808456283,4845.9375536996413,65438.364861911963,109.31161117473545]
[168,65438.364861911963,5226.6441917842039,354.45780966868978,4872.1863821155139,60566.17847979645,101.01720333226737]
[169,60566.17847979645,5226.6441917842039,328.06680009889749,4898.5773916853068,55667.601088111143,92.800009182928193]
[170,55667.601088111143,5226.6441917842039,301.53283922726871,4925.1113525569353,50742.489735554205,84.65942194835381]
[171,50742.489735554205,5226.6441917842039,274.85515273425193,4951.7890390499524,45790.700696504253,76.594839433283397]
[172,45790.700696504253,5226.6441917842039,248.0329621060647,4978.6112296781394,40812.089466826117,68.605663991305178]
[173,40812.089466826117,5226.6441917842039,221.06548461197477,5005.5787071722289,35806.510759653887,60.691302490857488]
[174,35806.510759653887,5226.6441917842039,193.95193328145854,5032.6922585027451,30773.818501151141,52.851166281483344]
[175,30773.818501151141,5226.6441917842039,166.69151688123534,5059.9526749029683,25713.865826248173,45.084671160336391]
[176,25713.865826248173,5226.6441917842039,139.2834398921776,5087.3607518920262,20626.505074356148,37.391237338936456]
[177,20626.505074356148,5226.6441917842039,111.72690248609581,5114.9172892981078,15511.58778505804,29.770289410172982]
[178,15511.58778505804,5226.6441917842039,84.021100502397715,5142.6230912818064,10368.964693776234,22.221256315554168]
[179,10368.964693776234,5226.6441917842039,56.165225424621262,5170.478966359583,5198.4857274166507,14.743571312700466]
[180,5198.4857274166507,5226.6441917842039,28.158464356840188,5198.4857274273636,-1.0712938092183322E-8,7.3366719430800593]
[null,null,{"$f":"SUM(C3:C182)","v":940795.9545211565},{"$f":"SUM(D3:D182)","v":340795.95452114608},{"$f":"SUM(E3:E182)","v":600000.00000001106}]

{"sheet":"Sheet1","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Please enable macros"]