Last seen: Jul 22, 2014 3:11 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



(224 reviews)

[see more]

1 user has recommended this freelancer.

My projects:

  • $350.00 USD
    Profile image for Seller MikeMoser



    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...
  • $60.00 USD
    Profile image for Seller claudioabitante


    7 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
  • $175.00 USD
    Profile image for Seller sundialstudios


    21 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 ( My client is now looking to display this data in formatted tables on his website...
  • $125.00 USD
    Profile image for Seller samara1


    21 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...
  • $100.00 USD
    Profile image for Seller samara1


    24 days ago

    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...
  • $100.00 USD
    Profile image for Seller samara1


    25 days ago

    Excellent Work!

    Project Description:Please apply updates as described via our chat. We look forward to working with you on future projects.
  • $75.00 AUD
    Profile image for Seller 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
  • $60.00 USD
    Profile image for Seller 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
  • $500.00 USD
    Profile image for Seller 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...
  • $250.00 USD
    Profile image for Seller 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
    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!

  • $500 USD 4 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

  • $150 USD 4 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.

  • [Sealed] 4 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.

  • £142 GBP 15 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

  • $100 USD 24 days ago

    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!

  • $526 USD 27 days ago

    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

  • $147 USD 27 days ago

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

  • €147 EUR 27 days ago

    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 !!!

  • $50 USD 28 days ago

    I need a vb program in excel made that will calculate many formulas and create a cvs file from all the sizes that I give it.Here is what the output file looks like

  • $147 USD Jun 21, 2014

    A Summary worksheet to read from unspecified number of excel worksheets/workbooks (number changes monthly). The summary will need to index/match the specified month to return data from the corresponding row in each worksheet (may be different rows in each worksheet)

  • $150 NZD Jun 16, 2014

    We have 5 badminton courts in each courts are playing 4 people every 15 min.The members are 30 divided in a,b,c,d grade what i need is a software that can mixed the people playing.The condition are:a,b grade can play together and c with d

  • ₹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

  • $155 USD Feb 20, 2014

    We have a datasheet with 15000 records. We need to add data to new columns we have created. We need a VBA form created so we can easily navigate to the next row of data, show existing data, and add data to the new columns. The new columns will be populated using either listdown on the form or option buttonsHere is very example of what we need:We have sheet with...Image Name Sizec:/Img1.jpg james 55c:/Img2.jpg sam 57c:/img3.jpg George 45we wantImage Name Size New Colourc:/img1.jpg james 55 1 Redc:/img2,jpg sam 57 0 Bluec:/img3.jpg George 45 1 RedSo new would be added on form using checkbox or option button and Colour would be added using listboxWe need about 200 option buttons and listboxes created (about 200 new columns). Data for listboxes will be in neighbouring sheet. IMPORTANT: each row has an image and we need the image displayed on the form. images are about 500-800 pixels

  • RM80 MYR Feb 18, 2014

    1.need to measure overall projects, by campaign performance, by staffs2.combined previous months performance, can do max few months analysis staff is measured by penetration rate % and $anp/leads and etc.

  • $200 AUD Feb 12, 2014

    Hi there,I have raw data in an excel file. I need someones help in creating reports (using Pivot Tables and Charts) from the raw data.

  • $200 USD Feb 11, 2014

    I have a large and complex excel worksheet that relies heavily on ranges, offsets, reference cells, formulas, worksheets, buttons and more. I need an expert with VBA and excel to make some upgrades and fixes to the worksheet project. Currently calculations only work with type "labor adjustment" for the product section of the worksheet. The worksheet calculates consolidated GP%, cost, labor and quite a few other items in a project summary, prints a budget, takes input from stations and enters onto a tab of worksheet. You must be able to work with ranges, modules, dialogs in VBA code. Statements may be similar to ActiveCell.offset(0, 26).Formula = yadayada. Mainly some logic must be corrected, additions and upgrades must be made to the project. You will be adding items to the project summary, adding references to an OID tab from within initial worksheet (station). Also, budget created by worksheet code must output in a specific format, print set up to landscape to output details of project. Budget must be autopopulated correctly. A great deal of the functionality is already in place; however, it must be fixed.

  • $222 USD Feb 4, 2014

    A programmed excel worksheet that will capture services sold by operators and also customized run daily accounting

  • $150 USD Jan 30, 2014

    Hi deepbluetech, I noticed your profile and would like to offer you my project. Please review the project description and we can discuss any details.

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


[see more]




Oct 2006 - Oct 2012 (6 years)

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


Bachelor of Technology, Electronics & Communication

Jawaharlal Nehru Vishvavidyalaya



Certificate in Advanced Networking & Security

Indian Institute of Technology, Kharagpur

Certificate in Business Management

Indian Institute of Management, Ahmedabad

2012 - 2013


Excel Expert

MS Excel

Experienced Excel VBA coder.