Download Files uploaded by Hemant Hegde





xlsx File
61 KB

Derivatives - Spread

Hi I made this excel working trying to understand spreads in options. Column A is irrelevant. This is my workings and I don't know if they are correct....

Posted on 26 October 2012  (Downloads: 927) Shares & Stock


xls File
23 KB

Convert Number to Text (Indian style)

As I saw on the internet, many people were searching for some macros and add-ins to convert number to text. But some macros are available but they convert the number to text in "Millons" style. I have prepared this workbook which uses a small table...

Posted on 03 April 2009  (Downloads: 987) Others


xls File
58 KB

Advanced Validation Using macros

Use this macro code to validate data in the Excel Applications you develop (with necessary modifications):)...

Posted on 25 August 2008  (Downloads: 1202) Info Technology


xls File
38 KB

Tax Calculator: Excel

This is a simple excel file. It is not locked. You can change the tax slab rates according to the assessment years. you are also welcome to improve this. mail me @ hemantbalesara@hotmail.com...

Posted on 07 June 2008  (Downloads: 1029) Income Tax


xls File
761 KB

Audit tool?

Hi. Check out these macros. I think they should help in auditing with Tally. If it doesnt work, it should atleast help you to learn Visual Basic and Excel Macros. Try It :)...

Posted on 06 June 2008  (Downloads: 3310) Audit


xlm File
24 KB

Round-off

We get rounding off differences in financial statements in excel format. you can round off them using "=ROUND(#ref,0)" formula. But if u use this excel file youu will just have to press "CTRL+R" selecting the cell containing formula. :)...

Posted on 06 June 2008  (Downloads: 438) Audit


xll File
570 KB

Extrsct Data from Tally - Trial

Extracts data from tally. Prepares the trial balance neatly....

Posted on 02 June 2008  (Downloads: 3507) Accounts