tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30144__200004_OA
Sheet: ARUBA-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 12954190 | 38565878
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 19724265 | 59569325
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 2916287
 | Total Sales: |  | 32678455 | 101051490
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -4398784 | -12565797 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -28492624 | -84855857
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 197496 | 583040
 | Total Purchases: |  | -32693912 | -96838614
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 15457 | 43934.343063
 |  |  | 0 | 0
23 | Fuel: |  | -197496 | -583040
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -69018
25 |  | Demand | 0 | -2916287
 | Total Transport Expense: |  | 0 | -2985305
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 9152329.724600002
31 |  | Prior Month Book Balance | 0 | -9155983
 |  | Total MTM Income | 0 | -3653.27539999783
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -708087
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -2476
 |  | TOTAL INTRA-MTH
Spreadsheet: 720870d1614339404-data-summary-based-on-multiple-criteria-table
Sheet: scheet1

 | ARTICOLO | CE | Attivo | AA | BB |  |  | ARTICOLO | AA | BB
 | [NAME] | SI | 4 |  |  |  |  | [NAME]
 |  | NO | 4 |  |  |  |  | LPP
 | LPP | SI | 8 |  |  |  |  | Manutenzione
 | Manutenzione | SI | 8 |  |  |  |  | EVENTI
 |  | NO | 1 |  |  |  |  | CATAFORESI
 | EVENTI | SI | 9 |  |  |  |  | PQ
 |  | NO | 1 |  |  |  |  | [NAME]
 | CATAFORESI | SI | 15 |  |  |  |  | LAVORAZIONI
 |  | NO | 1 |  |  |  |  | [NAME]
 | PQ | SI | 20 |  |  |  |  | PRESSOFUSIONE
 |  | NO | 5 |  |  |  |  | VERNICIATURA
 | [NAME] | SI | 20 |  |  |  |  | SALDATURA
 |  | NO | 6 |  |  |  |  | Magazzini
 | LAVORAZIONI | SI | 15
 |  | NO | 12
 | [NAME] | SI | 9
 |  | NO | 18
 | PRESSOFUSIONE | SI | 13
 |  | NO | 15
 | VERNICIATURA | SI | 34
 |  | NO | 5
 | SALDATURA | SI | 16
 |  | NO | 26
 | Magazzini | SI | 43
 |  | NO | 3
 | Totale complessivo
Spreadsheet: 117374d1312744393-from-one-document-to-another-auto-filling-each-time-example
Sheet: DetailedSiteOccupancyPerRoomNum

Occupiers of site :
First responder |  | Room |  | Name |  | [NAME] | Departure | Organization | Department | Nights
False |  | 0101 |  | [NAME] |  | 2011-08-04 00:00:00 | 2011-08-18 00:00:00 | A | M | 1
False |  | 0102 |  | [NAME] |  | 2011-08-04 00:00:00 | 2011-08-17 00:00:00 | A | M | 1
False |  | 0103 |  | [NAME] |  | 2011-07-27 00:00:00 | 2011-08-10 00:00:00 | A | M | 1
False |  | 0104 |  | [NAME] |  | 2011-07-26 00:00:00 | 2011-08-09 00:00:00 | A | M | 1
False |  | 0105 |  | [NAME] |  | 2011-08-03 00:00:00 | 2011-08-17 00:00:00 | A | M | 1
False |  | 0106 |  | [NAME] |  | 2011-08-03 00:00:00 | 2011-08-17 00:00:00 | A | M | 1
False |  | 0107 |  | [NAME] |  | 2011-08-04 00:00:00 | 2011-08-18 00:00:00 | A | M | 1
False |  | 0108 |  | [NAME] |  | 2011-08-03 00:00:00 | 2011-08-17 00:00:00 | A | M | 1
True |  | 0109 |  | [NAME] |  | 2011-08-04 00:00:00 | 2011-08-18 00:00:00 | A | M | 1
Spreadsheet: john_griffith__16046__2_6_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 130 | 132 | 55 | 55.9 | 0.7 | 2002-02-06 12:12:00
 | CL J2 | 20.5 | 242 | 252 | 46.7 | 48.6 | 0.61 | 2002-02-06 12:12:00
 | CL K2 | 20.5 | 323 | 333 | 45.5 | 46.9 | 0.6 | 2002-02-06 12:12:00
 | CL M2 | 21 | 375 | 385 | 43.5 | 44.7 | 0.58 | 2002-02-06 12:12:00
 | CL N2 | 21 | 422 | 432 | 42.8 | 43.8 | 0.57 | 2002-02-06 12:12:00
 | CL Q2 | 21 | 450 | 465 | 41.3 | 42.7 | 0.55 | 2002-02-06 12:12:00
 | CL U2 | 21 | 470 | 485 | 39.9 | 41.2 | 0.54 | 2002-02-06 12:12:00
 | [NAME] | 21 | 480 | 495 | 37.7 | 38.9 | 0.51 | 2002-02-06 12:12:00
 | CL X2 | 21 | 485 | 500 | 35.9 | 37 | 0.48 | 2002-02-06 12:12:00
 | [NAME] | 21 | 495 | 510 | 34.9 | 36 | 0.47 | 2002-02-06 12:12:00
 | CL F3 | 21 | 500 | 515 | 33.6 | 34.6 | 0.45 | 2002-02-06 12:12:00
 | CL G3 | 21 | 505 | 525 | 32.5 | 33.8 | 0.44 | 2002-02-06 12:12:00
 | CL M3 | 21 | 530 | 560 | 29.9 | 31.6 | 0.41 | 2002-02-06 12:12:00
 | CL Z3 | 21 | 540 | 570 | 26.5 | 28 | 0.36 | 2002-02-06 12:12:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 693298d1598904068-returning-row-names-for-multiple-largest-values-top3months
Sheet: Sheet2

Month | Value1 | Value2 | Value3 | Value4 | Value5
Jan | 4 | 1 | 1 | 1 | 1 |  |  | Value1: Jan, Mar, April
Feb | 2 | 2 | 0 | 3 | 1 |  |  | Value2: Feb, Mar, April
Mar | 3 | 3 | 3 | 0 | 1 |  |  | Value3: Jan, Mar, April
April | 3 | 2 | 2 | 1 | 0 |  |  | Value4: Jan, Feb, April
 |  |  |  |  |  |  |  | Value5: Jan, Feb, Mar
 |  |  |  |  |  |  |  | Value1
 |  |  |  |  |  |  |  | Value2
 |  |  |  |  |  |  |  | Value3
 |  |  |  |  |  |  |  | Value4
 |  |  |  |  |  |  |  | Value5
Spreadsheet: 877431d1724261168-return-same-value-in-one-sheet-to-another-sheet-but-also-not-return-a-value-if-none-exists-return-value-etaf
Sheet: R Sheet

ID # | Description | Data 1 | Data 2 | Data 3
 |  | <-- does not work to return the value "ARGH" entered in M Sheet D10
 |  | <-- Works by not returning a result.
Spreadsheet: andy_zipper__183__DYNEGY-ICE VOL May15
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 8 | 24942500 |  | Carson , M | Firm-LD Peak | MWhs | 3 | 19200
[NAME], G | NG Fin BS, LD1 for GDM | MMBtus | 1 | 765000 |  | Dorland , C | Firm-LD Peak | MWhs | 5 | 68000
 | NG [NAME], ID, GDD | MMBtus | 3 | 7650000 |  | Fischer, M | Firm-LD Peak | MWhs | 1 | 4800
 | NG Fin BS, LD1 for NGI | MMBtus | 1 | 1530000 |  | [NAME], R | Firm-LD Peak | MWhs | 2 | 36800
Mckay, B | NG Fin BS, LD1 for IF | MMBtus | 2 | 1510000 |  | Stalford, R | Firm-LD Peak | MWhs | 1 | 1600
Pimenov, V | NG [NAME], FP | MMBtus | 2 | 15000 |  | Grand Total |  |  | 12 | 130400
White , B | Crude | bbl | 1 | 120000
Grand Total |  |  | 18 | 36532500
Spreadsheet: 176855d1346129393-nested-if-function-example
Sheet: Sheet2

 | Complaint | Start Time | Current Time | Status | Total Time | Escalated To |  |  | Hours | Escalate To
 | xxx | 04:21:00 | 09:53:00 | Open |  | ? |  |  | 4 to 8 hrs | [NAME]
 | yyy | 01:17:00 | 09:53:00 | Open |  | ? |  |  | 8 to 16 hrs | [NAME]
 | zzz | 17:00:00 | 09:53:00 | Open | 16:53:00 | ? |  |  | 16 to 24 hrs | [NAME]
 | aaa | 09:52:00 | 09:53:00 | Open |  | ? |  |  | More than 24 hrs | Louis
Spreadsheet: 274837d1383233339-top-ten-list-based-on-an-certain-criteria-sample
Sheet: Sheet1

Client Name | Regional Manager | Revenue
A | [NAME] | 234 |  | Top Clients
B | [NAME] | 345 |  | [NAME] |  | [NAME] |  | [NAME]
C | [NAME] | 247 |  | Client | Rev | Client | Rev | Client | Rev
A | [NAME] | 842
A | [NAME] | 456
F | [NAME] | 836
G | [NAME] | 842
H | [NAME] | 487
I | [NAME] | 965
J | [NAME] | 178
K | [NAME] | 367
L | [NAME] | 928
M | [NAME] | 842
N | [NAME] | 463
O | [NAME] | 670
P | [NAME] | 709
Q | [NAME] | 209
R | [NAME] | 387
S | [NAME] | 479
T | [NAME] | 823
U | [NAME] | 728
V | [NAME] | 299
X | [NAME] | 754
Y | [NAME] | 821
Z | [NAME] | 675
Spreadsheet: 706342d1606651066-finding-number-of-unique-value-based-on-another-value-incentive
Sheet: AM

 |  | INCENTIVE
 |  |  |  |  | Need formula in this column |  |  |  | INCENTIVE RULES
 | SL | Area Manager | ID | No. of member | No. of member sold vehicles | Incentive Amount |  |  | No. of member | Slab of Monthly Limit | Incentive Per member
 | 1 | Md. [NAME] Sarker-20090401 | 20090401 | 4 |  |  |  |  | 4 | 10000
 | 2 | Md. Kawser Ahamed-1032 | 1032 | 7 |  |  |  |  | 5 | 10000
 | 3 | [NAME] | 20080401 | 6 |  |  |  |  | 6 | 10000
 | 4 | Hasan Mahmud-20100902 | 20100902 | 9 |  |  |  |  | 7 | 12000
 | 5 | Md. Majedul Islam Patwary-20110554 | 20110554 | 9 |  |  |  |  | 8 | 12000
 | 6 | Mahbub Mehedi Jinnah-20090809 | 20090809 | 12 |  |  |  |  | 9 | 12000
 | 7 | [NAME] | 20141227 | 4 |  |  |  |  | 10 | 12000
 | 8 | MD. ATIQUR RAHMAN-20110484 | 20110484 | 6 |  |  |  |  | 11 | 12000
 | 9 | MD. MIZANUR RAHMAN-20090824 | 20090824 | 6 |  |  |  |  | 12 | 12000
 | 10 | Minhaz Al Islam Sarker-20090703 | 20090703 | 8
 | 11 | MD HASAN-UZ-ZAMAN-20090303 | 20090303 | 10
 | 12 | IFTEKHARUL [NAME] | 20070410 | 12
 | 13 | MUHAMMAD SELIM DEWAN-20100206 | 20100206 | 8
 | 14 | ABU ZAFAR MOHAMMAD SALEY-20090705 | 20090705 | 7
 | 15 | MOHAMMAD MOIN UDDIN-20081018 | 20081018 | 9
 | 16 | Md. Rafiqul Islam-201103150 | 201103150 | 7
 | 17 | Md. KAYMUL ISLAM-20090814 | 20090814 | 8
 | 18 | A.S.M ASADUR RAHMAN-20090704 | 20090704 | 8
 | 19 | HASAN ALI KHAN-20100832 | 20100832 | 9
 | 20 | MD. SALAMIN SARKER-20090421 | 20090421 | 10
 | 21 | K M Nasim Iqbal-20160845 | 20160845 | 4
 | 22 | [NAME] Sultan-20090506 | 20090506 | 4
 | 23 | [NAME] | 1387 | 4
 | 24 | [NAME] | 20080413 | 7
 | 25 | [NAME] (Sujon)-982 | 982 | 7
 | 26 | Harris Jomaddar-801 | 801 | 7
 | 27 | MUSLIM AHMED-20111230 | 20111230 | 6
 | 28 | Jahangir Alam-755 | 755 | 6
 | 29 | Md. Hasanul Karim-20091152 | 20091152 | 8
 | 30 | Md. Abu Sufian-20141106 | 20141106 | 2
 | 31 | [NAME] | 20090418 | 6
 | 32 | [NAME] | 20151244 | 4
Spreadsheet: 686940d1594882394-hyperlink-function-and-break-the-hyperlink
Sheet: Sheet1

 | [NAME] | [NAME] | [NAME] | Doc Code | Dco No | Version | [NAME]
 | D:\Sample Folder\Draw\MCD-1001-Art\MCD-1001-Drawing\Active\ | MCD-1001-02-Clown-Browny |  | MCD | 1001 | 02 | Clown-Browny
 |  | MCD-1001-03-Clown_Greeny |  | MCD | 1001 | 03 | Clown_Greeny
 |  | MCD-1001-04-Clown Bluey |  | MCD | 1001 | 04 | [NAME]
 |  | MCD-1001-10-Clownpinky |  | MCD | 1001 | 10 | Clownpinky
 | D:\Sample Folder\Draw\MCD-1001-Art\MCD-1001-Drawing\Active\MCD-1001-02-Clown-Browny | MCD-1001-02-Clown-Browny
Spreadsheet: 748772d1632332918-create-a-daily-rolling-schedules-from-multiple-worksheets-daily-work-schedule
Sheet: Brand

Brand
 |  | Priority |  |  |  |  |  | Status / Issues
Scaffold demo - hp htr, lime, [NAME] |  | C |  | START
8-UNIT CONTROL ROOM | X | B |  | START | IP
7B-side FA Equalizing Line Scaffold |  | C | COMP |  |  |  |  | 21-674493
7B Side Water Supply Valve Scaffold |  | A | COMP
8-UNIT J TRIPPER | X | A | COMP |  |  |  |  | BUILD ROLLER SCAFFOLD FOR COUPLING REPLACEMENT
7 FA air water serperators discharge line leaking on 6th fl | X | A |  |  |  |  |  | wo # 21-719728
6-UNIT SUMP LINE SCAFFOLD & INSULATION | X | A |  |  |  |  |  | WO # 21-718266
Unit 7 Bottom Ash catwalk, install insulation on missing steam pipe | WMAT | B
unit 8 pegging steam line on the 14th floor |  | A |  | COMP
Replace window on Unit 7 east side feeder floor |  | A |  |  |  |  | Start
McCormick- [NAME] |  |  |  |  |  |  |  | Backlog
Spreadsheet: 820740d1678277075-counting-available-beds-in-a-facility-new-sample
Sheet: Tabelle2

 | Room | Sex | NAME | Infos | Planning | Others |  | Available Beds
 | 1.80 | m | Mr. [NAME]
 | 1.78 | m | Mr XY |  |  |  |  | Female
 | 1.78 |  |  |  |  |  |  | =SUMME(WENNFEHLER(B3:B24=B4:B25)*(C3:[NAME]:C25)*(D3:E24="")*(E3:E24="")*(F3:F24="")*(G3:G24="")*((C3:C24="w")+(C4:C25="w"));0))
 | 1.73
 | 1.73 |  |  |  |  |  |  | Male
 | 1.71
 | 1.71
 | 1.70 | f | Mrs. [NAME] |  |  |  |  | Unisex
 | 1.70
 | 1.68
 | 1.68
 | 1.67
 | 1.64
 | 1.64
 | 1.54
 | 1.56
 | 1.57
 | 1.59
 | 1.60 | f | Mrs. [NAME]
 | 1.60 |  |  |  | 2023/03/10 Mrs. [NAME]
 | 1.63
 | 1.63
Spreadsheet: 06b2257b-7ac8-44cd-bf39-b9a7e2951263
Sheet: Sheet1

Appendix 13: [NAME] (French) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | La Contenu de la Trousse Syphilis
Infirmier:
Contenu | Quantité | Quantité | Quantité | Quantité | Quantité | Quantité | Quantité | Quantité
penicillin benzathine G
eau stérile
lidocaine
seringues (5 ou 10 cc)
aiguilles 18-20
aiguilles 27
epinephrine
seringues insulines
cotons alcoolisés
lancettes
testes rapides syphilis
protocols/carte d’éducation
fiches suppléments syphilis
assay diluent
tubes capillaires
Date
Signature
Spreadsheet: 188089d1350672882-matching-two-columns-of-data-in-two-different-worksheets-dummy-worksheet
Sheet: THURS, JAN 3

 |  | DAILY DEPOSIT
 |  | Thursday
 |  | Check Totals
 |  |  | Cash Totals
 |  | Deposit Total
Checks |  | Checks |  | Checks |  | Checks |  | Checks
No. | Amount | No. | Amount | No. | Amount | No. | Amount | No. | Amount
Checks |  | Checks |  | Checks |  | Checks |  | Checks
Cash |  | Cash |  | Cash |  | Cash |  | Cash
Spreadsheet: 750419d1633445880-nested-formulas-retrieve-values-from-proper-data-set-vlv98-
Sheet: Rate Card

Type | Client | Rate | [NAME] | Description | Delivery
Fuit |  | 750 | 3 | Frozen | Night Delivery
 |  | 770 |  | [NAME] | Full Day Delivery
 |  | 400 |  | [NAME] | Half Day Delivery
 |  | 60 |  | Organic
 |  | 840 |  | Single Pack | Full Day Delivery
 |  | 150 |  | Speciality | Speciality Delivery
 |  | 420 |  | No Package
 |  | 28.5 |  | Cooked
 |  | 630 |  | [NAME]
 |  | 360 |  | [NAME]
 |  | 45 |  | Cooked
 |  | 630 |  | [NAME]
 |  | 360 |  | [NAME]
 |  | 630 |  | [NAME]
 |  | 360 |  | [NAME]
Veg |  | 750 | -0.33 | Set Up | Night Delivery
 |  | 600 | -0.2 | [NAME] | Full Day Delivery
 |  | 300 | -0.2 | [NAME] | Half Day Delivery
 |  | 60 | -0.2 | Organic
 |  | 2 | -0.25 | Per Unit
Fresh |  | 750 |  | Set Up | Night Delivery
 |  | 400 |  | [NAME] | Hand Delivery
 |  | 200 |  | [NAME] | Hand Delivery
 |  | 60 |  | Organic | First Delivery
 |  | 200 |  | No Package | No Package
Meat |  | 750 |  | Set Up | Night Delivery
 |  | 400 |  | [NAME] | Hand Delivery
 |  | 200 |  | [NAME] | Hand Delivery
 |  | 60 |  | Organic | First Delivery
 |  | 200 |  | No Package | No Package
Other |  | 37.5 |  | Organic
Spreadsheet: 692259d1598239359-use-min-and-max-excluding-top-and-bottom-values-average_of_table
Sheet: Max - If

 |  |  | PostTender | Average | Minimum | [NAME]
ID | ESTIMATE TYPE | P50% | 20% of required | 2nd smallest number | > second smallest
7 | PostTender | 1
15 | PostTender | 2
25 | PostTender | 3
108 | PostTender | 4
4 | PostTender | 5
6 | PostTender | 6
41 | PostTender | 7
44 | Detailed | 8
86 | PostTender | 8
111 | PostTender | 9
34 | PostTender | 10
55 | Detailed | 12
Spreadsheet: 543995d1508716111-need-help-using-text-to-column-s666-mybpreadings_22oct2017
Sheet: MyBPReadings_22Oct2017

Date Time |  | Systolic | Diastolic | Pulse
2017-10-22 16:38:00 | 16:38:00 | 120 | 80 | 78
2017-10-22 11:42:00 | 11:42:00 | 120 | 80 | 78
2017-10-21 11:51:00 | 11:51:00 | 120 | 80 | 78
2017-10-21 05:59:00 | 05:59:00 | 120 | 80 | 78
2017-10-20 20:05:00 | 20:05:00 | 120 | 80 | 78
2017-10-20 16:38:00 | 16:38:00 | 120 | 80 | 78
2017-10-20 06:02:00 | 06:02:00 | 120 | 80 | 78
2017-10-18 16:27:00 | 16:27:00 | 120 | 80 | 78
2017-10-18 12:01:00 | 12:01:00 | 120 | 80 | 78
2017-10-18 09:17:00 | 09:17:00 | 120 | 80 | 78
2017-10-18 02:05:00 | 02:05:00 | 120 | 80 | 78
Spreadsheet: 33491d1229944935-identify-duplicates-across-multiple-colums-and-rows-example
Sheet: Sheet1

Folder A | Folder B | Folder C | Folder D
1234 | 5678 | 5681 | 2345
1235 | 5679 | 3457 | 2346
1236 | 5680 | 3458 | 2347
1237 | 5681 | 3459 | 2348
1238 | 5682 | 3460 | 2349
1239 | 5683 | 3461 | 2350 |  | I want to highlight duplicate cells in different colors if they occur in more than one column.
1240 | 5684 | 3462 | 2351
1241 | 5685 | 3463 | 2352 |  | Every cell must be checked against every other cell to find and indicate duplicates.
1242 | 5686 | 3464 | 2353
1243 | 2349 | 3465 | 2354
1244 | 5688 | 3466 | 2355
1245 | 5689 | 3467 | 2356
1246 | 5690 | 3468 | 2357
1247 | 5691 | 3469 | 2358
1248 | 5692 | 3470 | 2359
1249 | 5693 | 3471 | 2360
1250 | 5694 | 3472 | 2349
1251 | 5695 | 3473 | 2362
1252 | 1246 | 3474 | 2363
1253 | 5697 | 3475 | 2364
1254 | 5698 | 3476
 | 5699 | 3477
 |  | 3478
 |  | 3479
 |  | 3480
 |  | 3481
 |  | 3482
Spreadsheet: 198660d1354850953-excel-populating-a-calendar-excelcalendar
Sheet: Calendar

 | Week Commencing | 2012-12-10 00:00:00
Spreadsheet: 839134d1691684714-dynamic-drop-down-list-in-excel-sample
Sheet: Acct

 | Account | Type
 | 101 | [NAME]
 | 102 | [NAME]
 | 103 | [NAME]
 | 104 | [NAME]
 | 105 | [NAME]
 | 501 | Base
 | 502 | Base
 | 503 | Base
 | 504 | Base
 | 601 | Var
 | 602 | Var
 | 603 | Var
 | 604 | Var
Spreadsheet: daren_farmer__6518__Final_1-1-00
Sheet: SAP Procs

ENA Energy Operations
Global Counterparty/SAP COE
Y2K Preparations and Test Plan
 | December |  |  |  |  |  |  |  | January
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 1 | 2 | 3 | 4 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 30 | 31
I. | Critical Processes
 | A. | Process new counterparty to SAP
 | B. | Process settlement address change to SAP
 | C. | Set up new bank
II. | Critical Dates
 | A. | First week of month - January 1 - January 7
III. | Dependencies
 | A. | ENA - none at this time
 | B. | Enron - Europe - settlements
IV. | Preparations
 | [NAME]
 |  | ii. | 12/30/1999 |  |  | Active Customer/Vendor list
 |  | iii. | 12/30/1999 |  |  | Bank list
 | B. | Confirm [NAME] test plans with dependent parties - 12/27/99
V. | Equipment/Supplies required for Disaster Scenario
 | A. | Telephone - voice line
 | B. | General office supplies
VI. | Y2K Global Counterparty/SAP COE Contacts
 |  | [NAME] |  |  |  | X3-6517 |  |  | (713) 862-2066
 |  | [NAME] |  |  |  | X3-3103 |  |  | (281) 370-2363 |  |  |  | backup
 |  | [NAME] |  |  |  | X3-9249 |  |  | (281) 893-4012
VII. | Test Plans for 1/1/2000
 | A. | Execute tasks as outlined on SAP Test template using inputs from other areas
 |  | such as Global Counterparty
 | B. | Capture screen print of all entries and verification of integrated systems
 | C. | Test online connection from home on 1/1/00
Spreadsheet: 787150d1657642967-autofill-patterns-which-reference-evenly-spaced-columns-rows-example1
Sheet: Prod1

Prod1
 | Company | Assigned Seats | Sub9 | Prod5 | Sub3 | Sub4 | Sub5 | Sub6 | Sub7 | Sub8 | Sub9 | Sub10
Spreadsheet: 858995d1707474610-no-border-for-empty-cells-excel-border-issue-cf-tms
Sheet: Sheet1

 | DESIRED BORDERS, NO LINES FOR EMPTY CELLS |  |  |  |  |  |  |  | LINES FOR EVERY CELL
 |  |  | 2020 | 2021 | 2022 | 2023 | 2024 |  |  |  | 2020 | 2021 | 2022 | 2023 | 2024
 | North | Q1 |  |  |  |  |  |  | North | Q1
 |  | Q2 |  |  |  |  |  |  |  | Q2
 |  | Q3 |  |  |  |  |  |  |  | Q3
 |  | Q4 |  |  |  |  |  |  |  | Q4
 | South | Q1 |  |  |  |  |  |  | South | Q1
 |  | Q2 |  |  |  |  |  |  |  | Q2
 |  | Q3 |  |  |  |  |  |  |  | Q3
 |  | Q4 |  |  |  |  |  |  |  | Q4
 | West | Q1 |  |  |  |  |  |  | West | Q1
 |  | Q2 |  |  |  |  |  |  |  | Q2
 |  | Q3 |  |  |  |  |  |  |  | Q3
 |  | Q4 |  |  |  |  |  |  |  | Q4
 | East | Q1 |  |  |  |  |  |  | East | Q1
 |  | Q2 |  |  |  |  |  |  |  | Q2
 |  | Q3 |  |  |  |  |  |  |  | Q3
 |  | Q4 |  |  |  |  |  |  |  | Q4
 | CELLS WITH CF
 |  |  |  | 2020 | 2021 | 2022 | 2023 | 2024
 | North |  | Q1
 |  |  | Q2
 |  |  | Q3
 |  |  | Q4
 | South |  | Q1
 |  |  | Q2
 |  |  | Q3
 |  |  | Q4
 | West |  | Q1
 |  |  | Q2
 |  |  | Q3
 |  |  | Q4
 | East |  | Q1 |  |  |  |  |  |  | CF applied to B25:B40 |  |  | =MATCH("zzz",$D:$D,1)=ROW()
 |  |  | Q2
 |  |  | Q3
 |  |  | Q4
 | NO LINE AT THE END
Spreadsheet: sally_beck__33906__GlobalMgmtSum-Q101-0111
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1ST QTR 2001 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT |  |  |  | Change - Fav / (Unfav)
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Margin | Expenses (1) | Total
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Transportation
LNG
Middle East
Puerto Rico
Office of the Chairman
Total Commercial
Group Support Cost |  | 0 | 0
Support Cost Allocated to Teams |  | 0 | 0
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
Interest Expense/(Income)
Global Markets Pre-tax Income
(1) Includes Capital Charge & Operating, Direct, and Allocated Expenses
 |  | Margin change from: 10/26/00 |  |  |  | Expense changes from: 10/26/00
 |  | DPR Change |  |  |  | Operating Expense
 |  | MPR Change |  |  |  | Commercial Expense
 |  | Other Margin Changes |  |  |  | Other
 |  | Total Change |  |  |  | Total Change
 |  | Total Margin - QTD |  |  |  | Total Expense
 |  | Prior Week: |  |  |  | Prior Week:
 |  | This Week: |  |  |  | This Week:
 |  | Change: |  |  |  | Change:
Spreadsheet: 217794d1362183647-combining-totals-on-different-sheets-in-different-cells-computer-class-grading
Sheet: Discussion Score

Last Name | First Name | User ID | Lesson 01 Discuss | [NAME] 02 | [NAME] 03 | [NAME] 04 | [NAME] 05 | [NAME] 06 | [NAME] 07 | [NAME] 08 | [NAME] 09 | [NAME] 10 | [NAME] 11 | [NAME] 12 | [NAME] 13 | [NAME] 14 | [NAME] 15 | [NAME] 16 | [NAME] 17 | [NAME] 18 | [NAME] 19 | [NAME] 20 | [NAME] 21 | [NAME] 22 | [NAME] 23 | [NAME] 24 | [NAME] 25 | [NAME] 26 | [NAME] 27 | [NAME] 28 | [NAME] 29 | [NAME] 30 | [NAME] 31 | Total Discussion Score
Ferrell | [NAME] | bsf76 | 0 | 7 | 7 | 7 | 8 | 10 | 10 | 10 | 10 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
Spreadsheet: 103936d1301581252-importing-fields-from-other-spreadsheets-clients
Sheet: Sheet1

A/C Number | First Name | Surname | Address
1 | [NAME] | Smith | 12 Glengyle Terrace
2 | [NAME] | Johnston | 3 West Norton Place
3 | [NAME] | Reed | 9 Palmerston Place
4 | [NAME] | McDonald | 20/9 West Silvermills Lane
5 | [NAME] | Dalgliesh | 126/9 Pleasance, EH8 9TL