Search found 34 matches

by LanceGary
Fri Nov 02, 2018 12:52 am
Forum: PlanMaker 2018 for Windows
Topic: How to make graphs
Replies: 1
Views: 3016

Re: How to make graphs

I presume your equations have an x input and a y output. I presume the x input is the same for all three equations that you wish to compare. Make a column containing that set of x-values. Then make three columns for the y-values from the 3 equations. Turn the equations into formulae that Planmaker c...
by LanceGary
Fri Nov 02, 2018 12:41 am
Forum: TextMaker 2018 for Windows
Topic: Error opening C:\Users\User\AppData\Local\Temp\FileName
Replies: 2
Views: 2437

Re: Error opening C:\Users\User\AppData\Local\Temp\FileName

I wonder if you installed the recent Windows 10 feature update? It was supposed to back up all your files to MS Onedrive, but some people found that it had simply deleted all their files. If this is the case I do not know how you get your files back.
Lance
by LanceGary
Mon Oct 29, 2018 9:10 am
Forum: PlanMaker 2018 for Windows
Topic: Can't see how to insert image into cell
Replies: 5
Views: 3257

Re: Can't see how to insert image into cell

There are tutorials showing how to paste pictures into an Excel cell.

see for example
https://trumpexcel.com/insert-picture-into-excel-cell/
by LanceGary
Mon Jul 09, 2018 10:47 am
Forum: TextMaker 2018 for Windows
Topic: Operator AND inside function
Replies: 2
Views: 1969

Re: Operator AND inside function

If you enclose the two conditions being tested by the "If" statement in brackets it should work.

so

if((Table1.#a1<5) & (Table1.#c3<5); "Small"; "Large")

should print "Small" or "Large" depending on the values in Table1. It did in my tests.

Lance
by LanceGary
Mon Mar 19, 2018 6:12 pm
Forum: PlanMaker 2018 for Windows
Topic: Solver
Replies: 0
Views: 48150

Solver

I think there are several open source solvers for spreadsheets. If John W. Foreman (“Data Smart”, Wiley, 2014) is to believed some of them are better than the solver supplied with Excel (which, apparently, has been somewhat crippled in more recent versions of Excel). I wondered if it would be possib...
by LanceGary
Mon Nov 20, 2017 8:32 am
Forum: PlanMaker 2018 for Windows
Topic: xlsx versus xlxm
Replies: 10
Views: 19257

Re: xlsx versus xlxm

" If I open it in Plan Maker and then try to save it as "xlsx" it says a file by that name already exists but shows it with extension "xlsm"."

Save to another folder?

Lance
by LanceGary
Wed Jan 01, 2014 12:43 am
Forum: Water Cooler
Topic: Happy New Year
Replies: 1
Views: 26276

Happy New Year

Best wishes for 2014 to everyone here.
by LanceGary
Thu May 02, 2013 1:13 am
Forum: Water Cooler
Topic: Microsoft's subscription price trap
Replies: 4
Views: 30143

Microsoft's subscription price trap

The latest issue of Office Watch includes the following interesting remarks about the subscription option for MS office: "Microsoft has played a clever game with Office 2013 subscription pricing and the media has taken the bait with the proverbial hook, line and sinker. "Take this generally positive...
by LanceGary
Thu Mar 14, 2013 1:30 pm
Forum: Water Cooler
Topic: Cloud based spreadsheets are not trustworthy
Replies: 0
Views: 27890

Cloud based spreadsheets are not trustworthy

Abstract from Journal of Statistical Software: Cloud computing is a relatively new technology that facilitates collaborative creation and modification of documents over the internet in real time. Here we provide an introduc- tory assessment of the available statistical functions in three leading clo...
by LanceGary
Fri Feb 15, 2013 10:03 am
Forum: Water Cooler
Topic: One more reason to appreciate Softmaker!
Replies: 1
Views: 27093

One more reason to appreciate Softmaker!

According to Woody's Office Watch MS has changed the licence terms for MS Office. I quote from that Newsletter's excerpt of the new licence terms: 'The direct evidence is there in the Software Licence Agreement (the SLA is the newer name of the EULA). We have a copy of the Office 2013 Software Licen...
by LanceGary
Wed Jul 28, 2010 12:18 am
Forum: Water Cooler
Topic: Largest formula you ever wrote?
Replies: 3
Views: 5107

Re: Largest formula you ever wrote?

sven-l wrote:There is no fixed limitation. You should at least be able to insert 65536 characters into a cell in PlanMaker but I never tested it.
Ah. About the size of the entire memory of a computer from the late 70s or early 80s.

Thanks

Lance
by LanceGary
Mon Jul 26, 2010 9:57 pm
Forum: Water Cooler
Topic: Largest formula you ever wrote?
Replies: 3
Views: 5107

Largest formula you ever wrote?

I can't seem to find anything in the documentation for Planmaker about how many characters can fit in a cell. I'm sure it is more than 255 (at least in PM 2010 for Windows my experiments suggest that it is larger than 255). Wondering about this led me to wonder what the largest formula was that peop...
by LanceGary
Wed Jun 30, 2010 3:53 pm
Forum: Water Cooler
Topic: Misinformation in a review
Replies: 2
Views: 4987

Re: Misinformation in a review

Ha - I'm sure if you couldn't move them then I won't be able to.

Cheers

Lance
by LanceGary
Wed Jun 30, 2010 12:58 am
Forum: Water Cooler
Topic: Misinformation in a review
Replies: 2
Views: 4987

Misinformation in a review

There seems to be some misinformation about the necessity for Activesync on your machine before installing Planmaker in this review: http://spreadsheet-software-review.toptenreviews.com/planmaker-review.html I think this requirement is only for window mobile versions of Planmaker? (EDIT: Actually ha...
by LanceGary
Sun Mar 14, 2010 4:44 pm
Forum: Water Cooler
Topic: Pi Day
Replies: 0
Views: 4788

Pi Day

see http://en.wikipedia.org/wiki/Pi_Day Quote: "Pi Day and Pi Approximation Day are two holidays held to celebrate the mathematical constant ? (pi) (in the mm/dd date notation: 3/14); since 3, 1 and 4 are the first three digits of ?. March 14 is also the birthday of Albert Einstein and the two event...

Go to advanced search