Spudder's Design Tool (SDT)
- D_Hall
- Staff Sergeant 5


- Posts: 1947
- Joined: Thu Feb 07, 2008 7:37 pm
- Location: SoCal
- Has thanked: 11 times
- Been thanked: 44 times
The smaller the value, the better (more accurate results). However, if you go too small it will cause an error.
What's going on behind the scenes....
I wanted the spreadsheet to be of a reasonable size. Sure, I could make a spreadsheet that was 10,000 rows long, but I didn't want to do that. But if you've only got a small(ish) number of rows, then picking a time step between each state (row) in the spreadsheet is a non-trivial thing. A small gun will (likely) need small time steps, while a large gun (Vera!) might need very large time steps.... Assuming you want the spreadsheet to run to the spud exiting the muzzle that is.
So I try to pick a time step intelligently. I first make a very crude guesstimate of muzzle energy. That gives me a (crude estimate of) muzzle velocity. I then assume constant acceleration and determine how long it would take a projectile to clear the muzzle. If you use a time scaler of 1.0.... That's the nominal length of time the spreadsheet will cover. 0.5 will be half as long. 2.0 will be twice as long. I'm sure you get it by now....
But smaller scalers means smaller time steps. That means more accurate results. Larger scalers means larger time steps. That means less accurate results.
But if the scaler is TOO small, the spreadsheet doesn't "cover" enough time and the projectile will still be somewhere in the barrel when the last calculation is run.
I'd like to pick my timestep a bit more intelligently, but for now... It'll do.

