180 likes | 336 Views
Todays Presentation. EuSpRIG What Is The Problem? Development Methods Audit Products Model Review (as per Andersen’s). European Spreadsheet Risks Information Group Founded March 1999 Ray Butler (HMCE) , David Chadwick (UoG), Patrick Cleary (UoW).
E N D
Todays Presentation EuSpRIG What Is The Problem? Development Methods Audit Products Model Review (as per Andersen’s)
European Spreadsheet Risks Information Group Founded March 1999 Ray Butler (HMCE) , David Chadwick (UoG), Patrick Cleary (UoW). Symposia: July 2000(Greenwich), July 2001 (Amsterdam), July 2002 (Cardiff) ISACA (2000/2001 sponsor), PWC (2001 sponsor) BCS IRMA, KPMG, Anderson’s Universities of Hawaii, Singapore, Klagenfurt, Calgary, Amsterdam Operis (OAK), Southern Cross Software (Spreadsheet Detective), HMCustoms (SPACE) www.eusprig.org
Development Methods Life-Cycle Stages Visual Aids Programming Languages Model Reviews – see later
Attributes < • new_quantity, old_quantity, new_real_income, old_real_income, demand_change • real_income_change, income_elasticity, good_type • Where demand_change = new_quantity / old_quantity – 1 and real_income_change = new_real_income / old_real_income – 1 and income_elasticity = demand_change / real_income_change and good_type = if (income_elasticity > 0, “normal”, “inferior”” ) ModelMaster Jocelyn Paine Univ. of Bristol
Audit Tools Microsoft Auditing Tool Spreadsheet Professional Spreadsheet Detective (OAK) Operis Analysis Kit SPACE (Spreadsheet Audit for Customs & Excise)
Tools for Audit Spreadsheet Auditing from Customs & Excise • Customs & Excise’s own product • Risk assessment and testing methodology • Software - add-in for Excel • Training • Tests any file Excel can open • Works on copy file SpACE
European Spreadsheet Risks Information Group EuSpRIG 2002 Symposium ‘Spreadsheet Roulette: the hidden corporate gamble' University of Wales, Institute Cardiff Thursday 18th - Friday 19th July 2002 Papers : 5000words Management summaries: 2000 words Camera ready copies by Friday 3rd May, notified of acceptance by 31st May www.eusprig.org