Tabletrick - Revision history

DogNatural: Added "External links" and a link to HatTables

2010-01-26T00:25:12Z

Added "External links" and a link to HatTables

← Older revision		Revision as of 00:25, 26 January 2010
Line 65:		Line 65:
	==See Also==		==See Also==
	* [[OpenTableTrick]] - TableTrick for OpenOffice.org		* [[OpenTableTrick]] - TableTrick for OpenOffice.org

			==External links==
			* [http://hattick.wetpaint.com/page/HatTables+%28English%29 HatTables] - An Excel add-on similar to the original TableTrick but which makes use of [table] tags

EchoMan: Layout formatting

2009-04-09T07:52:29Z

Layout formatting

← Older revision		Revision as of 07:52, 9 April 2009
Line 61:		Line 61:
	# The result: see Picture 6.		# The result: see Picture 6.
	[[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]]		[[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]]
			<br clear="all" />

	==See Also==		==See Also==
	* [[OpenTableTrick]] - TableTrick for OpenOffice.org		* [[OpenTableTrick]] - TableTrick for OpenOffice.org

EchoMan: Added See Also section

2009-04-09T07:44:05Z

Added See Also section

← Older revision		Revision as of 07:44, 9 April 2009
Line 61:		Line 61:
	# The result: see Picture 6.		# The result: see Picture 6.
	[[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]]		[[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]]

			==See Also==
			* [[OpenTableTrick]] - TableTrick for OpenOffice.org

EchoMan: /* Summary */ Found a mirror for 1.6 while the site is not working

2009-04-09T07:42:32Z

Summary: Found a mirror for 1.6 while the site is not working

← Older revision		Revision as of 07:42, 9 April 2009
Line 2:		Line 2:
	== Summary ==		== Summary ==
	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>		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>
	<s>It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].</s>		<!--<s>It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].</s>-->
			It can be found [http://www.mediafire.com/?ytdqjlzylzm here].
	[[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]]

Flattermann: /* Summary */ (URL is not working anymore)

2009-04-07T10:24:41Z

Summary: (URL is not working anymore)

← Older revision		Revision as of 10:24, 7 April 2009
Line 2:		Line 2:
	== Summary ==		== Summary ==
	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>		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>
	It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].		<s>It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].</s>
	[[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]]

BBabou: /* Files */

2008-12-14T08:28:35Z

Files

← Older revision		Revision as of 08:28, 14 December 2008
Line 15:		Line 15:

	=== Files ===		=== Files ===
	Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br>		Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.5.xla here]<br>
	Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br>		Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br>

BBabou: /* Summary */

2008-03-29T04:11:40Z

Summary

← Older revision		Revision as of 04:11, 29 March 2008
Line 1:		Line 1:
	[[Category:Helper Applications]][[Image:Tabletrick example2.JPG\|thumb\|380px\|Picture 1: A nice league table]]		[[Category:Helper Applications]][[Image:Tabletrick example2.JPG\|thumb\|380px\|Picture 1: A nice league table]]
	== Summary ==		== 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. Pictures 1 and 2 show some examples of what Tabletrick can do.<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>
	It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].		It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].
	[[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]]

BBabou: /* Summary */

2008-03-28T08:08:07Z

Summary

← Older revision		Revision as of 08:08, 28 March 2008
Line 1:		Line 1:
	[[Category:Helper Applications]][[Image:Tabletrick example2.JPG\|thumb\|380px\|Picture 1: A nice league table]]		[[Category:Helper Applications]][[Image:Tabletrick example2.JPG\|thumb\|380px\|Picture 1: A nice league table]]
	== Summary ==		== 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>~~		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>
	~~Pictures 1 and 2 show some examples of what Tabletrick can do~~.		It can be found [http://staff.science.uva.nl/~jnunnink/tabletrick/ here].
	[[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]]

BBabou: /* Installation Guide */

2008-03-28T08:07:00Z

Installation Guide

← Older revision		Revision as of 08:07, 28 March 2008
Line 13:		Line 13:

	== Installation Guide ==		== Installation Guide ==
	~~'''~~Files~~'''<br>~~
	~~<br>~~		=== Files ===
	Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br>		Excel Add-In: [http://staff.science.uva.nl/~jnunnink/tabletrick/TableTrick%20v1.4.xla here]<br>
	Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br>		Button Image: [http://staff.science.uva.nl/~jnunnink/tabletrick/HTlogo.bmp here]<br>
	~~<br>~~
	~~'''~~Installation~~'''<br>~~		=== Installation ===
	~~<br>~~
	[[Image:Tabletrick_guide_3.jpg\|frame\|Picture 3: Add-in menu]]		[[Image:Tabletrick_guide_3.jpg\|frame\|Picture 3: Add-in menu]]
	Follow these steps:<br>		Follow these steps:<br>
Line 29:		Line 28:
	# Press OK		# 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.<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>~~
	~~'''~~Locating the Excel Add-In folder~~'''<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>		Unfortunately, the location of the Add-In folder is different for each Windows or Excel version. Some of the possible locations are:<br>
	<ul>		<ul>
Line 49:		Line 47:
	# Note the location (see Picture 4)		# 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.<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>~~
	~~'''~~Uninstallation~~'''<br>~~		=== Uninstallation ===
	~~<br>~~
	Follow these steps:<br>		Follow these steps:<br>
	# Choose ''Add-Ins...'' in the ''Tools'' menu		# Choose ''Add-Ins...'' in the ''Tools'' menu

BBabou at 04:18, 28 March 2008

2008-03-28T04:18:01Z

← Older revision		Revision as of 04:18, 28 March 2008
Line 23:		Line 23:
	Follow these steps:<br>		Follow these steps:<br>
	# Download the files (the Button Image is optional)		# Download the files (the Button Image is optional)
	# Save ~~the~~ files in the Add-In folder of Excel (see below how to locate it)		# Save both files in the Add-In folder of Excel (see below how to locate it)
	# Start Excel		# Start Excel
	# Choose ''Add-Ins...'' in the ''Tools'' menu		# Choose ''Add-Ins...'' in the ''Tools'' menu
Line 41:		Line 41:
	C:\Program Files\Microsoft Office\Office\Library		C:\Program Files\Microsoft Office\Office\Library
	</ul>		</ul>
			[[Image:Tabletrick_guide_4.jpg\|frame\|Picture 4: Add-in folder]]
	If this does not work for you, then there is a little trick to determine the folder location:<br>		If this does not work for you, then there is a little trick to determine the folder location:<br>
	# Open a new workbook in Excel.		# Open a new workbook in Excel.
Line 47:		Line 47:
	# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''		# At ''Save as type:'' select ''Microsoft Excel Add-In (*.xla)''
	# The ''Save in:'' folder is now automatically changed to the Add-In folder		# The ''Save in:'' folder is now automatically changed to the Add-In folder
	# Note the location (see Picture 4) ~~[[Image:Tabletrick_guide_4.jpg\|frame\|Picture 4: 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.<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>
Line 58:		Line 58:

	== Usage Guide ==		== Usage Guide ==
	~~[[Image:Tabletrick_guide_5.jpg\|frame\|Picture 5: Select a table in excel]]~~
	# Select the part of the Excel worksheet you want to convert (see Picture 5)		# Select the part of the Excel worksheet you want to convert (see Picture 5)
	# Press the TableTrick button (~~[[Image:Tabletrick_button.jpg]]~~ or H)		# Press the TableTrick button (or a capital 'H' if you didn't download the button image)
	# Go to Hattrick and paste (ctrl+v) the code in your forum post		# Go to Hattrick and paste (ctrl+v) the code in your forum post
	# The result: see Picture 6.		# The result: see Picture 6.
	[[Image:Tabletrick_guide_6.jpg\|frame\|Picture 6: Result after pasting the code in Hattrick]]		[[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]]