Back to All Channels
37d 9h

Material takeoff-Quote Mapper

Hello All,


I am building a program that you can import your RFQ material list into it and a supplier quote to it and, it will map all the supplier pricing to your materials.


This also gives you the ability to teach it what other vendors call items vs what you may call it.


Future versions of this will allow you to add other suppliers to the same project so you can compare pricing.



by show of ๐Ÿ‘, how many people would find something like this useful. What would be things you would like something like to be able to do?

Shawn M 37d 9h

the more you teach the program, the more it will map without asking you to approve it.

Is this a price leveler?

๐Ÿ‘1
Shawn M 37d 9h

It's not yet as it only supports one supplier at the moment. But yes. I could have it do that when more than one supplier is added. I could program it to create an additional list of materials and give you the best prices from each supplier.

ahhh this is nice, and would it sync automatically with your list items?

Shawn M 37d 9h

If built directly into ZZ, I'd say yes. That could easily be done. Then it would be much easier to tell the program to map the price to the item in ZZ.


Right now, it lives outside of ZZ but It would not be hard to code it into it once it is a bit more polished.

Also, then there wouldn't be a need to import a xlsx.

Well done Sir! Can i reach out to understand a little more what you are working on?

Shawn M 36d 11h

I'll get back to you on that for sure!

Shawn M 33d 8h

I made some updates to the program over the weekend. It now supports multiple Vendors, Exports both Side by side on a material report, and also consolidates your material and tells you who has the best price for each item and tells you how much you are saving per item. I am currently working on bringing this into ZZ.



Edit: It's not limited to 2 Vendors. It can support quite a few.

Shawn M 29d 15h

I added another feature, if you add a suppliers quote and they have multiple prices for the same item, The program will now tell you which items have different unit prices.

I'm doing a process piping takeoff right now. The struggle bus I would see with this is getting my zztakeoff database setup to match supplier quotes.

Shawn M 29d 13h

You teach the program what you call an item and what the supplier calls it. as time goes on, the program learns the supplier and won't ask you to teach it anymore.

๐Ÿค”1
Shawn M 29d 13h

I'm trying my best to get this implemented into ZZ but, I am struggling because I need certain JS files for it to run and currently Dev mode does not allow html code to grab those files.

@Shawn Are the JS files you need publicly available on https://cdnjs.com? If so, we can duplicate them over into our servers to make them available for you. The reason our Dev Tools don't allow referencing external JS files is just for additional security.

๐Ÿ‘1๐ŸŽ‰1
Shawn M 29d 9h

let me check. Thank you.

Shawn M 29d 8h

https://cdnjs.cloudflare.com/ajax/libs/pdf.js/6.2.108/pdf.min.mjs

https://cdnjs.cloudflare.com/ajax/libs/pdf.js/6.2.108/pdf.worker.min.mjs


I need these two please !!!!!


Delete this post if you don't want to keep it here!

๐Ÿ‘1

No problem. We copied these into our list of available libraries. You can try this to load the PDF.js library.


<!-- Load PDF.js 6.2.108 (zzTakeoff replaces {{libs}} with the plugin-libs CDN URL) -->

<script type="module">

ย import * as pdfjsLib from '{{libs}}/pdfjs-dist/6.2.108/pdf.min.mjs'

ย pdfjsLib.GlobalWorkerOptions.workerSrc = '{{libs}}/pdfjs-dist/6.2.108/pdf.worker.min.mjs'


ย // Make it available to the rest of your component

ย window.pdfjsLib = pdfjsLib

ย window.dispatchEvent(new Event('pdfjs-ready'))

</script>

๐Ÿ”ฅ1๐ŸŽ‰1๐Ÿ‘1
Shawn M 29d 7h

Thank you so much Herber!

๐Ÿ‘1๐Ÿ™‚1
You must be logged in to post replies. If you don't have an account you can signup here.