Top_Banner

Showing posts with label Do-it Yourself. Show all posts
Showing posts with label Do-it Yourself. Show all posts

November 20, 2018

How Digital Invitation, E-greeting Can Ease Your Pain

With ever increasing use of smartphones, many traditional things are fading too fast. It is changing the way we interact with our friends and family. It has made it simple to send interactive messages through social media apps using emoticons, smileys, stickers etc. It can be used to send digital greetings and invitation cards as well.  

Send a customised Digital video invitation card 
Physical invitation cards not only involves printing costs, but also need considerable time and efforts to get them delivered to the intended recipient. SMS, e-mails or even directly speaking to the person are the common alternatives to invite for a weekend party or small family function. 


Sending digital invitations is yet another option available on smartphones. It is very simple to create a digital card using MS Paint or create one-page  slide in  powerpoint. Save it as an image and post it at social media profile page or send it to a select group or recipients as using facebook, whatsapp, twitter etc. 

Also see : Print Large Posters and Banners on Standard A4 printer
Video Greetings : Do-it Yourself !!
It is easy to choose from a list of 'Standard' templates as per a specific occasion and make a customisation. Use your creativity and thoughts to put thins in place as per your requirements.
     It is So! simple and easy to do it !!

Free version creates a watermark on the video invitations. However, if you don't want it you need to a little bit more. Once you are done with the video animation, play it to preview and use any screen capture utility to capture the full screen video and export it on local computer. if required do further video editing with 'photos' utility in windows 10.


August 7, 2018

Advanced Google search for free stuff and downloads . . .

Search music, videos, e-books and apks using Google Operators 

It is quiet easy to find any type of files using a advanced of google operators, in an iterative  manner with minor tweaking in syntax using different combination of operators and keywords to get desired. A simple syntax  goes like this :

      -inurl:(htm|html|php) intitle:"index.of"+"filetype"+"topic"

Just substitute <filetype> with a single or multiple file types such as (mp3|wma|mp4|mpeg) or maybe (pdf|doc|txt) etc. and also the <topic> with the main context of your query like book title, song, album name, game, apk  name etc.

Some more examples :

This query searches for music files related to singer [Rahman].  
      -inurl:(htm|html|php) intitle:"index.of"+(wma|mp3) Rahman

Here you can find some helpful pdf files for english grammar.
      -inurl:(htm|html|php) intitle:"index.of"+(pdf) English Grammar


Refer below link, if you aant to read more about operators :
http://www.googleguide.com/advanced_operators_reference.html#allinurl

Download pdf files using Library Genesis

This search engine provides a ebook downloads in multiple formats. Just type the book title in search bar and it would provides a list of entries related to the book title.

June 3, 2018

House, Plot or Property 'facing' Direction using Online compass

How to get a 'facing' direction for a House Property

Although I am not a vaastu expert or an architect by profession, but It is very clear that direction plays a very prominent role while choosing a rental house, or buying a new house, plot or business property.  Lets answer a too basic or even silly question :  
               Which direction are we talking about . .??
The direction of the house or the ‘facing’ of the house, is the direction you face, while coming out of the house or property. 


The best entry or 'facing' direction is North-East, followed by North-West, East, North and West.  
However, It can just be used as a thumb rule to shortlist a specific site. Keep in mind, there are many other parameters as well that influence overall vaastu compliance of a site or property. It is not easy or a Do-it yourself task to a decision for properties that are irregular in shape, having tilled directions, tapered boundary walls, rounded corners and facing other directions. It is  advised to consult a vastu expert to have a comprehensive site assessment that would take care of each and every aspect related to a house or plot property.  Since I've gone too far in a foreign territory, Lets get back to a more specific context about [ How to identify a 'facing' direction of a property ]. 

Also Read : Auto-updated Equity Stocks Portfolio in Google Sheets

How to get an accurate Direction of 'facing' of Property 





Setcompass.com  is a Google Maps tool for the plotting and recording of compass bearings, distances and magnetic declination or variation for single or multiple Google Map routes.

It can be used to measure a 'facing' direction for any house, plot or building using google Maps. Please see the video for a step-by-step instructions :



Also Read : Use Xpath query to fetch data from a Webpage 

May 2, 2018

Print Large Posters and Banners on standard A4 printers



Sometimes, it is required to print large banners or posters at home or office, in addition to the small offices who does not have a suitable printer.  There may be multiple reasons for such one time or once a while requirement for events such as birthday party, conference, seminar, workshop, directions, artwork, wall paintings and of course, educational  classroom posters for your kid's school assignments.  Last one is actually more relevant for me.

Standard A4 printers are too common at workplace or home than A3 or oversized printers. Large printers are used for some dedicated requirements and hard to find, even in  small office and companies. Unless you are not looking for a 'professional quality' prints, It is easy and cheaper way getting large prints on standard printer without any extra hardware.
Here are some ways to get large print with standard A4 printers.

How it works ??
Nothing too tricky or hi-fi, It is just based on simple idea to print a Large image into 'Multiple A4 segments' and post-processing to combine them together to make a bigger print.

Method-1  Using MS Paint for printing Image Files.                       

It is a simple method if you are printing from photos or image file formats.



Method-2  Using blackposters.com for Large Image Printing.                       

It is just similar to MS Paint method, but has a better user interface . Final output is provided as a multiple pages PDF file as per inputs parameters. However, It also creates a watermark 'created using [BLOCK POSTERS]' at lower right corner, when using free service.


Method-3 Print Large Poster and Banners using Adobe Reader



 
If you have a pdf document or drawing that no need to look for anything.  










April 30, 2018

How to Display a Custom alert message in Google Sheet



Use this code in [Google Script Editor] to display a simple  user alert . It can also be used with formula calculations to check for invalid or blank cell values in a google spreadsheet.  

function SimpleAlert() 
{
  var ui = SpreadsheetApp.getUi(); 
  ui.alert('Write your Text Message Here');
  
 };
















December 29, 2017

NX Conversion of Units for Parts and assemblies ( Metric to Inches or Vice-versa)

NX has a command line interface (CLI) Utility program for unit conversion in part and assemblies. [ug_convert_part.exe] is available under %UGII_ROOT_DIR% folder that fullymeets all user intents to convert units for a single part, assembly or all part in a folder or sub-folders. There is no other way to do it through GUI. Although, it may be a bit tedious for some but not too complex or technical.


To start doiing it, just navigate to [NX Tools] folder path as shown and Run [Command Prompt].  It would directly change  directory to UGII root and you can simply type the command name.



Type, [ug_convert_part.exe]  and hit enter.  Syntax options are displayed  on screen just above the command  line.



Syntax for convestion from Metric [mm] to Inches [in] is highlighted in the image below. 


After conversion is done, you can check file properties in NX application.



Syntax for Unit conversion of complete assembly including child parts at once. Unit for all part in assembly will change to in/mm with a warning message for the parts that are already in same units.




December 6, 2017

Rectification Request u/s 154(1) for Tax mismatch Only [ITR-1 Income from Salary (More than one employer)].


Abstract : 

TDS on Salary as deducted by three employers (due to Transfer Posting) during previous year, didn't exactly matched with ITR-1 claims for AY 2017-18. Although, Tax was deducted by the two previous employers and same is correctly shown in Form 26AS, but I didn't mention it correctly in my return. I forget to fill TDS details for previous employers and therefore,  tax deducted by them was not considered while processing the return. Tax demand is raised against the income with previous two employers.  It falls under 'apparent mistake in records' as tax is already deducted but not claimed in return. 

I filed a 'Rectification request for Tax mismatch Only' without changing any other data in my original return.


An e-mail from Income Tax CPC is Too Scary, isn't it !!
Nothing less than a nightmare to see a new email from '@cpc.gov.in' in your inbox. Its hard to push down an unusual feeling of discomfort and nervousness that spontaneously runs through whole body, even though it might be a 'Normal' or confirmation message. Filling annual tax return is one of the tedious and awful tasks for me as well as most of us who are salaried employees. Nobody would ever want to see it again until next assessment.

This year, I too received an 'Intimation U/S 143(1)' for AY2017-18, showing a TDS mismatch under two sub-sections that eventually led to a demand for Net tax payable at Sr. no.-52. These are :
1. Interest Payable     ( Sr. no  33-36)
2. Pre-paid Taxes        ( Sr. no  38-42)

Its a bit tricky and cumbersome to calculate/verify an interest mismatch and even I don't care about it.  However, Item 2 could be related to a clerical error or invalid entries  or apparant mistakes while filing an income tax return. 

What mistakes Rectification Request ?


A rectification request under section 154(1) is allowed by the Income Tax Department for correcting mistakes when there is an apparent mistake in your Income Tax Return.

Under this section, you can rectify clerical, arithmetical mistakes, a mismatch in tax payments, inclusion of income chargeable under an incorrect heading, and even changes in your resident status. Further, there must be confirmation that the mistake is apparent from the records and it is not a mistake that requires debate, elaboration, investigation, etc.. 

What went wrong ?

I had been transfered two times during previous year. Form 26AS  clearly shows the details of tax deducted by all three employers alongwith other deductions. This details must match with records uploaded in income tax return. However, I forget to mention these important details such as TAN number, Name, Amount paid and Tax deducted by two previous employers. 

What to do if there is Mismatch in ITR1 with Form 26AS ?

Scenario-1
It makes sense to pay net amount against Demand Identification No (DIN), if Tax mismatch is only due to interest payable or you agree to the Tax demand. 
In both cases, just pay the tax and relax.

Scenario-2

In case you find some error in the calculation sheet or mistakes apparent in records, you can file a rectification request online or should consult a qualified CA or good tax expert for further action. 

Given below is a manual from Income Tax official website, howeve it lacks some screenshot during the process and checking status after request submittion.
http://incometaxindiaefiling.gov.in/eFiling/Portal/StaticPDF/Rectifcation_Manual.pdf
Rectification request can be raised after ITR is processed and intimation U/s 143(1) or order under section 154 is recieved by the taxpayer. Request for efiled return can be only be submitted online.




Step-by-Step process to raise a rectification request : 

Step-1 Log-in with your E-Filing credentials at Income Tax  eFiling website.

Step-2 Navigate to Menu item  e-File >  Rectification as shown below: 



Step-3 Enter PAN, Income Tax Returns , Assessment Year and CRN**  



**Communication Reference Number is avialable in intimation U/S 143(1).



Step-4 Select Rectification Request Type > 



Option -1_ Taxpayer is  Correcting Data for Tax Credit mismatch only

Select this option if you tax mismatch is due to a mistakes in TDS on Salary or Other than Salary and Self Assessement Tax (SAT) details. Here, you can add additional details for previous employers if forget to mention in return. 

'IT Details' check-box  is provided for correcttion in BSR code, Serial number of Challan , Date and amount of Tax deposit.

Option -2_ Taxpayer is  Correcting Data for Rectification

Tax payers can raise a request for rectification in data under specific schedules after selecting an appropriate reason from a given list of 22 items as applicable to in your case. 

In that case, tax payer has to select a reason from amon the listed 22 items, as well as needs to upload a revised xml file with selected schedule for data rectification.



Next, you need to select upload a select 'Schedules to be changed' and Upload a revised xml file. 



Option-3.  ‘No further Data Correction required. Reprocess the case’.

Lets get back to our original topic of Tax mismatch due to incorrect or mistakes in TDS filiing.

Step-5 Enter new data to correct mismatch.
Always keep in mind the following important points given in 'Intimation U/S 143(1) while entering data in the rectification request :
"Please note, before filing for rectification, cross check the tax credits information furnished by you with the Form 26AS."
"Please note that while filing rectification application all details of tax payments of that schedule have to be filled (including those which have also been already matched and allowed). As the new data overwrites the earlier data, any omission of tax payment data will result in disallowance of that of tax payment which is not entered. Kindly ensure that the claims are correct and appear in Form 26AS."




Step-6 Submit request and confirm 'OK' to the warning message.


Step-7 Confirmation email with Rectification request Receipt would be sent to registered email Id.



Step-8 Checking status for Rectification request.
Navigate to My Account > View e-Filed Returns/Forms > Rectification Returns in drop down menu > Submit.



Step-9 
Taxpayer has option to witdraw rectification request within 3 days after submittion, if some incorrect information has been submitted. It is given on the rectification status page.





Rectification Order U/S 154 is sent to tax payers through email as well as a hard copy delivered at their communication address after it is processed by income tax dept.

Do not panic, to see an email with subject line that reads as "Intimation U/S 154 for PAN ARTxxxxx1M AY:2017-18" . 


Tax demand/Refund is generated after the consideration of rectification as sent earlier.  Refund will get credited to your account however, if there is a tax demand than you need to pay it as advised.