Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2022, 06:31 AM
_katapult _katapult is offline Calculate (optimum) number of files for printing Windows 10 Calculate (optimum) number of files for printing Office 2021
Novice
Calculate (optimum) number of files for printing
 
Join Date: May 2022
Posts: 5
_katapult is on a distinguished road
Default Calculate (optimum) number of files for printing

Hello everyone!
For several projects we need to do some (rather simple, but time consuming) preparations before sending documents to the printshop.
We have to calculate how many documents fit in a folder and how many folders are needed in the end.
As the number of pages and the amount of documents (> 100) vary every time, we have do make these adjustments manually. However I was wondering whether there is a more elegant way to do that.


after summing up the size of the document (the analog withd) = done via a formula, we select the documents which fit into the folder (i.e. 7,5cm) = up to now manually.

is there a way to automatically
- count all files until 8 / 6 (cm) is reached
- highlight and separate these sections,
- preferably make a file consisting of documents of one category first.

à in the end receive the minimum amount of big/small folders.
One additional difficulty might be, that there are not only rows with numbers, but also chapter-separations – which of course, might be sorted out, however they are quite nice for keeping the overview.
I ve added a screenshot, thank you in advance!
Attached Images
File Type: png calculate_file_number_example.PNG (34.9 KB, 13 views)
Reply With Quote
  #2  
Old 05-22-2022, 08:32 AM
Purfleet Purfleet is offline Calculate (optimum) number of files for printing Windows 10 Calculate (optimum) number of files for printing Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Please attach a file example rather than a screen dump so we dont have to waste time recreating the data that al reaady exists
Reply With Quote
  #3  
Old 05-23-2022, 04:14 AM
_katapult _katapult is offline Calculate (optimum) number of files for printing Windows 10 Calculate (optimum) number of files for printing Office 2021
Novice
Calculate (optimum) number of files for printing
 
Join Date: May 2022
Posts: 5
_katapult is on a distinguished road
Default

please find attached the excel-file to the screenshot i mentionned in the previous post!
Attached Files
File Type: xlsx calculate_optimum_number.xlsx (31.4 KB, 5 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default How to automatically Calculate number of days between two dates? wcngu1 Word 6 10-24-2019 04:20 AM
Need to calculate a result if a number is positive or negative. aaghd72 Excel 3 03-01-2019 12:34 AM
Calculate number of days in a table from a specific date tstolbert Word 2 06-25-2016 02:30 PM
Selecting the optimum graphics card fro a new laptop bitpusher PowerPoint 1 11-23-2015 08:37 AM
Number Alignment When Printing Welshie82 Outlook 0 03-19-2012 02:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft