MAJIS Timeline#
from majis import Timeline
Load an existing timeline#
timeline = Timeline(timeline='timeline.xlsm')
timeline
| Event Name | Phase | block | Comments | OBS_NAME | start_time_relative_ca | stop_time_relative_ca | start_time_utc | stop_time_utc | pointing desc | MAJIS resol | prime | MAJIS ODF name | ITL name | Mirror Flag | start_angle | start_scan_speed | stop_scan_speed | Scanner step per frame | stop_angle | scanner_timetot (ms) | First CU_frame start wrt C/A | Last CU_frame stop wrt C/A | First CU_frame start (UTC) | Last CU_frame stop (UTC) | cu_trep_ms | spatial_binning | obs durat (sec) (w/o borders) | nb_cu_frames_tot | nb_cu_frames_tot (computed) | ppe | Spectral Mapping | Number of spectels after spectral binning | Nb of bits per spectel after compression | datarate (bits/s) | DV (Mbits) | Browse Parameters | Number of browse spectels | Nb of bits per browse spectel after compression | browse datarate (bits/s) | browse DV (Mbits) | Image Mode | Dark Strategy | Dark Subtraction | VI flag | IR flag | VI Readout | IR Readout | Start Row VI | Start Row IR | VI Despiking N | VI Despiking M | VI Despiking K | VI Tint | VI Gain | VI Offset | VI NPE | IR Despiking N | IR Despiking M | IR Despiking K | IR Tint | IR Gain | IR Offset | IR NPE | Power (W) | Science mode (for power estimation) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RUN Earth | NIGHT OBSERVATION OF KUALA LUMPUR AND SUMATRA ISLAND EAST COAST | MAJ_EGA_SCAN_001 | MAJIS | ENABLE | -1.99951 | 0.0235421317 | 0.0235421317 | 0 | 2.07328 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) *1000 ), "N/A") | =IF(X3<$Y$2,"-","") & TEXT(ABS(X3-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y3<$Y$2,"-","") & TEXT(ABS(Y3-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:25 | 2024-08-20 21:27:53 | 200 | No Binning | 865 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 128 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels ) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 372 | 360 | 1 | 1 | Lowest | 22 | 10 | 1 | 1 | 1 | 1 | Lowest | 22 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | NIGHT OBSERVATION OF THAILAND, CAMBODGE, VIETNAM AND THE MERIDIONAL CHINESE SEA | MAJ_EGA_SCAN_002 | MAJIS | ENABLE | -1.69974 | 0.0235421317 | 0.0235421317 | 0 | 1.03115 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X4<$Y$2,"-","") & TEXT(ABS(X4-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y4<$Y$2,"-","") & TEXT(ABS(Y4-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:28:09 | 2024-08-20 21:30:05 | 200 | No Binning | 580 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 128 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 372 | 360 | 1 | 1 | Lowest | 22 | 10 | 1 | 1 | 1 | 1 | Lowest | 22 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | NIGHT OBSERVATION OF THE MERIDIONAL CHINESE SEA | MAJ_EGA_SCAN_003 | MAJIS | ENABLE | -2.09682 | 0.0470842634 | 0.0470842634 | 0 | 1.90534 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X5<$Y$2,"-","") & TEXT(ABS(X5-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y5<$Y$2,"-","") & TEXT(ABS(Y5-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:30:20 | 2024-08-20 21:31:45 | 100 | No Binning | 850 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 436 | 424 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | NIGHT OBSERVATION OF MOSTLY THE MERIDIONAL CHINESE SEA AND SOME SMALL PHILIPPINES ISLANDS | MAJ_EGA_SCAN_004 | MAJIS | ENABLE | -1.99951 | 0.0470842634 | 0.0470842634 | 0 | 2.00265 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X6<$Y$2,"-","") & TEXT(ABS(X6-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y6<$Y$2,"-","") & TEXT(ABS(Y6-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:31:59 | 2024-08-20 21:33:24 | 100 | No Binning | 850 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 436 | 424 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | CROSSING THE TERMINATOR AT THE MIDDLE OF THE OBSERVATION | MAJ_EGA_SCAN_005 | MAJIS | ENABLE | -2.09682 | 0.0470842634 | 0.0470842634 | 0 | 2.09368 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X7<$Y$2,"-","") & TEXT(ABS(X7-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y7<$Y$2,"-","") & TEXT(ABS(Y7-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:33:38 | 2024-08-20 21:35:07 | 100 | No Binning | 890 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 436 | 424 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN (AND MAYBE JAPANESE ISLANDS MIYAKOJIMA) | MAJ_EGA_SCAN_006 | MAJIS | ENABLE | -2.09682 | 0.0470842634 | 0.0470842634 | 0 | 0.72824 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X8<$Y$2,"-","") & TEXT(ABS(X8-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y8<$Y$2,"-","") & TEXT(ABS(Y8-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:35:21 | 2024-08-20 21:36:21 | 100 | No Binning | 600 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 436 | 424 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN (AND MAYBE JAPANESE ISLANDS MINAMIDAITO AND KITADAITO) | MAJ_EGA_SCAN_007 | MAJIS | ENABLE | -2.09682 | 0.0470842634 | 0.0470842634 | 0 | -0.54304 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X9<$Y$2,"-","") & TEXT(ABS(X9-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y9<$Y$2,"-","") & TEXT(ABS(Y9-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:36:35 | 2024-08-20 21:37:08 | 100 | No Binning | 330 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 436 | 424 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN (AND MAYBE JAPANESE ISLANDS MINAMIDAITO AND KITADAITO) | MAJ_EGA_SCAN_008 | MAJIS | ENABLE | -2.09682 | 0.0470842634 | 0.0470842634 | 0 | 0.49282 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X10<$Y$2,"-","") & TEXT(ABS(X10-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y10<$Y$2,"-","") & TEXT(ABS(Y10-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:37:22 | 2024-08-20 21:38:17 | 100 | No Binning | 550 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 802 | 790 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN AND SOME NON NEGLIGEABLE ISLANDS LIKE IWO JIMA, AGRIHAN AND PAGAN | MAJ_EGA_SCAN_009 | MAJIS | ENABLE | -1.41253 | 0.0470842634 | 0.0470842634 | 0 | 1.83628 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X11<$Y$2,"-","") & TEXT(ABS(X11-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y11<$Y$2,"-","") & TEXT(ABS(Y11-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:38:31 | 2024-08-20 21:39:40 | 100 | No Binning | 690 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 70 | 58 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN ONLY | MAJ_EGA_SCAN_010 | MAJIS | ENABLE | -1.99951 | 0.0470842634 | 0.0470842634 | 0 | 0.82554 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X12<$Y$2,"-","") & TEXT(ABS(X12-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y12<$Y$2,"-","") & TEXT(ABS(Y12-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:39:54 | 2024-08-20 21:40:54 | 100 | No Binning | 600 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 436 | 424 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN ONLY | MAJ_EGA_SCAN_011 | MAJIS | ENABLE | -1.99951 | 0.0470842634 | 0.0470842634 | 0 | 0.82554 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X13<$Y$2,"-","") & TEXT(ABS(X13-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y13<$Y$2,"-","") & TEXT(ABS(Y13-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:41:08 | 2024-08-20 21:42:08 | 100 | No Binning | 600 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 802 | 790 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN ONLY | MAJ_EGA_SCAN_012 | MAJIS | ENABLE | 2.09682 | -0.0313895089 | -0.0313895089 | 0 | 0.0565 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X14<$Y$2,"-","") & TEXT(ABS(X14-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y14<$Y$2,"-","") & TEXT(ABS(Y14-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:42:22 | 2024-08-20 21:43:27 | 100 | No Binning | 650 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 70 | 58 | 1 | 1 | Lowest | 70 | 10 | 1 | 1 | 1 | 1 | Lowest | 70 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN ONLY | MAJ_EGA_SCAN_013 | MAJIS | ENABLE | 2.09682 | -0.0313895089 | -0.0313895089 | 0 | 0.0565 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X15<$Y$2,"-","") & TEXT(ABS(X15-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y15<$Y$2,"-","") & TEXT(ABS(Y15-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:43:41 | 2024-08-20 21:44:46 | 100 | No Binning | 650 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 436 | 424 | 1 | 1 | Lowest | 70 | 10 | 1 | 1 | 1 | 1 | Lowest | 70 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN ONLY | MAJ_EGA_SCAN_014 | MAJIS | ENABLE | 2.09682 | -0.0313895089 | -0.0313895089 | 0 | 0.0565 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X16<$Y$2,"-","") & TEXT(ABS(X16-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y16<$Y$2,"-","") & TEXT(ABS(Y16-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:45 | 2024-08-20 21:46:05 | 100 | No Binning | 650 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 802 | 790 | 1 | 1 | Lowest | 70 | 10 | 1 | 1 | 1 | 1 | Lowest | 70 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN (AND MAYBE MIDWAY ATOLL) | MAJ_EGA_SCAN_015 | MAJIS | ENABLE | -2.09682 | 0.0470842634 | 0.0470842634 | 0 | -0.30762 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X17<$Y$2,"-","") & TEXT(ABS(X17-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y17<$Y$2,"-","") & TEXT(ABS(Y17-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:46:19 | 2024-08-20 21:46:57 | 100 | No Binning | 380 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 70 | 58 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE PACIFIC OCEAN AND SOME MINOR HAWAIIAN ISLANDS | MAJ_EGA_SCAN_016 | MAJIS | ENABLE | -2.09682 | 0.0470842634 | 0.0470842634 | 0 | -0.30762 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X18<$Y$2,"-","") & TEXT(ABS(X18-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y18<$Y$2,"-","") & TEXT(ABS(Y18-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:47:11 | 2024-08-20 21:47:49 | 100 | No Binning | 380 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 436 | 424 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | DAY OBSERVATION OF THE MAIN HAWAIIAN ISLANDS | MAJ_EGA_SCAN_017 | MAJIS | ENABLE | -1.64794 | 0.0470842634 | 0.0470842634 | 0 | 0.28251 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X19<$Y$2,"-","") & TEXT(ABS(X19-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y19<$Y$2,"-","") & TEXT(ABS(Y19-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:48:04 | 2024-08-20 21:48:45 | 100 | No Binning | 410 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 70 | 58 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | EGRESS ... AT FIRST THE PACIFIC OCEAN THEN EARTH'S ATMOSPHERE + SPACE | MAJ_EGA_SCAN_018 | MAJIS | ENABLE | -1.41253 | 0.0470842634 | 0.0470842634 | 0 | 1.41253 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X20<$Y$2,"-","") & TEXT(ABS(X20-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y20<$Y$2,"-","") & TEXT(ABS(Y20-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:49 | 2024-08-20 21:50 | 100 | No Binning | 600 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 802 | 790 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | 1 | 1 | Lowest | 11 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) | |||||||||||
| RUN Earth | EGRESS ... EARTH'S ATMOSPHERE + SPACE | MAJ_EGA_SCAN_019 | MAJIS | ENABLE | -0.70626 | 0.0235421317 | 0.0235421317 | 0 | 0.70626 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | =IF(X21<$Y$2,"-","") & TEXT(ABS(X21-$Y$2),"hh:mm:ss"&decimal_separator&"000") | =IF(Y21<$Y$2,"-","") & TEXT(ABS(Y21-$Y$2),"hh:mm:ss"&decimal_separator&"000") | 2024-08-20 21:50:15 | 2024-08-20 21:51:15 | 200 | No Binning | 300 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 128 | MAJIS_DEFAULT_SPECTRAL_MASK_shift0 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | Nominal | Dark Before + After | Subtracted | ON | ON | 1 MHz | 1 MHz | 372 | 360 | 1 | 1 | Lowest | 22 | 10 | 1 | 1 | 1 | 1 | Lowest | 22 | 10 | 1 | 1 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing)) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description)) |
Explore the content of the timeline#
Get the timeline template version:
timeline.version
<Version('1.9.10')>
Get the timeline template changelog:
timeline.log
| Version | Date | Author | Changes |
|---|---|---|---|
| 1.9.10 | 2024-05-29 | Cydalise Dumesnil | Add new column "Comments" |
| 1.9.9 | 2024-05-23 | Vincent Carlier | Add new columns "VI Gain", "VI Offset", "IR Gain", "IR Offset" |
| 1.9.8 | 2024-05-13 | Vincent Carlier | Fix issues related to the decimal separator ',' or '.' depending on the host PC : - new variable name 'decimal_separator' used to compute the time 'wrt C/A' from 'UTC' in the cells - fix of the macro DIFF_TIME_ms used to compute the DV in case of continuous acquisition Add a note about 'scanner_timetot' computation Add a note about decimal separator in the time 'wrt C/A' columns |
| 1.9.7 | 2024-04-25 | Vincent Carlier | Add spectral masks |
| 1.9.7 | 2024-03-21 | Vincent Carlier | Change the names BROWSE_TABLE into BROWSE_PARAMETERS Change column names: "Browse" into "Browse Parameters" Fix fomulas for nomi and brow to take into account VI_Flag and IR_Flag Add bullet tips in 2nd row (copy of footer comments) |
| 1.9.7 | 2024-03-14 | Vincent Carlier | Split de number of spectels from the spectral table into VI and IR. Split de number of spectels from the browse parameters into VI and IR. |
| 1.9.6 | 2024-03-14 | Vincent Carlier | Add a macro which resets the unused values if Mirror Flag is "DISABLE" Add a data validation on start_angle and stop_angle (from -2.1 to +2.1) |
| 1.9.6 | 2024-03-13 | Vincent Carlier | - reorganisation of the order of columns |
| 1.9.6 | 2024-03-11 | Vincent Carlier | - Change column names: "Observation ID" changed in "OBS_NAME" |
| 1.9.6 | 2024-03-04 | Vincent Carlier | - Add a check in DV cell to check that the number of CU Frame entered by hand is equal to the computed value - fix the DIFF_TIME_CA_ms function to work with column name instead of cell name - Update color code - Add comments |
| 1.9.5 | 2024-02-27 | Vincent Carlier | - fix computation of scanner_timetot (ms) - rename the test browse table - change the suffix of browse parameters file to _xxx_BROWSE_PARAMETERS - add Europa scan bowse parameters : MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS - add Europa scan spectral table : MAJIS_EUROPA_SCAN_SPECTRAL_TABLE - add some test browse parameters |
| 1.9.4 | 2024-02-08 | Vincent Carlier | - update of the Start Row VI and Start Row IR - fix formula of scanner_timetot (abs added for start and stop speed) - new spectral table MAJIS_STAR_LOCATION_WITH_SCAN_SPECTRAL_TABLE |
| 1.9.4 | 2024-01-25 | Vincent Carlier | - new column "nb_cu_frames_tot (computed)" added with the same formula than timeline2config when the scanner is used in asynchronous mode. - new column "scanner_timetot (ms)" added which compute the duration between the scanner start and end position. This value is then used to compute the number of CU Frames in the column "nb_cu_frames_tot (computed)" - Human-readable naming of cells used in formulas to make all the formulas readable and understandable. - Some foot notes are added or modified for better clarity - some new Spectral tables added in 'internal' sheet |
| 1.9.3 | 2023-11-14 | Vincent Carlier | Browse datavolume formula fixed |
| 1.9.2 | 2023-10-23 | Cydalise Dumesnil | equivalent nb of bits updated for table MAJIS_JUP_DISC_SCAN and MAJIS_JUP_DISC_SLEW |
| 1.9.2 | 2023-10-12 | Vincent Carlier | - Formula DIFF_TIME_CA_ms(start_ca;stop_ca) added to compute the time in milliseconds between Start and Stop. Useful to compute the number of frame and the datavolume of segment observations. |
| 1.9.1 | 2023-09-13 | Vincent Carlier | - version updated in "info" tab - New column AO: "Nb of bits per spectel after compression" - Comment in column AN fixed : "This includes the compression rate per band" replaced by "This includes the spectral binning" - Title of column AO updated in "Number of spectels after spectral binning" - Browse datavolume added (4 new columns BB to BE) - "internal" sheet added - dropdown lists created to select "Spectral mapping" and "Browse" - Datavolume and datarate formulas added for Nominal and Browse data - Power estimations added (formulas + table) |
| 1.9 | 2023-07-13 | Quentin Gottafray | Change parameters name to match MOS |
| 1.8.2 | 2023-06-14 | Cydalise Dumesnil | parameters language modification (french to english) and Gfinder correspondance |
| 1.8.1 | 2023-06-07 | all | New issue |
| 1.0 | 2022-12-06 | Cydalise Dumesnil | Despiking parameter Tint and NPE added Scan step number in case of synchronization added |
| 1.0 | 2022-11-28 | Cydalise Dumesnil | change of names wrt the build_TC template |
| 1.0 | 2022-11-08 | François Poulet | creation |
Get science changelog:
timeline.science
---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
Cell In[5], line 1
----> 1 timeline.science
File ~/checkouts/readthedocs.org/user_builds/majis-ops/envs/stable/lib/python3.10/site-packages/majis/itl/timeline.py:296, in Timeline.science(self)
287 """Science change log.
288
289 Raises
(...)
293
294 """
295 if self.version < Version('2.0'):
--> 296 raise ValueError(
297 f'Science changelog is only available in template ≥ 2.0 (current: `{self.version}`)'
298 )
300 return TimelineChangeLog(self._template, sheet_name='science change log')
ValueError: Science changelog is only available in template ≥ 2.0 (current: `1.9.10`)
Get the number of observations:
len(timeline)
19
Get the list of observations:
timeline['OBS_NAME']
['MAJ_EGA_SCAN_001',
'MAJ_EGA_SCAN_002',
'MAJ_EGA_SCAN_003',
'MAJ_EGA_SCAN_004',
'MAJ_EGA_SCAN_005',
'MAJ_EGA_SCAN_006',
'MAJ_EGA_SCAN_007',
'MAJ_EGA_SCAN_008',
'MAJ_EGA_SCAN_009',
'MAJ_EGA_SCAN_010',
'MAJ_EGA_SCAN_011',
'MAJ_EGA_SCAN_012',
'MAJ_EGA_SCAN_013',
'MAJ_EGA_SCAN_014',
'MAJ_EGA_SCAN_015',
'MAJ_EGA_SCAN_016',
'MAJ_EGA_SCAN_017',
'MAJ_EGA_SCAN_018',
'MAJ_EGA_SCAN_019']
Get one observation details by index (starting at 1):
timeline[1]
{'Event Name': 'RUN Earth',
'Comments': 'NIGHT OBSERVATION OF KUALA LUMPUR AND SUMATRA ISLAND EAST COAST',
'OBS_NAME': 'MAJ_EGA_SCAN_001',
'prime': 'MAJIS',
'Mirror Flag': 'ENABLE',
'start_angle': -1.99951,
'start_scan_speed': 0.0235421317,
'stop_scan_speed': 0.0235421317,
'stop_angle': 2.07328,
'First CU_frame start (UTC)': '2024-08-20 21:25',
'Last CU_frame stop (UTC)': '2024-08-20 21:27:53',
'cu_trep_ms': 200,
'spatial_binning': 'No Binning',
'nb_cu_frames_tot': 865,
'ppe': 128,
'Spectral Mapping': 'MAJIS_DEFAULT_SPECTRAL_MASK_shift0',
'Browse Parameters': 'MAJIS_EUROPA_SCAN_BROWSE_PARAMETERS',
'Image Mode': 'Nominal',
'Dark Strategy': 'Dark Before + After',
'Dark Subtraction': 'Subtracted',
'VI flag': 'ON',
'IR flag': 'ON',
'VI Readout': '1 MHz',
'IR Readout': '1 MHz',
'Start Row VI': 372,
'Start Row IR': 360,
'VI Despiking N': 1,
'VI Despiking M': 1,
'VI Despiking K': 'Lowest',
'VI Tint': 22,
'VI Gain': 10,
'VI Offset': 1,
'VI NPE': 1,
'IR Despiking N': 1,
'IR Despiking M': 1,
'IR Despiking K': 'Lowest',
'IR Tint': 22,
'IR Gain': 10,
'IR Offset': 1,
'IR NPE': 1}
Get one observation single property:
timeline['start_angle', 1]
-1.99951
Export ITL observations to a new timeline from the default template#
timeline = Timeline(observations='absolute_time.itl')
timeline
| Event Name | Phase | block | Comments | OBS_NAME | start_time_relative_ca | stop_time_relative_ca | start_time_utc | stop_time_utc | pointing desc | MAJIS resol | prime | MAJIS ODF name | ITL name | Mirror Flag | start_angle | start_scan_speed | stop_scan_speed | Scanner step per frame | stop_angle | tick_freq | scanner_timetot (ms) | First CU_frame start wrt C/A | Last CU_frame stop wrt C/A | First CU_frame start (UTC) | Last CU_frame stop (UTC) | cu_trep_ms | spatial_binning | obs durat (sec) (w/o borders) | nb_cu_frames_tot | nb_cu_frames_tot (computed) | ppe | Spectral Mapping | Number of spectels after spectral binning | Nb of bits per spectel after compression | datarate (bits/s) | DV (Mbits) | Browse Parameters | Number of browse spectels | Nb of bits per browse spectel after compression | browse datarate (bits/s) | browse DV (Mbits) | Image Mode | Dark Strategy | Dark Subtraction | CDS flag | VI flag | IR flag | VI Readout | IR Readout | Start Row VI | Start Row IR | VI Despiking N | VI Despiking M | VI Despiking K | VI Tint | VI Gain | VI Offset | VI NPE | IR Despiking N | IR Despiking M | IR Despiking K | IR Tint | IR Gain | IR Offset | IR NPE | Power (W) | Science mode (for power estimation) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MULTI WORDS COMMENT with , and ; / MULTI LINES COMMENT | MAJ_JUP_DISK_SCAN_001 | MAJIS | absolute_time.itl | ENABLE | -1.31051 | 0.0022421078 | 0.0022421078 | 0.0 | 0.10202 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | 2032-09-23T05:15:45Z | 2032-09-23T05:26:15Z | 500 | No Binning | 300 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 400 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | 100 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF(OR(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing), "N/A")) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description), "N/A")) | |||||||||||||||||||||||||||||||||||||||
| MAJ_JUP_DISK_SCAN_002 | MAJIS | absolute_time.itl | ENABLE | 1.32935 | -0.0022421078 | -0.0022421078 | 3.0 | -0.08318 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | 2032-09-23T06:09:45Z | 2032-09-23T06:20:15Z | 2100 | Binning x2 | 300 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 400 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | 372 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF(OR(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing), "N/A")) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description), "N/A")) |
timeline['start_angle', 1]
-1.31051
Edit a single field value:
timeline['start_angle', 1] = -1.5
timeline['start_angle', 1]
-1.5
Save the timeline to a new XLSM timeline file:
timeline.save('new_timeline_from_itl.xlsm')
PosixPath('new_timeline_from_itl.xlsm')
Reload the timeline and append new ITL observation, reported as relative time to reference events:
timeline = Timeline(
observations='relative_time.itl',
refs='events.evf',
timeline='new_timeline_from_itl.xlsm',
)
timeline
| Event Name | Phase | block | Comments | OBS_NAME | start_time_relative_ca | stop_time_relative_ca | start_time_utc | stop_time_utc | pointing desc | MAJIS resol | prime | MAJIS ODF name | ITL name | Mirror Flag | start_angle | start_scan_speed | stop_scan_speed | Scanner step per frame | stop_angle | tick_freq | scanner_timetot (ms) | First CU_frame start wrt C/A | Last CU_frame stop wrt C/A | First CU_frame start (UTC) | Last CU_frame stop (UTC) | cu_trep_ms | spatial_binning | obs durat (sec) (w/o borders) | nb_cu_frames_tot | nb_cu_frames_tot (computed) | ppe | Spectral Mapping | Number of spectels after spectral binning | Nb of bits per spectel after compression | datarate (bits/s) | DV (Mbits) | Browse Parameters | Number of browse spectels | Nb of bits per browse spectel after compression | browse datarate (bits/s) | browse DV (Mbits) | Image Mode | Dark Strategy | Dark Subtraction | CDS flag | VI flag | IR flag | VI Readout | IR Readout | Start Row VI | Start Row IR | VI Despiking N | VI Despiking M | VI Despiking K | VI Tint | VI Gain | VI Offset | VI NPE | IR Despiking N | IR Despiking M | IR Despiking K | IR Tint | IR Gain | IR Offset | IR NPE | Power (W) | Science mode (for power estimation) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MULTI WORDS COMMENT with , and ; / MULTI LINES COMMENT | MAJ_JUP_DISK_SCAN_001 | MAJIS | absolute_time.itl | ENABLE | -1.5 | 0.0022421078 | 0.0022421078 | 0 | 0.10202 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | 2032-09-23T05:15:45Z | 2032-09-23T05:26:15Z | 500 | No Binning | 300 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 400 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | 100 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF(OR(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing), "N/A")) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description), "N/A")) | |||||||||||||||||||||||||||||||||||||||
| MAJ_JUP_DISK_SCAN_002 | MAJIS | absolute_time.itl | ENABLE | 1.32935 | -0.0022421078 | -0.0022421078 | 3 | -0.08318 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | 2032-09-23T06:09:45Z | 2032-09-23T06:20:15Z | 2100 | Binning x2 | 300 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 400 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | 372 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF(OR(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing), "N/A")) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description), "N/A")) | ||||||||||||||||||||||||||||||||||||||||
| MAJ_JUP_DISK_SCAN_101 | other | relative_time.itl | ENABLE | -0.27937 | 0.0022421078 | 0.0022421078 | 3.0 | 0.23385 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | 2032-09-23T02:58:11Z | 2032-09-23T03:01:59.900Z | 100 | No Binning | 109 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | 436 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF(OR(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing), "N/A")) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description), "N/A")) | ||||||||||||||||||||||||||||||||||||||||
| MAJ_JUP_DISK_SCAN_102 | other | relative_time.itl | ENABLE | -0.37981 | 0.0022421078 | 0.0022421078 | 3.0 | 0.13341 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | 2032-09-23T03:04:34Z | 2032-09-23T03:08:22.900Z | 200 | Binning x4 | 109 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 64 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | 802 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF(OR(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing), "N/A")) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description), "N/A")) |
The new observations were append to the end of the file.
Warning
When new observations are append to an existing timeline, only the new observations are sorted and append to the list. The orginial observations are not re-oredred.
Add relative timing#
If a global relative time w.r.t. to a C/A reference is provided, all the First CU_frame start wrt C/A and Last CU_frame stop wrt C/A fields will be completed based on the First CU_frame start (UTC) and Last CU_frame stop (UTC) fields. This can be done after the load the timeline:
timeline.ca_ref = '2032-09-24T21:33:36 PERIJOVE_12PJ (COUNT = 1)'
timeline['First CU_frame start wrt C/A', 1]
'-001.16:17:51.000'
or it can be provided directly when the timeline is loaded:
Timeline(
timeline='new_timeline_from_itl.xlsm',
ca_ref='2032-09-24T21:33:36 PERIJOVE_12PJ (COUNT = 1)',
)
| Event Name | Phase | block | Comments | OBS_NAME | start_time_relative_ca | stop_time_relative_ca | start_time_utc | stop_time_utc | pointing desc | MAJIS resol | prime | MAJIS ODF name | ITL name | Mirror Flag | start_angle | start_scan_speed | stop_scan_speed | Scanner step per frame | stop_angle | tick_freq | scanner_timetot (ms) | First CU_frame start wrt C/A | Last CU_frame stop wrt C/A | First CU_frame start (UTC) | Last CU_frame stop (UTC) | cu_trep_ms | spatial_binning | obs durat (sec) (w/o borders) | nb_cu_frames_tot | nb_cu_frames_tot (computed) | ppe | Spectral Mapping | Number of spectels after spectral binning | Nb of bits per spectel after compression | datarate (bits/s) | DV (Mbits) | Browse Parameters | Number of browse spectels | Nb of bits per browse spectel after compression | browse datarate (bits/s) | browse DV (Mbits) | Image Mode | Dark Strategy | Dark Subtraction | CDS flag | VI flag | IR flag | VI Readout | IR Readout | Start Row VI | Start Row IR | VI Despiking N | VI Despiking M | VI Despiking K | VI Tint | VI Gain | VI Offset | VI NPE | IR Despiking N | IR Despiking M | IR Despiking K | IR Tint | IR Gain | IR Offset | IR NPE | Power (W) | Science mode (for power estimation) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MULTI WORDS COMMENT with , and ; / MULTI LINES COMMENT | MAJ_JUP_DISK_SCAN_001 | MAJIS | absolute_time.itl | ENABLE | -1.5 | 0.0022421078 | 0.0022421078 | 0 | 0.10202 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | -001.16:17:51.000 | -001.16:07:21.000 | 2032-09-23T05:15:45Z | 2032-09-23T05:26:15Z | 500 | No Binning | 300 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 400 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | 100 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF(OR(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing), "N/A")) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description), "N/A")) | |||||||||||||||||||||||||||||||||||||
| MAJ_JUP_DISK_SCAN_002 | MAJIS | absolute_time.itl | ENABLE | 1.32935 | -0.0022421078 | -0.0022421078 | 3 | -0.08318 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), IF(start_scan_speed=stop_scan_speed, ABS( (stop_angle - start_angle) / start_scan_speed ) *1000, ABS( (stop_angle - start_angle) / (stop_scan_speed - start_scan_speed) * LN( stop_scan_speed / start_scan_speed ) ) * 1000), "N/A") | -001.15:23:51.000 | -001.15:13:21.000 | 2032-09-23T06:09:45Z | 2032-09-23T06:20:15Z | 2100 | Binning x2 | 300 | =IF(AND(Mirror_Flag="ENABLE",ABS(Scanner_step_per_frame)<>3), INT( (scanner_timetot__ms / cu_trep_ms) + 0.5), "N/A") | 400 | =(VI_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE) + (IR_flag="ON") * VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE) | =((VI_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,3,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,5,FALSE)*VLOOKUP(SPECTRAL_MASK,list_of_spectral_masks,4,FALSE)) ) / Number_of_spectels_after_spectral_binning | =DV__Mbits/cu_trep_ms/ IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A, Last_CU_frame_stop_wrt_C_A)/cu_trep_ms,nb_cu_frames_tot)*(1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_spectels_after_spectral_binning * Nb_of_bits_per_spectel_after_compression / (1024*1024) ) | =(VI_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE) + (IR_flag="ON") * VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE) | =IF(Number_of_browse_spectels=0,0, ((VI_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,3,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,2,FALSE)) + (IR_flag="ON") * (VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,5,FALSE)*VLOOKUP(BROWSE_PARAMETERS,list_of_browse_parameters,4,FALSE)) ) / Number_of_browse_spectels) | =browse_DV__Mbits / cu_trep_ms / nb_cu_frames_tot * (1024*1024) | =IF(AND(nb_cu_frames_tot__computed<>"N/A",nb_cu_frames_tot<>nb_cu_frames_tot__computed), "ERROR: nb_cu_frames_tot and nb_cu_frames_tot (computed) are not equal", IF(nb_cu_frames_tot=65535, DIFF_TIME_CA_ms(First_CU_frame_start_wrt_C_A,Last_CU_frame_stop_wrt_C_A)/cu_trep_ms, nb_cu_frames_tot) * ( ppe / 2^(IF(spatial_binning="No Binning",0,IF(spatial_binning="Binning x2",1,IF(spatial_binning="Binning x4",2,"N/A")))) ) * Number_of_browse_spectels * Nb_of_bits_per_browse_spectel_after_compression / (1024*1024) ) | 372 | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning, power_2ch_science_pointing), IF(OR(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning, power_1ch_science_pointing), "N/A")) | =IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_2ch_science_scanning_description, power_2ch_science_pointing_description), IF(AND(VI_flag="ON",IR_flag="ON"), IF( Mirror_Flag = "ENABLE", power_1ch_science_scanning_description, power_1ch_science_pointing_description), "N/A")) |