tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50636d1250108082-rank-and-then-offset-book1
Sheet: Sheet1

 | Region:Segment | ANZ Consumer |  |  | ANZ SMB |  |  | [NAME] |  |  | Argentina SME |  |  | Australia Consumer |  |  | Australia SMB
 | Region:Segment ID | apjaunzdhs |  |  | apjaunzsmb |  |  | laardhs |  |  | laarsme |  |  | apjaudhs |  |  | apjausmb
 |  |  |  |  |  |  |  | Direct Load | 20487 |  | Direct Load | 7310 |  | Direct Load | 66426 |  | Direct Load | 27948
 |  |  |  |  |  |  |  | [NAME] | 17057 |  | Search Terms | 3432 |  | Search Terms | 8963 |  | [NAME] | 10585
 |  |  |  |  |  |  |  | Search Terms | 16728 |  | [NAME] | 2182 |  | [NAME] | 7183 |  | Search Terms | 4446
 |  |  |  |  |  |  |  | Referred Traffic | 5001 |  | [NAME] | 2019 |  | Referred Traffic | 5303 |  | Referred Traffic | 2740
 |  |  |  |  |  |  |  | [NAME] | 4468 |  | ::unspecified:: | 1138 |  | Affiliates | 4297 |  | Affiliates | 1803
 |  |  |  |  |  |  |  | Offline Media | 126 |  | Product Listings | 416 |  | Offline Media | 4205 |  | [NAME] | 1224
 |  |  |  |  |  |  |  | ::unspecified:: | 100 |  | Referred Traffic | 241 |  | [NAME] | 3620 |  | Offline Media | 1185
 |  |  |  |  |  |  |  | Affiliates | 64 |  | Offline Media | 17 |  | ::unspecified:: | 950 |  | ::unspecified:: | 171
 |  |  |  |  |  |  |  | Social Media | 22 |  | Affiliates | 2
 | ::unspecified:: % of Total
 | RANK
 | Argentina SME | Find the highest % in row 35 (rank #1), return the Region:Segment here
 | Australia Consumer | Find the second highest % in row 35 (rank #2), return the Region:Segment here
 | Australia SMB | Find the third highest % in row 35 (rank #3), return the Region:Segment here
 | [NAME] | Find the fourth highest % in row 35 (rank #4), return the Region:Segment here
Spreadsheet: 230532d1366804452-time-card-spread-sheet-help-copy-of-time-card-rec
Sheet: STAFF MEMBER

Week One
Date | Start Time - Job card |  | End Time - Job card |  | Lunch | Hours worked
 |  |  |  |  |  |  | equiv. in hours | Notes:
2013-03-25 00:00:00 | 8.35 | 08:21 | 16.95 | 16:57 | 00:30:00 | 8.1 | 08:06:00
2013-03-26 00:00:00 | 8.34 | 08:20 | 16.96 | 16:58 | 00:30:00 | 8.133333333333331 | 08:08:00 | The times input are as shown on the time cards
2013-03-27 00:00:00 | 8.31 | 08:19 | 16.97 | 16:58 | 00:30:00 | 8.149999999999999 | 08:09:00 | If i format the column as time is also inputs the date
2013-03-28 00:00:00 | 8.06 | 08:04 | 17.23 | 17:14 | 00:30:00 | 8.666666666666668 | 08:40:00 | which throws the time out. So at the moment it is just
2013-03-29 00:00:00 | HOLIDAY |  |  |  |  | 8 |  | as a general
 |  |  | Total hours worked |  |  | 41.05 |  | Ideally i would like  the spread sheet to show as follows
Week Two |  |  |  |  |  |  |  | Column A | Date as per job card input by me
Date | Start Time - Job card |  | End Time - Job card |  | Lunch | Hours worked |  | Column B | Start time as per job card input by me
 |  |  |  |  |  |  |  | Column C | Actual start time - input by formula
2013-04-01 00:00:00 | HOLIDAY |  |  |  |  | 8 |  | Column D | Finish time as per job car input by me
2013-04-02 00:00:00 | 7.24 |  | 16.98 |  |  | 0 |  | Column E | Actual finish time - input by formula
2013-04-03 00:00:00 | 8.4 |  | 17.04 |  |  | 0 |  | Column F | Lunch is half an hour
2013-04-04 00:00:00 | 8.39 |  | 16.97 |  |  | 0 |  | Column G | Total hours worked formual E-C-F
2013-04-05 00:00:00 | 8.41 |  | 16.89 |  |  | 0
 |  |  | Total hours worked |  |  | 8 |  | Each week should total down to the hours worked per week
 |  |  |  |  |  |  |  | Finally each week should total down to show monthly hours worked
Week Three
Date | Start Time - Job card |  | End Time - Job card |  | Lunch | Hours worked
2013-04-08 00:00:00 | 8.39 |  | 17.46 |  |  | 0
2013-04-09 00:00:00 | 8.35 |  | 16.92 |  |  | 0
2013-04-10 00:00:00 | 8.27 |  | 16.96 |  |  | 0
2013-04-11 00:00:00 | 8.39 |  | 16.97 |  |  | 0
2013-04-12 00:00:00 | 8.27 |  | 17.01 |  |  | 0
2013-04-13 00:00:00 | 8.36 |  | 17.25 |  |  | 0
 |  |  | Total hours worked |  |  | 0
Week Four
Date | Start Time - Job card |  | End Time - Job card |  | Lunch | Hours worked
2013-04-15 00:00:00 | 8.31 |  | 16.86 |  |  | 0
2013-04-16 00:00:00 | 8.15 |  | 16.96 |  |  | 0
2013-04-17 00:00:00 | 8.26 |  | 16.98 |  |  | 0
2013-04-18 00:00:00 | 8.3 |  | 16.91 |  |  | 0
2013-04-19 00:00:00 | 8.17 |  | 16.94 |  |  | 0
 |  |  | Total hours worked |  |  | 0
 |  |  | Total hours worked for the Month |  |  | 49.05
Spreadsheet: 762030d1641370712-combine-columns-datas-for-identical-values-in-first-column-test5
Sheet: result

 | +ZX | t1 | t1 |  | i need in C column | <-- | t1 |  |  | i need in D column | <-- | t1
185 | +ZGuide(2)LIM(4) | t3 | t2|t3 |  |  |  | t3 |  |  |  |  | t2|t3
380 | ANC | [NAME] | [NAME] |  |  |  | [NAME] |  |  |  |  | [NAME]
10000 | +ZGuide(2)
10020 | +ZGuideLIM | t6 | t5|t6 |  |  |  | t6 |  |  |  |  | t5|t6
6000 | +ZGuideLIM | t8 | t7|t8 |  |  |  | t8 |  |  |  |  | t7|t8
 |  |  |  |  |  |  |  |  |  |  |  | symbol "|" on key "\" of keyboard.
Spreadsheet: john_griffith__16091__1_17_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 51 | 350 | 435 | 49.6 | 61.6 | 1.78 | 2002-01-17 14:43:00
 | [NAME] | 52 | 650 | 750 | 48.1 | 55.6 | 1.7 | 2002-01-17 14:43:00
 | HO J2 | 52 | 880 | 960 | 49.9 | 54.5 | 1.71 | 2002-01-17 14:43:00
 | HO K2 | 52 | 990 | 1080 | 46.6 | 50.9 | 1.59 | 2002-01-17 14:43:00
 | HO M2 | 53 | 1085 | 1185 | 43.6 | 47.6 | 1.52 | 2002-01-17 14:43:00
 | HO N2 | 53 | 1200 | 1240 | 43.9 | 45.4 | 1.49 | 2002-01-17 14:43:00
 | HO Q2 | 54 | 1255 | 1290 | 41.4 | 42.6 | 1.43 | 2002-01-17 14:43:00
 | HO U2 | 55 | 1250 | 1350 | 37.6 | 40.6 | 1.35 | 2002-01-17 14:43:00
 | [NAME] | 56 | 1300 | 1400 | 36.2 | 39 | 1.32 | 2002-01-17 14:43:00
 | HO X2 | 56 | 1400 | 1500 | 36.9 | 39.6 | 1.35 | 2002-01-17 14:43:00
 | [NAME] | 57 | 1400 | 1550 | 34.7 | 38.5 | 1.31 | 2002-01-17 14:43:00
 | HO F3 | 58 | 1400 | 1600 | 32.7 | 37.5 | 1.28 | 2002-01-17 14:43:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 799733d1665240143-assign-different-values-to-cells-and-sum-them-sumproduct-various-etaf
Sheet: Sheet1

October |  | Federica 1 | Gabriele | Martina | Luisa | Natale | Francesca | Stefano | October
Sum |  | 0,5 | 0,5 | 0,5 | 1 | 1 | 1,5 | 1,5
3 | lun | Ch Rob P | Ort P | 20 - 8 | Gin M | Amb | Oto M | [NAME] | 3 | lun
4 | [NAME] | NCH P | Amb | sn | 20 - 8 | NCH M | End Dig M | Vasc M | 4 | [NAME]
5 | [NAME] | Amb + BU P | [NAME] | [NAME] | sn | [NAME] | L | 20 - 8 | 5 | [NAME]
6 | gio | Ch Uni P | [NAME] | Oto M | BLS 9 17 |  | Amb + Uro Rob P | sn | 6 | gio
7 | ven | Ort M | 20 - 8 | NCH P | L | [NAME] | NCH M | Amb | 7 | ven
8 | sab |  | sn |  | FS |  | FS |  | 8 | sab
9 | dom |  |  |  |  | 20 - 8 |  | [NAME] | 9 | dom
10 | lun | Ocu M | Pom 2 | L | Amb | sn | BU P | L | 10 | lun
11 | [NAME] | Amb | 20 - 8 | End Uro M | Ort M | [NAME] |  | [NAME] | 11 | [NAME] |  | "20 - 8" in ven row = 0,5. For sab and dom rows: - amb = 0,5 - 20 - 8 = 1 - Urg M + Pom = 1 (not [NAME] = 1 + Pom = 1) - Urg 2 M + Pom 2 = 1 (like above) - Other text in cell or empty cell = 0
12 | [NAME] | BU P | sn | BLS 9 17 | NCH 8-17 | Vasc M  + Pom | Amb | [NAME] | 12 | [NAME]
13 | gio | Uro Rob M | [NAME] | Ch Uni M | [NAME] | [NAME] | End Uro M | Ort M | 13 | gio
14 | ven | 20 - 8 | NCH M | Uro Rob P | Ch Osp M | [NAME] | Ort M | [NAME] | 14 | ven
15 | sab | sn | FS | Amb |  | FS | FS |  | 15 | sab
16 | dom |  |  |  |  |  | 20 - 8 |  | 16 | dom
17 | lun | NCH 8-17 | [NAME] | Ort M | Amb | [NAME] P | sn | 20 - 8 | 17 | lun
18 | [NAME] | Ort M | NCH P | NCH M | Vasc M | Pom 2 | Vasc P | sn | 18 | [NAME]
19 | [NAME] | Ch [NAME] | [NAME] | [NAME] | 20 - 8 | L | NCH 8-17 | [NAME] | 19 | [NAME]
20 | gio | Amb | Gin M | Vasc M + Pom 2 | sn | Ort M + Pom | End Uro M | Oto M | 20 | gio
21 | ven | L | [NAME] | Ch Osp M |  | NCH P + Ch Osp M | Pom 2 | NCH M | 21 | ven
22 | sab |  |  |  | [NAME] |  | Amb |  | 22 | sab
23 | dom |  |  |  |  |  |  |  | 23 | dom
24 | lun | 20 - 8 | Ort M | Gin Rob P | NCH 8-17 | [NAME] | [NAME] | BU P | 24 | lun
25 | [NAME] | sn | End Dig M | 20--8 |  | Amb | Ort M | Gin M | 25 | [NAME]
26 | [NAME] | Vasc M | NCH 8-17 | sn | Ocu M | 20 - 8 | [NAME] |  | 26 | [NAME]
27 | gio | [NAME] |  | [NAME] | Amb | sn |  | [NAME] | 27 | gio
28 | ven | FS | [NAME] | FS | FS | FS | FS | Ort M + Ort P | 28 | ven
29 | sab | FS |  | FS | FS | FS | FS | Amb | 29 | sab
30 | dom | FS |  | FS | FS | FS | FS |  | 30 | dom
31 | lun |  | [NAME] | L | Gin P | NCH 8-17 | 20 - 8 | Amb | 31 | lun
Spreadsheet: 04bc89df-be24-4392-af58-24dea14ae4d3
Sheet: Sheet1

Group | Room | Mentor 2013
1 | H306 | Ainsworth, [NAME]
2 | J208 | Barlow, [NAME]
3 | [NAME] | Baughn, [NAME]
4 | J305 | Bensch, [NAME]
5 | J213 | Buxton, [NAME]
6 | J214 | [NAME], Lindsey
7 | Ccroft17 | Crosby, [NAME]
8 | Speed201 | Devries, [NAME]
9 | [NAME] | Everitt, Curtis
10 | Ccroft130 | Frautschi, [NAME]
11 | Ccroft24 | Gautier, [NAME]
12 | S301 | [NAME], Grant
13 | P104 | [NAME], Cole
14 | MCC103 | Caldwell, Will
15 | MCC105 | Hendry, [NAME]
16 | MCC104 | Howell, [NAME]
17 | S304 | [NAME], [NAME]
18 | N310 | [NAME], [NAME]
19 | N311 | [NAME], Elyssa
20 | A114 | [NAME], [NAME]
21 | H105 | Letson, Jared
22 | A109 | Long, J.B.
23 | P103 | Malley, [NAME]
24 | J307 | [NAME], [NAME]
25 | FHClassroom | Pfenninger, Darek
26 | S305 | Reed, Brooke
27 | S303 | [NAME], Andraya
28 | L402 | [NAME], [NAME]
29 | JA108 | Swede, [NAME]
30 | P106 | [NAME], [NAME]
31 | [NAME] | [NAME], [NAME]
32 | Speed206 | Traylor, [NAME]
33 | S307 | Waller, [NAME]
34 | H100 | Weaver, [NAME]
35 | H312 | West, Sydney
36 | L305 | Wilson, [NAME]
37 | S302 | Windham, Garrett
38 | J209 | [NAME], [NAME]
39 | JA104 | Faries, Myles
40 | L307 | [NAME], Amanda
Spreadsheet: 169106d1342703832-matching-prop-refs-to-addresses-example
Sheet: Costs

Prop Ref | Number | Road | Cost
 | 25 | ALDER DRIVE | 1213.159728565839
 | 27 | ALDER DRIVE | 1213.159728565839
 | 29 | ALDER DRIVE | 1213.159728565839
 | 31 | ALDER DRIVE | 1213.159728565839
 | 26 | ALDER DRIVE | 1146.118174658626
 | 28 | ALDER DRIVE | 1146.118174658626
 | 30 | ALDER DRIVE | 1146.118174658626
 | 32 | ALDER DRIVE | 1146.118174658626
 | 42 | ALDER DRIVE | 1073.782658813208
 | 44 | ALDER DRIVE | 1073.782658813208
 | 46 | ALDER DRIVE | 1073.782658813208
 | 48 | ALDER DRIVE | 1073.782658813208
 | 45 | ALDER DRIVE | 721.5194812495997
 | 47 | ALDER DRIVE | 721.5194812495997
 | 49 | ALDER DRIVE | 721.5194812495997
 | 51 | ALDER DRIVE | 721.5194812495997
 | 50 | ALDER DRIVE | 1019.305659772332
 | 52 | ALDER DRIVE | 1019.305659772332
 | 54 | ALDER DRIVE | 1019.305659772332
 | 56 | ALDER DRIVE | 1019.305659772332
 | 62 | ALDER DRIVE | 1010.907436561385
 | 64 | ALDER DRIVE | 1010.907436561385
 | 66 | ALDER DRIVE | 1010.907436561385
 | 68 | ALDER DRIVE | 1010.907436561385
 | 71 | ALDER DRIVE | 912.7478760415579
 | 73 | ALDER DRIVE | 912.7478760415579
 | 75 | ALDER DRIVE | 912.7478760415579
 | 77 | ALDER DRIVE | 912.7478760415579
 | 84 | ALDER DRIVE | 1034.574560520416
 | 86 | ALDER DRIVE | 1034.574560520416
 | 88 | ALDER DRIVE | 1034.574560520416
 | 90 | ALDER DRIVE | 1034.574560520416
Spreadsheet: 174020d1344887692-run-excel-over-several-computers-example
Sheet: Sheet1

Date |  |  | Vendor |  | Document Number |  | Invoice No. |  | PR Number
 |  |  |  |  |  |  |  |  | 320100
 | NAME AND ADDRESS OF VENDOR |  |  |  |  |  |  |  | ACTIVITY
 |  |  |  |  |  |  |  |  | GANG
 |  |  |  |  |  |  |  |  | OBJECT
 |  |  |  |  |  | APPROVED BY:
 |  |  |  |  |  | REQUESTED BY:
 |  |  | [NAME] |  |  |  |  | QUANTITY | UNIT PRICE | AMOUNT
Items: |  |  |  |  |  |  |  |  | Amount:
 |  |  |  |  |  |  |  |  | Freight:
 |  |  |  |  |  |  |  |  | Tire Fee:
 |  |  |  |  |  |  |  |  | Total:
Intended                                Use:
 |  |  |  |  |  |  |  |  | Total:
GL Account |  |  | Amount | Business Area | Fund | Cost Center |  | WBS Element |  | Functional Area
 |  |  |  | 276 |  | 27640       0300
 |  |  |  | 276 |  | 27640       0300
 |  |  |  | 276 |  | 27640       0300
 |  |  |  | 276 |  | 27640       0300
Spreadsheet: 830767d1685090648-return-the-last-value-livro8
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 1000 | 850 | 500 | 1100 | 1200 | 1500 | 1550 | 1350 | 1450 | 1200 | 1150 | 1450
 |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 150 | 250 | 300
Spreadsheet: 797009d1663669439-count-before-and-after-some-consecutive-condition-special-count
Sheet: גיליון1

count before | count after | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35
9 | 3
2 | 4
1 | 0
Spreadsheet: 84616d1284650926-index-match-with-several-criteria-workings
Sheet: Sheet1

 | Provider (please select)
 | P2 |  |  |  | [NAME] per week
Total Hours Supplied | 150 | hrs | 11 |  | Provider | Up to 200  hours | 201 hours to 499 | 500 hours to 999 | 1000 hours to 1999 | 20000 +
 |  |  |  |  | P1 | 10 | 15 | 20 | 25 | 30
 |  |  |  |  | P2 | 11 | 16 | 21 | 26 | 31
Spreadsheet: 144895d1331197965-copying-from-1-sheet-to-many-sheets-sales-records-sample
Sheet: PAUL SMITH

SALES SETTLEMENTS & RECEIPTS RECONCILIATION
2012
PAUL SMITH
Date | Invoice No | Client Name | Accounting Code | Model | Delivery Date | Qty | [NAME] | Ex-Stock / On Order | Amount | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Balance |  |  |  |  | DELIVERED | DEPOSIT OF | CHECKING IF DEPOSIT IS EQUAL TO  60%
 |  |  |  |  |  |  |  |  |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  |  |  |  |  |  | SALAH
 |  |  |  |  |  |  |  |  |  | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No |  |  |  |  |  | ON:
 |  |  |  |  |  |  |  |  | € | € |  | € |  | € |  | € |  | € |  | € |  | € |  | € |  | €
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 191087d1351896164-pivot-table-assistance-rag-pivot
Sheet: Data

Country | Business Unit | Colour 1 | [NAME] | Colour 3 | [NAME]
UK | MSA | Green | Amber | Green | Green
USA | TSA | Amber | Blue | Blue | Red
UK | MSA | Blue | Green | Amber | Green
UK | MSA | Green | Amber | Green | Green
USA | TSA | Amber | Blue | Blue | Red
USA | TSA | Blue | Amber | Red | Amber
USA | TSA | Amber | Green | Blue | Green
USA | TSA | Green | Green | Green | Green
USA | TSA | Blue | Green | Green | Blue
USA | TSA | Green | Red | Amber | Green
USA | TSA | Amber | Green | Blue | Red
USA | TSA | Blue | Amber | Green | Amber
USA | TSA | Green | Blue | Green | Green
USA | TSA | Blue | Amber | Blue | Blue
USA | TSA | Blue | Blue | Amber | Green
USA | TSA | Blue | Red | Green | Green
UK | TSA | Amber | Amber | Amber | Amber
UK | TSA | Red | Blue | Amber | Blue
UK | TSA | Blue | Red | Blue | Red
USA | MSA | Blue | Amber | Red | Green
USA | MSA | Red | Blue | Green | Amber
USA | MSA | Green | Green | Amber | Green
UK | MSA | Green | Amber | Green | Green
UK | TSA | Blue | Red | Blue | Red
UK | TSA | Blue | Red | Blue | Red
UK | TSA | Green | Red | Blue | Amber
UK | TSA | Amber | Amber | Amber | Red
UK | TSA | Green | Amber | Red | Red
UK | TSA | Green | Green | Green | Amber
Spreadsheet: 100593d1298922830-rearrange-table-layout-book23
Sheet: Sheet1

P/N: | QTY: | P/N: | QTY:
1234 | 2 | 789 | 5
5678 | 7 | 1234 | 3
9123 | 4 | 3333 | 1
45678 | 5 | 9123 | 2
 |  | 54678 | 6
Rquested Table:
P/N: | QTY: | P/N: | QTY:
 |  | 789 | 5
1234 | 2 | 1234 | 3
 |  | 3333 | 1
5678 | 7
9123 | 4 | 9123 | 2
45678 | 5 | 54678 | 6
[NAME] note: The P/N can be Numeric / Alphanumeric / Alphabetic values
Spreadsheet: 84401d1284464254-how-to-change-position-of-data-excel-forum-
Sheet: billbook

# invoice | Amount | Expiring date
1 | 100 | 2010-09-01 00:00:00
 | 300 | 2010-09-02 00:00:00
 | 200 | 2010-09-01 00:00:00
 | 150 | 2010-09-03 00:00:00
 | 250 | 2010-09-04 00:00:00
 | 350 | 2010-09-03 00:00:00
 | 250 | 2010-09-03 00:00:00
 | Accounts receivable
September | amount | Invoice #
2010-09-01 00:00:00
 |  | I would like the invoice # in A2:A8 in C13:F20
 |  | Below it's how I would like it.
 | Accounts receivable
September | amount | Invoice #
2010-09-01 00:00:00 |  | 1 | 3
 |  | 2
 |  | 4 | 6 | 7
 |  | 5
Spreadsheet: 15ecc6e5-a785-434c-9cf7-107c63a5cb69
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2013-2014 Unit Program Planner
ONLY ENTER DATA IN HIGHLIGHTED SPACES
1. Enter all your activities and costs per Scout under each month. |  |  | Unit Type and Unit # |  | 0
2. Enter your number of Scouts and unit commission %. |  |  | Number of Scouts in Unit |  | 0
3. Fill in the five shaded fields at the bottom of the sheet. |  |  | Unit Commission % |  | 0
September |  | October |  | November
Activities | Cost | Activities | Cost | Activities | Cost
Total Cost | 0 | Total Cost | 0 | Total Cost | 0
December |  | January |  | February
Activities | Cost | Activities | Cost | Activities | Cost
Total Cost | 0 | Total Cost | 0 | Total Cost | 0
March |  | April |  | May
Activities | Cost | Activities | Cost | Activities | Cost
Total Cost | 0 | Total Cost | 0 | Total Cost | 0
June |  | July |  | August
Activities | Cost | Activities | Cost | Activities | Cost
Total Cost | 0 | Total Cost | 0 | Total Cost | 0
0 | Registration & Insurance |  | Unit Total Activity Cost & Expenses |  | 0
0 | Boys' Life |  | Scout Total Activity Cost & Expenses |  | 0
0 | Uniform |  | Other Expenses |  | 0
0 | Advancements |  | Unit [NAME]
0 | Total Expenses |  | Scout Sales Goal
 |  |  | Unit Commission
Spreadsheet: 761643d1641132042-dynamic-column-reference-in-filter-command-filter-fomrula-example
Sheet: data

First Name | Last Name | Gender | Weight | Age | SUN | MON | TUE | WED | THU | FRI | SAT
[NAME] | Bystander | Male | 250 | 28 | Y | Y | Y | Y | Y | N | N
Tamara | [NAME] | Female | 125 | 19 | N | N | Y | Y | Y | Y | N
Mutt | Hendrix | Male | 200 | 42 | N | N | N | N | Y | Y | Y
[NAME] | Stouffer | Male | 175 | 22 | Y | Y | Y | Y | N | N | Y
Mark | Reeves | Male | 250 | 30 | Y | N | Y | N | Y | N | Y
Cathy | Sample | Female | 130 | 34 | Y | N | N | Y | Y | Y | N
Deesha | Mchendra | NA | 290 | 28 | N | N | N | N | N | N | N
Spreadsheet: e1b0c04a-fc7e-4d05-91c2-2e209ee6a02f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MAAN | Test | MAAN | Maleic Anhydride, IgE | Maleic Anhydride, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
MAAN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MAAN | Result | MAAN | Maleic Anhydride, IgE | Maleic Anhydride, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 19746-7 | Maleic anhydride [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: e13f1f8c-d68c-46f0-9a1e-2e837c5448a3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7988 | 10254 | Luisella | [NAME] | ITA | 112 | [NAME] | 00:00:00 | 00:39:43 | 00:00:00 | [NAME] | 1 | 02:03:13
Spreadsheet: 103044d1300893560-excel-2007-data-validation-du
Sheet: Sheet3

[NAME] | 234 | 235 | 236 | 237
[NAME] | 532 | 533 | 534 | 535
[NAME] | 532 | 533 | 534 | 535
[NAME] | 345 | 346 | 347 | 348
Spreadsheet: sally_beck__35194__EGM_MgmtSum-Q4-1019
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  | 4TH QTR 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME]
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Transportation
Overview |  |  |  |  |  | 0 | 0
Office of the Chairman
Subtotal Commercial
LNG
Middle East
Puerto Rico
Subtotal LNG / ME / PR
Total Commercial
Group Support Cost |  | 0 | 0
Support Cost Allocated to Teams |  | 0 | 0
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
Interest Expense/(Income)
Global Markets Pre-tax Income
(1) Includes Capital Charge & Operating, Direct, and Allocated Expenses