tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 817056d1675968092-match-function-issue-showing-incorrect-value-vlookup-and-match-issue
Sheet: Sheet1

 |  | A | B | C | D | E | F | G
 | XYZ | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | C | A | F
 | XYZ
 |  | This Should Show a 3. Not a 2. What am I doing wrong?
Spreadsheet: 4a5060bc-b5bd-46b9-b378-bb9c0f17680f
Sheet: Page 9

Permit No.: |  |  | WQ0013200 |  |  | Facility Name: |  | Southeast Brunswick Sanitary District WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | L - 10 / (6) |  | Field Name: |  | L - 2 / (18) |  | Field Name: |  | L - 3 / (17) |  | Field Name: |  | L - 4 / (19,20)
 |  |  |  |  |  | Area (acres): |  | 0.4 |  | Area (acres): |  | 0.27 |  | Area (acres): |  | 0.3 |  | Area (acres): |  | 0.26
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  | 32.8 |  | Annual Rate (in): |  | 32.8 |  | Annual Rate (in): |  | 32.8 |  | Annual Rate (in): |  | 32.8
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 105910d1303183325-excel-2007-div-0-error-help-this-bloody-spreadsheet-
Sheet: fortnight ending 3rd Apr 2011

# | PO | Site | Date Completed | OM | Cost Per Hour | Labour Hours | Total labour cost | Travel Mileage | Travel cost at 0.7c | Fuel for Pressurewasher | Management time cost | TOTAL COST
1 |  | 88 Collins Street | 2011-04-02 00:00:00 | MP | 30 | 3 |  | 152
2 |  | Morley Gate Way | 2011-04-03 00:00:00 | KV | 30 | 15.5 |  | 134
3 |  |  |  |  | 30
4 |  |  |  |  | 30
5 |  |  |  |  | 30
6 |  |  |  |  | 30
7 |  |  |  |  | 30
8 |  |  |  |  | 30
9 |  |  |  |  | 30
10 |  |  |  |  | 30
TOTAL
 | GST | 0.1
 | TOTAL
Total Fuel for P/washer | Number of Jobs
224.24 | 2
Management hours | Number of Jobs
1 | 2
Management travel to OCS | Number of Jobs
42 | 2
Spreadsheet: b6c4a054-2f14-43cc-bbaf-d4b7c9270f4b
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
B2MC | Test | B2MC | Beta-2-Microglobulin (B-2-M), [NAME] | Beta-2-Microglobulin, CSF | Nephelometry | Sterile, screw-capped, plastic vial |  |  | 1 | mL | Container/Tube: Sterile vial [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.70-1.80 mcg/mL | Monday through Saturday; 3 p.m. | Same day/1 day | 2 days | 1 | 82232 |  |  |  |  | Rochester
B2MC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
B2MC | Result | B2MC | Beta-2-Microglobulin, CSF | Beta-2-Microglobulin, CSF | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 1951-3 | Beta-2-Microglobulin:MCnc:Pt:CSF:Qn:
Spreadsheet: 151351d1334867311-sumif-with-three-intersecting-values-test
Sheet: Calculations

Event Count Selection |  |  | Conditional Count Selection |  |  | Calculation Figures
Unique Condition Values | Event Count |  | Unique User Defined Field 4 Values | Conditional Event |  | Unique I.D. Numbers | # of ALL Events | # of Selected Events | Conditional Events
 | False |  |  | False
 | True |  |  | False
 | False |  |  | True
 | True |  |  | True
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
 | False |  |  | False
Spreadsheet: 102237d1300215278-multiple-cell-formula-example-1
Sheet: Calculation

Product | Magazine Example |  | Status | Status
 |  |  | Price | Pages
 | Sep
Price | 425
Pages | 40
Costs
sheets | 840
inserts | 42.5
Covers | 800
Grand Total | 1682.5
Spreadsheet: 647556d1572505911-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-pq-tennis-data-from-website-olly
Sheet: Tennis Data

Grass |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
[NAME] |  | [NAME] | 25 | 201 | 347 | 146 | 0 | Clay | 0.6104 | 52977
[NAME] |  | [NAME] | 25 | 175 | 308 | 133 | 0 | Carpet | 0.7049 | 71590
Spreadsheet: 93726d1293485474-v-look-up-with-or-statement-example
Sheet: Sheet2

Project Number | Fcst | Act
3898001555 | 2009-02-18 00:00:00 | 2009-02-18 00:00:00
3898001556 | 2009-02-18 00:00:00 | 2009-02-18 00:00:00
3898001557 | 2012-01-01 00:00:00
3898001558 | 2009-02-18 00:00:00 | 2009-02-18 00:00:00
3898001559 | 2010-11-01 00:00:00
3898001560 | 2010-03-10 00:00:00 | 2010-03-10 00:00:00
3898001561 | 2010-03-08 00:00:00 | 2010-03-08 00:00:00
3898001562 | 2009-02-18 00:00:00 | 2009-02-18 00:00:00
3898001563 | 2009-02-18 00:00:00 | 2009-02-18 00:00:00
3898001575 | 2009-07-16 00:00:00 | 2009-07-16 00:00:00
3898001577 | 2009-05-01 00:00:00 | 2009-05-01 00:00:00
3898001584 | 2009-10-23 00:00:00 | 2009-10-23 00:00:00
3898001585 | 2010-03-10 00:00:00 | 2010-03-10 00:00:00
3898001624 | 2009-09-07 00:00:00 | 2009-09-07 00:00:00
Spreadsheet: 138366d1327625690-excel-2007-hypelink-hell-copy-of-tlc-client-progress-3-
Sheet: Santiago

Client | Carolina Matta
Student | Santiago
 | Date Completed | Comments
Initial Contact | 2001-11-01 00:00:00 | CG phoned
Details put on database | 2012-11-01 00:00:00
Evaluation | 2012-11-01 00:00:00 | with rebecca at office
Evaluation Report Received | 2012-11-04 00:00:00
Follow Up with Parent | 2012-11-07 00:00:00 | want to start next week
Course Overview Made | 2012-11-09 00:00:00
Confirmed Teacher | 2012-11-11 00:00:00 | Grace
Teacher Availability Updated
Sent out T&Cs/Welcome Pack | 2012-11-15 00:00:00
Added Lessons to Database | 2012-11-17 00:00:00
Send info to JF | 2012-11-17 00:00:00
Follow Up 1st class | 2012-11-19 00:00:00 | thought it was the best class they ever had
How often do they want follow up? | every 20 classes
20 classes | jan 30 | thoguht student improved a ton
40 classes | march 10
Band Scores |  | fluency
Initial |  | 5
20 classes |  | 7
40 classes |  | 7
Spreadsheet: b4c1f846-7db3-4f2b-baff-79f10e87684e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259332 | 57736 | [NAME] | Yanagawa | JPN | 80 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 07:23:58
Spreadsheet: 162563d1339975975-excel-2007-formulas-in-cells-order-guide-example
Sheet: Sheet1

 |  |  | WINDOW 1
 |  | [NAME] |  | tom |  | lane
 |  | 318-6793 |  | 901-5522 |  | 964-8336
 |  | us foods |  | sysco |  | sham |  | [NAME] | mon | wed | [NAME] | fri
PRODUCE
APPLES  88CT
ASPARAGUS 11#
[NAME]  48CT
BASIL  FRESH 1#
BERRIES  BLACK
[NAME]
[NAME] 2/4#
BERRIES RASPBERRY FRZN  2/5#
CABBAGE  RED  SHRED 4/5#
CARROTS JUMBO 25#
CELERY  24CT
CHERRY TART DRIED FRSH
 |  |  | WINDOW 2
number |  | description | brand | pack/cs |  | price
 |  |  |  |  |  | 2012-06-10 00:00:00 | 2012-06-03 00:00:00
1331552 |  | Apple, [NAME] 100 Count Washington Fancy Fresh Ref | Cross Valley Farms | 100 Ea | 36.22 | 36.22 | 36.6
5083894 |  | Asparagus, Green Jumbo Fresh Ref | Packer | 13-15 [NAME] | 41.82 | 41.82 | 39.49
2223071 |  | Asparagus, Green Large Bunch Fresh Ref | Packer | 11/1 [NAME] | 39.53 | 40.44 | 38.55
6047500 |  | Avocado, [NAME] 40-48 Count Fresh Ref | Packer | 40-48 Ea | 40.47 | 42.64 | 42.64
8007320 |  | Avocado, Ripe 40-48 Count Fresh Ref | Packer | 40-48 Ea | 40.28 | 42.49 | 42.93
1384213 |  | Basil, Fresh Herb | Packer | 1 [NAME] | 9.03 | 9.03 | 9.03
8412884 |  | Bean, [NAME] | Monarch | 15 [NAME] | 19.22 | 19.22 | 19.42
8020588 |  | Blackberry, Fresh Ref | Packer | 12/.5 Pt | 25.08 | 26.22 | 26.22
8168841 |  | Blueberry, Fresh Ref | Packer | 12/.5 Pt | 32.46 | 32.46 | 32.46
1327642 |  | [NAME], Red Whole Iqf Frozen | Monarch | 2/5 [NAME] | 24.66 | 24.66 | 24.92
9353129 |  | [NAME], Clamshell Fresh Ref | Cross Valley Farms | 8/1 [NAME] | 15.12 | 15.46 | 15.18
 |  | [NAME] |  | tom |  | lane
 |  | 318-6793 |  | 901-5522 |  | 964-8336
 |  | us foods |  | sysco |  | sham |  | [NAME] | mon | wed | [NAME] | fri
PRODUCE
APPLES  88CT
ASPARAGUS 11#
[NAME]  48CT
BASIL  FRESH 1#
BERRIES  BLACK
[NAME]
Spreadsheet: 107111d1304338047-array-by-state-customer-by-state2
Sheet: Example

Employee 1 | Employee 2 |  |  |  |  | Desired end result
AK |  |  |  |  |  | Employee 1 |  |  | Employee 2
 | AL |  |  |  |  | Customer 1 | 12 |  | Customer 2 | 10
 | AR |  |  |  |  | Customer 2 | 5 |  | Customer 3 | 9
AZ |  |  |  |  |  | Customer 4 | 7 |  | Customer 5 | 10
 |  |  |  |  |  |  |  |  | Customer 6 | 6
 | AK | AL | AR | AZ
Customer 1 | 10 | 0 | 0 | 2
Customer 2 | 5 | 10 | 0 | 0
Customer 3 | 0 | 6 | 3 | 0
Customer 4 | 2 | 0 | 0 | 5
Customer 5 | 0 | 10 | 0 | 0
Customer 6 | 0 | 5 | 1 | 0
Employee# | State | Customer | Count |  |  | Sum of Count | Column Labels |  |  |  |  |  |  | Sum of Count | Column Labels
[NAME] | AK | Macy | 10 |  |  | Row Labels | Billy | [NAME] | Fred | [NAME] | [NAME] | Grand Total |  | Row Labels | Billy | [NAME] | Fred | [NAME] | [NAME] | Grand Total
Fred | AL | Costco | 15 |  |  | Costco |  |  | 30 |  |  | 30 |  | AK |  | 10 |  | 34 |  | 44
[NAME] | AR | Sears | 2 |  |  | Macy |  | 14 |  |  |  | 14 |  | AL |  |  | 15 |  |  | 15
[NAME] | AZ | XYZ | 45 |  |  | Microsoft | 26 |  |  |  |  | 26 |  | AR |  |  |  |  | 2 | 2
Billy | CA | Microsoft | 15 |  |  | Sears |  |  |  |  | 27 | 27 |  | AZ |  |  |  | 45 |  | 45
[NAME] | NH | Macy | 4 |  |  | XYZ |  |  |  | 79 |  | 79 |  | CA | 15 |  |  |  |  | 15
Fred | NJ | Costco | 15 |  |  | Grand Total | 26 | 14 | 30 | 79 | 27 | 176 |  | NH |  | 4 |  |  |  | 4
[NAME] | NY | Sears | 25 |  |  |  |  |  |  |  |  |  |  | NJ |  |  | 15 |  |  | 15
[NAME] | AK | XYZ | 34 |  |  |  |  |  |  |  |  |  |  | NY |  |  |  |  | 25 | 25
Billy | WA | Microsoft | 11 |  |  |  |  |  |  |  |  |  |  | WA | 11 |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 26 | 14 | 30 | 79 | 27 | 176
Spreadsheet: 757264d1638172207-formula-to-calculate-average-sample-file
Sheet: Sheet1

Name | Score | Expected Score | Comments
[NAME] | 3 | 3
[NAME] | 2 | 3.25 | Repeated 4 times, hence took avg score
[NAME] | 3 | 4 | Repeated 3 times, hence took avg score
[NAME] | 2 | 3.25 | Repeated 4 times, hence took avg score
[NAME] | 5 | 4 | Repeated 3 times, hence took avg score
[NAME] | 4 | 3.25 | Repeated 4 times, hence took avg score
[NAME] | 4 | 4 | Repeated 3 times, hence took avg score
[NAME] | 4 | 4
[NAME] | 5 | 3.25 | Repeated 4 times, hence took avg score
Spreadsheet: 864519d1711650844-xlookup-help-to-produce-a-number-if-not-found-on-prior-tab-sample-file-xlookup
Sheet: 2025

 | 25000
 |  | Pack Price Architecture | EMC: downcounting | N | VMS_WELL_SKIN
 |  | Pack Price Architecture | Small Size Gummy & Caplet | Y | DH
 |  | Active Mix | Transition Tums 70ct EX Twin pack to 170ct value size at DG | Y | DH
 |  | Pack Price Architecture | Prep H Club pack Renovation | Y | DH
 |  | Pack Price Architecture | GasX Club pack Renovation | Y | DH
 |  | Promotion Management | TUMS Display: SKU Assortment | N | DH
 |  | Promotion Management | TUMS/Nexium co-promotions- during 14ct drive periods | N | DH
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 3

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
[NAME] Seed Beads: 6/0 Stone-Look Dyed 25gms |  |  |  |  | 12 | 0.48 | 5.76
BD270F | F) Classic | 775749198621 | INDIA | 7018.10.0020
[NAME] Seed Beads: 6/0 Stone-Look Dyed 25gms |  |  |  |  | 12 | 0.48 | 5.76
[NAME] | G) Baby | 775749198638 | INDIA | 7018.10.0020
[NAME] Seed Beads: 6/0 Stone-Look Dyed 25gms |  |  |  |  | 12 | 0.48 | 5.76
BD270H | H) Paradise | 775749198645 | INDIA | 7018.10.0020
[NAME]: Oval+Diamond Faceted Bead Medley Stranded |  |  |  |  | 12 | 1.25 | 15
BD320A | A) Turquoise | 775749214840 | CHINA | 7018.10.0020
[NAME]: Oval+Diamond Faceted Bead Medley Stranded |  |  |  |  | 12 | 1.25 | 15
BD320B | B) Emerald | 775749214857 | CHINA | 7018.10.0020
[NAME]: Oval+Diamond Faceted Bead Medley Stranded |  |  |  |  | 12 | 1.25 | 15
BD320C | C) Amber | 775749214864 | CHINA | 7018.10.0020
[NAME]: Oval+Diamond Faceted Bead Medley Stranded |  |  |  |  | 12 | 1.25 | 15
BD320D | D) Sapphire | 775749214871 | CHINA | 7018.10.0020
Glass Beads: Oval Faceted Bead Medley Stranded Asst 6eax6styles |  |  |  |  | 36 | 0.82 | 29.52
BD324 | - | 775749214949 | CHINA | 7018.10.0020
Glass Beads: Cube Faceted Bead Medley Stranded Asst 6eax6styles |  |  |  |  | 36 | 0.82 | 29.52
[NAME] | - | 775749214888 | CHINA | 7018.10.0020
[NAME]: 4mm+6mm Krystaal [NAME] 6eax4styles |  |  |  |  | 24 | 0.75 | 18
BD394A | A) Two-Tone Luster | 775749199208 | CHINA | 7018.10.0020
[NAME]: 4mm+6mm Krystaal [NAME] 6eax4styles |  |  |  |  | 24 | 0.75 | 18
BD394B | B) Crystalline | 775749199215 | CHINA | 7018.10.0020
[NAME]: [NAME] |  |  |  |  | 24 | 0.75 | 18
BD398A | A) Smooth | 775749199024 | CHINA | 7018.10.0020
[NAME]: [NAME] |  |  |  |  | 24 | 0.75 | 18
BD398B | B) Faceted | 775749199031 | CHINA | 7018.10.0020
Acrylic Fashion Beads: 7" Safari Oval Strand Asst 5styles |  |  |  |  | 48 | 0.3 | 14.4
[NAME] | - | 775749175905 | CHINA | 3926.90.9990
Brass [NAME]: 6mm-12mm Round Luxe x5 |  |  |  |  | 24 | 0.3 | 7.2
[NAME] | A) Gold Swirl | 775749172973 | INDIA | 8308.90.0090
Brass [NAME]: 6mm-12mm Round Luxe x5 |  |  |  |  | 24 | 0.3 | 7.2
BD586C | C) Gold Loops | 775749172997 | INDIA | 8308.90.0090
[NAME] 45g ULTIMIX |  |  |  |  | 24 | 0.75 | 18
[NAME] | A) B&W Classic | 775749154924 | CHINA | 7018.10.0020
[NAME] 45g ULTIMIX |  |  |  |  | 24 | 0.75 | 18
BD705B | B) The Blues | 775749154931 | CHINA | 7018.10.0020
[NAME] 45g ULTIMIX |  |  |  |  | 24 | 0.75 | 18
BD705C | C) Nuggets | 775749154948 | CHINA | 7018.10.0020
[NAME] 45g ULTIMIX |  |  |  |  | 24 | 0.75 | 18
BD705D | D) Going Green | 775749154955 | CHINA | 7018.10.0020
[NAME] 45g ULTIMIX |  |  |  |  | 24 | 0.75 | 18
BD705E | E) [NAME] | 775749154962 | CHINA | 7018.10.0020
Spreadsheet: 7e41dae4-8204-406a-bc05-de6b1a07de3c
Sheet: GC SFF Pivots (Summary)

 | [NAME]  --  SFF Collection-Day
 | Summary Pivots (with all 5 Collection Sites reporting)  --  Nov 12, 2011
 | Row Labels | Sum of Weight |  |  | Row Labels | Sum of Weight |  | 2010 REF | 2009 REF
 | Pack | 87209.89448399999 |  |  | LINK | 34814.029084 |  | 38734.24880399999 | 34151.78928999996
 | 1106 | 1428 |  |  | [NAME] | 42997 |  | 38040 | 52912.99999999999
 | 1148 | 2230 |  |  | Messiah’s Market | 9917 |  | 15761.390872 | 14957.39999999999
 | 1152 | 4637.067456000001 |  |  | Seven Loaves | 7276 |  | 4901 | 1300
 | 1156 | 606.992518 |  |  | Tree of Life | 11814 |  | 11043 | 0
 | 1157 | 843.8988339999999 |  |  | Grand Total | 106818.029084 |  |  | 10503.2 | Holiday Coalition
 | 1158 | 2140.071193999999
 | 1159 | 6120
 | 1162 | 2452
 | 1167 | 683
 | 1174 | 252
 | 1483 | 6382.669736
 | 1484 | 3060 |  |  | AHG-T7673 = | American Heritage Girl
 | 1500 | 1406 |  |  | CC = | Community Church
 | 151 | 1939 |  |  | RiteAid = | RiteAid (Staff)
 | 154 | 4035
 | 1550 | 2184
 | 1576 | 384.5924699999999
 | 1666 | 1559
 | 1733 | 230
 | 1737 | 1234 |  |  | Row Labels | Sum of Weight
 | 2010 | 664 |  |  | Other | 653
 | 256 | 1762 |  |  | AHG-T7673 | 585
 | 282 | 1836 |  |  | CC | 53
 | 39 | 637 |  |  | RiteAid | 15
 | 533 | 347 |  |  | Troop | 18955.1346
 | 572 | 1968.950306 |  |  | 1154 | 739
 | 663 | 1057 |  |  | 1159 | 744
 | 704 | 771 |  |  | 1165 | 509.92398
 | 71 | 2664 |  |  | 1168 | 420
 | 743 | 649 |  |  | 1173 | 528
 | 905 | 1741.060804 |  |  | 1550 | 215
 | 910 | 522.71066 |  |  | 1910 | 523
 | 950 | 2812.73891 |  |  | 2010 | 518
 | 951 | 1137.5736 |  |  | 2011 | 1039
 | 952 | 9 |  |  | 2950 | 52
 | 953 | 947 |  |  | 2970 | 2873.299271999999
 | 956 | 1274.787904 |  |  | 572 | 916.45222
 | 957 | 352.780092 |  |  | 663 | 1518
 | 958 | 5368 |  |  | 905 | 173.17133
 | 961 | 3536 |  |  | 950 | 1649.547858
 | 962 | 2053 |  |  | 956 | 1756.84574
 | 965 | 4095 |  |  | 961 | 17
 | 969 | 493 |  |  | 966 | 1527.12642
 | 975 | 245 |  |  | 968 | 626.76778
 | 982 | 1444 |  |  | 969 | 657
 | 997 | 1690 |  |  | 982 | 535
 | 998 | 3325 |  |  | 998 | 1417
 | Grand Total | 87209.89448399999 |  |  | Grand Total | 19608.1346
Spreadsheet: 833466d1686987259-retrieve-all-info-from-source-data-for-all-matches-from-list-find-all-matches-1-
Sheet: Results

 | Asset | Make | Model | S/N
[NAME] | C000001 | HP | x360 | SN001
[NAME] | C000007 | HP | x360 | [NAME]
[NAME] | C000008 | HP | FireFly | SN008
[NAME] | C000014 | Dell | 7400 | SN014
[NAME] | C000016 | Dell | 7400 | SN016
[NAME] | C000015 | Dell | 7200 | SN015
[NAME] | C000019 | HP | x360 | SN019
[NAME] | C000020 | Apple | MacBook Air | SN020
Spreadsheet: afea96ec-cc7a-4013-83b4-407a1f0f4aae
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
FFTOX | Test | FFTOX | [NAME], [NAME] (Serum) | [NAME], Serum, ELISA | Enzyme Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 1 mL serum refrigerated. | 0.10 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | REFERENCE RANGE:  Negative  Results of this assay must be interpreted with caution, as broad variations in antibody response occur, and levels may remain elevated for years after infection. Further, as with many parasitic serology assays, antibodies induced by other parasitic infections may crossreact in this assay. Although a negative result usually rules out infection with Toxocara spp., parallel testing of serial samples may prove useful in following patients with suspected Toxocara infection.    Test Performed by: Focus Diagnostics, Inc.                              5785 Corporate Avenue 	                 Cypress, CA 90630-4750 | Tuesday, Friday | 1 - 5 days | 2 - 7 days | 1 | 86682 |  |  |  |  | Focus Diagnositics, Inc.
FFTOX | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
FFTOX | Result | [NAME] | [NAME], Serum, ELISA | [NAME], Serum, ELISA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5386-8
Spreadsheet: 769888d1645718601-find-specials-value-in-the-row-and-return-value-with-subject-resutl
Sheet: Sheet1

Result | WK3 | Wk4 | WK5 | WK6
[NAME] | True | False | True | False
WK3,WK4,WK5,WK6 | False | False | False | False
WK5,WK6 | True | True | False | False
Spreadsheet: 627ce7de-e275-49c1-8005-f0cd8f04aa04
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | [NAME] | Diesel
MODELO
 | Número de plazas |  | [NAME] | 5 | 5
MOTOR
 | Código del motor |  |  | VQ35DE | YD25
 | [NAME], configuración |  |  | V6 | 4 en línea
 | Válvulas por cilindro |  |  | 4 | 4
 | Cilindrada |  | cm³ | 3498 | 2488
 | Diámetro x carrera |  | [NAME] | 95.5 x 81.4 | 89.0 x 100.0
 | Potencia máxima |  | kW (CV) / rpm | 188 (256) / 6.000 | 140 (190) / 4.000
 | Par máximo |  | Nm/rpm | 334 / 4.400 | 450 / 2.000
 | [NAME] |  |  | 10.3 | 15.0
 | Tipo de combustible |  |  | gasolina RON95 sin plomo | Diesel
 | Capacidad del depósito |  |  | 82 | 82
Transmisión |  |  |  | 4WD | 4WD
 | Caja de cambios |  |  | CVT | [NAME] velocidades
 | Desarrollos | 1a |  | 2.371 | 4.199
 |  | 2a |  |  | 2.405
 |  | 3a |  |  | 1.583
 |  | 4a |  |  | 1.161
 |  | 5a |  | 0.439 | 0.855
 |  | 6a |  |  | 0.685
 |  | Marxa atrás |  | 1.766 | 3.457
 |  | Grupo final |  | 5.173 | 3.803
 | Tracción |  |  | 4WD | 4WD
CHASIS
 | Suspensión | delantera |  | Independiente columnas [NAME]
 |  | trasera |  | Independiente multibrazo
 | Dirección |  |  | De piñón y cremallera con asistencia sensible a la velocidad
 | Frenos |  |  | Discos ventilados delante y detrás
 | Llantas (opción) |  |  | 18 x 7.5J
 | Neumáticos (opción) |  |  | 235/65 R18 103H
PESO Y DIMENSIONES
 | Peso en [NAME]2) |  | [NAME] | 1.790 / 1.830 | 1.895 / 1.898
 | Peso máximo autorizado |  | [NAME] | 2365 | 2495
 | Carga máxima  2) |  | [NAME] | 467 | 447
 | Peso máximo por eje (PAW) | delantero | [NAME] | 1245 | 1370
 |  | trasero | [NAME] | 1200 | 1185
 | Peso máximo remolcable | con frenos | [NAME] | 1585 | 1585
 |  | sin frenos | [NAME] | 750 | 750
 | Carga máximo sobre el punto de enganche |  | [NAME] | 100 | 100
 | [NAME] |  | [NAME] | 4860 | 4860
 | [NAME] |  | [NAME] | 1885 | 1885
 | [NAME] |  | [NAME] | 1720 | 1720
 | [NAME] entre [NAME] |  | [NAME] | 2825 | 2825
 | Vías | delantera | [NAME] | 1610 | 1610
 |  | trasera | [NAME] | 1610 | 1610
 | Radio de giro [NAME] ([NAME]) |  | m | llanta 18" 11,4 llanta 20" 11,8 | llanta 18" 11,4 llanta 20" 11,8
PRESTACIONES
 | Consumo 3) | Ciclo urbano | l/100 km | 14.9 | 10.1
 |  | Extra-urbano | l/100 km | 8.6 | 6.8
 |  | Combinado | l/100 km | 10.9 | 8.0
 | Emisiones de CO2 (combinadas) |  | g/km | 261 | 210
 | Velocidad máxima |  | km/h | 210 | 196
 | [NAME]/h |  | seg | 8.0 | 10.5
Spreadsheet: 291244d1390229379-trying-to-create-a-functional-spreadsheet-overhead-map-for-trailer-yard-inventory-demo
Sheet: List

Unit# | Vin# | Insp Date | Row | Errors | Comments
123456 | 1PNV01PT432123432 | 2012-01-13 00:00:00 | B |  | light issues
321098 | 1GRAA0622WL765432 | 2013-02-12 00:00:00 | A |  | damage to LF corner
654321 | 1GRAA0622WL654321 | 2013-03-13 00:00:00 | N/A | M | MISSING (not on map)
765432 | 1JJV532WL12345678 | 2013-04-13 00:00:00 | A |  | door damage
987654 | 1GRAA0622WL123456 | 2013-05-13 00:00:00 | C
6543210 | N/A |  | B | A | ADDITIONAL (not in unit# list)
A11111 | 1JJV532WL98765432 | 2014-01-01 00:00:00 | C
 |  |  |  |  | NOTE: 6543210 was a typo on the [NAME], 654321 was the correct #
 |  |  |  |  | this was caught by the program and displayed in Col E as an error
Spreadsheet: 158274d1338135985-combine-sum-sheets-and-make-a-summary-into-another-sheet-sumif-across-sheets
Sheet: summary

Sheets A - C | Jan - March
Todate Total
 | desc | qty
cris | 2 a c | 4
cris | 2 a b | 5
cris | 3 a c | 7
cris | 3 a x | 1
cris | 2 a a | 9
cris | 2 a v | 13
cris | 3 a x | 5
cris | 3 a t | 1
cris | 1 b c | 2
cris | 2 c e | 3
cris | 3 e c | 4
cris | 5 r t | 5
cris | 3 a g | 6
cris | 5 h j | 4
cris | 2 y r | 5
 | Total
 | total Rows
combine / sum sheets A - C into another sheet
using what???
what formula should I use to attain this