ࡱ>  ,#ScrollBar1Framex( 4CellUpButton ,4CellDownButtonexq %'()*+,-tA Microsoft Forms 2.0 FormEmbedded Object9qKLMNOPVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} AdjustCells Caption = "Adjust Sketch Dimensions" ClientHeight = 2070 ClientLeft = 2040 ClientTVBFrame3DesignListDialog"{?hMhfoz|  !"#%')+-/13579;=?ACEGIKMOQSUVWXYZ[\]^_`abcdeghijklmnopqrstuvwyz{|}~ Pro/DESKTOP\G\G\G BGet Pro/DESKTOP parameters GetVarsFromDW(wwwwwD@0P@D8D8Q@Q@5@5@8333p(` BUpdate Pro/DESKTOPUpdateDW(wwwwwwUffaE35aB"#aBB#aBD#aE"%aEUUaEa@a@a@aEaDDDQp( BAdjust Cell ValuesShowAdjustCells(wwDADDDDDDDADD@D@p(' ACreate Lines from Points MakePolyLine(ww3#03!0  3 3  3 3 " 30 3#0 "! ! 20p(lj9991? BCreate Spline from Points MakeSpline(ww" "  !!!!   ""p(9999y1F!Example 2!Object 1  FMicrosoft Word Document MSWordDocWord.Document.89qMBD001F9615  F0th0thMBD0005C222 F0thЁhMBD00056FB6  F0thp=hMBD0002EE27& F0thhMBD00020BC6- F0thHhMBD0070B60A 4 F0thЊhMBD0070B5A0; F0thPhMBD0070A1C9 B F0th ^hMBD00702614I F0th`hMBD006F527E P F0th`?hMBD006D2ECFW F0th05hMBD006CADA9` F0thGOhOle $A1Table CompObj&jObjectPool0th0th i8@8 NormalCJ_HaJmH sH tH <A@< Default Paragraph Font z./nomn000000 0 0 0 0000FNRX.V]**^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L..V]         @1@UnknownGz Times New Roman5Symbol3& z Arial"qhUfWW*r0m1@DefaultragrawalWordDocument"SummaryInformation(DocumentSummaryInformation8&Ole (BM bjbj== "WWl  n""""""""$$ DH"""""v""(vvv":""v"vvv" "\ >0n,fvExample 2: Creating Sketches from Data Points This example will explain how to use the two tools for creating sketches from data points in Excel (Create Lines from Points and Create Spline from Points). These tools are useful when creating sketches that represent equations or are defined by data points. Good examples are involute gear profiles or airfoil data. To use these tools: Open Pro/DESKTOP. Activate the sketch you want the line or spline drawn on. In Excel, put the cursor on the first data point in the first column. Click on either the Create Lines from Points or the Create Spline from Points button. Try it on the below data. .+DKd5\5B* \ph./nomn & F$a$  1h/ =!"#$%Oh+'0l   ( 4 @LT\dssDefaultefaefa Normal.dot ragrawalt3grMicrosoft Word 9.0@| @P?@O՜.+,0 hp|    Title2F!Example 1!Object 13  FMicrosoft Word Document MSWordDocWord.Document.89q1F!Example 1!Object 9  FMicrosoft Word Document MSWordDocWord.Document.89q1Table0CompObj*jObjectPoolЁhЁhWordDocument8" i8@8 NormalCJ_HaJmH sH tH <A@< Default Paragraph FontO  zOIu~MNQ00 0 0 0 0 0 000OOOQsvQ::NQD/9<)NObject>Create From File (must click this tab!) In the create from file dialog box, Check Link To File. This will dynamically link the inserted object to the Pro/DESKTOP design file. Browse to the saved Pro/DESKTOP design file Click OK Pro/DESKTOP will insert the current view of the design into Excel. Try changing some of the values in Excel and hit the Update Pro/DESKTOP button. The embedded Pro/DESKTOP image in Excel will also update!  O5\5B* \phIu~MNO & F$a$ O 1h/ =!"#$%SummaryInformation(BDocumentSummaryInformation8JOle ,A1Table!ROh+'0l   ( 4 @LT\dssDefaultefaefa Normal.dot ragrawalt4grMicrosoft Word 9.0@">@@[&՜.+,0 hp|    Title i8@8 NormalCJ_HaJmH sH tH <A@< Default Paragraph Font z!"Xz 00 0 0 0 000   D/9<)N@4 Title$a$5B* \ph  z343Lq0@0@0@0 0 0 0 0 0 00pNx%^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.pN         @1@UnknownGz Times New Roman5Symbol3& z Arial"hxUFbW~01@DefaultragrawalWordDocumentSummaryInformation(02DocumentSummaryInformation8Ole 8EM bjbj== "WWl  H,,,,,,,,$ H,,,,,P,,PPP, ,,P,PPP{,  P6 0H,f@fPExample 1: Using the Get Variables From Pro/D Tool This example will demonstrate how to use the Get Pro/DESKTOP Parameters tool, the Update Pro/DESKTOP tool and the Adjust Cell Values tool. Run Pro/DESKTOP and start a new design file. Draw a rectangle that is 4 inches x 3 inches and extrude it 2 inches. Start a new Excel sheet. Position the cursor on a blank cell. Click the Get Pro/DESKTOP Parameters button (gear, button #1) Pro/D will place parameters into Excel (see Figure 2). The area used is referred to as the reserved area. If the reserved area is overlapped or if anything other that the numeric data is changed then errors will occur. a{{5\ 343Lq & F  1h/ =!"#$%Oh+'0l   ( 4 @LT\dssDefaultefaefa Normal.dot ragrawalt4grMicrosoft Word 9.0@~@8@+՜.+,0 hp|    Title5F!Instructions!Object 16  FMicrosoft Word Document MSWordDocWord.Document.89q5F!Instructions!Object 13  FMicrosoft Word Document MSWordDocWord.Document.89q1Table36CompObj:jObjectPool58ЊhЊhWordDocument" i8@8 NormalCJ_HaJmH sH tH <A@< Default Paragraph Font4>@4 Title$a$5B* \ph0B@0 Body Text B*ph  z `a00000000000    "<BEO:: @: # p@UnknownGz Times New Roman5Symbol3& z Arial"qhUFW>01DefaultragrawalM  bjbj== "WW lD:::: F DW^^^^^^^^$  -H^^^^^^^^F^^^^R D(D:"'0Wuu$6Button 5: Spline with Points This tool is used to create a spline passing through a given set of points on the active sketch of a design or drawing document. The users creates two colums of point data in Excel, then they select the left colum top and click this tool. This tool will then place each of the data points on the active sketch in Pro/Desktop and connect the points with a curved line. Please note that the two columns of point data assume that the point data in the left hand side column represents x co-ordinates and the point data in the right hand side column represents y co-ordinates. Please make sure that a design or drawing document is open in Pro/DESKTOP with the desired sketch active. The use of this button is demonstrated on Example 2 worksheet.  5\`a    1h+ =!"#$%SummaryInformation(79DocumentSummaryInformation8Ole <E1Table:=Oh+'0l   ( 4 @LT\dssDefaultefaefa Normal.dot ragrawalt5grMicrosoft Word 9.0@ @kC@T(՜.+,0 hp|    Title i8@8 NormalCJ_HaJmH sH tH <A@< Default Paragraph Font4>@4 Title$a$5B* \ph zfg000000000000000@h=: #@UnknownGz Times New Roman5Symbol3& z Arial"hUFW~01DefaultragrawalCompObj>jObjectPool<?PhPhWordDocument"SummaryInformation(>@M bjbj== "WWl```` l )$ H x @ (N` 0)GGButton 4: Line with Points This tool is used to create a set of lines passing through a given set of points on the active sketch of a design or drawing document. The users create two columns of point data in Excel, and then they select the left column top and click this tool. This tool will then place each of the data points on the active sketch in Pro/Desktop and connect the points with straight lines. Please note that the two columns of point data assume that the point data in the left hand side column represents x-coordinates and the point data in the right hand side column represents y-coordinates. Please make sure that a design or drawing document is open in Pro/DESKTOP with the desired sketch active. This use of this button is demonstrated on Example 2 worksheet.  B*ph5B*\ph5\fg$a$ 1h+ =!"#$%Oh+'0l   ( 4 @LT\dssDefaultefaefa Normal.dot ragrawalt5grMicrosoft Word 9.0@[@kC@'DocumentSummaryInformation8Ole @E1TableADCompObjBjancel"   % Microsoft Forms 2.0 FormEmbedded Object9q*+,-J0VERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} DesignListDialog Caption = "Design Selection Box" ClientHeight = 1665 ClientLeft = 45 ClientTop = 330 ClientWidth = 5205 StartUpPosition = 1 'CenterOwner TypeInfoVer = 8 End ՜.+,0 hp|    Title