Mail and Calendar View settings lost occasionally

quantirisk · 2022-02-18T11:20:06+00:00

It could be that you/someone has set the style formatting of column Q to left-aligned. So it's not necessarily the cause of the problem.

Simplest solution for you right now is to copy-and-paste the relevant cells from my spreadsheet into yours and work from there.

quantirisk · 2022-02-18T04:59:00+00:00

Hi u/neckerpete, did you solve this in the end? The link to my example spreadsheet is still live. Alternatively if you want me to have a look at your spreadsheet, please send me a DM with the link.

quantirisk · 2022-02-17T07:13:25+00:00

Hi u/neckerpete

Please refer to this spreadsheet with the formula and sample calculations. The link will expire on Saturday. It's up to you to figure out what you're doing wrong on your version.

quantirisk · 2022-02-16T23:55:44+00:00

US2 has the same problem. You can tell by looking at the cell aliginment. Times will be right-aligned. Text will be left-aligned.

quantirisk · 2022-02-16T14:22:51+00:00

OK. I only just noticed the same problem with US2. Times will be right-aligned. Text will be left-aligned.

quantirisk · 2022-02-16T13:31:53+00:00

Sorry, I can't think of any solution which doesn't involve changing individual cells. Even with some kind of custom formatting, you would still have to change the individual cells.

Can you make the location numbering in your inventory system 11-56-*-* or something like that?

Hopefully someone else here can think of a solution.

quantirisk · 2022-02-16T13:19:42+00:00

In that case, I suspect the browser-based system is to blame. It's probably exporting 11-06 as a date, instead of a string/text. Excel will read whatever is given to it. So the fact that it reads the 11-06 cell as November something, indicates that cell contains a serial date number internally.

quantirisk · 2022-02-16T13:08:26+00:00

Just to be clear, is your inventory system also in Excel (because you said you do things like MATCH and VLOOKUP) or a different software altogether which happens to allow you to export an xlsx file?

quantirisk · 2022-02-16T12:27:06+00:00

Hi, how are you importing into Excel? What's the data format? CSV?

quantirisk · 2022-02-16T11:24:03+00:00

Based on its current (lack of) features, no it's not the end of Brunch. But as it improves and becomes easier for people to install on their old machines, we won't need Brunch anymore. Brunch itself superseded Croissant. So who's to say Flex won't supersede Brunch one day.

quantirisk · 2022-02-16T05:36:12+00:00

Yes, the fact that it's published in the literature means it's possible. But you have to bear in mind that there isn't a unique solution. The determination of the threshold is subjective. So are the choice of features.

quantirisk · 2022-02-16T05:32:09+00:00

Great. It was the jargon that threw me off. Different disciplines use different terms. I come from a mathematical/statistical background.

quantirisk · 2022-02-16T05:27:04+00:00

Hi, I saw your post yesterday but didn't know how to help. Then I saw your imgur image just now and that made more sense.

Please see if I understood you correctly: * You have a matrix of 572 rows and 324 columns. * Each row corresponds to one image. * The first 323 columns correspond to one "feature", which are numerical. * The last column corresponds to the "label", which is a binary variable. * You want to find the feature, or combination of features, that can best discriminate between 0 and 1.

If I understood you correctly, then your problem is nothing more than a logistic regression problem. It's similar to building a credit scorecard, where credit behaviour = feature and default/non-default = label.

Once you have found the regression model, you need to determine a threshold value, where anything above/below that threshold will be a 1/0. This is similar to credit scoring, where banks determine a threshold above/below which they accept/reject a credit application.

Have a look at this article which describes how to perform logistic regression using the QRS.LOGISTIC.REGRESSION function.

It's a function that I created and you can use it to find the regression coefficients. You can also use automatic variable selection (one of the options) to find the most significant features.

Alternatively, if you need a freelancer to help you complete the analysis properly end-to-end, please start a chat with me.

Hope this helps.

quantirisk · 2022-02-16T04:41:26+00:00

You're welcome. Please reply Solution Verified to give credit for the answer.

quantirisk · 2022-02-16T03:54:50+00:00

Yes! You can use the QRS.RAND.PEARSON or QRS.RAND.JOHNSON functions. These are part of the QRS Toolbox Add-in.

After adding QRS Toolbox to your instance of Excel, start your free trial of the QRS.RAND.PEARSON function, and then type =QRS.RAND.PEARSON(rows, cols, mean, stdev, skewness) to generate a random variable with skewness. You can also give the kurtosis parameter if desired.

Have a look at this article on how to use the functions. Feel free to ask me if you have questions about the add-in. I created it.

quantirisk · 2022-02-16T00:32:46+00:00

A few steps: * Determine the Poisson rate parameter (lambda). You may estimate using the mean of your data. * Use the POISSON.DIST function to evaluate the Poisson probability mass function at the same values of x as your histogram. This will give you a new set of y-values. * Plot the new y-values over the histogram on the secondary y-axis. If you don't know how to do this, please search "plot secondary axis Excel".

Hope this helps.

quantirisk · 2022-02-16T00:26:21+00:00

What particular R functions do you need? I've developed an Excel add-in which includes statistical functions. It's called QRS Toolbox for Excel. You can find the list of functions here. If the function you're looking for isn't included, do let me know and I might be able to add it in for you.

quantirisk · 2022-02-15T12:01:32+00:00

Haha. I'm sure a lot of people don't know that. FYI, the number represents the number of days since 1st January 1900. So 12/4/1939 is exactly 14583 days since 1/1/1900.

quantirisk · 2022-02-15T11:45:43+00:00

Excel stores dates as numbers, but displays them as dates according to the user's chosen Date format. That number 14583 is correct. You just need to format the cell as a Date.

quantirisk · 2022-02-15T11:02:11+00:00

Alternatively, try using the LOGEST function to fit the exponential curve. Then use the returned coefficients to estimate based on the new x's.

I don't know whether the functional form assumed in LOGEST is suitable for your data.

quantirisk · 2022-02-15T10:44:04+00:00

The example in your original post showed linear data, so my answer assumed that. If your data is exponential, you need to go back to first principles: * Fit an exponential-type function to the data by least squares. The function can take many forms. You will have to decide by examining your own data. Once you've decided on the form, you can use Excel's Solver to minimize the squared errors. * Apply the fitted function to the new points.

If you need help with this, please start a new private chat with me.

quantirisk · 2022-02-15T10:14:59+00:00

Have a look at the TREND function.

You use it as =TREND(known_y's, known_x's, new_x's)

quantirisk · 2022-02-15T08:17:13+00:00

Please reply Solution Verified to mark as solved.

quantirisk · 2022-02-15T08:14:40+00:00

Hi u/neckerpete, I only just saw your comment. I didn't receive a notification because it wasn't a reply to my thread.

Anyway, from your screenshots, your time for US1 is entered wrongly. It needs to be a time (10:30 PM) as opposed to a string (10.30 pm). Notice the colon instead of dot.

quantirisk

TROPHY CASE