tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 705119d1605883633-how-to-use-a-formula-in-one-cell-to-mark-other-cells-sample-book-for-forum
Sheet: Sheet1

Data | Data | Data | 2020-11-10 09:20:19
Data | Data | Data | 2020-11-10 09:24:05
Data | Data | Data | 2020-11-10 09:26:47
Data | Data | Data | 2020-11-10 09:29:50
Data | Data | Data | 2020-11-10 09:30:54
Data | Data | Data | 2020-11-10 09:31:32
Data | Data | Data | 2020-11-10 09:36:57
Data | Data | Data | 2020-11-10 09:37:23
Data | Data | Data | 2020-11-10 09:38:22 | 30
Data | Data | Data | 2020-11-10 09:39:55
Data | Data | Data | 2020-11-10 09:40:32
Data | Data | Data | 2020-11-10 09:50:32
Data | Data | Data | 2020-11-10 09:53:26
Data | Data | Data | 2020-11-10 09:54:26
Data | Data | Data | 2020-11-10 09:54:17
Data | Data | Data | 2020-11-10 09:55:22
Data | Data | Data | 2020-11-10 09:56:05
Data | Data | Data | 2020-11-10 09:56:00
Data | Data | Data | 2020-11-10 09:57:45
Data | Data | Data | 2020-11-10 09:58:36
Data | Data | Data | 2020-11-10 09:59:41
Data | Data | Data | 2020-11-10 10:00:07
Data | Data | Data | 2020-11-10 10:02:54
Data | Data | Data | 2020-11-10 10:03:50 | 30
Data | Data | Data | 2020-11-10 10:09:51
Data | Data | Data | 2020-11-10 10:12:48
Data | Data | Data | 2020-11-10 10:13:32
Data | Data | Data | 2020-11-10 10:18:08
Data | Data | Data | 2020-11-10 10:19:48
Data | Data | Data | 2020-11-10 10:23:47
Data | Data | Data | 2020-11-10 10:23:49
Spreadsheet: 878316d1725386755-countifs-function-16-team-league
Sheet: Schedule

Whitby Winter Softball League
- Schedule - Results - Standings -
January - April, 2023 // 6:15 - 12:15
 |  |  |  | STANDINGS
Team # | Team Name |  |  | Place | Team Name |  | W | L | T | Pts | RF | RA | +/- |  |  |  |  | Team Name |  | W | L | T | Pts | RF | RA | +/- | Rank
1 | BS |  |  | 1st
2 | [NAME] |  |  | 2nd
3 | Heavy Set Hitters |  |  | 3rd
4 | Big Stick Energy |  |  | 4th
5 | Dustin Diamonds |  |  | 5th
6 | Revengers |  |  | 6th
7 | [NAME] |  |  | 7th
8 | Ball Slappers |  |  | 8th
9 | Young Bucks |  |  | 9th
10 | IBEW 353 |  |  | 10th
11 | [NAME]'s Assassins |  |  | 11th
12 | Stranger Throws |  |  | 12th
13 | [NAME] |  |  | 13th
14 | Diamond Donkeys |  |  | 14th
15 | Aint That A Pitch |  |  | 15th
16 | Diamond Killerz |  |  | 16th
SCHEDULE
2023-01-07 00:00:00 | Diamond | Home |  | Score | Visitor |  | Score |  |  |  |  |  |  |  |  |  |  | Team Name |  | Game Times
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6: 15 PM | 7:15 PM | 8:15 PM | 9:15 PM | 10:15 PM | 11:15 PM | 12:15 AM | 1:15 AM
6:15 PM | 1
6:15 PM | 2
7:15 PM | 1
7:15 PM | 2
8:15 PM | 1
8:15 PM | 2
9:15 PM | 1
9:15 PM | 2
10:15 PM | 1
10:15 PM | 2
11:15 PM | 1
11:15 PM | 2
12:15 AM | 1
12:15 AM | 2
1:15 AM | 1
1:15 AM | 2
Spreadsheet: 845492d1696994120-if-the-value-in-a-cell-already-exists-how-do-i-increase-another-cells-value-by-1-my-gites
Sheet: Reservations

Client | Reservation ID | Direct ou Booking | Date d'arriver | Date de départ | Gite No. | Duration | Prix par jour | Prix de Séjour | No. Adultes | No. D'enfants | Ménage | Serviettes | Taux de Taxe | Totale Tax | Total Prix | Acompte 1 | Méthod | Acompte 2 | Méthod | [NAME] | A Payé | Payé? |  |  | SPILL Zone for available rooms
1 [NAME] | 1 | Direct | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 | 10 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 9 | 11
2 Bruce Springsteen | 1 | Direct | 2024-01-02 00:00:00 | 2024-01-07 00:00:00 | 2 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 9 | 11
4 [NAME] | 1 | Direct | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 | 12 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 9 | 11
4 [NAME] |  | Direct | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 | 8 |  |  |  | 2 | 3 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 9 | 11
Spreadsheet: 216570d1361813780-still-sumif-question-book2-hb-start-over-14-daily-reconciliation-6
Sheet: Cash Out Summary

 |  |  |  |  |  | Cash Out #:
 |  |  |  | CASH OUT SUMMARY
 | Prepared By: |  |  |  |  | Dept.
 | Opening Date: |  |  |  |  | Closing Date:
 |  |  | TYPE |  | ACCOUNT |  |  | AMOUNT
 | CASH CAMP |  |  |  | 5110
 | ADDITIONAL VEHICLE --- Reg. |  |  |  | 5112
 | ADDITIONAL VEHICLE --- GA |  |  |  | 5112
 | SANITARY DUMP FEES |  |  |  | 5114
 | GROUP CAMP SALES |  |  |  | 5120
 | DAY USE PARKING SALES |  |  |  | 5125
 | GROCERY SALES - NONTAXABLE |  |  |  | 5220
 | GROCERY SALES - TAXABLE |  |  |  | 5225
 | NONGROCERY SALES - TAXABLE |  |  |  | 5230
 | NONGROCERY SALES - NONTAXABLE |  |  |  | 5231
 | WOOD |  |  |  | 5230
 | SEASON PASS |  |  |  | 5205
 | SALES TAX
 | TRANSIENT OCCUPANCY TAX
 |  |  |  |  | Total Accountability
 |  |  |  |  | Less Credit Card Sales
 |  |  |  |  | CASH OUT TOTAL
 |  |  |  |  |  |  | Bank | 25
 | TOTAL CASH & CHECKS |  |  |  |  |  |  | EMP. SIGNATURE:
 | LESS BEGINNING BANK |  |  |  | 25 |  |  | MGR SIGNATURE
 | SUBTOTAL |  |  |  |  |  |  | AUDIT 1:
 | LESS CASH OUT TOTAL |  |  |  |  |  |  | AUDIT 2:
 | DISCREPANCY |  | OVER | SHORT |  |  |  | AUDIT 3:
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: LexisNexis

LexisNexis
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 Price | Price per unit
Academic
Searches | 2595 | 1788 | 3196 | 7736 | 7367 | 4266 | 2724 | 5750 | 6526 | 7270 | 1925 | 1988 |  | 21720
Documents Retrieved | 3708 | 2888 | 3791 | 7817 | 8730 | 5660 | 3990 | 6881 | 7087 | 9194 | 2638 | 2543 |  | 21720
Congressional
Searches | 63 | 20 | 302 | 312 | 283 | 68 | 36 | 118 | 172 | 130 | 77 | 133
Documents Retrieved | 37 | 11 | 239 | 224 | 412 | 27 | 63 | 67 | 195 | 115 | 54 | 357
Environmental
Searches | 0 | 9 | 135 | 299 | 445 | 222 | 32 | 172 | 506 | 329 | 44 | 46 |  | 4200
Documents Retrieved | 0 | 5 | 93 | 273 | 457 | 202 | 4 | 311 | 579 | 261 | 62 | 42 |  | 4200
COUNTER-Compliant?: | No
Spreadsheet: 885511d1735173893-springfield-school-board-assigning-students-to-schools-work-corrected
Sheet: Option 1 - corrected

 | OBJECTIVE
 | Decision Variable
 | Area | School 1 |  |  | School 2 |  |  | School 3 |  |  | Total per area | Sign | [NAME] |  | Total per school
 |  | 6th | 7th | 8th | 6th | 7th | 8th | 6th | 7th | 8th |  |  |  |  | School 1 | School 2 | School 3
 | 1 | 0 | 0 | 0 | 144 | 171 | 135 | 0 | 0 | 0 |  | "=" | 450
 | 2 | 0 | 0 | 0 | 222 | 168 | 210 | 0 | 0 | 0 |  | "=" | 600
 | 3 | 0 | 0 | 11 | 0 | 0 | 20 | 165 | 176 | 178 |  | "=" | 550
 | 4 | 98 | 140 | 112 | 0 | 0 | 0 | 0 | 0 | 0 |  | "=" | 350
 | 5 | 195 | 169 | 135 | 0 | 0 | 0 | 0 | 1 | 0 |  | "=" | 500
 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 153 | 126 | 171 |  | "=" | 450
 | Sub Total
 | Upper cap |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | 1100 | 1000
 | Lower cap
 | Area | School 1 |  |  | School 2 |  |  | School 3 |  |  | Percentage |  |  |  | numbers of students per grade |  |  |  | required numbers of students per grade (calculated from percentages)
 |  | 6th | 7th | 8th | 6th | 7th | 8th | 6th | 7th | 8th | 6th grade | 7th grade | 8th grade |  | 6th grade | 7th grade | 8th grade |  | 6th grade | 7th grade | 8th grade
 | 1 |  |  |  |  |  |  |  |  |  | 0.32 | 0.38 | 0.3
 | 2 | 0 | 0 | 0 |  |  |  |  |  |  | 0.37 | 0.28 | 0.35
 | 3 |  |  |  |  |  |  |  |  |  | 0.3 | 0.32 | 0.38
 | 4 |  |  |  |  |  |  | 0 | 0 | 0 | 0.28 | 0.4 | 0.32
 | 5 |  |  |  | 0 | 0 | 0 |  |  |  | 0.39 | 0.34 | 0.27
 | 6 |  |  |  |  |  |  |  |  |  | 0.34 | 0.28 | 0.38
 | BUSING COST
 | Area | School 1 | School 2 | School 3
 | 1 | 300 | 0 | 700
 | 2 | - | 400 | 500
 | 3 | 600 | 300 | 200
 | 4 | 200 | 500 | -
 | 5 | 0 | - | 400
 | 6 | 500 | 300 | 0 |  |  |  |  |  |  |  |  |  |  | Total per school
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | School 1 | School 2 | School 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | 1100 | 1000
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 17879 | 24612
2 |  |  | 15280 | 24612
3 |  |  | 22363 | 24612
4 |  |  | 22522 | 24612
5 |  |  | 25194 | 24612
6 |  |  | 25342 | 24612
7 |  |  | 26046 | 24612
8 | 11 |  | 24733 | 24612
9 | 22 |  | 26013 | 24612
10 | 1 |  | 25516 | 24612
11 |  |  | 25869 | 24612
12 |  |  | 25308 | 24612
13 |  |  | 25349 | 24612
14 |  |  | 26042 | 24612
15 |  |  | 25954 | 24612
16 |  |  | 26036 | 24612
17 |  |  | 13182 | 24612
18 |  |  | 21303 | 24612
19 |  |  | 20687 | 24612
20 |  |  | 15373 | 24612
21 |  |  | 7932 | 16205
22 |  |  | 25349 | 24612
23 |  |  | 25784 | 24612
24 |  |  | 26042 | 24612
25 |  |  | 26050 | 24612
26 |  |  | 26033 | 24612
27 |  |  | 25939 | 24612
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -178485 | -80532
2001-07-31 00:00:00 | Balance | -1023166 |  | -496043.34
2001-08-27 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | -58339.66 | Zia |  |  | 22864 | -24566
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 | 44144.84 | [NAME] |  |  | 26357 | 26521
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -762222.24 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | 17769
 |  |  |  | Duke
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: FA 08 - Data

[NAME]
Focus Area 08 - Environmental Health - Pennsylvania
Objective Number | Objective Title | Baseline Data | Final Data | HP2010 Goal | Target Progress
08-05 | Persons Receiving Safe Drinking Water from Community Water Systems (percentage) | 99 (1996) | 95 (2009) | 95 | Met or exceeded target
08-06 | Waterborne Disease Outbreaks from Community Water Systems (number of outbreaks) | 0 (1996) | 0 (2009) | 2 | Met or exceeded target
08-27a | State Monitors Lead Poisoning | Yes (2001) | Yes (2009) | Yes | Met or exceeded target
Note: The list of objectives above are limited to those for which Pennsylvania data were available.
Spreadsheet: a5a17504-e604-4ddb-be32-a543ae617bc3
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Wea-Ada | 731383655722 | Various | Our Lady, Mother Of God | 2011-11-08 | Compact Disc | Classical | 14.98 | Y | Available
Wea-Ada | 731383664625 | Various | Songs For The Eucharist Ancient And New | 2013-09-24 | Compact Disc | Classical | 14.98 | Y | Available
Timelife | 610583311426 | Various | 50 Classics For Relaxation | 2011-10-04 | Compact Disc | Classical | 9.98 | Y | Available
Spreadsheet: kimberly_watson__20614__02CapPlan_8_22_01
Sheet: NNG Imb. & Purch.

NORTHERN NATURAL GAS COMPANY
1996 ACTUAL - 2003 PROJECTION
IMBALANCE SETTLEMENTS / GAS PURCHASES
($ Millions)
 |  |  |  |  |  |  |  | 1996 |  | 1997 |  | 1998 |  | 1999 |  | 2000 |  | 2001 |  | 2002 |  | 2003
 |  |  |  |  |  |  |  | Actual |  | Actual |  | Actual |  | Actual |  | Actual |  | CE |  | Est. |  | Est.
Net Cash Flow Impact
 | Imbalance Activity - Cash In |  |  |  |  |  |  | 7.1 |  | 15.5 |  | 22.4 |  | 25 |  | 84 |  | 41 |  | 25 |  | 25
 |  | - Cash Out |  |  |  |  |  | -18.4 |  | -25 |  | -26.1 |  | -20.7 |  | -21.3 |  | -53.2 |  | -20 |  | -20
 |  | Net Imbalance Activity
 | Gas Purchases |  |  |  |  |  |  | -17.1 |  | -14.6 |  | -4.4 |  | -12.4 |  | -67.3 |  | -64.4 |  | -17.5 |  | -17.5
 |  | - Misc. |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Total Gas Purchases
 |  | Net Cash Flow Impact
Note - Gas volumes purchased in one month are paid for in the next month.
 |  | - Carlton |  |  |  |  |  | 0 |  | -2.6 |  | -2.6 |  | -2.6 |  | -2.5 |  | -2.5 |  | -2.5 |  | -2.5
Spreadsheet: 156066d1337170583-using-sumifs-formula-and-or-condition-simultaneously-tracker
Sheet: Summary Data

 |  |  |  | POSTS | VIEWS | APPS | TOTAL REG |  | NEW REG |  | SHORTLISTED |  | INTERVIEWED |  | PLACED
Disc. | Rank | Region | Platform | No. | No. | No. | No. | Ratio | No. | Ratio | No. | Ratio | No. | Ratio | No. | Ratio | ROI
OPS | SEN | UK | RWJ
OPS | MID | UK | RWJ
OPS | JUN | UK | RWJ
Spreadsheet: 594531d1539815668-time-calculations-copy-of-jtakwformula-outgoing
Sheet: Outgoing

Scheduled Departure | Actual Departure | Time Difference
10/10/2018 07:55
10/10/2018 08:15
10/10/2018 10:30
10/09/2018 22:30 | 10/09/2018 22:26
10/10/2018 05:55 | 10/10/2018 06:02
10/10/2018 06:00 | 10/10/2018 05:30
10/10/2018 01:00 | 10/10/2018 01:00
10/10/2018 02:45 | 10/10/2018 02:15
10/10/2018 06:00 | 10/10/2018 06:00
10/10/2018 06:00 | 10/10/2018 05:55
10/10/2018 08:00 | 10/10/2018 06:35
10/09/2018 23:45 | 10/10/2018 00:04
10/10/2018 03:30 | 10/10/2018 03:15
10/09/2018 20:00 | 10/09/2018 19:44
10/10/2018 03:30 | 10/10/2018 03:29
10/10/2018 06:00 | 10/10/2018 05:45
10/10/2018 06:00 | 10/10/2018 05:45
10/10/2018 03:30 | 10/10/2018 03:20
10/10/2018 05:45 | 10/10/2018 05:30
10/10/2018 06:15 | 10/10/2018 06:00
10/10/2018 06:15 | 10/10/2018 06:00
10/09/2018 21:00 | 10/09/2018 20:52
10/10/2018 00:30 | 10/10/2018 00:25
10/10/2018 03:30 | 10/10/2018 03:15
10/09/2018 22:00 | 10/09/2018 21:59
10/10/2018 02:30 | 10/10/2018 02:15
10/10/2018 06:00 | 10/10/2018 05:45
10/10/2018 06:00 | 10/10/2018 05:55
10/10/2018 03:00 | 10/10/2018 03:00
10/10/2018 00:35 | 10/10/2018 00:25
10/10/2018 06:00 | 10/10/2018 06:09
10/09/2018 21:00 | 10/09/2018 20:59
10/09/2018 22:00 | 10/09/2018 22:06
10/10/2018 03:30 | 10/10/2018 03:15
10/10/2018 04:30 | 10/10/2018 04:29
10/10/2018 05:00 | 10/10/2018 04:45
10/10/2018 03:30 | 10/10/2018 03:15
10/09/2018 22:00 | 10/09/2018 22:10
10/09/2018 22:30 | 10/09/2018 22:30
10/10/2018 05:30 | 10/10/2018 05:29
10/10/2018 02:30 | 10/10/2018 02:15
Spreadsheet: 851499d1701721681-pulling-estimated-work-hours-based-on-schedule-forumula-test-file
Sheet: Escalation

 |  |  | Bottom |  |  |  |  |  | Adjust Formulas Per EXP date |  |  |  |  |  |  |  |  | Edit orange cells with desired % as a number
 |  |  | Rate Sheet
 |  |  | ST JM | Current | By Craft | Total | Misc. Directs |  | MH Done by | MH Done By | MH Done By | MH Done By |  | % Done by | HRs % Done By | HRs% Done By | HRS % Done By | 1 Year Later | 2 Years Later | 3 Years Later | Total Craft Labor
 |  |  | Total Cost | Exp Date | Total Hours | Sch Hours | Delta Hours | HRS/MO | Current Exp Date | 1 Year Later | 2 Years Later | 3 Years Later | Labor $ | Current Exp Date | 1 Year Later | 2 Years Later | 3 Years Later | 6 | 12 | 18 | Escalation
 | Elec |  |  | 2023-12-31 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 | LB |  |  | 2023-12-31 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 | CP |  |  | 2023-12-31 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 | CR1 |  |  | 2023-12-31 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 | CR2 |  |  | 2023-12-31 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 | CR3 |  |  | 2023-12-31 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 | CR4 |  |  | 2023-12-31 00:00:00 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 |  | Subtotals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G&A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost w/ G&A
Spreadsheet: 698058d1601715755-second-to-last-non-empty-cell-display_last_non-empty_cell
Sheet: Sheet1

 |  |  |  | Answer
 |  |  |  | display fourth-to-last non empty cell | display third-to-last non empty cell | display second-to-last non empty cell | display last non-empty cell
 |  |  |  |  |  |  |  |  | OP01 | OP02 | OP03 | OP04 |  | OP04 | OP03 | OP01
 |  |  |  | OP04 | OP04 | OP03 | OP01
Spreadsheet: 1de7e35e-bbeb-4e73-aded-2a0f28468f79
Sheet: Sheet1

Table S2. Quantitative trait loci identified in the susceptible sub-population (rpg-TTKSK) of seedlings of the QSM DH mapping population inoculated with [NAME] race TTKSK. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Trait | Chra | Bin | cM | [NAME] | LOD | AEEc | [NAME] | PVE
Infection Frequency for Infection Type 0 | none detected
Infection Frequency for Infection Type 1 | 5 | 27 | 74.91 | 3.55015837743232 | 4.084452908361689 | 0.0745 | Q21861 | 27.26
Infection Frequency for Infection Type 2 | 7 | 1 | 0.01 | 3.43790407954538 | 4.089165003680646 | -0.1592 | Q21861 | 28.23
Infection Frequency for Infection Type 3 | 6 | 30 | 83.63 | 3.511544665017795 | 4.375690799688177 | -0.1521 | Q21861 | 21.9
 | 7 | 7 | 11.18 | 3.511544665017795 | 3.889172386687136 | 0.1364 | SM89010 | 18.93
Principal Component 1 | none detected
Principal Component 2 | 7 | 1 | 0.01 | 3.54118506808652 | 4.350675436520258 | 0.1948 | n.a. | 28.76
Principal Component 3 | 4 | 10 | 37.2 | 3.384863170089269 | 4.070164619330014 | 0.1948 | n.a. | 28.76
Principal Component 4 | 2 | 45 | 124.38 | 3.637399871231681 | 4.84629231928463 | 0.051 | n.a. | 22.41
 | 2 | 60 | 193.54 | 3.637399871231681 | 7.335972396241615 | -0.1063 | n.a. | 45.66
aChromosome
bExperiment-wise threshold determined through CIM that included reselection of background markers for each of 1,000 permuted versions of the phenotype data
cAllelic effect estimate
[NAME] that confers greater resistance
Spreadsheet: 865355d1712392431-trying-to-extract-data-based-on-county-countymonthdaylisting
Sheet: Sheet1

Data Table |  |  |  |  |  | Search Table
Month | Day | Year | County/Counties | Intensity |  | Enter County |  | Grant |  | # of Occurrences |  |  |  | Desired Results
1 | 1 | 1850 | Grant | EF0
2 | 2 | 1851 | Grant, Lafayette | EF1 |  | Occurences | County | Month | Day | Year | County/Counties | Intensity |  |  | Occurences | County | Month | Day | Year | County/Counties | Intensity
3 | 3 | 1852 | Lafayette | EF2 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1850 | Grant | EF0
4 | 4 | 1853 | La Crosse | EF3 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1851 | Grant, Lafayette | EF1
2 | 2 | 1851 | Grant, La Crosse | EF4 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1851 | Grant, La Crosse | EF4
2 | 2 | 1851 | Grant | EF5 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 1851 | Grant | EF5
7 | 7 | 1856 | Lafayette | EF0 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 1900 | Grant | EF3
8 | 8 | 1857 | Lafayette | EF1 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 1903 | Grant | EF0
9 | 9 | 1858 | Monroe | EF2 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 1904 | Grant | EF1
10 | 10 | 1900 | Grant | EF3 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7 | 1905 | Grant, Lafayette | EF2
11 | 11 | 1901 | La Crosse | EF4 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 1925 | Grant, La Crosse | EF5
12 | 12 | 1902 | Lafayette | EF5 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 7 | 1926 | Grant, La Crosse | EF0
5 | 5 | 1903 | Grant | EF0 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 7 | 1926 | Grant, Lafayette | EF1
6 | 6 | 1904 | Grant | EF1 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 11 | 1960 | Grant | EF4
7 | 7 | 1905 | Grant, Lafayette | EF2
4 | 8 | 1906 | Lafayette | EF3
5 | 7 | 1907 | La Crosse | EF4
6 | 6 | 1925 | Grant, La Crosse | EF5
5 | 7 | 1926 | Grant, La Crosse | EF0
5 | 7 | 1926 | Grant, Lafayette | EF1
7 | 9 | 1958 | Lafayette | EF2
8 | 10 | 1959 | Monroe | EF3
9 | 11 | 1960 | Grant | EF4
5 | 12 | 1961 | La Crosse | EF5
Spreadsheet: 866685d1713583873-listing-data-from-one-sheet-to-another-while-liming-number-of-entries-sample
Sheet: snackbar Calendar

W1 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | [NAME] | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | W3 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | W4 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2024-05-05 00:00:00
1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2
W5 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | W6 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | W7 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | W8 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2
Spreadsheet: darrell_schoolcraft__7219__saledoc11_5TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2001-11-26 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 11/27/01 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.39
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
11/27/01 | 11/27/01 | 20000 |  | 20000 |  | 20000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
California Border |  |  |  |  | 20000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 456920d1461124372-how-to-add-up-certain-columns-sum-up
Sheet: Sheet2

 | 1st week |  |  |  |  |  |  |  | 2nd week |  |  |  |  |  |  |  | 3rd week |  |  |  |  |  |  |  | 4th week |  |  |  |  |  |  |  | 5th week
 | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day | DV Plan | DV Actual | farmer visits | FM | MFM | [NAME] | Workshop | Field Day
Total
Spreadsheet: 719667d1613752010-comparing-two-columns-for-duplicates-example
Sheet: Sheet1

Database | Site | Migrated Databases | Migrated?
Alpha | 1 | Alpha
Alpha | 2 | [NAME]
Beta | 1 | Echo
Beta | 2
[NAME] | 1
[NAME] | 2
Delta | 1
Delta | 2
Echo | 1
Echo | 2
Foxtrot | 1
Foxtrot | 2
Spreadsheet: 118051d1313411229-extracting-data-from-multiple-sheets-in-to-one-example-packing-list
Sheet: 1053

 | CLOTHING PACKING LIST
 | I EUROPE LTD
 | CUSTOMER NAME: |  |  | PHIL ROWBOTTOM
 | ADDRESS
 | ORDER NO. |  |  | UCLAW11 - 1053
 | INVOICE NO
 | AGENT NAME |  |  | [NAME]
 | REPEAT CONF. |  |  | 2011-07-15 00:00:00
 | CUST.PO
 | NO. OF CARTON |  |  | 1
 | STYLE | NO | CRTN NO | COLOUR | XS | S | M | L | XL | XXL | TOTAL | BX TOTAL
 | UCLG | RAYS-701 | 13262 | Peacoat | 0 | 4 | 10 | 9 | 6 | 1 | 30 | 30
 | UCLG | RAYS-701 | 13290 | White | 0 | 4 | 10 | 9 | 6 | 1 | 30 | 30
 |  |  |  |  |  |  |  |  |  |  |  | 60
Spreadsheet: 820416d1678101541-date-between-formula-book1
Sheet: Sheet1

Inspected | Next Inspection Due
2022-03-23 00:00:00
2023-02-12 00:00:00
2022-09-26 00:00:00
2023-02-27 00:00:00
2023-02-28 00:00:00
2023-03-01 00:00:00
2022-01-02 00:00:00
2023-03-03 00:00:00
2023-03-04 00:00:00
Spreadsheet: 736156d1623386090-find-nth-largest-vakue-and-return-with-corrsponding-columns-sample
Sheet: Sheet1

UNIVERSITY | Top Commission | Top Comm. EP | SLAB / Remark | Second Top | Second Top EP | SLAB / Remark | A | SLAB / Remark | B | SLAB / Remark | C | SLAB / Remark | D | SLAB / Remark | E | SLAB / Remark | F | SLAB / Remark | G | SLAB / Remark | H | SLAB / Remark
ANNA |  |  | 8+:20 |  |  | 8+:20 | 17 | 8+:20 | 13 | 3+:17.5 | 15 | 8+:20 | 17 | 5+:20 | 17 | 8+:20 | 13 | 3+:17.5 | 15 | 8+:20 | 17 | 5+:20
CLT |  |  | 8+:20 |  |  | 8+:20 | 13 | 8+:20 | 14 | 8+:20 | 15 | 8+:20 | 8 | 5+:20 | 13 | 8+:20 | 14 | 8+:20 | 15 | 8+:20 | 8 | 5+:20
UK |  |  | 8+:20 |  |  | 8+:20 | 15 | 3+:17.5 | 16 | 8+:20 | 15 | 10+: 20 | 14 | 10+: 20 | 15 | 3+:17.5 | 16 | 8+:20 | 15 | 10+: 20 | 14 | 10+: 20