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

    • Yes...but look at the numbers. There is a tiny tiny fraction of the number of Joules available, compared to what is used/needed. Just because things are "possible" doesn't make them meaningful.
    • Thanks for taking the time to post that ! If anything changes or happens please do update us. 
    • Somehow Vertimass/Oak Ridge National Labs has figured out a catalyst that can convert ethanol into C9-C10 hydrocarbons in basically a single step without ending up with a bunch of ethylene or similar waste products: https://patents.google.com/patent/WO2023224867A1/en I still don't think anything like this will keep us from needing to transition to EVs regardless along with all kinds of other electrification, but things like this will go a long way towards alleviating the problem of how to electrify things like planes. Renewable diesel is seemingly an easier problem as well, Chevron is already running refineries for the stuff and the primary feedstock is tallow and other waste fats from agriculture.
    • Ok so I have sorted everything with my uniclutch and  i can offer up a bit of feedback and some things that might help others.    I found problems with factory damper line. Weird shit and had trouble with peddle adjustment    I used this https://au.gktech.com/products/r33-gts-t-skyline-braided-clutch-line?_pos=2&_sid=22b01b9b9&_ss=r Also when adjusting peddle leave a bit of play. You can get into a over stroke condition easy.. Make sure you can push the slave forward after adjusting to confirm fluid can return to master then you will need to pump it up heaps…..not sure why but that’s how it is.    last thing the splined adapter is machined perfectly. If your input shaft is old like mine was I would put a bit of valve grinding paste on it and stroke it like a 15 year old. Just to give it a tad more clearance and to better match it to the spline.    reason is on a near flat shift I have had situation where the peddle returns a millisecond after you lift from the clutch. No slip or anything but I reckon this is due to tolerance on the spline being way tighter than stock clutch and binding for a sec. I think this will go away but also my spline was old. Box is old so I guess I should have checked better. It’s a super neat fit.    it feels light as and holds awesome without any noise    
    • My Fuga Hybrid is JDM, 2014 model but very similar to the V37 from the looks of things..same platform just physically larger and very comfortab;e
×
×
  • Create New...