tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 781243d1653078366-2-variable-vlookup-help-workticket-test-info-5-20-2022
Sheet: Work Ticket info

 |  | [NAME] |  |  |  |  | [NAME]
 |  | WorkTicketNo | StepLineKey | Description |  |  | WorkTicketNo | StepLineKey | Description
 |  | 31903.3.1 | 000014 |  |  |  | 31903.3.1 | 000001 | General Instructions
 |  | 31903.3.1 | 000015 |  |  |  | 31903.3.1 | 000002 | Purchasing Instructions
 |  | 31903.3.1 | 000016 |  |  |  | 31903.3.1 | 000003 | Incoming Inspection
 |  | 31903.3.1 | 000016 |  |  |  | 31903.3.1 | 000004 | Fabrication Instructions
 |  | 31903.3.1 | 000014 |  |  |  | 31903.3.1 | 000005 | Fabricate
 |  | 31903.3.1 | 000012 |  |  |  | 31903.3.1 | 000006 | In-Process Inspection
 |  | 31903.3.1 | 000016 |  |  |  | 31903.3.1 | 000007 | Coating Instructions
 |  | 31903.3.1 | 000010 |  |  |  | 31903.3.1 | 000008 | Coating 1 Test Run
 |  | 31903.3.1 | 000018 |  |  |  | 31903.3.1 | 000009 | Pre-Coat Preparation 1
 |  | 31903.3.1 | 000016 |  |  |  | 31903.3.1 | 000010 | Coat Side 1
 |  |  |  |  |  |  | 31903.3.1 | 000011 | Measure Coating Results
 |  |  |  |  |  |  | 31903.3.1 | 000012 | Pre-Coat Preparation 2
 |  |  |  |  |  |  | 31903.3.1 | 000013 | Coat Side 2
 |  |  |  |  |  |  | 31903.3.1 | 000014 | Measure Coating Results
 |  |  |  |  |  |  | 31903.3.1 | 000015 | Photolith Patterning
 |  |  |  |  |  |  | 31903.3.1 | 000016 | Pre-Coat Preparation 3
 |  |  |  |  |  |  | 31903.3.1 | 000017 | Coat Side 3
 |  |  |  |  |  |  | 31903.3.1 | 000018 | Photo Lift Off
 |  |  |  |  |  |  | 31903.3.1 | 000019 | Pre-Coat Preparation - 4
 |  |  |  |  |  |  | 31903.3.1 | 000027 | Coat Side 4
 |  |  |  |  |  |  | 31903.3.1 | 000020 | Measure Coating Results
 |  |  |  |  |  |  | 31903.3.1 | 000021 | Post-Coating Validation
 |  |  |  |  |  |  | 31903.3.1 | 000022 | Quality Inspection
 |  |  |  |  |  |  | 31903.3.1 | 000023 | Env/Dur/Other Testing
 |  |  |  |  |  |  | 31903.3.1 | 000024 | Shipping Validation
 |  |  |  |  |  |  | 31903.3.1 | 000025 | Packaging/Labeling
 |  |  |  |  |  |  | 31903.3.1 | 000026 | Customer Shipment
Spreadsheet: 719427d1613661045-sumifs-formula-not-valid-value-hh_job_-template_2021
Sheet: Bonus WK 1

 | Week 1 - Bonus Hours
 | Begin Date:
 | End Date:
 | Employee | Bonus Hours
Spreadsheet: 768393d1644944824-index-match-that-compares-if-date-is-between-two-dates-and-returns-yes-or-no-jjoseph08-practice
Sheet: Date Ranges

Week 1 | 2022-01-03 00:00:00 | 2022-01-09 00:00:00
Week 2 | 2022-01-10 00:00:00 | 2022-01-16 00:00:00
Week 3 | 2022-01-17 00:00:00 | 2022-01-23 00:00:00
Week 4 | 2022-01-24 00:00:00 | 2022-01-30 00:00:00
Week 5 | 2022-01-31 00:00:00 | 2022-02-06 00:00:00
Week 6 | 2022-02-07 00:00:00 | 2022-02-13 00:00:00
Week 7 | 2022-02-14 00:00:00 | 2022-02-20 00:00:00
Week 8 | 2022-02-21 00:00:00 | 2022-02-27 00:00:00
Week 9 | 2022-02-28 00:00:00 | 2022-03-06 00:00:00
Week 10 | 2022-03-07 00:00:00 | 2022-03-13 00:00:00
Week 11 | 2022-03-14 00:00:00 | 2022-03-20 00:00:00
Week 12 | 2022-03-21 00:00:00 | 2022-03-27 00:00:00
Week 13 | 2022-03-28 00:00:00 | 2022-04-03 00:00:00
Week 14 | 2022-04-04 00:00:00 | 2022-04-10 00:00:00
Week 15 | 2022-04-11 00:00:00 | 2022-04-17 00:00:00
Week 16 | 2022-04-18 00:00:00 | 2022-04-24 00:00:00
Week 17 | 2022-04-25 00:00:00 | 2022-05-01 00:00:00
Week 18 | 2022-05-02 00:00:00 | 2022-05-08 00:00:00
Week 19 | 2022-05-09 00:00:00 | 2022-05-15 00:00:00
Week 20 | 2022-05-16 00:00:00 | 2022-05-22 00:00:00
Week 21 | 2022-05-23 00:00:00 | 2022-05-29 00:00:00
Week 22 | 2022-05-30 00:00:00 | 2022-06-05 00:00:00
Week 23 | 2022-06-06 00:00:00 | 2022-06-12 00:00:00
Week 24 | 2022-06-13 00:00:00 | 2022-06-19 00:00:00
Week 25 | 2022-06-20 00:00:00 | 2022-06-26 00:00:00
Week 26 | 2022-06-27 00:00:00 | 2022-07-03 00:00:00
Week 27 | 2022-07-04 00:00:00 | 2022-07-10 00:00:00
Week 28 | 2022-07-11 00:00:00 | 2022-07-17 00:00:00
Week 29 | 2022-07-18 00:00:00 | 2022-07-24 00:00:00
Week 30 | 2022-07-25 00:00:00 | 2022-07-31 00:00:00
Week 31 | 2022-08-01 00:00:00 | 2022-08-07 00:00:00
Week 32 | 2022-08-08 00:00:00 | 2022-08-14 00:00:00
Week 33 | 2022-08-15 00:00:00 | 2022-08-21 00:00:00
Week 34 | 2022-08-22 00:00:00 | 2022-08-28 00:00:00
Week 35 | 2022-08-29 00:00:00 | 2022-09-04 00:00:00
Week 36 | 2022-09-05 00:00:00 | 2022-09-11 00:00:00
Week 37 | 2022-09-12 00:00:00 | 2022-09-18 00:00:00
Week 38 | 2022-09-19 00:00:00 | 2022-09-25 00:00:00
Week 39 | 2022-09-26 00:00:00 | 2022-10-02 00:00:00
Week 40 | 2022-10-03 00:00:00 | 2022-10-09 00:00:00
Week 41 | 2022-10-10 00:00:00 | 2022-10-16 00:00:00
Week 42 | 2022-10-17 00:00:00 | 2022-10-23 00:00:00
Week 43 | 2022-10-24 00:00:00 | 2022-10-30 00:00:00
Week 44 | 2022-10-31 00:00:00 | 2022-11-06 00:00:00
Week 45 | 2022-11-07 00:00:00 | 2022-11-13 00:00:00
Week 46 | 2022-11-14 00:00:00 | 2022-11-20 00:00:00
Week 47 | 2022-11-21 00:00:00 | 2022-11-27 00:00:00
Week 48 | 2022-11-28 00:00:00 | 2022-12-04 00:00:00
Week 49 | 2022-12-05 00:00:00 | 2022-12-11 00:00:00
Week 50 | 2022-12-12 00:00:00 | 2022-12-18 00:00:00
Week 51 | 2022-12-19 00:00:00 | 2022-12-25 00:00:00
Week 52 | 2022-12-26 00:00:00 | 2023-01-01 00:00:00
Spreadsheet: 868960d1715670005-from-dropdown-list-match-across-multiple-sheets-dropdown-match-across-multiple-sheets
Sheet: ShivMilk

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 to 10 |  |  | 11 to 20 |  |  | 21 to EOM
Helper | Date | Item | Qty | Rate | Amt | Daily Amt | 10 days Amt |  | Month | 1 to 10 | 11 to 20 | 21 to EOM | Purchase |  | Total Paid | Cheque | Online | Cash | Cheque | Online | Cash | Cheque | Online | Cash
 | 2024-04-01 00:00:00 | Milk | 15.5 | 48 |  |  |  |  | 2024-01-01 00:00:00
 | 2024-04-02 00:00:00 | Milk | 8 | 48 |  |  |  |  | 2024-02-01 00:00:00
 | 2024-04-03 00:00:00 | Milk | 12 | 48 |  |  |  |  | 2024-03-01 00:00:00
 | 2024-04-04 00:00:00 | Milk | 6 | 48 |  |  |  |  | 2024-04-01 00:00:00 |  |  |  |  |  |  | 5725 |  |  | 5550 |  |  |  | 4200
 | 2024-04-05 00:00:00 | Milk | 10 | 48 |  |  |  |  | 2024-05-01 00:00:00
 | 2024-04-06 00:00:00 | Milk | 12 | 48 |  |  |  |  | 2024-06-01 00:00:00
 | 2024-04-07 00:00:00 | Milk | 12 | 48 |  |  |  |  | 2024-07-01 00:00:00
 | 2024-04-08 00:00:00 | Milk | 13 | 48 |  |  |  |  | 2024-08-01 00:00:00
 | 2024-04-09 00:00:00 | Milk | 14 | 48 |  |  |  |  | 2024-09-01 00:00:00
 | 2024-04-10 00:00:00 | Milk | 12 | 48 |  |  |  |  | 2024-10-01 00:00:00
 | 2024-04-12 00:00:00 | Milk | 15 | 48 |  |  |  |  | 2024-11-01 00:00:00
 | 2024-04-13 00:00:00 | Milk | 15 | 48 |  |  |  |  | 2024-12-01 00:00:00
 | 2024-04-14 00:00:00 | Milk | 13 | 48 |  |  |  |  | Year Total
 | 2024-04-15 00:00:00 | Milk | 12 | 48
 | 2024-04-16 00:00:00 | Milk | 7 | 48
 | 2024-04-17 00:00:00 | Milk | 10 | 48
 | 2024-04-18 00:00:00 | Milk | 10 | 48
 | 2024-04-19 00:00:00 | Milk | 12 | 48
 | 2024-04-20 00:00:00 | Milk | 17 | 48
 | 2024-04-21 00:00:00 | Milk | 6 | 48
 | 2024-04-22 00:00:00 | Milk | 12 | 48
 | 2024-04-23 00:00:00 | Milk | 12 | 48
 | 2024-04-24 00:00:00 | Milk | 12 | 48
 | 2024-04-25 00:00:00 | Milk | 13 | 48
 | 2024-04-26 00:00:00 | Milk | 17 | 48
 | 2024-04-27 00:00:00 | Milk | 12 | 48
 | 2024-05-01 00:00:00 | Milk | 15 | 48
 | 2024-05-03 00:00:00 | Milk | 8 | 48
 | 2024-05-04 00:00:00 | Milk | 10 | 48
 | 2024-05-05 00:00:00 | Milk | 10 | 48
 | 2024-05-06 00:00:00 | Milk | 13 | 48
 | 2024-05-07 00:00:00 | Milk | 15 | 48
 | 2024-05-08 00:00:00 | Milk | 8 | 48
 | 2024-05-09 00:00:00 | Milk | 10 | 48
 | 2024-05-10 00:00:00 | Milk | 8 | 48
 | 2024-05-11 00:00:00 | Milk | 4 | 48
Spreadsheet: 781821d1653570375-a-formula-that-looking-in-sheet-1-and-if-the-name-matches-pulls-through-an-id-sample-of-report-aligw
Sheet: Production

 |  |  |  | I want to get the sheet to search the front sheet for any laptop IDs for these people that
 |  |  |  | may be listed in the front sheet and for the appropriate Laptop ID to appear in the cell next to the correct name.
Company | Full Name ([NAME]) (Cells D & E) | First Name | Last Name | LAPTOP ID
AH |  | [NAME] | Smith
AH |  | [NAME] | Smart
TCS |  | Victoria | McColl
TCS |  | Martin | [NAME]
TCS |  | [NAME] | Soanes
TCS |  | [NAME] | Cooper
Spreadsheet: 85365d1285374297-calculate-date-using-nested-ifs-dates_g
Sheet: Holiday List

 | Holiday List
 | Enter Year | 2007 | Actual Day
Spreadsheet: 4014c051-d71c-4e46-aba1-8842c491bfe0
Sheet: Sheet1

Cabot Industrial Trust | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
Form for Providing 2000 Year-End Tax Reporting Information
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Income |  |  |  |  |  |  |  |  |  |  |  |  |  | Unrecaptured
 | Allocations |  |  |  |  |  |  |  | Cash | Taxable |  |  |  |  | Section 1250 |  | Exempt- | Alternative | Foreign
 | F=Final | Security |  | Ticker | Issuer | Declaration | Record | Payable | Distribution | Ordinary | Short-term | Return of | 28 Percent | 20 Percent | Gain | Section 1202 | Interest | Minimum | Tax
Status | E=Estimated | Description | CUSIP | Symbol | Class. | Date | Date | Date | Per Share | Dividend | Capital  Gain | Capital | Rate  Gain | Rate Gain | (25 Percent) | Gain | Dividend | Tax Amount | Gross Up
 |  | Common | 127072106 | CTR | 1 | 12/08/1999 | 12/31/1999 | 01/19/2000 | 0.15 | 0.15 |  |  |  |  |  | 0 | 0 |  | 0
 |  | Common | 127072106 | CTR | 1 | 03/08/2000 | 04/10/2000 | 04/28/2000 | 0.355 | 0.355 |  |  |  |  |  | 0 | 0 |  | 0
 |  | Common | 127072106 | CTR | 1 | 05/10/2000 | 07/10/2000 | 07/28/2000 | 0.355 | 0.355 |  |  |  |  |  | 0 | 0 |  | 0
 |  | Common | 127072106 | CTR | 1 | 09/14/2000 | 10/10/2000 | 10/27/2000 | 0.355 | 0.355 |  |  |  |  |  | 0 | 0 |  | 0
 |  | Common | 127072106 | CTR | 1 | 12/05/2000 | 12/21/2000 | 01/30/2001 | 0.165 | 0.165 |  |  |  |  |  | 0 | 0 |  | 0
S |  | Common | 127072106 | CTR | 1 | 12/05/2000 | 12/21/2000 | 01/30/2001 | 0.19 | 0.19 | 0 | 0 | 0 | 0
 | F | Totals for 2000 |  |  |  |  |  |  | 1.38 | 1.38 |  |  |  |  |  | 0 | 0 | 0.0525 | 0
Notes:
The dividend declared in 1999 is deemed to 2000.
The entire Q4 dividend was $0.3550, $0.1650 deemed to 2000 and $0.1900 deemed to 2001.
Spreadsheet: 66311d1266998743-remove-all-but-last-row-for-set-of-entries-uploadtes
Sheet: Sheet1

Account | Value
24257853 | 25
24546373 | 58.14
24649413 | 98.03
24649413 | 500
24702013 | 5
24825333 | 5
24825333 | 10
24825333 | 15
24828683 | 5
24886023 | 10
25041313 | 20
25041313 | 40
Spreadsheet: 718119d1612991007-drop-down-lists-and-choosing-from-a-table-sample-project
Sheet: Sheet2

 | BDA Vendor
 | Choose One |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cable:
 | ADRF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Splitters:
 | Safe-Com |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Connectors:
 | Solid
 | Comba
 | Wattage
 | Choose One
 | .5 W
 | 2 W
 | 5 W
 | 20 W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .5 [NAME] | 2 Watt | 5 Watt | 20 Watt | VHF | UHF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 7657.13 | 9561.85 | - | - | 20000 | 20000
 | Venue Type | Radius | Sq. Footage | [NAME] | Cable | Splitters | Connectors | Jumpers |  |  |  |  |  |  |  |  | ADRF | - | 6600 | 11000 | - | 20000 | 20000
 | Choose One |  |  |  | 250 |  |  |  |  |  |  |  |  |  |  |  | Safe-Comm |  |  |  | - | 20000 | 20000
 | Apartment | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Solid |  |  |  | - | - | -
 | Educational | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comba | 7061.5 | 8235.3 | - | - | 20000 | 20000
 | Hospital | 50
 | Manufacturing | 70
 | Office | 70
 | Warehouse | 80
 | Other | 65
 | System Type
 | Choose One
 | 700
 | 800
 | 700/800
 | UHF
 | VHF
 | Fiber Needed
 | Choose One
 | Yes
 | No
Spreadsheet: 124208d1318244228-using-sumproduct-with-autofilter-book1
Sheet: Sheet1

 |  |  |  |  |  |  | Subtotal
 |  |  |  |  | Customer | Month |  | $
 |  |  |  |  | Coles | June |  | 1000
 |  |  |  |  |  | July |  | 4000
 |  |  |  |  | WoW | August |  | 3000
 |  |  |  |  | Big W | August |  | 2000
 |  |  |  |  | Revised
 |  |  |  |  | Original
Spreadsheet: 356605d1415159135-taking-average-in-7-cells-in-a-column-problem-1_avg
Sheet: Sheet1

 | SN | Point | Average
 | 1 | 12
 | 2 | 13
 | 3 | 15
 | 4 | 15
 | 5 | 11
 | 6 | 8
 | 7 | 3
 | 8 | 2
 | 9 | 3
 | 10 | 5
 | 11 | 7
 | 12 | 11
 | 13 | 23
 | 14 | 23
 | 15 | 2
 | 16 | 12
 | 17 | 34
 | 18 | 11
 | 19 | 24
 | 20 | 14
 | 21 | 12
 | 22 | 4
 | 23 | 12
 | 24 | 3
 | 25 | 2
 | 26 | 1
 | 27 | 11
 | 28 | 2
Spreadsheet: 0631d7b6-9649-410f-8baf-7baf5f9d96bf
Sheet: +55 Seeding List

55+ MS (47)
No | Member ID | LastName | FirstName | Country | Gender | Seed
1 | 578 | TRAVERS | [NAME] | SCO | M | 1
2 | 52504 | KOLOSKOV | [NAME] | RUS | M | 2
3 | 483 | SANTOSA | Uun Setiawan | NED | M | 3/4
4 | 88890 | BUSHUEV | Sergey | RUS | M | 3/4
5 | 136 | FAROOQ | Tariq | AUT | M | 5/8
6 | 89962 | MEIER | [NAME] | DEN | M | 5/8
7 | 87496 | KAWAGUCHI | Toshio | JPN | M | 5/8
8 | 52503 | SMIRNOV | Yuri | RUS | M | 5/8
55+ WS (15)
No | Member ID | LastName | FirstName | Country | Gender | Seed
1 | 964 | BENDER | [NAME] | GER | F | 1
2 | 189 | BLACK | Christine | SCO | F | 2
55+ MD (28)
No | Member ID 1 | Member ID 2 | Lastname 1 | Firstname 1 | Lastname 2 | Firstname 2 | Country 1 | Country 2 | Gender 1 | Gender 2 | Seed
1 | 192 | 142 | HELLEDIE | Jesper | FLADBERG | Steen | DEN | DEN | M | M | 1
2 | 73879 | 68818 | PANITCHAIKUL | Jiamsak | [NAME] | Surapong | THA | THA | M | M | 2
3 | 52510 | 578 | DOUGLAS | [NAME] | TRAVERS | [NAME] | SCO | SCO | M | M | 3/4
4 | 79096 | 93035 | OCHIAI | Hisao | TAKAOKA | Katsura | JPN | JPN | M | M | 3/4
55+ WD (12)
No | Member ID 1 | Member ID 2 | Lastname 1 | Firstname 1 | Lastname 2 | Firstname 2 | Country 1 | Country 2 | Gender 1 | Gender 2 | Seed
1 | 189 | 1202 | BLACK | Christine | RIDDER | Marjan | SCO | NED | F | F | 1
2 | 87523 | 97850 | [NAME] | Birte | AAGAARD | [NAME] | DEN | DEN | F | F | 2
55+ XD (25)
No | Member ID 1 | Member ID 2 | Lastname 1 | Firstname 1 | Lastname 2 | Firstname 2 | Country 1 | Country 2 | Gender 1 | Gender 2 | Seed
1 | 461 | 1202 | RIDDER | [NAME] | RIDDER | Marjan | NED | NED | M | F | 1
2 | 578 | 189 | TRAVERS | [NAME] | BLACK | Christine | SCO | SCO | M | F | 2
3 | 136 | 964 | FAROOQ | Tariq | BENDER | [NAME] | AUT | GER | M | F | 3/4
4 | 52418 | 64960 | TAYLOR | [NAME] | STRETCH | [NAME] | ENG | ENG | M | F | 3/4
Spreadsheet: 477159d1472150818-formula-to-add-row-data-if-blank-then-data-from-different-sheet-with-reference-criteria-sumofthings_response
Sheet: Completed

 |  | Comp | Comp | Comp | Comp | Comp | Comp
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD
 | C Holcom | 15 | 30 | 60 | 100 | 225 | 300
 | A Ivanson | 20 | 60 | 100 | 160 | 400 | 640
 | B Risuto | 20 | 85 | 140 | 200 | 450 | 700
 | M Franklin | 20 | 85 | 140 | 200 | 450 | 700
Spreadsheet: 726067d1617032177-select-a-cell-from-a-list-of-100-cells-example-2
Sheet: INPUT

1 | x
2 | x
3 | x
4 | x
5 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
Spreadsheet: e9fecdce-194d-41fa-8a24-6744ebfb89f3
Sheet: Sheet1

Table S11 - MLPA results from the analysis of 21 independent spore isolates from rtt109Δ +8 diploids
Isolatea | Events in Initial Fluctuation Cultureb | Events in YPD Cultureb | Events in GCR Cultureb | GCR Ratesc
RDKY7709-1 | +8 | +8 | -5L, +12R,+8 | 2.10585116378348e-06
RDKY7709-2 | +8 | +8 | -5L, +16R, +8 | 6.25697712926699e-06
RDKY7709-3 | +8 | +8 | -5L, +10R, +8 | 7.60136870959031e-07
RDKY7709-4 | +8 | +8 | -5L, +5R, +8 | 1.60778104318612e-06
RDKY7709-5 | +8 | +8 | -5L, +3R, +8 | 2.88292311281241e-06
RDKY7709-6 | +8 | +8 | -5L, +12R, +8 | 3.87055576012934e-06
RDKY7709-7 | +8 | +8 | -5L, +14L, +8 | 1.58152041546565e-06
RDKY7710-1 | +8 | +8 | -5L, +12R, +8 | 2.85073989314972e-06
RDKY7710-2 | - | - | -5L, +3R | 1.31800621362051e-06
RDKY7710-3 | +8 | +8 | -5L, +5R, +8 | 1.52083559844759e-06
RDKY7710-4 | +8 | +8 | -5L, +3R, +8 | 3.09212937838481e-06
RDKY7710-5 | - | - | -5L, +10R, +12 | 2.24889821934994e-06
RDKY7710-6 | +9 | +9 | -5L, +5R, +9 | 3.610881066949e-06
RDKY7710-7 | +8 | +8 | -5L, +12R, +8 | 2.46702474247252e-06
RDKY7711-1 | +8 | +8 | -5L, +14L, +8 | 2.19017861812806e-06
RDKY7711-2 | - | - | -5L, +3L, +12 | 1.14008605364754e-06
RDKY7711-3 | - | - | -5L, +12L, +12 | 1.01274888062033e-06
RDKY7711-4 | - | - | -5L, +3R, +8L, +8Rd | 1.13950740215639e-06
RDKY7711-5 | +8 | +8 | -5L, +8L, +8 | 1.42177485717712e-06
RDKY7711-6 | +8 | +8 | -5L, +12R, +8 | 2.15854308282915e-06
RDKY7711-7 | +8 | +8 | -5L, +4R, +8 | 3.10764665149748e-06
a 7 isolates each from the indicated RDKY strains were isolated from random sporulations, tested for mating type MATa, and then used in the initial starting culture for the fluctuation tests.
b Events are relative to the indicated chromosome number. "+": duplication, "-": deletion, "L": specifically left arm, "R": specifically right arm. Single "-" indicates no event. For example, "+8" indicates a whole chromosome duplication of chrVIII, "+8R" a duplication of the right arm of chrVIII, and "-" indicates no event.
c measured in events/cell/generation
d Isolate had duplicated telomeric ends of chrVIII but did not have duplicated centromeric regions of the chromosome
Spreadsheet: 121150d1315871237-if-and-search-or-find-fuctions-together-photo-metadata-test
Sheet: Photo Metatdata

Name | Title | Title | Title | Contract Package No | Procuremnet No. | Project Name | Document Type | Photo Date |  |  | Photographer Name |  |  |  | Photo Direction | Photo Phase |  |  |  |  |  | Building No. | Description | Date Picture Taken | Record Type | Records Center Status | Keywords
U220 TB 01-01-01 - NW XOB Test.jpg
U220 TB 01-01-01 - N NBT Test.jpg
U220 DWD 01-01-01 - S SBT Test.jpg
U220 DGD 01-01-01 - SE SUR Test.jpg
This is what I want to happen from what is pasted into this column | Test |  |  |  |  |  |  | 01-01-01 |  |  | Name that is tied to the initials |  |  |  | Direction | filled manually |  |  |  |  |  | See example in A2 and sheet 2 | same as b2 | entered manually | n/a | n/a | n/a
Spreadsheet: 171895d1343907686-conditional-formatting-for-deadlines-work_order_log
Sheet: Current

Current Work Orders |  | Date
Job Number | Description | Date Started | Deadline
9450 | Network Protector - NT 100 at Richmond and King | 2012-06-18 00:00:00 | 2012-08-03 00:00:00
9465 | Fault Indicators in [NAME] area | 2012-07-17 00:00:00 | 2013-01-01 00:00:00
9471 | Secondary Pedestal Replacement | 2012-07-24 00:00:00 | 2013-01-01 00:00:00
9472 | Manhole Repairs ([NAME] and [NAME]) | 2012-07-24 00:00:00 | 2012-08-15 00:00:00
9474 | Cable Fault on [NAME] and Scottsdale St. in Lambeth area | 2012-07-31 00:00:00 | 2012-08-15 00:00:00
Spreadsheet: 218924d1362608885-formula-check-returning-n-a-diststar_amie797
Sheet: Sheet2

Dist | Store | Day | Time | STAR
95 | 486 | Mon, [NAME] 04 | 7:00 AM | 0
95 | 486 | Mon, [NAME] 04 | 8:00 AM | 2.17
95 | 486 | Mon, [NAME] 04 | 9:00 AM | 3.29
95 | 486 | Mon, [NAME] 04 | 10:00 AM | 4.86
95 | 486 | Mon, [NAME] 04 | 11:00 AM | 6.71
95 | 486 | Mon, [NAME] 04 | 12:00 PM | 9.67
95 | 486 | Mon, [NAME] 04 | 1:00 PM | 6
95 | 486 | Mon, [NAME] 04 | 2:00 PM | 9
95 | 486 | Mon, [NAME] 04 | 3:00 PM | 10.67
95 | 486 | Mon, [NAME] 04 | 4:00 PM | 11.6
95 | 486 | Mon, [NAME] 04 | 5:00 PM | 11
95 | 486 | Mon, [NAME] 04 | 6:00 PM | 8.8
95 | 486 | Mon, [NAME] 04 | 7:00 PM | 4.8
95 | 486 | Mon, [NAME] 04 | 8:00 PM | 5.2
95 | 486 | Mon, [NAME] 04 | 9:00 PM | 0
95 | 486 | Mon, [NAME] 04 | 10:00 PM | 0
86 | 488 | Mon, [NAME] 04 | 7:00 AM | 0
86 | 488 | Mon, [NAME] 04 | 8:00 AM | 2.33
86 | 488 | Mon, [NAME] 04 | 9:00 AM | 4.2
86 | 488 | Mon, [NAME] 04 | 10:00 AM | 7.5
86 | 488 | Mon, [NAME] 04 | 11:00 AM | 5.29
86 | 488 | Mon, [NAME] 04 | 12:00 PM | 7.71
86 | 488 | Mon, [NAME] 04 | 1:00 PM | 5.57
86 | 488 | Mon, [NAME] 04 | 2:00 PM | 4.62
86 | 488 | Mon, [NAME] 04 | 3:00 PM | 6.33
86 | 488 | Mon, [NAME] 04 | 4:00 PM | 4.33
86 | 488 | Mon, [NAME] 04 | 5:00 PM | 8.25
86 | 488 | Mon, [NAME] 04 | 6:00 PM | 6.5
86 | 488 | Mon, [NAME] 04 | 7:00 PM | 7.75
86 | 488 | Mon, [NAME] 04 | 8:00 PM | 4.33
86 | 488 | Mon, [NAME] 04 | 9:00 PM | 0
28 | 494 | Mon, [NAME] 04 | 7:00 AM | 0
28 | 494 | Mon, [NAME] 04 | 8:00 AM | 2.83
28 | 494 | Mon, [NAME] 04 | 9:00 AM | 3.67
28 | 494 | Mon, [NAME] 04 | 10:00 AM | 5.67
28 | 494 | Mon, [NAME] 04 | 11:00 AM | 5.29
28 | 494 | Mon, [NAME] 04 | 12:00 PM | 4.67
28 | 494 | Mon, [NAME] 04 | 1:00 PM | 5.29
28 | 494 | Mon, [NAME] 04 | 2:00 PM | 4.57
28 | 494 | Mon, [NAME] 04 | 3:00 PM | 4.12
28 | 494 | Mon, [NAME] 04 | 4:00 PM | 5.75
28 | 494 | Mon, [NAME] 04 | 5:00 PM | 10.5
28 | 494 | Mon, [NAME] 04 | 6:00 PM | 13
28 | 494 | Mon, [NAME] 04 | 7:00 PM | 8
28 | 494 | Mon, [NAME] 04 | 8:00 PM | 7
28 | 494 | Mon, [NAME] 04 | 9:00 PM | 0
Spreadsheet: 145687d1331710707-autofill-across-worksheets-sample-workbook
Sheet: Financial Position Statement

 |  |  |  | FINANCIAL POSITION STATEMENT
 |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4 | Qtr. 1 | Qtr. 2 | Qtr. 3 | Qtr. 4
Cash Balance | 34663.06692304664 | 43007.76858815222 | 46056.12491239142 | 35532.22067995963 | 31448.30269486112 | 13891.92574388388 | 2645.202731686339 | 0 | 6882.98032584638 | 17664.84087834797 | 57186.0298372883 | 106999.0638455939
Accounts Receivable | 16087.74069301126 | 17078.86538774595 | 14903.84238874365 | 18157.00216586053 | 17350.59894917918 | 16417.32577998072 | 26349.15359888949 | 29124.53244762946 | 28442.50611334585 | 41269.74417321452 | 57019.31511390169 | 64806.82234724137
Finished Product Inventory | 8810.950496743597 | 732.2872699138002 | 0 | 92.39062957992232 | 16001.23095971479 | 0 | 11439.05993330615 | 23065.46892723707 | 35048.21234453439 | 39188.65575986839 | 37305.47921751373 | 22911.43280107127
Raw Material Inventory | 20871.42012072483 | 16918.03038451252 | 12989.88555010545 | 16800 | 4900 | 18400 | 23000 | 24950.0237140097 | 28107.68944038183 | 30841.23577380821 | 15968.11541571884 | 12725.9137420002
Savings Account Balance | 14000 | 11000 | 13000 | 15000 | 17000 | 21000 | 21000 | 21000 | 21000 | 21000 | 25000 | 30000
Total Current Assets
Plant and Equipment Balance | 47058.15825770512 | 46587.57667512807 | 46722.90090837678 | 48056.87189929301 | 48479.00318030007 | 47994.21314849707 | 47514.27101701211 | 47039.12830684199 | 46568.73702377357 | 45982.44965353583 | 45522.62515700048 | 44766.79890543047
Total Assets
Bank Loan Balance | 5000 | 0 | 0 | 0 | 0 | 0 | 3000 | 844.5109921975236 | 0 | 0 | 0 | 0
Bonds Outstanding | 40000 | 38000 | 36000 | 34000 | 32000 | 30000 | 30000 | 30000 | 35000 | 37000 | 37000 | 32000
Capital Stock Value | 63859.4 | 63859.4 | 63859.4 | 63859.4 | 63859.4 | 63859.4 | 63859.4 | 63859.4 | 63859.4 | 63738.8 | 63738.8 | 63438.2
Accum. [NAME] | 32631.93649123143 | 33465.12830545254 | 33813.35375961729 | 35779.0853746931 | 39319.73578405516 | 23844.06467236165 | 35088.2872808941 | 50475.24240352068 | 67190.725247882 | 95208.12623877487 | 137262.764741423 | 186771.8316413373
Total Stockholders' Equity | 96491.33649123146 | 97324.52830545255 | 97672.7537596173 | 99638.48537469309 | 103179.1357840552 | 87703.46467236168 | 98947.68728089408 | 114334.6424035207 | 131050.125247882 | 158946.9262387749 | 201001.564741423 | 250210.0316413373
Total Liabilities
Spreadsheet: 680774d1591192367-xlookup-and-lookup-for-the-nearest-previous-date-xlookup-and-lookup-for-the-nearest-previous-date
Sheet: Sheet1

 |  | Date | North | South
 |  | 2020-04-06 00:00:00 | 159 | 120
 |  | 2020-04-07 00:00:00 | 184 | 176
 |  | 2020-04-08 00:00:00 | 139 | 196
 |  | 2020-04-11 00:00:00 | 186 | 171
 |  | 2020-04-12 00:00:00 | 143 | 178
 |  | 2020-04-13 00:00:00 | 128 | 114
 |  | 2020-04-15 00:00:00 | 165 | 139
 |  | Date | 2020-04-15 00:00:00
 |  | Area | North |  | [NAME]:
 |  | Result
Spreadsheet: 178496d1346814063-need-formula-to-find-matches-then-populate-other-cells-books
Sheet: Sheet1

ID# | Title | [NAME] |  | Titles on Order | [NAME] for Titles on Order
1 | To Kill a Mockingbird | Classics |  | XXXX | xxxxxx
2 | xxxxxxx | Biography |  | XXXXX | xxxxxx
3 | xxxxxxx | Children's |  | To Kill A Mockingbird | Classics
4 | xxxxxxx | xxxx |  | xxxxxx | xxxxxx
5 | xxxxxxx | xxxx
6 | xxxxxxx | xxxx
7 | xxxxxxx | xxxx
8 | xxxxxxx | xxxx
9 | xxxxxxx | xxxx
10 | xxxxxxx | xxxx
11 | xxxxxxx | xxxx
12 | xxxxxxx | xxxx