{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Overview","SailMail Log","Station Table","Chart"],"not_rendered":{"charts":1,"macros":1,"external_links":1,"defined_names":2},"unopened":[{"sheet":"Chart","index":3,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Overview","index":0,"n_rows":24,"n_cols":1,"rows_kept":24,"merged":[[8,1,8,2]],"flags":["formulas_cached_only"]}
["SailMail Log  by John Stevenson"]
[]
["The purpose of this spreadsheet is provide a log that tracks connect time with the SailMail system.  SailMail users are restricted to a total of 90 minutes of connect time over a 7 day period.  Once over that limit the system may not accept connections for a period necessary to reduce that 7-day connect time total to some value less than 90 minutes.  When I initially started using SailMail I found it difficult to determine how close I was coming to that 90 minute limit.  I did not want to go over the limit and find out how strictly it is enforced.  SailMail allows users to request additional time if they are in danger of going over the limit and have a safety at sea or other critical reason for needing extra connect time.  However, if you don't know how close you are to the limit you don't know when to request an extension.  If you go over it may be too late to request additional time.  You may be locked out for a period of time."]
[]
["Consequently I developed this spreadsheet to help me track my connect time and anticipate if I am in danger of exceeding the system limit.  All connections are entered into the SailMail Log Worksheet.  The necessary fields are the Date, Connect Time and Disconnect Time.  These fields are used to compute the total connect time for the last 7 days.  The additional fields may be filled in to provide a record of these connections, but they are not used in the connect time calculations."]
[]
["At the top are the overall values generated by the log:"]
[]
["SailMail Connection Log as of: 1/17/2005  4:25:38 PM      Hours to UTC:"]
["Current 7-Day Connect Time: 37.66 Minutes"]
["Time Available for Connection now: 52.34 Minutes"]
[]
["The first line displays the date and time the log was opened.  Since the SailMail system times are UTC, this time should be UTC.  If you do not run your PC on UTC, then enter the UTC offset in hours in the cell to the right of the Hours to UTC: text.  If your PC time zone is West Longitude, enter the offset as a positive value.  If your timezone is East Longitude enter the offset as a negative value."]
["The second line shows your total connect time for the last 7 days as recorded in the log.  This value is calculated to the date/time displayed in the line above.  The spreadsheet also calculates 7-day connect time for each log entry (7-Day Cnct Mins field).  That value reflects the 7-day connect time at the time that connection was completed, and the value is not updated after the log entry is completed.  The value shown at the top of the worksheet is recalculated everytime the spreadsheet is opened (or Function Key 9 is pressed)."]
["Therefore the  connect time value shown on the second line is your key to how close you are to the system limit at the current time.  In the example value (37.66 minutes) there should be no worry about going over the limit."]
["The third line is an attempt to quantify how close you are to the limit.  This value represents how long you can stay connected without going over the limit.  Obviously 52.34 minutes should exceed anyone's requirement for a single connection.  The information on this line becomes important only when the value becomes 15 minutes or less.  With a low quality connection it is very easy to exceed 15 minutes to get one GRIB file and a couple of text messages.  Therefore when the Time Available value becomes small it is time to either delay your next connection for 12 to 24 hours or send a request for additional time to the SailMail sysop."]
["Also please don't try to use these calculations too precisely.  I have no insight into how SailMail calculates the connect used to administer the system.  This is my approach, which may not match what SailMail calculates."]
[]
["The workbook also includes a graph of the daily connection time and the running 7-day connect time.  This may be helpful to plan the next connection so that it does not push the connect time too far above the SailMail 90 minute limit.  The graph can help identify the longer connections that may be a major factor in a currently high 7-day connect time, and identify how much time must pass before these connections will drop out of the total (more than 7 days ago)."]
[]
["Dates and times should be entered in standard Excel formats (mm/dd, hh:mm:ss).  To make the time data entry easier you may elect to change the time separator character from \":\" to one that does not require the shift key (e.g., \"-\" or \".\").  This is accomplished through the Windows Control Page."]
["The worksheet is protected to prevent accidental overwriting of the function calls that perform the calculation.  Protection can be turned off at any time (Tools/Protection/Unprotect Sheet)."]
[]
["This spreadsheet was developed under MS Office XP Professional and tested under that suite and MS Office 2003 Professional.  The test OS are Windows XP Professional and Windows 2000 Professional.  The calculations are performed in a single Visual Basic function (DailConnectAvg).  This function may not work properly in earlier versions of MS Office/Visual Basic."]

{"sheet":"SailMail Log","index":1,"n_rows":116,"n_cols":15,"rows_kept":116,"merged":[[0,5,0,6],[1,5,1,6],[5,1,5,2],[5,5,5,6]],"flags":["formulas_cached_only"]}
[{"$nulls":4},"SailMail Connection Log as of:","2007-03-17T19:05:20.760",{"$nulls":5},"Hours to UTC:",{"v":5,"d":"5.00"}]
[{"$nulls":4},"7 Day Period Starts:","2007-03-10T19:05:20.760",null,0]
[{"$nulls":4},"Current 7-Day Connect Time:",{"v":0,"d":"0.00"},"Minutes",0]
[{"$nulls":4},"Time Available for Connection now:",{"v":90,"d":"90.00"},"Minutes"]
[]
["Date","Time (hh:mm:ss)",{"$nulls":3},"Traffic",{"$nulls":3},"Connect","Incld in ",null,null,"7-Day"]
["(mm/dd)","Connect","Disconnect","Station","Frequency","Char Sent","Char Rcvd",null,"SWR","Time (min)","7 Day Period","Traffic","Eff BPS","Cnct Mins","Comments"]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":9},{"v":0,"d":"0.00"},false,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[{"$nulls":4},"Totals:",0,0,null,null,{"v":0,"d":"0.00"},null,0,{"v":0,"d":"0.00"}]

{"sheet":"Station Table","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"flags":["formulas_cached_only"]}
["Location","Callsign","Frequencies in kHz"]
["Palo Alto ","WRD719","5881.4, 7971.4, 10343, 13971, 13986, 18624"]
["San Diego","WQAB964","2759, 5740, 7380, 10206, 13874, 18390, 23060"]
["San Luis Obispo","WHV861","2800.4, 5861.4, 8020.4, 10320, 10982, 13915, 13946, 18296"]
["Friday Harbor","WHV382","2794.4, 5830, 7995, 10315, 13940, 18277"]
["Honolulu ","KUZ533","2701.4, 5836, 7957.4, 10325, 13930, 18264"]
["Rockhill","KZN508","2656.4, 5876.4, 7961.4, 7981.4, 10331, 13992, 13998, 18618, 18630"]
["Lunenburg","XJN714","4805, 7822, 10523, 13937, 18234, 21866"]
["Firefly","VZX","2824, 4162, 5085.8, 6357, 8442, 10476.2, 12680, 13513.8, 14436.2, 16908, 18594, 22649"]
["Maputo","RC01","5212, 7957.4, 10335, 13930, 18264, 22212, 27888"]
["Brunei Bay","V8V2222","5212, 6305, 8399, 10323, 13426, 14987, 16786, 18893, 20373, 22352"]
["Brugge Belgium","OSY","6330.5, 8422, 12580.5, 16684.5"]
["Corpus Christi","WPTG385","2720.8, 5859.4, 7941.4, 10361.4, 13906.4, 13926.4, 18376.4, 22881.4"]
["South Daytona","WPUC469","2807.8, 5897.4, 8009.4, 10366.4, 13921.4, 18381.4, 22961.4 "]
["Pedro Miguel","HPPM2","2650, 5870, 10337, 18610, 22643"]
["Chiriqui","HPPM1","4075, 5735, 8185, 10450, 13880, 18240, 18440, 23050"]
["Los Lagos","CEV773","2828.5, 5266.5, 10620, 10623, 13861.5, 13875"]