I have been searching around google and I even called Microsoft and they hanged up cause they didn't know. Anyways... I am trying to multiply the entire Y column because thats my exp for monsters instead of doing it manually 1 by 1 is there a formula or something I can do to do it very quickly?
Take down the row and column ofc.
and over to side of everything place the formula.
=SUM(Y2*2)
Then you click on the box that has that forumula (which should now be showing the exp value in the column y row 2 box * (times) 2.
And the box should have a dark box around it and a square at the bottom right of it. click and hold that square, and drag it down till its in line with the last monster.
It will multiply all the exp values to that amount.
Save the document so it saves the value not the formula. (IMPORTANT)
Re-open the file then copy the entire list that you just made and then paste it over the old exp values, then you can remove the list you made off to side.
If you don't save it, then re-open it, you will only copy the formula in the box's not the value. Note: the formula might differ a LITTLE because I just used open office (free version of microsoft office) but as far as i can remember, if it is going to be any different you might just have to tell it to not increase the value of the *2.(which is done with a $ in front of the 2, so *$2) Because of how the drag option works it takes the numbers n adds one to it for you. Microsoft exel should be smart enough to not increase the *2 value as well as the free version anyway, but it should pop up with a suggestion if its wrong anyway.
I get a #VALUE! error
I didnt understand what you mean by "and over to side of everything place the formula."
If you provide pictures it will help me more, im a visual person.
Only thing i know is for example ur exp on blaverus is 500 then do =10*500 will make it 10x but this still takes long time if u do it manualy thats why i got logitech G110 which allows macros and scripts otherwise ther is a way to do the column at once but i cud never find out on google xD gl finding the way haha
Like, open the csv in exel, go to the end of all the csv's basic info.
So basically you want to start at GH2 if you using a3 files.
Put in the formula so you are multiplying the exp (column y) in row 2 (first monster).
Which SHOULD be: =SUM(Y2*2) (If that formula is not working for you, click on the sum symbol next to where you can type at the top. Hover your mouse over icons there till you find it. Then you can just put in what box you want to use as a reference (y2) then times (*) it by whatever value you want.)
Then press enter and it should show you the value of the first monsters exp times by 2.
If so, click on that box so its highlighted, then at bottom right of the box there should be a square. Click and hold that square then drag it down.
I really don't feel like getting screen shots of each part and making a "tutorial" on how to do it just because it is quite simple.
If you are having trouble still then I guess I will have to....
wow, seems all of you are making it entirely too complicated
there will be a box around the first one you do, with a little square in the bottom right hand corner of that box, grab that little square, drag it all the way to the bottom.
save as a CSV file, it will tell you ur going to lose format blah blah blah, click yes.
done.
really not that hard, microsoft prolly hung up on you cus they couldnt fathom such an ignorant question
wow, seems all of you are making it entirely too complicated
there will be a box around the first one you do, with a little square in the bottom right hand corner of that box, grab that little square, drag it all the way to the bottom.
save as a CSV file, it will tell you ur going to lose format blah blah blah, click yes.
done.
really not that hard, microsoft prolly hung up on you cus they couldnt fathom such an ignorant question
google is ur friend btw
Did you not.... read what has been said in this thread?
That is what I have said... lol.
No offense but that post isn't needed nor warranted.
no offense but ur explanation sux ***, hes having a difficult time understanding cus ur making it too complicated, obviously another post is needed and warranted otherwise he wouldnt be having trouble with ur explanation
u failed to tell him how to save it, just it was important to do so, which no offense, but was stupid
the link i posted has screenshots, which he asked for
i didnt take something that could be said in one sentence and make it into a 3 page tutorial.
so no offence but if u dont want someone reexplaining, make a post that doesnt suck.
Josh just ignore him, anyways I added my monster.csv if you can add pictures in it when your done with it, it will be great so next time if I want to change it I dont have to ask about this topic again.
Josh just ignore him, anyways I added my monster.csv if you can add pictures in it when your done with it, it will be great so next time if I want to change it I dont have to ask about this topic again.
Ok done, and here is a tutorial on how to do it.
Put the csv on media fire because Epvp's upload system hates me lol.
Josh just ignore him, anyways I added my monster.csv if you can add pictures in it when your done with it, it will be great so next time if I want to change it I dont have to ask about this topic again.
ok well, **** you too
dont worry i wont be helping you for **** anymore, so you wont have to worry about him ignoring my posts on ur threads, there wont be one, obviously ur just another 'do it for me' anyways, ur loss not mine. . . .
dont worry i wont be helping you for **** anymore, so you wont have to worry about him ignoring my posts on ur threads, there wont be one, obviously ur just another 'do it for me' anyways, ur loss not mine. . . .
They want a tutorial so they know how to do it themselves...
And I offered to do it for them. There is a difference.
And if that is how you feel, why bother posting. is it not simpler to just ignore it and move on?
You could go ahead and say the same to me about replying to you, but I'm just replying because I don't see the point nor sense in that post, other then to basicaly say "ok **** you not helping you" which is just not needed to say.
If you have nothing constructive to say, don't say anything.
And if you cant see the constructive side of what I've said here then well... gg.
Edit: My point is... Calling them lazy n **** is as idiotic as calling EVERYONE in this community lazy for using serverfiles they did not make. Which is just silly and childish....
[Excel]Question 11/04/2012 - Dekaron Private Server - 5 Replies i just downloaded excel etc but i couldnt seem to find something how to split csv each column .. :S like every , is a new column its just as messed up as notepad lol any can explain me abit how to change this so everything is splitted up in their columns ?
[QUESTION] Little Excel Problem 08/08/2011 - Dekaron - 3 Replies hi guys,i have little problem with the view in excel how can i make it to normal view,because when i open .csv with excel it looks like spaghetti all messed up :D
http://img8.imageshack.us/img8/9244/excelproblem. jpg
Uploaded with ImageShack.us
[HELP]excel on db 12/31/2010 - EO PServer Hosting - 6 Replies anyone know to connect and edit database with microsoft excell 2010?
CSV with excel question 10/23/2009 - Dekaron - 1 Replies im trying to do the no agro for crespo a,b,c read the tut that has been posted in hacks section, Can someone list the monsters for B,C. The tut says to use the search for the id of the monsters, but i dont know how using excel. Any help would be great. Or the list of monsters ;)
Question. about useing Excel 03/26/2009 - Dekaron - 4 Replies in all the tut movies i see pplz click on the line and all the numbers up to this blank:
http://triton.imageshack.us/Himg259/scaled.php?se rver=259&filename=93961427.jpg&xsize=640&a mp;ysize=480
how i do it?
otherwise ther is a way to do the column at once but i cud never find out on google xD gl finding the way haha
