##Instanciar clases 
lienzo = Crear_lienzo(15, 6, 0.5, 0.5)
excel = Gestionar_datos()
graficar = Graficar(11, 11, 14, 12, 12, 10)

##Crear lienzo del gráfico
fig = lienzo.crear_figura()


##Leer excel
length_dataframe = excel.leer_excel('D:\Cindy\Ingeniería\Maestría\Resultados\R2L\Summup data.xlsx', 'Length_triplicate')

##Arrays lote 1

##ARL Lote 1
arl1_day3 = excel.crear_array(length_dataframe, 'ARL_3', 0, 20)
arl1_day6 = excel.crear_array(length_dataframe, 'ARL_6', 0, 20)
arl1_day9 = excel.crear_array(length_dataframe, 'ARL_9', 0, 20)
arl1_day12 = excel.crear_array(length_dataframe, 'ARL_12', 0, 20)

arl1_prom = [np.average(arl1_day3), np.average(arl1_day6), np.average(arl1_day9), np.average(arl1_day12)]
arl1_sd = [np.std(arl1_day3, ddof=sample_sd), np.std(arl1_day6, ddof=sample_sd), np.std(arl1_day9, ddof=sample_sd), np.std(arl1_day12, ddof=sample_sd)]


#S1 Lote 1 
s1_day3 = excel.crear_array(length_dataframe, 'S1_3', 0, 20)
s1_day6 = excel.crear_array(length_dataframe, 'S1_6', 0, 20)
s1_day9 = excel.crear_array(length_dataframe, 'S1_9', 0, 20)
s1_day12 = excel.crear_array(length_dataframe, 'S1_12', 0, 20)

s1_prom = [np.average(s1_day3), np.average(s1_day6), np.average(s1_day9), np.average(s1_day12)]
##Instanciar clases 
lienzo = Crear_lienzo(10, 6, 0.5, 0.5)
excel = Gestionar_datos()
graficar = Graficar(11, 11, 14, 12, 12, 10)

##Crear lienzo del gráfico
fig = lienzo.crear_figura()

##Leer excel
spiralization_dataframe = excel.leer_excel('D:\Cindy\Ingeniería\Maestría\Resultados\R2L\Summup data.xlsx', 'Spiralization_triplicate')

##Arrays lote 1

##ARL Lote 1
arl1_day12 = excel.crear_array(spiralization_dataframe, 'ARL_12', 0, 20)
arl_prom_1 = np.average(arl1_day12)
arlsd_1 = np.std(arl1_day12, ddof=sample_sd)
arlsem_1 = sem(arl1_day12)

##S1 Lote 1
s1_day12_1 = excel.crear_array(spiralization_dataframe, 'S1_12', 0, 20)
s1prom_1 = np.average(s1_day12_1)
s1sd_1 = np.std(s1_day12_1, ddof=sample_sd)
s1sem_1 = sem(s1_day12_1)

##S2 Lote 1
s2_day12_1 = excel.crear_array(spiralization_dataframe, 'S2_12', 0, 20)
s2prom_1 = np.average(s2_day12_1)
s2sd_1 = np.std(s2_day12_1, ddof=sample_sd)
s2sem_1 = sem(s2_day12_1)
excel = Gestionar_datos()
graficar = Graficar(11, 11, 14, 12, 12, 10)

##Crear lienzo del gráfico
fig = lienzo.crear_figura()

####################################Length##############################################
##Leer excel
length_dataframe = excel.leer_excel(
    'D:\Cindy\Ingeniería\Maestría\Resultados\R2L\Summup data.xlsx',
    'Length_triplicate')

##Arrays lote 1

##ARL Lote 1
s01_day12_length = excel.crear_array(length_dataframe, 'ARL_12', 0, 20)
s0_prom_1_length = np.nanmean(s01_day12_length)
s0sem_1_length = sem(s01_day12_length)

##S1 Lote 1
s5_day12_1_length = excel.crear_array(length_dataframe, 'S1_12', 0, 20)
s5prom_1_length = np.nanmean(s5_day12_1_length)
s5sem_1_length = sem(s5_day12_1_length)

##S2 Lote 1
s4_day12_1_length = excel.crear_array(length_dataframe, 'S2_12', 0, 20)
s4prom_1_length = np.nanmean(s4_day12_1_length)
s4sem_1_length = sem(s4_day12_1_length)

##S3 Lote 1
s2_day12_1_length = excel.crear_array(length_dataframe, 'S3_12', 0, 20)