tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b284d907-669b-4091-b1a2-f47aee97965d
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
CNP | Test | CNP | [NAME], Fungus Indent | Microbial Probe Fungus Ident |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87150 |  |  |  |  | Rochester
CNP | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 25578d1216935092-excel-2007-alpha-sort-columns-when-linked-cells-are-sorted-client-review-chart
Sheet: Client Review_Alphabetical

Client  Review Chart - Alphabetical
 |  | Updated
 | Client Name |  | Client Number
1 | Barger, | Greg | [PHONE]
2 | Brown, | [NAME] | [PHONE]
3 | Callahan, | [NAME] | [PHONE]
4 | Childree, | [NAME] | [PHONE]
5 | [NAME], | [NAME] | [PHONE]
6 | Gohde, | Ryon | [PHONE]
7 | Hadley, | [NAME] | [PHONE]
8 | Hansel, | [NAME] | [PHONE]
9 | Harris, | Julius | [PHONE]
10 | King, | Jeremy | [PHONE]
11 | Law, | Marcus | [PHONE]
12 | Mathews, | [NAME] | [PHONE]
13 | [NAME], | [NAME] | [PHONE]
14 | Newton, | Mark | [PHONE]
15 | Parmer, | [NAME] | [PHONE]
16 | Reese, | Clarence | [PHONE]
17 | STAFF | BED | [PHONE]
18 | Strickland, | [NAME] | [PHONE]
19 | [NAME], | [NAME] | [PHONE]
20 | Waldrop, | Adam | [PHONE]
21 | Ward, | Cedric | [PHONE]
22 | Winther, | Svein | [PHONE]
23 | Zack, | [NAME] | [PHONE]
24
25
26
Spreadsheet: 26111d1218023859-find-and-copy-data-source
Sheet: Sheet1

Col1 | Col2
1.1 | 16ht6573
1.1.1 | yrgs4527
1.1.2 | dg34627
1.1.3 | 24527
1.1.4 | dg27623
1.1.5 | f2373
1.1.6 | erfj2332
1.1.7 | [NAME]
1.1.8 | jerhf75
1.2 | lykh85
1.3 | gj6859
1.4 | gy4587
1.4 | tkjh7345
1.5 | rkltj4845
1.5.1 | rkltj4855
1.5.3 | dfv2983
1.5.3 | ngv7623
1.7 | wkfg35
1.8 | jsegh362
1.9 | wuidh37
1.10 | 4786
1.12 | [NAME]
1.13 | ek6327
10 | [NAME]
10 | [NAME]
26.19 | wek322
Where a HPA Serial No. has been allocated, indicated by a *, this is due to no serial number found on receipt of the assembly / component.
THE ABOVE LANDING GEAR ASSEMBLY AND ASSOCIATED COMPONENTS HAVE BEEN OVERHAULED
IN [NAME] WITH THE OEM'S CURRENT OVERHAUL MANUAL(S). BACK TO BIRTH AND
CUMULATIVE CYCLE INFORMATION FOR EACH LIFE LIMITED COMPONENT OR ASSEMBLY IS PROVIDED
BY THE PREVIOUS OWNER / OPERATOR WHO IS RESPONSIBLE FOR THE ACCURACY OF THIS INFORMATION.
DOCUMENTATION IS RETAINED ON FILE AT THE CONTRACTED OVERHAUL / REPAIR FACILITY.
Spreadsheet: 831033d1685363896-need-formula-to-vlookup-value-with-criteria-result-of-product-id-nmaes_lookup_
Sheet: Product ID

sl.no | Customer Name | Product ID
1 | [NAME] | FUR-BO-10001798
2 | [NAME] | FUR-TA-10000577
3 | [NAME] | FUR-FU-10001487
4 | [NAME] | FUR-CH-10002774
5 | [NAME] | FUR-TA-10000577
6 | [NAME] | FUR-BO-10004834
7 | [NAME] | FUR-CH-10001146
8 | [NAME] | FUR-CH-10000513
9 | [NAME] | FUR-FU-10000629
10 | [NAME] | FUR-FU-10001934
11 | [NAME] | FUR-TA-10001768
12 | [NAME] | FUR-FU-10002157
13 | [NAME] | FUR-CH-10004063
14 | [NAME] | FUR-TA-10004534
15 | [NAME] | FUR-CH-10001146
16 | [NAME] | FUR-FU-10004848
17 | [NAME] | FUR-FU-10000521
18 | [NAME] | FUR-CH-10004063
19 | [NAME] | FUR-BO-10002613
20 | [NAME] | FUR-TA-10004289
21 | Heather Kirkland | FUR-FU-10002960
22 | [NAME] | OFF-LA-10000240
23 | [NAME] | OFF-PA-10002365
24 | [NAME] | OFF-BI-10003656
25 | [NAME] | OFF-AP-10002311
26 | [NAME] | OFF-ST-10004186
27 | Alejandro Grove | OFF-ST-10000107
28 | [NAME] | OFF-AR-10003056
29 | [NAME] | OFF-AR-10000246
30 | [NAME] | OFF-BI-10001634
31 | [NAME] | OFF-PA-10000249
32 | [NAME] | OFF-EN-10002986
33 | Ruben Ausman | OFF-ST-10003479
34 | [NAME] | OFF-ST-10003282
35 | [NAME] | OFF-ST-10001713
36 | [NAME] | OFF-BI-10004410
37 | [NAME] | OFF-FA-10000304
38 | [NAME] | OFF-ST-10000604
39 | [NAME] | OFF-AR-10002671
40 | [NAME] | OFF-PA-10000482
41 | [NAME] | OFF-BI-10004654
42 | [NAME] | OFF-BI-10004182
43 | [NAME] | OFF-AP-10002118
44 | [NAME] | OFF-AR-10002053
45 | [NAME] | OFF-EN-10000927
46 | [NAME] | OFF-ST-10003656
47 | [NAME] | OFF-ST-10003442
48 | [NAME] | OFF-AR-10004930
49 | [NAME] | OFF-PA-10003177
50 | [NAME] | OFF-BI-10004738
51 | [NAME] | OFF-BI-10001721
52 | [NAME] | OFF-AP-10000358
53 | [NAME] | OFF-PA-10003256
54 | [NAME] | OFF-PA-10004040
55 | [NAME] | OFF-AR-10000380
56 | [NAME] | OFF-FA-10000621
57 | [NAME] | OFF-BI-10003650
58 | Troy Staebel | OFF-BI-10003274
59 | [NAME] | OFF-PA-10001804
60 | [NAME] | OFF-AR-10000940
61 | [NAME] | OFF-AP-10001058
62 | [NAME] | OFF-ST-10003656
63 | [NAME] | OFF-AP-10000326
64 | [NAME] | OFF-PA-10001950
65 | [NAME] | OFF-AR-10001547
66 | [NAME] | OFF-LA-10002475
67 | [NAME] | OFF-PA-10002751
68 | [NAME] | OFF-EN-10001990
69 | [NAME] | OFF-BI-10004002
70 | [NAME] | OFF-AR-10004441
71 | [NAME] | OFF-PA-10000659
72 | [NAME] | OFF-AP-10000891
73 | [NAME] | OFF-AP-10002684
74 | [NAME] | OFF-AR-10001940
75 | [NAME] | OFF-ST-10003455
76 | [NAME] | OFF-BI-10001890
77 | [NAME] | OFF-ST-10001328
78 | [NAME] | OFF-EN-10001509
79 | [NAME] | OFF-AR-10004685
80 | [NAME] | OFF-ST-10001414
81 | [NAME] | OFF-BI-10000343
82 | [NAME] | OFF-PA-10002666
83 | [NAME] | OFF-AP-10003217
84 | [NAME] | TEC-PH-10004977
85 | [NAME] | TEC-PH-10004093
86 | [NAME] | TEC-AC-10000171
87 | [NAME] | TEC-AC-10002167
88 | [NAME] | TEC-AC-10004633
89 | [NAME] | TEC-AC-10001998
90 | [NAME] | TEC-AC-10001552
91 | [NAME] | TEC-AC-10003499
92 | [NAME] | TEC-AC-10000844
93 | [NAME] | TEC-PH-10002293
94 | [NAME] | TEC-PH-10000215
95 | [NAME] | TEC-AC-10003657
96 | [NAME] | TEC-PH-10003273
97 | [NAME] | TEC-AC-10002323
98 | [NAME] | TEC-PH-10001918
Spreadsheet: 106242d1303409815-formula-for-automatic-summing-game-1
Sheet: Sheet1

465 | 175 | -475 | -165
Player 1 | Player 2 | Player 3 | Player 4
75 | -25 | -25 | -25
-40 | 120 | -40 | -40
35 | 95 | -65 | -65
-15 | -10 | -10 | 35
20 | 85 | -75 | -30
150 | -70 | -30 | -50
170 | 15 | -105 | -80
-50 | -25 | -10 | 85
120 | -10 | -115 | 5
Spreadsheet: 854536d1704376403-look-for-two-conditions-in-two-columns-within-a-table-test-133-aligw
Sheet: Sheet1

 |  |  | Name | Date | Output
 |  |  | [NAME] | 2022-04-15 21:02:11
 |  |  | [NAME] | 2021-08-10 21:03:34
 |  |  | Anna | 2023-04-16 21:02:22
 |  |  | [NAME] | 2019-09-16 21:02:12
 |  |  | Anna | 2023-05-01 21:02:35
 |  |  | Anna | 2022-08-01 14:35:53
 |  |  | [NAME] | 2018-08-01 14:32:20
 |  |  | [NAME] | 2020-06-15 21:36:16
 |  |  | [NAME] | 2020-06-15 21:36:17
 |  |  | Anna | 2022-08-09 21:02:16
Spreadsheet: 225653d1365078128-populate-data-based-on-cell-information-test
Sheet: Sheet1

 |  |  |  | 3
 |  |  |  |  | From the above selected item I want the details specific to that item from Shee2 to be shown below.
 |  |  |  |  | CODE |  | OTHER |  | PRICE
Spreadsheet: 815903d1675259125-formula-to-sum-best-two-values-considering-groups-q218a
Sheet: Sheet1

 |  |  | Originally |  | How it is to be calculated?
 |  | Code | Obtained
 |  | B10 | 39 |  | Col C - B12 to [NAME] - check with [NAME], Sum best 2 of D12 TO D39 if F12 to F39 is "C"
 |  | C10 | 40 |  | i.e. | 1) Check - B12 to [NAME] if it match with B3
 |  | C13 | 39 |  |  | 2) After above, match F12 to F39 with "C"
 |  | E10 | 37 |  |  | 3) After both above, [NAME] to D39 - only best 2 values
 |  | A10 | 25
 |  | M10 | 28
 |  | R10 | 39
 |  | Code | Value | [NAME] | Desc1 |  | Example:
 |  | B10 | 13 | 20 | C | 28.6 is correct | Best 2 of B10 (of Col D) is 28.6 (of "C" as per Col F")
 |  | B10 | 15.6 | 20 | C
 |  | B10 | No | 20 | C
 |  | B10 | 10 | 10 | P
 |  | C10 | 4 | 10 | C
 |  | C10 | 8.2 | 10 | C | 13 is correct
 |  | C10 | 5 | 10 | C
 |  | C10 | 26.3 | 30 | P
 |  | C13 | 7.8 | 15 | C | 19.8 is correct
 |  | C13 | 6.3 | 15 | C
 |  | C13 | 12 | 15 | C
 |  | C13 | 19 | 20 | P
 |  | E10 | 11.8 | 20 | C
 |  | E10 | 12 | 20 | C
 |  | E10 | 15.2 | 20 | C
 |  | E10 | 10 | 10 | P
 |  | A10 | 2.4 | 15 | C
 |  | A10 | 3.6 | 15 | C
 |  | A10 | 5.7 | 15 | C
 |  | A10 | 16 | 20 | P
 |  | M10 | 2 | 20 | C
 |  | M10 | 10.8 | 20 | C
 |  | M10 | 7.6 | 20 | C
 |  | M10 | 10 | 10 | P
 |  | R10 | 6.9 | 15 | C
 |  | R10 | 11.4 | 15 | C
 |  | R10 | 8.4 | 15 | C
 |  | R10 | 18.7 | 20 | P
Spreadsheet: 878387d1725459134-xlookup-formula-returns-false-only-for-some-rows-nicbkk-book4
Sheet: Sheet1

FAC1
 | Code | Name | Employees | Brand | Country | Region | POS | SUN |  |  |  | Factory | Reference | Software
 | FAC1 | Factory1 | 15 | AC | Thailand | Asia | 2 | 2 |  |  |  |  |  | Opera
 | FAC2 | Factory2 | 25 | AC | Thailand | Asia | 0 | 0 |  |  |  |  |  | Opera
 | FAC3 | Factory3 | 38 | EHR | India | India | 0 | 0 |  |  |  |  |  | Opera
 | [NAME] | Factory4 | 40 | UHR | Laos | Asia | 2 | 0 |  |  |  |  |  | Opera
 | FAC5 | Factory5 | 41 | UHR | Thailand | Asia | 2 | 2 |  |  |  |  |  | Opera
 | FAC6 | Factory6 | 42 | UHR | India | India | 0 | 0 |  |  |  |  |  | Symphony
 | FAC7 | Factory7 | 44 | EHR | India | India | 0 | 0 |  |  |  |  |  | Symphony
 | FAC8 | Factory8 | 44 | UHR | Thailand | Asia | 1 | 2 |  |  |  |  |  | Material Control
 | FAC9 | Factory9 | 50 | UHR | Thailand | Asia | 1 | 2 |  |  |  |  |  | Material Control
 | FAC10 | Factory10 | 51 | UHR | Thailand | Asia | 2 | 2 |  |  |  |  |  | Material Control
 | FAC11 | Factory11 | 58 | UHR | Thailand | Asia | 3 | 0 |  |  |  |  |  | Sun
 | FAC12 | Factory12 | 63 | UHR | Thailand | Asia | 2 | 2 |  |  |  |  |  | Sun
 | FAC13 | Factory13 | 64 | UHR | Thailand | Asia | 2 | 2
 | FAC14 | Factory14 | 69 | UHR | Thailand | Asia | 2 | 2
 | FAC15 | Factory15 | 86 | UHR | Thailand | Asia | 3 | 2
 | FAC16 | Factory16 | 94 | EHR | Laos | Asia | 2 | 2
 | FAC17 | Factory17 | 120 | EHR | Indonesia | Asia | 2 | 2
 | FAC18 | Factory18 | 128 | EHR | Thailand | Asia | 2 | 2
 | FAC19 | Factory19 | 139 | UHR | Thailand | Asia | 3 | 0
 | FAC20 | Factory20 | 147 | UHR | Thailand | Asia | 3 | 2
 | FAC21 | Factory21 | 158 | EHR | Thailand | Asia | 1 | 2
 | FAC22 | Factory22 | 164 | TLA | Thailand | Asia | 1 | 2
 | FAC23 | Factory23 | 165 | TLA | Thailand | Asia | 1 | 2
 | FAC24 | Factory24 | 194 | EHR | Thailand | Asia | 2 | 4
 | FAC25 | Factory25 | 224 | TLA | Thailand | Asia | 2 | 2
 | FAC26 | Factory26 | 268 | EHR | Vietnam | Asia | 5 | 2
 | FAC27 | Factory27 | 390 | EHR | Thailand | Asia | 5 | 3
 | FAC28 | Factory28 | 413 | TLA | Thailand | Asia | 2 | 2
 | FAC29 | Factory29 | 494 | EHR | Thailand | Asia | 6 | 5
Spreadsheet: 329505d1404324328-ref-error-code-using-vlookup-mtpinventory-and-invoice
Sheet: Inventory

Text Code | Barcode | Item # | Item Type | Picture/ Description | Size |  | Location | Bin | Hanging | Colour | Show | Rental Cost
 |  |  |  |  | Child | Adult
1PCSA1B2BR | 1pcsa1b2br | 1 | Pants (P) | Orphan pants | S |  | A1 | B2 |  | Brown (BR) | Oliver (O)
3 |  | 2
4 |  | 3
5 |  | 4
6 |  | 5
7 |  | 6
8 |  | 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
 |  | 32
 |  | 33
 |  | 34
 |  | 35
 |  | 36
 |  | 37
 |  | 38
 |  | 39
 |  | 40
 |  | 41
 |  | 42
Spreadsheet: 734042d1621952083-dependency-drop-down-based-on-values-from-another-cell-eh_prm_test-part-1
Sheet: Attribution_v4

 |  | PRM - UK Sign Off
 |  | Integration Status
 |  | UMAC |  | Completed - Ok
 |  | CRD |  | Completed - Ok
 |  | Loading Tool |  | In Progress
 |  | Attribution |  | In Progress
 |  | [NAME] |  | In Progress
 |  |  |  |  |  |  |  |  |  |  |  | Central Team Use |  | !
 | NOTE FOR TESTER | ID | Date | [NAME] | Owner | Request Type | Request Name | View | Improvement Type | Country | Criteria | KPI | Target |  | KPI - Request Type (Fields) | KPI - Request Type Local Sign Off | Comments
Attribute (Amend Existing or Create New) | Use Amend Existing | 1 |  |  | [NAME] | Attribution​ | Attribute (Amend Existing or Create New) | Customer | [NAME] | GB | High | % completed | 1 |  | NOT OK | [NAME]
 | Use Create New | 2 |  |  |  |  | Attribute (Amend Existing or Create New)
 | Assigned correctly? | 3 |  |  |  | Attribution​ | Attribute (Amend Existing or Create New) | Customer
 | No specific notes | 4 |  |  |  | Attribution​ | Attribute Product Coding Extract | Customer
 | Use New Alignment | 5 |  |  |  | Attribution​ | Attribute alignment (UK only) | Customer
 | Use Re-Alignment | 6 |  |  |  | Attribution​ | Attribute alignment (UK only) | Customer
 | Use Amend Existing | 7 |  |  |  | Attribution​ | Volume Equivalence (Amend Existing or Create New) | Customer
 | Use Create New | 8 |  |  |  | Attribution​ | Volume Equivalence (Amend Existing or Create New) | Customer
 |  | 9 |  |  |  |  |  | Customer
 |  | 10 |  |  |  |  |  | Customer
 |  | 11 |  |  |  |  |  | Customer
 |  | 12 |  |  |  |  |  | Customer
 |  | ID | Date | [NAME] | Owner | Request Type | Request Name | View | Improvement Type | Country | Criteria | KPI | Target
 |  |  |  |  |  |  |  | Agent |  |  | Urgent | % completed | 1
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
 |  |  |  |  |  |  |  | Agent
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: Duke

Duke Energy Field Services
Contract  24268
2000-11-30 00:00:00 |  | -208801.6
2000-12-31 00:00:00
60874 | 3715
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2000-11-30 00:00:00 |  | 166829.88
2000-12-31 00:00:00
9164 | 12556
9167
Duke Energy Trading and Marketing
Contract  24361
2000-11-30 00:00:00 |  | 285553.17
2000-12-31 00:00:00
500241
500391 | 8468
500392 | 2431
Duke Energy Trading and Marketing
21665 |  | 73449.16
22664 |  | 23612.35
20248 |  | -15794
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 139411.09
27291 |  | -17965
27123 |  | -6425.19
Spreadsheet: fa970d9f-d427-469f-a231-0a30f07d15b7
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 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  |  |  | 全国（岩手県，宮城県及び福島県を除く）
 |  |  |  |  |  |  |  |  |  |  |  | 第24表 | 世帯の種類，世帯人員別世帯数
 |  |  |  |  |  |  | 平成21年7～9月 |  |  |  |  |  |  |  |  |  |  |  |  | (万世帯)
 |  |  |  |  |  |  |  |  |  |  | 世帯人員 | 総　　数 | 世　　　　　　帯　　　　　　人　　　　　　員
 |  |  |  |  |  |  |  |  |  |  |  |  | 平均世帯
 |  |  |  |  |  |  |  |  |  |  |  |  | 人　　員 | １人 | ２人 | ３人 | ４人 | ５人 | ６人 | ７人以上
 |  |  |  |  |  |  |  |  |  |  |  |  | （人）
 |  |  |  |  |  |  | 世帯の種類Ⅱ |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
2400 | 84*30 |  | 1 |  | 1 |  | 総数 |  |  |  | 1 | 4912 | 2.44 | 1532 | 1376 | 869 | 749 | 254 | 89 | 43
2400 | 84*30 |  | 1 |  | 2 |  |  | ２人以上の世帯 |  |  | 2 | 3380 | 3.1 | - | 1376 | 869 | 749 | 254 | 89 | 43
2400 | 84*30 |  | 1 |  | 3 |  |  |  | 親族世帯 |  | 3 | 3375 | 3.1 | - | 1371 | 869 | 748 | 254 | 89 | 43
2400 | 84*30 |  | 1 |  | 4 |  |  |  |  | 核家族世帯 | 4 | 2805 | 2.88 | - | 1301 | 735 | 601 | 148 | 16 | 3
2400 | 84*30 |  | 1 |  | 5 |  |  |  |  | その他の親族世帯 | 5 | 569 | 4.2 | - | 69 | 134 | 147 | 106 | 73 | 40
2400 | 84*30 |  | 1 |  | 6 |  |  |  | [NAME] |  | 6 | 6 | 2.06 | - | 5 | 0 | 0 | - | - | -
2400 | 84*30 |  | 1 |  | 7 |  |  | 単身世帯 |  |  | 7 | 1532 | 1 | 1532 | - | - | - | - | - | -
2400 | 84*30 |  | 1 |  | 8 |  |  |  | うち学生を除く |  | 8 | 1427 | 1 | 1427 | - | - | - | - | - | -
Spreadsheet: 102372d1300318329-vlookup-data-owner-test
Sheet: Measures

Measures for Data Owner
FY11
 | Measure | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Target | % Var From Target for 1st Quarter | Traffic light for 1st Quarter | Mitigation for 1st Quarter
 |  | Oct,Nov,Dec | Jan,Feb,Mar | Apr,May,[NAME] | Jul,Aug,Sep
 | Percent savings
 | All | 0.1 |  |  |  | 0.15 | -0.3333333333333333 | Y
 | Major | 0.01 |  |  |  | 0.2 | -0.95 | R
 | Percent spent
 | All | 0.75 |  |  |  | 0.85 | -0.1176470588235294 | G
Spreadsheet: 156133d1337186020-analyzing-cell-data-in-first-three-columns-of-sheet-1-to-accurately-update-sheet-3-sampleinventory
Sheet: TODAY

LINE | ITEM NUMBER | [NAME] | [NAME] | ON HAND | QTY AVAIL | AISLE | BIN
TRE | 6100-1 | 6.100" .080 | WALL 180 TIP | 0 | 0 | 12 | 39
TRE | 6200-2 | 6.200" PUSH | ROD | 11 | 11 | 12 | 39
TRE | 6250-4 | 3/8" 6.250" | .080 WALL 180 TIP | 0 | 0 | 12 | 39
TRE | 6300-2 | 6.300" .080 | WALL 210 TIP | 10 | 10 | 12 | 39
TRE | 6300-3 | 3/8" 6.300" | .080 WALL 210 TIP | 8 | 8 | 12 | 41
TRE | 6350-2 | 6.350" .080 | WALL 210 TIP | 15 | 15 | 12 | 39
TRE | 6350-3 | 3/8" 6.350" | .080 WALL 210 TIP | 0 | 0 | 12 | 41
TRE | 6400-2 | 6.400" .080 | WALL 210 TIP | 20 | 20 | 12 | 39
TRE | 6400-3 | 3/8" 6.400" | .080 WALL 210 TIP | 14 | 14 | 12 | 41
TRE | 6450-2 | 6.450" .080 | WALL 210 TIP | 9 | 9 | 12 | 39
TRE | 6450-3 | 3/8" 6.450" | .080 WALL 210 TIP | 7 | 7 | 12 | 41
TRE | 6500-2 | 6.500" .080 | WALL 210 TIP | 1 | 1 | 12 | 39
TRE | 6500-3 | 3/8" 6.500" | .080 WALL 210 TIP | 14 | 14 | 12 | 41
TRE | 6550-2 | 6.550" .080 | WALL 210 TIP | 8 | 8 | 12 | 39
TRE | 6550-3 | 3/8" 6.550" | .080 WALL 210 TIP | 0 | 0 | 12 | 39
TRE | 6600-2 | 6.600" .080 | WALL 210 TIP | 16 | 16 | 12 | 39
TRE | 6600-3 | 3/8" 6.600" | .080 WALL 210 TIP | 4 | 4 | 12 | 41
TRE | 6650-2 | 6.650" .080 | WALL 210 TIP | 48 | 48 | 12 | 39
What I'd like to have happen is if LINE, ITEM NUMBER, & DESCRIPTION are found to be identical from Sheet1(Update) update the fields ON HAND, [NAME], AISLE, BIN.  If there are any discrepencies found in LINE, ITEM NUMBER, or [NAME] add a row with copied data columns A-H
Spreadsheet: phillip_allen__29930__house
Sheet: Sheet1

 | # of units | per unit cost | Total cost
Legal
Builders risk Insurance |  |  | 1000
Design
Engineering Slab |  |  | 480
Energy audit |  |  | 150
Archictect |  |  | 4500
Fees & Permits
Building & Septic Permit |  |  | 410
Utility
Construction Electric |  |  | 150
Construction Water |  |  | 100
Foundation |  |  |  |  | slab
Slab |  | 7.5 |  |  | flatwork
 |  |  |  |  | panels
Framing |  |  |  |  | plumbing
Panels  per quote |  |  | 26000 |  | builder fee
Frame Labor | 5770 | 5.45
Panel Beams |  |  | 2000 |  | total
Frame Materials |  |  | 18000
[NAME] |  |  | 5000
Porch Posts(4X300,4X225) |  |  | 2100
Windows | 30 | 150
Equipment Rental |  |  | 1250
Doors
interior doors | 16 | 75
exterior doors | 4 | 600
garage door & opener |  |  | 1500
Roof
Gutters |  |  | 1000
Roofing bid (30 yr. Composition) |  | 88
Masonry
Stucco |  |  | 14000
Rock |  |  | 8500
Mailbox |  |  | 400
fireplace |  |  | 2500
Electrical
Electrical bid |  |  | 11000
Central Vacuum |  |  | 1400
lights&fans |  |  | 3000
HVAC
a/c(2 units-3 ton up, 2.5 ton down) |  |  | 12000
air exchanger |  |  | 1000
Plumbing
plumbing bid |  |  | 15000
septic |  |  | 7500
Propane Tank(buried) |  |  | 1500
Insulation
insulation |  |  | 1000
Soundproofing | 800 | 1.2
Tyvek |  |  | 600
Drywall
sheetrock |  |  | 13000
Rounded Corners |  |  | 1000
Trim Out
trim |  |  | 8500
stairs+railings |  |  | 3500
Cabinets
cabinet-kitchen |  |  | 9000
Cabinet-wetbar |  |  | 2500
Cabinet-entertainment
Bookshelves(living) |  |  | 2500
Back door bench&shelves |  |  | 500
Computer Nook |  |  | 750
Office desk |  |  | 750
Laundry cabinets |  |  | 1500
Master Bath-Vanities |  |  | 2000
[NAME] |  |  | 1000
2 Girls Vanities |  |  | 1500
Painting
paint |  |  | 12500
Bath & Shower
MasterBath-vanity tops |  |  | 1500
[NAME] top |  |  | 800
Girls Baths-vanity tops |  |  | 800
Master Bath Shower(Tile & Glass) |  |  | 1500
[NAME] surround |  |  | 750
[NAME] surround |  |  | 750
Counter tops
counter-kitchen | 80 | 50
[NAME] |  |  | 1000
Counter-wetbar |  |  | 2000
Flooring
floor | 4000 | 7
[NAME]
Master [NAME] |  |  | 500
Bathroom Mirrors |  |  | 600
Hardware
Hardware Allowance |  |  | 1000
Appliances
appliances-kitchen |  |  | 6000
Appliance -wetbar |  |  | 1300
Flatwork
driveway |  |  | 7500
landscape
landscape |  |  | 3000
General Expenses
Clean up-Exterior |  |  | 800
Clean up Interior |  |  | 650
[NAME] |  |  | 1000
Job toilet |  |  | 500
Superintendent |  |  | 1000
Punch out |  |  | 500
Miscellaneous |  |  | 4000
Subtotal
contractor fee |  |  | 35000
Total
Per sq. ft.(4100)
Spreadsheet: 752909d1635087286-trying-to-find-solution-for-blank-spaces-123_2
Sheet: Sheet1

No | Name | 0 or 1
1 |  | 1
2 |  | 1
3 |  | 1
4 | [NAME] | 1
5 | [NAME] | 1
6 | Nataly | 1
7 |  | 1
8 | Angie | 1
9 |  | 1
10 |  | 1
11 | Marko | 1
12 | Stephen | 1
13 | Mario | 1
14 | [NAME] | 1
15 |  | 1
16 | Nikola | 1
17 | Norton | 1
18 | Ana | 1
19 |  | 1
20 |  | 1
21 | Maria | 1
22 |  | 1
23 |  | 1
24 |  | 1
25 |  | 0
26 |  | 0
27 |  | 0
28 |  | 0
29 |  | 0
30 |  | 0
Spreadsheet: 748060d1631869621-vloopup-if-col-2-and-col-3-are-not-blank-book1
Sheet: Sheet1

Orange | 2020 | 22
Peach | 2021 | 12
Pinapple | 2021 | 40
Apple Red
Apple Pink | 2022 | 4
Apple Yellow | 2022 | 14
Any Apple
 | 2022 | 4 | Desired output
Spreadsheet: 700458d1603199911-copy-table-to-new-shape-deliveries
Sheet: Sheet1

Trailer no | Branch NUMBER |  |  |  |  |  | Trailer no | 1st Branch No | 2nd Branch No | 3rd Branch No
Trailer 1 | 111 |  | <- BEFORE |  | AFTER ->
 | 222
 | 333
Trailer 2 | 444
 | 555
Trailer 3 | 666
 | 777
Trailer 4 | 888
 | 999
Trailer 5 | 122
 | 133
 | 144
Spreadsheet: 44707d1243481373-skip-blank-cells-seroleh-4
Sheet: Sheet1

 | Data
no | employee | Retire age | DO Birth | DO retire
1 | a | 58 | 1973-03-14 00:00:00
2 | b | 58 | 1967-07-24 00:00:00
3 | c | 56 | 1987-09-21 00:00:00
4 | d | 55 | 1977-06-02 00:00:00
5 | e | 58 | 1968-05-05 00:00:00
6 | f | 56 | 1955-12-19 00:00:00
 |  |  |  |  |  |  | Refer to the data, I want that DO retire is automatically calculated base on retire age and DOB. Just use simple Excel code such as if, vlookup, etc. Not the macros or vb.
Spreadsheet: 79993d1280242108-conditional-v-look-up-possible-excel-forum
Sheet: Sheet2

Area Name | Shop | Newspapers | Training Travel Costs | Travel | Canteen Expenses | Cleaning Expenses | Postage |  | Essential Repairs | Stationery | Total Controllable Expenses
 | 1554 | 0.00 | 0.00 | 0.00 | 4.81 | 0.00 | 0.00 |  | 0 | 0.00 | 4.81
 | 1555 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |  | 0 | 8.34 | 8.34
 | 2072 | 0.00 | 0.00 | 0.00 | 2.55 | 0.00 | 0.00 |  | 0 | 0.00 | 2.55
Spreadsheet: 1066250b-16e0-4713-a260-1be89c845ca8
Sheet: disordered_res.txt

Structure | Protein | PDZ domain | Residue | Chain | Position (PDB file)
1be9 | PSD95 | 3 | LYS | B | 5
2i1n | DLG3 | 1 | GLU | A | 222
2v90 | PDZD3 | 3 | ASP | D | 334
2i0l | DLG1 | 2 | ARG | C | 2001
3gge | GIPC2 | 1 | LYS | A | 200
3b76 | [NAME] | 3 | LYS | B | 497
3b76 | [NAME] | 3 | GLU | B | 498
2vrf | [NAME] | 1 | GLU | D | 199
2i04 | MAGI1 | 1 | ARG | D | 2000
Spreadsheet: 2d0db9e1-8e41-45a0-bed6-89a700938706
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
 | College Name |  |  |  |  |  |  | Quarter Reporting Period
Module Information:
Class Hours |  |  |  |  |  |  |  |  |  | Unduplicated Count
Education: |  |  |  |  |  |  |  |  |  | Youth:
Employment: |  |  |  |  |  |  |  |  |  | Emancipated Youth:
Daily Living: |  |  |  | How many hours were experiential: |  |  |  |  |  | Adult:
Finanical Literacy: |  |  |  |  |  |  |  |  |  | Non Minor Dependent
Speaker Bureau: |  |  |  |  |  |  |  |  |  | Total Unduplicated Count | 0
Total Hours | 0
One-on-One Youth Information: |  |  |  |  |  |  | [NAME] in College Information
Total number of youth one-on-one minutes: |  |  |  |  |  | Number of youth currently enrolled in college.
Total number of adult one-on-one minutes: |  |  |  |  |  | Number of youth who have completed one or more college courses.
Number of participating youth: |  |  |  |  |  | Number of youth who have earned a vocational certificate, two year degree, or transferred to a four year institution.
Number of participating adults:
Total number of participating youth and adults:
Report Narrative:
 | Completed By |  |  |  |  |  |  |  | Date Completed