tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_stokley__3836__ISO to SCL Comparison Pivots
Sheet: Energy Split SCL and EPMI

Desc. | Supplemental
Total | Customer
MrktDt | ECTRT | ECTstCA | SCL | Grand Total
2000-09-06 00:00:00 | -3655.118107241004 | -913.827451810251 | -86807.81322197377 | -91376.75878102503
2000-09-07 00:00:00 | -1681.690112133335 | -420.4820030333341 | -39938.09798816669 | -42040.27010333336
2000-09-08 00:00:00 | -974.353305333334 | -243.5914513333337 | -23140.78867666664 | -24358.73343333331
2000-09-11 00:00:00 | -44.99969999999999 | -11.2494000000001 | -1068.7603 | -1125.0094
2000-09-12 00:00:00 | -2069.915901666668 | -517.4183754166678 | -49160.59186458333 | -51747.92614166666
2000-09-13 00:00:00 | -2132.241700000001 | -532.8886666666687 | -50645.53443333334 | -53310.66480000001
2000-09-14 00:00:00 | -1713.241466666667 | -428.3162666666676 | -40689.28943333335 | -42830.84716666669
2000-09-15 00:00:00 | -900.0000000000014 | -225 | -21375 | -22500
2000-09-16 00:00:00 | -1830.0083 | -457.5059 | -43462.57090000001 | -45750.0851
2000-09-17 00:00:00 | -1989.772154000001 | -497.4284385000012 | -47257.57735750002 | -49744.77795000003
2000-09-19 00:00:00 | -3258.961833333336 | -879.7904000000036 | -83586.92800000001 | -87725.68023333335
2000-09-20 00:00:00 | -1961.633666666669 | -501.2284333333359 | -47620.70566666673 | -50083.56776666674
Grand Total | -22211.93624704102 | -5628.726786760263 | -534753.6578422239 | -562594.3208760252
Spreadsheet: 887337d1737570768-looking-for-formula-to-generate-a-date-based-on-what-is-in-another-cell-excel-forum-sample-data
Sheet: Sheet1

ARRIVAL DATE | RMS | ARRIVAL AIRPORT | FLIGHT | ARRIVE HOTEL | DEPART HOTEL | FLIGHT | DEPARTURE DATE
2025-02-01 00:00:00 | 2 | IND | FX 3609 | 10:32 | 04:35 | DL 3105 | 2025-02-02 00:00:00
2025-02-01 00:00:00 | 2 | IND | FX 3645 | 10:56 | 06:10 | DL 3106 | 2025-02-02 00:00:00
2025-02-03 00:00:00 | 2 | IND | AA 0539 | 00:32 | 21:25 | FX 1307 | 2025-02-03 00:00:00
2025-02-03 00:00:00 | 2 | IND | UA 3426 | 13:16 | 02:30 | FX 1717 | 2025-02-04 00:00:00
2025-02-07 00:00:00 | 2 | IND | FX 0022 | 02:15 | 15:42 | DL 3126 | 2025-02-07 00:00:00
2025-02-10 00:00:00 | 2 | IND | UA 3426 | 13:16 | 02:30 | FX 1717 | 2025-02-11 00:00:00
2025-02-14 00:00:00 | 2 | IND | FX 0022 | 02:15 | 15:42 | DL 3126 | 2025-02-14 00:00:00
2025-02-14 00:00:00 | 2 | IND | FX 1654 | 02:29 | 14:23 | AA 1589 | 2025-02-14 00:00:00
2025-02-15 00:00:00 | 2 | IND | FX 1574 | 05:49 | 17:50 | AA 3764 | 2025-02-15 00:00:00
2025-02-15 00:00:00 | 2 | IND | FX 3609 | 10:32 | 04:40 | AA 2938 | 2025-02-16 00:00:00
2025-02-15 00:00:00 | 2 | IND | FX 3645 | 10:56 | 06:05 | UA 3483 | 2025-02-16 00:00:00
2025-02-15 00:00:00 | 2 | IND | FX 3629 | 11:31 | 06:05 | UA 3483 | 2025-02-16 00:00:00
2025-02-15 00:00:00 | 2 | IND | FX 0097 | 12:14 | 06:05 | UA 3483 | 2025-02-16 00:00:00
2025-02-15 00:00:00 | 1 | IND | FX 3617 | 12:29 | 06:45 | UA 0500 | 2025-02-16 00:00:00
Spreadsheet: 821215d1678509657-rank-from-current-table-to-desired-table-what-formula-do-i-use-rank-formula-1-ans
Sheet: Sheet1

 | Current table |  |  | desired table |  |  |  |  | RESULT
 | potatoes | 12 |  | peas | 15
 | carrots | 8 |  | potatoes | 12
 | peas | 15 |  | carrots | 8
 | cabbage | 3 |  | swede | 7
 | swede | 7 |  | beans | 5
 | beans | 5 |  | cabbage | 3
 | formula to produce the desired table from the current table please
Spreadsheet: 818401d1676810655-change-if-formula-to-get-rid-of-zeros-copy-of-daily-shipments-ii-6400-
Sheet: August Data

Days of the month | Daily Shippping Goal | Daily shipments Missed | Daily Shipment | Total Shipments to Date | Total Shipments  Missed to Date |  | Total Shipments to Date |  |  |  |  |  |  |  |  |  |  | Total Shipments  Missed to Date
1 | 2 | 1
2 | 3 | 1
3 | 10 | 3
4 | 9 | 1
5 | 0 | 1
6 | 0 | 3
7 | 7 | 0
8 | 7 | 2
9 | 8 | 1
10 | 10 | 1
11 | 9 | 1
12 | 0
13 | 0
14 | 10 | 8
15 | 9 | 1
16 | 8 | 2
17 | 15 | 1
18 | 1 | 1
19 | 0
20 | 0
21 | 15 | 1
22 | 12 | 2
23 | 11 | 1
24 | 5 | 4
25 | 5 | 1
26 | 0
27 | 0
28 | 10 | 1
29 | 2 | 1
30 | 5 | 1
31 | 5 | 4
Spreadsheet: phillip_m_love__30091__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 3/30/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
@ Link Networks, Inc. | V08068.1/4 | F | ONP | [NAME]
Booneville Natural Gas Corp., The | V07897.1 | F | NG | Brant Reves
EXCO Resources, Inc. | V07283.1 | F | WTI | [NAME]
Evergreen Printing & Publishing | V05886.1 | P | NWSP | [NAME]
Gas Alberta Inc. | V07997.1 | P | NGGJ | [NAME]
Indiana Utilities Corporation | V07879.1 | F | NG | Brant Reves
Linden Trading Company, Inc. | V05068.1 | P | ONP | [NAME]
New Counterparty | V04870.1 | P | NWSP | [NAME]
New Counterparty | V05203.1 | P | NBSK | [NAME]
New Counterparty | V05996.1 | P | ONP | [NAME]
New Counterparty | V06062.1 | P | ONP | [NAME]
Philadelphia Gas Works | V06872.1 | P | NG | [NAME]
Seminole Canada Energy Company | [NAME] | F | WTI | [NAME]
The Fiber Resource Group, Inc. | V06800.1 v08097.1 | P | NBSK | [NAME]
Trafigura Derivatives Limited | V07400.1 | F | C3GC | Credit Previously Provided
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Kinder Morgan Energy Partners | V04894.1 | F | NG | [NAME], Inc.
Nexen Inc. | V08048.3/4 | F | NG | Nexen Marketing
Reliant Energy Trading & Marketing | V06654.1/2/3 | F | NG | Reliant Energy Services, Inc.
Sempra Energy Trading Services | V08092.1/2 | F | [NAME]/WTI | Sempra Energy Trading Corp.
Texaco Energy Marketing L.P. | V06871.1 | F | NG | Texaco Natural Gas, Inc.
Texaco Inc. | V07890.1 | F | NG | Texaco Natural Gas, Inc.
Spreadsheet: 143161d1330244539-compare-2-values-from-1-table-with-2-values-from-second-table-copy-of-gaz
Sheet: Sheet1

prod. Time | 268 | 216 | 223
level | 1 | 1 | 1
active? | 1 | 1 | 1
accel. | 0 | 0 | 0
accel. dur. | 0 | 0 | 0
X Coord. | 3978 | 1299 | 1521
Y Coord. | 3960 | 2772 | 2520 |  | I would like Excel to compare B13:C14 with B6:D7 and if there is a match to multiply B1 or C1 with B12 or C12 depending if they match
Ore Remaining
When Empty |  |  |  |  | I.e in this case B6 and B7 matches C13 and C14 so the result in B8 would be C12*B1
 |  |  |  |  | and C6 and C7 matches D13 and [NAME] so the result would be D12*C1
 |  |  |  |  | and D6 and D7 matches B13 and B14 so the result in D8 would be B12*D1
Ore | 720 | 322 | 654
X Coord. | 1521 | 3978 | 1299
Y Coord. | 2520 | 3960 | 2772
Spreadsheet: 158510d1338287149-organizing-an-array-into-a-different-array-kybynn_2_dim_array_match_question_29may12_02
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | e | 0.1 | lvxczjk | 1
 | 1 | 2 | 3 | 4 | 5 |  |  |  | b | 0.5 | lkwkne | 2 |  | 1 | 2 | 3 | 4 | 5
a | jf | lskjd |  |  | xklvj |  |  |  | a | 0.6 | jf | 3 | a
b | lkwkne | [NAME] |  |  |  |  |  |  | g | 1 | lj | 4 | b
c |  | xvlkcj | [NAME] | qrwklr | xkjv |  |  |  | a | 1.2 | lskjd | 5 | c
d |  |  |  |  |  |  |  |  | b | 1.2 | [NAME] | 6 | d
e | lvxczjk |  | nskl |  | lskdjf |  |  |  | c | 1.5 | xvlkcj | 7 | e
f |  |  |  |  | werlmk |  |  |  | e | 2.2 | nskl | 8 | f
g |  | lj |  |  | do |  |  |  | c | 2.4 | [NAME] | 9 | g
 |  |  |  |  |  |  |  |  | c | 3.2 | qrwklr | 10
What I want to do is to display the yellow array according to the green array. |  |  |  |  |  |  |  |  | e | 4 | lskdjf | 11
The organization is based on the number in column L and the letter in column J |  |  |  |  |  |  |  |  | g | 4 | do | 12
In the green array, the letters from column K are displayed organized according to |  |  |  |  |  |  |  |  | a | 4 | xklvj | 13
the correct letter in column A and the correct number in row 2 |  |  |  |  |  |  |  |  | c | 4.1 | xkjv | 14
The numbers are organized as follows: If a number from column L is lower than the |  |  |  |  |  |  |  |  | f | 4.3 | werlmk | 15
number from row 2 it is organized in under the highest number of row 2
Sorry for the vague explanation
 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  | a
 |  |  |  |  |  |  | b
 |  |  |  |  |  |  | c
 |  |  |  |  |  |  | d
 |  |  |  |  |  |  | e
 |  |  |  |  |  |  | f
 |  |  |  |  |  |  | g
Spreadsheet: 749782d1633005606-create-4-week-average-sumif-office-365-formula-help-4-week-average
Sheet: Roll Up

15
 | Last 4 Wk Avg | Total
Item 1
Item 2
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10
Item 11
Item 12
Item 13
Item 14
Item 15
Item 16
Item 17
Item 18
Item 19
Item 20
Item 21
Item 22
Item 23
Item 24
Item 25
Spreadsheet: 45242d1244029662-formula-to-calculate-totals-from-three-different-sheets-topperformer
Sheet: TOTALS

NAME | TOTAL |  |  | Error Checking |  |  | Top 5 | Score
[NAME] | 467 |  |  | 467 |  | 1st | Bridget Mohale | 652
ankie Pitse | 483 |  |  | 483 |  | 2nd | [NAME] | 650
[NAME] | 334 |  |  | 334 |  | 3rd | Kamo C Maripane | 649
Bridget Mohale | 652 |  |  | 652 |  | 4th | Theresa Khela | 611
[NAME] | 427 |  |  | 427 |  | 5th | [NAME] | 596
[NAME] | 431 |  |  | 431
[NAME] | #N/A |  |  | 152
Dikeledi Shuping | #N/A |  |  | 164
[NAME] | 431 |  |  | 431
[NAME] | 331 |  |  | 331
[NAME] | #N/A |  |  | 25
Kamo C Maripane | 649 |  |  | 649
[NAME] | 566 |  |  | 566
[NAME] | 378 |  |  | 378
[NAME] | 527 |  |  | 527
[NAME] | 382 |  |  | 382
[NAME] | #N/A |  |  | 194
Lindiwe Maepa | 323 |  |  | 323
Mase Letseleha | 472 |  |  | 472
Matshidiso Kganyago | 386 |  |  | 386
Michelle Damons | 505 |  |  | 505
[NAME] | 479 |  |  | 479
Monchu Ntswane | 434 |  |  | 434
[NAME] | 450 |  |  | 450
Musiwalo [NAME] | 464 |  |  | 464
[NAME] | 569 |  |  | 569
[NAME] | 133 |  |  | 133
[NAME] | 548 |  |  | 548
[NAME] | 596 |  |  | 596
Phindile Ndhlovu | 546 |  |  | 546
[NAME] | 426 |  |  | 426
Phuti Mangaba | 483 |  |  | 483
[NAME] | #N/A |  |  | 40
[NAME] | 650 |  |  | 650
[NAME] | 402 |  |  | 402
[NAME] | #N/A |  |  | 13
[NAME] | 102 |  |  | 102
Sibusiso Sibeko | 471 |  |  | 471
Tahlitah Mosia | 396 |  |  | 396
Theresa Khela | 611 |  |  | 611
[NAME] | 109 |  |  | 109
Tumi Glodean Mekwa | 356 |  |  | 356
[NAME] | 477 |  |  | 477
Veronique Legoabe | 152 |  |  | 152
[NAME] | 499 |  |  | 499
Spreadsheet: dcc20257-698d-4288-8d17-1d5de9310942
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
EDCT | 1 | Collaborate with other educational institutions, government and community agencies, and community based organizations to obtain local/state/federal fund | None | -- Pick One -- | 1.1.r1 | Hire a full-time Foundation Director for grant application management and fund solicitation | OneTime | 99000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EDCT | 2 | Secure sustainable funding to support community outreach that develops and provides rigorous and relevant programming for K-12 students, afterschool students, teachers and CC faculty to enhance academic and career success . | None | -- Pick One --
EDCT | 3 | Expand SBCCD EDCT's role in Logistics Technology Training programs to assist the Global Export and Logistics industrial sector/cluster in Southern California. | None | -- Pick One --
EDCT | 4 | Expand the scope of Nanotechnology training to include [NAME], Nanoenergy and [NAME] and continue to be a leader in the nation in providing cutting edge Nanotechnology training for technicians. | None | -- Pick One --
EDCT | 5 | Understand and develop programs to meet the workforce development needs of employers in the region. | None | -- Pick One --
EDCT | 6 | Market customized training and professional development programs to the community through various outreach efforts, community events, presentations at events and to the businesses | None | -- Pick One -- | 3.2.r1 | Marketing and outreach | OneTime | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EDCT | 7 | Enhance District-wide dissemination of information regarding EDCT's mission, value and training programs | None | -- Pick One -- | 5.1.r1 | Electronic publishing and e-mailing | OnGoing | 2000 | 0 | 2000 | 0 | 2000 | 0 | 0 | 0
Spreadsheet: 291820d1390413884-need-help-sorting-multiple-columns-sort-order-backwards
Sheet: Sheet1

Team | Wins | Losses | Points
[NAME] | 6 | 1 | 25 |  | Sort first by Points
[NAME] | 5 | 2 | 19 |  | Then by losses
[NAME] | 4 | 3 | 18 |  | Then by wins
[NAME] | 4 | 3 | 17
[NAME] | 4 | 3 | 16 |  | See the result to the right.
[NAME] | 3 | 4 | 9
[NAME] | 3 | 4 | 7
Trent | 2 | 5 | 5
[NAME] | 2 | 5 | 4
[NAME] | 2 | 5 | 3
George | 1 | 6 | 2
Spreadsheet: 837100d1689850671-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-132-aligw
Sheet: DATABASE2

Who | How many | Where |  | 1 - This is DATABASE 2
1 | 3 | 30
3 | 2 | 10 |  | 2 - This database is pasted from an erp to here in this format.
3 | 2 | 50
1 | 5 | 50 |  | 3 - Each year we paste a database to the excel file.
1 | 1 | 10
3 | 3 | 20
3 | 2 | 10
1 | 5 | 50
1 | 5 | 50
Spreadsheet: 234458d1368109014-from-two-sheets-copy-sheets-but-automatic-generate-1-on-two-cells-formula-possible-sample-only
Sheet: Instrument List

Instrument 1
Instrument 2
Instrument 3
Instrument 4
Instrument 5
Instrument 6
Instrument 7
Instrument 8
Instrument 9
Instrument 10
Instrument 11
Instrument 12
Instrument 13
Instrument 14
Instrument 15
Instrument 16
Instrument 17
Instrument 18
Instrument 19
Instrument 20
Instrument 21
Instrument 22
Instrument 23
Instrument 24
Instrument 25
Instrument 26
Instrument 27
Instrument 28
Instrument 29
Instrument 30
Instrument 31
Instrument 32
Instrument 33
Instrument 34
Instrument 35
Instrument 36
Instrument 37
Instrument 38
Instrument 39
Instrument 40
Instrument 41
Instrument 42
Instrument 43
Instrument 44
Instrument 45
Instrument 46
Instrument 47
Instrument 48
Instrument 49
Instrument 50
Instrument 51
Instrument 52
Instrument 53
Instrument 54
Instrument 55
Instrument 56
Instrument 57
Instrument 58
Instrument 59
Instrument 60
Instrument 61
Instrument 62
Instrument 63
Instrument 64
Instrument 65
Instrument 66
Instrument 67
Instrument 68
Instrument 69
Instrument 70
Instrument 71
Instrument 72
Instrument 73
Instrument 74
Instrument 75
Instrument 76
Instrument 77
Instrument 78
Instrument 79
Instrument 80
Instrument 81
Instrument 82
Instrument 83
Instrument 84
Instrument 85
Instrument 86
Instrument 87
Instrument 88
Instrument 89
Instrument 90
Instrument 91
Instrument 92
Instrument 93
Instrument 94
Instrument 95
Instrument 96
Instrument 97
Instrument 98
Instrument 99
Instrument 100
Spreadsheet: kate_symes__18835__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
 | 2001-03-10 00:00:00 |  | 156.73 | 17840 | 98.45 | 6040
 | 2001-03-09 00:00:00 |  | 157.31 | 16960 | 98.45 | 6040
 | 2001-03-08 00:00:00 |  | 213.95 | 22880 | 131.78 | 6600
 | 2001-03-07 00:00:00 |  | 313.92 | 24048 | 201.19 | 6080
 | 2001-03-06 00:00:00 |  | 339.12 | 29856 | 231.76 | 7080
 | 2001-03-05 00:00:00 |  | 299.82 | 13200 | 217.92 | 3080
 | 2001-03-04 00:00:00 |  |  |  |  |  | 217.92 | 9240
 | 2001-03-03 00:00:00 |  | 248.15 | 15920 | 165.24 | 2720
 | 2001-03-02 00:00:00 |  | 248.24 | 16400 | 165.07 | 3320
 | 2001-03-01 00:00:00 |  | 264.44 | 17648 | 164.24 | 7520
 | 2001-02-28 00:00:00 |  | 181.23 | 21200 | 120.65 | 4728
 | 2001-02-27 00:00:00 |  | 185.42 | 15344 | 116.58 | 2800
 | 2001-02-26 00:00:00 |  | 193.48 | 13840 | 132.88 | 4800
 | 2001-02-25 00:00:00 |  |  |  |  |  | 132.88 | 14400
 | 2001-02-24 00:00:00 |  | 177.7 | 16000 | 131.62 | 11200
 | 2001-02-23 00:00:00 |  | 179.36 | 17040 | 131.62 | 11200
 | 2001-02-22 00:00:00 |  | 229.75 | 23200 | 149.39 | 6448
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
 | 2001-02-19 00:00:00 |  | 262.12 | 13200 | 190.74 | 5400
 | 2001-02-18 00:00:00 |  |  |  |  |  | 261.52 | 23280
 | 2001-02-17 00:00:00 |  | 323.71 | 16720 | 264.62 | 8840
 | 2001-02-16 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-15 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-14 00:00:00 |  | 267.18 | 20320 | 202.45 | 6200
 | 2001-02-13 00:00:00 |  | 233.43 | 13520 | 159.16 | 7400
 | 2001-02-12 00:00:00 |  | 195.13 | 7760 | 159.51 | 6920
 | 2001-02-11 00:00:00 |  |  |  |  |  | 159.15 | 18960
 | 2001-02-10 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
Spreadsheet: 0c79b9a8-fb2f-4909-9abd-067130a9002f
Sheet: 2003

2003 Rank | NAME OF EMPLOYER | EMPLOYEES(1) | BUSINESS | 2002 Rank
1 | HARVARD UNIVERSITY | 8727 | HIGHER EDUCATION | 1
2 | MASSACHUSETTS INST. OF TECHNOLOGY | 8569 | HIGHER EDUCATION | 2
3 | CITY OF CAMBRIDGE(3) | 3226 | GOVERNMENT | 3
4 | CAMBRIDGE PUBLIC HEALTH COMM. | 1746 | MEDICAL | 5
5 | FEDERAL GOVERNMENT | 1690 | GOVERNMENT | 6
6 | BIOGEN INC. | 1467 | BIOTECHNOLOGY | 8
7 | MT. AUBURN HOSPITAL | 1449 | MEDICAL | 7
8 | MILLENNIUM PHARMACEUTICALS | 1412 | BIOTECHNOLOGY | 4
9 | GENZYME CORPORATION | 1005 | BIOTECHNOLOGY | 9
10 | DRAPER LABORATORY INC. | 923 | RESEARCH & DEVELOPMENT | 10
11 | WYETH/GENETICS INSTITUTE | 724 | BIOTECHNOLOGY | 11
12 | WHITEHEAD INSTITUTE | 690 | RESEARCH & DEVELOPMENT | 16
13 | COMMONWEALTH OF MASSACHUSETTS | 678 | GOVERNMENT | 12
14 | CAMP, DRESSER & MCKEE | 630 | ENGINEERING CONSULTANTS | 13
15 | LESLEY UNIVERSITY | 608 | HIGHER EDUCATION | 17
16 | QUEST DIAGNOSTICS | 593 | CLINICAL TESTING SERVICES | 15
17 | GRACE CONSTRUCTION | 554 | CONSTRUCTION PRODUCTS | 20
18 | VERTEX PHARMACEUTICALS INC. | 486 | BIOTECHNOLOGY | 19
19 | WHOLE FOODS/BREAD & CIRCUS | 476 | RETAIL SUPERMARKET | 14
20 | SHAWS SUPERMARKETS/STAR MARKET | 435 | RETAIL SUPERMARKET | 24
21 | EF INTERNATIONAL | 422 | TRAVEL & EXCHANGE PROGRAMS | 21
22 | ABT ASSOCIATES | 408 | MANAGEMENT CONSULTING | 23
23 | YOUVILLE HOSPITAL(2) | 403 | MEDICAL | 28
24 | MONITOR GROUP | 395 | MANAGEMENT CONSULTING | 22
25 | CAMBRIDGE [NAME]) | 353 | HOTEL | 31
Spreadsheet: 67151d1267737562-finding-matches-within-date-ranges-jk-test-page
Sheet: Sheet1

FY 2010 Schedule of Tasks: | Estimated | Estimated | Estimated | Estimated | Total
 | Start | Finish | Days | Hours / Day | Hours
Road Rehabilitation:
Mapping & Cluster Development | 2009-10-01 00:00:00 | 2009-12-29 00:00:00 | 64 | 8 | 512 |  | HRS/DAY
a) pavement management group |  |  |  |  |  | 2009-10-01 00:00:00
:meet with members for FY budget |  |  |  |  |  | 2009-10-02 00:00:00
:data needs (software, GIS, spreadsheet) |  |  |  |  |  | 2009-10-03 00:00:00
:political input or recommendations |  |  |  |  |  | 2009-10-04 00:00:00
:operations division input of concerns | 2009-10-02 00:00:00 | 2009-10-02 00:00:00 | 1 | 2 | 2 | 2009-10-05 00:00:00
:IMD input of concerns | 2009-10-02 00:00:00 | 2009-10-02 00:00:00 | 1 | 6 | 6 | 2009-10-06 00:00:00
:cluster criteria recommendations | 2009-10-01 00:00:00 | 2009-10-05 00:00:00 | 3 | 2 | 6 | 2009-10-07 00:00:00
:timeline of events |  |  |  |  |  | 2009-10-08 00:00:00
:future meeting schedule(s) |  |  |  |  |  | 2009-10-09 00:00:00
b) field assessment |  |  |  |  |  | 2009-10-10 00:00:00
:review road ranking of entire city (pms) | 2009-10-01 00:00:00 | 2009-10-05 00:00:00 | 3 | 2 | 6 | 2009-10-11 00:00:00
:develop map as directed from PMG |  |  |  |  |  | 2009-10-12 00:00:00
:review developed cluster areas | 2009-10-01 00:00:00 | 2009-10-06 00:00:00 | 4 | 2 | 8 | 2009-10-13 00:00:00
:review and correct map discrepancies |  |  |  |  |  | 2009-10-14 00:00:00
:prepare list for data analyst |  |  |  |  |  | 2009-10-15 00:00:00
Spreadsheet: 198287d1354727358-an-interesting-example-please-help-example
Sheet: Sheet1

Company name | Invest | Analyst |  | Investable companies: | [NAME] | [NAME]
Vodfone | Yes | [NAME]
HSBC |  | [NAME]
[NAME] | Yes | [NAME]
Barclays |  | [NAME]
IAG | Yes | [NAME]
Spreadsheet: 881260d1729255868-combining-and-analyzing-data-from-multiple-tables-power-query-sample
Sheet: ZSOR

[NAME] | Customer | KAM | Order# | Confirm Date | Remaining Qty | Remaining Value | Year | Month |  | RESULT in different tab
MP-5 | PEEE | FAHI | 200550 | 2023-09-11 00:00:00 | 59 | 668 |  |  |  | ZSOR AND [NAME] both tabs are updating regularly from auto system. (Linked)
MP-5 | PEEE | FAHI | 200550 | 2023-03-11 00:00:00 | 100 | 200 |  |  |  | I want to combined them and get the data as below.
MP-1 | ABC | AMIR | 20111 | 2023-03-11 00:00:00 | 110 | 612
MP-1 | CCC | ZAK | 200990 | 2024-03-11 00:00:00 | 225 | 753 |  |  |  |  | Slicer selected(2020)
MP-2 | MCY | ZAK | 200210 | 2024-05-05 00:00:00 | 256 | 850
MP-3 | NIM | IMRA | 2019010 | 2024-02-05 00:00:00 | 120 | 799 |  |  |  |  | [NAME] | Customer | KAM | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
MP-5 | PEEE | FAHI | 200550 | 2024-08-11 00:00:00 | 167 | 844 |  |  |  | Value pivot | MP-5 | PEEE | FAHI | 839
MP-1 | ABC | AMIR | 2110001 | 2025-03-11 00:00:00 | 92 | 711 |  |  |  |  | MP-1 | CCC | ZAK
MP-1 | CCC | ZAK | 100010 | 2025-01-11 00:00:00 | 142 | 659 |  |  |  |  | MP-3 | NIM | IMRA
MP-2 | MCY | ZAK | 120210 | 2024-07-05 00:00:00 | 200 | 843
MP-3 | NIM | IMRA | 222010 | 2025-02-05 00:00:00 | 128 | 711 |  |  |  |  | Slicer selected(2023)
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Customer | KAM | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep
 |  |  |  |  |  |  |  |  |  | Value pivot | MP-5 | PEEE | FAHI |  |  |  |  |  |  |  |  | 668
 |  |  |  |  |  |  |  |  |  |  | MP-1 | ABC | AMIR |  |  | 612
Spreadsheet: 757842d1638469481-im-looking-for-help-on-how-link-a-master-sheet-to-populate-another-sheets-in-the-workbook-team-roster-fix
Sheet: FGB

Washington Nationals
Team Owner
Team Salary
[NAME]
Available Salary
Roster
Minor League Players
Name-Pitchers | Salary | Years | Tm | Lg | W | L | W-L% | ERA | G | GS | GF | CG | SHO | SV | IP | H | R | ER | HR | BB | IBB | SO | HBP | BK | WP | BF | ERA+ | FIP | WHIP | BB9 | HR9 | H9 | SO9 | SO/W
 |  | Age | Tm | Lg | G | PA | AB | R | H | 2B | 3B | HR | RBI | SB | CS | BB | SO | BA | OBP | SLG | OPS | OPS+ | TB | GDP | HBP | SH | SF | IBB
[NAME] |  |  | Tm | Lg | G | PA | AB | R | H | 2B | 3B | HR | RBI | SB | CS | BB | SO | BA | OBP | SLG | OPS | P
Starling Marte
Spreadsheet: 853085d1703035937-subtotal-with-multiple-criteria-and-or-sumproduct-test-sumproduct
Sheet: Surveys_Sent_2023-12-19_14-44

 |  |  | The formula generating the results in the Opened column for sms and email are not accurate.
 | Delivery Method | Total | Opened | Responded
 | sms
 | [NAME]
 | Total
 | Response %
 | Totals
status | dontcontact | sent | opened | responded | deliverymethod
 |  | 2023-12-19 12:03:55 | 2023-12-19 12:06:16 |  | sms
 |  | 2023-12-19 12:03:55 |  |  | sms
 |  | 2023-12-19 12:03:55 |  |  | sms
 |  | 2023-12-19 12:03:55 |  |  | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 | 2023-12-19 12:07:31 | 2023-12-19 12:08:01 | sms
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 |  |  | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 | 2023-12-19 14:15:08 | 2023-12-19 14:15:30 | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 |  |  | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:53 |  |  | sms
 |  | 2023-12-19 12:03:53 | 2023-12-19 12:09:13 | 2023-12-19 12:09:29 | sms
 |  | 2023-12-19 12:03:53 |  |  | sms
 |  | 2023-12-19 12:03:54 | 2023-12-19 12:07:31 | 2023-12-19 12:08:01 | sms
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 |  |  | email
 |  | 2023-12-19 12:03:54 |  |  | sms
 |  | 2023-12-19 12:03:54 | 2023-12-19 14:15:08 | 2023-12-19 14:15:30 | email
Total