tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0ef3f7da-c281-4c73-b166-f11345d4708f
Sheet: Sheet1

Table with row headings in column A and column headings in rows 4 to 8. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
[NAME] for 2010 by Size of Family and Number of Related Children Under 18 Years
 |  |  |  |  | Related children under 18 years
Size of family unit | Weighted |  |  |  |  |  |  |  |  | Eight
 | average | None | One | Two | Three | Four | Five | Six | Seven | or more
 | thresholds
One person (unrelated individual)....... | 11139
Under 65 years.............................. | 11344 | 11344
65 years and over........................... | 10458 | 10458
Two people...................................... | 14218
Householder under 65 years........... | 14676 | 14602 | 15030
Householder 65 years and over........ | 13194 | 13180 | 14973
Three people.................................... | 17374 | 17057 | 17552 | 17568
Four people..................................... | 22314 | 22491 | 22859 | 22113 | 22190
Five people...................................... | 26439 | 27123 | 27518 | 26675 | 26023 | 25625
Six people........................................ | 29897 | 31197 | 31320 | 30675 | 30056 | 29137 | 28591
Seven people................................... | 34009 | 35896 | 36120 | 35347 | 34809 | 33805 | 32635 | 31351
Eight people.................................... | 37934 | 40146 | 40501 | 39772 | 39133 | 38227 | 37076 | 35879 | 35575
Nine people or more.......................... | 45220 | 48293 | 48527 | 47882 | 47340 | 46451 | 45227 | 44120 | 43845 | 42156
Source:  U.S. Census Bureau.
Spreadsheet: phillip_m_love__30695__July_Sithe_PriceBasisIndex_revised
Sheet: Price

855437
 |  |  |  |  |  |  |  |  | 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 | NX1 | 01-JUL-2000 | 559484 | 0 | 1 | 4.369000000000001 | 1e-07 | 0 | 2444385.5401
NG-PRICE | NK8605.1 | F | NX1 | 01-JUL-2000 | -310000 | 0 | 1 | 4.369000000000001 | 4.27 | 0 | -30690
NG-PRICE | NK9373.1 | F | NX1 | 01-JUL-2000 | -155000 | 0 | 1 | 4.369000000000001 | 3.99 | 0 | -58745
NG-PRICE | NL9651.2 | F | NX1 | 01-JUL-2000 | -500000 | 0 | 1 | 4.369000000000001 | 4.165 | 0 | -102000
NG-PRICE | NL9651.3 | F | NX1 | 01-JUL-2000 | -500000 | 0 | 1 | 4.369000000000001 | 4.1725 | 0 | -98250
NG-PRICE | [NAME] | F | NX1 | 01-JUL-2000 | 155000 | 0 | 1 | 4.369000000000001 | 4.175 | 0 | 30070
FT-CENTRAL | NN0237.1 | F | NX1 | 01-JUL-2000 | 155000 | 0 | 1 | 4.369000000000001 | 4.325 | 0 | 6820
NG-PRICE | [NAME] | F | NX1 | 01-JUL-2000 | 155000 | 0 | 1 | 4.369000000000001 | 4.49 | 0 | -18755
NG-PRICE | NN8688.1 | F | NX1 | 01-JUL-2000 | 155000 | 0 | 1 | 4.369000000000001 | 4.165 | 0 | 31620
INTRA-CNT-TRANS | NO2915.1 | F | NX1 | 01-JUL-2000 | 100000 | 0 | 1 | 4.369000000000001 | 4.4675 | 0 | -9850
NG-PRICE | NO5709.1 | F | NX1 | 01-JUL-2000 | 155000 | 0 | 1 | 4.369000000000001 | 4.64 | 0 | -42005
INTRA-CENTRAL | NP9810.1 | F | ANNUITY | 01-JUL-2000 | 0 | 0 | 1 | 4.369000000000001 | 0 | 127500 | 0
FT-CENTRAL | NQ0697.2 | P | NX1 | 01-JUL-2000 | 20871 | 0 | 1 | 4.369000000000001 | 1e-07 | 0 | 91185.39689999999
FT-CENTRAL | NQ0697.4 | P | NX1 | 01-JUL-2000 | -20871 | 0 | 1 | 4.369000000000001 | 1e-07 | 0 | -91185.39689999999
GREATLAKENEP | NQ0697.5 | F | ANNUITY | 01-JUL-2000 | 0 | 0 | 1 | 4.369000000000001 | 0 | -626.13 | 0
FT-CENTRAL | NU0175.1 | P | NX1 | 01-JUL-2000 | -185285 | 0 | 1 | 4.369000000000001 | 1e-07 | 0 | -809510.1465
Spreadsheet: 2a716750-bbbd-49c7-9bd6-6dbf9becf6b8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Law, Public Safety, Corrections and Security: Law Enforcement Services
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Law Enforcement Services Pathway of the Law, Public Safety, Corrections and Security [NAME]) can serve as a guide, along with other career planning
materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan
of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for                       Law Enforcement Services Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Animal Control Officer ►Bailiff ►Bomb Technician ►Criminal Investigator and Special                .   Agent ►Evidence Technician ►Federal Marshall ►Game Enforcement Officer ►Gaming Investigator ►Highway Patrol Officer ►Immigration and Customs                       .    Inspector ►[NAME] ►Police and Patrol Officer ►Police Detective and Criminal                    .    Investigator ►Police, Fire and Ambulance                      .   Dispatcher ►Private Detective and Investigator ►Sheriff and Deputy Sheriff ►Training Officer ►Transit and Railroad Police ►Unemployment Fraud Investigator
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 845156d1696679280-if-then-statement-breaks-when-i-delete-rows-forum
Sheet: Sheet2

Monday | 8
Monday | 0
Tuesday | 8
Tuesday | 0
Wednesday | 8
Wednesday | 2
Total Hrs
Days O/T |  | equal or greater than 9.5 hours
Days O/T |  | equal or greater than 10.2 hours
Spreadsheet: 197372d1354310742-if-a-cell-equals-x-then-format-that-many-cells-for-input-bracket-help
Sheet: Elite 8

 | Total Points
SOUTH | PPG this RD
WEST
EAST
MIDWEST
Spreadsheet: 107014d1304164916-how-to-find-top-25-values-from-more-than-1000-rows-with-their-corresponding-names-excel-test-top-5-dave
Sheet: Sheet2

Rank | Name
1 | a | 983 |  | Foxtrot | #N/A
2 | d |  |  | Alpha
3 | f |  |  | Bravo
4 | g |  |  | Delta
5 | h |  |  | Delta
6 | j |  |  | Echo
7 | k |  |  | Sierra
8 | u |  |  | India
9 | y |  |  | Romeo
4 | r |  |  | Tango
5 | w |  |  | [NAME]
65 | f |  |  | Kilo
68 | t |  |  | [NAME]
983 | b |  |  | [NAME]
45 | a |  |  | [NAME]
Spreadsheet: 836458d1689364027-conditional-formatting-excel-forum-question
Sheet: Sheet1

 |  | Baskeball Court 1 |  | Basketball Court 2 |  | VB Court 1 | VB Court 2
 | Monday | Half A | Half B | Half A | Half B
 | 08:00:00
 | 08:30:00
 | 09:00:00
 | 09:30:00
 | 10:00:00
 | 10:30:00
 | 11:00:00
 | 11:30:00
 | 12:00:00
 | 12:30:00
 | 13:00:00
 | 13:30:00
 | 14:00:00
 | 14:30:00
 | 15:00:00
 | 15:30:00
 | 16:00:00
 | 16:30:00
 | 17:00:00
 | 17:30:00
 | 18:00:00
 | 18:30:00
 | 19:00:00
 | 19:30:00
 | 20:00:00
 | 20:30:00
 | 21:00:00
 | 21:30:00
 | 22:00:00
 | 22:30:00
 | 23:00:00
 | 23:30:00
Spreadsheet: 224668d1364689157-risk-matrix-conditional-formatting-rr-example
Sheet: Sheet1

 | Likelihood | Consequence | Risk Rating |  | Likelihood | Consequence | Risk Rating |  |  | Likelihood | Consequence
 | Almost Certain | Insignificant | High |  | Almost Certain | Major |  |  |  | Almost Certain | Insignificant
 | Almost Certain | Minor | High |  | Likely | Moderate |  |  |  | Likely | Minor
 | Almost Certain | Moderate | Extreme |  |  |  |  |  |  | Possible | Moderate
 | Almost Certain | Major | Extreme |  |  |  |  |  |  | Unlikely | Major
 | Almost Certain | Catastrophic | Extreme |  |  |  |  |  |  | Rare | Catastrophic
 | Likely | Insignificant | Medium
 | Likely | Minor | High
 | Likely | Moderate | High
 | Likely | Major | Extreme
 | Likely | Catastrophic | Extreme
 | Possible | Insignificant | Low
 | Possible | Minor | Medium
 | Possible | Moderate | High
 | Possible | Major | High
 | Possible | Catastrophic | Extreme
 | Unlikely | Insignificant | Low
 | Unlikely | Minor | Low
 | Unlikely | Moderate | Medium
 | Unlikely | Major | High
 | Unlikely | Catastrophic | Extreme
 | Rare | Insignificant | Low
 | Rare | Minor | Low
 | Rare | Moderate | Medium
 | Rare | Major | High
 | Rare | Catastrophic | High
Spreadsheet: 69919d1270583502-conditional-formatting-book1
Sheet: Sheet1

aaa | 1
aaa | 2
aaa | 3
aaa | 4
bbb | 1
bbb | 2
bbb | 3
bbb | 4
bbb | 5
bbb | 6
bbb | 7
bbb | 8
[NAME] | 1
[NAME] | 2
[NAME] | 3
[NAME] | 4
ddd
eee
eee
eee
[NAME]
Spreadsheet: 4a28c203-125c-426c-9fa0-25be3eee871a
Sheet: Sheet1

Original to Teacher Making Request | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | WOONSOCKET PUBLIC SCHOOLS | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Form Date:  7/14/00
Copy to Principal |  |  |  | 108 High Street
Copy to Superintendent |  |  |  | Woonsocket, Rhode Island  02895
 |  |  |  | FIELD TRIP REQUEST FORM
Field Trip Destination: |  |  |  |  |  |  |  | Date of Request:
Grade / Organization Requesting Field Trip: |  |  |  |  |  |  |  | Teacher Responsible:
School:
 |  | If applicable, on the line above, list the name and telephone number of the travel  agent arranging this trip
In the event a field trip participant must be contacted at the scheduled destination, please provide a contact name and telephone number on the line above
Departure Date: |  |  |  | Time of Departure: |  |  |  | Number of Students Expected to Attend:
Return Date: |  |  |  | Return Time: |  |  |  | Transportation Mode:
Total # Days of the Field Trip: |  |  |  | Total # Days Away From the Building: |  |  |  | Transportation Vendor:
Total # Chaperones: |  |  |  | Total # Substitutes: |  |  |  | Transportation Cost:
List All Teachers Chaperoning this Trip: |  |  |  |  |  |  |  | Admission Costs:
 |  |  |  |  |  |  |  | Miscellaneous Costs:
 |  |  |  |  |  |  |  | Total Cost of Field Trip: | 0
 |  |  |  |  |  |  |  | Total Cost Per Student: | 0
Indicate all sources of funding that apply:
Educational Justification for the Field Trip:
 |  |  |  |  |  |  |  | Attach itinerary / other information if necessary
Overnight trips must be submitted to the Superintendent at least one week prior to a regularly scheduled School Committee meeting.  The supervising teacher
whose name appears on this form shall be responsible for making all arrangements for the trip (including but not limited to:  obtaining all necessary permission
slips, pre-paying if necessary all admissions, permits, fees, transportation, etc.).
School nurse-teachers are not allowed to supply medications for field trips.  (See Field Trip Medical Form).
List all students who have written permission to self-carry and self-administer medication on your field trip:
[NAME]: |  |  |  |  |  | Building Principal’s Recommendation:
 |  | Date: |  |  |  |  |  | Date:
Comments: |  |  |  |  |  | Comments:
(Supervisor’s Signature) |  |  |  |  |  | (Principal’s Signature)
 |  | Date:
 |  |  |  |  |  | (Administrator’s Signature)
 |  |  |  |  |  | Comments:
Scheduled for School Committee Meeting of:
Spreadsheet: 101752d1299797322-count-number-of-patients-present-during-an-hour-episode-recovery-room-project
Sheet: Sheet1

Recovery Room Time |  |  |  |  |  | Time
 |  |  |  |  |  | Range
Patient | Start Time | End Time |  |  |  | 08:00:00 | 08:59:00
1 | 08:00:00 | 09:15:00 |  |  |  | 09:00:00 | 09:59:00
2 | 09:00:00 | 09:30:00 |  |  |  | 10:00:00 | 10:59:00
3 | 09:15:00 | 10:15:00 |  |  |  | 11:00:00 | 11:59:00
4 | 08:15:00 | 09:30:00 |  |  |  | 12:00:00 | 12:59:00
5 | 12:00:00 | 13:50:00 |  |  |  | 13:00:00 | 13:59:00
6 | 13:00:00 | 13:15:00 |  |  |  | 14:00:00 | 14:59:00
7 | 14:00:00 | 15:15:00 |  |  |  | 15:00:00 | 15:59:00
Spreadsheet: 160344d1339060387-if-cell-value-is-not-null-then-paste-the-table-row-in-another-sheet-last-empty-row-new-microsoft-office-excel-worksheet-3-
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2 |  |  |  |  | Table 3
07:00:00 | 07:05:00 |  | + | 00:05:43.200000 | 07:00:00 | 07:05:00 |  | + | 00:05:43.200000
07:30:00 | 07:31:00 |  | + | 00:01:43.200000 | 07:30:00 | 07:31:00 |  | + | 00:01:43.200000
08:00:00 | 08:00:00 |  | + |  | 08:00:00 | 08:04:00 |  | + | 00:04:00
09:30:00 | 09:30:00 |  | + |  | 08:30:00 | 08:30:00 |  | +
10:00:00 | 10:00:00 |  | + |  | 09:00:00 | 09:01:00 |  | + | 00:01:00
10:30:00 | 10:30:00 |  | + |  | 09:30:00 | 09:32:00 |  | + | 00:02:00
11:00:00 | 11:10:00 |  | + | 00:10:43.200000 | 10:00:00 | 10:05:00 |  | + | 00:05:43.200000
11:30:00 | 11:30:00 |  | + |  | 10:30:00 | 10:45:00 |  | + | 00:15:00
12:00:00 | 12:00:00 |  | + |  | 11:00:00 | 11:06:00 |  | + | 00:06:00
12:30:00 | 12:30:00 |  | + |  | 11:30:00 | 11:30:00 |  | +
Spreadsheet: 35069d1232573369-table-searching-problems-book1a
Sheet: Sheet1

 |  | 2 | 4 | 6 | 8 | widths
Lined | 0-125 | 25.25 | 39.38 | 52.61 | 75.81 |  |  |  | Lined
 | 126-200 | 29.03 | 45.26 | 65.21 | 87.15
 | 201-400 | 33.02 | 60.64 | 76.49 | 98.91 |  |  |  | 4 | w
 | drop
 |  |  |  |  |  |  |  |  | 175 | drop
Interlined |  | 2 | 4 | 6 | 8 | width
 | 0-125 | 30.29 | 47.25 | 63.11 | 90.98
 | 126-200 | 34.86 | 54.29 | 78.23 | 104.58
 | 201-400 | 39.64 | 72.77 | 91.77 | 118.7
 | drop
Spreadsheet: 887489d1737720076-add-one-to-existing-record-in-list-various-prefixes-test7
Sheet: Sheet1

Blank |  |  |  | Example
Ref | Short |  |  | Ref | Short
 | CT |  |  | CT-00001 | CT
 | FS |  |  | FS-00001 | FS
 | QT |  |  | QT-00001 | QT
 | HP |  |  | HP-00001 | HP
 | TPC |  |  | TPC-00001 | TPC
 | TP |  |  | TP-00001 | TP
 | FS |  |  | FS-00002 | FS
 | HP |  |  | HP-00002 | HP
 | TP |  |  | [NAME] | TP
 | TP |  |  | TP-00003 | TP
Spreadsheet: 128374d1320933701-display-totals-figuresreq
Sheet: Figures

 | 103 | 105 | 109 | 110 | 118 | 120 | 123 | 124 | 125 | 126 | 127 | 130 | 144 | 170 | 200 | 201 | 208 | 209 | 210 | 211 | 218 | 220 | 230 | 805 | 998
Answering Machine Auto
Bankrupt
Busy
Busy Auto
Call Back
Credit Card Lead
Decision Maker Unavailable
Declined Sale
Disconnected Number
Disconnected Number Auto
DO NOT CALL
Doesnt Meet Criteria
Hung Up
In An IVA
[NAME]
[NAME] Called
Lead To Be Called
NEO
No Answer
No Answer AutoDial
No Pitch No Price
Not Interested
Not Struggling with Debt
ODS Call Back
ODS Lead
PPI Lead
TPS DNC
Wrong Number
(blank)
Spreadsheet: 6ccda76c-fe42-41d6-bc86-e95b79061628
Sheet: Budget Summaries 4

Construction, Debt Payment & Trust Funds - Budgeted Revenues
 |  |  | Capital | Special
Description | Bond | Non-Voter | Projects | Building & | Trust/ | Foundation/ | Net
 | Redemption | Approved Debt | Building | Technology | Agency | Component | Total
 | Fund | Fund | Fund | Fund | Funds | Units | (OTHER FUNDS)
Beginning Fund Balance
Revenue:
Local Sources
County/Intermediate Sources
State Sources
Federal Sources
Total Revenue
Transfers In/Out
Revenue from Other Sources
Allocation From General Fund
Total Net Revenue
Estimated Funded Pupil Count
Budgeted Net Revenue Per Funded Pupil
Spreadsheet: 678488d1589911664-trying-to-make-a-value-change-according-to-the-date-route-card-calculator-mk2
Sheet: Paces & GMA

 | Paces Per 100m | GMA
 | 76 | 1.5
 | Date | Annual Change
 |  | 2.5
 | Upcoming GMA
 | Year | Annual Change (Ꝋ)
 | 2019 | 4
 | 2020
 | 2021
 | 2022
 | 2023
 | 2024
 | 2025
 | 2026
 | 2027
 | 2028
 | 2029
 | 2030
Spreadsheet: 174612d1345125145-simple-automatic-sorting-numbers-from-low-to-high-workbook55
Sheet: Sheet1

3 | SORT
8
9
10
11
18
19
22
23
25
26
30
34
36
40
45
46
48
49
53
54
56
59
62
63
65
68
69
70
72
73
76
77
79
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
Spreadsheet: sally_beck__33995__Log as of 4_20_01
Sheet: Sum APril 4 to April 10

 | Week summary (April 4 to April 10)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed | 1
2 | IT Hardware problems |  |  | Officialized on time but needed recalc | 2
3 | IT Software Problems |  |  | Book not officialized
4 | Miscellaneous |  |  | No process in place | 1
5 | Uncontrollable | 0 |  | Other
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs | 1
 |  |  |  | Slow feeds
 |  |  |  | Feed problem | 1
 |  |  |  | Books shown as officialized, but not RiskTrac
 |  |  |  | Application down alternate system used
 |  |  |  | Other | 5
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 763127d1642003511-create-a-function-that-displays-pricing-based-on-age-in-range-life-insurance-example
Sheet: Sheet1

Age |  | Rate per $100
0-35 | 0 | 0.292
35-39 | 35 | 0.768
40-44 | 40 | 0.918 |  |  | Monthly Earnings | Age
45-49 | 45 | 1.075 |  |  | 4000 | 60
50-54 | 50 | 1.257
55-59 | 55 | 1.492 |  |  | Estimated Monthly Payroll Deduction
60-64 | 60 | 1.61
65-69 | 65 | 1.472
70-100 | 70 | 1.472
Spreadsheet: 266447d1379616169-conditional-formating-and-formula-help-sample
Sheet: Stat

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cabs
Cabs | Airline | Flight # | ETA | Tail/Reg | Call IN |  | Shuttle |  |  |  |  |  |  |  | Airline | FLT # | REG # | ETA | # of Cabs
 |  |  |  |  |  |  |  |  | ETA |  |  | Call IN
 |  |  |  |  |  |  |  |  | 04:00-04:59 |  |  | 04:00-04:59
 |  |  |  |  |  |  |  |  | 05:00-05:59 |  |  | 05:00-05:59
 |  |  |  |  |  |  |  |  | 06:00-06:59 |  |  | 06:00-06:59
 |  |  |  |  |  |  |  |  | 07:00-07:59 |  |  | 07:00-07:59
 |  |  |  |  |  |  |  |  | 08:00-08:59 |  |  | 08:00-08:59
 |  |  |  |  |  |  |  |  | 09:00-09:59 |  |  | 09:00-09:59
 |  |  |  |  |  |  |  |  | 10:00-10:59 |  |  | 10:00-10:59
 |  |  |  |  |  |  |  |  | 11:00-11:59 |  |  | 11:00-11:59
 |  |  |  |  |  |  |  |  | 12:00-12:59 |  |  | 12:00-12:59
 |  |  |  |  |  |  |  |  | 13:00-13:59 |  |  | 13:00-13:59
 |  |  |  |  |  |  |  |  | 14:00-14:59 |  |  | 14:00-14:59
 |  |  |  |  |  |  |  |  | 15:00-15:59 |  |  | 15:00-15:59
 |  |  |  |  |  |  |  |  | 16:00-16:59 |  |  | 16:00-16:59
 |  |  |  |  |  |  |  |  | 17:00-17:59 |  |  | 17:00-17:59
 |  |  |  |  |  |  |  |  | 18:00-18:59 |  |  | 18:00-18:59
 |  |  |  |  |  |  |  |  | 19:00-19:59 |  |  | 19:00-19:59
 |  |  |  |  |  |  |  |  | 20:00-20:59 |  |  | 20:00-20:59
 |  |  |  |  |  |  |  |  | 21:00-21:59 |  |  | 21:00-21:59
 |  |  |  |  |  |  |  |  | 22:00 + |  |  | 22:00 +
 |  |  |  |  |  |  |  |  | Client Movements |  |  | Shuttles
 |  |  |  |  |  |  |  |  | Air Georgian |  |  | 04:00-04:59
 |  |  |  |  |  |  |  |  | Air North |  |  | 05:00-05:59
 |  |  |  |  |  |  |  |  | Air Partners/Morgan air |  |  | 06:00-06:59
 |  |  |  |  |  |  |  |  | Air Sprint |  |  | 07:00-07:59
 |  |  |  |  |  |  |  |  | Air Tindi / Disovery Air |  |  | 08:00-08:59
 |  |  |  |  |  |  |  |  | Airborne |  |  | 09:00-09:59
 |  |  |  |  |  |  |  |  | Airco |  |  | 10:00-10:59
 |  |  |  |  |  |  |  |  | Alberta Central Airways |  |  | 11:00-11:59
 |  |  |  |  |  |  |  |  | Can-West |  |  | 12:00-12:59
 |  |  |  |  |  |  |  |  | [NAME] |  |  | 13:00-13:59
 |  |  |  |  |  |  |  |  | CathTon |  |  | 14:00-14:59
 |  |  |  |  |  |  |  |  | CDN North |  |  | 15:00-15:59
 |  |  |  |  |  |  |  |  | Cervus |  |  | 16:00-16:59
 |  |  |  |  |  |  |  |  | CMA |  |  | 17:00-17:59
 |  |  |  |  |  |  |  |  | Enerjet |  |  | 18:00-18:59
 |  |  |  |  |  |  |  |  | FedEX |  |  | 19:00-19:59
 |  |  |  |  |  |  |  |  | Grimes |  |  | 20:00-20:59
 |  |  |  |  |  |  |  |  | HawkAir |  |  | 21:00-21:59
 |  |  |  |  |  |  |  |  | Integra |  |  | 22:00 +
 |  |  |  |  |  |  |  |  | IronBrothers |  |  | Total Shuttle
 |  |  |  |  |  |  |  |  | Jazz
 |  |  |  |  |  |  |  |  | JV Driver
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | NCA
 |  |  |  |  |  |  |  |  | Nor-Alta
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Northern Air
 |  |  |  |  |  |  |  |  | NWAL
 |  |  |  |  |  |  |  |  | Regional 1
 |  |  |  |  |  |  |  |  | Storm
 |  |  |  |  |  |  |  |  | Suncor
 |  |  |  |  |  |  |  |  | Sunwest
 |  |  |  |  |  |  |  |  | Syncrude
 |  |  |  |  |  |  |  |  | Perimeter
Spreadsheet: 694324d1599534979-counting-empty-blank-upward-until-last-populated-cell-count-blank-cells-2
Sheet: Sheet3

 |  |  | < formula for this should show number of empty cells from last populated cells
1 | 4 | 12
 |  |  |  | 1 | 1 | 3 | 8
 |  |  |  | 3 | 3 | a | t
 |  |  |  | b | e | t | a
 |  |  |  | 2 | 4 | a | u
 |  | 8 |  | 1 | 1 | 8 | a
 |  |  |  | 1 | a | 12 | t
 |  |  |  | b | e | a | a
 |  |  |  | a | a | a | e
 |  |  |  | 1 | a | a | e
 |  |  |  | a | a | a | e
 |  |  |  | 1 | 4 | 4 | 4
 |  |  |  | a | 1 | 12 | e
 |  |  |  | a | 3 | a | e
 |  |  |  | a | a | 1 | e
 |  |  |  | a | 4 | a | 1
 |  |  |  | 1 | 1 | a | e
 |  |  |  | a | a | a | 6
Spreadsheet: 598912d1542788395-formula-containing-index-match-isnumber-and-search-with-a-few-ifs-thrown-in-not-working-data-checking
Sheet: Subjects Status

Surname Forename | Gender | NC Year | Admission No | Spanish - BLP | Technology - WA | Technology - BLP | Spanish - BLP Grade Check | Technology - WA Grade Check | Technology - BLP Grade Check | Spanish - BLP Class | Technology - WA Class | Technology - BLP Class |  | Technology - WA Class | Technology - BLP Class
aaa | F | 8 | 8541 |  |  |  |  |  |  |  |  |  |  | 8x/Tx2 | 8x/Tx2
bbb | F | 8 | 8544 |  |  |  |  |  |  |  |  |  |  | 8x/Ft1 | 8x/Ft1
[NAME] | F | 8 | 8545 |  |  |  |  |  |  |  |  |  |  | 8x/Ft1 | 8x/Ft1
ddd | F | 8 | 8546 |  |  |  |  |  |  |  |  |  |  | 8y/Tx1 | 8y/Tx1
eee | F | 8 | 8547 | 5 |  |  |  |  |  |  |  |  |  | 8x/Tx1 | 8x/Tx1
[NAME] | F | 8 | 8550 |  |  |  |  |  |  |  |  |  |  | 8y/Ft1 | 8y/Ft1
ggg | F | 8 | 8557 | 6 |  |  |  |  |  |  |  |  |  | 8y/Te1 | 8y/Te1
hhh | F | 8 | 8565 |  |  |  |  |  |  |  |  |  |  | 8y/Te1 | 8y/Te1
jjj | F | 8 | 8855 |  |  |  |  |  |  |  |  |  |  | 8x/Te1 | 8x/Te1
Spreadsheet: 686132d1594377808-how-to-create-a-formula-but-only-if-it-doesnt-match-any-entries-in-another-column-payrol-test-v11
Sheet: Pay Codes

Pay code | Pay Code Description | Rate
1 | Care wk | 20
2 | Care wk eve | 25
3 | Care wkend | 26
4 | Care wkend eve | 25
5 | Sleeping Nights | 24
6 | Waking Night wk | 34
7 | Waking Night wkend | 23
20 | Admin/Compliance | 1
21 | Shadowing | 4
22 | Supervisions
60 | Team Meeting
42 | Training/Elearning
25 | On-Call | 8
Spreadsheet: 493385d1481700428-day-number-in-a-quarter-weekday
Sheet: weekday

Date | WeekName | Number of Week Day | Qtr
2010-01-01 00:00:00