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

 | Total | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
CAROLINE
Scrubbed Data
2007 | 5700 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750
2008 | 4215 | 150 | 175 | 150 | 155 | 160 | 200 | 500 | 600 | 750 | 1000 | 250 | 125
2009 | 2400 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Total | 12315 | 550 | 625 | 650 | 705 | 760 | 850 | 1200 | 1350 | 1550 | 1850 | 1150 | 1075
Allocated Data
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
[NAME]
2007 | 954.6085403098232 | -52.27072889866147 | -40.37093771352795 | 0 | 24.02513279159962 | 3.467729526051755 | 73.31312930643708 | 98.98165506674525 | 119.129270940409 | 150 | 174.4168627571514 | 197.4695716398456 | 206.4468548937726
2008 | 54.06088775558783 | -331.6954686297682 | -310.3467476360812 | -275 | -247.532203049777 | -269.7577819057969 | -150.7221669089457 | 174.5264677144582 | 297.1791485592752 | 475 | 749.9738383842046 | 24.41524909709642 | -81.97944786907769
2009 | -3529.245574566173 | 124.8367188873849 | 43.12488623085997 | -25 | -110.0328365592563 | -221.1386038233786 | -250.0518642204563 | -325.9717728229801 | -401.8086972138647 | -475 | -550.0051791274999 | -625.3390942548708 | -712.8591316621107
Total | -2520.576146500762 | -259.1294786410448 | -307.5927991187492 | -300 | -333.5399068174336 | -487.4286562031238 | -327.460901822965 | -52.46365004177665 | 14.49972228581953 | 150 | 374.3855220138561 | -403.4542735179288 | -588.3917246374158
BETTY
Scrubbed Data
2007
2008
2009
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Allocated Data
2007
2008
2009
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]
2007 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
JOE
Scrubbed Data
2007 | 0
2008 | 0
2009 | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Allocated Data
2007 | 0
2008 | 0
2009 | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]
2007 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CAROL
Scrubbed Data
2007 | 0
2008 | 0
2009 | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Allocated Data
2007 | 0
2008 | 0
2009 | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]
2007 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0