Help support TMP


"Microsoft Excell Question" Topic


14 Posts

All members in good standing are free to post here. Opinions expressed here are solely those of the posters, and have not been cleared with nor are they endorsed by The Miniatures Page.

Please be courteous toward your fellow TMP members.

For more information, see the TMP FAQ.


Back to the Terrain and Scenics Message Board

Back to the Maps Message Board


Areas of Interest

General

Featured Hobby News Article


Featured Recent Link


Featured Showcase Article

Stan Johansen Miniatures' Painting Service

A happy customer writes to tell us about a painting service...


Featured Workbench Article

Trying Out Chalk Board Stickers

Labeling base bottoms with black chalkboard-type stickers.


Featured Profile Article

Pegboards at Dollar Tree

Pegboards can be used for wargaming campaigns.


1,262 hits since 14 Oct 2009
©1994-2025 Bill Armintrout
Comments or corrections?

Steve Hazuka14 Oct 2009 8:03 p.m. PST

I would like to use Excell to draw up some floor plans and ship deck plans and I was wondering what size cell would I need to make for half inch and one inch square cells. I keep playing with it but I figured I'm not the first one to do this.

JRacel14 Oct 2009 8:20 p.m. PST

tabletopwarrior,

I live, eat and breath Excel to make a living and it is the last tool, short of MS Access I would use to make map grids. I am sure the folks around here can point you in a better direction since almost any decent art program would do this much better. Maybe there is a good way to use it for this, but for the life of me I can't think what it would be. Sorry, not trying to burst your bubble, just thinking you might do better asking about a cheap or free graphics program that can do this much better than Excel.

Best of luck,

Jeff

Skrapwelder14 Oct 2009 8:23 p.m. PST

100 pixels to the inch so your cell should be 50 pixels by 50 pixels

Personal logo chicklewis Supporting Member of TMP14 Oct 2009 8:41 p.m. PST

Here's just what you need. Print graph paper with any size grid. FREE ! EASY ! I've used it many times.

printfreegraphpaper.com

(JRacel is right, Excell is CR@P for your purpose. Even uses different units for the horizontal and vertical. Excell NOT recommended)

Top Gun Ace14 Oct 2009 11:05 p.m. PST

Try MS Word's simple drawing program.

You can easily make squares, grids, hexes, etc. of any size. Just click on the right mouse button, and select Format Autoshape to resize as desired.

You can use English, or Metric units, as desired.

You can also use the various shapes, or the simple drawing features to permit you to draw the outer hull outline of the craft too.

mandt215 Oct 2009 7:17 a.m. PST

See if you can find an old version of Photoshop on eBay.

Personal logo Extra Crispy Sponsoring Member of TMP15 Oct 2009 7:22 a.m. PST

Powerpoint will let you create a gridded page. From that you can then add all sorts of shapes and save them as "clip art" to be used again when needed…

KenH0115 Oct 2009 8:42 a.m. PST

Try this, any size and type of graph paper you can think of.

incompetech.com/graphpaper

dumps to PDF format.

Ken

Ruben aka Qwirz15 Oct 2009 11:20 a.m. PST

I always use Photoshop for grids and Templates too.
Atlhough Autocad saves a lot of time but needs a bit more of practice. (….my wife is an Architect!)
I Have to say that Chick's link is the fastest mean to Hex grids. I still think hexes are best than squares.

Ruben aka Qwirz15 Oct 2009 11:23 a.m. PST

And Ken's too! The net is full of surprises!

Ditto Tango 2 115 Oct 2009 8:14 p.m. PST

Chick and Ken! Thanks so much for those great links!
--
Tim

BillChuck16 Oct 2009 5:32 a.m. PST

For drawing square-based maps, there are several programs available. Search for rpg mapmaking tools. One I know off hand is Dundjinni. There should be dome freeware programs out there as well.

Chris Wimbrow16 Oct 2009 3:16 p.m. PST

I have worked out the cell sizes to make 1/4" or 1" (within acceptable tolerances) printed cells with Excel for my printer. It's just a matter of testing, proportioning, and trial and error.

And you have the spreadsheet functionality built in.

Last Hussar22 Oct 2009 6:16 p.m. PST

AutoREALM- free mapping down load (or it was 3 years ago when I got it)

Sorry - only verified members can post on the forums.