Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: December Entry: Most 'Excel'-lent!

  1. #1

    Map December Entry: Most 'Excel'-lent!

    A totally spur-of-the-moment idea. Probably has very little chance of winning the coveted Golden Compass, but I think it might score some points for novelty.

    I decided to go old-school with my mapping software... No, not pen and paper - that's the Light Challenge. EXCEL!!! Woohoo!!! Party Time! Excellent!

    Using a Surface Chart and a bunch of random numbers and formulas, here is a prospective view of a part of the floor of a cavern. Note that because it's using random numbers in there, the final version is guaranteed to actually look nothing like this. This is mostly just proof of concept.
    ### Latest WIP ###
    Click image for larger version. 

Name:	Excel-Floor-1.jpg 
Views:	137 
Size:	66.7 KB 
ID:	40464
    My Finished Maps | My Planet Maps | My Challenge Entries | Album: Pre-generated Worlds

    ------
    Assuming I stick with fantasy cartography, I'd like to become a World Builder, laying out not only a realistic topography, but also the geopolitical boundaries and at least rough descriptions of the countries and societies.

  2. #2
    Community Leader Bogie's Avatar
    Join Date
    Nov 2011
    Location
    Maine, USA
    Posts
    7,632

    Default

    You definitely get Novelty points! Very different. Be interesting to see how this turns out.

  3. #3
    Guild Expert jbgibson's Avatar
    Join Date
    Oct 2009
    Location
    Alabama, USA
    Posts
    1,429

    Default

    Novelty points, geek points, and no doubt insanity points. I can not WAIT to see how this winds up.

    <bows>

  4. #4
    Guild Adept Facebook Connected EricPoehlsen's Avatar
    Join Date
    Mar 2011
    Location
    Regensburg, Germany
    Posts
    264

    Default

    - very cool...

  5. #5
    Community Leader Lukc's Avatar
    Join Date
    Sep 2011
    Location
    Seoul, South Korea
    Posts
    1,573

    Default

    Number crunchy!

  6. #6

  7. #7
    Community Leader Facebook Connected tilt's Avatar
    Join Date
    May 2010
    Location
    Trelleborg, Sweden
    Posts
    5,784
    Blog Entries
    2

    Default

    hehe looks good, fun idea... I remember once seeing a portrait done with excell - that is after rotating the graphs in 3D space the portrait appeared
    regs tilt
    :: My DnD page Encounter Depot free stuff for your game :: My work page Catapult ::
    :: Finished Maps :: Competion maps - The Island of Dr. Rorshach ::
    :: FREE Tiles - Compasses :: Other Taking a commision - Copyright & Creative Commons ::
    Works under CC licence unless mentioned otherwise

  8. #8

    Default

    I don't know if I've ever tried this stunt before or not. If I have, it was a VERY long time ago. I am a self-proclaimed Excel Expert though, so if I can't do it, it will take someone better than me to do it.

    Planning: I'll do a scale of 1 point = 1'

    Hurdle #1: Excel Surface charts have a limit of 4000 points, which is approximately 63x63 if I go square. For simplicity's sake, I will use 50'x50' tiles.

    Hurdle #2: Surface charts use category axes, not numeric, so I can't define the chart axis min/maxes and then stack multiple charts with transparency and expect them to line up.

    Solution: Create a Master Grid that is clear, except for gridlines, at the proper rotation. Export the individual charts into images, then line up and resize them to fit in the Master Grid.

    Hurdle #3: Surface Charts do not do holes or gaps. If I want to overlap or not have boundaries right at the tile edges this is a problem.

    Solution: I'll have to erase parts by hand, or set the color to white and let the transparency handle it somehow. I'll have to figure it out differently for each instance where I want a hole or gap for overlaying purposes.

    Hurdle #4: With this amount of preplanning needed, I can't just slap a grid of formulas together as I had originally planned and see what happens. I'll have to lay out the size and general direction of the lair in order to determine the number of tiles and best rotation to use.
    My Finished Maps | My Planet Maps | My Challenge Entries | Album: Pre-generated Worlds

    ------
    Assuming I stick with fantasy cartography, I'd like to become a World Builder, laying out not only a realistic topography, but also the geopolitical boundaries and at least rough descriptions of the countries and societies.

  9. #9
    Guild Member Engris's Avatar
    Join Date
    Nov 2011
    Location
    Minnesota
    Posts
    56

    Default

    I MUST see how this turns out. You have a very creative and interesting idea there.

  10. #10

    Default

    Using a 4x5 Master Grid, so there will be 20 50x50 tiles. Might be a touch excessive, but better to overshoot than under. Actually, more than 20 tiles. Probably more like 30-35, since some of the grids will require more than one tile.

    I'm starting out with a water tile as a simple starting point. There will be 4 of them along the front as the edge of a river. At the moment it looks rather jagged, so I'm going to see if I can't smooth it out some, but if not, not. Jagged water may fit in quite nicely with the probable jaggedness of the rest of the map.

    I've already found some things I can do to make it easier. Surface Charts don't do gaps, but I can set certain elevation ranges to transparent fill.
    My Finished Maps | My Planet Maps | My Challenge Entries | Album: Pre-generated Worlds

    ------
    Assuming I stick with fantasy cartography, I'd like to become a World Builder, laying out not only a realistic topography, but also the geopolitical boundaries and at least rough descriptions of the countries and societies.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •