cost calculation

Hello all, I require a little help with forecasting the 'cost' per day based on a timeline. I have created a project timeline which each row (task) has a start and end date. Each task has a value (cost). Each task requires a 20% deposit, 4 weeks before the start date. The remaining 80% cost...

Hello board members, After performing work with a client I want to perform some sort of "post-work" cost calculation to determine if my prices are right. If I have a list of products in tab 1 with purchase price & sales price, how can I address those in tab 2 (using a drop down) I have...

Hello, I'm using Excel 2013, and windows 7. I've spent a good 4 or 5 hours Googling this and can't figure it out so I thought I'd try MrExcel! I'm new to Power Pivot / View and am trying to figure out how I can "teach" excel the relationship that exists between my data tables as it relates to...

I'm trying to come up with a cell formula to calculate monthly costs going into the future like so: <table style="width: 450px; height: 360px;" border="0" cellpadding="0" cellspacing="0"> <colgroup><col style="mso-width-source:userset;mso-width-alt:4169;width:86pt" width="114"> <col...