示例#1
0
def main():


    for format_sheet in range(2): #runs through the code twice: once without and once with formatting column widths


        if format_sheet == 0:
            network = net_summary.add_worksheet('Network')
            screenlines = net_summary.add_worksheet('Screenlines')
            # this isn't working
            #countstime = net_summary.add_worksheet('CountsTime')
            #countsall = net_summary.add_worksheet('CountsAll')
            


        highway_summary(network, net_summary, format_sheet, times, screenlines)

        if format_sheet == 1:
            colwidths = xlautofit.even_widths_single_index(output_file) 
        

        net_summary.close()
def main():


    for format_sheet in range(2): #runs through the code twice: once without and once with formatting column widths


        if format_sheet == 0:
            network = net_summary.add_worksheet('Network')
            transit = net_summary.add_worksheet('Transit')
            screenlines = net_summary.add_worksheet('Screenlines')
            countstime = net_summary.add_worksheet('CountsTime')
            countsall = net_summary.add_worksheet('CountsAll')
            amtransitall = net_summary.add_worksheet('AMTransitAll')
            mdtransitall = net_summary.add_worksheet('MDTransitAll')

        transit_summary(transit_df, net_summary, transit, amtransitall, mdtransitall)

        highway_summary(network, net_summary, format_sheet, times, screenlines, countstime, countsall)

        if format_sheet == 1:
            colwidths = xlautofit.even_widths_single_index(output_file) 
        

        net_summary.close()
示例#3
0
            excel_writer=writer,
            sheet_name="Arrivals and Departures by Hour",
            na_rep="-",
            startrow=1,
            startcol=4 * i + 1,
            index=False,
        )
    sheet = "Arrivals and Departures by Hour"
    worksheet = writer.sheets[sheet]
    if i != len(times):
        worksheet.write(0, 4 * i, " ")
arrival_mode_split.to_excel(excel_writer=writer, sheet_name="Arrival Mode Split", na_rep="-")
departure_mode_split.to_excel(excel_writer=writer, sheet_name="Departure Mode Split", na_rep="-")
writer.save()

colwidths = xlautofit.even_widths_single_index("Q:/soundcast/outputs/Regional_Centers.xlsx")

writer = pd.ExcelWriter("Q:/soundcast/outputs/Regional_Centers.xlsx", engine="xlsxwriter")
mode_split.to_excel(excel_writer=writer, sheet_name="Mode Split", na_rep="-")
work_mode_split.to_excel(excel_writer=writer, sheet_name="Work Trip Mode Split", na_rep="-")
work_dest_mode_split.to_excel(excel_writer=writer, sheet_name="Work Destination Mode Split", na_rep="-")
miles_traveled.to_excel(excel_writer=writer, sheet_name="VMT and PMT", na_rep="-")
workbook = writer.book
header_format = workbook.add_format({"bold": "True", "align": "center", "border": 1})
top_5_format = workbook.add_format({"font_color": "#006060", "bold": "True"})
bot_5_format = workbook.add_format({"font_color": "#600060", "bold": "True"})
for i in range(len(times)):
    if i == 0:
        trips_by_time[times[i]].to_excel(
            excel_writer=writer, sheet_name="Arrivals and Departures by Hour", na_rep="-", startrow=1
        )
]


location = os.getcwd().replace("\\", "/")
output_file = location + "/Weekly Forecasts/Week" + str(week_number) + ".xlsx"

for read_data in range(2):

    week_book = xlsxwriter.Workbook(output_file)
    header_format = week_book.add_format({"align": "center", "bold": True, "bottom": True})
    index_format = week_book.add_format({"align": "right", "bold": True})
    score_format = week_book.add_format({"num_format": "#0", "align": "right"})
    percent_format = week_book.add_format({"num_format": "#0%", "align": "right"})

    if read_data:
        colwidths = xlautofit.even_widths_single_index(output_file)

    for game_time in matchups:
        if read_data:
            data_book = xlrd.open_workbook(output_file)
            data_sheet = data_book.sheet_by_name(game_time)
        sheet = week_book.add_worksheet(game_time)
        sheet.write_string(1, 0, "Chance of Winning", index_format)
        sheet.write_string(2, 0, "Expected Score", index_format)
        sheet.write_string(3, 0, "2.5th Percentile Score", index_format)
        sheet.write_string(4, 0, "10th Percentile Score", index_format)
        sheet.write_string(5, 0, "25th Percentile Score", index_format)
        sheet.write_string(6, 0, "50th Percentile Score", index_format)
        sheet.write_string(7, 0, "75th Percentile Score", index_format)
        sheet.write_string(8, 0, "90th Percentile Score", index_format)
        sheet.write_string(9, 0, "97.5th Percentile score", index_format)
示例#5
0
            startrow=1,
            startcol=4 * i + 1,
            index=False)
    sheet = 'Arrivals and Departures by Hour'
    worksheet = writer.sheets[sheet]
    if i != len(times):
        worksheet.write(0, 4 * i, ' ')
arrival_mode_split.to_excel(excel_writer=writer,
                            sheet_name='Arrival Mode Split',
                            na_rep='-')
departure_mode_split.to_excel(excel_writer=writer,
                              sheet_name='Departure Mode Split',
                              na_rep='-')
writer.save()

colwidths = xlautofit.even_widths_single_index(
    'Q:/soundcast/outputs/Regional_Centers.xlsx')

writer = pd.ExcelWriter('Q:/soundcast/outputs/Regional_Centers.xlsx',
                        engine='xlsxwriter')
mode_split.to_excel(excel_writer=writer, sheet_name='Mode Split', na_rep='-')
work_mode_split.to_excel(excel_writer=writer,
                         sheet_name='Work Trip Mode Split',
                         na_rep='-')
work_dest_mode_split.to_excel(excel_writer=writer,
                              sheet_name='Work Destination Mode Split',
                              na_rep='-')
miles_traveled.to_excel(excel_writer=writer,
                        sheet_name='VMT and PMT',
                        na_rep='-')
workbook = writer.book
header_format = workbook.add_format({