I have a query regarding making a Excel Sheet for Daily sales.
here I go,
Well i want to make an Excel Sheet where in I just need to enter the Date, Invoice Number , Product , No of Product and rest it should calculate the VAT (Rounding Off) amount N den the Grand Total..
I am trying to build a sales sheet that will keep all the records during the month but every day it refreshes to a blank sheet, then allowing users to flick back to a previous day and all the data from then is still saved?
I think this is possible in excel as I am sure I have seen a working sheet before but I don't know where to start or even what the process would be called in excel?
I have daily basis monthly sales. Now I want to summarize into monthly gross. Pls look attached file. I am looking for a formula to summarize January daily sales from date 1st to 31 st as of just January and and sum of each day gross.
I'm trying to build a formula that allows me to see which item is the highest trending over a period of time I input.
I figured out the way how to select data between specific Start and End dates, but don't know how to interpret "trending" in a formula.
I was thinking maybe highest jump from beginning to end of interval, but what if it's a new item that was launched halfway through the interval and does poorly throughout, that would still be "trending" under that rationale....
I want to track daily sales of a shop with the tenders (Cash, Master, Visa)seperated.
Everyday there will be a file ctp.dbf from a folder YYYYMMDD (previous day date) which contains sales details.
I tried to use sumif commands and everything is working fine. everytime i have to open book.xls and from it I do a files>Open to open the ctp.dbf for the calculation to be done. is there a way where by i can open 1 file and everthing i calculated properly?
Also this book.xls can only do for 1 day how can i go about having the daily sales detail of the month (look something like sales summary.xls) or even year in 1 excel file?
attached is book.xls and sales summary.xls for reference.
I am trying to determine the top contributors to 50% of sales based on cumulative percent of sales (see attached file). I can determine if percent of sales is less than 50%, but I need to include the person that pushes the group of top performers over the 50% mark.
I have a sales level that I need to track...My rolling 12 months' sales must be $85,000 and my currently monthly sales must be $7,000. I have a sheet that tracks the $85,000 and tells me what I need to achieve that, but I haven't figured out how to include the $7,000 monthly minimum....
The chart below is what I have. So for example, this month it's telling me I only need to sell another 3016.46 to hit the $85,000 rolling 12, but I actually need to hit $4821.79 to meet the $7k minimum.
Actual Rolling 12 Goal Sep 2012 5,367.24 73,663.30 Oct 2012 5,649.93 69,496.28 Nov 2012 14,163.38 73,451.30 [code]....
I have created a chart on excel for us to track daily sales but also to figure sales tax so we know what to send the IRS each month. We have been figuring the sales tax ourselves and filling in the chart on excel but I would like to create a formula that automatically does it for me based on total sales.
I am trying to create a spreadsheet that uses a selection criteria based on different sheets within a workbook to output a costing quote, anything i can use as a template? I will post the sheet that i am working on that I need to combine into a working book.
I am making a sheet to track the daily cycles of a machine. I need to get the information from the "meter reading" column to populate in the " cycles recorded" cell. I'm very new to this and need a formula to use to track the changes in column D on the attached sheet that will populate changes in cell D4.
i have facing a big problem nowadays.problem is that, i have to regularly update manually(copy & paste) "oil filling", " stock" & "meter reading", coming from every day by the supervisors of our company for verious sites spreading accross the our state, nearly 1305 site. i have attached the master file(which should be updated) with the reports coming from the supervisors(Rosan & Jhon) in another sheets. the master file is same form as i given. is their any way of automatic update by any macro.
In cells A4 to A54, their names are displayed. In cells I4 to I54, their total sales are displayed.
Starting in cell B59 and C59 I'd like to display their name and sales respectively.
Also in column I I'd have a second value which would be a total of each department. Would it be possible to leave this data out of the formula? No big deal if I have to put that value in the next column.
I want to restrict the value entered on a sales sheet to force the value to be over 15% margin. In column M you enter a value in column N it report the margin. I want to force the value in M to give a minimum 15% in column N or report an error.
So, I'm trying to create a database, of sorts. I run several reports every morning that leave me with the information I need, but I would like to be able to store them in a master sheet, thus creating a database. That master sheet will be used by my co-workers and, at times, my customers or boss. Add in a few hundred new lines every day and it becomes a task in itself just to keep the spreadsheet up to date, manually. I'm only needing to do this now because the system I use now will be shut down starting next Monday. I (someone who has never had any formal excel training) have been tasked with creating a new way to track orders.
I can create a unique identifier tag for each line, but I don't know how to program or create a macro/equation to be able to filter and replace values in the tag's row, based solely on the tag. The combination of columns A&B in my test report will give me the unique tags. From there, I need columns E-L to be able to be updated from the new reports each morning.
If Sheet 2 contains a list of items that I have updated during the day and wish to place into the master sheet (Sheet1). I don't know the language needed to write the macro and any necessary equations.
My goal is to have my reports dump information into a master sheet, but only replacing/adding onto existing rows and columns that correspond with each other and creating new lines when no pair is found.
I've attached what my report should look like after I've filtered out the unneeded information. It will be this, every day, except with a few hundred more lines.
Imagine Sheet 1 is the master sheet and sheet 2 is the newly uploaded information.
One of my job responsibility the following up our store stock, usually we consume constant daily value form our stock, as example we used daily 200 mt of corn, 150 mt do soya bean meal and so on, I would like to creat excel sheet to deduct this value from the previous column daily automatically.
I have set up a datasheet with information to be used in generating several pivot tables:
Column A - Our Invoice Number Comunn B - Vendor's Invoice Date Column C - Type of Vendor (Labor, PM, Subcontractor, Material, or Equipment) Column D - Vendor Name Column E - Vendor Invoice Number/Time Classification (Column C is Labor, PM, this is either Regular Time or Overtime. If Column C is Subcontractor, Material, or Equipment, the Vendor's Invoice Number is enetered.) Column F - Labor Hours Worked (Column C is Labor or PM, a value is entered, if not, formula enters "N/A") Column G - Labor Rate ((Column C is Labor or PM, vlookup value is entered, if not, formula enters "N/A") Column H - Amount Billed ((Column C is Labor or PM, formula multiplies rate by hours, if not, enter the amount of the Vendor's invoice.) Column I - Mark Up Percentage Column J - Mark Up Amount Column K - Total Amount Billed (Column H + Column J)
I need to set up a daily job sheet (like and invoice) for each date listed under Column B. For each day, I need to generate a daily job sheet showing all of that day's information. The location of the information is based on the value in Column C - Subcontractors's data go in one spot on the sheet and Labor costs go in another place.
I have around 250 Employees Camp Meals Statements. Each day we prepare a Excell Sheet and enter the details file attached for easy reference Im manually calculating the Totals in each sheet if emp takes meals we marked as Y otherwise N based on that i want the total meals daily. One more thing Base on employeed code i want the monthly statement in another sheet same file attached..
I need to copy the values of a range on the weekly sales worksheet to the monthly sales worksheet. The last column is the total on the weekly sales. Part of the heading of the total column is the week ending date (e.g. 10/17/2009. On the Monthly Sales I have the months in columns by week ending (e.g. 10/17/2009).
Range I4:I28 to the monthly sales worksheet by date.