tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 158eea83-e6bf-4684-9016-55573e62afc1
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 | Unnamed: 12
 |  |  |  |  | MEAL MONEY FORM
Event(s) |  |  | Inclusive Dates From |  |  |  | to |  |  | Activity
 | (if applicable) |  |  |  |  |  |  |  |  |  | (if applicable)
I certify that I have received |  | $ |  | for the following: |  |  |  | Meal Money
 |  |  |  |  |  |  |  | Other (specify)
 |  |  |  |  |  |  |  | Other (specify)
 | SIGNED |  |  | TITLE/AFFILIATION |  |  | SIGNED |  |  |  | TITLE/AFFILIATION
1. |  |  |  |  |  | 21
2. |  |  |  |  |  | 22
3. |  |  |  |  |  | 23
4. |  |  |  |  |  | 24
5. |  |  |  |  |  | 25
6. |  |  |  |  |  | 26
7. |  |  |  |  |  | 27
8. |  |  |  |  |  | 28
9. |  |  |  |  |  | 29
10. |  |  |  |  |  | 30
11. |  |  |  |  |  | 31
12. |  |  |  |  |  | 32
13. |  |  |  |  |  | 33
14. |  |  |  |  |  | 34
15. |  |  |  |  |  | 35
16. |  |  |  |  |  | 36
17. |  |  |  |  |  | 37
18. |  |  |  |  |  | 38
19. |  |  |  |  |  | 39
20. |  |  |  |  |  | 40
Show computation as follows:
 | Computation of allowance per person: |  |  |  |  |  | Computation of total disbursement:
 |  |  |  |  |  |  |  | $ amount |  | # of days |  | Total
1st Day   $ |  | X |  | $ | 0
 |  |  |  |  |  |  | $ |  | X |  | $ | 0
Full Days $ |  | X |  | $ | 0
Last Day  $ |  | X |  | $ | 0
 |  |  |  |  |  |  | Signature of Responsible Person                Date
 |  |  | TOTAL | $ | 0
Spreadsheet: 800639d1665766345-special-issue-if-functions-and-display-splits-book1-1-
Sheet: Sheet1

class | type | cell type | stimuli | concentration | value | …
a | 1 | M1 | B | 0.5 | 50 |  |  |  | 2 | M1 | A | 0.5 | 65
a | 1 | M1 | B | 5 | 23 |  |  | e | 2 | M2 | A | 0.5 | 34
a | 2 | M1 | B | 0.5 | 98 |  |  | a | 1 | M1 | B | 0.5 | 50
a | 2 | M1 | B | 5 | 43 |  |  | a | 2 | M1 | B | 0.5 | 98
b | 3 | M1 | X | 0.5 | 54 |  |  | d | 1 | M1 | B | 0.5 | 87
b | 3 | M1 | X | 5 | 23 |  |  | a | 1 | M1 | B | 5 | 23
b | 4 | M1 | X | 0.5 | 65 |  |  | a | 2 | M1 | B | 5 | 43
c | 1 | M2 | C | 0.5 | 54 |  |  | d | 1 | M1 | B | 5 | 34
c | 1 | M2 | C | 5 | 76 |  |  | c | 1 | M2 | C | 0.5 | 54
c | 2 | M2 | C | 0.5 | 54 |  |  | c | 2 | M2 | C | 0.5 | 54
c | 2 | M2 | C | 5 | 34 |  |  | e | 1 | M1 | C | 0.5 | 23
d | 1 | M1 | B | 0.5 | 87 |  |  | c | 1 | M2 | C | 5 | 76
d | 1 | M1 | B | 5 | 34 |  |  | c | 2 | M2 | C | 5 | 34
d | 2 | M1 | A | 0.5 | 65 |  |  | e | 1 | M1 | C | 5 | 56
e | 1 | M1 | C | 0.5 | 23 |  |  | b | 3 | M1 | X | 0.5 | 54
e | 1 | M1 | C | 5 | 56 |  |  | b | 4 | M1 | X | 0.5 | 65
e | 2 | M2 | A | 0.5 | 34 |  |  | b | 3 | M1 | X | 5 | 23
a | base |  |  |  | 54
b | base |  |  |  | 76
c | base |  |  |  | 89
d | base |  |  |  | 23
e | base |  |  |  | 65
Spreadsheet: drew_fossum__8994__Fixed3_103100
Sheet: ENA_20

NORTHERN NATURAL GAS COMPANY
FUEL HEDGING BOOK
Enron North America_20
Prod. | Contract | Contract | Strike |  | Fuel | Floating | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  |  |  | (4) | (4) | (4)
2000-11-01 00:00:00 |  | ENA-Call Option | 0.775 |  | 500000
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: eric_saibi__9954__110701R
Sheet: Dresden 02

Owner Name |  | Exelon Nuclear
Station Name |  | Dresden Nuclear Power Station
Unit Name |  | Dresden 02
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nuclear
Capacity |  | 828 MW
Start Date |  | 2001-10-20 00:00:00
End Date |  | 2001-11-07 00:00:00
Prv. Start Date |  | 2001-10-20 00:00:00
Prv. End Date |  | 2001-11-20 00:00:00
Comments |  | Refuel, Hoping to be at 100% by Friday
SIC |  | 4931
Plant ID |  | 1009265
Unit ID |  | 1007231
Outage ID |  | 8100
Spreadsheet: darrell_schoolcraft__7667__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2002-01-16 00:00:00
 |  |  | SoCal Gas Price |  | 2.25
 |  |  | San Juan Gas Price |  | 2.135
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 485 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 540 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 540 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 540 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 540 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 540 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 540 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 540 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 540 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 540 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 540 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 540 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 540 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 540 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 540 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 540 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 540 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 485 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 485 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 485 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 485 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 485 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 485 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 485 | 7
Spreadsheet: 773936d1648124579-formula-range-based-on-another-cell-value-test-demo2
Sheet: Sheet1

 |  |  |  |  |  | POINT | RESULT1 | RESULT2 | RESULT3...
 |  |  |  |  |  | 1 | 1.1 | 1.6
 |  |  |  |  |  | 2 | 1.5 | 1.4
 |  |  |  |  |  | 3 | 2.5 | 1.3
 |  |  |  |  |  | 4 | 2.1 | 2.2
 |  |  |  |  |  | 5 | 1.5 | 1.3
 |  |  |  |  |  | 6 | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 7 | 2.5 | 1.3
 |  |  |  | 3 | 6
 |  |  |  |  |  | 8 | 1.1 | 1.6
 |  |  |  |  |  | 9 | 1.4 | 1.4
 |  |  |  |  |  | 10 | 1.3 | 1.3
 |  |  |  |  |  | 11 | 2.1 | 2.2
 |  |  |  |  |  | 12 | 1.2 | 2.1
 |  |  |  |  |  | 13 | 1.2 | 1.6
 |  |  |  | FROM | UNTIL | 14 | 2.5 | 1.3
 |  |  |  | 10 | 14
Spreadsheet: phillip_m_love__30686__WACOG 06-00
Sheet: Sheet1

WACOG  for 06/00 Production
West | 3.998
Texas | 4.283
Sithe | 4.3
Ontario | 4.38
Mkt E | 4.51
East | 4.293
Midwest | 4.425
Denver | 3.406
Central | 4.24
Peoples | 4.25
Spreadsheet: 160476d1339090903-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: MedicalManagement

Announcement Number | Employee Announcements
Medical Management1
Medical Management2
Medical Management3
Medical Management4
Medical Management5
Announcement Number | Manager [NAME]
Medical Management1manager
Medical Management2manager
Medical Management3manager
Spreadsheet: 504fa7a0-1550-4b02-8658-96343a1b71ff
Sheet: Sheet1

Prilog 1. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Razdoblje izvještavanja: |  |  |  | 01.01.2012. |  | do | 31.03.2012.
Tromjesečni financijski izvještaj poduzetnika TFI-POD
Matični broj (MB): |  | 03051773
Matični broj subjekta ([NAME]): |  | 040060543
Osobni identifikacijski broj (OIB): |  | [PHONE]
Tvrtka izdavatelja: |  | LAGUNA NOVIGRAD D.D.
Poštanski broj i mjesto: |  | 52466 |  |  | NOVIGRAD
Ulica i kućni broj: |  | ŠKVERSKA 8
Adresa e-pošte: |  | [EMAIL]
Internet adresa: |  | www.laguna-novigrad.hr
Šifra i naziv općine/grada: |  | 291 | NOVIGRAD
Šifra i naziv županije: |  | 18 | ISTARSKA |  |  |  | Broj [NAME]: | 234
 |  |  |  |  |  |  | ([NAME])
Konsolidirani izvještaj: |  | NE |  |  |  | Šifra NKD-a: |  | 5510
[NAME] subjekata konsolidacije (prema MSFI): |  |  |  | Sjedište: |  |  | MB:
Knjigovodstveni servis:
Osoba za kontakt: |  | PALFI FABIJANA
 |  | (unosi se samo prezime i ime osobe za kontakt)
Telefon: |  | 052/858-617 |  |  |  | Telefaks: | 052/726-622
Adresa e-pošte: |  | [EMAIL]
Prezime i ime: |  | BOKULIĆ ZRINKA
 |  | (osoba ovlaštene za zastupanje)
 | Dokumentacija za objavu:
 | 1. [NAME] izvjštaji (bilanca, račun dobiti i gubitka, izvještaj o novčanom tijeku, izvještaj o promjenama
 | [NAME] i bilješke uz financijske izvještaje)
 | 2. Međuizvještaj poslovodstva,
 | 3. [NAME] osoba odgovornih za sastavljanje izvještaja izdavatelja.
 |  |  |  | M.P. |  | (potpis osobe [NAME])
Spreadsheet: 366935d1419581180-how-to-divide-a-number-randomly-between-cells-randum-destribution
Sheet: Sheet2

239
Spreadsheet: 94460d1294263316-need-help-creating-a-timesheet-to-track-one-employee-over-different-jobs-jobssheets
Sheet: 12-25-10

[NAME]
Date | Job # | Customer | Job | Operation | Start | End | Total | Paid
2010-12-21 00:00:00 | 4 |  |  |  | 11:30:00 | 13:45:00 |  | Yes
2010-12-21 00:00:00 | 4 |  |  |  | 14:40:00 | 15:40:00 |  | Yes
2010-12-22 00:00:00 | 2 |  |  |  | 14:10:00 | 16:10:00 |  | Yes
2010-12-22 00:00:00 | 2 |  |  | Travel - Material and [NAME] | 12:00:00 | 13:45:00 |  | Yes
2010-12-23 00:00:00 | 2 |  |  | 15 finished | 10:45:00 | 16:45:00 |  | No
2010-12-23 00:00:00 | 2 |  |  | [NAME] to width | 16:45:00 | 18:00:00 |  | No
 |  |  |  |  | Hours Worked
 |  |  |  |  | Hours Paid
 |  |  |  |  | Hours Unpaid
Spreadsheet: 187209d1350380084-mirroring-two-ranges-of-cells-so-that-either-range-could-be-edited-and-saved-in-the-other-test
Sheet: Period 1

 | School Name | Average | 0 | 0.6 | 0.63 | 0.67 | 0.7 | 0.73 | 0.77 | 0.8 | 0.83 | 0.87 | 0.9 | 0.93 | 0.97
 |  | [NAME] | F | D- | D | [NAME] | C- | C | C+ | B- | B | [NAME] | A- | A | A+
 | Teachers
 | Period 1 |  |  | Assignment or Test Name
 | 2012 |  |  | Total Points
 |  |  |  | AVERAGE
 | Student Name | Average | [NAME] | Assessment | Lab/ICA | Midterm | Final | Project
 | Student 1 |  |  |  |  |  |  |  | 3 | 3.5 | 3 | 41.25 | 7.5 | 4 | 20 | 57 | 49 | 68 | 3.5 | 3.5 | 80 | 85 | 3
 | Student 2 |  |  |  |  |  |  |  | 3 | 3.5 | 4 | 50 | 8 | 4 | 34 | 85.5 | 32 | 85 | 3.5 | 3.5 | 90 | 93 | 4
 | Student 3 |  |  |  |  |  |  |  | 3 | 4 | 4 | 48.75 | 8 | 4 | 48 | 90.5 | 48 | 88.5 | 4 | 4 | 80 | 83 | 3
 | Student 4 |  |  |  |  |  |  |  | 3.5 | 3.5 | 4 | 47.5 | 7.5 | 4 | 30 | 81 | 35 | 90 | 4 | 3.5 | 100 | 93 | 3.5
 | Student 5 |  |  |  |  |  |  |  | 3.5 | 4 | 4 | 46.25 | 8 | 4 | 44 | 75 | 35 | 93 | 4 | 3.5 | 100 | 88 | 3.5
 | Student 6 |  |  |  |  |  |  |  | 3.5 | 3.5 | 4 | 45 | 7 | 4 | 46 | 58.5 | 50 | 80 | 3.5 | 2 | 90 | 88 | 3.5
 | Student 7 |  |  |  |  |  |  |  | 4 | 4 | 4 | 35 | 7.5 | 4 | 30 | 83 | 32 | 84.5 | 4 | 3.5 | 90 | 73 | 4
 | Student 8 |  |  |  |  |  |  |  | 3 | 4 | 4 | 37.5 | 7.5 | 4 | 40 | 87 | 32 |  |  |  | 90 |  | 4
 | Student 9 |  |  |  |  |  |  |  | 3 | 3.5 | 3.5 | 48.75 | 7.5 | 4 | 36 | 90 | 35 | 78 | 3.5 | 2 | 90 | 75 | 4
 | Class Summary
 | Average
 | Highest Score
 | Lowest Score
 | Grade Categories | % of Final Grade
 | Assessment | 0.2
 | Lab/ICA | 0.3
 | Midterms | 0.2
 | Final | 0.15
 | Project | 0.15
 | TOTAL
Spreadsheet: 276028d1383732826-rather-complicated-lookup-problem-containing-2-linked-sheets-lookup
Sheet: Request

 |  | After selecting the 'Matter', the following 3 cells should be filled in with the corresponding information from 'Authorisation' automatically
 |  |  | This should say a number
 |  |  | fromt the authorisation sheet.
 |  |  | (Like 2.500)
Approved | Function | Matter | Autorisation | Reports | Function
by |  |  | level | to
Person 2 |  | Expense reports | 1500 | Chief 2 | Production manager 2
Person 29 |  | Raw material & supplies production | 2500 | Chief 29 | Production manager 29
Person 43 |  | Debit and credit memo's | 100000
Select person
Select person
Select person
Select person
Spreadsheet: phillip_m_love__30695__July_Sithe_PriceBasisIndex_revised
Sheet: Basis

855438
 |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
FT-CENTRAL | N38268.U | P | CGPR-ST.CLAIR | 01-JUL-2000 | 559484 | 0 | 1 | 0.0425 | 1e-07 | 0 | 23778.0141
INTRA-CNT-MKT | NO7810.1 | P | IF-ANR/ML7 | 01-JUL-2000 | -713000 | 0 | 1 | 0.111 | 0.085 | 0 | -18538
FT-ONTARIO | NO7825.1 | P | CGPR-ST.CLAIR | 01-JUL-2000 | 155000 | 0 | 1 | 0.0425 | 0.025 | 0 | 2712.5
FT-CENTRAL | NQ0697.2 | P | CGPR-FARWELL | 01-JUL-2000 | 20871 | 0 | 1 | 0.081 | 1e-07 | 0 | 1690.5489
FT-CENTRAL | NQ0697.4 | P | CGPR-FARWELL | 01-JUL-2000 | -20871 | 0 | 1 | 0.081 | 1e-07 | 0 | -1690.5489
FT-CENTRAL | NU0175.1 | P | CGPR-ST.CLAIR | 01-JUL-2000 | -185285 | 0 | 1 | 0.0425 | 1e-07 | 0 | -7874.594
Spreadsheet: 99626d1298241226-need-to-change-the-cell-to-refer-to-subscription-test
Sheet: 3

Item to Send: | Date to Send Product | Sent? | [NAME]?
A | 2010-05-10 00:00:00 | yes | yes
B | 2010-08-17 00:00:00 | no | Yes
C | 2010-09-13 00:00:00 | no | No
 |  | Not Sent Out | Not Complete
 |  | Sent Out | Complete
Spreadsheet: 820083d1677856037-adding-a-number-to-a-calculated-number-1-or-2-based-on-a-range-test
Sheet: Sheet2

No. of Bundles |  | Range |  | Adder if in these ranges
2.6 |  | 0 | 0.5 | 1
0.49 |  | 0.51 | 0.99 | 2
 |  | 1 | 1.5 | 1
 |  | 1.51 | 1.99 | 2
 |  | 2 | 2.5 | 1
 |  | 2.51 | 2.99 | 2
 |  | 3 | 3.5 | 1
 |  | 3.51 | 3.99 | 2
 |  | 4 | 4.5 | 1
 |  | 4.51 | 4.99 | 2
 |  | 5 | 5.5 | 1
 |  | 5.51 | 5.99 | 2
Spreadsheet: 0acc8201-e5d2-4c09-99c1-246820da5d19
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 31. LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), 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 | A2413975X | 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 | A2413976A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413977C | 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 | A2413978F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413979J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413980T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413981V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413982W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413983X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413984A | 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 | A2413985C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413986F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413987J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413988K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413989L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413990W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 778766d1651306616-unable-to-get-index-match-to-make-data-from-one-worksheet-to-to-a-summary-worksheet-index-match-sample-file-aligw
Sheet: BT Investors Choice

This is the worksheet INTO which I want to pull data using INDEX/Match
to come FROM the Combined worksheet
 | Account Number | Bank Statement Order Number | Date |  |  |  |  |  | Expected Value
BT Investors Choice | 1026 |  |  |  |  |  |  |  | 0
BT Investors Choice | 2180 |  |  |  |  |  |  |  | 1
BT Investors Choice | 2180 |  |  |  |  |  |  |  | 2
BT Investors Choice | 2180 |  |  |  |  |  |  |  | 3
BT Investors Choice | 2180 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 1 |  | 2020-07-01 00:00:00
I am using the suggested formulae: |  |  |  |  |  |  |  |  | 2 | 1 | 2020-10-01 00:00:00
 | Expected Value |  |  |  |  |  |  |  | 3 | 2 | 2020-01-01 00:00:00
 | 1 |  |  |  |  |  |  |  | 4 | 3 | 2020-04-01 00:00:00
 | 1 |  |  |  |  |  |  |  | Blank | 4 | 2021-06-30 00:00:00
What am I doing incorrrectly in EACH formula?
Index | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
Match | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
 | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
Spreadsheet: 137675d1327315381-matching-meeting-criteria-from-worksheet-to-worksheet-aa220112
Sheet: Selections

 |  | Dubbo | 1 | 8 | Run Legless | 8. Run Legless | 8. Run Legless | 3
 |  | Dubbo | 3 | 1 | Betarzi | 1. Betarzi | 1. Betarzi | 2
 |  | Dubbo | 3 | 2 | [NAME] | 2. Donato | 2. Donato | 1
 |  | Dubbo | 4 | 1 | Bramante | 1. Bramante | 1. Bramante | 7
 |  | Dubbo | 4 | 4 | Hes Invincible | 4. Hes Invincible | 4. Hes Invincible | 1
 |  | Dubbo | 5 | 1 | Bottled Up | 1. Bottled Up | 1. Bottled Up | 5
 |  | Dubbo | 6 | 1 | [NAME] | 1. Czar Of Yangery | 1. Czar Of Yangery | 3
 |  | Dubbo | 6 | 7 | [NAME] | 7. Panov | 7. Panov | 1
 |  | Dubbo | 6 | 8 | Royal Society | 8. Royal Society | 8. Royal Society | 1
 |  | Dubbo | 6 | 11 | Urania Crown | 11. Urania Crown | 11. Urania Crown | 5
 |  | Dubbo | 7 | 1 | [NAME] | 1. [NAME] | 1. [NAME] | 1
 |  | Dubbo | 7 | 6 | [NAME] | 6. [NAME] | 6. [NAME] | 1
 |  | Dubbo | 7 | 7 | Korvey Choice | 7. Korvey Choice | 7. Korvey Choice | 1
 |  | Dubbo | 7 | 8 | Midnite Crusade | 8. [NAME] | 8. [NAME] | 4
 |  | Dubbo | 7 | 10 | [NAME] | 10. [NAME] | 10. [NAME] | 1
 |  | Dubbo | 7 | 12 | Steel Spring | 12. Steel Spring | 12. Steel Spring | 2
 |  | Dubbo | 7 | 13 | Little Rikki | 13. Little Rikki | 13. Little Rikki | 1
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
 |  |  |  |  |  | .
Spreadsheet: 83992d1283997528-simple-data-formatting-seek4help
Sheet: Sheet1

Username | Computer | Action | Date | Time
UserA | PC 11 | logon | 20/07/2010 | 13:41:01
UserA | PC 11 | logoff | 20/07/2010 | 13:41:03
UserB | PC 11 | logon | 20/07/2010 | 15:35:00
UserB | PC 11 | logoff | 20/07/2010 | 15:35:03
Spreadsheet: 889514d1740364343-special-function-cell-to-generate-graphs-automatically-for-certain-week-ranges-tool-downtime-4-
Sheet: Sheet1

Month | Year | Factory MA | SDUT | Reference
Spreadsheet: 728630d1618549244-if-cell-contains-certain-rule-then-copies-a-range-of-other-cells-to-another-tab-permit-register-example-2
Sheet: BP

ABC Job Number | Address | Description | Client | Date of Confirmation  to Proceed | Permit  Number
Spreadsheet: 35841d1233578208-formula-that-will-give-me-true-or-false-results-test1
Sheet: Sheet1

Last Name | First Name |  | Hire/Term Date | Active | Fulltime | Permanent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] as Range Set Rng = Range(Range("A1"), Range("A" & Rows.Count).End(xlUp))
DOE | [NAME] | BEKELE | 2005-04-29 00:00:00 | 1 | 0 | 0
DOE | [NAME] |  | 2008-01-18 00:00:00 | 1 | 0 | 0 |  | DOE / [NAME] | 1
DOE | [NAME] |  | 2008-07-23 00:00:00 | 0 | 1 | 1 |  | DOE / JANE | 0
SMITH | JON |  | 2007-07-10 00:00:00 | 0 | 0 | 0 |  | SMITH / JON | 0
SMITH | JON |  | 2008-01-24 00:00:00 | 0 | 0 | 0 |  | DOE / JUSTIN | 1
DOE | JUSTIN |  | 2003-05-23 00:00:00 | 1 | 0 | 0 |  | ANDREW / JANE | 1
DOE | JUSTIN |  | 2003-08-12 00:00:00 | 1 | 0 | 0 |  | Bloggs / Fred | 0
ANDREW | [NAME] |  | 2003-05-29 00:00:00 | 1 | 0 | 1 |  | Smith / Tim | 1
ANDREW | [NAME] |  | 2005-08-24 00:00:00 | 0 | 0 | 0 |  | Jones / Brian | 0
ANDREW | [NAME] |  | 2005-12-16 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2007-02-28 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2007-05-11 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2007-06-04 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2007-07-28 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2008-01-31 00:00:00 | 0 | 1 | 1
ANDREW | [NAME] |  | 2008-04-30 00:00:00 | 1 | 1 | 1
DOE | [NAME] | BEKELE | 2005-04-29 00:00:00 | 1 | 0 | 0
DOE | [NAME] |  | 2008-01-18 00:00:00 | 1 | 0 | 0
DOE | [NAME] |  | 2008-07-23 00:00:00 | 0 | 1 | 1
SMITH | JON |  | 2007-07-10 00:00:00 | 0 | 0 | 0
SMITH | JON |  | 2008-01-24 00:00:00 | 0 | 0 | 0
DOE | JUSTIN |  | 2003-05-23 00:00:00 | 1 | 0 | 0
DOE | JUSTIN |  | 2003-08-12 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2003-05-29 00:00:00 | 1 | 0 | 1
ANDREW | [NAME] |  | 2005-08-24 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2005-12-16 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2007-02-28 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2007-05-11 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2007-06-04 00:00:00 | 0 | 0 | 0
ANDREW | [NAME] |  | 2007-07-28 00:00:00 | 1 | 0 | 0
ANDREW | [NAME] |  | 2008-01-31 00:00:00 | 0 | 1 | 1
ANDREW | [NAME] |  | 2008-04-30 00:00:00 | 1 | 1 | 1
Bloggs | Fred |  |  | 1
Bloggs | Fred |  |  | 1
Bloggs | Fred |  |  | 1
Bloggs | Fred |  |  | 0
Smith | [NAME] |  |  | 1
Smith | [NAME] |  |  | 1
Smith | [NAME] |  |  | 0
Smith | [NAME] |  |  | 1
Jones | [NAME] |  |  | 0
Spreadsheet: 613451ab-348a-4932-b143-2c3e10964aed
Sheet: UVA Leadership Pilot

Grant: |  | Title 1A UVA Leadership Pilot |  |  |  |  |  | Title 1A UVA Leadership Pilot
CFDA # |  | 84.010
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2013-14
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]-866-6724  or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - September 15, 2014
Code | District Name | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY  2013 | AUGUST  2013 | SEPTEMBER  2013 | OCTOBER  2013 | NOVEMBER  2013 | DECEMBER  2013 | JANUARY  2014 | FEBRUARY  2014 | [NAME]  2014 | APRIL  2014 | MAY  2014 | JUNE  2014 | JULY  2014 | AUGUST  2014 | SEPTEMBER  2014
30 | Adams 14 | [NAME], [NAME], Adams City Middle School | 47914 |  |  |  |  |  | 25297 |  | 3223
123 | [NAME] | [NAME], Middle, and [NAME] | 8400
3140 | Weld RE-8 | District Wide | 231000 |  |  |  |  |  | 36000
Spreadsheet: 79259d1279551599-convert-data-from-columns-to-rows-sample
Sheet: Sheet4

Count of Customer | Product |  |  |  |  | referenced left | are you sure you want these? |  | vlookups |  |  |  |  | products
Customer | Cable | [NAME] | Pipe | Rope |  | Customer | Product | type | address | city | state | zip | Fax# | prod1 | prod2 | prod3 | prod4
[NAME]'s Plumbing | 1 | 1 | 1 | 1
[NAME]'s Irrigation |  | 1
Joes's Mechanical | 1 | 1 | 1