Jumat, 16 Februari 2024

signal gsm sim800l

ValueRSSI dBmCondition
2-109Marginal
3-107Marginal
4-105Marginal
5-103Marginal
6-101Marginal
7-99Marginal
8-97Marginal
9-95Marginal
10-93OK
11-91OK
12-89OK
13-87OK
14-85OK
15-83Good
16-81Good
17-79Good
18-77Good
19-75Good
20-73Excellent
21-71Excellent
22-69Excellent
23-67Excellent
24-65Excellent
25-63Excellent
26-61Excellent
27-59Excellent
28-57Excellent
29-55Excellent
30-53Excellent

 

Selasa, 07 November 2023

google spreadsheet dengan node red

 

node-red-contrib-google-sheets 1.1.2

nodered node to get, update, append, and clear google sheets.

npm install node-red-contrib-google-sheets

A basic node for reading and writing from/to google sheets.

Auth

To setup auth this node uses a google service account:

Create a new service account from This Page

Download a JSON credentials object for the service account.

Give that account access to the sheets API.

Share your sheet with the email address of the service account eg nodered@nodered-12345.iam.gserviceaccount.com

Sheets

The sheet ID can be found in the URL of your google sheet, for example in https://docs.google.com/spreadsheets/d/1UuVIH2O38XK0TfPMGHk0HG_ixGLtLk6WoBKh4YSrDm4/edit#gid=0

The ID would be 1UuVIH2O38XK0TfPMGHk0HG_ixGLtLk6WoBKh4YSrDm4

Cells

Google sheets uses the following syntax to reference a tab and cells of the worksheet

The format is Sheet1!A1:C3

Where Sheet1 is the Sheet name followed by a ! then the grid of the first cell eg A1 then a : and finally the grid of the last cell eg C3

A range of cells can be a Row at A1:A5, a Column A1:E1 or even a block such as A1:C3

Selasa, 31 Oktober 2023

cara setting port forwarding di modem huawei b312


 cara setting port forwarding di modem huawei b312

1. koneksikan ke modem huawei

2. tunggu sampai konek

3. jika sudah konek, buka browser

4. ketik ip modem 192.168.8.1

5. masukkan kata sandi admin

6. lakukan next" aja seperti barusan saya lakukan

7. bikin sandi login modem yg baru

8.pilih pengaturan jaringan - lalu ethernet - pengaturan ethernet

9. mode sambungan pilih ip statis

10. masukkan ip dari jaringan wan.

11. server dns utama isi 8.8.8.8

12. simpan

13. pilih lanjutan

14. pilih keamanan - uncentang firewall (non aktifkan firewall)

15. pilih server maya dan masukkan ip yang mau di forwardkan\

16. simpan

17. FINISH


thanks - Founder SIMOR

Kamis, 20 Juli 2023

function kirim telegram node red

 [

    {

        "id": "92caf8fe4730c41d",

        "type": "function",

        "z": "c4bef54c1ac65e88",

        "name": "send to telegram",

        "func": "var cb = msg.payload\nvar d = new Date();\nvar t = new Date();\nvar date = d.toLocaleDateString();\nvar time = t.toLocaleTimeString();\nvar a;\n\nif(cb == 1)\n{\n   \n    msg.payload = {}\n    msg.payload.chatId = 1383300284\n    msg.payload.type = \"message\";\n    msg.payload.content = \"Over Voltage \" + time + \" \" + date;\n  \n}\n\n\nreturn msg;",

        "outputs": 1,

        "noerr": 0,

        "initialize": "",

        "finalize": "",

        "libs": [],

        "x": 730,

        "y": 340,

        "wires": [

            [

                "ca3dba7f8f791834"

            ]

        ]

    }

]

signal gsm sim800l

Value RSSI dBm Condition 2 -109 Marginal 3 -107 Marginal 4 -105 Marginal 5 -103 Marginal 6 -101 Marginal 7 -99 Marginal 8 -97 Marginal 9 -95...