conspiringfate
New Member
- Joined
- Feb 20, 2006
- Messages
- 2
I am looking for someone who can help me do the following....
MONEY IS INVOLVED
PROJECT 1:EXCEL and VBA
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
mike
MONEY IS INVOLVED
PROJECT 1:EXCEL and VBA
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
mike
