# Need help creating program

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.
D

#### Deleted member 252027

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

#### Attachments

• 14.5 KB Views: 92

#### -Fabez-

Should be easy to make some code for you D

#### Deleted member 252027

I would be so gratefull !!!

Looking forward to seeing the .exe

D

#### Deleted member 252027

Any progress -Fabez - ?

D

Bump

D

bump

#### -Fabez-

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

D

#### Deleted member 252027

-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>

D

bump

D

bump

D

bump

#### Archroom

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.

D

#### Deleted member 252027

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

D

bump

#### -Fabez-

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``````

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.