Google Sheets SUM columns from other sheets and group by month, but also show the individual sheets values before doing SUM

Currently I have a Spreadsheet which has a number of customer sheets, each with a pivot table showing the month in row I and the total income for each month in row L.

On a separate sheet I have a query that sums all of the month totals (This just shows 2 Customer sheets, normally these sheets are given the name of the customer):

=query({'Sheet1'!I2:I,'Sheet1'!L2:L;'Sheet2'!I2:I,'Sheet2'!L2:L},"Select Col1, sum(Col2) group by Col1 label Col1 'Month'") 

Currently this shows:

| Month       | sum   |    | 2018/12     | £ 35.00  | 2019/01     | £ 155.00  | 2019/02     | £ 60.00  | 2019/03     | £ 210.00  | Grand Total | £ 460.00  

I have been asked to add a column for each customer sheet which shows the value the query took before it did the SUM, I want each column to be named as the Sheet the column came from. So it should look like:

| Month       | sum       | Sheet1  | Sheet2 |    | 2018/12     | £ 35.00   | £10     | £25 | 2019/01     | £ 155.00  | £100    | £55 | 2019/02     | £ 60.00   | £30     | £30 | 2019/03     | £ 210.00  | £110    | £100 | Grand Total | £ 460.00  

If the totals showed under each sheet name it wouldn’t hurt, but isn’t necessary. The sum could be on the left or right, I’m not worried about it’s positioning.

Is there any way to do this in Google Sheets? I have been playing around with query a bit, but haven’t managed to get it to display more than 2 Columns.

How to exposure stack RAW photos while also outputting a raw photo?

So I have .DNG files that I have taken from an iPhone and I’m trying to figure out how to stack them and then output the stacked photo as a .DNG file as well (or any RAW format tbh).

I know how to code fairly well so I am able to stack them using python and the rawpy module. The problem is that rawpy currently has no way to output RAW files. So when I stack them, I can output as JPG, but that’s not what I want.

Going through astro photography forums, I’ve seen threads that say that Deep Sky Stacker can be used to read and stack RAW files, but I couldn’t find any guides that can tell me how to export an image as a .DNG file.

Does DSS output stacked photos as RAW? (format doesn’t matter, but DNG would be preferred) Is there a way to do this through Lightroom, maybe? Is there any way to do this programmatically?. I’m fairly new to all this so any help would be appreciated.

Calculating sha256 returns also “-bash: command not”

I’m trying to find a SHA256 hash of a string:

$   fdsafdsa | shasum -a 256  

While it returns a hash, it also throws an error:

-bash: fdsafdsa: command not found e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855  - 

I’ve tried using quotes — to no avail. How to get rid of “-bash: fdsafdsa: command not found”?

Does Mind Blank also protect your gear?

Does Mind Blank protect magic items or even normal gear that is on the Mind Blanked target from divination spells? (including but not limited to Detect Magic, Locate Object etc)

Another player and I aren’t currently in agreement on this, i thought Mind Blank would also protect my stuff but he is telling me that Nondetection is what i should be using and his reason for that is a bit of text at the end of Nondetection that isn’t in the Mind Blank spell and that line is,

“If cast on a creature, nondetection wards the creature’s gear as well as the creature itself.”

The reason i have not brought this question to the GM yet is because he is in blackout mode studding for his exams currently and can’t be reached yet.

if the majority answer is “Yes it protects your gear as well” could you put the reasoning why in the answer as well? So when the GM is free i can bring it to him and the other player before the game so it doesn’t devolve into a debate at the table.

Thank you your time 😀

When restoring a character’s hit point maximum lost from exhaustion, does the character also regain hit points?

When restoring a character’s hit point maximum lost from exhaustion, does the character also regain hit points?

For example, the fourth level of exhaustion reduces a character’s hit point maximum to half. Normally, a long rest will remove one level of exhaustion and conveniently allows a character to regain hit points. However, what happens when a character uses a spell like greater restoration to undo the effect? Does the character regain half their hit points or do they stay at half hit points?

I took a quick look through the PHB but cannot find anything on the effects of regaining maximum hit points. Wording for spells like aid imply hit point maximums and hit points are entirely separate.

Moreover, the complement is also without any Part results which is why it

Keto Trim intact and if that is the case, return the container to get a new one . Do not keep the complement open when you are not using it because it can get contaminated when it comes in contact with air. To prevent contamination and to keep the complement pure and clean, keep it in a dry position where it is not exposed to any dust or foreign particles. Final Verdict on Keto TrimA quick summary of the Keto Trimcomplement shows that the…

Moreover, the complement is also without any Part results which is why it

Toggling an interface causes static ipv6 address to be deleted whereas ipv4 address stays. How to make ipv6 address also stay?

I’m working with kernel 2.6.32. I have set a static ipv4 and ipv6 address on my machine.

ifconfig eth1 eth1      Link encap:Ethernet  HWaddr 00:50:56:AB:8D:A1           inet addr:10.5.175.254  Bcast:10.5.255.255  Mask:255.255.128.0           inet6 addr: 2011:1::/32 Scope:Global           inet6 addr: fe80::250:56ff:feab:8da1/64 Scope:Link           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1           RX packets:4470 errors:0 dropped:2 overruns:0 frame:0           TX packets:22237 errors:0 dropped:0 overruns:0 carrier:0           collisions:0 txqueuelen:100           RX bytes:235138 (229.6 KiB)  TX bytes:1389682 (1.3 MiB) 

After that I toggled the interface

ip link set dev eth1 down ip link set dev eth1 up 

Then the output

ifconfig eth1 eth1      Link encap:Ethernet  HWaddr 00:50:56:AB:8D:A1           inet addr:10.5.175.254  Bcast:10.5.255.255  Mask:255.255.128.0           inet6 addr: fe80::250:56ff:feab:8da1/64 Scope:Link           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1           RX packets:4470 errors:0 dropped:2 overruns:0 frame:0           TX packets:22240 errors:0 dropped:0 overruns:0 carrier:0           collisions:0 txqueuelen:100           RX bytes:235138 (229.6 KiB)  TX bytes:1389940 (1.3 MiB) 

How do I make the ipv6 comeback like the ipv4 ?

There is a solution in the newer kernels https://bugs.launchpad.net/ubuntu/+source/ifupdown/+bug/1218442

I’m looking if there is a solution or a workaround to make it work for 2.6.32 kernel.

Try to retrieve not only the members of SP visitors group but also the other columns with PnPPowershell

I have this code below to retrieve all the members of the sharepoint visitors group. But the visitors group contains also other columns like job, departments etc. How can I retrieve the other columns as wel.

Get-PnPGroupMembers -Identity "ICT Operations - Bezoekers" | select title 

Greetings, P

Can I travel around Europe with an expired student visa and Italian Permeso appointment receipt? I also have the expired Permeso card, will that help?

I would like to travel around Europe before I head back to India. But my student Visa has expired and my Italian stay permit is under renewal. I have the appointment receipt and the expired permit as proof. Will that be enough to travel to countries such as Germany, Budapest, France or Swiss?