Home

Multiple cost prediction

%3CLINGO-SUB%20id%3D%22lingo-sub-861282%22%20slang%3D%22en-US%22%3EMultiple%20cost%20prediction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861282%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20team%20of%2050%20colleagues%20who%20travel%20to%20over%2075%20venues%20during%20the%20course%20of%20the%20year.%20Once%20their%20schedules%20are%20sent%20to%20them%20they%20are%20required%20to%20predict%20their%20costs%20for%20the%20coming%20months%2C%20if%20their%20schedule%20changes%20they%20have%20to%20update%20the%20prediction.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20is%20it%20possible%20to%20have%20a%20formula%20on%20Excel%20with%20the%20costs%20for%20each%20person%2Fvenue%20loaded%20in%20the%20background%20so%20that%20when%20they%20are%20scheduled%20it%20automatically%20predicts%20the%20costs%20for%20the%20entire%20team%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861282%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861324%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20cost%20prediction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861324%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411148%22%20target%3D%22_blank%22%3E%40Jikster%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20too%20abstract%20question%2C%20it%20depends%20on%20how%20you%20organise%20you%20data.%20If%20you%20keep%20cost%20predictions%20in%2050%20separate%20files%20that%20could%20be%20combined%20by%20Power%20Query.%20If%20in%20one%20file%20-%20most%20probably%20by%20formulas%2C%20but%20again%20depends%20on%20how%20the%20data%20is%20structured.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861345%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20cost%20prediction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861345%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20essentially%20what%20I%20thought%20was%20an%20Excel%20document%20on%20which%20every%20colleague%20is%20listed%2C%20when%20the%20initials%20of%20the%20location%20they%20are%20travelling%20to%20are%20entered%20into%20their%20row%20it%20picks%20up%20which%20colleague%20and%20venue%20and%20generates%20a%20predicted%20cost%20(based%20on%20data%20previously%20gathered%20and%20keyed%20into%20the%20formula)%20but%20I%20fear%20that%20might%20be%20too%20complex.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861407%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20cost%20prediction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861407%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411148%22%20target%3D%22_blank%22%3E%40Jikster%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20provide%20small%20sample%20file%20with%20input%20data%20(without%20sensitive%20information)%20and%20manually%20calculated%20desired%20result%20it%20will%20be%20easier%20to%20discuss%20concrete%20formula(s).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jikster
New Contributor

Hello, 

 

I have a team of 50 colleagues who travel to over 75 venues during the course of the year. Once their schedules are sent to them they are required to predict their costs for the coming months, if their schedule changes they have to update the prediction. 

 

Is is it possible to have a formula on Excel with the costs for each person/venue loaded in the background so that when they are scheduled it automatically predicts the costs for the entire team? 

 

 

3 Replies
Highlighted

@Jikster 

It's too abstract question, it depends on how you organise you data. If you keep cost predictions in 50 separate files that could be combined by Power Query. If in one file - most probably by formulas, but again depends on how the data is structured.

@Sergei Baklan 

 

So essentially what I thought was an Excel document on which every colleague is listed, when the initials of the location they are travelling to are entered into their row it picks up which colleague and venue and generates a predicted cost (based on data previously gathered and keyed into the formula) but I fear that might be too complex.

 

@Jikster 

If you provide small sample file with input data (without sensitive information) and manually calculated desired result it will be easier to discuss concrete formula(s).

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