Chiuso

Excel Costing Sheet Rebuild and Minimize Data Entry

Ok team, please view attached the excel costing sheet.

Once read the description and looked through the file please when you submit your bid tell me briefly how much you can reduce the amount of entry’s. Only then will I consider the bid, if it is automatic proposal then I will not look at it.

What I would like from you my friends;

1: Rebuild the costing sheet so it is easy to fill in (It does not need to be flash and fancy, just easy to see the data so we can double check our cost and if we are too expensive we can go through and see where we can save money).

2: While rebuilding the sheet the focus is to reduce/minimise the amount of entry we must put in. What I mean by that Is – adding a name and formula to replace the workers and having to enter the number of hours for each one every process and replace it with Number of staff on site and how many days etc.

We do need to work out each process so when we put this into Xero we enter in one-line Grinding and per m2 price and next line will be HBE or Nuthane and m2 price.

Below is an example.

Grinding

Enter m2:

Enter Days:

Enter Staff:

Enter Overheads: (combine overheads with Nordy and vacuum and anything else that we use on every job)

Enter Travel kms: (for one day and this calculates it for everyday on site)

Enter Travel time: (for one day and this calculates it for everyday on site)

And then we do the same for product coving and screed or you might be able to reduce all of them into one small sheet I’m not to sure but please just investigate it and give me an idea how much you can reduce it by in your bid, so I understand you know what I want, and you have ideas.

Ideally, we would want to open the sheet up and enter the size of the job and it had a menu of what products/process and the calculate from this would tell us all the information automatically (I know there would be a way to calculate this, but I know this is too advance so yeah.

Now this is our costing sheet that we fill out every day to price every job that we do.

I have built this over the last couple of years with no excel experience and used basic calculations/formulas.

I have also had put no thought into the layout.

How we fill the costing sheet in;

Note: We only enter data into the red cells and only into the red cells that relate to the job because not every job is the same product.

Once we have visited the customers site to measure the floor area to work out the total square metres (m2) and decide what floor application is going to best suit the customers needs.

1. We sit down and enter the square metres (m2) into the product red cells in column B (e.g. HBE or/and Nuthane etc)

When we enter the m2 here this calculates the cost of product and the total cost of product (blue cells) will appear in column O 23,24,25 or 26 (diamond hard is missing, I have just realised)

2. We then go through the stages of the job (Grinding, Product, Coving and Screed. Coving and screed does not happen on every job) and enter hours for each guy that will be on site, travel etc.

Once we have finished entering each step we have a total per m2, total cost and total profit etc to put into our quote on Xero.

Competenze: Inserimento Dati, Elaborazione dati, Excel, Microsoft Office, Visual Basic

Vedere di più: how to speed up excel 2013, how to speed up excel 2016, excel slow calculating 4 processors, improve excel performance with large files, excel file slow to respond, how to fix slow excel file, business budget template excel, excel processing slow, electrical engineering, excel, turkish , delivery, health, translation, data entry, data processing, Balance sheet and accounts data entry, project finance statement, excel ,word ,accounting, speed typing,data entry, excel formula expert, excel formula indian expert, data entry jobs now hiring in dallas tx, data entry to complete client information for 45005000 contacts

Sul datore di lavoro:
( 8 valutazioni ) Murrumbeena, Australia

ID Progetto: #17000833

27 freelance hanno fatto un'offerta media di $196 per questo lavoro

schoudhary1553

Hi there..... Warm Greetings We came along with your request for Excel Costing Sheet Rebuild and Minimize Data Entry and we reviewed your project description. We'd like to help you with confidence and satisfying Più

$250 AUD in 2 giorni
(249 Recensioni)
7.5
ponnarasiBabu

I am an excel expert and have completed many complicated excel related tasks. Read the project specs. I understand you wanted to explain the steps, but its always better we talk directly so we can share ideas and make Più

$294 AUD in 7 giorni
(390 Recensioni)
7.3
Dhruvika111

Greetings! Hope you are doing well. I have reviewed your requirement and the attached document. The template you are looking for can be created using Few Excel Codes and formulas. I have few queries to ask you regar Più

$66 AUD in 2 giorni
(291 Recensioni)
7.5
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag Più

$250 AUD in 2 giorni
(76 Recensioni)
6.6
chriskerpini

Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. It's not Più

$270 AUD in 5 giorni
(78 Recensioni)
6.7
dgled

Hi, I looked at your file and read the description as I understand you want to fill hours manually per project/employee/etc. and to keep it in a database and clear sheet 1 for the next project/employee/etc. if it is c Più

$250 AUD in 3 giorni
(50 Recensioni)
6.3
fatimatuzzohura

Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project . Thanks Fatima

$294 AUD in 3 giorni
(140 Recensioni)
6.2
caabdul

Hi there, I am an accountant vba developer and can make this sheet compact with even more functions that you want. But the budget should be $400 and also I need to discuss whole sheet with you. If you are interested, Più

$400 AUD in 10 giorni
(58 Recensioni)
6.0
sonarkaushik

I am very able to create a excel costing sheet to minimise the data entry. I am ready to start regards

$133 AUD in 3 giorni
(99 Recensioni)
6.2
renesontiongson

Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$200 AUD in 3 giorni
(70 Recensioni)
5.4
mohds2

Hello, I am a EXCEL EXPERT - Macros(VBA) with 10 years of Exprience. I have already completed About 2000+ On Various Freelance Websites I can give you quality work in quick time Thank you Mohammed Sutarw Più

$55 AUD in 3 giorni
(44 Recensioni)
5.6
SShtv

I have a lot of practical experience in Excel. Including the development of databases and User Forms. Your task is clear to me and I am ready to execute the project for the 100 USD. For example, I send a screen of one Più

$75 AUD in 2 giorni
(54 Recensioni)
5.5
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. I have already built a project costing app in Excel VBA, and think, with sli Più

$225 AUD in 3 giorni
(30 Recensioni)
4.9
$155 AUD in 3 giorni
(23 Recensioni)
4.1
Ashisjena2015

Hi, I'm an advanced excel expert. I will help you right now. Thank you!................................................................................

$100 AUD in 0 giorni
(19 Recensioni)
4.2
TechnoGuruu

Hi, I have checked your post as well as existing excel sheet. You explained it very well. So, you want a job work costing calculator sheet. I understood your requirements. So for this we have to design few master sh Più

$222 AUD in 7 giorni
(9 Recensioni)
3.5
sanjibsahanew

Hi I would like to work for you. I will provide highly credible excel sheet with my senior level experience. You may validate my profile which is also certified as “Preferred Freelancer” and the highest trust score Più

$150 AUD in 5 giorni
(7 Recensioni)
4.1
$222 AUD in 3 giorni
(8 Recensioni)
3.1
khurram1984

We will make the format cleaner. Use If Formula to include / exclude cost for different projects. Us link function to limit data entry to only specific cells. Make multiple sheets for calculation. Make a Dashboard Shee Più

$140 AUD in 3 giorni
(5 Recensioni)
2.9
HelloEpisode

Hello, Having seen your project post, I would like to submit my bid for the same. Reading through your post, what comes to mind is that you are trying to create an easy system for yourself or your team members to e Più

$555 AUD in 20 giorni
(1 Recensione)
2.9