tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2fc6d6ca-874f-4ed6-b41b-5c5a59d1f2df
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflowerseed | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 |  |  |  | Cents/pound
2001/02 | 16.46 | 17.98 | 23.25 | 23.45 | 32.23 | 19.14 | 13.55 | 13.87
2002/03 | 22.04 | 37.75 | 33.13 | 29.75 | 46.7 | 28.17 | 18.13 | 17.8
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/121 | 51.9 | 53.22 | 83.2 | 57.19 | 100.15 | 56.09 | 48.11 | 50.33
2012/131 | 53.0-57.0 | 55.0-59.0 | 85.0-89.0 | 58.5-62.5 | 98.0-102.0 | 57.5-61.5 | 49.0-53.0 | 48.5-52.5
2010/11
October | 44.02 | 47.2 | 56 | 51.45 | 71.4 | 47.5 | 46.64 | 37
November | 47.62 | 50.75 | 63 | 53.63 | 75.13 | 51.96 | 37.32 | 41.75
December | 51.51 | 54 | 62.9 | 58.25 | 77.9 | 54.71 | 38.3 | 45
January | 53.84 | 55.92 | 74.125 | 59.5 | 80.06 | 57.91 | 48.5 | 50.1
February | 54.21 | 56.75 | 85.625 | 60.13 | 79.63 | 63.39 | 49.6 | 49.9
March | 54.07 | 55.5 | 96.75 | 60.25 | 77.5 | 67.72 | 52 | 51.75
April | 56.65 | 57.7 | 101.2 | 62.05 | 78.7 | 68.89 | 51.5 | 52.83
May | 56.09 | 56.06 | 103.75 | 60.19 | 82.81 | 68.33 | 54.31 | 53.87
June | 55.68 | 55.25 | 103.25 | 59.56 | 78.5 | 66.7 | 56.75 | 57.41
July | 55.16 | 54.75 | 97 | 60.7 | 88.05 | 62 | 63 | 60.89
August | 54.39 | 54.75 | 95 | 60 | 95.56 | 62 | 58.96 | 56.35
September | 55.13 | 55.35 | 94.8 | 58.45 | 97.5 | 57.95 | 61.33 | 59.28
2011/12
October | 51.73 | 51.56 | 92.5 | 56.81 | 97 | 54.24 | 61.1 | 52.09
November | 51.44 | 50.5 | 91 | 56.13 | 98.75 | 53.98 | 48.86 | 45.51
December | 50.17 | 51.1 | 91 | 55.4 | 96.1 | 53.36 | 48.71 | 50.78
January | 50.99 | 52.19 | 88.75 | 55.06 | 95.81 | 54 |  | 51.1
February | 52.36 | 54.56 | 86 | 56.94 | 95 | 56.3 | 52.55 | 53.17
March | 53.43 | 55.95 | 82 | 59.1 | 96.6 | 59.31 | 54.6 | 52.24
April | 54.96 | 56.88 | 79 | 60.94 | 102.38 | 60.75 | 52.59 | 49
May | 50.69 | 52 | 80 | 55.88 | 106.13 | 58.05 | 54.82 | 55.48
June | 48.65 | 50.05 | 80.2 | 54.1 | 111 | 52.9 | 54.83 | 49.88
July | 51.96 | 53.75 | 78 | 57.44 | 110 | 54.76 | 53 | 49.13
August | 52.65 | 54.65 | 75 | 58.75 | 110 | 57.26 |  | 48.36
September1 | 53.81 | 55.5 | 75 | 59.75 | 104.5 | 58.21 |  | 47.19
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2012-10-17 11:41:56.250000
Spreadsheet: 51259d1250790957-points-formatting-book1-1-
Sheet: Sheet1

Player Name |  | WK 1 | WK2 | WK3 | WK4
[NAME] | 730 | 1 | 22 | 10 | 11 | 400 | 10 | 170 | 150
[NAME] | 680 | 2 | 21 | 9 | 12 | 340 | 20 | 190 | 130
[NAME] | 660 | 3 | 20 | 8 | 13 | 310 | 30 | 210 | 110
[NAME] | 650 | 4 | 19 | 7 | 14 | 290 | 40 | 230 | 90
Retief Goosen | 650 | 5 | 18 | 6 | 15 | 270 | 50 | 250 | 80
[NAME] | 650 | 6 | 17 | 5 | 16 | 250 | 60 | 270 | 70
[NAME] | 650 | 7 | 16 | 4 | 17 | 230 | 70 | 290 | 60
[NAME] | 650 | 8 | 15 | 3 | 18 | 210 | 80 | 310 | 50
[NAME] | 660 | 9 | 14 | 2 | 19 | 190 | 90 | 340 | 40
[NAME] | 710 | 10 | 13 | 1 | 20 | 170 | 110 | 400 | 30
[NAME] | 830 | 11 | 12 | 11 | 1 | 150 | 130 | 150 | 400
[NAME] Poulter | 750 | 12 | 11 | 12 | 2 | 130 | 150 | 130 | 340
[NAME] | 700 | 13 | 10 | 13 | 3 | 110 | 170 | 110 | 310
[NAME] | 660 | 14 | 9 | 14 | 4 | 90 | 190 | 90 | 290
[NAME] | 640 | 15 | 8 | 15 | 5 | 80 | 210 | 80 | 270
[NAME] | 620 | 16 | 7 | 16 | 6 | 70 | 230 | 70 | 250
[NAME] | 600 | 17 | 6 | 17 | 7 | 60 | 250 | 60 | 230
[NAME] | 580 | 18 | 5 | 18 | 8 | 50 | 270 | 50 | 210
[NAME] | 560 | 19 | 4 | 19 | 9 | 40 | 290 | 40 | 190
[NAME] | 540 | 20 | 3 | 20 | 10 | 30 | 310 | 30 | 170
[NAME] | 390 | 21 | 2 | 21 | 22 | 20 | 340 | 20 | 10
[NAME] | 440 | 22 | 1 | 22 | 21 | 10 | 400 | 10 | 20
 |  |  |  |  |  |  | VLOOKUP(B2;Sheet2!$A$2:$B$23;2;FALSE)
 |  |  |  |  | OK, this is formula (yeloow):
 |  |  |  |  | B2 looks what value to look. In your case WK1
 |  |  |  |  | green is defined table (you must put $)
 |  |  |  |  | 2 is 2nd row in table. You can define more column in table.
 |  |  |  |  | false (ignore for now)
 |  |  |  |  | You can add all of them into one column (green) but if you have too many columns (tournaments) maybe this is not best solution.
Spreadsheet: 755351d1636804491-averaging-only-some-data-in-a-row-of-cells-golf-group-spreadsheet
Sheet: Ball Exchange

 |  | JV | [NAME] | [NAME] | [NAME] | [NAME] | Gene | George | [NAME] | [NAME] | [NAME] | Mitch | Rich | [NAME] | [NAME] Mc | [NAME] | [NAME] | Byron
 | Any |  |  |  |  |  | X |  |  |  |  |  |  | X
 | Calloway Super Soft |  |  | X |  | X
 | Noodle |  |  |  | X
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | [NAME] |  |  |  |  |  |  |  | X
 | [NAME] |  |  |  |  |  |  |  |  | X |  |  |  |  | X
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | [NAME] |  |  |  |  |  |  |  | X
 | Titleist AVX |  |  |  |  | X
 | Titleist Pro V1 | X | X |  |  |  |  | X |  |  |  | X |  |  |  | X
 | Titleist Pro V1x | X | X
 | [NAME] |  | X
 | [NAME] |  |  | X
 | Titleist Velocity |  |  |  |  |  |  |  |  |  |  |  | X
 | Titleist [NAME] |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  | X
 | Vice |  |  |  |  |  |  |  |  |  | X
 | Wilson Staff |  | X |  |  |  |  |  |  |  |  |  |  |  |  | `
 | [NAME], premium |  |  |  |  |  |  |  |  |  |  |  | X
 | Bridgestone Tour Bxs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X
Spreadsheet: 221004d1363347630-i-need-help-transferring-across-data-from-one-sheet-to-another-excel-forum
Sheet: Imported Wholesale

Auto+Hide | Hide+? | hide
 |  |  | Packaging Waste - Wholesale
 |  | Source |  | 14/02/2012..31/12/2012
 |  | "MyDataSource","Helix UK LIVE","5404","1","$BBBBBB","2","EACH" | Item | [NAME] net of Returns | Code | Qty. Per unit of measure | Aluminium GSM | Electircal GSM | Paper GSM | Plastic GSM | Steel GSM
Auto |  |  | A06010
Auto |  |  | A06010
Auto |  |  | A06010
Auto |  |  | A06010
Auto |  |  | A06990
Auto |  |  | A08000
Auto |  |  | A08000
Auto |  |  | A08000
Auto |  |  | A08000
Auto |  |  | A08002
Auto |  |  | A08002
Auto |  |  | A08002
Auto |  |  | A08002
Auto |  |  | [NAME]
Auto |  |  | [NAME]
Auto |  |  | [NAME]
Auto |  |  | [NAME]
Auto |  |  | A09000
Auto |  |  | A09000
Auto |  |  | A09000
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 23

 |  | Transactions
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated swap transaction volumes, week ending December 14, by product type, participant type, and cleared status (in number of transactions), all tenors, currencies, and deliveries. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
**Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: chris_germany__1882__Ogleth200105
Sheet: external

DOYLE |  | Deals 774072, 774087, 774325
May    2001
 | GAS [NAME] |  |  |  |  |  | PURCHASE |  | TRANSPORT
 |  | PURCHASES |  |  |  |  | [NAME] |  | COMMODITY |  | DAILY TRANS
 | DAY AHEAD | RECEIPT | DELIVERY | [NAME] | IMBALANCE |  |  |  | FT | IT @ .1861 | COST
DAY | REQUEST |  |  |  |  |  |  |  | zero |  | DEL'd x Comm.
2001-05-01 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0328 | 0.1861
 | 0
 | 0 |  | 4250 | 4027 |  |  | 4.9
 | 0 |  |  | 5 |  |  |  |  |  |  | 0
 | 0 |  |  | 0 |  |  |  |  |  |  | 0
 | 0
 | 0
 | 0 | 4500
 | 0 | 10000 |  | 6586 |  |  |  |  |  |  | 0
 | 0 | 10000 |  |  |  |  |  |  |  |  | 0
 | 0 | 5500 |  |  |  |  |  |  |  |  | 0
 | 0 | 0 |  | 0
 | 0 |  |  | 0
 | 0
 | 0 |  |  | 5
 | 0 |  |  | 0
 | 0 | 32000 |  | 34031 |  |  | 4.4
 | 0 | 15000
 | 0 | 0 |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 0
 | 0
 | 0 | 1893
 | 0 | 0 |  |  |  |  |  |  |  |  | 0
 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | BOLD DATE = PIPELINE ACTUALS
 | DAY AHEAD REQUEST = "Schedule 8's" total MW x heat rate estimate of 12.1
 | All gas for month purchased delivered…no transport costs or fuel losses.
 | Ending balance to be cashed out via [NAME]'s published [NAME] IT rate.
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Case Closure

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Closure
Activity Name | Case Closure
Activity Description / Purpose | Due to a change causing the client to become ineligible, the case record will be closed and end the client’s benefits.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Receive documentation/decision/report
Determine case needs to be closed
Determine eligibility for transitional benefits
Enter information into system
Send client notice of action
Update case folder
Route to "Close files"
Determine if referral is needed
Cancel closing
Spreadsheet: 217342d1362048339-looking-up-value-by-closest-match-and-determining-cell-address-test
Sheet: Sheet1

 |  | Inside Diameters ([NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  | Calculated Value
 |  | Schedule |  |  |  |  |  |  |  |  |  |  | 273.45 | [NAME]
 |  | 5s | 10s | 10 | 20 | 40s | 40 | 80s | 80 | 160 | Double Extra Strong
NB (") |  |  | 7.81 |  |  | 6.83 | 6.83 | 5.47 | 5.47 |  |  |  | Required pipe
 |  |  | 10.42 |  |  | 9.24 | 9.24 | 7.68 | 7.68
 |  |  | 13.58 |  |  | 12.53 | 12.53 | 10.75 | 10.75
 |  | 18.04 | 17.12 |  |  | 15.8 | 15.8 | 13.88 | 13.88 | 11.84 | 6.4 |  |  | 1st attempt
 |  | 23.37 | 22.45 |  |  | 20.93 | 20.93 | 18.85 | 18.85 | 15.59 | 11.03 |  |  | 2nd attempt Simplified
 | 1 | 30.1 | 27.85 |  |  | 26.64 | 26.64 | 24.3 | 24.3 | 20.7 | 15.22 |  |  | 3rd Attempt
 |  | 38.26 | 36.62 |  |  | 35.04 | 35.04 | 32.46 | 32.46 | 29.46 | 22.76
 | 1.5 | 44.96 | 42.72 |  |  | 40.88 | 40.88 | 38.1 | 38.1 | 33.98 | 27.94 |  |  | << Text, thus not much can be done with this
 | 2 | 57.03 | 54.79 |  |  | 52.51 | 52.51 | 49.25 | 49.25 | 42.91 | 38.19
 | 2.5 | 68.81 | 66.93 |  |  | 62.71 | 62.71 | 59.01 | 59.01 | 53.97 | 44.99
 | 3 | 64.68 | 82.8 |  |  | 77.92 | 77.92 | 73.66 | 73.66 | 66.64 | 58.42
 | 3.5 | 97.38 | 95.5 |  |  | 90.12 | 90.12 | 85.44 | 85.44
 | 4 | 110.08 | 108.2 |  |  | 102.26 | 102.26 | 97.18 | 97.18 | 87.32 | 80.06
 | 5 | 135.76 | 134.5 |  |  | 128.2 | 128.2 | 122.24 | 122.24 | 100.54 | 103.2
 | 6 | 162.74 | 161.48 |  |  | 154.06 | 154.06 | 146.34 | 146.34 | 131.8 | 124.38
 | 8 | 213.54 | 211.56 |  | 206.38 | 202.72 | 202.72 | 193.68 | 193.68 | 173.06 | 174.64
 | 10 | 266.25 | 264.57 |  | 260.35 | 254.51 | 254.51 | 247.65 | 242.93 | 215.89
 | 12 | 315.93 | 314.71 |  | 311.15 | 304.79 | 303.23 | 298.45 | 288.95 | 257.19
 | 14 | 347.68 | 346.05 | 342.9 | 339.76 | 336.54 | 333.34 | 330.02 | 317.5 | 284.18
 | 16 | 398.02 | 396.04 | 393.7 | 390.56 | 387.34 | 381.09 | 381.09 | 363.58 | 325.48
 | 18 | 448.82 | 447.64 | 444.5 | 441.36 | 438.14 | 428.66 | 431.8 | 409.6 | 366.72
 | 20 | 496.44 | 496.94 | 495.3 | 488.94 | 488.94 | 477.88 | 482.6 | 455.62 | 408.02
 | 24 | 598.52 | 596.9 | 596.9 | 590.54 | 590.54 | 574.7 | 584.2 | 547.72 | 490.58
Spreadsheet: 699039d1602346148-generic-formula-to-sort-multivalues-in-specific-order-sort-multiple-in-correct-order_new
Sheet: Sheet1

 |  |  |  |  |  |  |  | Expected
Specific | All |  | 4 | 1 | 3 | 2 |  | 4 | 1 | 3 | 2
red | blue§green§red§yellow |  |  |  |  |  |  | yellow | red | green | blue
yellow | yellow |  |  |  |  |  |  |  | yellow
green | red§blue§green |  |  |  |  |  |  |  | green | blue | red
blue | red§yellow |  |  |  |  |  |  |  | red |  | yellow
green
 | green |  |  |  |  |  |  |  | green
 |  |  |  | blue | green | yellow |  |  | red | green | blue
 |  |  | yellow |  |  |  |  |  | yellow
 |  |  | green | red | blue |  |  |  | green | blue | red
 |  |  | red | yellow |  |  |  |  | red |  | yellow
 |  |  | green |  |  |  |  |  | green
Spreadsheet: 685785d1594196073-split-5-parameters-separated-by-and-into-series-of-columns-pq-5-parameter-test-aligw
Sheet: Input

Product | 1 | 2 | 3 | 4 | 5
101 | 0219A&1&January&PC&4 | 0219B&3&February&PC&2 | 0219C&2&March&PM&2 | 0219C&2&March&PM&2 | 0219C&2&March&PM&2
102 | 0220A&1&January&PC&4 | 0220B&3&February&PC&2 | 0220C&2&March&PM&2 | 0220C&2&March&PM&2 | 0220C&2&March&PM&2
103 | 0221A&1&January&PC&4 | 0221B&3&February&PC&2 | 0221C&2&March&PM&2 | 0221C&2&March&PM&2 | 0221C&2&March&PM&2
Spreadsheet: 865815d1712796565-averages-from-a-table-based-on-a-day-of-the-week-and-beginning-ending-time-average-days-times-02-eba
Sheet: Sheet1

FRIDAY
START TIME | END TIME | NUMBER OF TRANSACTIONS | TOTAL SUM ALL CASHIERS | TOTAL SUM WAREHOUSE
00:00:00 | 00:59:59
01:00:00 | 01:59:59
02:00:00 | 02:59:59
03:00:00 | 03:59:59
04:00:00 | 04:59:59
05:00:00 | 05:59:59
06:00:00 | 06:59:59
07:00:00 | 07:59:59
08:00:00 | 08:59:59
09:00:00 | 09:59:59
10:00:00 | 10:59:59
11:00:00 | 11:59:59
12:00:00 | 12:59:59
13:00:00 | 13:59:59
14:00:00 | 14:59:59
15:00:00 | 15:59:59
16:00:00 | 16:59:59
17:00:00 | 17:59:59
18:00:00 | 18:59:59
19:00:00 | 19:59:59
20:00:00 | 20:59:59
21:00:00 | 21:59:59
22:00:00 | 22:59:59
23:00:00 | 23:59:59
Spreadsheet: 272261d1382318756-formula-for-running-balance-of-stock-levels-runningbalexample
Sheet: Sheet1

Order | X | Date | Customer | Item Code | QNTY BO | SOH | RUNNING BAL
11111 | A | 2013-07-22 00:00:00 | CUST! | 17482-1 | -1 | 9 | 8
22222 | B | 2013-10-15 00:00:00 | CUST2 | 17482-1 | -3 | 9 | 5
22222 | B | 2013-10-15 00:00:00 | CUST3 | 88845-56 | -2 | 115 | 113
22553 | A | 2013-09-27 00:00:00 | CUST3 | FH7465 | -1 | 1 | 0
22687 | A | 2013-10-04 00:00:00 | CUST4 | FH7465 | -2 | 1 | -2
33240 | A | 2013-10-01 00:00:00 | CUST5 | FH7465 | -1 | 1 | -3
Spreadsheet: 126570d1319747749-excel-2007-grouping-in-pivot-tables-pivotdatatwotables
Sheet: Sheet1

Date | Amt
Spreadsheet: 275543d8-74a2-4031-a6ae-699f1a3bc9c1
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
 | 6457.0 International Trade Price Indexes, Australia
 | Tables 10 and 11. Export Price Index by Balance of Payments classification of exports, Index Numbers
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
Index Numbers ;  Rural goods total ; |  |  | Original | A2295687L | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Meat and meat preparations ; |  |  | Original | A2295693J | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Cereal grains and cereal preparations ; |  |  | Original | A2295696R | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Wool and sheepskins ; |  |  | Original | A2295699W | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Other rural ; |  |  | Original | A2295702X | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Non-rural goods total (excluding non-monetary gold) ; |  |  | Original | A2295690A | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Metal ores and minerals ; |  |  | Original | A2295705F | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  [NAME], coke and briquettes ; |  |  | Original | A2295708L | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Other minerals ; |  |  | Original | A2295711A | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  [NAME] (excluding non-monetary gold) ; |  |  | Original | A2295714J | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Machinery ; |  |  | Original | A2295717R | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Transport equipment ; |  |  | Original | A2295720C | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Other manufactures ; |  |  | Original | A2295723K | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Other non-rural ; |  |  | Original | A2295726T | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  Non-monetary gold ; |  |  | Original | A2295681X | 1989-09-01 00:00:00 | 2011-12-01 00:00:00 | 90 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: mark_guzman__24552__west prices1009
Sheet: Power West Price Peak

 |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
Peak | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Price change |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
Peak | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
 |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
Peak | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA | 0 | 123 | 110 | 107 | 113.3333333333333 | 83 | 67.5 | 137.6666666666667 | 82.16666666666667 | 92.58333333333333 | 64.85416666666667 | 56.99982500000001 | 33.5618356060606 | 24.97850227272728 | 72.10606060606061 | 42.72850227272726 | 43.34372518939394
COB | 0 | 129 | 112 | 110 | 117 | 82 | 67.16666666666667 | 140.3333333333333 | 78.5 | 92 | 66.16666666666667 | 58.68732500000001 | 38.78699833333333 | 32.95366499999999 | 83.03333333333333 | 47.20366499999999 | 50.49441541666666
NP15 | 0 | 123 | 99 | 94.25 | 105.4166666666667 | 75.25 | 60 | 119.3333333333333 | 67.33333333333333 | 80.47916666666666 | 61.16666666666666 | 56.56166666666667 | 36.94484848484848 | 35.6360606060606 | 68.67030303030302 | 42.74763447406666 | 45.99971164881968
ZP26 | 0 | 100 | 75 | 73 | 82.66666666666667 | 66.33333333333333 | 60 | 118.1666666666667 | 59.66666666666666 | 76.04166666666667 | 55.25833333333333 | 47.02333333333333 | 32.92405641291082 | 33.67630517976258 | 59.52122530843663 | 34.78605445748052 | 40.22691033964764
SP15 | 0 | 100 | 75 | 73 | 82.66666666666667 | 66.33333333333333 | 68.33333333333333 | 119.3333333333333 | 59.66666666666666 | 78.41666666666667 | 56.71666666666667 | 47.04083333333333 | 32.92405641291082 | 35.51642746661356 | 59.52122530843663 | 34.78605445748052 | 40.68694091136038
Palo Verde | 0 | 103 | 75 | 73.5 | 83.83333333333333 | 66.33333333333333 | 72.66666666666667 | 140 | 61.33333333333334 | 85.08333333333333 | 57.46701806279018 | 47.76099331754367 | 32.09406882237991 | 36.46391249280836 | 58.14521446680262 | 34.28480562116557 | 40.24700035078912
ROCKIES | 0 | 103 | 75 | 93.5 | 90.5 | 86.33333333333333 | 92.66666666666667 | 160 | 81.33333333333333 | 105.0833333333333 | 77.46701806279019 | 67.76099331754367 | 52.0940688223799 | 56.46391249280836 | 78.14521446680261 | 54.28480562116555 | 60.24700035078911
Spreadsheet: 224481d1364580527-combine-two-lists-excel-help
Sheet: Combination

Credit? | Invoice # | Their Amount | Our Date | Account # | Our Amount | Offage | Subtotal |  | Credit? | Invoice # | Their Amount | Our Date | Account # | Our Amount | Offage | Subtotal
Spreadsheet: 762794d1641821733-display-result-based-on-2-criterias-excel-forum-2021-01-10
Sheet: Sheet1

 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 |  | Date | Name | Sales |  |  | Name | 2022.01.01 | 2022.01.02 | 2022.01.03
Alpha |  |  |  |  | 2022-01-01 00:00:00 | Alpha | 10 |  |  | Alpha | 10 | 15 | 101
Beta |  |  |  |  | 2022-01-01 00:00:00 | Beta | 20 |  |  | Beta | 20 | 25 | 202
Gamma |  |  |  |  | 2022-01-01 00:00:00 | Gamma | 30 |  |  | Epsilon | 40 | 45 | 404
Epsilon |  |  |  |  | 2022-01-01 00:00:00 | Epsilon | 40 |  |  | Gamma | 30 | 35 | 303
 |  |  |  |  | 2022-01-02 00:00:00 | Alpha | 15
 |  |  |  |  | 2022-01-02 00:00:00 | Beta | 25
 |  |  |  |  | 2022-01-02 00:00:00 | Gamma | 35
 |  |  |  |  | 2022-01-02 00:00:00 | Epsilon | 45
 |  |  |  |  | 2022-01-03 00:00:00 | Alpha | 101
 |  |  |  |  | 2022-01-03 00:00:00 | Beta | 202
 |  |  |  |  | 2022-01-03 00:00:00 | Gamma | 303
 |  |  |  |  | 2022-01-03 00:00:00 | Epsilon | 404