Responsive Ad Area

Month: December 2018

Using IF Array in Excel

Let’s say I am trying to calculate X/Y/Z, where the value for Z is in a single column C but the values for each of X and Y are selected from two columns apiece, with the higher of the two cell values being used. I can paste the intermediate value into a hidden column of course by doing =IF(A1>B1, A1/C1, B1/C1) and then repeating the formula to calculate X/Y/Z using the intermediate value instead of Y/Z, but how do I sidestep that and combine everything into one array? Using IF Array in Excel Using IF Array in Excel test {$excerpt:n}

Auto populating sheet and then creating a new sheet.

I’m working on a dashboard, and there is a sheet titled “Customer list” with names and numbers of customers. Each day the dashboard has to generate a new list of 40 customers through an Active X button that have to be contacted. I am unable to figure out how to code the button in such a way that every time it is pressed, a new list of 40 customers is generated from the sheet ‘Customer list’ each time. Please help, I’ll be very grateful. Auto populating sheet and then creating a new sheet. Auto populating sheet and then creating a new sheet. test {$excerpt:n}

Direct peer connection cannot be established in Zerotier

I have two boxes with ip addresses 10.61.3.88 and 10.170.130.31. Both are directly accessible to each other and ports 9993 are telnetable. However, neither could see the other in the list of zerotier-cli listpeers. I also tried adding hints to local.conf as this { "virtual": { "e4465b2ccc": { "role": "UPSTREAM", "try": [ "10.170.130.31/9993" ] } } } which doesn’t help. All firewalls are turned off and selinux is disabled. One box is Archlinux while the other Centos 7. Zerotier version is 1.2.12. What’s going wrong here? Direct peer connection cannot be established in Zerotier Direct peer connection cannot be established in Zerotier test {$excerpt:n}

Camping ground in USA

I and my family member’s about to go camping at west Virginia. I am newly shift here and don’t anything about the place. Where we can go for camp and also come back safely. Camping ground in USA Camping ground in USA test {$excerpt:n}

How to copy files with the same name but in different folders to the same folder and keeping both of them (not one overriding the other)?

I am writing a python scripts that goes through all of the directories of a certain hard drive and I want to recursivly enter all the directories and when the code finds a file it copies it to a different path that i’ve specified. The thing is that some files have the same name and i want to save both of the files. is there a way to tell the program to save both files (maybe add a “(1)” like windows copy method does) and not override each other? I’ve used the shutil.copy2 to copy the files so far… Thanks in advance for the help! How to copy files with the same name but in different folders to the same folder and keeping both of them (not one overriding the other)? How to copy files with the same name but in different folders to the same folder and...

How can I make my sliding animation begin at the edge of the page?

I have an SVG image that I animated sliding from the left into the frame. The problem is, the animation begins at the left edge of the object, and not the left edge of the page. How can I make the animation begin at the edge of the page? When I add margin or padding on the object, it just starts the animation further from the edge of the page. When I add margin or padding inside the SVG, it accomplishes the goal but cuts off the SVG on the right. HTML Body: <body style="background:#3F6184;"> <div class="full-w"> <object class="hi" data="static/images/Hi.svg"></object> </div> </body> svg: <svg version="1.1" id="hi" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" x="0px" y="0px" viewBox="0 0 160.562 148.92" style="enable-ba...

Find average after annotation subtract without aggregate Django-rest-framework

I have a lot of querys that want to return in a single request, I have a query with an aggregate and when we concat the queryset with this function and try to serialize the function returns an error: [‘All items in the ConversasAPIViewSet querylist attribute should contain a queryset key’] Is there any kind of solution for this problem? APIViewSet: class ConversasAPIViewSet(ObjectMultipleModelAPIViewSet): kpiDTO = KpiDTO(6) json = Conversas.objects.values('nome' ).annotate(deltaTime = (Max('data') - Min('data')) ).aggregate(tempoMedioTotal=Avg('deltaTime')) qtdUsuariosMes, qtdMensagensMes, fraseIntentEntity, tempoMedioTotal = kpiDTO.retornaDTO() querylist = [ {'queryset': qtdMensagensMes, 'serializer_class': QuantidadeMensagensMesSerializer, 'label': 'qtdMensagensMes'}, {'query...

Have two discord.py scripts and want to connect them together without actually putting them together

Trying to connect my two scripts i made to work on heroku without actully putting them together as that won’t work. Hi, So i have a little problem I mad two discord scripts and they both work, but i want to host my bot on heroku and and I use free version so i can only host one bot, the problem is i have two files and cannot put them together as it won’t work and i can’t show you the scripts as they’re quite good to be shown. I see alot of tutorials talk about main and seems to work but it doesn’t work in discord.py or atleast I’m using it wrong and can’t find any tutorial about it on discord.py any one know how to connect to scripts together from GitHub? Lets say this is file 1 and it has the following import discord client = discord.Client() @cli...

Possible to display IEX data with Python 3.7?

I understand how to Display CSV data using Python but now I want to import live /historical data from the IEX api into python. I know you have to use Pandas and they have documentation for python 3.5 but I am having trouble figuring out how to install python 3.5 since there are security flaws and they don’t offer a web based installer anymore. Here is the IEX documentation https://pypi.org/project/iexfinance/ and here is a better overview of IEX https://iextrading.com/developer/docs/#unofficial-libraries-and-integrations. I would also be willing to use another library like this but IEX seems to be the best and has most historical data. Just running into a lot of issues with 3.7 I have already tried using their documentation to GET and pull display info. I can do it with a csv just fi...

The system cannot find the path specified: Error while starting zookeeper(Apache Kafka)

I am getting the below error while starting Zookeeper server in the command prompt: The system cannot find the path specified. I am using Windows 8 OS, Kafka 2.12 and Java 8 JDK. I have checked on the below: 1. Set JAVA_HOME to JDK bin folder. 2. Set the PATH environment variable correctly using JAVA_HOME as the relevant path. 3. Set the CLASSPATH environment variable correctly using JAVA_HOME as the relevant path. 4. Used shortened path in windows to avoid using spaces: Ex: C:Progra~1 instead of C:Program Files 5. Checked on the below commands in the command prompt: echo %JAVA_HOME% echo %PATH% echo %CLASSPATH% where java java -version java -d64 -version javac -version All of them gave me the specified path. However it didn’t resolved my issue. The system cannot find the path...

How can I remove this? …(process 4652) exited with code 0

So.. I am noob, and I just created a c++ empty project in Visual Studio 2017. int main() { return 0; } This is all I have in ‘main.cpp’, and ‘main.cpp’ is the only thing I’ve added/done in this project. I started without debugging and it results : E:"location_of_the_file" (process 1276) exited with code 0. Press any key to close this window . . . I have no idea how to remove that first line. Please help! How can I remove this? …(process 4652) exited with code 0 How can I remove this? …(process 4652) exited with code 0 test {$excerpt:n}

Is 16:8 hours Intermittent fasting good for Heath, please share any scientific analysis

Is Intermittent Fasting good for health, I want to go with 16:8 hour intermittent fasting, please share any scientific analysis. Is 16:8 hours Intermittent fasting good for Heath, please share any scientific analysis Is 16:8 hours Intermittent fasting good for Heath, please share any scientific analysis test {$excerpt:n}

  • 1
  • 2
Skip to toolbar