tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cara_semperger__1462__ENRON_BPA_FEBRUARY_POSITIONS
Sheet: January MONTH Positions

 |  |  | To: BPA [NAME]
 |  |  | From:
 |  |  | [NAME](503)464-3902 COB
 |  |  | [NAME] (503)464-3831 MIDC
2002-02-01 00:00:00
 | HLH |  |  |  | MID COLUMBIA
 | MONTH | 2 | C#10123 | X | BPA | ENRON | BPA | X | C#42022 | 2
 | MONTH | 50 | C#10123 | X | BPA | ENRON | BPA | X | C#10642 | 50
 | MONTH | 50 | C#10123 | X | BPA | ENRON | BPA | X | C#10742 | 50
 |  |  |  |  | OPEN | ENRON | BPA |  | C#24517 | 25
 |  |  |  |  | OPEN | ENRON | BPA |  | C#24474 | 25
 |  |  |  |  | OPEN | ENRON | BPA |  | C#10743 | 50
 |  |  |  |  | OPEN | ENRON | BPA |  | C#42022 | 12
 |  |  |  |  | OPEN | ENRON | BPA |  | C#42013 | 50
 |  |  |  |  | OPEN | ENRON | BPA |  | C#42014 | 50
 |  |  |  |  | OPEN | ENRON | BPA |  | C#24315 | 25
 | LLH M-SAT, 1-24 SUN AND HOLIDAYS
 | MONTH | 2 | C#10123 | X | BPA | ENRON | BPA | X | C#42022 | 2
 | MONTH | 50 | C#10123 | X | BPA | ENRON | BPA | X | C#10642 | 50
 | MONTH | 50 | C#10123 | X | BPA | ENRON | BPA | X | C#10742 | 50
 | MONTH | 25 | C#22450 | X | BPA | ENRON | BPA | X | C#42014 | 25
 |  |  |  |  | OPEN | ENRON | BPA |  | C#42022 | 11
 |  |  |  |  | OPEN | ENRON | BPA |  | C#10743 | 50
 |  |  |  |  | OPEN | ENRON | BPA |  | C#42013 | 50
 |  |  |  |  | OPEN | ENRON | BPA |  | C#42014 | 25
 | ALL HOURS ALL DAYS |  |  |  | COB
 | MONTH | 25 | C#21896 |  | BPA | ENRON | OPEN
 | MONTH | 25 | C#21892 |  | BPA | ENRON | OPEN
 | MONTH | 50 | C#23273 |  | BPA | ENRON | OPEN
 | MONTH | 50 | C#23274 |  | BPA | ENRON | OPEN
Spreadsheet: john_griffith__15746__10_16_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 63 | 340 | 440 | 40.9 | 52.9 | 1.86 | 2001-10-16 12:36:00
 | HO Z1 | 64 | 800 | 900 | 46.4 | 52.2 | 1.98 | 2001-10-16 12:36:00
 | HO F2 | 65 | 1100 | 1150 | 48.5 | 50.7 | 2.03 | 2001-10-16 12:36:00
 | HO G2 | 64 | 1180 | 1280 | 43.9 | 47.6 | 1.84 | 2001-10-16 12:36:00
 | [NAME] | 63 | 1200 | 1325 | 40.4 | 44.6 | 1.68 | 2001-10-16 12:36:00
 | HO J2 | 62 | 1200 | 1325 | 37.4 | 41.3 | 1.53 | 2001-10-16 12:36:00
 | HO K2 | 61 | 1200 | 1325 | 34.9 | 38.6 | 1.41 | 2001-10-16 12:36:00
 | HO M2 | 60 | 1175 | 1325 | 32.2 | 36.4 | 1.29 | 2001-10-16 12:36:00
 | HO N2 | 60 | 1175 | 1325 | 30.5 | 34.4 | 1.22 | 2001-10-16 12:36:00
 | HO Q2 |  |  |  | 29.1 | 31.4 | 1.2 | 2001-10-12 14:53:00
 | HO U2 |  | \ |  | 28.8 | 34.4 | 1.25 | 2001-10-12 14:53:00
 | [NAME] |  |  |  | 24.3 | 26.8 | 1.08 | 2001-08-20 15:41:00
 | HO X2
 | [NAME]
 | HO F3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 65465d1266184992-search-and-return-address-for-all-matches-findaddress
Sheet: Sheet1

A | F | K |  | Search: |  | Address:
B | G | L |  | A |  | $A$1 | $A$1
C | H | M |  |  |  | $C$4 | $C$4
D | I | A |  |  |  | $B$6 | $B$6
E | J | O |  |  |  | $A$8 | $A$8
N | A | K |  |  |  | $B$8 | $B$8
B | G | L |  |  |  | $C$8 | $C$8
A | A | A |  |  |  | $A$10 | $A$10
D | H | M |  |  |  |  | $C$10
A | J | A |  |  |  |  | $A$11
A | Q | D |  |  |  |  | $B$31
B | B | B |  |  |  |  | $A$35
B | B | B |  |  |  |  | $C$35
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | B | B
B | A | B
B | B | B
B | B | B
B | B | B
A | B | A
Spreadsheet: 844296d1696008753-some-excel-tasks-forecast-and-demand-tasks
Sheet: Zad.2

Zad. 2 | Remove the repeated values from "Column 1", then assign the correct description based on the data from the "Data for task.2" tab.
 | Column 1 | Column2
 | 1046257
 | 1044991
 | 1045003
 | 1045465
 | 1045017
 | 1045682
 | 1045686
 | 1045683
 | 1046410
 | 1046411
 | 1046412
 | 1046413
 | 1046414
 | 1046415
 | 1046416
 | 1046417
 | 1048269
 | 1048270
 | 1048271
 | 1048272
 | 1046951
 | 1046952
 | 1046950
 | 1047101
 | 1048652
 | 1048653
 | 1048654
 | 1048655
 | 1048817
 | 1048818
 | 1048819
Spreadsheet: 215659d1361447986-extracting-rows-from-a-spreadsheet-based-on-a-unique-code-that-may-appear-in-two-columns-book1
Sheet: Sheet1

Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6
1234 |  | 1234 | [NAME] | Abc1
1235 |  | 1234 | data2 | Abc2
1236 |  | 1234 | data3 | Abc3
1237 |  | 1234 | data4 | Abc4
1238 |  | 1235 | data5 | [NAME]
1239 |  | 1236 | [NAME] | Abc6
1240 |  | 1237 | data7 | Abc7
1234 |  | 1238 | data8 | Abc8
1235 |  | 1234 | data9 | Abc9
1236 |  | 1235 | data10 | Abc10
1237 |  | 1236 | data11 | Abc11
1234 |  | 1237 | data12 | Abc12
1235 |  | 1238 | data13 | Abc13
1236 |  | 1239 | data14 | Abc14
1237 |  | 1240 | data15 | Abc15
1238 |  | 1241 | data16 | Abc16
1239 |  | 1242 | data17 | Abc17
1240 |  | 1243 | data18 | Abc18
Spreadsheet: 202baab5-eac3-4924-841f-f8fb278a5ed0
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
SERWB | Test | SERWB | Serotonin, Blood | Serotonin, B | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | EDTA (lavender-top) tube: EDTA |  |  | 2.5 | mL | Collection Container/Tube: Lavender top (EDTA) Submission Container/Tube: Serotonin tube (Supply T259) containing ascorbic acid [NAME]: 2.5 mL Collection Instructions: 1. Transfer 2.5 mL whole blood to serotonin tube and mix well. Note: The amount of whole blood added to the tube is based on the amount of ascorbic acid. 2. Immediately freeze specimen. Additional Information: Medications that may affect serotonin concentrations include lithium, MAO inhibitors, methyldopa, morphine, and reserpine. | 2.5 mL | Hemolysis	NA Thawing	Warm reject; Cold OK - refreeze Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | < or =330 ng/mL | Monday, Wednesday, Friday; 10 a.m. | 2 days | 6 days | 1 | 84260 |  |  |  |  | Rochester
SERWB | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Frozen | 90 days
SERWB | Result | 84373 | Serotonin, B | Serotonin, B | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2939-7 | Serotonin:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 688226d1595633457-using-sumifs-to-categorize-expenditures-monthly-example1
Sheet: expense

Expenses |  |  |  | June |  | July |  | August |  | September |  | October |  | November |  | December
Advertising |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Truck Expenses |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Lawn Equipment Purchases |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Lawn Equipment Repar |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Lawn Equipment Supplies |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Gas |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Lawn Oil/Gas |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Licenses |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Insurance (General Liability Insurance) |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Food |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Customer Repair |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 769493d1645559447-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Average Checkins per AG+Week

Weeks | Start Date | End Date
Week 1 | 2022-01-03 00:00:00 | 2022-01-09 00:00:00
Week 2 | 2022-01-10 00:00:00 | 2022-01-16 00:00:00 |  |  |  | IS THERE A WAY TO TAKE WHAT'S ON THE AVERAGE CHECKINS PER AGE GROUP TAB AND DO IT PER WEEK?
Week 3 | 2022-01-17 00:00:00 | 2022-01-23 00:00:00
Week 4 | 2022-01-24 00:00:00 | 2022-01-30 00:00:00
Starting Age | Ending Age
13 | 19
20 | 29
30 | 39
40 | 49
50 | 59
60 | 69
70 | 79
80 | 89
90 | 99999
Spreadsheet: 728376d1618420385-display-all-the-clients-from-different-sheets-display-all-the-clients-from-different-sheets
Sheet: Product A

Product A
Clients
Client A |  | 1
Client B |  | 1
Client C |  | 1
Client D |  | 1
Client E |  | 1
Client F |  | 1
...
...
...
Spreadsheet: 600730d1543933299-indirect-need-cell-range-to-change-to-the-indirect-method-indirect
Sheet: Data

Dates | Age | Band |  | 0 | 18-25
2018-01-25 00:00:00 | 23 |  |  | 26 | 26-35
2018-01-26 00:00:00 | 42 |  |  | 36 | 36-45
2018-01-27 00:00:00 |  |  |  | 46 | 46-55
2018-01-28 00:00:00 | 33 |  |  | 56 | 56-70
2018-01-29 00:00:00 | 57 |  |  | 70 | 56-70
2018-01-30 00:00:00 | 44
2018-01-31 00:00:00 | 20
2018-02-01 00:00:00 | 63
2018-02-02 00:00:00 | 57
2017-02-03 00:00:00 | Unknown
Spreadsheet: 848189d1698960987-pmt-formula-fusionista-pmt-formula
Sheet: Sheet7

 | Beginning Balance | Principal payment | Interest payment | Total payment | Ending balance
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 753644d1635602878-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-t8
Sheet: ORDER LIST

CHEAPEST ORDER LIST BY SUPPLIER
 | SUPPLIER | PRODUCTS | PRICE | QTY | ORDER CODE | PHONE NUMBER | [NAME]
 | BOOKER |  |  |  | 1234 | 015394 33679 | [EMAIL]
 |  | Coke
 |  | Coke BIB
 |  | Diet Coke
 |  | Diet Coke BIB
 |  | Ginger Beer
 |  | Old Mout Berries & Cherries
 |  | Old Mout Kiwi & Lime
 |  | Peroni
 |  | Pimms
 |  | Prosecco Spumante
 |  | [NAME]
 |  | San Pellegrino Orange
 |  | San Pellegrino Sparkling
 |  | Scweppes BIB
 |  | Shipyard American IPA
 |  | Strathmore Sparkling Mineral Water
 |  | Strathmore Still Mineral Water
 |  | Volvic
 |  | Wyldwood Organic Cider
 |  | [NAME]
Spreadsheet: 167601d1342034890-sum-per-10-cells-count-each-100-oeldere-
Sheet: Blad1

1 |  | 99 | 4950 |  |  | 100
2 |  | 199 | 20000
3 |  | 299 | 30000
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
200
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
300
Spreadsheet: 737842d1624624823-need-a-single-formulas-to-calculate-net-worth-overall-gain-and-couple-of-more-parameters-money
Sheet: working to cal avg inv price

 | Date | Side | Qty | Price | Value |  |  | This is how I made my transactions
 | 2021-07-01 00:00:00 | Buy | 225 | 10000 |  |  |  | Date | Price | Side | ShareQty
 | 2021-07-01 00:00:00 | Buy | 75 | 10200 |  |  |  | 2021-05-25 00:00:00 | 100.4 | BUY | 250
 |  |  |  |  |  |  |  | 2021-05-31 00:00:00 | 92.5 | BUY | 54
 |  |  |  |  |  |  |  | 2021-06-03 00:00:00 | 100.75 | SELL | -14
 | Date | Side | Qty | Price | Value |  |  | 2021-06-07 00:00:00 | 126.9 | SELL | -38
 | 2021-07-01 00:00:00 | Buy | 225 | 10000 |  |  |  | 2021-06-10 00:00:00 | 154.1 | SELL | -27
 | 2021-07-01 00:00:00 | Buy | 75 | 10200 |  |  |  | 2021-06-14 00:00:00 | 140.9 | BUY | 40
 |  |  |  |  |  |  |  | 2021-06-16 00:00:00 | 127.25 | BUY | 40
 | 2021-07-05 00:00:00 | Sell | 150 | 9950 |  |  |  | 2021-06-18 00:00:00 | 114.9 | BUY | 40
 |  |  |  |  |  |  |  | 2021-06-22 00:00:00 | 126.6 | SELL | -18
 |  |  |  |  |  |  |  | 2021-06-24 00:00:00 | 119.7 | BUY | 35
 | Date | Side | Qty | Price | Value |  |  | 2021-05-25 00:00:00 | 100.4 | BUY | 153
 | 2021-07-01 00:00:00 | Buy | 75 | 10000 |  |  |  | 2021-05-31 00:00:00 | 92.5 | BUY | 54
 | 2021-07-01 00:00:00 | Buy | 75 | 10200 |  |  |  | 2021-06-14 00:00:00 | 140.9 | BUY | 40
 |  |  |  |  |  |  |  | 2021-06-16 00:00:00 | 127.25 | BUY | 40
 |  |  |  |  |  |  |  | 2021-06-18 00:00:00 | 114.9 | BUY | 40
 |  |  |  |  |  |  |  | 2021-06-24 00:00:00 | 119.7 | BUY | 35
Spreadsheet: michelle_lokay__26713__1201invsumm
Sheet: Sheet1

[NAME]
December transportation invoices
Not paid as of 1/24/02    2:00 p.m.
ENA ***** |  |  |  | 315580 | ENA agent for Enervest until 12/31-$205,344(contr end date 12/31/01)
ENRON ENERGY SERVICES, INC. |  |  |  | 22886.32 | cont 27762 - contr end date 12/31/01
[NAME] dispute (reserved by [NAME]) |  |  |  | 53256 | [NAME] dispute
BASS ENTERPRISES PRODUCTION |  |  |  | 6975 | Ward
Citizens |  |  |  | 279195 | Mulligan | claims to have sent check on 1/22/02 - need to get them to start wiring
CMS CONTINENTAL NATURAL GAS INC. |  |  |  | 1532.64 | McEvoy
DYNEGY MARKETING AND TRADE |  |  |  | 87885 | Minter | claims to have wired $$$ to Bank of America - they are investigating
MERCADO GAS SERVICES INC |  |  |  | 1499.71 | Giambrone
NORTH STAR STEEL COMPANY |  |  |  | 31215.14 | Hernandez | why late?
ONEOK BUSHTON PROCESSING, INC |  |  |  | 24025.01 | Giambrone | have not paid Nov invoices either - why late??  -  also short paid [NAME] and Aug due to dispute
PHILLIPS PETROLEUM COMPANY |  |  |  |  | McEvoy | invoice $32,550 pd $31,527
SID RICHARDSON GASOLINE CO. |  |  |  | 265.36 | Ward
TRISTAR GAS MARKETING COMPANY |  |  |  | 167.6 | McEvoy
VIRGINIA POWER ENERGY MARKETING, INC. |  |  |  | 8505.21 | Giambrone | check sent 1/22
Spreadsheet: 118016d1313352824-linking-2-cells-together-premier-league-fun
Sheet: Table

 | Team | Total
1 | [NAME]
2 | Man Utd
3 | Liverpool
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | Chelsea
8 | Newcastle
9 | Everton
10 | Man City
11 | Swansea
12 | Tottenham
13 | Arsenal
14 | West Brom
15 | QPR
Spreadsheet: 32cc7d62-a0e2-47a3-a9e0-a0f8a573e7b2
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Jan 21 - 25, 2008
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1um | 1um
SVG                         Coater | Date (Coat) | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | 2008-01-23 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 4 | 1 | 2 | 4
 | Problems
Thickness Test                                (NanoSpec) | Date (Measurement) | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | 2008-01-23 00:00:00 | - | - | -
 | Top (A) | 10438 | 17486 |  | 10515 | 17281 | 30495 | - | - | -
 | Center (A) | 10405 | 17509 |  | 10501 | 17301 | 30793 | - | - | -
 | Flat (A) | 10429 | 17524 |  | 10512 | 17316 | 30603 | - | - | -
 | Left  (A) | 10456 | 17495 |  | 10520 | 17295 | 30585 | - | - | -
 | Right (A) | 10427 | 17510 |  | 10509 | 17286 | 30583 | - | - | -
 | Average (A) | 10431 | 17505 |  | 10511 | 17296 | 30612 | - | - | -
 | [NAME]  (A) | 19 | 15 |  | 7 | 14 | 110 | - | - | -
 | Comments
Exposure | Date (Exposure)
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.0s | 1.4s | 3.0s x2 | 1.1s | 1.4s | 3.0s
 | Problems
SVG                            Developer | Date (Develop)
 | Track | 2 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Test | Date (Measurement)
 | Top (H/V) (um)
 | Center (H/V) (um)
 | Flat (H/V) (um)
 | Left (H/V) (um)
 | Right (H/V) (um)
 | Comments
Spreadsheet: 600849d1544001307-reference-to-every-nth-column-reverse-offset-example
Sheet: Blad1

 | Jan | Jan | Feb | Feb | March | March | April | April | May | May | June | June | July | July | August | August | Total
Data
 | =INDEX($B10:$I10;(KOLUMNER($B:B)+1)/2) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =PRODUKTSUMMA(B2:Q2; REST(KOLUMN(B:Q)+1; 2))
 | 22268 |  | 22268 |  | 22268 |  | 22268 |  | 22268
 | Jan | Feb | March | Mars | Apr | March | May | June
DATA | 22894.9118861401 | 22804.74542379624 | 22714.78185018044 | 22625.02018466382 | 22535.45945135726 | 22446.0986790884 | 22356.93690137889 | 22267.9731564217
Spreadsheet: kate_symes__18301__DJ Index 4-16
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-16 00:00:00
Flow Date: | 2001-04-16 00:00:00
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 365 | 1200
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 332.5 | 400
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 378.7063953488372 | 8256
 | Firm Trades Purchases | 385 | 400
[NAME] | Firm Trades Sales | 355 | 1200
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 229.3055555555556 | 5760
 | Firm Trades Purchases | 231.625 | 3200
[NAME] | Firm Trades Sales | 116.6505882352941 | 3400
 | Firm Trades Purchases | 116.8333333333333 | 600
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 225.8823529411765 | 272
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 118.9361702127659 | 376
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 282.6946721311475 | 7808
 | Firm Trades Purchases | 280 | 400
[NAME] | Firm Trades Sales | 216.751968503937 | 2032
 | Firm Trades Purchases | 219.8 | 1000
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 247 | 4400
 | Firm Trades Purchases | 233.1787878787879 | 2640
[NAME] | Firm Trades Sales | 117.3529411764706 | 3400
 | Firm Trades Purchases | 125.6521739130435 | 184
Spreadsheet: 845688d1697096934-group-and-increment-avoiding-duplications-seq1-1-
Sheet: Sheet1

VARIATION 1
 | Cust1 | Cust2 | Cust3 | Cust4 | Cust5 | SEQUENCE
Grp1 | X |  | X |  |  |  | 1
[NAME] |  | X |  |  |  |  | 1
Grp3 | X |  |  | X |  |  | 2
Grp4 |  |  |  | X |  |  | 3
Grp5 |  |  |  |  | X |  | 1
Grp6 |  |  | X |  | X |  | 2
Grp7 | X |  |  | X | X |  | 4
Grp8 | X |  |  |  |  |  | 5
Grp9 |  | X | X |  |  |  | 3
[NAME] | X |  | X | X |  |  | 6
 | Cust1 | Cust2 | Cust3 | Cust4 | Cust5 | SEQUENCE
Grp1
[NAME]
Grp3
Grp4
Grp5
Grp6
Grp7
Grp8
Grp9
[NAME]
Spreadsheet: 879873d1727450429-compare-several-columns-ignore-blanks-example-6-
Sheet: Planilha1

I need to compare B3 to H18 if any number is equal. Both in lines or columns. Any repeted number should be flagged. [NAME] blanks.
 | Home Phone | Home Phone 2 | Business Phone | Business Phone 2 | [NAME] | Other Phone | [NAME] | Business Fax |  | DUPLICATE
 |  |  |  |  |  |  | (034) 3314 0400
 |  |  |  |  |  |  | (034) 992 222 115
 |  |  |  |  |  |  | (016) 981 028 901
 | (034) 992 678 000 |  | (034) 3334 8070 |  |  |  | (034) 998 787 081
 |  |  |  |  |  |  | (034) 992 807 189
 |  |  | (034) 997 670 022 |  |  |  | (034) 3314 7445
 |  |  |  |  |  |  | (031) 998 264 985
 |  |  |  |  |  |  | (012) 997 665 360
 | (034) 996 986 341
 |  |  | (034) 999 720 945 |  |  |  | (034) 3322 2478
 | (034) 3319 8032
 |  |  | (034) 988 150 973 |  |  |  | (034) 3333 2201
Spreadsheet: 142136d1329678382-summarise-data-from-multiple-sheets-based-on-dates-test-data
Sheet: Area 1

Date | reference | problem |  |  | problem a
 |  |  |  |  | problem b
2012-02-01 00:00:00 | abc123 | problem a |  |  | problem c
2012-02-02 00:00:00 | abc124 | [NAME] |  |  | [NAME]
2012-02-03 00:00:00 | abc125 | [NAME]
2012-02-04 00:00:00 | abc126 | [NAME]
2012-02-05 00:00:00 | abc127 | problem c
2012-02-07 00:00:00 | abc129 | problem b
2012-02-08 00:00:00 | abc130 | problem b
2012-02-09 00:00:00 | [NAME] | problem c
Spreadsheet: 110941d1307481800-excel-2007-groupby-and-distinct-groupdistinct
Sheet: Sheet1

trans | seq | key | item | sum
1213 | 1 | 29319280 | 106369 | 0
1214 | 1 | 1899446 | 106369 | 0
1220 | 1 | 125635869 | 106369 | 0
1221 | 1 | 125635875 | 106369 | 0
1221 | 2 | 125635875 | 202 | 25
1224 | 1 | 79531558 | 106369 | 0
1225 | 1 | 79531571 | 106369 | 0
1225 | 2 | 79531571 | 82164 | 3.99
1226 | 3 | 79531571 | 666666 | 2
Row Labels | Sum of sum | Count of trans
1213
29319280 | 0 | 1
1214
1899446 | 0 | 1
1220
125635869 | 0 | 1
1224
79531558 | 0 | 1
Grand Total | 0 | 4
Spreadsheet: 84406d1284467961-searching-and-applying-a-dummy-example
Sheet: Sheet1

STU_CODE | [NAME] | Economics | Mathematics
042322825 | SOCIOLOGY | 1 | 0
042322825 | SOCIOLOGY | 1 | 0
042322825 | [NAME] | 1 | 0
042322825 | [NAME] | 1 | 0
042322825 | LAW | 1 | 0
042322825 | LAW | 1 | 0
042322825 | [NAME] | 1 | 0
042322825 | [NAME] | 1 | 0
042322825 | BUSINESS | 1 | 0
042322825 | BUSINESS | 1 | 0
042442617 | CHINESE | 0 | 1
042442617 | CHINESE | 0 | 1
042442617 | MATHEMATICS | 0 | 1
042442617 | MATHEMATICS | 0 | 1
042442617 | BUSINESS STUDY | 0 | 1
042442617 | BUSINESS STUDY | 0 | 1
043093308 |  | 0 | 0
044481243 |  | 0 | 0
050277777 | BUSINESS STUDY | 0 | 1
050277777 | DRAMA/THEATRE | 0 | 1
050277777 | ENGLISH LIT. | 0 | 1
050277777 | MATHEMATICS | 0 | 1
050277777 | DRAMA/THEATRE | 0 | 1
050277777 | ENGLISH LIT. | 0 | 1
050277777 | SPANISH | 0 | 1
Spreadsheet: 749160d1632547485-display-list-of-new-or-updated-rows-in-a-list-update
Sheet: Paste

Title | PartID | Location | Price | Image [image] | Image2 [image2] | Image3 [image3] | Description | Quantity | Category | Dif
SamplePart1 | 1 | [NAME] | 0.04 |  |  |  | SampleDes1 | 500 | 0
SamplePart2 | 2 | LOC2 | 0.01 |  |  |  | SampleDes2 | 1280 | 0
SamplePart3 | 3 | [NAME] | 0.08 |  |  |  | SampleDes3 | 1260 | 0
SamplePart4 | 4 | LOC4 | 0.11 |  |  |  | SampleDes4 | 1021 | 0
SamplePart5 | 5 | LOC5 | 0.08 |  |  |  | SampleDes5 | 1000 | 0
SamplePart6 | 6 | LOC6 | 0.28 |  |  |  | SampleDes6 | 900 | 0
SamplePart7 | 7 | [NAME] | 0.14 |  |  |  | SampleDes7 | 733 | 0
SamplePart8 | 8 | LOC8 | 0.43 |  |  |  | SampleDes8 | 688 | 0
SamplePart9 | 9 | [NAME] | 3.83 |  |  |  | SampleDes9 | 540 | 0
SamplePart10 | 10 | LOC10 | 0.09 |  |  |  | SampleDes10 | 500 | 0
SamplePart11 | 11 | LOC11 | 0.08 |  |  |  | SampleDes11 | 500 | 0
[NAME] | 12 | LOC12 | 0.14 |  |  |  | SampleDes12 | 497 | 0
SamplePart13 | 13 | [NAME] | 3.34 |  |  |  | SampleDes13 | 410 | 0
SamplePart14 | 14 | LOC14 | 0.09 |  |  |  | SampleDes14 | 400 | 0
SamplePart15 | 15 | LOC15 | 0.06 |  |  |  | SampleDes15 | 396 | 0
SamplePart16 | 16 | LOC16 | 5.63 |  |  |  | SampleDes16 | 370 | 0
SamplePart17 | 17 | LOC17 | 1.59 |  |  |  | SampleDes17 | 350 | 0
SamplePart18 | 18 | LOC18 | 2.91 |  |  |  | SampleDes18 | 325 | 0
SamplePart19 | 19 | LOC19 | 0.44 |  |  |  | SampleDes19 | 314 | 0
SamplePart20 | 20 | LOC20 | 1.25 |  |  |  | SampleDes20 | 999
SamplePart21 | 21 | LOC21 | 5.21 |  |  |  | SampleDes21 | 888
Spreadsheet: 218876d1362597774-find-text-multiple-in-worksheet-and-return-sum-of-values-in-adjacent-cell-find-text-in-array-return-adjacent-cell-value
Sheet: test

 | result |  | look for |  | vert.offset |  | horiz. Offset
 |  |  | Material A |  | 0 |  | 1 |  | result
 |  |  |  |  |  |  |  |  | lookup value
 | [NAME] of Material |  |  |  |  |  |  |  | vert.  and horiz.  offsets
 | Widget 1 |  | Widget 2 |  | Widget 3
 | Material A | 1 | Material A | 4 | Material A | 7
 | Material B | 2 | Material B | 5 | Material B | 8
 | Material C | 3 | Material C | 6 | Material C | 9
 | - array is B4: H9
 | - set cell B2 to find text "Material A" from array, & get SUM of all values of cell offset (0,1) highlighted in yellow