tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 106432d1303699606-multiple-drop-list-menu-7000kj
Sheet: Food List

Fruit | Vegetable | Grain | GrainFat | Meat | MeatFat | Milk | MilkFat | Fat
Apple (one) | Artichoke | Bread | Chocolate | Beef (lean) | Bacon (trimmed) | Skim | Milk (whole) | Avocado
[NAME] (one) | Asparagus | Breadcrumbs | Crackers (regular) | Buffalo | Beef (minced) | Non-Fat | Milk (2-4%) | Margarine (regular fat)
Carambola/Star Fruit (one) | Bean Sprout | Crackers | Hommus | Chicken (skinless) | Beef (brisket) | 1% Fat Milk |  | Margarine (reduced fat)
[NAME] (one) | Beans (string) | Crispbread | Ice Cream (low fat) | Goat | Beef (sirloin) | Yoghurt (non fat) |  | Mayonnaise (regular fat)
Grapefruit (one) | Beetroot | Crumpet | Muesli Bar | Kangaroo | Beef (ribs) | Milk (Butter)
Nashi Per (one) | Bok Choy | Dinner Roll | Pancake | Lamb (trimmed) |  | [NAME]
Nectarine (one) | Broccoli | Pumpernickel | Scone | Pork (lean) |  | Milk (evaporated)
Orange (one) |  | [NAME] (thick style) | Muffin |  |  | Milk (powdered)
[NAME] (one) |  |  | Hot Cross Bun
Peach (one) |  |  | Plain Cake
Pear (one) |  |  | Snack Food (regular fat)
 |  |  | Soup (cream-based)
 |  |  | [NAME]
Spreadsheet: 151015d1334759920-dynamic-named-range-question-offset-forum-version
Sheet: AM

AM
Ph
 |  | ID | File | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | CL | OFF | LD | REF
2 |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRP
Spreadsheet: 845184d1696696931-adding-a-new-row-for-every-new-item-book1
Sheet: Sheet1

Received Pocket | Currency | Value USD
YYY | RMB | 2000
[NAME] | [NAME] | 10000
[NAME] | [NAME] | 10000
YYY | USD | 5000
[NAME] | USD | 10000
YYY | RMB | 1000
WWW | IND | 20000
WWW | EUR | 3000
Received Pocket | Currency | SUMIF
WWW | IND
WWW | EUR
YYY | RMB
[NAME] | [NAME]
[NAME] | USD
 |  |  |  | Whenever I add a new Pocket OR existing pocket with a different curreny, an additional row to be added here (black arrow)
 |  |  |  | Example, if I type in WWW in A10, and USD in B10 then A20 would be WWW while [NAME] will be usd.
 |  |  |  | If I type in WWW and IND in A10 and B10, nothing happen.
Spreadsheet: 831583d1685728090-excel-copies-named-range-from-a-different-sheet-when-a-sheet-is-copied-d-test
Sheet: Supplier list

Supplier | Address | Default contact | Contact2 | Contact3 | Contact4 | Contact5 | Contact6 | Contact7 | Contact8 | Contact9 | Contact10 | Contact11 | [NAME] | Contact13 | Contact14 | Contact15 | Contact16 | Contact17 | Contact18 | Contact19 | Contact20
GM | GM street | Melvin
Ford | Ford street | [NAME]
Spreadsheet: 2163e187-314e-4518-a98a-3d86f94476e0
Sheet: Sheet1

Table 1--Soybeans:  Annual U.S. supply and disappearance | 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
 | Area |  | Yield | Supply |  |  |  |  | Use
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed, feed |  |  | Ending
September 1 |  |  |  | stocks | Production | Imports | Total |  |  | & residual | Exports | Total | stocks
 | Million acres |  | Bu./acre |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2011/12 | 75.046 | 73.776 | 41.93130557362828 | 215.013 | 3093.524 | 16.1356425643245 | 3324.672642564324 |  | 1703 | 87.28499983897359 | 1365.017642725351 | 3155.302642564324 | 169.37
2012/131 | 77.198 | 76.164 | 39.82959140801429 | 169.37 | 3033.581 | 36.1366418632023 | 3239.087641863202 |  | 1689 | 89.96486634648022 | 1319.565775516722 | 3098.530641863203 | 140.557
2013/142 | 76.533 | 75.869 | 43.34883812888005 | 140.557 | 3288.833 | 25 | 3454.39 |  | 1700 | 109.3899999999999 | 1495 | 3304.39 | 150
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  | Supply |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
 |  |  |  |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2012/13
September-November |  |  |  | 169.37 | 3033.581 | 4.2863493307698 | 3207.23734933077 |  | 622.6353144323552 |  | 618.4410348984147 | 1241.07634933077 | 1966.161
December-February |  |  |  | 1966.161 | --- | 4.7181036423045 | 1970.879103642304 |  | 447.2727627133432 |  | 525.5863409289612 | 972.8591036423045 | 998.02
March-May |  |  |  | 998.02 | --- | 7.8351491690241 | 1005.855149169024 |  | 446.1362887515575 |  | 125.0548604174667 | 571.1911491690241 | 434.664
June-August |  |  |  | 434.664 | --- | 19.2970397211039 | 453.9610397211039 |  | 262.9205004492242 |  | 50.48353927187971 | 313.4040397211039 | 140.557
Total |  |  |  |  | 3033.581 | 36.1366418632023 | 3239.087641863202 |  | 1778.96486634648 |  | 1319.565775516722 | 3098.530641863203
2013/14
September-November |  |  |  | 140.557 | 3288.833 | 11.8156584914991 | 3441.205658491499 |  | 632.482992166453 |  | 661.164666325046 | 1293.647658491499 | 2147.558
1 Estimated. 2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2014-01-14 08:04:32.280000
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2014-01-14 08:04:32.280000
Spreadsheet: 151403d1334890835-a-formula-to-sum-rows-sumproduct_test
Sheet: Sheet1

Jan | 03/01/2012 | 1904 | 20217-505 | 9970.7
Jan | 03/01/2012 | 1905 | 20217-505 | 9971.15
Jan | 04/01/2012 | 1906 | 20217-505 | 9972.14
Jan | 03/01/2012 | 1905 | 20217-505 | 9971.15
Jan | 04/01/2012 | 1907 | 20217-605 | 12234.05
Feb | 09/02/2012 | 1910 | 20217-605 | 9991.09
Jan | 04/01/2012 | 1911 | 20217-605 | 9993.53
Jan | 10/01/2012 | 1912 | 20217-605 | 9923.27
Jan | 01/01/2012 | 1913 | 20217-605 | 9993.77
Feb | 11/02/2012 | 1914 | 20217-605 | 7460
RESULT FROM THE FORMULA = |  |  | 0
CHECKING CONTROL STRING = |  |  | 01/03
Spreadsheet: 838880d1691493484-simplifying-speeding-up-an-indirect-formula-weekly-sales-yoy-by-customer-test
Sheet: A

 |  |  |  | 2023-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | JAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEC |  |  | TOTAL YEARLY
 |  |  |  | 2022-01-03 00:00:00 | 2023-01-02 00:00:00 | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference 22 Vs 23 |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference |  |  | Difference | 2022 | 2023 | Difference | 2022 | 2023 | Difference
A | 1111
 |  |  | 2023-07-05 00:00:00
 |  |  | 2023-05-01 00:00:00
 |  |  | 2023-06-01 00:00:00
 |  |  | 2023-08-07 00:00:00
 | A's TOTAL
KEY
 | Sampling
 | New customer
abcd | Closed
Spreadsheet: 2bc6c65f-d5b6-4102-8085-97ba34981c1e
Sheet: Sheet1

AVERY DENNISON | 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
PRELIMINARY CONSOLIDATED STATEMENT OF INCOME
(In millions, except per share amounts)
 |  |  |  |  |  | (UNAUDITED)
 |  |  |  |  |  | Three Months Ended |  |  |  |  |  | Twelve Months Ended
 |  |  |  |  |  | Jan. 2, 2010 |  |  | Dec. 27, 2008 |  |  | Jan. 2, 2010 |  |  | Dec. 27, 2008
 |  |  |  |  |  | (13 Weeks) |  |  | (13 Weeks) |  |  | (53 Weeks) |  |  | (52 Weeks)
Net sales |  |  |  |  | $ | 1521.8 |  | $ | 1511.5 |  | $ | 5952.7 |  | $ | 6710.4
Cost of products sold |  |  |  |  |  | 1106.7 |  |  | 1133.1 |  |  | 4366.2 |  |  | 4983.4
Gross profit |  |  |  |  |  | 415.1 |  |  | 378.4 |  |  | 1586.5 |  |  | 1727
Marketing, general & administrative expense |  |  |  |  |  | 341.4 |  |  | 309.8 |  |  | 1268.8 |  |  | 1304.3
Goodwill and indefinite-lived intangible asset impairment charges |  |  |  |  |  | 0 |  |  | 0 |  |  | 832 |  |  | 0
Interest expense |  |  |  |  |  | 18.3 |  |  | 28.1 |  |  | 85.3 |  |  | 115.9
Other expense, net (1) |  |  |  |  |  | 28.9 |  |  | 12.3 |  |  | 191.3 |  |  | 36.2
Income (loss) from operations before taxes |  |  |  |  |  | 26.5 |  |  | 28.2 |  |  | -790.9 |  |  | 270.6
(Benefit from) provision for income taxes |  |  |  |  |  | -23.4 |  |  | -14.4 |  |  | -44.2 |  |  | 4.5
Net income (loss) |  |  |  |  | $ | 49.9 |  | $ | 42.6 |  | $ | -746.7 |  | $ | 266.1
Per share amounts:
Net income (loss) per common share, assuming dilution |  |  |  |  | $ | 0.47 |  | $ | 0.43 |  | $ | -7.21 |  | $ | 2.7
Average common shares outstanding,
 |  | assuming dilution |  |  |  | 106.3 |  |  | 98.6 |  |  | 103.6 |  |  | 98.7
Common shares outstanding at period end |  |  |  |  |  | 105.3 |  |  | 98.4 |  |  | 105.3 |  |  | 98.4
(1) |  | Other expense for the fourth quarter of 2009 includes $26.9 of restructuring costs, asset impairment and lease cancellation charges and
 |  | legal settlement costs of $2.
 |  | Other expense for the fourth quarter of 2008 includes $12.3 of restructuring costs, asset impairment and lease cancellation charges.
 |  | Other expense for 2009 YTD includes $129.1 of restructuring costs, asset impairment and lease cancellation charges, legal settlement costs
 |  | of $41 and a loss of $21.2 from debt extinguishment.
 |  | Other expense, net, for 2008 YTD includes $40.7 of restructuring costs, asset impairment and lease cancellation charges, partially offset by ($4.5)
 |  | related to a gain on sale of investments.
-more-
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: ALA Guide to Reference

ALA Guide to Reference
2010-2011
COUNTER-Compliant?: | No
 | [NAME] | Aug-2010 | Sep-2010 | Oct-2010 | Nov-2010 | Dec-2010 | Jan-2011 | Feb-2011 | Mar-2011 | Apr-2011 | May-2011 | Jun-2011 | Total | 2010-2011 price | Price per unit
ALA Guide to Reference
Logins | 2 | 0 | 1 | 3 | 0 | 1 | 0 | 2 | 2 | 0 | 0 | 0 |  | 0
Spreadsheet: 767950d1644753922-sumif-and-drop-result-multiplied-per-number-of-times-is-repeated-in-matched-cell-test_rev03
Sheet: SAMPLE2

CRITERIA | FINAL RESULT |  |  |  |  |  |  | SUM_RANGE | MATCH
AAA |  |  |  |  |  |  |  | 100 | AAA;AAA;AAA
BBB |  |  | SUBSTITUTE(J2; ";" ; ",") |  |  |  |  | 200 | AAA;BBB;ABC
ABC |  |  |  |  |  |  |  | 300 | BBB;ABC;BBB;ABC;BBB;AAA
Spreadsheet: 167173d1341921416-formula-for-calculating-a-variance-exchange-auto-daily-count-template
Sheet: Sheet1

PRODUCT | SOLD | COUNT 1 | COUNT 2 | TOTAL | VARRIATION
42 Below - Kiwi
42 Below - Passion
42 Below - Honey
42 Below - Feijoa
42 Below - Vodka
Grey Goose - L'Orange
[NAME]
[NAME] Poire
[NAME]
Herradura - Anejo
Herradura - Repasado
Herradura - Bianco
Cazadores - Anejo
Cazadores - Blanco
Finlandia - G/F
Finlandia - Mango
Finlandia - Lime
Finlandia - Vodka
Finlandia - Cranberry
Bacardi - Limon
Bacardi - Gold
Bacardi - 151*
Bacardi - 8
DOM - Benadictine
angastura 1919
[NAME]
[NAME]
Apple Schnapps
Butter Scotch Schnapps
Peach Schnapps
Manderin Schnapps
Gordons Dry Gin
Bombay Saphire Gin
De Kuyper Blue Caracao
Midori Melon
Cointreau
EMT
Mckenna
Eristoff
Dewars
[NAME]
Bundaburg
El Jimadore
Wild Turkey
J/W Red Label
PRODUCT | SOLD | COUNT 1 | COUNT 2
J/W Black Label
Dewars 12 yo
Southern Comfort
Jameson
Canadian Club
Mt Gay - Eclipse
Mt Gay - Extra Old
Inner Circle - 40.0%
Inner circle - 57.8%
[NAME]
[NAME]
[NAME] 12YO
[NAME]
[NAME]
Martini - Rosato
[NAME]
[NAME]
[NAME]
Woodford
Chambord
Malibu
Tia Maria
Baileys
Kahlua
Frangelico
[NAME]
Galliano Black
Agwa
Tuaca
Jagermeister
Spreadsheet: 138271d1327590674-not-showing-value-in-particular-cells-forum-sample-5
Sheet: Sheet1

9 | 5 | 5 |  | 9 | 1 | 9 |  | 9
6 | 6 | 6 |  | 5 | 2 | 5 |  | 5
 |  |  |  | 5 |  | 6 |  |  | 6
 |  |  |  | 6 | 4 |  |  | #N/A | #N/A
 |  |  |  | 6 |  |  |  | #N/A | #N/A
 |  |  |  | 6 |  |  |  | #N/A | #N/A
Spreadsheet: 883323d1731936915-dynamic-drop-down-using-tables-testworkbook-alexhen-
Sheet: Job Summary

Job Number | Customer Number | Description | Cost Type | [NAME] | Fixed Price | Date | Invoiced | Invoice Date | Paid | Part Payment | Payment Date | Confirmation Email | Invoice Status | Materials | Labour | Total Estimate | Final Labour Cost | Final Invoice | Completion Status | Job Number with Details | Job Number Copy | Customer ID | Invoiceable
 | 100001 - Fred Head | Repair & Gravel Drive, Install Gates, [NAME] and Poly Tunnel. [NAME] | Estimate | Daily |  | 2024-10-05 00:00:00
 | 100002 - [NAME] | [NAME] and Install Shower | Quote | Fixed | 1500 | 2024-10-05 00:00:00 | Yes | 2024-10-15 00:00:00 |  |  |  | Sent
 | 100003 - Jim Thing | Fix mouse hole and repair small section of roof lining in car port. Remove and install customer supplied fence and gate | Estimate | Daily |  | 2024-10-10 00:00:00 | Yes | 2024-10-24 00:00:00 |  |  |  | Sent
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-10-22 00:00:00 | Yes | 2024-10-31 00:00:00 |  |  |  | Sent
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-11-01 00:00:00 | Yes | 2024-11-10 00:00:00
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-11-11 00:00:00
Spreadsheet: 142021d1329579981-finding-x-and-y-with-respect-to-third-variable-if-having-two-sets-of-x-and-y-test-trends1-2-
Sheet: Sheet1

Temp |  | 5 OC |  | 7 OC |  | 9.6 OC
 | X | Y | X | Y | X | Y
 | 435 | 1.00228594 | 435 | 1.00209478
 | 449 | 1.000986038 | 449 | 1.00079709
 | 463 | 0.999760292 | 463 | 0.999573015
 |  | 5 | 7 | 9.6
 | 435 | 1.00228594 | 1.00209478 |  | TREND(C11:D11,C10:D10,E10)
 | 449 | 1.000986038 | 1.00079709 |  | TREND(C12:D12,C10:D10,E10)
 | 463 | 0.999760292 | 0.999573015 |  | TREND(C13:D13,C10:D10,E10)
Spreadsheet: 86243d1286267678-best-price-spreadsheet-packing-cost-evaluation
Sheet: Castle

Castle
 | Price
Europa 1/1 | 31
Europa 1/2 | 32
50mm Clear Tape | 33
25mm Clear tape | 34
Fragile Tape | 35
Pallet Wrap | 36
Bubble Wrap | 37
Grip top bags 3.5"x4.5" (per 1000) | 38
Grip top bags 4.5"x4.5" (per 1000) | 39
Grip top bags 3x7.5" (per 1000) | 40
Open ended poly bags 10"x12" (per 1000) | 41
Open ended poly bags 12"x15" (per 1000) | 42
Open ended poly bags 15"x20" (per 1000) | 43
Open ended poly bags 18"x24" (per 1000) | 44
Open ended poly bags 24"x36" (per 1000) | 45
Spreadsheet: d5b6a22d-244f-4256-bea6-57426cd00142
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
FSUNG | Test | FSUNG | Sunflower Seed IgG | Sunflower Seed IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube (s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FSUNG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FSUNG | Result | FSUNG | Sunflower Seed IgG | Sunflower Seed IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: cbc2c6fe-5c86-4d33-aef1-0217f018e64e
Sheet: Q3 2009

FINANCIAL REPORTS
MEUR (except stated otherwise) | Q3 2009 | YTD 2009
Income statement | Jul-Sep 09 | Jan-Sep 09
Revenue | 165.4 | 491.2
EBITDAR | 54.2 | 148.8
EBITDA | 3.1 | -4.8
EBIT | -4.9 | -27
Financial income & expense, net | -1.1 | -0.9
Income tax | -0.1 | 0
Profit/loss for the year | -6.1 | -27.9
Balance sheet | 2009-09-30 00:00:00
Balance sheet total | 388
Total equity attributable to equity holders of the parent | 164.2
Cash flow | Jan-Sep 09
Cash flow from operating activities | -10.7
Cash flow from investing activities | -20.8
Cash flow from financing activities | 14.7
Financial key figures | Jul-Sep 09 | Jan-Sep 09
EBITDAR Margin, % | 0.327 | 0.303
EBITDA Margin, % | 0.019 | -0.01
EBIT Margin, % | -0.03 | -0.055
Operational key figures | 2009-09-30 00:00:00
Number of hotels1) | 280
Number of rooms1) | 58795
Operational key figures | Jul-Sep 09 | Jan-Sep 09
Occupancy, %2) | 64.6 | 60
RevPAR, EUR2) | 59 | 58.3
Share related key figures | 2009-09-30 00:00:00
Weighted average number of shares | 146307540
Share related key figures | Jul-Sep 09 | Jan-Sep 09
Earnings per share, EUR | -0.04 | -0.19
1.     Includes leased, managed and franchised hotels/rooms in operations.
2.     Including managed and leased hotels in operation.
Spreadsheet: 0612121d-3d06-460e-b677-23da51de8be7
Sheet: Sample PhD 1

Name: |  | EDRE Student |  |  |  | PID #: |  | P000000000
OHIO Email: |  | [EMAIL] |  |  |  | Year Began: |  | 2010
Program: |  | Educational Research and Evaluation |  | (Ph.D.) |  | Degree: |  | Ph.D.
Advisor: |  | [NAME] |  |  |  | Major Code: |  | PH6277
Postal Address: |  | 1234 Main St., Somewhere, OH 43210
Course Number |  | Course Name |  | Academic Year |  | Term & Year |  | [NAME] |  | [NAME] |  | Grade
Area #1 |  | Statistics & Quantitative Methods
EDRE 722 |  | [NAME] in Education |  | 2010-11 |  | Spring 2011 |  | 5 |  |  |  | A
EDRE 7610 |  | Computer Programming in EDRE |  | 2012-13 |  | Fall 2012 |  |  |  | 4
EDRE 7620 |  | Computer Software in EDRE |  | 2012-13 |  | Fall 2012 |  |  |  | 4
EDRE 790 |  | Advanced Reading in EDRE: CFA |  | 2011-12 |  | Spring 2012 |  | 2
EDRE 792 |  | Special Projects II in EDRE: AMOS |  | 2011-12 |  | Spring 2012 |  | 2
PSY 622 |  | Intermediate Correlation and Regression |  | 2011-12 |  | Summer 2012 |  | 4 |  |  |  | A
PSY 828 |  | Multivariate Statistics II |  | 2011-12 |  | Spring 2012 |  | 4 |  |  |  | A
BIOS 670 |  | Biostatistics I |  | 2012-11 |  | Winter 2011 |  | 4 |  |  |  | A
MATH 550A |  | Statistical Theory |  | 2010-11 |  | Summer 2011 |  | 4 |  |  |  | A
Area #2 |  | Research Design, Measurement, & Evaluation
EDRE 723 |  | Questionnaires & Nonparametric Statistics |  | 2011-12 |  | Winter 2012 |  | 5 |  |  |  | A
EDRE 7330 |  | Research Design in Education |  | 2012-13 |  | Spring 2013 |  |  |  | 4
EDRE 7800 |  | Program Evaluation |  | 2012-13 |  | Fall 2012 |  |  |  | 4
EDRE 7110 |  | Techniques of Test Development |  | 2012-13 |  | Spring 2013 |  |  |  | 4
EDRE 712 |  | Research in Educational Measurements |  | 2011-12 |  | Winter 2012 |  | 5 |  |  |  | A
EDRE 793 |  | Advanced Seminar in EDRE: History |  | 2011-12 |  | Fall 2011 |  | 3 |  |  |  | CR
PSY 623 |  | Design and Analysis of Experiments |  | 2010-11 |  | Spring 2011 |  | 4 |  |  |  | A
Area #3 |  | [NAME]
EDRE 750 |  | Introduction to Qualitative Methods |  | 2011-12 |  | Fall 2011 |  | 4 |  |  |  | A
EDRE 751 |  | Qualitative Interviewing |  | 2011-12 |  | Winter 2012 |  | 5 |  |  |  | A
EDRE 7520 |  | [NAME] in Education |  | 2012-13 |  | Fall 2012 |  |  |  | 4
EDRE 7930 |  | Advanced Seminar in EDRE: Coding |  | 2012-13 |  | Spring 2013 |  |  |  | 2
Area #4 |  | Higher Education & Institutional Research
EDHE 778 |  | Assessment and Evaluation |  | 2010-11 |  | Winter 2011 |  | 4 |  |  |  | A
EDHE 783 |  | Institutional Research & Self-Study in HE |  | 2011-12 |  | Fall 2011 |  | 4 |  |  |  | A
EDHE 890 |  | Databases in Higher Education |  | 2011-12 |  | Spring 2012 |  | 4 |  |  |  | A
Area #5 |  | Dissertation (maximum of 10 semester hours)
EDRE 8950 |  | Dissertation |  |  |  |  |  |  |  | 10
Spreadsheet: 239214d1369848459-4-digit-code-for-similar-product-new-product-unique-code-unclejemima-final-hopefully-
Sheet: Sheet1

HIDE THESE COLUMNS |  |  | Product | Colour | Product #
 | 1 |  | Apple | Red
 |  |  | Apple | Red
 |  |  | Apple | Green
 |  |  | Orange | Orange
 |  |  | Orange | Red
 |  |  | [NAME] | Yellow
 |  |  | Apple | Blue
 |  |  | Pear | [NAME]
 |  |  | Pear | Blue
 |  |  | Orange | Orange
 |  |  | Cherries | Black
 |  |  | Tomato | Green
 |  |  | [NAME] | Yellow
 |  |  | [NAME] | Green
 |  |  | [NAME] | White
 |  |  | Apple | Red
 |  |  | [NAME] | White
 |  |  | Apple | red
 |  |  | apple | purple
 |  |  | apple | ginger
 |  |  | [NAME] | blue
Spreadsheet: 81228d1281472988-countif-value-in-ranges-sample
Sheet: Summary

 | ABAND | BABY | BTRJB | CHILD | HOURS | JOB | MONEY | MOVE | OOBUS | OTHER | RETIR | SCHL
< 3 months
3-6 months
6-12 months
1-3 years
3-5 years
5-10 years
10-20 years
20+ years
Count the number of employee #s that have Months of Service within the ranges in A and Termination Codes equal to those in row 1
Spreadsheet: 144000d1330663330-need-to-eliminate-blank-lines-in-vlookup-results-card
Sheet: Cards Sold

Date Listed | Date Sold | Control # | Card Type | Card Number | Balance | Paid | Sold | Profit $$ | Profit % | Plastic Jungle | [NAME] | other | Date paid
2012-02-15 00:00:00 |  | 2 |  |  |  |  | 88
2012-02-15 00:00:00 |  | 4 |  |  |  |  | 60
2012-02-15 00:00:00 |  | 3 |  |  |  |  | 72
2012-02-14 00:00:00 |  | 1 |  |  |  |  | 35
2012-02-16 00:00:00 |  | 5
Spreadsheet: 622883d1556972253-create-one-master-list-from-lists-on-multiple-worksheets-ef1282a_create-one-list-from-multiple-sheets
Sheet: MASTER LIST

 |  |  |  |  |  |  |  |  |  |  | 0
From | Item No. | Description | Own Depot |  |  |  |  |  | List 1
 |  |  |  |  |  |  |  |  | List 2
 |  |  |  |  |  |  |  |  | List 3
 |  |  |  |  |  |  |  |  | List 4