Making a program to do calculations

[A_Mediocre_Kangaroo_Farmer]

I'm incapable of writing any sort of program in any language, but I've tried to learn.

 

I'm looking for help to make a program that will allow me to spend less time with a pen and a calculator for my school work.

 

The calculations will basically be starting with two or more coordinates and working out their directional angle and distance relative to eachother.

 

Example:

A: 75612.502 N , 1412.162 E

B: 75637.421 N , 1422.692 E

 

Directional angle of AB = ArcTan( (1422.692-1412.162) / (75637.421-75612.502) ) = 25.4527 Gradian (22.9074 degrees)

Directional angle of AB = ArcTan( (Be-Ae) / (Bn-An)

 

Distance AB = Square root of ( (1412.162-1422.692)^2 + (75637.421-75612.502)^2 = 27.0525

Distance AB = Square root of ( (Ae-Be)^2 + (An-Bn)^2 ) 

 

I'm mostly using gradian instead of degree. 400 units instead of 360 units in a full circle. 1:0.9 ratio

There is also the four quadrants to take into consideration, if delta N or E is negative the angle output needs some more work.

If both delta N and delta E are positive the formula gives the right answer, if dN is negative add 200g(180°), if dN and dE are negative add 200g(180°), if dE is negative add 400g(360°)

 

Functionally I'd like the interface to be something like this:

 

allowing for as many points wanted over 2 and doing the working out for each unique distance and angle and displaying them all.

 

 

 

 

Anyone experienced with programming might be able to point me in the right direction on where I should start. Like what sort of language would be best suited for this?

 

 

 

[JuztBe]

Seems like a fitting task for excel. In output fields you would use the formula where variables are linked to input nodes.

[A_Mediocre_Kangaroo_Farmer]

42 minutes ago, JuztBe said:

Seems like a fitting task for excel. In output fields you would use the formula where variables are linked to input nodes.

Thanks for the response!

I've been looking at some tutorials for Excel now trying to get easy access to everything i need for my little project. But there is one thing I can't find. Probably because I don't really know how to describe it or what it's called.

 

  I want to adjust "automatically" for  the number of points I need to calculate. Like how giving it 2 points gives me 1 line of output and giving it 10 points give me 45 lines of output and 20 points somewhere around 200. The output field would be huge sometimes (and that's mostly the reason I want to make this in the first place) but not always. Do you know any keywords for this sort of thing so I can google it?

[JuztBe]

13 minutes ago, A_Mediocre_Kangaroo_Farmer said:

Thanks for the response!

I've been looking at some tutorials for Excel now trying to get easy access to everything i need for my little project. But there is one thing I can't find. Probably because I don't really know how to describe it or what it's called.

 

  I want to adjust "automatically" for  the number of points I need to calculate. Like how giving it 2 points gives me 1 line of output and giving it 10 points give me 45 lines of output and 20 points somewhere around 200. The output field would be huge sometimes (and that's mostly the reason I want to make this in the first place) but not always. Do you know any keywords for this sort of thing so I can google it?

Never actually tried that with excel. "dynamic" would be most important keyword. dynamic levels seemed like something similar. Maybe charts, outputs, tables could be it as well.

[A_Mediocre_Kangaroo_Farmer]

5 hours ago, JuztBe said:

Never actually tried that with excel. "dynamic" would be most important keyword. dynamic levels seemed like something similar. Maybe charts, outputs, tables could be it as well.

Thanks for turning me onto excel! I went on an excel specific forum and asked for help since I couldn't find anything that seemed to fit. Turns out I was approaching the output completely the wrong way!

[vorticalbox]

15 hours ago, A_Mediocre_Kangaroo_Farmer said:

Thanks for turning me onto excel! I went on an excel specific forum and asked for help since I couldn't find anything that seemed to fit. Turns out I was approaching the output completely the wrong way!

You should post your solution and mark it as solved that way other people searching can find the answer.

[Edwin Dimas]

A more powerfull solution would be Mathlab or a lighter version Scilab, I dont know if you are allowed to use it at school because its almost like cheating  haha but you still have to learn some code.

The thing there is: you have a software designed to make calculus oriented programs. 

You have all math functions already made and ready to call. 

You can make functions, asign values and plot them to see the behavior.

And also you can design your own interface so you can literally make your own and totally personalized advanced calculator.