tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 470860d1468736084-sorting-two-different-values-book1
Sheet: R Sort

 | Status | Opened |  | Unit | All
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | Answer is Like this
 | Unit | R | A2 - Assending Order
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | R-01 | 10.47 | 45.04 | 182.76 | 7.16 | 1.24 | 37.54 | 0.65 | 0.28 | 4.36 | 400 | B | KA 02
 | R-08 | 7.84 | 45.85 | 146.36 | 3.98 | 1.29 | 44.29 | 0.73 | 0.41 | 20.69 | 400 | F | KA 06
 | R-07 | 10.06 | 50.57 | 114.96 | 9.73 | 0.93 | 28.86 | 0.6 | 0.74 | 9.21 | 400 | E | KA 05
 | Unit | RR
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | RR-05 | 11.31 | 46.76 | 112.06 | 6.84 | 0.72 | 37.34 | 0.71 | 0.33 | 9.33 | 400 | C | KA 03
 | RR-09 | 10.95 | 47.59 | 113.88 | 4.93 | 1.27 | 38.29 | 0.71 | 0.39 | 14 | 400 | G | KA 07
 | RR-12 | 10.83 | 48.1 | 129.52 | 7.03 | 1.39 | 35.85 | 0.67 | 0.34 | 11.91 | 400 | I | KA 09
 | Unit | GR
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | GR-01 | 11.22 | 47.61 | 80.64 | 8.68 | 0.96 | 32.48 | 0.62 | 0.4 | 7.96 | 400 | A | KA 01
 | GR-11 | 8.07 | 52.71 | 62.19 | 11.97 | 0.78 | 27.78 | 0.69 | 0.34 | 12.3 | 400 | H | KA 08
 | Unit | All
 | [NAME] | a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | a9 | qty | s | vn
 | R-01 | 10.47 | 45.04 | 182.76 | 7.16 | 1.24 | 37.54 | 0.65 | 0.28 | 4.36 | 400 | B | KA 02
 | R-08 | 7.84 | 45.85 | 146.36 | 3.98 | 1.29 | 44.29 | 0.73 | 0.41 | 20.69 | 400 | F | KA 06
 | RR-05 | 11.31 | 46.76 | 112.06 | 6.84 | 0.72 | 37.34 | 0.71 | 0.33 | 9.33 | 400 | C | KA 03
 | RR-09 | 10.95 | 47.59 | 113.88 | 4.93 | 1.27 | 38.29 | 0.71 | 0.39 | 14 | 400 | G | KA 07
 | GR-01 | 11.22 | 47.61 | 80.64 | 8.68 | 0.96 | 32.48 | 0.62 | 0.4 | 7.96 | 400 | A | KA 01
 | RR-12 | 10.83 | 48.1 | 129.52 | 7.03 | 1.39 | 35.85 | 0.67 | 0.34 | 11.91 | 400 | I | KA 09
 | R-07 | 10.06 | 50.57 | 114.96 | 9.73 | 0.93 | 28.86 | 0.6 | 0.74 | 9.21 | 400 | E | KA 05
 | GR-11 | 8.07 | 52.71 | 62.19 | 11.97 | 0.78 | 27.78 | 0.69 | 0.34 | 12.3 | 400 | H | KA 08
Spreadsheet: 102956d1300825342-excel-formula-just-in-time-system-book1_drakaz
Sheet: Sheet1

 |  |  | Paddington
 |  |  | Dr | Cr
Opening stock |  |  | 100
Date | Invoice No. | Account
2011-04-01 00:00:00 | 181532 | Myrt | 40
2011-04-02 00:00:00 | 52665 | Mood |  | 130
2011-04-11 00:00:00 | 154564sa | Ridd | 10
2011-04-12 00:00:00 | 51dsa | Myrt |  | 30 | -10
2011-04-13 00:00:00 | ef55e | Snap | 200 | 100
Spreadsheet: 274370d1383093811-cummulative-pivot-chart-test
Sheet: Sheet1

Item | Delivery date
1 | 2013-01-01 00:00:00
2 | 2013-01-01 00:00:00
3 | 2013-01-02 00:00:00
4 | 2013-01-02 00:00:00
5 | 2013-01-03 00:00:00
6 | 2013-01-03 00:00:00
7 | 2013-01-04 00:00:00
8 | 2013-01-04 00:00:00
Spreadsheet: 113923d1309812817-search-function-in-price-list-serach-function-in-price-list
Sheet: Sheet1

range | 0 | 61 | 121 | 171 | 221 | 271 | 321 | 421 | 521
country | 60 | 120 | 170 | 220 | 270 | 320 | 420 | 520 | 620
BE | 0.55 | 0.55 | 0.55 | 0.6 | 0.75 | 0.9 | 1.13 | 1.44 | 1.11
CZ | 0.26 | 0.36 | 0.46 | 0.54 | 0.78 | 0.78 | 0.82 | 0.87 | 0.86
ES | 0.51 | 0.51 | 0.58 | 0.58 | 0.86 | 0.98 | 1.11 | 1.1 | 1.09
FR | 0.42 | 0.37 | 0.44 | 0.5 | 0.63 | 0.76 | 0.93 | 1.13 | 1.23
[NAME] | 0.26 | 0.36 | 0.46 | 0.54 | 0.78 | 0.78 | 0.82 | 0.87 | 0.86
PL | 0.74 | 0.74 | 0.74 | 0.81 | 1.01 | 1.22 | 1.53 | 1.94 | 1.5
SE | 0.45 | 0.39 | 0.51 | 0.66 | 0.7 | 0.84 | 1.04 | 1.27 | 1.35
RU | 0.5 | 0.5 | 0.5 | 0.55 | 0.69 | 0.83 | 1.04 | 1.32 | 1.02
MAIL | WEIGHT | PRICE | Index/Matc | Vlookup | Hlookup
FR | 20 | ?? | 0.42 | 0.42 | 0.42
FR | 100 | ?? | 0.37 | 0.37 | 0.37 |  | 0 - 60 | 61 - 120 | 121 - 170 | 171 - 220 | 221 - 270 | 271 - 320 | 321 - 420 | 421 - 520 | 521 - 620
BE | 200 | ?? | 0.6 | 0.6 | 0.6
RU | 200 | ?? | 0.55 | 0.55 | 0.55
SE | 300 | ?? | 0.84 | 0.84 | 0.84
FR | 362 | ?? | 0.93 | 0.93 | 0.93
FR | 428 | ?? | 1.13 | 1.13 | 1.13
BE | 494 | ?? | 1.44 | 1.44 | 1.44
RU | 560 | ?? | 1.02 | 1.02 | 1.02
SE | 626 | ?? | 1.35 | 1.35 | 1.35
FR | 692 | ?? | 1.23 | 1.23 | 1.23
FR | 758 | ?? | 1.23 | 1.23 | 1.23
Spreadsheet: larry_campbell__21319__Cash Out Prices for August 2000
Sheet: City Gas 

Rates Stated per Therm |  |  |  | City Gas Company of Florida
 |  |  |  | Underdeliveries |  |  |  | Overdeliveries
August 2000 BTU Factor |  |  | 1.075 | Cashout - Without Standby |  |  |  | Cashout - Without Standby
September  2000 BTU Factor |  |  | 1.078 | Tier 1 | [NAME] | Tier 3 |  | Tier 1 | [NAME] | Tier 3
Commercial Service |  |  |  | 0.78331 | 0.86164 | 0.93997 |  | 0.384 | 0.3456 | 0.3072
Interruptible Preferred |  |  |  | 0.68034 | 0.74837 | 0.81641 |  | 0.384 | 0.3456 | 0.3072
Interruptible Large Volume |  |  |  | 0.63529 | 0.69882 | 0.76235 |  | 0.384 | 0.3456 | 0.3072
Gas Flow Month: August 2000
Spreadsheet: 780814d1652796658-vlookup-based-on-the-dropmenu-data-for-sheet-name-vlookup-based-on-sheet-name
Sheet: Data Output

 |  |  | Month | [NAME]
 | Student Code | Name | [NAME] | Mark2 | [NAME] | Total
 | M001
 | M002
 | M003
 | M004
Spreadsheet: 07837aba-e5c9-4f29-8a0f-8f367dda192b
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
 | 5609.0 Housing Finance, Australia
 | TABLE 12. HOUSING LOAN OUTSTANDINGS TO HOUSEHOLDS (OWNER OCCUPATION AND INVESTMENT HOUSING)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Owner-occupied housing ;  [NAME] ; |  |  | Original | A2435226X | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Permanent Building Societies ; |  |  | Original | A2435228C | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Credit Co-operatives ; |  |  | Original | A2435230R | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435232V | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
Investment housing ;  [NAME] ; |  |  | Original | A2435227A | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
Investment housing ;  Permanent Building Societies ; |  |  | Original | A2435229F | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
Investment housing ;  Credit Co-operatives ; |  |  | Original | A2435231T | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
Investment housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435233W | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
All residential housing ;  [NAME] ; |  |  | Original | A2435234X | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
All residential housing ;  Permanent Building Societies ; |  |  | Original | A2435235A | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
All residential housing ;  Credit Co-operatives ; |  |  | Original | A2435245F | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
All residential housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435246J | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
All residential housing ;  Securitisation Vehicles ; |  |  | Original | A2435238J | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
All residential housing ;  Other Lenders ; |  |  | Original | A2435241W | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
All residential housing ;  Total (Lender Housing) ; |  |  | Original | A2435244C | 2002-03-01 00:00:00 | 2012-01-01 00:00:00 | 119 | $ Millions | STOCK | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 109565d1306395154-lookup-countif-sumiif-example-questionnaire
Sheet: Summary Results

 | Very Satisfied | Satisfied | Neither satisfied nor dissatisfied | Dissatisfied | Very dissatisfied | Did not use | Applicant Comments
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Spreadsheet: phillip_m_love__30020__STORAGE
Sheet: JulyMossBluff

 | ENRON NORTH AMERICA MOSS BLUFF STORAGE
[NAME] |  |  |  | NOTE:  1.5% FUEL CHARGED GOING INTO MOSS BLUFF (Injection)
 | NGPL |  |  | CHANNEL (EL PASO) |  |  | HOUSTON PIPELINE (HPL) |  |  | [NAME] (UTTCO) |  |  | TEJAS GAS |  |  | TETCO
 | Inj net fuel | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl
2000-07-01 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-02 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-03 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-04 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-05 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-06 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-07 00:00:00 | 19495 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-08 00:00:00 | 19495 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-09 00:00:00 | 19495 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-10 00:00:00 | 19495 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-11 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-12 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-13 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-14 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-15 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-16 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-17 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-18 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-19 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-20 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-21 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-22 00:00:00 | 0 | 3500 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-23 00:00:00 | 0 | 3500 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-24 00:00:00 | 0 | 3500 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-25 00:00:00 | 0 | 9370 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-26 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-27 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-28 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-29 00:00:00 | 1376 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-07-30 00:00:00 | 1376
2000-07-31 00:00:00 | 1376
Total Inj/Withdrawl
Net Inj/WithD per Pipe
Ending Balance
Spreadsheet: 745860d1630327823-find-which-array-a-value-belongs-to-sampledata
Sheet: Sheet1

Sales per day |  |  |  |  |  |  |  |  |  | Top Sales
Week | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  | 1 | 2 | 3
1 | 32478 | 23541 | 23813 | 12512 | 52353 | 83134 | 74112
2 | 54234 | 33255 | 43233 | 46235 | 75423 | 91235 | 123422
3 | 45252 | 35235 | 34555 | 53523 | 46432 | 81312 | 78712 |  |  |  |  |  |  | > Want to know what days these values come from
4 | 41341 | 53234 | 43231 | 32123 | 53134 | 75312 | 98123
Spreadsheet: 100402d1298777591-sumifs-alternative-for-excel-2003-sumproduct-not-working-sumif-example
Sheet: KVS

20110220 | 0615 | 2 | 22
20110220 | 0630 | 3 | 33
20110220 | 0645 | 1 | 1
20110220 | 0700 | 1 | 8
20110220 | 0715 | 3 | 19
20110220 | 0730 | 6 | 44
20110220 | 0745 | 2 | 11
20110220 | 0800 | 5 | 30
20110220 | 0815 | 8 | 57
20110220 | 0830 | 15 | 233
20110220 | 0845 | 13 | 397
20110220 | 0900 | 9 | 297
20110220 | 0915 | 3 | 26
20110220 | 0930 | 1 | 23
20110220 | 0945 | 7 | 48
20110220 | 1000 | 5 | 79
20110220 | 1015 | 12 | 257
20110220 | 1030 | 4 | 190
20110220 | 1045 | 5 | 173
Spreadsheet: 61846d1262766677-sumproduct-formula-pack-usage
Sheet: Pack Usage

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
[NAME] | 1
ARGX17L
ARGX17LN
ARGX21H
[NAME]
ARGX21HN
ARGX21HN
[NAME]
ARGX21L | 10
ARGX21LN
BCX15H
BCX21H
BCX21HN
DP001
SVX15H
SVX21H
TCBP
TCBP/1K
[NAME]
[NAME]
TCP21K/1K
TCP21L
TCP21L S
TCX13H
TCX19H
TCX21H
TCX21H HF
TCX21H/1K
TCX21H/1K HF
ULP14L
ULP17H/1K
ULP17L
ULP17L/1K
ULP21H
ULP21H/1K
ULP21H/1K HF
ULP21L
ULP21L/1K
ULX17H
ULX19H
ULX19H/1K
ULX21H
ULX21H/1K
ULX21H/1K HF
Spreadsheet: daren_farmer__6657__Texas Matrix
Sheet: Texas

User ID | User Name | Role
achoksh | [NAME] | Logistics
alannou | [NAME] | Logistics
bfletch | [NAME] | Logistics | Not Texas
ccernos | C C Cernosek | Logistics
chawkin | [NAME] | Logistics
crodrig | [NAME] | Logistics
dfarmer | [NAME] | Logistics
ekam | [NAME] | Logistics | No longer in Logistics
ggrant | [NAME] | Logistics
[NAME] | [NAME] | Logistics | Not Texas
jpattis | [NAME] | Logistics
[NAME] | [NAME] | Logistics
kbussel | [NAME] | Logistics | Not Texas
klenart | [NAME] | Logistics | Not Texas
kmoore | [NAME] | Logistics | Not Texas
kolinge | [NAME] | Logistics | Not Texas
kseaman | [NAME] | Logistics | No longer with the company
[NAME] | [NAME] | Logistics
mbowen | [NAME] | Logistics | Not Texas
mfrankl | [NAME] | Logistics | Not Texas
mmackin | [NAME] | Logistics | No longer with the company
mmcclur | [NAME] | Logistics
mmsmith | [NAME] | Logistics | Texas Transportation and Rate Management
pclynes | [NAME] | Logistics
rcotten | [NAME] | Logistics
rcrocke | [NAME] | Logistics | Not Texas
rlloyd | [NAME] | Logistics
rpinion | [NAME] | Logistics
rstanle | [NAME] | Logistics
rsupert | [NAME] | Logistics
sgilber | [NAME] | Logistics
smorris | Stella Morris | Logistics
sneuwei | [NAME] | Logistics
strevin | [NAME] | Logistics
tacton | [NAME] | Logistics
tmaire | [NAME] | Logistics | Not Texas
bherod | [NAME] | Risk Analytics
bhull | [NAME] | Risk Analytics
csulliv | [NAME] | Risk Analytics
dbaumba | [NAME] | Risk Analytics
ebass | [NAME] | Risk Analytics
hwither | [NAME] | Risk Analytics | Texas Transportation and Rate Management
mfriedm | [NAME] | Risk Analytics | Not Texas
mwalter | [NAME] | Risk Analytics
nferrie | Nelson Ferries | Risk Analytics
owinfre | [NAME] | Risk Analytics
sventur | [NAME] | Risk Analytics
cmetz | [NAME] | Trader
egottlo | [NAME] | Trader
etisdal | [NAME] | Trader | Gas Control
evillar | [NAME] | Trader
ewardle | [NAME] | Trader | Not Texas
ghanks | [NAME] | Trader | Gas Control
glamphi | [NAME] | Trader
gmcclen | [NAME] | Trader
[NAME] | [NAME] | Trader | Not Texas
[NAME] | [NAME] | Trader
[NAME] | [NAME] | Trader
jsabine | [NAME] | Trader
jwallis | [NAME] | Trader
lallen | [NAME] | Trader
[NAME] | [NAME] | Trader | Texas Tranportation and Rate Management
[NAME] | [NAME] | Trader
mabraha | [NAME] | Trader | Not Texas
[NAME] | [NAME] | Trader
wfalbau | [NAME] ([NAME]) | Trader
Spreadsheet: benjamin_rogers__1169__Base
Sheet: Wilton

INCOME STATEMENT - WILTON
('000 $) |  |  |  | 1999
Revenue
PPA Period:
Demand Payment |  |  |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Energy Payment |  |  |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Block Payment |  |  |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Market Period:
Demand Payment |  |  |  | 0 | 0 | 0 | 0
Variable Revenue |  |  |  | 0 | 0 | 0 | 0
Energy Margin |  |  |  | 0 | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fuel |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed O&M |  |  |  | 0
Variable O&M |  |  |  | 0
Major Maintenance & Ongoing Capex |  |  |  | 0
Insurance |  |  |  | 0
SG&A |  |  |  | 0
Utility Start Up Power |  |  |  | 0
Property, Other Taxes |  |  |  | 0 | 78.38864699999999 | 402.3808693768251 | 402.3808693768251 | 402.3808693768251 | 402.3808693768251 | 360.3662568116061 | 360.3662568116061 | 360.3662568116061 | 360.3662568116061 | 318.3516442463871 | 318.3516442463871 | 318.3516442463871 | 318.3516442463871 | 276.3370316811681 | 276.3370316811681 | 276.3370316811681 | 276.3370316811681 | 234.3224191159491 | 234.3224191159491 | 234.3224191159491 | 301.5973298986361
Debt Service L/C Fee |  |  |  | 0
Marketing Fee |  |  |  | 0 | 0 | 0 | 0
Administrative Fee
O&M Fees |  |  |  | 0
Total Expense
EBITDA
Depreciation & Amortization |  |  |  | 0
EBIT
Interest Expense |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense) |  |  |  | 0
[NAME]
CASH FLOW WILTON
Investor Interest
('000 $) |  |  |  | 1999
EBITDA
Capital Expenditures |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service |  |  |  | 0
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense) |  |  |  | 0
Federal Cash Taxes Benefit (Expense) |  |  |  | 0
After Tax Cash Flow
Investor Net Income
Investor [NAME]
Spreadsheet: 807371d1669873899-trying-to-finalize-consignment-calculator-with-tiered-rates-labyrin_2
Sheet: Sheet1

2022 Consignment Rates |  |  |  |  |  |  |  |  | Item Payout Estimator (Enter Your Item Value To Estimate Payout)
THE BEST CONSIGNMENT RATES - YOU PAY ZERO PROCESSING FEES |  |  |  |  |  |  |  |  | THE BEST CONSIGNMENT RATES - YOU PAY ZERO PROCESSING FEES
RATES FOR INDIVIDUAL AUCTIONS |  |  |  |  |  |  |  |  | RATES FOR INDIVIDUAL AUCTIONS
SALES PRICE |  |  | Qty |  | PAYOUT |  |  |  | SALES PRICE |  |  | Qty |  | Enter item Price | Payout
0 | 9.99 |  | 1 |  | $3 Flat Fee | 3 |  |  | Item #1 |  |  | 1 |  | 11 | 8.35 | 10 | 0.85 | -1
10 | 49.99 |  | 1 |  | 85%-$1 | 0.85 | -1 |  | Item #2 |  |  | 1 |  | 5 | 3 | 0 | 3 | 0
50 | 99.99 |  | 1 |  | 0.86 | 0.86 |  |  | Item #3 |  |  | 1 |  | 101 | 88.88 | 100 | 0.88 | 0
100 | 499.99 |  | 1 |  | 0.88 | 0.88 |  |  | Item #4 |  |  | 1 |  | 10 | 7.5 | 10 | 0.85 | -1
500 | 999.99 |  | 1 |  | 0.88 | 0.88 |  |  | Item #5 |  |  | 1 |  | 5000 | 4650 | 5000 | 0.93 | 0
1000 | 2499.99 |  | 1 |  | 0.89 | 0.89 |  |  | Item #5 |  |  | 1 |  | 10000 | 9400 | 10000 | 0.94 | 0
2500 | 4999.99 |  | 1 |  | 0.91 | 0.91
5000 | 9999.99 |  | 1 |  | 0.93 | 0.93 |  |  |  |  |  |  |  | Total Payout | 14157.73
10000 | And Up |  | 1 |  | 0.94 | 0.94
999999
Spreadsheet: 778417d1651055980-capitalize-certain-letters-proper-aligw
Sheet: Sheet1

 |  | User Inputs | Expected Results | AliGW
 |  | LR-Jame King Geo | LR-Jame King Geo
 |  | LR-JAME KING GEO | LR-Jame King Geo
 |  | lr-jame King geO | LR-Jame King Geo
 |  | rs-jame king geo | RS-Jame King Geo
 |  | DP-JAME KING GEO | DP-Jame King Geo
 |  | KO-jame king geo | KO-Jame King Geo
Spreadsheet: 716706d1612340772-identifying-every-5th-row-but-ignores-cells-that-have-a-false-in-the-adjacent-column-dummy-sheet
Sheet: Sheet1

Job | rule 1 | rule 2 | rule 3 | Tech Check Required
job 1 000reviewjnh |  |  |  | ?
fghjreview89 |  |  |  | ?
full job |  |  |  | ?
full job |  |  |  | ?
full job |  |  |  | ?
fghjreview89 |  |  |  | ?
fghjreview90 |  |  |  | ?
job 1 000reviewjnh |  |  |  | ?
full job |  |  |  | ?
full job |  |  |  | ?
[NAME] |  |  |  | ?
[NAME] |  |  |  | ?
full job |  |  |  | ?
full job |  |  |  | ?
full job |  |  |  | ?
Spreadsheet: louise_kitchen__24140__ubsfinal
Sheet: Sheet1

 |  |  |  |  | 145 Model
 | Texas Gas Trading |  |  |  | 4
 | East Gas Trading |  |  |  | 6
 | Central Gas Trading |  |  |  | 5
 | West Gas Trading |  |  |  | 9
 | Nymex Desk Trading |  |  |  | 5
 | Derivatives Marketing |  |  |  | 7
 | Gas Outsourcing |  |  |  | 4
 | Texas Gas Origination |  |  |  | 2
 | East Gas Origination |  |  |  | 2
 | Central Gas Origination |  |  |  | 2
 | West Gas Origination |  |  |  | 5
 | Ercot Power Trading |  |  |  | 3
 | Northeast Power Trading |  |  |  | 6
 | Midwest Power Trading |  |  |  | 3
 | Southeast  Power Trading |  |  |  | 4
 | East Options Trading |  |  |  | 3
 | East Real Time Trading |  |  |  | 12
 | East Power Services |  |  |  | 1
 | Ercot Power Origination |  |  |  | 3
 | Northeast Power Origination |  |  |  | 4
 | Midwest Power Origination |  |  |  | 3
 | Southeast Power Origination |  |  |  | 3
 | Southwest Power Trading |  |  |  | 2
 | California Power Trading |  |  |  | 3
 | Northwest Power Trading |  |  |  | 3
 | West Real Time Trading |  |  |  | 8
 | West Power Services |  |  |  | 1
 | Southwest Power Origination |  |  |  | 2
 | California Power Origination |  |  |  | 3
 | Northwest Power Origination |  |  |  | 3
 | Western Canada Gas and Power Trading |  |  |  | 8
 | Western Canada Gas and Power Origination |  |  |  | 8
 | Eastern Canada Gas and Power Trading |  |  |  | 2
 | Eastern Canada Gas and Power Trading |  |  |  | 2
 | Leadership |  |  |  | 2 | 2
Spreadsheet: 52883d1252691025-conditional-format-conflict-i-think-book1
Sheet: Sheet1

00:10:47 | 00:11:00 | 00:19:56 | 00:19:57 | 00:23:10 | 00:04:09 | 00:05:14 | 00:10:53
00:01:32 | 00:23:58 | 00:15:09 | 00:15:37 | 00:22:13 | 00:02:20 | 00:12:59 | 00:01:51
00:09:02 | 00:12:18 | 00:00:53 | 00:21:30 | 00:12:24 | 00:16:14 | 00:22:42 | 00:11:00
00:16:33 | 00:07:45 | 00:19:15 | 00:19:09 | 00:03:56 | 00:22:10 | 00:03:50 | 00:15:26
00:15:24 | 00:17:07 | 00:20:20 | 00:07:45 | 00:11:23 | 00:15:25 | 00:17:49 | 00:06:13
00:13:43 | 00:15:46 | 00:10:09 | 00:15:17 | 00:10:41 | 00:16:54 | 00:16:14 | 00:22:36
00:08:41 | 00:18:57 | 00:20:26 | 00:15:34 | 00:22:20 | 00:04:17 | 00:22:27 | 00:04:35
00:06:05 | 00:05:03 | 00:01:16 | 00:15:33 | 00:00:53 | 00:22:50 | 00:03:09 | 00:03:16
00:07:17 | 00:13:20 | 00:14:21 | 00:08:30 | 00:05:21 | 00:04:20 | 00:05:38 | 00:11:18
00:08:32 | 00:05:28 | 00:18:34 | 00:13:26 | 00:16:50 | 00:12:46 | 00:03:51 | 00:07:26
00:06:01 | 00:17:54 | 00:00:13 | 00:08:51 | 00:11:47 | 00:14:54 | 00:06:55 | 00:08:03
00:16:10 | 00:05:32 | 00:08:38 | 00:10:50 | 00:12:49 | 00:20:28 | 00:19:48 | 00:06:41
00:01:11 | 00:06:42 | 00:06:07 | 00:13:02 | 00:10:31 | 00:21:38 | 00:01:44 | 00:17:17
00:14:40 | 00:13:15 | 00:21:15 | 00:00:08 | 00:15:18 | 00:15:10 | 00:20:24 | 00:19:58
00:00:23 | 00:14:13 | 00:00:22 | 00:14:26 | 00:12:03 | 00:21:27 | 00:21:43 | 00:16:33
00:19:03 | 00:15:21 | 00:08:59 | 00:07:06 | 00:17:28 | 00:05:13 | 00:12:29 | 00:15:04
00:22:43 | 00:23:45 | 00:05:31 | 00:04:40 | 00:09:33 | 00:06:43 | 00:19:57 | 00:13:31
00:18:45 | 00:17:00 | 00:07:12 | 00:16:11 | 00:01:35 | 00:09:25 | 00:18:39 | 00:19:56
00:17:16 | 00:13:40 | 00:04:44 | 00:22:30 | 00:19:56 | 00:00:23 | 00:22:16 | 00:04:10
00:13:39 | 00:11:29 | 00:18:27 | 00:02:20 | 00:15:02 | 00:20:24 | 00:08:30 | 00:04:21
Spreadsheet: eric_saibi__9933__103001
Sheet: Antelope Valley 02

Owner Name |  | Basin Electric Power
Station Name |  | Antelope Valley Power Station
Unit Name |  | Antelope Valley 02
NERC Region |  | MAPP
State |  | ND
Fuel Type |  | Coal
Capacity |  | 435 MW
Start Date |  | 2001-10-27 00:00:00
End Date |  | 2001-10-30 00:00:00
Comments |  | They Have unit 2 down now with unplanned Valve repairs. Should have unit back online by the end of the day.
SIC |  | 4911
Plant ID |  | 1014375
Unit ID |  | 1007275
Outage ID |  | 18759
Spreadsheet: 553356d1514264344-how-paste-data-on-only-visible-cells-2
Sheet: Sheet1

 | 540 | MH28/AB-7013 | 200 | 18.015 | [NAME] | KARANJA | 18.03
 | 542 | MH27/X-3906 | 131 | 11.835 | [NAME] | KARANJA | 11.85
 | 544 | MH27/A-3510 | 201 | 18.1 | [NAME] | KARANJA | 18.14