DIV_E_Word Help (current code version 2014-05-26)

This word version of Form E offers enhanced functionality, self-calculation and expandable fields. You must have macros enabled for the DIV_E_Word document; when they are enabled, the form will produce a Oyez DIV_E Menu Bar (see below).

Input options

The backdrop of the form is protected. You can TAB between fill-in fields, as in OyezForms.

Where the form asks for your client's interest in an asset (sections A, B, C, D etc.), you can enter a percentage (i.e. 50%), and the correct monetary value will be substituted in the field.

Entering a non-numeric term (e.g. 'TBA') into a t votal field will render it inert.

To add a row to a table, you must use the TABLE>ADD ROW + menu option. Version 2013-11-11 allows extra Children to be so added.

Boosting performance: the responsiveness of the form will depend on the capability of your PC, but you can enhance performance by selecting VIEW>NORMAL in the standard Word menu. This will prevent pagination calculation as you are filling the form.

 

Compatibility between Word versions

This form was authored in Word 2003. It will work with Word 2003, 2007 and 2010. If you modify the form in Word 2010 and a user will subsequently open it in 2003, be sure to check the 'maintain compatibility with previous versions of Word' check box.

 

Menu Bar Options

This menu contains various sub-menus. In Word2007+, the command bar will appear in the 'Add-Ins' tab on the ribbon bar; in Word2003 it will appear as a floating command bar that can be docked.

Navigate

The NAVIGATE menu offers 'Jump To' navigation to all the major sub-sections of Form E. Simply select the section you wish to navigate to.

 

Sub-Sections

For continuity, you can duplicate sections 2.2 Property, 2.5 Life insurance, 2.11 Business interests, 2.13 Pensions, 2.15 Earned income, 2.16 Self-employment by selecting SUB-SECTIONS>DUPLICATE SUB-SECTIONS.

Any duplicate sub-section can be removed by putting the text cursor within it and selecting SUB-SECTIONS>DELETE SELECTED SUB-SECTION.

 

Tables

ADD ROW + / DELETE ROW -. Where a table allows additional rows to be added (e.g. C1,C2,C4, etc) you can use these options to add rows for extra capacity. You can also remove rows from tables. Rigid sub-section tables (e.g. 2.2 Property, 2.5 Life insurance etc) do not allow additional rows.

CLEAR SELECTED TABLE'S VALUES. This will remove all inputted values from a table. In the case of tables that allow rows to be added/removed (e.g. C1, C2, C4, etc), the table row count will also be reduced to 6 rows. You can subsequently add new rows to deepen it.

 

Actions

SWITCH OFF AUTO-CALCULATION. Toggling auto-calculation. By default, the form will calculate figure work every time you enter a new fill-in field. Users of slower PCs have the option to switch this off by selecting this option . When auto-calculation is supressed, you can manually trigger form calculation by selecting CALCULATE FORM. Auto-calculation status can be set on a form-by-form basis (version 2014-05-26+)

CREATE ONLINE CLIENT QUESTIONNARE New online option for your client to input infomation about their assets and income online, and for you to merge it into the word document. Click here for details

INCOME NEEDS > 3.1.1 > DUPLICATE CURRENT COSTS TO FUTURE COSTS copies values from current cost column to future cost column. If a value already exists in the future costs column, it is retained.

INCOME NEEDS > 3.1.1 > MERGE STORED 3.1.1 INCOME NEEDS LIST will merge into section 3.1.1 a stored list of income needs. Initially, this will be a default list supplied by Oyez, but you can amend this and then store the amended list for subsequent re-use (see below)

INCOME NEEDS > 3.1.1 > EXTRACT AND STORE 3.1.1 INCOME NEEDS LIST will take whatever list of income needs is currently in section 3.1.1 and store it for future re-use by merging (see above).

INCOME NEEDS > 3.1.2 > as per 3.1.1, above.

CREATE ... > SCHEDULE OF ASSETS SPREADSHEET creates an .xls spreadsheet containing sub-totals A, B, C1-5, D1-2, E, F, and G. B, E, and F are broken down to individual assets. These are totaled downwards into a Grand Total. The spreadsheet contains 'Husband', 'Wife', and 'Joint' columns that cross-total.

CREATE ... > CHRONOLOGY generates a fresh word document containing key dates that have been inputted into the Form E

MANAGE CURRENCY CONVERSIONS this dialogue enables the form to convert non-sterling figures. Currency values can be set on a per-form basis.

Anticipated use:

  1. User sets up to 6 currency symbols, and associated conversion ratios to the pound, that they wish to use on the form. They then click UPDATE SYMBOLS/RATIOS FOR THIS FORM
  2. Where appropriate, user enters numeric values prefaced with designated currency symbols. The form retains symbols and values, but totals in pounds.
  3. When required, the user may subsequently update conversion ratios by repeating step 1, above. The form will update totals automatically.
  4. Finally, user clicks REPLACE SYMBOLS THROUGHOUT FORM. All symbols are removed, and values converted to pounds.

Windows 7 users can access live currency exchange data by right-clicking on the Desktop, selecting Gadgets, then selecting the Currency Icon.

CHILD BENEFIT produces a dialogue listing all children and the associated child benefit. You can select which values on this list are totaled and added to section 2.18, 'state benefits'.

 

SET SELECTED TEXT'S FONT SIZE resizes all of the text content in the currently selected fill-in field

APPEND TEXT FIELD TO CURRENT SECTION allows user to append a text field for ad-hoc notes etc.

MARK UNUSED TABLES 'NOT APPLICABLE' checks first field in each assets/liability table and, if empty, inserts 'not applicable' into that field to denoted the table is not relevant to the case.

RESET STRIKEOUT FIELDS re-instates default strike-out text in sections 1, 3.1.1, and 5 of the form.

REMOVE PAGE NUMBERING deletes auto-numbering of pages from the foot of each page.

 

PREFERENCES displays the preferences dialogue.Here, you can choose to delay the menu initialisation until the form has fully loaded. This is useful if macros are present in your normal.dot template. Contact support for further advice. You can also choose to format totals with pence displayed.

CODE VERSION enables support to see exactly which release of the form you are using.

ONLINE HELP brings you to this page.

 

Useful Links

Para 2.3

http://www.xe.com/currencyconverter/

Para 2.4

http://www.londonstockexchange.com/prices-and-markets/markets/prices.htm

Para 2.8

http://www.glass.co.uk/

Para 2.13

http://www.direct.gov.uk/prod_consum_dg/groups/dg_digitalassets/@dg/@en/@over50/documents/digitalasset/dg_180317.pdf

http://www.dsdni.gov.uk/retirement_pensions_forecast_form.pdf

Para 2.15

http://www.hmrc.gov.uk/calcs/nice.htm

http://www.hmrc.gov.uk/calcs/paye.htm

Para 2.18

https://www.gov.uk/browse/benefits

https://www.gov.uk/calculate-your-child-maintenance

 

Contact Us

If you have any suggestions to improve this form please email support@oyez.co.uk .

 

Maintaining compatibility with previous word versions on save

 

Update Log

2014-05-29

Auto-calc now defaults to On for newly created documents.

2014-05-27

Online help file edited, separate 'sueful links' item in help menu of form.

2014-05-26

Auto-calculation status (enabled/disabled) is remembered on a form-by-form basis.
Exported schedule of assets spreadsheet, chronology, now have court information on header.

2014-04-23

Editorial update to accomodate same sex marriages
Also, bug fix: replacing currency symbols now works on table cells with more than one field.

2014-03-19

Bug fix for online questionnaire data merge.

2014-01-04 ACTIONS>APPEND TEXT FIELD TO CURRENT SECTION created.
This allows a user to add an ad-hoc fill-in field under the current input table for additional notes etc. This may have a knock-on affect on pagination.
2013-11-11 Ability to add/remove extra Children now added (max 50).
2013-06-27 Change to Reachout engine
bug fix: footer on pages 21+ now display page number.
2013-06-02 Debug xml file output removed from reachout.
General information/Statement of truth: cross-out clauses optimised for editing
Option to control display of '£' sign in totals (ACTIONS>PREFERENCES)
Fill-in fields for Miscellaneous notes removed from foot of each duplicatable section to aid pagination
Option to remove page numbering on document (ACTIONS>REMOVE PAGE NUMBERING)
2013-05-03 Descriptive bookmarks added to sections 1 and 5 for external data targetting
Online Client Assets and Income Questionnaire with data merge-back facility added (subscription required)
2013-04-23 Code version dialogue now cantains template path.
2013-04-18 Fix: Total A now appears in Summaries section.
2013-04-16/7 Fix for % calculation
Extra notes fields against value fields in duplicatable sub-sections
2013-04-12 ACTIONS>SET SELECTED TEXT'S FONT SIZE added
ACTIONS>MARK UNUSED TABLES 'not applicable' added
Code now only reads fill-in field's content cell
2013-04-02 Bug fix in Child Benefit calculation.
2013-03-22 Total fields will now remain inert if any non-numeric term is entered into them. (eg 'TBA', 'na')
ACTIONS>PREFERENCES now has option to format totals with pence.
Additional table rows are now blank, they do not contain text from row above.
Currency Conversion now accommodates up to 6 currencies.
Document can be unprotected (password: oyez)