Table Making Excel Spreadsheet

[vamosj]

If I said I had an Excel Spreadsheet that creates the PC code for the tables (including color, bold, italics, and underlining), what would you pay in silvers to have this helpful tool?

[Bobmuhthol]

Sorry, I don't understand.

[Buckwheet]

Probably not because there are free websites that do this for you?

[vamosj]

Probably not because there are free websites that do this for you?

Hmm, didn't know about any websites that do this for you...

But to explain further.... Those nice tables you see here in PC such as inspires right here (http://forum.gsplayers.com/showthread.php?t=65826), can be a pain to create..

Take this table for example..


Item|
Price|
Enchant|
Remarks|
Sold?
Short Sword|
100 Silver|
0x|
Found on Kobold|
YES
Longsword|
200 Silver|
0x|
Left in TSC|
NO
Brig Armor|
500 Silver|
1x|
Bought from Pawnshop|
NO
Mace|
300 Silver|
0x|
Made by Player|
NO
Half Plate|
1000 Silver|
2x|
Invasion Drop|
NO
Fusion Orb|
1 Mil Silver|
|
Someone Gave to me|
YES



Well to code it in would look like this:

http://i.imgur.com/gv3wm.png


But instead of coding it in the PC, this is what you will be working with. Run a macro and then all you have to do is go over to PC and paste.

http://i.imgur.com/XVozK.png

[Tgo01]

10 silvers. Would have offered more but you used Inspire as an example.

[Buckwheet]

Not 100% sure as its been a while since I really messed with these, but:

http://codefisher.org/format_toolbar/

http://www.autohotkey.com/forum/topic6161.html

http://luke.breuer.com/time/item/Word2BBCode/683.aspx

Those are offline BBCode editors.

I just do this in google docs:

https://plus.google.com/photos/107806407587049026677/albums/5654886403213082833/5654886405333359234

[vamosj]

Took a look at the three websites.. Looks like it makes it a little easier but it still seems like coding the table except there's a couple of buttons that assist.

Google Docs is okay too... I just would rather deal with the actual program and not the online version.. But that's me.

[Whirlin]

I'm actually rated in the top 100 Excel users on some international help forums... If you're interested in getting a VBA solution for this, let me know... however, if there are free alternatives, I'd recommend those.

Editted: Scratch that... you were looking to sell your VBA, not for someone to make it for you...

[Inspire]

You can do what I did and copy off of Buckwheet.

(It is kind of a pain sometimes when it gets off by 1 tab)

[Sam]

I'm actually rated in the top 100 Excel users on some international help forums...

I know a guy who's top 5 all time.

[vamosj]

Hehe... Well I'm not trying to swing a dick here, but I'm one of the top... Well okay I'm not. But I like to dabble in Excel VBA and I figure I'd use this as another learning tool.. Also try and get some extra silvers out of spending some time to make it. Specially since most of the stuff I try and sell don't move much, so if I can, I try and get silvers somewhere else... Hence this little project.

I think the program works good, I'm sure there's some stuff that can be improved on it, but I'm happy with it for my level of knowledge.

[Donquix]

I think it's funny that you use lich and were just asking for help troubleshooting another stormfront script, and i'm also assuming you haven't paypaled tillmen or sent him silvers in game or anything correct me if i'm wrong there, and you're planning on trying to sell what is essentially a pipe delimited text file.

[Bobmuhthol]

So I filled A1 - C4 with some words, wrote up a shitty macro, and went to town.

Obviously it can be further built up, but this is the basis of what this macro seems to do.

Here's the macro and the resulting table:

Sub Table()
For varvar = 5 To 7
If varvar = 5 Then
Cells(varvar, 1) = "{table}" + Cells(varvar - 4, 1)
Else
Cells(varvar, 1) = Cells(varvar - 4, 1)
End If
For x = 2 To 4
If x = 4 Then
Cells(varvar, 1) = Cells(varvar, 1) + "|" + Cells(varvar - 4, x)
Else
Cells(varvar, 1) = Cells(varvar, 1) + "|" + Cells(varvar - 4, x)
End If
Next x
If varvar = 7 Then
Cells(varvar, 1) = Cells(varvar, 1) + "{/table}"
Else
' Don't do shit
End If
Next varvar
End Sub



YoMama|YoYoMama|Amama|DickMama
Yeah Boi|You Go Girl|Tits|Fish
Fish with|Tits|Titty|Fish

[Bobmuhthol]

I'm actually rated in the top 100 Excel users on some international help forums

I'm in the top 100 Excel users on this particular forum, but like you, I'm using a pretty meaningless sample of comparison.

[vamosj]

Well, I guess I shall give up all hope.. The PC Gods have spoken and have tried to make fun of me.

I shall run now and never again try and make silvers...

Matter of fact, I shall give all my silvers away and play with nothing but 0x gear found off of critters....

I feel so ashamed...:hang:

[Tgo01]

Well, I guess I shall give up all hope.. The PC Gods have spoken and have tried to make fun of me.

I shall run now and never again try and make silvers...

Matter of fact, I shall give all my silvers away and play with nothing but 0x gear found off of critters....

I feel so ashamed...:hang:

Crushed his spirit in less than 12 hours, this a new PC record?

[vamosj]

There, I have dropped my fortune atop the boulder.. You chance is now to take what I have before it's gone....

You won't be able to take it all in one trip so bring your friends....

[Asha]

I created Excel so

[Donquix]

I created Excel so

All this time i've been playing gemstone with Al Gore and I never knew it?!

[whartondanielle5]

Hehe... Well I'm not trying to swing a dick here, but I'm one of the top... Well okay I'm not. But I like to dabble in Excel VBA and I figure I'd use this as another learning tool.. Also try and get some extra silvers out of spending some time to make it. Specially since most of the stuff I try and sell don't move much, so if I can, I try and get silvers somewhere else... Hence this little project.

I think the program works good, I'm sure there's some stuff that can be improved on it, but I'm happy with it for my level of knowledge.

Excel is a really great tool for recording workouts. But unfortunately i do not know how to do something in excel. When i am asked to do something in excel at the university, i buy homework from the service. By the way, for students who, like me, do not want to do their homework on excel, i have a recommendation. Anyone who wants to make a schedule in excel, but does not know how to do it, can probably also use the help of this service. So do you need help? Then you need bookwormhub.com (https://bookwormhub.com/excel-homework.html) - it's the best service!

[Helsfeld]

Is this still available?