Tabletrick: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
[[Category:Helper Applications]] | [[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]] | ||
[[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]Tabletrick is an excel-addin built by [[Users:BigBabou|BigBabou]], based on an excel implementation by [[ukelele]]. The tool was tested in the federation '[[Weetjewat]]' and was built with the help of [[Weetjewat]]. Tabletrick converts selected cells in an excel-worksheet to [[conference-code]] that can be pasted into your post on the Hattrick [[conferences]]. It is used to create nicely aligned tables with every kind of data you like.<br>It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].<br> | == Summary == | ||
Tabletrick is an excel-addin built by [[Users:BigBabou|BigBabou]], based on an excel implementation by [[ukelele]]. The tool was tested in the federation '[[Weetjewat]]' and was built with the help of [[Weetjewat]]. Tabletrick converts selected cells in an excel-worksheet to [[conference-code]] that can be pasted into your post on the Hattrick [[conferences]]. It is used to create nicely aligned tables with every kind of data you like.<br>It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].<br> | |||
Pictures 1 and 2 show some examples of what Tabletrick can do. | |||
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]] | [[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]] | ||
| Line 17: | Line 18: | ||
<li> Start Excel | <li> Start Excel | ||
<li> Choose ''Add-Ins...'' in the ''Tools'' menu | <li> Choose ''Add-Ins...'' in the ''Tools'' menu | ||
<li> Check the box next to ''TableTrick v1.x'' (see Picture | <li> Check the box next to ''TableTrick v1.x'' (see Picture 3) | ||
<li> Press OK | <li> Press OK | ||
</ol> | </ol> | ||
The add-in is now installed and a new button is placed in the standard toolbar, near the cut/paste group. Also, an ''About TableTrick...'' item is placed in the ''Tools'' menu. | The add-in is now installed and a new button is placed in the standard toolbar, near the cut/paste group. Also, an ''About TableTrick...'' item is placed in the ''Tools'' menu.<br> | ||
<br> | |||
'''Locating the Excel Add-In folder'''<br> | |||
<br> | |||
Unfortunately, the location of the Add-In folder is different for each Windows or Excel version. Some of the possible locations are:<br> | |||
<ul> | |||
<li> Excel XP(2002) on Windows XP:<br> | |||
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns | |||
<li> Excel 2000 on Windows 98:<br> | |||
C:\Windows\Application Data\Microsoft\AddIns | |||
<li> Excel 97 on Windows 98:<br> | |||
C:\Program Files\Microsoft Office\Office\Library | |||
</ul> | |||
If this does not work for you, then there is a little trick to determine the folder location:<br> | |||
<br> | |||
<ol> | |||
<li> Open a new workbook in Excel. | |||
<li> Choose ''Save As...'' in the ''File'' menu | |||
<li> At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)'' | |||
<li> The ''Save in:'' folder is now automatically changed to the Add-In folder | |||
<li> Note the location (see Picture 4) | |||
</ol> | |||
Note: Apparently the ''Application Data'' folder is hidden on most systems. In that case, turn on ''Show hidden folders'' under ''Folder Options...'' in the ''Tools'' menu of Windows Explorer to find the (hidden) Add-Ins folder.<br> | |||
<br> | |||
'''Uninstallation'''<br> | |||
<br> | |||
<ol> | |||
<li> Choose ''Add-Ins...'' in the ''Tools'' menu | |||
<li> Uncheck the box next to ''TableTrick v1.x'' | |||
<li> Press OK | |||
</ol> | |||
Revision as of 03:28, 28 March 2008
Summary
Tabletrick is an excel-addin built by BigBabou, based on an excel implementation by ukelele. The tool was tested in the federation 'Weetjewat' and was built with the help of Weetjewat. Tabletrick converts selected cells in an excel-worksheet to conference-code that can be pasted into your post on the Hattrick conferences. It is used to create nicely aligned tables with every kind of data you like.
It can be found here.
Pictures 1 and 2 show some examples of what Tabletrick can do.
Installation Guide
Files
Excel Add-In: here
Button Image: here
Installation
- Download the files (the Button Image is optional)
- Save the files in the Add-In folder of Excel (see below how to locate it)
- Start Excel
- Choose Add-Ins... in the Tools menu
- Check the box next to TableTrick v1.x (see Picture 3)
- Press OK
The add-in is now installed and a new button is placed in the standard toolbar, near the cut/paste group. Also, an About TableTrick... item is placed in the Tools menu.
Locating the Excel Add-In folder
Unfortunately, the location of the Add-In folder is different for each Windows or Excel version. Some of the possible locations are:
- Excel XP(2002) on Windows XP:
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns - Excel 2000 on Windows 98:
C:\Windows\Application Data\Microsoft\AddIns - Excel 97 on Windows 98:
C:\Program Files\Microsoft Office\Office\Library
If this does not work for you, then there is a little trick to determine the folder location:
- Open a new workbook in Excel.
- Choose Save As... in the File menu
- At Save as type: select Microsoft Excel Add-In (*.xla)
- The Save in: folder is now automatically changed to the Add-In folder
- Note the location (see Picture 4)
Note: Apparently the Application Data folder is hidden on most systems. In that case, turn on Show hidden folders under Folder Options... in the Tools menu of Windows Explorer to find the (hidden) Add-Ins folder.
Uninstallation
- Choose Add-Ins... in the Tools menu
- Uncheck the box next to TableTrick v1.x
- Press OK
