Rickresource Rickenbacker Forum

cjj wrote:I'm sure there's probably some slick way to do it directly from an Excel spread sheet (which is how I entered the data), but I'm a total novice with Excel graphs.

I would almost guarantee you there isn't! Excel is a program I use and enjoy for a number of things, but graphing is rarely one of them.

jps wrote:Can you make the graph more of a chart/grid with the "columns" representing the pickup distance relative to the left edge (20th fret) and the "rows" would represent each instrument listed individually to avoid overlapping data?

+1!

jps wrote:Can you make the graph more of a chart/grid with the "columns" representing the pickup distance relative to the left edge (20th fret) and the "rows" would represent each instrument listed individually to avoid overlapping data?

The original "graph" was supposed to graphically look like what the pickup placement would look like, the rectangles representing the shape of a pickup, but obviously, as you add more models, they start to stack and things get too cluttered.

So, perhaps a more traditional style of graph would be easier to understand...

cassius987 wrote:

cjj wrote:I'm sure there's probably some slick way to do it directly from an Excel spread sheet (which is how I entered the data), but I'm a total novice with Excel graphs.

I would almost guarantee you there isn't! Excel is a program I use and enjoy for a number of things, but graphing is rarely one of them.

Hmm, are you sure you're talking about Excel here? How's this, generated in Excel from the data given:

I see you're really busy today, CJ.

Can you make them blips in stead of lines?

Hey, it's after work, it's dark outside, and it's 10 below (F) What else would I be doing???

Oh yeah, while you're at it, put them in chronological order, or by model.

cangaroo wrote:Hi ... i have this question for you, related to the thread topic.

I want to mod my 75 4001 and placing a toaster in 1/2 inch position. Anyway i noticed that i can place easily the pu in 1/2 position without the need for additional routing, and i was wondering if this is correct for a 75. Mine is a lefty so maybe the route was made the year before (as far as i know 74 is the last year of 1/2 inch basses), i also noticed that some pots are marked as 74 (but i guess this is rather common).

I guess the bass has not been routed again after production mainly because the route has the original finish in it, unless the whole bass has been refin, but i don't think so.

EDIT : where i can find a 1/2 inch pickguard for my rick ?

i've been loosely documenting the '75 basses for sale on ebay to make note on the switch from 1/2 to inch.

OB-1006 1/2
OC-1619 1/2
OD-1985 1/2
OD-2228 1/2
OD-XXXX 1/2
OE-XXXX 1"
OF-XXXX 1"
OG-XXXX 1/2
OH-XXXX 1"
OI-6259 1" (previously mine)

the OG could have been a hold over at the factory...i don't know, but i would say between april and may was the switch but does not guarranty the bass was made at a certain time ...just had the jack plate attached at a certain time. xxxx indicates the swines never offered the serial # to the auction. in theory, the factory could find a '89 manufactured 4003 under a bench in the raw...finish it and put a current jack plate on it and call it a 4003 from 2009. i doubt that would ever occur, but you get my point on holdovers. maybe the OG was changed from a 1" back to a 1/2 covertly as a selling point !

on another note...OB-1006 is an oddity. it was mapleglo and had a fretted dot neck with binding. could have been a fretless that was fretted post-factory as the bass looked original...again, who knows !

jps wrote:Oh yeah, while you're at it, put them in chronological order, or by model.

Well, they are pretty much in chronological order! Well, for some reason, it reverses them so they are in kind of reverse order, but a few didn't have years on them (and I forgot a few of the years), so the 1st 4 are kind of out of order.

As for making them blips, I can't see how to do that right off. There's a "Scatter" chart available, which is pretty close to what you want, but I can't seem to get it to put the model column on the vertical axis, only numbers. As I said, I don't do a whole lot with Excel. I could write a program in 'C' to do it, or even in Verilog and have it implemented in Silicon inside an ASIC, but that would be hard to see...

cjj wrote:

cassius987 wrote:

cjj wrote:I'm sure there's probably some slick way to do it directly from an Excel spread sheet (which is how I entered the data), but I'm a total novice with Excel graphs.

I would almost guarantee you there isn't! Excel is a program I use and enjoy for a number of things, but graphing is rarely one of them.

Hmm, are you sure you're talking about Excel here? How's this, generated in Excel from the data given:

image001.jpg

Sorry, I didn't mean to imply that it can't make graphs--just that I don't like to use it for that.

Ronbo's '75 data supports what we've been saying about the 1/2" spacing change to 1" - mid 1975.

When I get a chance, I will add this pickup data to the Girth file on another sheet. It will help keep it all together and easily accessible. In a few months we'll forget the name of this thread.

cassius987 wrote: Sorry, I didn't mean to imply that it can't make graphs--just that I don't like to use it for that.

No problem! I know people who excel (pun intended) at making all sorts of wonderful graphs and charts with Excel. I hardly use it at all, though it is a nice format for recording data and doing some simple calculations. Actually, I initially entered all the data people gave me on pickup positions into exce just because it's handy for stuff like that. But, as I said, I'm pretty useless with it, I'm actually surprised I made a half way reasonable chart with it!

johnallg wrote:Ronbo's '75 data supports what we've been saying about the 1/2" spacing change to 1" - mid 1975.

When I get a chance, I will add this pickup data to the Girth file on another sheet. It will help keep it all together and easily accessible. In a few months we'll forget the name of this thread.

Hey, great idea! Actually, I'd like to get as much data from all the different models as possible. Even better would be to understand why RIC put pickups where they did for different models. Hmm, I wonder if anyone really knows...

By the way, it's already in an xls file, I can just mail it to you if you want...

I didn't notice pickup space measurements for a 4004 with the pickups towards the bridge.
My '04 4004Cii JG:
From end of neck to the middle of the bass pickup: 1.75"
From the front end of the bridge to middle of the treble pickup: 2.44"

rickenbrother wrote:I didn't notice pickup space measurements for a 4004 with the pickups towards the bridge.
My '04 4004Cii JG:
From end of neck to the middle of the bass pickup: 1.75"
From the front end of the bridge to middle of the treble pickup: 2.44"

Do all the measurements from the middle of the 20th fret so we have a constant factor to gauge from. Your bridge pickup measurement won't make sense, otherwise, compared to the other measurements at this point.

I'll get a long machinists ruler that I can do that with later.