|
Google Site Search | Get RDSS | Sartin Library | RDSS FAQs | Conduct | Register | Site FAQ | Members List | Today's Posts | Search |
RDSS 2.2 (and previous versions) Racing Decision Support System - The NEW Version 2.2 |
|
Thread Tools | Display Modes |
10-26-2019, 01:34 PM | #21 | |||
always learning
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
|
Bill,
Quote:
Quote:
Quote:
Thanks Tom |
|||
10-26-2019, 05:54 PM | #22 |
always learning
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
|
Turns out the size of the file with the very complicated formula for filtering and counting the SUBTOTAL formulas is too big to upload. I'll think about a way to work around that.
Last edited by Dorianmode; 10-26-2019 at 05:58 PM. |
10-26-2019, 08:21 PM | #23 |
always learning
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
|
Here is Bill's file with the filtering functions corrected, I think.
The formula for counting only visible filtered rows is very complicated. I'll keep my eye open for a simpler one that takes up less memory. In order to upload it, I had to lop off all the extra rows at the bottom. But if you add rows in the normal way, it will still work, and the programming ranges will update automatically with the extra row numbers. Bill, if you want me to fix the red and green and yellow colors in all the races, if that's helpful, it would be very easy to do. Tom |
10-27-2019, 11:20 AM | #24 |
Grade 1
Join Date: Feb 2006
Location: Escondido CA just 25 minutes from where the turf meets the surf - "...at Del Mar"
Posts: 2,418
|
No, the red and green was built into the template, it goes away after the first few programmed cells. NO problem with adding cells as long as when we do, we expand the range before getting to the last named cell in the range.
So you add row A1785 above the named range, which here might be A1790. The range expands by as many lines as you add, as you know. There is a lot to check when making this spreadsheet. I spent a lot of hours during my research debugging formulas for all the columns all the way out to the D and E columns. Thanks for doing the leg work on the rest of the formulae. Bill |
11-03-2019, 12:07 PM | #25 | |
always learning
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
|
Quote:
Thanks again to Bill V for sharing all this great information and doing all the work of putting it in one place. The information here is (literally) worth a fortune. Tom |
|
11-06-2019, 02:31 PM | #26 | |
always learning
Join Date: Jul 2011
Location: Minneapolis / Rancho Santa Fe
Posts: 277
|
Quote:
An amazing amount of information here ... thanks Bill ... a huge contribution. |
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Model Results Hits A Big One At GPX 05-25-19 | partsnut | Selections | 10 | 05-27-2019 01:00 PM |
Brohamer Model Question | papajohn3times | General Discussion | 4 | 03-20-2018 09:32 AM |
Brohamer Decision Model | CaptDon100 | Sartin Methodology Handicapping 101 (102 ...) | 26 | 06-26-2015 06:41 PM |
Original Brohamer Model | RichieP | Manuals | 0 | 09-24-2009 10:11 AM |
Original Brohamer Model Audio 1985 | RichieP | Audio Collection | 0 | 09-20-2009 09:54 AM |