Project Controls International

FPSO and Topsides

West African Costs

Basis of Estimate

(procedures)
(analyses)
(white papers)

 

         Project Knowledge = Success

                    

www.projectcontrolsinternational.com

Que$tor Estimates

(white papers)

www.projectcontrolsinternational.com    |   contact: jorge.alberch@gmail.com   |   check me out at

Home

 

Analysis

- Construction Unit Costs

- FPSO and Topside Costs

- Offshore Fabrication Costs

- Welding Consumables

 

B.Dev./ Contracts

- Contracts: Quantum Meruit

- Guide to Business Acquisition

- Proposal Development

- Relationship Building

- Video: LATTE (Starbucks)

Mind Maps

- Estimating

- Planning

- Schedule Development

- Schedule Maintenance

- Risk Management

 

Procedures

- Constructability

- Document Management

- Estimating Process

- Project Claims and COs

- Project Controls

- Project Execution Plan

- Project Execution Strategy

- Contract Synopsis

Scheduling

- Basis of Schedule

- Number of Schedule Activities

- MS Project vs. Primavera P6

- Planning and Scheduling

- Schedule Extension of  Time

- Typical Primavera P6 Settings

- Updating a P6 Schedule

- Video: Liquidated Damages

- Why Your Project will be Late

 

Courses

- Construction Estimating

- Estimating Course

- Planning and Scheduling

White Papers

- Basis of Estimate

- Communicating Effectively

- Construction Escalation

- Earned Value Management

- Estimating Productivity

- Evaluating Change Orders

- International Multipliers

- Nigerian Content Development

- Project Execution Plan

- Project Risk Contingency

- Project Variables

- Que$tor Estimates

- Risk Analysis Spreadsheet

- Risk Breakdown Structure

- Risk Management

- Spreadsheets vs Databases

- Starting the Project

- Why Project Controls

- Work Breakdown Structure

Interesting Stuff

- Programmable Robot

- Pipe Dimensions and Weights

- Concurrent Database

- LibreOffice Base vs. MS Access

- SharePoint Database

- SAP vs Oracle ERP

- Free Unit Converter

- Motivational Food for Thought

- Passionate about Meetings?

- Video: Project Controls

 

 

Contact Us

- Bio

- PMC Consultancy

Setting up LibreOffice with H2 as the Database Engine

 

Have you ever wanted to have your own “in-house”/ “home-made” database shared with your work colleagues allowing them simultaneous (concurrent) read/ write access to the database? If so read on.

 

This is a very interesting project that allows for concurrent multi-user database access, with the data residing locally in the network. It uses LibreOffice base as the front end and H2 as the backend database engine.

 

(By the way, the H2 database is an amazing database engine: it’s got a tiny footprint, amazing firepower, extremely easy to use and a thorough documentation that’s impossible not to love).

 

This setup is ideal for small teams working with databases concurrently. Check the below link for more detailed instructions.

 

http://www.oooforum.org/forum/viewtopic.phtml?t=164295

 

 

Update:

 

We’ve been using the database at the office now for over a year with up 6 concurrent users and it’s been working beautifully. I’ve dedicated a small clunky PC tower (however this step is optional, as you can also use your own computer/ laptop) as the database server (running H2). Also I connect to it if necessary (for example for a bi-weekly reboot) via a remote desktop application (e.g. TeamViewer). This database setup works really well and is ideal for a small office/ team environment with a data-centric focus.

 

I believe that many more people would create concurrent databases with this set up if they knew how. If you need a bit of help with your set-up feel free to send me an email and pending time availability I’ll try provide some assistance.

Concurrent Network Based Database

Meetings

Love them or hate them. How to conduct successful productive meetings.

Funny, but true. Video on the functions of Project Controls.

Enjoy!

Settings do matter: pick the wrong settings and your schedule’s output will be meaningless.

What the text books didn’t tell you
Primavera P6 Settings
Video - Project Controls

Selected Articles

Tips on Scheduling

50% Science, 50% Art, 100% Communication

Why Project Controls?