tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871666d1718092742-formula-to-pull-date-from-other-tab-formula
Sheet: Master

Financial Row | - No Cost Center - | COGS: [NAME]: Global | [NAME]: Licence - Product & Solutions | COGS: Maintenance - Customer Success | COGS: Maintenance - Infrastructure & Data | COGS: Professional Services - Customer Success | G&A: Corporate Existence | G&A: Facilities | G&A: Finance | G&A: Human Resources | G&A: Infrastructure & Data | G&A: Management | G&A: Operations | G&A: [NAME] | N/A: Only Balance Sheet entries | R&D: Product and Solutions: Global | R&D: Technology: R&D | S&M: Marketing | S&M: Office of Sales Strategy | S&M: Partner Channel Sales | S&M: Sales | S&M: Sales Engineering | Total
 | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount
Gross Profit
Overheads
610000 - Bank Charges
620000 - Depreciation
630000 - Insurance
635000 - Professional Fees
635001 - Subscription Services
635002 - Other Professional Fees
645001 - Meals and Entertainment:Entertainment Meals, Events & Other
645002 - Meals and Entertainment: Subsistence
645004 - Business Meals
650000 - Office Supplies
655000 - Operating Lease  Expenses
655000 - Operating Lease  Expenses
655200 - Variable Lease Expenses
Total - 655000 - Operating Lease  Expenses
660001 - Repair & Maintenance
664000 - Learning and Development
665102 - Salaries & Wages :Employee Benefits :Health Insurance
665104 - Salaries & Wages: Employee Benefits: Employer Payroll Taxes
665108 - Salaries & Wages: Employee Benefits: PTO Expense
665109 - Salaries & Wages: Defined Benefit Plan
665501 - Salaries & Wages: Bonus
665502 - Salaries & Wages: Other Compensation
665503 - Salaries & Wages: Salary
665505 - Salaries & Wages: Commissions
670000 - Shipping & Delivery
680000 - Taxes & Licenses
685001 - Travel: Lodging
685101 - Travel: Transportation: Airfare, Train and Bus Travel
685103 - Travel:Transportation: Mileage
685105 - Travel: Transportation: Taxi and Shuttle
691000 - Telecommunications
Total - Overheads
Operating Profit
Other Income
710000 - Exchange Gain
Total - Other Income
Other Expenses
810000 - Exchange Loss
810002 - Unrealized Gain/Loss
811009 - Rounding Gain/Loss (system)
Total - Other Expenses
Net Profit/(Loss)
Spreadsheet: 154698d1336517930-need-help-with-macros-for-invoice-worksheet-invoice-sheet
Sheet: Sheet2

COMPANY NAME
ADDRESS |  |  | Date: | 2012-05-08 00:00:00
 |  |  | Order No:
 |  |  | Account No:
 |  |  | Invoice No: | A001
Customer |  | Site Address
Part No | Description | Price Per Item | Quantity | Total
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
The Above Equipment was received by me in accordance with the above details. |  |  | Dis
Sign ………………………………………………………………… |  |  | Sub Total | 0
 |  |  | VAT 20% | 0
Print………………………………………………….……………… |  |  | Total | 0
Spreadsheet: 835240d1688436384-excel-formula-sum-values-if-then-formula-pile-tracker-formula-development-kampstra-
Sheet: Sheet1

White | White |  | 0 | 0 | 5 | 100 | 50 | 50 | 5 | 15
Red | Red |  | 5 | 10 | 12 | 14 | 25 | 100 | 50 | 0
Orange | Orange |  | 80 | 15 | 15 | 20 | 6 | 5 | 18 | 0
Yellow | Yellow |  | 0 | 0 | 5 | 100 | 50 | 20 | 30 | 40
Green | Green |  | 20 | 20 | 10 | 10 | 5 | 20 | 100 | 10
Blue | Blue |  | 20 | 20 | 10 | 10 | 5 | 20 | 100 | 60
Purple | Purple |  | 60 | 5 | 4 | 0 | 0 | 5 | 80 | 15
Pink | Pink |  | 80 | 15 | 15 | 20 | 6 | 5 | 18 | 0
Red | Orange |  | 5 | 15 | 15 | 20 | 6 | 5 | 15 | 15
Red | Yellow |  | 0 | 0 | 5 | 100 | 50 | 50 | 5 | 15
Red | Green |  | 20 | 20 | 10 | 10 | 5 | 20 | 100 | 60
Blue | Red |  | 60 | 250 | 60 | 5 | 4 | 0 | 0 | 5
Blue | Orange |  | 80 | 15 | 15 | 20 | 6 | 5 | 18 | 0
Blue | Yellow |  | 5 | 10 | 12 | 14 | 25 | 100 | 50 | 20
Blue | Green |  | 80 | 15 | 15 | 20 | 6 | 5 | 18 | 0
White | White
Red | Red
Orange | Orange
Yellow | Yellow
Green | Green
Blue | Blue
Purple | Purple
Pink | Pink
Red | Orange
Red | Yellow
Red | Green
Blue | Red
Blue | Orange
Blue | Yellow
Blue | Green
Color 1 | Color 2 | Column1 | 6A3 | 6A4 | 6A6 | 6A5 | 6A7 | 5A2 | 6A2 | 6A1
Blue | Red |  | 150 | 20
Blue | Red |  |  | 20
Blue | Red |  |  |  |  | 40 |  | 160
Blue | Red |  |  |  |  |  |  | 16
Blue | Yellow |  |  |  |  | 10 | 8 |  |  | 12
Blue | Orange |  | 10 |  |  | 88
Red | Yellow |  |  |  |  |  |  |  |  | 16
Pink | Black |  | 20
Pink | Black |  | 20
Blue | Orange |  |  |  | 116 | 18 | 20
Blue | Orange |  |  |  | 10
Blue | Orange
Blue | Orange
Pink | Pink
Blue | Green
Blue | Orange |  |  |  | 10 | 20
Orange | White |  |  |  | 10
Red | Yellow |  |  |  |  |  |  |  |  | 9
Red | Orange
Blue | Red |  |  |  |  |  |  |  |  | 14
Orange | White |  |  |  |  |  | 80
Blue | Green |  |  |  |  |  |  |  |  | 12
Red | Yellow |  |  |  |  |  |  |  |  | 20
Red | Green
Orange | White
Pink | Pink
Blue | Green
Blue | Orange
Blue | Green
Pink | Pink
Red | Green
Blue | Green
Red | Orange |  |  | 12 | 12
Red | Green
NC | NC
Spreadsheet: 229362d1366378152-referencing-a-named-range-or-sheet-dynamically-zone
Sheet: Sheet2

 | Zone | Branch
 | Zone 1 | Branch 1
 | Zone 1 | Branch 2
 | Zone 1 | Branch 3
 | Zone 1 | Branch 4
 | Zone 1 | Branch 5
 | Zone 1 | Branch 6
 | Zone 1 | Branch 7
 | Zone 1 | Branch 8
 | Zone 1 | Branch 9
 | Zone 1 | Branch 10
 | Zone 1 | Branch 11
 | Zone | Branch
 | Zone 2 | Branch 1
 | Zone 2 | Branch 2
 | Zone 2 | Branch 3
 | Zone 2 | Branch 4
 | Zone 2 | Branch 5
 | Zone 2 | Branch 6
 | Zone 2 | Branch 7
 | Zone 2 | Branch 8
 | Zone 2 | Branch 9
 | Zone 2 | Branch 10
 | Zone 2 | Branch 11
 | Zone | Branch
 | Zone 3 | Branch 1
 | Zone 3 | Branch 2
 | Zone 3 | Branch 3
 | Zone 3 | Branch 4
 | Zone 3 | Branch 5
 | Zone 3 | Branch 6
 | Zone 3 | Branch 7
 | Zone 3 | Branch 8
 | Zone 3 | Branch 9
 | Zone 3 | Branch 10
 | Zone 3 | Branch 11
Spreadsheet: 686615d1594720682-plan-vs-actual-for-asset-inventory-activity-pm-inventory-asset
Sheet: Sheet1

Monthly target | 2155
Working Days | 20
Daily Target | 32
Category |  | Actual | Percentage
Notebook High-End | 120
Notebook Standard | 555
PC High-End | 57
PC Standard | 1423
Grand Total |  |  |  |  | August 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September 2020
 |  |  |  |  | Week I |  |  |  |  | Week II |  |  |  |  | Week III |  |  |  |  | Week IV |  |  |  |  | Week I |  |  |  |  | Week II
 |  |  |  |  | 2020-08-03 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | 2020-08-31 00:00:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-07 00:00:00 | 2020-09-08 00:00:00 | 2020-09-09 00:00:00 | 2020-09-10 00:00:00 | 2020-09-11 00:00:00
 |  |  |  | Category | Office 1 |  |  | Office 2
 |  |  |  | Notebook High-End
 |  |  |  | Notebook Standard
 |  |  |  | PC High-End
 |  |  |  | PC Standard
Spreadsheet: 73656d1274284777-match-value-that-is-closest-in-value-and-also-fulfills-other-criteria-problem1
Sheet: problem

STAGE 1
 | Items to be matched | items to match with |  | Desired outcome
 | Size in Mil$ | Size in Mil$ | PE Firm | Match
item 1 |  | 77.027 | 0
item 2 | 98.741 |  | 0
item 3 |  | 99.05 | 1
item 4 |  | 833.354 | 0
item 5 |  | 98.74 | 1
I want to match [NAME] to the item that is closest in value and is also a PE Firm (PE Firm = 1) and return the result to column E.
In this case for item 2, the closest in value is item 3. However, 3 is not a PE Firm.
I would already be happy if someone could tell me how to do this. See below if you want to see my whole challenge ;)
You might wonder, why don’t I just delete all those Items that are not PE firms. For that see stage 2 below
STAGE 2
 | Items to be matched | items to match with |  | Items to be matched | items to match with | Desired outcome
 | Size in Mil$ | Size in Mil$ | PE Firm | Industry code | Industry code | Match
item 1 |  | 77.027 | 1 | 7564 |  | # N/A
item 2 | 98.741 |  | 0 |  | 7833 | item 1
item 3 |  | 99.05 | 0 | 3842 |  | # N/A
item 4 |  | 110 | 0 | 3321 |  | # N/A
item 5 |  | 103 | 1 | 6522 |  | # N/A
I want to match [NAME] to the item that is closest in value, is a PE firm and has the same first letter for the Industry Code
So that would be item 1.
Thanks in advance, please let me know what might be unclear.
Spreadsheet: 741766d1627320323-pulling-working-days-from-a-range-pulling-work-days-from-a-range
Sheet: Table1

Date From | Date To | Custom
2021-07-19 00:00:00 | 2021-07-19 00:00:00 | 2021-07-19 00:00:00
2021-07-14 00:00:00 | 2021-07-16 00:00:00 | 2021-07-14 00:00:00
2021-07-14 00:00:00 | 2021-07-16 00:00:00 | 2021-07-15 00:00:00
2021-07-14 00:00:00 | 2021-07-16 00:00:00 | 2021-07-16 00:00:00
2021-07-22 00:00:00 | 2021-07-27 00:00:00 | 2021-07-22 00:00:00
2021-07-22 00:00:00 | 2021-07-27 00:00:00 | 2021-07-23 00:00:00
2021-07-22 00:00:00 | 2021-07-27 00:00:00 | 2021-07-26 00:00:00
2021-07-22 00:00:00 | 2021-07-27 00:00:00 | 2021-07-27 00:00:00
Spreadsheet: 119072d1314187665-index-and-match-function-rank
Sheet: Final Result

accno | Position-1 | Position-2 | Position-3 | Position-4 | Position-5 | Position-6 | Position-7 | Position-8
J0000033 | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Exhaust.jpg | Cat.jpg | Alternator.jpg | Coil Spring.jpg | Wheel Bearing.jpg
j0000034 | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Exhaust.jpg | Cat.jpg | Starter.jpg | Shock Absorber.jpg | Coil Spring.jpg
J7000067 | Engine Oil.jpg | Clutch & DMF.jpg | Radiator.jpg | Exhaust.jpg | Alternator.jpg | Wheel Bearing.jpg
J7000099 | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Alternator.jpg | Starter.jpg | Wheel Bearing.jpg | Turbo.jpg
J7001200 | Engine Oil.jpg | Clutch & DMF.jpg | Exhaust.jpg | Starter.jpg | Coil Spring.jpg | Wheel Bearing.jpg
J7000104 | Engine Oil.jpg | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Shock Absorber.jpg | Coil Spring.jpg
Sample Below
accno | Position-1 | Position-2 | Position-3 | Position-4 | Position-5 | Position-6 | Position-7 | Position-8
J0000033 | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Exhaust.jpg | Cat.jpg | Alternator.jpg | Coil Spring.jpg | Wheel Bearing.jpg
j0000034 | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Exhaust.jpg | Cat.jpg | Starter.jpg | Shock Absorber.jpg | Coil Spring.jpg
J7000067 | Engine Oil.jpg | Clutch & DMF.jpg | Radiator.jpg | Exhaust.jpg | Alternator.jpg | Wheel Bearing.jpg
J7000099 | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Alternator.jpg | Starter.jpg | Wheel Bearing.jpg | Turbo.jpg
J7001200 | Engine Oil.jpg | Clutch & DMF.jpg | Exhaust.jpg | Starter.jpg | Coil Spring.jpg | Wheel Bearing.jpg
J7000104 | Engine Oil.jpg | Timing Belt Kit.jpg | Clutch & DMF.jpg | Radiator.jpg | Shock Absorber.jpg | Coil Spring.jpg
Spreadsheet: 864328d1711545709-how-can-i-enhance-this-sumproduct-formula-to-only-counts-cells-greater-than-zero-sumproduct-question
Sheet: NON-WORKING Version

Year | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025
Month | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00
Users | 25 | 28 | 26 | 21 | 29 |  | 33 |  |  | 27 | 27 | 25 | 23 | 22 | 27 | 29 | 31
Hours | 501 | 608 | 612 | 574 | 773 |  | 768 |  |  | 639 | 622 | 611 | 634 | 620 | 799 | 632 | 733
Avg of Monthly Hours
Year Selected ([NAME]) | 2024
Spreadsheet: 884295d1733390534-reference-match-when-data-doesnt-match-exactly-example
Sheet: Working file

 | InvoiceIteT.ProductAccountReference |  | Ref
 | ABC000
 | TJA003S
 | TJA016S
 | TJA020S
 | TJA003S
 | TFB254S
 | TFB694S
 | ABC000
 | TJA003S
 | TJA016S
 | TJA019S
 | TJA016S
 | TFB694S
 | TFB253S
 | TJA004S
 | TJA003S
 | TJA009
 | S1
 | M
Spreadsheet: 777151d1650202126-color-certain-values-color11
Sheet: Sheet1

Date | Name | Surname | ID
2022-04-17 00:00:00 | Jake | Surname1 | 10001
2022-04-17 00:00:00 | [NAME] | Surname2 | 10002
2022-04-17 00:00:00 | [NAME] | Surname3 | 10003
2022-04-17 00:00:00 | [NAME] | Surname4 | 10004
2022-04-17 00:00:00 | [NAME] | Surname5 | 10005
2022-04-17 00:00:00 | [NAME] | Surname6 | 10006
2022-04-17 00:00:00 | [NAME] | Surname7 | 10007
2022-04-17 00:00:00 | Justin | Surname8 | 10008
2022-04-17 00:00:00 | Parker | Surname9 | 10009
2022-04-17 00:00:00 | [NAME] | Surname10 | 10010
2022-04-17 00:00:00 | [NAME] | Surname11 | 10011
2022-04-17 00:00:00 | [NAME] | Surname12 | 10012
2022-04-17 00:00:00 | Martin | Surname13 | 10013
2022-04-17 00:00:00 | [NAME] | Surname14 | 10014
2022-04-17 00:00:00 | [NAME] | Surname15 | 10015
2022-04-17 00:00:00 | [NAME] | Surname16 | 10016
Spreadsheet: 545150d1509299981-if-formula-error-sample-workbook-for-if-formula-error
Sheet: Sheet1

 | Name | Category | Period |  |  | Count | Name | Category | Period | All
 | B | ABC | Full Year | 1
 | B | CED | Full Year | 2
 | B | DEF | Full Year | 3
 | B | GHI | Full Year | 4
 | B | JKL | Full Year | 5
 | B | MNO | Full Year | 6
 | B | PQR | Full Year | 7
 | A | ABC | Full Year | 8
 | A | CED | Full Year | 9
 | A | DEF | Full Year | 10
 | A | GHI | Full Year | 11
 | A | JKL | Full Year | 12
 | A | MNO | Full Year | 13
 | A | PQR | Full Year | 14
 | C | ABC | Full Year | 15
 | C | CED | Full Year | 16
 | C | DEF | Full Year | 17
 | C | GHI | Full Year | 18
 | C | JKL | Full Year | 19
 | C | MNO | Full Year | 20
 | C | PQR | Full Year | 21
 | TOTAL
Spreadsheet: 537ba0cc-b5ab-4434-981e-6fe92a5db149
Sheet: NON-RESIDENTIAL 

 |  |  |  |  |  |  |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  |  |  |  |  |  |  | SEPTEMBER 2014 NON-RESIDENTIAL DATA
APPLICATION TYPE |  | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  |  | PERMIT NUMBER |  |  | SQUARE FOOTAGE | VALUATION | CONTRACTOR
 | Street Number | Street Name | Suffix | [NAME] | Unit | Block | Lot | Tr | Permit Year | Permit number | STATUS | YMMDD
NEW COMMERCIAL
NCOM | 2211 | UNSER | BLVD | SE | PMP | A | 5B |  | 14 | 6511 | PC | 140930 | 4547 | 600000 | MEDLOCK COMMERCIAL CONTRACTORS | RETAIL/CONVENIENT STORE
NEW OFFICE/INSTITUTION
OFIN | 4500 | SUNDT | RD | NE | IPW |  |  |  | 14 | 6290 | PC | 140919 | 42405 | 4441500 | RACHEL MATTHEW HOMES | ACADEMICS
OFIN | 1790 | GRANDE | BLVD | SE | GN |  |  |  | 14 | 6314 | PC | 140922 | 6145 | 650000 | LATITUDE LLC | MEDICAL OFFICE
COMMERCIAL REMODEL/INTERIOR TENANT IMPROVEMENT
RCOM | 4321 | FULCRUM | WY | NE | CCIEH | A | 1A1A |  | 14 | 6003 | AP | 140909 | 5965 | 80000 | INSIGHT CONSTRUCTION LLC
RCOM | 504 | NM HIGHWAY 528 |  | NE | IPE | C | 31A |  | 14 | 6526 | PC | 140930 | 7282 | 150000 | [NAME] CORRALES
RCOM | 5501 | OBREGON | RD | NE | U17 | 140 | 8A |  | 14 | 6291 | AP | 140919 | 56000 | 15412 | GOODRICH ROOFING CO INC
RCOM | 4300 | RIDGECREST | DR | SE | RRMP | A |  |  | 14 | 5847 | AP | 140903 | 6080 | 75000 | MCDAVID CONSTRUCTION INC.
RCOM | 2345 | SOUTHERN | BLVD | SE | WH2 |  |  |  | 14 | 6219 | AP | 140917 | 1190 | 15000 | JARA CONSTRUCTION CO
RCOM | 1908 | WELLSPRING | AVE | SE |  |  |  |  | 14 | 6149 | AP | 140916 | 1428 | 140672 | TANGLEWOOD CONSTRUCTION
RCOM | 1050 | 33RD | ST | NE | U13 | 85 | 1 |  | 14 | 5833 | AP | 140902 | 50 | 0 | IGUANA DEVELOPMENT COMPANY
TELECOMMUNICATION
TCOM | 5101 | SANTA FE HILLS | BLVD | NE | EH |  |  |  | 14 | 5841 | PC | 140903 | 600 | 10000 | OUT TO BID
Spreadsheet: 76130d1276695134-two-columns-count-of-data-list_help
Sheet: Sheet1

COUNTY | UNIT |  | SUMMARY
[NAME] | UNIT 1 |  | [NAME] | 3
[NAME] | UNIT 2 |  | LANCASHIRE | 6
[NAME] | UNIT 3
[NAME] | UNIT 3
LANCASHIRE | UNIT A
LANCASHIRE | UNIT A
LANCASHIRE | UNIT A
LANCASHIRE | UNIT B
LANCASHIRE | UNIT C
LANCASHIRE | UNIT C
LANCASHIRE | UNIT D
LANCASHIRE | UNIT E
LANCASHIRE | UNIT F
Spreadsheet: 6167eb18-c394-46b1-9fef-c86d67af4a17
Sheet: Sheet1

Table S5. Data statistics of the two small RNA libraries (SP1 and SP2). | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Class | Total Reads | High Qulity Reads | Total Distinct Reads | Redundancy(%)a | Perfect Matchedb Genomec | % | Total of Perfect | %
SP1 | 33389568 | 32876012 | 4827798 | 85.3151349378994 | 572165 | 11.85146934482346 | 7501543 | 22.81767934626621
SP2 | 22249434 | 21822050 | 3349147 | 84.65246390691983 | 522262 | 15.59388106882141 | 8447486 | 38.71
Total | 55639002 | 54698062 | 7460784 | 86.36005787554228 | 916159 | 12.27966122595159 | 15949029 | 29.15830729066781
a Redundancy=100-(Total Distinct Clean Reads/Total Clean Reads x 100)
b using soap2.20 aligner: soap.huge -M 0 -r 2
c Schistosoma japonicum Genome were downlaod from Chinese National Human Genome Center(http://lifecenter.sgst.cn/schistosoma/cn/schistosomaCnIndexPage.do)
Spreadsheet: 002c2a29-68f7-4398-9579-ce20e3f237a7
Sheet: Sheet1

FEBRUARY | Units are no longer allowed to bring their own firewood to camp | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 2014-09-15 00:00:00
CHARTS ARE UPDATED DAILY. FOR UP TO THE MINUTE AVAILABILITY CALL (716) 891-4073 OR E-MAIL [EMAIL]
SCHOELLKOPF |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | Code | FEE | FEB 6 - 8 | FEB 13 - 15 | FEB 20 - 22 | FEB 27 - MAR 1
District/Council Events
**Phillip (Lower) | 8 | S,W,E | 48
**Schoellkopf (Upper) | 12 | S,W,E | 72
Schwartz | 14 | S,W | 70 |  |  |  | T58 W
Score | 18 | S,W,E | 108
**Self | 12 | S,W,E | 72
Sikes | 16 | S,W,E, | 96
**Toulmin | 18 | S,W,E | 108
Lean-To's
**Art Wood (Flats) | 12 | W | 48 |  |  | T931 W
**[NAME] (Northwoods) | 12 | W | 48
**Seibel (Northwoods) | 12 | W | 48
**Faso (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
Troop 7 Shelter | 20 | S,W,E | 96
**Szymkowiak lean-to | 12 | W, E | 72
Tenting    $2 per person per night
Tenting    $2 per person per night
Tenting    $2 per person per night
**SEASONAL [NAME] MAY BE CLOSED FOR VEHICLE TRAFFIC, PLEASE CONTACT THE RANGER AT [PHONE]
SCOUTHAVEN |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | CODE | FEE | FEB 6 - 8 | FEB 13 - 15 | FEB 20 - 22 | FEB 27 - MAR 1
District/Council Events
[NAME] | 20 | S,W,E | 120
Loegler 1 | 20 | C,S,W,E | 120
Loegler 2 | 20 | C,S,W,E | 120 |  |  |  | T506 1/4W
[NAME] | 30 | C,S,W,E | 180 |  |  | P816 W | P583 W
Lean-To's
#1 Eagle | 12 | W | 48
#2 Whitetail | 12 | W | 48
#3 Dziedzic | 12 | W | 48
Moose | 10 | W | 40
Boss | 12 | W | 48
Tenting    $2 per person per night
Day Hike  $2 per person
[NAME] |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | CODE | FEE | FEB 6 - 8 | FEB 13 - 15 | FEB 20 - 22 | FEB 27 - MAR 1
District/Council Events |  |  |  |  | OA WINTER FELLOWSHIP
Cabin #1 | 24 | S,W,E | 144 |  | OA
Cabin #2 | 24 | S,W,E | 144
Leader's Lodge | 28 | S,W,E | 168 |  | OA
[NAME] | 30 | C,S,W,E | 180 |  | T824
Lean-To's
Stone Lean-To | 6 | [NAME] | 24
Troop 107 Shelter | 8 | W | 30
Ganosote Lean-To | 12 | W | 48
[NAME] | 12 | W | 48
[NAME] To | 12 | W | 48
Tenting    $2 per person per night
Tenting    $2 per person per night
Day Hike  $2 per person
Code: S=Cooking Stove; W=Wood Heating Stove; E=Electricity; C=Co-Ed Ready
Firewood is $50.00 per 1/2 face cord.
Spreadsheet: 878882d1726191223-i-want-criteria-base-index-with-count-function-criteria-base-index
Sheet: Sheet1

 | Index | [NAME] |  |  |  |  |  | Criteria
 | a | small | small |  | find with formula | find with formula |  | small
 | b | big | big |  |  |  |  | big
 | c | XL | XL |  |  |  |  | large
 | a | XXL | XXL |  | Result
 | c | big | big |  |  | 2
 | b | XXXL | XXXL |  | b | 2
 | a | large | large |  | c | 2
 | c | small | small
 | b | large | large
Spreadsheet: 2585d31f-cb75-4ebd-8111-59624db35525
Sheet: Wool

 | WOOL
 | Name of Co-Operative | File no. | Product Classification
1 | Ngcengane Shearing Shed | 6 | P1160
2 | Zinzani Wool Growers Co-operative | 35 | P1160
3 | [NAME] | 46 | P1160
4 | Ncipizeni-Corana Wool Growers | 115 | P1160
5 | Ncedabantu Woolgrowers Co-op | 148 | P1160
6 | Masufuye Agricultural Co-operative Ltd | 173 | P1160
 | COTTON
1 | [NAME] | 40 | [NAME]
2 | Nyosana Cotton Primary Co-op | 92 | [NAME]
Spreadsheet: bd8fd385-3ae8-4805-b9b8-51550f7bb44e
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: |  |  | 2013-08-30 09:23:10.650000
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.875 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.75 | 101.824 | 101.699 | 101.574 | 101.199
4.625 | 101.106 | 100.981 | 100.856 | 100.481 |  | Note: | Refer To Price [NAME]
4.5 | 100.215 | 100.09 | 99.965 | 99.59 |  |  | For all Price Adjs
4.375 | 99.284 | 99.159 | 99.034 | 98.409
4.25 | 98.659 | 98.534 | 98.409 | 97.784
4.125 | 97.869 | 97.744 | 97.619 | 96.994
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.557 | 101.432 | 101.307 | 100.932
3.75 | 100.941 | 100.816 | 100.691 | 100.316
3.625 | 100.569 | 100.444 | 100.319 | 99.944
3.5 | 100.062 | 99.937 | 99.812 | 99.187
3.375 | 99.319 | 99.194 | 99.069 | 98.444
3.25 | 98.588 | 98.463 | 98.338 | 97.713 |  | Minimum loan amount:
3.125 | 97.647 | 97.522 | 97.397 | 96.772 |  | 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 | 2013-09-13 09:23:10.650000
30 DAY | 2013-09-28 09:23:10.650000
45 DAY | 2013-10-13 09:23:10.650000
60 DAY | 2013-10-28 09:23:10.650000
90 DAY | 2013-11-27 09:23:10.650000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 882806d1731279690-distribute-students-evenly-and-only-once-in-repeating-sessions-according-to-wishes-wishes-reading-day-norwegianteacher-
Sheet: Round 4

12.10 - 12.50
name | grade | which wish |  | ID | name | grade | which wish