tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 25686d1217160367-continuation-of-car-ownership-database-2-car-ownership-database
Sheet: 2008

INPUT |  |  |  |  |  |  |  |  |  | CALC | INPUT | CALC
Car Ownership Database |  |  |  | Today is the: |  | 2008-07-27 00:00:00 |  |  |  |  |  | PLEASE CHECK MOT DUE LIST
Forename | Surname | Home Phone No | Mobile No | [NAME] | Car Model | Car Registration | Description of work done | Date work done | Car Milage | Cambelt needs replacing? | Date of last MOT | Is MOT due?
[NAME] | Bloggs | 01428 724657 | [PHONE] | Bentley | 5TX | 1ZY 6NU | New Exhaust | 2005-03-02 00:00:00 | 60000 | Cambelt Needs Replacing | 2008-02-03 00:00:00 | Yes
[NAME] | [NAME] | 01224 593922 | [PHONE] | Audi | SX2 | 1ny 7ui | Repaired engine |  | 60000 | Cambelt Needs Replacing |  | Yes
 |  |  |  |  |  |  |  |  | 60000 | Cambelt Needs Replacing |  | Yes
Spreadsheet: 836146d1689127167-simple-formula-to-describe-to-user-what-is-missing-test-sheet
Sheet: Sheet1

 | A | B | C | Needed
1 | apple |  |  | banana is needed and orange is needed
2 |  | banana | orange | apple is needed
3 | apple | banana |  | orange is needed
4 |  |  | orange | apple is needed and banana is needed
5 | apple |  | orange | banana is needed
6 |  |  |  | apple is needed and banana is needed and orange is needed
7 |  | banana |  | apple is needed and orange is needed
 | A | B | C | Needed
1 | 2023-12-01 00:00:00 |  |  | banana is needed and orange is needed
2 |  | 2023-03-05 00:00:00 | 2023-06-07 00:00:00 | apple is needed
3 | 2022-01-02 00:00:00 | 2021-04-07 00:00:00 |  | orange is needed
4 |  |  | 2023-04-08 00:00:00 | apple is needed and banana is needed
5 | 2022-08-09 00:00:00 |  | 2023-09-01 00:00:00 | banana is needed
6 |  |  |  | apple is needed and banana is needed and orange is needed
7 |  | 2022-08-30 00:00:00 |  | apple is needed and orange is needed
Spreadsheet: 800954d1666009371-extract-information-from-different-sheets-in-a-workbook-new-sample-file
Sheet: Result

Group | Display Name | [NAME] | Department
Group1 | TEST Name1 | ABCD | Finance
Group1 | TEST Name2 | TEST1 | Procurement
Group1 | TEST Name3 | ZADCG | Finance
Group1 | TEST Name4 | OUIDHK | General Management
Group2 | TEST Name5 | JKLDJO | Finance
Group2 | TEST Name6 | JFHUIKD | Procurement
Group2 | TEST Name7 | NBHDFL | Finance
Group2 | TEST Name8 | [NAME] | General Management
Spreadsheet: 456920d1461124372-how-to-add-up-certain-columns-sum-up
Sheet: Sheet1

 |  |  |  |  |  |  |  | April | 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
 |  |  |  |  |  |  |  | Total
Sr | Area | Territory | Customer | Name 1 | Sales point | Telephone | Telephone 2 | Dealer OL | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity | Plan | Actual | Farmer visits | MD Activity
1 | Khanewal | Khanewal | 102317 | [NAME] |  |  |  |  | x |  |  | MFM
2 | Khanewal | Khanewal | 102185 | Butt Zarai Service |  |  |  |  |  | x | 2
3 | Khanewal | Khanewal | 102889 | National Trading House |  |  |  |  | x |  | 2 | MFM
4 | Khanewal | Khanewal | 400455 | [NAME] |  |  |  |  | x | x
5 | Khanewal | Khanewal | 500176 | [NAME] |  |  |  |  |  |  |  | [NAME]
6 | Khanewal | Khanewal | 500024 | [NAME]
7 | Khanewal | Khanewal | 400460 | Target Zarai Markaz
8 | Khanewal | Khanewal | 103825 | [NAME]
9 | Khanewal | Khanewal | 104215 | [NAME]
10 | Khanewal | Khanewal | 103648 | [NAME]
11 | Khanewal | Khanewal | 500554 | Sheikh Arshad and Co.
12 | Khanewal | Khanewal | 102896 | [NAME]
13 | Khanewal | Khanewal | 102999 | [NAME]
14 | Khanewal | Khanewal | 102385 | Dawood Traders
15 | Khanewal | Khanewal | 104323 | Akbar Brothers
16 | Khanewal | Khanewal | 104289 | [NAME]
17 | Khanewal | Khanewal | 103926 | Awais Traders
18 | Khanewal | Khanewal | 103700 | Hamza Commission Shop
19 | Khanewal | Khanewal | 102868 | Haq Fareed Traders
20 | Khanewal | Khanewal | 104270 | Madina Trading Company
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: N75 DFA

 |  |  |  |  | N75 DFA
Registration number : | N75 DFA |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | Volkswagen |  | 1996-07-31 00:00:00 | 12 Months | 1997-08-01 00:00:00 | 140
Specification : | Golf |  | 1997-07-31 00:00:00 | 12  Months | 1998-08-01 00:00:00 | 145
Type : | Car |  | 1998-07-31 00:00:00 | 12 Months | 1999-08-01 00:00:00 | 150
1st Registered : | n/a |  | 1999-07-31 00:00:00 | 12 Months | 2000-08-01 00:00:00 | 155
Engine : | Diesel |  | 2000-07-31 00:00:00 | 12 Months | 2001-08-01 00:00:00 | 155
[NAME] : |  |  | 2001-07-31 00:00:00 | 12 Months | 2002-08-01 00:00:00 | 160
 |  |  | 2002-07-31 00:00:00 | 12 Months | 2003-08-01 00:00:00 | 160
 |  |  | 2003-07-31 00:00:00 | 12 Months | 2004-08-01 00:00:00 | 165
 |  |  | 2004-07-30 00:00:00 | 12 Months | 2005-08-01 00:00:00 | 165
Back To Index |  |  | 2005-07-29 00:00:00 | 12 Months | 2006-08-01 00:00:00 | 170
 |  |  | 2006-07-31 00:00:00 | 12 Months | 2007-08-01 00:00:00 | 175
 |  |  | 2007-07-31 00:00:00 | 12 Months | 2008-08-01 00:00:00 | 180
 |  |  | 2008-07-31 00:00:00 | 12 Months | 2009-08-01 00:00:00 | 185
 |  |  | 2009-07-31 00:00:00 | 12 Months | 2010-08-01 00:00:00 | £190 + £2.50 (online fee)
 |  |  | 2010-07-30 00:00:00 | 12 Months | 2011-08-01 00:00:00 | 205
 |  |  | 2011-07-28 00:00:00 | 12 Months | 2012-08-01 00:00:00 | 215
Spreadsheet: 674635d1587969635-how-to-populate-cells-from-above-from-another-column-array-populate-cells-from-above-from-another-column
Sheet: Sheet1

Unformattable array |  |  | Expected result which i do not know how to get to
TGS\\4541\\27APR20\\1 |  |  | TGS\\4541\\27APR20\\1
 | P_SPVS |  | TGS\\4541\\27APR20\\1
 | P_SPVS_SIP_VS |  | TGS\\4541\\27APR20\\1
722314\\VB0057\\FILL\\X23 |  |  | 722314\\VB0057\\FILL\\X23
 | P_HOLD_PRE |  | 722314\\VB0057\\FILL\\X23
 | P_HOLD_PROD |  | 722314\\VB0057\\FILL\\X23
 | OP_HOLD |  | 722314\\VB0057\\FILL\\X23
 | OP_HOLD_ |  | 722314\\VB0057\\FILL\\X23
TWE\\4320\\27APR10\\1 |  |  | TWE\\4320\\27APR10\\1
 | OP_PVS_PRE |  | TWE\\4320\\27APR10\\1
 | OP_P |  | TWE\\4320\\27APR10\\1
 | OP_PVS_CIP_V |  | TWE\\4320\\27APR10\\1
 | OP_PVS_CIP_V |  | TWE\\4320\\27APR10\\1
 | OP_PVS_CIP_V |  | TWE\\4320\\27APR10\\1
 | OP_PVS_CIP_V |  | TWE\\4320\\27APR10\\1
Spreadsheet: 8bd66515-8fd4-4cf1-8369-a9c5ba382a0d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2834 | 15496 | Uli | Mutscheller | GER | 0 | 00:23:00 | 00:00:48 | 00:25:56 | 00:01:23 | 00:28:07 | 1 | 01:19:16
2834 | 15497 | [NAME] | Bergersen | GER | 0 | 00:27:40 | 00:01:00 | 00:30:37 | 00:01:18 | 00:33:34 | 2 | 01:34:10
2834 | 15498 | [NAME] | Granlund | SWE | 0 | 00:29:15 | 00:01:33 | 00:32:40 | 00:03:13 | 00:34:57 | 3 | [NAME]
Spreadsheet: 867631d1714459605-need-attendace-sheet-for-saleman-visited-diffrent-regions-with-different-items-book4-12-aligw-2-
Sheet: Sheet1

 |  | Salesman | Items | Region |  |  |  |  |  |  |  |  |  | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME] | REG-7
 |  | Salesman101 | Item-1 | REG-1 |  |  |  |  |  |  |  |  | Salesman101 | 0.3333333333333333 |  | 0.6666666666666666
 |  | Salesman101 | Item-2 | REG-3 |  |  |  |  |  |  |  |  | Salesman111 | 0.1111111111111111 |  | 0.4444444444444444 |  | 0.1111111111111111 | 0.3333333333333333
 |  | Salesman101 | Item-3 | REG-3 |  |  |  |  |  |  |  |  | Salesman121 |  |  |  |  |  |  | 1
 |  | Salesman111 | Item-1 | [NAME] |  |  |  |  |  |  |  |  |  | 0.1481481481481481 |  | 0.3703703703703704 |  | 0.03703703703703703 | 0.1111111111111111 | 0.3333333333333333
 |  | Salesman111 | Item-2 | REG-3
 |  | Salesman111 | Item-3 | REG-1
 |  | Salesman111 | Item-4 | REG-3
 |  | Salesman111 | Item-5 | REG-3
 |  | Salesman111 | Item-6 | [NAME]
 |  | Salesman111 | Item-7 | REG-3
 |  | Salesman111 | Item-8 | REG-5
 |  | Salesman111 | Item-9 | [NAME]
 |  | Salesman121 | Item-1 | REG-7
 | Items | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME] | REG-7
Salesman101 | Item-2 |  |  | 0.3333333333333333
Salesman101 | Item-3 |  |  | 0.3333333333333333
Salesman111 | Item-1 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-2 |  |  | 0.1111111111111111
Salesman111 | Item-3 | 0.1111111111111111
Salesman111 | Item-4 |  |  | 0.1111111111111111
Salesman111 | Item-5 |  |  | 0.1111111111111111
Salesman111 | Item-6 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-7 |  |  | 0.1111111111111111
Salesman111 | Item-8 |  |  |  |  | 0.1111111111111111
Salesman111 | Item-9 |  |  |  |  |  | 0.1111111111111111
Salesman121 | Item-1 |  |  |  |  |  |  | 1
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 22

 |  | Net Notional Outstanding
Product Type |  | Cleared** | Uncleared
Total Metals* | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Energy | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Agricultural | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Index | Exotic
 | Option
 | Spot/Forward
 | Swap
Total Other*** | Exotic
 | Option
 | Spot/Forward
 | Swap
TOTAL |  | N/A**** | N/A
Estimated net notional amount outstanding, October 25 weekly snapshot, by product type and cleared status (millions of USD), all participant types, tenors, and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***Environment, Freight, Multi-Commodity Exotic
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 724448d1616164676-get-date-from-table-to-other-sheet-planning-2021-week-11b-1-ans
Sheet: Info

 |  | Cell C4 value changed
 | Dosier N° | N° | Werfomschrijving | N°2 | ∑ PW | ∑ BA | Latei ft ≠ St. | ∏ | ꙱ | Column1 | Column2 | Column3 | G.F.⌠ | G.M.₼ | Column4 | Dat. S12 | N° lot | Dat. S32 | Leverdat. | Verbo N° | TDL-N° | Koer N° | Naar werf | Terug
 | 202000021
Spreadsheet: 684015d1593098411-how-did-they-do-this-example
Sheet: BIOCHEMICAL REACTIONS,LAB

Letter | BACTERIA | Gram Reaction | Morphology | Motility | [NAME] | Catalase | Oxidase | Glucose Acid/Gas | Lactose Acid/Gas | Mannitol Acid/Gas | Sucrose Acid/Gas | Tryptophan (Indole) | Nitrate Reduction | Simmons citrate | H2S | Slant | Butt | Gas | MR-VP | [NAME] (amylase) | [NAME] (lipase) | Urease | [NAME] (PPA) | Milk (Caseinase) | Oxygen Requirement | Optimal temperature | Letter
Spreadsheet: kate_symes__18413__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | 2000-12-22 00:00:00 |  | 474.38 | 3200 | 290.77 | 1408 | 484.27 | 1335 | 300 | 25
 | 2000-12-21 00:00:00 |  | 476.11 | 3600 | 290.77 | 1408 | 500 | 1175 | 450 | 600
 | 2000-12-20 00:00:00 |  | 465.71 | 2800 | 375 | 200 | 529.93 | 2100 | 550 | 200
 | 2000-12-19 00:00:00 |  | 450 | 2400 | 346.89 | 1608 | 477.03 | 1720 | 210 | 697
 | 2000-12-18 00:00:00 |  | 377 | 2000 | 325 | 400 | 593.64 | 3048 | 423.21 | 1126
 | 2000-12-17 00:00:00 |  |  |  |  |  |  |  | 551.77 | 2065 |  | 325 | 600
 | 2000-12-16 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 587.5 | 1400 | 537.5 | 1200
 | 2000-12-15 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 571.38 | 3975 | 517.59 | 3375
 | 2000-12-14 00:00:00 |  | 484.61 | 5200 | 256.22 | 1608 | 654.11 | 730 | 437.04 | 1340
 | 2000-12-13 00:00:00 |  | 688.24 | 6800 | 500 | 200 | 454.83 | 6475 | 350 | 100
 | 2000-12-12 00:00:00 |  | 818.75 | 3200 | 300 | 200 | 800 | 0 | 600 | 0
 | 2000-12-11 00:00:00 |  | 3200 | 2800 | 1187.5 | 400 | 597.15 | 1192 | 561.22 | 245
 | 2000-12-10 00:00:00 |  |  |  |  |  |  |  | 740.4 | 5823 |  | 1187.5 | 1200
 | 2000-12-09 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 450 | 450 | 487.5 | 0
 | 2000-12-08 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 325 | 630 | 487.5 | 0
 | 2000-12-07 00:00:00 |  | 679.17 | 2400 | 412.5 | 400 | 505.96 | 235 | 320.47 | 265
 | 2000-12-06 00:00:00 |  | 357.3 | 9600 | 275 | 800 | 342 | 858 | 237.5 | 200
 | 2000-12-05 00:00:00 |  | 278.47 | 7600 | 245 | 200 | 388 | 125 | 237.5 | 0
 | 2000-12-04 00:00:00 |  | 283.12 | 10000 | 255 | 400 | 281.5 | 0 | 255 | 0
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 298721d1392890424-will-a-count-if-formula-work-to-obtain-the-required-data-copy-of-programme-application-tracker-v0-2
Sheet: Lists

Decommission in situ | [NAME] | 1 | UK | DEV
Migrate | [NAME] | 2 | Singapore | Prod
Out of Scope | [NAME] | 3 | Trumbull - Digital Realty | QA
In review | [NAME] | 4 |  | DR
Awaiting review |  |  |  | Test
 |  |  |  | PreProd
Spreadsheet: 484250d1476193061-how-to-sort-table-with-subtotal-sumif-values-in-row-and-preserve-formula-integrity-example_sheet
Sheet: EXAMPLE

VARIABLE | COUNTRY | GROUP | 2014 YEAR | 2015 YEAR
Grape | Albania | Group ALFA
Grape | Bosnia Herzegovina | Group ALFA | 150000 | 400000
Grape | Bulgaria | Group ALFA | 200000 | 424000
Grape | Croatia | Group ALFA | 260000 | 250000
Grape | Greece | Group ALFA | 100000 | 70000
Grape | Macedonia | Group ALFA | 5000 | 16000
Grape | Serbia | Group ALFA | 870000 | 240000
Grape | Slovenia | Group ALFA | 63000 | 30000
Grape | Total Group ALFA | Group ALFA
Grape | Czech Republic | Group BETA | 336000 | 320000
Grape | Hungary | Group BETA | 1500000 | 500000
Grape | Slovakia | Group BETA | 100000 | 270000
Grape | Poland | Group BETA | 900000 | 800000
Grape | France | Group BETA | 3000000 | 2920000
Grape | Morocco | Group BETA | 20000 | 70000
Grape | Total Group BETA | Group BETA
Grape | Italy | Group GAMMA | 5000000 | 4250000
Grape | Total Group GAMMA | Group GAMMA
Grape | Total Groups | Groups
Chestnuts | Albania | Group ALFA | 0 | 0
Chestnuts | Bosnia Herzegovina | Group ALFA | 120000 | 120000
Chestnuts | Bulgaria | Group ALFA | 250000 | 700000
Chestnuts | Croatia | Group ALFA | 300000 | 200000
Chestnuts | Greece | Group ALFA | 80000 | 1000
Chestnuts | Macedonia | Group ALFA | 1000 | 1000
Chestnuts | Serbia | Group ALFA | 900000 | 800000
Chestnuts | Slovenia | Group ALFA | 30000 | 58000
Chestnuts | Total Group ALFA | Group ALFA
Chestnuts | Czech Republic | Group BETA | 200000 | 340000
Chestnuts | Hungary | Group BETA | 1200000 | 990000
Chestnuts | Slovakia | Group BETA | 1350000 | 265000
Chestnuts | Poland | Group BETA | 1120000 | 1153000
Chestnuts | France | Group BETA | 3480000 | 5000000
Chestnuts | Morocco | Group BETA | 77000 | 74000
Chestnuts | Total Group BETA | Group BETA
Chestnuts | Italy | Group GAMMA | 300000 | 280000
Chestnuts | Total Group GAMMA | Group GAMMA
Chestnuts | Total Groups | Groups
Spreadsheet: 796099d1663097354-need-to-calculate-top-5-items-based-on-data-and-to-place-the-results-in-cells-using-commas-2022-09-13-oeldere-pankaj-jaswani-excel-forum-help_top-and-bottom-result-with-textjoin-comma-va
Sheet: Sample Data

[NAME] | [NAME] | IN Stock | OUT Stock | Avg. Sale | Market Stock | Stock Days | Group
Model_1 | Running | 200 | 50 | 10 | 100 |  |  |  |  |  |  | Data Needed | Result
Model_2 | Discontinue | 0 | 25 | 5 | 88 |  |  |  |  |  |  | Slow Moving Models (Top5) - M1, [NAME], M3, M4, M5
Model_3 | Running | 50 | 35 | 7 | 145 |  |  |  |  |  |  | Fast Moving Models (Top5 )- M1, [NAME], M3, M4, M5
[NAME] | Running | 300 | 175 | 35 | 850 |  |  |  |  |  |  | Highest Stock Days (Top5) - M1, [NAME], M3, M4, M5
Model_5 | Running | 1000 | 400 | 80 | 1600 |  |  |  |  |  |  | Lowest Stock Days (Top5) -M1, [NAME], M3, M4, M5
Model_6 | Running | 500 | 325 | 65 | 500
Model_7 | Discontinue | 0 | 65 | 13 | 80
Model_8 | Running | 0 | 10 | 2 | 40 |  |  |  |  |  |  | 0 | Fast
Model_9 | Discontinue | 0 | 5 | 1 | 5 |  |  |  |  |  |  | 10 | Medium
Model_10 | Discontinue | 0 | 55 | 11 | 90 |  |  |  |  |  |  | 20 | Slow
Model_11 | Discontinue | 0 | 90 | 18 | 950 |  |  |  |  |  |  | 30 | [NAME]
[NAME] | Running | 300 | 175 | 35 | 250
Model_13 | Running | 450 | 190 | 38 | 200 |  |  |  |  |  | Rijlabels | Som van Stock Days
Model_14 | Running | 600 | 370 | 74 | 450 |  |  |  |  |  | Fast | 35
[NAME] | Running | 1200 | 575 | 115 | 1500 |  |  |  |  |  | Model_10 | 8
Model_16 | Running | 500 | 250 | 50 | 600 |  |  |  |  |  | [NAME] | 7
Model_17 | Running | 600 | 155 | 31 | 1100 |  |  |  |  |  | Model_14 | 6
Model_18 | Discontinue | 0 | 15 | 3 | 50 |  |  |  |  |  | Model_6 | 8
Model_19 | Running | 100 | 150 | 30 | 150 |  |  |  |  |  | Model_7 | 6
Model_20 | Running | 700 | 275 | 55 | 650 |  |  |  |  |  | Medium | 72
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 13
 |  |  |  |  |  |  |  |  |  |  | Model_16 | 12
 |  |  |  |  |  |  |  |  |  |  | Model_18 | 17
 |  |  |  |  |  |  |  |  |  |  | Model_2 | 18
 |  |  |  |  |  |  |  |  |  |  | Model_20 | 12
 |  |  |  |  |  |  |  |  |  |  | Slow | 85
 |  |  |  |  |  |  |  |  |  |  | Model_3 | 21
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 24
 |  |  |  |  |  |  |  |  |  |  | Model_5 | 20
 |  |  |  |  |  |  |  |  |  |  | Model_8 | 20
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 88
 |  |  |  |  |  |  |  |  |  |  | Model_11 | 53
 |  |  |  |  |  |  |  |  |  |  | Model_17 | 35
 |  |  |  |  |  |  |  |  |  |  | Eindtotaal | 280
Spreadsheet: 876184d1722865329-quote-template-help-paul_t-quote-template-05_08_24-aligw
Sheet: Pack01

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES |  | (COMPLEXITY LEVEL →) |  | LEVEL 1 | LEVEL 2 | LEVEL 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO |  | (BAND DESCRIPTION) | BAND | HOURS | HOURS | HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 TO 6 HOLES | A | 2.75 | 3 | 3.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 TO 12 HOLES | B | 2.25 | 2.5 | 2.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 TO 20 HOLES | C | 1.75 | 2 | 2.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 TO 30 HOLES | D | 1.25 | 1.5 | 1.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 TO 50 HOLES | E | 1 | 1.25 | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 TO 100 HOLES | F | 0.75 | 1 | 1.25
 |  | CENTRE FUSE DRILL TOOL QUOTE PACK 01
QUOTE PACK | TOOL NUMBER | TOOL [NAME] | NO# DRILL BARS LH | NO# DRILL BARS RH | LH/RH | ITEM NUMBER | NUMBER HOLES | COMPLEXITY | PINS | BARREL NUTS | STORAGE CASE | BAE COMMENTS |  | Hours | Hrs Cost | Material | Total Cost | Sub Con Comment
1 | ZRDXXXXXX | XXXXXXXXXXXX |  |  |  |  |  | LEVEL 1 TO 3 | TOTAL NUMBER | TOTAL NUMBER | YES
 |  |  | 1 |  | LH | 1 | 35 | LEVEL 1
 |  |  |  | 1 | RH | 1 | 35 | LEVEL 1 |  |  |  |  |  | 35 | 2695 | 150 | 2845
 |  |  |  |  |  |  |  |  | PINS/ BUSHES & STORAGE CASE TOTALS
Spreadsheet: 155201d1336718894-excel-2007-generating-automated-timesheet-timesheet-1
Sheet: Leave

EXIDE INDUSTRIES LIMITED |  | From | To | No of
[NAME] | 114 | 2012-03-21 00:00:00 | 2012-03-26 00:00:00 | 1
MANJUSHA PAUL | 1084 | 2012-03-26 00:00:00 | 2012-03-26 00:00:00 | 1
 | 1084 | 2012-03-27 00:00:00 | 2012-03-27 00:00:00 | 1
 | 1084 | 2012-03-28 00:00:00 | 2012-03-31 00:00:00 | 1
SUBRATA GHOSH | 1173 | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 | 4
[NAME] | 1230 | 2012-03-21 00:00:00 | 2012-03-21 00:00:00 | 1
RAU MANDALIKA BHASKAR VENKATA | 1471 | 2012-03-23 00:00:00 | 2012-03-23 00:00:00 | 0.5
TILOTTAMA DAS | 1513 | 2012-04-07 00:00:00 | 2012-04-07 00:00:00 | 1
 | 1513 | 2012-04-20 00:00:00 | 2012-04-20 00:00:00 | 0.5
[NAME] | 1756 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2
 | 1756 | 2012-04-20 00:00:00 | 2012-04-20 00:00:00 | 1
SANDIP PRADHAN | 1834 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00 | 1
MANASI BISWAS | 6031 | 2012-03-21 00:00:00 | 2012-03-21 00:00:00 | 1
SUDIPTO ROY | 6057 | 2012-03-31 00:00:00 | 2012-04-08 00:00:00 | 9
MIR GEASHUDDIN AHAMMED | 6505 | 2012-04-06 00:00:00 | 2012-04-06 00:00:00 | 1
KRANTI CHOWDHURY MALLICK | 6510 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00 | 0.5
SHIVENDER KUMAR GAUTAM | 7978 | 2012-03-19 00:00:00 | 2012-03-25 00:00:00 | 7
SUSHOVIT MISHRA | 8102 | 2012-03-21 00:00:00 | 2012-03-21 00:00:00 | 0.5
KALYANI BHOWMICK | 8211 | 2012-03-27 00:00:00 | 2012-03-27 00:00:00 | 1
[NAME] | 8327 | 2012-04-09 00:00:00 | 2012-04-09 00:00:00 | 1
MD ASIF IKBAL MUNSHI | 8489 | 2012-04-06 00:00:00 | 2012-04-13 00:00:00 | 8
KAUSTAV HALDER | 8569 | 2012-04-06 00:00:00 | 2012-04-06 00:00:00 | 0.5
 | 8569 | 2012-04-10 00:00:00 | 2012-04-16 00:00:00 | 0.5
Spreadsheet: 73960d1274526838-2-bars-in-one-not-stacked-730185
Sheet: Sheet1

 | Budget | Actual |  |  |  |  | Budget | Actual | Budget
a | 100 | 50 |  |  |  | a | 100 | 50 | 0
b | 75 | 75 |  |  |  | b | 0 | 75 | 0
c | 50 | 100 |  |  |  | c | 0 | 100 | 50