Find Jobs
Hire Freelancers

Build patient database

$8-15 USD / hour

Cerrado
Publicado hace casi 9 años

$8-15 USD / hour

I am an eye doctor and I need to create an excel spreadsheet that will allow me to track and manipulate data with patient name, insurance billing info, patient referrals, balance due, ledger info, etc. . I already have created an worksheet that I currently use, but I need it to do more. I don't have the knowledge in excel macros to finish the job right. I will use this mainly as an end-of-day ledger to account for total fees paid by patient and which insurances need to be billed. I need the ability to add commonly used diagnostic codes. I also want to add the function for patient recall as well so that I can specify a certain month to call the patient as a reminder to schedule an appointment. I need to add a function for patient referrals. I want the excel program to allow me to use a push button function to identify which patients at the end-of-day need to be referred and have that patient name info automatically be saved as a list as a separate spreadsheet. The excel spreadsheet that I am using now is included with this project for reference.
ID del proyecto: 8098294

Información sobre el proyecto

21 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
21 freelancers están ofertando un promedio de $12 USD /hora por este trabajo
Avatar del usuario
Hi, I have gone through your project details and would like to take an opportunity to work on it. I suggest you to use Microsoft Access for the solution as there you will be able to maintain data through forms easily and data will be stored securely. Apart from that reports can be created as you need.. like patients data, fee details etc. Waiting for your response to talk further in detail to plan out work. Thanks.
$8 USD en 8 días
4,8 (9 comentarios)
3,6
3,6
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$15 USD en 4 días
5,0 (4 comentarios)
2,9
2,9
Avatar del usuario
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert on SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble Ashish Seth
$12 USD en 3 días
4,8 (7 comentarios)
3,2
3,2
Avatar del usuario
EXPERIENCED DEVELOPER... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quick... Please note that I am a holder of SQL Level 3 badge which makes me one of the TOP SQL freelancers around
$15 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am having good hands on experience with database creation and management . I have managed and worked with big data projects using informatica tool as well . I had understood your project needs and guaranteed delivery on time with best results will be given to you. looking forward to work with you. Thanks
$12 USD en 6 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm a computer science professional with a PhD degree and extensive experience in Excel database development. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at a some Excel projects I did: https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$15 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I can design and implement for you a new internet information system(programming and database in PHP/MySQL) for your needs. I am graduate of Management Science and Technology department of Athens University of Economics and Business. I like projects like your project. We can design your web application to appear well to any mobile devices' or tablet's screen sizes. My proposal is to develop this new application and stop working with Excel files. Of course your current excel data will be loaded as the first data in the new application and you will not lose any data. I wait for your interest, John Skordialos
$8 USD en 25 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, I can design a Microsoft Access Database for your Eye Doctor Office that will fill all your needs that you requested. Access is a little different then Excel but I believe it will benefit you in the long run. I can add fields in the database for all the data you requested (Patient Name, Insurance, Balance, etc...). I can setup the Database with a form view where you can view all you important information like you already had in your spreadsheet. I can make a dynamic form per patient that you would open when seeing a patient and this form would have all the patient information on it that's stored in the database. I can setup an end-of-day ledger report that you can run at the end of bussiness day to see all your total fees paid by patients. I can setup a back-end database where all the data stored. I will also setup a front-end database for multiple people to use if you would like. This front-end database will have all your forms and report for viewing. You will add all your data through these forms so you don't really need to know anything about Access. These front-end forms will have error-checking so no data is entered into the database incorrectly (text entered into a date field, etc...). If you have any question let me know. Thanks ACLARK6996
$13 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi doctor, I believe Excel is not a good choice to build a solution around. Excel is good to deal with unstructured data however when it comes to structured data ( patients, Payments, etc) you need a database management system. I would recommend to build a solution in Microsoft Access where you can perform all of the required functionalities with a user-friendly interface; a few clicks and you get what you want. with Access, you will be able to perform daily work as well as generate statistics and reports on a daily, weekly, monthly basis. I proficient in Excel, VBA and Access and I can do the job either ways, but I am committed to give my clients an advice while I am proposing a solution. Your satisfaction is guaranteed. If you need more details please contact me. Best Regards Ahmed
$8 USD en 15 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I know your heart is set on MS Excel, but consider a browser-based cloud database application service that includes ALL IT services in a single plan. During twenty years of creating database applications for clients, I developed a method to support a diverse set of CUSTOM applications. We combine all services: DESIGN, DEVELOPMENT, HOSTING, TRAINING, and SUPPORT into a single plan--one low monthly fee to fully support your IT needs. Search for "Konduit Transaction Editor". I can set up your CUSTOM Patient Appointment/Billing Ledger database application on a production Transaction Editor (TEd) cloud server within two weeks for just $495. Users can Test Drive the application online for two months as we continue to refine your requirements. You get immediate hands-on experience and we can calculate the affordable monthly recurring fee based on the complexity of the application we build. * Each TEd application combines spreadsheet ease-of-use with the accountability of a database and includes ongoing professional APPLICATION support. * Intuitive SEARCH, SORT, and VIEW-creation capabilities * All user data changes recoverable from CHANGE HISTORY LOG * Column and Row USER-ACCESS CONTROLS * Highly reliable and secure * IMPORT/EXPORT - named VIEWS and file format specifications * JOB scheduling and EVENT-based data modifications * NOTIFY capabilities * and so much more... Contact me for a demonstration.
$12 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
What You think about Lotus Notes database for this operation? It's a good solution for so databases, with big count of text fields, for example operation description, receipe, photo, if need. If You planned a businss expansion, this database can be groved to any count of users, with power security and access levels. Lotus can write letters for You and patiences with remember ot other messages. Of course, this solution have a lake - original 'lotus' interface. I can sent screenshot, if You think about this solution.
$13 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have adequate experience working with excel macros and i can accomplish the required work within set timelines.
$14 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have 2 years experience in developing Excel Macros Can develop an advanced spreadsheet as per your requirement using macros. You can add-in additional functionalities as per requirement.
$11 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Currently I build many different excel databases and reports using formulas, macros and many different add-ons to accomplish functionality. I have worked with excel with many organizations in many different fields. Here is what I feel would need to be done in order to accomplish what you need. 1. Gather Detailed Scope/Requirements needed by the client. 2. Build source data sheets to store and manipulate the data. 3. Build any reporting functions required by the client. Depending on the scope I would think 1 to 2 weeks and the project could be completed. I have the ability to work more than 20 hours per week to complete the project successfully to meet client requirements.
$11 USD en 20 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde jul 18, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.