tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 693608d1599056101-random-calculation-error-with-adding-and-subtracting-times-timesheet-problem
Sheet: Jul

July 2020
 |  |  | Hours worked |  |  |  |  | Total |  |  | Travel |  |  |  | Total |  |  | Adjustment | Adjusted total | Top-up | Total with top-up |  |  | Total hours |  |  |  |  |  | Overtime accrued
Date | Day | Day type | Morning |  | Afternoon |  | Private appointment |  |  |  | First travel |  | Second travel |  |  |  |  |  |  |  |  |  |  | Overall |  |  |  |  |  | Total
 |  |  | Start | Finish | Start | Finish |  |  |  |  | Start | Finish | Start | Finish |  |  |  |  |  |  |  |  |  | Total | Diff | Total | Diff | Total | Diff
2020-07-01 00:00:00 | Wed | Working day | 08:50:00 | 11:30:00 | 14:15:00 | 17:15:00 |  |  | 03:00:00
2020-07-02 00:00:00 | Thu | Working day | 09:35:00 | 12:25:00 | 13:10:00 | 18:00:00 |  |  | 06:30:00
2020-07-03 00:00:00 | Fri | Working day | 09:15:00 | 10:15:00 | 12:10:00 | 16:40:00 |  |  | 04:20:00
2020-07-04 00:00:00 | Sat | Weekend
2020-07-05 00:00:00 | Sun | Weekend
2020-07-06 00:00:00 | Mon | Working day | 07:40:00 | 08:20:00 | 09:45:00 | 17:10:00 |  |  | 04:00:00
2020-07-07 00:00:00 | Tue | Working day | 09:35:00 | 12:40:00 | 13:20:00 | 16:00:00 |  |  | 04:30:00
2020-07-08 00:00:00 | Wed | Working day | 08:40:00 | 12:50:00 | 13:55:00 | 16:30:00 |  |  | 02:30:00
2020-07-09 00:00:00 | Thu | Working day | 09:00:00 | 12:30:00 | 13:00:00 | 17:55:00 |  |  | 04:00:00
2020-07-10 00:00:00 | Fri | Working day | 09:00:00 | 12:05:00 | 14:40:00 | 17:00:00 |  |  | 04:00:00
2020-07-11 00:00:00 | Sat | Weekend
2020-07-12 00:00:00 | Sun | Weekend
2020-07-13 00:00:00 | Mon | Working day | 09:30:00 | 12:30:00 | 14:05:00 | 17:15:00 |  |  | 02:00:00
2020-07-14 00:00:00 | Tue | Working day | 09:50:00 | 12:30:00 | 13:00:00 | 16:25:00 |  |  | 02:00:00
2020-07-15 00:00:00 | Wed | Working day | 11:00:00 | 17:00:00 |  |  |  |  | 01:00:00
2020-07-16 00:00:00 | Thu | Working day | 09:20:00 | 12:00:00 | 13:00:00 | 16:20:00 |  |  | 02:00:00
2020-07-17 00:00:00 | Fri | Working day | 10:30:00 | 16:00:00 |  |  |  |  | 1904-01-02 00:00:00
2020-07-18 00:00:00 | Sat | Weekend
2020-07-19 00:00:00 | Sun | Weekend
2020-07-20 00:00:00 | Mon | Annual leave
2020-07-21 00:00:00 | Tue | Public holiday
2020-07-22 00:00:00 | Wed | Annual leave
2020-07-23 00:00:00 | Thu | Annual leave
2020-07-24 00:00:00 | Fri | Annual leave
2020-07-25 00:00:00 | Sat | Weekend
2020-07-26 00:00:00 | Sun | Weekend
2020-07-27 00:00:00 | Mon | Annual leave
2020-07-28 00:00:00 | Tue | Annual leave
2020-07-29 00:00:00 | Wed | Annual leave
2020-07-30 00:00:00 | Thu | Annual leave
2020-07-31 00:00:00 | Fri | Annual leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To carry forward:
 |  | Signatures
 |  | Employee |  |  |  |  |  | For ALLEA
 |  | Date | 3.08.2020 |  |  |  |  | Date
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Executive Director
Spreadsheet: 97fdc932-fcbd-4320-97d0-2dab2061e320
Sheet: Page 4

DIVISION OF WATER RESOURCES TAX CERTIFICATION & EXEMPTION APPLICATION |  |  |  |  |  |  |  |  |  | PAGE 4
Waste Treatment Systems & Equipment:  Waste treatment systems & equipment must be used exclusively for the abatement of water pollution |  |  |  |  |  |  |  |  |  | Rev 09/01/2013
For County Use Only |  | For DWR Use Only "A" Approved "D" Disapproved | Description of Waste Treatment Systems or Equipment | Was asset listed in the permit (Yes/No)           * | Asset Number, Vehicle Identification Number (VIN) | How is this equipment used for pollution abatement? | % of Use for Pollution Abatement | Year of Acquisition | Original Historical Cost** | Is this asset replacing a prior asset?
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
Attach additional pages if necessary
*   If the asset is listed in the DWR permit, the description must be identical as listed on the current permit.  If the asset is not specifically listed in the DWR permit, the applicant must attach detailed information as to why the asset should qualify for Tax Certification.
** When certifying systems or equipment, DENR is not certifying the cost of the equipment or the year of acquisition.
Applicant |  |  |  |  | Title: |  |  | Date:
Signature |  |  |  |  | Of:
 |  |  | (print name also) |  |  | (Name of Applicant Business Entity)                                                                                                                                                             TC-WQ
NOTICE:  The penalty for false statement, representation or certification                              herein includes imprisonnment and/or the assessment of civil penalties.
Spreadsheet: 727052d1617692955-unable-to-get-the-date-displayed-in-the-way-i-wish-test_change-date
Sheet: date format

Symbol | Trade Date |  |  |  |  |  |  | this file I got from somewhere else. I wanted to change the date format.
GODREJCP | 2020-03-06 |  |  |  |  |  |  | 1. I went to contrl panel -region and langugae-and set the date format as DD-MM-yyyy.
PIDILITIND | 2020-03-06 |  |  |  |  |  |  | 2. even then the date incol B  looks different.
SRF | 2020-03-06 |  |  |  |  |  |  | 3. It is formated as general. So I tried to change it to date. Even then it is not displaying the way I like
INFY | 2020-03-06 |  |  |  |  |  |  | 4. I want the date to appear as [NAME]. What to do?
JUBLFOOD | 2020-03-06 |  |  |  |  |  |  | 5, when I type the date in some other place it is displaying correctly.  See H14
NIITTECH | 2020-03-06
GENUSPAPER | 2020-03-06
GENUSPAPER | 2020-03-06
BAJFINANCE | 2020-03-06
BATAINDIA | 2020-03-06
ASTRAL | 2020-03-06
ASTRAL | 2020-03-06
GENUSPAPER | 2020-03-13 |  |  |  |  |  | 2020-06-14 00:00:00
Spreadsheet: 297032d1392263384-how-to-search-and-remove-a-series-of-entries-based-on-adjacent-values-search-and-remove
Sheet: Sheet1

 |  | The data to process is in Columns C and D.
 |  | I want to delete a series if the average of the numbers in the adjacent cell D is less than 20.
 |  | In below example,  All of Series 1 and 3 will remain, but all of Series 2 will be deleted.
Series 1 |  | 15263-001-1 | 24
15263-001 |  | 15263-001-2 | 89
 |  | 15263-001-3 | 3
 |  | 15263-001-4 | 62
 |  | 15263-001-5 | 40
Series 2 |  | 76219-002-1 | 0
76219-002 |  | 76219-002-2 | 0
 |  | 76219-002-3 | 5
 |  | 76219-002-4 | 4
 |  | 76219-002-5 | 9
 |  | 76219-002-6 | 22
 |  | 76219-002-7 | 4
 |  | 76219-002-8 | 18
 |  | 76219-002-9 | 7
 |  | 76219-002-10 | 0
 |  | 76219-002-11 | 0
Series 3 |  | 61232-851-1 | 150
61232-851 |  | 61232-851-2 | 200
 |  | 61232-851-3 | 34
 |  | 61232-851-4 | 68
 |  | 61232-851-5 | 51
 |  | 61232-851-6 | 89
 |  | 61232-851-7 | 2
 |  | 61232-851-8 | 46
 |  | 61232-851-9 | 5
 |  | 61232-851-10 | 80
Spreadsheet: 137932d1327434596-automatically-create-graphs-based-on-specific-data-graph-data
Sheet: Export Graph data

Date | responsible | Order Compliance (%) | ASN Compliance (%) | Arrive O Port Compliance (%) | Depart on Air Compliance (%) | average
2011-12-02 00:00:00 | FRA | 88 | 96 | 90 | 92 |  |  |  | X axis should show date
2011-12-02 00:00:00 | MUC | 48 | 100 | 38 | 25 |  |  |  | Y axis should show average value per responsible.
2011-12-02 00:00:00 | STR | 100 | 80 | 50 | 50
2011-12-02 00:00:00 | ANR | 100 | 100 | 80 | 80
2011-12-05 00:00:00 | FRA | 80 | 96 | 90 | 92 |  |  |  | Afterwards I need to create seperate sheets based on the responsible party. (see tab ANR for details)
2011-12-05 00:00:00 | MUC | 48 | 100 | 38 | 25
2011-12-05 00:00:00 | STR | 100 | 80 | 100 | 100
2011-12-05 00:00:00 | ANR | 100 | 100 | 100 | 80
2011-12-06 00:00:00 | FRA | 73 | 95 | 90 | 92
2011-12-06 00:00:00 | MUC | 48 | 83 | 38 | 25
2011-12-06 00:00:00 | STR | 80 | 75 | 100 | 100
2011-12-06 00:00:00 | ANR | 80 | 100 | 100 | 75
2011-12-07 00:00:00 | FRA | 70 | 95 | 90 | 92
2011-12-07 00:00:00 | MUC | 70 | 83 | 38 | 25
2011-12-08 00:00:00 | FRA | 73 | 96 | 90 | 92
2011-12-08 00:00:00 | MUC | 66 | 86 | 38 | 25
2011-12-08 00:00:00 | STR | 100 | 100 | 100 | 100
2011-12-08 00:00:00 | ANR | 83 | 100 | 100 | 80
2011-12-09 00:00:00 | FRA | 69 | 96 | 93 | 92
2011-12-09 00:00:00 | MUC | 44 | 86 | 38 | 25
2011-12-09 00:00:00 | STR | 83 | 100 | 100 | 100
2011-12-09 00:00:00 | ANR | 100 | 100 | 100 | 100
2011-12-09 00:00:00 | LHR | 0 | N/A
2011-12-12 00:00:00 | FRA | 87 | 97 | 93 | 93
2011-12-12 00:00:00 | MUC | 45 | 80 | 38 | 25
2011-12-12 00:00:00 | STR | 100 | 100 | 100 | 100
2011-12-12 00:00:00 | ANR | 100 | 100 | 100 | 100
2011-12-13 00:00:00 | FRA | 90 | 97 | 94 | 92
2011-12-13 00:00:00 | MUC | 48 | 80 | 38 | 25
2011-12-13 00:00:00 | STR | 100 | 100 | 100 | 100
2011-12-13 00:00:00 | ANR | 100 | 100 | 83 | 83
2011-12-14 00:00:00 | FRA | 96 | 96 | 95 | 92
2011-12-14 00:00:00 | MUC | 58 | 80 | 38 | 25
2011-12-14 00:00:00 | STR | 100 | 100 | 100 | 100
2011-12-14 00:00:00 | ANR | 100 | 100 | 100 | 100
2011-12-15 00:00:00 | FRA | 96 | 96 | 95 | 92
2011-12-15 00:00:00 | MUC | 58 | 78 | 30 | 20
2011-12-15 00:00:00 | STR | 86 | 100 | 100 | 100
2011-12-15 00:00:00 | ANR | 100 | 86 | 100 | 100
2011-12-16 00:00:00 | FRA | 98 | 96 | 95 | 94
2011-12-16 00:00:00 | MUC | 49 | 67 | 30 | 20
2011-12-16 00:00:00 | STR | 86 | 100 | 100 | 100
2011-12-16 00:00:00 | ANR | 100 | 100 | 100 | 100
2011-12-19 00:00:00 | FRA | 95 | 98 | 96 | 97
2011-12-19 00:00:00 | MUC | 46 | 67 | 30 | 20
2011-12-19 00:00:00 | STR | 100 | 100 | 100 | 100
2011-12-19 00:00:00 | ANR | 100 | 100 | 100 | 100
Spreadsheet: 51219d4e-c647-484b-a828-52c6a7334fee
Sheet: Sheet1

# | [NAME] | [NAME] | min. | sec. | 2b s. | 2b ú. | 3b s. | 3b ú. | TH s. | TH ú. | DU | DO | DC | Bl | As | M+ | M- | F+ | F- | Val | b.
4 | [NAME] | Dušan | 17 | 37 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 3
5 | Bratčenkov | Vojtěch | 15 | 58 | 2 | 2 | 4 | 1 | 0 | 0 | 2 | 1 | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 6 | 7
7 | [NAME] | Travis | 18 | 42 | 3 | 1 | 2 | 0 | 2 | 1 | 1 | 3 | 4 | 0 | 0 | 0 | 1 | 2 | 2 | 1 | 3
8 | Cadri-Nicholson | Bertengeh | 14 | 25 | 3 | 2 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 0 | 0 | 0 | 1 | 0 | 1 | 4 | 4
9 | Švrdlík | Kamil | 16 | 27 | 7 | 4 | 0 | 0 | 2 | 1 | 2 | 2 | 4 | 0 | 1 | 0 | 0 | 3 | 4 | 9 | 9
10 | Slezák | Pavel | 20 | 29 | 4 | 2 | 3 | 1 | 6 | 5 | 0 | 0 | 0 | 0 | 3 | 0 | 2 | 3 | 2 | 9 | 12
11 | Bohačík | Jaromír | 24 | 1 | 6 | 6 | 1 | 0 | 3 | 3 | 3 | 3 | 6 | 0 | 0 | 0 | 1 | 4 | 2 | 21 | 15
12 | Smith | [NAME] | 25 | 8 | 6 | 6 | 3 | 1 | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 2 | 5 | 1 | 21 | 17
13 | Eitutavičius | Arvidas | 19 | 50 | 2 | 2 | 5 | 4 | 6 | 6 | 1 | 1 | 2 | 0 | 1 | 0 | 5 | 4 | 0 | 23 | 22
14 | Prášil | [NAME] | 20 | 17 | 7 | 3 | 2 | 1 | 0 | 0 | 0 | 5 | 5 | 0 | 2 | 0 | 0 | 0 | 4 | 7 | 9
15 | Pelikán | [NAME] | 7 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0
 |  |  | 40 | 0 | 41 | 28 | 22 | 9 | 21 | 18 | 10 | 25 | 35 | 0 | 9 | 0 | 14 | 21 | 19 | 104 | 101
 |  |  |  |  | 68% |  | 41% |  | 86%
Spreadsheet: 190990d1351870469-merging-2-databases-map6
Sheet: Blad3

Ticker | CompName | datadate | fyear | gvkey | AT | EBITDA | SEQ | mkvalt | GIND | numblks | firm_id
AZA.1 | ALZA CORP | 19951231 | 1995 | 1359 | 937215 | 131683 | 454553 |  | 352020
AZA.1 | ALZA CORP | 19961231 | 1996 | 1359 | 1613.7 | 152.6 | 596.7 |  | 352020 | 2 | 4760
AZA.1 | ALZA CORP | 19971231 | 1997 | 1359 | 1369.2 | 189.5 | 301.2 |  | 352020 | 3 | 4761
AZA.1 | ALZA CORP | 19981231 | 1998 | 1359 | 1576.3 | 229.3 | 455.2 | 4561425 | 352020 | 3 | 4762
AZA.1 | ALZA CORP | 19991231 | 1999 | 1359 | 1852.5 | 229.9 | 691.8 | 3538675 | 352020 | 6 | 4763
AZA.1 | ALZA CORP | 20001231 | 2000 | 1359 | 2921.6 | 305 | 1563.4 | 10093.75 | 352020 | 2 | 4764
Spreadsheet: 108388d1305441711-if-a-cell-in-a-column-in-any-worksheet-x-copy-entire-row-budget_update
Sheet: DISC

Date | Location | Memo | Method | Amount
2011-05-10 00:00:00 | Smiths |  | DISC | 25
2011-05-11 00:00:00 | Dans |  | DISC | 35
2011-05-06 00:00:00 | Chevron |  | DISC | 12
2011-04-29 00:00:00 | Walmart |  | DISC | 10.22
2011-04-30 00:00:00 | Shopko |  | DISC | 3.49
2011-05-02 00:00:00 | Target |  | DISC | 59.88
2011-05-02 00:00:00 | Walmart |  | DISC | 4.93
2011-05-03 00:00:00 | Rite Aid |  | DISC | 3.2
2011-05-07 00:00:00 | Wahlgreens |  | DISC | 9.33
2011-05-02 00:00:00 | Cinemark |  | DISC | 15
2011-05-08 00:00:00 | Texas Roadhouse |  | DISC | 54.9
Spreadsheet: 700258d1603102536-indexing-and-matching-across-sheets-sample
Sheet: Sheet1

Date | LSOA | Ward
2017-08-01 00:00:00 | Portsmouth 001A
2017-08-01 00:00:00 | Portsmouth 001A
2017-08-01 00:00:00 | Portsmouth 001A
2017-08-01 00:00:00 | Portsmouth 001A
2017-08-01 00:00:00 | Portsmouth 001A
2017-08-01 00:00:00 | Portsmouth 001B
2017-08-01 00:00:00 | Portsmouth 001B
2017-08-01 00:00:00 | Portsmouth 001C
2017-08-01 00:00:00 | Portsmouth 001C
2017-08-01 00:00:00 | Portsmouth 001C
2017-08-01 00:00:00 | Portsmouth 001D
2017-08-01 00:00:00 | Portsmouth 001D
2017-08-01 00:00:00 | Portsmouth 001D
2017-08-01 00:00:00 | Portsmouth 001D
2017-08-01 00:00:00 | Portsmouth 001D
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 001E
2017-08-01 00:00:00 | Portsmouth 002A
2017-08-01 00:00:00 | Portsmouth 002A
2017-08-01 00:00:00 | Portsmouth 002A
2017-08-01 00:00:00 | Portsmouth 002A
2017-08-01 00:00:00 | Portsmouth 002A
Spreadsheet: 862014d1709818039-reverse-calculation-retirment-calculator-excel
Sheet: Investments

 |  | Amounts ($)
Year | Age | Total savings | Non- registered | Non- registered | Non- registered | TFSA | TFSA | RRSP |  | RRSP
 |  |  |  | contributions | Taxable amount |  | Contributions |  | Contributions
2023 | 58 |  |  |  |  |  | 0 |  |  | 288000
2024 | 59 |  |  |  |  |  | 6500 |  |  | 225792
2025 | 60 |  |  |  |  |  | 7000 |  |  | 161468.928
2026 | 61 |  |  |  |  |  | 7000 |  |  | 94458.87155200003
2027 | 62 |  |  |  |  |  | 7000 |  |  | 97670.47318476802
2028 | 63 |  |  |  |  |  | 7500 |  |  | 100991.2692730501
2029 | 64 |  |  |  |  |  | 7500 |  |  | 104424.9724283338
2030 | 65 |  |  |  |  |  | 7500 |  |  | 107975.4214908972
2031 | 66 |  |  |  |  |  | 7500 |  |  | 111646.5858215877
2032 | 67 |  |  |  |  |  | 8000 |  |  | 115442.5697395217
2033 | 68 |  |  |  |  |  | 8000 |  |  | 119367.6171106654
2034 | 69 |  |  |  |  |  | 8000 |  |  | 123426.116092428
2035 | 70 |  |  |  |  |  | 8500 |  |  | 127622.6040395706
2036 | 71 |  |  |  |  |  | 8500 |  |  | 131961.772576916
2037 | 72 |  |  |  |  |  | 9000 |  |  | 136448.4728445311
2038 | 73 |  |  |  |  |  | 9000 |  |  | 141087.7209212452
2039 | 74 |  |  |  |  |  | 9000 |  |  | 145884.7034325675
2040 | 75 |  |  |  |  |  | 9500 |  |  | 150844.7833492748
2041 | 76 |  |  |  |  |  | 9500 |  |  | 155973.5059831502
2042 | 77 |  |  |  |  |  | 9500 |  |  | 161276.6051865773
2043 | 78 |  |  |  |  |  | 10000 |  |  | 166760.0097629209
2044 | 79 |  |  |  |  |  | 10000 |  |  | 172429.8500948602
2045 | 80 |  |  |  |  |  | 10500 |  |  | 178292.4649980855
2046 | 81 |  |  |  |  |  | 10500 |  |  | 184354.4088080204
2047 | 82 |  |  |  |  |  | 11000 |  |  | 190622.458707493
2048 | 83 |  |  |  |  |  | 11000 |  |  | 197103.6223035478
2049 | 84 |  |  |  |  |  | 11000 |  |  | 203805.1454618684
2050 | 85 |  |  |  |  |  | 11500 |  |  | 210734.520407572
2051 | 86 |  |  |  |  |  | 11500 |  |  | 217899.4941014294
2052 | 87 |  |  |  |  |  | 12000 |  |  | 225308.076900878
2053 | 88 |  |  |  |  |  | 12000 |  |  | 232968.5515155078
2054 | 89 |  |  |  |  |  | 12500 |  |  | 240889.4822670351
2055 | 90 |  |  |  |  |  | 12500 |  |  | 249079.7246641143
2056 | 91 |  |  |  |  |  | 12500 |  |  | 257548.4353026942
2057 | 92 |  |  |  |  |  | 12500 |  |  | 266305.0821029858
2058 | 93 |  |  |  |  |  | 12500 |  |  | 275359.4548944873
2059 | 94 |  |  |  |  |  | 12500 |  |  | 284721.6763608999
Spreadsheet: 744141d1629009548-lunch-time-dilemma-schedule-wokfire-ans
Sheet: Sheet1

Week | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Baja | sunday off
Day | MON |  |  | TUE |  |  | WED |  |  | THU |  |  | FRI |  |  | SAT |  |  | SUN |  |  | Total Sales |  | Joel | monday off
Date | 2021-08-16 00:00:00 |  |  | 2021-08-17 00:00:00 |  |  | 2021-08-18 00:00:00 |  |  | 2021-08-19 00:00:00 |  |  | 2021-08-20 00:00:00 |  |  | 2021-08-21 00:00:00 |  |  | 2021-08-22 00:00:00 |  |  |  |  | Staff-1 | Flexible
SALES TARGET | 1000 |  |  | 1000 |  |  | 1200 |  |  | 1500 |  |  | 1500 |  |  | 1500 |  |  | 1000 |  |  |  |  | Staff-2 | Flexible
TEAM MEMBERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Tuesday and Thursday
 | 0 | 0 |  | 0 | 0 |  | 09:00:00 | 17:00:00 |  | 10:00:00 | 23:30:00 |  | 10:30:00 | 23:30:00 |  | 10:30:00 | 23:30:00 |  | 12:00:00 | 18:00:00 |  |  |  | Shariful | Flexible
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | all week off
Daniella | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 10:30:00 | 23:30:00 |  | 11:00:00 | 23:30:00 |  | 0 | 0 |  | 0 | 0 |  |  |  | [NAME] | only lunch cover
Joel | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 11:30:00 | 23:30:00 |  | 11:30:00 | 23:30:00 |  |  |  | Breaktime Formula
Shariful | 0 | 0 |  | 09:30:00 | 14:30:00 |  | 09:30:00 | 14:30:00 |  | 09:30:00 | 14:30:00 |  | 09:30:00 | 14:30:00 |  | 09:30:00 | 14:30:00 |  | 0 | 0
 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 10:00:00 | 21:00:00 |  | 10:30:00 | 12:30:00 |  | 10:30:00 | 12:30:00 |  | 0 | 0
 | 09:00:00 | 18:00:00 |  | 09:00:00 | 18:00:00 |  | 09:00:00 | 18:00:00 |  | 09:00:00 | 18:00:00 |  | 09:00:00 | 18:00:00 |  | 09:00:00 | 18:00:00 |  | 0 | 0
 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
DIANA | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 11:30:00 | 14:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Staff-1 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Staff-2 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Staff-3 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
TOTAL  HOURS
BREAK : Unpaid. |  |  |  |  |  |  |  |  |  |  |  |  | Meal Policy
<8hrs=30min break |  |  |  |  |  |  |  |  |  |  |  |  | 1 - 4 Hours shift: 1 Drink
>8hrs=1 hour break |  |  |  |  |  |  |  |  |  |  |  |  | 5 - 8 Hours shift: 1 Drink and 1 Meal
 |  |  |  |  |  |  |  |  |  |  |  |  | >8 Hours Shift: 2 Drinks and 2 Meals
NO PHONES ALLOWED DURING THE SHIFT!!!
Spreadsheet: 330005d1404479885-hlookup-and-match-example1
Sheet: Sheet1

[NAME] |  |  |  |  | [NAME] |  |  |  | [NAME]
1953-04-02 00:00:00 | [NAME] | 2 |  | 1951-01-01 00:00:00 | Fred |  |  | 1957-01-01 00:00:00 | Alfred
1958-07-04 00:00:00 | [NAME] | 3 |  | 1953-04-02 00:00:00 | [NAME] |  |  | 1958-07-01 00:00:00 | [NAME]
1960-01-01 00:00:00 | [NAME] |  |  | 1957-02-03 00:00:00 | [NAME] |  |  | 1958-07-04 00:00:00 | [NAME]
1962-04-08 00:00:00 | [NAME] | 4 |  | 1962-04-08 00:00:00 | [NAME] |  |  | 1965-02-03 00:00:00 | [NAME]
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Credit

 | Credit
 | 2002 Plan
 |  |  |  |  |  |  |  | Credit
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation | 0 |  | 2625993
 | Special Pays | 0 |  |  |  | 0 |  | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes | 0
ENAEMPEX | Employee Expense | 115211.17 |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense | 158715.86
ENAOUTSV | Outside Services | 0 |  |  |  |  |  | Total
ENASUPP | Supplies Expense | 28163.05
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 36000 | 0
ENARENT | Rent | 1844.33 |  |  |  |  |  | Admins | 49200 | 1
 |  |  |  |  |  |  |  | Exec. [NAME]. | 63600 | 0
ENATECH | Technology | 29491.73 |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 1
ENAOTHEX | Other Expenses | 2056.67 |  |  |  |  |  | Specialist | 66000 | 1
ENATAXES | Taxes Other than Income | 0 |  |  |  |  |  | Sr Specialist | 84000 | 2
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Managers | 105600 | 5
 |  |  |  |  |  |  |  | Directors | 156000 | 2
 | Headcount |  |  | 58 |  |  |  | Sr Director | 184800 | 2 |  |  |  | 1
 |  |  |  |  |  |  |  | Vice President | 210000 | 1
 | A&A Headcount |  |  | 0 |  |  |  | EVP/CRO | 476400 | 0 |  |  |  | 1
 | Total Headcount
 |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent |  |  |  |  |  | Other Expense Calculation
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 722322d1615198943-index-formula-to-disregard-the-name-of-column-copy-of-parental-leave_example
Sheet: Sheet1

 | Maternity | Maternity | Vacation | Vacation | Parents' leave | Parents' leave
PersonalNumber | Start | End | From | To | Start | End | Note
ABCD | 2014-03-13 00:00:00 | 2014-09-24 00:00:00 | 2014-09-25 00:00:00 | 2014-10-15 00:00:00 |  |  | Maternity leave
ABCD | 2014-10-16 00:00:00 | 2016-09-30 00:00:00 |  |  |  |  | Parents' leave
KLMN | 2015-06-27 00:00:00 | 2016-03-31 00:00:00 |  |  |  |  | Parents' leave
YVFRT | 2010-06-09 00:00:00 | 2010-12-21 00:00:00 | 2010-12-22 00:00:00 | 2011-01-16 00:00:00 |  |  | Maternity leave
YVFRT | 2011-01-17 00:00:00 | 2011-03-31 00:00:00 |  |  |  |  | Parents' leave
YVFRT | 2013-04-01 00:00:00 | 2013-09-28 00:00:00 | 2013-09-29 00:00:00 | 2013-11-01 00:00:00 |  |  | Maternity leave
YVFRT | 2013-11-02 00:00:00 | 2014-02-28 00:00:00 |  |  |  |  | Parents' leave
YVFRT | 2014-09-29 00:00:00 | 2015-04-12 00:00:00 |  |  |  |  | Maternity leave
Spreadsheet: 770789d1646250597-calculate-days-from-vendor-proposed-dates-to-actual-delivery-date-color-coded-past-due-dates-material-assessment
Sheet: Hamilton Sundstrom

 |  |  |  |  |  |  |  | Program |  |  | Inclusion Criteria |  |  |  | Exclusion Criteria | Wave V Overall and Attribute Scores
Supplier | Part Name | Part Number | Module | Hull # Boat | Arrvl to SDD | City | State | VCS | CLB | Component/ Material/ Service | 2017 Overall Readiness Score | 2018 Overall Readiness Score | 2019 Overall Readiness Score | 2020 Overall Readiness Score | Notes | 2021 Overall Readiness Score | Business Stability | Human Resource Capacity | Supply Chain | Production/Facilities/Capability | Schedule | Supplier Quality
[NAME] | AILPE | EB-4022-1B | AMR | 797 | 0.2956878850102669 | Windsor Locks | CT | a | a | Advanced Integrated Low Pressure [NAME], ECG | G | G | G | G |  | G | G | G | G | G | Y | G
 | AILPE | EB-4022-1B | AMR | 798 | 3.975359342915811
 | AILPE | EB-4022-1B | AMR | 799 | 3.219712525667351
 | AILPE | EB-4022-1B | AMR | 800 | 2.595482546201232
 | AILPE | EB-4022-1B | AMR | 801 | -1.117043121149897
 | AILPE | EB-4022-1B | AMR | 802 | -9.067761806981519
 | AILPE | EB-4022-1B | AMR | 803 | 4.6652977412731
 | AILPE | EB-4022-1B | AMR | 804 | -21.84804928131417
 | AILPE | EB-4022-1B | AMR | 805 | -20.92813141683778
 | AILPE | EB-4022-1B | AMR | 806 | -19.87679671457905
 | AILPE | EB-4022-1B | AMR | 807 | -19.08829568788501
 | AILPE | EB-4022-1B | AMR | 808 | -14.81724845995893
 | AILPE | EB-4022-1B | AMR | 809 | -13.79876796714579
 | AILPE | EB-4022-1B | AMR | 810 | -16.16427104722793
 | AILPE | EB-4022-1B | AMR | 811 | -15.37577002053388