tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807326d1669847771-keep-rows-with-min-of-start-date-and-end-of-start-date-for-a-given-id-minandmaxforidv2
Sheet: Sheet1

ID | Start | End | Unique | Earliest
1442906 | 12/15/2018 | 03/14/2023
1818991 | 05/31/2018 | 08/28/2023 | 1818991
1818991 | 05/31/2018 | 08/28/2023 | 1818999
1818991 | 06/21/2022 | 06/20/2032 | 1819012
1818991 | 06/28/2022 | 06/27/2032 | 1819038
1818991 | 06/29/2022 | 06/28/2032 | 1819052
1818991 | 07/08/2022 | 07/07/2032 | 1819059
1818991 | 07/27/2022 | 07/26/2032 | 1819105
1818991 | 08/01/2022 | 07/31/2032
1818991 | [NAME] | 08/17/2032
1818991 | 08/19/2022 | 08/18/2032
1818991 | 08/26/2022 | 08/25/2032
1818991 | [NAME] | 09/15/2032
1818991 | [NAME] | 09/26/2032
1818999 | 01/10/2018 | 11/07/2024
1818999 | 01/10/2018 | 11/07/2024
1819012 | 12/18/2015 | 05/18/2023
1819012 | 12/18/2015 | 05/18/2023
1819038 | 02/13/2019 | 05/13/2023
1819052 | 08/31/2018 | 01/28/2026
1819052 | 08/31/2018 | 01/28/2026
1819059 | 04/18/2018 | 03/17/2023
1819105 | 05/30/2017 | 08/28/2023
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: Hobbs

Hobbs Pipeline - 2002
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
Hobbs [NAME]
Beginning Inventory | 155644.07
Receipts | 1455196.72
Deliveries | 1383354.6
Ending Inventory | 226117.37
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)- % |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Hobbs [NAME]
Beginning Inventory | 17049.77
Receipts | 41688.54
Deliveries | 37715.3
Ending Inventory | 26866.87
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)- % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Hobbs Pipeline
Beginning Inventory |  | 0
Receipts | 1404422.02 |  |  |  |  |  |  |  |  |  |  | 0
Deliveries | 1328606.66 |  |  |  |  |  |  |  |  |  |  | 0
Ending Inventory
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 2430.94
Adjusted G(L)-Bbls
Adjusted G(L)- %
Spreadsheet: 6472ffbc-7805-4113-8298-89e7ea1283ba
Sheet: Sheet1

State Auditor - DEM (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/25/2013 7:49:15 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 1001 | 93 | 93
Precinct 1002 | 131 | 131
Precinct 1003 | 74 | 74
Precinct 1004 | 103 | 103
Precinct 1005 | 47 | 47
Precinct 1606 | 68 | 68
TOTAL | 516 | 516
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 683069d1592474083-how-to-find-the-total-value-qty-and-value-xlf-pivot-report
Sheet: Sheet1

staff code | sales person | product | QTY | value | date | time |  |  |  |  | date | 2020-06-17 00:00:00
1001 | [NAME] | S-10-SSD | 1 | 1250 | 2020-06-17 00:00:00 | 09:00:00
1001 | [NAME] | S-10-SSD | 1 | 1250 | 2020-06-17 00:00:00 | 09:05:00 |  |  |  |  | Row Labels | Sum of value
1001 | [NAME] | S-20-HDD | 1 | 1980 | 2020-06-17 00:00:00 | 15:00:00 |  |  |  |  | 1001 | 4480
1004 | [NAME] | S-5770-GRAPHIC CARD | 1 | 2230 | 2020-06-17 00:00:00 | 15:40:00 |  |  |  |  | [NAME] | 4480
1004 | [NAME] | S-20-HDD | 1 | 1980 | 2020-06-17 00:00:00 | 10:09:00 |  |  |  |  | S-10-SSD | 2500
1004 | [NAME] | S-2080-CARD | 1 | 10980 | 2020-06-17 00:00:00 | 16:25:00 |  |  |  |  | S-20-HDD | 1980
1007 | [NAME] | S-USB-BLACK | 1 | 32 | 2020-06-17 00:00:00 | 11:49:00 |  |  |  |  | 1004 | 15190
1007 | [NAME] | S-SLIVER-GREEN | 1 | 699 | 2020-06-17 00:00:00 | 17:06:00 |  |  |  |  | [NAME] | 15190
1007 | [NAME] | S-SLIVER-GREEN | 1 | 699 | 2020-06-17 00:00:00 | 17:06:00 |  |  |  |  | S-2080-CARD | 10980
1007 | [NAME] | S-2080-CARD | 1 | 10980 | 2020-06-17 00:00:00 | 17:22:00 |  |  |  |  | S-20-HDD | 1980
1007 | [NAME] | S-SLIVER-GREEN | 1 | 699 | 2020-06-17 00:00:00 | 14:30:00 |  |  |  |  | S-5770-GRAPHIC CARD | 2230
1007 | [NAME] | S-2080-CARD | 1 | 10980 | 2020-06-17 00:00:00 | 16:27:00 |  |  |  |  | 1007 | 24089
1009 | [NAME] | S-20-HDD | 1 | 1980 | 2020-06-17 00:00:00 | 13:20:00 |  |  |  |  | [NAME] | 24089
1009 | [NAME] | S-USB-BLACK | 1 | 32 | 2020-06-17 00:00:00 | 10:36:00 |  |  |  |  | S-2080-CARD | 21960
1009 | [NAME] | S-USB-BLACK | 1 | 32 | 2020-06-17 00:00:00 | 10:36:00 |  |  |  |  | S-SLIVER-GREEN | 2097
1009 | [NAME] | S-USB-BLACK | 1 | 32 | 2020-06-17 00:00:00 | 10:36:00 |  |  |  |  | S-USB-BLACK | 32
 |  |  |  |  |  |  |  |  |  |  | 1009 | 2076
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 2076
 |  |  |  |  |  |  |  |  |  |  | S-20-HDD | 1980
 |  |  |  |  |  |  |  |  |  |  | S-USB-BLACK | 96
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 45835
Spreadsheet: 05bd2c95-0328-4bdb-9b14-62ca30e6b6bd
Sheet: 2009-10

Table U
Student Numbers by Disability
2009-10
Disability | Undergraduate | Graduate | Total
Autistic Spectrum Disorder | 15 | 5
Blind / Are Partially Sighted | 11 | 10
Deaf / Have a Hearing Impairment | 17 | 21
Specific Learning Disability - e.g Dyslexia | 302 | 170
Mental Health Difficulties | 18 | 25
Multiple Disabilities | 11 | 11
Personal Care Support | 1 | 0
Unseen Disability eg Diabetes, [NAME], [NAME] | 59 | 94
Wheelchair User / Have Mobility Difficulties | 9 | 14
Other Disability | 53 | 25
No Known Disability | 12378 | 8469
Total
The data in this table reflects disability information voluntarily provided by students at the time of application. Students who do not wish to declare their disability or subsequently develop or are diagnosed as having a disability while studying at UCL will remain in the "No Known Disability" or "Not Known" categories. Therefore, the actual number of students with disabilities registered at UCL will be higher than indicated in this table.
Spreadsheet: kate_symes__18350__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-20 00:00:00 |  | 156.24 | 41264 | 72.99 | 7352
 | 2001-04-19 00:00:00 |  | 229.64 | 20496 | 95.31 | 12496 | 180.68 | 3529 | 118.99 | 927
 | 2001-04-18 00:00:00 |  | 229.64 | 20496 | 95.31 | 12496 | 187.63 | 4084 | 144.85 | 1444
 | 2001-04-17 00:00:00 |  | 229.42 | 18496 | 95.12 | 12096 | 142.12 | 2567 | 106.88 | 1257
 | 2001-04-16 00:00:00 |  | 229.53 | 12208 | 115.94 | 6400 | 160.59 | 4001 | 107.53 | 1253
 | 2001-04-15 00:00:00 |  | 225 | 0 | 110 | 0 | 51.43 | 665 | 27.78 | 90 |  | 115.16 | 27000
 | 2001-04-14 00:00:00 |  | 155.23 | 23600 | 76.12 | 10400 | 130.86 | 1510 | 52.21 | 510
 | 2001-04-13 00:00:00 |  | 155.23 | 23600 | 76.12 | 10400 | 113.58 | 2005 | 92.43 | 493
 | 2001-04-12 00:00:00 |  | 173.67 | 28080 | 86.85 | 9600 | 154.54 | 3865 | 74.1 | 415
 | 2001-04-11 00:00:00 |  | 179.1 | 25424 | 91.37 | 9280 | 176.83 | 2341 | 68.53 | 739
 | 2001-04-10 00:00:00 |  | 175.51 | 21664 | 89.05 | 7360 | 152.75 | 5195 | 106.04 | 1927
 | 2001-04-09 00:00:00 |  | 140.37 | 29824 | 99.04 | 10024 | 160.69 | 4429 | 82.6 | 1221
 | 2001-04-08 00:00:00 |  | 135 | 0 | 99 | 0 | 94.68 | 4331 | 89.95 | 950 |  | 98.94 | 30072
 | 2001-04-07 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 124.58 | 4097 | 104.49 | 973
 | 2001-04-06 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 144.64 | 4383 | 107.57 | 1185
 | 2001-04-05 00:00:00 |  | 210.51 | 39072 | 95.69 | 12336 | 113.42 | 2159 | 94.37 | 1318
 | 2001-04-04 00:00:00 |  | 235.75 | 35568 | 96.01 | 11864 | 134.48 | 2153 | 65.34 | 1391
 | 2001-04-03 00:00:00 |  | 232.48 | 34768 | 101.7 | 8424 | 124.35 | 2275 | 80.72 | 166
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456 | 151.72 | 5836 | 152.21 | 1055
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
Spreadsheet: mary_hain__25846__4th Qtr 2000EPMI FERC Report
Sheet: Exchange

 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Total
Exchange Receipt
Missoula Electric Power Cooperative |  | 2880 | 2976
Total
Exchange Delivery
Missoula Electric Power Cooperative
Total
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 9b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Fixed-Float | 1580301 | 474059 | 195413 | 28076 | 27413 | 29955 | 75727 | 2410944
OTHER* | 389090 | 429095 | 32122 | 8379 | 74270 | 30595 | 38132 | 1001683
TOTAL | 1969391 | 903154 | 227535 | 36455 | 101683 | 60550 | 113859 | 3412627
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: 016a66d7-af27-44c3-98e5-cb9cc86ea591
Sheet: Sheet1

COUNTY SUMMARY/BALLOTS CAST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Republican |  |  | Democratic
 | Regular | Absentee | Total | Regular | Absentee | Total
Belknap County | 8149 | 311 | 8460 | 2186 | 76 | 2262
Carroll County | 7046 | 346 | 7392 | 1911 | 73 | 1984
Cheshire County | 6311 | 227 | 6538 | 5112 | 186 | 5298
Coos County | 2773 | 108 | 2881 | 1897 | 83 | 1980
Grafton County | 7863 | 365 | 8228 | 5385 | 285 | 5670
Hillsborough County | 40113 | 1650 | 41763 | 15911 | 804 | 16715
Merrimack County | 16895 | 637 | 17532 | 9885 | 435 | 10320
Rockingham County | 33681 | 1241 | 34922 | 9727 | 359 | 10086
Strafford County | 9187 | 291 | 9478 | 4015 | 142 | 4157
Sullivan County | 3847 | 131 | 3978 | 2331 | 95 | 2426
Totals | 135865 | 5307 | 141172 | 58360 | 2538 | 60898
Spreadsheet: michelle_lokay__26648__available money for demand fees 05_2001
Sheet: 06.12

Market as of 06/04/01  - California -SoCal Basis
 | mid-market basis bids at Needles |  | fuel cost at $4.00 | margin after fuel (can be demand fee)
2002-06-01 00:00:00 | 0.95
2002-07-01 00:00:00 | 0.95
2002-08-01 00:00:00 | 0.95
2002-09-01 00:00:00 | 0.95
2002-10-01 00:00:00 | 0.95
2002-11-01 00:00:00 | 0.95
2002-12-01 00:00:00 | 0.95 |  |  |  |  | 7
Jan-dec 03 | 0.33 |  |  |  |  | 12
Jan-dec 04 | 0.28 |  |  |  |  | 12
Jan-dec 05 | 0.23 |  |  |  |  | 12
 |  |  |  | Total number of months
 |  |  |  | Rate we can pay
** Assumption is that TW-Permian basis is 0.  Market ranges between -.02 to 0.
Spreadsheet: 858160d1706896573-if-and-with-multiple-conditions-sample
Sheet: Sheet1

Cardholder | Expense Item | Transaction Date | Post Date | Merchant | Total (USD) | Status | Image Count | Flag | Coded | Status
[NAME] | General Expense | 01/09/2024 | 01/10/2024 | FSP*BCSP BOARD OF CERT | 90 | In [NAME] | 1 | Red | No
[NAME] | Lodging | 01/17/2024 | 01/19/2024 | DAYS INN | 385.56 | In [NAME] | 1 | Red | No
[NAME] | Lodging | 01/10/2024 | 01/12/2024 | DAYS INN | 385.56 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/24/2024 | 01/26/2024 | HOMEDEPOT.COM | 239.09 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/24/2024 | 01/26/2024 | HOMEDEPOT.COM | 79.86 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/25/2024 | 01/27/2024 | PRO TOOL WA | 1941.36 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/12/2024 | 01/14/2024 | THE HOME DEPOT #8916 | 780.71 | In [NAME] | 1 | Red | No
[NAME] | Travel - Other | 01/30/2024 | 01/31/2024 | AVIS RENT-A-CAR | 896.09 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/17/2024 | 01/19/2024 | PJ'S TRAVEL CENTER | 24.24 | In [NAME] | 1 | Red | No
[NAME] | Fuel | 01/26/2024 | 01/27/2024 | EXXON JORDANS KWIK STO | 67.01 | In [NAME] | 1 | Red | No
[NAME] | Fuel | 01/30/2024 | 01/31/2024 | EXXON JORDANS KWIK STO | 22.49 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/16/2024 | 01/17/2024 | EXXON JORDANS KWIK STO | 59.79 | In [NAME] | 1 | Red | No
[NAME] | Vehicle Repairs | 01/19/2024 | 01/20/2024 | TRACTOR SUPPLY CO #161 | 55.89 | In [NAME] | 1 | Red | No
[NAME] | General Expense | 01/04/2024 | 01/05/2024 | WM SUPERCENTER #1345 | 15.86 | In [NAME] | 0 | Red | No
[NAME] | General Expense | 01/06/2024 | 01/06/2024 | UPS*1Z35TPG00328759424 | 12.37 | In [NAME] | 0 | Red | No
[NAME] | Meals & Entertainment | 01/06/2024 | 01/07/2024 | TST* WHISKEY KITCHEN D | 400 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/04/2024 | 01/05/2024 | EXXON SHORT STOP | 31.51 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/06/2024 | 01/08/2024 | SHEETZ 0340   00003400 | 61.54 | In [NAME] | 0 | Red | No
[NAME] | Fuel | 01/10/2024 | 01/11/2024 | EXXON SHORT STOP | 60.32 | In [NAME] | 0 | Red | No
[NAME] | General Expense | 01/08/2024 | 01/10/2024 | EAST COAST LUMBER | 33.15 | In [NAME] | 1 | Green | Yes
[NAME] | General Expense | 01/19/2024 | 01/20/2024 | C&C MACHINE AND FABRIC | 500 | In [NAME] | 1 | Green | Yes
[NAME] | General Expense | 01/29/2024 | 01/30/2024 | PARRISH GENERAL SUPPLY | 29.95 | In [NAME] | 1 | Green | Yes
[NAME] | General Expense | 01/05/2024 | 01/06/2024 | HARBOR FREIGHT TOOLS 7 | 79.15 | In [NAME] | 1 | Green | Yes
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: Ercot

[NAME]
Originator |  | Commodity |  | Team |  | Total |  | %Total
Curry |  | Power |  | [NAME]
Sukaly |  | Power |  | [NAME] |  | 27602
Ahn |  | Power |  | [NAME] |  | 12000
Total
Spreadsheet: 694160d1599399805-auto-copy-of-certain-relevant-field-from-one-sheet-to-another-sheet-on-basis-of-condition-autocopycertainfieldstoanother2
Sheet: Sheet1

IRRELEVANT DATA
ID NUMBER | DATE OF BIRTH (DOB) | AGE | Group | NAME | PHYISCS | MATH | CHEMISTRY | SOCIAL SCIENCE | HISTORY | ARTS | GEOGRAPHY | BLOOD GROUP | FATHER'S NAME | [NAME] NAME | BLAH | BLAH2 | BLAH3
761057 | 2001-10-13 00:00:00 |  |  | [NAME] | 65 | 72 | 59 | 42 | 56 | 16 | 35 | A+ | XXXX | XXXXX | XXXXX | XXXXX | XXXXX
549236 | 2003-05-16 00:00:00 |  |  | [NAME] | 77 | 83 | 75 | 49 | 67 | 15 | 72 | B- | XXXX | XXXXX | XXXXX | XXXXX | XXXXX
179278 | 1999-11-23 00:00:00 |  |  | Viplaw Saran | 83 | 87 | 67 | 47 | 57 | 11 | 65 | AB+ | XXXX | XXXXX | XXXXX | XXXXX | XXXXX
439874 | 2004-12-22 00:00:00 |  |  | [NAME] | 43 | 65 | 84 | 35 | 65 | 17 | 57 | B- | XXXX | XXXXX | XXXXX | XXXXX | XXXXX
176541 | 2002-07-16 00:00:00 |  |  | [NAME] | 76 | 78 | 63 | 39 | 71 | 19 | 67 | B- | XXXX | XXXXX | XXXXX | XXXXX | XXXXX
216479 | 2001-06-12 00:00:00 |  |  | [NAME] | 32 | 65 | 59 | 33 | 54 | 13 | 41 | A+ | XXXX | XXXXX | XXXXX | XXXXX | XXXXX
349647 | 2003-01-11 00:00:00 |  |  | [NAME] | 89 | 93 | 82 | 47 | 68 | 11 | 72 | O+ | XXXX | XXXXX | XXXXX | XXXXX | XXXXX
964172 | 2004-02-24 00:00:00 |  |  | [NAME] | 94 | 97 | 87 | 49 | 72 | 14 | 70 | B- | XXXX | XXXXX | XXXXX | XXXXX | XXXXX
IRRELEVANT DATA
Spreadsheet: 775556d1649177777-recent-attendance-percentage-help-attendance
Sheet: Sheet1

2022-04-05 00:00:00 |  | January |  |  |  |  | February |  |  |  | March |  |  |  | April
Name | 7/10 Ready? | 2022-01-03 00:00:00 | 2022-01-10 00:00:00 | 2022-01-17 00:00:00 | 2022-01-24 00:00:00 | 2022-01-31 00:00:00 | 2022-02-07 00:00:00 | 2022-02-14 00:00:00 | 2022-02-21 00:00:00 | 2022-02-28 00:00:00 | 2022-03-07 00:00:00 | 2022-03-14 00:00:00 | 2022-03-21 00:00:00 | 2022-03-28 00:00:00 | 2022-04-04 00:00:00 | 2022-04-11 00:00:00 | 2022-04-18 00:00:00 | 2022-04-25 00:00:00
Eva | Yes | N | N | Y | N | N | Y | Y | Y | N | Y | Y | Y | Y | N | Y | Y | Y
[NAME] | No | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | N | Y | Y | N | N
Nathan | Yes | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
Spreadsheet: 161689d1339599653-look-up-two-text-values-then-multiply-two-cells-based-on-the-looked-up-text-values-question
Sheet: Sheet1

 |  |  | Product
 |  |  | Primary
 | Commision | Bonus Level | Secondary | Bonus |  |  |  |  | Primary | Secondary
 | 300 | D | Primary |  |  |  |  | A | 0 | 0
 | 200 | E | Secondary |  |  |  |  | B | 0.15 | 0.15
 | 100 | D | Primary |  |  |  |  | C | 0.3 | 0.3
 |  |  |  |  |  |  |  | D | 0.45 | 0.375
 |  |  |  |  |  |  |  | E | 0.65 | 0.4875
 |  |  |  |  |  |  |  | F | 0.8 | 0.56
 |  |  |  |  |  |  |  | G | 0.9 | 0.675
 |  |  |  |  |  |  |  | H | 1.05 | 0.8
 |  |  |  |  |  |  |  | I | 1.3 | 1
Spreadsheet: 3de13708-bf8b-4989-be27-3718f0731cd5
Sheet: Notes

 | 2011 Simulated Grades
 | Disclaimer: These simulations are based on 2011 data and are meant only to illustrate the proposed accountability system in Ohio's ESEA Flexibility Request.  These grades do not replace the 2010-11 ratings and are not projections for 2011-12.  ODE is still receiving feedback from education stakeholders which may be considered by the General Assembly and integrated into new legislation later this year.   These data remain subject to change and are not final.
 | As described in Ohio's ESEA Flexibility Request, the proposed overall grade is an average of three equally weighted component percentages:
 | - | Student Achievement: Performance Index measure
 | - | Student Growth: Equal weight of the Value-Added measure and Graduation Rate Gap measure (if available)
 | - | Gap Closing: AYP replacement that measures how well reading and math achievement gaps are closing
 | Link to Ohio's [NAME]:
 | http://education.ohio.gov/GD/Templates/Pages/ODE/ODEDetail.aspx?page=3&TopicRelationID=129&ContentID=116237
 | Summary of [NAME],  2010-2011 Data
 | Overall Letter Grade | All LEAs |  | Public Districts |  | Community Schools & STEM |  | All School Buildings
 |  | Count | Percentage | Count | Percentage | Count | Percentage | Count | Percentage
 | A | 8 |  | 3 |  | 5 |  | 353
 | A- | 36 |  | 28 |  | 8 |  | 266
 | [NAME] | 58 |  | 48 |  | 10 |  | 247
 | B | 95 |  | 85 |  | 10 |  | 284
 | B- | 146 |  | 133 |  | 13 |  | 321
 | C+ | 80 |  | 75 |  | 5 |  | 251
 | C | 57 |  | 52 |  | 5 |  | 238
 | C- | 70 |  | 54 |  | 16 |  | 204
 | [NAME] | 42 |  | 28 |  | 14 |  | 156
 | D | 41 |  | 23 |  | 18 |  | 138
 | D- | 47 |  | 28 |  | 19 |  | 168
 | F | 224 |  | 52 |  | 172 |  | 783
 | Total: | 904 |  | 609 | 1 | 295 | 1 | 3409 | 1
 | ODE included hidden columns after the letter grades to allow for further research using these simulations. For LEAs, Public Districts, Community Schools & STEM, these hidden columns are:
 | - | Column H: | Organization IRN
 | - | Column I: | Organization Type
 | For All School Buildings, these hidden columns are:
 | - | Column I: | District IRN
 | - | Column J: | School IRN
 | - | Column K: | School Type
Spreadsheet: 49843d1249279570-sum-values-in-a-dynamic-range-contiguous-cells-in-a-table-example
Sheet: 3

Actuals
Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Comments | Job comments
TOTALS |  |  |  |  | 138362 |  | TOTALS
 |  |  |  |  | 1924 |  | 3
 |  |  |  |  | 4910 |  | 3
 |  |  |  |  | 6020 |  | 3
 |  |  |  |  | 4631 |  | 3
 |  |  |  |  | 4921 |  | 3
 |  |  |  |  | 6441 |  | 3
 |  |  |  |  | 7410 |  | 3
 |  |  |  |  | 4659 |  | 3
 |  |  |  |  | 4799 |  | 3
 |  |  |  |  | 5841 |  | 3
 |  |  |  |  | 6460 |  | 3
 |  |  |  |  | 8183 |  | 3
 |  |  |  |  | 4341 |  | 3
 |  |  |  |  | 4407 |  | 3
 |  |  |  |  | 7797 |  | 3
 |  |  |  |  | 7526 |  | 3
 |  |  |  |  | 8 |  | 3
 |  |  |  |  | 6213 |  | 3
 |  |  |  |  | 2440 |  | 3
 |  |  |  |  | 2271 |  | 3
 |  |  |  |  | 1896 |  | 3
 |  |  |  |  | 6665 |  | 3
 |  |  |  |  | 1734 |  | 3
 |  |  |  |  | 6279 |  | 3
 |  |  |  |  | 7596 |  | 3
 |  |  |  |  | 658 |  | 3
 |  |  |  |  | 5216 |  | 3
 |  |  |  |  | 2020 |  | 3
 |  |  |  |  | 5096 |  | 3
Spreadsheet: 109203d1306145811-indirect-help-forum
Sheet: Summary

February | Validation here |  | 2001-02-01 00:00:00 |  |  | 2001-01-01 00:00:00
Account Number | Account Name | Country | Total Market Value | Cash  Value | % Cash | Total Market Value | Cash  Value | % Cash
111 | Murphy | UK | 110 | 70 | 0.6363636363636364 | 100 | 10 | 0.1
222 | Jones | US | 300 | 200 | 0.6666666666666666 | 150 | 20 | 0.1333333333333333
333 | Smith | SCO | 500 | 150 | 0.3 | 200 | 30 | 0.15
 |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 40166d1238503860-cell-references-in-formulae-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 377101
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date of Input | 2009-01-05 00:00:00 | This is a fluid number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mileage | B1 | This is a fluid number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-05 00:00:00 |  | B1 | This Feeds from cell T5 if the dates match.
 | Days | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-08 00:00:00 |  |  | 5 Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-10 00:00:00 |  | A1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-11 00:00:00
A | B1 | A1 | B2 | A2 | B12 | A3 | C1 | A4 | B13 | A5 | B21 | A6 | B14 | A7 | C2 |  | 2009-01-12 00:00:00
B1 | A1 | B2 | A2 | B12 | A3 | C1 | A4 | B13 | A5 | B21 | A6 | B14 | A7 | C2 | A |  | 2009-01-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-15 00:00:00 |  | B2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-20 00:00:00 |  | A2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-25 00:00:00 |  | B12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00