Đang Thực Hiện

Excel Job by dwright16

Hi Sasi, I need some more things done for the cash flow model that you have helped me with. I have attached the spreadsheet that I need the work done. Basically we have roughly 400 gas stations in 14 different companies. I would like to be able to choose a company on a summary tab (like slicer’s in pivot tables maybe?) and have the cash flow data populate. Raw data is imported to the “gallons”and expenses”worksheets. Then the formulas calculate when cash is collected or paid out in the “cash flow detail”worksheet. Maybe when you select a company in the summary tab (Cashflow roll-up worksheet) you can apply some type of filter in the gallons sold and expense worksheets and use a sumif in the cash flow detail workbook? Then do a lookup in the summary workbook from the cash flow detail workbook? Or maybe I don’t need to have both a cash flow roll up tab and a cash flow detail tab? Also, I don’t need to show individual store volumes in the cash flow detail tab, when can just sumif by brand right?( in rows 17-22 and 26-31 in the cash flow detail worksheet) Let me know what you think .

Thanks, Dave

Kĩ năng: Excel

Xem nhiều hơn: the cash store, sasi, Roll up, pivot tables, populate spreadsheet data, project expense spreadsheet, project populate, can apply project, need custom spreadsheet, calculate store data, pivot tables project, expenses project, raw data summary, cash flow spreadsheet, work expenses spreadsheet, cashflow, spreadsheet expenses, dave may, project cash flow, custom flow, slicer, project cash flow spreadsheet, custom spreadsheet, custom tables, may apply project

Về Bên Thuê:
( 5 nhận xét ) `Washington, United States

ID dự án: #4546019

Được trao cho:


Hired by the Employer

$15 USD / giờ
(4 Đánh Giá)