• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member
  • Login

FACTORY PRODUCTION SHEET|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / FACTORY PRODUCTION SHEET|General Excel Questions & Answers|Excel Forum|My Online Training Hub

office scripts course

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumGeneral Excel Questions & Answe…FACTORY PRODUCTION SHEET
sp_PrintTopic sp_TopicIcon
FACTORY PRODUCTION SHEET
Avatar
Craig Niven

New Member
Members
Level 0
Forum Posts: 1
Member Since:
July 15, 2020
sp_UserOfflineSmall Offline
1
July 15, 2020 - 6:55 am
sp_Permalink sp_Print

Good evening, 

Trust you are well. 

I am look for some assistance with a formula which I can use to return the value of stock available to sell on the given day that I am using the system.

I manufacture cement products, these take between 7 and 10 days to cure. Once cured only then is the product ready to sell.

I have made a "manufactured sheet", "caps", "columns" and "sales" sheets. 

On the manufactured sheet I record the units made, based on this "caps" and "columns" sheets will return the quantity made and the date the stock will be ready to be sold.

Caps and columns sheets numbers will constantly update based on what is manufactured. 

I need to be able to record my sale of the units while keeping a true value of what stock is available to sell based on the date that it ready to sell. 

If there is a post I missed please share the link or alternatively recommend a course on mytraininghub.com which would cover this situation. 

 

Thank you in advance, 

 

Kind regards,

Craig

Avatar
Anders Sehlstedt
Eskilstuna, Sweden

VIP
Members


Trusted Members
Level 3
Forum Posts: 880
Member Since:
December 7, 2016
sp_UserOfflineSmall Offline
2
July 17, 2020 - 6:20 am
sp_Permalink sp_Print

Hello Craig,

In attached file you will see an example of, in my view, a better approach to handle the data. This is just an example aimed to show how easier it is to get the information you need and different ways to get it. I have gathered it all in one sheet, so it looks a bit messy.

The main source of data is the table in columns A to E, called Table1. In this table I have structered the manufacturing and sales data in a tabular data format, which makes it very easy to get whatever data I want from it using formulas or Pivot Table. All you need to do is to continue feed the table with new data. The Pivot Table needs then to be updated, right click any cell in the Pivot Table and Refresh.

 Take a look and try it out. I do think you will see the benifits of this approach.

Regarding a suitable course, I think the Excel Experts would be a good starting point.

Br,
Anders

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, Riny van Eekelen, Sheryl Gill, Rob Starren, Sheilah Taylor
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Mohamed Touahria
Sheila McCall
Nicholas Montano
John Babcock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28549

 

Member Stats:
Guest Posters: 49
Members: 32803
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel Office Scripts
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate
  • Sponsor Our Newsletter

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.