Đã Đóng

MS Word & Excel Documentation Preparation

We wish to automate our current MS Word Document Preparation Process.

Our current process is to

1. Enter data (e.g. name, address, assets, liabilities, income, expenses) into our purpose built MS Excel 2007 spreadsheets

2. Press a button in excel that opens a purpose built MS Word 2007 Template

3. The data entered into excel is automatically populated into the word template by us pressing Ctrl A then F9

4. Using Quickparts in MS Word where we have stored all our purpose built document insertions (e.g. contents, graphs, tables, etc) we add the required insertions throughout the Word document

5. We then manually edit the insertions until there are complete

We have designed the MS Word Template for a single person, and also another Template for a couple... All of the insertions have also been designed for either a single person or a couple

What we would like to do is automate the manual process of selecting the insertions and pasting them into the required sections throughout the MS Word template.

Our Thoughts on the Design... We were thinking that while in MS Excel (after data entry) we would select the required MS Word template to be used, and also select the required insertions (with the insertions being automatically inserted throughout the Word template in their required sections).

We would then press a button on MS Excel which would open MS Word with the template pre-populated with all the data and the selected insertions in the sections where they arte required.

We are open to how best to design this...

In terms of the MS Word Template there are different sections throughout the document where we are required to paste the insertions. Below are the (6) main sections of the Template where we are required to paste the insertions

- Executive Summary
- Important Information (i.e. name, address, dob, kids, assets, liabilities, income, expenses are listed in this section)
- Goals & Objectives (a summary of the goals & objectives the client wishes to achieve are listed here)
- Risk Profile (a description & graph of the client's risk profile is inserted here)
- Advice to You (all recommendations are inserted here)
- Analysis & Projections (all calculations & projections are inserted here)
- Appendix (all appendices are inserted here)

In terms of the insertions, they are purpose built MS Word sections saved into Quickparts that contain information about a specific topic and also include tables, graphs and excel spreadsheets.

As we prepare documents for either a single person or couple, most of the insertions have been designed/ set up for either a single person or a couple. There are approx. 60 individual insertions.

It is important that the insertions selected to go into the MS Word template are pasted into the correct sections and are also pasted in the order in which they are selected.

I have attached a MS Word template sample to review (please ignore the colour boxes up the top of the page)

Kỹ năng: PHP, Kiến trúc phần mềm

Xem thêm: excel document preparation, quickparts, word of press, word in press, where are graphs used, what is manual data entry, what are graphs used for, what are graphs, name and address template excel, how to automate data entry in excel, how are graphs used, design thinking process, data pressing, data entry in excel 2007, best graphs for data, best graphs, best excel spreadsheets, arte design, another word for design, documentation preparation using excel, document preparation word excel, add pasting, data entry word excel, what is a word template, what is a entry word

Về Bên Thuê:
( 0 nhận xét ) Caroline Springs, Australia

Mã Dự Án: #1612241

9 freelancer đang chào giá trung bình $1567 cho công việc này

spcinc

I can do it!

$2500 USD trong 10 ngày
(9 Đánh Giá)
5.1
Krusche

We would be ready to program the solution according to the best practices of the software development. Please check the PMB.

$1500 USD trong 7 ngày
(3 Đánh Giá)
4.5
Nhcuong

Hi, I can do it in very flexible way. You can design templates as your like and simply input keywords in them, so you dont even worry about fields editor. Then you can configure the keywords list in the excel and gene Thêm

$1500 USD trong 10 ngày
(4 Đánh Giá)
3.6
Puhek

Hello! I've done a lot of excel automation in the past. This is not a very hard task but it does involve a lot of laborious coding. Please check your messages for further discussion. Best regards, M.

$2000 USD trong 21 ngày
(2 Đánh Giá)
3.0
CAZimmermann

I have automatized process using Excel since 1998, when I helped Ericsson Brazil to automatize its process. I'm ready to start.

$1500 USD trong 5 ngày
(1 Đánh Giá)
3.0
mrbrave

Hi...I have Good experience of developing tools for generating word document from excel....Please check your PMB for one of my advanced sample..

$1600 USD trong 15 ngày
(6 Đánh Giá)
2.8
tejisingh90

please give me this I m sure your satisfaction with my work 200%

$1500 USD trong 5 ngày
(0 Đánh Giá)
0.0
imti007

Expert in Ms word & Excel..Very much professional...

$1500 USD trong 11 ngày
(0 Đánh Giá)
0.0
Rifky25

PL SEND THIS PROJECT

$2000 USD trong 20 ngày
(0 Đánh Giá)
0.0
greatwarrior

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you....thanks !!!

$1500 USD trong 10 ngày
(0 Đánh Giá)
0.0
shagoon2u

VBA Experts are ready to start immediately.

$1500 USD trong 10 ngày
(0 Đánh Giá)
0.0
alezyy

Expert in Ms word & Excel

$1500 USD trong 5 ngày
(0 Đánh Giá)
0.0