The Forestry Forum is sponsored in part by:

iDRY Vacuum Kilns


Forestry Forum
Sponsored by:


TimberKing Sawmills



Toll Free 1-800-582-0470

LogRite Tools



Norwood Industries Inc.




Your source for Portable Sawmills, Edgers, Resaws, Sharpeners, Setters, Bandsaw Blades and Sawmill Parts

EZ Boardwalk Sawmills. More Saw For Less Money!

STIHLDealers.com sponsored by Northeast STIHL


Woodland Sawmills

Peterson Swingmills

 KASCO SharpTech WoodMaxx Blades

Turbosawmill

Sawmill Exchange

Michigan Firewood, your BRUTE FORCE Authorized Dealer

Baker Products

ECHO-Bearcat

iDRY Wood Lumber Vacuum Drying for everyon

Nyle Kiln Dry Systems

Chainsawr, The Worlds Largest Inventory of Chainsaw Parts

Smith Sawmill Service

Dynamic Green Products Inc.





Author Topic: lumber inventory  (Read 7091 times)

0 Members and 1 Guest are viewing this topic.

Offline jeepman

  • member
  • *
  • Posts: 28
  • Age: 46
  • Gender: Male
  • KD8ADW
    • Share Post
lumber inventory
« on: October 06, 2003, 08:07:16 PM »
Does anyone know of a good spreadsheet to keep up with lumber? Notebook is getting full.

Offline Percy

  • Senior Member x2
  • *****
  • Posts: 2271
  • Age: 66
  • Location: Terrace B.C. Canada
  • Gender: Male
  • Resident trouble maker
    • Share Post
Re: lumber inventory
« Reply #1 on: October 06, 2003, 11:28:25 PM »
I built a spreadsheet in Microsoft Works that I used to use alot. I could email it to you if you like.......Meybe there is somthing on the net a guy could down load.... :P
GOLDEN RULE : The guy with the gold, makes the rules.

Offline woodhaven

  • In Memoriam
  • *
  • Posts: 460
  • Age: 68
  • Gender: Male
  • Circular Saw Diehard
    • Share Post
Re: lumber inventory
« Reply #2 on: October 07, 2003, 05:31:00 AM »
What items are you looking for? I do a little programming, maybe I could build you something.
Richard

Offline Jason_WI

  • Senior Member
  • ****
  • Posts: 651
  • Age: 45
  • Location: Egg Harbor, WI
  • Gender: Male
  • He who dies with the most toys wins.
    • Share Post
Re: lumber inventory
« Reply #3 on: October 07, 2003, 04:12:17 PM »
For those of you who can't afford the Micro$oft verson of Office there is an alternitave.

Its called Open Office and will run on Windoze. Better yet it is FREE to download. Gotta love those Unix guys and there free mentality.

As far as I can tell it can do everything that Micro$oft Office can do.

http://www.openoffice.org/


Jason
Norwood LM2000, 20HP Honda, 3 bed extentions. Norwood Edgemate edger. Gehl 4835SXT

Offline Oregon_Sawyer

  • Full Member x2
  • ***
  • Posts: 224
  • Age: 66
  • Gender: Male
  • Sawing for the fun of it!
    • Share Post
Re: lumber inventory
« Reply #4 on: October 08, 2003, 12:12:32 AM »
I wrote a spread sheet in Excell.  It also figures board Ft.

I could send it to you by E-Mail I think.
Sawing with a WM since 98. LT 70 42hp Kubota walk behind. 518 Skidder. Ramey Log Loader. Serious part-timer. Western Red Cedar and Doug Fir.  Teamster Truck Driver 4 days a week.

Offline oldsaw

  • Senior Member
  • ****
  • Posts: 754
  • Age: 58
  • Gender: Male
  • It's a tree, it's a board, it's a....
    • Share Post
If you have Office or Works, it wouldn't take
« Reply #5 on: October 09, 2003, 08:31:27 PM »
much to build one.  I have built Excel spreadsheets to keep track of my "too big" record collection (for insurance) as well as tracking sales/commission/% of quota at the office.  Hey, a salesman has to know how much money he is going to be able to spend on "toolbox stuff".
So many trees, so little money, even less time.

Stihl 066, Husky 262, Husky 350 (warmed over), Homelite Super XL, Homelite 150A

Offline woodhaven

  • In Memoriam
  • *
  • Posts: 460
  • Age: 68
  • Gender: Male
  • Circular Saw Diehard
    • Share Post
Re: lumber inventory
« Reply #6 on: October 10, 2003, 06:03:42 PM »
I would still be interested in knowing what items and fields you would like to have. It might be something I want to build for my own use. Most store bought software will do "almost" what you want it to but there is always something you wish was differant or a another feature added. That is actually why I learned programming anyway. Never could find software to do what I wanted the way I wanted.
Richard

Offline jeepman

  • member
  • *
  • Posts: 28
  • Age: 46
  • Gender: Male
  • KD8ADW
    • Share Post
Re: lumber inventory
« Reply #7 on: October 10, 2003, 07:19:41 PM »
Thanks to Percy for the spreadsheet and thanks to the rest of you for the ideas.
Woodhaven, what I was interested in was a sheet with columns for each common size of lumber and a board foot calculator. One can have a sheet for each species stacked and have their inventory at the fingertips without looking in the lumber yard to see if you've got 20 hemlock 8X8X10's. If you keep any lumber around, it would be of great use.

Offline woodhaven

  • In Memoriam
  • *
  • Posts: 460
  • Age: 68
  • Gender: Male
  • Circular Saw Diehard
    • Share Post
Re: lumber inventory
« Reply #8 on: October 11, 2003, 04:46:38 AM »
Would you use a real easy computer program or would you still use your spread sheets? It could all be done on one screen saved to a data base and printed. All the things you named would only require 4 or 5 buttons. Instead of having a sheet for each species you would just select it from a list. I will start working on something and post a screen shot to see what you think.
What would be helpful is to now is the sizes and species some of the other guys use as well.
Richard

Offline smwwoody

  • Senior Member x2
  • *****
  • Posts: 1450
  • Age: 52
  • Location: Gold Hill Virginia
  • Gender: Male
  • Makeing round wood square
    • Share Post
Re: lumber inventory
« Reply #9 on: October 11, 2003, 10:51:42 AM »
What about grade
Full time Mill Manager
Cleereman head rig
Cooper Scragg
McDonugh gang saw
McDonugh edger
McDonugh resaw
TS end trim
Pendu slab recovery system
KJ4WXC

Offline woodhaven

  • In Memoriam
  • *
  • Posts: 460
  • Age: 68
  • Gender: Male
  • Circular Saw Diehard
    • Share Post
Re: lumber inventory
« Reply #10 on: October 11, 2003, 12:04:02 PM »
Yep,
Thats a good one !!
Richard

Offline Percy

  • Senior Member x2
  • *****
  • Posts: 2271
  • Age: 66
  • Location: Terrace B.C. Canada
  • Gender: Male
  • Resident trouble maker
    • Share Post
Re: lumber inventory
« Reply #11 on: October 11, 2003, 07:19:19 PM »
Heya Woodhaven
The spreadsheet I sent Jeepman was very basic but effective. Does bdft calculations and totals yaddayadda easily modified for pricing as well. What I think would be great, for me anyways is  a program that you could enter the days cut into , plus the days sales, keeping an accurate inventory/net worth of whatever boards you have in stock.Also a log inventory integrated with "projections' of what you could expect to get from said logs. An added bonus would be invoice printing,tax caculations, and an automatic notification of old stock that you could 'Red Tag" and sell cheap to get the coin back in cirrculation. OOOOhhh boy, the more I think about it, the more usefull but complex it could be...now I understand why there are constant upgrades of software. Anyways I dont know dick about programming but I have an idea, along with many others here,of what would be needed for daily milling. If you built a dedicated, small sawmilling software package, reasonably priced, you might be able to sell it and subsidize your milling :D :D :D

Id be glad to throw you my ideas.....



The 'SMILEY" boss is enjoyin hisself these days huh??
GOLDEN RULE : The guy with the gold, makes the rules.

Offline woodhaven

  • In Memoriam
  • *
  • Posts: 460
  • Age: 68
  • Gender: Male
  • Circular Saw Diehard
    • Share Post
Re: lumber inventory
« Reply #12 on: October 11, 2003, 07:37:40 PM »
Dang Percy,
This started out as a project I could do in a few days. Now you talking about a year long book keeping system. Don't have that kind of extra time right now as I am still cleaning up from the storm. I will start on the first part and over time see where it goes.
Richard

Offline Ron Wenrich

  • Forester
  • Administrator
  • *****
  • Posts: 14190
  • Age: 72
  • Location: Jonestown, PA
  • Gender: Male
    • Share Post
Re: lumber inventory
« Reply #13 on: October 13, 2003, 04:03:28 AM »
A number of years ago I worked on a program that was geared more to the small to medium sized sawmill.  It would take care of log inventory, lumber inventory and expenses.

Logs were a logs in and logs out by species, grade and size.  You had a continuous log inventory.  Lumber was the same thing.

Expenses tracked labor, fuel, insurance and anything you wanted to add.

I then put in a section for putting in sawing times of logs and log yields.  From that, with given lumber prices, you could price the value of each log - lumber sawn vs expenses.  It also accounted for sawdust and chips.  It would help mills weed out logs that shouldn't hit the headblocks.

Then I added a "what if" category. There you could play with lumber prices, expenses and sawing time to see if added equipment made you more profitable.  I wanted to take it one step further by going from logs to tree so it could be used as an aid in buying standing timber.

An outfit up in Maine had a similar program that was for sale, so I quit on it.  There's tied in handheld units which eliminated a lot of input.  They were a couple of steps ahead of me in technology.

A simple product could be developed for weekenders and small mills.  
Never under estimate the power of stupid people in large groups.

Offline woodhaven

  • In Memoriam
  • *
  • Posts: 460
  • Age: 68
  • Gender: Male
  • Circular Saw Diehard
    • Share Post
Re: lumber inventory
« Reply #14 on: October 14, 2003, 04:07:53 PM »
Ron
What programming language were you using and do you still have the program? I currently use C++ and Visual Basic 6
Richard

Offline edsaws

  • Full Member x2
  • ***
  • Posts: 116
  • Gender: Male
  • When in doubt drink stout!
    • Share Post
Re: lumber inventory
« Reply #15 on: November 28, 2003, 08:31:04 PM »
Hi all i was reading some old posts and came across this one and was wondering if someone wouldn't mind sending me a copy of a spreadsheet that could tally up the inventory. I'd really appreciate it thanks

Offline oakiemac

  • Senior Member x2
  • *****
  • Posts: 1483
  • Location: south west Michigan
  • Gender: Male
  • God bless the U.S.A!
    • Share Post
    • Hickoryandoak
Re: lumber inventory
« Reply #16 on: November 28, 2003, 08:49:20 PM »
I would appreciate that program myself. Thanks.
Oakie
Mobile Demension sawmill, Bobcat 873 loader, 3 dry kilns and a long "to do" list.

Offline WoodChucker

  • Senior Member
  • ****
  • Posts: 405
  • Gender: Male
  • I need to edit my profile!
    • Share Post
    • The WoodChucker
Re: lumber inventory
« Reply #17 on: November 29, 2003, 05:56:38 AM »
Yeah if anyone would email me a copy of there spreed sheet I'd appreciate it very much, Thanks!  

R.T.  rt@thewoodchucker.com
If a Husband & Wife are alone in the forrest fighting and no one is around to hear them, is he still wrong anyway?

Offline tamilanand

  • member
  • *
  • Posts: 4
  • I'm new!
    • Share Post
Re: lumber inventory
« Reply #18 on: May 03, 2016, 11:10:26 AM »
Can anyone Please share the spreadsheet to keep up with lumber to my email id--> indian.anand@gmail.com

Appreciate your help. Thank you.

Offline Magicman

  • Senior Member x2
  • *****
  • Posts: 40450
  • Age: 77
  • Location: Brookhaven, MS
  • Gender: Male
  • A "Traveling Man"
    • Share Post
    • Knothole Sawmill
Re: lumber inventory
« Reply #19 on: May 03, 2016, 11:29:57 AM »
I don't, but Welcome to the Forestry Forum.  Adding your sawmill, location, etc. always helps with questions.   :)
Knothole Sawmill, LLC     '98 Wood-Mizer LT40SuperHydraulic   WM Million BF Club Member   WM Pro Sawyer Network

Never allow your "need" to make money to exceed your "desire" to provide quality service.....The Magicman

Offline Chuck White

  • Senior Member x2
  • *****
  • Posts: 12502
  • Age: 71
  • Location: Russell, NY (Way Upstate)
  • Gender: Male
  • Sawing Mobile since 2005
    • Share Post
Re: lumber inventory
« Reply #20 on: May 03, 2016, 08:51:23 PM »
Welcome to the Forestry Forum, tamilanand.
~Chuck~
Retired USAF 1989, Retired School Bus Driver 2012, now semi-retired Mobile Sawyer
1995 Wood-Mizer LT40HDG25 Kohler - Cooks Cat Claw Sharpener and single-tooth setter, 4-foot Logrite cant hook.
Basic mechanical skills are all that's required to maintain a Wood-Mizer

Offline red

  • Senior Member x2
  • *****
  • Posts: 2094
  • Location: ne PA
  • Gender: Male
  • we will never forget
    • Share Post
Re: lumber inventory
« Reply #21 on: May 03, 2016, 09:09:38 PM »
WoW original post was in 2003 . . .
We have a lot of good boys and girls in harms way
lets all support them and their familys.

Offline tamilanand

  • member
  • *
  • Posts: 4
  • I'm new!
    • Share Post
Re: lumber inventory
« Reply #22 on: May 31, 2016, 03:01:48 AM »
Thank you Magicman. Our Saw mill is located at- Sivakasi ,Tamilnadu ,India

Offline tamilanand

  • member
  • *
  • Posts: 4
  • I'm new!
    • Share Post
Re: lumber inventory
« Reply #23 on: May 31, 2016, 03:02:49 AM »
Thank you Chuck White

Offline tamilanand

  • member
  • *
  • Posts: 4
  • I'm new!
    • Share Post
Re: lumber inventory
« Reply #24 on: May 31, 2016, 03:04:27 AM »
Yes Red, Googled it and gave a shot hoping someone having the sheet will share. Thank you Red

Offline Quebecnewf

  • Senior Member x2
  • *****
  • Posts: 1143
  • Location: Harrington Harbour Quebec Canada
  • Gender: Male
    • Share Post
Re: lumber inventory
« Reply #25 on: May 31, 2016, 05:37:48 AM »
So funny that this should pop up after 2003 . Just yesterday I was messing around in Excel doing something along the same lines as this. Trying to make a spread sheet to do lumber inventory , prices, qty, board feet , etc etc.
Did I mention my Excel skills are very very poor.

I am sure given all the talent and the advances in software and computers there is some FF member who has done this already .

 He or she will find this post and post up his or her spreadsheet that they have developed and rescue us from mucking through it and ending up with something that is not that good anyway.

The pool of talent on this site is not to be beaten. So all we have to do is sit back and wait for the RIGHT FF member to see this. It won,t take long I bet.

Waiting............

Quebecnewf


Share via delicious Share via digg Share via facebook Share via linkedin Share via pinterest Share via reddit Share via stumble Share via tumblr Share via twitter

xx
lumber inventory

Started by kderby on Sawmills and Milling

13 Replies
3292 Views
Last post December 03, 2006, 12:57:45 PM
by solodan
xx
Lumber Inventory Software

Started by PA_Walnut on Sawmills and Milling

16 Replies
2702 Views
Last post December 07, 2018, 06:45:54 AM
by PA_Walnut
xx
Log Inventory

Started by Horselog on Sawmills and Milling

2 Replies
906 Views
Last post June 06, 2016, 01:33:26 PM
by paul case
xx
inventory

Started by cangel on Forestry and Logging

3 Replies
1714 Views
Last post November 18, 2014, 06:36:05 PM
by clearcut
 


Powered by EzPortal