Explore

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

HKGB_ATT

HKGB_ldg

HKGB_ETT

HKGB_Est

HAFU_ATT

HAFU_ldg

HAFU_RIN

HAFU_E1TT

HAFU_E1st

HAFU_E2TT

HAFU_E2st

HAFG_ATT

HAFG_ldg

HAFG_RIN

HAFG_E1TT

HAFG_E1st

HAFG_E2TT

HAFG_E2st

MZE_ATT

MZE_ldg

MZE_RIN

MZE_E1TT

MZE_E1st

MZE_E2TT

MZE_E2st

MGH_ATT

MGH_ldg

MGH_RIN

MGH_E1TT

MGH_E1st

MGH_E2TT

MGH_E2st

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

HKGB_ATT

HKGB_ldg

HKGB_ETT

HKGB_Est

HAFU_ATT

HAFU_ldg

HAFU_RIN

HAFU_E1TT

HAFU_E1st

HAFU_E2TT

HAFU_E2st

HAFG_ATT

HAFG_ldg

HAFG_RIN

HAFG_E1TT

HAFG_E1st

HAFG_E2TT

HAFG_E2st

MZE_ATT

MZE_ldg

MZE_RIN

MZE_E1TT

MZE_E1st

MZE_E2TT

MZE_E2st

MGH_ATT

MGH_ldg

MGH_RIN

MGH_E1TT

MGH_E1st

MGH_E2TT

MGH_E2st

Datos

7,937.33

9,103.00

8,044.50

7,526.00

10,396.58

9,719

11,668.83

9,784

11,005.9

20,916

9,992.05

15,937

7,216.67

11,173

26,595

6,980.66

9,381

6,979.84

20,641

63,617

6,841.86

13,911

3,232.83

11,999

21,194

2,946.2

5,344

15,883.42

46,259

51,750

11,922.52

15,534

10,691.05

8,691

16,606.17

40,586

50,256

3,879.95

6,694

11,941.22

9,196

14,203.67

31,464

38,320

7,585.83

9,004

3,621.05

8,654

4,332.67

11,066

19,515

5,099.35

5,553

15,091.45

5,785

16,120.5

44,481

55,296

3,947.45

5,918

3,947.45

5,924

15,793.51

52,976

57,679

9,298.34

7,356

10,086.27

7,407

10,267.74

20,802

27,046

10,671.84

14,268

8,554.87

8,985

11,040.17

40,461

44,702

11,692.11

31,708

9,777.06

18,426

17,217.16

45,414

47,742

10,173.13

11,876

11,877.78

9,439

14,856.75

44,036

53,215

7,398.65

6,764

10,359.39

9,114

11,361.17

18,792

26,119

6,867.97

7,661

13,908.68

15,541

15,014.89

19,565

25,951

19,744.99

26,500

16,893.19

18,576

6,506.41

15,373

26,637

4,490.11

5,342

4,988.84

6,915

5,425.48

18,060

36,202

1,930.33

1,555

5,425.48

14,310

17,823.5

50,740

54,327

5,696.67

6,971

5,481.42

5,008

10,610.5

21,762

24,268

5,970.48

6,843

3,292.87

4,994

7,370.94

23,853

31,610

7,370.94

7,892

7,370.94

7,892

6,574.33

27,686

34,682

3,562.16

3,572

3,562.16

3,575

6,750

10,680.15

6,680.22

8,506

11,599.66

28,840

33,835

7,854.62

6,783

14,559.34

12,880

12,349.68

24,941

43,769

3,434.18

4,281

3,434.18

4,281

17,346.34

37,280

204,820

6,330

5,989

7,579.5

6,801

21,500

21,147

153,975

7,640.75

7,479

6,337.12

gd7,212.00

Test

There are no rows in this table

⁠

Una vez traídos 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

7,937.33

9,103

8,044.5

7,526

EC-JKG

6,979.84

20,641

63,617

6,841.86

13,911

EC-EUT

7,216.67

11,173

26,595

6,980.66

9,381

D-HKGB

6,750

10,680.15

6,680.22

8,506

EC-FHX

10,396.58

9,719

11,668.83

9,784

EC-HCC

11,005.9

20,916

9,992.05

15,937

D-HAFG

D-HAFI

7,370.94

23,853

31,610

7,370.94

7,892

7,370.94

7,892

D-HAFS

6,574.33

27,686

34,682

3,562.16

3,572

3,562.16

3,572

D-HAFU

D-HESP

10,610.5

21,762

24,268

5,970.48

6,843

3,292.87

6,843

EC-MFU

15,883.42

46,259

51,750

11,922.52

15,534

10,691.05

15,534

EC-MLG

16,606.17

40,586

50,256

3,879.95

6,694

11,941.22

6,694

EC-MPL

14,203.67

31,464

38,320

7,585.83

9,004

3,621.05

9,004

EC-MPM

4,332.67

11,066

19,515

5,099.35

5,553

15,091.45

5,553

EC-MPO

16,120.5

44,481

55,296

3,947.45

5,918

3,947.45

5,918

EC-MPZ

15,793.51

52,976

57,679

9,298.34

7,356

10,086.27

7,356

EC-MRK

10,267.74

20,802

27,046

10,671.84

14,268

8,554.87

14,268

EC-MUE

11,040.17

40,461

44,702

11,692.11

31,708

9,777.06

31,708

EC-MZI

17,217.16

45,414

47,742

10,173.13

11,876

11,877.78

11,876

EC-NAU

14,856.75

44,036

53,215

7,398.65

6,764

10,359.39

6,764

EC-NID

11,361.17

18,792

26,119

6,867.97

7,661

13,908.68

7,661

EC-NJV

15,014.89

19,565

25,951

19,744.99

26,500

16,893.19

26,500

EC-NKA

6,506.41

15,373

26,637

4,490.11

5,342

4,988.84

5,342

EC-NTC

5,425.48

18,060

36,202

1,930.33

1,555

5,425.48

1,555

EC-NTF

17,823.5

50,740

54,327

5,696.67

6,971

5,481.42

6,971

EC-NGU

3,232.83

11,999

21,194

2,946.2

5,344

EC-MGH

EC-MZE

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

EC-JKG

EC-EUT

EC-FHX

EC-HCC

D-HAFI

D-HAFS

D-HESP

EC-MFU

EC-MLG

EC-MPL

EC-MPM

EC-MPO

EC-MPZ

15,722.26

52,736

57,339

9,227.09

7,220

10,015.02

7,271

EC-MRK

EC-MUE

EC-MZI

EC-NAU

EC-NID

EC-NJV

EC-NKA

EC-NTC

EC-NTF

EC-NGU

There are no rows in this table

⁠

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

Try clicking the ··· in the right corner or using a keyboard shortcut (

CtrlP

) instead.