• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to organize Coordinates!
#1
Hey there!

Because of live-map no longer existing, I decided to start using a different way to manage coordinates, and where faction bases are.  It worked really good so far, and I was able to share it with my own faction.  So I decided to show everyone how to do it.  

Things Needed:
Google account
Google Spreadsheet
Everything listed is 100% free, and can be used for many other things, outside of factions.

Benefits:
Management of coordinates, and bases.
Easily shareable throughout a team!
Very easy to do

Tutorial:
There is both a video, and a written explanation with pictures.  I decided to do both because my mic quality is really bad.





Explanation: (This explanation shows only what I did in the video)
Step 1: Create a new google Spreadsheet.
[Image: 913a9d9a6b1f718667160e19c490dee9.png]

Step 2: Insert the following text in the cells listed.
Cell A1: Faction Name
Cell B1: x-Coordinate
Cell C1: y-Coordinate 
Cell D1: z-Coordinate
Cell E1: Nearest Stargate
[Image: 3dc78ab2d479caf30af1077f896c986d.png]

Step 3: Insert the color key.
Highlight cells G1:I10
[Image: bb6920be6453d0630d862818ffef3a94.png]

Click the "Fill color" button and select a color. (I choose gray)
[Image: 3019581b8ff04ceeb43bb73fd089b127.png]

Type:
Cell H1: Key
Cells H2:H9 are where you can put the colors of the key.
Here are some examples of colors and things to sort by:
[Image: f652d662e667b0cbac4aa6c190e7e7a2.png]
You can change the color by selecting a cell, and then clicking the "Fill color" button, just like above!
Congratulations, you have finished the tutorial, but there are some really useful things you could add on as well!

Step 4: Finishing up the sheet with some cool things!
One cool thing you can do, is add a new sheet for each faction you find.  In this sheet you can store some information about who is in it.
Start out by making a new sheet.  You do this by clicking the plus symbol at the bottom of the screen!
[Image: d5579aae2d69395cc3c65bbff669a18f.png]

Rename the sheet, by right clicking the tab and clicking "rename".
[Image: 66ab58b33c21e6012171846b43dd51c6.png]

From here, you just need to do a little bit more typing.
Cell A1: Player
Cell A2: Rank In Faction
You have now completed the last step.

Usage:
I really hope you can figure out you put the information under the cell with the category in it.
For example, You put the faction name under cell A1(Faction Name).
If it is a faction's base, you color it so the key shows that.  Same with everything else.

Conclusion:
I hope this can help a few people and their factions stay organized with coordinates.  I made this to promote more action between factions, because bases coordinates can be stored, and shared between members!

Thanks for giving this a look Smile

~SkipTheBekfist
  Reply
#2
Very nice. I really like this and it would probably be much more helpful and organized if players did this. But if I'm too lazy. I just write it down on a piece of paper Tongue
Only Unicorn Factioneer yet
MineSquads Factions Famlit [Monitor]
Play.MineSquads.com
  Reply
#3
Very nice tutorial, thanks for that Smile
  Reply
#4
(11-16-2016, 12:47 PM)KVMS Wrote: Very nice. I really like this and it would probably be much more helpful and organized if players did this. But if I'm too lazy. I just write it down on a piece of paper Tongue

Thanks  Smile Paper always works really good.

(11-16-2016, 02:05 PM)Vaseline Wrote: Very nice tutorial, thanks for that Smile

Thank Gandy Smile
  Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)