tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1178__ENRON_$orion_1099
Sheet: Fixed O&M

STANDARD 1EA + 6 LM
SUMMARY OF ANNUAL OPERATION & MAINTENANCE
Prepared by [NAME]
(Amounts in US$ Actual)
 |  |  | Average |  | Total
Personnel Expenses |  |  | Annual | Positions | Annual
 |  | Wages Manager | 90000 | 1
 |  | Wages Supervisors | 65000 | 2
 |  | Wage Administration | 28000 | 1
 |  | Wages Operations | 50000 | 12
 |  | Wages Maintenance | 60000 | 6
 |  | Wages Subtotal
 |  | Burden Expenses @ 45%
 |  | Burdened Wages
 |  | G&A @ 15%
 |  | Fees |  |  | 250000
 |  |  | Sub Total Personnel
Operation & Maintenance
 | Semi Variable (Values assume a 50% Capacity Factor) 1
 |  | Equipment Parts |  |  | 750000
 |  | Expendables |  |  | 250000
 |  |  | Sub Total Semi Variable O&M
 | Fixed
 |  | Outside Services |  |  | 125000
 |  | Water Treatment |  |  | 550000
 |  | Office |  |  | 72000
 |  | Training |  |  | 25000
 |  | Other |  |  | 125000
 |  |  | Sub Total Fixed O&M
 |  |  | Total
 | 1 | Can alter for capacity factor as follows:  Cost *(1 - ((50% - CF) * .6)) Not currently implemented.
Spreadsheet: 6fb882d2-28d2-4486-af61-3fc1caa41b74
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6396 | 34730 | Ana Rita | Rodriguez | MEX | 0 | 00:15:10 | 00:02:36 | 00:40:22 | [NAME] | 00:25:50 | 1 | [NAME]
6396 | 44947 | Catalina | Del Toro | MEX | 0 | 00:16:43 | 00:03:17 | 00:44:13 | 00:01:45 | 00:28:46 | 2 | 01:34:44
6396 | 44948 | Concepcion | [NAME] | MEX | 0 | [NAME] | 00:03:56 | 00:50:21 | 00:02:52 | 00:32:49 | 3 | 01:49:01
6396 | 44949 | Nekane | Ortiz | MEX | 0 | 00:15:51 | 00:04:06 | 00:49:47 | 00:02:37 | 00:16:06 | DQ | 00:00:00
Spreadsheet: 145638d1331669858-i-need-a-macro-script-that-will-keep-only-rows-that-have-background-manually-highlighted-colored-rows
Sheet: Sheet2

 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 9
 |  |  |  | 9
Spreadsheet: benjamin_rogers__1171__Gleason - 501F & 501FD
Sheet: Operations

Operations
PPA Plant Output Summary
Capacity Degradation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Heat Rate Degradation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Degraded Capacity (MW)
Peak Capacity Sales Rate (MW)
Peak  Hours
Maximum Peak Generation (MWh)
Merchant Plant Output Summary
Capacity Degradation
Heat Rate Degradation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Degraded Capacity (MW)
Peak Capacity Sales Rate (MW)
Peak Energy Sales (MW)
Peak  Hours
Maximum Peak Generation (MWh)
PPA to [NAME]
PPA MWh
% of Total MWh Taken
Market MWh
% of Total MWh Taken
Actual MWh Produced
% of Total MWH Available
Degraded Peak Heat Rate (Btu/kWh)
Peak Fuel MMBBtu
Peak Fuel Cost $000
Sales and Use Tax on Fuel
Start up fuel cost for all turbines
Total Fuel Cost
Gas & Power Curves
Avg Mid Gas Curve Price ($/MMBtu) |  | 2.007132083333333 | 2.304759166666666 | 2.343126666666667 | 2.37128 | 2.408875 | 2.457113333333333 | 2.515308333333333 | 2.5888675 | 2.677533333333333 | 2.7819925 | 2.906365000000001 | 3.051938333333334 | 3.218111666666668 | 3.395443333333333 | 3.583075 | 3.776285833333333 | 3.97705 | 4.206997499999999 | 4.404585833333333 | 4.605178333333333 | 4.712465866666666
Fixed Price ($/MMBtu)
Sales Tax Rate |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Delivered Gas Price
Desk Mid Peak Power Curve ($/MWh) |  | 21.1797 | 22.01295 | 23.55825 | 24.58845 | 26.462 | 29.110725 | 31.221625 | 32.913375 | 31.893275 | 34.744 | 38.104775 | 40.0566 | 39.882375 | 39.33192500000001 | 46.32112499999999 | 44.642 | 50.891375 | 50.096 | 49.431925 | 56.320125 | 52.0453
Assumed Residual Capacity Value Curve ($/kWmo)
Spreadsheet: 861745d1709580286-how-to-calculate-the-difference-between-values-with-columns-of-different-codes-example-1
Sheet: Sheet1

FAC IND | OPPS CAP IND | PROC CODE | MODIFIER | FEE | NON PAR FEE | LC |  |  | PROC CODE | MODIFIER | FEE
 |  | 10004 |  | 57.64 | 54.76 | 62.97 |  |  | 10004 |  | 133
 |  | 10005 |  | 150.72 | 143.18 | 164.66 |  |  | 10005 |  | 320
 |  | 10006 |  | 65.76 | 62.47 | 71.84 |  |  | 10006 |  | 152
 |  | 10007 |  | 347.4 | 330.03 | 379.53 |  |  | 10007 |  | 722
 |  | 10008 |  | 159.77 | 151.78 | 174.55 |  |  | 10008 |  | 407
 |  | 10009 |  | 489.04 | 464.59 | 534.28 |  |  | 10009 |  | 1181
 |  | 10010 |  | 267.71 | 254.32 | 292.47 |  |  | 10010 |  | 712
 |  | 10021 |  | 113.99 | 108.29 | 124.53 |  |  | 10021 |  | 350
 |  | 10030 |  | 728.8 | 692.36 | 796.21 |  |  | 10021 | 26 | 192
 |  | 10035 |  | 414.28 | 393.57 | 452.61 |  |  | 10030 |  | 2247
 |  | 10036 |  | 341.59 | 324.51 | 373.19 |  |  | 10035 |  | 1356
 |  | 10040 |  | 132.51 | 125.88 | 144.76 |  |  | 10036 |  | 1178
 |  | 10060 |  | 143.99 | 136.79 | 157.31 |  |  | 10040 |  | 236
 |  | 10061 |  | 241.45 | 229.38 | 263.79 |  |  | 10060 |  | 251
 |  | 10080 |  | 288.74 | 274.3 | 315.45 |  |  | 10061 |  | 482
 |  | 10081 |  | 392.55 | 372.92 | 428.86 |  |  | 10080 |  | 406
 |  | 10120 |  | 173.64 | 164.96 | 189.7 |  |  | 10081 |  | 675
 |  | 10121 |  | 298.65 | 283.72 | 326.28 |  |  | 10120 |  | 336
 |  | 10140 |  | 192.69 | 183.06 | 210.52 |  |  | 10121 |  | 583
 |  | 10160 |  | 146.96 | 139.61 | 160.55 |  |  | 10140 |  | 390
 |  | 10180 |  | 298.56 | 283.63 | 326.17 |  |  | 10160 |  | 310
Spreadsheet: 80354d1280517696-moving-column-data-to-single-row-anyone-else-single-line
Sheet: Sheet1

THIS IS WHAT I START WITH
45 | ERJ-3EKF1001V | RES, 1.0K, 50V, 1/10W, 1%, THICK FILM | R1, R65, R75, R86, [NAME], | 8
 |  |  | R96, R97, R98
46 | P27.0KHTR-ND | RES, 27.0K, 50V, 1/10W, 1%, THICK FILM | R14, R19, R77, R79, R89 | 5
47 | ERJ-3EKF1503V | RES, 150K, 150V, 1/10W, 1%, THICK FILM | R15, R80, R81, R82, R83 | 5
48 | ERJ-8GEYJ470V | RES, 47, 200V, 1/4W, 5%, THICK FILM | R16, R20, R21, R46, R47 | 5
49 | ERJ-3EKF5602V | RES, 56.0K, 50V, 1/10W, 1%, THICK FILM | R2, R3, R9, R10, R11, | 18
 |  |  | R12, R13, R53, R55, R56,
 |  |  | R59, R61, R62, R63, R64,
 |  |  | R66, R69, R73
50 | ERJ-3EKF2202V | RES, 22.0K, 50V, 1/10W, 1%, THICK FILM | R22, R23, R27, R28, R32, | 6
 |  |  | R33
51 | ERJ-8GEY0R00V | RES, 0.0, 200V, 1/4W, 5%, THICK FILM | R24, R41 | 2
THIS IS WHAT I WOULD LIKE TO END UP WITH
45 | ERJ-3EKF1001V | RES, 1.0K, 50V, 1/10W, 1%, THICK FILM | R1, R65, R75, R86, R95,R96, R97, R98 | 8
46 | P27.0KHTR-ND | RES, 27.0K, 50V, 1/10W, 1%, THICK FILM | R14, R19, R77, R79, R89 | 5
47 | ERJ-3EKF1503V | RES, 150K, 150V, 1/10W, 1%, THICK FILM | R15, R80, R81, R82, R83 | 5
48 | ERJ-8GEYJ470V | RES, 47, 200V, 1/4W, 5%, THICK FILM | R16, R20, R21, R46, R47 | 5
49 | ERJ-3EKF5602V | RES, 56.0K, 50V, 1/10W, 1%, THICK FILM | R2, R3, R9, R10, R11,R12, R13, R53, R55, R56,R59, R61, R62, R63, R64,R66, [NAME], R73 | 18
50 | ERJ-3EKF2202V | RES, 22.0K, 50V, 1/10W, 1%, THICK FILM | R22, R23, R27, R28, R32,R33 | 6
51 | ERJ-8GEY0R00V | RES, 0.0, 200V, 1/4W, 5%, THICK FILM | R24, R41 | 2
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
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
2002-01-31 00:00:00 |  |  | 17587
2002-02-23 00:00:00
CBS Dollars
 |  |  | 385897
Spreadsheet: 765501d1643363568-i-want-to-count-the-occurrences-of-unique-values-within-a-group-test_sheet_for_unique-and-countifs
Sheet: Sheet1

 | Group | ID |  |  |  |  |  | Unique values |  | Oranges | Bananamilk
 | Applejuice | 10
 | Applejuice | 11 |  |  |  |  |  | 11
 | Applejuice | 12 |  |  |  |  |  | 12
 | Applejuice | 12 |  |  |  |  |  | 13
 | Applejuice | 12
 | Applejuice | 11
 | Applejuice | 10
 | Applejuice | 10
 | Oranges | 13
 | Oranges | 10
 | Oranges | 10
 | Oranges | 12
 | Oranges | 12
 | Oranges | 13
 | Bananamilk | 11
 | Bananamilk | 11
 | Bananamilk | 11
 | Bananamilk | 11
 | Bananamilk | 11
 | Bananamilk | 12
 | Bananamilk | 10
 | Bananamilk | 13
Spreadsheet: 114734d1310470065-total-from-multiple-spreadsheets-music2011sales
Sheet: Apr

TC Reporting Month | # [NAME] | PayRate for one sold | Total Earned | Currency | Album Title | [NAME] | Name of store or service | Country Of Sale
2011-04-13 00:00:00 | 1 | 8.4 | 0.6909337344 | [NAME] | Touching The Winky | Penguins | iTunes Mexico | MX
2011-04-13 00:00:00 | 1 | 0.71 | 0.99444020426 | EUR | Touching The Winky | Penguins | iTunes UK/EU | GB
2011-04-13 00:00:00 | 1 | 0.71 | 0.99444020426 | EUR | Touching The Winky | It's a Penis | iTunes UK/EU | GB
2011-04-13 00:00:00 | 1 | 0.71 | 0.99444020426 | EUR | Touching The Winky | Funt | iTunes UK/EU | GB
2011-04-13 00:00:00 | 368 | 0.92 | 474.19390923136 | EUR | [NAME] | [NAME] | iTunes UK/EU | GB
2011-04-13 00:00:00 | 1 | 0.71 | 0.99444020426 | EUR | The Triple Coiler | Found Some Poo | iTunes UK/EU | GB
2011-04-13 00:00:00 | 20 | 0.71 | 19.8888040852 | EUR | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes UK/EU | GB
2011-04-13 00:00:00 | 1 | 0.71 | 0.99444020426 | EUR | Touching The Winky | Willies from Mars | iTunes UK/EU | GB
2011-04-13 00:00:00 | -1 | 0.92 | -1.28857040552 | EUR | [NAME] | [NAME] | iTunes UK/EU | GB
2011-04-13 00:00:00 | 2 | 0.71 | 1.98888040852 | EUR | Touching The Winky | Titty Titty Gash Gash | iTunes UK/EU | GB
2011-04-13 00:00:00 | 2 | 0.71 | 1.98888040852 | EUR | Touching The Winky | Boobs | iTunes UK/EU | GB
2011-04-13 00:00:00 | 2 | 0.99 | 1.845693673263 | AUD | Touching The Winky | Funt | iTunes AU/NZ | AU
2011-04-13 00:00:00 | 1 | 9.99 | 9.3123635332815 | AUD | Touching The Winky |  | iTunes AU/NZ | AU
2011-04-13 00:00:00 | 3 | 1.29 | 3.6074921795595 | AUD | [NAME] | [NAME] | iTunes AU/NZ | AU
2011-04-13 00:00:00 | 3 | 0.99 | 2.7685405098945 | AUD | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes AU/NZ | AU
2011-04-13 00:00:00 | 2 | 1 | 2 | USD | [NAME] | [NAME] | iTunes U.S. | US
Spreadsheet: e5615d31-38b9-4efd-9d4e-354e44557406
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
DUCK | Test | DUCK | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
DUCK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
DUCK | Result | DUCK | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6100-2
Spreadsheet: 85325d1285345143-v-lookup-3-in-1-excel-forum-1-
Sheet: Large Project Estimator

Estimator for Projects over $250,000
 |  | Site name |  |  |  |  | FORECASTED ODD: | 2010-01-11 00:00:00
 |  | manhattan |  |  |  |  | ESCALATION: | 0.1
 |  | CTI Code |  |  |  |  |  |  |  | Cost/
 |  | Serial # |  |  |  |  |  |  |  | Sq.Ft.
 |  | Project Type |  |  |  |  | GC COST
 |  | Project Manager |  |  |  |  | CW COST
 |  | [NAME] |  |  |  |  | CW & USER COSTS
 |  | Ownership
WBS Code | Cost Description | Estimator Cost | PjM Adjustment | Escalation Adjustment | Adjusted Total (Leased) | Adjusted Total (Owned) | Comments
 | Site Cleaning (clearing and Development) | 100000 | 30000
 | Utilities | 70 | 40
 | Environmental | 30000 | 1000
 | Demolition
 | Paving
 | Landscaping
 | Site Work SubTotal
 | Building Concrete
 | Masonry | 200000 | 20000
 | Steel and Railings
 | Rough Carpentry
 | Insulation
 | Roof and sealants | 100000 | 30000
 | Interior walls and partitions
 | Structural SubTotal
 | Plumbing | 200
 | HVAC | 40000 | 4000
 | Electrical and Lighting
 | Electronic Surveillance | 5000
 | Fire Protection/Suppresion
 | Mechanical Electrical SubTotal
 | Millwork
 | Doors Hardware and Glazing
 | Acoustical Ceiling
 | Finishes and Paint
 | Ceramic Tile and Flooring | 20000 | 2000
 | Carpet and Access Flooring | 35000 | 4000
 | Specialties
 | Finish SubTotal
 | GC Project Management
 | Building Permits and Utility Fees
 | GC Costs
 | GC Additional Costs
 | GC Overhead and Profit
 | GC Fees SubTotal
 | Total General Contractor Costs (line 12 or 13 in ROM) (sum of all remaining GC items that are not already itemized in ROM)
Line 25 | Architect and Engineer Services | 400000 | 30000
 | Exterior Signage | 42000 | 2000
Line 25 | Due Diligence and Legal | 12000 | 2000
 | Cabling | 5000
 | Carpet (Bank pruchased) (line 18 or 19 in ROM)
 | Reimbursables | 10000
 | PjM Fees @10%
 | Additional CW Costs
 | Total CW Costs
 | Security Equipment | 100000 | 10000
 | Bank Equipment | 75000
 | Vault Chest/Safe Deposit Equipt (line 33 in ROM)
 | Telecomm Equipt/Technology | 55000
 | ATMs (line 33 in ROM)
 | System Furniture | 80000
 | Total User Costs
 | Land Acquisition Cost | 400000
 | Tenant Improvement Allowance | -20000
Spreadsheet: 862731d1710380864-check-condition-with-2-file-report
Sheet: สูตร

SR Opened | Planned Start | Activtiy Closed Date | Solved SLA / Manual ลงเอง | SLA VS Planed Start (day) | SLA VS Opened Date (day) | SLA VS Planed Start Raking | SLA VS Opened Date Raking
2021-12-30 10:38:19 | 2021-12-30 18:12:46 | 2022-01-04 08:02:53 | 5
 | 2023-07-03 13:41:39 | 2023-07-03 15:44:33
Spreadsheet: 04c4108c-0549-464e-8dac-7788356a78b1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | February | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | CSA March 2014 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | April | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45
23 | 24 | 25 | 26 | 27 | 28 | 29 | 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 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
SueandBill 2/19 - 3/2
 |  |  | brennie 2/26 - 3-10
 |  |  |  |  |  |  |  | RobinH 3/2 - 12
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | hotsotchginger 3/5 - 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Michigan Lady 3/8 - 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | jmac 3/12 - 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | monobrow1 3/12 - 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | liljohn 3/12 - 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KC 3/13 - 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BlondeHawaiian 3/14 - 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | andypapa 3/15 -18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]??
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | waynef 3/16 - 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fido 3/16 - 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Donna & Ken 3/17 - 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gibbyvaca 3-17 - 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lab_NH 3/28 - 4/4
 |  |  |  |  |  |  |  |  |  |  | Celebrating a birthday
 |  |  |  |  |  |  |  |  |  |  | Celebrating an anniversary/honeymoon
 |  |  |  |  |  |  |  |  |  |  | Wedding in Paradise
Spreadsheet: 754665d1636414620-list-result-dynamically-with-match-partial-result-dynamicmatchpartialresult
Sheet: Sheet1

Region |  | Employee Name | Region |  |  |  |  | South | East | West | <-- Transpose Values from tbl
North |  | Adam | North;South |  |  |  | Adam | Adam | [NAME] | [NAME]
South |  | [NAME] | South;East |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
East |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
West |  | [NAME] | West;North |  |  |  | Elijah | Elijah | [NAME] | [NAME]
 |  | [NAME] | North;East |  |  |  | Betty |  |  | Betty
 |  | [NAME] | South;West
 |  | Elijah | North;South
 |  | [NAME] | [NAME]
 |  | Betty | North;West
 |  |  |  |  |  |  |  | Desired Result
tblRegion |  | tblEmployee
Spreadsheet: 839076d1691645228-which-index-match-function-matching-2-values-to-2-values-and-returning-one-result-matrix-test-aligw
Sheet: Requirements

 |  |  |  |  | Course | Management | Supervisor | Hard FM | Soft FM | [NAME]
 |  |  |  |  | Safety First | Required | Required | Required | Required | Required
 |  |  |  |  | Safety Rules Common Arrangement (TS & Managers Only) | Required | Required | n/a | n/a | n/a
 |  |  |  |  | Ethics Human Rights (online or offline) | Required | Required | Required | Required | Required
 |  |  |  |  | Modern Slavery (online or offline) | Required | Required | Required | Required | Required
 |  |  |  |  | Data Protection UK/GDPR | Required | Required | Required | Required | Required
 |  |  |  |  | Cyber Security (if connected) | Required | Required | Required | Required | Required
 |  |  |  |  | Diversity & Inclusion | Required | Required | Required | Required | Required
 |  |  |  |  | Display Screen Equipment (DSE) and workstation | Required | Required | n/a | n/a | Required
 |  |  |  |  | Accident Investigation Interactive | Required | n/a | n/a | n/a | n/a
 |  |  |  |  | [NAME] (NFL) | Required | n/a | n/a | n/a | n/a
 |  |  |  |  | CDM Regulations Interactive | Required | n/a | n/a | n/a | n/a
 |  |  |  |  | First Aid in the workplace for Managers Interactive | Required | n/a | n/a | n/a | n/a
 |  |  |  |  | Health and Safety for Managers Interactive | Required | n/a | n/a | n/a | n/a
Spreadsheet: 883658d1732289168-stuck-filtering-table-data-and-forcing-automatic-updates-emp_test
Sheet: EmpHours

Emoloyee ID | Office | Name | Mon Hours | Tues Hours | Wed Hours | Thur Hours | Fri Hours
643 | ACC | Smith, [NAME] | 4 |  | 8 |  | 8
443 | LOG | [NAME], Pam | 6 |  |  | 9 | 3
773 | LOG | [NAME], [NAME] |  | 6 | 8
236 | FIN | Jones, [NAME] | 8 |  |  | 9
976 | FIN | [NAME], Greg | 8 |  |  |  | 5
235 | ACC | [NAME], [NAME] |  | 9 | 2 |  | 2
238 | CS | Young, Emily
Spreadsheet: 267486d1380093621-help-with-searching-for-specfic-text-across-multiple-columns-in-a-sheet-madyowie
Sheet: Sheet1

 |  |  |  |  |  | Column #
 |  |  | 1 | 2
 |  |  | Dgzjp | [NAME]
 |  |  | Keioh | [NAME]
 |  |  | Doqyd | Pchgy
 |  |  | [NAME] | Cmncn
 |  |  | Dufyo | Mvjal
 |  |  | Pnrmj | Expired
 |  |  | Ahnaj | [NAME]
 |  |  | Sgacx | Cxlgi
 |  |  | Umrxe | [NAME]
 |  |  | Dkwtz | Hrvdy
 |  |  | Fuqol | Mbtwx
 |  |  | [NAME] | Tsqax
 |  |  | Evxxb | Abjye
 |  |  | Odwrj | Zyofu
 |  |  | Efrml | [NAME]
 |  |  | Artea | Ctgbj
 |  |  | Hzokd | Qcwyb
 |  |  | Xsrfa | Jlghu
Spreadsheet: 36429d1234305928-auto-input-info-from-a-list-example
Sheet: Sheet1

(Mannually entered) |  | Auto |  | Auto |  | Auto |  |  |  | Hidden list
ITEM# |  | BRAND NAME |  | SIZE |  | FLAVOR |  |  |  | Item |  | Brand Name |  | Size |  | Flavor
 |  |  |  |  |  |  |  |  |  | 1562 |  | Edys |  | 4 qt |  | Choc
 |  |  |  |  |  |  |  |  |  | 2664 |  | [NAME] |  | 5 qt |  | Van
 |  |  |  |  |  |  |  |  |  | 6718 |  | Haag |  | 6 qt |  | Straw
 |  |  |  |  |  |  |  |  |  | 4589 |  | Bryers |  | 7 qt |  | Fudge
 |  |  |  |  |  |  |  |  |  | 9876 |  | [NAME] |  | 8 qt |  | Neo
 |  |  |  |  |  |  |  |  |  | 8965 |  | Pop |  | 9 qt |  | [NAME]
Spreadsheet: 217878d1362239247-trying-to-combine-data-if-statement-maybe-trial-bb-
Sheet: ALL DATA

 | Member [NAME] | Class Code | Hours Reg. | OT Hours | DT Hours
[NAME] | [NAME] | J | 127 | 68 | 30
[NAME] | [NAME] | A4 | 110.5 | 59.5 | 10
[NAME] | [NAME] | A3 | 0 | 0 | 0
[NAME] |  | F | 129 | 68 | 20
JULY | [NAME] | J | 127 | 68 | 30
JULY | [NAME] | A4 | 110.5 | 59.5 | 10
JULY | [NAME] | A4 | 11 | 75 | 0
Spreadsheet: 749578d1632909727-table-from-another-table-lookup-index-match-filter-distinct-values-without-blanks-rk01-
Sheet: Sheet2

Names | Distinct
[NAME] | [NAME] |  |  |  | [NAME]
[NAME] | [NAME] |  |  |  | [NAME]
[NAME] | [NAME] |  |  |  | [NAME]
jeremy | jeremy |  |  |  | Jeremy
 | [NAME] |  |  |  | [NAME]
[NAME] | tom |  |  |  | [NAME]
[NAME]
tom
[NAME]
13
12
12
Spreadsheet: 839353d1691875087-conditional-formatting-please-help-sample-formula-help
Sheet: Sheet1

($000s) | Census | Base
Title | # in Job | Avg | Min | Median | [NAME]
Analyst III | 5 | 112 |  | 100
Analyst II | 10 | 110 |  | 90
Analyst I | 15 | 64 |  | 80
Spreadsheet: 704543d1605618418-is-it-possible-to-sum-up-numbers-here-prod-test
Sheet: Produksjonsplan

Sipa tapper |  |  |  |  |  |  |  |  |  |  |  |  |  | Antall lag |  | Papp Type |  |  |  | Antall flasker
Merknad | Dag | Batch nr. | Antall fl. | Multipakk / 4pk | Ant. Paller Pakker | Ant. HP | 4-pk HP | Vare nr. | Produktnavn | Vol. | Preform | Kork | Multipakk | Multipakk | HP | Papp 220 gr. | Papp 500 gr. | Plast bredde mm. | Ant. [NAME]. | Antall flasker [NAME] | Antall flasker [NAME] | Antall flasker 4-pakk | Antall flasker multipakk | Antall flasker [NAME] | Antall pakker pr. [NAME] | Antall flasker pr. [NAME] | Antall flasker Schw. |  | Antall del pr. kit |  | Ant. fl. [NAME]. kit
 | Mandag | 10 |  |  |  |  |  | 1
 |  | 20 |  |  |  |  |  | 618 |  |  |  |  |  |  |  |  |  |  |  | 20000 | 20000
 |  | 30 |  |  |  |  |  | 854 |  |  |  |  |  |  |  |  |  |  |  | 30000 | 10000
 |  | 40 |  |  |  |  |  | 864 |  |  |  |  |  |  |  |  |  |  |  | 25000
 |  | 50 |  |  |  |  |  | 636 |  |  |  |  |  |  |  |  |  |  |  | 25000
 |  | 60 |  |  |  |  |  | 638 |  |  |  |  |  |  |  |  |  |  |  | 30000
 | Tirsdag | 20 |  |  |  |  |  | 146 |  |  |  |  |  |  |  |  |  |  |  |  | 55000
 |  | 20 |  |  |  |  |  | 148 |  |  |  |  |  |  |  |  |  |  |  |  | 10000
 | Fredag | 1
 |  | 2
 |  | 3
 |  | 407662 |  |  |  |  |  | 874 |  |  |  |  |  |  |  |  |  |  |  | 20000