Create Dials and Speedometer Scorecard #download, #exceldashboards, #excel, #tools, #samples, #templates,


#

In this article we will take an Excel source containing scorecard information and convert into dials and speedometer charts.

We will also create few bar trending charts.

Consider the below sample data

Source File: You can download the excel file here

The above excel file tracks few metrics such as safety, quality and revenue. This is just a sample data and may not make sense in actual world but just imagine a manufacturing company that wants to track its overall safety and quality score and also track its total revenue. Now the company may use its own method at deriving the individual safety and quality scores.

They may have a dedicated team to collect safety violations and product defects and then use some formulae to convert those data into final score for any given month. We are not concerned with any of the methods on how those scores are generated. You are the dashboard person and the company has provided you the metrics by each month and now your job is produce a nice dashboard that shows relevant charts for the given data.

Since the data is tracked for each month, it makes sense to show a line or bar chart trending for the metrics.

Dials and Speedometers are relevant when we need to show performance of a single value. So in this case, since we have 12 month data, how do we show single value on the meter chart?

One solution is to show an Average value for the safety and Quality metrics or we could show a dial that shows the current month values.

So the GOAL for this exercise is: Show bar chart for Safety trending 12 months and show average and current month value on the dial chart.

Dial chart requirement: For the dial chart, we are measuring the performance, whether we are on track or missed the goal. In order to achieve that, we create three new columns for safety such as safety_bad , safety_ok , safety_good . These values need to be decided by the company management. If you are not sure, then look at previous year data and decide what should be good and bad values. The dials are used to guide the company to perform better or atleast improve that portion of the company operation represented by the metric.

First let us create the date hierarchy columns from the Period column. You need to make sure that the Period column is an actual Excel date column, else the hierarchy will not be generated

You may click on the color icon to change the colors of your choice

Next, we select the range boundary values

The safety_bad value from our spreadsheet represents the lower boundary of our bad region, safety_ok represents the upper boundary of our bad region, similarly safety_ok is the lower bound for our ok region and so on. For the Good upper bound we simply typed a value but as general practice we should have one more column for the upper bound of the final region. In our case the final region is Safety Good .

Next, for the pointer value, select the column that you want to show on the dial chart. In our case we select Safety and aggregation as Avg

Next, we click on Create chart . This action shows the dialog below

We change the chart title to Average Safety

NOTE: remove the double quotes in the SQL statement for the group by. This will cause an error.

Click on Fully Apply

Here is our final Dial Chart

Next, create a dial chart to show current month value

We will change some conditions on the main Qlet. Right click on the Name and select Duplicate

It creates an exact copy of the qlet table. We change the name to Current Month

Right click on the Period column and select Create – Create Date Filter

This action shows a dialog as shown below

First change the operator to Between

Next select First Day of Month for the from and Last Day of Month for the To val.

Click on Use This Filter

This action applies the filter to the Qlet and it shows only currrent month row

Next, right click on Current Month and select Create Chart

All of the settings remain the same except the Aggregation , make sure to select NONE


06/10/2017

Posted In: NEWS

Tags: , , , , , , , , , , , , , , , ,

Leave a Comment

Taskbar Pinned Programs – Enable or Disable – Windows 7 Help


#

Windows 7: Taskbar Pinned Programs – Enable or Disable

This will allow you to enable and disable the ability for specific or all users to pin a program to the taskbar, and allow or prevent pinned programs from being shown on the taskbar for all users in Windows 7. Pin to Taskbar and pinned programs is enable by default in Windows 7.

Using a REG File Download

1.To Enable Taskbar Pinned Programs forOnly Current User A) Click on the Download button below to download the file below. Enable_Taskbar_Pinned_Programs.reg

B) Go to step 3.
2.To Disable Taskbar Pinned Programs forOnly Current User A) Click on the Download button below to download the file below. Disable_Taskbar_Pinned_Programs.reg

3. Click on Save. and save the .reg file to the desktop.

4. Right click on the downloaded .reg file and click on Merge.

5. Click on Run. Yes. Yes. and OK when prompted.

6. When done, you can delete the downloaded .reg file if you like.

7. Log off and log on, or restart the computer to apply.

Through the Local Group Policy Editor

1. Open the all users . specific users or groups . or all users except administratorsLocal Group Policy Editor for how you want this policy applied.

2. In the left pane, click on to expand User Configuration. Administrative Templates. and Start Menu and Taskbar. (See screenshot below)
3. In the right pane, right click on Remove pinned programs from the taskbar and click on Edit. (See screenshot above)

4. To Enable Taskbar Pinned Programs A) Select (dot) either Not Configured or Disabled. (See screenshot below step 6)

8. Log off and log on, or restart the computer to apply.
That’s it,
Shawn

Hello Crossnet, and welcome to Seven Forums.

If you mean that you do not have the Pin to taskbar option in the context menu, then this is usually caused by using a XP method to remove the shortcut arrow icon instead of the proper Vista and Windows 7 method. If this may be the case, then try restoring the default shortcut arrow overlay icon using either method in the tutorial below, then see if you have the Pin to taskbar option afterwards.

Hope this helps,
Shawn

Computer type PC/Desktop
System Manufacturer/Model Number Self built custom
OS 64-bit Windows 10 Pro
CPU Intel i7-3930K 3.2 Ghz (O/C 4 Ghz)
Motherboard ASRock X79 Extreme11
Memory 32 GB (4x8GB) G.SKILL DDR3 Quad PC3-19200 2400MHz
Graphics Card MSI N760 TF 4GB5/OC GTX 760 4GB
Sound Card SB Recon 3Di Integrated Chip
Monitor(s) Displays 3 x 27 Asus VE278Q
Screen Resolution 1920×1080

Keyboard Logitech wireless K800
Mouse Logitech MX Master
PSU OCZ Series Gold OCZZ1000M 1000W
Case Corsair Air 740
Cooling Corsair Hydro H115i
Hard Drives 256GB OCZ Vector 6TB WD Black WD6001FZWX
Internet Speed 300 Mb/s Download and 30 Mb/s Upload
Antivirus Malwarebyte Anti-Malware Premium
Browser IE11
Other Info Creative F200 webcam * Lite-On iHBS212 12x BD Writer * Samsung CLX-3175FW Printer * Linksys EA9500 Router * Arris SB6190 Cable Modem * APC SMART-UPS RT 1000 XL

Thanx for the answer. Yes, i remove the shortcut arrow icon. But i do that since i installed windows 7 for the first time about six month ago. and there is no problem with taskbar pin. But now, suddenly the taskbar pin is disappear from my windows 7 taskbar and it can’t to enable/show again.

and also i don’t have the Pin to taskbar option in the context menu

OS Windows 7
CPU INTEL DUAL CORE E5500 2.8GHz
Motherboard FOXCONN G41MX-K
Memory VISIPRO DDR2 1GBX2 PC6400
Graphics Card ONBOARD
Sound Card ONBOARD
Monitor(s) Displays LG LCD 17 (L177WSB)
Screen Resolution 1440 X 900

Keyboard STANDARD
Mouse OPTIC STANDARD
PSU STANDARD (CASING BUILT-IN) 450W
Case ADVANCE
Cooling STANDARD (INTEL PROCESSOR HEATSHINK)
Hard Drives SEAGATE BARACUDA SATA 250GB 7200RPM

As a test, go ahead and restore the shortcut arrow using the tutorial link above to see if that restores your pin to taskbar option. If it does, then you can use the same tutorial to remove the shortcut arrow.

If you removed the shortcut arrow using one of these all-in-one type tune-up/customize programs, then be sure that you do not still have it set to not have a shortcut arrow.

Computer type PC/Desktop
System Manufacturer/Model Number Self built custom
OS 64-bit Windows 10 Pro
CPU Intel i7-3930K 3.2 Ghz (O/C 4 Ghz)
Motherboard ASRock X79 Extreme11
Memory 32 GB (4x8GB) G.SKILL DDR3 Quad PC3-19200 2400MHz
Graphics Card MSI N760 TF 4GB5/OC GTX 760 4GB
Sound Card SB Recon 3Di Integrated Chip
Monitor(s) Displays 3 x 27 Asus VE278Q
Screen Resolution 1920×1080

Keyboard Logitech wireless K800
Mouse Logitech MX Master
PSU OCZ Series Gold OCZZ1000M 1000W
Case Corsair Air 740
Cooling Corsair Hydro H115i
Hard Drives 256GB OCZ Vector 6TB WD Black WD6001FZWX
Internet Speed 300 Mb/s Download and 30 Mb/s Upload
Antivirus Malwarebyte Anti-Malware Premium
Browser IE11
Other Info Creative F200 webcam * Lite-On iHBS212 12x BD Writer * Samsung CLX-3175FW Printer * Linksys EA9500 Router * Arris SB6190 Cable Modem * APC SMART-UPS RT 1000 XL

Moving pinned programs to the right of the taskbar
Hello, Hopefully i’m posting at the right section. But I wanted to know if it is possible to make your pinned programs be at the right of the taskbar. So lets say you open a new program right now it comes to the right of the pinned programs right? Is it possible to move the pinned programs.

Taskbar – Separate Pinned Programs
How to Sort Pinned Programs into Categories on the Taskbar This is similar to how to pin folders to the taskbar, but my own ‘tweaked’ way of doing it with programs Example: Here is my version of the program sorting: Update- You can do this to make Shutdown/Restart buttons as well.

Programs pinned to taskbar, loose their Icon
I have Windows 7 RC installed on two different computers and this has happened on both. I’ll install a program I use a lot, pin it to the taskbar and some of the icons will lose their original icon after awhile. It doesn’t seem to effect the operation of the program or the shortcut to the.

Can’t Switch Programs On Screen Via Programs Pinned to Taskbar
An example: I open Firefox full-screen. If I try to switch to Outlook, which is open and showing in the taskbar, it wont let me. I am forced to minimize Firefox Same thing happens when Outlook is full screen.

Odd problem with pinned programs on taskbar
I seem to be having a problem with the pinned programs on my taskbar and I was wondering if anybody can help me here. Most of the programs on my taskbar simply highlight the icon that I clicked when I want to start the program or start a new instance of the program. However, a select few programs.

Problem with right click on programs pinned to taskbar.
Hello. I hope I’m in the good section for my post. When I right click on Windows Media Player on the taskbar, the recent files and task lists appears, but don’t work. when I click on a file or a task, nothing happen :(. However, it worked at the beginning (just after Windows installation).


01/10/2017

Posted In: NEWS

Tags: , , , , , , , , , , , , , , , , , ,

Leave a Comment

CRM (Customer Relationship Management) Tutorials #sap,abap,tips,tutorials,adobe #forms, #adobe #interactive #forms


#

SAP CRM (Customer Relationship Management)

  • Web Services and Document Templates in CRM
    • Creating Web Services in CRM (More details )
    • Creating Document Templates using Web Services in CRM (More details)
    • Transporting Web Services in CRM (More details )
    • Transporting Document Templates in CRM (More details )
  • Creation of WEB UI Component and navigation with standard component (More details )
  • Advanced Search Component for OneOrder Objects in SAP CRM 7.0 Part 1 (More details )
  • Advanced Search Component for OneOrder Objects in SAP CRM 7.0 Part 2 ( More details )
  • Adding custom fields using Application Enhancement Tool (AET) (More details )
  • Adding new text types in SAP CRM (More details )
  • Print duplicate service ticket form in CRM (More details )
  • Innovative Method to Print Service Ticket Directly in CRM (More details )
  • Creating a Dropdown in SAP CRM WebUI (More details )
  • Creating OCA(On Click Action) in SAP CRM WebUI (More details )
  • Creating a button in CRM WEB UI (More details )
  • Creating a custom field and display it in table view (More details ) NEW
  • How to Show User and System Name on top of Web UI Page (More details ) NEW
  • Creating an OVP (Overview Page) with Assignment Blocks, displaying table data based on input given (More details ) NEW
  • Steps for Adding Widgets on WEB UI Home Page (More details ) NEW

Few more tutorials related to CRM:

  • Migrating Customer data along with relationships (CRM) using LSMW (More details )
  • Configuration of CRM 7.0 Server with PI 7.0 (More details )
  • Action Profiles in SAP-CRM (More details )
  • Creation and configuration of Business Partners (More details )
  • Adding Web URL (like google.com, yahoo.com) in CRM UI (More details )
  • Configurations for opening an external URL (like SAP.COM) from IC WebClient. (More details)
  • Difference between EEWB and BDT (More details)

© 2006-2007 SAPTechnical.COM. All rights reserved.

All product names are trademarks of their respective companies. SAPTechnical.COM is in no way affiliated with SAP AG.
SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver, and and any other SAP trademarks are registered trademarks of SAP AG in Germany and in several other countries.
Every effort is made to ensure content integrity. Use information on this site at your own risk.


29/09/2017

Posted In: NEWS

Tags: , , , , , ,

Leave a Comment

Home Based Travel Agent Resources – Video Tutorials, Articles, More #travel

#home based travel agent
#

Home Based Travel Agent Resources

Google has all the answers out there for you (somewhere), but wouldn t it be nice if there was a site that linked to resources for those looking to become a home based travel agent?  I thought so too!

We ve got two sets of readers here:

  • Experienced travel agents  I know just the thing for you.  Check out our calendar of industry events and make sure to read our education and marketing articles  to help you grow your home based travel agency even more!
  • New travel agents   If you re looking to become a home based travel agent, you came to the right place!  You ll find our travel agent basics  (there are multiple pages so make sure to click the older entries button!) will give you the big picture on how things work a super important foundation.  After that, we ve got a host agency list (with over 600 agent reviews) for you to peruse.  Speaking of

Four Steps to Finding the Perfect Host Travel Agency

We ve helped a LOT of home based travel agents find a host agency.  We also answer a lot of the same questions because, as it turns out, most new home based travel agents feel confused, frustrated, and unsure of where to start or how to find a good host agency!

If that s you, this video guides you through the questions you need to be asking yourself in order to narrow down your host agency options.  You ll also want to check out the Finding the Best Host Agency article for some more tips.

And after watching the video, we ve created a spreadsheet to help you compare host agencies.  You can download it below:

Home Based Travel Agent Newsletter Popular Articles





05/08/2017

Posted In: NEWS

Tags: , , , , , , , , ,

Leave a Comment

MBA Projects #mba #projects, #android #projects, #reports, #examples, #source #code, #basics,


#

MBA Projects

Download All MBA Final Year Projects, Project Reports, B School Projects, Business Project Abstracts, MBA Papers, MBA Presentations. Final Year mba students can find mba projects on finance, MBA Projects on banking, MBA Projects on marketing with project reports and abstracts for free download.

Total Quality Management is a new mantra in ever organization. It is defined involvement of all the employees in organization towards achieving quality product on a continual improvement basis. The present study was conducted in a cement industry in Hyderabad Viz. Maha Cements, Hyderabad. For collecting the data and input. One of the quality philosophy( )

Introduction In this chapter a brief overview of the background of the study is given. The readers will also find the research aim, objectives and the research question with which the present research is carried out. Limitations of the study were also given before ending up this chapter with the structure of the dissertation. Research( )

1) What is your Name and Designation? Ans: Krish. Sales Associate. 2) How many years of experience you have in 4 wheeler sales Service? Ans: 2 Years. 3) From how long you are associated with Car Dealer Outlet? Ans: 1 Year. 4) What do you think of Attention paid by Management on feed back( )

ABSTRACT Employee Motivation is essentially about commitment to doing something. In the context of a business, motivation can be said to be about “The will to work”. Motivation is an internal drive that activates behavior and gives its direction. The word motivation is coined from the Latin word “movere”, which means to move. The term( )

The title assigned is” THE ANALYSIS OF MUTUAL FUNDS WRT EQUITY FUNDS” with reference to “STOCK BROCKING COMPANY.” The study focuses on different mutual fund schemes and how these schemes are influencing on the company profitability and Turnover. The main motive of this Analysis of Mutual Funds wrt Equity Funds project is to analyze how( )

MBA PROJECTS: 1000 Projects supports students of different universities to complete their project requirements (summer projects, internships, assignments) on time. We provide all the information regarding the project report works whatever necessary. We have a separate team for giving full assistance to MBA students. We have tie ups with many companies and we provide live( )

Find the below provided all MBA Finance Final Year Projects Titles. Students who are interested to buy these projects online we will provide abstracts, synopsis, guide certificate and full documentation. Finance Topic Name: Equity analysis with reference to Cement sector A study on Two agriculturl commodites with ref. to Sugar Wheat Agricultural insurance in India Comparative( )

Employee Motivation MBA Project consisted of finding out that factor which motivates the employees the most. The most appropriate means to ascertain such information was to conduct a motivation survey. The research undertaken was a descriptive research as it sought to describe the characteristics of a small sample of employees with regards to what motivated( )

MBA Project on Dividend Policy: Investment Decision with regard to long term assets is called capital budgeting. Decision with regard to short term or current assets is called working capital management. Dividend Decision A firm distributes all profits or retain them or distribute a portion and retain the balance with it. Which course should be( )

Customer Perception MBA Project Overview: The respondents are of HYUNDAI and they came know about the service from hoardings, print media, primarily and through electronic media and road shows secondarily. The respondents are using HYUNDAI since 1 year and below 1 year in most of the cases. The service provided by HYUNDAI is used by( )


02/08/2017

Posted In: NEWS

Tags: , , , , , , , , , , ,

Leave a Comment

Home Based Travel Agent Resources – Video Tutorials, Articles, More #travel

#home based travel agent
#

Home Based Travel Agent Resources

Google has all the answers out there for you (somewhere), but wouldn t it be nice if there was a site that linked to resources for those looking to become a home based travel agent?  I thought so too!

We ve got two sets of readers here:

  • Experienced travel agents  I know just the thing for you.  Check out our calendar of industry events and make sure to read our education and marketing articles  to help you grow your home based travel agency even more!
  • New travel agents   If you re looking to become a home based travel agent, you came to the right place!  You ll find our travel agent basics  (there are multiple pages so make sure to click the older entries button!) will give you the big picture on how things work a super important foundation.  After that, we ve got a host agency list (with over 600 agent reviews) for you to peruse.  Speaking of

Four Steps to Finding the Perfect Host Travel Agency

We ve helped a LOT of home based travel agents find a host agency.  We also answer a lot of the same questions because, as it turns out, most new home based travel agents feel confused, frustrated, and unsure of where to start or how to find a good host agency!

If that s you, this video guides you through the questions you need to be asking yourself in order to narrow down your host agency options.  You ll also want to check out the Finding the Best Host Agency article for some more tips.

And after watching the video, we ve created a spreadsheet to help you compare host agencies.  You can download it below:

Home Based Travel Agent Newsletter Popular Articles





15/06/2017

Posted In: NEWS

Tags: , , , , , , , , ,

Leave a Comment

Home Based Travel Agent Resources – Video Tutorials, Articles, More #flight

#home based travel agent
#

Home Based Travel Agent Resources

Google has all the answers out there for you (somewhere), but wouldn t it be nice if there was a site that linked to resources for those looking to become a home based travel agent?  I thought so too!

We ve got two sets of readers here:

  • Experienced travel agents  I know just the thing for you.  Check out our calendar of industry events and make sure to read our education and marketing articles  to help you grow your home based travel agency even more!
  • New travel agents   If you re looking to become a home based travel agent, you came to the right place!  You ll find our travel agent basics  (there are multiple pages so make sure to click the older entries button!) will give you the big picture on how things work a super important foundation.  After that, we ve got a host agency list (with over 600 agent reviews) for you to peruse.  Speaking of

Four Steps to Finding the Perfect Host Travel Agency

We ve helped a LOT of home based travel agents find a host agency.  We also answer a lot of the same questions because, as it turns out, most new home based travel agents feel confused, frustrated, and unsure of where to start or how to find a good host agency!

If that s you, this video guides you through the questions you need to be asking yourself in order to narrow down your host agency options.  You ll also want to check out the Finding the Best Host Agency article for some more tips.

And after watching the video, we ve created a spreadsheet to help you compare host agencies.  You can download it below:

Home Based Travel Agent Newsletter Popular Articles





11/05/2017

Posted In: NEWS

Tags: , , , , , , , , ,

Leave a Comment