Need Excel Expert up for a challenge

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

oscarose replied

23 December 2012, 11:45
You can do this yourself in Excel using a combination of VBA and macros.

In Excel, you'll need to activate the developer tab which is under setting/preferences somewhere (default setting is off).

HTH and good luck.

Last edited by oscarose; 23 December 2012, 11:47.
Leave a comment:
Spacecadet replied

22 December 2012, 19:48
Originally posted by rcoups View Post

I have an Excel file I downloaded from another forum. It is not my work. It generates a schedule for my 8 Ball league. I can input the # of teams and the number of weeks in the session, hit "generate" and I get a fairly balanced home and away schedule. I need to tweak the schedule, because some of our venues have more than 1 pool table and multiple teams, so there is an over-booking possibility to deal with. Also, we would like the schedule to pit most of the stronger teams (for ex. the top 10 or 12 teams from the previous session) against each other. Are these tweaks possible with Excel or do I need to find someone proficient in VB, C++ or C# to write an app for us ?

Thanks in advance for any help you can provide.

Sounds like a job for SAP
I've got a team of consultants I can send in for 6 months.
Leave a comment:
adubya replied

22 December 2012, 13:31
What day rate can you afford ?
Leave a comment:
xoggoth replied

22 December 2012, 12:58
Even assuming formulas can't do it, there's very little one can't do with a bit of VBA in Excel itself. Can you post a link to this download so we have more idea what you mean?
Leave a comment:
rcoups started a topic Need Excel Expert up for a challenge

21 December 2012, 23:17
Need Excel Expert up for a challenge

I have an Excel file I downloaded from another forum. It is not my work. It generates a schedule for my 8 Ball league. I can input the # of teams and the number of weeks in the session, hit "generate" and I get a fairly balanced home and away schedule. I need to tweak the schedule, because some of our venues have more than 1 pool table and multiple teams, so there is an over-booking possibility to deal with. Also, we would like the schedule to pit most of the stronger teams (for ex. the top 10 or 12 teams from the previous session) against each other. Are these tweaks possible with Excel or do I need to find someone proficient in VB, C++ or C# to write an app for us ?

Thanks in advance for any help you can provide.
Tags: None