tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1227__UAE with 2 LM's & debt structure 04-21-00
Sheet: Debt

DEBT ISSUANCE | (This page is set up to solve for Debt Principal given DSCR, by using the Goal Seek Button)
('000 $)
EBITDA by Debt Fiscal Year
DSCR | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3
Target DS
Debt Principal | 68291.63156319613
Ending Balance at Maturity
 | 2001-04-01 00:00:00 | 2002-04-01 00:00:00 | 2003-04-01 00:00:00 | 2004-04-01 00:00:00 | 2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 2007-04-01 00:00:00 | 2008-04-01 00:00:00 | 2009-04-01 00:00:00 | 2010-04-01 00:00:00 | 2011-04-01 00:00:00 | 2012-04-01 00:00:00 | 2013-04-01 00:00:00 | 2014-04-01 00:00:00 | 2015-04-01 00:00:00 | 2016-04-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2019-04-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2023-04-01 00:00:00 | 2024-04-01 00:00:00 | 2025-04-01 00:00:00 | 2026-04-01 00:00:00 | 2027-04-01 00:00:00 | 2028-04-01 00:00:00 | 2029-04-01 00:00:00 | 2030-04-01 00:00:00 | 2031-04-01 00:00:00 | 2031-05-01 00:00:00
Beginning Balance
Addition |  | 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
Principal Payment
Interest Payment
Ending Balance
Pro-rata EBITDA
DSCR
(Debt Anniversary) | 2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-10-01 00:00:00 | 2006-10-01 00:00:00 | 2007-10-01 00:00:00 | 2008-10-01 00:00:00 | 2009-10-01 00:00:00 | 2010-10-01 00:00:00 | 2011-10-01 00:00:00 | 2012-10-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-10-01 00:00:00 | 2017-10-01 00:00:00 | 2018-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-10-01 00:00:00 | 2021-10-01 00:00:00 | 2022-10-01 00:00:00 | 2023-10-01 00:00:00 | 2024-10-01 00:00:00 | 2025-10-01 00:00:00 | 2026-10-01 00:00:00 | 2027-10-01 00:00:00 | 2028-10-01 00:00:00 | 2029-10-01 00:00:00 | 2030-10-01 00:00:00 | 2031-05-01 00:00:00
Beginning Balance
Addition | 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
Principal Payment
Interest Payment
Ending Balance
Pro-rata EBITDA
DSCR
Beginning Balance
Addition | 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
Interest Payment
Ending Balance
Debt Service
Principal Payments
Interest Expense
Net Debt Service
ACTUAL DSCR
Accrued Debt Service
Principal Payments
Interest Expense
Net Debt Service
 | Debt Summary
 | Treasury (%)
 | Spread (%)
 | All In Coupon Rate (%)
 | Term (years)
 | Average Life (years)
 | Total amount ($ '000)
 | DSCR |  | Average
 |  |  | Minimum
Time Factor | 0
Average Life
Spreadsheet: 328071d1403783099-dropdown-list-based-on-other-cells-vaue-opzetje_1
Sheet: Sheet2

 |  |  |  | Tarief (rate) depends on the values of Column D and E. Should be selected from Dropdown.
 |  |  |  |  |  |  | Toeslag (allowance)  depends on column D). Should be selected from Dropdown.
 | [NAME] | Zorgvrager | [NAME] | Tarief | aantal uren | totaal_1 | [NAME] (in %) | [NAME] (in €) | totaal
 | klant 1 | ALLcare |  | 10 | 2 |  | 20
 | klant 2
 | klant 3
 | klant 4
 |  |  |  |  |  |  |  | This column will (most likely) be hidden as well
 |  |  |  |  |  | This column will be hidden
Spreadsheet: 68460d1269000069-excel-2007-look-up-of-data-vlookup-test-for-stock-management
Sheet: Product Data

Full Code | Description | Page | RRP | Image | Material | Code | Size |  | Stock Variation
11001X | Metal Car | 1 | 2.91 | 1001 | 1 | 1001 | X
21001X | Plastic Car | 1 | 1.81 | 1001 | 2 | 1001 | X
51001 | Large Fire House | 10 | 43.55 | 1001 | 5 | 1001
11002X | Metal Bike | 2 | 2.91 | 1002 | 1 | 1002 | X
21002X | Plastic Bike | 2 | 1.81 | 1002 | 2 | 1002 | X
51002 | Large Hospital | 11 | 43.55 | 1002 | 5 | 1002
51003 | Large School | 11 | 43.55 | 1003 | 5 | 1003
11007E | Metal Bus (Med) | 3 | 4.7 | 1007 | 1 | 1007 | E
11007K | Metal Bus (Large) | 3 | 11 | 1007 | 1 | 1007 | K
21007E | Plastic Bus (Med) | 3 | 2.22 | 1007 | 2 | 1007 | E
Spreadsheet: 27cc0cbb-852c-474e-8c6a-04f3355dea0d
Sheet: General

GENERAL
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Amending Chapter 61 of the |  | 2011-05-01 00:00:00 |  | Amending Chapter 61 of the Codes of Ordinances
 | Codes of Ordinances
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Water Services Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Water Services Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | Water Services Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact |  |  |  |  |  |  |  | $60,000
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
 | Billings for impervious surfaces prior to 5/1/11, FY 2010-11 rates shall apply.
 | Billings for impervious surfaces on or after 5/1/11, the new rates shall apply.
Fact Sheet Prepared by:
Reviewed by:
 | [NAME]
 | Acting Director of Water Services
Reference Numbers |  | Chapter 61 Code of Ordinances
Spreadsheet: 828903d1683790061-formula-to-read-multiple-points-rounds-formulae
Sheet: Results

 | Player | X totals | Round 1 | Round 2 | Round 4 |  | Formulae works when value is 1, but nor for anything higherr (such as 2, 3 3tc.
 |  |  |  |  |  |  | Require formulae which calculates all Yes with result  in column C
 | Player 01
 | Player 02
 | Player 03
 | Player 04
 | Player 05 |  |  |  |  |  | Outcome choulld be 3
 | Player 06
 | Player 07 |  |  |  |  |  | Outcome choulld be 4
 | Player 08
 | Player 09
 | Player 10 |  |  |  |  |  | Outcome choulld be 5
 | Totals
Spreadsheet: 678748d1590049026-formula-not-calculating-charts
Sheet: Age Good WIP Mar

 | Good WIP - Order position :  1, 2, 10 & blank
 | <= 30 Days | >30 <=89 Days | >= 90 days | Target Line
1 | 83 | 24 | 167 | 200
2 | 137 | 23 | 167 | 200
3 | 166 | 23 | 165 | 200
4 | 203 | 20 | 161 | 200
5 | 246 | 20 | 161 | 200
6 | 205 | 15 | 166 | 200
7 | 204 | 15 | 165 | 200
8 | 178 | 15 | 165 | 200
9 | 176 | 13 | 167 | 200
10 | 158 | 18 | 166 | 200
11 | 176 | 18 | 166 | 200
12 | 196 | 19 | 166 | 200
13 | 227 | 19 | 166 | 200
14 | 235 | 16 | 166 | 200
15 | 220 | 16 | 165 | 200
16 | 227 | 16 | 165 | 200
17 | 237 | 16 | 165 | 200
18 | 252 | 16 | 164 | 200
19 | 256 | 16 | 164 | 200
20 | 272 | 13 | 163 | 200
21 | 325 | 13 | 161 | 200
22 | 308 | 13 | 161 | 200
23 | 271 | 13 | 161 | 200
24 | 272 | 13 | 161 | 200
25 | 257 | 13 | 161 | 200
26 | 207 | 41 | 162 | 200
27 | 178 | 41 | 161 | 200
28 | 169 | 41 | 161 | 200
29 | 179 | 38 | 162 | 200
30 | 210 | 38 | 162 | 200
31 | 263 | 38 | 108 | 200
Total
Spreadsheet: 676459d1588807619-trying-to-set-formula-to-divide-if-criteria-is-met-keep-getting-a-circular-reference-commission-sample
Sheet: FEB20

 | 2020-02-01 00:00:00
 | CUSTOMER NAME | STOCK # | COUNT |  |  |  |  |  |  | WORKING DAYS |  |  |  | TOTAL COMMISSION |  | UNADJUSTED Commission | FI Commission | + - BONUS | INVOICE | FI Gross | FE Gross | SALE PRICE | FE COMMISSION | N/U/S/CVP
 | [NAME] | JU518925 | 1
 | HOOD | 91184A | 1 |  |  |  |  |  |  | 25 | 25 |  |  |  |  |  |  |  |  | 315.36 | 869.39 |  |  | U
 | VEZAKIS | 90007 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 876.12 | -1449.06 |  |  | CVP
 | HUSKE | 200582 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1525 | -437.69 |  |  | CVP
 | DUTREMBLE | P7380A | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1980.65 |  |  | U
 | SANCHEZ | 200706 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88135 | 5487.15 | 3705.71 | 92910 |  | N
 | ESIPENKO | 200211 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47634 | 2269.04 | -3505.88 | 44843 |  | N
 |  |  |  |  |  | GOAL |  | +     -
 |  |  |  |  |  | 5
 |  |  |  |  |  | PACE |  |  | FI AVERAGE
 |  |  |  |  |  |  |  |  | FE AVERAGE
 |  |  |  |  |  | NEW |  | USED
 |  |  |  |  |  | SPRINTER |  | CVP
 |  | TOTAL
 | BONUSES:
 | FAST START 6TTL/2 NEW BY 15TH |  | 600 |  |  |  |  |  |  |  |  |  | MANUAL ENTRY |  | FRONT/ BACK TOTAL PAY
 | VOLUME 12-15 W/ 4 NEW |  | 1000 |  |  |  |  |  |  |  |  |  | MANUAL ENTRY |  | FAST START
 | VOLUME 15.5-20 W/ 5 NEW |  | 1200 |  |  |  |  |  |  |  |  |  | MANUAL ENTRY |  | VOLUME BONUS
 | VOLUME 20.5+ W/ 6 NEW |  | 1500 |  |  |  |  |  |  |  |  |  | MANUAL ENTRY |  | SALES PROFESSIONAL
 | SALES PROFESSIONAL |  | 1000 |  |  |  |  |  |  |  |  |  |  |  | SPRINTER BONUS
 | SPRINTER 4+ |  | 500 |  |  |  |  |  |  |  |  |  |  |  | CVP BONUS
 | CVP 5+ |  | 500 |  |  |  |  |  |  |  |  |  |  |  | CHARGEBACKS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Spreadsheet: 70698d1271411159-sumproduct-across-worksheets-test
Sheet: Sheet1

 | Date |  |  |  |  | Term |  | Month to report |  |  | Inst | [NAME] | idl | TOTALS |  |  | From | To
 | 2010-01-06 00:00:00 |  |  |  |  | inst |  | February |  |  | 4 | 6 | 1 | 11 |  | January | 2010-01-01 00:00:00 | 2010-01-31 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | inst |  |  |  |  |  |  |  |  |  | February | 2010-02-01 00:00:00 | 2010-02-28 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | inst |  |  |  |  |  |  |  |  |  | March | 2010-03-01 00:00:00 | 2010-03-31 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | inst |  |  |  |  |  |  |  |  |  | April | 2010-04-01 00:00:00 | 2010-04-30 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | May | 2010-05-01 00:00:00 | 2010-05-31 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | idl |  |  |  |  |  |  |  |  |  | June | 2010-06-01 00:00:00 | 2010-06-30 00:00:00
 | 2010-01-07 00:00:00 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | July | 2010-07-01 00:00:00 | 2010-07-31 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | August | 2010-08-01 00:00:00 | 2010-08-31 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | September | 2010-09-01 00:00:00 | 2010-09-30 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | October | 2010-10-01 00:00:00 | 2010-10-31 00:00:00
 | 2010-01-08 00:00:00 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | November | 2010-11-01 00:00:00 | 2010-11-30 00:00:00
 | 2010-02-08 00:00:00 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | December | 2010-12-01 00:00:00 | 2010-12-31 00:00:00
 | 2010-02-09 00:00:00 |  |  |  |  | [NAME]
 | 2010-02-10 00:00:00 |  |  |  |  | idl
 | 2010-02-11 00:00:00 |  |  |  |  | idl
 | 2010-02-12 00:00:00 |  |  |  |  | idl
 | 2010-02-13 00:00:00 |  |  |  |  | idl
 | 2010-02-14 00:00:00 |  |  |  |  | inst
 | 2010-02-15 00:00:00 |  |  |  |  | idl
 | 2010-02-16 00:00:00 |  |  |  |  | idl
 | 2010-02-17 00:00:00 |  |  |  |  | idl
 | 2010-02-18 00:00:00 |  |  |  |  | idl
 | 2010-03-13 00:00:00 |  |  |  |  | inst
 | 2010-03-14 00:00:00 |  |  |  |  | inst
 | 2010-03-15 00:00:00 |  |  |  |  | inst
 | 2010-03-16 00:00:00 |  |  |  |  | inst
 | 2010-03-17 00:00:00 |  |  |  |  | inst
 | 2010-03-18 00:00:00 |  |  |  |  | inst
 | 2010-03-19 00:00:00 |  |  |  |  | inst
 | 2010-03-20 00:00:00 |  |  |  |  | inst
 | 2010-03-21 00:00:00 |  |  |  |  | inst
 | 2010-03-22 00:00:00 |  |  |  |  | inst
 | 2010-03-23 00:00:00 |  |  |  |  | [NAME]
 | 2010-03-24 00:00:00 |  |  |  |  | idl
 | 2010-03-25 00:00:00 |  |  |  |  | idl
Spreadsheet: 593278d1539078808-sorting-table-problems-book1
Sheet: Sheet1

This is to enable a sensitivity analysis of the current leases and pricing landscape - each cell within the large green box is free for user entry
 | Lower weekly price bound - £ | Lower weekly price bound - £ | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Upper weekly price bound - £ | Upper weekly price bound - £ | 175
 | Global scatter of PAS/TAL leases | Global scatter of PAS/TAL leases as of 2-8-2018
ADM | TAL |  |  | 16
AST | PAS |  |  |  |  |  | 1 |  | 1
BLI/PAS | PAS |  |  |  | 11 | 9 | 4 |  | 12 |  |  | 2
BLI/TAL | TAL |  |  |  |  | 11
Crom | PAS |  |  |  |  |  |  | 1 |  |  | 1
Den | PAS |  |  |  | 1 | 23 | 2 | 38 | 10 | 2 | 24 | 8 |  |  | 12
DS | PAS |  |  |  |  |  |  |  | 2 |  |  |  | 3 |  |  | 1
FRES | PAS |  |  |  | 6 | 5 |  |  | 2 | 1 | 1 | 1
FS | PAS |  |  | 10 | 12 |  | 2 | 3 | 2 |  | 4 |  |  | 1 | 1
HE | PAS |  |  |  | 2 |  |  |  |  |  |  | 1
LONDON ON | PAS |  | 1 |  | 1 | 1 | 1 | 1 |  | 1 |  | 2
LONDON RE | PAS |  |  |  |  |  |  | 3 | 1 | 4
Mid | PAS |  | 1 | 4 | 4 | 55 | 1 | 73 | 23 | 12 | 20 | 13 | 2 |  | 3
MIDW | PAS |  |  | 1 | 1 | 10 |  | 9 | 13 | 3 | 3 | 4 |  | 1 | 4
No C | PAS
Norb | PAS |  |  |  | 1 | 10 | 7 | 1 | 16 | 3 | 4 | 4 |  | 2 | 1
Norb/TAL | TAL |  |  | 1 | 3
NORB/TAL2 | TAL |  |  | 3 | 1
Sey | PAS |  |  |  |  | 1 |  |  | 3 |  | 1
Shas | PAS |  |  | 1 |  | 2 | 5 |  | 2
STAN/PAS | PAS |  |  |  |  |  |  | 1
STANL/TAL | TAL |  |  |  |  | 84
WORLD | PAS |  |  |  | 1 |  | 4 |  | 2
Spreadsheet: df3a88a9-553b-48d5-921b-b362b36c024b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8530 | 63859 | [NAME] | Martinez | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:11:48
8530 | 63793 | Liliana | Montero | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:18:00
Spreadsheet: 834900d1688139493-consolidate-a-range-based-on-four-columns-consolidation-2-
Sheet: Sheet1 (2)

PRODUCT | REGION | REGION SALES |  | TOTAL REGION SALES
AAA | UK | 200
BBB | UK | 200
CCC | EUROPE | 300 |  |  |  |  |  |  |  |  | 1 | 1
DDD | EUROPE | 300 |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 737840d1624624563-formula-to-extract-items-from-one-list-not-present-in-a-second-list-book2
Sheet: Sheet1

List 1 | List 2 | Unique Values
A | B | A
B | D | C
C | E | G
D | F | H
E |  | I
F
G
H
I
Spreadsheet: 482616d1475154809-macro-to-separate-po-numbers-in-cell-and-enter-into-separate-cells-po-numbers
Sheet: Sheet1

Purchase Order Number | PO1 | PO2 | PO3 | PO4 | PO5 | PO6
[PHONE] [PHONE] [PHONE] [PHONE] [PHONE] | 4500038225 | 4500055358 | 4500056720 | 4500056720 | 4500067801
4500041868
4500045976
4500058122
[PHONE] - CTG [PHONE] - Bill in US $!! | 4500067732 | 4500065755
4500081801
[PHONE] - FSSC [PHONE] - CTG [PHONE] - Stoke Poges | 4500067398 | 4500067396 | 4500067397
4500067732
4500069078
4500069304
[PHONE] [PHONE]
4500069608
4500071253
4500087469
4500086143
4500084163
4500079575
4500075583
4500084390
4500077718
[PHONE] [PHONE]
4500077418
4500077599
4500080043
4500079643
4500084215
4500084263
4500085396
4500086562
4500085416
4500085416
4500089752
4500078225
4500086945
4500082522
[PHONE] [PHONE] [PHONE] [PHONE]
4500078886
4500088494
4500078886
4500083890
[PHONE] [PHONE] [PHONE] [PHONE]
4500079413
4500086797
4500079998
4500082604
[PHONE] [PHONE]
4500079830
[PHONE] [PHONE] - 16-0016
4500080645
4500080645
4500079488
4500080150
4500080142
4500080149
4500080053
4500085210
[PHONE] [PHONE] - 15-0247 [PHONE] - 15-0228
4500081360
4500081361
[PHONE] [PHONE] - 15-0249 & 15-0248 [PHONE] - 16-0066 [PHONE] - 16-0038 [PHONE] - 16-0095 Only
4500081841
4500081178
4500082996
4500083924
4500084213
4500086479
4500081551
4500079647
4500083926
4500083889
4500085591
4500088093
4500081262
4500079178
4500082605
4500083166
4500086726
4500081178
4500083944
4500084933
4500088947
4500085321
4500086979
4500085139
4500041868
4500087234
4500086059
4500087347
4500087104
[PHONE] [PHONE] [PHONE]
4500089592
4500089358
4500087526
4500088881
4500089635
Spreadsheet: 787302d1657720840-find-cell-based-on-date-index-and-matching-excelfiles1
Sheet: Blad2

What it should look like:
Transport | Last checkup | Next checkup week | Type of checkup
#1 | 2022-04-10 00:00:00 | 16 | GAS
#2 | 2022-03-25 00:00:00 | 16 | Oil,Gas,Battery
#3 | 2022-05-01 00:00:00 | 21 | Chain
… | … | … | …
Where I have been stuck
Transport | Last checkup | Next checkup | Type of checkup
#1
#2
#3
Spreadsheet: 106998d1304142890-counting-multiple-cells-with-different-items-book1
Sheet: Sheet1

 | Location | response | Date
 | Area 1 | 1st | 2010-11-16 00:00:00 |  |  | Area 1 | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | April
 | Area 2 | 2nd | 2010-12-01 00:00:00 |  |  | 1st
 | Area 3 | 2nd | 2011-03-01 00:00:00 |  |  | 2nd
 | Area 4 | 1st | 2010-09-27 00:00:00 |  |  | 3rd
 | Area 2 | 4th | 2011-02-17 00:00:00 |  |  | 4th
 | Area 1 | 1st | 2011-03-23 00:00:00 |  |  | 5th
 | Area 2 | 3rd | 2011-03-14 00:00:00 |  |  | GT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Area 2 | 1st | 2010-10-25 00:00:00
 | Area 3 | 2nd | 2011-02-23 00:00:00
 | Area 2 | 3rd | 2011-02-09 00:00:00 |  |  | Area 2 | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | April
 | Area 4 | 1st | 2010-10-25 00:00:00 |  |  | 1st
 | Area 2 | 2nd | 2010-09-09 00:00:00 |  |  | 2nd
 | Area 1 | 3rd | 2010-09-20 00:00:00 |  |  | 3rd
 | Area 3 | 1st | 2011-02-28 00:00:00 |  |  | 4th
 | Area 2 | 2nd | 2010-10-07 00:00:00 |  |  | 5th
 | Area 2 | 4th | 2010-11-09 00:00:00 |  |  | GT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Area 1 | 1st | 2010-11-16 00:00:00
 | Area 4 | 1st | 2010-12-06 00:00:00
 | Area 3 | 1st | 2010-12-06 00:00:00 |  |  | Area 3 | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | April
 | Area 3 | 1st | 2011-02-07 00:00:00 |  |  | 1st
 | Area 4 | 3rd | 2010-07-09 00:00:00 |  |  | 2nd
 | Area 3 | 2nd | 2011-01-19 00:00:00 |  |  | 3rd
 | Area 1 | 3rd | 2010-09-22 00:00:00 |  |  | 4th
 | Area 2 | 1st | 2010-12-06 00:00:00 |  |  | 5th
 | Area 2 | 3rd | 2010-12-28 00:00:00 |  |  | GT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Area 4 | 1st | 2010-10-07 00:00:00
 | Area 1 | 5th | 2011-01-25 00:00:00
 | Area 3 | 4th | 2011-01-14 00:00:00 |  |  | Area 4 | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | April
 | Area 1 | 2nd | 2010-12-13 00:00:00 |  |  | 1st
 | Area 4 | 1st | 2011-01-31 00:00:00 |  |  | 2nd
 | Area 2 | 2nd | 2011-03-03 00:00:00 |  |  | 3rd
 | Area 3 | 2nd | 2011-02-16 00:00:00 |  |  | 4th
 | Area 3 | 1st | 2011-01-20 00:00:00 |  |  | 5th
 | Area 1 | 3rd | 2011-01-10 00:00:00 |  |  | GT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Area 2 | 3rd | 2011-01-24 00:00:00
Spreadsheet: 63747d1264616281-euclidean-distance-matrix-prototype-software
Sheet: Normalization

 | Attribute
Group | Risk |  |  |  |  |  |  |  | R Value | Cost |  |  |  |  |  |  |  |  | C Value | Performance |  |  |  |  |  |  |  | p Value
item | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Sept23-Sept29m

Main Arena
 | 2012-09-23 00:00:00 |  |  | Thru | 2012-09-29 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-09-23 00:00:00 | 2012-09-24 00:00:00 | 2012-09-25 00:00:00 | 2012-09-26 00:00:00 | 2012-09-27 00:00:00 | 2012-09-28 00:00:00 | 2012-09-29 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 828638d1683651626-finding-the-position-of-a-value-in-a-column-when-conditionally-filtering-sample-sheet-match-with-conditional-filtering-error
Sheet: Sheet1

 | names | values
 | [NAME] | 75
 | sammy | 80
 | jenny | 14
 | [NAME] | 10
 | roni | 24
 | chrissy | 20
 | [NAME] | 15
 | brianna | 90
 | [NAME] | 23
 | [NAME] | 22
Spreadsheet: 858711d1707297968-average-dispatch-per-month-slow-turn-over
Sheet: Slow Moving Stock

 | Category | Article | Article Description | [NAME] | Receipt Date | Dispatched Qty | Last Billing Date | SOH | UoM | [NAME] | MAP | Inventory Value | Shelf Life Remaining | Days in Inventory | Remarks | Average Dispatch per Month
 | XYZ | XYZ | XYZ | 5000 | 2022-11-09 00:00:00 |  | 2024-02-06 00:00:00 | 2994 | EA | 2024-10-01 00:00:00 | 3.85
 |  |  | Total
Spreadsheet: 453029d1459114620-formula-to-return-the-sum-of-absolute-differences-of-all-values-in-a-given-row-summing-absolute-differences
Sheet: Summing Absolute Differences

THE DIFFERENCE BETWEEN: A2 & B2 = 3 (SEE B4); B2 & C2 = 7 (SEE C4); C2 & D2 = 13 (SEE D4); D2 & E2 = 14 (SEE E4); E2 & F2 = 7 (SEE F4); F2 & G2 = 11 (SEE G4); AND THE SUM OF ALL THOSE ABSOLUTE DIFFERENCES = 55 (SEE H4).  Instead of manually calculating the sum of all these absolute difference, I would rather have a formula produce the sum in cell H2.
7 | 10 | 3 | 16 | 2 | 9 | 20
 | Difference between A2 & B2 = 3 | Difference between B2 & C2 = 7 | Difference between C2 & D2 = 13 | Difference between D2 & E2 = 14 | Difference between E2 & F2 = 7 | Difference between F2 & G2 = 11
 | 3 | 7 | 13 | 14 | 7 | 11