tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 605761d1547251528-populate-name-vacation-date-information-into-calendar-format-in-separate-tab-leave-planner-template-v2
Sheet: December

Legend:
b | = bereavement
o | = other day off |  | o.5 | = half other day off
v | = paid vacation |  | v.5 | = half paid vacation
s | = sick day |  | s.5 | = half sick day
u | = unpaid day off |  | u.5 | = half unpaid day off
x | = present
st | = statutory holiday
 | Summary of Leave Taken This Month
Employee Name | Vacation | Sick | Unpaid | Bereavement | Statutory | Other | 2018-12-01 00:00:00 | 2018-12-02 00:00:00 | 2018-12-03 00:00:00 | 2018-12-04 00:00:00 | 2018-12-05 00:00:00 | 2018-12-06 00:00:00 | 2018-12-07 00:00:00 | 2018-12-08 00:00:00 | 2018-12-09 00:00:00 | 2018-12-10 00:00:00 | 2018-12-11 00:00:00 | 2018-12-12 00:00:00 | 2018-12-13 00:00:00 | 2018-12-14 00:00:00 | 2018-12-15 00:00:00 | 2018-12-16 00:00:00 | 2018-12-17 00:00:00 | 2018-12-18 00:00:00 | 2018-12-19 00:00:00 | 2018-12-20 00:00:00 | 2018-12-21 00:00:00 | 2018-12-22 00:00:00 | 2018-12-23 00:00:00 | 2018-12-24 00:00:00 | 2018-12-25 00:00:00 | 2018-12-26 00:00:00 | 2018-12-27 00:00:00 | 2018-12-28 00:00:00 | 2018-12-29 00:00:00 | 2018-12-30 00:00:00 | 2018-12-31 00:00:00 | # of Days Worked | # of Week Days | Days in Lieu Earned
Spreadsheet: 695137d1600072118-set-kpi-for-my-import-and-export-shipment-tracker-kpi-1-1-
Sheet: Sheet1

Sl. No. | Job No. | Customer | Import/Export | Mode of Shipment | Country | Order confirmation date | BRN/ Cntr release from port | Vessel Departure Date | Vessel [NAME] date | Documents sent to WSS | Check (ED) | ED received from WSS | [NAME] to Port | BL from Liner | Docs uploaded in V-motion | Invoiced Date | No. of Units Damaged | Remarks/ Comments | STATUS
1 |  | AMS | EXPORT | SEA | MOM/DAR/DUR | 2020-08-25 00:00:00 | 2020-08-31 00:00:00 | 2020-09-16 00:00:00 | - | 2020-09-18 00:00:00 |  | 2020-09-03 00:00:00 | 2020-09-03 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-14 00:00:00 |  |  | Completed
2 |  | AMS | IMPORT | SEA | JAPAN | NA | NA | 2020-09-14 00:00:00 | 2020-08-28 00:00:00 | 2020-08-24 00:00:00 |  | 2020-08-31 00:00:00 | 2020-09-05 00:00:00 | NA | 2020-09-14 00:00:00 | 2020-09-14 00:00:00 |  |  | Completed
3
Spreadsheet: 77520d1277982145-countif-with-multiple-criteria-function-analysisdomespec-2-
Sheet: Sheet1

 |  |  |  |  |  |  | Spec (mm)
Dome | Spec |  |  |  |  |  | 95 | 100 | 105 | 110 | 115 | 120 | 125 | 130
(kg) | ([NAME])
1.73 | 105 |  |  | Dome (kg) | 1 | 1.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.76 | 105 |  |  |  | 1.25 | 1.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.775 | 105 |  |  |  | 1.5 | 1.75 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
1.785 | 110 |  |  |  | 1.75 | 2 | 1 | 1 | 6 | 1 | 0 | 2 | 0 | 0
1.835 | 95 |  |  |  | 2 | 2.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.84 | 120 |  |  |  | 2.25 | 2.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.88 | 105 |  |  |  | 2.5 | 2.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1.88 | 100
1.9 | 120
1.915 | 105
1.87 | 105
1.79 | 105
Spreadsheet: 758750d1639052972-how-to-vlookup-then-multiply-book7
Sheet: Sheet1

Date | Internal IDs | Qty to pack |  | Weight per IDs |  | Customer ID | [NAME] | Box ID | Total ID weight + Box weight | Total box weight | Weight per Box
2021-12-17 00:00:00 | 13280-14417 | 200 |  | 2.3 |  | 23331914 | 1 | 73120 | 459.9999999999999 |  | 489.9999999999999
 |  |  |  |  |  |  |  |  | 30 | 489.9999999999999
2021-12-17 00:00:00 | 13336-14417 | 120 |  | 0.421 |  | 84118091 | 2 | 73019 | 50.52
 |  |  |  |  |  |  |  |  | 100
2021-12-17 00:00:00 | 13337-14417 | 180 |  | 0.7504 |  | 23209911 | 6 | 73094 | 135.072
2021-12-17 00:00:00 | 13338-14417 | 180 |  | 0.7504 |  | 23209912 | 6 | 73019 | 135.072
2021-12-17 00:00:00 | 13339-14417 | 180 |  | 0.4638 |  | 23209913 | 6 | 73084 | 83.484
2021-12-17 00:00:00 | 13344-14417 | 80 |  | 0.392 |  | 13439714 | 2 | 73084 | 31.36
2021-12-17 00:00:00 | 13308-14417 | 100 |  | 0.444 |  | 23506767 | 2 | 73085 | 44.4
2021-12-17 00:00:00 | 13341-14417 | 90 |  | 0.607 |  | 39016190 | 2 | 73026 | 54.63
Spreadsheet: 855864d1705337437-list-by-highest-including-joint-highest-ranking
Sheet: Sheet2

Team | Rank | Name | Dec
101 | 3 | [NAME] | 105
102 | 1 | Vicky | 109
102 | 3 | [NAME] | 109
103 | 1 | [NAME] | 90
104 | 1 | [NAME] | 116
105 | 4 | [NAME] | 123
106 | 1 | [NAME] | 121
106 | 2 | Asha | 121
Spreadsheet: 101754d1299798121-calculate-based-on-multiple-criteria-bs-cap-analysis
Sheet: Factors

Age |  | Male Factor |  | Female Factor |  | Plans | [NAME] |  | Financial Responsibility
0 | M | 1.8 | F | 1.8 |  | HZU | 74.1 |  | 1.43
1 | M | 0.5 | F | 0.5 |  | [NAME] | 51.89
2 | M | 0.5 | F | 0.5 |  | H4V | 71.21
3 | M | 0.5 | F | 0.5 |  | HZY | 69.36
4 | M | 0.5 | F | 0.5 |  | H3Z | 90.09
5 | M | 0.46 | F | 0.47 |  | D85 | 46.36
6 | M | 0.46 | F | 0.47 |  | H3Z | 90.09
7 | M | 0.46 | F | 0.47 |  | D85 | 46.36
8 | M | 0.46 | F | 0.47 |  | DAR | 46.18
9 | M | 0.46 | F | 0.47 |  | RAH | 70.67
10 | M | 0.46 | F | 0.47 |  | H4U | 77.65
11 | M | 0.46 | F | 0.47 |  | H5F | 67.22
12 | M | 0.46 | F | 0.47 |  | PEA | 54.99
13 | M | 0.46 | F | 0.47 |  | HBM | 84.2
14 | M | 0.46 | F | 0.47 |  | H4F | 73.09
15 | M | 0.55 | F | 0.77 |  | HDB | 83.66
16 | M | 0.55 | F | 0.77 |  | HYF | 66.94
17 | M | 0.55 | F | 0.77 |  | PGB | 48.27
18 | M | 0.55 | F | 0.77 |  | H10 | 80.12
19 | M | 0.55 | F | 0.77 |  | PBP | 53.02
20 | M | 0.5 | F | 1.01 |  | H3Z | 90.09
21 | M | 0.5 | F | 1.01 |  | HDB | 83.66
22 | M | 0.5 | F | 1.01 |  | H3Z | 90.09
23 | M | 0.5 | F | 1.01 |  | H2E | 81.04
24 | M | 0.5 | F | 1.01
25 | M | 0.59 | F | 1.28
26 | M | 0.59 | F | 1.28
27 | M | 0.59 | F | 1.28
28 | M | 0.59 | F | 1.28
29 | M | 0.59 | F | 1.28
30 | M | 0.68 | F | 1.45
31 | M | 0.68 | F | 1.45
32 | M | 0.68 | F | 1.45
33 | M | 0.68 | F | 1.45
34 | M | 0.68 | F | 1.45
35 | M | 0.78 | F | 1.46
36 | M | 0.78 | F | 1.46
37 | M | 0.78 | F | 1.46
38 | M | 0.78 | F | 1.46
39 | M | 0.78 | F | 1.46
40 | M | 0.9 | F | 1.49
41 | M | 0.9 | F | 1.49
42 | M | 0.9 | F | 1.49
43 | M | 0.9 | F | 1.49
44 | M | 0.9 | F | 1.49
45 | M | 1.05 | F | 1.58
46 | M | 1.05 | F | 1.58
47 | M | 1.05 | F | 1.58
48 | M | 1.05 | F | 1.58
49 | M | 1.05 | F | 1.58
50 | M | 1.25 | F | 1.69
51 | M | 1.25 | F | 1.69
52 | M | 1.25 | F | 1.69
53 | M | 1.25 | F | 1.69
54 | M | 1.25 | F | 1.69
55 | M | 1.61 | F | 1.84
56 | M | 1.61 | F | 1.84
57 | M | 1.61 | F | 1.84
58 | M | 1.61 | F | 1.84
59 | M | 1.61 | F | 1.84
60 | M | 2.05 | F | 2.07
61 | M | 2.05 | F | 2.07
62 | M | 2.05 | F | 2.07
63 | M | 2.05 | F | 2.07
64 | M | 2.05 | F | 2.07
65 | M | 2.28 | F | 2.22
Spreadsheet: 755892d1637165799-help-wedding-planner-macbride-wedding-rev1-mcknze21-
Sheet: Totals

Total Invited |  | 1
Total Accepted RSVP's
Day Invitations
Accepted Day RSVP's
Evening Invitations
Accepted Evening RSVP's
Declined [NAME]'s
Total Bus
Day Bus
Evening Bus
Waiting on Day RSVP's
Waiting on Evening RSVP's
Thank You Cards
Spreadsheet: 231472d1367083982-using-excel-for-home-based-symptoms-diary-wheeze-diary_pvt
Sheet: Sheet4

 | Data
Date | Count of [NAME], nose block,[NAME] leak | Count of Night cough | Count of Activity induced cough | Count of Wheeze Night | Count of Wheeze: day
2013-04-27 00:00:00 | 1 | 1 | 1 | 1 | 1
2013-04-28 00:00:00 |  |  | 1 | 1 | 1
(blank)
Grand Total | 1 | 1 | 2 | 2 | 2
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: AF Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 10-01) 12-10-2017 | pdf |  | 01-01) 08-01-2019 | pdf |  | 08-01) 07-08-2019 | pdf |  | 05-01) 22-05-2019 | pdf |  | 07-01) 08-07-2019 | pdf
 | 11-01) 16-11-2017 | pdf |  | 03-01) 13-03-2019 | pdf |  | 09-01) 09-09-2019 | pdf |  | 07-01) 24-07-2019 | pdf |  | 07-02) 22-07-2019 | pdf
 | 12-01) 06-12-2017 | pdf |  | 06-01) 20-06-2019 | pdf |  | 09-02) 11-09-2019 | pdf |  | 08-01) 27-08-2019 | pdf |  | 08-01) 26-08-2019 | pdf
 | 12-02) 18-12-2017 | pdf |  | 07-01) 17-07-2019 | pdf |  | 10-01) 23-10-2019 | pdf |  | 09-01) 11-09-2019 | pdf |  | 09-01) 19-09-2019 | pdf
 | 01-01) 09-01-2019 | pdf |  | 08-01) 07-08-2019 | pdf |  | 12-01) 19-12-2019 | pdf |  | 09-02) 12-09-2019 | pdf |  | 10-01) 20-10-2019 | pdf
 | 02-01) 04-02-2019 | pdf |  | 08-02) 27-08-2019 | pdf |  | 02-01) 20-02-2020 | pdf |  | 10-01) 23-10-2019 | pdf |  | 03-01) 11-03-2020 | pdf
 | 03-01) 18-03-2019 | pdf |  | 09-01) 08-09-2019 | pdf |  | 03-01) 05-03-2020 | pdf |  | 12-01) 19-12-2019 | pdf
 | 03-01) 26-03-2019 | pdf |  | 09-02) 11-09-2019 | pdf |  |  |  |  | 02-01) 13-02-2020 | pdf
 | 08-01) 27-08-2019 | pdf |  | 10-01) 20-10-2019 | pdf |  |  |  |  | 03-01) 05-03-2020 | pdf
 | 09-01) 23-09-2019 | pdf |  | 10-02) 31-10-2019 | pdf
 | 10-01) 22-10-2019 | pdf |  | 12-01) 18-12-2019 | pdf
 | 10-02) 31-10-2019 | pdf |  | 03-01) 18-03-2020 | pdf
 | 11-01) 21-11-2019 | pdf
 | 12-01) 26-12-2019 | pdf
 | 01-01) 30-01-2020 | pdf
 | 03-01) 18-03-2020 | pdf
 | 04-01) 22-04-2020 | pdf
 | 05-01) 13-05-2020 | pdf
Spreadsheet: 218403d1362444568-return-the-unique-data-from-a-list-unique-example
Sheet: BHA DB

Job Numer | BHA # | [NAME] | Motor Serial | [NAME] | Stage | Bit Manufacture | Bit Type | [NAME] | Depth In | Depth Out | Drilling Hours | Circulating Hours | Motor Incident | MWD Incident
 | 1
 | 2 | 311
 | 3 | 222
 | 4 | 156
 | 5 | 156
 | 6 | 156
 | 7
 | 8
 | 9
 | 10
 | Total
Spreadsheet: 184293d1349203576-list-data-from-cells-in-a-single-table-row-into-a-multi-column-and-multi-row-range-example_verydetailedexplainations
Sheet: Sheet that needs autofill Skip

 | Ingredient | Quantity | UOM |  | Ingredient | Quantity | UOM |  | Ingredient | Quantity | UOM
 | Potatoe | 2 | Per | ---> | WILL MAKE THEIR WAY OVER HERE |  |  | ---> | WILL MAKE THEIR WAY OVER HERE
 | Roast Beef | 2 | Lbs
 | Gravy | 1 | Pint
 |  |  | SOME RECIPES WILL HAVE INGREDIENTS THAT | --- | -----------> |  | SOME RECIPES WILL HAVE INGREDIENTS THAT | --- | -----------> | etc…
 | Ingredient | Quantity | UOM |  | Ingredient | Quantity | UOM |  | Ingredient | Quantity | UOM
 | [NAME] | Data 2 Ab | Data 2 Ac | ---> | WILL MAKE THEIR WAY OVER HERE |  |  | ---> | WILL MAKE THEIR WAY OVER HERE
 | Chicken | Data 2 Bb | Data 2 Bc
 | Data 2 Ca | Data 2 Cb | Data 2 Cc
 |  |  | SOME RECIPES WILL HAVE INGREDIENTS THAT | --- | -----------> |  | SOME RECIPES WILL HAVE INGREDIENTS THAT | --- | -----------> | etc…
 | Ingredient | Quantity | UOM |  | Ingredient | Quantity | UOM |  | Ingredient | Quantity | UOM
 | Lettuce | Data 3 Ab | Data 3 Ac | ---> | WILL MAKE THEIR WAY OVER HERE |  |  | ---> | WILL MAKE THEIR WAY OVER HERE
 | Data 3 Ba | Data 3 Bb | Data 3 Bc
 | Data 3 Ca | Data 3 Cb | Data 3 Cc
 |  |  | SOME RECIPES WILL HAVE INGREDIENTS THAT | --- | -----------> |  | SOME RECIPES WILL HAVE INGREDIENTS THAT | --- | -----------> | etc…
etc… | etc…. | etc…. | etc…. |  | etc…. | etc…. | etc…. |  | etc…. | etc…. | etc….
Do Not Concern Yourself With This Column's Formula |  | I need the data in the Red Boxes to have a formula that when you drag the AutoFill it will return the data as it is portrayed.
 |  | I already have a formula, thatnks to user simarui, for the column with the "Name #" entries and tried to play around with it for the other columns I need on this page; however I have been unsuccessful at every turn with all the ideas I have tried to impliment.
Spreadsheet: 25386d1216679668-vlookup-in-a-range-nominal-dollar-amounts-bond-portfolio-sample-1
Sheet: Sheet1

% of [NAME] expiring in
0 - 365 days | 0.3207547169811321 | <= I want to change the formulas in B3:B6 so they update automatically as time goes by
366 - 1460 days | 0.1509433962264151
1461 - 3285 days | 0.1886792452830189
3286 - 4745 days | 0.3396226415094339
sum | 1
Instrument | Value | Expiration | Days until expiration | Weight of Portolio
BondA | 1000 | 2008-12-31 00:00:00 | 163 | 0.03773584905660377
BondB | 3500 | 2009-05-07 00:00:00 | 290 | 0.1320754716981132
BondC | 4000 | 2010-05-09 00:00:00 | 657 | 0.1509433962264151
BondD | 9000 | 2020-12-08 00:00:00 | 4523 | 0.3396226415094339
BondE | 5000 | 2014-09-09 00:00:00 | 2241 | 0.1886792452830189
BondF | 1800 | 2008-08-08 00:00:00 | 18 | 0.06792452830188679
BondG | 2200 | 2008-09-16 00:00:00 | 57 | 0.0830188679245283
total | 26500 |  |  | 1
Spreadsheet: 50029577-a752-42c8-885b-b4a6ffdd3a30
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
WEED4 | Test | WEED4 | Weed Panel # 4 | Weed Panel # 4 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
WEED4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
WEED4 | Result | WEED4 | Weed Panel # 4 | Weed Panel # 4 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 134653d1325545611-extract-login-and-logut-data-from-one-worksheet-to-another-index
Sheet: Admin

Employee Name | POSITION
[NAME] | TECH
EMPLOYEE2 | TECH
EMPLOYEE3 | TECH
EMPLOYEE4 | RPH
EMPLOYEE5 | RPH
EMPLOYEE6 | TECH
EMPLOYEE7 | TECH
EMPLOYEE8 | TECH
EMPLOYEE9 | RPH
EMPLOYEE10 | RPH
EMPLOYEE11 | TECH | YEAR
EMPLOYEE12 | TECH | 2011
EMPLOYEE13 | RPH | 2012
EMPLOYEE14 | TECH | 2013
EMPLOYEE15 | TECH | 2014 |  | MONTH
EMPLOYEE16 | TECH | 2015 |  | January
EMPLOYEE17 | TECH |  |  | February
EMPLOYEE18 | RPH |  |  | March
EMPLOYEE19 | RPH |  |  | April
EMPLOYEE20 | RPH |  |  | May
 |  |  |  | June
 |  |  |  | July
 |  |  |  | August
 |  |  |  | September
 |  |  |  | October
 |  |  |  | November
 |  |  |  | December
Spreadsheet: 09d70d29-6bcf-48b2-9800-134de89a0636
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 32. LEASE FINANCE COMMITMENTS, By Purpose: State (VIC), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413959X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413960J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413962L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413963R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413964T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413965V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413966W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413967X | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413968A | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413969C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413970L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413971R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413972T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413973V | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413974W | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 141209d1329152257-need-help-setting-up-pivots-to-analize-data-already-entered-2-10-12-excel-sample-worksheet
Sheet: Summary by Item #

Ocean Air Enterprises
Contract # [NAME] (Brooklyn, Queens & Staten Island)
Summary by Building / Item #
September 1, 2011 to October 31, 2011
Building Code | Building Address | Item | Item Description | Quantity | Amount | Total
304 | 120 Schemerhorn Street | 5 | Install Unit |  | 100 | 6300
304 | 120 Schemerhorn Street | 6 | Remove Unit |  | 1 | 51
304 | 120 Schemerhorn Street | 7 | Transport Unit |  | 10 | 1120
304 | 120 Schemerhorn Street | 11 | [NAME] |  | 100 | 5400
304 | 120 Schemerhorn Street | 12 | Steam Clean |  | 25 | 1500
304 | 120 Schemerhorn Street | 13 | Additional Payment - Upper mount. Units |  | 100 | 8800
326 | 345 Adams Street | 11 | [NAME] |  | 100 | 100
415 | 88-11 Sutphin Blvd | 11 | [NAME] |  | 100 | 100
417 | 120-55 Queens Blvd | 5 | Install Unit |  | 100 | 100
417 | 120-55 Queens Blvd | 9 | Cover Unit - Winter |  | 10 | 610
417 | 120-55 Queens Blvd | 11 | [NAME] |  | 100 | 700
417 | 120-55 Queens Blvd | 13 | Additional Payment - Upper mount. Units |  | 100 | 3300
417 | 120-55 Queens Blvd | 17 | Collect BTU & EER Information |  | 1 | 61
418 | 125-01 Queens Blvd | 11 | [NAME] |  | 100 | 100
509 | 100 Richmond Terrace | 5 | Install Unit |  | 100 | 100
509 | 100 Richmond Terrace | 6 | Remove Unit |  | 1 | 1
509 | 100 Richmond Terrace | 7 | Transport Unit |  | 10 | 20
509 | 100 Richmond Terrace | 11 | [NAME] |  | 100 | 500
509 | 100 Richmond Terrace | 13 | Additional Payment - Upper mount. Units |  | 100 | 400
 |  | Ocean Air Enterprises
 |  | Contract # [NAME] (Brooklyn, Queens & Staten Island)
 |  | Summary by Item #
 |  | September 1, 2011 to October 31, 2011
 |  | Item | Item Description | Quantity | Amount | Total
 |  | 5 | Install Unit |  | 1 | 1
 |  | 6 | Remove Unit |  | 1 | 1
 |  | 7 | Transport Unit |  | 1 | 1
 |  | 9 | Cover Unit - Winter |  | 1 | 1
 |  | 11 | [NAME] |  | 1 | 1
 |  | 12 | Steam Clean |  | 1 | 1
 |  | 13 | Additional Payment - Upper mount. Units |  | 1 | 1
 |  | 17 | Collect BTU & EER Information |  | 1 | 1
Spreadsheet: 674714d1587994890-automate-my-hobby-lemoncello-recipe-and-production-sheet-lemmonchello-recipe-for-disaster
Sheet: Test

Recipe | INGREDIENT 1 | INGREDIENT 2 |  |  |  | Spirits | Spirit Volume | Price | FINAL VOL | FINAL QTY
 | Leo sidrunit |  |  |  |  | BATYA
 | heleroh/kollakad suured ja kõvad [NAME] laimid
 | [NAME] veriapelsini
 | Leo sidrunit
 | Leo sidrunit
 | Leo sidrunit
 | laimi Mehhikost, BioMarket
 | Leo sidrunit |  |  |  |  | Smirnoff
 | Leo sidrunit
 | laimi Mehhikost, BioMarket
 | Leo sidrunit
 | Leo sidrunit
 | [NAME] apelsin
 | Leo sidrunit |  |  |  |  | [NAME]
 | öko ingver riiviga viilutatud
 | Leo sidrunit
 | Leo sidrunit
 | To set the Drop Downs |  |  |  |  |  | Use INDEX MATCH to find the relevant data
 | Use Data, Data Validation, 'Allow' List |  |  |  |  |  | that matches your requirements.
 | Source. Navigate to the Column in the [NAME] and |  |  |  |  |  | The $$ sign placement is important.
 | select the range required. |  |  |  |  |  | The IFERROR - occurs when no data is present
 | You can create many drop downs but you can also use
 | The INDEX MATCH to autofill other data
Spreadsheet: 672757d1586987227-payroll-project-for-ytd-payrolefinal
Sheet: Mallory's Time Sheet

 | WAGE | OT RATE | BONUS | SOC SEC | MEDICARE | FEDERAL | STATE | HEALTH | DENTAL | VISION | 401K | VACATION TIME EARNED | VACATION TIME LEFT | SICK TIME EARNED | SICK TIME LEFT
 | 12 | 1.5 | 20 | 0.042 | 0.0145 | 0.2 | 0.0425 | 110 | 40 | 10 | 100 |  |  |  |  | 2019-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-11-17 00:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY |  |  |  | 2019-11-24 00:00:00
2019-11-04 00:00:00 | 09:00:00 | 12:30:00 | 13:30:00 | 17:30:00
2019-11-05 00:00:00 | 08:30:00 | 13:00:00 | 14:30:00 | 18:00:00
2019-11-06 00:00:00 | 17:30:00 | 00:00:00 | 01:00:00 | 03:00:00
2019-11-07 00:00:00 |  |  |  |  | 8
2019-11-08 00:00:00 |  |  |  |  |  | 8
2019-11-09 00:00:00 | 08:30:00 | 12:00:00 | 13:00:00 | 18:00:00
2019-11-10 00:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2019-11-11 00:00:00 | 23:00:00 | 03:00:00 | 04:00:00 | 11:00:00
2019-11-12 00:00:00 |  |  |  |  | 8
2019-11-13 00:00:00 | 08:00:00 | 13:00:00 | 13:30:00 | 18:30:00
2019-11-14 00:00:00 | 17:00:00 | 00:00:00 | 00:30:00 | 03:00:00
2019-11-15 00:00:00 |  |  |  |  |  | 8
2019-11-16 00:00:00
2019-11-17 00:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2019-11-18 00:00:00 | 08:30:00 | 13:00:00 | 13:30:00 | 18:00:00
2019-11-19 00:00:00 |  |  |  |  | 8
2019-11-20 00:00:00 |  |  |  |  | 8
2019-11-21 00:00:00 | 22:00:00 | 02:00:00 | 02:45:00 | 09:00:00
2019-11-22 00:00:00 |  |  |  |  |  | 8
2019-11-23 00:00:00 | 10:00:00 | 14:00:00
2019-11-24 00:00:00