Need help creating program

Discussion in 'Software Development' started by vipersf, Sep 25, 2008.

Not open for further replies.
1. Hello all,

I would like to create a very very easy (for you guys probably) program.
Now I know really nothing about programming, so I was wondering if you could help me out here.

Attached is an excell file which I currently use to calculate the rate of descend for an aircraft. But it's not usefull to have to fill the data in everytime in that file.

Therefore what I'm looking for is a stand alone .exe that would:

1) Calculate the "Start Descend Distance". This after input of current and desired altitude, rate of descend and ground speed. (UPPER PART of .xls)

2) Calculate the "Rate of descend". This after input of current and desired altitude, distance and ground speed. (LOWER PART of .xls)

Could you help me with this fairly easy (if you know what you're doing that is) program ??

Any help appreciated

Vipersf

Attached Files:

• Descend Calculator.xls
File size:
14.5 KB
Views:
92
2. Should be easy to make some code for you 3. I would be so gratefull !!!

Looking forward to seeing the .exe

4. Any progress -Fabez - ?

5. Bump

6. bump

7. Could you post the equations for start dscent distance rate of decent please.

8. -Fabez- i'm not sure what you mean so I will post everything I can offer you ... I hope this contains all you need !!

As said before:

The program should be able to do two options:

Option 1: Calculate the "Start Descend Distance". This after input of current and desired altitude, rate of descend and ground speed. (UPPER PART of .xls)

Option 2: Calculate the "Rate of descend". This after input of current and desired altitude, distance and ground speed. (LOWER PART of .xls)

In option 1:
Current Altitude (A2) = <input variable>
Desired Altitude (B2) = <input variable>
Rate of descend (C2) = 1800 (by default !)
Feet to descend (D2) = A2-B2
Time To Allow for Descent MM:SS (E2) = (((D2/C2)-INT(D2/C2))*0.6)+INT(D2/C2)
Ground Speed (Kts) (F2) = <input variable>
Distance (NM) covered per Minute (G2) = F2/60
Sart Descent Distance (NM) From Target (H2) = G2*(D2/C2)

In option 2:
Current Altitude (A7) = <input variable>
Desired Altitude (B7) = <input variable>
Rate of descend (C7) = (D7/E7)
Feet to descend (D7) = (A7-B7)
Time To Allow for Descent MM:SS (E7) = INT(H7/(F7/60))+((F7/60)-INT(F7/60))/0.6
Ground Speed (Kts) (F7) = <input variable>
Distance (NM) covered per Minute (G7) = F7/60
Sart Descent Distance (NM) From Target (H7) = <input variable>

9. bump

10. bump

11. bump

12. can anyone help me. i am new to this.

i want to save an excel worksheet as the content of a spacific cell. anyone know how.

13. Hi Archroom,

Would you mind opening a new topic ?
General rule: 1 problem = 1 topic.

Welcome to TechGuy ... these people are very professional and I'm sure they'll help you out

14. bump

15. The following is Python code, sorry it took so long. If you find any mistakes I will fix them, if you have any questions I will be happy to help you. The calculations may be incorrect as the way you posted them was slightly confusing, if so could you post the calculations again and I will correct them for you Code:
print "Plane Calc Program"
print "Please choose either one or two"
Choice=int(raw_input("Choice: "))
if Choice==1:
CurrentAlt=float(raw_input("Current Altitude: "))
DesiredAlt=float(raw_input("Desired Alritude: "))
RateOfDes=float(raw_input("Rate of desent: "))
if RateOfDes=="":
RateOfDes=1800
FeetToDes=CurrentAlt-DesiredAlt
TimeToDes=((FeetToDes/RateOfDes)-(FeetToDes/RateOfDes)*0.6)+(FeetToDes/RateOfDes)
GroundSpeed=float(raw_input("Ground Speed: "))
DistCoveredPerMin=GroundSpeed/60
StartDesDist=DistCoveredPerMin*(FeetToDes/RateOfDes)
print "Feet to desend: "
print FeetToDes
print "Time to desend: "
print TimeToDes
print "Distance covered per minute: "
print DistCoveredPerMin
print "Start desend distance from target: "
print StartDesDist
elif Choice==2:
CurrentAlt=float(raw_input("Current Altitude: "))
DesiredAlt=float(raw_input("Desired Alritude: "))
StartDesDist=float(raw_input("Start desent distance: "))
GroundSpeed=float(raw_input("Ground Speed: "))
FeetToDes=CurrentAlt-DesiredAlt
TimeToDes=StartDesDist/(GroundSpeed/60)+(GroundSpeed/60)-(GroundSpeed/60)/0.6
RateOfDes=(FeetToDes/TimeToDes)
DistCoveredPerMin=GroundSpeed/60
print "Feet to desend: "
print FeetToDes
print "Time to desend: "
print TimeToDes
print "Rate of a desent: "
print RateOfDes
print "Distance covered per minute: "
print DistCoveredPerMin

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 733,556 other people just like you!