Flowchart C# workbook

INICIO

PART LIST COMPARISON

WORKBOOK CHECKLIST

PART LIST vs STUFF

CIRDI vs STUFF

NO

NO

Find & load

PDF CIRDI

loaded?

Find & load

excel part list

YES

YES

loaded?

NO

NO

Open?

Find & load

PDF STUFF

NO

YES

Open

Find & Load

PDF STUFF

NO

YES

Open & hide file

Open & hide file

Open

NO

Error message

Error message

Open

YES

NO

Open & hide file

Open & hide file

YES

YES

Open new excel file

Set sheet

Find components

Open new excel file & set sheet

Find PDF components

Load parts in excel file

YES

Complete

NO

YES

Error message

Load parts in excel file

loaded?

Compare 2 row of component

NO

YES

finish

close all tabs

Show result excel tile

Are you finish?

NO

YES

Load parts in excel file

Compare 2 row of parts

Print part list

Show result excel file

Are you finish?

NO

YES

finish

close all tabs

Part or match in both rows?

Print Yes

Print No

YES

NO

Print quantity

Print part list

Show result excel file

Part or match in both rows?

Print Yes

Print No

YES

NO

Print quantity

New project

Engineering

change

New excel Workbook

Open a workbook

Back

Back

Back

Message (Create all document numbers)

NO

YES

Open a new excel file

Open window (PCB Document)

Hide excel document

Eye symbol

Is excel file visible?

Show excel file

Hide excel file

NO

YES

Next

Save

Open window to save as

Is it saved?

YES

NO

Open alert dialog

YES

NO

Open window PCB Checklist

Is it save as?

Complete document numbers and index

YES

NO

is it next button?

NO

YES

Complete document numbers and index

Eye symbol

Is excel file visible?

Show excel file

Hide excel file

NO

YES

Next

Save

Save address

Save excel document

Save excel document

Save excel document

Save excel document

Open window PCB MData

Complete document numbers and index

Eye symbol

Is excel file visible?

Show excel file

Hide excel file

NO

YES

Save

Save excel document

Exit

Exit

Close all document used

Exit

Close all document used

Next step

Open window ECAD workbook

Complete project information

Complete Team members information

Transfer text to excel file

Transfer text to excel file

Transfer text to excel file

Transfer text to excel file

Save excel document

G3

G5

MS7

G8

change to summary sheet

change to GW5 sheet

change to MS7 sheet

change to GW8 sheet

change to GW3 sheet

Open window GW3 Process Stage

Open window GW5 Process Stage

Open window MS7 Process Stage

Open window GW8 Process Stage

Complete GW3 questions

Complete GW5 questions

Complete MS7 questions

Complete GW8 questions

Transfer text to excel file

Upload file

Upload file to excel workbook

Find file to upload

Write text box

Verify if file is uploaded

Change status evidence of excel sheet

No

Yes

Back

Finish

Save excel document

CDB Check list

is this a D product?

You will use conformal?

Save variant

Save variant

Description project

Made merge in a below summary sheet

Finish

Back

Open workbook

Find workbook file

Found

NO

YES

Find workbook file

Message (Create all document numbers)

NO

YES

NO

YES

Open a new excel file

Hide excel document

Open window (Select document)

Choose type of change

Check parts or documents necessary

Next

Back

Save

Save excel document

Exit

Close all document used

Finish

Save excel document

PCB STUFF

PCB CIRDI

PCB STENT

PCB CDENT

PANEL DRAWING

PCB BAREBOARD

PCB TESTP

Open PDF

Find PDF document

NO

YES

Select document?

NO

YES

Find preset information

Transfer information about project

This information exist?

Write No and fill color cell

Write Yes and fill cell

Compare title block and general content

it is no necessary

Write NA and fill color cell

Modify configuration from CDB Check list window

Edges

Title block contents

Information selected transfer to excel file

Select Drawing Checklist

PCB STUFF

PCB CIRDI

PCB STENT

PCB CDENT

PANEL DRAWING

PCB BAREBOARD

PCB TESTP

Select option from menu

CDB Change / Release Form

Transfer information to excel file

Select option from menu

Write on text box

Part list

General instructions

Extra Documents attached to CDB

Upload file

Transfer information to excel file

Select option from menu

Write on text box

Find file

Upload document to excel file

Select file

NO

YES

Error message

YES

NO

finish

close all tabs

finish

close all tabs

finish

close all tabs

Eye symbol

Is excel file visible?

Show excel file

Hide excel file

NO

YES

Variant

Open window variant

Edit

New

Find variant sheet

exist variant?

Write variant name

Edit everything necessary information

Get information from excel

Variant contain text?

Create a new sheet with variant name

Verify if text box contain something

NO

YES

NO

YES

Copy information from variantexxx

Delete information irrelevant