tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 768750d1645107964-lookup-results-are-coming-up-offset-samplelookup
Sheet: 0216

Item | Description | RK | T | Class | On Hand | M | On Order | Column5 | Committed | Bckordered | UM | Last Cost | R | CT UM | Extension | Column1 | On Hand6 | UM7 | Cost | UM8 | Extension9 | Extension10 | Warehouse | Item10 | Serial Lot | Category
1/2X71.5WHD | TAN SPNG CORD GKT HI | B | B | A02 | 2600 |  | 242850 |  | 2600 | 9400 | EA | 716.39 |  | M | 1862.61 |  |  |  |  |  |  |  | UP | 1/2X71.5WHD
100-400RMWF217 | 100-400 RM WHITE  W/F217 | A | B | C27 | 1405 |  | 2500 |  | 80 | 0 | EA | 155.32 |  | M | 218.23 |  |  |  |  |  |  |  | UP | 100-400RMWF217
10090 | 15G SQR FIBER DRUM | E | B | C07 | 25 |  | 167 |  | 25 | 167 | EA | 11.05 |  | EA | 276.25 |  |  |  |  |  |  |  | GR | 10090
Spreadsheet: 148210d1333250169-i-need-help-with-volume-cuts-sheet-test-acc-cost-work-book
Sheet: Assembly

 | SYTEM 1 | Inch |  |  | SYTEM 2 | Inch |  |  | SYTEM 3 | Inch
C/M |  |  |  | C/M |  |  |  | C/M
T |  |  |  | T |  |  |  | T
B |  |  |  | B |  |  |  | B
Angl |  |  |  | Angl |  |  |  | Angl
Angl |  |  |  | Angl |  |  |  | Angl
# B |  |  |  | # B |  |  |  | # B
B Lft |  |  |  | B Lft |  |  |  | B Lft
B Rght |  |  |  | B Rght |  |  |  | B Rght
Lk/C |  |  |  | Lk/C |  |  |  | Lk/C
 | SYSTEM 4 | Inch |  |  | SYSTEM 5 | Inch |  |  | SYSTEM 6 | Inch
C/M |  |  |  | C/M |  |  |  | C/M
T |  |  |  | T |  |  |  | T
B |  |  |  | B |  |  |  | B
Angl |  |  |  | Angl |  |  |  | Angl
Angl |  |  |  | Angl |  |  |  | Angl
# B |  |  |  | # B |  |  |  | # B
B Lft |  |  |  | B Lft |  |  |  | B Lft
B Rght |  |  |  | B Rght |  |  |  | B Rght
Lk/C |  |  |  | Lk/C |  |  |  | Lk/C
 | SYSTEM 7 | Inch |  |  | SYSTEM 8 | Inch |  |  | SYSTEM 9 | Inch
C/M |  |  |  | C/M |  |  |  | C/M
T |  |  |  | T |  |  |  | T
B |  |  |  | B |  |  |  | B
Angl |  |  |  | Angl |  |  |  | Angl
Angl |  |  |  | Angl |  |  |  | Angl
# B |  |  |  | # B |  |  |  | # B
B Lft |  |  |  | B Lft |  |  |  | B Lft
B Rght |  |  |  | B Rght |  |  |  | B Rght
Lk/C |  |  |  | Lk/C |  |  |  | Lk/C
 | SYSTEM 10 | Inch |  |  | SYSTEM 11 | Inch |  |  | SYSTEM 12 | Inch
C/M |  |  |  | C/M |  |  |  | C/M
T |  |  |  | T |  |  |  | T
B |  |  |  | B |  |  |  | B
Angl |  |  |  | Angl |  |  |  | Angl
Angl |  |  |  | Angl |  |  |  | Angl
# B |  |  |  | # B |  |  |  | # B
B Lft |  |  |  | B Lft |  |  |  | B Lft
B Rght |  |  |  | B Rght |  |  |  | B Rght
Lk/C |  |  |  | Lk/C |  |  |  | Lk/C
 | SYSTEM 13 | Inch |  |  | SYSTEM 14 | Inch
C/M |  |  |  | C/M
T |  |  |  | T
B |  |  |  | B
Angl |  |  |  | Angl
Angl |  |  |  | Angl
# B |  |  |  | # B
B Lft |  |  |  | B Lft
B Rght |  |  |  | B Rght
Lk/C |  |  |  | Lk/C
Spreadsheet: d93b5017-f713-4e53-86ad-81c73cf85c42
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Empresario
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Autónomo
 | D/Dª: |  |  |  |  |  |  |  |  |  |  |  |  |  | DNI:
 | Tipo:
 | En nombre y representación de la sociedad
 | CIF: |  |  | , en [NAME]
 | Datos de contacto
 | Domicilio:
 | C.P.: |  |  | Localidad: |  |  |  |  |  |  |  |  | Provincia: | ALMERIA
 | Telófono: |  |  |  | Fax:
 | Correo electronico:
 | Página Web:
 | [NAME]:
 | [NAME]: Su voluntad expresa de pertenencia, como [NAME] a la Cámara de Comercio, Industria y Navegación de Almería, con todos los derechos y obligaciones que establece la Ley 3/1993, Básica de Cámaras de Comercio, y en particular lo establecido [NAME] artículo 6 en su redacción dada por el Real Decreto Ley 13/2010, así como lo dispuesto en la Disposición Transitoria Primera de dicho Decreto.
 | Durante el año 2012, la cuota cameral oficial es 0.
 | Aportación Voluntaria de |  |  |  |  |  |  |  |  | Euros, prevista en el artículo 10, apartado D, de la Ley 3/1993.
 | Nº Cuenta [NAME] |  |  |  |  | 3058 0000 [PHONE] (Cajamar)
 | Protección de Datos de Carácter Personal
 | Le informamos de que en cumplimiento de lo establecido en la Ley Orgánica 15/1999, de 13 de Diciembre de Protección de Datos de Carácter Personal (LOPD), los datos recogidos en este documento así como los derivados de la relación con la Cámara Oficial de Comercio, Industria y Navegación de Almería, van a ser incorporados a nuestro fichero.
 | Su finalidad es [NAME] servicio personalizado e informarle de aquellas novedades que puedan [NAME] interés. Estos datos no serán cedidos a ningún tipo de organización pública ni privada salvo a las que por razones de obligaciones legales así haya que hacerlo. Así mismo le informamos de la posibilidad de ejercitar los derechos de acceso, rectificación, oposición y cancelación mediante cualquier medio de comunicación ante el Responsable del Fichero: Cámara Oficial de Comercio, Industria y Navegación de Almería. Av. [NAME], nº 29. CP 04007. Almería. Tlf.- 950 181700 / E-mail: recauda@camaradealmería.es
 | Leído y Conforme |  |  |  |  |  |  |  |  |  |  |  | Firma
 | En Almería, a |  |  | de |  |  |  | 201
 |  |  |  |  |  |  |  |  | Una vez cumplimentado [NAME] a [EMAIL] y recibirá un correo [NAME]
 |  |  |  |  |  |  |  |  | Adjuntando este documento.
Spreadsheet: 776751d1649883336-automate-daily-report-sample-daily-census
Sheet: Keep

Payer | Doctor | Location | [NAME]
A | [NAME] | SJMC | P
B | Ashok | KAISER | M
GIP | Bhavsar | PLH | J
H | Bhola | PIH | U
HO | Ehsan | UCI
K | Geiss | StJOE
M | Houshan
P | Houshyar
R | Imparato
SJH | [NAME]
 | [NAME]
 | Park
 | [NAME]
 | Pellegrino
 | Sadighian
 | Sayyur
 | [NAME]
 | [NAME]
Spreadsheet: michelle_lokay__26576__Dec00pnr
Sheet: USGT(NA) 500615

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP |  | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | USGT | 27268 | 00/10 | 500615 | PnR
1 |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
2 |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
3 |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
4 |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
5 |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
6 |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.03
7 |  |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.03
8 |  |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.03
9 |  |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.05
10 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.08
11 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.08
12 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.08
13 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.08
14 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.08
15 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
16 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
17 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
18 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
19 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
20 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.25
21 |  |  |  |  |  |  |  |  |  |  |  | 0.03 | 0.3883
22 |  |  |  |  |  | 28462 |  |  |  |  |  | 0.03 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
25 |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
27 |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
29 |  |  |  |  |  | 1538 |  |  |  |  |  | 0.04 | 0.3883
30 |  |  |  |  |  |  |  |  |  |  |  | 0.04 | 0.3883
 |  |  |  |  |  |  | Deal Rate | Total Invoice |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection
 |  |  |  | Total W/D |  |  | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 739545d1625763775-lf-conditional-formula-depending-on-text-that-exist-not-equating-to-contents-on-matching-row-of-column-3-if-column-1-and-2-match
Sheet: Table 2

Category | Vendor | Item #
1.7oz Cereal | Seacat
1oz Cereal | Good Source
2 oz Cereal | Good Source
4 PACK COOKIES | Good Source
CHE024 | Good Source
CHI035A | Good Source
CON001 | Elwood International, Inc.
CON005 | Sysco
CON006 | Sysco
CON010 | Elwood International, Inc.
CON011 | Four In One Co., Inc.
CON021 | Sysco
CON022 | Four In One Co., Inc.
CON025 | Good Source
DRI027 | Good Source
DRI050 | Good Source
DRI066 | Good Source
DRINK MIX | Good Source
Fruit Bar | Good Source
Goldfish | Good Source
JELLY | Four In One Co., Inc.
PB Cheese Crackers | Kellog Sales Company
PBJ Combo | Diamond Crystal
PBJ010 | Four In One Co., Inc.
PBJ022 | Four In One Co., Inc.
Pretzel | Pacific Grain & Foods
Pretzel | Stellar Snacks
SNK018 | Kellog Sales Company
SNK109 | Stellar Snacks
SNK137 | Stellar Snacks
Sunflower Seeds | Pacific Grain & Foods
Sunflower Seeds | Stellar Snacks
Tropical Mix | Good Source
Tropical Mix | Pacific Grain & Foods
Tropical Mix | Stellar Snacks
Tropical Mix | Royal Snacks Inc.
Spreadsheet: 677558d1589395835-multiple-criteria-find-min-and-max-date-values-2020-05-13-oeldere-roberthairt-pt-9378727-multiple-criteria-find-min-and-max-date-values-prob
Sheet: Sheet1

Build | Country | type | year | Date |  |  |  | Date | (Meerdere items) |  | MIN
A | NA | Build | 2020 | 2020-07-08 00:00:00
B | NA | Build | 2020 | 2020-03-23 00:00:00 |  |  |  | Min van Date | Kolomlabels
A | NA | Build | 2021 | 2020-03-23 00:00:00 |  |  |  | Rijlabels | EU | NA | Eindtotaal
B | NA | Build | 2021 | 2020-11-16 00:00:00 |  |  |  | A
A | NA | Build | 2020 | 2020-08-28 00:00:00 |  |  |  | 2020
B | EU | Build | 2020 | 2020-01-13 00:00:00 |  |  |  | Build | 2020-11-20 00:00:00 | 2020-03-28 00:00:00 | 2020-03-28 00:00:00
A | EU | Build | 2020 | 2020-11-20 00:00:00 |  |  |  | New | 2020-03-16 00:00:00 |  | 2020-03-16 00:00:00
B | EU | New | 2020 | 2020-07-17 00:00:00 |  |  |  | 2021
A | NA | Build | 2020 | 2020-03-28 00:00:00 |  |  |  | Build |  | 2020-03-23 00:00:00 | 2020-03-23 00:00:00
A | NA | Build | 2020 |  |  |  |  | New |  | 2020-05-04 00:00:00 | 2020-05-04 00:00:00
A | EU | New | 2020 | 2020-03-16 00:00:00 |  |  |  | B
B | NA | New | 2021 | 2020-11-04 00:00:00 |  |  |  | 2020
A | NA | New | 2021 | 2020-05-04 00:00:00 |  |  |  | Build | 2020-01-13 00:00:00 | 2020-03-23 00:00:00 | 2020-01-13 00:00:00
B | NA | New | 2021 | 2020-09-28 00:00:00 |  |  |  | New | 2020-07-17 00:00:00 |  | 2020-07-17 00:00:00
 |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  | Build |  | 2020-11-16 00:00:00 | 2020-11-16 00:00:00
 |  |  |  | [NAME] | Min Date |  |  | New |  | 2020-09-28 00:00:00 | 2020-09-28 00:00:00
A | NA | Build | 2020 | 2020-08-28 00:00:00 | 2020-03-28 00:00:00 |  |  | Eindtotaal | 2020-01-13 00:00:00 | 2020-03-23 00:00:00 | 2020-01-13 00:00:00
Spreadsheet: 78783d1279105794-advanced-lookup-retrieving-multiple-data-from-a-single-cell-example-123456-
Sheet: Data

 | Mixture name | Component 1 | Concentration 1 | Component 2 | Concentration 2 | Component 3 | Concentration 3 |  | Density (g/L)
 | Example 1 | Methane | 0.25 | Nitrogen | 0.75 |  |  |  | 1.059
 | Example 2 | Methane | 0.1 | Propane | 0.1 | Nitrogen | 0.8 |  | 1.203
 | If necessary this information can be laid out in the same way as on 'Main', would be easier if it could be laid out as above though
Spreadsheet: 681693d1591702837-count-values-in-one-range-if-the-cells-in-a-corresponding-range-are-not-empty-2020-06-08-oeldere2-thurgel-681567d1591637965-count-values-in-one-range-if-the-cells-in-a-cor
Sheet: Sheet1

[0-10 yrs/oed] | [11-15 yrs/oed] | [16-24 yrs/oed] | [25-34 yrs/oed] | [35-44 yrs/oed] | [45-54 yrs/oed] | [55-64 yrs/oed] | [65-74 yrs/oed] | [75+]
 | 1 | 2 |  | 2 | 1 |  |  |  |  |  |  |  |  |  | In order to calculate the number of households with adults between 16 and 64 and dependents who are under 16, I would like to use a forumula that counts all the instances where there is a value in columns D to G (green in the attached), i.e. each household IF there is a value in the corresponding cells A to B (yellow in the attached).
2 |  | 3 | 1 |  | 2
 | 2 |  |  |  | 2 |  |  |  |  |  |  |  |  |  | I'm pretty sure I should be able to do this but have tried all sorts, to no avail.
 |  | 3 |  |  | 2
 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | Here are some of the forumals I've tried:
 |  |  |  |  | 2
 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  | =IF(D2:G875,"<>"),AND(B2:C875,"<>"),COUNT(D2:G875)
 |  |  |  |  |  | 2
 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | =IF(B2:C875,"<>"),counta(D2:G875)
 |  |  |  |  |  |  | 2
 |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  | =countif(D2:G875,"<>"),(B2:C875,"<>")
 |  | 2 |  |  | 1 | 1
 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | These all return a 'There's a problem with this formula' errors.
 |  |  |  |  |  |  | 2
2 | 2 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | Can anyone help?
1 | 1 |  |  |  | 1 | 1
 |  | 2 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  | Thanks!
1 | 1 |  |  |  | 2
1 |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | actually, it's not working properly.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So what I need is to count every household where there is at one or more child under 16 AND one or more adults 16-54 AND one or more adults over 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I also need to count hosueholds where there is one or more adults 16-54 AND one or more adults over 55 but NO children under 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | your help greately appreciated as always
Spreadsheet: 59917d1260446713-conditional-formatting-extension-for-max-cells-formatting
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 330
11 | 12 | 13 | 14 | 15 | 178
21 | 22 | 23 | 24 | 25 | 26
16 | 17 | 18 | 19 | 20 | 21
345 | 346 | 347 | 348 | 349 | 350
13 | 14 | 15 | 16 | 15 | 14
15 | 16 | 17 | 18 | 19 | 20
224 | 228 | 223 | 134 | 185 | 467
51 | 98 | 65 | 45 | 12 | 32
654 | 564 | 3498 | 654 | 65 | 654
12 | 13 | 14 | 15 | 16 | 17
4 | 5 | 6 | 7 | 8 | 9
11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  | 654
Spreadsheet: 50400d1249835174-copying-formulas-between-cells-example
Sheet: My house

Aylesbury II ([NAME])
Invoice | January | SFP Date | February | SFP Date | March | SFP Date | April | SFP Date | May | SFP Date | June | SFP Date | July | SFP Date | August | SFP Date | September | SFP Date | October | SFP Date | November | SFP Date | December | SFP Date | Total
Company 1 | 2358.38 | 2009-01-27 00:00:00 |  |  |  |  | 1732.25 | 2009-04-28 00:00:00 | 2618.95 | 2009-05-21 00:00:00 | 913.5 | 2009-06-22 00:00:00 | 2952.61 | 2009-07-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | 10575.69
Company 2 | 752.73 | 2009-01-29 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4741.42 | 2009-07-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | 5494.15
Company 3 | 1671.42 | 2009-02-09 00:00:00 |  |  |  |  | 425.39 | 2009-05-13 00:00:00 |  |  | 496.28 | 2009-07-03 00:00:00 | 2022.64 | 2009-07-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4615.73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 4782.530000000001 |  | 0 |  | 0 |  | 2157.64 |  | 2618.95 |  | 1409.78 |  | 9716.67 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 20685.57
Spreadsheet: 114345d1310098873-counting-subject-to-conditions-count-min
Sheet: Sheet1

8
0
10
10
10
10
10
10
10
10
10
10
7
7
7
7
7
0.5
1
3
4
5
6
7
8
9
10
14
11
12
13
13
13
Spreadsheet: 161113d1339420207-random-results-based-on-percentages-baseball-simulator
Sheet: Odds

0.0693125 |  | 7
0.0693125 |  | 12
0.0693125 |  | 17
0.0693125 |  | 8
0.4455000000000001 |  | 13
0.0693125 |  | 18
0.0693125 |  | 9
0.0693125 |  | 14
0.0693125 |  | 19
 | 7 | 12 | 17 | 8 | 13 | 18 | 9 | 14 | 19
Spreadsheet: 140726d1328872605-vlookup-function-incorrect-invoice
Sheet: Sheet1

 | QTY | Decription | Unit Price | NET | VAT |  | Line Total |  |  | List of Products | Cost
 | 15 | 6" x 5" Print | 0.1 | 1.25 | 0.25 |  | 1.5 |  |  | 5" x 4" Print | 0.1
 | 1 | 7" x 5" Print | 0.2 | 0.1666666666666667 | 0.03333333333333333 |  | 0.2 |  |  | 5" x 4.5" Print | 0.11
 | 10 | 10" x 8" Print | 0.48 | 4 | 0.7999999999999998 |  | 4.8 |  |  | 5" x 5" Print | 0.12
 | 1 | 20" x 10" Print | 1 | 0.8333333333333334 | 0.1666666666666666 |  | 1 |  |  | 5" x 5.5" Print | 0.13
 | 2 | 5" x 5.5" Print | 0.13 | 0.2166666666666666 | 0.04333333333333336 |  | 0.26 |  |  | 6" x 4" Print | 0.07
 |  |  |  |  |  |  |  |  |  | 6" x 4.5" Print | 0.08
 |  |  |  |  |  |  |  |  |  | 6" x 5" Print | 0.1
 |  |  |  |  |  |  |  |  |  | 6" x 5.5" Print | 0.1
 |  |  |  |  |  |  |  |  |  | 6" x 6" Print | 0.12
 |  |  |  |  |  |  |  |  |  | 6" x 6.5" Print | 0.12
 |  |  |  |  |  |  |  |  |  | 7" x 5" Print | 0.13
 |  |  |  |  | Sub Total |  | 6.466666666666667 |  |  | 8" x 6" Print | 0.11
 |  |  |  |  | Postage |  | 1.99 |  |  | 8" x 8" Print | 0.25
 |  |  |  |  | VAT |  | 1.293333333333333 |  |  | 9" x 6" Print | 0.3
 |  |  |  |  | Total |  | 9.75 |  |  | 10" x 7" Print | 0.45
 |  |  |  |  |  |  |  |  |  | 10" x 8" Print | 0.48
 |  |  |  |  |  |  |  |  |  | 10" x 8.5" Print | 0.5
 |  |  |  |  |  |  |  |  |  | 10" x 9" Print | 0.52
 |  |  |  |  |  |  |  |  |  | 10" x 9.5" Print | 0.54
 |  |  |  |  |  |  |  |  |  | 10" x 10" Print | 0.58
 |  |  |  |  |  |  |  |  |  | 12" x 8" Print | 0.55
 |  |  |  |  |  |  |  |  |  | 12" x 10" Print | 0.65
 |  |  |  |  |  |  |  |  |  | 14" x 10" Print | 0.7
 |  |  |  |  |  |  |  |  |  | 15" x 10" Print | 0.9
 |  |  |  |  |  |  |  |  |  | 20" x 10" Print | 1
 |  |  |  |  |  |  |  |  |  | 30" x 10" Print | 1.5
Spreadsheet: 266487d1379625219-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-countyfipscode1
Sheet: NORTH CAROLINA-32

 | COUNTY | CODE
 | Alamance | 1
 | [NAME]
 | Alleghany
 | [NAME]
 | [NAME]
 | Avery
 | Beaufort
 | Bertie
 | Bladen
 | Brunswick
 | Buncombe
 | Burke
 | Cabarrus
 | Caldwell
 | Camden
 | [NAME]
 | Caswell
 | Catawba
 | Chatham
 | Cherokee
 | [NAME]
 | Clay
 | Cleveland
 | Columbus
 | Craven
 | Cumberland
 | Currituck
 | Dare
 | [NAME]
 | Davie
 | Duplin
 | [NAME]
 | Edgecombe
 | [NAME]
 | Franklin
 | Gaston
 | Gates
 | [NAME]
 | Granville
 | Greene
 | Guilford
 | Halifax
 | Harnett
 | Haywood
 | Henderson
 | Hertford
 | Hoke
 | Hyde
 | Iredell
 | [NAME]
 | Johnston
 | Jones
 | [NAME]
 | Lenoir
 | Lincoln
 | McDowell
 | Macon
 | [NAME]
 | Martin
 | Mecklenburg
 | Mitchell
 | Montgomery
 | Moore
 | Nash
 | New Hanover
 | Northampton
 | Onslow
 | Orange
 | Pamlico
 | Pasquotank
 | Pender
 | Perquimans
 | Person
 | Pitt
 | Polk
 | Randolph
 | Richmond
 | Robeson
 | Rockingham
 | [NAME]
 | Rutherford
 | Sampson
 | Scotland
 | Stanly
 | Stokes
 | [NAME]
 | Swain
 | Transylvania
 | Tyrrell
 | Union
 | Vance
 | Wake
 | [NAME]
 | Washington
 | Watauga
 | Wayne
 | Wilkes
 | Wilson
 | Yadkin
 | Yancey
Spreadsheet: 692963d1598659149-i-need-to-have-a-result-return-from-two-criteria-from-one-sheet-looking-at-another-sheet-overtimelogbook2
Sheet: AUGUST 2020

 | OT Summary
 | 2020-08-03 00:00:00 |  |  | OT Hours (Total) | Employee Count
[NAME] | Date | 30 min lunch | RepCount | Representative | UserID | Start Time | End Time | Shift | Supervisor | Location | OT Hours  (Total) | Notes
 | 2020-08-04 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
 | 2020-08-05 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
 | 2020-08-12 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
 | 2020-08-14 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
 | 2020-08-17 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
 | 2020-08-18 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
 | 2020-08-19 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
 | 2020-08-20 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
 | 2020-08-21 00:00:00 |  |  | [NAME] | [NAME] | 07:30:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 2 | 2 hrs before
 | 2020-08-26 00:00:00 |  |  | [NAME] | [NAME] | 08:00:00 | 09:30:00 | 9:30-6:00 | [NAME] | Company | 1.5 | 1.5 hrs before
Spreadsheet: 62019d1262911973-excel-2007-range-selection-in-multiple-worksheets-formrexcel-2
Sheet: TAB2

 |  | TAB2 |  |  |  | Date | 2010-01-07 00:00:00 | [NAME] fields Auto Complete
 |  | Ref (Auto) | Priority (Auto) | Status (Auto) | [NAME] | Action Title | Brief Description and Benefit | Success Criteria | Impact |  | Impact Justification | Difficulty |  | Total Score | Difficulty Justification | Owner | Sub-Actions | Initial Planned Completion Date | Forecast Completion Date | Days Late | Actual Completion Date |  | ROM Cost (if more than just FTE hours) | Breakdown of Cost (if applicable) | Summary of Updates (create in Notepad and copy in to achieve carriage returns)
 | 2 | [NAME] | High | Off Target by 6 days | Off Target | 2 |  |  | High | 3 |  | Easy | 3 | 6 |  | fred |  | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 6
 | 3 | [NAME] | Medium | Completed 4 Days Ago | Complete | 3 |  |  | Medium | 2 |  | Moderate | 2 | 4 |  | [NAME] |  | 2010-04-30 00:00:00 | 2010-04-30 00:00:00 | -113 | 2010-01-03 00:00:00 | 4
 | 4 | [NAME] | Low | On Target for -259 days | On Target | 4 |  |  | Low | 1 |  | Difficult | 1 | 2 |  | [NAME] |  | 2010-09-23 00:00:00 | 2010-09-23 00:00:00 | -259
 | 5 | TAB2 5 | High | Off Target by 6 days | Off Target | 5 |  |  | High | 3 |  | Moderate | 2 | 5 |  | [NAME] |  | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 6