Salary Computation - Xls Download

Hi Seniors
Please help me in preparing the salary structure.
Net pay should be 6000 (PM) and basic should be 3500. Its urgent
Thanks in advance

Dear Narendir,
Basic - 3500
Transport Allowance - 800
special Allowance - 1700
or
Basic - 3500
HRA - 1750
Special Allowance - 750
with thanks,
radhisaran

Narinder,
Before answering ur query u have to be clear whether Net take home is 6000 or Gross..?

Dear Narinder ,
This format I have devised . Hope it might be of some use to you.
Thanks & Regards,
Ashfaque

Dear Seniors ,
Thanks a lot of your appreciation about the format . Every day I update myself with Cite hr.com . I gained a lot from this platform & today i am confident about my performance . Thanks a lot cite hr , Seniors , members for their valuable suggestion & contribution .Any suggestion is appreciable.
With Regards,
Ashfaque

Hi guys !!!!
I am looking out for a change rite now and is interested in changing my industry as well.Pls guide me if you have any sugesstions , as i also want to enroll myself in SAP Professional course which means i will have wait till 3 months.
Waiting for valuable suggestions from you
Regards
Arpita :)