tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58097d1258409548-creating-a-sports-table-sportstable
Sheet: Setup

NUMBER OF TEAMS |  | 8
COMPETITION TYPE |  | Full Competition
TEAMS NAME
1 | Name1
 | [NAME]
 | Name3
 | Name4
 | Name5
 | Name6
 | Name7
 | Name8
 | Lille
Spreadsheet: 270560d1381522948-list-dates-that-correspond-to-employee-id-numbers-from-a-different-sheet-example4-oeldere-
Sheet: Sheet2

31 | 2013-08-15 00:00:00 |  |  |  | date | choise
32 | 2013-08-15 00:00:00 |  |  |  | 2013-08-15 00:00:00 | 31
33 | 2013-08-15 00:00:00 |  |  |  | 2013-08-15 00:00:00 | 32
31 | 2013-08-22 00:00:00 |  |  |  | 2013-08-15 00:00:00 | 33
32 | 2013-08-22 00:00:00 |  |  |  | 2013-08-22 00:00:00 | 31
33 | 2013-08-22 00:00:00 |  |  |  | 2013-08-22 00:00:00 | 33
31 | 2013-08-30 00:00:00 |  |  |  | 2013-08-22 00:00:00 | 32
32 | 2013-08-30 00:00:00 |  |  |  | 2013-08-30 00:00:00 | 31
33 | 2013-08-30 00:00:00 |  |  |  | 2013-08-30 00:00:00 | 32
 |  |  |  |  | 2013-08-30 00:00:00 | 33
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 10c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60+ | TOTAL
Cross-Currency Basis | 787284 | 648461 | 972760 | 1664907 | 2537922 | 2466628
Cross-Currency Fixed-Fixed | 61752 | 16983 | 34627 | 39227 | 108817 | 175283
Cross-Currency Fixed-Float | 148555 | 122559 | 181792 | 240582 | 372936 | 2473481
TOTAL
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Pwr Vol Mgmt

 | Power Volume Mgmt
 | 2002 Plan
 |  |  |  |  |  |  |  | Energy Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Analyst & Associate | 0 |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 0
ENAOUTSV | Outside Services | 0 |  |  |  |  | 0 | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  |  | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  |  | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  |  | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 13 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  | 0 | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 59470d1259958366-league-spreadsheet-exampleleaguespreadsheet2009
Sheet: Week 3

Week 3
 |  | score | Handicap | adjusted score | points won |  |  |  | score | Handicap | adjusted score | points won
Blue | bill | 300 | - | 300 | 1 | vs. | yellow | erin | 254 | 21.6 | 275.6 | 0
 | bob | 296 | - | 296 | 1 | vs. |  | [NAME] | 214 | 36.4 | 250.4 | 0
 | [NAME] | 289 | - | 289 | 0 | vs. |  | elwood | 265 | 29.2 | 294.2 | 1
red | ray | 300 | - | 300 | 1 | vs. | green | gary | 280 | 18 | 298 | 0
 | [NAME] | 271 | - | 271 | 0 | vs. |  | grendel | 278 | 15.6 | 293.6 | 1
 | ron | 260 | - | 260 | 0 | vs. |  | greg | 254 | 8.8 | 262.8 | 1
Spreadsheet: 14d833bf-62db-4a7c-aa54-cd0db0c04916
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 33. LEASE FINANCE COMMITMENTS, By Purpose: State (QLD), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413943F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413944J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413945K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413946L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413947R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413948T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413949V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413950C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413951F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413952J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413953K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413954L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413955R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413956T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413957V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413958W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 685083d1593707370-formatting-a-cell-for-time-iartn-rtk-usage-help
Sheet: UserCodes

Code | Description | Industry | Sector | Location
AG2 | Agricultural-Government (Iowa - Non-DOT) |  |  |  |  |  | Agricultural
AG3 | Agricultural-Government (Iowa - County) |  |  |  |  |  | Other DOT Networks
AG6 | Agricultural-Government (Outside Iowa) |  |  |  |  |  | Survey/Engineering/GIS Users
AP1 | Agricultural-Private (Iowa) |  |  |  |  |  | Construction Users
AP2 | Agricultural-Private (Outside Iowa) |  |  |  |  |  | Other
CG1 | Construction-Government (Iowa - DOT) |  |  |  |  |  | Iowa DOT
CG2 | Construction-Government  (Iowa - Non-DOT)
CG3 | Construction-Government (Iowa - County) |  |  |  |  |  | Network
CG4 | Const ruction-Government (Iowa - City)
CGS | Construction-Government (federal) |  |  |  |  |  | Private
CG6 | Construction-Government  (Outside Iowa) |  |  |  |  |  | Government
CP1 | Construction-Private (Iowa) |  |  |  |  |  | Federal
CP2 | Construction-Private (Outside Iowa)
NG2 | Network-Government (Iowa) |  |  |  |  |  | Iowa
NG3 | Network-Government (Iowa - County) |  |  |  |  |  | Outside Iowa
NG4 | Network-Government (Iowa - City)
NGS | Network-Government (Federal)
NG6 | Network-Government (Outside Iowa)
NP1 | Network-Private (Iowa)
NP2 | Network-Private (Outside Iowa)
OG1 | Other-Government (Iowa - DOT)
OG2 | Other-Government (Iowa - Non-DOT)
OG6 | Other-Government (Outside Iowa)
OP1 | Other-Private (Iowa)
OP2 | Other-Private (Outside Iowa)
SG1 | Survey-Government (Iowa - DOT)
SG2 | Survey-Government (Iowa - Non-DOT)
SG3 | Survey-Government (Iowa - County)
SG4 | Survey-Government  (Iowa - City)
SG5 | Survey-Government (Federal)
SG6 | Survey-Government (Outside Iowa)
SG7 | Survey-Government (Quasi-Public)
SP1 | Survey-Private (Iowa)
SP2 | Survey-Private (Outside Iowa)
[NAME] | Administration | Administration | Government | Iowa
 | Functions for SBC User Codes | "=VLOOKUP([@UserCode],UserCode,3,0) | "=VLOOKUP([@UserCode],UserCode,4,0) | "=VLOOKUP([@UserCode],UserCode,5,0)
Spreadsheet: 222524d1363875892-names-of-failure-students-to-be-automatically-shown-in-the-list-of-failures-marks-and-list-of-failures_2
Sheet: Marks

Group 4
SN | Student's Name | Student No. | Mark | Grade
1 | Student 1 | 13144 | 65
2 | Student 2 | 13145 | 80
3 | Student 3 | 13146 | 77
4 | Student 4 | 13147 | 72
5 | Student 5 | 13148 | 68
6 | Student 6 | 13149 | 63
7 | Student 7 | 13150 | 67
8 | Student 8 | 13151 | 60
9 | Student 9 | 13152 | 72
10 | Student 10 | 13153 | 65
11 | Student 11 | 13154 | 77
12 | Student 12 | 13155 | 63
13 | Student 13 | 13156 | 76
14 | Student 14 | 13157 | 55
15 | Student 15 | 13158 | 0
16 | Student 16 | 13159 | 45
17 | Student 17 | 13160 | 87
18 | Student 18 | 13161 | 71
19 | Student 19 | 13162 | 61
20 | Student 20 | 13163 | 53
21 | Student 21 | 13164 | 60
22 | Student 22 | 13165 | 0
23 | Student 23 | 13166 | 63
24 | Student 24 | 13167 | 50
25 | Student 25 | 13168 | 65
26 | Student 26 | 13169 | 58
27 | Student 27 | 13170 | 91
28 | Student 28 | 13171 | 70
29 | Student 29 | 13172 | 73
30 | Student 30 | 13173 | 67
31 | Student 31 | 13174 | 60
32 | Student 32 | 13175 | 63
33 | Student 33 | 13176 | 58
34 | Student 34 | 13177 | 55
35 | Student 35 | 13178 | 78
36 | Student 36 | 13179 | 53
37 | Student 37 | 13180 | 79
38 | Student 38 | 13181 | 63
39 | Student 39 | 13182 | 73
40 | Student 40 | 13183 | 33
41 | Student 41 | 13184 | 67
42 | Student 42 | 13185 | 76
43 | Student 43 | 13186 | 88
44 | Student 44 | 13187 | 69
45 | Student 45 | 13188 | 70
46 | Student 46 | 13189 | 80
47 | Student 47 | 13190 | 62
48 | Student 48 | 13191 | 63
49 | Student 49 | 13192 | 95
Spreadsheet: 859527d1707903029-formula-help-for-isolating-two-columns-based-on-no-match-test-excel-aligw
Sheet: PRICING ANALYZER

Pulled Sales History SIM List | SIM Description | Sell Contract | SPA Cost | SPA Name | 2610 Standard Cost | 2610 WTT Cost | [NAME] | Loaded Margin | [NAME] Months | QTY Sold - Revenue | [NAME] Cost | [NAME]
 | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
[PHONE] | a | f | f | s | x | s | s | s | g | h | v | v
Spreadsheet: 290935d1390049933-adding-0s-for-missing-years-js
Sheet: converted form

Years | Frequency | data Start Year | 1700 | <---- Type here
Spreadsheet: michelle_cash__26490__Capital_ONE
Sheet: 18_01_99

ELEKTRO Eletricidade e Serviços S/A  (EXTRA OFICIAL - PRELIMINAR)
Composição do Capital Social |  |  |  |  |  |  |  | Posição em: | 18/01/1999
 |  | [NAME] |  |  | [NAME] |  |  | Total Ações
DATA | Acionistas | Quantidade | Valor em R$ | % | Quantidade | Valor em R$ | % | Quantidade | Valor em R$ | % | Observações
1998-12-23 00:00:00 | [NAME] | 43681170494 | 0 | 0.8998 | 0 | 0 |  |  | 0 | 0.4661
1998-12-23 00:00:00 | CESP - Companhia Energética de São Paulo | 4854165156 | 0 |  | 0 | 0 |  |  | 0 | 0.0518
1998-12-23 00:00:00 | CESP - Companhia Energética de São Paulo | 0 | 0 |  | 44554244393 | 0 | 0.9866 |  | 0 | 0.4755
1998-12-23 00:00:00 | Acionistas Minoritários, inclusive Conselheiros. | 6315910 | 0 | 0.0002 | 602365837 | 0 | 0.0134 |  | 0 | 0.0066
1998-12-23 00:00:00 | TOTAL |  | 0 |  |  | 0 |  |  | 528598154.94
1999-01-18 00:00:00 | EPC - EMPRESA PARANAENSE COMERCIALIZADORA LTDA. | 43343321079 | 0 |  | 0 | 0 |  |  | 0 |  | Conforme informação recebida de Edson Pavão (ENRON's Lawyer) e/ou J.P.Morgan através de telefone/Fax/E-Mail.
1999-01-18 00:00:00 | ENRON BRAZIL POWER INVESTMENTS V LTD. | 337849415 | 0 |  | 0 | 0 |  |  | 0 |  | Conforme informação recebida de Edson Pavão (ENRON's Lawyer) e/ou J.P.Morgan através de telefone/Fax/E-Mail.
1999-01-18 00:00:00 | CESP - Companhia Energética de São Paulo | 4854165156 | 0 |  | 0 | 0 |  |  | 0 |  | Conforme determina Edital da CESP, estas ações foram destinadas à Oferta aos empregados, com liquidação prevista para 27/01/99.
1999-01-18 00:00:00 | CESP - Companhia Energética de São Paulo | 0 | 0 |  | 44554244393 | 0 |  |  | 0 |  | Ações livres [NAME], em princípio no Leilão marcado para 18/02/99, conforme [NAME] ENRON Serviços do [NAME].
1999-01-18 00:00:00 | Acionistas Minoritários | 6315910 | 0 |  | 602365837 | 0 |  |  | 0
1999-01-18 00:00:00 | TOTAL |  | 0 |  |  | 0 |  |  | 528598154.94
Capital Social composto por ações Nominativas Escriturais, sem valor nominal.
Nota: As informações contidas na parte cinza representam a posição atual da empresa, para efeito comparativo com posições anteriores.
Spreadsheet: 51235d1250775034-linking-cell-movement-test-linked-movement
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50
 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60
 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70
 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80
 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90
 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100
 | 0.7908723469654539 | 0.05005320044515926 | 0.4554378722852717 | 0.7802184265279513 | 0.7721150793928047 | 0.6820094295282555 | 0.4948079289404488 | 0.4024942494355841 | 0.6238193375588228 | 0.6874559221824468
 | 0.6537665720552097 | 0.3741545892140765 | 0.1621358684175007 | 0.7801688389655261 | 0.777095177737432 | 0.7885640922441786 | 0.8492770233926041 | 0.1766832765496229 | 0.9319561711306337 | 0.1197670021321866
 | 0.475286794947845 | 0.8633793763607391 | 0.150572662453228 | 0.2423777640629423 | 0.3804935118639863 | 0.1810542587362036 | 0.748102226379981 | 0.8915497259634391 | 0.4196968302533914 | 0.2047629622112499
 | 0.5566453483325668 | 0.0434776010526754 | 0.556571167135985 | 0.6500802833568065 | 0.9638363878133474 | 0.3571740761353779 | 0.1344973429933083 | 0.2373344276286247 | 0.2483137536154547 | 0.3800255894873912
 | 0.7026426524194767 | 0.6169014355294653 | 0.9589264151199313 | 0.4680563219529112 | 0.9693963113955499 | 0.7269042129530723 | 0.5974216363425953 | 0.5428675645772554 | 0.8540561803914202 | 0.6032050804125799
 | 0.7919046722212248 | 0.0872562942484778 | 0.4844370724048161 | 0.2210098988037057 | 0.4322443112368459 | 0.7007200329837968 | 0.5179181353696354 | 0.01036365270202722 | 0.6323867651654114 | 0.7369420475460853
 | 0.384205904264878 | 0.3431946639354075 | 0.396923867634009 | 0.2340385710855486 | 0.8753101609379152 | 0.9045600606850663 | 0.5456872549843439 | 0.545883444417331 | 0.4267327611228726 | 0.329133177553274
 | 0.4373116736030953 | 0.5211336702422669 | 0.5133867510772951 | 0.4236000659515702 | 0.5917721497339761 | 0.3825035024892345 | 0.7380562589011375 | 0.9203520136225047 | 0.1063746205442537 | 0.6085351948088129
 | 0.4605252304492309 | 0.7773793628307624 | 0.0007662659996601207 | 0.03159183876334204 | 0.1632881223680842 | 0.946426184622486 | 0.3354256454703117 | 0.6158198405643738 | 0.4747638464552131 | 0.03605897702829619
 | 0.7626649053097845 | 0.3378257661006387 | 0.2935401341510373 | 0.2911563962904764 | 0.2909860499185837 | 0.8795466653497912 | 0.6615888477548364 | 0.8562634826785351 | 0.432090229531382 | 0.466572860006093
Spreadsheet: 0b274b2d-a5a7-4f02-bded-c9e70682bdf6
Sheet: Sheet1

Unnamed: 0 | MONTHLY OPERATING REPORT | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | FOR PUBLIC WATER SYSTEMS THAT ARE USING GROUNDWATER SOURCES
 | OR ARE PURCHASING TREATED WATER FROM ANOTHER PUBLIC WATER SYSTEM
 |  | PUBLIC WATER
 |  | SYSTEM NAME: |  |  |  |  | PWS ID No.:
 |  | Report for |  |  |  |  | Number of Active Service
 |  | the Month of: |  |  |  |  | Connections this Month:
 |  |  |  |  | WATER PRODUCTION
 | Date | Pumpage to storage and distribution X 1000 Gals
 |  | From Wells Directly to [NAME]. |  | From Wells to Storage Tanks | Purchased Water Directly to [NAME]. | Purchased Water into Storage | From SWTP or GWUDI Plant | Total Daily         Production
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | Total
 | Avg
 | [NAME]
 | Min
 | Any additional information you wish to provide:
 |  | I certify that I am familiar with the information contained in this report and that, to the best of my knowledge, the information is true, complete, and accurate.
 | Operator's
 | Signature: |  |  |  |  | Date:
 | Certificate No. and Class:
 | TCEQ - 0811 (DRAFT 7-4-06) |  |  |  |  |  |  |  | GW-PWMOR
 |  | 0.2 | 0.5 |  | 28
Spreadsheet: 1b928a9f-7ee4-4fdb-b7ee-56b8dcd761a9
Sheet: Sheet1

FY15 - NEW SCHOOLS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
School Name | Sponsor | Type of School | District | Lead
Buckeye Preparatory Academy | Buckeye Community Hope Foundation | start-up | Columbus City | Preston
City Prep Academy | Buckeye Community Hope Foundation | start-up | Columbus City | Preston
Norwood Community Conversion School | Norwood City School District | conversion | Norwood City | Preston
R.E.A.C.H. Academy | Buckeye Community Hope Foundation | start-up | Toledo City | Preston
Toledo SMART Elementary | Buckeye Community Hope Foundation | start-up | Toledo City | Preston
United Preparatory Academy | [NAME] | start-up | Columbus City | Preston
Utica Shale Academy of Ohio | Jefferson County ESC | conversion | Southern Local | Preston
Spreadsheet: 695036d1599989134-average-total-by-no-of-days-in-a-month-excluding-weekends-2020-09-13-oeldere2-ibrmoh-695030d1599983287-average-total-by-no-of-days-in-a-month-excluding
Sheet: Sheet2

Holidays | Date
Eid Ramadan Holidays | 2020-05-23 00:00:00
Eid Ramadan Holidays | 2020-05-24 00:00:00
Eid Ramadan Holidays | 2020-05-25 00:00:00
Eid Ramadan Holidays | 2020-05-26 00:00:00
Eid Ramadan Holidays | 2020-05-27 00:00:00
Eid Hajj Holidays | 2020-07-30 00:00:00
Eid Hajj Holidays | 2020-07-31 00:00:00
Eid Hajj Holidays | 2020-08-01 00:00:00
Eid Hajj Holidays | 2020-08-02 00:00:00
Eid Hajj Holidays | 2020-08-03 00:00:00
National Day | 2020-09-23 00:00:00
test day | 2020-02-12 00:00:00
Spreadsheet: 749749d1632992635-fill-with-fill_with
Sheet: SHEET1

 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5
 |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5
 |  |  | EXAMPLE_1 |  |  |  |  | #
 | 1512 | 352 |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  | #
 |  |  | [NAME] |  |  |  | #
 | 1512 | 527 |  |  |  |  | # |  |  | #
 |  |  | EXAMPLE_3 |  |  | #
 | 1512 | 100 |  |  | #
 |  |  |  |  | #
 |  |  | EXAMPLE_4 |  |  |  |  |  | #
 | 1512 | 476 |  |  |  |  | # |  |  | #
 |  |  |  |  |  | # |  |  |  | #
Spreadsheet: 889999d1741106558-exel-2013-conditional-formatting-lowest-8-scores-and-12-highest-scores-from-last-20-entri-format-last-20-scores-in-column-phlebolover-
Sheet: Sheet1

Overall Scores | [NAME] | [NAME] | [NAME]
Handicap
Differential
Handicap Index
Lowest 8 scores average from last 20  (or less ,see table 1)
2024-08-12 00:00:00 | 69 | 65 | 82
2024-08-15 00:00:00 | 73 | 64 | 80
2024-08-19 00:00:00 | 71 | 66 | 78
2024-08-22 00:00:00 | 70 | 69 | 82
2024-08-26 00:00:00 | 68 | 69 | 79 |  |  |  |  |  |  |  |  |  | 71 | Indicates lowest 8 scores of last 20 played
2024-08-29 00:00:00 | 75 | 67 | 78 |  |  |  |  |  |  |  |  |  | 85 | Indicates rest of scores of last 20 played
2024-09-02 00:00:00 | 80 | 75 | 87
2024-09-09 00:00:00 | 74 | 67 | 69
2024-09-16 00:00:00 |  | 65 | 78
2024-09-26 00:00:00 | 68 |  | 71
2024-10-03 00:00:00 | 75 |  |  |  |  |  |  |  |  |  |  |  | At the moment  I use Conditional Formating to indicate the bottom 8 scores of last 20 played (via Format the top and bottom rankled values only rule).But I have to manually count back last 20 scores excluding blanks everytime new scores are added. Could this be done automatically.
2024-10-07 00:00:00 | 72 | 68
2024-10-10 00:00:00 |  | 64
2024-10-14 00:00:00 | 76 | 66 | 79
2024-10-21 00:00:00 | 74 | 70 | 75
2024-10-24 00:00:00 |  | 67 | 76
2024-10-28 00:00:00 | 74 | 71 | 69
2024-10-31 00:00:00 | 71 | 69 | 77
2024-11-04 00:00:00 | 75 | 69 | 79
2024-11-11 00:00:00 | 81 | 67 | 78
2024-11-14 00:00:00 | 67 | 68 | 79
2024-11-18 00:00:00 |  | 66 | 72
2024-11-25 00:00:00 | 66 | 76 | 71
2024-11-28 00:00:00 | 78 | 70 | 74
2024-12-02 00:00:00 | 68 | 61
Spreadsheet: 64939d1265743113-polynomial-function-miles-v-petrol
Sheet: Sheet1

 |  |  | [NAME] | Petrol
 |  |  | 10 | 19.13324192654046
 |  |  | 15 | 25.18839842596951
 |  |  | 20 | 27.22656516372086
 |  |  | 25 | 29.87920255072333
 |  |  | 30 | 33.6154462400464
 |  |  | 35 | 36.68157790309129
 |  |  | 40 | 39.45088579875367
 |  |  | 45 | 41.73913787287672
 |  |  | 50 | 43.25253520100728
 |  |  | 55 | 44.01572719073768
Spreadsheet: michelle_lokay__26655__PGE_PERMIAN
Sheet: Summary

 | EffDt |  |  |  | PGE-PERMIAN SPREAD OPTION VALUE
 | INPUTS
 | PGE price | Permian | Strike | Ann.IntRt | Vol.A | Vol.B | Correlation | ExpDt | OptType |  | Spread | Option Price
 |  |  | 0 | 0.06 |  |  | 0.5 | 2001-10-01 00:00:00 | 1 |  |  | 0.366977443175897
 |  |  |  |  |  |  |  | 2002-01-01 00:00:00 |  |  |  | 0.4471787452631767
 |  |  |  |  |  |  |  | 2002-04-01 00:00:00 |  |  |  | 0.5062300496233648
 |  |  |  |  |  |  |  | 2002-06-01 00:00:00 |  |  |  | 0.5396438868596639
Spreadsheet: 600604d1543865973-vlookup-if-formula-help-to-report-summary-of-tasks-sample-task-list-copy
Sheet: Table1

CLIENT | TASK | EMPLOYEE | DUE | PRIORITY
Acme Corp | Build desk | [NAME] | 2018-12-03 00:00:00 | HIGH
Acme Corp | Order material | [NAME] | 2018-12-04 00:00:00 | HIGH
Ace Inc | Build shelf | [NAME] | 2018-12-05 00:00:00 | HIGH
Ace Inc | Order material | [NAME] | 2018-12-06 00:00:00 | HIGH
AL LLC | Build cabinet | [NAME] | 2018-12-07 00:00:00 | HIGH
AL LLC | Order material | [NAME] | 2018-12-08 00:00:00 | HIGH
ABC | Build table | [NAME] | 2018-12-09 00:00:00 | HIGH
ABC | Order material | [NAME] | 2018-12-10 00:00:00 | HIGH
Spreadsheet: 81513d1281651879-validation-list-and-if-vlookup-formula-approval-portal-v2
Sheet: Portal

 | Purchase Requisition
 |  | Country | Cost Centre
 |  |  |  |  |  | Approver 1 | Deputy 1 | Approver 2 | Deputy 2
 |  | Belgium | 303011010
 | [NAME]
 |  | Country | Cost Centre | Value
 |  |  |  |  |  | Approver 1 | Deputy 1 | Approver 2 | Deputy 2
 |  | Ireland | 312043000 | >150000
Spreadsheet: 59217d1259705861-countif-on-dates-countif_dates
Sheet: Sheet2

 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
Monthly Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 92 | 0
Percent Change From Previous Month
Percent Change From Previous Year
Quarterly Total
Percent Change From Previous Quarter
Percent Change From Previous Year
So, in K2, I'd like to count all the October '09 entries from the first sheet