tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851922d1702043594-formula-to-change-text-color-if-2-criteria-are-met-ticket-tracking-beamer
Sheet: Blank

 |  |  |  |  |  | ../../../../../../../MIMS%20Tracking%20Comments.xlsx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priority | Emergency
 | Ticket Number | Type of Ticket | Issue/Task Comment | Asset Category | Asset Names |  | Time Created | Ack By | Mobilization Time | Mobilization Time in days:hrs:min | Completion Time | Resolution Time in hrs:min:sec | Resolution Time in days:hrs:min | Completed Date | Solution | Avg. Priority [NAME] | Avg. Priority Resolution Time | Avg. Emergency Acknowledge Time | Avg. Emergency Resolution Time | Longest Priority Response Time | Longest Priority Resolution Time | Longest Emergency Response Time | Longest Emergency Resolution Time | "Priority" Over Allotted Acknowledge Time | Priority Over Allotted Resolution Time | "Emergency" Over Allotted Acknowledge Time | "Emergency" Over Allotted Resolution Time | Unresolved Priority Tickets | Unresolved Emergency Tickets
Spreadsheet: 772652d1647424241-use-a-formula-stated-in-a-different-cell-test1
Sheet: Sheet1

Supplier | Aldi |  |  |  |  |  | Supplier | Model
Model Used |  |  |  |  |  |  | M&S | 1
 |  |  |  |  |  |  | Tesco | 1
Val_Cost -> | 100 |  |  |  |  |  | Aldi | 1
[NAME] | 15 |  |  |  |  |  | Waitrose | 2
Val_Multiplier -> | 2.5 |  |  |  |  |  | Lidl | 3
VAT -> | 0.2
Val_Post -> | 5
Retail Price
Spreadsheet: theresa_staab__39608__north central purchase detail 2001
Sheet: July 01

North Central Oil | Contact: | [NAME] |  |  | Enron North America
 | PH: | (713) 268-4532
 | FAX: |  |  |  | [NAME] | PH:  [PHONE]
 | E-Mail: | [EMAIL] |  |  |  | FAX:  [PHONE]
July, 2001
First of Month Nomination: | 25840
Btu factor
Transportation | 0.14 | per [NAME] (25,000/d)
IF CIG Index | 1.75
 |  | Index Discount/Premium | Lost Creek Transport/MMBtu | Total Net Back
Net Backs: | CIG GD | 0.03 | -0.1460337
 | Firm Quantity | 0 | -0.1460337
 | IF CIG (90%) | 0.04 | -0.1460337
 |  | 90% of FOM Nom. Less Firm Quantity | 90% of FOM less Firm Quantity | Firm Quantity | Firm Quantity Volume MMBtu | GD Volume | CIG GD Volume MMBtu |  | Total Net Receipts MMBtu | $ CIG +.04 | $ [NAME] | $ CIG GD | Total Payment
 | CIG GD Rockies | IF CIG less Netback |  | CIG less Netback | 15000 | [NAME] less Netback
2001-07-01 00:00:00 | 1.935 |  |  |  |  |  |  |  | 25581.6
 | 1.935 |  |  |  |  |  |  |  | 25581.6
 | 2.135 |  |  |  |  |  |  |  | 24969.78
 | 2.015 |  |  |  |  |  |  |  | 24354.99
 | 2.015 |  |  |  |  |  |  |  | 24354.99
 | 2.235 |  |  |  |  |  |  |  | 24354.99
 | 2.155 |  |  |  |  |  |  |  | 24354.99
 | 2.155 |  |  |  |  |  |  |  | 24354.99
 | 2.155 |  |  |  |  |  |  |  | 24354.99
 | 2.29 |  |  |  |  |  |  |  | 23986.71
 | 2.405 |  |  |  |  |  |  |  | 23986.71
 | 2.455 |  |  |  |  |  |  |  | 23495.67
 | 2.55 |  |  |  |  |  |  |  | 23372.91
 | 2.285 |  |  |  |  |  |  |  | 23372.91
 | 2.285 |  |  |  |  |  |  |  | 23372.91
 | 2.285 |  |  |  |  |  |  |  | 23372.91
 | 2.275 |  |  |  |  |  |  |  | 23372.91
 | 2.295 |  |  |  |  |  |  |  | 23372.91
 | 2.23 |  |  |  |  |  |  |  | 23372.91
 | 2.135 |  |  |  |  |  |  |  | 23372.91
 | 1.985 |  |  |  |  |  |  |  | 23372.91
 | 1.985 |  |  |  |  |  |  |  | 23372.91
 | 1.985 |  |  |  |  |  |  |  | 23372.91
 | 2.215 |  |  |  |  |  |  |  | 23372.91
 | 2.17 |  |  |  |  |  |  |  | 24110.46
 | 2.225 |  |  |  |  |  |  |  | 24110.46
 | 2.36 |  |  |  |  |  |  |  | 24110.46
 | 2.125 |  |  |  |  |  |  |  | 24110.46
 | 2.125 |  |  |  |  |  |  |  | 24110.46
 | 2.125 |  |  |  |  |  |  |  | 24110.46
 | 2.52 |  |  |  |  |  |  |  | 24110.46
 |  |  |  |  |  |  |  |  | avg. $/MMBtu
Spreadsheet: darrell_schoolcraft__7213__saledoc10_3TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2001-10-17 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 10/18/01-10/19/01 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | El Paso Perm Gas Daily
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
10/18/01 | 10/19/01 | 20000 |  | 10000 |  | 10000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58646 |  | 10000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 272314d1382354737-if-and-fill-in-one-table-2nd-table-will-be-filled-in-automatically-example-expenses2
Sheet: Sheet1

Date | Category | Person | Supplier | Item | PO nr | [NAME] | Tin | Amount | VAT (18%) | Net
2013-01-11 00:00:00 | Food2 | [NAME] | [NAME] | [NAME] | 233 | september | 12 | 300 | 54 | 246
2013-01-11 00:00:00 | shop1 | [NAME] | unknown | clothes | 27 | non | 0 | 0 | 0 | 0
2013-01-12 00:00:00 | cig 1 | you | me | cigar | 48 | unhealth | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | Values
Category | Date | Person | Supplier | Item | PO nr | [NAME] | Tin | Amount | VAT (18%) | Net | Sum of Amount | Sum of VAT (18%) | Sum of Net
cig 1 | 2013-01-12 00:00:00 | you | me | cigar | 48 | unhealth | 0 | 0 | 0 | 0 | 0 | 0 | 0
Food2 | 2013-01-11 00:00:00 | [NAME] | [NAME] | [NAME] | 233 | september | 12 | 300 | 54 | 246 | 300 | 54 | 246
shop1 | 2013-01-11 00:00:00 | [NAME] | unknown | clothes | 27 | non | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total |  |  |  |  |  |  |  |  |  |  | 300 | 54 | 246
Spreadsheet: 686152d1594390969-count-base-hours-for-attendance-report-attendance-record-1-
Sheet: John Doe

[NAME]
Dt | Day | Check In | Check Out | Shift | Ttl Work Hours | Base Hours | Overtime |  | Schedule
1 | [NAME] | 08:58:00 | 15:32:00
2 | Kamis |  |  |  |  |  |  |  | Monday – Thursday
3 | Jumat | 14:55:00 | 21:33:00 |  |  |  |  |  | S1 | 09:00 – 15:30 | 6.5 | hours
4 | Sabtu | 09:01:00 | 15:31:00 |  |  |  |  |  | MD | 12:00 – 18:00 | 6 | hours
5 | Minggu | 14:57:00 | 21:34:00 |  |  |  |  |  | S2 | 15:00 – 20:30 | 5 | hours
6 | Senin | 11:50:00 | 18:05:00
7 | Selasa | 09:02:00 | 15:32:00 |  |  |  |  |  | Friday – Sunday
8 | [NAME] | 14:56:00 | 20:35:00 |  |  |  |  |  | S1 | 09:00 – 15:30 | 6.5 | hours
9 | Kamis | 08:59:00 | 15:30:00 |  |  |  |  |  | MD | 13:00 – 19:00 | 6 | hours
10 | Jumat |  |  |  |  |  |  |  | S2 | 15:00 – 21:30 | 6.5 | hours
11 | Sabtu
12 | Minggu
13 | Senin
14 | Selasa
15 | [NAME]
16 | Kamis
17 | Jumat
18 | Sabtu
19 | Minggu
20 | Senin
21 | Selasa
22 | [NAME]
23 | Kamis
24 | Jumat
25 | Sabtu
26 | Minggu
27 | Senin
28 | Selasa
29 | [NAME]
30 | Kamis
31 | Jumat
Spreadsheet: 732683d1621158099-count-days-from-today-until-text-in-adjacent-cell-changes-book22
Sheet: Ark1

Origin | Destination | Date
Mallorca | New York | 2021-05-05 00:00:00 |  | I'm looking for a formula that count the days from today() and until the 'Destination' text changes.
New York | New York | 2021-05-06 00:00:00
New York | New York | 2021-05-07 00:00:00
New York | New York | 2021-05-08 00:00:00
New York | New York | 2021-05-09 00:00:00
New York | New York | 2021-05-10 00:00:00
New York | London | 2021-05-11 00:00:00
London | London | 2021-05-12 00:00:00
London | London | 2021-05-13 00:00:00
London | London | 2021-05-14 00:00:00 |  | Ideal result:
London | London | 2021-05-15 00:00:00 |  | Time until next destination
London | São Paulo | 2021-05-16 00:00:00 | ------ | 4
São Paulo | São Paulo | 2021-05-17 00:00:00
São Paulo | São Paulo | 2021-05-18 00:00:00
São Paulo | São Paulo | 2021-05-19 00:00:00
São Paulo | Hawaii | 2021-05-20 00:00:00 | <-----
Hawaii | Hawaii | 2021-05-21 00:00:00
Hawaii | Hawaii | 2021-05-22 00:00:00
Hawaii | Hawaii | 2021-05-23 00:00:00
 |  | 2021-05-24 00:00:00
 |  | 2021-05-25 00:00:00
Spreadsheet: 0050710e-be3b-45d7-8838-6c960e8dfec1
Sheet: Labor-Task

Advertising and Integrated Marketing Solutions (AIMS )                                          Solicitation 7FCB-H2-07-0541-B                                                                       Page 1 of 4
Schedule 541 - Proposal Price List Preparation Spreadsheet (Labor/Task)
[NAME]:
Labor/Task Pricing
SIN(s) PROPOSED | SERVICE PROPOSED (e.g. Job Title/Task) | COMMERCIAL PRICE LIST (CPL) OR MARKET PRICES | UNIT OF ISSUE (e.g. Hour, Task, Sq ft) | MOST FAVORED CUSTOMER (MFC) | DISCOUNT OFFERED TO MFC (%) | MFC PRICE | DISCOUNT OFFERED TO GSA (off CPL or Market Prices) (%) | PRICE OFFERED TO GSA (excluding IFF) | PRICE OFFERED TO GSA (including IFF) | SUPPORTING INVOICE NUMBER
541-1 | Project Mgr | 150 | Hourly | All Commercial Customers | 0.05 |  | 0.1 |  |  | 123456
Note: The table above is an example, for further instructions, see tab: |  |  |  | Enclosure A
Spreadsheet: 768045d1644809609-transform-raw-data-want-raw-data-to-be-show-as-tableau-transform
Sheet: Sheet1

Raw Data |  |  |  |  |  |  |  | What I wat
Date | Customer | Payment | Deposit |  |  |  |  | Date | Customer | Reference | Payment | Deposit
2022-01-01 00:00:00 | [NAME] | 1000 |  |  |  |  |  | 2022-01-01 00:00:00 | [NAME] | 0016RF2032331804 | 1000
Edit | 0016RF2032331804 |  |  |  |  |  |  | 2022-01-01 00:00:00 | [NAME] | ZZ0016SW282712 |  | 3000
2022-01-01 00:00:00 | [NAME] |  | 3000 |  |  |  |  | 2022-01-01 00:00:00 | Crystal | 0016SW2208199112111 | 1100
Edit | ZZ0016SW282712 |  |  |  |  |  |  | 2022-01-01 00:00:00 | Leiny | 0016RF20819MMA | 1919
2022-01-01 00:00:00 | Crystal | 1100 |  |  |  |  |  | 2022-01-02 00:00:00 | Cherbelle | 0016RF2032338881 |  | 90
Edit | 0016SW2208199112111
2022-01-01 00:00:00 | Leiny | 1919
Edit | 0016RF20819MMA
2022-01-02 00:00:00 | Cherbelle |  | 90
Edit | 0016RF2032338881
Spreadsheet: 104706d1302196406-consolidate-duplicate-rows-into-one-cell-test-success
Sheet: copy into original 2

number | first | last | original price
650001 | bob | masters | 100
650002 | [NAME] | pho | 50
650003 | dwayne | green | 25
650003 | dwayne | green | 15
650004 | [NAME] | shane | 35
650005 | bob | molloy | 45
650006 | karen | [NAME] | 75
650006 | karen | [NAME] | 100
650006 | karen | [NAME] | 250
650006 | karen | [NAME] | 500
Spreadsheet: 150583d1334608456-combining-several-worksheets-into-one-invoices
Sheet: dAlbenas BAH

 |  |  |  |  |  | XXXXX Latin America
 |  |  |  |  |  | 355 Alhambra Circle
 |  |  |  |  |  | Suite 1400
April 6, 2012 |  |  |  |  |  | Coral Gables, FL  33134
Ref. No.: | 060412- | E
Freight Forwarder: |  |  |  |  | Ship To:
TROPICAL SHIPPING |  |  |  |  | D’ALBENAS AGENCIES
9505 NW 108TH |  |  |  |  | MADEIRA STREET
MEDLEY, FL  33178 |  |  |  |  | NASSAU
 |  |  |  |  | BAHAMAS
ATTN: TEAM 3 - D'ALBENAS BAHAMAS
TELE: (305) 805-7472 |  |  |  |  | ATTN: [NAME]
 |  |  |  |  | TELE: (242) 677-1456
Boxes | SKU | Description |  |  |  | Value | TOTAL US$
20 | 97215 | [NAME] (5/carton) |  |  |  | 3.5
5 | 93031 | [NAME] |  |  |  | 55
20 | 93032 | XXXXX Plastic Rolling Rack |  |  |  | 30.33333333333333
5 | 97015 | 1 Wide Pie Crust Rack |  |  |  | 3
2 | 97753 | Small [NAME] (5/carton) |  |  |  | 2.5
5 | 97440 | Mini Folding Wire Weekender |  |  |  | 43.33333333333334
12 | 97576 | On - The - Go Stackable Baskets |  |  |  | 28.66666666666667
5 | 97488 | Easy Cheese Hanging Merchandiser |  |  |  | 10.66666666666667
5 | 97494 | XXXXX Cheese Cooler/ [NAME] |  |  |  | 10
1 | 92022 | New Universal End Cap |  |  |  | 363.3333333333333
10 | 97499 | Toasted Chips Shelf Organizer |  |  |  | 9.666666666666666
5 | 90179 | Oreo 100th Birthday Inflatable Cake |  |  |  | 4
10 | 90182 | Oreo 100th Birthday Pennants |  |  |  | 3
 | TOTAL |  |  |  |  | TOTAL
 | [NAME]
Spreadsheet: chris_stokley__3917__0201 PGES2
Sheet: ECT

 | EPMI Charges To ECT
 | Trans Type | (CAISO 0601 A)
 | ID | (All)
 |  |  |  |  |  |  |  |  | MrktDt | (All)
 |  | Data |  |  |  |  |  |  | SchedType | (All)
 | Customer | Exp | Rev | Charge | Volume |  |  |  | ID | (All)
 | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  | Data
 |  |  |  |  |  |  |  |  | Customer | Location | TO | Charge | Rate | Volume | FTR %
 |  |  |  |  |  |  |  |  | PGES | All | SP15 | 11206.25 | 0 | -79.73 | 0
 |  |  |  |  |  |  |  |  |  |  | All | -66880.44320000007 | 0 | -901313.9871997783 | 0
 |  |  |  |  |  |  |  |  |  |  | NP15 | 17162.29 | 0 | -130.67 | 0
 |  |  |  |  |  |  |  |  |  |  | HUMB | 34.69 | 0 | -0.08 | 0
 |  |  |  |  |  |  |  |  |  |  | SF | 18743.23 | 0 | -50.18 | 0
 |  |  |  |  |  |  |  |  |  |  | ZP26 | -3.48 | 0 | 1.97 | 0
 |  |  |  |  |  |  |  |  | PGES Total |  |  | -19737.46320000001 | 0 | -901572.6771997786 | 0
 |  |  |  |  |  |  |  |  | Grand Total |  |  | -19737.46320000001 | 0 | -901572.6771997786 | 0
Spreadsheet: 838582d1691152802-maximum-drawdown-in-percentage-max-dd-aligw
Sheet: Sheet1

Total R2 | [NAME] DD%
-0.005
-0.01
0
0.01
0.005
0.015
0.025
0.035
0.04500000000000001
0.02
0.01
0.0655
Spreadsheet: 476192d1471673155-calculating-percentage-between-dates-with-starting-and-ending-percent-discounts
Sheet: Sheet1

Day |  | Discount
2016-08-01 00:00:00 |  |  |  | Start | 2016-08-01 00:00:00
 |  |  |  | End | 2017-02-28 00:00:00
Spreadsheet: 52909d1252767967-annual-leave-entitlement-that-resets-to-original-number-after-passing-year-leaves
Sheet: August Schedule

 | Public Holidays |  | Dates
 | New Year's Day |  | 2009-01-01 00:00:00
 | Chinese New Year |  | 2009-02-26 00:00:00
 |  |  | 2009-02-27 00:00:00
 | Good Friday |  | 2009-04-10 00:00:00
 | Labour Day |  | 2009-05-01 00:00:00
 | [NAME] |  | 2009-05-09 00:00:00
 | National Day |  | 2009-08-09 00:00:00
 | [NAME] |  | 2009-09-20 00:00:00
 | Deepavali |  | 2009-10-17 00:00:00
 | [NAME] |  | 2009-11-27 00:00:00
 | Christmas Day |  | 2009-12-25 00:00:00
 | The anchor date defines at what date the shift pattern starts.
 | you can change it to any other date if you want. Just make sure your shift patterns are adjusted to that date,
anchor date >>> | 2009-08-01 00:00:00 | team1 | team 2 | team3 | team4
first shift | 1 | O | W | N | D
second shift | 2 | O | R | N | D
third shift | 3 | D | O | W | N
etc | 4 | D | O | R | N
 | 5 | N | D | O | W
 | 6 | N | D | O | R
 | 7 | W | N | D | O
 | 8 | R | N | D | O
Spreadsheet: 853875d1703836964-need-to-get-updated-the-workbook-by-update-one-function-inventory
Sheet: NEW INVENTORY

 | INVOICES |  |  |  |  | SHOP1 |  |  |  |  | SHOP2 |  |  |  |  |  | INVENTORY IN SHOP1 AND SHOP2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHOP | (Όλα)
 | ΣΚΦ | Στήλη1 | ΦΑΙΔΡΑ |  | UNIT PRICE | CODE | [NAME] | QUANTITY |  | UNIT PRICE | CODE | [NAME] | QUANTITY |  | UNIT PRICE | CODE | [NAME] | QUANTITY SHOP 1 | QUANTITY SHOP 2 | TOTAL QUANTITY |  |  | [NAME] | TOTAL QUANTITY
 | 0 |  | 0 |  | 0.5 | 5 | ITEM1 | 13 |  | 0.5 | 5 | ITEM1 | 16 |  |  |  | 5 | IS NOT IN SHOP1 | IS NOT IN SHOP2 | 0 |  |  | 0 | 0
 |  |  |  |  | 0.65 | 6 | ITEM2 | 20 |  | 0.5 | 8 | ITEM8 | 12 |  |  | 0.5 | 7 | IS NOT IN SHOP1 | IS NOT IN SHOP2 | 0 |  |  | TOTAL | 0
 |  |  |  |  | 0.5 | 7 | ITEM3 | 25 |  |  |  |  |  |  |  | 0.5 | 8 | IS NOT IN SHOP1 | IS NOT IN SHOP2 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.65 | 6 | IS NOT IN SHOP1 | IS NOT IN SHOP2 | 0
Spreadsheet: 860ddda7-06d1-4c7d-80d8-ef68d12cd297
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Rhino | 81227997472 | [NAME] | Follow The Star | 2007-07-24 | Compact Disc | Gospel | 16.99 | Y | While Supplies Last
Rhino | 603497990849 | [NAME] | Wing And A Prayer, A | 2007-11-13 | Music DVD | Gospel | 19.98 | Y | While Supplies Last
Spreadsheet: 213325d1360440986-have-to-get-about-15000-records-sorted-help-book1
Sheet: this is how i need it

Product id | voltage | height | speed | color | speed | hight | amps | voltage | weight
k1001 | 12 v | 30cm | 20 | green | 20 |  |  | 12 v
k1052 |  |  | 35 |  | 35 | 21cm
[NAME] | 15 |  |  |  |  |  | 4 | 15 | 13kg
i depends on the which product id it is which spec is given.
so when is no spec available it just needs to let it blank
Spreadsheet: 822596d1679432466-golf-gross-and-net-plus-skin-calculation-kga-golf-tournament-gross-and-net-ranking-plus-skins
Sheet: Normal

PLAYER NAMES (KEEP TEAM NAMES TOGETHER) | PLAYER CH | PAYOUT PLAYERS (X) | HANDICAP | HELPER (XX) | STROKE INDEX | 9 | 5 | 7 | 13 | 11 | 1 | 17 | 15 | 3 |  | SKIN (SINGLE)   X | 10 | 4 | 8 | 18 | 2 | 14 | 16 | 6 | 12 |  | GROSS | TOP RANK GROSS | NET | TOP RANK NET
 |  |  |  |  | PAR | 4 | 5 | 4 | 5 | 3 | 4 | 3 | 4 | 4 |  |  | 4 | 4 | 4 | 3 | 5 | 4 | 3 | 5 | 4
 |  |  |  |  | HOLE NUMER | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 |  |  | #10 | #11 | #12 | #13 | #14 | #15 | #16 | #17 | #18
LENG | 10 | X |  |  |  | 4 | 5 | 6 | 7 | 6 | 7 | 3 | 6 | 6 |  | X | 6 | 6 | 6 | 3 | 7 | 7 | 7 | 6 | 5
RITY | 15 | X |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 3 | 5 | 6 |  | X | 5 | 7 | 4 | 3 | 6 | 6 | 5 | 6 | 5
KAM | 2 |  |  |  |  | 6 | 6 | 6 | 6 | 3 | 4 | 4 | 5 | 6 |  | X | 4 | 6 | 4 | 3 | 5 | 7 | 2 | 5 | 5
LA | 6 | X |  |  |  | 5 | 8 | 11 | 10 | 6 | 9 | 6 | 6 | 8 |  |  | 7 | 9 | 8 | 5 | 11 | 10 | 7 | 8 | 7
HOWIE | 8 | X |  |  |  | 5 | 5 | 4 | 6 | 5 | 7 | 3 | 4 | 8 |  |  | 7 | 4 | 7 | 2 | 5 | 4 | 4 | 7 | 4
BUUN | 12 |  |  |  |  | 4 | 6 | 5 | 6 | 3 | 5 | 2 | 6 | 4 |  | X | 4 | 6 | 5 | 3 | 5 | 7 | 3 | 6 | 5
PHILLIP | 7 | X |  |  |  | 5 | 5 | 5 | 6 | 3 | 6 | 5 | 6 | 5 |  |  | 4 | 5 | 5 | 3 | 6 | 5 | 4 | 5 | 6
GOSALL | 9 | X |  |  |  | 8 | 5 | 4 | 7 | 3 | 6 | 3 | 4 | 7 |  | X | 5 | 6 | 7 | 3 | 7 | 5 | 3 | 7 | 4
AL | 12 |  |  |  |  | 5 | 6 | 5 | 5 | 4 | 6 | 5 | 4 | 9 |  | X | 5 | 5 | 6 | 2 | 6 | 6 | 4 | 5 | 6
ARNY | 11 | X |  |  |  | 5 | 6 | 6 | 8 | 4 | 5 | 4 | 4 | 5 |  |  | 5 | 5 | 5 | 3 | 4 | 5 | 3 | 7 | 5
CHAI | 20 | X |  |  |  | 5 | 7 | 6 | 8 | 5 | 5 | 4 | 4 | 4 |  | X | 4 | 4 | 5 | 5 | 7 | 9 | 4 | 5 | 4
KO | 15 | X |  |  |  | 7 | 7 | 6 | 8 | 6 | 7 | 7 | 6 | 7 |  | X | 3 | 7 | 7 | 5 | 7 | 7 | 5 | 7 | 7
SAN | 10 |  |  |  |  | 4 | 5 | 5 | 5 | 3 | 5 | 4 | 4 | 5 |  | X | 4 | 5 | 3 | 3 | 6 | 6 | 2 | 5 | 4
SB | 8 |  |  |  |  | 6 | 6 | 5 | 7 | 4 | 4 | 5 | 5 | 6 |  |  | 5 | 6 | 6 | 4 | 6 | 5 | 5 | 7 | 5
MATTHEW | 7 |  |  |  |  | 3 | 6 | 5 | 7 | 5 | 7 | 7 | 4 | 2 |  | X | 6 | 4 | 4 | 3 | 5 | 8 | 3 | 7 | 5
Spreadsheet: daren_farmer__5650__HPL-Jan
Sheet: Jan 01

 |  | Reliant Energy - Entex
 |  | Enron Capital &  Trade/Houston Pipe Line
 |  | MONTHLY NOMINATION SUMMARY
 |  |  | From |  | Month to Date
Gas Flow Day |  | [NAME]. | 2001-01-01 00:00:00
Houston Pipe Line
982000 |  | HPL  Points | 325000
981326 | Industrial Tier 1 & 2 | Enterprise | 2000
981195 | Industrial Tier 1 & 2 | Huntsman East | 4000
981258 | Industrial Tier 1 & 2 | LUFKIN CHAMPION
981279, 981280, 981293 | Lufkin/Diboll- Temple Inland
980073 | Huntv,Woodls,[NAME]
Total HPL
Midcon |  |  | 75000
Total  Midcon
NGPL Spring City Gate |  |  | 2000
Total  NGPL
PAYBACK |  |  | 0
Total Available
Allocated as Follows:
Residential
012-41991-301 | 91% Domestic | HPL 76 | 910
016-41991-301 | Transactions 2-5,7 | ECT Trans # 1
016-41991-313 | Contract terminated 07/31/00 | NGMS 308 | 0
016-41991-306 | Trans 6- Silsbee |  | 250
016-41991-301 | Trans 10 [NAME]. | Lufkin Diboll | 0
 | Subtotal
016-41991-301 | Transaction 1 - Overflow | ECT Trans # 1
Total Residential
Industrial
012-41991-301 | 9% Industrial | HPL 76 | 90
016-41991-311 | Terminated 12/31/99 | CNG | 0
016-41991-306 | Trans 6 -Tier 1 - Entex | Tier 1 | 21000
016-91000-303 | Trans 6 -Tier 1 - Unit | Tier 1
016-41991-306 | Trans 6 -Tier 2 - Entex | [NAME] | 7000
016-91000-303 | Trans 6 - Tier 2  - Unit | [NAME] | 500
016-41991-306 | VA Hospital - Terminated 07/31/00 | VA Hosp | 0
Total Industrial at meter 2000
016-91000-301 | existing | NSS/Vidor | 4000
016-41991-306 | [NAME]. | Lufkin Diboll | 8000
016-41991-312 | [NAME]. | Temple Inland | 2800
Total Industrial not at meter 2000
Total Industrial
Huntsville/Woodlands/Conroe
016-41991-301 | Trans 6 -Huntsville |  | 4000
016-41991-301 | Trans 9 -Woodlands |  | 18000
016-41991-301 | Trans 8 - Conroe |  | 12000
Total H/W/C
Transportation
012-41991-204 |  | IT | 0
012-41991-203 |  | Firm Trsp | 10000
Total Transportation
Total Allocated
Check Available = Allocated
Transport Receipts |  | [NAME]
012-41991-203 | TEJAS THOMPSONVILLE From PanCanadian | 6351 | 10000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 5000
012-41991-203 | TEJAS THOMPSONVILLE | 6351 | 10000
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: Apr

 | TLR Max Level | Number of Incidents
 | 1 | 0
 | 2a | 4
 | 2b | 13
 | 2c | 0
 | 3 | 3
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | Total
 | Curtailment | TLR level | MW Curtailed | Controller | Start Time | End Time | Total Time
1 | 1999-04-21 00:00:00 | 3 | 29 | MAIN | 05:40:00 | 23:00:00
1 | 1999-04-28 00:00:00 | 3 | 300 | SPP | 16:20:00 | 18:10:00
Spreadsheet: 739547d1625765288-show-corresponding-cell-data-blank-cells-calculating
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4 | Year to date
 |  |  | 467301.72 | 509420.55 |  |  | 532594.79 | (This equal E4 if F4 and G4 is blank)
 |  |  | 265414.76 | 265414.76 |  |  | 265414.76 | (This equal E4 if F4 and G4 is blank)
 |  |  | Q1 | Q2 | Q3 | Q4 | Year to date
 |  |  | 467301.72 | 509420.55 | 551539.38 |  |  | (This equal F4 if G4 is blank)
 |  |  | 265414.76 | 265414.76 | 265414.76 |  |  | (This equal F4 if G4 is blank)
Spreadsheet: 54494d1254478269-need-some-help-with-ranges-701402-need-some-help-with-ranges
Sheet: Master

Enter Item & Quantity
Item # | Qty | Sub Total
Item-2 | 2 | 21.5138 | stanley's
Item-4 | 1 | 35.3695 | teylyn
Item-4 | 1 | 35.3695 | teylyn
Item-6 | 2 | 49.3014 | teylyn
Item-1 | 1 | 16.4338 | stanley's
Item-2 | 1 | 10.7569 | teylyn
Item-3 | 1 | 21.4757 | stanley's
Item-4 | 1 | 35.3695 | teylyn
Item-5 | 1 | 8.0391 | stanley's
Item-6 | 1 | 24.6507 | teylyn
Total Sale |  | 258.2799
As you see, I entered C5 and C6 manually…I need the spreadsheet to go find Item-2 (A5) on
Inventory and multiply it times B5, with the result in C5.  Same with any entry in "A" column.
Spreadsheet: 745097d1629745015-index-and-small-functions-to-chart-only-selected-data-index
Sheet: work (2)

No | Quarter | [NAME] | COO | CR | EP | IT | LST | LSM | MS
3
 | Applies
 | Column | C | D | E | F | G | H | I | J
 | Dept
 | Categories | c | e | j
 | Chart Data | 3 | 5 | 10
No | Quarter | [NAME] | COO | CR | EP | IT | LST | LSM | MS
1 | 2023 3Q | 6
2 | 2024 1Q | 2 |  | 16 |  |  |  | 7
3 | 2024 3Q | 1 |  | 5 |  |  |  |  | 1
4 | 2024 4Q | 2
5 | 2026 1Q | 7 | 6 | 14 |  |  | 3 | 7 | 13
6 | 2026 2Q | 4 |  | 22 | 1 |  | 26
7 | 2026 3Q | 6 |  |  |  | 1 | 9
 | Grand Total | 28 | 6 | 57 | 1 | 1 | 38 | 14 | 14