tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 540633d1506835356-complicated-multiple-nested-if-statements-tennis-bvj-
Sheet: Pivot Table 1

Tagged Player | Tournament | Year | Opponent Player |  | 2017
[NAME] | US Open | 2017 | [NAME] |  | 2015
 |  | 2015 | [NAME] |  | 2016
 |  | 2016 | [NAME] |  | 2014
 |  | 2014 | [NAME] |  | all
[NAME] | US Open | 2017 | [NAME]
 |  | 2015 | [NAME]
 |  | 2016 | [NAME]
 |  | 2014 | [NAME]
[NAME] | US Open | 2017 | [NAME]
 |  | 2015 | [NAME]
 |  | 2016 | [NAME]
 |  | 2014 | [NAME]
Green | British Open | 2017 | Schroder
 |  | 2015 | Schroder
 |  | 2016 | Schroder
 |  | 2014 | Schroder
(blank) | (blank) | (blank) | (blank)
all | all | all | all
Spreadsheet: 164017d1340614474-excel-2007-vlookup-combined-with-concatenation-example-source-and-desired-output
Sheet: Source1

 | 6CAN | Cannington | CANN | 6CAN | 27035 | 5 | 57840 | South Perth (C)
 | 6CAN | Cannington | CANN | 6CAN | 27035 | 5 | 50490 | Belmont (C)
 | 6CAN | Cannington | CANN | 6CAN | 27035 | 5 | 51330 | Canning (C)
 | 6CAN | Cannington | CANN | 6CAN | 27035 | 5 | 53780 | Gosnells (C)
 | 6CAN | Cannington | CANN | 6CAN | 27035 | 5 | 58510 | [NAME] (T)
 | 6CAN | Cannington | CANN | 6CAN | 27035 | 5 | 54200 | Kalamunda (S)
Spreadsheet: 680957d1591277857-if-formula-for-number-range-text-cashshare
Sheet: Sheet1

 | CASH Report
 | Client |  | MTD |  | QTD |  | YTD |  | CASH
 | HCA |  | 0.75 |  | 0.96 |  | 0.59 |  | 123456789
 | ICS |  | 0.45 |  | 0.99 |  | 0.36 |  | 1234567890
 | OSG |  | 1 |  | 1.03 |  | 1.08 |  | 123456789
 | Total HCA/ICS/OSG: |  | 0.89 |  | 0.87 |  | 1.06 |  | 750000000
Spreadsheet: 67717d1268265686-data-validation-list-that-depends-on-partially-matched-data-book1
Sheet: Sheet1

 |  |  |  | Lisbon
 |  |  |  | Oporto
 |  |  |  | Coimbra
City | Zip |  | Coimbra |  | Lisbon | Oporto | Coimbra
Coimbra | 9740 | 2 | 9900 |  | 1500 | 2200 | 9900
 |  | 3 | 9970 |  | 1600 | 2300 | 9970
 |  | 4 | 9740 |  | 1700 | 2500 | 9740
 |  | 5 | 9350 |  |  | 2800 | 9350
 |  | 6 | 9980 |  |  |  | 9980
Spreadsheet: 851777d1701908359-pulling-estimated-work-hours-based-on-schedule-forumula-test-file-sregez80-
Sheet: Escalation

 |  |  |  |  |  |  |  |  | 2023-12-01 00:00:00
 |  |  |  |  |  |  |  |  | 2024-12-01 00:00:00
 |  |  | 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
 | LB |  |  | 2023-12-31 00:00:00 |  |  |  |  |  | 0 | 0 | 0 |  | 0
 | CP |  |  | 2023-12-31 00:00:00 |  |  |  |  |  | 0 | 0 | 0 |  | 0
 | CR1 |  |  | 2023-12-31 00:00:00 |  |  |  |  |  | 0 | 0 | 0 |  | 0
 | CR2 |  |  | 2023-12-31 00:00:00 |  |  |  |  |  | 0 | 0 | 0 |  | 0
 | CR3 |  |  | 2023-12-31 00:00:00 |  |  |  |  |  | 0 | 0 | 0 |  | 0
 | CR4 |  |  | 2023-12-31 00:00:00 |  |  |  |  |  | 0 | 0 | 0 |  | 0
 |  | Subtotals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G&A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost w/ G&A
Spreadsheet: 0fd29b2a-6068-46f3-8ccf-36479af3a9e1
Sheet: Sheet1

Suggested Timeline for Regularly Scheduled Series (RSS) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Task | Chronological Timeline | Task Assignee | Due Date | Date Completed
Identify Professional Practice Gaps | 6-9 Months | Course Director
Identify Intended Program Outcomes | 6-9 Months | Course Director
Identify Target Audience | 6-9 Months | Course Director
Contact CME Department to request CME sponsorship | 6-9 Months | Course Director
Select Planning Committee | 6-9 Months | Course Director
Review "What You Need to Know" Planning Document & CME Application | 6-9 Months | Course Director
Select Date | 6-9 Months | Course Director/Committee
Select Location | 6-9 Months | Course Director/Committee
Submit Completed Application to CME Department | 6-9 Months | Course Director
Select Specific Topics and Identifiy Gaps and Desired Outcomes | 6 Months | Course Director/Committee
Apply for Pharmaceutical Grants | 6 Months | CME
Invite Speakers | 3-6 Months | Course Director
Send Speaker Packets | 3-6 Months | Course Director/Support Staff
Create Draft Budget | 3-6 Months | Course Director
Review Speaker COI Forms/Submit to CME | 3-6 Months | Course Director/CME
[NAME] and send to CME for approval | 1-2 Months | Support Staff
Distribute [NAME] | 1-2 Months | Support Staff
[NAME] | 2 Weeks | Support Staff
Confirm AV/Catering/Room Setup | 1-2 Weeks | Support Staff
Create & Print Sign-In Roster | 1-2 Weeks | Support Staff
Create & Print Evaluation | 1-2 Weeks | Support Staff
Post Conference Documents to CME | 1-2 Weeks Post | Support Staff
Send Certificates | 1-2 Weeks Post | CME
Evaluation Summary | 1-2 Weeks Post | CME
Final Budget to CME | 1-2 Weeks Post | Support Staff
Outcome Measurement Survey | 3 Months Post | CME
Spreadsheet: 793640d1661600706-add-an-increase-limit-to-a-formula-midshires-master
Sheet:  Master

 |  | HOLE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 | Total |  |  | Stroke Index |  |  |  |  |  |  |  | HANDICAPPING ALTERATIONS
1 | PLAYER | PAR |  | 4 |  | 4 |  | 4 |  | 3 |  | 4 |  | 4 |  | 4 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  | PAR | PTS | Playing H'Cap |  |  |  | HANDICAP | NEW |  |  | 36 | Winners | Other |  | H'cap |  | catagory
1 |  | S/I |  | 17 |  | 5 |  | 9 |  | 15 |  | 3 |  | 1 |  | 7 |  | 13 |  | 11 |  | 8 |  | 12 |  | 16 |  | 2 |  | 10 |  | 4 |  | 18 |  | 14 |  | 6 | GROSS | 3 |  | S/I 1 | S/I 2 | S/I 3 | POST | CHANGE | HANDICAP |  |  |  | Cuts | Cuts | Increase | Change
1 | ADAMS (Brian)
1 | ADAMS ([NAME])
0 | BATTERBEE ([NAME])
0 | BAXTER (Nick)
1 | BENNETT ([NAME])
1 | BROMLEY ([NAME])
1 | CURT ([NAME])
1 | CURT (Sean)
0 | DERBYSHIRE ([NAME])
0 | DONNELLY ([NAME])
1 | DOWNER ([NAME])
0 | [NAME] ([NAME])
0 | GELLMAN ([NAME])
1 | GIBOIN ([NAME])
1 | GROUT ([NAME])
0 | [NAME] (Stuart)
1 | [NAME])
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
1 | [NAME] ([NAME])
1 | KOLEK ([NAME])
1 | KOLEK ([NAME])
1 | LEECH ([NAME])
1 | LEECH ([NAME])
0 | LEONARD ([NAME])
0 | LEONARD ([NAME])
1 | [NAME] ([NAME])
1 | LOOM (Scott)
1 | MARVESLEY ([NAME])
1 | MCGILLIVRAY ([NAME])
0 | MCINTYRE ([NAME])
0 | MCKENZIE ([NAME])
0 | MEMOLI ([NAME])
1 | MITCHELL ([NAME])
1 | MOSS ([NAME])
1 | MUNTING ([NAME])
0 | NOONS (Martin)
1 | [NAME] ([NAME])
0 | [NAME] ([NAME])
1 | PYM ([NAME])
1 | SMITH ([NAME])
1 | SMITH ([NAME])
0 | TAYLOR ([NAME])
0 | VANN (Martin)
0 | ANDREWS ([NAME])
0 | ATKINS (Allen)
0 | BURNETT ([NAME])
0 | CLARKE ([NAME])
0 | CRONIN ([NAME])
0 | [NAME] ([NAME])
0 | FAWCETT ([NAME])
0 | HAMMOND ([NAME])
0 | KING ([NAME])
0 | [NAME] (Trevor)
0 | MCDONALD ([NAME])
0 | PRESTON ([NAME])
0 | SPENCER ([NAME])
0 | THORPE ([NAME])
0 | VALENTINE ([NAME])
0 | WARREN (Derek)
0 | WEEKS ([NAME])
1 | WILLS (Stuart)
0 | WOODFORD ([NAME])
 | Number of Players
 | SKINS
 | 1
 |  | HOLE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 | Total |  |  |  |  |  |  |  |  |  |  | Total Cuts
 |  | PAR |  | 4 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  | 4 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 5 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4
 |  | S/I |  | 16 |  | 4 |  | 18 |  | 14 |  | 10 |  | 8 |  | 2 |  | 12 |  | 6 |  | 7 |  | 15 |  | 13 |  | 5 |  | 9 |  | 1 |  | 17 |  | 11 |  | 3 | GROSS
 | Average Score
 | PARS
 | BIRDIES
 | Total Score
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -93082 | -90000
2 | -73789 | -56575
3 | -67333 | -74975
4 | -76511 | -80000
5 | -79371 | -70000
6 | -82768 | -79999
7 | -78642 | -69936
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-09-30 00:00:00 |  |  | -37850
2001-10-07 00:00:00
CBS Volume
 |  |  | -13974
Spreadsheet: 109174d1306118608-multi-sheet-referencing-for-formulas-example
Sheet: Sheet1

SHEET 1 "AK" | SHEET 1 "AN" | SHEET 1 "AO"
1000000 | 1500000 | 0.3333333333333333
1000000 | 2000000 | 0.5
1000000 | 875000 | -0.1428571428571428
110000 | 90000 | 0
220000 | 175000 | 0
300000 | 285000 | 0
3630000 | 4925000
605000 | 820833.3333333334 | 0.1150793650793651
Spreadsheet: 848520d1699258388-trying-to-get-excel-to-extract-text-from-other-cells-and-list-them-vertically-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This formula is what I want but I want it to display the text found in the week.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Found
 | ` BILL & DEBT PAYMENTS CALENDAR ` |  |  | S - Phone |  |  |  |  |  | S - Debt |  | S - Power |  |  |  |  |  |  | Not Found
 |  |  |  |  |  |  |  |  |  |  |  | S - School |  |  |  |  |  |  | Not Found
 | TODAY'S DATE
 | MONTH | YEAR
 | November | 2023
 | START DAY
 | Monday
Spreadsheet: 2a57b445-10db-4aec-94a9-f3dbdffeaf54
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Contract #62090340 for Project #62100352 - Runway 1/19 Safety Area Construction - Phase 2
 | Amendment No. 3
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  |  |  |  | FY
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: |  |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  |  |  |  | FY
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: |  |  |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 153610d1335973201-average-sales-using-changing-cell-for-iso-week-test_sales
Sheet: Sheet1

 |  | Quantity | Sales | ISO Week Number | Day of the week
 |  |  |  | CURRENT WEEK: | 3
 |  |  | Sales | Qty | Average
 |  | Monday | 145000 | 0
 |  | Tuesday | 3497 | 4450 | 0.7858426966292135
 |  | Wednesday | 6000 | 5800 | 1.03448275862069
 |  | Thursday | 0 | 0
 |  | Friday | 0 | 0
 |  | Totals | 154497 | 0
 |  | Weekly Average as of week |  |  | 2
 |  | [NAME] |  | Avg Wkly Qty
 |  | 73906
 |  | Total Sls | 221721 | Total Qty | #N/A
Spreadsheet: 104746d1302208412-help-with-define-name-and-auto-updating-graphs-names
Sheet: 4A

Month | Count
2009-02-01 00:00:00
2009-03-01 00:00:00 | 1
2009-04-01 00:00:00
2009-05-01 00:00:00 | 2
2009-06-01 00:00:00 | 1
2009-07-01 00:00:00
2009-08-01 00:00:00
2009-09-01 00:00:00 | 1
2009-10-01 00:00:00 | 1
2009-11-01 00:00:00 | 2
2009-12-01 00:00:00
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00 | 1
2010-05-01 00:00:00 | 2
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00 | 1
2010-10-01 00:00:00 | 1
2010-11-01 00:00:00
2010-12-01 00:00:00
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
Spreadsheet: 491002d1480251580-how-can-i-get-country-name-based-on-city-names-in-the-columns-country-name-based-on-city
Sheet: Sheet1

City1 | City2 | City3 | City4 | City5 | Formula for Country Name | [NAME] for country names if Multi cities in the columns |  | City | Country
New York |  |  |  |  |  |  |  | Bejing | China
 |  |  | Mumbai |  |  |  |  | Berlin | Germany
 | Toronto |  |  |  |  |  |  | Dublin | Ireland
Karachi |  |  |  |  |  |  |  | Karachi | Pakistan
 |  |  |  | London |  |  |  | London | England
 |  | Sidney |  |  |  |  |  | Los Angeles | USA
 | Walington |  |  |  |  |  |  | Mumbai | India
Los Angeles |  |  |  |  |  |  |  | New York | USA
 |  |  |  |  |  |  |  | Sidney | Australia
London | Tokyo | Washington |  | Berlin |  |  |  | Tokyo | Japan
Bejing |  |  | Dublin |  |  |  |  | Toronto | Canada
 |  |  |  |  |  |  |  | Walington | New Zealand
 |  |  |  |  |  |  |  | Washington | USA
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 10. HIV

 |  | HIV test results |  |  |  |  | HIV test results | 0
 |  |  |  |  |  |  | Please indicate HIV-1 subtypes prevalent in your donor population:
 |  | Please indicate the 3 most prevalent HIV-1 subtypes in your donor population: |  |  |  |  | A, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | B, percentage (if data available) | 0 | 0
 |  | A, percentage (if data available) |  |  |  |  | C, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | D, percentage (if data available) | 0 | 0
 |  | B, percentage (if data available) |  |  |  |  | E, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | F, percentage (if data available) | 0 | 0
 |  | C, percentage (if data available) |  |  |  |  | G, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | H, percentage (if data available) | 0 | 0
 |  | D, percentage (if data available) |  |  |  |  | J, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | K, percentage (if data available) | 0 | 0
 |  | E, percentage (if data available) |  |  |  |  | CRF (circulating recombinant forms), please specify and indicate percentage | 0 | 0
 |  |  |  |  |  |  | O, percentage (if data available) | 0 | 0
 |  | F, percentage (if data available) |  |  |  |  | N, percentage (if data available) | 0 | 0
 |  | G, percentage (if data available) |  |  |  |  | Please indicate HIV-2 prevalence in your donor population | 0
 |  | H, percentage (if data available)
 |  | J, percentage (if data available)
 |  | K, percentage (if data available)
 |  | CRF (circulating recombinant forms), please specify and indicate percentage
 |  | (if data available)
 |  | O, percentage (if data available)
 |  | N, percentage (if data available)
 |  | Please indicate HIV-2 prevalence in your donor population
 |  |  |  | Page 13 of 34
Spreadsheet: c671b714-d362-4e5b-a8b3-e4f6a657e58d
Sheet: Table 5.1

Monthly Statistical Bulletin
5.1 Business interest rates
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Large business interest rate (a) (b) – per cent
September | 5.45 | 6.4 | 6.45 | 5.65 | 4.75
December | 6 | 6.65 | 6.25 | 5.3
March | 6.2 | 6.600000000000001 | 6.2 | 5.15
June | 6.4 | 6.550000000000001 | 5.7 | 4.95
Annual average | 6.012499999999999 | 6.550000000000001 | 6.149999999999999 | 5.2625
Small business interest rate (a) (c) – per cent
September | 7.100000000000001 | 8.25 | 8.5 | 7.7 | 6.800000000000001
December | 7.7 | 8.6 | 8.15 | 7.2
March | 8.05 | 8.55 | 8.2 | 7.15
June | 8.25 | 8.55 | 7.75 | 7.050000000000001
Annual average | 7.775 | 8.4875 | 8.149999999999999 | 7.275
(a) The data are weighted average rates, which are calculated from outstanding credit
facilities held by businesses at different interest rates with different maturities.
(b) A large business loan is defined as being $2 million or more.
(c) A small business loan is defined as being less than $2 million.
Source: RBA website statistical table F5 | http://www.rba.gov.au/PublicationsAndResearch/Bulletin/2008/index.html
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-04-02 00:00:00
Spreadsheet: 882833d1731318033-transpose-data-into-multiple-columns-based-on-numbers-book-2-1-
Sheet: Sheet1

Column1 | Column2 |  | 1 | 2 | 3 | 4
1 | MEMBER ID: 1234 |  | MEMBER ID: 1234 | Organization Name: ABC Corp | Mobile Number: [PHONE] | Representative Name: [NAME]
1 | Organization Name: ABC Corp |  | MEMBER ID: 5678 | Organization Name: XYZ Ltd | Mobile Number: [PHONE] | Representative Name: [NAME]
1 | Mobile Number: [PHONE] |  | MEMBER ID: 59862 | Organization Name: HGTLtd | Mobile Number: 1258932
1 | Representative Name: [NAME] |  | MEMBER ID: 1258 | Organization Name: LGB Corp
2 | MEMBER ID: 5678
2 | Organization Name: XYZ Ltd
2 | Mobile Number: [PHONE]
2 | Representative Name: [NAME]
3 | MEMBER ID: 59862
3 | Organization Name: HGTLtd
3 | Mobile Number: 1258932
4 | MEMBER ID: 1258
4 | Organization Name: LGB Corp
Spreadsheet: 231269d1366990967-populating-an-excel-purchase-order-master-po
Sheet: PINK

 | RECEIVING REPORT
 | CARRIER: |  |  |  | PRO. NO.: |  | WEIGHT |  | P.P.D. | COLL. | CHARGES
 | ITEMS SHOWN AS ON ORDER ENTERED BY: |  | DATE ENTERED:                          D    M    Y |  | ITEMS SHOWN AS RECEIVED ENTERED BY: |  | DATE ENTERED:                          D    M    Y |  | REC'D WITH OTHER P.P. NO.s: |  |  | FREIGHT ESTIMATED AT:
 |  |  |  |  |  |  |  |  |  | Date:
 | TO: |  |  |  |  |  |  |  | SHIP TO:
 |  | Ph. |  |  | Fax
 |  | Contact. |  |  | [NAME] | mailto:[EMAIL]
 | SHIP VIA: |  |  |  | P.P.D | COLL. | SHIPPING DATE |  | TERMS:
 | ITEM | ORDER | QTY | BACK | SUPPLIER |  | SUPPLY THE FOLLOWING SUBJECT TO CONDITIONS BELOW |  |  |  |  | UNIT | TOTAL
 |  | QTY | REC | ORDER |  |  |  |  |  |  |  | PRICE
 |  | Charged to |  |  |  |  | INVOICE #                D.M.#-W.O.# |  | AMOUNT CHARGED
 |  |  |  |  |  |  |  |  |  |  | NEW ORDER
 |  |  |  |  |  |  |  |  |  |  | AQUA-TECH POOLS LTD.
 | GST# R100241819
 |  | CANCEL ALL BACKORDERS IF BOX CHECKED
 |  | DAMAGED   GOODS   CLAIMED   TO |  |  |  |  | DATE |  |  | WHITE | CANARY | PINK
 |  | REC'D BY |  |  |  |  | DATE |  |  | SUPPLIER | RECEIVING | BACK ORDER
Spreadsheet: 808950d2-c141-46c3-abb0-6bca38856cb7
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
SALC | Test | SALC | Salicylate, Serum | Salicylate, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top  [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Adult therapeutic concentration: 2-20 mg/dL Toxic concentration: > or =50 mg/dL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80196 |  |  |  |  | Rochester
SALC | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
SALC | Result | 8480 | Salicylate, S | Salicylate, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 4024-6 | Salicylates:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 726260d1617130328-simulate-outcomes-of-combinations-with-probability-of-rank-among-other-competitors-sample-file
Sheet: Blad1

Match 1 | Match 2 | Match 3 | Match 4 | Match 5 | Match 6 | Match 7 |  | Player | Points | Rank
0 | 0 | 0 | 0 | 0 | 0 | 1 |  | [NAME] | 25 | 1
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | [NAME] | 20 | 2
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | [NAME] | 0 | 5
0 | 1 | 0 | 0 | 0 | 0 | 0 |  | [NAME] | 15 | 3
0 | 0 | 0 | 0 | 1 | 0 | 0 |  | [NAME] | 5 | 4
0 | 0 | 0 | 0 | 0 | 0
1 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 1
0 | 0 | 1 | 1 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
Spreadsheet: 939c15a8-5fb1-44d3-bb88-362431d789e5
Sheet: Sheet1

Table S4. Non-uniform distribution of transcription factor binding sites relative to the ERE in ChIP-PET clusters. | Unnamed: 1
MatrixID | KS p-value
V$ER_Q6 | 0
V$CDX_Q5 | 6.83e-08
V$SF1_Q6 | 1.24e-06
V$MAF_Q6_01 | 8.99e-05
V$PAX3_B | 0.000109
V$XPF1_Q6 | 0.000226
V$HEB_Q6 | 0.000382
V$AP1_Q4_01 | 0.000856
V$HNF1_Q6 | 0.00199
V$PAX4_04 | 0.00313
[NAME] | 0.0033
V$MRF2_01 | 0.00357
V$CEBP_01 | 0.00417
V$CHCH_01 | 0.00564
V$PAX4_02 | 0.00579
V$NKX3A_01 | 0.0084
V$HNF3_Q6_01 | 0.00931
V$TST1_01 | 0.0097
V$COUPTF_Q6 | 0.00996
[NAME] | 0.0109
V$ZTA_Q2 | 0.011
[NAME] | 0.0135
V$MAZ_Q6 | 0.0161
[NAME] | 0.0183
V$FAC1_01 | 0.0257
V$TATA_01 | 0.0277
V$MSX1_01 | 0.0304
V$SP1_01 | 0.0318
V$NFE2_01 | 0.0322
V$HNF4_DR1_Q3 | 0.0332
V$CIZ_01 | 0.0374
V$MYC_Q2 | 0.0384
V$RFX1_02 | 0.0408
V$TBP_Q6 | 0.045
V$GC_01 | 0.0455
V$POU1F1_Q6 | 0.0459
V$GATA4_Q3 | 0.0481
Spreadsheet: 329177d1404222144-two-part-restrict-cell-for-mac-ip-address-entry-potential-for-multiple-ip_mac
Sheet: Sheet3

GIVEN TO STUDENT
[NAME] | MAC ADDRESS | IP ADDRESS
1
2
3
4
5
ANSWER EXPECTED
[NAME] | MAC ADDRESS | IP ADDRESS
1 | AA:B1:22:2C:DD:1C | 192.168.1.1
2 | A0:11:A5:DD:55:6E CC:DD:11:AA:BB:22 | 192.168.1.2 10.0.0.1
3 | 00:11:AA:DD:55:66 00:11:AA:DD:55:66 CC:DD:11:AA:BB:22 | 192.168.10.2 192.168.1.2 10.0.0.1
4 | 11:BB:22:CC:DD:FF | 192.168.1.11
5 | CD:BB:22:C4:DD:2F | 192.168.1.16
Spreadsheet: 49470d1248820009-auto-populating-columns-in-one-sheet-from-another-based-on-criteria-example
Sheet: Sheet1

2009-06-28 00:00:00
Sunrise | Sunset | Moonrise | Moonset | Illum.
559 | 2001 | 637 | 2039 | 0
Grounded: | Leave: | TAD: | No Fly: | Off: | Flying: | Available:
#N/A | [NAME] | XO |  |  | CO | [NAME]
 |  | OPS |  |  | Dill | Jones
 |  | [NAME] |  |  | [NAME] | Pototschnik
 |  | Souders |  |  | Decker | Cooper
 |  |  |  |  | Ziegler | [NAME]
Spreadsheet: 797349d1663839552-how-to-incorporate-an-or-into-my-sumifs-coupon-schedule
Sheet: Sheet1

Security | PMT | Date | Schedule | Frequency
Bond 1 | 500 | 2026-01-01 00:00:00 | Maturity | 2
Bond 1 | 500 | 2023-01-01 00:00:00 | Coupon 1 | 2
Bond 1 | 500 |  | Coupon 2 | 2
Bond 1 | 500 |  | Coupon 3 | 2
Bond 1 | 500 |  | Coupon 4 | 2
Bond 1 | 500 |  | Coupon 5 | 2
Bond 1 | 500 |  | Coupon 6 | 2
Bond 2 | 1000 | 2025-09-30 00:00:00 | Maturity | 2
Bond 2 | 1000 | 2022-09-30 00:00:00 | Coupon 1 | 2
Bond 2 | 1000 |  | Coupon 2 | 2
Bond 2 | 1000 |  | Coupon 3 | 2
Bond 2 | 1000 |  | Coupon 4 | 2
Bond 2 | 1000 |  | Coupon 5 | 2
Bond 2 | 1000 |  | Coupon 6 | 2