tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 797484d1663920151-use-smaller-than-in-getpivotdata-formula-test
Sheet: Sheet1

 |  |  |  |  | Month | Product | Amount
 |  |  |  |  | 1 | Appels | 23
 |  |  |  |  | 1 | Pears | 16
 |  |  |  |  | 2 | Appels | 63
 |  |  |  |  | 2 | Pears | 5 |  |  |  |  |  |  | Sum of Amount | Column Labels
 |  |  |  |  | 3 | Appels | 12 |  |  |  |  |  |  | Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Grand Total
 |  |  |  |  | 3 | Pears | 85 |  |  |  |  |  |  | Appels | 23 | 63 | 12 | 45 | 12 | 45 | 52 | 25 | 63 | 43 | 64 | 25 | 472
 |  |  |  |  | 4 | Appels | 45 |  |  |  |  |  |  | Pears | 16 | 5 | 85 | 63 | 78 | 61 | 12 | 85 | 23 | 38 | 42 | 51 | 559
 |  |  |  |  | 4 | Pears | 63 |  |  |  |  |  |  | Grand Total | 39 | 68 | 97 | 108 | 90 | 106 | 64 | 110 | 86 | 81 | 106 | 76 | 1031
 |  |  |  |  | 5 | Appels | 12
 |  |  |  |  | 5 | Pears | 78
 |  |  |  |  | 6 | Appels | 45
 |  |  |  |  | 6 | Pears | 61
 |  |  |  |  | 7 | Appels | 52
 |  |  |  |  | 7 | Pears | 12
 |  |  |  |  | 8 | Appels | 25
 |  |  |  |  | 8 | Pears | 85 |  |  |  | Get sum of all appels before 6th month
 |  |  |  |  | 9 | Appels | 63
 |  |  |  |  | 9 | Pears | 23
 |  |  |  |  | 10 | Appels | 43
 |  |  |  |  | 10 | Pears | 38
 |  |  |  |  | 11 | Appels | 64
 |  |  |  |  | 11 | Pears | 42 |  |  |  | =GETPIVOTDATA("Amount",$O$7,"Month",<6,"Product","Appels")
 |  |  |  |  | 12 | Appels | 25
 |  |  |  |  | 12 | Pears | 51 |  |  |  | I was hoping this would work
Spreadsheet: 854462d1704324850-if-then-multiple-criteria-with-an-end-result-of-changing-a-cell-a-color-time-example-vertical
Sheet: Sheet1

 | Department | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00
 | A
 | B
 |  | *Notes
 |  | In each Cell above in the blue section
 |  | Example: In Cell "C5", I'd like to reference the Department "A" to the table on Sheet2. If the date/time matchs and falls withing the time range then change the color of this cell to Green
 |  | So in Cell C8, since this block falls within the table in Sheet 2 it will meet the criteria and Change colors
 |  | End Result:
 |  | Also could this work if I needed it to span over multiple days like the "Department B" row example in Sheet2?
 |  | End Result:
Spreadsheet: 142905d1330083108-sumproduct-groups-of-data-excelforum
Sheet: Sheet1

 | DATE | AMMOUNT | ANIMAL |  |  |  |  | THIS WORKS |  |  |  | NEED THIS
 | 2012-01-02 00:00:00 | -10 | COW |  |  | [NAME] |  | DOG | 2012-01-01 00:00:00 | 2012-01-31 00:00:00 |  | ALEX | 2012-01-01 00:00:00 | 2012-01-31 00:00:00
 | 2012-01-04 00:00:00 | -11.28 | LEOPARD |  |  | DOG
 | 2012-01-04 00:00:00 | 431.76 | SNAKE |  |  | SNAKE |  | RESULT |  | -42.4 |  | RESULT | -42.4
 | 2012-01-05 00:00:00 | -4.29 | BIRD |  |  | COW
 | 2012-01-08 00:00:00 | -41.16 | COW |  |  | LEOPARD
 | 2012-01-08 00:00:00 | -409.99 | FISH
 | 2012-01-08 00:00:00 | -2.71 | LEOPARD |  |  | ALEX
 | 2012-01-15 00:00:00 | -20.35 | [NAME] |  |  | DOG
 | 2012-01-15 00:00:00 | 11.52 | SNAKE |  |  | [NAME]
 | 2012-01-18 00:00:00 | -3.95 | COW |  |  | HORSE
 | 2012-01-19 00:00:00 | -1.1 | HORSE |  |  | LEOPARD
 | 2012-01-20 00:00:00 | -6.96 | DOG
 | 2012-01-20 00:00:00 | -11 | COW |  |  | MONIQUE
 | 2012-01-28 00:00:00 | -11.75 | HORSE |  |  | FISH
 | 2012-01-28 00:00:00 | -54.99 | FISH |  |  | BIRD
 | 2012-02-01 00:00:00 | -21.19 | DOG
 | 2012-02-01 00:00:00 | -54 | LEOPARD
 | 2012-02-05 00:00:00 | -12.34 | HORSE
 | 2012-02-05 00:00:00 | -89 | BIRD
 | 2012-02-07 00:00:00 | 25.88 | DOG
 | 2012-02-08 00:00:00 | -4.75 | COW
 | 2012-02-10 00:00:00 | -16.5 | [NAME]
 | 2012-02-13 00:00:00 | -9.49 | SNAKE
Spreadsheet: 22123d1210694918-spread-sheet-formulas-and-drop-down-orders
Sheet: Rank & Pay Rate

 | Name the Hilighted list for data validation
 |  | Rank | 1 UTA
 |  | E1 | 44.9
 |  | E2 | 50.33
 |  | E3 | 59.66
 |  | E4 | 71.77
 |  | E5 | 90.18
 |  | E6 | 97.68
 |  | E7 | 108.77
 |  | E8 | 121.23
 |  | E9 | 141.82
 |  | CW1 | 118.76
 |  | CW2 | 128.93
 |  | CW3 | 141.83
 |  | CW4 | 151.82
 |  | CW5 | 208.71
 |  | 2LT | 107.17
 |  | 1LT | 135.81
 |  | CPT | 171.9
 |  | MAJ | 193.3
 |  | LTC | 203.77
 |  | COL | 233.88
Spreadsheet: phillip_m_love__30259__OntFRED
Sheet: FVar

Financial Liquidation Variances
Flash Perspective: Gas Acct to Review
TAGG | [NAME] | VLookupGL | [NAME] |  | Desk Adjustment | GL Adjustment/Reclass | Comments
NL3318.B | -3049644 | -3049644
NN6701.1 | 14225 | -931200
NK4224.1 | 211794.58 | -211726.91
NJ7495.1 | 179200 | -179220
NK5155.2 | 118661.5604 | -118661.63
NK6490.2 | 84950 | -84941
NK5853.2 | 77800 | -77790
NK5531.2 | 71800 | -71790
NI0331.1 | 58300.03 | -58290.03
NK4980.2 | 58300 | -58290
NJ8350.1 | 49850 | -49860
NM8493.2 | 38750 | -38752
NM7361.2 | 32350 | -32352
NL8089.1 | -26900 | -26910
NL2918.2 | 25450 | -25452
NM7023.2 | 23150 | -23154
NL1165.2 | -13425 | -13426
NL1165.1 | -12725 | -12726
NK3755.1 | 12400 | -12390
NN0937.2 | 5000 | -4995
NK3697.1 | 4900 | -4890
NH2542.H | -3584466.0528 | 0
NH4747.1 | -1186000 | 0
NN2751.2 | -1142208.969 | 0
NH2542.C | -646713.9297 | 0
NK4467.2 | -35099.94 | 0
NK5567.2 | -6900.06 | 0
[NAME] | -5849.97 | 0
NI0300.1 | -4200.03 | 0
NN2751.5 | -4059.6888 | 0
NK4965.2 | -3299.97 | 0
NJ8973.2 | -3240.027 | 0
NH2933.2 | -2700.03 | 0
NH2956.2 | -2700.03 | 0
NG2539.2 | -1200.03 | 0
NG3435.2 | -1199.985 | 0
NI0304.2 | -899.91 | 0
NH9506.2 | -299.97 | 0
NG3354.2 | 600.015 | 0
NH2403.2 | 600.015 | 0
[NAME] | 600.015 | 0
NK5152.2 | 2437.7972 | 0
NH9762.1 | 4200.03 | 0
NK5484.2 | 4950.03 | 0
NK2759.2 | 6300.015 | 0
NK5134.2 | 10835.5368 | 0
NK4571.2 | 14549.97 | 0
NK4538.2 | 35099.94 | 0
NK4511.2 | 36599.94 | 0
NK4451.2 | 38099.94 | 0
[NAME] | 269025 | 0
NH2542.E | 646713.9297 | 0
NH2542.A | 3413130.3639 | 0
NO1121.2 | -2475 | 2474.5
NM9636.2 | -7750 | 7755
NL0764.1 | 8200 | 8204
NN1072.1 | 9250 | 9255
[NAME] | 10212.5 | 10208
NL1138.2 | -25450 | 25452
NM7651.1 | 28350 | 28352
NJ9548.1 | -29600 | 29610
[NAME] | -35275 | 35280
NK9451.1 | 42900 | 42891
[NAME] | -44250 | 44253
[NAME] | -45250 | 45255
NK4144.1 | -131579.871 | 77399.87
NK6115.2 | 79150 | 79141
NL0076.4 | -87344.12700000001 | 87341.1
NL9853.1 | -90700 | 90706
NK6115.1 | 92200 | 92191
NI6055.1 | 537750 | 537750
NL3287.1 | 613768 | 613768
Spreadsheet: 42d2c49c-6205-48e7-8177-b52d4dcb67be
Sheet: Sheet1

Portland Facility: Inventory Status of Sauces
As of June 30
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price
[NAME]:
Steak Types:
Quantity in Stock | Item Number | Item Name | Retail Price | Size | Category | Stock Level
45 | 2582 | [NAME] | 6.59 | 8 oz. | Finishing/Glaze
85 | 2894 | Champagne Shallot | 6.35 | 8 oz. | Finishing/Glaze
23 | 2968 | Baked Acorn Squash | 7.59 | 11 oz. | Finishing/Glaze
49 | 2485 | Maple Chipotle | 9.69 | 15 oz. | Steak
26 | 2892 | Roasted Garlic Peanut | 9.59 | 14 oz. | Eastern
49 | 2642 | Vidalia Onion Fig | 8.59 | 12 oz. | Hot
46 | 2893 | Curried Mango | 7.59 | 13 oz. | BBQ/Grilling
36 | 2954 | Roasted Pepper Sesame | 6.75 | 12 oz. | Eastern
46 | 2647 | Honey | 5.59 | 8 oz. | BBQ/Grilling
13 | 2877 | [NAME] | 6.89 | 9 oz. | Finishing/Glaze
62 | 2934 | [NAME] | 7.95 | 8 oz. | Eastern
26 | 2365 | [NAME] | 5.69 | 6 oz. | Hot
26 | 2678 | Roasted Apple | 7.49 | 9 oz. | BBQ/Grilling
36 | 2783 | [NAME] | 5.95 | 10 oz. | Steak
43 | 2493 | Sesame [NAME] | 8.95 | 12 oz. | Eastern
28 | 2895 | [NAME] | 9.59 | 15 oz. | Eastern
62 | 2978 | Roadhouse | 7.59 | 12 oz. | Steak
46 | 2554 | Mesquite | 7.75 | 12 oz. | Steak
46 | 2534 | [NAME] | 8.35 | 12 oz. | Steak
39 | 2312 | [NAME] | 7.95 | 12 oz. | Steak
36 | 2444 | Pomegranate | 9.59 | 10 oz. | BBQ/Grilling
29 | 2564 | Roasted Tomato | 5.95 | 6 oz. | BBQ/Grilling
46 | 2664 | Black Olive | 6.95 | 10 oz. | [NAME]
36 | 2696 | Basil | 8.59 | 10 oz. | [NAME]
46 | 2553 | Sun Dried Tomato | 8.59 | 9 oz. | [NAME]
46 | 2698 | Artichoke | 9.59 | 8 oz. | [NAME]
56 | 2841 | Sun Dried Tomato and Olive | 8.59 | 7 oz. | [NAME]
26 | 2897 | Maple Chipotle | 9.59 | 13 oz. | BBQ/Grilling
28 | 2345 | New England Cranberry | 9.59 | 12 oz. | Cocktail
49 | 2489 | Spicy Horseradish | 8.59 | 10 oz. | Cocktail
65 | 2347 | [NAME] | 9.65 | 12 oz. | Cocktail
49 | 2999 | [NAME] | 8.49 | 8 oz. | Cocktail
42 | 2668 | Black Truffles | 10.95 | 6 oz. | Finishing/Glaze
37 | 2598 | [NAME] | 9.59 | 8 oz. | Finishing/Glaze
45 | 2223 | Organic Tomato and [NAME] | 6.99 | 12 oz. | Pasta
56 | 2225 | Organic Arrabbiata | 7.95 | 14 oz. | Pasta
48 | 2288 | [NAME] Tomato | 8.59 | 14 oz. | Pasta
55 | 2333 | Tomato Puree | 7.59 | 10 oz. | Pasta
65 | 2446 | Organic Ortolana | 6.59 | 9 oz. | Pasta
45 | 2336 | Genovese | 8.95 | 8 oz. | [NAME]
42 | 2465 | Organic Carli | 9.95 | 8 oz. | [NAME]
32 | 2963 | Asparagus Tip | 24.95 | 16 oz. | Pasta
29 | 2433 | [NAME] | 19.59 | 16 oz. | Pasta
65 | 2556 | [NAME] | 12.59 | 12 oz. | Pasta
28 | 2113 | Mushroom Cream | 16.95 | 16 oz. | Pasta
49 | 2221 | Vodka Tomato | 8.59 | 12 oz. | Pasta
23 | 2116 | [NAME] | 6.95 | 8 oz. | Eastern
37 | 2616 | [NAME] | 7.89 | 10 oz. | BBQ/Grilling
46 | 2119 | [NAME] | 6.95 | 8 oz. | Cocktail
32 | 2457 | Tequila Lime | 7.59 | 9 oz. | Cocktail
23 | 2396 | Red Pepper | 6.95 | 8 oz. | Hot
29 | 2398 | Spicy Jerk | 6.95 | 7 oz. | Hot
36 | 2663 | Habanero | 5.95 | 8 oz. | Hot
46 | 2455 | Jalapeno | 7.59 | 10 oz. | Hot
49 | 2346 | [NAME] | 9.59 | 12 oz. | Hot
Spreadsheet: 744790d1629455301-finding-maximum-of-column-totals-by-dates-maximum-of-column-totals-by-dates
Sheet: Sheet1

 | Maximum of column totals by dates
 | Date | Count1 | Count2 | Count3 | Count4 | MaxCount |  |  | For 01/08/21
 | 2021-08-01 00:00:00 | 1 | 1 | 1 | 0 |  |  |  | Count1 = 1 + 0 + 1 = 2
 | 2021-08-01 00:00:00 | 0 | 1 | 0 | 0 |  |  |  | Count2 = 1 + 1 + 1 = 3
 | 2021-08-01 00:00:00 | 1 | 1 | 0 | 0 |  |  |  | Count3 = 1 + 0 + 0 = 1
 | 2021-08-02 00:00:00 | 0 | 1 | 0 | 0 |  |  |  | Count4 = 0 + 0 + 0 = 0
 | 2021-08-02 00:00:00 | 1 | 1 | 1 | 1 |  |  |  | MaxCount = MAX(2,3,1,0) = 3
 | 2021-08-02 00:00:00 | 0 | 1 | 0 | 1
 | 2021-08-02 00:00:00 | 1 | 1 | 1 | 0
 | 2021-08-02 00:00:00 | 1 | 0 | 1 | 1
 | 2021-08-03 00:00:00 | 0 | 1 | 1 | 0
 | 2021-08-03 00:00:00 | 1 | 1 | 0 | 1
 | 2021-08-03 00:00:00 | 1 | 1 | 0 | 0
 | 2021-08-03 00:00:00 | 1 | 0 | 1 | 1
 | 2021-08-03 00:00:00 | 1 | 0 | 0 | 0
 | 2021-08-03 00:00:00 | 0 | 0 | 0 | 0
 | 2021-08-03 00:00:00 | 1 | 0 | 0 | 0
 | 2021-08-03 00:00:00 | 1 | 1 | 1 | 1
 | 2021-08-03 00:00:00 | 1 | 0 | 0 | 0
 | 2021-08-03 00:00:00 | 0 | 0 | 1 | 0
 | 2021-08-03 00:00:00 | 0 | 1 | 0 | 0
 | 2021-08-03 00:00:00 | 1 | 0 | 1 | 0
 | 2021-08-03 00:00:00 | 1 | 1 | 0 | 0
Spreadsheet: 176fd333-d34c-4a40-b23d-8b2bf0b6bcf2
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2012/13 |  |  |  | 2011/12
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 14 |  | 8176 |  | 12.4 |  | 9343 |  | 16.6 |  | 2680 |  | 18.9 |  | 2091
September | 13.8 |  | 9172 |  | 13.7 |  | 10310 |  | 17.8 |  | 1458 |  | 17.6 |  | 2394
October | 13.9 |  | 11849 |  | 14.1 |  | 8703 |  | 15.7 |  | 2698 |  | 17 |  | 3367
November | 14 |  | 12784 |  | 13.9 |  | 7205 |  | 16 |  | 2988 |  | 17.7 |  | 4199
December | 14.1 |  | 11332 |  | 13.8 |  | 9947 |  | 16.1 |  | 3831 |  | 17.5 |  | 4677
January | 14.4 |  | 13973 |  | 13.6 |  | 9455 |  | 15 |  | 4720 |  | 17.8 |  | 5598
February | 14.6 |  | 11895 |  | 13.3 |  | 9926 |  | 15.8 |  | 2134 |  | 16.5 |  | 3629
March | 14.7 |  | 10765 |  | 13 |  | 10050 |  | 16.2 |  | 3010 |  | 16.5 |  | 4632
April | 14.8 |  | 9548 |  | 13.3 |  | 9432 |  | 16.5 |  | 2898 |  | 17.2 |  | 3879
May | 15.4 | 1/ |  |  | 13.3 |  | 9698 |  | 16.7 | 1/ |  |  | 16.5 |  | 3429
June |  |  |  |  | 13.5 |  | 7129 |  |  |  |  |  | 15.8 |  | 3381
July |  |  |  |  | 13.5 |  | 8037 |  |  |  |  |  | 16.6 |  | 3343
Average to date 2/ | 14.37 |  |  |  |  |  |  |  | 16.24
Season-average farm price | 14.4 | 3/ |  |  | 13.4 |  |  |  | 16.1 | 3/ 4/ |  |  | 17.1
Average marketings |  |  | 11054.88888888889 |  |  |  | 9102.916666666666 |  |  |  | 2935.222222222222 |  |  |  | 3718.25
Total volume marketed |  |  | 99494 |  |  |  | 109235 |  |  |  | 26417 |  |  |  | 44619
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
4/ The medium/short-grain season-average- farm price ([NAME]) largely reflects rice that is marketed through
price pools in California. The pool price is not final until all the rice in the pool is marketed for the crop year.
Therefore, [NAME] forecasts based on the average of NASS monthly prices and the final price may differ.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated June 14, 2013.
Spreadsheet: 124512d1318448243-need-a-formula-to-make-excel-search-for-info-book1
Sheet: Worksheet 1

 |  | Member | Location Number | Building Number | Location Name | Building Description
 |  | 001 | 001 | 001
 |  | 001 | 001 | 014
 |  | 001 | 001 | 015
 |  | 001 | 001 | 016
 |  | 001 | 001 | 017
Spreadsheet: louise_kitchen__22523__New Counterparties
Sheet: Year Over Year

Enron North America
New EOL Customers
2001 Actuals vs. Target
 |  | 1Q01 | 1Q01 Target | [NAME]) |  | 2Q01 | 2Q01 Target | [NAME]) |  | 3Q01 | 3Q01 Target | [NAME]) |  | 4Q01 | 4Q01 Target | [NAME]) |  | YTD 01 | YTD 01 Target | [NAME]) | % increase
Canada
Canada Power- Alberta |  | 0 | 8 |  |  | 1 | 8 |  |  | 0 | 8 |  |  | 0 | 8
Canada Power- Eastern |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | 0
Canada Gas |  | 2 | 5 |  |  | 1 | 5 |  |  | 0 | 5 |  |  | 0 | 5
US Natural Gas
Central Gas |  | 4 | 3 |  |  |  | 3 |  |  | 0 | 3 |  |  | 0 | 3
East Gas |  | 5 | 5 |  |  |  | 5 |  |  | 0 | 5 |  |  | 0 | 5
West Gas |  | 3 | 4 |  |  | 1 | 4 |  |  | 0 | 4 |  |  | 0 | 4
Texas Gas |  | 2 | 6 |  |  | 1 | 6 |  |  | 0 | 6 |  |  | 0 | 6 |  |  |  |  |  | 0
Financial |  | 3 | 0 |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0
East Power
ERCOT |  | 0 | 6 |  |  | 0 | 6 |  |  | 0 | 6 |  |  | 0 | 6
Southeast |  | 0 | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3
Midwest |  | 0 | 6 |  |  |  | 6 |  |  |  | 6 |  |  |  | 6
Northeast |  | 5 | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10
West Power |  | 10 | 5 |  |  |  | 5 |  |  | 0 | 5 |  |  | 0 | 5
Spreadsheet: 825705d1681478373-hlookup-a-date-between-dates-and-return-a-different-row-stock-report
Sheet: Stock usage

 | Usage
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | Week 34 | Week 35 | Week 36 | Week 37 | Week 38 | Week 39 | Week 40 | Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48 | Week 49
A
B
C
D
Spreadsheet: 4e398977-132c-480b-a68c-4d8e5e0635ed
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | UNIVERSITY OF ILLINOIS |  |  | Study Abroad Office |  | Tel:  (217) 333-6322
 | at URBANA CHAMPAIGN |  |  | 910 S. Fifth Street, 112 ISB |  | Fax: (217) 244-0249
 |  |  |  | Champaign, IL 61820, USA |  | E-mail: [EMAIL]
 | OFFICIAL STUDY ABROAD BUDGET
 | Name of Student:  ____________________________ |  |  |  | UIN:  _____________________
 | Sponsoring institution/foreign university: |  |  | [NAME]
 | Location of program: |  |  |  | Granada, Spain
 | Program Term: | Spring 2011 |  |  | Credit Hours: 12-18
 | SIAA Program Fee |  |  |  | 9523
 |  | SIAA Program Fee includes:
 |  | Instruction and Fees |  | 6162
 |  |  | Instruction and Fees in Spain | 5362
 |  |  | SIAA Admin Fees | 800
 |  | Miscellaneous Expenses |  | 3361
 |  |  | Housing and Meals | 3161
 |  |  | Excursions/Other | 200
 |  |  | IL-CISI Insurance | 0
 | Additional Meals During Orientation |  |  |  | 50
 | Estimated Round-Trip Airfare |  |  |  | 1000
 | Books and Supplies |  |  |  | 40
 | Local Transportation |  |  |  | 50
 | Personal Expenses |  |  |  | 2364
 | TOTAL ESTIMATED COST |  |  |  | 13027
 | The following estimated costs do not apply to all students and thus are not included in the above estimate.
 | Extended Housing May 9-May 27 (399 euro total)* |  |  | 512 | (Based on Euro-Dollar rate 1.28)
 | * This accomodation extension is for students taking courses at the Univesity of Granada due to their later academic calendar.
 | * For Michigan students, the total amount will be billed to the student along with the above program fees at the beginning of the term.
 | * For non-Michigan AESOP students, the total amount will be billed to the student around the middle of the semester in a second billing.
 | Extended Housing per day, post May 27 (22 euro/day)* |  |  | 28 | (Based on Euro-Dollar rate 1.28)
 | * Students taking courses at the University of Granada will pay this amount per day of extension beyond May 27.
 | * This per day amount will be paid by the student directly to CEGRI, thus this amount will not be reflected on a bill from Illinois.
 |  |  |  |  | Updated: July 22, 2010
 | Please note that the above total cost is based partially on estimates and addresses basic necessities and light to moderate social expenses only.  Costs can fluctuate as a result of changes in exchange rates, tuition increases, varying personal lifestyles, etc.
 | Please contact the Study Abroad Office at 333-6322 if you have any questions
Spreadsheet: 5edba2a0-cdd0-45e5-a13a-ddc75fd02557
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BFBL | Test | BFBL | [NAME], [NAME] | Bilirubin, BF | Photometric, Diazonium Salt | Amber vial (Supply T192) |  |  | 3 | mL | Collection Container/Tube: Body fluid container Submission Container/Tube: Opaque, amber vial (Supply T192) [NAME]: 1 mL Collection Instructions: 1. Centrifuge, separate supernatant, and send both supernatant and sediment. 2. Protect specimen from light. 3. Label specimens as sediment and supernatant.  Additional Information: Indicate specimen source. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Not applicable The reference range has not been established for bilirubin in body fluids. The test result should be integrated into the clinical context for interpretation. | Monday through Saturday; Continuously | Same day | 1 day | 1 | 82247 |  |  |  |  | Rochester
BFBL | [NAME] | BODYFL | Body Fluid |  |  |  | Frozen | 70 days
BFBL | Order Question | FLD14 | [NAME]: |  | Plain Text
BFBL | Result | BRNBF | [NAME] (BF) | [NAME] (BF) | Numeric |  |  |  |  | mg/dL
BFBL | Result | FLD14 | [NAME]: | [NAME]: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6 | Fluid:Type:Pt:Body fld:Nom:
Spreadsheet: 236279d1368735484-creating-a-drop-down-which-changes-adjacent-cell-data-25_08_2010_example_for_i-need-help
Sheet: Models_Table

DEF | 456
STU | 192021
GHI | 789
JKL | 101112
ABC | 123
MNO | 131415
YZZ | 242526
PQR | 161718
VWX | 212223
Attention: It´s not necessary sort this list. Try to change place some lines.
 | The result at SEARCH sheet don´t change.
Spreadsheet: 40415d1238723906-excel-2007-how-to-compare-data-in-two-tables-comparemerge
Sheet: Sheet1

 | Field1 | Field2 |  | Field3 | Field4 |  | [NAME]
 | Request_A | Item_A |  | Request_B | Item_B |  | Request_Final | Item_Final
 | 10051 | 10 |  | 10051 | 20
 | 10052 | 10 |  | 10052 | 10
 | 10053 | 10 |  | 10053 | 10
 | 10054 | 10 |  | 10054 | 10
 | 10054 | 20 |  | 10054 | 20
 | 10055 | 20 |  | 10054 | 30
 | 10055 | 30 |  | 10055 | 10
 |  |  |  | 10055 | 30
 |  |  |  | 10056 | 10
 | MS Access Database |  |  | 10057 | 20
 | Table Name : Compare
 | Field Names : Filed1, Field2, Field3 & Field4
 | Field Properties: Number
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: Yearly O&M Costs 11-20

Table 5.2.8. Present Value of Operations and [NAME] (Years 11-20)
 |  |  |  |  |  |  |  |  |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of O&M Costs for Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | Total Present Value of Yearly O&M Expenses (Years 11-20):
 |  |  |  |  |  |  |  |  |  |  |  | Total Present Value of Annual O&M Costs (Life of Project):
i= | 0.04875
Spreadsheet: 465103d1465460009-lookup-or-match-example1
Sheet: Sheet3

 | Date | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-01-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-30 00:00:00 | 2016-07-01 00:00:00 | 2016-07-02 00:00:00 | 2016-07-03 00:00:00 | 2016-07-04 00:00:00 | 2016-07-05 00:00:00 | 2016-07-06 00:00:00 | 2016-07-07 00:00:00
 | a |  | 25 |  | 32 |  |  |  | 40 |  |  |  |  |  |  |  | 60
 | b |  |  | 17 |  | 33 |  |  |  | 46 |  |  |  |  |  |  | 64
 | c | 40 |  |  | 33 |  |  | 51 |  |  |  |  |  |  |  |  | 55
 | d |  |  | 19 |  | 46 |  |  |  | 55 |  |  |  |  |  |  |  | 47
 | e |  | 25 |  | 35 |  |  |  | n/a |  |  |  |  |  |  |  |  | 49
 | f |  | 33 |  | 36 |  |  |  | 36 |  |  |  |  |  |  |  |  | 53
 | g |  |  | 34 |  | 40 |  |  |  | 44 |  |  |  |  |  |  |  |  | 60
 | h | 18 |  |  | 19 |  |  | 27 |  |  |  |  |  |  |  |  |  |  | 38
[NAME] in Excel
Manually set up
 |  | 1 | 2 | 3 | 4
 | a | 2016-06-21 00:00:00 | 2016-06-23 00:00:00 | 2016-06-27 00:00:00 | 2016-07-05 00:00:00
 | b | 2016-06-22 00:00:00 | 2016-06-24 00:00:00 | 2016-06-28 00:00:00 | 2016-07-05 00:00:00
 | c | 2016-06-20 00:00:00 | 2016-06-23 00:00:00 | 2016-06-26 00:00:00 | 2016-07-05 00:00:00
 | d | 2016-06-22 00:00:00 | 2016-06-24 00:00:00 | 2016-06-28 00:00:00 | 2016-07-06 00:00:00
 | e | 2016-06-21 00:00:00 | 2016-06-23 00:00:00 | 2016-06-27 00:00:00 | 2016-07-06 00:00:00
 | f | 2016-06-21 00:00:00 | 2016-06-23 00:00:00 | 2016-06-27 00:00:00 | 2016-07-06 00:00:00
 | g | 2016-06-22 00:00:00 | 2016-06-24 00:00:00 | 2016-06-28 00:00:00 | 2016-07-07 00:00:00
 | h | 2016-06-20 00:00:00 | 2016-06-23 00:00:00 | 2016-06-26 00:00:00 | 2016-07-07 00:00:00
Can a function be used to fill in this chart so it looks like this ? |  |  |  |  |  |  | Therefore the Date in row 1 is matched with the date in cell c17 and then the figure alongside 'a' is placed in cell 'C30'
 |  |  |  |  |  |  | and so on
 |  | 1 | 2 | 3 | 4
 | a | 25 | 32 | 40 | 60
 | b | 17 | 33 | 46 | 64
 | c | 40 | 33 | 51 | 55
 | d | 19 | 46 | 55 | 47
 | e | 25 | 35 | n/a | 49
 | f | 33 | 36 | 36 | 53
 | g | 34 | 40 | 44 | 60
 | h | 18 | 19 | 27 | 38
Spreadsheet: 856415d1705663965-extract-course-names-from-every-unique-possible-combination-without-regard-to-order-example-61-ans
Sheet: Students

Student | Course 1 | Course 2 | Course 3 |  | [NAME] to extract courses | Registration link
Alpha |  | X | X |  | Course 2, Course 3
Bravo |  | X | X | Course 2 | Course 2
[NAME] |  | X |  | Course 3 | Course 3
Delta |  |  | X | Course 1 | Course 1
Echo | X |  |  | Course 1, Course 2 | Course 1, Course 2
Foxtrot | X | X |  | Course 1, Course 2, Course 3 | Course 1, Course 2, Course 3
Golf | X | X
Hotel |  |  | X
India | X | X | X
[NAME] |  | X
Kilo |  |  | X
Lima | X | X
[NAME] | X | X
November |  |  | X
[NAME] |  |  | X
Papa |  | X
Quebec |  | X
Romeo | X | X
Sierra |  | X
Tango |  | X | X
Uniform |  |  | X
Victor |  | X
Whiskey | X