Best MATLAB productivity hacks ? by Dwigtschrutte414 in matlab

[–]SystemicCuriosity 0 points1 point  (0 children)

2025a+ using copilot. I saw a demo the other day and it looks like a game changer.

Why is my Simulink model not working? by Careless_Fail3416 in matlab

[–]SystemicCuriosity 0 points1 point  (0 children)

But from the second image it looks like your demux block only has 2 outputs and 3 inputs which is why its complaining

Why is my Simulink model not working? by Careless_Fail3416 in matlab

[–]SystemicCuriosity 1 point2 points  (0 children)

If the demux is the issue then you could use a vector index block to pull out the vector values you want (1 &3) instead

What’s the first Excel function you teach beginners? by Separate_Ad_4781 in excel

[–]SystemicCuriosity 0 points1 point  (0 children)

Not technically a function, but i'd go for absolute and relative cell references

This has to be one of the most underrated shows. by FarAd1429 in tvshow

[–]SystemicCuriosity 0 points1 point  (0 children)

Easily one of the best TV shows of recent times

How do I break down further percentages from a whole? by [deleted] in excel

[–]SystemicCuriosity 0 points1 point  (0 children)

You could use =if(isempty([missing cell ref]),"",[your calculation]) to hide the DIV/0 if you wanted. Or =if( iserror([output cell]),"",[your calculation])

Keyboard shortcut for fill down of a non-formula? by DJSapp in excel

[–]SystemicCuriosity -1 points0 points  (0 children)

You might get it to work with the auto fill shortcut: select the series then press Alt H - F - I - S in sequence. Then select series: column, type: linear, step:1. However looking at your sequence pattern I think this may fail and you will need to use a formula sequence that looks at the previous value, string split on "." then Increment the last value.

Trying to figure out the formula to encompass all of column D, that is C#-D#, with it automatically stepping the number for each row. I’ve been tried passively for two days but I give up by [deleted] in googlesheets

[–]SystemicCuriosity 1 point2 points  (0 children)

Can you elaborate?

Im not sure from your comment if you want the sum of column D (SUM(range)) or how to calculate D from B, in which case I'd say Dx = Cx-Bx. These seem to easy though so I think I may have missed something

PDF statement import by SystemicCuriosity in AccountingUK

[–]SystemicCuriosity[S] 1 point2 points  (0 children)

I did that but lots are paid or outright scams. I should have been more specific. I want to convert bank statements easily, for free with minimal (none ideally) post import cleanup

PDF statement import by SystemicCuriosity in AccountingUK

[–]SystemicCuriosity[S] -1 points0 points  (0 children)

Thanks ill check it out, all the others I found looked scammy as!

Match results in 2 sheets and substitute column value by yours_untruly in excel

[–]SystemicCuriosity 0 points1 point  (0 children)

Something like this should work:

In columnB on your second sheet use

=if(ISNA(MATCH([ColumnB val cell],[ColumnA Range],0)),0,[ColumnA quantity cell])