tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 016fe966-91f6-4036-a960-748803cc05ba
Sheet: Sheet1

Unnamed: 0 | DeKalb County School District | Unnamed: 2 | Unnamed: 3
 | Proposed Job Classification Listing with Salary Ranges
 | 2012-2013
 | PARAPROFESSIONAL | 22969 | 46243.2
 | Paraprofessional I | 22969 | 31245
 | Paraprofessional II | 25486 | 33245
 | Paraprofessional III | 33986.4 | 46243.2
 | CLERK/LABORER | 23617 | 42413
 | Clerk/Laborer I | 23617 | 33139
 | Clerk/Laborer II | 25987 | 36044
 | Clerk/Laborer III | 30165 | 42413
 | SECRETARY/ADM ASST | 30165 | 63808
 | Secretary | 30165 | 41808
 | Administrative Assistant | 34918 | 47509
 | Executive Assistant | 37171 | 53068
 | Office Specialist | 45808 | 63808
 | SECURITY | 32016 | 63973
 | Security I | 32016 | 45642
 | Security II | 40653 | 55317
 | Security III | 45808 | 63973
 | MECHANIC/TECHNICIAN | 37420 | 60487
 | Mechanic/Technician I | 37420 | 50907
 | Mechanic/Technician II | 40982 | 55767
 | Mechanic/Technician III | 44462 | 60487
 | SUPERVISOR | 45477 | 68157
 | Supervisor I | 45477 | 59599
 | Supervisor II | 47671 | 64856
 | [NAME] | 50100 | 68157
 | ACCOUNTANT/AUDITOR | 38304 | 66151
 | Accountant/Auditor I | 38304 | 52108
 | Accountant/Auditor II | 45808 | 62328
 | Accountant/Auditor III | 48626 | 66151
 | ANALYST | 43154 | 80743
 | Anaylst I | 43154 | 58711
 | Analyst II | 44340 | 65180
 | Analyst III | 59928 | 80743
 | SPECIALIST | 46376 | 76651
 | Specialist I | 46376 | 63096
 | Specialist II | 53085 | 72154
 | Specialist III | 56450 | 76651
 | TEACHER | 52635 | 103821
 | Teacher | 52635 | 103821
 | Counselor | 52635 | 103821
 | Psychologist | 52635 | 103821
 | MANAGER | 66967 | 106606
 | Manager I | 66967 | 92324
 | Manager II | 75444 | 99544
 | Manager [NAME] | 80638 | 106606
 | COORDINATOR | 54807 | 106606
 | Coordinator I | 54807 | 96358
 | Coordinator II | 59937 | 104228
 | Coordinator III | 80638 | 106606
 | ASSISTANT PRINCIPAL | 61831 | 112725
 | Assistant Principal I - E | 61831 | 110725
 | Assistant Principal II (M/H) | 63831 | 112725
 | PRINCIPAL | 84638 | 118482
 | Principal I -E | 84638 | 115742
 | Principal II  -M | 85268 | 116360
 | [NAME] | 86725 | 118482
 | DIRECTOR | 85725 | 116994
 | Executive Director | 89176 | 116994
 | Director | 85725 | 112482
 | ADMINISTRATIVE LEADERSHIP | 119908 | 122471
 | Regional Superintendent | 119908 | 122471
 | Associate Superintendent | 121726 | 122471
 | [NAME] HEAD | 159885 | 159885
 | Deputy/Chief | 159885 | 159885
Spreadsheet: 747118d1631237489-us-tax-code-nested-if-equation-help-taxbase
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tax Digest
 |  |  |  |  |  |  |  |  | Net_Income | TaxRate | BasePrvTax |  | Net Income  sample | Tax | Prv | Curr
 | Net Income LESS than 10,000 (1-10,000) |  |  |  |  |  |  |  | 1 | 0.02 | 0
 | Net Income EQUAL to 10,001 and LESS than 20,001 (10,001-20,000) |  |  |  |  |  |  |  | 10001 | 0.025
 | Net Income EQUAL to 20,001 and LESS than 30,001 (20,001-30,000) |  |  |  |  |  |  |  | 20001 | 0.03
 | Net Income EQUAL to 30,001 and LESS than 40,001 (30,001-40,000) |  |  |  |  |  |  |  | 30001 | 0.035
 | Net Income EQUAL to 40,001 and LESS than 999,999,999,999 (40,001 and above) |  |  |  |  |  |  |  | 40001 | 0.0375
 |  |  |  |  |  |  |  |  | 999999999999
Spreadsheet: 71844d1272549485-calculate-addl-hours-on-timesheet-per-day-timesheet_simplified
Sheet: Sheet1

 | Accumulated | 2010-05-03 00:00:00 |  |  | 2010-05-04 00:00:00 |  |  | 2010-05-05 00:00:00 |  |  | 2010-05-06 00:00:00 |  |  | 2010-05-07 00:00:00 |  |  |  | Hours
 | Hours | In | Out | Addt'l Hrs | In | Out | Addt'l Hrs | In | Out | Addt'l Hrs | In | Out | Addt'l Hrs | In | Out | Addt'l Hrs | [NAME] | Remaining
[NAME] | 09:30:00 | 09:00:00 | 18:00:00 | 01:30:00 | 10:00:00 | 21:00:00 | 03:30:00 | 09:00:00 | 17:00:00 | 00:30:00 | 09:00:00 | 19:00:00 | 02:30:00 | 08:00:00 | 17:00:00 | 01:30:00 |  | 09:30:00
[NAME] |  | manual | manual |  | manual | manual | similar to E3 | manual | manual | similar to E3 | manual | manual | similar to E3 | manual | manual | similar to E3 | manual
Format | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | h:[NAME] | number, no dec | h:[NAME]
Spreadsheet: 160733d1339177448-excel-2007-look-up-question-lookup-from-multiple-tabs
Sheet: 217

Attendance Rules: 5 – 5.75   NoCorrective Action 6 – 7.00  No Corrective Action taken; Notice of Attendance Record 7.25 – 7.75   Verbal Warning 8 – 8.75  Written Warning 9 – 9.75  Final Written Warning with 120-day probation Next Point (10) - Review for Termination |  | Occurrence Rules: **Occurrences stay on the record for a rolling one year. **Occurrences stay on until an Approved FMLA letter is issued from UNUM. A doctors excuse does not remove an Occurrence. 8-15 minutes tardy, early departure or shift interruption~.25 16 or more minutes tardy, early departure or shift interruption ~ .50 3 hours or more absent when scheduled to work ~ 1 2 consecutive work days absent (10 hours for part-time)~2 3 or more consecutive days absent (15 hours for part-time)~2.25 Call-off or no-show for scheduled & communicated overtime~1 |  |  |  |  |  |  |  | 0 | n/a
 |  |  |  |  |  |  |  |  |  | 1 | Applied for
 |  |  |  |  |  |  |  |  |  | 0.25 | Approved
 |  |  |  |  |  |  |  |  |  |  | Denied
Tech Name | Kris Mayreis | Total Occurrences
Tech Number | 217 | Corrective Action Step
Date | Occurrence Issued | FMLA   Applied for/ Approved/Denied | Comments
Quit
Spreadsheet: fc221cd6-c311-42f7-b7d1-d8ebcdbf8310
Sheet: Detailed Revenue

The NASDAQ OMX Group, Inc.
Revenue Detail
(in millions)
(unaudited)
 |  |  |  | Three Months Ended
 |  |  |  | September 30, |  | June 30, |  | September 30,
 |  |  |  | 2011 |  | 2011 |  | 2010
MARKET SERVICES
Transaction Services
Cash Equity Trading Revenues:
 | U.S. cash equity trading |  |  | 481 |  | 387 |  | 368
 | Cost of revenues:
 | Transaction rebates |  |  | -327 |  | -258 |  | -248
 | Brokerage, clearance and exchange fees |  |  | -111 |  | -93 |  | -78
 | Total U.S. cash equity cost of revenues |  |  | -438 |  | -351 |  | -326
 | Net U.S. cash equity trading revenues |  |  | 43 |  | 36 |  | 42
European cash equity trading |  |  |  | 24 |  | 23 |  | 21
 | Total net cash equity trading revenues |  |  | 67 |  | 59 |  | 63
Derivative Trading and Clearing Revenues:
 | U.S. derivative trading and clearing |  |  | 121 |  | 115 |  | 93
 | Cost of revenues:
 | Transaction rebates |  |  | -63 |  | -64 |  | -55
 | Brokerage, clearance and exchange fees |  |  | -7 |  | -7 |  | -4
 | Total U.S. derivative trading and clearing cost of revenues |  |  | -70 |  | -71 |  | -59
 | Net U.S. derivative trading and clearing revenues |  |  | 51 |  | 44 |  | 34
 | European derivative trading and clearing |  |  | 33 |  | 31 |  | 26
 | Total net derivative trading and clearing revenues |  |  | 84 |  | 75 |  | 60
 | Access Services Revenues |  |  | 60 |  | 55 |  | 45
 | Total Transaction Services revenues less transaction
 | rebates, brokerage, clearance and exchange fees |  |  | 211 |  | 189 |  | 168
 | Market Data Revenues:
 | Net U.S. tape plans |  |  | 30 |  | 30 |  | 28
 | U.S. market data products |  |  | 33 |  | 32 |  | 32
 | European market data products |  |  | 20 |  | 21 |  | 16
 | Total Market Data revenues |  |  | 83 |  | 83 |  | 76
 | Broker Services Revenues |  |  | 5 |  | 4 |  | 4
 | Other Market Services Revenues |  |  | 1 |  | 1 |  | 1
 | Total Market Services revenues less transaction
 | rebates, brokerage, clearance and exchange fees |  |  | 300 |  | 277 |  | 249
ISSUER SERVICES
Global Listing Services Revenues:
U.S. Operations: | Annual renewal |  |  | 30 |  | 29 |  | 29
 | Listing of additional shares |  |  | 10 |  | 10 |  | 10
 | Initial listing |  |  | 4 |  | 4 |  | 4
 | Total U.S. listing services |  |  | 44 |  | 43 |  | 43
 | European listing services |  |  | 13 |  | 14 |  | 12
 | Corporate Solutions |  |  | 22 |  | 23 |  | 18
 | Total Global Listing Services revenues |  |  | 79 |  | 80 |  | 73
 | Global Index Group Revenues |  |  | 13 |  | 13 |  | 12
 | Total Issuer Services revenues |  |  | 92 |  | 93 |  | 85
MARKET TECHNOLOGY
 | License, support and facility management |  |  | 28 |  | 30 |  | 27
 | Delivery project |  |  | 6 |  | 6 |  | 4
 | Change request, advisory and broker surveillance |  |  | 12 |  | 10 |  | 7
 | Total Market Technology revenues |  |  | 46 |  | 46 |  | 38
Total revenues less transaction rebates, brokerage,
clearance and exchange fees |  |  |  | 438 |  | 416 |  | 372
Spreadsheet: 876977d1723678192-countifs-adding-values-from-another-cell-help-test-file
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  | 52 |  |  |  |  |  | 125
 |  |  |  |  |  |  |  |  |  | 41 |  |  |  |  |  | 1412
 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  | 3218
 |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  | -1520
 | DAYS | UNITS | FRONT | BACK | TREND |  |  |  |  | 24 |  |  |  |  |  | -582
 | 1-15 |  |  |  |  |  |  |  |  | 91 |  |  |  |  |  | 782
 | 16-30 |  |  |  |  |  |  |  |  | 65 |  |  |  |  |  | 481
 | 31-45 |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  | 57
 | 46-60 |  |  |  |  |  |  |  |  | 102 |  |  |  |  |  | 0
 | 60-75 |  |  |  |  |  |  |  |  | 17 |  |  |  |  |  | -82
 | 76-90 |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  | 1297
 | 90+ |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  | 41
 | TOTAL: |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  | 0
Spreadsheet: 781278d1653129365-obtain-the-numbers-of-a-list-depending-the-name-distribui-o-de-pe-as
Sheet: MAFALDA

 |  |  | MAFALDA
 |  |  | Nª PEÇA | DESCRIÇÃO | VALOR
Spreadsheet: 677238d1589257658-multiple-lists-to-look-into-excel-help-
Sheet: Sheet1

Text | Required Answers |  | IT Services | Building Work | Legal Work | Business Work | Service Work
Service Improvement | Service Work |  | National Oracle Solution | Architecture | Legal | Organisational Culture | Service Improvement
Organisational Culture | Business Work |  | Computers | [NAME] | Lawyers | Workforce reviews | National Patient Flow
Workforce reviews | Business Work |  |  | Building Improvements |  | Response based practice | Planning & Funding
National Patient Flow | Service Work |  |  |  |  | Staff Recognition
Response based practice | Business Work |  |  |  |  | Credentialling
Staff Recognition | Business Work
Credentialling | Business Work
Architecture | Building Work
Planning & Funding | Service Work
[NAME] | Building Work
Building Improvements | Building Work
Legal | Legal Work
National Oracle Solution | IT Services
Lawyers | Legal Work
Computers | IT Services
Spreadsheet: 703800d1605181557-eliminating-empty-cells-over-multiple-columns-eliminate-blank-cells-multiple-columns
Sheet: Sheet1

 |  |  |  |  |  |  |  | List of children in all classes
 | Pet Tag | Pet |  | Class 1 | Class 2 | Class 3 |  | [NAME] | [NAME] | [NAME] | [NAME]
 | a | cats |  | [NAME] | [NAME]
 | b | dogs |  | [NAME] |  | [NAME]
 | c | rabbit |  | [NAME] | [NAME] | [NAME]
 | d | [NAME] |  |  | [NAME] | [NAME]
 | e | horse |  | [NAME] | [NAME]
 | f | donkey |  |  | [NAME] | [NAME]
 | g | piglet |  |  |  | [NAME]
 | h | monkey |  | [NAME]
 | i | calf |  | [NAME]
 | J | Hen |  |  | [NAME] | [NAME]
 | K | Chicken |  |  |  | [NAME]
 | l | Spider |  |  | [NAME] | [NAME]
Spreadsheet: 106675d1303901887-urgent-name-match-issue-for-wrk-anyone-help-sample
Sheet: Sheet1

Last Name | First Name | Last Name 2 | First Name 2 | Last Name Match T/F | First Name Match T/F
Smith | [NAME] | Smith | [NAME] | 1 | 1
Jacobs | [NAME] | Jacobs | [NAME] | 1 | 1
Black | [NAME] | [NAME] | White | 0 | 0
Blue | Betty | [NAME] | [NAME] | 0 | 0
Green | [NAME] | Sinatra | [NAME] | 0 | 0
 |  | Betty | Blue | 0 | 0
Spreadsheet: 27401d1220586147-search-function-search-words-function
Sheet: Sheet1

cats | 4
dogs | 6 |  |  |  | dogs | 6
mice | 44
birds | 45
big dogs | 64 |  |  |  | big dog | 64
snoop dog | 56 |  |  |  | snoop dog | 56
dog gy dog | 454 |  |  |  | dog gy dog | 454
red dog | 245 |  |  |  | red dog | 345
big mice | 6456
big bird | 65465
nice cats | 767
Spreadsheet: 0ddfd6b9-79ae-44a8-a3ae-d64a338bdac6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | FORM A-S
INTERNATIONAL CIVIL AVIATION ORGANIZATION
AIR TRANSPORT REPORTING FORM
TRAFFIC - COMMERCIAL AIR CARRIERS
Contact person: |  |  | State:
Organization:
Tel:
Fax:
E-mail: |  |  | Year:
 |  |  | TOTAL ALL SERVICES
 |  |  | (passenger, mail and freight |  |  |  |  | ALL-FREIGHT SERVICES ONLY
 |  |  | including all-freight) |  |  |  |  | (included in columns c and d data)
ICAO | Description | Unit |  | Classified by flight stage |  |  |  | Classified by flight stage
code |  |  | International |  | Domestic |  | International |  | Domestic
 | a | b | c |  | d |  | e |  | f
 | SCHEDULED REVENUE FLIGHTS
1010 | 1.   Aircraft kilometres | 000
1020 | 2.   Aircraft departures | number
1030 | 3.   Aircraft hours | number
1040 | 4.   Passengers carried | number
1050 | 5.   Freight tonnes carried | number
1060 | 6.   Passenger-kilometres performed | 000
1070 | 7.   Seat-kilometres available | 000
1080 | 8.   Passenger load factor | %
1091 | 9.   [NAME] performed                                       .     a)  passenger (incl. baggage) | 000
1092 | b)  freight (incl. express) | 000
1093 | c)  mail | 000
1094 | d) total (9a to 9c) | 000
1100 | 10.  [NAME] available | 000
1110 | 11.  Weight load factor | %
2010 | NON-SCHEDULED REVENUE FLIGHTS                12.   Aircraft kilometres | 000
2020 | 13.   Aircraft departures | number
2030 | 14.   Aircraft hours | number
2040 | 15.   Passengers carried | number
2050 | 16.   Freight tonnes carried | number
2060 | 17.   Passenger-kilometres performed | 000
2070 | 18.   Seat-kilometres available | 000
2091 | 19.   [NAME] performed                                       .     a)  passenger (incl. baggage) | 000
2092 | b)  freight (incl. express) | 000
2093 | c)  mail | 000
2094 | d)  total (19a + 19c) | 000
2100 | 20.   [NAME] available | 000
3020 | AIR TAXI REVENUE FLIGHTS                                      21.   Aircraft departures | number
3030 | 22.   Aircraft hours | number
2330 | NON REVENUE FLIGHTS 23.   Aircraft hours | number
Remarks (including a description of any unavoidable deviation (s) from reporting instructions):
Spreadsheet: 0cb38c3a-3333-4247-a70f-b3b797b2496e
Sheet: Sheet1

AFLAC INC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
8-K
10/29/2013
CURRENT REPORT
Georgia |  | 001-07434 |  | 58-1167100
(State or other jurisdiction |  | (Commission |  | (IRS Employer
of incorporation) |  | File Number) |  | Identification No.)
1932 Wynnton Road, Columbus, Georgia |  |  |  | 31999
(Address of principal executive offices) |  |  |  | (Zip Code)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 82658d1282685149-count-values-with-multiple-criteria-formula-help
Sheet: Sheet1

0 | - | 2 | x |  |  |  |  |  |  | 31 | 56
2 | - | 0 | 3 | 59 |  |  |  |  |  | x
2 | - | 0 | 34 | 43 |  |  |  |  |  | x
1 | - | 1 | 15 |  |  |  |  |  |  | 67
2 | - | 1 | 32 | 52 |  |  |  |  |  | 15
5 | - | 1 | 5 | 43 | 53 | 72 | 75 |  |  | 44
1 | - | 1 | 10 |  |  |  |  |  |  | 77
Spreadsheet: 750850d1633693048-filter-dynamic-array-to-keep-rows-which-include-conditional-minimum-values-filter-dynamic-aray-to-keep-rows-which-include-conditional-minimum-values
Sheet: Sheet1

Table to be filtered |  |  |  |  | Filtered table
Column A | Column B | Column C | Column D |  | Column A | Column B | Column C | Column D
2018-11-14 00:00:00 | A | B | C |  | 2018-11-14 00:00:00 | A | B | C
2018-11-15 00:00:00 | A | B | C |  | 2018-11-16 00:00:00 | D | E | F
2018-11-16 00:00:00 | D | E | F |  | 2018-11-20 00:00:00 | G | H | I
2018-11-17 00:00:00 | D | E | F
2018-11-20 00:00:00 | G | H | I
Array version of table to be filtered |  |  |  |  | Array version of filtered table
Spreadsheet: 758163d1638714666-get-data-from-one-table-to-another-with-any-method-match-index-task-6-aligw
Sheet: Hárok1

Get the data from blue table to the red table by using any method.
 |  | Category |  |  |  |  |  |  |  |  |  | Category
 |  | HDD | SPD | FFI | ADW | HDW | LAD | TWC |  |  |  | TWC | LAD | HDW | ADW | FFI | SPD | HDD
Brand | [NAME] |  |  | 2005 |  |  |  |  |  | Brand | [NAME]
 | Bref | 730 |  |  |  |  | 4575 |  |  |  | Silan
 | [NAME] | 3772 |  |  |  |  | 3867 | 3121 |  |  | Pur
 | Clin |  |  |  |  |  |  | 2269 |  |  | Bref
 | Coccolino |  |  | 678 |  |  |  |  |  |  | [NAME]
 | Domestos | 25 |  |  |  |  | 8416 |  |  |  | Clin
 | Finish |  |  |  | 7647
 | Jar |  |  |  | 5922 | 2903
 | Lenor |  |  | 7636
 | Pur |  |  |  |  | 8913
 | Silan |  |  | 5531
 | TS |  |  |  |  | 2502 | 7343
 | Dylon |  |  |  |  |  | 18217
 | [NAME] |  |  |  |  |  |  | 1230
Spreadsheet: 725393d1616665820-excel-newbie-countifs-dont-count-and-always-shows-0-instead-help
Sheet: Sheet1

No. | Branch Name | Phone Number | Call Status
1 | A | 123456789 | unanswered
2 | A |  | answered
3 | A |  | answered
4 | A |  | complain
5 | A |  | didn't make through
6 | B |  | didn't make through
7 | B |  | answered
8 | B | 466281909 | answered
9 | B |  | unanswered
10 | B |  | complain
11 | B |  | answered
12 | C | 238999479 | complain
13 | C |  | didn't make through
14 | D | 488239424 | didn't make through
15 | D |  | answered
Spreadsheet: 845476d1696973503-if-values-between-x-and-y-date-each-year-output-yes-between-dates-bvj-
Sheet: Sheet1

Date |  | Expected | So Far |  | [NAME]'s
2000-02-16 00:00:00 |  | Nope
2000-12-09 00:00:00 |  | Yes
2001-03-16 00:00:00 |  | Yes
2001-05-31 00:00:00 |  | Nope
2001-10-03 00:00:00 |  | Yes
2002-02-14 00:00:00 |  | Yes
2002-04-27 00:00:00 |  | Nope
2002-06-21 00:00:00 |  | Nope
2002-07-08 00:00:00 |  | Nope
2002-08-05 00:00:00 |  | Nope
2002-08-11 00:00:00 |  | Nope
2002-10-05 00:00:00 |  | Yes
2002-10-16 00:00:00 |  | Yes
2003-08-27 00:00:00 |  | Nope
2003-11-02 00:00:00 |  | Yes
2004-01-28 00:00:00 |  | Yes
2004-02-09 00:00:00 |  | Yes
2004-03-02 00:00:00 |  | Yes
2004-03-07 00:00:00 |  | Yes
2004-06-24 00:00:00 |  | Nope
2004-10-06 00:00:00 |  | Yes
2005-06-15 00:00:00 |  | Nope
2005-07-22 00:00:00 |  | Nope
2006-01-26 00:00:00 |  | Yes
2006-03-02 00:00:00 |  | Yes
2006-05-05 00:00:00 |  | Nope
2006-07-02 00:00:00 |  | Nope
2006-12-31 00:00:00 |  | Yes
2007-05-17 00:00:00 |  | Nope
2007-06-12 00:00:00 |  | Nope
2007-07-30 00:00:00 |  | Nope
2008-05-07 00:00:00 |  | Nope
2008-11-30 00:00:00 |  | Yes
2008-12-26 00:00:00 |  | Yes
2009-03-18 00:00:00 |  | Yes
2009-03-29 00:00:00 |  | Yes
2009-07-14 00:00:00 |  | Nope
2009-07-28 00:00:00 |  | Nope
2009-11-22 00:00:00 |  | Yes
2009-12-13 00:00:00 |  | Yes
2010-06-08 00:00:00 |  | Nope
2010-10-10 00:00:00 |  | Nope
2010-11-26 00:00:00 |  | Nope
2011-06-29 00:00:00 |  | Nope
2011-08-12 00:00:00 |  | Nope
2011-10-23 00:00:00 |  | Yes
2011-11-20 00:00:00 |  | Yes
2011-12-26 00:00:00 |  | Yes
2012-03-10 00:00:00 |  | Yes
2012-07-11 00:00:00 |  | Nope
2012-07-27 00:00:00 |  | Nope
2012-12-26 00:00:00 |  | Yes
2013-01-11 00:00:00 |  | Yes
2013-07-29 00:00:00 |  | Nope
2013-08-10 00:00:00 |  | Nope
2014-03-08 00:00:00 |  | Yes
2014-12-26 00:00:00 |  | Yes
2015-03-29 00:00:00 |  | Yes
2015-07-03 00:00:00 |  | Nope
2015-08-17 00:00:00 |  | Nope
2015-09-27 00:00:00 |  | Yes
2015-10-09 00:00:00 |  | Yes
2015-11-08 00:00:00 |  | Yes
2015-11-17 00:00:00 |  | Yes
2016-02-22 00:00:00 |  | Yes
2016-06-06 00:00:00 |  | Nope
2016-08-30 00:00:00 |  | Nope
2016-11-16 00:00:00 |  | Yes
2016-11-20 00:00:00 |  | Yes
2017-02-02 00:00:00 |  | Yes
2017-04-12 00:00:00 |  | Yes
2017-07-14 00:00:00 |  | Nope
2017-08-05 00:00:00 |  | Nope
2017-08-22 00:00:00 |  | Nope
2017-10-12 00:00:00 |  | Yes
2017-10-17 00:00:00 |  | Yes
2017-12-15 00:00:00 |  | Yes
2018-01-06 00:00:00 |  | Yes
2018-01-24 00:00:00 |  | Yes
2018-06-09 00:00:00 |  | Nope
2018-06-09 00:00:00 |  | Nope
2018-07-31 00:00:00 |  | Nope
2018-11-19 00:00:00 |  | Yes
2019-03-27 00:00:00 |  | Yes
2019-05-20 00:00:00 |  | Nope
2019-11-11 00:00:00 |  | Yes
2020-01-02 00:00:00 |  | Yes
2020-02-03 00:00:00 |  | Yes
2020-07-23 00:00:00 |  | Nope
2020-11-21 00:00:00 |  | Yes
2020-12-12 00:00:00 |  | Yes
2021-01-19 00:00:00 |  | Yes
2021-05-30 00:00:00 |  | Nope
2021-09-19 00:00:00 |  | Yes
2022-02-24 00:00:00 |  | Yes
2022-07-29 00:00:00 |  | Nope
2022-12-22 00:00:00 |  | Yes
2023-02-01 00:00:00 |  | Yes
2023-06-15 00:00:00 |  | Nope
Spreadsheet: 152124d1335269463-count-c6-n6-minusing-if-a-ws-or-hs-are-in-those-cells-register-test-1
Sheet: 3

WEEK COMMENCING |  |  | 2012-04-16 00:00:00
Name | REFERENCE | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURDAY |  | FRIDAY |  | SATURDAY | SUNDAY | TOTAL SESSION      2 sessions for each half day max 14 but total days will be a max of 7 | TOTAL DAY  max of 7 (goes up in whole numbers) if attend 1/2 day, this is counted as 1, if attends both AM and PM this is counted as 1
 |  | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 |  | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 2 | 1
 |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 8 | 4
 |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 8 | 4
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 4 | 2
 |  | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 6 | 3
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 8 | 4
 |  | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 6 | 3
 |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 8 | 4
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 10 | 5
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Total Sessions |  | 4 | 4 | 6 | 6 | 8 | 8 | 7 | 7 | 7 | 7 | 0 | 0 | 64 | 32
Number of Sessions |  | 4 | 4 | 6 | 6 | 8 | 8 | 7 | 7 | 7 | 7 | 0 | 0 | 64
Number of HS Sessions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Number of WS  Sessions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Sessions |  | 4 | 4 | 6 | 6 | 8 | 8 | 7 | 7 | 7 | 7 | 0 | 0 | 64 | 0
KEY:
0 | DOES NOT ATTEND SERVICE
1 | DOES ATTEND SERVICE
HS | Home Support - IS SUPPORTED AT HOME BY STAFF FROM DAY SERVICE
WS | [NAME], Supported by Staff out in the community,  NO support given at home or in DTS