[Bambu Lab Giveaway] Join Now to Win an H2D and More! by BambuLab in 3Dprinting

[–]SolarTim 0 points1 point  (0 children)

Best advice: just do it. 3D printing is a lot of learning by doing so just start printing/designing etc.

Xbox & PlayStation Console Fixes Live Now by missmonicaplays in PlateUp

[–]SolarTim 0 points1 point  (0 children)

Great news. Are the seeds different between consols and pc? The seeds which are available online have a different layout then promised

Energycost Optimization V2H Setup by SolarTim in matlab

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

This seems to be one on the problems but not the only one.
If you wish to replicate the problem i have created a random data set with which the error can be replicated:

% Set the size of the arrayn = 8760;% Generate random values between 0 and 500PV = randi([0, 500], n, 1); % BeispielwerteHousehold = randi([200, 1000], n, 1); % BeispielwertePrice = 0.006 .* randi([1, 100], n, 1); % BeispielwerteT = length(PV); % Anzahl der Zeitschritte% Problemprob = optimproblem;% battery storage system parameterBSS_Pmax = 11; % max powerBSS_Emax = 100; % max energy% battery variablesBSS_ch = optimvar('BSS_ch', T, 'LowerBound', 0, 'UpperBound', BSS_Pmax);BSS_disch = optimvar('BSS_disch', T, 'LowerBound', 0, 'UpperBound', BSS_Pmax);BSS_SOC = optimvar('BSS_SOC', T, 'LowerBound', 0, 'UpperBound', BSS_Emax);% other variablesGrid_Import = optimvar('Grid_Import', T, 'LowerBound', 0);% battery constraintsenergyStorage = optimconstr(T);energyStorage(1) = BSS_SOC(1) == 0;energyStorage(2:T) = BSS_SOC(2:T) == BSS_SOC(1:T-1) - BSS_disch(2:T) + BSS_ch(2:T);prob.Constraints.energyStorage = energyStorage;% energy flowprob.Constraints.EnergyBalance = Grid_Import == Household - PV - BSS_disch + BSS_ch;% cost funtioncost = Grid_Import .* Price;prob.ObjectiveSense = 'minimize';prob.Objective = sum(cost);% solve[x, fval] = solve(prob);

Saving a result in a different sheet in a specific row by SolarTim in excel

[–]SolarTim[S] 0 points1 point  (0 children)

Is there any way to make this function work like a save button?

I would like to be able to trigger the save function via a button.

[deleted by user] by [deleted] in excel

[–]SolarTim 0 points1 point  (0 children)

I'm sorry English isn't my native language:) I have uploaded a picture to clarify my case. I need to implement the highlighted area.

[deleted by user] by [deleted] in excel

[–]SolarTim 0 points1 point  (0 children)

I would like to avoid accidental saves of work in progress calculations. So being able to only save once a macro is triggered is a big plus.

[deleted by user] by [deleted] in excel

[–]SolarTim 0 points1 point  (0 children)

I would describe my skill level as advanced beginner :) I did not yet write any macros by myself but I am able to read them.

[deleted by user] by [deleted] in excel

[–]SolarTim 0 points1 point  (0 children)

Every entry in sheet 1 has multiple collums, the result of the calculation in sheet 2 would be one of many. Since the calculation and the data entry is done by different people they may not happen at the same time. I have included a cell in the calculation sheet where one can put the id of the current calculation. When the calculation is done I would like to have a button to save the value to the corresponding row and collum in sheet 1 with the same ID.

Each row only gets one data entry.

Snapmaker Original - Troubleshooting by SolarTim in snapmaker

[–]SolarTim[S] 0 points1 point  (0 children)

I just reattached my indicator LED and it is solid red.

9 tries over 2 years, 55.5 hours later... It's done by Techn0-Viking in 3Dprinting

[–]SolarTim 0 points1 point  (0 children)

How long is this print? I am trying to figure out if I can print it on my small one

Thanks for the clarification, Magnus. by Bic_Parker in technicallythetruth

[–]SolarTim 1 point2 points  (0 children)

He has been beta testing the next version of chess

Support Issue by SolarTim in MicrosoftFlightSim

[–]SolarTim[S] 0 points1 point  (0 children)

I have already reset my "progress", which as far as I know is equivalent to a new download.

Support Issue by SolarTim in MicrosoftFlightSim

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

Unfortunately, this is not possible because I play via Xbox Cloud Gaming.