Find Jobs
Hire Freelancers

Excel model - create custom reports

$30-250 USD

Закрито
Опублікований over 6 years ago

$30-250 USD

Оплачується при отриманні
High level description: I have created an excel based model to calculate monthly bills for children attending a playgroup or Montessori where two government subsidies apply. Based on the fee per session, type of session, date of birth of child and number of days attending the model calculates the monthly bill and auto recognises which government subsidy applies. What I need now is, using the valuable data in the main "tracker sheet", some custom reports that will allow the playgroup/Montessori owner to quickly add/remove children, print bills, rotas etc. I have created the template forms and reports but will need the code written to extract the right data from the tracker spreadsheet. Please read below description carefully and start your proposal with three dots. Detailed description: Reports/forms required: 1. Add a child to a premises/room - based on simple form (which I have a template for) - write code so it adds the child to the chosen premises/room; 2. Remove a child from a premises/room - simple form (which I have template for) - write code so once child is selected and delete button is pressed the child is removed from the relevant room/premises; 3. Print bill - template already created - need code written to automatically pull the data for the child selected; 4. List of children in each scheme - need code written to pull a list of children under each scheme (there is Y/N applicable column in the tracker spreadsheet so should be relatively simple); 5. List of emergency contact details by child by room (all data in main spreadsheet); 6. Set up reports (i.e add a room, add a premises, add which government subsidy applies) add a fee structure etc). The tracker spreadsheet will pull different inputs depending on the fee structure and room type as different subsidies will apply. 7. Ability to edit children that are already added. So search and their details show up in exact same form as the "add child" form but you could add or delete a day to reflect any changes in number of days they are attending. Project timeframe: 4 days. And please give me your budget. Thank you.
ID проекту: 15093397

Про проект

44 пропозицій(-ї)
Дистанційний проект
Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
44 фрілансерів(-и) готові виконати цю роботу у середньому за $173 USD
Аватарка користувача
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $180 USD - Once the project is complete
$180 USD за 3 дні(-в)
4,9 (464 відгуки(-ів))
8,3
8,3
Аватарка користувача
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
$250 USD за 4 дні(-в)
5,0 (480 відгуки(-ів))
8,0
8,0
Аватарка користувача
Hello , I have read your project description and understood your requirement. I have 5 years experience in VB.Net and Excel Macros. I can do this task. Relevant Skills and Experience Skills : Excel, Macros,VB.net, Web scraping, Data entry, Copy typing, Transcription works Proposed Milestones $100 USD - Project
$100 USD за 2 дні(-в)
4,9 (460 відгуки(-ів))
7,7
7,7
Аватарка користувача
Hi: I can create a Macro (VBA) that can help you achieve your objectives. Please share template forms. I have done several similar projects (i.e. Quote Generator, Monthly Performance Dashboard, etc.) Relevant Skills and Experience Please note that over 80% of my completed projects are related to Excel and Macro. Moreover, I have ~100% completion rate and ~5-star feedback on projects. Proposed Milestones $150 USD - Macro
$150 USD за 4 дні(-в)
4,9 (171 відгуки(-ів))
7,1
7,1
Аватарка користувача
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Relevant Skills and Experience excel Proposed Milestones $555 USD - g
$555 USD за 3 дні(-в)
5,0 (97 відгуки(-ів))
6,6
6,6
Аватарка користувача
I'm Office Developer that provides data entry, VBA Programming and database programming support. I am delighted to take on your Excel model - create custom reports. I can also provide a prototype. Relevant Skills and Experience SKILLS: • Web Architecture. • VBA Scripting. • Database Programming & Development. • Business Intelligence Development. Proposed Milestones $55 USD - work $100 USD - work
$155 USD за 3 дні(-в)
4,9 (25 відгуки(-ів))
6,5
6,5
Аватарка користувача
create tool to build fee calculation model Relevant Skills and Experience Excel/VBA Proposed Milestones $250 USD - Completed tool Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedback. Thanks.
$250 USD за 4 дні(-в)
4,9 (115 відгуки(-ів))
6,3
6,3
Аватарка користувача
... Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can help you With this Excel upgrades so please contact me by chat and then we could discuss better your project and I could see your forms and tables. Kind regards, Luis Romero
$80 USD за 4 дні(-в)
5,0 (167 відгуки(-ів))
6,0
6,0
Аватарка користувача
A proposal has not yet been provided
$198 USD за 5 дні(-в)
4,9 (41 відгуки(-ів))
5,5
5,5
Аватарка користувача
... Hi, I will give you a complete system to automatize your work with the feature of AddNew, Edit, Delete, Search records. I have a sample for you, please send me message to get it. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manipulating Data in Multiple Sheets and Creating Reports. Budget $250, Time Frame 4 days. Proposed Milestones $80 USD - initial $80 USD - second $90 USD - final windows or mac?
$250 USD за 4 дні(-в)
4,8 (100 відгуки(-ів))
5,8
5,8
Аватарка користувача
I have 7 years of experience with similar job experience which I can show you before being hired. See my profile for client reviews about me. Relevant Skills and Experience Excel VBA Proposed Milestones $133 USD - only Looking for your response.
$133 USD за 1 день
4,9 (32 відгуки(-ів))
5,5
5,5
Аватарка користувача
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $155 USD - 100% milestone and release upon completion
$100 USD за 2 дні(-в)
4,9 (72 відгуки(-ів))
5,7
5,7
Аватарка користувача
... Dear client, I have carefully read the description. I can write VBA code for you for each of these tasks. Looking Forward Relevant Skills and Experience Excel, VBA Proposed Milestones $133 USD - Excel file fulfilling the requirements
$80 USD за 3 дні(-в)
5,0 (28 відгуки(-ів))
5,0
5,0
Аватарка користувача
I can create this excel model and can generate report Relevant Skills and Experience excel, vba, macro Proposed Milestones $194 USD - All
$194 USD за 5 дні(-в)
4,6 (43 відгуки(-ів))
5,6
5,6
Аватарка користувача
Excel VBA expert with 2+ years of Experience
$150 USD за 2 дні(-в)
4,9 (16 відгуки(-ів))
4,5
4,5
Аватарка користувача
Excel work Relevant Skills and Experience I have 9 years of experience in excel and data analysis. I have created lots of analysis in excel, automated reports, developed high level customized dashboard in excel for different type of analysis Proposed Milestones $188 USD - Output
$188 USD за 4 дні(-в)
5,0 (12 відгуки(-ів))
4,0
4,0
Аватарка користувача
... I have read the project description and available to work on it immediately. Relevant Skills and Experience I am a professional with 10 years experience and have recently closed 4 projects in Excel using VBA. Proposed Milestones $55 USD - Add, Remove and Edit Children Details. $55 USD - Bill Printing, Children listing and Emergency Contact Details $57 USD - Reports Please confirm the operating system and excel version you are using.
$167 USD за 4 дні(-в)
5,0 (12 відгуки(-ів))
4,2
4,2
Аватарка користувача
... Hi there, Good day! I'm interested in the job and can get it done within 3 days having budget of $150. Feel free to contact me and discuss more details if OK. Relevant Skills and Experience Having good knowledge of Excel VBA. Proposed Milestones $150 USD - Complete the task
$150 USD за 3 дні(-в)
4,9 (11 відгуки(-ів))
3,9
3,9
Аватарка користувача
I will modify my existing MS Office VBA script to generate the Reports/forms that you require. Relevant Skills and Experience I have been coding in basic & MS Office VBA script since 2000. Proposed Milestones $250 USD - Project Successfully Completion
$250 USD за 4 дні(-в)
5,0 (1 відгук)
3,4
3,4
Аватарка користувача
I have read ur requirements n I would like to provide my services. pls pm me if interested in some demos.
$110 USD за 4 дні(-в)
5,0 (9 відгуки(-ів))
3,1
3,1

Про клієнта

Прапор LAO PEOPLE'S DEMOCRATIC REPUBLIC
Vientian, Lao People's Democratic Republic
5,0
6
На сайті з серп. 9, 2015

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.