Home

Forecasting

%3CLINGO-SUB%20id%3D%22lingo-sub-281984%22%20slang%3D%22en-US%22%3EForecasting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281984%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20below%20table%20coming%20out%20from%20power%20query%20after%20unpivot%20and%20i%20would%20like%20to%20develop%20formula%20to%20forecast%20automatically.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20i%20have%20actual%20data%20for%20Jan%2C%20Feb%20and%20Mar%20(Number%20of%20WO)%26nbsp%3Band%20i%20would%20like%20to%20forecast%20for%20Apr%2C%20May%20and%20June.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20more%20than%201000%20items%20lists%20-%20Any%20help%20would%20be%20really%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EItems%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3BDate%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3BActuals%26nbsp%3BForecast%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Jan%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Feb%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Mar%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Apr%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-May%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Jun%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Jan%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Feb%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Mar%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Apr%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-May%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Jun%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Jan%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Feb%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Mar%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Apr%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-May%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Jun%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Jan%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Feb%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Mar%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Apr%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-May%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20Work%20Order%3C%2FTD%3E%3CTD%3E18-Jun%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Jan%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Feb%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Mar%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Apr%3C%2FTD%3E%3CTD%3E14%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-May%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20acquisitions%3C%2FTD%3E%3CTD%3E18-Jun%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Jan%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Feb%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Mar%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Apr%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-May%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENumber%20of%20capitalization%3C%2FTD%3E%3CTD%3E18-Jun%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EI%20have%20attached%20my%20excel%20spreadsheet%20along%20with%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-281984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Lionel Charley
Occasional Visitor

I have below table coming out from power query after unpivot and i would like to develop formula to forecast automatically.

 

Below i have actual data for Jan, Feb and Mar (Number of WO) and i would like to forecast for Apr, May and June.

 

I have more than 1000 items lists - Any help would be really appreciated.

 

Items                                       Date      Actuals Forecast

Number of Work Order18-Jan10 
Number of Work Order18-Feb9 
Number of Work Order18-Mar15 
Number of Work Order18-Apr00
Number of Work Order18-May00
Number of Work Order18-Jun00
Number of acquisitions18-Jan6 
Number of acquisitions18-Feb8 
Number of acquisitions18-Mar10 
Number of acquisitions18-Apr00
Number of acquisitions18-May00
Number of acquisitions18-Jun00
Number of capitalization18-Jan12 
Number of capitalization18-Feb4 
Number of capitalization18-Mar9 
Number of capitalization18-Apr00
Number of capitalization18-May00
Number of capitalization18-Jun00

 

 

Number of Work Order18-Jan10 
Number of Work Order18-Feb9 
Number of Work Order18-Mar15 
Number of Work Order18-Apr16 
Number of Work Order18-May00
Number of Work Order18-Jun00
Number of acquisitions18-Jan6 
Number of acquisitions18-Feb8 
Number of acquisitions18-Mar10 
Number of acquisitions18-Apr14 
Number of acquisitions18-May00
Number of acquisitions18-Jun00
Number of capitalization18-Jan12 
Number of capitalization18-Feb4 
Number of capitalization18-Mar9 
Number of capitalization18-Apr15 
Number of capitalization18-May00
Number of capitalization18-Jun00

I have attached my excel spreadsheet along with this

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies