Dairy Science and Food Technology Homepage
Home  Cheese starters Donate support Site  Probiotics Cheese yield  Cheese quality Cheese science  Italian cheese Anti-microbial  proteins  Phages Primary production  Ice cream Wine Calculators  Harvard referencing  Packaging  Jobs
Forum Home Forum Home > Site calculators and spreadsheet queries > Spreadsheet and site calculators
  New Posts New Posts RSS Feed - Excel spreadsheet help
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Excel spreadsheet help

 Post Reply Post Reply
Author
Message Reverse Sort Order
formula123 View Drop Down
Admin Group
Admin Group

Administrator

Joined: 01 Sep 2009
Location: N. Ireland
Status: Offline
Points: 390
Post Options Post Options   Thanks (0) Thanks(0)   Quote formula123 Quote  Post ReplyReply Direct Link To This Post Topic: Excel spreadsheet help
    Posted: 21 Mar 2011 at 8:23pm
The spreadsheet is free for educational use. The functions used are all in the public domain. All I have done is show how they might be used. You are free to modify, adapt as you wish. BUT I am not responsible for any problems , issues etc that you might encounter using the application!
Back to Top
Sponsored Links


Back to Top
PaulR View Drop Down
Newbie
Newbie


Joined: 21 Mar 2011
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote PaulR Quote  Post ReplyReply Direct Link To This Post Posted: 21 Mar 2011 at 12:21am
I have been looking for a spreadsheet to change kilograms to pounds and ounces and found yours at http://www.dairyscience.info/map/converter.xls . Exactly what I needed have you any objections in me using this in our school?
 
Thanks Paul
Back to Top
formula123 View Drop Down
Admin Group
Admin Group

Administrator

Joined: 01 Sep 2009
Location: N. Ireland
Status: Offline
Points: 390
Post Options Post Options   Thanks (0) Thanks(0)   Quote formula123 Quote  Post ReplyReply Direct Link To This Post Posted: 07 Feb 2011 at 11:18pm
Joe

Thank you for supporting the site.

To see the worksheets in a workbook go to "View" on the ribbon, then go to  "Arrange all" and finally go to "Arrange horizontal". You should see all the worksheets now.

Re; pounds and ounces. I can suggest 2 options. 

 a) using the convert function. The syntax is:
 
    = CONVERT(number,"from_unit","to_unit"). Note the requirement for  "" around the units.
 
Alternatively use the DOLLARFR function. This can be easily configured to give pounds and ounces (in sixteenths)  but it is confusing for many people.  

The syntax here is =DOLLARFR(number*2.2046,16). A result of 2.02 means 2 pounds and 2 ounces! I have prepared a simple, free spreadsheet to show how this can be done. Click on the image below to download the spreadsheet.




Back to Top
joe91 View Drop Down
Newbie
Newbie


Joined: 07 Feb 2011
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote joe91 Quote  Post ReplyReply Direct Link To This Post Posted: 07 Feb 2011 at 10:09pm
Need some help with spreadsheets from the site pl? If I cant see a worksbook (lost it) in Excel 2010 how can I see it? I want to convert kilos to pounds and oz how do I do this in spredsheet without this option. Thanks JFS
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.