This code do: Copy a value from "Sheet1" Paste special (as a number) in another sheet "Sheet2" Jump to the next line I already did: Disabled screen refresh Wrapped the code with Application.EnableEvents = False and Application.Calculation = xlCalculationManual 1 made the calculation a lit...

Ok this is the first makefile I've ever written. I it works and that's about it. Things that I was wondering if if I can specify where the object files go. It looks really bad with all the .o files cluttering the working folder. I was thinking a src folder and maybe a obj folder? Is there a bette...

I solve this problem in Swift. I'm not sure if using an array was the right way to approach it since the problem was on stacks. Any feedback on my code is appreciated: You have an empty sequence, and you will be given N queries. Each query is one of these three types: 1 x -Push the el...

The question I posted received no comment or answer at all. It was just edited by another person to make the wording better and clearer. I reviewed the question but I can't find any way to improve it. Can I repost it exactly like the old question to see if anyone is interested?

My MySQL query is loading very slowly (over 30 secs) and I was wandering what tweaks I can make to optimize it. The query should return the last post with the string "?" of all threads. SELECT FeedbackId, ParentFeedbackId, PageId, FeedbackTitle, FeedbackText, FeedbackDate FROM ReaderFeedback as...

I am using react-native-router-flux to organize the routes for my application. Using Firebase, I am able to call onAuthStateChanged() in the componentWillMount function to determine whether or not a user is logged in. If a user is logged in, the state: loggedIn is set to true and the appScenes ro...

I just finished Project Euler #29. And it worked successfully. But after comparing my answers to those from other folks, i realize my answer is wrong. Now it seemed to give me the correct example when i used the numbers from the example (2-5)... but it seems to fail when going 2 - 100. All my mat...

Task- to find sum of all primes not greater than N Input format- first line contains T, the number of test cases and second line N Constraints- 1<=N<=10^6 I used the Sieve of Erastothenes. The code is working fine for first 6 conditions but in the last two it is showing wrong answer and time-o...

there here a simple mp3 Arranger that i just create for arranging mp3 files Question: how can i optimize this code? am i violating any OOP principle? is it readable? how can i make it better? The Project has 3 Files so i am posting the github link here instead of pasting the code Directly h...

I don't exactly know what to tag this question with as I'd never posted on meta before. Feel free to add the relevant tags and remove the unnecessary ones which I tagged. Just a few hours back I received the nice answer badge for this answer of mine which I posted few months back. The nice ...

I solved this stack problem in Swift. Looking for any feedback on my code: import Foundation /// Returns an integer read from one line of standard input. func readInteger() -> Int { guard let line = readLine() else { fatalError("Unexpected end of input") } guard let i = Int...

I downloaded Keylemon and set up a facial recognition login screen, then changed the password to something long and complex that I did not remember. Then Keylemon said it detected the password had been changed and wouldn't let me in without entering it. Fortunately, I can still get in on anothe...

I am developing ICMP tools package with Python. Currently I've implemented IPv4 ping using raw sockets. The current roadmap is: icmp traceroute Simultaneous ping ICMPv6 Documentation Tests https://github.com/abozhilov/icmp I'll be glad if you share opinion, ideas or critique. Contributions ...

I know nothing about .htaccess files and I really need to remove the extensions in my pages (.html,.php,etc..). I also wanted to compress files (html,css,js,jpg,etc..). I've been looking for answers and that's what I got so far (below). Although the website opens, the things I was expecting to ha...

I wrote a Priority Queue that is stored using a doubly linked list. The queue can return the head and tail of the list, and contains a print function that is only used for testing purposes. I'd like a critique of the general style, correctness, efficiency, exception handling, algorithm and any ...

is there any shorter version of this? or is there any better (and shorter) way to get index of a regex match in python? import re sstring = """ this is dummy text which starts with nothing and ends with something """ starts = re.finditer('start[s]?', sstring) ends = re.finditer('end[s]?', sstri...

I am currently making a simple pong game in Unity2D, following this tutorial. I currently have a scene where there is a title, and a game board. I want to add a scoring system so that when each player knocks the ball to the opposite wall, they get +1 point. Here are my scripts. I should include t...

While using bind_param in the below set of statments, the ? doesnt take account >of whitespaces. Example if $var contains "UFL", it'll work properly but if its >"university of florida", then it will say $b is undefined, that is, it doesnt >consider the whitespaces. $var=$_POST['sel']; $sql5...

My code is for the AC system and I used SA algorithm but there is a run time error. I couldn't find what is wrong with it.

I just wrote a tetris game and I'd like to humbly request for code review especially in terms of code transparency, code efficiency (whether something can be coded in faster way using less resources) and bad coding habits. Game is complete and working and hopefully without any serious bugs (at le...

I'm trying to write regex to validate the password for the given rule. Passwords must be at least 8 characters in length and contain at least 3 of the following 4 types of characters: lower case letters (i.e. a-z) upper case letters (i.e. A-Z) numbers (i.e. 0-9) special characters (e.g. !@#$&*...