tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 26803d1219328235-will-sumif-do-this-keep-top-80-pct
Sheet: Sheet1

 | All Items Shown as a Percentage of Total Brand Sales by Region. |  |  |  |  |  |  |  | 11
 | Bread |  | Milk | Milk | Juice | Juice |  |  | Milk |  |  |  | Juice
Atlantic
Connecticut |  |  | 22 | 22 |  | 1.670090906899111 |  | 22 | 22 | 22 | 22 | 2 | 46 | 46 | 46
Delaware |  |  |  | 1 |  | 0.8879566441012168 |  | 1 | 16 | 38 | 16 | 1 | 32 | 78 | 32
Georgia | 38.62848962061561 | Column B Shows the Result that I would like to see | 16 | 16 | 32.1963291884062 | 32.1963291884062 |  | 16 | 16 | 54 | 16 | 32 | 7 | 85
Maine |  |  |  | 0.611927371020253 |  | 0.6235310139725944 |  | 1 | 13 | 67 | 13 | 1 | 7 | 92
Massachusetts | 12.72211882605584 |  | 13 | 13.37741224980386 | 46.08916578209843 | 46.08916578209843 |  | 13 | 12 | 79 | 12 | 46 | 3 | 95
New Hampshire |  |  |  | 10 |  | 0.05212925187355789 |  | 10 | 10 | 89 |  | 0 | 2 | 97
New Jersey | 12.97523264137437 |  | 16 | 16 |  | 7.354655500580915 |  | 16 | 8 | 97 |  | 7 | 1 | 98
North Carolina | 9.009878310665714 |  | 12 | 12.30087335634231 |  | 7.370163953013301 |  | 12 | 1 | 98 |  | 7 | 1 | 99
Rhode Island |  |  |  | 8 |  | 2.520579651216208 |  | 8 | 1 | 99 |  | 3 | 1 | 100
Tennessee | 9.81617752326414 |  |  | 0 |  | 1.23539810783848 |  | 0 | 0 | 99 |  | 1 | 0 | 100
Vermont |  |  |  | 0.4192835690323955 |  | 0 |  | 0 | 0 | 99 |  | 0 | 0 | 100
 |  |  | 79 | 99.70949654619882 | 78.28549497050463 | 100
Central | Bread |  |  | Milk |  | Juice
Arkansas | 2.349567399344988 |  |  | 2.128928712190178 |  | 0
Illinois | 24.50980072670392 |  |  | 27.15634238351489 |  | 32.92692317668649
Indiana | 6.429863294934254 |  |  | 6.305952738663394 |  | 11.0973357931665
Iowa | 0.6517523992635197 |  |  | 2.034771740421103 |  | 0.2999137545311294
Kansas | 4.977433073175499 |  |  | 2.715444697970189 |  | 0.2135061701175661
Kentucky | 16.32704935395043 |  |  | 5.015126994842829 |  | 14.09756761839298
Michigan | 9.518192038844443 |  |  | 8.091200141820803 |  | 10.334501105628
Minnesota | 8.69014061558014 |  |  | 10.44317328506372 |  | 6.53447224906135
Missouri | 8.700568653968356 |  |  | 8.940285302871592 |  | 1.085444618088204
Nebraska | 2.112655402212699 |  |  | 1.620904743136548 |  | 2.384030646322246
North Dakota | 1.534551024065957 |  |  | 0.730120698199868 |  | 0.1066314984015407
Ohio | 4.540107213269678 |  |  | 6.36231312851451 |  | 5.459605670153231
South Dakota | 1.155231127694589 |  |  | 1.599609323825839 |  | 2.287815071557801
West Virginia | 0.6191647793003437 |  |  | 0.6578166174512058 |  | 0
Wisconsin | 7.883922897691168 |  |  | 16.19800949151333 |  | 13.17225262789295
Spreadsheet: theresa_staab__39627__Enron Daily Email Aug'01
Sheet: Enron IT

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lost Creek Facilities Report
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipper Summary
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Enron (IT)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LC-IT-002
 | Rec. Noms. |  |  |  | Del. [NAME]. |  | Total Delivery | Allocated Receipts |  |  |  |  |  | Daily | Cummulative
[NAME] |  |  |  |  | LC - WIC | LC - CIG | Nominations |  |  |  | Fuel | Total Net | Allocated | Imbalance | Imbalance
[NAME] |  |  |  |  |  |  |  |  |  |  | 0 | Receipts | UA4 |  | 1391
 | 0 | 6386 | 0 | 0
 | 0 | 6204 | 0 | 0
 | 0 | 6204 | 0 | 0
 | 0 | 6204 | 0 | 0
 | 0 | 6204 | 0 | 0
 | 0 | 6204 | 0 | 0
 | 0 | 5718 | 0 | 0
 | 0 | 5718 | 0 | 0
 | 0 | 5718 | 0 | 0
 | 0 | 5718 | 0 | 0
 | 0 | 5718 | 0 | 0
 | 0 | 5718 | 0 | 0
 | 0 | 5718 | 0 | 0
 | 0 | 5718 | 0 | 0
 | 0 | 6204 | 0 | 0
 | 0 | 6204 | 0 | 0
 | 0 | 6022 | 0 | 0
 | 0 | 6022 | 0 | 0
 | 0 | 6022 | 0 | 0
 | 0 | 6022 | 0 | 0
 | 0 | 6022 | 0 | 0
 | 0 | 6022 | 0 | 0
 | 0 | 5779 | 0 | 0
 | 0 | 5779 | 0 | 0
 | 0 | 5657 | 0 | 0
 | 0 | 5657 | 0 | 0
 | 0 | 5657 | 0 | 0
 | 0 | 5657 | 0 | 0
 | 0 | 5657 | 0 | 0
 | 0 | 5657 | 0 | 0
 | 0 | 5657 | 0 | 0
TOTAL
Spreadsheet: 843934d1695749617-find-the-particular-cells-book3-3-
Sheet: Sheet1

 | Data | Multiplier | Product
 | 10500 | 0 |  |  | Target | 58770
 | 21500 | 0 |  |  | Sum of Products
 | 30000 | 0 |  |  | Difference
 | 4500 | 1
 | 6573 | 1
 | 32666 | 0
 | 4500 | 0
 | 79681 | 0
 | 126493 | 0
 | 32326 | 1
 | 32166 | 0
 | 10533 | 1
 | 7222 | 0
 | 1500 | 0
 | 4838 | 1
Spreadsheet: 876655d1723385126-replicate-data-from-one-file-to-another-jw-biometric-aug-2024
Sheet: OT Details

 |  |  | Days of Month
Emp Id / Ref No | Employee Name | Month/Year | 1 st | 2 nd | 3 rd | 4 th | 5 th | 6 th | 7 th | 8 th | 9 th | 10 th | 11 th | 12 th | 13 th | 14 th | 15 th | 16 th | 17 th | 18 th | 19 th | 20 th | 21 st | 22 nd | 23 rd | 24 th | 25 th | 26 th | 27 th | 28 th | 29 th | 30 th | 31 st
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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 780309d1652379631-getting-an-error-code-when-trying-to-add-more-conditions-columns-to-an-if-statement-calendar-draft
Sheet: 3 Events Per Day Monthly View

2022 |  | Level 1
June
Spreadsheet: 754059d1635920666-formula-to-get-correlation-of-every-5-rows-example
Sheet: Sheet1

 | 23 |  |  |  |  |  | 34
 | 4 |  |  |  |  |  | 56
 | 5 |  |  | <--correlation of these 5--> |  |  | 12
 | 32 |  |  |  |  |  | 87
 | 54 |  |  |  |  |  | 56
 | 6 |  |  |  |  |  | 43
 | 7 |  |  |  |  |  | 56
 | 54 |  |  | <--correlation of these 5--> |  |  | 36
 | 89 |  |  |  |  |  | 87
 | 34 |  |  |  |  |  | 45
 | 7 |  |  |  |  |  | 62
 | 76 |  |  |  |  |  | 98
 | 78 |  |  | <--correlation of these 5--> |  |  | 76
 | 32 |  |  |  |  |  | 54
 | 56 |  |  |  |  |  | 23
Spreadsheet: 673622d1587470228-sumif-returns-text-deposit-reconciliation-template
Sheet: Blank

 |  | Remote Deposit Reconciliation Form
 | Community Name:
 | Address:
 | Prepared By:
 | Deposit Date:
 |  |  |  |  |  |  |  | INCOME SUMMARY |  |  |  | CAM CODE | Description
ITEM # | OWNER'S NAME | UNIT | AMOUNT | GL CODE | CHECK# | [NAME] |  | Total | CAM CODE | Description |  | 40000 | CONDOMINIUM FEE
1 | [NAME] | 1101 | 1000 | 40000 |  |  |  |  | 40000 | CONDOMINIUM FEE |  | 40135 | PARKING FEE
 |  |  |  |  |  |  |  |  | 40135 | PARKING FEE |  | 46000 | CABLE T.V. FEE
 |  |  |  |  |  |  |  |  | 46000 | CABLE T.V. FEE |  | 43655 | CABLE TV COMMISSION
 |  |  |  |  |  |  |  |  | 43655 | CABLE TV COMMISSION |  | 44135 | INTEREST INCOME
 |  |  |  |  |  |  |  |  | 44135 | INTEREST INCOME |  | 44270 | IN-UNIT SERVICE
 |  |  |  |  |  |  |  |  | 44270 | IN-UNIT SERVICE |  | 42015 | KEY/LOCKS/FOB INCOME
 |  |  |  |  |  |  |  |  | 42015 | KEY/LOCKS/FOB INCOME |  | 43000 | LATE FEES
 |  |  |  |  |  |  |  |  | 43000 | LATE FEES |  | 45420 | LAUNDRY INCOME
 |  |  |  |  |  |  |  |  | 45420 | LAUNDRY INCOME |  | 43075 | LEGAL FEES
 |  |  |  |  |  |  |  |  | 43075 | LEGAL FEES |  | 42340 | [NAME]
 |  |  |  |  |  |  |  |  | 42340 | [NAME] |  | 43680 | MOVE-IN/MOVE-OUT FEES
 |  |  |  |  |  |  |  |  | 43680 | MOVE-IN/MOVE-OUT FEES |  | 44670 | PARKING FEE
 |  |  |  |  |  |  |  |  | 44670 | PARKING FEE |  | 42720 | PARTY ROOM FEE
 |  |  |  |  |  |  |  |  | 42720 | PARTY ROOM FEE |  | 44745 | STORAGE FEES
 |  |  |  |  |  |  |  |  | 44745 | STORAGE FEES |  | 45530 | VENDING INCOME
 |  |  |  |  |  |  |  |  | 45530 | VENDING INCOME |  | 50745 | Community Expense
 |  |  |  |  |  |  |  |  | Sub-Total: |  |  | 59000 | Electric Reimbusement
 |  |  |  |  |  |  |  |  |  |  |  | 64440 | Bulk Trash
 |  |  |  |  |  |  |  |  |  |  |  | 66110 | Plumbing Repairs
 |  |  |  |  |  |  |  |  |  |  |  | 66640 | Electric repairs
 |  |  |  |  |  |  |  | EXPENSE SUMMARY |  |  |  | 84015 | [NAME]
 |  |  |  |  |  |  |  | Total | CAM CODE | Description |  | 84015 | Windows
 |  |  |  |  |  |  |  |  | 50745 | Community Expense |  | 84015 | Riser Project
 |  |  |  |  |  |  |  |  | 59000 | Electric Reimbusement
 |  |  |  |  |  |  |  |  | 64440 | Bulk Trash
 |  |  |  |  |  |  |  |  | 66110 | Plumbing Repairs
 |  |  |  |  |  |  |  |  | 66640 | Electric repairs
 |  |  |  |  |  |  |  |  | 84015 | [NAME]
 |  |  |  |  |  |  |  |  | 84015 | Windows
 |  |  |  |  |  |  |  |  | 84015 | Riser Project
 |  |  |  |  |  |  |  |  | Sub Total:
 | TOTAL: |  |  |  |  |  |  |  | Grand Total:
Spreadsheet: 14516596-6a16-415f-bfa0-210d21fa7d5f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Tableau de comptabilisation des présences / absences des salariés
 | ANNEE : 2011 |  |  | MOIS DE : ________________
 | NOM DE LA STRUCTURE :
 | [NAME]
 | Nom du salarié 1 | RSA2 | Nombre d'absences (en journées) | Motif (pour chaque absence)
 | Exemple             Jean Dupont |  | 4 | Examen AFPA (1 journée)
 |  |  |  | Permis de conduire (2 journées)
 |  |  |  | [NAME] (1 journée)
 | Martin Durant |  | 0
TOTAUX
 | 1 Indiquer la liste complète des salariés du chantier |  |  | Signature du Président
 | 2 Cocher si le salarié est bénéficiaire du RSA
Spreadsheet: 169160d1342714411-count-a-column-based-on-values-in-another-column-sample
Sheet: Sheet1

Row Labels | Units | Total Units | Instock
1000172A--- | 2 | 2 | 1
101534--- | 2 | 2 | 1
1040107--- | 2 | 2 | 1
COXCOBB | 2 | 2 | 1
000NORK | 2 | 2 | 1
Grand Total | 10 | 10
Spreadsheet: 180926d1347876527-sorting-data-excel
Sheet: Sheet1

surename | name
xxx | a
xxx | b
xxx | c
xxx | d
yyy | e
yyy | f
yyy | g
yyy | h
yyy | i
yyy | j
yyy | k
zzz | l
zzz | m
zzz | nn
zzz | o
zzz | p
zzz | q
Spreadsheet: 834866d1688126375-function-that-gives-the-substring-between-spaces-before-the-last-space-in-the-string-map1
Sheet: before

name
Hello [NAME] | 8-9 2017
Hello [NAME] | 1-3 2017
Hello Inkoopfacturen 6-7 2017 | 6-7 2017
Hello Inkoopfacturen 10-12 2017 | etc.
Hello Inkoopfacturen 10-12 2017 | etc.
Hello Verkoopfacturen 3-4 2017 | etc.
Hello Verkoopfacturen 3-4 2017 | etc.
Hello Verkoopfacturen 8-9 2017 | etc.
Hello Verkoopfacturen 8-9 2017 | etc.
Hello [NAME] | etc.
Hello [NAME] | etc.
Hello Verkoopfacturen 6-7 2017 | etc.
Hello Verkoopfacturen 6-7 2017 | etc.
Spreadsheet: 105251d1302680058-rebuild-a-table-from-1-column-of-copied-data-exampleupload
Sheet: DesiredOutput

Header1 | Header2 | Header3 | -> headers can be done mannually
p1data11 | p1data21 | p1data31
p1data12 | p1data22 | p1data32
p1data13 | p1data23 | p1data33
p1data14 | p1data24 | p1data34
p1data15 | p1data25 | p1data35
p1data16 | p1data26 | p1data36
p1data17 | p1data27 | p1data37
p1data18 | p1data28 | p1data38
p2data11 | p2data21 | p2data31
p2data12 | p2data22 | p2data32
p2data13 | p2data23 | p2data33
p2data14 | p2data24 | p2data34
p2data15 | p2data25 | p2data35
p2data16 | p2data26 | p2data36
p2data17 | p2data27 | p2data37
p2data18 | p2data28 | p2data38
p3data11 | p3data21 | p3data31
p3data12 | p3data22 | p3data32
p3data13 | p3data23 | [NAME]
p3data14 | p3data24 | p3data34
p3data15 | p3data25 | p3data35
p3data16 | p3data26 | p3data36
p3data17 | p3data27 | p3data37
p3data18 | p3data28 | [NAME]
Spreadsheet: 708554d1607929373-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: FRANCE

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: andy_zipper__769__summary
Sheet: ElPaso

El Paso
 |  | 2001-10-15 00:00:00 | 2001-10-16 00:00:00 | 2001-10-17 00:00:00 | 2001-10-18 00:00:00 | 2001-10-19 00:00:00 | 2001-10-22 00:00:00 | 2001-10-23 00:00:00
US Gas Swap      Nymex                   Apr-Oct02       USD/MM |  | -167500 | -167500 | -167500 | -167500 | -167500 | -167500 | -167500
US Gas Swap      Nymex                   Dec01           USD/MM |  | -87500 | -87500 | -97500 | 0 | 0 | 0 | 20000
US Gas Swap      Nymex                   Dec01           USD/MM-L |  | 0 | -300 | -300 | -300 | -300 | -450 | -450
US Gas Swap      Nymex                   Jan-Dec02       USD/MM |  | 21000 | 11000 | -19000 | -44000 | -44000 | -44000 | -71000
US Gas Swap      Nymex                   Jan-Dec03       USD/MM |  | 18000 | 25500 | 40500 | 168500 | 225000 | 225000 | 230000
US Gas Swap      Nymex                   Jan02           USD/MM |  | 50000 | 50000 | 50000 | 70000 | 70000 | 70000 | 70000
US Gas Swap      Nymex                   Jan02           USD/MM-L |  | 100 | 200 | 200 | 200 | 200 | 200 | 200
US Gas Swap      Nymex                   Nov01           USD/MM |  | -142500 | -87500 | -240000 | -285000 | -640000 | -712500 | -900000
US Gas Swap      Nymex                   Nov01           USD/MM-L |  | 950 | 1150 | 1150 | 1150 | 1150 | 1300 | 1300
US Gas Swap      Nymex                   Nov01-Mar02     USD/MM |  | 232500 | 220000 | 220000 | 220000 | 220000 | 220000 | 220000
US Gas Swap      Nymex                   Apr-Oct02       USD/MM
US Gas Swap      Nymex                   Dec01           USD/MM
US Gas Swap      Nymex                   Dec01           USD/MM-L
US Gas Swap      Nymex                   Jan-Dec02       USD/MM
US Gas Swap      Nymex                   Jan-Dec03       USD/MM
US Gas Swap      Nymex                   Jan02           USD/MM
US Gas Swap      Nymex                   Jan02           USD/MM-L
US Gas Swap      Nymex                   Nov01           USD/MM
US Gas Swap      Nymex                   Nov01           USD/MM-L
US Gas Swap      Nymex                   Nov01-Mar02     USD/MM
US Gas Swap      Nymex                   Apr-Oct02       USD/MM
US Gas Swap      Nymex                   Dec01           USD/MM
US Gas Swap      Nymex                   Dec01           USD/MM-L
US Gas Swap      Nymex                   Jan-Dec02       USD/MM
US Gas Swap      Nymex                   Jan-Dec03       USD/MM
US Gas Swap      Nymex                   Jan02           USD/MM
US Gas Swap      Nymex                   Jan02           USD/MM-L
US Gas Swap      Nymex                   Nov01           USD/MM
US Gas Swap      Nymex                   Nov01           USD/MM-L
US Gas Swap      Nymex                   Nov01-Mar02     USD/MM
Spreadsheet: 287464d1388804441-looking-up-clients-book1
Sheet: Pivot

 | Employee | Annabell
 | Sum of Hours |  | Department
 | Client | Date | Advertising | Finance | Sales | Operations | Grand Total
 | [NAME] | 2011-02-23 00:00:00 | 10 |  |  |  | 10
 | [NAME] | 2013-08-26 00:00:00 | 6 |  |  |  | 6
 | [NAME] | 2013-01-31 00:00:00 |  |  | 6 |  | 6
 | [NAME] |  | 16 |  | 6 |  | 22
 | [NAME] | 2011-03-07 00:00:00 |  |  | 2 |  | 2
 | [NAME] | 2011-08-28 00:00:00 |  |  | 10 |  | 10
 | [NAME] | 2013-08-25 00:00:00 | 4 |  |  |  | 4
 | [NAME] |  | 4 |  | 12 |  | 16
 | [NAME] | 2011-04-10 00:00:00 | 4 |  |  |  | 4
 | [NAME] | 2011-05-12 00:00:00 |  | 11 |  |  | 11
 | [NAME] | 2012-05-07 00:00:00 |  |  | 6 |  | 6
 | Franchesca Schear Total |  | 4 | 11 | 6 |  | 21
 | [NAME] | 2013-04-27 00:00:00 | 10 |  |  |  | 10
 | [NAME] | 2011-03-29 00:00:00 |  | 2 |  |  | 2
 | [NAME] | 2012-10-28 00:00:00 |  |  |  | 10 | 10
 | [NAME] |  | 10 | 2 |  | 10 | 22
 | [NAME] | 2013-05-28 00:00:00 | 3 |  |  |  | 3
 | [NAME] | 2013-04-01 00:00:00 |  | 12.5 |  |  | 12.5
 | [NAME] | 2012-09-22 00:00:00 | 9 |  |  |  | 9
 | [NAME] |  | 12 | 12.5 |  |  | 24.5
 | Grand Total |  | 46 | 25.5 | 24 | 10 | 105.5
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Jeffery, Scott

Jeffery, Scott
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: 327926d1403724299-formula-for-different-options-to-return-a-value-based-upon-the-selections-example
Sheet: Reference Sheet

Size & Connection | OD | ID | [NAME]
API NC 23 | 3 | 1 | 2508 | 1st row |  | API NC 23 | 3 | 1
API NC 23 | 3 | 1.25 | 2508 | 1st row |  | 2 3/8" [NAME]. | 3.13 | 1.25
API NC 23 | 3 | 1.5 | 2508 | 1st row |  | 2 3/8" PAC | 3.25 | 1.5
API NC 23 | 3.13 | 1 | 3330 | 2nd row |  | 2 3/8" IF | 3.5 | 1.75
API NC 23 | 3.13 | 1.25 | 3330 | 2nd row |  | API NC 26 | 3.75
API NC 23 | 3.13 | 1.5 | 2647 | 2nd row |  | 2 7/8" SH | 3.88
API NC 23 | 3.25 | 1 | 4000 | 3rd row |  | 2 7/8" [NAME]. | 4.13
API NC 23 | 3.25 | 1.25 | 3387 | 3rd row |  | 2 7/8" XH
API NC 23 | 3.25 | 1.5 | 2647 | 3rd row
2 3/8" [NAME]. | 3 | 1.25 | 2241 | 1st row
2 3/8" [NAME]. | 3 | 1.5 | 2241 | 1st row
2 3/8" [NAME]. | 3 | 1.75 | 1749 | 1st row
2 3/8" [NAME]. | 3.13 | 1.25 | 3028 | 2nd row
2 3/8" [NAME]. | 3.13 | 1.5 | 2574 | 2nd row
2 3/8" [NAME]. | 3.13 | 1.75 | 1749 | 2nd row
2 3/8" [NAME]. | 3.25 | 1.25 | 3285 | 3rd row
2 3/8" [NAME]. | 3.25 | 1.5 | 2574 | 3rd row
2 3/8" [NAME]. | 3.25 | 1.75 | 1749 | 3rd row
2 3/8" PAC | 3 | 1.25 | 3797 | 1st row
2 3/8" PAC | 3 | 1.5 | 3797 | 1st row
2 3/8" PAC | 3 | 1.75 | 2926 | 1st row
2 3/8" PAC | 3.13 | 1.25 | 4966 | 2nd row
2 3/8" PAC | 3.13 | 1.5 | 4151 | 2nd row
2 3/8" PAC | 3.13 | 1.75 | 2926 | 2nd row
2 3/8" PAC | 3.25 | 1.25 | 5206 | 3rd row
2 3/8" PAC | 3.25 | 1.5 | 4151 | 3rd row
2 3/8" PAC | 3.25 | 1.75 | 2926 | 3rd row
2 3/8" IF | 3.5 | 1.25 | 4606
2 3/8" IF | 3.5 | 1.5 | 4606
2 3/8" IF | 3.5 | 1.75 | 3697
2 3/8" IF | 3.75 | 1.25 | 5501
2 3/8" IF | 3.75 | 1.5 | 4668
2 3/8" IF | 3.75 | 1.75 | 3697
API NC 26 | 3.5 | 1.25 | 4606
API NC 26 | 3.5 | 1.5 | 4606
API NC 26 | 3.5 | 1.75 | 3697
API NC 26 | 3.75 | 1.25 | 5501
API NC 26 | 3.75 | 1.5 | 4668
API NC 26 | 3.75 | 1.75 | 3697
2 7/8" SH | 3.5 | 1.25 | 4606
2 7/8" SH | 3.5 | 1.5 | 4606
2 7/8" SH | 3.5 | 1.75 | 3697
2 7/8" SH | 3.75 | 1.25 | 5501
2 7/8" SH | 3.75 | 1.5 | 4668
2 7/8" SH | 3.75 | 1.75 | 3697
2 7/8" [NAME]. | 3.5 | 1.25 | 3838 | 1st row
2 7/8" [NAME]. | 3.5 | 1.5 | 3838 | 1st row
2 7/8" [NAME]. | 3.5 | 1.75 | 3838 | 1st row
2 7/8" [NAME]. | 3.75 | 1.25 | 5766 | 2nd row
2 7/8" [NAME]. | 3.75 | 1.5 | 4951 | 2nd row
2 7/8" [NAME]. | 3.75 | 1.75 | 4002 | 2nd row
2 7/8" [NAME]. | 3.88 | 1.25 | 5766 | 3rd row
2 7/8" [NAME]. | 3.88 | 1.5 | 4951 | 3rd row
2 7/8" [NAME]. | 3.88 | 1.75 | 4002 | 3rd row
2 7/8" XH | 3.75 | 1.25 |  | 1st row
2 7/8" XH | 3.75 | 1.5 |  | 1st row
2 7/8" XH | 3.75 | 1.75 |  | 1st row
2 7/8" XH | 3.88 | 1.25 |  | 2nd row
2 7/8" XH | 3.88 | 1.5 |  | 2nd row
2 7/8" XH | 3.88 | 1.75 |  | 2nd row
2 7/8" XH | 4.13 | 1.25 |  | 3rd row
2 7/8" XH | 4.13 | 1.5 |  | 3rd row
2 7/8" XH | 4.13 | 1.75 |  | 3rd row
Spreadsheet: 811775d1672781488-i-need-to-have-manual-data-track-a-unique-dynamic-list-book1
Sheet: Sheet1

DATASET |  |  |  |  |  |  |  |  |  | DYNMAIC LIST | MANUAL DATA
NAMES | COLOR1 | COLOR2 | COLOR3 | COLOR4 | COLOR5 |  |  |  |  | UNIQUE LIST | COLOR CODE
[NAME] | RED | GREEN | BLUE |  |  |  |  |  |  |  | CC3333
RODNEY | PURPLE | RED | BLACK |  |  |  |  |  |  | GREEN | 458B00
NICK | GREEN | BLUE | RED | YELLOW |  |  |  |  |  | BLUE | 1034A6
[NAME] | RED | ORANGE | PINK |  |  |  |  |  |  | PURPLE | BE61BA
[NAME] | VIOLET | GREEN | BLUE |  |  |  |  |  |  | BLACK | 000000
RICHARD | ORANGE | PURPLE | PINK | RED | YELLOW |  |  |  |  | YELLOW | FFE200
 |  |  |  |  |  |  |  |  |  | ORANGE | [NAME]
 |  |  |  |  |  |  |  |  |  | PINK | E038B6
 |  |  |  |  |  |  |  |  |  | VIOLET | AE00FF
 |  |  |  |  |  | IF THE DATASET IS MODIFIED OR ADDITIONAL DATA ADDED THE DYNAMIC LIST WILL CHANGE |  |  |  |  | HOWEVER THIS COLOR CODE DATA NEEDS TO STAY BESIDE IT'S CORRISPONDING COLOR
Spreadsheet: 186420d1350036886-search-beers
Sheet: K

Brewery |  | Beer
Kelham Island |  | Celebration
 |  | Pale Island
 |  | Best Bitter
 |  | [NAME]
Kelburn |  | [NAME]
 |  | Dark Moor
 |  | Auld Hauf Hunner
 |  | Red Smiddy
 |  | [NAME]
[NAME] |  | Thirst Run
Keystone |  | Gold Spice
King (WJ) |  | King Mild
King  & Barnes |  | Mild ale
 |  | Sussex
 |  | Broadwood
 |  | Old ale
 |  | Festive
Spreadsheet: 272697d1382465621-having-trouble-with-formulas-stats
Sheet: Sheet1

 | Team          Totals |  |  |  |  | 1 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 4 |  |  |  |  | 5 |  |  |  |  | 6 |  |  |  |  | 7 |  |  |  |  | 8 |  |  |  |  | 9 |  |  |  |  | 10 |  |  |  |  | 11 |  |  |  |  | 12 |  |  |  |  | 13
 | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q | V | D | [NAME] | A | Q
2013-09-23 00:00:00 |  |  |  | 0 | 0
 |  |  |  |  |  | 1 | 1 | 13 | 951 |  | 0 | 0 | 10 | 789 |  | 0 | 0 | 10 | 1673 |  | 2 | 2 | 17 | 875 |  | 1 | 1 | 4 | 2353 |  | 1 | 1 | 8 | 1189 |  | 0 | 0 | 8 | 906 |  | 1 | 0 | 21 | 933 |  | 0 | 0 | 8 |  |  | 1 | 0 | 19 | 790 |  | 0 | 0 | 5 | 1738 |  |  |  |  |  |  |  |  | 5 | 1801
 |  |  |  |  |  | 1 | 0 | 9 | 837 |  | 2 | 2 | 10 | 1052 |  | 5 | 5 | 4 | 5303 |  | 2 | 2 | 32 | 654 |  | 0 | 0 | 15 | 623 |  | 0 | 0 | 9 | 899 |  | 1 | 1 | 4 | 1974 |  |  |  |  |  |  | 0 | 0 | 12 |  |  | 1 | 1 | 23 | 768 |  | 0 | 0 | 13 | 968 |  |  |  | 8 |  |  |  |  | 5 | 1492
 |  |  |  |  |  | 2 | 2 | 10 | 1912 |  | 1 | 2 | 24 | 827 |  | 0 | 1 | 11 | 1711 |  | 0 | 0 | 50 | 348 |  | 2 | 2 | 13 | 1773 |  | 1 | 1 | 21 | 911 |  | 1 | 1 | 15 | 1320 |  | 1 | 1 | 15 | 1238 |  | 2 | 3 | 16 |  |  | 1 | 1 | 31 | 609 |  | 2 | 2 | 11 | 1712 |  |  |  |  |  |  | 0 | 0 | 17 | 1132
 |  |  |  |  |  | 1 | 2 | 16 | 1100 |  | 3 | 3 | 25 | 754 |  | 1 | 2 | 3 | 6585 |  | 1 | 1 | 37 | 362 |  | 1 | 1 | 15 | 1290 |  | 1 | 0 | 20 | 954 |  | 0 | 0 | 14 | 1383 |  | 1 | 1 | 17 | 1174 |  | 3 | 3 | 24 |  |  | 1 | 0 | 32 | 544 |  | 1 | 1 | 11 | 1518 |  |  |  | 11 |  |  |  |  | 12 | 1575
2013-09-30 00:00:00 |  |  |  |  |  |  |  | 12 | 1660 |  |  |  | 22 | 962 |  |  |  | 15 | 1555 |  |  |  | 26 | 815 |  |  |  | 17 | 1186 |  |  |  | 20 | 1088 |  | 3 | 3 | 14 | 1553 |  | 0 | 0 | 14 | 1197 |  | 0 | 0 |  |  |  |  |  | 22 | 956 |  |  |  | 15 | 1651 |  |  |  | 15 |  |  |  |  | 16 | 1121
2013-10-07 00:00:00
2013-10-14 00:00:00
2013-10-21 00:00:00
Total
Wx SPC %
Voice SPC %
Spreadsheet: 767271d1644389441-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation1-ans
Sheet: Weekdays

Weekdays
Click Consulting
Purpose | To update the allocation table to exclude weekend days.
Function | NETWORKDAYS - returns the number of workdays, excluding weekends, between two dates (inclusive)
Allocation
 | Amount | Alloc Start | Alloc End |  | WeekDays | DailyAmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 1000 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | 600 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | 900 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | -750 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | 800 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | 650 | 2022-01-01 00:00:00 | 2022-06-30 00:00:00
 | 850 | 2022-04-01 00:00:00 | 2022-12-31 00:00:00
 |  | Dates are changed for verification.