These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

New Missile Names
Author
Previous Topic Next Topic
TheSmokingHertog
Julia's Interstellar Trade Emperium
#1 - 2012-01-24 16:23:44 UTC
Are you MD'ers also happy with changing all Excel sheet to the new names for missiles?

Thougth I had build some very dynamic fields, but it seems that I cant change the names on missiles for this month, else I have to reset a lot of data ;). Access on the other hand, was easy, it was build on the productID number, not the names.

"Dogma is kind of like quantum physics, observing the dogma state will change it." ~ CCP Prism X

"Schrödinger's Missile. I dig it." ~ Makari Aeron

-= "Brain in a Box on Singularity" - April 2015 =-
Officer Nyota Uhura
#2 - 2012-01-25 07:27:02 UTC
Too high tech excel for me. I use a pen and paper.
hellscure
Caldari Provisions
Caldari State
#3 - 2012-01-25 08:39:45 UTC
Changing all the spreadsheets was a pain... I do hope that they do not revert the change back again.
It is going to be a hell of work, to modify all guides/online pdf's/ and other stuff..
Lucinda Hamu
Doomheim
#4 - 2012-01-25 08:40:22 UTC
It came as some shock to me to find that after I had negotiatied a deal for a number of researched missle BPO's the contract was for different BPOs. I almost had a fall out with the seller before realising I was an idiot and the names had changed.
Gre gore
Naliao Inc.
Test Alliance Please Ignore
#5 - 2012-01-27 18:55:11 UTC
Find/Replace All

I would assign the names to a number in excel too. vlookup is your friend.
TheSmokingHertog
Julia's Interstellar Trade Emperium
#6 - 2012-01-27 18:57:05 UTC
Gre gore wrote:
Find/Replace All

I would assign the names to a number in excel too. vlookup is your friend.


Vlookup, that was the one making spreadsheets in space possible, why didn't they teach me that one @ college!

"Dogma is kind of like quantum physics, observing the dogma state will change it." ~ CCP Prism X

"Schrödinger's Missile. I dig it." ~ Makari Aeron

-= "Brain in a Box on Singularity" - April 2015 =-
Kagan Storm
Doomheim
#7 - 2012-01-27 20:50:40 UTC
Why were the names changed?
Nobody said it
Nobody wanted it
Nobody ever mentioned missile names beeing confusing.

Why was this done?

My opinion somebody in CCP hired a family member and like had to give him "a job" so he can justify him beeing in the corporation and reviving a salary.


This is/was ********.

My ego is the the size of my carriers jump range.
Shar Tegral
#8 - 2012-01-27 20:55:46 UTC  |  Edited by: Shar Tegral
This
Gre gore wrote:
Find/Replace All

Not this
Gre gore wrote:
vlookup is your friend.

Learn to love Sumif more. It will make your Excel-fu strong!


PS: vlookup can create an increasing cpu load whereas sumif can stand in without the same cpu load. As your spreadsheet grows so to will the calculate load. Using vlookup, as a primary tool, eventually had me turning off auto-calculate.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#9 - 2012-01-27 21:02:57 UTC
databases ftw Blink

Joins are your friend. And if you can't stand to leave excel, there's always ODBC for doing your pivot tables.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Syrk
Caldari Militia Supply Corps
#10 - 2012-01-29 05:13:57 UTC
Shar Tegral wrote:
This
Gre gore wrote:
Find/Replace All

Not this
Gre gore wrote:
vlookup is your friend.

Learn to love Sumif more. It will make your Excel-fu strong!


PS: vlookup can create an increasing cpu load whereas sumif can stand in without the same cpu load. As your spreadsheet grows so to will the calculate load. Using vlookup, as a primary tool, eventually had me turning off auto-calculate.


Excel is the game. EVE is a good third-party mod to that game.
Mantra Achura
Stammtisch
#11 - 2012-01-29 14:42:46 UTC
In case you are using item names instead of item ids for identification purposes you made something wrong.
Just for visualization purposes "Find/Replace All" is your friend.
TheSmokingHertog
Julia's Interstellar Trade Emperium
#12 - 2012-01-29 23:34:39 UTC
Mantra Achura wrote:
In case you are using item names instead of item ids for identification purposes you made something wrong.
Just for visualization purposes "Find/Replace All" is your friend.


First, thx for the SUMIF()... lets test it later on.

About the wrongness, I had not planned to use this excel sheet in the extended version state it ended up in. Blink

"Dogma is kind of like quantum physics, observing the dogma state will change it." ~ CCP Prism X

"Schrödinger's Missile. I dig it." ~ Makari Aeron

-= "Brain in a Box on Singularity" - April 2015 =-
Invictra Atreides
Toward the Terra
#13 - 2012-01-30 00:11:10 UTC
Kagan Storm wrote:
Why were the names changed?
Nobody said it
Nobody wanted it
Nobody ever mentioned missile names beeing confusing.

Why was this done?

My opinion somebody in CCP hired a family member and like had to give him "a job" so he can justify him beeing in the corporation and reviving a salary.


This is/was ********.


Are you saying that they shouldn't have done that? Just because you don't read the Patch notes or the Dev blogs doesn't mean that CCP didn't give us any information regarding the name change.

Hybrids:
Antimatter Charges
- Small
- Medium
- Large
- Extra Large

Projectiles:
EMP Charges
- Small
- Medium
- Large
- Extra Large

Crystals:
Multifrequency
- Small
- Medium
- Large
- Extra Large

Missiles:
Kinnetic
- Light ("Bloodclaw" Light Missile)
- Heavy ("Scourge" Heavy Missile)
- Cruise ("Wrath" Cruise Missile)
- Citadel ("Rift" Citadel Missile)


More user friendly for new players. Should have been done ages ago. Why where missiles the only ones with fancy names.

Blog | Tutorials | Youtube "I don’t know everything, I just know what I know."
Krixtal Icefluxor
INLAND EMPIRE Galactic
#14 - 2012-01-30 01:20:13 UTC  |  Edited by: Krixtal Icefluxor
Kagan Storm wrote:
Why were the names changed?
Nobody said it
Nobody wanted it
Nobody ever mentioned missile names beeing confusing.

Why was this done?

My opinion somebody in CCP hired a family member and like had to give him "a job" so he can justify him beeing in the corporation and reviving a salary.


This is/was ********.



Thank GOD for the change.

I remember staring at my blue EM Cruise Missiles wondering why the hell is this thing called PARADISE ??????? Shocked

Obviously you never got to T2 where the names split into Fury and Precision...and the designations for the lesser missiles along the same lines.....and then the Faction designations too.................

Really a quadruple bizzarro Naming System 'twas.........

And if one is bitter because it mangled a spreadsheet....please kill me if EVE becomes more complicated for me than pen and paper. I really would need a life then.............

"He has mounted his hind-legs, and blown crass vapidities through the bowel of his neck."  - Ambrose Bierce on Oscar Wilde's Lecture in San Francisco 1882
Zeta Zhul
Preemptive Paranoia
#15 - 2012-01-30 20:37:36 UTC
Invictra Atreides wrote:
...

More user friendly for new players. Should have been done ages ago. Why where missiles the only ones with fancy names.


Well then why the "Trauma" missile name? Missiles generally have a single specific damage type. They're missiles! Just use the damage type then. It'll make life a lot easier.

I'd rather deal with Kinetic Heavy Missile or EMP Cruise Missile than whatever FOTM crappy name they give the things. At least then it would make some sort of sense. Now I've got to go through and modify not only existing data but past archived data for something that doesn't really accomplish anything.
Utemetsu
#16 - 2012-01-30 20:49:15 UTC
Of course, if they changed it back, wouldn't you have to change your spreadsheets to reflect that...again?
TheSmokingHertog
Julia's Interstellar Trade Emperium
#17 - 2012-01-31 16:35:08 UTC
Utemetsu wrote:
Of course, if they changed it back, wouldn't you have to change your spreadsheets to reflect that...again?


Not me... have made the spreadsheets so EVE can change them forever... without trouble. Now use the Product ID only within the Excel sheet. Vlookup will add the name based on a list that can be changed easily, on the locations necessarily.

"Dogma is kind of like quantum physics, observing the dogma state will change it." ~ CCP Prism X

"Schrödinger's Missile. I dig it." ~ Makari Aeron

-= "Brain in a Box on Singularity" - April 2015 =-