Excel

Microsoft Excel related information contained within the article.

Is weekly timesheet entry at the bottom of your task list? I have tried many systems to enlighten this chore, from pen and paper to now online time tracking and reporting using #Python #API requests. This is an early version of a personal #KPI metrics based system, that I can extend to suit project specifics.

Online Time Tracking and Reporting with Python API

2020-04-09 in Engineering tagged API / Excel / pandas / python

This post is part 1 of a series of posts I intend to pen related to a personal engineering tracking workbook that I put together for each of my projects. I plan to keep the length short and manageable, as well as breaking it out for others to go to […]

Project Tracking Workbook | Part 1 Actions

2019-07-02 in Engineering tagged Excel / INDEX / MATCH / MID / RIGHT / SUBSTITUTE / TABLE / TRIM

Excel Table showing all the extracted data from the web — Have you ever wanted to extract information from a web page to use in a calculation, or as a reference for something else you may be working on? I have used similar functions in the past (pre Power Query days) to grab stock price information or Forex rates for personal finance […]

Engineering Data Extracted from the Web Using Power Query

2018-08-05 in Engineering tagged Excel / Function / Parameter / Power Query / Spreadsheet / Tutorial