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

    • So stock ECU does not like anything above 10 psi?  That Nistune one is just for "try" if it will be any different, I know it need to be tune for that. I know but YOU may know about these problem but i/we dont. They few little Skylines here let alone people who know anything about tham so that is why iam asking here  
    • So now we have a radiator with no attachments whatsoever. It lifts up with a particularly tight spot between the drivers side air box mount and the lower radiator outlet, but if you've got this far you will sort that too. This is the lower mounts with the rad out so you can see where the rubber bushes go, it is a straight shot upwards Done! Assembly is the reverse of disassembly, with blood less likely to be shed.
    • Right, onto the second last trick. The Air Con condenser is mounted to the front of the radiator and stays in the car when the radiator is removed. There are 2x 10mm headed self tappers holding the top of the condenser to the radiator, remove those The bottom of the condenser is attached to the radiator with clips. You need to lift the condenser out of those clips and clear (up, then forward). f**ked if  could work out how to do that last bit with the front bumper on. I hope you can, and you share the trick.  Bumper removal probably deserves its own thread one day once I've recovered the will to live, but basically you need to remove the wheels, front inner guard liners (clips and 10mm headed bolts), the self tapper between the guard and the bumper at the rearmost point of the bumper (same as an R32 that bit), any remaining clips at the top/front of the grill, an absolute bastard design with a plate that holds the top of the bumper above the headlight each side (only 1 bolt which is tricky to get to, but the plate catches 2 places on the bumper and must be removed....carefully!) and push clips between the bumper and guard under the headlight. If you've done all that you will be faced with wiring for the fog lights on both sides and in ADM Q50 RS at least, 4 nasty tight plugs on the driver's side for the ADAS stuff. So, the clips at the bottom look like this on drivers side (looking from the front) And on the passenger side (also from the front), you can see this one is already out Clearance on both of these are super tight; the condenser needs to move up but the upper rad support mount prevents that, and the radiator can't move down far because it is (rubber) mounted. Once you achieve the impossible and drop the condenser off those mounts so it does not stop the rad moving, you are good to go
    • OK, next the shroud needs to come off and there are a couple of tricks. Firstly, there is a loom from near the passenger side headlight to the fans, coolant temp sensor etc and there is no plug to undo.  In my case I was OK to leave the shroud on top of the engine so I just undid the passenger side fan plug and about 10 of the clips which gave enough free wire to put it aside. The fan plugs were super tight, the trick I used was a small falt screwdriver to push down on the release tab, then a larger flat screwdriver to lever the plug out of the fan unit....be careful with how much force you apply! If you need to remove the shroud altogether for some reason you will have to deal with all the plugs (tight) and clips (brittle)....good luck. I removed all of the clips and replaced them with cable ties that I will just cut next time. Also, in the Red Sport / 400R at least, the intake heat exchanger reservoir hose is bolted to the shroud in 2 places with 10mm headed bolts; so remove them (the hose stays in the car; no need to undo it at the t fittings down at the radiator lower mount. Once you've dealt with the HX hose and the wiring loom, there are 3x 10mm headed self tappers holding the top of the shroud to the radiator; remove those.   The shroud then lifts out of the bottom mounts where it sits on the radiator, up and onto the engine out of the way. Simples
    • Ok, disregard my “rate them” comment, sorry for my unrealistic input
×
×
  • Create New...