help
hou can i cut and past a dukument my boss give me for you to read
re: help<br><br>you need to get the documents scanned in and sent through to our offices.
its kind difficult to understand in my POV but not impossible  

imagining it while reading


can you show some codes? or samples on what you want to achive? Hi, this would not be possible as clients would not normally let you pass this along, but if you go to Prince2 sites you can get a list of documents they require at the different points in a project.


The list below is what I copied from some where in the distant past,so apologies if i have not got permission or not recognized you as the owner of this list.


<b>Pre-Project;</b>  

<ol>  

Business case  

Feasibility study  

Investment appraisal for projects  

Issue management  

Project life cycle  

Project opportunities  

Risk management  

Sensitivity analysis  

Small project  

Stakeholders -identification-communication-power map  

Terms of reference</ol>


<b>Planning & Starting a Project;</b>  

<ol>  

Approval  

Authorization  

Back-scheduling  

baseline and baselining  

Communications plan  

Constraints  

Critical success factors  

Estimating  

Filing & document management  

Handover options  

Issues management  

Milestones and milestone plans  

Network analysis and critical path  

Objective (s)  

Planning checklist  

Programme or project identification?  

Project life-cycle  

Project opportunities  

Project strategy  

Quality in project work  

Risk management  

Scheduling  

Scope  

Stage or Phase  

Task checklist  

Terms of reference  

Tuning or scaling a project  

Two level planing  

Work breakdown structure  

Work distribution model  

Work packages  

</ol>


<b>During a Project;</b>  

<ol>  

Budget control  

Business case review  

Channel control  

Controlling against schedule  

Decisions in projects  

Earned value analysis  

Filing & document management in a project  

Impact analysis  

Issue management  

Lessons learnt  

Project health checks  

Quality in a project work  

Reports projects and programs  

Request for change  

Risk management  

Stages – start and end procedures  

Task checklist  

</ol>


<b>Closing a Project;</b>  

<ol>  

Closing a project  

Handover options  

Lessons learnt  

Post project review</ol>


<b>Project Organization</b>  

<ol>  

Champion  

Matrix management  

Prince 2 project board  

Responsibility matrix  

Sponsor  

Steering group  

</ol>


<b>Project Finance</b>  

<ol>  

Authorization  

Budget control  

Budgets for project work  

Earned value Analysis  

Impact Analysis  

Investment appraisal for projects  

Benefit realization planning  

</ol>


I have some templates for reports and business cases i can let you have if you need them, but there are many different types and ones which companies use. move on and get over it. maybe you should ask him. hi,

there is no one-fits-it-all framework that you can use. viktor cheng approach is good but oversimplified.  you should be flexible enough to come up with your own approaches and it comes with practice. 

i recommend the following approach:

1) start with "case in point" book - you can download this book for free everywhere. it's not the best guide on how you should approach the cases, however, it will give you the basic understanding.

2) start practicing cases with partners here or find them locally. !!! find experienced partners or coaches who can provide a good feedback!!!

3) purchase and read viktor cheng book (amazon kindle store) and listen to loms (his website). i recommend to reread the book and listen to loms every 15 cases. every time, having more experience, you’ll be finding something new.

4) practice fast math


 learn how to multiply double digit numbers (https://www.youtube.com/watch?v=6ndkkpzyjho)
 learn the division table up to 1/11 (i.e. 5/6 = 83.3)
 learn how to work with zeros (hint: 4000000 = 4*10ˆ6)
 use math tools (mimir math for ios), math tool on viktor cheng website to practice


5) below you can find a list of the most common case types and some high-level recommendations on structuring:


 market sizing - structuring from the supply or demand side. structuring using a formula or using an issue tree
 profitability - basic profitability framework. remember about different revenue streams and product mix
 market context cases (market entry, new product, acquisition, etc). always start with the big picture "market". finish with something specific to the case (e.g. how to enter?"). structure it as if you are defining the work streams for the real project.
 operational math problem (e.g. should we increase the speed of an elevator or just buy a second one? how should we reduce the queues? etc.) - structuring as a process / value chain, with inflows, operations, and outflows
 cost cutting - i provided the recommendations on structuring it here: https://www.preplounge.com/en/consulting-forum/operations-cases-mck-1105#a2134
 valuation - purely financial structure with cash flows, growth rate, wacc / hurdle rate, etc.
 synergies - revenue synergies (price, qty, mix) and cost synergies (value chain).
 social / economics cases (e.g. how to improve the quality of life in the city? how to increase the revenues of the museum?) - huge variability. practice 3-5 social cases before the interview


6) also, i would try to focus on the most common industries in the following priority(sorted by probability of getting a case): 1-retail and cpg; 2-airlines; 3-telecom; 4-banking; 5-natural resources; 6-tech

7) ! important: don't forget about the fit interview part. crafting you stories and backups stories will require a couple of weeks!

ps

here is a good list of articles regarding the different parts of the case:

1) start with clarifying questions:

https://www.preplounge.com/en/consulting-forum/clarifying-questions-1786#a3956

2) communicating while structuring. here is a long post by me on how to communicate the structure during the case study:

https://www.preplounge.com/en/consulting-forum/how-to-communicate-its-structure-for-the-case-study-1313#a2806

3) using hypothesis. i made a post about hypothesis here:

https://www.preplounge.com/en/consulting-forum/how-to-state-a-hypothesis-and-match-to-the-structure-1156#a2268

4) communicating while making calculations: 


 always tell the interviewer your approach
 check with the interviewer that your approach is correct
 come to the interviewer with some preliminary answers
 check your assumptions with the interviewer


5) communicating during the analysis of graphs / tables


 take a minute to look at the graph. read the graph title. look at the graph type and define the type (pie chart, line chart, etc). look at the legend (ask for clarifying questions if necessary). identify whats going on on the graph. look for: trends, % structures. look for unusual things - correlations, outliers,
 make 3-4 conclusions from the graph. think out loud on potential hypothesis on what could be the root cause / what are the consequences
 prioritize the most important for your current analysis and move forward with the case


6) communicating while having questions on creativity


 ask an interview for a minute to think
 think of several buckets of ideas (e.g. organic growth / non-organic growth / differentiation). remember to think as big as possible
 narrow down to each bucket and generate as many ideas as possible
 present the structure (buckets) and then your ideas


7) communicating your conclusion. you can find a good example i've posted here:

https://www.preplounge.com/en/consulting-forum/how-much-answer-first-should-the-conclusion-be-1231#a2493

8) communicating your fit stories

use the top-down approach while communicating your stories. "the pyramid principle" is the must-read by ex mckinsey on this topic.

i recommend using the star framework:


 in situation, you should briefly provide the context, usually in 1 or 2 sentences
 task usually includes 2 or 3 sentences describing the problem and your objective.
 then you provide a list of specific actions you took to achieve the goal. it should take 1 or 2 sentences per action (usually 3-4 actions). note that the interviewer can stop you any minute and ask for more details.
 the results part should have 1 or 2 sentences describing the outcomes. this part is finalizing your story - make sure it can impress the interviewer and stay in the memory.


best! yes for current region you can use a range 
  
something like this 
  

  

  

```
With Worksheets("sheet1")
.range("A1:e10").copy
```

  

  
the dot before "range" is important.
  

  
it will copy only from A1 to E10. modify to suit you you're a bit of a wuss, and not leader material, it seems. tell her to buy you out your share as you can't cope with the job as is. i can do it if you like.:grin: The download is an updated version. watching from our office during a training