✅ EZchecklist™ Your superpower for Perfect Days
Friday, February 21, 2020
Mobile device anomalies
Mobile devices can be used very effectively for all typical recording of data in your ProductName app, however Google sheets is limited in more advanced capabilities that are available on your laptop computers.
1. These notes apply to the iPhone (X), but are most likely to apply to other mobile devices as well.
2. Many options that are available on the Main Menu shown on computers are unavailable on mobile:
a. Tools option
b. Data option
c. Add-ons
d. View
e. Help
f. EZchecklist Viewing Options
3. Charts, graphs, etc have limited editing abilities.
4. Undo and Redo by shaking the device is unavailable, but these choices are prominently displayed at the top of the sheet with the backward arrow (Undo) and forward arrow (Redo).
5. Switching between tabs (from Checklist to Controls, for example) is unsupported.
Monday, February 17, 2020
Tech Notes, Advanced
Technical Notes for Advanced Users
The notes below are for developers and highly experienced users,
and not at all essential for most users.
Retain the formula in selected cells in Column C
If the last character in an activity description in column B is "-", this will cause the formula in the corresponding column C row to be retained when the new Column C is created each evening. Otherwise all contents of Column C cells will be reset to blank. Note that the Value of the cell in C is transferred to the new column C, but not the formula. This is useful in conjunction with the IMPORTRANGE function, see below.
Import values from Other Spreadsheets
Using the IMPORTRANGE function in a cell, it is easy to copy a value from another Google spreadsheet and paste it into EZchecklist. One use for this would be to import your Weight for today from a spreadsheet that is fed by IFTTT that picks up the most recent weight from your Withings scale. Another use for this function is to post a summary value the details of which are confidential. For example, you want to post total expenses from another sheet that is private, and that would include individual salaries which you want to keep undisclosed.
Score() - a scorekeeping function
and not at all essential for most users.
Retain the formula in selected cells in Column C
If the last character in an activity description in column B is "-", this will cause the formula in the corresponding column C row to be retained when the new Column C is created each evening. Otherwise all contents of Column C cells will be reset to blank. Note that the Value of the cell in C is transferred to the new column C, but not the formula. This is useful in conjunction with the IMPORTRANGE function, see below.
Import values from Other Spreadsheets
Using the IMPORTRANGE function in a cell, it is easy to copy a value from another Google spreadsheet and paste it into EZchecklist. One use for this would be to import your Weight for today from a spreadsheet that is fed by IFTTT that picks up the most recent weight from your Withings scale. Another use for this function is to post a summary value the details of which are confidential. For example, you want to post total expenses from another sheet that is private, and that would include individual salaries which you want to keep undisclosed.
Score() - a scorekeeping function
Notice there is a special function called score(C5:C37)
This is a function that looks at the contents in the named range of cells in column C
for the appearance of a drop-down selection that looks like this: (score=1)
for the appearance of a drop-down selection that looks like this: (score=1)
This tells the function to add 1 Standard Score Unit to the overall score for the day so far.
You can change the values of the scorekeeping by changing the
Drop-Down list under Data Validation.
Drop-Down list under Data Validation.
Automatic backups!
Have no fear of experimenting. There are multiple safety nets.
For starters, you have the Undo command (command-Z) to Undo the
last changes you made. And if that’s not good enough,
you have Google’s built-in archiving service.
For starters, you have the Undo command (command-Z) to Undo the
last changes you made. And if that’s not good enough,
you have Google’s built-in archiving service.
Click File - See revision history.
Drop-down lists
Data Validation (see menu item Data/Data Validation, laptop only)
can be used to make it easy to enter data accurately and quickly
without using the keyboard.
This makes using it on mobile devices especially quick and easy.
You can easily modify the list of allowable items by selecting the cell(s) you want to change,
and then click Data/Data Validation. Click here for help.
can be used to make it easy to enter data accurately and quickly
without using the keyboard.
This makes using it on mobile devices especially quick and easy.
You can easily modify the list of allowable items by selecting the cell(s) you want to change,
and then click Data/Data Validation. Click here for help.
Time considerations
Every day, at some point after midnight, the details of the day are saved
and a fresh checklist is created for the new day.
The default time for this is between midnight and 1PM, but this can be user defined.
and a fresh checklist is created for the new day.
The default time for this is between midnight and 1PM, but this can be user defined.
If your day usually extends a little later and you want to push back your End of Day,
see menu Tools, Script Editor, click the Clock (Current Project’s Triggers),
and finally, change the time.
see menu Tools, Script Editor, click the Clock (Current Project’s Triggers),
and finally, change the time.
Sharing your EZchecklist with one or more people.
Click the big blue Share button on the top right corner of your EZchecklist
and enter the email address of the person(s) you want to be able to View or Edit.
and enter the email address of the person(s) you want to be able to View or Edit.
Shortcuts Tab
The Shortcuts Tab
This tab provides links to directly access the various parts of the system.
You can return to the Shortcuts page at any time by clicking on the checkmark icon ✅
in the upper left of every page in the system.
in the upper left of every page in the system.
You may like to navigate with this traditional “menu” approach.
However is you prefer navigate to the tab level then scroll down to reach your destination,
then you may want to eliminate the Shortcuts tab: right-click on the Shortcuts tab,
then Delete, or Hide.
However is you prefer navigate to the tab level then scroll down to reach your destination,
then you may want to eliminate the Shortcuts tab: right-click on the Shortcuts tab,
then Delete, or Hide.
--------------------
Note:
Keyboard Shortcuts
There are many helpful Google keyboard shortcuts. See this help.
Sunday, February 16, 2020
Resources
The resources that were formative in creating EZchecklist:
A must-read story of how the Pilot’s checklist was invented,
and how simple checklists are saving countless lives and
hundreds of millions of dollars in hospitals.
This is a condensation of some major points in the author’s groundbreaking book:
The Checklist Manifesto: How to Get Things Right.
and how simple checklists are saving countless lives and
hundreds of millions of dollars in hospitals.
This is a condensation of some major points in the author’s groundbreaking book:
The Checklist Manifesto: How to Get Things Right.
2. Research on Effectiveness of Written Goals - by Dr. Gail Matthews
shows that people who wrote down their goals, shared this information with a friend,
and sent weekly updates to that friend were on average 33% more successful
in accomplishing their stated goals than those who merely formulated goals.
The study provides evidence for the effectiveness of three tools:
accountability, commitment, and writing.
Here’s more about research on goal setting.
shows that people who wrote down their goals, shared this information with a friend,
and sent weekly updates to that friend were on average 33% more successful
in accomplishing their stated goals than those who merely formulated goals.
The study provides evidence for the effectiveness of three tools:
accountability, commitment, and writing.
Here’s more about research on goal setting.
5. The Ten Timeless Principles of Managing a Young, Growing Business -
FREE high quality wall Poster, suitable for framing, to users of this software product.
Email mm@DBLM.com
FREE high quality wall Poster, suitable for framing, to users of this software product.
Email mm@DBLM.com
6. Research on The Science of Affirmations:
“Did I do my best…”
New Post
TOS/EULA
EULA=End User License Agreement
TOS=Terms of Service
To all friends who use my software:
It gives me great joy to create software that actually helps people.
Your enthusiastic support is my goal. You can help by asking for help.
Thank you for the opportunity to be of service.
Namaste,
Michael McCafferty
A word about Privacy and Security:
My promise is that all your information will be kept absolutely private and secure as humanly possible and you have to trust that we are good people here at DBLM.com, who, as you know is a real human being called Michael McCafferty, and he’s got a long history of being a stand up guy and you can rely on his word and experience.
Your data is never shared, sold, copied, whatever. I would consider that a betrayal of trust and you could sue us for damages and put us out of business forever. We won’t do that. It’s your responsibility to take steps to secure your data with multiple levels of passwords, two-factor identification, encryption, etc. We need to work together on this.
Privacy
The information in your personal copy of EZchecklist™ is completely confidential.
The only other person who may access your copy is your coach/advisor,
to help you customize your system.
The only other person who may access your copy is your coach/advisor,
to help you customize your system.
To share it with another person, click “Share” in the upper right corner
of your checklist system (not this document). Enter their email address in the box,
and select “Can View” (or possibly “Can Edit”) from the list, and then “Send”.
This will send an email notice to that person with a link to access your system.
of your checklist system (not this document). Enter their email address in the box,
and select “Can View” (or possibly “Can Edit”) from the list, and then “Send”.
This will send an email notice to that person with a link to access your system.
To remove someone from being able to view your information,
click “Share” and then the line under the box: “Shared with ….”.
This will bring up a list of those who can view/edit/comment.
To remove a person, just click the X at the right of their name. Poof. Gone.
click “Share” and then the line under the box: “Shared with ….”.
This will bring up a list of those who can view/edit/comment.
To remove a person, just click the X at the right of their name. Poof. Gone.
To use any Google product, such as this system is built upon,
you need to have a Google ID and password, so keep that information to yourself
to be sure that your information is private.
you need to have a Google ID and password, so keep that information to yourself
to be sure that your information is private.
Mutual Confidentiality Agreement
1. I, Michael McCafferty, agree to keep all your data and conversations,
emails, texts, etc. completely private, other than what you share publicly on the user blog,
and then it is only shared with other users, and only what you want to share.
emails, texts, etc. completely private, other than what you share publicly on the user blog,
and then it is only shared with other users, and only what you want to share.
2. By using EZchecklist™, you agree to keep this system completely private,
and that means Not showing it to anyone else, or sharing any links to checklists
or User Guide.
This product is in continuous development and leaks would be a bad thing.
and that means Not showing it to anyone else, or sharing any links to checklists
or User Guide.
This product is in continuous development and leaks would be a bad thing.
A word from the lawyers. (groan)
Please excuse the legaleze, but lawyers say you have to include this stuff even though nobody reads it. It says so much about everything and nothing and it’s guaranteed to be boring, but airtight, and there isn’t a blessed thing you can do about it except not use the software. This is typical of any End User License Agreement (EULA) that everyone has to agree to but they never read because, well, look at it...
Your access to and use of the Service is conditioned upon your acceptance of and compliance with these Terms.
Please read these Terms of Service (“Terms”, “Terms of Service”) carefully before using the EZchecklist™ software application (the “Service”) operated by DBLM.com (“us”, “we”, or “our”).
Your access to and use of the Service is conditioned upon your acceptance of and compliance with these Terms. These Terms apply to all visitors, users and others who wish to access or use the Service.
By accessing or using the Service you agree to be bound by these Terms. If you disagree with any part of the terms then you do not have permission to access the Service.
What personal information do we collect from the people that visit our blog, website or app?
When ordering or registering on our site, as appropriate, you may be asked to enter your name, email address or other details to help you with your experience.
Communications By creating an Account on our service, you agree to subscribe to newsletters, marketing or promotional materials and other information we may send. However, you may opt out of receiving any, or all, of these communications from us by following the unsubscribe link or instructions provided in any email we send.
Content Our Service allows you to post, link, store, share and otherwise make available certain information, text, graphics, videos, or other material (“Content”). You are responsible for the Content that you post on or through the Service, including its legality, reliability, and appropriateness.
By posting Content on or through the Service, You represent and warrant that: (i) the Content is yours (you own it) and/or you have the right to use it and the right to grant us the rights and license as provided in these Terms, and (ii) that the posting of your Content on or through the Service does not violate the privacy rights, publicity rights, copyrights, contract rights or any other rights of any person or entity. We reserve the right to terminate the account of anyone found to be infringing on a copyright.
You retain any and all of your rights to any Content you submit, post or display on or through the Service and you are responsible for protecting those rights. We take no responsibility and assume no liability for Content you or any third party posts on or through the Service.
You agree that this license includes the right for us to make your Content available to other users of the Service who are authorized by you and who may also use your Content subject to these Terms, EZChecklist ™ has the right but not the obligation to monitor and edit all Content provided by users.
In addition, Content found on or through this Service are the property of EZChecklist ™ or used with permission. You may not distribute, modify, transmit, reuse, download, repost, copy, or use said Content, whether in whole or in part, for commercial purposes or for personal gain, without express advance written permission from us.
Accounts When you create an account with us, you guarantee that you are above the age of 13, and that the information you provide us is accurate, complete, and current at all times. Inaccurate, incomplete, or obsolete information may result in the immediate termination of your account on the Service.
You are responsible for maintaining the confidentiality of your account and password, including but not limited to the restriction of access to your computer and/or account. You agree to accept responsibility for any and all activities or actions that occur under your account and/or password, whether your password is with our Service or a third-party service. You must notify us immediately upon becoming aware of any breach of security or unauthorized use of your account.
We reserve the right to refuse service, terminate accounts, remove or edit content in our sole discretion.
Disclaimers and Limitations of Liability Please read this section carefully since it limits the liability of EZChecklist ™ and its parents, subsidiaries, affiliates, related companies, officers, directors, employees, agents, representatives, partners, and licensors (collectively, the “ EZChecklist ™ Entities”). Each of the subsections below only applies up to the maximum extent permitted under applicable law. Some jurisdictions do not allow the disclaimer of implied warranties or the limitation of liability in contracts, and as a result the contents of this section may not apply to you. Nothing in this section is intended to limit any rights you may have which may not be lawfully limited.
The Services are Available “AS-IS” Your access to and use of the Services or any Content is at your own risk. You understand and agree that the Services is provided to you on an “AS IS” and “AS AVAILABLE” basis. Without limiting the foregoing, EZChecklist ™ ENTITIES DISCLAIM ALL WARRANTIES AND CONDITIONS, WHETHER EXPRESS OR IMPLIED, OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT.
EZChecklist ™ Entities make no warranty and disclaim all responsibility and liability for: (i) the completeness, accuracy, availability, timeliness, security or reliability of the Services or any Content; (ii) any harm to your computer system, loss of data, or other harm that results from your access to or use of the Services, or any Content; (iii) the deletion of, or the failure to store or to transmit, any Content and other communications maintained by the Services; (iv) whether the Services will meet your requirements or be available on an uninterrupted, secure, or error-free basis. No advice or information, whether oral or written, obtained from EZChecklist ™ Entities or through the Services, will create any warranty not expressly made herein.
Copyright The ownership to the EZChecklist ™ software, trademarks, and brand, rests with DBLM.com and Michael McCafferty. Any form of copying, sharing, selling, transferring, reverse engineering, gifting, whatever-ing, of the software requires written permission, without exception.
Links To Other Web Sites Our Service may contain links to third party web sites or services that are not owned or controlled by EZChecklist ™ .
EZChecklist ™ has no control over, and assumes no responsibility for the content, privacy policies, or practices of any third party web sites or services. We do not warrant the offerings of any of these entities/individuals or their websites.
You acknowledge and agree that EZChecklist ™ . shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with use of or reliance on any such content, goods or services available on or through any such third party web sites or services.
We strongly advise you to read the terms and conditions and privacy policies of any third party web sites or services that you visit.
Termination If you wish to terminate your account, you may simply discontinue using the Service. To remove your data, simply File/Move to trash, no notice need be given, no salesman will call. We wish you well.
We may terminate or suspend your account and bar access to the Service immediately, without prior notice or liability, under our sole discretion, for any reason whatsoever and without limitation, including but not limited to a breach of the Terms.
All provisions of the Terms which by their nature should survive termination shall survive termination, including, without limitation, ownership provisions, warranty disclaimers, indemnity and limitations of liability.
Governing Law These Terms shall be governed and construed in accordance with the laws of California, United States, without regard to its conflict of law provisions.
Our failure to enforce any right or provision of these Terms will not be considered a waiver of those rights. If any provision of these Terms is held to be invalid or unenforceable by a court, the remaining provisions of these Terms will remain in effect. These Terms constitute the entire agreement between us regarding our Service, and supersede and replace any prior agreements we might have had between us regarding the Service.
Changes We reserve the right, at our sole discretion, to modify or replace these Terms at any time. By continuing to access or use our Service after any revisions become effective, you agree to be bound by the revised terms. If you do not agree to the new terms, you are no longer authorized to use the Service. We tried to keep this easy.
Support
Welcome to the best support in the world!
Three ways to get fast support:
1. Email mm@DBLM.com
or
2. Text message to 858.342.6949
or
3. Book 1-1 time. Use this link to schedule a time convenient for you.
Quick Start
There are 3 steps to get started with EZchecklist:
2. Email mm@DBLM.com to get your copy. A link will be sent to you via email.
3. Click the link and begin! You'll know what to do because you read the User Guide first.
Saturday, February 15, 2020
Subscribe to:
Posts (Atom)