quota

  1. J

    Quota/Dogfight/Chicago Golf Spreadsheet

    Good Afternoon, I am trying my best to create a golf spreadsheet for a league. I am curious if anyone has a current golf league spreadsheet that contains any of these. I would love the quota spreadsheet, but would take any. I am struggling on excel creating formulas although I have had a great...
  2. J

    Golf Quota Point System Formula Help

    Good Afternoon, I am in dire need of help. I am not to savvy with Excel. I have been struggling and seem to find no answers on how to convert someones score to par, to points in the row below. For example in quota point system, its a lot like Stableford, but ones handicap is subtracted from 36...
  3. T

    Need help returning average of top 3 scores from most recent 5 at a moment in time

    Hi everyone. First post here and I need some help. I'm setting up a scoring sheet for a golf course that needs to calculate what we call a "quota". Your quota is an average of your top 3 scores from your 5 most recently played. I have the easy stuff done. A player's score is entered into a...
  4. L

    Tiered Commissions Calc

    Hi, I was wondering if someone could help me with this. I have a tiered commissions structure as follows: 0-100% attainment (Total payout of 100% of eligible %) 100-125% (total payout of 1.5% of eligible %) 125%+ (total payout of 2.5% of eligible %) accelerated commission rate not to exceed 15%...
  5. L

    3d formula without quota

    Hi I am reading the article below and it say that to create 3 d formula, you need to do this ='[workbook]'worksheet'!$A$1 (single quota) I tried that and my formula was =[test1.xlsx]Sheet1!$A$1 So I am in test2.xlsx and I want to link to cell A1 in file test1.xlsx. I just type = then...
  6. K

    Tiered Commission Structure - HELP ASAP PLEASE

    So, we have a commission structure where I need to calculate the payout each month, based on what percent of quota they have achieved. I know I need to use a sumproduct, but I am not able to make it work. The ICF% should be based on the % to Quota Running Total Revenue to Quota column (P)...
  7. B

    Send email based on value AND date?

    I'm back! You guys are teaching me so much! New question: When using Google sheets I have a sheet setup with some charts. These charts show who has made their "quota" I guess you'd call it. They must do 2 audits a day, 8 per week, and 48 per month. I'm wondering if there is a way to setup the...
  8. M

    Extract numbers from a cell

    Hi all, sorry if this has been done over and over again, i have searched but cant find anything which applies to my query. i have many cells which contain information like this: <tbody> Quota Alert: User vend-scader-casawdco-467191056786938 disabled due to exceeded quota Quota Alert: User...
  9. R

    Issue with VLOOKUP formula

    Hello guys, I have an issue with the Vlookup formula. Pratically I need the formula To search the value corresponding to the names. I have a formula like that =Vlookup(J3;I14:J52;2;0) and it is fine it is working. The problem is that formula is working for the "quota fissa" column. In order to...
  10. B

    Private Message Quotas

    If a user has exceeded their stored private messages quota such that they cannot accept further messages until they clear some space (e.g. a new user who is yet to post to the Forum and therefore has not yet "earned" any quota, but it could be any user with a full mailbox): are they immediately...
  11. V

    What is this formula doing? (Min/Max)

    I have inherited the below formula. I believe it is wrong but I don't really know what's it's doing. It is supposed to take sales amounts and depending on where the sales person is in regards to their quota payout on a percentage tiered approach. Can someone rewrite this formula so it works...
  12. T

    Just need "yes" or "No" if someone hit quota.

    So I think this is really easy, but I can't quite figure it out. I have a book with multiple sheets. (Using | below to show different columns) (cut out a lot of data points, but there is a lot more sales codes/quotas, and employees) In one sheet I show the quota based on job title as such...
  13. S

    Sales Quota distribution factoring in % of phone hours

    Hi, I am having difficutly building a formula to distribute overall sales quotas to employees base on each employees expected phone hours. Total Sales Target : 1000 Total Employees : 15 Total Phone Hours for Dept : 2000 Employee 1 : 161 hours (8.05%) Employee 2 : 123 hours (6.15%) Employee 3 ...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top