Wikiup:Technik/Text/Basic/EXCEL-Tabellenumwandlung/Darstellungsmöglichkeiten

Auf dieser Seite zeigt beispielhaft einige Darstellungen die in EXCEL formatiert, mit dem Makro format_as_wikitable konvertiert und dann ohne weitere Änderungen nach Wiki übernommen worden sind.

Intro for English guests

This gallery shows some samples that have been rendered for Wiki with the macro VBA-Macro for EXCEL tableconversion.

Ein Kostenstellenbericht

Kostenstelle	12000	IT-Services
Kostenstellebereich
Periode von	01.01.2006
Periode bis	30.09.2006
		Plan	Ist	Delta	Delta%
220000	Lohnkosten	528'000.00	415'104.71	112'895.29	21.38%
220020	Unfallversicherung	6'336.00	5'100.52	1'235.48	19.50%
220040	Altersvorsorge I	42'240.00	39'101.86	3'138.14	7.43%
220060	Pensionskasse	47'520.00	34'718.49	12'801.51	26.94%
220080	Weiterbildung	50'234.00	38'415.85	11'818.15	23.53%
220100	Reisekosten	12'000.00	10'265.83	1'734.17	14.45%
* Personalkosten		686'330.00	542'707.26	143'622.74	20.93%
230000	Büromaterial	7'500.00	6'512.05	987.95	13.17%
230010	Porto	20'000.00	19'396.29	603.71	3.02%
230020	Abonnemente	8'000.00	5'700.74	2'299.26	28.74%
230030	SW-Sonderlizenzen	32'000.00	26'860.66	5'139.34	16.06%
230040	Telefongespräche	42'000.00	36'473.02	5'526.98	13.16%
* Sachkosten		109'500.00	94'942.76	14'557.24	13.29%
** Primärkosten		795'830.00	637'650.02	158'179.98	19.88%
500010	Overhead Konzern	89'222.90	68'790.04	20'432.86	22.90%
500020	Raumkosten	56'000.00	42'806.08	13'193.92	23.56%
500030	Mobiliar	32'000.00	24'959.92	7'040.08	22.00%
500040	Standardarbeitsplatz (PC)	23'000.00	16'537.13	6'462.87	28.10%
500050	Telefonzentrale	25'000.00	20'455.82	4'544.18	18.18%
**Sekundärverrechnungen		1'021'052.90	811'199.01	209'853.89	20.55%
Total		1'816'882.90	1'448'849.03	368'033.87	20.26%

Farbtabelle

Die Nummer entspricht dem EXCEL VBA-Wert des Colorindex.

0		1		2		3		4		5		6
7		8		9		10		11		12		13
14		15		16		17		18		19		20
21		22		23		24		25		26		27
28		29		30		31		32		33		34
35		36		37		38		39		40		41
42		43		44		45		46		47		48
49		50		51		52		53		54		55

Kalender

	1-Okt-06	2-Okt-06	3-Okt-06	4-Okt-06	5-Okt-06	6-Okt-06	7-Okt-06
	Mo	Di	Mi	Do	Fr	Sa	So
8:00							Bergtour Wallis
9:00
10:00		Sitzung Rheinwald
11:00
12:00			Mittagessen mit Rolf
13:00
14:00
15:00
16:00
17:00
18:00					Training

Checklist

This sample table is originally bigger. The author may add a link to the original here. --ollio 09:44, 5. Nov. 2006 (CET)

Home Maintenance Schedule
This is a starting list; you may want to add or remove items by inserting and deleting rows on this worksheet.
Quarterly		Date last completed
Plumbing
Faucets and shower heads	Check interior and exterior faucets for leaks. Clean aerators. Replace washers if necessary.
Drains	Clean with baking soda. Pour water down unused drains.
Pipes	Inspect visible pipes for leaks.
Kitchen and bathroom cabinets	Check under and around for leaks.
Toilets	Check for stability and leaks.
Water heater	Check area around water heater for leaks. If you have hard water, drain 1-2 gallons water.
Interior
Wood cabinets and trim	Apply a wood protectant.
Interior doors	Lubricate hinges.
Garage door	Lubricate hardware. Inspect mechanism for free travel.
...........	.............
Spring		Date last completed
Plumbing
Water heater	Flush out hot water to remove accumulated sediment.
Interior
Attic	Examine for evidence of any leaks. Check insulation and remove or add if necessary. Check for evidence of birds, squirrels, raccoons, etc. Check for proper ventilation.
Countertops	Inspect for separations at sinks and backsplash. Recaulk where required.
Tiled areas	Inspect for loose or missing grout or caulking. Regrout or recaulk if necessary.
Shower doors/tub enclosures	Inspect for proper fit. Adjust if necessary. Inspect caulking and recaulk if necessary.
...........	.......................
Electrical and appliances