The Normalize Data application was created to help the user make adjustments to a Power Commander III USB (PC3) fuel map. Using as input Throttle Position (TPS), RPM, and Duty Cycle data supplied by a PC3, Air-Fuel Ratio (AFR) data supplied by a Wideband Commander, and a set of Target AFRs created by the user, corrections are calculated and applied to the existing PC3 map file, which is then saved on the PC. Optionally, a copy can be saved to an SD card or can be automatically uploaded to a Dynojet LCD Manager unit. The map can then be easily installed in the Power Commander using the Power Commander Control Center, or via the LCD unit.
There are many processing options available to the user, providing the flexibility to deal with individual situations as needed.
All worksheets have a Help button, and all user-accessible fields have comments associated with them, visible if the user chooses by selecting the applicable menu item or right-click shortcut. These, along with this User Documentation, should provide all of the information needed to allow a person (who is somewhat familiar with the principles of EFI as embodied in Power Commanders, LCD Display Units, and Wideband Commanders) to successfully use this application. It is suggested that the new user review all of the comments and help screens as well as this document before actually attempting to use the application.
The application requires that the following software be installed:
· DynoJet’s Power Commander Control Center if any of the map upload/download functions are needed[1].
· Dynojet’s Liquid Crystal Display (LCD) Manager software if a map is to be uploaded/downloaded using that device.
· Microsoft Excel, 2003 or later.
o 2003 and earlier require a free Microsoft add-on that allows them to utilize 2007 and later file formats.
· Microsoft Windows XP Sp3 or later, 32 or 64 bit.
· An application capable of reading .pdf files.
This is an Excel workbook containing extensive VBA code. It was written as a personal tool, and as a self-teaching exercise[2]. It “ain’t bad”, but don’t expect commercial-grade stuff here.
It is intended to ease the process of correctly modifying maps. It is not a design tool, nor is it a tool to initiate the novice into the mysteries of EFI. The user is expected to have a good grasp of why a target AFR is appropriate at a given loadpoint—for instance.
It was originally written using Excel 2003 and Windows XP SP3. It was subsequently updated to use Excel 2010. Though the user interface has changed significantly on later versions of MS Office, the application runs correctly. Note that an additional software product (“Excel compatibility Pack”, available free from Microsoft) is needed to use later MS Office file formats on earlier versions. The application has not been tested using those. It has been successfully tested on Windows 7 (32 and 64 bit) and Vista.
Because it uses “macros”, it may not run on specific installations unless security options allowing macros to run are chosen by the user on their own MS Office installation.
It was written and tested using the latest versions of Dynojet's Power Commander Control Center and LCD Display Manager software available at the time (2009). It uses code specific to the data formatting and user interface of those Dynojet products, and it is likely that, while it will calculate the required map adjustments and otherwise operate successfully, it will not actually send the maps to the devices if different versions of those software packages are used.
It has not been tested using the Power Commander V, Wideband Commander II, or other Dynojet products of similar type, nor is there any intent or need to do so. In combination, these products are within limits capable of accomplishing the same goals on their own.
Over time I have created several basic tools and documents related to tuning Harley Davidsons for street and touring. I call this the “Street Power” series, consisting of Street Power 1 – The Fundamentals, Street Power 2 – Tuning the Power Commander USB Without a Dyno, Street Power 3 – Spreadsheet Tuning Aids, and Street Power 4 – A Case Study In Magnetti-Marelli Tuning. ...
Notes:
1). The application and all required test data, images, settings, examples, etc., are included below. I suggest that you download all of it to the same folder. Read both the Readme.txt and the NormalizeData Doc.pdf files first, to understand how it works and how to set it up.
2). Version 5.1.1 and earlier will not work reliably using WIndow 8.1/MS Office 13. Version 5.1.2 will work properly in Windows 8.1 and in Windows 10, including Office versions 13 through 15.
3). To date, no Android "Office" apps will work for this application. While they can display and modify the cells, they do not have the ability to utilize Visual Basic for Applications (VBA).
[1] If the PC3-USB Control Center or the LCD Manager is not installed, all fields, buttons, and functions related to the missing software will be disabled.
[2] I had created some manual spreadsheets to help me calculate corrections to maps, but soon grew tired of cutting and pasting. I was a computer programmer for 30-plus years, but I did not use Visual Basic for Applications (VBA). I decided to see if I could automate the process using VBA, so I taught myself. A pro VB programmer would understandably wonder at the elementary level of coding, and my lack of knowledge of technique, but it works, and it reliably accomplishes what I designed it to do. In the end, that’s all that counts.