tier

So, I am trying to determine how best to calculate Tie rates for a commission structure when I know what the total payout should be at 100% achieved? Here is a sample of the tier structures, <colgroup><col><col><col></colgroup><tbody> 0.00% 75.000% 2.00% 75.00% 90.000% 3.00% 90.00%...

Hi, I need help creating a worksheet formula. I have a task with tiered goals (0-80). One may be evaluated at any point on this tier; employee A may start at tier 1, employee B may start at tier 10 at evaluation times. Going from tier 0 to tier 1 requires satisfactory completion of 1 task. Going...

Hi, I am trying to use SQL to take all the data from my Table and summarise it on Week ID and Tier one can someone help please. This is whati am currently using but it gives all data and i want it to summarise all under Week ID and Tier 1 only how many occur underTier 1 by week. Declare...

Hello I created a Microsoft excel sheet for a sports league I play in. There are 3 divisions the league, each win being worth more points the higher up. Every 3 weeks, the top 4 teams on the top of each division (except the top division) will move up, while the bottom 4 will move down (except...

Hi! I'm designing a new promotion and i'm thinking how to determine the quantity for each tier as well as how to determine what tiers i should create? e.g. Tier 1 = 1 to 5 units purchase = 2x bonus points Tier 2 = 6 to 50 units purchase = 5 x bonus points Tier 3 = 51 units and above = 10 x...

Here has got to be a better way to do this. This takes forever and gives me a run time error. I want to change the value of the cell only if it is NOT one of the four IFS. I probably want a find and replace but only if it is on condition it is not one of the four values (Player Tier, Veteran...

Hi all, I have attached my document with my desired result in the link below (I can't figure out how to add an excel document to this page). Below is a quick summary of what I'm looking to do (it's also in the document). I appreciate all your help and please let me know if you have any...

Hi, Not sure about the best way to go about this like at all.. I have a table of data that comes in once a week that looks like the table below (but bigger). Now I've made another table listing all the tiers down one column, and the criteria names across. The data needs to be the sum of the...

Hi Im quite new to this site, loving it already. This question might have been asked numerous times already, just dont know what to search for. I require assistance in creating tiers. This is based on tally system. Apologies if it is not clear enough. Not sure how to ask this correctly...

I am currently trying to create a formula that will do the following: Numbers in Column F contain numbers assigned to companies If # is between: 5 - 25 = Tier 4 26-100 = Tier 3 101 - 500 = Tier 2 500+ = Tier 1 I would like the formula to look in the F column and auto populate the tier that...

Hoping someone could help me out with a formula or macro to solve my issue. I currently have a list of data that's listed as such <tbody> Name Amount Bob 100 Bob 250 Bob 300 Carl 10 Carl 40 Carl 50 Carl 110 Carl 200 David 1000 </tbody> What I need to do is calculate the...

Hello all, I've tried everything, but I can't seem to figure this out (if it's even possible)... Basically, I have the following columns: Name (in alphabetical order), position, tier (tier based on position) This is all in the "Master" tab, but I have another tab that takes each position and...

I am trying to use a Range VLOOKUP based upon the criteria of color in this example. I have another set of data but used this example for simplicity and business reasons. But I need to use the table range that corresponds with the color. I have a lot of values so hard coding is not an option...

Hi I currently have a dormula that im using to calculate tiers. the overall ranking can start from from 1 to 1000. in column L. Tiering is 1 to 4. Cell E1 is 1, cell F1 is 150 cell G1 is 2 cell H1 is 350 cell I1 is 3, cell J1 is 335 and cell k1 is 4. currently there i am using this...

This should be easy but for some reason I am just stumped. I am trying to get this done without adding too many additional cells I have tried nesting an IF statement and adding clauses to the SUMPRODUCT but cannot quite get it. I am most likely OVERthinking this The below is what I am trying...

Hello, I have cells mentioning the ranges as mentioned below in Column A beginning with row1: No:of workers Min no: 0-30 ? 31-60 ? 61-70 ? 71+ ? I wanted to calculate the min no: before each tier. i.e. B2...

Hey guys, I got a job to categorise the Job titles in our CRM database into 3 tiers and a negative tier (for lead grading purposes). A previous colleague started building up a ruleset which uses keywords to get a certain job title into category: Tier 1, Tier 2, Tier 3 or Negative Tier Now this...

Hi Everyone, I have what has been a tricky problem for me. I have seen several posts on tiered pricing, which have been very helpful for calculating a basic tiered price system. But here's my situation: Items stored are on a tiered basis. If an item has been at a location for 0-15 days, its...