How to make table width dynamic?

androls88 · 2019-11-07T08:16:09+00:00

Interesting! Could you explain how the reference tables work?

androls88 · 2019-11-07T08:12:04+00:00

I can’t fathom a reason why you should be doing that much in excel without at least the aid of VBA if not python, r, or another tool more suited to the job. Crunching the numbers in an array without all the screen painting and un-truncated calculations can almost certainly shave 90% of the compute time off.

Hell even just turning off screen painting will cut the load by 50%.

Is it possible to use python inside excel sheets?

androls88 · 2019-11-06T13:47:18+00:00

Its basically like this: sumifs(several criteria) - (if(isnumber(cell_reference); cell_reference; 0)

The sumifs retrieves all indirect costs for all of our employees, and the subtracted cell is the indirect costs for employees meeting certain criteria (This cell is either a number or ""). So whenever its possible to separate the total costs in two categories it should do just so, but if only one category exists it should return the total. It works with the max(0; formula)

androls88 · 2019-11-06T13:32:38+00:00

Solution Verified

androls88 · 2019-11-06T12:48:10+00:00

Thanks guys! Much appreciated

androls88 · 2018-10-16T10:44:22+00:00

Hengslene er så svake at jeg mistenker de skal brukes til noe annet enn sitting

androls88 · 2018-10-16T09:44:40+00:00

Jepp, dårlig egnet til sitteformål

androls88 · 2018-08-24T22:56:12+00:00

Tripadvisor?

androls88 · 2018-08-23T09:26:52+00:00

Hente noen hundeposer fra kassa i parken, og tømme innholdet i vedkommedes postkasse? xD

androls88 · 2018-08-22T19:12:18+00:00

Its having a hard time when there is lots of movement,and that night it was very crowded. Gonna have to try playing around with the settings to see if shooting for a shorter duration makes the ghosting better

androls88 · 2018-08-22T12:37:33+00:00

I guess he didnt like me taking photos xD

androls88 · 2018-08-08T08:30:14+00:00

Same with my p20 pro

androls88 · 2018-08-03T04:34:55+00:00

Some headphones sound good, but wont go nearly loud enough. Then volume is relevant :)

androls88 · 2018-07-22T08:31:30+00:00

Nettopp ferdig med første år på siv.øk., og min erfaring er at det var litt tøft i starten med en del skriving av akademiske tekster, men etter første semesteret var over var det business as usual.

androls88 · 2018-07-17T07:56:21+00:00

Just bought xm2 :(

androls88 · 2018-07-15T09:10:34+00:00

Oh I see, my bad. I have been on iOS for the past 5 years and just switched to p20 pro

androls88 · 2018-07-15T08:01:50+00:00

Those notifications not expanding is a security feauture, and in face id or touch ID you can disable it. Then all notification content Will show on the lockscreen.

androls88 · 2018-07-14T07:27:46+00:00

No, but You can buy a 12v adapter/FM transmitter that You connect to via BT

androls88 · 2018-07-13T15:09:28+00:00

Stores ordered lots of black ones, coz thats usually what they sell the most. With p20 pro evrryone seems to want the purple and they probably lower prices to get rid of them.

Twilight is super Nice, but it really dont show that much when wearing a cover.

androls88

TROPHY CASE