Links for the Week of 2021-08-15
Here are some links I covered in the past week.
Table of Contents
- Table of Contents
- General
- Important Dental Metrics/KPI
- HTML
- Membership Websites
- Automating R Scripts and Github Actions
- A Few Javascript Bookmarklets to Add to Apple Safari on iOS
- RDrop2 package
- Eaglesoft
- Google Sheets to Google Calendar
- DeepSpeech
General
ADVFN
Free site for stock, crypto and other data.
Stock Analysis and Forecasting
tags: package
How to use various news APIs, sentiment analysis and time series forecasting to analyze stock data.Makes use of the prophet package that connects the prophet Facebook API for forecasting. Link - DB.
How to get at the database schema of a hidden DB? - Stack Overflow
This is a great question about how to access an Eaglesoft database.
How I Attracted 1,000+ New Patients in Less Than 3 Years Using Instagram with Dr. Brian Baliwas - Thriving Dentist with Gary Takacs
R function to read in all sheets from Excel Files
Custom function that uses the readxl package to loop through all of the sheets in and xls or xlsx file and returns them as a tibble or a data.frame.
library(readxl)
read_excel_allsheets <- function(filename, tibble = FALSE) {
# I prefer straight data.frames
# but if you like tidyverse tibbles (the default with read_excel)
# then just pass tibble = TRUE
sheets <- readxl::excel_sheets(filename)
x <- lapply(sheets, function(X) readxl::read_excel(filename, sheet = X))
if(!tibble) x <- lapply(x, as.data.frame)
names(x) <- sheets
x
}
Gusto API
Documentation on how to link to the Gusto payroll API.
Getting Data from the Web with R - Part 6: HTTP Basics and the RCurl Package
Important Dental Metrics/KPI
Clinical Metrics
- Active Patients - patients seen within last 24 months
- Active Hygiene - active patients with recall in the next 6 months.
Schedule Metrics
- Average hourly production - production divided by hours worked
- Production per procedure - production divided by total number of procedures
- Unfilled hours - total hours unscheduled divided by total available hours
- Scheduled hours - total hours unscheduled divided by total available hours
- Number of broken appointments not reappointed
- Production lost from broken appointments
Financial Metrics
- Production -
- By Doctor
- By Hygiene
Employee Metrics
- Production Ratios
- Per Employee - total production divided by # of employees per period
- Per Hours Worked - total production divided by # of hours worked per period
- Per Hygienist - total production divided by hygienist divied by no of hygienists per period
- Hours
- Total Hours
- Total Hours by Department
- Hours Per Employee
- Total Hours
- Compensation
- Gross Earnings - total compensation, including base wages,
- Total - sum of gross earnings for all employees
- Per Employee
- Per Department
- Average Gross Earnings Per Employee
- Average Gross Earnings Per Department
- Total - sum of gross earnings for all employees
- Gross Earnings - total compensation, including base wages,
Master the Metrics that Matter
HTML
Tool that displays outline of HTML5 documents - Software Recommendations Stack Exchange
Covers how to get a broad outline of a HTML5 page. Recommends the following tools:
- GitHub - hoyois/html5outliner: A Javascript implementation of the HTML outline algorithm
- Ready to check - Nu Html Checker with instructions on how to implement the tool locally. From the article The Nu Html Checker (v.Nu):
You can have it downloaded and run within minutes (if not seconds) with just two commands:
wget https://sideshowbarker.net/releases/jar/vnu.jar
java -cp ./vnu.jar nu.validator.servlet.Main 8888
Then open http://localhost:8888/ in your browser and you’ll have a form you can use for either checking documents by specifying their URLs or by file upload. To get an outline for a document, just check the outline checkbox in that form.
- A Chrome extension called HTML5 Outliner
Membership Websites
MemberSpace - Turn any part of your website into members-only with just a few clicks
13 Best Membership Website Builders and Platforms in 2021
Slightly skewed reviews of membership hosing sites.
Automating R Scripts and Github Actions
Running R Scripts on a Schedule with GitHub Actions - Simon Couch
Killer article on how to automate running an R script using Github Actions.
A Few Javascript Bookmarklets to Add to Apple Safari on iOS
I do a lot of research and writing on my iPhone. That means that I frequently need tools that aren’t readily available on iOS. Sometimes apps can stand in to do the work. Sometimes you need a little extra help.
Here is a good overview of how iOS bookmarklets work and how to install them or a list of useful ones to get you started.
PDF Pretty bookmarklet
Sometimes webpages don’t save well as PDFs (looking at you, Medium) and this gives a quick way to print to PDF in a “pretty” manner.
javascript:(function(){if(window['priFri']){window.print()}else{pfstyle='nbk';pfBkVersion='1';_pnicer_script=document.createElement('SCRIPT');_pnicer_script.type='text/javascript';_pnicer_script.src='//cdn.printfriendly.com/printfriendly.js';document.getElementsByTagName('head')[0].appendChild(_pnicer_script);}})();
View Page Source bookmarklet
I can’t recall where I found this one but it works fairly seamlessly - view the html code of any site you are browsing.
javascript:(function()%7Bvar%20a=window.open('about:blank').document;a.write('%3C!DOCTYPE%20html%3E%3Chtml%3E%3Chead%3E%3Ctitle%3ESource%20of%20'+location.href+'%3C/title%3E%3Cmeta%20name=%22viewport%22%20content=%22width=device-width%22%20/%3E%3C/head%3E%3Cbody%3E%3C/body%3E%3C/html%3E');a.close();var%20b=a.body.appendChild(a.createElement('pre'));b.style.overflow='auto';b.style.whiteSpace='pre-wrap';b.appendChild(a.createTextNode(document.documentElement.innerHTML))%7D)();
List all Links
javascript:(function(){var a=;for(var ln=0;ln<document.links.length;ln++){var lk=document.links[ln];a+=ln+': <a href=\+lk+'\' title=\+lk.text+'\'>'+lk+'</a><br>\n';}w=window.open(,'Links','scrollbars,resizable,width=400,height=600');w.document.write(a);}()
RDrop2 package
More to come on this one but this is a great R interface to Dropbox.