No Clocks

googlesheets4

:heavy_check_mark::interrobang: Validate JSON. Contribute to ropensci/jsonvalidate development by creating an account on GitHub.

Without the knowledge, it can be challenging to write queries that retrieve the data you need in the format you need. An Excel and ...

Professional data validation for the R environment - data-cleaning/validate

Check out this recent interview with Sebastian Dewhurst, Director of Business Development, EASA speaks about Transforming Excel Spreadsheets into Enterprise Applications.

Data validation and organization of metadata for data frames and database tables - rich-iannone/pointblank

Fully illustrated Excel tutorial + 300 examples. 100% free.

R package to store and retrieve objects from disk in a git-friendly format. - antoine-sachet/cacheR

JKP Application Development Services, World-class Excel Application Development

HTTP query cache for R. Contribute to nealrichardson/httpcache development by creating an account on GitHub.

ASAP Utilities is a friendly Excel add-in that saves our users a lot of valuable time. It contains many well-thought-out and useful tools that make working in Excel much easier and faster. Since 1999 it has grown to become probably one of the world's most popular add-ins for Excel.

Learn Excel like a pro with easy-to-follow tutorials, step-by-step videos and free workbooks. Learn formulas, pivot tables, data validation, filters and more!.

manage cached files. Contribute to ropensci/hoardr development by creating an account on GitHub.

Contribute to DataCurationNetwork/data-primers development by creating an account on GitHub.

Key-value caches for R. Contribute to r-lib/cachem development by creating an account on GitHub.

In this tip we look at an easy way to build DDL for SQL Server tables using an Excel template to generate the T-SQL for the table structure.

Cache CRAN-like metadata and package files. Contribute to r-lib/pkgcache development by creating an account on GitHub.

Excel is a mighty powerful application, and yet, there are any number of utilities available to extend its capabilities. I’m sure everyone has their favorites, and here I’m going to talk about mine. My reliance on these utilities is as a developer of Excel applications, that is, solutions that combine add-ins, templates, and regular workbook […]

jkp-ads.com: A user- and maintenance-friendly Excel spreadsheet template

An R caching layer. Contribute to robertzk/cachemeifyoucan development by creating an account on GitHub.

A thorough overview of what you can do with external data: import and refresh, shape it with Power Query, secure it, define connections and properties.

Simplified R caching for reproducible big data projects - databio/simpleCache

iⁿ methodology for testing spreadsheets, conclusion

:recycle: R package: R.cache - Fast and Light-weight Caching (Memoization) of Objects and Results to Speed Up Computations - HenrikBengtsson/R.cache

If you want access the newest Microsoft Office features, you can download the Insider version. This version of Microsoft Office acts as the first public testing grounds for all of the fresh features that have been cooked up over in Redmond. Learn how you can get setup with the Insider Version of Off

A set of tools for datasets and plots archiving. Contribute to pbiecek/archivist development by creating an account on GitHub.

Many companies are still managed with Excel spreadsheets. This can result in catastrophic miscalculations. It's time to learn about some alternatives.

Parallel Processing in R using a Thread Pool. Contribute to rdpeng/threadpool development by creating an account on GitHub.

Excel is great, but trying to figure it out how to use Excel on your own can get you only so far because it isn’t intuitive. But if you use the techniques and tips in this tutorial, you’ll be able...

Explore the concept of Data Analytics with R, Tableau and Excel. Also, understand the features, applications and working of these tools.