Page 1 of 1

I made an Excel template for planning layouts at work.

Posted: Thu Feb 05, 2015 12:47 pm
by TypeO
Hi everyone,

I was bored at work the other day and made a Factorio Excel template to plan out some stuff for my game later. It's not very elaborate, but good enough for furnace layouts and stuff.

https://docs.google.com/spreadsheets/d/ ... 1511466101

I am not very good with google docs, so I hope this somehow works.

Edit: Looks like Google docs doesn't like Excel formatting. So No vertical text in google docs.

Cheers
TypeO

Re: I made an Excel template for planning layouts at work.

Posted: Tue Feb 10, 2015 12:04 pm
by Starwalker
I took a look, and after a little while I thought "Why bother with this, why not play the real game instead of trying to play it in Excel".

Then I realized that was exactly what you were doing! Playing the game at work, or as close as you could. I know the feeling, I'm at work typing this, thinking of what I'll build when I come home.

This is more powerful then crack.

Re: I made an Excel template for planning layouts at work.

Posted: Wed Feb 11, 2015 10:08 am
by TypeO
Starwalker wrote:This is more powerful then crack.
That's pretty accurate. If Factorio would run better from an USB stick, I would probably play it at work. But it doesn't, so I'll play with my Excel sheets. :D

Re: I made an Excel template for planning layouts at work.

Posted: Wed Feb 11, 2015 11:03 am
by cube
TypeO wrote:If Factorio would run better from an USB stick, I would probably play it at work. But it doesn't, so I'll play with my Excel sheets. :D
It doesn't? It should. What did you try? What does it do?

Re: I made an Excel template for planning layouts at work.

Posted: Wed Feb 11, 2015 5:37 pm
by TypeO
It works, but stutters hard right from the beginning. I don't think it's because of the stick, probably because of my shitty work computer.

Re: I made an Excel template for planning layouts at work.

Posted: Wed Feb 11, 2015 6:17 pm
by onebit
draw.io works pretty well for this, too. I find its useful to make a drawing of complex factories before construction to make sure everything flows neatly.


Image

To open it in draw.io login to google and select open in draw.io Pro.

Re: I made an Excel template for planning layouts at work.

Posted: Wed Feb 11, 2015 8:55 pm
by DerivePi
I'll stick with ACAD for now (at least until I adapt Revit to my cause...).

Re: I made an Excel template for planning layouts at work.

Posted: Wed Feb 11, 2015 9:41 pm
by onebit
I like how you can show the power under there!

Re: I made an Excel template for planning layouts at work.

Posted: Wed Feb 11, 2015 10:50 pm
by infogulch
TypeO, I liked your sheet but it had a bunch of problems from importing from Excel. So I reworked it to use Unicode arrow characters (→←↑↓↰↱↲↳ etc) instead of rotated text, fixed cell size and border issues, reworked some machines, and made an example. It seems to work a lot better imo:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Some scrrenshots:
Image
Image
The original of this design: (https://i.imgur.com/aWXV8VC.png)

Re: I made an Excel template for planning layouts at work.

Posted: Thu Feb 12, 2015 1:58 pm
by TypeO
infogulch wrote:TypeO, I liked your sheet but it had a bunch of problems from importing from Excel. So I reworked it to use Unicode arrow characters (→←↑↓↰↱↲↳ etc) instead of rotated text, fixed cell size and border issues, reworked some machines, and made an example. It seems to work a lot better imo:
Yeah, that's way better. Thanks
DerivePi wrote:I'll stick with ACAD for now (at least until I adapt Revit to my cause...).
That's cool. I work also work with CAd a bit, but you are the first I have seen that has the black backround activated. :)
onebit wrote:draw.io works pretty well for this, too. I find its useful to make a drawing of complex factories before construction to make sure everything flows neatly.
Cool, will look into it. thanks

Re: I made an Excel template for planning layouts at work.

Posted: Thu Feb 12, 2015 5:48 pm
by DerivePi
For underground belts, you can only go 4 tiles, not 5.

Re: I made an Excel template for planning layouts at work.

Posted: Sat Feb 21, 2015 2:16 am
by ShenJingBing
I just doodle them on paper. :roll: :) It's more about the idea, coming up with a different setup, the exact alignment is secondary.