Been trying to get treemap to work but the output is blank and not sure why. If I take an example from the web and place it into my code the the output works fine – but when I try to use my data it does not output. The sample code is.. library(plotly) labels = […]
I have block categories A, B, C, … and each category has blocks. all blocks in each category have ports p0, p1, p2, … and have constraints to connect as: A: a0, a1, a2, … p0: B, C p1: B p2: B, C p3: C B: b0, b1, b2, … p0: A C: c0, c1, […]
Im getting the error: Cannot use a mutable variable as an argument of the security function This is the code to show 3 lines as Resistance, Middle and Support. //@version=4 srch = input(high, "Highs Source") srcl = input(low, "Lows Source") mn = input(21, "Short Range", minval=1) F = input(5, "Long Range Factor", minval=2) mx = […]
I cant answer this with a comment because of my user status so I post the question again, here is the answer below: =REGEXEXTRACT(CELL("address",A1),"$\D") Works only in google sheets I think.
How can one get coordinates from input consisting of country, route number and distance from the beginning of the route? For example: (Austria, A1, 0 km), (Belgium, A12, 20 km) etc. I have looked at multiple geocoding APIs and none of them offers such funcionality. I have found a partial solution for some cases. Sometimes […]
I’m using the command below to create an HLS playlist: ffmpeg -i "Full.mp4" -map 0:v:0 -map 0:a:0 -map 0:v:0 -map 0:a:0 -map 0:v:0 -map 0:a:0 -vcodec libx264 -crf 22 -preset medium -c:a copy -filter:v:0 scale=w=480:h=360:force_original_aspect_ratio=decrease -maxrate:v:0 600k -b:a:0 64k -filter:v:1 scale=w=640:h=480:force_original_aspect_ratio=decrease -maxrate:v:1 800k -b:a:1 128k -filter:v:2 scale=w=1280:h=720:force_original_aspect_ratio=decrease -maxrate:v:2 1000k -b:a:2 128k -var_stream_map "v:0,a:0,name:360p v:1,a:1,name:480p v:2,a:2,name:720p" […]
I am trying to calculate totals for each node of a tree structure, Calculating the total depends on roll up type I have Structure like below if node type is current list = Look to current node, no need I go down in the tree if node type is child = ignore the current node […]
I want to drive 3 i2c devices on a single i2c line. Is it possible to achieve this without using A0,A1,A2 pins? I thought the address of i2c devices should be programmatically changeable. 2 mcp23017 and si5351 chips I use.
I have a table which calculates the total logged hours per week per person. The Excel file has the following structure: table where the desired values are calculated table with days of the month divided by weeks table with the data necessary for the calculations (which is in another sheet) Calculation sheet This is where […]
I have a table which calculates the total logged hours per week per person. I have used the following formula: =SUMIFS(time,date,">="&A1,date,"<"&A1+7,project,"A") This formula was applied for weeks of January and it gave me the totals per week, displayed in 5 columns for every week of the month. I intend to use this Excel as a […]