tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56168d1256250083-consolidating-data-in-one-pivot-table-pivot-problem
Sheet: One

 |  |  | Class A |  |  | Class B |  |  | Class C |  |  | Class D
Customer | Account | Months | Real | Budget | Difference | Real | Budget | Difference | Real | Budget | Difference | Real | Budget | Difference
ONE | 1 | Jan | 30 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Feb | 29 | 0 | 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Mar | 32 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Apr | 31 | 0 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | May | 32 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Jun | 27 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Jul | 28 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Aug | 28 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Sep | 27 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Oct | 28 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Nov | 27 | 0 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 1 | Dec | 28 | 0 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Jan | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Feb | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Mar | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Apr | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | May | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Jun | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Jul | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Aug | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Sep | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Oct | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Nov | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 2 | Dec | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Jan | 0 | 0 | 0 | 13 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Feb | 0 | 0 | 0 | 11 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Mar | 0 | 0 | 0 | 15 | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Apr | 0 | 0 | 0 | 14 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | May | 0 | 0 | 0 | 11 | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Jun | 0 | 0 | 0 | 10 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Jul | 0 | 0 | 0 | 23 | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Aug | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Sep | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Oct | 0 | 0 | 0 | 14 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Nov | 0 | 0 | 0 | 21 | 0 | 21 | 0 | 0 | 0 | 0 | 0 | 0
ONE | 3 | Dec | 0 | 0 | 0 | 12 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 33631d1230099161-match-and-display-is-it-possible-add-an-index
Sheet: Jobs

 | Supplier | Description
 | [NAME] | Website
 | [NAME] | [NAME] and Website
 | [NAME] | Stationary
 | [NAME] | Website
 | [NAME] | Logo
 | [NAME] | Business Card
 | [NAME] | Business Card
 | [NAME] | Website
 | [NAME] | Logo and Business Card
 | [NAME] | Logo
 | [NAME] | Website
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Rangers

Texas Rangers | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Texas Rangers | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
[NAME], Lance | ML | ML | ML | ML | ML | ML |  | From Cubs | -0.2
Murphy, [NAME] | ML | ML | ML | ML | ML | ML |  | From Diamondbacks | -0.2
Murphy, [NAME] | ML | ML | ML | ML | ML | ML |  | From Mariners |  | -0.3
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | From Tigers | -3.5
[NAME] | ML | ML | ML | ML | ML | ML
Arias, [NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
Burgess, [NAME] | ML | ML | ML | ML | ML | ML |  | To Blue Jays | 0.7
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | To Mariners | 4
Collazo, Willie | ML | ML | ML | ML | ML | ML
Enright, [NAME] | ML | ML | ML | ML | ML | ML
Felix, [NAME] | ML | ML | ML | ML | ML | ML
Frazier, Todd | ML | ML | ML | ML | ML | ML
Friday, [NAME] | ML | ML | ML | ML | ML | ML
Fuller, Clay | ML | ML | ML | ML | ML | ML
Hagadone, Nick | ML | ML | ML | ML | ML | ML
Roberson, [NAME] | ML | ML | ML | ML | ML | ML
Roe, Chaz | ML | ML | ML | ML | ML | ML
Sinkbeil, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Worth, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | 15.9 | 15.9 | 15.9
[NAME], Derek | 15.6 | 15.6 | 15.6
[NAME], [NAME] | 5 | A3
Pierzynski, [NAME] | 4.8 | 4.8
Street, Huston | 3.8 | A3
Kearns, [NAME] | 3.4 | 3.4 | 3.4
Choo, Shin-Soo | 3 | A2 | A3
Weaver, Jered | 3 | A2 | A3
Capps, [NAME] | 2.9 | A2 | A3
Zimmerman, [NAME] | 2.9 | A2 | A3
Taveras, Willy | 2.7 | A3
Bray, [NAME] | 2.5 | A2 | A3
Kinney, [NAME] | 1.9 | 1.9
Corpas, [NAME] | 1.7 | A2 | A3
Rios, Alexis | 1.6
Lopez, Felipe | 1 | 1 | 1
Accardo, Jeremy | 0.9 | A2 | A3
Backe, [NAME] | 0.8 | 0.8
German, Esteban | 0.8 | A2 | A3
Gorzelanny, [NAME] | 0.7 | A1 | A2 | A3
Morrow, [NAME] | 0.7 | A1 | A2 | A3
Mathis, [NAME] | 0.5 | A
Bailey, Homer | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Casto, Kory | 0.3 | 0.7 | A1 | A2 | A3
Dillon, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Raburn, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Jimenez, [NAME] | 0.2
Encarnacion, Juan | 0.1 | 0.1 | 0.1
Spreadsheet: 63821d1264693417-running-total-test
Sheet: Sheet1

 | 2008-12-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 7.918 | 3 | 9.47209 |  |  | 0
 | 2009-01-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 137.275 | 347 | 63.1943 | 10 | 8 | 94.1176470588235
 | 2009-02-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 123.286 | 450 | 91.2512 | 10 | 9 | 105.882352941176
 | 2009-03-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 132.555 | 484 | 91.2829 | 10 | 9 | 105.882352941176
 | 2009-04-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 141.629 | 580 | 83.3919 | 10 | 7 | 82.3529411764706
 | 2009-05-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 132.759 | 500 | 94.1556 | 10 | 8.5 | 100
 | 2009-06-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 134.141 | 472 | 87.9671 | 10 | 9 | 105.882352941176
 | 2009-07-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 131.235 | 515 | 98.1065 | 10 | 9 | 105.882352941176
 | 2009-08-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 130.434 | 517 | 99.0923 | 8 | 8 | 117.647058823529
 | 2009-09-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 144.318 | 608 | 105.323 | 8 | 7.2 | 105.882352941176
 | 2009-10-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 110.004 | 490 | 111.36 | 8 | 7.2 | 105.882352941176 |  |  | Correct
 | 2009-11-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 132.455 | 509 | 96.0704 | 10 | 10 | 117.647058823529 |  |  | 3
 | 2009-12-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 3
 | 2010-01-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 2
 | 2010-02-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 2
 | 2010-03-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 2
 | 2010-04-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 1
 | 2010-05-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 1
Spreadsheet: 763350d1642116153-how-to-auto-populate-values-based-on-multiple-criteria-sample
Sheet: Mitigation Strategy

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Risk Assessment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Program 1
 |  | This report is used to capture identified risks and the initial mitigation that have been implemented to identify the residual risk rating. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Program 2
 |  | AIDS & Hepatitis C Programs
 |  |  |  |  |  | OPERATIONAL |  |  |  |  |  |  |  |  |  |  |  | STRATEGIC |  |  |  | External Environmental
 |  | Program | Transfer Payment Recipient | Lead TP | 2019/20 Funding $ | Human Resources | Finance | I&IT | Program Delivery | Policy | Project/Initiative | Legal | Regulatory | Emergency Management | Infrastructure | Physical Security | Other | Cultural | Governance | Regulational | Other
Spreadsheet: 881435d1729518691-repeat-cell-contents-based-on-quantity-roscow88-testa-tms
Sheet: Sheet2

SKU | Description | Price
 | ABC | 1
123 | ABC | 1
123 | ABC | 1
123 | ABC | 1
123 | ABC | 1
456 | EFG | 2.5
456 | EFG | 2.5
456 | EFG | 2.5
456 | EFG | 2.5
456 | EFG | 2.5
456 | EFG | 2.5
456 | EFG | 2.5
789 | HIJ | 11
Spreadsheet: 124011d1317997135-excel-2007-vlookup-enter-same-look-up-and-populate1
Sheet: Sheet1

 | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | etc | etc
[NAME] Could be up to 15 days duration) | A | A | A | A
Auto Input Data (Could B 1,2 or 3 As) | A |  |  |  |  |  | A | A |  |  |  |  | A
 |  | Works ok here |  |  |  |  | Beyond here I am lost
Spreadsheet: 327592d1403623015-compare-two-columns-and-highlight-the-difference-sample
Sheet: Sheet1

Status | COL1 | COL2 | [NAME] | COL4 | [NAME]
I | XXXX | 10 | XSXSX | 1 | 70
C | XXXX | 10 | XSXS | 2 | 70
I | [NAME] | 10 | [NAME] | 1 | 80
C | [NAME] | 10 | [NAME] | 1 | 80
I | ZZZZ | 10 | XXXXX | 1 | 90
C | ZZZZ | 10 | XXXX | 1 | 50
Spreadsheet: 70305d1271097365-adding-spaces-to-a-data-set-example
Sheet: Sheet1

 | ALU | APKT | ARRS | ARUN | CIEN | CSCO | FFIV | JNPR | MOT | OPXT | PALM | QCOM | RIMM | SHOR | STAR | TLAB
 | GLW | JNPR | GLW | JNPR | JNPR | QCOM | JNPR | CSCO | AAPL | AVGO | AAPL | CSCO | MSFT | FFIV | FFIV | CSCO
 | MOT | FFIV | MOT | FFIV | FFIV | EMC | SYMC | QCOM | CSCO | JDSU | HPQ | INTC | AAPL | COMS | TLAB | MOT
 | JNPR | COMS | JNPR | COMS | TLAB | MOT | NTAP | EMC | QCOM | FNSR | QCOM | TXN | IBM | PLCM | ADTN | JNPR
 | HRS | JDSU | FFIV | BRCD | JDSU | JNPR | CTXS | GLW | JNPR | INFN | DELL | MOT | CSCO | RVBD | TKLC | FFIV
 | COMS | RVBD | TLAB | PLCM | PLCM | SYMC | TLAB | MOT | TLAB | HLIT | MOT | BRCM | HPQ | CIEN | ADCT | ADTN
 | TLAB | ADTN | CTV | RVBD | ADTN | NTAP | JDSU | NTAP | ARRS | OCLR |  | JNPR | QCOM | BCSI | HLIT | CIEN
 | BRCD | CIEN | PLCM | BCSI | ARRS | CA | BRCD | CHKP | PALM | OPLK |  | MRVL | DELL | APKT | CELL | ARRS
 | ADCT | FNSR | ADTN | APKT | TKLC | CTXS | PLCM | FFIV |  | ANAD |  | NVDA | MOT | NTGR | AIRV | ADCT
 |  | ARUN | CIEN | NTGR | FNSR | CHKP | RVBD | COMS |  | MRVC |  | ALTR | JNPR | EXTR
 |  | INFN | ADCT | HLIT | INFN | HRS | ADTN | TLAB |  |  |  | XLNX | SY
 |  | ADCT | HLIT |  | ADCT | FFIV | ARRS | JDSU |  |  |  | AMD | PALM
 |  |  |  |  | SCMR | COMS | BCSI |  |  |  |  | MXIM | IN
 |  |  |  |  |  | TLAB | ARUN
 |  |  |  |  |  | JDSU | FTNT
 |  |  |  |  |  | BRCD | HLIT
ALU | APKT | ARRS | ARUN | CIEN | CSCO | FFIV | JNPR | MOT | NRTLQ | OPXT | PALM | QCOM | RIMM | SHOR | STAR | TLAB | ALU | APKT | ARRS | ARUN | CIEN | CSCO | FFIV | JNPR | MOT | NRTLQ | OPXT | PALM | QCOM | RIMM | SHOR | STAR | TLAB | ALU | APKT | ARRS | ARUN | CIEN | CSCO | FFIV | JNPR | MOT | NRTLQ | OPXT | PALM | QCOM | RIMM | SHOR | STAR | TLAB
Spreadsheet: 01af6e77-2c8d-4dba-b6db-8f3300c5d875
Sheet: Special School

[NAME]: |  | High Cost Risk Pool Data Collection 2013-2014
Student SSID | Average Special School Cost for Your LEA | Description of Unique Special Education Services as per Student IEP | Extraordinary Costs of Services Provided to Each Student | Total Average Classroom Costs + Extraordinary Costs | Subtract $19,683 (3X the 2012-13 Average Per Pupil Expenditure for Utah) ($6561) | Medicaid or Private Insurance  Reimbursement Received       (Subtracted from Total Costs) | Eligible Risk Pool Expenses
123456789 | 6000 | Physical Therapy, SLP, therapy swing, 2:1 aide | 22000 |  |  | 600
 |  |  |  |  |  | Subtotal
Spreadsheet: 121047d1315809440-how-to-identify-only-2-digit-permuted-number-from-list-of-3-digit-number-numbers-1-
Sheet: Sheet1

 |  | Number | help |  |  | Enter number
 |  | 1235 | 1235 |  |  | 235 | 235
 |  | 2523 | 2235 |  |  | 123 | 123
 |  | 1425 | 1245 |  |  | 541 | 145
 |  | 4458 | 4458 |  |  | 544 | 445
 |  | 2153 | 1235 |  |  | 153 | 135
 |  | 5152 | 1255 |  |  | 215 | 125
 |  | 3254 | 2345
 |  | 9133 | 1339
 |  | 5568 | 5568
 |  | 5609 | 569
 |  | 1515 | 1155
 |  | 1977 | 1779
 |  | 7368 | 3678
 |  | 8994 | 4899
 |  | 4189 | 1489
 |  | 9853 | 3589
Spreadsheet: 108149d1305223395-search-the-text-of-cell-in-a-range-and-return-the-whole-cell-where-content-is-found-copy-of-example-3
Sheet: Question 2

2062EDEBIT | EDEBIT
2069dfgdsgdfs | dfgdsgdfs
2070dfgdsf | dfgdsf
2073dfsdgsdf | dfsdgsdf
2124Account.comTAKE | Account.com |  |  |  |  | 2NDCHANCEBANKING.NET
2125dfsdf | dfsdf |  |  |  |  | 2062 NDCHANCEBANKING.ORG
222dfdfgdsgdf | dfdfgdsgdf |  |  |  |  | ACTIVATEDEBITCARD.NET
2233dfsdgfdf | dfsdgfdf |  |  |  |  | ACTIVAT 2070 EDEBITCARD.ORG
2234dfgdfg | dfgdfg |  |  |  |  | ALLACCESSMASTERCARD.NET
 |  |  |  |  |  | ALLACCESSMASTERCARD.ORG
 |  |  |  |  |  | AMERICANEXPRESSPREPAID.NET
 |  |  |  |  |  | AMERICAN 2124 EXPRESSPREPAID.ORG
 |  |  |  |  |  | APPLYBANKACCOUNT.NET
 |  |  |  |  |  | APPLYBANKACCOUNT.ORG
 |  |  | So if the keywords in column B |  |  | BABYBANKACCOUNT.COM
 |  |  | Found in the middle (5-15) of column A |  |  | BABYBANKACCOUNT.NET
 |  |  | Has a domain available in Column F |  |  | BABYBANKACCOUNT.ORG
 |  |  | Then return the cell which has the domain avaible
 |  |  | And display them in column C
 |  |  | Above is a example of what would happen
Spreadsheet: 715949d1611933839-show-a-filtered-subset-of-a-table-on-a-different-page-creating-a-dashboard-example
Sheet: Data

Name | Prog | Ext org | Int | email
A. test | excel |  | dep A | [EMAIL]
B. test | excel | Friend |  | [EMAIL]
C. test | mail | Gov |  | [EMAIL]
D. test | mail |  | depB
E. test | excel | Friend |  | bla@bla
F. test | mail | other
 |  | See other tab for dashboard
Spreadsheet: 441518d1453253208-how-do-i-calculate-lead-time-between-two-dates-during-working-hours-and-exclude-weekends-lead-time-formula-v2
Sheet: Lead Time Formula

Open Date | Close Date | FORMULA 1 Lead Time (Working Hours including weekends) | FORMULA 2 Lead Time (Working days and Working Hours) | Holidays | Difference | Working Days | New Formula | Updated  Formula | Update Formula 3
2015-06-04 08:23:02 | 2015-08-06 14:33:38
2015-06-04 10:57:33 | 2015-10-23 09:09:28
2015-06-03 00:19:34 | 2015-06-03 00:30:46
2015-06-18 02:17:21 | 2015-06-18 02:20:46
2015-07-10 15:13:01 | 2015-07-15 14:34:59 |  |  |  | 3:39:41
2015-06-12 14:23:54 | 2015-08-12 09:27:31
2015-09-09 11:15:21 | 2015-10-02 16:33:12
2015-07-17 11:05:24 | 2015-08-10 11:28:14
2015-10-23 00:26:43 | 2015-10-23 00:32:31
2015-07-17 17:11:31 | 2015-09-17 10:16:58
2015-08-19 08:25:25 | 2015-09-10 18:21:49
2015-07-28 16:58:07 | 2015-09-28 11:23:10
2015-08-06 17:46:51 | 2015-10-05 17:24:28
2015-08-07 17:41:51 | 2015-10-06 08:18:25
2015-11-02 11:09:14 | 2015-11-23 10:12:16
2015-10-29 20:05:50 | 2015-11-17 11:02:54
2015-10-22 03:44:23 | 2015-10-22 03:49:55
2015-10-25 04:22:26 | 2015-10-25 04:27:10 |  |  |  |  |  |  |  |  | -0.538379629632497
2015-08-10 05:00:15 | 2015-08-10 05:03:50 |  |  |  |  |  |  |  |  | -0.5383680555557173
2015-08-02 05:04:44 | 2015-08-02 05:09:29 |  |  |  |  |  |  |  |  | -0.5303703703708986
2015-10-11 15:57:26 | 2015-10-11 16:13:42 |  |  |  |  |  |  |  |  | -0.5119444444450589
2015-10-20 09:33:59 | 2015-10-21 20:17:22
2015-08-28 16:43:55 | 2015-11-04 17:16:09
2015-11-04 11:28:13 | 2015-11-09 10:51:52 |  |  |  | 1 day, 0:50:02
2015-08-03 10:36:12 | 2015-09-03 10:58:42
2015-10-15 11:47:49 | 2015-11-10 10:48:04
2015-06-17 10:34:51 | 2015-06-17 20:40:51
2015-08-27 20:56:32 | 2015-08-27 21:58:25
2015-10-18 08:16:42 | 2015-10-18 08:59:30 |  |  |  | 0:42:48
2015-11-09 18:18:30 | 2015-11-17 20:47:31
2015-06-12 11:38:36 | 2015-06-29 19:29:07
2015-10-08 14:40:46 | 2015-10-29 15:43:06
2015-07-10 21:57:58 | 2015-07-10 22:53:31
2015-11-03 11:33:44 | 2015-11-27 15:46:08
2015-09-08 02:10:03 | 2015-09-08 02:55:29
2015-07-10 18:16:51 | 2015-08-05 09:49:15
2015-11-03 15:11:32 | 2015-11-27 15:51:33
2015-11-10 15:18:06 | 2015-12-02 14:03:12
2015-06-22 14:33:06 | 2015-07-13 14:43:21
2015-10-13 13:46:56 | 2015-11-02 17:37:07
2015-08-14 08:25:34 | 2015-09-07 14:01:54
2015-07-17 18:55:14 | 2015-07-17 20:06:17
2015-08-20 21:39:59 | 2015-08-20 21:41:48
Spreadsheet: 875263d1721840390-totally-stumped-figuring-sales-compensation-spreadsheet-sample-commission-spreadsheet
Sheet: Sheet1

Pay Percentages
Tier-1 | 1 | 425625.99 | 0.00741
Tier-2 | 425626 | 851250.99 | 0.00835
Tier-3 | 851251 | 1276875.99 | 0.00927
Tier-4 | 1276876 | 1702500.99 | 0.0102
Tier-5 | 1702501 | 10000000 | 0.02
 |  | May | Jun | Jul | Aug | Sep
Monthly Sales Totals |  | 180110 | 141860 | 150000 | 900000 | 400000
Cumulative Sales Totals
These entries are manually entered. They are what the results should be.
Available for Tier-1 |  | 180110 | 141860 | 103655 | 0 | 0
Available for Tier-2 |  | 0 | 0 | 46345 | 804905 | 0
Available for Tier-3 |  | 0 | 0 | 0 | 95095 | 0
Available for Tier-4 |  | 0 | 0 | 0 | 0 | 400000
Available for Tier-5
Here is where the calculated results should go.
Available for Tier-1
Available for Tier-2
Available for Tier-3
Available for Tier-4
Available for Tier-5
Spreadsheet: mary_fischer__25609__32C-2001
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032C
COMPANY NAME   Enron Building Services Inc. Hldg Co.
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 81f8444f-3c99-4e05-ba4e-92bb2772b2aa
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Energiforsyning
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Alta Kraftlag SA |  | 9550 | Øksfjord | 78 45 09 00 | 78 45 09 10
Alta Kraftlag SA |  | 9161 | Burfjord | 78 45 09 00 | 77 76 83 36
Andmyran Vindpark AS |  | 8484 | Risøyhamn
Arctic Wind AS |  | 9690 | Havøysund | 78 42 30 10
[NAME] |  | 8110 | Moldjord | 75 56 82 73
[NAME] |  | 8264 | Engan | 971 73 968
BE Kraftsalg AS | Jernbaneveien 85 | 8006 | Bodø | 75 54 51 50
[NAME] | [NAME] 8 | 8226 | Straumen
[NAME] | Bjørkåsv. 69 | 8540 | Ballangen
Barents Naturgass AS | Sjøgata 6 | 9600 | Hammerfest | 78 40 62 00
Be Nett AS |  | 8110 | Moldjord
Be Nett AS |  | 8120 | Nygårdsjøen
Be Nett AS |  | 8140 | Inndyr
Be Nett AS |  | 8135 | Sørarnøy
Beiarkraft AS | Os | 8110 | Moldjord | 901 66 254
Bentsjord Kraft AS | c/o Jarle Myrhaug | 9147 | [NAME]
Bindal [NAME] |  | 7980 | Terråk | 75 03 19 00 | 75 03 19 10
Bodø Energi AS |  | 8100 | Misvær
Bordvedåga Kraft AS | [NAME] 70 | 8626 | Mo i Rana | 07800
[NAME] | Lodve Langesgate 2 | 8514 | Narvik
Brattland Kraft AS | Skjerperveien 6 | 8630 | [NAME] | 75 16 01 49
Brattland Øyvind | Skjerperveien 6 | 8630 | [NAME] | 990 07 668
Burfjord montørstasjon |  | 9161 | Burfjord | 77 76 82 56
Censu Trading AS | Strandgata 22 | 8656 | Mosjøen | 75 17 55 11
Durmålskraft AS | Korgen | 8646 | Korgen
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/