tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 468076d1467125005-copying-row-formula-from-one-sheet-to-another-sheet-template
Sheet: Raw Data

[NAME] REPORT
Product: | Oxycodone ER tablets 80 mg
Lot No: | OXC3 38T4C-14-80XR
Lab Sample ID: | LAB-14-0529.00CS
Instrument ID: | LAB-053 ([NAME]), LAB-034 (Apr.15)
Book, Page# | IPC-OXY-01.6 P.34
Date: | Dec 17/14
Method: | Paddle, 100rpm, 37 ºC, 24hrs, by [NAME] @ 280nm
Medium | 0.1N HCl 900mL
 |  | Time (hr)/ Amount (mg) Dissolved
Time | Vessel-1 | Vessel-2 | Vessel-3 | Vessel-4 | Vessel-5 | Vessel-6
 | 0 | 0 | 0 | 0 | 0 | 0
1 | 24.185 | 21.304 | 23.135 | 25.188 | 23.388 | 23.296
2 | 33.393 | 30.315 | 33.711 | 35.092 | 33.816 | 33.11
3 | 41.339 | 37.801 | 41.701 | 43.71 | 42.607 | 41.055
4 | 47.868 | 44.003 | 47.993 | 50.634 | 49.046 | 48.188
5 | 55.353 | 50.062 | 54.808 | 56.054 | 55.535 | 54.225
6 | 59.674 | 54.683 | 59.576 | 61.177 | 60.44 | 58.725
7 | 63.47 | 58.923 | 64.382 | 65.659 | 65.167 | 63.054
8 | 65.657 | 61.672 | 66.826 | 68.941 | 68.231 | 66.468
9 | 68.928 | 64.513 | 68.626 | 71.976 | 70.357 | 69.068
10 | 71.53 | 67.057 | 71.565 | 72.291 | 73.046 | 70.461
11 | 73.517 | 69.053 | 73.561 | 76.218 | 74.422 | 73.675
12 | 74.914 | 71.335 | 75.599 | 77.153 | 76.309 | 74.928
13 | 76.643 | 72.579 | 76.349 | 78.187 | 77.236 | 76.242
14 | 77.291 | 73.313 | 77.208 | 79.573 | 77.974 | 77.69
15 | 79.223 | 74.287 | 77.362 | 80.209 | 78.075 | 77.722
16 | 78.712 | 74.826 | 78.144 | 80.99 | 78.973 | 78.564
17 | 78.843 | 75.228 | 79 | 80.504 | 78.242 | 78.627
18 | 79.852 | 75.775 | 78.242 | 80.804 | 79.133 | 78.98
19 | 79.804 | 75.852 | 78.929 | 80.763 | 78.822 | 78.564
20 | 79.556 | 75.922 | 78.07 | 80.092 | 78.172 | 77.5
21 | 79.276 | 75.974 | 78.349 | 81.296 | 79.423 | 80.65
22 | 79.037 | 76.827 | 78.996 | 81.965 | 79.991 | 80.526
23
24 | 79.69 | 77.242 | 78.782 | 80.665 | 79.036 | 75.965
 |  | Time (hr)/ Percentage Dissolved
Time[Hr] | Vessel-1 | Vessel-2 | Vessel-3 | Vessel-4 | Vessel-5 | Vessel-6 | [NAME]. | Std.[NAME]. | %RSD | Min | [NAME] |  | 40 | 0
0 |  |  |  |  |  |  |  |  | 0 |  |  |  | 40 | 110
1 |  |  |  |  |  |  |  |  |  |  |  |  | 120 | 0
2 |  |  |  |  |  |  |  |  |  |  |  |  | 120 | 110
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 |  |  |  |  |  |  |  |  |  |  | Percentage Withdrawed in each time point
Label Claim | 80 |  |  | Percentage Dissolved in each time point
Time | Medium volume(ml) | [NAME]) |  | V1 | V2 | V3 | V4 | V5 | V6 |  | V1 | V2 | V3 | V4 | V5 | V6
0min | 900 | 2
Hr 1 | 900
Hr 2
Hr 3
Hr 4
Hr 5
Hr 6
Hr 7
Hr 8
Hr 9
Hr 10
Hr 11
Hr 12
Hr 13
Hr 14
Hr 15
Hr 16
Hr 17
Hr 18
Hr 19
Hr 20
Hr 21
Hr 22
Hr 23
Hr 24
Spreadsheet: 848215d1698979193-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days
Sheet: Daily Pay Sheet

 | WEEK 1 - DAILY PAY COMPONENT DESCRIPTION
 | DATE :
 | DAY : | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
 | 1. NORMAL WORK PAYMENT
 | SHIFT CLASSIFICATION : |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 1 TOTAL
 | SHIFT ADD-ON :
 | SHIFT # :
 | NORMAL HOURS PAID :
 | VALUE (a) :
 | 2. ADDITIONAL PAYMENTS | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($)
 | Voluntary Overtime 150% :
 | Voluntary Overtime 200% :
 | Early-Late Penalty 15% :
 | Broken Shift Penalty 150% :
 | Broken Shift Penalty 200% :
 | High Capacity Allowance : | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  |  | N/A
 | Travelling Time : | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  |  | N/A
 | Public Holiday - Work :
 | Public Holiday :
 | RDOC-1st. 3 hrs :
 | RDOC-After 3 hrs :
 | ADOC-1st. 3 hrs :
 | ADOC-After 3 hrs :
 | Annual Leave : | N/A |  |  |  |  |  |  |  |  |  |  |  | N/A
 | [NAME] Loading : | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A
 | Sick Day :
 | Build-Up Time Payment : | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ADO Deduction (mins) :
 | VALUE (b) :
 | TOTAL VALUE  [c = (a+b)] :
 | WEEK 2 - DAILY PAY COMPONENT DESCRIPTION
 | DATE :
 | DAY : | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
 | 1. NORMAL WORK PAYMENT
 | SHIFT [NAME] : |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 2 TOTAL
 | SHIFT ADD-ON :
 | SHIFT # :
 | NORMAL HOURS PAID :
 | VALUE (d) :
 | 2. ADDITIONAL PAYMENTS | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($) | Hrs. Paid | Value ($)
 | Voluntary Overtime 150% :
 | Voluntary Overtime 200% :
 | Early-Late Penalty 15% :
 | Broken Shift Penalty 150% :
 | Broken Shift Penalty 200% :
 | High Capacity Allowance : | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  |  | N/A
 | Travelling Time : | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  |  | N/A
 | Public Holiday - Work :
 | Public Holiday :
 | RDOC-1st. 3 hrs :
 | RDOC-After 3 hrs :
 | ADOC-1st. 3 hrs :
 | ADOC-After 3 hrs :
 | Annual Leave : | N/A |  |  |  |  |  |  |  |  |  |  |  | N/A
 | [NAME] Loading : | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A |  | N/A
 | Sick Day
 | Build-Up Time Payment : | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | ADO Deduction (mins) :
 | VALUE (e) :
 | TOTAL VALUE [f = (d+e)] :
 | WEEK 1 SUMMARY |  |  |  | WEEK 2 SUMMARY :
 | Normal Work : |  |  |  | Normal Work :
 | Additional Payments : |  |  |  | Additional Payments :
Spreadsheet: 491000d1480248911-how-can-i-get-country-name-based-on-city-names-in-the-columns-country-name-based-on-city
Sheet: Sheet1

City1 | City2 | City3 | City4 | City5 | Country 1 | Country 2 | Country 3 | Country 4 | Country 5
Newyork
 |  |  | Mumbai
 | Toronto
Karachi
 |  |  |  | London
 |  | Sidney
 | Walington
Los Angeles
 | Mumbai |  | Bejing
London | Tokyo | Washington |  | Berlin
Bejing |  |  | Dublin
Spreadsheet: cara_semperger__1441__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (26)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | DAILY DEAL= 3HLH, 4MW LLH
 |  |  |  |  | Mid Columbia Paths
2001-11-26 00:00:00
 | HLH
 | DAY | 10 | PSPL(G)MIDC | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R | 10
 | DAY | 10 | FCPD(G)SYS-BPA(T)FCPD/PGE#10043HNF | X | FRANKLINCO | ENRON | PGE | X | COLSTRIP B/R | 10
 | DAY | 2 | [NAME] #96083HNF | X | GHPUD | ENRON | PGE | X | COLSTRIP B/R | 2
 | DAY | 3 | PGE(G)MIDC | X | PGE | ENRON | EQUILONENT | X | PSEI LOAD DEAL
 | MONTH | 25 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 20 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE |  | COLSTRIP B/R
 | DAY | 4 |  | X | PGE | ENRON | AIRPROD | X | PSEI
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 586013d1534159938-advanced-filter-using-and-logic-does-not-return-expected-values-for-non-numeric-values-todowithadvancedfiltering
Sheet: FilterNumbers

ItemNum | Cost | InStock
1 | 10 | 10
2 | 10 | 8
3 | 25 | 100
4 | 20 | 5
5 | 20 | 20
6 | 18 | 32
ItemNum | Cost | InStock
 | >=10 | >=10
ItemNum | Cost | InStock
1 | 10 | 10
3 | 25 | 100
5 | 20 | 20
6 | 18 | 32
Spreadsheet: 005ed459-14ca-479c-9fe4-35eb2d498fa9
Sheet: Sheet1

Recheck Tracking Tool | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Total | Total | % of
 | Initial Exams | Rechecks | Rechecks |  | Goal to
2013 | Performed | Performed | to Exams | Goal | Actual
January | 185 | 30 | 0.1621621621621622 | 0.23 | -0.06783783783783784
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 70405d1271169130-counting-records-in-using-lookup-book1-2-
Sheet: Activity by Day and Time

 | Exisiting / New client | (All)
 | Count of Id |  | Week
 | Day | AM / PM | 10 | 11 | 12 | 13 | 14 | Grand Total
 | Mon | AM | 2 | 2 | 2 | 2 |  | 8
 |  | PM | 2 | 3 | 3 | 2 | 3 | 13
 | Mon Total |  | 4 | 5 | 5 | 4 | 3 | 21
 | Tue | AM | 2 | 2 | 1 | 1 | 2 | 8
 |  | PM | 2 | 2 | 4 | 3 | 1 | 12
 | Tue Total |  | 4 | 4 | 5 | 4 | 3 | 20
 | Wed | AM | 1 | 2 | 2 | 1 | 2 | 8
 |  | PM | 3 | 2 | 2 | 3 | 2 | 12
 | Wed Total |  | 4 | 4 | 4 | 4 | 4 | 20
 | Thu | AM | 3 | 3 | 3 | 1 |  | 10
 |  | PM | 3 | 2 | 1 | 2 |  | 8
 | Thu Total |  | 6 | 5 | 4 | 3 |  | 18
 | Fri | AM | 2 | 3 | 2 | 1 |  | 8
 |  | PM | 2 | 2 | 1 | 2 |  | 7
 | Fri Total |  | 4 | 5 | 3 | 3 |  | 15
 | Sat | AM | 1 | 1 |  | 1 |  | 3
 |  | PM | 1 | 2 |  |  |  | 3
 | Sat Total |  | 2 | 3 |  | 1 |  | 6
 | Grand Total |  | 24 | 26 | 21 | 19 | 10 | 100
 | Volume and % Contribution of activity by Day/time by week
 |  |  | Week
 |  |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | Total
 | Day | AM / PM | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%) | vol. | (%)
 | Mon | AM
 |  | PM
 | Mon Total
 | Tue | AM
 |  | PM
 | Tue Total
 | Wed | AM
 |  | PM
 | Wed Total
 | Thu | 11:09:00
 |  | 13:08:00
 | Thu Total
 | Fri | AM
 |  | PM
 | Fri Total
 | Sat | AM
 |  | PM
 | Sat Total
 | Sun | AM
 |  | PM
 | Sun Total
 | Total
Spreadsheet: 723306d1615620927-remove-more-than-one-middle-name-example
Sheet: sites

Full Name | First Name | Last Name
[NAME] [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | Marsh
[NAME] | [NAME] | Goodway
Spreadsheet: 837951d1690550325-index-match-not-working-test-file-1-1-aligw
Sheet: Sheet1

Surname | Forenames | Patient Post Code | Patient Address |  | Calculated First Name | Surname | From |  | Actual First Name | Surname | From
[NAME] | fred | DY14 0HJ | [NAME] Residential Home |  |  |  |  |  | fred | [NAME] | [NAME] Residential Home
jones | alice | SY1 1NQ | Swan Hill House Residential Home, 6 [NAME], SHREWSBURY |  |  |  |  |  | alice | jones | Swan Hill House Residential Home, 6 [NAME], SHREWSBURY
[NAME] | [NAME] | SY11 2WZ | 21 [NAME], Rotherhide
[NAME] | billy | SY1 2LN | 6 Berwick Road, [NAME], Shrewsbury |  |  |  |  |  | billy | [NAME] | 6 Berwick Road, [NAME], Shrewsbury
harris | [NAME] | SY1 2PA | Ottley House Nursing Home, [NAME], SHREWSBURY |  |  |  |  |  | [NAME] | harris | Ottley House Nursing Home, [NAME], SHREWSBURY
smart | [NAME] | SY12 2EF | 17 hathers ridge, doncaster
Spreadsheet: e518e46a-e4d0-47ff-8f5c-6b150d8ef5a1
Sheet: Sheet1

Unnamed: 0 | Press Release Table | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Aug' 13 | Jul' 13 | Aug' 12 | M-M Chng | Y-Y Chng
 |  |  | Index of Consumer Sentiment
 | 82.1 | 85.1 | 74.3 | -0.035 | 0.105
 |  |  | Index of Consumer Expectations
 | 73.7 | 76.5 | 65.1 | -0.037 | 0.132
 |  |  | Current Conditions Index
 | 95.2 | 98.6 | 88.7 | -0.034 | 0.073
Spreadsheet: 195808d1353668414-link-a-formula-in-a-cell-to-an-item-in-another-cell-kopie-meetstaat
Sheet: MEETSTAAT

 |  |  |  |  |  |  |  | NET | KORF |  |  | RAND
 | ITEM | NIVEAU | ONDERDEEL | REFERENTIE | BREEDTE (cm) | [NAME] (cm) | [NAME]/DIKTE (cm) | WAPENING (kg) | WAPENING (kg) | BETON    (m3) | BEKISTING (m2) | BEKISTING (m)
 | FUNDERINGSPLAAT | 0 | NIV 0 |  | 1200 | 1500 | 30
 | BALK | 0 | APP 0.01 | B1 | 40 | 30 | 350
 | KOLOM | 0 | APP 0.01 | K1 | 35 | 50 | 240
 | BALK | 0 | APP 0.02 | B2 | 30 | 50 | 350
 | KOLOM | 0 | APP 0.02 | K2 | 50 | 60 | 240
 | PREDAL | 1 | AFDEK 0 |  | 1200 | 1500 | 5
 | BALK | 0 | APP 1.01 | B1 | 40 | 30 | 350
 | KOLOM | 0 | APP 1.01 | K1 | 35 | 50 | 240
 | BALK | 0 | APP 1.02 | B2 | 30 | 50 | 350
 | KOLOM | 0 | APP 1.02 | K2 | 50 | 60 | 240
 | PREDAL | 1 | AFDEK 0 |  | 1200 | 1500 | 5
Spreadsheet: 47171d1246057496-find-and-retrieve-a-set-of-data-example-1-with-formatting
Sheet: SUBTOTALS

Area | Names | Sales |  | Northeast
Northeast | [NAME] | 100 |  | Southeast
Northeast | [NAME] | 100 |  | West
Northeast | [NAME] | 50
Northeast Total
Southeast | [NAME] | 25
Southeast | [NAME] | 25
Southeast | [NAME] | 50
Southeast | [NAME] | 75
Southeast | [NAME] | 40
Southeast | Jaime | 20
Southeast Total
West | Zac | 80
West | [NAME] | 80
West | [NAME] | 125
West | [NAME] | 50
West | Dane | 45
West | Naomi | 25
West | [NAME] | 60
West Total
Grand Total
Spreadsheet: 139716d1328402672-vlookup-from-multiple-pages-test-lookup-different-page-values
Sheet: Mar

TABLE
[NAME] | CODE | BUILDING | $
LABOR | 45 | 1 | 26000
SUPPLIES | 46 | 2 | 1500
RENTAL | 47 | 3 | 0
EQUIPMENT | 48 | 4 | 500
MISC | 49 | 5 | 1250
IT | 50 | 6 | 0
Spreadsheet: 678406d1589875229-counting-the-sum-of-a-cell-based-on-an-adjacent-cells-value-countif-problem
Sheet: Sheet1

Description |  | MH 1 Depth | MH 2 Depth | AV Depth | Length (m)
 |  |  |  |  |  |  | Depth | Total (m)
Run1 |  | 0.15 | 0.16 |  | 1 |  | 0.25 to 0.50
Run2 |  | 0.15 | 0.105 |  | 1 |  | 0.50 to 0.75
Run3 |  | 0.16 | 0.37 |  | 1 |  | 0.75 to 1.00
Run4 |  | 0.15 | 0.215 |  | 1 |  | 1.00 to 1.25
Run5 |  | 1.1 | 1.2 |  | 1 |  | 1.25 to 1.50
Run6 |  | 0.15 | 0.215 |  | 1 |  | 1.50 to 1.75
Run7 |  | 0.15 | 0.37 |  | 1 |  | 1.75 to 2.00
Run8 |  | 0.37 | 1.44 |  | 1 |  | 2.00 to 2.25
Run9 |  | 0.15 | 1.44 |  | 1 |  | 2.25 to 2.50
Run10 |  | 1.44 | 2.9 |  | 1
Spreadsheet: 456546d1460936535-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-a
Sheet: MIDDLE

 |  |  | M I D D L E
NAME | ADDRESS | JUICE | FROZENS | SOUP
 |  |  |  |  | BEEF / QUICHE |  | FISH / LAMB |  | SAUS / CHICK |  | CHICK / BEEF |  | FISH / LAMB
Client 1 |  |  |  |  | BEEF | [NAME] | LAMB | YOGHURT | CHICK | [NAME] | BEEF | YOGHURT | LAMB | [NAME] |  |  |  | Week 1 | Main 1 | Main 2 | Diabetic Sweet | Sweet | Soup
Client 2 |  | OJ |  |  | QUICHE | YOGHURT | LAMB | YOGHURT | SAUS | YOGHURT | BEEF | YOGHURT | FISH | YOGHURT |  |  |  | Monday | [NAME] | Quiche Lorraine | [NAME] |  | Tomato
Client 3 |  | OJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | Baked Fish | [NAME] | Apple Peach & Custard |  | Beef & Veg
Client 4 |  | OJ |  |  |  |  |  |  |  |  |  |  |  |  |  | no corn |  | Wednesday | Curried Sausages | Crumbed Chicken | Pears & Custard |  | Chicken
Client 5 |  | AJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday | [NAME] | Roast Beef & Veg | Berry Cream Cheesecake |  | Veg
Client 6 |  |  |  |  | QUICHE | [NAME] | FISH | [NAME] | SAUS | [NAME] | CHICK | [NAME] | FISH | [NAME] |  | 2 pub meals |  | Friday | Crumbed Fish | [NAME] | Fruit & Custard | Banana Bread & Custard | Pumpkin
Client 7 |  | AJ |  |  | QUICHE | JELLY | LAMB | YOGHURT | SAUS | JELLY | BEEF | YOGHURT | FISH | JELLY
Client 8 |  | OJ
Client 9 |  | AJ |  |  | BEEF | [NAME] | LAMB | [NAME] | SAUS | YOGHURT | CHICK | [NAME] | FISH | YOGHURT |  | no corn
Client 10 |  | NO JUICE |  |  |  |  | LAMB | [NAME] | SAUS | [NAME] | BEEF | [NAME] | FISH | [NAME]
Client 11 |  |  | 7 FROZ (Meal only) |  | FROZENS
Client 12 |  | OJ
Client 13 |  | OJ | 2 froz, sw, ju |  | BEEF | [NAME] |  |  | SAUS | [NAME] |  |  | FISH | [NAME]
 |  |  | 1 froz,sw ju
Client 14 |  | NO JUICE |  |  | BEEF |  | LAMB |  | SAUS |  |  |  | LAMB
Client 15 |  | AJ |  |  | BEEF | YOGHURT | LAMB | YOGHURT | CHICK | YOGHURT | BEEF | YOGHURT | FISH | YOGHURT
 |  | AJ |  |  | BEEF | YOGHURT | LAMB | YOGHURT | CHICK | YOGHURT | BEEF | YOGHURT | FISH | YOGHURT
Spreadsheet: 221107d1363368247-how-to-sort-data-into-various-tables-and-lookup-matching-data-to-populate-rest-of-table-0start-up-qualification-audit
Sheet: Look Up tables

SIC Code |  |  |  | Start | End | Start YR | End YR | QTR | Full QTR |  | Start | End | Start YR | End YR | QTR | Full QTR
Code | Sector | Main |  | 2011-04-01 00:00:00 | 2011-06-30 00:00:00 |  |  | Q1 |  |  | 2011-04-01 00:00:00 | 2011-06-30 00:00:00 |  |  | Q1
29 | Manufacture machinery and equipment | Engineering |  | 2011-07-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Q2 |  |  | 2011-07-01 00:00:00 | 2011-09-30 00:00:00 |  |  | Q2
30 |  | Design / Creative |  | 2011-10-01 00:00:00 | 2011-12-31 00:00:00 |  |  | Q3 |  |  | 2011-10-01 00:00:00 | 2011-12-31 00:00:00 |  |  | Q3
31 |  | IT |  | 2012-01-01 00:00:00 | 2012-03-31 00:00:00 | 2011 |  | Q4 |  |  | 2012-01-01 00:00:00 | 2012-03-31 00:00:00 | 2011 |  | Q4
32 |  | IT |  | 2012-04-01 00:00:00 |  |  |  | Q1 |  |  | 2012-04-01 00:00:00 |  |  |  | Q1
33 |  | IT |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q2
40 |  | IT |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
41 |  | IT |  |  |  | 2012 |  | Q4 |  |  |  |  | 2012 |  | Q4
72 |  | IT |  |  |  |  |  | Q1 |  |  |  |  |  |  | Q1
73 |  | IT |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q2
642 |  | IT |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
742 |  | IT |  |  |  | 2013 |  | Q4 |  |  |  |  | 2013 |  | Q4
22 |  | IT |  |  |  |  |  | Q1 |  |  |  |  |  |  | Q1
80 | Education |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q2
851 | Health | IT |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
852 | Health | IT |  |  |  | 2014 |  | Q4 |  |  |  |  | 2014 |  | Q4
65 |  | IT |  |  |  |  |  | Q1 |  |  |  |  |  |  | Q1
66 |  | IT |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q2
67 |  | IT |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
7411 |  | IT |  |  |  | 2015 |  | Q4 |  |  |  |  | 2015 |  | Q4
74111 |  | IT |  |  |  |  |  | Q1 |  |  |  |  |  |  | Q1
74119 |  | IT |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q2
7412 |  | IT |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
74121 |  | IT |  |  |  | 2016 |  | Q4 |  |  |  |  | 2016 |  | Q4
74122 |  | IT |  |  |  |  |  | Q1 |  |  |  |  |  |  | Q1
74123 |  | IT |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q2
7413 |  | IT |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
7414 |  | IT |  |  |  | 2017 |  | Q4 |  |  |  |  | 2017 |  | Q4
74141 |  | IT |  |  |  |  |  | Q1 |  |  |  |  |  |  | Q1
74142 |  | IT |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q2
74143 |  | IT |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q3
74149 |  | IT |  |  |  | 2018 |  | Q4 |  |  |  |  | 2018 |  | Q4
7415 |  | IT
7420 |  | IT
74201 |  | IT
74202 |  | IT
74203 |  | IT |  |  |  | Sector List
74204 |  | IT |  |  |  | IT
74205 |  | IT |  |  |  | Communication
74206 |  | IT |  |  |  | Non Innovative
74209 |  | IT |  |  |  | R & D
7430 |  | IT |  |  |  | Design / Creative
7440 | Advertising | IT |  |  |  | Engineering
74402 |  | IT
74409 |  | IT
7460 |  | IT
74601 |  | IT
74602 |  | IT
7481 |  | IT
74819 |  | IT
7524 |  | IT
9111 |  | IT
9112 |  | IT
9120 |  | IT
9133 |  | IT
91 |  | IT
9211 |  | IT
92111 |  | IT
92119 |  | IT
9220 |  | IT
92201 |  | IT
92202 |  | IT
9231 |  | IT
9240 |  | IT
9251 |  | IT
Spreadsheet: 30820d1226508956-excel-to-recognize-a-series-of-dates-as-a-particular-week-in-the-year-weekrange
Sheet: Sheet1

2008-01-01 00:00:00 | 1 | 2008-02-02 00:00:00 | 5
2008-01-08 00:00:00 | 2
2008-01-15 00:00:00 | 3
2008-01-22 00:00:00 | 4
2008-01-29 00:00:00 | 5
2008-02-05 00:00:00 | 6
2008-02-12 00:00:00 | 7
2008-02-19 00:00:00 | 8
2008-02-26 00:00:00 | 9
2008-03-04 00:00:00 | 10
2008-03-11 00:00:00 | 11
2008-03-18 00:00:00 | 12
2008-03-25 00:00:00 | 13
2008-04-01 00:00:00 | 14
2008-04-08 00:00:00 | 15
2008-04-15 00:00:00 | 16
2008-04-22 00:00:00 | 17
2008-04-29 00:00:00 | 18
2008-05-06 00:00:00 | 19
2008-05-13 00:00:00 | 20
2008-05-20 00:00:00 | 21
2008-05-27 00:00:00 | 22
2008-06-03 00:00:00 | 23
2008-06-10 00:00:00 | 24
2008-06-17 00:00:00 | 25
2008-06-24 00:00:00 | 26
2008-07-01 00:00:00 | 27
2008-07-08 00:00:00 | 28
2008-07-15 00:00:00 | 29
2008-07-22 00:00:00 | 30
2008-07-29 00:00:00 | 31
2008-08-05 00:00:00 | 32
2008-08-12 00:00:00 | 33
2008-08-19 00:00:00 | 34
2008-08-26 00:00:00 | 35
2008-09-02 00:00:00 | 36
2008-09-09 00:00:00 | 37
2008-09-16 00:00:00 | 38
2008-09-23 00:00:00 | 39
2008-09-30 00:00:00 | 40
2008-10-07 00:00:00 | 41
2008-10-14 00:00:00 | 42
2008-10-21 00:00:00 | 43
2008-10-28 00:00:00 | 44
2008-11-04 00:00:00 | 45
2008-11-11 00:00:00 | 46
2008-11-18 00:00:00 | 47
2008-11-25 00:00:00 | 48
2008-12-02 00:00:00 | 49
2008-12-09 00:00:00 | 50
2008-12-16 00:00:00 | 51
2008-12-23 00:00:00 | 52
2008-12-30 00:00:00 | 53
Spreadsheet: 869118d1715769388-barcode-scanning-library-dvd-library
Sheet: Sheet1

DVD Title | Barcode Number | Loaned Out (Yes/No) | Loan Date | Borrower Name | Expected Return Date | Helper
Rocky | 20026752 | Yes |  | [NAME]
[NAME] | 5018505005425 | No
[NAME] | 5060180816438 | No
[NAME] | 5000159459228 | Yes |  | [NAME]
Spreadsheet: 164264d1340716102-frequency-of-a-name-corresponding-to-its-date-sample-1
Sheet: Sheet1

Date | Customer | Phone Number | Address
2012-05-25 00:00:00 | [NAME] | 000-0001 | 1456 Oakdale Road
2012-05-25 00:00:00 | [NAME] | 000-0002 | 786 [NAME]
2012-05-25 00:00:00 | [NAME] | 000-0003 | 546 Brimley
2012-05-25 00:00:00 | [NAME] | 000-0004 | 1324 Tree Dr
2012-05-27 00:00:00 | [NAME] | 000-0005 | 67 King St
2012-05-27 00:00:00 | [NAME] | 000-0002 | 786 [NAME]
2012-05-27 00:00:00 | [NAME] | 000-0007 | 98 College
2012-05-27 00:00:00 | [NAME] | 000-0008 | 543 Trailbreak
2012-05-29 00:00:00 | [NAME] | 000-0003 | 546 Brimley
2012-05-29 00:00:00 | [NAME] | 000-0004 | 1324 Tree Dr
2012-06-02 00:00:00 | [NAME] | 000-0007 | 98 College
2012-06-02 00:00:00 | [NAME] | 000-0003 | 546 Brimley
2012-06-04 00:00:00 | April Field | 000-0013 | 785 [NAME]
2012-06-09 00:00:00 | [NAME] | 000-0004 | 1324 Tree Dr
2012-06-09 00:00:00 | [NAME] | 000-0002 | 786 [NAME]
2012-06-09 00:00:00 | [NAME] | 000-0001 | 1456 Oakdale Road
2012-06-10 00:00:00 | [NAME] | 000-0002 | 786 [NAME]
2012-06-10 00:00:00 | [NAME] | 000-0003 | 546 Brimley
2012-06-12 00:00:00 | [NAME] | 000-0004 | 1324 Tree Dr
2012-06-16 00:00:00 | [NAME] | 000-0005 | 67 King St
2012-06-16 00:00:00 | [NAME] | 000-0001 | 1456 Oakdale Road
2012-06-17 00:00:00 | [NAME] | 000-0007 | 98 College
Spreadsheet: 742748d1628005837-dropdown-list-from-another-workbook-permit-example
Sheet: Plumbers

Plumbers | Registration Number
Spreadsheet: 328493d1403912168-data-validation-and-lookup-problem-example-file2
Sheet: Sheet2

Data Validation Item Drop-Down List Table
 | ITEMS | Quantity | Unit | Group1 Price | Group2 Price | Group3 Price | Total | HOW I NEED IT TO TOTAL |  | Pricing
1 | Item1 | 1 |  |  |  |  |  |  |  | ITEMS | Units | Group1 Price | Group2 Price | Group3 Price
2 | Item3 | 2 |  |  |  |  |  |  |  | Item1 | Each | 10
3 | Item2 | 3 |  |  |  |  |  |  |  | Item2 | lbs |  |  | 20
4 | [NAME] | 4 |  |  |  | 100 |  |  |  | Item3 | lbs |  |  | 5
5 | Item6 | 5 |  |  |  |  |  |  |  | Item4 | Hour |  | 30
6 | [NAME] Item2 | 6 |  |  |  |  |  |  |  | Item5 | Each | 4
7 |  | 7 |  |  |  |  |  |  |  | Item6 | Hour |  | 7
8 |  | 8
9 |  | 9
10 |  | 10
11 |  | 11
Spreadsheet: 454858d1460007711-values-are-coming-with-same-decimals-excel-weight-adjustment-1-
Sheet: Sheet1

S.NO. | CONTAINER NOS. |  | SEAL NOS. |  | NET WT | ADJUSTED WT |  |  | SLABS | INCLUDING EMPTY CONTAINER WEIGHT (2.3MT)
1 | ABCD | 123456 | 56789 |  | 25.38 |  |  | 1 | 20-26MT
 |  |  |  |  | 24.89 |  |  | 2 | 26-30MT
 |  |  |  |  | 21.21
 |  |  |  |  | 22.45
 |  |  |  |  | 27.62
 |  |  |  |  | 27.54
 |  |  |  |  | 25.68
 |  |  |  |  | 26.35
 |  |  |  |  | 24.52
 |  |  |  |  | 26.91
 |  |  |  |  | 26.23
 |  |  |  |  | 25.46
2 | ABCD | 123456 | 56790 |  | 22.67
3 | ABCD | 123456 | 56791 |  | 27.14
4 | ABCD | 123456 | 56792 |  | 26.58
5 | ABCD | 123456 | 56793 |  | 24.56
Spreadsheet: 709601d1608435288-match-and-assign-to-index-number-test-1
Sheet: Sheet1

Table 1
 | Month No. | 1
 | Apples sold | 1 | 5 | 1 | 3 | 2 | 9 | 1 | 10 | 3 | 4 | 5 | 3 | 5 | 2 | 10 | 9 | 8 | 2 | 8 | 1
 | [NAME]
Apple index |  | Count
1 | 1 |  | sold 1 for month 1
 | 2
 | 2
 | 2
 | 2
 | 2 |  | Sold 5 for month 2
 | 3 |  | Sold 1 for month 3
 | 4
 | 4
 | 4 |  | Sold 3 for month 4