Template For Event Costing

May 9, 2009

I have been googling for a excel sheet, but just seem to find the right one. Then I found this great looking forum so I know someone here must beable to help me.

This is what I need:

I host an event twice a month I have cost that change every two weeks and would like a nice looking sheet that I can puch the numbers in to then it will tell me how much I need to charge each guest. I have cost that are always the same and other that are not. If this isnt clear here is an example...

Week1 week2 Month Year
Milk 2.50 2.50 5.00 130.00
Eggs .75 .75 1.50 39.00
Vodka 2.50 2.50 5.00 130.00
Lawn Darts 10.25 10.25 20.50 530.00


Host 75.00 75.00 150.00 3900.00
room 125.00 125.00 250.00 6500.00

total 216 216 432 11232.00

Number of guest week1 week 2 month year
25 30 55 55

cost of each guest 8.64 7.20

View 9 Replies


ADVERTISEMENT

Formula For Costing Roster

Aug 6, 2008

Been trying to come up with a formula that I can use in cells to cost a roster.
What I want to be able to do is just input start times into cells and the hours worked is automatically costed out in another cell. The trouble I have been having is that different start times attract a shift allowance eg. before 05:00 you get a 20% loading for the whole shift, between 07:00 and 19:00 is 10% and any finishing time after 19:00 is 15%, don't know how to write the formula to do this.

View 10 Replies View Related

Creating Auto Costing Sheet For Pre-Sales Function?

Oct 9, 2013

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.

View 2 Replies View Related

Copy And Rename Sheet (template) From Cell Value Entered In Template?

Feb 21, 2013

how to create a copy of my employee attendance template. Is there a way to create a copy of the template by entering an employee name in the "name" cell of the template and it automatically renames the sheet that employee name and also saves or recopies the template for use with the next employee?

View 8 Replies View Related

Updating Excel Files...Old Template To New Template?

Jan 5, 2009

I Have a number(30+) of excel files based off of one template. I have since updated the template, thus making the the old ones obsolete. Is there a way to update the older files to use the new template without having to copy and paste the addition's row by row column by column?

None of the additions to the template will change the placement of existing data, nor will it change the data itself. It will however add Values to cells that were previously empty.

Hints, Tricks, or Ideas?

View 9 Replies View Related

Add A New Sheet From Template And Edit A Template

Apr 23, 2009

1)
I created a one-sheet template, and a new workbook from that sheet. When in that new workbook I go Insert>Sheet>Other and select the aforementioned one-sheet template, Excel crashes, or if not, it adds the new sheet, but then no longer saves the workbook and starts producing error messages (like: "An unexpected error has ocurred. AutoRecover has been disabled for this session of Excel.").

1a)
Now, the complication is that this is working when I do a model operation with a generic template sheet. So I checked the template that I actually want to form sheets after, and Excel finds no errors, nor does it's name contain any unusual characters. What could Excel prevent from working with a template like this?

2)
How do I edit a template? The only way I can find is to manually find the spot in finder, open, and save with the same name. But: if I do that, the documents basing on that template don't change accordingly. If they're intended not to, the whole template procedure makes no sense. I could then just as well copy a file. — I've been searching for tutorials on that, but google doesn't even return a single result on Excel "edit template". Therefor my very basic question here.

View 5 Replies View Related

Exporting Data From Master File To Template File (Auto-Populate Template)

May 6, 2014

I've attached 2 test files, one is the database master file containing the projects (each row represents a project, unique reference number in column A) and the other is the blank template file i'm hoping to export data into and then save down with the naming convention "column A_column B.xlsx"

Kept the test files simple but would need to modify any code to apply to much larger database consisting of many more fields etc.

Master.xlsx‎
Template.xlsx‎

View 9 Replies View Related

Copy From Template And Select Any Sheet That Starts With S And Copy / Paste This Template To

Aug 19, 2008

I have a list of invoice #'s on a sheet named "Temp Sheet".

I have a VBA macro that created a new tab for each entry and named it the invoice #. So basically the vba code created a new tab ( based on the number of invoice #'s on my list ), and named each tab an invoice number. So if I had a list of 10 invoice #'s, named S1-S10, the vba code created 10 tabs, named S-1, S-2,. S-3.....

Now to my question.
I have a template sheet I want to copy from ( "Template" ), and select any sheet that starts with "S", and copy/paste this template to.

View 9 Replies View Related

Export Data From A Template File To Total List File Using Macro In Template File

Dec 18, 2012

I have a template file for ordering trafolyte and steel plates. I have added macros to this template file. The existing macros do the following (shortly described):

Macro 1: clears order
Macro 2: update order date + send a read only file to the supplier of plates + save a read only copy of the file into one of three folders acc to info in one of the cells.

It's the Macro 2 I want to edit.

I want to add a "function" which copy a selection of data.column A to N from row 12 to 548 but only the rows where there is a value in column A.

Row 1 to 11 includes standard order info and Macro buttons.
Row 11 includes the heading for order data.

For everytime someone click on the Macro 2 button in the template file, I want the selection to be paste into the first "available" row in a "Total list" file.

The "Total list" file may have to be open (or a function to open, paste selection and then close the "Total list" file may be added)

File and Folder info:

To simplify suggestions, the following file and path info can be used (I can change to the correct later):
Template file name: template_order.xlsm
Template file location: \servershared emplate

Total list file name: total_list.xlsx
Total list file location: \servershared otal

Selection info:

The template file exists of a "general order info area" A1:N10
The column heading for order data is located at A11:N11
The selection to be copied is A12:N550 - But only rows where column A includes data (not empty).
(If the spesific order consists of 14 plates than there will be item no 1-14 in column A and I then I want to copy A12:N25 (row 25 will be item 14).

When I try to use record macro it looks like it only records what's happening in the template file - It doesn't record the pasting in the total list.

View 1 Replies View Related

Worksheet Change Event :: (ByVal Target As Range) Event In Module After Creating A Sheet

Mar 27, 2009

Is there a way to write a Worksheet_SelectionChange (ByVal Target As Range) event in module after creating a sheet in VBA? I constantly delete a sheet, then repopulate it with a new one that is empty, but I need to add some code that happens if they should change a particular cell. It worked when I ran it on a worksheet without refreshing, but as soon as I cleared and repopulated the sheet, it was gone. Is there a way to preserve this?

View 9 Replies View Related

Change Event Causing Event To Fire Again

Aug 7, 2006

I have the following code, which works perfectly:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim TotalDays As Integer

TotalDays = Range("C65536").End(xlUp).Row + 1

The code points to the next blank cell so the user can input a value. Each time the user enters a value I want to re-run the code so that the colour of the cell changes.

However I also want to perform various calculations on the sheet. However this means the sheet is being changed and so continually repeats my code.

How do I add the following, to my previous code?

Range("E8").Value = Cells(7, 6) * 2.5

View 9 Replies View Related

Event Sub From Run Function Event

Aug 5, 2014

Looking for the syntax that will allow me to code an event sub routine, based off the event of a specific function e.g. findnum being run.

View 14 Replies View Related

CSV Copy To Template Using VBA

Oct 15, 2008

I need to write a VBA code which will read the CSV files from a folder by opening the CSV files , then copy the contents of csv file into another EXCEL template already present in the same xls template.

The XLS template has tabs named like "UAT2D" and i want the csv file data to paste in the particular xls tab which is blank initially. But what is happening my code open the required CSV , copy the data and insert the CSV into the xls template by creating the new tab. see the code A below

View 5 Replies View Related

Schedule Template

Oct 16, 2009

We have huge restrictions on hours, and to avoid inputting, then revising the schedule into my companies scheduling module, then having to change it again when the boss looks it over, it's just confusing.

Anyway, I'll get to the point, I want to add the hours up in a row of cells for the week sunday through saturday. Like so:

1100-2100 | 1100-2100 | OFF | 1100-2100 etc... I want it to add these cells hours up and have the total end up in the 8th cell.

Is this possible? I am a new excel user, or at least, setting up my own sheet.

View 10 Replies View Related

Template For Worksheet

Mar 22, 2008

I am creating a large workbook using the same worksheet "form" over and over. How can I use a shortcut or someother method to add the form to a new sheet without having to copy and paste from the last sheet?

View 9 Replies View Related

Understanding Template

Dec 8, 2008

I have a workbook with several worksheets and numerous userforms, commandbuttons and macro's. I want to prevent people from saving over the workbook once they have used it, but allow save as using a different workbook name.

I tried saving the book as .xlt, but then when I reopen it and make material changes, it lets me save over it. I have't worked with templated before, is there something I am doing wrong?

View 9 Replies View Related

SaveAs From Template

Apr 29, 2009

I'm running a macro in a template and trying to save the results to a different folder.
I want the file name to be blank in the Saveas Text box of the UI also. Unfortunatley my code is bugging out & I can't work out why.

ActiveWorkbook.SaveAs Filename:="C:", FileFormat:=xlNormal _
, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

The save to path does change so I want to be able to change the save location.

View 9 Replies View Related

New Sheet As Template

Nov 24, 2009

I made a thread about this last week but I don't think I was very clear about what wanted so now I'm going to describe it more in detail.
I work at a place that takes care of boats and also offers to store them during the winter. Now I have created a template which consists of one work order and one invoice so when a new customer arrives I open up my template and fill out the work order. But then when the customer comes back next year and wants something else done with his boat I need a new work order but in the same document. So I need to add another work order as a new sheet. The only way I can think of now is to copy an old work order and then paste it but that would take too long time to do every time and I would also have to change the width of all columns. So my question is: Is there some easier way to do this? Basically what I want is a quick way to add either a work order or an invoice as a new sheet.
Link to my old thread: http://www.mrexcel.com/forum/showthread.php?t=430633

View 9 Replies View Related

Template Or Readonly

Jul 13, 2006

I do not want the user to be able to change the workbook.

I will put a small macro to export any specific sheet which the user can change into to a new workbook.

For the main file (which the user can interact with, but is not allowed to overwrite), what is the concensus- make it Readonly or save as a template?

I think the template option looks quite fancy. I also think, but I'm not sure, that a ReadOnly can be undone by the user?

I'm leaning towards template format, but I don't really know it. Are there any significant disadvantages?

View 3 Replies View Related

Deploy Template With Vba

Jul 6, 2007

I recently deployed a single-page spreadsheet intended to be added to existing workbooks (it generates a hiearchical view of pricing in a WBS structure), and it includes some UDFs and subs.

I was hoping I could save it as a tempate, but when inserted as a template, it didn't bring along its code module. I ended up instructing someone to copy the sheet to the intended workbook, and had them open the VBE to drag the module over. There is surely a better way!

I would prefer not to train people to use add-ins or mess with Personal.xls.

View 9 Replies View Related

How To Set Default To Open Or New For A Template

Dec 7, 2005

Somehow I have changed a default setting that I cannot figure out how to change back. I have various templates setup in a "Forms" folder. Normally I go to My Documents, find the template file and double click on it, and the appropriate program (usually either Excel or Word) starts and opens a copy of the template as a document. What happens now is that the program starts and the template itself opens. I have tried going to My Documents and right clicking on the file and what appears to be happening is that the default (highlighted) option is "Open" instead of "New" which is what the default used to be. How do I change it back?--

View 7 Replies View Related

Template Formula For Populate

Aug 26, 2009

I have a template (attached) that needs to be populated. It's objective is to determine the QUARTER and YTD based on MONTH. For example, there's a M shown for the month Jul, Q also shown for the month Jul (since current month is Jul, current quarter month is only Jul and not Jul, Aug & Sep), and all months up to the current month shows Y for the year row. The above is currently done manually. I need a formula that will fill in the Q and Y's automatically based on the M. Is it possible?

View 3 Replies View Related

Interest Template: How To Sum Up According To Date

Sep 9, 2009

I have created a template that I use to determine interest calculations (it is based on simple daily interest, but monthly compounding and adjusts for any variations in interest rates during the month), and it seems to work fine so far.

However, I am trying to make it better and would like to eliminate as much manual input as possible. I have attached an example of the template to help explain what I would like to achieve

The Running Balance is dependant on column "J" - Interest for the Month. At the moment, I am manually adding up interest accumulated for the month, however if I add one cell too high or miss a cell when adding, it can lead to compounded problems further down. So in short I am looking for a method that would automatically calculate "interest for the month" by adding all the amounts in column "I" (Interest Daily) at month end for that month only (dates are entered in Column B)

In the attached template, grey areas indicate capital movements and/or interest rate changes that may occur during a month (ie movement in the month in question that affects the daily interest calculated)

I hope I've covered everything!

Any help in this regard comes most appreciated. If anything is unclear, I will do my best to explain what I am trying to achieve in greater detail.

View 7 Replies View Related

Extract Information From Template

Sep 17, 2009

i have 2 sheets, one is a database sort. and the other sheet is a template tat i had design. i have inserted a filter to the database sheet that i wan to extract info from my template (diff catergory). but shows nothing,

View 10 Replies View Related

Chart Template Saving

Jan 12, 2010

I am trying to save a chart as a template but when i apply it to another chart it doesn;t have all the original formatting i did. I doesn't retain the gradient fills on the series, the fact that i've changed one series to line on a col chart??

View 9 Replies View Related

Create New Pages From A Template?

Mar 18, 2013

I have a workbook that has a total of 128 pages. The problem is that a lot of those pages won't be used. Basically I have a sheet that needs to be filled out for each day up to around 30 days, sometimes more, most times less.

Currently I have created all the sheets that I will typically need (31 daily's, 31 daily printable reports).

Data is entered into the daily (and other spots) and then with the use of formulas transferred to the report sheet which is hidden and then printable with the use of macros.

I also need to withdraw some of this information (CSV File) to be able to populate a database.

Is it possible to have my "daily" page as a template and then create the subsequent pages as I need them? (this would have to be done with a bunch of other report pages as well). For ease of use I would need all the formulas etc that I currently have to be able to be "created" as well. As an example, there is a running total of costs associated with the "daily" pages that would need to be carried forward.

View 8 Replies View Related

Merging Template Changes Into Spreadsheets

Jul 14, 2013

I have a template and several spreadsheets based on this template, and when changes are made to the template they need to be manually merged into each spreadsheet, a very painstaking, time consuming, and error prone process. Changes are mostly added rows, data tables, and macro (coding) changes. Surely there must be a better way of doing this. There must be some way of automating at least part of this process, or so I would think. I know that changes to a workbook can be tracked, but I don't shows changes to code, and I don't know if it is true for templates as well (but I suspect that it is); at least this would show me what changes to the template had been made, but maybe not changes to the code, but this is only a small part of the problem.

View 1 Replies View Related

Demand And Supply Gap Template?

Dec 14, 2012

I am looking for a template where I can have the Gap between Demand and Supply of Resources. This is to plan taking up new opportunities or not based on the supply.

View 2 Replies View Related

Before Save Code Within Template

Feb 14, 2014

I am trying to create a beforesave code within my template. The template has certain fields that are blank and when the end user enters data, I want them to be able to click on save or the blue disk and it saves it to a new location, based on their user and some of the cells within the form. I do not want the template to be saved with the data they input. The data they input is saved only when they click the blue disk and it saves to another location, with their username and certain cells in the form. Then the end user can continue using that same template for the next entry and so on. I have a beforeclose that asks them if they really want to close or not. The only time they would close, or hit the big red X is when they are done with all their entries for the day. Here is my code for beforesave:

[Code] ......

View 10 Replies View Related

Template For Raffle Generator?

Apr 23, 2014

I would like a template that allows me to create of a randomized raffle. How to create one, but need it for a raffle I am holding, where some participants have more tickets than others.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved