Topic: Excel table to wiki  (Read 755 times)


tedomedo

« on: August 03, 2017, 11:33:33 AM »
Hi. How can i add my excel table to a wiki and to keep everything (colors, borderings, row/column sizes...)?

Ametsala

« Reply #1 on: August 04, 2017, 03:21:19 PM »
First of all, especially if your table has complex information (like the ones in the wiki's Plants page), make sure your table's wikicode is legible after conversion. The point of a wiki is that anyone can edit it at anytime so everyone needs to be able to understand the wikicode now and in the future.

I created the week calendar for the wiki using OpenOffice. Saved as html and copy pasted the contents of the html file to http://bmanolov.free.fr/html2wiki-tables.php#wiki. This created a lot of chaff though (IIRC, all formatting was saved individually for each cell and there were some completely unnecessary tidbits I removed manually), and the resulting wikicode is hard to read.

Can't remember if I've used this method for another table that doesn't change bg color in the middle of rows/columns, so don't know how it handles such tables. For such, I might just use a simpler widget like the Copy and Paste Excel-to-Wiki Converter and add colors etc. manually afterwards.

There's also a VBA-Macro for EXCEL table conversion, but I haven't played with that. (Haven't had excel in years)

See also:
Wikipedia's tool page
Wikimedia Commons: Convert tables and charts to wiki code or image files


tedomedo

« Reply #2 on: August 06, 2017, 10:56:41 AM »
After some experiments I do this: paste excel table to .rtf in word, sometimes i have to resize rows and columns because pasted table has not the same size as in excel, then i save this as filtered html. There's no need to convert html to wiki - at least not on http://unrealworld.wikia.com, where i updated Cultures 2 days ago for version 3.30.
« Last Edit: August 06, 2017, 11:02:51 AM by tedomedo »

koteko

« Reply #3 on: August 28, 2017, 05:41:49 PM »
After some experiments I do this: paste excel table to .rtf in word, sometimes i have to resize rows and columns because pasted table has not the same size as in excel, then i save this as filtered html. There's no need to convert html to wiki - at least not on http://unrealworld.wikia.com, where i updated Cultures 2 days ago for version 3.30.

@tedomedo do you by any chance have those tables for 3.4 too? I would be curious to see if the stats distribution has changed.

EDIT: also there's something strange with the first table (at least). Some of the "top" numbers are lower than the "average" numbers, which is impossible. Eg, Owl supposedly had a "top strength" of 3? That's probably a mistake but there are a few in there.
« Last Edit: August 28, 2017, 05:50:21 PM by koteko »

tedomedo

« Reply #4 on: September 14, 2017, 12:29:39 AM »
top = the best found profile  (not the best found individual attribute)

The best profile i was able to find for Owl-Tribe has strength 3. Sum of all attributes for this best profile is 172. If you divide 172 by amount of all attributes (11), you get average, which is 15.6  (in my language we use , for decimals) and that's what you see in row Average.

Sami the Boss says that 3.4 has the same skills and attributes relations as 3.3.
« Last Edit: September 14, 2017, 01:17:58 AM by tedomedo »

koteko

« Reply #5 on: September 14, 2017, 02:26:30 PM »
I see - "best profile" is just the one with highest sum of attributes. I was a bit confused as to what that column actually reported.

Would you share the raw data? :)

tedomedo

« Reply #6 on: September 14, 2017, 05:36:28 PM »
Yes, i'm thinking about this. I can convert my excel table with all acquired stats to pdf using primo pdf and save it somewhere.

koteko

« Reply #7 on: September 14, 2017, 06:46:10 PM »
Why not share the excel table? Would be much easier to play around and try to squeeze out more information, as a collective effort ;)

tedomedo

« Reply #8 on: September 16, 2017, 03:01:51 PM »
Pdf is created and available. Go to http://unrealworld.wikia.com/wiki/Cultures

tedomedo

« Reply #9 on: September 21, 2017, 11:39:05 AM »
I don't want to start a new topic about my wiki posting. Let me know if you want to see something more in pdf and wiki site about cultures. I already know cheat engine addresses for body height and weight. I will add this once too. Of course, Sami won't give formulas for everything else :)