User:MvGulik/tmp

No Skills

No skill required (Technically!) (those that are not marked as such already):
(Assuming same for repairing)

Log Cabin

Timber House

Stone Mansion

Stonestead

Igloo

Demijohn

Sturdy Bed

Cottage Table

Rustic Table

Rustic Chair

Cloth Chair

Cottage Throne

Ram Chair

Royal Throne

Arched Chair

Long Bench

Fine Sofa

Garden Bench

Rocking Chair

Cushioned Stool

Royal Stool

Snowball

Cold Cut

Stinging Poultice

Gray Grease

Horrible Knot

Itsy Bitsy Weaver

Primitive Doll

Roast Meat

Roasthopper

Wooden Shovel

Chitin Sequins

(Leather Pocket)

+Foraging Skill: scanned/fixed. +Pottery: scanned

Lay Brick Paving

+Stone Working:

Lay Stone Paving

-- Bye bye W14.

image overlaying

Single (32x32)	Overlay(b) 32x32 + 16x16	Overlay(b) 48x48 + 24x24	Single (32x32) => 64x64	Overlay(a) 64x64	Overlay(b) 64x64 + 21x21	Overlay(b) 64x64 + 32x32
Single (32x32)	Overlay(b) 32x32 + 16x16	Overlay(b) 48x48 + 24x24	Single (32x32) => 64x64	Overlay(a) 64x64	Overlay(b) 64x64 + 21x21px	Overlay(b) 64x64 + 32x32
				Overlay(a) 64x64	Overlay(b) 64x64 + 21x21	Overlay(b) 64x64 + 32x32
						Overlay(b) 64x64 + 32x32	Overlay(c) 64x64 + 32x32

Preferring case (c).

Actually: Case (c) seems not needed for inventory related images. As these dual image-types are probably only used inside the crafting UI.

That leaves, a somewhat nasty, vertical offset difference when using non "Overlay-icon" style overlay images.

Gems q10 table test

(Amber)	Rough	Smooth	Cabochon	Pear	Heart	Brilliant
Tiny	Constitution +1	?	Constitution +1 Agility +1	Constitution +2 Agility +1	Constitution +2 Agility +1	Constitution +3 Agility +2
Small	Constitution +1 Agility +1	Constitution +3 Agility +2	Constitution +3 Agility +2	Constitution +4 Agility +2	Constitution +6 Agility +4	?
Fair	Constitution +2 Agility +1	Constitution +? Agility +?	Constitution +4 Agility +2	Constitution +6 Agility +3	Constitution +8 Agility +4 Survival +8	Constitution +9 Agility +5 Carpentry +9
Large	?	Constitution +4 Agility +2	Constitution +? Agility +?	Constitution +8 Agility +4 Farming +8	?	Constitution +12 Agility +9 Melee Combat +12
Grand	?	Constitution +4 Agility +3	Constitution +8 Agility +4 Carpentry +8	Constitution +10 Agility +6 Farming +10	Constitution +12 Agility +6 Carpentry +12	Constitution +15 Agility +7 Melee Combat +15
Jotun	?	Constitution +6 Agility +3	Constitution +12 Agility +6 Farming +12	?	Constitution +18 Agility +9 Farming +18	Constitution +19 Agility +10 Survival +19

Crappy wikitable buggers:

1) Breaks "<br>" inside the cells-content breaks simple copy and paste actions on the displayed table. Data that would normally be in one line(row) is now put on multiple lines. (only solution: not using html-breaks. :-/ )

2) Any content in the cell-style part ("|foobar|<cell content>" vs "||<cell content>" breaks the tabletool tool processing. (among other issues)

Only known potential solution would be creating(coding) a dedicated wiki-table code processor. :-/

A simple Tab-delimited output could work if it strips any html-breaks. CSV (comma-delimited & quoted-text) output would probably be nicer.

[Show/hide] Probably not useful to others.

Spreadsheet related data: (specific to these Gem tables)

Strip mediawiki table-code down to data only:

"=REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(
A1,"!\s*scope=""row""\s*\|\s*","","g")
,"style=""background-color:#d8fbd8;""","","g")
,"\?","?","g")
,"\n\|<!-.*->\|\s*","@","g")
,"(\[\[|\]\])","","g")
,"\s*
\s*"," ","g")
,"\s*\|\}\s*","
","g")
,"\|-.*\n","","g")
,"\s*\{\|.*\s*","
","")
," *!! *","@","g")
,"!\s*","","g")"
The "@" character needs to be replace with a comma or a Tab. (Tab did no work on my end, and finding the right comma if I used that here ... yea.)
+ There are two data line-breaks. As the used application simply did not support "\n" and "\t" as replacement code (which blows my mind).

Turning spreadsheet table data back into mediawiki code.

Merged initial (semi)raw-data input (partial of full table data):

"...
! scope="row" | Jotun
|<!--Rough....-->| ?
|<!--Smooth...-->| Constitution +6 Agility +3
|<!--Cabochon.-->| # Constitution +12 Agility +6 Farming +12
..."

Final process:

"=REGEX(REGEX(REGEX(REGEX(
F19,"(?i)([a-z]+( [a-z]+)?) ?\+([0-9?]+) ?(,?)","$1 +$3 <br> ","g")
," ?<br> ?([|\n])","$1","g")
,"\?","<b style=""color:red;"">\?","g")
,"\| ?\# ?\[\[","style=""background-color:#d8fbd8;""| [[","g")"