tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9ba0fa0a-7794-4181-ab0c-a243bd64c060
Sheet: Sheet1

DIV 1AA CIF-SS/FORD 2013 GIRLS BASKETBALL CHAMPIONSHIPS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
1ST ROUND |  | 2ND ROUND | QTR FINALS | SEMIFINALS | FINALS
SAT., FEB. 16 |  | WED., FEB. 20 | SAT., FEB. 23 | TUES., FEB. 26 | WED-SAT
7:00 P.M. |  | 7:00 P.M. | 7:00 P.M. | 7:00 P.M. | FEB 27-MAR 2
*[NAME] (1) | Trinity #1
 |  | [NAME]
Wilson/LB | Moore #4 | 89-31
*Silverado | [NAME] #1 | Thurs., 2/21        F | *[NAME]
 |  | *Silverado | 78-25
Knight (16) | Golden #2 | 66-50
*Rialto | San Andreas #1 |  |  | [NAME]
 |  | *Centennial/Cor | F | 56-39 | PLEASE REPORT SCORES TO:
Centennial/Cor (9) | Big VIII #2 | 78-48 |  |  | www.cifsshome.org
*[NAME]/V (8) | Foothill #1T | 6:00 p.m. | Centennial/Cor |  | Home Campus
5:00 p.m. |  | [NAME]/V | 60-41
Pacifica/Oxnard | Pacific View #2 | 64-34
*[NAME] (5) | Baseline #1 |  | Wed., 2/27 |  | [NAME]
 |  | [NAME] |  |  | 73-72 (OT)
Roosevelt | Big VIII At-Lg | 83-33
*[NAME] (12) | Sunset #2 | F | [NAME]
 |  | *Edison | 79-50
[NAME] | Sierra #2T | 47-41
*[NAME] (13) | Century #1T |  | 6:00 p.m. | *Etiwanda
6:00 p.m. |  | *Great Oak | F | 60-50
[NAME] | Southwestern #3 | 58-48
*Poly/LB (4) | Moore #1 | 6:00 p.m. | *Poly/LB
 |  | Poly/LB | 65-26
Downey | [NAME] Vly #3 | 66-33
*Santiago/Cor (3) | Big VIII #1
 |  | *Santiago/Cor | Friday, March 1 - 8:45 p.m. |  |  | Santiago/Cor
[NAME] | [NAME] At-Lg | 70-25 |  | Anaheim Arena |  | CHAMPION
*[NAME] (14) | South Coast #1 | F | *Santiago/Cor |  |  | 70-65
 |  | [NAME] | 89-61
Diamond Bar | Hacienda #3T | 47-22
*[NAME] (11) | Golden #1 |  |  | Santiago/Cor
 |  | Highland | F | 78-63
West Ranch | Foothill #3 | 54-45
*Millikan (6) | Moore #2 | F | Millikan
 |  | *Millikan | 78-45
[NAME] | Baseline #2 | 73-19
*Rancho Verde (7) | Inland Valley #1 |  | @ La Habra HS |  | Santiago/Cor
 |  | *Rancho Verde |  |  | 53-41
Upland | Baseline #3 | 48-34
*Los Alamitos (10) | Sunset #1 | F | *Rancho Verde
 |  | Los Alamitos | 49-43
King, [NAME] | Big VIII #3 | 54-50
*Arcadia (15) | Pacific #1T |  |  | *Troy
 |  | Arcadia | F | 66-26
Summit | Sunkist #2 | 85-52
*Troy (2) | Freeway #1 | F | Troy
 |  | *Troy | 59-18
Chaparral | Southwestern At-Lg | 60-27
*Denotes Host Team
2013 GIRLS BASKETBALL DIVISION 1AA
Spreadsheet: 775750d1649285987-trying-to-figure-out-the-formula-to-skip-over-blank-cells-but-add-last-five-and-divide-test-sheet
Sheet: Scores

 | 1 | 2 | 3 | 4 | 5 | 2022-05-10 00:00:00 | 2022-05-17 00:00:00 | 2022-05-24 00:00:00 | 2022-05-31 00:00:00 | 2022-06-07 00:00:00 | 2022-06-14 00:00:00 | 2022-06-21 00:00:00 | 2022-06-28 00:00:00 | 2022-07-05 00:00:00 | 2022-07-12 00:00:00 | 2022-07-19 00:00:00 | 2022-07-26 00:00:00 | 2022-08-02 00:00:00 | 2022-08-09 00:00:00 | 2022-08-16 00:00:00
Score | 48 | 46 | 40 | 41 | 39 | 32 | 32 | 32 |  | 36 |  |  |  |  |  |  |  | 36
Average
Spreadsheet: 849380d1699892136-formula-to-workout-the-total-margin-from-a-table-with-gross-amounts-sample-report-reverse-calculation
Sheet: Sheet1

 |  |  |  | Gross Amount |  | Margin  rate | Net Amount | Margin
 |  |  |  | 150000 |  | 0.2
 |  |  |  | 120000 |  | 0.2
 |  |  |  | 240000 |  | 0.2
 |  |  |  | 80000 |  | 0.05
 |  |  | Total
 |  |  | Margin
 |  |  | Net Amount
Spreadsheet: 95899d1295426599-conditional-formatting-based-on-formula-not-cell-value-cond-format-example
Sheet: Sheet1

 | 2011-01-19 00:00:00
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
Item | Description | 2011-01-03 00:00:00 | 2011-01-10 00:00:00 | 2011-01-17 00:00:00 | 2011-01-24 00:00:00 | 2011-01-31 00:00:00
160093 | Bearing Ret | 0 | 0 | 0 | 0 | 0
 | Del'd
 | Weekly Balance | 0 | 0 | 0 | 0 | 0
 | Cume Balance | 0 | 0 | 0 | 0 | 0
Spreadsheet: theresa_staab__39630__Citation Statement
Sheet: 2nd Revised Stmt

 |  |  |  | BEAR PAW ENERGY
 |  |  |  | 1625 Broadway, Suite 2300
 |  |  |  | Denver, CO  80202
 |  |  |  | (303)626-8293
 |  | ANTELOPE VALLEY GAS BALANCING STATEMENT
Producer: | Citation Oil & Gas Corp.
 | 8223 Willow Place South
 | Houston, TX  77070-5623
 | Gas | Allocated | Allocated | Gas | Gas | Total | Ft. Union | TCGS | Cumulative
 | Received into | Receipts into | Receipts Into | Delivered | Delivered | Gas | Monthly | Monthly | MMBtu  Due
 | Antelope Valley | Ft. Union | TCGS | Ft. Union | TCGS | Delivered | Imbalance | Imbalance | Producer
 | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | MMBtu | (Bear Paw)
2000-01-01 00:00:00 | 8894 | 8894 |  | 7672 | 0 |  |  | 0
2000-02-01 00:00:00 | 19564 | 19564 |  | 18974 | 0 |  |  | 0
2000-03-01 00:00:00 | 25596 | 25596 |  | 25258 | 0 |  |  | 0
2000-04-01 00:00:00 | 25925 | 25925 |  | 28500 | 0 |  |  | 0
2000-05-01 00:00:00 | 27362 | 27362 |  | 36727 | 0 |  |  | 0
2000-06-01 00:00:00 | 26886 | 26886 |  | 19683 | 0 |  |  | 0
2000-07-01 00:00:00 | 25280 | 25280 |  | 32488 | 0 |  |  | 0
2000-08-01 00:00:00 | 34949 | 24716 | 10233 | 23657 | 10233
2000-09-01 00:00:00 | 28222 | 28222 | 0 | 30480 | 0 |  |  | 0
2000-10-01 00:00:00 | 29968 | 29968 | 0 | 28062 | 0 |  |  | 0
2000-11-01 00:00:00 | 27148 | 27148 | 0 | 25116 | 0 |  |  | 0
2000-12-01 00:00:00 | 25132 | 0 | 25132 | 0 | 27646
Rev. Dec. 00 | 25231 | 0 | 25231 | 0 | 27646 |  | 0
2001-01-01 00:00:00 | 20613 | 0 | 20613 | 0 | 23699
2001-02-01 00:00:00 | 18080 | 0 | 18080 | 0 | 14824 |  | 0
2001-03-01 00:00:00 | 19713 | 0 | 19713 | 0 | 14352 |  | 0
2001-04-01 00:00:00 | 19457 | 0 | 19457 | 0 | 0 |  | 0
To be taken care of by [NAME] per agreement with [NAME]!
Spreadsheet: 724032d1615992558-matching-multiple-criteria-rate-card-test
Sheet: Delivery list

Grantham | C |  |  |  |  |  |  |  | Band | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
South Bank | E |  |  |  |  |  |  |  | A | 70.7 | 54.49 | 52.87 | 49.66 | 43.26 | 36.85 | 32.05 | 28.83 | 25.63 | 24.03
Leeming Bar | E |  |  |  |  |  |  |  | B | 81.7 | 67.29 | 64.09 | 57.69 | 54.49 | 48.06 | 41.65 | 36.85 | 33.64 | 32.05
Ellesmere | C |  |  |  |  |  |  |  | C | 86.42 | 72.1 | 68.9 | 64.09 | 59.28 | 52.87 | 48.06 | 43.26 | 40.05 | 36.85
[NAME] | D |  |  |  |  |  |  |  | D | 91.14 | 76.9 | 73.71 | 68.9 | 65.69 | 60.88 | 54.49 | 51.25 | 46.47 | 43.26
Tunstead | BVS |  |  |  |  |  |  |  | E | 97.42 | 83.31 | 78.51 | 75.3 | 72.1 | 65.69 | 62.5 | 57.69 | 52.87 | 48.06
Peterborough | A |  |  |  |  |  |  |  | F | 106.86 | 102.55 | 97.73 | 92.93 | 88.12 | 78.51 | 70.5 | 64.09 | 59.28 | 54.49
Evesham | C |  |  |  |  |  |  |  | G | 122.55 | 120.16 | 113.75 | 107.35 | 102.55 | 89.72 | 80.12 | 73.71 | 67.29 | 60.88
Chesterfield | C |  |  |  |  |  |  |  | H | 146.12 | 137.78 | 131.37 | 123.36 | 115.36 | 105.74 | 94.53 | 84.92 | 76.9 | 70.5
Carlisle | E |  |  |  |  |  |  |  | J | 157.13 | 144.19 | 136.18 | 132.97 | 128.18 | 120.16 | 107.35 | 96.14 | 88.12 | 80.12
Swansea | D |  |  |  |  |  |  |  | K | 180.69 | 160.21 | 152.21 | 144.19 | 136.18 | 128.18 | 120.16 | 108.94 | 97.73 | 88.12
Southall | C |  |  |  |  |  |  |  | BVS | 165 | 165 | 165 | 165 | 165 | 165 | 165 | 165 | 165 | 165
[NAME] (Norish) | C
Grimsby | C
Heywood | C
Ellingham | A
[NAME] (Great Food Ltd) | C
Newark | C
Carlisle | E
[NAME] | D
Bristol | C
Cardiff | D
[NAME] | A
Portadown | J
Sheffield | B
Elm | A
Lough Egish | J
Naas (QK Cold Store) | J
Newport | D
Spreadsheet: 777407d1650371894-transfer-data-from-sheet-1-to-sheet-2-using-formula-formula-aligw
Sheet: Sheet2

Column1 | Column2 | Column3
 |  |  |  | Expected
 |  |  |  | This is what I am getting if I drag the formula from top to bottom
Spill: |  |  |  | As array:
 | Month | Target |  |  | Month | Target
Jan | 0 | 2222 |  | Jan | 0 | 2222
Feb | 2481.389578163772 | 2222 |  | Feb | 2481.389578163772 | 2222
Mar | 2923.976608187134 | 2222 |  | Mar | 2923.976608187134 | 2222
Apr | 9036.144578313253 | 2222 |  | Apr | 9036.144578313253 | 2222
May | 2808.988764044944 | 2222 |  | May | 2808.988764044944 | 2222
Jun | 0 | 2222 |  | Jun | 0 | 2222
Jul | 5305.039787798408 | 2222 |  | Jul | 5305.039787798408 | 2222
Spreadsheet: jonathan_mckay__16951__NewWorld-2
Sheet: Sheet1

New World Products
 | Transco ZN 6 | Tetco M 3 | Dominion | TCO | Col Gulf | [NAME] | Hhub | Sonat la | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Tgt- Sl | [NAME]
Term | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis | Basis
Financial ROM
First 15days
Last 15days
Jan | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Feb | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Mar | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Jan-Mar | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Apr02-Oct02 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Nov02-Mar03 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Apr03-Oct03 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes
Spreadsheet: 74214d1274789951-tables-references-calculations-components-v2
Sheet: components

 |  | Flashlight | Components needed to build X units
 |  | Units | Blood | Sweat | Tears | Money
 |  | 1 | 33 | 55 | 66 | 12
 |  | 2 | 62 | 72 | 110 | 17
 |  | 3 | 91 | 89 | 154 | 22
 |  | 4 | 120 | 106 | 198 | 27
 |  | 5 | 149 | 123 | 242 | 32
 |  | 6 | 178 | 140 | 286 | 37
 |  | 7 | 207 | 157 | 330 | 42
 |  | 8 | 236 | 174 | 374 | 47
 |  | 9 | 265 | 191 | 418 | 52
 |  | 10 | 294 | 208 | 462 | 57
 |  | 11 | 323 | 225 | 506 | 62
 |  | 12 | 352 | 242 | 550 | 67
 |  | 13 | 381 | 259 | 594 | 72
 |  | 14 | 410 | 276 | 638 | 77 |  |  |  | Moped | Components needed to build X units
 |  | 15 | 439 | 293 | 682 | 82 |  |  |  | Units | Blood | Sweat | Tears | Money
 |  | 16 | 468 | 310 | 726 | 87 |  |  |  | 1 | 33 | 55 | 66 | 12
 |  | 17 | 497 | 327 | 770 | 92 |  |  |  | 2 | 62 | 72 | 110 | 17
 |  | 18 | 526 | 344 | 814 | 97 |  |  |  | 3 | 91 | 89 | 154 | 22
 |  | 19 | 555 | 361 | 858 | 102 |  |  |  | 4 | 120 | 106 | 198 | 27
 |  | 20 | 584 | 378 | 902 | 107 |  |  |  | 5 | 149 | 123 | 242 | 32
 |  | 21 | 613 | 395 | 946 | 112 |  |  |  | 6 | 178 | 140 | 286 | 37
 |  | 22 | 642 | 412 | 990 | 117 |  |  |  | 7 | 207 | 157 | 330 | 42
 |  | 23 | 671 | 429 | 1034 | 122 |  |  |  | 8 | 236 | 174 | 374 | 47
 |  | 24 | 700 | 446 | 1078 | 127 |  |  |  | 9 | 265 | 191 | 418 | 52
 |  | 25 | 729 | 463 | 1122 | 132 |  |  |  | 10 | 294 | 208 | 462 | 57
 |  | 26 | 758 | 480 | 1166 | 137 |  |  |  | 11 | 323 | 225 | 506 | 62
 |  | 27 | 787 | 497 | 1210 | 142 |  |  |  | 12 | 352 | 242 | 550 | 67
 |  | 28 | 816 | 514 | 1254 | 147 |  |  |  | 13 | 381 | 259 | 594 | 72
 |  | 29 | 845 | 531 | 1298 | 152 |  |  |  | 14 | 410 | 276 | 638 | 77
 |  | 30 | 874 | 548 | 1342 | 157 |  |  |  | 15 | 439 | 293 | 682 | 82
 |  | 31 | 903 | 565 | 1386 | 162 |  |  |  | 16 | 468 | 310 | 726 | 87
 |  | 32 | 932 | 582 | 1430 | 167 |  |  |  | 17 | 497 | 327 | 770 | 92
 |  | 33 | 961 | 599 | 1474 | 172 |  |  |  | 18 | 526 | 344 | 814 | 97
 |  |  |  |  |  |  |  |  |  | 19 | 555 | 361 | 858 | 102
 |  |  |  |  |  |  |  |  |  | 20 | 584 | 378 | 902 | 107
 |  |  |  |  |  |  |  |  |  | 21 | 613 | 395 | 946 | 112
 |  |  |  |  |  |  |  |  |  | 22 | 642 | 412 | 990 | 117
 |  |  |  |  |  |  |  |  |  | 23 | 671 | 429 | 1034 | 122
 |  |  |  |  |  |  |  |  |  | 24 | 700 | 446 | 1078 | 127
 |  |  |  |  |  |  |  |  |  | 25 | 729 | 463 | 1122 | 132
 |  |  |  |  |  |  |  |  |  | 26 | 758 | 480 | 1166 | 137
 |  |  |  |  |  |  |  |  |  | 27 | 787 | 497 | 1210 | 142
 |  |  |  |  |  |  |  |  |  | 28 | 816 | 514 | 1254 | 147
 |  |  |  |  |  |  |  |  |  | 29 | 845 | 531 | 1298 | 152
 |  |  |  |  |  |  |  |  |  | 30 | 874 | 548 | 1342 | 157
Spreadsheet: stacey_white__39004__Power Global Meter PMI 2002 Plan Capital
Sheet: Project Assumption WS

[NAME] | Project Name | Start Date - Month | Start Date - Year | Est Complete Date - Month | Est Complete Date - Year | Project Type (C=[NAME], E=Exp, M= Main) | Hardware (.90) | Software (.91) | .92 [NAME] - within your dept | .92 Enron Labor - Infrastructure | .92 [NAME] - Other Dev | .93 Contractor Expenses | .94 Other Expenses | Total Est Proj Costs | Comments / Assumptions | ENA % | EIM % | EGM % | Corp % | EBS % | EES % | ETS % | E-OPS % | Infra % | [NAME] | E-COM % | OTHER % | TOTAL %
 | [NAME] and PMI Data |  |  |  |  | C | 75000 | 20000 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (From [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Sum of Projects)
Note:  This worksheet does not link into the other spreadsheets. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diff
This worksheet was created to assist in budgeting at the project level.  Please
note the following cost elements equal the above cost types:
Cost Type | Cost Element
.90 | 52504500
.91 | 52504500
.92 | 52000500
.93 | 52507400
.94 | 54005000
Spreadsheet: 102385d1300325851-index-match-to-reformat-data-reorgdatav3
Sheet: Instructions

Today, 09:13 PM |  |  |  |  |  |  |  |  |  |  | Today, 08:53 PM
ReorgData multiple Tracker ws LR LC Count rng - Staci - EF768143 - SDG13.xls |  |  |  |  |  |  |  |  |  |  | [NAME]
Registered User   Join Date: 05 Mar 2011 |  |  |  |  |  |  |  |  |  |  | Re: index Match to reformat data
Location: Savannah, GA |  |  |  |  |  |  |  |  |  |  | Do you want the macro to work on all worksheets in your workbook?
MS Office Version:Excel 2003 (work), 2010 (home) |  |  |  |  |  |  |  |  |  |  | No
Posts: 7 |  |  |  |  |  |  |  |  |  |  | Or, just a selection of some of the worksheets?
index Match to reformat data |  |  |  |  |  |  |  |  |  |  | Yes
[NAME] |  |  |  |  |  |  |  |  |  |  | If so, what is the logic to just pick some of the worksheets?
I have several trackers that production employees fill out daily, |  |  |  |  |  |  |  |  |  |  | still thinking about that one...lol
that are in an ugly format for data anaylsis, but is convenient for their daily use. |  |  |  |  |  |  |  |  |  |  | We could run the macro on all worksheets that begin with Tracker.
I was wondering if someone could help me figure out a way to get the information into the format that I would like. |  |  |  |  |  |  |  |  |  |  | I could make this scenerio work and rename the worksheets to say "Trackerx", "Trackerxx", "Trackerxxx",etc.
I would like the data to show in columns: |  |  |  |  |  |  |  |  |  |  | Do you want the Final Format worksheet to include all the data from the other worksheets?
Dates |  |  |  |  |  |  |  |  |  |  | Trick Question: Well, Yes from all the worksheets that will start with Tracker
Last Name |  |  |  |  |  |  |  |  |  |  | Will this macro, just pull the information once or will it duplicate the data if the macro is reran?
First Name |  |  |  |  |  |  |  |  |  |  | Meaning today I run the macro, it will format the data, how it is currently being done.
Quantity |  |  |  |  |  |  |  |  |  |  | Tomorrow I rerun the macro the only difference is it will basically reset worksheet "Final Format",
Hours |  |  |  |  |  |  |  |  |  |  | and give me the current information, correct? If so that would be brilliant.
Avg |  |  |  |  |  |  |  |  |  |  | Or will it duplicate the previous information, in addition to getting the current data? That would not be good.
I am going to show the workbook, exactly as the Tracker is formatted, |  |  |  |  |  |  |  |  |  |  | Thanks for you help!
then there is an example of the format that I would like to get all the data.
I was thinking, maybe I could have this "Final Format" sheet in each workbook, but I am not sure.
Any ideas would be appreciated.
Thanks,
Staci
Date
Last Name
First Name
Quantity
Hours
AVG.
Spreadsheet: 226551d1365439384-multi-conditionals-based-on-overtime-weekends-and-hourly-minimums-proto-2
Sheet: Main

Date: |  | 2013-04-06 00:00:00
DAY 1 |  | Start | Finish | Travel | Lunch | Regular | Overtime | Total | X | Y | Z
 |  | 09:00:00 | 12:30:00 | 01:00:00 | 00:30:00
Spreadsheet: 149893d1334175308-excel-2007-sumproduct-across-multiple-worksheets-value-error-sample
Sheet: January

 | 100 | 101 | 100 | 101 | 104 | 103
Fred | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 2 | 2 | 2 | 2 | 2 | 2
Darry | 3 | 3 | 3 | 3 | 3 | 3
[NAME] | 4 | 4 | 4 | 4 | 4 | 4
Susi | 5 | 5 | 5 | 5 | 5 | 5
[NAME] | 6 | 6 | 6 | 6 | 6 | 6
Spreadsheet: 746967d1631141810-calculate-number-of-tickets-per-month-and-charge-a-certain-rate-if-it-exceeds-a-threshold-book3
Sheet: Sheet1

TaskID | Date | Ticket Title | Ticket Count per Month per Task | Month Helper | Desired Result - if less than 5 tickets per month per task -> $10, if more than 5 -> all tickets for that task for that month are $20
Id1 | 2021-01-01 00:00:00 | Ticket 1 |  |  | 20
Id1 | 2021-01-02 00:00:00 | Ticket 2 |  |  | 20
Id1 | 2021-01-03 00:00:00 | Ticket 3 |  |  | 20
Id1 | 2021-01-04 00:00:00 | Ticket 4 |  |  | 20
Id1 | 2021-01-05 00:00:00 | Ticket 5 |  |  | 20
Id1 | 2021-01-05 00:00:00 | Ticket 6 |  |  | 20
Id1 | 2021-01-07 00:00:00 | Ticket 7 |  |  | 20
Id1 | 2021-01-08 00:00:00 | Ticket 8 |  |  | 20
Id1 | 2021-01-09 00:00:00 | Ticket 9 |  |  | 20
Id1 | 2021-01-10 00:00:00 | Ticket 10 |  |  | 20
Id1 | 2021-02-01 00:00:00 | Ticket 11 |  |  | 10
Id1 | 2021-02-02 00:00:00 | Ticket 12 |  |  | 10
Id1 | 2021-02-03 00:00:00 | Ticket 13 |  |  | 10
Id2 | 2021-02-15 00:00:00 | Ticket 14 |  |  | 10
Id2 | 2021-02-16 00:00:00 | Ticket 15 |  |  | 10
Spreadsheet: 1c079e99-bd23-4859-8156-0b6b79fc88ad
Sheet: Instruments

 | Instruments
UOM |  | Manufacturer | PART NUMBER | PRICE
EA | T7208 Phones | Nortel | NT8B26AABA | 126
EA | T7216E Phones | Nortel | NT8B27JAAB | 147
EA | KIM 24 extenders for above 7216E |  |  | 189
EA | Analog feature sets single line | [NAME] | 220300VBA27S | 40.96400000000001
EA | Analog feature sets dual line | [NAME] | 220500VBA27S | 50.52600000000002
EA | Head sets (wireless) for above sets | Plantronics | CS55 | 223.692
EA | Head sets (wired) for above sets | Plantronics | H171 | 79.38
EA | Head sets (wireless) | Plantronics | CS55 | 223.692
EA | Head sets (wired) | Plantronics | H171 | 79.38
EA | Wired/wireless conference phones | Telematrix | 095501 | 270.06
EA | Cordless headsets for various instruments | Plantronics | SAVI W740 | 288.6660000000001
EA | ISDN telephone S/T interface 10 botton | TeoTech | 6210T | 389.3120000000001
EA | ISDN telephone S/T interface 20 botton | TeoTech | 6220T | 487.8720000000001
EA | ISDN telephone U interface 20 botton | TeoTech | 6220U | 612.3040000000002
EA | ISDN telephone U interface 10 botton | TeoTech | 6210U | 529.76
Spreadsheet: 587348d1534969066-conditional-formula-based-on-sales-amount-jtakwformula-bonus2
Sheet: Sheet2

 |  |  |  | Criteria : |  |  | Comm. | Delta | Bonus
 |  |  |  | Sales amount | 0 | 500000 | 0 | 0 | Less than 500k - 0%
 |  |  |  | Greater than 500k and upto  750K | 0 | 750000 | 0.015 | 0.015 | Greater than 500k and upto  750K - 1.5%
 |  |  |  | Greater than 750k and upto  1M | 750000 | 1000000 | 0.02 | 0.005 | First 750K = 1.5%, Next 250k  - 2%
 |  |  |  | Greater than 1M and upto 2M | 1000000 | 2000000 | 0.03 | 0.01 | First 750K = 1.5%, upto 1M Next 250K = 2% ; upto Next 1M=3%
 |  |  |  | Greater than 3M | 2000000 |  | 0.05 | 0.02 | First 750K = 1.5%, upto 1M Next 250K = 2% ; upto Next 1M=3% ; Next =5%
Bonus Rate based on Sales
Input | Input | [NAME] |  | Example of 1,350,000
[NAME] | Sales amount | Bonus Amount |  | Sales | Rate | Bonus
Sales 1 | 560000 |  |  | 750000 | 0.015
Sales 2 | 750001 |  |  | 250000 | 0.02
Sales 3 | 795000 |  |  | 350000 | 0.03
Sales 4 | 2300000 |  | <-Correct
Sales 5 | 3500000
Sales 6 | 1350000
Sales 7 | 500000 |  |  | Example of 2,300,000
 |  |  |  | Sales | Rate | Bonus
 |  |  |  | 750000 | 0.015
 |  |  |  | 250000 | 0.02
 |  |  |  | 1300000 | 0.03 |  | <-Incorrect
 |  |  |  |  |  |  | <-Incorrect
 |  |  |  | Example of 3,500,000
 |  |  |  | Sales | Rate | Bonus
 |  |  |  | 750000 | 0.015
 |  |  |  | 250000 | 0.02
 |  |  |  | 1000000 | 0.03
 |  |  |  |  | 0.05
Spreadsheet: andy_zipper__798__Broker & Exchange Detail 10-26-01 EM
Sheet: BROKER DEAL SUMMARY

EnronOnline Broker Detail for 10/26/2001
Completed Transactions:
TODAY
DATE | 2001-10-26 00:00:00
 | COMM | Data
 | US POWER |  | NA GAS |  | CONTINENTAL POWER |  | Total DEAL COUNT | Total FEE SAVINGS
Broker | DEAL COUNT | FEE SAVINGS | DEAL COUNT | FEE SAVINGS | DEAL COUNT | FEE SAVINGS
APB Energy, Inc. | 13 | 668 |  |  |  |  | 13 | 668
Natsource LLC | 3 | 333 |  |  |  |  | 3 | 333
Amerex Natural Gas I, Ltd. |  |  | 3 | 1962.5 |  |  | 3 | 1962.5
Amerex Power, Ltd. | 14 | 1108 |  |  |  |  | 14 | 1108
Prebon [NAME] (UK) Ltd |  |  |  |  | 2 | 16.56 | 2 | 16.56
GFI EnergyNet LLC | 5 | 772 |  |  |  |  | 5 | 772
Grand Total | 35 | 2881 | 3 | 1962.5 | 2 | 16.56 | 40 | 4860.06
LTD (First Trade March 28, 2001)
 | COMM | Data
 | US POWER |  | NA GAS |  | CONTINENTAL POWER |  | UK GAS |  | UK COAL |  | US COAL |  | CONTINENTAL GAS |  | Total DEAL COUNT | Total FEE SAVINGS
Broker | DEAL COUNT | FEE SAVINGS | DEAL COUNT | FEE SAVINGS | DEAL COUNT | FEE SAVINGS | DEAL COUNT | FEE SAVINGS | DEAL COUNT | FEE SAVINGS | DEAL COUNT | FEE SAVINGS | DEAL COUNT | FEE SAVINGS
APB Energy, Inc. | 1737 | 122624.84 | 349 | 94975.5 |  |  |  |  |  |  |  |  |  |  | 2086 | 217600.34
Natsource LLC | 873 | 91206 | 121 | 15661.5 |  |  |  |  |  |  | 1 | 3750 |  |  | 995 | 110617.5
Power Merchants Group, LLC |  |  | 45 | 3106.515 |  |  |  |  |  |  |  |  |  |  | 45 | 3106.515
Amerex Natural Gas I, Ltd. | 1 | 4 | 246 | 56839.2845 |  |  |  |  |  |  |  |  |  |  | 247 | 56843.2845
Amerex Power, Ltd. | 1594 | 240574 |  |  |  |  |  |  |  |  |  |  |  |  | 1594 | 240574
Prebon Energy, Inc. | 3 | 256 |  |  | 1 | 0 |  |  |  |  |  |  |  |  | 4 | 256
Prebon [NAME] (UK) Ltd |  |  |  |  | 101 | 17007.99 |  |  |  |  |  |  |  |  | 101 | 17007.99
Natsource Tullett Europe Limited | 1 | 3.3736 |  |  | 71 | 15717.22560000001 | 28 | 31047.66250000001 | 6 | 5077.6 |  |  | 4 | 3278.7175 | 110 | 55124.57919999999
GFI EnergyNet LLC | 292 | 67876.8 |  |  |  |  |  |  |  |  |  |  |  |  | 292 | 67876.8
Grand Total | 4501 | 522545.0135999999 | 761 | 170582.7994999999 | 173 | 32725.21559999999 | 28 | 31047.66250000001 | 6 | 5077.6 | 1 | 3750 | 4 | 3278.7175 | 5474 | 769007.0087000001
Failed Transactions:
TODAY
Date | 2001-10-26 00:00:00
FAILED TRANSACTION COUNT | COMM
Broker | US POWER | CONTINENTAL POWER | Grand Total
APB Energy, Inc. | 2 |  | 2
Amerex Power, Ltd. | 2 |  | 2
Prebon [NAME] (UK) Ltd |  | 3 | 3
GFI EnergyNet LLC | 1 |  | 1
Grand Total | 5 | 3 | 8
LTD
FAILED TRANSACTION COUNT | COMM
Broker | US POWER | NA GAS | CONTINENTAL POWER | UK GAS | UK COAL | US COAL | Grand Total
APB Energy, Inc. | 230 | 172 |  |  |  |  | 402
Natsource LLC | 128 | 18 |  |  |  | 2 | 148
Power Merchants Group, LLC |  | 47 | 1 |  |  |  | 48
Amerex Power, Ltd. | 149 |  |  |  |  |  | 149
Amerex Natural Gas I, Ltd. |  | 32 |  |  |  |  | 32
Prebon Energy, Inc. | 1 | 1 |  |  |  |  | 2
Prebon [NAME] (UK) Ltd |  |  | 41 |  |  |  | 41
Natsource Tullett Europe Limited |  |  | 28 | 9 | 7 |  | 44
GFI EnergyNet LLC | 50 |  |  |  |  |  | 50
TFS Energy, LLC |  | 4 |  |  |  |  | 4
Grand Total | 558 | 274 | 70 | 9 | 7 | 2 | 920