Skip to content

Instantly share code, notes, and snippets.

FROM python:3
WORKDIR /usr/src/app
COPY . .
RUN pip install flask waitress
EXPOSE 8080
@hyperupcall
hyperupcall / macro.vba
Last active January 23, 2020 12:32
excel macro for updating some charts
Sub recreateEdwinForecast(dateDifference As Integer, startRow As String, endRow As String, startDate As String, endDate As String)
Sheets("Edwin").Select
ActiveWindow.SelectedSheets.Delete
Sheets("Main").Select
Range("A" & startRow & ":C" & endRow).Select
ActiveWorkbook.CreateForecastSheet Timeline:=Sheets("Main").Range("A" & startRow & ":A" & endRow), _
Values:=Sheets("Main").Range("C" & startRow & ":C" & endRow), ForecastEnd:=endDate, ConfInt _
:=0.95, Seasonality:=1, ChartType:=xlForecastChartTypeLine, Aggregation _
:=xlForecastAggregationAverage, DataCompletion:= _
xlForecastDataCompletionInterpolate, ShowStatsTable:=False