tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 470779d1468648043-time-calculation-formula-not-working-well-book16
Sheet: Sheet1

OPEN DATE | RECEIPT DATE | CLOSE DATE | Time period
2016-12-07 09:37:36 | 2016-12-07 09:39:18 | 2016-12-07 09:39:50
2016-12-07 09:33:20 | 2016-12-07 09:36:33 | 2016-12-07 09:37:19
2016-12-07 07:51:33 | 2016-12-07 07:52:33 | 2016-12-07 07:53:01
7/13/2016 9:48:47 AM | 7/13/2016 9:49:27 AM | 7/13/2016 9:49:40 AM
2016-12-07 09:54:35 | 2016-12-07 10:08:48 | 2016-12-07 10:09:33
7/13/2016 11:08:27 AM | 7/13/2016 11:15:03 AM | 7/13/2016 11:15:37 AM
7/13/2016 11:41:45 AM | 7/13/2016 11:45:33 AM | 7/13/2016 11:46:10 AM
7/13/2016 11:32:25 AM | 7/13/2016 11:35:54 AM | 7/13/2016 11:36:21 AM
Spreadsheet: 700604d1603264726-highlight-highest-value-in-row-excel-highlight-highest-value-sample
Sheet: Sheet1

1 |  | 1 |  |  | 1 |  |  |  | 1 | Helper: Mark column with 1
1 | abc | 2 |  |  | 3 |  |  |  | 4
2 |  | 3 |  |  | 4 |  |  |  | 5
3 | 100 | 4 |  |  | 5 |  |  |  | 6
4 |  | 5 |  |  | 6 |  |  |  | 7
5 |  | 6 |  |  | 7 |  |  |  | 8
6 |  | 7 |  |  | 8 |  |  |  | 9
7 |  | 8 |  |  | 9 |  |  |  | 10
8 |  | 9 |  |  | 10 |  |  |  | 11
9 |  | 10 |  |  | 11 |  |  |  | 12
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44025

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44025
Number of cores |  | 4
Spare cores |  | 2
Core size |  | 2.5mm2
Cable Type |  | Cu, PVC
Drawing References
Cable Service |  | [NAME]
Panel Number | T44 PP |  | Panel Number |  | GCB4
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | GCB4 | INITIAL
1 | 20/ADY441210 |  | TBX5:59 |  | [NAME]
2 | 20/ADY441229 |  | TBX5:61 |  | X12:8
3 | Spare
4 | Spare
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes | 2011-08-02 00:00:00 | Links between X12:11 and X12:7 in GCB4 |  |  |  | DJC
Edition Notes
Spreadsheet: 249976d1373706757-best-way-to-import-this-data-sample1-version-1-
Sheet: Master

PartNumber | Description | Quantity
11723 | 3.3125 | 1000000
46281 | 5.5 | 250000
46527 | 2 | 8900
32995 | 8.125 | 75000
304969 | 4 | 8200
128630 | 7 | 300000
58943 | 1.333333333333333 | 400
64209 | 12 | 5000000
38756 | 10 | 320000
12164 | 3.125 | 7000
967313 | 0.4375 | 1200000
Spreadsheet: 555132d1515447516-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 5

 |  |  | Tournament 5
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  |  |  | 55
 |  |  |  | 38
 |  |  |  | 29
 |  |  |  | 31
 |  |  |  | 40
 |  |  |  | 66
 |  |  |  | 59
 |  |  |  | 60
 |  |  |  | 55
 |  |  |  | 62
 |  |  |  | 57
 |  |  |  | 57
 |  |  |  | 76
 |  |  |  | 72
 |  |  |  | 68
 |  |  |  | 49
 |  |  |  | 76
 |  |  |  | 41
 |  |  |  | 57
 |  |  |  | 64
 |  |  |  | 59
 |  |  |  | 48
 |  |  |  | 60
 |  |  |  | 49
 |  |  |  | 47
 |  |  |  | 31
 |  |  |  | 36
 |  |  |  | 42
 |  |  |  | 59
 |  |  |  | 50
 |  |  |  | 36
 |  |  |  | 47
 |  |  |  | 57
 |  |  |  | 41
 |  |  |  | 49
 |  |  |  | 71
 |  |  |  | 55
 |  |  |  | 60
 |  |  |  | 30
 |  |  |  | 44
 |  |  |  | 38
 |  |  |  | 32
 |  |  |  | 69
 |  |  |  | 52
 |  |  |  | 52
 |  |  |  | 32
 |  |  |  | 69
 |  |  |  | 70
 |  |  |  | 62
 |  |  |  | 74
 |  | x | x | x
Spreadsheet: chris_stokley__3869__EES 1
Sheet: EES Wind

EES Wind ISO Settlement 01/01/2001 - 01/31/2001
 |  | EPMI Charges To Customers
Trans Type | (All)
 |  |  | Data
Customer | ID | Desc. | Expense | Revenue | Total | Volume
[NAME] | 402 | Generation Deviation | -86786.32189518584 | 258.830756826 | -86527.49113835982 | 715.3455012000003
 | 487 | Allocation Excess Cost for IE | -0.23 | 8.55 | 8.32 | -0.02
 | 523 | Market Operations Charge | -0.6123000000000001 | 3.043375053 | 2.431075053 | -2.553650327617182
EES_2 | 402 | Generation Deviation | -104974.6004189442 | 396.588881065 | -104578.0115378792 | 880.7640377000001
 | 487 | Allocation Excess Cost for IE | -0.76 | 9.91 | 9.15 | -0.01
 | 523 | Market Operations Charge | -1.3643 | 7.328881426200001 | 5.964581426200001 | -6.278408413950117
EES_3 | 402 | Generation Deviation | -68988.07919172 | 6277.475219147001 | -62710.60397257301 | 523.3413650000001
 | 487 | Allocation Excess Cost for IE | -0.14 | 3.99 | 3.85 | 0
 | 523 | Market Operations Charge | -0.4079 | 2.2084018736 | 1.8005018736 | -1.895773874865373
Grand Total |  |  | -260752.51600585 | 6967.925515390801 | -253784.5904904592 | 2108.693071283568
Spreadsheet: 455233d1460167725-top-4-male-and-top-4-female-scores-with-4-more-top-scores-added-rank_top4
Sheet: Sheet1

 | Top
 | Hurdle
 | Count
 | Name | Tag In | Score | 10's | Rank in Div | Overall rank |  | Male |  |  | Female
1 | [NAME] | Male | 273 | 16
2 | [NAME] | Male | 264 | 9
3 | [NAME] | Male | 263 | 7
4 | [NAME] | Male | 261 | 12
5 | [NAME] | Female | 203 | 2
6 | Morgan King | Female | 190 | 1
7 | [NAME] | Male | 261 | 7
8 | [NAME] | Female | 201 | 1
9 | [NAME] | Male | 260 | 7
10 | [NAME] | Male | 252 | 8
11 | [NAME] | Male | 246 | 5
12 | [NAME] | Male | 236 | 5
13 | Christian Popoca | Male | 235 | 6
14 | [NAME] | Male | 233 | 3
15 | [NAME] | Male | 232 | 7
16 | [NAME] | Male | 227 | 1
17 | [NAME] | Female | 224 | 1
18 | Rose Degrande | Female | 218 | 4
19 | [NAME] | Female | 218 | 0
20 | [NAME] | Male | 215 | 1
21 | [NAME] | Male | 166 | 2
22 | [NAME] | Female | 154 | 0
23 | [NAME] | Female | 0 | 3
24 | [NAME] | Male | 0 | 2
25 | [NAME] | Male | 0 | 1
Spreadsheet: 648454d1573055041-simple-pivot-table-issue-missing-something-samplepivot
Sheet: Data

Part# | Name | Quantity | Year
100 | One Hundred | 3 | 2019
100 | One Hundred | 3 | 2018
200 | Two Hundred | 4 | 2018
200 | Two Hundred | 5 | 2019
Spreadsheet: 703254d1604907188-top-10-list-with-one-more-dynamic-value-top-10-list-with-one-more-dynamic-value
Sheet: Sheet1

Problem |  |  |  |  |  |  |  |  | Result
Sl. No. | State | Value |  | What to Do |  | Desired State | L |  | Sl. No. | State | Value
1 | A | 2333 |  | List top 10 based on the values field and compare with a specific state, if the specified state is already in the top 10 then do nothing other wise add the specific state to the list and remaining as other states.  The Desired State is a dynamic value and to be selected from the dropdown list. |  |  |  |  | 1
2 | B | 6565 |  |  |  |  |  |  | 2
3 | C | 48 |  |  |  |  |  |  | 3
4 | D | 5484 |  |  |  |  |  |  | 4
5 | E | 4541 |  |  |  |  |  |  | 5
6 | F | 54551 |  |  |  |  |  |  | 6
7 | G | 545 |  |  |  |  |  |  | 7
8 | H | 448 |  |  |  |  |  |  | 8
9 | I | 48897 |  |  |  |  |  |  | 9
10 | J | 112121 |  |  |  |  |  |  | 10
11 | K | 151 |  |  |  |  |  |  | 11 | L | 15
12 | L | 15 |  |  |  |  |  |  | 12 | Other States
13 | M | 1548 |  |  |  |  |  |  |  | Total
14 | N | 4548
15 | O | 5487
16 | P | 4848
17 | Q | 48
18 | R | 445
19 | S | 58
20 | T | 4884
 | Total
Spreadsheet: 44291d1242912252-return-unique-text-values-without-advanced-filter-interior-doors
Sheet: 56 Int Doors

 | Interior Doors
 | Base House
 | Item | Qty | Location/Room
 | 20-68 Twin Ballcatch Interior Door | 1 | Study
 | 24-68 LH Interior Door | 1 | Coat Closet
 | 24-68 LH Interior Door | 1 | Powder Bath
 | 28-68 LH Interior Door | 1 | Under Stair Closet
 | 24-68 LH Interior Door | 1 | Pantry
 | 20-68 LH Interior Door | 1 | [NAME]
 | 28-68 LH Interior Door | 1 | Mechanical Room
 | 28-68 RH Interior Door | 1 | Mechanical Room
 | 26-68 LH Interior Door | 1 | Bedroom # 2
 | 60-68 Bi-Pass Interior Door | 1 | Bedroom # 2
 | 26-68 LH Interior Door | 1 | Bedroom # 3
 | 60-68 Bi-Pass Interior Door | 1 | Bedroom # 3
 | 26-68 RH Interior Door | 1 | Bedroom # 4
 | 60-68 Bi-Pass Interior Door | 1 | Bedroom # 4
 | 26-68 LH Interior Door | 1 | Bedroom # 5
 | 60-68 Bi-Pass Interior Door | 1 | Bedroom # 5
 | 24-68 LH Interior Door | 1 | Bath # 3
 | 24-68 LH Interior Door | 1 | Bath # 4
 | 28-68 LH Interior Door | 1 | Laundry Room
 | 26-68 RH Interior Door | 1 | Owner's [NAME]
 | 24-68 LH Interior Door | 1 | Owner's [NAME]
 | 24-68 RH Interior Door | 2 | Owner's Bath
 | 16-68 LH Interior Door | 1 | Owner's Bath
 | Count of Base House Interior Doors
Spreadsheet: 24778d1215601285-how-to-arrange-name-lines-alphabetically-specimen-file
Sheet: Sheet1

EXISTING FORMAT
Name & Address | Age | Contact No. | Occupation | Office Address
[NAME] | 42 | 1111111111 | sdfasdfasdfasdf | sdfasdfasdfasdfds
29 Avenue, 3rd Street
Washington
[NAME] | 55 | 2222222222 | nzxcvxclkasdf | wdjuflasdfjk
42nd Street, Times Square
New York
[NAME] | 45 | 33333333333 | tyiou[tyuioy[ | hjglfgjsdf
3rd Street, Defence Circle
Capetown, SA
REQUIRED FORMAT
[NAME] | 55 | 2222222222 | nzxcvxclkasdf | wdjuflasdfjk
42nd Street, Times Square
New York
[NAME] | 42 | 1111111111 | sdfasdfasdfasdf | sdfasdfasdfasdfds
29 Avenue, 3rd Street
Washington
[NAME] | 45 | 33333333333 | tyiou[tyuioy[ | hjglfgjsdf
3rd Street, Defence Circle
Capetown, SA
Spreadsheet: 73079d1273743995-indentifying-trends-and-progressive-increase-or-decrease-2009-vs-2010
Sheet: Sheet1

 | 2009 |  |  |  |  | 2010
 | January | Februray | March | April |  | January | February | March | April
 | 45 | 44 | 43 | 44 | Agents | 36 | 47 | 50 | 42
 | 6136 | 6621 | 6190 | 4318 | Applications | 4574 | 5018 | 5917 | 5238
 | 154358 | 184776 | 186791 | 157362 | Dials | 119514 | 154700 | 227228 | 195444
 | 73941 | 77532 | 96955 | 81802 | Leads Used | 54705 | 43521 | 70951 | 59325
 | 0.5556 | 0.6716 | 0.5 | 0.33 | Contactability | 0.5017 | 0.6042 | 0.6092 | 0.4565
 | 2.087583343476556 | 2.383222411391425 | 1.926574183899747 | 1.923693797217672 | Dials to leads | 2.184699753221826 | 3.554605822476506 | 3.202604614452228 | 3.294462705436157
 | 0.08298508270107248 | 0.08539699736882836 | 0.06384405136403486 | 0.05278599545243393 | Applications to Leads | 0.0836121012704506 | 0.1153006594517589 | 0.0833955828670491 | 0.08829329962073325
 | 12.05035853976532 | 11.71001359311282 | 15.66316639741519 | 18.94441871236684 | Leads to Applications | 11.95999125491911 | 8.672977281785572 | 11.99104275815447 | 11.32588774341352
 | 7 | 8 | 7 | 5 | Average Sales per consultant per month | 6 | 5 | 5 | 6
 | Recency 2010
 | Month | Sales
 | January | 323
 | February | 426
 | March | 727
 | April | 394
Spreadsheet: 690648d1597221253-counting-colours-2020-08-12-oeldere-digbee-690644d1597220288-counting-colours-dummy-help
Sheet: Pivot

 |  |  |  |  |  |  | Contact Made | Yes
Count of Ward | Column Labels |  |  |  |  |  | Count of Ward | Column Labels
Row Labels | [NAME] | Yes | (blank) | Grand Total |  |  | Row Labels | Other | Tenant already updated rent | Tenant going to update rent | Grand Total
ARB1 | 62 | 46 | 20 | 128 |  |  | ARB1 | 2 | 12 | 32 | 46
[NAME] | 39 | 35 | 68 | 142 |  |  | [NAME] | 2 | 13 | 20 | 35
BRW1 | 40 | 77 |  | 117 |  |  | BRW1 | 7 | 37 | 33 | 77
ELC1 | 12 | 37 |  | 49 |  |  | ELC1 | 2 | 23 | 12 | 37
FAB1 | 22 | 111 | 5 | 138 |  |  | FAB1 | 51 | 19 | 41 | 111
LIN1 | 15 | 24 | 1 | 40 |  |  | LIN1 |  | 10 | 14 | 24
[NAME] | 22 | 40 | 13 | 75 |  |  | [NAME] | 16 | 19 | 5 | 40
LVS1 | 1 | 52 | 27 | 80 |  |  | LVS1 | 19 | 22 | 11 | 52
WHB1 | 77 | 112 | 21 | 210 |  |  | WHB1 | 25 | 36 | 51 | 112
Grand Total | 290 | 534 | 155 | 979 |  |  | Grand Total | 124 | 191 | 219 | 534
Spreadsheet: 193681d1352912122-vlookup-function-on-excel-2010-not-working-vlookup-testing
Sheet: Sheet1

DATA
 |  |  |  | [NAME] | Value= TRUE | Value=FALSE
Sl. No | Name | Location |  | [NAME]
1 | [NAME] | Houston |  | [NAME]
2 | [NAME] | Chicago |  | [NAME]
3 | [NAME] | LA |  | [NAME]
4 | [NAME] | New York |  | [NAME]
5 | [NAME] | Washington |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 755247d1636732645-articles-by-client-products
Sheet: Folha1

Nº CLIENT | NAME | Nº ARTICLE | NAME ARTICLE | PRICE | DISCOUNT | FINAL PRICE
1 | [NAME] | 001 | COFFEE | 10 | 0.2
1 | [NAME] | 00456 | BEER | 15.5 | 0.2
3 | [NAME] | 001 | COFFEE | 10 | 0.15
4 | LOUIS | 0010500 | SANDWICH | 8.4 | 0.11
5 | JEAN | 00107107 | STRAWBERRIES | 4 | 0.25
5 | JEAN | 0012345 | POTATOES | 2.5 | 0.25
5 | JEAN | 000101 | ORANGES | 3.5 | 0.25
5 | JEAN | 00342 | GRAPE | 7 | 0.25
6 | ROSE | 00107107 | STRAWBERRIES | 4 | 0.14
7 | PETER | 00107107 | STRAWBERRIES | 4 | 0.12
7 | PETER | 001 | COFFEE | 10 | 0.11
Spreadsheet: 727169d1617739163-create-a-report-of-trucks-and-total-hours-sorted-by-totals-descending-trucks
Sheet: Data

Date | Truck | From | TO | Total
2020-03-19 00:00:00 | 9638 | 09:00:00 | 12:00:00 | 3
2020-03-19 00:00:00 | 5314 | 09:00:00 | 12:00:00 | 3
2020-03-19 00:00:00 | 3518 | 09:00:00 | 12:00:00 | 3
2020-03-19 00:00:00 | 5796 | 09:00:00 | 12:00:00 | 3
2020-03-19 00:00:00 | 8697 | 09:00:00 | 12:00:00 | 3
2020-03-19 00:00:00 | 4621 | 09:00:00 | 10:00:00 | 1
2020-03-19 00:00:00 | بلاز 5 | 09:00:00 | 12:00:00 | 3
2020-03-19 00:00:00 | 9638 | 13:00:00 | 15:00:00 | 2.000000000000001
2020-03-19 00:00:00 | 5314 | 13:00:00 | 15:00:00 | 2.000000000000001
2020-03-19 00:00:00 | 5796 | 13:00:00 | 15:00:00 | 2.000000000000001
2020-03-19 00:00:00 | 8697 | 13:00:00 | 15:00:00 | 2.000000000000001
2020-03-19 00:00:00 | 4621 | 13:00:00 | 15:00:00 | 2.000000000000001
2020-03-19 00:00:00 | 3518 | 13:00:00 | 15:30:00 | 2.500000000000002
2020-03-19 00:00:00 | 9638 | 15:00:00 | 15:30:00 | 0.5000000000000009
2020-03-19 00:00:00 | 5314 | 15:00:00 | 15:30:00 | 0.5000000000000009
2020-03-19 00:00:00 | 5796 | 15:00:00 | 15:30:00 | 0.5000000000000009
2020-03-19 00:00:00 | 8697 | 15:00:00 | 15:30:00 | 0.5000000000000009
2020-03-19 00:00:00 | 4621 | 15:00:00 | 15:30:00 | 0.5000000000000009
2020-03-19 00:00:00 | 5796 | 16:30:00 | 18:00:00 | 1.5
2020-03-19 00:00:00 | أفيكو 2 | 16:30:00 | 18:00:00 | 1.5
2020-03-19 00:00:00 | 9638 | 16:30:00 | 18:00:00 | 1.5
2020-03-19 00:00:00 | 4621 | 16:30:00 | 18:00:00 | 1.5
2020-03-19 00:00:00 | 8697 | 16:30:00 | 18:00:00 | 1.5
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 17 Feb 20 - 22 Feb 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-02-17 00:00:00 | 2020-02-18 00:00:00 | 2020-02-19 00:00:00 | 2020-02-20 00:00:00 | 2020-02-21 00:00:00 | 2020-02-22 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 17/02/2020 - 22/02/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Dameon
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME]
[NAME] | ✓ | ✓ | [NAME] | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | [NAME] |  |  |  |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME]
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Nathan | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME]
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Tyson | ✓
Will | [NAME] | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | [NAME] | ✓ | ✓ | ✓ |  |  |  |  |  | ✓
 | AWAY | ✓ | ❌ | ✓ |  |  |  |  |  |  | ✓
 | AWAY | AWAY | ✓ | ✓ |  |  |  |  |  |  | ✓
Edge Protection [NAME] |  |  | 17/02/2020 - 22/02/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 17/02/2020 - 22/02/2020
Blum Warehouse |  |  | ✓ |  |  |  |  |  |  | Dameon | ✓
Canterbury Linen Services |  |  |  |  |  |  |  |  |  | [NAME]
Bascik |  |  | ✓ |  |  |  |  |  |  | [NAME]
Komatsu |  |  |  |  |  |  |  |  |  | [NAME] | ✓
47 Link Drive |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | N/A
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ✓
Spreadsheet: 786250d1657069171-sorting-my-problem
Sheet: 1

What it's now
Date | Costomer | Product
2022-02-01 00:00:00 | Costomer A | Product 1
2022-02-02 00:00:00 | Costomer A | Product 1
2022-05-06 00:00:00 | Costomer A | Product 2
2022-02-04 00:00:00 | Costomer B | Product 1
2022-02-15 00:00:00 | Costomer B | Product 3
2022-03-13 00:00:00 | Costomer C | Product 4
How it's should be
Customer | Product | Date | Product | Date | Product | Date
Costomer A | Product 1 | 2022-02-01 00:00:00 | Product 1 | 2022-02-02 00:00:00 | Product 2 | 2022-05-06 00:00:00
Costomer B | Product 1 | 2022-02-04 00:00:00 | Product 3 | 2022-02-15 00:00:00
Costomer C | Product 4 | 2022-03-13 00:00:00
Spreadsheet: 799851d1665351021-counting-the-emails-that-match-another-column-while-so-matching-a-condition-in-another-example-question-etaf-2-
Sheet: Sheet1

email | source | date | Count once |  | from | to
[EMAIL] | mobile | 2020-05-05 00:00:00 |  |  | 2020-05-06 00:00:00 | 2020-05-07 00:00:00
[EMAIL] | computer | 2020-05-05 00:00:00 |  |  |  |  | I am trying to count the number of time an email appears on sheet 2 that also appears on sheet 1 that is from source computer on dates 5/6/20 and 5/7/20.
[EMAIL] | computer | 2020-05-06 00:00:00
[EMAIL] | mobile | 2020-05-06 00:00:00
[EMAIL] | mobile | 2020-05-07 00:00:00
[EMAIL] | computer | 2020-05-07 00:00:00
Spreadsheet: 97813d1296901326-excel-2007-how-to-add-next-column-value-for-consecutive-patterns-763044_lewis_koh
Sheet: Sheet1

 | code | value | c1 | s1 |  | Manual calculation |  |  | Auto calculation
 | 1 | 2 |  |  |  | value  of [NAME] of code 0 | =-6
 | 0 | 3
 | 1 | 3 |  |  |  | Value of [NAME] of code 1 | =11.2 | (not 9)
 | 1 | 1
 | 1 | 2
 | 1 | 3.1
 | 0 | 4
 | 0 | 4
 | 1 | 2
 | 0 | -1
 | 0 | -2
 | 0 | -3
 | 1 | 2.2
 | 1 | 4
 | 1 | 4
 | 1 | 1
Spreadsheet: 586134d1534225947-eliminate-rows-except-the-one-with-the-latest-dates-example-sorted-by-member-associated-date
Sheet: Sheet3

Name | Date | Campaign Event
[NAME] | 2016-05-04 00:00:00 | 2016-05, AMER All, Accelerate Lenovo Channel Partner Forum |  | I want to see…
Jaime Dolly | 2018-01-12 00:00:00 | [NAME] 638 |  | Name | Date | Campaign Event
[NAME] | 2017-05-25 00:00:00 | 2017-05, [NAME], Newsletter Partner Q2
[NAME] | 2017-05-05 00:00:00 | 2017-04, [NAME], ITBA Storage Roadshow - Apr11 - Hamburg
[NAME] | 2016-05-27 00:00:00 | 2016-04, [NAME], ITBA Storage Roadshow - Apr06 - Hamburg
[NAME] | 2017-05-24 00:00:00 | 2017-05, [NAME], Newsletter Partner Q2
[NAME] | 2017-05-05 00:00:00 | 2017-04, [NAME], ITBA Storage Roadshow - Apr11 - Hamburg
[NAME] | 2016-05-27 00:00:00 | 2016-04, [NAME], ITBA Storage Roadshow - Apr06 - Hamburg
[NAME] | 2014-10-08 00:00:00 | 09-2014, [NAME], ITBA Germany Q3 2014
[NAME] | 2017-11-15 00:00:00 | 2017-09, [NAME], ITBA [NAME] Hamburg
[NAME] | 2016-12-28 00:00:00 | 2016-09, [NAME], ITBA Virtualization Roadshow - Sep28 - Hamburg
[NAME] | 2015-06-04 00:00:00 | 04-2015, [NAME], ITBA Roadshow - Apr21 - Hamburg
[NAME] | 2018-01-08 00:00:00 | 2017-12, [NAME], DC Webcast Serie - Teil 7 - All-Flash Märchen
[NAME] | 2017-05-05 00:00:00 | 2017-04, [NAME], ITBA Storage Roadshow - Apr11 - Hamburg
[NAME] | 2016-05-27 00:00:00 | 2016-04, [NAME], ITBA Storage Roadshow - Apr06 - Hamburg
[NAME] | 2014-10-08 00:00:00 | 09-2014, [NAME], ITBA Germany Q3 2014
[NAME] | 2014-12-04 00:00:00 | 05-2014, EMEA CE, Newsletter Partner Q2
[NAME] | 2014-04-23 00:00:00 | 03-2014, [NAME], ITBA Roadshow Hamburg
[NAME] | 2017-11-15 00:00:00 | 2017-09, [NAME], ITBA [NAME] Hamburg
[NAME] | 2016-12-28 00:00:00 | 2016-09, [NAME], ITBA Virtualization Roadshow - Sep28 - Hamburg
[NAME] | 2015-06-04 00:00:00 | 04-2015, [NAME], ITBA Roadshow - Apr21 - Hamburg
[NAME] | 2018-01-12 00:00:00 | [NAME] 638
Lex Luthor | 2014-10-21 00:00:00 | Whitepaper: 36 Reasons To Adopt SDS EN
Lex Luthor | 2015-04-17 00:00:00 | Requested a Virtual SAN
[NAME] | 2015-04-20 00:00:00 | 01-2015, EMEA ALL, Techtarget Asset Syndication
[NAME] | 2016-12-28 00:00:00 | 2016-09, [NAME], ITBA Virtualization Roadshow - Sep28 - Hamburg
Amalia [NAME] | 2017-08-02 00:00:00 | 2017-03, [NAME], IDG Standard Content Syndication Q1/Q2
[NAME] | 2017-04-11 00:00:00 | 2017-03, [NAME], IDG Standard Content Syndication Q1/Q2
[NAME] | 2017-05-10 00:00:00 | Requested a Virtual SAN
[NAME] | 2017-05-10 00:00:00 | Downloaded Virtual SAN Appliance
[NAME] | 2017-05-10 00:00:00 | Support Download: VMware vSphere 1.3 Plug-in for SANsymphony-V
[NAME] | 2017-05-10 00:00:00 | Support Download: Microsoft SCOM Management Pack 1.3
[NAME] | 2017-08-23 00:00:00 | 2017-08, [NAME], Newsletter [NAME]
[NAME] | 2016-06-13 00:00:00 | 2016-06, [NAME], IDC Storage Transformation - Jun07 - Frankfurt
Spreadsheet: 220560d1363193845-trying-to-retrieve-information-from-worksheet-to-a-form-workbook2-jacc
Sheet: Form

 |  | Design Inflow Information Report (Integra US) |  |  |  |  |  | Ref. No.: Date      :
Job No. | 85 |  |  |  |  |  |  |  |  |  |  |  | Matching row no:
Job In Date | 12./18/12
Author
Title | Business and Society, 9e
Publisher | Cengage Learning
Division | Mason
Sub-Division
Country | US
Currency | USD |  | (USD/GBP)
Project Manager | Emily Friel
Estimted Completion | 2013-12-02 00:00:00
Estimated Value | 1500 |  | Interior Design, Adaptation PAL stylesheet
Estimated Value | 300 |  | Interior Design Management Adaptation PAL
Estimated Value | 1500 |  | Cover Design Moderate
Estimated Value | 300 |  | Cover Design Management Moderate Core Book
Estimated Value | 200 |  | 20. Mechanical - Core Book
Estimated Value | 100 |  | Cover Design ISE
Estimated Value | 120 |  | Cover Management-Templated Series ISE
Estimated Value | 100 |  | 21. Mechanical (IE, ISE, AISE, ADV, Splits)
Notes: | combined interior and cover design inflow
Spreadsheet: bf975939-552e-4b35-a619-3308909b44db
Sheet: Example 1.3-blank

Example 1.3: Ranked data from problem 1.7 is provided below.  Calculate the mean, median and standard deviation of the 50 years of annual peak discharges.  Create a histogram of the data using bins of 1000.  [NAME] the bins by the median value
 |  |  |  |  |  | Residuals (x - xbar)
 | Years 1-10 | Years 11-20 | Years 21-30 | Years 31-40 | Years 41-50
 | 990 | 4610 | 5740 | 7170 | 9010
 | 1310 | 4710 | 6210 | 7380 | 9180
 | 1720 | 4780 | 6360 | 7460 | 9500
 | 2120 | 4780 | 6540 | 7760 | 9790
 | 2580 | 5050 | 6660 | 7930 | 10300
 | 3160 | 5150 | 6700 | 8250 | 10700
 | 3180 | 5380 | 6700 | 8350 | 10810
 | 3270 | 5500 | 6930 | 8670 | 11350
 | 3760 | 5530 | 6930 | 8730 | 11900
 | 4550 | 5580 | 7020 | 8860 | 12900
 |  |  |  |  |  | Residuals squared
What is the mean and mediane for the data?
Mean = |  |  | Standard Deviation =
Median = |  |  | Variance =
 |  |  | Skew =
How is the data shaped?  What is the mode of the data?
Bin | Bin | Frequency
0 - 999 | 500
1000 - 1999 | 1500
2000 - 2999 | 2500 |  |  |  |  | Sum of squares =
3000 - 3999 | 3500 |  |  |  |  | DF
4000 - 4999 | 4500 |  |  |  |  | Variance =
5000 - 5999 | 5500 |  |  |  |  | [NAME] =
6000 - 6999 | 6500
7000 - 7999 | 7500
8000 - 8999 | 8500
9000 - 9999 | 9500
10000 - 10999 | 10500
11000 - 11999 | 11500
12000 - 12999 | 12500