Framing calculator

Computerised Mount Cutters, Computers, other gadgetry.

Re: Framing calculator

Postby kuduframes » Sat Mar 22, 2014 4:54 pm

Should have included my email address -
kudu-frames@btconnect.com
kuduframes
 
Posts: 166
Joined: Thu Apr 28, 2011 6:09 pm
Location: Ewshot, Hampshire
Organisation: Kudu Frames
Interests: Art, photography

Loft

Re: Framing calculator

Postby Muffspups » Mon Apr 14, 2014 1:27 pm

Hi Colin, i too am just getting into framing and could do with all the help i can get

could i get a copy with the arqadia mouldings part as well

Thank you

vince@sportsrecycler.co.uk
Muffspups
 
Posts: 1
Joined: Mon Apr 14, 2014 6:40 am
Location: South Shields
Organisation: Experiential
Interests: Mountain biking. Framing

Re: Framing calculator

Postby carpman » Wed Apr 16, 2014 1:42 pm

Hi, if the offer is still open i would like to try your spreadsheet it out.

Many thanks

m.innes@blueyonder.co.uk
carpman
 
Posts: 13
Joined: Mon Mar 10, 2014 10:42 am
Location: London
Organisation: Innes Photography
Interests: photography, framing, fishing

Re: Framing calculator

Postby snipeh6 » Mon Jun 09, 2014 7:02 pm

Hi Colin,
i would be delighted if you could send me a copy of your price guide. How do I make a Thankyou donation ?
kjmuir64hotmail.co.uk.
Regards
Karen
snipeh6
 
Posts: 1
Joined: Wed Apr 25, 2012 8:32 pm
Location: scotland
Organisation: aberdeen
Interests: art, sailing, books

Re: Framing calculator

Postby gbazza » Wed Jun 11, 2014 3:18 pm

Hi Colin

I would be grateful if you could send me a copy of your spreadsheet to try.

Many thanks

Brian
gbazza
 
Posts: 11
Joined: Sun Aug 11, 2013 9:25 pm
Location: Way Up North
Organisation: Not Yet
Interests: Art - Picture Framing - Films - Music

Re: Framing calculator

Postby hamishfour » Thu Jul 17, 2014 5:32 pm

Hi Colin,
I run a spread sheet on my mac and also have Estlite on a PC which I'm not mad about and also I hate PC. Does your program allow for time spent on a job as well as materials? I have time and materials on my mac spreadsheet but It may be very basic compared to yours so would be very interested to see how yours works.
Best wishes,
Hamish. info@hamishbell.co.uk
hamishfour
 
Posts: 20
Joined: Mon Mar 29, 2010 2:44 pm
Location: Suffolk
Location: SUFFOLK
Organisation: HAMISH BELL FRAMES
Interests: art poker footie

Re: Framing calculator

Postby Whitewater Gallery » Fri Aug 08, 2014 4:55 pm

Hi Colin

If the offer is still open I would like to take a look at your pricing software.

Thanks

Nick
Whitewater Gallery
 
Posts: 358
Joined: Sun Jun 29, 2014 3:32 pm
Location: Polzeath
Organisation: Whtewater Gallery
Interests: Surfing, sailing

Re: Framing calculator

Postby Colin » Sat Aug 09, 2014 9:19 am

Hello Nick,

I will happily send you a copy, just need your email address. PM me if you would rather not put it on the board.

Best wishes
Colin
Sic dunkum biscuitus disintegrat
User avatar
Colin
 
Posts: 19
Joined: Thu Mar 19, 2009 1:40 pm
Location: Teynham, Kent
Organisation: Polka Dot Art Centre
Interests: Sculpture and art in general

Re: Framing calculator

Postby mrcrimps » Thu Aug 14, 2014 7:26 pm

Hi Colin, could I get a copy please?

Many thanks, Chris

mrcrimps@hotmail.co.uk
mrcrimps
 
Posts: 2
Joined: Thu Aug 14, 2014 11:17 am
Location: Holmfirth
Organisation: Monumental frames
Interests: guitar, brewing, walking, music festivals

Re: Framing calculator

Postby Whitewater Gallery » Sun Aug 17, 2014 12:19 pm

Hi Colin

I am not sure if my previous post worked as I can not see it. If your software is still available I would like to give it a try.

my email is nick@whitewatergallery.co.uk

Many thanks

Nick
Whitewater Gallery
 
Posts: 358
Joined: Sun Jun 29, 2014 3:32 pm
Location: Polzeath
Organisation: Whtewater Gallery
Interests: Surfing, sailing

Re: Framing calculator

Postby Colin » Mon Aug 18, 2014 9:06 am

Sorry Nick,

Couldn't send it before as you forgot to include your email address. Its on its way now.

Best wishes
Colin
Sic dunkum biscuitus disintegrat
User avatar
Colin
 
Posts: 19
Joined: Thu Mar 19, 2009 1:40 pm
Location: Teynham, Kent
Organisation: Polka Dot Art Centre
Interests: Sculpture and art in general

Re: Framing calculator

Postby Whitewater Gallery » Wed Aug 20, 2014 2:29 pm

Hi Colin

Sorry about that unfamiliar with the protocol! However I have not received an email? Maybe try nick@360photography.co.uk

Thanks

Nick
Whitewater Gallery
 
Posts: 358
Joined: Sun Jun 29, 2014 3:32 pm
Location: Polzeath
Organisation: Whtewater Gallery
Interests: Surfing, sailing

Re: Framing calculator

Postby featherd » Fri Sep 12, 2014 10:26 am

Hello Colin,

I'd love to get a copy of your spreadsheet, if it's still available. If you could PM me and let me know your PayPal email address please

Kind regards

Dean
featherd
 
Posts: 37
Joined: Thu Jun 12, 2014 9:30 am
Location: Worcestershire
Organisation: Frames By Design Ltd
Interests: Football, Computers, Art

Re: Framing calculator

Postby kashif86 » Mon Sep 15, 2014 9:27 am

It should be dependent upon your requirements, I don't think so calculator can give the exact measurements, anyhow,you did a great Job.. Thumbs Up for your effort!
A wide range of canvas frames and materials available with an extended range of indoor and outdoor exhibition display equipment and sublimation blanks.
kashif86
 
Posts: 21
Joined: Wed Sep 03, 2014 7:02 am
Location: United Kingdom
Organisation: Get Canvas Plus
Interests: Making Friends, Reading Books, Swimming

Re: Framing calculator

Postby Colin » Fri Sep 19, 2014 1:35 pm

Hope its OK to reply to these queries to the list as other users may find it useful

Kashif86, Perhaps I was being a bit too general in saying 'Don't change the pink cells'. Obviously if a cell contains a formula it would be unwise to change it but general things like labour charges, sundries costs, moulding prices etc can be altered to suit. Also if you apply a discount this will show on the invoice, if on the other hand you wish to uplift the charge by a percentage to reflect a more complex job then this does not show.
To avoid problems with virus attacks the whole thing runs on formulas without the use of macros or embedded code. If you do accidentally overwrite a formula let me know and I will help you repair it or send you a new copy if you haven't made a back up

Dean, Just let me know your email address, by pm if you prefer and I will send you a copy.

Colin
Sic dunkum biscuitus disintegrat
User avatar
Colin
 
Posts: 19
Joined: Thu Mar 19, 2009 1:40 pm
Location: Teynham, Kent
Organisation: Polka Dot Art Centre
Interests: Sculpture and art in general

Re: Framing calculator

Postby Nadine » Wed Dec 31, 2014 2:14 pm

hi Colin,

I would really appreciate a chance to take look at your tool. Please pm me at nadine_nassif (at) yahoo.com

Many thanx
Nadine
Nadine
 
Posts: 1
Joined: Wed Dec 31, 2014 12:29 pm
Location: Germany
Organisation: Frames
Interests: Working in the framers business and getting to know new framing styles

Re: Framing calculator

Postby janwilsonart » Thu Jan 01, 2015 9:56 am

Hi Colin. Happy New Year to you.
I too would like to try your spreadsheet. I use a Mac with Excel. I order everything from Wessex. I only do a few frames a week, mainly for my art students, so this sounds just right for me. What value donation are you thinking of?

Many thanks
Jan

email: thewilsons2@me.com
janwilsonart
 
Posts: 13
Joined: Wed Jan 22, 2014 5:23 pm
Location: Maidstone
Organisation: Jan Wilson Art
Interests: Art and textile craft

Re: Framing calculator

Postby Fellows Framing » Wed Jan 07, 2015 8:20 pm

Hi Colin,

I have just seen the posts re your calculator. I currently have a home made version which drives me batty at times. I would like to see yours if its still available.

Thank you.
Sarah
Fellows Framing
 
Posts: 124
Joined: Wed Dec 04, 2013 8:21 pm
Location: Gloucestershire
Organisation: Fellows Framing
Interests: Framing, Riding

Re: Framing calculator

Postby Colin » Wed Jan 14, 2015 1:49 pm

There is a flaw in two formulas in the spread sheet and my thanks go to Peter Ramsay for pointing them out. When calculating the glass and back sizes it fails to take into account the addition of a mount. Fortunately the difference in price when using float or non reflective glass is quite trivial however it would be fairly serious in the case of crystal/waterwhite glass.

To correct these errors make another copy of the spreadsheet and use this new one to make the changes.

1. On the calculator sheet go to cell E32 with the Glass heading and delete the contents.

2. Copy and paste in this new formula
=IF('Data Entry'!H7="Yes",IF('Data Entry'!I7="Float",(F36+H36)*(G36+I36)*C23,IF('Data Entry'!I7="Non Ref",(F36+H36)*(G36+I36)*C24,IF('Data Entry'!I7="Crystal",(F36+H36)*(G36+I36)*C25,IF('Data Entry'!I7="Mirror",(F36+H36)*(G36+I36)*C26)))),0)

3. Still on the calculator sheet go to cell F32 with the Backing heading aand delete the contents.

4. Copy and paste in this new formula
=IF('Data Entry'!J7="Yes",(F36+H36)*(G36+I36)*C27,0)

5. Save under a different name to your original.

Play around with the frame and mount sizes and ensure that the values of the glass and backing change on the Calculator sheet. When you are happy that everything is working fine discard the old version.

Any new versions of the spreadsheet I send out will have these changes incorporated.

On a personal note I am currently recovering from the after effects prostate cancer treatment so responses may be a little slower than normal. If you have requested a copy of my program rest assured I will send it to you providing I have your email address.

If you are happy with the spreadsheet and feel like making a donation then please send it to Prostate Cancer UK web site is: http://prostatecanceruk.org/

Best wishes and Happy New Year to you all
Colin
Sic dunkum biscuitus disintegrat
User avatar
Colin
 
Posts: 19
Joined: Thu Mar 19, 2009 1:40 pm
Location: Teynham, Kent
Organisation: Polka Dot Art Centre
Interests: Sculpture and art in general

Re: Framing calculator

Postby Yowdee » Tue Jan 20, 2015 2:23 pm

Hi Colin,

I would love the chance to get a copy of your framing calculator if possible. I wasn't clear if it is compatible with Mac as i use a Macbook Pro?

I am very happy to make a donation to your chosen charity.

My personal e-mail address is - monkeyfacesw9@gmail.com

Many thanks for you time and generosity in sharing this with everyone.

All the best

Janet
Yowdee
 
Posts: 3
Joined: Tue Jan 20, 2015 1:07 pm
Location: Devon
Organisation: Janet McNeill
Interests: Art, film, photography,walking...

PreviousNext

Return to Technology - CMC's Computers Etc




 
Picture Framer's Trade Directory
Picture Framer's Oracle

 
Members Map Header
Members Map
More info
Resources Header
Contact Forum Admin
Directory
How to include an image in your post
Cove Box Designer
Download Designer
General supplies
Glass
Machinery
Mounts/Mountboard
Artists
Conservators
Prints
Software
Tuition
UK Medals
Framers Forum Live!
Support Header
Crimson
White
Green
Violet
Advertise Header
Forum Banner Ads