Goose's Guide is Baaaaack!

**NeoMatrix** · 09-25-2015

Latest modifed revision of the GG_October_2014_Xrefv11.xlsx. (No change in information)

Current GG_Xref update revision is Ver1.1 on the 25-09-15

Nothing has changed data wise .

Improvements to the original document include:
o Column collapse A..E and J..K
o Drop down menu for Xref of Product number to Model number
o Improved parts # search in "Column H" . Type in "Part #" in drop down filter and press enter.
o Improved "EDP #" search.
o Improved "Supplies" search.
o Improved spelling , general grammar. (though not perfect)
o Correction to formula #Xref! bug in revision 1.0

Sorry guys & gals from the otherside of the pond. The document was spell checked using the original English(USA) format...

Remember the above file format is Excel 2010 *.xlsx . This is not in old style 2007 *.xls format.
There are no macro's available in the above file format, so the document should arrive in original text format, and therefore virus free.

PM with me your email e-ddress if you want the latest revision(1.1) .....

**1978chaya** · 10-16-2015

Please send me How clear the SC 302 Functional Error in Ricoh Aficio MP 1800L2

**sandmanmac** · 10-16-2015

Originally Posted by 1978chaya

Please send me How clear the SC 302 Functional Error in Ricoh Aficio MP 1800L2

You've hi-jacked a thread with a completely unrelated issue!

And you also asked this question 3 weeks ago!
Buy a manual, GOOGLE IT! or call a tech

SC 302 in Ricoh Aficio MP 1800 L2 & SC 402 in Ricoh Aficio C2030

**NeoMatrix** · 10-18-2015

[ Rev 1.2] Mon 19-10-15
GG_October_2014_Xrefv12.xlsx

There should be a revision update for GG in the next week or two.

[Bug Fix ]
1. Fixes some minor grammar corrections.
2. Fixes a round down search condition in Excel formula.
The round down condition might show up as invalid model number if Product Code is not found in Xref Sheet. This might happen if new Product numbers are entered into the Solutions Sheet and no Xref Sheet match found.
3. Improved formula programming and error checking.
This may slow the XREF sheet conversion due to additional time taken for error checking. There are 50300 rows (GG.xls) x 5 = 250k checks. Depending on your PC it may take 5-10 seconds for the screen to update when different Manufactures are selected from drop down list.

[Improvement]
Additional column for Series Code definitions. (Thanks to Blackcat4866).

I will automatically post the revision update to all those people in my GG private email list.

**NeoMatrix** · 10-19-2015

Would anybody like to see additional manufacturers in the XREF table ?
Would you like to see the XREF Sheet with the Models Ricoh, Gestetner, Nashuatec, Rex Rotary, Infotec and Lanier ?

Does any one have the latest XREF table that covers all the above models.
I do have an XREF table but I'm not sure it's complete or up to date for all manufactures.

**ptrflrs** · 08-02-2016

Latest Goose's guide dated June 2016. Don't have unzip utility? Get 7zip free HERE. Don't have excel? Get Libreoffice free HERE. You're welcome.

**NeoMatrix** · 08-02-2016

Originally Posted by ptrflrs

Latest Goose's guide dated June 2016. Don't have unzip utility get 7zip free HERE. Don't have excel? Get Libreoffice free HERE. You're welcome.

Update from 2014 to 2016.
There appears to be around 2500 new lines of text in the updated 2016 version.
Do you know if the entire 2016 data sheet has been checked over?

Have all duplicate lines been remove?
Has the grammar and general spelling(Jenglish) been tidied up to remove any multi-national ambiguity?

Thanks for the update...