SOT: Excel Help, Engine Data Log |
|
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. |
|
SOT: Excel Help, Engine Data Log |
McMark |
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. |
smrz914 |
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).
|
McMark |
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 |
Jake Raby |
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... |
McMark |
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.
|
Jake Raby |
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) |
McMark |
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 |
Jake Raby |
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) |
McMark |
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.
|
grantsfo |
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.
|
Jake Raby |
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! |
McMark |
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 |
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) |
||
McMark |
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?
|
Part Pricer |
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) |
McMark |
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)
|
Part Pricer |
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) |
McMark |
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)
|
Part Pricer |
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 |
That's probably because I sorted the data by ascending by RPM. Here is the picture of the data as sent. Attached thumbnail(s) |
||
McMark |
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 |
|
Air_Cooled_Nut |
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) |
Lo-Fi Version | Time is now: 7th June 2024 - 11:47 PM |
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 ... |