tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889646d1740550475-automate-numerical-identifier-formula-richud90-worked-example-v2-365-aligw
Sheet: Sheet2

 |  | Start No
 |  | 1001
Equipment | Equipment No | Numerical Identifier | SPILL
Motor | Motor 1
Motor | Motor 1 |  | 1001
Motor | Motor 1 |  | 1001 | These figures are what I want the formula to formulate automatically using the information in column B. All equipment must start at number in Cell C2. This is to automatically assign a unique numerical number against and equipment but the number shouldn’t change if the equipment is the same. example below
Fan | Fan 1 |  | 1001
Pump | Pump 1 |  | 1001
Pump | Pump 2 |  | 1002
Pump | Pump 2 |  | 1002 | If someone selects Motor 1 = 1001
Gearbox | Motor 1 |  | 1001 | If another Motor 1 is selcted it will also be 1001.
Pump | Pump 2 |  | 1002 | If [NAME] is selected that will NOT be 1002, it will be 1001 because Fan is unique to motor.
Gearbox | [NAME] |  | 1001 | If [NAME] is then selected the formula will know " Motor 1 - 1001" has already occurred and therefore will be 1002.
Gearbox | [NAME] |  | 1002
Gearbox | [NAME] |  | 1002
Spreadsheet: 540823d1506987959-index-match-return-all-unique-values-book4
Sheet: Sheet1

Series | ID
A | 187512
A | 199954
A | 187512
B | 199954
B | 187512
B | 111411
C | 111411
B | 199954
D | 111411
C | 187512
A | 111411
C | 199954
D | 199954
A | 111411
C | 187512
A | 111411
C | 199954
B | 111411
D | 187512
D | 111411
B | 199954
A | 187512
Spreadsheet: 681775d1591736782-need-help-on-sumifs-for-horizontal-and-vertical-criteria-from-2-different-tabs-test
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  | What I need
 | CNN | ALABEL_CONT | 315480.24210288 | 1135165.754609993 | 1071306.625136332 | 667796.802792415 |  |  | Sheet1 | CNN | ALABEL_CONT | Q1 | 315480.24210288
 | CNN | COGS_CC | 55207.44856978 | 160759.3861043007 | 93302.44596697259 | 88920.7411886433 |  |  | Sheet1 | CNN | ALABEL_CONT | Q2 | 1135165.754609993
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | ALABEL_CONT | Q3 | 1071306.625136332
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | ALABEL_CONT | Q4 | 667796.802792415
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q1 | 55207.44856978
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q2 | 160759.3861043007
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q3 | 93302.44596697259
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q4 | 88920.7411886433
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q1 | 0.3648460706249971
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q2 | 0.3648460706249971
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q3 | 0.3980660706250019
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q4 | 0.401199710625
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q1 | 1.459384282499988
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q2 | 1.459384282499988
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q3 | 1.592264282500008
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q4 | 1.6047988425
Spreadsheet: 167305d1341948314-excel-2007-conditionally-formatting-pivot-tables-cf-pivot-sum
Sheet: Sheet1

Category | Amt
Cat1 | 1 |  |  | CF of Sum Less than 10.
Cat2 | 1
Cat3 | 1 |  |  | Row Labels | Sum of Amt
Cat4 | 3 |  |  | Cat1 | 9
Cat5 | 4 |  |  | Cat2 | 1
Cat1 | 2 |  |  | Cat3 | 12
Cat2 | 0 |  |  | Cat4 | 5
Cat3 | 9 |  |  | Cat5 | 10
Cat4 | 2 |  |  | Grand Total | 37
Cat5 | 3
Cat1 | 2
Cat2 | 0
Cat3 | 2
Cat4 | 0
Cat5 | 1
Cat1 | 4
Cat2 | 0
Cat3 | 0
Cat4 | 0
Cat5 | 2
Spreadsheet: 195044d1353407116-how-to-count-example
Sheet: Sheet2

Gender | Subject 1 | Subject 2 | Subject 3 |  |  | M |  |  | F
M | A | A | A |  |  | A | B | C | A | B | C
F | B | A | A |  | Subject 1
M | C | C | C |  | Subject 2
F | A | B | A |  | Subject 3
F | A | B | C
M | C | A | A
Spreadsheet: 159948d1338910799-excel-2007-help-i-need-help-with-if-logics-and-or-conditional-formulas-new-to-this-excel-help-assembly-modified-by-tigeravatar-
Sheet: Assigned Areas

Area | Employee
Inspection | Dawn
Axial | [NAME]
Coat | Dale
Wave | [NAME]
Post Wave | [NAME]
Hardware | [NAME]
Assembly | [NAME]
Kitting | Rosemary
Wave Insp. | 0
[NAME] | Angie
Spreadsheet: 32b44f92-b206-4f9c-a828-3af8e2aed458
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
HBRPB | Test | HBRPB | Histoplasma capsulatum/Blastomyces dermatitidis, Molecular Detection, PCR, Blood | Histoplasma/Blastomyces PCR, B | Real-Time Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  | 4 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 5 mL Collection Instructions: The high sensitivity of amplification by PCR requires the specimen to be processed in an environment in which contamination of the specimen by Histoplasma or Blastomyces species DNA is not likely. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Not applicable | Monday through Friday, 3 times per week | 1 day | 3 days | 2 | 87798 |  |  |  |  | Rochester
HBRPB | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 7 days
HBRPB | Order Question | SRC79 | Histo/Blasto Source |  | Plain Text
HBRPB | Result | SRC79 | Histo/Blasto Source | Histo/Blasto Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
HBRPB | Result | 32462 | Histo/Blasto Result | Histo/Blasto Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HBRPB | Result | 32453 | Special Information | Special Information | Alphanumeric
HBRPB | Result | 32464 | Report Status | Report Status | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 76085d1276666837-sumproduct-to-count-by-week-countif
Sheet: Sheet1

2010-08-01 00:00:00 | 32
2010-01-09 00:00:00 | 2
2010-06-06 00:00:00 | 24
2010-02-01 00:00:00 | 6
2010-02-15 00:00:00 | 8
2010-02-15 00:00:00 | 8
2010-06-21 00:00:00 | 26
2010-07-14 00:00:00 | 29
2010-03-02 00:00:00 | 10
2010-02-03 00:00:00 | 6
2010-06-01 00:00:00 | 23
2010-01-01 00:00:00 | 1
2010-04-01 00:00:00 | 14
2010-05-01 00:00:00 | 18
2010-05-01 00:00:00 | 18
2010-03-01 00:00:00 | 10
2010-03-01 00:00:00 | 10 |  | 2009-12-21 00:00:00
 |  |  | 2009-12-27 00:00:00
WeekNumber | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Number of Jobs | 1 | 1 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0
no. of jobs w/o weeknums | 1 | 1 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0
Spreadsheet: 846831d1697984469-create-dropdown-list-when-an-option-is-selected-in-b2-b44-dropdown-list_sample
Sheet: Here

S/N | W4 Type | W-4 (2020 or [NAME] (before 2020)? |  |  | Exempt |  | Exempt
1 | W-4 (before 2020) | Exempt |  |  | Single |  | Single
2 | W-4 (before 2020) |  |  |  | Married (Filing Jointly) |  | Married
3 | W-4 (before 2020) |  |  |  | Head of Household |  | Married but use Single rate
4 | W-4 (2020 or later) |  |  |  |  |  | Non-Resident Alien
5 | W-4 (2020 or later)
6 | W-4 (2020 or later)
7 | W-4 (2020 or later)
8 | W-4 (2020 or later)
9 | W-4 (2020 or later)
10 | W-4 (2020 or later)
11 | W-4 (2020 or later)
12 | W-4 (2020 or later)
13 | W-4 (2020 or later)
14 | W-4 (2020 or later)
15 | W-4 (2020 or later)
16 | W-4 (2020 or later)
17 | W-4 (2020 or later)
18 | W-4 (2020 or later)
19 | W-4 (2020 or later)
20 | W-4 (2020 or later)
21 | W-4 (2020 or later)
22 | W-4 (2020 or later)
23 | W-4 (2020 or later)
24 | W-4 (2020 or later)
25 | W-4 (2020 or later)
26 | W-4 (2020 or later)
27 | W-4 (2020 or later)
28 | W-4 (2020 or later)
29 | W-4 (2020 or later)
30 | W-4 (2020 or later)
31 | W-4 (2020 or later)
32 | W-4 (2020 or later)
33 | W-4 (2020 or later)
34 | W-4 (2020 or later)
35 | W-4 (2020 or later)
36 | W-4 (2020 or later)
37 | W-4 (2020 or later)
38 | W-4 (2020 or later)
39 | W-4 (2020 or later)
40 | W-4 (2020 or later)
41 | W-4 (2020 or later)
42 | W-4 (2020 or later)
43 | W-4 (2020 or later)
Spreadsheet: 185380d1349688722-vlookup-based-on-2-lookup_values-vlookup-1
Sheet: Sheet1

 | [NAME] letter: | a |  | Insert Number :
 |  |  |  |  |  |  |  |  |  | a | 1 | blue
 |  |  |  |  |  |  |  |  |  | b | 2 | black
 |  |  |  |  |  |  |  |  |  | c | 3 | green
 |  |  |  |  |  |  |  |  |  | d | 4 | red
 |  |  |  |  |  |  |  |  |  | e | 5 | yellow
 |  |  |  |  |  |  |  |  |  | f | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  | g | 7 | pink
 |  |  |  |  |  |  |  |  |  | h | 8 | purple
 |  |  |  |  |  |  |  |  |  | i | 9 | grey
 |  |  |  |  |  |  |  |  |  | j | 10 | orange
Spreadsheet: 35345d1232969647-excel-2007-sort-a-dynamic-range-alphabetically-excel-forum-example
Sheet: Address Book

Employee ID | Name | Address | Telephone Number
EMP001 | [NAME] | 1 The High Street | (01234) 455667
EMP002 | [NAME] | 2 The Cresent | (01234) 779955
EMP003 | [NAME] | "Farm House Cottage", The Avenue | (01234) 342669
EMP004 | [NAME] | 2 The Cresent | (01234) 779955
EMP005 | [NAME] | 45 Haven Road | (01344) 324675
Spreadsheet: 114801d1310506948-record-the-difference-between-a-newly-imputed-number-and-the-one-before-it-test
Sheet: Old Entry

January Numbers as of 01/01/2011
Name | # | W1 | [NAME] | U1 | U2 | EMS | Com. | Total | Change
name | 7 | 10 | 5
name | 8 | 20 | 10
name | 9 | 30 | 5
name | 10 | 40 | 20
name | 13 | 80 | 25
name | 16 | 60 | 30
name | 19 | 70 | 35
name | 20 | 80 | 30
name | 23 | 90 | 45
---------------------------------------------------------------------------------
name | 21 |  |  | 1 | 3 | 5 | 7
name | 22 |  |  | 8 | 4 | 6 | 8
 |  |  |  |  | W Total
 |  |  |  |  | U, EMS, & Com Total
 |  |  |  |  | TOTAL
 |  | "Old Entry" and "New Entry and Change" are not actually different sheets, I just did it this way for visual purposes. They should be the same sheet, with "Old Entry" being the before, and "New Entry and Change" being the after
Spreadsheet: 79821d1280055078-automatic-updating-sample-workbook
Sheet: Battalion Perstat

Battalion PERSTAT
Last Name | First Name | Position | ORG | Location | Status
[NAME] | [NAME] | [NAME] | [NAME] | PM FWD HQ | Duty
Barnes | [NAME] | LOG Assistant [NAME] | JLI | PM FWD HQ | Duty
Carrillo | [NAME] | Material Handler | JLI | PM FWD HQ | Duty
[NAME] | [NAME] | [NAME] | JLI | PM FWD HQ | LWOP
[NAME] | Carnell | Operations Tech | JLI | PM FWD HQ | Duty
Spreadsheet: 115859d1311340869-excel-claim-sorting-date-sorting-for-claims-1-
Sheet: Sheet1

2010-02-02 00:00:00 | 2011-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2006-02-02 00:00:00 | To | 2007-02-01 00:00:00
Serial | Date | Paid | Oustanding | Total | Title |  |  |  |  |  |  | 2007-02-02 00:00:00 | To | 2008-02-01 00:00:00
4 | 2011-02-01 00:00:00 | 6545 | 6554 | 13099 | TH |  |  |  |  |  |  | 2008-02-02 00:00:00 | To | 2009-02-01 00:00:00
5 | 2011-01-31 00:00:00 | 554 | 4545 | 5099 | MD |  |  |  |  |  |  | 2009-02-02 00:00:00 | To | 2010-02-01 00:00:00
6 | 2011-01-28 00:00:00 | 545 | 44 | 589 | EL |  |  |  |  |  |  | 2010-02-02 00:00:00 | To | 2011-02-01 00:00:00
7 | 2011-01-27 00:00:00 | 500 | 454 | 954 | PL |  | Note: | Select the date from Cell A1 |  |  |  | 2011-02-02 00:00:00 | To | 2012-02-01 00:00:00
8 | 2011-01-26 00:00:00 | 522 | 5454 | 5976 | EL |  |  | Copy paste the formula in A3:F3 below
9 | 2011-01-25 00:00:00 | 12132 | 5454 | 17586 | PL |  |  | Hide column M:O
10 | 2011-01-24 00:00:00 | 6545 | 54 | 6599 | PL |  |  | there is similar formula in A3&C3:F3
11 | 2011-01-21 00:00:00 | 554 | 454 | 1008 | PL |  |  | There is separate formula in B3
12 | 2011-01-20 00:00:00 | 545 | 45 | 590 | PL |  |  | These are array formulas and should be confirmed throgh Ctrl+Shift+Enter
13 | 2011-01-19 00:00:00 | 500 | 454 | 954 | EL
14 | 2011-01-19 00:00:00 | 522 | 45 | 567 | EL
15 | 2011-01-17 00:00:00 | 12132 | 454 | 12586 | EL
17 | 2011-01-13 00:00:00 | 554 | 45 | 599 | MD
18 | 2011-01-12 00:00:00 | 545 | 45 | 590 | MD
19 | 2011-01-11 00:00:00 | 500 | 45 | 545 | MD
20 | 2011-01-10 00:00:00 | 522 | 45 | 567 | MD
21 | 2011-01-07 00:00:00 | 12132 | 45 | 12177 | TH
22 | 2011-01-06 00:00:00 | 6545 | 45 | 6590 | TH
23 | 2011-01-05 00:00:00 | 554 | 45 | 599 | TH
24 | 2011-01-04 00:00:00 | 545 | 45 | 590 | TH
25 | 2011-01-03 00:00:00 | 500 | 45 | 545 | TH
26 | 2010-12-30 00:00:00 | 522 | 4 | 526 | EL
27 | 2010-12-29 00:00:00 | 12132 | 54 | 12186 | EL
28 | 2010-12-28 00:00:00 | 6545 | 5457545 | 5464090 | EL
29 | 2010-12-27 00:00:00 | 554 | 45 | 599 | EL
30 | 2010-12-23 00:00:00 | 545 | 45 | 590 | EL
31 | 2010-12-22 00:00:00 | 545 | 45 | 590 | EL
#N/A |  | #N/A | #N/A | #N/A | #N/A
#N/A |  | #N/A | #N/A | #N/A | #N/A
#N/A |  | #N/A | #N/A | #N/A | #N/A
#N/A |  | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 23c6ca8d-c7a8-4c98-93c7-d6ab9371a31c
Sheet: Criteria

Department | Amount | Vendor
English | 25 | Campus Graphics
English | 205 | Sodexho
Theology | 2089 | Sodexho
Dean's Office | 3200 | Sodexho
Theology | 89 | Campus Graphics
Bioethics | 239 | OfficeMax
Bioethics | 2049 | Sodexho
Dean's Office | 38 | OfficeMax
Classics | 400 | OfficeMax
Classics | 450 | Sodexho
English | 56.9 | Sodexho
Philosophy | 67.9 | Sodexho
Philosophy | 230 | Campus Graphics
Modern Languages | 4500 | Campus Graphics
Modern Languages | 209 | Sodexho
Modern Languages | 38 | Campus Graphics
Philosophy | 500 | Sodexho
Modern Languages | 700 | OfficeMax
English | 20 | OfficeMax
History | 900 | Campus Graphics
Sociology | 890 | Campus Graphics
Psychology | 750 | OfficeMax
Psychology | 75 | Campus Graphics
Sociology | 90 | Campus Graphics
History | 2000 | Sodexho
English | 50 | Campus Graphics
History | 905 | Campus Graphics
History | 203 | Sodexho
Psychology | 450 | OfficeMax
Psychology | 780 | OfficeMax
Psychology | 90 | OfficeMax
Modern Languages | 87.5 | OfficeMax
Dean's Office | 2000 | Sodexho
Bioethics | 48 | Campus Graphics
Spreadsheet: 778015d1650787756-work-shifts-with-monthly-update-works-1-
Sheet: mese

Anno | 2022 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1 |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P2 |  |  |  |  |  |  | Sat
A |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N1 |  |  |  |  |  |  | Sat
 |  | 2 | R2 | M1 | M2 | P1 | P2 |  | N1 | N2 | R1 | R2 | M1 | M2 |  | P1 | P2 | N1 | N2 | R1 | R2 |  | M1 | M2 | P1 | P2 | N1 | N2 |  | R1 |  |  |  |  |  | N2 |  |  |  |  |  |  | Sat
 |  | 3 | R2 | M1 | M2 | P1 | P2 |  | N1 | N2 | R1 | R2 | M1 | M2 |  | P1 | P2 | N1 | N2 | R1 | R2 |  | M1 | M2 | P1 | P2 | N1 | N2 |  | R1 | R2 | M1 | M2 |  |  | R1
 |  | 4 | P1 | P2 |  | N1 | N2 | R1 | R2 | M1 | M2 |  | P1 | P2 | N1 | N2 | R1 | R2 |  | M1 | M2 | P1 | P2 | N1 | N2 |  | R1 | R2 | M1 | M2 | P1 | P2 |  |  |  | R2
 |  | 5 | N1 | N2 | R1 | R2 | M1 | M2 |  | P1 | P2 | N1 | N2 | R1 | R2 |  | M1 | M2 | P1 | P2 | N1 | N2 |  | R1 | R2 | M1 | M2 | P1 | P2 |  | N1 | N2
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12299 | 10388 | -556
2 | 11706 | 10732 | -472
3 | 11910 | 10841 | -486
4 | 10885 | 10906 | -523
5 | 11935 | 10912 | -570
6 | 11321 | 10866 | -565
7 | 10936 | 10786 | -410
8 | 10657 | 10786
9 | 17477 | 10786
10 | 12031 | 10913 | -1
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  | 542879.87
2001-07-10 00:00:00
Spreadsheet: 737888d1624638775-nested-if-function-to-pull-info-from-multiple-cells-sample
Sheet: Manning Table W1 & W2

ASSIGNMENT MANNING TABLE
WEEK 1 | WED | THU | FRI | SAT | SUN | MON | TUE
 | 2021-07-21 00:00:00
MH/C5
G9/ER
IF(AND('Week 1 & 2'!B64="Laurie",'Week 1 & 2'!C65="MH"),"No One", "Laurie"),(AND('Week 1 & 2'!B64="Laurie",'Week 1 & 2'!D65="MH"),"No One", "[NAME]"))
Spreadsheet: 852329d1702396677-help-with-formula-current-tool-aligw
Sheet: Customer 2 codes

Customer 2
Buyer Code | Correct Code
SDD-020006 | H7917-00006
SDD-020020 | H7917-00020
SDD-020054 | H7917-00054
SDD-020060 | H7917-00060
SDD-020067 | H7917-00067
SDD-020073 | H7917-00073
SDD-020080 | H7917-00080
[NAME] | H7917-00089
SDD-020507 | H7917-00507
SDD-020555 | H7917-00555
SDD-020634 | H7917-00634
SDD-020645 | H7917-00645
SDD-020700 | H7917-00700
SDD-020744 | H7917-00744
SDD-020774 | H7917-00774
SDD-020803 | H7917-00803
SDD-020881 | H7917-00881
SDD-021036 | H7917-01036
SDD-021039 | H7917-01039
SDD-021081 | H7917-01081
SDD-021083 | H8070-00001
SDD-021084 | H8070-00002
SDD-021085 | H9347
SDD-021086 | H9330
SDD-021087 | H8070-00005
SDD-021088 | H8070-00006
SDD-021089 | H8070-00007
SDD-021090 | H8070-00008
Spreadsheet: 48819d1248118386-pulling-data-by-name-in-column-sample
Sheet: Sheet1

Spreadsheet 1 |  |  |  |  |  | Spreadsheet 2
Employee # | Employee Name | Org | Score
234 | [NAME] | Finance | 40 |  |  |  | Average Score | Highest Score | Lowest Score | Standard Deviation
346 | [NAME] | Finance | 45 |  |  | Finance | 41
879 | Fred | Finance | 43 |  |  | Design | 0
978 | [NAME] | Finance | 42
314 | Scott | Design | 37
393 | [NAME] | Design | 39
839 | [NAME] | Design | 41
Spreadsheet: 118413d1313670420-look-for-value-in-columns-quest18-08
Sheet: Sheet1

 |  |  | How it should be
1 |  |  | 1 |  |  | 1 |  |  |  | If there is a number in cell G4, note in cell b4 a 0 if the following number is higher then a 1. If the following number is a 1 note a 1
2
3
4
5 |  |  | 1 |  |  | 1
6 |  |  | 0 |  |  | 1
7 |  |  | 0 |  |  | 2
8
9
10
11
12
13 |  |  | 1 |  |  | 3
14
15 |  |  | 0 |  |  | 1
16 |  |  | 0 |  |  | 2
17
18
19
20 |  |  | 0 |  |  | 3
21 |  |  | 1 |  |  | 4
22 |  |  | 1 |  |  | 1
23 |  |  |  |  |  | 1
24
25
26
27
28
29
Spreadsheet: 32404d1228516628-vlookup-formula-sample-of-vlooup
Sheet: 2

RECIPE CALCULATOR
ingredient | servings in recipe | serving size as per label | cal / serving | total calories | fat | total fat | sat fat | total sat fat | carbs | total carbs | sugar | total sugar | fiber | total fiber | protein | total protein |  | sodium | total sodium | calcium | total calcium | chol | total cholesterol
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DIRECTIONS:
total calories per recipe ===> | 0
servings per recipe ===>
calories per serving ===>
fat per recipe === > | 0
fat per serving ===>
sat fat per recipe ===> | 0
sat fat per serving ===>
carbs per recipe ===> | 0
carb per serving ===>
sugar per recipe ===> | 0
sugar per serving ===>
fiber per recipe ===> | 0
fiber per serving ===>
protein per recipe ===> | 0
protein per serving ===>
Spreadsheet: 195303d1353481506-timetable-conditional-formatting-day-sheet-template
Sheet: Sheet1

 |  |  |  | Names
Event |  | Time |  | [NAME] | Woody | [NAME] | [NAME] | [NAME] | [NAME] | Gwyn | [NAME] | [NAME] | [NAME]
1 |  | 08:00:00
1 |  | 08:05:00
2 |  | 08:10:00
3 |  | 08:15:00
4 |  | 08:20:00
4 |  | 08:25:00
5 |  | 08:30:00
5 |  | 08:35:00
6 |  | 08:40:00
 |  | 08:45:00
 |  | 08:50:00
 |  | 08:55:00
 |  | 09:00:00
 |  | 09:05:00 |  |  |  |  | 1
 |  | 09:10:00
 |  | 09:15:00
 |  | 09:20:00
 |  | 09:25:00
 |  | 09:30:00
 |  | 09:35:00
 |  | 09:40:00
 |  | 09:45:00
 |  | 09:50:00
 |  | 09:55:00
 |  | 10:00:00
 |  | 10:05:00
 |  | 10:10:00
 |  | 10:15:00
 |  | 10:20:00
 |  | 10:25:00
 |  | 10:30:00
 |  | 10:35:00
 |  | 10:40:00
 |  | 10:45:00
 |  | 10:50:00
 |  | 10:55:00
 |  | 11:00:00
 |  | 11:05:00
 |  | 11:10:00
 |  | 11:15:00
 |  | 11:20:00
 |  | 11:25:00
 |  | 11:30:00
 |  | 11:35:00
 |  | 11:40:00
 |  | 11:45:00
 |  | 11:50:00
 |  | 11:55:00
 |  | 12:00:00
 |  | 12:05:00
 |  | 12:10:00
 |  | 12:15:00
 |  | 12:20:00
 |  | 12:25:00
 |  | 12:30:00
 |  | 12:35:00
 |  | 12:40:00
 |  | 12:45:00
 |  | 12:50:00
 |  | 12:55:00
 |  | 13:00:00
 |  | 13:05:00
 |  | 13:10:00
 |  | 13:15:00
 |  | 13:20:00
 |  | 13:25:00
 |  | 13:30:00
 |  | 13:35:00
 |  | 13:40:00
 |  | 13:45:00
 |  | 13:50:00
 |  | 13:55:00
 |  | 14:00:00
 |  | 14:05:00
 |  | 14:10:00
 |  | 14:15:00
 |  | 14:20:00
 |  | 14:25:00
 |  | 14:30:00
 |  | 14:35:00
 |  | 14:40:00
 |  | 14:45:00
 |  | 14:50:00
 |  | 14:55:00
 |  | 15:00:00
 |  | 15:05:00
 |  | 15:10:00
 |  | 15:15:00
 |  | 15:20:00
 |  | 15:25:00
 |  | 15:30:00
Spreadsheet: 93336d1292940457-var-difference-on-pivot-table-book1
Sheet: Sheet1

Month | Report Date | Sold | Capacity
APR | 2010-12-15 00:00:00 | 718 | 2808
APR | 2010-12-15 00:00:00 | 4143 | 8802
APR | 2010-12-15 00:00:00 | 5454 | 17532
APR | 2010-12-15 00:00:00 | 2862 | 7824
AUG | 2010-12-15 00:00:00 | 705 | 4638
AUG | 2010-12-15 00:00:00 | 1036 | 8910
AUG | 2010-12-15 00:00:00 | 613 | 3732
FEB | 2010-12-15 00:00:00 | 604 | 1128
FEB | 2010-12-15 00:00:00 | 1363 | 3492
FEB | 2010-12-15 00:00:00 | 1832 | 7308
FEB | 2010-12-15 00:00:00 | 1071 | 2088
JAN | 2010-12-15 00:00:00 | 814 | 1557
JAN | 2010-12-15 00:00:00 | 2392 | 4032
JAN | 2010-12-15 00:00:00 | 4772 | 8172
JAN | 2010-12-15 00:00:00 | 1564 | 2142
JUL | 2010-12-15 00:00:00 | 1216 | 4545
JUL | 2010-12-15 00:00:00 | 1546 | 8766
JUL | 2010-12-15 00:00:00 | 813 | 3912
JUN | 2010-12-15 00:00:00 | 1060 | 4485
JUN | 2010-12-15 00:00:00 | 1098 | 8649
JUN | 2010-12-15 00:00:00 | 973 | 3732
MAR | 2010-12-15 00:00:00 | 930 | 2256
MAR | 2010-12-15 00:00:00 | 2718 | 7914
MAR | 2010-12-15 00:00:00 | 3480 | 16236
MAR | 2010-12-15 00:00:00 | 1742 | 3774
MAY | 2010-12-15 00:00:00 | 1443 | 4482
MAY | 2010-12-15 00:00:00 | 1447 | 8910
MAY | 2010-12-15 00:00:00 | 1025 | 3900
OCT | 2010-12-15 00:00:00 | 187 | 4665
OCT | 2010-12-15 00:00:00 | 167 | 8964
OCT | 2010-12-15 00:00:00 | 120 | 4014
SEP | 2010-12-15 00:00:00 | 514 | 4545
SEP | 2010-12-15 00:00:00 | 527 | 8766
SEP | 2010-12-15 00:00:00 | 329 | 3912
APR | 2010-12-20 00:00:00 | 365 | 1404
APR | 2010-12-20 00:00:00 | 2114 | 4401
APR | 2010-12-20 00:00:00 | 2758 | 8766
APR | 2010-12-20 00:00:00 | 1482 | 3912
AUG | 2010-12-20 00:00:00 | 733 | 4638
AUG | 2010-12-20 00:00:00 | 1047 | 8910
AUG | 2010-12-20 00:00:00 | 623 | 3732
FEB | 2010-12-20 00:00:00 | 617 | 1128
FEB | 2010-12-20 00:00:00 | 1387 | 3492
FEB | 2010-12-20 00:00:00 | 1919 | 7308
FEB | 2010-12-20 00:00:00 | 1082 | 2088
JAN | 2010-12-20 00:00:00 | 826 | 1557
JAN | 2010-12-20 00:00:00 | 2420 | 4032
JAN | 2010-12-20 00:00:00 | 5008 | 8172
JAN | 2010-12-20 00:00:00 | 1589 | 2142
JUL | 2010-12-20 00:00:00 | 1265 | 4686
JUL | 2010-12-20 00:00:00 | 1620 | 9027
JUL | 2010-12-20 00:00:00 | 849 | 4080
JUN | 2010-12-20 00:00:00 | 1103 | 4485
JUN | 2010-12-20 00:00:00 | 1123 | 8649
JUN | 2010-12-20 00:00:00 | 981 | 3732
MAR | 2010-12-20 00:00:00 | 470 | 1128
MAR | 2010-12-20 00:00:00 | 1387 | 3957
MAR | 2010-12-20 00:00:00 | 1824 | 8118
MAR | 2010-12-20 00:00:00 | 874 | 1887
MAY | 2010-12-20 00:00:00 | 1451 | 4482
MAY | 2010-12-20 00:00:00 | 1522 | 8910
MAY | 2010-12-20 00:00:00 | 1036 | 3900
OCT | 2010-12-20 00:00:00 | 338 | 4665
OCT | 2010-12-20 00:00:00 | 376 | 8964
OCT | 2010-12-20 00:00:00 | 226 | 4014
SEP | 2010-12-20 00:00:00 | 554 | 4545
SEP | 2010-12-20 00:00:00 | 576 | 8766
SEP | 2010-12-20 00:00:00 | 333 | 3912