LT sheet at FRD site updated

Discussion in 'Archived Threads 2001-2004' started by Jeff Rosz, Jan 26, 2003.

  1. Jeff Rosz

    Jeff Rosz Second Unit

    Joined:
    Sep 24, 2000
    Messages:
    335
    Likes Received:
    0
    Trophy Points:
    0
    just a heads up for yas.
     
  2. AndersP

    AndersP Stunt Coordinator

    Joined:
    May 17, 2002
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    0
    Sorry, but what´s the FRD site?
     
  3. Jeff Rosz

    Jeff Rosz Second Unit

    Joined:
    Sep 24, 2000
    Messages:
    335
    Likes Received:
    0
    Trophy Points:
    0
    oh, sorry here's the link. lots of good stuff there.

    to anyone in the know(Anthony G. perhaps?):wrt the LT sheet there, i have noticed a few quirks on the sheet. would anyone care to answer some questions?

    jack, no prob [​IMG]
     
  4. AndersP

    AndersP Stunt Coordinator

    Joined:
    May 17, 2002
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    0
    Thanx, it shure was![​IMG]
     
  5. Isaac C

    Isaac C Stunt Coordinator

    Joined:
    Aug 1, 2000
    Messages:
    140
    Likes Received:
    0
    Trophy Points:
    0
     
  6. I haven't worked on that spreadsheet for some time but I can try to help
     
  7. Pete Mazz

    Pete Mazz Supporting Actor

    Joined:
    May 17, 2000
    Messages:
    761
    Likes Received:
    0
    Trophy Points:
    0
    So far, I've noticed it won't import old file formats.
    It doesn't calculate Vd correctly.
    I've always had to play with driver diameter to get correct Sd.

    The expanded driver/wiring section is nice![​IMG]

    Pete
     
  8. Pete Mazz

    Pete Mazz Supporting Actor

    Joined:
    May 17, 2000
    Messages:
    761
    Likes Received:
    0
    Trophy Points:
    0
    Jack, I agree. Would be much easier. Why enter driver diameter at all, really?

    Xmax may be the culprit. It looks like peak/peak gets the correct calculations and graphs going. Didn't take notice on the Tumult.

    Pete
     
  9. Pete Mazz

    Pete Mazz Supporting Actor

    Joined:
    May 17, 2000
    Messages:
    761
    Likes Received:
    0
    Trophy Points:
    0
    Input Buffer control gives me runtime error 1004 - Unable to set the Colorindex property of the font class.

    The "Exceeded Max Excursion/Amplifier Power" popups no longer work.

    I miss the toggle up/down control on the Power Applied cell.

    Pete
     
  10. I forget why Diameter was used. I think it was in one of the earlier codings. I changed it a while back to Sd, but for some reason, it got re-coded to Diam. As far as anything involving macros/VB, you will have to talk with Paul on those.
     
  11. Jeff Rosz

    Jeff Rosz Second Unit

    Joined:
    Sep 24, 2000
    Messages:
    335
    Likes Received:
    0
    Trophy Points:
    0
    i go to work and look what i miss..
    jack and pete found eveything i did.
    however the input buffer button locks the whole thing(on my comp anyway). sometimes i have to minimize the whole sheet several times for any changes to take effect. might be my version of excel though, excel 97.

    the array section is a nice addition but a might confusing, i had to play with it and look at the formulas to figure it out....the user entered number in cell B20 "isobaric series" must be 1. otherwise you get division by 0 in cell B11 "comp drivers". maybe this is as it should be, i dunno?

    so for a tummy, do we use 34 or 68 for xmax? edit: nevermind, one way, thx jack. just changed it to 34 and save file.

    and a general question i have is about box stuffing...so i design a box with stuffing for a certian Q. naturally, Vb decreases due to stuffing. the LT sheet calls for Vb & fsc & Q. do i enter my params "as stuffed" or enter the unstuffed numbers?

    "It doesn't calculate Vd correctly." it doesnt? is Vd not xmax*Sd?

    thanks
     

Share This Page