tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 046fb196-c2dd-4376-b179-358a348a2902
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Batch ID: | Unnamed: 5 | Unnamed: 6
 |  |  |  | Style & Recipe Name:
 |  |  |  | Brew Date:
 |  |  |  | Yeast Strain:
 |  |  |  | Yeast pitched @:
 |  | Original Brix *Note:  This calculator will not work without this information
 |  |  |  | 14
 |  | Observed Refractometer Readings | Temp. in 0F | Actual SG | Actual [NAME] | General Notes:
Date | Time | (Apparent Brix) | ([NAME] if your refractometer is equipped with ATC) | (Adjusted for effect of ethanol & temp) | (Adjusted for effect of ethanol & temp) | Daily Notes:
 |  | 7 |  | 1.01092868 | 2.789089953566133
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | * No Entry Assumes 60 0F
[NAME] |  | [NAME] ([NAME]) = -676.67 + 1286.4*SG - 800.47*(SG^2) + 190.74*(SG^3)
 |  | SG = 1.001843 - 0.002318474(OB) - 0.000007775(OB^2) - 0.000000034(OB^3) + 0.00574(AB) + 0.00003344(AB^2) + 0.000000086(AB^3)
 |  | where SG = Specific Gravity, OB = Original Brix, AB = Apparent [NAME] (Brix Readings During Fermentation)
Spreadsheet: 96712d1296037592-excel-2007-pivot-tables-combination-of-show-items-with-no-data-and-grouping-group-by-date-pivot_showitemswithnodate_vs_groupingdaterange
Sheet: STEP 3

Date | Summary |  |  |  | Count of Summary
2010-01-01 00:00:00 | Item 1 |  |  |  | Years | Date | Total
2010-03-01 00:00:00 | Item 2 |  |  |  | <1/01/2010 | <1/01/2010
2010-08-01 00:00:00 | Item 3 |  |  |  | 2010 | jan | 1
2010-10-01 00:00:00 | Item 4 |  |  |  |  | feb
2010-10-05 00:00:00 | Item 5 |  |  |  |  | mrt | 1
2010-12-01 00:00:00 | Item 6 |  |  |  |  | apr
2011-03-01 00:00:00 | Item 7 |  |  |  |  | mei
2011-08-01 00:00:00 | Item 8 |  |  |  |  | jun
 |  |  |  |  |  | jul
 |  |  |  |  |  | aug | 1
 |  |  |  |  |  | sep
 |  |  |  |  |  | okt | 2
 |  |  |  |  |  | nov
 |  |  |  |  |  | dec | 1
 |  |  |  |  | 2011 | jan
 |  |  |  |  |  | feb
 |  |  |  |  |  | mrt | 1
 |  |  |  |  |  | apr
 |  |  |  |  |  | mei
 |  |  |  |  |  | jun
 |  |  |  |  |  | jul
 |  |  |  |  |  | aug | 1
 |  |  |  |  |  | sep
 |  |  |  |  |  | okt
 |  |  |  |  |  | nov
 |  |  |  |  |  | dec
 |  |  |  |  | >2/08/2011 | >2/08/2011
 |  |  |  |  | Grand Total |  | 8
STEP 3 | Adding the option 'Show Items with No Data'
Spreadsheet: 732972d1621343733-extract-data-with-dependent-dropdown-from-multiple-tables-engine_workbook
Sheet: Engine B

 | level | type | components | description | quantity |  | level | type | components | description | quantity
 | 1 | Engine B | 10155419C | Ventildeckel 1270 | 1 |  | 1 | Engine B | 10154622B | Ventildeckel | 1
 | 1 | Engine B | 10155514A | Ventiltraeger -1270- | 1 |  | 1 | Engine B | 10655314A | Ventiltraeger | 1
 | 1 | Engine B | 10155441B | Dosiergehaeuse 1270 | 1 |  | 1 | Engine B | 10157876B | Dosiergehaeuse | 1
 | 1 | Engine B | 10152552E | Kalibrierschraube -1270- | 1 |  | 1 | Engine B | 10152552E | Kalibrierschraube | 1
 | 1 | Engine B | 10152539E | Blende -1270- | 1 |  | 1 | Engine B | 10152537E | Blende | 1
 | 1 | Engine B | 22150004D | Diffusor mit Heizung.-1270- | 1 |  | 1 | Engine B | 22150004D | Diffusor mit Heizung | 1
 | 2 | Engine B | 10153111B | Abdeckung -1270- | 1 |  | 2 | Engine B | 10153111B | [NAME] | 1
 | 2 | Engine B | 10153112F | Diffusor -1270- | 1 |  | 2 | Engine B | 10153112F | Diffusor | 1
 |  |  |  |  |  |  | 2 | Engine B | 08002155C | Spezifikation.Diffusor mit Heizung | 0
 |  |  |  |  |  |  | 1 | Engine B | 10182162B | Schutzfilter -1270- | 2
 |  |  |  |  |  |  | 1 | Engine B | 10153913B | Isolationshuelse mit.Blende -1270- | 1
Spreadsheet: 0a65a088-d5fb-4caf-917e-621b82ea1725
Sheet: Sheet1

1930 - 19th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Cleveland, Ohio, USA |  |  |  |  | 1930-09-01 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | USA | Orman | [NAME] | McCracken | [NAME] | Goodyear VIII | Norfolk/Massachusetts | 872 | 1900-01-01 03:56:00
2 | BEL | Demuyter | Ernest | [NAME] | [NAME] | Belgica | Adams/Massachusetts | 720
3 | USA | Hill | [NAME] | [NAME] | [NAME] | Detroit | Albany/New York | 671
4 | USA | Blair | [NAME] | Trotter | F.A. | Cleveland | Copenhagen/New York | 559
5 | GER | [NAME] | Dr. Hugo | Götze | [NAME] | Barmen | Pittsfield/New York | 551 | 19:00:00
6 | FRA | Boitard | [NAME] | Herbe | J. | [NAME] | Smithville/Ontario/Canada | 265
Spreadsheet: darrell_schoolcraft__7296__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2001-12-11 00:00:00
 |  |  | SoCal Gas Price |  | 2.525
 |  |  | San Juan Gas Price |  | 2.18
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 475 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 540 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 540 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 540 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 540 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 540 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 540 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 540 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 540 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 540 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 540 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 540 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 540 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 540 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 540 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 540 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 540 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 475 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 475 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 475 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 475 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 475 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 475 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 475 | 7
Spreadsheet: kate_symes__18085__Deal Correction 11-20
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2000-11-20 00:00:00 | 2000-11-20 00:00:00 | 2000-11-17 00:00:00 | STSW | TA | Houston | Prebon | Term: From one day to BOM | Computer defaults | 461779 | Palo Verde | BOM | On [NAME] | 25 | 115 | [NAME]
 | 2000-11-20 00:00:00 | 2000-11-20 00:00:00 | 2000-11-20 00:00:00 | STSW | TA | Houston | Bloomberg | Added broker name | TA | 463045 | Palo Verde | Z-00 | On [NAME] | 25 | 125 | Idaho
 | 2000-11-20 00:00:00 | 2000-11-20 00:00:00 | 11/21-22/00 | STSW | TA | Houston | APB | Term: From 11/21 to 11/21-22 | Changes in Deal Blotter didn't change in Deal Entry | 462956 | Palo Verde | 11/21-22/00 | On [NAME] | 25 | 178 | Pacificorp
 | 2000-11-20 00:00:00 | 2000-11-20 00:00:00 | 11/21-22/00 | STSW | TA | Houston | APB | Term: From 11/21 to 11/21-22 | Changes in Deal Blotter didn't change in Deal Entry | 462964 | Palo Verde | 11/21-22/00 | On [NAME] | 25 | 178 | Transalta
 | 2000-11-20 00:00:00 | 2000-11-20 00:00:00 | 11/21-22/00 | STSW | TA | Houston | APB | Term: From 11/21 to 11/21-22 | Changes in Deal Blotter didn't change in Deal Entry | 462956 | Palo Verde | 11/21-22/00 | On [NAME] | 25 | 179 | Sierra Pacific
 | 2000-11-20 00:00:00 | 2000-11-20 00:00:00 | 2000-11-14 00:00:00 | LTCA | BB | Houston | APB | Time zone: from PST to PDT | Time Zone defaulted incorrectly - Daylight Savings Time begins | 458406 | COB N/S | Q2'01 | [NAME] | 50 | 51 | Sacramento MUD
 | 2000-11-20 00:00:00 | 2000-11-20 00:00:00 | 2000-11-14 00:00:00 | LTCA | BB | Houston | APB | Time zone: from PST to PDT | Time Zone defaulted incorrectly - Daylight Savings Time begins | 458405 | COB N/S | Q2'01 | [NAME] | 50 | 50.95 | EES
Spreadsheet: 887795d1738122741-results-issue-with-sumif-and-int-functions-efsumif-and-int-bvj-
Sheet: Sheet1

 |  |  |  |  | cells custom number format - hh:[NAME] a/p
 |  |  |  |  | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30: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 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00 | 1900-01-01 00:30:00 | 1900-01-01 01:00:00 | 1900-01-01 01:30:00 | 1900-01-01 02:00:00 | 1900-01-01 02:30:00 | 1900-01-01 03:00:00 | 1900-01-01 03:30:00 | 1900-01-01 04:00:00 | 1900-01-01 04:30:00 | 1900-01-01 05:00:00 | 1900-01-01 05:30:00 | 1900-01-01 06:00:00
 |  | filter <100 applied
 | Column1 | Column2 | Column3
 | 5 | 1 |  |  | cells custom number format - h a/p
 | 5 | 1 |  |  | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30: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 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00 | 1900-01-01 00:30:00 | 1900-01-01 01:00:00 | 1900-01-01 01:30:00 | 1900-01-01 02:00:00 | 1900-01-01 02:30:00 | 1900-01-01 03:00:00 | 1900-01-01 03:30:00 | 1900-01-01 04:00:00 | 1900-01-01 04:30:00 | 1900-01-01 05:00:00 | 1900-01-01 05:30:00 | 1900-01-01 06:00:00
 | 5 | 1
 | 5 | 1
 | 5 | 1
 | 5 | 1
 | 5 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 0.5
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 1
 | 4 | 0.5
 | 4 | 0.5
 | 4 | 1
 | 3 | 0.5
 | 3 | 1
 | 3 | 1
 | 4 | 0.75
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 0.25
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 4 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 3 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 2 | 1
 | 3 | 1
 | 2 | 1
 | 1 | 1
 | 1 | 1
 | 1 | 1
 | 2 | 1
 | 2 | 1
 | 1 | 1
 | 1 | 1
 | 1 | 1
 | 1 | 1
 | 1 | 1
 | 1 | 1
Spreadsheet: 453973d1459544925-how-can-i-direct-excel-to-show-me-scenarios-example
Sheet: Sheet1

Players: |  | Group 1 | (note, it does not have to say Group 1, etc)
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | Eddie | Fred
[NAME] |  | Greg | [NAME]
Eddie |  | Ian | Jake
Fred
Greg
[NAME] |  | Group 2
Ian |  | [NAME] | [NAME]
Jake |  | [NAME] | Eddie
 |  | Fred | Greg
 |  | [NAME] | Ian
 |  | Jake | [NAME]
 |  | Group 3
 |  | [NAME] | [NAME]
 |  | [NAME] | Eddie
 |  | Fred | Greg
 |  | [NAME] | [NAME]
 |  | Jake | Ian
Spreadsheet: 698898d1602236599-filter-and-remove-in-the-list-parents-with-children
Sheet: Sheet1

no | STUDENT FIRST NAME | STUDENT LAST NAME | PARENT FIRST NAME (P) | PARENT LAST NAME (P) | FIRST NAME (S) | LAST NAME (S)
1 | [NAME] | Walter | Suhaylah | Samaki | Nadeem | Walter
2 | [NAME] | Walter | Suhaylah | Samaki | Nadeem | Walter
3 | Yoel | Wick | Rose | Rothbletz | Wick | [NAME]
4 | Salha | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
5 | Melvin | Jacson |  |  | Frantz | Jacson
6 | Hibiki | Hamza | Shino | Hamza | Kentaro | Hamza
7 | [NAME] | Kenge | Moza | Kenge | [NAME] | Kenge
8 | Nayyif | Kenge | Moza | Kenge | [NAME] | Kenge
9 | [NAME] | Ndege | [NAME] | Hasham | [NAME] | Ndege
10 | Abdelrahman | Nyoka | [NAME] | Nyokai | [NAME] | Nyoka
11 | Aiden | Panya | Sonya | Dinnendahl | Sameer | Panya
12 | Jwan | [NAME] | Amani | [NAME] | [NAME] | [NAME]
13 | Lamar | [NAME] | Amani | [NAME] | [NAME] | [NAME]
14 | [NAME] | [NAME] | [NAME] | Zero | [NAME] | [NAME]
15 | Haru | Kuku | [NAME] | Kuku | Hironobu | Kuku
16 | Yusei | Kuku | [NAME] | Kuku | Hironobu | Kuku
17 | Mikaeel | mkono | Mehtab | [NAME] | [NAME] | mkono
18 | Natalia | [NAME] | Renata | [NAME] | [NAME] | [NAME]
19 | Akosua | Nyarko van Hoorn | Ama | Nyarko van Hoorn | Kofi | Asante
20 | Jasper | Sanyo | [NAME] | Fimbo | Trond | Sanyo
21 | [NAME] | Vihemäki | [NAME] | Vihemäki | [NAME] | [NAME]
22 | [NAME] | mguu | Claudia | mguu | Stephen | mguu
23 | Naledi | mguu | Claudia | mguu | Stephen | mguu
24 | Sibylla | Karanga | Mikaela | Karanga | [NAME] | Karanga
25 | Soren | Karanga | Mikaela | Karanga | [NAME] | Karanga
26 | Frida | Karanga | Ulrika | Karanga | [NAME] | Karanga
Spreadsheet: 740721d1626498955-function-formula-to-populate-specific-number-test2
Sheet: Sheet1

[NAME] |  |  |  |  | Only even nos , Table B |  |  |  |  | Only odd nos, Table C
2 | 2 | 1 | 2122
1 | 122 | 11 | 2
2 | 21 | 11 | 12
2 | 1212 | 1 | 2
211 | 12 | 11
1221 | 211
121 | 22 | 11
 | 121 | 111 | 2
1 | 111 | 1 | 21
 | 11 | 111 | 22
221 | 12 | 11
11 | 122 | 11
[NAME] |  |  |  |  | Only even nos , Table B |  |  |  |  | Only odd nos, Table C
2 | 2 | 1 | 2122 |  | 2 | 2 |  | 222 |  |  |  | 1 | 1 |  | Objective
1 | 122 | 11 | 2 |  |  | 22 |  | 2 |  | 1 | 1 | 11 |  |  | From table A separate out  "2" & "1"  as in Tale B and C
2 | 21 | 11 | 12 |  | 2 | 2 |  | 2 |  |  | 1 | 11 | 1
2 | 1212 | 1 | 2 |  | 2 | 22 |  | 2 |  |  | 11 | 1
211 | 12 | 11 |  |  | 2 | 2 |  |  |  | 11 | 1 | 11 |  |  | Given
1221 | 211 |  |  |  | 22 | 2 |  |  |  | 11 | 11 |  |  |  | Table A has combinations of 1 & 2 numbers
121 | 22 | 11 |  |  | 2 | 22 |  |  |  | 11 |  | 11
 | 121 | 111 | 2 |  |  | 2 |  | 2 |  |  | 11 | 111
1 | 111 | 1 | 21 |  |  |  |  | 2 |  | 1 | 111 | 1 | 1
 | 11 | 111 | 22 |  |  |  |  | 22 |  |  | 11 | 111
221 | 12 | 11 |  |  | 22 | 2 |  |  |  | 1 | 1 | 11
11 | 122 | 11 |  |  |  | 22 |  |  |  | 11 | 1 | 11
Spreadsheet: 754954d1636590334-counting-cells-with-data-in-them-while-containing-a-formula-counting-data-in-cells
Sheet: Sheet1

 | List 2 |  |  |  |  |  |  |  |  | List 1
1 |  |  |  |  |  |  |  |  |  | 125.564
2 |  |  |  |  |  |  |  |  |  | 125-45-512
3 |  |  |  |  |  |  |  |  |  | 20-89-72
4 |  |  |  |  |  |  |  |  |  | 245555
5 |  |  |  |  |  |  |  |  |  | 25-2555-1
6 |  |  |  |  |  |  |  |  |  | 198214-5
7 |  |  |  |  |  |  |  |  |  | 1428-455-25
8 |  |  |  |  |  |  |  |  |  | 42668.4555
9 |  |  |  |  |  |  |  |  |  | 788526
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9908

August 1999 Transport Expense Flash
Company | Company Number |  | Commodity Expenses |  | Demand Charges |  | Payable To Pipeline | Contract Numbers
HPLC | 12 |  |  |  |  |  | Long term deal commodity expense on HPL |  | Intrazone
 |  |  |  |  |  |  |  |  | Accrual | 391000 | not included in this estimate - separate
HPLC | 12 |  | 6239.17 |  |  |  | Black Marlin | 96022051 | Interzone
HPLC | 12 |  | 4853.67 |  |  |  | Channel Industries Gas Co. | 96017259
HPLC | 12 |  | 3298.89 |  |  |  | Tejas Gas Operating, LLC | 96008850
ECT/Texas | 16 |  | 7887.44 |  |  |  | Northern Natural Gas/Black Marlin | 96020553
ECT/Texas | 16 |  | 99717 |  |  |  | Oasis Pipe Line Co. | 96015445/ 96016667/ 96019481/ 96019482
ECT/Texas | 16 |  | 440 |  |  |  | Pan Grande Pipeline, LLC | 96019628
ECT/Texas | 16 |  | 219214.28 |  |  |  | PG&E Texas Pipeline, L.P. | 96006479/ 96006482/ 96009903/ 96011842
 |  |  |  |  |  |  |  | 96016601
ECT/Texas | 16 |  |  |  | 93300 |  | Centana Storage Demand Charge | 96019236
ECT/Texas | 16 |  |  |  | 15000 |  | Tennessee/800 to HPL-Sabine Demand Charge - payable to East Desk
Totals
DEMAND CHARGE NOTES: |  |  |  | $15,000 demand charge is in line 25 of OA Flash Page
 |  |  |  | $93,300 demand charge is in line 36 of OA Flash Page
ISSUES: | CPR estimate does not tie with Unify actuals as of 8/2/99
NOTE: | Because Unify does not tie with CPR, and because Unify does not seem to have flashed all pipelines, we used CPR tickets to flash
Spreadsheet: 234384d1368086441-error-in-date-and-time-format-change
Sheet: Sheet1

Assigned Date (dd/mm/yy) | Start Time (hh:[NAME]: AM / PM) | Date Completed | End Time (hh:[NAME]: AM / PM)
41395 | 0.3993055555555556 | 41395 | 0.425
41395 | 0.4256944444444444 | 41395 | 0.4625
41395 | 0.4847222222222222 | 41395 | 0.5236111111111111
41395 | 0.5236111111111111 | 41395 | 0.5513888888888888
41395 | 0.5513888888888888 | 41395 | 0.5923611111111111
41395 | 0.5930555555555556 | 41395 | 0.6777777777777777
41395 | 0.6784722222222223 | 41395 | 0.7027777777777778
41396 | 0.3541666666666667 | 41396 | 0.375
41396 | 0.375 | 41396 | 0.3986111111111111
41396 | 0.3986111111111111 | 41396 | 0.4201388888888889
41396 | 0.4201388888888889 | 41396 | 0.4555555555555555
41396 | 0.4555555555555555 | 41396 | 0.5263888888888889
41396 | 0.5270833333333333 | 41396 | 0.5541666666666667
41396 | 0.5548611111111111 | 41396 | 0.5902777777777778
41396 | 0.5909722222222222 | 41396 | 0.6152777777777778
41396 | 0.6152777777777778 | 41396 | 0.65625
41396 | 0.6569444444444444 | 41396 | 0.6819444444444445
41396 | 0.6826388888888889 | 41402 | 0.7083333333333334
41401 | 0.3680555555555556 | 41401 | 0.4201388888888889
41401 | 0.4395833333333334 | 41401 | 0.5118055555555555
41401 | 0.5125000000000001 | 41401 | 0.5340277777777778
41401 | 0.5347222222222222 | 41401 | 0.5770833333333333
41401 | 0.5770833333333333 | 41401 | 0.6006944444444444
41401 | 0.6006944444444444 | 41401 | 0.6256944444444444
41401 | 0.6444444444444445 | 41401 | 0.6652777777777777
41401 | 0.6652777777777777 | 41401 | 0.6833333333333332
41401 | 0.6916666666666668 | 41401 | 0.6979166666666666
41401 | 0.3326388888888889 | 41402 | 0.3506944444444444
41402 | 0.3506944444444444 | 41402 | 0.3930555555555555
41402 | 0.3930555555555555 | 41402 | 0.41875
41402 | 0.41875 | 41402 | 0.4263888888888889
41402 | 0.5076388888888889 | 41402 | 0.5340277777777778
41402 | 0.4263888888888889 | 41402 | 0.4506944444444445
41402 | 0.4506944444444445 | 41402 | 0.50625
41402 | 0.5395833333333333 | 41402 | 0.5611111111111111
41402 | 0.5618055555555556 | 41402 | 0.5861111111111111
41402 | 0.5868055555555556 | 41402 | 0.6124999999999999
41402 | 0.6124999999999999 | 41402 | 0.6569444444444444
41402 | 0.6569444444444444 | 41402 | 0.6777777777777777
41402 | 0.6777777777777777 | 41402 | 0.7034722222222222
41403 | 0.3326388888888889 | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
41403 |  | 41403
Spreadsheet: 599796d1543316095-amend-a-formula-which-can-total-perfectly-semi-finished-domestic-stock-gk2-
Sheet: Pivot Table 1

QUALITY | MANUFACTURED | DESIGN NO. | COLOUR | ROLLS GIVEN PROCESSING | SUM of METER | SUM of 60" | SUM of 68" | SUM of 81 | SUM of 90*100 | SUM of 96*110 | SUM of 102*120 | SUM of 108 | SUM of 120*120 | SUM of PILLOW | SUM of CUSHION | SUM of BOOSTER
FEATHER |  |  |  |  | 433.5 |  |  |  | 143 |  |  |  |  | 270
ROMAN | NATRAJ HANDLOOM | 1 | KORA | 2121 | 52 | 16 |  |  |  |  |  |  |  |  | 75 | 30
 |  |  |  | 2125 | 78 |  |  |  | 25 |  |  |  |  | 50
 |  |  |  |  | 751 | 227 |  |  | 20 |  |  |  |  | 40 | 750 | 315
 |  |  |  | (blank) | 52 | 16 |  |  |  |  |  |  |  |  | 75 | 30
 |  |  | KORA Total |  | 933 | 259 |  |  | 45 |  |  |  |  | 90 | 900 | 375
 |  |  | MIX | 2140 | 52 | 16 |  |  |  |  |  |  |  |  | 75 | 30
 |  |  |  | 2152 | 31 |  |  |  | 10 |  |  |  |  | 20
 |  |  |  | 2154 | 46 |  |  |  | 15 |  |  |  |  | 30
 |  |  |  | 2155 | 46 |  |  |  | 15 |  |  |  |  | 30
 |  |  |  | 2162 | 61 |  |  |  | 20 |  |  |  |  | 40
 |  |  |  |  | 576.5 | 64 |  |  | 120 |  |  |  |  | 240 | 300 | 120
 |  |  | MIX Total |  | 812.5 | 80 |  |  | 180 |  |  |  |  | 360 | 375 | 150
 |  | 1 Total |  |  | 1745.5 | 339 |  |  | 225 |  |  |  |  | 450 | 1275 | 525
 | NATRAJ HANDLOOM Total |  |  |  | 1745.5 | 339 |  |  | 225 |  |  |  |  | 450 | 1275 | 525
ROMAN Total |  |  |  |  | 1745.5 | 339 |  |  | 225 |  |  |  |  | 450 | 1275 | 525
(blank)
Grand Total |  |  |  |  | 2179 | 339 |  |  | 368 |  |  |  |  | 720 | 1275 | 525
Spreadsheet: 849632d1700058540-i-forgot-how-to-rearrange-cells-book2_corti-aligw
Sheet: Sheet1

WHAT I HAVE
ID | identifier | GPBW | SOOP | TIV | X | FOTE | CIB | KP | KT
10 | C.acrifolius |  |  |  |  | FOTE 712
11 | C.acutispissipes |  |  |  |  |  | CIBI4 15-17, 161,162
12 | C.acutispissipes |  |  |  |  |  |  |  | KT 106
13 | C.acutispissipes |  | SOOP 64
14 | C.acutorum | GPBW5 196
15 | C.acutostriaculus |  |  | TIV 63
16 | C.acutovelatus | GPBW5 196
17 | C.acutovelatus |  | SOOP 101
WHAT I WANT TO HAVE
ID | identifier | GPBW | SOOP | TIV | X | FOTE | CIB | KP | KT
10 | C.acrifolius |  |  |  |  | FOTE 712
13 | C.acutispissipes |  | SOOP 64 |  |  |  | CIBI4 15-17, 161,162 |  | KT 106
14 | C.acutorum | GPBW5 196
15 | C.acutostriaculus |  |  | TIV 63
16 | C.acutovelatus | GPBW5 196 | SOOP 101
 | identifier | GPBW | SOOP | TIV | X | FOTE | CIB | KP | KT
10 | C.acrifolius |  |  |  |  | FOTE 712
11 | C.acutispissipes |  | SOOP 64 |  |  |  | CIBI4 15-17, 161,162 |  | KT 106
14 | C.acutorum
15 | C.acutostriaculus |  |  | TIV 63
16 | C.acutovelatus |  | SOOP 101
Spreadsheet: 65351d1266010004-payroll-calcualtions-nested-if-payroll-20help-1-
Sheet: Sheet1

 | Yale/Mercer | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec | FICA FF 7.15% | 09 Total
[NAME] | M | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2145 | 30000
[NAME] | Y | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 857.9999999999999 | 12000
[NAME] | Y | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2145 | 30000
[NAME] | M | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3003 | 42000
[NAME] | M | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1287 | 18000
Total |  | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 |  | 132000
Yale |  | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 |  | 42000
FICA | 0.0715 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 |  | 3003
Unemployment | 0.0057 | 0
L&I | 0.003474
Mercer |  | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 |  | 90000
FICA | 0.0715 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 |  | 6435
Unemplyoment | 0.0057 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75
L&I | 0.003445
Spreadsheet: 178997d1346977295-sorting-times-linked-with-two-other-data-entries-2-min-stagger
Sheet: Sheet1

Number | 2 Minute Stagger
 | Dose Time | 5 Min | 15 Min | 30 Min | 1 Hour | 2 Hour | 4 Hour | 8 Hour
1 | 08:00:00
2
3
4
5
6
7
8