tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0513ba60-0c33-4405-885b-e080dc522cb3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | WEST ROSEVILLE | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Property Crime Summary
 |  |  |  |  | April 2009
[NAME] |  |  | INCIDENT |  | TARGET |  |  | DATE/TIME
[NAME]. |  |  | 459 PC |  | Rear window of veh. parked |  |  | 2009-04-16 00:00:00 | 2009-04-18 00:00:00
 |  |  |  |  | along roadway broken. Personal |  |  |  | 12:00:00
 |  |  |  |  | item removed.
9300 Blk Viking Pl. |  |  | 459 / 594 PC |  | Dry Creek Elem. School District |  |  | 2009-04-19 00:00:00 | 2009-04-20 00:00:00
 |  |  |  |  | warehouse vandalized - extensive |  |  | 14:30:00 | 04:00:00
 |  |  |  |  | damage.
9300 Blk Watt Ave. |  |  | 594 PC |  | BB gun used to break windows in |  |  | 2009-04-21 00:00:00 | 2009-04-23 00:00:00
 |  |  |  |  | two veh's. parked on property. |  |  | 13:00:00 | 08:00:00
9100 Blk Billy Mitchell Bl. |  |  | 459 PC |  | Door to res. forced open. Theft |  |  | 2009-04-30 00:00:00 | 2009-04-30 00:00:00
 |  |  |  |  | occurred. |  |  | 08:30:00 | 14:14:00
Note: Crime Stoppers is offering a reward for information leading to the arrest of the suspects from the vandalism at Dry Creek Elem. School
District warehouse. Crime Stoppers,  [PHONE].
V = Victim
S(s) = Suspect(s)
594 PC = Vandalism
664/459 PC = Attempt Burglary
459 PC = Burglary
487 PC = Grand Theft
488 PC = Petty Theft
As a reminder, please remove any valuables from your vehicle(s) and secure it. If you have an alarm system for your car
or home, please utilize it.
Thank You
Spreadsheet: 86251d1286280076-vba-comparison-of-two-worksheets-cars
Sheet: Original DB

Car Type | Car Model | Imported to country | Imported Date
Volkswagen | [NAME] | US | 2001-01-01 00:00:00
Volkswagen | [NAME] | China | 2002-02-02 00:00:00
Volkswagen | [NAME] | Japan | 2003-03-03 00:00:00
Citroen | C5 | France | 2004-04-04 00:00:00
Citroen | C5 | UK | 2005-05-05 00:00:00
Spreadsheet: 850833d1701178583-power-query-shift-by-1-quarter-shift-in-column
Sheet: MEPS

Year | Quarter | Average/Q1
2020 | Q4 | 660
2021 | Q1 | 812.5 |  | 660
2021 | Q1 | 812.5 |  | 660
2021 | Q1 | 812.5
2021 | Q2 | 1155
2021 | Q2 | 1155
2021 | Q2 | 1155
2021 | Q3 | 1298.3333
2021 | Q3 | 1298.3333
2021 | Q3 | 1298.3333
2021 | Q4 | 1175
2021 | Q4 | 1175
2021 | Q4 | 1175
2022 | Q1 | 1146.6667
2022 | Q1 | 1146.6667
2022 | Q1 | 1146.6667
2022 | Q2 | 1280
2022 | Q2 | 1280
2022 | Q2 | 1280
2022 | Q3 | 925
2022 | Q3 | 925
2022 | Q3 | 925
2022 | Q4 | 780
2022 | Q4 | 780
2022 | Q4 | 780
2023 | Q1 | 865
2023 | Q1 | 865
2023 | Q1 | 865
2023 | Q2 | 890
2023 | Q2 | 890
2023 | Q2 | 890
2023 | Q3 | 761.6667
2023 | Q3 | 761.6667
2023 | Q3 | 761.6667
2023 | Q4 | 720
2023 | Q4 | 720
Spreadsheet: 130266d1322146202-pivot-grand-total-sandeep
Sheet: Sheet1

Original data
Year | Spend
2010 | 25
2010 | 26
2010 | 27 |  |  |  |  |  | Column Labels
2011 | 28 |  |  |  |  |  | 2011 | 2010 | Grand Total
2011 | 29 |  |  |  |  | Sum of Spend | 87 | 78 | 165 | Change 165 to a difference between 2011 and 2010.
2011 | 30
My solution
Year | Spend | 2010 | 2011 |  |  | Sum of 2011 | Sum of 2010 | Difference
2010 | 25 |  |  |  |  | 87 | 78 | 9 | Calculated field to get the difference
2010 | 26
2010 | 27
2011 | 28
2011 | 29
2011 | 30
 |  | Difference
Spreadsheet: 2089f04e-d86a-42dd-9b09-34a10b8e3d6b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-07-12 09:30:21.510000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.84 | 101.715 | 101.59 | 101.215
3.75 | 101.46 | 101.335 | 101.21 | 100.835 |  | Note: | Refer To Price [NAME]
3.625 | 100.979 | 100.854 | 100.729 | 100.354 |  |  | For all Price Adjs
3.5 | 100.416 | 100.291 | 100.166 | 99.541
3.375 | 99.568 | 99.443 | 99.318 | 98.693
3.25 | 98.644 | 98.519 | 98.394 | 97.769
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.047 | 101.922 | 101.797 | 101.422
3.25 | 101.475 | 101.35 | 101.225 | 100.85
3.125 | 101.182 | 101.057 | 100.932 | 100.557
3 | 100.831 | 100.706 | 100.581 | 100.206
2.875 | 100.24 | 100.115 | 99.99 | 99.365
2.75 | 99.582 | 99.457 | 99.332 | 98.707
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-07-26 09:30:21.510000
30 DAY | 2012-08-10 09:30:21.510000
45 DAY | 2012-08-25 09:30:21.510000
60 DAY | 2012-09-09 09:30:21.510000
90 DAY | 2012-10-09 09:30:21.510000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 0dece6ba-9cbb-4708-b791-ffc172b18493
Sheet: August

 | SUNDAY
 |  | 2014-07-28 00:00:00 | 2014-07-29 00:00:00 | 2014-07-30 00:00:00 | 2014-07-31 00:00:00 | 2014-08-01 00:00:00 | 2014-08-02 00:00:00
 |  | 2014-08-04 00:00:00 | 2014-08-05 00:00:00 | 2014-08-06 00:00:00 | 2014-08-07 00:00:00 | 2014-08-08 00:00:00 | 2014-08-09 00:00:00
 |  | 2014-08-11 00:00:00 | 2014-08-12 00:00:00 | 2014-08-13 00:00:00 | 2014-08-14 00:00:00 | 2014-08-15 00:00:00 | 2014-08-16 00:00:00
 |  | 2014-08-18 00:00:00 | 2014-08-19 00:00:00 | 2014-08-20 00:00:00 | 2014-08-21 00:00:00 | 2014-08-22 00:00:00 | 2014-08-23 00:00:00
 |  | 2014-08-25 00:00:00 | 2014-08-26 00:00:00 | 2014-08-27 00:00:00 | 2014-08-28 00:00:00 | 2014-08-29 00:00:00 | 2014-08-30 00:00:00
 |  | Campus files to CO by noon | Delete Deadline 5pm | ACH File to Treasury |  | Pay Day
 |  | 2014-09-01 00:00:00 | NOTES
Spreadsheet: 454367d1459811337-im-in-the-bermuda-triangle-of-recalculation-therapy-chicken-spreadsheet
Sheet: Sheet1

 |  | [NAME]
 |  | Time | Group Size by Day
 |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 8:00-9:00 | 5
 |  | 9:00-10:00
 |  | 10:00 -11:00
 |  | 11:00-12:00 |  |  |  | 10
 |  | 12:00-1:00 |  |  | 6
 |  | 1:00-2:00 | 5 |  |  |  | 5 | 3
 |  | 2:00-3:00
 |  | 3:00-4:00 | 4
 |  | 4:00-5:00
 |  | Time | Gross Revenue  by Day
 |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 8:00-9:00
 |  | 9:00-10:00
 |  | 10:00 -11:00
 |  | 11:00-12:00
 |  | 12:00-1:00
 |  | 1:00-2:00
 |  | 2:00-3:00
 |  | 3:00-4:00
 |  | 4:00-5:00
 |  | Total
 |  | Weekly Total Gross Revenue
 |  | Compensation Scale
 |  | Participants |  |  |  |  | Hourly Cost per Participant
 |  | 1 | to | 2 | pay |  | 10 | per hour
 |  |  | + |  | pay |  | 5 | per hour
Spreadsheet: 766440d1643896208-lookup-and-return-items-in-column-array-based-on-date-lookup-and-return-in-a-column-aligw
Sheet: Netting calculation

 |  | 2021-03-01 00:00:00 |  |  |  |  | 2021-04-01 00:00:00 |  |  |  |  | 2021-05-01 00:00:00
 |  |  | Client | Net Amount |  |  |  | Client | Net Amount |  |  |  | Client | Net Amount
 |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | Felix
 |  |  | Kurt |  |  |  |  | [NAME] |  |  |  |  | [NAME]
Spreadsheet: c4861341-f142-477a-9edb-8df60640ed4f
Sheet: Sheet1

Infant Mortality, Maine, by [NAME], 2005-2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | Average number of deaths per year | Average number of births per year | Infant mortality rate* | 95% CI
Total |  | 85 | 13888.8 | 6.1 | 5.4 - 6.6
Infant sex
 | Female | 38 | 6757.2 | 5.6 | 4.6 - 6.2
 | Male | 46 | 7131.2 | 6.5 | 5.7 - 7.4
Infant Mortality, Maine, by Selected Maternal Demographics, 2000-2009
 |  | Average number of deaths per year | Average number of births per year | Infant mortality rate* | 95% CI
Maternal Race
 | American Indian | 0 | 112.7 | 1.8 | 0.2 - 6.4
 | Asian/Pacific Islander | 1 | 219.9 | 5 | 2.5 - 9.0
 | Black or African American | 2.7 | 250.2 | 10.79136690647482 | 7.1 - 15.7
 | White | 72 | 13186.7 | 5.5 | 5.1 - 5.9
Maternal Ethnicity
 | Hispanic | 1 | 185.4 | 5.9 | 3.0 - 10.6
 | Not Hispanic | 75 | 13605.8 | 5.5 | 5.1 - 5.9
County (Maternal Residence)
 | Androscoggin | 8 | 1324.3 | 6.3 | 5.0 - 7.8
 | Aroostook | 4 | 704.5 | 5.4 | 3.8 - 7.4
 | Cumberland | 17 | 2983.6 | 5.5 | 4.7 - 6.4
 | Franklin | 2 | 279.9 | 5.7 | 3.3 - 9.3
 | Hancock | 2 | 507.2 | 3.9 | 2.4 - 6.1
 | Kennebec | 6 | 1245.3 | 5.1 | 3.9 - 6.5
 | Knox | 2 | 403.7 | 5.4 | 3.4 - 8.3
 | Lincoln | 1 | 302.2 | 3.6 | 1.8 - 6.5
 | Oxford | 3 | 551.1 | 6 | 4.1 - 8.4
 | [NAME] | 9 | 1575.6 | 5.9 | 4.8 - 7.2
 | Piscataquis | 1 | 161 | 4.3 | 1.7 - 9.0
 | Sagadahoc | 2 | 405.3 | 4.7 | 2.8 - 7.3
 | Somerset | 4 | 539.7 | 6.5 | 4.5 - 9.0
 | [NAME] | 3 | 403.1 | 6.9 | 4.6 - 10.0
 | Washington | 2 | 343.1 | 4.7 | 2.7 - 7.6
 | York | 12 | 2081.9 | 5.7 | 4.7 - 6.8
Public Health District (Maternal residence)
 | Aroostook | 4 | 704.5 | 5.4 | 3.8 - 7.4
 | Central | 10 | 1785 | 5.5 | 4.5 - 6.7
 | Cumberland | 17 | 2983.6 | 5.5 | 4.7 - 6.4
 | Downeast | 4 | 850.3 | 4.2 | 3.0 - 5.9
 | Mid Coast | 8 | 1514.3 | 5.3 | 4.2 - 6.6
 | Penquis | 10 | 1736.6 | 5.8 | 4.7 - 7.0
 | Western | 13 | 2155.3 | 6.1 | 5.1 - 7.3
 | York | 12 | 2081.9 | 5.7 | 4.7 - 6.8
Data Source: Maine linked infant birth/death and birth certificate databases, Maine CDC Data, Research and Vital Statistics. *Infant mortality=number of deaths to children under 1 year of age per 1,000 live births.  95% CI = 95% Confidence Interval.
Spreadsheet: 758625d1638974561-excel-fprmula-for-monthly-and-year-to-date-profit-and-loss-profit-and-loss
Sheet: Sheet2

 | Column Labels
 | Sum of Revenue | Sum of Expenses | Sum of Profit | Total Sum of Revenue | Total Sum of Expenses | Total Sum of Profit
Row Labels | 2021 | 2021 | 2021
Jan | 7000 | 3700 | 3300 | 7000 | 3700 | 3300
Feb | 11000 | 7500 | 3500 | 11000 | 7500 | 3500
Mar | 7000 | 3700 | 3300 | 7000 | 3700 | 3300
Apr | 11000 | 7500 | 3500 | 11000 | 7500 | 3500
Grand Total | 36000 | 22400 | 13600 | 36000 | 22400 | 13600
Spreadsheet: 793625d1661586231-index-match-for-2-variables-andrew-apples-pears
Sheet: Sheet1

 |  | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 |  |  | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00
 | [NAME] | a | c | pears | c |  |  | [NAME] | [NAME] | [NAME] | anne
 | [NAME] | apples | d | f | s
 | [NAME] | c | pears | g | w
 | anne | d | f | e | apples
 | luke | e | g | d | e
 | formula for input in I3 to L3 - input people who bought apples OR pears on a particular date.
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 11b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* |  | <100 | <100 | 156 | 156
FRA | 618 | 230 | <100 | 774 | 1622
IRS- [NAME] | 4751 | 1538 | 332 | 5618 | 12239
OIS | 354 | 130 |  | 228 | 712
VNS | <100 |  |  |  | <100
Zero Coupon | <100 | <100 |  |  | <100
TOTAL | 5723 | 1898 | 332 | 6776 | 14729
Estimated swap transaction volumes, week ending January 4, by product type and supermajor currency (millions of USD), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for supermajor currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 825239d1681209645-show-results-based-on-multiple-matching-criteria-results-based-on-multiple-criteria-match
Sheet: Sheet1

 |  |  |  |  |  |  | Car List
Class | Roll | Car | [NAME] |  |  | Class | Car | [NAME] | Role | Role Rank |  | A+ |  | Balance
A+ | Balance |  |  |  |  | B | NISSAN Skyline GT-R V-spec (1999) | 129 | Balance | 2 |  | A |  | Corner
 |  |  |  |  |  | A+ | [NAME] 670-4 SV (2009) | 179 | Balance | 2 |  | B |  | Top Speed
 |  |  |  |  |  | S+ | Mercedes-Benz 190E 2.5-16 (1988)) | 234 | Balance | 2 |  | S |  | Walker
 |  |  |  |  |  | B | Porsche 911 Carrera RSR 2.8 (1973) | 131 | Corner | 1 |  | S+
 |  |  |  |  |  | B | Honda NSX-R | 135 | Balance | 1
Expected Results |  |  |  |  |  | A | Porsche 911 Carrera RSR 2.8 (1973) | 140 | Corner | 1
Class | Roll | Car | [NAME] |  |  | B | Mazda MX-5 (1996) | 142 | Top Speed | 1
A+ | Balance |  |  |  |  | A | NISSAN Skyline GT-R V-spec (1999) | 160 | Balance | 1
 |  |  |  |  |  | A+ | Porsche 911 Carrera RSR 2.8 (1973) | 167 | Corner | 1
 |  |  |  |  |  | S | Mercedes-AMG GT Black Series (2020) | 171 | Corner | 1
 |  |  |  |  |  | B | Acura RSX-S (2004) | 172 | Walker | 1
 |  |  |  |  |  | A | Ferrari Testarossa Coupe (1984) | 173 | Walker | 1
 |  |  |  |  |  | A+ | NISSAN Skyline GT-R KPGC10 (1971) | 173 | Balance | 1
 |  |  |  |  |  | A+ | Ferrari Testarossa Coupe (1984) | 193 | Walker | 1
 |  |  |  |  |  | A+ | Lotus Emira | 194 | Top Speed | 1
 |  |  |  |  |  | S | Ferrari F40 (1987) | 195 | Balance | 1
 |  |  |  |  |  | S+ | Lotus Exige S (2006) | 222 | Corner | 1
 |  |  |  |  |  | S | Ferrari Testarossa Coupe (1984) | 224 | Walker | 1
 |  |  |  |  |  | S+ | Porsche 911 Carrera S (1997) | 233 | Balance | 1
 |  |  |  |  |  | S+ | [NAME] (2016) | 245 | Top Speed | 1
Spreadsheet: 800129d1665497387-reconciliation-of-two-sheets-exercise-2-
Sheet: Reconciliation

Part (with 000 ending) | Store - Sheet1 | Part possibilities - Sheet1 | Consumption - Sheet 1 | Element - Sheet 1 | Element - Sheet 1 (000 ending) |  | Store - Sheet 2 | Part - Sheet 2 | Consumption - Sheet 2 | Consumption - Sheet 2*1000 | Element - Sheet 2
[PHONE] | 5414 | [PHONE]
[PHONE] | 5524 | [PHONE]
[PHONE] | 5414 | [PHONE]
[PHONE] | 5448 | [PHONE]
[PHONE] | 5448 | [PHONE]
[PHONE] | 5524 | [PHONE] | n/a | n/a |  |  |  |  | n/a |  | n/a
Spreadsheet: 39902d1238149607-vlookup-query-index-match-amended-pricing-sheet
Sheet: Project control

JOB CONTROL AS AT:
PROJECT: |  | 0
Material Content |  |  |  |  | Plant Content |  |  |  |  | Labour content |  |  | Dollars | Hours |  | Contractors
CONTRACT VALUE: |  |  | 157.77 |  | CONTRACT VALUE: |  |  | 0 |  | CONTRACT VALUE: |  |  | 0 | 1.1 |  | CONTRACT VALUE: |  |  | 0
DATE | DESCRIPT. | INV. NO. | AMOUNT |  | DATE | DESCRIPT. | INV. NO. | AMOUNT |  | DATE | DESCRIPT. | INV. NO. | AMOUNT |  |  | DATE | DESCRIPT. | INV. NO. | AMOUNT
COST TO DATE B/F |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  | 0
Month: |  |  |  |  | Month: |  |  |  |  | Month: |  |  |  |  |  | Month:
COST TO DATE: |  |  | 0 |  | COST TO DATE: |  |  | 0 |  | COST TO DATE: |  |  | 0 | 0 |  | COST TO DATE: |  |  | 0
BALANCE OF CONTRACT: |  |  | 157.77 |  | BALANCE OF CONTRACT: |  |  | 0 |  | BALANCE OF CONTRACT: |  |  | 0 | 1.1 |  | BALANCE OF CONTRACT: |  |  | 0
TOTAL CONTRACT PRICE: |  |  | 0
BALANCE OF CONTRACT: |  |  | 0
Spreadsheet: 49268d1248535540-looking-up-the-column-header-for-a-given-value-in-a-column-example-ranj
Sheet: Sheet2

Header 1 | [NAME] | [NAME] | [NAME] | ABS High 1 | Header | ABS High 2 | Header
-2.32 | -5 | 4 | 1 | -5 | [NAME] | 4 | [NAME]
-1.01 | -3 | 2.5 | 2 | -3 | [NAME] | 2.5 | [NAME]
-3.3 | -2 | 1 | 3 | -3.3 | Header 1 | 3 | [NAME]
-2.32 | -1 | 7 | 4 | 7 | [NAME] | 4 | [NAME]
Spreadsheet: kate_symes__18258__Deal Correction 4-2
Sheet: 3-30

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-03-30 00:00:00 | 2001-03-30 00:00:00 | 2001-02-27 00:00:00 | STCA | JR | EES | N/A | Changed index sale to peak hours/added off peak index sale |  | 533090/  566081 | NP-15 | H-01 | RTC | 25 | DJ NP15 Index | EES
 | 2001-03-30 00:00:00 | 2001-03-30 00:00:00 | 2001-03-05 00:00:00 | STCA | KS | EES | N/A | Offset: from +2 to -2 |  | 537972/3 | SP-15 | 2001-03-06 00:00:00 | RTC | 18 | DJ SP15 Index-2 | EES
 | 2001-03-30 00:00:00 | 2001-03-30 00:00:00 | 2001-03-27 00:00:00 | STSW | TA | Houston | APB | Broker fee: from .0075 to .0275 |  | 562195 | PV | 2001-03-28 00:00:00 | On [NAME] | 25 | 120.02 | LADWP
 |  |  |  | Grand Count
Spreadsheet: 134811d1325642393-extracting-ms-project-data-extract-forum-help-tollgates-to-milestones
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | How to Extract Date & Ignore Times in Columns E & F?
 | Extracted | 2012-01-03 00:00:00
 | Time Extracted | 17:30:00
 |  |  |  | AS IS Extraction |  |  |  |  |  |  |  | Ignore Times
 | Task Name | Notes / Comments | Planned Duration | Planned Start | Planned Finish | Phyical % Complete | Actual Finish | Resource Names | Predecessors |  |  | Planned Start | Planned Finish
 | Company Z - Company A Program | 01/03/12 Draft | 111.4 wks? | 2011-12-15 08:00:00 | 2014-01-31 17:00:00 | 0 | NA
 | Company A Project Planning |  | 6 wks | 2011-12-19 08:00:00 | 2012-01-27 17:00:00 | 0 | NA | All Associated Company A Divisions
 | Company A Internal Program & Project Kickoff |  | 6 wks | 2011-12-19 08:00:00 | 2012-01-27 17:00:00 | 0 | NA | Company A Mgnt. & Company Z POCs
 | Define Objectives |  | 3 wks | 2011-12-19 08:00:00 | 2012-01-06 17:00:00 | 0 | NA
 | Define Project Scope |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Develop Project Plan |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Review Project Plan |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Revise Project Plan |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Re-Review Project Plan |  | 5 wks | 2011-12-19 08:00:00 | 2012-01-20 17:00:00 | 0 | NA
 | Company A Internal Approval |  | 1 wk | 2012-01-23 08:00:00 | 2012-01-27 17:00:00 | 0 | NA |  | 3,4,8,5,6,7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Have running extraction function
 | Company A Kickoff Meeting with Company Z |  | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA
 | Company A Kickoff Meeting with Company Z | Company A Mgnt. & Company Z  Mgnt. & POCs | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA | Company A Mgnt. & Company Z  Mgnt. & POCs
 | Company A Presents Project Plan |  | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA
 | If necessary, Revise Project Plan |  | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA
 | Re-Review Project Plan with Company Z |  | 3 wks? | 2012-01-16 08:00:00 | 2012-02-03 17:00:00 | 0 | NA
 | Company Z Approves Program & Project Plan |  | 0 wks | 2012-02-03 17:00:00 | 2012-02-03 17:00:00 | 0 | NA |  | 16,14,15
Spreadsheet: 219786d1362947681-how-to-count-number-of-overlapping-rows-within-a-time-interval-testjobs
Sheet: Sheet1

Name | Job Start date & Time | Job End  date & Time | Job Start  Time | Job End  Time | interval  start | interval  end | count
q1 | 2012-02-17 07:00:01.980000 | 2012-02-17 07:00:06.470000 |  |  | 07:00:00
q2 | 2012-02-17 07:00:01.690000 | 2012-02-17 07:00:08.250000
q3 | 2012-02-17 07:00:02 | 2012-02-17 07:00:05.640000
q4 | 2012-02-17 07:00:02.860000 | 2012-02-17 07:00:05.010000
q5 | 2012-02-17 07:00:50.910000 | 2012-02-17 07:01:24.040000
q6 | 2012-02-17 07:00:05.460000 | 2012-02-17 07:00:06.340000
q7 | 2012-02-17 07:00:10.780000 | 2012-02-17 07:00:22.960000
q8 | 2012-02-17 07:00:06.500000 | 2012-02-17 07:00:08.300000
q9 | 2012-02-17 07:00:07.100000 | 2012-02-17 07:00:07.750000
q10 | 2012-02-17 07:00:07.380000 | 2012-02-17 07:00:08.510000
q11 | 2012-02-17 07:00:08.450000 | 2012-02-17 07:00:12.360000
q12 | 2012-02-17 07:00:08.530000 | 2012-02-17 07:00:10.870000
q13 | 2012-02-17 07:00:08.390000 | 2012-02-17 07:00:09.030000
q14 | 2012-02-17 07:20:10.230000 | 2012-02-17 07:20:14.400000
q15 | 2012-02-17 07:00:08.990000 | 2012-02-17 07:00:10.770000
q16 | 2012-02-17 07:00:09.110000 | 2012-02-17 07:00:11.320000
q17 | 2012-02-17 07:04:50.270000 | 2012-02-17 07:16:29.970000
q18 | 2012-02-17 07:20:14.400000 | 2012-02-17 07:20:45.460000
Spreadsheet: 63e11c34-11f0-4270-82f5-b03e1badc1d6
Sheet: Dataset S8

Dataset S8. Details of CRISPR variants
Lineage | CRISPR_ID | CRISPR1 spacer content | CRISPR2 spacer content
N01-73.H.09 | CR_AG1 | STM1var1-Ago1-STM2-STM3-ParB2-Ago2-Ago3-Ago4-Ago5-Ago6-Ago7-Chol2-Ago8-Ago9-Ago10-Ago11-Ago12 | [NAME]
N05-62.H.72 | CR_AG2 | STM1var1-Ago1-STM2-STM3-ParB2-Ago2-Ago3-Ago4-Ago5-Ago6-Ago7-Chol2-Ago8-Ago9-Ago10-Ago11-Ago12-Ago13 | [NAME]              AgoB4-AgoB5-AgoB6-AgoB7
N17-17.H.06 | CR_AG3 | STM1var1-Ago1-STM2-STM3-ParB2-Ago2          Ago4-Ago5-Ago6-Ago7-Chol2-Ago8-Ago9-Ago10-Ago11-Ago12-Ago13 | [NAME]              AgoB4-AgoB5-AgoB6-AgoB7-AgoB8
N17-18.H.07 N33-34.H.09 | CR_AG4 | STM1var1-Ago1-STM2-STM3-ParB2-Ago2-Ago3-Ago4-Ago5-Ago6-Ago7-Chol2          Ago9-Ago10-Ago11-Ago12-Ago13 | [NAME]              AgoB4-AgoB5-AgoB6-AgoB7-AgoB8
N27-25.H.03 and remaining strains | CR_AG5 | STM1var1-Ago1-STM2-STM3-ParB2-Ago2-Ago3-Ago4-Ago5-Ago6-Ago7-Chol2-Ago8-Ago9-Ago10-Ago11-Ago12-Ago13 | [NAME]              AgoB4-AgoB5-AgoB6-AgoB7-AgoB8
N31-36.H.00 | CR_AG6 | STM1var1-Ago1-STM2-STM3           Ago2-Ago3-Ago4-Ago5-Ago6-Ago7-Chol2-Ago8-Ago9-Ago10-Ago11-Ago12-Ago13 | [NAME]              AgoB4-AgoB5-AgoB6-AgoB7-AgoB8
N02-N38 | CR_AG7 (MRCA)* | STM1var1-Ago1-STM2-STM3-ParB2-Ago2-Ago3-Ago4-Ago5-Ago6-Ago7-Chol2-Ago8-Ago9-Ago10-Ago11-Ago12-Ago13 | [NAME]
Note: *CR_AG7 represent the ancestral CRISPR profile from which all others are derived
Lineages are named according to Dataset S2.
Spacer designations are according to Institut Pasteur CRISPR Query Page (http://www.pasteur.fr/recherche/genopole/PF8/crispr/CRISPRDB.html).
SL483 and all other genomes not listed above possess the CR_AG5 profile
Spreadsheet: 164078d1340641926-look-up-problem-code-and-loaction
Sheet: Sheet1

Code & Location | Code
72040109
5023949764661
72040114
5023949223920
5023949510183
5023949791414
72040115
5023949057895
72010901
5023949510183
72010904
5023949510183
72010908
5023949510183
5023949771634
5023949833970
72010910
5023949423933
5023949510183
5023949583392
5023949912859
72010913