Current Time: Feb 15, 2019, 01:12:49 pm

File Listing: Minecart Calculator 2.8 |
||||||||||||||||||||||||

Last Updated: Aug 04, 2013, 04:00:40 pm First Created: Jun 22, 2013, 05:12:30 pm Author: fricy
Download Now |
||||||||||||||||||||||||

DescriptionThis is an Excel spreadsheet for calculating minecart speeds, travel distances, roller/ramp placements, etc.Tested and works: Regular tiles with rollers/pushes/track stops, single ramps with regular tracks in between.Works more or less: Straight ramps up to ~25 z levels/200000 speed, ramp spirals with regular tracks/corners in between.Untested/wrong: Long straight ramps, fluids on ramps, speed/tile skipping above 200k.Usage: Data inputColumn D contains the track, it sets the impulse- and friction values according to the features entered. note: If the cart is going faster then the added roller's impulse, the roller will be ignored. ACCEPTED:push: 20000 roller high+: 49990 roller high : 39990 roller low: 19990 roller med: 29990 roller low-: 9990 impulse ramp: 4910 DOWN ramp: 4910 UP ramp: -4890 corner ramp: -10/tick and -1000/tile track : -10 corner: -10/tick and -1000/tile bridge: -10 floor: -200 empty: 0 TS high+: -50000 TS high: -10000 TS med: -500 TS low: -50 TS low-: -10 blank is NOT acceptedColumn F is for calculating friction in water ACCEPTED:blank,0-7 Column G is for calculating friction in magma ACCEPTED:blank,0-7 Additionaly you can enter the "Z level" into any of the cells in column C, if any of the subsequent cells is an up/down ramp the Z level indicator will change accordingly. If you want to delete the number just drag over any of the above/below cell. ResultsDON'T EDIT these:Column A: tiles travelled from roller/push the counter resets to zero when (valid) roller is added Column B: steps that a cart travels Column G: Minecart speed Column H: Cart behaviour: - speed>distance units: SKIP
- max speed: LIGHTSPEED
- >1 tile/step: TELEPORT
- >0,7 t/t: SHOTGUN
- >0,5 t/t: DERAIL MODE
- >0,1 t/t: SAFE
- >0 t/t: SNAIL MODE
- =0 t/t: !!STOP!!
- =0 t/t and cart is on an UP ramp: !Roll again!
Friction values and the accepted text can be modified on the second sheet of the workbook (friction data). If you modify column A (tile types & source) you must sort these columns (A->Z) afterwards, or the formulas won't work! The data column ( B ) can be edited freely. But don't do this. Changelog:2.8
- Refined some of the ramp formulas
- Redid some of the formulas, should be .xls compatible again.
2.6
- Distance calculations:
a: speed b: base friction c: distance units (length of a tile) c_{delta}: lefover distance units n: ticks/tile
n = (sqrt(4a^2+4ab+b^2+8bc)-2a-b)/(2b) -- rounded down c_{delta}=c-na+b((n^2+n)/2)
- Ramp distance units are ~1,4 times longer than regular tiles, but then they compensate for the longer distance. (Partly working)
- Rollers start a cart from the beginning of the roller tile, a push teleports it to the beginning (not the middle!) of the next tile
- Logic checks: ramps/rollers/drop influence a minecart from the
*middle of the previous*tile. Exiting a ramp teleports a cart to the middle of the next tile. - Tile skipping
- Multi-tile rollers are calculated correctly
- No more corner column, corners are entered in D
- Only .xlsx (Excel2007) version.
2.0
- Distance calculations are done with the 1.a formula with some modifications thanks to expwnent's instructions. Almost every calculation is integrer based now.
- Push starts the cart in the middle of the next tile, rollers start in the beginning of the tile
- Shotgun mode added to cart behaviour
- Z level indicator added
- Formating bling-blings
1.5
- Everything except for the "GUI".
- Tile friction is calculated with floating point precision. (was rounded up before) As a result roller speed is correct, testing shows ~1% precision.
- Track stops use rounded up steps to calculate friction. Testing shows this to be true.
- Ramps do not work... They are weird. Rounding up the steps generate too much speed, while using floating point generates too little... I think current release shows ~15% more speed then in DF. Any advice welcome.
1.a
- Merged the impulse and friction columns, it should be easier to design track layouts now. Sideeffect: rollers have tile friction (-10) now, and rollers on ramps only calculate tile friction instead of ramp friction, but as I understand roller mechanics it shouldn't matter much. Please tell me if I'm wrong....
- Improved autocomplete.
- Added impulse ramp, it's just a copy of DOWN ramp for now.
- Modified Column M, it's now a cart behaviour indicator, shows when a cart reaches speed milestones.
- Ramps travel distance is 50000 now. (was 100000 before, some posts indicate it should be half the distance) Max speed is reached after 48 ramps. - testing needed -
- Modified impulse values of rollers. (10000,20500,31500,42500,54000)
- Modified the friction calculations to make up for roller speed changes.
- Added Column D for calculating steps needed to complete the route. - testing needed -
- Multi-tile rollers will not behave correctly...
Enjoy. |
||||||||||||||||||||||||

Checksum / Hash |
||||||||||||||||||||||||

SHA-256: d9ce4496e6f7e95859be6fd3551f69415cff3fbf62ea06eceb983c2df9702f30 |
||||||||||||||||||||||||

IP: logged Commands |
||||||||||||||||||||||||

More From This Author |