Skip to content

Instantly share code, notes, and snippets.

@hyperupcall
hyperupcall / meta.yml
Last active February 10, 2020 03:14
my cloud init snippets
instance-id: 60a5a5b4-5c2f-4b7c-ade5-1d07483a2725
@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