#counter

[[FrontPage]]

#logparanoia()

//- &color(red){NEWS!!}; This page has been totally updated! (Nov. 12, 2011)
//- &color(red){NEWS!!}; I will give an informal talk on Praat Launcher at [[Tsukuba Phonetics and Phonology Seminar>https://sites.google.com/site/tsukubapps/]] (Nov. 20, 2011, University of Tsukuba). The talk will be conducted in Japanese.


//* Praat Launcher [#a0eca2e6]
''&size(30){Praat Launcher};'' is a Microsoft Excel add-in that launches [[Praat>http://www.fon.hum.uva.nl/praat/]] from Excel worksheets.
It works on Excel 2003/2007/2010/2013/2016 (for Windows), and 2004/2011/2016 (for Macintosh)((Praat Launcher does NOT run on Excel 2008 (for Macintosh), which lacks VBA.)).
//, ''but not on 2008 (for Macintosh)''.

#br
----

&size(20){&color(red){NEWS!};};  (Sep. 5, 2016) An updated version (Ver. 3.0.0) Released! (Supported: Excel 2013/2016 for win, 2011/2016 for mac)


&size(20){&color(red){NEWS!};};  (Mar. 14, 2013) An updated version (Ver. 2.1.2) Released! (bug fixed)


&size(20){&color(red){NEWS!};};  (Oct. 16, 2012) I presented a poster session at [[the Second Workshop on Corpus Japanese Linguistics>http://www.ninjal.ac.jp/event/specialists/project-meeting/m-2012/jclws02/]] ([[NINJAL>http://www.ninjal.ac.jp/]],Tokyo).
- Nishikawa, K. (2012) [[Praat Launcher: An Excel Addin for “doing phonetics by computer”>http://www.ninjal.ac.jp/event/specialists/project-meeting/files/JCLWorkshop_no2_papers/JCLWorkshop2012_2_30.pdf]] (in Japanese) &color(red){<- Click to open or download PDF version (external link)};

(it can be a convenient introduction to Praat Launcher for Japanese speakers)

//&size(20){&color(red){NEWS!};};  (Aug. 8, 2012) An updated version (Ver. 2.1.1) Released!
// is under development! 
//- It will be released by the end of this month (July, 2012).
//- The aims of this update are:
//++ to allow it to accommodate various types of data, including CSJ-RDB (in preparation), and
//; cf. [[Koiso, Den, and Maekawa 2011>http://www.ninjal.ac.jp/event/project-meeting/m-2011/jclws01/JCLWorkshop_no1_papers/JCLWorkshop2012_53.pdf]]
//++ to make the design as simple as possible.
----
#br

''Contents''

#contents

* Demonstration Movie [#w346c1dc]
- http://www.youtube.com/watch?v=wHACLupeAS8~
#youtube(wHACLupeAS8)
--- ''N.B. '' In this demo, the first launch is executed from the add-in menu (at the upper left), the second launch from the (right-)click menu, and the third and the following launches by pressing the shortcut key (C-S-v). Praat is closed each time with the Praat shortcut key (C-q).

* Download (add-in, documents, sample set) [#f8eea4e2]

- Excel add-in
-- Download one of the following .zip files and unzip it:
--- &ref(praat_launcher300_xlam.zip); (Sep. 5, 2016) <- [NEW-STYLE] ''Ribbon'' based user interface (extension: ''.xlam'')
--- &ref(praat_launcher300_xla.zip); (Sep. 5, 2016) <- [OLD-STYLE] ''CommandBar'' based user interface (extension: ''.xla'') 

|               | ''CommandBar (.xla)'' |CENTER:''Ribbon (.xlam)'' |h
| ''Windows''   | 2003                  | 2007, 2010, 2013, 2016   |
| ''Macintosh'' | 2004, 2011            | 2016                     |
CENTER:Supported versions of Microsoft Excel
--- '''Notes for mac users (1)''': On Excel 2011 for mac, use ''.xla'' add-in, not ''.xlam''.
--- '''Notes for mac users (2)''': On Excel 2016 for mac, an additional file would be required. For details, see [[below>#e76fedcd]].

--- &size(9){[[Older Versions>#pf3f4d42]]};
- documents
//++ &ref(setup_prln.pdf); (Setup, Update, and Deletion of the Add-in. Version 1.0)
//++ &ref(tut_prln.pdf); (Tutorial for Praat Launcher. Version 1.0)
//++ &ref(man_prln.pdf); (Manual of Praat Launcher. Version 1.0)
++ [[setup_prln.pdf>http://language.world.coocan.jp/prln/setup_prln.pdf]] (Setup, Update, and Deletion of the Add-in. Version 1.0)
++ [[tut_prln.pdf>http://language.world.coocan.jp/prln/tut_prln.pdf]] (Tutorial for Praat Launcher. Version 1.0) &color(red){<- For Praat Launcher Version 1.5.x; an updated manual is in preparation; See [[History>#bda3956e]] instead.)};
++ [[man_prln.pdf>http://language.world.coocan.jp/prln/man_prln.pdf]] (Manual of Praat Launcher. Version 1.0) &color(red){<- For Praat Launcher Version 1.5.x; an updated manual is in preparation; See [[History>#bda3956e]] instead.)};

- sample set (used in the Tutorial)
-- [[sample20111103.zip>http://language.world.coocan.jp/prln/sample20111103.zip]]

* Motto [#o5267c27]
- Enjoy doing phonetics by computer!
- Praat-o motto tanoshiku! (in Japanese)
//* Motto [#o5267c27]
//- Enjoy doing phonetics by computer!
//- Praat-o motto tanoshiku! (in Japanese)

//* Praise from the Users [#rec02c4f]
//- It has changed my style of work. (male - Ibaraki, Japan)
//- Just use it! (male - Hiroshima, Japan)
//- It drastically reduces the time of work. (female - Chiba, Japan)
//
//-- &color(red){N.B. These are personal comments.};

//* License [#xdc91771]
//You may use, copy, modify, and redistribute Praat Launcher provided that you believe it contributes to phonetic studies.

* Notes for users of Excel 2016 for mac [#e76fedcd]
The setting-up of Praat Launcher on ''Excel 2016 for mac'' is slightly complicated.
// in some respects.

** Add-ins Folder [#e1e5a432]
//To quote:
//>There is no default startup directory for Excel 2016 for Mac. To set a startup folder, see References section for alternative startup file location. ("How to use Excel startup folders in Excel for Mac" https://support.microsoft.com/en-us/kb/259921 )

Possibly:
--  ~/Library/Group Containers/UBF8T346G9.Office/User Content.localized/Add-Ins.localized

cf. http://macadmins.software/docs/UserContentIn2016.pdf

** Setting up [#t1e35d08]
Additional jobs are required if you run Praat Launcher on ''Excel 2016 for Mac''.
+ Create the following directory if it does not exist:
 ~/Library/Application Scripts/com.microsoft.Excel/
+ Download &ref(praatlauncher.applescript); (an AppleScript file), and put it in the directory created above.

//&ref(praatlauncher.applescript);


Example (on the terminal):
 cd ~/Library
 mkdir "Application Scripts"
 cd "Application Scripts"
 mkdir com.microsoft.Excel
 cd com.microsoft.Excel
 cp ~/Downloads/praat_launcher_xlam/praatlauncher.applescript .

** File/Folder access settings [#p4284114]
After the first launch of Praat, the following dialog windows might appear. Click [Select] button to grant file access.

 Grant File Access
 
 Additional permissions are required to access the following files:
 /Users/[homedirectoryname]
 
 Micorsoft Excel needs access to the folder named '[homedirectoryname]'.
 Select this file to grant access.
                                       [Cancel] [Select]

 Grant File Access
 
 Additional permissions are required to access the following files:
 /Users/[homedirectoryname]/tmp_launch.praat
 
 Micorsoft Excel needs access to the file named 'tmp_launch.praat'.
 Select this file to grant access.
                                       [Cancel] [Select]

* Disclaimer [#b95bd39a]
The author expressly disclaims all liability, loss or risk incurred as a direct or indirect consequence of the use of Praat Launcher.

* Tips [#v87ec8d3]
- Akira Utsugi made a Praat Plug-in which generates data for launch:
-- [[Plug-in for Praat Launcher>https://sites.google.com/site/utsakr/Home/miscellaneous-files]] (link to Akira Utsugi's Web Site) &color(red){<- link updated (Aug. 12, 2012)};
//broken link

* Trouble Shooting [#ec905d3b]

*** Excel 2011 for mac [#f7735a79]
- Excel terminates unexpectedly when the add-in comes into use.
-- Try the following steps:
--- https://support.microsoft.com/en-us/kb/2026104 (in English)
--- https://support.microsoft.com/ja-jp/kb/2026104 (in Japanese)

* Known Bugs [#p2fc74d7]
(under construction)

* Older Versions [#pf3f4d42]
-- &ref(praat_launcher.2.1.2.xla); (Mar. 14, 2013)
-- &ref(praat_launcher.2.1.1.xla); (Aug. 8, 2012)
-- praat_launcher.1.5.2.xla (not released on the web)
-- praat_launcher.1.5.1.xla (not released on the web)
-- &ref(praat_launcher.1.5.0.xla); (Nov. 3, 2011)

* History [#bda3956e]

** Version 3.0.0  (Sep. 5, 2016) [#cbf05688]

- Newly supported: Excel 2013/2016 for win; 2011/2016 for mac
-- '''Notes for mac users''': Excel 2011 for mac, rather than 2016 for mac, is recommended as far as Praat Launcher is concerned; on the latter, [[additional jobs>#e1e5a432]] would be required.
- Two types of add-ins are provided:
-- [OLD-STYLE] ''CommandBar'' based user interface (extension: ''.xla'')
-- [NEW-STYLE] ''Ribbon'' based user interface (extension: ''.xlam'')
|               | ''CommandBar (.xla)'' |CENTER:''Ribbon (.xlam)'' |h
| ''Windows''   | 2003                  | 2007, 2010, 2013, 2016   |
| ''Macintosh'' | 2004, 2011            | 2016                     |
CENTER:Supported versions of Microsoft Excel

-- '''Notes for mac users''': On Excel 2011 for mac, use ''.xla'' add-in, not ''.xlam''.
- Context menus (right-click menus in the case of Windows) are eliminated.
- Shortcuts are added:
-- Ctrl-Shift-F1: Create the Setting Sheet
-- Ctrl-Shift-F2: Adjust the Setting Sheet
-- Ctrl-Shift-F3: Version Info




** Version 2.1.2  (Mar. 14, 2013) [#td481455]
- Corrected a bug that causes the launcher to give an incorrect error message when positive integers containing "0" (e.g., 10, 102, ...) are specified in the SettingSheet.

** Version 2.1.1 (Aug. 8, 2012) [#s19067b1]
&color(red){Totally Updated!}; 

The aims of this update:
- to allow it to accommodate various types of data, including CSJ-RDB (in preparation)
- to make the design as simple as possible

*** Screenshots [#e21faaf5]

''Menu''

- Old (version 1.5.x)
&ref(menu_old.jpg,,80%);

- New (version 2.1.1)
&ref(menu_new.jpg,,80%);


''Setting Sheet''

- Old (version 1.5.x)
&ref(settingsheet_old.jpg,,50%);

- New (version 2.1.1)
&ref(settingsheet_new.jpg,,50%);

*** Major Modifications [#pf64aadc]

- Four mutually independent commands (Command 1-4) are provided, each of which can take its own values (e.g., Sound/TextGrid files).
- In the Setting Sheet, files must be specified with their absolute paths and extensions.
-- The following items were abolished:
--- Folder containing the TextGrid Files
--- Folder containing the Sound Files
--- TextGrid File Extension
--- Sound File Extension
--- Sound Filebasename Suffix 1
--- Sound Filebasename Suffix 2
--- Column/Field for Filebasename
--- Column/Field for Sound Filebasename Suffix
- Notations like "<A>", "<B>", ... are available in specifying the files; they represent the values of the cells at the intersection of the current row and the specified columns.
-- Examples:
 C:\path\to\<A>.wav
 C:\path\to\<A>-L.wav
 C:\path\to\<A>-<E>.wav
-- Numerals ("<1>", "<2>", ...), besides alphabets, are also available.
-- Substrings of the values of the cells can also be obtained with the following notation:
 <column[,start][,length]>
(NOTE: Arguments enclosed with "[" and "]" are optional; however, ''start'' cannot be omitted when ''length'' is specified.)
--- column: alphabet or numeral
--- start: the starting position (NOTE: The number begins with 1, not 0)
--- length: the number of characters (NOTE: If omitted, returns everything through the end of the string.)
--- Examples:
 C:\path\to\<A,1,10>.wav    # A01F0055-L-foo  =>  A01F0055-L
 C:\path\to\<A,5>.wav       # foo-A01F0055-L  =>  A01F0055-L
-- The notations "<BASENAME>" and "<SUFFIX>" were abolished.
- The notation "column[,start][,length]" is also available in "Column/Field for TIMESTAMP". (NOTE: "<" and ">" should NOT be included here.)
-- Examples:
 D,6,9      # 0001 00000.329-00004.849  L:-001-001  =>  00000.329
 D,16,9    # 0001 00000.329-00004.849  L:-001-001  =>  00004.849
("0001 00000.329-00004.849  L:-001-001" is an instance taken from *.sdb (Short Unit Word) files in CSJ, in which the timestamps (as well as the channel info) are embedded in Column D.)
- The value of either Sound or TextGrid file may be null (but not the both); Praat Launcher tries to open only the specified one.
-- The commands to open either Sound or TextGrid file were abolished.



*** Minor Modifications [#jf4790bb]
- The cells on Column E of the Setting Sheet become editable.  (NOTE: The values on Column E are simply ignored; users can make use of it to escape some values.)
- Praat Launcher causes an error if (i) the values of TIMESTAMP1 and TIMESTAMP2 are both numeric, and (ii) the value of TIMESTAMP1 is larger than that of TIMESTAMP2.
- Renamed "(Setting -> )SettingSheet" to "Create".
- Provided "(Setting -> ) Adjust" Menu, which adjusts the Column width of the Setting Sheet.
- The default values of "Select: from the Specified Point Minus..." and "Select: to the Specified Point Plus..." changed from 0.03 to 0.01.
- [Windows Only] Slashes ("/") in the values of file specification are taken as path separators ("\").
- [Windows Only] Praat Launcher gives an error message before launching Praat, if the specified Sound/TextGrid files do not exist. (NOTE: In Macintosh, Praat, not Praat Launcher, gives an error message.)


** Version 1.5.2 (not released on the web) [#l9394f13]

- When a file (e.g., a Pitch file) is specified in "Other File(s) to be Read" (renamed as "Other Files" in Version 2.1.1), Praat Launcher tries to open it with an appropriate editor, and jump to the specified regions within that editor.
-- NOTE: Praat Launcher does NOT synchronize multiple editors. Check the "Group" button (at the rightmost bottom in the editor) to synchronize them.

** Version 1.5.1 (not released on the web) [#g0c01722]
- Corrected a bug that caused Praat to halt (in some ---not the author's--- environments) when the value of TIMESTAMP1 is less than 1.

Front page   Edit Diff Backup Upload Copy Rename Reload   New List of pages Search Recent changes   Help   RSS of recent changes