offline
Last seen: Jul 30, 2014 2:05 PM EDT
Hire Me!
Rate: $25.00 USD/hour
Follow Invite to Project
 

Arul AP

IT Professional

Username: deepbluetech

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

Location: Bangalore, India

Member since: July 2012

Reputation:

5.0/5

(224 reviews)

6.4
[see more]

1 user has recommended this freelancer.

My projects:

  • $525.00 USD
    5.0
    Profile image for Seller MikeMoser

    MikeMoser

    8 days ago

    developed a very user friendly solution to our project. I would definitely reccommend him to do macro coding.

    Project Description:I have two excel files that need to be manipulated and combined into a third file. This will be a daily updated file, so the vlookups need to run off a macro that will dump the unnecessary data and just...
    [more]
  • $60.00 USD
    5.0
    Profile image for Seller claudioabitante

    claudioabitante

    15 days ago

    as expected. thanks

    Project Description:usual tasks. please remember: - date of invoice 30 june 2014 - use different template if paid upfront or not (differentiated by 1 or 0) thanks
    [more]
  • $175.00 USD
    5.0
    Profile image for Seller sundialstudios

    sundialstudios

    29 days ago

    This is my 2nd project with Arul and Deepbluetech and I will without hesitation use him for future projects.

    Project Description:Hi Arul - last month you compiled some data for me and created an awesome spreadsheet (https://www.freelancer.com/projects/Data-Entry-Excel/Merge-Organize-Data-Excel-Specs.html) My client is now looking to display this data in formatted tables on his website...
    [more]
  • $125.00 USD
    5.0
    Profile image for Seller samara1

    samara1

    29 days ago

    Excellent Work!

    Project Description:Goal: Excel Macro to automate the process of creating a report from data extracted from two separate source documents. Included: PD Source File.csv PD DOC LIST SOURCE.xlsx PDDATAMAP.xlsx PDOUTPUTTEMPLATE.xlsx...
    [more]
  • $100.00 USD
    5.0
    Profile image for Seller samara1

    samara1

    Jun 27, 2014

    Excellent work yet again!

    Project Description:Included: 1 .xls file and 2 .xlsx files as follows: LOC INS SOURCE.xls LOC SAMPLE OUTPUT.xlsx LOC INS LIST SOURCE.xlsx Take the attached “LOC INS SOURCE.XLS” and manipulate it by doing the following: 1...
    [more]
  • $100.00 USD
    5.0
    Profile image for Seller samara1

    samara1

    Jun 27, 2014

    Excellent Work!

    Project Description:Please apply updates as described via our chat. We look forward to working with you on future projects.
    [more]
  • $75.00 AUD
    5.0
    Profile image for Seller BOFFA

    BOFFA

    Jun 22, 2014

    Brilliant as always !

    Project Description:Create a Pop up Window that shows the cost price results based on a Part number search All raw data is held in another worksheet that the pop up window feeds from
    [more]
  • $60.00 USD
    5.0
    Profile image for Seller claudioabitante

    claudioabitante

    Jun 7, 2014

    great job as always

    Project Description:usual (difference invoice template for paid upfront and not). please use as date of the invoice the 31may 2014. always the same. thanks
    [more]
  • $500.00 USD
    5.0
    Profile image for Seller keryeancheah

    keryeancheah

    May 28, 2014

    High accuracy and well structured output in a rather complex project which involves seiving through a lot of data with many variations and grouping similar or near similar data together.

    Project Description:Requirement: Develop a macro or recommend a solution to find duplicates which may or may not be exact matches (here after referred to as "duplicates") and display duplicates in groups. Characteristics...
    [more]
  • $250.00 USD
    5.0
    Profile image for Seller brianpolarek

    brianpolarek

    May 19, 2014

    Excellent work. Glad I worked with him. Will hire again for sure

    Project Description:Need someone proficient in excel to clean-up, improve a scheduling sheet. Multi-sheet, conditional formatting, drop down, etc
    [more]
    Arul AP has not completed any projects.
  • $25 USD/hr In Progress

    I have ongoing work related to our previous project "Macro and vlookup project"

  • $155 USD In Progress

    I have a running EXCEL spreadsheet that needs to be modified. All formulas must be rechecked and/or modified. I have some items/tabs that need to be added and formulas to go along with it. I don"t have all the raw data therefore the person awarded this project will continue to work with me in the future as the spreadsheet develops into a master tracking system. I would love to have the ability to hide/lock all formulas after they have been establish in order to keep users from editing as well as some professional graphs for quick briefs. Thank you! - Please feel free to ask specific questions! Happy New Year!

    [more]
  • $25 USD/hr Today

    creating a micro cap program in excel that i want to be done also in a website and app.have a very good draft of program already done. need someone full time for again 3 months min

  • $100 AUD Yesterday

    Require some data on a spreadsheet to be emailed to the person on a particular line Eg. 1 2 3 4 5 6 7 person 1 email data1 person 2 email dataperson 3 email dataperson one should receive an email with the 1-7 column with the data1 underneath.person two should receive an email with the 1-7 column with data 2 underneath. Will provide spreadsheet to make a little but clearer.Needed this completed in the next 12 hours.

    [more]
  • $40 USD Yesterday

    We need to find out which store numbers have a trolley type.For example Main Fleet - SA0002, SA004, SA008... (these are the store numbers that have the "main fleet" trolley type")We need a list of the store numbers for each Trolley Type (not all store numbers have all trolley types.).

    [more]
  • kr500 SEK Yesterday

    I need a VBA code that does the following:If data from a drop down menu in cell C1 is VALUE1 then lock CELL A1If data from drop down menu in cell C1 is VALUE 2 then lock CALL B2

  • $30 USD 3 days ago

    Hi! Currently developing an excel sheet application and new some help.1. The value for a range object is dymamic and the cell area stands in a TableA, Cell A3 - how do I have to implement it? Range("Steuereinheit!D83").Select is not working.2. I have X excel tables each containing dynamic content. For a final reporting, I would like to have: Content of Table 1 -- two lines free space Content of Table 2 --- two lines free space etc. The number of tables that are filled is determined in a cell IMPORTANT: Each "Content block" has to be displayed completely on the page - not splitted over 2 pages. In case the content would be splitted, the whole content block shall be put onto the next page.3. There is general statis in which the values for each month are taken. Each each new month, the results shall be put in the next row that is currently not filled.Clear so far? Looking forward to your bids and will award asap.

    [more]
  • $400 CAD 3 days ago

    Excel spreadsheet with 2000 lines of client info (name, address, email, phone number) to be transferred to cloud based accounting app (Wave Accounting).No auto import tool is available.

  • $30 USD 5 days ago

    According to the attached screenshot, we were supposed to be able to enter lots of options like checkboxes, textboxes, radio buttons (when we left-click twice on the cell position of N1), but we are now constrained by row height, and the error message is showing on the screenshot as attached below.The run-time error is "1004". => The Excel file is appended below.Please also see if you could enable copy-and-paste of selected rows this way to another Excel spreadsheet all those options ticked.Rest of functions to remain intact and not tampered with on the Excel fileThe Excel file is appended below.

    [more]
  • $125 USD 5 days ago

    I have an EXCEL spreadsheet that allows you enter costs for a product. Spreadsheet is attached. You should have enough expertise with profit margin calculations and EXCEL to understand the current formulas and what the spreadsheet is doing. If you can"t understand every aspect of the current spreadsheet DON"T BID. I will not answer your questions. You aren"t experienced enough.You must explain in the private message board your understaning of our requirements. If you do not explain what you are REQUIRED to do then how do I know you understand what we need. You also have to explain your expertise with VBA, EXCEL, Macros and GUI DESIGN.In some cases the costs are in two sections. Each section is the related costs for a feature. So there are two features and the related costs. Some products only have one feature and therefore on set of costs.The spreadsheet allows the user to apply different markup percentage rates to the costs to determine what the sales price would be for the product based on the markup values.There are 3 other cost recovery percentage entries that are applied. Profit is calculated and profit margin. Using a discount percentage a reseller price is also determined.An associated business receives a percentage of gross sales. This amount is also calculated based on the sales price.The spreadsheet is setup for 6 markup scenarios that you can see in the spreadsheet all at once. The spreadsheet also has a macro that enable you to hide the scenario(s) you don"t want displayed.The spreadsheet is setup with all the cells visible.The requirements of the project is to use VBA to create a very user friendly, more aesthetically pleasing GUI for non-experienced EXCEL users to enter well labelled data inputs, variables, and a more visually appealing display of results.It looks too complicated with all the spreadsheet cell and data values displaying. It also needs to be user proof so that they can"t accidently delete cell formulas, make an entry in the cell where no entry is permitted and it has to look very professional, an appropriate use of colours to help identify sections, clever ways to hide scenarios the user does not want to see and is very intuitive and easy to use.The other requirement is a reverse calculation. Currently costs and markups are entered to determine a profit margin. We would like to enter costs and desired profit margin to determine all the other values e.g. sales price.100% milestone will not be considered. Lowest bidder will have an advantage in getting the project.

    [more]
  • £50 GBP 5 days ago

    I am looking for somebody with advanced excel skills to organise an excel spreadsheet and briefly explain how you have achieved it.I need the attached document and listed tasks to be completed within an hour today.

    [more]
  • $500 USD 12 days ago

    need 1 excel - vba expert for 1 project to work at our place in bangalore. Duration would be 1 month. sample excel has been attached. it was created last year. this year, it is to be made more intelligent this year. cal 97412 77800. uday1.msn @gmail.com

    [more]
  • $150 USD 12 days ago

    Hi,I want to create an excel sheet that has project management features (I have the template) but also want dashboard and also few other sorting feature including Vlookup formula to extract data.This is not that complex work and anyone with intermediate excel skills along with the VBA skills should be able to do this task.Please do not send bids without attaching your sample work from the past projects.

    [more]
  • [Sealed] 12 days ago

    BASICALLY :- A simple program (on Mac) to take multiple .xlsl files (examples attached) and to strip out one column (a twitter handle), attach a "@" at the start of each, and to pump out the names as .csv files. No usernames to appear twice, so must dedupe and also check against a list of usernames already in existence (BLACKLIST) Needed ASAP (5 days ish). MUST be installed + testedIN MORE DETAIL:to be installed on 2 Mac machines and to do the following:1. IMPORTING DATA:An "IMPORT" button at the top of the data table, will bring up a window allowing selection of several files at a time in the attached xlsx format (there will be only one worksheet per file and the worksheet name may vary so please do not specify a particular worksheet name in the code). Files may contain up to 100,000 records each with sizes up to 40MB. Please show a progress bar with estimated time whilst the following is carried out:a) Check each file to see if it will import successfully (some files may have errors). If there are corrupt files, stop the import and notify the user of the unsuccessful filenames.b) Import "screen name" column and add an @ to the beginning of each entry in this fieldc) Import "location" columnd) Add a third column for "filename" where each record is tagged with the portion of the filename to the left of the first space. Eg. a file named "Blacklist 1.xlsx" would go in as "Blacklist"e) Add a fourth column for "Blacklisted?" with a Y or N value. In the first instance, if the filename column = Blacklist (not case sensitive) this should be a Y, otherwise for newly imported record his should be an N.f) all the other columns are not relevant, so please don"t import them if database will run less efficiently.g) Check "screen name" against records that already exist in the database and delete duplicates. Clarification: - records already existing in the database will take precedence and remain, whilst new incoming duplicates are deleted. - If 2 records with identical screen names are imported at once from separate files, only one instance will remain, matters not which.2. VIEWING + EDITING DATAThe default view in the application should be a table of the data, which can be sorted, filtered + edited in the following way:a) Ability to "clear all" data, with an added "are you sure?" control after pressed.b) Ability to do "contains" search (not case sensitive) at the top of any one of the columns, where if that search is left blank the default will be for all records to appear (subject to the filters on other columns).c) Ability to sort by clicking on the header of any given column.d) and to edit cells3. EXPORTING DATAThe user should be able to specify an export file length to dictate how many records appear in each exported file. The default should be set to 5,000, but the user can change it to whatever they like, then press an EXPORT button with the following result:a) Several csv files of the specified file length would be created and saved to a specified folder.b) They would contain only the "screen name" column (with an @ at the beginning as per the earlier instruction)c) They would be named sequentially according to the filename column, whatever appears in the "location" search field and the file length. Eg if someone had loaded in one file named "Cribs and one named "Bastille", then searched for "london" in the location search and 5000 as a file length, in the search terms, finding 11,000 bastille records and 7,000 for cribs, the resulting files would be:Bastille-london-5000-1Bastille-london-5000-2Bastille-london-5000-3Cribs-london-5000-1Cribs-london-5000-2If nothing is specified in the "location" search field, the resulting files would be named and exported with only the file name and length. Eg.Bastille-5000-1Bastille-5000-2Lastly, every record that is successfully exported in this way would automatically have its "Blacklisted?" column on the database changed to Y.

    [more]
  • £142 GBP 23 days ago

    Hi I have a simple application that I would like built. The idea is it would take a excel file and substitute the text in order to make the content more unique. I have written a spec and attached. I imagine this needs to be a windows programme since it might be resource intensive (well reasonable). Please give me examples of previous project done. I don"t have a big budget for this, it"s a luxury rather than a necessity. thanks Ed

    [more]
  • $100 USD Jun 27, 2014

    Hey everyone,I have an inventory sheet that I need to update daily. I have several excel files that need to talk to each other. Basically I just need a button that will create an "End File" which is just a file that will tell my sales channel what listings need to be removed. I think it is called a macro but I am not sure that is the correct term. Every day I will download the most up to date Products file and Active Listings file, then I will click the button you are creating.3 Workbooks / Files:MasterFile (Contains older inventory items)Products (Contains up to date inventory items)ActiveListings (Contains Listings for Products)Button Actions:a) Finds Item IDs that ARE in MasterFile but NOT in Products (meaning that they are no longer offered by the supplier). The Item IDs need to be added to a list of Item IDs to remove from ActiveListings (let"s call this LIST A), then the row needs to be deleted on the MasterFileb) Adds all Item IDs that have the stock value as "N" within Products file in LIST Ac) Finds all listing#s within ActiveListings sheet, then Creates an "end file" which is a CSV file that has the listing# of products that are out of stockExample:MasterFile File (NOTE - These are the old inventory from the previous day)TITLE, ITEM IDBaseball, 001Basketball, 002SoccerBall, 003Football, 004Products File (NOTE - 001 and 002 are out of stock. 003 is missing, meaning it is discontinued. Row corresponding to 003 needs to be removed from the master file)TITLE, ITEM ID, IN STOCK?Baseball, 001, NBasketball, 002, NFootball, 004, YActiveListings File (NOTE - I currently have 2 active listings for 001 which is out of stock, and 1 listing for 003 which is discontinued)LISTING ID, ITEM IDLISTING#1, 001LISTING#2, 001LISTING#3, 004LISTING#4, 004LISTING#5, 003Created EndFile CSV (NOTE - This CSV file contains which listings need to be removed)ACTION (STATIC), LISTING ID, REASON (STATIC)End, LISTING#1, NotAvailableEnd, LISTING#2, NotAvailableEnd, LISTING#5, NotAvailableThis is the first job of many, so I would love to work with someone who can help me with more macros / buttons / Excel work in the future. If you are interested, please let me know a price estimate and if it is a good price then we can talk further and I can provide more details. If you need clarification, please ask. Thanks!

    [more]
  • $526 USD Jun 25, 2014

    I have 3rd party business data which includes numerous fields such as business name, address, city, state, zip, # of employees, annual sales, amount spent on advertising per year etc. I have a 2nd database that includes our internal sales data including company name, address, city, state, zip, amount purchased. Goal is to compare the two and identify a list of current clients and non clients that can be used for mapping, sales territories etc. Fairly straightforward

    [more]
  • $147 USD Jun 25, 2014

    I need to convert the way an Excel spreadsheet reads. I need a simple way to change how my Excel export reads.

  • €147 EUR Jun 24, 2014

    For a client I have to manage a transfer from one CRM system to another.Attached are:- example of export files- example of file format to be deliveredThis will be tested with few records.Afterwards we will make merge of full database (+/- 3500 ctcs)URGENT PROJECT !!!

    [more]
  • ₹9000 INR May 17, 2014

    i am responsible to u despatched work hradwork and also submitted

  • ₹600 INR Apr 17, 2014

    any type of work can be entertained .willing to work in any condition but i should get get money.mere paisey marne nhi chaiye.

  • $800 USD Mar 13, 2014

    SCOPE DESCRIPTION:To automate a personal organizer, with content and structure provided in the form or a Word document, that will:•Allow users to fill in multiple sets of auto-generating forms. The auto-generation refers to adding additional fields for new names, addresses, etc. as blank ones are filled. Approx 13 forms.•Auto populate fields in letters, call lists, and a tracking timeline. Approx. 5 letters.•Complete a checklist as fields are populated. One list.•Scan in and file documents and images to be included in print out packages.•Print to PDF or to a printer auto-populated letters with a set of attachments including forms and scanned documents.•Generate email reminders.DELIVERABLES:The project shall provide:•One master program where the text contents of the organizer and letters can be edited.oFunctional changes to the organizer will be completed as Additional Services request to programmer.•Ability to produce an un-editable organizer for publishing.•Instruction manual or tutorial on use of the organizer as the master administrator.PROJECT TIMELINE:Approximately 1 week

    [more]
    Arul AP does not have any open projects.
    Arul AP does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Freelancer

Oct 2006 - Oct 2012 (6 years)

vWorker.com

Completed more than 150 projects on vWorker related to VB 6,Excel VB Macros, Excel, Access, Word, Powerpoint & Office data Management

Education

Bachelor of Technology, Electronics & Communication

Jawaharlal Nehru Vishvavidyalaya

1996-1999

Certifications

Certificate in Advanced Networking & Security

Indian Institute of Technology, Kharagpur

Certificate in Business Management

Indian Institute of Management, Ahmedabad

2012 - 2013

Publications

Excel Expert

MS Excel

Experienced Excel VBA coder.