tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 165095d1341007824-vlookup-forumula-that-has-more-than-on-set-search-value-sample-ensmith-oeldere-
Sheet: Rep

Rep | Current Performance | Current Points | Revised Points
A | 0.3426 | 15
B | 0.2424 | 11
C | 0.3333 | 13
D | 0.32 | 15 |  |  | [NAME] will return a value in Column D (Revised Points)
E | 0.3367 | 15
F | 0.2315 | 5 |  |  | When a percentage input is made in [NAME] B3:F3 on [NAME] tab
G | 0.3694 | 15
H | 0.2891 | 10 |  |  | The returned value in Column D (Revised Points) will be based on the Metric table on the Metric tab
I | 0.0154 | 8
J | 0.2887 | 12
K | 0.1818 | 10
L | 0.0833 | 2
M | 0.5784 | 15
N | 0.0952 | 5
O | 0 | 0
P | 0.1379 | 0
Q | 0.2815 | 12
R | 0 | 0
S | 0.1667 | 2
T | 0 | 15
U | 0.2 | 0
V | 0.3382 | 15
W | 0.3819 | 14
X | 0.3246 | 15
Y | 0.0865 | 0
Z | 0.4861 | 15
Spreadsheet: 119a7feb-a78c-4681-86d1-26b806f6e8aa
Sheet: FREEDHeatContentData

 |  |  |  |  |  |  |  |  | Datafiles and Charts from FREED
 | Air
 | T (C) | HT-H298 (J) |  |  |  |  |  |  |  |  |  | N2, (g)
 | 25.00000000000102 | 0 |  |  |  |  |  |  |  |  |  | (Nitrogen dimer) |  |  |  |  |  |  |  |  |  |  |  | CO2, (g)
 | 77.50000000000091 | 1528.410101990046 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Carbon Dioxide)
 | 130.0000000000008 | 3058.592311833174 |  |  |  |  |  |  |  |  |  | T (C) | HT-H298 (J)
 | 182.5000000000007 | 4602.842788593135 |  |  |  |  |  |  |  |  |  | 700 | 20607.31694482889 |  |  |  |  |  |  |  |  |  | T (C) | HT-H298 (J)
 | 235.0000000000006 | 6165.759609209447 |  |  |  |  |  |  |  |  |  | 850.0000000000001 | 25549.33448360424 |  |  |  |  |  |  |  |  |  | 700 | 31961.02187822106
 | 287.5000000000005 | 7749.042905122745 |  |  |  |  |  |  |  |  |  | 1000 | 30594.83504495163 |  |  |  |  |  |  |  |  |  | 850.0000000000001 | 40184.49561339754
 | 340.0000000000003 | 9352.98595532882 |  |  |  |  |  |  |  |  |  | 1150 | 35730.24328577257 |  |  |  |  |  |  |  |  |  | 1000 | 48623.53225874677
 | 392.5000000000002 | 10977.18940019238 |  |  |  |  |  |  |  |  |  | 1300 | 40943.62497996388 |  |  |  |  |  |  |  |  |  | 1150 | 57233.67641495805
 | 445.0000000000001 | 12620.9202694519 |  |  |  |  |  |  |  |  |  | 1450 | 46224.36126288886 |  |  |  |  |  |  |  |  |  | 1300 | 65981.66139481943
 | 497.5 | 14283.29839295029 |  |  |  |  |  |  |  |  |  | 1600 | 51562.86705915795 |  |  |  |  |  |  |  |  |  | 1450 | 74842.07660130368
 | 550 | 15963.39486303944 |  |  |  |  |  |  |  |  |  | 1750 | 56950.36938093001 |  |  |  |  |  |  |  |  |  | 1600 | 83795.19169515236
 |  |  |  |  |  |  |  |  |  |  |  | 1900 | 62378.7374311267 |  |  |  |  |  |  |  |  |  | 1750 | 92825.48997902567
 |  |  |  |  |  |  |  |  |  |  |  | 2200 | 73328.01122514259 |  |  |  |  |  |  |  |  |  | 1900 | 101920.6508669344
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2200 | 120268.1098300226
 | H2O, (g)
 | (Hydrogen Oxide) |  |  |  |  |  |  |  |  |  |  | O2, (g)
 |  |  |  |  |  |  |  |  |  |  |  | ([NAME] dimer)
 | T (C) | HT-H298 (J)
 | 700 | 24894.4712913114 |  |  |  |  |  |  |  |  |  | T (C) | HT-H298 (J)
 | 850.0000000000001 | 31174.74529450363 |  |  |  |  |  |  |  |  |  | 700 | 21770.22982172005
 | 1000 | 37719.48671621815 |  |  |  |  |  |  |  |  |  | 850.0000000000001 | 27025.25929307847
 | 1150 | 44513.94346244114 |  |  |  |  |  |  |  |  |  | 1000 | 32370.92667079878
 | 1300 | 51541.45768615618 |  |  |  |  |  |  |  |  |  | 1150 | 37791.97292649441
 | 1450 | 58784.11788878092 |  |  |  |  |  |  |  |  |  | 1300 | 43277.72287355394
 | 1600 | 66223.14898647158 |  |  |  |  |  |  |  |  |  | 1450 | 48820.83847064718
 | 1750 | 73839.15870567651 |  |  |  |  |  |  |  |  |  | 1600 | 54416.45474955128
 | 1900 | 81612.30020133778 |  |  |  |  |  |  |  |  |  | 1750 | 60061.57417539348
 | 2200 | 97548.95309326479 |  |  |  |  |  |  |  |  |  | 1900 | 65754.63475771128
 |  |  |  |  |  |  |  |  |  |  |  | 2200 | 77283.70851713771
Spreadsheet: ryan_slinger__33676__5_21act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 82813d1282830114-multiplying-a-cell-number-by-a-user-input-number-food-nutrients-counter-02
Sheet: Fats and Oils

 | Food Nutrients Counter
Fats and Oils | Saturated | [NAME] | Polyun | Total | Calories | Description
Extra Virgin Olive Oil | 11 | 60 | 8 | 80 | 720 | 100g
Extra Virgin Olive Oil |  |  |  |  | 0 | Table Spoon
[NAME] |  |  |  |  | 0 | 100g
 |  |  |  |  | 0 | 100g
 |  |  |  |  | 0 | 100g
 |  |  |  |  | 0 | 100g
 |  |  |  |  | 0 | 100g
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 739218d1625580252-phone-number-validation-regexmatch-for-digits-country-excel-code-sample
Sheet: Country code sample

Person-Phone | [NAME] | Person - Country | Country code Length | Deal - Title | Validated Number | Correct Result
[PHONE] | 420 | Czech Republic | 3 | [NAME] |  | 420602305700
602305700 | 420 | Czech Republic | 3 | Deal2 |  | 420602305700
[PHONE] | 420 | Czech Republic | 3 | Deal2 |  | 420602305700
31633584300 | 31 | Netherlands | 2 | Deal3 |  | 31633584300
633584300 | 31 | Netherlands | 2 | Deal4 |  | 31633584300
[PHONE] | 31 | Netherlands | 2 | Deal4 |  | 31633584300
[PHONE] | 91 | India | 2 | Deal5 |  | 919784380900
9784380900 | 91 | India | 2 | Deal5 |  | 919784380900
[PHONE] | 91 | India | 2 | Deal5 |  | 919784380900
4531899900 | 45 | Denmark | 2 | Deal6 |  | 4531899900
31899900 | 45 | Denmark | 2 | Deal6 |  | 4531899900
031899900 | 45 | Denmark | 2 | Deal6 |  | 4531899900
46760394500 | 46 | Sweden | 2 | Deal7 |  | 46760394500
760394500 | 46 | Sweden | 2 | Deal8 |  | 46760394500
[PHONE] | 46 | Sweden | 2 | Deal8 |  | 46760394500
Spreadsheet: 751010d1633780901-delayed-holidays-in-calendar-sample-jt
Sheet: Sheet1

 |  |  | 2021
 |  |  | October
Spreadsheet: 493899d1481936410-filtering-combined-items-within-a-given-set-of-rows-in-pivot-table-copy-of-copy-of-sample-workbook-2
Sheet: Pivot Table (Before)

EMP NAME | Week count | PAY PERIOD | DATE | DESCR | Sum of HOURS | Sum of AMT | Sum of All Breaks | Sum of ADJ HOURS | Sum of Average Pay | Sum of Paid
[NAME] 2 | 2 | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 76.6 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] 2 | 2 | 07/01/12-07/07/12 Total |  |  | 8 | 76.6 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 2 | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Piece Rate | 8 | 71.28 | 0.33 | 7.67 | 8.34419817470665 | 0
[NAME] | 2 | 07/01/12-07/07/12 Total |  |  | 8 | 71.28 | 0.33 | 7.67 | 8.34419817470665 | 0
[NAME] | 2 | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 73.24 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 2 | 07/01/12-07/07/12 Total |  |  | 8 | 73.24 | 0.33 | 7.67 | 8.34419817470665 | 2.64
Spreadsheet: 685268d1593867037-profit-and-revenue-sharing-revenue
Sheet: Sheet1

 |  |  | NetIncome | 100000
Emp | Points | Percentage of Sharing | Distribution
Emp1 | 4 |  | *Formula To be added*
Emp2 | 4
Emp3 | 3
Emp4 | 4
Emp5 | 2
Emp6 | 3
Emp7 | 2
[NAME] | 1
Emp9 | 2
Emp10 | 3
Emp11 | 2
Emp12 | 2
Emp13 | 1
Emp14 | 1
Spreadsheet: 870199d1716749595-is-there-a-way-to-simplify-this-formula-excel-help-with-formulas-2-
Sheet: Results

Week Commencing | Contract | Contract % | Days Worked | Days Lost | Daily Average m3 | Reasons for Days Lost | Reasons for Days Lost | Contract Profit | Profit per Machine | Daily Average Profit | Contract Notes
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Week Number |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Spreadsheet: 66300d1266985508-message-beyond-current-date-master-rc-tracker
Sheet: ASNE

 |  |  |  |  |  | Corporate
 |  |  |  |  |  | Kolkata
 |  |  |  |  |  | West Bengal
 |  |  |  | Capex |  | Assam
 |  |  |  | Opex |  | NESA
S.No | Products /Services | Function | Capex/Opex | Vendor/Service Provider | Value(Rs) | Originated from(Circle/Region/Corporate) | Date of Issue | Date of Expiry | Remarks
NE/CP/09/R03 | LEASE AGREEMENT FOR WAREHOUSE | COMMERCIAL | CAPEX | ASSOCIATE BEVERAGE PVT LTD | As per Agreement | NESA | 2009-08-11 00:00:00 | 2012-08-11 00:00:00
NE/CP/09/R01 | LEASE AGREEMENT FOR WAREHOUSE | COMMERCIAL | CAPEX | MUKUND SYSTEMS & NETWORKING(P) LTD | As per Agreement | Assam | 2009-07-03 00:00:00 | 2012-07-06 00:00:00
NE/CP/09/R08 | Outsourcing of MARCOM warehouse management, SIM packaging & RCV bundling | MARCOM | OPEX | SIGMA SUPPLY CHAIN SOLUTIONS PVT. LTD. | 1296000 | ASSAM & NESA | 2009-11-04 00:00:00 | 03.11.2009
NE/CP/09/R07 | Rent Agreement for Storage Space | SERVICES DELIVERY | OPEX | ALAKA CHOUDHURY | 153537.6 | ASSAM & NESA | 2009-11-01 00:00:00 | 31.10.2012
NE/CP/09/R06 | Transportation Charges | COMMERCIAL | OPEX | AIR TRANSPORT CORPORATION (ASSAM) LTD. | Depends on business volume | ASSAM & NESA | 2009-10-15 00:00:00 | 14.07.2011
NE/CP/09/R05 | Transportation Charges | COMMERCIAL | OPEX | RADHIKA EXPRESS PVT. LTD. | Depends on business volume | ASSAM & NESA | 2009-09-01 00:00:00 | 31.08.2010
NE/CP/09/R04 | [NAME] for Byrnihat Location | COMMERCIAL | OPEX | ASSOCIATED BEVERAGES PVT. LTD. | Depends on business volume | NESA | 12-AGT-09 | 11.08.2012
NE/CP/09/R02 | [NAME] | COMMERCIAL | OPEX | MUKAND SYSTEMS & NETWORKING PVT. LTD. | Depends on business volume | ASSAM | 2009-07-07 00:00:00 | 06.07.2012
Spreadsheet: 100033d1298511899-re-return-nth-largest-value-using-multiple-criteria-sales-ranks
Sheet: Data

Salesmen | Sales |  |  | Top | 6 |  | Check
Billy | 500 |  |  | [NAME] | 11260 |  | 11260
[NAME] | 760 |  |  | [NAME] | 7590 |  | 7590
Irwin | 950 |  |  | [NAME] | 6440 |  | 6440
[NAME] | 60 |  |  | [NAME] | 5630 |  | 5630
[NAME] | 830 |  |  | Billy | 5570 |  | 5570
[NAME] | 950 |  |  | [NAME] | 4620 |  | 4620
Billy | 190
[NAME] | 610
[NAME] | 130
Billy | 430
[NAME] | 710
[NAME] | 890
[NAME] | 320
[NAME] | 350
[NAME] | 320
[NAME] | 150
Billy | 940
[NAME] | 780
[NAME] | 820
[NAME] | 570
[NAME] | 790
[NAME] | 710
[NAME] | 1000
[NAME] | 520
[NAME] | 240
[NAME] | 870
[NAME] | 90
Eddie | 530
[NAME] | 690
[NAME] | 710
[NAME] | 650
Billy | 300
[NAME] | 490
[NAME] | 50
Eddie | 90
[NAME] | 260
[NAME] | 700
Irwin | 560
Eddie | 710
[NAME] | 960
[NAME] | 500
[NAME] | 380
[NAME] | 750
Billy | 340
[NAME] | 870
[NAME] | 820
Irwin | 750
[NAME] | 890
Irwin | 120
[NAME] | 1000
[NAME] | 980
[NAME] | 860
Billy | 180
Eddie | 760
[NAME] | 90
[NAME] | 770
[NAME] | 920
Billy | 220
Billy | 870
[NAME] | 230
[NAME] | 940
Eddie | 290
Irwin | 480
[NAME] | 970
Eddie | 760
[NAME] | 670
[NAME] | 940
[NAME] | 10
[NAME] | 870
[NAME] | 490
[NAME] | 450
[NAME] | 970
[NAME] | 730
Billy | 900
[NAME] | 760
[NAME] | 50
[NAME] | 630
[NAME] | 900
[NAME] | 450
[NAME] | 90
[NAME] | 450
[NAME] | 170
[NAME] | 890
Irwin | 430
[NAME] | 540
Billy | 660
[NAME] | 850
[NAME] | 10
Irwin | 250
[NAME] | 790
[NAME] | 250
Irwin | 880
[NAME] | 530
[NAME] | 730
Eddie | 500
Billy | 40
[NAME] | 360
Eddie | 10
[NAME] | 170
Spreadsheet: 233a9ec8-84eb-48a4-9639-4523984e9b3d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 10. Labour force status by Sex - Northern Territory - Trend and Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Employed - full-time ;  [NAME] ; |  |  | Trend | A184131L | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184148J | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184165K | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184133T | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184150V | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | [NAME] | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184136X | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184153A | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184170C | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184143W | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184160X | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184177V | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184142V | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184159R | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184176T | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163486J | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163503X | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163520A | 1978-02-01 00:00:00 | 2011-10-01 00:00:00 | 405 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 0264f5fb-97e9-4dda-9c03-3a8b23d8e377
Sheet: Page 2

 | CERT # | ACCOUNT# | REPORTINGS | GROSS RENTAL INCOME | EXEMPT AMOUNT | TAXABLE RECEIPTS | TAX RATE (%) | AMOUNT OF TAX DUE | PENALTY | INTEREST | TOTAL AMOUNT DUE | DAYS AVAILABLE | DAYS OCCUPIED
1 |  |  | AMENDED |  |  |  | 0.1
2 |  |  | PREVIOUS |  |  |  | 0.1
3 |  |  | DIFFERENCE |  |  |  | 0.1
4 |  |  | AMENDED |  |  |  | 0.1
5 |  |  | PREVIOUS |  |  |  | 0.1
6 |  |  | DIFFERENCE |  |  |  | 0.1
7 |  |  | AMENDED |  |  |  | 0.1
8 |  |  | PREVIOUS |  |  |  | 0.1
9 |  |  | DIFFERENCE |  |  |  | 0.1
10 |  |  | AMENDED |  |  |  | 0.1
11 |  |  | PREVIOUS |  |  |  | 0.1
12 |  |  | DIFFERENCE |  |  |  | 0.1
13 |  |  | AMENDED |  |  |  | 0.1
14 |  |  | PREVIOUS |  |  |  | 0.1
15 |  |  | DIFFERENCE |  |  |  | 0.1
16 |  |  | AMENDED |  |  |  | 0.1
17 |  |  | PREVIOUS |  |  |  | 0.1
18 |  |  | DIFFERENCE |  |  |  | 0.1
19 |  |  | AMENDED |  |  |  | 0.1
20 |  |  | PREVIOUS |  |  |  | 0.1
21 |  |  | DIFFERENCE |  |  |  | 0.1
22 |  |  | AMENDED |  |  |  | 0.1
23 |  |  | PREVIOUS |  |  |  | 0.1
24 |  |  | DIFFERENCE |  |  |  | 0.1
25 |  |  | AMENDED |  |  |  | 0.1
26 |  |  | PREVIOUS |  |  |  | 0.1
27 |  |  | DIFFERENCE |  |  |  | 0.1
28 |  |  | AMENDED |  |  |  | 0.1
29 |  |  | PREVIOUS |  |  |  | 0.1
30 |  |  | DIFFERENCE |  |  |  | 0.1
31 |  |  | AMENDED |  |  |  | 0.1
32 |  |  | PREVIOUS |  |  |  | 0.1
33 |  |  | DIFFERENCE |  |  |  | 0.1
34 |  |  | AMENDED |  |  |  | 0.1
35 |  |  | PREVIOUS |  |  |  | 0.1
36 |  |  | DIFFERENCE |  |  |  | 0.1
 | AMENDED TOTALS page 2
 | Report period |  |  | to |  |  | ***AMENDED***
Spreadsheet: 886902d1737003201-sorting-smaller-lsit-of-data-against-larger-master-list-mpfred6-sort-example-spill-365-aligw
Sheet: Sheet1

I start with this spreadsheet
Acct # | Acct# | Name | Qty | Price
143 | 214 | [NAME] | 24 | 12
214 | 356 | [NAME] | 56 | 14
225 | 628 | [NAME] | 61 | 6
356 | 833 | [NAME] | 79 | 23
527
628
662
833
845
982
And want to sort columns B,C,D and E so they match the master list of accounts
 | Acct# | Name | Qty | Price
143
214 | 214 | [NAME] | 24 | 12
225
356 | 356 | [NAME] | 56 | 14
527
628 | 628 | [NAME] | 61 | 6
662
833 | 833 | [NAME] | 79 | 23
845
982
Spreadsheet: 356673d1415184985-top-5-numbers-in-a-range-numbers
Sheet: Sheet1

42 | 39 | 16 | 9 | 5
10 | 32 | 18 | 29 | 19 |  |  |  | Top Five Numbers |  |  |  | 45
5 | 7 | 37 | 17 | 13 |  |  | 1 | 45 |  |  |  | 44
38 | 1 | 37 | 26 | 32 |  |  | 2 | 44 |  |  |  | 43
6 | 13 | 18 | 23 | 45 |  |  | 3 | 43 |  |  |  | 42
6 | 43 | 13 | 2 | 16 |  |  | 4 | 42 |  |  |  | 41
8 | 29 | 45 | 21 | 6 |  |  | 5 | 41 |  |  |  | 40
40 | 9 | 16 | 3 | 33 |  |  |  |  |  |  |  | 39
17 | 19 | 41 | 14 | 21 |  |  |  |  |  |  |  | 38
36 | 12 | 35 | 11 | 17 |  |  |  |  |  |  |  | 37
19 | 2 | 31 | 30 | 40 |  |  |  |  |  |  |  | 36
43 | 15 | 37 | 14 | 10 |  |  |  |  |  |  |  | 35
9 | 42 | 26 | 11 | 6 |  |  |  |  |  |  |  | 34
29 | 14 | 9 | 43 | 8 |  |  |  |  |  |  |  | 33
6 | 1 | 14 | 34 | 41 |  |  |  |  |  |  |  | 32
5 | 24 | 18 | 13 | 35 |  |  |  |  |  |  |  | 31
35 | 23 | 30 | 4 | 7 |  |  |  |  |  |  |  | 30
23 | 14 | 37 | 7 | 2 |  |  |  |  |  |  |  | 28
40 | 23 | 25 | 33 | 17 |  |  |  |  |  |  |  | 24
41 | 36 | 29 | 1 | 11 |  |  |  |  |  |  |  | 14
5 | 4 | 14 | 8 | 13
31 | 25 | 21 | 41 | 19
19 | 34 | 18 | 25 | 36
7 | 27 | 25 | 36 | 44
10 | 29 | 34 | 31 | 21
20 | 8 | 6 | 16 | 43
15 | 36 | 23 | 11 | 20
20 | 6 | 39 | 13 | 12
12 | 27 | 41 | 11 | 43
9 | 33 | 3 | 16 | 36
8 | 32 | 7 | 25 | 9
29 | 24 | 9 | 42 | 36
29 | 14 | 4 | 31 | 15
17 | 2 | 28 | 22 | 14
4 | 13 | 42 | 3 | 28
24 | 38 | 7 | 33 | 14
12 | 22 | 5 | 34 | 19
19 | 20 | 41 | 22 | 4
24 | 40 | 19 | 44 | 4
21 | 35 | 25 | 42 | 3
7 | 4 | 19 | 34 | 9
21 | 28 | 20 | 45 | 44
30 | 41 | 10 | 6 | 35
39 | 11 | 9 | 2 | 7
18 | 8 | 42 | 27 | 1
11 | 44 | 13 | 16 | 39
2 | 16 | 7 | 10 | 40
44 | 37 | 16 | 15 | 34
13 | 24 | 16 | 30 | 21
31 | 22 | 37 | 24 | 25
16 | 14 | 9 | 11 | 24
28 | 31 | 15 | 12 | 9
40 | 44 | 13 | 30 | 25
22 | 9 | 20 | 40 | 31
41 | 42 | 28 | 14 | 31
5 | 24 | 16 | 17 | 31
14 | 6 | 26 | 18 | 35
37 | 26 | 30 | 17 | 15
45 | 4 | 30 | 8 | 6
38 | 17 | 42 | 3 | 39
35 | 27 | 5 | 11 | 3
23 | 30 | 24 | 26 | 6
6 | 33 | 41 | 24 | 43
33 | 12 | 23 | 17 | 1
30 | 18 | 14 | 19 | 26
27 | 3 | 15 | 33 | 11
39 | 16 | 38 | 14 | 32
44 | 30 | 14 | 23 | 41
42 | 27 | 43 | 25 | 1
31 | 20 | 17 | 35 | 19
4 | 1 | 45 | 33 | 40
27 | 32 | 14 | 19 | 43
26 | 10 | 17 | 34 | 1
3 | 10 | 6 | 40 | 45
12 | 11 | 18 | 38 | 8
2 | 35 | 25 | 30 | 17
22 | 35 | 42 | 26 | 41
42 | 5 | 18 | 10 | 4
5 | 22 | 44 | 38 | 6
30 | 23 | 21 | 26 | 28
21 | 32 | 44 | 12 | 29
7 | 4 | 12 | 38 | 40
42 | 3 | 41 | 22 | 17
44 | 28 | 1 | 8 | 24
1 | 16 | 12 | 26 | 43
28 | 25 | 27 | 19 | 32
3 | 17 | 34 | 9 | 43
20 | 4 | 7 | 31 | 40
Spreadsheet: kam_keiser__18070__ActiveCounterpartiesforTest020602
Sheet: Sheet1

Location | CP ID | Counterparty Name
East | 72209 | Allegheny Energy Supply Company, LLC
East | 8 | Amerada Hess Corporation
East | 586 | ANR Pipeline Company
East | 102342 | Aquila Capital and Trade Ltd.
East | 5225 | Arizona Public Service Company
East | 64516 | Avista Corporation
East | 26 | Baltimore Gas and Electric Company
East | 70526 | Bank of America, National Association
East | 56631 | BNP Paribas
East | 65291 | BP Corporation North America Inc.
West | 5264 | Cargill, Incorporated
West | 27457 | Carolina Power & Light Company
West | 3545 | Colorado Interstate Gas Company
West | 3497 | Conoco Inc.
West | 53876 | Coral Energy Canada Inc.
West | 49747 | Coral Energy Holding, L.P.
West | 1173 | Detroit Edison Company, The
West | 55250 | Duke Energy Corporation
West | 54980 | Duke Energy Marketing Limited Partnership
West | 54979 | Duke Energy Trading and Marketing, L.L.C.
West | 63064 | El Paso Gas Transmission Company
West | 57826 | El Paso Offshore Gathering & Transmission Company
West | 93110 | Exelon Generation Company, LLC
Central | 1421 | Florida Power & Light Company
Central | 1424 | Florida Power Corporation
Central | 65246 | IDACORP Energy L.P.
Central | 5815 | JP Morgan Chase Bank
Central | 2166 | Michigan Consolidated Gas Company
Central | 45492 | MidAmerican Energy Company
Central | 57251 | Nexen Marketing
Central | 3514 | North Carolina Natural Gas Corporation
Central | 154 | Northern Indiana Public Service Company
Central | 2383 | Northern Natural Gas Company
Central | 161 | Northern States Power Co.
Central | 11330 | Nova Gas Transmission
Central | 2421 | Oasis Pipe Line Company
Central | 11157 | PanCanadian Petroleum Limited
Central | 2584 | Pinnacle West Capital Corporation
Texas | 177 | Public Service Company Of Colorado
Texas | 2648 | Public Service Electric and Gas Company
Texas | 68285 | Reliant Energy Services Canada Ltd.
Texas | 65268 | Reliant Energy Services, Inc.
Texas | 187 | San Diego Gas & Electric Company
Texas | 2872 | Southern California Gas Company
Texas | 201 | Southwestern Public Service Company
Texas | 3015 | Tennessee Gas Pipeline Co.
 | 3947 | Texaco Inc.
 | 3032 | Texas Eastern Transmission, LP
 | 6223 | TransCanada Pipelines Limited
 | 11266 | UBS Warburg Energy (Canada) Ltd.
 | 1305 | UBS Warburg Energy LLC acting as agent for UBS AG, London Branch
 | 169 | Utilicorp United Inc.
 | 3246 | Virginia Electric and Power Company
 | 11324 | Westcoast Energy Inc.
 | 64254 | Williams Energy Marketing & Trading Company
 | 240 | Wisconsin Public Service Corporation
Spreadsheet: mary_hain__25838__2nd qtr 2000 EPMI FERC Report
Sheet: Exchange

 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | Total
Exchange Receipt
Hinson Power Company | 4464 | 0 | 0
Illinois Power Company | 0 | 0 | 0
[NAME] | 2870 | 0 | 0
Washington Water & Power | 0 | 0 | 0
Total
Exchange Delivery
Hinson Power Company | -4464 | 0 | 0
Illinois Power Company | 0 | 0 | 0
[NAME] | -2870 | 0 | 0
Washington Water & Power | 0 | 0 | 0
Total