tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: McKenzie

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 550063d1512074133-tally-up-x-marks-for-roll-sheets-with-names-on-multiple-sheets-master-attendance-sheet-example
Sheet: Tuesday

 | TUESDAY
 |  | 2017-09-19 00:00:00
 | STUDENT NAME | WK1 | WK2 | WK3 | WK4 | WK5 | WK6 | WK7 | WK8 | WK9 | WK10 | WK11 | WK12 | WK13 | WK14 | WK15 | WK16 | WK17
1 | AJAY SMITH | X
 | ALEX YU |  |  |  |  | X | X |  | X | X | X | X
 | ALEXANDRA MCDONALD | X |  |  |  |  |  | X
 | [NAME] |  | X
 | ANGEL YOU | X | X | X | X | X | X | X | X | X | X | X
 | ANNIE CLARK |  | X |  |  | X |  |  | X | X
 | BECCA GOODSON |  |  |  |  | X | X
 | [NAME] | X |  |  |  |  |  | X
 | [NAME] |  |  | X | X | X
 | SAMUEL SMITH |  |  |  |  | X
Spreadsheet: 788008d1658224499-if-or-ifs-function-to-evaluate-multiple-conditions-sample-file-dose-comparision
Sheet: Sheet1

Theoritical dose based on age | Prescribed dose | Underdosed | overdosed
110mg | 110mg | No | No
110mg | 75mg | Yes | No
Dose down to clinical judgement | 150mg | Dose down to clinical judgement | Dose down to clinical judgement
100mg | 150mg | No | Yes
Dose down to clinical judgement | 110mg | Dose down to clinical judgement | Dose down to clinical judgement
150mg | 75mg | Yes | No
Spreadsheet: 190088d1351522775-how-to-add-a-horizontal-line-to-a-graph-plot-a-line
Sheet: Sheet1

 |  | 20 | 43 |  |  | change this value
 |  | 23
 |  | 34
 |  | 54
 |  | 23
 |  | 15
 |  | 53
 |  | 76
 |  | 41
 |  | 21
 |  | 31
 |  | 41
 |  | 24
 |  | 32
Spreadsheet: 172909fb-bf08-42ea-9c8a-c275f0289967
Sheet: Available Historical Tables

Contents
Available Historical Tables (click on title to go to table)
Fall | Spring
Headcount | Headcount
Academic Level
Undergraduate (Incl. No Data and Non Home-Based)
Graduate
Ethnicity
Chinese
Filipino
Japanese
Korean
Other Asian
Native Hawaiian or Part-Hawaiian
Pacific Islander
Hispanic
Caucasian
African American or Black
Amer Indian or Alaskan Native
[NAME] (2 or More)
No Data
STEM Majors Headcount
Spreadsheet: 695679d1600340999-vlookup-returns-0-after-text-conversion-example-sheet-20200917-vlookup_chris
Sheet: Data

Unique ID in Tekst | Crosscheck in groups | displayName | surname | givenName | id |  | Look up on original ID | Comment
 |  | 2elijn |  |  | d5ba47f6-eb3d-44cc-b3d1-0d0558c14d80
 |  | 3CX Wallboard | Wallboard | 3CX | b44ae438-a336-49bc-b28f-f337eaab510b
 |  | Aaisja Khealiram | Khealiram | Aaisja | ef055e4a-4dbb-4a60-b565-66927c4e0bf5
 |  | aanvraag |  |  | 125bbe01-1d76-4809-8b93-2c70f813d1f1
 |  | [NAME] | Fizesan | [NAME] | 930c8630-73fa-4284-aa49-04f05eff4308
 |  | [NAME] | Ciccarello | Dario | 0bcb6213-3ef2-40c0-aca0-1e36302a1806
 |  | [NAME] | Planning | [NAME] | 63f70d0d-187a-4ff7-a6b6-1a40e392bb80
 |  | Dashboard Service | Service | [NAME] | 60e91b97-d72c-4f0f-89a8-8083d266b965
 |  | [NAME] |  |  | 06aa97a5-ba32-4a5c-9969-34612e5a5f56
 |  | [NAME] | Cammeraat | Debora | c8cedb1d-7107-4c96-833a-fabcfdf222ed
 |  | [NAME] | [NAME] | [NAME] | faaafa07-3b96-47ad-817b-d29eef585ccd
 |  | [NAME] | Gruijs | Dennis | 2142231a-8f6b-4127-bb00-32c338aef463 |  |  | Why #N/A? ID exist on the groups tab?
 |  | [NAME] | [NAME] | Dennis | f9c9dd81-1c6f-4150-a4dc-387dce699e81
 |  | [NAME] | [NAME] | Dennis | 14f31995-dafc-478b-aae3-1b6f4a5cef0b |  |  | Why #N/A? ID exist on the groups tab?
 |  | [NAME] | Bullinger | [NAME] | 36d189f0-cb9d-470a-9492-c6cdbd440954
 |  | [NAME] | [NAME] | [NAME] | ba022e45-29c2-4dab-b28d-b10b11541601
 |  | [NAME] | [NAME] | [NAME] | 4ea64d9d-87e3-4b9c-84ff-f0aadded0fdb
 |  | Developer |  |  | 744995fd-0908-4d9f-9b0b-adc3c1e8c912
Spreadsheet: 859239d1707711162-countif-cells-having-initials-and-possibly-symbols-scheduleexceltest
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | / indicates a half hour scheduling increment       ^ indicates a 15 min scheduling increment
 |  | Mon |  |  |  |  |  |  | Tue |  |  |  |  |  |  | Wed
12A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
1A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
2A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
3A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
4A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
5A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
6A |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | KS
7A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
8A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
9A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
10A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
11A |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
12P |  |  | AK |  |  |  |  |  |  | AK |  |  |  |  |  |  | AK
1P |  |  | AK |  | DM/ |  |  |  |  | AK |  | [NAME] |  |  |  |  | AK |  | MC^
2P |  |  |  |  | DM |  |  |  |  | AK |  | DM |  |  |  |  | AK |  | MC
3P |  |  |  |  | DM |  |  |  |  | AK/ |  | DM |  |  |  |  |  |  | MC
4P |  |  |  |  | DM |  |  |  |  |  |  | DM |  |  |  |  |  |  | MC
5P |  |  |  |  | DM |  |  |  |  |  |  | DM |  |  |  |  |  |  | MC |  |  |  |  |  | This is what the totals
6P |  |  |  |  | DM |  |  |  |  |  |  | DM |  |  |  |  |  |  | MC |  |  |  |  |  | should be
7P |  |  |  |  | DM |  |  |  |  |  |  | DM |  |  |  |  |  |  | MC |  |  |  |  |  | KS | 27
8P |  |  |  |  | DM |  |  |  | [NAME] |  |  | DM |  |  |  |  |  |  | MC |  |  |  |  |  | JB | 2.5
9P |  | [NAME] |  |  | DM/ |  |  |  | KS |  |  |  |  |  |  | [NAME] |  |  | MC/ |  |  |  |  |  | MC | 7.75
10P |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | JB |  |  |  |  |  |  |  |  | AK | 23.5
11P |  | KS |  |  |  |  |  |  | KS |  |  |  |  |  |  | JB
 |  | Sign next to your name indicating you are accepting these shifts. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | KS |  |  |  |  | Moore, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | DM |  |  |  | This is the formula that we use right now
[NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | JB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You can see how it will calculate 1 hour for
Call, Mark |  |  |  |  |  |  |  |  |  |  |  |  | MC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | just the initials, .5 hour if there is a / , and
[NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | AK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .25 hour if there is ^ .
Spreadsheet: 0dcd259c-09de-4793-8c17-2c8ea298da0a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 181 |  |  |  | 181
 | ALLEGHENY |  |  |  | 4627 | 4627
 | ARMSTRONG |  |  |  | 436 | 436
 | BEAVER |  |  |  | 785 | 785
 | BEDFORD |  |  |  | 312 | 312
 | BERKS | 1056 |  |  |  | 1056
 | BLAIR |  |  |  | 650 | 650
 | BRADFORD |  |  | 165 |  | 165
 | BUCKS |  | 1706 |  |  | 1706
 | BUTLER |  |  |  | 806 | 806
 | CAMBRIA |  |  |  | 1188 | 1188
 | CAMERON |  |  |  | 45 | 45
 | CARBON |  |  | 211 |  | 211
 | CENTRE | 338 |  |  | 128 | 466
 | CHESTER |  | 866 |  |  | 866
 | CLARION |  |  |  | 223 | 223
 | CLEARFIELD |  |  |  | 755 | 755
 | CLINTON |  |  | 126 |  | 126
 | COLUMBIA | 208 |  |  |  | 208
 | CRAWFORD |  |  |  | 490 | 490
 | CUMBERLAND | 376 |  |  |  | 376
 | DAUPHIN | 517 |  |  |  | 517
 | DELAWARE |  | 1856 |  |  | 1856
 | ELK |  |  |  | 310 | 310
 | ERIE |  |  |  | 1911 | 1911
 | FAYETTE |  |  |  | 929 | 929
 | FOREST |  |  |  | 31 | 31
 | FRANKLIN | 343 |  |  |  | 343
 | FULTON | 50 |  |  |  | 50
 | GREENE |  |  |  | 286 | 286
 | HUNTINGDON |  |  |  | 257 | 257
 | INDIANA |  |  |  | 551 | 551
 | JEFFERSON |  |  |  | 301 | 301
 | JUNIATA | 81 |  |  |  | 81
 | [NAME] |  |  | 488 |  | 488
 | LANCASTER | 804 |  |  |  | 804
 | [NAME] |  |  |  | 533 | 533
 | LEBANON | 208 |  |  |  | 208
 | LEHIGH | 774 |  |  |  | 774
 | LUZERNE |  |  | 827 |  | 827
 | LYCOMING |  |  | 195 |  | 195
 | MCKEAN |  |  |  | 222 | 222
 | MERCER |  |  |  | 576 | 576
 | MIFFLIN | 216 |  |  |  | 216
 | MONROE |  |  | 384 |  | 384
 | MONTGOMERY |  | 2073 |  |  | 2073
 | MONTOUR | 25 |  |  |  | 25
 | NORTHAMPTON | 536 |  |  |  | 536
 | NORTHUMBERLAND | 291 |  |  |  | 291
 | PERRY | 138 |  |  |  | 138
 | PHILADELPHIA |  | 8128 |  |  | 8128
 | PIKE |  |  | 132 |  | 132
 | POTTER |  |  |  | 152 | 152
 | SCHUYLKILL | 370 |  |  |  | 370
 | SNYDER | 87 |  |  |  | 87
 | [NAME] |  |  |  | 614 | 614
 | SULLIVAN |  |  | 19 |  | 19
 | SUSQUEHANNA |  |  | 202 |  | 202
 | TIOGA |  |  | 148 |  | 148
 | UNION | 73 |  |  |  | 73
 | VENANGO |  |  |  | 329 | 329
 | WARREN |  |  |  | 223 | 223
 | WASHINGTON |  |  |  | 926 | 926
 | WAYNE |  |  | 140 |  | 140
 | WESTMORELAND |  |  |  | 2056 | 2056
 | WYOMING |  |  | 70 |  | 70
 | YORK | 669 |  |  |  | 669
 | Totals | 7341 | 14629 | 3107 | 20652 | 45729
Spreadsheet: 163950d1340567897-sum-index-formula-help
Sheet: Sheet1

Type | Code | Amount
A | Z001 | 100 |  | Requirement: Sum of Column "C" where Column "B" equals a particular code and Column "A" cells contain values in any one of the cells in Range "J4:J6".
B | Z001 | 125
C | Z001 | 110
D | Z001 | 135 |  |  |  |  |  |  | Match
E | Z001 | 150 |  | e.g. | Test | Test (Array) | Answer |  | B
F | Z001 | 105 |  | Z001 |  |  | 365 |  | D
G | Z001 | 100 |  |  |  |  |  |  | F
A | Z002 | 102
B | Z002 | 109 |  | Why the above formula is returning errror, even the array version is returning error !!!
C | Z002 | 111
D | Z002 | 145
E | Z002 | 137
F | Z002 | 100
G | Z002 | 125
A | Z003 | 110
B | Z003 | 135
C | Z003 | 150
D | Z003 | 105
E | Z003 | 100
F | Z003 | 102
G | Z003 | 109
A | Z004 | 111
B | Z004 | 145
C | Z004 | 137
D | Z004 | 100
E | Z004 | 125
F | Z004 | 110
G | Z004 | 135
A | Z005 | 150
B | Z005 | 105
C | Z005 | 100
D | Z005 | 102
E | Z005 | 109
F | Z005 | 111
G | Z005 | 145
Spreadsheet: 269338d1381134330-reference-data-in-a-row-based-on-data-in-a-cell-training-record-matrix
Sheet: Personnel Sheet

Name: | Builder | FirstName
SAP: | 1111111
Role: | Electrician
Mandatory Quals
Electrical Licence: | EW987987 | 2017-02-23 00:00:00 | Electrical Mechanic
Drivers Licence: | 12345678 | 2014-10-26 00:00:00 | WA | C
CPR: | 2014-05-02 00:00:00
Working @ Heights: | 2014-09-26 00:00:00
W@H RTIO GAP: | 1900-01-01 00:00:00
RTIO HSE: | 2015-04-02 00:00:00
RTIO PIO: | 2014-03-26 00:00:00
[NAME] Site: | 2015-04-21 00:00:00
[NAME] Plant: | 2015-04-21 00:00:00
Basic Fire: | 2014-05-02 00:00:00
Construction Card: | 81600
Electrical Workers Competency: | 2015-04-23 00:00:00
[NAME]: | 2015-04-23 00:00:00
Spreadsheet: 77196d1277722697-displaying-the-colour-of-a-conditional-format-in-another-cell-forum-excel
Sheet: Figures

 | BOARD REPORT FIGURES
 | MAY 2010
1 ACCESS
 |  |  |  | This Month |  | Year to Date
PROJECT |  |  | Target | Actual | % | New Cases | %
ASSESSMENT |  |  | 815 | 758 | 0.9300613496932515
COURT TEAM |  |  | 72 | 66 | 0.9166666666666666
OUTREACH |  |  | 48 | 19 | 0.3958333333333333
TELEPHONE |  |  | 194 | 306 | 1.577319587628866
2 CASEWORK
 |  |  |  | This Month |  | Year to Date
PROJECT |  |  | Target | Actual | % | New Cases | %
DISCRIMINATION |  |  | 8 | 8 | 1
FIF DEBT |  |  | 67 | 80 | 1.194029850746269
NEW LEGAL AID |  |  | 158 | 151 | 0.9556962025316456
RENT ARREARS |  |  | 36 | 8 | 0.2222222222222222
3 CLIENTS
 |  |  |  | This Month |  | Year to Date
PROJECT |  |  | Target | Actual | % | New Cases | %
COMPLAINTS |  |  | 1 | 0
DAY 1 |  |  | 1 | 0.95 | 0.95
NO SHOW RATE |  |  | 0.05 | 0.05 | 0.05
WAITING TIME (DAYS) |  |  | 5 | 5 | 5
 | BOARD REPORT FIGURES
 | MAY 2010
4 COMPLIANCES
 |  |  |  | This Month |  | Year to Date
PROJECT |  |  | Target | Actual | % | New Cases | %
FILING LIVE |  |  | 12 | 12 | 1
FIRE TESTS |  |  | 8 | 8 | 1
FIRST AIDERS |  |  | 9 | 9 | 1
INSURANCES LIVE |  |  | 5 | 5 | 1
5 PEOPLE
 |  |  |  | This Month |  | Year to Date
PROJECT |  |  | Target | Actual | % | New Cases | %
CONTRACTS ISSUED |  |  | 64 | 64 | 1
APPRAISALS |  |  | 54 | 54 | 1
SICKNESS RATE |  |  | 0.04 | 0.01 | 0.25
TRAINED RECRUITS |  |  | 20 | 20 | 1
6 MONEY
 |  |  |  | This Month |  | Year to Date
PROJECT |  |  | Target | Actual | % | New Cases | %
CASH TO PLAN |  |  | 150000 | 150100 | 1.000666666666667
EXPENDITURE |  |  | 145566 | 145560 | 0.9999587815836115
INCOME TO PLAN |  |  | 144861 | 144890 | 1.000200191908105
SIGNED CONTRACTS |  |  | 13 | 13 | 1
 |  |  | 1.5
 | CODING |  | 1.26
0.89 | 0.84 | 3 | 0.89 | 11 | 1458873 | 12 |  | 0.15 | 5
0.9 | 0.85 |  | 0.9 | 10 |  | 11 | 2 | 0.16 | 6
0.94 | 0.99 | 2 | 0.94 | 6 |  | 7 | 1 |  | 15
0.95 | 1 | 1 | 0.95 | 5 |  | 6 | 0 |  | 16
0.91 | 1.01 |  | 0.99
Spreadsheet: 715795d1611866874-tiered-payments-with-multiple-variables-sample-workbook
Sheet: Sheet2

 | C1.1.1 | 0 | 3
 | C2.1.1 | 3 | 6
 | [NAME] | 6 | 12
 | C4.1.1 | 12 | 24
 | C5.1.1 | 24 | 999999
 | C1.1.2 | 0 | 3
 | C2.1.2 | 3 | 6
 | C3.1.2 | 6 | 12
 | C4.1.2 | 12 | 24
 | C5.1.2 | 24 | 999999
 | C1.2.1 | 0 | 3
 | C2.2.1 | 3 | 6
 | C3.2.1 | 6 | 12
 | C4.2.1 | 12 | 24
 | C5.2.1 | 24 | 999999
 | C1.2.2 | 0 | 3
 | C2.2.2 | 3 | 6
 | C3.2.2 | 6 | 12
 | [NAME] | 12 | 24
 | C5.2.2 | 24 | 999999
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: Income-SL

3-501 Income - StudyLink
Date | Ref. | Details | Debit |  | Date | Ref. | Details | Credit
 |  |  |  |  | 2008-12-08 00:00:00 | 1-001 | National Bank - Cheque | 184.17
 |  |  |  |  | 2008-12-16 00:00:00 | 1-001 | National Bank - Cheque | 184.17
 |  |  |  |  | 2008-12-23 00:00:00 | 1-001 | National Bank - Cheque | 184.17
 |  | Total | 0 |  |  |  | Total | 552.51
 |  | Balance |  |  |  |  | Balance | 552.51
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: AC Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 29-01-2019 | pdf |  | 11-01) 25-11-2015 | pdf |  | 04-01) 22-04-2019 | pdf |  | 04-01) 22-04-2019 | pdf |  | 04-01) 22-04-2019 | pdf
 | 03-01) 13-03-2019 | pdf |  | 12-01) 28-12-2015 | pdf |  |  |  |  |  |  |  | 07-01) 11-07-2019 | pdf
 | 04-01) 07-04-2019 | pdf |  | 04-01) 23-04-2019 | pdf |  |  |  |  |  |  |  | 02-01) 05-02-2020 | pdf
 | 06-01) 02-06-2019 | pdf |  | 07-01) 02-07-2019 | pdf
 | 07-01) 02-07-2019 | pdf |  | 03-01) 02-03-2020 | pdf
 | 07-02) 11-07-2019 | pdf
 | 02-01) 05-02-2020 | pdf
 | 02-02) 23-02-2020 | pdf
Spreadsheet: 808501d1670500079-how-to-calculate-result-by-skipping-blank-cells-exam-results-etaf
Sheet: Sheet1

STUDENT NO | ENGLISH | PHYSICS | CHEMISTRY | MATHS | BIO | IT | YOGA | RESULT
1 | 34 | 33 | 45 |  | 33
2 | 45 | 31 | 32 | 33 |  | 21
3 | 31 | 45 | 34 | 23 |  | 37
4 | 1 | 1 | 45 |  |  | 1 | 1
 |  | If a student obtained greater than and equal to 33 marks then print result? PASS? in RESULT (I) column otherwise print fails in that subject in which mark obtained less than 33. Also, some cells are blank.
 |  | e.g., STUDENT No. 2, obtained less than 33 marks in PHYSICS, CHEMISTRY and in IT. Also, BIOLOGY & YOGA cells are blanked, the result should be FAILS IN PHYSICS, CHEMISTRY, IT.
 |  | I have used the following formula which is not work:
 |  | IF(COUNT(B2:H2)=0,"",IF(COUNTIFS(B2:H2,">=33")=COUNT(B2:H2),"Pass","Fails in "&TEXTJOIN(", ",,FILTER($B$1:$H$1,(B2:H2<33)*(B2:H2<>"")))))
Spreadsheet: 765166d1643200985-need-help-in-finding-any-formula-to-get-difference-of-in-and-out-timing-copy-of-sample-works-aligw
Sheet: Manual format

 |  |  | Status |  | Status |  | Status
Employee Name | Emp Number | 22/01/2022 | 22/01/2022 | 23/01/2022 | 23/01/2022 | 25/01/2022 | 25/01/2022
A | SP-01
B | SP-06
C | SP-07
D | SP-09
Vlookup in the SYSTEM EXTRACTED tab, the difference between IN and OUT if for the employee is 8 HOURS show nothing.
if the difference in IN and OUT is less then 8 hours and above 4 hours show Half Day
if the difference in IN and OUT is less then 8 hours and above 2 hours show Short Leave
Spreadsheet: 769902d1645720899-reduce-1-minute-data-to-30-minute-data-in-excel-s2_5-minutes-to-30-minutes
Sheet: Sheet4

[NAME] | Description | Result
 | Displays the value in cell [NAME] (4) | 4
 | Sums the range B6:D8 | 34
 | Returns an error, because the reference is to a non-existent range on the worksheet. | #REF!
 | Data | Data
 | 4 | 10
 | 8 | 3
 | 3 | 6
Spreadsheet: 57112d1257278322-copy-data-to-specific-records-increment
Sheet: Sheet1

Jones | David | 1 | 10/10/1970 | 12345 | 12345
Jones | Sue | 2 | 11/11/1974 | 12346 | 12345
Jones | Fred | 3 | 10/10/1990 | 12347 | 12345
Smith | Bill | 1 | 01/01/1965 | 12348 | 12348
Smith | [NAME] | 2 | 09/09/1968 | 12349 | 12348
Smith | Bill | 1 |  |  | 12350
Smith | [NAME] | 2 |  |  | 12350
Smith | Bill | 3 |  |  | 12350
Smith | [NAME] | 4 |  |  | 12350
Smith | Bill | 5 |  |  | 12350
Smith | [NAME] | 6 |  |  | 12350
Jones | David | 1 |  |  | 12356
Jones | Sue | 2 |  |  | 12356
Jones | Fred | 3 |  |  | 12356
Spreadsheet: mary_fischer__25738__Quebecor Amort
Sheet: New Quebecor

EES - Company 20R
Amortization Schedule
Quebecor
Life - 5 Years
EES - Company 20R
Amortization Schedule
Date |  | Payment | Amortization Schedule | Balance on BS | Month
2000-04-01 00:00:00 |  | 5000000
2000-05-01 00:00:00 |  |  |  |  | 60
2000-06-01 00:00:00 |  |  |  |  | 59
2000-07-01 00:00:00 |  |  |  |  | 58
2000-08-01 00:00:00 |  |  |  |  | 57
2000-09-01 00:00:00 |  |  |  |  | 56
2000-10-01 00:00:00 |  |  |  |  | 55
2000-11-01 00:00:00 |  |  |  |  | 54
2000-12-01 00:00:00 |  |  |  | 4692694.363031668 | 53
2001-01-01 00:00:00 |  |  |  |  | 52
2001-02-01 00:00:00 |  |  | 90244.12 |  | 51
2001-03-01 00:00:00 |  |  | 90244.12 |  | 50
2001-04-01 00:00:00 |  |  | 90244.12 |  | 49
2001-05-01 00:00:00 |  |  | 90244.12 |  | 48 | True Up:
2001-06-01 00:00:00 |  |  | 90244.12 |  | 47
2001-07-01 00:00:00 |  |  | 90244.12 |  | 46
2001-08-01 00:00:00 |  |  | 90244.12 |  | 45
2001-09-01 00:00:00 |  |  | 90244.12 |  | 44
2001-10-01 00:00:00 |  |  | 90244.12 |  | 43
2001-11-01 00:00:00 |  |  | 90244.12 |  | 42
2001-12-01 00:00:00 |  |  | 90244.12 |  | 41
2002-01-01 00:00:00 |  |  | 90244.12 |  | 40
2002-02-01 00:00:00 |  |  | 90244.12 |  | 39
2002-03-01 00:00:00 |  |  | 90244.12 |  | 38
2002-04-01 00:00:00 |  |  | 90244.12 |  | 37
2002-05-01 00:00:00 |  |  | 90244.12 |  | 36
2002-06-01 00:00:00 |  |  | 90244.12 |  | 35
2002-07-01 00:00:00 |  |  | 90244.12 |  | 34
2002-08-01 00:00:00 |  |  | 90244.12 |  | 33
2002-09-01 00:00:00 |  |  | 90244.12 |  | 32
2002-10-01 00:00:00 |  |  | 90244.12 |  | 31
2002-11-01 00:00:00 |  |  | 90244.12 |  | 30
2002-12-01 00:00:00 |  |  | 90244.12 |  | 29
2003-01-01 00:00:00 |  |  | 90244.12 |  | 28
2003-02-01 00:00:00 |  |  | 90244.12 |  | 27
2003-03-01 00:00:00 |  |  | 90244.12 |  | 26
2003-04-01 00:00:00 |  |  | 90244.12 |  | 25
2003-05-01 00:00:00 |  |  | 90244.12 |  | 24
2003-06-01 00:00:00 |  |  | 90244.12 |  | 23
2003-07-01 00:00:00 |  |  | 90244.12 |  | 22
2003-08-01 00:00:00 |  |  | 90244.12 |  | 21
2003-09-01 00:00:00 |  |  | 90244.12 |  | 20
2003-10-01 00:00:00 |  |  | 90244.12 |  | 19
2003-11-01 00:00:00 |  |  | 90244.12 |  | 18
2003-12-01 00:00:00 |  |  | 90244.12 |  | 17
2004-01-01 00:00:00 |  |  | 90244.12 |  | 16
2004-02-01 00:00:00 |  |  | 90244.12 |  | 15
2004-03-01 00:00:00 |  |  | 90244.12 |  | 14
2004-04-01 00:00:00 |  |  | 90244.12 |  | 13
2004-05-01 00:00:00 |  |  | 90244.12 |  | 12
2004-06-01 00:00:00 |  |  | 90244.12 |  | 11
2004-07-01 00:00:00 |  |  | 90244.12 |  | 10
2004-08-01 00:00:00 |  |  | 90244.12 |  | 9
2004-09-01 00:00:00 |  |  | 90244.12 |  | 8
2004-10-01 00:00:00 |  |  | 90244.12 |  | 7
2004-11-01 00:00:00 |  |  | 90244.12 |  | 6
2004-12-01 00:00:00 |  |  | 90244.12 |  | 5
2005-01-01 00:00:00 |  |  | 90244.12 |  | 4
2005-02-01 00:00:00 |  |  | 90244.12 |  | 3
2005-03-01 00:00:00 |  |  | 90244.12 |  | 2
2005-04-01 00:00:00 |  |  | 90244.24 |  | 1
Spreadsheet: 847780d1698656985-need-help-to-manipulate-and-delete-data-across-multiple-worksheets-example-1
Sheet: Sheet3

Full Name | Student Number | Location | Division | Date
Scooby Doo | garsefgre | a | a | 2023-10-15 00:00:00
[NAME] | opaiudjf | a | a | 2023-05-04 00:00:00
[NAME] | argfdsads | a | a | 2022-06-06 00:00:00
Location B
Full Name | Student Number | Location | Division | Date
[NAME] | 12sd7 | b | a | 2023-07-18 00:00:00
Brer Rabbit | avead | b | a | 2023-04-05 00:00:00
[NAME] | 34gtad | b b2 | a | 2022-06-03 00:00:00
Location C
Full Name | Student Number | Location | Division | Date
[NAME] | 32gvad | c | a | 2023-02-21 00:00:00
[NAME] | lpa0sdjnha | c | a | 2022-06-19 00:00:00
Daffy Duck | 06dfg | c | a | 2021-10-11 00:00:00
Location D
Full Name | Student Number | Location | Division | Date
Wile E Coyote | bacvq | d | a | 2021-05-26 00:00:00
Alf Neuman | 986kfg | d d2 | a | 2022-12-18 00:00:00
[NAME] | w5gn6yu | d d2 | a | 2022-02-15 00:00:00
Location E
Full Name | Student Number | Location | Division | Date
[NAME] | nsdf5 | e | a | 2022-06-19 00:00:00
[NAME] | asdvra37 | e | a | 2021-09-09 00:00:00
Spreadsheet: 679414d1590409117-deferred-revenue-various-billing-cycle-test-ml-3-
Sheet: Sheet1

Customer | Invoice Date | Start Date | End Date | Amount | [NAME] | Frequency Value |  | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | total payment
A | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-30 00:00:00 | 10000 | 1
B | 2019-02-01 00:00:00 | 2019-02-01 00:00:00 | 2020-05-30 00:00:00 | 15000 | 3
C | 2019-05-01 00:00:00 | 2019-05-01 00:00:00 | 2020-06-30 00:00:00 | 350000 | 6
D | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2020-12-31 00:00:00 | 50000 | 12
Spreadsheet: 585057d1533591571-ref-question-monday-reporting-
Sheet: Round Up 

Sales
Week Ending |  |  |  |  |  | Total
Sales Actual
Budget Sales
Last Year Sales
Sales Vs Budget
LFL %
Stock (Rolling)
 | 1 Week | 2 Week | 3 Week | 4 Week | Total | 5 Week | Total
Total Purchasing
As Percentage
Target Purchasing
Over/Under
Labour
Labour Spend
Spend Target
Over/Under
As Percentage
Spreadsheet: 103760d1301480913-dynamic-lists-using-names-sample-21
Sheet: Sheet2

employee
susan | skill 1 | skill 2 | skill 3
[NAME] | skill 1 | skill 2 | skill 3
[NAME] | skill 1 | n/a | skill 3
[NAME] | skill 1 | skill 2
[NAME] | skill 1 | skill 2
Burt | skill 1