Spreadsheet: 76581d1277137997-populate-worksheet-based-on-information-in-another-sheet-sample-2
Sheet: Practice1

TASK ORDER |  | Type | Ref Nbr | Invoice | Doc Date | Aged | Delivery Date/Expected Delivery Date | Total | 0-30 | 31 To 60 | 61 To 90 | Over 90 | Balance | Description | Status | POC
 |  | IN | 001172 | 140001 | 2009-09-25 00:00:00 |  |  | 178.1
 |  | IN | 001185 | 11TX02 | 2009-09-25 00:00:00 |  |  | 12195.93
 |  | IN | 001190 | 120113 | 2009-09-25 00:00:00 |  |  | 12669.65
 |  | IN | 001191 | 120114 | 2009-09-25 00:00:00 |  |  | 5443.08
 |  | IN | 001208 | 070218 | 2009-10-12 00:00:00 |  |  | 32.48
 |  | IN | 001257 | 11TX05 | 2009-11-18 00:00:00 |  |  | 104645.12
 |  | IN | 001445 | 11TX11 | 2010-01-26 00:00:00 |  |  | 1363.3
 |  | IN | 001449 | 11TX10 | 2010-01-27 00:00:00 |  |  | 2068.15
 |  | IN | 001453 | 140005 | 2010-01-27 00:00:00 |  |  | 194510.22
 |  | IN | 001459 | 03TX03 | 2010-01-28 00:00:00 |  |  | 416459.8
 |  | IN | 001473 | 140003R | 2010-02-18 00:00:00 |  |  | 64850.25
 |  | IN | 001490 | 140004R | 2010-02-22 00:00:00 |  |  | 57157.81
 |  | IN | 001495 | 11TX06R | 2010-02-24 00:00:00 |  |  | 90606.98
 |  | IN | 001496 | 12TZ06 | 2010-02-24 00:00:00 |  |  | 85514.24
 |  | IN | 001500 | 140006 | 2010-02-25 00:00:00 |  |  | 335431.09
 |  | IN | 001563 | 12TZ07 | 2010-03-24 00:00:00 |  |  | 368307.78
 |  | IN | 001570 | 11TX09R | 2010-04-09 00:00:00 |  |  | 287111.16
 |  | IN | 001577 | 140007 | 2010-04-21 00:00:00 |  |  | 796676.48
 |  | IN | 001601 | 11TX15 | 2010-05-20 00:00:00 |  |  | 84249.55
 |  | IN | 001606 | 070303 | 2010-05-26 00:00:00 |  |  | 45605.14
 |  | IN | 001609 | 140008 | 2010-05-26 00:00:00 |  |  | 232891.72
 |  | IN | 000657 | 020213R | 2007-12-17 00:00:00 |  |  | 4956.74
 |  | IN | 000719 | 09-B-07 | 2008-06-16 00:00:00 |  |  | 10295.57
 |  | IN | 000744 | 020308 | 2008-08-06 00:00:00 |  |  | 1329.56
 |  | IN | 000933 | 070213 | 2009-04-22 00:00:00 |  |  | 204.19
 |  | IN | 000970 | 020407 | 2009-05-21 00:00:00 |  |  | 800067.8200000001
 |  | IN | 000990 | 08-1-04 | 2009-06-24 00:00:00 |  |  | 25794.74
 |  | IN | 001140 | 100216R | 2009-08-28 00:00:00 |  |  | 98907.45
 |  | IN | 001146 | 060227 | 2009-08-31 00:00:00 |  |  | 769.6800000000001
 |  | IN | 001168 | 100120 | 2009-09-25 00:00:00 |  |  | 86337.99
 |  | IN | 001169 | 020417 | 2009-09-25 00:00:00 |  |  | 19638.83
 |  | IN | 001170 | 020418 | 2009-09-25 00:00:00 |  |  | 48510.17
 |  | IN | 001171 | 060313 | 2009-09-25 00:00:00 |  |  | 101170.53
 |  | IN | 001173 | 100313 | 2009-09-25 00:00:00 |  |  | 111976.12
 |  | IN | 001174 | 060229 | 2009-09-25 00:00:00 |  |  | 52603.31
 |  | IN | 001175 | 070216 | 2009-09-25 00:00:00 |  |  | 10844.59
 |  | IN | 001176 | 040222 | 2009-09-25 00:00:00 |  |  | 956
 |  | IN | 001177 | 070217 | 2009-09-25 00:00:00 |  |  | 943.14
 |  | IN | 001178 | 020318 | 2009-09-25 00:00:00 |  |  | 28282.69
 |  | IN | 001179 | 020319 | 2009-09-25 00:00:00 |  |  | 2249.16
 |  | IN | 001180 | 040321 | 2009-09-25 00:00:00 |  |  | 216481.84
 |  | IN | 001181 | 040322 | 2009-09-25 00:00:00 |  |  | 32188.49
 |  | IN | 001182 | 110125 | 2009-09-25 00:00:00 |  |  | 51408.22
 |  | IN | 001183 | 110126 | 2009-09-25 00:00:00 |  |  | 73396.68
 |  | IN | 001184 | 04TX11 | 2009-09-25 00:00:00 |  |  | 83391.16
 |  | IN | 001186 | 060118 | 2009-09-25 00:00:00 |  |  | 6447.63
 |  | IN | 001187 | 070114 | 2009-09-25 00:00:00 |  |  | 5.02
 |  | IN | 001188 | 060228 | 2009-09-25 00:00:00 |  |  | 306370.99
 |  | IN | 001189 | 100314 | 2009-09-25 00:00:00 |  |  | 9093.97
 |  | IN | 001203 | 04TZ01 | 2009-10-09 00:00:00 |  |  | 2860.26
 |  | IN | 001204 | 06TZ3 | 2009-10-09 00:00:00 |  |  | 19951.78
 |  | IN | 001205 | 10311 | 2009-10-12 00:00:00 |  |  | 276381.08
 |  | IN | 001206 | 10312 | 2009-10-12 00:00:00 |  |  | 35498.47
 |  | IN | 001207 | 05-B-11 | 2009-10-12 00:00:00 |  |  | 2413.83
 |  | IN | 001209 | 11B012 | 2009-10-12 00:00:00 |  |  | 384173.58
 |  | CM | 001210 | 11B013 | 2009-10-12 00:00:00 |  |  | -183.78
 |  | IN | 001225 | 020420 | 2009-10-22 00:00:00 |  |  | 234403.33
 |  | IN | 001253 | 100317 | 2009-11-18 00:00:00 |  |  | 339136.43
 |  | IN | 001265 | 060221R2 | 2009-11-19 00:00:00 |  |  | 526974.57
 |  | IN | 001302 | 10TZ03 | 2009-11-24 00:00:00 |  |  | 267351.19
 |  | IN | 001312 | 02TZ02 | 2009-11-25 00:00:00 |  |  | 150000
 |  | IN | 001330 | 04TX15 | 2009-12-09 00:00:00 |  |  | 29509.09
 |  | IN | 001339 | 04TX13R | 2009-12-11 00:00:00 |  |  | 69002.04
 |  | IN | 001361 | 04TX06R | 2009-12-12 00:00:00 |  |  | 4435.95
 |  | IN | 001397 | 06TZ13 | 2009-12-30 00:00:00 |  |  | 54658.64
 |  | IN | 001416 | 060230R2 | 2010-01-12 00:00:00 |  |  | 101846.14
 |  | IN | 001446 | 110127 | 2010-01-26 00:00:00 |  |  | 77700.32
 |  | IN | 001457 | 060317 | 2010-01-27 00:00:00 |  |  | 107524.19
 |  | CM | CM001480 |  | 2010-02-23 00:00:00 |  |  | -0.01
 |  | IN | 001499 | 060306R | 2010-02-25 00:00:00 |  |  | 1065142.69
 |  | IN | 001501 | 100320 | 2010-02-25 00:00:00 |  |  | 78454.82
 |  | IN | 001503 | 060223R | 2010-02-25 00:00:00 |  |  | 180468.19
 |  | IN | 001567 | 100118R2 | 2010-03-24 00:00:00 |  |  | 70790.66
 |  | IN | 001574 | 110128R | 2010-04-15 00:00:00 |  |  | 158450.66
 |  | IN | 001591 | 060308R3 | 2010-04-27 00:00:00 |  |  | 15478.16
 |  | IN | 001592 | 04TX16R1 | 2010-04-29 00:00:00 |  |  | 17561.47
 |  | CM | 001594 | 020308 | 2008-08-06 00:00:00 |  |  | -797405.56
 |  | IN | 001595 | [NAME] | 2010-05-05 00:00:00 |  |  | 747728.93
 |  | IN | 001596 | 100319R | 2010-05-05 00:00:00 |  |  | 45746
 |  | IN | 001597 | 020409R | 2010-05-14 00:00:00 |  |  | 207655.12
 |  | IN | 001598 | 020308 | 2010-05-17 00:00:00 |  |  | 797405.56
 |  | IN | 001600 | 04-1-16R | 2010-05-19 00:00:00 |  |  | 148835.34
 |  | IN | 001602 | 020412R | 2010-05-21 00:00:00 |  |  | 549669.34
 |  | IN | 001603 | 030214 | 2010-03-23 00:00:00 |  |  | 10637.43
 |  | IN | 001604 | 020216 | 2010-05-25 00:00:00 |  |  | 6842.66
 |  | IN | 001605 | 070115 | 2010-05-26 00:00:00 |  |  | 20184.63
 |  | IN | 001608 | 070115 | 2010-05-27 00:00:00 |  |  | 20184.63
 |  | CM | 001610 | 020407 | 2009-05-21 00:00:00 |  |  | -800067.8200000001
 |  | IN | 001611 | 020215R2 | 2010-06-03 00:00:00 |  |  | 666680.49
 |  | CM | 001612 | 020413 | 2009-08-25 00:00:00 |  |  | -144723.36
 |  | DM | 020317HERO |  | 2009-08-24 00:00:00 |  |  | 46374.14
 |  | DM | 020415HERO |  | 2009-08-25 00:00:00 |  |  | 247588.36
 |  | DM | 030309HERO |  | 2009-08-24 00:00:00 |  |  | 84577.84
 |  | DM | 0303HERO |  | 2009-08-25 00:00:00 |  |  | 35481.94
 |  | DM | 040320HERO |  | 2009-08-24 00:00:00 |  |  | 347577.34
 |  | DM | 04TX09HERO |  | 2009-08-25 00:00:00 |  |  | 135520.1
 |  | DM | 060226HERO |  | 2009-08-21 00:00:00 |  |  | 216217.4
 |  | DM | 060310HERO |  | 2009-08-24 00:00:00 |  |  | 219543.33
 |  | DM | 070215HERO |  | 2009-08-25 00:00:00 |  |  | 59063.68
 |  | DM | 0702HERO |  | 2009-08-25 00:00:00 |  |  | 22202.32
 |  | DM | 100309HERO |  | 2009-08-24 00:00:00 |  |  | 48485.7
 |  | DM | 100310HERO |  | 2009-08-24 00:00:00 |  |  | 45408.41
 |  | DM | 110122HERO |  | 2009-08-24 00:00:00 |  |  | 116795.62
 |  | DM | 1101HERO |  | 2009-08-25 00:00:00 |  |  | 65134.42
 |  | DM | 120110HERO |  | 2009-08-24 00:00:00 |  |  | 22216.54
 |  | DM | CCJSHERO02 |  | 2009-10-09 00:00:00 |  |  | 3817.16
 |  | DM | CCJSHERO03 |  | 2009-10-22 00:00:00 |  |  | 4815.39
 |  | CM | CM00000012 |  | 2009-07-23 00:00:00 |  |  | -2484.1
 |  | DM | CSSPHERO02 |  | 2009-10-09 00:00:00 |  |  | 26486.12
 |  | DM | CSSPHERO03 |  | 2009-10-22 00:00:00 |  |  | 19478.3
 |  | DM | HAITHERO02 |  | 2009-10-09 00:00:00 |  |  | 24094.2
 |  | DM | HAITHERO03 |  | 2009-10-22 00:00:00 |  |  | 25399.41
 |  | DM | INTDHERO03 |  | 2009-10-22 00:00:00 |  |  | 5248.400000000001
 |  | DM | INTEHERO02 |  | 2009-10-09 00:00:00 |  |  | 4211.46
 |  | DM | INTZHERO02 |  | 2009-10-09 00:00:00 |  |  | 1228.34
 |  | DM | JSSLHERO02 |  | 2009-10-09 00:00:00 |  |  | 3983.97
 |  | DM | [NAME] |  | 2009-10-22 00:00:00 |  |  | 8920.39
 |  | DM | JSSPHERO02 |  | 2009-10-09 00:00:00 |  |  | 15425.37
 |  | DM | JSSPHERO03 |  | 2009-10-22 00:00:00 |  |  | 15010.49
 |  | DM | LEBAHERO02 |  | 2009-10-09 00:00:00 |  |  | 19846.46
 |  | DM | LEBAHERO03 |  | 2009-10-22 00:00:00 |  |  | 31130.34
 |  | DM | [NAME] |  | 2009-10-09 00:00:00 |  |  | 9599.01
 |  | DM | LIBEHERO03 |  | 2009-10-22 00:00:00 |  |  | 7048.93