Annulé

Excel VBA Project

Also, please confirm if you have the skill to handle the application

and

the

> time you expect it will take to finish tasks 2-4. The developer who

has to

> pass the job due to a family emergency will be available for

questions by

> email, so please email a list of whatever you need to know to get

this

done.

>

>

> Below are:

>

> 1) Notes from the developer having to pass along the job

> 2) The original description of the tasks to be done

>

>

> ***************************************************

>

> From the developer:

>

> > Here is what is in the file:

> > Step 1 (Issues) - removed Approach and Maturity columns, added

Priority

> > column, updated colors and fonts to match new pages

> > Step 2 (Stakeholder Issues) - created the worksheet, updated the

Jump To

> > menu and Main form to go to this worksheet as step 2

> > Step 3 (Modes and Sectors) - created the worksheet, updated the

Jump To

> > menu and Main form to go this worksheet as step 3, updated Step 4's

Back

> > button, enabled sorting if you click on the underlined headers

> > Position Map - I tried putting a listbox in each box to allow for

> > scrolling. This worked for display, except if you had the Main

menu

> > displayed first, it would somehow overlow the listboxes unless you

> > clicked on Refresh. I haven't been able to track down what this

Excel

> > bug is and how to workaround it, so I returned it to the way it

was.

> >

> > I think I included one or two help popups. I'll doublecheck

tomorrow

> > and see if I can send some more.

> >

> > What needs to be done:

> > The Prepare_to_publish and Import procedures need to be updated to

> > populate the new worksheets. The modRecordMaintenance needs to

update

> > the new worksheets. The new worksheets need to update the

Stakeholder

> > worksheet. This is all of that data integrity stuff that wouldn't

be

> > necessary if this was a real database. The Goa/Issue headers on

the

> > Sectors and Modes sheet need to be VLookups instead of hardcoded.

> >

>

> Additional notes from the developer:

>

> The code modules are fairly well laid out, so I think a strong

developer

> could take over and complete the remaining work. The named ranges

are

> also very logical and easy to get a grip on. The steps are just

rather

> involved. For example, from the Modes&Sectors page, you need to

> 1)update any existing stakeholder records (Stakeholder worksheet)

then

> 2)insert new stakeholder record rows (stakeholder worksheet) if new

ones

> were added then 3) update the list of stakeholders on the

> StakeholderIssues page. You also need to do error checking like

> removing empty rows (users might leave those in between data rows),

and

> generating an error if the stakeholder name is not entered, but a

sector

> is assigned. For even more data security, I'd recommend doing things

> like limiting the scrollable area so users can't be adding stuff at

> random spots on the worksheets. So it's fairly detailed stuff you

neeed

> to do for the updates.

>

> I did some work, but the next developer will probably need to

> go back and redo some of that since I started on the update logic,

but

> didn't complete it. The logic is complex enough it'd be better if

> he/she had a fresh start on that.

>

>

> ************************************************

>

> Tasks from client as well as a clarification of Task 4b:

>

> Task 2: Change Issue's Column Label to Coke Prioritization Levels

> - Update column label and test

>

> Task 3: Enhance Position Map

> - Modify font so that names are easier to read, possibly larger font

and

> alternating colors?

> - Add scroll bar for large lists

> - Test printing and different screen resolutions for best fit

>

> Task 4:

> Overall these are more complex layouts.

>

> 4a: Combine steps 2 & 3

> - Create new form

> - Add code to auto-populate cells from keystrokes and correctly move

to

the

> next step

> - Send mock-up to client for review, make any requested

modifications, and

> test

>

> Task 4b: Update step 4

> I'm not sure I understand this task. It says "We want to move a

couple of

> buttons off the current Step 4 and create a new UI for them." Which

buttons

> are we moving off of step 4? The mock-up seems related to the

General

Info

> tab. Is the idea to get all of the fields in the General Info tab to

a

> different screen? If that is the case, then would the user see it

before

or

> after the current step 4?

>

> To clarify:

>

> A) Today, on Step 4: Database, in addition to free form text fields

for

> info, there are 3 other fields to assign values to this stakeholder

group.

> 1) Sectors, 2) Modes of Engagement, 3) Highest Priority.

>

>

> B) Task 4B, also designated by the General Info tab in the Conceptual

> Mock-ups excel file sent to you, is to create separate UI for the

user to

> designate this particular information. We figure it will look alot

like

the

> UI you create for Steps 2&3, just to give the user a consistant UI to

work

> with).

>

> The reason we are making this a separte UI v.s. just having you add

it to

> Steps 2&3 UI is bcs my product mgr tells me theswe topics need to be

focused

> on separately for some reason.

>

> The user would see this 2nd UI after the 1st UI you are creating -

ie.

Steps

> 2&3

Compétences : .NET, Traitement de Données, Administration Système, Visual Basic, Bureau Windows

Voir plus : what levels, work values, we excel, visual basic developer job, vba work, vba with, ups job application, ups application, track description, sorting logic, security logic, review bug, reason job change, project work example, priority one, original client, net developer job description, need net developer description, mock data, me excel, match skill, match list, logical position, laid work, job excel skill

Concernant l'employeur :
( 0 commentaires ) Starkville, United States

N° du projet : #45168