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

    • You have the option to do this. Nobody but me ever did this (go slower, I mean) Everyone seems to fall victim to "This would be a great setup for you, but for me, I need a little more power..."
    • Save yourself the headache of an alarm. Immobilizer on the signal side of the main EFI relays so it won't start is good enough. DIY killswitch is the same thing except instead of a nice passive system you need to remember to switch it on and off.
    • Yeah, the advent of canbus was supposed to cut down on wiring weight, then some bright marketing wonk says "oh, look at all these wonderful tech gadgets we can cram in here now that we have this wonderous technology" and some arsehole safety legislator says "oh, look at all the wonderful surveillance and tracking gadgets we can cram in here now that we have this wonderous technology" and some dipshit young engineer who has grown up thinking that an extra 500000 lines of code is not a problem because storage is cheap these days says "oh look at all this wonderful shit I can do to one up those dipshit arsholes over at VW" and the Karens of the world all go "oh look at all these fancy things I can do on my screen (so long as I am not driving on a bumpy road wherein touch screens immediately become the single most stupid shit idea ever shoveled into a car) and my 19 zone airconditioning keeps my sweaty fat folds a bit less damp and the windows close themselves because I'm too fat and lazy to wind them up for myself and these reversing sensors would have been great if I'd paid attention to them instead of smashing them on the bollard while I was reversing and staring fixedly forward that day I went to pick up little Charlize from ballet" and the sweaty mongoloids who say "oh this wonderful collision avoidance technology with these 45 excellent radar antennae scattered across the front of my car mean I can tailgate like a methed up tradie at full speed with no fear because the car and the 35 airbags will protect me if it all goes wrong" ...... </shallistopranting?>
    • There's a post from a member (can't recall who), went down the path of a twin scroll G30-660 and it's doing over 300kW+ AND comes on about the same as a high flow RB25DET turbo. Have your cake and eat it too in this case. TBH, if I had a 2nd chance of building my car again (i.e. someone gave me what I wanted for my shit box, but the deal was I had to re-build another R33 and keep the change) I would just pop in a stock NEO motor (with new seals, rod bearings, ARP studs, head gasket, sump, Nitto pump), get a smaller twin scroll turbo, modify the stock low mount (keep the divider in place), and make a solid 300kW on 98RON and call it a day. 
    • It's all the sound deadening, and extra shit piled into them, plus all the extra (even though it's thinner) material for crumple zones. I can't fathom in modern cars why they need canbus to the headlights, and why the headlights must be vin coded on some cars to the ECU, BCM, and security module! Especially when they claim it's for security, yet, the canbus at the headlights let's thieves steal the car in minutes, so even more cars are being stolen! The Mercedes Sprinter 907 vans. They're a huge van, but a "basic" van. Yet they have that many canbus networks, plus two Lin networks, AND an Ethernet network. Logging a single network alone of 8 byte data frames, and they will generate a 20mb log file in 5 minutes. That's one network, and I can't remember the exact amount, but there's over 10 full CAN2.0B networks in them. I'm not a fan of modern cars, oddly, more and more I hate DBW, and all the bullshittery the cars try and interfere with. But all that bullshittery adds weight, plus crazy regulations on crumple zones, plus, ever picked a modern seat up, half of them have like 4 electric motors in them and will weigh 30+kg each. Then all the motors for things like adjustable steering columns blah blah blah. And did I mention the sound deadening so you can even hear an ambulance right behind you even if you 7.2surround sound is off?
×
×
  • Create New...