Spreadsheet: 219690d1362882305-need-to-calculate-total-months-backwards-until-it-reach-a-goal-sample
Sheet: DVD Returns Analysis Input

 |  |  |  | DVD Gross Revenue
Reporting Group Studio 2Yr Summary | Grand Total | Feature New Release | Catalogue | Fee Product | Video Acquired | TV
 |  | 535.6836199999999 | 2944.622650000003 | 3381.734569999996 | 116.41859 | 1236.471690000001
 |  | 2271.235700000001 | 3096.502580000001 | 1987.067350000003 | 61.79072 | 4901.748300000001
 |  | 1217.66499 | 3798.488629999989 | 1764.407169999999 | 54.48044999999998 | 4577.27128
 |  | 9281.015329999998 | 6315.562339999995 | 3114.017160000002 | 97.80575 | 13766.212
 |  | 7840.60791 | 5582.574219999999 | 2537.042080000002 | 68.41472999999998 | 8632.97319
 |  | 1856.12128 | 2429.545540000003 | 1144.5094 | 265.2732000000001 | 2678.66702
 |  | 3481.795009999999 | 2718.58653 | 1598.712039999999 | 105.32136 | 1544.834419999999
 |  | 2390.731779999999 | 2747.707710000002 | 1298.100190000001 | 59.8074 | 1836.73052
 |  | 4460.00738 | 2188.001249999998 | 658.0066199999999 | 56.62902000000001 | 1728.449660000002
 |  | 6364.363999999997 | 5345.700700000004 | 1037.23126 | 131.26459 | 3729.178829999996
 |  | 1607.41621 | 1938.207949999999 | 2583.26405 | 21.39829 | 1850.77835
 |  | 1278.28719 | 2787.229609999999 | 881.9814399999985 | 25.79937 | 1201.40676
 |  | 908.2937800000002 | 3781.87175 | 1363.961480000002 | 38.82147 | 1816.628559999998
 |  | 2263.11376 | 2462.15739 | 1274.170570000001 | 38.76763 | 3271.151609999996
 |  | 7447.971089999999 | 4602.676379999998 | 1675.96946 | 186.84616 | 4918.02137
 |  | 4162.249189999999 | 6017.609740000001 | 2494.31706 | 453.6844800000001 | 9446.880580000005
 |  | 11678.25325 | 3855.571500000006 | 1850.38166 | 139.57395 | 4522.345569999996
 |  | 1172.45196 | 2039.994400000002 | 1065.619829999999 | 48.92853000000002 | 941.9779799999994
 |  | 1297.27788 | 1516.06286 | 958.2487399999993 | 34.59244 | 1357.841429999999
 |  | 962.94496 | 1322.097519999999 | 552.9189699999998 | 154.8995600000001 | 1018.41526
 |  | 4051.343590000001 | 1768.171899999999 | 1979.93838 | 46.41056 | 491.3377000000004
 |  | 2970.68134 | 2741.330099999998 | 1189.623459999999 | 60.41575 | 1411.280020000002
 |  | 4451.742710000002 | 1055.087419999999 | 566.5138199999994 | 21.46004 | 502.2751100000005
 |  | 3846.63408 | 1532.143020000001 | 658.6795099999996 | 27.00681 | 1041.810039999999
 |  | 1447.39308 | 1454.485549999999 | 630.3471299999989 | 375.7367599999999 | 1187.43059
 |  | 1579.56323 | 2247.193319999999 | 1600.053180000005 | 168.23535 | 3511.925079999999
 |  | 6343.096830000003 | 2952.00719 | 1825.822970000001 | 146.67469 | 4701.855760000001
 |  | 4128.504190000001 | 4298.102560000003 | 2861.224040000002 | 104.37239 | 5011.397890000005
TOTAL
 |  |  |  | DVD Returns Revenue
Reporting Group Studio 2Yr Summary | Grand Total | Feature New Release | Catalogue | Fee Product | Video Acquired | TV
 |  | 2172.12048 | 510.6600999999995 | 234.9607300000002 | 28.76828 | 211.4976600000001
 |  | 256.7196700000001 | 416.2340499999999 | 202.0115800000001 | 36.79132 | 153.95456
 |  | 757.4701700000003 | 283.0209399999999 | 269.5019400000005 | 51.56823000000001 | 266.9995899999996
 |  | 633.32386 | 243.8339399999999 | 209.0115700000003 | 29.37557 | 352.8596699999998
 |  | 114.44452 | 355.10692 | 124.79616 | 18.90938 | 337.03109
 |  | 247.88661 | 311.9997999999998 | 161.0826000000004 | 16.06674000000001 | 684.01322
 |  | 200.6152 | 391.0973199999999 | 231.3831600000002 | 6.388849999999999 | 677.7843200000001
 |  | 351.1945499999999 | 422.387119999999 | 94.07844000000009 | 28.4302 | 407.17643
 |  | 107.40467 | 87.59802000000006 | 44.87416000000002 | 33.20329 | 156.08647
 |  | 211.50331 | 170.40426 | 79.59377000000016 | 21.75789 | 173.9673600000001
 |  | 181.71706 | 410.9367300000004 | 111.1559800000001 | 25.88154 | 346.1367100000002
 |  | 66.03453000000002 | 418.5412699999997 | 110.23391 | 5.17647 | 157.1053199999998
 |  | 58.99443000000002 | 160.0881100000003 | 69.95276 | 9.555510000000002 | 210.1377700000001
 |  | 42.12855 | 211.3641600000001 | 70.11999999999998 | 18.01547 | 58.67048999999999
 |  | 56.90954 | 134.6727 | 42.23336000000011 | 4.439870000000003 | 25.86080999999998
 |  | 42.18617999999999 | 46.98001999999994 | 72.6205600000002 | 7.03536 | 39.75256000000001
 |  | 660.0109600000001 | 800.4362899999984 | 325.6213199999992 | 40.97742 | 411.03438
 |  | 119.78214 | 280.8193600000004 | 77.69471000000013 | 33.66039 | 447.37186
 |  | 306.65252 | 576.1325999999993 | 144.9196999999998 | 35.15344 | 403.3962700000002
 |  | 56.83367999999999 | 175.1873900000002 | 64.31436000000014 | 22.58524 | 220.7693299999999
 |  | 169.60369 | 85.79924000000008 | 23.04326 | 10.32313 | 170.5922599999999
 |  | 71.28422000000002 | 28.36816000000003 | 14.31696000000002 | 8.845300000000003 | 39.41083999999999
 |  | 29.74111 | 174.70497 | 73.20879000000002 | 4.04099 | 253.5667799999999
 |  | 54.70117 | 316.5446800000001 | 80.47105000000005 | 25.96271 | 182.1110599999999
 |  | 115.92914 | 128.99964 | 16.98539999999999 | 31.78879999999999 | 91.63737
 |  | 12 | 311 | 82 | 6 | 135
 |  | 297.2582399999999 | 93.60312 | 26.3489 | 29.24714 | 133.1731100000001
 |  | 91.18677000000004 | 123.7324599999999 | 22.57656000000002 | 13.4803 | 64.54288000000003
TOTAL
Ave (12mo) [NAME]
Reserve for Returns |  | 3748.7932 | 4288.45072 | 1966.049670000001 | 96.10157000000001 | 3268.572740000001
Months Coverage
Ave (12mo) [NAME]
Reserve for Returns |  | 2248.50363 | 4802.954120000002 | 1383.84877 | 51.29825999999999 | 3103.44648
Months Coverage
Ave (12mo) [NAME]
Reserve for Returns |  | 2637.779099999999 | 4667.446060000003 | 2024.796870000009 | 82.28694999999999 | 3664.625420000001
Months Coverage
Ave (12mo) [NAME]
Reserve for Returns |  | 2518.1138 | 4471.980759999999 | 1940.596270000003 | 74.63428 | 4314.160959999999
Months Coverage
Ave (12mo) [NAME]
Reserve for Returns |  | 2858.4815 | 6100.020280000002 | 2051.206729999969 | 93.86004 | 5111.254029999999
Months Coverage