SPREADSHEET: import and graph log files

Airboy · **Posted:** Sun Mar 04, 2012 8:06 pm

STI2NR wrote:

I am using open office. The import csv button does not work with macros enabled.

Is there an alternate way to load the log I have??

Please help.

The macros are not compatible with Open Office.

STI2NR · **Joined:** Wed Dec 21, 2011 10:37 pm **Posts:** 429

Airboy wrote:

STI2NR wrote:

I am using open office. The import csv button does not work with macros enabled.

Is there an alternate way to load the log I have??

Please help.

The macros are not compatible with Open Office.

So I have to buy the 140$ excel software? Is there another program you can recommend to use your spreadsheet?

Airboy · **Posted:** Sun Mar 04, 2012 8:37 pm

STI2NR wrote:

Airboy wrote:

STI2NR wrote:

I am using open office. The import csv button does not work with macros enabled.

Is there an alternate way to load the log I have??

Please help.

The macros are not compatible with Open Office.

So I have to buy the 140$ excel software? Is there another program you can recommend to use your spreadsheet?

I bought MS Office 2003 from eBay for ~$40

STI2NR · **Joined:** Wed Dec 21, 2011 10:37 pm **Posts:** 429

Using microsoft office 2010 I open the spreadsheet and it says "document has lost its activex controls" and then it says read only and compatibility mode at the top. none of the buttons work they just get outlined when I click on them.

Airboy · **Posted:** Sun Mar 04, 2012 11:54 pm

Did you change the Macro security settings for Excel to ask for permission when opening files containing macros?

STI2NR · **Joined:** Wed Dec 21, 2011 10:37 pm **Posts:** 429

Airboy wrote:

Did you change the Macro security settings for Excel to ask for permission when opening files containing macros?

Yeah, I also tried it with 2003 excel and the buttons still do not work. It just outlines them like it wants me to move them somewhere.

I am wondering if I am doing it wrong. Is there a way to tell excel to run this file as a workbook not as a spreadsheet? It seems like it wants me to edit the file rather than utilize it as a workbook.

In 2010 excel the macro settings are greyed out.

Strange.

Airboy · **Posted:** Mon Mar 05, 2012 1:41 pm

Are you using PC or Mac?

STI2NR · **Joined:** Wed Dec 21, 2011 10:37 pm **Posts:** 429

Airboy wrote:

Are you using PC or Mac?

Pc, windows xp.

Airboy · **Posted:** Mon Mar 05, 2012 11:11 pm

what you describe sounds like the Macro security level is set to High.

download the spreadsheet file again, in case the file was modified by Open Office or whatever

Start Excel 2003
go to Tools-->Macros-->Security and select Medium security level
close Excel and restart

load freshly downloaded spreadsheet.

If that doesn't work then I don't know.

STI2NR · **Joined:** Wed Dec 21, 2011 10:37 pm **Posts:** 429

I used 2010 excel. Took me forever to find the security settings but that fixed it. Thanks tons!

had to allow vba controls as well to get the buttons to work.

TY2185 · **Joined:** Wed Jan 06, 2010 1:54 pm **Posts:** 1

First time playing with this today. Thanks for all of your hard work on this!

STI2NR · **Joined:** Wed Dec 21, 2011 10:37 pm **Posts:** 429

Airboy, are there instructions anywhere on reading/interpreting the boost/wg interpolation tables?

I am trying to understand what each column is showing after I hit the interpolate button. I am sure this is a great boost tuning tool to utilize once I understand how it works.

Thanks for your valuable time.

Airboy · **Posted:** Wed Mar 21, 2012 1:18 am

STI2NR wrote:

Airboy, are there instructions anywhere on reading/interpreting the boost/wg interpolation tables?

I am trying to understand what each column is showing after I hit the interpolate button. I am sure this is a great boost tuning tool to utilize once I understand how it works.

Thanks for your valuable time.

Not really any instructions. The columns of numbers that are created are all graphed out. They are the Boost Targets and WGDC limits, calculated to include compensations for elevation and air temperature. 18psi in the Boost Target table become some other number when you get to 3500', which is where I am.

STI2NR · **Joined:** Wed Dec 21, 2011 10:37 pm **Posts:** 429

Airboy wrote:

STI2NR wrote:

Airboy, are there instructions anywhere on reading/interpreting the boost/wg interpolation tables?

I am trying to understand what each column is showing after I hit the interpolate button. I am sure this is a great boost tuning tool to utilize once I understand how it works.

Thanks for your valuable time.

Not really any instructions. The columns of numbers that are created are all graphed out. They are the Boost Targets and WGDC limits, calculated to include compensations for elevation and air temperature. 18psi in the Boost Target table become some other number when you get to 3500', which is where I am.

My bad, I thought it was used to help tune boost by using wgdc and comparing it to turbo dynamics to create a new boost target table.

menbolduc001 · **Joined:** Wed Apr 25, 2012 8:01 pm **Posts:** 29

Why do i have this problem is there any option i have to change in the logger?

This is the data page in excel spreadsheet

Thanks

Chris

RomRaider

Forum rules

SPREADSHEET: import and graph log files

Who is online