BMW M3 Forum
BMW M3 Forum BMW M3 Gallery BMW M3 Reviews BMW M3 Social Groups BMW M3 Chat M3Forum Sponsors >>
Loading


Mobile M3forum
Go Back   BMW M3 Forum.com (E30 M3 | E36 M3 | E46 M3 | E92 M3 | F80/X) > BMW M3 Discussions > E46 M3 (2001-2006)
Tire Rack Buy Winter Tires Now!
Not a member? Register Now!
Register Gallery All Albums Garage Search Today's Posts Mark Forums Read Calendar FAQ

E46 M3 (2001-2006) Engine: S54 - Max Hp: 333 hp at 7,900 rpm / 262 lb/ft at 4,900 rpm
Total Produced: 45,000+ - Years Produced: 2001 to 2006.


Reply
 
Thread Tools Display Modes
Old Mon, Jan-02-2017, 08:34:40 AM   #1
STAATS
Registered User
 
STAATS's Avatar
 
Join Date: May 2015
Posts: 438
In the garage:
Reputation: 0 STAATS is on a distinguished road

Australia




Default BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Okay so I finally finished and got around to posting this. Basically I created an all encompassing vehicle log book, for tracking servicing, maintenance, parts on hand, performance, etc.

It is a macro-enabled Workbook so i have had to host on my Google Drive:
https://drive.google.com/drive/folde...UE?usp=sharing

Once downloaded you need to fill in your car details on the front tab (optional) and then all your vehicle default settings, minimums and maximums etc (mandatory). Then on the settings tab you need to enter the folders you want it to export completed service checklists and maintenance worksheets too... Then it should be good to go... it is only in BETA stage so may have some issues...

Here is a basic feature list:
- Service Checklist based on BMW Dealer Service Checklist
- Record Service Checklist information in the Service Log at the click of a button (Record Service Work feature is macro-enabled)
- Reset Service Checklist for new service at the click of a button (New Service Work feature is macro-enabled)
- Auto-updating Service Dashboard shows graphs for brake pad/disc thickness, battery charge and other measurements taken during service (macro-enabled)
- Auto-updating Service Dashboard also automatically compares service intervals against the service log and checks service measurements against min and max measurements to provide system health messages (high level traffic light system and error readout system)
- Maintenance Worksheet built to track major maintenance or vehicle upgrades
- Record maintenance work in the Maintenance log at the click of a button (Record Maintenance Worksheet is macro-enabled)
- Detailing Checklist
- Driving Log
- Other partially implemented features and tracking logs

Here is a few basic screenshots (they are a bit poor as I had to zoom out for some):
Overview of Vehicle Details tab:


Overview of Vehicle Settings tab:


Overview of Service Dashboard:


Example of macro-enabled buttons (always the same style throughout the workbook):


The service checklist, detailing checklist and Car Setup Sheet and Log are the same basic structure and functionality ones I have already posted here before (now just with macro-enabled features and a dashboard):
Service Checklist - http://www.m3forum.net/m3forum/showt...ghlight=staats
Detailing Checklist - http://www.m3forum.net/m3forum/showthread.php?t=563054
Car Setup sheet & log - http://www.m3forum.net/m3forum/showthread.php?t=563059

Apologies the pictures no longer work, I will try fix this when I get time.

Last edited by STAATS; Thu, Aug-17-2017 at 01:16:19 AM. Reason: Updated to Google Drive and unlocked macro
Jump to top STAATS is offline   Reply With Quote
Sponsored Links
Register now and remove these ads
Old Mon, Jan-02-2017, 08:44:23 AM   #2
STAATS
Registered User
 
STAATS's Avatar
 
Join Date: May 2015
Posts: 438
In the garage:
Reputation: 0 STAATS is on a distinguished road

Australia




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Please feel free to have a look at the non-macro-enabled tools and then download this tool and have a play... I did notice that I built this on my work computer without any issues but a few of the macro-enabled features gave me "400" errors and just didn't execute on my home computer... so it is possible only some of the features will work...

Post any comments, improvements, errors etc... I can't promise I will fix them or take them on board but if I have time I will have a look... I will also post any improvements etc that I make as I develop the tool and start to use it when I get my car back on the road...

(For the moment I plan to leave the macro-code locked, for those of you who find you can't view the code or try to edit it... this is mainly because I put a lot of effort and time into this and as much as I am happy to freely share my work i don't know if I am ready to leave it open to changing or the potential for people to distribute and claim as their own... those who test, provide comments, look to help me improve and happen to know VBA may get unlocked versions )

Last edited by STAATS; Mon, Jan-02-2017 at 08:45:22 AM. Reason: Amending some omissions and addition of extra note
Jump to top STAATS is offline   Reply With Quote
Old Mon, Jan-02-2017, 08:50:51 AM   #3
Flow
Registered User
 
Flow's Avatar
 
Join Date: Mar 2011
Posts: 2,850
In the garage:
Reputation: 0 Flow is on a distinguished road
Location: France

France




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

That looks awesome. Downloading right now
Thank you very much for the share !
__________________
- Florian • E46 M3 tightening torques PDF
2004 M3 • TiAg / LSB • SMG
Jump to top Flow is offline   Reply With Quote
Old Mon, Jan-02-2017, 08:54:46 AM   #4
Flow
Registered User
 
Flow's Avatar
 
Join Date: Mar 2011
Posts: 2,850
In the garage:
Reputation: 0 Flow is on a distinguished road
Location: France

France




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Excel for mac has issues with the file... that's sad
__________________
- Florian • E46 M3 tightening torques PDF
2004 M3 • TiAg / LSB • SMG
Jump to top Flow is offline   Reply With Quote
Old Mon, Jan-02-2017, 11:23:58 AM   #5
SocratesRising
Chess is King
 
SocratesRising's Avatar
 
Join Date: Jan 2013
Posts: 1,473
In the garage:
Reputation: 0 SocratesRising is on a distinguished road
Location: Capital Region, NY

United States




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Thanks so much! Incredible detail, functional as well as looking great. Nicely done.
__________________

Slicktop * Cloth Seats * AS SSK * Besian

2018 Mercedes Benz E63S Edition 1 Night Black Magno
2018 Porsche GTS Cabriolet Carmine Red
2017 Audi R8 V10 Suzuka Gray
2016 AMG GTS Edition 1 Selenite Grey
2012 Mercedes Benz C63 AMG Black Series Obsidian Black
2002 BMW M3 Imola Red

“All the great things are simple, and many can be expressed
in a single word: freedom, justice, honor, duty, mercy, hope.”

― Winston S. Churchill
Jump to top SocratesRising is offline   Reply With Quote
Old Mon, Jan-02-2017, 11:38:03 AM   #6
0-60Motorsports
Established 1998....
 
0-60Motorsports's Avatar
 
Join Date: Mar 2004
Posts: 14,693
In the garage:
Reputation: 0 0-60Motorsports is on a distinguished road
Location: Al Manama, Bahrain

Bahrain




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Awesome!!! Thanks
__________________
EURO 04 M3 Mods: GC DA's / Eibach Sways / PF RTABs / RE RCAs / INTRAVEE II / ///MFEST Badges / M5 SMG Knob / VCSL: Bumper + Race Lip, CF Trunk, CF Diffusor / DIETZ TV in Motion / SuperSprint: Stepped Headers, Cat Deletes, Res X-pipe, Sport Muffler / Z8 Starter Button / Lamin-X / STM Paddles / OEM CSL: Steering, Interior, Intake, CF Roof / Terra MSS54HP CSL Clone + TTFS Tune / BBS CH's, LIGHTWERKZ / ST40's / DINAN RSB / RE Race Brace / BW Oil Cooler / 3.91 gears / Radium OCC
Jump to top 0-60Motorsports is online now   Reply With Quote
Old Tue, Jan-03-2017, 02:12:22 AM   #7
STAATS
Registered User
 
STAATS's Avatar
 
Join Date: May 2015
Posts: 438
In the garage:
Reputation: 0 STAATS is on a distinguished road

Australia




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Quote:
Originally Posted by Flow View Post
Excel for mac has issues with the file... that's sad
Sorry about that one mate

I don't know if Office for Mac has VBA integrated? not sure but as I don't screw around with Mac...

I'm glad you guys like it... it's mainly the result of having a lot of free time at work and a desire to learn VBA haha...
Jump to top STAATS is offline   Reply With Quote
Old Wed, Jan-04-2017, 12:29:33 AM   #8
skru_fase
Registered User
 
skru_fase's Avatar
 
Join Date: Oct 2009
Posts: 112
Reputation: 0 skru_fase is on a distinguished road
Location: Toronto

Canada




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Awesome work. Feel like doing one for the E92 M3?
Jump to top skru_fase is offline   Reply With Quote
Old Wed, Jan-04-2017, 08:05:35 AM   #9
v1rotate1
Registered User
 
v1rotate1's Avatar
 
Join Date: May 2011
Posts: 935
In the garage:
Reputation: 0 v1rotate1 is on a distinguished road
Location: Huntington Beach

United States




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Great idea. Thanks for sharing
__________________
Jump to top v1rotate1 is offline   Reply With Quote
Old Wed, Jan-04-2017, 08:36:37 AM   #10
Flow
Registered User
 
Flow's Avatar
 
Join Date: Mar 2011
Posts: 2,850
In the garage:
Reputation: 0 Flow is on a distinguished road
Location: France

France




Default Re: BMW E46 M3 Vehicle Log Book & Service Tracker Tool

Quote:
Originally Posted by STAATS View Post
Sorry about that one mate

I don't know if Office for Mac has VBA integrated? not sure but as I don't screw around with Mac...
Excel for mac has basic VBA now, but a lot of commands are missing.
With advanced VBA code, I always get in trouble
__________________
- Florian • E46 M3 tightening torques PDF
2004 M3 • TiAg / LSB • SMG
Jump to top Flow is offline   Reply With Quote
Reply

Bookmarks

Tags
log book, service

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT. The time now is 09:41:12 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
M3Forum.com and M3forum.net is in no way sponsored, endorsed or affiliated by or with BMW NA / BMW AG or any of it's subsidiaries or vendors.
BMW and M3 (E90 M3 | E92 M3 | E93 M3 | E46 M3 | E36 M3 | E30 M3) are registered trademarks of BMW AG.
M3Forum Terms of Service
Copyright ©1999-2017 M3Forum.com
Discussing Turner's new monoball FCABs in the E46 M3 (2001-2006) Forum - Engine: S54 - Max Hp: 333 hp at 7,900 rpm / 262 lb/ft at 4,900 rpm
Total Produced: 45,000+ - Years Produced: 2001 to 2006. at BMW M3 Forum.com (E30 M3 | E36 M3 | E46 M3 | E92 M3 | F80/X)