Hey guys, very new here. Never coded Swift, and just beginning with C++, but wanting to make a specific app I've had in mind for a long time. It involves a lot of spreadsheet math and equations, and I was simply wondering if there was some way to reference a table/chart like you can do in Excel?
Basically, based upon 3 numbers that a user inputs, I want a chart to be populated in a very specific manner, and then I want equations to call the values in the chart.
As an example:
If a user inputs "10 RPE" and "2 Reps", I want it to take a certain number (Load) and multiply it by 0.96. Now, I understand that I could just use a bunch of switch case or if else statements, but that would be A LOT of clutter, and I don't want my code to be long and confusing. The reason I say this is because there will be dozens of charts among hundreds of programs which customize these charts. I can post the spreadsheet here if you guys would like to see what I'm referring to.