I regularly come across Owners (DOD and non-DOD) who run Job Order Contracts and other IDIQs in spreadsheets…or at least try to do so. I will come right out and say, it can’t be done efficiently, nor does the approach provide for an appropriate level of management/oversight. I’d love to hear your thoughts on the topic. Is it lack of education? Mismanagement? Other?
Certainly spreadsheets have many advantages over manual methods, however they fall way short of what a database application such as e4Clicks Project Estimator has to offer.
Is your spreadsheet difficult to use and maintain?
Do changes made in one spreadsheet force you to make changes in another?
Can you see all pertinent data on one screen or do you have to keep scrolling or open other tabs?
Can you easily update prices, quantities and other data elements in a single location?
Are estimates hard to find because they are buried in a confusing collection of folders and directories?
Does your spreadsheet automatically generate a series of reports and/or populate a government form?