tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766203d1643797866-count-across-multiple-columns-with-multiple-criteria-example-1-
Sheet: Sheet1

jan |  |  |  | feb |  |  |  | march |  |  |  | april |  |  |  | april
Name | sale | percentage | membership | Name | sale | percentage | membership | Name | sale | percentage | membership | Name | sale | percentage | membership | Name | sale | percentage | membership
[NAME] | 5 | 5 | y | jasmine | 5 | 5 | y | mary | 5 | 5 | y | jasmine | 5 | 5 | y | jasmine | 5 | 5 | y
jasmine | 10 | 10 |  | [NAME] | 10 | 10 |  | mary | 10 | 10 |  | jasmine | 10 | 10 | y | jasmine | 10 | 10
jasmine | 15 | 15 |  | mary | 15 | 15 |  | mary | 15 | 15 |  | jasmine | 15 | 25 |  | mary | 15 | 15 | y
jasmine | 20 | 20 |  | mary | 20 | 20 |  | mary | 20 | 20 |  | jasmine | 20 | 20 |  | [NAME] | 20 | 20
jasmine | 25 | 25 |  | mary | 25 | 25 | y | mary | 25 | 25 |  | jasmine | 25 | 25 |  | [NAME] | 25 | 90
jasmine | 25 | 30 | y | mary | 25 | 30 | y | mary | 25 | 75 | y | mary | 25 | 30 | y | [NAME] | 25 | 95 | y
[NAME] | 25 | 35 |  | [NAME] | 25 | 35 |  | [NAME] | 25 | 35 |  | [NAME] | 25 | 35 |  | mary | 25 | 35
[NAME] | 15 | 45 |  | [NAME] | 15 | 45 |  | [NAME] | 15 | 45 | y | [NAME] | 15 | 45 |  | mary | 15 | 45
[NAME] | 20 | 50 |  | [NAME] | 20 | 50 |  | [NAME] | 20 | 50 |  | [NAME] | 20 | 50 |  | [NAME] | 20 | 50
[NAME] | 15 | 60 |  | mary | 15 | 60 |  | mary | 15 | 60 | y | mary | 15 | 60 | y | [NAME] | 15 | 60
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 25
 |  |  |  |  |  |  | 30
 |  |  |  |  |  |  | 35
 |  |  |  |  |  |  | 40
 |  |  |  |  |  |  | 45
 |  |  |  |  |  |  | 50
 |  |  |  |  |  |  | 55
 |  |  |  |  |  |  | 60
 |  |  |  |  |  |  | 65
 |  |  |  |  |  |  | 70
 |  |  |  |  |  |  | 75
 |  |  |  |  |  |  | 80
 |  |  |  |  |  |  | 85
 |  |  |  |  |  |  | 90
 |  |  |  |  |  |  | 95
 |  |  |  |  |  |  | 100
Spreadsheet: 92120d1291780219-excel-2007-formula-for-extraction-of-text-in-bracket-extraction-of-text-in-brackets
Sheet: Sheet1

Question 1 |  |  |  | Question 2
Original Data | Desire Outcome |  |  | Original Data | Desire Outcome (1) | Desire Outcome (2)
AM CO -  Corp (Z-XXX-AM_CO) | Z-XXX-AM_CO |  |  | Enter Vendor Invoice (F-43)  and   Void Checks (FCH3) | F-43 | FCH3
AM COMMON -  Corp (Z-XXX-AM_COMMON) | Z-XXX-AM_COMMON |  |  | Automatic Clearing without Currency (F.13)  and   Void Checks (FCH3) | F.13 | FCH3
AM FO -  Corp (Z-XXX-AM_FO) | Z-XXX-AM_FO |  |  | Change Document (FB02)  and   Void Checks (FCH3) | FB02 | FCH3
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (4)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
4.01
4.02
4.03
4.04 |  |  |  |  |  |  |  |  |  | 0
4.05 |  |  |  |  |  |  |  |  |  | 0
4.06 |  |  |  |  |  |  |  |  |  | 0
4.07 |  |  |  |  |  |  |  |  |  | 0
4.08 |  |  |  |  |  |  |  |  |  | 0
4.09 |  |  |  |  |  |  |  |  |  | 0
4.1 |  |  |  |  |  |  |  |  |  | 0
4.11 |  |  |  |  |  |  |  |  |  | 0
4.12 |  |  |  |  |  |  |  |  |  | 0
4.13 |  |  |  |  |  |  |  |  |  | 0
4.14 |  |  |  |  |  |  |  |  |  | 0
4.15 |  |  |  |  |  |  |  |  |  | 0
4.16 |  |  |  |  |  |  |  |  |  | 0
4.17 |  |  |  |  |  |  |  |  |  | 0
4.18 |  |  |  |  |  |  |  |  |  | 0
4.19 |  |  |  |  |  |  |  |  |  | 0
4.2 |  |  |  |  |  |  |  |  |  | 0
4.21 |  |  |  |  |  |  |  |  |  | 0
4.22 |  |  |  |  |  |  |  |  |  | 0
4.23 |  |  |  |  |  |  |  |  |  | 0
4.23999999999999 |  |  |  |  |  |  |  |  |  | 0
4.24999999999999 |  |  |  |  |  |  |  |  |  | 0
4.25999999999999 |  |  |  |  |  |  |  |  |  | 0
4.26999999999999 |  |  |  |  |  |  |  |  |  | 0
4.27999999999999 |  |  |  |  |  |  |  |  |  | 0
4.28999999999999 |  |  |  |  |  |  |  |  |  | 0
4.29999999999999 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 109291d1306189999-converting-frequency-table-into-list-extract-numbered-list-to-column
Sheet: Sheet1

 |  | helper: finds new start row of new number colum a |  | result
1 | 4 | 1 |  | 1
2 | 3 | 5 |  | 1
3 | 5 | 8 |  | 1
4 | 1 | 13 |  | 1
8 | 2 | 14 |  | 2
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 8
 |  |  |  | 8
Spreadsheet: darrell_schoolcraft__7330__LAPA 8-7 sorted by ERF
Sheet: H50479_30B_SERF_LAPA_01

Transwestern |  |  | H50479_30B |  | Station 8 to Station 7 Mainline |  |  | 2001-12-01 00:00:00
Weld number | Rel. dist. (feet) | Abs. dist. (feet) | Int/Ext | LAPA length (ins) | ERF | Orientation (o clock) | LAPA pressure @ 100% SMYS (psi) | LAPA depth (%) | LAPA pressure @ 72% [NAME] (psi) | Upstream AGM # | TW sta. @ upstream AGM | Footage from upstream AGM to pit | Downstream AGM # | [NAME]. @ downstream AGM | Footage from pit to downtream AGM | TW Eng. Stationing | TW Mile Post |  | Inspection Sheet #
48960 | 11.1 | 149896.9 | EXT | 12.4 | 1.341 | 06:45 | 1464.8 | 16 |  | 27 | 148133 | 2700.2 | vlv 8009 | 155418 | 4576.6 |  |  |  | 9
60650 | 6.2 | 178727.3 | EXT | 32.5 | 1.16 | 06:00 | 1498.8 | 11 |  | 32 | 182381 | 7991.1 | 33 | ? | 2893.1 |  |  |  | 14
60300 | 17.5 | 177711.2 | EXT | 82.2 | 1.149 | 12:45 | 1446.1 | 13 |  | 32 | 182381 | 6974.8 | 33 | ? | 3909.4 |  |  |  | 13
47770 | 15.2 | 147619 | EXT | 15.2 | 1.139 | 04:15 | 1481.1 | 14 |  | 27 | 148133 | 422.3 | vlv 8009 | 155418 | 6854.5 |  |  |  | 8
7340 | 7.7 | 20426.9 | EXT | 17.7 | 1.088 | 11:15 | 1508.4 | 11 |  | 3 | 19105 | 2147.2 | 4 | 26666 | 5370.5 |  |  |  | 3
52870 | 2.4 | 157392.8 | EXT | 15.6 | 1.084 | 02:45 | 1501.5 | 12 |  | vlv8009 | 155418 | 2909.9 | AGM 29 | 161275 | 2876.4 |  |  |  | 11
48970 | 7.4 | 149912.2 | EXT | 12.6 | 1.081 | 07:00 | 1474.7 | 15 |  | 27 | 148133 | 2715.6 | vlv 8009 | 155418 | 4561.2 |  |  |  | 10
46090 | 6.7 | 143751.1 | EXT | 10.6 | 1.061 | 07:00 | 1477.7 | 16
7430 | 19.2 | 20618 | EXT | 8.5 | 1.055 | 02:15 | 1468.5 | 18
7340 | 7.2 | 20426.4 | EXT | 10.2 | 1.031 | 08:15 | 1465.5 | 17
7340 | 18.3 | 20437.4 | EXT | 13.9 | 1.012 | 09:00 | 1507 | 12
22680 | 19.2 | 73649.5 | EXT | 5.1 | 1.01 | 05:45 | 1525.1 | 19
2390 | 29.4 | 6900.4 | EXT | 4.2 | 1.002 | 07:30 | 1502 | 26
60270 | 29.1 | 177630.8 | EXT | 12.1 | 0.991 | 12:15 | 1514.2 | 12
7340 | 14.2 | 20433.3 | EXT | 11.7 | 0.987 | 12:00 | 1512.5 | 12
5840 | 4.3 | 17106.9 | EXT | 4.7 | 0.985 | 01:45 | 1564 | 15
Spreadsheet: 126272d1319609517-excel-2007-if-function-timestamp-with-data-changes-for-excelforum-
Sheet: Sheet1

 | Data | Timestamp | Data backup | Timestamp Backup | Timestamp
 | μΉΤΣΟς | 2011-10-03 17:18:35 | 1 – μΉΤΣΟς | 1 – 40819,[PHONE] | 2011-10-03 17:22:17
 | ΚΛ | 2011-10-03 17:20:58 | 1 – ΚΛ | 1 – 40819,[PHONE] | 2011-10-03 17:22:31
 | Ι | 2011-10-03 17:21:02 | 1 – Ι | 1 – 40819,[PHONE] | 2011-10-03 17:23:36
 | [NAME] | 2011-10-03 17:21:10 | 0 - Λευτέρης | 0 – 40819,[PHONE] | 2011-10-03 17:21:10
Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: PR_Procurement Info_4

On-going Progress Update and Disbursement Request
PROGRESS UPDATE PERIOD
Grant number:
Progress Update - Reporting Period: |  |  | Cycle: |  | Number:
Progress Update - Period Covered: |  |  | Beginning Date: |  | End Date:
Progress Update - Number:
Section 4:  Procurement and Supply Management
 |  |  |  |  |  | Comments
1a.  Have you updated the Price Quality Reporting (PQR) with the required information on the pharmaceuticals and health products received during the period covered by this PU/DR’ (if applicable)?  If health products procurement information has not been entered into the PQR, please explain why.       !  For further guidance on PQR data entry, please refer to the guidelines. |  |  |  |  | Yes | The required information was updated for ARVs, rapid tests and condoms in the PQR (for cases when we did not have the final invoices, we updated the PQR based on pro-forma invoices).
2.  Based on the most up-to-date stock situation, are there any risks of stockouts of key pharmaceuticals & health products at the central level in the next period of implementation?  If yes, please comment. |  |  |  |  | No | Based on available information, there are sufficient stocks of drugs at central level. There were issues with drugs stocks in two regional centers but the PR worked closely with the central warehouse, the chief medical facility and the distribution company and ensured that the stocks at the regional level were replenished as soon as possible.
3.  Comment on additional issues related to the procurement and supply management of pharmaceuticals and health products
Spreadsheet: b1b210b4-636a-487e-8d36-4eff79507d5a
Sheet: Equipment List

Regatta 2013
[NAME]
Event |  | Chief Judge | Asst Judge | Special / Equipment
 | Required
MP-1 | [NAME] | [NAME] |  | score card/
MP-2 | [NAME] | [NAME] |  | CPC [NAME]
MP-3 | Knot Tying | [NAME] page |  | Argo
MP-4 | Quiz | [NAME] |  | Marcus / Neil
MP-5 | Uniform Insp. |  |  | CA
MP-6 | Conduct & Dis |  |  | CA
 | Optional
O-1 | [NAME] | [NAME] |  | Prop
O-2 | Blinker | [NAME] |  | Prop / Pat Kelley
O-3 | Bos'n chair |  |  | Prop
O-4 | [NAME] | [NAME] |  | CPC Dennis Moore
O-5 | Compass Cards | [NAME] |  | [NAME]
O-6
O-7 | [NAME] |  |  | CPC
O-8 | Piloting | [NAME] |  | Argo / Jeremy
[NAME] | Heaving Line | [NAME] |  | CPC
O-10 | Engines | [NAME] |  | [NAME]
O-11
O-12 | Sailmaking | [NAME] |  | Prop /Jeremy/
O-13 | [NAME] | [NAME] |  | [NAME]
O-14 | Semaphore | [NAME] |  | CPC /Prop
O-15 | Splicing, Whip | [NAME] |  | CPC
O-16 | Swimming | [NAME] |  | CA
O-17 | Taking out line | [NAME] |  | Argo/CPC
O-18 | Tug O War | Bos'n |  | Prop
O-19
O-20 | Safety Event
 | Service Events
R-1 | Barracks Insp
R-2 | [NAME] | Bos'n
R-3 | Service Watch
R-4 | Adult Judging
 | Galley
 | Central Accting
 | Splice Sail evaluation team
Spreadsheet: 207031d1358351334-auto-append-add-new-row-including-formatting-from-previous-row-when-data-is-entered-vat-calculator-ehf
Sheet: Calculator

DATE | [NAME] | COMPANY | (NET) | V.A.T. | (GROSS) | INSURANCE
10.01.13 | MATERIALS | SCREWFIX |  |  | 120
 |  | TOTALS
Spreadsheet: 774723d1648635762-extract-data-from-qr-code-and-deduct-from-inventory-list-extract-qr-code
Sheet: Blad1

data from QR code :
{"id":"OiF9mMKP","product_order_id":"67b92426-c9cf-4c51-9737-2e574bb4342d","product_sku":"F52"}
[NAME] | Antal
F70 | Deluxe [NAME] (4kg) 🇵🇹 | 12
F55 | [NAME] (5kg) 🇪🇸 | 11
F12 | Eko Mandarin (3kg) 🇪🇸 | 10
F52 | Eko [NAME] (2kg) 🇪🇸 | 8
F41 | Deluxe Apelsin (6kg) 🇵🇹 | 7
D49 | [NAME] (1kg) 🇩🇰 | 7
V21 | Eko Sötpotatis (3kg) 🇪🇸 | 6
F04 | [NAME] och Apelsin (3,5kg) 🇪🇸 | 6
V89 | Eko [NAME] (3kg) 🇪🇸 | 6
[NAME] | Eko körsbärstomater på kvist (2kg) 🇪🇸 | 5
V45 | Eko Potatis (4kg) 🇩🇰 | 5
V27 | [NAME] och Blomkål (3,5kg) 🇪🇸 | 5
F80 | [NAME] (3,5kg) 🇪🇸 | 5
V10 | Ekologiska miniplommontomater (2 kg) 🇪🇸 | 5
F45 | Eko [NAME] (2kg) 🇪🇸 | 4
F15 | [NAME] (3kg) 🇪🇸 | 4
D09 | [NAME] (1kg) 🇵🇹 | 3
F71 | Eko [NAME] (6kg) 🇪🇸 | 3
F28 | Eko [NAME] (2,8kg) 🇪🇸 | 3
D21 | Eko Hasselnötter (900g) 🇵🇹 | 2
F05 | Eko Citron (3kg) 🇪🇸 | 2
D08 | Eko [NAME] (900g) 🇵🇹 | 2
F140 | [NAME] (4kg) 🇪🇸 | 2
F01 | [NAME] och Grapefrukt (3,5kg) 🇪🇸 | 2
F08 | Eko [NAME] och Citron (3,5kg) 🇪🇸 | 2
F63 | Eko [NAME] (4kg) 🇪🇸 | 2
V11 | Ekologisk blandning av körsbärstomater (2 kg) 🇪🇸 | 2
V68 | Eko [NAME] (4kg) 🇩🇰 | 1
D06 | Eko rostade hasselnötter (900g) 🇪🇸 | 1
F10 | [NAME] (3kg) 🇪🇸 | 1
D13 | Eko Valnötter (700g) 🇵🇹 | 1
V60 | [NAME] (1kg) 🇩🇪 | 1
Spreadsheet: 882842d1731326498-sumproduct-formula-returns-0-or-does-not-recognise-the-conditions-sumif-aswell-sumproduct
Sheet: Results

Results
=SUMPRODUCT((Table1[Woche & Jahr]=C$5)*((Table1[AG-IBAN]=Results!$B6)+(Table1[Verwendungszweck]="*Berlin*"))+(Table1[Betrag]))
Customer | Account | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | Mrz 24
Berlin | DE239874
Amsterdam | NL982309
London | GB092735
=SUMPRODUCT((Table1[Woche & Jahr]=C$5)*((Table1[AG-IBAN]=Results!$B6)+(Table1[Verwendungszweck]="*Berlin*"))*(Table1[Betrag]))
Customer | Account | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | Mrz 24
Berlin | DE239874
Amsterdam | NL982309
London | GB092735
=SUMIFS(TableRE6[Betrag];TableRE6[Woche & Jahr];'2024-01'!V$4;TableRE6[Verwendungszweck];"=*Hallthurm*";TableRE6[Betrag];"<0")/1000
Customer | Account | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | Mrz 24
Berlin | DE239874
Amsterdam | NL982309
London | GB092735
Spreadsheet: andy_zipper__172__DYNEGY-ICE VOL Apr17
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-17-01 thru Apr-17-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 769543d1645589525-index-match-stacking-index-match-stacking
Sheet: Sheet1

Column1 | Column2
List | Company
Human 1 | Company 1
Human 2 | Company 2
Human 3 | Company 3
Human 4 | Company 1
Human 5 | Company 2
Human 6 | Company 3
Human 7 | Company 1
Human 8 | Company 2
Human 9 | Company 3
Human 10 | Company 1
Human 11 | Company 2
Human 12 | Company 3
Human 13 | Company 1
Human 14 | Company 2
Human 15 | Company 3
Human 16 | Company 1
Human 17 | Company 2
[NAME] |  |  | Desired
 |  |  | Human 1 | Company 1
 |  |  | Human 4 | Company 1
 |  |  | Human 7 | Company 1
 |  |  | Human 10 | Company 1
 |  |  | Human 13 | Company 1
 |  |  | Human 16 | Company 1
Spreadsheet: 856507d1705727049-cross-reference-and-add-values-from-multiple-sheets-exceltestdata
Sheet: Master

Name | Qty
Name1 | 225 | <- Should = total of all 'Name1' from data sheets
[NAME] | 1734 | <- Should = total of all '[NAME]' from data sheets
Name3 | 111 | <- Should = total of all 'Name3' from data sheets
Name4 | 11 | <- Should = total of all 'Name4' from data sheets
Name5 | 72 | <- Should = total of all 'Name5' from data sheets
Name6 | -40 | <- Should = total of all 'Name6' from data sheets
Spreadsheet: 869944d1716472294-change-date-from-dd-mm-yyyy-to-mm-yyyy-example_excel2
Sheet: Data2

PERMNO | Date | UniqueIdentifier | LogMB
10225 | 1970-01-30 00:00:00
10225 | 1970-02-27 00:00:00
10225 | 1970-03-31 00:00:00
10225 | 1970-04-30 00:00:00
10225 | 1970-05-29 00:00:00
10225 | 1970-06-30 00:00:00
10225 | 1970-07-31 00:00:00
10225 | 1970-08-31 00:00:00
10225 | 1970-09-30 00:00:00
10225 | 1970-10-30 00:00:00
10225 | 1970-11-30 00:00:00
10225 | 1970-12-31 00:00:00
Spreadsheet: 781445d1653328656-need-an-adjustment-to-existing-formula-for-new-position-codes-sample-file
Sheet: Sheet1

 | Warehouse Change in "Reports To" and updated Position Numbers
 | Position Number | Job Title | Job Details | Reports To
 | Grocery/Dairy
 | 20216086 | GW-Load-Trainer-Lift-DMG/Recoup | 8 hour schedule | GB
 | 20216075 | GW-Load-Trainer-Lift | 10 hour schedule | GB
 | 20216076 | Janitor | 8 hour schedule | GB
 | 20216113 | [NAME] | 8 hour schedule (Receiving shift) | GB
 | 99999 | [NAME] | 10 hour schedule (Receiving shift)(When it gets created) | GB(not yet used - maybe in near future though)
 | Perish
 | 10305276 | GW-Load-Trainer-Lift-FR Lift-DMG/Recoup-FR DMG/Recoup | 8 hour schedule | CM
 | 10305275 | GW-Load-Trainer-Lift-FR Lift | 10 hour schedule | CM
 | 10305318 | Janitor-FR Janitor | 8 hour schedule | CM
 | 20209586 | [NAME] | 8 hour schedule (Receiving shift) | CM
 | 20209600 | [NAME] | 10 hour schedule (Receiving Shift) | CM(not yet used - maybe in near future though)
Spreadsheet: 757253d1638158383-how-to-calculate-investment-return-with-contribution-and-withdrawal-example
Sheet: Sheet1

Initial Investment | 75000
Annual Contribution | 3600
Interest Rate | 0.09
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8
With Yearly Investments of $3,600.00
With Annual Contributions and One-Time Withdrawals |  |  |  | 20000 | 40000 | 40000 | 40000 | 20000 | <= in these years one-time withdrawal while still contributing
Spreadsheet: daren_farmer__5581__HPLN1116
Sheet: Sheet1

HPLN1116.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - November 16, 2000
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-11-16 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 0 | 0
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Sandhills |  | HPL | 8 | 8
Enron (S) |  | LS HPL [NAME] |  | HPL | 0 | 10
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 52172d1251882447-sum-formula-with-multiple-criteria-697993_hermithead
Sheet: Sheet1

Employee | Category ID | Category | Hours |  |  | Total Hours
SMITH JOHN | 208279 | Training | 2 | SMITH JOHN:Training |  | Training | [NAME] | Maintenance
SMITH JOHN | 208501 | Training | 2 | SMITH JOHN:Training | SMITH JOHN | 6 | 16 | 22.5
SMITH JOHN | 208579 | Training | 2 | SMITH JOHN:Training | JONES [NAME] | 34 | 25.5 | 0
SMITH JOHN | 891578 | [NAME] | 4 | SMITH JOHN:Admin | [NAME] | 0 | 0 | 20.5
SMITH JOHN | 891578 | [NAME] | 4 | SMITH JOHN:Admin | [NAME] | 0 | 34 | 22.5
SMITH JOHN | 891578 | [NAME] | 4 | SMITH JOHN:Admin
SMITH JOHN | 891578 | [NAME] | 4 | SMITH JOHN:Admin
SMITH JOHN | 904601 | Maintenance | 5 | SMITH JOHN:Maintenance | If SMITH JOHN equals TRAINING then return the total number of hours for TRAINING (and so on)
SMITH JOHN | 904601 | Maintenance | 13.5 | SMITH JOHN:Maintenance
SMITH JOHN | 904601 | Maintenance | 4 | SMITH JOHN:Maintenance
JONES [NAME] | 891578 | [NAME] | 8.5 | JONES [NAME]:Admin
JONES [NAME] | 891578 | [NAME] | 8.5 | JONES [NAME]:Admin
JONES [NAME] | 891578 | [NAME] | 8.5 | JONES [NAME]:Admin
JONES [NAME] | 208279 | Training | 8.5 | JONES [NAME]:Training
JONES [NAME] | 208501 | Training | 8.5 | JONES [NAME]:Training
JONES [NAME] | 208579 | Training | 8.5 | JONES [NAME]:Training
JONES [NAME] | 209221 | Training | 8.5 | JONES [NAME]:Training
[NAME] | 904601 | Maintenance | 13.5 | [NAME] BOB:Maintenance
[NAME] | 904601 | Maintenance | 4 | [NAME] BOB:Maintenance
[NAME] | 904604 | Maintenance | 3 | [NAME] BOB:Maintenance
[NAME] | 891578 | [NAME] | 8.5 | [NAME]:Admin
[NAME] | 891578 | [NAME] | 8.5 | [NAME]:Admin
[NAME] | 891578 | [NAME] | 8.5 | [NAME]:Admin
[NAME] | 891578 | [NAME] | 8.5 | [NAME]:Admin
[NAME] | 904601 | Maintenance | 5 | SAM SIMON:Maintenance
[NAME] | 904601 | Maintenance | 13.5 | SAM SIMON:Maintenance
[NAME] | 904601 | Maintenance | 4 | SAM SIMON:Maintenance
Spreadsheet: 872674d1719041480-conditional-formatting-for-numbers-and-in-the-same-coloumn-sample-report
Sheet: Sheet1

 |  |  | Actual | budget | [NAME]
 |  |  | 50 | 75 |  | manually Formatted
 |  |  | 100 | 80 |  | manually Formatted
 |  |  | 0.25 | 0.5 |  | manually Formatted
 |  |  | 11 | 22 |  | manually Formatted
 |  |  | 0.5 | 0.725 |  | manually Formatted
 |  |  | Actual | budget | [NAME]
 |  |  | 100 | 75
 |  |  | 60 | 80
 |  |  | 0.75 | 0.5 |  |  | Expecting this value to show in Black Font , when the variance becomes positive
 |  |  | 11 | 22
 |  |  | 1 | 0.725 |  |  | Expecting this value to show in Black Font , when the variance becomes positive
Spreadsheet: 781048d1652956886-which-formula-can-i-use-to-calculate-the-sum-test
Sheet: Test

CA | 3 | DG | 2 | RK | 1
DG | 3 | IC | 2 | CA | 1
CA | 3 | DG | 2 | IC | 1
DG | 3 | IC | 2 | CA | 1
DG | 3 | IC | 2 | CA | 1
RK | 3 | DG | 2 | IC | 1
IC | 3 | CA | 2 | DG | 1
RK | 3 | CA | 2 | IC | 1
IC | 3 | DG | 2 | RK | 1
Spreadsheet: 802920d1667147206-aggregate-function-problem-in-expenses-spreadshhet-expenses-
Sheet: Report

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | these columns do not exist and are only here to ullistrate the totals of sums needed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SO FOR AAA111 |  |  |  |  |  | AAA222 |  |  |  | BBB111 |  |  |  | BBB222
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | This | 10 |  | This |  | that |  | Emma |  | [NAME] |  | [NAME] |  | them |  | [NAME] |  | those |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | that | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB111 | them | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB222 | those | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | that | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | that | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB222 | those | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA222 | [NAME] | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB111 | [NAME] | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB111 | them | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | [NAME] | 110
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB222 | [NAME] | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | that | 130
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB111 | Mark | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA222 | [NAME] | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | Emma | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | This | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 | [NAME] | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BBB111 | them | 30