• 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

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

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
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: 873
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: Atos Franzon, Louis Muti
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Blair Gallagher
Brandi Taylor
Hafiz Ihsan Qadir
Gontran Bage
adolfo casanova
Annestine Johnpulle
Priscila Campbell
Jeff Mikles
Aaron Butler
Maurice Petterlin
Forum Stats:
Groups: 3
Forums: 24
Topics: 6369
Posts: 27852

 

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

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • 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
 

Company

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

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.