Spreadsheet: 71314d1271977412-pulling-data-into-summary-page-example-2a
Sheet: Allocated Data

 | Total | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
Caroline
Original Amt
2007 | 4650 | 250 | 275 | 300 | 325 | 350 | 375 | 400 | 425 | 450 | 475 | 500 | 525
2008 | 4050 | 475 | 450 | 425 | 400 | 375 | 350 | 325 | 300 | 275 | 250 | 225 | 200
2009 | 5850 | 75 | 150 | 225 | 300 | 375 | 450 | 525 | 600 | 675 | 750 | 825 | 900
 | 137809503.09 | 1127470.51 | 7415514.890000001 | 0 | 1286368 | 16223180.64 | 319696.25 | 239420.25 | 1183527.5 | 0 | 66673.75 | 378981.25 | 3668526.75
Alloc%
2007 | 1 | 0.009082915594645944 | 0.05589431895828351 | 0 | 0.00299959141046279 | 0.1329493442112807 | 0.004498321849501172 | 0.00254586233313684 | 0.01381348014021412 | 0 | 0.001227657353365408 | 0.005060856720308726 | 0.03533932401186173
2008 | 1 | 0.01409572343109109 | 0.0785483280801805 | 0 | 0.006330507624442466 | 0.1460207517487918 | 0.002063334025559248 | 0.001457022417051576 | 0.00940283813574936 | 0 | 0.000104646463181824 | 0.002598892901793739 | 0.03489723934538846
2009 | 1 | 0.002177081501535103 | 0.0458340917942668 | 0 | 0.03344278853085423 | 0.1230362768623428 | 0.0001152538232361999 | 0.001850995853295435 | 0.003014495356441163 | 0 | 6.905503333139401e-06 | 0.0004110233392372832 | 0.01428792406901189
Alloc $
2007 | 5813412.91 | 2.270728898661486 | 15.37093771352796 | 0 | 0.9748672084004067 | 46.53227047394826 | 1.68687069356294 | 1.018344933254736 | 5.870729059591002 | 0 | 0.5831372428485686 | 2.530428360154363 | 18.55314510622741
2008 | 7376273.16 | 6.695468629768268 | 35.34674763608123 | 0 | 2.532203049776986 | 54.75778190579693 | 0.7221669089457368 | 0.4735322855417621 | 2.820851440724808 | 0 | 0.026161615795456 | 0.5847509029035912 | 6.979447869077691
2009 | 4955188.21 | 0.1632811126151328 | 6.87511376914002 | 0 | 10.03283655925627 | 46.13860382337855 | 0.05186422045628994 | 0.9717728229801033 | 1.808697213864698 | 0 | 0.00517912749985455 | 0.3390942548707586 | 12.8591316621107
Total | 18144874.28 | 9.129478641044887 | 57.59279911874921 | 0 | 13.53990681743366 | 147.4286562031238 | 2.460901822964966 | 2.463650041776601 | 10.50027771418051 | 0 | 0.614477986143879 | 3.454273517928713 | 38.3917246374158
New Amt
2007 | 4745.391459690177 | 252.2707288986615 | 290.370937713528 | 300 | 325.9748672084004 | 396.5322704739482 | 376.6868706935629 | 401.0183449332548 | 430.870729059591 | 450 | 475.5831372428486 | 502.5304283601544 | 543.5531451062274
2008 | 4160.939112244412 | 481.6954686297682 | 485.3467476360812 | 425 | 402.532203049777 | 429.7577819057969 | 350.7221669089457 | 325.4735322855418 | 302.8208514407248 | 275 | 250.0261616157954 | 225.5847509029036 | 206.9794478690777
2009 | 5929.245574566173 | 75.16328111261514 | 156.87511376914 | 225 | 310.0328365592563 | 421.1386038233786 | 450.0518642204563 | 525.9717728229801 | 601.8086972138647 | 675 | 750.0051791274999 | 825.3390942548708 | 912.8591316621107
Total | 14835.57614650076 | 809.1294786410448 | 932.5927991187492 | 950 | 1038.539906817434 | 1247.428656203124 | 1177.460901822965 | 1252.463650041777 | 1335.50027771418 | 1400 | 1475.614477986144 | 1553.454273517929 | 1663.391724637416
Betty
Original Amt
2007 | 4950 | 275 | 300 | 325 | 350 | 375 | 400 | 425 | 450 | 475 | 500 | 525 | 550
2008 | 3750 | 450 | 425 | 400 | 375 | 350 | 325 | 300 | 275 | 250 | 225 | 200 | 175
2009 | 5850 | 75 | 150 | 225 | 300 | 375 | 450 | 525 | 600 | 675 | 750 | 825 | 900
 | 137809503.09 | 1127470.51 | 7415514.890000001 | 0 | 1286368 | 16223180.64 | 319696.25 | 239420.25 | 1183527.5 | 0 | 66673.75 | 378981.25 | 3668526.75
Alloc%
2007 | 1 | 0.009082915594645944 | 0.05589431895828351 | 0 | 0.00299959141046279 | 0.1329493442112807 | 0.004498321849501172 | 0.00254586233313684 | 0.01381348014021412 | 0 | 0.001227657353365408 | 0.005060856720308726 | 0.03533932401186173
2008 | 1 | 0.01409572343109109 | 0.0785483280801805 | 0 | 0.006330507624442466 | 0.1460207517487918 | 0.002063334025559248 | 0.001457022417051576 | 0.00940283813574936 | 0 | 0.000104646463181824 | 0.002598892901793739 | 0.03489723934538846
2009 | 1 | 0.002177081501535103 | 0.0458340917942668 | 0 | 0.03344278853085423 | 0.1230362768623428 | 0.0001152538232361999 | 0.001850995853295435 | 0.003014495356441163 | 0 | 6.905503333139401e-06 | 0.0004110233392372832 | 0.01428792406901189
Alloc $
2007 | 5813412.91 | 2.497801788527635 | 16.76829568748505 | 0 | 1.049856993661976 | 49.85600407923027 | 1.799328739800469 | 1.081991491583157 | 6.216066063096355 | 0 | 0.6138286766827038 | 2.656949778162081 | 19.43662820652395
2008 | 7376273.16 | 6.343075543990991 | 33.38303943407671 | 0 | 2.373940359165925 | 51.10726311207713 | 0.6705835583067555 | 0.4371067251154728 | 2.585780487331074 | 0 | 0.02354545421591039 | 0.5197785803587478 | 6.10701688544298
2009 | 4955188.21 | 0.1632811126151328 | 6.87511376914002 | 0 | 10.03283655925627 | 46.13860382337855 | 0.05186422045628994 | 0.9717728229801033 | 1.808697213864698 | 0 | 0.00517912749985455 | 0.3390942548707586 | 12.8591316621107
Total | 18144874.28 | 9.004158445133758 | 57.02644889070179 | 0 | 13.45663391208417 | 147.101871014686 | 2.521776518563514 | 2.490871039678733 | 10.61054376429213 | 0 | 0.6425532583984687 | 3.515822613391587 | 38.40277675407764
New Amt
2007 | 5051.976751504753 | 277.4978017885276 | 316.7682956874851 | 325 | 351.049856993662 | 424.8560040792303 | 401.7993287398004 | 426.0819914915832 | 456.2160660630964 | 475 | 500.6138286766827 | 527.6569497781621 | 569.436628206524
2008 | 3853.551130140082 | 456.343075543991 | 458.3830394340767 | 400 | 377.3739403591659 | 401.1072631120771 | 325.6705835583068 | 300.4371067251155 | 277.5857804873311 | 250 | 225.0235454542159 | 200.5197785803587 | 181.107016885443
2009 | 5929.245574566173 | 75.16328111261514 | 156.87511376914 | 225 | 310.0328365592563 | 421.1386038233786 | 450.0518642204563 | 525.9717728229801 | 601.8086972138647 | 675 | 750.0051791274999 | 825.3390942548708 | 912.8591316621107
Total | 14834.77345621101 | 809.0041584451337 | 932.0264488907018 | 950 | 1038.456633912084 | 1247.101871014686 | 1177.521776518563 | 1252.490871039679 | 1335.610543764292 | 1400 | 1475.642553258398 | 1553.515822613392 | 1663.402776754078
JOE
Original Amt
2007 | 6450 | 400 | 425 | 450 | 475 | 500 | 525 | 550 | 575 | 600 | 625 | 650 | 675
2008 | 1100 | 75 | 50 | 25 | 0 | 25 | 50 | 65 | 85 | 125 | 225 | 200 | 175
2009 | 6450 | 125 | 200 | 275 | 350 | 425 | 500 | 575 | 650 | 725 | 800 | 875 | 950
 | 14000 | 600 | 675 | 750 | 825 | 950 | 1075 | 1190 | 1310 | 1450 | 1650 | 1725 | 1800
Alloc%
2007 | 1 | 0.009082915594645944 | 0.05589431895828351 | 0 | 0.00299959141046279 | 0.1329493442112807 | 0.004498321849501172 | 0.00254586233313684 | 0.01381348014021412 | 0 | 0.001227657353365408 | 0.005060856720308726 | 0.03533932401186173
2008 | 1 | 0.01409572343109109 | 0.0785483280801805 | 0 | 0.006330507624442466 | 0.1460207517487918 | 0.002063334025559248 | 0.001457022417051576 | 0.00940283813574936 | 0 | 0.000104646463181824 | 0.002598892901793739 | 0.03489723934538846
2009 | 1 | 0.002177081501535103 | 0.0458340917942668 | 0 | 0.03344278853085423 | 0.1230362768623428 | 0.0001152538232361999 | 0.001850995853295435 | 0.003014495356441163 | 0 | 6.905503333139401e-06 | 0.0004110233392372832 | 0.01428792406901189
Alloc $
2007 | 5813412.91 | 3.633166237858378 | 23.75508555727049 | 0 | 1.424805919969825 | 66.47467210564037 | 2.361618970988115 | 1.400224283225262 | 7.942751080623121 | 0 | 0.7672858458533797 | 3.289556868200672 | 23.85404370800667
2008 | 7376273.16 | 1.057179257331832 | 3.927416404009025 | 0 | 0 | 3.650518793719795 | 0.1031667012779624 | 0.09470645710835243 | 0.7992412415386956 | 0 | 0.02354545421591039 | 0.5197785803587478 | 6.10701688544298
2009 | 4955188.21 | 0.2721351876918879 | 9.16681835885336 | 0 | 11.70497598579898 | 52.29041766649569 | 0.05762691161809993 | 1.064322615644875 | 1.959421981686756 | 0 | 0.005524402666511521 | 0.3596454218326228 | 13.57352786556129
Total | 18144874.28 | 4.962480682882098 | 36.84932032013288 | 0 | 13.12978190576881 | 122.4156085658558 | 2.522412583884178 | 2.559253355978489 | 10.70141430384857 | 0 | 0.7963557027358016 | 4.168980870392042 | 43.53458845901095
New Amt
2007 | 6584.903210577636 | 403.6331662378584 | 448.7550855572705 | 450 | 476.4248059199698 | 566.4746721056404 | 527.3616189709882 | 551.4002242832253 | 582.9427510806231 | 600 | 625.7672858458534 | 653.2895568682006 | 698.8540437080067
2008 | 1116.282569775003 | 76.05717925733182 | 53.92741640400902 | 25 | 0 | 28.65051879371979 | 50.10316670127796 | 65.09470645710836 | 85.7992412415387 | 125 | 225.0235454542159 | 200.5197785803587 | 181.107016885443
2009 | 6540.45441639785 | 125.2721351876919 | 209.1668183588534 | 275 | 361.704975985799 | 477.2904176664957 | 500.0576269116181 | 576.0643226156449 | 651.9594219816868 | 725 | 800.0055244026665 | 875.3596454218326 | 963.5735278655613
Total | 14241.64019675049 | 604.9624806828821 | 711.8493203201328 | 750 | 838.1297819057688 | 1072.415608565856 | 1077.522412583884 | 1192.559253355978 | 1320.701414303849 | 1450 | 1650.796355702736 | 1729.168980870392 | 1843.534588459011