Create Summary Report in Excel Using PivotTable and PivotChart

PIVOT Table Excel can help you by recommending and then automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data. Make sure your data has column headings or table headers, and that there are no blank rows. Scenario : Create a line chart from the available data of a school where the performance of all students are available in excel sheet.  This will enable the school head to measure the department wise performance  and also the overall performance. Task 1: Create %ge performance of each department with category 1-5 View the complete video tutorial here in Youtube.   select the data range by highlighting rows and columns of the data and press OK Drag the columns as shown above Right click on any row -> Show Value as -> % of Row Total Click on any row and click Pivot chart as shown below.   Download the sample excel data file from here.      .

» Read more

Solar Powered Weather Station using Arduino and BME280

Requirement : Developing a solar powered weather station which will monitor Temperature. Pressure, Humidity and Altitude from Sea Level. Parts Required Arduino Uno LCD BM280 (https://www.sparkfun.com/products/13676) 10k ohm potentiometer (optional) Power Bank with Solar Panel   Parts images: LCD Potentiometer (To adjust brightness) Arduino Uno Powerbank with Solar Panel Connection Details :     BME280 — Connection  Connect 3.3V of BME 280  to 3.3V of Arduino. Connect GND of BME 280 to ground of Arduino. Connect the SCK pin of BME 280 to Digital #13 of Arduino. Connect the SDO pin  of BME 280 to Digital #12 of Arduino. Connect the SDI pin of BME 280 to Digital #11 of Arduino. Connect the CS pin  of BME 280 Digital #10 of Arduino. LCD Connection  LCD RS pin to digital pin 9 LCD Enable pin to digital pin 8 LCD D4 pin to digital pin 5 LCD D5 pin to digital pin 4 LCD D6 pin to digital pin 3 LCD D7 pin to digital pin 2 Connect potentiometer only if you need to adjust brightness. if not please connect the pin V0 to GND Library Required: Download BME280 Library and copy to Adrduino library folder from this link : https://github.com/sparkfun/SparkFun_BME280_Arduino_Library Download the zip file , extract to a […]

» Read more

How to Display Line Numbers in the Editor Visual Studio 2013

Line numbers aren’t added to your code; t hey’re just for reference. If you want line numbers to print, in the Print dialog box, select the Include line numbers check box. To display line numbers in code On the menu bar, choose Tools, Options. Expand the Text Editor node, and then select either the node for the language you are using, or All Languages to turn on line numbers in all languages. Or you can type line number in the Quick Launch box .

» Read more

Finding a Port which is already in use : Windows

Scenario: You want to find out a port which is used by another application. Step1: Open Command Prompt in elevated mode Step 2 : Enter following command : netstat -aon | findstr :80 This command is to find application which s using port 80. The command will show the process id of the application. Note that you will see the process id. Current case process id is : 3428 Step 3 : Open Windows Task Manager – > View -> Select Columns –> Click PID –> OK Step 4 : Open Process , Sort by Process ID, Select the desired process , Click End Process Tree   Select the Process which shows PID you found above , then right click End Process Tree This will close the application which is running on specified port.          .

» Read more

Batch creation of Batch PDF file from Multiple jpg files – Step By Step

Task : I want to create PDF files of 1000 students records. Each student record have 2 pages. Each page is named in the following format IDNUMBER_PageNo.jpg Example of one students : 20151101234.jpg 20151101234_001.jpg These are the records of one students scanned as jpg. The task is make them as pdf file with a file name : 20151101234.pdf Note that , I have 1000 student records with 2000 jpg files. I have to make 1000 PDF files out of these 2000 jpg files. Tools Required : Microsoft Excel Open Source Software : imagemagic Free Download : http://www.imagemagick.org/script/binary-releases.php For 64 Bit , Windows 7 , I downloaded this Version => http://www.imagemagick.org/download/binaries/ImageMagick-6.9.2-0-Q16-x64-dll.exe Theory: Using ImageMagick if you wish to combine multiple jpeg and create single pdf , then you should use following command convert file1.jpg file2.jpg file3.jpg file.pdf Steps Involved : Create a folder and put all jpg files inside it. Extract the file names , paste to Excel Sheet Create a batch script in the format required by Imagemagick Install Imagemagick Software and Test Enjooooooy Step1 : Create a folder in c Drive as Haneef and paste all the files there Step2 Open Command Prompt cd c:\haneef dir *.* /b >> haneef.txt This will create a […]

» Read more

Java Issue with Chrome Browser 42 and above in Bank Websites with Tokens

After the new upgrade of Chrome browser many Bank websites (Like Axis Bank) where Java Token used will not work unless you make following settings. If your site requires Java plugin , chrome will not support unless you enable the NAPI plugin manually. Enabling NPAPI in Chrome Version 42 and later As of Chrome Version 42, an additional configuration step is required to continue using NPAPI plugins. In your URL bar, enter: chrome://flags/#enable-npapi Click the Enable link for the Enable NPAPI configuration option. Click the Relaunch button that now appears at the bottom of the configuration page. If you still face issues , please leave me a comment . ********* More info on this issue: How do I use Java with the Google Chrome browser? This article applies to: Browser(s) Chrome Java version(s): 7.0, 8.0 NPAPI support by Chrome The Java plug-in for web browsers relies on the cross platform plugin architecture NPAPI, which has long been, and currently is, supported by all major web browsers. Google announced in September 2013 plans to remove NPAPI support from Chrome by “the end of 2014”, thus effectively dropping support for Silverlight, Java, Facebook Video and other similar NPAPI based plugins. Recently, Google […]

» Read more

Controlling LCD from Push Button Using Arduino

Parts Required : Resistors 1 K Ohm (1 No)   220 Ohm resistor – 1no Potentiometer 10K Arduino Uno Board     LC Display Push Button Switch   Circuit Diagram Arduino Code: // By Haneefputtur.com // LCD RS pin to digital pin 12 // LCD Enable pin to digital pin 11 // LCD D4 pin to digital pin 5 // LCD D5 pin to digital pin 4 // LCD D6 pin to digital pin 3 // LCD D7 pin to digital pin 2 // LCD Anode Pin to Analog Pin A4 // Push Button to digital Pin 8 #include <LiquidCrystal.h> #define LCD_LIGHT_PIN A4 const int buttonPin = 8; LiquidCrystal lcd(12, 11, 5, 4, 3, 2); int buttonState = 0; void setup() { // Setup the number of columns and rows that are available on the LCD. lcd.begin(16, 2); lcd.noDisplay(); // Set the button pin as an input. pinMode(buttonPin, INPUT); // Set the LCD display backlight pin as an output. pinMode(LCD_LIGHT_PIN, OUTPUT); // Turn off the LCD backlight. digitalWrite(LCD_LIGHT_PIN, LOW); } void loop() { buttonState = digitalRead(buttonPin); if (buttonState == HIGH) { // Print some text to the LCD. lcd.clear(); lcd.setCursor(0, 0); lcd.print(“Haneef Puttur.com”); // Turn the backlight on. digitalWrite(LCD_LIGHT_PIN, HIGH); […]

» Read more

Install IIS on Windows Server 2012 by using the UI – Classic ASP

Install IIS on Windows Server 2012 by using the UI On the Start page, click the Server Manager tile, and then click OK. In Server Manager, select Dashboard, and click Add roles and features. In the Add Roles and Features Wizard, on the Before You Begin page, click Next. On the Select Installation Type page, select Role-based or Feature-based Installation and click Next On the Select Destination Server page, select Select a server from the server pool, select your server, and click Next. On the Select Server Roles page, select Web Server (IIS), and then click Next. On the Select Features page, note the preselected features that are installed by default, and then select the following additional role services: ASP ISAPI Extensions Click Next. On the Web Server Role (IIS) page, click Next. On the Select Role Services page, note the preselected role services that are installed by default, and then click Next. noteNote You only have to install the IIS 8 default role services for a static-content web server. On the Confirm Installation Selections page, confirm your selections, and then click Install. On the Installation Progress page, confirm that your installation of the Web Server (IIS) role and required […]

» Read more

CV Writing Tips

Page 1: This is the most important page so it almost 60% of vital information about the candidate that helps him/her ‘sell’ themselves to the employer should be on this page with these sections. Check Objective Statement on CV. Should be ideally 3 lines long with a detail on education, no of years’ experience and skills / areas of interest. It’s a good idea to put the email, contact number on the header of the document, so that it shows on all pages. Key Skills Section – should come after the objective statement. Include core work related skills first, then people skills (leadership, team player) Work experience section – should always be in chronological order, with the current/last position mentioned first. Month and Year should be mentioned clearly with the position and company name. Work experience section – if the candidate has been promoted within the company, include a designation chronology. Employers are interested in ‘career highlights’ – what is your proudest achievement in your company. Mention these ‘highlights’ in points, quantified like “improved production by 20%”, “tripled the output” etc. Mention job responsibilities in no more than 4-5 points. PAGE 2 – For more experienced professionals this page will […]

» Read more

Installing SSL on Etherpad

Step1 : Convert SSL certificate to PEM format from pfx; openssl pkcs12 -in orginal.pfx -out cle.pem -nodes Step2: update /opt/etherpad/etherpad140/etherpad-lite/setting.json “ssl” : { “key” : “/opt/etherpad/etherpad140/ssl/cle.pem”, “cert” : “/opt/etherpad/etherpad140/ssl/cle.pem”, “passphrase” : “xxourpfxpasswordxx“, },   Credits : Shaju.

» Read more
1 2 3 4 32