Excel Report AS9102 Format

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Report AS9102 Format

    I recently downloaded a script file from the Wilcox website that populates an Excel inspection report with the PC-DMIS results. Does anyone have a script file that will populate an Excel worksheet of the AS9102 Form 3 FAI report?

  • #2
    I do not know what thattype of report is. But, if you post an example I may have something similar that can be cobbled to suit your needs?
    sigpic

    James Mannes

    Comment


    • #3
      Sheet Format

      Attached is the Excel spreadsheet format as required by AS9102.
      Attached Files

      Comment


      • #4
        Sorry I wasn't familiar with that form. We obviously are not aerospace at my facilty. We are sort of space cadets though? I do not think I have anything to offer to you sorry for your troubles. I learned a new term though that counts for something.
        sigpic

        James Mannes

        Comment


        • #5
          I have been looking at this cmmautoimport file I downloaded from the Wilcox website. It appears to be a series of macros in the Excel spreadsheet that somehow retreives data from PC-DMIS. Does anyone know how this works, and how I could create something to populate the AS9102 form I am working with?

          Comment


          • #6
            Originally posted by frankv
            I have been looking at this cmmautoimport file I downloaded from the Wilcox website. It appears to be a series of macros in the Excel spreadsheet that somehow retreives data from PC-DMIS. Does anyone know how this works, and how I could create something to populate the AS9102 form I am working with?

            The post to cell order is not that difficult, but time consuming.
            Here is something that James Doolittle made a while back.
            there are more advanced copies available if you wish.
            Last edited by Cumofo; 08-05-2006, 03:37 PM.
            sigpic

            Comment


            • #7
              Frankv,
              I'm also in the aerospace industy and have been looking for the same type of program or software. If you come across aything please let me know and I will do the same.

              Thanks Brian

              Comment


              • #8
                Cumofo... Welcome back
                sigpic
                if you had soap on a rope it would be tied to yer ankle

                Comment


                • #9
                  Check the date bro
                  <internet bumper sticker goes here>

                  Comment


                  • #10
                    oh well.. Not all here today. Got a hot one that they would like by end of day tommorrow.
                    sigpic
                    if you had soap on a rope it would be tied to yer ankle

                    Comment


                    • #11
                      I know I know I am dragging up an old post, but just an FYI for future searchers of the forum, Hexagon has a utility to automatically fill out AS9102 forms from PC-DMIS programs. PM me for information.
                      --Brian

                      "The best way to predict the future is invent it. This includes your very next action."

                      Support: Hexagon Metrology Support Center
                      Training: Hexagon Metrology University

                      Comment


                      • #12
                        AS 9102 is the standard for aerospace parts. It is part of AS9100
                        sigpic
                        A proud Vietnam Veteran. 1973-1974

                        Comment


                        • #13
                          While on the subject of Excel Spreadsheets...

                          Sorry I don't have an answer for you Franky but, since we are all talking about Excel spreadsheets I've got another question...
                          I have the Basic script from Hexagon that converts a report from PCDMIS to an Excel spreadsheet and I've been tweaking it to get the desired report for our customer. What I need to know is what are the basic variable names that PCDIMS uses for values in the report? I am sure there are variables used to represent all of measured output values along with values that are entered into the header of the PCDMIS report. I just don't know what any of them are. I have been lucky enough to guess at one of them, "BONUS", and have that work. I would like to be able to extract header information such as the Revision and Serial number values and plug that into the Excel report.
                          One other thing I've found is that this basic script only works when I use Legacy Dimensioning. At this point in time that is fine but, eventually I need to get into the latest format. Is there a script available that can utilize the latest format? I'd appreciate information on this.
                          John.

                          Comment

                          Related Topics

                          Collapse

                          • rick15857
                            As9102
                            by rick15857
                            I have been trying to figure out how to link PCDMIS V2011 to fill in the AS9102 First Article spreadsheet in Excel. Reports have been somewhat of an achilles...
                            02-28-2012, 05:08 PM
                          • InspectorJester
                            Formatting an Excel Report
                            by InspectorJester
                            Good Morning All.
                            Running PC-DMIS 2013MR1 SP5 without Datapage
                            -------------------------------------------------------------------
                            ...
                            05-01-2018, 09:15 AM
                          • jackj
                            Excel Report
                            by jackj
                            Is there anything out there that can create an Excel report for multiple inspections for the same part? Any help appreciated.
                            06-29-2007, 09:49 AM
                          • AuRules
                            Microsoft excel
                            by AuRules
                            What's up and good morning to all. I needing some help on inserting a excel document of some manual checks we do. I know very little about hyper-report...
                            07-14-2008, 10:07 AM
                          • JIM HARRIS
                            As9102
                            by JIM HARRIS
                            I know their are not many people out there that use this software(Hexagon product)but I have a question on editing the templet.Brian G. maybe you know...
                            08-14-2009, 01:21 PM
                          Working...
                          X