[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y ] [Home]
4chanarchives logo
#KeepFightingMichael >Still waiting on new cars >Hami
Images are sometimes not shown due to bandwidth/network limitations. Refreshing the page usually helps.

You are currently reading a thread in /sp/ - Sports

Thread replies: 255
Thread images: 173
File: Schumacher.jpg (53 KB, 620x465) Image search: [Google]
Schumacher.jpg
53 KB, 620x465
#KeepFightingMichael

>Still waiting on new cars
>Hamilel dragging feet on new contract
>Schumi is a very sad potato
>Engine loophole allows in season modification

>Jessica is now Mrs. Button
>Jessica Doppelganger Porn Avaliable
>http://xhamster.com/movies/1518054/orgasms_teen_takes_older_gent_as_lover.html

Thread Dies = Bianchi Dies
>>
Sauber cheeky dubs
>>
I'm suffering without F1 action lads

Jerez testing feels so far away
>>
>>55398996

We might make it.
>>
File: ShinyMio.gif (3 MB, 350x197) Image search: [Google]
ShinyMio.gif
3 MB, 350x197
i officially declare the F1 threads free of the fucking bianchi curse.
>>
>>55399048

It's not cure of autism.

>>55399052
>>55399022
>>55398999
>>55398975
>>55398904
>>55398881
>>55398736
>>
File: 0980398534534.jpg (31 KB, 460x276) Image search: [Google]
0980398534534.jpg
31 KB, 460x276
>>55399048
No the image that i wanted to post but uh... whatever.
>>
>>55399048
Bianchi was taken from us with quints

Only quints can save him.
>>
Quints to save potato's
>>
File: Jessica_3.jpg (55 KB, 593x436) Image search: [Google]
Jessica_3.jpg
55 KB, 593x436
>>55399085
>>55399078
>>55399048
Guys pls
>>
>>55399117

I'm just fucking done. I'm going back to drinking, I've fucked everything else up.
>>
>The site will be going down for performance upgrades shortly. Go outside!

MOOOOT NO WHAT ABOUT BIANCHI

Also it's 1am I can't go outside
>>
>>55399452

GOODBYE BIANCHI
>>
File: 1891000-behold__optic_blast_.png (681 KB, 800x600) Image search: [Google]
1891000-behold__optic_blast_.png
681 KB, 800x600
>>55399452
>>55399496
THE LIFT
WILL BE
LIFTED
I FUCKING
TOLD YOU
SO
>>
>>55399543
We have to get quints Mexibro for Bianchi

We won't have another shot for a month or 2 by which time I will have forgotten
>>
>>55399583
oh god it's gonna take some time.
>>
>>55399749
100 to go

get ready

>tfw moot decides to disable quints as an upgrade
>>
>>55399901
oh shit.
>>
go to sleep
>>
File: 910h 2.jpg (44 KB, 599x337) Image search: [Google]
910h 2.jpg
44 KB, 599x337
Caterpillar 910H 4eva
>>
File: rosb-6.jpg (226 KB, 1680x1120) Image search: [Google]
rosb-6.jpg
226 KB, 1680x1120
For Bianchi and just end it
>>
DUBS FOR BIANCHI
>>
he's going to die
>>
File: starandstrifesmotehrfucker.jpg (131 KB, 1280x740) Image search: [Google]
starandstrifesmotehrfucker.jpg
131 KB, 1280x740
>>55399988
this counts.
>>
>>55399988
trips + dubs = quints

Bianchi confirmed for not kill
>>
File: drakkenlarge.jpg (127 KB, 800x533) Image search: [Google]
drakkenlarge.jpg
127 KB, 800x533
>>55400072
We did it boys, lets go home.
>>
>>55400014
I think none zero quints are disabled.
I can't see it on the front page

test:
>>55400000
>>55499999
>>
File: Jessica_dat_belly_button.jpg (119 KB, 640x640) Image search: [Google]
Jessica_dat_belly_button.jpg
119 KB, 640x640
In case moot dies during the update and we never see each other ever again.

It's been an honour
>>
>>55400457
don't be this negative, everything is gonna be fine
>>
File: FULL.jpg (2 MB, 1600x800) Image search: [Google]
FULL.jpg
2 MB, 1600x800
>>55400498
man i miss the days when mexican drivers had mexican sponsorship liveries
>>
File: MexicoMexicoMexico2.jpg (94 KB, 900x653) Image search: [Google]
MexicoMexicoMexico2.jpg
94 KB, 900x653
>>55400606
good old 2002 days man, good old days
>>
First for Jules gonna make it
>>
>>55401421
#POTATO4LYFE
>>
>>55401443
no need to be rude

btw, image uploading still down?
>>
>>55401449
yep

#THANKSMOOT
>>
Daily Reminder that Toto Wolff is a huge Cuck
>>
>>55398842
>2015
>putting the subject in the name field

come on now guys
>>
>McLaren MP4-30
It will be a very conventional looking thing and another 'exciting' shade of silver. Expect nothing more from the most autistic team on the grid. Honda engine to be 2nd best to the merc.
>Lotus E23 Hybrid
It's last years car but with the new nose we say at Austin on and some Aero updates. Oh and the merc unit of course
>Ferrari "project 666"
Pretty much the exact same car
>Force India VJM08
Expect a new nose and that's your lot
>Mercedes W06 Hybrid
Class of the field, very little changes needed. Will look more or less the exact same.
>Red Bull RB11
Expect an extraordinarily clever interpretation of the nose rules and a beautiful aero package for Newey's final car.
>Sauber C34
It will be a pig. A good looking one though.
>STR10
Similar performance to this year but with a conventional nose. Will be the most average and uncontroversial Formula 1 car in history.
>Williams FW37
Hopefully they've employed someone who can get the best out of the Martini sponsorship and make the livery the undisputed GOAT on the grid. A new nose and a bit more downforce, closer to the merc but still struggling to get on the top step.

And also
>Caterham
If they make it, comedy gold with the 2014 car but a new nose will ensue. I doubt it though.
>Manor
it's not happening, but some people are STILL holding out for it even though everything has been sold.


Ladies and gentlemen, the 2015 cars.
>>
>>55401975
>Newey's final car
RIP Red Bull.
>>
>>55401449
>image uploading still down?

Real nice imageboard we have
>>
>>55402283
>Image uploading is fucked

Brilliant

Where did everyone go while the site was down?
I checked [spoiler]8[/spoiler]chan and people ghost posting on the archive like /a/ does
>>
>>55402283
I had a quick look on /g/ and there wasn't the usual
>Hey guys I borked the site again how do I fix it?
thread from Moot.
>>
>>55402427

I really wish /F1/ would migrate
>we could make our own board
>>
Holy shit that Jessica porn! I honestly just masturbated to it. I just had to.
>>
>>55402465
There is an /F1/ board already, but it's slower than the 2012 HRT.
>>
>>55402925

Why? It cant be that bad, if we all go there it would be rather cool.

We could make our own forum, I'd be happy to do it, no rules and autistic mods. I think I've got enough server space so I could foot the bill. Anyone interested?
>>
>>55402925
>Deader than Bianchi
>>
>>55403160

So if we really want our own board/forum here are our options.

>Forum

This would be rather easy to implement, and probably a lot more advanced than the autistic image board software out there. Even though we would have to change the way we post, we could still have the general thread at the top, and then have specific circlejerks below it.

>Imageboard

We could run wakaba, it would be rather shit looking initially, and it will take a fuck ton of time to get working correctly, but it will give us the imageboard experience.

As much as I like the imageboard experience, a forum would be pretty nice, especially if we get a proper one with real features, with no dumb mods, and if we keep it somewhat private, we should be okay.
>>
>>55402925

Looks pretty /comfy/ tho
>>
>fucking up the thread subject
It's like the most important thing about making a thread, why did you even bothered?
>>
>>55404443

Made worse by not putting F1 or Formula 1 in the OP, making the thread impossible to search for.

>I really with retards would stop making threads
>>
>>55402925
And it wasn't by one of us but by someone from /r/formula1
>>
>>55404674

yeah, that's going to be a problem

>he'll likely get butthurt about hamnigga posts
>>
>>55398842
What do Schumacher,Bianchi and cucumber have in common?
They're all vegetables.
>>
>>55404691
>This board is the official (possibly not in Bernie's eyes) home of Formula 1 on [spoiler]8[/spoiler]chan. 4chan is kill, and [spoiler]8[/spoiler]chan allows custom boards hence the reason we're here instead of just making f1 threads that 404 all the time on /sp/.
>Yes, this is the official place.
>In all seriousness though, I started this board after being frustrated with reddit.com/r/formula1 becoming the worst of reddit circlejerk and having terrible post quality, and because f1technical.net had obsessions with user seniority and hierarchy.
>My hope is that the anonymity afforded by [spoiler]8[/spoiler]chan, the lack of a comment rating system, and the extremely lax rules will create a better quality of discussion for Formula 1 since there is no incentive to circlejerk.
>Any and all constructive criticism is welcome. Invite your friends if you'd like so the off season isn't quite as boring.

I can tell it wouldn't work but at least he is nice and we have a place to go if moot takes us offline.

Maybe it's just me but going on there feels really weird.
You can post 8Mb images, with size 10000 x 10000px and you can post 5 images per post.
I should like it more but it just feels too much. Somehow I have come to like some of the limitations here.
Also we haven't been affected at all by mods so we don't really have any reason to leave.
>>
>>55404727
-cucumber
+pizza
FTFY
>>
>>55404754
>>55404754

or
-cucumber
+Karthikeyan

>http://www.motorsport.com/f1/news/angry-vettel-calls-karthikeyan-a-cucumber/
>>
>>55404749
>I should like it more but it just feels too much. Somehow I have come to like some of the limitations here.

The only thing I don't like is GIF's automatically loading.It fucks pages load times, wastes a heap of host and client data, and bogs down the servers (as does auto refresh on by default).
>>
>>55404958
>Veetle in charge of not being Richardo's cuck
>>
>>55404998
>GIF's automatically loading.
>It fucks pages load times

>Australian internet connections
>>
>>55405010
>making posts that have nothing to do with what's being discussed because your arse is still hurting from the raping Vettel gave Webber
>>
>>55405097
Who's webber?
>>
>>55405123
>the best comeback you could think of
>>
>>55405010
>Vettltetelle in charge of not being a phallic object
>>
can someone explain the f1 term 'outbrake' for me? i am a bit casual, but the meaning seems ambiguous depending on the subject, ie 'to outbreak someone' versus 'to outbreak oneself'.
>>
>>55406336
outbraking someone else is braking later than the other guy and not run wide, usually overtaking the other guy.
outbraking yourself is braking too late and running wide and lose time because of it
>>
>>55406336
If you are side by side down a straight against someone and break later then them you will have outbroke them and in theory got to the corner earlier and made the overtake.

If you break too late so that you can't make the apex of the corner you will outbreak yourself and have gone too deep into the corner and will lose time.
>>
>>55406372
>>55406406
thanks.
>>
>>55406445
>>55406336
Monza demonstrates this pretty well

This is Hamilton outbreaking Kimi into the first chicane:
https://www.youtube.com/watch?v=fzFDvZhntvQ

This Rosberg outbreaking himself into the first chicane and going straight on to save the tyres
http://mediacrush.net/TU2Ei0XiBLTZ
>>
Saving Jules Bump
>>
Can we just spam the fuck out of the thread until 500 posts and someone not retarded can make a new thread?
>>
File: 1409056850263.jpg (328 KB, 700x1690) Image search: [Google]
1409056850263.jpg
328 KB, 700x1690
>>
File: 1410815024371.png (278 KB, 622x387) Image search: [Google]
1410815024371.png
278 KB, 622x387
God damnit I can't use this anymore

;_;
>>
>>55412595

massa said he wouldn't help rosberg because he's still mad at glock
>>
File: singapore failure.jpg (129 KB, 1440x810) Image search: [Google]
singapore failure.jpg
129 KB, 1440x810
Unless...
>>
File: whodat.jpg (300 KB, 1440x810) Image search: [Google]
whodat.jpg
300 KB, 1440x810
>>55412827

wait a minute...
>>
>>55412827
>>
>>55401975

the new ferrari is james allison's first ferrari, so it should look different, but apparently the initial aero results were identical or worse to the F14 T.
>>
File: bum.png (1000 KB, 863x638) Image search: [Google]
bum.png
1000 KB, 863x638
dead thread pls
>>
File: wagbffs.png (2 MB, 903x858) Image search: [Google]
wagbffs.png
2 MB, 903x858
on the march to 500 posts and a new thread
>>
>>
File: 1343564175839.jpg (1 MB, 2052x1368) Image search: [Google]
1343564175839.jpg
1 MB, 2052x1368
posting an F1 car before mods come to rekt our shit.
>>
File: silvera.jpg (109 KB, 2000x850) Image search: [Google]
silvera.jpg
109 KB, 2000x850
This fucking car will be making 400kph in the fairmont harpin
>>
File: 2wdytja.jpg (216 KB, 1536x1024) Image search: [Google]
2wdytja.jpg
216 KB, 1536x1024
>>55412088
yes we can
>>
File: 9a02aa5fddf489036a596acf4d1fefaa.jpg (870 KB, 2048x1536) Image search: [Google]
9a02aa5fddf489036a596acf4d1fefaa.jpg
870 KB, 2048x1536
>>
File: 20uwcj6.jpg (134 KB, 644x429) Image search: [Google]
20uwcj6.jpg
134 KB, 644x429
>>
File: 95monfrentzen.jpg (134 KB, 1024x709) Image search: [Google]
95monfrentzen.jpg
134 KB, 1024x709
>>
File: 142wl1.jpg (164 KB, 1536x1024) Image search: [Google]
142wl1.jpg
164 KB, 1536x1024
>>
File: 933.jpg (95 KB, 999x749) Image search: [Google]
933.jpg
95 KB, 999x749
>>
Recommend a good race

Preferably 2009+
>>
>>
File: BoJ2UppCMAAogGZ.jpg (79 KB, 600x800) Image search: [Google]
BoJ2UppCMAAogGZ.jpg
79 KB, 600x800
>>
>>55418161
>fairmont hairpin

That is the first time I've heard it called that.

Also mods will get more pissed by us dumping F1 cars then us posting a wag or 2
>>
File: demlips.png (2 MB, 919x916) Image search: [Google]
demlips.png
2 MB, 919x916
>>55418657

Canada 2011

Valencia 2012

That should get you ready for the 2015 Mclaren lineup hype
>>
File: 2820.jpg (125 KB, 1024x768) Image search: [Google]
2820.jpg
125 KB, 1024x768
>>
File: 4699.jpg (118 KB, 1024x773) Image search: [Google]
4699.jpg
118 KB, 1024x773
>>
File: come_to_bed_anon1.webm (3 MB, 1920x1080) Image search: [Google]
come_to_bed_anon1.webm
3 MB, 1920x1080
>>
File: 1341668872835.gif (3 MB, 256x192) Image search: [Google]
1341668872835.gif
3 MB, 256x192
>>
File: 1331957864804.jpg (751 KB, 2000x2000) Image search: [Google]
1331957864804.jpg
751 KB, 2000x2000
post classic /f1/
>>
File: 3142137_11a141f91b_o.jpg (205 KB, 1600x645) Image search: [Google]
3142137_11a141f91b_o.jpg
205 KB, 1600x645
>>55418657
australia 2010
>>
>>
>>55418657
There has been 24 different Grand Prix since 2008.
This is what a season made up of the best of each grand prix looks like.
>>
>>55418749
what do you call it? Hotel corner?
>>
File: best_season.jpg (29 KB, 846x52) Image search: [Google]
best_season.jpg
29 KB, 846x52
>>55419001
forgot image

>>55419030
Loews Hairpin, Grand Hotel Hairpin or Gare
>>
File: the_cutest_little_autist.webm (2 MB, 1280x720) Image search: [Google]
the_cutest_little_autist.webm
2 MB, 1280x720
>>
>>
File: em.png (1 MB, 914x908) Image search: [Google]
em.png
1 MB, 914x908
>>
File: 13069043184_0d9574afb1_h.jpg (1 MB, 1600x996) Image search: [Google]
13069043184_0d9574afb1_h.jpg
1 MB, 1600x996
>>
File: 1410399513897.jpg (190 KB, 1293x726) Image search: [Google]
1410399513897.jpg
190 KB, 1293x726
>>
File: 2014 Results.jpg (356 KB, 1440x900) Image search: [Google]
2014 Results.jpg
356 KB, 1440x900
I'm practicing excel for my new job I start tomorrow and used an idea an ameribro had awhile ago to award points down to last place throughout the season.

- how do I assign a certain amount of points for a specific result? i.e 30 points for first, 25 for 2nd.

- what sort of points system should I use? Before I used 22 minus result, but Rosberg ended up beating Hamilton that way.
>>
File: 1410930430057.jpg (335 KB, 2048x1365) Image search: [Google]
1410930430057.jpg
335 KB, 2048x1365
im going to miss this beauty next year
>>
>>55419056
In fact this is what the championship would look like for such a season

https://docs.google.com/spreadsheets/d/13_HFG99tyZuZpiDqKoerZNlahhclS6liMiQbgf_GlKk/edit?pli=1#gid=1395533443

And if you chose only the worst races

https://docs.google.com/spreadsheets/d/13_HFG99tyZuZpiDqKoerZNlahhclS6liMiQbgf_GlKk/edit?pli=1#gid=611106726
>>
File: germany.png (2 MB, 1776x1732) Image search: [Google]
germany.png
2 MB, 1776x1732
>>55418970
>>
File: 1411513456876.jpg (411 KB, 994x1280) Image search: [Google]
1411513456876.jpg
411 KB, 994x1280
>>
File: 1414863134287.jpg (204 KB, 1280x890) Image search: [Google]
1414863134287.jpg
204 KB, 1280x890
>>
File: vettemplate.png (2 MB, 1600x1067) Image search: [Google]
vettemplate.png
2 MB, 1600x1067
>>55419281 Template
>>
File: 1351064929179.jpg (23 KB, 232x197) Image search: [Google]
1351064929179.jpg
23 KB, 232x197
>>55398842
Fuck You OP I thought we killed Bianchi when I searched for F1
>>
File: 1415839527785.jpg (749 KB, 3635x2384) Image search: [Google]
1415839527785.jpg
749 KB, 3635x2384
>>
File: wh77ap.jpg (289 KB, 1600x1200) Image search: [Google]
wh77ap.jpg
289 KB, 1600x1200
>>
File: zt4u.jpg (173 KB, 1539x996) Image search: [Google]
zt4u.jpg
173 KB, 1539x996
>>
File: 1335096262437.jpg (53 KB, 300x434) Image search: [Google]
1335096262437.jpg
53 KB, 300x434
>>55419281

Anyone remember this one?
>>
>>55419221
This is a shit method but it works

In the table in the links I posted in >>55419258 if you click on the points column you will see a massive set of vlookup formulas which reference the table on the far right which is points for each position.

Basically the vlookup formula will lookup the finishing position in the first race for that driver in the reference table and return the corresponding points value. It will then do the same for the next race and so on while adding them all up. That leaves with the total points for that driver.

This allows you to change the point system quickly and easily.

I'll make a diagram if my shit explanation doesn't help.
>>
File: JB5OZco.jpg (289 KB, 1600x1200) Image search: [Google]
JB5OZco.jpg
289 KB, 1600x1200
>>
File: le_nicoprostberg_Face.png (1 MB, 1157x649) Image search: [Google]
le_nicoprostberg_Face.png
1 MB, 1157x649
https://www.youtube.com/watch?v=ExG9eNDHG9E

The race no one wanted to finish
>>
File: lewis_hamilton_mugging_emilia.jpg (79 KB, 540x720) Image search: [Google]
lewis_hamilton_mugging_emilia.jpg
79 KB, 540x720
Has there been a better former driver turned commentator than Hunt?
>>
>>55419834
Michael Waltrip
>>
>>
File: williams-f1-bmw-01.jpg (281 KB, 1600x1200) Image search: [Google]
williams-f1-bmw-01.jpg
281 KB, 1600x1200
>>55419903

>BMW will never take on Williams as works team again and take Massa to 1 WDC and GOA77AS to 8 consecutive championships after Massa takes out hamilton in a mad suicide attack
>>
>>55404727
They've all been inside Jessica?
>>
>>55419056

Watching 2008 Silverstone

Good choice?
>>
>>55420607
Yeah
>>
Remember guys. If you put /f1/ in all field there is no way to go wrong
>>
File: kubi_bmw_monz_2008.jpg (507 KB, 2128x1416) Image search: [Google]
kubi_bmw_monz_2008.jpg
507 KB, 2128x1416
>>55420051
Fuck bmw and their beautiful cars
>>
>>55420664
Oh shit Jenson is a mod
>>
>>55421278

>Nick never won a race

>and will probably be killed in a Formula E crash before he gets another win
>>
>>55421346
Fucking lost it.
>>
File: 1412900668957.gif (1021 KB, 500x281) Image search: [Google]
1412900668957.gif
1021 KB, 500x281
>>55421346
>>
>>55421346
No, i just did my job as a /sp/artizen and reported the porn
>>
>>55419627
I'm going to watch a Vlookup tutorial and try use it, will post results.

Are there any other main functions I should be aware of? I've watch quite a few tutorials already - the job is generally data entry.
>>
>>55421613
>Jenson is currently on his honeymoon in a Hawaii
>Reporter has an American flag

Jenson pls
How can you type with ball gag on anyway?

>>55421705
No extra for this one. It is just a pain in the arse.
I did a bigger one which included a constructors table and a graph showing the points change and it got very complicated very quickly.
>>
File: hey_vetlel_look_over_here.gif (850 KB, 250x250) Image search: [Google]
hey_vetlel_look_over_here.gif
850 KB, 250x250
>>55421613

>reporting a LINK
>>
File: spee.jpg (638 KB, 1858x1028) Image search: [Google]
spee.jpg
638 KB, 1858x1028
>>55421613
>>
fuck this shitty thread I sereosly hope bianchi dies now
>>
File: sexy_mr_potato_head.gif (492 KB, 400x225) Image search: [Google]
sexy_mr_potato_head.gif
492 KB, 400x225
>>55422073


Too much m8, you're a bad person
>>
How do we get the sport to be more driver focused?

When a driver who isn't even in the top 3 skill wise can win 4 titles in a row, there's something not quite right with that. Someone was quoted as saying the car is 90% and the driver is 10%. What can we change about the formula to put more focus on the driver? Should they?
>>
>>55422598
Identical cars

That's it
>>
File: literallyreddit.png (11 KB, 943x171) Image search: [Google]
literallyreddit.png
11 KB, 943x171
>skyF1 comments sections
>>
>>55422651
But then it is no longer Formula 1, It's just IndyCar or GP2/3

A key part of Formula 1 is the constructors battle.
>>
>>55422742
Yes, i was just answering his question

That's F1.
>>
>>55421860
I've found a function called RANK that seems to work, but haven't got a clue how to use it.
>>
File: Vlookup.jpg (187 KB, 1883x639) Image search: [Google]
Vlookup.jpg
187 KB, 1883x639
>>55422902
I'm playing with it but I don't think that would work.

I copied the first line in on >>55419221 and did the formula for it in vlookup form

The formula is:

=VLOOKUP(B2,W$2:X$24,2,FALSE)+VLOOKUP(C2,W$2:X$24,2,FALSE)+VLOOKUP(D2,W$2:X$24,2,FALSE)+VLOOKUP(E2,W$2:X$24,2,FALSE)+VLOOKUP(F2,W$2:X$24,2,FALSE)+VLOOKUP(G2,W$2:X$24,2,FALSE)+VLOOKUP(H2,W$2:X$24,2,FALSE)+VLOOKUP(I2,W$2:X$24,2,FALSE)+VLOOKUP(J2,W$2:X$24,2,FALSE)+VLOOKUP(K2,W$2:X$24,2,FALSE)+VLOOKUP(L2,W$2:X$24,2,FALSE)+VLOOKUP(M2,W$2:X$24,2,FALSE)+VLOOKUP(N2,W$2:X$24,2,FALSE)+VLOOKUP(O2,W$2:X$24,2,FALSE)+VLOOKUP(P2,W$2:X$24,2,FALSE)+VLOOKUP(Q2,W$2:X$24,2,FALSE)+VLOOKUP(R2,W$2:X$24,2,FALSE)+VLOOKUP(S2,W$2:X$24,2,FALSE)+VLOOKUP(T2,W$2:X$24,2,FALSE)

All you have to do is make the same (position/points) table like I did on the right and copy that formula into the correct cell.
You should just be able to drag it down for the rest of the drivers and it should work.

If you want to change the point system just change the values in the righthand column of that table on the right and it will change automatically.
I have it set to 10,9,8,7,6,5,4,3,2,1 this gives Hamilton a total of 153.
>>
>>55424039
Anon you are a genius, I'm going to have a play and see what I can do.
>>
>>55424239
Just a warning, some of your race values are wrong (You have Kyvat and Perez both coming 10th in Malaysia)
>>
>>55424239
If you can't get it to work and feel like cheating here you go

https://mega.co.nz/#!0gV2WZob!yHIH01vqLz5XgGXykH6M1iMAEbJNRW0_NPCIolLIqgs
>>
>>
>>55424039
What do the $ signs indicate?
>>
>>55426547
It's used to refer to cells

Look up how to use $ sign in excel
>>
File: absorel_table[1].png (3 KB, 508x160) Image search: [Google]
absorel_table[1].png
3 KB, 508x160
>>55426547
It keeps the cell reference fixed.

If we have the very simple formula "=A1" in cell B1 it will change as follows when copied and pasted:
Pasted to B2, it becomes "=A2"
Pasted to B3, it becomes "=A3"
Pasted to C2, it becomes "=B2"

If you make the formula "=A$1" in cell B1 it will change as follows when copied and pasted:
Pasted to B2, it becomes "=A$1"
Pasted to B3, it becomes "=A$1"
Pasted to C2, it becomes "=B$1"

If you make the formula "=$A1" in cell B1 it will change as follows when copied and pasted:
Pasted to B2, it becomes "=A$2"
Pasted to B3, it becomes "=A$3"
Pasted to C2, it becomes "=A$2"

If you make the formula "=$A$1" in cell B1 it will change as follows when copied and pasted:
Pasted to B2, it becomes "=$A$1"
Pasted to B3, it becomes "=$A$1"
Pasted to C2, it becomes "=$A$1"


If you don't want the cell reference to change when copied or dragged you use dollar signs in front of the letter and number.
You want all the rows to use the same position/points table so you want it to be a fixed reference
>>
>f1 general
>>
>>55427174
Thanks, great explanation. Last question I think - why do you put false in each bracket here >>55424039 ?
>>
>>55427360

Not that guy, but it's an argument for IF/VLOOKUP
>>
File: 13.jpg (37 KB, 599x511) Image search: [Google]
13.jpg
37 KB, 599x511
>>55427301

Go on groupon and buy one of the $20-$40 excel/ms office guided workshops, one of the best things I've ever done. It's so fucking useful
>>
>>55427301
=$F$1 + 'General'

Get it right.

>>55427360
If you want it to find the closest match in the first column you put in 'true' or you just leave it blank
If you want it to find the exact match in the first column you put in 'false'

I don't know why you would want it to find the closest match and not the exact match but that is just how vlookup works.
>>
>>55427653
>>55427632
>Both post wags
>Both know some excel

This explains so much
>>
File: 1414374579436.png (111 KB, 169x291) Image search: [Google]
1414374579436.png
111 KB, 169x291
>>55427653
>=$F$1 + 'General'
Now we're talking.
>>
>>55427653
Ok, greatly appreciated anon. Now going to run over some of the common functions and have a play around. Got my brother to do my online excel test to get this job as there wasn't enough time to learn it at the time, now shitting myself and feel like a fraud (despite having watched hours of tutorials and improving a lot).
>>
>>55427843

Well quit fucking sheep and get it to m8
>>
File: goddamitfelipe.jpg (243 KB, 1680x1120) Image search: [Google]
goddamitfelipe.jpg
243 KB, 1680x1120
Just saw Guardians of the Galaxy for the first time.
It's fucking A-MA-zing
>>
File: rly.png (147 KB, 421x433) Image search: [Google]
rly.png
147 KB, 421x433
>>55428203
R E D D I T
E
D
D
I
T
>>
>>55428386

just stop. drop it.
>>
Please schumi come back.

>>55419899
No. Don't even.
>>
>>55427843
You said it was data entry?
Trust me you are probably fine just knowing absolute basics like saving things, making new worksheets and formatting.

If it's anything like some of the data entry I have had to do it's sitting there typing written forms into an already formatted excel sheet.

Like the form would be like

NAME:
Button, Jenson

JOB:
Formula 1 Driver

FETISHES (please tick all that apply):
BDSM, NTR, Erotic asphyxiation

MARRIAGE STATUS:
Complicated

And I would just sit and type that into a spreadsheet.
>>
File: exceltutorial.png (8 KB, 608x209) Image search: [Google]
exceltutorial.png
8 KB, 608x209
>>55428515

>had to do an excel test for a job interview
>over two weeks nearly mastered excel
>hardest thing they had me do was manually enter a few entries in one column and enter in a sum formula for those cells

God I was pissed
>>
File: 1415402292780.gif (552 KB, 221x474) Image search: [Google]
1415402292780.gif
552 KB, 221x474
>>55428515
>>55428637
I love you /f1/.
>>
>>55428497
>>55419899

Mikey isn't good. He's affable, but gets irritating in a hurry. I'd take Dale Jarrett or even DW before him. (DW is gimmicky as hell, but really underrated when it comes down to firsthand knowledge)

The correct answer to this question, though, is Buddy Baker.
>>
File: bottas_girlfriend_blog1.jpg (79 KB, 710x400) Image search: [Google]
bottas_girlfriend_blog1.jpg
79 KB, 710x400
>>55428720
>>
File: Jess_thumbs_up.jpg (588 KB, 3264x2448) Image search: [Google]
Jess_thumbs_up.jpg
588 KB, 3264x2448
>>55428637
The thing is there are people so brain dead they are incapable of learning basic computer shit or just so stubborn they refuse.

I work for a consultant and we have clients who are local government and councils and we end up having whole organisations and departments who don't know anything about excel.
Like no one in the department for education in a local district knew excel. They saved all their data in either hand written form or word documents.
All the sensitive data on children (name, DOB, full address, school, year group, disabilities, pick up and drop off time, the bus they take) was in filing cabinets

I asked how in fucks name they sorted anything and they looked at me like I was an alien.

We had to have copies of the data so they ended up taking pictures of all the pieces of paper and sending them to us via email.
None of the emails were encrypted, none of the files were encrypted.

If someone got their hands on that, shit would have hit the fan big time.

>>55428720
>>
>>55428386
>liking movies is reddit
i don't even... fucking autists post stupid waifu shit and no one bats an eye, post a fucking thing about a movie
>hurr durururuurhurhruashrqu redddiiiit

sometimes i hate you /f1/
>>
>>55429566
>walking around in those shorts

What a whore
>>
File: Jessica_monster.jpg (189 KB, 715x1118) Image search: [Google]
Jessica_monster.jpg
189 KB, 715x1118
>>55429706
Sorry anon

Is this any better?
>>
>>55429914
One on the left is cuter
>>
File: jessica_22.jpg (340 KB, 970x1455) Image search: [Google]
jessica_22.jpg
340 KB, 970x1455
>>55429947
I don't who she is.

She is definitely not a michibata sister.
Angelica is Jessica little sister on the right
>>
>>55429596

Are you mexibro?

If so, I'm hoping they do a sequel with 80's music instead of 70's

Guns N' FUCKIN Roses

inb4 "dadrock"
>>
File: 13446244863020.jpg (106 KB, 318x478) Image search: [Google]
13446244863020.jpg
106 KB, 318x478
Good article on the engine freeze changes:
http://www.jamesallenonf1.com/2015/01/arms-race-game-changer-what-do-the-latest-changes-to-f1-engine-rules-mean/

According to James Allen, the teams can only introduce upgrades all in one go, once a year.
ie. they can run the old power unit for the first few races, then introduce the new 2015 power unit a few races in, if they desire.

The advantage is having more time to develop their improvements
The disadvantage is having to run their shitty 2014 spec power unit in races until they're ready with the 2015 one

>AMUS claimed teams could introduce upgrades one at a time
>it appears this is incorrect
>pic related: tfw I believed AMUS and yesterday explained it to you all with their wrong perspective
>>
>>55429914

Someone needs to photoshop that into a blowjob pic
>>
File: mass-p2.jpg (204 KB, 1680x1120) Image search: [Google]
mass-p2.jpg
204 KB, 1680x1120
>>55430837
>I'm hoping they do a sequel with 80's music
you are my fucking nigga.
80's pop-rock is the best.
>>
>>55431380
Is honda still kill?
>>
>>55431380
>The advantage is having more time to develop their improvements
>The disadvantage is having to run their shitty 2014 spec power unit in races until they're ready with the 2015 one

If Mercedes bring their new engine and Ferrari is still using the old one then I can't see Vettel making it within 107% in Australia.
>>
>>55431479

They never were really. They'll still have a 2015 spec motor, build with data McLaren learned from Mercedes in 2014.

>our keking about it was more at the butthurt of Honda dick suckers
>>
>>55431380

i don't see why a team or manufacturer would want to start racing in 2015 with their 2014 engine.
>>
File: recycling imo.png (44 KB, 1043x252) Image search: [Google]
recycling imo.png
44 KB, 1043x252
>>55431940

If your old equipment is still better than what other people have, then why not
>pic related
>>
>>55429914
but Monster was a mercedes sponsor

mclaren had lucozade
>>
>>55428515

>Erotic asphyxiation

thisismyfetish.jpg
>>
>>55433281

I think it was a Brawn sponsor first.
>>
>>55433338
As long as you don't put Auto in front of it it's okay.

Always play it safe and have a safeword.
>>
>>55433750

>safeword

It's funny, I during my last session with my Mistress, I used Jessica as my safeword.
>>
File: Eiffeland Type 21.jpg (38 KB, 940x530) Image search: [Google]
Eiffeland Type 21.jpg
38 KB, 940x530
>>55433850
>Wags as safewords

I like it. They definitely need to start making F1 themed/sponsored sex equipment.
You could have a Ferrari sponsored bad dragon stallion which would be way too expensive and too soft.
McLaren Honda Tenga egg
Williams Martini flavoured lube and condoms

F1 car so this discussion doesn't seem weird.
>>
File: ABANdonthread.webm (1006 KB, 1280x720) Image search: [Google]
ABANdonthread.webm
1006 KB, 1280x720
>this thread
>>
>>55434055

>Martini lube

Jesus, that would be amazing. Why do they not make alcohol related lubes.

For my next session, I'm going to be tied to a chair for a bit, and just left there while hot wax is dripped on me, I was thinking of using either potato or Schumi as my safeword.
>>
>>55434180

Wait, I'm retarded. Alcohol lubes would just wear out really fucking quickly.
>>
>>55434224
So we need McLaren sponsored Mobil 1 lube?

I'm going to go to bed now
>>
>>55434286

Yes. Good night.
>>
File: disbitch.jpg (83 KB, 472x720) Image search: [Google]
disbitch.jpg
83 KB, 472x720
Don't you 404 on me, heretic
>>
File: Jessica_jenson_scarf.jpg (162 KB, 768x1024) Image search: [Google]
Jessica_jenson_scarf.jpg
162 KB, 768x1024
You are going make it to the morning
>>
>>55437059
>>55437092
Why do you just prolong his suffering?
>>
>>55437131
because Jules is a goddamn fighter, anon
>>
Reminder that the Dubai 24h race is next weekend
>>
>>55437532
Even if he "recovers", it'll be a pyrrhic victory because he'll be seriously impaired, and nobody wants to go through life as a mong.
>>
File: 1412403191153.jpg (366 KB, 3264x2448) Image search: [Google]
1412403191153.jpg
366 KB, 3264x2448
>Jenson and Jessica are currently on their honeymoon making sweet sweet love
>>
File: carnumber.png (213 KB, 1366x768) Image search: [Google]
carnumber.png
213 KB, 1366x768
car number by win percentage
>>
>>55439353
I can't catch autism over the internet can I?
>>
>>55439370
if you think that's autistic just wait until you see what stat i'm cooking up next
>>
>>55439416
I'm scared now...
>>
File: connat.png (136 KB, 1366x728) Image search: [Google]
connat.png
136 KB, 1366x728
>>55439435
the result wasn't as interesting as i had hoped

it was constructors and nationalities by points per race (9-6-4 system) put together on one list

the only interesting thing was that argentina has better points per race than williams. mclaren, red bull, ferrari, brawn, and some others all have better points per race than any nationality
>>
SomersF1
>Honda and McLaren seem to have come out as the biggest losers in the debacle, as Charlie Whiting's technical directive appears to suggest that as Honda didn't homologate a powerunit in 2014 they must do so by the 28th February 2015, and as the other manufacturers did in 2014, run a season whereby they adhere to no changes, having already had the artificial ability to spend their 32 tokens. I'd suggest that's speculative at best, as the regulations have that intent but aren't prescriptive, meaning that if Honda or McLaren put the lawyers on it they'd win hands down.


what does he mean prescriptive? like the NHS?
>>
interesting-ish prost interview
https://www.youtube.com/watch?v=9G9Ek6xxsTs#t=494
>>
>>55439761

It's just a fancy way of saying the regulations are poorly worded and the FIA's current interpretation wouldn't hold up in court.
>>
File: t-thanks jules.jpg (54 KB, 640x242) Image search: [Google]
t-thanks jules.jpg
54 KB, 640x242
leaks of 2015 noses when?
>>
>>
Post Vettel in Ferrari colors, the GOAT combination.
>>
Friendly reminder that only literal autists and Dorftrottel watch F1.
:)
>>
>>55441938

Another Germanbro bullied the fuck out
>>
File: vett-ferr-2012-6.jpg (220 KB, 1680x1121) Image search: [Google]
vett-ferr-2012-6.jpg
220 KB, 1680x1121
>>55441883
>>
I have to say im very much looking forward for the 'best of the rest' battle this year. Mclaren x Ferrari x William x RB. I have no idea of whats going to happen
>>
>>55442782

>Mercedes ruining everything
>>
>>55444444
shit, we missed sexts for Bianchi
>>
Biaump
>>
File: animooted.gif (245 KB, 700x460) Image search: [Google]
animooted.gif
245 KB, 700x460
>Mclaren fan will defend this
>>
File: BtZBe2PIgAAkIxW.jpg (63 KB, 600x600) Image search: [Google]
BtZBe2PIgAAkIxW.jpg
63 KB, 600x600
>>
>>55446895
lewd
>>
>>55419834
barry sheene
neil crompton
>>
>>55449001

https://www.youtube.com/watch?v=CgBvCplFrBI
>>
>https://soundcloud.com/westboundsign-1/was-auch-immer

L O N D O N
O
N
D
O
N
>>
>>55446895
>so will McLaren fans
>>
>>55450502

Complaining about spelling in an Ausbro post made at
>03:42:44
>>
>>55451223
Oh Christ, I'm an idiot...

>so will Alonso fans
>>
>>55450447
what the fuck even is this L O N D O N shit about
>>
File: know your meme.jpg (94 KB, 861x1468) Image search: [Google]
know your meme.jpg
94 KB, 861x1468
>>55453402
>>
>>55454131
but why is that a meme
it isnt even funny and it's 4 years old, why is this only a thing now?
>>
>>55454131

>/fit/ being a homosexual dating site
>seems about right
>>
>>55454196
It has been a thing for ages m8
>>
>>55454338
I've only ever seen it these past few weeks
>>
>>55442658
You can see it in his eyes. He has left home. He is ready to do Great things. He will avenge Schumi's death.
>>
>>55439674
Pols better racers than brits
>>
File: Seb_unhappy.jpg (91 KB, 1200x800) Image search: [Google]
Seb_unhappy.jpg
91 KB, 1200x800
>>55454766
He will fail.

Schumi at least had a team of competent people he brought in. Vettel is committing Villeneuve levels of career suicide.
>Vettel's face when the Ferrari 666 is as bad as the BAR-01
>>
>>55454766
It will be glorious
>>
File: fortheglory.jpg (1 MB, 2387x1080) Image search: [Google]
fortheglory.jpg
1 MB, 2387x1080
>>
File: idi_amin.gif (4 MB, 298x224) Image search: [Google]
idi_amin.gif
4 MB, 298x224
>>55454766

>mfw Vettel returns Ferrari to glory, and Alonso couldn't
>>
>>55456259
Unless he has agreed to suck off Ross Brawn to make him come back that car will still be worse than the Force India, perhaps even as bad as the Torro Rosso if the Mercedes engine update rumours are true.
>>
>>55456531
>that car will still be worse than the Force India

>implying people expect Vettel will return Ferrari to glory in 2015
>implying it's not a long term project
>implying I'm going to get fish and chips for lunch, but need to go to the supermarket to get tartare sauce first
>>
File: vett-ferr-2012-10.jpg (180 KB, 1680x1121) Image search: [Google]
vett-ferr-2012-10.jpg
180 KB, 1680x1121
>>55454766
>>
>>55456962
>implying it's not a long term project
That the problem. I really can't see him lasting even 3 seasons with a car which isn't going to score points on average.

He will give up, retire early and raise his kid. Fair play to him if he does because I would have retired after this season.
He has 4 titles
He has broken loads of records
He has all the money he could ever need
He has a super qt waifu
He has a baby daughter
>>
File: 358363A883.jpg (482 KB, 1296x992) Image search: [Google]
358363A883.jpg
482 KB, 1296x992
Irresponsability the picture
>>
>>55459983
>Fun the picture fix'd
>>
File: AVUS_south_kurve_1.jpg (83 KB, 600x610) Image search: [Google]
AVUS_south_kurve_1.jpg
83 KB, 600x610
>>55459983
>tfw no South Kurve
>>
File: 2532582.jpg (176 KB, 800x523) Image search: [Google]
2532582.jpg
176 KB, 800x523
>>55460178
Thread replies: 255
Thread images: 173

banner
banner
[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y] [Home]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
If a post contains personal/copyrighted/illegal content you can contact me at [email protected] with that post and thread number and it will be removed as soon as possible.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com, send takedown notices to them.
This is a 4chan archive - all of the content originated from them. If you need IP information for a Poster - you need to contact them. This website shows only archived content.