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

    • I hope it's actually possible. This is a write off in insurance world.
    • Yup. 2-way with shallow ramp angles. Still works.
    • That was the first session so not a lot to take from the day. It was low 20s ambient and the coolant had got to 110 (and obviously had some pressure!) so that still needs to be addressed. I haven't downloaded the data yet but will. I had refilled the auto trans with Redline DT6 because it claimed the best viscosity I could find at 100o. It wasn't really long enough to get a good feel for that; while the trans got to 100o in the session it still wasn't shifting crisply as I hoped. I think I'll try a few more sessions before judging. No steering motor overheat but I'd hope not in only 1 session! But finally the suspension; it was night and day over the standard stuff and the car was a couple of seconds quicker on the same crappy tyres, which is a huge difference. I'll stick with that and get some sway bars and a mechanical diff sorted too and see how that all goes together
    • I guess it’s partially a compromise of how my car is used, wanting to be able to switch from drift to grip with track side on-car adjustment. Also partially with the way the knuckles are set there is more static camber but less dynamic camber gain. 
    • OK, so update from the track day on Friday It was a classic "an unfortunate series of events'. There were a few cars around and when i checked my mirror coming out of the fish hook I notice some smoke from the rear of mine. Looked again and it was getting much worse, I figured I'd blown a turbo or something to got off it and pulled off the racing line. However.... since it is a left hairpin into a right kink, I was on the inside of the next corner. There was a car passing me on the left and a big drop off over the ripple strip on the right......and someone had knocked the witch's hat that was on the apex about 1m onto the track. So, between those 3, I decided to mow down the cone and not damage my car/the other car. Right choice, but surprising result.  The car decided the cone was a small pedestrian so it blew the rear bonnet hinges up to protect their head in the upcoming person to car impact....I didn't see that coming and like an airbag deployment it happened super fast. Straight into the pits from there, everything was driving fine but it became clear it was a coolant leak not smoke, it was billowing up onto the windscreen. Onto the trailer and home. I'll do a separate thread about the repair (once I work out what it is ), but the immediate problem was the bonnet wouldn't open because the front was pinched onto the front bar and would not release. Ultimately we unbolted the hinge from the bonnet, pulled it back a little and it released from the front OK. "There's your problem", the top radiator hose had popped off at the radiator.
×
×
  • Create New...