Tools – PME4U

Qld State Government – New Tender and Contract Templates

Post author:PME4U
Post published:March 21, 2015
Post category:Contract Management Contracting Frameworks Probity And Ethics Procurement Policy Procurement Processes Templates Tools
Post comments:2 Comments

As a key component of their goal of making it easier and more efficient for suppliers and agencies to do business with each other, in February this year the Procurement Transformation Division launched a new set of goods and services procurement invitation and contractual frameworks for use by all Government Agencies. If you are a supplier to or a buyer for the Queensland State Government and you haven't familiarised yourself with them yet, then it is high time you did. So what is new and what do we need to know about this new framework?

Advanced Excel Contracts Manager – Generate Unique ID’s

Post author:PME4U
Post published:February 7, 2015
Post category:Advanced Excel Contracts Manager Contract Management Excel Procurement Systems Tools Tutorial VBA
Post comments:1 Comment

A critical function of any contracts and procurement process management solution is to generate a unique identifier for each process and contract. I cannot stress enough how important it is to allocate an identifier to a process and to use it for all communications regarding the process and the contract, both internally and externally. Why? Because loss of clarity in communications can result in regrettable errors. In addition to that, if you are managing more than a couple of processes and contracts, tremendous efficiency is gained when you include a direct relationship between a communication, document, record and a process or contract. Often the ID's are generated manually by looking at the last number used and adding one, but this can result in duplications through accidentally re-entering the same number and potential inconsistencies through data entry errors. You may mean to type CAT-112 and instead you type CAT-121. Nine numbers have been skipped, which can be confusing, and you may have actually recorded CAT-112 on all your documents and folders. So in this blog we'll look at a method in our Advanced Excel Contracts Manager to automatically generate and ID using Excel and a bit of VBA.

Advanced Excel Contract Manager – Protect Your Data

Post author:PME4U
Post published:January 27, 2015
Post category:Advanced Excel Contracts Manager Contract Management Excel Procurement Systems Tools Tutorial Uncategorized VBA
Post comments:0 Comments

It is all well to create a complex list of data, but reviewing, adding and maintaining records in the Excel table format when there are more than a few fields quickly becomes slow and unreliable. End users will complain about having to maintain so many fields, managers will want the data displayed as different forms of information and administrators will quickly tire of trying to fix the errors introduced through poor data entry and accidental deletions. This is where the benefit of the Advanced Excel Contract Manager solution in separating access to and maintenance of the data from the raw data sheet delivers a tremendous advantage over basic spreadsheet tables.

Using Array Variable in Excel VBA to Boost Performance

Post author:PME4U
Post published:December 2, 2014
Post category:Excel Procurement Systems Tools Tutorial VBA
Post comments:0 Comments

The array variable provides an opportunity to significantly boost the performance of Excel in processing large data sets and they are surprisingly easy to use. In a recent project, I implemented an array variable and allowed the code run nearly 10 times faster. If you need to manipulate large data sets and your code is running slower than you would like, take a look at this solution.

Data Provider Built in Excel

Post author:PME4U
Post published:November 15, 2014
Post category:Templates Tools Tutorial Uncategorized
Post comments:1 Comment

I was presented with an excellent challenge by one of my clients a couple of weeks back. They had established a contractual arrangement with twenty providers that contained an effective suite of KPIs for measuring and managing performance, but sadly lacked the ability to capture and report on those KPIs. Next they developed a nifty Excel workbook for the vendors to complete and provide their data, but the workbook was made up of seventeen different worksheets and each was in a different layout designed to make data entry easy. It did not make reporting easy though and the is where I come in.

Managing overload in procurement

Post author:PME4U
Post published:January 18, 2014
Post category:Capability Development Procurement Processes Procurement Systems Tools
Post comments:0 Comments

I have found that generally ten concurrent procurement projects of varying complexity per practitioner is about the upper limit of being able to ensure enough focus is placed on each job. Right now though, with the combination of team members being on leave and the new year projects kicking off, I find myself with closer to 30 concurrent jobs. As I was attempting to review a complex plan, I could see the Outlook popups fading in and out in an almost constant stream. I likened it to sitting in a boat under a waterfall trying to bail it out with a thimble. So what tactics can we use to manage these periods of intense overload?

Advanced Excel Contracts Manager – Overview

Post author:PME4U
Post published:January 1, 2014
Post category:Advanced Excel Contracts Manager Capability Development Contract Management Excel Procurement Systems Templates Tools Tutorial
Post comments:5 Comments

Spreadsheets are a powerful and commonly used tool in procurement. Whether used to track what contracts we have, calculate cost, score evaluations or tracking projects. However, few Excel workbooks in procurement really leverage the full power and possibilities of Excel. With just a basic knowledge of the Visual Basic for Applications (VBA) language, you can turn your Excel workbook, into an Excel Application with functionality you never considered possible in a spreadsheet. This is the first in a series of blogs covering the development and use of an Excel Application to build a Advanced Excel Contracts Manager for managing Contract Lifecycle Management (CLM).

Advanced Excel Contract Manager – Contract fields and validation

Post author:PME4U
Post published:December 23, 2013
Post category:Advanced Excel Contracts Manager Capability Development Contract Management Excel Procurement Systems Templates Tools Tutorial
Post comments:3 Comments

A critical component in building a powerful contract life cycle management application in Excel is to determine what data you want to capture and then taking steps to ensure data quality is maintained. It is always a balance between usability and the need to build meaningful reporting. While using a standard format spreadsheet quickly becomes arduous when there are more than 15 fields of data, the Advanced XL Contract Manager provides functionality that makes capturing a hundred fields efficient and easy. There are the obvious fields such as the contract number, title, description, start and expiry dates. But there are a few fields you may not have thought of. In this blog, we'll start with defining the Contract fields and validation methods to make sure our data stays clean.