[Zasquatch]

Originally Posted by enrita

still not working

You never posted a shot of the data series screen

The fact that it gets through all the code without an error and spits out a graph with color coded series in the legend, means that it is something screwey with the plot area. I wish I could replicate it on my end, it would make things much easier to troubleshoot.

Try this log and see if it plots right:

[BMWsky]

I really appreciate the link you sent me yesterday, thank you. I'm still getting a "Runtime error 5" though.

[Zasquatch]

Originally Posted by nitehawk

Great macro OP, I've been using it alot Any luck adding RPMs on either axis?

v1.4 added, incorporating RPM graphing!

[Zasquatch]

Originally Posted by BMWsky

I really appreciate the link you sent me yesterday, thank you. I'm still getting a "Runtime error 5" though.

Email me your log file and i'll try to replicate it again. zasquatches@gmail.com .
Do you get the error with the file I posted above? Just rename the .txt to .csv and try to plot it.

[BMWsky]

Originally Posted by Zasquatch

Email me your log file and i'll try to replicate it again. zasquatches@gmail.com .
Do you get the error with the file I posted above? Just rename the .txt to .csv and try to plot it.

Cool, I'll try that. Thank you!


Erik

[enrita]

with 1.4 looks like this now . tried both your file and my file

[nitehawk]

Originally Posted by Zasquatch

v1.4 added, incorporating RPM graphing!

Great, thanks! I'm getting an error extracting the v1.4 file though...

[Zasquatch]

Originally Posted by nitehawk

Great, thanks! I'm getting an error extracting the v1.4 file though...

Which one?

[nitehawk]

Originally Posted by Zasquatch

Which one?

Office 07-10

[ar design II]

simply awesome man. great work and an awesome tool for all cobb users!

[Zasquatch]

Originally Posted by enrita

with 1.4 looks like this now . tried both your file and my file

Damn..... I see two problems: 1, your RPM isn't scaling properly, and 2, your left axis still only goes from 0-1. Is this some crazy version of office? lol. At least you are seeing data now though.

I tell you what, I'll try to get a version of 2007 up and running and see if its an isolated 2007 issue. I cannot replicate this behavior on OSX 2011 or Win7 2010.

If you could get a higher res screen shot of the data series menu (i.e. right click on the plot and edit data series or source data) that could be helpful to ensure that the data is in fact plotting somewhere in the plot area.

If its easier you can email the jpgs to the email i listed above.

[Zasquatch]

Originally Posted by nitehawk

Office 07-10

Is anyone else having trouble extracting? Maybe try a newer winzip/winrar/etc?

Send me an email and I can email you the xls directly

[Zasquatch]

Originally Posted by Kai @ AR Design

simply awesome man. great work and an awesome tool for all cobb users!

Thanks Kai, more to come!

[Zasquatch]

Originally Posted by enrita

with 1.4 looks like this now . tried both your file and my file

Enrita, I installed office 2007 and still cannot replicate your issue. It may have to do with your specific system configuration or Office settings. If you can get a shot of the data series screen we can try to figure out what's going on. It's pretty weird that RPM is plotting correct, but nothing else is.... Something screwy is going on here.

[enrita]

Originally Posted by Zasquatch

Enrita, I installed office 2007 and still cannot replicate your issue. It may have to do with your specific system configuration or Office settings. If you can get a shot of the data series screen we can try to figure out what's going on. It's pretty weird that RPM is plotting correct, but nothing else is.... Something screwy is going on here.

its my job laptop, maybe some weird settings there.
by data series you mean the extra tab with the log ?

[Zasquatch]

Originally Posted by enrita

its my job laptop, maybe some weird settings there.
by data series you mean the extra tab with the log ?

Go to the graph tab, right click on the graph, and there should be an option for "source data" or "select data". You don't really have to post a screen shot, but look at the data it is selecting on the other tab and make sure the correct columns are being plotted.

Also, is your RPM being divided by 100? Look at the RPM column and see if the values are or not. It should be an added column all the way to the right of the data.

May be a good idea to go under File>Options>Formulas and make sure that Workbook Calculation is set to Automatic.

[enrita]

Originally Posted by Zasquatch

Go to the graph tab, right click on the graph, and there should be an option for "source data" or "select data". You don't really have to post a screen shot, but look at the data it is selecting on the other tab and make sure the correct columns are being plotted.

Also, is your RPM being divided by 100? Look at the RPM column and see if the values are or not. It should be an added column all the way to the right of the data.

May be a good idea to go under File>Options>Formulas and make sure that Workbook Calculation is set to Automatic.

i give up , i hate excel , just makes me angry

[Zasquatch]

Originally Posted by enrita

i give up , i hate excel , just makes me angry

LOL, if I had a dollar for everytime I've said that......

[Zasquatch]

For some of you having .zip issues, email me for a direct copy. Make sure to mention what version you need. To reiterate, you should be right clicking the PDF, Save Target As, once saved, right click and reaname to .zip, double click, drag the .xls out of the zip into your folder. Every machine i have tested this on has worked.

Also, if you start it up in office 2010 and you click the "Enable editing" security banner then get a Run-time error 91, just click end and continue on as if nothing happened. I don't know why it does this, but it has nothing to do with the functionality.

[DrHeLpErZx]

Couldn't get it to extract with the default unzip utility for Mac OSX, so I had to get stuffit. Though once I did, the program works amazing, donation coming your way in a few days

[Zasquatch]

Originally Posted by ADebelius

Couldn't get it to extract with the default unzip utility for Mac OSX, so I had to get stuffit. Though once I did, the program works amazing, donation coming your way in a few days

Great, thanks!

I use "The Unarchiver" on OSX, I find it works better than the native utility for unarchiving. Let me know if you run into any issues in the future

[DrHeLpErZx]

The Unarchiver works much better than stuffit. Thanks for the suggestion. Also, sent a donation your way. Thanks again for the wonderful program!