NEW Weapons Calculator by "NEM" Accurate "Based on MOBsize"
Forums › General Discussion › NEW Weapons Calculator by "NEM" Accurate "Based on MOBsize"-
I uploaded it here
www.onlinegc.co.uk/downloads/NEMS WEAPON CALCULATOR.xlsx
You will need Excel to use it.
Let me know what you think or to make any ammendments etc..Thanks
Stu
-
Someone asked to here is reply..
If you leave Mobsize Cell Blank, it calculates your ATT & DEF based on what weapons you key in/own,Then Once you key your actual mob size.. it calculates the actual ATT & DEF..
Total upkeep, required upkeep etc.
You need to allow editing.
Trust there isnt any macros or viruses if you can clarify plz.
thanks -
Havnt tried it but well done, it's about time someone this. The one on mobcodes is ok but needs a mob number box. To cut out all the work.
-
Wow. Nice one nem.
-
Nice one NEM!
-
I did ask Mobcode & Turfwarsdb if they wanted to use it but i got no response mate.
I can convert this to a webpage but only if you have Office & IE6+ installed...
Stu -
I would ask Nick but i my emails are directed straight into his BIN.
I wanted to use the little weapon icons. I do have them but sure they are Limited or owned. -
NO Messrine,
I won't change cell colours LMAO
and as i said, i cant make it a webpage as it is built in Excel and only visible in IE6+ for owners of Office/Excel.
I'd need it converted to PHP. -
Nice one matey
-
Nice1 nem, sounds interesting, I'll give it a look when I get near a computer
-
Nice one, Nem :-)
-
Nemesis add NEM wrote:
I uploaded it here
www.onlinegc.co.uk/downloads/NEMS WEAPON CALCULATOR.xlsx
You will need Excel to use it.
Let me know what you think or to make any ammendments etc..Thanks
Stu
It's nice...Thanks! Some missing weapons tho...
"Sawed-off Shotgun"
Att: 13 Def: 14
Cost: $25K
Upkeep: $0"Glock 31"
Att: 14 Def: 10
Cost: $30K
Upkeep: $0"AR-15 Assault Rifle"
Att: 30 Def: 14
Cost: $300K
Upkeep: $0"Riot Shield"
Att: 3 Def: 6
Cost: $16K
Upkeep: $0 -
Also, I'd like to resize columns H & I -- they're not wide enough. Can it be unprotected?
-
Doc Xray wrote:
I can do that. I have protected it to hide the formulas as it took me a few days to sort out.Also, I'd like to resize columns H & I -- they're not wide enough. Can it be unprotected?
I'll add thw saedoff shotgun, glock AR 15 & riot shield.. thanks Doc :)
-
ok widened cells H & I, now shows billions of $. Unless your font is too large :)
Will sort extra weapons soon..
Cheers -
Awesome -- thanks!
-
Nem you wiz it's wicked much better than the one on mobcode.👊👍
-
Yeah well done Nem. Great stuff
-
Doc Xray wrote:
That's wrong btw. Those are loot weapons which cannot be bought. Hence cost is actually meaningless and only counts in terms of resale valueNemesis add NEM wrote:
I uploaded it here
www.onlinegc.co.uk/downloads/NEMS WEAPON CALCULATOR.xlsx
You will need Excel to use it.
Let me know what you think or to make any ammendments etc..Thanks
Stu
It's nice...Thanks! Some missing weapons tho...
"Sawed-off Shotgun"
Att: 13 Def: 14
Cost: $25K
Upkeep: $0"Glock 31"
Att: 14 Def: 10
Cost: $30K
Upkeep: $0"AR-15 Assault Rifle"
Att: 30 Def: 14
Cost: $300K
Upkeep: $0"Riot Shield"
Att: 3 Def: 6
Cost: $16K
Upkeep: $0 -
Fair point. It would still be useful to have them in a calculator for the purposes of assessing total A & D and upkeep
-
Nice job. You are still missing some weaponry though, such as glocks, AR 15s and riot shields.
And a suggestion, list everything in the order as it is listed in the market and you will have an awesome product here.
-
That's almost what im half way through doing. it is very similar to listed in the market but needs to be in this order for the array to pick up strongest weapons as the market list isnt in order of strongest weapon.
I did Email Nick to ask if it is ok to use the Weapon Pictures as Icons in the sheet but as i said, he most probably as me as spam mail LOL.
It's easy to take pics away if im denied but looks a lot better.
Those "extra" weapons i have added with pics and are now an option to select with amounts as they all count towards ATT & DEFF stats.
I left the purchase price as Doc suggested even if you cannot purchase them as i may need a "sell price".
Will be done by tomorrow evening..
If any of your mob building web owners are interested and can/want convert to a PHP webpage, please let me know as it would be easier to use via Ipod Iphone Ipad rather than an Excel spreadsheet on PC.
Stu -
Wow NEM!!! Awesome!! I'll download next time I'll get on the pc :)
-
visible on Internet explore+6 if you have microsoft office installed.
Not likely on a phone, pod or pad -
Thanks nem. Gotta check it out now.
-
Created new one with new weapons etc,
but Moved thread to Help section, here ---> http://turfwarsapp.com/forum/235/30699755/
Thanks
NEM -
Sounds great, let me go and try...
-
Here's one I use, includes sheets for yours and theirs and works out the chances of success in a fight: http://cid-f7c960b0b1ddd7bc.office.live.com/self.aspx/Turf%20Wars/Turf%20Wars%20Calc.xlsx
-
Somebody created this same thing a while ago & passed it on to me (they keep it updated also). Since I can't see yours on the phone, I wanted to ask if you remembered to include the defense for razor wire turf upgrades?
-
Add swagger wrote:
Thats good! i never see anything before which is why i did it.Here's one I use, includes sheets for yours and theirs and works out the chances of success in a fight: http://cid-f7c960b0b1ddd7bc.office.live.com/self.aspx/Turf%20Wars/Turf%20Wars%20Calc.xlsx
Maybe we could merge them somehow, works out ATT & DEF stats, and a sep sheet for fight % win/losses. -
I downloaded,and got an invite to a party in India
![[][]](https://turfwarsapp.com/img/app/ajax-forbutton.gif)
Purchase Respect Points NEW! · Support · Turf Map · Terms · Privacy
©2021 MeanFreePath LLC