Replies

They are located in 2 directories on the c drive.
1 directory was a fresh install and then a copy over from the old computer c drive
2. other directory files were copied from the old computer c drive. copy and paste.
Thx
Jk

Given the size of modern hard drives, why bother to archive mail?

cheers, Paul

I have a lot of emails or so the machine says, it is time to get rid of them or to archive them off the computer but where I can search and see the dates and threads not weird looking files.
Thanks
JK

Yes there is – none other than Windows Explorer. You can just drag’n’drop emails out of WLM into a folder of your choice. They’ll be saved as .eml files with the subject as the filename. Note, though, that this will copy the emails, not move them, so you’ll have to delete them in WLM afterwards. Normal Explorer commands will work, such as to select a whole folderful.

That is great, but
1. the date of the “email file” on windows explorer picks up the date that it was transferred as of today. So one has a whole bunch of files with the same date unless you open each file to see the date of the email
2. No easy way to read them or group them or to search them like one does in regualar email programs

I need a way to have the emails off the computer ideally and still be able to use them like regular emails sort on sender or date or do a search to see a particular topic…..

Having them on explorer makes certain they are not lost, but need a better program to use them…
Any other suggestions welcome
Thanks
JK

Thank you, but I don’t want to “overthink” this one.
Just to keep it ultra simple, if one were to choose to make an all cash offer on property b that has a HOA fee of $500 a year and planned to own the property for 15 years how much less would you offer for property b versus property a. Would it be as simple as $500 x 15 years so $7500 less or is there a more elegant approach formula to this.???
Thanks
JK

Dear Maudibe
Many many thanks, Tried everything really great, Columns add works great
[Rows add fine but have to make certain there is an item in the a column for the new row or won’t work right
which is just fine
(sorry for the late response I was away and only had my Iphone and surprisingly could not view xls files on it)
Again my thanks
JR

So the “empty” cells of the spreadsheet do not show so “empty”
can the empty cells default from blank to an empty “circle” radio button may be easier to read a long grocery list Please see my original a.xls for the empty circles/radio buttons.
Another words, can the on off formatting of the cell show a different empty kind of symbol versus just being empty
THanks

Dear Maud and HTH, Many thanks, both work great, and will just try each out to see works better.
Thank you for the abundance of choices, many thanks
JR

Maud, many many thanks, just wonderful.
1. Any way I can add formatting to increase the font size or change its color to say red bold and slightly larger check mark.
2. Also can the pointer not revert to a1 but to the next cell below as if you had just hit the enter key or something similar.
Right now it moves the whole workbook up and forces you to scroll down for a long list to get back to the area of the workbook you were last in??
Again my thanks
JR

I apologize, but the pasted photo seems to be in front of all the cells and not linked to a cell.
I perform edit / paste, maybe this is the wrong set of commands to paste into a cell versus pasting into a sheet

Thank you but this does NOT work It inserts a picture into the spreadsheet that you can move allaround the sheet. It does not insert it into a particular cell that is then associated with that cell. Unless I am inserting incorrectly.
JR

Steve Perfect THanks, Just looking for what the time weighted average is for a given date that I give to the spreadsheet. This works great. Gives me a feeling of how much of my own principal has been working for me at the xirr with a time weighted average.
JR

HTH Many thanks, really appreciate this. JR

Steve Many thanks,
1.I pasted in the formula into your sheet at cell f10 and it yields 0 I am not certain I understand this.

2.I was actually thinking more of a hedge fund where you put in deposits over the years and was trying to get what I thought would be a simple handle on how much “original” money was basically working for you for that time period.
Extreme example to show my point: If you put in 10k at the begining then 10k is working for you of your own money and if you put in 5k additional of your own money say 1 month right before you take a valuation some 2 years later in reality you only had 10k working for you of your original money for all the time of this investment not 15 k or an average of 7.5 k, as an extreme example.

With a hedge fund any possible dividends, interest or increase in value during the investment period is irrelevanat as this is all a ghost till the money comes out. What is only real from most people point of view is how much of your own original money has been put in and is at risk and working for you. Rest of any increase is immaterial as do not know how much you have till you cash out.

What I think has more interest is how much of your own real money has been working for you over these years, in this extreme example it is not 15k but really 10k that you have been earling the XIRR on.

Obviously if you made 20 additions at varying times the actual amount of your own real money workinig is less obvious over the life span as investment could be skewed to the front end (all the deposits at the beginning or to the rear end or equally distributed over the period from beginning till when you cash out) . .

Was hoping to get at a formula or way of seeing how much of one’s capital has really been getting the xirr for the period of the investment retrospectively was it really 10k as most put in at the very end or was it the full amount of whatI put in as all at the beginning. or was it just some time weighted average that only a computer can properly calculate that the xirr was working on . This would be determined by the first date cell and the last date cell when one decides to liquadate all monies.

I hope this is clear, Thanks
JR

Steve
I am impressed, your understanding of this math is so far superior to mine.
What I am interested in is getting a handle on the amount of principal that you are getting interest on.
Lets say it is a non dividend paying stock or a mutual fund just to make it clearer to get my thought across. We have a certain amount at the beginning invested say 10 K over the months years you put in at different non equal intervals say 1K one time 6 k another time. And at the end say 3 years later you have a value for the investment of say 20K
But if all the contributions were put in right at the end of 3 years you might be feel you only were getting the increase on just the beginning working capital of 10 k as most of the principal was put in 2 days before the end. On the other hand all the contributions of principal might group at the beginning and then you would be getting increase in value on all of the principal

I am interested to see what the “time weighted” capital would be. Are you getting 6 % on most or part of the capital, how much capital was getting the benefit from the IRR most of the time was it just 10 k or was it 18 k…… It would not be fair to add up all the principal payments and divide by the number and say this is what the average working capital was over the term of the investment as the curve could be skewed to the front or end…..
Just looking for a better understanding / indication of what is the “average” working capital just like the XIRR gives a better indication of the return over the term of the investment
thanks
jr

Steve
ps Is there a way of determining the average daily balance in a time weighted fashion between the first deposit and the last deposit versus just doing a simple average which does not propertly reflect the different investment period of the different deposits??