tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677346d1589311500-need-not-sure-if-function-or-vbs-is-best-way-to-proceed-example
Sheet: Output

NAME | TYPE | CAUSE NUMBER | FILING DATE | AAL | Adversary | 262 | 263-1 | 263-2/Final
Smith | ER | 65412 |  | JM |  | 2020-05-19 00:00:00 | 2020-09-15 00:00:00 | 2021-01-05 00:00:00
Marks | ER | 65413 |  | KK |  | 2020-05-19 00:00:00 | 2020-09-15 00:00:00 | 2021-01-05 00:00:00
Jones | ER | 65321 |  | ST |  | 2020-05-19 00:00:00 | 2020-09-15 00:00:00 | 2021-01-05 00:00:00
Spreadsheet: 4b21f7e0-e782-435d-aab5-7e4b54907df9
Sheet: Newark

REGIONAL DIRECTORY 2014/2015
NEWARK UNIFIED SCHOOL DISTRICT
[NAME], Superintendent | [NAME], Coordinator of Student Development and Pupil Services | [NAME], Student Development Technician
5715 Musick Avenue | 5715 Musick Avenue | 5715 Musick Avenue
Newark, CA 94560 | Newark, CA 94560 | Newark, CA 94560
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] | [EMAIL] | [EMAIL]
[NAME], Regional Community Liaison | [NAME], [NAME] (facilities use) | [NAME], Assessment Technician
O: [PHONE] | 5715 Musick Avenue | 5715 Musick Avenue
C: [PHONE] | Newark, CA 94560 | Newark, CA 94560
[EMAIL] | O: [PHONE] | O: [PHONE]
 | [EMAIL] | [EMAIL]
Spreadsheet: 841720d1693900469-listing-staff-and-roles-according-to-table-staff-operations-excel-test
Sheet: Staff Site Allocate

 | BRAND PARTNER DEMO | CATALINA BAY | CATALINA BAY CU | CINTRA | IMPERIAL GARDENS | NATONAL MINI | QUEEN STREET | SPENCER | STARBUCKS | STUDIO ONE | SUMMIT | T BUILD | UNITEC | VICTORIA AVE | WESTWOOD
[NAME]
Leading Hand
[NAME]
# of Staff on this site
Spreadsheet: 752949d1635133574-retrieve-multiple-results-by-vlookup-possible-vlookup
Sheet: dashboard

 | Display Information based on score
 | 3 |  |  | Company name | Name | Surname | [NAME]
 |  |  |  | GGG
Spreadsheet: 724901d1616436747-formula-needed-to-create-a-list-based-on-specific-count-test-doc
Sheet: Sheet5

 | Item | Corresponding count |  |  | Result List
 | Cat | 1 |  |  | Cat
 | Cat | 1 |  |  | Dog
 | Cat | 1 |  |  | Horse
 | Dog | 1 |  |  | Horse
 | Dog | 1 |  |  | Horse
 | Dog | 1 |  |  | Horse
 | Horse | 4 |  |  | Elephant
 | Horse | 4 |  |  | [NAME]
 | Horse | 4 |  |  | [NAME]
 | Horse | 4 |  |  | [NAME]
 | Horse | 4
 | Horse | 4
 | Horse | 4
 | Elephant | 1
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
Spreadsheet: 29343d1224258121-converting-table-array-to-list-example
Sheet: Sheet1

 |  | 5210 | 5350 | 5630 |  | Dept. | Acct. | Amount
 | 201 | 10 | 20 | 50 |  | 201 | 5210 | 10
 | 311 | 60 | 70 | 40 | ---> | 201 | 5350 | 20
 | 566 | 1 | 3 | 5 | ??? | 201 | 5630 | 50
 | 865 | 11 | 13 | 16 |  | 311 | 5210 | 60
 | 8899 | 21 | 23 | 25 |  | 311 | 5350 | 70
 |  |  |  |  |  | 311 | 5630 | 40
 |  |  |  |  |  | 566 | 5210 | 1
 |  |  |  |  |  | 566 | 5350 | 3
 |  |  |  |  |  | 566 | 5630 | 5
 |  |  |  |  |  | 865 | 5210 | 11
 |  |  |  |  |  | 865 | 5350 | 13
 |  |  |  |  |  | 865 | 5630 | 16
 |  |  |  |  |  | 8899 | 5210 | 21
 |  |  |  |  |  | 8899 | 5350 | 23
 |  |  |  |  |  | 8899 | 5630 | 25
Spreadsheet: michael_maggi__26472__NYMEXWEEKLYSTATS
Sheet: SC

Week Ending: | 2001-01-25 00:00:00
 | Futures Settlement Prices
 | BRENT CRUDE OIL |  |  |  |  | Contract Symbol:  SC
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-01-21 00:00:00 | 2001-01-22 00:00:00 | 2001-01-23 00:00:00 | 2001-01-24 00:00:00 | 2001-01-25 00:00:00 | Interest
 | 2002-03-01 00:00:00 | CLOSED | 18.74 | 19.12 | 19.14 | 19.4 | 72
 | 2002-04-01 00:00:00 | CLOSED | 18.87 | 19.17 | 19.29 | 19.55 | 10
 | 2002-05-01 00:00:00 | CLOSED | 18.98 | 19.27 | 19.37 | 19.67 | 20
 | 2002-06-01 00:00:00 | CLOSED | 18.98 | 19.3 | 19.33 | 19.59 | 625
 | 2002-07-01 00:00:00 | CLOSED | 19.01 | 19.33 | 19.33 | 19.57 | 98
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 825
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Brent Crude Oil
 | 5 Day Hist. Vol. |  |  | N\A
 | 20 Day Hist. Vol. |  |  | N\A
 | Implied Volatility-Options
 |  |  |  | Brent Crude Oil
 | At the Money Call & Put
 |  |  |  | N\A
 | MON | TUE | WED | THUR | FRI | Total
Volume | CLOSED | 0 | 5 | 200 | 350
Spreadsheet: 882036d1730299141-comparing-two-columns-in-one-worksheet-to-two-columns-in-second-worksheet-jo-version-003-take-3
Sheet: Actual Rates

PD | FY | Labor | Labor | Labor | Labor | Labor | G&A | M&H
 |  | MNST | PGMT | COAT | CDEV | SOFT
N/A | 2021 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 2022 | 6.82604958 | 116.61966763 | 26.74633499 | 1.40833949 | 6.49588651 | 0.29360195 | 0.06294492
12 | 2023 | 7.80906274 | 93.51894225 | 61.35400173 | 2.61413019 | 7.60551968 | 0.2924222 | 0.07788839
12 | 2024 | 6.19921278 | 63.62544553 | 38.69458959 | 7.5147715 | 6.63741656 | 0.19578489 | 0.03521769
3 | 2025 | 8.5291762 | 0 | 19.96888149 | 11.37601338 | 1.20928799 | 0.41212029 | 0.21027155
Spreadsheet: jeff_dasovich__14034__Agro
Sheet: Sheet1

Agro-Feed
Question 3 - 1995 Income Statement
 |  | Income Statement, May, 31, 1995
 |  | Income from continuing Operations |  |  |  |  |  |  |  | 9500000
 |  | Gain on sale of land |  |  |  |  |  |  | 750000
 |  | Discontinued Operations
 |  |  | Income (loss) on uncollectable accounts receivable
 |  |  | A/R charged off (April 95 - end of year) |  |  |  |  |  | 5110461
 |  |  | less bad debt expense |  |  |  |  |  | 3644536
 |  |  | Est future uncollectable A/R |  |  |  |  |  | 570000
 |  |  | Losses and write-doesn of land, building and equipment
 |  |  | Recorded between April 95 - end of year |  |  |  |  |  | 1465425
 |  |  | Estimted future loss |  |  |  |  |  | 6867608
 |  |  | Cost and Expenses related to dicontinuance
 |  |  | Incurred between April 95 and end of year |  |  |  |  |  | 2294559
 |  |  | Est future costs |  |  |  |  |  | 2803073
 |  |  | Income tax credits |  |  |  |  |  | 11027752
 |  | Income after accounting for discontinued operations
 |  | and before other extraordinary items
 |  | Extraordinary Items
 |  |  | Pesticide Recall
 |  |  | Litigation cost from recall |  |  |  |  |  | 500000
 |  |  | Reformulation and testing cost related to recall |  |  |  |  |  | 300000
 |  |  | Cumulative legal costs due to recall |  |  |  |  |  | 575000
 |  |  | Gain on change in depreciation method |  |  |  |  |  | 200000
 |  |  | (for products purchased after March 1995)
 |  |  | Cost due to litigation settlement |  |  |  |  |  | 250000
 |  |  | Loss due to tornado -  net insurance claim |  |  |  |  |  | 135000
 |  |  | Total Income after discontinued operations and
 |  |  | extraordinary items
Spreadsheet: 765292d1643270976-find-result-in-data-table-by-multiple-conditions-cooling-power
Sheet: Calculation form

 |  | Warehouse size | 15 | ㎡
 |  | Warehouse height | 2.2 | m
 |  | Panel thickness | 100 | [NAME]
 |  | Outside air temp. | 35 | ℃
 |  | Desirable Internal temp. | 10 | ℃
TODO | How to? -> | Required power |  | kw
Spreadsheet: 157935d1337933916-copy-and-pasting-filtered-data-sample
Sheet: Sheet1

 | Dir | Business_name
 | Monsterrat | [NAME]
 | Monsterrat | Kelsick & Kelsick
 | Monsterrat | Lab Works Ltd
 | Monsterrat | [NAME]'s [NAME]
 | Monsterrat | [NAME]'s Pharmacy
 | Monsterrat | Montserrat Shipping & Business Services
 | st lucia | [NAME] Medical Centre
 | st lucia | [NAME]'s Garage
 | st lucia | Angelos International Ltd
 | st lucia | Aravins Enterprises
 | st lucia | Auto Star Ltd
 | st lucia | Bank Of Montserrat Ltd
 | Monsterrat | Business & Student Support Centre The
 | Monsterrat | C & G Construction
 | Monsterrat | CathRon Products/Housing Lot Development
 |  | under process
 |  | under process
 |  | under process
 |  | under process
 |  | under process
 |  | under process
 |  | under process
 |  | under process
 |  | under process
Spreadsheet: 461528d1463634214-excel-wont-sort-the-dates-and-recognise-the-date-format-dust-bar-graph-backup-
Sheet: Type 2.3

Date | Dust (%)
6/05/2016 (Lot 74) | 34
5/05/2016 (Lot 73) | 25
19/10/2015 (Lot 56) | 40
20/11/2014 (Lot 82) | 25
30/10/2014 (Lot 79A) | 20
30/09/2014 (Lot 79) | 25
10/03/2014 (Lot 53) | 20
20/01/2014 (Lot 49) | 10
[NAME] (Lot 49) | 30
[NAME] (Lot 49) | 35
19/05/2015 (Lot 34) | 25
11/09/2015 (Lot 44) | 25
26/10/2015 (Lot 57) | 25
4/12/2015 (Lot 61) | 25
14/07/2014 (Lot 70) | 25
22/12/2014 (Lot 84) | 25
Average: | 26
Spreadsheet: 683513d1592804274-adding-indirect-function-to-an-existing-if-statement-sample-file_indirect-lookup
Sheet: Draftboard

 |  | 2020 Draft Big Board
 | Round
 | 1 | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10
 | 2 | #11 | #12 | #13 | #14 | #15 | #16 | #17 | #18 | #19 | #20
Spreadsheet: 106192d1303381876-vlookup-formula-for-data-from-different-sheets-vlookup-formual-for-data-from-3-sheets
Sheet: Sheet2

15 | b1
16 | b2
17 | b3
18 | b4
19 | [NAME]
20 | b6
21 | b7
22 | b8
23 | b9
24 | b10
Spreadsheet: 721282d1614623435-excel-index-match-retrieving-multiple-columns-of-data-excel-question-00237440xc6a08-
Sheet: By Year

Annual Yield Worksheet (Closed) |  |  |  |  |  |  | Total Weighted Average Investor Yield =
Investor | Investment | Date | Status | Principal Payment Amount | Total Payment Amount | IRR | Weight Factor | Total Weight Factor
Total
2020
2019
2018
2017
Spreadsheet: 147775d1332962362-excel-2007-count-formula-without-exact-match-book1
Sheet: Sheet1

problem |  | Problem | Count
BETTER NOTES |  | [NAME]
CCD PIF. OTHER PLAN LESS THAN 300 |  | Disc Label
CHEAPER PLAN
CHEAPER PLAN AND DISC LABEL
CHEAPER PLAN AVAILABLE
DED CHANGE
DISC LABEL
DISC LABEL
DISC LABEL AND CHEAPER PLAN
DISC LABEL AND EMAIL
DISC LABEL AND [NAME]
DISC LABEL AND PROMO CODE
[NAME]
[NAME]
[NAME]
[NAME] AND BETTER NOTES
EMAIL AND CHEAPER PLAN
EMAIL AND DISC LABEL
EMAIL AND PROMO CODE
FIX MILES
NOTES
NOTES, EMAIL , DISC LABEL
PROMO CODE
VERIFY ACCNT
Spreadsheet: 860445d1708533049-fill-a-sheet-based-on-data-entered-manually-in-another-sheet-sample-workbook-35-aligw
Sheet: Sheet2

VESSEL | BASE SPIRIT | PRODUCT | WEIGHT (KG) | VOLUME (L) | ABV (%) | LAA
5A | RYE | gin | 39 | 40 | 0.4
4A | GRAPE | brandy | 20 | 22 | 0.35
1B | OTHER | vodka | 5 | 6 | 0.42
2A | WHISKY | bourbon | 36 | 37 | 0.57
2B | WHISKY | scotch | 13 | 14 | 0.38
3B | GRAPE | flavoured brandy | 17 | 18 | 0.12
1A | OTHER | liqueur | 57 | 58 | 0.92
5B | VERMOUTH | vermouth | 23 | 24 | 0.18
3A | GRAPE | amaro | 41 | 42 | 0.26
4B | GRAPE | bitters | 16 | 17 | 0.14
Spreadsheet: 142048d1329602128-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: PGA

 |  | WEEK 18 PGA Championship
 |  | Total Earnings |  |  |  | Rankings Through Week 18 | Total
 | [NAME] | 0 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 2 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 | Player 4 | 0 |  | 4 |  | Player 4 | 0
 | Player 5 | 0 |  | 5 |  | Player 5 | 0
 | Player 6 | 0 |  | 6 |  | Player 6 | 0
 | Player 7 | 0 |  | 7 |  | Player 7 | 0
 | Player 8 | 0 |  | 8 |  | Player 8 | 0
 | Player 9 | 0 |  | 9 |  | Player 9 | 0
 | Player 10 | 0 |  | 10 |  | Player 10 | 0
 | Player 11 | 0 |  | 11 |  | Player 11 | 0
 | Player 12 | 0 |  | 12 |  | Player 12 | 0
 | Player 13 | 0 |  | 13 |  | Player 13 | 0
[NAME] |  | PGA |  | YTD
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
[NAME]
Allenby, [NAME] |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 4
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 5
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 6
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 7
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 8
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 9
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 11
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 12
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Player 13
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total |  |  | 0
Spreadsheet: 788085d1658254688-creating-a-customer-status-flag-based-on-multiple-columns-sample-customer-status
Sheet: vendor 1

External Order Number | [NAME] | [NAME] | Customer Flag- Existing
14954894156
14954894157
14954894158
14954894159
14954894160
14954894161
14954894162
14954894163
14954894164
14954894165
14954894166
14954894167
14954894168
14954894169
14954894170
14954894171
14954894172
14954894173
14954894174
14954894175
Spreadsheet: 863783d1711178826-calculating-time-based-on-event-formula-help-tracking-time-on-events-example-1-aligw
Sheet: Sheet1

Battery #1 in | Battery #2 in | Battery #1 out | Battery #2 out | Time stamp | Name |  | Battery in time |  |  |  |  |  |  |  |  |  |  | Battery out time
1 | 2 | 9 | 10 | 09:45:00 | MonDAGV
3 | 4 | 1 | 2 | 10:05:00 | MonDAGV
5 | 6 | 7 | 8 | 10:10:00
10 | 9 | 3 | 4 | 11:10:00
2 | 1 | 5 | 6 | 12:10:00
1 | 2 | 9 | 10 | 13:10:00
3 | 4 | 1 | 2 | 14:00:00
5 | 6 | 7 | 8 | 14:15:00
10 | 9 | 3 | 4 | 15:16:00
2 | 1 | 5 | 6 | 16:12:00
 |  |  |  |  |  |  |  | time in stamp | time out stamp | Time difference
 |  |  |  |  |  |  | 1 | 09:45:00 | 10:05:00 | 00:20:00
 |  |  |  |  |  |  | 2 | 09:45:00 | 10:05:00 | 00:20:00
 |  |  |  |  |  |  | 3 | 10:05:00 | 11:10:00 | 01:05:00
 |  |  |  |  |  |  | 4 | 10:05:00 | 11:10:00 | 01:05:00
 |  |  |  |  |  |  | 5 | 10:10:00 | 12:10:00 | 02:00:00
 |  |  |  |  |  |  | 6 | 10:10:00 | 12:10:00 | 02:00:00
 |  |  |  |  |  |  | 10 | 11:10:00 | 13:10:00 | 02:00:00
 |  |  |  |  |  |  | 9 | 11:10:00 | 13:10:00 | 02:00:00
 |  |  |  |  |  |  | 2 | 12:10:00 | 14:00:00 | 01:50:00
 |  |  |  |  |  |  | 1 | 12:10:00 | 14:00:00 | 01:50:00
 |  |  |  |  |  |  | 1 | 13:10:00 | 14:00:00 | 00:50:00
 |  |  |  |  |  |  | 2 | 13:10:00 | 14:00:00 | 00:50:00
 |  |  |  |  |  |  | 3 | 14:00:00 | 15:16:00 | 01:16:00
 |  |  |  |  |  |  | 4 | 14:00:00 | 15:16:00 | 01:16:00
 |  |  |  |  |  |  | 5 | 14:15:00 | 16:12:00 | 01:57:00
 |  |  |  |  |  |  | 6 | 14:15:00 | 16:12:00 | 01:57:00
 |  |  |  |  |  |  | 10 | 15:16:00
 |  |  |  |  |  |  | 9 | 15:16:00
 |  |  |  |  |  |  | 2 | 16:12:00
 |  |  |  |  |  |  | 1 | 16:12:00
Spreadsheet: 3e6e180c-0ebf-4e64-a6dc-c03d03e59909
Sheet: Sheet1

Instructions for use.
1.  Manually input data on Log worksheet in columns A through E.  Erase any data already processed.
Particularly for contests, it may be easy to fill in columns A through C by copying down the column.
2.  [NAME] down (or delete) formulas in columns G and H on Log worksheet to match length of data input.
3.  On the ADIF worksheet, copy down (or delete) formulas in column A to match length of Log sheet.
The last row occupied on both [NAME] and ADIF sheets will be the same.
4.  VERY IMPORTANT:  then save this Excel workbook in Excel format (normal save).
5.  After saving in Excel format, go to ADIF worksheet and Save As (your choice of name)
in Text (MS-DOS) format.  Choose "Text (MS-DOS)" from the drop-down list in the Save As
dialog box (it's pretty far down the list).  Give the file a name in double-quotes,
with an .ADI extension, like "W8TM_log3.ADI"  This will save only the one worksheet;
ignore warnings about lost info.
6.  Shut down Excel.  It will issue a warning and ask you if you want to save.  [NAME] the
warning and shut down without saving anything.
7.  Check that you didn't screw up by reopening this workbook in Excel (it should be unchanged from step 3)
and by viewing the .ADI file in a text editor (it should look like the ADIF worksheet but without
columns or blank lines).
8.  The .ADI file you saved should be able to be signed by TQSL and e-mailed to LoTW.
DON'T SKIP STEP 4.
If you screw up steps 5 or later, you can restart from the Excel file saved in Step 4.
If you want to make more manual ADI entry workbooks like this one, you can copy this file in Explorer or
Save As an Excel workbook from Excel, under a new file name in either case.
If TQSL expands the list of bands it will process, insert them in frequency order on the Band Table worksheet.
Comment:  out-of-band frequency input results in the next-lower frequency band name (or #N/A if less than 1.8).
[NAME] names should match those listed in TQSL's manual ADIF editor.
Spreadsheet: 726524d1617284253-need-help-with-vlookup-based-on-if-and-and-vlookup-with-if-and
Sheet: All products

 | Customer | Product A | Product B
 | VSOP | L | J
 | MANU | L | J
 | MANC | L | J
 | LIVP | L | J
 | ARSE | L | J
 | TOTH | L | J
 | QPRA | L | J
 | NOTF | L | J
 | CHFC | L | J
 | LCFC | L | J
 | [NAME] | J | L
 | ASAP | J | L
 | PLSE | J | L
 | ADEV | J | L
 | ALKP | J | L
 | DPQE | J | L
 | CLCS | J | L
 | FNUP | J | L
 | VWPO | J | L
 | CP3O | J | L
Spreadsheet: 764446d1642748791-index-required-by-matching-two-columns-index-with-match-two-columns-new-data
Sheet: Input Master

 |  |  |  |  |  | Performance Grade > |  | Outstanding | Very Good | Good | Average | Below Average
 | Category | Grade | Slab |  | Category | H1 | % | 1 | 0.8 | 0.7 | 0.4 | 0
 | Category-A | Outstanding | 0.15 |  | A | Upto 4000 | 0.15
 | Category-A | Very Good | 0.12 |  | B | Between 4001 to 6500 | 0.12
 | Category-A | Good | 0.105 |  | C | Between 6501 to 10000 | 0.1
 | Category-A | Average | 0.06 |  | D | Above 10001 | 0.08
 | Category-A | Below Average | 0
 | Category | Grade | Slab
 | Category-B | Outstanding
 | Category-B | Very Good
 | Category-B | Good
 | Category-B | Average
 | Category-B | Below Average
 | Category | Grade | Slab
 | Category-C | Outstanding
 | Category-C | Very Good
 | Category-C | Good
 | Category-C | Average
 | Category-C | Below Average
 | Category | Grade | Slab
 | Category-D | Outstanding
 | Category-D | Very Good
 | Category-D | Good
 | Category-D | Average
 | Category-D | Below Average
Spreadsheet: 883933d1732726846-xlookup-with-multiple-value-relationships-example
Sheet: Sheet1

test | provider | instrument |  | newtestname
1 | A | AOutSource |  | 1(All)
1 | B | BOutSource |  | 2(D)
1 | C | CInHouse |  | 3(B)
1 | D | DInHouse |  | 4(D)
2 | D | DInHouse |  | 5(InHouse)
3 | B | BOutSource |  | 6(c)
4 | D | DInHouse |  | 7(D)
5 | D | DInHouse |  | 8(D)
5 | C | CInHouse |  | 9(D)
6 | C | CInHouse |  | 10(OutSource)
7 | D | DInHouse
8 | D | DInHouse
9 | D | DInHouse
10 | A | AOutSource
10 | B | BOutSource
Spreadsheet: 85516d1285618141-using-weekly-data-to-convert-to-monthly-quote-analyzer
Sheet: Monthly Totals

Year | Month | Month Name | # of Jobs Quoted | Jobs Quoted Value | Average Value/Job | # of Jobs Attained | Jobs Attained Value | Average Value/Job | # of Jobs Success Rate | Job Value Success Rate | Jobs Quoted Rolling Total | Ave. Quote Value/Week | Jobs Won Rolling Total | Ave. Won Value/Week
2010 | 1 | June
2010 | 2 | July
2010 | 3 | August
2010 | 4 | September
2010 | 5 | October
2010 | 6 | November
2010 | 7 | December
2011 | 8 | January
2011 | 9 | February
2011 | 10 | March
2011 | 11 | April
2011 | 12 | May
2011 | 13 | June
2011 | 14 | July
2011 | 15 | August
2011 | 16 | September
2011 | 17 | October
2011 | 18 | November
2011 | 19 | December
2011 | 20 | January
Spreadsheet: 0c6a392a-a6ba-47e3-a555-c2215e2f554c
Sheet: Notes

[NAME] | http://highered.colorado.gov/Publications/Reports/Enrollment/FY2008/
 | http://highered.colorado.gov/Data/Graphs/Inst_Dashboard.swf
[NAME] | Data run by CDHE Research Department.
Retention | Fall 07 to Fall 08 retention
 | http://highered.colorado.gov/Publications/Reports/Enrollment/FY2008/2008_RetentionRates_rev082009.pdf
Graduation Rates | 2 year colleges- 2005 cohort, graduating at original or 2-Year transfer institution
 | 4 year colleges- 2002 cohort, graduating in 6 years at either home or transfer institution
 | http://highered.colorado.gov/Publications/Reports/Enrollment/FY2008/2008_GradRates.pdf
Carnegie Classifications | http://classifications.carnegiefoundation.org/lookup_listings/institution.php
 | See next tab.
CCHE Classification | DHE/CCHE policy & Colorado Revised Statues.
Type of Institution | DHE/CCHE policy & Colorado Revised Statues.
Tuition and fees | Tuition/fees for 09-10- basic for 30 credit hours, does not include high cost programs or differential tuition/  for ldc- in district tuition/fees.
Admissions | DHE/CCHE policy & Colorado Revised Statues.
Specialty Areas | Taken from individual Institution's website.
Minority Class | Federal Designation
Statutory Mission | Taken from individual Institution's website.
Accessibility Statements | Taken from individual Institution's website.
Spreadsheet: 708720d1607978331-array-index-problems-need-assistance-or-any-advice-to-help-to-create-formula-to-enable-to-book1indexandaggregate
Sheet: Before Sheet

Information in Spreadsheet 1
Family ID | No of Children
2022 | 2
2022 | 2
2023 | 2
2023 | 2
2841 | 2
2841 | 2
2405 | 3
2026 | 2
2378 | 3
2377 | 1
2378 | 3
2028 | 3
2691 | 2
2331 | 1
Spreadsheet: 739535d1625759711-need-a-single-formulas-to-calculate-net-worth-overall-gain-and-couple-of-more-parameters-balance-portfolio-value-based-on-fifo-sabha-
Sheet: port

 |  |  |  |  | Current Qty
 |  |  | Invested |  | Overall Gain |  |  |  | [NAME]
 |  |  | Prev Close | 7.45 | Today Gain
 |  |  | LTP | 7.8 | Networth
 |  |  | Rate | P / L % | Type | Qty | Cost | Bal_Qty | Portfolio_Bal
 | 2021-06-28 00:00:00 |  | 10 |  |  | 5
 | 2021-06-29 00:00:00 |  | 17 |  |  | -3
 | 2021-06-30 00:00:00 |  | 3 |  |  | 17
 | 2021-07-01 00:00:00 |  | 7.8 |  |  | -15
Spreadsheet: 121135d1315860975-how-to-do-this-lookup-copy-of-copy-of-stats-help-1
Sheet: Picking Stats

 | ZONE 1 |  |  |  | ZONE 2 |  |  |  | ZONE 3 |  |  |  | ZONE 4 |  |  |  | TOTAL PICK RATE
DATE | PICKED | NOT PICKED | PICKER | PICK RATE | PICKED | NOT PICKED | PICKER | PICK RATE | PICKED | NOT PICKED | PICKER | PICK RATE | PICKED | NOT PICKED | PICKER | PICK RATE
2011-09-05 00:00:00 | 28 | 10 | [NAME] |  | 76 | 7 | [NAME] |  | 8 | 2 | [NAME] |  | 16 | 22 | [NAME]
2011-09-06 00:00:00 | 3 | 2 | [NAME] |  | 24 | 8 | [NAME] |  | 3 | 0 | [NAME] |  | 4 | 3 | [NAME] |  |  |  | ZONE 1 AVERAGE
2011-09-07 00:00:00 | 13 | 3 | [NAME] |  | 13 | 3 | [NAME] |  | 13 | 3 | [NAME] |  | 13 | 3 | [NAME] |  |  |  | ZONE 2 AVERAGE
2011-09-08 00:00:00 | 24 | 5 | [NAME] |  | 24 | 5 | [NAME] |  | 24 | 5 | [NAME] |  | 24 | 5 | [NAME] |  |  |  | ZONE 3 AVERAGE
2011-09-09 00:00:00 | 54 | 15 | [NAME] |  | 54 | 15 | [NAME] |  | 54 | 15 | [NAME] |  | 54 | 15 | [NAME] |  |  |  | ZONE 4 AVERAGE
2011-09-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERALL AVERAGE
2011-09-13 00:00:00
2011-09-14 00:00:00
2011-09-15 00:00:00
2011-09-16 00:00:00
2011-09-19 00:00:00
2011-09-20 00:00:00
2011-09-21 00:00:00
2011-09-22 00:00:00
2011-09-23 00:00:00
2011-09-26 00:00:00
2011-09-27 00:00:00
2011-09-28 00:00:00
2011-09-29 00:00:00
2011-09-30 00:00:00
2011-10-03 00:00:00
2011-10-04 00:00:00
2011-10-05 00:00:00
2011-10-06 00:00:00
2011-10-07 00:00:00