Automatic Rent Reminder using esp8266

LoRa Automation to Control Relays

SQL Server Table Editor / Management Tool | Visual Studio

water detection system using arduino and blynk IoT (advanced) connected ...

Extract text from PDF(OCR/Image) File using Python / Voter data extraction

Billing / Invoice Automation using Google Sheets

Billing / Invoice Automation using Google Sheets

 

⭐️⭐️GITHUB

https://github.com/deepaklohia/google-sheets-billing-automation

 

⭐️GOOGLE SHEET SAMPLE

https://docs.google.com/spreadsheets/d/e/2PACX-1vSxUi1KfkWOINQlqagJX1ZFZy5FMFmMwxItVXuuHHZw8TpyvhFUxNY8KrDnd9yHMJ1r2Zjr-GWP1E8b/pubhtml

 

➡️ Google Sheets Fully Functional  Free Add-ons

 

⭐️Google Sheets Attendance Tracker

https://workspace.google.com/marketplace/app/attendance_tracker/602607637436

 

⭐️Google Sheets Time Tracker

https://workspace.google.com/marketplace/app/time_tracker/182790105381

 

⭐️Google Sheets Combine Sheets

https://workspace.google.com/marketplace/app/combine_sheets/405522851504

 

⭐️Google Sheets TimeJet

https://workspace.google.com/marketplace/app/timejet/531257058624

 

➡️OTHER USEFUL VBA AUTOMATIONS

 

how to extract notepad data in excel | VBA Automation

https://youtu.be/xHr7WXjK4dc

 

how to get Developer tab in MS Excel

https://youtu.be/DKj2YqcP9cA

 

How to run any exe file using VBA

https://www.youtube.com/watch?v=WCFLHf0QbE8

 

Excel macro to convert pdf to excel

https://www.youtube.com/watch?v=jeJR_v6TZOQ

 

Attendance tracker (custom ribbon)

https://www.youtube.com/watch?v=AU5lbtVVL4M

 

file inner text / content replacer - find and replace text

https://youtu.be/Cqi4xtJdOso

 

Excel Macro to convert pdf to Excel

https://youtu.be/jeJR_v6TZOQ

 

how to merge excel files

https://www.youtube.com/watch?v=AB9dJ_0bwo4

 

how to track time and motion

https://youtu.be/sBknyAEBPMU

 

send birthday greeting automatically

https://youtu.be/1jFJ35ZPR_A

 

connect excel to word  / create  letters in word automatically

https://youtu.be/ZgZHY4mOOvY

 

automated sop / workflow designer

https://youtu.be/7aNVmmYneZQ

 

Send bulk emails in outlook

https://www.youtube.com/watch?v=tDIOenSdN80

 

extract outlook attachments

https://www.youtube.com/watch?v=Wq83KruKUyk

 

Outlook email extractor VSTO Plugin

https://youtu.be/jg3EWdvjPS0

 

how to remove password from MS Access database permanently

https://youtu.be/Zc87eBV3Maw

 

Similarity finder / Advanced lookup

https://youtu.be/1Mcchh1rBjU

 

Excel to notepad

https://youtu.be/wlO5TyC1x00

 

bulk legal letter generator

https://www.youtube.com/watch?v=7-iv3L-lvBY

 

simple attendance tool

https://youtu.be/AU5lbtVVL4M

 

Excel randomizer for random records

https://youtu.be/4dLTVfTB3I0

 

Excel html editor

https://youtu.be/J76SpjwhMtA

 

email domain name remover

https://youtu.be/hqx5xP1Rc4o

 

 

google sheets, billing automation , customized billing, invoice , google app script , how to automate billing , invoice

Arduino Digital Clock

MS Excel Add-ins to Boost your Production | Free MS Excel Must Have Add-ins

Play any Scale Without Learning Piano / Music Theory | कोई भी राग बजाए ब...

must have google sheets add-on

किसी भी पुरानी कार को बनाओ wifi कार | using Node Mcu

(9v battery is used. you may use upload 12v battery)

esp8266 Code

/* Fill-in information from Blynk Device Info here */

#define BLYNK_TEMPLATE_ID "template id"

#define BLYNK_TEMPLATE_NAME "Template name"

#define BLYNK_AUTH_TOKEN "pasteHere"

#define BLYNK_FIRMWARE_VERSION "0.0.1"

/* Comment this out to disable prints and save space */

#define BLYNK_PRINT Serial

/* WIFI INFO*******************************************/

const char ssid[] = "wifi name" ;

const char pass[] = "password" ;

const int PIN_IN1 = 5; //D1

const int PIN_IN2 = 4; //D2

const int PIN_IN3 = 14; //D5

const int PIN_IN4 = 12; //D6

/*

D1 5

D2 4

D3 0

D4 2

D5 14

D6 12

D7 13

D8 15

*/

#include <ESP8266WiFi.h>

#include <BlynkSimpleEsp8266.h>

BLYNK_WRITE(V1){

Serial.println("move front");

int value = param.asInt();

if(param.asInt() == 1){ digitalWrite(PIN_IN1, HIGH); digitalWrite(PIN_IN3, HIGH);

}else{ digitalWrite(PIN_IN1, LOW); digitalWrite(PIN_IN3, LOW); }

Blynk.virtualWrite(V1, value);}

BLYNK_WRITE(V2){

Serial.println("move back");

int value = param.asInt();

if(param.asInt() == 1) {digitalWrite(PIN_IN2, HIGH); digitalWrite(PIN_IN4, HIGH);

} else { digitalWrite(PIN_IN2, LOW); digitalWrite(PIN_IN4, LOW); }

Blynk.virtualWrite(V2, value);

}

BLYNK_WRITE(V3){

Serial.println("move right");

int value = param.asInt();

if(param.asInt() == 1) { digitalWrite(PIN_IN2, HIGH);

}else { digitalWrite(PIN_IN2, LOW); }

Blynk.virtualWrite(V3, value);}

BLYNK_WRITE(V4){

Serial.println("move left");

int value = param.asInt();

if(param.asInt() == 1) { digitalWrite(PIN_IN4, HIGH);

} else { digitalWrite(PIN_IN4, LOW); }

Blynk.virtualWrite(V4, value);

}

// This function is called every time the device is connected to the Blynk.Cloud

BLYNK_CONNECTED(){

Blynk.syncVirtual(V1); // will cause BLYNK_WRITE(V0) to be executed

Blynk.syncVirtual(V2); // will cause BLYNK_WRITE(V0) to be executed

Blynk.syncVirtual(V3); // will cause BLYNK_WRITE(V0) to be executed

Blynk.syncVirtual(V4); // will cause BLYNK_WRITE(V0) to be executed

}

void setup()

{

Serial.begin(115200);

Blynk.begin(BLYNK_AUTH_TOKEN, ssid, pass);

pinMode(PIN_IN1, OUTPUT);

pinMode(PIN_IN2, OUTPUT);

pinMode(PIN_IN3, OUTPUT);

pinMode(PIN_IN4, OUTPUT);

/*off by default*/

digitalWrite(PIN_IN1, LOW);

digitalWrite(PIN_IN2, LOW);

digitalWrite(PIN_IN3, LOW);

digitalWrite(PIN_IN4, LOW);

//lastMilliSec = millis();

}

void loop()

{

Blynk.run();

}

Selenium VBA Error: Unable to download chrome driver for version 115

how to record macro / automate / script in MS office 365