tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120302d1315186639-data-entry-over-multiple-sheets-sample-lesson-group-workbook
Sheet: CC MONDAY

 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00 | 2011-10-06 00:00:00 | 2011-10-13 00:00:00 | 2011-10-20 00:00:00 | 2011-10-27 00:00:00 | 2011-11-03 00:00:00 | 2011-11-10 00:00:00 | 2011-11-17 00:00:00 | 2011-11-24 00:00:00 | 2011-12-01 00:00:00 | 2011-12-08 00:00:00 | 2011-12-15 00:00:00 | 2011-12-22 00:00:00 | 2011-01-05 00:00:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
01:00:00
01:30:00
02:00:00
02:30:00
 | GROUP A |  |  |  | GROUP D |  |  |  | GROUP G |  |  |  | GROUP J
 | GROUP B |  |  |  | GROUP E |  |  |  | GROUP H |  |  |  | GROUP K
 | GROUP C |  |  |  | GROUP F |  |  |  | GROUP I |  |  |  | GROUP L
Spreadsheet: 139899d1328538566-excel-2007-how-to-calculate-count-of-certain-column-values-in-a-pivot-table-pt-calculated-item
Sheet: Sheet1

T | F | S
T1 | t | S1
T1 | t | S2
T1 | t | S3
T1 | t | [NAME]
T2 | t | S3
T2 | t | S2
T2 | t | S3
T2 | t | [NAME]
Spreadsheet: 868815d1715521653-split-cell-with-multiple-lines-into-usable-data-explain-sheet2
Sheet: Sheet1

Mon 27 May, 20:05 OSS #1 - $2,000,000 GTD [Day2] $630 674 $2,000,000 15 DAYS Mon 27 May, 20:05 OSS #2 Mystery Bounty - $1,500,000 GTD [Day2] $109 3,094 $1,500,000 15 DAYS Mon 27 May, 20:05 OSS #3 - $500,000 GTD [Day2] $66 2,005 $500,000 15 DAYS Sun 26 May, 20:05 OSS #4 Mystery Bounty - $200,000 GTD [Day2] $16.50 3,480 $200,000 14 DAYS Sun 26 May, 20:05 OSS #5 Mystery Bounty - $100,000 GTD [Day2] $2.50 9,275 $100,000 14 DAYS Sun 12 May, 17:05 OSS #89L - $50,000 GTD Low [NAME] Off $11 136 $50,000 JOIN Sun 12 May, 18:05 OSS #90 - $750,000 GTD Sunday High Roller $630 26 $750,000 JOIN Sun 12 May, 19:05 OSS #91 PKO - $750,000 GTD $2,650 15 $750,000 JOIN HOT This section is reserved to hold tournaments you are registered in. Also, you can use in other rows to place that tournament here. YOURS OSS All-In or Fold STEPS Late Reg:Lvl 11 (16:54) PKO - $3,000 GTD $33 100 $3,000 JOIN Late Reg:Lvl 8 (51:43) [NAME]600 GTD $11 42 $600 JOIN Late Reg:Lvl 5 (77:49) [NAME]1,000 GTD $6.60 92 $1,000 JOIN Late Reg:Lvl 7 (124:24) PKO Early Special - $6,000 GTD $11 297 $6,000 JOIN Late Reg:Lvl 2 (135:13) PKO - $10,000 GTD $22 184 $10,000 JOIN Late Reg:Lvl 11 (160:50) OSS #85H - $20,000 GTD Early Special $16.50 399 $20,000 JOIN Late Reg:Lvl 11 (161:02) OSS #85M - $7,500 GTD Early Special $8.80 290 $7,500 JOIN Late Reg:Lvl 5 (182:04) OSS #86H - $60,000 GTD Euro WarmUp $109 90 $60,000 JOIN Late Reg:Lvl 5 (184:04) OSS #86L - $40,000 GTD $55 162 $40,000 JOIN
 | $3,000 | GTD | $33 | 100 | $3,000 | JOIN | #N/A | #N/A
Late Reg:Lvl 8 (51:43) [NAME] | $600 | GTD | $11 | 42 | $600 | JOIN | #N/A | #N/A
Late Reg:Lvl 5 (77:49) [NAME] | $1,000 | GTD | $6.60 | 92 | $1,000 | JOIN | #N/A | #N/A
Late Reg:Lvl 7 (124:24) PKO Early Special | $6,000 | GTD | $11 | 297 | $6,000 | JOIN | #N/A | #N/A
Late Reg:Lvl 2 (135:13) PKO | $10,000 | GTD | $22 | 184 | $10,000 | JOIN | #N/A | #N/A
Late Reg:Lvl 11 (160:50) OSS #85H | $20,000 | GTD | Early | Special | $16.50 | 399 | $20,000 | JOIN
Late Reg:Lvl 11 (161:02) OSS #85M | $7,500 | GTD | Early | Special | $8.80 | 290 | $7,500 | JOIN |  |  | IN THESE LINES THE FORMAT WENT WRONG BECAUSE OF A DIFFERENT TEKST FORMAT
Late Reg:Lvl 5 (182:04) OSS #86H | $60,000 | GTD | Euro | [NAME] | $109 | 90 | $60,000 | JOIN
Late Reg:Lvl 5 (184:04) OSS #86L | $40,000 | GTD | $55 | 162 | $40,000 | JOIN | #N/A | #N/A
Minutes left |  |  | Buy in | Players | Guaranteed |  |  |  |  |  | WHAT I WANT THE RESULTS TO BE
16 |  |  | 33 | 100 | 3000 |  |  |  |  |  | Get Numbers from the lines
 |  |  |  |  |  |  |  |  |  |  | Make Calculations with the numbers
Spreadsheet: 24b2b36a-65a6-485d-9f6d-c92c5ce516d0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 9. FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Personal Finance - New motor cars and station wagons ; |  |  | Original | A2414166T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Personal Finance - Used motor cars and station wagons ; |  |  | Original | A2414167V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Personal Finance - Motor cycles ; |  |  | Original | A2414168W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Personal Finance - Other motor vehicles ; |  |  | Original | A2414169X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2414170J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Commercial Finance ; |  |  | Original | A2414171K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Value of Lease Finance Commitments ; |  |  | Original | A2414172L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414173R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 173906d1344851767-sum-if-0a32trial-1-
Sheet: Sheet1

 |  |  |  | Helper Columns |  |  |  | Budget |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | JAN |  |  | Fruits
 |  |  |  | You can hide these |  |  |  | Apple | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | FEB |  |  | Apple
 |  |  |  |  |  |  |  | Orange | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | MARTC |  |  | Orange
DATE | Commodity | PRIZE |  |  |  |  |  | Grapes | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | APR |  |  | Grapes
2012-06-01 00:00:00 | Apple | 2 | Apple | 6 | JUN |  | Annual Epenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | MAY |  |  | Total Expenses
2012-06-03 00:00:00 | Orange | 2 | Orange | 6 | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | JUN |  |  | [NAME]
2012-07-08 00:00:00 | Grapes | 2 | Grapes | 7 | JUL |  | Month | Commodity | Expenses | Above Budget | Below Budget | South Afircan Products |  |  |  |  |  |  |  |  |  |  | 7 | JUL |  |  | Kiwi
2012-07-10 00:00:00 | Water Melon | 5 | Water Melon | 7 | JUL | 6 | JUN | Total Expenses | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | AUG |  |  | Total expenses
2012-07-16 00:00:00 | [NAME] | 5 | [NAME] | 7 | JUL | 7 | JUL | Total Expenses | 115.9 |  |  | 10 |  |  |  |  |  |  |  |  |  |  | 9 | SEPT
2012-07-16 00:00:00 | Kiwi | 20 | Kiwi | 7 | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | OKT
2012-07-17 00:00:00 | Apple | 8 | Apple | 7 | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | NOV
2012-07-17 00:00:00 | Orange | 0.3 | Orange | 7 | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | DEC
2012-07-17 00:00:00 | Apple | 3 | Apple | 7 | JUL
2012-07-17 00:00:00 | Orange | 5 | Orange | 7 | JUL
2012-07-17 00:00:00 | Grapes | 2 | Grapes | 7 | JUL
2012-07-17 00:00:00 | Water Melon | 2 | Water Melon | 7 | JUL
2012-07-21 00:00:00 | [NAME] | 4.8 | [NAME] | 7 | JUL
2012-07-21 00:00:00 | Kiwi | 4.8 | Kiwi | 7 | JUL
2012-07-22 00:00:00 | Apple | 10 | Apple | 7 | JUL |  |  |  | 2 |  | 8
2012-07-22 00:00:00 | Orange.in | 1 | Orange | 7 | JUL |  |  | 0 | 21 | 11
2012-07-22 00:00:00 | Orange.uk | 2 | Orange | 7 | JUL
2012-07-22 00:00:00 | Orange.bl | 3 | Orange | 7 | JUL
2012-07-22 00:00:00 | Orange.South Africa | 2 | Orange | 7 | JUL
2012-07-22 00:00:00 | Apple.South Africa | 2 | Apple | 7 | JUL
2012-07-22 00:00:00 | Peach.South Africa | 6 | Peach | 7 | JUL
2012-07-22 00:00:00 | Dates | 13 | Dates | 7 | JUL
2012-07-22 00:00:00 | Cashew | 15 | Cashew | 7 | JUL
 |  |  | 0 | 1 | JAN
Spreadsheet: 465919d1465940596-choose-item-from-a-table-based-on-percentage-weighted-random
Sheet: Random

ITEMS | Drop chance |  | DRAW:
Item 1 | 3 | 1
Item 2 | 7.000000000000001
Item 3 | 10
Item 4 | 2
Item 5 | 18
Item 6 | 9
Item 7 | 11
Item 8 | 10
Item 9 | 15
Item 10 | 15
TOTAL
Spreadsheet: 32742ed5-7064-4fca-a5a4-9b4127694999
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 21. Selected output of division L rental, hiring and real estate services, subdivision, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  66 Rental and hiring services (except real estate) ; |  |  | Original | A2314172R | 1996-06-01 00:00:00 | 2011-09-01 00:00:00 | 62 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  661 Motor vehicle and transport equipment rental and hiring ; |  |  | Original | A3343910T | 2001-09-01 00:00:00 | 2011-09-01 00:00:00 | 41 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6611 Passenger car rental and hiring ; |  |  | Original | A3343912W | 2001-09-01 00:00:00 | 2011-09-01 00:00:00 | 41 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6619 Other motor vehicle and transport equipment rental and hiriing ; |  |  | Original | A3343914A | 2001-09-01 00:00:00 | 2011-09-01 00:00:00 | 41 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  663 Other goods and equipment rental and hiring ; |  |  | Original | A2314181T | 1996-06-01 00:00:00 | 2011-09-01 00:00:00 | 62 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6712 Non-residential property operators ; |  |  | Original | A2314163L | 1996-03-01 00:00:00 | 2011-09-01 00:00:00 | 63 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  672 Real estate services ; |  |  | Original | A2314166V | 1998-09-01 00:00:00 | 2011-09-01 00:00:00 | 53 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-12

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-16 00:00:00
 |  |  | Monitoring Well #: | MW-12 |  |  |  | Well Depth: | 8.51 |  | ft |  |  | Screened/Open Interval: | 2-6' |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 6 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 4.46 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 925 | x |  | 6.57 | NA | 13.96 | NA | 1492 | NA | 0.73 | NA | -34.9 | NA | 62.2 | NA | 300 | 4.6
 | 930 | x |  | 6.57 |  | 13.85 |  | 1441 |  | 0.47 |  | -53.7 |  | 34.8 |  | 300 | 4.61
 | 935 | x |  | 6.62 |  | 13.67 |  | 1376 |  | 0.35 |  | -70.9 |  | 20.7 |  | 300 | 4.67
 | 940 | x |  | 6.65 |  | 13.6 |  | 1337 |  | 0.32 |  | -75.6 |  | 16.8 |  | 300 | 4.66
 | 945 | x |  | 6.67 |  | 13.64 |  | 1318 |  | 0.31 |  | -69.2 |  | 9.96 |  | 300 | 4.69
 | 950 | x |  | 6.68 |  | 13.55 |  | 1316 |  | 0.3 |  | -73.6 |  | 9.17 |  | 300 | 4.75
 | 955 | x |  | 6.7 |  | 13.44 |  | 1302 |  | 0.29 |  | -78.4 |  | 9.43 |  | 300 | 4.71
 | 1000 |  | x | 6.71 |  | 13.45 |  | 1296 |  | 0.27 |  | -81.4 |  | 3.82 |  | 300 | 4.72
 | Comments: |  | Pump could not be set at proper intake depth due to inadequate water level
 |  | Purge start: |  |  | 09:18:00 |  |  | Sample time: |  | 09:57:00
 |  | Purge end: |  |  | 09:55:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 129065d1321434865-vertical-horizontal-reference-for-a-cell-vlookup-example-file
Sheet: Amounts Matrix

 | Transactions
Account Nr | Trans 1 | Trans 2 | Trans 3 | Trans 4 | Trans 5 | Trans 6 | Trans 7 | Trans 8 | Trans 9 | Trans 10 | Trans 11 | Trans 12 | Trans 13
100100
100200 | -115000 |  | 568925
100300 |  |  | 10000
100400 |  | 5400000 | 59988
100500 |  |  | 48659255 |  |  |  | 5000000
250150 |  |  |  |  |  |  |  |  |  |  | -343840989
250200
250250
250300 |  |  |  |  |  | 3792575
250350 |  |  |  | 300050012
250400 |  |  |  |  |  |  |  | -45839848
250450 |  |  |  |  | -1111000 |  |  |  |  |  | -458698321
250500
250550 | 45843860
250600
250650 |  |  | 84883899
250700 |  |  |  |  |  |  |  |  | -5839459
250750
250800 |  |  |  |  | -383484583
250850
250900 |  |  |  |  |  |  |  |  |  |  |  | 344398759
250950
Spreadsheet: 98254d1297245816-get-the-text-from-one-string-extracting-20the-20text-20from-20the-20string-1-
Sheet: LIST

Bussiness Role ID
CRX27
CRX28
CRX29
CRXD1
CRXD11
CRXD2
CRXD4
CRXD5
CRXD6
CRXD7
CRXD8
[NAME]
CR13
CR15
CR16
FI02
FI22
FI23
FI24
FI25
FI26
FI29
[NAME]
MD29
MF25
PU07
PU08
PU09
PU10
PU11
PU16
PU17
PU18
PU25
SC25
TR01
TR02
TR03
TR04
TR05
CR02
CR23
CO01
CO03
CO04
CO06
CO08
CO10
CO12
CO14
CO15
CO17
CO18
CO19
CO21
CR01
CR03
CR04
CR05
CR07
CR09
CR10
CR11
CR12
CR17
CR19
CR20
CR22
CR24
CR25
CR26
CR30
CR34
FI00
FI03
FI04
FI05
FI06
FI07
FI08
FI10
FI11
FI13
FI14
FI16
FI17
FI18
FI19
FI20
FI21
HR01
HR02
LO01
LO02
LO03
LO04
LO05
[NAME]
LO07
LO08
LO09
LO11
LO13
LO16
LO18
MA01
MA02
MD02
MD03
MD04
MD10
MD11
MD12
MD13
MD15
[NAME]
MD18
MD20
MD22
[NAME]
MD26
MD27
MD28
MD30
MD31
MD33
[NAME]
MD35
MD36
MD37
MD38
MD39
MD40
MD41
MD42
MD43
MD44
MD45
MD46
MF01
MF02
MF04
MF05
MF06
MF07
MF08
MF09
MF11
MF12
MF13
MF16
MF17
MF18
PU01
PU02
PU03
PU04
PU06
PU12
PU13
PU15
PU20
PU21
PU24
PU27
PU28
PU29
PU30
QU01
QU02
QU03
QU04
QU05
QU07
SC02
LOX8
[NAME]
MF03
LO10
LO17
MF10
CR14
PU14
PU19
QU20
SC01
Spreadsheet: daren_farmer__6580__egmnom-Feb
Sheet: EGM 201

 | Nomination Change
 | ATTN: Transportation Specialist
HOUSTON PIPE LINE COMPANY
HPL Contract # |  | 012-27106-02-001
Shipper: | Entex Gas Marketing | Effective Dates:
Nominator: | Troy Benoit | Start:
Telephone: | (713)207-3376 | 2000-02-01 00:00:00
Fax: | (713)646-5799 | Stop:
 |  | 2000-02-29 00:00:00
RECEIPTS |  |  | FEB | FEB | FEB | FEB | FEB
METER # | [NAME] | SUPPLIER | 1
35 | MOSS BLUFF |  | 0 | 0 | 0 | 0 | 0
71 | TEXOMA |  | 0 | 0 | 0 | 0 | 0
584 | VALERO - AGUA DULCE |  | 0 | 0 | 0 | 0 | 0
644 | LONE STAR KATY |  | 0 | 0 | 0 | 0 | 0
701 | WESTERN HEADER |  | 0 | 0 | 0 | 0 | 0
4045 | EXXON CLEAR LAKE | SUPERIOR
4132 | EXXON KATY | ECT | 10000 | 10000 | 10000 | 10000 | 10000
4132 | EXXON KATY | ECT | 9500 | 9500 | 9500 | 9500 | 9500
4132 | EXXON KATY |  | 0 | 0 | 0 | 0 | 0
4132 | EXXON KATY  (AQ SS) |  | 0 | 0 | 0 | 0 | 0
4132 | EXXON KATY |  | 0 | 0 | 0 | 0 | 0
4531 | NEEDVILLE |  | 0 | 0 | 0 | 0 | 0
6269 | PG&E THOMPSONVILLE |  | 0 | 0 | 0 | 0 | 0
6351 | TEJAS THOMPSONVILLE |  | 0 | 0 | 0 | 0 | 0
6721 | PAWNEE PLANT |  | 0 | 0 | 0 | 0 | 0
6780 | [NAME] |  | 0 | 0 | 0 | 0 | 0
7038 | TRANS TX AUGA DULCE |  | 0 | 0 | 0 | 0 | 0
7285 | MOSS BLUFF |  | 0 | 0 | 0 | 0 | 0
8740 | MID TX KATY |  | 0 | 0 | 0 | 0 | 0
6040 | VALERO RIVERSIDE |  | 0 | 0 | 0 | 0 | 0
7038 | [NAME] | CONOCO | 0 | 0 | 0 | 0 | 0
9643 | EXXON KING RANCH |  | 0 | 0 | 0 | 0 | 0
98675710 | CROW OCONNER | [NAME] | 150 | 150 | 150 | 150 | 150
ZZZZ | FORCED PAYBACK | ENTEX/HPL | 0 | 0 | 0 | 0 | 0
 |  | RECEIPT TOTAL
DELIVERIES
METER # | [NAME] | MARKET
35 | MOSS BLUFF
522 | HARDY
1000 | FORMOSA PLANT | FORMOSA
1060 | SHELL DEER PARK
1063 | LYONDELL/CITGO
1168 | [NAME]
1233 | TX CITY
1244 | KOCH REFINERY
1427 | GSU SABINE | ENTERGY | 13000 | 13000 | 13000 | 13000 | 13000
4132 | EXXON KATY HPL | AMOCO
7340 | LUFKIN CHAMPION | DONAHOE
1264 | WINNIE PIPELINE
1319 | ENERCORP
1326 | ENTERPRISE | ENTERPRISE
1373 | LYONDELL
1394 | HILL PETRTO | DYNEGY
1412 | HL&P PH ROBINSON
1427 | GSU SABINE | RES
1428 | DUPONT BEAUMONT | DUPONT
1431 | MARATHON TX CITY
1485 | OXY BATTLE GROUND | OXY
1507 | SABINE PIPELINE
1508 | IGS DODGE STREET
1563 | DESTECH
3069 | BAMMEL STORAGE | MIDCON/ENTEX
4132 | EXXON KATY HPL | RES
4531 | NEEDVILLE
3537 | [NAME] | KET
8020 | BAYPORT PLANT
 | HUNTSMAN | ENTEX
ZZZZ | IMBALANCE |  | 0 | 0 | 0 | 0 | 0
 |  | DELIVERY TOTAL
 |  | BALANCE
Spreadsheet: 783780d1655137528-using-iferror-and-unique-to-create-a-summary-table-2022-06-13-oeldere-benhornsby2021-voucher-tracker2
Sheet: MasterList

Staff issuing | Project name | Date issued | Recipient name | Recipient Postcode | Ward Area | Amout issued | Date issued2 | Reason for allocation | Additional information
[NAME] | Atrax |  |  |  |  | 1
[NAME] | Atrax |  |  |  |  | 2
[NAME] | Works4Youth |  |  |  |  | 4
[NAME] | Elecmobile |  |  |  |  | 3
[NAME] | PolyCarbon |  |  |  |  | 5
[NAME] | Atrax |  |  |  |  | 3
[NAME] | [NAME] |  |  |  |  | 2
Spreadsheet: 58322d1258582394-how-to-sum-by-date-month-year-running-daily-totals-daily-report-excel_wsums
Sheet: Cash Sales

Cash Sales
Day/Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1 | 400
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: 329582d1404343075-calculate-up-to-a-value-calculate-up-to-a-value-hours-1-
Sheet: HOW IT WORKS - PLEASE READ 1ST

 |  |  |  |  |  |  |  |  |  |  | TAKEN | START | PAID HRS | REMAINING
 | Week |  | Week | Total | Total | Total Days | Total |  |  |  | HOLIDAYS | BALANCE | HOLIDAY | HOLIDAYS
 | Commencing |  | No | Hours | NonWkHrs | Holiday | [NAME] |  |  |  | 0 | 21 |  | 21
 | 00:00:00 |  | 1 |  |  | 1
 |  |  | 2
 |  |  | 3 |  |  | 1
 |  |  | 4
 |  |  | 5 |  |  | 4
 |  |  | 6
 |  |  | 7 |  |  | 5
 |  |  | 8
 |  |  | 9 |  |  | 5
 |  |  | 10
 |  |  | 11 |  |  | 3.5
 |  |  | 12
 |  |  | 13 |  |  | 2
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  |  | é | é | é |  | é
 |  |  |  | SHOULD |  |  | NOW CORRECTLY
 |  |  |  | BE |  |  | CALCULATES BY THE HOUR
 |  |  |  | ENTERED |  |  | AS IN CHECK 24/03/1900 ROW
 |  |  |  | AS
 |  |  |  | WHOLE NUMBER
 |  |  |  | AS IN 48
 |  |  |  | NOT 48:00
 |  |  |  |  |  | é
 |  |  |  |  | ACCEPTS HALF-DAY
 |  |  |  |  | HOLIDAYS
 |  |  |  |  | AS IN   0.5
 |  |  |  |  | NOT   0:5
Spreadsheet: 866782d1713706814-debtor-ageing-with-adjustment-of-credit-balance-on-fifo-basis-debtor-ageing-template-1-
Sheet: Debtor ageing template

 | OLD DEBTOR AGEING |  |  |  |  |  |  |  |  |  | DESIRED DEBTOR AGEING
 | Total | 0-30 | 31-60 | 61-90 | 91-120 | 121-180 | 181-360 | 366-730 | 731-1095 |  | New Bal | 0-30 | 31-60 | 61-90 | 91-120 | 121-180 | 181-360 | 366-730 | 731-1095
Case1 |  | 100 | 700 | 400 | -2500 | 1000 | 800 | -100 | 1800 |  |  | 100 | 700 | 400 | 0 | 1000
Case2 |  | 100 | -200 | -300 | 400 | -1000 | 700 | -800 | 1800 |  |  | 100 | 0 | 0 | 400 | 0
Case3 |  | 100 | -200 | -300 | -1900 | 500 | 500 | 900 | 1800 |  |  | 100 | 0 | 0 | 0 | 500
 |  | 100 | -200 | -300 | -1900 | 500 | 500 | 900 | 1800 |  |  | 100 | 0 | 0 | 0 | 500
Case 1
2500 negative balance is adjusted till 31-60 bucket and balance of 400 placed in 31-60 bucket and 0-30 bucket kept as it is since negative 2500 is exhausted in bucket 31-60
Case 2
Positive balance of 1800 in bucket >180 adjusted against 61-90 & 31-60 and balance 1300 kept as it is same bucket. Rest bucket same as it since there is no negative balance to adjust.
Case 3
Balance 1800 in bucket is adjusted in bucket >180 and bucket 0-30. Being balance in 91-120 exhausted, rest bucket kept as it.
Spreadsheet: 164048d1340630195-gross-pay-payroll1
Sheet: Sheet1

Employee Number | Employee Name | Hours Worked | [NAME] | Gross Pay
 |  | 38
 |  | 38
 |  | 38
 |  | 38
 |  | 38
 |  | 38
 |  | 38
 |  | 38
 |  | 38
 |  | 38
 |  | 38
 |  | 38
Spreadsheet: 770224d1645899392-transfer-link-with-filter-function-test-sort-2
Sheet: MENUS

 | TYPE
 | REMORQUE FERMÉE | PROFILE_4
 | REMORQUE A COL DE CYGNE - ACIER | PROFILE_5
 | REMORQUE A COL DE CYGNE - GALVANISÉ | PROFILE_6
 | dimension | hauteur | capacité | couleur
 | 6x12 | 6 | 3500 - 1 essieu | BLANC
 | 6x14 | 7 | 5500 - 2 essieux | NOIR
 | 7x14 | 8 | 7000 - 2 essieux | ANTHRACITE
 | 7x20 |  | 20000 - 2 essieux | ROUGE
 | 8x16 |  |  | ARGENT
 | 8x22
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -175
2
3 |  | -2000
4
5 |  | -16528
6 | -31547 | -16528
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-12-31 00:00:00 |  |  | -8253
2002-01-06 00:00:00
CBS Dollars
 |  |  | 163235
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: HX04 GHD

 |  |  |  |  | [NAME]
Registration number : | [NAME] |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2008-02-29 00:00:00 | 12 Months | 2009-03-01 00:00:00 | 165 | Private HGV
Specification : | 4 X 2 RCT (2 Axle) |  | 2008-06-30 00:00:00 | Exchanged Licence | 2009-03-01 00:00:00 | n/a | HGV
Type : | FA LF45.150 |  | 2009-02-27 00:00:00 | 12 Months | 2010-03-01 00:00:00 | 165
1st Registered : | 21.04.04 |  | 2010-02-26 00:00:00 | 12 Months | 2011-03-01 00:00:00 | 165
Engine : | CUMMINS BE 150 |  | 2011-02-28 00:00:00 | 12 Months | 2012-03-01 00:00:00 | 165
[NAME] : | unkown |  | 2012-02-29 00:00:00 | 12 Months | 2013-03-01 00:00:00 | 165
Back To Index
Spreadsheet: sally_beck__34369__FallonDelaneyrpt
Sheet: Webb

[NAME]
GIS ID | Formatted Name | Company Name | Job Title | [NAME] | Level1 Full Name | Level2 [NAME] | Level3 [NAME] | Level4 [NAME] | Company | BU Supported: EGM, EIM, EBS, EES or ENA
90040932 | BAEHR, KEVIN P | ENRON NET WORKS LLC(CNEN) | STAFF IT | DINH, THUY-TIEN T | WHALLEY, [NAME] | PIPER, GREGORY | PICKERING, MARK | WEBB, [NAME] | Estate
90009025 | COUCH, KEITH N | ENRON NET WORKS LLC(CNEN) | DIRECTOR IT | ELROD, HAL C | WHALLEY, [NAME] | PIPER, GREGORY | PICKERING, MARK | WEBB, [NAME] | Estate
90126605 | CUMMINS, DOUGLAS | ENRON NET WORKS LLC(CNEN) | DIRECTOR IT | MONTAGNE, KEVIN A | WHALLEY, [NAME] | PIPER, GREGORY | PICKERING, MARK | WEBB, [NAME] | Estate
90129052 | [NAME], LISA | ENRON NET WORKS LLC(CNEN) | SPECIALIST IT | DINH, THUY-TIEN T | WHALLEY, [NAME] | PIPER, GREGORY | PICKERING, MARK | WEBB, [NAME] | Estate
90128722 | FISHER, [NAME] | ENRON NET WORKS LLC(CNEN) | MANAGER IT | SMITH, TERESA J | WHALLEY, [NAME] | PIPER, GREGORY | PICKERING, MARK | WEBB, [NAME] | Estate
90137052 | HOMMELL, MATT | ENRON NET WORKS LLC(CNEN) | SPECIALIST IT |  |  |  |  |  | Estate
90152406 | RIVERA, BRYAN | ENRON NET WORKS LLC(CNEN) | SPECIALIST SR IT |  |  |  |  |  | Estate
90137079 | SANCHEZ, CHRIS | ENRON NET WORKS LLC(CNEN) | SPECIALIST IT |  |  |  |  |  | Estate
90152395 | SEK, JULIE | ENRON NET WORKS LLC(CNEN) | STAFF IT | ALTHAUS, [NAME] R | WHALLEY, [NAME] | PIPER, GREGORY | PICKERING, MARK | WEBB, [NAME] | Estate
 |  |  |  | 9
Spreadsheet: 77927d1278421681-filling-in-columns-for-numeric-only-fillin
Sheet: Sheet2

case name
totals
500
500
500
500
500
500
500
totals
399
399
399
399
399
399
399
case name
totals
400
400
400
400
400
400
400
400
400
400
end
Spreadsheet: 773993d1648146433-want-to-sum-up-specific-cells-in-a-cohort-table-sum-of-diagonal-using-index
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 |  | Helper
April | 100 |  |  |  |  |  |  | << Sum
May | 80 | 100 |  |  |  |  |  | << [NAME]
June | 70 | 80 | 80
July | 60 | 70 | 70 | 70
August | 50 | 60 | 60 | 60 | 70
September | 40 | 50 | 50 | 50 | 60
October | 30 | 40 | 40 | 40 | 50