1) This is basically looking for what I define as a clear trend at a meeting and in a sense is simple as it really is working around previous project (please check those out) except the count works by the "meeting" although it needs to reset when ever a new meeting/date is detected. I already have the VBA code to produce a "count" from my last programmer if that is easier. I would think continuing to call up macros by a shortcut key would be fine or if preferred a GUI within VBA.
The idea behind this is to so I can firstly either run it over one individual meeting over 8 months with the ability to reset when a new day is detected or run it over multiple meetings in a single day and keep count of each one to save me having to run the software hundreds of times. What I plan to do is use "Sort by A-Z" for the date when have multiple meetings in a day that way makes things a LOT easier for you as meetings will be grouped together rather than remembering everything in memory or something along those lines.
The option (on/off) followed by selection of "meeting" or "date"
A) to reset the COUNT at the start of a different meeting OR date
B) to STOP the COUNT when there is a gap of 1 or 2 (options)
- A clear trend is when a meeting has at least (3/3) for that particular type (FCDGS) AND it is 1 ahead of ANY other type. Now, it keeps counting until this becomes true and STOPS when there is a gap of 1/2 depending on option chosen.
- Keep in mind it HAS to have 3/3 at start of meeting or it's disqualified.
I have provided you nearly 1.5 months of examples so it should become crystal clear and left out ALL those that don't qualify from what I can see. Keep in mind the first "red highlighted race" on "by Meeting(1)/by Date(2)" works same as possible (it is excluded from the final output) and those races highlighted in green QUALIFY and soon as it returns to NO highlighted race the trend has ended. To make this easy to understand have spaced them over shown the race above and below picked out those races/selections that match the qualifying type (FCDGS). Now "by Meeting (2)/by Date (2)" contains ALL the qualifiers.
The examples show what happens when there is only a single gap although same logic is applied when there is 2 gaps. A gap in this case is when it returns anything but (1,2,3) for the dominant category (Form/Class/Distance/Going/Speed). A double gap (2 gap) is when the same happens two lines (races) in a row, e.g. the dominant category returns something like 9 followed by 9 instead of (1,2 or 3). What I can do is show the chosen programmer past project specification if needed to help fully understand the "Count" feature and the code.
There is another part to this project to follow should you be successful on this one. My previous programmer was outstanding just unable to commit right now so given someone else a chance.
Please have a look and contact me with any questions.