Find Jobs
Hire Freelancers

Data import to Excel and automatically export as graphs to PowerPoint and Word document templates

$3000-5000 USD

Fechado
Publicado há quase 8 anos

$3000-5000 USD

Pago na entrega
seeking an Excel/MS Office programmer to provide a quote for development of the tool below. My company provides EHR expertise. Background Chronic pain patients are clinically complex and require careful monitoring by prescribers to ensure safe, effective management. Understanding trends and practice patterns in treatment in a prescriber’s own practice may provide useful insights in treatment for this population. POCP’s client is interested in developing an out-of-the-box, user-friendly spreadsheet-based research tool for use by healthcare practitioners. The tool will allow them to download or input and analyze data from their own practice data. The tool would be developed as a pre-programmed Excel (or similar program) ‒ Instructions ‒ Templates for data collection ‒ Graphic representations of collected data for automatic export to tools including: auto-populated presentations, abstract templates, and manuscript templates • Tool would interface with the top 5 electronic medical record providers and facilitate upload of data directly from the EMR, via uploaded data file, or via manual entry of data. • Varied levels of complexity selected based on interests or practitioner and resource availability • Each level would have a unique practice pattern question, data inputs, and results ‒ Level I: low complexity, low practitioner demand ‒ Level II: moderate complexity, moderate practitioner demand ‒ Level III: high complexity, high practitioner demand • Data collected may include: ‒ Prescribed medications (medication, strength, dose, duration) ‒ Patient survey information (5-10 lifestyle questions) ‒ Diagnosis (by ICD-10 code) • In addition to aggregation for prescriber use, POCP’s client seeks a vendor who would also facilitate the availability of the de-identified data back to POCP’s client for their own analyses. Due dates Draft Tool Content: June 13, 2016 Beta version of tool: July 1, 2016 Testing with practitioners: July 15, 2016 Final Tool: August 1, 2016
ID do Projeto: 10554434

Sobre o projeto

23 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
23 freelancers are bidding on average $3.950 USD for this job
Avatar do Usuário
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).
$3.000 USD em 90 dias
4,9 (271 avaliações)
7,7
7,7
Avatar do Usuário
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$3.000 USD em 30 dias
4,8 (300 avaliações)
7,1
7,1
Avatar do Usuário
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$4.000 USD em 30 dias
5,0 (271 avaliações)
7,1
7,1
Avatar do Usuário
Hello there, I reviewed the requirements description and would like to inform you that I am an Expert in creating data visualization tools like the one you are looking for. I have done several dashboards/reports that work on raw data and present the results in very elegant visual reports consisting of charts, tables, conditional formatting etc. I have shared some of my work in my profile and if you drop a message to me, I would be able to share some very nice dashboards that work on large data, for your review. Now, I must also inform you that though I am expert in analyzing the data and presenting it, I just have basic information of clinical data and even less on medical terminology. So, I will need your help in defining the requirements and calculation of metrics. Once we have discussed the requirements in detail, I can assure you that I would be able to create a very intuitive set up for your purpose. I have done more than 490 projects here on freelancer itself (with Excellent ratings) and can assure you of high quality work. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to working with you and thank you for considering my bid. Regards, Rishi
$4.444 USD em 60 dias
4,8 (98 avaliações)
6,4
6,4
Avatar do Usuário
Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have also done lot of auto generation of Word templates and PowerPoint slides generation on the fly using data from Excel. I have more than 10 years of experience to my credit. I have done good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$3.000 USD em 30 dias
4,9 (54 avaliações)
5,8
5,8
Avatar do Usuário
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience in health care and I have been freelancing for over 3 years. I have worked on lot of advance Excel dash boarding and VBA coding using Microsoft access database, SQL and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$4.000 USD em 30 dias
4,9 (22 avaliações)
5,9
5,9
Avatar do Usuário
Hi there, This sounds like a fascinating project, and I am very interested in helping you out. I am a data and analytics professional with almost 10 years creating Excel-based tools for processing, analyzing and visualizing data. I have extensive experience programming in Excel and creating intuitive interfaces. I am US-based (Atlanta) and bring a strong educational and professional background. I encourage you to check out my profile and reviews. I would love to chat with you in more detail about this project and hope to have the opportunity to work together soon. Best regards, Marcelo
$4.467 USD em 30 dias
5,0 (12 avaliações)
4,9
4,9
Avatar do Usuário
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details
$4.444 USD em 30 dias
5,0 (49 avaliações)
4,7
4,7
Avatar do Usuário
Hi, I can share with you an example that shares graphs with Powerpoint and Word document templates. But what you are requesting is more than that. Your budget seems OK fit that. However, I think, 1. You must create a document at least 3 to 5 pages with detailed description of every step you want, you must spare some time with that. Also you need to share every piece of data you have. 2. You must verify your payment, as soon as we approve when we are awarded, ten percent would be cut from our account. 3. You must provide some payment at the beginning of the project and need to define some milestones. If you provide these then we may discuss your project.
$4.500 USD em 30 dias
5,0 (21 avaliações)
4,4
4,4
Avatar do Usuário
Hi, I’m very interested in your job. I have more than 7 years’ experience work with Excel & VBA. Short background, what type of macros I wrote (total count of my VBA macro > 50): - all possible operations with text, formulas, files in Excel and Word; - processing any information, formatting, parsing, transforming, forecasting; - creating forms, reports, queries, adding controls. Also I have good background with all types of excel models and any type of excel reports. If you choose me to do this job you will feel confident that you request is done with high quality and exact as you expected. I am very polite and benevolent, so you get please communicating with me. Please, let me know if you choose me for this job. Best regards, Alex.
$3.000 USD em 10 dias
5,0 (1 avaliação)
2,2
2,2
Avatar do Usuário
A proposal has not yet been provided
$3.333 USD em 20 dias
4,9 (4 avaliações)
1,1
1,1
Avatar do Usuário
We have a very long experience with MS Office automation (Excel, Outlook, Word, ...) as well in desktop application. Please, take a look at our portfolio. From our own experience, with your requirements, it is not a light weight project, and you must expect a lot of back and forth discussions, and the schedule may be difficult, if not impossible, to reach. Prescribed medication: must we consider access to some drugs database (online or off-line)
$8.000 USD em 75 dias
0,0 (0 avaliações)
2,3
2,3
Avatar do Usuário
I have previously created a report like this one for financial data integration into a budget modeling tool in excel using VBA.
$3.888 USD em 75 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
United States
0,0
0
Membro desde mai. 20, 2016

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.