|
Random Thoughts.....What are you thinking?
Server: Valefor
Game: FFXI
Posts: 14155
By Valefor.Slipispsycho 2012-04-01 16:51:20
A friend of mine just posted pics on his face book of him and Tech N9ne.. He got backstage passes to the concert he's having in Houston tonight.
By Irohuro 2012-04-01 17:00:43
you have facebook slip?
Server: Valefor
Game: FFXI
Posts: 14155
By Valefor.Slipispsycho 2012-04-01 17:04:40
No, wife does.
Server: Leviathan
Game: FFXI
Posts: 18930
By Leviathan.Catnipthief 2012-04-01 17:07:01
Valefor.Slipispsycho said: »A friend of mine just posted pics on his face book of him and Tech N9ne.. He got backstage passes to the concert he's having in Houston tonight.
:o
I'd actually like to see this guy in concert, I don't like much rap but I was a bit amazed with him lol.
VIP
Server: Siren
Game: FFXI
Posts: 14552
By Siren.Kalilla 2012-04-01 17:09:01
Valefor.Slipispsycho said: »Thank you google... =MID([text source],FIND("[text]",[text source]),#)
Wanted to find a way to search within a cell and return a substring when I don't know the start point... that was bugging me so much! I.. Uh... Well..
/brain goes poof.
Indeed x_x lol D:
Well I'm currently trying to make my own calculator in excel and wanted to pull the description of all 6144 armor pieces to find out value of an attribute, for example:
DEF:30 MND+10 Healing magic skill +10 "Cure" potency +11% Enmity-5
and I wanted to find out how much MND is in this description. I first check to see if it has it, and if it does then I continue to find the midpoint of MND, then I add 3 to start at the plus sign and tell it to give me a string of 3 values after the midpoint, so in this case it would give me (+10). I then find out if its positive or negative then convert it into a number instead of text so I can use it in equations!
So I figured it out and was happy .-.
Server: Asura
Game: FFXI
Posts: 19930
By Asura.Chuuuuu 2012-04-01 17:10:14
Server: Shiva
Game: FFXI
Posts: 27982
By Shiva.Spathaian 2012-04-01 17:12:16
I know that was an april fools thing but it makes me sad. >.>
Server: Asura
Game: FFXI
Posts: 19930
By Asura.Chuuuuu 2012-04-01 17:13:01
i was amused by it lol
Server: Valefor
Game: FFXI
Posts: 14155
By Valefor.Slipispsycho 2012-04-01 17:13:06
Valefor.Slipispsycho said: »Thank you google... =MID([text source],FIND("[text]",[text source]),#)
Wanted to find a way to search within a cell and return a substring when I don't know the start point... that was bugging me so much! I.. Uh... Well..
/brain goes poof.
Indeed x_x lol D:
Well I'm currently trying to make my own calculator in excel and wanted to pull the description of all 6144 armor pieces to find out value of an attribute, for example:
DEF:30 MND+10 Healing magic skill +10 "Cure" potency +11% Enmity-5
and I wanted to find out how much MND is in this description. I first check to see if it has it, and if it does then I continue to find the midpoint of MND, then I add 3 to start at the plus sign and tell it to give me a string of 3 values after the midpoint, so in this case it would give me (+10). I then find out if its positive or negative then convert it into a number instead of text so I can use it in equations!
So I figured it out and was happy .-.
Server: Ramuh
Game: FFXI
Posts: 16303
By Ramuh.Sagittario 2012-04-01 17:13:15
Valefor.Slipispsycho said: »Thank you google... =MID([text source],FIND("[text]",[text source]),#)
Wanted to find a way to search within a cell and return a substring when I don't know the start point... that was bugging me so much! I.. Uh... Well..
/brain goes poof.
Indeed x_x lol D:
Well I'm currently trying to make my own calculator in excel and wanted to pull the description of all 6144 armor pieces to find out value of an attribute, for example:
DEF:30 MND+10 Healing magic skill +10 "Cure" potency +11% Enmity-5
and I wanted to find out how much MND is in this description. I first check to see if it has it, and if it does then I continue to find the midpoint of MND, then I add 3 to start at the plus sign and tell it to give me a string of 3 values after the midpoint, so in this case it would give me (+10). I then find out if its positive or negative then convert it into a number instead of text so I can use it in equations!
So I figured it out and was happy .-.
[+]
Phoenix.Sehachan
Server: Phoenix
Game: FFXI
Posts: 13352
By Phoenix.Sehachan 2012-04-01 17:14:03
3/3 gorgets on Qilin in a row. He sure wanted me to have that thing.
Server: Ramuh
Game: FFXI
Posts: 16303
By Ramuh.Sagittario 2012-04-01 17:18:48
Grats Miss Chan!
Alexander.Drokin
Server: Alexander
Game: FFXI
Posts: 2740
By Alexander.Drokin 2012-04-01 17:19:32
Valefor.Slipispsycho said: »Thank you google... =MID([text source],FIND("[text]",[text source]),#)
Wanted to find a way to search within a cell and return a substring when I don't know the start point... that was bugging me so much! I.. Uh... Well..
/brain goes poof.
Indeed x_x lol D:
Well I'm currently trying to make my own calculator in excel and wanted to pull the description of all 6144 armor pieces to find out value of an attribute, for example:
DEF:30 MND+10 Healing magic skill +10 "Cure" potency +11% Enmity-5
and I wanted to find out how much MND is in this description. I first check to see if it has it, and if it does then I continue to find the midpoint of MND, then I add 3 to start at the plus sign and tell it to give me a string of 3 values after the midpoint, so in this case it would give me (+10). I then find out if its positive or negative then convert it into a number instead of text so I can use it in equations!
So I figured it out and was happy .-.
I was a bit confused by the word "cell" in the first post. My mind went straight to HTML, not a spreadsheet. ; ;
I think to simplify for non-tech people, it's doing this:
- Search spreadsheet cell.
> Does cell have "MND"?
No - Stop
Yes - Check next 3 digits
> Is first digit + or -?
+ Add to total MND
- Subtract from total MND
I could be wrong but that's how it sounds.
Server: Shiva
Game: FFXI
Posts: 2391
By Shiva.Leonkasai 2012-04-01 17:20:28
Congrats Seha~
[+]
Alexander.Drokin
Server: Alexander
Game: FFXI
Posts: 2740
By Alexander.Drokin 2012-04-01 17:20:51
3/3 gorgets on Qilin in a row. He sure wanted me to have that thing.
Con... graulations?
Sorry, never got around to VW. I hope that's a good thing that you got! *goes to Wiki, probably still won't know if it's any good*
VIP
Server: Siren
Game: FFXI
Posts: 14552
By Siren.Kalilla 2012-04-01 17:20:59
Valefor.Slipispsycho said: »Thank you google... =MID([text source],FIND("[text]",[text source]),#)
Wanted to find a way to search within a cell and return a substring when I don't know the start point... that was bugging me so much! I.. Uh... Well..
/brain goes poof.
Indeed x_x lol D:
Well I'm currently trying to make my own calculator in excel and wanted to pull the description of all 6144 armor pieces to find out value of an attribute, for example:
DEF:30 MND+10 Healing magic skill +10 "Cure" potency +11% Enmity-5
and I wanted to find out how much MND is in this description. I first check to see if it has it, and if it does then I continue to find the midpoint of MND, then I add 3 to start at the plus sign and tell it to give me a string of 3 values after the midpoint, so in this case it would give me (+10). I then find out if its positive or negative then convert it into a number instead of text so I can use it in equations!
So I figured it out and was happy .-.
I was a bit confused by the word "cell" in the first post. My mind went straight to HTML, not a spreadsheet. ; ;
I think to simplify for non-tech people, it's doing this:
- Search spreadsheet cell.
> Does cell have "MND"?
No - Stop
Yes - Check next 3 digits
> Is first digit + or -?
+ Add to total MND
- Subtract from total MND
I could be wrong but that's how it sounds. yus!
Hades.Triet
Server: Hades
Game: FFXI
Posts: 1615
By Hades.Triet 2012-04-01 17:21:12

I can't help but watch this for at least 1 minute...but...where is the subligar?
[+]
Server: Leviathan
Game: FFXI
Posts: 18930
By Leviathan.Catnipthief 2012-04-01 17:23:46
*sigh* ISP is going to get a *** earful tomorrow when I call them dumbass son of a ***, internet has cut off at least 7 times in the LAST HOUR alone (not to mention the 19 times it did it the other day)
I know they will try to tell me "oh herpderp just reset the router durrrrrrr" but I won't accept anything short of them coming out here and checking this *** out.
Sick and *** tired of this crap.
Cerberus.Valmur
Server: Cerberus
Game: FFXI
Posts: 3642
By Cerberus.Valmur 2012-04-01 17:24:35
3/3 gorgets on Qilin in a row. He sure wanted me to have that thing.
Yup that thing drops all the damn time /comfort
Server: Ramuh
Game: FFXI
Posts: 16303
By Ramuh.Sagittario 2012-04-01 17:25:43

I can't help but watch this for at least 1 minute...but...where is the subligar?
It got cut out the .gif! But here is something to satisfy our needs :D
Server: Leviathan
Game: FFXI
Posts: 18930
By Leviathan.Catnipthief 2012-04-01 17:26:56
ohgawdydidiclickthat
Alexander.Drokin
Server: Alexander
Game: FFXI
Posts: 2740
By Alexander.Drokin 2012-04-01 17:27:12
Valefor.Slipispsycho said: »Thank you google... =MID([text source],FIND("[text]",[text source]),#)
Wanted to find a way to search within a cell and return a substring when I don't know the start point... that was bugging me so much! I.. Uh... Well..
/brain goes poof.
Indeed x_x lol D:
Well I'm currently trying to make my own calculator in excel and wanted to pull the description of all 6144 armor pieces to find out value of an attribute, for example:
DEF:30 MND+10 Healing magic skill +10 "Cure" potency +11% Enmity-5
and I wanted to find out how much MND is in this description. I first check to see if it has it, and if it does then I continue to find the midpoint of MND, then I add 3 to start at the plus sign and tell it to give me a string of 3 values after the midpoint, so in this case it would give me (+10). I then find out if its positive or negative then convert it into a number instead of text so I can use it in equations!
So I figured it out and was happy .-.
I was a bit confused by the word "cell" in the first post. My mind went straight to HTML, not a spreadsheet. ; ;
I think to simplify for non-tech people, it's doing this:
- Search spreadsheet cell.
> Does cell have "MND"?
No - Stop
Yes - Check next 3 digits
> Is first digit + or -?
+ Add to total MND
- Subtract from total MND
I could be wrong but that's how it sounds. yus!
Congrats on getting it figured out! Nothing like wanting to tear your hair out over a programming obstacle, only to realize there's a function to handle the problem using half a line of code. :)
(Now... you remind me that I need to get back to re-teaching myself C++ and all those other less-interesting languages. D: )
[+]
Server: Ramuh
Game: FFXI
Posts: 16303
By Ramuh.Sagittario 2012-04-01 17:36:39
Leviathan.Catnipthief said: »ohgawdydidiclickthat
You don't know it yet, but the entire FFXI community including yourself has been undergoing subligar indoctrination for the past year. You want it! YOU NEED IT!
Server: Ramuh
Game: FFXI
Posts: 11972
By Ramuh.Laffter 2012-04-01 17:40:12

I can't help but watch this for at least 1 minute...but...where is the subligar?
It got cut out the .gif! But here is something to satisfy our needs :D
Ocelot Gloves.
Server: Ramuh
Game: FFXI
Posts: 11972
By Ramuh.Laffter 2012-04-01 17:40:55
I laugh way too hard at that picture <_<
Hades.Triet
Server: Hades
Game: FFXI
Posts: 1615
By Hades.Triet 2012-04-01 17:45:55
I laugh way too hard at that picture <_<
[+]
Server: Leviathan
Game: FFXI
Posts: 18930
By Leviathan.Catnipthief 2012-04-01 17:47:00
Leviathan.Catnipthief said: »ohgawdydidiclickthat
You don't know it yet, but the entire FFXI community including yourself has been undergoing subligar indoctrination for the past year. You want it! YOU NEED IT!
uh oh ....
Server: Ramuh
Game: FFXI
Posts: 16303
By Ramuh.Sagittario 2012-04-01 18:13:29
I hate having hot feet when I'm trying to sleep feels like they are on fire :(
Server: Bismarck
Game: FFXI
Posts: 9553
By Bismarck.Moonlightespada 2012-04-01 18:21:24
[+]
Alexander.Drokin
Server: Alexander
Game: FFXI
Posts: 2740
By Alexander.Drokin 2012-04-01 18:33:38
How do you turn this kind of art
into this kind of... Um... I don't even know what to call it? ; ;
This is a thread that I found on another website I post at. It can be really really interesting. I thought it deserved a place here.
Post your random thoughts for the day here, or anything else that intrigues you.
For starters, is it possible to give constructive critism to someone who doesn't have a neck? I totally just walked by a girl who didn't. Someone isn't getting a necklace for Valentines day!
And who decided black and white can't be colors? I want to say a racist. I really do.
Inb4thisthreadgetsreallywtf
|
|