Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can someone help me indent this python code correctly so I can run it? here's the code: import xlwt from xlwt import Workbook from decimal

can someone help me indent this python code correctly so I can run it?

here's the code:

import xlwt from xlwt import Workbook from decimal import *

#create a workbook wb = Workbook() #create a sheet sheet = wb.add_sheet('Sheet')

#percentages list percentages = [23.6, 38.2, 50, 61.8, 78.6, 113, 123.6, 138.2, 161.8] #add first row for i in range(len(percentages)): sheet.write(0,i+1,str(percentages[i])+'%')

#user input n = int(input('Enter number of elements: ')) #second row starts from index 1 row=1 print('Enter numbers: ') for i in range(n): #User input val = float(input()) #Add entered value to first column of the row sheet.write(row,0,str(val)) #calculate each percentage prev = "" for j in range(len(percentages)): result = (percentages[j]/100)*val #write result to sheet by rounding to nearest whole number using quantize method current = str(Decimal(result).quantize(Decimal("1"))) if(prev != current): sheet.write(row,j+1,current) prev = current #increment the row by 1 row+=1 #save Workbook as xls` wb.save('percentages.xls')

thanks to anyone who helped!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Development For Dummies

Authors: Allen G. Taylor

1st Edition

978-0764507526

More Books

Students also viewed these Databases questions

Question

LO4 Provide an overview of four challenges facing HR today.

Answered: 1 week ago