I made an Excel template for planning layouts at work.

Post all other topics which do not belong to any other category.
Post Reply
TypeO
Burner Inserter
Burner Inserter
Posts: 7
Joined: Tue Apr 29, 2014 1:24 pm
Contact:

I made an Excel template for planning layouts at work.

Post 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

Starwalker
Manual Inserter
Manual Inserter
Posts: 4
Joined: Tue Feb 10, 2015 11:58 am
Contact:

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

Post 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.

TypeO
Burner Inserter
Burner Inserter
Posts: 7
Joined: Tue Apr 29, 2014 1:24 pm
Contact:

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

Post 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

User avatar
cube
Former Staff
Former Staff
Posts: 1111
Joined: Tue Mar 05, 2013 8:14 pm
Contact:

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

Post 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?

TypeO
Burner Inserter
Burner Inserter
Posts: 7
Joined: Tue Apr 29, 2014 1:24 pm
Contact:

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

Post 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.

onebit
Long Handed Inserter
Long Handed Inserter
Posts: 97
Joined: Mon Feb 02, 2015 4:32 pm
Contact:

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

Post 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.

User avatar
DerivePi
Filter Inserter
Filter Inserter
Posts: 505
Joined: Thu May 29, 2014 4:51 pm
Contact:

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

Post by DerivePi »

I'll stick with ACAD for now (at least until I adapt Revit to my cause...).
Attachments
RR-IMPORT-EXPORT.png
RR-IMPORT-EXPORT.png (101.77 KiB) Viewed 9935 times

onebit
Long Handed Inserter
Long Handed Inserter
Posts: 97
Joined: Mon Feb 02, 2015 4:32 pm
Contact:

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

Post by onebit »

I like how you can show the power under there!

infogulch
Inserter
Inserter
Posts: 20
Joined: Mon Dec 29, 2014 6:09 pm
Contact:

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

Post 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)

TypeO
Burner Inserter
Burner Inserter
Posts: 7
Joined: Tue Apr 29, 2014 1:24 pm
Contact:

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

Post 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

User avatar
DerivePi
Filter Inserter
Filter Inserter
Posts: 505
Joined: Thu May 29, 2014 4:51 pm
Contact:

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

Post by DerivePi »

For underground belts, you can only go 4 tiles, not 5.

ShenJingBing
Burner Inserter
Burner Inserter
Posts: 6
Joined: Sat Feb 21, 2015 1:56 am
Contact:

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

Post 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.

Post Reply

Return to “General discussion”