estimate

Hi, Using O365. I have: Install Date of new equipment over various dates (fairly recent) Repair records for the equipment since the install date Some equipment is no new, no repairs as of yet. How can I use the data to estimate a number of repairs/equipment/year? Thanks, -Lou

Trying to find a workaround to show a cumulative '% percent of' (currently using 'show values as'), so running up to 100% by the end of the year, hopefully more if we exceed sales expectations. I have uploaded an example of the information i am working with as it may help to see the data - I...

I have a workbook for internal estimating that several people in my company use. I am adding VBA to make the workbook more user friendly and efficient. 1. User opens workbook and is prompted by a Y/N Textbox. "Would you like to start an estimate" a. User presses "No", then estimate opens...

I have assigned a macro to a button that will operate once. It is creating an estimate number using date, customer last name and a random number. Once it has run, subsequent presses of the button do generate the Already Run message which is what I was trying to do. I need to be able to run it...

Hello, So far I have this but I can not get it use the next line inside of a table. It always uses the next row after the end of the table. Any thoughts? strName = InputBox("What is the Estimate #") strName1 = InputBox("What is the Prospects Name?") strName2 = InputBox("What is the Prospects...

hi all, So my question is, I have and two tabs ("Materials" and "Delivery") I would like to import into and existing workbook we use for quotations. the tab "Materials" work perfectly under the code below: Private Sub CommandButton1_Click() 'Read Data Dim wsname As String Dim hours As...

My active worksheet called "Estimate", includes my billing items from a formula in cells B13:B39, and a user entered month in cell M8 for the period the statement is being created for. The Pivot table is on a worksheet called "Pivot Data", and contains the information I need to summarize in...

Hi All, I apologise if this question has been asked before, I've tried searching for an answer to no avail. I'm trying to estimate data for a year that has not ended yet. Ok, let's say I have a dataset of unit orders from 2008 to August of current year. I want to build a table and chart that...

I have a graph with two lines (2012 and 2013 data). I want to calculate the average growth rate (they only go up over time) between the two and the average growth rate from one week to the next for 2013 only. The x axis is dates (e.g. July1-8) and the y-axis is money. When I tried other formulas...

I have some historical data from year 2009 till now, for each month of the year and for 7 items. What I want is to make a report table (same or different Sheet) to automatically show a simple estimate of data for the future months (based on actual ones), every time I enter data for a month. I'm...

I have a spreadsheet that I've created for us to estimate repair costs for customers. I would like for the Estimate # to automatically change everytime they open the sheet to create a new estimate. The assigned cell is R3. The estimate # can start at 0001. I'm not great at VBA, so step by...