Lynxmotion Tech Support

www.lynxmotion.com
It is currently Tue May 21, 2013 9:35 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 122 posts ]  Go to page Previous  1 ... 4, 5, 6, 7, 8, 9  Next
Author Message
 Post subject: Re: excel 2007
PostPosted: Fri Mar 27, 2009 3:58 am 
Offline
Robot Guru
User avatar

Joined: Thu Nov 09, 2006 5:46 am
Posts: 2078
Location: Norway
badger1666 wrote:
hi can anyone help
does the pep work ok with later versions of excel ie 2007
or does it have to be 2000 or 2003 ?
i just seem to get errors in import to 2007
thanks
chris

Hi,

I don't have the 2007 version, but I think I tried it ones (dead slow though).

What errors do you get?

_________________
[b]Kåre Halvorsen, Zenta[/b]
-----------------------------------------
Zenta's blog
http://zentasrobots.com/
Zenta's YouTube channel
http://www.youtube.com/ZentaOlbaid
-----------------------------------------


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 27, 2009 8:27 am 
Offline
Robot Guru
User avatar

Joined: Sat Apr 15, 2006 1:42 pm
Posts: 4414
I am runnin excel 2007 and can make PEP work. The version of pep I have is 2.02LM beta.

But when it first loads nuthin works. I finally found there was a message toward the top of the window that said something like:

Security warning: Some active content has been disabled. There is a button near this message called "Options..." In here is an option to enable the active content...

Kurt


Top
 Profile  
 
 Post subject: errors
PostPosted: Fri Mar 27, 2009 3:07 pm 
Offline
Roboteer

Joined: Thu Mar 26, 2009 11:53 am
Posts: 17
hi
the error i get is a runtime error ,13, type mismatch
if i click on debug it then shows me this line,

LastSeqNmbr = Worksheets("Ind.Sekvenser").Cells(RowCounter, 3) ' Store the value..

this happens after i start the pep ok and then load up any of the pre made files of yours ie phoenix 3,4,5
using your instuction manuel

thanks

chris green

ps just tried pep v 1.09 as well but still get the same thing


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 27, 2009 5:11 pm 
Offline
Robot Guru
User avatar

Joined: Thu Nov 09, 2006 5:46 am
Posts: 2078
Location: Norway
Hi, would you mind posting a screenshoot of the Ind.Sekvenser sheet. (Especially the upper left section) after getting the error.

Thanks.

_________________
[b]Kåre Halvorsen, Zenta[/b]
-----------------------------------------
Zenta's blog
http://zentasrobots.com/
Zenta's YouTube channel
http://www.youtube.com/ZentaOlbaid
-----------------------------------------


Top
 Profile  
 
 Post subject: errors
PostPosted: Sat Mar 28, 2009 1:45 am 
Offline
Roboteer

Joined: Thu Mar 26, 2009 11:53 am
Posts: 17
i know this may sound dumb but how do i post a screen shot
its just somthing i have never had to do before :oops:


Top
 Profile  
 
 Post subject:
PostPosted: Sat Mar 28, 2009 3:02 am 
Offline
Robot Guru
User avatar

Joined: Thu Nov 09, 2006 5:46 am
Posts: 2078
Location: Norway
By using photobucket or other websites that support picture upload, then you can post a link to the picture by using the IMG command.

_________________
[b]Kåre Halvorsen, Zenta[/b]
-----------------------------------------
Zenta's blog
http://zentasrobots.com/
Zenta's YouTube channel
http://www.youtube.com/ZentaOlbaid
-----------------------------------------


Top
 Profile  
 
 Post subject: errors
PostPosted: Sat Mar 28, 2009 1:44 pm 
Offline
Roboteer

Joined: Thu Mar 26, 2009 11:53 am
Posts: 17
hi zenta
i gave the photobucket a try hope you can see them ok

http://i589.photobucket.com/albums/ss33 ... oenix4.jpg
http://i589.photobucket.com/albums/ss33 ... oenix3.jpg
http://i589.photobucket.com/albums/ss33 ... enshot.jpg


Top
 Profile  
 
 Post subject: Re: errors
PostPosted: Sat Mar 28, 2009 2:08 pm 
Offline
Robot Guru
User avatar

Joined: Wed Feb 27, 2008 8:59 am
Posts: 3151
Location: Online @ innerbreed.co.uk
badger1666 wrote:


Image highlight link and press (Img) :wink:
Image
Image
Image

_________________
Jonny Poole,
Freelance Concept Art & Animatronics, 3D Art and 3D Modelling, as well as Physical Modelling, Mechanical design, and illustration.
http://www.innerbreed.co.uk/
Create, Innovate, Inspire.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Mar 28, 2009 6:28 pm 
Offline
Robot Guru
User avatar

Joined: Thu Nov 09, 2006 5:46 am
Posts: 2078
Location: Norway
Hi,

The pictures tell more than 1000 words... :wink:
There is something wrong in the import process, did you do exactly what I described in the manual on page 15?

In the import process (when opening the .csv file) remember to select semicolon delimited cells, it seems like the semicolon still are in between the values on your sheet.

_________________
[b]Kåre Halvorsen, Zenta[/b]
-----------------------------------------
Zenta's blog
http://zentasrobots.com/
Zenta's YouTube channel
http://www.youtube.com/ZentaOlbaid
-----------------------------------------


Top
 Profile  
 
 Post subject: errors
PostPosted: Sat Mar 28, 2009 7:08 pm 
Offline
Roboteer

Joined: Thu Mar 26, 2009 11:53 am
Posts: 17
hi zenta
on my version of excel you just open the file there does not seem to be an option to select semicolon delimited
i will look around in the options ,
it just opens up an explorer to find the file you want to open
then opens it up in another window
i have followed the manual it might just be 2007 that the problem ??
theres another thing i noticed when i go to open lets phoenix 5.csv excel
cant see it unless i select all files it ??

regards chris


Top
 Profile  
 
 Post subject: Re: errors
PostPosted: Sun Mar 29, 2009 5:28 am 
Offline
Robot Guru
User avatar

Joined: Thu Nov 09, 2006 5:46 am
Posts: 2078
Location: Norway
badger1666 wrote:
hi zenta
on my version of excel you just open the file there does not seem to be an option to select semicolon delimited
i will look around in the options ,
it just opens up an explorer to find the file you want to open
then opens it up in another window
i have followed the manual it might just be 2007 that the problem ??
theres another thing i noticed when i go to open lets phoenix 5.csv excel
cant see it unless i select all files it ??

regards chris


I'm sorry that I can't help you more since I don't have Excel 2007 to test on. Have you tried the help function on Excel 2007 to see how you import an .csv file correctly?

_________________
[b]Kåre Halvorsen, Zenta[/b]
-----------------------------------------
Zenta's blog
http://zentasrobots.com/
Zenta's YouTube channel
http://www.youtube.com/ZentaOlbaid
-----------------------------------------


Top
 Profile  
 
 Post subject: errors
PostPosted: Sun Mar 29, 2009 7:22 am 
Offline
Roboteer

Joined: Thu Mar 26, 2009 11:53 am
Posts: 17
hi
i think i solved it
in 2007 you click the data tab then text it will open exploerer select the file you want it then open box that you mention check delimit box and away you go no errors
the thing i noticed is the ind.sekvenser screen is now empty except
for the words (vacant sequence/step!!)
and when you play sequence nothing moves on the screen except the six leg boxes, flash active ik!, for one cycle ?
i will try some more thing to get it working

thanks
chris


Top
 Profile  
 
 Post subject:
PostPosted: Sun Mar 29, 2009 8:47 am 
Offline
Robot Guru
User avatar

Joined: Sat Apr 15, 2006 1:42 pm
Posts: 4414
FYI - I also have excel 2007, (wish I was using 2003 :cry: ), I don't get an error when I load the latest version beta of pep that I downloaded. But it gets loaded into what they consider to be compatability mode. They give you a one way to convert to the new 2007 format with all of the new features and the like. Not sure if my data is correct however... I don't have the problem with the ;s showing up, but I get a lot of numbers like 7.10E-14 as pin numbers. I wonder if I cut and paste a couple of rows here if it would work...
Code:
97   Comment   SEQUENCE   STEP   PIN0   PIN1   PIN2   PIN4   PIN5   PIN6   PIN8   PIN9   PIN10   PIN16   PIN17   PIN18   PIN20   PIN21   PIN22   PIN24   PIN25   PIN26   T0   T1   T2   T4   T5   T6   T8   T9   T10   T16   T17   T18   T20   T21   T22   T24   T25   T26   TMAX   TTOTAL   INFO1
140   Flip box   1   1   7.10E-14   0   0   1.80E-13   0   0   0   0   0   0   0   0   1.80E-13   0   0   0   0   0   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   Flip box
   Transition 12s to next pose   1   2   7.10E-14   0   0   1.80E-13   0   0   0   -31.248   -25.278   0   0   0   1.80E-13   0   0   0   0   0   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   Transition 12s to next pose
   0   1   3   7.10E-14   0   0   1.80E-13   0   0   -20   -31.248   -25.278   0   0   0   1.80E-13   0   0   0   0   0   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   
   0   1   4   7.10E-14   0   0   1.80E-13   0   0   -20   1.53E-10   0.000112   0   0   0   1.80E-13   -31.248   -25.278   0   0   0   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   160   


Here are like rows 5-9 of that page...

Kurt


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jun 29, 2009 9:43 am 
Offline
Roboteer
User avatar

Joined: Tue Oct 10, 2006 8:20 am
Posts: 160
Location: Australia
hi zenta,

just wanted to ask you about PWM/deg factor in the PEP setup sheet. Where are these values being used? are these being used as the servo limit values? if yes, then whats the significance in determining the PWM/deg factor?and can you plz elaborate me how have you implemented these values in the code?to me these seem some values being used in some conditional statements during the motion sequences.

thanks,
umar


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jun 29, 2009 12:56 pm 
Offline
Robot Guru
User avatar

Joined: Thu Nov 09, 2006 5:46 am
Posts: 2078
Location: Norway
pyrrhicpk wrote:
hi zenta,

just wanted to ask you about PWM/deg factor in the PEP setup sheet. Where are these values being used? are these being used as the servo limit values? if yes, then whats the significance in determining the PWM/deg factor?and can you plz elaborate me how have you implemented these values in the code?to me these seem some values being used in some conditional statements during the motion sequences.

thanks,
umar


Hi,

They are used to calculate the correct position. I believe I'm using the same method that are used in Visual SEQ. Here is the sub in PEP:

Code:
Sub CalculatePWM(LimitPWMRow As Integer, PWMFactorRow As Integer)
    'Calculate the actual pwm value to each servo, uses PWM/deg factor from PEP sheet Setup
    'Left front leg:
    If TempCoxaDEG >= 0 Then
        'calculate 0 deg to max deg PWM value:
        TempCoxaPWM = Worksheets("Setup").Cells(LimitPWMRow, 3) + (TempCoxaDEG * Worksheets("Setup").Cells(PWMFactorRow, 3))
        'Check MAX limit PWM value:
        If TempCoxaPWM > Worksheets("Setup").Cells(LimitPWMRow, 4) Then
            TempCoxaPWM = Worksheets("Setup").Cells(LimitPWMRow, 4)
        End If
    Else
        'calculate <0 deg to min deg PWM value
        TempCoxaPWM = Worksheets("Setup").Cells(LimitPWMRow, 3) - (TempCoxaDEG * Worksheets("Setup").Cells(PWMFactorRow, 2))
        'Check MIN limit PWM value:
        If TempCoxaPWM < Worksheets("Setup").Cells(LimitPWMRow, 2) Then
            TempCoxaPWM = Worksheets("Setup").Cells(LimitPWMRow, 2)
        End If
    End If
   
    If TempFemurDEG >= 0 Then
        TempFemurPWM = Worksheets("Setup").Cells(LimitPWMRow, 6) + (TempFemurDEG * Worksheets("Setup").Cells(PWMFactorRow, 5))
        'Check MAX limit PWM value:
        If TempFemurPWM > Worksheets("Setup").Cells(LimitPWMRow, 7) Then
            TempFemurPWM = Worksheets("Setup").Cells(LimitPWMRow, 7)
        End If
    Else
        TempFemurPWM = Worksheets("Setup").Cells(LimitPWMRow, 6) - (TempFemurDEG * Worksheets("Setup").Cells(PWMFactorRow, 4))
        'Check MIN limit PWM value:
        If TempFemurPWM < Worksheets("Setup").Cells(LimitPWMRow, 5) Then
            TempFemurPWM = Worksheets("Setup").Cells(LimitPWMRow, 5)
        End If
    End If
   
    If TempTibiaDEG >= 0 Then
        TempTibiaPWM = Worksheets("Setup").Cells(LimitPWMRow, 9) + (TempTibiaDEG * Worksheets("Setup").Cells(PWMFactorRow, 7))
        'Check MAX limit PWM value:
        If TempTibiaPWM > Worksheets("Setup").Cells(LimitPWMRow, 10) Then
            TempTibiaPWM = Worksheets("Setup").Cells(LimitPWMRow, 10)
        End If
    Else
        TempTibiaPWM = Worksheets("Setup").Cells(LimitPWMRow, 9) - (TempTibiaDEG * Worksheets("Setup").Cells(PWMFactorRow, 6))
        'Check MIN limit PWM value:
        If TempTibiaPWM < Worksheets("Setup").Cells(LimitPWMRow, 8) Then
            TempTibiaPWM = Worksheets("Setup").Cells(LimitPWMRow, 8)
        End If
    End If
   
End Sub

_________________
[b]Kåre Halvorsen, Zenta[/b]
-----------------------------------------
Zenta's blog
http://zentasrobots.com/
Zenta's YouTube channel
http://www.youtube.com/ZentaOlbaid
-----------------------------------------


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 122 posts ]  Go to page Previous  1 ... 4, 5, 6, 7, 8, 9  Next

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group