tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867246d1714093036-advice-creating-a-list-using-data-from-2-separate-files-mrexcel-worksheet-longissimus-
Sheet: End Result

Landing Page URL | Team ID | Location ID | Design ID | March Visits | Feb Visits | Apr Visits | March Number of purchases | Feb Number of purchases | April Number of purchases | March Number of People who started registering | Feb Number of People who started registering | April Number of People who started registering | March Number of ppl who finished registering | March Number of ppl who finished registering | April Number of ppl who finished registering
www.bestfootball.com | 1 | 99 | 1000 | 4343243 | 333333 | 888888 | 233 | 50 | 49 | 23432 | 2000 | 200 | 4343 | 500 | 50
www.bestfootball.com | 1 | 66 | 1000 | 23432523 |  |  | 43 |  |  | 23423 |  |  | 432
www.bestfootball.com | 2 | 98 | 1000 | 4534543 | 555555 | 999999 | 234 | 70 | 69 | 45654 | 20007 | 2000 | 2532 | 700 | 70
www.cheesecake.com | 1 | 97 | 2000 | 345213 | 3424322 | 6666666 | 78 | 60 | 59 | 43534 | 20008 | 2000 | 354 | 900 | 90
www.cheesecake.com | 1 | 99 | 2000 |  | 3333343 | 3333343 |  | 90 | 89 |  | 20008 | 2000 |  | 899 | 89
www.cheesecake.com | 2 | 700 | 2000 | 1312312 | 3443545 |  | 80 | 30 |  | 235 | 2000 |  | 200 | 190
www.cheesecake.com | 3 | 800 | 2000 | 23432432 | 23445555 |  | 3 | 20 |  | 43643 | 2000 |  | 24 | 190
www.cheesecake.com | 3 | 900 | 2000 | 32432423 |  | 8864353 | 34 |  | 19 | 34634 |  | 200 | 3543 |  | 19
www.bacon.com | 1 | 44 | 999 | 900000 |  |  | 20 |  |  | 1000 |  |  | 100
www.bacon.com | 1 | 33 | 999 | 900000 |  |  | 20 |  |  | 1000 |  |  | 100
www.bacon.com | 4 | 22 | 999 | 800000 |  |  | 20 |  |  | 1000 |  |  | 100
www.smartphone.com | 1 | 99 | 3000 |  | 88888 | 9090909 |  | 12 | 11 |  | 200 | 20 |  | 100 | 10
www.smartphone.com | 2 | 66 | 3000 |  | 888881 | 9000099 |  | 12 | 11 |  | 200 | 20 |  | 100 | 10
www.junglejoy.com | 1 | 11 | 4000 |  |  | 9090909 |  |  | 29 |  |  | 200 |  |  | 19
www.cheesecake.com | 3 | 90 | 2000 |  |  | 7777777 |  |  | 29 |  |  | 200 |  |  | 19
Spreadsheet: 809723d1671266733-apply-conditional-formatting-based-on-conditions-of-whole-column-excel-forum-17
Sheet: Sheet1

 |  |  |  | formatting cell
Unit | weight per unit |  |  |  |  | if all weights in column B have a unit of KG than highlight cell E1 in green color
Kg | 13 |  |  |  |  | if there is any weight in column A that is not [NAME] than highlight cell E1 in red
Kg | 23 |  |  |  |  | if any unit is available in column A but with a zero weight value in column B than highlight cell E1 in red color
Kg | 3
Kg | 323
Kg | 23
Kg | 3
Kg | 213
Kg | 213
Kg | 43
Kg | 34
Kg | 13
Kg | 24
Kg | 3
Kg | 23
Kg | 3
Kg | 23
Kg | 34
Kg | 45
Kg | 65
Kg | 56
Kg | 76
Kg | 87
Kg | 4
Kg | 34
Kg | 234
Kg | 21
Kg | 12
Kg | 123
Spreadsheet: 790103d1659536431-10-day-rolling-values-on-chart-book1
Sheet: Sheet1

2022-01-01 00:00:00 | 45
 | 66
 | 36
 | 27
 | 11
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 44
 | 55
 | 76
 | 81
 | 23
 | 48
 | 90
Spreadsheet: 271972d1382121658-if-statement-return-value-if_sample
Sheet: Sheet1

[NAME] |  |  | [NAME]
0400-0500 | 25 |  | 0400-0500 | 2
0500-0600 | 30 |  | 0500-0600 | 3
0600-0700 | 15 |  | 0600-0700 | 35
0700-0800 | 50 |  | 0700-0800 | 15
0800-0900 | 15 |  | 0800-0900 | 12
0900-1000 | 32 |  | 0900-1000 | 49
1000-1100 | 21 |  | 1000-1100 | 25
1100-1200 | 42 |  | 1100-1200 | 16
1200-1300 | 3 |  | 1200-1300 | 5
 |  | 50
Spreadsheet: 761656d1641140974-dynamic-dropdown-in-excel-dnamic-dropdown
Sheet: JE

 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | ERP
 |  |  |  |  |  |  |  |  |  | BH
 |  |  |  |  |  | 4 |  |  | 2 |  | 3
Line Items: | Code | key | Account | Currency | Amount | SrcAcct | CC | PC | CoCode | Text | [NAME]
 |  |  |  |  |  | 640003-LF00E30100303 |  |  | 620662_2025
Spreadsheet: 696527d1600874428-dynamic-table-creation-template_111-bluya-
Sheet: Sending

 | Package Unique number |  | Sent date
 | A33 |  | 2020-08-01 00:00:00
 | A26 |  | 2020-10-04 00:00:00
 | A27 |  | 2021-01-01 00:00:00
 | A28 |  | 2020-09-01 00:00:00
 | A29 |  | 2022-10-02 00:00:00
 | A30 |  | 2020-12-10 00:00:00
 | A31 |  | 2021-05-03 00:00:00
 | A32 |  | 2022-03-04 00:00:00
 | A36 |  | 2020-05-02 00:00:00
 | A39 |  | 2027-12-09 00:00:00
Spreadsheet: 148986d1333639851-how-can-i-pull-data-from-one-tab-to-another-if-a-date-is-entered-into-a-certain-field-candidate-tracker
Sheet: Stress & Thermal

Candidate | Job Title | Date [NAME] | Sent to | Status | Int. Requested | Int. Date | Offer Date | Start date | Notes |  |  |  |  |  |  |  | CV sent week | Interview Week | Offer Week | Start Week
Candidate A | Stress Engineer | 2012-01-01 00:00:00 | [NAME] | OfferAccept | Yes | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-05-01 00:00:00
Spreadsheet: 63713d1264591215-formatting-words-to-change-colours-book1
Sheet: Sheet1

 | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
A | [NAME] | Y
 | Rich | Y
 | [NAME] | N
 | [NAME] | Y
 | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
B | [NAME] | Y
 | Rich | N
 | [NAME] | N
 | [NAME] | N
 | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
C | [NAME] | N
 | Rich | N
 | [NAME] | Y
 | [NAME] | Y
Spreadsheet: 108682d1305697862-dataset-combination-dates-streets-routes-example_forum-mod
Sheet: Sheet1

Table 1 | Route | Start Date | End Date | Vehicles per day |  |  | Table 1 | Route | Start Date | End Date | Vehicles per day
 | Route1 | 2012-01-01 00:00:00 | 2012-01-04 00:00:00 | 10 |  |  |  | Route1 | 2012-01-01 00:00:00 | 2012-01-04 00:00:00 | 10
 | Route2 | 2012-01-02 00:00:00 | 2012-01-05 00:00:00 | 20 |  |  |  | Route2 | 2012-01-02 00:00:00 | 2012-01-05 00:00:00 | 20
 | Route3 | 2012-01-01 00:00:00 | 2012-01-06 00:00:00 | 30 |  |  |  | Route3 | 2012-01-01 00:00:00 | 2012-01-06 00:00:00 | 30
 | Route4 | 2012-01-03 00:00:00 | 2012-01-05 00:00:00 | 40 |  |  |  | Route4 | 2012-01-03 00:00:00 | 2012-01-05 00:00:00 | 40
 | Route5 | 2012-01-04 00:00:00 | 2012-01-07 00:00:00 | 50 |  |  |  | Route5 | 2012-01-04 00:00:00 | 2012-01-07 00:00:00 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Street1 |  |  |  |  |  |  |  | Street2 |  |  |  |  |  |  |  | Street3
Table2 | Street | Route |  |  |  |  | Table2 | Street | Route |  |  |  |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  | 2012-01-01 00:00:00 |  |  |  |  |  |  |  | 2012-01-01 00:00:00
 | Street1 | Route1 |  |  |  |  |  | Street1 | Route1
 | Street2 | Route1 |  |  |  |  |  | Street2 | Route1
 | Street3 | Route1 |  |  |  |  |  | Street3 | Route1
 | Street1 | Route2 |  |  |  |  |  | Street1 | Route2
 | Street2 | Route2 |  |  |  |  |  | Street2 | Route2
 | Street1 | Route3 |  |  |  |  |  | Street1 | Route3
 | Street3 | Route3 |  |  |  |  |  | Street3 | Route3
 | Street1 | Route4 |  |  |  |  |  | Street1 | Route4
 | Street2 | Route4 |  |  |  |  |  | Street2 | Route4
 | Street1 | Route5 |  |  |  |  |  | Street1 | Route5
Table3 | Output |  |  |  |  |  | Table3 | Output
 | Date | Street1 | Street2 | Street3 |  |  |  | Date | Street1 | Street2 | Street3
 | 2012-01-01 00:00:00 |  | 10 |  |  |  |  | 2012-01-01 00:00:00
 |  |  |  | 30
 |  |  |  | 30
 |  | 50
Spreadsheet: 158349e2-9039-4f51-9801-787050b12990
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CLONS | Test | CLONS | Clonazepam, Serum | Clonazepam, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Container/Tube: Red top [NAME]: 2 mL | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Serum gel tube | Therapeutic concentration: 20-60 ng/mL Toxic concentration: >100 ng/mL | Varies, batched 3 times per week | 1 day | 1 day | 1 | 80154 |  |  |  |  | New England
CLONS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CLONS | Result | 500108 | Clonazepam, S | Clonazepam, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3494-2 | Clonazepam:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 59433d1259932504-help-to-build-a-working-day-calculator-jordan-lawrance
Sheet: Sheet1

Invoice Date | Sent to Mkting | Back to Finance | Coded by Finance | Paid | Payment Sent | Payment Received
2009-12-07 00:00:00 | 2009-12-09 00:00:00 | 2009-12-16 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2009-12-31 00:00:00 | 2010-01-04 00:00:00
2009-12-07 00:00:00 | 2009-12-09 00:00:00 | 2009-12-16 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2009-12-31 00:00:00 | 2010-01-04 00:00:00
2000-01-02 00:00:00
Spreadsheet: 116701d1312028285-selective-columns-unofficial-handicap-adjustment-workings
Sheet: Sheet1

 |  |  | Adj | H'Cap |  | SCORES | RANK | A | Cut (a) | Cut (a+b) | Increase | New Adj | New H'Cap
ADAMS. [NAME] | 17.80000000000003 | 17.80000000000003 | 0.5 | 18.30000000000003 |  | 41
ADAMS. [NAME] | 32.30000000000002 | 32.30000000000002 | 1.1 | 33.40000000000002 |  | 40
ANKERS. Neville | 15.49999999999999 | 15.49999999999999 | 0 | 15.49999999999999 |  | 33
BASIL. Greg | 10.59999999999999 | 10.59999999999999 | 0 | 10.59999999999999 |  | 28
BROMLEY. [NAME] | 23.1 | 23.1 | 0 | 23.1 |  | 37
CLARKE. [NAME] | 7.099999999999993 | 7.099999999999993 | -4.5 | 2.599999999999993 |  | 30
DOOLEY. [NAME] | 26.80000000000001 | 26.80000000000001 | 0.9 | 27.70000000000001 |  | 38
GOODALL. [NAME] | 22.50000000000003 | 22.50000000000003 | 0.2 | 22.70000000000003 |  | 31
HAINES. [NAME] | 18.1 | 18.1 | -1 | 17.1 |  | 34
 |  |  |  |  |  | 36
Number of players | 9
Bottom third
Top two-thirds
Spreadsheet: 185159d1349528761-extracting-uk-postcodes-from-string-of-text-to-import-into-microsoft-autoroute-getpostcodes-novba-
Sheet: Sheet1

String
%CA145DX15505382054963814826,%0WS13QE15505382055020814826,%0HU91TQ15505382069227814826,%0WS13QE15505382117853814826,%00L10AB15505382117853814826
Use Text to Columns to get
%CA145DX15505382054963814826 | %0WS13QE15505382055020814826 | %0HU91TQ15505382069227814826 | %0WS13QE15505382117853814826 | %00L10AB15505382117853814826
Copy > Paste Special > Transpose | Result
%CA145DX15505382054963814826 | CA145DX
%0WS13QE15505382055020814826 | [NAME]
%0HU91TQ15505382069227814826 | HU91TQ
%0WS13QE15505382117853814826 | [NAME]
%00L10AB15505382117853814826 | L10AB
or sometimes it comes like this:
String | Result
%CA145DX15504002468914814826 | CA145DX
%0WS13QE15504002468914814826 | [NAME]
%0HU91TQ15504002468914814826 | HU91TQ
%0WS13QE15504002468914814826 | [NAME]
%00L10AB15504002468914814826 | L10AB
Spreadsheet: 289991d1389767011-multiple-data-validation-on-one-cell-sample
Sheet: Sheet1

 | 2014-01-01 00:00:00
 | 2014-01-31 00:00:00
 | Date
1 | 2014-01-15 00:00:00 | 2014-01-15 00:00:00
2 | 2014-01-15 00:00:00 | 2014-01-15 00:00:00
3 | 2014-01-16 00:00:00 | 2014-01-16 00:00:00
4 |  | 2014-01-16 00:00:00
5 | 2014-02-01 00:00:00 | 2014-02-01 00:00:00
6 | 2014-01-16 00:00:00 | 2014-02-01 00:00:00 | ***
7 |  | 2014-02-01 00:00:00
8 |  | 2014-02-01 00:00:00
9 |  | 2014-02-01 00:00:00
10 |  | 2014-02-01 00:00:00
Spreadsheet: 217642d1362139710-using-address-with-vlookup-table_array-argument-address_vlookup
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 |  | 1 | a
 |  |  |  |  |  |  |  | 1 | b
1 |  |  |  |  |  |  |  | 2 | c
2 |  |  |  |  |  |  |  | 2 | d
3 |  |  |  |  |  |  |  | 2 | e
4 |  |  |  |  |  |  |  | 3 | f
 |  |  |  |  |  |  |  | 4 | g
Spreadsheet: 215148d1361283879-index-and-match-book1
Sheet: AW

 | WP05MLC | date
1.1.1 | 1.1.1
1.2.1 | 1.2.1
1.2.4 | 1.2.4
1.2.5 | 1.2.5
1.2.6 | 1.2.6
1.3.15 | 1.3.15
2.1.13 | 2.1.13
2.1.2 | 2.1.2
2.1.5 | 2.1.5
2.2.2 | 2.2.2
2.2.4 | 2.2.4
2.2.5 | 2.2.5
2.3.1 | 2.3.1
2.3.108 | 2.3.108
2.3.116 | 2.3.116
2.3.13 | 2.3.13
2.3.22 | 2.3.22
2.3.24 | 2.3.24
2.3.26 | 2.3.26
2.3.27 | 2.3.27
2.3.28 | 2.3.28
2.3.29 | 2.3.29
2.3.3 | 2.3.3
2.3.32 | 2.3.32
2.3.34 | 2.3.34
2.3.4 | 2.3.4
2.3.49 | 2.3.49
2.3.5 | 2.3.5
2.3.50 | 2.3.50
2.3.58 | 2.3.58
2.3.99 | 2.3.99
2.4.11 | 2.4.11
2.4.18 | 2.4.18
2.4.8 | 2.4.8
2.4.9 | 2.4.9
2.5.1 | 2.5.1
2.5.10 | 2.5.10
2.5.12 | 2.5.12
2.5.16 | 2.5.16
2.5.17 | 2.5.17
3.1.22 | 3.1.22
3.1.23 | 3.1.23
3.1.30 | 3.1.30
3.1.40 | 3.1.40
3.1.58 | 3.1.58
3.2.1 | 3.2.1
3.2.10 | 3.2.10
3.2.12 | 3.2.12
3.2.13 | 3.2.13
3.2.27 | 3.2.27
3.2.29 | 3.2.29
3.2.4 | 3.2.4
3.2.8 | 3.2.8
3.2.9 | 3.2.9
3.3.1 | 3.3.1
3.3.100 | 3.3.100
3.3.101 | 3.3.101
3.3.12 | 3.3.12
3.3.14 | 3.3.14
3.3.154 | 3.3.154
3.3.163 | 3.3.163
3.3.167 | 3.3.167
3.3.194 | 3.3.194
3.3.195 | 3.3.195
3.3.196 | 3.3.196
3.3.197 | 3.3.197
3.3.198 | 3.3.198
3.3.199 | 3.3.199
3.3.20 | 3.3.20
3.3.200 | 3.3.200
3.3.201 | 3.3.201
3.3.202 | 3.3.202
3.3.203 | 3.3.203
3.3.204 | 3.3.204
3.3.205 | 3.3.205
3.3.206 | 3.3.206
3.3.208 | 3.3.208
3.3.209 | 3.3.209
3.3.210 | 3.3.210
3.3.22 | 3.3.22
3.3.24 | 3.3.24
3.3.3 | 3.3.3
3.3.34 | 3.3.34
3.3.35 | 3.3.35
3.3.38 | 3.3.38
3.3.42 | 3.3.42
3.3.43 | 3.3.43
3.3.44 | 3.3.44
3.3.47 | 3.3.47
3.3.48 | 3.3.48
3.3.52 | 3.3.52
3.3.53 | 3.3.53
3.3.56 | 3.3.56
3.3.57 | 3.3.57
3.3.59 | 3.3.59
3.3.66 | 3.3.66
3.3.70 | 3.3.70
3.3.71 | 3.3.71
3.3.72 | 3.3.72
3.3.79 | 3.3.79
3.3.82 | 3.3.82
3.3.83 | 3.3.83
3.3.86 | 3.3.86
3.3.87 | 3.3.87
3.3.90 | 3.3.90
3.3.95 | 3.3.95
3.3.96 | 3.3.96
3.3.99 | 3.3.99
3.4.27 | 3.4.27
3.4.29 | 3.4.29
3.4.30 | 3.4.30
3.4.38 | 3.4.38
3.4.40 | 3.4.40
3.4.42 | 3.4.42
4.7.14 | 4.7.14
4.7.5 | 4.7.5
4.8.11 | 4.8.11
4.8.12 | 4.8.12
4.8.13 | 4.8.13
4.8.15 | 4.8.15
4.8.16 | 4.8.16
4.8.5 | 4.8.5
4.8.6 | 4.8.6
4.8.7 | 4.8.7
Spreadsheet: chris_germany__1958__lonestarnom
Sheet: Mar7

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  | [NAME]
 |  |  |  |  | 713/853-9781 (Phone)
 |  |  |  |  | 713/345-7374 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: | 2002-03-27 00:00:00 |  | End Date: | 2002-03-27 00:00:00
RECEIPT POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
17-1240-50 | NNG Sprayberry | 108743 | 0 | 0.01
17-1240-50 | NNG Sprayberry | 107903 | 3000 | 0.01 |  | Sell at point to TXU K#501
17-1954-50 | Conoco Sterling | Conoco | 17000 | 0.01 |  | Sell at point to TXU K#501
17-7462-50 | [NAME] | 5268 | 0 | 0.01
17-0071-00 | [NAME] | at plant | 0 | 0.01
17-3000-00 | [NAME] | 2827276201 | 0 | 0.01
DELIVERY POINT INFORMATION:
STATION # | [NAME] | DOWNSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671 | 0 |  | 0
Spreadsheet: 824977d1680993453-what-s-is-a-simple-formula-to-add-12-24-from-another-worksheet-ak-sample
Sheet: COVER-24

 | AK |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  | 1200 |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  | 1200 |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  | 1200 |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Comments |  |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 825899d1681625594-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-sample_ceepeebee
Sheet: Overview Sheet

Week Date | 2023-05-04 00:00:00
Name | Team | Starting Weight | Starting Height | Starting BMI | Concurrent Week Losses | Hat-Trick | 2023-04-06 00:00:00
 |  |  |  |  |  |  | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg) | Weight (kg)
Stephan | White | 129 | 180 |  | 0 |  | 128 | 128 | 126 | 125
Spreadsheet: 298657d1392857077-sumifs-for-dates-sum-total-for-each-month-rent
Sheet: Sheet1

 |  |  |  |  | 2014-01-01 00:00:00 | 43000
 |  |  |  |  | 2014-02-01 00:00:00 | 32000
Date | Rent |  |  |  | 2014-03-01 00:00:00 | 57000
2014-01-01 00:00:00 | 8000 |  |  |  | 2014-04-01 00:00:00 | 19000
2014-01-16 00:00:00 | 20000 |  |  |  | 2014-05-01 00:00:00 | 23000
2014-01-31 00:00:00 | 15000 |  |  |  | 2014-06-01 00:00:00 | 11000
2014-02-10 00:00:00 | 23000 |  |  |  | 2014-07-01 00:00:00 | 7000
2014-02-28 00:00:00 | 9000 |  |  |  | 2014-08-01 00:00:00 | 21000
2014-03-03 00:00:00 | 15000 |  |  |  | 2014-09-01 00:00:00 | 6000
2014-03-07 00:00:00 | 7000 |  |  |  | 2014-10-01 00:00:00 | 18000
2014-03-16 00:00:00 | 18000 |  |  |  | 2014-11-01 00:00:00 | 21000
2014-03-20 00:00:00 | 2000 |  |  |  | 2014-12-01 00:00:00 | 8000
2014-03-31 00:00:00 | 15000 |  |  |  | 2015-01-01 00:00:00 | 13000
2014-04-30 00:00:00 | 19000 |  |  |  | 2015-02-01 00:00:00 | 23000
2014-05-31 00:00:00 | 23000 |  |  |  | 2015-03-01 00:00:00 | 4000
2014-06-30 00:00:00 | 11000 |  |  |  | 2015-04-01 00:00:00 | 22000
2014-07-31 00:00:00 | 7000 |  |  |  | 2015-05-01 00:00:00 | 29000
2014-08-31 00:00:00 | 21000 |  |  |  | 2015-06-01 00:00:00 | 6000
2014-09-30 00:00:00 | 6000 |  |  |  | 2015-07-01 00:00:00 | 20000
2014-10-31 00:00:00 | 18000 |  |  |  | 2015-08-01 00:00:00 | 15000
2014-11-30 00:00:00 | 21000
2014-12-31 00:00:00 | 8000
2015-01-31 00:00:00 | 13000
2015-02-28 00:00:00 | 23000
2015-03-31 00:00:00 | 4000
2015-04-30 00:00:00 | 22000
2015-05-11 00:00:00 | 7000
2015-05-31 00:00:00 | 22000
2015-06-30 00:00:00 | 6000
2015-07-31 00:00:00 | 20000
2015-08-31 00:00:00 | 15000
Spreadsheet: 77584d1278017143-calculate-averages-market-analysis
Sheet: Sheet1

 | DJIA
 | INDU INDEX
DATES | Px Last
2010-05-01 00:00:00
2010-05-02 00:00:00
2010-05-03 00:00:00 | 11151.83
2010-05-04 00:00:00 | 10926.77
2010-05-05 00:00:00 | 10868.12
2010-05-06 00:00:00 | 10520.32
2010-05-07 00:00:00 | 10380.43
2010-05-08 00:00:00
2010-05-09 00:00:00
2010-05-10 00:00:00 | 10785.14
2010-05-11 00:00:00 | 10748.26
2010-05-12 00:00:00 | 10896.91
2010-05-13 00:00:00 | 10782.95
2010-05-14 00:00:00 | 10620.16
2010-05-15 00:00:00
2010-05-16 00:00:00
2010-05-17 00:00:00 | 10625.83
2010-05-18 00:00:00 | 10510.95
2010-05-19 00:00:00 | 10444.37
2010-05-20 00:00:00 | 10068.01
2010-05-21 00:00:00 | 10193.39
2010-05-22 00:00:00
2010-05-23 00:00:00
2010-05-24 00:00:00 | 10066.57
2010-05-25 00:00:00 | 10043.75
2010-05-26 00:00:00 | 9974.45
2010-05-27 00:00:00 | 10258.99
2010-05-28 00:00:00 | 10136.63
2010-05-29 00:00:00
2010-05-30 00:00:00
2010-05-31 00:00:00
2010-06-01 00:00:00 | 10024.02
2010-06-02 00:00:00 | 10249.54
2010-06-03 00:00:00 | 10255.28
2010-06-04 00:00:00 | 9931.97
2010-06-05 00:00:00
2010-06-06 00:00:00
2010-06-07 00:00:00 | 9816.49
2010-06-08 00:00:00 | 9939.98
2010-06-09 00:00:00 | 9899.25
2010-06-10 00:00:00 | 10172.53
2010-06-11 00:00:00 | 10211.07
2010-06-12 00:00:00
2010-06-13 00:00:00
2010-06-14 00:00:00 | 10190.89
2010-06-15 00:00:00 | 10404.77
2010-06-16 00:00:00 | 10409.46
2010-06-17 00:00:00 | 10434.17
2010-06-18 00:00:00 | 10450.64
2010-06-19 00:00:00
2010-06-20 00:00:00
2010-06-21 00:00:00 | 10442.41
2010-06-22 00:00:00 | 10293.52
2010-06-23 00:00:00 | 10298.44
2010-06-24 00:00:00 | 10152.8
2010-06-25 00:00:00 | 10143.81
2010-06-26 00:00:00
2010-06-27 00:00:00
2010-06-28 00:00:00
2010-06-29 00:00:00
2010-06-30 00:00:00
Previous Month Date | 2010-05-01 00:00:00 | 2010-05-31 00:00:00
Current Month Date | 2010-06-01 00:00:00 | 2010-06-30 00:00:00
Previous Month Average | 210003.83 | <<~~ Currently just sum…
Current Month Average | 193721.04
Spreadsheet: 769033d1645264689-remove-blank-data-in-printout-in-excel-sample-sheet-prinout-hide-aligw
Sheet: Sheet1

Price List |  |  |  |  | Price List
Description | Price | Qty | Amount |  | Description | Price | Qty | Amount
Product1 | 4557 | 96
Product2 | 2844 | 32
Product3 | 1189 | 0
Product4 | 4824 | 42
Product5 | 4929 | 100
Product6 | 4440 | 59
Product7 | 4890
Product8 | 4914 | 34
Product9 | 3283 | 26
Product10 | 4711 | 5
Product11 | 3346 | 36
Product12 | 3347 | 75
Product13 | 2133
Product14 | 4331 | 30
Product15 | 3316 | 24
 |  | Total
Spreadsheet: 46930d1245852725-looking-up-the-oldest-in-a-list-of-names-probleem-max_min
Sheet: max_min

 |  | Name | Age
 |  | Jan | 15 |  |  | Name | Oldest | Youngest | Average
 |  | Marcel | 25 |  |  | Jan
 |  | [NAME] | 65 |  |  | Marcel
 |  | Joop | 18 |  |  | [NAME]
 |  | [NAME] | 43 |  |  | Joop
 |  | [NAME] | 52 |  |  | [NAME]
 |  | [NAME] | 74 |  |  | [NAME]
 |  | Yves | 12 |  |  | [NAME]
 |  | Tristan | 5 |  |  | Yves
 |  | France | 40 |  |  | Tristan
 |  | Helga | 43 |  |  | France
 |  | Sabine | 47 |  |  | Helga
 |  | [NAME] | 43 |  |  | Sabine
 |  | Jan | 31 |  |  | [NAME]
 |  | Marcel | 60
 |  | [NAME] | 21
 |  | [NAME] | 15
 |  | Tristan | 23
 |  | Sabine | 5
 |  | [NAME] | 55
 |  | [NAME] | 52
 |  | France | 80
 |  | Yves | 75
Spreadsheet: 542196d1507744866-workflow-how-to-show-this-weeks-tasks-sum-product-pivot-workflow-this-weeks-tasks-prc
Sheet: Sheet2

just one example…
 | SHOWDATE | ARTIST | TOWN / CITY | VENUE | FACEBOOK TOUR 3 | ASK VENUE TO DO MAILSHOT | ASK TICKET OUTLET NEXT MAILER
 | 2017-10-27 00:00:00 | BAND 398 | ST HELENS | CITADEL | 2017-10-09 00:00:00 | 2017-10-13 00:00:00 | 2017-10-13 00:00:00
 | 2017-10-28 00:00:00 | BAND 400 | BURY | THE MET | 2017-10-09 00:00:00
Years | SHOWDATE | ARTIST | TOWN / CITY | VENUE | FACEBOOK TOUR 3 | ASK VENUE TO DO MAILSHOT | ASK TICKET OUTLET NEXT MAILER
2017 | 27-Oct | BAND 398 | ST HELENS | CITADEL | 2017-10-09 00:00:00 | 2017-10-13 00:00:00 | 2017-10-13 00:00:00
 | 28-Oct | BAND 400 | BURY | THE MET | 2017-10-09 00:00:00 | N/A | N/A
Grand Total