Ojasvi Software Private Limited
ESTA12 Engineer’s Sensible Trusted Armament
Software for making Estimates
Useful for Engineers and Contractors Contractors
Ojasvi Software Pvt Ltd 106, Jamna Apartments, Sector-9, Rohini, Delhi –110085 Tele-fax: 011-27297960,27894314, Mobile: 9868153512
[email protected], www.ojasvisoftware.com
Caution Note We have taken efforts to the best of our skill and knowledge while feeding Data in to Esta 12 the users are advised to consult the official documents before pursuing data related action. It is notified that Ojasvi Software Pvt. Ltd. will not be responsible for any damage or loss to anybody arising out of any error or omission in this version.
Minimum Hardware and Software Required
License and Disclaimer Notice You are not permitted to copy the software and other files on other disc and can not modify them in any manner whatsoever and can not claim any right over the same.
changes in the present edition or revises the present edition at any time without having to notify any person or department. may
also
be
variations
in
the
software
and
documentation because of changes and improvements to the software after printing.
Ojasvi Software Pvt Ltd believes that the Data integrated in the Software is correct. All the data’s have been fed very carefully and checked very-very carefully, but Ojasvi Software Pvt Ltd will not be responsible for any mistake whatsoever.
Pentium IV CD-drive
Ojasvi Software Pvt Ltd reserves the right to make
There
Hardware
512 MB RAM 100 MB of free Hard disc space Laser/ DeskJet/ 80 column dot-matrix printer
Software Window XP and onwards
Installation of Esta 12 To install the Esta 12 you must have CD-Disc drive (Refer to previous page Minimum Hardware and Software Requirement) Place the CD of Esta 12 in your CD-Drive, we assume that D: drive is your CD-Drive. Please do as follows • • • •
Click on My Computer and then “D” Drive Double click on “SETUP”, and then follow the instructions. In case of controversy click on “IGNORE”. In case there is a file already in your computer then retain the older file.
After successful loading a shortcut of Esta12 will be placed on desktop. On clicking shortcut, registration form will open as b elow.
1) Fill the form and click on button on “Save” and then “Exit”. 2) Restart the Esta and click on button “Activation Code”, you will be taken to our website automatically as shown on next page. 3) Click on browse/choose, go to C:\Esta12\UserData\ EstaUserCode, select the file EstaUserCode, then click on button “Register”, you will get the activation code as shown on next page in 2nd photo. 4) Copy activation code and paste it in newly opened registration form as shown on next page and then click on Button “Activate”. After successful activation login window will be opened. 5) If computer is not connected to internet, the copy EstaUserCode file from folder C:\Esta12\UserData in pen drive, visit other computer having internet, visit our website at www.esta.co.in/esta12 and repeat step (3) & (4)
Extra Item Statement
Sequence of Operations
Multiple Extra item statement can be prepared by selecting the items in the same manner as in estimate. The Market rate analysis can be prepared for extra items similarly as in estimate.
All operations have been arranged as per the procedure adopted by the Public Works Departments and other Engineering Departments in the following sequence:
Substituted Item Statement
1. 2. 3.
Multiple Substituted item statement can be prepared by selecting the agreement item to be substituted and then the item by which it is to be substituted. The Market rate analysis can be prepared for substituted items similarly as in estimate
Deviation Statement The Deviation statement is automatically generated and can be printed for every running bill and final bill.
Preparation of Estimate. Market rate analysis and justification statement. Schedule of quantities (Schedule of Work) for percentage rate tender / item rate tender. 4. Preparation of comparative statement of tenders received. 5. Selection of tenderer for agreement. 6. Running account bill. 7. Extra item statement with market rate analysis. 8. Substituted item statement with market rate analysis. 9. Part Rate Statement. 10. Cement Consumption statement. 11. Final account bill. 12. Deviation statement The above sequence can be by-passed with a super password if needed specifically.
To Start ESTA
Preparing Estimate
To Operate the Esta 12 the steps to be followed are as under. •
Double click on the shortcut of Esta 12 on desktop screen or Click on START, PROGRAM and then Esta 12 in sequence. Login window as shown below will open on the Screen.
•
Enter the Password. (“user” and “kp” are pre set passwords)
•
Press Enter or Click on the button OK , Esta12 will open for use.
•
The window screen has a menu bar with following menu.
By default Esta12 opens in Estimate Window. If other windows are opened, then by clicking on Estimate in menu bar Estimate Window will opens as below.
There are five buttons in 2 nd menu bar. The functions of each are as below. i)
New: To create new estimate click on button New in 2 nd menu bar, a text box will be visible on the 2 nd menu bar itself. Type the brief name of project/ work and click on Save. A new window named FORMAT will open. Feed full name of work, cost index, contingencies etc and click on Save. By clicking on Close you will go to item selection window. Details of selection of items are given on page 23
(i)
Master Data: To add or modify the sub heads, items and materials in Master Database.
(ii)
User’s Specific: To Add or modify User’s specific information i.e. stamps to be printed on reports, analysis constants, bill constants, list of working contractors.
(iii)
Utility: Options to set default database, to incorporate latest changes in DSR, to change Password.
ii)
Delete: Clicking on button Delete, will delete the estimate already selected.
(iv)
Estimate: To prepare statement, bills etc.
iii)
(v)
Help : To get help.
Export: Clicking on button Export, will export/transfer a copy of the estimate already selected to the destination defined i.e. CD/backup file.
(vi)
Exit : To close the software.
iv)
Import : Clicking on button Import, will import/receive a copy of the estimate from the destination already defined i.e. CD/backup file.
v)
Exit : Clicking on button Exit will close Esta 12.
estimate,
justification,
comparative
All estimates in Esta12 are shown on the main screen of estimate window. Last created or opened estimate will be set as default and will be opened by clicking on button bar “Estimate” in left column.
Click in quantity column of main estimate window and type the quantity one by one. The data entered will be saved automatically. •
To open other estimate just click on Estimate Id (brief name of estimate) in list of estimate on main screen and then click on button bar “Estimate” in left column.
Add from Est: If items from other estimate are to be copied then click on button “Add from Est” in main estimate window.
Item Selection for Estimate Clicking on “Estimate” button in left column a window as shown above displaying selected items if any, will open . If new estimate is created the form will be blank i.e. having no items. The functions of all buttons in this form are detailed as under. •
Add from DB: Clicking on button “Add from DB” will open a further new window displaying all sub heads of default database in grid on left side and all items of 1st sub head in a grid in middle of screen. Clicking on any other sub head, the items of that sub head will be displayed in middle grid. To select the items click in square box in left side of items in middle grid one by one and then click on button “Save”. To add item from other sub head click on that sub head and select the items similarly by clicking in square box before the item and then on button “Save”. All selected items will be added in estimate. After selecting all items, click on button “Close”, the current window will be closed and main estimate window will be visible.
A new window as shown above will be opened showing all estimates in drill down in 2nd menu bar and displaying all items of selected estimate. Click in square box in left side of item in grid one by one and then click on button “Save”. All the items in estimate can be selected just by one
click on button “Select All”. After selecting all required items click on button “Close”. The current window will be closed and main estimate window will be visible. •
•
Add from Esta 2007: It is possible to add items from estimate prepared with Esta 2007. If it is required then click on button “Add from Esta 2007” in main estimate window. A new window will be opened. Select the estimate by clicking on Browse and then button “Ok”. All Items of selected estimate of Esta 2007 will be added in this estimate of Esta12. Measurements: To feed detail measurements of item, click first on item and then on button “Measurement”. A new window will open. Click on button “Add Row” and feed details i.e. location, number, length, weight, height in the grid. Then again click on button “Add Row”, feed details in second row and repeat the steps till all measurements are entered. Total quantity of measurements will be automatically entered in estimate’s quantity column.
•
•
Format: Clicking on button Format opens a window (as shown on next page). Percentage of cost index, contingencies and departmental charges to be added in estimate are entered in this screen. Selection of printing of estimate either with Sub Head or without Sub Head, rounding of estimated amount to Rs 1 or 10 or 100 are made in this window. The editing in name of work can also be done here.
History: Clicking on button History new window (as shown below) opens. The heads of account, history, design & scope, specification, method, rate, time, cost etc are entered in the respective text boxes. Editing can also be done accordingly. History from other Estimate can be copied by selecting the estimate in drill down in 2 nd menu bar from which history is to be copied and then clicking on “Import” on 2 nd menu bar. Clicking on button “Print” will show the print preview of history sheet.
like Education Cess. These changes will affect the analysis of current estimates only. •
•
•
Items for Just: By default Esta12 selects 100% items of estimate for justification. If justification is to be prepared for less items, click on button “Items for Just”. A new form will open in which either you can type the required percentage (say 90) in text box in 2 nd menu bar and click on “Calculate”. Esta12 will automatically select the items having total amount equal to or just more than the percentage entered, adopting the process of selection of item in order of highest amount. Selection of items can also be done by clicking in square box in left most column one by one.
Copy Rates: Clicking on button “Copy Rates” will open a new form to select the station of which rates are to be copied. After selection of station click on button “Copy Rates”, all the basic rates required for current project will be copied from the updated list of basic rates of that location/city/station.
•
View Analysis: Clicking on button “View Analysis” will open a new window showing all analysis of rates of current estimate. The analysis (except carriage) can be printed by clicking on button “Print All”. To print any one analysis select item from drill down of estimate item No and then click on button “Print Displayed”. To print carriage analysis click on button “Print Carriage”.
•
Printing of List of Material & Labour: The List of Material & Labour with market rate and schedule rate can be printed by clicking on button “Rate SR+MR”. The List of Material & Labour with market rate only can be printed clicking on button “Rate MR”.
•
Printing of Justification Statement: Justification Statement can be printed by clicking on button “Just. Stmt”.
•
Printing of Estimate with Market Rate: The estimate based on market rate is automatically prepared and can be printed by clicking on button “Est. Mkt. Rate”.
•
Material & Labour: Clicking on button “Mat. & Labour” will open a new window (as shown on next page) showing total quantity of material and labour required in project based on the analysis.
Update Analysis: Clicking on button “Update Analysis” will update all analysis of this estimate with changed b asic material rates.
Preparing Comparative Statement To prepare comparative Statement, the estimate must be locked. In estimate mode clicking on button “Lock” on 2 nd menu bar will lock the estimate. Otherwise, “Comparative” button bar will not be active. Clicking on “Comparative” button bar in left column a new window will open (showing list of all tenderers, if fed). The functions of buttons in this window are as under.
The functions of buttons in this window are as follows a)
All Material: The complete list all material and labour can be printed for by clicking at button “All Material”.
b) Items with Materials: The list of all items of estimate with individual set of all material and labour involved in items separately can be printed for by clicking at button “Item by Material”. c)
Materials with items: The list of all materials with bifurcation of quantity into items of estimate can be printed for by clicking at button “Material by Item”.
d) 1 Material with items: The list of bifurcation of quantity of 1 material into items of estimate can be printed for by clicking at button “1 Material by Item”.
•
New: Clicking on button “New” the text boxes to feed the detail of tenderer will be visible. Feed Name of Contractor, Address and phone number. Clicking on “Save” will put this contractor in comparative statement and opens a new window to feed quoted rates of contractor. Feed the rates and then click on “Close”. The contractor can be added from master by clicking on button “Add from Master” in left side and then on button “Add” on right side.
Preparing Bills Clicking on button bar “Bills” in left column, a new window will open. If already bills have been prepared, then list of these Bills will be displayed.
•
•
Similarly letter for extension of time, show cause notice and final notice can be printed by clicking on buttons Time Ext., Show Cause Notice, Final Notice respectively. Schedule of Work for Agreement: Clicking on button “Schedule for Agreement” will print the Schedule of Work with Agreed rates.
The functions of buttons in this window are as under. •
New: To create new Bill click on button “New”, a text box with p re-fed date will be visible. Click on button “Save”, a new window will open as below to select items in bill.
•
Open: To open existing Extra Item Statement click in row of extra item to be opened and then on button “Open”, a window showing all items in selected Extra Item Statement. Further any addition or deletion of items can be done as described above.
•
Delete: To delete existing Extra Item Statement click in row of extra item and then on button “Delete”.
•
Justify: To make market rate analysis for items of any Extra Item Statement click in row of required extra item and then on button “Justify”. A window showing all materials & labour involved in items of Extra Item will open exactly similar as in case of justification of estimate. Change of material rates, updation of analysis are to be done similarly as in case of justification of estimate items.
Preparing Substituted Item In new Esta12 multiple Substituted Item Statements can be prepared. Clicking on button bar “Substituted Item” in left column a new window will open. If any substituted item statements has already been prepared then list of these statements will be displayed in the grid.
The functions of buttons in this window are as under. •
•
Print: To print any Extra Item Statement, click in row of that extra item and then on button “Print”.
New: To create new Substituted Item Statement click on button “New”. A text box to enter authority i.e. AE/EE/SE/CE will be visible. After Entering the authority and clicking on button “Save” a new window as shown below will open.
Clicking on “Add Items” in 2 nd menu bar opens further new window as shown below.
Select agreement item to be substituted from upper part of window by clicking in the row (The row will become light blue). Lower portion of window will be filled up with items of same sub head. Now select the item to substitute by clicking in the row of item and then click on button “Substitute”. To substitute other item repeat the above procedure. After selection of all items, click on button “Close” to close this window. In extra items initially DSR rates are taken in all columns of rates by Esta12. Market rate will be added automatically if justification is prepared as detailed on next page under heading Justify. Further negotiated rates can be fed manually in agreed rate column. The calculation will be done with rates in agreed column. Feed the quantity in the column of quantity of both to be substituted and by substituted and then click on button “Save” in 2 nd menu bar. After approval the substituted item statement can be locked by clicking on button “Lock” in 2 nd menu bar. •
Open: To open existing Substituted Item Statement click in row of selected Substituted item and then on button “Open”, a window showing Substituted Item Statement will open. Further any addition or deletion of items can be done as described above.
•
Delete: To delete existing Substituted Item Statement click in row of Substituted item and then on “Delete” in 2 nd menu bar.
•
Justify: To make market rate anal ysis for items of any Substituted Item Statement click at any place in row of Substituted item and then on “Justify” in 2 nd menu bar. A window showing all materials & labour involved in items of Substituted Items will open exactly similar as in case of justification of estimate. Change of material rates, updation of analysis are to be done similarly as in case of justification of estimate items.
•
Print: To print any Substituted Item Statement, click in row of that Substituted Item Statement and then on “Print” in 2 nd menu bar.
User’s Specific Details Clicking on User’s specific in menu bar shows following options are there to feed user’s individual details. i)
Utility Clicking on Utility in menu bar shows following options. i)
Change Default database: There is always a default database. While operating Esta12 sub head and items of default database will be shown by the software. Of course the items of other database can also be taken while preparing estimate. Any database can be set as default database by selecting the desired database in drill down in 2 nd menu bar and then clicking on “Save” in menu bar.
ii)
Update with latest DSR corrections: After purchase or loading of software, if any change in DSR is there, your database can be updated automatically. For it click on “Utility” in menu bar and then on “Update with latest DSR corrections”. A new window will open, select down loaded file (from www.ojasvi.in) by clicking on browse and then on “Ok”. Your database will automatically be updated.
Stamp: In this form you are required to feed your individual details i.e. name of the State, Branch, Division, Sub division. You may feed three stamps to be printed below some reports like detailed estimate.
ii) Analysis Constants: In this form the standard constants used in analysis i.e. water charges, OH&CP (pre-fed as per CPWD) can be changed by the user if they desire so. There is extra provision of two additional constants that can be loaded after OH&CP like Education Cess. These changes will not affect the master database, but will affect the analysis of estimates prepared after these changes. iii) Bill Constants: In this form you can feed the standard deductions to be effected in contractor bills. iv) Contractors: In this form a database of contractors can be created and can be used while preparing comparative statements, avoiding typing/ feeding again and again.
iii) Change Password: Both user and super passwords can be changed by clicking on “Utility” in menu bar and then on “Change Password”. General user can change his password only, while Officer-in-charge can change his password as well as user’s password.
b) Edit: To edit the existing Location/City click on Location/ City in the grid and then click on “Edit” button, do necessary modifications and click on “Save” button. c)
5.
Delete: To delete the existing Location/ city click on Location/ city in the grid and then click on “Delete” button,
Material Rate : Clicking on Master data and then on Material Rate will open a window showing all material by default in a grid showing Material Id, description, unit, DSR rates and market rate (DSR rates are pre-fed in market rate column). Materials, Labour, Carriage, and Machinery can be seen separately by clicking on respective radio button in menu bar. Location/City for which rates to be updated is to be selected in drill down box in 2nd menu bar. Change the rates of material/ Labour/ Carriage/ Machinery in the column of “Market Rates” and then click on “Save”.
6.
Export Database: Clicking on Master data and then on Export Database will open a window having option to browse the location at which database is to be exported. Alternatively you can go to folder where Esta12 is loaded (default location is C:\Esta12). Open “Userdata” folder and copy the file named “master”, paste it at desired location.
7.
Import Database: Clicking on Master data and then on Import Database will open a window having option to browse the location from where the database is to be imported. Alternatively database can be copied from the location where it is, then go to destination folder where Esta12 is loaded (default location is C:\Esta12), open “Userdata” folder and past/ replace the file named “master”.
8.
Export N.S. Item: Clicking on Master data and then on Export N.S. Item will open a new window with all N.S. Items in database. Click in square box in left most column of items to be exported and then click on button “Export”. The selected items are added in file tempDB at location C:\Esta12\Userdata. This tempDB file can be taken to any location including pen drive.
9.
Import N.S. Item: Clicking on Master data and then on Import N.S. Item will open a new window having option to browse the location of file tempDB (in any drive). After selection of tempDB and clicking on button “OK” all available items in will be visible (As shown on next page).
10. Import Item from Excel Sheet: Clicking on Master data and then on Import Item from Excel sheet will open a new window. Clicking on button “Open Format File” will open a formatted Excel sheet. Copy or feed items in this format. Alternatively change format of your Excel sheet similar to this. Save this sheet. In 2nd step click on button “Open Saved File”, select the Excel sheet by clicking on browse and then click on “Ok”. Items in Excel sheet will be added in database. 11. Import N.S. Item from Esta 2007: If you have some items in your Esta2007, you can bring them in Esta12. Clicking on Master data and then on Import N.S. Item from Esta 2007 will open a new window. Click on Browse, select database file of Esta 2007 (civil 2007) and then click on “Ok”. All N.S. items in file of Esta 2007 will be visible in Esta12. Click in square box in left most column of items (one or more) to be imported and then click on button “Import”. The selected items will be added in database.
To import items into database, click in square box in left most column of items to be imported and then click on button “Import”. The selected items are added in database.
12. Import Market Rates (of material) from Esta 2007: If you have some sets of material rates in your Esta2007, you can bring them in Esta12. Clicking on Master data and then on Import Market Rates (of material) from Esta 2007 will open a new window. Click on Browse, select database file of Esta 2007 (civil 2007) and then click on “Ok”. All material rates with name of station in file of Esta 2007 will be added in database. The added locations can be seen in list of location by clicking on Master data and then on Location. Market Rates can be seen in by clicking on Master data and then on Market Rates.
