tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 217463d1362072816-two-way-table-lookup-with-interpolation-cfl
Sheet: Sheet1

 | 400 | 440 | 480 | 520 | 560 | 600 | 640 | 680 | 720 | 760 | 800 | 840
3 |  |  | 1939.138 | 2260.631 | 2642.631 | 2985.574 | 3325.973 | 3715.063 | 4232.792 | 4770.067 | 5300.583 | 5865.487
3.5 |  | 1925.3 | 2265.446 | 2639.841 | 3068.622 | 3489.563 | 3920.099 | 4424.993 | 5042.097 | 5690.236 | 6362.187 | 7083.644
4 | 1832.58 | 2195.665 | 2591.754 | 3019.079 | 3494.613 | 3992.985 | 4514.23 | 5134.462 | 5844.873 | 6609.928 | 7419.371 | 8290.329
4.5 | 2058.785 | 2466.03 | 2904.323 | 3382.829 | 3910.145 | 4488.172 | 5107.788 | 5827.722 | 6642.158 | 7520.524 | 8470.801 | 9483.196
5 | 2284.99 | 2734.813 | 3216.939 | 3745.633 | 4326.136 | 4983.282 | 5701.9 | 6520.757 | 7439.534 | 8430.907 | 9515.254 | 10678.04
5.5 | 2491.252 | 2981.509 | 3520.146 | 4095.308 | 4746.487 | 5476.889 | 6296.752 | 7220.668 | 8234.095 | 9341.077 | 10551.05 | 11855.7
6 | 2696.597 | 3227.509 | 3821.887 | 4444.478 | 5167.525 | 5970.809 | 6892.249 | 7920.45 | 9029.053 | 10251.55 | 11586.36 | 13034.39
6.5 | 2894.609 | 3465.203 | 4098.855 | 4787.052 | 5573.265 | 6463.417 | 7476.069 | 8603.548 | 9821.655 | 11160.94 | 12623.48 | 14213.49
7 | 3092.681 | 3702.481 | 4375.929 | 5129.457 | 5979.188 | 6955.7 | 8060.001 | 9286.347 | 10614.99 | 12070.62 | 13660.61 | 15376.99
7.5 | 3274.606 | 3920.471 | 4653.193 | 5456.348 | 6384.926 | 7444.428 | 8643.942 | 9959.337 | 11404.88 | 12984.38 | 14694.23 | 16540.49
8 | 3456.119 | 4138.292 | 4922.481 | 5783.338 | 6791.179 | 7933.042 | 9227.898 | 10632.64 | 12195.22 | 13898.12 | 15724.57
8.5 | 3627.634 | 4353.936 | 5179.175 | 6105.723 | 7191.481 | 8423.253 | 9803.193 | 11307.36 | 12977.22 | 14801.79 | 16754.91
9 | 3798.892 | 4569.113 | 5435.57 | 6428.177 | 7591.833 | 8913.559 | 10377.9 | 11982.33 | 13759.27 | 15705.93
9.5 | 3960.451 | 4777.318 | 5687.99 | 6745.158 | 7990.532 | 9407.352 | 10962.26 | 12657.58 | 14546.77 | 16610.07
10 | 4121.711 | 4985.424 | 5940.123 | 7062.207 | 8389.533 | 9901.348 | 11546.87 | 13332.63 | 15340.08
10.5 | 4283.04 | 5180.452 | 6186.602 | 7364.981 | 8786.856 | 10394.99 | 12121.33 | 14009.99 | 16133.39
11 | 4444.243 | 5375.491 | 6433.4 | 7667.264 | 9184.175 | 10888.52 | 12695.75 | 14687.27
11.5 | 4595.59 | 5570.037 | 6674.995 | 7975.095 | 9581.837 | 11373.58 | 13270.48 | 15370.32
12 | 4746.89 | 5764.573 | 6916.878 | 8283.125 | 9978.918 | 11858.65 | 13845.32 | 16053.37
12.5 | 4898.008 | 5956.199 | 7148.752 | 8584.604 | 10369.58 | 12353.42 | 14428.92 | 16736.42
13 | 5048.942 | 6147.554 | 7380.328 | 8886.001 | 10760.01 | 12848.64 | 15012.57
13.5 | 5190.268 | 6339.261 | 7616.76 | 9189.369 | 11156.68 | 13341.09 | 15589.25
14 | 5331.564 | 6530.583 | 7852.931 | 9492.543 | 11554.1 | 13834.08 | 16165.93
14.5 | 5487.248 | 6722.641 | 8088.589 | 9793.383 | 11938.87 | 14335.83
15 | 5643.079 | 6914.936 | 8330.51 | 10093.65 | 12322.64 | 14837.28
15.5 | 5794.4 | 7112.506 | 8563.256 | 10397.11 | 12714.92 | 15335.32
16 | 5945.71 | 7309.843 | 8795.3 | 10700.18 | 13107.13 | 15833.37
Spreadsheet: andy_zipper__232__ENW AA Program
Sheet: Sheet1

Full Name | PRC Meeting Name | PRC Business Unit | Org Unit Name | [NAME] | PRC Rep
[NAME], Heather  A | Analyst Level 1 | EWS (ENW) | ENW Commercial Coordination | Mr. [NAME] [NAME] | Forster, [NAME]
[NAME], [NAME]  L | Analyst Level 1 | EWS (ENW) | ENW Marketing Americas | Mr. [NAME] | Forster, [NAME]
Thakkar, Ami  H | Analyst Level 1 | EWS (ENW) | ENW Marketing Americas | Mr. [NAME] | Forster, [NAME]
Bucalo, [NAME]  T | Analyst Level 2 | EWS (ENW) | ENW Marketing Americas | Mr. [NAME] | Forster, [NAME]
Ferrara, [NAME] | Analyst Level 2 | EWS (ENW) | ENW Content and Community | Mr. [NAME] | Forster, [NAME]
Hull, [NAME]  L | Analyst Level 2 | EWS (ENW) | ENW Marketing Americas | Mr. [NAME] | Forster, [NAME]
Segura, [NAME]  L | Analyst Level 2 | EWS (ENW) | ENW - eMarket Services | Mr. [NAME] Palmer | Forster, [NAME]
Rostant, Justin  K | Analyst Level 2 | EWS (ENW) | ENW Origination and Development | Mr. [NAME] | Forster, [NAME]
Whitehead, [NAME] | Analyst Level 2 | EWS (ENW) | ENW Commodity Logic | Mr. [NAME] | Forster, [NAME]
[NAME] | Analyst Level 2 | ENW (ENW) | ENW Energy Ops Product Control | Mr. [NAME] | Forster, [NAME]
Maniar, [NAME] | Associate | ENW (ENW) | ENW Investments | Mr. [NAME] | [NAME], [NAME]
Marolo, [NAME] | Associate | ENW (ENW) | ENW Investments | Mr. [NAME] | [NAME], [NAME]
Smith, [NAME] | Associate | ENW (ENW) | ENW Commodity Logic | Mr. [NAME] | [NAME], [NAME]
Eller, [NAME] | Associate | ENW (ENW) | ENW Commodity Logic | Mr. [NAME] | [NAME], [NAME]
Alatorre, [NAME] | Associate | ENW (ENW) | ENW Origination & Development | Mr. [NAME] | [NAME], [NAME]
[NAME] | Associate | ENW (ENW) | ENW EOL Online Trading | Mr. [NAME] | [NAME], [NAME]
Timothy, Justin | Associate | ENW (ENW) | EEL Australia Support | Mrs. [NAME] [NAME] | [NAME], [NAME]
Spreadsheet: 741372d1626997988-how-to-extract-a-unique-list-of-values-from-across-multiple-sheets-in-a-workbook-power-query-to-produce-unique-list-mightybracket123-
Sheet: Summary

Product IDs |  |  |  | Product ID
123 |  | Expected list of values |  | 123
124 |  |  |  | 124
125 |  |  |  | 125
126 |  |  |  | 126
127 |  |  |  | 127
128 |  |  |  | 128
129 |  |  |  | 129
130 |  |  |  | 130
131 |  |  |  | 131
132 |  |  |  | 132
Spreadsheet: 701980d1604026833-sum-if-sample
Sheet: Sheet1

 |  |  |  | Prod1 | Prod2 | Prod3
 |  |  | Total Client 1
 |  |  | Total Client 2
 |  |  | Total Client 3
 |  |  | Total Client 4
 | Product | Lot number | Lot Quantity | Current Stock | Client | Invoice No | Qty | Client2 | Invoice No3 | Qty 4 | Client3 | Invoice No4 | Qty 5
 | PROD1 | 1515 | 80 |  | Client1 | 001 | 40 | Client2 | 007 | 20 | Client1 | 008 | 2
 | PROD1 | 1516 | 80 |  | Client2 | 002 | 20
 | PROD1 | 1517 | 80 |  | Client3 | 003 | 10 | Client4 | 009 | 20 | Client5 | 010 | 15
 | PROD3 | 1518 | 80 |  | Client1 | 004 | 5
 | PROD2
Spreadsheet: 89462d1289256110-list-values-formulaically-with-no-gaps-puzzle2
Sheet: Sheet1

 | aa.123 | [NAME] | cr.123
 | aa.1234 | bc.12 | [NAME]
 | ae.12 | bd.123
 | af.12
 | aa.123
 | ar.12345 | bb.123 |  | dt.1
 | af.12345 | bj.12 |  | do.1234
 | aj.123 | bj.1234 |  | di.1
 |  | bb.12
 |  | bb.12
 |  | bu.12
 |  | bm.1
Spreadsheet: 134190d1325084258-merging-combining-rows-and-creating-a-range-macro-yellow-unchanged-green-desired-blue-orig-data
Sheet: Sheet1

Sponsor | Product Code | Low Fund | High Fund | Number inbetween |  | Product Code | Sponsor | Low Fund | High Fund | Number inbetween
762 | TF | 1 | 1 |  |  | TF | 762 | 1 | 1
767 | WE | 2 | 6 |  |  | WE | 767 | 2 | 6
767 | PG | 7 | 8 |  |  | PG | 767 | 7 | 8
1006 | BL | 9 | 10 |  |  | BL | 1006 | 9 | 10
767 | GO | 11 | 14 |  |  | GO | 767 | 11 | 14
1006 | GS | 15 | 18 |  |  | GS | 1006 | 15 | 18
767 | ET | 19 | 19 |  |  | ET | 767 | 19 | 19
1006 | EN | 20 | 20 |  |  | EN | 1006 | 20 | 20
1006 | LF | 21 | 22 |  |  | LF | 1006 | 21 | 22
1006 |  | 25 | 27 |  |  | DG | 1006 | 23 | 24
1006 | WF | 28 | 29 |  |  |  |  | 25 | 27
1006 | TN | 30 | 30 |  |  | WF | 1006 | 28 | 29
9999 | zzz | 31 | 32 |  |  | TN | 1006 | 30 | 30
767 | FX | 33 | 39 |  |  | zzz | 9999 | 31 | 32
767 | NU | 40 | 40 |  |  | FX | 767 | 33 | 39
767 |  | 42 | 499 |  |  | NU | 767 | 40 | 40
762 |  | 501 | 890 |  |  | FX | 767 | 41 | 41
 |  |  |  |  |  |  |  | 42 | 499
 |  |  |  |  |  | TF | 762 | 500 | 500
 |  |  |  |  |  |  |  | 501 | 890
Assignment# | Sponsor | Product Code
1 | 762 | TF
2 | 767 | WE
3 | 767 | WE
4 | 767 | WE
5 | 767 | WE
6 | 767 | WE
7 | 767 | PG
8 | 767 | PG
9 | 1006 | BL
10 | 1006 | BL
11 | 767 | GO
12 | 767 | GO
13 | 767 | GO
14 | 767 | GO
15 | 1006 | GS
16 | 1006 | GS
17 | 1006 | GS
18 | 1006 | GS
19 | 767 | ET
20 | 1006 | EN
21 | 1006 | LF
22 | 1006 | LF
23 | 1006 | DG
24 | 1006 | DG
25
26
27
28 | 1006 | WF
29 | 1006 | WF
30 | 1006 | TN
31 | 9999 | zzz
32 | 9999 | zzz
33 | 767 | FX
34 | 767 | FX
35 | 767 | FX
36 | 767 | FX
37 | 767 | FX
38 | 767 | FX
39 | 767 | FX
40 | 767 | NU
41 | 767 | FX
blank rows until 500
500 | 762 | TF
Spreadsheet: 160528d1339098758-excel-2007-a-formula-calculates-a-cycle-open-and-close-same-day-an-extension-needed-different-day-spiros63_the_case_ron_v3
Sheet: Testing 2

 | 2012-05-01 00:00:00
 | Date | Ascending Numbering | Trade  Direction | Entry                               Type | Amount                                                      Of Shares | Open                                        At | Close                                   At | Exit                                  Type | Expenses                                € | P/L                                                  €
 |  | 1 | ä | Wave Entry | 100000 | 1.3 | 1.4 | Take Profit Level | 100
 |  | 2 | ä | Wave Entry | 100000 | 1.3 | 1.4 | Take Profit Level | 100
 |  | 3 | ã | Wave Entry | 100000 | 1.3 | 1.4 | Stop Loss | 100
 |  | 4 | ã | Wave Entry | 100000 | 1.3 | 1.4 | Stop Loss | 100
 |  | 5 | ä | Wave Entry | 100000 | 1.3
 |  | 5 |  |  |  |  | 1.4 | Take Profit Level | 100
 |  | 6 | ã | Wave Entry | 100000 | 1.3
 |  | 6 |  |  |  |  | 1.4 | Stop Loss | 100
 | 2012-05-17 00:00:00 | 7 | ã | Wave Entry | 50000 | 1.3 | 1.35 | Take Profit Level | 50
 | 2012-05-17 00:00:00 | 8 | ã | Wave Entry | 50000 | 1.3 | 1.4 | Take Profit Level | 50
 | 2012-05-17 00:00:00 | 9 | ã | Wave Entry | 100000 | 1.3
 | 2012-05-18 00:00:00 | 9 |  |  |  |  | 1.35 | Take Profit Level 1 | 50
 | 2012-05-19 00:00:00 | 9 |  |  |  |  | 1.4 | Take Profit Level 2 | 50
Spreadsheet: 106869d1304014698-if-statement-sampleworkbookexcelforum
Sheet: Blood Pressures and medications

# of BP meds with combos as 1drug | id | Systolic | Diastolic | *ace | *alpha | *arb | *b | *ccbd | *ccbn | *pd | *ld | *td | *b+td | *ace+td | *pd+td | *ara+td | *aag+td | *a+b | *ace+ccbd | *cag | *ara | *aa | SYSAdjust | DIAAdjust
2 | 19002 | 145 | 90 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 19003 | 150 | 92 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
2 | 19004 | 160 | 97 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
All these people are on 2 drugs
Spreadsheet: 841318d1693500856-calculating-shift-schedules-into-hours-allocated-wage-ratio
Sheet: Sheet1

Sales | 25000
Wages
Wage Ratio
EMPLOYEE | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | Wage
Garth |  |  |  |  |  |  |  |  | 20
[NAME] |  |  | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  | 17
[NAME] | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  |  |  | 15 |  | Shift | Hours
CUSTOMER SERVICE |  |  |  |  |  |  |  |  |  |  | 9-6 | 8
[NAME] |  | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  |  | 17 |  | 10-3 | 5
Jessica | 9-6 |  |  |  |  |  | 9-6 |  | 14 |  | 10-2 | 4
PICK/FILL TEAM
[NAME] |  |  |  |  |  |  |  |  | 18
Candy |  | 10-3 | 10-3 | 10-3 | 10-3 | 10-3 |  |  | 15
[NAME] |  | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  |  | 15
DEPARTMENTS
[NAME] | 9-6 |  |  |  |  |  | 9-6 |  | 14
[NAME] | 9-6 |  |  |  |  |  | 9-6 |  | 14
[NAME] |  |  |  |  |  |  | TBD |  | 14
Kerry | 9-6 | 9-6 | 9-6 |  |  | 9-6 | 9-6 |  | 14
[NAME] |  |  |  |  |  |  |  |  | 14
Mitchell | 9-6 |  |  | 9-6 | 9-6 | 9-6 | 9-6 |  | 14
[NAME] | 9-6 |  |  |  |  |  | 9-6 |  | 14
Stuart |  | 9-6 | 9-6 | 9-6 | 9-6 | 9-6 |  |  | 14
[NAME] | 9-6 |  |  |  |  |  | 9-6 |  | 14
Hours
Spreadsheet: larry_campbell__21589__Winter_icap_auction_monthly_bid_form_09-27-01_19_30
Sheet: Jan OPP

SUBMIT TO: |  |  |  |  |  | New York Independent System Operator
[EMAIL] |  |  |  |  |  | Installed Capacity (UCAP) Monthly Auction
 |  |  |  |  |  | Bids to Purchase
Auction Month: |  | January |  | 1 |  |  | Date submitted:
 |  |  |  | Submittal Number
Registrant Name: |  |  |  |  |  |  | Time submitted:
 |  |  |  |  |  |  | Location of Capacity to be Purchased
Use Only For Monthly Auction |  |  |  |  | In each location you must enter the number 1 for yes or 0 for no*
 |  |  |  |  | Capacity must be |  | Capacity can be located
 |  |  |  |  | located here |  | in any of the following areas
 | Purchaser's | Maximum Price | Amount (MW) | Total
Bid # | Name | [($/kW- per 1 month) | [express to | Bid ($) | NYC | LI | PJM-ISO | ISO-NE | HQ | O-IMO
 |  | express to nearest $.01] | nearest 0.1 MW]
1 |  |  |  |  | 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
Instructions:
* Rest of State - New York Control Area outside of New York City & Long Island
 | Do Not Delete Yellow Row
 | Do Not Enter Information
 | Contact Name: |  |  |  |  |  | Contact Phone#:
 |  |  |  |  | Comments:
 | Company Name:
 | Company Address:
 | Contact E-Mail:
Short Name
1stRoch
3mP&P
AdvantEn
AEPSysOp
AESCreRe
AESEastE
AESNuEn
AgwayES
AllegEnS
AllegPwr
AmerHess
AmherUtl
AquilEPM
AstGenCo
BlueCir
CanaEmir
CanNiaPwr
CargAlli
CHEnt
CHGE
CingyEnM
CingySvr
CityBuff
CoastMEn
ColumEN
ConecEn
ConEdEn
ConEdNY
[NAME]
ConstPwr
ConSuPwL
CoralPwr
CountEri
CountMon
CountNia
[NAME]
DynegyPM
EastCoas
ECNY
Econnerg
EdisnMMT
Electrox
ElPasMEn
EmpiNatG
Energetx
EnronEnS
EnronPM
EntNucIP
EntNukFz
EntPwrM
Essent
FedEG
FiberEn
FortUSEn
FPLEnPwM
Freeport
FrtDrum
FstEnTSv
GrtBayPw
HessEn
HQEnSvUS
IndCorin
IndIllio
IndOlean
IndOsweg
IndYerks
IntlPapr
ISODfAPR
ISODfAUG
ISODfDEC
ISODfFEB
ISODfJAN
ISODfJUL
ISODfJUN
ISODfMAR
ISODfMAY
ISODfNOV
ISODfOCT
ISODfSEP
ISOMoAPR
ISOMoAUG
ISOMoDEC
ISOMoFEB
ISOMoJAN
ISOMoJUL
ISOMoJUN
ISOMoMAR
ISOMoMAY
ISOMoNOV
ISOMoOCT
ISOMoSEP
isostrpS
isostrpW
ISOSuApr
ISOSuAug
ISOSuDec
ISOSuFeb
ISOSuJan
ISOSuJul
ISOSuJun
ISOSuMar
ISOSuMay
ISOSuNov
ISOSuOct
ISOSuSep
[NAME]
Kaleida
KeySpEn
KeySpRav
KochEnT
LIPA
LockpEnA
MEGA
MetroEN
Metrogen
MirabiGE
MLCS
MorgStan
NatlFuel
NEPAEn
NEUtilSv
NewLSE
NewSuppl
NFRPwr
NIMOEM
NIMOPC
NRGPwrM
NYMPA
NYPA
NYSEG
NYSEGSol
OccidChm
OnonCogn
OntPwrGn
OrionEnS
ORUtil
OutHQ
OutIMO
OutNE
OutPJM
PECoEn
PGENTPwr
PPLEnPl
Praxair
PrimPwrM
ProjOrgA
PSCoCol
PSEG
PSEGEnRT
PSEGEnT
RelintEn
RGE
RockvCtr
SelEn
SelkCogn
SemprEnt
SenecaEn
SenecaFL
SingRobO
[NAME]
SithePwM
SmartEn
SMEC
SoCoEnM
StatEnSv
StratgEn
StratgPM
SUNYBuff
TGE
TMassena
TopsMkts
TranAEnM
TrnCanPM
TXUEnSev
UofR
VirgPwrM
Wegmans
WeschRes
WestNYWi
WillEnMT
Spreadsheet: 110341d1307032855-excel-2007-macro-to-or-s-to-exsisting-cells-on-dif-pages-example-for-belayasila-v2
Sheet: Total

Item | Amount
Item 1 | 4
Item 2 | 20
Item 3 | 30
Item 4 | 58
Item 5 | 50
Item 6 | 60
Item 7 | 112
Item 8 | 80
Item 9 | 90
Item 10 | 52
Spreadsheet: 998580bb-db19-4501-a738-6bff969103db
Sheet: Sheet1

Table 9.   Rates of Net Migration Increase for Prefectures 1) - Total population | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
(‰)
 |  |  | Oct. 1, 1993 to | Oct. 1, 1994 to | Oct. 1, 1995 to | Oct. 1, 1996 to | Oct. 1, 1997 to
Prefectures |  |  | Sep. 30, 1994 | Sep. 30, 1995 | Sep. 30, 1996 | Sep. 30, 1997 | Sep. 30, 1998
 |  |  | 2) | 2)
 |  | Japan | -0.7 | -0.4 | -0.1 | 0.1 | 0.3
 | 1 | Hokkaido | -0.5 | 0 | -0.4 | -0.9 | -1.6
 | 2 | Aomori-ken | -1.2 | -1.1 | -0.3 | -2.2 | -2.1
 | 3 | Iwate-ken | -1.1 | -0.5 | -0.7 | -1.4 | -1.3
 | 4 | Miyagi-ken | 1.5 | 2.7 | 1.4 | 1.7 | 0.4
 | 5 | [NAME] | -1.1 | -1.6 | -2 | -2 | -2.1
 | 6 | Yamagata-ken | -1.3 | -0.4 | -1.1 | -0.6 | -0.8
 | 7 | [NAME] | -0.2 | 0.2 | -0.6 | -1 | -1.3
 | 8 | Ibaraki-ken | 3.3 | 2.3 | 2.7 | 1.7 | 1.9
 | 9 | Tochigi-ken | 0.9 | 1.1 | 1.9 | 2.2 | 1.3
 | 10 | [NAME] | 0.1 | 0.8 | 1.2 | 0.9 | 1.5
 | 11 | Saitama-ken | 4 | 3 | 2.7 | 1.7 | 1.8
 | 12 | Chiba-ken | 1.7 | 1 | 0.8 | 1.3 | 2.7
 | 13 | Tokyo-to | -7.3 | -4.3 | -1.9 | 1.3 | 0.2
 | 14 | Kanagawa-ken | -0.6 | -0.4 | -0.1 | 1 | 3.8
 | 15 | Niigata-ken | 0.3 | 0.8 | 0.7 | 0.1 | -0.7
 | 16 | Toyama-ken | -0.3 | 0.8 | 1.4 | -0.1 | -0.3
 | 17 | Ishikawa-ken | -0.8 | 0.9 | -0.2 | -0.7 | -0.6
 | 18 | Fukui-ken | -0.1 | 0.3 | 0.3 | -0.9 | -0.6
 | 19 | Yamanashi-ken | 2.2 | 1.9 | 2.4 | 1.7 | 1.9
 | 20 | Nagano-ken | 1.6 | 2.3 | 4.2 | 2 | 1.6
 | 21 | [NAME] | -0.3 | -0.2 | 0.6 | 0.1 | -0.3
 | 22 | Shizuoka-ken | -0.2 | -0.7 | 0.5 | 0.1 | 0.2
 | 23 | [NAME] | -1.2 | -0.9 | -0.2 | 0.5 | 1.5
 | 24 | Mie-ken | 2.6 | 2.5 | 2.3 | 1.9 | 1.4
 | 25 | [NAME] | 5.4 | 6.2 | 4.8 | 5.5 | 5.9
 | 26 | Kyoto-fu | -2.1 | -0.5 | -1.1 | -1.6 | -0.9
 | 27 | [NAME] | -5.3 | -0.4 | -2.8 | -3.7 | -3.2
 | 28 | [NAME] | 1.7 | -11.4 | -0.9 | 1.7 | 2.5
 | 29 | [NAME] | 3.3 | 5.2 | 2.8 | 1.4 | -0.5
 | 30 | Wakayama-ken | 2.3 | 1.5 | -1.2 | -1.4 | -1.9
 | 31 | [NAME] | 0 | 1.2 | -0.6 | -0.6 | 0.9
 | 32 | Shimane-ken | -1.3 | 0.4 | -0.9 | -1.2 | -1.8
 | 33 | [NAME] | 0.3 | 1 | -0.4 | 0.1 | -0.3
 | 34 | Hiroshima-ken | -1.2 | -0.3 | -2 | -1.7 | -1.4
 | 35 | Yamaguchi-ken | -1.4 | -1.1 | -2.6 | -1.8 | -1.9
 | 36 | Tokushima-ken | -0.8 | 1.8 | -0.3 | -0.2 | 0.1
 | 37 | Kagawa-ken | 0.5 | 0.8 | 0.5 | -0.2 | 0.1
 | 38 | Ehime-ken | -1.1 | -1 | -1.2 | -1.1 | -1.5
 | 39 | [NAME] | -0.7 | 0.3 | -1.2 | -0.4 | -0.5
 | 40 | Fukuoka-ken | 1.6 | 2 | 1.5 | 1.4 | 1.6
 | 41 | Saga-ken | 0 | 0.1 | -0.1 | -2 | -1.5
 | 42 | Nagasaki-ken | -2.7 | -3.3 | -3.6 | -4.7 | -4.8
 | 43 | [NAME] | 0.3 | 0.6 | -0.6 | -0.4 | -0.4
 | 44 | Oita-ken | -0.6 | -0.4 | -1.4 | -1.2 | -1.6
 | 45 | Miyazaki-ken | 0.4 | -0.5 | -0.6 | -2.4 | -2.2
 | 46 | [NAME] | -0.1 | 1.4 | -0.5 | -0.6 | -0.7
 | 47 | [NAME] | 1 | 0.6 | -0.5 | -0.7 | 0.4
Note  1)  Per 1,000 persons at the beginning of the period.
2)  [NAME] adjusted by the results of 1990 Population Census and 1995 Population Census.
Spreadsheet: 164696d1340850441-using-manual-countif-to-count-the-number-of-columns-that-contain-a-certain-text-contains-text
Sheet: Sheet1

Name | contains long | contains [NAME]
[NAME], [NAME], boon, long, [NAME]
[NAME]
[NAME], boon,long
long, boon,
[NAME] , [NAME], [NAME]
boon, marry
[NAME], long
Spreadsheet: phillip_m_love__30155__9902_OA
Sheet: NE-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 | 93951748 | 168966082
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 63965777 | 119726634.4202998
4 |  | Option Premiums | 0 | 88910
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 157917525 | 288781626.4202998
 | Purchases:
6 |  | 3rd Party / Inter Enron | -94462979 | -171418036
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -55713434 | -106066009
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 627064 | 1144342
 | Total Purchases: |  | -149549349 | -276339703
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | -842723 | -1517548
12 |  | Purchases | 922792 | 1649530
 | Total Intra CTS Sales / Purchases |  | 80069 | 131982
 | Imbalances:
13 |  | In Kind | 226478 | 427573
14 |  | Cash Out | -360353 | -666916.8981082512
15 |  | Cash In | 488068 | 855329
16 |  | Synthetic Storage | -238970 | -419914
 | Total Imbalances: |  | 115223 | 196071.1018917488
 | Storage:
17 |  | Injection (Sales to Stg) | 112201 | 203400
18 |  | W/D (Purchase from Stg) | -8395722 | -10119290
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -8395722 | -10119290
 | Total Storage: |  | -8283521 | -9915890
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -190556 | -337495.1715445606
 |  |  | 0 | 0
23 | Fuel: |  | -627064 | -1196394
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -1086700
25 |  | Demand | 0 | -12261836
 | Total Transport Expense: |  | 0 | -13348536
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | -112176.6
 | Total Transport Revenue: |  | 0 | -112176.6
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 158915.965
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 158915.965
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -2435307.935000001
31 |  | Prior Month Book Balance | 0 | 3892110
 |  | Total MTM Income | 0 | 1456802.064999999
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 5713
34 |  | Originations | 0 | 16223.95
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 1738274
37 |  | [NAME] | 0 | 23732.945
38 |  | Interdesk Charges | 0 | 11753580
39 |  | Canada | 0 | 164679.23
40 |  | Miscellaneous | 0 | -2000000
 |  | TOTAL
FT-South East
 |  | Current Month MTM | 0 | 0
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: e92471bb-ce36-4280-ab6f-2dcba7295091
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
1894 | 6150 | [NAME] | Riveros | CHI
1894 | 5471 | [NAME] | Geijo | ARG
1894 | 6151 | [NAME] | Vyhmeister | CHI
1894 | 6152 | Virginia | Lopez | URU
Spreadsheet: 743459d1628520676-all-matching-results-in-text-string-from-another-list-sample-data
Sheet: Sheet1

 | Expected Result 1 | Expected Result 2 | Expected Result 3 |  |  |  | List
hdhjdjdj657jjssjsjs234jdkksks765 | 657 | 234 | 765 |  |  |  | 657
yetehsn234jnsnss876 | 234 | 876 |  |  |  |  | 234
bheteyhn876mdjdj | 876 |  |  |  |  |  | 876
[NAME] | 893 | 765 |  |  |  |  | 893
getwhwjfd765jdjddndn | 765 |  |  |  |  |  | 765
Spreadsheet: 88949d1288753377-sumproduct-withnamed-range-using-dropdown-list-sumproduct_test
Sheet: Total

Revenue | Rank | Plan_Revenue | FCJul |  |  |  | Plan_Revenue |  | Using dropdown list to reference to Named [NAME] for dynamic view of data
Pipeline | S | 183148 | 22000 |  |  |  | 183148
 | A | 0 | 0 |  |  |  | 0
 | B | 0 | 0 |  |  |  | 0
 | C | 0 | 0 |  |  |  | 0
 | D | 150000 | 45000 |  |  |  | 150000
Total Pipeline |  | 333148 | 67000 |  |  |  | 333148
 |  |  |  |  |  |  |  |  |  |  |  |  | 80950 | 209854 | 117691 | 104142.3399999999 | 79263.67 | 5950 | 118000
 |  |  |  |  |  |  |  |  |  |  |  |  | Copa | Copa | Copa | Copa | Copa | Forecast | Forecast
GROUP | WBS | Customer | Description | Version | Order Proposing Date | Order Confirm Date | Rank | Remarks | Plan Revenue | Plan Ext Cost | Plan Int Cost | [NAME] | 2010-1 | 2010-2 | 2010-3 | 2010-4 | 2010-5 | 2010-6 | 2010-7
Blank | Blank | Blank | Blank | Pipeline |  | 2009-10-15 00:00:00 | S | Blank | 148800 |  | 66000 | 0.5564516129032258 | 11200 |  | 0 |  | 0 |  | 22000
Blank | Blank | Blank | Blank | BACKLOG |  | 2009-12-22 00:00:00 | A | Blank | 120000 |  | 71428 | 0.4047666666666667 | 20000 | 20000 | 13548 |  | 0
Blank | Blank | Blank | Blank | BACKLOG |  | 2010-02-08 00:00:00 | C | Blank | 114000 |  | 59400 | 0.4789473684210526 | 19000 | 19000 | 19000 | 19000 | 4750 |  | 50000
Blank | Blank | Blank | Blank | BACKLOG |  | 2010-02-17 00:00:00 | D | Blank | 148800 |  | 82168 | 0.4477956989247312 | 24800 | 24800 | 24800 | 24800 | 14171.43
Blank | Blank | Blank | Blank | Pipeline |  | 2010-03-29 00:00:00 | S | Blank | 34348 |  | 29478 | 0.1417840922324444 | 5950 | 5478 | 5725 | 5724.67 | 5724.67 | 5950
Blank | Blank | Blank | Blank | BACKLOG |  | 2010-02-19 00:00:00 | D | Blank | 42829 | 38637 |  | 0.09787760629480025 |  | 42829 | 0 |  | 0 |  | 1000
Blank | Blank | Blank | Blank | Pipeline |  | 2010-04-01 00:00:00 | D | Blank | 150000 |  | 109392 | 0.27072 |  | 60000 | 30000 | 30000 | 30000 |  | 45000
Blank | Blank | Blank | Blank | BACKLOG |  | 2010-04-15 00:00:00 | D | Blank | 111600 |  | 49500 | 0.5564516129032258 |  | 37747 | 24618 | 24617.6699999999 | 24617.57
Spreadsheet: 7c56e64f-7974-4588-a884-aed4fa54075f
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Metro One | 74948820327 | Company | Company | 2002-08-06 | Compact Disc | P & W | 17.99 | N | To Be Retired
Spreadsheet: 840636d1692881098-matrix-lookup-probably-as-simple-as-my-previous-question-test-example2
Sheet: Riskregister

Threat | Lowest probability | Highest probability | Most likely probabilty | Calculated probability | Probabilty level | Lowest consequense | Highest consequense | Most likely consequense | Calculated consequense | Consequense level | Risk level
Something goes wrong | 0 | 0.099 | 0.02 |  |  | 0 | 99 | 50