tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117589d1312900707-recalculating-formulas-after-running-a-macro-output-example
Sheet: Billable Hours

 | Quantity | Multiplier | Hourly Type | [NAME] | Duration Units | Total Billable Hours | Total Cost
1.1.4. | 1 | 1 | Project Manager | 50 | 2 | 2 | 100
1.1.5. | 1 | 1 | Consultant | 60 | 4 | 4 | 240
1.1.6. | 1 | 1 | Administrator | 40 | 5 | 5 | 200
1.1.7. | 1 | 1 | Engineer | 70 | 6 | 6 | 420
1.2.3. | 1 | 1 | Consultant | 60 | 5 | 5 | 300
1.2.4. | 1 | 1 | Administrator | 40 | 3 | 3 | 120
1.2.5. | 1 | 1 | Engineer | 70 | 6 | 6 | 420
1.2.6. | 1 | 1 | Consultant | 60 | 4 | 4 | 240
2.1.2. | 1 | 1 | Consultant | 60 | 4 | 4 | 240
2.1.3. | 1 | 1 | Administrator | 40 | 2 | 2 | 80
2.1.4. | 1 | 1 | Administrator | 40 | 1 | 1 | 40
2.1.5. | 1 | 1 | Consultant | 60 | 5 | 5 | 300
2.1.6.2. | 1 | 1 | Project Manager | 50 | 6 | 6 | 300
2.2.3. | 1 | 1 | Engineer | 70 | 8 | 8 | 560
2.2.4. | 1 | 1 | Project Manager | 50 | 4 | 4 | 200
2.2.5. | 1 | 1 | Project Manager | 50 | 2 | 2 | 100
2.2.6. | 1 | 1 | Consultant | 60 | 6 | 6 | 360
2.3.2. | 1 | 1 | Engineer | 70 | 3 | 3 | 210
2.3.3. | 1 | 1 | Consultant | 60 | 5 | 5 | 300
2.3.4. | 1 | 1 | Administrator | 40 | 4 | 4 | 160
2.3.5. | 1 | 1 | Consultant | 60 | 5 | 5 | 300
2.4.2. | 1 | 1 | Project Manager | 50 | 1 | 1 | 50
2.4.3. | 1 | 1 | Engineer | 70 | 2 | 2 | 140
2.4.4. | 1 | 1 | Consultant | 60 | 5 | 5 | 300
2.4.5. | 1 | 1 | Administrator | 40 | 1 | 1 | 40
2.5.1. | 1 | 1 | Engineer | 70 | 5 | 5 | 350
2.5.2. | 1 | 1 | Consultant | 60 | 8 | 8 | 480
2.5.3. | 1 | 1 | Project Manager | 50 | 5 | 5 | 250
2.5.4. | 1 | 1 | Engineer | 70 | 9 | 9 | 630
2.6. | 1 | 1 | Consultant | 60 | 6 | 6 | 360
2.7. | 1 | 1 | Administrator | 40 | 7 | 7 | 280
Spreadsheet: darrell_schoolcraft__7818__imbalsumm0109
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
NNG |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Volumetric | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | if changed to volumetric the volume would be 61,000 mmbtus
[NAME] |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Northwest |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
TransColorado |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Continental |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -175
2
3 |  | -2000
4
5 |  | -16528
6 | -31547 | -16528
7 | -17414 | -16528
8 | -10189 | -10500
9 | -17552 | -15935
10 | -9962 | -15500
11 | -70735 | -71187
12 | -58208 | -59296
13 | -57826 | -59296
14 | -57796 | -59296
15 | -24830 | -25514
16 | -29576 | -21882
17 | -28848 | -30000
18 | -53049 | -55009
19 | -42986 | -43709
20 | -42941 | -43709
21 | -42980 | -43709
22 | -16682 | -7709
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -14315
2002-01-22 00:00:00
CBS Dollars
 |  |  | 163235
Spreadsheet: 267527d1380103848-help-with-lookup-formulae-please-expert
Sheet: Riders List

No. | Name | Last Name | Club | Class
1 | [NAME] | Bloggs | witley | Champ
2 | A | Bloggs | Normandy | Champ
3 | B | Bloggs | carshalton | Expert
4 | c | Bloggs | croydon | Expert
5 | d | Bloggs | LFB | Expert
6 | e | Bloggs | [NAME] | Club A
7 | f | Bloggs | witley | Club A
8 | g | Bloggs | Normandy | Club B
9 | h | Bloggs | carshalton | Expert
10 | i | Bloggs | croydon | Champ
11 | jk | Bloggs | LFB | Expert
12 | l | Bloggs | [NAME] | Club B
13 | m | Bloggs | witley | Expert
14 | n | Bloggs | Normandy | Champ
15 | o | Bloggs | carshalton | Vet B
16 | p | Bloggs | croydon | Vet B
17 | q | Bloggs | LFB | Vet A
18 | r | Bloggs | [NAME] | Vet A 50
19 | s | Bloggs | witley | Evo
20 | t | Bloggs | Normandy | Sportsman
21 | u | Bloggs | carshalton | Expert
22 | v | Bloggs | croydon | Expert
23 | w | Bloggs | LFB | Champ
24 | x | Bloggs | [NAME] | Expert
25 | y | Bloggs | witley | Champ
26 | z | Bloggs | Normandy | Sportsman
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 41223d1239725799-transferring-data-sets-between-worksheets-budgetsummary
Sheet: Lists

Wages
Interest/dividends
Miscellaneous
Income totals
Mortgage/rent
Utilities
Home telephone
Cellular telephone
Home repairs
Home improvement
Home security
Garden supplies
Home totals
Groceries
Child care
Dry cleaning
Dining out
Housecleaning service
Dog walker
Daily living totals
Gas/fuel
Insurance
Repairs
Car wash/detailing services
Parking
Public transportation
Transportation totals
Cable TV
Video/DVD rentals
Movies/plays
Concerts/clubs
Entertainment totals
Health club dues
Insurance
Prescriptions
Over-the-counter drugs
Co-payments/out-of-pocket
Veterinarians/pet medicines
Life insurance
Health totals
Plane fare
Accommodations
Food
Souvenirs
Pet boarding
Rental car
Vacations totals
Gym fees
Sports equipment
Team dues
Toys/child gear
Recreation totals
Magazines
Newspapers
Internet connection
Public radio
Public television
Religious organizations
Charity
Dues/subscription totals
Clothing
Gifts
Salon/barber
Books
Music (CDs, etc.)
Personal totals
Long-term savings
Retirement (401k, Roth IRA)
Credit card payments
Income tax (additional)
Other obligations
Financial obligation totals
Other 1
Other 2
Other 3
Other 4
Other 5
[NAME]. payments totals
Total expenses
Cash short/extra
Spreadsheet: 199356d1355191577-help-a-teacher-day-how-to-pull-data-from-a-sheet-to-enter-in-a-calendar-template-grading-attendance-behavior-chart
Sheet: Tuesday

Date: Tuesday |  | 2012-12-11 00:00:00 |  | Daily Student Tracking Report
Student | On Time |  | On Task |  | Response |  | Talking |  | Disruption |  | Gum/food |  | Homework |  | Classwork |  | Absent |  | Tardy |  | Total (day)
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Student 7
Student 8
Student 9
Student 10
Student 11
Student 12
Student 13
Student 14
Student 15
Student 16
Student 17
Student 18
Notes for Principal / Parent   |        Nòt pou Direktè / Paran              |        Notas para el Director / Padres  √
Name | Time | Reason      |      Rezon ki fè      |      Razón
Spreadsheet: 696577d1600891317-repeat-data-based-on-start-and-end-date-example-1
Sheet: Sheet1

Contract | Start | End | Value | How often charged
A | 2019-01-02 00:00:00 | 2020-01-08 00:00:00 | 100000 | Quarterly | 3
B | 2017-02-06 00:00:00 | 2022-05-07 00:00:00 | 250000 | Quarterly
C | 2017-08-04 00:00:00 | 2021-06-08 00:00:00 | 150000 | Monthly
D | 2016-06-09 00:00:00 | 2022-01-02 00:00:00 | 25000000 | Quarterly
E | 2018-07-02 00:00:00 | 2022-06-01 00:00:00 | 5600000 | Monthly
F | 2016-09-03 00:00:00 | 2020-04-02 00:00:00 | 1200000 | Quarterly
 | 2016-01-01 00:00:00
A
B
C
D
E
F
Total
Spreadsheet: 236870d1369047059-sequence-conundrum-sequence_problem
Sheet: Sheet1

GL Code | TB Group
141001 | Cash | 1 | 0 | 1 | [NAME]
141001 | Cash | DUPE | 1 | 1 | Cash0
141002 | Cash | 3 | 1 | 1 | Cash2
148001 | Equalisation | 1 | 0 | 1 | Equalisation1
148002 | Equalisation | 2 | 0 | 1 | Equalisation2
148001 | Equalisation | DUPE | 1 | 1 | Equalisation0
141004 | Cash | 4 | 1 | 1 | Cash3
141007 | Cash | 5 | 1 | 1 | Cash4
Spreadsheet: 270728d1381611159-index-match-one-step-away-multi-branch-dead-stock-look-up
Sheet: MASTER

 |  |  | Home Branch | BIR | Product Group | 01 01LCD | 180 |  |  | Number of Items
 |  |  | Item # |  | Item Description | Available | Avg Monthly Usage | Days On Hand | dfw | DFW | BIR | DEN | HOU | HRL | KSC | LIT | MON | NSH | OKC | RIC | SAT | SPF | STA
 |  |  |  | I want to add a criteria to the formula in D4. I want it to only show the items that are > or = to the number I manually enter in
 |  |  |  | cell H2.
Spreadsheet: 0c3e5d6e-0832-48bf-a4a3-0cad795430fb
Sheet: Sheet1

Unnamed: 0 | REKAPITULASI MONEV MONO TAHUN (IbM) TAHUN 2010 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
KELOMPOK MONEV ANGKA BARU | KELOMPOK | KOTA PT | KODE PT 2010 | PERGURUAN TINGGI | IbM | PAKAR | PENDAMPING | WAKTU
3 | III | [NAME] | 104-001 | Akademi Pembangunan Pertanian [NAME] | 1 | VS. Tripriyo | Desmelita | 18 s.d 20 Okt
 |  | Padang | 001-006 | Universitas [NAME] | 14 | Hp. [PHONE] | Hp. [PHONE]
 |  |  |  | Universitas Bung Hatta Padang | 1
 |  |  |  | Universitas Muhammadiyah [NAME] | 1
 |  |  |  | Universitas Ekasakti Padang | 2
 |  |  |  | Universitas [NAME] | 4
 |  | Padang |  | Universitas Andalas | 9 | Haryadi | Desmelita | 19 s.d 21 Okt
 |  |  | 001-032 | [NAME] | 8 | Hp.[PHONE] | Hp. [PHONE]
 |  | Payakumbuh | 005-025 | [NAME] | 11
 | III Total |  |  |  | 51
 | - Pertemuan untuk kelompok Pakar VS. Tripriyo tanggal 18 Okt Jam 09:00 di UNP Semua PTS
 | - Pertemuan untuk kelompok [NAME] tanggal 19 Okt Jam 109:00 di UNAND
Spreadsheet: 51034d1250615735-formatting-based-on-same-name-insert-2-rows
Sheet: Sheet1

 | name | numbered name
 | martin 1 | 1 |  | this is done now sort sheet by column c (header numbered name) ascending
 | martin 1 | 1
 | martin 1 | 1
 | martin 1 | 1
 | martin 1 | 1
 | fred | 2
 | fred | 2
 | fred | 2
 | fred | 2
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | pete | 4
 | pete | 4
 | pete | 4
 | pete | 4
 | arthyr | 5
 | arthyr | 5
 | arthyr | 5
 | arthyr | 5
 | arthyr | 5
 | [NAME] | 6
 | [NAME] | 6
 | [NAME] | 6
 | [NAME] | 6
 | dominic | 7
 | dominic | 7
 | dominic | 7
 | dominic | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
Spreadsheet: 164638d1340824175-compiling-data-from-selected-fields-in-multiple-files-into-one-master-file-master-template
Sheet: Sheet1

Invoice No. | Customer Name | Post-Code | Address Line 1 | Address Line 2 | Address Line 3 | Order Date | Ebay No. | [NAME] | [NAME]: | e-Mail: | Product Details | Colour | Payment Status | Notes | End of Delivery Window
123512 | [NAME] | XX0 0AA | Flat 0 | 00 abc xyz | Anonytown | 2012-04-19 00:00:00 | 1234 |  | 07912 345678 | [EMAIL] | Corner Sofa Right | Black | Cash on Delivery | Not in stock. Stock arrives 14/06 Delivery required 26/06
123513 | [NAME] | XX1 1AA | Flat 1 | 00 abc xyz | Anonytown | 2012-04-20 00:00:00 | 4321 |  | 07765 432100 | [EMAIL] | Corner Sofa Left | [NAME] | Paid | In Stock
Spreadsheet: 110818d1307413793-search-and-match-database
Sheet: Database 2

PJM_ORG | PJM | PROJECT_ID | PROJECT_NAME | ASSET_ID | ASSIGNEE | [NAME] | SERIAL_NUM | QUANTITY | UNIT_PRICE | AMOUNT | PO_NUM
info | AMOS | d123 | abc | abc-00-123456 | [NAME] how | CISCO Router_x000D_ | FHK0917F1J8 | 1 | 6888 | 6888 | CN05002770
info | boon | d345 | abc | abc-00-123457 | how tan | HP Compaq PC_x000D_ | [NAME] | 1 | 2700 | 2700 | CN05002770
model | hwa | d456 | abc | abc-00-123458 | pin boon | Purchase of ST-LC multi-media cable for fibre connection between level 21 server room to 18 floor server room | NA | 1 | 60 | 60
model | [NAME] | e678 | abc | abc-00-123459 | hwa pin | MP-WD Passport Elite 25oGB  portable harddisk | WXE308EC0719 | 1 | 196.26 | 196.26
Spreadsheet: c2150081-5bf4-4a94-b70e-529bf8ff8e8d
Sheet: Sheet1

Tukuma kauss 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
F-1-H jun |  |  |  | Tūres |  |  |  |  |  |  |  | Rezultāts | Vieta
Nr. | Vārds | uzvārds | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
1 | Dāvis | Skribāns | [NAME] | 72 | 90 | 90 | 90 | 90 |  |  |  | 432 | 2
2 | Mārcis | Bautra | [NAME] | 82 | 90 | 90 | 89 | 90 |  |  |  | 441 | 1
3 | Edgars | Vaivala | [NAME] | 90 | 81 | 76 | 90 | 24 |  |  |  | 361 | 4
4 | Arnolds | Bērzājs | [NAME] | 90 | 90 | 90 | 63 | 90 |  |  |  | 423 | 3
5
6 | LR juniori
7 | Dāvis | Skribāns | Tukuma MS 1 | 72 | 0 | 90 | 90 | 90 | 120 |  |  | 462 | 2
8 | Raivis | Āķītis | Tukuma MS 1 | 55 | 0 | 90 | 90 | 90 | 97 |  |  | 422 | 3
9 | Edgars | Vaivala | Tukuma MS 2 | 90 | 0 | 76 | 90 | 24 | 109 |  |  | 389 | 4
10 | Mārcis | Bautra | Tukuma MS 2 | 82 | 0 | 90 | 89 | 90 | 113 |  |  | 464 | 1
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Spreadsheet: 749340d1632743459-sumifs-that-skip-columns-zeszyt3
Sheet: 06PAZK

1 | 1 | 11 | 2 | 2 | 22 | 3 | 3 | 33 | 4 | 4 | 44
4 | 4 | 14 | 1 | 1 | 21 | 2 | 2 | 32 | 3 | 3 | 43
3 | 3 | 13 | 4 | 4 | 24 | 1 | 1 | 31 | 2 | 2 | 42
2 | 2 | 12 | 3 | 3 | 23 | 4 | 4 | 34 | 1 | 1 | 41
Spreadsheet: 82885d1282891179-search-button-using-macro-rammohan
Sheet: Mr.Naresh Reddy

←← |  | NARESH REDDY
NATURE OF WORK |  | 7.1 Home Theatre System WITH TV( NO PRJTR)
APP VALUE
SALES INCHARGE
CLIENTS REPRESENTATE |  | 9849991412
ARCHITECT
PO DETAILS
SERVICE COORDINATES
SITE CONDITION
DELIVERY SCHEDULE
STATUS ON DAY TO DAY BASIS |  | Cabling for 7.1 HT completed. Payment received for cables
ROUGH ESTIMATE OF THE MATERIAL
DAC Spk-14 spkr cable |  | 20 mts
DAC Spk-16 spkr cable |  | 70 mts
DAC Subwoofer cable ARSW11C |  | 15 mts
←←
Spreadsheet: kate_symes__18161__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 | 2001-02-04 00:00:00 |  | 200 | 0 | 185 | 0 | 181.95 | 1513 | 175.11 | 1100 |  | 196.25 | 10704
 | 2001-02-03 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 185 | 35 | 199.94 | 233
 | 2001-02-02 00:00:00 |  | 222.8 | 15824 | 195.9 | 7648 | 203.95 | 380 | 200 | 48
 | 2001-02-01 00:00:00 |  | 355.71 | 7984 | 306.05 | 3728 | 255.73 | 1202 | 198.09 | 315
 | 2001-01-31 00:00:00 |  | 409.15 | 12656 | 342.56 | 3280 | 313.68 | 3766 | 275 | 70
 | 2001-01-30 00:00:00 |  | 468.99 | 11456 | 403.48 | 2872 | 383.47 | 304 | 351 | 25
 | 2001-01-29 00:00:00 |  | 420.48 | 19824 | 407.62 | 3832 | 383.33 | 4070 | 304.86 | 1442
 | 2001-01-28 00:00:00 |  | 450 | 800 | 350 | 0 | 488.38 | 355 | 460.46 | 416 |  | 408.68 | 12240
 | 2001-01-27 00:00:00 |  | 294.85 | 19024 | 254.41 | 4032 | 456.54 | 845 | 457.01 | 236
 | 2001-01-26 00:00:00 |  | 295.64 | 17424 | 254.65 | 3832 | 369.4 | 402 | 350 | 75
 | 2001-01-25 00:00:00 |  | 319.38 | 15024 | 295.88 | 1272 | 296.66 | 437 | 234.61 | 965
 | 2001-01-24 00:00:00 |  | 307.59 | 18224 | 261.91 | 2872 | 290.03 | 291 | 291.18 | 807
 | 2001-01-23 00:00:00 |  | 329.11 | 18624 | 254.24 | 4712 | 309.54 | 1107 | 305 | 200
 | 2001-01-22 00:00:00 |  | 393.64 | 26784 | 333.06 | 3312 | 351.61 | 465 | 314.65 | 1500
 | 2001-01-21 00:00:00 |  | 300 | 800 | 337.5 | 0 | 367 | 625 | 318.16 | 435 |  | 335.88 | 8736
 |  |  |  |  |  | ..
Spreadsheet: darron_c_giron__8011__EMW 0921
Sheet: TP-EMWNSS

 | TP-EMWNSS - FINANCIAL
 | Financial Values
 | Price Positions
 | New Price Positions
 | Basis Positions
 | Index Positions
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
 | [NAME] in the previous month
 | Price Positions |  | -579181
 | Basis Positions |  | 0
 | Index Positions |  | 0
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
31
 | Price Positions |  | 0
 | Basis Positions |  | 0
 | Index Positions |  | 0
 | Gas Daily Swaps |  | 0
 | Price Option |  | 0
 | Basis Option |  | 0
 | Gas Daily Option |  | 0
33
 | Price Positions
 | Basis Positions
 | Index Positions
 | Gas Daily Swaps
 | Price Option
 | Basis Option
 | Gas Daily Option
30
Spreadsheet: d98e390f-2246-4a77-abf0-4e8f395c5637
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
FZRBC | Test | FZRBC | Zinc, Red Blood Cell | Zinc, Red Blood Cell | Inductively Coupled Plasma/Mass Spectrometry (ICP-MS) |  |  |  |  |  | Collect whole blood from a metal free EDTA (royal blue top) tube. Spin down and separate plasma and red blood cells immediately. Ship 2 mL plasma and 2 mL RBC in metal free tubes, refrigerate.   Note: Both plasma and RBCs are required for testing. | 0.1 mL | Specimens other than	Red blood cells (RBCs) and plasma Anticoagulants other than	Royal blue-top metal free EDTA  Hemolysis	Mild reject; Gross reject Thawing	NA Lipemia	NA Icteric	NA | Zinc, [NAME]: 70-120 ug/dL Zinc, RBC: 1,000-1,600 ug/dL   Test Performed by: Medtox Laboratories, Inc.                                       402 W. County Road D                                       St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 84630 |  |  |  |  | Medtox Laboratories, Inc
FZRBC | Component | FZ013 | Zinc, Plasma | Zinc, Plasma | Only orderable as part of a profile. For further information see #91949 "Zinc, Red Blood Cell" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | No
FZ013 | [NAME] | MET FREE | Metal Free EDTA Plasma |  |  |  | Refrigerated | 5 days
FZ013 | Result | Z1741 | Zinc, Plasma | Zinc, Plasma | Numeric |  |  |  |  | ug/dL |  |  |  |  |  |  |  |  |  | In Process
FZRBC | Component | [NAME] | Zinc, RBC | Zinc, RBC | Only orderable as part of a profile. For further information see #91949 "Zinc, Red Blood Cell" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | No
[NAME] | [NAME] | RBCS | RBCS |  |  |  | Refrigerated | 5 days
[NAME] | Result | Z1742 | Zinc, RBC | Zinc, RBC | Numeric |  |  |  |  | ug/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: andy_zipper__639__Broker & Exchange Detail 11-21-01 EM
Sheet: EXCHANGE DEAL SUMMARY

EnronOnline Exchange Detail for 11/21/2001
Completed Transactions:
TODAY
Date | 2001-11-21 00:00:00
Count
Exchange Party | Counterparty Name | Commodity | Total
Grand Total
No Activity
LTD
Date | (All)
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 91
 |  | US West Power | 25
 | Tucson Electric Power Company | US West Power | 2
 | Cinergy Marketing & Trading, LLC | Natural Gas | 2
 | Conectiv Energy Supply, Inc. | US East Power | 11
 |  | Natural Gas | 1
 | Tractebel Energy Marketing, Inc. | US East Power | 1
 |  | Natural Gas | 15
 | CMS Marketing, Services and Trading Company | US East Power | 1
 |  | Natural Gas | 3
 | Calpine Energy Services, L.P. | US East Power | 4
 |  | US West Power | 2
 |  | Natural Gas | 9
 | CLECO Marketing and Trading, LLC | Natural Gas | 1
 | PG&E Energy Trading-Gas Corporation | Natural Gas | 131
 | Axia Energy, LP | Natural Gas | 3
 | Entergy-Koch Trading, LP | Natural Gas | 10
 | Conoco Inc. | Natural Gas | 13
 | Richardson Energy Marketing, Ltd. | Natural Gas | 1
True Quote LLC Total |  |  | 326
Grand Total |  |  | 326
Spreadsheet: 889649d1740552224-formula-to-spill-data-from-a-table-based-on-multiple-condtions-ck458-table-data-extraction-spill-365-aligw
Sheet: Output

 |  |  |  |  |  |  |  |  | Enter Start Date |  | 2025-01-10 00:00:00
 |  |  |  |  |  |  |  |  | Enter End Date |  | 2025-01-26 00:00:00
Displays work that is ready waiting for delviery (> 2 days) |  |  |  |  |  |  |  |  |  |  |  | Displays work that has taken longer than 2 days to deliver (using date range in L2 & L3)
# | Date | Type | Tm# | Inv# | Pw | Name | Co | Status |  |  |  | # | Date | Type | Tm# | Inv# | Pw | Name | Co | Status | date2 | Com | Name (c) | Name (d) | PW2 | Status (d)
10 | 2025-01-22 00:00:00 | C | 24424 | 55485 | y | [NAME] | TMX | Ready |  |  |  | 6 | 2025-01-10 00:00:00 | C | 44548 | 55485 | y | [NAME] | TMX | Ready | 2025-01-13 00:00:00 | JAM | [NAME] | [NAME] | y | Delivered
12 | 2025-01-24 00:00:00 | B | 44548 | 55485 | y | [NAME] | MBC | Ready |  |  |  | 9 | 2025-01-14 00:00:00 | A | 44225 | 55485 | y | [NAME] | TMX | Ready | 2025-01-25 00:00:00 | JAM | [NAME] | [NAME] | y | Delivered
13 | 2025-01-25 00:00:00 | C | 44548 | 55485 | y | [NAME] | MBC | Ready
14 | 2025-01-26 00:00:00 | A | 44548 | 55485 | y | [NAME] | MBC | Ready |  |  |  |  | 2025-01-10 00:00:00 | C | 44548 | 55485 | y | [NAME] | TMX | Ready | 2025-01-13 00:00:00 | JAM | [NAME] | [NAME] | y | Delivered
15 | 2025-01-27 00:00:00 | A | 22585 | 55485 | y | Janice | MBC | Ready |  |  |  | 9 | 2025-01-14 00:00:00 | A | 44225 | 55485 | y | [NAME] | TMX | Ready | 2025-01-25 00:00:00 | JAM | [NAME] | [NAME] | y | Delivered
Spreadsheet: 164806d1340897226-vlookup-with-partial-match-problem
Sheet: Sheet2

 | Serial nr. |  |  | Other list
 | X129V45A679 |  |  | X134S12G203
 | X129V45A678 |  |  | X129V45A678
 | X234G12B123 |  |  | X130V44B055
 | X130V44B055 |  |  | X129V45A688
 | X129V45A680 |  |  | S123B12V230
 | Q492V45D780 |  |  | X234A32D230
 | X234G12B126 |  |  | X130V44B058
 | X835G22B126 |  |  | X130V44B059
 | X33V45A6816 |  |  | [NAME]
 | X234G12B125 |  |  | X129V45A666
 |  |  |  | D123D12F230
 |  |  |  | X129V45A222