My wife needs to build a scoring system spreadsheet for our horse/saddle club.
What she needs to know is if there is a way to make individual spreadsheets for different events effect another overall score.
Basically say there are 20 events with 10 contestants that all need the daily score, the daily score needs to be transferred and added to an overall year end score for the year end awards.
If there is other free software that might work better let me know !
Thanks for any help or advice !
IP: Logged
06:46 PM
PFF
System Bot
86GT3.4DOHC Member
Posts: 10007 From: Marion Ohio Registered: Apr 2004
You can do this easily. Y can add numbers between tabs just as you can inside a single tab. Just have a tab for each event and a final tab for the season. Or if you must have different spreadsheets instead of different tabs it will work the same way. I assume you know how to put in a simple addition formula if not let me know and I can describe it.
IP: Logged
07:07 PM
Mike Gonzalez Member
Posts: 5093 From: Colorado Springs, CO. USA Registered: Jul 2001
LOL, no not horse racing. Its horse shows, cow events, barrels, halter, more like a dog agility show. Some events score the handler, some score the animal.
IP: Logged
07:07 PM
Mike Gonzalez Member
Posts: 5093 From: Colorado Springs, CO. USA Registered: Jul 2001
You can do this easily. Y can add numbers between tabs just as you can inside a single tab. Just have a tab for each event and a final tab for the season. Or if you must have different spreadsheets instead of different tabs it will work the same way. I assume you know how to put in a simple addition formula if not let me know and I can describe it.
My wife can do the simple formulas, she is having trouble figuring out how to tally a total on a seperate page. I will see if I can get her to post better what she needs in a few, she just got home.
IP: Logged
07:10 PM
Mike Gonzalez Member
Posts: 5093 From: Colorado Springs, CO. USA Registered: Jul 2001
She said if you can explain to us how to get the values to transfer to another tab or spreadsheet that she should be able to figure out how to do the rest of it. Its just the transfering over for the yearly totals thats got her stumped.
IP: Logged
07:31 PM
naskie18 Member
Posts: 6258 From: Commerce Twp, MI, USA Registered: Jun 2002
And she wonders why I spend so much time on the Fiero forum !! Is there no question that cant be answered here !! Thanks guys +'s for all that dont have them from me !
IP: Logged
07:55 PM
Flamberge Member
Posts: 4268 From: Terra Sancta, TX Registered: Oct 2001
Vlookup allows you to look up values in a vertical table. For my Excel assignments I give my students, I use Vlookup to do a gradebook, or as a table for looking up shipping values.
IE:
0% F 60% D 70% C 80% B 90% A
You'll then create a formula to look up your value in that table and it'll return what letter grade the percent corresponds to.
LOL !! I thought so !! but my DVR already knows this info !
Just type vlookup into msExcel, add some exclamation marks if you want to. Then take and hook your computer to your DVR. (I recommend duck tape.) Take and give it all a jolt of power using my patented lamp cord retro shocker method.
And bingo, all kinds of coolness. You will be able to watch V whenever you want, add enough exclamation marks and you can see episodes before they are aired I hear.
Brad
IP: Logged
11:26 PM
datacop Member
Posts: 1426 From: Indianapolis, IN, USA Registered: Jan 2004
Originally posted by Flamberge: People bash Microsoft, but I can count the number of programs I like more than Excel on one hand.
As much as I dislike most of Microsoft's products, they sure did get Excel right. The amount of stuff I can make Excel do is freaking ridiculous, and I love that they incorporated VB, as I had some courses in that in high school and still remember enough to be dangerous
IP: Logged
11:59 AM
Feb 2nd, 2011
Formula Owner Member
Posts: 1053 From: Madison, AL Registered: May 2001
Originally posted by ryan.hess: To transfer it between sheets (tabs), you use the sheet name and exclamation mark.
For instance, to add two columns, A1-A5 on the first tab, and B1-B5 on the second tab, you'd type
=sum(sheet1!A1:A5,sheet2!B1:B5)
That will work, but there's an easier way. Go to a cell, type in "=", then go to the sheet containing the value you want in your formula, and select the cell (or cells) you want. Excel will add the "sheet1!" (or whatever sheet) automatically. Hit <ENTER> or continue with your formula.
IP: Logged
09:13 AM
Feb 3rd, 2011
Cheever3000 Member
Posts: 12397 From: The Man from Tallahassee Registered: Aug 2001