tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 29470d1224509788-question-on-returning-value-from-a-chart-example
Sheet: Sheet1

 |  |  | AVERAGE
Increase |  | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150
0 |  | 0 | 200 | 400 | 800 | 1200 | 1600 | 2000 | 2400 | 2800 | 3400 | 4000
0.015 |  | 200 | 400 | 600 | 1000 | 1400 | 1800 | 2200 | 2600 | 3000 | 3600 | 4200
0.03 |  | 400 | 600 | 800 | 1200 | 1600 | 2000 | 2400 | 2800 | 3200 | 3800 | 4400
0.045 |  | 600 | 800 | 1000 | 1400 | 1800 | 2200 | 2600 | 3000 | 3400 | 4000 | 4600
0.06 |  | 800 | 1000 | 1200 | 1600 | 2000 | 2400 | 2800 | 3200 | 3600 | 4200 | 4800
0.075 |  | 1000 | 1200 | 1400 | 1800 | 2200 | 2600 | 3000 | 3400 | 3800 | 4400 | 5000
0.09 |  | 1200 | 1400 | 1600 | 2000 | 2400 | 2800 | 3200 | 3600 | 4000 | 4600 | 5200
0.105 |  | 1400 | 1600 | 1800 | 2200 | 2600 | 3000 | 3400 | 3800 | 4200 | 4800 | 5400
0.12 |  | 1600 | 1800 | 2000 | 2400 | 2800 | 3200 | 3600 | 4000 | 4400 | 5000 | 5600
0.135 |  | 1800 | 2000 | 2200 | 2600 | 3000 | 3400 | 3800 | 4200 | 4600 | 5200 | 5800
0.15 |  | 2000 | 2200 | 2400 | 2800 | 3200 | 3600 | 4000 | 4400 | 4800 | 5400 | 6000
0.165 |  | 2200 | 2400 | 2600 | 3000 | 3400 | 3800 | 4200 | 4600 | 5000 | 5600 | 6200
0.18 |  | 2400 | 2600 | 2800 | 3200 | 3600 | 4000 | 4400 | 4800 | 5200 | 5800 | 6400
0.1950000000000001 |  | 2600 | 2800 | 3000 | 3400 | 3800 | 4200 | 4600 | 5000 | 5400 | 6000 | 6600
0.2100000000000001 |  | 2800 | 3000 | 3200 | 3600 | 4000 | 4400 | 4800 | 5200 | 5600 | 6200 | 6800
0.2250000000000001 |  | 3000 | 3200 | 3400 | 3800 | 4200 | 4600 | 5000 | 5400 | 5800 | 6400 | 7000
0.2400000000000001 |  | 3200 | 3400 | 3600 | 4000 | 4400 | 4800 | 5200 | 5600 | 6000 | 6600 | 7200
0.2550000000000001 |  | 3400 | 3600 | 3800 | 4200 | 4600 | 5000 | 5400 | 5800 | 6200 | 6800 | 7400
0.2700000000000001 |  | 3600 | 3800 | 4000 | 4400 | 4800 | 5200 | 5600 | 6000 | 6400 | 7000 | 7600
0.2850000000000001 |  | 3800 | 4000 | 4200 | 4600 | 5000 | 5400 | 5800 | 6200 | 6600 | 7200 | 7800
0.3000000000000002 |  | 4000 | 4200 | 4400 | 4800 | 5200 | 5600 | 6000 | 6400 | 6800 | 7400 | 8000
Spreadsheet: 0760ab75-570a-493a-a032-2f5c3129cd34
Sheet: Sheet1

BROCK UNIVERSITY - Finance  Deposit Register | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Department: |  |  | [NAME]: | Y       or        N
Remitted By: |  |  | Extension:
Date:
If this deposit is payment for a Brock Invoice, please enter RP details:  RP#
Cash Record |  |  | Other Deposit Items (i.e. Credit Card, Debit, US$)
# of Bills | Denomination | Total Value | Description | Value
 | x $5 | 0
 | x $10 | 0
 | x $20 | 0
 | x $50 | 0
 | x$100 | 0
Total Value of Coins
Cash Total |  | 0 | Total | 0
Cash Deposit GL Number:
Please list all cheques that are being submitted to Finance for deposit.  If cheques are to be applied to a student account the Student ID and [NAME] (first 3 letters of the students last name) are mandatory.  IF cheques are being applied to an internal 9 digit general ledger account the account number must be provided as well as the payor's name.
**Account Number must be recorded on the back of each cheque**
Student ID      (if Required) | SUR     Check | Amount | GL if Required | Payor (cheque written by)
Additional cheques can be listed below if required
CHEQUE TOTAL |  | 0 | 0 | 0
DEPOSIT TOTAL |  |  |  | 0
Finance Use:
VERIFIED BY: |  |  | OR#:
DATE:
Student ID      (if Required) | SUR     Check | Amount | GL if Required | Payor (cheque written by)
Spreadsheet: 770842d1646298946-need-help-solving-this-transpose-scenario-copy-of-need-help-solving-this-transpose-scenario
Sheet: Output

 |  |  | 1
 | Dist | City
1
Spreadsheet: 836673d1689587951-calculating-yield-to-maturity-difference-between-rate-and-yield-formulas-ytm-calculator_for_sharing
Sheet: YTM

Yield to Maturity - Semi-annual Payments
Inputs |  | [NAME]
Coupon Rate
Par Value | 100
Start (Purchase) Date | 2023-07-01 00:00:00
Maturity Date | 2025-01-31 00:00:00
Years to Maturity |  | =YEARFRAC(B7,B8,1)
[NAME]. of Coupon Payments | 2
Bond Price | 93.5
Intermediary Calculations
Coupon |  | =(B5*B6)/B10
Number of Periods |  | =B9*B10
Outputs using RATE
Yield to Maturity |  | =RATE(B16,B15,-B11,B6)*B10
Outputs using YIELD
Yield to Maturity |  | =YIELD(B7,B8,B5,B11,B6,B10,1)
Spreadsheet: 329665d1404380010-removed-repeated-charecteristics-with-1-creteria-thilag
Sheet: Sheet1

[NAME]
AAA
AAA
AAA
BBB
BBB
CCC
CCC
DDD
DDD
MMM
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
DDD
AAA
BBB
CCC
Spreadsheet: 731133d1620207214-find-the-last-payment-copy-of-example-2-003-
Sheet: Sheet2

ID | How many payments? | Last payment (when? Period?)
61060 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
49013
93544
34170
62507
85365
73331
419225 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
79741
39847
99885
33291
82640 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
98135
49524
90717 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
68812
58341
58527
5417 |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
86157
68789
75514
69001
41532
75179
98122 |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
16720 |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
431911 |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
33108 |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
422358
421254
93694
33345 |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
96090
41814
62144
406600
63514 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
8151 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
405311 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
94519
55224
95528 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
46491
48693
59065
37872 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
25827 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
41731
16694
17976 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
18101 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
14713 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
44909 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
80760 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
50345
65058
38043
11324
15666 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
15966
11863
15611
60415 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
44042
11968 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
10504 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
92058
82422
366648 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
427637 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
48642
69951
Spreadsheet: 836644d1689561518-sum-column-based-on-another-list-sum-based-on-match
Sheet: Key

n | 10
nc | 10
n1 | 10
n2 | 10
d | 8
dc | 8
d1 | 8
d2 | 8
d3 | 8
d* | 8
[NAME] | 8
a | 12
ac | 12
a1 | 12
a2 | 12
p | 12
nt | 10
) | 12
)1 | 12
)c | 12
p10 | 10
p12 | 12
Spreadsheet: 847786d1698661303-combine-functions-to-return-the-right-values-from-a-matrix-excelforum_1
Sheet: Calendar 1

 |  |  |  |  |  |  |  |  |  |  |  | Function not working → |  |  |  | [NAME] not working
 | MATRIX |  |  |  |  |  |  |  |  |  |  | RETURN VALUES FROM THE MATRIX
 | ↓ |  |  | ↓ |  |  | ↓ |  |  | 2023-10-04 00:00:00
 | Unit | Position | Shift | Staff | 2023-10-01 00:00:00 | 2023-10-02 00:00:00 | 2023-10-03 00:00:00 | 2023-10-04 00:00:00 | 2023-10-31 00:00:00 | Oct |  | Day: | 2023-10-03 00:00:00
 | 2C | Position1 | M | Employee 01 | 2C |  | 2C | 2C
 | 3P | Position1 | E | Employee 02 |  | 3P | 3P |  |  |  |  | 2C | Employee 01 |  | 4C | Employee 03
 | 4C | Position1 | N | Employee 03 | 4C |  | 4C | 4C |  |  |  |  | Employee 04 |  |  | Employee 06
 | 2C | Position1 | M | Employee 04 | 2C | 2C | 2C |  |  |  |  |  | Employee 15
 | 3P | Position1 | E | Employee 05 |  | 3P
 | 4C | Position1 | N | Employee 06 | 4C |  | 4C
 | FLO | Position1 | M | Employee 07 | FLO |  | FLO | FLO
 | 3P | Position1 | E | Employee 08 | HOL | HOL | 3P |  |  |  |  | 3P | Employee 02 |  | FLO | Employee 07
 | 4C | Position1 | N | Employee 09 | VAC | VAC | VAC | VAC | VAC |  |  |  | Employee 08 |  |  | Employee 16
 | 2C | Position1 | M | Employee 10 | 2C | SICK | SICK | SICK |  |  |  |  | Employee 12
 | FLO | Position1 | M | Employee 11 | FLO |  | FLO |  | FLO |  |  |  | Employee 14
 | 3P | Position1 | M | Employee 12 | 3P |  | 3P
 | 2C | Position1 | M | Employee 13 |  | 2C
 | 3P | Position1 | M | Employee 14 | 3P |  | 3P |  |  |  |  | Vacation |  | Holiday |  | Sick
 | 2C | Position1 | M | Employee 15 | 2C | 2C | 2C |  |  |  |  | Employee 09 |  | Employee 08 |  | Employee 10
 | FLO | Position1 | M | Employee 16 | FLO |  | FLO |  | FLO |  |  | Employee 18
 | 2C | Position1 | M | Employee 17 |  | 2C
 | 3P | Position1 | M | Employee 18 | VAC | VAC | VAC | VAC | VAC
Spreadsheet: marie_heard__24532__Corn Products
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: | 2001-10-16 00:00:00 | DEAL MAKER: | Patrice Thurston
COUNTERPARTY: | Corn Products International, Inc | CONTACT: | 1
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State | DE | S&P Rating | BBB
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) | n/a | Enron Corp. (BBB+)
LIMIT $ MILLIONS |  | $15MM
Incorporation State |  | Oregon
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | $7.5MM | $25MM
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0 | 0
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X | X
-Below = S&P/Moody's | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | $18MM
-Guarantor ($[NAME]) |  | $300MM
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | Vanek | x3-1436
Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: CC 103833 - Upload

SAP PROFIT CENTER:
PROFIT CENTER OWNER:
SAP COST CATEGORY:
SAP COST | SAP COST |  |  |  |  |  |  |  |  |  |  |  |  | Annual
CENTER | ELEMENT | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Expense
 | 52000500
 | 52001000
 | 59003000
 | 52001500
 | 52002000
 | 52002500
 | 52003000
 | 52003500
 | 52004000
 | 52004500
 | 52503500
 | 52502000
 | 52507400
 | 52507000
 | 52507100
 | 52507200
 | 52507300
 | 52507500
 | 52507600
 | 52507700
 | 52508000
 | 52508100
 | 52508500
 | 53500000
 | 53500500
 | 53600000
 | 52500500
 | 52504100
 | 53800000
 | 53801000
 | 52504500
 | 54000000
 | 52502500
 | 52505500
 | 54005000
 | 52504200
 | 52506500
 | 52506000
 | 52503000
 | 52504000
 | 57200000
 | 57000000
 | 59099900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 786010d1656927469-help-with-countifs-and-unique-values-formula-kpi-test-data
Sheet: CS Register

Name / ID Number | Sex | 2021 Group | 2021 Groups NP
Bluebell | F | 75 | 0
[NAME] | M |  | 0 |  | Data should count cells in this column with 0
Bounty | F |  | 0 |  | And count unique values where 0 is in the other column
[NAME] | F | 75 | 0
[NAME] | F | 8 | 7 |  | Answer should be 3
Karlos | M | 41 | 0 |  | 75, 41 and 31
Katerina | F | 41 | 0
Kristoff | M | 8 | 7
[NAME] | M | 75 | 0
Mercury | M | 31 | 0
Violet | F | 8 | 7
Spreadsheet: 160980d1339350088-excel-2008-find-lower-price-from-multiple-sheets-book1-shokarta-oeldere-
Sheet: Sheet2

Shop: | name1 | sheet 2
id | price
1 | 43 | sheet 2
2 | 12 | sheet 2
3 | 31 | sheet 2
4 | 32 | sheet 2
6 | 4 | sheet 2
Spreadsheet: phillip_m_love__30655__9901_OA
Sheet: EAST-CON-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  EAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | 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: 5925a415-9065-446d-89d2-dad38df3804b
Sheet: EPR CF

CONSOLIDATED STATEMENTS OF CASH FLOW ([NAME] and Condensed)
 | Nine Months Ended
 | June 30,
 | 2012 |  | 2011
(In millions)
Operating
Net income | 157.8 |  | 230.2000000000001
Depreciation and amortization | 179.3 |  | 167.3
Contingent acquisition related costs | 11.1 |  | 0
Other non-cash items | 49.7 |  | 68.1
Changes in operating assets and liabilities, excluding acquisitions:
Receivables | 1 |  | 15.1
Inventories | -25.3 |  | -2.3
Accounts payable and accrued liabilities | 14.5 |  | -46
Jackpot liabilities | -38.5 |  | -81.00000000000001
Income taxes | -6.5 |  | 70.3
Other assets and deferred costs | -16.1 |  | 27
Net operating cash flows | 327 |  | 448.7000000000002
Investing
Capital expenditures | -170.8 |  | -155.1
Jackpot annuity investments, net | 36.7 |  | 42.8
Changes in restricted cash | 6.7 |  | 22.9
Loans receivable, net | 21.5 |  | 23.9
Business/VIE acquisition/deconsolidation | -233.9 |  | -105.9
Other | 29.6 |  | 31.2
Net investing cash flows | -310.2 |  | -140.2
Financing
Debt related proceeds (payments), net | 280 |  | -104.4
Employee stock plans | 15.1 |  | 33.4
Share repurchases | -475.1 |  | -25
Noncontrolling interest acquired | -2.5 |  | 0
Dividends paid | -53.5 |  | -53.8
Net financing cash flows | -236 |  | -149.8
Foreign exchange rates effect on cash | 0.5 |  | -0.7999999999999999
Net change in cash and equivalents | -218.7 |  | 157.9000000000001
Beginning cash and equivalents | 460 |  | 158.4
Ending cash and equivalents | 241.3 |  | 316.3000000000002
Spreadsheet: 173938d1344863779-macros-button-help-3m-valley
Sheet: Veg Glycerine

Veg. Glycerine 99.7 BIO-K
577 Lbs./Drum
[NAME]
Lot # | CB243700209
Batch # | 999999
PO | USMMMOFO8T
Rel. | N/A | 2009-04-20 00:00:00
 |  | 3
Veg. Glycerine 99.7 BIO-K
577 Lbs./Drum
[NAME]
Lot # | CB243700209
Batch # | 999999
PO | USMMMOFO8T
Rel. | N/A | 2009-04-20 00:00:00
List
15
21
Spreadsheet: geir_solberg__11258__5_30act
Sheet: EPEData

 | 37133.71944444445
 | NEWMAN 1 ,ECON, 42  , 68  , 39  , 83  , 26  ,1
 | NEWMAN 2 ,MANL, 76  , 77  , 37  , 82  ,  0  ,1
 | NEWMAN 3 ,ECON, 99  ,100  , 35  ,103  ,  1  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,214  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 217 ,  245,  111, 268 ,  27 ,
 | COPPER   ,MANL, 62  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,MANL, 43  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 39  , 42  , 30  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  , 90  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,  82 ,   89,   59,  97 ,   0 ,
 | PALOVERDE,MANL,591  ,591  ,591  ,600  ,  0  ,1
 | FOURCRNRS,MANL,103  ,103  ,103  ,104  ,  0  ,1
 | LAMBDA, 54.09,  840,  839,   42,   -5,    0,23794,43
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 856134d1705497956-count-distinct-values-help2
Sheet: SUMMARYdelete

 |  |  |  |  |  |  |  |  |  |  | DOC DATE
 | SITES | FC [NAME] | Consider AWCT  To - Do CREATED AT FC | IWS & Eligible and date is <today |  |  |  |  |  |  | SITES | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00
 |  |  |  | REGIME WEEKS
 |  |  |  | 9 | 13 | 22 | 26 | 35 | 39
 |  |  |  |  |  |  |  |  |  |  | ACTON
 |  |  |  |  |  |  |  |  |  |  | Ealing
 |  |  |  |  |  |  |  |  |  |  | Fulham
 |  |  |  |  |  |  |  |  |  |  | Harlesden
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Hounslow
 |  |  |  |  |  |  |  |  |  |  | ShepherdBush
 |  |  |  |  |  |  |  |  |  |  | Kingston
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Uxbridge
 |  |  |  |  |  |  |  |  |  |  | Wembley
 |  |  |  |  |  |  |  |  |  |  | Wandsworth
 | TOTAL |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | MISSING INFORMATION IWS: Date Before today and Eligible blank
 | SITES | Consider AWCT  To - Do CREATED AT FC | Duplicattes | Either DOC OR FC DATE Missing | FC Date BEFORE DOC date | FC Date Regime BLANK | FC Date To-do BLANK | 9 Weeks Regime BLANK | 9 Weeks To-do BLANK | 13 Weeks Regime BLANK | 13 Weeks To-do BLANK | 22 Weeks Regime BLANK | 22 Weeks To-do BLANK | 26 Weeks Regime BLANK | 26 Weeks To-do BLANK | 35 Weeks Regime BLANK | 35 Weeks To-do BLANK | 39 Weeks Regime BLANK | 39 Weeks To-do BLANK | TOTAL MISSING
 | ACTON
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | ShepherdBush
 | Kingston
 | [NAME]
 | Uxbridge
 | Wembley
 | Wandsworth
 | TOTAL
 | STARTED on IWS & Eligible --> moved to Light touch into work & Working Enough
 | SITES | FC Date To-do: IWS AND Eligible | 9 Weeks Regime | 13 Weeks Regime | 22 Weeks Regime | 26 Weeks Regime | 35 Weeks Regime | 39 Weeks Regime | Total into work VS Started on IWS & Eligible
 | ACTON |  |  |  |  |  |  |  |  | ACTON
 | Ealing |  |  |  |  |  |  |  |  | Ealing
 | Fulham |  |  |  |  |  |  |  |  | Fulham
 | Harlesden |  |  |  |  |  |  |  |  | Harlesden
 | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 | Hounslow |  |  |  |  |  |  |  |  | Hounslow
 | ShepherdBush |  |  |  |  |  |  |  |  | ShepherdBush
 | Kingston |  |  |  |  |  |  |  |  | Kingston
 | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 | Uxbridge |  |  |  |  |  |  |  |  | Uxbridge
 | Wembley |  |  |  |  |  |  |  |  | Wembley
 | Wandsworth |  |  |  |  |  |  |  |  | Wandsworth
 | TOTAL
Spreadsheet: 859327d1707747668-how-to-populate-daily-sales-dynamically-based-on-the-week-ending-dates-and-daily-breakdo-daily-splits
Sheet: Sheet1

Input / Source Data
 | 2024-08-10 00:00:00 | 2024-08-17 00:00:00 | 2024-08-24 00:00:00 | 2024-08-31 00:00:00 | 2024-09-07 00:00:00 | 2024-09-14 00:00:00 | 2024-09-21 00:00:00
Sales Volume | 7000 | 5000 | 9000 | 10000 | 5000 | 4000 | 2000
Days | 5 | 5 | 5 | 5 | 6 | 6 | 6
Days | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
5 | 0.214 | 0.204 | 0.194 | 0.194 | 0.194 | 0 | 0 | 1
6 | 0.1833333333333333 | 0.1733333333333333 | 0.1633333333333334 | 0.1633333333333334 | 0.1633333333333334 | 0.1533333333333333 | 0 | 1
Desired Output Highlighted in Green & Yellow
Day | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Date | 2024-08-04 00:00:00 | 2024-08-05 00:00:00 | 2024-08-06 00:00:00 | 2024-08-07 00:00:00 | 2024-08-08 00:00:00 | 2024-08-09 00:00:00 | 2024-08-10 00:00:00 | 2024-08-11 00:00:00 | 2024-08-12 00:00:00 | 2024-08-13 00:00:00 | 2024-08-14 00:00:00 | 2024-08-15 00:00:00 | 2024-08-16 00:00:00 | 2024-08-17 00:00:00 | 2024-08-18 00:00:00 | 2024-08-19 00:00:00 | 2024-08-20 00:00:00 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 | 2024-08-23 00:00:00 | 2024-08-24 00:00:00 | 2024-08-25 00:00:00 | 2024-08-26 00:00:00 | 2024-08-27 00:00:00 | 2024-08-28 00:00:00 | 2024-08-29 00:00:00 | 2024-08-30 00:00:00 | 2024-08-31 00:00:00
Volume
Day | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Date | 2024-09-01 00:00:00 | 2024-09-02 00:00:00 | 2024-09-03 00:00:00 | 2024-09-04 00:00:00 | 2024-09-05 00:00:00 | 2024-09-06 00:00:00 | 2024-09-07 00:00:00 | 2024-09-08 00:00:00 | 2024-09-09 00:00:00 | 2024-09-10 00:00:00 | 2024-09-11 00:00:00 | 2024-09-12 00:00:00 | 2024-09-13 00:00:00 | 2024-09-14 00:00:00 | 2024-09-15 00:00:00 | 2024-09-16 00:00:00 | 2024-09-17 00:00:00 | 2024-09-18 00:00:00 | 2024-09-19 00:00:00 | 2024-09-20 00:00:00 | 2024-09-21 00:00:00
Volume
Spreadsheet: 824399d1680543214-comparing-two-lists-with-multiple-columns-lists
Sheet: VLOOKUP

La liste 2017 (au bas) contient les numéros
[NAME] transférer a la liste 2021.
J'ai mélangé les noms, sur la liste 2021
[NAME] fonctionne
Cette méthode utilise les "array" et a la fin
pour "entrer" la formule is faut faire
CTRL+SHIFT+ENTER puisqu'il y a un
un "array" dans la formule
Liste 2021
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Liste 2021 (sans les #N/A)
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Nouvelle liste (on met la cellule vide si elle
contient des 0)
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Liste 2017
Arsenault | Stéphane | V | 697-7803
Covo | [NAME] | V
Eastwood | [NAME] | v | 695-3197
Arcand | [NAME] | A | 695-2732
Beaulieu | Michel
Legault | [NAME]
Rozon | Gilles |  | 695-6565
Cross | [NAME] | X | 694-4895
Kelso | [NAME]
Du Preez | [NAME]