Wikiup:Technik/Text/Basic/EXCEL-Tabellenumwandlung/Darstellungsmöglichkeiten
aus Wikipedia, der freien Enzyklopädie
< Wikiup:Technik | Text | Basic | EXCEL-Tabellenumwandlung
Dies ist die aktuelle Version dieser Seite, zuletzt bearbeitet am 16. August 2013 um 23:28 Uhr durch imported>PerfektesChaos(310926) (+kat).
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 |
|