offline
Last seen: Jul 27, 2014 2:32 AM EDT
Hire Me!
Rate: $100.00 USD/hour
Follow Invite to Project
 

buyaspreadsheet

www.buyaspreadsheet.com

Username: buyaspreadsheet

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

Location: London Colney, St Albans, United Kingdom

Member since: November 2012

Reputation:

5.0/5

(17 reviews)

4.7
[see more]

No user has recommended this freelancer.

My projects:

  • £45.00 GBP
    5.0
    Profile image for Seller Tfoege

    Tfoege

    Feb 8, 2014

    Another exceptionel product!

    Project Description:Cost analyzing looping module
    [more]
  • $300.00 USD
    5.0
    Profile image for Seller Tfoege

    Tfoege

    Feb 5, 2014

    Great work. Hired again straight after finish

    Project Description:Hello, We have an excel sheet with six lists and a matrix We need a VBA script that can combine all the possible combinations of those lists with an attached value either as a function of the columns...
    [more]
  • $75.00 USD
    5.0
    Profile image for Seller wcramton

    wcramton

    Oct 15, 2013

    Quick and easy to deal with.

    Project Description:I believe you already completed the project below for someone else and wanted to see if you could do the same for me. Thanks Dear All I need a VBA macro that pulls the zestimate and rent zestimate of a property from Zillowcom...
    [more]
  • [Sealed]
    4.8
    Profile image for Seller noodes

    noodes

    Oct 3, 2013

    It was great working with Andrew. He has the expertise and is very professional.

    Project Description:The project is describe in detail in the attached PDF documents. If more information is needed please be free to ask additional question in order to give me a better quote. I will provide the Excel sheet...
    [more]
  • $65.00 USD
    5.0
    Profile image for Seller hycomfg

    hycomfg

    Sep 13, 2013

    very quick, perfect results, will save me a lot of time. Clearly capable of far more complex tasks. Recommended.

    Project Description:We have a spreadsheet with a large set of sales data in a single worksheet. We sell to a number of organisations each of whom has a number of branches. There is one record for every branch with a number of fields - perhaps 30 or more fields...
    [more]
  • $34.00 USD
    5.0
    Profile image for Seller Kaboria84

    Kaboria84

    Jun 12, 2013

    Andrew was great and professional. Very easy to work with and I will hire him for any future project. Look no further, he is your best option.

    Project Description:There is no data to enter at the moment but I need a sheet programmed to do the following. We sell a product to many different clients and I want to track how much it is costing us to service these clients...
    [more]
  • $80.00 USD
    5.0
    Profile image for Seller ballywho

    ballywho

    May 31, 2013

    He was easy to work with, he was extremely fast, and very responsive to our needs!

    Project Description:Edit the Topics by Time tab: Make it so the user can set a date range and sort by column - the tab will then populate with all the topics and associated topic data (including tab name). The tab will search all tabs within the worksheet using the post-date as the search parameter...
    [more]
  • £110.00 GBP
    5.0
    Profile image for Seller hudsonfurniture

    hudsonfurniture

    May 31, 2013

    Absolutely perfect, could not fault, will definitely use again!

    Project Description:Hi, Please find details of the project below, I'm not an expert in mathematics so I could well have missed something crucial, please contact me if you need anything clarifying and I will respond immediately...
    [more]
  • $82.00 USD
    5.0
    Profile image for Seller investorvw

    investorvw

    Apr 25, 2013

    Andrew was very helpful, went above and beyond. Would hire him again. Good communicator, helped project with suggestions and was able and ready to chat. He is in the US and it is a plus for those who live here. Thanks Andrew!

    Project Description:I have an excel file file with some Visual Basic programming that needs a little addition. The arrows and bands displayed by the program need to show values on top of the objects. I am attaching the excel file with current programs (Macros)...
    [more]
  • $82.50 USD
    5.0
    Profile image for Seller JHLLC

    JHLLC

    Apr 23, 2013

    Definitely will leave a bonus. Definitely would work with again. Definitely would recommend Andrew to others in need of his expertise.

    Project Description:Project Background: Some years ago Microsoft offered an add-in for Excel that allowed near-real time (20 minute delayed) stock and option quotes to be downloaded into an Excel spreadsheet. Microsoft...
    [more]
    buyaspreadsheet has not completed any projects.
  • $100 USD/hr In Progress

    Hi,Please see attached spreadsheet file.The data in the sheet marked "data" is daily unit prices for a range of Australian Pension fund investment options (managed funds which have no distributions or dividends). The data is updated via bloomberg datafeed plugin). The function of this spreadsheet is twofold:1) To allow me to graph the relative performance of a range of selected funds for a set period ("value of $10,000 invested") - this is done by selected the funds (columns AE to AG) (via drop down lists of Sector, then Fund) and pressing the Fund Graphs button.2) To allow me to graph a "portfolio" made up of a mixture of funds for a set period, by selected the funds in AE to AG and then selecting weightings for each fund from columns A to AD, with "rebalance" dates (portfolio reweightings) specified in row 7. In relation to the portfolio function I would like to create the following “summary” for the chosen portfolio and period: 1) Total return for the period2) Annualised return for the period where over 1 year period.3) Standard deviation After that is done I would like to create a “monthly return stream” table for each of the complete months in the period. From this we can determine the “best month”, “worst month”, “average month return”, median monthly return and then draw a histogram of the monthly returns distribution (ie a bell curve of monthly returns).Please let me know your thoughts.Thanks!Steve Melling

    [more]
  • $75 USD In Progress

    Dear AllI need a VBA macro that pulls the zestimate and rent zestimate of a property from Zillowcom.I have a spreadsheet (with multiple rows) that contains home addresses in the U.S.: A - Street AddressB - CityC - StateD - Zip code E - Zestimate (this is what I need you to provide)F - Rent Zestimate (this I need as well)I need someone to program a macro or otherwise to populate the Zillow Zestimate home value and Zillow Rent Zestimate rent value. I"m fairly computer literate, but learning Excel VBA for this project will require too much time on my behalf.

    [more]
  • $1000 USD In Progress

    I need a document level addin for Microsoft Excel that is to be used for a business spreadsheet (accounting related). The exact details of the project will be revealed once the job has been awarded but the following skills are required: - Knowledge of accounting - Excel spread sheet design - Excel ribbon customisation (using vb.net)We currently use a mixture of spreadsheets and calculators for some accounting related tasks and want to combine all of these into one spread sheet.In order to verify the skills of the Freelance I would like to see samples of work created including an example of a excel spreadsheet they have designed and a ribbon customisation they have done.Legal Requirements of this project: - This is to be based around a spreadsheet used at work and so all communications relating to this project are to be kept strictly confidential - All files/communications relating to this project must be deleted at the completion of the project - A signed form on the completion of the project will be required to verify that all communications and files have been deletedThe exact price of the project will be clarified once the bidder has been awarded the job.Any questions: please ask.Thanks for reading.

    [more]
  • $950 USD In Progress

    Please see the attachment for the detailed requirements for this project.The Observatory is a global marketing consultancy that helps marketers make more from their marketing resources. It currently operates from 8 cities across the world and has approximately 20 partners.A key component of some of its consultancy services depend on being able to use its existing information as a benchmark against the data being captured for a specific project.For this application the benchmarking data is the hourly rates a marketing communications agency charges to its clients. This tool will allow all The Observatory partners around the world to:1.Enter the hourly rates data in a consistent manner2.Standardise it to a common currency3.Benchmark (index) it to a selection of the other data already captured.4.Undertake basic manipulation / analysis of the data5.Output various reports

    [more]
  • $450 USD In Progress

    We are after someone to develop a bespoke order form system (Excel)for use by our field sales team. The system will need to perform the following functions:-1.Produce an order for a client based on the products they have orderedI.We have a bespoke product offering whereby each of our products has varying properties. An example being shirts can have a) Set Colours b) Set Collars c) Fabric Type d) varying designs. When a product is selected the correct options would then need to appear through various dropdown boxes. Once an item is fully selected a button will need to appear allowing the product to be added to the order. The product would then appear underneath in an editable area and separately on an order form for a client. The user should be able to remove an item from the editable area which then removes the item from the order form. They should be able to amend only set properties on the order for such as price, which we will advise in due course which fields they are.II.The form will also need to pull through client information from the customer data stored on another form via a dropdown box. This will need to appear on the edit screen as well as the order form.III.On the order form a jpg images will need to be shown of the product ordered.2.Internally the spreadsheet will need to store each SKU (Product) with the various properties & clients.3.Feeding into the above the spreadsheet will require a worksheet whereby the company will be able to add products to the dataset & customers.The successful candidate will need to have the following skills:-•Excel – Extensive knowledge•VBA – Extensive knowledgeAs and when the candidate is selected we will provide the data along with a visual example of what is required. This is an urgent project and will be required by next Tuesday (18th December).Best Wishes,Suzanne.

    [more]
  • $250 CAD 28 days ago

    Data processing, data entry, data manipulation, excel charts and dashboard preparation.

  • $500 USD 28 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]
  • $100 USD Jun 26, 2014

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

  • €500 EUR Jun 24, 2014

    i need someone to look at 4 data models (in excel) and translate these into a number of formulas so my development team can work on the application

  • $25 USD Mar 21, 2014

    I have some raw files of excel and i want to convert them in some particular template so what i am looking for is a person who can write Visual basic code which directly convert my that particular excel data to some required excel template. task is very simple VB programming if you know VBA for Excelfurther details will give you on my accountSkype ID : syed.furqan.rafique

    [more]
  • $250 NZD Mar 13, 2014

    I am a secondary school teacher.Using a Barcode scanner, I would like to be able to take the attendance of large groups with their ID cards.I found an amazing spreadsheet that was freely shared on mrexcel.com It was created by hiker95 and here is the link to it.http://www.mrexcel.com/forum/excel-questions/704960-need-help-attendance-sheet-using-barcode-scanner-2.htmlThis sheet enables a barcode scanner to input an ID number into A1 and then a date and time is stamped alongside the respective person to which has that respective ID number relates to. After each number is processed, A1 is cleared and re-selected ready for the next entry.I would like a modified version that allows for two columns of barcodes to be checked against. This is because the group of people I"m currently trying to track attendance of have one or two different ID cards they could use.I would also like each new date that scanning place, an automatic column to be created with only the time stamped under the respective date alongside the correct person. If the date already exists, it simply puts in the correct time of scan eg. 2:45pm underneath the date, beside the respective ID holder. However, if the date hasn"t yet been used yet, then it creates a new column on the right with that date listed at the top, and then the time at the bottom.I would also like a column to tally the amount of attendances.If there is any ID code that is not recognised, I would like the unknown fields to be filled with question marks like "???". This way, I can search up the ID"s information later, and then fill in the fields that are missing. I would still like the time to be stamped however and the barcode recorded.I have attached a picture of the proposed spreadsheet.

    [more]
  • $70 USD Mar 6, 2014

    This is a very quick & easy assignment. I need a simple excel program to take user input with location vs date/ time, and draw a bar-chart. The timescale is on the left and right, and the locations named by number format. For advanced user in VBA programming, this task can be completed very very quick.

    [more]
  • $250 USD Sep 17, 2013

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

  • €4 EUR Jul 6, 2013

    Accurate and reliable.Billing.Billing is a job struggling with payments, accuracy, booking orders, and in the spirit of a strong need to do the job ..program microsoft excel, data tabulation, and the formula is my daily, and on every Wednesday, I was always dealing with the collectors to pay the bills, and withdraw a demand to be paid ..and at the end of the year, I was never too late to hold a closed book and recommend to the head of my company ..and gratefully, I have never faced adversity for my work. . .

    [more]
  • $137 USD Jun 9, 2013

    mengentri data sesuai permintaan

  • $30 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"ll send you the file I use know for modification.

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

Portfolio

[see more]

Résumé

Experience

Director

Aug 2011 - Nov 2012 (1 year)

UBS AG

A further highly analytical role within UBS, a leading Swiss bank and one of the biggest financial institutions in the world with offices in more than 50 countries.

Manager

Sep 2005 - Jul 2011 (5 years)

PricewaterhouseCoopers LLP

A highly analytical, client-facing consultancy role, providing services to a wide range of predominantly FTSE 100 organisations.

Education

First Class Master of Mathematics & Statistics, University of Warwick (4 year course, MMathStat)

2001-2005

Certifications

Qualified Actuary

Institute of Actuaries