Help on a super spreadsheet for forecasting staff

trefle10

New Member
Joined
Jul 26, 2007
Messages
4
Hi guys, I'm new around here but I was reading your stuff for quite some time.

I'm also quite novice to excel programing (VBA and formulas) but I'm a Java developer so I understand logic... just not the logic around Excel... :)

I have to maintain a staffing forecast spreadsheet and it was quite a pain so I created a bunch of formulas and macros to help me. The problem is that it's not performant and quite heavy as I keep adding data.

Can someone have a look at it and try to optimise it? I'm a quick learner, if you start it I can keep improving it... I just dont know where to start.

Also, if someone could help me to implement some kind of calendar for vacation that looks a little bit like the one found on this site http://www.en.jgm-software.com/ (not trying to steal their stuff, just want to give you an example of the improvement I'm looking for)

I dont know how to attach my spreadsheet, is ther a way?

Let me know, any help will be good!

Thansk in advance! you guys ROCK!
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
Send me your email in a PM and I'll send a example of the Vacation calendar.

I'm headed for the golf course in ten minutes... :LOL:
 

trefle10

New Member
Joined
Jul 26, 2007
Messages
4
guys, forget the vacation planner thing, my main issue it to get my spreadsheet optimized... can anyone tell me how I can atatch it here so people can help me?

Thanks in advance.
 

trefle10

New Member
Joined
Jul 26, 2007
Messages
4
well it's just that I did a poor job of coding it and it's quite slow at the moment. also the size is with data no in exces to 4 megs... it's all because I did a bunch of formulas instead of coding it right...

I really have to send the spreadsheet as the html marker cant grab enough of it to see the problems...

PM me if you want me to send you the document.

and thanks for the help!
 

Forum statistics

Threads
1,181,720
Messages
5,931,668
Members
436,797
Latest member
fullmetalpogi

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
Top