×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Construction Management: Excel for Control and/or Reporting

Construction Management: Excel for Control and/or Reporting

Construction Management: Excel for Control and/or Reporting

(OP)
Anyone here use excel for some sort of "integrated control" in their companies/jobs and in a way that permits any kind of reporting? If so, please expand about how you got that going on. If not, please say what where the drawbacks your found that prevented such a use of Excel and about what you use instead.

Thanks.

RE: Construction Management: Excel for Control and/or Reporting

I haven't personally; however, excel by itself probably isn't the tool you're after. Excel linked with Microsoft Access will allow to you create databases for equipment inventorying, cost coding, payable and receivable tracking, and vendor management. Additionally you can create custom forms and data validation objects to control the inputs to your tables. Essentially Access is the database tool running in the foreground, excel will utilize tables (viewable in excel) for the database.

RE: Construction Management: Excel for Control and/or Reporting

(OP)
Managing all the information that could potentially add up in excel when used as a database is indeed problematic. We've been using excel for control of different tasks that don't belong to any particular project to be included in their schedules/programs. We've been doing this for over a month now and just opening the file takes about 15 seconds, so I can't see this becoming manageable in the long term; I'm not very knowledgeable when it comes to databases so I hadn't tought of access but I'll look into it, thanks.

I wasn't refering to that though, but rather to using excel as the interface to make reports by making data consultations of external sources (we're running and MS SQL server).

So please expand in the new light of what we've commented.

Thanks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources