tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lisa_gang__22235__EPE_MARCH_2002
Sheet: MARCH(12)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-12 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | FOUR CORNERS |  | PALO VERDE | PALO VERDE | PALO VERDE
Pacific | Mountain | SALE | SALE |  | PURCHASE | PURCHASE | PURCHASE
Standard | Standard | EPMI | EPMI |  | EPMI | EPMI | MIRANT
Time | Time | 22.25 | 22.25 |  | 121 | 121 | 141.5
 |  | CARRY OVER FROM 3/11 | ON GOING DAILY |  | ON GOING DAILY | ON GOING DAILY | ONGOING DAILY
 |  | 3/1/02-3/31/02 | 3/1/02-3/31/02 |  | 3/1/02-3/31/02 | 3/1/02-3/31/02 | 3/1/02-3/31/02
 |  | EPMI TAG#41387 | EPMI TAG#41424 |  | EPMI TAG#41427 | EPMI TAG#41426 | EPMI TAG#41434 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL |  | DIRECT BILL | DIRECT BILL | DIRECT BILL
2400 | 0100 | 25 | 0 |  | 0 | 0 | 0
0100 | 0200 | 0 | 25 |  | 0 | 0 | 0
0200 | 0300 | 0 | 25 |  | 0 | 0 | 0
0300 | 0400 | 0 | 25 |  | 0 | 0 | 0
0400 | 0500 | 0 | 25 |  | 0 | 0 | 0
0500 | 0600 | 0 | 25 |  | 0 | 0 | 0
0600 | 0700 | 0 | 25 |  | 0 | 0 | 0
0700 | 0800 | 0 | 0 |  | -25 | -25 | -25
0800 | 0900 | 0 | 0 |  | -25 | -25 | -25
0900 | 1000 | 0 | 0 |  | -25 | -25 | -25
1000 | 1100 | 0 | 0 |  | -25 | -25 | -25
1100 | 1200 | 0 | 0 |  | -25 | -25 | -25
1200 | 1300 | 0 | 0 |  | -25 | -25 | -25
1300 | 1400 | 0 | 0 |  | -25 | -25 | -25
1400 | 1500 | 0 | 0 |  | -25 | -25 | -25
1500 | 1600 | 0 | 0 |  | -25 | -25 | -25
1600 | 1700 | 0 | 0 |  | -25 | -25 | -25
1700 | 1800 | 0 | 0 |  | -25 | -25 | -25
1800 | 1900 | 0 | 0 |  | -25 | -25 | -25
1900 | 2000 | 0 | 0 |  | -25 | -25 | -25
2000 | 2100 | 0 | 0 |  | -25 | -25 | -25
2100 | 2200 | 0 | 0 |  | -25 | -25 | -25
2200 | 2300 | 0 | 0 |  | -25 | -25 | -25
2300 | 2400 | 0 | 25 |  | 0 | 0 | 0
2400 | 0100 | 0 | 25 |  | 0 | 0 | 0
 | MST Total |  |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  | TOTAL SALES |  |  |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)4C |  | PINWEST(G)PV | PINWEST(G)PV | PINWEST(G)PV
 |  | EPMI | EPMI |  | AEP | EPME | MIRANT
 |  | AZPS(T)FC3/PPD2 | AZPS(T)FC3/PPD2 |  | EPMI | AEP | EPE
 |  | WALC(T)PPD2/COOLIDGE | WALC(T)PPD2/COOLIDGE |  | EPE | EPMI | EPMI
 |  | CRSP(L)COOLIDGE | CRSP(L)COOLIDGE |  | EPE(T)PV/WW | EPE | EPE
 |  |  |  |  | TEP(T)WW/SP3 | EPE(T)PV/WW | EPE(T)PV/WW
 |  |  |  |  | EPE(T)SP3/LUNA | TEP(T)WW/SP3 | TEP(T)WW/SP3
 |  |  |  |  |  | EPE(T)SP3/LUNA | EPE(T)SP3/LUNA
 |  |  |  |  |  | EPE(L)LUNA | EPE(L)LUNA
Spreadsheet: 750080d1633223082-find-count-consecutive-entries-in-a-row-in-excel-counting
Sheet: Sheet2

 | 5 | a | 1
 | 4 | b
 | 4 | c
 | 1 | d
 | 3 | e
 | 2 | f
 | 5 | g
 | 1 | h
 | 3 | i
 | 4 | j
Spreadsheet: cfe104a7-6036-4ace-82f0-38171ebd1eb1
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
TAKRO | Test | TAKRO | Tacrolimus, Blood | Tacrolimus, B | High-Performance Liquid Chromatography/Tandem Mass Spectrometry (HPLC-MS/MS) | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions:  1. Draw blood immediately before a schedule dose.  2. Do not centrifuge.  3. Send specimen in original tube. Additional Information:  1. Therapeutic range applies to trough specimens drawn immediately prior to a.m. dose. 2. For specimens sent ambient, sirolimus analysis cannot be performed. If both are ordered, only tacrolimus result will be released. If sirolimus analysis is desired, specimen must be sent refrigerated or frozen. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Cold OK; Warm reject Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 5.0-15.0 ng/mL | Monday through Sunday; 1 p.m | Same day/1 day | 2 days | 1 | 80197 |  |  |  |  | Rochester
TAKRO | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 14 days
TAKRO | Result | 35145 | Tacrolimus, B | Tacrolimus, B | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 70033d1270683688-sumproduct-will-not-handle-multiple-criteria-sumproduct
Sheet: Sheet1

a | 1 | 10 |  |  |  |  | 30 |  | 1 | 2 | 3
b | 1 | 10
c | 2 | 10 |  |  |  |  |  |  | named range "rng"
a | 3 | 10
c | 1 | 10 |  |  |  |  |  |  | does not work with vertical range
a | 4 | 10
b | 3 | 10
a | 4 | 10
s | 2 | 10
a | 3 | 10
Spreadsheet: 714764d1611350715-vlookup-with-duplicates-search-and-avoid-duplicates
Sheet: Search

Company | Origin | Type | Size | Prior | Multiple | Score | Year | Count | Timing | Price | Exp | Name | Site | License | Reference
Electricians
^ | In-Person | Long Term | Small | No | No | 44 | 2019 | 1 | Fast | Low | high | [NAME] | FL | B345 | Q2 | <
Search Criteria | Phone | Rapid | Tiny | No | No | 67 | 2020 | 1 | Fast | Avg | Low | [NAME] | TX | N/A | Q4 | < | Desired output
 | Phone | Emergency | Mid | Yes | Yes | 67 | 2020 | 1 | Slow | Avg | Low | [NAME] | AL | b1v2c5 | Q4 | <
Should Return list of all matching | Phone | Long Term | Large | Yes | No | 64 | 2021 | 1 | Fast | Avg | Low | Randall | FL | C435 | Q4 | <
entries from contractors sheet
---->
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1
2 |  |  |  | 3639
3 | 4302 |  |  | 3639
4 |  |  |  | 3639
5 | 18615 |  |  | 10000
6 | 26699 |  |  | 26000
7 | 56421 |  |  | 55000
8 | 23123 |  |  | 22806
9 | 301 |  |  | 2577
10 |  |  |  | 2577
11 | 1242 |  |  | 2577
12 | 19627 |  |  | 20408
13 | 3631 |  |  | 5000
14 | 17373 |  |  | 16000
15 | 63088 |  |  | 61408
16 | 15643 | 11182 | 77567 | 80510
17 |  | 11182 | 92407 | 80510
18 | 37058 | 922 | 45734 | 80510
19 |  |  | 158 | 6000
20 | 6044 |  |  | 5000
21 | 12320 |  |  | 12191
22 | 23789 |  |  | 22000
23 | 45408 |  | 36242 | 81399
24 | 44990 |  | 40010 | 81399
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  |  |  | 61895
 | 2001-06-24 00:00:00
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Hoverter

 |  |  | 2014 Hoverter Homes F.E. Delivery Calendar
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | 2nd & 4th Thursdays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: 859800d1708049337-convert-data-in-list-form-in-a-single-cell-to-data-into-individual-rows-single-cell-data-to-multiple-rows
Sheet: Sheet1

Beta 125 RR 2T 2020 - 2023 Beta 125 RR 2T RACING 2020 - 2023 Beta 200 RR 2T 2020 - 2023 Beta 250 RR 2T 2020 - 2023  Beta 300 RR 2T 2020 - 2023  Beta 250 RR 2T RACING 2020 - 2023 Beta 300 RR 2T RACING 2020 - 2023  Beta 350 RR 4T 2020 - 2023 Beta 390 RR 4T 2020 - 2023  Beta 430 RR 4T 2020 - 2023  Beta 480 RR 4T 2020 - 2023  Beta 350 RR 4T RACING 2020 - 2023 Beta 390 RR 4T RACING 2020 - 2023  Beta 430 RR 4T RACING 2020 - 2023  Beta 480 RR 4T RACING 2020 - 2023 | This is how the current data is formatted - list in a single cell
Below is how I need the data - each row of data in separate cells
Beta 125 RR 2T 2020 - 2023
Beta 125 RR 2T RACING 2020 - 2023 | Beta 125 RR 2T RACING 2020 - 2023
Beta 200 RR 2T 2020 - 2023 | Beta 200 RR 2T 2020 - 2023
Beta 250 RR 2T 2020 - 2023 | Beta 250 RR 2T 2020 - 2023
Beta 300 RR 2T 2020 - 2023 | Beta 300 RR 2T 2020 - 2023
Beta 250 RR 2T RACING 2020 - 2023 | Beta 250 RR 2T RACING 2020 - 2023
Beta 300 RR 2T RACING 2020 - 2023 | Beta 300 RR 2T RACING 2020 - 2023
Beta 350 RR 4T 2020 - 2023 | Beta 350 RR 4T 2020 - 2023
Beta 390 RR 4T 2020 - 2023 | Beta 390 RR 4T 2020 - 2023
Beta 430 RR 4T 2020 - 2023 | Beta 430 RR 4T 2020 - 2023
Beta 480 RR 4T 2020 - 2023 | Beta 480 RR 4T 2020 - 2023
Beta 350 RR 4T RACING 2020 - 2023 | Beta 350 RR 4T RACING 2020 - 2023
Beta 390 RR 4T RACING 2020 - 2023 | Beta 390 RR 4T RACING 2020 - 2023
Beta 430 RR 4T RACING 2020 - 2023 | Beta 430 RR 4T RACING 2020 - 2023
Beta 480 RR 4T RACING 2020 - 2023 | Beta 480 RR 4T RACING 2020 - 2023
Spreadsheet: 42742d1241337244-various-index-match-problems-workbook-v2
Sheet: Sublevels Progress 1 year

[NAME] 8 | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A | Total
Male | 0 | 0 | 0 | 1 | 3 | 5 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 17
Female | 0 | 0 | 0 | 1 | 1 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 11
Total | 0 | 0 | 0 | 2 | 4 | 8 | 10 | 4 | 0 | 0 | 0 | 0 | 0 | 28
[NAME] 8 | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A | Total
SEN | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 6
G&T | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 4
Traveller | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cedar 8 | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A | Total
Male | 0 | 0 | 2 | 1 | 5 | 10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 19
Female | 0 | 0 | 0 | 2 | 6 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13
Total | 0 | 0 | 2 | 3 | 11 | 15 | 1 | 0 | 0 | 0 | 0 | 0 |  | 32
Cedar 8 | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A | Total
SEN | 0 | 0 | 1 | 0 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
G&T | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
Traveller | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Linden 8 | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A | Total
Male | 0 | 0 | 1 | 0 | 4 | 6 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 17
Female | 0 | 0 | 0 | 3 | 2 | 2 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 12
Total | 0 | 0 | 1 | 3 | 6 | 8 | 7 | 3 | 1 | 0 | 0 | 0 | 0 | 29
Linden 8 | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A | Total
SEN | 0 | 0 | 0 | 2 | 2 | 2 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 9
G&T | 0 | 0 | 1 | 0 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 7
Traveller | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2
Maple 8 | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A | Total
Male | 0 | 0 | 0 | 2 | 4 | 7 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 17
Female | 1 | 0 | 0 | 1 | 4 | 3 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 13
Total | 1 | 0 | 0 | 3 | 8 | 10 | 5 | 1 | 1 | 0 | 0 | 0 | 1 | 30
Maple 8 | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A | Total
SEN | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 6
G&T | 0 | 0 | 0 | 0 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 5
Traveller | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
Spreadsheet: 163829d1340475792-help-matching-data-in-sheet1-based-on-data-on-sheet2-sample2-pphg-oeldere-
Sheet: Sheet1

MEMBERSHIP_CARD_NO | MEMBERSHIP_LEVEL | RESORT | COUNTRY | DEPARTURE_DATE | NUMBER_NIGHTS | MONTH | YEAR | count | count / year
8815879251 | GOLD | PPBKK | MY | 2010-08-08 00:00:00 | 14 | 8 | 2010 | 1 | 1
8005707061 | GOLD | PPBKK | JP | 2010-02-01 00:00:00 | 4 | 2 | 2010 | 1 | 1
8910102045 | GOLD | PPBKK | MY | 2010-09-01 00:00:00 | 4 | 9 | 2010 | 1 | 1
8567232761 | GOLD | PPBKK | JP | 2010-08-02 00:00:00 | 4 | 8 | 2010 | 1 | 1
8448577501 | PLATINUM | [NAME] | US | 2012-03-29 00:00:00 | 2 | 3 | 2012 | 1 | 1
8503518596 | GOLD | [NAME] | US | 2012-05-29 00:00:00 | 2 | 5 | 2012 | 1 | 1
8796533379 | GOLD | [NAME] | US | 2012-04-28 00:00:00 | 1 | 4 | 2012 | 1 | 1
8811307853 | GOLD | PPXMN | NL | 2011-04-03 00:00:00 | 1 | 4 | 2011 | 1 | 1
8811307853 | BLACK | PPXMN | DE | 2011-01-05 00:00:00 | 3 | 1 | 2011 | 2 | 2
8219114250 | GOLD | PPXMN | AU | 2011-12-04 00:00:00 | 2 | 12 | 2011 | 1 | 1
8182449820 | GOLD | PPXMN | TW | 2011-04-07 00:00:00 | 3 | 4 | 2011 | 1 | 1
8206496735 | GOLD | PPXMN | CN | 2011-09-05 00:00:00 | 1 | 9 | 2011 | 1 | 1
8815879251 | GOLD | PPBKK | MY | 2011-08-08 00:00:00 | 14 | 8 | 2011 | 2 | 1
8815879251 | GOLD | PPBKK | MY | 2012-08-08 00:00:00 | 14 | 8 | 2012 | 3 | 1
8005707061 | GOLD | PPBKK | JP | 2011-02-01 00:00:00 | 4 | 2 | 2011 | 2 | 1
8005707061 | GOLD | PPBKK | JP | 2012-02-01 00:00:00 | 4 | 2 | 2012 | 3 | 1
8910102045 | GOLD | PPBKK | MY | 2011-09-01 00:00:00 | 4 | 9 | 2011 | 2 | 1
8910102045 | GOLD | PPBKK | MY | 2011-09-01 00:00:00 | 4 | 9 | 2011 | 3 | 2
8815879251 | GOLD | PPBKK | MY | 2010-08-07 00:00:00 | 14 | 8 | 2010 | 4 | 2
8910102045 | GOLD | PPBKK | MY | 2012-06-01 00:00:00 | 4 | 6 | 2012 | 4 | 1
8815879251 | GOLD | PPBKK | MY | 2010-08-08 00:00:00 | 14 | 8 | 2010 | 5 | 3
8815879251 | GOLD | PPBKK | MY | 2010-08-06 00:00:00 | 14 | 8 | 2010 | 6 | 4
8815879251 | GOLD | PPBKK | MY | 2010-08-15 00:00:00 | 14 | 8 | 2010 | 7 | 5
8005707061 | GOLD | PPBKK | JP | 2010-03-01 00:00:00 | 4 | 3 | 2010 | 4 | 2
8005707061 | GOLD | PPBKK | JP | 2010-04-01 00:00:00 | 4 | 4 | 2010 | 5 | 3
 |  |  |  |  |  |  |  |  |  |  | Count of NUMBER_NIGHTS | Column Labels
 |  |  |  |  |  |  |  |  |  |  | Row Labels | 2010 | 2011 | 2012 | Grand Total
 |  |  |  |  |  |  |  |  |  |  | 8005707061 | 3 | 1 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  | 8182449820 |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  | 8206496735 |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  | 8219114250 |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  | 8448577501 |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 8503518596 |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 8567232761 | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 8796533379 |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 8811307853 |  | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  | 8815879251 | 5 | 1 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  | 8910102045 | 1 | 2 | 1 | 4
 |  |  |  |  |  |  |  |  |  |  | Grand Total | 10 | 9 | 6 | 25
Spreadsheet: 267779d1380202357-highlighting-passed-dates-based-on-a-negative-figure-contraload-deliveries-into-purfleet
Sheet: Forward Production Requirements

 |  |  |  |  | Starting Stock | 150
Production Date | Tool | Order Reference | [NAME] | Qty per Pallet | No. Pallets |  |  |  | Stock Checks
2013-10-14 00:00:00 | 13985 | 13/0015/1/42 | 547008 | 2072 |  |  |  |  | 2013-09-23 00:00:00
2013-10-01 00:00:00 | 14139 | 13/0708/2/38-PLASTIC | 20250 | 2025
2013-10-08 00:00:00 | 14138 | 13/0707/2/40 | 126000 | 4200
2013-11-04 00:00:00 | 14139 | 13/07082/45-PLASTIC | 20250 | 2025
2013-11-11 00:00:00 | 13985 | 13/0015/1/45 | 532504 | 2072
2013-11-11 00:00:00 | 14138 | 13/0707/2/46 | 105000 | 4200
2013-12-09 00:00:00 | 13985 | 13/0015/1/50 | 476560 | 2072
2013-12-09 00:00:00 | 14138 | 13/0707/2/50 | 75600 | 4200
Spreadsheet: 772011d1646960743-vlookup-xlookup-idk-pls-help-help
Sheet: Data Before Formulas

Product Title | List of Makes | List of Models | Car Make if product title (A) contains a Make from entire Col. B | Car Model if product title (A) contains a Model from entire Col. C
Audi R8 Lights | Audi | R8
Chevy Camaro Lights | Chevy | Camaro
[NAME] | Ford | Mustang
Chevy [NAME] | Toyota | Supra
Toyota [NAME]
Ford [NAME]
BMW M4 Wing
[NAME]
Spreadsheet: 390592d1429701646-create-formula-with-drop-down-list-instant-quote
Sheet: Sheet2

 | GRADE |  |  |  |  |  | EQUATION
 | Grade | USD |  |  |  |  |  | USD |  | [NAME] ([NAME]) | Surcharge
 | 304 | 2180 |  |  |  |  | Grade | 3410 |  | 50 - 599 | 0.0109
 | 304L | 2210 |  |  |  |  | Finish | 0 |  | 600 - 999 | 0.0105
 | 316L | 3410 |  |  |  |  | Thks | 80 |  | 1000 | 30
 | 410S | 1160 |  |  |  |  | [NAME] | 0.09 |  | 1219 / 1250 | 0
 | 430 | 1240 |  |  |  |  | SUM | 3804.1
 | FINISH
 | Finish | USD |  |  |  |  | DROP DOWN LIST
 | 2BB | 0
 | BA | 80
 |  |  |  |  |  |  | Grade | Finish | Thickness | [NAME] ([NAME]) | FINAL PRICE
 |  |  |  |  |  |  | 316L | 2BB | 0.8 | 50 - 599 | 3805
 | WIDTH
 | [NAME] | USD
 | 50 - 599 | 0.09
 | 600 - 999 | 0.05
 | 1000 | 30
 | THICKNESS
 | Thickness | USD
 | 1.2 | 50
 | 1 | 65
 | 0.9 | 65
 | 0.8 | 80
 | 0.7 | 100
 | 0.6 | 115
 | 0.5 | 130
 | 0.4 | 200
 | 0.3 | 300
 | 0.28 | 360
Spreadsheet: 57746d1257959618-returning-all-rows-from-table-that-match-certain-criteria-overdue-indexkey
Sheet: AllAccounts

Date Due | Invoice | Company | Total | Paid | Overdue
2008-01-01 00:00:00 | 1 | Company A | 345 | Yes
2009-06-01 00:00:00 | 2 | Company A | 654 | No
2009-12-01 00:00:00 | 3 | Company A | 2123 | No
2009-01-01 00:00:00 | 4 | Company A | 258 | No
2009-08-01 00:00:00 | 5 | Company B | 122 | No
2009-12-01 00:00:00 | 6 | Company A | 35
2009-01-01 00:00:00 | 7 | Company C | 654 | Yes
2009-06-01 00:00:00 | 8 | Company C | 234
Spreadsheet: 854702d1704472005-shift-work-sick-leave-and-hours-worked-calculator-sample-sheet-5-1-
Sheet: Inputs

Types of Shifts | Hours calculated
OT | 12 |  | Overtime shift
RDO | 0 |  | RDO
Nightshift | 12 |  | Nightshift
Day Shift | 12 |  | Dayshift
Leave | 0 |  | Leave
Training day 8 Hours | 8 |  | Training day 8 hours
Sick | 0 |  | Sick
WC | 12 |  | WC
Overtime shift
RDO
Nightshift
Dayshift
Leave
Training day 8 hours
Sick
WC
WC =
Spreadsheet: 853054d1703005642-sumifs-with-date-and-1-other-criteria-scheduling-kansas-press-calc
Sheet: DODG 7420

T1 |  | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 |  |  | Dodg 7420 | 36 | 14 | 20 | PAP-SO-0040 - 48X96 20PT STYRENE | 1 | 4 Pass | 2023-12-26 00:00:00 |  | T2
Spreadsheet: 221305d1363461081-if-function-and-the-12-tones-of-the-piano-book1
Sheet: Sheet1

13 | C |  | "C","C#","D","Eb","E","F","F#","G","G#","A","Bb","B"
Shg | C |  | C=1, 13, 25, 37, … but also -11, -23, -35, ….
 |  |  | C#= 2, 14, 26, … but also -10, -22, -34, …
marcol | C
 |  |  |  |  |  | 12
 |  |  |  |  |  | 11
 |  |  |  |  |  | 10
 |  |  |  |  |  | 9
 |  |  |  |  |  | 8
 |  |  |  |  |  | 7
 |  |  |  |  |  | 6
 |  |  |  |  |  | 5
 |  |  |  |  |  | 4
 |  |  |  |  |  | 3
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  | 4
 |  |  |  |  |  | 5
 |  |  |  |  |  | 6
 |  |  |  |  |  | 7
 |  |  |  |  |  | 8
 |  |  |  |  |  | 9
 |  |  |  |  |  | 10
 |  |  |  |  |  | 11
 |  |  |  |  |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
 |  |  |  |  |  | 15
 |  |  |  |  |  | 16
 |  |  |  |  |  | 17
 |  |  |  |  |  | 18
 |  |  |  |  |  | 19
 |  |  |  |  |  | 20
 |  |  |  |  |  | 21
 |  |  |  |  |  | 22
 |  |  |  |  |  | 23
 |  |  |  |  |  | 24
Spreadsheet: 040be80e-39bc-4395-a79b-4f7fcae27b5d
Sheet: Sheet1

TRAVEL EXPENSE VOUCHER - SAMPLE FOR STUDENT
Name:  [NAME] |  |  |  | Deliver check to (mailing address): |  |  |  | DEPARTMENT USE ONLY
 |  |  |  | 1492 Commonwealth Drive |  |  |  | Cost Center/WBSE | Commitment Item |  | Amount
[NAME] ID:  @83045382 |  |  |  | Indiana, PA  15701
Purpose of Travel:
Professional presentation at the American College of Sports Medicine (ACSM) Conference |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | TRAVEL OFFICE USE ONLY
 |  |  |  |  |  |  |  | Vendor Number:________________________      1099
 |  |  |  |  |  |  |  | Travel Officer:___________     Date:_________  Yes   No
Itinerary |  |  |  |  | Transportation and Lodging |  |  |  | Miscellaneous
Date | Leave | Return | List Locations |  | Pers Auto | Provider Name |  | Cash You |  |  | Cash You
 | Time | Time |  |  | Miles |  |  | Paid | Explanation |  | Paid
2009-03-09 00:00:00 | 08:00:00 | 09:30:00 | Indiana to Pittsburgh Airport |  | 75 |  |  |  | food (total for trip) |  | 75
2009-03-09 00:00:00 | 12:00:00 | 14:00:00 | Pittsburgh to Atlanta |  |  | Delta Airlines |  | 220
2009-03-09 00:00:00 |  |  |  |  |  | Sheraton Hotel |  | 125
2009-03-10 00:00:00 |  |  |  |  |  | Sheraton Hotel |  | 125
2009-03-11 00:00:00 | 07:00:00 | 09:00:00 | Atlanta to Pittsburgh
2009-03-11 00:00:00 | 09:30:00 | 11:00:00 | Pittsburgh Airport to Indiana |  | 75 |  |  |  | Airport parking |  | 20
 |  |  | Total Miles
 |  |  | Rate Per Mile |  | 0.565
 |  |  | Totals:
 |  |  |  |  | A |  |  | B |  |  | D
 |  |  |  |  |  | Total Reimbursement (A+B+C+D)
I certify that the statements and expenses claimed are in accordance with established university travel policies and were incurred in the performance of official duties.
______________________________________________________ |  |  |  |  |  |  | _____________________________________________________
[NAME]'s Signature                                              Date |  |  |  |  |  |  | Authorizing Signature                                               Date
Student:  Submit completed travel voucher, original receipts, and copy of conference program (with your presentation) to your department office the week
after travel is complete.  All receipts must be originals and must show proof of purchase.  Students are NOT eligible for state employee per diem rates.
Dept:   Forward original travel voucher and receipts to Travel Office, [NAME].  Use dept cost center and indicate maximum amount to be funded.
Forward copy of travel voucher and copy of conference program to [NAME] for Research, 122 Stright Hall to initiate transfer of funds.