[mso] Re: Excel Subroutine (Golf Spreadsheet)
- From: "Andrew" <tyto2820@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 25 Mar 2005 18:58:27 -0000
Tracy,
It sounds like you are really proud of the things your spreadsheet does!
It is true that a spreadsheet uses more memory the larger and more
complicated it becomes because all the data (including the formulae) is
loaded into memory. Given the enormous amounts of memory available these
days, this is not too much of a problem.
When you say you "have developed a program", do you mean that you are using
Visual Basic to process the calculations? From the rest of your query, it
would seem that you are not. What you are asking for (a subroutine to
handle similar calculations for a number of members, teams and tournaments)
suggests a Visual Basic macro.
If you were able to do this, I suppose your file size might be slightly
smaller but I don't think you would save anything on 'calculation': it would
still have to do the same amount of math, effectively.
Andrew
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of k_tracy@xxxxxxxxxxxxx
> Sent: 24 March 2005 01:09
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Excel Subroutine
> Importance: High
>
> Folks,
>
> If you can help, I'll dance at your wedding, relatives
> wedding, or just dance in general.
>
> I have developed a program in MS Excel 2003 that
> automatically performs every single manual task that is
> required to maintain my company's golf league, but at present
> it's tons of memory. We have 182 members and 18 teams, and
> the program has to keep up with each individual, each team,
> and each tournament (20 per season). A lot of work for the
> program, i.e. a lot of memory, since each formula has to be
> repeated over and over for each member, team, etc. But if I
> could figure out how to build a single cell that only acts as
> a subroutine to satisfy the hundreds of cells that require
> that same formula, the program would be much more generous
> and I could develop it even further.
>
> What I'm saying is: say Paul , John, George, and (heck)
> Ringo play as a foursome. Each requires the same formula to
> acquire his weekly handicap. Is there a way to task this
> function to a single "subroutine" cell and paste the result
> for each golfer, rather than repeating the same function four times?
>
> Thanks
>
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
- » [mso] Re: Excel Subroutine (Golf Spreadsheet)
