tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 855776d1705276757-get-data-from-1-sheet-to-other-sheets-depending-on-drop-down-list-christmas-comp-trial-for-extra-species-remove-columsn
Sheet: Whiting

WHITING
Angler # | Length (mm) | Angler Name | Age Group
Spreadsheet: 859465d1707842457-if-sum-problem-copy-of-test-data-gradings
Sheet: Sheet1

Location ID | Store Grade 2023 | Category 1 | Survey submitted | No of calls to store | Latest Visit | Grade | Movement
11228895 | Ungraded | Cycle 1 | 2024-01-02 11:15:36 | 1 |  | Ungraded | as not latest from H2 this should be blank | Blank
11239325 | [NAME] | Cycle 1 | 2024-01-05 10:56:46 | 1 |  | Ungraded | as not latest from H2 this should be blank | Blank
11238872 | Silver | Cycle 1 | 2024-01-15 11:28:45 | 1 |  | [NAME] | as not latest from H2 this should be blank | Blank
11228811 | Gold | Cycle 1 | 2024-01-15 11:28:45 | 1 |  |  | as not latest from H2 this should be blank | Blank
11228895 | Ungraded | Cycle 2 | 2024-02-12 09:14:06 | 2 | latest | Ungraded |  | Unchanged |  |  | Unchanged
11239325 | [NAME] | Cycle 2 | 2024-02-12 10:41:11 | 2 | latest | Ungraded |  | Loss |  |  | Loss
11238872 | Silver | Cycle 2 | 2024-02-12 09:16:07 | 2 | latest | Gold |  | Gain |  |  | Gain
11228811 | Gold | Cycle 2 | 2024-02-12 09:16:07 | 2 | latest | [NAME] |  | Loss |  |  | Loss
 |  |  |  |  |  |  | if A and G match return the word unchanged
 |  |  |  |  |  |  | If G is better than B return the word Gain
 |  |  |  |  |  |  | if g is worse than B return the word loss
Spreadsheet: 23396d1212786155-variable-hyperlinking-between-sheets-hyperlink1
Sheet: Testing

Name | Label
Test 1 | Type A | Type A
Test 2 | Type B | Type B
Test 3 | Type C | Type C
Test 4 | Type D | Type D
Test 5 | Type E | Type E
Test 6 | Type F | Type F
Test 7 | Type G | Type G
Test 8 | Type H | Type H
Test 9 | Type I | Type I
Test 10 | Type J | Type J
Test 11 | Type K | Type K
Test 12 | Type L | Type L
Test 13 | Type M | Type M
Test 14 | Type N | Type N
Test 15 | Type O | Type O
Spreadsheet: 57082d1257262754-is-there-an-easier-way-to-change-my-tables-format-example
Sheet: Sheet1

Current Format
Box | Year | First File in Box | Last File in box
1 | 2002 | 1 | 5
2 | 2002 | 6 | 8
3 | 2002 | 9 | 12
[NAME]
Box | Year | File
1 | 2002 | 1
1 | 2002 | 2
1 | 2002 | 3
1 | 2002 | 4
1 | 2002 | 5
2 | 2002 | 6
2 | 2002 | 7
2 | 2002 | 8
3 | 2002 | 9
3 | 2002 | 10
3 | 2002 | 11
3 | 2002 | 12
Spreadsheet: 217151d1361993667-rounding-of-values-to-specific-range-values-lookup-example
Sheet: Sheet1

Calculated Width | Next Available Size |  | [NAME]
1.25 |  |  | 6 | 6"
 |  |  | 5 | 5"
 |  |  | 4 | 4"
 |  |  | 3 | 3"
 |  |  | 2 | 2"
 |  |  | 1.5 | 1-1/2"
 |  |  | 1 | 1"
 |  |  | 0.75 | 0.75"
 |  |  | 0.5 | 0.5"
Spreadsheet: 063b33a2-96e2-49f3-a2df-574c1b322de2
Sheet: Sheet1

SAMPLE MEAT GOAT BUDGET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | by [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Annual kidding |  |  | You can only edit values highlighted in yellow.
HERD COMPOSITION: |  |  | PRODUCTION PARAMETERS
 | Number of Does | 30 |  | Percent kid crop raised |  |  | 1.7
 | Number of Bucks | 1 |  | Doe replacement rate |  |  | 0.2
 | Adult death loss | 0.05 |  | Buck Replacement Rate |  |  | 0.33
INCOME CALCULATION: |  | No. Head | lbs./hd | Net Price | Unit | Total | Per doe
 | Market kids | 45 | 70 | 1 | lb. | 3150 | 105
 | Cull does | 4.500000000000001 | 90 | 0.75 | lb. | 303.7500000000001 | 10.125
 | Cull bucks | 0.33 | 170 | 0.75 | lb. | 42.075 | 1.4025
 | Other income |  |  |  |  | 0 | 0
 | TOTAL INCOME |  |  |  |  | 3495.825 | 116.5275
OPERATING COSTS: |  | No. Head | Amt/hd | Unit | Cost | Total | Per doe
 | Feed costs
 | Hay | 31 | 0.25 | ton | 90 | 697.5 | 23.25
 | Grain | 31 | 135 | [NAME]. | 0.09 | 376.65 | 12.555
 | Salt and Minerals | 31 | 12 | [NAME]. | 0.16 | 59.52 | 1.984
 | Supplemental feed for kids | 51 | 0 | [NAME]. | 0.1 | 0 | 0
 | Pasture maintenance | 82 | 6 | [NAME]. | 30 | 180 | 6
 | Health program |  | doses
 | Deworming (adults) | 31 | 3 | doses | 1 | 93 | 3.1
 | Deworming (kids) | 51 | 3 | doses | 0.75 | 114.75 | 3.825
 | CD-T booster  (adults) | 31 | 1 | doses | 0.5 | 15.5 | 0.5166666666666667
 | CD-T vaccinations (kids) | 31 | 2 | doses | 0.5 | 31 | 1.033333333333333
 | Other vet costs | 31 |  | head | 4 | 124 | 4.133333333333334
 | [NAME] replacement | 0.33 |  | head | 250 | 82.5 | 2.75
 | Bedding | 31 |  | head | 3 | 93 | 3.1
 | Marketing and Hauling | 49.83 |  | head | 5 | 249.15 | 8.305
 | Supplies | 31 |  | head | 3 | 93 | 3.1
 | Additional Cost |  |  | Total cost | 0 | 0 | 0
 | Additional Cost |  |  | Total cost | 0 | 0 | 0
 | Interest on operating money | 0.05 |  | Cost for 6 months |  | 55.23925000000001 | 1.841308333333334
 | TOTAL OPERATING COSTS |  |  |  |  | 2264.80925 | 75.49364166666666 |  | `
RETURN TO LAND, LABOR AND CAPITAL |  |  |  |  |  | 1231.01575 | 41.03385833333334 | <-- Profitability
COST PER POUND LIVE WEIGHT |  |  |  |  |  |  | 0.6092013492063493 | <-- Breakeven Price (Live)
COST PER POUND CARCASS WEIGHT |  |  |  | Yield | 0.47 |  | 1.296173083417764 | <-- Breakeven Price (Carcass)
Spreadsheet: benjamin_rogers__935__PJM DAILY NEW
Sheet: Stacks

New England Daily Forecasted Interchange
DATE | 2001-02-09 00:00:00
Tie | New York |  |  |  |  | New Brunswick |  |  | Highgate |  |  | Hydro Quebec DC Tie     Phase II ** |  |  | Hydro Quebec DC Tie     Phase I **
 | Northern Ties * |  | 1385 Cable
Hr End | Purchases | Sales | Purchases | Sales | Net | Purchases | Sales | Net | Purchases | Sales | Net | Purchases | Sales | Net | Purchases | Sales | Net
1 | -1232 | 238 |  |  |  | -299 |  |  | -201 |  |  | -787
2 | -1232 | 238 |  |  |  | -299 |  |  | -201 |  |  | -787
3 | -1232 | 238 |  |  |  | -299 |  |  | -201 |  |  | -787
4 | -1232 | 238 |  |  |  | -299 |  |  | -201 |  |  | -787
5 | -1232 | 88 |  |  |  | -299 |  |  | -201 |  |  | -747
6 | -1282 |  |  |  |  | -299 |  |  | -217 |  |  | -803
7 | -1311 |  |  |  |  | -682 |  |  | -217 |  |  | -955
8 | -1028 |  |  |  |  | -575 |  |  | -217 |  |  | -1250
9 | -992 |  |  |  |  | -575 |  |  | -217 |  |  | -1289
10 | -988 |  |  |  |  | -575 |  |  | -210 |  |  | -1279
11 | -982 |  |  |  |  | -575 |  |  | -217 |  |  | -1279
12 | -978 |  |  |  |  | -575 |  |  | -217 |  |  | -1264
13 | -975 |  |  |  |  | -575 |  |  | -217 |  |  | -1299
14 | -972 |  |  |  |  | -575 |  |  | -217 |  |  | -1309
15 | -968 |  |  |  |  | -575 |  |  | -217 |  |  | -1317
16 | -967 |  |  |  |  | -575 |  |  | -210 |  |  | -1319
17 | -971 |  |  |  |  | -575 |  |  | -210 |  |  | -1450
18 | -1047 | 49 |  |  |  | -575 |  |  | -210 |  |  | -1587
19 | -1047 | 49 |  |  |  | -575 |  |  | -210 |  |  | -1561
20 | -997 |  |  |  |  | -575 |  |  | -210 |  |  | -1342
21 | -977 |  |  |  |  | -575 |  |  | -210 |  |  | -1292
22 | -959 | 1 |  |  |  | -575 |  |  | -210 |  |  | -1213
23 | -939 | 49 |  |  |  | -525 |  |  | -210 |  |  | -1191
24 | -1233 | 49 |  |  |  | -299 |  |  | -217 |  |  | -763
 | * New York Northern Ties
 | Pleasant Valley - Long Mountain (398 line)
 | Alps - Berkshire (393 line)
 | Rotterdam - Bear Swamp (E205W line)
 | Plattsburgh - Sand Bar (PV-20 line)
 | Whitehall - Blissville (K37 line)
 | Hoosick - Bennington (K6 line)
 | Smithfield - Salisbury (690 line)
Send questions or comments to ISO-NE Customer Service Dept. at, [EMAIL]
Nets
Spreadsheet: 147939d1333041690-conditional-formatting-in-excel-2010-sample1
Sheet: Home Page

Sheet 1 | 2012-03-15 00:00:00 | 14
Sheet 2
Sheet 3
Sheet 4
Sheet 5
Sheet 6
Sheet 7
Sheet 8
Sheet 9
Sheet 10
Sheet 11
Sheet 12
Sheet 13
Sheet 14
Sheet 15
Sheet 16
Sheet 17
Sheet 18
Sheet 19
Sheet 20
Sheet 21
Spreadsheet: 873769d1720337202-how-to-find-total-of-working-hours-from-a-single-cell-2024
Sheet: SUNDAYS 2024 (2)

 |  | 2024
 |  | SHOP1 |  |  | SHOP2
 |  | 2024-05-05 00:00:00 | PERSON 1 |  | 2024-05-05 00:00:00 | PERSON 1
 |  | 2024-05-12 00:00:00 | PERSON 2 |  | 2024-05-12 00:00:00 | PERSON 2
 |  | 2024-05-19 00:00:00 | PERSON 1 |  | 2024-05-19 00:00:00 | PERSON 5
 |  | 2024-05-26 00:00:00 | PERSON 3 |  | 2024-05-26 00:00:00 | PERSON 3
 |  | 2024-06-02 00:00:00 | PERSON 2 |  | 2024-06-02 00:00:00 | PERSON 2
 |  | 2024-06-02 00:00:00 | PERSON 4 |  | 2024-06-02 00:00:00 | PERSON 4
 |  | 2024-06-09 00:00:00 | PERSON 1 |  | 2024-06-09 00:00:00 | PERSON 1
 |  | NUMBERS OF SUNDAYS |  |  | NUMBERS OF SUNDAYS
 |  | PERSON 1 |  |  | PERSON 1
 |  | PERSON 2 |  |  | PERSON 2
 |  | PERSON 3 |  |  | PERSON 3
 |  | PERSON 4 |  |  | PERSON 4
 |  | PERSON 5 |  |  | PERSON 5
 |  | PREFERRED RESULT
Spreadsheet: 267125d1379959598-entering-gps-coordinates-into-excel-2003-gps
Sheet: Sheet1

Example 1 |  | Degree | Minute | Seconds
Camping Site | LAT | 67 | 54 | 35 | N | 67°19.64N
 | LON | 027 | 29 | 72 | E | 027°29.72E
Example 2
Camping Site | LAT | 67°19.64N | N
 | LON | 027°29.72E | E
Spreadsheet: 542856d1508147564-min-and-max-date-returning-00-01-1900-testdata-set
Sheet: Analysis

Field / Event | Count | First Change | Last Change |  |  | Networking Days | Last Change to today date
Alias Company Name
Company Currency
Company Merged
Country of Domicile
Created.
DB Assets
DC Assets (Brightscope)
DC Assets (MMD)
GL Business Segment
Information Sharing Risk Rating
Information Sharing Risk Rating Region
Legal Classification
Mailing Address Line 1
Office Address Line 1
Total Plan Assets
Ownership Structure
Client Of
Tax ID
Spreadsheet: 76357d1276866401-rearrange-pivot-table-columns-excelforumspt
Sheet: Sheet1

Date | Product | Units
2009-10-01 00:00:00 | Apples | 10 |  |  | Month | Date
2009-10-15 00:00:00 | Peaches | 20 |  |  | Product | Jan | Oct | Nov | Dec | Grand Total
2009-11-01 00:00:00 | Apples | 30 |  |  | Apples |  | 10 | 30 |  | 40
2009-11-15 00:00:00 | Peaches | 40 |  |  | Lemons |  |  |  | 50 | 50
2009-12-01 00:00:00 | Lemons | 50 |  |  | Peaches |  | 20 | 40 |  | 60
2010-01-01 00:00:00 | Strawberries | 60 |  |  | Strawberries | 60 |  |  |  | 60
2010-01-15 00:00:00 | Watermelons | 70 |  |  | Watermelons | 70 |  |  |  | 70
 |  |  |  |  | Grand Total | 130 | 30 | 70 | 50 | 280
Spreadsheet: 853777d1703741696-combine-data-from-different-source-combine
Sheet: Combine

Prod_Index | Age_Year | Pocket | Ctry | Code_TX |  | Age_Year | Pocket | Code_TX | Ctry
#1 | 2.1 | A | SG | AxD_7611 | #1 | 2.1 | A | AxD_7611
#2 | 3.5 | A | CHN | AxD_7611 | #1 |  | A |  | SG
#3 | 3.9 | B |  | [NAME] | #2 | 3.5 | A | AxD_7611
#4 | 1.5 | A |  | [NAME] | #2 |  | A |  | CHN
#5 |  | C | CHN |  | #3 | 3.9 | B | [NAME]
#6 |  | C | TW |  | #4 | 1.5 | A | [NAME]
#7 |  | B | CHN |  | #5 |  | C |  | CHN
#8 | 8.3 | G |  | Gj_110 | #6 |  | C |  | TW
 |  |  |  |  | #7 |  | B |  | CHN
 |  |  |  |  | #8 | 8.3 | G | Gj_110
Spreadsheet: 874220d1720784777-how-can-i-get-a-specific-result-in-a-cell-based-on-whats-in-the-previous-ones-elitebeat-book2-copy-2-copy
Sheet: Sheet1

Style | Type | Height | [NAME] | OUTPUT
Compi | K1 | 300 | 500 |  |  |  |  |  |  |  |  | Style | Type | Height | [NAME] | Output
Compi | K1 | 300 | 500 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 400 | 204
Compi | K2 | 450 | 1400 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 500 | 255
Compi | K1 | 300 | 500 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 1000 | 509
Compi Verti | K3 | 450 | 3000 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 1500 | 764
Compi | K1 | 300 | 500 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 2000 | 1018
Compi | K1 | 300 | 400 |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 2500 | 1273
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K1 | 300 | 3000 | 1527
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K1 | 450 | 400 | 302
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 500 | 378
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 600 | 454
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 700 | 529
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 800 | 605
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 900 | 680
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 1000 | 756
 |  |  |  |  |  |  |  |  |  |  |  | Compi | P+ | 450 | 1100 | 832
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 1200 | 907
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 1400 | 1058
 |  |  |  |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 1600 | 1210
Style of Radiator | Type of Radiator | Height | [NAME] |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 1800 | 1361
Compi | K1 | 300 | 400 |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 2000 | 1512
Compi Verti | P+ | 450 | 500 |  |  |  |  |  |  |  |  | Compi | K2 | 450 | 2200 | 1663
 | K2 |  | 600 |  |  |  |  |  |  |  |  | Compi Verti | K3 | 450 | 2400 | 1814
 | K3 |  | 700 |  |  |  |  |  |  |  |  | Compi Verti | K3 | 450 | 2600 | 1966
 |  |  | 800 |  |  |  |  |  |  |  |  | Compi Verti | K3 | 450 | 2800 | 2117
 |  |  | 900 |  |  |  |  |  |  |  |  | Compi Verti | K3 | 450 | 3000 | 2268
 |  |  | 1000
 |  |  | 1100
 |  |  | 1200
 |  |  | 1300
 |  |  | 1400
 |  |  | 1500
 |  |  | 1600
 |  |  | 1700
 |  |  | 1800
 |  |  | 1900
 |  |  | 2000
 |  |  | 2100
 |  |  | 2200
 |  |  | 2300
 |  |  | 2400
 |  |  | 2500
 |  |  | 2600
 |  |  | 2700
 |  |  | 2800
 |  |  | 2900
 |  |  | 3000
Spreadsheet: 36619d1234479732-list-matching-with-dates-using-dates-as-filters-dates
Sheet: Sheet1

RED ROSE RESTAURANT LIST 1
Last Name | First Name | Job | Birth Month | Start Employment Contract | End Employment Contract
Smith | [NAME] | Waiter | March | 1995-01-31 00:00:00 | 1998-06-15 00:00:00
Smith | [NAME] | [NAME] | February | 1996-03-05 00:00:00 | 1999-08-16 00:00:00
Smith | [NAME] | Janitor | January | 1996-06-05 00:00:00 | 1999-03-04 00:00:00
Smith | [NAME] | Waiter | March | 1998-09-19 00:00:00 | 2001-02-01 00:00:00
Smith | [NAME] | [NAME] | February | 2000-12-01 00:00:00 | 2003-04-03 00:00:00
Smith | [NAME] | Janitor | January | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Smith | [NAME] | Waitress | September | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Smith | [NAME] | [NAME] | October | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
[NAME] | [NAME] | [NAME] | November | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Phillips | Todd | Janitor | April | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
[NAME] | [NAME] | Waiter | May | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
RED ROSE RESTAURANT LIST 2
Last Name | First Name | Job | Birth Month | Start Employment Contract | End Employment Contract
Smith | [NAME] | Waiter | March | 1995-01-31 00:00:00 | 1998-06-15 00:00:00
Smith | [NAME] | [NAME] | February | 1996-03-05 00:00:00 | 1999-08-16 00:00:00
Smith | [NAME] | Janitor | January | 1996-06-05 00:00:00 | 1999-03-04 00:00:00
Smith | [NAME] | Waiter | March | 1998-09-19 00:00:00 | 2001-02-01 00:00:00
Smith | [NAME] | [NAME] | February | 2000-12-01 00:00:00 | 2003-04-03 00:00:00
Black | [NAME] | Janitor | January | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
White | [NAME] | Waitress | September | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Smith | [NAME] | [NAME] | October | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
[NAME] | [NAME] | [NAME] | November | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Phillips | Todd | Janitor | April | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
[NAME] | [NAME] | Waiter | May | 1999-03-05 00:00:00 | 2002-07-08 00:00:00
Spreadsheet: 114426d1310143211-wildcard-search-using-vlookup-example
Sheet: Sales items

material
056544A.202
059781A
[NAME]
079245A
083299A
083367A
083761A
084742A
085340A
104-009/54
301-007/61
314-108/99
314-205/76
314-333/31A
332-004/93
421-008/54
421-025/32
443-015/07
465525A
465670A
465797A
465798A
465876A
465878A
466141A
466143A
466289A
466293A
466302A
467540A
467843A
467922A
468157A
468188A
468190A
468662A
468662B
468662C
468714A
Spreadsheet: 222535d1363877236-perhaps-conditional-formatting-tabs-sample-resourcing
Sheet: PE

MONTH | 2013 Actual - RFA | 2013 Actual - EHP | 2013 Actual - EHSQ | 2013 Actual - WHP | Total Days Available
December |  |  |  |  | 132
November |  |  |  |  | 126
October |  |  |  |  | 138
September |  |  |  |  | 126
August |  |  |  |  | 132
July |  |  |  |  | 138
June |  |  |  |  | 120
May |  |  |  |  | 138
April |  |  |  |  | 121
March |  |  |  |  | 105
February | 42 | 26.5 | 9.5 |  | 78
January | 40.5 | 39 | 3.5 |  | 110
MONTH | 2013 Forecast - RFA | 2013 Forecast - EHP | 2013 Forecast - EHSQ | 2013 Forecast - WHP | Total Days Available
December | 20 | 55 | 20 |  | 132
November | 20 | 55 | 20 |  | 126
October | 40 | 65 | 20 |  | 138
September | 80 | 65 | 20 |  | 126
August | 80 | 65 | 20 |  | 132
July | 102 | 55 | 20 |  | 138
June | 82 | 60 |  |  | 120
May | 92 | 60 |  |  | 138
April | 74 | 44 |  |  | 121
March | 50 | 54 | 7 |  | 105
February |  |  |  |  | 78
January |  |  |  |  | 110
MONTH | 2013 Combined - RFA | 2013 Combined - EHP | 2013 Combined - EHSQ | 2013 Combined - WHP | Total Days Available
December |  |  |  |  | 132
November |  |  |  |  | 126
October |  |  |  |  | 138
September |  |  |  |  | 126
August |  |  |  |  | 132
July |  |  |  |  | 138
June |  |  |  |  | 120
May |  |  |  |  | 138
April |  |  |  |  | 121
March |  |  |  |  | 105
February |  |  |  |  | 78
January |  |  |  |  | 110
Spreadsheet: 165743d1341330823-pivot-table-help-lighting-equipment-club-brp-gaylord-national-aug-2012
Sheet: Sheet1

Truss Label | Total | Truss 1 | Truss 2 | Truss 3 | Truss 4 | Truss 5 | Truss 6 | Truss 7 | Truss 8 | Truss 9 | Truss 10 | Truss 11 | Truss 12 | Truss 13 | Truss 14 | Truss 15 | Truss 16 | Truss 17
Overall Length |  | 170 | 170 | 230 | 72 | 72 | 48 | 190 | 48 | 40 | 48 | 64 | 36 | 40 | 18 | 18 | 18 | 48
[NAME] |  | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20 | 20x20
Color
12"x12" 10'-0"
12"x12" 8'-0"
12"x18" 10'-0" |  | 17 | 17 | 23 |  |  |  | 19 |  | 4 |  |  | 2 | 4 | 1 | 1 | 1
12"x18"  8'-0" |  |  |  |  | 9 | 9 | 6 |  | 6 |  | 6 | 8 | 2 |  | 1 | 1 | 1 | 6
Chain Motors 1/2 Ton |  | 5 | 5 | 7 | 3 | 3 | 2 | 6 | 2 | 2 | 3 | 3 | 2 | 2 | 1 | 1 | 1 | 3
Lighting Equipment
6 Bar Lamp Bar - S4 Par MFL 575w
Martin EC-10 Video Panels |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14
Video Equipment
(3) Desks (1) [NAME], (1) Presentation Main, (1) Spare
(90) [NAME] or [NAME] 700 can be a combo of both
(3) Hippos or Catalyst for playback on towers, Sea-Doo Wall, & Tech Zone Wall
Spreadsheet: 688506d1595833575-match-two-cells-returning-data-from-third-cell-two-cell-match
Sheet: Lookup

Heading 1 | Heading 2 | Heading 3 |  | Heading 1 | Heading 2 | Export.Heading 1
ghi | CD | 1234A |  | ghi | CD | 1234A
[NAME] | KL | 8765R |  | def | AB | 6543F
jkl | EF | 987U |  | [NAME] | KL | 8765R
def | AB | 6543F |  | jkl | EF | 987U
pqr | IJ | 982L |  | mno | GH | 57648Z
mno | GH | 57648Z |  | pqr | IJ | 982L
Spreadsheet: 115299d1310957292-please-help-with-linking-data-from-one-table-to-another-copy_for_testing-chadoak-delivery-plan
Sheet: Maintenance

 |  |  |  | Maintenance
 |  |  |  |  | Cert | enrolled y/n
 | 1 | MATTHEW | BOOTH | PLUMBER | 3 |  | Maintenance |  | 28_6_11
 | 2 | CHRISTOPHER | DENDLE | [NAME] | 3 |  | Maintenance
 | 3 | PHILIP | GILBERT | PLUMBER | 3 |  | Maintenance |  | 28_6_11
 | 4 | PAUL | GRIFFIN | MANAGER | 4 |  | Office |  | 28_6_11
 | 5 | GREG | MILES | SITE MANAGER | 4 |  | Maintenance
 | 6 | EVAN | CORRELJE | PLUMBER | 4 |  | Maintenance
 | 7 | Wayne | [NAME] | Plumber | 4 |  | Maintenance
 | 8 | Sean | Condon | Plumber | 4 |  | Maintenance
 | 9 | [NAME] | FROILAND | MECHANIC | 4 |  | Office |  | 23_6_11
 | 10 | [NAME] | LEWIS | PLUMBER - Supervisor | dip |  | Maintenance |  | 28_6_11 | dip
 | 11 | CONNIE | MILONAS | BUSINESS ADMIN GRADE 3-20 YRS | dip |  | Maintenance |  | 23_6_11
 | 12 | MITCHELL | CLYDESDALE | APPRENTICE 4TH YEAR | dip |  | Maintenance
 | 13 | SHANE | GRIFFIN | APPRENTICE PLUMBER 1st YEAR | dip |  | Maintenance
 | 14 | PAUL | JONES | APPRENTICE 1ST YEAR PLUMBER | dip |  | Maintenance
 | 15 | [NAME] | Hamshere | Plumber | dip |  | Maintenance
 | 16 | [NAME] | BOOTH | Apprentice | dip |  | Maintenance
 | 17 |  |  |  |  |  | Maintenance
Spreadsheet: 6d4c5fdd-2cf8-43df-a766-0bed851d5c32
Sheet: Sheet1

[NAME] | Relevant genotype | Reference
NKI2148 | MATa [NAME] lys2Δ0 met15Δ0 ura3Δ0 hhf1-hht1∆::LEU2 hht2::HHT2-LoxP-HA-HPHMX-LoxP-T7 HIS3::PTDH3-CRE-EBD78 bar1∆::HisG | [NAME].
NKI2169 | NKI2148 hhf2::HHF2Δ3-18 + HHT2-HHF2 | This study
NKI2215 | MATa [NAME]trp1∆63 ura3∆0 met15∆0 | This study
 | [NAME] HIS3::PTDH3-CRE-EBD78 bar1∆::HisG hht2::HHT2-LoxP-HA-HPHMX-LoxP-T7
NKI2245 | [NAME] | This study1
NKI2219 | MATa [NAME]trp1∆63 ura3∆0 met15∆0 | This study
 | [NAME] bar1∆::HisG   HIS3-PTDH3-CRE-EBD78
 | hht2::HHT2-LoxP-HA-HPHMX-LoxP-T7 pol30∆::KANMX
NKI2225 | NKI2219  pBL230 (pRS314-POL30-WT) | This study
NKI2226 | NKI2219  pBL230.1 (pRS314-pol30-E3A-K5A) | This study
NKI2227 | NKI2219  pBL230.8 (pRS314-pol30-R61A-D63A) | This study
[NAME] | NKI2219  pBL230.79 (pRS314-pol30-L126A-I128A) | This study
NKI4114 | MATα his3∆1 leu2∆0 ura3∆0 met15∆0 can1∆::PSTE2-Sp-his5 hhf1-hht1∆::LEU2 hht2::HHT2-LoxP-HA-HPHMX-LoxP-T7 lyp1∆::NATMX-PTDH3-CRE-EBD78 | This study2
BY4741 | MATa his3∆1 leu2∆0 met15∆0 ura3∆0 | Open biosystems
NKI4128 | MATa his3∆1 leu2∆0 met15∆0 ura3∆0 can1∆::PSTE2-Sp-his5 hhf1-hht1∆::LEU2 hht2::HHT2-LoxP-HA-HPHMX-LoxP-T7 lyp1∆::NATMX-PTDH3-CRE-EBD78 | This study
NKI2236 | NKI4128 cac1∆::KANMX | This study
NKI2235 | NKI4128 top1∆::KANMX | This study
NKI4188 | NKI4128 swd1∆:: KANMX | This study
NKI4189 | NKI4128 swd3∆::KANMX | This study
NKI4190 | NKI4128 set2∆::KANMX | This study
NKI4088 | [NAME] | This study
NKI2194 | NKI2148 hhf2-K5,12R (H4-K5R,[NAME]) | This study
NKI2288 | NKI2148 [NAME] nhp6b∆:: NATMX | This study
1Generated using a derivative of plasmid pKL187 (K. Labeeb) in which the CUP1 promoter was replaced by a MET3 promoter fragment
2Derived from Y7092 (gift from C. Boone)
Spreadsheet: 871686d1718109063-modifying-table-to-be-more-dynamic-book3-1-
Sheet: lepingud

Number | Name | [NAME] | Üürilepingu kood | Code | Kinnistu aadress | Kinnistu piirkond | Client | Start year | End year | Kap.komp | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
5 | Name5 |  |  | SEEMNE200 |  |  | Client1 | 2018-01-01 00:00:00 | 2029-10-31 00:00:00 |  |  |  |  |  |  | 7657 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 2222 | 2222 | 2222 | 2222 | 2222
6 | Name6 |  |  | PURAVIKU4 |  |  | Client2 | 2020-01-01 00:00:00 | 2026-10-31 00:00:00 |  |  |  |  | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222
7 | Name7 |  |  | TOOME5 |  |  | Client3 | 2020-01-01 00:00:00 | 2024-10-31 00:00:00 |  |  | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 1111 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222 | 2222
8 | Name8 |  |  | KEEVISE14 |  |  | Client4 | 2019-01-01 00:00:00 | 9999-12-31 00:00:00 |  |  |  |  |  |  | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000 | 8000