Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to add rows and increment averaged amount between them

How to add rows and increment averaged amount between them

How to add rows and increment averaged amount between them

How do you write a program or VB to increase the rows?
Also, any easy way to increment the average amount
between them? I have attached the sample excel file.
The actually data has about 1000 rows.

Original Data Set (5 minutes Snap Shot)

COEFF A                    COEFF B            TIMESTAMP
0.779705644    3.485488892    6/18/2001 0:05
0.778691053    3.4968822                    6/18/2001 0:10
0.779860318    3.496875763    6/18/2001 0:15
0.78243196    3.509756804    6/18/2001 0:20

Final Data Set (would like to change to 1 minute snap shot)    
COEFF A                    COEFF B                    TIMESTAMP
0.779705644    3.485488892    6/18/2001 0:05
0.779502726    3.487767553    6/18/2001 0:06
0.779300000    3.490046215    6/18/2001 0:07
0.779096889    3.492324877    6/18/2001 0:08
0.778893971    3.494603539    6/18/2001 0:09
0.778691053    3.496882200    6/18/2001 0:10
0.778924906    3.496880913    6/18/2001 0:11
0.779158759    3.496880000    6/18/2001 0:12
0.779392612    3.496878338    6/18/2001 0:13
0.779626465    3.496877050    6/18/2001 0:14
0.779860000    3.496875763    6/18/2001 0:15

0.78243196    3.509756804    6/18/2001 0:20


RE: How to add rows and increment averaged amount between them

I have NO idear what you are trying to do?????

Do you want to group the data (eg how many "A values" from 0.779-0.78 etc.)?

Increase what rows? there are a infinite (or close to but at much more than 1000 rows) in an Excel sheet

Best Regards


RE: How to add rows and increment averaged amount between them

He wants a VB program to insert (in this case) 4 rows between each existing row and then take the timestamp and split it evenly through the newly inserted rows.

Sorry, but I would have to rely on insert the first four rows manually, and then copy that new format though the sheet.

Possibly you can record a macro of the first couple of steps, save it, then look at the programming to get you started.

"If you don't use your head, your going to have to use your feet."

RE: How to add rows and increment averaged amount between them

The macro recorder is probably the single most useful tool that you have at your disposal.  

If you record the manual steps involved in your operation, most of the time, the remaining work is to simply figure out how to structure the loop to automate the operation and how to generate the relative cell addressing needed.


RE: How to add rows and increment averaged amount between them

btw... is the data actually linear?  you might want some sort of spline fit and then increment on the spline.


RE: How to add rows and increment averaged amount between them

If I understand you correctly, you want to add new readings to an already existing table and then you want to ensure that the new table is "sorted" according to the times of the readings.  You then want to obtain averages.

Is this correct?

If so, the easiest way to accomplish it is to instert the new readings at the end of the table you already have, and then use the built-in sorting tool.  

Depending on your formatting needs, the best way to ensure that all items are included in any averaging is to use the entire column, and place the result on a separate page, or if you must have the average on the same page, you may consider placing the answer at the top of the table, rather than the bottom (as this location won't change), and use a formula to cover the largest possible number of rows you'll ever have.  As another option, you can use VBA to do the averaging.

If you give me more specific information, I can probably give  you more specific ways of doing what you need.

RE: How to add rows and increment averaged amount between them

how about if you make a second worksheet that uses formulas based on the first sheet to accomplish your goal?

one possible method:

Create 5 lines of sheet2 as follows:
  - first column contains row numbers
  - first row uses the index function to copy a row (one cell at a time) from the other sheet. ex:  =INDEX(Sheet1!B3:B12,INT(A3/5)+1,0)
  - next four rows contain the required functions to interpolate linearly between the 6th row and the 1st (they will not display the right info until later)
Then "copy down" your formulas to fill the sheet.  Your interp'd rows should now show the right info.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close