Find Jobs
Hire Freelancers

Build patient database

$8-15 USD / hour

종료됨
게시됨 거의 9년 전

$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: 8098294

프로젝트 정보

21 제안서
원격근무 프로젝트
활동 중 9년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
21 이 프로젝트에 프리랜서들의 평균 입찰은 $12 USD입니다./시간
사용자 아바타
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 8일에
4.8 (9 건의 리뷰)
3.6
3.6
사용자 아바타
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 4일에
5.0 (4 건의 리뷰)
2.9
2.9
사용자 아바타
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 3일에
4.8 (7 건의 리뷰)
3.2
3.2
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 6일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 25일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 15일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I have adequate experience working with excel macros and i can accomplish the required work within set timelines.
$14 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 20일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED STATES)
United States
0.0
0
7월 18, 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)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.