Jump to content

You're browsing the 2004-2023 VATSIM Forums archive. All content is preserved in a read-only fashion.
For the latest forum posts, please visit https://forum.vatsim.net.

Need to find something? Use the Google search below.

VATOCE Oceanic Worksheets


Ray Lang
 Share

Recommended Posts

Ray Lang
Posted
Posted

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]

spacer.png

Link to comment
Share on other sites

Greg Barber
Posted
Posted

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

VATPAC3 - Director ATC Training & Standards

Link to comment
Share on other sites

Jackson Harding
Posted
Posted

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

 

vatsim_0.png

Link to comment
Share on other sites

Ray Lang
Posted
Posted

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]

spacer.png

Link to comment
Share on other sites

  • 2 weeks later...
Jackson Harding
Posted
Posted

#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

 

vatsim_0.png

Link to comment
Share on other sites

 Share