• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

CSAT Dashboard Report using VBA

V

VarunMV

New Member
Good Morning,


In a team, there are 10 candidates (S1,S2,.....S10). Calculation needs to performed on yearly basis (Jan2013....Dec2013)[columns including Goal/Grand Total].


In an excel file, beside S1 to S10 consider alphabets A,B,....J. I will divide these with repect to Group Managers (GM) as GM1,GM2&GM3

GM1 S1toS3, GM2 S4toS6 and GM3 S7toS10. Each candidates will have a productivity of 10, so if we sum those values, will have an answer as '100', convert this to percentage '100%'.


My Goal is to meet 125% productivity. If someone resigns in any month, work/productivity should be distributed equally to remaining without affecting 125%(cannot be less than 125% in any month).


Need VBA code to design above mentioned Csat Dashboard.
 
VarunMV


Firstly, Welcome to the Chandoo.org Forums


I believe it is possible to do this without VBA

Can you post a sample file

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hi Varun ,


This forum does not have a provision for either uploading files or attaching files to posts.


What you can do is to use your preferred file-sharing website ( RapidShare , Hotfile , DropBox , SkyDrive , GoogleDocs , SpeedyShare ... ) to upload your file , give others permission to access and download the file , and then post that access link here , in this same topic.


Narayan
 
Thank you,

I uploaded the workbook using rapidshare portal. Need assistance in writing a coding tip to develop CSAT dashboard report,
 
Hi Varun ,


If you have uploaded your file to RapidShare , give others permission to access / download your file , and then post that access link here , in this same topic.


Narayan
 
Hi Narayan,


I have provided necessary access.


https://rapidshare.com/#myrs_filemanager/file/0


Guidelines are explained in the excel workbook.


Regards,

Varun
 
Hi Varun ,


I am not able to download your file , since I cannot see any link to your file ; the link you have provided just takes me to the home screen of RapidShare ( https://rapidshare.com/#home ).


I do not know why it is so difficult to post an access link ; for instance , I have uploaded a particular file to a file-sharing website such as DropBox , and I get a link such as :


https://www.dropbox.com/s/tufvjloysdp2xuq/MatchFormat_8.xlsx


Anyone who clicks on the above link is immediately taken to a screen from where you can download the file ; it is so straightforward.


Can you try once more , and post a valid access link here ?


Narayan
 
Hi Narayan,


https://www.dropbox.com/home/Dashboard%20Report#!/home/Dashboard%20Report.


VBA code not required. Need to design a dashboard on the value provided in an excel file. Let me know if you have any questions on the same.
 
Hi Varun


I think you are copying link from AddressBar in Dropbox Website..


In Dropbox Website..

If you hav already uploaded your file.. then.. Right Click on the filename > Click ShareLink.

In the pop-up box click GetLink.. It will copy the actual link of the file..

Then paste the link here..
 
Hi VarunMV,


Please place your file in Public Folder of Drop bex and paste its link as Deb said.


Regards,
 
Hi Varun ,


I had posted the detailed instructions for uploading a file to DropBox , and posting the access link in this forum ; I am reproducing the same here :


1. Open your browser , and enter the address http://www.dropbox.com , and let the site load.


2. In the upper right corner , you should see a SIGN IN option. Click on it , enter your email address and password , to sign in.


3. When the site loads , you should see a screen listing all your files which you have uploaded ; above this , you should see several icons , one of which will have an upward arrow , signifying UPLOAD. Click on this.


4. A popup box displays UPLOAD TO DROPBOX , and below that a button which says CHOOSE FILES. Click on this button , and choose the file(s) you wish to upload.


5. When the Upload is completed , you should see the button DONE. Click on this.


6. The screen which was displayed in step 3 above , will re-appear , and you should see the newly uploaded file there. Since the files are displayed in alphabetical order ( unless you have chosen another sort order ) , you may have to scroll down to see your file.


7. Against each file's entry , the right-most column shows the sign of a link ; when you see your file , click on the link symbol against your file. A new window will pop up with the name of your file , and two buttons labelled SEND and GET LINK. If you do not see the GET LINK button , wait till it appears. Click on GET LINK ; the link will be copied to your clipboard.


8. Now , you can use CTRL V to paste the link.


9. In case you do not wish to go through this procedure , you can email me the file at :


narayank1026 [at] gmail [dot] com.


Narayan
 
You must log in or register to reply here.
Back
Top