wb = load_workbook('./trekking3.xlsx')
sheet1 = wb['Справочник']
sheet2 = wb['Раскладка']

calories = dict()
squirrels = dict()
fats = dict()
carbohydrates = dict()


for cellObj in sheet1['A2':'E38']:
    calories[cellObj[0].value] = cellObj[1].value
    squirrels[cellObj[0].value] = cellObj[2].value
    fats[cellObj[0].value] = cellObj[3].value
    carbohydrates[cellObj[0].value] = cellObj[4].value

curr = 1

sumCalories = 0
sumSquirrels = 0
sumFats = 0
sumCarbohydrates = 0

for cellObj in sheet2['A2':'C100']:
    if cellObj[0].value == curr:
        sumCalories += calories[cellObj[1].value]/100*cellObj[2].value
        sumSquirrels += squirrels[cellObj[1].value]/100*cellObj[2].value
        sumFats += fats[cellObj[1].value]/100*cellObj[2].value
        sumCarbohydrates += carbohydrates[cellObj[1].value]/100*cellObj[2].value

    else:
        #print(f'Day: {curr}')
        print(floor(sumCalories),
            floor(sumSquirrels),
            floor(sumFats),
            floor(sumCarbohydrates))
        sumCalories = calories[cellObj[1].value]/100*cellObj[2].value
        sumSquirrels = squirrels[cellObj[1].value]/100*cellObj[2].value
        sumFats = fats[cellObj[1].value]/100*cellObj[2].value
        sumCarbohydrates = carbohydrates[cellObj[1].value]/100*cellObj[2].value
        curr = cellObj[0].value
print(floor(sumCalories),
            floor(sumSquirrels),
            floor(sumFats),
            floor(sumCarbohydrates))