Home

NFRC User Manual

Contents

1. 266 5 3 3 SPREADSHEET FORMATTING REQUIREMENTS cooccoccncnncnncnncnncnncnnccnconccnccnccncnncnnss 7 3 4 USING THE UPLOAD SPREADSHEET ccccecceceeccececccecesccsccscesccsccscescescescescess 13 3 4 1 Reporting Individual Products occcccccccconnoncnnnnnncnonononacncnnnnnnnnnnnnnos 14 3 4 2 Reporting Product Groupings coooooonccnnnnnccnnnnnnonnnnnnnnnnnnnnnannnnnnnnnnnonnnnos 14 3 4 3 New Report Type Upload oooooncccccccccnnnoocccnnnnnnnnnonnnnoncnnnnnnnnnnnnnos 16 3 44 Recertification Report Type Upload oooooncccncccconononocccnnnnnnnnnnnnnos 17 343 REVISION Report UDS soda 17 3 4 6 Addendum Report Type ccccccoooononnccnnnnononononocnnnnnnnnonononanccnnonnnnnnnnnnos 20 3 5 COMPLETING THE UPLOAD SPREADSHEET seccsceeccscceccsccscescescescescesceeces 23 IA Cels Fhedin Proper iy esere e 23 3 5 2 Cells Not Filled in Properly ooccccccccoooooncccnnnnnnnnonnnncncnnnnncnnnnnanos 24 Starting the Application ove naaa rotas 26 Format Checking Application ccccccccssssssssscccccsssssssssssscccccsccssssssssscccssssssssscsees 27 5 1 INTRODUCTI N sion EE aaa 27 5 1 1 Via the Simulators Status Screen on CPD 2 0 ooooccccncnccncnccncncnncncnnoos 27 liz Vida BY gc al URL contro ne ve ne ee ne er eee lote 24 5 2 PROCESS TO UPLOADA TIE aes cer sees re OE EEr 28 5 3 SELECTING A MANUFACTURER REPORT TYPE AND UPLOAD FILE 29 5 4 TEST REP
2. E wasg bupeyo B GY perfora asa PN Po fos fra vive cL 0 489234 0 674325 0 790000 AID n 09 03 wrva viva J GY iston oses ara o o os fw val vival LE 0 475689 Gr _ 0 475689 0 33 LE 0378293 D yu B gt S 9IPJINS JIAISSI WU tb lD D SIPLINS AWAISS WS o o olo O r N Mm la pia ps pe pea de ee i eii i page 6 NERC CPD 2 0 User Manual moai BU BV Bw BX SY l uBZL ca 5 a 7 m a z i E z 5 z 5 T p i ki Y A A 5 E 2 z 5 E 4 z y 5 El S E o cj 3 5 z 3 5 3 zs 3 e sa E Ti y j 3 dl 5 a E se RE E S a SF 7 g 8 0 432345 42 10 0 462346 39 11 0 462346 13 0 483415 38 14 0 483415 16 0 472394 39 17 0 472394 39 19 0 354362 42 0 023124 0 693325 0 000000 0 670242 0 025235 0 630632 0 000000 0 605324 0 027323 0 571234 0 000000 0 543823 3 3 Spreadsheet Formatting Requirements The following matrix contains fields and the corresponding description that have to be entered into the spreadsheet Note Fields that are required to match data in the NFRC Certified Products Directory must match the exact syntax Field Name The name of the manufacturer who owns the product for which the simulation data was generated Mfr Name l l e Manufacturer name shall be the same as listed in the license agreement and as listed in the CPD e The series or
3. CA a National Fenestration Rating Council National Fenestration Rating Council Incorporated SIMULATION LAB USER MANUAL rgoa1 NERC Certified Products Database 2 0 2009 NATIONAL FENESTRATION RATING COUNCIL INC PREPARED BY National Fenestration Rating Council 6305 Ivy Lane Suite 140 Greenbelt MD 20770 Voice 301 589 1776 Fax 301 589 3884 Email info Onfrc org Website www nfrc org National Fenestration Rating Council FOREWORD This NFRC Certified Products Database Simulation Lab User Manual provides guidelines and explains the procedure to NFRC Accredited Simulation Laboratories for uploading products information using NFRC online Certified Products Database CPD 2 0 Questions on the use of this procedure should be addressed to National Fenestration Rating Council 6305 Ivy Lane Suite 140 Greenbelt MD 20770 Voice 301 589 1776 Fax 301 589 3884 Email info nfrc org Website www nfrc org NFRC CPD 2 0 User Manual ioa page 11 Aa ke National Fenestration Rating Council Table of Contents WOE WOE A CIO PO E IA A 11 AA annern EEEE ill 1 Introduccion insano iia 2 Ze Simulation Lab AMM A 2 3 Simulation Lab Summary Spreadsheet ssseeeeccccssssscecoccossssceccecosssssscccocssssssseeeoooo 3 3 1 HEADER SECTION PRODUCT LINE INFORMATION 0eceeccecceccecceccecesceeceeces 4 3 2 PRODUCT RATING SECTION INDIVIDUAL PRODUCT INFORMATION
4. Ameritech Millworks LP AML 888 Amsco Windows AMS 7 NFRC CPD 2 0 User Manual toan page 37 This version of the CPD provides simulation laboratories the ability to upload spreadsheets up to 35MB in size in an efficient timeframe To support the user a progress bar will be displayed that monitors the upload percentage and registration of the report to the server If you have a file size that exceeds the 35MB limit please contact the NFRC to support the processing of a large file 6 1 Lab Report Checking Tool Prior to uploading a spreadsheet to the CPD all simulations uploaded to CPD 2 0 shall be successfully processed through the format checking application prior to uploading to the NFRC CPD per Section 5 6 2 Adding a Report to the CPD To upload simulation spreadsheet data start at the Home screen 6 2 1 Selecting a Manufacturer The simulation lab user can search for different manufacturer clients either by Name a three character manufacturer alpha code or manufacturer numeric ID or by scrolling through the list Figure 6b Selecting a Manufacturer FIND MANUFACTURER FABCDEFGHIJKLMNOPORSTUVWA2 Y Al CI O oae o A Window Inc AWN om AH Windows ECM 326 ABC Window Company Inc ABC 1 ABC Window Contractors Inc AWC 341 To select the desired manufacturer click on the manufacturer hyperlink which will result in the manufacturer name being placed to the right of the Selected Manufacturer in highlighted te
5. Inc new simulation initial xls 281 5 25 2009 10 03 59 PM Passed LRT 0000007 2009 05 25 10 03 59pm new simulation initial txt 5 6 1 Finding a Manufacturer To search the queue for a specific manufacturer s spreadsheet use the Find Manufacturer search tool 5 6 1 1 Search by Name Select the radio button to the left of By Name and type in the manufacturer s full name and select the Search button See figure 5j showing the result of not typing in the full MFG name NFRC CPD 2 0 User Manual toan page 31 Figure 51 Type in MFG Name FIND MANUFACTURER A Window Inc physical testing cod 2 0 upload w3 Os completed xls 146 6117 2009 1 22 45 Pl Figure 5j Result of No Matches Found FIND MANUFACTURER 2 By Name By Code or ID Figure 5k Successful Search Result FIND MANUFACTURER By Name O By Code or iD A Window Inc Show All A Window Inc A Window Inc A Window Inc A Window Inc A Window Inc A Window Inc A Window Inc A Window Inc A Window Inc NERC CPD 2 0 User Manual oa physical testing cpd 2 0 upload w3 03 completed xls addendumtest ams 53 xl8 009 04 13 new large xi addendumtest ams 53 xls addendumtest ams 53 xl8 addendumtest ams 53 xl8 new initial addendum xls nfre upload sheet check v3 09 10000 lines xs new simulation initial xk 304 19075 304 304 304 10640 201 6117 2009 1 22 45 Ph 6117 2009 1 19 45 PM 6117 20
6. position The number represents the relative location of the pane within the glazing assembly beginning from the exterior The field shall be rounded and contain a minimum number of 3 decimals and a maximum of 6 decimals Values are expected to be within the range 0 0 lt x lt 1 0 L Test for existence versus of Pane ID Pane Thickness 1 to 8 Contains gap distance between successive panes in inches The number represents the relative location of the gap within the glazing assembly beginning from the exterior The field shall be rounded and contain a minimum number of 3 decimals and a maximum of 6 decimals Gap 1 to 7 L Test for existence versus of Panes NFRC CPD 2 0 User Manual 01 page 8 Field Name e Contains the gas name which is used to fill the gap e The number represents the relative location of the gap within the glazing assembly beginning from the exterior Gap Fill 1 to 7 e This is a text field of a maximum 3 characters from the NFRC Database Codes i e AR3 e L Test for existence versus of Gap widths e S Match against database DB values e The gas fill concentration simulated between glazing layers beginning from the exterior The user shall only state the percentage of inert gases present the application will assume the difference is air If multiple inert gases are present the user shall separate them using of gap fill 1 to 7 P ie 80 argon 10 krypton mixture s
7. All product configurations shall be listed separately 3 4 2 Reporting Product Groupings The simulator may report the group leaders with all applicable grouping information in a condensed format using the summary spreadsheet If the simulator chooses to report the information in a condensed spreadsheet using the grouping rules applicable under NFRC 100 200 and 500 the application will expand the group leaders into all manufacturer requested configurations and populate the NFRC Certification Products Database If this option is used the simulator shall be required to populate the summary spreadsheet as follows e All product configurations shall be listed separately according to the formatting and NFRC code requirements as listed in Section 3 3 e The Product Number shall denote the group leader e For each entry under the group leader that is grouped with the leader the Product Number field shall be blank e The hierarchy rules of NFRC 100 shall apply NFRC CPD 2 0 User Manual toan page 14 A Center of Glazing Grouping 1 ii iii Each groupings first entry i e group leader shall have the Product Number field populated At the manufacturer s option additional glazing options with different values under NFRC 200 included in the grouping may be listed individually under the group leader The user shall include a blank row between grouped options The Summary Sheet contains a button Data Check in the top le
8. Certification Products Database CPD This section will discuss the various components of the simulation summary spreadsheet The current simulation summary spreadsheet can be located on the CPD Info web page on the NFRC website http www nfrc org CPDInfo aspx The user shall use the Excel file that matches version of Excel the user has on their system Since the upload process does not acknowledge a 2007 Excel file a user with Excel 2007 will have one additional step Users with 2007 Excel 1 Start with 2007 Excel sheet file with extension x sm 2 Upon completion select Check Data which time stamps the sheet SAVE the file in 2007 Excel format then SAVE AS a 2003 Excel format 3 Upload and test the 2003 Excel file spreadsheet to the Lab Report Test Tool 4 Upload the 2003 Excel file to the CPD 5 If the user is required to modify an upload spreadsheet it is highly recommended to always use the 2007 Excel file in order to receive the full data checking capabilities The users will then save a file in both versions and re upload the 2003 version Users with 2003 Excel 1 Start with 2003 Excel sheet file with extension x s 2 Upon completion select Check Data which timestamps the sheet save the file as a 2003 Excel file 3 Upload and test the 2003 Excel file spreadsheet to the Lab Report Test Tool 4 Upload the 2003 Excel file to the CPD NFRC CPD 2 0 User Manual 01 page 3 The spreadsheet
9. Failed Error Check Published c Manufacturer 5 Name Code or ID Uploaded Since lt NR Remove Fitsrs_ remove Paging Figure amp c A convenient reminder set in the Lab Reports screen How To Use Filtering By default thie page displays the list of Unverified associated with your account To see reports with a different status 1 Select the Report Status you would like to see 2 Optionally select a Manufacturer by entering a Code ID or portion of a Name 3 Optionally enter the earliest report eubmiesion date you wish to see 4 Click on the Apply Filters button o return to the default view click on the Remove Filters button 8 2 Lab Report Columns The column header information allows quick review of uploaded reports and status Sorting can be done by selecting any of the headers to arrange reports in alpha or numerical order select header again to reverse the order of reports listed Figure 8d Column Headers in Lab Reports screen Report Number Report Spreadsheet Report Type Status Date Manufacturer Mir Code Mfr ID Submitted By Upload Date 8 2 1 Description of Column Headers e Report Number the report number listed in the spreadsheet e Report Spreadsheet the name of the spreadsheet uploaded e Report Type the report type selected by the lab user when uploading the spreadsheet e Status the status of the report listed as follows NFRC CPD 2 0 User M
10. J N 52 a A A it o cti Your Lab Report file has been uploaded ACAN Window Systems Inc ACA 615 Your confirmation Number is LRT 0000039 ACAN Windows Inc AWI 1392 An email will be sent to you with the results of the validation 5 5 2 Failed Upload Red text will be displayed indicating that there were errors with the upload process see Figure 5g Errors at this screen indicate the spreadsheet was not uploaded properly because the file was not a version 2003 Excel file This error does not mean the spreadsheet had incorrect codes or data Figure 5g Example of Red text that upload has failed FIND MANUFACTURER By Name By Code or ID Show All Report Type Addendum v Lab Type Data File Please select a file after all other entries have been made Test Report The data file must be an Excel file Please select another 4cadia Windows and Nanre Awn EIR Note For errors that users cannot resolve please contact NFRC Staff for assistance 5 6 Report Test Queue Each spreadsheet successfully uploaded will be displayed on the Report Test Queue tab page This page provides the specific simulation lab user the ability to review the status of all spreadsheets and to gain access to the event log for each spreadsheet The user can access this page by clicking on the gray tab at the top of the webpage or by clicking on the text that is displayed when successfully uploading a spreadsheet When the user s spreadsheet has bee
11. Lab Report Static 46 8 1 AVAILABLE FILTERS AND SORTING ccsccscesceccecesceccsccsceccsccscescscescscecescesceces 46 8 2 LAB REPORT COLUMNS dc 47 8 2 1 Description of Column Headers csie aa 47 Validation PROCESS aaa 51 9 1 METHODS TO VIEW THE VALIDATION COMPARISON PAGE esceececescesceces 51 9 1 1 Usine View Validation Butto cir a 51 12 Usmo Ema ly pet Wink d Dz 9 2 VALIDATION COMPARISON PAGE 52 ON Adda Comnen eenaa a a aa 53 9 2 2 Edit Update Data on Validation Comparison Page eee 54 TL NoOne e Li E neta icant eies 55 Completing the NFRC Testing and Certification Process ssssssssssssccceccccosssoo 56 Special CASUS oraora E 57 11 1 ENTRY DOOR UPLOAD SPREADSHEET SETUP ccceececcscescecceccscescecescesceses 57 CETA Opaque No Lite OPGOD Sariin ea a a 57 L2 Wy E16 OPIO siones 58 NFRC CPD 2 0 User Manual toan page iv INTRODUCTION The Simulation Lab Certified Products Database User s Manual provides guidelines and explains the procedure for uploading required data to the online NFRC Certified Products Database 2 0 It is intended to provide Simulation Labs with information on how to upload simulation data into the CPD for a manufacturer s fenestration product review the data and submit the data to a specific Inspection Agency and finalize the validation process in conjunction with the IA and Testing Lab SIMULATION LAB RESPONSIBILITIES Accredited NFRC Simulation Labs partici
12. Match against NFRC Database Codes page 10 Field Name Contains the sash type code of the product type from the NFRC Database Codes Note this field shall be populated and not be left blank If multiple frames are present a comma shall be used to Sash Type separate the different frame types i e VI VY Sash code must be filled in if non applicable Sash code N S Match against NFRC Database Codes A description of the door panel configuration from the NFRC Database Codes This is a text field of 2 characters i e EM S Match against NFRC Database Codes A description of the material used to enhance thermal acoustical or structural performance of the door from the NFRC Database Codes This is a text field of 2 characters e EP S Match against NFRC Database Codes Door Description Door Core Fill A description of the covering which is applied to the door core for the primary purpose of protection from environmental elements that may or may not add structural integrity from the NFRC Database Codes This is a text field of 2 characters i e GS This cell will be left blank when uploading a window S Match against NFRC Database Codes A description of the structural members of door composed of but not limited to wood wood products metal composites or other reinforcing materials that is found between the Door Skin Material Door Substructure Edge from the NFRC Database Codes This is a text fie
13. model name as specified by the manufacturer Series Model e The listed Series Model will be displayed in NFRC Certified Products Directory CPD e The Operator Type as listed in NFRC 100 Table 4 3 which applies to the entire product line e Matches the NFRC Database Codes The Thermal Break Type which applies to the entire product line Thermal break code must be filled in if non applicable Thermal Break N Matches the NFRC Database Codes Report Tvbe e New recertification revision addendum or simple addendum report p yP type Can use dropdown arrow e This field will be used for the following report types recertification CPD Number revision addendum and simple addendum e Use alpha numeric CPD number i e ABC B 2 l e The dimensions height x width of the model used for the simulation 2004 Model Size in mm i e 2000mm x 2000mm Validation Size e The dimensions height x width of the model used for validation in mm i e 2000mm x 2000mm NFRC CPD 2 0 User Manual toan page 7 Thermal Break Type Field Name Rating Procedure e The rating procedure used to prepare the report e The identification code which NFRC has assigned to the simulation lab which prepared the report lso Code Lab codes must be entered correctly on spreadsheets and correspond to the user that is logged in If the code and the user s lab do not match the user will not be able to delete or submit a spreadsheet The date upon whi
14. not require a validation option in the report for validation because of validation groupings or because the product is a simulation only product type a validation option will not be listed on the spreadsheet This will activate the Non Validation pull down menu A product uploaded as this product type will not have to go through the new validation process There are three non validation options 1 Multi purpose Products 1 Not Applicable 111 Same Product NERC CPD 2 0 User Manual moai page 44 Figure 7i Detail showing non validation options Select lA Non Validation Option National Fenestration Rating Council Submit to lA Select Non validation Option iw Select Non validation Option Multipurpose Products AA A Not Applicable COMMENTS CPD Number same Product GENERAL INFORMATION Report Type Hew Revision Date 56 29 2008 Add Comment Model Series NEW 08 06 28 Gr Operator Type HSXX Mir Name 123XYZ Company Lab Code oNFR Thermal Break Type N 2004 Model Size 1200mm x 1500mm Rating Procedure 2004 Report Number NEW 06 29 2008 Gr lA Code Uploaded By shanlon Upload Date 10 28 2008 File Version Report Type CPD 2 0 Multi purpose Products Products that are uploaded in accordance with the NFRC 100 Section 4 2 3 2 shall be submitted to the IA under this protocol Same Product Products that are uploaded in accordance with the NFRC 100 Section 4 2 3 1 shall be subm
15. the Product Number column Refer to section 3 4 3 e Recertification A product line that has been previously certified and is obtaining recertification in accordance with the PCP obtains a Recertification report type The upload spreadsheet shall contain original CAR information to validate a simulation 1f applicable a validation option listed as ZERO 0 in the Product Number column a validation option listed as ZERO 0 in the Product Number column Refer to section 3 4 4 e Revision A revision report type upload spreadsheet contains data that revises replaces an individual option in a certified product line because the individual product s contain inaccurate or incomplete data The revision can affect the data in the header as well as other separate CAR rating values All original data shall be archived and accessible NOTE Do not use a revision report type if the desired outcome is add any options in the product line Refer to section 3 4 5 NFRC CPD 2 0 User Manual 01 page 39 e Simple Addendum A simple addendum contains individual product options that are being added to the end of a certified product line Refer to section 3 4 6 1 Figure 6d Choosing Report Type Report Type Lab Type Addendum Data File New Recertification Revision er all other entries have been made Simple Addendum b Reports with the Lab Re ort Test before upload Add Report 6 2 3 Select Data File and Add Report Uti
16. 0 User Guide Example shanlon 12 20 2007 11 04 27 AM CPD Number Operator Type VSDH Add Comment Lab Code SNFR T Thermal Break Type H 2004 Model Size 1200mm x 1500mm Rating Procedure 2004 Report Number Sim 12 19 07 001a shanlon 1220 2007 If the simulation report has not been linked by the IA for comparison with a test report the View Validation button will not be available The simulator can not proceed to the validation comparison page until the IA has coordinated a test report with the simulation report NFRC CPD 2 0 User Manual toan page 51 9 1 2 Using Email Hyperlink If the IA chooses to fail the validation and request corrections each laboratory will receive an email containing a hyperlink directing the lab to the corresponding validation page NOTE Details contained in the email are currently being established Figure 9b Example email Dear Username This is an automated response from the NFRC Certified Products Management System Use this URL to correct information on the associated lab report s http cpd2 nfrc org test_validate_Compare_example 123456789 NFRC 9 2 Validation Comparison Page At the Validation Comparison page the Simulation Laboratory can perform the following add comments edit update data and or notify the IA The Simulation Lab cannot edit any data on the Validation Comparison page unless the IA has selected to fail the validation in which the Simulat
17. 000 SHGC C O G e For individual products that have a total value equal to zero use 0 000001 e Values are expected to be within the range 0 0 lt x lt 1 0 e This is a decimal field of 6 decimal places 8 characters i e 0 782342 NFRC CPD 2 0 User Manual 0a1 page 9 Field Name VT C O G Grid Type Frame Emissivity Frame Absorptance Frame Type NERC CPD 2 0 User Manual moai The Visual Transmittance VT representative of the center of glazing region For individual products that are not able to obtain and shall have a dash as the rating use a Zero 0 000000 For individual products that have a total value equal to zero use 0 000001 Values are expected to be within the range 0 0 x lt 1 0 This is a decimal field of 6 decimal places 8 characters i e 0 782342 The spacer system s used in the simulation of the product line Note this field shall be populated and not be left blank if there is no spacer e g single pane units user will populate with N If multiple spacers are present a comma shall be used to separate the different spacer systems This is a text field of 4 characters for each spacer system listed from the NFRC Database Codes i e A1 D CS D S Match against NFRC Database Codes This includes grilles between the panes simulated divided lite attached and true divided lite Note this field shall be populated and not be left blank If multiple div
18. 000001 in the COG columns as well as the requirement to have a code for the frame sash and door descriptions still applies B SHGC and VT COG columns NERC CPD 2 0 User Manual moai i ii As indicated above the SHGC and VT cog columns contain specific values to meet a particular rating calculation Unfortunately the total rating calculation for both the SHGC and VT will be represented by a in the interim when the total rating 1s less than 0 000001 For instance 1f a door has a VICOG value of 0 000001 and the O and 1 VT value is O the total VT rating calculation will be less than 0 000001 thus resulting in a dash for the rating For issues where a calculation generates a rating error on a CAR contact the NFRC for these issues which will be handled on a case by case basis page 58
19. 07 001b New Viewed by lA Under Review 123XYZ Comp CNFR 121907 001a xls Sim 12 19 07 001a New Viewed by IA Under Review 123XYZ Comp GRD CPD 2 0 Simulation Test 2 xIls RPT TEST 01 GROD New Viewed by l Under Review 123XY Z Comp 8 1 Available Filters and Sorting The available filters can be sorted by Report Status Manufacturer or Uploaded Since date Select the corresponding radio buttons fill in the applicable information and click the Apply Filters button l Report Status Reports can be sorted by All Unverified Rejected Accepted Failed Error Check or Published Manufacturer Reports can be sorted by manufacturer s name three character alpha code or numeric ID Uploaded Since Reports can be sorted by the Uploaded Since feature enter the earliest report submission date you would like to be displayed Alternatively the lab can sort by using the column headers above the submitted report information select any of the headers to arrange reports in alpha or numerical order select header again to reverse the order of reports listed NFRC CPD 2 0 User Manual toan page 46 NOTE When applying filters you must click the Apply Filters button afterward you must also click the Remove Filters button to restore the default Unverified status during your session Figure 8b Available Filters Available Filters Report Status Status OO Al Unverified Rejected Accepted
20. 09 1 13 29 Pl 6117 2009 1 07 09 PM 6117 2009 1 06 16 PM 6117 2009 9 23 26 AM 9202009 9 54 46 Pl 9292009 10 08 05 PM 25 2009 10 03 59 PM page 32 5 6 1 1 Search by Manufacturer Code or ID Select the radio button to the left of By Code or ID and type in the manufacturer s alpha or numeric code and select the Search button Figure 5l Type in MFG Alpha Code FIND MANUFACTURER By Name By Code or iD AWN Gomas A Window Inc physical testing cpd 2 0 upload v3 03 completed xls 145 611712009 1 22 45 PM Figure 5m Successful Search Result FIND MANUFACTURER O By Name By Code or ID physical testing cpd 2 0 upload v3 facie A Window Inc 03 completed xls A Window Inc addendumtest ame 53 xl8 A Window Inc 2009 04 13 new large xlz A Window Inc addendumtest ams 53 xl8 A Window Inc addendumtest am 53 xis A Window Inc addendumtest ame 53 xl8 A Window Inc new initial addendum xls E see check v2 29 A Window Inc new simulation initial xs 146 304 19075 304 304 304 280 10640 201 6117 2009 1 22 45 Ph 6117 2009 1 19 45 PM 6 17 2009 1 13 29 PM 611712009 1 07 09 PM 6 17 2009 1 06 16 PM 6117 2009 9 23 26 AM 5 28 2009 9 54 46 Ph 525 2009 10 08 05 Phi 292009 10 03 59 PM NOTE Select the Show All button to remove any filters and to display all manufacturer spreadsheets in order of the Upload Time NERC CPD 2 0 User Manual oa
21. 1 ABC Window Systems ABC 1 Abritek Windows and Doors Acadia Windows and Doors ACAN Window Systems Inc ACA 615 Addendum v C NFRC Database Committee U ploadsheetiSpreadsheet Testing 2009 04 13 New Large xis Browse Please select a file after all other entries have been made Test Report Figure 5e Validating the spreadsheet FIND MANUFACTURER O By Name Osy Code or ID Report Type A Window inc Lab Type A amp H Windows ECM 326 Data File ABC Window Contractors Inc Awe 341 ABC Window Systems ABC 1 Abritek Windows and Doors Acadia Windows and Doors ACAN Window Systems Inc ACA 615 NERC CPD 2 0 User Manual moai Selected Manufacturer Addendum C NFRC Database Committee UploadsheetiSpreadsheet Testing 2009 04 13 New Large xls Browse Please select a file after all other entries have been made Test Report page 29 5 5 1 Successful Upload Upon completion of the verifying the spreadsheet is uploaded properly to the application text on the screen will display a confirmation number and other details Click on the text to access the Report Test Queue screen Figure 5f Spreadsheet uploaded successfully FIND MANUFACTURER O By Name O By Code or ID Report Type Addendum v Lab Type Data File ABC Window Contractors Inc AWC 341 Please select a file after all other entries have been made ABC Window Systems ABC 1 Abritek Windows and Doors ABR 739 Ac Wi NS
22. 3 09 CPD 2 0 MirProdCod 255 Characters Addendum Addendum 123XYZ Com Addendum FIXD H Hew Product Humber CPD Number AY 2 T O2 Pane ID 1 Pane ID 2 Pane ID 3 Pane ID 4 Pane ID 5 Pane ID 6 Pane ID 7 The setup listed displayed in Figure 3e will add individual product options listed to the end of the grouping series for group leader 001 of the certified product line In this example the first 2 rows were from the original spreadsheet and the next 2 are new options new spacer options to new grids options to be added to the end of this grouping series When this spreadsheet is accepted the application will locate the individual product option number 001 in the product line and populate the new individual product options listed at the end of the this grouping series NOTE To add new grid options to existing options copy and paste the original options and modify the line to accommodate the new options Do NOT add options to the original rows because the data may not populate properly in the case above do not add a G grid type and grid size to the original rows 3 5 Completing the Upload Spreadsheet After all the required product line and product rating information are filled in click any one of the yellow buttons labeled Data Check 3 5 1 Cells Filled in Properly If all of the cells are filled in properly the user will receive the following prompt and a date and time sta
23. 8 Model Series Mfr Name 123XYZ Company Operator Type Lab Code SNFR Thermal Break Type IA Code 2004 Model Size Uploaded By shanlon Rating Procedure Upload Date 10 26 2008 Report Number Windows Internet Explorer File Version Report Type CPD 2 0 NFRC CPD 2 0 User Manual toan page 42 7 1 3 Submitting the Uploads Spreadsheet to the IA GENERAL INFORMATION Revision Date Mfr Name Lab Code IA Code Uploaded By Upload Date If the uploaded data is correct and the manufacturer has provided the proper authorization a simulation lab shall submit the uploaded data to the corresponding IA Using the pull down menu highlight the appropriate IA and select the Submit to IA button NOTE This action will update the status of the spreadsheet to Submitted Pending IA Review The simulator still has the ability to delete the spreadsheet until the IA reviews the spreadsheet Figure 7e Detailed view of Submit to A button Non Validation Option Submit to LA PRODUCT LINE INFORMATION CPD Number 5 1 2009 Model Series Initial Upload 123472 Company Operator Type HSXX SNFR Thermal Break Type N 2004 Model Size 1200mm x 1500mm shanlon Rating Procedure 2004 1 Report Number Initial Report Figure 7f Pull down menu to choose IA Figure 7g Select Submit to IA button Select lA Non Validation Option National Fenestration Rating Council ii Submit to lA GENERAL INFORM
24. A Sel E E GENERAL INFORMATION Report Type New Revision Date 71112008 Mfr Name 123XYZ Company COMMENTS Simulation Upload User Guide Example Simulation Upload 001 VSDH Lab Code SNFR Thermal Break Type N IA Code Uploaded By Upload Date 2004 Model Size 1200mm x 1500mm Rating Procedure 2004 Report Number SIM UPLOAD 001 Save Cancel File Version Report Type CPD 2 0 Figure 7c Detailed view of saved comment ini Non Validation Option GENERAL INFORMATION PRODUCT LINE INFORMATION Revision Date 7 11 2008 Model Series Simulation Upload 001 Simulation Upload User Guide Example shanlon Mfr Name 123XYZ Company Operator Type Add Comment Repon Types Me cPo numer 10 26 2008 6 05 18 PM Lab Code SNFR Thermal Break Type IA Code 2004 Model Size Uploaded By Rating Procedure Upload Date Report Number File Version Report Type CPD 2 0 7 1 2 Deleting the Upload Spreadsheet If the lab deems the uploaded data is not correct select the Delete button Answer the prompt to confirm the deletion An affirmative response results in the report removed from the CPD and the user will be forwarded to the Lab Report screen Figure 7d Detailed view of delete button comment Select lA Non Validation Option v Submit to la lot Applicable GENERAL INFORMATION PRODUCT LINE INFORMATION Report Type New CPD Number Revision Date 7111200
25. ATION Report Type Revision Date Mir Name Lab Code LA Code Uploaded By Upload Date PRODUCT LINE INFORMATION New CPD Number 5 1 2009 Model Series Initial Upload 23X72 Company Operator Type HSXX SNFR Thermal Break Type N 2004 Model Size 1200mm x 1500mm shanlon Rating Procedure 2004 5112 2009 Report Number Initial Report NFRC CPD 2 0 User Manual toan page 43 7 1 3 1 Upload Spreadsheet Containing a Validation Option 0 New or recertification products requiring a validation option in the report for validation shall contain a 0 option This product will not activate the Non Validation pull down menu If Non Validation Option is activated for the lab to select the page must be deleted from the CPD and resubmitted after adjusting the spreadsheet Note If the validation option 0 is formatted as text the CPD will not read the field correctly The validation option must be a numerical zero to work correctly regardless of formatting Usually typing over the entry with a zero 0 will correct this problem Figure 7h Detail showing 0 validation option Mtr Prod Code SIMULATION REPORT DETAILS lt lt First lt Previous Next gt Last gt gt Number ID 1 ID 2 ID 3 ID 4 ID 5 ID 6 IDF Test 1 001 9001 9001 0 Validation 000 9001 9001 0 Option 7 1 3 2 Upload Spreadsheet Without a Validation Option 0 New or recertification products that do
26. C CPD 2 0 User Manual 01 with the appropriate value or code revision A1 D ZF S NOTE Do not use a revision to change the amount of grouped options in the series i e an additional spacer A1 D ZF S CU D A spreadsheet set up in this manner will produce an error Addendum Report Type As previously indicated an addendum upload contains new data that will be added to the currently certified products within a product line There are two methods available to set up the data on the spreadsheet for an addendum report type Dependent upon where the new individual product options are being added to the certified product line the addendum can be simple or complex A simple addendum contains new individual product options that are being added to the end of a product line see section 3 4 6 1 A complex addendum contains new individual product options that are being added within a series of options already grouped within the product line see section 3 4 6 2 There shall be no validation 0 option in the upload spreadsheet as the product has already been approved which means any validation issues have already been resolved 3 4 6 1 Simple Addendum Upload A simple addendum is used to add individual product options to the end of a product line A simple addendum can contain single row or grouped rows of individual products All rows for each new individual product shall be filled out completely in accordance with NFRC value and code
27. CPD by clicking on the log off hyper link Lab codes must be entered correctly on spreadsheets and correspond to the user that is logged in If the code and the user s lab do not match the user will not be able to delete or submit a spreadsheet Figure 4a Starting the NFRC Certification Database Login Screen ETA NFRC A WE RE CHANGING THE WAY A FOR WINDOWS DOOR Ah National Fenestration Rating Council NFRC Products Directory NFRC Products Directory Search ay ay To view ratings data for certified or attachment products cali ld AL please click the button below User Name Search Product Directory Password Program CPD Film Attachments If you are a Program Participant and do not have your login information please contact Technical Support at suppon nfre org This web site is optimized for a display resolution of 1024x766 and requires Microsoft Internet Explorer 5 0 or higher Using older browsers non compatible browsers or disabling browser features such as JavaScript will reduce site functionality and overall appearance Download the latest version of Microsoft Internet Explorer NFRC CPD 2 0 User Manual toan page 26 5 FORMAT CHECKING APPLICATION NOTE All simulations uploaded to CPD 2 0 shall be successfully processed through the format checking application prior to uploading to the NFRC CPD 5 1 Introduction The formatting of the data and the codes used in the simulation u
28. E WAY a FOR WINDOWS DOORS AN Rating Counci LAB REPORT TEST NFRC CPD Lab Report Test Tool NFRC Products Directory Search To view ratings data for certified or attachment products please click the button below Search Product Directory Lab Log In Contact Information for participating manufacturers can be found at If you are a Program Participant and do not have your login information htto nfre orq participantlist aspx contact Technical Support at supportf ntfrc org This web site is optimized for a display resolution of 1024766 and requires Microsoft Internet Explorer 5 0 or higher Using older browsers non compatible browsers or disabling browser features such as JavaScript will reduce site functionality and overall appearance Download the latest version of Microsoft Internet Explorer 5 2 Process to Upload a File After logging in the user 1s taken to the Home screen of the application where the simulation lab will select a spreadsheet requiring format checking The current simulation summary spreadsheet can be located on the technical documents web page on the NFRC website http www nfrc org CPDInfo aspx See section 3 for spreadsheet requirements to match the version of Excel to the users system Figure 5b Simulator Home Screen CPD Lab Report Test Tool Home Codes Log off FIND MANUFACTURER By Name By Code or ID FABCDEFGHIJKLMNOPQRSTUVWXYZ AN S
29. EFGHIJKLMNOPQRSTUVWXYZIAI Selected Manufacturer lt None Selected CO coe o nevortrios OO A Window Inc AWN 854 Lab Type ASH Windows ECM 326 Data File ABC Window Contractors inc AWC 344 Please select a file after all other entries have been made ABC Widow E ABC 1 You must test all Sim Lab Reports with the Lab Report Test before upload Add Report Abritek Windows and Doors ABR 739 Acadia Windows and Doors AWD 528 ACAN Window Systems Inc ACA 615 ACAN Windows Inc AWI 1392 Accent Windows Inc ACC 147 Accurate Dorwin Ltd ADL 451 Acralight International Skylights AIS 1367 Advanced Glazing Systems LLC AGS 706 Advanced Window Cor ADC 1346 Advanced Window Products ADV 1186 Air Tite Window Company ATW 871 Airtite Products LLC APL 843 Albertini S P A ASP 797 ALCO Windows Inc ALC 1440 All New Glass Inc ALN 558 Window amp Door Manufacturing ASM 833 All Temp Windows Inc ATP 983 All Weather Windows Ltd AWW 278 Allan Window Technologies ATH 1388 Allsco Building Products ABG 498 Alpine Window Systems APS 1349 Alside Window Company ALS 4 ALTEK Fenetres Inc FAI 1121 Alton Windows and Doors Limited ALD 1222 Aluminart Architectural Inc ALA 1076 Aluminum Products of Cape Cod Inc APR 734 American Exteriors PON 958 American Integrity Corporation AIC 607 American Jewel Window Systems AJW 608 American Openings HIL 680 American Window Alliance Inc AMW 703 Amerimax Building Products Inc AMX 153
30. HSXX Thermal Break Type N Report Type Revision Data Check v 3 09 CPD 2 0 MirProdCod 255 Characters Product Humber Pane ID 1 Pane ID 7 Pane ID 3 Pane ID 4 Pane ID 5 Pane ID 6 Pane ID 7 The setup listed displayed in Figure 3a will revise the data listed in each row to the specific individual product option For example when this spreadsheet is accepted the third row listed will locate individual product option 00021 00002 for the product line X YZ T 79 and revise the data accordingly 3 4 5 2 Complex Revision Upload A complex revision is used when revising all or some products within an entire grouped series A complex revision 1s a method to use when revising the data to a grouping For example If the spacer was erroneously entered as Al S and should have been A1 D the simulator will use the same NFRC CPD 2 0 User Manual toa page 18 grouping series in the original spreadsheet and revise the Al S spacer with Al D Figure 3b Complex Revision spreadsheet setup Mfr Name XYZ123 Company Series Model 2009 Casement Operator Type CSSV Thermal Break Type N Report Type Data Check v 3 08 CPD 2 0 MirProdCod 255 Characters NERC CPD 2 0 User Manual moai Product Number SNFR 5 4 09 12345 456 4 Pane ID 1 Pane ID 2 Pane ID 3 Pane ID 4 Pane ID 45 Pane ID 6 Pane ID 7 Grid Size The setup listed displayed in Figure 3b will revise t
31. ORT BUTTON c ccccceccsccecceccscceccsccecceccsccsccsccsccsscsccsscsscssssscssessoesees 29 5 5 UPLOADING STATUS cccecesccecceccscccccsccscescescescescescescescescescescescescessescescescescens 29 Dil SUCCESS OAC nada 30 Io AA eee er eer eee ee eee renee ee 30 NFRC CPD 2 0 User Manual ioa page 111 10 11 5 6 REPORT TESTOUEDE ar ada 30 OL Finding a Manta criada 31 310 2 Refresh BUON sc ta daa atico 34 5 055 A alt eet anee es eee 34 A o II A 35 5 6 5 Handling Spreadsheets with Errors coconncionnniconinicnrdcnicccinicn ricas aci 36 5 6 6 Handling Approved Spreadsheets ccccooooononncnnnnncononnnnncncnnnnncnnnnnnnos 36 Uploading Spreadsheet to CPD ics ccescessssacesswewstseusstusisssecesstasssaceussseuteasestuccsssssorsassss 37 6 1 LAB REPORT CHECKING TOOL 0 cccccecceccsccscceccecceccsccscceccsccsccsscscescoessecees 38 6 2 ADDING A REPORT TO THE CPD 00 0 cccecceccscsscecceccscesceccscesceccscscescscesceses 38 0 2 1 Selec a Mnu icre eana 38 O22 SEIECE REPON LYDE si ds TA 39 023 Select Data Fileand Add REPO E s choseccy dcess sonia cute aa 40 Submittino A REPOL inician 41 7 1 SIMULATION REPORT DETAIL PAGE ceccecceccecceccecceccecceccsccscescesceecesceeces 4 FEL Sane CO MMM ada lia 42 7 1 2 Deleting the Upload Spreadsheet ooooonnccnccccccnnnooccnnnnnnnnnonananononss 42 7 1 3 Submitting the Uploads Spreadsheet to the A ccccccnnnnnnnnocn 43
32. ULATION REPORT DETAILS lt lt First lt Previous Next gt Last gt gt 250 rows Ka Product Pane coset Gap Gap Ga 1D 2 10 3 wD 4 1D 5 1D 6 1D 7 1D 8 e 1 2 3 Ei 1 9001 9001 0 125 0 125 0 5 de 2 9002 9003 0 125 0 125 0 5 9001 9001 0 125 0 125 0 5 7 1 Simulation Report Detail Page The following are actions at the simulation report detail page 1 The ability to save Comments 2 Delete the spreadsheet 3 Submit the uploaded spreadsheet to the IA NOTE New or recertification products requiring validation will contain the validation option for comparison to a thermal test The validation option will always have a Product Number of ZERO 0 and shall be the last option in the spreadsheet This product number must be a numerical zero For new or recertification products that do not contain a validation option 0 because of validation groupings or the product is a simulation only product type the simulator shall choose the proper non validation method refer to section 7 1 3 2 NFRC CPD 2 0 User Manual toan page 41 7 1 1 Saving Comments It is recommended that the simulator provide any necessary details in the Comment field for the IA s knowledge To add a comment select the Add Comment button type comment in the window box provided and select Save The comment will then be visible on the page Figure 7b Detailed view of Comment field in edit mode and message ect I
33. anual toan page 47 o Uploaded spreadsheet has been properly uploaded and waiting for the lab to delete or submit to the IA Report Number Report Spreadsheet Report Type EX SiM UPLOAD 001 Simulation Test New 001 xls New Uploaded o Submitted Pending IA Review spreadsheet has been properly uploaded and submitted to IA and is waiting for the IA to review for the first time but can be deleted by the simulator Report Number Report Spreadsheet Report Type sous O Submitted Pending l Review SiM UPLOAD 001 simulation Test New 001 xls New o Viewed by IA spreadsheet has been properly uploaded submitted to IA and that IA has reviewed the spreadsheet but it has not been approved by the IA Neither the lab nor the JA can delete the spreadsheet when this status occurs Report Number Report Spreadsheet Report Type Status SIM UPLOAD 00 Simulation Test New 001 l New Viewed by lA o Accepted by IA Pending Validation spreadsheet has been properly uploaded submitted to IA and approved by the IA prior to the IA accepting the validation Neither the lab nor the IA can delete the spreadsheet when this status occurs SM UPLOAD 001 simulation Test New 001 xs New Accepted by 14 Pending Validation o Accepted Validation Report viewed by IA spreadsheet has been properly uploaded submitted to IA and viewed by the IA The validation has been accepted but the spreadsheet has not been ap
34. b 3171 104 15 16 Test 4a 004 3176 102 17 test 4b _ 3176 104 18 SAA A 19 Validation Option 000 9001 9001 Figure 2b Pane Thickness 1 Pane Thickness 2 Pane Thickness 3 Pane Thickness 4 Pane Thickness 5 Pane Thickness 6 Pane Thickness 7 Pane Thickness 8 soaa o o o I NE IE E IS IS SS IS 10 0315 0 118 41 0 315 fjomel _ a IO IS OS IS IS AS 13 0 338 0 118 14 0338 0118 EMO RO O RO IS SS 16 0 394 0 118 J T T T 17 0 394 0 118 J T py 1 AA 0125 J o NFRC CPD 2 0 User Manual toan page 5 BT Zilld dep jo ENE Ue 100 9IPJINS AyAissiwy pue y a bp3 24113561155 1000 9 IIl4 des jo BS G Il 4 dep Jo SIPJINS JAISSIJ rr JENAIE jy ad wyg 100g p Illd deg Jo ain Gaia TT Th E 14 3103 100 9IPJINS JAISSIWJ a uondussag 1000 d Yyses 9IPJINS JAISSIJ Sli o o d aswel BN aseuns arssiwg 20814105 y ae IA aseuns JAISSII o a on a ailai ALLTEL ELLE La H pS fameen HS adi pug loci n HS a a f on e M oa E cn y m mi Cy y j i f c Li hyns su aswel BL BM E Oo 3215 pug Figure 2d Figure 2e da N NIN T z seuns Aissiwalo 81S z z o olo H g 0 3 LA ipo A l aaa 0 a WY VA Y G 5 0 3 DSHS B 0 362845 0 625437 aD N os 03 vrva viva F g 0 3 10284 B
35. ch the report was created by the laboratory in numeric format i e 05 15 2009 Sim Rpt Revision Date Note e For new product lines the cell contains the original report date The date is then modified for all subsequent revisions or addendums Report Number e The name or number of the report as specified by the Simulator Data Checked e This is a read only field that indicates when the local validation was last run on the spreadsheet e This is a free form field that manufacturers can use to enter additional MfrProdCode information about the reference or option product e lA will be able to edit this field e This filed contains the internal number that the database uses to identify the product e The field may also contain a number which represents the relative count of the reference products contained in the spreadsheet If the field is used in this manner the entry should be blank if the product is an option Note e Product number ZERO which will be denoted as 0 shall always be the validation option for comparison to the physical test if applicable and will be the last individual product listed Product Number Contains the identifying code as defined in the IGDB or User database of the glass film or laminate The number represents the relative location of the pane within the assembly beginning from the exterior Pane ID 1 to 8 Contains the thickness of the pane in inches located at the specified
36. cts 1 Select Addendum report type from the drop down arrow and in the spreadsheet and while uploading the spreadsheet to the CPD 2 The lab will need to know the product line CPD X YZ T 24 and the group leader product option number 234 a The product line s CPD Number will be placed in the cell for the CPD Number b The individual CPD product number i e 234 for each group leader will be placed in the Product Number column 3 The lab determines the new individual product options additional glass width s spacer emissivity frame sash and or grid within a grouping to be added to the product line a The new individual options are added below the corresponding group series which contains all of page 21 the original group leader data and its corresponding individual product options NOTE All options that were originally uploaded must be listed using exactly the same number of options in the same order so that when expanded the same numbers of original individual products are created Addendum products will be listed after this original series Do not change the number of grouped options in the original series such as adding an additional spacer option to the group leader row which will populate expand the individual products incorrectly The number of rows and grouped options within the original series such as grids N G S shall be listed in the spreadsheet when using this report type For e
37. data or codes listed on the validation comparison screen but can be other issues related to problems in the actual reports To help the Simulation Lab the IA may have provided details about the non validation issue in the comment field 9 2 3 Notifying the IA When any necessary modifications are completed the Simulation Lab will select the Notify IA button which will inform the JA via email that a modification has been performed Figure 9h View of Notify IA button Edit of Gap Fill 2 Edit Spacer A S Al 5 NFRC CPD 2 0 User Manual toan page 55 10 COMPLETING THE NFRC TESTING AND CERTIFICATION PROCESS The coordination of the validation process is a new part of the CPD and the validation process does not eliminate other IA processes therefore the IA will continue to verify that the products validate via laboratory reports As part of the reporting requirements the simulation lab is required to not only upload a simulation report but also forward a completed report per the NFRC LAP 1 e a Signed report containing all necessary data a BOM and drawings NFRC CPD 2 0 User Manual toan page 56 11 SPECIAL CASES This section is for product types that require specific setups in order to process correctly through the Lab Report Test tool and the CPD publication to a finished Product Line 11 1 Entry Door Upload Spreadsheet Setup 11 1 1 Opaque No Lite Options A 0 oO QD W Z
38. e the last individual product in the upload spreadsheet NFRC CPD 2 0 User Manual toan page 16 e The CPD Number cell is left blank 3 4 4 Recertification Report Type Upload e Select Recertification using the drop down arrow at the Report Type cell e The simulation validation option will be denoted by ZERO 0 in the Product Number field which will be the last individual product in the upload spreadsheet e The CPD Number cell will be the product line s original CPD number 1 e X YZ T 77 Each field holds one value 3 4 5 Revision Report Type A revision report type upload spreadsheet contains data that revises replaces an individual option in a certified product line because the individual product s contain inaccurate or incomplete data NOTE Do not use a revision report type if the desired outcome is to add any options in the product line There shall be no validation O option in the upload spreadsheet as the product has already been approved which means any validation issues have already been resolved NOTE It is important to work with the inspection agency when submitting a revision There are instances when a revision will not be appropriate because of the amount of labels and products that have been manufactured It may be necessary to use a simple addendum report type and the IA will resolve any options the manufacturer wishes to discontinue There are two methods available to setup the data on the spr
39. e total fenestration product solar heat gain coefficient for a center of glazing SHGC of 1 This designation is used for the product option with grids greater than 1 inch using the NFRC 200 2004 Procedure SHGC 1 Grid gt 1 This is a decimal field of 6 decimal places 8 characters i e 0 622876 Non relevant columns based on the grid configuration may be left blank The total fenestration product visible transmittance for a center of glazing VT of 0 This designation is used for the product option with grids greater than 1 inch using the NFRC 200 2004 Procedure VT 0 Grid gt 1 This is a decimal field of 6 decimal places 8 characters i e 0 000000 Non relevant columns based on the grid configuration may be left blank The total fenestration product visible transmittance for a center of glazing VT of 1 This designation is used for the product option with grids greater than 1 inch using the NFRC 200 2004 Procedure VT 1 Grid gt 1 This is a decimal field of 6 decimal places 8 characters i e 0 612542 Non relevant columns based on the grid configuration may be left blank 3 4 Using the Upload Spreadsheet NFRC accredited simulation laboratories are required to use the summary sheet to upload data to the NFRC Certification Database The summary spreadsheet shall be used as follows e The spreadsheet shall not be modified e Filename of the summary spreadsheet shall not exceed 50 charac
40. eadsheet for a revision report type Dependent upon the amount of data to revise the revision can be simple or complex A simple revision 1s a revision of specific individual product options see section 3 4 5 1 A complex revision is used when revising all or some products within an entire grouped series see section 3 4 5 2 3 4 5 1 Simple Revision Upload A simple revision 1s used to revise specific individual product options and not an entire grouped series of options 1 Select Revision report type from the drop down arrow in the spreadsheet and while uploading the spreadsheet to the CPD 2 The lab will need to know the product line s CPD number XYZ T 84 and the CPD number of the individual product s to be revised 00234 00001 NFRC CPD 2 0 User Manual toan page 17 a The product line s CPD Number will be placed in the cell for the CPD Number b The entire CPD number of each individual product option will be used 1 e XY Z T 24 00234 00001 in the Product Number column 3 The entire row for the individual product shall be filled out completely 4 Inthe case where multiple individual options will be revised the spreadsheet must contain only those rows of data not an entire grouping with each row having the specific individual product number as listed in the CPD Figure 3a Simple Revision spreadsheet setup Mfr Name 123XYZ Company Sseries Model Simple Revision Upload Operator Type
41. elected Manufacturer lt None Selected gt CN Report Typ 3 A Window Inc AWN 854 Lab Type Simulation ASH Windows ECM 326 Data File ABC Window Company Inc ABC 1 Please select a file after all other entries have been made pany ABC Window Contractors Inc AWC 341 epi Abritek Windows and Doors ABR 739 Acadia Windows and Doors AWD 528 ACAN Window Systems Inc ACA 615 NFRC CPD 2 0 User Manual toa page 28 5 3 Selecting a Manufacturer Report Type and Upload File The simulation lab user can select the manufacturer via the matrix on the left side of the screen select the report type via the pull down arrow and utilize the Browse button to select the Simulation Upload Spreadsheet Figure 5c Selecting a Report Type using the pull down arrow Selected Manufacturer Report Type Lab Type higa Addendum Data File New Recertification Revision Simple Addendum 5 4 Test Report Button Browse er all other entries have been made When the correct upload spreadsheet is displayed click the Test Report button to begin the uploading of the spreadsheet to the checking queue 5 5 Uploading Status The application will provide a status of the spreadsheets uploaded to the checking tool Figure 53d Uploading the spreadsheet FIND MANUFACTURER By Name O By Code or ID Show All Selected Manufacturer Report Type Lab Type ASH Windows ECM 326 Data File ABC Window Contractors Inc AWC 34
42. ft section above the rating information If the user has not inserted blank rows separating the products when the data entry is completed but before proceeding to the database application and performing the upload function the user shall click the Data Check button This will run a macro that looks to see whether or not a Product Number has been entered If there is no product number entered nothing happens but if the macro detects a product number then it will insert a blank row and continue down the entire spreadsheet B Spacer Grouping i ii iii Spacer groupings shall be shown by listing the spacer codes in the Spacer field and separating the codes with a comma The spacer group leader shall be listed first and the spacer grouped with the leader shall follow separated by a comma 1 e Al D S4 D The user shall not place a comma after the last value 1 e A1 D S4 D The spreadsheet will not upload correctly if there is a comma after the last value C Divider Grouping NERC CPD 2 0 User Manual moai i ii Divider groupings shall be listed in the Grid Type field using the divider codes and separating them with a comma The divider group leader shall be listed first and the divider configurations grouped with the leader shall follow separated by a comma i e N G page 15 111 The user shall not place a comma after the last value e N G S iv Each cell in the divider colum
43. hall be shown as 80 10 e Values shall add up to the capacity of the established NFRC values for the IG s filling technique remaining of the gap shall be considered Air i e 90 e Values shall contain no decimals i e 95 5 e The value of the emissivity of the surface beginning from the exterior exposed environment side The user shall not enter the emissivity of Emissivity Surface 1 to 16 for clear glass or tinted clear glass typically 0 840 e This is a decimal field of 3 decimals 5 characters i e 0 101 e S Test for existence versus number of Pane IDs e The color code for the tint of the glass film or dynamic glazing e This is a text field of 2 characters from the NFRC Database Codes i e BZ Tint e Opaque Door Tint Code OT In accordance with code description the Mfr Prod Code column must be filled in for a description e The hierarchy is tints and then clear e S Match against NFRC Database Codes Shading System e Currently not in use leave cell blank e The U Factor representative of the center of glazing region e Values are expected to be within the range 0 0 lt x lt 1 3 e This is a decimal field of 6 decimal places 8 characters i e 0 356434 U Factor C O G e The Solar Heat Gain Coefficient SHGC representative of the center of glazing region e For individual products that are not able to obtain and shall have a dash as the rating use a Zero 0 000
44. he entire grouped individual product options listed For example when this spreadsheet is accepted the application will locate the individual product option group leader XY Z T 24 00234 00001 for the product line X YZ T 24 and revise the grouped data accordingly l Select Revision report type from the drop down arrow in the spreadsheet and while uploading the spreadsheet to the CPD The lab will need to know the product line s CPD XYZ T 24 and the grouped series product number of the individual CPD product s to be revised 234 a The product line s CPD Number will be placed in the cell for the CPD Number b The individual CPD product number 234 for each group leader will be placed in the Product Number column All options that were originally uploaded must be listed using exactly the same number of options in the same order This includes the number of rows and grouped options within the series such as grids N G S shall be listed in the spreadsheet when using this report type In the instance in Figure 3b if the initial spreadsheet contained 5 rows of options including the group leader and there were 2 spacer groupings and only 1 grid option the revision spreadsheet shall contain the same number of rows and amount of grouping options page 19 3 4 6 Series Model E Operator Type Thermal Break Type Data Check w CPD 2 0 255 MirProdCod Characters simple 1 Simple 2 NER
45. iders are present a comma shall be used to separate the different dividers This is a text field of 1 character for each grid type listed from the NFRC Database Codes i e N G S Match against NFRC Database Codes The designation for grids less than 1 in height shall be listed as 0 75 and the designation for grids greater than or equal to 1 in height shall be listed as 1 5 If multiple dividers are present a comma shall be used to separate the different dividers This shall be left blank if no dividers are present This is a decimal field from the NFRC Database Codes i e 0 75 L Test for existence versus Grid Type S Match against NFRC Database Codes The emissivity of the frame cross section surface finish This is a decimal field with 1 decimal 3 characters i e 0 9 Contains the frame absorptance value Use 0 5 for glazed sloped curtain wall products use 0 3 for all other product types This is a decimal field with 1 decimal 3 characters i e 0 5 S Match against NFRC Database Codes Contains the frame type code of the product type from the NFRC Database Codes Note this field shall be populated and not be left blank If multiple frames are present a comma shall be used to separate the different frame types Frame code must be filled in if non applicable Frame code N This is a text field of 2 characters xx for each frame type listed from the NFRC Database Codes i e VY VA S
46. ion Lab will be informed about a validation issue Figure 9c View of Validation Comparison Page CERTIFIED PROCUCT S Re TORT Teni tij See TIFOSSI a 1163007 IR fai Met Tira at Gi Lii Feme Thickness EI Oi Laj Pura Thicinema F Lap Par Tecisa i mi tot fore Thrine Da Pasa Tecisen mi ot Fare Thicke a7 La Fane Thike a Lap Gap 1 tal Geez Edi Gea Lii Gapi bii Gast Lap dap Lan di Ey Omftt L Ge raz La Gag has La Gee fea fal Gag Fas Lat Ges rae Lop Gap Far Esp Sarii hai Esp Sef Gas FAS Dii Lean dy Sertece 7 Lal mmsy paa o Ea bmiinty Sortece i fad Eranty Sertece Ee mare Serl O ij lemeviyiwice gt Li ran Sarge b y Emmanty eriti y fmt rd 10 DI Emami eil Lu Cemaecty Gortece 17 ld Usado Gertece 1 a immi ete 14 da Exmairfy Darin E Lis Dry Feria 16 ag Tia da Main pde NERC CPD 2 0 User Manual moai A a 1 ce ETA amir ln ete me poe ani Trema Gaah Typs amanen kmra Begi prey p b pa SUL Ce Bage MEA need a y PE DS pE BAS PETA A TA mM EXIT ea IF page 52 Figure 9d View of Headers on Comparison Page SIMULATION SUMMARY TESTING SUMMARY Sim 12 19 07 001a Test 12 19 2007a Sim 12 19 07 001a TNFR 12 19 2007 001a 11 2007 Test Da 1410 2007 SNFR Edit Grid Type H Edit Frame Emissivity 0 9 0 9 Edit Frame Absorptance 0 3 0 3 Edit Frame Type Wy Wa YY Edt Sash Type vi va Edit Door Descrip
47. is divided into two parts the header section which contains the manufacturer and product line information and the product rating section which contains the rating values and individual product information Refer to Section 3 3 for the requirements for each field 3 1 Header Section Product Line Information Figure la through Figure 1d depicts the header section which are contained in rows from to 6 Figure la Pe asa SREING SUSUR Mfr Name Series Model Operator Type Thermal Break Type N Report Type New Data Check v 3 08 CPD 2 0 on amp Go Ro Figure Ib pK bE MM N oO P QaitTrRis t T Pultviw 1 Datacheck NFRC 2004 Simulation Data Upload Form 2 3 4 5 6 Figure lc A El e 3 2004 Model Size Validation Size 5 Rating Procedure 6 Figure Id Sim Lab Code SNFR Sim Rpt Revision Date 11 16 07 Report GRD Sim Test02 NFRC CPD 2 0 User Manual toa page 4 3 2 Product Rating Section Individual Product Information Figure 2a through Figure 2f depicts the product rating section which starts from Row 7 and continues below Figure 2a Pane ID 1 Pane ID 2 Pane ID 3 Pane ID 4 Pane ID 5 Pane ID 6 Pane ID 7 Pane ID 8 e e x _ 174 D D E o amp o c L a O E Test 1 oO gl is Product Number N anh 9001 9001 ese E aes 10 3175 102 3175 104 ESSE 13 Test 3a 003 3171 102 14 Test 3
48. itted to the IA under this protocol Not Applicable Products types that do not require a validation NOTE It is recommended that a simulation lab provide the corresponding simulation report details used for the validation such as a report number or product line number when uploading a report using validation grouping in the comment box NFRC CPD 2 0 User Manual toan page 45 LAB REPORT STATUS The Lab Report Status screen allows the simulation lab to monitor and select uploaded spreadsheets to review The default report status view is Unverified but has sorting options and filters Figure Sa Default Report Status Screen Available Filters How To Use Filtering By default this page displays tl Report Status Al Unverified Rejected Accepted Failed Error Check a dierent siaiu 1 Select the Report Status 2 Optionally select a Manuf 3 Optionally enter the earlic 4 Click on the Apply Filters Apply Filters To return to the default view c Report Name Report Number Report Type Status Manufacture GRD CPD 2 0 Simulation Test 1x RPT TEST 01 GRD Viewed by l Under Review 123X772 Comp SNFR 121007 001a xl3 Sim 12 10 2007a New Viewed by lA Under Review 123XYZ Comp GRD CPD 2 0 Simulation Test 4 xls RPT TEST 01 GRD New Viewed by l Under Review 123XYZ Comp GRO CPD 2 0 Simulation Test 1 x RPT TEST 01 GRD New Viewed by l Under Review 123XYZ Comp SNFR 112907 001b xls SNFRC 1129
49. ld of 2 characters i e WD This cell will be left blank when uploading a window S Match against NFRC Database Codes A description of the raised panel section of a door that is either an individual component of the door or it may be a simulated panel that is created in the embossing of the Door Skin Material from the NFRC Door Panel Material Database Codes This is a text field of 2 characters i e FG This cell will be left blank when uploading a window S Match against database DB values Door Skin Material The U Factor representative of the total fenestration system This is a decimal field of 6 decimal places 8 characters i e 0 232342 U Factor The total fenestration product condensation resistance CR cannot be a decimal and must be a whole number This field can be left blank This is a number field of 2 digits no decimals i e 50 Condensation Resistance The total fenestration product solar heat gain coefficient for a center of glazing SHGC of 0 This designation is used for the product option with no grids using the NFRC 200 2004 Procedure SHGC 0 No Grid This is a decimal field of 6 decimal places 8 characters i e 0 004095 Non relevant columns based on the grid configuration may be left blank NFRC CPD 2 0 User Manual ioa page 11 Field Name SHGC 1 No Grid VT 0 No Grid VT 1 No Grid SHGC 0 Grid lt 1 SHGC 1 Grid lt 1 VT 0 Grid lt 1 VT 1 G
50. lizing the Browse button select the Simulation Upload Spreadsheet for the specific manufacturer When the correct Data File 1s displayed click the ADD REPORT button Figure 6e Choosing data file Selected Manufacturer Report Type Lab Type Data File CANFRAC Database Committee ploadsheetSimulation Test New 001 2 Please select a file after all other entries have been made If there are errors with the upload the errors will be listed on the screen Record the errors and adjust the spreadsheet if applicable If a spreadsheet cannot upload properly utilize the CPD 2 0 Issue Form located at http www nfrc ore CPD Info aspx and contact NFRC Staff The simulation data file detail screen will be displayed if there are no errors NFRC CPD 2 0 User Manual toan page 40 7 SUBMITTING A REPORT The simulation data file detail screen will be displayed if there are no errors Figure 7a screen capture is only a sample of the entire detail page Figure 7a Screen after data files is uploaded correctly Select lA Non Validation Option DENIS GENERAL INFORMATION PRODUCT LINE INFORMATION Report Type New CPD Number Report Type CPD 2 0 Revision Date 5 1 2009 Model Series Initial Upload Mfr Name 123XYZ Company Operator Type HSXX Lab Code SNFR Thermal Break Type N IA Code 2004 Model Size 1200mm x 1500mm Uploaded By shanlon Rating Procedure 2004 Upload Date 5 12 2009 Report Number Initial Report SIM
51. mp will be inserted left of the yellow data check cell location NERC CPD 2 0 User Manual 01 page 23 SUCCESS i 1 Y The error check is complete This sheet will now be time stamped 3 5 2 Cells Not Filled in Properly If any of the cells are not filled in properly the user will receive a prompt depicting the error and the cell location of the error Figure 3f through Figure 31 display examples of some errors and the location of the error Figure 3f Check Halted AN Cell B2 has an invalid entry The Series Model is missing Figure 3g Check Halted A Cell B3 has an invalid entry The Operator Type is missing Figure 3h Check Halted A Cell D11 has an invalid entry The Gap thickness is populated but the Pane Thickness is not NFRC CPD 2 0 User Manual toan page 24 Figure 31 Check Halted y Cell BP11 has an invalid entry An invalid Test Procedure was specified NFRC CPD 2 0 User Manual toan page 25 4 STARTING THE APPLICATION For optimum performance the application can be accessed using Internet Explorer 5 5 or higher To access the application use the following link http cpd nfrc org The Simulation Lab user is taken to the following login screen and prompted to input a valid username and password Usernames and passwords are supplied to the Lab user by the NFRC User can at any time in the application log off that 1s exit out of the
52. n NFRC CPD 2 0 User Manual toan page 30 checked by the lab report test tool the status will be updated the log will list a hyperlink to view the results and the user will receive a notification via email The queue checking system is designed to support the lab user by not having to wait for the upload and checking of the spreadsheet The spreadsheet is checked based on the upload time The spreadsheets listed in the queue are displayed based on the Upload Time for all the manufacturers Figure 5h Report Test Queue Tab Report Test Queue Codes Log off FIND MANUFACTURER A By Name Oy Code or 0 A Window Inc 2009 04 13 new large xls 19075 6 17 2009 1 13 29 PM Queued LRT 0000039 A Window Inc addendumtest ams 53 xls 304 6 17 2009 1 07 09 PM Passed LRT 0000038 06 07 A Window Inc addendumtest ams S3 xls 304 6 17 2009 1 06 16 PM Passed LRT 0000037 2009 06 17 01 06 16pm addendumtest ams S3 txt A Window Inc addendumtest ams 53 xls 304 6 17 2009 9 23 26 AM Failed LRT 0000034 2009 06 17 09 23 26am addendumtest ams S3 txt pei Window addendum 2 xis 281 5 28 2009 9 55 58 PM Failed LRT 0000018 ABC Window addendum 1 xls 281 5 28 2009 9 55 32 PM Passed LRT 0000017 Contractors Inc A Window Inc new initial addendum xls 280 5 28 2009 9 54 46 PM Passed LRT 0000016 nfrc upload sheet check v3 09 pe A Window Inc 10000 lines xis 10640 5 25 2009 10 08 05 PM Passed LRT 0000008 10000 lines txt A Window
53. n must be populated v The Manufacturer Product Code MfrProdCode field may be used to provide further clarification language for divider options used by the manufacturer D Grid Size 1 Divider size shall be listed in the Grid Size field using the divider size codes and separating them with a comma These sizes represent the default divider modeling size for the solar heat gain coefficient and the visible transmittance modeling E Frame and Sash Groupings 1 Frame and sash groupings that result in a single frame group leader with one set of specialty products data shall be documented in the simulation report and the single set of specialty products SHGCO and 1 VTO and 1 data shall be used for all individual products in the spreadsheet a The frame or sash group leader shall be listed first and the frame configurations grouped with the leader shall follow separated by a comma 1 e VY VI 11 Frame grouping that results in multiple frame group leaders with unique specialty products data shall be documented in the simulation report and the appropriate specialty products data entered into the spreadsheet for each individual product 111 The frame variations can be indicated in the manufacturer s product code 3 4 3 New Report Type Upload e Select New using the drop down arrow at the Report Type cell e The simulation validation option will be denoted by ZERO 0 in the Product Number field which will b
54. o the IA the IA will coordinate link the uploaded spreadsheets to begin the validation process The IA will then review the data submitted via the upload spreadsheets at the Validation Comparison page The IA has the capability to Add Comments check boxes for data that the IA deems questionable notify the labs about a validation failure or approve the validation 9 1 Methods to View the Validation Comparison Page The Simulation Lab can proceed to the validation comparison page via two methods 1 Selecting the View Validation button located on the Report Detail page 2 Using the hyperlink supplied in an email when the IA deemed the Verification Failed Note If the lab user is logged into the CPD clicking the hyperlink in the email will open a new internet browser page and proceed to the validation page If not already logged in the system will prompt the user to log in but only proceed to the simulators Home tab 9 1 1 Using View Validation Button At the Lab Report status page select the simulation report upload file to view the Report Detail page Select the View Validation button to proceed to the validation comparison page Figure Ya Default Report Status Screen with View Validation button Non Validation Option View Validation COMMENTS GENERAL INFORMATION Report Type New Revision Date 1 1 2007 Mfr Name 123XY Z Company PRODUCT LINE INFORMATION Model Series Sim 412 19 07 001a Sim upload with 00
55. page 33 5 6 2 Refresh Button Use the Refresh Button to refresh the page to access the most current Statuses 5 6 3 Column Headers 5 6 3 1 Manufacturer Displays the manufacturer selected by the lab user at the Home screen See Section 5 3 5 6 3 2 File Displays the name of the spreadsheet uploaded to the application 5 6 3 3 Size KB Displays the size of the spreadsheet uploaded in kilobytes 5 6 3 4 Upload Time Displays the date and time when the spreadsheet was uploaded to the application This column is used as the display order 5 6 3 5 Status Displays one of the three 3 spreadsheet statuses Queued Passed or Failed Queued The initial status for spreadsheets which is waiting in the queue for processing Passed The status when the successfully passed the checking tool Failed The status when the spreadsheet failed the checking tool 5 6 3 6 Confirmation Number A tracking number is automatically generated by the Lab Report Test Tool for each spreadsheet successfully uploaded and listed in the Report Test Queue NOTE It is recommended to provide this number when contacting NFRC Staff for any problems 5 6 3 7 Log This is initially blank when the status of the spreadsheet is queue This will display the event log TXT file link when the spreadsheet has been processed NFRC CPD 2 0 User Manual toan page 34 5 6 4 Event Log Upon completion of the checking the Log column text on the screen
56. pating in the Laboratory Accreditation Program LAP are responsible for uploading information into the Certified Products Database specific to their manufacturer client These responsibilities include A Competently generate simulations in accordance with the current NFRC documents for fenestration products using the current NFRC approved programs a For rating purposes using NFRC approved simulation software tools the rounding shall only be performed on the rating after the rating has been determined in metric units and the calculations including conversions are complete b Data from NFRC approved simulation software tools to be used in NFRC approved upload spreadsheets shall be obtained in the following manner data obtained from NFRC Approved Software will be at 15 decimals and truncated to 6 decimals c Values from NFRC Approved Software which are listed in all NFRC CPD Upload Spreadsheets shall contain 6 decimals where applicable B Properly upload the data to the proper client C Ensure that the product information uploaded is accurate and complete D Submit the data to the correct NFRC Licensed Inspection and Certification Agency NFRC CPD 2 0 User Manual toan page 2 SIMULATION LAB SUMMARY SPREADSHEET The simulation summary spreadsheet for U factor Solar Heat Gain Coefficient Visible Transmittance and Condensation resistance was designed to allow for an efficient transfer of simulation data into the NFRC Online
57. pload spreadsheet shall be in accordance with the NFRC Simulation Report Formatting Checking Requirement document The process described in this document is for a standalone checking application which will be used for the interim until such time 1t is determined to be implemented within the NFRC CPD 2 0 environment The checking application is for CPD 2 0 simulation uploads only and is not required for the Attachment Product Directory APD For optimum performance the application can be accessed using Internet Explorer 5 5 or higher The checking application can be accessed using either of the following methods 5 1 1 Via the Simulators Status Screen on CPD 2 0 Log onto CPD 2 0 using the following link http cpd nfrc org and click on the RED text labeled Lab Report Test 5 1 2 Via a Direct URL Use the following URL to gain access to the format checking application login screen http labreporttest nfrc org In both paths the Simulation Lab user 1s taken to the Lab Report Test Tool login screen see Figure 5a and prompted to input a valid username and password Usernames and passwords are supplied to the Lab user by the NFRC Current CPD 2 0 usernames and passwords are acceptable User can at any time in the application log off that is exit out of the CPD by clicking on the log off hyper link NFRC CPD 2 0 User Manual 01 page 27 Figure 5a NFRC Simulator Lab Report Test Tool Login Screen Er WE RE CHANGING TH
58. proved by the IA Neither the lab nor the IA can delete the spreadsheet when this status occurs Report Number Report Spreadsheet Report Type Accepted Validation Report Viewed by IA Initial Report New Simulation Initial xl New NFRC CPD 2 0 User Manual toa page 48 o Accepted Validation Report not viewed by IA spreadsheet has been properly uploaded submitted to IA and NOT viewed by the IA The validation has been accepted Neither the lab nor the JA can delete the spreadsheet when this status occurs Report Number Report Spreadsheet Report Type Accepted Validation Report Not Viewed by IA Initial Report New Simulation Initial oct New o Accepted by IA Pending Product Line Generation spreadsheet has been properly uploaded submitted to IA and approved by the IA and the validation has been accepted The IA needs to generate the product line Neither the lab nor the IA can delete the spreadsheet when this status occurs y Accepted by lA Pending Product Line Generation SIM UPLOAD 001 Simulation Test New 001 x o Rejected spreadsheet has been properly uploaded submitted to IA and reviewed by the JA but rejected Note If the simulation and thermal uploads have been coordinated for the validation process and either report is rejected by the IA this will require BOTH reports to be uploaded as previously performed Depending on the circumstance one or both uploads may require revision
59. requirements Figure 3c Simple Addendum spreadsheet setup Mfr Name Report Type Sir 3 09 E a fe fe fe fe Pane ID 3 E a La UN Pane ID 3 Produce Humber Pane ID 1 s e Pane ID 2 page 20 The setup listed displayed in Figure 3c will add individual product options listed to the end of the certified product line For example when this spreadsheet is accepted the application will locate the end of the product line and populate the individual product options listed at the end of the product line The product numbers listed 1 amp 2 will not affect the numbering sequence in the CPD 1 Select Simple Addendum report type from the drop down arrow and in the spreadsheet and while uploading the spreadsheet to the CPD 2 The lab will need to know the product line s CPD XYZ T 79 a The product line s CPD Number will be placed in the cell for the CPD Number 3 The application will automatically add individual products to the end of the product line starting with the next available individual product number therefore any starting number can be used for the product number on the upload spreadsheet with each added row thereafter having the proper subsequent individual product number 3 4 6 2 Complex Addendum Upload NERC CPD 2 0 User Manual moai A complex addendum is used to add additional options at the end of a grouped series of certified individual produ
60. rid lt 1 NERC CPD 2 0 User Manual 01 The total fenestration product solar heat gain coefficient for a center of glazing SHGC of 1 This designation is used for the product option with no grids using the NFRC 200 2004 Procedure This is a decimal field of 6 decimal places 8 characters i e 0 781213 Non relevant columns based on the grid configuration may be left blank The total fenestration product visible transmittance for a center of glazing VT of 0 This designation is used for the product option with no grids using the NFRC 200 2004 Procedure This is a decimal field of 6 decimal places 8 characters i e 0 000000 Non relevant columns based on the grid configuration may be left blank The total fenestration product visible transmittance for a center of glazing VT of 1 This designation is used for the product option with no grids using the NFRC 200 2004 Procedure This is a decimal field of 6 decimal places 8 characters i e 0 776152 Non relevant columns based on the grid configuration may be left blank The total fenestration product solar heat gain coefficient for a center of glazing SHGC of 0 This designation is used for the product option with grids less than 1 inch using the NFRC 200 2004 Procedure This is a decimal field of 6 decimal places 8 characters i e 0 007854 Non relevant columns based on the grid configuration may be left blank The total fenestration p
61. roduct solar heat gain coefficient for a center of glazing SHGC of 1 This designation is used for the product option with grids less than 1 inch using the NFRC 200 2004 Procedure This is a decimal field of 6 decimal places 8 characters i e 0 692343 Non relevant columns based on the grid configuration may be left blank The total fenestration product visible transmittance for a center of glazing VT of 0 This designation is used for the product option with grids less than 1 inch using the NFRC 200 2004 Procedure This is a decimal field of 6 decimal places 8 characters i e 0 000000 Non relevant columns based on the grid configuration may be left blank The total fenestration product visible transmittance for a center of glazing VT of 1 This designation is used for the product option with grids less than 1 inch using the NFRC 200 2004 Procedure This is a decimal field of 6 decimal places 8 characters i e 0 691237 Non relevant columns based on the grid configuration may be left blank page 12 Field Name The total fenestration product solar heat gain coefficient for a center of glazing SHGC of 0 This designation is used for the product option with grids greater than 1 inch using the NFRC 200 2004 Procedure SHGC 0 Grid gt 1 This is a decimal field of 6 decimal places 8 characters i e 0 012342 Non relevant columns based on the grid configuration may be left blank Th
62. s Neither the lab nor the IA can delete the spreadsheet when this status occurs However future releases of CPD 2 0 will include this option Report Number Report Spreadsheet Report Type Status NEW 06 41 006N 001a NEW 0017T 06 06 21 New xie New Rejected o Published all processes simulation and test spreadsheet and the validation have been accepted by the IA and the IA has generated a product line Note Only the simulation upload spreadsheet status will display published Neither the lab nor the IA can delete the spreadsheet when this status occurs SIM UPLOAD 001 Simulation Test New 001 1 New Published NFRC CPD 2 0 User Manual 0a1 page 49 e Status Date displays the latest date a status was placed on the upload e Manufacturer the manufacturer selected by the lab user which matches the manufacturer listed on the upload spreadsheet e MFR Code the manufacturer s CPD code e MFR ID the manufacturer s one to three digit numeric CPD ID e Lab the accredited lab code that uploaded the spreadsheet e Submitted by the test lab user that logged in and uploaded the spreadsheet e Upload Date the date and time of the upload NFRC CPD 2 0 User Manual toan page 50 9 VALIDATION PROCESS The validation process is a new protocol and requires interaction between the Inspection Agency Test Lab and Simulation Lab After both laboratories upload and submit the spreadsheets t
63. ters including blank space in file name nor include bad characters Bad filename characters include lt I gt 4 amp oti oi O e The columns headers and titles are fixed and shall not be changed from the format supplied to work in the application e ach field holds one value Grouped options must have all fields filled in because this information does not fill in from the group leader e Do not remove non applicable fields from the spreadsheet NFRC CPD 2 0 User Manual toan page 13 e The only part of the SPT Specialty Products Table that must be filled in is the O amp 1 columns corresponding to the dividers listed in the Grid Column For instance if there is no grid thus an N is listed in the column the only SPT required are the SHGC amp VT 0 amp 1 values for no divider e Correct formatting of CPD Number for addendum simple addendum recertification revision report types must be entered as X YZ Z 17 not XY Z Z 017 3 4 1 Reporting Individual Products e The simulator may list each Individual Product within a Product Line as a separate line entry in the simulation summary spreadsheet If the simulator reports each Individual Product separately the following format shall be used o Each Product Number shall be unique o Each field on the summary spreadsheet shall contain only one entry the user shall not separate any values codes etc with commas if this option is used o
64. tion z 2 Edit Door Core Fill 3 2 Edit Door Skin Material z iS Edit Door Substructure Edge z Edit Door Panel Material E Edit U factor 0 35 0 350 Edit Size 1250mm x 1550mm 1200mm x 1500mm First review by l on validation conparison page labs need to verify shanlon 12 22 2007 the size and frame and sash types ia 11 50 17 Ph 9 2 1 Add a Comment The Simulation Lab can save a comment for the IA or test lab to read 1 Select Add Comment button 2 Type message 3 Select Save NFRC CPD 2 0 User Manual toan page 53 Figure 9f Detailed view of Comment field and message in editing mode simulation lab modified the Size and Frame Sash Type Figure 9g Detailed view of Comment field and saved message Add Comment E IT a ee l EIN ee E ao 18242007 Simulation lab modified the Size and Frame Sash Type shanlon 19 54 20 AM First review by IA on validation conparison page labs need to verify shanion 1222 2007 the size and frame and sash types la 11 50 17 PM 9 2 2 Edit Update Data on Validation Comparison Page The Simulation Lab can edit any data on the Validation Comparison page when the IA has selected the Verification Failed button which informs the Simulation Lab about the validation issue In conjunction with the Comment field and Error boxes the IA can inform the Simulation Lab 1f the validation issue was or was not based on the data or codes listed on the page 9 2 2 1 Validation Fail
65. ulator has verified that the spreadsheet 1s filled out in accordance with the NFRC Simulation Report Formatting Checking Requirement document the simulator shall forward the spreadsheet and the text file results to NFRC staff for review 5 6 6 Handling Approved Spreadsheets Spreadsheets successfully passing the checking application can be uploaded to CPD 2 0 NFRC CPD 2 0 User Manual toan page 36 Y mi CERTIFIED PRODUCTS DIRECTORY UPLOADING SPREADSHEET TO CPD After logging in the user 1s taken to the Home tab of the application where the simulation lab can access the lab report test tool and upload the client s data to the database The current simulation summary spreadsheet can be located on the technical documents web page on the NFRC website http www nirc org CPDInfo aspx See section 3 for spreadsheet requirements to match the version of Excel to the users system The following matrix contains fields and the corresponding description that for simulation labs familiar with CPD 1 0 the premise is the same when searching or selecting a manufacturer as well as when adding a report to the CPD between CPD 1 0 and CPD 2 0 the only difference is the interface A pull down menu will be used instead of a button when selecting the Report Type Figure 6a Simulator Home Screen Home Lab Reports IA Info My Account Codes Welcome shanlon FIND MANUFACTURER By Name By Code or ID ABCD
66. ure Related to the Data or Codes If the validation failure is based on data or codes listed the IA may have selected a box next to the corresponding error Any box selected by the IA is highlighted for the Simulation Lab to review To help the Simulation Lab the IA may have provided details about the non validation issue in the comment field To modify any data or codes the Simulation Lab can select the Edit button next to the corresponding data field and modify the field accordingly After modifying the data select the Update button To modify data in the Validation Comparison Page 1 Select Edit for the line of requested correction U factor 0 35 0 350 Edit Size 1250mm x 1550mm 1200mm x 1500mm al NFRC CPD 2 0 User Manual toan page 54 2 Correct data in text box simulation lab will only have access to correct simulation data Edit U factor 0 35 0 350 Update Cancel Size 1250mm x 1550m 1 3 Select Update Edit U factor 0 35 0 350 Update Cancel Size 1200mm x 1500mm 1200mmx 1500mm al 4 Updated information 1s saved in Validation Comparison page only Edit U factor 0 35 0 350 Edit Size 1200mm x 1500mm 1200mm x 1500mm al The Simulation Lab will not need to correct the 0 validation data on the upload page the CPD only uses this option for the Validation Comparison page 9 2 2 2 Validation Failure not related to the Data or Codes The validation failure does not have to be based on the
67. will display a downloadable text txt file By clicking on the text an event log screen will open displaying a list of the results The event log will list the results for the HEADER and for the DATA processed Figure 5n Lab Report Test of Header Results A A A e e il EA http labreporttest thecornerstonepros com test 2009 04 01 001 txt ae AAA o Location Mfr Name 21 Passed Location CPD Number 65 Fassed Location Series Model Be Passed Location Operator Type B3 Passed Location Thermal Break B4 Passed Location Report Type BS Passed Location Model Size AQ3 Passed Location Rating Procedure AOS Passed Location Sim Lab Code BIS Fassed Location SimEpt Revision Date BI4 Passed Location Report No BIS Passed Figure 50 Lab Report Test of Data Results 150 rows were tested 150 passed and 0 rows failed 150 was the last row tested Test ended 5 14 2009 1 41 42 PM Test took 00 00 08 5152980 hours Done NERC CPD 2 0 User Manual moai page 35 5 6 5 Handling Spreadsheets with Errors Spreadsheets containing errors will require modification of the spreadsheet by the user based on the errors listed in the event log The user 1s required to process the revised spreadsheet through the format checking application again until an approved status is obtained In the event that the checking application continues to list errors in the event log and the sim
68. xample if the initial spreadsheet contained 5 rows of options including the group leader and there were 2 spacer groupings and only grid option the addendum spreadsheet shall contain the same number of rows and amount of grouping options followed by rows containing the added options Figure 3d Complex Addendum spreadsheet setup for adding glass options Mfr Name XYZ123 Company Series Model 2009 Casement Operator Type CSSV Thermal Break Type N Report Type Data Check v 3 08 SNFR 5 4 09 12345 4564 CPD 2 0 Pane ID 2 Pane ID 3 Pane ID 4 Pane ID 45 Pane ID 6 Pane ID 441 Pane ID 7 Grid Size MiProdCod 255 Characters Product Number The setup listed displayed in Figure 3d will add individual product options listed to the end of the grouping series for group leader 234 of the certified product line In this example the first 5 rows were from the original spreadsheet and the next 3 are new options new gap widths to be added to the end of this grouping series When this spreadsheet is accepted the application will locate the individual product option number 234 in the product line and populate the new individual product options listed at the end of the this grouping series NFRC CPD 2 0 User Manual ioa page 22 Figure 3e Complex Addendum spreadsheet setup for adding grids Mir Name Series Model Operator Type Thermal Break Type Report Type Data Check v
69. xt NOTE The manufacturer name must be spelled out exactly the same in the upload spreadsheet for the upload to work properly An Excel file is located on the CPD Info page that contains the current list of Manufacturers http www nfrc org CPDInfo aspx NFRC CPD 2 0 User Manual toan page 38 Figure 6c Selected manufacturer is displayed FIND MANUFACTURER By Name O By Code or iD Show All Selected Manufacturer 860 128KVZCompany Report Type v 23XY mpany XYZ 860 Lab Type 3M MMM 1323 Data File 3WWindows Inc TWW 1362 Please select a file afer all other entries have been made 4 Seasons Windows Inc FSW 889 Add Report gt J 3 uh S VWXY AIN 6 2 2 Select Report Type Using the Report Type pull down menu choose the report type The report type shall match the report type listed on the upload spreadsheet e Addendum Complex A complex addendum is used to add additional options at the end of a grouped series of individual products Refer to section 3 4 6 2 e New A product line that is obtaining initial certification authorization in accordance with the PCP obtains a New report type New uploads also encompass existing product line reports that are issued to another NFRC licensee these reports are referred to as Reissued report types The upload spreadsheet shall contain original CAR information to validate a simulation if applicable a validation option listed as ZERO 0 in
70. z POR Pane ID Number Blank Pane Thickness Blank Tint shall contain the code OT The U factor SHGC and VT COG columns shall contain a value For products that cannot obtain a rating VT rating for glass blocks A zero 0 is entered in the corresponding SHGC or VT cog column which will result in a DASH for the corresponding rating Products that have a COG value that is equal to zero The user shall use a value of 0 000001 Such as if the actual value for the SHGC is zero the user will place a 0 000001 in the SHGC or VT COG column which will result in the application using a 0 000001 for the SHGC calculation Spacer and Grid Type shall contain an N Frame absorptance and emissivity shall contain a value The Frame Sash and door descriptions shall contain a code Use N for not applicable from the NFRC Directory Code List in cases where the column description is not applicable to the product All door columns must be filled in with a code U Factor shall contain a value Condensation Resistance 1f applicable shall contain a value The SHGC VT 0 amp 1 columns shall contain values but may be applied to match the grid code NFRC CPD 2 0 User Manual toan page 57 11 1 2 With Lite Options A For rows where the option contains a glazing option the glazing descriptions are filled out appropriately as well as the spacer and grid columns The use of ZERO or 0

Download Pdf Manuals

Related Search

Related Contents

Manual de instrucciones  Matrix Games Manual Template  SÉNAT DE BELGIQUE    Un petit paradis de verdure  Samsung BT621FSST Manuel de l'utilisateur  Dell Microsoft Windows Unified Data Storage Server 2003 (PowerVault NX 1950) Reference Guide  User Guide - fieldMarshall  Manual de instalación bluetooth original VW 9W7  Specific Product Documentation  

Copyright © All rights reserved. Failed to retrieve file