Shop OBEX P1 Docs P2 Docs Learn Events
StampDAQ — Parallax Forums

StampDAQ

ArchiverArchiver Posts: 46,084
edited 2003-09-08 03:20 in General Discussion
Gentlemen:

If you have not downloaded StampDAQ from Parallax you are missing out on a
fantastic program - for free!!

I am presently using this program to read a display in REAL TIME three ADC
readings at high speed. In fact, it is practically a digital scope. If you
are fairly good with ADCs and with Excel you will find this program
fascinating.
The possibilities are endless - monitoring pressure, voltage, temperature or
what have you.

Try it out - www.parallaxinc.com, seach for "StampDAQ".

I have no connection at all with Parallax - I just know something good when I
see it.

Sid - W4EKQ


[noparse][[/noparse]Non-text portions of this message have been removed]

Comments

  • ArchiverArchiver Posts: 46,084
    edited 2002-08-09 13:16
    Hey all,

    I am familiar with the basic stamp.. I just ordered a bs2p24 for use
    at work ( I am introducing the POWER of the Stamp to my co-workers!)
    and I am interested in using StampDAQ. My question is if anyone know
    if there is a way to have time-stamping in EXCEL that has a better
    resolution than .1 seconds? I want to record the response of a
    system for use in PID tuning and I want to have a speed vs. time
    graph for which I will need to get the time in mS if possible.

    Thanks,

    J. Manning
  • ArchiverArchiver Posts: 46,084
    edited 2002-08-09 13:32
    I don't think it's possible in Excel. You could attach an RTC to your BS2p
    and send the data yourself -- perhaps just as an offset to the intial reading.

    -- Jon Williams
    -- Parallax

    In a message dated 8/9/02 7:18:31 AM Central Daylight Time,
    jay_mann2000@y... writes:


    > I am familiar with the basic stamp.. I just ordered a bs2p24 for use
    > at work ( I am introducing the POWER of the Stamp to my co-workers!)
    > and I am interested in using StampDAQ. My question is if anyone know
    > if there is a way to have time-stamping in EXCEL that has a better
    > resolution than .1 seconds? I want to record the response of a
    > system for use in PID tuning and I want to have a speed vs. time
    > graph for which I will need to get the time in mS if possible.
    >
    > Thanks,
    >
    >




    [noparse][[/noparse]Non-text portions of this message have been removed]
  • ArchiverArchiver Posts: 46,084
    edited 2002-08-09 13:50
    jon,

    That is what I thought. Quick question: Should the example StampDAQ
    program stream data into the excel spreadsheet? I just installed it
    and it doesn't seem to be working correctly.

    Thanks,
    J. Manning

    --- In basicstamps@y..., jonwms@a... wrote:
    > I don't think it's possible in Excel. You could attach an RTC to
    your BS2p
    > and send the data yourself -- perhaps just as an offset to the
    intial reading.
    >
    > -- Jon Williams
    > -- Parallax
    >
    > In a message dated 8/9/02 7:18:31 AM Central Daylight Time,
    > jay_mann2000@y... writes:
    >
    >
    > > I am familiar with the basic stamp.. I just ordered a bs2p24 for
    use
    > > at work ( I am introducing the POWER of the Stamp to my co-
    workers!)
    > > and I am interested in using StampDAQ. My question is if anyone
    know
    > > if there is a way to have time-stamping in EXCEL that has a
    better
    > > resolution than .1 seconds? I want to record the response of a
    > > system for use in PID tuning and I want to have a speed vs. time
    > > graph for which I will need to get the time in mS if possible.
    > >
    > > Thanks,
    > >
    > >
    >
    >
    >
    >
    > [noparse][[/noparse]Non-text portions of this message have been removed]
  • ArchiverArchiver Posts: 46,084
    edited 2002-08-09 14:10
    In a message dated 08/09/2002 08:52:16 Eastern Daylight Time,
    jay_mann2000@y... writes:


    > That is what I thought. Quick question: Should the example StampDAQ
    > program stream data into the excel spreadsheet? I just installed it
    > and it doesn't seem to be working correctly.
    >

    For Jay

    I have made some changes to the Excel format which you might like. When you
    get your answers from Jon drop me an e-mail.

    Sid


    [noparse][[/noparse]Non-text portions of this message have been removed]
  • ArchiverArchiver Posts: 46,084
    edited 2002-08-09 14:11
    Another question:
    How do I set the baud rate to something higher than 9600? Is this possible and
    will doing so help me gain program speed/loop time?
    Thanks,
    J. Manning
    jonwms@a... wrote:I don't think it's possible in Excel. You could attach an
    RTC to your BS2p
    and send the data yourself -- perhaps just as an offset to the intial reading.

    -- Jon Williams
    -- Parallax

    In a message dated 8/9/02 7:18:31 AM Central Daylight Time,
    jay_mann2000@y... writes:


    > I am familiar with the basic stamp.. I just ordered a bs2p24 for use
    > at work ( I am introducing the POWER of the Stamp to my co-workers!)
    > and I am interested in using StampDAQ. My question is if anyone know
    > if there is a way to have time-stamping in EXCEL that has a better
    > resolution than .1 seconds? I want to record the response of a
    > system for use in PID tuning and I want to have a speed vs. time
    > graph for which I will need to get the time in mS if possible.
    >
    > Thanks,
    >
    >




    [noparse][[/noparse]Non-text portions of this message have been removed]


    To UNSUBSCRIBE, just send mail to:
    basicstamps-unsubscribe@yahoogroups.com
    from the same email address that you subscribed. Text in the Subject and Body of
    the message will be ignored.


    Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




    Do You Yahoo!?
    HotJobs, a Yahoo! service - Search Thousands of New Jobs

    [noparse][[/noparse]Non-text portions of this message have been removed]
  • ArchiverArchiver Posts: 46,084
    edited 2002-08-09 19:02
    Try the TIMER function.

    Here is a sample.

    Create a command button on your excel form then past in this function

    Private Sub CommandButton1_Click()
    i = InputBox("Enter a larger number for the delay", "", 1000000)
    s = Timer

    For x = 0 To i
    'simple delay
    Next

    e = Timer

    MsgBox (" start = " & s & vbCrLf & " end = " & e & vbCrLf &
    "elapsed = " & e - s)
    End Sub


    Mike Witherspoon


    Original Message
    From: jonwms@a... [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=51zHXUJDmWWKZtshvJSLffPwhWcF60aA6w6yHRRZmmZguS_UP-ogVSKSfKC149wj0ATimo9n5wuI]jonwms@a...[/url
    Sent: Friday, August 09, 2002 5:32 AM
    To: basicstamps@yahoogroups.com
    Subject: Re: [noparse][[/noparse]basicstamps] StampDAQ


    I don't think it's possible in Excel. You could attach an RTC to your BS2p
    and send the data yourself -- perhaps just as an offset to the intial
    reading.

    -- Jon Williams
    -- Parallax

    In a message dated 8/9/02 7:18:31 AM Central Daylight Time,
    jay_mann2000@y... writes:


    > I am familiar with the basic stamp.. I just ordered a bs2p24 for use
    > at work ( I am introducing the POWER of the Stamp to my co-workers!)
    > and I am interested in using StampDAQ. My question is if anyone know
    > if there is a way to have time-stamping in EXCEL that has a better
    > resolution than .1 seconds? I want to record the response of a
    > system for use in PID tuning and I want to have a speed vs. time
    > graph for which I will need to get the time in mS if possible.
    >
    > Thanks,
    >
    >




    [noparse][[/noparse]Non-text portions of this message have been removed]


    To UNSUBSCRIBE, just send mail to:
    basicstamps-unsubscribe@yahoogroups.com
    from the same email address that you subscribed. Text in the Subject and
    Body of the message will be ignored.


    Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
  • ArchiverArchiver Posts: 46,084
    edited 2002-08-13 10:05
    I made an adaptation to StampDAQ adding an additional directive,
    TIMER. This will place into a cell the time in seconds (to 3 decimal
    places) since the last connection, and may be reset through software
    using the directive of TIMER_RESET. It is NOT midnight friendly
    (don't collect data from before to after midnight).

    The file is posted at: (with sample code in the spreadsheet)

    http://groups.yahoo.com/group/basicstamps/files/StampDAQ/
    (StampDAQ with Timer.xls)
    Save locally before using.

    Also note, the time will only be accurate if your computer is fast
    enough to process the data AS it arrives.

    Open to more good suggestions that many may benefit from for an
    update to StampDAQ in the future.

    As far as baud rate, do you mean changing it on the Stamp side or the
    StampDAQ side? On the Stamp, see SEROUT in your user manual or help
    files.

    -Martin





    --- In basicstamps@y..., Jay Mann <jay_mann2000@y...> wrote:
    >
    > Another question:
    > How do I set the baud rate to something higher than 9600? Is this
    possible and will doing so help me gain program speed/loop time?
    > Thanks,
    > J. Manning
    > jonwms@a... wrote:I don't think it's possible in Excel. You could
    attach an RTC to your BS2p
    > and send the data yourself -- perhaps just as an offset to the
    intial reading.
    >
    > -- Jon Williams
    > -- Parallax
    >
    > In a message dated 8/9/02 7:18:31 AM Central Daylight Time,
    > jay_mann2000@y... writes:
    >
    >
    > > I am familiar with the basic stamp.. I just ordered a bs2p24 for
    use
    > > at work ( I am introducing the POWER of the Stamp to my co-
    workers!)
    > > and I am interested in using StampDAQ. My question is if anyone
    know
    > > if there is a way to have time-stamping in EXCEL that has a
    better
    > > resolution than .1 seconds? I want to record the response of a
    > > system for use in PID tuning and I want to have a speed vs. time
    > > graph for which I will need to get the time in mS if possible.
    > >
    > > Thanks,
    > >
    > >
    >
    >
    >
    >
    > [noparse][[/noparse]Non-text portions of this message have been removed]
    >
    >
    > To UNSUBSCRIBE, just send mail to:
    > basicstamps-unsubscribe@y...
    > from the same email address that you subscribed. Text in the
    Subject and Body of the message will be ignored.
    >
    >
    > Your use of Yahoo! Groups is subject to
    http://docs.yahoo.com/info/terms/
    >
    >
    >
    >
    >
    > Do You Yahoo!?
    > HotJobs, a Yahoo! service - Search Thousands of New Jobs
    >
    > [noparse][[/noparse]Non-text portions of this message have been removed]
  • ArchiverArchiver Posts: 46,084
    edited 2002-12-01 17:52
    I installed StampDAQ; I opened the simple test code, and then the
    StampDAQ interface in Excel. However, no data appears. These error
    messages popped up: "MS Visual Basic - errors occurred during load"
    and "compile error - sub or function not defined".

    Ctrl-S did not generate the data.

    any hints would be helpful.

    thanks.
  • ArchiverArchiver Posts: 46,084
    edited 2002-12-02 03:27
    Which version of Excel are you running? You need at least
    Office/Excel 2000.

    -Martin


    --- In basicstamps@y..., "engrmaps" <engrmaps@y...> wrote:
    > I installed StampDAQ; I opened the simple test code, and then the
    > StampDAQ interface in Excel. However, no data appears. These
    error
    > messages popped up: "MS Visual Basic - errors occurred during load"
    > and "compile error - sub or function not defined".
    >
    > Ctrl-S did not generate the data.
    >
    > any hints would be helpful.
    >
    > thanks.
  • ArchiverArchiver Posts: 46,084
    edited 2002-12-11 18:48
    Hi,

    I too have problems with the stampDAQ, I don't get any error
    messages but I don't have any data displayed. I have excel 2000.

    Thanx.
  • ArchiverArchiver Posts: 46,084
    edited 2002-12-12 04:19
    Could you please post the code you are using and I will give it a
    test? (or an abbreviated version if very long?).

    Thanks,
    Martin Hebel


    --- In basicstamps@yahoogroups.com, "thekoookooo <thekoookooo@y...>"
    <thekoookooo@y...> wrote:
    > Hi,
    >
    > I too have problems with the stampDAQ, I don't get any error
    > messages but I don't have any data displayed. I have excel 2000.
    >
    > Thanx.
  • ArchiverArchiver Posts: 46,084
    edited 2003-03-25 20:30
    Has anyone been successful in getting StampDAQ to work with Office 97?
  • ArchiverArchiver Posts: 46,084
    edited 2003-03-25 20:55
    In a message dated 03/25/2003 15:32:08 Eastern Standard Time,
    steve.halla@v... writes:


    > Has anyone been successful in getting StampDAQ to work with Office 97?
    >
    >

    DAQ will not work with office97. Martin Hebel, who wrote the program, said
    he was going to work on it. You can contact him at

    martin@s...

    Sid Weaver
    W4EKQ
    Port Richey, FL


    [noparse][[/noparse]Non-text portions of this message have been removed]
  • ArchiverArchiver Posts: 46,084
    edited 2003-09-08 01:32
    Is StampDAQ still available on the Parallax web-sight? I cannot seem to find
    it at the Parallax web-sight.


    [noparse][[/noparse]Non-text portions of this message have been removed]
  • ArchiverArchiver Posts: 46,084
    edited 2003-09-08 03:20
    You can get it from the Yahoo group site
    http://groups.yahoo.com/group/basicstamps/ in the files section.

    >
    Original Message
    > From: smartdim@a... [noparse]/noparse]mailto:[url=http://forums.parallaxinc.com/group/basicstamps/post?postID=igLXYhsvbdyB2o7rjZQGzxkDo2-VphiRG9RqcQcI2irD0DvYDjcZcl6zJVN1VtKD5n8B50mL]smartdim@a...[/url
    > Sent: September 7, 2003 5:32 PM
    > To: basicstamps@yahoogroups.com
    > Subject: [noparse][[/noparse]basicstamps] StampDAQ
    >
    >
    > Is StampDAQ still available on the Parallax web-sight? I cannot
    > seem to find
    > it at the Parallax web-sight.
    >
    >
    > [noparse][[/noparse]Non-text portions of this message have been removed]
    >
    >
    > To UNSUBSCRIBE, just send mail to:
    > basicstamps-unsubscribe@yahoogroups.com
    > from the same email address that you subscribed. Text in the
    > Subject and Body of the message will be ignored.
    >
    >
    > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
    >
    >
    >
Sign In or Register to comment.