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

aus Wikipedia, der freien Enzyklopädie
Zur Navigation springen Zur Suche springen

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

[Quelltext bearbeiten]

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

Ein Kostenstellenbericht

[Quelltext bearbeiten]
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%

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
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

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

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