Pages: 1 2 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sollan Dyl
|
Posted - 2008.07.01 16:15:00 -
[1]
Here it is folks, after a few nights toil on microsoft excel, I announce the:
EVE ECM Jamming calculator
This jamming calculator aims to assist EWAR pilots flying Caldari jamming ships. It outputs your percentage chance to jam a particular ship in 1 jam cycle. The calculator has inputs for every variable involved with ECM jamming including;
- The ship you are flying (includes all the Caldari ships wich contain jamming bonuses) - The ship your opponent is flying (from carrier to frigate) - The number and type of jamming modules on your ship - Allows you to account for less jamming modules on your ship incase you are fitting a tank - The number and type of Signal Distortion Amplifiers on your ship - Accounts for the stacking penalty of S.D.A.'s - Allows for your Signal Dispersion skill level Making this a very comprehensive jamming calculator.
I trawled the forums/websites far and wide for a calculator that does these calculations, I couldn't find one so the "EVE ECM jamming calculator" was born.
All feedback is gladly accepted, tell me if you like it or not , or where abouts i can improve it.
Thanks and enjoy
Sollan Dyl |
Sollan Dyl
|
Posted - 2008.07.01 16:16:00 -
[2]
reserved |
Arvald
Caldari Aurora Acclivitous Paxton Federation
|
Posted - 2008.07.01 16:24:00 -
[3]
i want you
Originally by: Xanos Blackpaw Stealthbomber combat (or as i like to call it: Just because you are paranoid don't mean there isnt a invisible demon about to eat your face) |
Mirana Niranne
Federal Noob Mercs
|
Posted - 2008.07.01 16:34:00 -
[4]
Does it allow you to assume the other ship is using an ECCM module?
Some ships, such as a pair of basilisks working in tandem, might be packing ECCM to help reduce the chance of losing their locks.
Phear the PHAIL |
Lennit Purn
Gallente Blindsight Inc.
|
Posted - 2008.07.01 16:37:00 -
[5]
The drop-down menus for Select Ship and # of Signal Distortion Amps don't work on my computer... but I use Open Office, so probably not your fault.
|
knifee
Caldari Euphoria Heavy Industries
|
Posted - 2008.07.01 16:37:00 -
[6]
Edited by: knifee on 01/07/2008 16:38:24 Thats pretty nice, is there anyway to add in the effect of ECCM mods fitted to the ship you are trying to jam?
edit: asked for above as well.
www.eve-dev.net - making a good thing better
|
Lone Gunman
|
Posted - 2008.07.01 16:38:00 -
[7]
ISK sent, could you add rigs to that if possible?
|
flashfreaking
LFC Executive Outcomes
|
Posted - 2008.07.01 16:39:00 -
[8]
Looks nice, but the Compatibility one does not allow me to select the hostile ship and the # of Distortion amps I'm using. Disallowed sig graphic. Send an e-mail to [email protected] when it meets the forum signature guidelines. ~Saint |
Liang Nuren
Perkone
|
Posted - 2008.07.02 02:06:00 -
[9]
Are there material differences between this and the functionality provided by EFT?
-Liang -- It was an honor to participate in the Insurgency campaign in Branch. o7 to all involved. |
Mu Yaling
|
Posted - 2008.07.02 02:45:00 -
[10]
Originally by: Liang Nuren Are there material differences between this and the functionality provided by EFT?
-Liang
mainly the quantity of trolls
-noob |
|
Sollan Dyl
|
Posted - 2008.07.02 02:50:00 -
[11]
Originally by: Liang Nuren Are there material differences between this and the functionality provided by EFT?
-Liang
After haveing a quick look in EFT (I wasn't aware of the EWAR functionality it had) I found that it only calculates the %chance of >>YOUR<< ship being jammed.
The 'EVE ECM jamming calculator' is designed to assit EWAR pilots in calculating their chance to jam >>OTHER<< ships and allows for modification of a whole range of factors that affect ECM jamming.
|
Bellum Eternus
Gallente D00M. The Requiem
|
Posted - 2008.07.02 03:22:00 -
[12]
Is awesome. Needs ECCM plox. It's scary just how effective this proves ECM to be.
Bellum Eternus
[Vid] L E G E N D A R Y COLLECTION
Inveniam viam aut faciam. |
Xaen
Caldari Caritas.
|
Posted - 2008.07.02 03:39:00 -
[13]
Originally by: Sollan Dyl
Originally by: Liang Nuren Are there material differences between this and the functionality provided by EFT?
-Liang
After haveing a quick look in EFT (I wasn't aware of the EWAR functionality it had) I found that it only calculates the %chance of >>YOUR<< ship being jammed.
The 'EVE ECM jamming calculator' is designed to assit EWAR pilots in calculating their chance to jam >>OTHER<< ships and allows for modification of a whole range of factors that affect ECM jamming.
Uhh no.
You can setup any ship configuration you like, then drop your ECM drones or modules into the "projected effects" window on the test ship. It shows % chance to jam.
It doesn't just have a list of all the default ship types for you to try, but it only takes a couple of seconds to create a new blank ship with default sensor strength. - Support fixing the UI|Suggest Jita fixes|Compact logs |
Grimpak
Gallente Trinity Nova Trinity Nova Alliance
|
Posted - 2008.07.02 03:51:00 -
[14]
hmm... doesn't seem to work that well in OOorg 2.4 ---
Quote: The more I know about humans, the more I love animals.
ain't that right. |
Threv Echandari
Caldari K Directorate
|
Posted - 2008.07.02 03:56:00 -
[15]
Sweet! I would have you babies if I was a woman, O K maybe not but **** still sweet
Thanks!!
Happiness is a Wet Pod
|
Sollan Dyl
|
Posted - 2008.07.02 05:04:00 -
[16]
Originally by: Xaen Uhh no.
You can setup any ship configuration you like, then drop your ECM drones or modules into the "projected effects" window on the test ship. It shows % chance to jam.
It doesn't just have a list of all the default ship types for you to try, but it only takes a couple of seconds to create a new blank ship with default sensor strength.
Hmm what u are saying is correct.
What i am saying is my program differs from EFT, in the following ways; You cannot drop your ship bonuses, signal distortion amplifiers, rig bonuses (soon to be included in EVE jamming calc) into the projected effects area and this vastly affects the outcomes, I'll give an example of what i mean;
--------------------------------------------------------------- In the EVE jamming calculator I selected: SHIP=kitsune MODULE=T1 racial SIGNAL DISTORTION AMP= 2x T2 SDA JAMMING SKILL Lvl=3 (Then i selected the ship i wanted to jam) TARGET SHIP=Drake
this gave me a %chance to jam a Drake of: 83.11% ----------------------------------------------------------------
In EFT I did the eqivalent (as you suggested): selected a ship= Drake then i added jammers to projected effects area= 5x T1 racials
this gave me a %chance to jam a Drake of: 57.7% ----------------------------------------------------------------
Also only the latest version (2.6) of EFT takes into account your signal dispersion skill lvl (edit- this functonality stopped working after a while too).
Cleary EFT doesn't have the facility to calculate other factors involved in ECM jamming, therefore cannot be compared this calculator. Im not saying don't use EFT or it is crap (I find EFT extremely useful). I am saying if you are serious about ECM jamming you will find this jamming calculator "much" more useful than EFT.
Hope that clears it up |
Xaen
Caldari Caritas.
|
Posted - 2008.07.02 06:49:00 -
[17]
Originally by: Sollan Dyl
Originally by: Xaen Uhh no.
You can setup any ship configuration you like, then drop your ECM drones or modules into the "projected effects" window on the test ship. It shows % chance to jam.
It doesn't just have a list of all the default ship types for you to try, but it only takes a couple of seconds to create a new blank ship with default sensor strength.
Hmm what u are saying is correct.
What i am saying is my program differs from EFT, in the following ways; You cannot drop your ship bonuses, signal distortion amplifiers, rig bonuses (soon to be included in EVE jamming calc) into the projected effects area and this vastly affects the outcomes, I'll give an example of what i mean;
--------------------------------------------------------------- In the EVE jamming calculator I selected: SHIP=kitsune MODULE=T1 racial SIGNAL DISTORTION AMP= 2x T2 SDA JAMMING SKILL Lvl=3 (Then i selected the ship i wanted to jam) TARGET SHIP=Drake
this gave me a %chance to jam a Drake of: 83.11% ----------------------------------------------------------------
In EFT I did the eqivalent (as you suggested): selected a ship= Drake then i added jammers to projected effects area= 5x T1 racials
this gave me a %chance to jam a Drake of: 57.7% ----------------------------------------------------------------
Also only the latest version (2.6) of EFT takes into account your signal dispersion skill lvl (edit- this functonality stopped working after a while too).
Cleary EFT doesn't have the facility to calculate other factors involved in ECM jamming, therefore cannot be compared this calculator. Im not saying don't use EFT or it is crap (I find EFT extremely useful). I am saying if you are serious about ECM jamming you will find this jamming calculator "much" more useful than EFT.
Hope that clears it up
Put the distortion amps on your ship first, then drag the jammer(s) to the projected effects. The bonuses will be applied.
EFT doesn't currently update projected effects if you modify the ship projecting them. You have to remove them from the target ship and re-add them.
Either that, or I misunderstand you.
From EFT:
Kitsune with (5) ECM - Spatial Destabilizer Is: 85% chance to jame a drake.
Kitsune with (5) ECM - Spatial Destabilizer Is and (2) Signal Distortion Amplifier Is: 93.3% chance to jam a drake. - Support fixing the UI|Suggest Jita fixes|Compact logs |
zzCoins
Caldari Decorum Inc Tygris Alliance
|
Posted - 2008.07.02 09:33:00 -
[18]
Need to enter ship skill level,to account for ship bonus to ECM strength
Could you make it a bit smaller, it does not fit onto my screen. |
Sollan Dyl
|
Posted - 2008.07.03 12:23:00 -
[19]
Ok, the 'EVE ECM Jamming calculator' has been updated, check the original post for details.
|
Bhodistafa
Gallente Amen Anera
|
Posted - 2008.07.03 12:38:00 -
[20]
Edited by: Bhodistafa on 03/07/2008 12:40:11 Looks like a nice speadsheet but doesn't fit to the page to view all of the cells in order to select them. The actual sheet cannot be 'grabbed' and dragged into view either. Also, the sheet cannot be resized because of its none moving nature.
Has anyone else had these difficulties?
I'm not picking fault by the way merely pointing out the bug I've encountered. Hopefully, it's something that can be resolved?
|
|
Sollan Dyl
|
Posted - 2008.07.03 13:10:00 -
[21]
Originally by: Bhodistafa Edited by: Bhodistafa on 03/07/2008 12:40:11 Looks like a nice speadsheet but doesn't fit to the page to view all of the cells in order to select them. The actual sheet cannot be 'grabbed' and dragged into view either. Also, the sheet cannot be resized because of its none moving nature.
Has anyone else had these difficulties?
I'm not picking fault by the way merely pointing out the bug I've encountered. Hopefully, it's something that can be resolved?
Yeah lol ive already reduced it in size. See i made it on a monitor running 1440 x 900 resolution, so if your running 800 x 600 it's gunna be massive or tiny on a 24" screen. Any way i'll look to see if i can unlock the scaleing within the file or something |
Sollan Dyl
|
Posted - 2008.07.03 14:24:00 -
[22]
ok just did a bit of fiddling with the scaleing, we should be able to scale it now. Tho I could change the size of the spreadsheet with the zoom control in the bottom righthand corner.
Hope that helps |
Bhodistafa
Gallente Amen Anera
|
Posted - 2008.07.03 16:23:00 -
[23]
Thanks for the fix it works perfectly.
I have to ask...why only Caldari jamming ships?
|
Sollan Dyl
|
Posted - 2008.07.03 22:19:00 -
[24]
Originally by: Bhodistafa
I have to ask...why only Caldari jamming ships?
Well I only included Caldari Ships for a few reasons, 1st one is they are the only ships that receive jamming bonuses. Also the other race's ships don't have enough mid slots to fit jammers and can't really waste low slots on SDA's either (it can be done but it's not really viable, if that makes any sense)
2nd is the database i'd have to build inside the spreadsheet would be huge to account for all ships in the game.
BUT.... In the next update I will look to included a 'generic' ship (that receives no bonuses) in the jamming section, all you'd have to do is manually input the amount of jamming modules you'd want to fit to it.
(maybe this is what u meant, if so, sry for the rant above. lol i'll prolly get shot down in flames for it)
At the moment tho, im busy trying to get this to work in open office, wich leads me onto my next post....
|
Sollan Dyl
|
Posted - 2008.07.03 22:21:00 -
[25]
The trouble with this file not working in OpenOffice is;
In Excel i used "dynamic named ranges" as the input for the dropdown boxes, it's like a named range, except it uses a formula to decide wich text to put in the dropdown box, I used either the OFFSET or INDEX functions as this formula.
The trouble seems to be OpenOffice doesn't allow "dynamic named ranges" to be used to format dropdown boxes.
Anybody have any idea's on how to fix or get around this?
note; I've never used OpenOffice before, so the anwser is probably gunna be pretty simple. lol |
Riley Kendrik
Caldari Magnadyne
|
Posted - 2008.07.04 04:33:00 -
[26]
Some questions. Is it showing the cumulative chance to jam with all your modules? Is there a way you can show jam chance with just one module? I ask because rarely are you just focusing on jamming one ship. In most situations you are balancing 3, 4 or more ships, especially when you're in a recon.
Also, is there a way to edit the number of slots you are using? Sure Falcons have 7 slots, but many of us put a sensor booster with scan res script in one of them, which will affect the outcome.
Very nice spreadsheet btw.
|
Sollan Dyl
|
Posted - 2008.07.05 01:29:00 -
[27]
Originally by: Riley Kendrik Some questions. Is it showing the cumulative chance to jam with all your modules? Is there a way you can show jam chance with just one module? I ask because rarely are you just focusing on jamming one ship. In most situations you are balancing 3, 4 or more ships, especially when you're in a recon.
Also, is there a way to edit the number of slots you are using? Sure Falcons have 7 slots, but many of us put a sensor booster with scan res script in one of them, which will affect the outcome.
Very nice spreadsheet btw.
Thanks Riley for your questions, here are you answers:
-Yes, the %chance is cumulative with all the modules you have selected -Yes you can show your %chance with just 1 module (explained below) -yes you can edit the number of slots you are useing (explained below)
Near the middle of the spreadsheet is a white text box with a label that sais - "Overide # of modules" this is what you use to do everything you asked above. I'll use an example below to explain.
Well we'll use your Falcon, when you input that ship, the calculator will say that it has 7 slots and it'll output your chance to jam with all 7 slots filled with jammers of your choice. Say you are useing only 5 slots for jammers on your setup, well you type in "5" in that text box I explained above, this will output your chance with 5 jammers fitted etc.
In the scenario where you have to jam say three different ships, well unfortunately you have to put them in 1 at a time, then select the amount and type of modules u might use on that particular ship, once you worked out your %chance, input the next ship and modules/type etc.
Hope that helps
Sollan
Oh by the way, a sensor booster only affects your lock time and/or locking distance, it has no effect on your chance to jam a ship (apart from a superficial effect, but that connot be calculated). Everything that affects your chance to jam in the game, is in this calculator (I hope) |
Riley Kendrik
Caldari Magnadyne
|
Posted - 2008.07.05 05:18:00 -
[28]
Thanks for the direction, this helps a lot. No worries about the multiple ships, I certainly didn't expect the spreadsheet to be able to handle multiple ships with one go.
As far as the sensor booster goes, you are correct, it does not affect jam chances. I use it to protect against other Falcons, in which case, as you will no doubt agree, the fastest lock wins.
|
Sollan Dyl
|
Posted - 2008.07.05 09:58:00 -
[29]
Originally by: Riley Kendrik Thanks for the direction, this helps a lot. No worries about the multiple ships, I certainly didn't expect the spreadsheet to be able to handle multiple ships with one go.
As far as the sensor booster goes, you are correct, it does not affect jam chances. I use it to protect against other Falcons, in which case, as you will no doubt agree, the fastest lock wins.
No probs mate, glad I could help, I might write a bit better help section in the next version too.
Sollan |
Kazuo Ishiguro
House of Marbles Zzz
|
Posted - 2008.07.05 10:21:00 -
[30]
Edited by: Kazuo Ishiguro on 05/07/2008 10:26:33 Edited by: Kazuo Ishiguro on 05/07/2008 10:22:10
Originally by: Sollan Dyl The trouble with this file not working in OpenOffice is;
In Excel i used "dynamic named ranges" as the input for the dropdown boxes, it's like a named range, except it uses a formula to decide wich text to put in the dropdown box, I used either the OFFSET or INDEX functions as this formula.
The trouble seems to be OpenOffice doesn't allow "dynamic named ranges" to be used to format dropdown boxes.
Anybody have any idea's on how to fix or get around this?
note; I've never used OpenOffice before, so the anwser is probably gunna be pretty simple. lol
Can't you do this via cell validation settings rather than using drop-boxes? Openoffice allows this iirc.
Also, any chance of providing an unlocked version? I'm sure that there are people who'd like to make their own tweaks or check your working.
Finally, I'd suggest adding the option of selecting a generic ship with no bonuses to ECM. Zzz research towers Direrie NEW: Liekuri
20:1 low-end compression |
|
Sollan Dyl
|
Posted - 2008.07.05 13:19:00 -
[31]
Originally by: Kazuo Ishiguro
Also, any chance of providing an unlocked version? I'm sure that there are people who'd like to make their own tweaks or check your working.
Lol, I knew this question would come sooner or later. The reason I locked it is, under the slick first page is two pages of ungodly mess that even I the author can't follow sometimes (the original version had the other two pages visible).
Also, I spent nights doing this spreadsheet, from being harrassed by the girlfriend to "come to bed it's 4 in the morning", to spending hours trawling the forums looking for stacking penalty formulas and how they work, to Alt Tabbing a billion times to get all the ship names and sensor strength info. So the moment I unlock it, someone with uber-slick excel skills will simply refine the spreadsheet and my time in the sun will be over . Also the working has been checked over and over, it all checks out with EVE, EFT and EVE-Mon, so there's no probs there.
I will tho, be looking to add that "generic ship" update soon so check back ppl.
Oh and thanks for the Open Office info, I might have to rewrite it yet. hehe I knew nothing about excel before this project
Thanks
Sollan |
Liiza Valora
|
Posted - 2008.07.05 18:45:00 -
[32]
Edited by: Liiza Valora on 05/07/2008 18:45:33 Hi Sollan Dyl thank you for a great program. I have some questions/comments about it: - Why will your program not allow me to select the ship type i am trying to jam? - I can't select the number of signal distortion amps. - I can't select number and types of rigs fit to my ship. - I can't select relevant ship skill level.
Is this jamming calculator locked or not operating properly? The program I am using is OpenOffice 2.4, It should be compatible. Thanks for your help and again great idea for a third party application. It's people like you that make eve-online better.
|
flashfreaking
LFC Executive Outcomes
|
Posted - 2008.07.05 19:00:00 -
[33]
Liiza, instead of asking this, read the thread, and the post above you, Ooo doesn't work with it, neither does the excell viewer of 2003. Disallowed sig graphic. Send an e-mail to [email protected] when it meets the forum signature guidelines. ~Saint |
Kazuo Ishiguro
House of Marbles Zzz
|
Posted - 2008.07.05 19:01:00 -
[34]
Edited by: Kazuo Ishiguro on 05/07/2008 19:02:47 I'd say open it up anyway. If someone does come along and refine it, you can learn from them. And believe me, it may look like a mess but I bet it's nothing like as bad as some of the spreadsheets I've worked with...
Also, if the game is updated at some point and you're no longer around, people can keep the spreadsheet in sync with it Zzz research towers Direrie NEW: Liekuri
20:1 low-end compression |
Xanaria
Tovil-Toba's Elite Guard
|
Posted - 2008.07.18 16:54:00 -
[35]
Very useful spreadsheet, however there seems to be a problem when using multiple ECM with strength higher than the target ship's strength (the more ECM applied the less the chance to jam is).
Other than that great work, keep it up
|
Solar Ray
|
Posted - 2008.07.20 06:25:00 -
[36]
Great spreadsheet, very useful. I have a question about the situation, where I fit, say 4 *different* racial jammers on my Kitsune. One jammer type for each race. I need to know the cumulative chance to jam a particular ship using *all four jammers*. Is there a way to know that?
In practice it is quite rare to have all racial jammers of one particular type. Also, when the "main" racial jammer fails, one usually wants to take a shot using other race jammers, since together they still seem to produce a better chance than multispectrals.
|
Peter Strasser
Eve University Ivy League
|
Posted - 2008.08.20 20:03:00 -
[37]
Thank you! I absolutely love this tool. Fantastic work. I'll be pointing my students to this thread.
The one thing I'd like to see is an option to set Signal Dispersion to 0. Eve Uni teaches from ab initio.
Kudos & Cheers! |
Rifter Drifter
Minmatar Greatly Reducing Inflation Every Fight
|
Posted - 2008.08.20 20:40:00 -
[38]
why the **** does this even exist?
here.. a simple Jamming Calculator.
Falcon, Permajammed Scorpion, if it locks you, permajammed
everything else, hope you get a few free cycles.
|
Seeing EyeDog
|
Posted - 2008.08.20 20:45:00 -
[39]
im sorry, but maybe im dumb. How do you calculate something that is partially chance based?? |
Sollan Dyl
|
Posted - 2008.09.16 05:56:00 -
[40]
sry guys I have been doing other things of late and haven't had a chance to update this, but i have now got excel bak on my computer and am ready to go
Originally by: Solar Ray Great spreadsheet, very useful. I have a question about the situation, where I fit, say 4 *different* racial jammers on my Kitsune. One jammer type for each race. I need to know the cumulative chance to jam a particular ship using *all four jammers*. Is there a way to know that?
In practice it is quite rare to have all racial jammers of one particular type. Also, when the "main" racial jammer fails, one usually wants to take a shot using other race jammers, since together they still seem to produce a better chance than multispectrals.
Yes you are quite right, in Eve world jamming you can "hit" with non racial jammers, so to help with this I might add into the "Ecm module" section a non racial jamming module, i will add two, 1 for a tech 1 module (1) and 1 for a tech 2 module (1.2). This will workout your percent chance to hit if you miss with your racials. Unfortunately to work out a total percentage chance with both your racials and non racials would require a whole rewrite.
Originally by: Seeing EyeDog im sorry, but maybe im dumb. How do you calculate something that is partially chance based??
basically this spreadsheet works out your chance to "hit" a particular ship with a cycle your jammers, it's essential for all ECM pilots as they can accurately predict their chance to jam any ship they might meet in the eve universe.
|
|
FlameGlow
Legio Octae Rebellion Alliance
|
Posted - 2008.09.16 08:18:00 -
[41]
Originally by: Solar Ray Great spreadsheet, very useful. I have a question about the situation, where I fit, say 4 *different* racial jammers on my Kitsune. One jammer type for each race. I need to know the cumulative chance to jam a particular ship using *all four jammers*. Is there a way to know that?
In practice it is quite rare to have all racial jammers of one particular type. Also, when the "main" racial jammer fails, one usually wants to take a shot using other race jammers, since together they still seem to produce a better chance than multispectrals.
Huh? Decent skilled kitsune will have about 12/4 on racials, 8 on multispecs; 4 jammers So against single target BS with say 24 strength using all your jammers gives total jam chance 81% with 4 multis and 71% with 4 different racials. Racials have advantage in range and cap consumption so it's up to you to decide what do you want.
_____________ I don't care what is nerfed, as long as it's not my "undock" button. |
dillsol
|
Posted - 2008.12.14 18:17:00 -
[42]
Sollan Dyls alt here,
I have a new version of the eve jamming calculator, Sollan can't currently log in to update the original post, so this is the link to the new file
EVE Ecm Jamming Calculator v1.2
I have updated it so you can select if you don't want to use the signal dispersion skill as peter from eve university requested
also I have added the ability to calculate the chance to jam with your "other" racial jammers not suited to the ship your trying to jam.
And also fixed a few other bugs and visuals
Hope you's like it
|
Sollan Dyl
|
Posted - 2009.01.05 02:10:00 -
[43]
original post updated |
Bellum Eternus
Gallente Death of Virtue
|
Posted - 2009.01.05 02:44:00 -
[44]
Great work. Bellum Eternus Inveniam viam aut faciam.
Death of Virtue is Recruiting
|
|
|
|
Pages: 1 2 :: [one page] |