# Woodworking blog entries tagged with 'excel'

## Format your excel formulas to inches and fractions

12-07-2014 11:52 AM by | 7 comments »

Have you ever had the result of a formula in excel to return something like 17.3333 then tried to format that cell to fractions up to two digits? Only to get a result of 17 1/3 when you really need it to be in 1/32, 1/16 or 1/64 increments. Well I have a solution for you. In this video I will demonstrate how you can use the MROUND function to accomplish this. So check it out and let me know what you think. Here is the link. http://youtu.be/Jfy_lglzNhA

## How to make a calculator in excel that will give you the distance needed to center a partition

09-30-2014 11:10 PM by | 0 comments »

Hello every one.If you viewed my video on how to create a calculator to come up with the constraints that eCabinets needs to automatically adjust your flutes for fluted moldings then you have to check these out! This calculator will help you easily determine the openings needed to position your partitions. Introduction to creating your own program in excel http://youtu.be/kqFM_jBV2A0 Partition Calculator Part1 Setting up the workbook http://youtu.be/_I3RMRrlVNw Partition Calculator P...

## How to make a Calculator in excel to generate the constraints in eCabinets for fluted moldings

09-28-2014 12:22 PM by | 2 comments »

Hello every one. If you viewed all three of the videos that I posted yesterday then you saw me use the calculator that I made in excel to come up with the constraints for the flutes in part 3. Today I would like to share the video that shows how I made this calculator. Check it out and let me know what you think.http://youtu.be/DqeCcdPCfKM

## 3D Stars #1: Program for Calculating Dimensions and Angles for 3D Stars

12-11-2012 09:14 AM by | 10 comments »

Have you ever seen a 3 Dimensional star that you really thought was pretty – perhaps on the side of a barn, in someone’s house, or even a Christmas decoration? As a woodworker you may have thought “I’d like to try making one like that.” When you research 3 dimensional (3D) stars on this forum or on the internet as a whole, you’ll be disappointed in what you find. If you’re lucky, you may find a project or two that talks about a specific sized star ...

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

 Benfleet Church - parquet sanding, repair and restoration 12-18-2014 07:20 PM The bar now 99% complete. 12-09-2014 10:01 AM 2nd bathroom at the cabin 11-23-2014 10:19 PM Outside is almost finished! 11-23-2014 07:48 AM Mail boxes 11-23-2014 03:18 AM Home remodel 2014 11-19-2014 06:31 PM Whole House Humidifier Install 11-17-2014 03:42 AM I guess I'll have a new project to get involved in 10-31-2014 05:00 PM Guy Harvey Outpost In Key West 10-30-2014 12:11 AM Key west Islander 10-29-2014 11:49 PM Garden Church Planter, succulents 11-29-2014 04:29 PM Wall planter 11-28-2014 03:34 PM Come dance with me 11-20-2014 03:14 PM Cedar Planter Box 11-15-2014 02:10 PM ESPALIER 10-10-2014 07:09 AM Green Chillies 10-09-2014 07:16 AM Bee - Cottage.... 09-06-2014 09:14 PM Stone Staircase 08-31-2014 09:45 AM pond house 08-21-2014 01:55 PM enclosed, raised bed, herb garden 08-05-2014 08:04 AM