Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def percentage(siteElement, excelCell, columnName):
- text = siteElement.text
- textrep = text.replace(' ', '').replace(',', '.')
- first_element = float(textrep)
- second_element = float(excelCell.value.replace(',', ''))
- if (first_element != second_element):
- if (first_element > second_element):
- percent = 100 * first_element/second_element - 100
- diff = first_element - second_element
- percent = abs(percent)
- diff = abs(diff)
- # print (percent)
- print(round(diff, 2), "$", columnName)
- if (percent > 10):
- print("+", round(percent, 2), "%", ' ', columnName)
- else:
- percent = 100-100*second_element/first_element
- diff = second_element - first_element
- percent = abs(percent)
- diff = abs(diff)
- # print (percent)
- print(round(diff, 2), "$", columnName)
- if (percent > 10):
- print("-", round(percent, 2), "%", ' ', columnName)
- else:
- print("ok")
- percentage(buyouts, d1332, "Выкуплено заказов на сумму")
- percentage(cs, e1332, "Услуги КС1")
- percentage(cod, f1332, "Денег получено от выкупленных заказов")
- percentage(cs2, g1332, "Услуги КС2")
- percentage(uncod, h1332, "Денег не получено от выкупленных заказов")
- percentage(cs3, i1332, "Услуги КС3")
- percentage(debtsum, j1332, "Сумма задолжности")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement