tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b80954c9-86c5-4cb5-ac83-4c9afbe44e4d
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
PEAN | Test | PEAN | Peanut, IgE | Peanut, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in 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
PEAN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PEAN | Result | PEAN | Peanut, IgE | Peanut, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6206-7 | Arachis hypogaea [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 181333d1347996453-index-and-matching-formula-combination-excel-help-3
Sheet: Sheet1

 | Average | Low | Low Date | High | High Date
Yearly
Quarterly
YTD
6 month
3 month
 | A/R | Sales | DSO |  |  |  | A/R | Sales | DSO |  |  |  | A/R | Sales | DSO
2007 | 15000000 | 35000000 |  |  | 2010 | Q1 |  |  |  |  | 2010 | January | 4000000 | 1400000
2008 | 90000000 | 50000000 |  |  |  | Q2 |  |  |  |  |  | February | 3000000 | 1400000
2009 | 74000000 | 35000000 |  |  |  | Q3 |  |  |  |  |  | March | 2000000 | 1400000
2010 |  |  |  |  |  | Q4 |  |  |  |  |  | April | 2000000 | 1400000
2011 |  |  |  |  | 2011 | Q1 |  |  |  |  |  | May | 2000000 | 1400000
2012 |  |  |  |  |  | Q2 |  |  |  |  |  | June | 2000000 | 1400000
2013 |  |  |  |  |  | Q3 |  |  |  |  |  | July | 2000000 | 1565000
2014 |  |  |  |  |  | Q4 |  |  |  |  |  | August | 2000000 | 1565000
2015 |  |  |  |  | 2012 | Q1 |  |  |  |  |  | September | 2000000 | 1565000
2016 |  |  |  |  |  | Q2 |  |  |  |  |  | October | 2000000 | 1565000
2017 |  |  |  |  |  | Q3 |  |  |  |  |  | November | 2000000 | 1565000
2018 |  |  |  |  |  | Q4 |  |  |  |  |  | December | 2000000 | 1565000
2019 |  |  |  |  | 2013 | Q1 |  |  |  |  | 2011 | January | 2000000 | 1565000
 |  |  |  |  |  | Q2 |  |  |  |  |  | February | 2000000 | 1565000
 |  |  |  |  |  | Q3 |  |  |  |  |  | March | 2000000 | 1565000
 |  |  |  |  |  | Q4 |  |  |  |  |  | April | 2000000 | 1565000
 |  |  |  |  | 2014 | Q1 |  |  |  |  |  | May | 2000000 | 1565000
 |  |  |  |  |  | Q2 |  |  |  |  |  | June | 2000000 | 1565000
 |  |  |  |  |  | Q3 |  |  |  |  |  | July | 2000000 | 1565000
 |  |  |  |  |  | Q4 |  |  |  |  |  | August | 2000000 | 1565000
 |  |  |  |  | 2015 | Q1 |  |  |  |  |  | September | 2000000 | 1565000
 |  |  |  |  |  | Q2 |  |  |  |  |  | October | 2000000 | 1565000
 |  |  |  |  |  | Q3 |  |  |  |  |  | November | 2000000 | 1565000
 |  |  |  |  |  | Q4 |  |  |  |  |  | December | 2000000 | 1565000
Spreadsheet: 769032d1645263677-remove-blank-data-in-printout-in-excel-sample-sheet-prinout-hide
Sheet: Sheet1

Price List
Description | Price | Qty | Amount
Product1 | 4557 | 96
Product2 | 2844 | 32
Product3 | 1189 | 0
Product4 | 4824 | 42
Product5 | 4929 | 100
Product6 | 4440 | 59
Product7 | 4890
Product8 | 4914 | 34
Product9 | 3283 | 26
Product10 | 4711 | 5
Product11 | 3346 | 36
Product12 | 3347 | 75
Product13 | 2133
Product14 | 4331 | 30
Product15 | 3316 | 24
 |  | Total
Spreadsheet: 758816d1639078004-macros-buttons-inventory-tracking-for-sales-and-products-no-clue-what-i-am-doing
Sheet: Display Sheet

Calculator |  |  | The cell below is linked to F3 for ease of use
 | Chocolate |  |  |  | 500
Current Situation
 | Buy ($/pint) | Sell ($/pint) |  | Bought (pints) | Sold (pints) | Purchases($) | Sales ($) | Profit ($ $) | Current Stock (pints)
 | =B21 | =B22 |  | =f3 when the "Buy+" button is pressed AND a number is put in D3 | =f3 when the "Sell-" button is pressed AND a number is put in D3 | =b8xe8 | =C8xF8 | =H7-(E8xB8)+(F8xc8) | this will be the value from B20+E8-F9
EXAMPLE BUY | 1 | 5 |  | 500 | 0
EXAMPLE SELL | 1 | 5 |  | 0 | 500
 | The numbers above are gathered by usign theg ray button below, that triggers the cells to the right for that flavor |  |  | The numbers above are gathered by using the "pints to buy/sell" and the button to the right (sell or buy). |  |  |  | A running profit total
Setup
 |  |  |  |  |  |  |  | 1.) | Stock (pints)
Chocolate |  |  |  |  | multiple buttons for each flavor ofered |  |  |  |  | is blank until the button to the left is pressed, the user will update that button in this area
Pints on hand: | 2 |  |  |  |  |  |  |  | Buy ($)
Cost per pint ($) | 1 |  |  |  |  |  |  |  |  | is blank until the button to the left is pressed, the user will update that button in this area
Sale per pint ($): | 5
 |  |  |  |  |  |  |  |  | Sell ($)
 |  |  |  |  |  |  |  |  |  | is blank until the button to the left is pressed, the user will update that button in this area
 |  |  |  |  |  |  |  |  | Save | this is grayed out until the user picks a button to the left, enters data for the stock, buy and sell, then presses SAVE
 |  |  |  |  |  |  |  |  | Reset | this button is active after a flavor is selected to left but it sets the stock, buy and sell to zero for the flavor selected
1.). User should select a gray button above to update the flavor informaiton.  This is updated to the right
2.). User will update the stock on hand, the buy price, the sell price, and click save.
3.). User can then pick the flavor fom the drop down in B3, which will then allow them to use the up/down arrors to enter the amoutn they are purchasing or selling.  OR they can enter a number in D3.
4.) user selects if they are buying or selling the pints in D3.
5.). A new row is entered on the data sheet to track all this info
6.). The flavor is updated with the latest informaiton on this [NAME] sheet so everyone can see the running totals, the buy or sell info and if we are currently running in the red.
Spreadsheet: 156207d1337224088-populate-data-only-when-project-is-complete-help1
Sheet: April

April ASSEMBLY PROJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.69
DATE | CODE | QTY | PULL SET UP | LENS PULL (105) | RECEIPT/LINE SET UP | LABELING | LENS PICKING | QI/MH | PALLET GRAB | Lot Check Labor | TOTAL LABOR | KITS/HR | COST/KIT | Comp
 | AVAIRA780X | 339 |  |  | 67.5 |  | 249.25 | 180.25 | 0.75 |  |  |  |  | x
 | PCC60 | 120 |  | 4.5 | 2 | 2.25 | 9.75 | 11.25 | 0.75 |  |  |  |  | x
 | PC1DCAN1080X | 9 |  |  | 1.25 |  | 0.5 | 0.5 | 0.25 |  |  |  |  | x
 | PC1D1200X | 350 |  | 4 | 2.75 | 16.25 | 18.5 | 39.25 | 1 |  |  |  |  | x
 | PCMF324NX | 360 |  | 9 | 52.25 | 75.75 | 109 | 65.25 | 3.25 |  |  |  |  | x
 | PC1DMF600X | 1080 |  |  | 29 | 52 | 62 | 70.25 | 5.75
 | BT324X | 500 |  |  | 27.75 | 2.5 |  |  | 2
 | BIOFINITY207X | 810 |  | 5.5 | 7.75 | 232.25 | 120.5 | 104.75 | 7 |  |  |  |  | x
 | PC1D1200X | 167 |  | 2 | 3 | 63 | 41.5 | 67.75 | 11.25
 | BFMF520X | 1350 |  |  | 211.5 | 278 | 194.5 | 198.75 | 22.25
 | AVAIRA780X | 521 |  |  | 34 | 11 | 311.25 | 139 | 9.5 |  |  |  |  | x
 | complete
Spreadsheet: 67377d1268023370-string-concatenation-of-values-sample-data
Sheet: Output

Group | Subgroup | Members | Remarks | Status | In-charge | Level | Units
Lopez | A | 1 | Sec A | Completed | [NAME] | Beginner | 12
[NAME] | B | 7 | Sec B | On-going | Siy | Proficient | 13
Martinez | A | 1 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 2 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 3 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 4 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 5 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 6 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | B | 7 | Sec C | Not started | [NAME] | Beginner | 21
[NAME] | A | 1 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 2 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 3 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 4 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 5 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 6 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | B | 7 | Sec D | Completed | [NAME] | Beginner | 20
Ramos | A | 1 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 2 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 3 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 4 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 5 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 6 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 7 | Sec E | Not started | Dy | Beginner | 16
Uy | A | 1 | Sec F | On-going | Han | Proficient | 11
Uy | A | 2 | Sec F | On-going | Han | Proficient | 11
Uy | A | 3 | Sec F | On-going | Han | Proficient | 11
Uy | A | 4 | Sec F | On-going | Han | Proficient | 11
Uy | B | 7 | Sec F | On-going | Han | Proficient | 11
Uy | C | 8 | Sec F | On-going | Han | Proficient | 11
[NAME] | B | 7 | Sec G | Started | Niy | Proficient | 13
[NAME] | C | 8 | Sec H | Completed | [NAME] | Proficient | 11
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 129260 | 129182
2 | 126748 | 122113
3 | 123158 | 122442
4 | 107561 | 106472
5 | 111357 | 111062
6 | 113863 | 113152
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -36642
2001-08-06 00:00:00
Spreadsheet: 50609d1250088971-problem-with-lookup-formula-missing-values-extracting-example2
Sheet: Sheet1

If 6 spades cost £4.80, how much does 1 spade cost?
If 6 goldfishes cost £15.30, how much does 1 goldfish cost?
If 4 beanbags cost £38.00, how much does 1 beanbag cost?
If 7 torches cost £36.75, how much does 1 torch cost?
If 4 calculators cost £31.96, how much does 1 calculator cost?
If 9 frisbees cost £28.98, how much does 1 frisbee cost?
If 3 onions cost £1.95, how much does 1 onion cost?
If 8 rucksacks cost £10.32, how much does 1 rucksack cost?
Spreadsheet: 743376d1628449767-formula-to-lookup-multiple-names-with-a-criteria-example-book1
Sheet: Sheet1

Full Name | Department | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 |  | ADD | ACT
Name1 | ADD | 0 | 0
[NAME] | GR | 7 | 0
Name3 | ACT | 0 | 0
Name4 | ADD | 13 | 0
Name5 | SW | 0 | 0
Name6 | SW | 0 | 20
Name7 | SW | 22 | 0
Name8 | SW | 0 | 0
Name9 | CT | 0 | 0
Name10 | CT | 0 | 0
Name11 | CT | 0 | 0
Name12 | CT | 0 | 0
Name13 | CT | 0 | 0
Name14 | CT | 0 | 11
Name15 | CT | 10 | 8
[NAME] | CT | 0 | 0
Name17 | CT | 0 | 0
Name18 | CT | 0 | 0
Name19 | CT | 0 | 12
[NAME] | ACT | 0 | 0
Name21 | CT | 0 | 16
Name22 | CT | 13 | 0
Name23 | CT | 0 | 4
Name24 | CT | 0 | 0
Name25 | CT | 0 | 0
Name26 | CT | 0 | 0
Name27 | CT | 0 | 0
Name28 | SW | 20 | 0
Name29 | CT | 0 | 0
Name30 | ADD | 7 | 0
Name31 | SW | 0 | 0
Name32 | GR | 0 | 0
Name33 | CT | 0 | 0
[NAME] | SW | 0 | 25
Name35 | CT | 0 | 0
Name36 | SW | 19 | 14
Name37 | ADD | 0 | 0
Name38 | CT | 0 | 0
[NAME] | SW | 0 | 13
Name40 | ADD | 0 | 0
Name41 | IT | 35 | 0
Name42 | ADD | 0 | 18
Name43 | CT | 0 | 0
Name44 | SW | 0 | 0
Name45 | SW | 17 | 14
Name46 | CT | 0 | 0
[NAME] | RT | 0 | 0
Name48 | GR | 0 | 0
Name49 | SV | 13 | 0
Name50 | CT | 0 | 0
Spreadsheet: 167889d1342138265-how-to-find-matches-names-and-weeks-between-2-pivot-tables-example
Sheet: Feuil1

ACTUAL HOURS PER WEEK |  |  |  | Forecasted Hours - Ressource Planning 2012
Empl Name & Initials | Week Ending Date | Total |  | Empl Name & Initials | Forecasted Weeks | Total
[NAME] | 2011-12-30 00:00:00 | 0.9 |  | [NAME] | Somme de 12/30/2011
 | 2012-01-06 00:00:00 | 0.8 |  |  | Somme de 01/06/2012
 | 2012-01-13 00:00:00 | 1.125 |  |  | Somme de 01/13/2012
 | 2012-01-20 00:00:00 | 0.675 |  |  | [NAME]
 | 2012-01-27 00:00:00 | 0.9 |  |  | Somme de 01/27/2012
 | 2012-02-03 00:00:00 | 1.125 |  |  | [NAME] 02/03/2012
 | 2012-02-17 00:00:00 | 0.9 |  |  | Somme de 02/10/2012
 | 2012-02-24 00:00:00 | 1.125 |  |  | Somme de 02/17/2012
 | 2012-03-02 00:00:00 | 0.9 |  |  | [NAME]
 | 2012-03-09 00:00:00 | 1.125 |  |  | [NAME]
 | 2012-03-16 00:00:00 | 1.125 |  |  | Somme de 03/09/2012
 | 2012-03-23 00:00:00 | 0.9 |  |  | Somme de 03/16/2012
 | 2012-03-30 00:00:00 | 1.125 |  |  | [NAME]
 | 2012-04-06 00:00:00 | 1.125 |  |  | Somme de 03/30/2012 | 1.1
 | 2012-04-13 00:00:00 | 1.125 |  |  | Somme de 04/06/2012 | 1.1
 | 2012-04-20 00:00:00 | 1.125 |  |  | [NAME] | 1.1
 | 2012-04-27 00:00:00 | 1.125 |  |  | [NAME] 04/20/2012 | 1.1
 | 2012-05-04 00:00:00 | 0.9 |  |  | Somme de 04/27/2012 | 1.1
 | 2012-05-11 00:00:00 | 1.125 |  |  | [NAME] | 1.1
 | 2012-05-18 00:00:00 | 1.125 |  |  | [NAME] | 1.1
 | 2012-05-25 00:00:00 | 1.125 |  |  | Somme de 05/18/2012 | 1.1
 | 2012-06-01 00:00:00 | 1.125 |  |  | [NAME] | 0.8
 | 2012-06-08 00:00:00 | 1.125 |  |  | Somme de 06/01/2012 | 1.1
 | 2012-06-15 00:00:00 | 1.125 |  |  | Somme de 06/08/2012 | 1.1
 | 2012-06-22 00:00:00 | 1.125 |  |  | [NAME] | 1.1
 | 2012-06-29 00:00:00 | 1.125 |  |  | Somme de 06/22/2012 | 0.9
 | 2012-07-06 00:00:00 | 1.125 |  |  | [NAME] | 0.9
Spreadsheet: 830457d1684930643-finding-1st-2nd-3rd-and-4th-largest-numbers-in-a-range-of-cells-find-values-in-a-range
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | 2nd | 3rd | 4th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 4 | 0 | 5 | 0 | 0 | 13 | 144 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct Answers-> |  | 144-9 | 13-8 | 5-5 | 4-3
Spreadsheet: 873778d1720348164-how-to-find-total-of-working-hours-from-a-single-cell-kvemperor-working-hours-shop-aligw
Sheet: july

[NAME] | 31 |  |  | ΡΕΠΟ
ΞΕΚΙΝΑΕΙ | 2024-07-01 00:00:00
ΒΗΜΑ | 1
 | ΙΟΥΛΙΟΣ |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ |  |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ
 |  | 11:00-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-22:00 | 15:00-21:00
 | 2024-07-02 00:00:00 | 09:30-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16:00-21:00
 | 2024-07-03 00:00:00 | 09:30-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16:00-21:00
 | 2024-07-04 00:00:00 | ΟΡΘΟΠΑΙΔΙΚΟΣ |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16:00-21:00
 | 2024-07-05 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:01 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16:00-21:00
 | 2024-07-06 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09:00-17:00 | 11:00-17:00 | ΡΕΠΟ | 09:00-22:00 | 17:00-22:00 | 09:00-22:00 | 16:00-21:00
 | 2024-07-07 00:00:00 | ΔΕΝ ΗΡΘΕ |  | ΡΕΠΟ | ΡΕΠΟ | 10:00-18:00 | 10:00-18:00 | ΡΕΠΟ | 10:00-18:00 | ΡΕΠΟ
 | 2024-07-08 00:00:00
 | 2024-07-09 00:00:00
 | 2024-07-10 00:00:00
 | 2024-07-11 00:00:00
 | 2024-07-12 00:00:00
 | 2024-07-13 00:00:00
 | 2024-07-14 00:00:00
 | 2024-07-15 00:00:00
 | 2024-07-16 00:00:00
 | 2024-07-17 00:00:00
 | 2024-07-18 00:00:00
 | 2024-07-19 00:00:00
 | 2024-07-20 00:00:00
 | 2024-07-21 00:00:00
 | 2024-07-22 00:00:00
 | 2024-07-23 00:00:00
 | 2024-07-24 00:00:00
 | 2024-07-25 00:00:00
 | 2024-07-26 00:00:00
 | 2024-07-27 00:00:00
 | 2024-07-28 00:00:00
 | 2024-07-29 00:00:00
 | 2024-07-30 00:00:00
 | 2024-07-31 00:00:00
Spreadsheet: 700380d1603176191-power-query-or-formulas-or-vba-pq-formulas-or-vba-joseph
Sheet: FINISHED

Order | Items | Picker ID | Box Type | Packer ID | [NAME]
1001 | X123 | 11, 12 | LRG | 9 | 2020-10-19 00:00:00
1001 | Z324 | 11 | LRG | 9 | 2020-10-19 00:00:00
1001 | T223 | 11 | LRG | 3 | 2020-10-19 00:00:00
1002 | X123 | 3 | MED | 12 | 2020-10-19 00:00:00
1002 | T223 | 4 | MED | 12 | 2020-10-19 00:00:00
1002 | X123 | 7, 11, 25 | MED | 12 | 2020-10-19 00:00:00
Using PivotTable:
Packer ID |  |  |  |  | Picker ID
Order | Items | Box Type | Packer ID | [NAME] | 3 | 4 | 7 | 11 | 12 | 25
1001 | T223 | LRG | 3 | 2020-10-19 00:00:00 |  |  |  | 1
 | X123 | LRG | 9 | 2020-10-19 00:00:00 |  |  |  | 1 | 1
 | Z324 | LRG | 9 | 2020-10-19 00:00:00 |  |  |  | 1
1002 | T223 | MED | 12 | 2020-10-19 00:00:00 |  | 1
 | X123 | MED | 12 | 2020-10-19 00:00:00 | 1 |  | 1 | 1 |  | 1
Grand Total |  |  |  |  | 1 | 1 | 1 | 4 | 1 | 1
Spreadsheet: 478755d1473043050-excel-formula-to-convert-data-range-to-columns-excel-formula-to-convert-data-range-to-columns
Sheet: Sheet1

 |  |  |  |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre#
 |  |  |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4
 |  |  |  |  |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus
 | Table of Contents
Employee | Work Centre# | Bonus
[NAME] | 1 | 253
[NAME] | 2 | 255
[NAME] | 3 | 277
[NAME] | 4 | 244
Duanne Busch | 6 | 256 |  |  |  |  | need Excel formula/s to create output in coloumns as above please
[NAME] | 6 | 277
Ingrid Jones | 5 | 288 |  |  |  |  | [NAME] does not work as the dominant factor is the work centre # followed by employee name with bonus in decending order.
[NAME] | 5 | 211
[NAME] | 7 | 166 |  |  |  |  | any help is welcome, thank you!
[NAME] | 3 | 287
[NAME] | 3 | 261
[NAME] | 4 | 259
[NAME] | 1 | 258
[NAME] | 6
[NAME]
Ingrid Jones | 7 | 299
[NAME]
[NAME] | 2 | 122
[NAME] | 3 | 166
Spreadsheet: 748487d1632164241-vlookup-hlookup-with-variable-to-lookup-formula-help-tomato-variable
Sheet: Sheet1

 |  |  |  |  |  |  |  | manually enter name in one of these 3 columns if it’s a vegetable that is supposed to be a fruit
 | Notes in red you can delete |  |  |  |  |  |  | Carrot | Turnip | Red Onion
 |  |  |  |  |  |  | Fruit? | yes | yes |  |  | only put a "yes" value in if the vegetable is supposed to be a fruit
 |  |  |  |  |  |  |  | enter any questionable items as vegetables in the ref list
Fruits
Produce | Carrot | Turnip | Pear | Red onion | Apple
Veggies
Fruits
Produce | [NAME] | Basil | Scallion | Red onion | cherry
Veggies
Fruits
Produce | Yucca | Snap Pea | [NAME] | Turnip
Veggies
Spreadsheet: john_griffith__16146__1_24_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG G2 | 205 | 14 | 15.5 | 81.8 | 90.5 | 11.1 | 2002-01-24 14:59:00
 | NG H2 | 210 | 33 | 35 | 66.8 | 70.9 | 9.09 | 2002-01-24 14:59:00
 | NG J2 | 215 | 38 | 39 | 55.1 | 56.5 | 7.54 | 2002-01-24 14:59:00
 | NG K2 | 225 | 44 | 45.5 | 49.7 | 51.4 | 7.15 | 2002-01-24 14:59:00
 | NG M2 | 235 | 49 | 51 | 45.6 | 47.4 | 6.87 | 2002-01-24 14:59:00
 | NG N2 | 245 | 57.5 | 58.5 | 46.5 | 47.3 | 7.22 | 2002-01-24 14:59:00
 | NG Q2 | 250 | 63.5 | 66 | 46.1 | 48 | 7.4 | 2002-01-24 14:59:00
 | NG U2 | 250 | 69 | 71 | 46.4 | 47.8 | 7.4 | 2002-01-24 14:59:00
 | NG V2 | 250 | 75 | 78 | 47.6 | 49.5 | 7.63 | 2002-01-24 14:59:00
 | NG X2 | 280 | 86.5 | 89.5 | 46.3 | 47.9 | 8.29 | 2002-01-24 14:59:00
 | [NAME] | 295 | 96 | 99 | 46.6 | 48.1 | 8.78 | 2002-01-24 14:59:00
 | NG F3 | 305 | 107 | 111 | 48.3 | 50.1 | 9.43 | 2002-01-24 14:59:00
 | NG H3 |  |  |  |  |  |  | 2002-01-22 14:46:00
 | NG M3 |  |  |  |  |  |  | 2002-01-07 10:05:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 3 MONTHS ENDED 3-31-2000
PREPARED BY:  ROSALYN LUM
EXTENSION: [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2001 |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2010 |  | 12-31-2015 |  | 12-31-2020 |  | after 12-31-2020 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 01e37d8b-aa10-4c63-9a83-976d8600211b
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
EC | Test | EC | Serologic Agglut Method Ident | Serologic Agglut Method 2 Ident |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87147 |  |  |  |  | Rochester
EC | [NAME] | VARIES | Varies |  |  |  | See instructions