« first day (975 days earlier)      last day (3338 days later) » 
00:00 - 16:0016:00 - 00:00

Zak
Zak
16:07
Oh my god. I've just been introduced to the accounting workbook our entire company's financial reporting is based off of. It's 50,000 formulas across 20 worksheets and ~100,000 cells. I'm resisting the urge to immediately kill it with fire with great difficulty. At some point I'm going to have to start recreating it piece by piece.
But who knows how long that'll take.
That doesn't sound too bad for a large company.
@Zak How long… for it to burn entirely?
The longer, the better, isn't it?
An awful lot of formulas, but 100,000 cells doesn't sound bad at all.
Zak
Zak
@Hosch250 We're not. We're 14 employees.
@Zak How long has this been in use?
Zak
Zak
16:10
At least a year
If you are keeping records through the years, it will build up fast.
@CaptainObvious Why is this not ot? Is it not asking for "how do I do this without x"?
@Zak It is battle tested. Whatever you replace it with from scratch won't be.
I took accounting classes not long ago, and they have to record a lot of information.
Take the Ship of Theseus approach
Zak
Zak
16:11
@DanPantry Maybe, but I have no idea what can safely be changed
And there are no tests
Or safeguards
You can safely assume that whatever you replace it with will not have the feature-bugs that that excel doc has
Zak
Zak
Or data validation
So there's no way to avoid the "safe changes" part
Zak
Zak
And no code
Purely spreadsheet functions
1. Don't post code in links. 2. If you have working code post it at SE Code Review 3. If your code is broken, explicitly state all the errors you get in your question. — πάντα ῥεῖ 40 secs ago
I'm voting to close this question as off-topic because it is not about a specific programming problem. Code reviews are at codereview.stackexchange.com. — n.m. 16 secs ago
Zak
Zak
16:13
Put it this way, when I start re-creating it, I'm going to sit down with the finance director and walk through what each bit of accounting needs to do.
Asking for improvements for already-working code is off-topic ("too broad") on StackOverflow, but an excellent fit for Code Review StackExchange. — Charles Duffy 24 secs ago
Zak
Zak
I mean, there's sheets with a data table for the first 2,000 rows. Then a new data table 100 rows further down with data in completely different columns
sub-split into multiple smaller tables with their own re-defined headers
0
Q: The longest known cycle length of generalized collatz 5x+1 trajectory

Angelina DThe generalized collatz 5x+1 trajectory ,if n is even then divide it by 2 and if n is odd then multiply n by 5 and add 1. For example if n =3, We have 3=>16=>8=>4=>2=>1=>6=>3 ,so the cycle length is 7. if n=5, We have 5=>26=>13=>66=>33=>166=>83=>416=>208=>104=>52=>26=>13, so the cycle length is...

Zak
Zak
AFAICT, the only reason it hasn't broken (in a way we can observe) is because it was hard-coded with a lot of extra rows which we haven't (yet) exceeded.
But I have no idea if the outputs are correct
And no way of checking
16:16
@Zak Sounds like job security for you :)
Zak
Zak
Definitely.
I think once this is re-coded, and our transaction list is in an actual database, it will become impossible to fire me without hiring a software dev to replace me.
0
Q: Completed a basic game of Tic-Tac-Toe in java. How can I make my code cleaner/more efficient?

ezmacnsteezeimport java.util.Scanner; public class ticTacToe { public static Scanner input; public static void main(String[] args) { input = new Scanner(System.in); char p1 = ' '; char p2 = ' '; boolean gameOver = false; char[][] board = new char[3][3]; int pos1 = 0, pos2 = 0; ...

Zak
Zak
Falsehoods programmers believe about: Addresses, Names, Time, Geography
Funny and enlightening at the same time :)
The names one is really good @Zak. I have a vietnamese colleague called Le-Thahn. Most of his ID papers have his surname as ".", or he has to use an English name
@Zak I love those, I have them bookmarked
16:30
@Zak I like how the Geography's blog favicon is "No".
And yes, that is the one Hiragana character I remember
Zak
Zak
Reminds me of this somewhat:
3644
Q: How do I correctly pass the string "Null" (an employee's proper surname) to a SOAP web service from ActionScript 3?

billWe have an employee whose last name is Null. Our employee lookup application is killed when that last name is used as the search term (which happens to be quite often now). The error received (thanks Fiddler!) is: <soapenv:Fault> <faultcode>soapenv:Server.userException</faultcode> <fault...

That^ is priceless
0
Q: Is this a good way to convert UK weight drams to ounces and pounds in PHP?

s7QI have written this little function to convert UK weight drams (dr) to ounces (oz) and pounds (lbs). As far as my research goes 1 lbs = 16 oz and 1 oz = 16 dr. I need the function to return an array of lbs, oz and dr. Am I doing it right? Or is there a better way to do it? Has my method got any ...

@Phrancis Yup. One of the few 'favourites' I have on SO.
Is him changing his name a reasonable workaround? — Dabbler Apr 18 '15 at 21:21
Zak
Zak
"People whose names break my system are weird outliers. They should have had solid, acceptable names, like 田中太郎."
"Human-readable dates can be specified in universally understood formats such as 05/07/11."
"Buildings do not move"
16:43
@Zak to be fair, this one is usually true unless they get hit with some explosives.
Zak
Zak
"Usually true"
@Zak Close enough for most systems. If they need, the record can be updated.
Zak
Zak
Sometimes I am truly amazed by the world
"Changes in the offsets between time zones will occur with plenty of advance notice."
I'm voting to close this question as off-topic because copied to codereview.stackexchange.com/questions/115817/…Alister Bulman 33 secs ago
Zak
Zak
"The day of the month always advances contiguously from N to either N+1 or 1, with no discontinuities."
16:47
@Zak When doesn't it?
I can believe it, people are so strange, but I've never heard of it myself.
@Zak I've had instances where the day of the month advanced from N to N+2, with sufficient levels of toxicity
Zak
Zak
"24:12:34 is an invalid time"
@Mat'sMug Example, please?
Zak
Zak
"You will never have to parse a format like ---12Z or P12Y34M56DT78H90M12.345S"
@Hosch250 There's a period of my late teen years that's quite foggy
Zak
Zak
16:50
"My software stack will handle it without me needing to do anything special"
@Mat'sMug lol
Zak
Zak
That one's gold ^^
Oh, drugs. That makes me glad I don't do them.
Glad you stopped.
Me too!
Zak
Zak
"The software will never run on a space ship that is orbiting a black hole."
16:52
0
Q: GitHub API client

Richard CookHere is my Haskell program designed to list all of my GitHub repos along with their descriptions and languages via the GitHub JSON APIs: {-# LANGUAGE DeriveGeneric #-} {-# LANGUAGE OverloadedStrings #-} module Main where import Control.Monad import Data.Aeson import qualified Data.ByteString a...

Zak
Zak
To be fair, that one is *probably* true
"People have names"
Anyway, TTQW. See y'all tomorrow.
See you.
I'm pretty sure the world is doomed if Rubberduck ever needs to run on a spaceship that's orbiting a black hole
5
@Mat'sMug Dim star = New WhiteDwarf()
hehe, space and programming jokes
This question needs another answer, one not written by the author of the answer in question. — Mast yesterday
That one.
@Mat'sMug They did the Apollo missions with something less advanced, I think they'll manage.
16:58
@Mat'sMug And it's not that bad. The world wouldn't be doomed, only the people orbiting the spaceship with Rubberduck on it.
Zak
Zak
@DanPantry But what if that's all that's left of the entire human race?
Takes "Edge Case" to a whole new level ^^
Who would be stupid enough to put the remainder of the human race on 1 vessel?
That's an accident waiting to happen, regardless of the software.
@Mast Donald Trump (off-topic warning, guys)
Zak
Zak
Who said they had a choice in the matter?
BTW.HomeTime
17:00
21
Q: How much idle chatter do we tolerate in The 2nd Monitor?

MastRelated but not a duplicate: How far off-topic can we get in 'the 2nd monitor'? Today was a complicated day in the history of The 2nd Monitor. On one side there appears to be consensus something went wrong which should be handled. On the other side there appears to be disagreement about how muc...

Zak
Zak
TIL the computer in a modern toaster is more powerful than the guidance computer on the Apollo missions
We're trying to save the (future) human race, how is that not important ^^
@Mast I don't see how this is relevant. If the answer is good, then fine. If it is bad, then DV and flag.
@Hosch250 It needs an actual answer.
A less biased one.
That's cruel : ( — Angelina D 15 mins ago
Nope.
17:21
0
Q: Effect marquee label in Delphi

NemoBlackI'm doing a function for a marquee effect on a label, the label handed it, I put long texts and disable the "AutoSize" property. The marquee effect is bottom-up, the code that I have is: procedure TForm1.Form_EffectsClick(Sender: TObject); begin Label1.Caption := 'This is right scrolling text'...

@CaptainObvious Y U MARQUEE??!
@CaptainObvious Borked.
> What is the problem ?
@Mast I just saw your comment on this post:
3
Q: Personal Website

Darcey MckelveyI have written the following code for my personal website, in Jade and Stylus. Can anyone review this code? Are there any tips that you can give me on how to make it better? Here is the main-page.jade file: doctype html html(lang="en") head title Darcey Mckelvey link(rel="stylesheet" h...

And I'm guessing he added because he uses it to compile his jade and styl files
It's difficult to help when you haven't actually explained what the problem is to begin with. If your code works and you're just looking for it to be reviewed, you're in the wrong place. codereview.stackexchange.comtnw 40 secs ago
Also, as I commented up at the beginning, please consider closing this question here and re-opening it on Code Review SE. — Charles Duffy 45 secs ago
I'm going to assume it's safe to remove and remove it
17:31
@AlexL So, he basically added the name of his compiler as a tag.
No reason for it to stick around in that case.
Thanks for the heads up.
Pretty much, yeah
That's one seriously old comment :P
Haha I have been going through zombies lately, so I've dug up a lot of old/wacky stuff
0
Q: Choosing different Version of a model

boyIs there anything to improve with how this code is structured into functions? Is the coding style ok and what can be improved beyond this? def add_lower_intuitive_relation(gurobi_model, Leg1, Leg2, lower_bound, eval_func, name=""): for first_departure in xrange(Leg1.latest_departure_time - L...

possible answer invalidation by Amstell on question by Amstell: codereview.stackexchange.com/posts/115437/revisions
17:50
@Duga We can let this one slide. It was edited in response to a comment.
18:08
Agreed with @Cerad as this seems overly complex. What's wrong with keeping it in your Entity function? That seems like the far better place for it. You said this isn't a reusable bundle, which means you should have some measure of control over the source code anyway - just use code reviews, document the format, and call it a day. — Jason Roman 38 secs ago
18:22
Kind of over the whole work thing today. How's everyone here?
Zak
Zak
@RubberDuck Tired, but glad none of my macros broke in the new year (that I know of)
4
Douane Allman just seriously overdoes it with that cheesy solo :/
Hiya there, btw.
18:46
1
Q: Is there any way this bash script segment can be simplified?

TrelIn this case, sdir is a base path I define elsewhere, and sfile is another prefix. Those are hard coded into the top of the script, so those will always be correct. What I'm trying to do here is first set the first eight variables to the proper default values. That's the first area I'm thinking ...

0
Q: CIDR Notation parser

mcgyver5I created the following code to better understand CIDR notation. Also to learn some of the Stream features in Java8. I posted my unit tests too. I'm interested in ways it might be improved especially by using Java8 features. I reviewed the InetAddr class and realized it uses at array of bytes...

http://www.commitstrip.com/en/2016/01/04/my-2016-big-resolution/
CommitStrip
My 2016 Big Resolution
CommitStrip
1451933274
4
19:33
@RubberDuck I'm pretty well done with work as well.
Somebody upvoted my SOAP vs. REST answer on SO today.
I feel special.
19:49
@annemartijn If you moved the question to codereview then please close this one. — i3arnon 22 secs ago
20:08
@Mat'sMug Are you around?
0
Q: Implementing an asynchronous mutex in C#

Tim Lovell-SmithI wrote a simple synchronization primitive that I can use with async operations on an external REST service so that I don't call it twice from different threads and have one call fail due to not having the latest state. Despite obvious limitations of that design decision I think this should solve...

@EBrown sort of
I need some WPF help...
wassup? hold on
@EBrown I know a bit of WPF, what's up?
I did not move the question to codereview. I'm just asking for a code review for my given answer. I'm even strongly considering that @kirill-shlenskiy will give me a better answer than my own. — annemartijn 38 secs ago
20:25
@SimonForsbergMcFeely I think I found an @Duga bug.
possible answer invalidation by EBrown on question by EBrown: codereview.stackexchange.com/posts/115468/revisions
Nevermind, as soon as I said that it came in.
@Duga Nope. Just added extra DDL.
20:58
Damn you're really getting hammered with questions on that @EBrown
@Phrancis That's a good thing, though.
Naruto answer; accepted non-selfie answer with 0 score: Rails app query form code behind
Ripe zombie; open question with answers, at least one answer having score 0, no answer having score > 0: 4 database queries, multiple loops in loops, slow processing time
I'm about to move all these comments into a chatroom though, auto-flag is at 20 comments within 24 hours
Perhaps this qualifies for codereview and should be moved there ? — Marged 43 secs ago
@Mat'sMug Maybe just move them to the SQL Helpline?
21:03
I don't get to pick a chatroom when I move an on-site conversation to chat
the system just creates a new one specifically for the question, and links to it, too
@Marged I'm sorry, didn't know about the Code Review Section so far. Any Mod: please feel free to move the topic whereever it belongs! :) — user2556555 24 secs ago
@Duga that's not quite how flagging works
You'll have to include a better description of what your code is doing, summarize that in the title, and then consider including the entire class - Code Review answers will address much more than just the performance aspect. — Mat's Mug 6 secs ago
21:50
how can you be this bad at UX
yes, that is the character limit I've reached there
now I have to continue on the next line
3
Q: Optimizing SQLite SELECT Performance

ManuI need to read Databases which contain 44-50 Tables, with around 5 Million entries in Total (~ 100k entries per Table). The Data consists of Positional Tracking Data in Sports (Players,Refs and the Ball) and Match-Events (Shots, Plays,Tackles,...): Match-Events are negligible regarding performan...

a... multiline textbox was too complicated?
lol that's awful
Hmm better here is to give them complete access and make a code rewiew and there is a cool plugin (Gerrit) where you can make code review for special users. Perhaps that is a solution. Otherwise you have to use Submodules. But normally you need the whole project to run the project. — Stony 46 secs ago
This is where I get my diploma
Pretty sure it's made by someone as his internship or thesis
the pisspoor internship site we have is also made by a student
22:02
monking
0
Q: Dictionary implementation using hash table in C

onedayI have written below code which does the task of loading the dictionary and checking if the given word is present or not. Implementation is using hash table with chained linked list Regarding hash function I have kept it simple only as I was not much concerned about collision Can someone pleas...

1
Q: What to do with question with compiler warnings/errors due to copy & paste error

ChrisWueUnfortunately in this question I posted some broken code due a copy-n-paste mistake without realizing. I've contemplated closing it but two answers have picked up on it and they also suggest other things beyond just pointing out the bugs. So I'm not sure if it might be better to just leave it?

22:18
@Quill hey
hey @phrancis, if I had two tables with an identical column (list and progress) how could I get the unique ones from the list table? in sqlite? is that a thing?
Yeah
Not exactly sure about SQLite but generally you can do SELECT ... UNION SELECT ... if you need to combine them together (assuming they are the same data type)
Which would do a distinct check on the values before giving you the result set
SELECT url
FROM listingToHit
WHERE NOT EXISTS (SELECT 1 FROM listing WHERE url = listingToHit.url)
this seems to work
Yeah could very well be, just do a sanity check
sanity check? like check the data?
22:27
yep
I don't think it does work
Good, check this : sqlite.org/lang_select.html
Search for paragraph beginning with A compound SELECT created using UNION ALL operator
/*This will return only distinct values, i.e. no duplicates */
SELECT url FROM listingToHit
UNION
SELECT url FROM listing;
Hmm, it's more of, all of the urls in listing are in listingToHit but I want to match all of the urls in listingToHit that aren't in listing
OK, use EXCEPT instead of UNION
22:43
That works
Thanks man :-)
You're welcome!
TTQW
0
Q: R: Largest common multiple equal or lower than `max`

Remi.bI made this small and easy function that return the largest common multiple of the elements of ms that is equal or lower than max LCMLthan = function(ms,max) { ms = sort(ms, decreasing =TRUE) max2 = c() for (m in ms) { max2=append(max2,m*floor(max/m)) } max2=min(m...

0
Q: Encapsulating Complex Calculation in JavaScript

aiokoThis is code for performing a calculation that should be repeated with different levels and temperatures. I am concerned about the organization of this code as I feel it may contain too many helper functions and seems a little unnecessarily complicated. Only the getCharge() method needs to be exp...

23:11
0
Q: Function to generate all valid Parentheses of n*2

mc20For a leetcode Problemto generate the valid Parentheses of length 2n, I have written the below solutions. It is working for smaller inputs but not for larger inputs. Please suggest a way to optimise my code. I have read the stackoverflow questions but unable to implement the same concept in my c...

@Mat'sMug I used a CURSOR today.
I guess you had to?
Yeah. I have a bunch of tables that I had to query.
Doesn't sound like a good reason at first sight...
@EBrown every sql query ever
23:26
^^
Eh, cursors can be OK to use, if you are careful (and you've determined you actually need one)
You kids are pampered nowadays
Back when I wrote COBOL, cursors were all we had
2
I thought EBrown was older than you?
If Jeroen wrote COBOL, I wrote my first program on a punch card
11 hours ago, by Morwenn
Hi, I'm an elitist jerk :)
@Morwenn is that the password for the C++ club?
Ew. You did write COBOL
@JeroenVannevel I'm impressed!
I'm glad that's over now, though if I had to do it again I'd put a lot more time in it
chosing the data types for my variables was always guessing which one would work
Hey @JeroenVannevel I'm getting a PowerShell error while trying to install VSDiagnostics, is that normal?
installing VSDiagnostics?
As in: adding it as a reference from NuGet?
23:36
 PM> Install-Package VSDiagnostics -Version 1.8.0
like that (I'm not really familiar with nuget)
using the beta version gives the same error anyway
> You cannot call a method on a null-valued expression.
At C:\Projects\ScraperC#\packages\VSDiagnostics.1.9.1-beta\tools\install.ps1:6 char:1
+ $project.Object.AnalyzerReferences.Add("$analyzerFilePath")
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull
@Quill VS2015?
Let me create a new project and try it out
though be warned: VSDiagnostics is very brittle right now
@Mat'sMug I don't think so
I'm virtually finished with school on Friday, after that I'll fix a billion bugs
@Quill oh lol, you need VS2015
@Jeroen user support 101: first question is always is the power cord plugged in? ;-)
23:41
I'm not sure why I have 2013 installed actually
I had 2015 (and VSDiagnostics) on my last machine...
Did you fork Rubberduck? That could have been why :-)
0
Q: How can I write this array-based parameters check more succinctly?

remusI've got a simple Javascript function that takes multiple types of arguments. Inside the function I'm doing a check on the arguments to determine which way the user called the function: if (_.isString(args[3]) && !_.isUuid(args[3]) && _.isString(args[4])) { options.to.type = args[3] } else i...

if (_.isString(args[3]) && !_.isUuid(args[3]) && _.isString(args[4])) {
    options.to.type = args[3]
} else if (_.isString(args[2]) && !_.isUuid(args[2]) && _.isString(args[3])) {
    options.to.type = args[2]
}
0
Q: How can I write this array-based parameters check more succinctly?

remusI've got a simple Javascript function that takes multiple types of arguments. Inside the function I'm doing a check on the arguments to determine which way the user called the function: if (_.isString(args[3]) && !_.isUuid(args[3]) && _.isString(args[4])) { options.to.type = args[3] } else i...

0
Q: Bus Announcement System in ROBLOX Lua

Mrfunny744I got bored and decided to create a lua announcement system with the ROBLOX API. One part is the display code, and the other part is the announcement code. DISPLAY CODE while true do wait(0.2) if script.Parent.Parent.An.Value == 0 then script.Parent.An1.Text = "This bus termina...

@Quill There are plenty of nice guys in the C++ club.
you can be nice, and elite. the jerk part is just redundant
23:56
No need to be nice or elite when you can be a jerk.
Ugh, System.in.read() is such a dumb tool. Been messing around with it long enough I decided to just use Scanner and limit it to one char instead. Worked first try.
00:00 - 16:0016:00 - 00:00

« first day (975 days earlier)      last day (3338 days later) »