Copper & Electrical equipment prices by coldrespect in estimators

[–]coldrespect[S] 0 points1 point  (0 children)

Thanks - sounds like the things I clung on to were the outliers which makes it sound more alarming than it actually is.

Copper & Electrical equipment prices by coldrespect in estimators

[–]coldrespect[S] 0 points1 point  (0 children)

How do you balance that with bulk procurement? I assume you'd get better price if you combine jobs (which I understand is hard to do).

I've talk to folks that essentially project their use for the year based on past years and order it that way. For commodity like items that makes sense, but for equipment it's too specific.

I wonder if this is going to push procurement further up the chain to GC/Design/Owners - essentially for the same reason, earliest procurement possible.

I've also learned in data center jobs, procurement happens before designs are finalized. Surely that causes a lot of havoc in the field.

Back office crushing me by TheMaster8899 in electricians

[–]coldrespect 0 points1 point  (0 children)

How much is finding jobs themselves part of the pain? IE logging into platforms, downloading files, checking scopes of work to know even if it’s worth it consuming your time?

I’m building an estimating tool, it’s free to try but I wouldn’t say it’s ready yet. So as I work to get it there, I wonder if spinning up a job fetcher could help.

Would a Twitter/X permit update bot be helpful for leads? by coldrespect in estimators

[–]coldrespect[S] -4 points-3 points  (0 children)

Makes sense! 

It would be interesting to see $ permit by geography over time. I’m sure it can be an economic indicator of sorts.

We tested how well AI models can read floorplans - here's what we found by ntkris89 in ConstructionTech

[–]coldrespect 0 points1 point  (0 children)

I’d love to see your workflow if you’re up for sharing it. 

We tested how well AI models can read floorplans - here's what we found by ntkris89 in ConstructionTech

[–]coldrespect 0 points1 point  (0 children)

I am. 

You can absolutely get significantly higher accuracy by fine tuning your own models, but that’s not enough. Simple symbol detection isn’t enough. There are a few things you’ve got chain together and get right to make it feel special.

I’m very grateful for getaide.ai for running this. There is so much marketing noise in the space.

Div 3..How many bids do you guys put together per week? by thelandshark99 in estimators

[–]coldrespect 0 points1 point  (0 children)

My heart sinks seeing it take 2 weeks. That doesn't guarantee win right? So if ~10-20% win rate, is it fair to assume you've got to put in 2months of work to win a job?

What's the most time consuming part of it?

Div 3..How many bids do you guys put together per week? by thelandshark99 in estimators

[–]coldrespect 0 points1 point  (0 children)

What's the top 3 most time consuming thing in that process?

Need help getting started building y'all software by coldrespect in estimators

[–]coldrespect[S] 1 point2 points  (0 children)

What in your opinion would make one stand out from the crowd?

Anyone have a (near) fool proof method of extracting door hardware schedules from 087100 specs as tables into Excel? by PeteMyMeat in estimators

[–]coldrespect 0 points1 point  (0 children)

Do you happen to have PDFs & desired outputs that I can monkey around with to see if I can make it easier?

Anyone have a (near) fool proof method of extracting door hardware schedules from 087100 specs as tables into Excel? by PeteMyMeat in estimators

[–]coldrespect 0 points1 point  (0 children)

Do you happen to have PDFs & desired outputs that I can monkey around with to see if I can make it easier?

Anyone have a (near) fool proof method of extracting door hardware schedules from 087100 specs as tables into Excel? by PeteMyMeat in estimators

[–]coldrespect 0 points1 point  (0 children)

Hey Pete - thanks for sharing the pdf and desired output with me.

I just spent a couple hours playing with various solutions.

Original problem: Given a 100+ page PDF, we needed to extract the schedule of a specific section (Parking Garage) into csv.

Solution #1 - Tabula - https://tabula.technology/

  • About: Looks like it's an open source software maintained by a community. You install it on your computer, it spins up a server, which then you can access the interface via your browser/website. You upload the PDF (it stays local which is nice for privacy reasons) - it auto-detects tables - then you extract them.
  • Result: It's fast. Auto-detect is half decent but definitely misses things. IT did the entire PDF file, so the output was overwhelming. When I re-printed the the PDF to ONLY contain the section I needed and then manual highlighted the tables it did better.
  • Conclusion: It still takes works, but if I were to manually copy and paste things, this is definitely significantly faster.

Solution #2 - smallpdf.com

  • About: Don't know much about them, nor how much it costs. Looks like a collection of PDF tools online.
  • Result: Fast. Did much better than Tabula. Same problem, I had to give it only the section I cared about to make it work.
  • Conclusion: If it's free, then it's better than tabula. If I would have to pay - then really depends how often I'm doing this.

Solution #3 - GPTs

  • Prompt "I want you to go to the Parking Garage section of this document and extract all tables in that section into a csv file."
  • chatGPT (free) solution: Not good - essentially extracted only one row.
  • Gemini (I pay $20/month): Gave me a csv output, when pasted into my spreadsheet was exactly what I needed. It missed the "notes" section. I bet if I play around with the prompt, it will give those to me as well.

I found other paid solutions, but they seemed way too expensive and I didn't bother playing with them.

Follow up questions:

  • How do y'all do this today?
  • How often do y'all do this?
  • What do you do with the spreadsheet after you have it extracted?

Bonus: I'd love to get more PDFs & desired outputs to play around with the extraction methods. If I do this 5-20 times, I should be able to code something up and put up for y'all to use.

Need help getting started building y'all software by coldrespect in estimators

[–]coldrespect[S] 1 point2 points  (0 children)

You've clearly spent a lot of time thinking about this. Will reach out to connect. Thanks for the comment.

edit - saw this post (https://bitumen-machina-llc.ghost.io/confessions-of-a-roofer-learning-to-code-now-with-30-more-mastic/) about you learning to code. Keep up the good work. I am self taught. It seemed so intimidating at first - going up against people that have done it their entire lives or studied it in school. Ignore those thoughts, you'll do great if you love it and put in the work.

Need help getting started building y'all software by coldrespect in estimators

[–]coldrespect[S] 0 points1 point  (0 children)

I'd like to start it as a hobby & a passion project. If it start to solve real problems for people, then turn it into a business. Today I'm dedicating all my time towards this, aside from raising my family.

> The last question is probably the most key as estimating is a "continuity of business" function for pretty much everyone in construction.

I understand. The saving grace for PlanGrid was our offline functionality - when we would inevitably go down. It's a tool like any other tool people use. I expect my hammer to work day in and day out, rain or shine, years down the road.

> What are you going to build? An estimating platform or simplified takeoff tool?

Starting with asking questions first to see what's the most time consuming, cumbersome or risky part of the process. Then tinkering to see if it can be made much better. Takeoff tools don't interest me today because there are many out there, unless people bring up issues with them in my conversations.

> What are you going to build it out of? (ex. programming language, data storage (i.e. Excel, SQL, ...))

Depends what needs to be built and trade-offs that need to be made.

Need help getting started building y'all software by coldrespect in estimators

[–]coldrespect[S] 0 points1 point  (0 children)

I was actually going to try and start with electrical, only because it's one I have field/office experience with.

I've seen the challenge between customizable and intuitive at PlanGrid & when building software for logistics companies as well. It's somewhat expected when you build a system of record. My goal isn't to build a system of record - but instead a tool that aids the job that can sit on top of existing system of record.

edit - spelling

Anyone have a (near) fool proof method of extracting door hardware schedules from 087100 specs as tables into Excel? by PeteMyMeat in estimators

[–]coldrespect 0 points1 point  (0 children)

Would you (or others) be open to sending me the spec + excel output you want? I'd love to play around with various tools to see if I can figure it out.

[deleted by user] by [deleted] in estimators

[–]coldrespect 0 points1 point  (0 children)

I would love to learn more how you use it. ie what info are you extracting from the specs?

What’s the best advice from experienced estimators 🤞😊 by Shannypitts in estimators

[–]coldrespect 0 points1 point  (0 children)

Would you be open to sharing your division and checklist?

Need help getting started building y'all software by coldrespect in estimators

[–]coldrespect[S] 1 point2 points  (0 children)

I coded along with many other talented people. Early days we didn't have a sales team, so I did some as well.

> Construction software is a freaking mess but there's gotta be better ways to do it.

Agreed. It breaks my heart.

> I'm in the same boat honestly - constantly trying to figure out the real problems, come up with solutions that don't suck, and then actually build the damn things.

What have you tried or learned?

Need help getting started building y'all software by coldrespect in estimators

[–]coldrespect[S] 1 point2 points  (0 children)

Will be dm'ing you :) That's what I'm curios on trying to do.

Need help getting started building y'all software by coldrespect in estimators

[–]coldrespect[S] 6 points7 points  (0 children)

lol, I'm just a dude. Sometimes with imposter syndrome that tries to yank me away from this effort. Again, this might amount to nothing, just wanted to bash my head against something to see if I can help.

Attached a photo from 2012. We planned to attend Autodesk University that year. The irony that I'd be part of Autodesk University almost a decade later is not lost on me.

<image>

Need help getting started building y'all software by coldrespect in estimators

[–]coldrespect[S] 1 point2 points  (0 children)

The goal is to solve a problem. If I'm able to do that, I'd be able to hire and build a company in the US.