rickets007

Making perfect loops with Excel

Recommended Posts

I still don't really get it but, is it possible to do corkscrews?

Share this post


Link to post

to be honest, i dont understand how to use this...

i guess i'll be doing loops the old way.

Share this post


Link to post

You need to explain more or a video or something.

Share this post


Link to post

Well, entering the parameters is pretty straightforward so I think you may be having trouble exporting the data. You need to select everything in yellow on the left. You will see that each line is one object and there are always 96 lines. If you enter in a smaller number in the '# of pieces' field you only need to select the lines of code up to and including that number. Then paste all this into a text editor. The file will contain many tab spaces you need to convert the tab spaces to regular spaces. This can be done with the replace feature. You can not type a tab space so you will have to highlight a tab space and copy/paste into the find field. Once the tab spaces have been converted to regular spaces you may add the code to your map file.

Share this post


Link to post
Sure they are, they are perfect loops! I recommend you to try that map. :P

The 2 maps I posted are testing maps of repeating loops to let you guys see that there can be driven on it and to let you guys know how to let it repeat, I don't think I can help Rickets007 about how to improve the program as I don't know anything about programming :oops:

This is usefull and it saves me time :wink:

Thanks Rickets007 and I wish you good luck on improving it with someone who knows about programming :D

The loop is too hard to make.

Looks nice but hard to make.

Edit: did my own spiral with that prog.

11111jd7.th.jpg

2222xm5.th.jpg

If I do the spiral smaller I could save objects and build one really long spiral.

Share this post


Link to post

OMFG !

Wow, incredible. Good work rickets007.

Want to play one of those maps, upload it in lw :D .

See ya

Share this post


Link to post
Alright, I have added a '# of loops' parameter. You can also control the direction of the loop (right or left handed) by making the offset negative.

But I want it in another angle.

Now I can have <--- and ---> if you get what i mean. Right and left handed.

But I want it in another angle, is taht possible?

Share this post


Link to post

Alright, I will try to work out the trig for rotating the spiral. It might take a while because I have been smoking pot all day and I'm really high.

Share this post


Link to post

I think I got it.

mta-screen0013.jpg

I am now going to work on optimizing the spread sheet. I will release the newest version within a few hours.

Share this post


Link to post

Great =)

This will really help me when i'm building maps like Going-Down.

And if you got time maybe you can figure out how to angle them like a spiral.

Share this post


Link to post

this is cool :D... to bad i can't open excel sheets on the comp im on... will have to wait untill i can use the pc im normally on...

Share this post


Link to post

Hedning, I see what you mean. That, however, would best be done by a separate program. I might look into making one sometime.

Share this post


Link to post

I have done some thinking about the spirals.

In the Unites States engineers use the term 'superelevation' to describe the angle a banked corner makes with flat ground. It looks like your super elevation in the picture is about 45 degrees.

There are two ways to deal with the transition from flat ground to the spirals superelevation.

1. Make the spiral have a constant superelevation and add separate transitional sections at the ends.

2. Make the superelevation start at zero and gradually increase until the middle of the spiral and then gradually decrease until the exit. This is similar to how I designed the loop generator so that the entrance and exit are strait.

Share this post


Link to post

Here is what I have so far

mta-screen0015.jpg

The entrance and exit create a problem. They require a convex road surface. This can not be created using flat pieces. Any ideas?

Share this post


Link to post

  • Recently Browsing   0 members

    No registered users viewing this page.