tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 184651d1349343654-find-the-mode-of-a-column-mostoccuringtextin1column
Sheet: Sheet1

 |  | List of text items
 |  | aaa
 |  | z
 |  | e
 |  | r
 |  | a
 |  | a
 |  | e
 |  | y
 |  | t
 |  | z
 |  | e
 |  | aaa
 |  | e
 |  | w
 |  | t
 |  | r
 |  | y |  | text item has to occur at least twice to be picked up by the "Mode" function ("w" and "q" are not picked up)
 |  | q
 |  | z |  |  |  |  |  | expanded formula, "w" and "q" are picked up
 |  | aaa
 |  | z
 |  | e
 |  | r
 |  | a
 |  | a
 |  | e
 |  | y
 |  | t
 |  | z
 |  | e
 |  | aaa
 |  | e
 |  | e
 |  | t
 |  | r
 |  | y
 |  | z
 |  | z
 |  | aaa
 |  | z
 |  | e
 |  | r
 |  | a
 |  | a
 |  | e
 |  | y
 |  | t
 |  | z
 |  | e
 |  | aaa
 |  | e
 |  | z
 |  | t
 |  | r
 |  | e
 |  | r
 |  | z
 |  | aaa
 |  | z
 |  | e
 |  | r
 |  | a
 |  | a
 |  | e
 |  | y
 |  | t
 |  | z
 |  | e
 |  | aaa
 |  | e
 |  | y
 |  | t
 |  | r
 |  | a
 |  | a
 |  | z
 |  | aaa
 |  | z
 |  | e
 |  | r
 |  | a
 |  | a
 |  | e
Spreadsheet: 841030d1693294501-conditional-formatting-highlight-row-based-on-filtered-batch-book3
Sheet: Sheet1

 |  |  |  |  |  |  |  | Batch | CIF | Qty | Sales
 |  |  |  |  |  |  |  | ABC
 |  |  |  |  |  |  |  | XYZ
 |  |  |  |  |  |  |  | OPQ
 |  |  |  |  |  |  | [NAME] | Batch | CIF | Qty | Sales
 |  |  |  |  |  |  | 123 | ABC | 10 | 150
 |  |  |  |  |  |  | 124 | ABC | 10 | 100 | 900
 |  |  |  |  |  |  | 125 | ABC | 10 | 120 | 1200
 |  |  |  |  |  |  | 126 | XYZ | 12 | 250 | 3000
 |  |  |  |  |  |  | 127 | XYZ | 12 | 200 | 2200
 |  |  |  |  |  |  | 128 | OPQ | 15 | 140 | 3000
Spreadsheet: 826711d1682186054-nested-if-to-pull-most-recent-dates-attendance-tracker-4-22-23-sample
Sheet: Summary

ID# | Employee ID | Assocaite Name | Supervisor | Department | Total Points | WLBD | Tardies | Level | Verbal Warning Date | Stop - VW | Written Warning Date | Stop - WW | Start - Final Written Warning Date | Stop - Final | Date
111111 |  |  |  |  |  |  |  |  | 2022-11-15 00:00:00
222222
333333
444444
555555
666666
777777
888888
999999 |  |  |  |  |  |  |  |  | 2022-11-02 00:00:00 |  | 2022-12-02 00:00:00 |  | 2023-02-02 00:00:00
111112
111113
111114
111115
111116
111117
111118
111119 |  |  |  |  |  |  |  |  | 2023-02-03 00:00:00 |  | 2023-02-04 00:00:00
111120
111121
111122
111123
Spreadsheet: 878418d1725493412-formula-multiple-criteria-with-date-range-and-adding-sample_dates
Sheet: Sheet2

Customer Number | Name | Dates | Date Range End Total | Adjustment Rollover | Amount of Offline Transactions
157575 | First2 Last2 3 |  |  |  |  | This is the section I am Having issues with.
157575 | First2 Last2 3
157575 | First2 Last2 3
123456 | First1 Last 1 2 |  |  |  |  | This formula was hit or miss.  I did a few spot checks and was not always 100% correct.
123456 | First1 Last 1 2
123456 | First1 Last 1 2
Spreadsheet: 697545d1601398387-need-help-with-regression-analysis-sampledata_regression
Sheet: SampleData

Crime | State
Assault | CA
Assault | FL
[NAME] | CA
Theft | FL
[NAME] | TX
Theft | CA
Robbery | TX
Robbery | TX
Theft | TX
Kidnapping | CA
Assault | TX
Robbery | CA
Robbery | FL
Kidnapping | FL
Assault | CA
Homicide | FL
Robbery | TX
[NAME] | FL
Homicide | CA
[NAME] | FL
Homicide | CA
Kidnapping | TX
[NAME] | TX
Theft | FL
[NAME] | TX
Theft | TX
Homicide | FL
Kidnapping | FL
Homicide | FL
Assault | FL
Spreadsheet: 9b04891f-90e8-4224-afc9-28669b78c07d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FPFIB | Test | FPFIB | PROMETHEUS FIBROSpect II | Prometheus FibroSpect II | Nephelometry Enzyme Linked Immunosorbent Assay (ELISA) | Plain, Red-Top or serum gel tube: Red |  |  | 2 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Spin down and send 2 mL of serum refrigerated. | 0.5 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.   Test Performed By:  Prometheus Laboratories, Inc.                                         Therapeutics and Diagnostics                                         9410 Carroll Park Drive                                         San Diego, CA  92121 | Monday through Friday | 4 days | 6-10 days |  | Profile |  |  |  |  | Prometheus Laboratories, Inc. Therapeutics and Diagnostics
FPFIB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FPFIB | Result | Z1520 | PROMETHEUS FIBROSpect II | PROMETHEUS FIBROSpect II | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPFIB | Billing Component | FPFIB |  | Nephelometry, ea Analyte |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 83883
FPFIB | Billing Component | FPFIB |  | Not Otherwise Specified |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 83520
Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Template

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 58538 | 63848
2 | 58642 | 55697
3 | 58406 | 59792
4 | 59692 | 63944
5 | 46721 | 47218
6 | 54155 | 54685
7 | 64066 | 62444
8 | 58452 | 62839
9 | 59525 | 62898
10 | 58572 | 62898
11 | 64462 | 63297
12 | 54763 | 53475
13 | 63725 | 61376
14 | 64469 | 63350
15 | 65261 | 64520
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 14916.9
2001-09-15 00:00:00
CBS Volume
 |  |  | 5234
Spreadsheet: 04cdfa77-0a27-4862-886b-51bfbb2e5e83
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | io | [NAME] | mein |  |  | i miei | meine
 | [NAME] | [NAME] | [NAME] |  |  | i tuoi | deine
 | lui/lei/Lei | [NAME] | sein/ihr/Ihr | amico |  | i suoi/Suoi | seine/ihre/Ihre | amici | (Freunde)
 | noi | [NAME] | unser | (Freund) |  | i nostri | unsere | figli | (Söhne)
 | voi | [NAME] | euer |  |  | i vostri | eure
 | loro | [NAME] | ihr |  |  | i loro | ihre
 | io | la mia | meine |  |  | le mie | meine
 | [NAME] | [NAME] | deine |  |  | le tue | deine
 | lui/lei/Lei | la sua/Sua | seine/ihre/Ihre | [NAME] |  | le sue/Sue | seine/ihre/Ihre | amiche | ([NAME])
 | noi | la nostra | unsere | (Freundin) |  | le nostre | unsere | figlie | ([NAME])
 | voi | la vostra | eure |  |  | le vostre | eure
 | loro | la loro | ihre |  |  | le loro | ihre
Achtung: Bei Verwandtschaftsbezeichnungen wird in der Einzahl [NAME]
(außer vor loro -> vor loro steht immer [NAME])
Spreadsheet: 774573d1648550884-highlight-time-in-a-weekly-booking-schedule-booking-schedule-copy-2-etaf
Sheet: Sheet1

WEEK | 13
TODAY | 2022-03-29 00:00:00 | Monday | 2022-03-28 00:00:00 | Tuesday | 2022-03-29 00:00:00 |  | Wednesday | 2022-03-30 00:00:00 | Thursday | 2022-03-31 00:00:00 |  | Friday | 2022-04-01 00:00:00 | Saturday | 2022-04-02 00:00:00 |  | Sunday | 2022-04-03 00:00:00
Time/Date |  | Left | Right | Left | Right | Time/Date | Left | Right | Left | Right | Time/Date | Left | Right | Left | Right | Time/Date | Left | Right
07:00:00 |  |  |  |  |  | 07:00:00 |  |  |  |  | 07:00:00 |  |  |  |  | 07:00:00
07:30:00 |  |  |  |  |  | 07:30:00 |  |  |  |  | 07:30:00 |  |  |  |  | 07:30:00
08:00:00 |  |  |  |  |  | 08:00:00 |  |  |  |  | 08:00:00 |  |  |  |  | 08:00:00
08:30:00 |  |  |  |  |  | 08:30:00 |  |  |  |  | 08:30:00 |  |  |  |  | 08:30:00
09:00:00 |  |  |  |  |  | 09:00:00 |  |  |  |  | 09:00:00 |  |  |  |  | 09:00:00
09:30:00 |  |  |  |  |  | 09:30:00 |  |  |  |  | 09:30:00 |  |  |  |  | 09:30:00
10:00:00 |  |  |  |  |  | 10:00:00 |  |  |  |  | 10:00:00 |  |  |  |  | 10:00:00
10:30:00 |  |  |  |  |  | 10:30:00 |  |  |  |  | 10:30:00 |  |  |  |  | 10:30:00
11:00:00 |  |  |  |  |  | 11:00:00 |  |  |  |  | 11:00:00 |  |  |  |  | 11:00:00
11:30:00 |  |  |  |  |  | 11:30:00 |  |  |  |  | 11:30:00 |  |  |  |  | 11:30:00
12:00:00 |  |  |  |  |  | 12:00:00 |  |  |  |  | 12:00:00 |  |  |  |  | 12:00:00
12:30:00 |  |  |  |  |  | 12:30:00 |  |  |  |  | 12:30:00 |  |  |  |  | 12:30:00
13:00:00 |  |  |  |  |  | 13:00:00 |  |  |  |  | 13:00:00 |  |  |  |  | 13:00:00
13:30:00 |  |  |  |  |  | 13:30:00 |  |  |  |  | 13:30:00 |  |  |  |  | 13:30:00
14:00:00 |  |  |  |  |  | 14:00:00 |  |  |  |  | 14:00:00 |  |  |  |  | 14:00:00
14:30:00 |  |  |  |  |  | 14:30:00 |  |  |  |  | 14:30:00 |  |  |  |  | 14:30:00
15:00:00 |  |  |  |  |  | 15:00:00 |  |  |  |  | 15:00:00 |  |  |  |  | 15:00:00
15:30:00 |  |  |  |  |  | 15:30:00 |  |  |  |  | 15:30:00 |  |  |  |  | 15:30:00
16:00:00 |  |  |  |  |  | 16:00:00 |  |  |  |  | 16:00:00 |  |  |  |  | 16:00:00
16:30:00 |  |  |  |  |  | 16:30:00 |  |  |  |  | 16:30:00 |  |  |  |  | 16:30:00
17:00:00 |  |  |  |  |  | 17:00:00 |  |  |  |  | 17:00:00 |  |  |  |  | 17:00:00
17:30:00 |  |  |  |  |  | 17:30:00 |  |  |  |  | 17:30:00 |  |  |  |  | 17:30:00
18:00:00 |  |  |  |  |  | 18:00:00 |  |  |  |  | 18:00:00 |  |  |  |  | 18:00:00
18:30:00 |  |  |  |  |  | 18:30:00 |  |  |  |  | 18:30:00 |  |  |  |  | 18:30:00
19:00:00 |  |  |  |  |  | 19:00:00 |  |  |  |  | 19:00:00 |  |  |  |  | 19:00:00
Spreadsheet: 39781d1238070644-multiple-columns-example-5
Sheet: Sheet1

Quarterly Target | wk 1 | wk 2 | wk 3 | wk 4 | wk 5 | wk 6 | wk 7 | wk 8 | wk 9 | wk 10 | wk 11 | wk 12 | wk 13 | Total
200 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 15.38461538461539 | 200
Weekly Target | 15 | 8 | 10 | 16.7 | 16.7 | 16.7 | 16.7 | 16.7 | 16.7 | 16.7 | 16.7 | 16.7 | 16.69999999999999 | 200
Input | 15 | 8 | 10
Spreadsheet: theresa_staab__39636__Enron Statement_0901
Sheet: Enron Imbalance

 |  | Imbalance Statement |  |  | To:
 |  | Date: | 2001-10-18 00:00:00 | Crestone Gathering Services, [NAME] | Enron North America
 |  |  |  | 1400 16th Street | 1200 17th Street, [NAME] 2750
 |  |  |  | Suite 310 | Denver, CO  80202
 |  |  |  | Denver, CO  80202
 |  |  |  | Contact:  [NAME] | Contact:  [NAME]
 |  |  |  | Tel: (720) 946-3692 | Tel:  (303) 575-6465
 |  |  |  | Fax: (720) 946-3640 | Fax: (303) 534-0552
Crestone Gathering Services, L.L.C.
Contract # | PR-G-999
Delivery | Net Receipts | Deliveries | Prior Month | Current Month | Cumulative
Month | MMBtu | MMBtu | Adjustments | Imbalance | Imbalance
 |  |  |  |  | -3395
2001-01-01 00:00:00 | 1863469 | 1865719 |  | 2250 | -1145
2001-02-01 00:00:00 | 1805653 | 1813702 |  | 8049 | 6904
2001-03-01 00:00:00 | 2165432.412555468 | 2145758.893983581 |  | -19673.51857188717 | -12769.51857188717
2001-04-01 00:00:00 | 1799306 | 1814576.664621893 |  | 15270.66462189262 | 2501.146050005453
2001-05-01 00:00:00 | 1865355 | 1902183 |  | 36828 | 39329.14605000545
2001-06-01 00:00:00 | 1928972 | 1922877 |  | -6095 | 33234.14605000545
2001-07-01 00:00:00 | 2048450 | 2050050 |  | 1600 | 34834.14605000545
2001-08-01 00:00:00 | 2059534 | 2048268 |  | -11266 | 23568.14605000545
2001-09-01 00:00:00 | 1884327.652210837 | 1864923.308114246 |  | -19404.34409659076 | 4163.801953414688
* positive balance =  gas due Crestone Gathering Services, L.L.C.
* negative balance = gas owed by Crestone Gathering Services, L.L.C.
________________ | Agree
________________ | Disagree, we show _________________________________ imbalance ([NAME])
 | Signed
 | Title
 | Phone
 | Date
Spreadsheet: 781873d1653595860-sum-values-depending-on-several-criteria-text-and-number-criteria-test
Sheet: 536_rekapitulacija

[NAME]
Šumarija: Ogulin
Gospodarska jedinica: Međuvođe-Zale
 |  |  |  |  |  |  | T-2
[NAME] prihoda | [NAME] drveća |  | Tarifa | Površina (ha)
 |  |  |  |  | Etat | Do [NAME]
Glavni redovni | 02 |  |  |  |  |  | 54
 | 04 |  |  |  |  |  | 279
 | 10 |  |  |  |  |  | 371
 | 16 |  |  |  |  |  | 370
 | 39 |  |  |  |  |  | 53
 | 59 |  |  |  |  |  | 30
 | 19 |  |  |  |  |  | 15
 | 62 |  |  |  |  |  | 750
 | 63 |  |  |  |  |  | 25
 | 61 |  |  |  |  |  | 110
 | 67 |  |  |  |  |  | 1750
 | 70 |  |  |  |  |  | 200
 |  | Ukupno:
Glavni slučajni
 |  | Ukupno:
Ukupno glavni prihod | 02
 | 04
 | 10
 | 16
 | 39
 | 59
 | 19
 | 62
 | 63
 | 61
 | 67
 | 70
 |  | Sveukupno:
Prethodni redovni | 04 |  |  |  |  |  | 760
 | 10 |  |  |  |  |  | 313
 | 16 |  |  |  |  |  | 443
 | 19 |  |  |  |  |  | 76
 | 27 |  |  |  |  |  | 252
 | 59 |  |  |  |  | Revirnik:____________________________________ | 158
 | 39 |  |  |  |  |  | 231
 | 62 |  |  |  |  |  | 719
 | 63 |  |  |  |  |  | 52
 | 61 |  |  |  |  |  | 524
 | 67 |  |  |  |  |  | 1549
 | 79 |  |  |  |  |  | 76
 |  | Ukupno:
Glavni i prethodni prihod | 02
 | 04
 | 10
 | 16
 | 27
 | 39
 | 59
 | 19
 | 62
 | 63
 | 61
 | 67
 | 70
 | 79
 |  | Sveukupno:
Datum: |  |  |  |  |  |  | Revirnik: | [NAME],dipl.ing.šum.
Spreadsheet: 873506d1720008758-data-concentration-sections
Sheet: Φύλλο1

 | All sections |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Section 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Section 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Section 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Section 4
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | W1 | QW34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W1 | QW34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W15 | QW17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W16 | QW43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W90 | QW46
 | W12 | QW11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W12 | QW11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W18 | QW19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W19 | QW76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W92 | QW54
 | W15 | QW22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QW22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QW55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QW87 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QW66
 | W18 | QW23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QW23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QW43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QW77
 | W16 | QW17
 | W19 | QW19
 | W90 | QW55
 | W92 | QW43
 |  | QW43
 |  | QW76
 |  | QW87
 |  | QW77
 |  | QW46
 |  | QW54
 |  | QW66
Spreadsheet: 121551d1316146636-aligning-product-features-into-transactional-columns-excel-question-1-
Sheet: Sheet1

MENS ACCESSORIES (04-40) | HEADWEAR (04-40-404) | VERTICAL 1 | FIT TECHNOLOGIES PTY LTD (101123) | LINE | 1000001384 | BASIC FLEXI 6377 | BASIC FLEXI 6377 | 1000001384 | 1
[NAME] (01-10) | DENIM (01-10-101) | BRANDED | MINT CO P/L- NUDIE JEANS (101037) | NUDIE | 1000001450 | SLIM JIM DRY | BASIC FLEXI 6377 | 1000001384 | 1
MENS TOPS (01-11) | S/S TEES (01-11-107) | VERTICAL 1 | CHANGZHOU LAOSAN GROUP IMP & EXP CO LTD (102073) | LINE | 1000001582 | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | SLIM JIM DRY | 1000001450 | 1
 |  |  |  |  |  |  | SLIM JIM DRY | 1000001450 | 1
 |  |  |  |  |  |  | SLIM JIM DRY | 1000001450 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
 |  |  |  |  |  |  | LINE CREW NAVY MARLE (WAS ONCE BLUE MARLE). | 1000001582 | 1
Spreadsheet: 820745d1678277958-count-times-name-occurs-in-a-week-example
Sheet: Sheet1

week | client |  | would like table
1 | bbc
1 | bbc |  | week | client | number of times client in week
1 | bbc |  | 1 | bbc | 3
1 | itv |  | 1 | itv | 2
1 | itv |  | 1 | c4 | 2
1 | c4 |  | 1 | c5 | 3
1 | c4
1 | c5
1 | c5
1 | c5
2 | bbc
2 | itv
2 | itv
2 | itv
2 | itv
2 | c5
3 | bbc
3 | bbc
3 | bbc
3 | c4
3 | c4
3 | c5
3 | c5
Spreadsheet: 0f0ad938-56c8-4462-b8bc-8f292ca48fc1
Sheet: Personnel Type Contracts

 |  | SFY 2013 STATE CODE SHEET
SFY 2013 STATE EDRS-UFARS codes crosswalk
UFARS Object Codes to EDRS Personnel Type Code
Contracted Services - SERVICE CODE B
UFARS OBJECT CODE | EDRS PTC | [NAME] | EDRS SERVICE CODE
394 | 1 | Teacher (Requires Setting Code) | B
394 | 2 | Program Coordinator/Due Process Facilitator (Non-Supervisory) | B
394 | 3 | Academic & Behavioral Strategist  New | B
394 | 4 | Physical Therapy Services | B
394 | 5 | Occupational Therapy Services | B
394 | 6 | School Nurse | B
394 | 7 | Educational Speech/Language Pathologist (Requires Setting Code) | B
394 | 8 | Paraprofessional/Personal Care Assistant | B
305 | 9 | Director of Special Education | B
305 | 10 | Assistant Director/Supervisor | B
394 | 11 | School Social Worker | B
394 | 12 | Cultural Liaison (Requires Activity Code) | B
394 | 13 | School Psychologist | B
394 | 14 | Audiologist | B
394 | 15 | Adaptive Physical Education Specialist | B
394 | 16 | Consultant (Prior Approval Required) (Requires Activity Code) | B
307 | 23 | Substitute Teachers | B
394 | 25 | Other Licensed/Certified Therapist - e.g. [NAME] or Music Therapist | B
394 | 26 | Foreign Language Interpreter | B
394 | 27 | Vision Media Assistant | B
394 | 28 | Interpreter for the Deaf | B
394 | 29 | Certified Orientation/Mobility Speciaist for Visually Impaired | B
394 | 34 | Assistative Technology Specialist | B
394 | 35 | School Counselor | B
394 | 37 | Certified Orientation/Mobility Assistant for Visually Impaired | B
394 | 38 | Security Specialist | B
394 | 40 | Social Worker for Interagency Activities | B
394 | 42 | Physician (Evaluation Only) | B
394 | 44 | Licensed Nursing Services | B
305 | 45 | Teacher Clerical Support Aide (Due Process) | B
394 | 48 | Behavioral Specialist | B
394 | 49 | Qualified Mental Health Professional | B
394 | 50 | Mental Health Behavioral Aide | B
394 | 52 | Mental Health Practitioner | B
394 | 53 | One - to -  One Paraprofessional | B
305 | 55 | Mentors for Interpreters of the Deaf & Hard of Hearing | B
394 | 57 | Contracted Therapeutic Recreationals | B
307 | 58 | Substitute Para/PCA/One - to - One Para | B
394 | 59 | Speech/Language Pathology Assistant | B
394 | 60 | Special Transportation Nursing Services (IEP MA Reporting Only) | B
394 | 61 | Specail Transportation PCA Services (IEP MA Reporting Only) | B
394 | 62 | Extracurricular Activities (Staff Only) (Requires Activity Code) | B
394 | 63 | Licensed Staff Extra Duty Time  New | B
394 | 64 | Non-Licensed Staff Extra Duty Time  New | B
Spreadsheet: 129217d1321500676-update-multiple-cells-based-on-value-in-another-cell-pay-slip
Sheet: 2011

 |  | Weekly |  |  | YTD
Date | Hours | Gross | Tax | Net | Gross YTD | Tax YTD | Net YTD
2011-11-07 00:00:00 | 15 | 291.5 | 7
2011-11-14 00:00:00 | 15 | 291.5 | 7 | 284.5 | 291.5 | 7 | 284.5
2011-11-21 00:00:00 | 15 | 291.5 | 7 | 284.5 | 583 | 14 | 569
2011-11-28 00:00:00 | 15 | 291.5 | 7 | 284.5 | 874.5 | 21 | 853.5
2011-12-05 00:00:00 | 15 | 291.5 | 7 | 284.5 | 1166 | 28 | 1138
2011-12-12 00:00:00 | 15 | 291.5 | 7 | 284.5 | 1457.5 | 35 | 1422.5
2011-12-19 00:00:00 | 15 | 291.5 | 7 | 284.5 | 1749 | 42 | 1707
2011-12-26 00:00:00 | 15 | 291.5 | 7 | 284.5 | 2040.5 | 49 | 1991.5
2012-01-02 00:00:00 | 15 | 291.5 | 7 | 284.5 | 2332 | 56 | 2276
2012-01-09 00:00:00 | 15 | 291.5 | 7 | 284.5 | 2623.5 | 63 | 2560.5
2012-01-16 00:00:00 | 15 | 291.5 | 7 | 284.5 | 2915 | 70 | 2845
2012-01-23 00:00:00 | 15 | 291.5 | 7 | 284.5 | 3206.5 | 77 | 3129.5
2012-01-30 00:00:00 | 15 | 291.5 | 7 | 284.5 | 3498 | 84 | 3414
2012-02-06 00:00:00 | 15 | 291.5 | 7 | 284.5 | 3789.5 | 91 | 3698.5
2012-02-13 00:00:00 | 15 | 291.5 | 7 | 284.5 | 4081 | 98 | 3983
2012-02-20 00:00:00 | 15 | 291.5 | 7 | 284.5 | 4372.5 | 105 | 4267.5
2012-02-27 00:00:00 | 15 | 291.5 | 7 | 284.5 | 4664 | 112 | 4552
2012-03-05 00:00:00 | 15 | 291.5 | 7 | 284.5 | 4955.5 | 119 | 4836.5
2012-03-12 00:00:00 | 15 | 291.5 | 7 | 284.5 | 5247 | 126 | 5121
2012-03-19 00:00:00 | 15 | 291.5 | 7 | 284.5 | 5538.5 | 133 | 5405.5
2012-03-26 00:00:00 | 15 | 291.5 | 7 | 284.5 | 5830 | 140 | 5690
2012-04-02 00:00:00 | 15 | 291.5 | 7 | 284.5 | 6121.5 | 147 | 5974.5
2012-04-09 00:00:00 | 15 | 291.5 | 7 | 284.5 | 6413 | 154 | 6259
Spreadsheet: 91de84fa-198c-47ff-ad7d-5e3c91d377f8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6129 | 16392 | [NAME] | [NAME] | RSA | 0 | 00:21:54 | 00:00:21 | 01:00:45 | [NAME] | 00:36:53 | 1 | 02:00:19
6129 | 25822 | Berndt | Burger | RSA | 17 | 00:22:51 | 00:00:20 | 01:02:32 | 00:00:30 | 00:36:02 | 2 | 02:02:16
6129 | 12816 | Wikus | Weber | RSA | 15 | 00:19:55 | 00:00:21 | 01:02:45 | [NAME] | 00:39:43 | 3 | 02:03:11
6129 | 11419 | [NAME] | [NAME] | RSA | 18 | [NAME] | 00:00:28 | 01:02:05 | 00:00:27 | 00:48:31 | 4 | 02:12:46
6129 | 12172 | [NAME] | Blignaut | RSA | 20 | [NAME] | 00:00:23 | 01:02:11 | 00:00:27 | 00:00:00 | DNF | 00:00:00
6129 | 15988 | Valery | De Falbaire | MRI | 16 | 00:20:02 | 00:00:21 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: b90a527e-b58b-4c5e-8b4f-96c75d7674bd
Sheet: DRA2

Instrument Name: | Developmental Reading Assessment 2nd edition (DRA2)
Vendor: | Pearson
Purpose: | DRA2 enables primary teachers to systematically observe, record, and evaluate changes in student reading performance. DRA2 provides teachers with information that helps teachers determine each student’s independent reading level and identify what the student needs to learn next.
Content Area and Student Population: | The DRA2 does not assess content. It provides a reading level. DRA2 includes a K-3 kit and a 4-8 kit.
Frequency: | The assessment can be used on a semi-annual or annual basis to monitor and document change over time in each student’s reading. It may be used more frequently with struggling readers to ensure continued progress. Testing windows are set at the local level.
Alignment: | Concurrent validity is reported in the technical manual (Page 56): http://assets.pearsonschool.com/asset_mgr/current/20139/DRA2_Technical_Manual_2012.pdf
BEGIN ENTERING DATA BELOW
Number of Students in October Count:
Number of Students Tested:
 |  | Developing |  | Instructional |  | Independent |  | Advanced |  | Totals and Goals
Grade | DRA2 Level | #of Students | %of Total | #of Students | %of Total | #of Students | %of Total | #of Students | %of Total | #of Students | Grade Totals | Goal: 50% of Students Meeting Goal (Green=Yes, Red=No)
K | A
K | 1
K | 2
K | 3
1 | 4
1 | 6
1 | 8
1 | 10
1 | 12
1 | 14
1 | 16
2 | 18
2 | 20
2 | 24
2 | 28
3 | 30
3 | 34
3 | 38
3 | 40
4 | 40
5 | 50
6 | 60
7 | 70
8 | 80