pdguzman profile picture
pdguzman profile picture

pdguzman

Sales Manager @ T-Mobile for Business

Fire Starter

Sales Manager: Any Trending Excel Formulas?

Hello War Room, any sales managers know of any Trending or Not Trending to sales quota excel formulas they can share? I’m building a forecast excel sheet and this would be very helpful to implement counting where we are in the month (day) and how many selling/working days are left.

🧢 Sales Management
7

16 comments

Sort by:
CuriousFox
WR Officer
3
🦊
@poweredbycaffeine 🦊
poweredbycaffeine
WR Lieutenant
5
☕️
Thank you, @CuriousFox, but I am an Excel for Dummies type of guy.
CuriousFox
WR Officer
2
🦊
Heard.
Boudreaux
Politicker
0
Regional Manager
Same!

FamilyTruckster
Politicker
3
Exec Director, Major Accounts
Sorry for the spamming. Can’t upload it easier. All the formulas are up top. 
You have to fill in the # of business days, target, day of the month, and total sold. The rest is formulas. 

*EDIT* if anyone can stitch together and repost feel free and I’ll take mine down. 
pdguzman
Fire Starter
1
Sales Manager @ T-Mobile for Business
Thank you, very helpful 
Mobi85
Politicker
2
Regional Sales Manager
I use a fairly simple formula for my industry due to daily sales that are coming in.  

I take current Revenue MTD divided by the # of business days already worked.  I take that average $ amount per working day and multiply it by the number of working days left in the month.  Take those 2 numbers and add them together to give me a rough forecast based on the averages.  

As you get further into the month that number becomes more and more accurate to end of month results.  I have typically had that formula land between 3-4k of end results when I have looked at it during the middle of the month.  With only 2 working days into the current month your numbers will probably be really skewed compared to looking at it after around 10-12 working days. 
pdguzman
Fire Starter
0
Sales Manager @ T-Mobile for Business
Thank you
FamilyTruckster
Politicker
2
Exec Director, Major Accounts
1
FamilyTruckster
Politicker
2
Exec Director, Major Accounts
2
FamilyTruckster
Politicker
2
Exec Director, Major Accounts
3
FamilyTruckster
Politicker
2
Exec Director, Major Accounts
4
Diablo
Politicker
1
Sr. AE
Great question! Curious to know if you guys are using any CRM that can save a lot of time on this plus this will be accessible by everyone?
MCP
Valued Contributor
1
Sales Director
With tech stacks as they are, there’s literally no reason to do this is Excel.
ZeroGrit
Valued Contributor
0
VP of Hoping My Emails Find You Well
Yep
softwarebro
Politicker
0
Sales Director
Forecast: FORECAST.LINEAR(cell,Value,Date)
mslope+int: CELL*SLOPE(Value,date)+INTERCEPT(Value,Date)

Related posts

6

HubSpot CRM vs Salesforce for sales reps?

Question
16
Hubspot CRM OR Salesforce for sales reps
46% HubSpot
54% Salesforce
87 people voted
10

Using a CRM other than Salesforce in Technology Sales

Question
🔎
💽
🏙
11
Have you used an CRM other than sales
47% I have only worked primarily with Salesforce
14% I have worked with other home grown CRMS
40% I have worked with other 3rd party CRMS
43 people voted
17

Sales Enablement Tool Guide (Gamification?)

Advice
☁️
🤓
16
Bravado is a community of trusted sales professionals endorsed by their customers.
Apple Store logo
Products
The War Room Jobs Salary Guide Tech Sales U
Company
About Us How It Works Blog Bug Bounty
Contact
Press Careers
© 2024 Bravado Inc. All rights reserved.
Privacy Policy Legal and Privacy Center Sales Jobs
If you are hired as a contract sales rep by a Bravado customer, we may ask you to prove access to the employee email account provided to you by that customer. This data will be shared with customers to track your sales productivity; customers can use this data to confirm you meet the minimum activity requirements to pay out your ramp stipend and commission.