Skip to content
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
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,957.16
9,138.00
8,064.33
7,562.00
10,396.58
9,719
11,668.83
9,784
11,005.9
20,916
9,992.05
15,937
7,274.34
11,371
27,065
7,038.33
9,440
7,024.09
20,713
64,691
6,886.11
13,963
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,696.5
40,742
51,045
3,970.28
6,776
12,031.55
9,278
14,227
31,502
38,358
7,599.5
9,026
13,929.85
15,678
4,356.26
11,205
19,760
5,122.94
5,593
15,115.03
5,825
16,189.33
44,629
55,993
4,016.28
5,986
4,016.28
5,992
15,853.17
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,127.5
40,728
45,100
11,779.45
31,854
9,864.4
18,571
17,246
45,587
48,058
10,201.97
11,921
11,906.62
9,484
14,966.17
44,205
54,253
7,508.07
6,857
10,469.04
9,229
11,382.25
18,833
26,160
6,889.05
7,689
3,697.24
2,616
15,042.98
19,593
26,240
19,773.08
26,527
10,719.13
8,718
6,547.08
15,524
27,069
4,530.78
5,386
5,029.51
6,959
5,456.83
18,178
36,492
1,961.68
1,593
5,456.83
14,347
17,863.58
50,940
54,677
5,736.75
7,032
5,521.5
5,069
10,684.33
22,034
25,005
6,044.31
6,908
3,366.7
5,059
7,420.47
24,034
32,171
7,420.47
7,947
7,420.47
7,947
6,622.33
27,853
35,259
3,610.16
3,625
3,610.16
3,628
6,804.5
10,745.15
6,734.72
8,543
11,706.25
29,111
34,812
7,961.2
6,877
14,665.92
12,973
12,397.35
25,090
44,170
3,481.85
4,339
3,481.85
4,339
17,377.84
37,378
206,050
6,361.5
6,027
7,611
6,839
21,543.67
21,289
156,635
7,684.42
7,526
6,380.79
gd7,259.00
Test
Una vez traídos los datos actuales en bruto, los reordenamos para tenerlos organizaos por aeronave.
Logbook v2
Registry
sn
Modelo
ATT actual
Landings
RIN
ENG1 TT
ENG1 Starts
ENG2 TT
ENG2 Starts
EC-DYQ
8677
AB206
7,957.16
9,138
8,064.33
7,562
EC-JKG
52068
206L-4
7,024.09
20,713
64,691
6,886.11
13,963
EC-EUT
51337
206L-3
7,274.34
11,371
27,065
7,038.33
9,440
D-HKGB
3958
206B
6,804.5
10,745.15
6,734.72
8,543
EC-FHX
3786
206B
10,396.58
9,719
11,668.83
9,784
EC-HCC
4505
206B
11,005.9
20,916
9,992.05
15,937
D-HAFG
33185
412
D-HAFI
36107
412
7,420.47
24,034
32,171
7,420.47
7,947
7,420.47
7,947
D-HAFS
36252
412
6,622.33
27,853
35,259
3,610.16
3,625
3,610.16
3,625
D-HAFU
36032
412
D-HESP
36206
412
10,684.33
22,034
25,005
6,044.31
6,908
3,366.7
6,908
EC-MFU
33172
412
15,883.42
46,259
51,750
11,922.52
15,534
10,691.05
15,534
EC-MLG
33188
412
16,696.5
40,742
51,045
3,970.28
6,776
12,031.55
6,776
EC-MPL
33211
412
14,227
31,502
38,358
7,599.5
9,026
13,929.85
9,026
EC-MPM
33151
412
4,356.26
11,205
19,760
5,122.94
5,593
15,115.03
5,593
EC-MPO
36041
412
16,189.33
44,629
55,993
4,016.28
5,986
4,016.28
5,986
EC-MPZ
36082
412
15,853.17
52,976
57,679
9,298.34
7,356
10,086.27
7,356
EC-MRK
36067
412
10,267.74
20,802
27,046
10,671.84
14,268
8,554.87
14,268
EC-MUE
36059
412
11,127.5
40,728
45,100
11,779.45
31,854
9,864.4
31,854
EC-MZI
33118
412
17,246
45,587
48,058
10,201.97
11,921
11,906.62
11,921
EC-NAU
36161
412
14,966.17
44,205
54,253
7,508.07
6,857
10,469.04
6,857
EC-NID
33105
412
11,382.25
18,833
26,160
6,889.05
7,689
3,697.24
7,689
EC-NJV
33091
412
15,042.98
19,593
26,240
19,773.08
26,527
10,719.13
26,527
EC-NKA
36305
412
6,547.08
15,524
27,069
4,530.78
5,386
5,029.51
5,386
EC-NTC
36355
412
5,456.83
18,178
36,492
1,961.68
1,593
5,456.83
1,593
EC-NTF
33178
412
17,863.58
50,940
54,677
5,736.75
7,032
5,521.5
7,032
EC-NGU
53551
407
3,232.83
11,999
21,194
2,946.2
5,344
EC-MGH
30942
212
EC-MZE
30917
212
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
Registry
sn
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
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.