Latest posts of: AEngineer -
Welcome Guest.   Make a donation to an author on the site July 01, 2015, 12:01:12 PM  *

Please login or register.
Or did you miss your validation email?

Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.

You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
Check out and download the GOE 2007 Freeware Challenge productivity tools.
  Forum Home Thread Marks Chat! Downloads Search Login Register  
  Show Posts
      View this member's profile 
      donate to someone Donate to this member 
Pages: [1] 2 Next
1  Other Software / Announce Your Software/Service/Product / Re: MasterSeeker 1.2 - Incredibly Fast File Search Engine! on: May 28, 2013, 05:12:06 AM
Tried it this morning after reading the above descriptions.  It is indeed a fine interface.  In particular I like the simple filtering tools you've built in that make narrowing easy and fast.  I've replace Search Everything with MasterSeeker thanks to the interface/capabilities.

A welcome addition would be the ability to export the found set to a text file so that one can work with the results.  I'd have a toggle between full path and file/folder name only.
2  Other Software / Announce Your Software/Service/Product / Re: Buzz Folders - Open/Save Dialog Box Extender ( + Free Version ) on: July 14, 2010, 08:07:33 AM
I was going to give the free version a try, but Web of Trust gave the site a bad (2/5) rating, with comments indicating malware.  Does anyone have information?
3  Main Area and Open Discussion / General Software Discussion / Re: Simple CRM and biz management tool for a small business? on: April 01, 2010, 08:12:38 PM
I suggest that you take a look at an online solution.  I serve on the board of a small nonprofit and did a search for them to address what sounds like similar problems.  I was quite impressed with Zoho's CRM solution.  They haven't yet chosen to put it into play so I cannot testify to how well it works in practice, but my test drive (free) impressed me.  It's free for three users and $12/user/month above that:  ZohoCRM Pricing.
4  Special User Sections / N.A.N.Y. 2010 / Re: NANY 2010 Release: Anuran on: February 06, 2010, 02:54:09 PM
Ummm.  I guess I saw it and didn't register.  Thanks for informing me!  Wink
5  Special User Sections / N.A.N.Y. 2010 / Re: NANY 2010 Release: Anuran on: February 06, 2010, 01:00:12 PM
More on converting to Excel Timestamp.
I found, somewhat to my embarrassment, that AM/PM and the fact that noon is labeled as 12:00PM not 00:00 PM exported info fouled up my prior Excel timestamp.  The following does work (I know it's ugly, but it's necessary), assuming that the exported timestamp is in A4. 

=DATE(LEFT(A4,4),MID(A4,6,2),MID(A4,9,2))+ TIME( IF( AND(RIGHT(A4,2)="PM",VALUE(MID(A4,14,2))<12),MID(A4,14,2)+12,MID(A4,14,2) ),  MID(A4,17,2),MID(A4,20,2))

It would be MUCH cleaner to export the time in military (24 hour) units.
6  Special User Sections / N.A.N.Y. 2010 / Re: NANY 2010 Release: Anuran on: January 31, 2010, 04:39:11 PM
Suggestion for others who want to import this to a database.  I'm adopting a convention that I'll put my "category" at the beginning followed by a "-"  That way I can easily parse the category in Excel.

Soccer - Watch Arsenal go down to Manu   mad
7  Special User Sections / N.A.N.Y. 2010 / Re: NANY 2010 Release: Anuran on: January 31, 2010, 06:44:20 AM
What a great use of a Saturday night (for me)!
Yes, it works splendidly. 

For documentation purposes here's the formula that produces a timestamp, assuming that the date output field is in A1

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+ TIME(MID(A1,14,2),MID(A1,17,2),MID(A1,20,2))

Many thanks indeed.
8  Special User Sections / N.A.N.Y. 2010 / Re: NANY 2010 Release: Anuran on: January 30, 2010, 09:07:13 PM
No line breaks please, one line per record
I think a header line would be nice although my memory is that most csv and tab outputs don't have one.

You're amazing - it's Saturday night and you should be out carousing.
9  Special User Sections / N.A.N.Y. 2010 / Re: NANY 2010 Release: Anuran on: January 30, 2010, 08:30:33 PM
You might have to help some people with the documentation on how to make the conversion. 

If you can provide an output in CSV or Tab form that gives:
Year (4 digit)

then it's easy to use the Date & Time formulas to create the timestamp in Excel.
10  Special User Sections / N.A.N.Y. 2010 / Re: NANY 2010 Release: Anuran on: January 30, 2010, 04:25:44 PM
Thanks for the quick response and willingness to try and push it further.

The date stamp algorithim in Excel is the days since January 1st, 1900 + Military Hours/24

e.g.  40198.5291666667  is 1/20/2010  12:42:00 PM
11  Special User Sections / N.A.N.Y. 2010 / Re: NANY 2010 Release: Anuran on: January 30, 2010, 08:40:18 AM
Like most here I was most impressed by what I saw, but won't be using it till I have the ability to export readily in either CSV or Tab format, ready for analysis in a spreadsheet or DB.  My quick review didn't show those capabilities - apologies if I missed them.  My suggestions specifically:
- Export option in CSV and/or Tab format - single line to allow importing each record
- Timestamp output option compatible with spreadsheet (Excel) import

Enhancements I'd love, but not as important
- A project field - with pull-down and ready editing - with default persistence of last project

12 Software / DcUpdater / Re: Dcuppdater.exe crashes multiple times daily in W7... on: December 09, 2009, 09:09:57 AM
I just discovered the same problem on my W7 machine.  It works if I start it individually and then use it, but I'm getting the same multiple crash warning that forces my "reliability" index to 1.
13 Software / Find And Run Robot / Re: Runtime Error! on: November 22, 2008, 07:02:11 PM
I had the same problem and had to unininstall and reinstall to get it to work. 

It made me realize how much I depend on it.  Thanks again Mouser!
14 Software / Post New Requests Here / IDEA - Macro to Convert OneNote Output to Word Headings (Styles) on: November 14, 2008, 07:32:24 PM
I'm a devoted OneNote user and a Word (2007) user because both do outlines very well.  Unfortunately OneNote's outlines do NOT transfer to Word's outlines - a known issue that eventually the OneNote people plan to address.  In the meantime I'd love to have a way to convert OneNote output to Word headings (styles).

If one exports from OneNote to Word you get tab-indented text - one tab for each heading level.  There ought to be a way to write a word macro (I assume) to count the indents and convert them to a heading (which has a style).  That's what I need, but am not knowledgeable enough to create.

If this is the wrong place to suggest this I'd appreciate suggestions on where I should - in DC or elsewhere.  It matters enough that I'm willing to pay a small amount, though obviously I hope the challenge intrigues people enough to get it done without cash.
15  News and Reviews / Mini-Reviews by Members / Re: Direct Access - text expander and application launcher (and much more) on: August 31, 2008, 08:06:16 PM
Just a quick reminder of another free program (now apparently no longer developed according to posts elsewhere in DC) that does some of what's discussed here - PowerPro.  It's free and quite amazing in what it does.  I'd be vastly less productive in my day job without its easy-to-create-and-modify text macros.  And that's only a small portion of what it does.

e.g, the following code typed in any windows document pulls in a text file containing my ten-line email signature that I can update as things change. I have about a dozen of these that get used every day.
16  Other Software / Announce Your Software/Service/Product / Re: Year Calendar on a Single Page - Excel-2007 Template on: August 31, 2008, 07:29:01 PM

I'll write up a mini-review with pictures and explanation, but it seems like cheating to review your submission.  That's why I put it here.

Jim Mitchell
17  Other Software / Announce Your Software/Service/Product / Year Calendar on a Single Page - Excel-2007 Template on: August 30, 2008, 03:21:04 PM
David Seah produced a very nice Excel template that allows one to print out a year's worth of calendar on a single piece of paper that will fold to fit with 3x5 cards.  It's great for planning because it's continuous, not starting a new line for each month.
(Images of my version at the bottom of this post 9/1/2008)

I took that idea, with his blessing, and gussied it up to be more automatic and to allow the user to pick any start date.  It uses Excel-2007 conditional formatting so wouldn't work very well with Excel-2003.

Here's a link to my blog where I posted it.

There's no money involved, I just got a kick out of generalizing it.  I hope it's useful to others.

Jim Mitchell

9/1/2008 At the request of others I've added the following information and pictures of how the end product and the data entry portion of the sheet look - there's also a sheet of instructions.

What I did:
David Seah's version had to be manually updated whenever you changed the starting date of the calendar, picked a different starting day of the week, or decided to insert a holiday.

Month Labels:
If the end of the week is in a different month than the prior week then display the month for that line.
To get the banner effect I had to develop conditional formatting.  Since this was the first time I used it the "rules" that I used are a bit clunky, but they work.

Start of Year:

Make it a single named entry that is used in the first cell of the calendar.  All the other cells flow from that one (and did in David's).

Make a lookup based on the week of the year calculated as a simple  sequence starting on the first week of the calendar (the lookup is hidden in a grouped column).  This got a bit tricky because I had to write some logic to ensure that a holiday falling on a row that displayed the month name shows up in the next line.  To make this work I decided to sacrifice David's ISO calendar week numbering scheme.
It could produce problems if someone puts holidays in succeeding rows starting with a month name - otherwise it's fine.

Column Formatting

This is set to be formatted with conditional formatting using the "Weekday" function looking for either Saturday or Sunday.  This makes them move in the display depending on which day of the week you use to start the calendar.

I protected the sheets so that users couldn't inadvertently put entries in the wrong place.  There's no password so anybody who wants to modify the sheet can do so with no problems = opensource(?).

Hope this helps.
18  Main Area and Open Discussion / Living Room / Re: How to achieve High Resolution for Text Reading on: August 30, 2008, 01:36:59 PM
Thanks for the feedback.

It might be worth it to us to replace a display with one optimized for text.  Does anyone have any specific recommendations?

It also seems to me that the inherent "pitch" (I think it's the right term) is critical.  The Kindle just has a much higher pitch and thus produces better resolution, albeit in grey-only scale.  Any comments on that would be appreciated too.
19  Main Area and Open Discussion / General Software Discussion / Energy Saving Setup for XP on: August 15, 2008, 01:18:18 PM
I leave my home machine on 24x7 (monitors off when not using) because I have it set to do several automatic backup tasks (net and local) in the middle of the night and because it's often still syncing files (Foldershare) when I head to bed. 

I'd love to be able to tell it to go into hibernation (ideal) or sleep when I head to bed after it's finished the syncing, but wake up in order to perform the backup tasks, going back to the energy conserving state afterward.

Is anybody aware of a way to achieve this?  I suppose the criteria would be:
- Wake on local demand - when I sit down at the keyboard
- Go to energy saving mode after identified tasks have gone to 0 activity for x minutes
- Wake at scheduled time(s), and return to energy saving mode after identified tasks have completed.
- If in hibernation mode, go to sleep mode at a scheduled time so that the wait on physically arriving at the machine is minimized.

Machines I'm concerned with are all XP

PS - Feel free to move this to another forum if that's more appropriate.
20  Main Area and Open Discussion / Living Room / How to achieve High Resolution for Text Reading on: August 15, 2008, 01:05:15 PM
I've just been working with my wife on switching to digital for newspapers.  She finds that she cannot comfortably read on a regular computer screen (Philadelphia Inquirer on Lenovo V100 - Screen 1280 x 800), but is quite happy reading on my Kindle.  Both she and I believe that the difference is the increased pixels/inch on the Kindle (167 ppi, 4-level gray scale).  This leads to several questions.

1) Does anyone know of a monitor/card combination that we could use to achieve the same kind of flicker-free resolution with our desktop machine at a vaguely reasonable price?

2) Am I missing something in my analysis that might make it more palatable for her to use the laptop for reading?


Jim Mitchell
21  Main Area and Open Discussion / General Software Discussion / Re: Educators/Teachers software... on: June 15, 2008, 08:14:03 AM
Yes, the blog isn't working at the moment.  I switched webhosts and it broke in the process.  There isn't really anything of note there anyway - all the recommendations are in the site that still works.  I probably ought to go in and put a note about the blog.

If I got overwhelming requests to continue the blog I'd fix it.  smiley
22  Main Area and Open Discussion / General Software Discussion / Re: Educators/Teachers software... on: June 14, 2008, 10:17:05 AM
I created a site a while back with my recommendations for academics.  It has an associated blog on which I stopped updates because I wasn't receiving much feedback.  You might find some useful information on the site.  I did my best to categorize the tools and identify them in a variety of ways.

Let me know if it's useful and I might do some updates.

Jim Mitchell
23  News and Reviews / Mini-Reviews by Members / Re: ZohoDB - Online Free Relational Database on: May 21, 2008, 07:00:42 PM
Nice minireview AEngineer!
Google spreadsheets can be used as a primitive database for google maps (or something like that).

For me the big difference between Google spreadsheet and ZohoDB is that Zoho is truly relational if still somewhat limited.  So far as I'm aware GSS isn't.  I use it and love it for other purposes.
24  News and Reviews / Mini-Reviews by Members / ZohoDB - Online Free Relational Database on: May 19, 2008, 08:27:46 PM
Basic Info

App NameZoho DB & Reports
App Version ReviewedAs of 5/18/2008 - Constantly updated
Test System SpecsXP-SP3, on Dell P390 2GB RAM
Supported OSesWeb-Based
Support MethodsForum
Upgrade PolicyCurrently Free - They update online
Pricing SchemeCurrently Free - I'd expect a  "Pro" in future.
Relationship btwn. Reviewer and Product REVIEWER: I'm a simple user - no financial relationship


Who is this app designed for: Someone with minimal programming expertise who wishes to create a moderately complex relational database online - although an understanding of relational database tables is probably a good idea.

The Good
  • It works
  • Pretty easy to learn
  • Easy to embed what you create in your own web page via an iframe (they provide the code) or directly publish a particular view
  • Database can be shared in part of whole (though I haven't tried this)
  • Pretty good reports that allow summarizing and a crude form of grouping

The needs improvement section
  • Little control over format yet - the output is a spreadsheet in appearance with no obvious way to control column width, font, weight etc.
  • No auto-incrementing the key field in tables - it's up to you to ensure that you have a unique entry so far as I can tell
  • Sometimes slow to accept updates, though generally pretty responsive.
  • Help is not evident. You need to figure it out yourself. Presumably it's in the forums, but I didn't find much helpful there.
  • If you make relations between tables you must put an entry in every linking field or the record won't show up in a query - this one took me a while to figure out.

Why I think you should use this product
If you need to produce an updatable list for a small-scale website this is great - no worry about PHP, MySQL (and less control of course). I tested it by creating a six-table database of equipment that my academic department has for common use in the department. After stumbling a bit with the problem noted above on required entries in linking fields it all worked as I wanted. Total time to learn, setup and populate the tables (only about 20 pieces of equipment), create the website to embed the result was 3 hours - vastly better than an effort with PHP a year or two ago. Here's what the output looks like.

How does it compare to similar apps
I'm not aware of any similar web-based apps that are free with similar functionality, though I'm sure Google is working on one. The closest approximations in the desktop world are Access, FileMaker and OpenOffice Base. All offer far more control and features for the single user, but they don't allow easy creation of a web page. Here are some others that I believe are less capable either because their not as fully relational or because the fees kick in very quickly.

  • - I took a quick look at this by creating a test DB. It doesn't seem to offer as much user control. It's more aimed at a rating system for restaurants, books etc.
  • (Intuit) - This one has been around a long time and is clearly very capable. The problem is that the minimum appears to be $250/month - not for me.

As I've emphasized throughout, the beauty of this app is that it's web-based and thus able to be readily shared and published. It's nowhere near as finished as even OpenOffice Base, but it sits cleanly in it's own niche and can be very helpful in a rapid manner.

Links to other reviews of this application
I'm sure that there must be some, but I couldn't find any devoted to the database portion of the much larger Zoho suite . It's fairly new.

25  Main Area and Open Discussion / General Software Discussion / Re: Drafting/Architectural Software? on: April 26, 2008, 06:50:44 AM
I'm an ancient autocad user who agrees that the shift to Revit (almost $8K list I believe) is inevitable in the professional world.

For simple 2D work there are actually some good alternatives - though without the double-wall capabilities etc.
QCad - very low cost, limited compared to ACad
OpenOffice Draw - quite capable indeed though not really aimed at the building world - free
Pages: [1] 2 Next | About Us Forum | Powered by SMF
[ Page time: 0.044s | Server load: 0.14 ]

Share on Facebook
submit to reddit