Categories
User Help

My Excel COUNTIF function always returns “0”

I am trying to count how many cells do not start with U, D, or R, appear before 15:00 pm and match a certain date (A4). I am using this function: =COUNTIFS(Sheet1!$B$2:$B$1088,A4,Sheet1!$C$2:$C$1088,"<>U*",Sheet1!$C$2:$C$1088,"<>D*",Sheet1!$C$2:$C$1088,"<>R*",Sheet1!$D$2:$D$1088,"<15:00") Column B in Sheet1 contains all the dates, column C in Sheet1 contains the cells that either start with U, D, R, or […]

Categories
User Help

My Excel COUNTIF function always returns “0”

I am trying to count how many cells do not start with U, D, or R, appear before 15:00 pm and match a certain date (A4). I am using this function: =COUNTIFS(Sheet1!$B$2:$B$1088,A4,Sheet1!$C$2:$C$1088,"<>U*",Sheet1!$C$2:$C$1088,"<>D*",Sheet1!$C$2:$C$1088,"<>R*",Sheet1!$D$2:$D$1088,"<15:00") Column B in Sheet1 contains all the dates, column C in Sheet1 contains the cells that either start with U, D, R, or […]

Categories
Mastering Development

Passing Hex parameter to RDLC

I have an RDLC report in my project where a text field is passed a string parameter using the following method to generate a hex number; public string GetHexColor(int r, int g, int b) { return string.Format("{0:X2}{1:X2}{2:X2}", r, g, b); } I was hoping for the user to specify the color of the fill by […]

Categories
Mastering Development

Better way of error handling in Kafka Consumer

I have a Springboot app configured with spring-kafka where I want to handle all sorts of error that can happen while listening to a topic. If any message is missed / not able to be consumed because of either Deserialization or any other Exception, there will be 2 retries and after which the message should […]

Categories
Mastering Development

Why does this time out? Is the time complexity not O(n^2logn)?

This problem comes from a leetcode problem called "3sum." I will include the problem statement, as it might be helpful in answering my questions. Problem Statement: Given an array nums of n integers, are there elements a, b, c in nums such that a + b + c = 0? Find all unique triplets in […]

Categories
Mastering Development

string operator + (overloaded) different behavior for char array and string.in cpp

I tried merging 2 arrays using string operator. Following case works fine, + operator accepts char* and string. string s = "";; char a[5] = { ‘f’, ‘i’, ‘r’, ‘s’, ‘t’ }; char b[6] = { ‘s’, ‘e’, ‘c’, ‘o’, ‘n’, ‘d’ }; s = a + string(b); But this case does not work fine […]

Categories
Mastering Development

How to delete older folders to a certain number of last folders using subprocess of python?

I work in Linux os. I want to delete older folders in a path to a certain number (e.g., 30) of last folders using python’s subprocess. Through a search survey, I have tried to run the following commands. p = subprocess.run(["rm", "-r", "`ls -t | awk ‘NR>30’`"]) or cmd = "rm -r `ls -t | […]

Categories
Artificial Intelligence (AI) Mastering Development

Why does TD Learning require Markovian domains?

One of my friends and I were discussing the differences between Dynamic Programming, Monte-Carlo, and Temporal Difference (TD) Learning as policy evaluation methods – and we agreed on the fact that Dynamic Programming requires the Markov assumption while Monte-Carlo policy evaluation does not. However, he also pointed out that Temporal Difference Learning cannot handle non-Markovian […]

Categories
Mastering Development

An Overflow Error In Orbit Simulation also Position’s of Planets Changing Very Fast (Faster than C)

I try to make a physics engine to calculate orbit. But I got too big results and too small results in lenght beetween the Sun and Mars. Position changing absurdly 5*E-70455 to -E187886 Can you help me: Engine Code import decimal G = decimal.Decimal(1) dt = decimal.Decimal(0.001) import matplotlib.pyplot as plt from Planets import planetList […]

Categories
Mastering Development Software

creating websocket connection in GO

I am trying to create a connection with a wss endpoint. My assumption is I make an endpoint on my system (socket) and listen on it, and create a client to connect to the endpoint of the website. I am trying to use websocket.(*dialer).Dial() from gorilla websocket library. What I am having problem with is […]