Desarrollo del Algoritmo:

Cálculo del tiempo necesario para realizar una ruta a pie, según desnivel y distancia

En HTML

<html>
<head>

<script>
function calcular() {
 

<!---ENTRADA DATOS---<
c1=eval(document.getElementById('desnivel').value);
c2=eval(document.getElementById('distancia').value);
 

<!---CONSTANTES---->

c3=eval(document.getElementById('kmhora').value);
c4=eval(document.getElementById('desniveliz').value);
c5=eval(document.getElementById('desnivlin').value);
c6=eval(document.getElementById('disteliz').value);
c7=eval(document.getElementById('distlin').value);
c8=eval(document.getElementById('kheliz').value);
c9=eval(document.getElementById('khlin').value);
c10=eval(document.getElementById('metminreal').value);
c11=eval(document.getElementById('metminrepo').value);
c12=eval(document.getElementById('correcdesn').value);
 

<!---VARIABLES--->
c13 = c1/c2
c14 = (c3*1000)/60
c15 = (c3+c8+c9)/3
c16 = (c15*1000)/60
c17 = c6/c3/1000
c18 = c7/c3/1000
c19 = c4/c6
c20 = c5/c7
c21 = c19*c20
c22 = c16-c14
c23 = c19-c20
c24 = c21-c13
c25 = c23/c22
c26 = c24/c25
c27 = c14+c26
c28 = c10*c11/c27
c29 = c13/c28
c30 = (c28*c29)/((c27*60)/1000)*c12
c31 = c2*c28
c32 = c31*c30
c33 = (c27*60)/1000
c34 = (c2/c33/1000)*60
c35 = c31+c32
c36 = c34+c35
c37 = c36/60

document.getElementById('form13').value=c13;
document.getElementById('form14').value=c14;
document.getElementById('form15').value=c15;
document.getElementById('form16').value=c16;
document.getElementById('form17').value=c17;
document.getElementById('form18').value=c18;
document.getElementById('form19').value=c19;
document.getElementById('form20').value=c20;
document.getElementById('form21').value=c21;
document.getElementById('form22').value=c22;
document.getElementById('form23').value=c23;
document.getElementById('form24').value=c24;
document.getElementById('form25').value=c25;
document.getElementById('form26').value=c26;
document.getElementById('form27').value=c27;
document.getElementById('form28').value=c28;
document.getElementById('form29').value=c29;
document.getElementById('form30').value=c30;
document.getElementById('form31').value=c31;
document.getElementById('form32').value=c32;
document.getElementById('form33').value=c33;
document.getElementById('form34').value=c34;
document.getElementById('form35').value=c35;
document.getElementById('form36').value=c36;
document.getElementById('form37').value=c37;

}

</script>
</head>
<body>

ENTRADA DE DATOS:</p>
<input type="number" id="desnivel" value="0" onkeyup="calcular()" size="20" ></p>
<input type="number" id="distancia" value="0" onkeyup="calcular()" size="20"></p>

CONSTANTES</p>

<input type="text" id="kmhora" value="5" disabled="disabled" size="20" ></p>
<input type="text" id="desniveliz" value="1500" disabled="disabled" " size="20" size="20"></p>
<input type="text" id="desnivlin" value="1600" disabled="disabled" size="20" ></p>
<input type="text" id="disteliz" value="48000" disabled="disabled" size="20" ></p>
<input type="text" id="distlin" value="15500"disabled="disabled" size="20" ></p>
<input type="text" id="kheliz" value="4.6" disabled="disabled" size="20" ></p>
<input type="text" id="khlin" value="3" disabled="disabled" size="20" ></p>
<input type="text" id="metminreal" value="76.33" disabled="disabled" size="20" ></p>
<input type="text" id="metminrepo" value="0.00065" disabled="disabled" size="20" ></p>
<input type="text" id="correcdesn" value="115" disabled="disabled" size="20" ></p>

VARIABLES</p>
<input type="text" id="form13" disabled="disabled" size="20" ></p>
<input type="text" id="form14" disabled="disabled" size="20" ></p>
<input type="text" id="form15" disabled="disabled" size="20" ></p>
<input type="text" id="form16" disabled="disabled" size="20" ></p>
<input type="text" id="form17" disabled="disabled" size="20" ></p>
<input type="text" id="form18" disabled="disabled" size="20" ></p>
<input type="text" id="form19" disabled="disabled" size="20" ></p>
<input type="text" id="form20" disabled="disabled" size="20" ></p>
<input type="text" id="form21" disabled="disabled" size="20" ></p>
<input type="text" id="form22" disabled="disabled" size="20" ></p>
<input type="text" id="form23" disabled="disabled" size="20" ></p>
<input type="text" id="form24" disabled="disabled" size="20" ></p>
<input type="text" id="form25" disabled="disabled" size="20" ></p>
<input type="text" id="form26" disabled="disabled" size="20" ></p>
<input type="text" id="form27" disabled="disabled" size="20" ></p>
<input type="text" id="form28" disabled="disabled" size="20" ></p>
<input type="text" id="form29" disabled="disabled" size="20" ></p>
<input type="text" id="form30" disabled="disabled" size="20" ></p>
<input type="text" id="form31" disabled="disabled" size="20" ></p>
<input type="text" id="form32" disabled="disabled" size="20" ><p>

<input type="text" id="form33" disabled="disabled" size="20" ></p>
<input type="text" id="form34" disabled="disabled" size="20" ></p>
<input type="text" id="form35" disabled="disabled" size="20" ></p>
<input type="text" id="form36" disabled="disabled" size="20" ></p>
<input type="text" id="form37" disabled="disabled" size="20" ><p>

 

</body>

</html>



EXCEL

CONCEPTOS

CELDAS

Desnivel acumulado de ascenso en metros:

C1

Distancia del recorrido en metros:

C2

Km/hora en movimiento en llano:

C3

Desnivel acumulado Pamplona Elizondo (m)

C4

Desnivel acumulado ruta circular Linza (m)

C5

Distancia ruta Pamplona - Elizondo

C6

Distancia ruta circular Linza

C7

Km/hora ruta Pamplona - Elizondo

C8

Km/hora ruta circular Linza

C9

Metros por minuto en marcha

C10

Minutos por metro de reposo

C11

Factor de corrección del desnivel

C12

Ratio desnivel/distancia:

C13

Metros/minuto en movimiento:

C14

km/hora movimiento:

C15

Metros/minuto en movimiento:

C16

Tiempo de 5 km/hora aplicado a la ruta Pamplona-Elizondo (horas):

C17

Tiempo de 5 km/hora aplicado a la ruta circular Linza (horas):

C18

Ratio desnivel/distancia ruta Pamplona-Elizondo:

C19

Ratio desnivel/distancia ruta circular Linza:

C20

Ratio circular Linza x ratio Pamplona-Elizondo:

C21

Diferencia m/min Linza -Elizondo:

C22

Ratio desnivel de referencia:

C23

Diferencia Ratio desnivel real con Ratio desnivel de referencia:

C24

Constante m/min en movimiento:

C25

Diferencia metros/minuto:

C26

Metros/minuto en movimiento:

C27

Minutos/metro en reposo:

C28

Factor pendiente:

C29

Factor desnivel:

C30

Minutos teóricos en llano:

C31

Minutos añadidos por pendiente y desnivel:

C32

Km/hora en movimiento:

C33

Total minutos en movimiento:

C34

Total minutos de reposo:

C35

Tiempo total (En minutos):

C36

Tiempo total (En horas):

C37

 

CELDAS

FÓRMULAS

 

C1

 

IN-

C2

 

PUT

C3

5

C

C4

1500

O

C5

1600

N

C6

48000

S

C7

15500

T

C8

4,6

A

C9

3

N

C10

76,33333333

T

C11

0,00065

E

C12

115

S

C13

C1/C2

 

C14

(C3*1000)/60

V

C15

(C3+C8+C9)/3

A

C16

(C15*1000)/60

R

C17

C6/C3/1000

I

C18

C7/C3/1000

A

C19

C4/C6

B

C20

C5/C7

L

C21

(C19*C20)

E

C22

C16-C14

 

C23

C19-C20

 

C24

C21-C13

 

C25

C23/C22

 

C26

C24/C25

 

C27

C14+C26

 

C28

C10*C11/C27

 

C29

C13/C28

 

C30

(C28*C29)/((C27*60)/1000)*C12

C31

C2*C28

 

C32

C31*C30

 

C33

(C27*60)/1000

S

C34

(C2/C33/1000)*60

A

C35

C31+C32

L

C36

C34+C35

I

C37

C36/60

D

 

 

A