LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
countif formula to find the occurances of a number that is greater than one number but less than another steveo Excel Discussion (Misc queries) 3 July 8th 06 02:04 AM
convert text-format number to number in excel 2000%3f Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM
Count number of times a specific number is displayed in a cell ran subs Excel Worksheet Functions 1 June 27th 05 05:01 PM
excel format cells/Number/Category: Number problem Matts Excel Discussion (Misc queries) 5 December 9th 04 09:47 PM
Rounding a number to a multiple quantity that adds to a fixed total number wjlo Excel Worksheet Functions 1 November 9th 04 04:43 PM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"