quote:

---

Originally posted by Nathan M.:
Deleting a template deletes the template file - it is gone. If it is going away once, and then coming back some other time, something very strange is happening as the file is somehow re-materializing.

---

It deletes the template until I shut down Equisim and restart it again. Then it reappears.

Jim

Guys,

I found this phenomenon interesting so I tried to duplicate it with the hopes of helping Nathan possibly debug. I am using v18, not v19.

Here's what I did: I made a backup copy of TekCapper's PCR template. Started ES, opened a single card, went to FV, switched to TC's template. It was there and working. Clicked the delete button. Shut down ES, then restarted. Opened the same card, went to FV, and tried to get to TC's template -- and it was NOT there. I tried to open a different card with the same results -- no template. I am not, as far as I can tell, seeing the same "Reappearing Template" phenomenon. I'll add that I don't use race assignment filters, so filtering is set to the defaults.

I am assuming that if you were to try to delete the template from the template folder itself using Windows the problem would...uh...disappear?

HH

quote:

---

Originally posted by Head Hawg:

I am assuming that if you were to try to delete the template from the template folder itself using Windows the problem would...uh...disappear?

HH

---

Nope, but it is not a huge problem for me. My guess it is somehow tied to backing up software on my machine.

Jim

UPDATE: Regarding the above, it does work fine now with the latest version. Must have been a problem in an earlier version for me.

Jim

This message has been edited. Last edited by: JimG,

Deleting a template deletes the template file - it is gone. If it is going away once, and then coming back some other time, something very strange is happening as the file is somehow re-materializing.

Nathan:

It happens every day-Now to me it is not a major issue but your above comments suggest I may have a problem, no?

Freddy

I would guess, as with Jim's issue, you have some sort of backup running on your computer that automatically restores files that are programatically deleted/not deleted via an install/uninstall operation? I'm not familiar with this sort of thing. Try this test though:

A) Start ES.
B) Create a new formula template
C) Open a file browser to the folder:
C:\program files\thorotech\ESROI5\frmtempls
D) In that folder, find the new template you created (it will be a file with the same name as your template).
E) In ES, delete that new template
F) In the file browser, see that the file is now gone (refresh the file browser if necessary). If the file goes away, ES has done its job (deleted the template file).

If the file later comes back, it has something to do with the way your computer is set up to handle the deletion of files/backing up of stuff.

Use Column Names instead of Column Number offsets.

When a column is inserted into an already existing template, the column offset changes and this could lead in a crash of ES or worse, a hidden time bomb of incorrect results to the formula.

For example, current template has 5 columns. In the fourth column the formula contains #COLVAL(3). A column is inserted between 2 and 3, which now makes the previous column #3 to be column #4. This could lead to a crash if numeric operations are attempted on a text column.

Example:

Col 1 = HName
Col 2 = Post Pos
Col 3 = Speed Pts
Col 4 = #COLVAL(2) * #COLVAL(3) - I know, it makes no sense!
Col 5 = Win Amount

Add new column for Jockey in betweeen 2 and 3, the formula will now be multiplying the post position by the jockey name.

COL 1 = HName
Col 2 = Post Pos
NEW Col 3 = Jockey
NEW Col 4 = Speed Pts
NEW Col 5 = Some Formula
NEW Col 6 = Win Amount


Could the #COLVAL function be enhanced to use the column name as defined in FV instead of the offset column number? In this way, should the template require an insertion of a column in between existing columns, the downstream forumula's using #COLVAL would not have to be revised.

Example: Column 10 is ppE2 and is defined in the template as E2. Instead of using #COLVAL(10) use #COLVAL(E2) instead.

Scott

How about a way to track the win% and roi of pertinet fields of fv templates

Nathan,

Here is a consolidated list

(2) Add a button on the left side of Speed Graph, below the "Reset PPs to Most Recent" button, to "Reset PPs to Primary Selected" to have the speed graph show the main, blue, pace line selected on the race form. I find myself doing this manually every time, flipping back and forth from the race form to the speed graph, because the selected race I want to graph is not always the last race.

(3) Add a "Previous Race" and "Next Race" button on the toolbar.

(4) Make the toolbar customizable, having the ability to add or remove any of the menu choices as buttons

(5) Have a paceline selection criteria which is customizable, not just for simulation bias settings but for general use,... allowing for use last race with no excuse, find most suitable race, ignore trip trouble in selection, etc.

(6) Add an updated varmasterlist.html to the help files in the directory \Program Files\ThoroTech\ESROI5\Help and add a choice for it on the "Help" menu

(7) Add the ability to print the Fractions Tool view and the Formula View in the "Print" Dialog box so that they can be printed with PPs, instead of having to print each seperately.

(8) Add the ability to "hide" columns in the formula view so that they do not print.

(9) Add autocomplete ability to the Formula View expression field so that when you type $ or # and start typing it will start matching to the variable or the function, instead of just bring up a pulldown list, then add the ability to hit return to select the variable or function you started typing.

(10) Add a checkbox to export column names as the first row when you choose "CSV Export" in FV. That way you can choose whether or not you want the column names in the CSV export file.

(11) Add the ability to show split times in feet per second (this may be asking for too much)

(12) Somehow identify the corresponding selected pacelines when printing the "Race Form" view, so that you can see what pacelines were selected for each horse on a printout, maybe adding a small blue or yellow box next to selected pacelines.

(13) The ability to print the "View Database Contents" details. Useful if you want to print to a file and email someone a list of the races in your database.

(14) The ability to "clear" the simulation view (maybe from the right click popup menu) so if you run more than one simulation with different settings you can clear that view, then run it again the way you want it. Now the only way to clear the simulation view is to close a card and reopen it.

(15) The ability to open a date range of race cards from the "Open Cards By Date" selection dialog.

(16) I realize that the Exotic Results files only contain the Final Time of the race,... but the Instant Charts do contain the fractional times. It would be cool if, when you "Store Race Charts", ES would read in and store the F1, F2, and F3 fractional times (in seconds) for each race. These are currently accessible via a right click on the race form and selecting "Race Properties", but the F1, F2, and F3 times have to be manually entered after looking them up in the Instant Chart. It would be very helpful if these values were loaded automatically into the DB (it looks like these are probably stored in the settings.sdb). Then they will be accessible via FV's variables, $rrRaceFract1, $rrRaceFract2, and $rrRaceFract3, just as $rrRaceTime is, without having to manually input the values in the race properties.

(17) It would be helpful to have FV available even when you do not have a race card open and be able to create a "Database" template that can pull information from settings.sdb and the currently connected profiler database. This can be used, for instance, to query your database for your profiled races to grab the fields date/track/race/class/distance/surf, to obtain the fractional and final times of the races (assuming wish list #16 is implemented). The Formula Template Editor Race Assignment Filters could be used to filter this data to a particular track. With this information you could, in theory, generate your own average fractional and finish time for each track/class/distance/surf to make your own "pars" for any date range you wanted.

(18) In FV, in the Formula Template Editor, Race Assignment Filters, add the ability to filter the races on a date range.

(19) Add the following FV variables which will return the calculated fraction times for the horse taking into consideration beaten lengths: $ppHFractOne, $ppHFractTwo, $ppHFractThree ($ppHFinalTime already exists).

(20) Pull information from the Exotic Results File and the Instant Chart and create a new set of variables for race results accessible in FV for each horse: $rrHFractOne, $rrHFractTwo, $rrHFractThree, $rrHFinalTime, $rrCallStart, $rrCall1, $rrCall2, $rrCall3, $rrFinish $rrBtnLengths1, $rrBtnLengths2, $rrBtnLengthsStretch, $rrBtnLengthsFinish, . Maybe a new template of type "Results", similar to a "Horse" template would make sense. If these were available via FV, I think I would definitely consider purchasing DB Direct because I could make my own race charts and export one line per horse with positions, beaten lengths, fractional times, and finish times.

(21) A FV variable to extract weather information from the Instant Chart. Could be used in a race chart db (see (20)). I've always wondered if weather was a factor or not, especially in Chicago where horses run in all 4 seasons of the year.

(22) A FV variable to extract full sentence race comments for each horse from the Instant chart.

(23) I know that ppApproxDistB is available (Returns ˜1' if the distance of the race was approximate. Common for turf races with moveable rails). It would be helpful to have FV variable to extract the actual amount (in feet) from the PP that the moveable rail is at in a turf race. On some tracks, depending on how far the rail is moved out, it is a change in distance for routes that should be considered. This could be then used as a turf race bias.

(24) Either you open a race card and the Exotic Results file is loaded automatically, or after you already have a race profiled and stored in the Profiler DB, I noticed that ES correctly marks all the late scratches in each race. I guess it gets these from the results file. It would also be helpful if it also made the Jockey changes automatically.

(25) In SPAT, add the Selection Type "Sim & Prof & Comp". I have found that a horses that are #1 sim, #1 prof, and #1 comp have a good hit% at certain tracks (which is rare) depending on the filters you use. It would be helpful to be able to query your DB using SPAT for this.

(26) In SPAT, add the Selection Type "Prof & Comp".

(27) In SPAT, add the Selection Type "Sim & Comp"

(28) When choosing "Store By Track", in the "Auto-Store" popup window that allows you to pick the dates and tracks, add a checkbox to "auto store race charts". If this checkbox is selected it would auto store the charts of the associated date range and selected tracks if it is located in the correct path <Data Card Root Folder>\<track>\charts\<track>_xx_xx_xx.html. This would save a lot of time manually adding the race charts for each track every day. I am proably not the only person who uses race charts extensively when mining through the PPs and want to see the detail from the PP's race chart via a right click on that PP line.

(29) Make the "Store Race Charts" function off the "Profiler Database" menu similar to the dialog above, which would allow you to pick the dates and tracks and would auto store the racecharts for the selected date range and track if they are located in the correct path.

Hi Tek
I also use and store charts. For what it is worth, here is how I do it. Right after I download the results xrd files I Use ,select charts,use contols select all charts this date. Click on any I don't want. Set up a download folder in my cards for all charts to go to.
After download use database menu,store all charts. Hi lite all of them in the folder. They go where they belong. Speeds things a little


Jerry

(25) In SPAT, add the Selection Type "Sim & Prof & Comp". I have found that a horses that are #1 sim, #1 prof, and #1 comp have a good hit% at certain tracks (which is rare) depending on the filters you use. It would be helpful to be able to query your DB using SPAT for this.

Hi Tek Yes, this is a good one. I found the same thing. I adapted my FV to do it and store the result in MY Picks. Spat would be great!

Jerry