ORIGINAL: hogboy
Hi all,
I've downloaded the schematics and pcb layouts from the GOMPY site and constructed it. CDI works well on the bench in test hi and lo modes and with magnet mounted to an electric flywheel the hall sensor fires the circuit well also. Can any one help though with the rotten excel spreadsheet. I've done everything as listed on this post regarding the ADD INNS for excel and still get the DEC@HEX macro problem. I would now like to be able to manipulate the advance curves but can't until I can get spreadsheet working. Also better way of contructing transformer is to use a split ferrite core and bobbin. Wind on 16meters of .2mm, 20 turns of .5mm and 10 turns of .2mm. Look forward to any positive responses to excel problem.
Hi hogboy,
I am also new to this forum and trying to build the CDI too. The excel sheet has an error on the command DEC to HEX. The solution from lumpylumpy is given below.
Could you give some more information on your Transformer, and some specs on the core (core size, type, producer etc)??
Maku.
Hi,i had problems with the exel sheets too,have instaled office severel times,instaled all addins and still not worked! then i did a little research and found out that there is a little error in the formulas calculating the lines for the asm. ; this is how it should loke like =IF(B16<$D$8,CONCATENATE(" ",$E$14,DEC2HEX(D16),$E$15,$A$142,ROUND(D16/10,1),$A$149,INT(B16),$B$14))
and this is how it loked originaly =IF(B40<$D$8,IF(D40>10,CONCATENATE(" ",$E$14,DECHEX(D40,2),$E$15,$A$142,TRUNC(D40/10,1),$A$149,INT(B40),$B$14),CONCATENATE(" ",$E$14,DECHEX(D40),$E$15,$A$142,ROUND(D40/10,1),$A$149,INT(B40),$B$14)),$E$16)
i have deleted a portion of the formula,and where it writes dechex i have replaced it with de2hex,as you could notice in the formula! you have to have the next addins instelled:anallysis toll pack and solver add-in!!!!!!!
you copy the formula in to the first line off the exel (cell e16) and press enter;after that copy/paste on each line until finsh(do not paste severel lines at once, one line at a time so you dont have to modify the formula!!!!)
this is made for the exel map 42 ;you can do the same with the other exel maps,but the formulas not the same! so be careful what you delete from the formula!!!
I hope it helps you,and i did not write it two complicated!I am not so good at english.
rpm adv. nr loops lines to insert into asm.
1,010 6.0 50 retlw 31h ;5ms 1010rpm 1,010 6.0
1,017 6.3 49 retlw 30h ;4.9ms 1016rpm 1,017 6.3
1,024 6.5 48 retlw 2Fh ;4.8ms 1023rpm 1,024 6.5
1,031 6.8 47 retlw 2Fh ;4.7ms 1030rpm 1,031 6.8
1,038 7.0 46 retlw 2Eh ;4.6ms 1038rpm 1,038 7.0
1,045 7.3 46 retlw 2Dh ;4.6ms 1045rpm 1,045 7.3
1,053 7.6 45 retlw 2Dh ;4.5ms 1052rpm 1,053 7.6
this is how it should look like.
Regard ,Zoli.