Categories
Mastering Development

What is required to make this treemap plot work?

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 = […]

Categories
Mastering Development

Connection Algorithm with Constraints

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, […]

Categories
Mastering Development

Mutable variable + security function – tradingview pine error

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 = […]

Categories
User Help

How to get the current column name in Google Sheets using Reg extract

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.

Categories
Ask Geographic Information System (GIS)

Geocoding by route number and distance

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 […]

Categories
User Help

How to put watermark in some segment .ts without transcoding full video

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" […]

Categories
Database Development

Sum Scores in Tree Structure Based on Rollup Type

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 […]

Categories
Arduino Ask Engineering

Is it possible to change and save I2C address programatically?

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.

Categories
User Help

How to calculate the total logged hours per person per week per month?

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 […]

Categories
User Help

How to calculate the total logged hours per person per week per month?

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 […]