I know this is a very beginner type of question, and I apologize if it's a stupid one. For work, I'm looking to create standalone tools to take place of existing Excel spreadsheets that are being used for modeling data. Everything is currently running off of VBA macros and other spreadsheet dependencies. My goal is to create something that works like the existing tools, but in a more streamlined fashion as some of the calculations can take a couple of hours in their current state. Since I have some experience in both Java and Python, but am by no means an expert in either, I'm looking for opinions from the communities before I commit to one specific language. In a nutshell, I want to create a program with a GUI that is able to query an existing Oracle database to pull data into the tool, run the calculations, and create an output file with the summed data. I would also like to handle multiple users, potentially up to 30 simultaneously. I know that overall, this is a pretty simple task for either language, but there's a lot of data and calculations that occur in order for us to get the projected data we're looking for. Also, if there is a tool that can help convert the existing tools to make this conversion happen faster, that would be helpful as well. Continue reading...
