Excel formula

[Octopus]

Hi all thanks
I am underway & have just decided to add a figure at end for Zebs fixings & bolts ect that way much easier at present & will look into building a better template as I go on

I agree, much easier to do...

 

[marc8]

Hi all
just trying to build something I can use each time on the bigger jobs rather than starting from scratch each time

 

[Octopus]

Hi all
just trying to build something I can use each time on the bigger jobs rather than starting from scratch each time

Each time you do a pricing exercise, add a new sheet to the workbook, and copy and paste a "similar" job in to the new sheet and work from there. Saves time.

Also when you miss time or parts off a job, go back and add them in "red" to the costing you did before you did the job, then next time you won't forget them.

 

[Guest125]

We use an online program called Workflowmax. Really good.

 

[marc8]

Hi all many thanks

 

[Octopus]

Hi all many thanks

Good man.

Getting the best out of the forum is giving, answering questions, taking and using the "LIKE" and "Thanks" buttons

 

[Geordie Spark]

Hi all thanks
I am underway & have just decided to add a figure at end for Zebs fixings & bolts ect that way much easier at present & will look into building a better template as I go on

This may help ---->>> https://www.google.co.uk/search?q=e...VNXoNsr0UIjXgJgG#q=excel+for+dummies&tbm=shop

 

[ipf]

This may help ---->>> https://www.google.co.uk/search?q=e...VNXoNsr0UIjXgJgG#q=excel+for+dummies&tbm=shop

Thought that was 'Excell for Plummies' for a mo.....

 

[marc8]

Hi all looking at a sum I would like to crack

multiple rows example
f1*f2 =f3 then f3 *1.2 =f4 then f4 * 1.1 = f5
can I then copy this for each row on the sheet

 

[Geordie Spark]

Thought that was 'Excell for Plummies' for a mo.....

I'll have you know that in a former life I taught CLAIT. (Google is your friend )

 

[Octopus]

Hi all looking at a sum I would like to crack

multiple rows example
f1*f2 =f3 then f3 *1.2 =f4 then f4 * 1.1 = f5
can I then copy this for each row on the sheet

yes, that should work. Try it and see.

10% mark up is a bit thin IMHO

 

[Geordie Spark]

yes, that should work. Try it and see.

10% mark up is a bit thin IMHO

Very thin!! ........ Try 25% - 30%

 

[marc8]

Hello Murdoch & Geordie spark
the 10% mark up is so I can see what it is on the job, I will adjust that value to what I want after don't forget this is not strictly 10% because already included that figure in vat this is after that cell, also job is zero rated

 

[Geordie Spark]

Hello Murdoch & Geordie spark
the 10% mark up is so I can see what it is on the job, I will adjust that value to what I want after don't forget this is not strictly 10% because already included that figure in vat this is after that cell, also job is zero rated

Ok ....... no problem,

 

[marc8]

murdoch
comes out with false can't get cell to equal before I move on it works if I do the sums for each cell individually

 

[marc8]

Geordie sparks

this gives me 2 figures in my head when I go to the office, should I get the squeeze I can move not all but I know the value of each 10% that I can move & still know what I am making

 

[marc8]

Hi all
now have formulated cells & copied over very kind friend popped in & has shown me the light great adds all totals breakdowns ect.

 

[telectrix]

i googled that. still ain't got a clue.

 

[marc8]

hi all
costed job with new excel format in a few hours & indeed it help very much, would like to move this forward with a few more bits on the excel spreadsheet, does anyone know who might be able to this sort of work (paid obviously). made a massive difference was underway with pricing the job but this took it to a new level.