tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857920d1706777920-please-help-with-the-formula-to-make-provision-for-inventory-provision-for-inventory
Sheet: DATA

outstanding at the beginning_INPUT MATERIAL |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  |  |  |  |  | 0
PRODUCT | Date | AMOUNT | Tồn |  | PRODUCT | AMOUNT |  | PRODUCT | Date | AMOUNT |  | 0~120 DAYS | 120 DAYS~1 YEARS | 1 YEARS~ 2 YEARS | 2 YEARS~ 3 YEARS | > 3 YEARS
Sản phẩm A | 2022-11-30 00:00:00 | 5 |  |  | Sản phẩm A | 5
Sản phẩm A | 2022-12-31 00:00:00 | 50 |  |  | Sản phẩm A | 5
Sản phẩm A | 2023-01-01 00:00:00 | 100 |  |  | Sản phẩm A | 20
Sản phẩm B | 2022-11-30 00:00:00 | 20 |  |  | Sản phẩm B | 20
Sản phẩm B | 2023-12-31 00:00:00 | 150 |  |  | Sản phẩm B | 30
Sản phẩm B | 2024-01-01 00:00:00 | 200 |  |  | Sản phẩm B | 100
Sản phẩm C | 2022-11-30 00:00:00 | 20
Sản phẩm C | 2024-01-01 00:00:00 | 80
Sản phẩm D | 2018-11-17 00:00:00 | 90
Spreadsheet: 820748d1678278837-count-times-name-occurs-in-a-week-s666-pq-count-times-name-occurs-in-a-week
Sheet: Sheet1

week | client |  | would like table |  |  |  | week | client | Count |  | week | client | Count of client
1 | bbc |  |  |  |  |  | 1 | bbc | 3 |  | 1 | bbc | 3
1 | bbc |  | week | client | number of times client in week |  | 1 | itv | 2 |  |  | c4 | 2
1 | bbc |  | 1 | bbc | 3 |  | 1 | c4 | 2 |  |  | c5 | 3
1 | itv |  | 1 | itv | 2 |  | 1 | c5 | 3 |  |  | itv | 2
1 | itv |  | 1 | c4 | 2 |  | 2 | bbc | 1 |  | 2 | bbc | 1
1 | c4 |  | 1 | c5 | 3 |  | 2 | itv | 4 |  |  | c5 | 1
1 | c4 |  |  |  |  |  | 2 | c5 | 1 |  |  | itv | 4
1 | c5 |  |  |  |  |  | 3 | bbc | 3 |  | 3 | bbc | 3
1 | c5 |  |  |  |  |  | 3 | c4 | 2 |  |  | c4 | 2
1 | c5 |  |  |  |  |  | 3 | c5 | 2 |  |  | c5 | 2
2 | bbc
2 | itv
2 | itv
2 | itv
2 | itv
2 | c5
3 | bbc
3 | bbc
3 | bbc
3 | c4
3 | c4
3 | c5
3 | c5
Spreadsheet: 758332d1638820575-find-multiple-payments-and-pull-details-app-test-1
Sheet: CHARGE (BILLING) DETAILS

Customer Name | Customer ID | Claim ID | Claim Patient ID | Patient Full Name | Primary Auth # | Insurance ID | Year | Month | Charge From Date (Min) | Charge To Date ([NAME]) | Charge CPT Code | Level of Care | Charge Rev Code | Charge [NAME] | Billed Days | Charge/Debit Amount | Paid | Patient Payments | Total Adjustments | Charge Balance | Charge Status | Open/Closed | INVOICE #1 | PAYMENT # 1 | ALLOWED #1 | DEDUCTIBLE #1 | OOP #1 | PAID #1 | INVOICE #2 | PAYMENT # 2 | ALLOWED #2 | DEDUCTIBLE #2 | OOP #2 | PAID #2 | INVOICE #3 | PAYMENT # 3 | ALLOWED #3 | DEDUCTIBLE #3 | OOP #3 | PAID #3 | INVOICE #4 | PAYMENT # 4 | ALLOWED #4 | DEDUCTIBLE #4 | OOP #4 | PAID #4 | INVOICE #5 | PAYMENT # 5 | ALLOWED #5 | DEDUCTIBLE #5 | OOP #5 | PAID #5 | INVOICE #6 | PAYMENT # 6 | ALLOWED #6 | DEDUCTIBLE #6 | OOP #6 | PAID #6 | INVOICE #7 | PAYMENT # 7 | ALLOWED #7 | DEDUCTIBLE #7 | OOP #7 | PAID #7
TEST 1 | 10023736 | 144161710 | 39553493 | TEST PATIENT | 123456 | ABC123 | 2020 | September | 2020-09-13 00:00:00 | 2020-09-14 00:00:00 | [NAME] | [NAME] | 0126 | UNITED HEALTHCARE | 2 | 13000 | 2778.74 | 0 | 10221.26 | 0 | PAID | CLOSED
Spreadsheet: phillip_m_love__30161__9901_OA
Sheet: SE-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 153649d1335986855-somewhat-complex-document-problems-extracting-and-organizing-data-from-cells-6max-hyper
Sheet: Sheet1

 | Players | UTG | MP | CO | BU | SB | BB
 | 6 | 500 | 500 | 500 | 500 | 500 | 500
 | 5 | 490 |  | 490 | 465 | 1065 | 490
 | 5 | 480 |  | 455 | 575 | 1010 | 480
 | 5 | 445 |  | 565 | 1100 | 420 | 470
 | 5 | 555 |  | 1215 | 385 | 410 | 435
 | 5 | 1330 |  | 375 | 375 | 375 | 545
 | 5 | 365 |  | 365 | 780 | 170 | 1320
 | 4 | 770 |  |  | 580 | 1260 | 390
 | 4 | 685 |  |  | 1225 | 330 | 760
 | 4 | 1215 |  |  | 295 | 700 | 790
 | 4 | 275 |  |  | 630 | 670 | 1425
 | 4 | 610 |  |  | 600 | 1535 | 255
 | 3 |  |  |  | 1465 | 590 | 945
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 1-5 thru 1-11

 |  |  |  |  |  | System:
 |  |  | 2009-01-05 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-01-05 00:00:00 |  |  |  |  |  |  | Total
1 |  |  |  | 64
2 |  |  |  | 58.35
3 |  |  | 50
4 |  |  | 28.65 |  |  | 26.71
5 |  |  |  | 31.11 |  |  | 33.57
6 |  |  |  | 32.56 |  |  |  | 32.88
7 |  |  |  |  |  | 31.48
8 |  |  | 32.38
9 |  |  |  | 35.71
10 |  |  | 30.81 |  |  |  | 28.94
11
12 |  | 31.78 |  |  | 30 |  |  | 34.19
13 |  | 35.5 |  |  |  | 37.62
14 |  |  |  |  | 31.5
15 |  |  | 31 |  | 31
16 |  | 31.09 |  | 28.39 |  | 35.7
17 |  |  | 32.78 |  | 30.08 |  |  | 31
18 |  |  |  |  | 33.09
19 |  |  |  | 29.38 |  | 33.15
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 98598d1297453908-pivot-table-displaying-data-rows-into-columns-inventory
Sheet: Computer_Purchase_Nick K

[NAME]
Date | Item Name | Item Description | Notes | Quantity | Cost | Shipping | Total
2011-01-01 00:00:00 | XEON650 | Dell Xeon DP 2.4 Ghz |  | 2 | 15 |  | 30
2011-01-01 00:00:00 | XEON530 | Dell Xeon DP 1.7 Ghz |  | 1 | 15 |  | 15
2011-01-01 00:00:00 | XEON670 | Dell Xeon 2.8 Ghz |  | 1 | 15 |  | 15
2011-01-01 00:00:00 | DELL2400 | Dell P4 [NAME] |  | 1 | 15 |  | 15
2011-01-01 00:00:00 | IBM_8183 |  |  | 3 | 15 |  | 45
2011-01-01 00:00:00 | IBM_8171 |  |  | 1 | 15 |  | 15
2011-01-01 00:00:00 | HPDX2200 |  |  | 1 | 15 |  | 15
2011-01-08 00:00:00 | DELL?1 | Dell P4 2.25 Ghz |  | 1 | 20 |  | 20
2011-01-08 00:00:00 | DELLXPS |  |  | 1 | 20 |  | 20
2011-01-08 00:00:00 | DELLGX240 | Dell P4 2.0 Ghz | 30GB HD | 1 | 20 |  | 20
 |  |  |  |  |  |  | 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
Spreadsheet: 46962d1245872163-create-custom-list-from-pivot-table-pivot-table-dropdown-example
Sheet: Sheet1

Item | Profit Margin | Profit Margin Value
widget a | Profit Margin | 0.25
widget b | Profit Margin | 0.3
widget c | Profit Margin | 0.35
widget d | Profit Margin | 0.4
widget e | Profit Margin | 0.5
Sum of Profit Margin Value | Profit Margin
Item | Profit Margin | Grand Total
widget a | 0.25 | 0.25
widget b | 0.3 | 0.3
widget c | 0.35 | 0.35
widget d | 0.4 | 0.4
widget e | 0.5 | 0.5
Grand Total | 1.8 | 1.8
Drop Down Menu Here
I want the drop down selections to only provide option of items with a profit margin below 40%.
Spreadsheet: 541635d1507452947-problem-with-sum-function-sum-function
Sheet: Sheet1

Refferal Charges | closing fee | SUM function | + Operator
89.544 | 20
149.24 | 40
44.408 | 10
133.224 | 40
Spreadsheet: 00b27eb0-08b6-47b4-820b-7e9bc21f43fd
Sheet: Math & Trigonometry Functions

Sum (Column) |  |  |  |  |  |  |  | SumIF (Numbers) |  | SumIF (Text) |  |  |  | SumIFs |  |  |  | ABS |  | ROUND
343 |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  |  |  |  | -4 |  | 2.15
898 |  |  |  |  |  |  |  | 127 |  | Category | Name | Sales |  | Quantity Sold | Product | Salesperson |  | 400 |  | 2.149
453 |  |  |  |  |  |  |  | 55 |  | Vegetables | Tomatoes | 456 |  | 50 | Pencils | [NAME] |  | 25 |  | -1.475
543 |  |  |  |  |  |  |  | 7 |  | Vegetables | Celery | 567 |  | 100 | Paper | [NAME] |  | -901 |  | 21.5
 |  |  |  |  |  |  |  | 90 |  | Fruits | Oranges | 1256 |  | 30 | Paper | [NAME]
 |  |  |  |  |  |  |  | 78 |  | Fruits | Apple | 2309 |  | 35 | Pencils | [NAME]
 |  |  |  |  |  |  |  | 45 |  |  | Butter | 500 |  | 125 | Pens | [NAME]
 |  |  |  |  |  |  |  | 6 |  | Fruits | Grapes | 2356 |  | 340 | Pens | [NAME]
 |  |  |  |  |  |  |  | 67 |  | Fruits | Watermelon | 109 |  | 500 | Water Bottles | [NAME]
 |  |  |  |  |  |  |  | 456 |  | Vegetables | Onion | 2980 |  | 250 | Writing Pads | [NAME]
 |  |  |  |  |  |  |  | 65 |  | Vegetables | Lettuce | 589 |  | 195 | Writing Pads | [NAME]
 |  |  |  |  |  |  |  | 467 |  | Vegetables | Potatoes | 1980 |  | 650 | Water Bottles | [NAME]
 |  |  |  |  |  |  |  | 1209 |  |  | Milk | 3400
 |  |  |  |  |  |  |  | 89 |  |  | Eggs | 4500
 |  |  |  |  |  |  |  | 389
 |  |  |  |  |  |  |  | 20 |  | Vegetable Sales
 |  |  |  |  |  |  |  | 22 |  | Fruits Sales
 |  |  |  |  |  |  | >200
 |  |  |  |  |  |  | <100 |  |  | How many items sold by [NAME]
Sum (Row) |  |  |  |  |  |  | <1500, >500 |  |  | (starting with "W")
 |  |  |  |  |  |  |  |  |  | How many items sold by [NAME]
 |  |  |  |  |  |  |  |  |  | (starting with "W")
 |  |  |  |  |  |  |  |  |  |  |  |  |  | How many items sold by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | How many items sold by [NAME]
Spreadsheet: 860331d1708464726-maxifs-max-count-based-on-multliple-criteria-tracking-test-03
Sheet: SUMMARY

 |  |  |  |  | START: | 2024-01-01 00:00:00
BANKS ISSUED | TOTAL COUNT | DAY | SWING | GRAVE | END: | 2024-02-28 00:00:00
BANK #01
BANK #03 |  | 1 | 3 | 0
BANK #04 |  | 1 | 1 | 0
BANK #02 (ISSUED) |  | 4 | 3 | 1
BANK #02 (RETURNED) |  | 1 | 3 | 4
DATE | SHIFT | EMPLOYEE | EMP # | TYPE | OUTLET | AMOUNT
 | DAY | 0 | 0 | ISSUED | BANK #01 | 900
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #01 | 900 |  | 2
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #01 | 900
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #01 | 900 |  | 2
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #01 | 900
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #01 | 900 |  | 2
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #01 | 900 |  | 1
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #01 | 900 |  | 1
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 2
2024-01-02 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 1
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000 |  | 3
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 4
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 3
2024-01-03 00:00:00 | GRAVE | 0 | 0 | ISSUED | BANK #02 | 15000 |  | 1
2024-01-03 00:00:00 | DAY | 0 | 0 | RETURNED | BANK #02 | 15000 |  | 1
2024-01-03 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | RETURNED | BANK #02 | 15000 |  | 2
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURNED | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURNED | BANK #02 | 15000 |  | 4
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #03 | 687.5 |  | 1
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5 |  | 2
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #03 | 687.5 |  | 1
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #03 | 687.5 |  | 3
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #04 | 687.5 |  | 1
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #04 | 687.5 |  | 1
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUED | BANK #04 | 687.5 |  | 1
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUED | BANK #04 | 687.5 |  | 1
Spreadsheet: 134517d1325373774-need-help-with-this-macro-on-highlighting-duplicates-test-mark-duplicates-on-multiple-criteria
Sheet: Raw Data

Employee No. | FIRST NAMES | SURNAME | TYPE OF LOAN | LOAN AMOUNT | TENOR | INSTALLMENTS | EFFECTIVE FROM | TO
1 | SOKABI | BABAFEMI AJIBOLA | CDL LOAN | 405000 | 12 | 49950 | 2011-01-04 00:00:00 | 31/03/2012 | OGSG
4 | OSUNFISAN | OLUMOROTI OKUFADEKE | CDL LOAN | 145000 | 12 |  | 2011-12-01 00:00:00 | 2012-11-01 00:00:00 | OGSG
4 | OSUNFISAN | OLUMOROTI OKUFADEKE | CDL LOAN | 100000 | 12 |  | 2011-01-06 00:00:00 | 31/05/2012 | OGSG
456 | IDOWU | MURTALA  ADELAJA | Retired | 90000 | 12 | 11100 | 2009-01-10 00:00:00 | 30/09/2010 | 4
566 | GANDONU | FREDERICK AKINOLA | CDL LOAN | 84000 | 12 |  | 2011-01-06 00:00:00 | 31/05/2012 | OGSG
680 | AKINBANJO | ADEYEMI SUNDAY | Retired | 77000 | 12 | 9496.666666666666 | 2010-01-05 00:00:00 | 30/04/2011 | 4
958 | OSIBAMOWO | OLULANA BABASOLA | CDL LOAN | 250000 | 12 | 30833.33333333333 | 2011-01-03 00:00:00 | 28/02/2012 | OGSG
1135 | AWOSINA | BABASOLA SOLOMON | CDL LOAN | 188000 | 12 |  | 2011-01-09 00:00:00 | 31/08/2012 | OGSG
1226 | OGUNSOLA | [NAME] | CDL LOAN | 64000 | 12 |  | 2011-09-01 00:00:00 | 2012-08-01 00:00:00 | 12
Spreadsheet: 712835d1610441439-how-to-add-formula-for-dynamic-drop-down-list-to-data-validation-share-excel-sheet-with-questions
Sheet: Active data sheet

Unique drop-down for Primary Category | Dependent drop-down for Secondary Category
Bird |  |  | Issue | Dependent drop-down not working. [NAME] works in B3 when [NAME] is pressed, but not on cells below or in data validation
Animal
Plant
Plant
Fish |  |  | Essential | Needs to work in excel 2010
Bird |  |  |  | Drop down list limited to actual values (i.e. no blank options
Bird |  |  |  | If "type" is added to T_Category, then the options are automatically updated
Bird
Country
 |  |  |  | I followed the following 2 videos:
 |  |  |  | 1) https://www.youtube.com/watch?v=7fYlWeMQ6L8 - extract unique items for dynamic data validation drop down list
 |  |  |  | 2) https://www.youtube.com/watch?v=gu4xJWAIal8 - find multiple matches & dependent drop down list (unsorted tabular data set)
 |  |  |  | Thanks!!
Spreadsheet: 265733d1379380380-index-and-match-only-if-adjacent-cell-value-is-true-test1
Sheet: Sheet1

Equipment Number | PM Number | PM Ref |  | Equipment Number | PM Number
AB | 12 | 1 |  | AB | 12 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
DE | 23 | 2 |  | DE | 87 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
GH | 45 | 1 |  | GH | 45 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
GH | 78 | 2 |  | JK | 42 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
DE | 87 | 1 |  | MN | 85 | <<< Desired result expected from formula (only if PM Ref = 1 for corresponding Equipment No in Column A)
JK | 42 | 1
AB | 63 | 2
MN | 22 | 2
JK | 86 | 2
MN | 85 | 1
Spreadsheet: 870168d1716727080-is-there-a-way-to-simplify-this-formula-excel-help-with-formulas-aligw
Sheet: List

Contracts |  | Reason for Days Lost
 |  | Down time reasons
Contract B |  | X
Contract C |  | WEATHER
Contract D |  | TRUCK BREAK DOWN
Contract E |  | AGENCY CREW ISSUE
Contract F |  | CONTRACT
Contract G |  | WORKSHOP
Contract H |  | UNIT BREAKDOWN
Contract I |  | AVALIBLE FOR CONTRACT
Contract j |  | VELOCITY CREW ISSUE
Contract K |  | SPARE ON CONTRACT
Contract L |  | CREW TRAVEL
Contract M |  | MATERIAL ISSUE
Contract N
Contract O
Contract P
Contract Q
0
Spreadsheet: 881995d1730233159-formula-for-displaying-movement-type-with-various-outcomes-book1
Sheet: Sheet1

 |  | START LOCATION | END LOCATION | DISPLAYED WORD
 |  | ID1 | 08-101-08 | PUTAWAY
 |  | MN4 | OB-03-05 | PICK
 |  | MN4 | 07-88-04 | TRANSFER
 |  | MN4 | FGRET | TRANSFER
 |  | MN4 | PH1QI | TRANSFER
 |  | MN4 | VNAMISSING | TRANSFER
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Nursing

NURSING ADN PROGRAM REQUIREMENTS
Associate in Applied Science Degree in Nursing
Student Name:  _________________________________________ | ACT | GPA
Student ID:  ___________________________ | ________ | ________
Curricular requirements for ADN
Prerequisites | Semester | Grade
___ Active status on Kentucky Medicaid Nurse Aid Registry
___ Computer Literacy - IC3 exam or CIS 100 (3)
___ BIO 137 Human Anatomy & Physiology I (4)
___ MAT 110 Applied Math (3) OR __ MAT 150 (3) College Algebra
OR Higher Level Mathematics Course
___ PSY 110 General Psychology (3)
General Education, Support and NRS Program Courses
First Year
Fall Semester
___ NRS 101 (9) Nursing Care I
___ BIO 139 (4) Human Anatomy & Physiology II  (Prior to or concurrent with NRS 101)
___ PSY 223 (3) Developmental Psychology (Prior to or concurrent with NRS 101)
Spring Semester
___ NRS 102 (10) Nursing Care II
___ ENG 101 (3) Writing I (Prior to or concurrent with NRS 102)
___ Oral Communication (3) (Prior to or concurrent with NRS 102)
Summer Session (For LPNs admitted to the RN program)
___ NRS 200 (3) LPN-ADN Transition course
Taken only by LPNs who have been admitted to the program with advanced standing.
Second Year
Fall Semester
___ NRS 201 (9) Nursing Care III
___ BIO 225 (4) Medical Microbiology OR BIO 227 (5) Principles of Microbiology
(Prior to or concurrent with NRS 201)
___ ENG 102(3) Writing II (Prior to or concurrent with NRS 201)
Spring Semester
___ NRS 204 (10) Nursing Care IV
___ Heritage or Humanities course (3) (Prior to or concurrent with NRS 204)
*All NRS, BIO and MAT classes require a grade of "C" or better to continue in the program.
LPN/ADN Career Mobility Program begins each Fall on Pineville and Cumberland Campuses.
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 765557d1643385747-textjoin-array-using-if-with-nested-and-book1
Sheet: Calendar

[NAME] issue | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 |  | Test formula just unit | Test formula Just date
Unit1
Unit2
Correct output
 | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00
Unit1 | a,b,c,d | d |  | h
Unit2 | l,k | m
Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Explaination about this model

 |  |  |  |  |  |  |  |  | Date: | Feb.08,2001
Asset Valuation Model - |  |  |  |  |  | Developed by | [NAME] |  | Ext.58927
 |  |  |  |  |  | Modified by | [NAME] |  | Ext.53579
Explaination about this model
1 | Assumptions
 | Before the valuation, please determine what will be the main variables that impact the cash flow. Based on historical data
 | and specific market research, hard input the values for these variables on the "Assumptions" sheet.  These variables
 | might be furthur tested in Sensitivity Analysis by using "Data"- "Table" function in Excel and Risk Analysis by using Crystal Ball.
2 | Format
a. | The assumption cells are in yellow background
b. | The forecast cells are in green background
c. | The historical data are in gray background
2 | Unlevered cash flow analysis
a. | The unlevered cash flow analysis mainly values the assets based on their business risks.  It does not consider the financial
 | risks from the financial leverage.
b. | If there is more than one asset, input the different asset data in the separate "Asset" sheets, and the "Unlev. Consolid" sheet will
 | automatically consolidate the valuation for the whole package of the assets.
c. | Please pay attention to the "Warning Flag" on these separate "Asset" sheets and the "unlev. Consolid" sheet
 | so that the model gives valid and accurate forecast.
3 | Levered cash flow analysis
a. | The levered cash flow analysis considers the costs ( e.g. interest expenses) and benefits ( e.g. tax benefits) from
 | financial leverage.
b. | In this model, it is important that the target capital structure is constant over the life of the assets. For example, if the financial
 | leverage rate is 50% of debt financing, the 50% debt financing rate must be maintained over the lift of the
 | assets.  To maintain a constant capital structure, the following relationships must be satisfied in the "Lev. Consolid" sheet:
 | Pre-Current Debt = Beg. Yr. Debt- Debt Retirement
 | Pre-Current Equity = Beg. Yr. [NAME]. Net Income - Net Cash Flow
 | Pre - Total Capital = Pre-Current Debt + Pre- Current Equity
 | End. Yr Debt = Leverage rate* Pre-Total Capital
 | End. Yr Equity= (1-Leverage rate) * Pre-Total Capital
 | Debt Retirement = End.Yr.[NAME]. Yr Debt
 | Net Cash Flow = Beg. Yr. Equity -End. Yr.[NAME]. Net Income
 | (please see the above terms in the "Lev.Consolid"sheet)
c. | As shown on the above formula, there exits circular relationships between these data. Therefore, a circular reference is intentionally
 | created in this model.  When opening the Excel, please go to "Tools"-"Options", Click on "Calculation"tab and check "Iteration" box.
Spreadsheet: 297493d1392406384-select-last-number-in-a-row-that-contains-a-number-greater-than-zero-and-return-a-value-last-value-in-row
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Answer:
Spreadsheet: 118689d1313892945-joining-values-in-multiple-columns-into-one-formatted-string-of-text-and-numbers-sample
Sheet: Sheet1

 | 022 | 22 | 4 | 7 | 9,10,15,16 |  | 1,2,7,8 | SE
 | 022 | 22 | 4 | 7 | 11,12,13,14 |  | 3,4,5,6 | SW
 | 022 | 22 | 4 | 8 | 1,2,7,8 |  | 9,10,15,16 | NE
 | 022 | 22 | 4 | 8 | 3,4,5,6 |  | 11,12,13,14 | NW
 | 020 | 19 | 5 | 12 | 4 |  | 1,2,7,8,9,10,15,16 | E
 | 019 | 20 | 5 | 24 | 1,2,7,8,10,9,15,16 |  | 9,10,11,12,13,14,15,16 | N
 | 019 | 20 | 5 | 25 | 1-through-36 |  | 1,2,3,4,5,6,7,8 | S
 |  |  |  |  |  |  | 1-through-36