Coding Projects and Duga Heaven :)

« first day (1593 days earlier) ← previous day next day → last day (1970 days later) »

Duga

12:00 AM

RELOAD!

[rubberduck-vba/Rubberduck] 1 opened issue. 13 issue comments.

IvenBach

12:19 AM

@Phrancis Hosch has experience with F# as I recall.

I'm failing along with getting my VSTO add-in to make it easy to solve for systems of linear equations.

Pretty sure putting everything in the code behind is #DoingItWrong.

1) Make it work *Done*
2) Make it right
3) Make it fast

Phrancis

@IvenBach I understand almost every word in that sentence, but the order you put it in confuses me o.o

(long for "what the heck is that")

IvenBach

x + 2y and 2x + y correspond to the coefficients {1,2; 2,1}.

Phrancis

Ah OK, I see. I don't maths very well X)

IvenBach

By taking the inverse of the coefficient matrix and multiplying it by the answer vector you can solve systems of linear equations.

It's typically simple to do in Excel. I'm forcing myself to learn by making it part of my add-in.

I got it to work as a Form, but all the logic is in the code behind.

Phrancis

@IvenBach So the form only contains the code for the GUI, and the rest of the logic is in a separate module?

IvenBach

12:34 AM

I think the best model for this is Model View Presenter (MVP) but I don't know how to write it using that pattern.

bruglesco

1:22 AM

@SimonForsberg Well I hope things slow down for you a little soon. I hope all this hard work is paying off.

@IvenBach I could be way off because I still haven't gotten around to learning C# yet

But I thought that the code behind is exactly where you would want your logic

shouldn't the 'business logic' be in the code behind and the form just covers the presentation logic?

oh hey - guess you'll find out

Q: VSTO add-in for Excel to solve systems of linear equations

This code is part of a VSTO add-in for Excel. As the title states it solves systems of linear equations by allowing the user to select the appropriate ranges. The code works and covers most issues I could think of. The form is displayed by a button click from the ribbon. The selection of ranges i...

c# excel

6 hours later…

IvenBach

7:56 AM

I’d like an answer but won’t hold my breath for it.

Everything I’ve understood for a view/form is is just presents a UI to enter info into. Nothing is stored in the UI though as it gets passed to some model. The theory of it I understand. Actually doing it is where I’m stuck.

Business logic is the Model, I think. If @SimonForsberg or anyone more experienced in this could correct I’d appreciate it.

Sleep time and worrying about it tomorrow.

Duga

8:46 AM

[Zomis/Connecting-Blocks] jorgemachucav starred us

6 hours later…

Feeds

2:58 PM

June 21st, 365, the date of the big Mediterranean earthquake and tsunami, lived in infamy for a few centuries before fading. Maybe the trick is a catchy rhyme; the '5th of November' thing is still going strong over 400 years later.

Marc-Andre

3:14 PM

Have a nice day everyone

1 hour later…

IvenBach

4:36 PM

@bruglesco Re-thinking the title the mention of VSTO may be off putting to some that could answer it. ~shrug~ let it be for a bit and if nobody bites then change the title.

Feeds

4:48 PM

CommitStrip: ChromEdge

posted on December 12, 2018 by CommitStrip

skiwi

5:15 PM

hey

@Feeds loool

IvenBach

It's a double edged sword.

skiwi

@IvenBach I see what you did there

IvenBach

Huh?

Oh, LAFF! I didn't even mean it that way but hooray for double entendres.

bruglesco

6:21 PM

@IvenBach I guess I missed what you were doing. I thought the code behind was your Model. I definately don't know enough C# to be helpful. Nvm and good luck.

IvenBach

6:35 PM

That’s the code behind for the form itself.

I’m not going to give up until I understand how to do it right.

skiwi

6:54 PM

@IvenBach Oh wow I thought you did it on purpose

IvenBach

7:37 PM

I have a way with #Words. It’s usually on the poor side unfortunately.

4 hours later…

Duga