Categories
User Help

Factoring business growth into linear regression

I am looking to run a pretty basic linear regression in excel with the products price as the Independent Variable and QTY sold as the Dependent variable. I have 5 years of sales data with each row showing month of month growth. The issue is our company has been in a steady state of growth […]

Categories
User Help

Factoring business growth into linear regression

I am looking to run a pretty basic linear regression in excel with the products price as the Independent Variable and QTY sold as the Dependent variable. I have 5 years of sales data with each row showing month of month growth. The issue is our company has been in a steady state of growth […]

Categories
Mastering Development

How can I split a row into multiple rows depending on multiple columns?

I have the following row (I use the character "|" to separate columns): A, B|1, 2, 3|0, 1, 2 and I want to obtain the following rows in a separate sheet: A|1|0 A|1|1 A|1|2 A|2|0 A|2|1 A|2|2 A|3|0 A|3|1 A|3|2 B|1|0 B|1|1 B|1|2 B|2|0 B|2|1 B|2|2 B|3|0 B|3|1 B|3|2 I tried the following (row is […]

Categories
Mastering Development

Python speed up permutation of bits within 32Bit number

I’m interested in reordering the bits within a number, and since I want to do it several trillion times, I want to do it fast. Here are the details: given a number num and an order matrix order. order contains up to ~6000 lines of permutations of the numbers 0..31. These are the positions to […]

Categories
Mastering Development

SQL Server 2014: Pairing rows from 2 tables based on values coming from a third one

I have 2 tables that contains typed events over time. The first table #T1 contains events that always comes before events in the second table #T2. A third table #E contains records that defines for an event the values that comes in #T1 and #T2 respectively. Sample data: CREATE TABLE #T1 ( EventTimestamp DateTime, VehicleId […]

Categories
Mastering Development

Is it possible in Java to implement interfaces and their methods without using the keyword “implements”?

I have homework to do (actually my girlfriend :-D) and there are some restrictions on what I can and can’t do. In my NetBeans project folder there are two folders named "interfaces" and "homework". The folder "interfaces" contains interfaces and classes that are NOT allowed to edit, because said that to us xD. I am […]

Categories
Mastering Development

How to draw a p5.js circle over an HTML image

I am loading an image into my web app using standard JS and HTML It just just a simple map and my goal is to draw on it using p5.js. <div id="map"> <img src="Assets/MENA.jpg" class="image" width="1500" height="750"> </div> function conflictMapMENA() { this.name="MENA conflict map"; this.id="conflict-map" this.draw = function() { var map = document.createElement(‘img’) map.src = […]

Categories
Mastering Development

TextField State Management in Flutter

I am trying to create a note app. I am using a Textfield with a prefixicon and my problem is that if the user types something in the textfield and afterwards picks a date, then the textfield input is getting cleared. Any suggestions ?? Thanks in advance ! Here is tthe full code… class AddTask […]

Categories
Linux Mastering Development

Unable to start a 5GHz wireless AP

I have a Debian 10 fresh install with an Intel Wireless-AC 9560 dual-band chip. I’ve been trying to get it to start a wireless AP in 5GHz mode, to no avail. The relevant part of the output of iw list is given below: Frequencies: * 5180 MHz [36] (22.0 dBm) (no IR) * 5200 MHz […]

Categories
Linux Mastering Development

Can’t Start Systemd Timer

I have the following systemd timer configuration [Unit] Description=Timer for Service [Timer] Unit=service-unit.service OnCalendar=Mon..Fri *-*-* 13..23:0,15,30,45:00 # *-*-* means every day and 10:00:00 is the time of day (UTC) [Install] WantedBy=timers.target When attempting to start the timer I receive the following error message: Failed to parse calendar specification, ignoring: Mon..Fri *-*-* 13..23…5,30,45:00 service-timer.timer lacks value […]