Excel question on modelling - Pace and Cap

Mitch44 · 01-29-2021, 02:22 PM

Ted is correct in solving this problem with the present version.

1. If your good at writing formulas just change it to reflect the last 20 races.
a. If so it won't delete the other information in the cells for that column unless you actually delete it.

b. Most need to delete much of their data collected anyway as its not current. I.e. thousand race data bases are insane anyway for one particular area. having a thousand race database is OK if broken down into smaller bytes such as by distance, surface and class.

2. If you can't write formulas just copy and paste into another workbook. That way you only need to get the formula correct one time, which should be attainable with help from others with real knowledgeable of this stuff or you fumble around to you get it right.(probably already done and there in the present day RDSS, unsure as I don't use it.

3. Use pencil and paper.

I have done a little work with Excel but I'm more a pencil and paper guy. The future updated version sounds like a vastly improved one over the present. For immediacy just work around it.

Mitch44

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adjustments Question	Ted Craven	RDSS2 / FAQ's	3	06-29-2014 04:22 PM
RDSS2 - Adjusted Screen Question	Ted Craven	RDSS2 / FAQ's	4	02-16-2013 07:45 PM
A Question Posed 1986	Bob Cochran	General Discussion	12	08-30-2009 08:29 PM
Release Notes - Version 0.98.8	Ted Craven	RDSS Info, Reference	3	07-28-2009 09:35 PM
Question Concerning "About" Distances...	lueylump	RDSS	2	05-13-2009 05:45 PM

01-29-2021, 02:22 PM	#11
Mitch44 Grade 1 Join Date: Nov 2014 Location: The Villages, Fl. Posts: 3,872	Ted is correct in solving this problem with the present version. 1. If your good at writing formulas just change it to reflect the last 20 races. a. If so it won't delete the other information in the cells for that column unless you actually delete it. b. Most need to delete much of their data collected anyway as its not current. I.e. thousand race data bases are insane anyway for one particular area. having a thousand race database is OK if broken down into smaller bytes such as by distance, surface and class. 2. If you can't write formulas just copy and paste into another workbook. That way you only need to get the formula correct one time, which should be attainable with help from others with real knowledgeable of this stuff or you fumble around to you get it right.(probably already done and there in the present day RDSS, unsure as I don't use it. 3. Use pencil and paper. I have done a little work with Excel but I'm more a pencil and paper guy. The future updated version sounds like a vastly improved one over the present. For immediacy just work around it. Mitch44