Home  |  Forums  |  914 Info  |  Blogs
 
914World.com - The fastest growing online 914 community!
 
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG. This site is not affiliated with Porsche in any way.
Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners.
 

Welcome Guest ( Log In | Register )

> SOT: Excel Help, Engine Data Log
McMark
post Jul 6 2005, 10:51 PM
Post #1


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
I don't know Excel very well. Can anyone help make me a graph of this data? I need the small numbers (<100) scaled up so that I can actually see the info. All I can do is get them overlapped at the bottom. (IMG:http://www.914world.com/bbs2/html/emoticons/wacko.gif)

http://www.914world.com/members/markd/misc/datalog.xls

Thanks.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
2 Pages V  1 2 >  
 Reply to this topicStart new topic
Replies(1 - 19)
smrz914
post Jul 6 2005, 11:07 PM
Post #2


Soon to be brightening the life of the person behind you.
**

Group: Members
Posts: 456
Joined: 21-April 03
From: Pleasant Hill, CA or Chico, CA
Member No.: 596
I opened up the file and columns A-E are highlighted. Is this the data you want graphed? Headings for the columns would be nice so I know what is being graphed vs. what (ie. x-axis is RPM and y-axis is HP).
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 6 2005, 11:24 PM
Post #3


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
A-E are what I want. If I knew how to title the columns I would have.

They are:

A: RPM
B: Timing
C: MAP
D: TPS
E: Injector Pulse Width

(IMG:http://www.914world.com/bbs2/html/emoticons/biggrin.gif) Thanks
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Jake Raby
post Jul 6 2005, 11:26 PM
Post #4


Engine Surgeon
*****

Group: Members
Posts: 9,394
Joined: 31-August 03
From: Lost
Member No.: 1,095
Region Association: South East States
Mark, is that Kit Carlson FI values?? Its hard to tell.

If so I already have a spreadsheet made up for mapping a 3D table for them.

It seriously helped the interpolation of the values for me given the resolution of his system...
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 6 2005, 11:29 PM
Post #5


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
Yeah, it's KitCarlson. Any help would be appreciated. I'm just getting started with the data logging and Excel is kicking my ass right now.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Jake Raby
post Jul 6 2005, 11:35 PM
Post #6


Engine Surgeon
*****

Group: Members
Posts: 9,394
Joined: 31-August 03
From: Lost
Member No.: 1,095
Region Association: South East States
email me
productdevelopment@aircooledtechnology.com
I'm at that computer now and will shoot the file on over ASAP.

It has my final fuel map for my 2056 that was using Kit Carlson already loaded into it.. (IMG:http://www.914world.com/bbs2/html/emoticons/clap.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 6 2005, 11:37 PM
Post #7


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
Email sent.

Just in case, my email is markd@mac.com
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Jake Raby
post Jul 7 2005, 12:11 AM
Post #8


Engine Surgeon
*****

Group: Members
Posts: 9,394
Joined: 31-August 03
From: Lost
Member No.: 1,095
Region Association: South East States
Reply sent..
I gave you an added toy to play with as well while I was at it... (IMG:http://www.914world.com/bbs2/html/emoticons/boldblue.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 7 2005, 12:24 AM
Post #9


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
Yipee! (IMG:http://www.914world.com/bbs2/html/emoticons/wink.gif) Got them. Nice stuff. (IMG:http://www.914world.com/bbs2/html/emoticons/boldblue.gif) Thanks.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
grantsfo
post Jul 7 2005, 12:37 AM
Post #10


Arrrrhhhh!
****

Group: Members
Posts: 4,327
Joined: 16-March 03
Member No.: 433
Region Association: None
Mark, Let me know if Jakes spreadsheet does the trick. I can setup a spreadsheet with chart that graphs these data points.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Jake Raby
post Jul 7 2005, 12:43 AM
Post #11


Engine Surgeon
*****

Group: Members
Posts: 9,394
Joined: 31-August 03
From: Lost
Member No.: 1,095
Region Association: South East States
No sweat!

Play with that extra one I sent and see what true CR is with cam changes- Its good stuff!
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 7 2005, 12:53 AM
Post #12


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
QUOTE (grantsfo @ Jul 6 2005, 10:37 PM)
Mark, Let me know if Jakes spreadsheet does the trick. I can setup a spreadsheet with chart that graphs these data points.

Jakes spreadsheet is a 3D graph of the VE table. I'd still like to see a graph of my data log. More info = better choices/understanding. (IMG:http://www.914world.com/bbs2/html/emoticons/wink.gif) I'm uploading a much larger XLS file with more data. (IMG:http://www.914world.com/bbs2/html/emoticons/boldblue.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 7 2005, 12:24 PM
Post #13


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
(IMG:http://www.914world.com/bbs2/html/emoticons/icon_bump.gif) Can someone make me a pretty graph?
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Part Pricer
post Jul 7 2005, 12:38 PM
Post #14


Believe everything I post
***

Group: Benefactors
Posts: 1,825
Joined: 28-December 02
From: Danbury, CT
Member No.: 35

I made a graph. I wouldn't really call it pretty though.



Attached thumbnail(s)
Attached Image
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 7 2005, 12:59 PM
Post #15


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
Close! There's a line graph that doesn't plot the data points. (IMG:http://www.914world.com/bbs2/html/emoticons/clap.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Part Pricer
post Jul 7 2005, 01:05 PM
Post #16


Believe everything I post
***

Group: Benefactors
Posts: 1,825
Joined: 28-December 02
From: Danbury, CT
Member No.: 35
Like this?


Attached thumbnail(s)
Attached Image
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 7 2005, 01:31 PM
Post #17


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
Sumthin' weird about that. Doesn't look like my real data. (IMG:http://www.914world.com/bbs2/html/emoticons/confused24.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Part Pricer
post Jul 7 2005, 01:46 PM
Post #18


Believe everything I post
***

Group: Benefactors
Posts: 1,825
Joined: 28-December 02
From: Danbury, CT
Member No.: 35
QUOTE (McMark @ Jul 7 2005, 03:31 PM)
Sumthin' weird about that. Doesn't look like my real data. (IMG:http://www.914world.com/bbs2/html/emoticons/confused24.gif)


That's probably because I sorted the data by ascending by RPM. Here is the picture of the data as sent.



Attached thumbnail(s)
Attached Image
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
McMark
post Jul 7 2005, 01:48 PM
Post #19


914 Freak!
***************

Group: Retired Admin
Posts: 20,179
Joined: 13-March 03
From: Grand Rapids, MI
Member No.: 419
Region Association: None
(IMG:http://www.914world.com/bbs2/html/emoticons/clap.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Air_Cooled_Nut
post Jul 7 2005, 02:18 PM
Post #20


914 Ronin - 914 owner who lost his 914club.com
***

Group: Members
Posts: 1,748
Joined: 19-April 03
From: Beaverton, Oregon
Member No.: 584
Region Association: None
Here's what I came up with, without sorting the RPM values.
How do you attach an Excel file?


Attached thumbnail(s)
Attached Image
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
« Next Oldest · 914World Garage · Next Newest »
 

2 Pages V  1 2 >
Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 17th May 2024 - 02:05 PM
Invision Power Board v9.1.4 © 2024  IPS, Inc.
All rights reserved 914World.com © since 2002
914World.com is the fastest growing online 914 community!
We have it all, classifieds, events, forums, vendors, parts, autocross, racing, technical articles, events calendar, newsletter, restoration, gallery, archives, history and more for your Porsche 914 ...