tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 670067d1585741811-excel-to-sql-script-exceltosqlscriptsampleupdated
Sheet: Sheet1

2229207 | 13824721 | 2020-03-27 00:00:00.000 | 2020-03-27 00:00:00.000 | [NAME] | [NAME] | [NAME] |  | NULL |  | 80007970 | [NAME] | 0520 | 3 | CA | 01 | 01 | H5 | 2018-02-23 00:00:00.000 | 2020-03-23 00:00:00.000 | 1000 | [PHONE] | [NAME] | 10000028 | A | NULL | 80007970 | DL | [NAME] | 17803781 | [NAME] |  |  |  |  |  | 135 | [NAME]
2148402 | 14149839 | 2020-03-27 00:00:00.000 | 2020-03-27 00:00:00.000 | Lewis | Ffion | Bailey |  | NULL |  | 80007970 | [NAME] | 0520 | 3 | CA | 01 | 01 | H5 | 2018-01-08 00:00:00.000 | 2020-03-24 00:00:00.000 | 1000 | 10000304 | [NAME] | 10000022 | A | NULL | 80007970 | DL | [NAME] | 24436695 | [NAME] |  |  |  |  |  | 135 | [NAME]
Result as of now:
[NAME]:
Expected Result :
(2229207,13824721,'2020-03-27 00:00:00.000','2020-03-27 00:00:00.000','Clark','Khadija','Peterson','',NULL,'','80007970','Peterson','0520','3','CA','01','01','H5','2018-02-23 00:00:00.000','2020-03-23 00:00:00.000','1000','[PHONE]','Peterson','10000028','A',NULL,'80007970','DL','Peterson','17803781','Peterson','','','','','','135','Peterson')
(2148402,14149839,'2020-03-27 00:00:00.000','2020-03-27 00:00:00.000','Lewis','Ffion','Bailey','',NULL,'','80007970','Peterson','0520','3','CA','01','01','H5','2018-01-08 00:00:00.000','2020-03-24 00:00:00.000','1000','10000304','Peterson','10000022','A',NULL,'80007970','DL','Peterson','24436695','Peterson','','','','','','135','Peterson')
Note: Only NULL values will not include single quote.
Note: NULL values are only found on columns I and Z
Spreadsheet: 154941d1336614560-whole-row-conditional-formatting-on-text-value-book2
Sheet: Sheet1

2nd Item Number | Description 1 | Description 2 | Sum of Short Shipped Qty | Sum of Short Shipped $ | Sum of Quantity On Hand | Sum of Quantity Available | Sum of Quantity Held | Lot Status | Comment
22267 | [NAME] ANTISEPTIC |  | 3888 | 8125.919999999999 |  |  |  |  | Production WC23.04.2012. ETA 30.04.2012, customer has been notified
21553 | [NAME] T/PASTE | 578893 | 5184 | 6220.8 |  |  |  |  | 2 weeks away
100428 | STARLET 125ML POLISH  REMOVER | VITAMIN E | 4224 | 4139.52 |  |  |  |  | Starts Today 7200 units
21268 | FOA SUN 140ML BRONZER | MOUSSE | 636 | 3542.520000000004 |  |  |  |  | Made and stock available
100427 | STARLET 125ML POLISH  REMOVER | NON ACETONE | 2544 | 2518.56 |  |  |  |  | Need Reconfirmed Date
22231 | FOA MINERAL LOOSE POWDER | NATURAL HONEY | 237 | 1971.899999999998 |  |  |  |  | OOS
21785 | FOA LIPGLOSS DIVINE SHINE | MORNING MIST | 429 | 1927.889999999998 |  |  |  |  | Back in Stock
20037 | BEAUTY ESSENTIALS 125ML | POLISH REMOVER VITAMIN E | 1872 | 1815.84 |  |  |  |  | Back in Stock
21789 | FOA LIPGLOSS DIVINE SHINE | [NAME] RUSH | 387 | 1733.129999999998
21786 | FOA LIPGLOSS DIVINE SHINE | SILK FORTUNE | 243 | 1096.229999999999
20988 | FOA LIQUID  EYELINER | CHARCOAL | 195 | 837.0600000000001
21762 | [NAME] QUENCH 30+ | PURE PLUM | 186 | 829.8899999999994 |  |  |  |  | Back in Stock
101757 | FOA LIP DEFINER | RUBY RED | 234 | 828.5099999999994 |  |  |  |  | Back in Stock
21783 | FOA LIP PLUMP | LAVISH INSTINCT | 165 | 825.33
19873 | FOA NAIL POLISH REMOVER | MOISTURISING | 432 | 648.0000000000002
100930 | FOA MECHANICAL EYELINER PENCIL | BROWN | 120 | 591.3899999999998
13303 | HOMEBRAND 200G PETROLEUM JELLY | 1995 | 216 | 324
22237 | FOA MINERAL BLUSH | BERRY PINK | 42 | 260.94
100429 | STARLET 125ML POLISH  REMOVER | OILY | 252 | 249.48
20979 | FOA TINTED MOISTURISER SPF30+ | MEDIUM | 39 | 241.02
19521 | FOA PRESSED POWDER | IVORY | 30 | 180
100429 | STARLET 125ML POLISH  REMOVER | OILY | 180 | 178.2
100930 | FOA MECHANICAL EYELINER PENCIL | BROWN | 30 | 154.77
102392 | CLASSICS LIQUID EYELINER | BLACK | 72 | 148.32
101757 | FOA LIP DEFINER | RUBY RED | 36 | 142.5
20039 | BEAUTY ESSENTIALS 125ML | POLISH REMOVER NNNON ACETONE | 144 | 139.68
22237 | FOA MINERAL BLUSH | BERRY PINK | 15 | 100.65
Spreadsheet: 53368d1253243840-selective-sums-mirmle
Sheet: Sheet1

household |  |  |  |  | work |  |  |  |  |  | TOTALS
date | item | description | price | type | date | item | description | price | type |  | gift | 23
1 | pizza | meals | 5 | gift | 2 | tims | meals | 5 | gift |  | cash | 49
2 | eggs | meals | 1 | cash | 2 | kfc | meals | 1 | cash |  | credit | 54
4 | butter | meals | 4 | credit | 4 | mcd's | meals | 4 | credit
5 | bread | meals | 3 | cash | 6 | tims | meals | 3 | cash
8 | paper | office | 6 | credit | 7 | fax | office | 6 | credit
9 | erasers | office | 2 | cash | 8 | stamps | office | 2 | cash
10 | pizza | meals | 5 | credit | 10 | pizza | meals | 5 | credit
12 | eggs | meals | 1 | credit | 11 | eggs | meals | 1 | cash
14 | butter | meals | 4 | credit | 13 | butter | meals | 4 | cash
15 | bread | meals | 3 | cash | 15 | bread | meals | 3 | cash
17 | paper | office | 6 | gift | 16 | paper | office | 6 | credit
19 | erasers | office | 2 | cash | 18 | erasers | office | 2 | credit
20 | pizza | meals | 5 | credit | 21 | pizza | meals | 5 | cash
22 | eggs | meals | 1 | cash | 23 | eggs | meals | 1 | gift
24 | butter | meals | 4 | gift | 23 | butter | meals | 4 | cash
25 | bread | meals | 3 | cash | 26 | bread | meals | 3 | cash
27 | paper | office | 6 | cash | 28 | paper | office | 6 | credit
29 | erasers | office | 2 | cash | 20 | erasers | office | 2 | gift
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 319217 | 340340 | 79105 | 72332 | 62892 | 43140 | 116592 | 115164 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 338215 | 355173 | 77785 | 72332 | 43877 | 43100 | 134967 | 128883
3 | 328407 | 344634 | 57852 | 52151 | 55140 | 49783 | 129505 | 119135 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 310428 | 315994 | 57787 | 52151 | 55035 | 49783 | 120156 | 115523 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 307705 | 336034 | 60972 | 50125 | 59642 | 43478 | 126850 | 130855 |  |  |  | 2001-02-01 00:00:00 | 15193330 | 15256233 |  | 5.61
6 | 324818 | 328994 | 58510 | 57480 | 45573 | 44980 | 119844 | 129531 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 365211 | 322967 | 39684 | 65000 | 44177 | 44747 | 129123 | 149108 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 336902 | 315737 | 46630 | 65000 | 45831 | 44747 | 110692 | 111045 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 315620 | 303183 | 49235 | 52200 | 49131 | 44747 | 115238 | 116476 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.45
10 | 293183 | 292259 | 54891 | 52125 | 47430 | 44644 | 91232 | 95923 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 310624 | 318715 | 48679 | 37125 | 48993 | 44747 | 80991 | 86699
12 | 317375 | 324777 | 53464 | 52125 | 49064 | 45195 | 112093 | 106677
13 | 275275 | 270008 | 54045 | 52125 | 35774 | 37232 | 110253 | 116226
14 | 271334 | 276943 | 54014 | 53977 | 50253 | 54024 | 89540 | 79743
15 | 294190 | 289200 | 54040 | 52125 | 53414 | 44748 | 125178 | 139144
16 | 296967 | 305719 | 53834 | 52124 | 43563 | 43511 | 109887 | 98603
17 | 300931 | 299343 | 51648 | 52125 | 56942 | 44748 | 122510 | 128656
18 | 301275 | 306001 | 54014 | 52124 | 43851 | 44748 | 127317 | 128824
19 | 304850 | 302554 | 52126 | 52124 | 44241 | 44660 | 134622 | 132325
20 | 302506 | 306570 | 53900 | 52125 | 32850 | 34748 | 120562 | 118757
21 | 299146 | 306488 | 54087 | 52125 | 41454 | 44748 | 121460 | 119920
22 | 291845 | 299547 | 53992 | 52125 | 42908 | 39356 | 125818 | 119675
23 | 296657 | 295047 | 48382 | 52125 | 41766 | 43478 | 110095 | 113349
24 | 289539 | 295162 | 44410 | 52125 | 44812 | 43478 | 130420 | 128936
25 | 286979 | 287302 | 52057 | 52125 | 42890 | 43478 | 120057 | 114561
26 | 308000 | 298182 | 34029 | 52125 | 41745 | 43478 | 108805 | 114175
27 | 294279 | 310878 | 44696 | 52125 | 41969 | 44530 | 134457 | 123741
28 | 308710 | 281367 | 54094 | 52125 | 42911 | 40206 | 132562 | 123191
29 | 317953 | 328732 | 61758 | 52125 | 42459 | 41269 | 135561 | 128143
30 | 307928 | 314550 | 63985 | 52125 | 27519 | 40615 | 99678 | 79752
31
2001-10-31 00:00:00 |  |  |  |  |  |  |  |  | 178125
2001-11-30 00:00:00
CBS Dollars
 |  |  | 1102698.99
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250
Spreadsheet: 156826d1337505712-find-value-and-count-how-many-times-after-every-nth-row-value-appears-test
Sheet: Sheet1

 |  |  | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
150 | 1 | 100
150 | 2 | 150
110 | 3 | 70
120 | 4 | 110
150 | 5 | 90
190 | 6 | 110
80 | 7 | 70
100 | 8 | 140
50 | 9 | 110
130 | 10 | 90
130
70
120
90
160
130
130
70
130
120
110
80
160
100
120
120
180
80
100
80
130
140
160
140
80
130
90
110
140
70
110
90
110
70
150
100
Spreadsheet: 193036d1352710116-time-sheet-with-formula-cell-to-work-out-the-hours-work-rota-template-november-2012
Sheet: NORBURY

 |  |  |  |  |  | NORBURY
District 053 |  |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY |  |  | TOTAL | ACCRUE
 |  |  |  | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Hrs | Hrs
Northwood | 37.5 | M | [NAME] |  |  | 0
10.00-22.00 | 37.5 | 2.5 | Rachel
9.45-22.00 S | 18 | 2.5 | Monique
[NAME] 65.5 | 18 | L1 | Samantha
O/C 7.75hrs | 18 | L1 | Cherly
Confirmed By | 30 | L1 | Rochelle
Norbury | 37.5 | M | [NAME]
7.45-22.00 | 37.5 | D | Oshane
8.45-22.00 S | 18 | 2.5 | [NAME]
[NAME] 80.5 | 20 | 2.5 | [NAME]
O/C 19.75hrs | 30 | 2.5 | Leigh-Anne
Confirmed By | 30 | W3 | [NAME]
Little Norbury | 37.5 | M | Agnes
7.45-22.00 | 30 | 2.5 | Dennis
8.45-22.00 S | 30 | 2.5 | [NAME]
[NAME] 54 | 30 | W3 | Elaina
O/C 19.75 hrs | 6 | L1 | [NAME]
Confirmed By | 18 | [NAME] | Kylie
Pollards Hill | 37.5 | M | Sean
8.15-22:00 | 37.5 | D | Charlotte
9.45-22:00 S | 30 | 2.5 | [NAME]
[NAME] 75.5 | 30 | L1 | [NAME]
 | 30 | T | [NAME]
Confrimed By
Spreadsheet: darron_c_giron__7961__Ftoc0500
Sheet: Orig Sched

 |  |  |  |  |  | ENRON CAPITAL & TRADE RESOURCES CANADA CORP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^ENRON RISK MANAGEMENT SERVICES CORP.
 |  |  |  |  |  |  |  |  |  |  | Total Notional |  |  | US Dollar |  | US Dollar |  | Canadian Dollar |  | Canadian Dollar
 |  |  |  |  |  |  |  |  |  |  | Quantities (BBtu) |  |  | Origination Value |  | Enter Value of |  | Origination Value |  | Enter Value of
Deal # |  | Date |  | Customer |  | ECT Origination |  | Originator |  | (Sales) |  | Purchases |  | (In Thousands) |  | Deal Here |  | (In Thousands) |  | Deal Here
NH2645.1 |  | 2000-05-08 00:00:00 |  | UtiliCorp |  | Middle Market - Central |  | Pollan |  | 0 |  | 0 |  |  |  | 5410
TOTAL ORIGINATION
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
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
2002-02-28 00:00:00 |  |  | 171935
2002-02-28 00:00:00
CBS Volume
 |  |  | 75136
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -18474 | -500 |  | -17302
2 | -17798 | -500 |  | -17302
3 | -17797 | -500 |  | -17302
4 | -18510 | -500 |  | -17302
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
 | 2001-08-31 00:00:00 |  |  |  | 73003
 | 2001-09-04 00:00:00
CBS Dollars
 |  |  | 71591
Spreadsheet: 685386d1593956010-create-relationship-between-randomised-data-to-prevent-repetition-shifts
Sheet: Sheet1

 | WORK | RANDOM | RANK |  | DAY | PERSON 1 | PERSON 2 | PERSON 3 | PERSON 4 | PERSON 5
 | [NAME] |  |  |  | Sun
 | [NAME] |  |  |  | Mon
 | [NAME] |  |  |  | [NAME]
 | [NAME] |  |  |  | Wed
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Sun | Mon | [NAME] | Wed
 |  |  |  |  |  |  |  |  |  |  |  | PERSON 1
 |  |  |  |  |  |  |  |  |  |  |  | PERSON 2
 |  |  |  |  |  |  |  |  |  |  |  | PERSON 3
 |  |  |  |  |  |  |  |  |  |  |  | PERSON 4
 |  |  |  |  |  |  |  |  |  |  |  | PERSON 5
Spreadsheet: 2d10b221-670a-4645-aa33-857ac9460c81
Sheet: Sheet1

SENATOR | OFFICE | COS | LD
[NAME] | 448 Russell | [EMAIL] | [EMAIL]
[NAME] | 136 Hart | [EMAIL] | [EMAIL]
[NAME] | 728 Hart | [EMAIL] | [EMAIL]
[NAME] | 313 Hart | [EMAIL] | [EMAIL]
Blanche Lincoln | 355 Dirksen | [EMAIL] | [EMAIL]
[NAME] | 433 [NAME] | [EMAIL] | [EMAIL]
[NAME] | 731 Hart | [EMAIL] | [EMAIL]
[NAME] | 304 Russell | [EMAIL] | [EMAIL]
[NAME] | 239 Dirksen | [EMAIL] | [EMAIL]
[NAME] | 185 Dirksen | [EMAIL] | [EMAIL]
[NAME] | [NAME] | [EMAIL] | [EMAIL]
Saxby Chambliss | 416 Russell | [EMAIL] | [EMAIL]
Spreadsheet: 27b95658-72ae-40ac-b62b-d5d4633ef3a6
Sheet: Sheet1

 |  |  | To determine Btuh heater requirments… |  |  |  |  |  |  |  | 5 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  |  | Find Cubic Measurements of [NAME] by
 |  |  | Entering Room Measurements in Feet:
 |  |  |  | [NAME] | 20 | ft.
 |  |  |  | Width- | 40 | ft.
 |  |  |  | [NAME] | 100 | ft.
 |  |  |  | Cubic Feet of Tent/Marquee:
 |  |  | Select Desired Rise in Room Temperature: |  |  | 30 | °
 |  |  |  | Btuh Requirement for Room: |  |  | Btuh's
 |  | May We Suggest: |  | Premier 80's
 |  |  |  | Premier 170's
 |  |  |  | Premier 350's
 |  |  |  | Premiier 170 | 170000
 |  |  |  | Premier 80 | 80000
 |  |  |  | Premier 350 | 350000
Spreadsheet: 200091d1355412837-formatting-issues-budget-2nd-review-sample
Sheet: budget

 |  |  |  | ATTACHMENT 3
 |  |  |  | GRANT BUDGET
 |  |  |  | (BUDGET PAGE 1)
facility |  | Obesity
APPLICABLE PERIOD:   The grant budget line-item amounts below shall be applicable only to expense incurred during the period beginning July 1, 2012 and ending June 30, 2013.
POLICY 03 Object  Line-item Reference | EXPENSE OBJECT LINE-ITEM CATEGORY  (detail schedule(s) attached as applicable) | GRANT CONTRACT | GRANTEE PARTICIPATION | TOTAL PROJECT
1 | Salaries2 | 35800 | 0 | 35800
2 | Benefits & Taxes | 10600 | 0 | 10600
4, 15 | Professional Fee/ Grant & Award 2 | 32500 | 0 | 32500
5 | Supplies | 7000 | 0 | 7000
6 | Telephone | 300 | 0 | 300
7 | Postage & Shipping | 300 | 0 | 300
8 | Occupancy | 1400 | 0 | 1400
9 | Equipment Rental & Maintenance | 0 | 0 | 0
10 | Printing & Publications | 2700 | 0 | 2700
11, 12 | Travel/ Conferences & Meetings2 | 2400 | 0 | 2400
13 | Interest 2 | 0 | 0 | 0
14 | Insurance | 0 | 0 | 0
16 | Specific Assistance To Individuals2 | 0 | 0 | 0
17 | Depreciation 2 | 0 | 0 | 0
18 | Other Non-Personnel 2 | 0 | 0 | 0
20 | Capital Purchase 2 | 0 | 0 | 0
22 | Indirect Cost | 7000 | 0 | 7000
24 | In-Kind Expense | 0 | 0 | 0
25 | GRAND TOTAL | 100000 | 0 | 100000
1  Each expense object line-item shall be defined by the Department of Finance and Administration Policy 03, Uniform Reporting Requirements and Cost Allocation Plans for Subrecipients of Federal and State [NAME], [NAME] (posted on the Internet at:  http://www.tn.gov/finance/act/documents/policy3.pdf).
2  Applicable detail attached if line-item is funded.
Spreadsheet: daren_farmer__6600__egmnom-Mar
Sheet: RHODIA

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-011
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-03-01 00:00:00
Fax: | (713)207-0054 | Stop:
 |  | 2000-03-31 00:00:00
RECEIPTS |  |  | MAR
METER # | [NAME] | SUPPLIER | 1
4132 | EXXON KATY | [NAME] (MIDCON 92155) | 500
ZZZZ | IMBALANCE |  | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
8078 | RHODIA-FREEPORT | RHODIA-FREEPORT | 500
ZZZZ | IMBALANCE |  | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 125705d1319182069-student-grade-inputting-and-grade-percentage-calculations-assignment
Sheet: Sheet1

Assignment
 |  | Marks per Assignment | 5
 |  | Total Assignment % | 0.15
 |  |  | Actual Percentage | Actual Score | Full Score | Assignment Number
 |  | Student Name |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 1 | Student A | 0.12 | 8 | 10 | 5 | 3
 | 2 |  | 0 | 0 | 0
 | 3 |  | 0 | 0 | 0
 | 4 |  | 0 | 0 | 0
 | 5 |  | 0 | 0 | 0
 | 6 |  | 0 | 0 | 0
 | 7 |  | 0 | 0 | 0
 | 8 |  | 0 | 0 | 0
 | 9 |  | 0 | 0 | 0
 | 10 |  | 0 | 0 | 0
 | 11 |  | 0 | 0 | 0
 | 12 |  | 0 | 0 | 0
 | 13 |  | 0 | 0 | 0
 | 14 |  | 0 | 0 | 0
 | 15 |  | 0 | 0 | 0
 | 16 |  | 0 | 0 | 0
 | 17 |  | 0 | 0 | 0
 | 18 |  | 0 | 0 | 0
 | 19 |  | 0 | 0 | 0
 | 20 |  | 0 | 0 | 0
 | 21 |  | 0 | 0 | 0
 | 22 |  | 0 | 0 | 0
 | 23 |  | 0 | 0 | 0
 | 24 |  | 0 | 0 | 0
 | 25 |  | 0 | 0 | 0
 | 26 |  | 0 | 0 | 0
 | 27 |  | 0 | 0 | 0
 | 28 |  | 0 | 0 | 0
 | 29 |  | 0 | 0 | 0
 | 30 |  | 0 | 0 | 0
 | 31 |  | 0 | 0 | 0
 | 32 |  | 0 | 0 | 0
 | 33 |  | 0 | 0 | 0
 | 34 |  | 0 | 0 | 0
 | 35 |  | 0 | 0 | 0
 | 36 |  | 0 | 0 | 0
 | 37 |  | 0 | 0 | 0
 | 38 |  | 0 | 0 | 0
 | 39 |  | 0 | 0 | 0
 | 40 |  | 0 | 0 | 0
 | 41 |  | 0 | 0 | 0
 | 42 |  | 0 | 0 | 0
 | 43 |  | 0 | 0 | 0
 | 44 |  | 0 | 0 | 0
 | 45 |  | 0 | 0 | 0
 | 46 |  | 0 | 0 | 0
 | 47 |  | 0 | 0 | 0
 | 48 |  | 0 | 0 | 0
 | 49 |  | 0 | 0 | 0
 | 50 |  | 0 | 0 | 0
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: CE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 75372445 | 171024496
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 32366719 | 72950314
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 107739164 | 243974810
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -82278061 | -183435098 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -27633671 | -64228073.98
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 246736 | 556223
 | Total Purchases: |  | -109664996 | -247106948.98
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 248 | 10
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 2377169 | 4895115 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 2377417 | 4895125
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | -299343 | -615150
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -299343 | -615150
 | Total Storage: |  | -299343 | -615150
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -152242 | -324732.186
 |  |  | 0 | 0
23 | Fuel: |  | -246736 | -556223
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -64099
25 |  | Demand | 0 | -2009563
 | Total Transport Expense: |  | 0 | -2073662
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 1768212.0426
31 |  | Prior Month Book Balance | 0 | 2767229
 |  | Total MTM Income | 0 | 4535441.042599999
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -4350605
34 |  | Originations | 0 | 7439
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 1083367
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 875269d1721845185-search-and-add-test-nihammon
Sheet: TEST

Item | Buy date | Buy price
Chocolate | 2020-01-02 17:43:00 | 6970.15924060414
Sweets | 2020-01-03 04:45:00 | 7227.0684598633
Potato | 2020-01-03 04:47:00
Drinks | 2020-01-03 12:32:00 | 7330.48188192224
Potato | 2020-01-03 14:04:00
Drinks | 2020-01-05 03:12:00 | 7446.54696768
Potato | 2020-01-05 09:03:00
Drinks | 2020-01-06 04:12:00 | 7529.51995783254
Drinks | 2020-01-06 23:21:00 | 7737.93822887955
Sweets | 2020-01-10 18:10:00 | 8045.55126290948
Drinks | 2020-01-14 04:27:00 | 8531.02031327339
Drinks | 2020-01-17 09:01:00 | 8946.98733971292
Chocolate | 2020-01-19 12:42:00 | 8640.86612497366
Drinks | 2020-01-27 13:51:00 | 8758.86895419281
Drinks | 2020-01-30 17:50:00 | 9486.25847074772
Ice Cream | 2020-02-03 17:01:00 | 9262.93194490644
Drinks | 2020-02-05 12:32:00 | 9447.57692702924
Ice Cream | 2020-02-10 07:28:00 | 9997.07847676397
Potato | 2020-02-11 16:30:00 | 10251.7072986215
Chocolate | 2020-02-16 20:13:00 | 9763.66751827579
Chocolate | 2020-02-17 14:37:00 | 9541.267034273
Potato | 2020-02-19 22:49:00 | 9637.42536147
Chocolate | 2020-02-24 18:27:00 | 9556.97402369288
Chocolate | 2020-02-26 02:58:00 | 9215.70497516145
Potato | 2020-03-01 17:34:00 | 8494.11695333686
Drinks | 2020-03-05 12:47:00 | 9095.8577753263
Chocolate | 2020-03-07 17:41:00 | 8954.70146689864
Chocolate | 2020-03-11 18:28:00 | 7652.46242478179
Chocolate | 2020-03-12 04:37:00 | 7615.79195159953
Out | 2020-03-13 02:02:00
TOTAL | POTATO
 |  | pivot table
 |  | Row Labels | Sum of Buy price
 |  | Chocolate | 77911.59476026086
 |  | Drinks | 84311.0568165967
 |  | Ice Cream | 19260.01042167041
 |  | Potato | 28383.24961342836
 |  | Sweets | 15272.61972277278
 |  | Grand Total | 225138.5313347291
Spreadsheet: 811825d1672823169-formula-to-return-sum-with-multiple-criteria-index-match-problem
Sheet: sum

client ID
 |  |  | 100700 | product group
4 | client x
5 | client y |  |  | why this cell is blank when client wit ID 5 have value in sheet dec22
8 | client z
49 | client q
54 | client ab
71 | client bc
88 | client cd
Spreadsheet: 869398d1715963940-formula-for-calculating-turnaround-time-within-complex-work-hours-that-cross-midnight-sample-calculations-turnaround-time-complex-working-hours
Sheet: Log

Working Hours |  |  | Holidays | 2024-01-01 00:00:00 | 2024-05-27 00:00:00 | 2024-07-04 00:00:00 | 2024-07-05 00:00:00 | 2024-09-02 00:00:00 | 2024-11-28 00:00:00 | 2024-11-29 00:00:00 | 2024-12-24 00:00:00 | 2024-12-25 00:00:00
5:00AM - 1:30AM Mon-Thur
5:00AM-3:30PM Fri
Sample | Date In | Time In | Date Done | Time Done | Date Out | Time Out | Date/Time In | Date/Time Done | Date/Time Out | Time 1 | Time 2 | Actual Time 1 | Actual Time 2
Same Day | 2024-05-13 00:00:00 | 05:00:00 | 2024-05-13 00:00:00 | 14:00:00 | 2024-05-13 00:00:00 | 14:30:00 |  |  |  |  |  | 9 | 9.5
Past 12PM | 2024-05-13 00:00:00 | 05:00:00 | 2024-05-14 00:00:00 | 00:30:00 | 2024-05-14 00:00:00 | 01:30:00 |  |  |  |  |  | 19.5 | 20.5
Past 12PM+next day | 2024-05-13 00:00:00 | 05:00:00 | 2024-05-14 00:00:00 | 00:30:00 | 2024-05-14 00:00:00 | 06:00:00 |  |  |  |  |  | 19.5 | 21.5
Start past 12 | 2024-05-14 00:00:00 | 00:00:00 | 2024-05-14 00:00:00 | 01:30:00 | 2024-05-14 00:00:00 | 06:00:00 |  |  |  |  |  | 1.5 | 2
Start past 12+ND | 2024-05-14 00:00:00 | 00:00:00 | 2024-05-14 00:00:00 | 06:00:00 | 2024-05-14 00:00:00 | 06:30:00 |  |  |  |  |  | 2.5 | 3
Same Day Friday | 2024-05-10 00:00:00 | 05:00:00 | 2024-05-10 00:00:00 | 14:00:00 | 2024-05-10 00:00:00 | 14:30:00 |  |  |  |  |  | 9 | 9.5
Overnight Friday | 2024-05-10 00:00:00 | 05:00:00 | 2024-05-13 00:00:00 | 06:00:00 | 2024-05-13 00:00:00 | 06:30:00 |  |  |  |  |  | 11.5 | 12