revenues

I'm trying to create a spreadsheet that will keep track of my sales reps' advance/draw vs their revenues and commission amounts. For example: I have a sales rep who takes home either the greater of $3,000/mo, or 70% of revenues, provided his draw balance is at $-0-. So, he will always make at...

I'm looking for a macro that I can use to create two calculated fields on a pivot table - I have to create these upwards of 10 times every day! The first one would be called "Conversion Ratio": ='Hits Unique' /Signups And the second one would be "Rev per Sale" ='Initial Revenues /...

Hello guys! I currently have a database with company info that is organized by quarters I would need to summarize by year. The database is roughly organized like the table below, but with a lot more inputs per company and doing SUMIF manually will be an task with no end. I tried using index...

Good evening, I am currently working on building out a revenue model that takes into account new salespeople being hired, along with their quotas, productivity ramp up (time it takes for them to achieve increasing percentages of their quota), and how this all feeds into increased monthly...

I am pretty new to formulas and I'm hoping someone can help me... I am trying to create a formula that assigns a rate of 1% for revenues between $350,000- $750,000 2% for $750,000 - $1,449,000 and 3% for $1,500,000 - $2,500,000. I did =IF(AND(G14>350000, G14<750000)1.00), (AND(G14>750001...