Formatting a Dashboard

Posted on 2011-05-12
Last Modified: 2012-05-11
Hi Experts

I have devised a Dashboard to check that a Crane is SAFE to operate:

Here are the criteria:
CELL L21 & N21 are Windspeeds CONSTANT & GUSTING

GREEN 25 or less
AMBER 26-30
RED 30+
GREEN 44 or less
AMBER 44-56

I think its ok here but I may have missed something. Would appreciate a SANITY check please.

Also the crane arrives on site on a given date. From that date onwards there is to be a 12 week interval for a CRANE SAFETY CHECK
From the date of arrival also there is to be a SIX MONTHLY Maintenance overhaul of crane.

Can you please check spreadsheet for any obvious errors.

Is there any way we can devise an arrival date and set that as a president for 12 weekly checks. Say arrives today 12th May, next inspection due 4th August, next 27th October and so on. Add this to the dashboard in row fashion in REctangle 3 and have it initialled by OPERATOR, to clear its use after maintenance.



 ExExversionCRANE.xls ExExversionCRANE.xls ExExversionCRANE.xls ExExversionCRANE.xls
Question by:tezza73
    LVL 50

    Accepted Solution


    not quite sure what you're after. The spreadsheet is mostly text.

    It is not quite apparent that some cells are entry cells for values, which then conidtionally change their color, and there is no indication as to what data type is expected in a cell. Row 17 has many different possible data entries. Maybe you could use data validation to help users pick valid entries only.

    I notice that the conditional formatting is set up in an odd way. Text is not case sensitive, so you only need to check for one version. It is not necessary to do a condition like is between "G" and "g", in fact, that is rather confusing.


    Author Comment

    I've requested that this question be deleted for the following reason:

    No Answer, it was merely a comment on the actual content of the spreadsheet
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    To be fair, there were three "issues" that were listed in this Q, ...not one.

    1. <I think its ok here but I may have missed something. Would appreciate a SANITY check please.">
    2. <Can you please check spreadsheet for any obvious errors.>
    These points are what I think teylyn addressed.

    So it seems that two of the three issues were answered to some extent.

    3. <Is there any way we can devise an arrival date and set that as a president for 12 weekly checks.>
    It would be challenging for a most experts to get to this third aspect if the first and second were not resolved.

    Remember you simply posted your 4 spreadsheets here (with no explanation of the code included) and simply asked us to "Fix them".

    So as far as I can tell, teylyn posts was an attempt to let you know that "perhaps" your current design does not easily lend itself toward getting you to solution #3...



    Author Closing Comment


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now