REAL ESTATE INVENTORY SYSTEMREAL ESTATE INVENTORY SYSTEM

Training Seminar - September 12, 2011, Bucharest, Romania

Guidelines on how to work with Guidelines on how to work with the Promise Systemthe Promise System

Part I - Part I - Configuration of the Configuration of the Inventory System Inventory System Part II Part II – Recording Estates in the – Recording Estates in the Inventory System Inventory SystemPart III Part III - Demonstration of Tools - Demonstration of Tools for calculating financial for calculating financial indicators indicators

2

Part I - Part I - Configuration of the Configuration of the Inventory System Inventory System

3

Part I – Content Part I – Content System featuresTerms used in the systemPhases of system exploitation

Installation Configuration – default and additional

optionsRecording real estates

Demonstration of default system Demonstration of additional configuration

options4

Software requirements - serverSoftware requirements - serverInformation system is compatible with Linux

and Windows. It may be installed on every OS that supports PHP and MySQL.

Web server - Apache or IISDatabase – MySQLScripting language - PHP

5

Software requirements - clientInformation system is web based and may be

used with every OS that has web browser with the following capabilities:

HTML and CSS supportJavascript support

6

Real Estate Inventory SystemReal Estate Inventory System Public section– available information for any visitor

Private section – accessible only by municipality experts

Web based system

7

Public section Public section Information about PROMISE projectInstruments for searching in the

database of recorded estates owned by the municipality

Filtering and sorting of the search results

Printing search results and downloading in excel file.

8

Private section (1)Private section (1)DefaultDefault data configuration in the system:

According to the elaborated concept within the project;

Described characteristics and prototypes;English as default language in the system.

Options for additional data configuration:Made only by municipality experts after system

installationCreating/editing/ deleting new characteristicsLanguage translation instrument

9

Private part (2)Private part (2)

Recording Real Estates in the systemPresentation of the linked estates

based on the Inventory Identification No

Instruments for smart searching in the database

Instruments for calculating financial indicators

10

System ExploitationSystem ExploitationSystem

Administrator User 1User 2

Installation Installation System administrator in the municipality

is responsible for:Installation of the system on a municipality

server. The system will be available for installation on a disk and is web based.

Management of user profiles and rights.Additional data configuration in the system,

according to the municipality requirements and needs.

Translation of the system interface using language translation instrument.

12

Prototypes – a set of characteristics, describing a property type. Default prototypes – 2 (land and entity)

Characteristics – basic units of information in the system

Groups of characteristics – similar characteristics could be assigned to a group

Data types– used in characteristic description during configuration

Inventory Identification Number – linking between estates is a result of automatic analysis of the IIN of each estate.

Terms used in the system Terms used in the system

13

GROUP 1

RelationsRelations

GROUP 2

LandLand EntityEntity

Data TypesData Types

Characteristics Characteristics Cadastral

Nr

Address

Building Permit Date

Surface

City

LOCATION

Entity PrototypeEntity Prototype

VALUES

Inventory Identification NrInventory Identification Nr

18

Default system configurationDefault system configurationThe system is configurated, including:

Prototypes – 2Characteristics – more than 70

Groups of characteristics - 23

19

Additional data configurationAdditional data configuration(1)(1) Performed by an authorized user directly in the system by entering the „Configuration” menu. The process of configuring the data is prior to the estate recording. This is the reason why some of the configuring functions will not available in the process of recording the estates.

20

Options for data configurationOptions for data configuration(2)(2)

Creating/Editing/Deleting of: Characteristics Groups Prototypes

21

Inventory System PrototypeInventory System PrototypeDemonstrationDemonstration

http://promise.bgnet.biz/ username: testusername: testpassword: test1password: test1

22

Part II Part II – Recording Estates in – Recording Estates in the Inventory Systemthe Inventory System

23

Part II – Content Part II – Content Recording Estates in the systemServices offered by the systemPublicly available information and services

Demonstration of recording estates

Demonstration of public part 24

Estate RecordingEstate RecordingSystem

Administrator User 1User 2

Recording EstatesRecording EstatesRecording Estates is done by a user in the municipality with granted access to the system by using options under menu Estates.Estates.

26

Options Options (1)(1)Describe and record an

estate in the systemPrint the record of the

described estateEdit characteristic of

recorded estate

27

Options Options (2)(2)Review the history of

characteristic data changed by a user

Relations between estates based on the IIN

Review and search in the list of recorded estates

28

ESTATE RECORDINGESTATE RECORDING

29

EDITING AND EDITING AND SEARCHINGSEARCHING

30

Search in the databaseSearch in the databaseSearching in the list of recorded

estates is available through applying the following filters:

Inventory Identification NumberDescription Both – IIN and Description

31

Part III Part III - Demonstration of Tools - Demonstration of Tools for calculating financial for calculating financial indicatorsindicators

32

Constant ValuesConstant ValuesInvestment cost Investment of acquisition cost

Discount rate or required rate of return

Nr of years of the cash flow33

EntriesEntriesChanging every year New values are filled in the system for each year

Participates in calculating the financial indicators

34

Financial EntriesFinancial EntriesLeasable areaUsed areaAreaAnnual rentOther incomeManagement fees UtilitiesSuppliesMaintenance and

repairsRecoveries

35

Exceptional Maintenance Costs = K1 + K2 + K3

Market priceMarket rentTotal capital investedTransaction expensesEmployeesNet usable areaEnergy consumedIC – Investment CostIAC – Investment

Acquisition Cost

Financial IndicatorsFinancial IndicatorsAutomatic calculated in the system through formulas including constant values and entries.

Calculated values are presented in a table and in a graphic

Print of the tables and graphics

36

Inventory System PrototypeInventory System PrototypeDemonstrationDemonstration

http://promise.bgnet.biz/

37