tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 820300d1678002681-sort-mixed-data-from-1-sheet-to-other-tabs-bol-a
Sheet: Jan

helper | Name | date | del/pic | AM/PM | BOL | on/off
 | atwell | 2023-01-12 00:00:00 | del | am | 40 | on
[NAME] | begli | 2023-01-13 00:00:00 | del | am | 41 | on
ell44941 | atwell | 2023-01-15 00:00:00 | pic | pm | 42 | on
[NAME] | maggie | 2023-01-15 00:00:00 | del | pm | 43 | off
gan44942 | meggan | 2023-01-16 00:00:00 | del | pm | 44 | off
ald44943 | [NAME] | 2023-01-17 00:00:00 | del | am | 45 | off
gan44944 | meggan | 2023-01-18 00:00:00 | del | pm | 46 | off
gli44946 | begli | 2023-01-20 00:00:00 | pic | am | 47 | on
ood44955 | atwood | 2023-01-29 00:00:00 | del | am | 48 | on
Spreadsheet: 194109d1353043846-associating-a-list-with-positve-and-negative-numbers-formula-divisionexample-1-
Sheet: Sheet1

 | (vs Damian B)
 | (vs [NAME])
 | (vs [NAME])
 | (vs [NAME]) |  |  | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7
 | (vs [NAME] E)
 | (vs [NAME])
 | (vs [NAME]) |  |  | VERSUS
 | (vs [NAME] D) |  |  | 1 | 2 | 2 | 1 | 1
 | (vs [NAME]) |  |  | Damian B | Brett B | [NAME] D | [NAME] | Keith E
 | (vs Brett B)
 |  |  |  | RESULT (Positve number = win   Negative number = loss)
1 | [NAME] |  |  | 20 | -5 | 14.3 | 40 | -20
 |  | W-L-T
 |  | 2-1-0 |  | Won |  |  | Won | Loss
Spreadsheet: 3de43201-6de9-4fad-b58d-998492c71f46
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
SEKTOR PENILAIAN DAN PEPERIKSAAN
MAKLUMAT PENERIMA BAYARAN PERSEORANGAN/INDIVIDU
No. Kad  Pengenalan | 0 |  |  | No. [NAME]
[NAME] | 211
[NAME] | 560101
Nama | 0
[NAME] |  | Encik/Puan/Cik
Alamat
Poskod
[NAME]
No Telefon | 0 | Rumah/Pejabat |  | [NAME] |  |  | [NAME]
No. [NAME] | 0
No. Faks | 0 | [NAME] (Wajib diisi)
Emel | 0 |  |  | [NAME] atau Pejabat/Sekolah (Wajib diisi)
Jawatan | 0 |  |  | PPPS/PPLD (Lain-lain nyatakan)
No. Gaji | 0 |  |  | [NAME] |  |  | Cth : P1 T3
Kod Bank |  |  |  | Akaun Bank | 0
[NAME] dan Alamat Bank
 |  |  |  | Cth : Public Bank, [NAME], Pulau Pinang
Status |  | Bujang/Kahwin/Janda/ Duda
Bangsa |  | Melayu/Cina/India (Lain-lain nyatakan)
Jantina |  | Lelaki/Perempuan
Warga |  | [NAME]
Agama |  | Islam/Kristian/Budha/Hindu (Lain-lain nyatakan)
[NAME]
[NAME] | 0 |  |  |  |  | [NAME]
Bulan Naik |  | Bulan Kenaikan Gaji
[NAME] |  | Tarikh Pelantikan |  | Tarikh [NAME]
Kumpulan |  | Profesional/Sokongan (Lain-lain nyatakan)
Pencen |  | [NAME] |  | No. KWSP
Tandatangan
Spreadsheet: 109762d1306524477-excel-2007-specific-date-compared-to-date-range-terrip
Sheet: Year 21

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 21:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
241 | January
242 | February
243 | March
244 | April
245 | May
246 | June
247 | July
248 | August
249 | September
250 | October
251 | November
252 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 581581d1531389891-ranking-based-on-3-columns-values-book1
Sheet: Sheet1

Name | P | S | G
Player 1 | 3 | 3 | 2
Player 3 | 3 | 2 | 3
Player 4 | 2 | 2 | 1
Player 6 | 2 | 1 | 1
Player 7 | 1 | 2 | 3
Player 5 | 2 | 2 | 2
Player 2 | 3 | 2 | 1
Spreadsheet: 95103d1294782781-trying-to-match-two-conditions-and-find-the-correct-value-on-that-row-copy-of-example
Sheet: Sheet1

Truck | States | [NAME] |  |  |  |  | Sum of Miles
Apple Truck | California | 3000 |  |  |  |  | Truck | States | Total
Apple Truck | Nevada | 600 |  |  |  |  | Apple Truck | California | 3000
Pear Truck | California | 500 |  |  |  |  |  | Nevada | 600
Pear Truck | Nevada | 100 |  |  |  |  | Apple Truck Total |  | 3600
Grape Truck | Arizona | 1600 |  |  |  |  | Grape Truck | Arizona | 1600
Grape Truck | California | 1200 |  |  |  |  |  | California | 1200
Grape Truck | Nevada | 800 |  |  |  |  |  | Nevada | 800
 |  |  |  |  |  |  | Grape Truck Total |  | 3600
 |  |  |  |  |  |  | Pear Truck | California | 500
 |  |  |  |  |  |  |  | Nevada | 100
 |  |  |  |  |  |  | Pear Truck Total |  | 600
 |  |  |  |  |  |  | Grand Total |  | 7800
Spreadsheet: 91784d1291430353-a-lookup-function-to-search-through-array-and-return-row-number-test
Sheet: CYCLES

 |  | 2010 |  |  |  |  |  |  |  |  |  | 2020
New Year's Day
[NAME]
Presidents' Day
Good Friday
Easter
Memorial Day
Independence Day
Labor Day
Columbus Day
Thanksgiving Day
Christmas Day
New Year's - Next year
Election Day
 |  | M |  |  |  | M |  |  |  | M
Election Cycles |  | Election | 2008 |  |  |  |  |  |  |  |  | 2044 | 2048
 |  | Post-Election | 2009 |  |  |  |  |  |  |  |  | 2045 | 2049
 |  | Mid-Term | 2010 |  |  |  |  |  |  |  |  | 2046 | 2050
 |  | Pre-Election | 2011 |  |  |  |  |  |  |  |  | 2047 | 2051
212 Week Cycle - Start Dates |  | 2011-07-04 00:00:00
End Dates
40 Week Cycle - Start Dates |  | 2010-03-26 00:00:00
End Dates
Spreadsheet: 60867d1261456882-compile-worksheet-list-toll-free-test
Sheet: Attempted Calls

 | Attempted Calls
 | Phone Number | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00
 | 8001234567 | 125
 | 8661234567 | 885
 | 8771234567 | 26
Spreadsheet: 133573d1324483365-pickup-database-sheet-table-contain-base-on-dashboard-sheet-criteria-training-database
Sheet: Pivots

 | Column Labels
Row Labels | 2011-12-07 00:00:00 | 2011-12-14 00:00:00 | 2011-12-19 00:00:00 | 2011-12-20 00:00:00 | 2011-12-21 00:00:00 | 2011-12-27 00:00:00 | Grand Total
[NAME]
Billing Level 01
[NAME]
Billing Level 01
Denver Fernando
Billing Level 01
[NAME]
Billing Level 01
[NAME]
Billing Level 01
Grand Total
Spreadsheet: darrell_schoolcraft__7470__MARKET2001
Sheet: SEPT01

 |  |  |  | PERCENT
POI | SCHEDULED | ACTUAL | DEVIATION | [NAME]
71374 | 1485 | 1313
71393 | 1978 | 1449
71461 | 5956 | 5281
71463 | 3810 | 3228
71464 | 8820 | 7962 |  |  | DAS OUT OF SERVICE
71465 | 546 | 337
71466 | 427 | 481
TOTAL
Spreadsheet: 795676d1662835808-how-to-alternating-stack-a-range-into-a-column-alternatingly-per-stack-eight-column-into-one-hd
Sheet: Sheet1

Source data-1 |  |  |  |  |  |  |  | Source data-2 |  |  |  |  |  |  |  | Source data-3
A |  | B |  |  |  | C |  | I |  |  | J | K |  |  |  | A |  | B |  | TEST |  | C |  | A |  | B |  |  |  | C
D |  | E |  |  |  | F |  | L |  |  | M | N |  |  |  | D |  |  |  |  |  | F |  | D |  | E |  |  |  | F
 |  | G |  |  |  | H |  | O |  |  | P |  |  |  |  |  |  |  |  |  |  | H |  |  |  | TEST |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST
 | Desired Output
 |  | Source data-1 | Source data-2 | Source data-3 | Source data-4
Spreadsheet: 65367d1266039196-auto-generating-dynamic-tables-myob-counting
Sheet: MYOB Counting

 | Eftpos Receipts |  |  |  | Cash |  |  |  |  | Cash and Eftpos Total |  |  | 0
 | Receipt | Amount |  |  | Money | Count | Total
 | 1 |  |  |  | $100 Note |  | 0
 | 2 |  |  |  | $50 Note |  | 0
 | 3 |  |  |  | $20 Note |  | 0
 | 4 |  |  |  | $10 Note |  | 0
 | 5 |  |  |  | $5 Note |  | 0
 | 6 |  |  |  | $2 Coin |  | 0
 | 7 |  |  |  | $1 Coin |  | 0
 | 8 |  |  |  | 50 Cent Coin |  | 0
 | 9 |  |  |  | 20 Cent Coin |  | 0
 | 10 |  |  |  | 10 Cent Coin |  | 0
 | 11 |  |  |  | 5 Cent Coin |  | 0
 | 12 |  |  |  |  | Grand Total | 0 |  | Cash sales after Counting
 | 13 |  |  |  |  |  |  |  |  | Number | Amount
 | 14 |  |  |  |  |  |  |  |  | 1
 | 15 |  |  |  |  |  |  |  |  | 2
 | 16 |  |  |  |  |  |  |  |  | 3
 | 17
 | 18
 | 19 |  |  |  | Cash Tip: Remember To Remove $100 before Counting.
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26 |  |  | Eftpos Tip: Ensure All receipts counted are Eftpos Receipts, and not Cash Receipts.
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | Grand Total | 0
Spreadsheet: 04ba7799-8472-4599-a774-e6b4037055ce
Sheet: Sheet1

Unnamed: 0 | Vendor Name: | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Equipment Line:
 |  | (Brand, if different from above) |  |  | Enter equipment information for each model proposed below, or choose from Y/N drop-down menu options
 |  | Black and White Copiers |  |  |  |  |  | C O L O R  Copiers
Ref | Specification | B&W  45 PPM | B&W  55 PPM | B&W  65 PPM | B&W  75 PPM | B&W  85 PPM | B&W  135 PPM | B&W  55 PPM | B&W  65 PPM
Equipment Features
1 | Proposed Model:
2 | Most current in production? |  |  |  |  |  |  |  |  |  |  |  | yes
3 | Actual PPM B&W: |  |  |  |  |  |  |  |  |  |  |  | no
4 | Actual PPM Color: |  |  |  |  |  |  |  |  |  |  |  | see explanation
5 | USA Introduction Date:
6 | Maximum Monthly Page Volume:
7 | Recommended Real World  Monthly Page Volume: |  |  |  |  |  |  |  |  |  |  |  | yes, standard feature
8 | [NAME] (every X pages): |  |  |  |  |  |  |  |  |  |  |  | yes, but optional accessory
9 | [NAME] Yield: |  |  |  |  |  |  |  |  |  |  |  | not available for model
10 | Dimensions W" x D" x H" (w/accessories as specified): |  |  |  |  |  |  |  |  |  |  |  | see explanation
11 | Installation Space Required W" x D" (w/accessories):
12 | Electrical Requirements:
13 | Standard Hard Drive Capacity:
14 | Maximum Capacity Hard Drive:
15 | Standard RAM:
16 | Maximum RAM:
17 | Operable as “walk-up” [NAME] even if disconnected from the network?
18 | Print from any networked PC?
19 | Faxing capability?
20 | Multi-position stapling?
21 | Offset stacking/collating?
22 | Reduce/enlarge 25% to 400%?
23 | Saddle stitching & hole punching finishers?
24 | Standard Paper Capacity (letter):
25 | Standard Paper Capacity (legal):
26 | Standard Paper Capacity (ledger):
27 | Maximum Paper Capacity (letter):
28 | Maximum Paper Capacity (legal):
29 | Maximum Paper Capacity (ledger):
30 | Output Capacity:
31 | [NAME]?
32 | Scanning Resolution (BW/Color):
33 | Maximum # Secure/PIN mailboxes for delayed printing:
34 | Maximum  # addresses in email/fax phonebook:
35 | Maximum # cost center codes:
36 | User interface standard across all models?
37 | Tab & slip sheet capable?
38 | Alphanumeric page numbering ([NAME])?
Fleet Management System
39 | Device/fleet management system?
40 | Automated meter readings?
41 | Remote programming of copier functions?
42 | Uploading & editing of phonebooks, mailboxes, cost centers?
43 | Standard  & custom production reports?
44 | Automated supply ordering?
45 | Submission of service calls?
Network Requirments
46 | Connectivity to WIN XP (SP2) - WIN 7 Active Directory & IBM System i5?
47 | TCP/IP supported?
48 | 10/100/1000MB Ethernet Connection?
49 | JPG, PDF & TIFF formats supported?
50 | Simple Mail Transfer Protocol (SMTP) supported?
51 | Server Message Block (SMB) supported?
Spreadsheet: 827058d1682450372-unable-to-get-countif-formula-to-calculate-two-columns-vehicle-inventory-3
Sheet: Sheet1

DISTRICT / SITE | PARKING SLOT # | VIN | MAKE | MODEL
1/1 | 120 | JH4KA3170LC006787 | Chevrolet | 2.6
1/4 | 11 | [NAME] | Ford | Type III
1/1 | 12 | 2C4GM68475R667819 | Dodge | ORV
1/3 | 65 | 1P4GH44R0RX359386 | Chevrolet | 2.1
1/3 | 12 | 1P4GH44R0RX359386 | Toyota | ORV II
1/1 | 1 | 1GBJ7D1B4BV132373 | Ford | Type III
1/4 | 66 | JH4KA2640GC004861 | Toyota | ORV II
1/2 | 41 | JH4CC2640NC004693 | Toyota | ORV II
 | Chevrolet | Toyota ORV II | Dodge | Ford | Ford Type III
Site 1
Site 2
Site 3
Site 4
Spreadsheet: 145233d1331398447-northwind-the-spreadsheet-northwind-the-ss
Sheet: Suppliers

ID | Company | Last Name | First Name | E-mail Address | Job Title | Business Phone | Home Phone | [NAME] | Fax Number | Address | City | State/Province | ZIP/Postal Code | Country/Region | Web Page | Notes | Attachments
1 | Supplier A | Andersen | [NAME] |  | Sales Manager |  |  |  |  |  |  |  |  |  |  |  | 0
2 | Supplier B | Weiler | Cornelia |  | Sales Manager |  |  |  |  |  |  |  |  |  |  |  | 0
3 | Supplier C | [NAME] | [NAME] |  | Sales Representative |  |  |  |  |  |  |  |  |  |  |  | 0
4 | Supplier D | Sato | Naoki |  | Marketing Manager |  |  |  |  |  |  |  |  |  |  |  | 0
5 | Supplier E | Hernandez-Echevarria | Amaya |  | Sales Manager |  |  |  |  |  |  |  |  |  |  |  | 0
6 | Supplier F | Hayakawa | Satomi |  | Marketing Assistant |  |  |  |  |  |  |  |  |  |  |  | 0
7 | Supplier G | [NAME] | Stuart |  | Marketing Manager |  |  |  |  |  |  |  |  |  |  |  | 0
8 | Supplier H | Dunton | [NAME] |  | Sales Representative |  |  |  |  |  |  |  |  |  |  |  | 0
9 | Supplier I | Sandberg | Mikael |  | Sales Manager |  |  |  |  |  |  |  |  |  |  |  | 0
10 | Supplier J | Sousa | [NAME] |  | Sales Manager |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 599107d1542861221-retail-inventory-calculating-multiple-items-in-a-sale-copy-of-retail-inventory-23102018-markp2010-
Sheet: Orders_and_Inventory

INVENTORY AND SALES MANAGER - ORDERS AND INVENTORY |  |  |  |  |  |  |  |  | Products | Report | Terms
 | CURRENT INVENTORY LEVEL |  |  |  | CHOOSE PRODUCT |  | PRODUCTS WHERE CURRENT INVENTORY <= RE-ORDER POINT
 |  |  |  |  | P3 |  | Product | Current Inventory | Re-order Point | Pending Purchase Quantity
 |  |  |  |  |  |  |  |  |  |  | 27
 | PRODUCTS AVAILABLE | QUANTITY | PRODUCTS TO RE-ORDER | CURRENT INVENTORY
 | ORDER ITEMS THAT CANNOT BE FULFILLED* |  |  | RE-ORDER POINT
 |  |  |  | PENDING PURCHASE QUANTITY
 |  |  |  | PENDING SALES QUANTITY
 | CURRENT | FUTURE
 | *where Sale quantity is higher than Inventory available - highlighted with red border in the table below
ENTER YOUR ORDER DETAILS |  |  |  |  |  |  |  | these  columns are automatically calculated
Order Number | Order Date | Order Type | Expected Date | Partner | Product Name | Quantity | Unit Price | Amount | Product Category | YearMonth | Inventory Availability
100 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P1 | 10 | 5.99
101 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P2 | 10 | 5.68
102 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P3 | 3 | 5.09
103 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P4 | 10 | 5.09
104 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P5 | 10 | 5.23
105 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P6 | 10 | 4.97
106 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P7 | 10 | 5.3
107 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P8 | 10 | 4.76
108 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P9 | 10 | 4.49
109 | 2018-10-13 00:00:00 | Purchase | 2018-10-15 00:00:00 | SI | P10 | 10 | 4.49
Sale 1 | 2018-10-13 00:00:00 | Sale | 2018-10-15 00:00:00 | SI | Pack 1 | 2 | 50
Sale 2 | 2018-10-13 00:00:00 | Sale | 2018-10-15 00:00:00 | SI | Pack 2 | 2 | 70
110 | 2018-11-19 00:00:00 | Purchase | 2018-11-19 00:00:00 | SI | P3 | 5 | 5.09
Spreadsheet: 847447d1698366480-athletics-spread-sheet-find-winner-athletics-spreadsheet-attempt-3
Sheet: Age Champ

 | AGE CHAMPS
 | STUDENT NAME | AGE GROUP | GENDER | HOUSE | POINTS
Winner | =('8 Boys'!R10) " and "('8 Boys'!R11) | [NAME] | Boy
[NAME] Up | =('8 Boys'!R16) " and "('8 Boys'!R17)
 |  | [NAME] | GIRL
 |  | 9YRS | BOY
 |  | 9YRS | GIRL
 |  | 10YRS | BOY
 |  | 10YRS | GIRL
 |  | 11YRS | BOY
 |  | 11YRS | GIRL
 |  | 12YRS | BOY
 |  | 12YRS | GIRL
Spreadsheet: 271688d1382021994-need-formula-to-find-the-match-then-copy-and-paster-number-needformula1
Sheet: Sheet1

xyz | xyz | xyz | xyz | xyz | Part | xyz | xyz | xyz | xyz | xyz | Qty1 | xyz | xyz | cc | ac | xyz | xyz | xyz | xyz | xyz | xyz | Num1 | Qty1 | Ds | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | Com | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz | xyz
1 |  |  |  |  | Hon9 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  | Hon8 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 1
3 |  |  |  |  | Hon1 |  |  |  |  |  | a |  |  |  |  |  |  |  |  |  |  |  | 1 | <=== cell W4 should be 293
4 |  |  |  |  | Hon1 |  |  |  |  |  | b |  |  |  |  |  |  |  |  |  |  |  | 6 | <=== cell [NAME] should be 283
5 |  |  |  |  | Hon11 |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 1
6 |  |  |  |  | Hon2 |  |  |  |  |  | c |  |  |  |  |  |  |  |  |  |  |  | 1 | <=== cell W7 should be 75.69
7 |  |  |  |  | Hon4 |  |  |  |  |  | e |  |  |  |  |  |  |  |  |  |  |  | 1 | <=== cell [NAME] should be 308
8 |  |  |  |  | Hon4 |  |  |  |  |  | e |  |  |  |  |  |  |  |  |  |  |  | 12 | <=== cell W9 should be 291
9 |  |  |  |  | Hon3 |  |  |  |  |  | d |  |  |  |  |  |  |  |  |  |  |  | 4 | <=== cell W10 should be 125
10 |  |  |  |  | Hon16 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1
11 |  |  |  |  | Hon17 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1
12 |  |  |  |  | Hon6 |  |  |  |  |  | f |  |  |  |  |  |  |  |  |  |  |  | 3 | <=== cell W13 should be 56.25
13 |  |  |  |  | Hon6 |  |  |  |  |  | f |  |  |  |  |  |  |  |  |  |  |  | 11 | <=== cell W14 should be 43.31
14 |  |  |  |  | Hon20 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 1
15 |  |  |  |  | Hon7 |  |  |  |  |  | h |  |  |  |  |  |  |  |  |  |  |  | 1 | <=== cell [NAME] should be 1 |  |  |  |  |  |  |  |  |  | 1. How to make value at Cell W16 should be 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. I need new [NAME] how to find the matches between
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a_ part in ws1.column F and part in ws2.column G;
 |  |  |  |  | ws1=Sheet1; ws2=Sheet2:  1. need formula how to find the matches between part in ws1.column F and part in ws2.column G 2. if match then copy the number from ws2.column R and paste to ws1.column W base on the range of qty1 at ws1.column X and ws2.column M  3. need to match the column at 2 ws in red |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b_ part in ws1.column L and part in ws2.column H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/961857-need-formula-to-find-the-match-then-copy-and-paster-number.html
Spreadsheet: 34dcb850-6093-474c-aa92-886473f36f59
Sheet: Sheet1

Simple Tri-Reagent protocol write-up | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
samples:
1 | 1 ml Tri-Rgt to tissue - Homogenize -- On Ice
 |  | - Best to add 500 ul, homogenize, add remaining 500 ul and vortex well.
2 | ADD 100 ul BCP; |  | Shake 15 seconds.
 | Let sit at Room temp 15 minutes.
 | Centrifuge 16 minutes at MAX ( 10-13K) @ 4C
 | Pipette top supernatant into new tube.
3 | ADD 500 ul Isopropanol, mix well
 | Let sit 10 minutes at RT
 | Cent 9-12 minutes at MAX ( 10-13K), 4-25 C
 | Pipette or dump liquid leaving pellet
4 | ADD 1 ml 75% [NAME], vortex
 | Cent 6 min @ MAX, 4-25 C
 | Dump [NAME] leaving pellet - air dry approx 8 min.
5 | Dissolve pellet in Rnase-free Water ( ~ 50 ul  or less )
 | Place on ice
6 | Test by gel or Bioanalyzer to insure quality of RNA
SAMPLE |  |  | Nanodrop/Bioanalyzer
 |  |  | [ ng/ul]
Spreadsheet: 0791d3d9-ae77-4c49-bd54-8b3347914f8a
Sheet: 2009-10

Table N
Students Domiciled within the UK by Method of Study
Country/Region | Undergraduate |  |  | Graduate |  |  | Total
 | Full Time | Part Time | Total | Full Time | Part Time | Total
England
Greater London | 3428 | 120 |  | 1721 | 1417
South East | 2274 | 39 |  | 763 | 569
South West | 561 | 5 |  | 164 | 97
North and Yorkshire | 416 | 4 |  | 123 | 63
North West | 358 | 4 |  | 77 | 57
Midlands | 716 | 9 |  | 179 | 138
East Anglia | 352 | 7 |  | 114 | 95
Not Known | 15 | 1 |  | 18 | 10
Subtotal
Northern Ireland | 67 | 1 |  | 13 | 13
Scotland | 85 | 2 |  | 54 | 23
Wales | 175 | 6 |  | 49 | 26
Channel Isles and Isle of Man | 32 | 0 |  | 3 | 3
Not Known | 2 | 11 |  | 5 | 1
Total
This table is concerned with students whose domicile at the time of application is within the UK irrespective of nationality.
The sum of Tables N and O is equivalent to the total number of students attending UCL.
Spreadsheet: 65883d1266516333-how-to-filter-only-new-data-entries-worksheet-
Sheet: Sheet1

VESSEL ID# |  | Fisherman Name | [NAME] | Scallops | Fish | 2010-02-10 00:00:00
CG HULL # | ME#
**** | **** | [NAME]
**** | **** | [NAME]
**** | **** | [NAME]
**** | **** | Lavon S
**** | **** | Mark
**** | **** | [NAME]
**** | **** | Wayne
**** | **** | Timothy
**** | **** | [NAME]
**** | **** | [NAME]
**** | **** | [NAME]
Spreadsheet: 864382d1711569563-function-to-look-up-value-based-on-two-factors-book2
Sheet: Sheet1

Code | Color | Shape
 | Green
 | Green |  |  | 1
 | Green |  |  | 1
 | Green |  |  | 1
 | Green |  |  | 1
 | Green |  |  | 1
 | Green |  |  | 1
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | Red |  |  | 2
 | [NAME] | Circle |  | 3
 | [NAME] | Circle |  | 3
 | [NAME] | Circle |  | 3
 | [NAME] | Circle |  | 3
 | [NAME] | Circle |  | 3
 | [NAME] | Circle |  | 3
 | [NAME] | Circle |  | 3
 | [NAME] | Square |  | 4
 | [NAME] | Square |  | 4
 | [NAME] | Square |  | 4
 | [NAME] | Square |  | 4
 | [NAME] | Square |  | 4
 | [NAME] | Rhombus |  | 5
 | [NAME] | Rhombus |  | 5
 | [NAME] | Rhombus |  | 5
 | [NAME] | Rhombus |  | 5