Australia's Freelance Marketplace
Bid request Featured

excel form and report

  • Closed
  • Posted 27 Oct 2017 at 11:06
  • Remote (anywhere)
  • Freelance / Casual
  • 14 bids

This project has closed

It's no longer taking bids. Find other work.

About the project

We undertake soil analysis and have a large list of results that we want to enter into a form to produce a report that is simple but visually appealing.

The form must be clear and enable easy entry without damaging the form or report structure.

The types of information we need to include in the report is actual raw data figures, comparisons with accepted norms, graphs (most likely bar or chart but possibly pie), details of the client and sample information, written recommendations, a disclaimer text box and other info that we are yet to confirm.

  • Payal Thakkar
    Melbourne, VIC 9 Dec 2017 at 11:22

    I am a Reporting Analyst at a Government Organisation in Victoria. Recently I created a database in MS Excel from Australian Bureau of Statistics website which included raw data figures. I analysed data and generated reports for management. I represented data using graphs like bar chart and pie chart. I have advanced MS Excel skills. I am a quick learner and finish my tasks quickly. You may contact me for more details. I am happy to answer all the questions you may have.

    $100 in 3 days
  • krupa
    24 Dec 2017 at 19:02

    Hi, I am krupa, completed Ph.D. in biology and has worked with cancer samples. I was used to filling patients details in the form of reports. Being a biology research student all these parameter and terminology are very common for me. I am offering you the best bid offer to finish your project. I assure to finish your work in given time.

    $100 in 5 days
  • A former member
    29 Oct 2017 at 22:23

    Hi Andrew, I'm a mechanical engineer with extensive experience in using excel to create a wide variety of reports from raw data, with emphasis on ease of use for the end user. Your request should be a relatively simple task and I'll be able to do up a quick concept for your review once I gain more specific details. Feel free to contact me if you have any questions about this job or any of my previous work on similar reports.

    Nick

    $120 in 4 days
  • A former member
    29 Oct 2017 at 00:16

    Hi, this can be in a form of excel or can also be created on a web link for easier access. I can help you with sorting data and create charts for it. I did my thesis on Ethograms on feeding behaviour of Eagles and sorted a lot of raw data- published the book as a second author - http://ojs.upmin.edu.ph/index.php/banwa-archives/article/view/19 Also had my Masters on Environmental Research and Management thus I understand the importance of analysing big chunk of files. Once you have provided your data then I can suggest what to do and supply reasonable rate and timeline. For the purpose of reference, I will include an estimate rate here.

    Thanks

    $125 in 7 days
  • MKH associates.
    Gold Coast, QLD 1 Nov 2017 at 05:23

    Andrew, I am a qualified accountant with extensive excel skills which should enable me to manipulate the data you have. I can create pivot tables, data tables and use vlookup to manipulate the data as required. We can then look to achieve the format you require for the presentation. From the data set up we can then create graphs as required.

    View portfolio
    $125 in 3 days
  • Danyal
    27 Oct 2017 at 17:11

    I am new to Ozlance. I am masters student at ANU and have worked at Deloitte for almost 2 years. I am great with excel and have experience in compiling and presenting big data in a way which makes it easier to analyse. I think i can do a good job with your project. I could give you a more detailed plan on how i will proceed once i see the data you need processed.

    $150 in 5 days
  • Data Freelancer
    Clayton, VIC 8 Nov 2017 at 11:48

    Hi Andrew,

    Happy to help. I have plenty of experience in excel adn simialr tasks. I am very new to Ozlance but is very active on Airtasker.

    Assign the task to get started.

    Joe

    View portfolio
    $30/hr about 5 hours
  • Ivantha
    29 Nov 2017 at 21:24

    I have several years of experience in analysis data using Excel and other statistical software like SPSS and SAS. I can deliver this on time an accurately.

    View portfolio
    $150 in 3 days
  • Cynthja Pappin
    Pokolbin, NSW 13 Jan 2018 at 19:17

    I have advanced skills in Excel and a university degree in geosciences. I have taken and reported on soil samples before and I have knowledge of client requirements.

    $150 in 5 days
  • Haresh Kumar
    Melbourne, VIC 19 Dec 2017 at 08:15

    Hi Andrew,

    I am an excel expert and can prepre the form for you in excel with some advaced features, such as dropdown list, limit on range of values to be enetered, type of data to be entered in each filed & matain a database where you can keep saving data from each form.

    View portfolio
    $175 in 5 days
  • Assured Admin Solutions
    Bunbury, WA 30 Oct 2017 at 15:39

    As an experienced Australian Executive Assistant with over 12 years experience working with small to large scale businesses, I have experience in providing high level reports based on both data analysis, as well as research data. These reports include excel charts and data reports, as well as qualitative information. I am not a student in the field of administration, I hold over 12 years experience. My resume is available on LinkedIn or by direct email. Kind Regards, Emma Nesbitt

    $200 in 4 days
  • Amanda Atkinson
    5.0 (1) Smithfield, SA 6 Nov 2017 at 14:59

    I used to be a Microsoft Certified software trainer and as such I used to teach people how to do this sort of thing! There are two parts to this project - 1. You need a form, in which people can easily enter data. This would have drop down boxes, etc to maintain an accurate data set and make data entry quicker. 2. You need a report, which displays data that has been entered into the form. This report could be dynamic, so that the data in the report changes as data is entered into the form. The report could be something that is printed out also which is more static in nature. I would be inclined to use what is called an Excel Dashboard - where graphs and tables all appear on the one sheet, connected to the data. This can be printed also.

    $200 in 7 days
  • Carole Gan
    Macquarie Park, NSW 9 Nov 2017 at 12:37

    I've been using Excel in my current work of writing reports for a research company who send me their SpSS output, as well for many many years in my previous management roles. I also used to be a Microsoft Office trainer and taught people how to do this sort of thing.

    I'm new at Ozlance, and this is my first bid, so, if I've left something out, please feel free to contact me.

    $250 in 7 days
  • A former member
    1 Nov 2017 at 15:12

    Hi Andrew, As a professional spreadsheet designer (my business is designing spreadsheets for other businesses, incorporating design of layout, calculations, and automation routines), I would be happy to take a look at your requirements and provide you with an in-depth quote illustrating the data, the deliverables and the price to achieve the desired outcome, however there's a little bit of information that I'll need first. Would you like to catch up via telephone or Skype (or in person if you happen to be in Adelaide)? All spreadsheets that I design have a strong focus on simplicity, user friendliness and future proofing. My work is guaranteed. Please feel free to contact me, Google me (DOCOffice) or check out my website www.docoffice.com.au

    $600 in 14 days
  • Aussiefreelancer.Katrina 27 Oct 2017 at 16:43

    Hi Andrew,

    Do you have a sample report as to how you would like it to look?

    • Andrew H. Client 27 Oct 2017 at 20:04

      Hi Katrina, yes we do have some samples of other reports that I can attach to show you. This is my first time using Ozlance so I'm not sure how to attache something.

    • A former member 1 Nov 2017 at 15:55

      Hi Andrew, You can add attachments when you post the job, by clicking the button labelled "Click or Drag files to Upload". It's a little fussy - you can't upload Word or Excel files, but if you print your report to pdf, you should be able to upload it without any trouble.

  • Icaliber 22 Nov 2017 at 15:23

    Hi Andrew,

    Base on your description I understood you are after reporting and charts.

    I have implemented reporting and chart component, please have a look a product(s) and try the trial version. You can download product via below link.

    http://icalit.com/Products/Products#product

    Please feel free to contact if you need more details or product configuration steps.

    Thanks Viki Viki_eisp@yahoo.co.in