formulas – IF & Then from Separate Sheets Using Words Instead of Numbers

On one sheet I have a name populating by a Data Variation from SHEET 2 and I would like the line below it to populate with some corresponding information in the cell next to it.

SHEET 1: IF ROW 11 = “Data Variation”

Then it will choose the corresponding cell to the right of the Data Variation information on SHEET 2, put it in ROW 12 and also populate ROW 14 with the NUMBER on SHEET 2.

So for example:

  • ROW 11 I will use the drop down to choose TRUCK.
  • It will then populate ROW 12 with the CORRESPONDING GREEN.
  • Then in ROW 14 it will get 2000.

This maybe something straight forward, but I really only know the basics of this stuff.

So thank you in advance!

enter image description here

windows – Huge difference in transfer speeds when using separate directories for transfer

I was transferring around 12k images (total size around 2 GBs) from my laptop to my Android phone via USB. Initially, it was around 5-6 images copying per second and soon after around 500 images speed began to drop and reached more than 5 seconds per image. I tried copying them in batches of 500 images but that was no better. It was like the more the number of files in a directory the slower it is to add more to it.

Then what I did is make separate folders in the same directory and copy only about 500 images at a time to each. This way I got speeds of 5-6 images per second similar to what I was getting initially when I was transferring them all at once to a single directory. Later, I simply moved the images out of those folders using native file manager in my phone, which was almost instantaneous.

Why is that speed was decreasing exponentially when I was copying all files to the same directory?

web app – One app with more features vs. separate apps focused on one thing

The term you’re looking for is debundling. Debundling is definitely not just a UX decision. It’s a collective decision between business technology and design. There are many reasons why not to debundle a software and same amount of reasons why the product should have been debundled immediately.

First major debundling seen from Foursquare. They’ve released a fun app where you can tag your location, leave reviews etc etc. But then they’ve received a huge interest and then they’ve started to collect massive amount of data which made them a good rival against yelp. But the thing is, foursquare released as an startup and probably didn’t had the structural code hierarchy of an enterprise company (just assuming here) Instead just piling the data they were looking forward to monitise the data so as a business decision they’ve decided shift the company model into a data company instead of just an entertainment company. But also they didn’t want to ditch their user base. Doing the two different complete business under one brand would be just a chaotic mess as seen in FB atm. So -as a very short- they’ve come up with a another app called Swarm for the users and kept the entertaining part in there and reshaped Foursquare into a way more enterprise company. Well I’m not saying that it’s been executed pretty well but they’re still a strong name in their field and seems like everything been worked out just fine for them.

Another example would be Google. They have dozens of apps which they use the same password but doing completely different things. It would be HELL if I only had a ‘Google’ app where I can check my mails, download files from drive, watch videos on youtube, start a video conference, etc.

I don’t know the technical details but they do have a shared API that talks between google apps within iPhone. So logging in within a fresh installed Google app on my iPhone is not a problem. But their decision to debundling drive into different apps I find a bit annoying. I could literally do the same edits within drive and if I happen to have docs or sheets installed by mistake, I end up jumping between apps and can’t understand what’s been going on. If I’m using drive on iOS, I’m always lost (that’s why I don’t prefer using it on mobile devices but from desktop)

Last example would be Facebook. Basically they HAD TO debundle their application because they were literally living the hellish Google app example I’ve mentioned a paragraph before. I remember at some point their application was so bloated that it was over 700mbs. Most of the iOS games takes that much of a space if they have 3D graphics and high res textures. Those are the ones takes up space. Facebook doesn’t have that. Just lines of codes. So at some point it became harder to release a stable app so they had so debundle it into several different apps. (they all failed so they’ve came to an understanding that they didn’t needed to have 4 different snapchat clones and another few clones of their own messenger apps)

So my point is, line could be several different reasons. Could be business related, technology related. Oh yeah, sometimes it can be even UX related too. But mostly business and technology.

python – How to separate information within 1 line of user input? (Python3)

I want to know how to separate information within 1 line of user input using Python3. For example, the user types

5 1 7 8 12 13

The 5 represents the number of numbers that follow, and I want to store those numbers (1, 7, 8, 12, 13) in 1 array as integers. I have tried splitting off each number as a String and then casting it as an int, but this doesn’t work well if the input line contains two (or possibly more) digit numbers.

plsql – How to separate a part of a string from other parts in Oracle PL-SQL using “regular_expression”

I have a string like this :

string := ' sum(x) = 12 and 
            sum(y) = 13 and
            sum(z) = 14 and
            w = 'p'   AND 
            q = 'p'   AND 
            l = 'p''

and I need to separate all sum(...) from the rest of the query:

where_Clause:=   w = 'p'   AND 
                 q = 'p'   AND 
                 l = 'p'

having_Clause :=  sum(x) = 12 and 
                  sum(y) = 13 and
                  sum(z) = 14 and

I’m sure there is a way to do that by regular_expression but cause I’m very new to oracle pl-sql , I need some help. I was wondering if you could help me with that.

Thanks on advance

malware – Browser threw me on same ad-site some seconds after scrolling on completely separate webpages

I was scrolling on two completely separate web pages, pages I have visited many times before. However they do both have ads. My browser is Opera, and I use an adblocker (on the other site it doesn’t always block all ads). After opening the page and scrolling on it for a while, I’m not sure but after maybe 5-30 seconds on the page, the browser redirected me to a different page (in the same tab), which was a page advertising an ISP/phone company, but it was a false ad, which would surely give viruses/etc if clicked on. These incidents happened within 10 hours of each other, and when the second one happened, I had many tabs open, including one from the page where it happened first.

In the past I’ve encountered many kinds of popups and ads, but this one seems strange because 1) it directed me to the same malware-ad page from two totally separate pages (the topic of these pages is nothing similar, one is blog about music lyrics and the other a game wiki), and 2) I did not click anything at the moment when it redirected me to that page. Also my Opera settings says “popups and redirecting” is disabled. A whois-service said the IP had been registered yesterday.

Quick virus scan didn’t find anything, I am now running full scan. I want to know how this kind of thing works, and what should I do to prevent it / does it mean I have malware?

EDIT1: I googled about the first site that did this. I reveal that the site is (wiki-style page for World of warcraft -videogame). There was lots of forum threads complaining about redirecting ads on that page, dating from 2016 to 2019. If it was caused by their ad, I’m not sure why my adblock let that ad through. Also, I had a wowhead tab open while browsing the other page that did this, so is it possible that the same script would somehow redirect me in another tab of a different page?

search – Data row lookup in separate big data sheet and placing it inside another sheet in Google spreadsheet

I would like to make a Google spreadshit for calorie tracking. In my head I imagine it as I would like to have a sheet where I will record daily food activity. And another DB sheet with all time consumed food types with their parameters. So, the idea is when I type food name in daily diary sheet it will lookup in DB sheet if I already recorded this food macros and the food exists it just places reference to the existing food or copies its parameters. So, my question is it possible to implement something like spotlight? When I type some characters it displays kind of popup with suggestions based on DB sheet data and if I choose popup element it gives me a reference to that data. Ideally it would be great to have a fuzzy search. Maybe someone knows in which directions may I start to research or some impelemnted solutions?

sql server – Store VarChar(Max) [Notes] Column on Same or Separate Table

While its great that you are even thinking about this – I would consider it to be micro-optimisation. SQL Server already has optimisations built into it for handling NVARCHAR(MAX) and so generally I would say to not second guess it until it becomes a problem. However, there are two main points that came to mind when reading your question.

The first is (as you touched on with your last point) would there actually be any performance gained by splitting the data out into another table over letting SQL Server optimise the pages and data itself? I don’t have hard evidence with me right now but I suspect not. The reason is that, as you mention, your data is regularly over 8000 bytes and therefore will be moved to LOB pages in your Note table anyway. You would just be moving the perceived problem from one table to another. Add the overhead of performing a JOIN when having to fetch the data and you are likely end up slightly worse off than you were to begin with.

Secondly, as you tagged the question with database design, my actual recommendation is that you do split out the notes into another table. However, my reasoning is not so much driven by the performance optimisation but more specifically adding flexibility to the application. It is highly likely that a shipment may need more than one note attached to it (for example if it is delayed on transit, or a customer calls in etc…). If you have the note on the actual shipment itself it makes it harder to do this without duplicating data. If you extract it into its own table you will be able to assign multiple notes to a shipment, and track who entered them and when. This makes your application and database more flexible.

If you want to optimise then I would recommend removing the need to query the notes unless someone specifically wants to view them (such as having a dedicated form in your application to do so). That way, you only need to perform the join/lookup when somebody explicitly wants to view the data. Even if you didn’t externalise the notes to another table, not including the column in the query if it is not needed will remove the need for SQL Server to read the LOB page. If possible I’d always optimise queries to return the least amount of information required before optimising at a micro level.

c# – Separate entities with common parent vs 1 entity with nullable properties

I’m working with .NET Core and Entity Framework Core and need to create an app where Employee can create 3 types of posts:

  • Idea – telling about what he think could change in organization. It have props:
  • Article Request – telling that there is need for something ex. new smartphone
  • Question

All three have some common properties which are: Id, AddedDate, Responses (list), Notifications. And each Response has list of Comments.

a) So 1st option – separate classes:

If I will make 3 separate classes with base class then I’ll end up with 3 tables for those 3 post types and there will be the same Ids for both – I mean there will be Question with Id=1, and Idea with Id=1.

On Response class I can’t reference it by PostId, because it doesn’t actually exist I would do something like that:

class BaseResponse<TPost> where TPost : BasePost {
    public int Id { get; set; }
    public string Message { get; set; }
    public User Author { get; set; }
    public TPost Post { get; set; }

class IdeaResponse : BaseResponse<Idea> {}
class ArticleRequestResponse : BaseResponse<ArticleRequest> {}
class QuestionResponse : BaseResponse<Question> {}

and in Context.cs:

public DbSet<Idea> Ideas { get; set; }
public DbSet<ArticleRequest> ArticleRequests { get; set; }
public DbSet<Question> Questions { get; set; }

public DbSet<IdeaResponse> IdeaResponses { get; set; }
public DbSet<ArticleRequestResponse> ArticleRequestResponses { get; set; }
public DbSet<QuestionResponse> QuestionResponses { get; set; }

So also 3 classes for responses, and then similar thing for notifications and also comments

b) 2nd option: 1 class with nullable properties with referenced data:

class Post {
    public int Id { get; set; }
    public DateTime AddedDate { get; set; }

    public PostType Type { get; set; { // enum

    public IdeaData IdeaData { get; set; } // != null when Type == PostType.Idea
    public ArticleRequestData ArticleRequestData { get; set; } // != null when Type == PostType.ArticleRequest
    public QuestionData QuestionData { get; set; } // != null when Type == PostType.Question

In that case I could create one Response class, one Notification class, and one Comment class.

Or maybe there is some other option? If something is unclear, please let me know and I will explain it in more details.