Integration of worksheets and dashboard in Excel

Mark_J_W

Thanks for this. 

I think there is a behaviour error. 

For ships that do not call to PMNZ facilities, we do charge them the appropriate fee for anchoring. See row 8 - CruiseShip1. This should have found that this is a fee of $4200 (column R is calculating this) and added it to column AH. Is this a formula error that is preventing it showing through? 

I put the columns M & N in to try and calculate out those ships that do not get charged for berthing as they call to PMNZ facilities compared to those that just anchor and are available to be charged. 

Would conditional formatting allow the row for a ship to completely grey out once the ship has departed?

For the invoicing side, the spreadsheet looks good and works. 

For the projects, that have p/wk or p/hr, is there a way to be able to add those hours/weeks in and it auto-calculate? 

I've added some comments to the sheets to try and explain what I mean.

The anchoring dashboard - Great!!

I've had a play with moving the ships to the various anchorages and for some reason they don't seem to be moving across into the current actual section? 

To get the data into the invoice template on the original workbook. Does it need both the shipping board and the invoicing board to send the data to a final "round-up" table before then going on to the template when required?