jakestew
Posts: 144
Score: 180 Joined: 8/13/2011 Last Login: 5/18/2013 From: Moscow,
ID, USA Status: offline
|
New Release! v0.98b6 is now on the site! Changes... -Changed table calculations to load a minimum of 7 instead of 0. This should make the processor always fire a spark, even if it's late. -Added the ability to save and load curves -Spreadsheet will now generate the HEX file! No compiler needed! -Too many spreadsheet changes and tweaks to list. -All settings now stored in the table, so everything changes when you change the table switch! Since this is still a beta version the spreadsheet has not been protected or locked in any way. Nothing has been hidden from the user, except empty rows and columns. So be careful to only edit what you need to change and to not accidentally change cells you shouldn't be changing. This version will generate the hex, but remember that it's not compiling anything. It is just entering the table data into a precompiled hex. I highly suggest not even clicking on the "HEX_Calcs" sheet. There is nothing for the user to edit on the "Table_Values", "Code", and "HEX_Calcs" sheets, so do not edit anything on these sheets. The "Copy Code" button is on the "Code", sheet though BTW. I tried to make things easy with the color coding and buttons. Green = settings/cells you can change Red = calculated values used in the program Yellow = intermediate or informational cells Blue = Various information or settings that should not normally be changed by the user The default curves that come with this sheet are based on replicating the stock ignition on my 4-stroke engine, which has a fixed 25 degree advance. This might not work well on your engine, so don't load it if you think it won't work! Quick run through on the spreadsheet... The first thing you need to know is that you must turn on macros for the spreadsheet to work right. When you first open the spreadsheet excel will pop up a bar across the top about a security warning. Click what you need to so that macros are turned on. You can also go into excel options and change the settings related to this or make it always trust this specific spreadsheet file. If you don't trust me to run macros on your computer or somehow get this file from a untrustworthy source then you can still use the spreadsheet. None of the buttons will work, so you will have to manually copy the source code into a file, manually copy the table values, and paste them into the source code, then compile the source. To do this just edit everything how you want, then copy cell G3 from the "Table_Values" sheet and paste it into the source code at the proper place, repeat with cell N3, then compile. Sheet 1, "Setup_Settings" -Put in your hall sensor degrees BTDC. My program times from when the magnet approaches, so it will probably seem 1-2 deg. MORE compared to programs that time from when the magnet leaves the sensor. If you use a 30 deg. magnet/sensor position, it will probably be 31-33 deg. according to my system. To find this just load up a fixed advance flat curve and time the motor to see where the spark hits, then adjust the Hall Deg. setting so the spark hits where it should. Finding this and adjusting it in the program should be easier than trying to move the sensor/magnet around! -Set your "Est. Start RPM" and "Start Advance deg." settings. 5 deg. advance is suggested for easy starting, so the main thing you have to figure out is how fast you are spinning the engine when you are starting it. Probably around 200-500 for handstarting, higher if you use a mechanical starting device or pull start. * This doesn't actually change anything anymore! It's just for seeing the calculations* Start RPM is now down lower in the user settings for each advance table, and the start advance degree is taken from the "0 RPM" setting in the advance curve. There is also a deg to digi-deg calculator in the top right cells of the page. -The rest of the settings are related to the MSD feature. With the default settings it will throw three sparks at start up, and two sparks from there until it hits 916 RPM. Otherwise it should only throw one spark. These settings should work best for most people, only change them if you want to try playing with the MSD feature. Sheet 2, "Advance_Curves" -Here is where you program your advance curves. -You can change the RPM set points and the advance settings. -Don't cross your points. That means they should all be in order from lowest to highest. -Point 0 is for starting, Point 500 is for 120-915 RPM. You can't change these points, but you can change the advance setting for them. -You can use the buttons to change the values. If you need a specific value you can key it into the cell. -Hitting tab instead of enter makes excel move to the right instead of down. This makes it easy to key in the values. -The graph shows your curve line in blue, the back-calculated setting is shown by the red line. -Red points at the top, bottom, and in the line show where the actual control points are according to the table (CurrentRev), these can't be changed. -Use the red marks and line to see what effect your curve is having on the actual table values. -You can go above the red line, but the red line represents what is actually put into the table and where sparks will actually fire. -You can use the button to copy your settings down to table two. Use this to quickly align your control points or change the curves. If you want to swap 2 -> 1 then use one of the save slots on the "Saved_Curves" sheet. Sheet 2, "Saved_Curves" -Here you have 6 slots to save and load curves -The preview button loads the saved curve into the graph at the bottom so that you can see it before loading it. -The load buttons load the saved curve into table 1 or 2 on the "Advance_Curves" sheet. -The save buttons save curve 1 or curve 2 into the save slot. -Loading/saving curves does NOT change the user settings, except for the start and low_rpm advances. -Always double check your other settings and remember that they are not saved with the curves. -The sheet will prompt you to name the curve and will automatically save the date and time. Finishing up! Once all your settings are right you can go to the first sheet and click "Copy HEX". This copies the hex file into your clipboard. Open a text editor, hit paste, then save the file with a .hex extension. You're now ready to program your PIC with the most advanced CDI program ever created! (and the programmer is as humble as he is skilled) -Jake
_____________________________
http://www.electrofunnel.com/CDI-2012/index.htm
Hide Signatures
|