|
Freesky Veteran
|
1#
A A
A Post at 9-25-2009 17:56 Show author
Miracle Spreadsheet/Tool(Img heavy)
So, not sure if there is already one out there, but this is a simple spreadsheet that lets you keep track of Miracle resource needs on individual or multiple levels. As well as keeping track of donations. Originally created in OpenOffice, but saved in an excel format. I'll try to add some screenshots and suggestions on how it can be used more efficiently by Alliance Leaders.
Example of a message I send out nightly to my members, using info from img 1
" Inspiration, goals, links to alliance website, etc etc
Level cost for †Devil Stone†
73,894,594 Food/Sand, 36,947,297 Metal/Wood, 18,473,649 Crystal
Current required resources for †Devil Stone†
43,571,546 Food
54,498,157 Sand
13,556,138 Metal
26,981,093 Wood
10,463,183 Crystal
Level cost for †Holy Angel†
49,263,063 Food/Sand, 24,631,531 Metal/Wood, 12,315,766 Crystal
Current required resources for †Holy Angel†
6,916,582 Food
6,707,155 Sand
8,782,504 Wood
Level cost for †Hell's Shadow†
49,263,063 Food/Sand, 24,631,531 Metal/Wood, 12,315,766 Crystal
Current required resources for †Hell's Shadow†
3,993,775 Sand
Final notes, expectiations, other links, etc etc."
Using the multiple levels ahead I was able to create a countdown that I posted on our forums which would be linked to in the "Update" message I sent out every day.(I took this screenie a while ago and saved it so there wasn't an updated one listed >.>)
Another quick tip is that you can use some html code in your messages.
Ex. <a href="http://tinyurl.com/p2lhh5" target="_newtab">Our Charter --- Clickafied!</a>
This is in our main alliance description ingame. Which is why the tinyurl was used(stupid character limit). This is similiar to using the BBCode in the forums. Just change the url in between the "" and the text where 'Our Charter --- Clickafied!' is to whatever you want it to be.
 
[ Last edited by thaliongor at 10-8-2009 01:58 ] Attachment: Your usergroup does not have permission to access attachments
|
