tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 203580d1357169429-how-do-i-convert-imported-date-time-data-to-date-time-format-raw-data
Sheet: RawData

Time | Raw_Data
01/12/2012 00:00 | 167.708333
01/12/2012 00:01 | 154.828333
01/12/2012 00:02 | 178.173333
01/12/2012 00:03 | 176.831667
01/12/2012 00:04 | 198.298333
01/12/2012 00:05 | 201.25
01/12/2012 00:06 | 200.445
01/12/2012 00:07 | 174.685
01/12/2012 00:08 | 157.511667
01/12/2012 00:09 | 147.046667
01/12/2012 00:10 | 138.728333
01/12/2012 00:11 | 142.485
01/12/2012 00:12 | 181.393333
01/12/2012 00:13 | 169.586667
01/12/2012 00:14 | 188.101667
01/12/2012 00:15 | 192.395
01/12/2012 00:16 | 192.126667
01/12/2012 00:17 | 182.198333
01/12/2012 00:18 | 176.831667
01/12/2012 00:19 | 173.88
01/12/2012 00:20 | 178.978333
01/12/2012 00:21 | 171.465
01/12/2012 00:22 | 164.756667
01/12/2012 00:23 | 190.516667
01/12/2012 00:24 | 175.221667
01/12/2012 00:25 | 173.88
01/12/2012 00:26 | 176.831667
01/12/2012 00:27 | 179.783333
01/12/2012 00:28 | 205.006667
01/12/2012 00:29 | 218.691667
01/12/2012 00:30 | 220.301667
01/12/2012 00:31 | 188.101667
01/12/2012 00:32 | 176.026667
01/12/2012 00:33 | 161.805
01/12/2012 00:34 | 163.146667
01/12/2012 00:35 | 182.466667
01/12/2012 00:36 | 181.393333
01/12/2012 00:37 | 177.636667
01/12/2012 00:38 | 151.608333
01/12/2012 00:39 | 178.978333
01/12/2012 00:40 | 163.415
01/12/2012 00:41 | 143.29
01/12/2012 00:42 | 146.51
01/12/2012 00:43 | 158.048333
01/12/2012 00:44 | 165.293333
01/12/2012 00:45 | 158.048333
01/12/2012 00:46 | 125.043333
01/12/2012 00:47 | 162.341667
01/12/2012 00:48 | 171.733333
01/12/2012 00:49 | 156.17
01/12/2012 00:50 | 147.583333
01/12/2012 00:51 | 151.876667
01/12/2012 00:52 | 130.41
01/12/2012 00:53 | 179.515
01/12/2012 00:54 | 185.955
01/12/2012 00:55 | 173.611667
01/12/2012 00:56 | 156.706667
01/12/2012 00:57 | 141.411667
01/12/2012 00:58 | 134.971667
01/12/2012 00:59 | 122.36
01/12/2012 01:00 | 134.971667
Spreadsheet: kate_symes__18469__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-01-17 00:00:00 |  | 272.66 | 29824 | 248.16 | 6312
 | 2001-01-16 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 422.32 | 6337 | 190 | 50
 | 2001-01-15 00:00:00 |  | 179.29 | 23760 | 158.21 | 3800 | 205.96 | 83 | 210 | 22
 | 2001-01-14 00:00:00 |  | 158.5 | 0 | 152.5 | 0 | 175.38 | 920 | 157.2 | 820 |  | 152.44 | 15000
 | 2001-01-13 00:00:00 |  | 158.65 | 17648 | 151.85 | 6600 | 180.04 | 1330 | 158.51 | 865
 | 2001-01-12 00:00:00 |  | 171.71 | 16368 | 147.69 | 5432 | 181.08 | 185 | 149.35 | 575
 | 2001-01-11 00:00:00 |  | 171.43 | 15360 | 147.59 | 5936 | 157.64 | 254 | 119.48 | 1146
 | 2001-01-10 00:00:00 |  | 157.57 | 15328 | 144.37 | 5680 | 149.25 | 499 | 120.6 | 712
 | 2001-01-09 00:00:00 |  | 152.13 | 22160 | 145.73 | 6400 | 148.76 | 1729 | 123.36 | 640
 | 2001-01-08 00:00:00 |  | 147.54 | 22800 | 130.49 | 6480 | 115.32 | 470 | 102.22 | 1125
 | 2001-01-07 00:00:00 |  | 140 | 0 | 130 | 0 | 119.61 | 888 | 82.66 | 800 |  | 130.49 | 19440
 | 2001-01-06 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 103.18 | 1305 | 98.34 | 1325
 | 2001-01-05 00:00:00 |  | 146.05 | 22800 | 135.85 | 3616 | 134.44 | 1345 | 120.8 | 1155
 | 2001-01-04 00:00:00 |  | 152.95 | 20280 | 139.1 | 5544 | 143.03 | 190 | 127.53 | 415
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800 | 156.14 | 485 | 127.71 | 648
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 |  |  |  |  |  | ..
Spreadsheet: 37fba628-cfff-40a7-a854-abcab3848a5c
Sheet: Sheet1

id | Name | Abbreviation
AIR | Airservices Australia | Airservices
VICAMB | Ambulance Victoria | Ambulance
AG | Attorney-General's Department | AG
AEMO | Australian Energy Market Operator | AEMO
AMSA | Australian Maritime Safety Authority | Maritime
[NAME] | Australian Pacific Airports (Melbourne) Pty Ltd (Melbourne Airport) | Melb. Airport
REDCROSS | Australian Red Cross | Red Cross
ATSB | Australian Transport Safety Bureau | ATSB
VICCOAST | Australian Volunteer Coast Guard Association Inc. [NAME] | Coast Guard
BUILDCOM | Building Commission | Building Comm.
BOM | Bureau of Meteorology | BOM
CMA | Catchment Management Authorities | Catchment
CTRLNK | Centrelink | Centrelink
CCV | Coroners Court of Victoria | Coroner
VICCFA | Country Fire Authority | CFA
VICDEF | Defence Victoria | Defence
DBI | Department of Business and Innovation | Dept Bus
DEECD | Department of Education and Early Childhood Development | DEECD
DH | Department of Health | DH
DHS | Department of Human Services | DHS
DPC | Department of Premier and Cabinet | DPC
DPI | Department of Primary Industries | DPI
DSE | Department of Sustainability and Environment | DSE
DT | Department of Transport | DOT
DTF | Department of Treasury and Finance | Treasury
EB | Emergency Broadcasters | Broadcasters
ESTA | Emergency Services Telecommunications Authority | ESTA
ESV | Energy Safe Victoria | ESV
EPA | Environment Protection Authority | EPA
ICA | Insurance Council of Australia Ltd | Insurance Council
LSV | Life Saving Victoria | Life Saving
MWC | Melbourne Water Corporation | Melb. Water
MFB | Metropolitan Fire Brigade | MFB
COUNCIL | Council | Council
NOPSA | National Offshore Petroleum Safety Authority | Petro Safety
[NAME] | Office of the Emergency Services Commissioner | [NAME]
OFSC | Office of the Fire Services Commissioner | OFSC
PV | [NAME] Victoria | [NAME]
PMC | Port of Melbourne Corporation | Port of Melb
RFCV | Rural Finance Corporation of Victoria | Rural Finance
SALVO | Salvation Army - Victorian Emergency Services | Salvo
STJOHN | [NAME] Australia ([NAME].) | St John
TELSTRA | Telstra Corporation Limited | Telstra
TRANSFLD | Transfield Services Australia Pty Ltd (EastLink) | Transfield
TRANSLNK | TransLink Operations Pty Ltd (CityLink) | Translink
TSV | Transport Safety Victoria | Transport Safety
VICRELIEF | VicRelief Foodbank Ltd | Foodbank
VICROADS | VicRoads | VicRoads
VICPOL | [NAME] | Police
VICSES | Victoria State Emergency Service | Vic SES
VICCHRCH | Victorian Council of Churches | Churches
VICRCA | Victorian Regional Channels Authority | VRCA
VICTRACK | VicTrack Access | VicTrack
VESRO | [NAME] and Rescue Organisations | Search & Rescue
WATER | Water Authorities | Water Auth
WICEN | Wireless Institute Civil Emergency Network (WICEN) | WICEN
WORKSAFE | [NAME] (Victorian WorkCover Authority) | Worksafe
Spreadsheet: 456305d1460737748-to-use-a-table-upon-a-variable-icecream
Sheet: Sheet1

CABINETS | MODEL | Colour | Price
 |  | White
BASE | B09
WALL | W12
BASE SINK | SB33
BASE SINK | SB30
LAZY SUSAN | LAZY1
Spreadsheet: 138130d1327521372-creating-multiple-rows-of-data-from-a-single-row-source-example
Sheet: Order Detail

Order Number: | 000002
Carton # | Quantity | Item # | Description | Notes
1 |  |  |  | Ship 1/25/2012
2 | 1 | 6
3, 4 | 2 | 7
5 | 1 | 8
6 | 1 | 9
Spreadsheet: 285554d1387719922-time-calculationan-time-chart
Sheet: Profit Loss

 |  |  |  |  |  |  |  |  |  |  |  |  |  | FAB HRS |  |  |  |  |  |  |  |  |  |  |  |  | INST HRS
DATE | INVOICE # | CUSTOMER | TOTAL COST | TOTAL RETAIL B4 TAX | GROSS PROFIT | PROFIT % | SLAB | SQ' SOLD | SQ' USED | COST/SQ' | STONE COST | WASTE | SHOWER COST | RICH | SHAWN (I) | SHAWN | BILL(I) | BRAD | KEVIN | CHUCK | TREVOR | MISC | [NAME] | LEE(I) | FAB COST | total hrs | RICH | SHAWN (I) | SHAWN | BILL(I) | BRAD | KEVIN | CHUCK | TREVOR | MISC | [NAME] | LEE(I) | INST COST | SERVICE HRS | SERVICE PARTS | SERVICE COST | SINK COST | FAUCET | FAUCET COST | PLUMBING | PLUMBING COST | TEAROUT | DEL COST | DUPONT | DUPONT COST | GIFT CARD | $ ON CREDIT CARD | CREDIT CARD COST | COMMISH CABINET SHOP
11/18/2013 | 1190/1181/1234 | BURDETT |  | 7358 |  |  | KASHMIRE GOLD | 94.07 | 123.78 | 9.41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  |  |  |  | 913 |  | 0 | 0 | 175 | 0 | 349 | 139 | 171.49 | 3000 |  | 0
 | 100
 | 126
Spreadsheet: 139261d1328160517-vlookup-issue-vlookup
Sheet: vlookup

1or2 | CompanyID | ValidatedCompanyName | CompanyID | CompanyName
2 | 2228 | 0 | 2229 | ABC
2 | 2229 | ABC | 2230 | ABCD
1 | 2230 | ABCD | 2231 | ABCDE
1 | 2231 | ABCDE | 2233 | ABCDEF
1 | 2232 | 0 | 2239 | ABCDEFG
1 | 2233 | ABCDEF | 2240 | ABCDEFGH
Spreadsheet: chris_germany__2917__01 2000 GELP OIL BY VENDOR
Sheet: Monthly Summary

 | 2000-01-01 00:00:00 | SUMMARY OF FUEL OIL DELIVERIES TO GORDONSVILLE
 | COMMENTS | Plant Recorded Off-Load Meter Reading |  | BP AMOCO "GROSS" DELIVERED | MARATHON ASHLAND "GROSS" DELIVERED | CITGO    "GROSS" DELIVERED
 | Current Month Ordered |  |  | 165000 | 120000
 | Current Month Delivery
 | ESTIMATED Gallons still unaccounted for… |  | 0
 | MONTH BEGINNING TANK INVENTORY | 0 | (AS STRAPPED BY PLANT… 12/14)
 | MONTH BEGINNING TANK INVENTORY | 0 | (AS REPORTED BY PLANT CONTROL ROOM)
 | PLANT RECORDED OFFLOAD TOTAL
 | ALL SUPPLIERS "GROSS" DELIVERY RECORD
 | TOTAL DIFFERENCE, Current month
Note: | BPAmoco didn't get any product into Plant prior to month end and |  | ESTIMATED COST SUMMARY (based on BOL, not invoice)
 | Citgo got order CIT-003 (the first 150,000 gallons) in and looks to have |  |  | "Gross" Gallons Delivered
 | [NAME]. 120,000 gallons of CIT-004 in prior to end of month. |  |  | [NAME]. Cost per gallon | 0
 |  |  |  | Estimated Cost of Oil for Month
Spreadsheet: 709593d1608427649-compare-to-cells-bouwcenter-poule-f1-2021-v1
Sheet: Stand

Stand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Toaal | Ranking
# | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  |  |  |  |  | Punten
1 | Player 1
2 | Player 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pole Position | 50
3 | Player 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Snelste ronden | 18
4 | Player 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eeste uitvaller | 10
5 | Player 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Snelste Pitstop | 10
6 | Player 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Best of the rest | 25
7 | Player 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 25
8 | Player 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 18
9 | Player 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 15
10 | Player 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wereldkampioen | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contstructers | 100
Spreadsheet: 599875d1543343598-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: Team 6

Date | [NAME] |  |  |  | PI
 | Sickcall and Med Documentation |  |  |  | SFC L
 | Infection, Asepsis, & Sterile Techniques |  |  |  | SSG A
 | Medication Administration |  |  |  | SSG Am
 | Injections |  |  |  | SSG F
 | Pharmacology |  |  |  | SSG K
 | Venipuncture |  |  |  | SFC L
 | EENT Primary Care |  |  |  | SSG A
 | Respiratory Primary Care |  |  |  | SSG Am
 | Abdominal Primary Care |  |  |  | SSG F
 | Orthopedic Primary Care |  |  |  | SSG K
 | Basic Wound Primary Care |  |  |  | SFC L
 | Skin Disease Primary Care |  |  |  | SSG A
 | Primary Care Pre-Examination Review
 | Primary Care Exam
 | Intro to Battlefield Medicine |  |  |  | SFC L
 | Battlefield Communication/ Documentation |  |  |  | SSG A
 | Casualty Movement |  |  |  | SSG Am
 | Combat Medical Aid Bag |  |  |  | SSG F
 | Combat Casualty Assessment |  |  |  | SSG K
 | Control Bleeding |  |  |  | SFC L
 | Airway Management |  |  |  | SSG A
 | [NAME] Trauma |  |  |  | SSG Am
 | Shock |  |  |  | SSG F
 | Vascular Access |  |  |  | SFC L
 | Fieldcraft 1 Pre-Examination Review
 | Field Craft Exam
 | Head Injuries with Traumatic Brain Injuries |  |  |  | SFC L
 | Ocular Injuries |  |  |  | SSG A
 | Burns |  |  |  | SSG Am
 | [NAME] |  |  |  | SSG F
 | Musculoskeletal Trauma |  |  |  | SSG K
 | [NAME]
 | Field Craft 2 Exam
 | [NAME] Training |  |  |  | SFC L
 | Casualty Triage |  |  |  | SSG A
 | Suicide Prevention |  |  |  | SSG Am
 | [NAME] and Geneva Conv. |  |  |  | SSG F
 | Environmental Threat |  |  |  | SSG K
 | Fieldcraft 3 Pre-Examination Review
 | Field Craft Exam
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
Spreadsheet: 773171d1647663652-calculate-value-between-dates-book1
Sheet: Sheet1

 |  |  |  |  |  |  | Today: | 2022-03-19 00:00:00 |  | <-- I enter the date
 |  |  |  | AVAIL | OCCUPIED |  | Rooms Left to Sell |  | Returns should be:
 |  | Dow | Day | ROOMS | ROOMS |  |  |  | total rooms avail from date entered until end of month
 |  | Tue | 2022-03-01 00:00:00 | 25 | 8 |  |  |  | minus rooms Occupied from date entered until end of month
 |  | Wed | 2022-03-02 00:00:00 | 25 | 3
 |  | Thu | 2022-03-03 00:00:00 | 25 | 13
 |  | Fri | 2022-03-04 00:00:00 | 25 | 10
 |  | Sat | 2022-03-05 00:00:00 | 25 | 14
 |  | Sun | 2022-03-06 00:00:00 | 25 | 13
 |  | Mon | 2022-03-07 00:00:00 | 25 | 23
 |  | Tue | 2022-03-08 00:00:00 | 25 | 19
 |  | Wed | 2022-03-09 00:00:00 | 25 | 21
 |  | Thu | 2022-03-10 00:00:00 | 25 | 16
 |  | Fri | 2022-03-11 00:00:00 | 25 | 25
 |  | Sat | 2022-03-12 00:00:00 | 25 | 23
 |  | Sun | 2022-03-13 00:00:00 | 25 | 20
 |  | Mon | 2022-03-14 00:00:00 | 25 | 19
 |  | Tue | 2022-03-15 00:00:00 | 25 | 17
 |  | Wed | 2022-03-16 00:00:00 | 25 | 19
 |  | Thu | 2022-03-17 00:00:00 | 25 | 17
 |  | Fri | 2022-03-18 00:00:00 | 25 | 20
 |  | Sat | 2022-03-19 00:00:00 | 25 | 21
 |  | Sun | 2022-03-20 00:00:00 | 25 | 19
 |  | Mon | 2022-03-21 00:00:00 | 25 | 19
 |  | Tue | 2022-03-22 00:00:00 | 25 | 12
 |  | Wed | 2022-03-23 00:00:00 | 25 | 17
 |  | Thu | 2022-03-24 00:00:00 | 25 | 20
 |  | Fri | 2022-03-25 00:00:00 | 25 | 21
 |  | Sat | 2022-03-26 00:00:00 | 25 | 17
 |  | Sun | 2022-03-27 00:00:00 | 25 | 9
 |  | Mon | 2022-03-28 00:00:00 | 25 | 13
 |  | Tue | 2022-03-29 00:00:00 | 25 | 9
 |  | Wed | 2022-03-30 00:00:00 | 25 | 6
 |  | Thu | 2022-03-31 00:00:00 | 25 | 13
 |  | TOTAL |  | 775 | 496
Spreadsheet: sally_beck__35035__MgmtSum-Q2-0410a
Sheet: Summary

ENRON NORTH AMERICA
2ND QUARTER 2000 EARNINGS ESTIMATE
Results based on Activity through April 7, 2000
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses* | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
GRM -  Weather
Emissions
GRM - New Products
Executive Trading
Total Trading & Risk Mgt.
East Midstream
West Midstream
Industrial Downstream - Paper
Industrial Downstream - Chemicals
Midstream IPP
Mexico
Total Origination
Genco
Generation Investments
Gas Assets
Gas Assets - Trading
Total Assets
Principal Investing
Energy Investments
Special Assets
CTG Assets
Total Investing
Commercial Transactions Group
Office of the Chairman
Total Commercial
Group |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Interest Related Charges
Capital Charge Offset
Overview |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
ENA EBIT
Interest Expense/(Income) |  |  | 8600 |  |  |  |  |  |  |  |  | 8600
[NAME]
 |  |  |  | MPR Change:
* Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 146968d1332442408-pivot-tables-grouping-data-in-multiple-columns-sample
Sheet: Sheet1

Job | Client | Cost | Team Lead | Supervisor | Team Member
Job A | Client A | 10 | Employee A | Employee B | Employee C
Job B | Client B | 20 | Employee C | Employee A | Employee B
Job C | Client C | 30 | Employee A | Employee B | Employee C
Employee A | Team Lead | Count of Team Lead | Sum of Cost
 | Job A | 1 | 10
 | Job C | 1 | 30
 | Subtotal | 2 | 40
 | Supervisor
 | Job B | 1 | 20
 | Subtotal | 1 | 20
 | Team Member
 | Subtotal | 0 | 0
Employee Total |  | 3 | 60
Employee B | Team Lead | Count of Team Lead | Sum of Cost
 | Subtotal | 0 | 0
 | Supervisor
 | Job A | 1 | 10
 | Job C | 1 | 30
 | Subtotal | 2 | 40
 | Team Member
 | Job B | 1 | 20
 | Subtotal | 1 | 20
Employee Total |  | 3 | 60
Employee C | Team Lead | Count of Team Lead | Sum of Cost
 | Job B | 1 | 20
 | Subtotal | 1 | 20
 | Supervisor
 | Subtotal | 0 | 0
 | Team Member
 | Job A | 1 | 10
 | Job C | 1 | 30
 | Subtotal | 2 | 40
Employee Total |  | 3 | 60
Spreadsheet: 538820d1505840991-pivot-table-displaying-old-data-53rd-street-cost-schedule
Sheet: Draw 6b - 07.23.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes |  | Row Labels | Line Number | Sum of Amount
Dirt Export | Rough Grading | 302 | 2017-07-12 00:00:00 | 1890 | B&M Grading | Export and transportation of dirt removal |  | Block/Retaining Walls | 345 | 4605
Dirt Export | Rough Grading | 302 | 2017-07-13 00:00:00 | 2430 | [NAME] | Export and transportation of dirt removal |  | Rough Grading | 302 | 12970
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-07-17 00:00:00 | 110 | [NAME] | OSHA caps for retaining wall steel covering |  | Grand Total | 319.2 | 17575
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-07-22 00:00:00 | 4495 | [NAME] | Retaning wall labor
Grading and Export | Rough Grading | 302 | 2017-07-22 00:00:00 | 8650 | B&M Grading | Grading and export material to [NAME]
Spreadsheet: 7394f7e0-60dc-4ea1-b558-c623a3ad65e7
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
FSESG | Test | FSESG | Sesame Seed IgG | Sesame Seed IgG | Enzyme Immunoassay (FEIA) |  |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | < 2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:  Viracor-IBT Laboratories                               1001 NW Technology Dr.                               Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FSESG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FSESG | Result | FSESG | Sesame Seed IgG | Sesame Seed IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 681227d1591411170-count-the-weeks-in-a-month-pivot-date-with-weekno-slicers
Sheet: Sheet1

Date | WeekNo | Amt
 |  |  |  | Row Labels | Sum of Amt
 |  |  |  | 2019 | 1733
 |  |  |  | Qtr3 | 1733
 |  |  |  | Jul | 614
 |  |  |  | 2 | 614
 |  |  |  | Aug | 336
 |  |  |  | 2 | 336
 |  |  |  | Sep | 783
 |  |  |  | 2 | 783