RTS

Explore

Control aeronaves

Logbook

Se actualiza automáticamente desde el excel Horas flota gracias a Zapier con la cuenta (jmllor+zapier@pm.me grabada en keychain)

La tabla Logbook data la actualiza automáticamente Zapier leyendo los datos de excel. Para evitar que cuente muchas tareas, lo que hace es que en el excel Horas flota he creado una pestaña llamada Zapier que en una única línea va leyeno los datos de todas las hojas y los copia aquí

Logbook data

Logbook data

ENCABEZADO

DYQ_ATT

DYQ_ldg

DYQ_ETT

DYQ_Est

FHX_ATT

FHX_ldg

FHX_ETT

FHX_Est

HCC_ATT

HCC_ldg

HCC_ETT

HCC_Est

EUT_ATT

EUT_ldg

EUT_RIN

EUT_ETT

EUT_Est

JKG_ATT

JKG_ldg

JKG_RIN

JKG_ETT

JKG_Est

NGU_ATT

NGU_ldg

NGU_RIN

NGU_ETT

NGU_Est

MFU_ATT

MFU_ldg

MFU_RIN

MFU_E1TT

MFU_E1st

MFU_E2TT

MFU_E2st

MLG_ATT

MLG_ldg

MLG_RIN

MLG_E1TT

MLG_E1st

MLG_E2TT

MLG_E2st

MPL_ATT

MPL_ldg

MPL_RIN

MPL_E1TT

MPL_E1st

MPL_E2TT

MPL_E2st

MPM_ATT

MPM_ldg

MPM_RIN

MPM_E1TT

MPM_E1st

MPM_E2TT

MPM_E2st

MPO_ATT

MPO_ldg

MPO_RIN

MPO_E1TT

MPO_E1st

MPO_E2TT

MPO_E2st

MPZ_ATT

MPZ_ldg

MPZ_RIN

MPZ_E1TT

MPZ_E1st

MPZ_E2TT

MPZ_E2st

MRK_ATT

MRK_ldg

MRK_RIN

MRK_E1TT

MRK_E1st

MRK_E2TT

MRK_E2st

MUE_ATT

MUE_ldg

MUE_RIN

MUE_E1TT

MUE_E1st

MUE_E2TT

MUE_E2st

MZI_ATT

MZI_ldg

MZI_RIN

MZI_E1TT

MZI_E1st

MZI_E2TT

MZI_E2st

NAU_ATT

NAU_ldg

NAU_RIN

NAU_E1TT

NAU_E1st

NAU_E2TT

NAU_E2st

NID_ATT

NID_ldg

NID_RIN

NID_E1TT

NID_E1st

NID_E2TT

NID_E2st

NJV_ATT

NJV_ldg

NJV_RIN

NJV_E1TT

NJV_E1st

NJV_E2TT

NJV_E2st

NKA_ATT

NKA_ldg

NKA_RIN

NKA_E1TT

NKA_E1st

NKA_E2TT

NKA_E2st

NTC_ATT

NTC_ldg

NTC_RIN

NTC_E1TT

NTC_E1st

NTC_E2TT

NTC_E2st

NTF_ATT

NTF_ldg

NTF_RIN

NTF_E1TT

NTF_E1st

NTF_E2TT

NTF_E2st

HESP_ATT

HESP_ldg

HESP_RIN

HESP_E1TT

HESP_E1st

HESP_E2TT

HESP_E2st

HAFI_ATT

HAFI_ldg

HAFI_RIN

HAFI_E1TT

HAFI_E1st

HAFI_E2TT

HAFI_E2st

HAFS_ATT

HAFS_ldg

HAFS_RIN

HAFS_E1TT

HAFS_E1st

HAFS_E2TT

HAFS_E2st

Number

ENCABEZADO

DYQ_ATT

DYQ_ldg

DYQ_ETT

DYQ_Est

FHX_ATT

FHX_ldg

FHX_ETT

FHX_Est

HCC_ATT

HCC_ldg

HCC_ETT

HCC_Est

EUT_ATT

EUT_ldg

EUT_RIN

EUT_ETT

EUT_Est

JKG_ATT

JKG_ldg

JKG_RIN

JKG_ETT

JKG_Est

NGU_ATT

NGU_ldg

NGU_RIN

NGU_ETT

NGU_Est

MFU_ATT

MFU_ldg

MFU_RIN

MFU_E1TT

MFU_E1st

MFU_E2TT

MFU_E2st

MLG_ATT

MLG_ldg

MLG_RIN

MLG_E1TT

MLG_E1st

MLG_E2TT

MLG_E2st

MPL_ATT

MPL_ldg

MPL_RIN

MPL_E1TT

MPL_E1st

MPL_E2TT

MPL_E2st

MPM_ATT

MPM_ldg

MPM_RIN

MPM_E1TT

MPM_E1st

MPM_E2TT

MPM_E2st

MPO_ATT

MPO_ldg

MPO_RIN

MPO_E1TT

MPO_E1st

MPO_E2TT

MPO_E2st

MPZ_ATT

MPZ_ldg

MPZ_RIN

MPZ_E1TT

MPZ_E1st

MPZ_E2TT

MPZ_E2st

MRK_ATT

MRK_ldg

MRK_RIN

MRK_E1TT

MRK_E1st

MRK_E2TT

MRK_E2st

MUE_ATT

MUE_ldg

MUE_RIN

MUE_E1TT

MUE_E1st

MUE_E2TT

MUE_E2st

MZI_ATT

MZI_ldg

MZI_RIN

MZI_E1TT

MZI_E1st

MZI_E2TT

MZI_E2st

NAU_ATT

NAU_ldg

NAU_RIN

NAU_E1TT

NAU_E1st

NAU_E2TT

NAU_E2st

NID_ATT

NID_ldg

NID_RIN

NID_E1TT

NID_E1st

NID_E2TT

NID_E2st

NJV_ATT

NJV_ldg

NJV_RIN

NJV_E1TT

NJV_E1st

NJV_E2TT

NJV_E2st

NKA_ATT

NKA_ldg

NKA_RIN

NKA_E1TT

NKA_E1st

NKA_E2TT

NKA_E2st

NTC_ATT

NTC_ldg

NTC_RIN

NTC_E1TT

NTC_E1st

NTC_E2TT

NTC_E2st

NTF_ATT

NTF_ldg

NTF_RIN

NTF_E1TT

NTF_E1st

NTF_E2TT

NTF_E2st

HESP_ATT

HESP_ldg

HESP_RIN

HESP_E1TT

HESP_E1st

HESP_E2TT

HESP_E2st

HAFI_ATT

HAFI_ldg

HAFI_RIN

HAFI_E1TT

HAFI_E1st

HAFI_E2TT

HAFI_E2st

HAFS_ATT

HAFS_ldg

HAFS_RIN

HAFS_E1TT

HAFS_E1st

HAFS_E2TT

HAFS_E2st

Number

Datos

7,841.25

8,821

7,948.42

7,403

10,099.16

9,162

11,371.42

9,532

11,005.9

20,916

9,992.05

15,937

7,046.09

10,900

26,051

6,810.08

9,200

6,965.25

20,585

63,341

6,827.28

13,891

2,909.33

11,410

17,860

2,622.7

5,026

15,752.25

45,738

50,554

11,791.35

15,390

10,559.88

8,547

16,267

40,094

46,143

3,540.78

6,401

11,602.05

8,903

14,061.09

31,030

37,787

3,585.41

5,152

3,478.47

8,333

4,234.09

10,662

18,238

5,000.77

5,396

14,992.87

5,627

15,943.75

43,909

53,922

3,770.7

5,686

3,770.7

5,693

15,729.84

52,757

57,393

9,234.67

7,234

10,022.6

7,285

10,082.44

20,510

25,293

10,486.54

14,116

8,369.57

8,833

10,773.75

39,613

43,399

11,425.7

31,271

9,510.65

17,989

17,128.16

45,093

46,786

10,084.13

11,758

11,788.78

9,322

14,575.25

43,576

50,478

7,117.15

6,539

10,078.15

8,702

11,249.5

18,332

24,992

6,756.3

7,492

13,797.01

15,373

14,899.91

19,298

24,483

19,630.01

26,376

16,778.2

18,452

6,270.16

14,741

22,327

4,253.86

5,014

4,752.59

6,587

5,206.33

17,109

34,500

1,711.18

1,326

5,206.33

14,082

17,723.91

50,354

49,413

5,597.08

6,832

5,381.83

4,868

10,310.77

21,254

21,300

6,675.59

6,594

6,675.59

4,742

7,062.92

23,270

24,174

7,062.92

7,624

7,062.92

7,625

6,292.66

27,300

31,642

3,280.5

3,331

3,280.5

3,334

17,940.41

Test

There are no rows in this table

⁠

Una vez traidos los datos actuales en bruto, los reordenamos para tenerlos organizaos por aeronave.

Logbook v2

Logbook v2

Registry

Modelo

ATT actual

Landings

RIN

ENG1 TT

ENG1 Starts

ENG2 TT

ENG2 Starts

EC-DYQ

8677

AB206

7,841.25

8,821

7,948.42

7,403

EC-JKG

52068

206L-4

6,965.25

20,585

63,341

6,827.28

13,891

EC-EUT

51337

206L-3

7,046.09

10,900

26,051

6,810.08

9,200

EC-FHX

3786

206B

10,099.16

9,162

11,371.42

9,532

EC-HCC

4505

206B

11,005.9

20,916

9,992.05

15,937

D-HAFI

36107

412

7,062.92

23,270

24,174

7,062.92

7,624

7,062.92

7,624

D-HAFS

36252

412

6,292.66

27,300

31,642

3,280.5

3,331

3,280.5

3,331

D-HESP

36206

412

10,310.77

21,254

21,300

6,675.59

6,594

6,675.59

6,594

EC-MFU

33172

412

15,752.25

45,738

50,554

11,791.35

15,390

10,559.88

15,390

EC-MLG

33188

412

16,267

40,094

46,143

3,540.78

6,401

11,602.05

6,401

EC-MPL

33211

412

14,061.09

31,030

37,787

3,585.41

5,152

3,478.47

5,152

EC-MPM

33151

412

4,234.09

10,662

18,238

5,000.77

5,396

14,992.87

5,396

EC-MPO

36041

412

15,943.75

43,909

53,922

3,770.7

5,686

3,770.7

5,686

EC-MPZ

36082

412

15,729.84

52,757

57,393

9,234.67

7,234

10,022.6

7,234

EC-MRK

36067

412

10,082.44

20,510

25,293

10,486.54

14,116

8,369.57

14,116

EC-MUE

36059

412

10,773.75

39,613

43,399

11,425.7

31,271

9,510.65

31,271

EC-MZI

33118

412

17,128.16

45,093

46,786

10,084.13

11,758

11,788.78

11,758

EC-NAU

36161

412

14,575.25

43,576

50,478

7,117.15

6,539

10,078.15

6,539

EC-NID

33105

412

11,249.5

18,332

24,992

6,756.3

7,492

13,797.01

7,492

EC-NJV

33091

412

14,899.91

19,298

24,483

19,630.01

26,376

16,778.2

26,376

EC-NKA

36305

412

6,270.16

14,741

22,327

4,253.86

5,014

4,752.59

5,014

EC-NTC

36355

412

5,206.33

17,109

34,500

1,711.18

1,326

5,206.33

1,326

EC-NTF

33178

412

17,723.91

50,354

49,413

5,597.08

6,832

5,381.83

6,832

EC-NGU

53551

407

2,909.33

11,410

17,860

2,622.7

5,026

There are no rows in this table

⁠

Esta es la tabla inicial. Aquí cada línea se actualizaba con un Zap independiente, pero claro, eso suponía abrir cada una de las pestañas y traer los datos, es mas eficiente de la otra forma. Actualmente tengo los ZAPs desactivados y por eso no se actualizan los datos.

Logbook - NO ACTUALIZA

Logbook - NO ACTUALIZA

Registry

Modelo

ATT

Landings

RIN

ENG1 TT

ENG1 PWC Starts

ENG2 TT

ENG2 PWC Starts

EC-DYQ

8677

AB206

EC-JKG

52068

206L-4

EC-EUT

51337

206L-3

EC-FHX

3786

206B

EC-HCC

4505

206B

D-HAFI

36107

412

D-HAFS

36252

412

D-HESP

36206

412

EC-MFU

33172

412

EC-MLG

33188

412

EC-MPL

33211

412

EC-MPM

33151

412

EC-MPO

36041

412

EC-MPZ

36082

412

15,722.26

52,736

57,339

9,227.09

7,220

10,015.02

7,271

EC-MRK

36067

412

EC-MUE

36059

412

EC-MZI

33118

412

EC-NAU

36161

412

EC-NID

33105

412

EC-NJV

33091

412

EC-NKA

36305

412

EC-NTC

36355

412

EC-NTF

33178

412

EC-NGU

53551

407

There are no rows in this table

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.