tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 818052d1676563621-search-for-and-sum-a-value-within-a-cell-among-a-range-of-cells-forum-example
Sheet: Sheet1

FirstSendDate | touchpoint_name | Volume |  |  |  | Search using these | Return these
2022-08-03 00:00:00 | Email-NN-AA-23-22303_A | 30 |  |  |  | NN-AA-23-22303 | 42
2022-09-03 00:00:00 | Email-NN-AA-23-22304_A | 40 |  |  |  | NN-AA-23-22304 | 40
2022-10-03 00:00:00 | Email-NN-AA-23-22303_A | 12 |  |  |  | NN-AA-23-22306 | 11
2022-11-03 00:00:00 | Email-NN-AA-23-22306_A | 11
Spreadsheet: 824977d1680993453-what-s-is-a-simple-formula-to-add-12-24-from-another-worksheet-ak-sample
Sheet: COVER-12

 | AK |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  | 1200 |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  | 1200 |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  | 1200 |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Comments |  |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 793658d1661616836-order-letters-based-on-their-combination-with-other-letters-excel-forum-25-august-afternoon-hasan-mougharbel-
Sheet: Sheet1

 | Apply formula here across all grey region |  |  |  |  |  | Original combination |  |  |  | The below tables is only for visualization purpose and would aid more to understand my mission |  |  |  |  | Order letters based on their combination with other letters (excelforum.com)
A | B | D | C |  |  | 1) | A | B | D
B | A | D | C |  |  | 2) | C | B | A |  |  | Combination of A with all letters
C | B | A | D |  |  | 3) | D | B | C
D | B | A | C |  |  | 4) | D | B | A |  | 1) | A | B | D
 |  |  |  |  |  |  |  |  |  |  | 2) | C | B | A
A |  |  |  |  |  |  |  |  |  |  | 3) | D | B | C
B |  |  |  |  |  | A | B | C | D |  | 4) | D | B | A
C |  |  |  |  | A
D |  |  |  |  | B |  |  |  |  |  |  | Combination of B with all letters
 |  |  |  |  | C
 |  |  |  |  | D |  |  |  |  |  | 1) | A | B | D
 |  |  |  |  |  |  |  |  |  |  | 2) | C | B | A
 |  |  |  |  |  |  |  |  |  |  | 3) | D | B | C
 |  |  |  |  |  |  |  |  |  |  | 4) | D | B | A
 |  |  |  |  |  |  |  |  |  |  |  | Combination of C with all letters
 |  |  |  |  |  |  |  |  |  |  | 1) | A | B | D
 |  |  |  |  |  |  |  |  |  |  | 2) | C | B | A
 |  |  |  |  |  |  |  |  |  |  | 3) | D | B | C
 |  |  |  |  |  |  |  |  |  |  | 4) | D | B | A
 |  |  |  |  |  |  |  |  |  |  |  | Combination of D with all letters
 |  |  |  |  |  |  |  |  |  |  | 1) | A | B | D
 |  |  |  |  |  |  |  |  |  |  | 2) | C | B | A
 |  |  |  |  |  |  |  |  |  |  | 3) | D | B | C
 |  |  |  |  |  |  |  |  |  |  | 4) | D | B | A
Spreadsheet: 51f7ce13-156e-461e-a06a-99cb03f4c176
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8501.0 Retail Trade, Australia
 | TABLE 12. Retail Turnover; Completely Enumerated (large) and Sample (small), By Industry Group
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Food retailing ;  Total (State) ;  Total Sample Sector ; |  |  | Original | A2540513J | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  Food retailing ;  Total (State) ;  Total CE and [NAME] ; |  |  | Original | A2540439W | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  Department stores ;  Total (State) ;  Total CE and [NAME] ; |  |  | Original | A2540427L | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  [NAME] and soft good retailing ;  Total (State) ;  Total Sample Sector ; |  |  | Original | [NAME]T | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  [NAME] and soft good retailing ;  Total (State) ;  Total CE and [NAME] ; |  |  | Original | A2540410T | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  [NAME] good retailing ;  Total (State) ;  Total Sample Sector ; |  |  | Original | A2540516R | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  [NAME] good retailing ;  Total (State) ;  Total CE and [NAME] ; |  |  | Original | A2540478L | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  Other retailing ;  Total (State) ;  Total Sample Sector ; |  |  | Original | A2540422A | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  Other retailing ;  Total (State) ;  Total CE and [NAME] ; |  |  | Original | A2540447W | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  Cafes, restaurants and takeaway food services ;  Total (State) ;  Total Sample Sector ; |  |  | Original | A2540405X | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  Cafes, restaurants and takeaway food services ;  Total (State) ;  Total CE and [NAME] ; |  |  | Original | A2540493K | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  Total (Industry) ;  Total (State) ;  Total Sample Sector ; |  |  | Original | A2540481A | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
Turnover ;  Total (Industry) ;  Total (State) ;  Total CE and [NAME] ; |  |  | Original | A2540505J | 1994-04-01 00:00:00 | 2009-03-01 00:00:00 | 180 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 795604d1662795201-calculate-average-but-exclude-weekend-and-public-holiday-book1-hd-4-
Sheet: Cal

 | May | Day | Total
 | 2022-05-01 00:00:00 |  | 5 |  |  | Date | Day
 |  |  | 4 |  |  | 2022-01-01 00:00:00 | Saturday
 |  |  | 5 |  |  | 2022-02-01 00:00:00 | Tuesday
 |  |  | 4 |  |  | 2022-02-02 00:00:00 | Wednesday
 |  |  | 5 |  |  | 2022-04-15 00:00:00 | Friday
 |  |  | 6 |  |  | 2022-05-01 00:00:00 | Sunday
 |  |  | 7 |  |  | 2022-05-03 00:00:00 | Tuesday
 |  |  | 8 |  |  | 2022-05-15 00:00:00 | Sunday
 |  |  | 3 |  |  | 2022-07-10 00:00:00 | Sunday
 |  |  | 5 |  |  | 2022-10-24 00:00:00 | Monday
 |  |  | 6 |  |  | 2022-12-25 00:00:00 | Sunday
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 3
 |  |  | 6
 |  |  | 8
 |  |  | 3
 |  |  | 6
 |  |  | 9
 |  |  | 5
 |  |  | 1
 |  |  | 4
 |  |  | 6
 |  |  | 7
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 5
 |  |  | 7
 |  |  | 8
 | Ave/mth |  |  |  |  | Solution for Excel users 365/2021
 |  |  |  |  |  | Solution for all Excel users (confirm formula with CTRL+SHIFT+ENTER if necessarry)
 |  |  |  |  |  |  | \
Spreadsheet: 022ee972-581c-4eef-ab1e-1ceda5717b4f
Sheet: Sheet1

Elementary  Division | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Pool A |  | Pool B
Atlanta Celtics Black |  | College Park
GA Trailblazers |  | GA Tarheels
Middle GA Ballers |  | Atlanta Celtics Gold
Southside Ballers |  | Respects Game
Friday , June 17
Team | Time | Court # | Game # |  | Results
A2 vs A1 | 7:00PM | Court 1 | GM 1
B3 vs B4 | 8:00PM | Court 1 | GM 2
B1 vs B2 | 9:00PM | Court 1 | GM 3
Saturday,  June 18
A3 vs A1 | [NAME] | Court 1 | GM 4
A2 vs A4 | 10:00AM | Court 1 | GM 5
B2 vs B4 | 11:00AM | Court 1 | GM 6
B1 vs B3 | 12:00PM | Court 1 | GM 7
Afternoon Session
A1 vs A4 | 1:00PM | Court 1 | GM 8
A3 vs A2 | 2:00PM | Court 1 | GM 9
B4 vs B1 | 3:00PM | Court 1 | GM 10
B2 vs B3 | 4:00PM | Court 1 | GM 11
A3 vs A4 | 5:00PM | Court 1 | GM 12
Sunday , June 17
Pool A #1 vs Pool B #2 |  | [NAME] | GM 13 | Court 1
Pool B #1 vs Pool A #2 |  | [NAME] | GM 14 | Court 2
Championship Game
Winner GM 14 vs Winner GM 13 |  |  | 2:00PM | Court 1
Rules
14 Minute running clock , 4 TO/game , One and One at 10 fouls
Clock stops at last 2 minute of every half,  20 pt lead with 2 min left, game
ends | Clock stops on Sunday
1st team Dark / 2nd Team White
Spreadsheet: 689457d1596438351-check-price-for-different-related-part-number-check-latest-part-price
Sheet: Sheet2

Part | Price | Effective from | Effective To |  |  |  | Check Part | Current quotation | Last 1st quotation | Last 2nd quotation
123K45670 | 525 | 2015-04-20 00:00:00 | 2015-10-01 00:00:00 | quotation expired |  |  | 123K45674 | BLANK | 626 | 508
123K45670 | 519 | 2015-10-02 00:00:00 | 2016-10-03 00:00:00 | quotation expired |  |  |  | 123K45674 | 123K45673 | 123K45670
123K45670 | 516 | 2016-10-04 00:00:00 | 2019-10-06 00:00:00 | quotation expired |  |  | can use concatenate | 123K45674 "BLANK" | 123K45673 626 | 123K45670 508
123K45670 | 508 | 2019-10-07 00:00:00 |  | <=active quotaton
123K45671 | 541 | 2015-05-13 00:00:00 | 2017-04-18 00:00:00 | quotation expired |  |  | Notes
123K45673 | 609 | 2015-08-20 00:00:00 | 2015-10-01 00:00:00 | quotation expired |  |  | part roll up on last part number
123K45673 | 602 | 2015-10-02 00:00:00 | 2016-10-03 00:00:00 | quotation expired |  |  | D5, D12 are active quotation
123K45673 | 673 | 2016-10-04 00:00:00 | 2017-10-03 00:00:00 | quotation expired |  |  | input 123K45674, want [NAME] part price for previous revision part number
123K45673 | 635 | 2017-10-04 00:00:00 | 2018-09-30 00:00:00 | quotation expired
123K45673 | 630 | 2018-10-01 00:00:00 | 2019-09-30 00:00:00 | quotation expired
123K45673 | 626 | 2019-10-01 00:00:00 |  | <=active quotaton
part roll up on last part number
…
…
…
A list of different part quotation.
…
…
…
…
…
…
Spreadsheet: 180184d1347511680-sorting-a-messy-database-output-by-address-suburb-book1
Sheet: Sheet1

[NAME]
5 Mont Street
CALORA NORTH NSW 2211
DOB: 13/01/2011 | ABN:
Partner: | Office:
User: P | Money: 0.00 | Type: 0
TEC01
Kerow Club
Treggle Industrial Estate
FAUTH WALL TR11 4SN
UNITED KINGDOM
DOB: | ABN: 59 138 211 060
Partner: | Office:
User: C | Money: 0.00 | Type: 0
NIV01B
DOB: | ABN:
Partner: | Office:
User: C | Money: 0.00 | Type: 0
[NAME]
7/ 2-4 Springfield Road
SPRINGFIELD NSW 2135
DOB: 20/03/1980 | ABN:
Partner: | Office:
User: I | Money: 0.00 | Type: 0
MAN02B
PO Box 8
KOORINGAL NSW 2221
DOB: | ABN: 82 237 035 882
Partner: | Office:
User: P | Money: 0.00 | Type: 0
DON001
C/- Super
PO Box 9000
[NAME] 4000
DOB: 11/08/1976 | ABN:
Partner: | Office:
User: I | Money: 0.00 | Type: 0
Spreadsheet: 50532d1249992518-vlookup-multiple-lines-excel-forum-rev-01
Sheet: Usage

Supplier |  | Qty | [NAME] | Total
Tesco | 2009-01-01 00:00:00 | 50 | Tesco-1 | 0
Tesco | 2009-01-02 00:00:00 | 55 | Tesco-1
Tesco | 2009-01-03 00:00:00 | 51 | Tesco-1
Tesco | 2009-01-04 00:00:00 | 52 | Tesco-1
Tesco | 2009-01-05 00:00:00 | 55 | Tesco-1
Tesco | 2009-01-06 00:00:00 | 56 | Tesco-1
 |  |  | -1
Sainsburys | 2009-03-01 00:00:00 | 99 | Sainsburys-3
Sainsburys | 2009-05-01 00:00:00 | 98 | Sainsburys-5
Sainsburys | 2009-06-01 00:00:00 | 97 | Sainsburys-6
Spreadsheet: 030d85a9-16d7-45e3-b9d2-f3ce053a2079
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 15a. MERCHANDISE EXPORTS, State and Australia, FOB Value
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ; |  |  | Original | A1829245L | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829246R | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829247T | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829248V | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829249W | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829250F | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829251J | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829252K | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A1829253L | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
Re-exports ; |  |  | Original | A1829254R | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
Total (State of origin) ; |  |  | Original | A1829255T | 1988-01-01 00:00:00 | 2010-04-01 00:00:00 | 268 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 123802d1317858858-sales-totals-formula-fbm-sales-totals
Sheet: CREG

Coastal Real Estate Guide
Ad Account | Rep | Price
Account X | [NAME] | 450
Account X | [NAME] | 175
Account X | [NAME] | 150
Account X | [NAME] | 500
Account X | [NAME] | 450
Account X | [NAME] | 450
Account X | Julie | 550
Account X | Julie | 195
Account X | Julie | 225
Account X | Julie | 450
Account X | Julie | 450
Account X | House | 500
Account X | House | 500
Account X | [NAME] | 450
Account X | [NAME] | 450
Account X | [NAME] | 450
Account X | House | 450
Account X | House | 450
Account X | House | 450
Account X | House | 450
Account X | House | 450
Account X | House | 450
Account X | House | 450
Account X | House | 450
Account X | House | 450
Account X | [NAME] | 180
Account X | [NAME] | 400
Total Pages |  | 11025
Spreadsheet: 816337d1675523076-extract-values-based-on-dropdown-selection-extract-values_sample_1
Sheet: Here

 | Active
Names | Status | Sales #
Ashley, Smith | Active | 255
Ashley, Smith | Active | 519
Amanda, Knox | Active | 770
Judith, Butler | Active | 271
Mindy, Thompson | Active | 86
Scott, [NAME] | Active | 963
Autumn, Goodman | Active | 868
[NAME], Rowe | Active | 569
Kelly, [NAME] | Active | 194
[NAME], [NAME] -Treal | Active | 201
Spreadsheet: 701512d1603798266-formula-to-calculate-royalty-as-sales-level-changes-test-excel
Sheet: Sheet1

From | Difference in Royalty
0 | 0.03
16000000 | 0.01
22000000 | 0.01
32000000 | 0.01
42000000 | 0.01
47000000 | 0.01
52000000 | 0.01
57000000 | 0.01
 | NET SALES | 49000000
 | Royalty
Spreadsheet: 841469d1693641739-sumifs-formula-sample
Sheet: Raw Dump

Date Modified | Date | Technician | Name of Driver/Helper | Week | Asset | Points |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Points Final
2023-08-01 08:29:25 |  | [NAME] | LaToya | 1 | 44231 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 08:51:34 |  | Rachel | Daquan | 1 | 48340 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 08:58:19 |  | Malik | Bridget | 1 | 47183 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 09:18:33 |  | [NAME] | Giovanni Russo | 1 | 44202 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 09:23:29 |  | Rachel | Sophia | 1 | 34965 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 09:53:19 |  | Aaliyah | Luca | 1 | 49985 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 09:57:35 |  | Rachel | Bridget | 1 | 45645 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
2023-08-02 10:03:40 |  | Malik | Giovanni Russo | 1 | 39942 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-03 10:03:40 |  | [NAME] | Sophia | 1 | 47203 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-07 10:03:40 |  | Rachel | Bridget | 2 | 43970 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-08 10:03:40 |  | Aaliyah | Giovanni Russo | 2 | 49154 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2023-08-09 10:03:40 |  | [NAME] | Sophia | 2 | 50056 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-10 10:03:40 |  | Malik | Daquan | 2 | 48128 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-11 10:03:40 |  | Aaliyah | Bridget | 2 | 44202 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 10:56:21 |  | [NAME] | Giovanni Russo | 1 | 50105 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
2023-08-01 10:57:50 |  | Malik | Sophia | 1 | 47098 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 10:59:50 |  | [NAME] | Luca | 1 | 45577 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-01 11:02:41 |  | Aaliyah | Bridget | 1 | 46913 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-04 10:03:40 |  | Malik | Giovanni Russo | 1 | 47160 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2023-08-05 10:03:40 |  | Aaliyah | LaToya | 1 | 42667 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 182807d1348608703-how-to-create-a-combination-chart-combinationchartstacked
Sheet: Sheet1

 |  |  |  | UNITS
 |  |  | 30 | 60 | 90 | 120 | 150 | 180
 |  | 2011-06-01 00:00:00 | 0 | 0 | 179666.6666666667 | 327113 | 487469.1666666667 | 579807.8333333334
 |  | 2011-07-01 00:00:00 | 0 | 0 | 0 | 104750 | 753605.5 | 234125
 |  | 2011-08-01 00:00:00 | 0 | 76663.75 | 245750.4166666667 | 1088868 | 1055836.833333333 | 814964.8333333334
 |  | 2011-09-01 00:00:00 | 0 | 0 | 119027.7777777778 | 336722.2222222222 | 475237.7777777778 | 542478.7777777778
 |  | 2011-10-01 00:00:00 | 0 | 0 | 250374 | 403800 | 910888.75 | 671609.5
 |  | 2011-11-01 00:00:00 | 37909.09090909091 | 24909.09090909091 | 138904.5454545454 | 382085.6363636364 | 391051 | 339345.7272727273
 |  | 2011-12-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 2012-01-01 00:00:00 | 0 | 0 | 0 | 23116.66666666667 | 304641.6666666667 | 494916.6666666667
 |  | 2012-02-01 00:00:00 | 0 | 0 | 26692.375 | 153681.25 | 0 | 0
 |  | 2012-03-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 2012-04-01 00:00:00 | 0 | 12561.11764705882 | 72320.58823529411 | 0 | 0 | 0
 |  | 2012-05-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 2012-06-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | VOLUME
 |  | 2011-06-01 00:00:00 | 30 | 60 | 90 | 120 | 150 | 180
 |  | 2011-07-01 00:00:00 | 4 | 4 | 4 | 4 | 4 | 4
 |  | 2011-08-01 00:00:00 | 3 | 3 | 3 | 3 | 3 | 3
 |  | 2011-09-01 00:00:00 | 2 | 2 | 2 | 2 | 2 | 2
 |  | 2011-10-01 00:00:00 | 5 | 5 | 5 | 5 | 5 | 5
 |  | 2011-11-01 00:00:00 | 3 | 3 | 3 | 3 | 3 | 3
 |  | 2011-12-01 00:00:00 | 2 | 2 | 2 | 2 | 2 | 2
 |  | 2012-01-01 00:00:00 | 55 | 55 | 55 | 55 | 55 | 55
 |  | 2012-02-01 00:00:00 | 22 | 22 | 22 | 22 | 22 | 22
 |  | 2012-03-01 00:00:00 | 44 | 44 | 44 | 44 | 44 | 44
 |  | 2012-04-01 00:00:00 | 22 | 22 | 22 | 22 | 22 | 22
 |  | 2012-05-01 00:00:00 | 44 | 44 | 44 | 44 | 44 | 44
 |  | 2012-06-01 00:00:00 | 22 | 22 | 22 | 22 | 22 | 22
Spreadsheet: john_griffith__16211__1_31_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG H2 | 215 | 31.5 | 33 | 70.4 | 73.8 | 9.75 | 2002-01-31 14:55:00
 | NG J2 | 220 | 39.5 | 40.5 | 59.5 | 61 | 8.33 | 2002-01-31 14:55:00
 | NG K2 | 225 | 44 | 45 | 51.7 | 52.9 | 7.4 | 2002-01-31 14:55:00
 | NG M2 | 230 | 49.5 | 50.5 | 48.4 | 49.4 | 7.07 | 2002-01-31 14:55:00
 | NG N2 | 240 | 56 | 56.5 | 47.3 | 47.7 | 7.17 | 2002-01-31 14:55:00
 | NG Q2 | 245 | 64 | 66 | 48.3 | 49.8 | 7.56 | 2002-01-31 14:55:00
 | NG U2 | 245 | 68 | 69 | 47.5 | 48.2 | 7.37 | 2002-01-31 14:55:00
 | NG V2 | 250 | 74.5 | 75 | 47.9 | 48.2 | 7.55 | 2002-01-31 14:55:00
 | NG X2 | 270 | 85 | 86.5 | 47.6 | 48.5 | 8.16 | 2002-01-31 14:55:00
 | [NAME] | 290 | 95 | 97.5 | 47.4 | 48.7 | 8.76 | 2002-01-31 14:55:00
 | NG F3 | 300 | 105 | 108 | 48.6 | 50 | 9.3 | 2002-01-31 14:55:00
 | NG G3 | 300 | 106 | 109 | 47 | 48.3 | 8.99 | 2002-01-31 14:55:00
 | NG H3 |  |  |  |  |  |  | 2002-01-30 10:03:00
 | NG M3 |  |  |  |  |  |  | 2002-01-25 14:56:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 684932d1593619808-how-to-pick-up-correct-data-in-multiple-rows-and-columns-in-a-table-how-to-pick-up-correct-data-in-multiple-rows-and-columns-in-a-table-pq
Sheet: Sheet1

 | Table 1 - Data |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 2 - Selling Price Summary
 | Item | 1
 |  | Product A |  |  |  | Product B |  |  |  | Product C |  |  |  |  |  |  | Our selling price over different sales channels
 | Sales to | [NAME] |  | MT |  | MT |  | FR |  | OT |  | FS |  |  | Item | Product Name | [NAME] | FR | FS | GT | MT | OT
 | Our Cost Price |  | 15 |  |  |  | 20 |  |  |  | 38 |  |  |  | 1
 | Desired Margin |  |  | 0.11 |  |  |  | 0.15 |  | 0.2 |  | 0.18 |  |  | 2
 | Our Selling Price |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Sales to | GT |  | FS |  | OT |  |  |  |  |  |  |  |  | 4
 | Our Cost Price |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | Desired Margin | 0.12 |  | 0.13 |  | 0.12 |  |  |  |  |  |  |  |  | 6
 | Our Selling Price
Spreadsheet: 86026d1285982777-next-date-upload
Sheet: Old

PH # | CALL TIME | CALL | AD # |  | START TIME | END TIME | EXCLUSIONS | PHD
132 | 2010-09-10 20:39:00 | (718) 555-3011 | 132 |  | 2010-08-30 13:04:00 | 2010-09-12 15:08:00 | (408)
938 | 2010-09-08 00:08:00 | (718) 555-3011 | 938 |  | 2010-07-09 12:55:00 | 2010-08-30 13:03:00 | (718) 555-2322
132 | 2010-09-02 16:59:00 | (408) 555-2810 | 938 |  | 2010-06-16 14:01:00 | 2010-07-09 12:54:00 | (305)
938 | 2010-08-23 11:23:00 | (313) 555-3820 |  |  |  |  | (718) 555-7111
938 | 2010-08-10 13:25:00 | (718) 555-2322
132 | 2010-08-08 13:08:00 | (313) 555-2810
132 | 2010-08-07 13:29:00 | (718) 555-0013 |  | I2 | counts unique C values that:
938 | 2010-07-22 04:00:00 | (408) 555-1820 |  |  |  | * have a corresponding B value that is on or between F2 & G2
938 | 2010-07-05 20:15:00 | (718) 555-7111 |  |  |  | * have a corresponding A value that matches D2
132 | 2010-07-03 22:21:00 | (305) 555-5810 |  |  |  | * do not match any number, or begin with any area code listed in H2:H100
132 | 2010-07-01 14:59:00 | (617) 555-3000
938 | 2010-06-29 08:39:00 | (617) 555-3000 |  | I2 | {=SUM(IF(FREQUENCY(IF(($B$2:$B$16>=$F2)*($B$2:$B$16<=$G2)*ISNA(MATCH($C$2:$C$16,$H$2:$H$5,0))*ISNA(MATCH(LEFT($C$2:$C$16,5),$H$2:$H$5,0))*($A$2:$A$16=$D2),IF($C$2:$C$16<>"",MATCH("~"&$C$2:$C$16,$C$2:$C$16&"",0))),ROW($C$2:$C$16)-ROW($C$2)+1)>0,1))}
132 | 2010-06-28 14:31:00 | (718) 555-2322
938 | 2010-06-20 02:57:00 | (718) 555-3050 |  |  | Data sheet
132 | 2010-06-17 14:38:00 | (305) 555-1008 |  |  | Log sheet
 |  |  |  |  | DNC sheet