Join the new world

Already have an account? Login



What is this?

You are reading an article written by a citizen of eRepublik, an immersive multiplayer strategy game based on real life countries. Create your own character and help your country achieve its glory while establishing yourself as a war hero, renowned publisher or finance guru.

Sniper Assistance System [official release]

Day 875, 19:32 • Published in Ireland Ireland

• by Sean Power

http://www.wdwpublicaffairs.com/Resources/images/Thunderbirds_47838007_maintLarge.jpg">
Rapturous crowds celebrate Mr. Powers promotion

http://www.erepublik.com/images/parts/icon_position_military_fieldmarshal.gif">

http://www.erepublik.com/images/parts/icon_position_military_fieldmarshal.gif">

WOOT!! Another Field Marshal for eIreland!! Some thanks to those Ive met on and off the battlefield along the way...
"Grainne

http://static.erepublik.com/uploads/avatars/Citizens/2009/02/19/fceeb25f6173370d39f61e5d2de28284_100x100.jpg" /> Grainne Ni Mhaille : For all the roleplaying mystique and encouragement on the original forums!

"Niall

http://static.erepublik.com/uploads/avatars/Citizens/2009/06/30/427d60b49c6e5598f192574a0768c903_100x100.jpg" />
Niall H : For all your plans on the original forum for reorganising the IDF which sparked my interest!

"Brian

http://static.erepublik.com/uploads/avatars/Citizens/2008/08/13/1a222b6fa56531e6e320da70239ad9d0_100x100.jpg" />
Brian Boru For being abrupt and telling me to go on IRC when I was a noob enquiring about the IVF!..

"DashRiprock"

http://static.erepublik.com/uploads/avatars/Citizens/2009/05/04/e415695433709b479836c03928b46f85_100x100.jpg" /> DashRiprock : For being a fantastic CO and getting everyone in the division involved on the forum with a competition to guess your last meal and the colour of your boxers (or should that be briefs?😉

"Conor

http://static.erepublik.com/uploads/avatars/Citizens/2009/03/20/fe6784e709e12db300c2abcf56ec13be_100x100.jpg" />
Conor Larkin: For powerful and inspiring articles released as CoS promoting the IDF

"edfluff"

http://static.erepublik.com/uploads/avatars/Citizens/2009/03/08/1b677f9750037621089ae6d4a3fe8b82_100x100.jpg" />
edfluff : For promoting me to my first military position as your XO and being a quality CO!

"Semprini"

http://static.erepublik.com/uploads/avatars/Citizens/2009/02/13/d0f1e99dcdeb48ea827a6ef178684de7_100x100.jpg" /> Semprini : For showing how damage reports can help increase activity in a division and being a very active and encouraging CO on forum

"05637716"

http://static.erepublik.com/uploads/avatars/Citizens/2009/02/27/9edb8df7cb7f98eb1816bbe709aed6c2_100x100.jpg" /> 05637716 : For believing in me as a safe CoS..... and for challenging me on IRC to explain the OT rules months earlier when you were trying to convince me of admin conspiracies 😉

"castaneda"

http://static.erepublik.com/uploads/avatars/Citizens/2009/04/02/22af57158896301082b32e037caed314_100x100.jpg" />
castaneda : For helpful info, advice on cheap gifts and selling reasonably priced q5s!

"Yddub

http://static.erepublik.com/uploads/avatars/Citizens/2009/07/26/9715206f6e835efb245b04f60a80539b_100x100.jpg" /> Yddub Emwolb : For a gigantic donation and being a cool character generally! I would not have gotten to FM during v1 without your help. Thank you so much🙂

"einberliner"

http://static.erepublik.com/uploads/avatars/Citizens/2009/07/15/c6d8a029a0915afd292495e1c6bde076_100x100.jpg" /> einberliner : For always being kind and generous.... particularly helpful in dragging me over the finish line 😉

I'd like to say thank you to some of the Presidents that have pushed the button thereby allowing guys like me to rank up!
"Theus

http://static.erepublik.com/uploads/avatars/Citizens/2008/09/06/d58bb3431470ff7f4dbaa7789ad37125_100x100.jpg" /> "Nithraldur"

http://static.erepublik.com/uploads/avatars/Citizens/2008/02/23/bc546801ff7ef8532c95880bb285f5e6_100x100.jpg" /> "AppleMan"

http://static.erepublik.com/uploads/avatars/Citizens/2009/03/08/d3e437e37090914b0194eb6b91ff5f88_100x100.jpg" /> "Hekter"

http://static.erepublik.com/uploads/avatars/Citizens/2009/05/12/9db7ea9bdb1e6022e6440b3d78323744_100x100.jpg" />
The last one is our current Phillipines / Malaysia TW button pusher🙂

"Battle

http://www.erepublik.com/images/achievements/icon_achievement_battlehero_off.gif"> "Battle

http://www.erepublik.com/images/achievements/icon_achievement_battlehero_off.gif">
Onto the important release of the Sniper Assistance System
S.A.S is a dual use spreadsheet to help those going for a Battle Hero medal.

Click for larger image

1 : Be completely upfront and plan ahead, see your damage capability based on your existing funds or budget (lefthand side)
OR
2 : On the 2nd day of battle see how much it would cost to grab the top spot from the current Battle Hero.(righthand side)

Features :
* Automatically grabs price of products on the irish market
* Allows you to compare irish price with international price (must be inputted manually)
* Fun for seeing how much damage your entire gold inventory could achieve in a single battle (particularly if your name is Snakeyes 😉
* Useful for predicting costs if you're a snipers (those who attempt to win battle hero medals at the last possible moment)
* One of a kind (if I'd seen something similar then I wouldnt have bothered!)

Drawbacks
* Some manual input still required
* Google and the API system tend to fight with eachother quite often!
* Googledocs account and some knowledge required to copy spreadsheet and use
* Some use of average prices so not 100% precise

Future Additions
* Automatically calculating cost based on market of the country of residence of user
* Anything else I can think of 😛
CHECK OUT THE SNIPER ASSISTANCE SYSTEM NOW

Instructions for use:
* Log into your google account
* Open up S.A.S
* Click 'File' then 'Make a Copy'
* Input info required under Green headers
* View output displayed under Orange headers
* Comment saying it was a waste of time 😛

CHECK OUT THE SNIPER ASSISTANCE SYSTEM NOW

http://www.erepublik.com/en/party/progressive-party-south-africa-3064/1">Join the PPSA Today!

Comments

einberliner Day 875, 19:34

I am very, very attracted to that spreadsheet.

Can I eMarry it?

Conor Larkin Day 875, 19:36

This is absolute awesomeness.

Will be using this when I get enough gold to go after BH...should be only another few years!

Sean Power Day 875, 19:39

still some snags to work out.... like when google and the API system are fighting I need to put in an if function so that itll use a manually inputted figure for gold/iep and iep/gold prices.

Hope it gets put to use by some soldiers going for BH anyhow!

Sean Power Day 875, 19:42

just noticed also.... if the inventory input is below what it costs for 12 q5s and 20 q1 gifts it just pretends you have them already 😛

I did mention it was an alpha release rite😉

Glorious Connolly Day 875, 19:45

A great man!

caladbolg Day 875, 20:12

Kick ass!

Edana Savage Day 875, 21:45

Congratulations!

Songtsan Gampo Day 875, 22:31

😃

Pip Kelly Day 876, 01:37

Welcome to the FM club 😃

Damn impressive spreadsheet Mr.Power

Gillian Smyth Day 876, 03:42

Congratulations on reaching FM status!

castaneda Day 876, 03:43

😉 congratulations sean

Nithraldur Day 876, 04:23

YAY! 🙂

John Gormley Day 876, 05:02

I'd like to welcome you to the FM club! Congrats.
Awesome spreadsheet! 🙂

Sargant Stefanos Day 876, 05:06

Congrats Sean, I'm hoping to follow you in a few days

And thanks for making me a CO btw

o7

Yddub Emwolb Day 876, 05:24

Congratulations Sean. A huge gain for Na Fianna.

Two Shillelagh O'Sullivan Day 876, 07:16

congratz on your FM rank
ps. love the spreadsheet

Dylanb9216 Day 876, 08:20

Grats on FM

DashRiprock Day 876, 08:29

Im getting close myself ! And this is great Sean, Ive been thinking about going for a medal soon....

(Q5 gun sellers, give me a call! Lets make a deal!)

Obi Kenobi Day 876, 08:31

Congrats 🙂

Mr Ginge Day 876, 08:51

IRON, LION, ZION!

Grainne Ni Mhaille Day 876, 09:24

Just gorgeous.
All of it 🙂
o7, and welcome to FM club 😃

Ian Arb Day 876, 09:44

Congrats on your promotion to FM and the Sniper Assistance System is quite epic and win!

patton Day 876, 16:51

Welcome to the group. Yddub got me over the line too

Heliconpac Day 876, 16:52

Toast!

Sean Power Day 876, 18:21

been working on the beta version of the S.A.S

1. Want to leave Ireland and still compare the local prices in your new country to the international best prices?
S.A.S can now adapt to any currency/market... adapting to a soldiers needs as he travels the globe in search of BH medals 😉

2. Don't want to input the figure for the damage of the current BH?
Sorted..... the current highest damage on your side is now automatically retrieved from zhunder.com without you need to!

3. Don't remember what damage you've already done? or can't be bothered checking zhunder for it?
No need to worry..... the spreadsheet will do it for you now 🙂

Things left to do:
1. You still need to put in the battle id... working on a work around to have that automatically be the last battle you fought in.

2. Also looking to automatically retrieve the international price list so not manual input is required.

aidans org Day 877, 00:18

Well done Sean, congrats.

Sean Power Day 877, 08:19

1. Local market prices no automatically changes based on country of residence.
2. International prices update automatically... no need for manual input anymore.
3. Current BH and user damages now automatically updated if Battle ID provided

😁 These 3 features gone live as of right now. Copy the new version at the same link to avail of the added funcionality 😉

Sean Power Day 877, 08:21

Have a way to auto-select the battle that you've last fought in so manual input will be reduced to Citizen ID & cash available to spend..... but its very time consuming to employ so might take a day or two.

Writer's Guild of Ireland Day 896, 16:47

I <3 Mr Power

Post your comment