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.





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:



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:



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/

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