tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: TTM Recon Q4FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended March 31, 2011
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on licensed intellectual property commitment (COGS) |  | Gain on Strategic Investments |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3589 |  | 0 |  | 239 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3828
Cost of revenue | 1499 |  | -12 |  | 0 |  | 1 |  | 0 |  | 0 |  | -2 |  | 0 |  | 1486
Gross profit | 2090 |  | 12 |  | 239 |  | -1 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2342
Operating expenses:
Marketing and sales | 747 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -21 |  | 0 |  | 726
General and administrative | 301 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -40 |  | 0 |  | 261
Research and development | 1153 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -111 |  | 0 |  | 1042
Acquisition-related contingent consideration | -17 |  | 17 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 57 |  | -57 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 161 |  | 0 |  | 0 |  | 0 |  | 0 |  | -161 |  | 0 |  | 0 |  | 0
Total operating expenses | 2402 |  | -40 |  | 0 |  | 0 |  | 0 |  | -161 |  | -172 |  | 0 |  | 2029
Operating income (loss) | -312 |  | 52 |  | 239 |  | -1 |  | 0 |  | 161 |  | 174 |  | 0 |  | 313
Gain on strategic investments | 23 |  | 0 |  | 0 |  | 0 |  | -23 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 10 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 10
Income (loss) before provison for (benefit from) income taxes | -279 |  | 52 |  | 239 |  | -1 |  | -23 |  | 161 |  | 174 |  | 0 |  | 323
Provision for (benefit from) income taxes | -3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 93 |  | 90
Net income (loss) | -276 |  | 52 |  | 239 |  | -1 |  | -23 |  | 161 |  | 174 |  | -93 |  | 233
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -0.84 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  | 0.7
Spreadsheet: 54098d1254133337-pivot-table-invoice-issue-pivot-table-issue
Sheet: Normal  & OT Hours

HDR | Contractor: |  | 0 | Agreed Hourly Rate: |  | 10
HDR | Vendor Number: |  | 0 | Agreed Overtime Rate: |  | 15
 | Invoice Number: |  | 1A | Agreed Tag Time Rate: |  | 12.5
HDR | Date of Invoice: |  | 2009-09-27 00:00:00 |  |  | 0
HDR | Submitted by: |  | 0 | For the attention of: |  | 0
HDR | PO: |  | 0 |  |  | 0
HDR
 | Normal |  |  |  |  |  |  | Overtime
HDR |  | Date of work | Name of Contractor | Service Order number | No. of [NAME] | Amount (excl. VAT) |  |  | Date of work | Name of Contractor | Service Order number | No. of OT / Tag Hrs | Amount (excl. VAT)
HDR
DAT | Eg. | 2009-01-01 00:00:00 | [NAME] | 1A | xx.xx | £xxx.xx |  | Eg. | 2009-01-01 00:00:00 | [NAME] | 1A | xx.xx | £xxx.xx
 | 1 | 2009-09-27 00:00:00 | [NAME] T | 1B | 10 | 100 |  | 1 | 2009-09-27 00:00:00 | [NAME] T | 1E | 2.5 | 37.5
 | 2 | 2009-09-27 00:00:00 | [NAME] T | 1C | 10 | 100 |  | 2 | 2009-09-27 00:00:00 | [NAME] T | 1F | 10 | 150
 | 3 | 2009-09-27 00:00:00 | [NAME] T | 1D | 10 | 100 |  | 3 | 2009-09-27 00:00:00 | [NAME] T | 1G | 10 | 150
 | 4 | 2009-09-27 00:00:00 | [NAME] T | 1E | 7.5 | 75 |  | 4 | 2009-09-27 00:00:00 | Birch W | 2E | 2.5 | 37.5
DAT | 7 | 2009-09-27 00:00:00 | Birch W | 2B | 10 | 100 |  | 5 | 2009-09-27 00:00:00 | Birch W | 2F | 10 | 150
 | 8 | 2009-09-27 00:00:00 | Birch W | 2C | 10 | 100 |  | 6 | 2009-09-27 00:00:00 | Birch W | 2G | 10 | 150
 | 9 | 2009-09-27 00:00:00 | Birch W | 2D | 10 | 100 |  |  |  |  | Total: | 45 | 675
 | 10 | 2009-09-27 00:00:00 | Birch W | 2E | 7.5 | 75
 |  |  |  | Total: | 75 | 750
DAT
DAT
DAT
DAT
DAT
TRL
Spreadsheet: 720182d1614061266-guidance-on-how-i-can-automate-the-on-time-where-it-follows-certain-conditions-test
Sheet: Scenario 3

Time (Normal Room) | ON/OFF Time |  | Time | Duration(min) | Normal Room
00:00:00 | 1 |  | 1900-01-12 00:00:00 | 0 | 1
 | 1 |  | 1900-01-12 00:10:00 | 10 | 1
 | 0 |  | 1900-01-12 00:20:00 | 20 | 1
 |  |  | 1900-01-12 00:30:00 | 30 | 1
 |  |  | 1900-01-12 00:40:00 | 40 | 0
 |  |  | 1900-01-12 00:50:00 | 50 | 1
 |  |  | 1900-01-12 01:00:00 | 60 | 1
 |  |  | 1900-01-12 01:10:00 | 70 | 1
 |  |  | 1900-01-12 01:20:00 | 80 | 1
 |  |  | 1900-01-12 01:30:00 | 90 | 0
 |  |  | 1900-01-12 01:40:00 | 100 | 1
 |  |  | 1900-01-12 01:50:00 | 110 | 1
 |  |  | 1900-01-12 02:00:00 | 120 | 0
 |  |  | 1900-01-12 02:10:00 | 130 | 0
 |  |  | 1900-01-12 02:20:00 | 140 | 0
 |  |  | 1900-01-12 02:30:00 | 150 | 0
 |  |  | 1900-01-12 02:40:00 | 160 | 0
 |  |  | 1900-01-12 02:50:00 | 170 | 0
 |  |  | 1900-01-12 03:00:00 | 180
 |  |  | 1900-01-12 03:10:00 | 190
 |  |  | 1900-01-12 03:20:00 | 200
 |  |  | 1900-01-12 03:30:00 | 210
 |  |  | 1900-01-12 03:40:00 | 220
 |  |  | 1900-01-12 03:50:00 | 230
 |  |  | 1900-01-12 04:00:00 | 240
 |  |  | 1900-01-12 04:10:00 | 250
Normal Room |  |  | 1900-01-12 04:20:00 | 260
ON time (min) | 40 |  | 1900-01-12 04:30:00 | 270
OFF time (min) | 10 |  | 1900-01-12 04:40:00 | 280
 |  |  | 1900-01-12 04:50:00 | 290
 |  |  | 1900-01-12 05:00:00 | 300
 |  |  | 1900-01-12 05:10:00 | 310
 |  |  | 1900-01-12 05:20:00 | 320
 |  |  | 1900-01-12 05:30:00 | 330
 |  |  | 1900-01-12 05:40:00 | 340
 |  |  | 1900-01-12 05:50:00 | 350
 |  |  | 1900-01-12 06:00:00 | 360
 |  |  | 1900-01-12 06:10:00 | 370
 |  |  | 1900-01-12 06:20:00 | 380
 |  |  | 1900-01-12 06:30:00 | 390
 |  |  | 1900-01-12 06:40:00 | 400
 |  |  | 1900-01-12 06:50:00 | 410
 |  |  | 1900-01-12 07:00:00 | 420
 |  |  | 1900-01-12 07:10:00 | 430
 |  |  | 1900-01-12 07:20:00 | 440
 |  |  | 1900-01-12 07:30:00 | 450
 |  |  | 1900-01-12 07:40:00 | 460
 |  |  | 1900-01-12 07:50:00 | 470
 |  |  | 1900-01-12 08:00:00 | 480
 |  |  | 1900-01-12 08:10:00 | 490
 |  |  | 1900-01-12 08:20:00 | 500
 |  |  | 1900-01-12 08:30:00 | 510
 |  |  | 1900-01-12 08:40:00 | 520
 |  |  | 1900-01-12 08:50:00 | 530
 |  |  | 1900-01-12 09:00:00 | 540
 |  |  | 1900-01-12 09:10:00 | 550
 |  |  | 1900-01-12 09:20:00 | 560
Spreadsheet: 438576d1452029692-need-to-get-a-simple-forecast-budget-excel-sample-ch3-1-cash-budge_student-template
Sheet: cash budget

[NAME]
Cash budget
 |  | 2012-04-01 00:00:00
Sales |  | 291000 | 365000 | 387000 | 329000 | 238000 | 145000 | 92000
Collections:
Cash | 0.4
First Month
Second Month
Total Collections
Purchases | 0.5
Payments
First Month | 0.6
Second Month | 0.4
Total payments
Collections
Less Disbursement
Inventory Payments
Wages | 0.2
Lease Payment | 10000
Interest |  |  |  | 30000 |  |  | 30000
Dividend (Common) |  |  |  | 50000
Taxes |  |  |  | 25000 |  |  | 25000
Capital Outlays |  |  |  |  | 200000
Total Disbursements
Beginning Cash Balance |  |  |  | 20000
Collections
Disbursements
Unadjusted Cash Balance
Current Borrowing
Ending Cash Balance
cuCumulative Borrowing |  |  | 0
Notes:
Minimum Cash Balance | 15000
Spreadsheet: tom_donohoe__39896__First Mth Noms for Enron Single Sheet
Sheet: Sheet1

 |  | Available Nominations for ENRON
FINAL!!! - Revision #1
 |  | 2000-12-01 00:00:00
#'S | Available Property | Pipeline | [NAME] # | MMBTU | 0.5
1 | East Breaks 110 | HIOS | 150408 | 4967
 | East Breaks 160 | HIOS | 33056 | 1904
 | East Breaks 165 | HIOS | 33055 | 2665
 | High Island 302 | HIOS | 161720 | 0
 | High Island 309 | HIOS | 161760 | 690 |  | Revision
 | High Island 310 | HIOS | 161759 | 372 |  | Revision
 | High Island 330 | HIOS | 161820 | 98
 | High Island 474/475 | HIOS | 161647 | 568
 | High Island 489 | HIOS | 161648 | 86
 | West Cameron 172E | ANR | 263952 | 1344
Attention: [NAME]
(713) 646-3390 fax
(713) 853-7164 phone
HIOS
1 | East Cameron 359 | STINGRAY | 905955 | 129
 | West Cameron 172D | STINGRAY | 36111 | 1987
 | West Cameron 180/144 | STINGRAY | 900483 | 1474
 | West Cameron 538 | STINGRAY | 906088 | 1
Attention: [NAME] ([EMAIL])
(713) 646-8543 fax
(713) 853-3570 phone
Stingray
1 | Eugene Island 372 | TGP | 018043 | 0
 | Rockefeller #1 (TGP) | TGP | 012540 | 0
 | Ship Shoal 111 | TGP | 012102 | 297
 | West Delta 54 | TGP | 010472 | 5500
Attention: [NAME] or [NAME]
(713) 646-2626 fax
(713) 853-4210 phone
Tennessee
1 | Ft. St. Phillips | [NAME] | 012685 | 0 | 0
Attention: [NAME]
(713) 646-8453 fax
(713) 345-7791 phone
[NAME]
1 | South Timbalier 185 | TRUNKLINE | 81709 | 0
 |  |  | Total Nominations of all fields:
Attention: Nelson Ferries |  |  |  |  | PANACO'S NOMINATIONS
[EMAIL] |  |  |  |  | PHONE: (713) 970-3133
(713) 646-3239 fax |  |  |  |  | FAX: (713) 970-3151
(713) 853-3061 phone |  |  |  |  | Lesley Strange
 |  |  |  |  | Volume Control Analyst
Attention:  [NAME]
[EMAIL]
Attention:  [NAME]
[EMAIL]
Spreadsheet: 876726d1723469643-excel-tables-question-tables
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | TRY 1 |  |  | TRY 2 |  |  | TRY 3 |  |  |  |  | TRY 4 | Column1 | Column2 | Column3
 | Hdr A | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  | Return A | Return C |  | Return A | Return C |  | Return A | Return C | New Col 1 | New Col 2 |  | Return A | Return C | New Col 1 | New Col 2
 | 6 | ACD | Elm | Why not |  | 425T |  |  |  |  |  |  | Elm |  |  | Elm
 | 11 | EDF | Maple | Because | Some blank | R342 |  |  |  |  |  | 11 | Maple |  | 11 | Maple
 | 156 | GHS | Elm | Maybe |  | 425T |  |  |  |  |  | 156 | Elm |  | 156 | Elm
 | 5 | TIF | Birch | I said so | But not | TR4 |  |  |  |  |  | 5 | Birch |  | 5 | Birch
 | 54 | KFSD | Pine | No | here | XSD |  |  |  |  |  | 54 | Pine |  | 54 | Pine
 | 21 | SF | Oak | Definitely not |  | 3860 |  |  |  |  |  | 21 | Oak |  | 21 | Oak
 | 33 | CEP | Elm | OK | Or | 425T |  |  |  |  |  | 33 | Elm |  | 33 | Elm
 | 4 | SF | Hickory | Fine | here | dfs |  |  |  |  |  | 4 | Hickory |  | 4 | Hickory
 |  |  |  |  |  |  |  |  | TRY1A
 |  |  |  |  |  |  |  |  | Return C | Return F
Spreadsheet: 132719d1323890321-pulling-top-10-to-a-new-sheet-book3
Sheet: Top 10%

Table 1 |  |  | Table 2 |  |  | Table 3 |  |  | Table 4 |  |  | Table 5
Top 10% by Sales |  |  | Top 10% by Cost |  |  | Top 10% by # of Units |  |  | Top 10% by Margin |  |  | Top 10% by Margin %
[NAME] | Amount |  | [NAME] | Amount |  | [NAME] | Amount |  | [NAME] | Amount |  | [NAME] | Amount
Spreadsheet: 725966d1617002415-need-help-to-simplify-the-formula-eosb-computation-v2
Sheet: EOSB Computation 

 | Nature of Leaving | Basic Salary per month | Joining Date | Leaving Date | Years of Service | Calculated EOSB
 | Resignation | 5000 | 2019-11-01 00:00:00
Row # | Nature of Leaving | Year of Service | Entitlement
A9 | Termination | upto 1 Year | No end of service benefits
A10 | Termination | 1 to 5 Years | 21 days of salary for every completed years of service
A11 | Termination | 5 years and above | 31 days of salary for every completed years of service
A12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resignation
A13 | Resignation | upto 1 Year | No end of service benefits |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Termination
A14 | Resignation | 1 to 3 Years | One third of total entitlement computed as per above slabs ([NAME] and A11)
A15 | Resignation | 3 to 5 Years | Two third of total entitlement computed as per above slabs (Rows 9,10 and 11)
A16 | Resignation | 5 years and above | Full entitlement as per the computation done in accordance with above slabs ([NAME] and A11)
 | Term | Salary per month | Days for computation | Years of Service | Termination | Resignation
 | 1-5 years | 5000 | 21
 | 5 and above Years | 5000 | 31
Spreadsheet: 861624d1709516359-invoices-from-csv-file-2024-autum-fixtures-senior
Sheet: Grade

grade | bye | away team | Count of home team
Monday Open Men A Grade |  |  | 48
 | Chef's Balling Brigade |  | 3
 | [NAME] InglÃ©s |  | 2
 | Nuggets |  | 2
 | Sonics |  | 2
 | The boys team |  | 2
 | The [NAME] |  | 2
 | ThunderUp |  | 3
Monday Open Men B Grade |  |  | 48
 | Big Baller Brand |  | 2
 | [NAME] |  | 2
 | Demolition Men |  | 3
 | LDUA - Monday |  | 3
 | Mentone Mustangs Open Men |  | 2
 | Oilers |  | 2
 | Saints Open Men Spurs |  | 2
Monday Open Men C Grade |  |  | 71
 | [NAME] |  | 1
 | LeGreatness |  | 1
 | [NAME] |  | 1
Monday Open Men D Grade |  |  | 63
 | [NAME] |  | 1
Monday Open Women A/B Grade |  |  | 85
Thursday Open Men A Grade |  |  | 38
 | Bayside 75ers |  | 4
 | Fish and Chips |  | 4
 | LDUA |  | 3
 | Slingshot |  | 4
 | The Next Chapter |  | 4
Thursday Open Men B Grade |  |  | 57
Thursday Open Men C Grade |  |  | 76
 | 99 Problems (But a Swish Ain't One) |  | 2
 | Cream City |  | 2
 | Fellas in Paris |  | 2
 | Nuggz |  | 2
 | [NAME] |  | 2
 | Raptors BC |  | 2
 | Runnez |  | 3
 | sheep. |  | 2
 | Splash Merchants |  | 2
Thursday Open Men D Grade |  |  | 76
Thursday Open Women A/B Grade |  |  | 76
Tuesday Open Men A Grade |  |  | 60
Tuesday Open Men B Grade |  |  | 59
 | southside trents |  | 1
 | Straight Outta Beauy |  | 1
 | Warriors |  | 1
Tuesday Open Men C Grade |  |  | 99
Tuesday Open Men D Grade |  |  | 80
 | And [NAME] |  | 2
 | Better Call Gasol |  | 3
 | Grey Army |  | 2
 | Lebrontourage |  | 2
 | OMBC Panthers Open Men Scallops |  | 2
 | [NAME] |  | 2
 | Spicy Bandits |  | 2
 | [NAME] |  | 2
 | The Benchwarmers |  | 3
Wednesday Open Men A/B Grade |  |  | 61
 | Eagles |  | 2
 | Eagles Basketball Club |  | 3
 | Huskies |  | 3
 | Ombc Panthers Black |  | 3
 | OMBC Panthers Open Men Thunder |  | 2
 | We Play Ball |  | 3
 | We Want Smoke |  | 3
Wednesday Open Men C Grade |  |  | 119
 | JBallers |  | 1
 | Saints Open Men Black |  | 1
Wednesday Open Men D Grade |  |  | 95
Wednesday Open Men Over 35 A Grade |  |  | 60
Wednesday Open Men Over 35 B Grade |  |  | 80
 | Aztecs. |  | 2
 | [NAME] |  | 2
 | Brick City |  | 2
 | [NAME] |  | 2
 | [NAME] |  | 3
 | OMBC Panthers Open Men Awesomness |  | 2
 | OMBC Panthers Open Men Classics |  | 2
 | OMBC Panthers Open Men Legends |  | 2
 | Thunder truck |  | 3
Total Geral |  |  | 1489
Spreadsheet: 31756d1227708850-array-formulas-sample-data-for-array-problems
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Electric |  |  |  |  | Gas |  |  |  |  | Telephone
Branch | Staff ID Summary | Electric Sales Rep ID | Staff First Name | Staff Second Name | Gas Sales Rep ID | Staff First Name | Staff Second Name | Telephone Sales Rep ID | Staff First Name | Staff Second Name | Type of Electric Payment | Type of Gas Payment | Type of Telephone payment | FDD Count | ODP | PPM | VDD | BC | FDD Count | ODP | PPM | VDD | BC | FDD Count | VDD
Ncl | NDRO15242 | NDRO15242 | Richie | OWENS | NDRO15242 | Richie | OWENS |  |  |  | FDD | FDD |  | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | NDSH26505 | NDSH26505 | Sean | [NAME] | NDSH26505 | Sean | [NAME] |  |  |  | FDD | FDD |  | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | HDRM19242 | HDRM19242 | [NAME] | MCCALLUM | HDRM19242 | [NAME] | MCCALLUM |  |  |  | FDD | FDD |  | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | 0 |  |  |  |  |  |  | SDLJ29719 | [NAME] | JENKINS |  |  | VDD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Ncl | SDSS28250 | SDSS28250 | [NAME] | SHAH | SDSS28250 | [NAME] | SHAH |  |  |  | FDD | FDD |  | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | SDPS28925 | SDPS28925 | Pratik | SONI |  |  |  |  |  |  | ODP |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | 0 |  |  |  |  |  |  | SDHP26017 | [NAME] | [NAME] |  |  | VDD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Ncl | NDIC28862 | NDIC28862 | Ian | COATES | NDIC28862 | Ian | COATES |  |  |  | ODP | ODP |  | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
Ncl | SDMN27840 | SDMN27840 | [NAME] | NAWAZ | SDMN27840 | [NAME] | NAWAZ | SDMN27840 | [NAME] | NAWAZ | VDD | VDD | VDD | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
Ncl | SDMN27840 | SDMN27840 | [NAME] | NAWAZ | SDMN27840 | [NAME] | NAWAZ |  |  |  | FDD | FDD |  | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | SDSS28250 | SDSS28250 | [NAME] | SHAH | SDSS28250 | [NAME] | SHAH |  |  |  | FDD | FDD |  | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | SDNR28473 | SDNR28473 | Nikki | RIDEHALGH | SDNR28473 | Nikki | RIDEHALGH |  |  |  | FDD | FDD |  | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | NDRO15242 | NDRO15242 | Richie | OWENS | NDRO15242 | Richie | OWENS |  |  |  | ODP | ODP |  | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
Ncl | NDRO15242 | NDRO15242 | Richie | OWENS | NDRO15242 | Richie | OWENS |  |  |  | VDD | VDD |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Ncl | NDRO15242 | NDRO15242 | Richie | OWENS | NDRO15242 | Richie | OWENS |  |  |  | BC | FDD |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Ncl | NDRO15242 | NDRO15242 | Richie | OWENS | NDRO15242 | Richie | OWENS |  |  |  | FDD | FDD |  | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: john_arnold__15477__Security List
Sheet: Sheet1

SECURITY LIST
 | Office of the Chair |  | Power Team |  | Gas Team
1 | [NAME] | 1 | Casey Evans - Risk | 1 | ANDY LEWIS | Trading
2 | [NAME] | 2 | Claudia Guerra | 2 | [NAME] | Risk
3 | [NAME] | 3 | [NAME] | 3 | Biliana  Pehlivanova (reports) | Risk
4 | [NAME] | 4 | Donnie Vinson - EES | 4 | BRAD MCKAY | Trading
5 | [NAME] | 5 | [NAME] | 5 | [NAME] | Risk
6 | [NAME] | 6 | [NAME] | 6 | [NAME] | Logistics
7 | [NAME] | 7 | [NAME] | 7 | [NAME] | Trading
8 | [NAME] | 8 | [NAME] | 8 | DUTCH QUIGLEY | Trading
9 | [NAME] | 9 | [NAME] | 9 | [NAME] | Trading
10 | [NAME] | 10 | [NAME] | 10 | [NAME] | Risk
11 | [NAME] | 11 | [NAME] | 11 | FRANK ERMIS | Trading
 |  | 12 | [NAME] | 12 | FRED LAGRASTA | Trading
 |  | 13 | [NAME] | 13 | GEOF STOREY | Trading
 |  | 14 | Narsimha Misra - EES | 14 | Glory Chi | Risk
 |  | 15 | [NAME] | 15 | [NAME] | Trading
 |  | 16 | [NAME] | 16 | INA RANGEL | Trading
 |  | 17 | [NAME] | 17 | [NAME] | Trading
 |  | 18 | T. Jae Black | 18 | [NAME] | EES Logistics
 |  | 19 | [NAME] | 19 | [NAME] | Trading
 |  |  |  | 20 | [NAME] GRIFFITH | Trading
 |  |  |  | 21 | JON MCKAY | Trading
 |  |  |  | 22 | JUSTIN O'MALLEY | Trading
 |  |  |  | 23 | [NAME] | Risk
 |  |  |  | 24 | KEITH HOLST | Trading
 |  |  |  | 25 | [NAME] MAY | Trading
 |  |  |  | 26 | Margie Straight | Logistics
 |  |  |  | 27 | [NAME] | Trading
 |  |  |  | 28 | [NAME] | [NAME]
 |  |  |  | 29 | [NAME] | Trading
 |  |  |  | 30 | [NAME] | Trading
 |  |  |  | 31 | [NAME] | Logistics
 |  |  |  | 32 | [NAME] | Risk
 |  |  |  | 33 | PETE KEAVEY | Trading
 |  |  |  | 34 | PHIL POLSKY | Trading
 |  |  |  | 35 | [NAME] | EES Logistics
 |  |  |  | 36 | [NAME] | Risk
 |  |  |  | 37 | Stephanie Stehling | EES Logistics
 |  |  |  | 38 | [NAME] | Risk
 |  |  |  | 39 | [NAME] | Logistics
 |  |  |  | 40 | [NAME] | Risk
Spreadsheet: 229340d1366371637-dependent-drop-down-lists-based-on-dynamic-data-range-book2-1-
Sheet: Dashboard

 | Year | 2013
 | Q | Qtr 1
 | Month | Feb
 | Brand
 | SKU | SDS-1941-Black
 |  |  |  | I THINK this is what you mean.  I wont know if it works fully until you test it with more data.
 |  |  |  | Appears to work with the limited data included though.
Spreadsheet: 808257d1670369455-product-of-two-columns-if-column-a-is-entry-is-text-get-value-from-another-column-excelforum-short-solution
Sheet: Sheet1

 |  | any number | get this if column B is text |  |  |  |  | product
abc |  | 2 | 3 |  |  |  |  |  |  | <- problem if column is text , get value from column D
2 |  | 3
3 |  | 4
4 |  | 5
2 |  | 6
3 |  | 7
4 |  | 8 |  |  | column B x column E
 |  |  |  |  |  |  |  |  | expected output
 |  |  |  |  | single shot fromula
Spreadsheet: 886720d1736839320-extract-values-in-alternate-columns-based-on-matching-criteria-sample
Sheet: Sheet1

 | Available data |  |  |  |  |  |  | Required to be filled
 | A | S | D | F |  |  |  | A | S | D | F
 | 1 | 2 | 3 | 4 |  |  |  | 1 |  | 3
 | 5 | 6 | 7 | 9 |  |  |  | 3 |  | 5
 | 3 | 4 | 5 | 6 |  |  |  | 5 |  | 7
Spreadsheet: 764033d1642536630-numerical-value-of-letters-in-words-example2576
Sheet: Sheet1

Character | Value
A | 1 |  |  | Target Cell
B | 2 |  |  | Hello:
C | 3 |  |  | Target Cell split into separate cells for calculation
D | 4 |  |  | H | E | L | L | O | :
E | 5
F | 6
G | 7 |  |  | Value
H | 8
I | 9
J | 10
K | 11
L | 12
M | 13
N | 14
O | 15
P | 16
Q | 17
R | 18
S | 19
T | 20
U | 21
V | 22
W | 23
X | 24
Y | 25
Z | 26
, | 1
. | 2
: | 3
; | 3
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
Spreadsheet: 677342d1589310671-filter-and-total-filter
Sheet: SHEET 1

DATE | Description | Money in | Money Out | MONEY IN REASON | MONEY OUT REASON
2020-03-17 00:00:00 | CARD PAYMENT TO MAGNET ACTURIS RECEIPT,579.03 GBP, RATE 1.00/GBP ON 13-03-2020 |  | 45
2020-03-14 00:00:00 | CARD PAYMENT TO TFL TRAVEL CH,3.00 GBP, RATE 1.00/GBP ON 12-03-2020 |  | 3 |  | NON
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT TO VIRGIN MEDIA PYMTS REF 214427, MANDATE NO 0021 |  | 30
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT TO BRITISH GAS REF 123456, MANDATE NO 0075 |  | 50
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT DERPE, MANDATE NO 0026 |  | 60
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT DERPE, MANDATE NO 0026 |  | 60
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT TO VIRGIN MEDIA PYMTS REF 214427, MANDATE NO 0021 |  | 30
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT TO BRITISH GAS REF 123456, MANDATE NO 0075 |  | 50
2019-12-24 00:00:00 | CARD PAYMENT TO ISLEWORTH,9.99 GBP, RATE 1.00/GBP ON 21-12-2019 |  | 9.99 |  | REPAIRS 38
2019-12-18 00:00:00 | CARD PAYMENT TO FIREPROTECT,75.05 GBP, RATE 1.00/GBP ON 15-12-2019 |  | 15 |  | REPAIRS 38
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 16

Product* | February 14 | February 21 | February 28 | March 7 | March 14
Total Equity**
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
Gross notional amount outstanding, March 14 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].