Help on a super spreadsheet for forecasting staff

[trefle10]

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!

 

[Brian from Maui]

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...

 

[trefle10]

Done!

Thanks again

good golf!

 

[trefle10]

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.

 

[ADAMC]

You cant attach the whole workbook only screenshots:

http://www.puremis.net/excel/downloads.shtml download Colo's HTML maker..
Whats actually the problem with your spreadsheet? Perhaps i can help?

 

[trefle10]

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!