I made an Excel template for planning layouts at work.
I made an Excel template for planning layouts at work.
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
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
-
- Manual Inserter
- Posts: 4
- Joined: Tue Feb 10, 2015 11:58 am
- Contact:
Re: I made an Excel template for planning layouts at work.
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.
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.
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.Starwalker wrote:This is more powerful then crack.
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Re: I made an Excel template for planning layouts at work.
It doesn't? It should. What did you try? What does it do?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
Re: I made an Excel template for planning layouts at work.
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.
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](http://i.imgur.com/dENJSF4m.png?1)
To open it in draw.io login to google and select open in draw.io Pro.
![Image](http://i.imgur.com/dENJSF4m.png?1)
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.
I'll stick with ACAD for now (at least until I adapt Revit to my cause...).
- Attachments
-
- RR-IMPORT-EXPORT.png (101.77 KiB) Viewed 11673 times
Re: I made an Excel template for planning layouts at work.
I like how you can show the power under there!
Re: I made an Excel template for planning layouts at work.
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](https://dl.dropboxusercontent.com/u/2925840/factorio-template-cap1.png)
![Image](https://dl.dropboxusercontent.com/u/2925840/factorio-template-cap2.png)
The original of this design: (https://i.imgur.com/aWXV8VC.png)
https://docs.google.com/spreadsheets/d/ ... sp=sharing
Some scrrenshots:
![Image](https://dl.dropboxusercontent.com/u/2925840/factorio-template-cap1.png)
![Image](https://dl.dropboxusercontent.com/u/2925840/factorio-template-cap2.png)
The original of this design: (https://i.imgur.com/aWXV8VC.png)
Re: I made an Excel template for planning layouts at work.
Yeah, that's way better. Thanksinfogulch 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:
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.DerivePi wrote:I'll stick with ACAD for now (at least until I adapt Revit to my cause...).
![Smile :)](./images/smilies/icon_e_smile.gif)
Cool, will look into it. thanksonebit 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.
Re: I made an Excel template for planning layouts at work.
For underground belts, you can only go 4 tiles, not 5.
-
- Burner Inserter
- Posts: 6
- Joined: Sat Feb 21, 2015 1:56 am
- Contact:
Re: I made an Excel template for planning layouts at work.
I just doodle them on paper.
It's more about the idea, coming up with a different setup, the exact alignment is secondary.
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
![Smile :)](./images/smilies/icon_e_smile.gif)