offline
Last seen: Apr 03, 2014 9:29 AM EDT
Hire Me!
Rate: $30.00 USD/hour
Follow Invite to Project
 

Defining Horizons

Going far and beyond the horizon!

Username: koolsidz

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is not verified.

Location: Pune, India

Member since: September 2009

Reputation:

5.0/5

(139 reviews)

6.1
[see more]

4 users have recommended this freelancer.

  • $550 USD
    5.0
    Profile image for Seller darolutionsl

    darolutionsl

    27 days ago

    Always a pleasure working with Sid. I recommend him anytime.

    Project Description:Create several reports including Cash Position, Bank Reconciliation, Bank Reconciliation Summary, Cash Flow Projections, Summary of Expenses Consolidated etc.
    [more]
  • $310 USD
    5.0
    Profile image for Seller darolutionsl

    darolutionsl

    Mar 8, 2014

    True Most Valuable Professional (MVP). One of the best at what he does.

    Project Description:VBA Programming in Excel
    [more]
  • $360 USD
    5.0
    Profile image for Seller darolutionsl

    darolutionsl

    Mar 4, 2014

    Great job once again! Definitely one of the best freelancers in his area of expertise. Thanks Sid.

    Project Description:Create a database in excel where data can be filtered by Country, Bank Account, Starting and Ending periods, Classification and Minimum value. Branch user will be able to add record, edit recent records and export data that will in turn be imported into the central database at the Headquarter...
    [more]
  • $31 USD
    5.0
    Profile image for Seller svet63

    svet63

    Jan 12, 2014

    Another excellent job by Sid! Definitely amongst the best developers at Freelancer! I will continue working with him whenever the need arises. A+++

    Project Description:Hi Sid. How are you? I need help with a piece of code I'm working on. It is about formatting a cross reference. Have a look at the file attached and let me know if you can do this. Thanks, Svet.
    [more]
  • $250 AUD
    5.0
    Profile image for Seller leonardmax

    leonardmax

    Oct 23, 2013

    I was highly impressed by Sid! Not only was the project completed on time and on budget, he also spent nearly 1 hour on Skype carefully and clearly explaining how to use and modify the system. No hesitation in using again.

    Project Description:I use an Excel Spreadsheet to manage client projects. See attached spreadsheet example. Each line is a different client's project. At various stages of the project process, I need to send letters to my clients...
    [more]
  • $41 SGD
    4.8
    Profile image for Seller wenshun9

    wenshun9

    Oct 8, 2013

    Fast and efficient. Great job. I will hire again. Thanks.

    Project Description:Currently I have a stack of hardcopy survey forms that I need someone to help me transfer the responses to a spreadsheet. There are between 80 forms to be recorded. I am staying in Singapore so I...
    [more]
  • $66 USD
    5.0
    Profile image for Seller jesslm17

    jesslm17

    Oct 1, 2013

    What I love about Koolsidz, is that he stands behind his work. If you looking for someone who can provide quality product, HE IS YOUR MAN!

    Project Description:Problem # 1: Sheet “COGS TOTAL” Yellow Columns A: AN are NOT finding and displaying all the values from the sheet “Cogs Export”. *Please remember the sheet “Cogs Export” will be changing on a monthly basis...
    [more]
  • $220 USD
    5.0
    Profile image for Seller jesslm17

    jesslm17

    Sep 20, 2013

    Easy to work with. Always delivers and offers support if needed.

    Project Description:Creating Vba and excel formula's for a project
    [more]
  • $115 USD
    5.0
    Profile image for Seller jesslm17

    jesslm17

    Sep 17, 2013

    Completed in a timely manner. Very easy to communicate with and very helpful

    Project Description:Project # 1: On the "COGS TOTAL" sheet (Row 27 and below each yellow column), please create a formula that gives a total quantity of cells with data in them. Row 27: A,C,E,G,I,K,M,O,Q,S,U,W,Y,AA,AC,AE,AG,AI,AK,AM...
    [more]
  • $66 USD
    5.0
    Profile image for Seller jesslm17

    jesslm17

    Aug 26, 2013

    Highly recommended

    Project Description:Excel Project # 3- you know :)
    [more]
    Defining Horizons has not completed any projects.
  • $35 USD/hr In Progress

    Each month I export to excel anywhere from 20-30 columns that contain numbers and at the top of each column is a person"s initials. I do this monthly and each month the person"s initials in each column may be in a different column than before or not listed at all.What I am trying to do, is create a formula on another spreadsheet (b) that finds a particular person"s initials and then displays that particular person"s complete column. Please help me! Example:PP DR SB DR01 43 28 7205 22 11 6409 04 99 41

    [more]
  • $150 USD In Progress

    I have an application in vb6 which functioned normally, it automates an operation that I am applying, my problem that I am no longer able to trigger the process because the programmer modify the website and removed the label tag that I had to click it with my application stopped working.What I need, via webbrowser into a website load the captcha he has in one picturebox vb6 and give the option of typing the right captchae log in pagecurrently something prevents you from creating the session, the opinion some measure of security risk restarts my session when I try to enter via a web browser.My basic design and the money is in hand.Interested in doing a job fast contact.I have many other small projects that outsource think if this goes well. thank you

    [more]
  • $35 USD Mar 14, 2014

    I need to have an excel spreedsheet designed.I have the template already, but just need the tabs to calibrate with each other?Please help?

  • $61 USD Mar 14, 2014

    I would like to create an executable file that would install and uninstall this tweak. Please see the attached files

  • $250 USD Mar 13, 2014

    Hello we have a number of Word 2003 macros that prompt the user for text input, then open a specific document from a specific directory (based on the user input) the input the text into the correct position in the word document, then save the document into specific directory. We need to have these macros converted to Word 2010 and 2013.

    [more]
  • $350 USD Feb 26, 2014

    Create a database in excel where data can be filtered by Country, Bank Account, Starting and Ending periods, Classification and Minimum value.Branch user will be able to add record, edit recent records and export data that will in turn be imported into the central database at the Headquarter.Generate various reports from the data in the central database.

    [more]
  • $175 USD Dec 20, 2013

    Ready so far:Main table and home screenInvoice templateCustomers DetailsInventory tableOrder history tableNeed to completeConnect all details such as customer detaails, invoicea, inventory, historyWe should create macros to turn invoice to printing file.The output will be a macro enabled excel sheet that works as POS systemI have attached what was done so far and a macro enabled sheet that is similar to what i want.I need this ASAP (around 24 hours)

    [more]
  • $250 USD Oct 22, 2013

    I use an Excel Spreadsheet to manage client projects. See attached spreadsheet example. Each line is a different client"s project. At various stages of the project process, I need to send letters to my clients. For example, 2 weeks after beginning a particular project for a client, I need to send them a personalised letter (Letter A) informing them of the status of their project. Then a few weeks later, Letter B needs to go out.I want to automate this process so that I can look at my spreadsheet, see the Client X needs to be sent a letter, click on Client X"s cell (or somewhere) which then brings up the merged MS Word document for me to review. This is not a mail merge, per se, because a) I want to open a particular MS Word template from Excel, not Word, and b) I only want to open one client"s letter at a time, not a mass mailing. I"m not sure if this can be set up, though, using mail merge, VBA(?), or bookmarks....So the functions required from within the Excel Spreadsheet are:-Chose which MS Word template to launch-Chose which client (ie. row) I want to merge data from-The MS Word doc that opens is to be named according to data from one of the cells in that row

    [more]
  • ₹1000 INR Oct 5, 2013

    Currently I have a stack of hardcopy survey forms that I need someone to help me transfer the responses to a spreadsheet. There are between 80 forms to be recorded. I am staying in Singapore so I need to pass the stack of forms to the freelancer who is staying in Singapore to do the data entry job. If you are bidding for the project, please suggest any ways that you can do this job if you are not staying in Singapore. Thank you.

    [more]
  • $16 USD/hr Oct 3, 2013

    Need help on VB Scripting for my project. Need help on VB Scripting for my project. Need help on VB Scripting for my project. Need help on VB Scripting for my project.

  • $5 USD/hr Aug 24, 2013

    .kjsdabsjdassadasdasda

  • $20 USD/hr Aug 16, 2013

    I have an existing Excel macro that creates a menu item, allows the user to select a file, calls out to an exe with that file name, and then reads into Excel a csv created by the exe. This does not work for 64-bit Excel and is questionable for 2010. I would like it updated to work for those versions.

    [more]
  • $45 USD Jun 27, 2013

    frankly speaking this is very simple project, bid if you agree to work at my budget "50USD" I need someone write an excel marco script to extract data from my website. person who can deliver in quick will be awarded.

    [more]
  • $67 USD Jun 20, 2013

    I have a Word Document that I want to update:1. I want to have front page with buttons that will send you to different areas in the form.2. Dynamic size of sections - based on a table size in one of the sections, other sections need to be multiplied i.e. if a table has one row than other section will appear once. If there are 3 rows in that table - a bunch of other section in the document/form need to appear 3 times.

    [more]
  • $55 AUD Jun 3, 2013

    I have a spreadsheet to calculate rations for cows. It is very simple. I want to change the sheet so that one spreadsheet holds the reference data and another sheet does the calculations. The reference data can contain 50 or so different feed types. Each ration is made using 7 to 10 feed types. This should be quite simple to build for me. I"ll send you the file I use know for modification.

    [more]
  • $30 USD May 21, 2013

    To tune up my excel vba (in excel 2007) to excel 2013.

  • ₱2000 PHP May 21, 2013

    Excel Expert to create and merge Provide Data for final SSSee final SS we need to show.your final SS must include all records.All fields must be filled out Total amount should be 2.2MM as records showWe will give you access view to an online billing interface where you can download all data neededPayment Amount and Payment date all lv empty and so Write off Balanace shoud be the Billed AmountADJ/CASE/WCAB # -> if you have the field in system you need yo download that into SS for allIf patient does not have DOB or other data - ok. if not show on systemI did some work already and will show youwe need it in 12 hours!Thanks!

    [more]
  • $1500 USD Feb 13, 2013

    This project requires knowledge of the FIX protocol (financial information exchange): http://www.fixprotocol.org. The following link might be useful as well: quickfix.orgThe objective is to develop Visual Basic code (VBA for Microsoft Excel) that would do the following:1) establish a connection to FIX server of a financial trading broker;2) get a list of open positions from the server. Select a particular stock (TICKER) from the list.3) read value of a particular cell in Excel spreadsheet. Positive value denotes BUY order, negative value denotes SELL order4) If the open position for TICKER stock is BUY and the order identified in step 3 is BUY then do nothing. If the open position of stick TICKER is SELL and the order is BUY then submit 2 orders to the server: Order 1. Close Position, Order 2: BUY. Similar process if theopen position is SELL.5) Orders to the server / trading should be started at a given particular time.Deliverables of the project are:1) VBA code2) Instructions on installation of FIX library on a Windows PC. FIX library as available from fixprotocol.org

    [more]
  • $55 USD Jan 2, 2013

    Hello, I am looking out to automate data entered in the Excel sheet . Also need to prepare a dashboard on Excel as well as powerpointLooking out for people who got expertise in Microsft Excel and Presentation.Details will be shared once the bid is awareded

    [more]
  • $30 USD/hr Oct 5, 2012

    Employe me and I will achieve Your oligations as expected.

  • $150 USD Sep 19, 2012

    Create an excel spreadsheet that allows us to enter in a list of specific details from each of our real estate transactions. Have multi tabs for different agents the auto calculate and combins data entered onto page 1 so we can view totals and specific metrics we need to monitor all our transactions. Need to have the ability to handle 500+ transactions on one page and auto calculate info and combine data from all tabs. I dont want to have limited ability to add more transactions and have to adjust the formulas ourselves. The spread sheet eeds to be scalable to handle a high number of transactions. Have the ability to add, edit and remove agent names to drop down menu on the main spreadsheet page. When we add a name a column should auto matically add to the other tabs of the spread sheet where it will then auto calculate the total number of transactions of that agent.

    [more]
  • $56 AUD Aug 23, 2012

    I have an Excel spreadsheet that has been extracted from a database but isn"t sorted into columns.I require someone to move the data into columns like TITLE, FIRST NAME, LAST NAME, EMAIL, WEB etc. In total, there is around 5000 entries.

    [more]
    Defining Horizons does not have any open projects.
    Defining Horizons does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Software Consultant

Sep 2006 - Present (7 years)

Freelance

Excel VBA/Word VBA/Powerpoint VBA/Access VBA/VB6/VB.NET/VSTO Whiz!<br /><br />Other areas of expertise:-<br /><br />* C#<br />* Web Scraping using automation<br />* PDF To Excel

Education

BSC

North-Eastern Hill University

1993-1996

12th

Kendriya Vidyalaya

1992-1993

Certifications

MVP

Microsoft

The MVP Award recognizes exceptional technical community leaders from around the world who voluntarily share their deep, real-world knowledge about Microsoft technologies with others.

Publications

Website

DirectHosts

http://www.siddharthrout.com/<br /><br />A website which is primarily dedicated to Excel Automation from VB.Net.<br /><br />You may think why VB.Net?<br /><br />It's simply because I am a die hard fan of Visual Basic. I love automating Excel from Visual Basic which allows one to perform actions such as creating a new workbook, adding data to the workbook, or creating charts. With Excel and other Microsoft Office applications, virtually all of the actions that you can perform manually through the user interface can