from openpyxl import Workbook, load_workbook
import openpyxl
import easygui
from [Link] import cols_from_range
wb = load_workbook('[Link]')
ws = [Link]
table1 = wb['TABLE']
free1 = wb['FREE']
duty1 = wb['DUTY']
a = 0
b = 0
c = 3
cc = 0
d = 3
k = 3
p = 2
q = 2
t = 3
tt = 9
ttt = 2
tttt = 3
for z in range(1, 52, 1):
for x in range(k, k + 6, 1): # IF 68 LAST THEN 73 MEANS +5
print(x)
for y in range(3, 6, 1):
if [Link](row=x, column=y).value is None:
b = b + 1
#print([Link](row=x, column=y).value)
#print(b)
else:
a = 1
#print([Link](row=x, column=y).value)
if a == 1:
[Link](row=c, column=2).value = 0
if b == 3:
[Link](row=c, column=2).value = 1
c = c + 1
a = 0
b = 0
a = 0
b = 0
for x in range(k, k + 6, 1): # IF 68 LAST THEN 73 MEANS +5
print(x)
for y in range(6, 9, 1):
if [Link](row=x, column=y).value is None:
b = b + 1
# print([Link](row=x, column=y).value)
# print(b)
else:
a = 1
# print([Link](row=x, column=y).value)
if a == 1:
[Link](row=d, column=3).value = 0
if b == 3:
[Link](row=d, column=3).value = 1
d = d + 1
a = 0
b = 0
k = k + 8
c = c + 3
d = d + 3
[Link](row=p, column=2).value = [Link](row=q, column=1).value
p = p + 9
q = q + 8
for x in range(1, 42, 1):
if [Link](row=t, column=2).value == 1:
[Link](row=tttt, column=2).value = [Link](row=ttt, column=2).value
t = t + 9
tttt = tttt + 1
ttt = ttt + 9
[Link]('[Link]')
