offline
Last seen: Jul 11, 2014 5:24 AM EDT
Hire Me!
Rate: $8.00 USD/hour
Follow Invite to Project
 

FIBIN K

Excel VBA Programmer

Username: FIBIN

  • 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: Malappuram, India

Member since: April 2011

Reputation:

4.9/5

(54 reviews)

5.5
[see more]

1 user has recommended this freelancer.

My skills:

My projects:

  • €90.00 EUR
    4.6
    Profile image for Seller ferbelgui

    ferbelgui

    21 days ago

    Great job!

    Project Description:I need an small application (Macro) for Excel. It should allow to import data from XML files to Excel spreadsheets. XML files match standard templates and therefore always have the same common structure.
    [more]
  • $90.00 AUD
    4.6
    Profile image for Seller peterobaker

    peterobaker

    Apr 18, 2014

    Good service.

    Project Description:Set up excel spreadsheet based on entry of monthly data to prepare simple reports in table and graph format for month, YTD and MAT comparing year on year with variances and trend data.
    [more]
  • [Sealed]
    5.0
    Profile image for Seller bheegaard

    bheegaard

    Jan 30, 2014

    Fibin did a great job, quickly understood the project and delivered exactly what we needed.

    Project Description:Hi, I need to have our cost calculator updated. It is an Excel sheet that we use in the sales process to show the production costs with our system. We need 1 sheet where the customer can choose between...
    [more]
  • $40.00 USD
    5.0
    Profile image for Seller Oisne

    Oisne

    Nov 14, 2013

    Fibin, got it right first time. Project was delivered without issue. Looking forward to working with him again.

    Project Description:I have student activity completion reports taken from Moodle. I would like % value of where a student(s) are within a course. Please only advanced excel analyst apply.
    [more]
  • $28.00 USD
    5.0
    Profile image for Seller james537

    james537

    Oct 21, 2013

    Great work. Very fast. Put up with all my changes. Very good understanding of project. A real expert!

    Project Description:Formulate text cells in excel spread sheet - Expect a correction or two. Work will be due in *TWO DAYS* EBAY TITLE: Formula for Ebay Title colum: First[H], Finish [I], Tip [J], Hose [K], Bowl...
    [more]
  • $99.00 USD
    5.0
    Profile image for Seller oyamburu

    oyamburu

    Sep 1, 2013

    Second time I work with FIBIN and the experience has been outstanding, his coding experience can turn complex tasks in few days of work. Worth working with him, will consider him as my first option for future projects.

    Project Description:Enhance current Real Estate control workbook as described in the mail previously sent
    [more]
  • $50.00 USD
    5.0
    Profile image for Seller Maikeld

    Maikeld

    Aug 28, 2013

    Good job.......

    Project Description:Dashboard & speed meter budget/actuals
    [more]
  • $55.00 AUD
    5.0
    Profile image for Seller rubz71

    rubz71

    Jul 19, 2013

    Fibin is very professional and get the job done as per the littlest specification. He is very helpful and a pleasure working with. Will work with him again.A+++ freelancer.

    Project Description:The project is about streamline a complex spreadsheet into a simplified excel spreadsheet. In terms with the complexity of the spreadsheet i would rate it 8 outta 10. There are few excel spreadsheet i wanna work with and merge into one master sheet...
    [more]
  • £20.00 GBP
    5.0
    Profile image for Seller nialloleary

    nialloleary

    Jul 12, 2013

    Excellent and prompt work. Excellent communication. Highly recommended.

    Project Description:400 identically formatted excel fives have been used to collect questionnaire data from 400 respondents (data not organised in a row but in the same place in each workbook). These will all be placed in one folder...
    [more]
  • $80.00 USD
    5.0
    Profile image for Seller eloctinar

    eloctinar

    Jun 18, 2013

    FIBIN = Excel Guru, Understood everything really quick, and delivered exactly what i was looking for.FIBIN work hard, on time, on budget I highly recommend him if you need some Excell stuff to be done.Thank you FIBIN, thumbs up!

    Project Description:This project is relatively simple, just a data entry form to perform data entry quick and clean. I need a data entry Form in excel to generate a title for Ebay Auction and populate a csv file from the entry...
    [more]
    FIBIN K has not completed any projects.
  • $35 USD In Progress

    HelloEvery mouth I create an outgoing excel paying report from my CRM.It"s takes about 20 steps to design the file as my requirements. (titles, column row and act"...)I want to create a macro that will create a file with all the steps in one click.the one who will make this project will connect my desktop and i will show him the exact work. very simple i think.this will be one click operation - the app will take the data from the SQL DB (I have the query alredy) and the output will be an excell report.thank you.Nadav

    [more]
  • $8 USD/hr In Progress

    Objective: Program must be able to automatically consolidate specific raw data by pulling it from the master sheet into columns that can refresh the range periodically in a template summary report(using a simple math algorithm). The template must be able to be used to analyze the summary dated to compare to a set data group(also in excel. Needs to be exported if possible to master summarynnThe overall purpose of this program is to cut the time it takes to organize and report sales statistics as a consulting firm. Reference sheet will ultimately be used to make purchase recommendations(contact me to see examples of the finished report compared to the raw data it was pulled from).

    [more]
  • $200 AUD In Progress

    We have a quoting spreadsheet created in-house. This system works reasonably well but very clunky and would like it smoother. We would like to streamline the data entry to the one page, all information can be fed into this page and then run through all connecting cells on each page. Is it easier to use drop down boxes to tick what items we want to input to help with the summary page (as below)We want to then create a summary page which only shows each item used on each page - still in each section but showing materials, hours and machinery. This page will be used as our job costing page so we need the information entered into the spreadsheet as quoted and a column next to it as actual so we can determine profit and loss on each item.Once the spreadsheet is completed we want it to be able to produce a adjustable gantt chart for the timeline of works allowed for in the quote.

    [more]
  • $750 USD 3 days ago

    Compare the data, maintain any data, summery of product

  • $250 USD 12 days ago

    i"d like to create a very advanced excel file using only formulas to analyze a set of data from a set time period over another time period...it would involve vlookups, index/match, time, conditional formatting to name a few....i imagine it being as involved as the dashboard seen here:http://apandre.wordpress.com/tools/excel/dashboards-with-excel/

    [more]
  • kr2222 SEK 12 days ago

    Hi,I have customer data that I would like to have structured in 5 different reports with two different version of each, so in total 10 reports. I want to add data each new month and possible to edit the formulas. Attached you will find my data and the reports that I wish to have created in excel.If you are interested or not, please answer me and give both a time estimate and price.Don"t hesitate to ask if anything is unclear.RegardsMagnus

    [more]
  • $750 USD 16 days ago

    Hello,I need a person who can import 500 excel sheets to Official software.This is easy work. But I need Only serious Freelancer for this work.Fixed Budget $750usdThanks

  • $55 USD 16 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!

    [more]
  • $150 USD Jun 11, 2014

    Need an excel program that allows multiple pilots (about 5) to log hours onto multiple planes or one and display a cost owed by each pilot based on pre-determined hourly costs. Program should show each pilot and what they owe for the calendar year and also a spot for if they have paid in already and deduct from their amount owing. Should be a page for the aircraft that the pilot fills in for pilot name, date, departure aerodrome, destination, number of people onboard, time up/time down, fuel used, pilot license number and signature. Based on this form it should automatically fill in other form. Another sheet will keep track of flown hours and advise when certain routine maintenance is due. Clear as mud?

    [more]
  • $50 USD Jun 11, 2014

    I need to generate a table of all possibilities from an excel workbook file. There is Make, Model, Year, Drivetrain, Wheel Size, Design, and Finish. You choose the options from the drop downs and it gives you a Part number, bolt pattern weight and description.

    [more]
  • $8 USD/hr Apr 5, 2014

    Hello,I am writing a dissertation and I have excel data that I need put into charts/tables. I have all the data, I just need someone to put it into a chart to the specifications that I need. There are maybe 20 charts to complete now. When I get my other survey back, I will need more charts.Thanks,Jennifer

    [more]
  • $150 USD Nov 22, 2013

    See document attached.

  • $40 USD Nov 14, 2013

    I have student activity completion reports taken from Moodle. I would like % value of where a student(s) are within a course.Please only advanced excel analyst apply.

  • $8 USD/hr Nov 14, 2013

    I have started a dynamic file that on selecting the futures ticker it pulls in 10 years historical futures prices from Bloomberg and then computes every combination of price change over the period. The model then allocates a % up and down over the respective period isolating all periods that are up or down more than 7 out of the last 10 years ie 70% The idea is to then present the outcomes either graphically or through conditional formatting where by all the periods are aligned against a Jan-Dec daily date row or column showing the sessional tendency of price to appreciate/decline. I have been using a lot of IF and VLOOKUP which has made the sheet extremely heavy and slow - The framework is there but I need someone to improve the formula logic possibly through VBA to make it more robust and efficient.

    [more]
  • $50 USD Nov 6, 2013

    We currently have an Excel data base of our products and pricing. We need a Quote Sheet template to enter item part number and the template will pull the price and description from the existing Excel data base that we have created.

    [more]
  • $30 USD Jun 5, 2013

    In this exercise, you will teach yourself PowerPivot and create a pivot table using PowerPivot data.Online there are many resources and videos that you can watch but at a high-level, this is what you need to do.1. Install PowerPivot on your computer. You should see the PowerPivot tab in your Excel afterwards.2. Using that new tab, launch PowerPivot and then import the attached two files. The file is tab delimited and contains column headers.3. After importing, create a relationship between the two data sheets.4. Create a pivot table and your screen will go back to Excel.5. In Excel, create a table or graph that summarizes parts of the data.

    [more]
  • ₹5000 INR May 22, 2013

    excel and vb programming for project proforma. the project involves project profitability, pre & post taxes, P&L for a power plant. we need to create a work book. sales people should use it and come up with decisions using this sheet to bid for projects. Please contact me, Madhav Muvvala 9989 04 3335 or email me madhav@icesolar.in

    [more]
  • $75 USD Apr 1, 2013

    Need to create a Dashboard for Managerial AnalysisNeed to create formulas to plot Product Life Cycle for product and product familyNeed basic Business Knowledge and Excel expertise with stat formulas , pivot tables (Nice to have) and Dashboards

    [more]
  • $30 USD Nov 8, 2012

    Hi,I want an excel workbook with macros to show sheets depending on password input.The idea is that when someone opens the workbook it would ask for a password. 15 different people are goint to be working with this workbook, but I want them to be able to see and modify only the sheet associated with their password.I have a very basic knowled of macros, but i want to be able to modify it in case i have to add a sheet later on. I also want to be able to modify the passwords.

    [more]
  • [Sealed] Jun 3, 2012

    Hello!Our company is looking for an individual who is highly skilled in Excel VBA Programming. Some features of the programming required will include the Find function, loops, nested loops and other nested function statements. We have already inputted the data into a macros-enabled Spreadsheet. We just need some help programming how that data will interact with itself. Some of the programming is already done for you, we just need someone to help finish the project. This is a highly proprietary project and due to company policy will require you to sign, scan, and email a Non-Disclosure Agreement before being accepted to work on this project. We would request at least 2 reviews/revisions of the project before funds are transferred. This should be an easy project for someone who is experienced in Excel VBA programming. We want to develop a long term professional relationship with an individual for future projects and further adaptations to the current project. We are offering $100 base pay plus a $25 bonus for completion within 3 days of starting project. There is also another special bonus that will only be discussed with the winning freelancer. We will provide all of the detailed information, which includes the xlsm spreadsheet, ranges, instructions, and calculations to complete this project to the winning freelancer.We look forward to working with you!

    [more]
  • $30 CAD May 9, 2011

    Our accounting department is currently provided GL data in an Excel spreadsheet for multiple locations summarized into daily totals (see sample attached). Each month they need the data in each tab converted to a CSV format to import into their accouting system. Each tab in the Excel spead sheet has specific data extracted and reformated into a CSV file (sample attached)

    [more]
    FIBIN K does not have any open projects.
    FIBIN K does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Senior Software Engineer

Jan 2010 - May 2010 (4 months)

UST - Global

Worked as Senior Software Engineer in UST - Global in Excel VBA coding and Software Testing

Programmer Analyst

Dec 2006 - Jan 2010 (3 years)

Cognizant Technology Solutions

Worked as Programmer analyst working on VBa coding and Software testing

Education

Bachelor of Technology

University of Calicut

2002-2006

MBA

Mahatma Gandhi University

2010-2012

Certifications

Most Valuable Performer Award(Testing Services)

Cognizant Technology Solutions

Got awarded for my performance in CTS Testing Services

CCP in QTP

Cognizant Technology Solutions

Got the certificate Cognizant Certified Professional in Quick Test Pofessional

CCP in Software Testing

Cognizant Technology Solutions

Got the certificate Cognizant Certified Professional in Software Testing

Publications

Nil

Nil

Nil