RCU Forums - View Single Post - Opensource CDI ignition
View Single Post
Old 05-17-2006 | 05:46 AM
  #136  
lumpylumpy
Junior Member
 
Joined: Feb 2006
Posts: 8
Likes: 0
Received 0 Likes on 0 Posts
From: timisoara, ROMANIA
Default RE: Opensource CDI ignition

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.