offline
Last seen: Apr 02, 2014 3:27 PM EDT
Hire Me!
Rate: $12.00 USD/hour
Follow Invite to Project
 

Sirius Services

Excel/VBA and Data Processing

Username: vserv

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

Location: Visakhapatnam, India

Member since: September 2009

Reputation:

5.0/5

(109 reviews)

6.1
[see more]

1 user has recommended this freelancer.

My projects:

  • $111 AUD
    4.0
    Profile image for Seller klektik

    klektik

    Aug 28, 2013

    work completed as required.

    Project Description:Complete provided Excel file to allow entered values to be compared with data in a provided table range. Full details are provided in attached zip or provided link. This is a short timeline, quick delivery project...
    [more]
  • $239.5 USD
    5.0
    Profile image for Seller srajagop

    srajagop

    Aug 5, 2013

    vserv was outstanding. This was an excel programming project that was different from anything he had done earlier. But he was flexible and did whatever was necessary and the program was delivered ahead of schedule (within a couple of weeks of the start date) and works beautifully. I simply forgot to notify on Freelancer that the project was completed. I have not had another similar programming project yet. Would definitely use him again and strongly recommend him!<br/>

    Project Description:This project will require prior experience in using VB macros for Excel. This project requires writing Visual Basic Code to implement a production planning algorithm. Information from a couple of different worksheets in Excel needs to be compiled and sorted using some criteria...
    [more]
  • $166 USD
    5.0
    Profile image for Seller rajdhillon

    rajdhillon

    Jun 12, 2013

    Very friendly and easy to work with. Provided expert advice on project, as well as how to make processes easier. Will definitely work with again in the future.

    Project Description:[This is a Private Project. You must be logged in to view the Project Description]
    [more]
  • $638 USD
    5.0
    Profile image for Seller omegasea21

    omegasea21

    Jun 2, 2013

    Perfect, as always, thank you!

    Project Description:Hi Guatam, would you be interested in doing more Excel analysis similar to the work you&#039;ve done for us before? I&#039;ve attached the new files. Please let me know. Thanks, Stuart
    [more]
  • $50 AUD
    5.0
    Profile image for Seller edsinnovations

    edsinnovations

    May 31, 2013

    No stress, no fuss, no worries..another project well done!

    Project Description:Hi There, You may recall a spreadsheet that you completed for me recently. I require some changes to be made to it. I have listed the changes on a separate sheet in the worksheet. can you let me know what...
    [more]
  • $35 USD
    5.0
    Profile image for Seller brianbam

    brianbam

    Apr 14, 2013

    He complete this project very fast and the excel sheet works great! I would definitely recommend him.

    Project Description:I have an excel sheet that uses a drop down menu in column D to select an account name. Once the account name is select then the adjacent cell (column D) looks up the appropriate distribution from another worksheet...
    [more]
  • $60 USD
    5.0
    Profile image for Seller pedrosasl

    pedrosasl

    Mar 17, 2013

    excellent freelancer

    Project Description:I need a script that will implement the following simple algorithm for editing cells in an Excel spreadsheet: 1. For all blue cells (i.e. cells with a blue background color) that have a non-blue cell...
    [more]
  • $60 AUD
    5.0
    Profile image for Seller edsinnovations

    edsinnovations

    Feb 1, 2013

    Without doubt completed the project over and beyond what I expected. would have no hesitation in hiring again..

    Project Description:I have an excel worksheet that has data that i want to transfer from one worksheet to another with &quot;buttons&quot; I have attached a sample worksheet for you to look over...
    [more]
  • $581 USD
    5.0
    Profile image for Seller omegasea21

    omegasea21

    Feb 1, 2013

    Went the extra mile and took ownership of the job. thank you!

    Project Description:[This is a Private Project. You must be logged in to view the Project Description]
    [more]
  • $50 USD
    5.0
    Profile image for Seller pglaeser

    pglaeser

    Jan 28, 2013

    Great freelancer - would use again!

    Project Description:I&#039;d like a macro that will auto format data per the attached SAMPLE file. The number of ACT, PEND, or CLOSD lines is variable.
    [more]
    Sirius Services has not completed any projects.
  • $60 USD In Progress

    I need a excel or Imacros script that will go to www.teletextholidays.co.uk and insert a date, duration etc and once the site responds with what is available the info is scrapped and then sort by predefined criteria to give info on who has the lowest price for each hotel and what that price is

    [more]
  • $40 USD Mar 3, 2014

    I find out that you have done this task (https://www.freelancer.ca/projects/Data-Entry-Excel/Obtaining-Data-from-Crunchbase-com.html) before.Besides the requirement like this task, I need to get email and categories of each company. I am willing to pay $40. Please let me know if you accept this task.Regards,Jack

    [more]
  • $10 USD/hr Aug 15, 2013

    Hi Vserv,nnIve got a project for you if your interested, its quire simple ive got a list of domains and there links in an excel workbooks.nnWhat i want to do is have a workbook called results and find all the common links to between the other workbooks, nnie. if workbook 1 has a link from google.com and so does workbook 2, and workbook 3 then i want to list that in the results workbook, nnIve attached some sample data below, aswell as the way the results workbook should be set out nn-- nnif you got any question just let me know, thanks

    [more]
  • $35 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&quot;ll send you the file I use know for modification.

    [more]
  • $30 USD May 10, 2013

    Hi Gautam, I trust you have been keeping well. I have attached a project I will need to discuss with you via skype. I will send a follow-up pdf which highlights the sort table I am trying to achieve.let&quot;s discuss.Looking forward to working with you again, best regards, Ian Smith

    [more]
  • $30 USD Feb 23, 2011

    Hi,I need an excel sheet that will read all the files from a given folder (and sub-folders too).The developed workbook should be able to create a list with the contents of the selected folder (an index).Thank you!

    [more]
  • $250 USD Jan 20, 2011

    This project utilizes Excel spreadsheets in both tab delineated files and comma separated values. The goal of this project will be to restructure the data from the base spreadsheets to the formats required as given in the examples read sheet for upload to an e-commerce website. The winning bidder should be familiar with basic HTML metadata tag structuring, Excel databases, CSV, tab delineated Excel spreadsheets, SQL databases, e-commerce terminology and have a strong grasp of the English language. This project has the possibility of continuing into other projects that also could utilize a skill set that was able to extract or data mine PDF documents and restart restructured data into CSV or tab delimited Excel database including product options (3rd spreadsheet in example files). In the given example are two items, labeled data feed 090810.csv and sample. Item 1 is a sample database, sample to is the sample and results. Ideally this would be achieved via the use of a macro that would be provided as a deliverable of the project. Also the project will require that&quot;s the images for the items in the database be placed into an FTP folder and send back to us for reformatting, and the image ID placed in the final spreadsheet.

    [more]
  • $250 USD Apr 4, 2010

    Display a form that puts the information in an Excel spreadsheet.Within this form is a Stopwatch or timer with functions such as &quot;Start, Stop, Reset&quot;Every 15 seconds of the minute would flash when the timer is running.Select from a popup calendar that puts that date in a cell.Select from dropdown lists.When a value is selected from a dropdown list additional cells are populated from another spreadsheet. Such as when a ID is selected the description is displayed in another cell.Form could be saved and printed as needed.

    [more]
  • [Sealed] Mar 31, 2010

    Transfer Microsoft word form into Excel.Add VBA to add form functionalityMicrosoft Word form to Microsoft ExcelApply input simplification where practicalApply data validation and input checking where possibleAdd loggingAutomatically copy text entered into Section 1 to corresponding fields in Appendix.Automatically add revision date in Section 1Add “add row” button where practicalApply simple conditional formatting to a single fieldApply conditional formatting if box is checked and no comment is added Copy and paste summaries automaticallyCalculate days until date specified and flag if date has passed&#8232;Details are outlined in the attached specifications form.Start date: Now !Finish: A.S.A.P. or before April 10Work must be supplied : 1) daily updates and in-progress VBA and Excel must be provided 2) final form in Excel to be supplied upon completion.&#8232;Payment to be made promptly. 25% payment after 50% of the work semi-operational&#8232;Remainder 75% to be paid promptly upon successful working form supplied in Excel form.&#8232;

    [more]
  • $750 USD Feb 13, 2010

    We want to extract data from websiteProducts catalogues including title, picture, description, price and optionsWe give website URL (we have a potential for around 20-50 sitesWe will give multiple website, so the amount will be 100$ per siteThanksJJ NINI

    [more]
    Sirius Services does not have any open projects.
    Sirius Services does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Manager

Dec 2000 - Dec 2003 (3 years)

A data processing company

Work of the company involved processing data taken from brochures and followed by populating databases

Education

M.Tech

Indian Institute of Technology, Delhi

1980-1982

Certifications

Project Management Professional

Project Managment Institute

Certification in Project Management skills

Publications

Proceedings of ICASSP

IEEE

Article on an adaptive algorithm for Signal Processing