tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f541df44-6462-430f-9a06-645ec1e2ec7b
Sheet: Rate History

Rate History
Fund | Expense per Contact Hour by  Discipline | 1999
1 | Agriculture
2 | Architecture and Precision Production Trades
3 | Biology, Physical Sciences, and Science Technology
4 | Business Management, Marketing, and Administrative Services
5 | Career Pilot
6 | Communications
7 | Computer and Information Sciences
8 | Construction Trades
9 | Consumer and Homemaking Education
10 | Engineering
11 | Engineering Related
12 | English Language, Lit, Philosophy, Humanities, & Interdisciplinary
13 | Foreign Languages
14 | Health Occupations - Dental Assistants, Medical Lab, and [NAME]. Degree Nursing
15 | Health Occupations - Dental Hygiene
16 | Health Occupations - Other
17 | Health Occupations - Respiratory Therapy
18 | Health Occupations - Vocational Nursing
19 | Mathematics
20 | Mechanics and Repairers - Automotive
21 | Mechanics and Repairers - Diesel, Aviation Mechanics, and Transportation Workers
22 | Mechanics and Repairers - Electronics
23 | Physical Education and Fitness
24 | Protective Services and Public Administration
25 | Psychology, Social Sciences, and History
26 | Visual and Performing Arts
28 | Developmental Education - Math
29 | Developmental Education - Reading/Writing
 | Average
 | Median
 | Standard Deviation
Spreadsheet: 103674d1301410041-joining-two-lists-and-highlighting-lowest-value-sfs-excel-example
Sheet: Output

ARTICLE_ID | M0 | 04/2011 | 05/2011 | 06/2011 | 07/2011 | 08/2011 | 09/2011
A1 |  |  |  |  |  |  |  |  |  | I want to have in column A under Article ID so starting row 2
A2 |  |  |  |  |  |  |  |  |  | list of products (A1, A2 etc) based on columns A in Tabs
A3 |  |  |  |  |  |  |  |  |  | Forecast and Operations. No duplicates
A4
B1
B2
B3
Spreadsheet: 306e0d59-60fd-4d51-ad9d-cb82c1befde1
Sheet: Reading Gr. 3

2012 Minnesota Comprehensive Assessments-Series II (MCA-II)
Grade 3 Reading
Raw Score | Scale Score | Level | Percentile Rank
0 | 301 | D | 1
1 | 301 | D | 1
2 | 301 | D | 1
3 | 301 | D | 1
4 | 301 | D | 1
5 | 301 | D | 1
6 | 301 | D | 1
7 | 301 | D | 1
8 | 301 | D | 1
9 | 310 | D | 1
10 | 315 | D | 1
11 | 319 | D | 1
12 | 322 | D | 2
13 | 325 | D | 3
14 | 327 | D | 4
15 | 329 | D | 4
16 | 331 | D | 5
17 | 333 | D | 6
18 | 335 | D | 7
19 | 336 | D | 8
20 | 338 | D | 9
21 | 339 | D | 10
22 | 340 | P | 11
23 | 342 | P | 12
24 | 344 | P | 14
25 | 345 | P | 15
26 | 347 | P | 17
27 | 348 | P | 19
28 | 350 | M | 21
29 | 352 | M | 23
30 | 353 | M | 26
31 | 355 | M | 30
32 | 357 | M | 33
33 | 359 | M | 38
34 | 362 | M | 43
35 | 365 | E | 48
36 | 367 | E | 54
37 | 370 | E | 61
38 | 374 | E | 68
39 | 378 | E | 75
40 | 383 | E | 82
41 | 389 | E | 88
42 | 397 | E | 94
43 | 398 | E | 98
44 | 399 | E | 99
Spreadsheet: 783620d1654966126-formula-linked-to-a-table-excel-forum
Sheet: Sheet1

Reference | Code | Description |  |  |  |  | Reference | Code | Description
C | 8520010 | Cash | A2 | 8520010 | Cash |  | C | 8520010 | Cash | H5 | 9990000 | Cancelled
T | 8520020 | Transfer |  |  |  |  | T | 8520020 | Transfer
S | 8520030 | Speedpoint |  |  |  |  | S | 8520030 | Speedpoint
CA | 9990000 | Cancelled |  |  |  |  | CA | 9990000 | Cancelled
if A2 is selected on D2 then E2 = 8520010 and F2 = Cash |  |  |  |  |  |  | if H5 is selected on K2 then L2 = 9990000 and M2 = Cancelled
The result should always be on E2 and F2 |  |  |  |  |  |  | The result should always be on L2 and M2
Scenario 1 |  |  |  |  |  |  | Scenario 2
Spreadsheet: 854411d1704296446-create-text-string-from-a-list-of-selections-naming-generator-permit-register-test-sheet-wip
Sheet: Sheet1

Permit | Site | Permit number |  | Comments |  | Permit types |  | Sites
Break ground | [NAME] |  |  |  |  | break ground | BG | [NAME] | SN
Hot works | Swanwick |  |  |  |  | Hot works | HW | Swanwick | SW
Break ground | Swanwick |  |  |  |  | Confined space | CS | Ripley | RI
Spreadsheet: 836309d1689258507-days-ahead-behind-schedule-1-1-aligw
Sheet: Sheet1

 | Date Report to be Returned to IRO from Team Manager (9 Working days) | Actual date report returned to IRO from Team Manager | Timescale (Working Days)
2023-01-26 00:00:00 |  | 2023-02-09 00:00:00
2023-01-09 00:00:00 |  | 2023-01-18 00:00:00
2023-01-13 00:00:00
2023-01-11 00:00:00
2023-01-11 00:00:00
2023-01-19 00:00:00
2023-01-05 00:00:00
2023-01-23 00:00:00 |  | 2023-02-23 00:00:00
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: 2020

 |  |  |  |  |  |  | 2020
 |  |  |  |  |  |  |  | Number   of       Walks | Total   Miles | Total Height | Total   Hours  Walked | Average Speed
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Jake
 |  |  |  |  |  |  | Will
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 96e8e6cc-b5bd-40c7-8b35-ddd0e1dd0af9
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
FHPP2 | Test | FHPP2 | Hypersensitivity Pneumonitis FEIA Panel II | Hypersensitivity Pneumonitis Panel | Immunoassay FEIA | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.6 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | [NAME] tenuis/alternata IgG		<12 mcg/mL Aspergillus fumigatus IgG		<46 mcg/mL Aureobasidium pullulans [NAME]		<18 mcg/mL Micropolyspora faeni IgG		<5 mcg/mL [NAME]/notatum IgG	<22 mcg/mL Phoma betae IgG			<8 mcg/mL Thermoactinomyces vulgaris IgG		<13 mcg/mL Trichoderma viride IgG			<10 mcg/mL  Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 2 - 3 days | 4 - 7 days | 8 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FHPP2 | [NAME] | SERUM | Serum |  |  |  | Refrigerated
FHPP2 | Result | Z3166 | [NAME] tenuis/alternata IgG | [NAME] tenuis/alternata IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHPP2 | Result | Z3167 | Aspergillus fumigatus IgG | Aspergillus fumigatus IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHPP2 | Result | Z3168 | Aureobasidium pullulans IgG | Aureobasidium pullulans IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHPP2 | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHPP2 | Result | [NAME] | Penicillium Chrysogenum IgG | Penicillium Chrysogenum IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHPP2 | Result | Z3171 | Phoma betae IgG | Phoma betae IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHPP2 | Result | Z3172 | Thermoactinomyces vulgaris IgG | Thermoactinomyces vulgaris IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHPP2 | Result | Z3173 | Trichoderma viride IgG | Trichoderma viride IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 838557d1691131499-textsplit-function-is-it-possible-to-spill-an-empty-cell-with-zero-txtsplit-hd-1-
Sheet: Sheet1

 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed |  |  | GK |  |  |  |  | AliGW |  |  |  |  | HD |  |  |  |  | HD (if table size > 32K)
 | 1 Smoke Wagon |  | 86 | 85/ 73 | 67 |  |  |  | 73 |  |  |  |  | 85 | 73 | 67 |  |  | 85 | 73 | 67
 | 2 Global Hysteria |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 3 I Strong |  | 86 | [NAME] 75 * | 71* |  |  |  | 75 |  |  |  |  | 86 | 75 | 71 |  | 86 | 86 | 75 | 71
 | 4 Maluma |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 5 Warrior's Cause |  | 93 | 91/ 65 | 66 |  |  |  | 65 |  |  |  |  | 91 | 65 | 66 |  | 93 | 91 | 65 | 66
 | 6 Exclusive Entry |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 7 Bundaburg |  | No Starts Available |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 8 Imposter Syndrome |  | 85 | 87/ 75 | 72 |  |  |  | 75 |  |  |  |  | 87 | 75 | 72 |  | 85 | 87 | 75 | 72
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 3 Protectthewitness |  | 95 | 85/ 57 * | 66* |  |  |  | 57 |  |  |  |  | 85 | 57 | 66 |  |  | 85 | 57 | 66
 | 2 R Girl Faith |  | 79 | 73/ 61 * | 63* |  |  |  | 61 |  |  |  |  | 73 | 61 | 63 |  | 79 | 73 | 61 | 63
 | 5 Vaccina |  | 88 | 81/ 55 * | 63* |  |  |  | 55 |  |  |  |  | 81 | 55 | 63 |  | 88 | 81 | 55 | 63
 | 1 Phancy Philly |  | 79 | 67/ 51 * | 54* |  |  |  | 51 |  |  |  |  | 67 | 51 | 54 |  | 79 | 67 | 51 | 54
 | 4 Sailor's Salute |  | 82 | 71/ 50 * | 53* |  |  |  | 50 |  |  |  |  | 71 | 50 | 53 |  | 82 | 71 | 50 | 53
 | 6 Calvary Kat |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12222 | 11345
2 | 12888 | 11487
3 | 11891 | 11488
4 | 11899 | 11090
5 | 11842 | 11492
6 | 11356 | 11494
7 | 11348 | 11494
8 | 10845 | 11494
9 | 10042 | 11484
10 | 11541 | 11494
11 | 12142 | 11444 | -1
12 | 12792 | 11444
13 | 12272 | 11444
14 | 11797 | 11830
15 | 11785 | 11837
16 | 11842 | 11772 | -183
17 | 12746 | 11494 | -7
18 | 11034 | 11467 | -66
19 | 11828 | 11467 | -113
20 | 12542 | 11467 | -62
21 | 11913 | 11494 | -36
22 | 10242 | 11494 | -104
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  | 442176.52
2001-08-22 00:00:00
CBS Volume
 |  |  | -235778
Spreadsheet: 108628d1305653202-finding-min-from-a-list-based-on-criteria-example1
Sheet: Sheet1

Name | Status | Days_from_Center
A | Upcoming | 14
A | n/a |  |  |  |  | Name | Status | Days_from Center
A | Upcoming | 15 |  |  |  | A | Upcoming | 14
A | n/a |  |  |  |  | B | overdue | -56
A | n/a |  |  |  |  | C | n/a
A | n/a |  |  |  |  | D | overdue | -111
B | n/a
B | overdue | -56
B | n/a
C | n/a
D | n/a
D | n/a
D | n/a
D | overdue | -111
D | overdue | -1
D | n/a
D | n/a
Spreadsheet: 680952d1591276641-auto-categorize-products-lookup-category-of-item-in-table
Sheet: EXPORT

List of Product Titles | Category(In the format I need it for uploading. | Don't need | 1st Cat | 2nd Cat |  |  |  |  |  | Desired outcome
[NAME] [NAME] | Shop All;Projects;Holidays/Easter |  |  |  |  | Shop All
SD1148 [NAME]'s Cups | Shop All;Holidays/Valentines |  |  |  |  | Shop All
SD1149 3D Wheelbarrow with Kitten | Shop All;Projects;Animals |  |  |  |  | Shop All
SD1150 Library Bookends | Shop All;Projects |  |  |  |  | Shop All
SD1151 Horse Bookends | Shop All;Projects |  |  |  |  | Shop All
SD1152 Horse Single | Shop All;Animals |  |  |  |  | Shop All
[NAME] | Shop All;Projects |  |  |  |  | Shop All
SD1155 3D Dream Bed | Shop All;Projects |  |  |  |  | Shop All
SD1158 Iphone Pouch | Shop All;Projects |  |  |  |  | Shop All
SD1159 Cupcake Stand | Shop All;Kitchen |  |  |  |  | Shop All
SD1160 Botanical Quilts | Shop All;Quilt |  |  |  |  | Shop All
SD1161 [NAME] | Shop All;Flowers |  |  |  |  | Shop All
SD1162 Botanical Quilts | Shop All;Quilt |  |  |  |  | Shop All
SD1164 [NAME] | Shop All;Projects |  |  |  |  | Shop All
SD1165 [NAME] | Shop All;Animals |  |  |  |  | Shop All
[NAME] | Shop All;Animals |  |  |  |  | Shop All
SD1167 Adorable Kittens | Shop All;Animals |  |  |  |  | Shop All
SD1168 Lacy Pyramid Box | Shop All;Projects |  |  |  |  | Shop All
SD1169 [NAME] blocks | Shop All;Quilt |  |  |  |  | Shop All
SD1170 [NAME] | Shop All;Flowers |  |  |  |  | Shop All
SD1171 Elegant Swans | Shop All;Birds:Flowers |  |  |  |  | Shop All
SD1172 Cutwork Elegant Swans | Shop All;Birds |  |  |  |  | Shop All
Spreadsheet: 115924d1311361155-how-to-reference-cell-with-date-in-formula-llj-bills-example-sheet
Sheet: Summary

 | Payee | Last Pmt Date | Last Pmt Amount | Next Pmt Due | Next Pmt Amt | Total Paid |  | Paydays |  | Amount Outstanding | Total Paid | Amount Outstanding | Total Paid | Total Bills |  | LLJ | JRJ
 | Netflix |  |  |  |  |  |  | Lil | 2011-06-17 00:00:00 |  |  |  |  |  |  | 2011-04-08 00:00:00 | 2011-04-08 00:00:00
 | SoCalGas |  |  |  |  |  |  | [NAME] | 2011-06-24 00:00:00 |  |  |  |  |  |  | 2011-04-22 00:00:00 | 2011-04-23 00:00:00
 | VZW |  |  |  |  |  |  | Lil | 2011-07-01 00:00:00 |  |  |  |  |  |  | 2011-05-06 00:00:00 | 2011-05-10 00:00:00
 | TOTALS |  |  |  |  |  |  | [NAME] | 2011-07-08 00:00:00 |  |  |  |  |  |  | 2011-05-20 00:00:00 | 2011-05-25 00:00:00
 |  |  |  |  |  |  |  | Lil | 2011-07-15 00:00:00 |  |  |  |  |  |  | 2011-06-03 00:00:00 | 2011-06-10 00:00:00
 |  |  |  |  |  |  |  | [NAME] | 2011-07-23 00:00:00 |  |  |  |  |  |  | 2011-06-17 00:00:00 | 2011-06-24 00:00:00
 |  |  |  |  |  |  |  | Lil | 2011-07-29 00:00:00 |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2011-07-08 00:00:00
 |  |  |  |  |  |  |  | [NAME] | 2011-08-10 00:00:00 |  |  |  |  |  |  | 2011-07-15 00:00:00 | 2011-07-23 00:00:00
 |  |  |  |  |  |  |  | Lil | 2011-08-12 00:00:00 |  |  |  |  |  |  | 2011-07-29 00:00:00
 |  |  |  |  |  |  |  | [NAME] | 2011-08-25 00:00:00 |  |  |  |  |  |  | 2011-08-12 00:00:00 | 2011-08-10 00:00:00
 |  |  |  |  |  |  |  | Lil | 2011-08-26 00:00:00 |  |  |  |  |  |  | 2011-08-26 00:00:00 | 2011-08-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-09 00:00:00 | 2011-09-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-23 00:00:00 | 2011-09-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-07 00:00:00 | 2011-10-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-21 00:00:00 | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-04 00:00:00 | 2011-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-18 00:00:00 | 2011-11-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-02 00:00:00 | 2011-12-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-30 00:00:00 | 2011-12-23 00:00:00
Spreadsheet: 700955d1603434444-date-difference-in-days-with-conditions-sample3a
Sheet: sample3

Order Number |  |  | Shipment Type | Date1 | Date2 | Expected Value:
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1141243 |  |  | Final | 2020-01-17 00:00:00 | 2020-01-17 00:00:00 | 0
1137372 |  |  | Interim | 2015-12-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Final | 2015-12-31 00:00:00 | 2020-01-16 00:00:00 | N/A
1137372 |  |  | Interim | 2015-12-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2016-04-30 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2016-04-30 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2016-08-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2016-08-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2016-12-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2016-12-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2017-04-30 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2017-04-30 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2017-08-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2017-08-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2017-12-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2017-12-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2018-04-30 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2018-04-30 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2018-08-31 00:00:00 | 2019-12-18 00:00:00 | N/A
1137372 |  |  | Interim | 2018-08-31 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2019-09-30 00:00:00 | 2019-12-17 00:00:00 | N/A
1137372 |  |  | Interim | 2019-09-30 00:00:00 | 2019-12-17 00:00:00
1130302 |  |  | Final |  | 2020-02-23 00:00:00 | -
1130302 |  |  | Final | 2020-02-23 00:00:00 |  | -
1130303 |  |  | Final | 2020-03-23 00:00:00 | 2020-03-23 00:00:00 | -
1130303 |  |  | Final |  |  | -
1130307 |  |  | Final | 2020-07-23 00:00:00 | 2020-07-23 00:00:00 | 0
1130307 |  |  | Final | 2020-07-23 00:00:00 | 2020-07-23 00:00:00 | 0
1130308 |  |  | Final | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 2
1130308 |  |  | Final | 2020-08-23 00:00:00 | 2020-08-25 00:00:00 | 2
1133451 |  |  | Final | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 6
1133451 |  |  | Final | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 6
1133451 |  |  | Final | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 6
1133451 |  |  | Final | 2020-01-01 00:00:00 | 2020-01-07 00:00:00 | 6
Spreadsheet: 788509d1658503815-inventory-control-spreadsheet-excel-demo
Sheet: Pull Down Data

 |  | Items
 |  | Airplane (Foam Super Glider) |  | Items being ordered for |  | Current Units in Stock as of
 |  | Backpack (Ladies Grey w/ Buttons)
 |  | Backpack (Black & Grey)
 |  | Backpack (Men's Black)
 |  | Balloons (Green, White, Black)
 |  | Beach Ball
 |  | Binoculars
 |  | Binoculars (Cardboard)
 |  | Blanket
 |  | Business Card Holder (Black)
 |  | [NAME]
 |  | [NAME] ([NAME])
 |  | Cell Buckle
 |  | Cell [NAME]
 |  | Cell Mount ( Clip-it Vent)
 |  | Cell Phone Cover (Waterproof)
 |  | Cell Suction Holder
 |  | [NAME]
 |  | Cleaning Cloth
 |  | Coaster ( Black Leather - Each)
 |  | [NAME]
 |  | [NAME] (6-pack)
 |  | [NAME] (Insulated Large)
 |  | Cup (Large VIP)
 |  | [NAME] ( High End w/Mesh)
 |  | [NAME] ( Clear Plastic)
 |  | [NAME] (Black or Gray Cloth)
 |  | Earbuds
 |  | Folder (Gusset)
 |  | [NAME]
 |  | Folder - Green Pocket Glossy Letter
 |  | Folder - Green Pocket Matte Letter
 |  | Folder - White Pocket Glossy Legal
 |  | Folder - White Pocket Glossy Letter
 |  | Frisbee ([NAME])
 |  | Frisbee Hard Style (Grey)
 |  | Football
 |  | [NAME] (White Paper)
 |  | Golf Balls (Callaway HEX per sleeve)
 |  | [NAME] (Grey)
 |  | [NAME] (Green)
 |  | [NAME]
 |  | Hand [NAME] (1/2 oz. Bottle)
 |  | Hand [NAME] (2 oz. Bottle)
 |  | Key Carabiner
 |  | [NAME]
 |  | Koozie
 |  | Lanyard
 |  | Laptop bag
 |  | Laptop Bag (Black_
 |  | Laptop Bag (Foam Black)
 |  | Laptop Bag (New Gray)
 |  | Laptop Bag ( Leather)
 |  | [NAME] (Ball)
 |  | [NAME] (Regular)
 |  | Light Bar
 |  | Luggage Tag
 |  | Magnetic Clip (White and Black)
 |  | [NAME]
 |  | Note Pad (Small, Medium, Large)
 |  | Note Book (Spiral 3x5)
 |  | Note Book (Spiral 6x9)
 |  | Note Pad (Black Cover with Pen)
 |  | Pen (Black)
 |  | Phone Ring
 |  | Phone Wedge
 |  | Plastic Bag (Black Small)
 |  | Plastic Bag (White Large)
 |  | Polo Shirt (M & W - Nike and Ogio)
 |  | Polo Shirt (M & W - Other Brand)
 |  | Pop Socket
 |  | Portfolio
 |  | Post-It Note (VIP)
 |  | Post-It Note Booklet
 |  | Screen Cleaners (Adhesive Back)
 |  | Screwdrivers
 |  | [NAME] .5 oz.
 |  | [NAME]
 |  | Sunshade
 |  | T-Shirt (Men's and Women's)
 |  | Tape Measure
 |  | Thank You Card/Envelope (Large)
 |  | Thank You Card/Envelops (Small)
 |  | [NAME] (Black Cloth)
 |  | Tumbler (Black Yeti Style)
 |  | Tumbler ([NAME])
 |  | Tumbler (VIP Clear)
 |  | USB Charger Cube
 |  | [NAME] (Various Styles and Colors)
 |  | Wallet Ninja
 |  | Water (Case of VIP Logo)
 |  | Wet Wipes
 |  | [NAME] (Black)
 |  | [NAME]
 |  | [NAME] ([NAME])
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 841751d1693922203-calculation-of-holiday-hours-holidays-calculator
Sheet: LucasShift

Date | Employee 1 |  |  | Employee 2 |  |  |  | Annual Holidays
 | Time In | Time Out | Hours | Time  In | Time Out | Hours
2023-08-01 00:00:00 |  |  |  | 07:00:00 | 16:16:00 |  |  | 2023-01-01 00:00:00
2023-08-02 00:00:00 |  |  |  | 07:00:00 | 16:22:00 |  |  | 2023-04-07 00:00:00
2023-08-03 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:15:00 |  |  | 2023-04-10 00:00:00
2023-08-04 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:19:00 |  |  | 2023-04-19 00:00:00
2023-08-05 00:00:00 | 16:00:00 | 07:00:00 |  |  |  |  |  | 2023-04-25 00:00:00
2023-08-06 00:00:00 | 16:00:00 | 07:00:00 |  |  |  |  |  | 2023-05-01 00:00:00
2023-08-07 00:00:00 |  |  |  | 07:00:00 | 16:15:00 |  |  | 2023-05-18 00:00:00
2023-08-08 00:00:00 |  |  |  | 07:00:00 | 16:15:00 |  |  | 2023-07-22 00:00:00
2023-08-09 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:11:00 |  |  | 2023-08-04 00:00:00
2023-08-10 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:13:00 |  |  | 2023-08-06 00:00:00
2023-08-11 00:00:00 | 16:00:00 | 07:00:00 |  |  |  |  |  | 2023-08-16 00:00:00
2023-08-12 00:00:00 | 16:00:00 | 07:00:00 |  |  |  |  |  | 2023-08-31 00:00:00
2023-08-13 00:00:00 |  |  |  | 07:00:00 | 16:12:00 |  |  | 2023-12-25 00:00:00
2023-08-14 00:00:00 |  |  |  | 07:00:00 | 16:19:00 |  |  | 2023-12-26 00:00:00
2023-08-15 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:14:00 |  |  | 2023-12-28 00:00:00
2023-08-16 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:17:00
2023-08-17 00:00:00 | 16:00:00 | 07:00:00
2023-08-18 00:00:00 | 16:00:00 | 07:00:00
2023-08-19 00:00:00 |  |  |  | 07:00:00 | 16:24:00
2023-08-20 00:00:00 |  |  |  | 07:00:00 | 16:14:00
2023-08-21 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:15:00
2023-08-22 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:15:00
2023-08-23 00:00:00 | 16:00:00 | 07:00:00
2023-08-24 00:00:00 | 16:00:00 | 07:00:00
2023-08-25 00:00:00 |  |  |  | 07:00:00 | 16:15:00
2023-08-26 00:00:00 |  |  |  | 07:00:00 | 16:15:00
2023-08-27 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:15:00
2023-08-28 00:00:00 | 07:00:00 | 16:00:00 |  | 16:00:00 | 07:15:00
2023-08-29 00:00:00 | 16:00:00 | 07:00:00
2023-08-30 00:00:00 | 16:00:00 | 07:00:00
2023-08-31 00:00:00 |  |  |  | 16:00:00 | 07:15:00
2023-08-04 00:00:00 | from 07.00 to 16.00 = 9 Hours |  |  | from 16.00 to 00.00 = 8 Hours
2023-08-06 00:00:00 | from 16.00 to 00.00 = 8 Hours |  |  | -
2023-08-16 00:00:00 | from 07.00 to 16.00 = 9 Hours |  |  | from 16.00 to 00.00 = 8 Hours
2023-08-31 00:00:00 | from 00.00 to 07.00 = 7 Hours |  |  | from 16.00 to 00.00 = 8 Hours
 | Total Holidays | 33 hours |  | Total Holidays | 24 hours
Spreadsheet: 199839d1355336337-sum-a-row-based-on-a-condition-in-a-separate-row-sample_data
Sheet: Sheet1

FRUIT | Pear | Grape | Lemon | Tomato
Apple | 3 | 3 | 2 | 0
Orange | 0 | 1 | 3 | 1
FRUIT | Pear | Grape | Lemon | Tomato
Apple | NOT IN SEASON | IN SEASON | NOT IN SEASON | IN SEASON
Orange | IN SEASON | NOT IN SEASON | NOT IN SEASON | IN SEASON
 | SUM OF IN SEASON | SUM OF NOT IN SEASON
FRUIT
Apple | 3 | 5
Orange | 4 | 1
Spreadsheet: 843400d1695247313-get-data-transfered-between-sheets-based-on-matching-critera-and-dates-over-45-days-test2
Sheet: Sheet1

PRODUCT CODE | BAG SIZE | [NAME] | WEIGHT PER CARTON (KG) | CURRENT CARTON QTY | FUTURE CARTON QTY | TOTAL 3 MONTH USAGE (FEB TO APRIL 2023) | STOCK | CONSIGNMENT STOCK | TOTAL STOCK | AGED STOCK | Aged Stock Days
WB90207 | 250x400 | 1 | 6.86 | 500 | 500 | 0
WB90211 | 250x700 | 2 | 8.89 | 350 | 350 | 0
WB90215 | 225x850 | 3 | 12.22 | 400 | 400 | 2387
WB90216 | 250x550 | 4 | 10.84 | 600 | 600 | 6090
WB90217 | 350x860 | 5 | 14.65 | 400 | 400 | 1050
WB90218 | 400x700 | 6 | 14.1 | 350 | 400 | 4047
WB90219 | 430x875 | 7 | 16.33 | 350 | 350 | 1400
WB90220 | 350x550 | 8 | 15.12 | 650 | 650 | 2240