All the expenses that were made should be entered in the google sheets "Ravi Transaction", "Soundri Transaction" & "Ravi Income"
I cannot just rely on the receipts entered. I could have missed a receipt or added a receipt twice. So, I need to reconcile the data from mint.
I cannot just rely on mint data. Maybe I made an expense outside, that wasn't captured in mint. So I have to reconcile both mint and manual receipts.
Do not use the mint and transaction combined data. Because, we are joining on store and amount. There will be duplicates. The only reason for reconciliation is to make sure that we have all the data in manual recipts section.
Use the manual transaction sheet to get expenses
Even though a sheet is shared, it must be published as csv. Otherwise the below strange error will be thrown
stop_for_content_type(req, expected = "application/atom+xml; charset=UTF-8")
``
## Create Test
```r
library(devtools)
# adds a template test file test-add.R in tests/testthat/ folder
#
devtools::use_test("add")
Important, dont add this in a file. If this is in a file, it keeps executing in loop filling up computer
library(covr)
cov <- package_coverage()
report(cov)
library(covr)
cov <- package_coverage()
report(cov, group="function")
devtools::use_vignette("my-vignette")
https://cran.r-project.org/web/packages/roxygen2/vignettes/rd.html
works from travis-ci, but not from local. Need to troubleshoot this later. But for now, we can use local coverage check
covr::codecov(token="uploadtoken")
The below command will take to google auth. Be sure to select only opendatalake account
source('~/rprojects/PersonalFinance/R/generate_tokens.R')
genToken()
> Sys.setenv(https_proxy = "https://abc123:password@proxy.com:8099")
> Sys.setenv(http_proxy = "http://abc123:password@proxy.com:8099"")
> rsconnect::setAccountInfo(name='app..', token='ABC239', secret='a+9den.c....')
> deployApp('R')
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.