Miscellaneous notes on the Excel-based Custody Tracker (OBSOLETE)
Instructions For Transferring Data From Older Versions Of The Parenting Time Tracker
Follow these steps to transfer your existing PTT data to a newer version of the PTT.
Open both the PTT that you've been using and the new (empty) PTT.
In the older version PTT (the one with all the data you've filled in), highlight the entire Start and Stop time block (all of the yellow cells) under the Scheduled Time.
Select Copy from the Edit menu, or press CTRL-C.
Switch to the new PTT.
Select the January 1 'Start Time' cell in the Scheduled Time section. Make certain you select only this single cell or the data won't transfer in correctly.
Use the Paste command on the Edit menu to paste the data, or press CTRL-V. This will fill in that entire section.
Repeat this for the Actual Time section and the other months.
Special note regarding the Type column: If you cut and paste the Type column, you'll lose the ability to wrap to the next line for longer 'Custom' types. If you want to be able to use longer descriptions in the 'Custom' cells, you must manually enter the Type data.
Save the PTT worksheet. You can now use the newer version of the PTT, with all the times and dates you entered into the previous version present.
Turning off the 'popups'
The value cell 'popups' are turned on because a lot of people who separate or download the Tracker later in the year don't start with January. You may find those popups annoying, but we think they're useful. If you really can't stand them, here's how to turn them off:
Unprotect the sheet using the password at the bottom of the Help page. (Tools -> Protection -> Unprotect Sheet)
Select the cells where you want to turn off the message. (You can select the Scheduled Time block as a unit (start and stop columns), the Type as a unit, and the Actual Time as a unit. There doesn't seem to be a way to do them all together because they have slightly different settings. Only the yellow (input) cells in these areas have the popup message turned on).
Select the center tab, "Input Message".
Click on the box marked "Show input message when cell is selected" to deselect it.
We strongly recommend that you reprotect the page when you are done. This will keep you from accidentally overwriting any cell with a formula in it, which is a lot easier to do than it sounds. Converting the Tracker for use in Lotus 123
Several people have asked about using the Parenting Time Tracker (PTT) in Lotus, and one of our users was nice enough to type up the following steps to convert the Tracker to work in Lotus. Since the PTT was not designed to run under Lotus, we can't guarantee that this will work, but some users have apparently been able to convert the worksheet(s) successfully.
Unzip the file using the "c:\tracker" folder as the default. You should see a message stating that the files unzipped successfully. One file is the .XLS file, one is the Help file, and one is this file (Lotus.txt).
Open Lotus 123 and click the "Browse for more workbooks" button.
Where it says "Look in" at the top of the pop-up window, set it to the "tracker" folder on the c:\ drive.
About two-thirds of the way down the pop-up window is a label that says "Files of type". Click on the arrow and choose "Microsoft Excel (XLS;XLT;XLW)"
The Tracker .XLS file should show up. Click on it and then click the 'Open' button.
Click the OK button in the 'Untranslatable' message dialog box. (Ignore this message.)
Put the correct year in the "Year" cell on the first tab, then select the January tab. On the January sheet, select cell B5. Up on the menu, select 'Range', then 'Range Properties'. When the Range Properties window shows up, select the tab with the key on it. Uncheck the bottom checkbox to disable the protection for cell B5.
Type "Mon" in cell B5.
Click the File menu and select "Save As..." In the "Save as type" area, select "Lotus 1-2-3 OS/2 Warp 4 workbook (123)". If you have an older (or newer) version of Lotus, select the correct version.
Converting the Tracker to Macintosh format
This is the text of the instructions found in Excel Help for converting a file for use on a Mac:
To Move files between Microsoft Windows and the Macintosh:
The Macintosh must be running system software version 7.5 or later, have PC Exchange installed, and be equipped with a disk drive that can read MS-DOS floppy disks. The Macintosh Excel version must correspond to the Excel for Windows version. For example, to move files from Excel 2000 to the Macintosh, you must be running Microsoft Office 98 Macintosh Edition.
Save your Windows-based file to a 3.5-inch floppy disk.
Insert the floppy disk in the Macintosh floppy disk drive.
In Excel on the Macintosh, click Open on the File menu.
Locate and then double-click the file you want.
If you have access to a network share that is connected both to personal computers running Windows and to Macintosh computers, you can place the files on the network and then open the files from either type of computer. You can also easily move files between Windows and the Macintosh if you have access to a Windows NT server that is set up with Services for the Macintosh. For more information, see your Windows NT documentation.
You can run QuickTime movies only on the Macintosh. The Microsoft Excel mapping feature, the Web Form Wizard, Quattro Pro converters, and the Access Links add-in program are not available for the Macintosh.
Because Macintosh files do not have file name extensions, you should use *.* to search for Macintosh files.