I started with VBA yesterday. Could this code be improved?
Private Sub Worksheet_Change(ByVal target As Range)
If target.Column = 3 Then
Call Modul1.AutoFill(target)
End If
End Sub
Option Explicit
Sub AutoFill(activeCell As Range)
Dim storedData As Range: Set storedData ...
I have this template function for computing standard deviation in one pass over the data. The underlying math is here.
coderodde_sd.h:
#ifndef CODERODDE_SD_H
#define CODERODDE_SD_H
#include <cmath>
#include <iterator>
#include <sstream>
#include <stdexcept>
namespace net {
namespace code...
Looking for a tool to UI testing of a Windows (.NET WinForms) application. The idea is that the analysts will record the tests via some UI and it will be able to be played back over and over again.
Commercial tools are fine but bonus points for free ones.
A rather stupid question, why can we see the moon at night when it is between the Earth and the Sun?
I have incorporated all the cool points made by ChrisWue in the initial iteration of this post.
Now, I am not reinventing the wheel for my concurrent queue, but use internally std::deque. Also, I modified the API of the concurrent forp construct: now it takes any range specified by means of iter...
Hello all first time poster, actually first time ever having code peer reviewed! This is just the main function im concerned about.
private function dologinWithPostData()
{
if (empty($_POST['user_name'])) {
$this->errors[] = "Username field was empty.";
} e...
The loop tag is generic... like, very, very generic. Generic as in, if your code doesn't loop somewhere, it's probably not a computer program. Hence I'm nominating the loop tag for burnination.
Numbers and stuff:
As of 2016-04-06 there are 460 posts tagged with loop
At the same time, the lang...
This is a tally calculator for the Saudi card game Baloot. As in, they're a set of functions so that the user would provide their winnings at the end of a round (card captured, projects declared, etc) and the functions would give them the score for themselves and their opponent.
Domain Model
(...
This program goes through 7 common logical functions (AND, OR, NOT, NOR, XOR, XNOR, and NAND) and generates and prints truth tables for them all.
#!/usr/bin/env python2
# coding:utf-8
import operator
import itertools
table = list(itertools.product([False, True], repeat=2))
ops={'AND': ('∧', ...
For a raytracer I’ve been writing with a classmate, we use a custom scene definition format that allows specifying shapes, composite shapes, materials, lights, cameras and transform and render commands.
The assets of a scene (i.e. shapes, composite shapes, materials, lights and cameras) are stor...
I am just learning swift and tried to make a queue class with enqueue and dequeue.
-The node holds the data for each element
-The enqueue adds an element to the "queue"
-The dequeue deletes the first element in the queue and returns the data
-Head and Tail are references to node elements, whic...
Goal
The user puts in a starting word and an ending word. My code creates a ladder between these words of words that are different by one letter.
Start: gain End: fire
Output:
gain
gait
wait
wart
ware
wire
fire
Solution
I created a linkedlist of linkedlists and a hashmap that uses the wor...
I am new in php, and i have a problem with code repetition
`
$a=$this->some->somemethod();
if($a){
$a->someA=A;
$a->someB=B;
$a->someC=C;
}else{
$this->some->someA=A;
$this->some->someB=B;
$this->some->someC=C;
}`
Have any idea?
On Stack Overflow, the community consensus for research before asking is:
A lot. An absurd amount. More than you think you are capable of. In fact, asking a question on Stack Overflow is the absolute last thing you ever want to do. You want to avoid it at all costs. You want to think of it as...
I'm trying to implement a function which
takes time and velocity and returns a point increment;
takes time and acceleration and returns a velocity increment.
In pseudocode, it should look like this:
derive :: Time -> Velocity -> Point
derive :: Time -> Acceleration -> Velocity
Time is a ty...
I am using PL/SQL.
I have the following SQL query:
SELECT vin, make, model, zip, OWNER_ID FROM quick.listing WHERE REGEXP_LIKE
(OWNER_PROD_search, Concat(CONCAT(CONCAT('*ALPHA_DEALER.', DMA ),'='), make_code ) )
and aggregate_count > 0 AND channel LIKE'%ATC%'
However, when executing this que...
I have an html button that when the user clicks the button it will change color from blue to red and back. Is there a better way to do this in jquery?
Here is my html/jquery code
<html>
<head>
<title>Button Fun</title>
<script src = 'bower_components/jquery/dist/jquery.js'></script>
<...
Drafted this up today out of the need for a very simple php based login form to protect an html page.
The app is simply included the top of index.html like this:
<?php require_once('./login.php'); ?>
Usernames are stored in a flat csv file 3 levels up (just above docroot). For this particula...
I have written a test program and loaded a PNG image into it,
https://dotnetfiddle.net/XHwp7o
Pixel format = 32 bit color
Resolution of the Bitmap,
Width = 512 pixels
Height = 512 pixels
Stride of the Bitmap = 2048 pixels
Offset or Padding = (Stride - Width) = (2048 - 512) = 1336 pixels.
...
I have made a simple program that, given a string and how many times to repeat it, it waits a second and types that string N times, followed by an enter key. It is made for applications like skype. The waiting is so that you can get from the console to the application on time.
Dim i
Set s = WScr...
public class LargestPalindromeProduct {
public static void main(String[] args) {
int product = 0;
int largest = 0;
for (int first = 1; first < 1000; first++) {
for(int second = 1; second < 1000; second++) {
product = first * second;
...
I wrote a script to compute / interpolate the nodes of a Polyline at a given latitude, input_lat. It works for my purpose but I am wondering if there is a better, more optimized way of doing this.
The idea is to first check if there is any exact match, i.e. if there are nodes at the exact give...
