tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 771060d1646402697-counting-working-days-between-start-and-end-dates-but-only-for-a-specific-month-networkdate-problem-aligw
Sheet: Sheet1

2022-01-01 00:00:00
Consultant | Contractor | Daily Margin | Billed Margin | Start Date | End Date | Days worked This month | Projected Revenue | Expected Revenue | Utilisation |  | Bank Holidays
 |  |  |  | 2021-12-01 05:00:00 | 2022-05-31 05:00:00 |  |  |  |  |  | 2021-12-26 00:00:00
 |  |  |  | 2022-01-10 05:00:00 | 2022-02-18 05:00:00 |  |  |  |  |  | 2021-12-27 00:00:00
 |  |  |  | 2021-04-01 05:00:00 | 2022-04-02 00:00:00 |  |  |  |  |  | 2021-12-28 00:00:00
 |  |  |  | 2021-09-15 05:00:00 | 2022-03-15 05:00:00 |  |  |  |  |  | 2021-12-29 00:00:00
 |  |  |  | 2021-11-03 05:00:00 | 2022-02-03 05:00:00 |  |  |  |  |  | 2021-12-30 00:00:00
 |  |  |  | 2021-11-01 05:00:00 | 2022-05-02 05:00:00 |  |  |  |  |  | 2021-12-31 00:00:00
 |  |  |  | 2021-09-27 05:00:00 | 2022-03-28 05:00:00 |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  | 2021-08-09 05:00:00 | 2022-08-09 05:00:00 |  |  |  |  |  | 2022-01-03 00:00:00
 |  |  |  | 2020-11-04 05:00:00 | 2022-03-31 00:00:00 |  |  |  |  |  | 2022-04-15 00:00:00
 |  |  |  | 2020-12-14 05:00:00 | 2022-06-14 00:00:00 |  |  |  |  |  | 2022-05-02 00:00:00
 |  |  |  | 2022-01-31 05:00:00 | 2022-07-29 05:00:00 |  |  |  |  |  | 2022-06-02 00:00:00
 |  |  |  | 2021-11-15 05:00:00 | 2022-09-30 00:00:00 |  |  |  |  |  | 2022-06-03 00:00:00
 |  |  |  | 2018-11-19 05:00:00 | 2022-02-28 00:00:00 |  |  |  |  |  | 2022-08-29 00:00:00
Spreadsheet: 860831d1708860697-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-new-working-file_edit-for-hans
Sheet: Fcast

 |  |  |  |  |  |  |  | 16 | 21 | 28 | 33
employee number: | Start date : | Due Date for Delivery: | Forecasted DOW for delivery: | Status: Done or Overdue? | Due Date for GD and DIB: | Forecasted DOW for due date: |  | Working Days *Start Date* | Working Days *Start Date* | Working Days *Start Date* | Working Days *Start Date*
184748 | 2024-02-01 00:00:00 | 2024-02-23 00:00:00 | Fri | OVER | 2024-02-15 00:00:00 | Thu
184748 | 2024-02-12 00:00:00 | 2024-02-23 00:00:00 | Fri | OVER | 2024-02-19 00:00:00 | Mon
11031395 | 2024-02-15 00:00:00 | 2024-03-08 00:00:00 | Fri |  | 2024-02-29 00:00:00 | Thu
11031395 | 2024-01-26 00:00:00 | 2024-03-19 00:00:00 | Tue |  | 2024-03-11 00:00:00 | Mon
11031395 | 2024-03-04 00:00:00 | 2024-03-26 00:00:00 | Tue |  | 2024-03-18 00:00:00 | Mon
11031395 | 2024-03-22 00:00:00 | 2024-04-22 00:00:00 | Mon |  | 2024-04-12 00:00:00 | Fri
11031395 | 2024-03-27 00:00:00 | 2024-04-22 00:00:00 | Mon |  | 2024-04-12 00:00:00 | Fri
11045848 | 2024-02-06 00:00:00 | 2024-04-09 00:00:00 | Tue |  | 2024-04-02 00:00:00 | Tue
11045848 | 2024-02-06 00:00:00 | 2024-04-09 00:00:00 | Tue |  | 2024-04-02 00:00:00 | Tue
11045848 | 2024-05-10 00:00:00 | 2024-06-17 00:00:00 | Mon |  | 2024-06-11 00:00:00 | Tue
11045848 | 2024-05-10 00:00:00 | 2024-06-17 00:00:00 | Mon |  | 2024-06-11 00:00:00 | Tue
11045848 | 2024-06-17 00:00:00 | 2024-07-22 00:00:00 | Mon |  | 2024-07-15 00:00:00 | Mon
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 78448 | 77619
2 | 85041 | 84335
3 | 98229 | 102930
4 | 97181 | 96001
5 | 94830 | 94837
6 | 118505 | 116824
7 | 132898 | 134855
8 | 138859 | 138000
9 | 124179 | 120027
10
11 | 692 | 12248
12 | 39802 | 37000
13 | 98820 | 96392
14 | 125524 | 131334
15 | 132209 | 132373
16 | 123588 | 121560
17 | 108500 | 106912
18 | 142283 | 139594
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 59179
2001-07-18 00:00:00
Spreadsheet: eric_saibi__9735__011102R
Sheet: Colstrip 03

Owner Name |  | PPL Montana LLC
Station Name |  | Colstrip Power Station
Unit Name |  | Colstrip 03
NERC Region |  | WSCC
State |  | MT
Fuel Type |  | Coal
Capacity |  | 778 MW
Start Date |  | 2002-01-05 00:00:00
End Date |  | 2002-01-18 00:00:00
Prv. Start Date |  | 2002-01-05 00:00:00
Prv. End Date |  | 2002-01-12 00:00:00
Comments |  | Generator problem.  Will be offline for at least another week.
SIC |  | 4931
Plant ID |  | 1015370
Unit ID |  | 1007494
Outage ID |  | 19382
Spreadsheet: 850411d1700751659-counting-consecutives-identical-cells-estevaoba-count_occurrences-eba
Sheet: Sheet1

A | W |  |  |  |  | Result required | Where? |  |  |  | W | D | L
A | D |  | Most consecutive wins | ALL | W | 3 | B:35:B37
A | L |  | Most consecutive draws | ALL | D | 3 | B15:B17
A | W |  | Most consecutive losses | ALL | L | 3 | B10:B12
B | W |  | Longest without a win | ALL | W | 6 | B:20:B25
A | D |  | Longest without a draw | ALL | D | 8 | B7:B14
A | L |  | Longest without a loss | ALL | L | 8 | B13:B20
A | W
A | W |  | Most consecutive wins | A | W | 3 | B26, B28, B31
B | L |  | Most consecutive draws | A | D
B | L |  | Most consecutive losses | A | L
B | L |  | Longest without a win | A | W
B | W |  | Longest without a draw | A | D
B | W |  | Longest without a loss | A | L
B | D
B | D |  | Most consecutive wins | B | W | 2 | B13:B14 and B18:B19
B | D |  | Most consecutive draws | B | D
B | W |  | Most consecutive losses | B | L
B | W |  | Longest without a win | B | W
B | D |  | Longest without a draw | B | D
A | L |  | Longest without a loss | B | L
A | D
A | D
A | L
B | L
A | W
B | D
A | W
B | L
B | W
A | W
B | D
B | D
A | L
A | W
B | W
A | W
A | D
B | L
B | D
A | L
Spreadsheet: 177893d1346505066-how-to-tell-excel-not-to-check-column-in-sequence-sanlen_857290_latest_sub_rej_date_01sep12_01
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Latest
 | Report | 1st Submission | 1st Reject | 2nd Submission | 2nd Reject | Date Submission | Date Reject |  | Submission | Rejection
 | Report1 | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 | 2012-08-04 00:00:00 | 2012-08-07 00:00:00 | 2012-08-04 00:00:00 | 2012-08-07 00:00:00
 | Report2 | 2012-08-05 00:00:00 | 2012-08-07 00:00:00 |  |  | 2012-08-05 00:00:00 | 2012-08-07 00:00:00
 | Report3 | 2012-08-04 00:00:00 |  |  |  | 2012-08-04 00:00:00
 | Report4
Spreadsheet: 737399d1624395019-identify-unique-id-across-2-sheets-but-the-unique-id-is-a-formula-not-a-value-test-sheet-tms
Sheet: Sheet1 (2)

County | State | Color | Name | Flavor | Dog | Unique ID
Wayne | OH | Yellow | [NAME] | Vanilla | Spot |  |  |  | =COUNTIF(Sheet1!$G:$G,$G2)
Greenville | SC | [NAME] | [NAME] | Chocolate | Rover
Abbington | GA | Orange | [NAME] | [NAME] | [NAME]
[NAME] | SC | Purple | [NAME] | Chocolate | Prince
 |  |  |  |  |  |  |  |  |  | Compare the "Unique ID" on both sheets and hightlight the duplicates
Spreadsheet: 778104d1650868583-compilation-of-work-shifts-with-monthly-updates-works-2-
Sheet: mese

Anno | 2022 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat
 |  | 1 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 |  |  |  |  |  |  |  |  |  | Sat
 |  | 2 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 |  |  |  |  |  |  |  |  |  |  |  |  | Sat
 |  | 3 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4
 |  | 4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5
 |  | 5 |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2 | M3 | M4 | M5 |  |  | P1 | P2 | P3 | P4 | P5 |  |  | N1 | N2 | N3 | N4 | N5 |  |  | M1 | M2
Spreadsheet: 76202d1276738923-max-min-date-range-based-on-another-cell-range-book3_jun16
Sheet: Sheet1

 |  |  |  | Session | Start | End
2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 1 |  | 1 | 2010-01-01 00:00:00 | 2010-01-08 00:00:00
2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 1 |  | 2 | 2010-01-09 00:00:00 | 2010-01-14 00:00:00
2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 1 |  | 3 | 2010-01-15 00:00:00 | 2010-01-22 00:00:00
2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 1
2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2
2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2
2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2
2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 3
2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 3
2010-01-19 00:00:00 | 2010-01-20 00:00:00 | 3
2010-01-21 00:00:00 | 2010-01-22 00:00:00 | 3
Spreadsheet: 727823d1618137530-building-a-truck-even-pallet-quantities-pallet-builder_mod1
Sheet: Info

 |  |  |  |  |  | MAX's
 | Weight/pallet |  |  |  |  | 12ct | 26 | pallets/truck
12ct | 1660 | lb |  |  |  | 3x4 | 26 | pallets/truck
3x4 | 1660 | lb |  |  |  | 24ct | 24 | pallets/truck
24ct | 1825 | lb |  |  |  | Cartons | 20 | pallets/truck
Cartons | 2075 | lb
 | Cases/Pallet
12ct | 161 | ca/pallet
3x4 | 161 | ca/pallet
24ct | 120 | ca/pallet |  |  |  | Example.. |  |  |  |  |  |  |  | This would be 1 truck. All uneven quantites would need to be in the last truck as "leftovers"
Cartons | 120 | ca/pallet |  |  |  | Truck # | SKU | Item | Lot # | Qty | Cases per Pallet | # of Pallets
 |  |  |  |  |  | Truck 1 | 5634 | Chocolate 12ct | 1234E | 161
Example of items to build in a truck… |  |  |  |  |  | Truck 1 | 5634 | Chocolate 12ct | 1234F
Item | SKU | Lot # | Qty (Cases)
Chocolate 12ct | 5634 | 1234A | 158
Chocolate 12ct | 5634 | 1234B | 9902
Chocolate 12ct | 5634 | 1234C | 9924
Chocolate 12ct | 5634 | 1234D | 10053
Chocolate 12ct | 5634 | 1234E | 161
Chocolate 12ct | 5634 | 1234F | 9435
This is my first post and I'm hoping I can get some help as I haven't been able to find something similar online.
In my job I need to create truckloads. Each truckload is to have X amount of pallets based on what the item is. I have to split up my inventory based on lot # and pallet quantity.
I've attached a sheet with the rules and an example of a "perfect deployment" (multiple truckloads for the quantities I need to ship). You are allowed to mix items in a truck as well as lot #'s.
However, each truck must be EXACTLY the maximum (either 26 pallets or 23 depending on the item). Any odd quantities must be on the last shipment and all grouped together.
I don't know if that is the best explanation but I'm attaching the spreadsheet and am more than willing to answer Q's. I do this often so any way to automate it would be helpful.
Spreadsheet: 684355d1593324515-find-max-and-lookup-previous-non-blank-date-equal-offense-log
Sheet: Sheet1

Score of last 10
[NAME] score
[NAME] score date
2020-06-27 00:00:00 | 7
 | 1
 | 2
 | 10
 | 10
 | 7
 | 6
 | 6
 | 9
 | 8
 | 4
 | 6
 | 8
Spreadsheet: darron_c_giron__8025__Book Admin West
Sheet: example

Book Administrator Listing
Company | Group | Report To
ENA | Gas | [NAME]
Name | Book ID | Primary / Back-up | Phone | Manual or System | System
[NAME] | ABC | Primary | x3-5686 | System | ERMS
[NAME] | XYZ | Back-up | x3-5686 | Manual
Spreadsheet: 124576d1318474079-count-group-of-number-in-column-countgroup
Sheet: Sheet1

2 |  |  |  |  | I would like to count how many time group of criteria appear?
2
2 |  |  |  |  | Criteria: | 3
3 |  |  |  |  | Result: | 5
3
2 |  |  |  |  | Which formula to use in G5?
2
2
2
2
1
1
1
3
3
3
3
3
3
1
1
3
3
2
2
1
3
1
1
1
1
1
3
3
3
3
Spreadsheet: benjamin_rogers__1255__merchant peaker plants version3
Sheet: ENA Comps

 |  | [NAME]
 |  |  |  |  |  |  |  |  |  | ENA | CSFB
 |  | Company | Location | Source | Turbine Type | Article Date | Operation Date | MW's | Cost ($ [NAME]) | Cost/kW | Cost/kW
 | 1 | Dynergy | Lake Charles | Co. Press Release | GE 7FA | 1999-07-23 00:00:00 | 2000-06-01 00:00:00 | 155 | 50 |  | 322
 |  | Tenaska | Georgia | Co. Press Release | GE 7FA | 1999-11-11 00:00:00 | 2001-06-01 00:00:00 | 936 | 410 |  | 354.84
 |  | Entergy | Miss. | Co. Press Release | GE 7EA | 2000-02-24 00:00:00 | 2001-06-01 00:00:00 | 300 | 140 |  | 466.67
 |  | Southwestern Elec. Coop. | Illinois | Megawatt Daily | GE LM 6000 | 1999-12-06 00:00:00 | 2001-06-01 00:00:00 | 45 | 25 |  | 555.56
 |  | Hoosier Energy/Williams | Indiana | N/A | GE LM 6000 | N/A | N/A | 170 | 94 |  | N/A
 |  | [NAME] | Texas | Co. Press Release | GE LM 6000 | N/A | 2001-06-01 00:00:00 | 178 | 93.2 |  | N/A
 |  | [NAME] | Louisiana | Co. Press Release | 6 LM 6000 & 1 7EA | 2000-05-10 00:00:00 | 2002-06-01 00:00:00 | 550 | 250 |  | N/A
 |  | DPL | Ohio | Co. Press Release | GE Gas Turbines | 2000-08-30 00:00:00 | 1999-06-01 00:00:00 | 250 | 75 |  | N/A
 |  | DPL | Ohio | Co. Press Release | Pratt & Whitney | 2000-01-31 00:00:00 | 2000-06-01 00:00:00 | 225 | 80 |  | 444.44
 |  | DPL | Ohio | Co. Press Release | GE Gas Turbines | 2000-01-10 00:00:00 | 2001-12-01 00:00:00 | 160 | 60 |  | 390.63
 |  | Indeck | Illinois | Co. Press Release | N/A | 2000-05-24 00:00:00 | 2001-06-01 00:00:00 | 700 | 250 |  | 357.14
 |  | Indeck | Illinois | Co. Press Release | N/A | 2000-03-01 00:00:00 | N/A | 300 | 100 |  | 333.33
 |  | Standard Power & Light | Illinois | Generation Week | N/A | 2000-03-01 00:00:00 | N/A | 800 | 380 |  | 475
 |  | PPL Global | Pennsylvania | Electric Power Daily | N/A | 2000-05-26 00:00:00 | 2002-06-01 00:00:00 | 900 | 425 |  | N/A
 |  | Average
 |  | Average (w/o GE LM 6000's)
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -175
2
3 |  | -2000
4
5 |  | -16528
6 | -31547 | -16528
7 | -17414 | -16528
8 | -10189 | -10500
9 | -17552 | -15935
10 | -9962 | -15500
11 | -70735 | -71187
12 | -58208 | -59296
13 | -57826 | -59296
14 | -57796 | -59296
15 | -24830 | -25514
16 | -29576 | -21882
17 | -28848 | -30000
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -14315
2002-01-17 00:00:00
CBS Dollars
 |  |  | 163235
Spreadsheet: 874792d1721301283-excel-formula-for-changing-cell-colour-when-date-inputted-is-getting-closer-excel-formula-for-changing-cell-colour-when-date-inputted-is-getting-closer
Sheet: Sheet1 (2)

Date | Months to TODAY |  | Green | Yellow | Light Red | Red |  | Excel formula for changing cell colour when date inputted is getting closer
2023-10-01 00:00:00 |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1426352-excel-formula-for-changing-cell-colour-when-date-inputted-is-getting-closer.html
 |  |  | [NAME] 6 mth | 3-6 mth | < 3 mth | past due
Spreadsheet: 779680d1651996312-finding-average-figure-based-on-matching-name-finding-average-figure-based-on-matching-name
Sheet: Sheet1

 | Task | Average Time |  | https://www.excelforum.com/excel-formulas-and-functions/1377607-finding-average-figure-based-on-matching-name.html
 | Walking
 | Running
 | Cycling
 | Task | Minutes
 | Walking | 100
 | Running | 10
 | Cycling | 1
 | Walking | 200
 | Running | 20
 | Cycling | 2
 | Walking | 300
 | Running | 30
 | Cycling | 3
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 22

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
U 3 |  | 22:00     6:00 |  |  | 14:00    24:00 | 15:00     1:00 | 23:00     7:00
 |  |  | 6:00     15:00 | 6:00     15:00 | 6:00     15:00
 | 6:00     16:00 | 8:00     18:00 |  |  | 6:00     16:00 | 14:00    23:00 | 22:00     6:00
 | 23:00     7:00 |  | 15:00    24:00 | 22:00     6:00
 | 10:00    20:00 |  |  | 14:00    24:00 | 22:00     6:00 | 22:00     6:00
 | 14:00    24:00 | 14:00    24:00 | 22:00     6:00
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
U 4 | 22:00     6:00 | 23:00     7:00 |  |  |  | 7:00     16:00 | 7:00     16:00
 | 5:00     13:00 | 14:00    23:00 | 22:00     6:00 | 23:00     7:00
 | 6:00     15:00 | 5:00     14:00 |  |  | 6:00     16:00 | 14:00    24:00 | 22:00     6:00
 | 22:00     6:00 |  |  | 15:00     1:00
 |  |  | 14:00    22:24 | 13:00    22:00 | 14:00    24:00 | 22:00     6:00 | 22:00     6:00
 |  |  | 6:00     15:00 | 4:00     11:00 | 6:00     14:00
Spreadsheet: 852264d1702350683-dedup-complex-fields-dedup-complex-fields
Sheet: Sheet1

 | [NAME] |  | [NAME] desired |  |  | Excel 365 | Stacked help | Uniques
 | AAL-AMS |  | AAL-AMS
 | AAL-AMS |  | ABZ-AMS | ABZ-AMS |  | ABZ-AMS
 | ABZ-AMS |  | ACC-AMS | ACC-AMS |  | ACC-AMS
 | ABZ-AMS |  | ACE-AMS | ACE-AMS |  | ACE-AMS
 | ACC-AMS |  | ADB-AMS | ADB-AMS |  | ADB-AMS
 | ACE-AMS |  | AES-AMS | AES-AMS |  | AES-AMS
 | ACE-AMS |  | AGP-AMS | AGP-AMS |  | AGP-AMS
 | ADB-AMS |  | ALC-AMS | ALC-AMS |  | ALC-AMS
 | ADB-AMS |  | AMS-ATL | AMS-AAL |  | AMS-AAL
 | AES-AMS |  |  | AMS-ABZ |  | AMS-ABZ
 | AES-AMS |  |  | AMS-ACC |  | AMS-ACC
 | AGP-AMS |  |  | AMS-ACE |  | AMS-ACE
 | AGP-AMS |  |  | AMS-ADB |  | AMS-ADB
 | ALC-AMS |  |  | AMS-AES |  | AMS-AES
 | ALC-AMS |  |  | AMS-ATL |  | AMS-ATL
 | AMS-AAL |  |  |  |  | AMS-AGP
 | AMS-AAL |  |  |  |  | AMS-ALC
 | AMS-ABZ |  |  |  |  | ATL-AMS
 | AMS-ABZ
 | AMS-ACC
 | AMS-ACE
 | AMS-ACE
 | AMS-ADB
 | AMS-ADB
 | AMS-AES
 | AMS-ATL
 | and so on…
Spreadsheet: 109673d1306453075-how-to-transpose-if-duplicates-transposelikeduplicates1
Sheet: Sheet1

 |  | (Desired Output) |  |  |  |  |  | 1
A | A | A A, A C, A P, A M, A E, A F, A G |  |  |  | A | A,A | A,C | A,P | A,M | A,E | A,F | A,G
C | A |  |  |  |  | B | B,H | B,A | B,R | B,K | B,L | B,N | B,O
P | A
M | A
E | A
F | A
G | A
H | B | B H, B A, B R, B K, B L, B N, B O
A | B
R | B
K | B
L | B
N | B
O | B
Spreadsheet: 49749d1249061705-vlookup-functions-example
Sheet: Supplier B

Part Name | Part Number | Package Type | Cost
101 | AB | Bag | 0.56
101 | AB | Box | 0.58
102 | AC | Bag | 2.45
102 | AC | Box | 2.66
103 | AD | Bag | 2.77
103 | AD | Box | 2.89
104 | AE | Bag | 2.99
104 | AE | Box | 4.25
Spreadsheet: 773219d1647703454-return-number-based-on-a-value-in-a-specific-cell-work-hourssumproduct
Sheet: Attendence Dashboard

Month | Year
1 | 2022
ID No. | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOURS | If an employee  is on duty "D" on Saturday, Sunday or Holiday day, under "D" should be 0 (zero)/blank cell, if is on duty "D" on the rest of the week (except Holyday day) under "D" should be 8 in order to calculate the work hours in that month in cell B8.
1 | [NAME] | D |  | P | D | P | D | P |  | D | P | P |  | P | H |  |  | D | P |  | L | P | D |  | P | P | H | H | H |  | D | P
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
 |  |  |  | D= DUTY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXCLUDE
 |  |  |  | P=PRESENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  | H=HOLIDAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L
 |  |  |  | L=LEAVE
Spreadsheet: 61a84ff7-20a4-4096-af73-c05f204aa6e3
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
PPAN | Test | PPAN | Acute Porphyria, Multi-Gene Panel | Acute Porphyria, Multi-Gene Panel | Polymerase Chain Reaction (PCR) Amplification/DNA Sequencing  (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA Yellow-Top (ACD) Tube: ACD |  |  | 3 | mL | [NAME] must arrive within 96 hours of collection.   Preferred: [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Biochemical Disorders Patient Information Sheet (Supply T527) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. |  | No specimen should be rejected. If specimen is received in wrong anticoagulant or at an inappropriate temperature, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Tuesday, 10 am | 14 days | 20 days | 1 | 81479 |  |  |  |  | Rochester
PPAN | [NAME] | VARIES | Varies |  |  |  | Ambient
PPAN | Result | 51489 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
PPAN | Result | 51490 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PPAN | Result | 51491 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Geneticist review:Imp:Pt:XXX:Nar:
PPAN | Result | 51492 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
PPAN | Result | 51493 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
PPAN | Result | 51494 | [NAME] | [NAME] | Alphanumeric
PPAN | Result | 51495 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
PPAN | Result | 51496 | Reviewed By | Reviewed By | Alphanumeric
PPAN | Result | 51497 | Release Date | Release Date | Alphanumeric
Spreadsheet: 768852d1645168059-formula-required-to-look-up-four-values-and-return-values-from-a-column-look-four-values-and-return-a-column-value-v2
Sheet: output

Category | Item | Type | LM | Target/team/d | Column1 | 7.2.22 | 7.02.2022 | 8.02.22 | 8.2.22 | 9.2.22 | 9.2.2022 | 10.02.2022 | 10.02.20222 | 11.02.2022 | 11.02.22 | 12.02.2022 | 12.2.22
Date | Date | Date | Date |  |  | EL | LM | EL | LM | EL | LM | EL | LM | EL | LM | EL | LM
installation | HH1 | 3L C | 90 | 8.00 elements | yes | 7 |  | 2 |  | 3
installation | HH1 | L A G | 93 | 4 elements | 4 lanterns / day = (8*3+7)*3m=93lm one element | 2 |  | 7 |  | 2
installation | HH1 | A P | 51 |  | TBC | 0 |  | 1 |  | 1
installation | HH1 | C W 80 |  | 1.5 column / day |  | 2 |  | 4 |  | 4
installation | HH1 | C W 30 | 3 | 1.5 column / day |  | 64 |  |  |  | 0
installation | HH1 | Mul |  | 3.5 elements | 1,5 hours / side which is consiting of 4 tubes with approx 13m height | 0 |  |  |  | 0
installation | HH1 | B W |  |  | is either 6 elements with 3 meter or 5 elements. Hence 5.5 | 2 |  | 4 |  | 6
installation | HH2 | 3L C | 90 | 8.00 elements | yes | 0
installation | HH2 | L A G | 93 | 4 elements | 4 lanterns / day = (8*3+7)*3m=93lm one element | 0
installation | HH2 | A P | 51 |  |  | 0
installation | HH2 | C W 80 |  | 1.5 column / day |  | 0
installation | HH2 | C W 60 | 3 | 1.5 column / day |  | 0
installation | HH2 | Mul |  | 3.5 elements | 1,5 hours / side which is consiting of 4 tubes with approx 13m height | 0
installation | HH2 | B W |  |  | is either 6 elements with 3 meter or 5 elements. Hence 5.5 | 0
installation | EP | 1 L C | 45 | 7.00 elements | 6 to 8 panels / day = 7 | 0 |  |  |  | 4
installation | EP | A P | 27 |  |  | 0 |  |  |  | 2
installation | EP | B W | 27 |  |  | 0 |  |  |  | 2
installation | NP | 1 L C | 45 | 7.00 elements | 6 to 8 panels / day = 7 | 0
installation | NP | A P | 27 |  |  | 0
installation | NP | B W | 27 |  |  | 0
installation | EBN | 3 L C | 90 | 6.00 elements | yes | 0 |  | 0 |  | 0
installation | EBN | L A G | 93 |  |  | 0
installation | EBN | A P | 51 |  |  | 0
installation | EBN | B W |  |  |  | 0
installation | E HH1 | 3L C | 90 | 8.00 elements | yes | 0
installation | E HH1 | L A G | 93 | 4 elements | 4 lanterns / day = (8*3+7)*3m=93lm one element | 0
installation | E HH1 | A P | 51 |  |  | 0
installation | E HH1 | C W 80 |  | 1.5 column / day |  | 0
installation | E HH1 | C W 30 | 3 | 1.5 column / day |  | 0
installation | E HH1 | B W |  |  | is either 6 elements with 3 meter or 5 elements. Hence 5.5 | 0