tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86025d1285976628-3d-scatter-plot-capability-response-surface-methodology
Sheet: Sheet1

 | Data |  |  |  | Simultaneous Linear Equations |  |  |  | Grid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Response Surface
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  | -0.03 | -0.06 | -0.09 | -0.12 | -0.15 | -0.18 | -0.21 | -0.24 | -0.27 | -0.3 | -0.33 | -0.36 | -0.39 | -0.42 | -0.45 | -0.48 | -0.51
 | x | y | z |  | x:z | z = 0.413x+1.9459 |  | 0.25
 | -0.5 | 0.4 | 1.281 |  | y:z | z = -2.5168y+2.8872 |  | 0.26
 | -0.5 | 0.45 | 1.795 |  | Adding | z = (.413x-2.5168y+4.8331)/2 |  | 0.27
 | -0.5 | 0.5 | 1.766 |  |  |  |  | 0.28
 | -0.4 | 0.35 | 1.595 |  |  |  |  | 0.29
 | -0.4 | 0.4 | 1.388 |  |  |  |  | 0.3
 | -0.4 | 0.45 | 2.344 |  |  |  |  | 0.31
 | -0.4 | 0.5 | 2.179 |  |  |  |  | 0.32
 | -0.3 | 0.35 | 1.792 |  |  |  |  | 0.33
 | -0.3 | 0.4 | 2.349 |  |  |  |  | 0.34
 | -0.3 | 0.45 | 1.682 |  |  |  |  | 0.35
 | -0.3 | 0.5 | 1.493 |  |  |  |  | 0.36
 | -0.2 | 0.35 | 1.836 |  |  |  | y | 0.37
 | -0.2 | 0.4 | 2.186 |  |  |  |  | 0.38
 | -0.2 | 0.45 | 1.863 |  |  |  |  | 0.39
 | -0.2 | 0.5 | 1.775 |  |  |  |  | 0.4
 | -0.1 | 0.25 | 2.991 |  |  |  |  | 0.41
 | -0.1 | 0.3 | 2.426 |  |  |  |  | 0.42
 | -0.1 | 0.35 | 1.954 |  |  |  |  | 0.43
 | -0.1 | 0.4 | 1.136 |  |  |  |  | 0.44
 | -0.1 | 0.45 | 1.438 |  |  |  |  | 0.45
 | -0.1 | 0.5 | 1.429 |  |  |  |  | 0.46
 | -0.05 | 0.3 | 2.163 |  |  |  |  | 0.47
 | -0.05 | 0.35 | 1.953 |  |  |  |  | 0.48
 | -0.05 | 0.4 | 1.672 |  |  |  |  | 0.49
 | -0.05 | 0.45 | 1.688 |  |  |  |  | 0.5
 | -0.05 | 0.5 | 1.963
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 8

 | Jul 5 |  | Jul 12 |  | Jul 19 |  | Jul 26
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and participant type (value of all trades in milliions of USD), all products and tenors, cleared and uncleared.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 117407d1312794834-trying-to-create-a-drop-down-from-vlookup-return-or-group-values-in-drop-down-workbook
Sheet: Course

Course Code | Abbreviation | Course Name | Faculty | Sub-Dean
1901AA | PhD | Doctor of Philosophy | Arts | CM
1901PY | PhD | Doctor of Philosophy (Psychology) | Arts | CM
1901CO | DComm | Doctor of  Communication | Arts | CM
1902DM | DMin | Doctor of Ministry | Arts | CM
1911SW | DSW | Doctor of Social Work | Arts | CM
1802AA | MArts | Master of Arts (Honours) | Arts | CM
1860TH | MTh(Hons) | Master of Theology (Honours) | Arts | CM
2901AA | PhD | Doctor of Philosophy | Business | EO
2902BA | DBA | Doctor of Business Administration | Business | EO
2901IT | DIT | Doctor of Information Technology | Business | EO
2801CH | MCom(Hons) | Master of Commerce (Honours) | Business | EO
2709CM | MCompMod | Master of Computational Modelling | Business | EO
3901AA | PhD | Doctor of Philosophy | Education | BH
3901IM | DIM | Doctor of Information Management | Education | BH
3902AA | EdD | Doctor of Education | Education | BH
4901AB | PhD | Doctor of Philosophy (Lab Based) | Science | AC
4901AA | PhD | Doctor of Philosophy (Non Lab Based) | Science | AC
4901HS | DHlthSc | Doctor of Health Science | Science | AC
4802AB | MHlthSc(Hons) | Master of Health Science (Honours)(Lab Based) | Science | AC
4802AA | MHlthSc | Master of Health Science (Non Lab Based) | Science | AC
5901SC | PhD | Doctor of Philosophy (Lab Based) | Science | AC
5901AG | PhD | Doctor of Philosophy (Non Lab Based) | Science | AC
5928SA | DSustAgric | Doctor of Sustainable Agriculture | Science | AC
5801PH | MPhil | Master of Philosophy (Lab Based) | Science | AC
5802PH | MPhil | Master of Philosophy (Non Lab Based) | Science | AC
4801BL | MAppSci(Hons) | Master of Applied Science (Honours) | Science | AC
Spreadsheet: 216242d1361655510-would-like-to-refer-the-top-row-as-column-name-in-formulas-excel-table-feature
Sheet: Sheet3

SLNO | NAME | PLACE | RATE | QTY | TOTAL | Average
1 | AAA | MY PLACE 1 | 155 | 52 | 8060
2 | BBB | MY PLACE 2 | 383 | 87 | 33321
3 | CCC | MY PLACE 3 | 282 | 23 | 6486
4 | AAA | MY PLACE 4 | 752 | 53 | 39856
5 | EEE | MY PLACE 5 | 172 | 12 | 2064
Spreadsheet: 709748d1608542076-formulas-required-for-different-options-selected-formula-group-help-1-
Sheet: Sheet1

Sno. | Description |  | Qty |  | Price | Value |  | Sub Option a |  | Sub Option b |  | Sub Option c
1.0 | Item 1 |  | 12345 | sqm
1.1 | Standard Option |  |  | pcs. | 1.16 |  |  | Not Selected |  | Not Selected |  | Not Selected
1.1a | Sub Option a |  |  | pcs. | 1.3 | Not Selected |  |  |  | Not Selected |  | Not Selected
1.1b | Sub Option b |  |  | pcs. | 2.69 | Not Selected |  | Not Selected |  |  |  | Not Selected
1.1c | Sub Option c |  |  | pcs. | 3.69 | Not Selected |  | Not Selected |  | Not Selected
1.2 | [NAME] |  | 1234 | pcs. | 1.17
1.3 | [NAME] |  | 12 | pcs. | 2.2
1.4 | [NAME] |  | 113 | pcs. | 1.89
1.5 | [NAME] |  | 123 | pcs. | 2.81
1.6 | [NAME] |  | 234 | pcs. | 2.93
1.7 | [NAME] |  | 345 | pcs. | 3.35
1.8 | [NAME] |  | 456 | pcs. | 1.12 |  |  |  |  |  |  |  | [NAME]
 |  | Standard |  |  |  |  |  |  |  |  |  |  | If [NAME] is selected then the values will be calculated for G14 i.e =(G3+SUM(Addons))/D2
 |  | Sub Option a |  |  |  | 1.81098177399757 |  |  |  |  |  |  | If F4 is selected then the values will be calculated for [NAME] i.e =(G4+SUM(Addons))/D2
 |  | Sub Option b |  |  |  | 3.367849331713244 |  |  |  |  |  |  | If F5 is selected then the values will be calculated for G16 i.e =(G5+SUM(Addons))/D2
 |  | Sub Option c |  |  |  | 4.487897934386391 |  |  |  |  |  |  | If F6 is selected then the values will be calculated for G17 i.e =(G6+SUM(Addons))/D2
 | Standard Size | 1.12
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 40803 | 40714 | 37694 | 35000
2 | 41335 | 40714 | 42690 | 35000
3 | 39966 | 40714 | 41584 | 40000
4 | 41167 | 40714 | 39857 | 40000
5 | 44360 | 43714 | 39563 | 40000
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
2001-05-31 00:00:00 |  | 2493268.61 |  | -2072427.18
2001-06-05 00:00:00
Spreadsheet: richard_shapiro__32155__ESESActionCalendar
Sheet: calendar

 | MAY |  |  |  | [NAME] |  |  |  | JULY |  |  |  |  | AUGUST |  |  |  | SEPTEMBER
 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 3 | 10 | 17 | 24
Communications Plan
Select ESES spokesperson
Draft press/information kit
Issue press release to announce ESES
Target launch website
Ongoing press briefings
Third party presentation for client approval
Ongoing third party outreach
Compile list of analysts/institutional investors
Analyst cover letter to client for approval
Analyst mailing
Introductions of IPPNY and SS+K
Ongoing coordination with IPPNY
Survey in field
Release survey findings (June 21)
Begin planning panel discussion event
Panel discussion
ESES to provide schedule of speaking engagements
SS+K to begin identifying and booking other speaking opp's
[NAME] speeches for client approval
Crisis statements for client approval
 | MAY |  |  |  | [NAME] |  |  |  | JULY |  |  |  |  | AUGUST |  |  |  | SEPTEMBER
 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 3 | 10 | 17 | 24
Advertising Plan
Brief creative team
Write radio spot
Develop creative for print ad
Review radio spot and creative for print internally
Submit radio and print to client
Client comments on radio and print
Submit revised radio spot and print ad
Client approval for radio spot and layout/copy for print ad
Client comments on proof for print ad
Purchase space for radio spot and print ad to run in Week 6
Find talent and book studio for radio spot
Record radio spot, edit and secure client approvals
Run radio and print
Spreadsheet: kate_symes__18602__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-08 00:00:00 |  | 365.71 | 2800 | 325 | 400
 | 2001-02-07 00:00:00 |  | 301.25 | 4800 | 231.43 | 1400 | 415.92 | 7768 | 431.28 | 1750
 | 2001-02-06 00:00:00 |  | 211.67 | 3600 | 200 | 600 | 458.43 | 2225 | 373.4 | 1560
 | 2001-02-05 00:00:00 |  | 200 | 4400 | 200 | 200 | 346.5 | 4395 | 308.59 | 2105
 | 2001-02-04 00:00:00 |  |  |  |  |  |  |  | 339.43 | 4946 |  | 206.67 | 1800
 | 2001-02-03 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 390.12 | 4411 | 362.33 | 1500
 | 2001-02-02 00:00:00 |  | 223.95 | 7600 | 196.25 | 800 | 489.58 | 1945 | 388.1 | 1470
 | 2001-02-01 00:00:00 |  | 368.81 | 8400 | 319.17 | 1200 | 507.77 | 2990 | 399.65 | 1410
 | 2001-01-31 00:00:00 |  | 410.67 | 6000 | 330 | 240 | 558.06 | 2700 | 457.58 | 825
 | 2001-01-30 00:00:00 |  | 475 | 3600 | 330 | 200 | 570.15 | 1790 | 441.67 | 900
 | 2001-01-29 00:00:00 |  | 409.94 | 6640 | 387.5 | 0 | 508.72 | 2665 | 432.7 | 925
 | 2001-01-28 00:00:00 |  |  |  |  |  |  |  | 573.46 | 3080 |  | 350 | 600
 | 2001-01-27 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 575 | 1900 | 453.79 | 896
 | 2001-01-26 00:00:00 |  | 295.84 | 6160 | 255.71 | 1400 | 484.63 | 1750 | 475.17 | 757
 | 2001-01-25 00:00:00 |  | 319.3 | 5760 | 300 | 400 | 408.1 | 3642 | 485.29 | 850
 | 2001-01-24 00:00:00 |  | 314.3 | 4560 | 260 | 0 | 466.67 | 1350 | 450 | 600
 | 2001-01-23 00:00:00 |  | 352.69 | 5200 | 237.5 | 400 | 465.24 | 1025 | 237.5 | 0
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200 | 404.09 | 5165 | 361.14 | 2480
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 839339d1691851496-calendar-with-recurring-weekly-events-demand-gen-enterprise-campaign-calendar_test-yogabbagabba-
Sheet: Raw_Data - Not Tied to Calendar

Date | Time (Drop down) | Program Name | Program Type | Actual Time | Next
2023-02-06 00:00:00 |  | MS Teams | Drip
2023-01-17 00:00:00 |  | EI Forrester Analyst [NAME] | Event |  |  |  |  | Wed
2023-03-13 00:00:00 |  | EI ISG Manufacturing Webinar | Event
2023-03-20 00:00:00 |  | EI ISG Healthcare Webinar | Event |  |  |  | 1) | EI ABM Always On @ 12:17pm
2023-03-15 00:00:00 |  | EI ISG Retail Webinar | Event |  |  |  | 2) | EI ABM Always On [PM]
2022-11-02 00:00:00 | PM | EI ABM Always On | Nurture | Wed, 12:17PM
 |  | Enterprise Intelligence- Welcome Email Series | Drip
 |  | MTB RT | Event
2023-04-26 00:00:00 | AM | Healthcare Short Nurture | Nurture | Wed, 9:17AM
 |  | iOT Utilities | Drip
2023-07-04 00:00:00 | AM | [NAME] | Nurture | [NAME], 9:15AM
2023-05-04 00:00:00 | AM | Manufacturing | Nurture | Thurs, 7:53AM
 |  | NRF - Retail | Drip
 |  | Engagement - PCI | Nurture
 |  | DBIR Nurture | Drip
2023-07-03 00:00:00 |  | DBIR Presents (Ep.1) | Event
 |  | DBIR Presents (Ep.2) | Event
 |  | DBIR Presents (Ep.3) | Event
 |  | DBIR Presents (Ep.4) | Event
2023-05-22 00:00:00 |  | DBIR Release Day (Ep1) | Event
 |  | DBIR Release Day (Ep2) | Event
 |  | DBIR Release Day (Ep3) | Event
2023-03-10 00:00:00 |  | Innovation Showcase | Event
2023-04-27 00:00:00 |  | Security Manufacturing Webinar | Event
2023-02-09 00:00:00 |  | Cyber Risk Roundtable | Event
Spreadsheet: 240261d1370273841-alphanumeric-sort-alphanum
Sheet: Sheet2

Current Format: |  | Desired Format:
ZLM3-ZLF4 |  | [NAME]
ZLM3-ZLF5 |  | ZLM3-ZLX3
ZLM3-ZLH4 |  | ZLM3-ZLF4
ZLM3-ZLH5 |  | ZLM3-ZLH4
[NAME] |  | ZLM3-ZLF5
ZLM3-ZLX3 |  | ZLM3-ZLH5
[NAME] |  | [NAME]
[NAME] |  | [NAME]
ZLN3-ZLH4 |  | [NAME]
[NAME] |  | ZLN3-ZLH4
[NAME] |  | [NAME]
[NAME] |  | [NAME]
Spreadsheet: 62214d1263211290-combination-of-if-and-left-prova-exel
Sheet: Sheet1

83510 - Opbrengst aandelen | -251022.96
83512 - Opbrengst warrants | 0
83513 - Opbrengst swaps | 0
83514 - ZW-Opbrengst aandelen Hedge funds | -4.08
83516 - Opbrengst UL fds aandelen | -1338658.35 |  | In this yellow cell I would like to take the sum of the values in the column B
83517 - Opbrengst UL fds aandelen stock div | -3827799.27 |  | corresponding to the cells in the column A which start with for example 83510
83518 - Opbrengst vastgoed | -747117.59 |  | which in reality are (-251022,96+10000)
83520 - Opbrengst obligaties | -195310687.45
83521 - Opbrengst schuldboekvorderingen | 0
83522 - ZW-Opbrengst obligaties COR | -132461363.47
83530 - Opbrengst beleggingspools | 0
83540 - Opbrengst hypotheken | -756543.92
83550 - Opbrengst los | -1205808.52
83551 - Opbrengst OHG HTM | 0
83552 - ZW-Opbrengst OHG AFS | 0
83560 - Opbrengst polisbeleningen | 0
83561 - Opbrengst hypotheken bouwfonds | -2606439.7
83563 - Opbrengst personeels leningen | -83108.91
83565 - Opbrengst lening HBG AFS | -943810.12
83566 - ZW interestbate IC leningen | -1660880.35
83568 - Intrest overige leningen | -41250
83570 - Opbrengst depots bij verzekeraars | -910199.12
83571 - Ontv. rente belasting dienst | -350251
83580 - Opbrengst bankrente | 235742.97
83581 - Opbrengst rente individueel | 0
83582 - Opbrengst rente collectief | -1285440.31
83583 - Opbrengst liquiditeitenfonds | -937820.64
83584 - Opbrengst liquiditeitenfonds | 0
83585 - Opbrengst rente reservesprong collectief | -1722.39
83587 - Opbrengst rente deposito's | -39525.92
83589 - Rente baten rek.crt. ZVV | 0
83590 - Opbrengst overige intrest | -28588624.8
83593 - Courtage | 0
83596 - Opbrengst overige intrest | 0
83510 - Opbrengst aandelen | 10000
Spreadsheet: 85980d1285957279-data-validation-multiple-subsets-data_validation_problem
Sheet: Sheet1

Data |  |  |  |  |  |  | Data Validation
Country | State/Province | City |  |  |  |  | Country | State/Province | City
Canada | Alberta | Calgary
United_States | Ontario | Edmonton
France | Quebec | Regina
 | Saskatchewan | Saskatchewan
 | California | Toronto
 | Texas | Montreal
 | Washington | Sacramento
 | Centre | Fresno
 | [NAME] | [NAME]
 | Picardie | Seattle
 |  | Châteauroux
 |  | [NAME]
 |  | Chantilly
Spreadsheet: 728168d1618344085-data-validation-list-using-unique-from-multiple-rows-dynamic-items-into-a-single-row
Sheet: Sheet1

# of Locations | 8
 |  | # of Stations | 3 | 7 | 2 | 3 | 1 | 2 | 3 | 4
List of unique values without Blanks or [NAME]: |  |  |  | PBB | PBC | PBD | PBE | PBF | PBG | PBH
 |  |  | PBAB | PBBB | PBCB | PBDB |  | PBFB | PBGB | PBHB
 |  |  | PBAC | PBBC |  | PBDC |  |  | PBGC | PBHC
 |  |  |  | PBBD |  |  |  |  |  | PBHD
 |  |  |  | PBBE
 |  |  |  | PBBF
 |  |  |  | PBBG
 |  |  | I Want to make this a List:
 |  |  |  | PBB | PBC | PBD | PBE | PBF | PBG | PBH
 |  |  | PBAA | PBBA | PBCA | PBDA | [NAME] | PBFA | PBGA | PBHA
 |  |  | PBAB | PBBB | PBCB | PBDB | 0 | PBFB | PBGB | PBHB
 |  |  | PBAC | PBBC | 0 | PBDC | 0 | 0 | PBGC | PBHC
 |  |  | 0 | PBBD | 0 | 0 | 0 | 0 | 0 | PBHD
 |  |  | 0 | PBBE | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | PBBF | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | PBBG | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | If I put this in a list, it gives a blank space:
 |  |  |  | PBB | PBC | PBD | PBE | PBF | PBG | PBH
 |  |  | PBAA | PBBA | PBCA | PBDA | [NAME] | PBFA | PBGA | PBHA
 |  |  | PBAB | PBBB | PBCB | PBDB |  | PBFB | PBGB | PBHB
 |  |  | PBAC | PBBC |  | PBDC |  |  | PBGC | PBHC
 |  |  |  | PBBD |  |  |  |  |  | PBHD
 |  |  |  | PBBE
 |  |  |  | PBBF
 |  |  |  | PBBG
Spreadsheet: 259469d1377071550-remove-char-10-blank-from-concatenate-formula-remove-gaps-from-concatenate
Sheet: Summary - data group

qty | item |  |  |  | Column A+B Join
1 | CH - 10
 | CH - 10 B
 | CH - 11
 | CH - 08
3 | CH - 09
 | OT - 09
 | OT - 09 B
 | OT - 10
 | OT - 11
6 | OT - 12
 | SO - 10
 | SO - 10 B
 | ST-11
 | ST-12
 | ST-13
 | ST-13A
 | ST-11 - TRAY
2 | ST-12 - TRAY
 | ST-13 - TRAY
 | ST-13A - TRAY
 | [NAME]
 |  |  |  |  | Summary Cell |  |  | Illustration of result I am trying to get:
 |  |  |  | I would like to remove the gaps in cell F24 for those items that are not showing because they have 0 value |  |  | I would like it to look like this: | 1 No. CH - 10 3 No. CH - 09 6 No. OT - 12 2 No. ST-12 - TRAY
Spreadsheet: 06135cac-7b32-4374-86ac-ab7e5817922f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | NPW Cost Sharing Funds Request Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Company Name Here
Labor Funding Request |  |  |  |  |  | Running Total
Function or Task | WBS Task | Assigned Personnel | [NAME] | Projected Labor Hours | Task Funding Request
Write GetView spec | WBS 4.2.1 Item 3 | Sr. Software Eng. | 50 | 100 | 5000
Modify brand x client to support with GetView | WBS 4.2.1 Item 4 | Assoc. Software Eng. | 30 | 150 | 4500
 |  | Expand form as needed
Total Labor |  |  |  |  | 9500 | 9500
Travel Funding Request
Function or Event | Duration | Aspects of Travel | Est. Trip Cost | # of Travelers | Trip Funding Request
[NAME] | 4 days | flight, lodging, per diem | 3000 | 1 | 3000
[NAME] | 2 days | flight, lodging, per diem | 3000 | 2 | 6000
Total Travel |  |  |  |  | 9000 | 18500
Other Expense Requests
Expense Type | Purpose or Use | Justification | Est. Cost | Amount (Units) | Expense Funding Request
Brand X Server CPU | Host WBS software | Required by submitter in order to have adequate infrastructure to show results | 5000 | 1 | 5000
[NAME] (Seat licenses) | Data storage and retrieval | Required by submitter in order to have adequate infrastructure to show results | 3000 | 20 | 60000
Total Other Expenses |  |  |  |  | 65000 | 83500
Grand Total Matching Funds Request |  |  |  |  | 83500
Spreadsheet: chris_germany__1977__lonestarnom2
Sheet: Apr 23

[NAME]
[NAME]
Dallas, TX  75201-5696
Attention: | Wilma Easter - Scheduling Department |  |  | From: | Enron Capital & Trade
Fax: | 214/875-3810 |  |  |  | [NAME]
Phone: | 214/875-3296 |  |  |  | 713/853-4743 (Phone)
Backup:  [NAME] 214/875-2674 |  |  |  |  | 713/646-3037 (Fax)
Contract #LS-MC-1671 |  |  | Start Date: | 2002-04-22 00:00:00 |  | End Date: | 2002-04-30 00:00:00
RECEIPT POINT INFORMATION:
STATION # | [NAME] | UPSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
17-1436-00 | Conger | Conoco System Supply | 0 | 0.01 | 0
17-1240-50 | NNG Sprayberry | 107903 | 10000 | 0.01 | 9900
17-1240-50 | NNG Sprayberry | 108466 | 0 | 0.01 | 0
17-7462-50 | [NAME] | 5268 | 0 | 0.01 | 0
17-0071-00 | [NAME] | at plant | 0 | 0.01 | 0
17-3000-00 | [NAME] |  | 25000 | 0.01 | 24750
DELIVERY POINT INFORMATION:
STATION # | [NAME] | DOWNSTREAM K# | NOM QUANTITY | FUEL % | NET QUANTITY
25-0002-00 | Kleburne Plant | 1671 | 35000 |  | 35000
FYI:  Buy/Sell Information
17-1240-50 | NNG Sprayberry | 107903 | 0 | 0 | 0 | sold to TXU K501
17-1436-00 | Conger | Conoco System Supply | 10000 | 0 | 10000 | sold to TXU K501
Spreadsheet: 169957d1343121816-rank-by-2-category-by-formula-instead-of-filter-rank-by-2-category
Sheet: Sheet1

Qty | Value | Rank by existing formula | Ranking I want to get
1 | 12 | 8 | 9
2 | 12 | 5 | 5
1 | 13 | 8 | 10
3 | 14 | 4 | 4
4 | 15 | 3 | 3
5 | 25 | 2 | 2
2 | 5 | 5 | 7
6 | 4 | 1 | 1
2 | 8 | 5 | 6
1 | 6 | 8 | 8
Spreadsheet: 473105d1470051356-count-number-of-clusters-of-numbers-within-a-column-of-numbers-clusters
Sheet: Sheet1

 |  | Positive | Nergative
 |  | Clusters | Clusters
[NAME] |  | "=>3" | "=>3"
15
17 |  | 1
16
12
-1
13
-15
18
-13 |  |  | 1
-12
-11
-18
-20
21
20
-22
11 |  | 1
15
23
34
89
-5 |  |  | 1
-6
-8
-12
TOTAL CLUSTERS |  |  |  |  | I need to be able to produce these values with a formula.
Spreadsheet: 750c6f9a-1cd8-47fc-aa07-e27f6bab1197
Sheet: Sheet1

Springfield Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-27 | 1 | [NAME] | 1 | Springfield | 2 | Final OT | [NAME], MA
2013-04-28 | 2 | [NAME] | 2 | Springfield | 3 | Final OT | [NAME], MA
2013-05-02 | 3 | Springfield | 1 | [NAME] | 2 | Final | [NAME] [NAME], NH
2013-05-04 | 4 | Springfield | 4 | [NAME] | 3 | Final OT | [NAME] [NAME], NH
2013-05-10 | 1 | Syracuse | 5 | Springfield | 2 | Final | [NAME], MA
2013-05-11 | 2 | Syracuse | 5 | Springfield | 3 | Final | [NAME], MA
2013-05-15 | 3 | Springfield | 0 | Syracuse | 3 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-17 | 4 | Springfield | 2 | Syracuse | 5 | Final | Onondaga County War Memorial Arena Syracuse, NY