Barça is bankrupt. 1.000M€ debt and January's wages can't be paid

  • The Fighting Cock is a forum for fans of Tottenham Hotspur Football Club. Here you can discuss Spurs latest matches, our squad, tactics and any transfer news surrounding the club. Registration gives you access to all our forums (including 'Off Topic' discussion) and removes most of the adverts (you can remove them all via an account upgrade). You're here now, you might as well...

    Get involved!

Latest Spurs videos from Sky Sports

Here is a fun excel formula that I have developed which has contributed to my psychosis.

=IF(AND(H43<$H$37,I43<$I$37,J43<$J$37),$G$37,IF(AND(H43<$H$38,I43<$I$38,J43<$J$38),$G$38,IF(AND(H43<$H$39,I43<$I$39,J43<$J$39),$G$39,IF(AND(H43<$H$40,I43<$I$40,J43<$J$40),$G$40))))

That formula combines with other, similar formulas to feed variables into the formula below.

=IF($H$32="Single",$H$44,K43&"T "&IF($H$33="Clear",,IF(OR($H$33="Gray",$H$33="Bronze"),$H$33,IF($H$33="Clear",,"Q"&$H$33)))&" / "&L43&" FBD"&" / "&IF($H$34="Clear",,IF(OR($H$34="Gray",$H$34="Bronze"),$H$34,IF($H$34="Clear",,"Q"&$H$34)))&" ")&K43&"T"

That formula generates a complete order string for an insulated glass lite which contains tempering information, Low-E choices, tint options, glass thicknesses, and spacer bar information to submit to a glass manufacturer.
6da43d69c65012a67aa470fe1cc1a0c811db7723r1-768-327_hq.gif


=IF(AND($B$5="Monoslope",$B$6>0,$B$6<7.5),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y7:Y8,'Fig 30.8-1 & 30.8-2'!$P$7:$P$8),IF(AND($B$5="Monoslope",$B$6>7.5,$B$6<15),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y8:Y9,'Fig 30.8-1 & 30.8-2'!$P$8:$P$9),IF(AND($B$5="Monoslope",$B$6>15,$B$6<30),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y9:Y10,'Fig 30.8-1 & 30.8-2'!$P$9:$P$10),IF(AND($B$5="Monoslope",$B$6>30,$B$6<45),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y10:Y11,'Fig 30.8-1 & 30.8-2'!$P$10:$P$11),IF(AND($B$5="Pitched",$B$6>0,$B$6<7.5),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y30:Y31,'Fig 30.8-1 & 30.8-2'!$P$30:$P$31),IF(AND($B$5="Pitched",$B$6>7.5,$B$6<15),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y31:Y32,'Fig 30.8-1 & 30.8-2'!$P$31:$P$32),IF(AND($B$5="Pitched",$B$6>15,$B$6<30),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y32:Y33,'Fig 30.8-1 & 30.8-2'!$P$32:$P$33),IF(AND($B$5="Pitched",$B$6>30,$B$6<45),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y33:Y34,'Fig 30.8-1 & 30.8-2'!$P$33:$P$34),"EM"))))))))

=IF(AND(Sheathing_Matl="Structural I", Framing_width=2,Blocked_Dia="Yes"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$18:$K$20,IF(S_nail=6,3,IF(S_nail=4,4,IF(S_nail=2.5,5,IF(S_nail=2,6,NA)))),FALSE),IF(AND(Sheathing_Matl="APA Rated Sheathing", Framing_width=2,Blocked_Dia="Yes"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$21:$K$27,IF(S_nail=6,3,IF(S_nail=4,4,IF(S_nail=2.5,5,IF(S_nail=2,6,NA)))),FALSE),IF(AND(Sheathing_Matl="Structural I", Framing_width=3,Blocked_Dia="Yes"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$36:$K$38,IF(S_nail=6,3,IF(S_nail=4,4,IF(S_nail=2.5,5,IF(S_nail=2,6,NA)))),FALSE),IF(AND(Sheathing_Matl="APA Rated Sheathing", Framing_width=3,Blocked_Dia="Yes"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$39:$K$45,IF(S_nail=6,3,IF(S_nail=4,4,IF(S_nail=2.5,5,IF(S_nail=2,6,NA)))),FALSE),IF(AND(Sheathing_Matl="Structural I", Framing_width=2,Blocked_Dia="No"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$18:$K$20,IF(Sheathing_Layout="Case 1",7,8),FALSE),IF(AND(Sheathing_Matl="APA Rated Sheathing", Framing_width=2,Blocked_Dia="No"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$21:$K$27,IF(Sheathing_Layout="Case 1",7,8),FALSE),IF(AND(Sheathing_Matl="Structural I", Framing_width=3,Blocked_Dia="No"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$36:$K$38,IF(Sheathing_Layout="Case 1",7,8),FALSE),IF(AND(Sheathing_Matl="APA Rated Sheathing", Framing_width=3,Blocked_Dia="No"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$39:$K$45,IF(Sheathing_Layout="Case 1",7,8),FALSE),2))))))))


First calculates the Cn variable in the equation for C&C wind loads for open structures for a particular wind zone, wind flow type, and tributary area. Second calculates the shear capacity of a specific range of wood diaphragms based on geometric conditions, materials used, and connection patterns.

I'm working on a spreadsheet to design reinforce concrete water storage tanks in my down time. For fun and shit.
 

VirginiaSpur

Supporter
"Intelligent but stupid" - Ahab
6da43d69c65012a67aa470fe1cc1a0c811db7723r1-768-327_hq.gif


=IF(AND($B$5="Monoslope",$B$6>0,$B$6<7.5),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y7:Y8,'Fig 30.8-1 & 30.8-2'!$P$7:$P$8),IF(AND($B$5="Monoslope",$B$6>7.5,$B$6<15),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y8:Y9,'Fig 30.8-1 & 30.8-2'!$P$8:$P$9),IF(AND($B$5="Monoslope",$B$6>15,$B$6<30),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y9:Y10,'Fig 30.8-1 & 30.8-2'!$P$9:$P$10),IF(AND($B$5="Monoslope",$B$6>30,$B$6<45),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y10:Y11,'Fig 30.8-1 & 30.8-2'!$P$10:$P$11),IF(AND($B$5="Pitched",$B$6>0,$B$6<7.5),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y30:Y31,'Fig 30.8-1 & 30.8-2'!$P$30:$P$31),IF(AND($B$5="Pitched",$B$6>7.5,$B$6<15),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y31:Y32,'Fig 30.8-1 & 30.8-2'!$P$31:$P$32),IF(AND($B$5="Pitched",$B$6>15,$B$6<30),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y32:Y33,'Fig 30.8-1 & 30.8-2'!$P$32:$P$33),IF(AND($B$5="Pitched",$B$6>30,$B$6<45),FORECAST.LINEAR($B$6,'Fig 30.8-1 & 30.8-2'!Y33:Y34,'Fig 30.8-1 & 30.8-2'!$P$33:$P$34),"EM"))))))))

=IF(AND(Sheathing_Matl="Structural I", Framing_width=2,Blocked_Dia="Yes"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$18:$K$20,IF(S_nail=6,3,IF(S_nail=4,4,IF(S_nail=2.5,5,IF(S_nail=2,6,NA)))),FALSE),IF(AND(Sheathing_Matl="APA Rated Sheathing", Framing_width=2,Blocked_Dia="Yes"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$21:$K$27,IF(S_nail=6,3,IF(S_nail=4,4,IF(S_nail=2.5,5,IF(S_nail=2,6,NA)))),FALSE),IF(AND(Sheathing_Matl="Structural I", Framing_width=3,Blocked_Dia="Yes"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$36:$K$38,IF(S_nail=6,3,IF(S_nail=4,4,IF(S_nail=2.5,5,IF(S_nail=2,6,NA)))),FALSE),IF(AND(Sheathing_Matl="APA Rated Sheathing", Framing_width=3,Blocked_Dia="Yes"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$39:$K$45,IF(S_nail=6,3,IF(S_nail=4,4,IF(S_nail=2.5,5,IF(S_nail=2,6,NA)))),FALSE),IF(AND(Sheathing_Matl="Structural I", Framing_width=2,Blocked_Dia="No"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$18:$K$20,IF(Sheathing_Layout="Case 1",7,8),FALSE),IF(AND(Sheathing_Matl="APA Rated Sheathing", Framing_width=2,Blocked_Dia="No"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$21:$K$27,IF(Sheathing_Layout="Case 1",7,8),FALSE),IF(AND(Sheathing_Matl="Structural I", Framing_width=3,Blocked_Dia="No"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$36:$K$38,IF(Sheathing_Layout="Case 1",7,8),FALSE),IF(AND(Sheathing_Matl="APA Rated Sheathing", Framing_width=3,Blocked_Dia="No"),VLOOKUP(Sheathing_Thk,'Lookup Tables'!$D$39:$K$45,IF(Sheathing_Layout="Case 1",7,8),FALSE),2))))))))


First calculates the Cn variable in the equation for C&C wind loads for open structures for a particular wind zone, wind flow type, and tributary area. Second calculates the shear capacity of a specific range of wood diaphragms based on geometric conditions, materials used, and connection patterns.

I'm working on a spreadsheet to design reinforce concrete water storage tanks in my down time. For fun and shit.


I've done windload calculations a couple of times, and no more. I tell people now that as a manufacturer, it's a conflict of interest and a problem of liability for me to perform structural calculations of that nature.
 

TottsAmazeballs

Supporter
I've started doing a lot more sql in recent years but in both instances (excel) I have been choosing to break things up into chunks and not monster formula so others can follow.

After trying to decipher people's formula and fixing things that are broken. I now have a "motto". It's not if we can do it but whether we should.
saying jeff goldblum GIF
 

TottsAmazeballs

Supporter
I feel for you bro. I code in several languages (and have written a fair few excel formulae long ago), but they are dogshit to read and write compared to even the worst languages I've used (PHP, VB). SQL isn't much better, but I'd much rather use that than Excel to extract data. You can use C# functions with MS SQL server, too, so it can be quite readable/maintainable. I have a feeling you can write functions for Excel the same way, but I'd guess they look like dogshit again once you start dealing with $h444 etc...
 

I've done windload calculations a couple of times, and no more. I tell people now that as a manufacturer, it's a conflict of interest and a problem of liability for me to perform structural calculations of that nature.
I don't blame you, they suck. You could always do like a lot of our delegated designs end up going, with manufacturer engineers sending in the stamped submittals which take all of 2 minutes of review before realizing they just decided not to do any lateral design at all and were just hoping you wouldn't notice and call them out. Not that I'm naming them or anything *cough*truss manufacturers*cough*.

I remember when I was in school, obviously being educated in a high-seismic zone and after having spent years on the construction side and seeing seismic details in the field, I thought seismic loads were the bees knees that separated the wheat from the chaff in SE.

Once I got to working in engineering, though, I quickly realized that generating wind loads is waaaaay more complex. ASCE 7-10 really overly complicated it (I think partly because the guys on the wind committee just developed science-envy of how technical the seismic committee was getting). Subsequent editions just seem to be muddling things more, and now we've got people trying to straight-face determine "design tornados".

Wind is so fucked up and complicated, it does my head in, hence why I've developed spreadsheets to do it for me in 95% of cases...and I piss and moan for hours when that 5% happens. Especially when in most cases its seismic detailing requirements that control the design and render all the work that goes into the wind design moot. Required, obviously, but usually fucking moot.
 
I've started doing a lot more sql in recent years but in both instances (excel) I have been choosing to break things up into chunks and not monster formula so others can follow.

After trying to decipher people's formula and fixing things that are broken. I now have a "motto". It's not if we can do it but whether we should.
I just lock my spreadsheets and tell people to fuck off.

I've also started making a lot better use of named cells and ranges in the past few years so *most* of my spreadsheets contain formulas that more or less explain themselves to anyone with the knowledge to have them open, anyway.

Breaking stuff into smaller chunks does increase flexibility, too, which is often a bigger asset that even increasing comprehension.

But, man, does it get my dick hard to plug in a couple of variables and get a result to a set of calculations that would take me hours by hand.
 
I feel for you bro. I code in several languages (and have written a fair few excel formulae long ago), but they are dogshit to read and write compared to even the worst languages I've used (PHP, VB). SQL isn't much better, but I'd much rather use that than Excel to extract data. You can use C# functions with MS SQL server, too, so it can be quite readable/maintainable. I have a feeling you can write functions for Excel the same way, but I'd guess they look like dogshit again once you start dealing with $h444 etc...
I can't code for shit. I still have PTSD from a semester of MatLab. My brain just won't get it. I can work with spreadsheets and databases all day....but there's just some sort of blockage I just can't get through with coding.
 

TottsAmazeballs

Supporter
I can't code for shit. I still have PTSD from a semester of MatLab. My brain just won't get it. I can work with spreadsheets and databases all day....but there's just some sort of blockage I just can't get through with coding.
I think I know why.

MatLab is to maths what enterprise software architecture is to coding. It assumes a firm understanding of the patterns and principles. Teaching coding via MatLab is something I imagine a Maths teacher with Asperger's would try to do. It's not mean, it's just not empathetic and, fundamentally really fucking hard. It's also hardly practical, since it would rail-road you into data science or researcher positions, not really coding. That's not a bad thing, since they are growth markets, but expecting to code and getting MatLab is like a mouth full of mud pie.

Python is a much better entry point if you're coming from Maths. It's a good all-rounder, in fact.

COYS!
 
Last edited:

TottsAmazeballs

Supporter
Brits and Americans can't even agree on today's date;
04/03/21 or 03/04/21?
Small-to-big, obviously. Most people know what month it is and you don't need to start with the year.

US format is basically saying "We mostly speak about events that are going to happen or happened some time ago. We'll let you know the month first, so we can zero in on the approximate area, then nail it down to the day before adding a year for the avoidance of doubt."

UK format is saying "Look, we both know what month it is. I'll start with the day and the other stuff is for clarity if required."

But, as a data guy, I love the yyyyMMddHHmmss format. Sort yourself out!
 

VirginiaSpur

Supporter
"Intelligent but stupid" - Ahab
Small-to-big, obviously. Most people know what month it is and you don't need to start with the year.

US format is basically saying "We mostly speak about events that are going to happen or happened some time ago. We'll let you know the month first, so we can zero in on the approximate area, then nail it down to the day before adding a year for the avoidance of doubt."

UK format is saying "Look, we both know what month it is. I'll start with the day and the other stuff is for clarity if required."

But, as a data guy, I love the yyyyMMddHHmmss format. Sort yourself out!
... I wonder if the American way is a holdover of the frontier?
 
Top Bottom