Random Thoughts.....What Are You Thinking?

Eorzea Time
 
 
 
言語: JP EN FR DE
日本語版のFFXIVPRO利用したい場合は、上記の"JP"を設定して、又はjp.ffxivpro.comを直接に利用してもいいです
users online
フォーラム » Everything Else » Undead » Random Thoughts.....What are you thinking?
Random Thoughts.....What are you thinking?
First Page 2 3 ... 5269 5270 5271 ... 22996 22997 22998
 Valefor.Slipispsycho
Offline
サーバ: 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.
Offline
Posts: 7851
By Irohuro 2012-04-01 17:00:43  
you have facebook slip?
 Valefor.Slipispsycho
Offline
サーバ: Valefor
Game: FFXI
Posts: 14155
By Valefor.Slipispsycho 2012-04-01 17:04:40  
No, wife does.
 Leviathan.Catnipthief
Offline
サーバ: Leviathan
Game: FFXI
user: Fyyvoaa
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.
 Siren.Kalilla
VIP
Offline
サーバ: Siren
Game: FFXI
user: Kalila
Posts: 14552
By Siren.Kalilla 2012-04-01 17:09:01  
Ramuh.Sagittario said: »
Valefor.Slipispsycho said: »
Siren.Kalilla 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 .-.
 Asura.Chuuuuu
Offline
サーバ: Asura
Game: FFXI
user: chuuuuu
Posts: 19930
By Asura.Chuuuuu 2012-04-01 17:10:14  
 Shiva.Spathaian
Offline
サーバ: Shiva
Game: FFXI
user: Spathaian
Posts: 27982
By Shiva.Spathaian 2012-04-01 17:12:16  
I know that was an april fools thing but it makes me sad. >.>
 Asura.Chuuuuu
Offline
サーバ: Asura
Game: FFXI
user: chuuuuu
Posts: 19930
By Asura.Chuuuuu 2012-04-01 17:13:01  
i was amused by it lol
 Valefor.Slipispsycho
Offline
サーバ: Valefor
Game: FFXI
Posts: 14155
By Valefor.Slipispsycho 2012-04-01 17:13:06  
Siren.Kalilla said: »
Ramuh.Sagittario said: »
Valefor.Slipispsycho said: »
Siren.Kalilla 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 .-.
 Ramuh.Sagittario
Offline
サーバ: Ramuh
Game: FFXI
user: Sagi
Posts: 16303
By Ramuh.Sagittario 2012-04-01 17:13:15  
Siren.Kalilla said: »
Ramuh.Sagittario said: »
Valefor.Slipispsycho said: »
Siren.Kalilla 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
Guide Maker
Offline
サーバ: Phoenix
Game: FFXI
user: Seha
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.
[+]
 Ramuh.Sagittario
Offline
サーバ: Ramuh
Game: FFXI
user: Sagi
Posts: 16303
By Ramuh.Sagittario 2012-04-01 17:18:48  
Grats Miss Chan!
 Alexander.Drokin
Offline
サーバ: Alexander
Game: FFXI
user: drokin
Posts: 2740
By Alexander.Drokin 2012-04-01 17:19:32  
Siren.Kalilla said: »
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.
 Shiva.Leonkasai
MSPaint Winner
Offline
サーバ: Shiva
Game: FFXI
user: Leonkasai
Posts: 2391
By Shiva.Leonkasai 2012-04-01 17:20:28  
Congrats Seha~
[+]
 Alexander.Drokin
Offline
サーバ: Alexander
Game: FFXI
user: drokin
Posts: 2740
By Alexander.Drokin 2012-04-01 17:20:51  
Phoenix.Sehachan said: »
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*
 Siren.Kalilla
VIP
Offline
サーバ: Siren
Game: FFXI
user: Kalila
Posts: 14552
By Siren.Kalilla 2012-04-01 17:20:59  
Alexander.Drokin said: »
Siren.Kalilla said: »
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
Offline
サーバ: Hades
Game: FFXI
user: Sirseiko
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?
[+]
 Leviathan.Catnipthief
Offline
サーバ: Leviathan
Game: FFXI
user: Fyyvoaa
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
Offline
サーバ: Cerberus
Game: FFXI
user: Valmur
Posts: 3642
By Cerberus.Valmur 2012-04-01 17:24:35  
Phoenix.Sehachan said: »
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
 Ramuh.Sagittario
Offline
サーバ: Ramuh
Game: FFXI
user: Sagi
Posts: 16303
By Ramuh.Sagittario 2012-04-01 17:25:43  
Hades.Triet said: »

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
 Leviathan.Catnipthief
Offline
サーバ: Leviathan
Game: FFXI
user: Fyyvoaa
Posts: 18930
By Leviathan.Catnipthief 2012-04-01 17:26:56  
ohgawdydidiclickthat
 Alexander.Drokin
Offline
サーバ: Alexander
Game: FFXI
user: drokin
Posts: 2740
By Alexander.Drokin 2012-04-01 17:27:12  
Siren.Kalilla said: »
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: )
[+]
 Ramuh.Sagittario
Offline
サーバ: Ramuh
Game: FFXI
user: Sagi
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!
 Ramuh.Laffter
Offline
サーバ: Ramuh
Game: FFXI
user: Rocketpop
Posts: 11972
By Ramuh.Laffter 2012-04-01 17:40:12  
Ramuh.Sagittario said: »
Hades.Triet said: »

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.
 Ramuh.Laffter
Offline
サーバ: Ramuh
Game: FFXI
user: Rocketpop
Posts: 11972
By Ramuh.Laffter 2012-04-01 17:40:55  
I laugh way too hard at that picture <_<
 Hades.Triet
Offline
サーバ: Hades
Game: FFXI
user: Sirseiko
Posts: 1615
By Hades.Triet 2012-04-01 17:45:55  
Ramuh.Laffter said: »
I laugh way too hard at that picture <_<
[+]
 Leviathan.Catnipthief
Offline
サーバ: Leviathan
Game: FFXI
user: Fyyvoaa
Posts: 18930
By Leviathan.Catnipthief 2012-04-01 17:47:00  
Ramuh.Sagittario said: »
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 ....
 Ramuh.Sagittario
Offline
サーバ: Ramuh
Game: FFXI
user: Sagi
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 :(
 Bismarck.Moonlightespada
MSPaint Winner
Offline
サーバ: Bismarck
Game: FFXI
Posts: 9553
By Bismarck.Moonlightespada 2012-04-01 18:21:24  
Its Infectious Sagi
[+]
 Alexander.Drokin
Offline
サーバ: Alexander
Game: FFXI
user: drokin
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? ; ;
First Page 2 3 ... 5269 5270 5271 ... 22996 22997 22998