cost

Hello I am using Microsoft Excel 2013. I am working on an estimating bill of quantities for Civil Engineering. In the Excel sheet 1 is the summary sheet 2 is the Office over heads and other costs sheet 3 is earth works sheet 4 concrete. In sheet 5 I want to build up the rates to use in each of...

Man I hope I explain this correctly... I use Excel for a purchase order log. Most materials have a set cost & I have a tab in my log with all materials and use VLOOKUP to input the cost of per line item entry based on the item ordered. However, I have 2 products whose prices vary depending on...

I have a spreadsheet with items similar to below: <tbody> # item code item description item size notes cost 001 Tool Box Prepack 1UN 47.75 CONTAINS: 0001 Screwdriver 1UN 2.79 002 Ladder 1UN 87.79 </tbody> I am trying to create a macro that will search for the word "Prepack" in...

All, If I even change a name of a query or something in the last step, the query refreshes all previous queries and it's very slow. Is there a way to stop this behavior that doesn't result in me just completely forgetting to refresh older ones? It's 3-4 minutes I have a few joins which make...

Mr Excel Query I currently have two formulas that I am trying to combine sothat the combined formula provides both outputs required I wonder if anyone could assist on the basis of info provided below The formal below are the 2 current versions I have in a cell W7 I would like to combine them...

Good day. I'm setting up a worksheet that will track a contractor's daily labor, times it by their hourly rate, and provide a total cost for each week worked. That part works fine. The weekly costs are then associated with a project(or cost center). I have added an extra column to show which...

Using VBA I am trying to save data within a table column into a saved column, the difficulty is the column to copy the data from changes each month as it is time related. As an example the column titles are of a standard naming convention based on their type and the month e.g. "Cost Apr-19"...

Hi everyone I am using the code below to do a vlookup on a product code entered on sheet 'Dashboard', and then matching this product code on a separate sheet and pulling the matching cost through on 'Equipment Cost Lookup'. The code I am using below works fine, but what I am trying to achieve...

I have racked my brain with a solution for this problem and can never seem to crack it. I have to calculate Cost Per Head (CPH) for several different slices of a data set consisting of >500k rows. This is simplified, but suppose my data has a column for Month, Team, State, Account, Account Type...

The attached table, first column is the truck code,3rd column is the price of new tires, the 4th column is the depreciation cost https://photos.app.goo.gl/Gtt76KvF51Yt8xCi8 I want to depreciate the cost of new tire over 26 months So i made a formula for the 4th column...

Hi, I have a workbook that is meant to track travel costs across various departments. it has 11 department spreadsheets and one summary sheet. My issue is finding either a macro or function that will transfer the individual travel cost entries on the various sheets, to a single cost cell on the...

https://imgur.com/bh9WKg1 Hi, In Column D i am counting all duplicates In column AN i have the Cost Column AP i am counting duplicate numbers from column D What i would like to do is Calculate the Total cost by each occurrence in column D, and then divide the total cost by the count from...

<tbody> Cost Center 1234 Total Cost Center 1234 </tbody> I have a table of information where, in column A there are title showing the beginning and end of each group. I want to fill down these titles. In the example above, I want to fill down the Cost Center 1234 in the empty...

Hi, Apologies as I am an excel novice so this may be an easy fix... I am trying to pull together a costing file whereby if someone enters the following in a sheet, it would return a cost for that person working on that date: Cell A1: 03-May-2019 Cell B1: Peter Pan Cell C1: Cost to return...

hi, if 496 hours per month and actual team cost is $6895.38 per month and this arrives to $13.90 as my hourly team rate. What would be my team cost per month is the total hours 785 during the month? Please let me know how do i calculate the team cost in excel when I only have hours for the...

Hello, Is there any way to create a calculated field when there is multiple columns in pivot table? there is two fields inserted in to column section and use the number from there to create calculated field. I am trying to create Rev Prod- cost 1 field. For example: Data would look like this...

Hi Excellers ... I wonder if anyone can assist . I have a data set that contains product code and a cost associated with that code.Column A & B The issue i have is , for some reason there are more than one cost attached to each code ( weird ) Eg Code 1234 £1.99 1234 £2.99 222 £3.99 3456...

Hi All, I have a table with a Product Name in column A and a Product Price in column E. I have a 2nd table that has a Product Name in column A, From Cost in Column B, To Cost in column C, and Mark up Cost in Column D I wan to lookup each product in the 1st table into table 2, and if the price...

Hello, I am trying to create an Excel file that will scrub the output of a program I use (excel file output) into the format of the input I need for a different program. My issue arises when the output file will put the minutes of an employee into various columns of the same row based on...

Problem: I have a Matrix of G/L accounts & Cost Center Variables. There is a possibility of 20 Cost Centers and 20 G/L Account Combinations for each of my Categories. 1. For each category, there are a 20 Possible Cost Centers as well as 20 G/L Account variations. 2. I need a way to...