tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 768116d1644846353-data-validation-formula-choosing-from-a-list-of-multiply-cells-and-values-calculated-vlidation_test
Sheet: Sheet1

a | b | c | d |  |  |  | a | b | hidden | c | d
one | 500 | 700 |  |  | but what I need is |  | one | 500 |  | 700 | 700
two | 275 | 375 |  |  |  |  | two | 275 |  | 375 | 375
 |  |  |  |  |  |  |  |  | ^ |  | ^
 |  |  |  |  |  |  |  |  |  |  | This result wanted
 |  |  |  |  |  | wanted validation formula |  |  | Of course with no hidden columns
 |  |  |  |  |  | $A$2;($C$2+$A$2)/2;$C$2 |  |  |  |  |  |  | 500;600;700
 |  |  |  |  | and | $A$2;($C$2+$A$2)*49,5%;($C$2+$A$2)*50%($C$2+$A$2)*50,5%;$C$3 |  |  |  |  |  |  | 500;594;600;606;700
Spreadsheet: 821494d1678745025-conditional-formatting-issue-anniversary-date-cf
Sheet: anniversary cf

 |  |  |  |  |  |  | Anniversary Date | Appointment Date | Eval Completed Date | Elapsed Days (just to illustrate, not needed in solution)
 |  |  |  |  |  |  | 1995-06-19 00:00:00 | 2022-04-16 00:00:00 | 2020-12-11 00:00:00
 |  |  |  |  |  |  | 1988-12-05 00:00:00 | 2008-07-01 00:00:00 | 2023-02-03 00:00:00
 |  |  |  |  |  |  | 2016-06-15 00:00:00 | 2020-11-16 00:00:00 | 2022-06-13 00:00:00
 |  |  |  |  |  |  | 2000-01-23 00:00:00 |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  | 2001-02-23 00:00:00 |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  | 2002-03-23 00:00:00 |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  | 2003-04-23 00:00:00 |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  | 1988-04-30 00:00:00 |  | 2023-05-01 00:00:00
Spreadsheet: 152581d1335444798-vlook-ups-help-please-fte
Sheet: Sheet1

Names | Dates | FTE
fffdf | 2009-01-02 00:00:00 | 37.5
ddd | 2009-12-01 00:00:00 | 37.5 |  |  | FTE at this date
fffdf | 2011-07-25 00:00:00 | 37.5 | I would like to have | 2011-11-28 00:00:00
ddfd | 2011-10-03 00:00:00 | 22
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-31 00:00:00 | 30.5
 | 2011-10-31 00:00:00 | 37.5
 | 2011-10-31 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 25.25
 | 2011-11-28 00:00:00 | 25.25
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
Spreadsheet: 622893d1556977796-create-one-master-list-from-lists-on-multiple-worksheets-excel-forum-example-create-one-list-from-multiple-sheets-3
Sheet: Extract (AssetStatus-Client2)

Obj Category | Object Type | Object No. | Description | Serial No | Own Depot
THYDBST | 101499 | 75115 | List 4 description 1 | 75115 | Client2
THYDBST | 101499 | 75191 | List 4 description 2 | J2SUB1065 | Client2
THYDBST | 101499 | 75691 | List 4 description 3 | J2SUB1149 | Client2
THYDBST | 101499 | 75692 | List 4 description 4 | J2SUB1150 | Client2
THYDCAM | 100217 | 75393 | List 4 description 5 | 0256/0257 | Client2
THYDCAM | 100217 | 75077 | List 4 description 6 | 204/205 | Client2
THYDCAM | 100217 | 31307 | List 4 description 7 | J2-HLK4600-02L/R | Client2
Spreadsheet: 289187d1389445108-i-want-telephone-numbers-and-time-of-any-format-to-specific-format-sample
Sheet: Sheet1

Mon | Tue |  |  | Expected output
11:00 AM to 10:00 PM | 11:00 AM to 10:00 PM |  |  | 11:00 AM to 10:00 PM | 11:00 AM to 10:00 PM
11 to 10 PM | 11:00 AM to 10:00 PM |  |  | 11:00 AM to 10:00 PM | 11:00 AM to 10:00 PM
11:00 AM to 10:00 PM | 11:00 AM to 10:00 PM |  |  | 11:00 AM to 10:00 PM | 11:00 AM to 10:00 PM
11:00 AM to 10:00 PM | 11:00 AM to 10:00 PM |  |  | 11:00 AM to 11:00 PM | 11:00 AM to 10:00 PM
11:00 AM to 11:00 PM | 11:00 to 10:00 |  |  | 11:00 AM to 11:00 PM | 11:00 AM to 10:00 PM
11:00 AM to 10:00 PM | 11:00 to 10:00 |  |  | 11:00 AM to 11:00 PM | 11:00 AM to 10:00 PM
11:00 AM to 10:00 PM | 11:00 to 10:00
11:00 to 10:00 | 11:00 AM to 10:00 PM
11:00 AM to 10:00 PM | 11:00 AM to 10:00 PM
11:00 AM to 10:00 PM | 11 to 10 PM
11:00 AM to 10:00 PM | 11 to 10 PM
11:00 AM to 10:00 PM | 11 to 10 PM
11:00 AM to 10:00 PM | 11 to 10 PM
Spreadsheet: 887656d1737949422-index-sumproduct-spill-issue-afl-supercoach-2025-test
Sheet: BRL

PLAYER | TOT | AVG |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 |  | CBA | CBA 1H | CBA2H | CBA L5
[NAME] | 630 |  |  |  |  | 83 |  |  | 89 | 73 | 83 | 82 | 85 | 85 | 87 | 81 | 93 |  | 86 | 82 | 76 | 85 | 90 | 88 | 96 | 88 | 93 | 96 | 81 | 80 | 85 | 94 | 90 | 90
[NAME] | 582 |  |  |  |  | 83 | 93 |  | 78 | 88 | 92 | 35 |  | 90 | 90 | 86 | 89 |  | 90 | 76 | 76 | 88 | 84 | 91 | 88 | 88 | 71 | 92 | 85 | 80 | 81 | 91 | 57
[NAME] | 609 |  |  |  |  | 59 | 85 |  | 85 | 85 | 83 | 88 | 81 | 90 | 87 | 69 | 67 |  | 72 | 76 | 65 | 88 | 84 | 88 | 80 | 92 | 82 | 92 | 81 | 76 | 81 | 76 | 83 | 87
[NAME] | 449 |  |  |  |  | 45 | 63 |  | 63 | 65 | 63 | 76 | 77 | 80 | 70 | 39 | 52 |  | 31 | 37 | 43 | 46 | 48 | 64 | 64 | 72 | 54 | 64 | 77 | 72 | 74 | 62 | 60 | 74
[NAME] | 47 |  |  |  |  |  |  |  | 22 |  |  |  | 81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
[NAME] | 29 |  |  |  |  | 52 | 48 |  |  |  |  | 6
[NAME] | 122 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 19 | 15 | 36 | 28 | 43 | 24 | 31 | 40 | 37 | 44 | 50 | 42
[NAME] | 167 |  |  |  |  | 38 | 33 |  | 26 | 35 | 38 | 47 | 27 | 10 | 10 | 33 | 15 |  | 14 | 16 | 19 | 12 | 19 | 18 | 16 | 12 | 29 | 24 | 23 | 28 | 22 | 24 | 13 | 6
[NAME] | 155 |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 35 | 47 | 64 | 74 |  | 83 | 68 | 76 | 35 | 0 | 9 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 9 |  |  |  |  |  | 30 |  | 4
[NAME] | 117 |  |  |  |  | 17 | 7 |  | 0 | 12 | 8 | 65 | 19 | 10 | 10 | 14 | 11 |  | 10 | 24 | 24 | 12 | 16 | 9 | 12 | 0 | 0 | 0 | 15 | 20 | 19 | 9 | 43 | 35
[NAME] | 83 |  |  |  |  | 14 | 30 |  | 33 | 27 | 33 |  |  |  |  |  | 0 |  | 14 | 21 | 22 | 12 | 39 | 15 | 4 | 8 | 0 | 0 | 8 | 4 | 0 | 0 | 3 | 0
[NAME] | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 12 | 29 | 8
[NAME] | 7 |  |  |  |  |  |  |  |  | 15 |  | 0 | 12
[NAME] | 12 |  |  |  |  | 10 | 11 |  | 0 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 14 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Total Team CBAs |  |  |  |  |  | 29 | 27 |  | 27 | 26 | 24 | 17 | 26 | 20 | 30 | 36 | 27 |  | 29 | 38 | 37 | 26 | 31 | 33 | 25 | 25 | 28 | 25 | 26 | 25 | 27 | 34 | 30 | 31
Spreadsheet: 221300d1363458496-attemepting-to-link-and-automate-multiple-data-points-individual-rep-kpi-report-2013-example
Sheet: Rep A

Name: |  |  |  |  |  |  |  |  |  |  |  |  | Jan 2013 - Dec 2013
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jan-Jun Total
Results | Rep | Team | Rep | Team | Rep | Team | Rep | Team | Rep | Team | Rep | Team | Rep | Team
Goal
Act
% to Goal
Goal
Act
% to Goal
Goal
Act
% to Goal
Activity | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jan-Jun Total
Goal
Act
% to Goal
Goal
Act
% to Goal
 | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jul-Dec Total
Results | Rep | Team | Rep | Team | Rep | Team | Rep | Team | Rep | Team | Rep | Team | Rep | Team
Goal
Act
% to Goal
Goal
Act
% to Goal
Goal
Act
% to Goal
Activity | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Jul-Dec Total
Goal
Act
% to Goal
Goal
Act
% to Goal
2013 Total
Results | Rep | Team | Results |  | Rep | Team | Results |  | Rep | Team
Goal |  |  | Goal |  |  |  | Goal
Act |  |  | Act |  |  |  | Act
% to Goal |  |  | % to Goal |  |  |  | % to Goal
2013 Total
Activity | Rep | Team | Activity |  | Rep | Team
Goal |  |  | Goal
Act |  |  | Act
% to Goal |  |  | % to Goal
Spreadsheet: 737794d1624609941-date-as-header-filter-names-and-make-a-list-for-work-location-tracker-pq-work-location-tracker-aligw
Sheet: Result

Week No | 23
Start date
End date
 | Name | Address | Phone |  |  |  |  |  |  |  | Name | Address | Phone | 01-Jun-21 | 05-Jun-21 | 06-Jun-21 | 07-Jun-21 | 08-Jun-21 | 09-Jun-21 | 10-Jun-21 | 11-Jun-21 | 12-Jun-21 | 03-Jun-21 | 04-Jun-21 | 02-Jun-21 | 13-Jun-21 | 14-Jun-21 | 15-Jun-21 | 16-Jun-21
 | Name-1 | Address-101 | Ph-01 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | Name-1 | Address-101 | Ph-01 | Y | Y | Y | Y | Y | Y | Y | Y | Y
 | Name-6 | Address-106 | Ph-06 |  | ✓ |  |  |  | ✓ |  | Name-14 | Address-114 | Ph-14 |  |  |  |  |  |  |  |  |  |  | Y |  | Y
 | Name-15 | Address-115 | Ph-15 |  |  |  |  | ✓ | ✓ |  | Name-15 | Address-115 | Ph-15 |  |  |  |  |  |  |  | Y | Y |  |  |  | Y | Y | Y | Y
 | Name-16 | Address-116 | Ph-16 |  |  | ✓ | ✓ | ✓ | ✓ |  | Name-16 | Address-116 | Ph-16 |  |  |  |  |  | Y | Y | Y | Y
 | Name-22 | Address-122 | Ph-22 |  |  |  | ✓ | ✓ |  |  | Name-22 | Address-122 | Ph-22 |  | Y |  |  |  |  | Y | Y |  |  |  |  | Y
 | Name-23 | Address-123 | Ph-23 | ✓ | ✓ |  |  |  |  |  | Name-23 | Address-123 | Ph-23 |  | Y | Y | Y | Y
 | Name-28 | Address-128 | Ph-28 |  | ✓ |  |  |  |  |  | Name-28 | Address-128 | Ph-28 |  |  |  |  | Y
 | Name-31 | Address-131 | Ph-31 |  |  | ✓ | ✓ | ✓ | ✓ |  | Name-29 | Address-129 | Ph-29 |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Name-36 | Address-136 | Ph-36 |  |  |  |  |  | ✓ |  | Name-3 | Address-103 | Ph-03 |  |  |  |  |  |  |  |  |  | Y
 | Name-45 | Address-145 | Ph-45 | ✓ | ✓ |  | ✓ | ✓ | ✓ |  | Name-30 | Address-130 | Ph-30 | Y |  |  |  |  |  |  |  |  |  |  |  | Y | Y | Y | Y
 | Name-46 | Address-146 | Ph-46 |  |  | ✓ | ✓ | ✓ | ✓ |  | Name-31 | Address-131 | Ph-31 |  |  |  |  |  | Y | Y | Y | Y |  |  |  | Y | Y | Y | Y
 | Name-47 | [NAME] | Ph-47 | ✓ | ✓ | ✓ |  |  |  |  | Name-36 | Address-136 | Ph-36 |  |  |  |  |  |  |  |  | Y
 | Name-50 | Address-150 | Ph-50 |  | ✓ |  |  |  |  |  | [NAME] | Address-139 | Ph-39 | Y |  |  |  |  |  |  |  |  |  | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Name-44 | Address-144 | Ph-44 |  | Y
 |  |  |  |  |  |  |  |  |  |  | Name-45 | Address-145 | Ph-45 |  | Y | Y | Y | Y |  | Y | Y | Y |  |  |  |  | Y | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Name-46 | Address-146 | Ph-46 |  |  |  |  |  | Y | Y | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Name-47 | [NAME] | Ph-47 |  |  |  | Y | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Name-5 | Address-105 | Ph-05 |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  | Name-50 | Address-150 | Ph-50 |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  | Name-59 | Address-159 | Ph-59 |  |  |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  | Name-6 | Address-106 | Ph-06 |  |  |  |  | Y |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  | Name-60 | Address-160 | Ph-60 |  |  |  |  |  |  |  |  |  |  |  |  | Y | Y | Y | Y
 |  |  |  |  |  |  |  |  |  |  | Name-66 | Address-166 | Ph-66 |  | Y
 |  |  |  |  |  |  |  |  |  |  | Name-9 | Address-109 | Ph-09 | Y |  |  |  |  |  |  |  |  | Y | Y | Y
Spreadsheet: 53df8e15-4552-4ac8-8425-33af2a546c70
Sheet: Appx A. Permit Types

[NAME] Types
Req # | Description of Requirement | Response | Comments
The system has the ability to track and maintain basic information and print for all of (and not limited to) the following permit types:
Zoning
PT.1 | Land Use Permits including the following subtypes…Standard structures, minor structures, telecom, wind turbine, sign, commercial, new homes
PT.2 | Address/911 Fire Number
PT.3 | [NAME]
PT.4 | Nonmetallic Mining Permits
PT.5 | Building Number Permits
Sanitation
The system has the ability to track and maintain basic permit information for all of (and not limited to) the following permit types:
PT.6 | New Sanitary
PT.7 | Existing Sanitary
PT.8 | Replacement Sanitary
PT.9 | Reconnect Sanitary
PT.10 | Non-plumbing Toilet
PT.11 | Privy
PT.12 | Aeration pretreatment components
Land Conservation
The system has the ability to track and maintain basic permit information for all of (and not limited to) the following permit types:
PT.13 | Animal Waste
Spreadsheet: 50287d1249655630-auto-inserting-rows-and-formula-audit-sheet
Sheet: Audit

Stock Audit Data
Year Start: |  | 2009-04-01 00:00:00
Year End |  | 2010-03-31 00:00:00
Audit # | AU001 |  |  | Raised by :
Date : | 2009-07-08 00:00:00 |  |  | [NAME] :
Item # | Serial # | Part # | Supplier | Model | Description | Warehouse | Shelf | StockType | Checked by | Notes | Part Category | Category Code | Unit Cost | Write-down Value
1 | 44-6676-01 | AC5536 | Cobra | XX44 | SU-Filter | 26 | A14 | Excess | 001 |  | C | 1-Standard | 5 | 3.333333333333333
Total |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 3.333333333333333
Spreadsheet: 268726d1380756613-help-circumference-error-circumference-error
Sheet: Table 4 Inter %Region (No FMO) 

Analyst 1
 | Relative Percentage
Animal | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
MF39741M | 55 | 9.5 | 16 | 37.5 | 21.8 | 90.1
MF39735M | 61.1 | 7.1 | 17 | 60.1 | 19.4 | 96.3
MF39746M | 63.9 | 3.4 | 10.3 | 30.2 | 23.6 | 92.9
MF39758F | 73.5 | 9.6 | 14.6 | 37.7 | 9.7 | 90.7
MF39755F | 62.5 | 22 | 14.1 | 36.2 | 22 | 92.5
MF39754F | 64.7 | 17.5 | 18.6 | 64.5 | 12 | 95.4
Mean | 63.5 | 11.5 | 15.1 | 44.4 | 18.1 | 93
SD | 6 | 6.9 | 2.9 | 14.2 | 5.8 | 2.5
Analyst 2
 | Relative Percentage
Animal | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
MF39741M | 56.4 | 6.3 | 14.7 | 24 | 23 | 87.3
MF39735M | 61.1 | 4.9 | 17.1 | 50.7 | 20 | 97.4
MF39746M | 64 | 2.5 | 10.8 | 34.1 | 23 | 89.8
MF39758F | 72.5 | 8.7 | 14.6 | 42.5 | 10.5 | 90.5
MF39755F | 62.6 | 18.7 | 14.2 | 32.2 | 21.9 | 92.8
MF39754F | 63.1 | 13.2 | 18.8 | 54.7 | 13 | 95.9
Mean | 63.3 | 9.1 | 15 | 39.7 | 18.6 | 92.3
SD | 5.3 | 6 | 2.7 | 11.7 | 5.5 | 3.8
[NAME]
Animal | Relative Percentage
MF39741M | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 55.7 | 7.9 | 15.4 | 30.8 | 22.4 | 88.7
%difference | 2.5 | 40.5 | 8.5 | 43.9 | 5.4 | 3.2
Pass/Fail | Pass | Fail | Pass | Fail | Pass | Pass
[NAME]
Animal | Relative Percentage
MF39735M | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 61.1 | 6 | 17.1 | 55.4 | 19.7 | 96.9
%difference | 0 | 36.7 | 0.6 | 17 | 3 | 1.1
Pass/Fail | Pass | Fail | Pass | Pass | Pass | Pass
[NAME]
Animal | Relative Percentage
MF39746M | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 64 | 3 | 10.6 | 32.2 | 23.3 | 91.4
%difference | 0.2 | 30.5 | 4.7 | 12.1 | 2.6 | 3.4
Pass/Fail | Pass | Fail | Pass | Pass | Pass | Pass
[NAME]
Animal | Mean Values (% in Region)
MF39758F | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 73 | 9.2 | 14.6 | 40.1 | 10.1 | 90.6
%difference | 1.4 | 9.8 | 0 | 12 | 7.9 | 0.2
Pass/Fail | Pass | Pass | Pass | Pass | Pass | Pass
[NAME]
Animal | Mean Values (% in Region)
MF39755F | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 62.6 | 20.4 | 14.2 | 34.2 | 22 | 92.7
%difference | 0.2 | 16.2 | 0.7 | 11.7 | 0.5 | 0.3
Pass/Fail | Pass | Pass | Pass | Pass | Pass | Pass
[NAME]
Animal | Mean Values (% in Region)
MF39754F | CD3+ | CD3+/TSF19+ | CD3-/CD20+ | CD3-/CD20+/TSF19+ | CD3-/CD20-/CD16+ | CD3-/CD20-/CD16+/TSF19+
Mean | 63.9 | 15.4 | 18.7 | 59.6 | 12.5 | 95.7
%difference | 2.5 | 28 | 1.1 | 16.4 | 8 | 0.5
Pass/Fail | Pass | Fail | Pass | Pass | Pass | Pass
Spreadsheet: 33a60295-4466-4ece-9ed3-a069c48e0bd5
Sheet: Sheet1

Supplementary Table 17: T.hominis Orf3051 shows highest similarity to bacterial peptidases and shares similar configuration of transmembrane domains (see Figure S14). Eukaryotic sequences show lower similarity and a different configuration of transmembrane domains. The sequences of A. fumigatus lack the functional CAAX peptidase sites and are therefore not included in the alignment figure (see Figure S14). | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Accession | organism | total score | query coverage | E-value | identities
search against all nr:
ZP_04061034.1 | Staphylococcus hominis SK119 | 56.6 | 0.63 | 6e-07 | 0.34
ZP_07843359.1 | Staphylococcus hominis subsp. hominis C80 | 56.6 | 0.63 | 6e-07 | 0.34
ZP_08094116.1 | Planococcus donghaensis MPA1U2 | 48.1 | 0.51 | 0.0004 | 0.28
YP_004149860.1 | Staphylococcus pseudintermedius HKU10-03 | 46.6 | 0.51 | 0.002 | 0.29
ACZ58679.1 | Staphylococcus aureus | 45.1 | 0.42 | 0.005 | 0.31
ZP_08572893.1 | Lactobacillus coryniformis subsp. torquens KCTC 3535 | 45.4 | 0.73 | 0.005 | 0.28
search restricted against Eukaryotes:
NP_565483.1 | Arabidopsis thaliana | 40.4 | 0.48 | 3e-06 | 0.29
ACU19176.1 | Glycine max | 38.9 | 0.48 | 8e-06 | 0.24
XP_003527432.1 | Glycine max | 38.9 | 0.48 | 8e-06 | 0.24
EDP53501.1 | Aspergillus fumigatus A1163 | 37.7 | 0.29 | 3e-05 | 0.28
XP_748481.2 | Aspergillus fumigatus Af293 | 37 | 0.51 | 4e-05 | 0.24
XP_003083502.1 | Ostreococcus tauri | 36.6 | 0.41 | 5e-05 | 0.31
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 15d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index/Index Tranche | 31511 | 120243 | 203821 | 31748 | 105421 | 97494
OTHER* | - | - | 6992 | - | - | 12200
TOTAL | 31511 | 120243 | 210813 | 31748 | 105421 | 109694
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 85321d1285342476-need-additional-function-within-sumproduct-book1
Sheet: DATA

FUND | EVENT | [NAME] | DTC_INST | EUR_INST | FED_INST | NET AMOUNT
FUND1 | [NAME] | DTC | 1234 |  |  | 695600
FUND2 | [NAME] | DTC | 2345 |  |  | 2943200
FUND3 | [NAME] | DTC | 3456 |  |  | 1154464
FUND1 | [NAME] | FED |  |  | SUB_A | 2850
FUND2 | RECEIVE | FED |  |  | SUB_B | 253000
FUND2 | RECEIVE | EURO |  | SUB2 |  | 43050
FUND3 | RECEIVE | DTC | 3456 |  |  | 2361600
Spreadsheet: 605518d1547128169-abbreviating-names-secondtrack-saple
Sheet: List

[NAME] | Aint
Ascot | Ascot
Ayr | Ayr
Bangor | Bang
Bath | Bath
Beverley | Bev
Brighton | Brig
Carlisle | [NAME]
[NAME] | Cart
[NAME] | [NAME]
Cheltenham | Chelt
Chelmsford City | ChelmC
Chepstow | [NAME]
Chester | Chest
Doncaster | [NAME]
[NAME] | Epsm
Exeter | [NAME]
Fakenham | Fake
Ffos Las | [NAME]
Folkstone | Folk
Fontwell | Font
Goodwood | Good
[NAME] | Ham
Haydock | Hayd
[NAME] | Here
Hexham | Hex
Huntingdon | [NAME]
Kelso | Kelso
[NAME] | [NAME]
Leicester | Leic
Lingfield | Ling
Ludlow | [NAME]
Market Rasen | MrktR
Musselburgh | Muss
Newbury | Newb
Newcastle | Newc
Newmarket | Newm
[NAME] | [NAME]
[NAME] | Nott
Perth | Perth
Plumpton | Plump
Pontefract | Ponte
Redcar | Redc
Ripon | Ripon
Salisbury | Salis
Sandown | Sand
Sedgefield | Sedge
Southwell | [NAME]
[NAME] | Strat
Taunton | Taun
Thirsk | Thirsk
Towcester | Towc
[NAME] | Uttox
Warwick | Warw
Wetherby | Weth
Wincanton | Winc
Windsor | Wind
Wolverhampton | Wolv
Worcester | Worc
Yarmouth | Yarm
York | York
Ballinrobe | Ballin
Bellewstown | Belle
Clonmel | Clon
Cork | Cork
[NAME] | DownR
Downpatrick | DownP
Dundalk | Dund
Fairyhouse | Fairy
Galway | Gal
Gowran Park | GowP
Killarney | Killar
Kilbeggan | [NAME]
Laytown | [NAME]
Leopardstown | Leop
Limerick | Lim
Listowel | List
Naas | Naas
Navan | Navan
Punchestown | Punch
Roscommon | Rosc
Shelbourne | Shelb
Sligo | Sligo
The Curragh | Curr
Thurles | Thurl
Tipperary | Tipp
Tralee | Tral
Tramore | Tram
Wexford | Wex
Spreadsheet: 1a642e1f-fe27-4a16-8dec-14c75ffa965c
Sheet: UI MTDC

Blue Cells require manual data entry.  White Cells are auto-fill.
Personnel |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Totals |  | OSP USE ONLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UI categories
Additional PI's |  |  |  |  |  |  |  |  |  |  |  |  |  | 01 - Salaries
Post Docs |  |  |  |  |  |  |  |  |  |  |  |  |  | 02 - Fringe
Grads |  |  |  |  |  |  |  |  |  |  |  |  |  | 03 - IH
Undergrad |  |  |  |  |  |  |  |  |  |  |  |  |  | 04 - Travel
IH |  |  |  |  |  |  |  |  |  |  |  |  |  | 05 - OE
Total Salaries |  |  |  |  |  |  |  |  |  |  |  |  |  | 06 - CO > 5,000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 07 - CO < 5,000
Fringe benefits |  |  |  |  |  |  |  |  |  |  |  |  |  | 08 - Reserved | TBD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 09 - F&A
Additional PI's |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 - Tuition
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
IH
Total Fringe
Total sal&fringe
Travel - domestic |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Travel - foreign |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Materials & Supplies |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Publications |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Subcontract #1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Subcontract #2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Subcontract #3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Capital <5K |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Service agreement |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Service agreement |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Other Expenses
MTDC
Indirect Rate | 0.434
 | -
Equipment > 5K |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Capital Projects |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Student Fees & Insurance | 0 | 0
Rental Costs - Off Site Facilities |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Scholarships |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Fellowships |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Participant Support |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Patient Care |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Subcontract #1 residual |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Subcontract #2 residual |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Subcontract #3 residual |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Direct Cost
Total Request
 | Select
 | 0.434
 | 0.25
 | 0.557
 | 0.26
 | 0.303
 | 0.301
 | 0.21
 | Other
Spreadsheet: mike_grigsby__27817__TexacoPG&ETopock deals
Sheet: 692525

Deal Id | 692525 |  |  |  |  |  | Original Deal Volume |  |  | Deal Price
Month | 2001-04-01 00:00:00 |  |  |  |  |  | 5000 |  |  | 7.36
 |  | Pipe | Zone | MeterCode
 |  | PG&E |  |  | Sum
 |  | SBELP TPCK |  | Sum |  |  |  |  | PG&E Large Packages |  |  | Contract |  | PG&E Large Packages
 | Date | EP0202RSB - SB-EPNG/ | Sum |  |  |  | Volume Cut |  | Gas Daily Price |  |  | Penalty |  | Gas Daily Hi Price |  | Hi - Penalty
 | 1 |  |  |  |  |  |  |  | 7.65 |  |  |  |  | 8.31
 | 2 | 4300 | 4300 | 4300 | 4300 |  |  |  | 7.65 |  |  |  |  | 8.31
 | 3 | 4763 | 4763 | 4763 | 4763 |  |  |  | 6.035 |  |  |  |  | 6.66
 | 4 | 4603 | 4603 | 4603 | 4603 |  |  |  | 7.96 |  |  |  |  | 9.3
 | 5 | 2812 | 2812 | 2812 | 2812 |  |  |  | 10.895 |  |  |  |  | 12.12
 | 6 | 3675 | 3675 | 3675 | 3675 |  |  |  | 11.59 |  |  |  |  | 12.99
 | 7 |  |  |  |  |  |  |  | 11.83 |  |  |  |  | 12.24
 | 8 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.83 |  |  |  |  | 12.24
 | 9 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.83 |  |  |  |  | 12.24
 | 10 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.575 |  |  |  |  | 12.25
 | 11 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.73 |  |  |  |  | 11.93
 | 12 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.62 |  |  |  |  | 12.23
 | 13 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 14 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 15 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 16 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 17 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.775 |  |  |  |  | 12
 | 18 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.42 |  |  |  |  | 11.9
 | 19 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.37 |  |  |  |  | 11.9
 | 20 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.045 |  |  |  |  | 11.67
 | 21 |  |  |  |  |  |  |  | 10.67 |  |  |  |  | 11.23
 | 22 | 5000 | 5000 | 5000 | 5000 |  |  |  | 10.67 |  |  |  |  | 11.23
 | 23 | 5000 | 5000 | 5000 | 5000 |  |  |  | 10.67 |  |  |  |  | 11.23
 | 24 | 5000 | 5000 | 5000 | 5000 |  |  |  | 10.855 |  |  |  |  | 11.42
 | 25 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.995 |  |  |  |  | 12.6
 | 26 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.52 |  |  |  |  | 13.1
 | 27 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.105 |  |  |  |  | 12.6
 | 28 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.005 |  |  |  |  | 12.18
 | 29 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.005 |  |  |  |  | 12.18
 | 30 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.005 |  |  |  |  | 12.18
 | Sum |  | 130153 | 130153 | 130153