| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
Maybe you don't want code, just a formula in a cell. You limit the two intervals to 100 seconds total at .1 second plot intervals. That means interval 1 could use a maximum of 1000 rows or C7:C1007. Time must increase as it goes down the column, so whatever row interval 1 ends on, it must be the maximum number in that range. The opposite would be true for the last position in column D. It would be the minimum position number. So for interval 2 to begin time in E7, put the formula "=MAX(C7:C1007) + .1" without the quotes. In F7 you would apply your acceleration formula to this "=MIN(D7
 1007)".Does this help any? Mike F "Jeff Ciaccio" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... Thanks Mike, but please forgive me for not being VBA savay. How do I get a different cell to run this sub automatically? For example, I think I'd like to put this to the right of the Starting Poisition (cell C7), so maybe E7 would be "Starting Position for second interval" and F7 would contain the return value from the subroutine. Thanks!! "Mike Fogleman" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... It seems that Interval1 ends from a user input time and is plotted in .1s intervals. So it takes 2s/.1s for Interval 1 to elapse. That is 20. So interval 1 will end 20 cells below the start time cell. If the start time cell is D14, then the end cell is D34. Sub Interval_1() Dim MyVal As Variant Dim intrvl1 As Long, CellCnt As Long intrvl1 = Range("C4").Value 'user input cell CellCnt = intrvl1 / 0.1 MyVal = Cells(14 + CellCnt, 4).Value '14 is start row End Sub Mike F "Jeff Ciaccio" <(E-Mail Removed)> wrote in message news:OS%(E-Mail Removed)... I am trying to wirte a sheet that will plot position vs time for two different time intervals, but I need to capture a value when it changes from interval 1 to interval 2. In the case below, I need to capture the 5, but it won't always be in that cell. I'd really apprecitate any suggestions. THANKS!! This worksheet will plot position vs. time and velocity vs. time for two time intervals up to 100 seconds. Time 1 From 0 sec to: 2.00 sec Time 2 From 2s to: 50.00 sec Starting position: 50.0 m Starting velocity: -22.50 m/s Acceleration from 0 to 2s: 0.00 m/s^2 Acceleration from 2s to 50s: 5.00 m/s^2 time (s) position(m) Interval 1 0 50 Interval 1 0.1 47.75 Interval 1 0.2 45.5 Interval 1 0.3 43.25 Interval 1 0.4 41 Interval 1 0.5 38.75 Interval 1 0.6 36.5 Interval 1 0.7 34.25 Interval 1 0.8 32 Interval 1 0.9 29.75 Interval 1 1 27.5 Interval 1 1.1 25.25 Interval 1 1.2 23 Interval 1 1.3 20.75 Interval 1 1.4 18.5 Interval 1 1.5 16.25 Interval 1 1.6 14 Interval 1 1.7 11.75 Interval 1 1.8 9.5 Interval 1 1.9 7.25 Interval 1 2 5 Interval 2 2.1 Interval 2 2.2 -- Jeff Ciaccio Physics and AP Physics Teacher Sprayberry High School; Marietta, GA Blog: http://sprayberry.typepad.com/ciaccio |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| can you capture info from a cell without retyping in another cell | jallen449 | Microsoft Word Document Management | 1 | 12th Mar 2010 07:04 PM |
| How do capture the first three characters from one cell to another cell | ExcelAlex | Microsoft Excel Misc | 0 | 21st Oct 2004 07:09 PM |
| How do capture the first three characters from one cell to another cell | ExcelAlex | Microsoft Excel Misc | 1 | 21st Oct 2004 07:03 PM |
| Capture a cell value at the end of day. | =?Utf-8?B?R2FyZWQ=?= | Microsoft Excel Worksheet Functions | 1 | 7th Oct 2004 03:30 PM |
| Formula to capture cell location as opposed to cell contents | Dan | Microsoft Excel Worksheet Functions | 0 | 10th Oct 2003 04:00 PM |
