#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Please attach a file example rather than a screen dump so we dont have to waste time recreating the data that al reaady exists
|
#3
|
|||
|
|||
please find attached the excel-file to the screenshot i mentionned in the previous post!
|
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 |