Jump to content
Ray Lang

VATOCE Oceanic Worksheets

Recommended Posts

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

Deputy Regional Director - VATSIM Oceania

Vatsim Senior Supervisor

Team Lead 1

Pacific Oceanic Partnership Admin

Have a question? Email [email protected]

u559tvN.png

Share this post


Link to post
Share on other sites

This is really cool. Having an issue though, maybe it's just me.

 

Created a conflict on L508...

739d3f2912.png

 

But it doesn't show on the overview...

98884878ad.png


Greg Barber

VATPAC7 - Non-Executive Director

Share this post


Link to post
Share on other sites

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


Vice President Regions.

VATSIM Board of Governors

vatsim_0.png

Share this post


Link to post
Share on other sites

#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


Vice President Regions.

VATSIM Board of Governors

vatsim_0.png

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

×
×
  • Create New...