Excel Work Instruction Template - Excel by ped96069

VIEWS: 1,424 PAGES: 5

More Info
									                                                      Guidance on the WIG Calculator and how to complete it

Introduction            The WIG calculator helps applicants and the FC set out the proposed work, their standard costs, the profile of work and
                        from this will calculate the level of grant that will be offered over the period of the contract. It ensures the latest standard
                        cost rates can be used and updates made more quickly where appropriate.

                        A separate WIG calculator needs to be completed for each WIG fund and for each individual work group or unrelated
                        work item within that fund. For example, an application for WIG SSSI and priority access would normally require 2
                        calculators completing. If a WIG has 7 different work items that are not reliant on one another (i.e. can not be classed as
                        a 'work group' as for example thinning and extraction may be viewed as linked work items) we suggest copying and
                        pasting the appropriate number of worksheets (in this case 7) into the wig calculator at the beginning of the process. You
                        may want to complete details that will remain the same for all the worksheets (for example wig fund, region etc.) before
                        copying and pasting in the new work sheets.

                        To copy the template, right click on the 'Template" tab at the bottom and select "Move or Copy", then tick the "Create a
                        copy" box and press OK. A new sheet "template (2)" will be created. Repeat as many times as is required

                        In order to fill in the calculator, we recommend you first print off the list of standard costs that are on the worksheet
                        "standardcosts" - this will provide easy reference when filling in the work details

                        Applicants need to fill in the yellow boxes on the form and the spreadsheet will identify the standard costs, calculate the
                        total cost and total grant. The Forestry Commission will complete those sections in green. Some of the white boxes will
                        automatically be populated based on what you enter in the yellow boxes. You cannot edit any other part of the form
                        except the yellow boxes

Completing the spreadsheet
Selecting the correct First of all make sure you are using the up to date version of the calculator. The latest version of the calculator is
calculator            available at www.forestry.gov.uk/ewgs-wig, or from your local FC office

WIG Fund                Choose the generic WIG fund you're applying for from the drop down list

Specific fund           Describe the specific fund (if there is one) e.g. "East Midlands Bird WIG", "South West Ancient Woodland Priority Areas"


Property name           Enter the name of the property, which should match form EWGS 1

Region                  Choose which region your woodland is located from the drop down list

Summary of operation Briefly describe why the work is being proposed, what you hope to achieve and any general details of the operation that
/ aims               may be appropriate to note

Work areas (optional) You can fill this in if the project covers most or all of these work areas. If you have completed column 3 of the work
                      details table there is no need to fill this section in

Area of work            This should normally add up to the total area of the work areas affected, unless the work is only happening in particular
                        parts of the work area

Work Details
Code                    Enter the code for the operation you wish to carry out, for example A14 for picnic bench with table, or F1 for stock
                        fencing. When you enter the code, other parts of the table should automatically populate themselves

Quantity                Enter the number of units you propose, noting what units the standard costs use. For example, for 400 metres of fencing
                        you should enter 400; if you propose producing 1000 A4 public access leaflets, these are measured in units of 500
                        leaflets so you should enter a quantity of 2
Work areas affected     List the work areas where each operation will take place. If you have completed the earlier work area section there is no
                        need to fill this in unless you need to highlight the location of particular work

Notes                   Use this section to add brief additional information about the operation

Claim year profile      Pick the claim years you plan to carry out the work from the drop down lists. Enter the percentage against each year,
                        based on when you intend to carry out the work. The total percentage will appear in red unless it totals 100%


Further notes           This section can be used to add any extra information that may be of relevance

Supervision costs       If supervision is required, this should be added as the final work detail, using code "L2" (agent hourly rate)

Timber Income           If there is income from an operation, this should be deducted using the Code "X100" which works in multiples of £100
                        income. Apply the claim year profile as with the linked operation e.g. thinning, coppicing

Spreadsheet results
                        Once you have filled in the yellow boxes, the orange section of the calculator shows:
                        - the total for the whole project
                        - what the grant contribution will be
                        - how the grant will be paid over the 5 years, based on your proposed work profile

                        If the orange section does not present values, it means a section of the form has not been completed fully
                                                                                                                                         Important note: due to system rounding, the total costs and grants may vary slightly, normally by no more than £20.
            APPENDIX A
                                                                                                                                                                                         The amount you will be paid is the value stated in the main contract



         WIG Fund:                                                                     Case ref (FC use):                                                                                                             Sheet number:
                                                                                    Percentage contribution:
      Specific Fund:                                                                                               #N/A
     Property Name:                                                                                 Region:                                                                                                                    Grant profile
 Summary of operation /
                 aims:
                                                                                                                                                                                                        Claim Year            Total Cost              Total Grant
                                                                                                                                                                                                             0            £                -             #N/A
                                                                                                                                                                                                             0            £                -             #N/A
                                                                                                                                                                                                             0            £                -             #N/A
                                                                                                                                                                                                             0            £                -             #N/A
                                                                                                                                                                                                             0            £                -             #N/A
Work areas (optional):                                                                        Area of work (Ha):                                                                                           Total          £                -             #N/A

                                                                     Work Details                                                                       Claim Year Profile
                                                                                                                                             Yr 1    Yr 2       Yr 3       Yr 4       Yr 5
                          Work areas
  Code        Quantity     affected           Std Operation                                Notes                                                                                               total     Cost/Unit                Unit                   Total

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -

                                                                                                                                                                                                                                                  £              -


FC Use only

                                       Claim Year        profile %                                                                   Notes
cost/ha                    #DIV/0!          0            #DIV/0!
adjustment                      #N/A        0            #DIV/0!
GLOS WIG Fund:                  #N/A        0            #DIV/0!
GLOS input Z2:              #N/A            0            #DIV/0!
                                            0            #DIV/0!
                                                         #DIV/0!


                                                                                                       Further notes




                                                                                          291f77c4-bd43-419b-9a75-36e8b1ef4efc.xls
            APPENDIX A                                                                                                                                                Important note: due to system rounding, the total costs and grants may vary slightly, normally by no more than £20




          WIG Fund: Priority access 80                                                                                          Case ref (FC use):                                                                                                      Sheet number:
                                                                                                                                              Percentage
         Specific Fund: East England Quality of Place access provision
                                                                                                                                             contribution:      80
     Property Name: Berry Wood                                                                                                                     Region: East England                                                                                         Grant profile
 Summary of operation / Construction of a new path to improve all ability access to the pic site, and improved amenity value through opening up of views
                 aims:
                                                                                                                                                                                                                                           Claim Year           Total Cost              Total Grant
                                                                                                                                                                                                                                             09/10         £          5,360.00     £            4,288.00
                                                                                                                                                                                                                                             10/11         £              300.00   £             240.00
                                                                                                                                                                                                                                               0           £                   -   £                 -
                                                                                                                                                                                                                                               0           £                   -   £                 -
                                                                                                                                                                                                                                               0           £                   -   £                 -
Work areas (optional):                                                                                                                     Area of work (Ha):        10.00                                                                   Total         £          5,660.00     £            4,528.00

                                                                               Work Details                                                                                                      Claim Year Profile
                                                                                                                                                                                        Yr 1    Yr 2    Yr 3   Yr 4    Yr 5
                          Work areas
  Code        Quantity     affected             Std Operation                                                                           Notes                                          09/10 10/11                            total        Cost/Unit                Unit                   Total
   A1          150          1a, 1b   Footpath construction - light sites      new path linking car park with picnic area, path location indicated on the map                             100                                   100    £          30.00          linear metre       £         4,500.00
   A4            2          1a, 1b     Kissing gate all ability               new gates at car park and picnic area, location indicated on map                                           100                                   100    £         380.00             each            £             760.00
   H1            1             2       Thinning                               thin to open up view from picnic area                                                                             100                            100    £         600.00            Hectare          £             600.00
                                                                                                                                                                                                                                                                                   £                 -
                                                                                                                                                                                                                                                                                   £                 -
                                                                                                                                                                                                                                                                                   £                 -
                                                                                                                                                                                                                                                                                   £                 -
  X100           3             2       Timber Income - units of £100                                                                                                                            100                                   -£        100.00            per £100         -£            300.00
    L2           2            all      Forestry Agent                         for site start up, particularly footpath                                                                   100                                   100    £            50.00          per hour         £             100.00
                                                                                                                                                                                                                                                                                   £                 -

FC Use only

                                           Claim Year             profile %                                                                                                          Notes
cost/ha                  £    566.00         09/10                  95%
adjustment                1.60000000         10/11                   5%
GLOS WIG Fund:               ACES 50            0                    0%
GLOS input Z2:                  90.6            0                    0%
                                                0                    0%
                                                                   100%


                                                                                                                                              Further notes




                                                                                                                                                                                                                                                     291f77c4-bd43-419b-9a75-36e8b1ef4efc.xls
Standard Costs for introduction Spring 2009

  Code                            Activity                  Cost per Unit            Units
   A1    Footpath construction - light sites            £            30.00       linear metre
   A2    Footpath construction - heavy sites            £            35.00       linear metre
   A3    Access gap                                     £            45.00           each
   A4    Kissing gate all ability                       £           380.00           each
   A5    Kissing gate pedestrian                        £           300.00           each
   A6    Stile                                          £           125.00           each
   A7    Dog gate                                       £            55.00           each
   A8    Post and disk waymarkers                       £            30.00           each
   A9    Routed hardwood waymarker                      £            60.00           each
   A10   Interpretation boards A1 size                  £         1,200.00           each
   A11   Notice boards - without interpretative signs   £           350.00           each
   A12   Leaflets A4 size                               £           500.00          per 500
   A13   Leaflets A3 size                               £           700.00          per 500
   A14   Picnic bench with table                        £           530.00           each
   A15   Bench with backrest                            £           410.00           each
   A16   Simple bench                                   £           165.00           each
   A17   Footbridge                                     £           750.00           metre
   A18   Safety inspection                              £            50.00        hourly rate
   A21   Brashing                                       £           300.00          hectare
   A22   Small car park                                 £            20.00      Square metre
   A23   Disabled parking bays                          £           220.00          per bay
   A24   Amenity Post & rail fence                      £            18.00       linear metre
   A25   Bridleway Gate                                 £           350.00           each
   A26   Horse Gate                                     £           400.00           each
   A27   Motorbike restriction barriers                 £           350.00           each
   A28   Footpath steps                                 £            50.00           each
   B1    Small pond creation, normal max depth 60cm     £             3.00      Square metre
   B2    Wood/concrete bird boxes                       £            25.00           each
   C1    Squirrel hoppers                               £            50.00           each
   C2    Hopper Maintenance                             £            80.00     season/hopper
   C3    Squirrel cage trap                             £            35.00           each
   C4    Trap maintenance                               £           130.00           each
   C5    Squirrel blood tests                           £            12.00   per pack of 10 tests
   C6    Deer high seat                                 £           350.00           each
   C7    Deer control                                   £             6.00     Hectare / year
   C8    Vole guards                                    £             0.40           each
   E1    Supply of conifer plants                       £           200.00         per 1000
   E2    Supply of broadleaf and shrub plants           £           400.00         per 1000
   E3    Tree planting costs                            £           240.00         per 1000
   E4    Supply & plant in 1.2m shelter                 £             3.00          per tree
   E5    Supply & plant in 0.75m shelter                £             2.50          per tree
   E6    Supply & plant in 0.6m shelter                 £             2.10          per tree
   E7    Supply & plant in 0.6m spiral                  £             1.40          per tree
   E8    Natural regen respacing / cleaning             £         1,000.00          Hectare
   E9    Weevil spray                                   £           160.00          Hectare
   F1    Stock Fencing                                  £             4.50       linear metre
   F1a   Stock Fencing in SDAs                          £             6.00       linear metre
   F2    Stock & Rabbit Fencing                         £             7.20       linear metre
   F3    Rabbit Fencing                                 £             5.90       linear metre
   F4    Deer Fencing                                   £             7.80       linear metre
   F4a   Deer Fencing in SDAs                           £            10.00       linear metre
   F5    Temporary Deer Fencing                         £             5.20       linear metre
   F6    Deer & Rabbit Fencing                          £            10.00       linear metre
   F7    Deer gate for vehicles                         £           430.00           each
   F8    Hanging Watergate >5m                          £           350.00           each

                                                                                                    EWGS WIG Calculator V1.0 issued xxxxxx
 F9    Hanging Watergate <5m                   £      200.00              each
F10    Field Gate                              £      365.00              each
F11    Badger Gate                             £       50.00              each
F12    Pole Barrier - timber                   £      190.00              each
F13    Pole Barrier - metal                    £      600.00              each
F14    Deer exclosure plot                     £      130.00              each
F15    Stock proofing stone field boundaries   £        2.60          linear metre
F16    Fence removal                           £        0.50          linear metre
 G1    Chemical screefing                      £        0.08               spot
 G2    Scarifying - new planting               £      100.00             Hectare
 G3    Ripping                                 £      125.00             Hectare
 G4    Mounding                                £      125.00             Hectare
 G5    New drains or clearing existing         £        2.00          linear metre
 G6    New drains on restock sites             £        2.00          linear metre
 G7    Maintain drains                         £        1.00          linear metre
 H1    Thinning                                £      600.00             Hectare
 H2    Extraction                              £      350.00             Hectare
 H3    Skyline Extraction                      £       30.00         Cubic metre
 L1    Forest Craftsman                        £      150.00             per day
 L2    Forestry Agent                          £       50.00             per hour
 L3    Tree surgery, 2 + chipper               £      500.00             per day
 L4    Tractor & chipper/flail with 1 man      £      350.00             per day
 L5    JCB hire & mini excavator               £       30.00               hour
 L6    360 excavator                           £       40.00               hour
 L7    Low loader                              £      350.00   to drop off & collect once
 R1    Cat 1a road                             £       60.00          linear metre
 R2    Road maintenance                        £        1.00          linear metre
 R3    Basic access track                      £       15.00          linear metre
 R4    Intermediate Access Track               £       30.00          linear metre
 R5    New culvert                             £       45.00          linear metre
 V1    Tree/scrub cutting <7cm, flail          £      500.00           net hectare
 V2    Tree/scrub cutting <7cm, manual         £      800.00           net hectare
 V3    Tree/scrub cutting >7cm, mulcher        £    1,300.00           net hectare
 V4    Tree/scrub cutting >7cm, manual         £    1,800.00           net hectare
 V5    Chemical weed control 1600+tph          £        0.08               spot
 V6    Chemical weed control <1600tph          £        0.10               spot
 V7    Asulox                                  £      250.00             Hectare
 V8    Stump treatment                         £      300.00             Hectare
 V9    Coppicing >30yrs old                    £    1,800.00             Hectare
V10    Coppicing <30yrs old                    £    1,200.00             Hectare
V10a   Coppicing no value + burn               £    2,400.00             Hectare
V11    Ride management 2 zone                  £      250.00            per km/yr
V12    Ride management 3 zone                  £      400.00            per km/yr
V13    Grass cutting recreation areas          £      550.00       Hectare / season
V14    Path strimming                          £        0.23          linear metre
V15    Rhodo control <7cm, flail               £      500.00          net Hectare
V16    Rhodo control >7cm                      £    2,200.00          Net Hectare
V17    Rhodo regrowth respray                  £      400.00          Net Hectare
V18    Rhodo control difficult sites           £    3,800.00          Net Hectare
V18a   Rhodo control very difficult sites      £    5,000.00          Net Hectare
V19    Ride mnt removal of arisings            £        0.60          linear metre
V20    Woodland hedge management               £        5.00          linear metre
V21    Pollarding mature trees                 £       90.00             per tree

X100   Timber Income - units of £100           -£     100.00           per £100
 Z1    Special Fund - £1000 cost                £   1,000.00        as appropriate
 Z2    Special Fund - £100 cost                 £     100.00        as appropriate



                                                                                      EWGS WIG Calculator V1.0 issued xxxxxx

								
To top