tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__35035__MgmtSum-Q2-0410a
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON NORTH AMERICA
2000-06-01 00:00:00 | 2ND QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD
ENA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast Margin Calculation
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin |  |  |  | Earnings Before Allocated Expenses
 | Business Team |  | DPR* | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME] |  |  | Plan | Forecast | [NAME]
[NAME] | Gas Trading |  | 1285
[NAME] | Power Trading
IR_FX | Financial Drift |  | 2263
ECT_INV_IRFX | Financial Trading
TRD_MKT | Canada |  | 2314 | 1822
COAL | Coal |  | -3 | 3
WEATHER | GRM -  Weather |  | 221
SO2 | Emissions |  | -1172
INSURANCE | GRM - New Products
EXEC_TRD | Executive Trading |  | 515
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
PAPER | Industrial Downstream - Paper |  | 643
CHEMICALS | Industrial Downstream - Chemicals
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico
 | Total Origination
GENCOS | Genco
N_BS_DEV | Generation Investments
ASST_ORIG | Gas Assets |  | 0 |  |  | 16373
ASST_TRD | Gas Assets - Trading
 | Total Assets
EQUITY | Principal Investing |  |  | -6852
PROD_FIN | Energy Investments |  |  | -883
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets |  |  | -8054
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
TREASURY_INT | Other Interest Related Charges
 | Overview |  |  |  |  |  |  |  |  |  |  | 38074
 | Total
 | * Excludes Cap. Charge & Operating Costs
 | Check Figures
 | Gas Trading
 | Emerging Businesses
Spreadsheet: 217391d1362060084-values-in-between-mappe1
Sheet: Ark2

 | Kategori
 | Kategori 1 | [NAME] | [NAME] 3 | [NAME] | [NAME] |  |  |  |  | Q=a*P+b+K1*k2*c+k3*c+k4*c
Tilskuerkapacitet | 40000 | 40000 | 40000 | 40000 | 40000
Tilskuere pr. [NAME] |  |  |  |  |  |  |  |  |  | a | -175
Antal kampe | 2 | 3 | 4 | 2 | 11 |  |  |  |  | b | 20000
Tilskuere i alt |  |  |  |  |  |  |  |  |  | c | 40000
Udgifter: |  |  |  |  |  |  |  |  |  | k1 | 1
Løn til IT |  |  |  |  |  |  |  |  |  | [NAME] | 0.7
Løn til NT |  |  |  |  |  |  |  |  |  | k3 | 0.4
Løn til UT |  |  |  |  |  |  |  |  |  | k4 | 0.2
Løn til øvrige af holdet
Løn til vagter |  |  |  |  |  |  |  |  |  | Vælg billet prisen | kr. pr. [NAME].
Udgifter til mad og drikke |  |  |  |  |  |  |  |  |  | Billetprisen | 150
 |  |  |  |  |  |  |  |  |  | Kategori 1 | [NAME] | [NAME] 3 | [NAME]
 |  |  |  |  |  | Øvrige udgifter |  | Antal
 |  |  |  |  |  | Løn til træner | 100000 | 1 |  | Grundløn | 50000 | Antal spillere
 |  |  |  |  |  | Løn til AT | 60000 | 2 |  | Faktor for IT | 2 | IT | 5
 |  |  |  |  |  | Løn til HL | 20000 | 1 |  | Faktor for NT | 1.5 | NT | 8
 |  |  |  |  |  | [NAME] | 10000 | 1 |  | Kaktor for UT | 0.75 | UT | 5
 |  |  |  |  |  | Løn til Massør | 6000 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | ↓
 |  |  |  |  |  | Antal tilskuere |  | Løn til vagter |  |  |  | Spillere i alt
 |  |  |  |  |  | 35000 |  | 30000
 |  |  |  |  |  | 34999 | 15000 | 20000
 |  |  |  |  |  | 14999 |  | 10000
 |  |  |  |  |  | Vare | indkøbspris
 |  |  |  |  |  | øl | 10
 |  |  |  |  |  | sodavand | 5
 |  |  |  |  |  | pølser | 10
Spreadsheet: 108158d1305225079-if-formula-help-auto-populate-a-bonus-based-on-return-on-sales-model-bonus-structure5
Sheet: Bonus '10 Q3 Metrics  (2)

Salaried Manager Bonus Structure
 | [NAME] | ROS $ | ROS %
Period 1 | 100000 | 2500 | 0.025
Period 2 | 100000 | 2500 | 0.025
Period 3 | 100000 | 2500 | 0.025
Total | 300000 | 7500 | 0.025
 |  | RM | GM
Avg. Weekly Guest Count Growth (Target -55)
Guest Count Growth |  | 0 | 0
Performance Earnings Growth
Performance Earning Growth |  | 0 | 0
Performance Earnings ROS%
0-5% | 15000 | 52.49999999999999 | 112.5
5.01-12% | 0 | 0 | 0
12.01-100% | 0 | 0 | 0
 | 15000
Simply Great Incentive
Steritech Score of 92% or better | Yes
Secret Shopper Score 100% | Yes
TUAU Top Box - 65% or better | Yes
Food Quality Score of 80% of Better | Yes
Overall Cleanliness Score of 90% of better | Yes
Speed of Service Score of 70% or Better | Yes
If 1=150, 2=300, 3=455, 4=605, 5=760, 6=915 | 6 | 380 | 915
Gross Total |  | 432.5 | 1027.5
Less Tax | 0.3726 | 161.1495 | 382.8465
Net Total |  | 271.3505 | 644.6535
Spreadsheet: 84029d1284039355-remove-blanks-from-data-validation-validation-list
Sheet: Uniques

[NAME] |  |  |  |  |  | To get Unique Values With Formula
 |  |  |  |  |  | 1 | Dynamically Name Range (for example in this case
Names |  | Unique Values |  |  |  |  | "DynamicNames" with this formula: =OFFSET(Uniques!$A$5,,,MATCH("*",Uniques!$A$5:$A$400,-1))
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME] |  |  | 2 | paste this formula elsewhere [NAME] Ctrl+Shift+Enter and
[NAME] |  | [NAME] | [NAME] |  |  |  | copy down as far as needed
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | [NAME] | [NAME]
[NAME] |  | 1
[NAME] |  | 2
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
1 |  | #N/A
[NAME] |  | #N/A
1 |  | #N/A
2 |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A
[NAME] |  | #N/A