tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 771106d1646413849-expected-output-based-on-2-criteria-and-header-sample-workbook-with-expected-outcome
Sheet: Expected Output

 | Expected Outcome 1 |  |  |  |  |  | Criteria 1 (Category) | All
 | Category | Activity | Performer Name |  |  |  | [NAME] (Month Status Yes/No) | Yes
 |  |  |  |  |  |  | [NAME] (Month header) | Dec.21 Status (Yes/No)
Spreadsheet: 64985d1265768083-custom-calendar-form-calendar
Sheet: Sheet1

 |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
Spreadsheet: 777144d1650197003-warehouse-movements-proposal-combine-two-tables-and-fullfill-sample-warehouse-movements-proposal-combine-two-tables-and-fullfill-
Sheet: Sheet1

Product | QtyAllowedToGive | WarehouseIdGiver | Rank
A | 30 | 100 | 1
A | 30 | 101 | 2
A | 10 | 102 | 3
B | 10 | 200 | 4
B | 20 | 201 | 5
D | 2 | 30 | 6
Product | QtyAllowedToTake | WarehouseIdTaker | Rank
A | 50 | 200 | 1
A | 5 | 203 | 2
A | 11 | 202 | 3
B | 16 | 202 | 4
B | 3 | 202 | 5
C | 10 | 300 | 6
Result Needed
Product | QtyToMove | WarehouseIdGiver | WarehouseIdTaker
A | 30 | 100 | 200
A | 20 | 101 | 200
A | 5 | 101 | 203
A | 5 | 101 | 202
A | 6 | 102 | 202
B | 10 | 200 | 202
B | 9 | 201 | 202
Spreadsheet: 704788d1605750497-highlight-duplicate-numerical-values-that-are-next-to-each-other-book2
Sheet: Sheet1

[NAME] | 12 | 0 | 12 | 12 | 11 | 12 | 13 | 13 | 13 | 12
[NAME] | 5265271 | 4590000 | 2742645 | 2420068 | 1997128 | 1832141 | 1943090 | 1782348 | 1864443 | 1511512
Layla | 710807 | 552700 | 565020 | 589091 | 542970 | 186123 | 192141 | 193217 | 203828 | 185244
[NAME] | 941143000 | 959304000 | 992414000 | 853060000 | 809472000 | 826591000 | 827109000 | 834589000 | 851473000 | 825199000
[NAME] | 8277017 | 8570863 | 8494605 | 8564376 | 8468412 |  | 2492305 | 2410369 | 2364507 | 2103382
[NAME] |  | 42612000 | 100981000 | 97278000 | 37810000 | 39726000 | 10971000 | 11148000 | 11466000 | 10380000
[NAME] |  | 4000000000 | 300000000 | 300000000 |  | 3369382
[NAME] |  | 12 | 12 |  |  | 6035345
[NAME]
[NAME] |  |  |  |  |  | 44353290
Carole | 53378 | 99808 | 101374 | 104560 | 96357 | 104576 | 107649 | 108435 | 114051
Spreadsheet: richard_shapiro__32163__CE2 Pack Template 2506 (FINAL VERSION)
Sheet: Expense Analysis (2)

[NAME]
 |  | [NAME]
 |  | (Actual v CE1 Forecast) |  | Description
Salaries & Wages |  | -14386.8 |  | Due to yearly Expat PAYE payments in April for $98k.
Travel & Entertainment |  | 354571.24 |  | Jul-Dec has been reduced inline with revised headcount of 25 (plan was 32)
Office Expenses |  | 5893.11 |  | On line with forecast
Consultancy |  | 48443.78020000004 |  | (See full breakdown of cost on next page)
Audit & Legal (tax, reg) |  | 914665.36 |  | Significant underspend, possibility of late billings to come through.
 |  |  |  | (See full breakdown of cost on next page)
Occupancy Costs(rent & utilities) |  | -24809.21 |  | Office costs for Brussels and Amsterdam office. Overstated due to late 2000 and Q1 costs
General & Admin |  | -44479.99 |  | Annual subscriptions fees for Confederation of British Industry $26k & Electricity Association $36k in April.
Mobile Phones/Land Lines/Telerate |  | 17089.82 |  | Well under Forecast. From July on land lines/faxes will be charged to each cost centre this could increase the cost by $5,000 per month.
Taxes Other Than Income |  | 0
TOTAL G&A |  | 1256987.3102
Savings Summary
 | Total | Saving |  | Description
Original Budget | 13501263
CE1 (Forecast end of Q1) | 11614213 |  |  | 14% saving on original budget. Mostly [NAME] and wages
CE2 (Forecast end of Q2) | 11193492 |  |  | 4% saving on CE1. Mostly Travel and Entertainment
 |  |  |  | 18% saving on original budget
Spreadsheet: 71394d1272050075-conditional-formatting-entire-row-with-graded-color-scale-color-scale-entire-row
Sheet: Sheet1

Instance # | Distance | Orientation | Depth %
1 | 2 | 100 | 42
2 | 5 | 248 | 55
3 | 6 | 177 | 28
4 | 11 | 174 | 97
5 | 17 | 260 | 96
6 | 19 | 342 | 45
7 | 22 | 48 | 52
8 | 26 | 134 | 21
9 | 29 | 266 | 23
10 | 33 | 302 | 74
11 | 37 | 193 | 30
12 | 41 | 62 | 63
13 | 44 | 216 | 74
14 | 48 | 122 | 64
15 | 51 | 316 | 76
16 | 55 | 68 | 66
17 | 59 | 113 | 52
18 | 62 | 239 | 35
19 | 66 | 7 | 48
20 | 70 | 241 | 27
Spreadsheet: 697825d1601560533-sum-if-s-and-round-up-incorrect-formulae-tally-23
Sheet: sheet3

[NAME] |  |  |  |  | Price per Kilo Summary
Species | Presentation | Boxes | Total (Kg) |  | Species | Grade | Presenattion | Boxes | Lowest (Kg) Price | Highest (Kg) Price | [NAME]
Spreadsheet: 770544d1646144441-how-to-type-a-value-and-substract-from-other-cell-same-column-use-of-ifformula-function-to-track-work-hours-arias-
Sheet: Sheet1

DAY | DATE | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | DAY | DATE | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
MON | 2021-12-06 00:00:00 | 8.6 | 5 | sick | 12.5 | SICK |  |  | MON
TUES | 2021-12-07 00:00:00 | 10 | 10 | 10 |  | SICK |  |  | TUES
WED | 2021-12-08 00:00:00 |  | sick |  |  | SICK |  |  | WED
THUR | 2021-12-09 00:00:00 |  | 20 |  |  | SICK |  |  | THUR
FRI | 2021-12-10 00:00:00 |  |  |  |  | SICK |  |  | FRI
SAT | 2021-12-11 00:00:00 |  |  |  |  |  |  |  | SAT
SUN | 2021-12-12 00:00:00 |  |  |  |  |  |  |  | SUN
Spreadsheet: 169905d1343101348-how-to-sum-the-duplicate-records-pt-for-duplicate-record
Sheet: Sheet1

[NAME] | Impression | Helper
a_300x250_jun08.gif (948516) | 435 | 300x250_jun08.gif (948516)
a_300x250_jun08.gif (948516) | 459912 | 300x250_jun08.gif (948516)
a_300x250_jun08 | 460347 | 300x250_jun08
b_300x250_jun08.gif (948517) | 450 | 300x250_jun08.gif (948517) |  |  |  | Sum of Impression
b_300x250_jun08.gif (948517) | 550488 | 300x250_jun08.gif (948517) |  |  |  | Helper | Total
b_300x250_jun08 | 550938 | 300x250_jun08 |  |  |  | 300x250_jun08 | 1598181
c_300x250_jun08.gif (948519) | 427 | 300x250_jun08.gif (948519) |  |  |  | 300x250_jun08.gif (948516) | 460347
c_300x250_jun08.gif (948519) | 586438 | 300x250_jun08.gif (948519) |  |  |  | 300x250_jun08.gif (948517) | 550938
[NAME] (948522) | 458 | 300x250_jun08.swf (948522) |  |  |  | 300x250_jun08.gif (948519) | 586865
c_300x250_jun08 | 586896 | 300x250_jun08 |  |  |  | 300x250_jun08.swf (948522) | 458
 |  |  |  |  |  | Grand Total | 3196789
Spreadsheet: mark_taylor__24692__Loaded on EOL
Sheet: Sheet1

 | Enron ID | Name | S&P | E-Rating | [NAME] | Industry | Crty of Incorp. | Equity Ticker | Quote On Website? | Quote on EOL?
 | EC02001 | AT&T Corp. | AA- | 2 | AA- | Telecom | USA | T | Y | Y
 | EC01008 | Baltimore Gas & Electric Company | A+ | 3 | A+ | Energy | USA | CEG | Y | Y
 | EC01012 | Birka Energi AB | BBB+ | 4 | BBB+ | Energy | SWE | BIRKA | Y | Y
 | EC01027 | Centrica plc | NR | 3 | A- | Energy | UK | CNA@LN | Y | Y
 | EC02006 | Cisco Systems Inc | NR | 3 | A- | Telecom | USA | CSCO | Y | Y
 | EC01032 | Citizens Utilities Company | A+ | 2 | A+ | Energy | USA | CZN | Y | Y
 | EC01039 | Constellation Energy Group, Inc. | A | 3 | A | Energy | USA | CEG | Y | Y
 | EC06013 | Dell Computer Corporation | BBB+ | 4 | BBB+ | Technology | USA | DELL | Y | Y
 | EC01056 | Fortum Power and Heat Oy | NR | 4 | BBB | Energy | FIN | FUM1V | Y | Y
 | EC07010 | Lucent Technologies Inc. | A | 3 | A | Electronics | USA | LU | Y | Y
 | EC02009 | MCI Worldcom, Inc. | A- | 3 | A- | Telecom | USA | WCOM | Y | Y
 | EC05019 | Monsanto Company | A | 3 | A | Chemicals | USA | MTC | Y | Y
 | EC01080 | National Grid Company plc | AA+ | 1 | AA+ | Energy | UK | NATGRI | Y | Y
 | EC01089 | [NAME] | NR | 3 | A- | Energy | NOR | N/A | Y | Y
 | EC01092 | [NAME] plc | NR | 2 | A+ | Energy | UK | NORWEB | Y | Y
 | EC01106 | PowerGen UK plc | A | 2 | A | Energy | UK | PWGLN | Y | Y
 | EC01110 | Scottish and Southern Energy plc | NR | 2 | A+ | Energy | UK | SSE@LN | Y | Y
 | EC01111 | ScottishPower UK plc | A | 2 | A | Energy | UK | SPW@LN | Y | Y
 | EC01112 | Seeboard plc | BBB+ | 3 | BBB+ | Energy | UK | SBD | Y | Y
 | EC01192 | [NAME] OYJ | BBB+ | 4 | BBB+ | Energy | FIN | Y.SEN | Y | Y
 | EC06017 | Sun Microsystems, Inc. | BBB+ | 4 | BBB+ | Technology | USA | SUNW | Y | Y
 | EC01124 | Sydkraft AB | NR | 2 | A+ | Energy | SWE | SYDASS | Y | Y
 | EC05028 | Union Carbide Corporation | BBB | 4 | BBB | Chemicals | USA | UK | Y | Y
 | EC08005 | Viacom Inc. | BBB- | 5 | BBB- | Entertainment | USA | VIA/B | Y | Y
 | EC02015 | Vodafone Airtouch plc | A | 2 | A | Telecom | UK | VOD | Y | Y
Spreadsheet: 782745d1654231145-sumifs-function-showing-0-data-copy-for-forum
Sheet: Shed 1

Year | Team Leader | Numbers | Number Full-time Staff | Number Casual | Number SWP | Number PLS | Total Hours2
Spreadsheet: 586013d1534159938-advanced-filter-using-and-logic-does-not-return-expected-values-for-non-numeric-values-todowithadvancedfiltering
Sheet: FilterText

Action | Notes | Priority | Status | Date Started | Date Completed
Action | Notes | Priority | Status | Date Started | Date Completed
Task 1 | Do Task 1 | 4 | Not Started
Task 2 | Do Task 2 | 1 | Complete
Task 3 | Do Task 3 | 2 | Complete
Task 4 | Do Task 4 | 4 | Complete
Action | Notes | Priority | Status | Date Started | Date Completed
Task 2 | Do Task 2 | 1 | Complete
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: HR

HR | ok
[NAME], [NAME] | VP
Clyatt, [NAME] | Admin Coordinator
[NAME], [NAME] | Analyst
Labbe, Anne | Analyst
Cashion, Tana | Associate
[NAME], [NAME] | Manager
Slone, [NAME] | Manager
Kearney, Julie | Manager
Curless, [NAME] | Specialist
Broussard, [NAME] | Specialist
Buckley, [NAME] | Sr. Spec
Calgary | Vacancy
Total | 12
Spreadsheet: 755851d1637143277-highlight-postive-and-negtivevalues-that-are-pposite-and-equal-conditional-formatting-to-highlight-values-that-are-opposite-and-equal
Sheet: Sheet1 (2)

Total BR | BR1 | BR2 | BR3
20251.35
14536.1
0
0
5959.78
-327965.68
-47097.33
2991645.59
1384558.37
253478.35
0
-51733.71
-164272.8
-10133.68
Spreadsheet: kate_symes__18400__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
 | 2000-12-16 00:00:00 |  | 275 | 480 | 210 | 400 | 183.11 | 2287 | 181.95 | 535
 | 2000-12-15 00:00:00 |  | 275 | 480 | 210 | 400 | 187.75 | 2655 | 153.05 | 1714
 | 2000-12-14 00:00:00 |  | 327.14 | 560 | 226 | 600 | 186.36 | 2035 | 170.6 | 1669
 | 2000-12-13 00:00:00 |  | 497.86 | 448 | 237.79 | 704 | 287.91 | 1278 | 165.71 | 1791
 | 2000-12-12 00:00:00 |  | 342.11 | 1328 | 239.28 | 1064 | 334.23 | 1940 | 165.94 | 1277
 | 2000-12-11 00:00:00 |  | 447.65 | 544 | 245.19 | 832 | 244.01 | 1470 | 147.46 | 1240
 | 2000-12-10 00:00:00 |  | 297.1 | 992 | 244.42 | 1504 | 200.84 | 712 | 127.41 | 600
 | 2000-12-09 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 187.04 | 810 | 148.98 | 1225
 | 2000-12-08 00:00:00 |  | 315.42 | 2304 | 213.76 | 1976 | 287.06 | 1430 | 175 | 390
 | 2000-12-07 00:00:00 |  | 312.11 | 2080 | 205.86 | 2776 | 246.51 | 172 | 138.05 | 519
 | 2000-12-06 00:00:00 |  | 267.18 | 2128 | 177.11 | 1344 | 260.08 | 529 | 151.35 | 911
 | 2000-12-05 00:00:00 |  | 237.02 | 2848 | 119.16 | 904 | 274.6 | 1057 | 172.84 | 1728
 | 2000-12-04 00:00:00 |  | 200.19 | 2080 | 131 | 800 | 227.66 | 1683 | 126.49 | 1488
 | 2000-12-03 00:00:00 |  | 150 | 800 | 118.5 | 0 | 127.99 | 2955 | 109 | 2055
 | 2000-12-02 00:00:00 |  | 148.68 | 1520 | 87.73 | 880 | 123.67 | 845 | 109.6 | 1885
 | 2000-12-01 00:00:00 |  | 148.68 | 1520 | 85 | 480 | 108.93 | 224 | 112.09 | 308
 | 2000-11-30 00:00:00 |  | 180 | 1280 | 85 | 0 | 123.62 | 2347 | 99.02 | 868
 | 2000-11-29 00:00:00 |  | 181.32 | 1520 | 120 | 200 | 136.18 | 765 | 118.06 | 134
 | 2000-11-28 00:00:00 |  | 130 | 240 | 82.5 | 0 | 117.7 | 755 | 108.98 | 215
Spreadsheet: 30878d1226582302-extracting-individual-worksheets-from-workbook-nov-sample
Sheet: Bluewater EOM

 |  |  | Owner's | Payment | November | 2008
 |  |  |  | [NAME]
Date From | Date To | Description | Total Rent | Type | Percentage | Total
2008-11-29 00:00:00 | 2008-02-25 00:00:00 | Accommodation | 8184 | Balance | 90% | 7365.6
 |  |  |  |  | Total Due | 7365.6
 |  | ASWA Commission Claim
Date From | Date To | Description | Total Rent | Tax Code | Commission | Total
2008-11-29 00:00:00 | 2008-02-25 00:00:00 | Accommodation | 8184 | GST | 0.11 | 990.2640000000001
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 990.2640000000001
 |  | Payment Summary
Statement | Date | Type | Description | Amount Due | ASWA Claim | [NAME]
 | 2008-11-30 00:00:00 |  |  | 7365.6 | 990.2640000000001 | 6375.336
Spreadsheet: 877261d1724050637-extract-data-by-lookup-col-d-at-col-n-o-and-join-wherever-1-from-sheet2-a-to-c-join-text-by-match-at-col-n-and-o
Sheet: Sheet2

Google Jal Corp (P) Ltd(125896354) | 470324 | GEMINI AI 4.0 MASS (CASHEW)
A.Z. International, Bankok(308420235) | 941762 | AZ CHROME-(CCA)
A.Z. International, Bankok(308420235) | 861382 | TWISTER(ZZ);CAPETOWN
Aakash Cosmetics Products,[NAME]) | 170471 | MICROSOFT PRODUCTS;ITALY (DC)
[NAME] Industries(400264131) | 460322 | ASIA TECHS;(MP)
[NAME] Industries(400264131) | 693426 | JS-RONALDO;BKS-DU [PHONE]
[NAME] Industries(400264131) | 831219 | MS-COPILOT DIARIES(T);TANKS-CALIFORNIA
[NAME] (S) Ltd.(501009999) | 431221 | APPLE HEALTH SIRI PVT LTD (U);USA
A.L.National Enterpriese, GoogleInca(40011444) | 361227 | CHATGPT AI HEALTH PVT LTD (D);LOSANGLES
Spreadsheet: 72603d1273286151-change-currency-formatting-based-on-value-of-another-cell-macro-start
Sheet: Drop down boxes

 |  | From and copy |  | Customers |  |  | Delivery |  | Payment Method |  |  | Currency
 |  | Eriko Uchiyama) |  | Origin Energy |  |  | Air and Ocean |  | CIF |  |  | Australian Dollars
 |  | [NAME]) |  | QNI |  |  | Ocean |  | DDP |  |  | [NAME]
 |  | [NAME]) |  | Flinders Power |  |  | Air |  | Advanced Payment
 |  |  |  | [NAME] |  |  |  |  | Letter of Credit
 |  |  |  | Alcoa of Australia
 |  |  |  | Mobil Refining Australia
 |  |  |  | AETV
Spreadsheet: 048bebe1-6639-4cae-8270-75696df14958
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/22/2008 | Wrestling | at Navy Classic (Annapolis, Md.) | 12:00 AM | 12th Place
11/23/2008 | Wrestling | vs. Columbia (Vestal, N.Y.) | 12:00 AM | W, 22-15
11/23/2008 | Wrestling | vs. North Carolina (Vestal, N.Y.) | 12:00 AM | W, 21-11
12/05/2008 | Wrestling | at Cliff Keen Invitational (Las Vegas, Nev.) | 12:00 AM | 23rd Place
12/14/2008 | Wrestling | at Penn State | 12:00 AM | L, 10-27
01/02/2009 | Wrestling | LEHIGH | 12:00 AM | L, 3-35
01/09/2009 | Wrestling | ILLINOIS | 12:00 AM | L, 19-26
01/17/2009 | Wrestling | MICHIGAN STATE | 12:00 AM | L, 15-25
01/18/2009 | Wrestling | at Duquesne | 12:00 AM | W, 57-0
01/23/2009 | Wrestling | at Bloomsburg | 12:00 AM | W, 19-16
01/24/2009 | Wrestling | at Clarion | 12:00 AM | W, 22-14
[NAME] | Wrestling | at Lock Haven | 12:00 AM | W, 20-16
[NAME] | Wrestling | at Pitt | 12:00 AM | T, 15-15
02/14/2009 | Wrestling | OHIO | 12:00 AM | W, 37-9
02/20/2009 | Wrestling | CLEVELAND STATE | 12:00 AM | W, 41-0
02/22/2009 | Wrestling | EDINBORO | 12:00 AM | T, 19-19
03/07/2009 | Wrestling | at EWL Championships (Lock Haven, Pa.) | 12:00 AM | 2nd Place
03/20/2009 | Wrestling | at NCAA Championships (St. Loius, Mo.) | 12:00 AM | 47th Place
Spreadsheet: 873503d1720008196-how-to-combine-daily-sales-remaining-stock-into-one-table-how-to-combine-daily-sales-remaining-stock-into-one-table
Sheet: Summary

 | Period |  |  | Channel | Orange | [NAME] | Mango | Price | Transport fee | Total
 | Start Date | 2024-07-01 00:00:00 |  |  |  |  |  |  |  |  |  | It's probably easier to continue doing your manul copying daily, especially when you have rows for "Restocking".
 | End Date | 2024-07-05 00:00:00 |  | Online | 51 | 36 | 24 | 2979000 | 570000 | 3549000 |  | Good to copy also Price, Transport fee and TOTAL.
 |  |  |  | Total |  |  |  |  |  |  |  | Add in a column for Channel and move the table to a seprate sheet, to facilitate manual copying.
 |  |  |  |  |  |  |  |  |  |  |  | Add in another sheet for analysis purpose, using SUMIFS.
 |  |  |  | Name | Orange | [NAME] | Mango | Price | Transport fee | Total |  | See attached workbook.
 | Channel | All
 |  |  |  | Amazon | 21 | 21 | 0 | 1980000 | 546000 | 2526000
 |  |  |  | [NAME] | 6 | 9 | 6 | 1980000 | 200000 | 2180000
 |  |  |  | [NAME] | 9 | 3 | 3 | 0 | 0 | 0
 |  |  |  | [NAME] | 3 | 3 | 3 | 0 | 0 | 0
 |  |  |  | [NAME] | 15 | 9 | 0 | 1980000 | 546000 | 2526000
 |  |  |  | [NAME] | 6 | 10 | 9 | 0 | 0 | 0
 |  |  |  | [NAME] | 3 | 6 | 3 | 999000 | 24000 | 1023000
 |  |  |  | olivia | 12 | 0 | 12 | 0 | 0 | 0
 |  |  |  | phei | 3 | 9 | 15 | 0 | 0 | 0
 |  |  |  | veronia | 0 | 6 | 0 | 0 | 0 | 0
Spreadsheet: 684761d1593526763-remove-blanks-from-data-vaildation-lists-test-enviro-eie
Sheet: Investments

Account Name: | [NAME]'s [NAME] |  |  |  |  | Account Name: | [NAME]'s [NAME] |  |  |  |  | Account Name: | [NAME]'s IRA |  |  |  |  | Account Name: | [NAME]'s IRA |  |  |  |  | Account Name: | Joint Account |  |  |  |  | Account Name: | [NAME]'s [NAME]
Account Owner: | Chrisanna |  |  |  |  | Account Owner: | [NAME] |  |  |  |  | Account Owner: | [NAME] |  |  |  |  | Account Owner: | [NAME] |  |  |  |  | Account Owner: | Joint |  |  |  |  | Account Owner: | [NAME]
Account Type: | Investment |  |  |  |  | Account Type: | Investment |  |  |  |  | Account Type: | Investment |  |  |  |  | Account Type: | Investment |  |  |  |  | Account Type: | Investment |  |  |  |  | Account Type: | Investment
Account Subtype: | Roth IRA |  |  |  |  | Account Subtype: | Roth IRA |  |  |  |  | Account Subtype: | IRA |  |  |  |  | Account Subtype: | IRA |  |  |  |  | Account Subtype: | Taxable Investment |  |  |  |  | Account Subtype: | Roth IRA
Holding | Symbol | Shares | Price | Market Value |  | Holding | Symbol | Shares | Price | Market Value |  | Holding | Symbol | Shares | Price | Market Value |  | Holding | Symbol | Shares | Price | Market Value |  | Holding | Symbol | Shares | Price | Market Value |  | Holding | Symbol | Shares | Price | Market Value
SPDR Portfolio S&P 500 Growth ETF | #[NAME]! | 5631.605 |  |  |  | SPDR Portfolio S&P 500 Growth ETF | #[NAME]! | 429 |  |  |  | SPDR Portfolio S&P 500 Growth ETF | #[NAME]! | 10000 |  |  |  | SPDR Portfolio Developed World ex-US ETF | #[NAME]! | 12000 |  |  |  | Cash |  | 100000 | 1 |  |  | Cash |  | 100000 | 1
SPDR S&P 500 ETF Trust | #[NAME]! | 64.631 |  |  |  | SPDR S&P 500 ETF Trust | #[NAME]! | 23 |  |  |  | SPDR S&P 500 ETF Trust | #[NAME]! | 200 |  |  |  | SPDR Portfolio S&P 500 Growth ETF | #[NAME]! | 1000 |  |  |  | Total |  |  |  |  |  |  | #[NAME]! | 34326.764
Total |  |  |  |  |  | Total |  |  |  |  |  | SPDR S&P 600 Small Cap Growth ETF | #[NAME]! | 40 |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | 200
 |  |  |  |  |  |  |  |  |  |  |  | Vanguard Emerging Markets Stock Index Fd Admiral Shs | #[NAME]! | 1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | 100
 |  |  |  |  |  |  |  |  |  |  |  | Vanguard Real Estate Index Fund Admiral Shares | #[NAME]! | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | 50
 |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: joe_parks__14542__nymexquotes
Sheet: Sheet1

 | 2001-11-30 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-03-19 00:00:00
2002-01-01 00:00:00 | 2.701
2002-02-01 00:00:00 | 2.786 | 2.465
2002-03-01 00:00:00 | 2.799 | 2.441 | 2.138
2002-04-01 00:00:00 | 2.759 | 2.456 | 2.198 | 2.359 | 3.256
2002-05-01 00:00:00 | 2.799 | 2.511 | 2.266 | 2.416 | 3.294
2002-06-01 00:00:00 | 2.849 | 2.571 | 2.331 | 2.479 | 3.324
2002-07-01 00:00:00 | 2.884 | 2.621 | 2.391 | 2.537 | 3.356
2002-08-01 00:00:00 | 2.921 | 2.671 | 2.446 | 2.592 | 3.384
2002-09-01 00:00:00 | 2.921 | 2.685 | 2.446 | 2.607 | 3.384
2002-10-01 00:00:00 | 2.946 | 2.716 | 2.47 | 2.652 | 3.392
2002-11-01 00:00:00 | 3.141 | 2.923 | 2.695 | 2.924 | 3.622
2002-12-01 00:00:00 | 3.331 | 3.128 | 2.894 | 3.194 | 3.843
2003-01-01 00:00:00 | 3.436 | 3.233 | 2.981 | 3.314 | 3.937
2003-02-01 00:00:00 | 3.366 | 3.173 | 2.931 | 3.261 | 3.865
2003-03-01 00:00:00 | 3.261 | 3.108 | 2.848 | 3.171 | 3.718
2003-04-01 00:00:00 | 3.116 | 2.953 | 2.729 | 3.044 | 3.5
2003-05-01 00:00:00 | 3.121 | 2.953 | 2.739 | 3.059 | 3.49
2003-06-01 00:00:00 | 3.151 | 2.988 | 2.791 | 3.114 | 3.52
2003-07-01 00:00:00 | 3.191 | 3.023 | 2.826 | 3.156 | 3.552
2003-08-01 00:00:00 | 3.226 | 3.065 | 2.881 | 3.199 | 3.582
2003-09-01 00:00:00 | 3.229 | 3.06 | 2.89 | 3.201 | 3.567
2003-10-01 00:00:00 | 3.267 | 3.1 | 2.904 | 3.221 | 3.6
2003-11-01 00:00:00 | 3.412 | 3.242 | 3.074 | 3.384 | 3.782
2003-12-01 00:00:00 | 3.551 | 3.39 | 3.231 | 3.559 | 3.952
2004-01-01 00:00:00 | 3.616 | 3.45 | 3.321 | 3.654 | 4.052
2004-02-01 00:00:00 | 3.536 | 3.356 | 3.245 | 3.564 | 3.927
2004-03-01 00:00:00 | 3.406 | 3.256 | 3.111 | 3.439 | 3.787
2004-04-01 00:00:00 | 3.221 | 3.074 | 2.938 | 3.246 | 3.579
2004-05-01 00:00:00 | 3.219 | 3.077 | 2.949 | 3.249 | 3.565
2004-06-01 00:00:00 | 3.269 | 3.117 | 2.984 | 3.284 | 3.604
2004-07-01 00:00:00 | 3.314 | 3.157 | 3.031 | 3.304 | 3.629
2004-08-01 00:00:00 | 3.359 | 3.207 | 3.081 | 3.335 | 3.649
2004-09-01 00:00:00 | 3.342 | 3.192 | 3.061 | 3.332 | 3.637
2004-10-01 00:00:00 | 3.367 | 3.207 | 3.081 | 3.344 | 3.662
2004-11-01 00:00:00 | 3.519 | 3.352 | 3.251 | 3.503 | 3.842
2004-12-01 00:00:00 |  | 3.487 | 3.429 | 3.683 | 4.022
2005-01-01 00:00:00 |  | 3.542 | 3.494 | 3.763 | 4.087
2005-02-01 00:00:00 |  |  | 3.389 | 3.658 | 3.967
2005-03-01 00:00:00 |  |  |  | 3.538 | 3.832
Spreadsheet: 61910d1262810981-find-specific-withdraw-entries-from-bank-statements-top1
Sheet: Sheet1

BANK STATEMENT |  | 2009-01-01 00:00:00
 |  | Withdraw | Deposit | Balance
2009-01-01 00:00:00 | GAS    Z8A | 1 |  | 10
2009-05-01 00:00:00 | VISA   T5D | 3 |  | 7
2009-05-01 00:00:00 | Hardware T1K | 2 |  | 5
2009-09-01 00:00:00 | Staples 1k2 | 2 |  | 3
2009-09-02 00:00:00 | Home T2S | 2 |  | 1
 | Deposit |  | 5 | 6
 | Deposit |  | 5 | 11
BANK STATEMENT |  | 2009-02-01 00:00:00
 |  | Withdraw | Deposit | Balance
2009-02-02 00:00:00 | GAS    S2W | 1 |  | 20
2009-02-02 00:00:00 | VISA   [NAME] | 3 |  | 17
2009-03-02 00:00:00 | Hardware 1H8 | 2 |  | 15
2009-05-02 00:00:00 | Staples R4R | 2 |  | 13
 | Home A3E | 2 |  | 11
 | Deposit |  | 5 | 16
 | Deposit |  | 5 | 21
GAS | 2