Papros Inc.

Click here/link for readme text-operating instructions

Follow the instructions bringing in summaries of the Declarations sheet answers to masterlist, and you can obtain pie charts as shown in the training videos. If the questions are those to which the summary has answers to all questions in one cell, copy that entire column alone to Notepad, save as something.csv and close. Then open something.csv using Excel, with commas as dlimiters, and you will have individual columns you can apply the floating pie chart to and get all statistics.

Notes

Old version support and old zip file is available to support users who still need that: (To switch between versions, there is no need to re-install. Just exit the program and Excel, then extract the contents of the zipfile you need to c:\mrp51 ensuring overwite of old files, then launch). Hint: If you are doing rollups with old versions of CMRTs, do the rollups using the old zip as appropriate, then convert the old CMRT to a new one, then load the files from the new zip folder to migrate forward. This helps in checking against compliant smelters and the new zip contains more optimized algorithms in checking versus the latest RMI smelter lists.

Click here for Link to the old zip folder archives

For speed, performance and near-guarantee of completion in supplier templates' rollups and smelter searches among supplier files, best to use XML rollup feature.
Click here/link for Pros and Cons of each approach .
Preferred browser for xml rollups is mozilla firefox, set it as your default. Then open mozilla, in the window type in about:config and then ok to the alerts, then in the items that show up, scroll and find security.fileuri_strict_origin_policy and toggle it to false - this will be needed for xml rollups.
Click here for Link to easy step by step instructions for XML creation, rollups and searches
Click here to see User feedback on XML approach-See User feedback regarding speed and use of the XML approach..

Convert all supplier templates to XML using the output multiple xml files feature after loading you supplier file paths in Sheet AF and then run the Addin. (The program will run to fruition, but conversions may take long as each character is examined for the file to be standards compliant- but the program can run in the background-bad filenames are dumped into an error bin, and only good files are converted. Because the XML is standards based, you can request the supplier to send a standard XML file using this program also, OR instead convert yourself.) Correct all error supply files or get them out of the list to be redone and added later. Do the rollup after all supplier files have been corrected and added to the list. (Note-the xml rollup is keyed of the smelterIDInput field, so ensure your templates have an entry for this field-if its blank copy the smelterID here to that field)

While doing the XML search or rollup, the filenames and paths should be in Sheet AF. If the files are on the desktop, the files must be in a folder within the C:\mrp51 folder. If on the web, the complete path including http:// must be entered.

For files on the desktop, the program automatically sanitizes the path from the current directory (C:\mrp51), by removing the the C:\mrp51 and converting all \ to /, appropraite for web web computation. If your xml search or rollup does not work, check if your path starting C:\mrp51\ is removed by the program. In some cases if your administrator has a used a non-ASCII ":" in the C:\mrp51 it may not remove this string, then you will need to manually set the path. To do this, copy all the filenames and paths to a blank sheet, then do a find and replace of all "C:\mrp51\", then paste in Sheet AF. There all \ will be converted to / automatically. Thus, finally, if your full filename and path is C:\mrp51\folder1\example1.xml the path that the program needs to see to run properly is folder1/example1.xml
In certain laptop installations of Firefox browser, users may have to type in "about:config" in the browser window, and disable the "security.file.origin_strict_policy" for the XML files to be opened in desktop/laptop.

Rollup of Excel based files (only .xlsx type files allowed for CMRT now, if you have .xlsm or .xlsb- open them and save them as .xlsx files Always check your all templates for these basics and for also being the proper version before using including them in a rollup, this will save you time in the overall process) and check smelter names in outbound templates- The latest conflict minerals template allows a little more than about 2000 rows. The rollup itself may have more rows(because the rollup compares not just the Smelter_Id cell, but also mines and recycled info). So if you have more, you will need to carefully separate the rows with no smelter_id and then from the rest remove duplicates, and then merge all the information together. It is imporatnt key is to get the Smelter ID and names correct. The best thing is to run the "Check Smelter names" in the Addins (after first selecting the current template first to make it active workbook). Always select the current workbook by clicking once before clicking an Addin button. This check smelter names feature works only with version 3.00 and higher templates. Read the readme7.txt for more on this feature.

Duplicate smelter name removal
During the rollup program removes duplicate smelter names if they are for the same metal by comparing against smelter names in first file, subsequent same smelter names for same metal in subsequent supplier files are not duplicated. In the latest version, to conform to writeout requirements, all smelter fields of two rows must be equal to be considered a duplicate.

Recommended smelter fields error correction procedure
After the rollup process, if smelter names are found mismatching, the best method is trace the suppliers with bad names or fields in their smelter list using the search procedures, and have them correct them. For users' own smelter lists, the recommended correction from an partially incorrect CMRT, is as follows, open a second new CMRT, do a manual pick of the new corrected smelters after checking, ensuring the smelter fields, then take that CMRT and roll it up with the earlier CMRT, and remove the incorrect duplicates in the resulting rollup. If proper smelters are picked from the bottom supplier on, there will be no such errors.

Web/XML database search
For best results, if you cannot configure your browser, for local XML files on desktop use Mozilla Firefox as your default browser, and for web file locations use Internet Explorer as your default browser(when IE asks for permission to allow blocked content, give permission)

Advise on Error 13, type mismatch, due to Language and Regional setting in Excel other than English:

If you get the above error due to your setting in Excel, if you can find the setting that causes this, set it in your default setting to prevent this error. An alternate recommended solution is to run on a machine with Language setting English. This has to do with version defaults in Excel and nothing to do with preference of one international language over another.

Advise on Rollup process stop or Conversion to XML stop:

"Method-Activate_Object of Notebook Failed" (Runtime error-2147221080) OR Error 91--The likely source of your error is that there is a problem with one of the files you are trying to rollup. Look at all the files that are open when the program stops. If a supplier file is open, it is the likely cause and is an incorrect file. The other possibility is that one of your supplier files is not even opening properly. A good visual clue has been added to identify faulty supplier files by stopping during each step (this minor feature added 3/14/2013) of the process to show the file being used in Sheet AF. In general, make sure all your supplier files are openable by Excel. If the program stop is on the first line of Sheet AF and there is no problem with file 1, the only other possibility is that in some Microsoft Windows systems, the EICC-GeSi template can be opened only with a pop-up happening. In those cases, when doing a rollup/multifile conversion, the same error message may show up. In these cases, try and open the file eicckp3A3A.xlsx (for CMRT 5.10 and higher) manually. If a pop-up happens, just save the file by using the same name. If the pop-up is the cause, after this, the pop-up will not happen when opening the file, and so the error will not happen again. If there is no pop-up, dont save the file.
Also if you start getting more than 2500 smelters, better convert your files to the built-iin EICC-GeSi xml format and do the rollups, as even CMRT has limitations over 3000 smelters and rollup templates could hang up on that.
In addition, always ensure your suppliers do not start a cell entry with "#" or a link, as these could jeopardize reading files.
XML Rollup- If all your XML files are ok and you are using Firefox as the browser and not getting a rollup even if the data is ok, then open Firefox, type in about:config in the window and scroll to security.fileuri.strict_origin_policy and ensure it is set to false.
Lastly, but importantly, check that all CMRTs are saved as .xlsx (not .xls -remember only .xlsx is allowed from 5.10 and higher, or in some cases, due to user errors as ".xlsx.xlsx" twice-this can be seen in Sheet AF when the files names are loaded. If such is the case correct both the actual filename and also the corresponding entry in Sheet AF. For further troubleshooting see also Frequently Encountered User Committed Errors