gk | kit generator is a cli application | Generator Utils library

i use parrot security as my daily distro. its mate terminal is transparent so is vim .but i wanted to get auto complete and used some plugins.auto complete window appears to be in pink which looks really ugly in semi transparent black background.i changed the theme and it was fixed but so was gone vim transparency .

in short word (1)i have to keep the default (2)i have to keep transparent vim (3)i have to change the auto complete window from pink to semi transparent black

here is my init.vimrc

I'm trying to select a range of data within a named range on a google sheet but after searching I still can't figure it out how to do it.

In this case, I would like to count the amount of time a club appeared within a gameweek.

Here I can do it for all the gameweek tables I have, there is no problem.

Total

=QUERY({B:C;D:E;F:G;H:I;J:K}; "SELECT Col1, SUM(Col2) WHERE Col1 <> '' AND Col1 <> 'GK' AND Col1 <> 'DEF' AND Col1 <> 'MID' AND Col1 <> 'FW' AND Col1 <> 'EXTRA' AND Col1 <> 'Club' AND Col1 <> 'count' AND Col1 MATCHES '^.{0,5}$' GROUP BY Col1 ORDER BY SUM(Col2) DESC LABEL Col1 'Club', SUM(Col2) 'count'")

But I'd like to do the same for each of the gameweek table. So far I have this

Gameweek 1

=QUERY({(B6:B15):(C6:C15);(D6:D15):(E6:E15);(F6:F15):(G6:G15);(H6:H15):(I6:I15);(J6:J15):(K6:K15)}; "SELECT Col1, SUM(Col2) WHERE Col1 <> '' GROUP BY Col1 ORDER BY SUM(Col2) DESC LABEL Col1 'Club', SUM(Col2) 'count'")

but it is not very usable as I'd have to change each range for every next table.

So I tried to make the "Gameweek 1" table as a named range gw1_clubcount and only select its adequate columns similarly as the total so that I would just have to change that for each gameweek but obviously it is not working but that's what I would like to reach.

Gameweek 1 with named range

=QUERY(gw1_clubcount {B:C;D:E;F:G;H:I;J:K}; "SELECT Col1, SUM(Col2) WHERE Col1 <> '' GROUP BY Col1 ORDER BY SUM(Col2) DESC LABEL Col1 'Club', SUM(Col2) 'count'")

I've found the INDEX function where you can select the desired row and column of the named range.That would give something like this below but that's not how you use it.

=QUERY({INDEX(gw1_clubcount,,1):INDEX(gw1_clubcount,,2);INDEX(gw1_clubcount,,3):INDEX(gw1_clubcount,,4);INDEX(gw1_clubcount,,5):INDEX(gw1_clubcount,,6);INDEX(gw1_clubcount,,7):INDEX(gw1_clubcount,,8);INDEX(gw1_clubcount,,9):INDEX(gw1_clubcount,,10)} ; "SELECT Col1, SUM(Col2) WHERE Col1 <> '' GROUP BY Col1 ORDER BY SUM(Col2) DESC LABEL Col1 'Club', SUM(Col2) 'count'")

I'm not very experienced with sheets and a little help would be very appreciated !

I would like to collect individual keystroke events (keydown and keyup) in a chat client. I have the following basic code, which sets up a chat app and sends each message to a mongoDB cluster. I would like to create a new record for each keystroke event, rather than each message. Below is what I tried, to at least print the keystroke event to the console, but event that doesn't seem to be working. Below are the rudimentary index.html, index.js, and a mongoose Schema in messages.js.

What I've tried: In index.html, I added:

Say I have a git-cc executable in PATH. If git-cc supports --help, then it is easy to provide adequate completion with

I am setting up neovim, with CoC.

It seems to work well, but with one big problem: My diagnostic windows are very large

I am not sure why this is. I would expect this to be only a few lines. Ideally, it should show up somewhere not directly over the code, but I'm not sure how to configure this.

This is my neovim config:

I have a problem when trying to implement a WMS/WMTS service in mapbox. I'm using java and android studio. I managed to place the map in the right coordinates, but when I zoom in the tiles from the service duplicates and scatters on the map. It also does not scale with the rest of the map as I zoom. I first tried with WMS service, then tried with a WMTS service to se if that helped, but i get the same problem.

It looks like I don't get the new tile from the WMS/WMTS and it just puts the same map on all the sub-tiles.

My WMS link: https://wms.geonorge.no/skwms1/wms.sjokartraster2?&service=wms&version=1.3.0&request=GetMap&BBOX=-20026376.39,-20048966.10,20026376.39,20048966.10&transparent=true&width=512&height=512&layers=all&CRS=EPSG:3857&format=image/png

My WMTS link: https://opencache.statkart.no/gatekeeper/gk/gk.open_wmts?service=WMTS&request=GetTile&layer=sjokartraster&style=default&tileMatrixSet=EPSG:3857&tileMatrix=EPSG:3857:0&format=image/png&TILECOL=0&TILEROW=0

I use this website to test my urls: http://trailbehind.github.io/TilejsonTester/

[Image shows when I zoom. Map of Norway shows four places in the world and does not get bigger][1]

My Question: I want to copy specific cells, from multiple workbooks (Called: Business Case (1) and rising), and within these workbooks, i want to copy data from 2 different worksheets (named "Summary" and "Business Case Input Sheet"). I dont know how to write the code to copy and paste the data correcly?

The place i want to copy from :

Filename:"Business Case (x)"

Sheet: "Summary"

Cells:

I think I know what I want. My output needs to have "teams" as dict keys, for each dict key there will be a nested dict, in each nested dict the key will be a players name, the values for each nested dict key will be a list of goals per game. I want to be able to find out who scored the highest amount of goals for each team eventually.

I don't know if a dataframe is better for this?

code to make nested dict - I didn't know how to do it

I have text data such as this, where strings are grouped by delimiters and some words have digits attached to them: