tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94446d1294258790-calculating-changing-distances-owhatathrill-mileagelog
Sheet: Sheet1

 | 500 [NAME] | 911 5th Avenue North | 401 Church Street | 312 [NAME]. | 1631 Lebanon Pike Circle | 310 Great Circle Road | 6500 Centennial Blvd. | 6418 Centennial Blvd. | 440 Hogan Road | 220 Blanton Avenue | 1500 Elm Hill Pike | 800 [NAME] | 221 Stewarts Ferry Pike | 843 Cowan Street | 23rd and Charlotte | 227 French Landing | 1158 Foster Avenue | 3041 Sidco Drive | 220 Athens Way | [NAME]. | 601 Fessler's [NAME] | 1111 Polk Ave | 2607 Winford Ave | 2405 Dickerson Pike
500 [NAME] | 0 | 1 | 1 | 1 | 6 | 4 | 8 | 8 | 11 | 5 | 5 | 1 | 12 | 3 | 2 | 2 | 5 | 6 | 3 | 15 | 3 | 4 | 6
911 5th Avenue North | 1 | 0 | 1 | 1 | 6 | 4 | 8 | 8 | 11 | 5 | 5 | 1 | 12 | 2
401 Church Street | 1 | 1 | 0
312 [NAME]. | 1 | 1 |  | 0
1631 Lebanon Pike Circle | 6 | 6 |  |  | 0 |  | 12
310 Great Circle Road | 4 | 3 |  |  |  | 0
6500 Centennial Blvd. | 8 | 8 |  |  | 12 |  | 0
6418 Centennial Blvd. | 8 | 8 |  |  |  |  |  | 0
440 Hogan Road | 11 | 10 |  |  |  |  |  |  | 0
220 Blanton Avenue | 5 | 5 |  |  |  |  |  |  |  | 0
1500 Elm Hill Pike | 5 | 5 |  |  |  |  |  |  |  |  | 0
800 [NAME] | 1 | 1 |  |  |  |  |  |  |  |  |  | 0
221 Stewarts Ferry Pike | 12 | 12 |  |  |  |  |  |  |  |  |  |  | 0
843 Cowan Street | 3 | 2 |  |  |  |  |  |  |  |  |  |  |  | 0
23rd and Charlotte | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
227 French Landing | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1158 Foster Avenue | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
3041 Sidco Drive | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
220 Athens Way | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME]. | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
601 Fessler's [NAME] | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1111 Polk Ave | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2607 Winford Ave | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2405 Dickerson Pike |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: phillip_m_love__30668__200003_OA
Sheet: TX-HPLR-VAR 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  HPLR
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 467232d1466622829-range-formula-help-needed-pivot-vs-countifs-and-averageifs
Sheet: Median

 | Based on Median (Vented Core) |  |  |  |  |  |  |  | Based on Median ([NAME])
 | Frame | Poles | Motor Type | Horsepower |  |  |  |  | Frame | Poles | Motor Type | Horsepower
Frame |  |  | Vented Core | 0>700 | 701>1250 | 1251>3000 | 3001>18,000 |  |  |  | [NAME] | 0>700 | 701>1250 | 1251>3000 | 3001>18,000
500 | 500 | 2-pole |  |  |  |  |  |  |  | 2-pole
500 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
500 |  | 6-pole |  |  |  |  |  |  |  | 6-pole |  |  |  |  |  |  | ** Return column J from VSM tab if Criteria is met.
500 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
500 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
500 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
500 |  | 16-pole |  |  |  |  |  |  |  | 16-pole |  |  |  |  |  |  | I added column A to make the formulas cleaned, you can group and contract it so you don’t have to see it. Or you can just hide it
580 | 580 | 2-pole |  |  |  |  |  |  |  | 2-pole
580 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
580 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
580 |  | 8-pole |  |  |  |  |  |  |  | 8-pole |  |  |  |  |  |  | Also this ONLY returns the FIRST data point, but as I mentioned in the forum, you could have multple 500 frame 6 pole vented under [NAME], THEN what should the math be?
580 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
580 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
580 |  | 16-pole |  |  |  |  |  |  |  | 16-pole |  |  |  |  |  |  | Also look at my VSM Avg Pivot and VSM Count Pivot sheets, that is likely how I would do it.
680 | 680 | 2-pole |  |  |  |  |  |  |  | 2-pole
680 |  | 4-pole |  |  |  |  |  |  |  | 4-pole |  |  |  |  |  |  | Also I have no idea what to do with column D or L
680 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
680 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
680 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
680 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
680 |  | 16-pole |  |  |  |  |  |  |  | 16-pole
800 | 800 | 2-pole |  |  |  |  |  |  |  | 2-pole
800 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
800 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
800 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
800 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
800 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
800 |  | 16-pole |  |  |  |  |  |  |  | 16-pole
630 | 630 | 2-pole |  |  |  |  |  |  |  | 2-pole
630 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
630 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
630 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
630 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
630 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
630 |  | 16-pole |  |  |  |  |  |  |  | 16-pole
710 | 710 | 2-pole |  |  |  |  |  |  |  | 2-pole
710 |  | 4-pole |  |  |  |  |  |  |  | 4-pole
710 |  | 6-pole |  |  |  |  |  |  |  | 6-pole
710 |  | 8-pole |  |  |  |  |  |  |  | 8-pole
710 |  | 10-pole |  |  |  |  |  |  |  | 10-pole
710 |  | 12-pole |  |  |  |  |  |  |  | 12-pole
710 |  | 16-pole |  |  |  |  |  |  |  | 16-pole
Spreadsheet: 3928dc5d-043b-40c4-b67a-3b61fb9c3d20
Sheet: ATOH7

MarkerName | Allele1 | Allele2 | P-value-overall | OR-overall | P-value-HPG | OR-HPG | P-value-NPG | OR-NPG | Direction | Gene | Location | 5'gene | 5'dist(kb) | 3'gene | 3'dist(kb) | CHR | BP
rs10998023 | a | g | 0.7193 | 1.016 | 0.8328 | 0.988 | 0.4767 | 1.054 | [NAME] | 0 | Intergenic | MYPN | 0.823 | ATOH7 | 17.785 | 10 | 69642602
rs765958 | a | g | 0.2025 | 0.95 | 0.1921 | 0.933 | 0.9486 | 1.005 | -- | 0 | Intergenic | MYPN | 1.553 | ATOH7 | 17.055 | 10 | 69643332
rs2394462 | a | g | 0.1465 | 0.915 | 0.3472 | 0.921 | 0.4502 | 0.913 | ?- | 0 | Intergenic | MYPN | 9.97 | ATOH7 | 8.638 | 10 | 69651749
rs1867567 | a | g | 0.2946 | 1.044 | 0.226 | 1.067 | 0.9923 | 0.999 | ++ | 0 | Intergenic | MYPN | 11.354 | ATOH7 | 7.254 | 10 | 69653133
rs7916697 | a | g | 0.128 | 0.932 | 0.1342 | 0.913 | 0.6988 | 1.031 | -- | ATOH7 | Exon | in | 0 | in | 0 | 10 | 69661859
rs2289804 | a | g | 0.4315 | 1.066 | 0.1885 | 1.152 | 0.8602 | 0.976 | ++ | 0 | Intergenic | ATOH7 | 1.177 | PBLD | 49.384 | 10 | 69663038
rs3858145 | a | g | 0.4255 | 1.037 | 0.386 | 1.053 | 0.6686 | 0.967 | [NAME] | 0 | Intergenic | ATOH7 | 19.983 | PBLD | 30.578 | 10 | 69681844
rs17231602 | a | g | 0.0491 | 0.891 | 0.3219 | 0.926 | 0.9025 | 1.013 | -- | 0 | Intergenic | ATOH7 | 20.434 | PBLD | 30.127 | 10 | 69682295
rs12571093 | a | g | 0.1069 | 0.915 | 0.1631 | 0.905 | 0.7775 | 1.027 | -- | 0 | Intergenic | ATOH7 | 27.516 | PBLD | 23.045 | 10 | 69689377
rs2241970 | a | g | 0.1101 | 1.091 | 0.1672 | 1.104 | 0.7744 | 0.973 | ++ | 0 | Intergenic | ATOH7 | 39.212 | PBLD | 11.349 | 10 | 69701073
Spreadsheet: 212520d1360157717-need-help-auto-generate-columns-stafprofile
Sheet: con

Name
Spreadsheet: 837317d1690038050-how-do-you-provide-points-based-on-a-defined-lookup-targets-table-points-based-on-value
Sheet: Test

 | Test | Pts | Points Want |  | Test2 | Pts | Points want
[NAME] | 0.2285714285714286 |  | 0 |  | 28 |  | 10
[NAME] | 0.1568627450980392 |  | 2 |  | 30 |  | 10
[NAME] | 0.0967741935483871 |  | 10 |  | 35 |  | 5
[NAME] | 0.2051282051282051 |  | 0 |  | 20 |  | 10
[NAME] | 0.0652100391304347 |  | 10 |  | 10 |  | 10
[NAME] |  |  | 0 |  | 5 |  | 10
Area2 | 0.09302325581395349 |  | 10 |  | 20 |  | 10
Area2 | 0.09090909090909091 |  | 10 |  | 30 |  | 7
Area2 | 0.15 |  | 7 |  | 15 |  | 10
Area2 | 0.19 |  | 4 |  | 35 |  | 4
Spreadsheet: 441bc646-3663-4833-a198-ff8cd17c3f61
Sheet: Sheet1

Name | Address | City | State | ZIP | Phone | County
Lafferty's Home Center | 5025 West Park Blvd. | Texarkana | TX | 75503
Superior Maytag H.A.C. | 2835 New Boston Rd | Texarkana | TX | 75501 | [PHONE]
Rice Furniture & Appliance, Inc. | [NAME] 2195 | Waldron | AR | 72958 | [PHONE] | Scott
Lowe's Home Centers, Inc. (Lowes) | 2120 FAYETTEVILLE ROAD | [NAME] | AR | 72956 | (479)494-4470 | CRAWFORD
Alston Bros. Furniture | 112 N. 3rd St. | Ozark | AR | 72949 | [PHONE] | Franklin
[NAME] | 3117 Waco Street | Fort Smith | AR | 72906 | [PHONE] | [NAME]
Best Buy Co., Inc. | 4195 PHOENIX AVE | Fort Smith | AR | 72903 | [PHONE] | [NAME]
Home Depot | 5101 PHOENIX AVENUE | Fort Smith | AR | 72903 | [PHONE] | [NAME]
[NAME] Plumbing | 5203 Moody Drive | Fort Smith | AR | 72903 | [PHONE]
Lowe's Home Centers, Inc. (Lowes) | 8001 ROGERS AVE. | Fort Smith | AR | 72903 | (479)452-6000 | SEBASTIAN
Sutherlands | 1801 South Zero St. | Fort Smith | AR | 72901 | [PHONE] | [NAME]
[NAME] Home Furnishings | 2210 Towson Ave. | Fort Smith | AR | 72901 | [PHONE] | [NAME]
Lensing Brothers, Inc. | [NAME] 73 | Subiaco | AR | 72865 | [PHONE] | Logan
Miller Sales, Inc. | 771 W. Walnut St. | Paris | AR | 72855 | [PHONE] | Logan
[NAME] | 605 W Main Street | [NAME] | AR | 72830 | [PHONE] | [NAME]
Sexton Furniture & Appliance, Inc. | 422 [NAME] | [NAME] | AR | 72830 | [PHONE] | [NAME]
Lowe's Home Centers, Inc. (Lowes) | 3011 PARKWAY EAST | RUSSELLVILLE | AR | 72802-2004 | (479)890-3018 | [NAME]
Hollingsworth Appliance | 3521 West Main St | Russellville | AR | 72801 | [PHONE] | Pope
[NAME] | 201 N. Arkansas Ave. | Russellville | AR | 72801 | [PHONE] | Pope
[NAME] | 920 S. Arkansas Ave. | Russellville | AR | 72801 | [PHONE] | Pope
Nino's Trading Company | 369 Albano Dr. | Tontitown | AR | 72770 | [PHONE] | Washington
Nino's Trading Company | PO Box 6820 | Springdale | AR | 72766 | [PHONE]
Metro Appliances & More | 5700 [NAME] | Springdale | AR | 72764 | [PHONE] | Washington
[NAME]'s Appliance Outlet (Tuckers) | 5260 [NAME] | Springdale | AR | 72764 | [PHONE] | Washington
Lowe's Home Centers, Inc. (Lowes) | 4233 WEST SUNSET AVE | SPRINGDALE | AR | 72762 | (479)717-4000 | WASHINGTON
Spreadsheet: 60937d1261513099-how-to-copy-cells-based-upon-criteria-smallworksheet
Sheet: Sheet1

 | [P] | iVillage.com: The Womens Network
 | [M] | 1BABY.COM
 | [M] | 1STBABY.COM
 | [M] | 800BABYGIFTS.COM
 | [M] | 888BABYGIFT.COM
 | [M] | 888BABYGIFTS.COM
 | [M] | ADVANCESINNEUROLOGY.COM
 | [M] | ADVANCESINONCOLOGY.COM
 | [M] | ALLWOMENSHEALTH.COM
 | [M] | ALZHEIMERS.COM
 | [C] | *.ALZHEIMERS.COM
 | [S] | *.ALZHEIMERS.COM
 | [M] | ALZHEIMERSNOW.COM
 | [M] | [NAME]
 | [C] | AMAZINGPREGNANCY.COM
Spreadsheet: 4a766bf3-8937-44be-b716-c9385a11fb08
Sheet: SIG Cohort 8

Grant: |  | Title 1A School Improvement
CFDA # |  | 84.010
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - November 15, 2013
Code | District Name | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | OCTOBER 2012 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | NOVEMBER 2013
0070-29 | Adams 50 | [NAME] | 100000 |  |  |  |  | 8130 | 2197 | 5499 | 10751 | 8605 |  |  | 1796 |  | 351
0480-23 | Boulder Valley RE-2 | [NAME] | 99944 |  |  | 7704 | 2534 |  | 192 | 4093 | 2322 | 2285 |  | 5077
0480-24 | Boulder Valley RE-2 | Emerald Elementary School | 100000 |  |  |  | 4193 |  | 396 | 7331 | 6901 |  |  |  | 7541 | 1210 | 9953
0480-25 | Boulder Valley RE-2 | Pioneer Bilingual Elementary | 100000 |  |  |  |  |  | 7355 | 7695 | 16970 | 5974 |  |  | 5331
0480-25 | Boulder Valley RE-2 | Pioneer Bilingual Elementary | 49658 |  |  | 3799 | 10948 |  | 5584 |  |  |  |  |  | 5087
0880-63 | Denver County 1 | Eagleton Elementary School | 50000 |  |  |  |  |  |  |  | 9326
1560-21 | Thompson R-2J | Monroe Elementary School | 97883 |  |  |  |  |  | 8895 | 2986 |  |  | 8094 |  | 9269 |  | 447
3145-20 | Ault-Highland Re-9 | Highland Elementary School | 83175 |  |  |  | 32531 | 11495 |  |  |  |  |  | 19989 | 2066 |  | 10090
8001-20 | Charter School Institute | Scolars to Leaders Academy | 46726 |  |  |  |  |  |  |  |  |  |  |  |  | 44811
Spreadsheet: 773994d1648146595-vlookup-index-function-error-example-4-1-
Sheet: By Employee

Employee ID | Task Order | Employee Name | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
 |  |  | 80 | 88 | 80 | 80 | 80 | 72 | 88 | 96 | 88
 | [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  | Answer:
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 5 | 0 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 02 AC.AD | [NAME], [NAME] | 0 | 5 | 5 | 5 | 5 | 5 | 5
 |  | Total Hours:
 |  | Extra Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra Hours:
2403 | Doe, [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2403 | Doe, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 01 AA.AD | Doe, [NAME] | 0 | 0 | 0 | 0 | 0 | 9 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 85 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10 |  |  | Row295
 |  | Total Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours:
 |  | Extra Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Extra Hours:
 | Fisher, Mary
 |  | Total Hours:
 |  | Extra Hours:
1920 | [NAME], [NAME]
 |  | Total Hours:
 |  | Extra Hours:
Spreadsheet: 693753d1599133593-lookup-multiple-solutions-values-and-list-them-excel-help
Sheet: Colli berekening

Position | Length | [NAME] | Qty | Qty/pos | [NAME] | Thickness | Density |  | M² | M³ | Weight | [NAME] weight
 | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME]
La1 | 1200 | 1020 | 5 |  | 1
La2 | 1200 | 1100 | 6 |  | 1
La3 | 1100 | 1020 | 7 |  | 1
La4 | 1300 | 1200 | 8 |  | 2
La5 | 1200 | 1100 | 9 |  | 2
La6 | 1100 | 1000 | 10 |  | 3
La7 | 1000 | 900 | 11 |  | 4
La8 | 900 | 800 | 12 |  | 4
La9 | 800 | 700 | 13 |  | 4
La2 | 1200 | 1100 | 14 |  | 4
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | => Totals
Spreadsheet: 04df2fac-5b0e-464d-b0fe-6c7422b47c6b
Sheet: State Report

 | State Summary Provided by the Ohio Department of Education
 | January 2014
 | Student Enrollment in EdChoice and Cleveland Scholarship Programs and Proficiency on Ohio Achievement and Graduation Tests for Spring 2013
 | Student Enrollment in EdChoice and Cleveland Scholarship Programs
 | Students participating for one year: |  |  |  |  |  | 4974
 | Students participating between one and three years: |  |  |  |  |  | 4156
 | Students participating for more than three years: |  |  |  |  |  | 12835
 | Percent of Students Proficient by Tested Grade
 | Tested Grade |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | 3 |  | 59.2 |  | 46.2 |  | Science test not given
 | 4 |  | 75.1 |  | 40.8 |  | Science test not given
 | 5 |  | 53.2 |  | 25.9 |  | 28
 | 6 |  | 66.5 |  | 34.1 |  | Science test not given
 | 7 |  | 68.5 |  | 37.7 |  | Science test not given
 | 8 |  | 75.6 |  | 44.9 |  | 36.6
 | OGT 10th |  | 92.2 |  | 82 |  | 72.8
 | OGT 11th |  | 64.7 |  | 38.5 |  | 38.2
 | OGT 12th |  | NC |  | NC |  | 31.6
 | Percent of Students Proficient by Student Gender
 | Gender |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | Female |  | 71.8 |  | 41.3 |  | 41.5
 | Male |  | 63.3 |  | 44 |  | 43.5
 | Percent of Students Proficient by Student Ethnicity
 | Ethnicity |  | Percent Proficient or Above in Reading |  | Percent Proficient or Above in Math |  | Percent Proficient or Above in Science
 | Asian/Pacific Island. |  | 75.5 |  | 64 |  | 40
 | Black |  | 62 |  | 33.9 |  | 33.5
 | Hispanic |  | 59.1 |  | 35 |  | 34.6
 | Multi-racial |  | 71.9 |  | 48.9 |  | 51.4
 | Native American |  | 55.9 |  | 28.6 |  | 40
 | White-Non Hispanic |  | 76.9 |  | 55.5 |  | 57.7
 | Notes
 | (1) All 2013 report card-affiliated data is preliminary pending the Auditor of State's investigation.
 | (2) This data may be amended from time to time as students are manually matched to their test and added to the report.
 | (3) Categories with fewer than 10 test takers are reported with 'NC'
 | (4) This data represents unverified assessment data from Spring 2013
 | (5) OGT Stands for Ohio Graduation Test.  This assessment is given starting in the 10th grade.
 | (6) Student enrollment participation includes all students in program
Spreadsheet: 836179d1689155984-costings-calculator-help-costings-calculator
Sheet: CHOICES

 |  |  |  |  | REGION 1 |  |  | REGION 2 |  |  | REGION 3
 |  |  |  |  | MARDEN | 1555 |  | MARDEN | 1555 |  | MARDEN | 1555
TYPE |  |  |  |  | ALNMOUTH | 1874 |  | ALNMOUTH | 1874 |  | ALNMOUTH | 1874
MARDEN | 1555 |  |  |  | RIPLEY | 2064 |  | RIPLEY | 2064 |  | RIPLEY | 2064
ALNMOUTH | 1874 |  |  |  | CHEDWORTH | 3062 |  | CHEDWORTH | 3062 |  | CHEDWORTH | 3062
RIPLEY | 2064 |  |  |  | WILLOW | 1876 |  | WILLOW | 1754 |  | WILLOW | 1325
CHEDWORTH | 3062 |  |  |  | OAK | 1754 |  | OAK | 1200 |  | OAK | 1255
CHOICE 1
Y | 128
N | 0
CHOICE 2
Y | 191
N | 0
CHOICE 3
Solid | 462
Sink Pack | 844
N | 0
CHOICE 4
Y | 250
N | 0
Spreadsheet: 744851d1629484180-multiple-invoices-and-multiple-payments-formula-excel-question
Sheet: Sheet1

Customer | Invoice Name | Invoice Amount | Applied Amount | Payment Name |  |  | Customer | Payment Name | Payment | Applied Amount | Invoice Applied to
Cust 1 | Invoice A | 100 |  |  |  |  | Cust 1 | Payment A | 50
Cust 1 | Invoice B | 100 |  |  |  |  | Cust 1 | Payment B | 25
Cust 1 | Invoice C | 100 |  |  |  |  | Cust 1 | Payment C | 50
Cust 1 | Invoice D | 100 |  |  |  |  | Cust 1 | Payment D | 200
Spreadsheet: 74840d1275396417-trunc-formula-example
Sheet: Sheet1

SECS/FRMS | FORM | SECS/FRMS | FORM | SECS/FRMS | FORM
1.00.00 | 59.99999999999999 | 2.00.02 | 120.0833333333333 | 0.0006954089506172838 | 60.08333333333332
1.02.02 | 62.08333333333334 | 1.03.02 | 63.08333333333333 | 1.157407407407399e-05 | 0.9999999999999929
1.05.00 | 65 | 2.05.12 | 125.5 | 0.0007002314814814815 | 60.5
1.10.00 | 70 | 2.11.02 | 131.0833333333333 | 0.0007069830246913581 | 61.08333333333334
Spreadsheet: 5acfac62-60ee-4c99-ac64-6fc047f3102b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
3541 | 21549 | [NAME] | Leithner | AUT | 82 | 00:18:14 | 00:00:49 | [NAME] | 00:01:10 | 00:21:07 | 1 | 01:02:14
3541 | 10491 | Co | Looijesteijn | NED | 0 | 00:19:59 | 00:01:06 | 00:22:03 | 00:01:35 | 00:25:58 | 2 | 01:10:44
3541 | 10329 | Curt | Maier | AUT | 83 | 00:21:17 | 00:00:46 | 00:23:47 | 00:01:23 | 00:23:32 | 3 | 01:10:46
3541 | 10231 | Jan | Holiga (1947) | SVK | 0 | 00:20:30 | 00:01:25 | 00:24:56 | [NAME] | 00:26:13 | 4 | 01:14:48
3541 | 21443 | [NAME] | [NAME] | AUT | 81 | 00:21:53 | 00:01:06 | 00:24:19 | 00:01:15 | [NAME] | 5 | 01:16:55
3541 | 21547 | Erich | Schochl | AUT | 84 | 00:20:31 | 00:00:56 | 00:24:43 | 00:01:46 | 00:29:51 | 6 | 01:17:49
Spreadsheet: 64192d1265087296-how-to-compare-if-multiple-cells-are-equal-sample
Sheet: Filter

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Job Title
Client | Science | 21x1 mono | 2007-01-07 00:00:00 | LXN522 | 917.7 | 25 | 0 | Science | 0
Client | Science | 21x1 mono | 2007-01-08 00:00:00 | LXN523 | 917.7 | 25 | 0 | Pathology  -  Class
Client | Science | 21x1 mono | 2007-01-09 00:00:00 | LXN524 | 917.7 | 25 | 0 | Science
Client | Science | 21x1 mono | 2007-01-10 00:00:00 | LXN525 | 917.7 | 25 | 0 | -  Science
Client | Science | 21x1 mono | 2007-01-11 00:00:00 | LXN526 | 917.7 | 25 | 0 | -  Science
Client | Science | 21x1 mono | 2007-01-12 00:00:00 | LXN527 | 917.7 | 25 | 0 | -  Science
Client | Science | 21x1 mono | 2007-01-13 00:00:00 | LXN528 | 917.7 | 25 | 0 | -  Science
0 | 0 | 0 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 0 | 0 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
0 | 0 | 0 | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
Spreadsheet: 205278d1357770968-drop-down-box-assitance-projected-data-testing
Sheet: Febuary2

Loc A |  |  |  |  |  | [NAME]
2012-12-31 00:00:00 | 15203 |  | -2363.81 |  |  | 2012-12-31 00:00:00 | -1007.41 |  | -186213
2012-12-31 00:00:00 | 0.01 |  | -2350.59 |  |  | 2012-12-31 00:00:00 | -1513 |  | -187356.63
2012-12-27 00:00:00 | 669.66 |  | -2350.6 |  |  | 2012-12-28 00:00:00 | 1156.44 |  | -186961.63
2012-12-27 00:00:00 | -295 |  | -3020.26 |  |  | 2012-12-24 00:00:00 | 1477.28 |  | -188118.07
2012-12-19 00:00:00 | 690.31 |  | -2725.26 |  |  | 2012-12-12 00:00:00 | 2173.74 |  | -189595.35
2012-12-19 00:00:00 | -295 |  | -3415.57 |  |  | 2012-12-11 00:00:00 | 0 |  | -191769.09
2012-12-18 00:00:00 | -1089.7 |  | -3120.57 |  |  | 2012-12-10 00:00:00 | -45123 |  | -191769.09
2012-12-12 00:00:00 | 669.66 |  | -2030.87 |  |  | 2012-12-03 00:00:00 | 0 |  | -191585.76
2012-12-12 00:00:00 | -295 |  | -2700.53
2012-12-11 00:00:00 | 0 |  | -2405.53 |  |  | Opening Balance | 191585.76
2012-12-05 00:00:00 | 669.66 |  | -2405.53 |  |  | Closing Balance | 186213
2012-12-05 00:00:00 | -295 |  | -3075.19
2012-12-03 00:00:00 | 0 |  | -2780.19
Income | 17902.3
Expenses | 2269.7
Opening Balance | 2780.19
Spreadsheet: 66086d1266777361-finding-top-ten-some-ranking
Sheet: Sheet1

 | POINTS | RANK UNIQUE |  | TOP 10 | POINTS
MARTIN 1 | 1 | 23 | 1 | MARTIN 23 | 48
[NAME] | 26 | 2 | 2 | [NAME] | 26
MARTIN 3 | 26 | 3 | 2 | MARTIN 3 | 26
MARTIN 4 | 3 | 21 | 2 | MARTIN 6 | 26
MARTIN 5 | 5 | 20 | 5 | MARTIN 21 | 21
MARTIN 6 | 26 | 4 | 6 | MARTIN 20 | 20
MARTIN 7 | 15 | 10 | 7 | MARTIN 19 | 19
MARTIN 8 | 8 | 19 | 8 | MARTIN 11 | 17
MARTIN 9 | 15 | 11 | 9 | MARTIN 13 | 16
MARTIN 10 | 10 | 18 | 10 | MARTIN 7 | 15
MARTIN 11 | 17 | 8 | 10 | MARTIN 9 | 15
MARTIN 12 | 12 | 16 | 10 | MARTIN 17 | 15
MARTIN 13 | 16 | 9 | 10 | MARTIN 18 | 15
MARTIN 14 | 14 | 14
MARTIN 15 | 13 | 15
MARTIN 16 | 12 | 17
MARTIN 17 | 15 | 12
MARTIN 18 | 15 | 13
MARTIN 19 | 19 | 7
MARTIN 20 | 20 | 6
MARTIN 21 | 21 | 5
MARTIN 22 | 3 | 22
MARTIN 23 | 48 | 1