Home

Help with External Data

%3CLINGO-SUB%20id%3D%22lingo-sub-653990%22%20slang%3D%22en-US%22%3EHelp%20with%20External%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-653990%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20company%20that%20generates%20automatic%20funds%20in%20and%20out%20statements%20for%20each%20ATM%20in%20our%20system%20in%20an%20Excel%20sheet%20format.%20Sadly%2C%20it%20does%20not%20break%20down%20by%20machines%2C%20but%20rather%20day%20by%20day.%20My%20goal%20for%20this%20is%20to%3A%20create%20an%20automatic%20statement%20that%20groups%20the%20data%20of%20funds%20in%20and%20out%20from%20each%20machine%2C%20which%20all%20have%20unique%20ID%20names.%20The%20website%20i%20get%20the%20data%20from%20lets%20me%20select%20the%20date%20ranges%2C%20but%20breaks%20down%20by%20each%20day%20with%20each%20machine%20funds%20in%20and%20out%26nbsp%3B%20below%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wanting%20to%20create%20a%20system%20where%20I%20can%20do%20the%20following%3A%3C%2FP%3E%3CP%3E1.%20Import%20the%20premade%20Excel%20sheet%20into%20some%20location%2C%20maybe%20OneDrive.%3C%2FP%3E%3CP%3E2.%20When%20this%20file%20is%20uploaded%2C%20I%20want%20another%20Excel%20document%20to%20generate%20a%20automatic%20statement%20that%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Ba.%20Creates%20a%20sum%20of%20each%20machine%20from%20each%20date%20range%2C%20for%20the%20columns%20%22Funds%20In%2C%20Funds%20Out%2C%20Net%20Funds%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20I%20also%20need%20Excel%20to%20calculate%20tax%20and%20such%20from%20this%20data%20into%20columns%20next%20to%20it%20but%20I%20can%20do%20this%20myself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20has%20any%20suggestions%20or%20knows%20who%20I%20can%20contact%20that%20would%20be%20great.%20I%20don't%20really%20know%20who%20to%20consult%20in%20making%20such%20a%20detailed%20Excel%20sheet%20system.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-653990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
jayppatel1115
Occasional Visitor

Hello,

 

I have a company that generates automatic funds in and out statements for each ATM in our system in an Excel sheet format. Sadly, it does not break down by machines, but rather day by day. My goal for this is to: create an automatic statement that groups the data of funds in and out from each machine, which all have unique ID names. The website i get the data from lets me select the date ranges, but breaks down by each day with each machine funds in and out  below it.

 

I am wanting to create a system where I can do the following:

1. Import the premade Excel sheet into some location, maybe OneDrive.

2. When this file is uploaded, I want another Excel document to generate a automatic statement that:

     a. Creates a sum of each machine from each date range, for the columns "Funds In, Funds Out, Net Funds"

 

3. I also need Excel to calculate tax and such from this data into columns next to it but I can do this myself.

 

If anyone has any suggestions or knows who I can contact that would be great. I don't really know who to consult in making such a detailed Excel sheet system.

 

Thanks