Freelancer

Write a program to automatically summarize monthly reports  

Write a program to automatically summarize monthly reports is project number 557580
posted at Freelancer.com. Click here to post your own project.


| More Free Trial For New Buyers
 

Status: Awarded

Selected Providers: subhadippal

Budget: $30-250

Created: 12/30/2009 at 10:08 EST

Bid Count: 63

Average Bid:
$ 126

01/09/2010 at 10:08 EST

Project Creator: jjacobsonm
Employer Rating: (No Feedback Yet)

Bid On This Project
 

Description

We are a long term care company that provides inpatient care to the elderly in nursing home and assisted living settings. Each month for marketing purposes, we track referrals we receive from local hospitals and inquiries from the local community. We have several Excel worksheets we use to track this information. One spreadsheet acts as the master list and contains all of the data for the other spreadsheets. Right now, we are manually taking data from the master spreadsheets and re-typing it in the appropriate area on the other spreadsheets. I would like a program or Excel macro written that will allow us to only enter the information once (on the master spreadhseet) and have it automatically transferred to the other spreadsheets. If you open the attached files, you will see an exmaple. The "Inquiry Tracking Worksheet" is the master sheet in which we type all of the necessary information. The "Marketing Reports" file contains several worksheets (tabs) for the different reports. When you compare the two, you will see all the information contained on each tab in the "Marketing Reports" file is taken directly from the "Inquiry Tracking Worksheet." Please look at information specifically for October 2009. Let me know if this is possible.


Additional files submitted:
Inquiry+tracking+worksheet+-+sample.xls
Marketing+Reports+-+Sample.xls

Messages Posted:12 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

70

3 days

11-24-2009 18:41 EST

I have 10 years of experience in VBA with Excel, Access, Word.

help

 

170

5 days

12-30-2009 10:35 EST

Hello, Please read the PM

help

 

100

2 days

11-26-2009 02:56 EST

This job can be nicely completed with Excel macros, please, see PMB for details! Regards!

help

 

100

10 days

11-24-2009 18:45 EST

Please refer to PM for details.

help

 

150

3 days

11-25-2009 22:45 EST

Hi, I have strong IT background to accomplish the desired quality result. I would also be able enhance the data capture sheet to prevent data entry problems. regards,

help

 

60

2 days

11-26-2009 10:04 EST

Please see PM..

help

 

100

3 days

12-01-2009 13:50 EST

Hi, It will be great opportunity to work on this project. Please see messege board.

help

 

100

1 day

01-02-2010 12:23 EST

I used to work in the investment banking industry in London and performed similar tasks successfully. Rest assured that the job can be done both quickly and efficiently. Regards, Marija

help

 

30

3 days

01-06-2010 02:22 EST

Hi I have experience in developing excel(vba macro and userform ) based solutions.It would be my pleasure to give solution to this problem. It will take a few hours.but I have posted more time to make it a User Friendly ,simple and bug free product.let me show you a demo.If you are satisfied with the final version then only you will pay.

help

 

100

1 day

11-24-2009 17:41 EST

(No Feedback Yet)

Hi! I'm interested in your project and having some ideas. Please see PM for details. Thanks

help

 

75

1 day

11-24-2009 18:21 EST

(No Feedback Yet)

I always do this thing in my work. I want to do this now.

help

 

200

1 day

01-04-2010 04:37 EST

(No Feedback Yet)

I am an Excel developer with four years experience in building best practise VBA and spreadsheet solutions. Looking at your samples, the most effective solution to your problem is to redesign/overhaul your existing spreadsheets so that a macro will not be required. How do you intend to maintain a macro based solution? Even a good macro solution will eventually require adjustment should your business processes change. I strongly advocate that you investigate a solution that you will be able to maintain yourself.

help

 

30

7 days

11-24-2009 19:48 EST

(No Feedback Yet)

please send me

help

 

1000

14 days

11-24-2009 20:44 EST

(No Feedback Yet)

For future reference, the best solution would be a database solution with a custom front end. This would be scalable and modifiable as your business progresses. What you are requesting will work for you, but is not the most elegant solution and will not feel like a finished product. contact me if you have a larger budget in the future or you are interested in a more long term solution.

help

 

65

3 days

11-24-2009 23:16 EST

(No Feedback Yet)

plz provide me details, what columns you want and what result you expect..may be i will be able to show u some sample work on this

help

 

40

6 days

11-24-2009 23:38 EST

(No Feedback Yet)

Respected Sir: I am really interested a lot to join in your team to working with my best quality and Accuracy should be delivered through out my project.I will always update our project details regularly on day-by-day process.I will satisfy our company's requirement in quicker manner.Thanks for spending your precious time on checking my description.

help

 

220

20 days

11-25-2009 00:45 EST

(No Feedback Yet)

Dear sir, Yes we can solve your problem. We can develop a software for you as per your requirment in .Net, where you can enter the master data and generate reports which can be exported in excel,pdf lioke wise. We are IT industry from the last 9 yrs. Give us a chance to serve you. Thanks Have a good day.

help

 

100

4 days

11-25-2009 01:07 EST

(No Feedback Yet)

Hello, I am an MBA(Finance) with corporate experience in financial structuring field. Hence, I am quite apt at making such excel and macro based templates. I can definitely provide you the required. Infact, I am working on quite a few similar projects. So, this project fits right in. Let me know if you would like me to do it. Regards, Shikha.

help

 

250

2 days

11-25-2009 05:18 EST

(No Feedback Yet)

I am interested in your project. I have some ideas in creating you a dashboard with interactive charts and drill downs. If you only want a duplicate of your current tables this can be done using pivot tables. Contact me if you want to discuss this further.

help

 

60

2 days

11-25-2009 05:55 EST

(No Feedback Yet)

Hi, I've just been working on your test file and got it working very well. It uses some pivots and some macros. You enter the data the way you are used to and it does all the work automatically, no need to run macros etc etc. I'll email you a copy. I've put in a bid of $60, when you see the file hopefully you'll think it's well worth it! Any questions please let me know! Thanks, Stephen

help

 

75

2 days

11-25-2009 07:11 EST

(No Feedback Yet)

I am British qualified IT professional and in this field for over 16 years. I have over 6 years data entry and 1 years internet research. My research skill is great. I am also a trained typist with speed and accuracy over 40wpm. In addition, I am connected to the internet 24 hours every day; so timely delivery is guaranteed. I do not like to rush my client's work, Since I am a fulltime free lance professional I can complete the task as soon as possible. I am really very interested in this project because it is what I know how to do best.

help

 

150

2 days

11-25-2009 10:51 EST

(No Feedback Yet)

I will write a vba macro that would obviate the need to input the data twice.

help

 

150

3 days

11-25-2009 11:57 EST

(No Feedback Yet)

I am extremely familiar with excel as I was an accountant for 15 years. I own and operate a computer company with software being my strength. I can do this for you on excel.

help

 

200

5 days

11-26-2009 03:49 EST

(No Feedback Yet)

Hi, We can create a web based programe for the same requirement, i'll host it at my side so there will be no extra annual charges for the same. Regards

help

 

30

2 days

11-26-2009 10:20 EST

(No Feedback Yet)

American VBA programer with 5 years of experience generating Excel-based reports using macros and advanced Excel programming techniques. I would like to build my feedback profile on here, so I am bidding low.

help

 

100

10 days

11-26-2009 11:34 EST

(No Feedback Yet)

Hi I have fair knowledge in macros in excel. Your requirement can be achieved. If you are interested in my bid, lets work together. Viveka

help

 

200

2 days

11-26-2009 13:34 EST

(No Feedback Yet)

Hi, I have sound knowledge in Excel, VB and VBA. Give me chance to work for your. Everything is possible. I have done so many macros like this. Data should be entered some where and those details will capture in my spread sheet. So I think your are also expecting the same.Give me chance i will prove my self. Regards, IQtech

help

 

60

1 day

11-26-2009 22:31 EST

(No Feedback Yet)

Sir, please check PM. Thanks

help

 

50

2 days

11-28-2009 04:34 EST

(No Feedback Yet)

Hello, I work on Excel & Access VBA, daily. I have seen the requirement details and sample files. I can provide single click solution for updating all sheets for selected months

help

 

30

1 day

11-29-2009 12:45 EST

(No Feedback Yet)

Hello, I’m interesting for a long collaboration with your company because I like very mach data entry jobs. Please send me more details about. Have a beautiful day,

help

 

30

1 day

11-30-2009 02:31 EST

(No Feedback Yet)

Please Check PMB for details.

help

 

30

1 day

12-01-2009 14:21 EST

(No Feedback Yet)

Sir i m expert in excel and have a many year experience to create this type of programs. kindly consider me. thanks

help

 

123

5 days

12-01-2009 14:45 EST

(No Feedback Yet)

My degrees are from Pennsylvania State University (Masters) and Bucknell University (Bachelors) in bioengineering, and chemical engineering respectively. There should be no trouble completing the project in the time specified. I am an expert with Microsoft office and many different types of computer programs, software and packages. For a few years I have made numerous presentations to fellow students, professors, and professional colleagues for a number of projects that involved data analysis. Microsoft excel is a very useful program with which I have much experience; some data compilation / analysis projects I conducted include analysis of lung diffusivity coefficients in the artificial lung, design sketches for pumps of the quadrilateral structure for removing diatomaceous earth solutions under high shear rates, laser amplitude readings for curvatized analysis of geometrical force structures, data reintegration of enantiomeric readers under UV spectroscopy for a closed width band, cross-sectional non-distinct tubules under dilative relief flexation, and a computational approach for bi-parallelism fields under asymptotic digression of forms. Each of these projects gave me great experience in organizational data summary. I am well-versed in the following software packages Microsoft Office, Microsoft Project, Matlab, Mathcad, Mathematica, Minitab, Sigmaplot, the laboratory LIMS/LACES data analysis and entry system, the engineering software HYSYS. My skills extend to both IBM/Macintosh systems and I have programming knowledge of C++, and HTML.

help

 

30

25 days

12-02-2009 06:44 EST

(No Feedback Yet)

I have a vast experience of doing jobs like this. Although i am new to the site but you will be satisfied with my progress. I hope you will consider me for the project.

help

 

45

5 days

12-02-2009 07:02 EST

(No Feedback Yet)

Dear sir, I'm interested in this project all of your terms & conditions. I'm confident to perfect delivery about this project. Thanks & regards SHIMUL

help

 

250

10 days

12-02-2009 08:34 EST

(No Feedback Yet)

A highly energetic and enthusiastic individual. Specializing in Information Technology. Accomplished educator with demonstrated ability to teach, motivate, and direct students while maintaining high interest and achievement. Consistently maintain excellent relations with students, parents, faculty, and administrators. Self-motivated with strong planning, organizational and leadership skills.

help

 

100

7 days

12-02-2009 22:32 EST

(No Feedback Yet)

This can be done by VBA Macro in Excel very easily. I have 5 years experience in VBA MAcro and I have done similar type of works for Novartis also. So, it seems pretty easy to me. I would love to work on this. Amount is not a matter for me as I am new in getfreelancer. So, please give a response and hopefully we will work together in near future.

help

 

50

2 days

12-30-2009 11:45 EST

(No Feedback Yet)

Hi, i have 8 years of experience in Excel macros, i can execute your project.

help

 

30

1 day

12-30-2009 11:55 EST

(No Feedback Yet)

hope you will hire me

help

 

50

1 day

12-30-2009 12:04 EST

(No Feedback Yet)

I have great experience in working with Excel and databases and would like to start asap

help

 

150

1 day

12-30-2009 12:51 EST

(No Feedback Yet)

Hi, i can do this.. check your pm

help

 

110

3 days

12-30-2009 12:54 EST

(No Feedback Yet)

Dear sir, I will do the job best with $90. if any one do with less, plz inform me. Regards Rasel

help

 

250

10 days

12-30-2009 12:56 EST

(No Feedback Yet)

Greetings from Strongsville, Ohio! Please see my entry in the Project Clarification Board. Thanks, RandyK

help

 

100

2 days

12-30-2009 13:59 EST

(No Feedback Yet)

Lets start.

help

 

150

5 days

12-30-2009 14:23 EST

(No Feedback Yet)

I am interested in helping you with this task. have enough experiencie preparing reports such as this. Please check my pm.

help

 

200

5 days

12-30-2009 20:04 EST

(No Feedback Yet)

We provide a free sample to you when you issue this project to us then with your approval we can deliverthis project in 5 days and can give online support for 3months on the work we did we a gain tell you we give our best practices to our clients to retain them for future projects so you can relay on us we take care all

help

 

100

14 days

12-31-2009 00:41 EST

(No Feedback Yet)

Hi, I several times did job like this, Let's start.

help

 

150

5 days

12-31-2009 03:59 EST

(No Feedback Yet)

I will try completed this project so plz give me a this project

help

 

90

10 days

12-31-2009 06:19 EST

(No Feedback Yet)

Respected Sir: I am really interested a lot to join in your team to working with my best quality and Accuracy should be delivered through out my project.I will always update our project details regularly on day-by-day process.I will satisfy our company's requirement in quicker manner.Thanks for spending your precious time on checking my description

help

 

30

5 days

12-31-2009 10:33 EST

(No Feedback Yet)

I can make a macro to post entries on the Inquiry Worksheet to Marketing Reports workheets.

help

 

200

60 days

12-31-2009 20:58 EST

(No Feedback Yet)

I work this project very carefully.

help

 

100

5 days

01-01-2010 04:39 EST

(No Feedback Yet)

I am expert in excel and can make this through various farumul. I am able to make many types of MIS as per requirement.

help

 

30

3 days

01-01-2010 06:39 EST

(No Feedback Yet)

Excel Works! ^_______^

help

 

500

30 days

01-01-2010 13:19 EST

(No Feedback Yet)

** please check your pm **

help

 

100

3 days

01-01-2010 17:35 EST

(No Feedback Yet)

Ok. I have 10 years experience in vba and I want to say that I can work this. Thanks.

help

 

100

5 days

01-02-2010 01:39 EST

(No Feedback Yet)

I can develop same project as per your requirement, so please conform me, can I develop & send you.

help

 

30

7 days

01-04-2010 10:06 EST

(No Feedback Yet)

I have been extensively working in Excel and have done similar work. Please send me details ASAP so that i can get this ready for you

help

 

30

1 day

01-04-2010 22:19 EST

(No Feedback Yet)

This is a simply fix - i'd like to do this for you lets talk

help

 

100

2 days

01-05-2010 09:02 EST

(No Feedback Yet)

Yes, this can be done. I have created sales tracking, employee scorecards, financial reports etc for my current employer. All on excel. This is right up my alley. If you give me this project, I will not let you down.

help

 

50

4 days

01-05-2010 14:06 EST

(No Feedback Yet)

i can easily done this work

help

 

50

4 days

01-06-2010 07:40 EST

(No Feedback Yet)

I 'v very interest about this project. I assure best quality and low cost and see me pm.

help

 

350

7 days

01-08-2010 04:44 EST

(No Feedback Yet)

yes, I can provide an excellent macro program. You need to program your spreadsheet with macros to automate the process because its really a burden typing repetitive data. I have experience in macro and VB programming so there is no doubt i can do that. But please understand that this is a one time project specific to your needs so i am charging 350USD. I hope you understand. Best regards, Ian S.

help

 

150

6 days

01-08-2010 09:06 EST

(No Feedback Yet)

Hi I work exclusively on MS Office Automation projects using Excel/VBA. I have gone through the requirements and will be able to automate the generation of three monthly reports required. I will also make the reports look more elegant. Looking forward working with you.

help


    Bid on this Project