Ray Lang Posted March 1, 2016 at 01:54 AM Posted March 1, 2016 at 01:54 AM Jackson Harding Oceania Regional Director have put together some excel Oceanic worksheets; they cover the following oceanic areas AGGG ANAU Brisbane Oceanic NFFF NTTT NZZO THe file VATOCE Oceanic Worksheets.zip can be downloaded from the Pacific Oceanic Partnership website http://pacificoceanic.vatsim.net/ Ray Lang Vatsim Senior Supervisor Pacific Oceanic Partnership Admin Have a question? Email [email protected] Link to comment Share on other sites More sharing options...
Greg Barber Posted March 1, 2016 at 04:07 AM Posted March 1, 2016 at 04:07 AM This is really cool. Having an issue though, maybe it's just me. Created a conflict on L508... But it doesn't show on the overview... Greg Barber VATPAC3 - Director ATC Training & Standards Link to comment Share on other sites More sharing options...
Jackson Harding Posted March 1, 2016 at 10:06 AM Posted March 1, 2016 at 10:06 AM Greg, That is odd, the overview sheet uses an INDIRECT() function to reference each page in the worksheet and label them as either OK or CONFLICT. They were written in ods format, however reading the Excel docomeentation that function is exactly the same. The only functionality that doesn't seem to translate is the LibreOffice ODS sheets have push buttons in the Overview page that link to each sheet in the file. These don't seem to work in Excel. I'll fire them up in Excel again and see if I can track down the issue. Jackson Chair Asia Pacific RCRP Link to comment Share on other sites More sharing options...
Ray Lang Posted March 2, 2016 at 01:32 PM Author Posted March 2, 2016 at 01:32 PM The Brisbane Oceanic overview status column where it has #Ref! by widening the column would this solve the problem. Ray Lang Vatsim Senior Supervisor Pacific Oceanic Partnership Admin Have a question? Email [email protected] Link to comment Share on other sites More sharing options...
Jackson Harding Posted March 10, 2016 at 10:54 PM Posted March 10, 2016 at 10:54 PM #Ref indicates there is an error in the formula in that cell, usually referring to the wrong point. If the cell is too narrow it's usually just ######## Jackson Chair Asia Pacific RCRP Link to comment Share on other sites More sharing options...
Recommended Posts