tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813810d1674003252-final-criteria-not-working-final-criteria-not-working
Sheet: Sheet1

Type | Sales Rep | Booked | INV | INV $ | Related Bill | Cost | Organisation | Name | Start Date | End Date | Status | Buy Type
 |  | 2022-07-01 00:00:00 | INV-3082 | 7188 | INV-3281 | 7188 | Spon | Name 1 | 2022-07-01 00:00:00 | 2022-08-18 00:00:00 | Completed | Content
 |  | 2022-07-01 00:00:00 | INV-3082 | 5463 | INV-3282 | 5463 | Spon | Name 2 | 2022-07-01 00:00:00 | 2022-09-08 00:00:00 | Ended | Content
 |  | 2022-07-01 00:00:00 | INV-3082 | 4025 | INV-3283 | 4025 | CPC | Name 3 | 2022-07-01 00:00:00 | 2022-10-05 00:00:00 | Completed | Content
 |  | 2022-07-01 00:00:00 | INV-3082 | 4025 | INV-3284 | 4025 | Spon | Name 1 | 2022-07-01 00:00:00 | 2022-07-05 00:00:00 | Ended | Content
 |  | 2022-07-01 00:00:00 | INV-3082 | 3450 | INV-3285 | 3450 | INCA | Name 2 | 2022-07-01 00:00:00 | 2022-11-18 00:00:00 |  | Content
 |  | 2022-07-01 00:00:00 | INV-3082 | 8050 | INV-3286 | 8050 | Spon | Name 3 | 2022-07-01 00:00:00 | 2022-08-09 00:00:00 |  | Content
 |  | 2022-07-01 00:00:00 | INV-3082 | 8970 | INV-3287 | 8970 | CPC | Name 1 | 2022-07-01 00:00:00 | 2022-07-18 00:00:00 | Ended | Content
 |  | 2022-07-01 00:00:00 | INV-3082 | 8234.2 | Fabulate Fee | - | INCA | Name 2 | 2022-07-01 00:00:00 | 2022-12-05 00:00:00 | Completed | Content
 |  |  |  | Paid
 |  | Booked |  | 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 | 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
No Status set |  | 2022-07-01 00:00:00
Status "Completed" |  | 2022-07-01 00:00:00
Status "Ended" |  | 2022-07-01 00:00:00
Status either |  | 2022-07-01 00:00:00
 |  |  |  | "=SUMIFS($E$1:$E$10,$K$1:$K$10,">="&E$12,$K$1:$K$10,"<="&EOMONTH(E$12,0),$C$1:$C$10,">="&$C$13,$C$1:$C$10,"<="&EOMONTH($c13,0),L1:L10,"Completed",L1:L10,"Ended")"
 |  |  |  | Total invoices (Col E) if they were booked (Col C) in July, ended (Col K) in July, and the Status (Col L) is either "Completed" or "Ended"
 |  | S/be:
 |  |  |  | Paid
 |  | Booked |  | 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 | 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
 |  | 2022-07-01 00:00:00
Spreadsheet: 759160d1639385847-nested-if-statements-and-their-sums-sumproduct-example-2-aligw
Sheet: Sheet2

Date |  | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | G | H | I | J | K | L | Cost | Fees | Revenue
1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
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
Spreadsheet: 41323d1239804597-graphing-gains-and-losses-of-personnel-679843
Sheet: Sheet1

Name | Gain | Lost |  |  | Count | SpikeCount
Fred | 2009-01-01 00:00:00 | 2009-01-29 00:00:00 |  | 2009-01-01 00:00:00 | 1 | 1
Johny | 2009-01-15 00:00:00 | 2009-02-10 00:00:00 |  | 2009-01-15 00:00:00 | 2 | 2
[NAME] | 2009-02-17 00:00:00 | 2009-03-22 00:00:00 |  | 2009-01-29 00:00:00 | 2 | #N/A
Betty | 2009-03-02 00:00:00 | 2009-04-01 00:00:00 |  | 2009-02-10 00:00:00 | 1 | 1
Scobby | 2009-03-18 00:00:00 | 2009-05-26 00:00:00 |  | 2009-02-17 00:00:00 | 1 | #N/A
 |  |  |  | 2009-03-02 00:00:00 | 2 | 2
 |  |  |  | 2009-03-18 00:00:00 | 3 | 3
 |  |  |  | 2009-03-22 00:00:00 | 3 | #N/A
 |  |  |  | 2009-04-01 00:00:00 | 2 | 2
 |  |  |  | 2009-05-26 00:00:00 | 1 | 1
Spreadsheet: 701943d1603996491-large-data-transpose-by-removing-duplicates-on-specific-rows-large-data-transpose
Sheet: Sample

Sample 1
 | PAYROLL NO., CARD NO. & NAME |  |  |  | 16385,C11302,Joseph |  |  |  |  |  |  |  | Present 21 |  | Holiday 0 |  | [NAME] | 4 | Absent 1 |  | Leave | 5 | Hour Work |  | 168.49 | OT | 9.25
 |  |  |  |  | Designation
 | IN1 | 09:52 | 09:48 | 10:07 |  |  | 09:33 | 09:43 |  | 10:04 | 10:09 |  |  | 09:55 | 09:07 | 10:24 | 09:12 | 09:53 |  |  | 10:07 | 08:57 | 09:03 | 09:36 | 09:06 |  |  | 09:44 | 09:16 | 09:11 | 09:13
 | Out1
 | IN2
 | Out2 | 17:06 | 17:07 | 17:04 |  |  | 17:38 | 17:04 |  | 17:43 | 17:40 |  |  | 18:07 | 18:05 |  |  | 18:07 |  |  | 19:11 | 18:47 | 19:35 | 19:52 | 19:21 |  |  | 17:50 | 17:54 | 18:00 | 18:11
 | H Work | 07.14 | 07.19 | 06.57 |  |  | 08.05 | 07.21 |  | 07.39 | 07.31 |  |  | 08.12 | 08.58 |  |  | 08.14 |  |  | 09.04 | 09.50 | 10.32 | 10.16 | 10.15 |  |  | 08.06 | 08.38 | 08.49 | 08.58
 | OT |  |  | 02.17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00.04 | 00.50 | 01.32 | 01.16 | 01.15
 | Status | SRT | SRT | HLF | OD | WO | SRT | SRT | OD | SRT | SRT | OD | WO | SRT | P | MIS | MIS | SRT | OD | WO | P | P | P | P | P | OD | WO | SRT | SRT | SRT | P
 |  | 26 | 27 | 29 | 30 | 31 | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
Sample 2
 | Employee Code | 123
 | Employee Name | [NAME]
 | Department | xxxx
 | Unit Code | xxxx
 | Start Date | xxxx
 | End Date | xxxx
 | Shift In Time | xxxx
 | Original In Time | xxxx
 | Shift Out Time | xxxx
 | Original Out Time | xxxx
 | Work Hours | xxxx
 | OT hours | xxxx
 | Status | xxxx
 | Shift | xxxx
 | Late/Early Status | xxxx
 | Late/Early Timings | xxxx
Spreadsheet: 722984d1615469570-formula-copy-number-of-rows-based-on-cell-value-file-1-formula-needed
Sheet: Sheet1

Name | Type |  | Type | Total Active Type 1-10)
[NAME] |  |  | A
[NAME] |  |  | B
Adam |  |  | C
 |  |  | D
 |  |  | E
In need this in next sheet:
Spreadsheet: 548151d1510901563-timesheet-time-calculation-for-multiple-jobs-type-correct-file
Sheet: Sheet1

DAY | DOCKET | CONTRACT | JOB | SITE DETAILS | TRAVEL | SITE |  | HOURS | JOB TYPE
 |  |  |  |  | TO SITE | START | FINISH | WORKED
1 | c12345 | xxx1 | 51690 | test site 1 | 0.25 | 09:00:00 | 09:30:00 |  | MAINTENANCE
2 | c12346 | xxx2 | 51691 | test site 2 | 0.75 | 08:00:00 | 08:15:00 |  | REPAIR
3 | c12347 | xxx3 | 51692 | test site 3 | 1 | 08:00:00 | 13:00:00 |  | INSTALL
4 | c12348 | xxx4 | 51693 | test site 4 | 0.5 | 08:45:00 | 09:30:00 |  | EXTRA WORK
5 | c12349 | xxx5 | 51694 | test site 5 | 1.5 | 10:30:00 | 11:45:00 |  | OFFICE WORK
6 | C12350 | xxx1 | 20127 | test site 1 | 0.25 | 09:00:00 | 09:30:00 |  | MAINTENANCE
7 | C12350 | xxx4 | 60216 | test site 4 | 0.75 | 08:00:00 | 08:15:00 |  | MAINTENANCE
8 | C12351 | xxx3 | 12654 | test site 3 | 1 | 08:00:00 | 13:00:00 |  | INSTALL
9 | C12352 | [NAME] | 125 | test site 8 | 0.5 | 08:45:00 | 09:30:00 |  | INSTALL
10 | C12353 | xxx9 | 99127 | test site 9 | 1.5 | 10:30:00 | 11:45:00 |  | REPAIR
 |  |  |  | SUB TOTAL |  | - | -
[NAME] TOTAL
REPAIR HOURS TOTAL
INSTALL HOURS TOTAL
EXTRA WORK HOURS TOTAL
OFFICE WORK HOURS TOTAL
Spreadsheet: 46912d1245841759-confirming-if-multiple-rows-of-numbers-run-in-sequence-test
Sheet: Sheet2

35733 | 41066 | 46993 | 52785 | 58453 | 64753 | 71221 | 77536 | 84764 | 89896 | 96774 | 106826 | 109081 | 115824
7047 | 8816 | 10701 | 12758 | 14574 | 16498 | 18336 | 20091 | 22099 | 23476 | 94746 | 28993 | 28634 | 30334
34381 | 39387 | 40057 | 51142 | 57057 | 63414 | 69776 | 75950 | 83198 | 88194 | 25269 | 73593 | 107021 | 113373
23355 | 26691 | 30371 | 34589 | 38621 | 43002 | 47518 | 51891 | 56920 | 60393 | 69559 | 106836 | 73935 | 78210
32152 | 34978 | 38479 | 42458 | 46095 | 50097 | 54281 | 58260 | 62506 | 65483 | 65216 | 73593 | 77239 | 80835
29827 | 33159 | 37111 | 41654 | 43875 | 50552 | 55365 | 60186 | 65450 | 69142 | 76621 | 81906 | 83515 | 87967
30072 | 33858 | 38062 | 42766 | 47112 | 52099 | 57123 | 62177 | 67754 | 71546 | 74231 | 88140 | 86334 | 91024
3686 | 5904 | 8471 | 11026 | 13389 | 10000 | 18499 | 21025 | 23698 | 25570 | 28079 | 31266 | 32631 | 34971
18465 | 21322 | 24609 | 27959 | 30943 | 34148 | 37459 | 40628 | 44203 | 46887 | 50313 | 57023 | 56767 | 59789
31288 | 37860 | 44879 | 52213 | 59119 | 66368 | 73345 | 80122 | 87025 | 92121 | 98733 | 108977 | 111071 | 117520
24552 | 28250 | 32575 | 36843 | 40826 | 45312 | 49620 | 53897 | 58693 | 62163 | 66559 | 76472 | 74581 | 78733
19814 | 23884 | 27939 | 32174 | 39236 | 40070 | 44127 | 48185 | 51103 | 55903 | 60002 | 69221 | 67048 | 70674
23604 | 27166 | 34100 | 35599 | 35950 | 43353 | 47084 | 50930 | 40000 | 58219 | 62375 | 72269 | 69505 | 72992
33992 | 37997 | 42465 | 46884 | 50858 | 54709 | 58256 | 61695 | 65994 | 68646 | 72312 | 78477 | 78576 | 81641
30199 | 34290 | 38199 | 42184 | 45896 | 49869 | 53909 | 57922 | 62379 | 65985 | 70135 | 77427 | 77445 | 80893
15146 | 16159 | 17605 | 20243 | 21246 | 22112 | 22894 | 24091 | 25853 | 27394 | 28571 | 34602 | 31257 | 32106
15359 | 16551 | 18668 | 21387 | 22339 | 22974 | 23534 | 24457 | 25219 | 26440 | 27315 | 33055 | 28635 | 29382
18584 | 20056 | 22226 | 23428 | 24275 | 25511 | 26972 | 28895 | 30941 | 32172 | 34406 | 43979 | 37085 | 37825
4859 | 5713 | 6940 | 7684 | 8173 | 8892 | 9760 | 10988 | 12100 | 12865 | 14389 | 19360 | 16065 | 16554
26521 | 30822 | 35743 | 40560 | 44889 | 49684 | 54618 | 59793 | 65199 | 69412 | 74379 | 82669 | 83985 | 88860
7139 | 8696 | 10495 | 12292 | 13734 | 15389 | 17263 | 19389 | 20057 | 23416 | 25611 | 29249 | 29087 | 30847
Spreadsheet: elizabeth_sager__9579__socal
Sheet: Sheet1

DEAL # | EOL # | COUNTERPARTY | DEAL DATE | FLOW START | FLOW END | PRICE | VOLUME | TRADER | DELIVERY POINT | DEAL TYPE | CATEGORY | BUY/SALE | PHYSICAL/FINANCIAL | FIRMNESS
461072.1 |  | Southern California Edison Company | 2000-11-16 00:00:00 | 2001-01-01 00:00:00 | 2005-12-31 00:00:00 | 60 | 1228800 | [NAME]  Motley | SP-15 | FORWARD | CMDTY | S | P | CAISO Energy
469388.1 |  | Southern California Edison Company | 2000-11-29 00:00:00 | 2001-07-01 00:00:00 | 2001-09-30 00:00:00 | 127.5 | 110400 | [NAME] | SP-15 | FORWARD | CMDTY | S | P | CAISO Energy
Spreadsheet: 07170347-c73d-455d-ba96-c698d91c2f13
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 175 |  |  |  | 175
 | ALLEGHENY |  |  |  | 4636 | 4636
 | ARMSTRONG |  |  |  | 440 | 440
 | BEAVER |  |  |  | 798 | 798
 | BEDFORD |  |  |  | 315 | 315
 | BERKS | 1014 |  |  |  | 1014
 | BLAIR |  |  |  | 642 | 642
 | BRADFORD |  |  | 159 |  | 159
 | BUCKS |  | 1633 |  |  | 1633
 | BUTLER |  |  |  | 816 | 816
 | CAMBRIA |  |  |  | 1201 | 1201
 | CAMERON |  |  |  | 47 | 47
 | CARBON |  |  | 195 |  | 195
 | CENTRE | 325 |  |  | 124 | 449
 | CHESTER |  | 844 |  |  | 844
 | CLARION |  |  |  | 225 | 225
 | CLEARFIELD |  |  |  | 775 | 775
 | CLINTON |  |  | 113 |  | 113
 | COLUMBIA | 200 |  |  |  | 200
 | CRAWFORD |  |  |  | 495 | 495
 | CUMBERLAND | 357 |  |  |  | 357
 | DAUPHIN | 505 |  |  |  | 505
 | DELAWARE |  | 1814 |  |  | 1814
 | ELK |  |  |  | 325 | 325
 | ERIE |  |  |  | 1924 | 1924
 | FAYETTE |  |  |  | 943 | 943
 | FOREST |  |  |  | 31 | 31
 | FRANKLIN | 329 |  |  |  | 329
 | FULTON | 52 |  |  |  | 52
 | GREENE |  |  |  | 285 | 285
 | HUNTINGDON |  |  |  | 253 | 253
 | INDIANA |  |  |  | 564 | 564
 | JEFFERSON |  |  |  | 311 | 311
 | JUNIATA | 78 |  |  |  | 78
 | [NAME] |  |  | 448 |  | 448
 | LANCASTER | 777 |  |  |  | 777
 | [NAME] |  |  |  | 538 | 538
 | LEBANON | 199 |  |  |  | 199
 | LEHIGH | 731 |  |  |  | 731
 | LUZERNE |  |  | 748 |  | 748
 | LYCOMING |  |  | 185 |  | 185
 | MCKEAN |  |  |  | 234 | 234
 | MERCER |  |  |  | 580 | 580
 | MIFFLIN | 207 |  |  |  | 207
 | MONROE |  |  | 354 |  | 354
 | MONTGOMERY |  | 2067 |  |  | 2067
 | MONTOUR | 23 |  |  |  | 23
 | NORTHAMPTON | 507 |  |  |  | 507
 | NORTHUMBERLAND | 284 |  |  |  | 284
 | PERRY | 140 |  |  |  | 140
 | PHILADELPHIA |  | 7890 |  |  | 7890
 | PIKE |  |  | 106 |  | 106
 | POTTER |  |  |  | 154 | 154
 | SCHUYLKILL | 367 |  |  |  | 367
 | SNYDER | 85 |  |  |  | 85
 | [NAME] |  |  |  | 633 | 633
 | SULLIVAN |  |  | 20 |  | 20
 | SUSQUEHANNA |  |  | 185 |  | 185
 | TIOGA |  |  | 139 |  | 139
 | UNION | 75 |  |  |  | 75
 | VENANGO |  |  |  | 334 | 334
 | WARREN |  |  |  | 230 | 230
 | WASHINGTON |  |  |  | 936 | 936
 | WAYNE |  |  | 133 |  | 133
 | WESTMORELAND |  |  |  | 2066 | 2066
 | WYOMING |  |  | 63 |  | 63
 | YORK | 636 |  |  |  | 636
 | Totals | 7066 | 14248 | 2848 | 20855 | 45017
Spreadsheet: 24215d1214355048-excel-2007-updating-results-across-sheets-automatically-pfb2
Sheet: Sheet2

 |  |  |  |  |  | POWER RATING | POWER RATING1
 |  |  |  | 1 | ARSENAL
 |  |  |  |  | ASTON VILLA
 |  |  |  |  | BLACKBURN
 |  |  |  |  | BOLTON
 |  |  |  |  | CHARLTON
 |  |  |  |  | CHELSEA
 |  |  |  |  | DERBY
 |  |  |  |  | EVERTON
 |  |  |  |  | FULHAM
 |  |  |  |  | IPSWICH
 |  |  |  |  | LEEDS
 |  |  |  |  | LEICESTER
 |  |  |  |  | LIVERPOOL
 |  |  |  |  | MAN UTD
 |  |  |  |  | MBORO
 |  |  |  |  | NEWCASTLE
 |  |  |  |  | SOUTHAMPTON
 |  |  |  |  | SPURS
 |  |  |  |  | SUNDERLAND
 |  |  |  |  | WEST HAM
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 25

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-25 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 604 |  | 390 |  | 67694 |  |  |  |  |  |  | 40 | 1 | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 2 | 43
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 2718 |  | 2077 |  | 67694 |  |  |  |  |  |  | 40 | 3 | 41
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 42 | 4 | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 5 | 46
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1200 |  | 1077 |  | 67694 |  |  |  |  |  |  | 41 | 6 | 42
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 40 | 7 | 41
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 45 | 8 | 47
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 45 | 9 | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 15 | 55
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 9018 |  | 9650 |  | 67694 |  |  |  |  |  |  | 43 | 35 | 51
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 42 | 39 | 43
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 986 |  | 889 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 680 |  | 603 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 6730 |  | 4944 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2563 |  | 2459 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 1562 |  | 1334 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 3205 |  | 2643 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 238 |  | 0 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 26 |  | 25 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20146 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69079 | 20596 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 171990d1343939994-drop-down-list-box-help-urgent-please-drop-down-day92
Sheet: Sheet1

December |  |  |  |  |  |  |  |  |  |  |  |  |  | January | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | February | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | March | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | April | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | May | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | June | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | July | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | August | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | September | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | October | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | November | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | December | 12
Spreadsheet: 436a39d2-0dd1-4a72-983f-42fb0d2ac2af
Sheet: Bristol Dental-Santa Ana

Bristol Family Dental Center, Dr. [NAME], DDS
2618 S. Bristol St.
Santa Ana, CA  92704
Main Phone Line: (714) 540-7101
Main Fax: (714) 540-6061
Name and Title | Role | Contact Email | Contact Phone Number | Fax Number
Dr. [NAME], DDS | Provides general dentistry services | N/A | N/A | N/A
[NAME] | Office Manager | N/A | 7145407101 | 7145406061
[NAME] | Office Assistant | N/A | 7145407101 | 7145406061
Spreadsheet: mark_taylor__24798__EII Roster 050400
Sheet: Sheet1

Name | Title | Phone | Location | E-Mail | Business Unit
BEYER, MICHAEL | VP | [PHONE] | Pittsburgh | [EMAIL] | ENA
BLACK, [NAME] | VP | [PHONE] | EB 3118B | [EMAIL] | ENA
BLESIE, BRADLEY R | VP | [PHONE] | 3AC 4400 | [EMAIL] | ENA
BOOTS, KELLY | VP | [PHONE] | EB 2751 | [EMAIL] | CORP
CAPELES, [NAME] | Executive VP | [PHONE] | Miramar, P.R. | jose.capeles.enron.com | CALME
DANIELS, STEVEN | VP-Bus Dev | [PHONE] | Redmond, WA | [EMAIL] | CORP
[NAME], [NAME] | President | [PHONE] | Redmond, WA | [EMAIL] | EE&CC
KOHLI, SANDEEP | VP Commercial | 8239856-248 | Mumbai, India | [EMAIL] | ENRON INDIA
LARSON, BRADFORD O | VP | [PHONE] | EB 2864 | [EMAIL] | CORP
MAHAN, MARIELLA | VP-Central American | [PHONE] | 3AC 1697 | [EMAIL] | CALME
MOORE, [NAME] | VP | [PHONE] | eb638 | [EMAIL] | EES
NEUBAUER, DAVE | VP Bus. Dev. & Mktg. | [PHONE] | OMA 656 | [EMAIL] | GPG
SALTIEL, ROB | VP | [PHONE] | London | [EMAIL] | ENRON EUROPE
SOLDANO, LOUIS | VP/Asst. Gen. [NAME] | [PHONE] | EB 4780 | [EMAIL] | GPG
STEFFES, [NAME] | VP | [PHONE] | EB 4711C | [EMAIL] | EES
TAYLOR, MARK | VP/Asst. Gen. [NAME] | [PHONE] | EB3889 | [EMAIL] | ENA
[NAME], [NAME] | VP | (713) 853-3476 | EB 1826 | [EMAIL] | EGEP
WALTENSPUEL, CHRISTOPHER | VP | [PHONE] | Enron House - London | [EMAIL] | ENRON EUROPE
ZDUNKEWICZ, RICHARD | VP | [PHONE] | EB-646 | [EMAIL] | EES
Spreadsheet: 854068d1704036417-choose-col-with-with-filter-choose-cols-filter-data-added
Sheet: Sheet3

 | Your expected results:
 | 1 | 75 | The  American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] ( (Main)) | 6 | 45 | 40
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd | 2 | 9 | 11
 | My formula:
 |  | 75 | The American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] (Main)) | 6 | 45 | 40
 | 8 |  | #N/A | 2 | 9 | 11
 | 145 |  | #N/A | 0 | 0 | 0
 |  |  | #N/A |  | 0 | 0
 |  |  | #N/A |  | 0 | 0
 |  | 75 | The American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] ( (Main)) | 6 | 45 | 40
 | 8 | 0 | Myselfi & Associates Trading Pvt.Ltd | 2 | 9 | 11
 | 145 | 0 | Jenite Licohetic | 0 | 0 | 0
Spreadsheet: 113729d1309542561-complex-drop-down-full_classlist
Sheet: Sheet1

Helper | Class | Student | Age |  |  | Class | English
0 | Spanish | Student 1 | 20
0 | Spanish | Student 2 | 19
0 | Spanish | Student 3 | 20 |  |  | Student 16 | 19
0 | Spanish | Student 4 | 20 |  |  | Student 17 | 20
0 | Spanish | Student 5 | 19 |  |  | Student 18 | 19
0 | Spanish | Student 6 | 20 |  |  | Student 19 | 20
0 | Spanish | Student 7 | 20 |  |  | Student 1 | 19
0 | Spanish | Student 8 | 19 |  |  | Student 2 | 20
0 | Spanish | Student 9 | 20 |  |  | Student 3 | 19
0 | Spanish | Student 10 | 20 |  |  | Student 4 | 20
0 | Math | Student 6 | 19 |  |  | Student 5 | 19
0 | Math | Student 7 | 20 |  |  | Student 6 | 20
0 | Math | Student 8 | 19 |  |  | - | -
0 | Math | Student 9 | 20 |  |  | - | -
0 | Math | Student 10 | 19 |  |  | - | -
0 | Math | Student 11 | 20 |  |  | - | -
0 | Math | Student 12 | 19 |  |  | - | -
0 | Math | Student 13 | 20 |  |  | - | -
0 | Math | Student 14 | 19 |  |  | - | -
0 | Math | Student 15 | 20 |  |  | - | -
1 | English | Student 16 | 19 |  |  | - | -
2 | English | Student 17 | 20 |  |  | - | -
3 | English | Student 18 | 19 |  |  | - | -
4 | English | Student 19 | 20 |  |  | - | -
5 | English | Student 1 | 19 |  |  | - | -
6 | English | Student 2 | 20 |  |  | - | -
7 | English | Student 3 | 19 |  |  | - | -
8 | English | Student 4 | 20
9 | English | Student 5 | 19
10 | English | Student 6 | 20
Spreadsheet: 785047d1656097074-importing-data-from-one-tab-into-another-test-data
Sheet: Sheet1

AJ011100 | 124 bent street | 4521.12
AJ011101 | 15 hell street | 999.25 |  | 15102
AJ011102 | 19 bell street | 145.25 |  | 15103
AJ011103 | 8 banana avenue | 1245.02 |  | 15104
AJ011104 | 8 great hill | 125.36 |  | 15105
AJ011105 | 96 hump hill | 178.36 |  | 15106
AJ011106 | 14 hastle drive | 542.36 |  | 15107
AJ011107 | 6 millers way | 2.36 |  | 15108
Spreadsheet: 135328d1325940691-gps-matrix-exemple-dist-calc
Sheet: Cities

City | LATITUDE | LONGITUDE
A | 27.13 | 57.95
B | 26.44 | 57.88
C | 27.9 | 59.27
D | 26.18 | 59.39
E | 27.26 | 60.05
F | 27.14 | 57.92
G | 25.93 | 58.1
H | 25.61 | 57.89
I | 27.85 | 59.77
J | 27.33 | 57.84
Spreadsheet: tracy_geaccone__40248__C0366-111726
Sheet: Dept_100186

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
FACILITY OPERATIONS - Dept. 100186
January, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Requisitioner Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111726
2000-11-01 00:00:00 | FRK120000882 |  | ENRON 40-4052 | MAINTENANCE | 1 | 12.56 | /EACH | 12.56
 |  |  |  |  |  |  | Ticket Total |  | 12.56
2000-11-01 00:00:00 | FRK120000883 |  | ENRON 40-4052 | MAINTENANCE | 1 | 12.45 | /EACH | 12.45
 |  |  |  |  |  |  | Ticket Total |  | 12.45
2000-11-01 00:00:00 | FRK120000884 |  | ENRON 40-4052 | MAINTENANCE | 1 | 10.01 | /EACH | 10.01
 |  |  |  |  |  |  | Ticket Total |  | 10.01
2000-11-01 00:00:00 | [NAME] |  | ENRON 40-4052 | MAINTENANCE | 1 | 10.01 | /EACH | 10.01
 |  |  |  |  |  |  | Ticket Total |  | 10.01
2000-11-01 00:00:00 | FRK120000886 |  | ENRON 40-4052 | MAINTENANCE | 1 | 6.28 | /EACH | 6.28
 |  |  |  |  |  |  | Ticket Total |  | 6.28
2001-01-24 00:00:00 | FOP100186-2001-01-0366-111726 |  | Facilities Operations | Sq. Ft. Occupied | 1097 | 0.05 | /EACH | 51.56
 |  |  |  |  |  |  | Ticket Total |  | 51.56
 |  |  |  |  |  |  | Total for R/C: 111726 |  | 102.87
 |  |  |  |  |  |  | Total for Dept_100186 |  | 102.87
Spreadsheet: 3fc3ae15-1420-47c9-9d58-605fad82073f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6847 | 51373 | Danielle | Mclaughlin | USA | 12 | 00:16:22 | 00:02:18 | 00:53:37 | 00:01:04 | 00:21:47 | 1 | 01:35:08