Dreieckdiagramm mit Excel

In der Geologie, aber auch in anderen Bereichen werden Dreiecksdiagramme eingesetzt.
3 Achsen ergeben ein gleichseitiges Dreieck. Es werden Werte eingetragen, die in der Summe immer 100% ergeben.

Beispiel ist die Bodenzusammensetzung aus Sand, Schluff und Ton.

Excel bietet kein Dreiecksdiagramm in der Auswahl.

Es ist aber trotzdem möglich ein Dreiecksdiagramm mit Excel zu machen. Dazu werden die Werte mit Hilfe einer Funktion und sin(60°) bzw cos(60°) in einen x-y-Plot übertragen. Die Achsen werden als Striche in einem Diagramm ("Punkte mit geraden Strichen") eingezeichnet. Außerdem sind waagrechte und schräge Hilfslinien möglich.

Dankenswerterweise haben Graham & Midgley dies in Excel bereits entwickelt.
http://www.lboro.ac.uk/research/phys-geog/tri-plot/
Graham DJ and Midgley NG. 2000. Graphical representation of particle shape using triangular diagrams: an Excel spreadsheet method. Earth Surface Processes and Landforms 25(13): 1473-1477.

Beispiel von mir
http://www.ipb.uni-tuebingen.de/kurs/comp/1_excel2007/uebung/tri-plot_v1-4.xls

Excel Skript
http://www.ipb.uni-tuebingen.de/kurs/comp/1_excel2007/kurs01_04.html#dreieckdiagramm



Hinweis:
In dem Programm SigmaPlot sind Dreiecksdiagramme eingebaut.

Shared Folders in VirtualBox 4.0 WindowXP(Host) Ubuntu 10.10(Guest)

Host: Windows XP
Guest Ubuntu 10.10
VirtualBox 4.0

My message:
Do not use long name, name with spaces or strange names for the share name!
"vboxshare" produced a
"mount.vboxsf: mounting failed with the error: Invalid argument"
"share" works!

Manual

1. Install Guest Additions
   
   
2. Settings VirtualBox:
   create sharing folder on Windows XP (host)
   give a short an simple name "share"!!!
   
   
3. Go to Ubuntu (Guest)
   mkdir a folder for sharing
   - Do not use the Home-Folder -
   this is importent if you want to create a permanent mount
   root is used in rc.local and root has respect of home directories.
   use for example /mnt or /tmp
   I use
   /media/vboxgemein
   
   
4. Mount manually
   
   sudo mount.vboxsf share /media/vboxgemein/
   
   If this work you can create a permanent mount folder in rc.local
   
   
5. Mount permanemtly
   open rc.local with editor
   
   sudo nano /etc/rc.local
   
   before the "exit 0" command type
   
   mount.vboxsf share /media/vboxgemein/
   
   
   
   
   
   
   

Sharkoon USB3.0 Host Controller Card Problems

Sharkoon USB3.0 Host Controller Card

Board ASUS P5AB

Windows 2003 Server 64 bit

The external USB 3.0 Harddrive will not be recognized.

Solution:
Instead of the newer driver 2040 (Mini-CD from Sharkoon or Website)
use the NEC 1019 Driver (Link)

STOP: c0000218 {Registry File Failure} The registry cannot load the hive (file): \SystemRoot\System32\Config\SOFTWARE

To recover a Windows XP from

STOP: c0000218 {Registry File Failure}
The registry cannot load the hive (file):
\SystemRoot\System32\Config\SOFTWARE

- I boot with UBUNTU 10.04 (of course you can also use a different Linux or Windows PE system there you can read and write to your Windows file System.

- and copy the following files to a temp folder:

C:\System Volume Information\_restore{D86480E3-73EF-47BC-A0EB-A81BE6EE3ED8}\RP1\Snapshot

• _REGISTRY_USER_.DEFAULT
• _REGISTRY_MACHINE_SECURITY
• _REGISTRY_MACHINE_SOFTWARE
• _REGISTRY_MACHINE_SYSTEM
• _REGISTRY_MACHINE_SAM

- Rename this files to

• Default
• Security
• Software
• System
• SAM

- copy the 5 files to
c:\windows\system32\config\

- restart the PC

- restore to a previous RestorePoint.

The full manual you can find in
http://support.microsoft.com/kb/307545/
Of course Microsoft do not use Linux, instead they use MS Recovery Console.
You find Recovery Console then you boot with Windows XP install CD and Press "R".

Mac Office 2008/11 kopiere Excel Diagramme nach Illustrator

Hier liegt tatsächlich ein Bug vor.
(Mac Office 2008/11 und Illustrator CS3/4)
Mit Office 2004 ging das problemlos!
Ob das mit Mac Office 2005 und Illustrator CS5 geht ist unklar.

Im Moment gibt es nur einen seltsamen Workaround.


1. Leeres Illustratorblatt öffnen
2. Ein Objekt erstellen. Z.B. ein Quadrat.
3. Das Quadrat auf den Schreibtisch ziehen.

4. Excel öffnen
5. Diagramm kopieren
6. In Illustrator einfügen.

Wenn die Schrift seltsam ist.
In Excel die Schrift auf Standardschriftart stellen (Arial...)
Illustrator kommt mit der neuen MS Office Standardschriftart Calibri nicht klar.



Ein anderer Workaround ist das Diagramm als pdf-Datei abspeichern:

1. Excel öffnen
2. Diagramm wählen und rechte Maustaste
3. Als Bild speichern...
4. Format "PDF"
5. Speichern

6. Die PDF-Datei in Illustrator einfügen.



Zur weiteren Information
-------------------

http://forums.adobe.com/thread/317769


daraus:

Re: Copy Excel charts into Illustrator?
Well. I stumbled on an odd work-around for my copy/paste issue.
open an AICS3 file or create a new one.
put an object on the page, then drag that object to the desktop to create
a .pictclipping file.
After
I do this, I can copy and paste to AICS3 all I want and it goes in just
fine. It doesn't like the default new office fonts, gradient fills or
shadows, but it comes over as vector.
The gradient fills
and shadows paste in as raster objects. I just define a plain fill and
get rid of the shadow before I copy. Change the font to Arial or
something and it comes in fine also.
Maybe this will help anyone else having this issue.
I have to do this after every restart, but quitting AI doesn't seem to
affect the temporary fix.




Außerdem vielleicht geht auch das:


41. Mar 11, 2010 10:25 AM

(Jenn_Kruk) Re: Copy Excel charts
into Illustrator?


I HAVE THE ANSWER!!!!!!!!!!
When
you open an illustrator file -> new. Click advanced and change color
mode from CMYK to RGB. This does the job! You can now paste your excel
graphs in the file!
If your text is in odd characters make
sure that the original font in excel is not in Calibri (it's to new)
but arial for example.
Regards,
Pieter

--------------------------------------



Mit freundlichen Grüßen

Dieter

PowerPoint 2003 and 2007 Resolution picture export

How to change the resolution of a slide that you export as a picture in PowerPoint

link to Microsoft

Windows 7 deploying images with imagex.exe

An excellent german manual you find here
http://wiki.winboard.org/index.php/Windows_7_verteilen

This Blog is a short English version of this manual.


look also
http://technet.microsoft.com/de-de/library/cc749092%28WS.10%29.aspx
http://www.tecchannel.de/pc_mobile/windows/2023629/windows_7_automatisch_installieren/
With special information for AutoUnattend.xml.



Create a "Windows Preinstallation Environment (WinPE)

You need
- Windows Automated Installation Kit (WAIK) für Windows 7 and
- Windows 7 Install-DVD

Create the iso file

Copy imagex.exe from WAIK to your WinPE iso file

for more information to create a WinPE
http://wiki.winboard.org/index.php/Windows_7_verteilen

Create Image

- Install Windows 7 on a fresh system


- Create an account and type in the computername

- Go run

"c:\windows\system32\sysprep\sysprep.exe"

System Preparation Tool:
-System Cleanup Action:
--Enter System Audit Mode
-Generalize is not active
-Shutdown Options
--Reboot

OK
Reboot the System

Now the system is in the audit modus.

Install all drivers and software you need.
Be aware not to close the System Preparation Tool window

Then you finished with installing drivers and software change the System Preparation Tool

System Preparation Tool:
-System Cleanup Action:
--Enter System Out-of-Box Experience (OOBE)
-Generalize is active
-Shutdown Options
--Shutdown

The System is finished for the next step.

Start the computer with the WinPE

Insert your WinPE CD and boot from CD

A command Prompt will be shown

Change device there you find your imagex.exe
For example
d:

imagex /compress maximum /capture c: c:\MyWin7.wim "Windows 7" /verify

Explanation:
/compress maximum - record with less data volume
/compress fast - for fast recording
/capture c: device C:\ - is recording-
c:\MyWin7.wim "Windows 7" - Name of image file
/verify - proof the whole thing

Use the Image

start with WinPE-C
- If you already create a partition

 format c: /q

you format C: in quick modus


- If you had a empty harddisk use the diskpart tool

diskpart
select disk 0
clean
create partition primary size=20000
select partition 1
format fs=ntfs label="Win7" Quick
assign letter=c
active
exit

with help you get information


- Change to there you find imagex.exe
For example you will find it in
d:

imagex /apply F:\MyWin7.wim 1 c:

Explanations:
/apply - we will use the image
F:\MyWin7.wim - your image is in F:
1 - this is the first image
C: the image will paste on c:

The image will be copied to c:
End the program with "exit"


Hint:
I got a 
"bootmgr missing" then I started the cloned Windows 7.
 

I started with the Win7 install DVD.

1. "Repair your Computer"

2.Select 
Startup Repair



- Alternatively you can type in in the comand prompt:

bootrec /rebuildbcd



- If Bootrec cannot locate any missing Windows installations,
you must remove the BCD store, and then you must re-create it.
To do this, type the following commands in the order shown below:
(Remember to press ENTER after each command)

bcdedit /export C:\BCD_Backup

ren c:\boot\bcd bcd.old

bootrec /rebuildbcd

- Restart the computer.


Sometimes following helps, in case Linux was installed:bootrec /fixmbr
bootrec /fixboot
bootrec /RebuildBcd




- Maybe you need another
Startup Repair

by booting from Install-DVD



see for bootrec
http://cyberst0rm.blogspot.com/2007/04/how-to-fix-bootmgr-is-missing-in.html

How To Rebuild the BCD in Windows
http://pcsupport.about.com/od/fixtheproblem/ht/rebuild-bcd-store-windows.htm