Link to home
Start Free TrialLog in
Avatar of hermesalpha
hermesalphaFlag for Paraguay

asked on

What would the best programming language and approach be for making a harness racing simulator in Excel?

Would for example Java or GWbasic be a good choice? (If possible to achieve without Excel's VBA.) Or could I benefit from using an online tool such as Unity or Game Maker Studio 2? What about Smalltalk or Ruby? And should I avoid PHP, JavaScript and C++ according to this website?:

https://medium.com/smalltalk-talk/the-three-worst-programming-languages-b1ec25a232c1

I already have a lot of VBA in this Excel, and now want to add a simulator for simulation of each harness race I have handicapped. It would consist of an oval shaped circuit and objects (maximum 15), that represent the horses, running around this circuit, and which I can control by entering values in a table below the circuit. Something like this:

https://www.youtube.com/watch?v=GaDdmlARB10&feature=youtu.be
https://www.youtube.com/watch?v=0jynCeeLAtI

(But my simulation would be an oval shaped circuit, otherwise the same principle with a table below where I can enter values that affect how the race is run/simulated.)

A layout something like this is what I have in mind:

https://www.youtube.com/watch?v=gV_0o40ckf4&t=442s
https://sites.google.com/site/e90e50fx/home/racetrack-chart-with-excel
(The first option would be perfect, if possible in Excel and in Windows 10.)

Of course these kind of layouts would be very good also, but probably not possible in Excel:

https://www.youtube.com/watch?v=i2-aJjgi7mE

So no high requirements on graphics (is not possible anyway in Excel), but on being able to control the race by a lot of parameters I can enter manually.

The principle here is the same as for my simulator, but the graphics and layout is not sufficient:

https://codereview.stackexchange.com/questions/100714/racetrack-in-vba
http://www.ozgrid.com/forum/showthread.php?t=79993
https://github.com/RaymondWise/RaceTrack

I also found this resource about lap time simulation:

http://www.jameshakewill.com/Lap_Time_Simulation.pdf

So it's about moving objects, simulation and modelling.

I would have two choices: Either to code in an editor, or use an online tool such as Unity, Game Maker Studio 2, Game Sparks, Game Editor or SimQuick. What are the pros and cons for either choise?

Or maybe the absolute optimal would be to separate Excel and this simulator. So that I make the simulator as a software, independently of Excel, and then import values for harness racing horses for each race from my harness racing Excel to this simulator software.
ASKER CERTIFIED SOLUTION
Avatar of Steve Krause
Steve Krause
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hermesalpha

ASKER

Thanks, I've also realised after doing some more research that Python seems to be a good option.