• Søk
  • +47 63 94 20 20
  • Webshop
  • Support
  • Kurs
  • NO
    • English
    • Svenska
    • Dansk
    • Suomi
    • Latviešu
    • Eesti
PLM Group logoPLM Group logoKontakt
  • PLM
    PLM

    PLM-løsninger som dekker alle aspekter innen design og engineering med en integrert arbeidsflyt.

    LES MER
    • ENTERPRISE PLM
    • DIGITAL VALUE CHAIN
    • SUSTAINABLE MANUFACTURING
    • PRODUCT MANAGEMENT
    • SOLUTION
    • VARIANT MANAGEMENT​
    • CROSS COMPANY COLLABORATION​
    • E-BOM MANAGEMENT​
    • ERP INTEGRATION
    • CHANGE MANAGEMENT
    • LIFE CYCLE ASSESSMENT
    TJENESTER
    • VALUE STREAM MAPPING
    • Migrering til 3DEXPERIENCE
    Last ned vår nyeste rapport

    Towards A Smarter Industry

  • CAD
    CAD

    Last ned en gratis Buyer’s Guide to CAD.​

    LES MER
    • PROGRAMVARE
    • SOLIDWORKS CAD
    • SOLIDWORKS ELECTRICAL
    • CATIA
    • DRAFTSIGHT
    • SOLIDWORKS PDM
    • CLOUD SERVICES I 3DEXPERIENCE
    • DRIVEWORKS
    • ØVRIG PROGRAMVARE
    • SPESIALLØSNINGER​
    • FOR OPPSTARTSBEDRIFTER​
    • FOR UTDANNING
    TJENESTER
    • SERVICE PLANS
    • INNOVATION AGREEMENTS
    • 3DEXPERIENCE ONBOARDING
    • Migrering til 3DEXPERIENCE​
    • KURS
    • HostPLM – SOLIDWORKS PDM ON CLOUD
    Velg riktig SOLIDWORKS-oppsett

    Forstå hvilke muligheter du har, og velg det SOLIDWORKS-oppsettet som passer deg og jobben du skal gjøre.

  • CAM
    CAM

    Det er en stor avgjørelse å kjøpe CAM-programvare. I vår ærlige Buyer's Guide hjelper vi deg finne den riktige løsningen til ditt verksted.

    LAST NED GUIDE
    PROGRAMVARE
    • SolidCAM
    • SolidCAM til skoler
    • Kundehistorie: Rasi Maskinfabrik
    • Kundehistorie: IJ Pipe
    • Moduler
    • CAM Assist
    • iMachining
    TJENESTER
    • Prøveversjon av SolidCAM
    • Postprocessors
    • Kurs
  • SIMULATION
    SIMULATION

    Simulering handler om mer enn å sørge for at produktet fungerer. Det handler om å forstå hvordan det vil passe inn i den virkelige verden. ​

    LES MER
    PROGRAMVARE
    • SIMULIA
    • 3DEXPERIENCE Simulation
    • SIMULIA Abaqus Structures
    • SIMULIA CST Electromagnetics
    • SIMULIA Simpack Multibody
    • SOLIDWORKS Simulation
    • SOLIDWORKS Simulation
    • SOLIDWORKS Flow Simulation
    • SOLIDWORKS Plastics
    TJENESTER
    • Simulation Starter
    • Kurs
    • Service plans
  • KUNNSKAP
    KUNNSKAP
    Increase CAD collaboration by using a cloud-based platform

    Få en oversikt over kursene vi kan tilby for deg og teamet ditt.

    SE ALLE KURS
    KUNNSKAP
    CASER​
    • KUNNSKAP
    • Artikler
    • Ebøker
    • Arrangementer og webinarer
    • ABONNER
    • Nyhetsbrev Engineering​
    • Nyhetsbrev Simulering
    • Nyhetsbrev 3D-printing
    • CASER​
    • Enaiblers | 3DEXPERIENCE for Startups
    • RAIKU | SOLIDWORKS for Startups
    • Inha Works | HostPLM
    • SwePart Transmission | 3DEXPERIENCE
    • Satateräs | HostPLM
    • Rollco | 3DEXPERIENCE
    • ALLE CASER​
    KOMMENDE ARRANGEMENTER​
    Arrangementer og webinarer​
    LAST NED VÅR NYESTE E-BOK

    5 Key Cloud Platform Benefits - the Essential Guide for Manufacturing Design

  • KONTAKT OSS​
    KONTAKT OSS​

    HJELP & SUPPORT

    Supportsenter
    Frequently asked questions
    Åpningstider
    09:00-18:00
    Telefonnummer
    +47 6394 2020
    For fjernsupport
    Teamviewer
    ONLINE SUPPORT
    FINN ET KONTOR NÆR DEG
    PLM GROUP
    • Om oss
    • Møt teamet
    • Karriere
  • Søk
  • +47 63 94 20 20
  • Webshop
  • Support
  • Kurs
  • NO
    • English
    • Svenska
    • Dansk
    • Suomi
    • Latviešu
    • Eesti

Eksportere BOM til Excel med CustomTools

BOM_cover2

I CustomTools kan man veldig raskt og enkelt lage stykklister (BOM) i Excel ved hjelp av forhåndssatte eksportprofiler i Excel report. En slik profil kan inneholde en ferdigoppsatt stykklistestruktur, metadata fra SOLIDWORKS og Custom property-verdier som man har definert i CustomTools. Stykklisten kan også inkludere forhåndsvisning av hver komponent med et lite bilde.

Å lage stykklister i Excel er en veldig tidkrevende prosess der feil lett kan oppstå. Mye av tiden går på å knote med strukturen og å fjerne irrelevante oppføringer.

Når man har en sammenstilling åpen i SOLIDWORKS er man bare to tastestrykk unna å eksportere en BOM i Excel. Trykker man på Export i CustomTools-menyen, får man opp en trestruktur over sammenstillingen. Her kan man velge vår forhåndssatte eksportprofil og ekskludere komponenter man ikke ønsker å ha med i BOM-en.

BOM_exportNår man trykker på Export, genererer CustomTools en BOM av sammenstillingen vår i Excel.

BOM_excel_w_preview

Excel report kan også generere tegningslister, reservedelslister og hente data fra ditt ERP-system. Den kan anvendes i flere forskjellige use cases og er svært tilpassbar.

 

Publisert i PLM Group news
Tagger BOM, CustomTools, Excel, Excel Reporting, Export

Relaterte artikler

Related Posts

Export Enterprise PDM BOM to Excel

In Enterprise PDM, out of the box, there is one option to export BOM to excel. That is "Open as a CSV file" option in Bill of Materials section. That is simple and good but does not have many options....

Les mer

Polygonmodeller: Disse mulighetene har du i SOLIDWORKS

Du har kanskje opplevd det før – modellen du ser på skjermen er delt opp i mange trekantede flater i ulike størrelser, som til sammen utgjør noe som ligner på den modellen du forventet å se. I slike tilfeller har du en modell som består av polygoner.

Les mer

3DEXPERIENCE – Hvor begynner du?

3DEXPERIENCE-plattformen er designet for å samle alle avdelingene i organisasjonen din, og gi deg muligheten til å arbeide i skyen.

Les mer
PLM Group Norway
ÅPNINGSTIDER
08:00-16:00
TELEFONNUMMER
+47 63 94 20 20
FOR EKSTERN HJELP
Teamviewer

PLM Group Norge AS

Torvet 6, 2000 Lillestrøm

info@plmgroup.no

+47 63 94 20 20

Design

  • SOLIDWORKS 3D CAD
  • CATIA
  • DriveWorks
  • 3DEXPERIENCE

Simulation

  • SIMULIA Simpack
  • SOLIDWORKS Simulation

Manufacturing

  • SolidCAM
  • SOLIDWORKS MBD
  • SOLIDWORKS Inspection
  • 3D Printing

PLM

  • 3DEXPERIENCE
  • CLOUD PLM
  • Datahåndtering i skyen

Learn and Support

  • Innovation Agreements
  • Kurs
  • 3DEXPERIENCE

Resources

  • Blogg
  • Explore our Resources
  • Cases
  • Åpenhetsloven

Design

  • SOLIDWORKS 3D CAD
  • CATIA
  • DriveWorks
  • 3DEXPERIENCE

Simulation

  • SIMULIA Simpack
  • SOLIDWORKS Simulation

Manufacturing

  • SolidCAM
  • SOLIDWORKS MBD
  • SOLIDWORKS Inspection
  • 3D Printing

PLM

  • 3DEXPERIENCE
  • CLOUD PLM
  • Datahåndtering i skyen

Learn and Support

  • Innovation Agreements
  • Kurs
  • 3DEXPERIENCE

Resources

  • Blogg
  • Explore our Resources
  • Cases
  • Åpenhetsloven

Follow us for more

Struggling to find exactly what you're looking for Struggling to find exactly what you're looking for in your BOM? As always, Lennart has a solution for that. SOLIDWORKS allows you to filter your bill of materials so you can find exactly what you need. 😌

#CADviceoftheweek #CAD #SOLIDWORKS #engineeringstudents
Win at Mölkky this summer – like an Engineer 🌼 Wh Win at Mölkky this summer – like an Engineer 🌼

Who doesn’t love Mölkky, the classic summer game of wooden pins and tactical throws?

But this time… don’t just play it. Simulate the perfect throw.

With multibody dynamics simulation, we identified the optimal trajectory to win the game.

Simulation setup highlights:
🥇 Multi-point contact modeling between 3D geometries
🥇 Defined initial angle and velocity of the throwing pin
🥇 Calculated realistic motion trajectory with physical accuracy

See below the winner's throw simulated with SIMULIA Simpack.

This summer, don’t leave your win to chance.

#Mölkky #Simulation #Engineering
Designing one machine used to be enough. Now? Eve Designing one machine used to be enough. 
Now? Every project is a system. Every system has layers. And every layer has deadlines.

At Schur Automation, engineering never stops - and chaos isn’t welcome.
That’s why their entire flow runs through SOLIDWORKS and PDM. 

Assemblies are built in 3D. Sheet metal parts unfold directly into the workshop. And behind it all, PDM keeps the data structured, current, and clean.

“Our engineers can focus on designing - not handling files.”

Because in high-complexity projects, clarity isn’t just helpful. It’s how you stay in control.

 #SOLIDWORKS #PDM #AutomationDesign #EngineeringFlow #SmartManufacturing
🔍When design data is fragmented, errors are inevit 🔍When design data is fragmented, errors are inevitable.
 
At Pinomatic, data management was previously based on a traditional folder structure. Managing duplicates and outdated versions consumed time and led to unnecessary rework.
 
✅With PDM solution, their data is now structured and reliable: versions stay under control, information is easy to find, and more time can be spent on actual design work.
 
👉 Read the full Pinomatic reference story:
https://plmgroup.eu/cases/efficiency-and-reliability-in-design-with-pdm/

#SOLIDWORKS #PDM #DataManagement #Engineering
  • Privacy and terms
  • General Terms and Conditions