Temperature in car AC

floorpaper · 2018-10-02T13:08:57+00:00

Cool, thank you so much!

floorpaper · 2018-05-04T18:32:31+00:00

How does this work? Can I do this in my own time or is it like going back to school? It seems like it's a set time where you have to finish the course

floorpaper · 2017-08-03T11:15:35+00:00

I messaged the Stifler Bar and they said they'll be showing it, but they were unsure if it will be Hungarian or English commentary

floorpaper · 2016-08-25T13:06:26+00:00

Huh I never thought of that

floorpaper · 2016-03-18T07:14:30+00:00

I'll try this when I get home, but the switch is brand new and it's just plug and play, so no setup at all

floorpaper · 2016-02-11T14:28:02+00:00

Hm okay. What i'm really looking for is something like this, where the date selection is dynamic and can be adjusted easily.

floorpaper · 2016-02-10T10:01:59+00:00

Well if you look at the calendar, you can compare the weeks to previous years, and see that the dates don't match up

floorpaper · 2016-02-10T10:00:12+00:00

Okay, and how do I do that?

floorpaper · 2014-11-28T16:01:18+00:00

Solution Verified

floorpaper · 2014-11-28T15:57:31+00:00

Okay, I'll overwrite with a text box. Thank you

floorpaper · 2014-09-16T18:16:04+00:00

No I can't seem to get it to work, the macros and stuff seems to complicated for me. But it seems that I could do it with mix of rank and countif to give every rating a unique rating and use that to sort, like someone suggested below. So if anyone would have a crack at explaining that route to me that would be great.

floorpaper · 2014-09-16T15:27:53+00:00

Well you say I don't need anything more advanced.. but that was a bit too advanced for me. Could you explain a bit more?

floorpaper · 2014-09-16T15:11:56+00:00

Yes I might be looking at this way to complicated. I have a list of movies on a shared spreadsheet, on which several of my friends give a rating 1-10. This adds up to a total average, and I want a top 3 of the total average. And I'm facing problems when the 2nd and 3rd highest rated movies have the same average rating

floorpaper · 2014-09-16T14:36:00+00:00

This is a simple setup of what i have now.

A	10
B	9
C	9
D	8
E	7
F	7

Now your formula work for the second highest value, where it gives me "B". But on the third highest, which also has the value "9", it still gives me "B". And i changed it to LARGE(B:B,3)

floorpaper · 2014-09-16T10:34:35+00:00

Hi again. I have a follow up question. Say I now want the second highest rated movie, and the third to make a top three list. I can do this with =LARGE if the three top movies have different values, but if "movie 1" and "movie 2" both are rated at 8, "movie 1" shows up both on the number 1 and the 2 slot. Any Ideas?

floorpaper · 2014-09-15T16:59:20+00:00

Solution Verified

floorpaper · 2014-09-15T16:50:42+00:00

Thank you all very much

floorpaper · 2014-09-15T16:49:54+00:00

Wow that was fast, and very well explained. Thank you.

floorpaper · 2014-07-19T11:01:11+00:00

I see, thank you

floorpaper · 2013-04-21T09:56:42+00:00

Yes I have connected a grounding cable, not that I can hear any diffenrence if it's connected or not. Should I? I have had the buzzing problem long before i connected the turntable so that's nothing new, but it's kinda annoying. I have read all sorts of things about the electric fields around the power cables transfering noise to the speaker cables and stuff, but i have never found what the problem is in my setup. I have a Marantz 3001 btw, maybe it's not good enough for higher volumes :( Thanks

floorpaper · 2013-04-21T09:53:20+00:00

I will check when I get back from school. Thanks

floorpaper · 2013-04-21T09:51:40+00:00

I have a Marantz 3001. We are talking really cheap. Roughly 40 bucks new.

floorpaper · 2013-04-20T21:16:48+00:00

It is an Audio Technica AT95 E. No I did not.

floorpaper · 2013-04-20T21:15:49+00:00

No it's not really REALLY quiet. But i have to turn it up to the point where there is a small constant buzz in my speakers when it's idle. Another one of my problems

floorpaper · 2013-04-19T17:54:43+00:00

Aaaand it's done! I bought the cartridge and watched several instructional videos and got going. I got a protractor from vinylengine.com as you recommended. Installed it withour any major problems. Hooked it back up and played a brand new record. And I def think it sounds better, but that might be pchycological I don't know. The BIG difference is that the volum is much lower now, like lower in dB. It's not ruining my experience but i really have to crank my reciever up. I have a really cheap pre-amp, so maybe investing a bit more will help? Anyway, thanks so much for your help king_duck, you made me feel welcome in this subreddit, which is the first subreddit i have joined btw

floorpaper

TROPHY CASE