+ Reply to Thread
Results 1 to 7 of 7

Dashboard workbook

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    110

    Dashboard workbook

    Hello, some one asked me to upload this workbook, so here it is.

    All respect goes out to https://www.excelforum.com/ and its users for providing the formulas needed for the dashboard.
    Special thanks to Jonmo1 , FDibbins, sandy666, AlKey, shg and Andy Pope .


    Name:  7.0 Classie template.png
Views: 35
Size:  143.4 KB
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    110

    Re: Dashboard workbook

    This was designed for a display dashboard. If one needs to print it, one will need to take a picture of the dashboard and use a paint software like https://www.getpaint.net and invert the colors. So, basically what that gonna do is make it from black and white to white and black.

    In order to look like this (picture down below)
    step 1 take a picture of the display (PrtScn button)
    step 2 past it in ( ctrl + v)
    step 3 invert the colors
    step 4 adjust the white level
    step 5 squeeze the image size

    Name:  IMG_1717 (1).jpg
Views: 30
Size:  1.52 MB
    Last edited by sovietchild; 04-13-2017 at 01:13 PM.

  3. #3
    Forum Expert
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    5,087

    Re: Dashboard workbook

    Thank you for the upload. That is a really cool dashboard!
    Dave

  4. #4
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    76

    Re: Dashboard workbook

    sovietchild, Many thanks for uploading your work that supports your dashboard. Will be studying it to learn some new techniques.

  5. #5
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    110

    Re: Dashboard workbook

    In order to look like this (picture down below)
    step 1 take a picture of the display (PrtScn button)
    step 2 past it in ( ctrl + v)
    step 3 invert the colors
    step 4 adjust the white levels
    step 5 squeeze the image size

    Name:  IMG_1717 (1).jpg
Views: 30
Size:  1.52 MB
    Last edited by sovietchild; 04-13-2017 at 01:12 PM.

  6. #6
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    110

    Re: Dashboard workbook

    Here is a simple dashboard if anyone wants it.

    Name:  Untitled.png
Views: 30
Size:  86.1 KB
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    110

    Re: Dashboard workbook

    Simple concept. (imitated from google images search through dashboards)

    Name:  CONSEPT.png
Views: 27
Size:  36.2 KB
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1