Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number sortation
I am trying to come up with a formula to sort page counts. Example: If I
give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page, 1 12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number sortation
What happens if you have an odd number of pages to start with? Is it
increased by 1 to make it even? Pete On Oct 11, 10:38 pm, daffy1 wrote: I am trying to come up with a formula to sort page counts. Example: If I give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page, 1 12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number sortation
What is your logic for preferring 24+16+12, and not 24+20+8 (or 20+20+12, or
20+16+16, or ...)? -- David Biddulph "daffy1" wrote in message ... I am trying to come up with a formula to sort page counts. Example: If I give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page, 1 12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number sortation
The order I am going by is taking the largest number first (24) and then the
next largest number (20). My original number combo was wrong. So yes, this case submitting a 52 would result in a 24 + 20 = 8. My apologies for that oversite. "David Biddulph" wrote: What is your logic for preferring 24+16+12, and not 24+20+8 (or 20+20+12, or 20+16+16, or ...)? -- David Biddulph "daffy1" wrote in message ... I am trying to come up with a formula to sort page counts. Example: If I give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page, 1 12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number sortation
give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page,
1 12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8. (ie 10110) Hi. You mention "Only available..." As a side note with your numbers, you selected the second of 13 possible solutions. You may need to specify a more detailed "Rule". FrobeniusSolve[{24,20,16,12,8},52]] {1,1,0,0,1}, {1,0,1,1,0}, {1,0,0,1,2}, {0,2,0,1,0}, {0,1,2,0,0}, {0,1,1,0,2}, {0,1,0,2,1}, {0,1,0,0,4}, {0,0,2,1,1}, {0,0,1,3,0}, {0,0,1,1,3}, {0,0,0,3,2}, {0,0,0,1,5} So one might think the solution is: 1*24 + 1*20 + 1*8 = 52 or 1*12+5*8 = 52 etc... All numbers in {24,20,16,12,8} are Co-Prime, hence there are an infinite number that can't be reproduced with these numbers. Your page numbers can only be 8,12,16,20, ...(+4) multiples of 4. Just to mention... From Number Theory, if you could reduce the last page from 8 to 7, then the Frobenius Number reduces from Infinity to 29. FrobeniusNumber[{24,20,16,12,7}] = 29 (29 being the largest page # you can't do) Therefore, every page number above 29 can be represented from {24,20,16,12,7}. I don't know what your requirements are, but thought it might be worth mentioning. -- Dana DeLouis "daffy1" wrote in message ... I am trying to come up with a formula to sort page counts. Example: If I give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page, 1 12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number sortation
Sorry to make a mess of this. My only "Rule" is that given the number 52 as
an example it would have to divide into 1*24 + 1*20 + 1*8. "Dana DeLouis" wrote: give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page, 1 12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8. (ie 10110) Hi. You mention "Only available..." As a side note with your numbers, you selected the second of 13 possible solutions. You may need to specify a more detailed "Rule". FrobeniusSolve[{24,20,16,12,8},52]] {1,1,0,0,1}, {1,0,1,1,0}, {1,0,0,1,2}, {0,2,0,1,0}, {0,1,2,0,0}, {0,1,1,0,2}, {0,1,0,2,1}, {0,1,0,0,4}, {0,0,2,1,1}, {0,0,1,3,0}, {0,0,1,1,3}, {0,0,0,3,2}, {0,0,0,1,5} So one might think the solution is: 1*24 + 1*20 + 1*8 = 52 or 1*12+5*8 = 52 etc... All numbers in {24,20,16,12,8} are Co-Prime, hence there are an infinite number that can't be reproduced with these numbers. Your page numbers can only be 8,12,16,20, ...(+4) multiples of 4. Just to mention... From Number Theory, if you could reduce the last page from 8 to 7, then the Frobenius Number reduces from Infinity to 29. FrobeniusNumber[{24,20,16,12,7}] = 29 (29 being the largest page # you can't do) Therefore, every page number above 29 can be represented from {24,20,16,12,7}. I don't know what your requirements are, but thought it might be worth mentioning. -- Dana DeLouis "daffy1" wrote in message ... I am trying to come up with a formula to sort page counts. Example: If I give the number 52. It has to sort into 1 24-page, 0 20-page, 1 16-page, 1 12-page and 0 8 page. The only available dividers are 24, 20, 16, 12 and 8. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |