tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 52284d1251987954-excel-2007-combining-worksheets-sample-2-
Sheet: combined

PN | Description | Qty | ExampleSheet1 | ExampleSheet2
1900123 | cap | 21 | 21 | 21
1900124 | resistor | 7 | 7 | 0
1900125 | inductor | 10 | 10 | 10
1900126 | cap | 5 | 5 | 5
1900127 | resistor | 14 | 14 | 0
1900128 | resistor | 21 | 21 | 21
1900129 | cap | 2 | 2 | 2
1900130 | micro | 1 | 1 | 0
1900131 | crystal | 2 | 2 | 2
1900131 | crystal | 2 | 2 | 2
1900133 | fuse | 4 | 0 | 4
1900135 | cap | 17 | 0 | 17
1900199 | inductor | 9 | 0 | 9
1900225 | processor | 1 | 0 | 1
Spreadsheet: louise_kitchen__22866__October01file
Sheet: Sheet1

 | 2000 |  |  | 2001 |  |  | Combined
 | Margin | Cash | Payout | Margin | Cash | Payout | Margin | Cash | Payout
Swerzbin | 210 | 2 |  | 190 | 1.5
Motley | 88 | 0.4 |  | 159 | 1.4
Richter* | 142 | 0.45 |  | 100 | 1
Badeer | 15 | 0.15 |  | 125 | 0.8
 | Proposed
 | Lavo | Belden
[NAME] | 1.75
[NAME] | 1.5 | 1.2
[NAME] | 1.2
[NAME] Richter | 0.75
Badeer | 0.5
[NAME] | 0.2 | 0
Total
* Richter's 2001 numbers include 59 from wholesale trading and 41 (rough estimate, who knows how much of the 200+ goes next to his name) for EES
Spreadsheet: 00670a4d-fd8a-4e77-99b3-0e89bc745cfb
Sheet: 4 YEARS

Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff
 | MUID |  |  |  | ACCT
Prepared by
Last Modified on
PI |  |  |  |  | DEPT
Project Title
Sponsor
 | Budget Period
 | Increase Annually By | 1.03
 |  |  |  |  |  | PERIOD 1 |  |  | PERIOD 2 |  |  | PERIOD 3 |  |  | PERIOD 4 |  |  | TOTAL
 | BUDGET ITEM | Name or Comment |  |  |  | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL
A. | PERSONNEL
6000 | PI Acad. Year
6000 | Co-I Acad Year
6000 | Co-I Acad Year
6000 | Other Professional
6000 | Total Professional
6007 | PI Summer
6007 | Co-I Summer
6007 | Co-I Summer
6007 | Total Sumr Salaries
6008 | Post Doc/Fellow Full-Time
6012 | Clinical/Lab Staff Full-Time
6013 | Clinical/Lab Staff Part-Time
6020 | Full-Time Hourly Staff
6035 | Part-Time Hourly Staff
6050 | Undergraduate Students
6024 | GRA-Academic Year | #: |  | Biweekly $:
6024 | GRA-Summer | #: |  | Biweekly $:
6024 | Total GRA
6195 | Fringe FT |  |  |  | 0.285
6195 | [NAME] |  |  |  | 0.16
6195 | Fringe PT & Summer Students |  |  |  | 0.08
6195 | Total Fringes
 | TOTAL PERSONNEL
B. | NONPERSONNEL
6200 | Office Expenses
6235 | Lab Supplies
6247 | Equipment > $5000
6265 | Computer Software
6505 | Consulting Fees
6515 | Subcontract 1 < $25K
6520 | Subcontract 1 > $25K
6515 | Subcontract 2 < $25K
6520 | Subcontract 2 > $25K
6515 | Total Sub < $25K
6520 | Total Sub > $25K
6602 | Student Stipends
6900 | Domestic Travel
6900 | Domestic Travel
6900 | Total Domestic Travel
6930 | Foreign Travel
7010 | Publications
7225 | Tuition
 | TOTAL NONPERSONNEL
 | TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)
 | TOTAL DIRECT COSTS: MU (Includes Subs I/C)
 | MTDC BASE
7520 | F&A Costs |  |  |  | 0.51
 | TOTAL PROJ COSTS
 |  |  |  |  | F&A for Subcontracts
 |  |  |  |  | #1
 |  |  |  |  | #2
Spreadsheet: 832818d1686620225-transforming-data-from-vertical-to-horizontal-using-excel-function-excel1-copy-uqls-
Sheet: Sheet1

Option A |  |  |  |  |  |  |  |  | Option B (what I want)
Source | Target | Sign | Storage |  | + | - | Categories |  | StorageA | StorageA | StorageA | StorageA | StorageB | StorageB | StorageB | StorageB | StorageC | StorageC | StorageC | StorageC | StorageC
StorageA | Evaporation | - |  |  |  |  | Sign |  | + | + | - | - | + | + | - | - | + | + | + | -
StorageA | SOTP | - |  |  |  |  | How to generate this result using formular |  | Rain | FlowinA | Evaporation | SOTP | Rain | FlowinB | Evaporation | SQPE | Rain | SWRD | FlowinC | Evaporation | UGTW
Rain | StorageA | +
FlowinA | StorageA | +
Rain | StorageB | + |  |  |  |  |  |  | Note
FlowinB | StorageB | + |  |  |  |  |  |  | + | To represent what into StorageA, StorageB and StorageC
StorageB | Evaporation | - |  |  |  |  |  |  | - | To represent what exisiting StorageA, StorageB and StorageC
StorageB | SQPE | -
SWRD | StorageC | +
Rain | StorageC | +
FowinC | StorageC | +
StorageC | Evaporation | -
StorageC | UGTW | -
Spreadsheet: 0184a0f3-0590-4571-bf12-bcfe4ffdd6bc
Sheet: 20

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes,  month ending November 30, by product, participant type, and cleared status (value of all trades in millions of USD).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared 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: f5bec63e-2d14-4fe7-a6fd-883fc16c4014
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5335 | 21486 | [NAME] | Oliveira | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:05:41
5335 | 28120 | [NAME] | Martincowski | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:09:48
5335 | 9915 | Fernanda | Bau | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:10:09
5335 | 5522 | Aglae | Menezes | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | [NAME]
5335 | 19206 | Rebeca | [NAME] | BRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:14:36
Spreadsheet: 547919d1510810295-find-specific-multiple-texts-and-define-it-example-aggregate
Sheet: steps

Text | Apple | Melon | Grape | Cake | Bread | the first intended record (but it needs to be simplified without the need of column B-F) | then if the cell contain both fruits and not fruits, if it mix together, will it be edible? | the second intended result | this column needs to be integrated to column I
[NAME] |  |  |  |  |  |  |  |  | Sulfur
Watermelon Grape Strawbery |  |  |  |  |  |  |  |  | Acid
Bread Melon Cherry Acid |  |  |  |  |  |  |  |  | Mercury
Grape Pineapple Plum Mercury
Juice Melon Strawberry
Spreadsheet: 715774d1611858252-understanding-the-lookup-formula-forum-excel-22-jan-2021
Sheet: Épargnes Inv.

 |  |  |  |  |  | Thanks again for taking the time:) !! I appreciate it!
 |  |  | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
 | Solde actuel des comptes: | AR
 |  | FT
 |  | PL
 |  | UR
DATE | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
2020-01-10 00:00:00 | Deposit | AR | 200
2020-01-21 00:00:00 | Deposit | AR | 200
2020-01-30 00:00:00 | Deposit | AR | 200
2020-03-01 00:00:00 | Deposit | FT | 300
2020-03-01 00:00:00 | Deposit | AR | 25
2020-03-05 00:00:00 | Withdrawal | AR | -30
2020-03-11 00:00:00 | Withdrawal | FT | -45
2020-03-13 00:00:00 | Withdrawal | AR | 20
2020-03-01 00:00:00 | Deposit | PL | 60
2020-03-01 00:00:00 | Deposit | UR | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 0 | 230 |  | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | PL | 0 | 320 |  | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 0 | 55 |  | 65
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 0 | 77 |  | 77
2020-06-15 00:00:00 | Withdrawal | AR | -50
2020-06-15 00:00:00 | Withdrawal | FT | -60
2020-06-15 00:00:00 | Withdrawal | PL | -40
2020-06-15 00:00:00 | Withdrawal | UR | -70
2021-01-01 00:00:00 | Deposit | AR | 120
2021-01-01 00:00:00 | Deposit | FT | 100
2021-01-01 00:00:00 | Deposit | PL | 90
2021-01-01 00:00:00 | Deposit | UR | 80
Spreadsheet: 94247d1294114735-min-max-timesheet-help-minmaxtimesheet
Sheet: Sheet1

Name | Date | Login1 | Logout1 | Login2 | Logout2 | Full Name | Login | Logout | Duration |  |  | Date | (All)
 |  |  |  |  |  | Doe, [NAME] | 11/15/2010 7:45 AM | 11/15/2010 8:55 AM | 01:09:50
 |  |  |  |  |  | Doe, [NAME] | 11/15/2010 9:11 AM | 11/15/2010 11:49 PM | 14:38:07 |  |  | Row Labels | Min of Login1 | [NAME] of Logout2
 |  |  |  |  |  | Doe, [NAME] | 11/16/2010 7:43 AM | 11/16/2010 7:59 AM | 00:15:42 |  |  | Doe, [NAME] | 07:43:00 | 23:49:00
 |  |  |  |  |  | Doe, [NAME] | 11/16/2010 8:01 AM | 11/16/2010 5:48 PM | 09:46:51 |  |  | Grand Total | 07:43:00 | 23:49:00
 |  |  |  |  |  | Doe, [NAME] | 11/17/2010 8:02 AM | 11/17/2010 4:30 PM | 08:28:29
 |  |  |  |  |  | Doe, [NAME] | 11/18/2010 7:47 AM | 11/18/2010 9:58 AM | 02:10:55
 |  |  |  |  |  | Doe, [NAME] | 11/18/2010 9:58 AM | 11/18/2010 12:06 PM | 02:07:31
 |  |  |  |  |  | Doe, [NAME] | 11/18/2010 12:06 PM | 11/18/2010 2:20 PM | 02:14:13
 |  |  |  |  |  | Doe, [NAME] | 11/18/2010 2:20 PM | 11/18/2010 2:24 PM | 00:03:38
 |  |  |  |  |  | Doe, [NAME] | 11/18/2010 2:24 PM | 11/18/2010 4:30 PM | 02:05:37
Spreadsheet: 176344d1345820683-ranking-compiled-data-from-different-worksheets-compilation-of-keywords
Sheet: Daily Deal - Phrase Match

Keyword | Competition | Global Monthly Searches | Local Monthly Searches (Canada)
"daily deal website" | 0.65 | 1900 | 110
"offers" | 0.34 | 4090000 | 60500
"deals" | 0.72 | 16600000 | 1000000
"deal" | 0.26 | 11100000 | 450000
"daily deals" | 0.4 | 301000 | 27100
"deal of the day" | 0.46 | 201000 | 22200
"best deal" | 0.74 | 301000 | 18100
"best deals" | 0.84 | 450000 | 18100
"deal find" | 0.28 | 14800 | 14800
"daily deal" | 0.26 | 301000 | 14800
"hot deals" | 0.39 | 301000 | 9900
"cheap deals" | 0.94 | 110000 | 5400
"good deal" | 0.42 | 368000 | 3600
"online deals" | 0.67 | 74000 | 3600
"great deals" | 0.56 | 49500 | 3600
"coupons online" | 0.58 | 90500 | 2900
"good deals" | 0.63 | 49500 | 3600
"deal finder" | 0.48 | 18100 | 3600
"daily specials" | 0.13 | 14800 | 2400
"one day sale" | 0.18 | 60500 | 2400
"group deals" | 0.68 | 9900 | 1900
"social deals" | 0.32 | 27100 | 1600
"group deal" | 0.5 | 4400 | 720
Spreadsheet: andy_zipper__799__Global_Prod 10-24-01 EM
Sheet: New - 24 Hr

New Global Products made available on
that were not available on
Global Product Short Desc.
For Curr Exch    Forward                 26Oct01         JPY/USD
For Curr Exch    Forward                 26Oct01         USD/EUR
For Curr Exch    Forward                 26Oct01         USD/GBP
For Curr LME     LME (Spot)              26Oct01         JPY/USD
For Curr LME     LME (Spot)              26Oct01         USD/EUR
For Curr LME     LME (Spot)              26Oct01         USD/GBP
Foreign Currency Reuters BOFC            24Oct01         CAD/USD
GO 0.2% Phy EFP  FOB ARA IPE             16-31Dec01      USD/mt
US Coal Phy      PRB8400                 Jan-Dec05       USD/ST-t
US Coal Phy      PRB8800                 Jan-Dec05       USD/ST-t
US Coal Phy Spd  PRB8800 vs PRB8400      Dec01           USD/ST-t
US Coal Phy Spd  PRB8800 vs PRB8400      Nov01           USD/ST-t
US Crude Fin Opt NYMEX WTI    EC21.5     Dec01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EC22.0     Dec01           USD/bl/m
US Crude Fin Opt NYMEX WTI    EP19.5     Dec01           USD/bl/m
US Prop Swap     OPIS MB TET             Jan02           c/Gl-b
US ResidOil Spd  NYH 1% Crack Spread     Jan-Dec02       USD/bl/m
Spreadsheet: 770795d1646253591-working-time-directive-calculations-timesheet2
Sheet: 28-2-22

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | B Bamber / G McDade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | D reid
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | total from last week | total leave taken | TOTAL | 17 WEEK Avrage | Avrage
 | [NAME] |  | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 14 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7
 | [NAME] | 18 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 15.5 | 7.5 | 1 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] | 0 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 25 | 7.5 |  |  | TR | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL
 | [NAME] | 22 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 26 | 7.5 |  |  |  | 7.5 | -1.5 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | Vacant Post | 8.5 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 116977d1312377599-reverse-problem-of-vlookup-reverse-vlookup
Sheet: Sheet1

Name | Date | Value |  |  |  | 2011-01-12 00:00:00 | 2010-02-13 00:00:00 | 2011-05-21 00:00:00 | 2011-04-21 00:00:00
AAA | 2011-01-12 00:00:00 | 10 |  |  | AAA | 10 | 0 | 0 | 0
BBB | 2010-02-13 00:00:00 | 20 |  |  | BBB | 0 | 20 | 0 | 0
CCC | 2011-04-21 00:00:00 | 10 |  |  | CCC | 0 | 0 | 0 | 10
Spreadsheet: 866231d1713195779-group-number-values-into-equal-groups-sample-worksheet
Sheet: Sheet1

76 Number Values | Total of Numbers | Total divided by 19 | Group 1 | Group 2 | Group 3 | Group 4
-7 |  |  | -7 | -4 | 0 | 1
-4 |  |  | 8 | 7 | 6 | 5
0 |  |  | 15 | 14 | 12 | 13
1 |  |  | 25 | 24 | 23 | 22
3
3
4 |  |  | I am trying to find a formula that would provide the desired result.  That result would be 19 groups of 4 equalling 40 or 41 (in this case) preferably.  I would hope to use the formule in the future with different totals and different numbers.  I entered the numbers above at random to visualize a desirable result.  Thanks for any help you can provide.
4
4
5
5
5
6
6
6
6
7
7
7
7
7
7
7
8
8
8
8
8
8
8
8
8
8
8
8
9
10
10
10
10
10
11
11
11
11
11
11
11
11
11
12
12
12
12
12
12
13
13
13
13
13
14
15
15
16
17
17
18
19
22
22
22
22
23
24
25
Spreadsheet: 140830d1328903935-need-help-setting-up-pivots-with-data-already-entered-2-10-12-excel-sample-worksheet
Sheet: Summary

Ocean Air Enterprises
Contract # 85620060038081
Billing Summary
For the Period September 1, 2011 through October 31, 2011
Building
Location |  | Building |  | Total |  | Page
/ Code |  | Address |  | Due |  | #
Brooklyn
 |  |  |  | 0 |  | N/A
 |  |  |  |  |  | 1 - 11
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  |  |  | 12
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
Queens
 |  |  |  | 0 |  | N/A
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14 - 18
 |  |  |  |  |  | 19
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
Staten Island
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  | 0 |  | N/A
 |  |  |  |  |  | 20
N/A - No Activity This Period
Spreadsheet: 89341d1289150403-automatic-monthly-payment-until-end-multiple-monhtly-payment
Sheet: multiple payment

Amount | Monthly instalment | # payment
1000 | 100 | 12
Date | Payment
2010-01-01 00:00:00
2010-01-02 00:00:00
…
2010-02-01 00:00:00 | 100 | what is the formula giving the payment amount next to 1 of each month until end of payment?
…
2010-03-01 00:00:00 | 100
…
2010-04-01 00:00:00 | 100
…
Spreadsheet: 139190d1328119389-nested-if-statements-to-display-value-criteria
Sheet: Sheet1

Loss of Revenue (Q1) | RTO Options (Q2) | Patient Care (Q3)
$1,000,000 per day | <= 1 hour | 75% of care
? | 2-24 Hours | 50% of care
? | ? | 25% of care
? | ? | 0% of care
$1,000,000 per day | <= 1 hour | 100% of care
? | 2-24 Hours | ?
Spreadsheet: 272362d1382366972-rearranging-datewise-horizontally-in-a-specified-format-from-raw-data-vat1_sr
Sheet: Result(Revised)

Date | Name of Party | Particulars | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total
 |  |  | [NAME]. 610
 |  |  | [NAME]. 504
 |  |  | [NAME]. 4409
 |  |  | PP NO.55408
 |  |  | PP NO. 55253
 |  |  | RECEPT NO. 93198
Spreadsheet: 126616d1319775978-using-reference-with-inserting-rows-sample-1-
Sheet: Planned

task | Planned | 2011-10-04 00:00:00
task 1 - draw |  | 8
task 2 - build |  |  | 8 | 8 | 8
INSERTED TASK
task 3 - assemble something |  |  |  |  | 8 | 8 | 8
task 4 - some task again |  |  |  |  |  | 8 | 8 | 8 | 8
Spreadsheet: 121593d1316185598-consolidate-data-from-multiple-tabs-in-the-same-excel-file-classsignupsconsolidate
Sheet: Consolidated

Name | Total Hours
FMEA01_Studies | 0
FMEA01_PT | 0
FMEA01_CM | 0
FMEA01_Others | 0
FMEA02_Studies | 0
FMEA02_PT | 0 |  |  |  | Sum of Total Hours
FMEA02_CM | 0 |  |  |  | Name | Total
FMEA02_Others | 0 |  |  |  | FMEA01_CM | 30
FMEA03_Studies | 0 |  |  |  | FMEA01_Others | 1099
FMEA03_PT | 0 |  |  |  | FMEA01_PT | 999
FMEA03_CM | 0 |  |  |  | FMEA01_Studies | 700
FMEA03_Others | 0 |  |  |  | FMEA02_CM | 0
FMEA04_Studies | 0 |  |  |  | FMEA02_Others | 0
FMEA04_PT | 0 |  |  |  | FMEA02_PT | 100
FMEA04_CM | 0 |  |  |  | FMEA02_Studies | 1025
FMEA04_Others | 0 |  |  |  | FMEA03_CM | 0
FMEA05_Studies | 0 |  |  |  | FMEA03_Others | 0
FMEA05_PT | 0 |  |  |  | FMEA03_PT | 10
FMEA05_CM | 0 |  |  |  | FMEA03_Studies | 0
FMEA05_Others | 0 |  |  |  | FMEA04_CM | 0
FMEA06_Studies | 0 |  |  |  | FMEA04_Others | 0
FMEA06_PT | 0 |  |  |  | FMEA04_PT | 10
FMEA06_CM | 0 |  |  |  | FMEA04_Studies | 0
FMEA06_Others | 0 |  |  |  | FMEA05_CM | 0
FMEA01_Studies | 100 |  |  |  | FMEA05_Others | 10
FMEA02_Studies | 10 |  |  |  | FMEA05_PT | 0
FMEA03_PT | 10 |  |  |  | FMEA05_Studies | 10
FMEA04_PT | 10 |  |  |  | FMEA06_CM | 0
FMEA05_Others | 10 |  |  |  | FMEA06_Others | 200
FMEA06_Others | 200 |  |  |  | FMEA06_PT | 0
FMEA06_Studies | 500 |  |  |  | FMEA06_Studies | 500
FMEA01_PT | 999 |  |  |  | Grand Total | 4693
FMEA01_Others | 1000
FMEA05_Studies | 10
FMEA01_Others | 99
FMEA02_Studies | 10
FMEA02_PT | 100
FMEA01_Studies | 500
FMEA02_Studies | 5
FMEA01_CM | 30
FMEA02_Studies | 1000
FMEA01_Studies | 100
Spreadsheet: 870431d1716949333-creating-a-dynamic-list-based-on-values-in-a-table-mock-data-dynamic-list-creation
Sheet: Sheet1

 |  |  | Apples | Bananas | Pears |  |  | Desired Output
 |  | North | 1 | 3 | 2 |  |  | North_Apples_1
 |  | South | 0 | 2 | 2 |  |  | East_Apples_1 |  |  | East_Apples_1
 |  | East | 1 | 0 | 3 |  |  | West_Apples_1 |  |  | West_Apples_1
 |  | West | 2 | 1 | 1 |  |  | West_Apples_2 |  |  | West_Apples_2
 |  |  |  |  |  |  |  | North_Bananas_1 |  |  | North_Bananas_1
 |  |  |  | total | 18 |  |  | North_Bananas_2 |  |  | North_Bananas_2
 |  |  |  |  |  |  |  | North_Bananas_3 |  |  | North_Bananas_3
 |  |  |  |  |  |  |  | South_Bananas_1 |  |  | South_Bananas_1
 |  |  |  |  |  |  |  | South_Bananas_2 |  |  | South_Bananas_2
 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  | North_Pears_1 |  |  | North_Pears_1
 |  |  |  |  |  |  |  | North_Pears_2 |  |  | North_Pears_2
 |  |  |  |  |  |  |  | South_Pears_1 |  |  | South_Pears_1
 |  |  |  |  |  |  |  | South_Pears_2 |  |  | South_Pears_2
 |  |  |  |  |  |  |  | East_Pears_1 |  |  | East_Pears_1
 |  |  |  |  |  |  |  | East_Pears_2 |  |  | East_Pears_2
 |  |  |  |  |  |  |  | East_Pears_3 |  |  | East_Pears_3
 |  |  |  |  |  |  |  | West_Pears_1 |  |  | West_Pears_1
 |  |  |  |  |  |  |  |  | 18 entries
Spreadsheet: 42683d1241213823-concatenate-excel-forum-concatenate
Sheet: Sheet1

Deal | Date | Amount | Currency |  | Concatenate |  | Alternative Concatenate
12 | 01.05.09 | -1200 | GBP |  | 12 01.05.09 -1200 GBP 1500 EURO |  | 12 01.05.09 -1200 GBP 1500 EURO
 |  | 1500 | EURO
Or this alternative
12 | 2009-05-01 00:00:00 | -1200 | GBP |  | 12 01.05.2009 -1200 GBP -1200 GBP
 |  | 1500 | EURO
Concatenate - Excel Help Forum
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 16

Product* | October 18 | October 25 | November 1 | November 8 | November 15
Total Equity** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Equity Swaps | N/A | N/A | N/A | N/A | N/A
Portfolio Swaps | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaptions | N/A | N/A | N/A | N/A | N/A
[NAME] | N/A | N/A | N/A | N/A | N/A
TOTAL | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Gross notional amount outstanding, November 15 weekly snapshot, by product type, all tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***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: 792968d1661247594-lookup-search-and-find-addon
Sheet: Sheet1

System | Brand | Type | ADD-ON | Gender
UNIQUE COLOR BLIND SUNGLASS | UNIQUE | SUNGLASS | COLOR BLIND
UNIQUE FRAME | UNIQUE | FRAME
UNIQUE KIDS FRAME WITH BLUE CONTROL | UNIQUE | FRAME | BLUE CONTROL | Kids
UNIQUE KIDS FRAME WITH CLIP ON | UNIQUE | FRAME | CLIP ON | Kids
UNIQUE KIDS FRAME/CHANGEABLE COLOR WITH BC | UNIQUE | FRAME | CHANGEABLE COLOR WITH BC | Kids
UNIQUE KIDS SUNGLASS | UNIQUE | SUNGLASS |  | Kids
UNIQUE SUNGLASS | UNIQUE | SUNGLASS
ZAINIA COLOR BLIND SUNGLASS | ZAINIA | SUNGLASS | COLOR BLIND
ZAINIA FRAME | ZAINIA | FRAME
ZAINIA FRAME WITH BLUE CONTROL | ZAINIA | FRAME | BLUE CONTROL
ZAINIA FRAME WITH UV420 | ZAINIA | FRAME | UV420
ZAINIA SUNGLASS | ZAINIA | SUNGLASS