Home
Introduction
PromOffice Brigadir is useful for building supervisors/contractors to keep track of building maintenance. Track separately, in detail, each area of expense, fix the performance, look for defects, create work schedules, distribute material and assign personnel. The program can also analyse the income and expense and prepare a client cost estimate.
Backup coping/data base restore
Basic concepts
In program following terms are used:
Search in table – information search in the table without change of total of records
Filter – information search in the table by means of reduction of quantity of records. Keep records corresponding the certain condition.
Work
«Work» tab - plan necessary works on object: make the list of
works with names, amount, your prospective quotations.
«Distribution» tab - assign work to personnel: appoint works,
specify quotations of executors.
Materials
«Delivery» tab - make the list of necessary materials: names,
suppliers, real procurement prices (its not shown to customer).
«Expenses» tab - make the list of the materials used in work:
what from the put materials are used, the prices are represented the customer.
Personnel
«Main list» tab - enter the information on everyone who on you
works.
«Employed on project»
tab - specify who from the main list works on the chosen object: with
quotations, tariffs, salaries.
«Time sheet» tab -use the electronic sheet.
«Debts» tab - analyse that who has run into debt money.
Explication
«Explication» tab - draw contours of rooms: where that is, walls,
floors, ceilings, ets, the sizes, the areas, volumes. That then all to
recollect.
Stuff
«Main list» - the list of the equipment on project: a shovels, a
stretchers, graters, cranes, the compressor etc., all this with expenses and
for what is bought, employed.
Money
Expenditure» tab- record where there leave money: to whom, for
what, how many.
«Receipts» tab -
record monetary receipts: payments ets.
System requirements:
- OS Windows 95/98/Me/2000/XP
- screen 800x600 hi-color (16 bit) and more
- processor 486
- 32 Mb RAM
- 15 MB free space on disk
If the program is not started, setup a component for access - Microsoft Data Access Components (MDAC). Find here http://microsoft.com/data
Licence
PromOffice Brigadir – organizer
of the building contractor.
© Al Piscuno, 2005
All copyrights to PromOffice Brigadir
are exclusively owned by PromOffice Software.
· The PromOffice Brigadir software -
only for HOME use and may not be rented or leased.
· The PromOffice Brigadir may be used,
with exceptions noted below, provided the distribution package is not modified.
No person or company may charge a fee for the distribution of
PromOffice Brigadir without written permission
from the copyright holder. The PromOffice Brigadir
may not be bundled or distributed with any other package without written
permission of the copyright holder.
· PromOffice Brigadir IS DISTRIBUTED "AS
IS". NO WARRANTY OF ANY KIND IS EXPRESSED OR IMPLIED. YOU USE AT YOUR OWN RISK.
THE AUTHOR WILL NOT BE LIABLE FOR DATA LOSS, DAMAGES, LOSS OF PROFITS OR ANY
OTHER KIND OF LOSS WHILE USING OR MISUSING THIS SOFTWARE.
· You may not use, copy, emulate, clone, rent, lease, sell, modify, decompile,
disassemble, otherwise reverse engineer, or transfer the licensed program, or
any subset of the licensed program, except as provided for in this agreement.
Any such unauthorized use shall result in immediate and automatic termination
of this license and may result in criminal and/or civil prosecution. All
rights not expressly granted here are reserved by PromOffice Software.
· Installing and using PromOffice Brigadir
signifies acceptance of these terms and conditions of the license.
· If You do not agree with the terms of this license You must remove
PromOffice Brigadir files from your storage
devices and cease to use the product.
Thank You for using PromOffice Brigadir.
Technical support
Web:
E-mail:
If it is necessary to change terms, names, messages of
the program according to your specificity, edit a file Lang.ini in a program
folder. Keep only service symbols %s, %d.
If the program is not started, setup a component for access - Microsoft Data Access Components (MDAC). Find here http://microsoft.com/data
Instructions manual
This program is divided into some parts.
At top two horizontal panels: the panel of the main menu, below the control panel.
The left part contains group-choosing windows: a project choosing window; a window of the menu; a window of batching; a notepad.
The average part is presented by the information panel with several tabs. The quantity, the name and information on this panel depends on object and kind of the information.
The right part contains control panel for data operating. Structure of control panel depends on tab you choose.
The bottom part – a line of a condition. In the informative line shows actual point at present
Set font
To set size and color of font choose Setup next Font
Menu
Menu contains:
File
Save as – save marked block of the table in file of certain disc
Save data base backup coping – save current file of database on another disc
Data base restoring – restore current database (saved disc file).
Print – preliminary viewing of a printed fragment
Exit – exit the program
View
Open Menu window
Open Tab Group window
Open Notepad
Open Calculator
Work – open «Work» tab group
Materials – open «Materials» tab group
Stuff –open «Stuff» tab group
Money – open «Money» tab group
Defects – open «Defects» tab group
Reports – open «Reports» tab group
Safety – open «Safety» tab group
Table setting – open table setting form
Find – open table data searching form
Editing
Cut – cut out the text in the buffer of an exchange
Copy – copy marked text in the buffer of an exchange
Paste– inserts the text from the buffer of an exchange
Choose all – mark all tables
Setup
Font – set font
Rate of exchange – put in current values of exchange
Convert all/ (dollars,euro,u.e.) – convert all d corresponding currency
Help
Help – call of the help under the program
About Program – information about program
Data operating tab
This tab is a combination of data viewing and searching table and form for data editing.
[v] Button shows inputting record list.
[…] Button shows corresponding directory of the records list, which you can.
Data editing is possible only in form not in table.
Control panel
There is control panel with the set of different operations on the right hand of each table.
<Start> - place cursor on the first record
<Previous> - place cursor on the previous record
<Next> - place cursor on the next record
<End> - place cursor on the last record
<Add> - add new record
<Copy> - add copy of current record
<Delete> - delete current record
<Print> - print marked block of table or account
Price editing panel
Price editing panel (right foot corner) consist of:
Denomination
| Information
| Extra scope
|
Quantity | Quantity of work units, material, the size of the rate, etc. | The help with the remainder information
|
Unit | Unit of work measures, material, etc. | The list with not repeating values |
Cost | Monetary estimation of unit | Costs of similar positions information |
Sum | The general monetary estimation of all units | 1 Sums of similar positions information |
Currency | Monetary unit type | Exchange rates and choice of currency by default |
Confirmed | The logic label sometimes necessary for reminding and analyzing |
|
In calculation | Attribute of presence of work costs, material in calculations, balances |
|
Inputting date | Not edited field automatically established at date of record |
|
Data search
Data search in table is possible in two ways:
Choose the column, type the first symbols of a line and cursor will automatically move on demanded record.
Press Ctrl-F or in Find (the right key of the mouse) or Main Menu - View – Find (having caused data search window).
Data search does not reduce total of records in the table.
Choose data filtering for reduction.
Data filtering
The first (after title) line of the table – line for inputting of filtering conditions.
.Filtering of records allows to reduce total of records up to reasonable limits.
Ways of filtering:
List conditions choosing
Choose demanded condition from the list. You can edit this record.
Manual inputting
Condition line looks:
[Operator1] Operand1 [)] [AND|OR Operator2 Operand2 [)] ]
where OperatorX is one of = , <> , != , > , < , >= , <= , ~ , !~ , in (
OperandX – number, date, line or for the operator 'IN' the list of the values divided by comma
E.G.: '1' '>=1' '>1 AND <=5' '~ TestStr%' '!~ TestStr_'
'in (1,2,3,4,5,6) and >100'
'in (Str1,Str2,Str3)'
Special form using (for date). Choose Menu – Date filtering.
Data sorting
Sorting allows to build records by way of increase/decrease of the first symbols of a line
.
To open classification you need:
In table: press heading of a column
In table: press the right key of the mouse – Sorting on increasing (decreasing)
In form: View – Table setting
Data batching
Data batching helps to analyze it.
Use batching this way: find not repeating values in column, count, and put in this information in special Batching window.
To open this function:
In table - press the right key of the mouse – Batch on this column
In form - View – Table setting
Set table
To open table form editing you need:
- Popup menu – Table setting
- Main Menu - View – Table setting
- Tool panel button
This form helps:
- Make columns visible\invisible
- Change sequence order of columns
- Make columns for grouping + grouping order
- Make columns for sorting+ sorting type (increasing, decreasing) + sorting order
Exchange rate
For recalculation of sums and prices in various kinds of currencies, it is necessary to establish their current rates. Choose Setup – Exchange rate and put in current values of dollar and euro.
You can also change currency denomination and currency by default (in the foot of the form).
Project selection window
Project selection window contains project list. It includes some additional information.
E.G.,
Project: Wall st. 1 app.2
- January
- Preparations for repair
- February
- Export of waste and garbage
.
When you choose the project, in all tables corresponding information is set. If the information in the table depends on chosen project, then at the top of the table there is an informative line with the name of the chosen project.
Group coping of works and materials is possible. For this purpose, choose in the table some records by means of arrows + buttons <Shift>, <Ctrl>, or mouse.
To use mouse you need:
Guide the cursor at an extreme left part of the table (mark column), till arrow, next mark the record by the left key of the mouse. Choose the project (it is possible to copy in the same) press [ < ] button at the panel. Thus, it is convenient to type records in new project, copying them from typical project.
«Work» tab group
«Works» tab
The table of works contains the list of works on the chosen project.If point in calculation is marked, then the sum for work is present at a report, estimates and other calculations.
Sum = Price * Extend. Group coping of works is possible too.
«Allocation» tab
The table of allocation of works allows storing the information on the executed work of each person; it helps to make feature payments. Besides the table allows to analyze an overall performance of people and not to make double payment for the same works.
«Balance of works» tab
Table contains the list of works on the chosen project + personal work allocation information.
«Materials» tab group
«Delivery» tab
This table contains the list of bought, ordered, stolen by you, and taken in a duty materials, etc.
If material has been delivered to project and has been paid by the customer, but in the strange image this material suddenly appears on another your project, it means another delivering and it should be put in the list of delivery to another project. Material sum is not shown the customer here. Group copying is possible. (IDH_270).
«Expenses» tab
The table of material expenses shows the list of the material used on chosen project. Material cost is different here then in “Delivery”. Cost of spent material is shown the customer in the estimate. A difference between the put and spent material – your margin
«Balance» tab
The table of material balance shows summary data of put and spent material used on chosen project. Shows the rests of material, the average margin.
«Sorts» tab
«Manufactures» tab
«Manufacturers» table contains the list of manufacturers of building materials and services.
«Delivery condition» tab
It contains delivery condition table.
«Explication» tab group
It is very difficult to remember all elements of project,
their sizes, an arrangement etc.
«Explication» tab
The tab "Explication" consists of the list of project
elements, scheme of elements, and the parameters form.
The list of elements contains also the information on parameters of an element
and total values on the columns, necessary for planning works and delivery of
materials.
Scheme consists of two types of graphic elements: a contour and a label.
The contour is represented by some broken line without an inscription. It is
convenient for a designation of rooms, balconies etc. where it is important to
view an arrangement and the sizes. The label is simply a shortcut with an
inscription. It is quickly gives learning about purpose and assignment of an
element and its name.
Each scheme's element can appoint a picture (to specify a path on a disk, for
example, to a photo). The picture can be chosen, removed, looked and, a
checkbox click - to not look at all a picture.
For adding a contour all over again it is necessary to choose it in the form
and then to outline points on scheme. The line becomes isolated if you get on
one of already existing points of an element. If you want not closed line,
press button " Esc ". To change a contour line, appoint the cursor on one of
cornter points and drag. If it is necessary to shift a contour, simply drag.
For addition of a label is simple enough to choose it in the form, and it will
appear on the screen, then it is possible to move in the necessary place a
mouse.
«Parameters» tab
The tab "Parameters" consists of two dependent tables: tables of parameters and tables of units. The table of parameters allows to group units.
«Personnel» tab group
«Employed on project» tab
The table contains the list of people involved on project.
Besides, for each person it is possible to define a kind and the size of payment:
Sum = Labor rate Õ Value.
«Time sheet» tab
If you have stuff with a time wage, you need time sheet – a sheet of the working days and an operating time. Choose Menu – Time sheet. At the top part of the table, there is a current date. Time sheet is positioned for current date automatically. First two columns with surnames and status are not scrolled across, the others are scrolled. For viewing the sheet for other date simply, choose the necessary date from a calendar at the top of the table. In Hours put in only figures, put in information in Notes.
«Main list» tab
The table contains the full list involved people. Not only builders, but also all the contacts you need.
E.G.:
Customer, driver, all your well connections.
«Status» tab
The status allows to group contacts.
The table below shows summary data by the month.
«Stuff» tab group
«Main list» tab
Table contain list of equipment, tooling and another values which stuff is responsible for (on each project).
«Types» tab
Table shows all types of equipment.
«Money» tab group
«Expenditure» tab
This tab contains table of expenditures (payments and sum information).
«Receipts» tab
This tab contains table of receipts (incomings and stuff information).
«Balance» tab
This tab contains balance list.
«Defects» tab
This tab contain table of defects (questions, problems), it helps to backtrace customer’s demands and requests. These points can be lost during work, often by customers.
Reports
You can make different reports with your data base. Choose Reports. In this tab choose report points you need. Account is forming for each project. The heading will show you the name of the project.
You can safe account results in text files, tab divided files and html – files.
Remember: If point in calculation is not marked this note won’t be in accounts.
Safety
Sometimes your information is confidential, so you can make limited access. You can set your password to enter the program. Choose Menu - Safety. Put in name and password then Apply till «Name and Password are changed». When you start program next time there will be an inquiry of the name and the password. If you forget your password you will have to send your data base to the program’s author to decode it. To make free access choose Safety and leave all the points clear then Apply till «No password and free access? « Choose Yes.
Backup coping and data base restore
To save data and to fix work on each stage you should make backup copy of database (Brigadir3.mdb file) on another disk. Choose File-Safe data base backup coping - Folder and put in name of a new file. You can make data base restore in the same way.
ATTENTION! When you restore data base current data will be replaced by previous saved data.