Wikipedia:Technik/Text/Basic/EXCEL-Tabellenumwandlung/Darstellungsmöglichkeiten
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% |
Farbtabelle
[Quelltext bearbeiten]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
[Quelltext bearbeiten]| 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
[Quelltext bearbeiten]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 |
|