tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 110485d1307121522-adding-multiple-rows-based-on-column-info-adding-multiple-rows-based-on-column-info
Sheet: Sheet1

Filed 1 | Filed 2 | Filed 3
A | 2 | X
A | 3 | X
A | 5 | X
B | 2 | X
B | 4 | X
B | 5 | X
C | 1 | X
C | 5 | X
Spreadsheet: 816631d1675758237-sum-by-year-book2-1-
Sheet: Trail Balance

 | TRAIL BALANCE
Account | Account Type | Debit | Credit | Balance
Cash In Hand | ASSEST
Cash In Bank | ASSEST
Misc Income | INCOME
Rent Accrual | ASSEST
Interest Received | ASSEST
Acc.Payable | LIABILITY
Drawings | LIABILITY
Rental Income | INCOME
Tax | LIABILITY
Utility | LIABILITY
Management Fees | LIABILITY
Sundry Expenses | LIABILITY
Maintenanace | LIABILITY
[NAME] | LIABILITY
Bank Charges | LIABILITY
Donation | LIABILITY
Equity | LIABILITY
Account Receivable | ASSEST
Shareholder | LIABILITY
security deposit | LIABILITY
Spreadsheet: 718535d1613170250-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 21

 |  |  | Date | 2021-01-21 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 15:00:00 | 16:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 1 day, 0:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 9b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Fixed-Float | 744835 | 337975 | 151541 | 47559 | 30688 | 33028 | 231706 | 1577332
OTHER* | 959396 | 637400 | 165862 | 65775 | 241139 | 125969 | 98960 | 2294501
TOTAL | 1704231 | 975375 | 317403 | 113334 | 271827 | 158997 | 330666 | 3871833
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: 768114d1644846123-populating-a-list-sample
Sheet: Sheet1

Customer Invoice. Details will be input here. |  |  |  | List of what each item contains |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Picking note for staff to know what to prep for event.
Invoice
Item |  | Qty | Cost | Item | XL Vase | 50cm Vase | 10.5" Vase | 9" Vase | 7.5" Vase | 50cm Stem Vase | 40cm Stem Vase | 30cm Stem Vase | Branches | Trunk | Canopy Trunk | Log Slices | Globes | Floating Candles |  |  | Picking List
XL Candle Cluster | Silver Candles | 2 | £[NAME] | XL Candle Cluster | 1 | 3 | 3 |  | 6 |  |  |  |  |  |  |  |  | 13 |  |  | Item | Qty
Tree | White Blossom | 4 | £[NAME] | Tree |  |  |  |  |  |  |  |  | 10 | 1 |  | 1 | 4 |  |  |  | XL Vase | 2
Canopy Tree | White Blossom | 2 | £[NAME] | Canopy Tree |  |  |  |  |  |  |  |  | 20 |  | 1 |  |  |  |  |  | 50cm Vase | 6
Stemmed Candle Trio | Silver Candles | 2 | £[NAME] | Candle Trio |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 3 |  |  | 10.5" Vase | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5" Vase | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50cm Stem Vase | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40cm Stem Vase | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30cm Stem Vase | 2
 | Is it possible to automate the picking list from the data that’s on the invoice. *note* these will be on different sheets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Branches | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trunk | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Canopy Trunk | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Log Slices | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Globes | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Floating Candles | 32
Spreadsheet: 773439d1647866363-extracting-predecessor-as-a-list-data_updated
Sheet: Sheet1

Task ID | Task Name | Predecessor ID | Driving Ids | Driving Ids for Task 9 (Example 1) | Driving Ids for Task 9 (Example 2)
1 | Task 1
2 | Task 2 |  |  | 9 | 7
3 | Task 3 | 2 |  | 9 | 7
4 | Task 4 | 3
5 | Task 5 | 3
6 | Task 6 | 5
7 | Task 7 | 3 |  | 9 | 7
8 | Task 8 | 7 |  | 9
9 | Task 9 | 8 |  | 9
Spreadsheet: 732504d1620995795-sum-cells-by-font-or-cell-colour-without-vba-template
Sheet: Sheet1

 |  | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | Actual | Target | Difference
 |  | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 |  |  | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40 | 20 |  |  | 40 | 40 | 40 | 40 | 20
 |  |  |  |  |  |  |  |  |  |  | 25 | 25 | 12 | 15 |  | 40 | 40 | 25 | 25 | 12 |  |  | 25 | 25 | 25 | 25 | 12
 |  |  |  |  |  |  |  |  |  |  | 25 | 40 | 12 | 15 |  | 40 | 40 | 27 | 27 | 27 |  |  | 37 | 37 | 37 | 37 | 15
 |  |  |  |  |  |  |  |  |  |  | 35 | 35 | 35 |  |  | 35 | 35 |  |  |  |  |  | 15 | 15 | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  |  | 25 | 25 | 25 |  |  | 25 | 25 | 25 | 25 |  |  |  | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 20 |  | 20 | 20 | 20 | 20 | 20 |  |  | 20 | 20 | 20 | 20 | 20
UK |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
US |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  | 25 | 29 | 12 | 15 |  | 30 | 25 | 25 | 25 | 12 |  |  | 25 | 25 | 25 | 25 | 12
 |  |  |  |  |  |  |  |  |  |  | 25 | 14 |  | 15 |  | 30 | 25 | 25 | 25 |  |  |  |  | 25 | 25 | 25
 |  |  |  |  |  |  |  |  |  |  | 26 | 26 | 26 |  |  | 26 | 26 | 26 | 26 | 26 |  |  | 26 | 26 | 26 | 26 | 26
 |  |  |  |  |  |  |  |  |  |  | 23 | 23 |  |  |  | 23 | 23 | 23 | 23 | 23 |  |  | 23 | 23 | 23 | 23 | 23
 |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  | 20 | 20 | 20 |  |  |  |  | 20 | 20 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 |  | 15 | 15 | 15 | 15 | 15 |  |  | 15 | 15 | 15 | 15 | 15
UK
US
UK | Difference
US | Difference
Finising/Cleaning
 | [NAME]
 | [NAME]
 |  | US |  | UK
 |  | No Fin | Fin | No Fin | Fin
 |  | 25 |  | 32 | 30
 |  | 25 |  | 32 | 30
 |  | 20 |  | 30 | 30
 |  |  |  | 30
 |  |  |  | 25
 |  |  |  | 23 | 23
Spreadsheet: 814076d1674142787-formula-to-add-numbers-in-a-table-based-on-date-criteria-loan-amortization-schedules
Sheet: Long-Short Term

Period Ending | 2023-01-31 00:00:00
Number | Lender | Term | Rate | Payment | Pmt Day | Current Ending Balance | # Payments in 12 months | Short Term
46 | Hitachi Capital America Corp | 60 | 0.0495 | 784.2 | 20th |  |  |  | <--- Needs to be the principal payments from each table for the next 12 months after the date in B1 (or the current ending balance if there are less than 12 payments due)
60 | Valley National Bank | 48 | 0.0232 | 1205.48 | 9th
76 | Ally Bank | 60 | 0.0599 | 1139.29 | 17th
Spreadsheet: 672456d1586875714-need-one-formula-to-divide-the-sum-of-one-column-by-another-sample3
Sheet: Sheet1

Educational Content Domain Outcomes |  |  | Number of Eligible Individuals enrolled and receiving instruction in educational content domain |  |  |  | Number of Eligible Individuals with demonstrated improvement of skills in educational content domain |  |  |  | Number of eligible individuals who left program without an educational improvement
 |  |  | Program Year 2017 |  | Program Year 2018 |  | Program Year 2017 |  | Program Year 2018 |  | Program Year 2017 |  | Program Year 2018
Reading |  |  | 12 |  |  |  | 9
Writing |  |  | 15 |  |  |  | 11
Mathematics |  |  | 7 |  |  |  | 4
English Language Acquisition |  |  | exluded from calc |  |  |  | exluded from calc
Civics/Citizenship Education |  |  | exluded from calc |  |  |  | exluded from calc
Workforce Preparation Employability Skills |  |  | 23 |  |  |  | 13 |  |  |  |  |  |  |  |  |  | Goal
TOTALS
Spreadsheet: 796669d1663430959-how-to-display-remaining-values-referenced-in-the-row-associated-of-the-targeted-value-test4-1-
Sheet: Feuil1

Country | Bank | Code bank | Name agency | Other | Other 1 | Other 2 | Other 3 | Other 4 | Other 5 | Other 6 |  |  | Other 5
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba5 | azqffgds |  |  | daba11
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | [NAME] | azqffgds |  |  | daba12
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba7 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba8 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba9 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba10 | azqffgds
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
 | remained values
expected result
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
Spreadsheet: f17b2a58-a7f0-46e8-b5cf-42f4f261415e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
5407 | 28468 | Andras | Szabo | HUN | 102 | 00:17:14 | [NAME] | 00:23:27 | 00:01:20 | [NAME] | 1 | 01:08:56
Spreadsheet: phillip_m_love__30138__200007_OA
Sheet: SITHE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 5318516 | 22601449
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 7837335 | 31773568
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 13155851 | 54375017
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -880400 | -3908976 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -11784013 | -48497445
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 4150 | 16819
 | Total Purchases: |  | -12660263 | -52389602
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | -500230 | -1668074
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -20747 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | -520977 | -1668074
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 25389 | 108411.03
 |  |  | 0 | 0
23 | Fuel: |  | -4150 | -16819
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -15075
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -15075
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | -251442.4342999999
31 |  | Prior Month Book Balance | 0 | -2237873
 |  | Total MTM Income | 0 | -2489315.4343
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 2304927
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -188376
 |  | TOTAL INTRA-MTH
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: Q Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 28-01-2020 | pdf |  | 03-01) 30-03-2020 | pdf |  | 12-01) 23-12-2019 | pdf |  | 03-01) 30-03-2020 | pdf |  | 03-01) 30-03-2020 | pdf
 | 03-01) 03-03-2020 | pdf
Spreadsheet: 71898d1272568358-advanced-filtering-searching-for-a-unique-word-filter3
Sheet: Sheet1

 |  |  |  |  | Title
 |  |  |  |  | *harry*
Search words: | [NAME] | secrets |  |  | *secrets*
BookList:
ISBN | Title | Author
111 | [NAME]: Prisoner of Azkaban | [NAME]
222 | Streetwise | [NAME]
333 | [NAME] and the Chamber of Secrets | Rowling [NAME]
444 | Down the Rabbit Hole | [NAME]
555 | Life, the Universe and Everything | [NAME]
Spreadsheet: stacey_white__39145__5th floorplan 0130
Sheet: Turrets

Name | Location | Group
Schrab | 5224 | [NAME]
Benbow | 5229 | [NAME]
[NAME] | 5222 | [NAME]
[NAME] | 5218 | [NAME]
[NAME] | 5312 | NE. Log
[NAME] | 5318 | NE. Log
Gillespie | 5306 | NE. Log
[NAME] | 5362 | [NAME]
Mendel | 5337 | [NAME]
Sewell | 5514 | M&A
Comeaux | 5130 | Genco
Broussard | 5964 | Genco
Lavarell | 5955 | Genco
Lenartowicz | 5959 | Genco
Poppa | 5958 | Genco
Serio | 5957 | Genco
Spreadsheet: kate_symes__18824__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]
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
 | 2001-03-02 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 204.08 | 1930 | 128.66 | 1229
 | 2001-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880 | 233.33 | 777 | 144.63 | 726
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
 | 2001-02-17 00:00:00 |  | 282.14 | 224 | 221.43 | 112 | 230.67 | 1640 | 205.12 | 1180
 | 2001-02-16 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 251.75 | 3017 | 181.8 | 1576
 | 2001-02-15 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 391.66 | 5037 | 207.21 | 1058
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392 | 304.68 | 695 | 197.1 | 1165
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
 | 2001-02-11 00:00:00 |  | 150 | 160 | 140 | 600 | 141.19 | 3174 | 132.09 | 2803
 | 2001-02-10 00:00:00 |  | 153.75 | 320 | 115.46 | 1720 | 150.05 | 2068 | 161.43 | 828
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760 | 168.64 | 1070 | 117.98 | 945
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
Spreadsheet: andy_zipper__123__Broker & Exchange Detail 6-7-01
Sheet: BROKER DEAL SUMMARY

EnronOnline Broker Detail for 6/7/2001
Completed Transactions:
TODAY
Date | 2001-06-07 00:00:00
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 4 | 28 | 1266.25 | 1528.6 | 32 | 2794.85
Natsource LLC |  | 14 |  | 1365 | 14 | 1365
Power Merchants Group, LLC | 1 |  | 90 |  | 1 | 90
Amerex Natural Gas I, Ltd. | 1 |  | 57.5 |  | 1 | 57.5
Amerex Power, Ltd. |  | 23 |  | 2212 | 23 | 2212
Prebon Energy, Inc. |  | 1 |  | 0 | 1 | 0
Grand Total | 6 | 66 | 1413.75 | 5105.6 | 72 | 6519.35
**Waiting on Broker Fees for Prebon Energy, Inc's German Power Trade on 6/7/01
LTD
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 100 | 296 | 28380 | 23829.84 | 396 | 52209.84
Natsource LLC | 38 | 293 | 6208.5 | 27451 | 331 | 33659.5
Power Merchants Group, LLC | 13 |  | 1636.83 |  | 13 | 1636.83
Amerex Natural Gas I, Ltd. | 59 | 1 | 10098.9375 | 4 | 60 | 10102.9375
Amerex Power, Ltd. |  | 95 |  | 8649 | 95 | 8649
Prebon Energy, Inc. |  | 2 |  | 120 | 2 | 120
Grand Total | 210 | 687 | 46324.2675 | 60053.84 | 897 | 106378.1075
Failed Transactions:
TODAY
Date | 2001-06-07 00:00:00
FAILED TRANSACTION COUNT | Commodity
Broker | Power | Grand Total
APB Energy, Inc. | 3 | 3
Natsource LLC | 1 | 1
Amerex Power, Ltd. | 1 | 1
Grand Total | 5 | 5
LTD
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 43 | 42 | 85
Natsource LLC | 7 | 40 | 47
Power Merchants Group, LLC | 21 |  | 21
Amerex Power, Ltd. |  | 12 | 12
Amerex Natural Gas I, Ltd. | 6 |  | 6
Prebon Energy, Inc. | 1 |  | 1
Grand Total | 78 | 94 | 172
Spreadsheet: 782640d1654167529-counting-cells-up-to-a-value-excluding-some-sample-worksheet-attached-copy-vc-1
Sheet: Hot & Cold Spot (90.5°C for 10)

 | [NAME]
 | First
 | Second
 | Third
 | Espected Value | 15 | 14 | 18
 | Time Stamp | Probe 1 | Probe 2 | Probe 3 | Probe 4 | Probe 5 | Probe 6 | Probe 7 | Probe 8
 |  | 3 |  | 3
 |  | 4 |  | 3
 |  | 5 | 3 | 3
 |  | 6 | 4 | 3
 |  | 8 | 5 | 3
 |  | 12 | 6 | 4
 |  | 30 | 8 | 5
 |  | 50 | 12 | 6
 |  | 70 | 30 | 8
 |  | 90 | 50 | 12
 |  | 95 | 70 | 30
 |  | 90.5 | 90 | 50
 |  | 60 | 95 | 70
 |  | 50 | 90.5 | 90
 |  | 4 | 60 | 95
 |  | 3 | 3 | 90.5
 |  | 1 | 30 | 60
 |  | 6 | 20 | 3
 |  | 3 | 10 | 30
 |  | 4.5 | 6 | 20
 |  |  | 3 | 10
 |  |  | 4.5 | 6
 |  |  |  | 3
 |  |  |  | 4.5
Spreadsheet: 675610d1588366802-copy-data-between-sheets-having-same-col-names-but-not-col-numbers-hlookup
Sheet: Sheet1

Open Date | Close Date | Symbol | Action | Units/Lots | SL | TP | Open Price | Close Price | Commission | Swap | Pips
2020-05-01 11:01:00 |  |  | Deposit | 0.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2020-04-28 20:26:00 | 2020-04-29 04:33:00 | EURNZD | Buy | 0.09 | 1.77423 | 1.78277 | 1.78623 | 1.77423 | -0.31 | -0.82 | -120
2020-04-28 23:40:00 | 2020-04-29 01:20:00 | [NAME] | Buy | 0.03 | 1.23631 | 1.24257 | 1.24281 | 1.24257 | -0.12 | -0.23 | -2.4
2020-04-28 23:11:00 | 2020-04-29 01:16:00 | EURUSD | Buy | 0.03 | 1.07699 | 1.08227 | 1.08299 | 1.08227 | -0.1 | -0.23 | -7.2
2020-04-28 23:41:00 | 2020-04-29 00:05:00 | EURCHF | Buy | 0.03 | 1.05088 | 1.05516 | 1.05488 | 1.05521 | -0.1 | -0.06 | 3.3
2020-04-28 00:54:00 | 2020-04-28 01:55:00 | [NAME] | Sell | 0.03 | 1.24947 | 1.24258 | 1.24297 | 1.24258 | -0.12 | 0 | 3.9
2020-04-27 16:00:00 |  |  | Deposit | 0.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Open Date | Close Date | Symbol | Action | Units/Lots | SL | TP | Open Price |  | Close Price | Commission | Swap | Pips
2020-05-01 11:01:00 |  |  | Deposit | 0.01 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
2020-04-28 20:26:00 | 2020-04-29 04:33:00 | EURNZD | Buy | 0.09 | 1.77423 | 1.78277 | 1.78623 |  | 1.77423 | -0.31 | -0.82 | -120
2020-04-28 23:40:00 | 2020-04-29 01:20:00 | [NAME] | Buy | 0.03 | 1.23631 | 1.24257 | 1.24281 |  | 1.24257 | -0.12 | -0.23 | -2.4
2020-04-28 23:11:00 | 2020-04-29 01:16:00 | EURUSD | Buy | 0.03 | 1.07699 | 1.08227 | 1.08299 |  | 1.08227 | -0.1 | -0.23 | -7.2
2020-04-28 23:41:00 | 2020-04-29 00:05:00 | EURCHF | Buy | 0.03 | 1.05088 | 1.05516 | 1.05488 |  | 1.05521 | -0.1 | -0.06 | 3.3
2020-04-28 00:54:00 | 2020-04-28 01:55:00 | [NAME] | Sell | 0.03 | 1.24947 | 1.24258 | 1.24297 |  | 1.24258 | -0.12 | 0 | 3.9
2020-04-27 16:00:00 |  |  | Deposit | 0.01 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Tags | Open Date | Close Date | Symbol | Action | Units/Lots | SL | TP | Commission | Swap | Pips
14 | 2020-05-01 11:01:00 |  |  | Deposit | 0.01 | 0 | 0 | 0 | 0 | 0
16 | 2020-04-28 20:26:00 | 2020-04-29 04:33:00 | EURNZD | Buy | 0.09 | 1.77423 | 1.78277 | -0.31 | -0.82 | -120
12 | 2020-04-28 23:40:00 | 2020-04-29 01:20:00 | [NAME] | Buy | 0.03 | 1.23631 | 1.24257 | -0.12 | -0.23 | -2.4
29 | 2020-04-28 23:11:00 | 2020-04-29 01:16:00 | EURUSD | Buy | 0.03 | 1.07699 | 1.08227 | -0.1 | -0.23 | -7.2
32 | 2020-04-28 23:41:00 | 2020-04-29 00:05:00 | EURCHF | Buy | 0.03 | 1.05088 | 1.05516 | -0.1 | -0.06 | 3.3
12 | 2020-04-28 00:54:00 | 2020-04-28 01:55:00 | [NAME] | Sell | 0.03 | 1.24947 | 1.24258 | -0.12 | 0 | 3.9
14 | 2020-04-27 16:00:00 |  |  | Deposit | 0.01 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 103960d1301592090-assistance-with-excel-data-example
Sheet: Sheet1

Number | ID | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 987 | 1 |  |  | 1 |  |  |  |  |  | 1
2 | 988 | 1 | 1 |  |  | 1 |  |  |  | 1
3 | 989 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 737746d1624567149-extract-data-records-from-table-extract-data-records-from-table
Sheet: Sheet1

A | B | C | D | E | F | G | RESULT FROM FORMULA
 | NOT AVAILABLE IN STOCK |  |  | CUSTOMER NOT ALLOWED |  |  | https://DQNvjcFnyQmPTraZr1ilcX1YufI%3D
 | NOT AVAILABLE IN STOCK |  |  | CUSTOMER NOT ALLOWED |  |  | https://2BQdlVuQOlqEBtG7xOWoGQX4g%3D
https://DQNvjcFnyQmPTraZr1ilcX1YufI%3D | CUSTOMER NOT ALLOWED | https://ZGieS2Y31Z07CY1MaJwYslLsHeY%3D |  | CUSTOMER NOT ALLOWED |  |  | https://ZGieS2Y31Z07CY1MaJwYslLsHeY%3D
 | CUSTOMER NOT ALLOWED | https://6AZsB8lOJQUwVKv0dwnfxIxWM3M%3D |  | CUSTOMER NOT ALLOWED |  |  | https://6AZsB8lOJQUwVKv0dwnfxIxWM3M%3D
 | CUSTOMER NOT ALLOWED |  | https://2F719t6oCtxoREwIoWcgfNN9i8%3D | CUSTOMER NOT ALLOWED |  | https://ZecDutblQKG%2BF6QyxaUjQ5SVF5E%3D | https://2F719t6oCtxoREwIoWcgfNN9i8%3D
 | CUSTOMER NOT ALLOWED |  |  | CUSTOMER NOT ALLOWED |  |  | https://ZecDutblQKG%2BF6QyxaUjQ5SVF5E%3D
https://2BQdlVuQOlqEBtG7xOWoGQX4g%3D | CUSTOMER NOT ALLOWED |  |  | CUSTOMER NOT ALLOWED
 | CUSTOMER NOT ALLOWED |  |  | CUSTOMER NOT ALLOWED
 | CUSTOMER NOT ALLOWED |  |  | CUSTOMER NOT ALLOWED
 |  |  |  |  |  |  |  | [NAME] to extract all data records from the Table (A2:G10), Starting with the text "http://"