Chemistry Formatter Add-ins for Microsoft Word, Excel, and PowerPoint
Christopher King
Chemistry Department, Troy University, Troy, AL 36082 Best applications mac app store.
Initial download is 8.8MB but you may have to download other components like the Visual Studios of Office 3.0 runtime module. Chemistry add-in for Word is compatible with Word 2007 and Word 2010 Release Candidate 1 (though weâve used it on the currently available public beta Word. The Chemistry add-in for Word enables you to create chemical structures directly in Microsoft Word. Not only can you draw your own structures, but you can import structures from PubChem and Opsin as well as from your own files. With the latest version, inside the editor form, you can export or import your structures as CML or MDL Molfile format. Chemistry add-in for Word goes open-source. Microsoft is now offering an add-in that lets Word users view and work on chemical structures to the open-source community.
E-mail: [email protected]
Home page: http://christopherking.name
Here are free, open-source add-ins for Microsoft Word, Excel, and PowerPoint that format chemical equations and exponents. The source code is released under the GPL v. 3 license. To illustrate their use, imagine typing the following line in Word:
Cu2+(aq) + SO42-(aq) CuSO4*5H2O Heat for 2 hours at 120°C. ÎH = 1E4 J/mol
(I typed -->, which Word automatically converted to ). Leave the cursor in this paragraph (or select just the text to format). Click the button, which runs the add-in. The line is converted to this:
Cu2+(aq) + SO42-(aq) CuSO4·5H2O Heat for 2 hours at 120°C. ÎH = 1 à 104 J/mol How do you download netflix on mac.
Superscripts and subscripts were added; the arrow was replaced with a prettier arrow; and the asterisk was converted to a centered dot to indicate waters of hydration (or radicals). A plus (or minus) sign with space before it is not superscripted. Numbers in the text after the equation were unchanged, except that 1E4 was converted to 1 Ã 104.
In Excel, you could type the following into two cells:
*CH3 + *OH --> CH3OH
2H2(g) + O2(g) --> 2H2O(g) yield: 3.2E8 kg
Select both cells, click the button, and the lines are converted to these:
·CH3 + ·OH CH3OH
2H2(g) 2H2O(g) yield: 3.2 Ã 108 kg
(The centered dots are a little small in Arial, which is Excelâs default font on the PC.)
Here are some other examples. Square brackets may be present.
Radicals can be entered.
A plus or minus sign before a letter is not treated as a charge.
If more than one digit precedes a charge, the last digit goes with the charge.
Chemistry Add In For Word Mac Download Version
A single digit preceding a charge goes with the charge, except for O3.
The program cannot read minds, so check the results. In the last example, CH3- was probably meant to be CH3-, rather than CH3-.
These add-ins take a couple of seconds to load the first time they are run; after that, they are quite fast.
To download the Word add-in, click on the appropriate link below with your secondary mouse button (i.e., right-click) and select Save Target As ⦠(Internet Explorer) or Save Link As ⦠(Firfox) from the menu.
Internet Explorer 7 changes the file extension to .zip in the Save As dialog. Change the ending back to .dotm and it should work fine.
The Word 2007 add-in seems to work at least somewhat on the Mac with Office 2011.
Chemistry Words List
Save the add-in in the Word startup directory.
Unless you have Office 2007 or later, do the following. Otherwise, follow the directions under PowerPoint, below.
Once the file is in the correct directory, it will automatically load every time Word is started. To start the formatter without restarting Word, go to the Templates and Add-Ins⦠dialog box (on the Tools menu).
If the list of add-ins does not include âChemistry Formatterâ, use the Add⦠button to locate it. Put a check mark next to the entry â Chemical Formatter for Word.dotâ (which should now be present in the add-ins list). Click the OK button to complete the installation. You can tell that installation succeeded by the appearance of the button on Wordâs standard toolbar.
The Chemistry Formatter for Word will process text in shapes, a ânormalâ selection of text, a âblockâ selection (made by holding down the alt key before selecting text), and cells in a table. The shapes and normal selection are usually processed in less than a second. Processing a block selection takes about 7 times as long, though this is still only about a second for small selections. A block of cells in a table is also somewhat slower to process if it extends over more than one row, and doesnât include all the cells in the row; however, it is not as slow as a block selection. If the AutoCorrect âReplace text as you typeâ option is turned off, the formatter will convert -->, but not , to . If it is on, the formatter will convert , but not -->, to .
Word XP and later versions allows the user to select several regions of text at the same time (select the first region, hold down the control key, and select another region with the mouse). The Chemistry Formatter will only format the last region selected. The formatter does not process text in diagrams. Also, the formatter will produce an error message if hidden text at the very end of a document is selected (by using âSelect Allâ from Wordâs Edit menu).
Complete âUndoâ capabilities are provided. (Word provides this automatically; I canât take credit for it.)
The program was created using Visual Basic for Applications. It is not password protected. To view the code, unload the add-in, open it from the file / open menu, then go to the Visual Basic Editor.
Chemists use all kinds of symbols. Word includes âAutoCorrectâ, which makes it easy to use combinations of symbols. If you type, say, â-->',it is automatically changed to . (Control-z will undo the change.) You can add other entries to the AutoCorrect list. Here are some entries Iâve added:
Here is a Word document that makes it easy to add entries to the AutoCorrect list. Just select the entries that you want to add from a table and click the button. 17 entries are included; you can add others. The table makes a convenient storage area for the entries youâve added so that you can find them when you need them.
Nghê Quá»c Khải has created a nice Word add-in called ChemSpell.
To download the Excel add-in, click on the appropriate link below with your secondary mouse button (i.e., right-click) (Mac users: hold down the control key, , and click on the link) and select Save Target As ⦠(Internet Explorer) or Save Link As ⦠(Netscape) from the menu.
Internet Explorer 7 changes the file extension to .zip in the Save As dialog. Change the ending back to .xlam and it should work fine.
Save the add-in in the existing Excel AddIns directory. (If the directory is hidden, make it visible by following the procedure given above for the Word Add-in.)
Note for non-English users:
On computers using a different language, the directory names may be different than shown below. See the notes under Word, above.
For Excel 2007 and 2010 for the PC, the default path to this folder follows. These directories are not visible by default, so the procedure above must be followed to make them visible. The Excel 2007 add-in seems to work at least somewhat on the Mac with Office 2011.
For Windows XP:
Chemistry Add In For Word Mac Download Torrent![]()
C:Documents and SettingsUSERNAMEApplication DataMicrosoftAddIns
For Windows 2007, and Vista:
C:UsersUSERNAMEAppDataRoamingMicrosoftAddIns
For Excel 2003, XP and 2000 for the PC, the default path to this folder is
for Windows 2000 or Windows XP,
C:Documents and SettingsUSERNAMEApplication DataMicrosoftAddIns
or, if user profiles are used on your computer,
C:WindowsProfilesUserNameApplication DataMicrosoftAddIns https://flickstree289.weebly.com/blog/mac-os-x-tiger-install-cd-download.
or, for older Windows operating systems,
C:WindowsApplication DataMicrosoftAddIns
Unless you have Office 2007 or later, do the following. Otherwise, follow the directions under PowerPoint, below.
Once the file is in the correct directory, go to the Add-Ins⦠dialog box (on the Tools menu).
Put a check mark next to the entryWord Chemistry Add In
Cells containing numbers or formulas are ignored. Hidden and protected cells are unchanged, as are linked textboxes. Blank cells are ignored, so you can run the formatter with an entire column or row (or the entire sheet) selected. The formatter is unable to format textboxes and other âAutoShapesâ if they are on charts, so these will have to be formatted manually.
âUndoâ is provided for cells. It is not available for other objects, such as comments and text labels. A drawback to adding undo capabilities is that it erases the contents of the clipboard.
The arrow, and multiplication sign, Ã, are operating system dependent in Excel (Word doesnât have this problem). If a Mac is used to create a spreadsheet containing these characters, the symbols will not make sense to someone viewing the spreadsheet on a PC, and vice versa. Although both operating systems have some fonts in common, the character sets used by these fonts are different. If you send a spreadsheet to someone using a different operating system, you may want to first use Edit / Replace⦠to convert to --> and x to Ã.
The Excel chemistry formatter was created using Visual Basic for Applications. The code originated from a macro provided by Dr. E. J. Billo, of the chemistry department at Boston College in Chestnut Hill, MA. His macro is also in his book, Excel for Chemists, 2nd ed, which came out in March, 2001.
The XP versions of the add-ins will convert 1e6 or 1E6 to exponential notation; the other versions only convert a capital E (searching for a lower case e, the most-used letter in English, significantly slowed down the formatter on older machines).
Why three versions? The add-ins were developed for Office XP. Some changes were needed when the add-ins were run on Office 2000, which didnât support the drawing canvas, or the new worksheet protection model used in Excel. More changes were needed then they were run on Office 97, which uses an older version of Visual Basic for Applications.
If you do some programming using Visual Basic for Excel or Word, you may have changed âError Trappingâ (Tools/Options⦠in the Visual Basic editor) to âBreak on All Errorsâ. This setting may occasionally cause the add-ins to stop running. The problem will go away if one of the other error trapping settings is used.
To download the PowerPoint add-in, click on the appropriate link below with your secondary mouse button (i.e., right-click) and select Save Target As ⦠(Internet Explorer) or Save Link As ⦠(Netscape) from the menu.
Chemistry Add In For Word 2016 Mac
This requires service pack 1 (which you may already have, if youâve got Microsoft Update turned on).
Internet Explorer 7 changes the file extension to .zip in the Save As dialog. Change the ending back to .ppam and it should work fine.
Internet Explorer 7 changes the file extension to .zip in the Save As dialog. Change the ending back to .ppam and it should work fine.
Save the add-in in the existing AddIns directory. The default path to this folder follows. These directories are not visible by default, so the prodecure above must be followed to make them visible.
In Windows 2000 or Windows XP, the default path to this folder (in English) is
C:Documents and SettingsUSERNAMEApplication DataMicrosoftAddIns
In Windows 7 or Vista, the default path to this folder (in English) is
C:UsersUSERNAMEAppDataRoamingMicrosoftAddIns
If your computer uses a language besides English, the directory name will probably not be exactly as indicated above. See the notes under Word, above.
To install in PowerPoint 2003: Start PowerPoint 2003. Change the security level from high to medium (on the Tools menu, select Macro, then Securityâ¦. On the âSecurity Levelâ tab, select Medium. Go to the Add-Ins⦠dialog box (on the Tools menu). Use the Browse button to find the file. Put a check mark next to the entry âChemistry Formatter for PowerPoint 2003â and you are done. You can tell that the installation succeeded by the appearance of a button with âH2Oâ on it on the formatting toolbar. If you like, you can reset the security level to high.
To install in PowerPoint 2007 or 2010: Start PowerPoint. Click the Office Button, then select PowerPoint Options (located at the bottom, not side, of the Office Button box). The PowerPoint Options box appears. On the menus on the left frame, select Add-Ins. At the bottom of the right frame is Manage, followed by a drop-down list. From the list, select PowerPoint Add-ins. Click the Go button. Up pops a dialog box. Use the Add New⦠button to find the file. Finally, put a check mark next to the entry 'Chemistry Formatter for PowerPoint 2007 (or 2010)â and you are done. You can tell that the installation succeeded by the appearance of a button on the Home tab of the ribbon, after the Font group:
The programming interface in PowerPoint is not as complete as it is in Word or Excel, so this add-in isnât quite as sophisticated. The button that runs the formatter isnât as fancy: it is just the label H2O. Hereâs what it looks like on the formatting toolbar: If you move it, the new position wonât be remembered when PowerPoint is restarted.
If â->â is typed, the formatter will convert it into a prettier arrow. This is different from Word and Excel, where â-->â is what gets changed to an arrow. In Word, if no text is selected, the paragraph containing the cursor is formatted. In PowerPoint, the paragraph containing the cursor cannot always be determined. So, if no text is selected in a title box, the entire contents of the box will be formatted. In a table or organization chart or note pane (in âNormalâ view), if no text is selected, nothing will be formatted, though if the entire table or chart is selected, then the entire table or chart will be formatted. For other shapes, the current paragraph will be formatted, if no text is selected. That includes notes in âNotesâ view. If multiple shapes or slides are selected, they will all be formatted. Comments cannot be formatted. No part of a chart can be formatted.
âUndoâ is available; Cntl +z, or the undo button or menu will restore the changes made by the add-in.
This version will replace either â->â or ââ with a prettier arrow. SmartArt shapes, charts, and comments cannot be formatted. Most selections of part of a paragraph can now be formatted. The PowerPoint 2010 code, for curious VBA programmers, may be downloaded.
The next version of Office for the Mac, âMicrosoft Office 2008 for Macâ, will not include Visual Basic. Microsoft recommends writing macros in AppleScript. Also, OpenOffice now supports macros. Both of these could use a chemistry formatter. If youâd like to get the chemistry formatters to work on other platforms, Iâd be happy to add a link to your site, or make your product available here. If youâd like, we could work together on the project. Getting the formatters to format text is the easy part. Getting them to handle any situation the user throws at them is the time consuming part. That requires learning the softwareâs object model. To produce a quality product requires testing all the possibilities, which takes time.
Let me know if you have problems or suggestions, or just like the formatters. Iâm at [email protected].
--Chris
Page last updated: December 16, 2013
The program can not be downloaded: the download link is not available.External download links have become invalid for an unknown reason.Sorry, but we cannot ensure safeness of third party websites.
Often downloaded with
Reference
Physics, Chemistry and Math - A simpleNeasyApp by WAGmob
Teaching Tools
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |