i was wondering if anyone knew the math formula for figuring out your running pace, if you plugged it into a regular calculator. im trying to create a running calculator, like the ones you find on some websites.
something like
pace = (((total time * 60 /)/distance)/60))
Take the answer of your formula round down / truncate to get the number of minutes. Take the formula answer modulo the number of minutes and multiply by 60 to get the number of seconds. e.g15:20 over 3.1m -> 920 seconds -> 296.77 sec / mile -> 4.94 min/mile, so 4 minutes and 4.94 mod 4 = .94 min -> .94* 60 = 56 seconds4:56 per mile
runningcalculator wrote:
i was wondering if anyone knew the math formula for figuring out your running pace, if you plugged it into a regular calculator. im trying to create a running calculator, like the ones you find on some websites.
something like
pace = (((total time * 60 /)/distance)/60))
If you are using Excel start in cell A1 (the upper left-hand corner of all the boxes shown). Then, follow the description below:
a) click on "format" and then select "cells";
b) next, find "custom" at the bottom of the open white window and select it;
c)clear the little window that pops up and input the format of time you want. For example, let's say you want to input 5k times; input "mm:ss.0"; which give you minutes, seconds and tenths (you could put two zeroes; if you want hundrethds of a second). Note; be sure to input either one or two zeroes rather than the letter "O."
d) select "ok" at the bottom of the window in the gray area. Now, you are back to where you started (in cell A1);
e) input the time you want to the cell A1; let's ay 15:00.0 (which is 15 minutes even with zero tenths of a second);
f) copy the time you input to cell A1 to a different cell (let's say cell B1, which is adjacent and to the direct right of cell A1). To copy simply press CTRL C, and then to paste in cell B1 just press CTRL V;
g) then, input specific comman instructions to cell B1, which refer (back) to cell A1. Example for cell B1: =A1/3.106856, which gives you the average per mile split of 15:00.0, which is in cell A1. When you click "enter" on your keyboard (after you input the formula to cell B1), the answer (4:49.68 - your per mile split) will show up;
h) if you want to figure out percentages of 5k pace for training purposess; copy cell B1 to C1. Then, type in a formula such as "=B1/.75". Once you tap "enter" on your keyboard, the time "6:26.24" will be present. That's your 75% speed of 5k pace.
Your Excel should look like this:
"A" column "B" column "C" column
15:00.00 04:49.68 06:26.24
Hopefully, when I select "Post Message" the alignment will look the same as when I am typing this.
Take care & good luck!
Tinman
Now that you mention it, I've always had one persistent problem with using timestamps in Excel with fractional seconds. Displaying them, and using the values in formulas is not a problem, but how do you manually input a time, with a non-zero tenths or hundredths of a second? Reading them from a text file is also problematic. For example, suppose my 5K time is "15:05.3". I have never managed to manually input this time, without Excel thinking it is just text (failing to recognize that it is a time that matches the cell format). I always have to invent expressions like "=15/1440+5.3/86400" to get a value that can be further manipulated in expressions.Is there some simple setting I've got wrong somewhere? I use some European formats rather than US formats, e.g. for displaying dates.
Tinman wrote:
If you are using Excel ...
e) input the time you want to the cell A1; let's ay 15:00.0 (which is 15 minutes even with zero tenths of a second);
...
Take care & good luck!
Tinman
im programming in visual basic, i was wondering how you would type an equation in so that it could figure it out using any mod arithmetic,depending on what the user put in? currently i only have
TextBox1.Text = (((TextBox2.Text * 60) / TextBox4.Text) / 60 Mod 6)
which would only work for 6 to 6:59 mile pace
I know Java but am not that familiar with VB but I pretty sure you want something like thisSomething like:Dim sec as IntegerDim min as IntegerDim value As Singlevalue = CSng((TextBox2.Text * 60) / TextBox4.Text))min = INT(value)sec = value mod minTextBox1.Text = Str$(min) & ":" & Str$(sec)
runningcalculator wrote:
im programming in visual basic, i was wondering how you would type an equation in so that it could figure it out using any mod arithmetic,depending on what the user put in? currently i only have
TextBox1.Text = (((TextBox2.Text * 60) / TextBox4.Text) / 60 Mod 6)
which would only work for 6 to 6:59 mile pace
Sorry meant:Dim sec as SingleDim min as IntegerDim value As Singlevalue = CSng((TextBox2.Text * 60) / TextBox4.Text))min = INT(value)sec = (value mod min) * 60TextBox1.Text = Str$(min) & ":" & Str$(sec)
runningcalculator wrote:
im programming in visual basic, i was wondering how you would type an equation in so that it could figure it out using any mod arithmetic,depending on what the user put in? currently i only have
TextBox1.Text = (((TextBox2.Text * 60) / TextBox4.Text) / 60 Mod 6)
which would only work for 6 to 6:59 mile pace
[/quote]
Dim sec as SingleDim min as IntegerDim value As Singlevalue = CSng(((TextBox2.Text * 60) / TextBox4.Text))/60)min = INT(value)sec = (value mod min) * 60TextBox1.Text = Str$(min) & ":" & Str$(sec)
runningcalculator wrote:
im programming in visual basic, i was wondering how you would type an equation in so that it could figure it out using any mod arithmetic,depending on what the user put in? currently i only have
TextBox1.Text = (((TextBox2.Text * 60) / TextBox4.Text) / 60 Mod 6)
which would only work for 6 to 6:59 mile pace
[/quote][/quote]
one other question
how would you allow 26:20 being put in to the text box? how would you convert it?
times are pretty easy to work with in excel
the trick is, as noted before, is when entering time values into a cell, explicity key in the tenth of a second even if it zero tenths, so excel doesnt read 16:30 as 16 hours 30 minutes.
once you key it in ok, you wont have parse out hours, minutes and seconds to get your paces, percent of time etc, just do normal math
like 6:05.0 in cell a1
then cell b1 can be formula of "= a1 * 3.1" to get 5k time, etc
most anything you would want to calculate can be done directly from excel without using VBA code. post back if you have something specific you dont know how to do
it is a little difficult to parse strings in visual basic, no easy function like in java that I know of. You can use left function to return a string that is a number of char from the left side of the string.
Dim inMin as Integer
Dim inSec as Integer
inMin = Left$(TextBox2.Text, 2)
inSec = Right$(TextBox2.Text, 2)
Of course this would only work if you allowed the input was only in the format xx:xx. If you want a more complicated method then you should use
i = Len(":") to get the position of ":" then use a loop to get all of the char up to that position and the char after ":"
Actually len("string") gives you the length of a string not the position of a char within a stringYou would have to get the length of the string then loop until the current char = ":" and put all the previous char into a string. Then do the same from ":" to the end. A real pain.
Right Track wrote:
it is a little difficult to parse strings in visual basic, no easy function like in java that I know of. You can use left function to return a string that is a number of char from the left side of the string.
Dim inMin as Integer
Dim inSec as Integer
inMin = Left$(TextBox2.Text, 2)
inSec = Right$(TextBox2.Text, 2)
Of course this would only work if you allowed the input was only in the format xx:xx. If you want a more complicated method then you should use
i = Len(":") to get the position of ":" then use a loop to get all of the char up to that position and the char after ":"
Nevermind. By explaining the problem, I just managed to give myself the clue to my own solution. The European format I was using for dates all along, "dd.mm.yy", using the period "." as a separator, was interfering with the interpreting "hh:mm:ss.0" correctly.This may seem like nothing, and probably is to the rest of the world, but solves a long standing pet peeve of mine. What a relief!Now if I could really run a 15:05.3, that would resolve another long standing problem!
Mr. Ray wrote:
Now that you mention it, I've always had one persistent problem with using timestamps in Excel with fractional seconds. Displaying them, and using the values in formulas is not a problem, but how do you manually input a time, with a non-zero tenths or hundredths of a second? Reading them from a text file is also problematic. For example, suppose my 5K time is "15:05.3". I have never managed to manually input this time, without Excel thinking it is just text (failing to recognize that it is a time that matches the cell format). I always have to invent expressions like "=15/1440+5.3/86400" to get a value that can be further manipulated in expressions.
Is there some simple setting I've got wrong somewhere? I use some European formats rather than US formats, e.g. for displaying dates.
I have a question for "Numbers Guy"...i was trying to figure this out and ran into a problem. How did you get the answer in your second step " 920 seconds"...when i calculate it i get 912 for this step..im confused because i see that you are right..PLEASE HELP ME ASAP