|
Mebh posted:
Yeah they're incredibly common. You have to treat the whole family at once. That said - human nits cannot live on cats. They won't give your cats nits. But they'll give *you* nits.
|
# ? Oct 17, 2022 02:39 |
|
|
# ? May 24, 2024 13:29 |
|
Lucy Powell MP (Lab and one of those featured in the Steven Kinnock 'look on his face when Labour weren't trounced at GE17' video) is boycotting the World Cup in Qatar.... but it's ok, she's going to watch it on a tv in a pub in the UK instead. Erm.... https://twitter.com/YorkshireBamf/status/1581366551462424577
|
# ? Oct 17, 2022 02:42 |
|
HopperUK posted:Yeah they're incredibly common. You have to treat the whole family at once. And if you invite a school friend who it turns out has nits round for a sleepover and then use the same pillow the next night you can catch them then too. Source: my niece. And now my head is itching - psychosomatic. I haven't got nits.
|
# ? Oct 17, 2022 02:44 |
|
Mebh posted:
Can confirm. I work on a mobile game with constant live multiplayer events and basically all our design data for them is in a combination of Google and Excel sheets.
|
# ? Oct 17, 2022 04:06 |
|
Angepain posted:I feel like Excel is not so much the problem in itself as a symptom of low budgets/understaffing. Okay there probably are some people who refuse to learn any new tools once they learn VLOOKUP but the multi-sheet colour-coded macro-enabled Excel gore monsters I've seen have had everyone touching them acknowledging just how terrible they are but they just don't have time to do the work of entangling it into something else. I imagine a government department having to hurriedly fix the covid pandemic that boris johnson just about acknowledges while being given 2p per month to do it would have been in the same boat, just frantically stitching together stopgap solutions that work in the short term and hoping it all holds together long enough to give the results that someone is already yelling at you down the phone for The problem is that a lot of the time you don't really need a database - in this specific case it would definitely have been good, but for say game design as posted above you'd really want some kind of bespoke design application (that might store the data in a database or use some kind of backend server or data files, depending on requirements), which costs a lot of money and might not be that much better than excel anyway. Database is just a data store, there's no interface to it by default. You can force it into serving as a set of spreadsheets by e.g. using access forms in excel but that is widely considered to be a terrible, horrible, awful, just the worst solution by computer program touchers. Using access via excel forms is really just distributed excel and not a proper database interface and can run into corruption and other issues really easily. Also access in general just sucks hard by database standards, most programmers will pull a face if you ask them to use access for whatever thing you want them to do. In programming terms it's about on the same level as VBA "programming", somehow worse than PHP which is already widely derided by everyone. Private Speech fucked around with this message at 05:00 on Oct 17, 2022 |
# ? Oct 17, 2022 04:32 |
|
Well, it's Monday, Brady is back from his noncing trip, and Jeremy oval office insists L*z Tr*ss is still in charge, so welcome to the last day of the reign of Queen Elizabeth Hashtag Three I guess.
|
# ? Oct 17, 2022 05:10 |
|
Guavanaut posted:Ah, I see she's also doing the Bill Donohue nonsense of "predatory men are taking years out of their lives to become priests to touch kids" rather than that an organisation can have faults that increase the likelihood of abuse going unreported or being covered (the conclusion of the Bishops' report, the Ryan Report, and the College of Cardinals).
|
# ? Oct 17, 2022 05:39 |
|
Senor Tron posted:Can confirm. I work on a mobile game with constant live multiplayer events and basically all our design data for them is in a combination of Google and Excel sheets. I mean, I get it. I still see these lovingly crafted rube goldberg excel sheets from time to time and think "gently caress me, why isn't this just a web form?" But surely its not so bad if you're just plotting an event timeline, right? What should the games industry be using?
|
# ? Oct 17, 2022 06:00 |
|
Give access a front end that makes any kind of sense to anyone age 14+ that gives idiots, ie me, the same kind of 'yeah I can probably make this do a sum' sense, and it'll take over
|
# ? Oct 17, 2022 06:53 |
|
1965917 posted:But surely its not so bad if you're just plotting an event timeline, right? What should the games industry be using?
|
# ? Oct 17, 2022 07:15 |
|
R4 was saying the 12 months safe zone is a convention rather than an expicit rule of the 1922 committee. https://www.bbc.com/news/world-middle-east-62305455.amp Oh so *now* the BBC will report on AJ
|
# ? Oct 17, 2022 07:15 |
|
I’m a software dev at a company that does bespoke software and like 80-90% of the work we get is for companies whose entire operation is done on an Excel sheet and have finally realised that’s not ideal
|
# ? Oct 17, 2022 07:30 |
|
VLOOKUP is a pretty powerful tool. One of the most infurating things about Excel though is that depending on your system locale, the way you type forumlas changes. So what you find in an online tutorial might not be how it works in your own system. Probably most english people never notice it. If I recall correctly this made formulas not work in an excel file made on another system when it opened in my workstation, if the locales where sufficiently different, like US to Finland. All the commas in the formula for instance has to be semicolons here.
|
# ? Oct 17, 2022 07:30 |
|
the thing about excel is at least it's not matlab
|
# ? Oct 17, 2022 07:32 |
|
His Divine Shadow posted:VLOOKUP is a pretty powerful tool.
|
# ? Oct 17, 2022 07:48 |
|
Confession: I don't actually know what VLOOKUP is. Without looking it up, is it an access operator? Like .at(i, j) or .find(i) and such.
|
# ? Oct 17, 2022 08:00 |
|
xtothez posted:And then this process has been heavily amplified in the last decade by social media giants pushing divisive and often fake material for profit. There's a reason why the far right is becoming dominant in many global democracies, including ours. This, it's the right wing rags but x1000. Especially the constant sliproads to fascism through men's right and TERFery
|
# ? Oct 17, 2022 08:05 |
|
Private Speech posted:Confession: I don't actually know what VLOOKUP is. Without looking it up, is it an access operator? Like .at(i, j) or .find(i) and such. It matches a number / text string in a range and then counts vertically along the columns from it depending on how many you select. So if you have a table where column a is names for example and column b is dates, you can search column a for a specific name but return the corresponding date in column b. Using a combination of INDEX and MATCH works better though. Or there is a function called XLOOKUP which I've never bothered to learn.
|
# ? Oct 17, 2022 08:07 |
|
Private Speech posted:Confession: I don't actually know what VLOOKUP is. Without looking it up, is it an access operator? Like .at(i, j) or .find(i) and such. =VLOOKUP("value to look up", $A$1:$G$2000 (where column 'A' contains the value to be looked up, and one of the columns 'B-G' includes values to be pulled, 2 (or however many columns need to be counted right from column A to get to the column with result values in), false) for example, if the chart has names in column A and days worked in column G, and I want to find the total days Kwasi Kwarteng was in the cabinet, I could run: =VLOOKUP("Kwasi Kwarteng",$A$1:$G$2000,7,false)
|
# ? Oct 17, 2022 08:09 |
|
A Buttery Pastry posted:I am not sure that's comparable. Priests get a job, ready access to victims, and security for their time investment. Trans women just get poo poo. Even from a theoretical actual TERF (as opposed to FART) perspective, the idea makes no sense, as a man pretending to be a woman would be trading the most powerful identity in favor of the weakest one, for no reason at all, seeing as men are perfectly able to be sexually abusive for years with no consequence within our current society. It's lazy bigotry upon lazy bigotry. Private Speech posted:Confession: I don't actually know what VLOOKUP is. DesperateDan posted:the thing about excel is at least it's not matlab
|
# ? Oct 17, 2022 08:13 |
|
We’re now at the point of derangement where the extreme right wing swivel eyed loons at The Telegraph are defending, erm, *checks notes* Jeremy Corbyn! https://www.telegraph.co.uk/news/2022/10/17/liz-truss-victim-british-coup/
|
# ? Oct 17, 2022 08:14 |
|
Private Speech posted:Confession: I don't actually know what VLOOKUP is. Without looking it up, is it an access operator? Like .at(i, j) or .find(i) and such. No it's an excel thing where you have a table of say names in one column and maybe department next to it in a column. Then somewhere else you have say a lot of says maybe date, name say 1/4 John 2/4 John 3/4 Mary 4/4 John and then next to that you have a column that says department but instead of typing that in each time you use a vlookup (vertical lookup) that looks up the name and populated the dept. So =vlookup(John, list,2,true/false) and puts whatever is next to John in. So 1/4 John catering 3/4 Mary housekeeping The structure of vlookup is not exactly what I typed there obviously, just to give you an idea and I'm phone posting before work. You can have multi column lookup tables also hlookup and recently a new one called xlookup. Beaten by vlookup posters above
|
# ? Oct 17, 2022 08:15 |
|
Spinning out tasks from Excel into specialist software has been the biggest driver of corporate software development for about 30 years. Everything from Salesforce and Netsuite on down is just that. You should be using XLOOKUP not VLOOKUP now btw. It’s the same thing except it can look both right AND left, a major technological wonder.
|
# ? Oct 17, 2022 08:17 |
|
DesperateDan posted:the thing about excel is at least it's not matlab peanut- posted:Spinning out tasks from Excel into specialist software has been the biggest driver of corporate software development for about 30 years. Everything from Salesforce and Netsuite on down is just that. this thread is getting far too real for me
|
# ? Oct 17, 2022 08:17 |
|
His Divine Shadow posted:VLOOKUP is a pretty powerful tool. In a lot of countries there are 'localization' companies who work on making eg office products suitable for that country eg in Cairo one I worked with did the Arabic one making it go say right to left instead of left to right (this was 14 years ago) and various defaults etc I can't remember now!
|
# ? Oct 17, 2022 08:21 |
|
peanut- posted:You should be using XLOOKUP not VLOOKUP now btw. It’s the same thing except it can look both right AND left, a major technological wonder. Agreed. But as someone else said, INDEX and MATCH will often do the job fractionally easier and are less prone to breaking due to data formatting. Worth learning each, they're not complicated. Between that and nice Pivot tables with data slicers you can bamboozle any manager
|
# ? Oct 17, 2022 08:55 |
|
peanut- posted:You should be using XLOOKUP not VLOOKUP now btw. It’s the same thing except it can look both right AND left, a major technological wonder. Xlookup all the way, I agree. It also tracks which cells you’re interested in, so if you add a column in between the lookup and the data, it doesn’t gently caress it all up. And it can be dragged across columns/rows to lookup multiple things, rather than needing to be redone every time like V and H lookup.
|
# ? Oct 17, 2022 08:59 |
|
I've forgotten everything i knew about Excel tbh
|
# ? Oct 17, 2022 08:59 |
|
Ahh okay thanks everyone, I can see how that could be useful in excel. So basically a mix of find (or MATCH) and at (INDEX) then.Failed Imagineer posted:Agreed. Probably not my manager TBH, he has like two decades of coding experience. But most managers sure.
|
# ? Oct 17, 2022 09:02 |
|
I became an excel legend at work when I found a way to force SUMPRODUCT to act conditionally in the same way as SUMIFS (maybe excel just does this now anyway, but it was a useful formula to learn).
|
# ? Oct 17, 2022 09:05 |
|
keep punching joe posted:I became an excel legend at work when I found a way to force SUMPRODUCT to act conditionally in the same way as SUMIFS (maybe excel just does this now anyway, but it was a useful formula to learn). Excel queries are a gateway drug to becoming a programmer, get out while you can.
|
# ? Oct 17, 2022 09:18 |
|
peanut- posted:You should be using XLOOKUP not VLOOKUP now btw. It’s the same thing except it can look both right AND left, a major technological wonder.
|
# ? Oct 17, 2022 09:21 |
|
1965917 posted:Excel queries are a gateway drug to becoming a programmer, get out while you can. This is what I figured so I've tried hard to not engage, except for my wrestling spreadsheet which I'm sure is deeply inefficient
|
# ? Oct 17, 2022 09:31 |
|
I like Excel, especially as entire offices dont seem to understand how to use it beyond making a list, so you can do one or two things like 'filter columns' and people are amazed. But then they ask you to do stuff like print out a spreadsheet and you end up having to tape loads of pieces of paper together so some manager can get out their felt tips, which I always felt was a bit daft.Dabir posted:Spreadsheets are pretty useful but I can't help feeling like they've done more harm than good from people thinking they can use them as databases What is a database exactly? When I've put together some awful spreadsheet in Excel that is used as a CRM database across multiple pages and tens of thousands of rows tracking 20+ types of data, I do wonder if there would be a better way of organising it, a sort of multi-dimensional spreadsheet that doesn't alter the way the data is laid out by making queries or organising it. Maybe this is what Access is for idk
|
# ? Oct 17, 2022 09:32 |
|
There seems to be a strong push amongst the right-wing media commentariat to bring Boris Johnson back as PM.quote:https://www.telegraph.co.uk/politics/2022/10/17/seen-whatsapp-message-setting-future-tory-leadership-brutality/ quote:https://www.dailymail.co.uk/debate/article-11319439/SARAH-VINE-real-problem-Tories-hung-Margaret-Thatcher.html
|
# ? Oct 17, 2022 09:48 |
|
justcola posted:What is a database exactly?
|
# ? Oct 17, 2022 09:50 |
|
But enough talk, have at [#VALUE] !
|
# ? Oct 17, 2022 10:06 |
|
justcola posted:What is a database exactly? When I've put together some awful spreadsheet in Excel that is used as a CRM database across multiple pages and tens of thousands of rows tracking 20+ types of data, I do wonder if there would be a better way of organising it, a sort of multi-dimensional spreadsheet that doesn't alter the way the data is laid out by making queries or organising it. Maybe this is what Access is for idk It's where Salesforce charge your company £50k a year to do the same thing as your CRM spreadsheet in ways that are even more confusing and disappointing
|
# ? Oct 17, 2022 10:07 |
|
peanut- posted:Spinning out tasks from Excel into specialist software has been the biggest driver of corporate software development for about 30 years. Everything from Salesforce and Netsuite on down is just that. I'd say you should be going further and using XLOOKUP and Tables. Put every one of your datasets in a different named table and then all of your formulas become legible.
|
# ? Oct 17, 2022 10:15 |
|
|
# ? May 24, 2024 13:29 |
|
justcola posted:I like Excel, especially as entire offices dont seem to understand how to use it beyond making a list, so you can do one or two things like 'filter columns' and people are amazed. But then they ask you to do stuff like print out a spreadsheet and you end up having to tape loads of pieces of paper together so some manager can get out their felt tips, which I always felt was a bit daft. I've never worked with Access but multi-dimensional tables = a "relational database". You will have to do queries, but those can be saved as views that your idiot boss can look at without getting scared of what's underneath. SQL is a good and pretty simple solution for this.
|
# ? Oct 17, 2022 10:17 |