Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to create a function which defines a pulse wave that rises from
0 to 1, stays at one for a bit, lowers to 0, and stays at zero for a bit. / if (t mod 1) <0.25, V(t) = 4* (t mod 1) | if 0.5 = (t mod 1) 0.25, V(t) = 1 V(t) = | | if 0.75 =(t mod 1) 0.5, V(t) = 1-4* (0.75-(t mod 1)) \ if 1 (t mod 1) 0.75, V(t) = 0 For this pulse wave there are straight rises, falls and flat bottoms and tops, which I need (and which is why a sine wave can't be used). If you're still with me, thanks. I can either put this all into a long excel equation for each cell that I want this in (there will be about 4 'if' statements and 6 'mod' statements) or create a UDF, where the t mod 1 only has to be calculated once. Any idea out there how much faster/ slower as UDF really is in a case like this? Also, can you think of an easier way to create this pulse wave? As a side note, the t in my program has some ROW() and COLUMN() dependence, and there will be 200+ cells filled with this equation (thus, I can't just compute it once and copy the values to each cell). Caculation speed is important because each cell is being calculated as the time, t, is advanced by a timer. Thanks in advance to anyone who takes a stab at this. -Abe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want brackets around my math equation answer? | Excel Worksheet Functions | |||
How do I ? math/excel question | Excel Discussion (Misc queries) | |||
simple math equation | Excel Discussion (Misc queries) | |||
math question Excel 2000 | Excel Programming | |||
Excel 2000 math question, repost | Excel Programming |