https://wiki.hattrick.org/api.php?action=feedcontributions&feedformat=atom&user=BBabouHattrick - User contributions [en]2026-09-30T21:22:19ZUser contributionsMediaWiki 1.43.9https://wiki.hattrick.org/index.php?title=User:BBabou&diff=111811User:BBabou2008-12-14T08:30:26Z<p>BBabou: </p>
<hr />
<div>'''BBabou''' aka '''BigBabou''' is a [[China|Chinese]] user that formerly played in [[Nederland]]. He is the creator of the Helper Application [[Tabletrick]].<br />
<br />
From 2002 till 2007, he managed his team ''Funkalicious'' in the [[Nederland|Dutch]] competition under the username ''BigBabou''.<br />
<br />
In December 2007, he moved to China, and requested to have ''Funkalicious'' locked.<br><br />
He started a new team, ''25 to Life'' in the [[China|Chinese]] competition, and changed his username to [[User:BBabou|BBabou]].<br />
<br />
[[Category: Dutch Users|Bbabou]]<br />
[[Category: Chinese Users|Bbabou]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=111810Tabletrick2008-12-14T08:28:35Z<p>BBabou: /* Files */</p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
Tabletrick is an excel-addin built by [[User: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. Pictures 1 and 2 show some examples of what Tabletrick can do.<br><br />
It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].<br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Features ==<br />
* Converts an Excel table to conference-code that creates the same table when pasted in the Hattrick forums<br />
* Detects cell alignment (left / center / right)<br />
* Detects cell font style (normal / bold / italic / bold+italic)<br />
* Detects vertical lines and distinguishes between solid and dotted or dashed lines<br />
* Supports Hattrick forum links<br />
<br />
== Installation Guide ==<br />
<br />
=== Files ===<br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.5.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br />
=== Installation ===<br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save both files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
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 />
<br />
=== Locating the Excel Add-In folder ===<br />
Unfortunately, the location of the Add-In folder is different for each Windows or Excel version. Some of the possible locations are:<br><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\<UserName>\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
[[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) <br />
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 />
<br />
=== Uninstallation ===<br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK<br />
<br />
== Usage Guide ==<br />
# Select the part of the Excel worksheet you want to convert (see Picture 5)<br />
# Press the TableTrick button (or a capital 'H' if you didn't download the button image)<br />
# Go to Hattrick and paste (ctrl+v) the code in your forum post<br />
# The result: see Picture 6.<br />
[[Image:Tabletrick_guide_5.jpg|frame|left|Picture 5: Select a table in excel]] [[Image:Tabletrick_guide_6.jpg|frame|Picture 6: Result after pasting the code in Hattrick]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=User:BBabou&diff=91763User:BBabou2008-03-29T08:06:59Z<p>BBabou: </p>
<hr />
<div>'''BBabou''' aka '''BigBabou''' is a [[Netherlands|Dutch]] user, and the creator of the Helper Application [[Tabletrick]].<br />
<br />
From 2002 till 2007, he managed his team ''Funkalicious'' in the [[Netherlands|Dutch]] Competiton under the username ''BigBabou''.<br />
<br />
In December 2007, he moved to China, and requested to have ''Funkalicious'' locked.<br><br />
He started a new team, ''25 to Life'' in the [[China|Chinese]] competition, and changed his username to [[User:BBabou|BBabou]].<br />
<br />
Member of [[Weetjewat]].<br />
<br />
[[Category: Dutch Users]]<br />
[[Category: Chinese Users]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=User:BBabou&diff=91762User:BBabou2008-03-29T06:19:20Z<p>BBabou: </p>
<hr />
<div>'''BBabou''' aka '''BigBabou''' is a [[Netherlands|Dutch]] user, and the creator of the Helper Application [[Tabletrick]].<br />
<br />
From 2002 till 2007, he managed his team ''Funkalicious'' in the [[Netherlands|Dutch]] Competiton under the username ''BigBabou''.<br />
<br />
In December 2007, he moved to China, and requested to have ''Funkalicious'' locked.<br />
He started a new team, ''25 to Life'' in the [[China|Chinese]] competition, and changed his username to [[User:BBabou|BBabou]].<br />
<br />
Member of [[Weetjewat]].<br />
<br />
[[Category: Dutch Users]]<br />
[[Category: Chinese Users]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=User:BBabou&diff=91758User:BBabou2008-03-29T04:22:26Z<p>BBabou: </p>
<hr />
<div>'''BBabou''' aka '''BigBabou''' is a [[Netherlands|Dutch]] user, and the creator of the Helper Application [[Tabletrick]].<br />
<br />
From 2002 till 2007, he managed his team ''Funkalicious'' in the [[Netherlands|Dutch]] Competiton under the username ''BigBabou''.<br />
<br />
In December 2007, he moved to China, and requested to have ''Funkalicious'' locked. He started a new team, ''25 to Life'' in the [[China|Chinese]] competition, and changed his username to [[User:BBabou|BBabou]].<br />
<br />
Member of [[Weetjewat]].<br />
<br />
[[Category: Dutch Users]]<br />
[[Category: Chinese Users]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91757Tabletrick2008-03-29T04:11:40Z<p>BBabou: /* Summary */</p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
Tabletrick is an excel-addin built by [[User: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. Pictures 1 and 2 show some examples of what Tabletrick can do.<br><br />
It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].<br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Features ==<br />
* Converts an Excel table to conference-code that creates the same table when pasted in the Hattrick forums<br />
* Detects cell alignment (left / center / right)<br />
* Detects cell font style (normal / bold / italic / bold+italic)<br />
* Detects vertical lines and distinguishes between solid and dotted or dashed lines<br />
* Supports Hattrick forum links<br />
<br />
== Installation Guide ==<br />
<br />
=== Files ===<br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br />
=== Installation ===<br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save both files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
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 />
<br />
=== Locating the Excel Add-In folder ===<br />
Unfortunately, the location of the Add-In folder is different for each Windows or Excel version. Some of the possible locations are:<br><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\<UserName>\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
[[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) <br />
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 />
<br />
=== Uninstallation ===<br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK<br />
<br />
== Usage Guide ==<br />
# Select the part of the Excel worksheet you want to convert (see Picture 5)<br />
# Press the TableTrick button (or a capital 'H' if you didn't download the button image)<br />
# Go to Hattrick and paste (ctrl+v) the code in your forum post<br />
# The result: see Picture 6.<br />
[[Image:Tabletrick_guide_5.jpg|frame|left|Picture 5: Select a table in excel]] [[Image:Tabletrick_guide_6.jpg|frame|Picture 6: Result after pasting the code in Hattrick]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=User:BBabou&diff=91711User:BBabou2008-03-28T16:05:00Z<p>BBabou: </p>
<hr />
<div>'''BigBabou''' is a Dutch Hattrick user, and the creator of the Helper Application [[Tabletrick]].<br />
<br />
From 2002 till 2007, he managed his team ''Funkalicious'' in the [[Netherlands|Dutch]] Competiton.<br />
<br />
In December 2007, he moved to China, and requested to have ''Funkalicious'' locked. He started a new team, ''25 to Life'' in the [[China|Chinese]] competition, and changed his username to [[User:BBabou|BBabou]].<br />
<br />
Member of [[Weetjewat]].<br />
<br />
[[Category: Dutch Users]]<br />
[[Category: Chinese Users]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=User:BBabou&diff=91710User:BBabou2008-03-28T16:03:39Z<p>BBabou: </p>
<hr />
<div>'''BigBabou''' is a Dutch Hattrick user, and the creator of the Helper Application [[Tabletrick]].<br />
<br />
From 2002 till 2007, he managed his team ''Funkalicious'' in the [[Netherlands|Dutch]] Competiton.<br />
<br />
In December 2007, he moved to China, and requested to have ''Funkalicious'' locked. He started a new team, ''25 to Life'' in the [[China|Chinese]] competition, and changed his username to [[User:BBabou|BBabou]].<br />
<br />
Member of [[Weetjewat]].<br />
<br />
[[Category: Dutch Users|Category: Chinese Users]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=User:BBabou&diff=91709User:BBabou2008-03-28T16:01:28Z<p>BBabou: </p>
<hr />
<div>'''BigBabou''' is a Dutch Hattrick user, and the creator of the Helper Application [[Tabletrick]].<br />
<br />
From 2002 till 2007, he managed his team ''Funkalicious'' in the [[Netherlands|Dutch]] Competiton.<br />
<br />
In December 2007, he moved to China, and requested to have ''Funkalicious'' locked. He started a new team, ''25 to Life'' in the [[China|Chinese]] competition, and changed his username to [[User:BBabou]].<br />
<br />
Member of [[Weetjewat]].<br />
<br />
[[Category: Dutch Users|Bigbabou]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=User:BBabou&diff=91701User:BBabou2008-03-28T15:53:16Z<p>BBabou: </p>
<hr />
<div>'''BigBabou''' is a Dutch Hattrick user, and the creator of the Helper Application [[Tabletrick]].<br />
<br />
From 2002 till 2007, he managed his team ''Funkalicious'' in the [[Dutch]] Competiton.<br />
<br />
In December 2007, he moved to China, and requested to have ''Funkalicious'' locked. He started a new team, ''25 to Life'' in the [[Chinese]] competition, and changed his username [[BBabou]].<br />
<br />
Member of [[Weetjewat]].<br />
<br />
[[Category: Dutch Users|Bigbabou]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91688Tabletrick2008-03-28T08:08:07Z<p>BBabou: /* Summary */</p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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. Pictures 1 and 2 show some examples of what Tabletrick can do.<br><br />
It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].<br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Features ==<br />
* Converts an Excel table to conference-code that creates the same table when pasted in the Hattrick forums<br />
* Detects cell alignment (left / center / right)<br />
* Detects cell font style (normal / bold / italic / bold+italic)<br />
* Detects vertical lines and distinguishes between solid and dotted or dashed lines<br />
* Supports Hattrick forum links<br />
<br />
== Installation Guide ==<br />
<br />
=== Files ===<br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br />
=== Installation ===<br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save both files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
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 />
<br />
=== Locating the Excel Add-In folder ===<br />
Unfortunately, the location of the Add-In folder is different for each Windows or Excel version. Some of the possible locations are:<br><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\<UserName>\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
[[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) <br />
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 />
<br />
=== Uninstallation ===<br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK<br />
<br />
== Usage Guide ==<br />
# Select the part of the Excel worksheet you want to convert (see Picture 5)<br />
# Press the TableTrick button (or a capital 'H' if you didn't download the button image)<br />
# Go to Hattrick and paste (ctrl+v) the code in your forum post<br />
# The result: see Picture 6.<br />
[[Image:Tabletrick_guide_5.jpg|frame|left|Picture 5: Select a table in excel]] [[Image:Tabletrick_guide_6.jpg|frame|Picture 6: Result after pasting the code in Hattrick]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91687Tabletrick2008-03-28T08:07:00Z<p>BBabou: /* Installation Guide */</p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Features ==<br />
* Converts an Excel table to conference-code that creates the same table when pasted in the Hattrick forums<br />
* Detects cell alignment (left / center / right)<br />
* Detects cell font style (normal / bold / italic / bold+italic)<br />
* Detects vertical lines and distinguishes between solid and dotted or dashed lines<br />
* Supports Hattrick forum links<br />
<br />
== Installation Guide ==<br />
<br />
=== Files ===<br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br />
=== Installation ===<br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save both files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
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 />
<br />
=== Locating the Excel Add-In folder ===<br />
Unfortunately, the location of the Add-In folder is different for each Windows or Excel version. Some of the possible locations are:<br><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\<UserName>\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
[[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) <br />
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 />
<br />
=== Uninstallation ===<br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK<br />
<br />
== Usage Guide ==<br />
# Select the part of the Excel worksheet you want to convert (see Picture 5)<br />
# Press the TableTrick button (or a capital 'H' if you didn't download the button image)<br />
# Go to Hattrick and paste (ctrl+v) the code in your forum post<br />
# The result: see Picture 6.<br />
[[Image:Tabletrick_guide_5.jpg|frame|left|Picture 5: Select a table in excel]] [[Image:Tabletrick_guide_6.jpg|frame|Picture 6: Result after pasting the code in Hattrick]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91686Tabletrick2008-03-28T04:18:01Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Features ==<br />
* Converts an Excel table to conference-code that creates the same table when pasted in the Hattrick forums<br />
* Detects cell alignment (left / center / right)<br />
* Detects cell font style (normal / bold / italic / bold+italic)<br />
* Detects vertical lines and distinguishes between solid and dotted or dashed lines<br />
* Supports Hattrick forum links<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save both files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\<UserName>\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
[[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) <br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK<br />
<br />
== Usage Guide ==<br />
# Select the part of the Excel worksheet you want to convert (see Picture 5)<br />
# Press the TableTrick button (or a capital 'H' if you didn't download the button image)<br />
# Go to Hattrick and paste (ctrl+v) the code in your forum post<br />
# The result: see Picture 6.<br />
[[Image:Tabletrick_guide_5.jpg|frame|left|Picture 5: Select a table in excel]] [[Image:Tabletrick_guide_6.jpg|frame|Picture 6: Result after pasting the code in Hattrick]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=File:Tabletrick_guide_6.jpg&diff=91685File:Tabletrick guide 6.jpg2008-03-28T04:14:36Z<p>BBabou: </p>
<hr />
<div></div>BBabouhttps://wiki.hattrick.org/index.php?title=File:Tabletrick_guide_5.jpg&diff=91684File:Tabletrick guide 5.jpg2008-03-28T04:13:57Z<p>BBabou: </p>
<hr />
<div></div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91683Tabletrick2008-03-28T04:11:47Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Features ==<br />
* Converts an Excel table to conference-code that creates the same table when pasted in the Hattrick forums<br />
* Detects cell alignment (left / center / right)<br />
* Detects cell font style (normal / bold / italic / bold+italic)<br />
* Detects vertical lines and distinguishes between solid and dotted or dashed lines<br />
* Supports Hattrick forum links<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save the files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\<UserName>\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
<br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) [[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK<br />
<br />
== Usage Guide ==<br />
[[Image:Tabletrick_guide_5.jpg|frame|Picture 5: Select a table in excel]]<br />
# Select the part of the Excel worksheet you want to convert (see Picture 5)<br />
# Press the TableTrick button ([[Image:Tabletrick_button.jpg]] or H)<br />
# Go to Hattrick and paste (ctrl+v) the code in your forum post<br />
# The result: see Picture 6.<br />
[[Image:Tabletrick_guide_6.jpg|frame|Picture 6: Result after pasting the code in Hattrick]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91682Tabletrick2008-03-28T04:09:41Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Features ==<br />
* Converts an Excel table to conference-code that creates the same table when pasted in the Hattrick forums<br />
* Detects cell alignment (left / center / right)<br />
* Detects cell font style (normal / bold / italic / bold+italic)<br />
* Detects vertical lines and distinguishes between solid and dotted or dashed lines<br />
* Supports Hattrick forum links<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save the files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\<UserName>\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
<br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) [[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK<br />
<br />
== Usage Guide ==<br />
[[Image:Tabletrick_guide_5.jpg|frame|Picture 5: Select a table in excel]]<br />
# Select the part of the Excel worksheet you want to convert (see Picture 5)<br />
# Press the TableTrick button ( or H)<br />
# Go to Hattrick and paste (ctrl+v) the code in your forum post<br />
# The result: see Picture 6.<br />
[[Image:Tabletrick_guide_6.jpg|frame|Picture 6: Result after pasting the code in Hattrick]]</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91681Tabletrick2008-03-28T03:53:18Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save the files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
* Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\<UserName>\Application Data\Microsoft\AddIns<br />
* Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
* Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) [[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91680Tabletrick2008-03-28T03:50:38Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save the files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
# Press OK<br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
# Open a new workbook in Excel.<br />
# Choose ''Save As...'' in the ''File'' menu<br />
# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
# The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
# Note the location (see Picture 4) [[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Uncheck the box next to ''TableTrick v1.x''<br />
# Press OK</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91679Tabletrick2008-03-28T03:48:11Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
Follow these steps:<br><br />
# Download the files (the Button Image is optional)<br />
# Save the files in the Add-In folder of Excel (see below how to locate it)<br />
# Start Excel<br />
# Choose ''Add-Ins...'' in the ''Tools'' menu<br />
# Check the box next to ''TableTrick v1.x'' (see Picture 3) [[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
# Press OK<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
<ol><br />
<li> Open a new workbook in Excel.<br />
<li> Choose ''Save As...'' in the ''File'' menu<br />
<li> At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
<li> The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
<li> Note the location (see Picture 4) [[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
</ol><br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
<ol><br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Uncheck the box next to ''TableTrick v1.x''<br />
<li> Press OK<br />
</ol></div>BBabouhttps://wiki.hattrick.org/index.php?title=File:Tabletrick_guide_4.jpg&diff=91678File:Tabletrick guide 4.jpg2008-03-28T03:44:32Z<p>BBabou: </p>
<hr />
<div></div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91677Tabletrick2008-03-28T03:43:43Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
Follow these steps:<br><br />
<ol><br />
<li> Download the files (the Button Image is optional)<br />
<li> Save the files in the Add-In folder of Excel (see below how to locate it)<br />
<li> Start Excel<br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
<li> Press OK<br />
</ol><br />
[[Image:Tabletrick_guide_3.jpg|frame|Picture 3: Add-in menu]]<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
<ol><br />
<li> Open a new workbook in Excel.<br />
<li> Choose ''Save As...'' in the ''File'' menu<br />
<li> At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
<li> The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
<li> Note the location (see Picture 4)<br />
</ol><br />
[[Image:Tabletrick_guide_4.jpg|frame|Picture 4: Add-in folder]]<br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
<ol><br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Uncheck the box next to ''TableTrick v1.x''<br />
<li> Press OK<br />
</ol></div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91676Tabletrick2008-03-28T03:38:20Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
Follow these steps:<br><br />
<ol><br />
<li> Download the files (the Button Image is optional)<br />
<li> Save the files in the Add-In folder of Excel (see below how to locate it)<br />
<li> Start Excel<br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
<li> Press OK<br />
</ol><br />
[[Image:Tabletrick_guide_3.jpg|thumb|right|Picture 3: Add-in menu]]<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
<ol><br />
<li> Open a new workbook in Excel.<br />
<li> Choose ''Save As...'' in the ''File'' menu<br />
<li> At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
<li> The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
<li> Note the location (see Picture 4)<br />
</ol><br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
<ol><br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Uncheck the box next to ''TableTrick v1.x''<br />
<li> Press OK<br />
</ol></div>BBabouhttps://wiki.hattrick.org/index.php?title=File:Tabletrick_guide_3.jpg&diff=91675File:Tabletrick guide 3.jpg2008-03-28T03:36:37Z<p>BBabou: Picture 3: Add-in menu</p>
<hr />
<div>Picture 3: Add-in menu</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91674Tabletrick2008-03-28T03:33:30Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
Follow these steps:<br><br />
<ol><br />
<li> Download the files (the Button Image is optional)<br />
<li> Save the files in the Add-In folder of Excel (see below how to locate it)<br />
<li> Start Excel<br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
<li> Press OK<br />
</ol><br />
[[Image:Tabletrick_guide_3.jpg]]<br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
<ol><br />
<li> Open a new workbook in Excel.<br />
<li> Choose ''Save As...'' in the ''File'' menu<br />
<li> At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
<li> The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
<li> Note the location (see Picture 4)<br />
</ol><br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
<ol><br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Uncheck the box next to ''TableTrick v1.x''<br />
<li> Press OK<br />
</ol></div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91673Tabletrick2008-03-28T03:28:48Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]][[Image:Tabletrick example2.JPG|thumb|380px|Picture 1: A nice league table]]<br />
== Summary ==<br />
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><br />
Pictures 1 and 2 show some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
<ol><br />
<li> Download the files (the Button Image is optional)<br />
<li> Save the files in the Add-In folder of Excel (see below how to locate it)<br />
<li> Start Excel<br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Check the box next to ''TableTrick v1.x'' (see Picture 3)<br />
<li> Press OK<br />
</ol><br />
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 />
<br><br />
'''Locating the Excel Add-In folder'''<br><br />
<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><br />
<ul><br />
<li> Excel XP(2002) on Windows XP:<br><br />
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns<br />
<li> Excel 2000 on Windows 98:<br><br />
C:\Windows\Application Data\Microsoft\AddIns<br />
<li> Excel 97 on Windows 98:<br><br />
C:\Program Files\Microsoft Office\Office\Library<br />
</ul><br />
If this does not work for you, then there is a little trick to determine the folder location:<br><br />
<br><br />
<ol><br />
<li> Open a new workbook in Excel.<br />
<li> Choose ''Save As...'' in the ''File'' menu<br />
<li> At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''<br />
<li> The ''Save in:'' folder is now automatically changed to the Add-In folder<br />
<li> Note the location (see Picture 4)<br />
</ol><br />
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 />
<br><br />
'''Uninstallation'''<br><br />
<br><br />
<ol><br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Uncheck the box next to ''TableTrick v1.x''<br />
<li> Press OK<br />
</ol></div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91671Tabletrick2008-03-28T03:20:36Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]]== Summary ==<br />
[[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><br />
Here are some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example1.JPG|thumb|380px|Picture 2: HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
<ol><br />
<li> Download the files (the Button Image is optional)<br />
<li> Save the files in the Add-In folder of Excel (see below how to locate it)<br />
<li> Start Excel<br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Check the box next to ''TableTrick v1.x'' (see Picture 1)<br />
<li> Press OK<br />
</ol><br />
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.</div>BBabouhttps://wiki.hattrick.org/index.php?title=Tabletrick&diff=91670Tabletrick2008-03-28T03:17:48Z<p>BBabou: </p>
<hr />
<div>[[Category:Helper Applications]]<br />
<br />
== Summary ==<br />
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><br />
Here are some examples of what Tabletrick can do. <br />
[[Image:Tabletrick example2.JPG|thumb|380px|left|A nice league table]][[Image:Tabletrick example1.JPG|thumb|380px|HT-links are also possible]]<br />
<br />
== Installation Guide ==<br />
'''Files'''<br><br />
<br><br />
Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br><br />
Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br><br />
<br><br />
'''Installation'''<br><br />
<br><br />
<ol><br />
<li> Download the files (the Button Image is optional)<br />
<li> Save the files in the Add-In folder of Excel (see below how to locate it)<br />
<li> Start Excel<br />
<li> Choose ''Add-Ins...'' in the ''Tools'' menu<br />
<li> Check the box next to ''TableTrick v1.x'' (see Picture 1)<br />
<li> Press OK<br />
</ol><br />
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.</div>BBabou