G6 | ♾ A Graph Visualization Framework in JavaScript | Data Visualization library

I'm building a Google Sheet that has two main sheets to it: (i) the user interface where they include the data (Name: "Interface Boletagem" - let's call Sheet A) and (ii) the database where the data gets stored (Name: "Boletador (Dados)" - let's call Sheet B).

I already have a script that got optimzed thanks to the contributors of this forum that transfers the data from Sheet A to the last blank row on Sheet B.

I am starting with CSS and I have a doubt, I do not understand why the section . aside2, takes the width based on the text that puts it inside and not the one specified in the grid of the body, what I want to do is to have the links of. aside2 rotated but with the width assigned in the grid-template-columns and not that I take it depending on whether I add more text or not, and understand why I will not, to see if someone can help me

*fill text because it says my post is mostly code, fill text because it says my post is mostly code

I get an error when using a formula like this [file.SetCellFormula(sheetName, "A6", "=IF(C6<>\"\";IF(OR((F6-E6)>0;G6<>\"\";J6>0);\"O\";\"X\");\"\")")], I'm sure the formula is correct, I have copied this formula from a working excel file

I use the following formula to calculate the SUMPRODUCT of the values in a column with the condition that there is a match between B2:B6 and A1:A3 (shoutout to user:8162520).

=SUMPRODUCT(($B$1:$B$6=$A$9)*(G2:G6))

Now however I would like to subtract to that result the percentage in C1 and/or D1, and "give it" to one of the other blue numbers, again with the condition that there is a match between C2:C6 or D2:D6 and A7:A9.

So for example in G7 the result for "1" should be 50% of 10 + 75% of 5, because "2" takes 50% of 10(G2) and "3" takes 25% of 5(G5).

The point is to create an overview of how many hours employees (1,2,3) have to spend spend on project B2:B6 for each week (E,F,G), and what happens if other employees take a certain percentage of the workload (C,D). What is the most efficient way to do this?

The numbers in A, B,C, D are reference numbers, they should not be part of the calculation. Maybe it's clearer if I use letters. See also the right results for E7:G7. The outcome must be the sum of the values in each column (workload) minus the percentage in C and D IF there is someone sharing the workload:

Example file: https://docs.google.com/spreadsheets/d/1M-o8Mu3vBrBgs1wC1WL5kqK61m6Vu1K5ylGByKDCZTo/edit?usp=sharing

On the sheet "To be coached" I have a query in cell A2. The query might not be optimal and maybe it's convoluted, but it works, aside from one small detail that I just can't get to work. This is the current query.

I am trying to create a heatmap with an external dendrogram using the ComplexHeatmap library .

Using excel 365. I have used this same formula for "asset allocations" and it worked perfectly. I decided to do the same for sector allocation and I can not figure out what is wrong. This has beat me down. I have tried for 2 days. I thought that I could just exchange the category for sector. Didn't work. Thank you for any help.

Here is the image which shows the sheet that I am using. The formula in G6 is:

=SUMPRODUCT(SUMIFS(INDIRECT(K$6:K$11&"[Value]"),INDIRECT(K$6:K$11&"[Sectors]"),[@Sector])) You can see a REF Error on the column "Value".

This image is to show where the "Sectors" are listed on the individual sheets that I wish to sum.

I need you all to help me with this problem.

The context :

I'm trying (struggling) to create a counter of every proposition the enterprise make to know every date of signature of each proposition. So I create a Worksheet that will serve as a base for everyone, every time they create one they just need to type a number to identify the proposition. I've already created a macro to write the number and the amount of a new proposition in the last free row of the counter Worksheet.

Note : The 2 Worksheet are in different Workbooks.

Now the difficulty is that on the counter sheet there are multiple signatures. Signature A, B, C, D and they never happened on the same day.

Note: I will create a different macro for each signature based on the eventual answer we will find. ( A macro for A, a macro for B, etc…)

Exemple :

ChronoView

Charles creates a Proposition, number: 101 and only do the signature A.

John creates a Proposition, number: 102 and only do the signature B.

I need to be sure that it will enter the date of signature A in the row of Proposition 101 and also enter the date of signature B in the row of Proposition 102

My actual position:

I've made 2 Workbooks :

—Contract (This workbook contains a sheet named “Proposition”)

—Chrono (This workbook contains a sheet named “Counter”)

PropositionView

So if I want my date of signature A for the Proposition 101 in the right row, I need to find the text/value of G6 that is in “Proposition”, and look for it in “Counter” A column. If it functions correctly, it must find the A9 cell then write the formula : TODAY() in H9

What I did (don't laugh, I started macro 3 weeks ago haha):

I have two small tables.

First one contains 3 columns and 5 rows. Second one contains 4 columns and 5 rows.

When cell value from first table (column 3) is equal to cell value from second (table column 3,4) then I need to copy ID's of those cells (columns 1 both tables) let say 10 rows below so I get another small tables where I would see all ID's from both tables which are equal.

I could do that with IF statement but It's lot of job and I'm looking for better solution.

I developed that simply code but I need to repeat it again and again...