Jump to content
SAU Community

Recommended Posts

  • Replies 62.7k
  • Created
  • Last Reply

Top Posters In This Topic

  • chaos

    7164

  • Ska

    5791

  • BelGarion

    3645

  • Nexus9

    3590

Top Posters In This Topic

cya guys lata im going to get sum new tyres! 235/45/17 for the front. and the backs are ok. surprise!!!!

I'm getting new 235/45/17 sat $165 for Falken's ZE-326 :D But that is with the club discount through Bob Jane T-Marts.

I dont have speakers at work so it wouldn't be as effective.

Now this stupid excel formula wont work :D

What does the $ sign in an excel formula mean again.

ahhhhhh funny, soooo funny, must watch again!! :D

The dollar sign before a part of the cell reference makes that part of the reference static, ie if you move/change the cell containing the formula, that part of the formula isn't modified. If you have $A5, then copy it one cell down and right, the ref will change to $A6 - there is no $ sign in front of the row number, so it's allowed to change. Doing the same thing with A$5 will allow the A to change, so it'll change to B$5. I'm not the best at explaining things, but if you want to email the document to me I'm happy to look at it :D

VLOOKUP is used to look up a value in the leftmost column of a table, then returns a value from the same row.

So, your formula is looking for a value (whatever is in B63 of the current sheet, eg 'fred') in the leftmost column of the area between A4 and S93 on the sheet named 'main sheet' in the file '26_261204.xls'. When it finds 'fred' in this column, it returns the value in column 19 (ie column S) of that row. The 'FALSE' at the end specifies that it must be an EXACT match, rather than an approximate one.

OMG your so smart.

Sorry I had to ask my boss. I didnt want to have to but I did. The formula was right and it was looking up what it needed to in the right sections.. but while I was on leave last week one of the ladies that was doing my work changed the name of one of the guys in one of the databases so what I was telling it to look up, it couldn't find cause it was spelt different in the two databases.

It was only one entry that was stuffing up, all the rest were fine!

Thanks heaps marc. I actually understand the formula now. My boss just showed me and said "heres how you copy it across" Didn't actually tell me what it does and what it's doing.

Guest
This topic is now closed to further replies.



  • Similar Content

  • Latest Posts

    • There's plenty of OEM steering arms that are bolted on. Not in the same fashion/orientation as that one, to be sure, but still. Examples of what I'm thinking of would use holes like the ones that have the downward facing studs on the GTR uprights (down the bottom end, under the driveshaft opening, near the lower balljoint) and bolt a steering arm on using only 2 bolts that would be somewhat similarly in shear as these you're complainig about. I reckon old Holdens did that, and I've never seen a broken one of those.
    • Let's be honest, most of the people designing parts like the above, aren't engineers. Sometimes they come from disciplines that gives them more qualitative feel for design than quantitive, however, plenty of them have just picked up a license to Fusion and started making things. And that's the honest part about the majority of these guys making parts like that, they don't have huge R&D teams and heaps of time or experience working out the numbers on it. Shit, most smaller teams that do have real engineers still roll with "yeah, it should be okay, and does the job, let's make them and just see"...   The smaller guys like KiwiCNC, aren't the likes of Bosch etc with proper engineering procedures, and oversights, and sign off. As such, it's why they can produce a product to market a lot quicker, but it always comes back to, question it all.   I'm still not a fan of that bolt on piece. Why not just machine it all in one go? With the right design it's possible. The only reason I can see is if they want different heights/length for the tie rod to bolt to. And if they have the cncs themselves,they can easily offer that exact feature, and just machine it all in one go. 
    • The roof is wrapped
    • This is how I last did this when I had a master cylinder fail and introduce air. Bleed before first stage, go oh shit through first stage, bleed at end of first stage, go oh shit through second stage, bleed at end of second stage, go oh shit through third stage, bleed at end of third stage, go oh shit through fourth stage, bleed at lunch, go oh shit through fifth stage, bleed at end of fifth stage, go oh shit through sixth stage....you get the idea. It did come good in the end. My Topdon scan tool can bleed the HY51 and V37, but it doesn't have a consult connector and I don't have an R34 to check that on. I think finding a tool in an Australian workshop other than Nissan that can bleed an R34 will be like rocking horse poo. No way will a generic ODB tool do it.
    • Hmm. Perhaps not the same engineers. The OE Nissan engineers did not forsee a future with spacers pushing the tie rod force application further away from the steering arm and creating that torque. The failures are happening since the advent of those things, and some 30 years after they designed the uprights. So latent casting deficiencies, 30+ yrs of wear and tear, + unexpected usage could quite easily = unforeseen failure. Meanwhile, the engineers who are designing the billet CNC or fabricated uprights are also designing, for the same parts makers, the correction tie rod ends. And they are designing and building these with motorsport (or, at the very least, the meth addled antics of drifters) in mind. So I would hope (in fact, I would expect) that their design work included the offset of that steering force. Doesn't mean that it is not totally valid to ask the question of them, before committing $$.
×
×
  • Create New...