Strategic Designs Ltd., forums http://www.startersorders.com/phpBB2/ |
|
Post Your Spreadsheets http://www.startersorders.com/phpBB2/viewtopic.php?f=19&t=11587 |
Page 1 of 3 |
Author: | Scatters [ Fri Nov 06, 2015 10:46 pm ] |
Post subject: | Re: Post Your Spreadsheets |
atriggerx23, you have put a lot of effort into this! Fantastic man. Tell me please, how were you able to determine the speed, stamina, consistency values to the nearest .5 measure?? I need some sort of magnifying glass to check and even then its not graded minutely enough to tell. Thanks John |
Author: | SiriusChill [ Fri Nov 06, 2015 11:49 pm ] |
Post subject: | Re: Post Your Spreadsheets |
You think it will work with OpenOffice? I am a cheapskate and using that. I currently have a trial version of Microsoft Office but that will be gone in a month. Please upload it and I'll give it a spin. Mainly the lineage recording. I would like a 6+ generations lineage recording because I like to see every once in awhile what I have done over time. I spent a long time last night going through the lines of the Sire I am breeding with now to see on "paper" what his lineage looks like. After much back n forth (and game crashes) - I came up with this representation of my sire Cross That Bridge... In real life this inbred freak wouldn't be fit to pull grandma's apple cart. But this is a game. Darker green are gamebreds and lighter are homebreds. Number next to horse is breeding distance indicator. Gamebred Over The River is one of the most influential horses I ever had. In the CK he would beat most horses from 6f to 10f. Go way back to gamebred Appeal Denied and he was my very first breeding sire in S06. Homebred Across The Galaxy was the horse that most of my future stars can trace directly to. He was a beast that I lost when forgetting to back him up. Staring at this last night I came to the conclusion that the male side is progressively being bred to go longer and the female side is progressively being bred to go shorter. I found it very interesting looking at my work over this time. I've posted my spreadsheet nonsense here before... These are the stats that matter to me in order of their importance to me. All stats being recorded at the beginning of the 5yo season. Horses are sent to game pool at the end of 4yo season after I record these and reload the save. The last 4 categories are the sum of each of the 3 stats categories with the last being the total sum of these 3. Purple being top percentile and green being above average. This example is my current breeding foray with Cross That Bridge and 3 mares - Great Find, Madrass and Silence Please. So far I have two keepers from the breeding - Great Cross and Dont Cross Me. Some more are coming. |
Author: | Pebbles Girl [ Sun Nov 08, 2015 3:30 pm ] |
Post subject: | Re: Post Your Spreadsheets |
atigger - I love your work I've studied dosage a bit so especially excited to think about using it in a game context. I'm planning on spending a lot more time focused on breeding so I definitely will find good use for your templates. I might be doing something wrong but I got 'link expired' message when I tried to download? |
Author: | mjtags11 [ Mon Nov 09, 2015 6:58 am ] |
Post subject: | Re: Post Your Spreadsheets |
Very nice job! I tried to do spreadsheets for my horses but updating them after every race eventually made my games last wayy too long once I had more than 5 horses (especially with 100 horses in my stable, one month could last over an hour; and a whole year... weeks). Just downloaded them and they might give me a reason to start playing again. And welcome back to the forums! Been awhile since we've heard from you. Hope all is well with you. |
Author: | Pebbles Girl [ Mon Nov 09, 2015 3:02 pm ] |
Post subject: | Re: Post Your Spreadsheets |
Up and running with your spreadsheets The grading using subtle shading from best to worst is much more visually informative than my old system of colour coding different ranges of numbers. With your meticulous record keeping I'm now wondering how you deal with progeny? I'm thinking I might have to do a lot of experimental coupling to see which abilities I want to encourage/improve. Do you have a spreadsheet you use for that too? Thanks again for sharing with us! |
Author: | Pebbles Girl [ Wed Nov 11, 2015 10:02 am ] |
Post subject: | Re: Post Your Spreadsheets |
Although I doubt we'll reach anything definitive, or even a general consensus, I think it's useful to consider much weight we individually give each stat. The more contributors we get, the more a 'hive mind' approach might show itself. I split stats into different tiers: Tier 1 - Potential (I still believe potential to be worthy of the top spot on its own). Tier 2 - Speed, Stamina, Acceleration, Cruising Burst, Extra Speed Rating (I believe an aggregation of these stats provides a good overview of a horse and largely removes distance bias). Tier 3 - Start, Battling, Confidence, Finish, Consistency (These are 'cherry on top' for me - if a horse that scores highly in Tiers 1 and 2 also does well in this category it adds that extra little something). Tier 4 - Constitution, Enthusiasm (of marginal importance to me). Any stats not mentioned are the ones I ignore. I haven't actually done any weighted scoring so I'll need to do a bit of work on that (and see what impact various weightings have on my rankings) but it'll be an interesting exercise. |
Author: | Pebbles Girl [ Wed Nov 18, 2015 4:26 pm ] |
Post subject: | Re: Post Your Spreadsheets |
Yes, the uncertainty is probably a useful thing (as frustrating as it is for someone who likes certainty!). I've been playing around with stats and weightings but I can't come up with a formula i'm happy with yet. Something I'm changing my mind on is the Stamina rating as I think I was wrong to aggregate it with Speed and Acceleration. I don't have enough longer distance horses to be sure but I think a 'good' longer distance horse should also be scoring highly on Speed and Acceleration? If that's the case, the addition of a high Stamina rating will actually accentuate distance bias. For instance my best IC horse has Speed 100, Stamina 30, Acceleration 90 = 220 ... I have a mundane PE horse that has Speed 75, Stamina 85, Acceleration 65 = 225. I think that proves I need to adjust my weightings and maybe remove Stamina entirely. I know Sirius values the Finish rating highly but, considering our best horses often win with daylight between them and the runner-up, I'm not sure it is 'activated' in every race in the same way as Potential, Speed, Acceleration, Cruising, Extra Speed are. What each horse achieves in their career isn't such a great indicator either I don't think. I had a very good 10f horse that won relatively little in the shape of G1s due to being the same generation as two monster gamebreds, whereas I've had sprinters and milers I'd consider less talented who have scooped up multiple G1s due to their distances being less competitive in their generations. I don't use the CK but I probably need to start doing so (although it sound buggy right now so hopefully it'll be fixed). Once I have enough of a pool available to run trials I can perhaps start to draw more conclusions about which stats are commonly high among those who do well in trials. It'd be interesting to hear what people who have done much more trialling and testing have worked out on that score. |
Author: | Pebbles Girl [ Wed Nov 18, 2015 8:03 pm ] |
Post subject: | Re: Post Your Spreadsheets |
That was really interesting - thanks for adding your thoughts at length I didn't know we could view stats for retired legends but i'm going to go look at my games after I type this, hehe. I know it's a really small sample size but battling qualities and cruising burst jumped out for me too when I was initially looking at their stats. Just a pity that every horse in my transfer pool has 10 for battling qualities! I'm still not convinced about finish application but i'd obviously prefer it to be 100 where possible. I agree there are complexities far beyond simply adding together a few stats and you make great points about how things like running style, starting ability and temperament etc can skew performance on any given day. All things being equal though, there must be certain stats that are beneficial to 'breed into' offspring. As I don't have any short term option to improve battling qualities, I'll pay close attention to cruising burst among my high potential horses and try to improve that across my lines. |
Author: | pjrhodes1970 [ Thu Nov 19, 2015 9:30 am ] |
Post subject: | Re: Post Your Spreadsheets |
wow never seen max distance adaptability before |
Author: | Pebbles Girl [ Thu Nov 19, 2015 10:24 am ] |
Post subject: | Re: Post Your Spreadsheets |
atiggerx33 wrote: I have now added a Breeding Sector to my file (it does not replace the original), the new link will be on the first page under Horse Data 2.0! So now, on both your "Horse" page and "Lifetime Scores" page you also must include the name of the Sire and Dam of the Individual (or if a gamebred leave them blank). Once you've filled these two columns with names, Let's say one of my Sires is named Dan The Man, you'd go over to the "Sire Scores" page and simply type "Dan The Man" (without quotes) into the name field, it will automatically fill in EVERYTHING else for you. The formulas took a lot of finagling on my part, they work 100%, however under NO circumstances should you EVER try to edit the data in a column other than the "Name" column, unless you're really good with formulas, you may cause irreparable damage. If you dislike a column (other than the foal count column) simply get rid of it. I warn you though, once removed by "deleting" a column cannot be brought back. Please note: If you leave a "Name" cell blank in the chart, that row will look quite ugly (a lot of errors mentioning you're dividing by 0, since everything is divided by the horse's foal count) until you fill it in. Also, I am like 90% sure the entries are case sensitive so use capitals and whatnot. Here is what the "Horse" page's two new columns look like, simple enough. This is a picture of my "Dam Scores" sheet. All the data is autofilled except for the name, so after filling out your "Horse" page and "Lifetime Scores" page with the sires and dams, simply type in some Dam names on the "Dam Scores" page and Sire names on the "Sire Scores" page and it'll automatically fill in every bit of the other information for you. If you do not use the "Lifetime Scores" or "CDs" simply delete the "AvScore" column, and the "AvCD" column. If you enter in a horse's sire and dam as soon as it is born, but do not enter in the other info (like potential and whatnot) until they are 4, you will get a messed up sire and dam score. (It is programmed to divide by the number of foals, so it'll divide by lets say "5" instead of "4", pretty much acting like your horse just gave birth to the worst foal in the history of foals, a foal with all 0 stats. This is a wonderful addition that I'm going to immediately start using! Thanks so much for sharing |
Author: | Pebbles Girl [ Thu Nov 19, 2015 12:04 pm ] |
Post subject: | Re: Post Your Spreadsheets |
atiggerx33 wrote: Pebbles Girl wrote: This is a wonderful addition that I'm going to immediately start using! Thanks so much for sharing No problem Pebbles! I've been enjoying playing with Excel, I never even realized it could do 1/2 the things I've asked it to figure out for me. It's been a bit of a b*tch figuring it all out, a lot of formulas I tried to get what I wanted came back with errors, for a while I thought I was asking the impossible. I actually manually entered a lot of data on a formula page to begin with, which was a real pain, very time consuming and just a miserable experience, I also only recorded the filly/colt percentages, number of foals, and the AvScore. Then I decided I wanted it not only to give me a lot more info (which I did not want to manually enter each time) but also decided there had to be a better way of getting it. What really encouraged me though, was that Sirius said he would like to see what I did for progeny. I knew I was sorely lacking there, but having someone else asking for it really encouraged me to get it done. I'm still so early in my breeding that it wasn't 100% necessary yet, but I knew from looking at what I could see of Sirius's charts that he was much further in, and not having excel himself would greatly appreciate it. So I guess a shout out to Sirius, for accidentally giving me the encouragement I needed. I wanted to kill excel and punch my computer several times (kept getting formula errors), and if you take a peek at the formula for the AvCD score you'll see why! It's like 5 solid lines of formula that it's coding for that one score (I really thought knowing the average progeny distance was important to breeding). For those who haven't downloaded the Dosage Chart but are curious what the brightly colorful column means just know its a tweaked version of a Thoroughbred Center of Distribution (google it, it's a pretty cool concept), but simply put the numbers range from -2.5 to +2.5. A score of "2.5" would signify that a horse was best at 5-6.75 furlongs, while a "-2.5" would (in my tweaking) signify a horse was best at around 15-16.75 furlongs, and a "0" would signify that a horse liked 10-11.75 furlongs... the closer to "0" the better they'd be suited (IMO) to the American Triple Crown. Not 100% sure, but I think that'd probably be what you wanted for the UK TC too, just with a really high Distance Adaptability bar to go with it. Just a note, I made the AvCD score brightly colored because I did not want to signify one distance as bad, and another as good. With the other stats, obviously lower is bad and higher is good thus the red to green coding (or in the case of Deterioration Potential I coded it to be green to red since you want that score to be low). I didn't want to imply a bias that a Classic runner was somehow better or worse than a sprinter, a good horse is a good horse whether they have the endurance of a quarter horse or an arabian or anywhere in between. I considered not color coding it at all, but then thought it would be easier to find similar-distance-producing sires/dams if the color coding was there. In hindsight I should have made stamina similar, I'm just so used to seeing it red-green on mine that it was habitual to look at it that way... I'm a complete Excel dummy so you have my total admiration for the coding. The colour coding variations for CD and Deterioration make complete sense. It was actually me who had asked for details of how you deal with progeny so I'm really excited about this addition. Especially considering it goes far beyond what I imagined might be available. This will mean an instant end to the piles of paper I was accumulating manually recording stats etc. Now, if only Mark could come up with an option for exporting stats to Excel our workload would virtually disappear, haha. |
Author: | mikeyfreedom [ Wed Nov 25, 2015 3:11 pm ] |
Post subject: | Re: Post Your Spreadsheets |
How does the spreadsheet calculate the Lifetime Score? There's no formula entered on the spreadsheet so it doesn't do any calculations when i put all the info in? |
Page 1 of 3 | All times are UTC [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |