login sign up

online
Online now
Hire Me!
Rate: $15.00 USD/hour
Follow Invite to Project
 

oFAZo

A VB6/VBScript/VBA expert, MS Access & MS Excel wizard, MS SQL expert & C++ enthusiast

Username: oFAZo

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

Location: Gurgaon, India India

Member since: January 2009

Reputation:

4.1

(20 reviews)

4.8
[see more]

My projects:

  • $45 USD
    5.0
    Profile image for Seller zoomonkey

    zoomonkey Australia

    8 days ago

    Excellent Freelancer. Great code and excellent communication. Will hire again.

    oFAZo's reply:

    Thanks! The experience was mutual :)

    Project Description: I have a sheet of data, which is in many rows across various columns. What I need a macro to do is loop though the data and copy (not move) prices from the data over to the column to the right for the data they relate to...
    [more]
  • $500 USD
    1.0
    Profile image for Seller balloons11

    balloons11 Canada

    Apr 29, 2012

    He is a thief. He does not do the work. Then waits and opens a dispute and steals money from you. He is owed nothing and should be banned from Freelancer. He has now stolen from us twice.This person has stolen from us twice. This dispute was closed last year when we did not even see the e-mail. He did not complete the work. He disappeared and then opens a dispute months later. Now a second time he was been allowed to open another dispute and steal from us again. When will this stop. How can freelancer let him do it twice. This project was done when he disputed it last year. How can you let him dispute it twice and steel from us twice.

    oFAZo's reply:

    I have submitted the completed project to the client, he keeps changing the requirement and Ive submitted two changes. My earlier feedbacks say differently about me & my work. Please ignore this feedback from this client. Thanks!

    Project Description: We need a program which will automatically e-mail customers that continue to owe us money and e-mail customers who have chosen an option on our website called pass along to remind them to fax us their billing information or to call us...
    [more]
  • $150 USD
    0.0
    Profile image for Seller ekariuki

    ekariuki United States[ Incomplete Report ]

    Apr 11, 2011

    Probably a good developer but did not complete the project communication could have been better. Thanks for the effort though.

    Project Description: I am looking for an MS ACCESS expert who is very good with working on Reports. I have a spread Sheet that I would like to move into an Access Database. Please open the attached file (Load Planner.xls) The database in the attachment is for example purposes to get you started......
    [more]
  • $35 USD
    5.0
    Profile image for Seller wcbruton

    wcbruton United States

    Apr 5, 2011

    Excellent service. Faz is very professional, efficient, and provides great communication. I will use him again and recommend his services to anyone.

    Project Description: I need a custom formula created for MS Excel, compatible with 2007 and newer. This formula will determine total material usage based on the following: 1. Material units are 10' sticks. The returned value will be in number of units...
    [more]
  • $50 USD
    4.4
    Profile image for Seller BinCode

    BinCode United Arab Emirates

    Jul 12, 2010

    Good Service Provider.Tries all possible ways to get the work done.

    Project Description: Dear All, I need an Outlook Macro that will format the new email, replies,forwards etc to the specified font (Verdana 10)with 1.5 Line spacing.But the macro should not affect the font and style of the signature of the users account...
    [more]
  • $651 USD
    5.0
    Profile image for Seller balloons11

    balloons11 Canada

    Jun 30, 2010

    FAZ worked on this project for us and quickly completed what turned out to be a much more difficult project than expected with ease and within a very short period of time. We would work with FAZ again in the future.Thanks.

    Project Description: Hello, When we require a customer to call us it is typically for only a few reasons. We are fed up of copying a pasting information from our invoices into e-mails. We want to be able to send customers emails to call or e-mail us back...
    [more]
  • [Sealed]
    5.0
    Profile image for Seller CEDUDE10

    CEDUDE10 United States

    Jun 22, 2010

    Good stuff. I have used this provider multiple times and I will continue to do so. Highly recommend...

    Project Description: Extract emails in text file.
    [more]
  • [Sealed]
    5.0
    Profile image for Seller CEDUDE10

    CEDUDE10 United States

    May 9, 2010

    update of previous project. great work as usual. will use this provider again.

    Project Description: quick update of license number entry and email text
    [more]
  • $50 USD
    5.0
    Profile image for Seller CEDUDE10

    CEDUDE10 United States

    Feb 17, 2010

    Very professional and thorough. Always a pleasure to work with FAZ.

    Project Description: Once a month I need cut and paste emails from a notepad text file and drop them into microsoft Excel. I want someone to write a script so that I can automate this process. Basically, I want to press...
    [more]
  • [Sealed]
    5.0
    Profile image for Seller CEDUDE10

    CEDUDE10 United States

    Jan 13, 2010

    great technical skills and very responsive. will work with again.

    Project Description: automation of certificate in XPS format and automating emailing. extension of previous project.
    [more]
    oFAZo has not completed any projects.
  • $225 USD In Progress

    My website has two separate submission forms.(WF1 and WF2) When someone submits either WF1 or WF2 all of the information that person inputted into the form is transcribed into the body of an email and then sent to my email. Each input field of either WF1 or WF2 will be on a separate line of the email. The emails will enter into my Inbox. WF1 comes from one email address and WF2 comes from a different email address. WF1 and WF2 are similar to each other the only difference between WF1 and WF2 is WF1 has a manager name and email plus 1 additional name and email plus 1 additional schedule plus 1 additional Zip Code list. WF2 has a manager name and email plus 8 additional names and emails plus 10 additional schedules plus 10 Zip Code lists.ACTION 1The inbox has 3 subfolders (SF1, SF2 and SF3). SF1 and SF2 should have identical properties and the same actions should happen whether I use subfolder SF1 or SF2. If I drag and drop an email from the inbox to either SF1 or SF2 the following actions should happen:1. All of the information in the email should be re-formatted into a excel spreadsheet (ES) so it's easier to read. 2. The new ES needs to be printed.3. A new email needs to be opened.4. The new ES needs to be attached to the new email.5. The new email should be sent to all of the email addresses that were entered into WF1 or WF2.6. Both WF1 and WF2 has a required field named 'organization' (RFO). The name entered into RFO should be cross referenced with a excel spreadsheet that I have on my computer. (MES). MES will list all possible RFO entries with corresponding email addresses. The matching email addresses on the MES should be added to new email created in step 3 and sent with the other emails in step 5.7.The MES will also have a corresponding list of files per RFO that should be attached to the new email created in step 3 before it is sent in step 5.8. WF1 and WF2 has the same section 'Would you like instructional material emailed?' if this is checked yes they can check up to 5 things they want emailed to them. Each of the items they are requesting should be attached to the new email created in step 3 before it is sent in step 5. 9.The body of the email created in step 3 should have generic text as a default. I should be able the change the default text at any time.10. I will need to manually send the email myself.ACTION 2The same actions should happen when I drag and drop an email from either SF1 or SF2 to SF3:1. A new email needs to be opened.2. The ES that was created in Action 1 should be created again and attached to the new email created in step 1.3.The new email should be sent to all of the email addresses that were entered into WF1 or WF2.4. Both WF1 and WF2 has a required field named 'organization' (RFO). The name entered into RFO should be cross referenced with a excel spreadsheet that I have on my computer. (MES). MES will list all possible RFO entries with corresponding email addresses. The matching email addresses on the MES should be added to new email created in step 1 and sent with the other emails in step 3.5. A special list of email addresses should be added to the new email created in step 1 before it is sent in step 3. I should be able to edit the list of special email addresses at any time.6.The body of the email created in step 1 should have generic text as a default. I should be able the change the default text at any time.7. I will need to manually send the email myself.

    [more]
  • $250 USD Today

    Simple Extract data from PDF, Text source formats into formatted Word.Document can be PDF, TXT.The selected data is import instantaneously transferred into the Plain Text format.This job is quite easy.*Please Bid Only New Freelancer*.More job starting details given via interview session.

    [more]
  • $83 USD Today

    Let me know where you are getting the PST file from. Are you creating it from your own inbox or something else? ## DeliverablesPST file must be real with unique and long emails, short emails, etc

  • $30 USD Today

    I need someone with advanced excel skills to figure out an advanced formula to create specific data.

  • £83 GBP 3 days ago

    You are an Independent IT Adviser providing expert advice to individuals on request. A client of a small newspaper, Daily News, produces two editions, morning and evening, and must publish at least 100 total copies for each days delivery. The morning edition requires 1hourof preparation and sells for20 pence. The evening edition requires 2.5 hours of preparation and sells for 30 pence. The clients objective is to maximise his total revenue of publishing, given that he has 200 preparation hours available each day and at least 40 copies of the evening edition must be printed each day.QuestionsYou should answer the following questions and incorporate your answers into a word-processed report. The sections of your report should correspond to the individual questions below.Formulate the clients problem as a linear programming model, clearly defining the variables, the objective function and the constraints.Solve the problem graphically by hand (use graph paper).Solve the problem using the Excel Solver and interpret the results. Find the value of the slack-variable relating to the hours available and discuss its economic interpretation.Find the shadow price of hours available and discuss its economic interpretation.For the final part of your report, in your capacity as an IT Adviser, you should present a memorandum to your client. Describe your main conclusions in simple, non-technical English; i.e. do not use technical terms like variable, objective function or dual price. Dont worry about repeating some or all of the points that you have already made in answer to earlier questions. The aim is to communicate your conclusions clearly to someone who knows nothing about the subject of linear programming. You may use tables and charts if you wish.Problem 2 A company manufactures a product. The total cost function is given by TC= 400 +10q and the total revenue function is given by TR= (60 - q) q, where q is the quantity sold.QuestionsYou should answer the following questions and incorporate your answers into a word-processed report. The sections of your report should correspond to the individual questions below.Plot on the same axes the revenue function and the total cost function and shade the region where profits are made.Using the graph or otherwise, obtain the output levels where total revenue equals total costs. State these breakeven costs and revenues.Calculate the profit-maximising level of output and the profit at this output level.Good presentation of the documentation

    [more]
  • $150 USD 3 days ago

    I need the following functions in Microsoft Outlook's Calendar. Please list in your quote which functions you plan to build. Please also note that however you accomplish these tasks, they must be done with only local software. If needed, we can have a computer on our network running 24-7 to perform these functions. We will like this completed asap, but absolutely it must be complete before June 8, 2013.1) have a shared master calendar that syncs with all of the calendars in a certain calendar group of shared calendars. If I create an appointment in the master calendar, it will be pushed to the correct sub calendar (this push will be based on the study selected in the form that is attached to the appointment). If I create an appointment in any one of the sub calendars in this calendar group, it will be pushed to the master calendar. (And all people who share these calendars will see the changes.) If this cannot be done in real-time, I will need some kind of macro or something that can perform a 'push' on request and every 5 minutes or so otherwise.-my idea: create an excel macro that pulls the appointments from one calendar and pushes them to another; do this for each sub calendar as well as for the main calendar, and make sure it doesn't create duplicates and make sure any edits to appointments get pushed on save and close: when the appointment has already been pushed once, it should not push it, but if someone saves-and-closes an appointment, it needs to be pushed again to overwrite the previous version. (we will need to be able to set this up ourselves on any new calendars we create in the future.)2) export an excel spreadsheet of all calendars in a group with one click (currently, I have to export each calendar individually, and then copy/paste)Note: if the above function is created, all I will have to do is export the master calendar (this will be perfect for us).3) auto populate a form that we have in each appointment based on the patient's name. If I create a new appointment for patient John Doe, when I type John Doe into the form in the name line, the rest of the form will auto-fill with any information saved in a previous form. If it is a new patient, obviously nothing will auto-fill, but when their follow-up appointment is created, it will autofill with their information. We will need to be able to add and edit these form fields as we choose without upsetting this auto-fill function.-my idea: create a custom contact form for each patient. This contact form will be attached to each appointment. The appointment form will update the contact form with any new information added or edited possibly via an excel macro push/pull. It should alert the user, 'You have changed the patient's information. Do you want this to overwrite the existing contact?' yes/cancel.Thanks a ton!Addendum:This will have to work with outlook version 2007, and 2010, and 2013.There will be about 10 people who have access to each shared calendar. Each of these people will also share the master calendar. The push from sub calendar to master calendar is universal. The push from master calendar to the correct sub calendar will be designated by a field in the outlook form (corresponding to one column in the excel file).Only 1 person's computer (1 outlook account) at a time will be performing the sync macro with an excel file because the excel file will be shared on our H-drive (very similar to dropbox), but we will need a user-friendly way to set-up and change the outlook account periodically as we desire. Only 1 person can have the excel file open at a time to edit/write (and perform macro). Any others that open the file will be in read-only mode.If an equation is used in excel, the outlook form will be filled by the cell's value, not the equation.

    [more]
  • $55 USD 4 days ago

    I would like to show you a specific PDF and have you set it u that I can edit it very quick.I want to replace things like:Name Addressphone#DateI want to be able to just tab from field to field and enter over old infoIt is the same pdf template that will be use for allWill also need ability to replace the bar code on the pdf.Attached is the PDF I wish to turn into a template I can edit.

    [more]
  • $16 USD/hr 4 days ago

    Looking for a programmer to assist in programming of MS Access applicationPlease quote your hourly rate.You need to have:1. Knowledge in MS Access programming2. Visual Basic3. SQL knowledgeThe program will run at Windows background.It will detect changes in Access database, then perform some task, including sending emailTo bid for this project, please submit ANY related project you've done before. Please email your project to The Administrator removed this message due to contact details which breaches our Terms and Conditions.If you're awarded this project, you MUST be willing to:1. Hand over the source code when project is completed2. Provide detailed documentation on the system flow, including charts & any other illustrations for our future reference.

    [more]
  • [Sealed] 4 days ago

    [This is a Private Project. You must be logged in to view the Project Description]

  • $55 USD 4 days ago

    The file attached is a theme file I use in Excel. It has multiple blue and grey fill colours, a verdana font and standard blue and and grey graphs and tables.I would like to change all of the shades of blue in the template for various shades of green. It has to work with everything in the template: fill colours, graph, tables, et cetera. It has to look as a nice combination with matching shades of green and grey. Similar to the example.

    [more]
  • $450 USD 4 days ago

    I need statistical analysis on a panel data set in either SAS, R or STATA. I need to analyze the data using fixed effects and random effects models. Additionally, I need a Heckman Selection Model estimated.

    [more]
  • $250 USD 4 days ago

    The site to be scraped is:http://leginfo.legislature.ca.gov/faces/billSearchClient.xhtmlThe information I would like scraped is the Todays Law As Amended for each bill text version.To see this for a bill, choose the Quick Search bar upper right of the screen and enter in AB 1. From the list of measures displayed chooseAB 1 Water quality: integrated plan: Salinas Valley. You will see a tab labeled Todays Law As Amended I would like the html content displayed scraped when you choose that tab.You will notice above the content to the right is a pull-down for Version:, I would want each version of the content. If it is of any help, I can provide the updated list of Measures and Versions daily that will have a new Todays Law As Amended for your scraper to work from. Once a version has been posted its content will not change.The scrape frequency would be once a day.

    [more]
  • $1111 USD 7 days ago

    Automated Reporting SoftwareMinimum Required Deliverables:1. Windows service that creates PDF files from a Microsoft access database and a File structure (using the Last modified attribute) that will e-mail the report weekly.2.PDF reports would be the following:(a) List of students that have been created in the database(b) List of students that have not used the system in the past week, and also in the past month(c) List of students in (b) but grouped by Learning Group (with Tutor name)(d) Percentage of students utilizing the system in the past week, and also the past month (Grouped by Tutor name)NOTE: If the scope of the bid is only for the minimum required deliverables, the bidding price will be SIGNIFICANTLY lower than the maximum price.Highly Preferred Deliverables:1.Software that reverse engineers the student tracking data contained in a directory (each student gets a directory)2.Additional PDF reports that will(a)Show the percentage completed of each course level for each student (e.g. Student A has completed 20% of the Beginner course, 0% of Intermediate, etc)(b)Show the percentage correct of each activity in the course (e.g. Student

    [more]
  • $83 USD 8 days ago

    Please see att the following:Scans of some client record papers: these need typing onto a spread sheet will be a smartsheet (that I will share with you). All detail will need copying across I have made some notes on the att. There will need to be a new entry for each contact screen shot att if the details address etc are the same they can be dragged down. Am guessing there will be a few hundred to do, in the ideal world a price per listing. Or price per hour and estimate of qty you could do per hour. Obviously the amount of content will vary. We could either send you scans like this one or post copies for you if you are in the UK..There is no deadline, the project will come in stages and could start withing the week. The scans will be uploaded and made available on our cloud system.Where you cannot read the detail we will make a system for you to note it easily and we will sort it this end, but that should be the minority.....You will have to sign a non disclosure agreement for this project.

    [more]
  • $83 USD 8 days ago

    I need the following:A calculator to calculate savings over different time periods when someone quits smoking. Title: Smoking Costs CalculatorSubtitle: Find out how much money youll save when you quit smoking?The user just needs to input the price of a pack of 20 cigarettes (format: 00.00). Text: How much do you pay for a pack of 20 cigarettes?And the number of cigs they smoke per day, (format: 00). Text: How many cigarettes do you smoke per day?Theres no need for currency signs, keep it open to accept all currencies.The calculator will calculate the cost of 1 cig by dividing the pack cost by 20. It will then multiply the 1 cig cost x the number of cigs smoked per day to get the daily cost. Then calculate the cost savings over 8 different time periods. Then display the figure in all of these 8 fields under the title: You will save. For each of the 8 time periods, also display the number of cigarettes not smoked, under the title: No. of cigarettes (on first line) NOT smoked (on 2nd line).Please average 30 days in each month for 1 month then multiple this for the other fields i.e. x6 for 6 months, x12 for 12 months etc. I want to give this calculator away free with an ebook, please make it look really good. Make it simple (like the calculator in MS windows), and a quick loading, stable file.See the attached application, this is to give you some idea, but it should look better than this. Can i also get unlimited revisions on it till it's right?Can i get the source code too?Please make it very stable with up-to-date software versions used and solid coding. *Please DO NOT apply for this job if you cant deliver ALL the above in a timely manner and communicate progress throughout.*Its VERY important that the applicant has a good command of English and can understand ALL the above requirements.I need a good working version in 2 days, depending on how good it is, there will be revisions to come to.If you have any more questions, please ask.I am not a programmer myself (as youve probably guessed!). So if you have any better ideas on how to improve the look or functionality of the calculator, feel free to make any suggestions. Many thanks! Jash

    [more]
  • $45 USD 9 days ago

    I have created a database already for gathering meeting minutes and i need help in finishing the project. if interested i will send the database to interested bidders.I am very interressado have some experience in developing and managing projects in access, I would like to Get your database to study it.

    [more]
  • $166 USD 8 days ago

    I need Bots! Different Kinds, I need them to be desktop version obviously, can be C, or C++. Please bid and PM me and i can send you more info of them. If you can make it please tell me your cost along with the time frame.

    [more]
  • $833 USD 8 days ago

    Project: VBA FROM DOC/DOCX to ExcelFrom an Excel spreadsheet we want to be able to select a range of DOC/DOCX from a folder (from 1 to 50 documents). A VBA script will parse the content of the selected documents and insert the content from each document into the Excel spreadsheet.//ExampleDocument1.docDocument1.docDocument3.docxDocument4.docxGoes toContent.xlsxContent.xlsx is structured like thisA1: SourceFilenameName of the DOC/DOCX fileB1:HeadingFirst line in the documentC1:ContentThe content from the document.//ChallengeThe content will be used for a website, so all styling must be removed. BUT if possible we would like to keep the markup of headings (,), bold, italic and underline so we can manage the styling via a css file. Linebreaks must be kept.What about tables in the doc - can they keep formatting?//PlatformOffice 2010/Office 2013//More functionality will need to be applied later, so if you can make above work you can expect more work from us :)

    [more]
  • $35 USD 10 days ago

    Hi,I need to create a simple script that customize the delay delivery in order for user to be able to delay all emails sent after 9PM until next day at 9AM. This is useful to a user that needs to work on a lot of emails after opening hours and doesn't want clients to receive an email at 11PM! The hard way is to delay every email one by one but i would like a rule 'if email created after 9PM delay until 9AM' or a way to keep outlook offline during a period of the night until 9AMI tried finding a rule i could apply but was unsuccessfulProvider will provide me with script and instructions on how to install itThanks for your help

    [more]
  • $100 USD 8 days ago

    I have three templates which I would like to modify and combine There are aspects of each that I like. I would like to explain what I want and have them combined.I would like the database titled services to remain mostly the same, but where the invoices and quotes use products I would like to have the northwind database imported and for it to pull from it. I basically want the services database with inventory tracking.This should be a simple $50 project.

    [more]
  • $222 AUD 10 days ago

    Create an integrative application using Microsoft Office 2010 (Excel & Access)Need someone to redesign database system, which allows me to manage staff, inventory, sales Also, create a workbook that allows me to analyse the performanceMust have MS 2010

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

Portfolio

[see more]

Resume

Education

BTech

Uttar Pradesh Technical University

2001-2005