Tuesday, 27 November 2018

quick method to add error bars and standard deviations to excel graphs

new excel (since 2013?) has an easily accessible button at the top-right of a chart that allows you to quickly add std error/deviation.


standard deviation excel graphs2


source: https://www.pryor.com/blog/add-error-bars-and-standard-deviations-to-excel-graphs/

shaded error bars in excel

summary: specify the upper/lower bounds using the error of your choice, plot those along with the primary data, then use transparency for the top bound to get the color effect and white-fill to remove what's below the bottom bound.

one comment to add to the below source is that depending on the order your data is loaded into the plot, you may need to switch up the order of the data series to obtain the correct appearance. however, top > data > bottom always in the order.


example:
before_and_after_error_bands.png


source: https://nikkimarinsek.com/blog/tutorial-how-to-make-shaded-error-bands-in-excel

radar/spider charts in excel


In Excel 2013, click Insert > Insert Stock, Surface or Radar Chart > Radar.


example:
doc-radar-chart-4


source: https://www.extendoffice.com/documents/excel/2135-excel-create-radar-chart.html

transparency of features within a part - reversing back to non-transparent


shift + left click to select
shift + right click to bring up option menu.

(might differ depending on keyboard mappings since the thread says tab+click)


source: https://forum.solidworks.com/thread/52713

Checking amazon spending history totals


Download entire order history (or specified dates) as excel file and calculate.

https://www.amazon.com/gp/b2b/reports

source: https://clark.com/shopping-retail/online-shopping/amazon-spending-history-total/

Friday, 2 November 2018

MD5 file extension

Files that contain the .md5 file extension are checksum files that are used to ensure that the data within a file is complete and has not become corrupt. An MD5 file verifies the integrity of downloaded files, discs and disk images.
source: https://file.org/extension/md5

Saturday, 8 September 2018

Mac - OS version from command line

system_profiler SPSoftwareDataType

OR

sw_vers

There are others but I found these two to be the most informative.

source: https://coderwall.com/p/4yz8dq/determine-os-x-version-from-the-command-line

ASUS laptop - keyboard backlight

use physical keyboard shortcuts rather than digital keyboard settings.


source: https://rog.asus.com/forum/showthread.php?1106-Can-t-seem-to-turn-on-keyboard-backlight-on-G53

Friday, 17 August 2018

Recover old events in google calendar (within 30 days)

as of 2018:
--> gear icon --> trash --> [select calendar]

source: https://productforums.google.com/forum/#!topic/calendar/MtNndu_xd2E

Hide completed tasks in Asana/Instagantt

--> show incomplete

source: https://community.asana.com/t/completed-tasks-just-fading-instead-of-disappearing/3420

Tuesday, 14 August 2018

Python pip package RequestsDependencyWarning - cryptography

Error:
 /usr/local/lib/python2.7/dist-packages/requests/__init__.py:83: RequestsDependencyWarning: Old version of cryptography ([1, 2, 3]) may cause slowdown.
Solution:
sudo pip install --upgrade cryptography
sudo python -m easy_install --upgrade pyOpenSSL



source: https://stackoverflow.com/questions/51283708/python-pip-package-requestsdependencywarning-when-installing-elastic-search-cura

Monday, 13 August 2018

Recover unsaved files in Sublime Text

Open %APPDATA%\Sublime Text 3\Local in a folder and open the Session.sublime_session file in a text editor. If you're lucky, extract the save data without additional hassle (may need to reformat).


source: https://forum.sublimetext.com/t/how-to-recover-lost-unsaved-files/18673

Sunday, 8 July 2018

Driver Installation Issue with BeagleBone Black (generalizable to any failures of installation of unsigned drivers)

Installation of Windows 10 Bone_D64.exe was failing.

Reason turned out to be:
Microsoft OS no longer allows direct installation of unsigned drivers to reduce access by malware. (there might be more to this...)


Solution:
> Updating the BIOS did not work for me, but installing RNDIS drive worked
> with the following instructions (found somewhere else that I cannot find
> now)
>
> device manager
> Under other devices choose RNDIS
> right click on it and update driver
> Browse my computer
> let me pick
> "Network adapters"
> select microsoft from on the left
> choose "USB RNDIS"
> Click next
> click yes
> then close
> DONE!!! YEAH !!!

source: https://groups.google.com/forum/#!category-topic/beagleboard/usb/-gczCwKR2Rk

Monday, 2 July 2018

Fixing when a file exceeds github's file size limit of 100 mb

git filter-branch --index-filter 'git rm --cached --ignore-unmatch [file]' merge-point..HEAD




source: http://www.thisprogrammingthing.com/2013/fixing-the-this-exceeds-githubs-file-size-limit-of-100-mb-error/

Saturday, 30 June 2018

changing the last commit message without committing newest changes

git commit --amend -m 'Your new message.'

source: https://stackoverflow.com/questions/11286362/changing-the-last-commit-message-without-committing-newest-changes

Monday, 28 May 2018

Git: .lock error while pushing [to origin]

My solution was re-creating the index (while keeping the worktree intact):
del .git\index
git reset --mixed head

source: https://stackoverflow.com/questions/13635429/git-rename-from-index-lock-to-index-failed

Host-Only Networking with VirtualBox


Adding a NAT Adapter

This will allow the guest system to access the broader internet through your host’s connection. You’ll be able to download packages, check email; whatever. Nobody outside sees anything of your guest system; as far as they’re concerned, it doesn’t exist. However, you cannot access any guest resources from your host machine, nor can any guest machines access each other. Yet.

source: http://christophermaier.name/2010/09/01/host-only-networking-with-virtualbox/

Tuesday, 15 May 2018

Debugging Samsung S8

various tips on restarting and booting in safe mode.

source: https://thedroidguy.com/2018/04/fix-samsung-galaxy-s8-wont-charge-troubleshooting-guide-1072340

Tuesday, 8 May 2018

Changing default font/spacing/etc in Microsoft Word

make changes to a document, apply changes to all (Normal.dotm) by setting as default.


source: https://www.cedarville.edu/help/Word-Change-Default-Line-Spacing

Wednesday, 4 April 2018

Powerpoint - multiple, simultaneous, automatic videos

Open up the animation pane and clear all other triggers/actions (source: https://support.office.com/en-us/article/change-the-playing-order-of-your-animation-effects-f41984c7-c5a6-4120-af1e-5208cf4295b4).

Select all videos on the slide that you want to play simultaneously. In the Animations tab, hit play. Right click on any of the selected videos and change to start 'Automatically'.

related: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_powerpoint-mso_other-mso_2010/powerpoint-how-can-i-automatically-play-two-video/eb19132f-2f49-48ae-94f6-59c1be8460b2

Tuesday, 3 April 2018

SolidWorks - customize keyboard shortcuts

To customize shortcut keys:
  1. With a document open, click Tools > Customize, or right-click in the window border and select Customize.
  2. Select the Keyboard tab.


source: http://help.solidworks.com/2017/english/solidworks/sldworks/hidd_customize_keyboard.htm

SolidWorks - disable resource monitor notification

Access the Windows Notifications Settings
To quickly access Windows Notification settings you can enter ‘Notification‘ into the search box next to the Windows icon on the left of the task bar (if the Search Box is missing right-click on the task bar and select Cortana > Search Box).

Then select Notifications & action settings from best match list:

Choose which SOLIDWORKS Resource Monitor Notifications to receive
In the notifications and actions dialog scroll in the list until you find the SOLIDWORKS Resource Monitor (if it’s not listed then you likely do not have SOLIDWORKS running , just start the application and it should appear).

Pick on the item to access it’s settings — or you can just turn them all off by moving the slider to off.

In the SOLIDWORKS Resource Monitor settings dialog you can then pick and choose which notifications you want to receive and how you want to receive them. For instance you still might want to receive all notifications but you can do so without a sound by turning play the sound to off:



source: https://www.javelin-tech.com/blog/2017/03/disable-solidworks-resource-monitor-notifications/

Deleting custom power plans

Click Start, and type power options.

Click Power Options.

Click Change Plan Settings under the plan you want to delete.

Click Delete This Plan and then OK.
Note: The Delete This Plan option only appears on plans you have created and that are not currently in use.

--> Can't delete the current plan that you're on.

source: http://www.dell.com/support/article/us/en/04/sln85974/changing-creating-or-deleting-my-power-plan-settings-in-microsoft-windows-vista-kb-article-316355?lang=en

Unpairing a bluetooth device

Some smaller bluetooth devices seem to support only one link at a time (i.e. bluetooth mouse).


Click the Bluetooth icon in the notification area and choose the command Show Bluetooth Devices.

Right-click a device in the window.

The device doesn’t need to be on to be unpaired. You’ll notice that the devices show up in the window regardless of whether they’re on.

Choose the command Remove or Remove Device.

Click the Yes button in the Remove Device dialog box.

If prompted, type the administrator’s password or click the Continue button.


source: http://www.dummies.com/computers/pcs/how-to-unpair-a-bluetooth-device-on-your-windows-network/

Friday, 23 February 2018

git fatal: HttpRequestException encountered in cygwin

fatal: HttpRequestException encountered.
   An error occurred while sending the request.
bash: /dev/tty: No such device or address
error: failed to execute prompt script (exit code 1)
fatal: could not read Username for 'https://github.com': No error

^While using git in cygwin.

Solution: Use powershell or command prompt instead.

source: https://github.com/atom/atom/issues/8984