{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["About","Patterns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"About","index":0,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["About"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"www.solvermax.com"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Key"]
[null,null,null,null,null,null,null,null,null,null,"Data"]
[null,null,null,null,null,null,null,null,null,null,"Constant"]
[null,null,null,null,null,null,null,null,null,null,"Highlight"]
[null,null,null,null,null,null,null,null,null,null,"Error"]
[null,null,null,null,null,null,null,null,null,null,"Solver variable"]
[null,null,null,null,null,null,null,null,null,null,"Pasted values"]
[]
[null,null,null,null,null,null,null,null,null,null,"Version"]
[null,null,null,null,null,null,null,null,null,null,"v 1.1"]
[null,null,null,null,null,null,null,null,null,null,"2022-06-30"]

{"sheet":"Patterns","index":1,"n_rows":274,"n_cols":12,"rows_kept":274,"cut":false,"hidden":false,"merged":[]}
["Create cutting patterns given stock length and required items"]
[]
["Assumptions",null,null,null,null,null,null,null,null,null,null,"Description"]
["Stock length",6000,"mm"]
["Combinations",{"$f":"PRODUCT(B18:H18)","v":45360},{"$f":"IF(NumCombos<=B6,\"OK\",\"Warning: May take a long time\")","v":"OK"}]
["Warning if >=",10000000,"combinations"]
[]
["Result"]
["Patterns",{"$f":"COUNTA(TablePatterns[Pattern])","v":253}]
["Of which",{"$f":"COUNTIFS(TablePatterns[Waste],\"<=\"&B11)","v":15}]
["have waste <=",100,"mm"]
[]
["Intermediate calculations"]
[null,"Required items"]
["Attribute",{"$f":"TablePatterns[[#Headers],[A]]","v":"A"},{"$f":"TablePatterns[[#Headers],[B]]","v":"B"},{"$f":"TablePatterns[[#Headers],[C]]","v":"C"},{"$f":"TablePatterns[[#Headers],[D]]","v":"D"},{"$f":"TablePatterns[[#Headers],[E]]","v":"E"},{"$f":"TablePatterns[[#Headers],[F]]","v":"F"},{"$f":"TablePatterns[[#Headers],[G]]","v":"G"},"Status"]
["Length",2316,2200,1650,1460,1140,1120,980,{"$f":"IF(MAX(Lengths)<=StockLength,\"OK\",\"Item(s) longer than stock\")","v":"OK"}]
["Pieces",{"$f":"ROUNDDOWN(StockLength/B16,0)","v":2},2,3,4,5,5,6]
["Combinations",{"$f":"B17+1","v":3},3,4,5,6,6,7]
[]
["VBA output Table"]
["Pattern","A","B","C","D","E","F","G","Length","Waste"]
["6000-1",2,0,0,0,1,0,0,5772,228]
["6000-2",2,0,0,0,0,1,0,5752,248]
["6000-3",2,0,0,0,0,0,1,5612,388]
["6000-4",2,0,0,0,0,0,0,4632,1368]
["6000-5",1,1,0,1,0,0,0,5976,24]
["6000-6",1,1,0,0,1,0,0,5656,344]
["6000-7",1,1,0,0,0,1,0,5636,364]
["6000-8",1,1,0,0,0,0,1,5496,504]
["6000-9",1,1,0,0,0,0,0,4516,1484]
["6000-10",1,0,2,0,0,0,0,5616,384]
["6000-11",1,0,1,1,0,0,0,5426,574]
["6000-12",1,0,1,0,1,0,0,5106,894]
["6000-13",1,0,1,0,0,1,0,5086,914]
["6000-14",1,0,1,0,0,0,2,5926,74]
["6000-15",1,0,1,0,0,0,1,4946,1054]
["6000-16",1,0,1,0,0,0,0,3966,2034]
["6000-17",1,0,0,2,0,0,0,5236,764]
["6000-18",1,0,0,1,1,0,1,5896,104]
["6000-19",1,0,0,1,1,0,0,4916,1084]
["6000-20",1,0,0,1,0,1,1,5876,124]
["6000-21",1,0,0,1,0,1,0,4896,1104]
["6000-22",1,0,0,1,0,0,2,5736,264]
["6000-23",1,0,0,1,0,0,1,4756,1244]
["6000-24",1,0,0,1,0,0,0,3776,2224]
["6000-25",1,0,0,0,3,0,0,5736,264]
["6000-26",1,0,0,0,2,1,0,5716,284]
["6000-27",1,0,0,0,2,0,1,5576,424]
["6000-28",1,0,0,0,2,0,0,4596,1404]
["6000-29",1,0,0,0,1,2,0,5696,304]
["6000-30",1,0,0,0,1,1,1,5556,444]
["6000-31",1,0,0,0,1,1,0,4576,1424]
["6000-32",1,0,0,0,1,0,2,5416,584]
["6000-33",1,0,0,0,1,0,1,4436,1564]
["6000-34",1,0,0,0,1,0,0,3456,2544]
["6000-35",1,0,0,0,0,3,0,5676,324]
["6000-36",1,0,0,0,0,2,1,5536,464]
["6000-37",1,0,0,0,0,2,0,4556,1444]
["6000-38",1,0,0,0,0,1,2,5396,604]
["6000-39",1,0,0,0,0,1,1,4416,1584]
["6000-40",1,0,0,0,0,1,0,3436,2564]
["6000-41",1,0,0,0,0,0,3,5256,744]
["6000-42",1,0,0,0,0,0,2,4276,1724]
["6000-43",1,0,0,0,0,0,1,3296,2704]
["6000-44",1,0,0,0,0,0,0,2316,3684]
["6000-45",0,2,0,1,0,0,0,5860,140]
["6000-46",0,2,0,0,1,0,0,5540,460]
["6000-47",0,2,0,0,0,1,0,5520,480]
["6000-48",0,2,0,0,0,0,1,5380,620]
["6000-49",0,2,0,0,0,0,0,4400,1600]
["6000-50",0,1,2,0,0,0,0,5500,500]
["6000-51",0,1,1,1,0,0,0,5310,690]
["6000-52",0,1,1,0,1,0,1,5970,30]
["6000-53",0,1,1,0,1,0,0,4990,1010]
["6000-54",0,1,1,0,0,1,1,5950,50]
["6000-55",0,1,1,0,0,1,0,4970,1030]
["6000-56",0,1,1,0,0,0,2,5810,190]
["6000-57",0,1,1,0,0,0,1,4830,1170]
["6000-58",0,1,1,0,0,0,0,3850,2150]
["6000-59",0,1,0,2,0,0,0,5120,880]
["6000-60",0,1,0,1,2,0,0,5940,60]
["6000-61",0,1,0,1,1,1,0,5920,80]
["6000-62",0,1,0,1,1,0,1,5780,220]
["6000-63",0,1,0,1,1,0,0,4800,1200]
["6000-64",0,1,0,1,0,2,0,5900,100]
["6000-65",0,1,0,1,0,1,1,5760,240]
["6000-66",0,1,0,1,0,1,0,4780,1220]
["6000-67",0,1,0,1,0,0,2,5620,380]
["6000-68",0,1,0,1,0,0,1,4640,1360]
["6000-69",0,1,0,1,0,0,0,3660,2340]
["6000-70",0,1,0,0,3,0,0,5620,380]
["6000-71",0,1,0,0,2,1,0,5600,400]
["6000-72",0,1,0,0,2,0,1,5460,540]
["6000-73",0,1,0,0,2,0,0,4480,1520]
["6000-74",0,1,0,0,1,2,0,5580,420]
["6000-75",0,1,0,0,1,1,1,5440,560]
["6000-76",0,1,0,0,1,1,0,4460,1540]
["6000-77",0,1,0,0,1,0,2,5300,700]
["6000-78",0,1,0,0,1,0,1,4320,1680]
["6000-79",0,1,0,0,1,0,0,3340,2660]
["6000-80",0,1,0,0,0,3,0,5560,440]
["6000-81",0,1,0,0,0,2,1,5420,580]
["6000-82",0,1,0,0,0,2,0,4440,1560]
["6000-83",0,1,0,0,0,1,2,5280,720]
["6000-84",0,1,0,0,0,1,1,4300,1700]
["6000-85",0,1,0,0,0,1,0,3320,2680]
["6000-86",0,1,0,0,0,0,3,5140,860]
["6000-87",0,1,0,0,0,0,2,4160,1840]
["6000-88",0,1,0,0,0,0,1,3180,2820]
["6000-89",0,1,0,0,0,0,0,2200,3800]
["6000-90",0,0,3,0,0,0,1,5930,70]
["6000-91",0,0,3,0,0,0,0,4950,1050]
["6000-92",0,0,2,1,1,0,0,5900,100]
["6000-93",0,0,2,1,0,1,0,5880,120]
["6000-94",0,0,2,1,0,0,1,5740,260]
["6000-95",0,0,2,1,0,0,0,4760,1240]
["6000-96",0,0,2,0,2,0,0,5580,420]
["6000-97",0,0,2,0,1,1,0,5560,440]
["6000-98",0,0,2,0,1,0,1,5420,580]
["6000-99",0,0,2,0,1,0,0,4440,1560]
["6000-100",0,0,2,0,0,2,0,5540,460]
["6000-101",0,0,2,0,0,1,1,5400,600]
["6000-102",0,0,2,0,0,1,0,4420,1580]
["6000-103",0,0,2,0,0,0,2,5260,740]
["6000-104",0,0,2,0,0,0,1,4280,1720]
["6000-105",0,0,2,0,0,0,0,3300,2700]
["6000-106",0,0,1,2,1,0,0,5710,290]
["6000-107",0,0,1,2,0,1,0,5690,310]
["6000-108",0,0,1,2,0,0,1,5550,450]
["6000-109",0,0,1,2,0,0,0,4570,1430]
["6000-110",0,0,1,1,2,0,0,5390,610]
["6000-111",0,0,1,1,1,1,0,5370,630]
["6000-112",0,0,1,1,1,0,1,5230,770]
["6000-113",0,0,1,1,1,0,0,4250,1750]
["6000-114",0,0,1,1,0,2,0,5350,650]
["6000-115",0,0,1,1,0,1,1,5210,790]
["6000-116",0,0,1,1,0,1,0,4230,1770]
["6000-117",0,0,1,1,0,0,2,5070,930]
["6000-118",0,0,1,1,0,0,1,4090,1910]
["6000-119",0,0,1,1,0,0,0,3110,2890]
["6000-120",0,0,1,0,3,0,0,5070,930]
["6000-121",0,0,1,0,2,1,0,5050,950]
["6000-122",0,0,1,0,2,0,2,5890,110]
["6000-123",0,0,1,0,2,0,1,4910,1090]
["6000-124",0,0,1,0,2,0,0,3930,2070]
["6000-125",0,0,1,0,1,2,0,5030,970]
["6000-126",0,0,1,0,1,1,2,5870,130]
["6000-127",0,0,1,0,1,1,1,4890,1110]
["6000-128",0,0,1,0,1,1,0,3910,2090]
["6000-129",0,0,1,0,1,0,3,5730,270]
["6000-130",0,0,1,0,1,0,2,4750,1250]
["6000-131",0,0,1,0,1,0,1,3770,2230]
["6000-132",0,0,1,0,1,0,0,2790,3210]
["6000-133",0,0,1,0,0,3,1,5990,10]
["6000-134",0,0,1,0,0,3,0,5010,990]
["6000-135",0,0,1,0,0,2,2,5850,150]
["6000-136",0,0,1,0,0,2,1,4870,1130]
["6000-137",0,0,1,0,0,2,0,3890,2110]
["6000-138",0,0,1,0,0,1,3,5710,290]
["6000-139",0,0,1,0,0,1,2,4730,1270]
["6000-140",0,0,1,0,0,1,1,3750,2250]
["6000-141",0,0,1,0,0,1,0,2770,3230]
["6000-142",0,0,1,0,0,0,4,5570,430]
["6000-143",0,0,1,0,0,0,3,4590,1410]
["6000-144",0,0,1,0,0,0,2,3610,2390]
["6000-145",0,0,1,0,0,0,1,2630,3370]
["6000-146",0,0,1,0,0,0,0,1650,4350]
["6000-147",0,0,0,4,0,0,0,5840,160]
["6000-148",0,0,0,3,1,0,0,5520,480]
["6000-149",0,0,0,3,0,1,0,5500,500]
["6000-150",0,0,0,3,0,0,1,5360,640]
["6000-151",0,0,0,3,0,0,0,4380,1620]
["6000-152",0,0,0,2,2,0,0,5200,800]
["6000-153",0,0,0,2,1,1,0,5180,820]
["6000-154",0,0,0,2,1,0,1,5040,960]
["6000-155",0,0,0,2,1,0,0,4060,1940]
["6000-156",0,0,0,2,0,2,0,5160,840]
["6000-157",0,0,0,2,0,1,2,6000,0]
["6000-158",0,0,0,2,0,1,1,5020,980]
["6000-159",0,0,0,2,0,1,0,4040,1960]
["6000-160",0,0,0,2,0,0,3,5860,140]
["6000-161",0,0,0,2,0,0,2,4880,1120]
["6000-162",0,0,0,2,0,0,1,3900,2100]
["6000-163",0,0,0,2,0,0,0,2920,3080]
["6000-164",0,0,0,1,3,1,0,6000,0]
["6000-165",0,0,0,1,3,0,1,5860,140]
["6000-166",0,0,0,1,3,0,0,4880,1120]
["6000-167",0,0,0,1,2,2,0,5980,20]
["6000-168",0,0,0,1,2,1,1,5840,160]
["6000-169",0,0,0,1,2,1,0,4860,1140]
["6000-170",0,0,0,1,2,0,2,5700,300]
["6000-171",0,0,0,1,2,0,1,4720,1280]
["6000-172",0,0,0,1,2,0,0,3740,2260]
["6000-173",0,0,0,1,1,3,0,5960,40]
["6000-174",0,0,0,1,1,2,1,5820,180]
["6000-175",0,0,0,1,1,2,0,4840,1160]
["6000-176",0,0,0,1,1,1,2,5680,320]
["6000-177",0,0,0,1,1,1,1,4700,1300]
["6000-178",0,0,0,1,1,1,0,3720,2280]
["6000-179",0,0,0,1,1,0,3,5540,460]
["6000-180",0,0,0,1,1,0,2,4560,1440]
["6000-181",0,0,0,1,1,0,1,3580,2420]
["6000-182",0,0,0,1,1,0,0,2600,3400]
["6000-183",0,0,0,1,0,4,0,5940,60]
["6000-184",0,0,0,1,0,3,1,5800,200]
["6000-185",0,0,0,1,0,3,0,4820,1180]
["6000-186",0,0,0,1,0,2,2,5660,340]
["6000-187",0,0,0,1,0,2,1,4680,1320]
["6000-188",0,0,0,1,0,2,0,3700,2300]
["6000-189",0,0,0,1,0,1,3,5520,480]
["6000-190",0,0,0,1,0,1,2,4540,1460]
["6000-191",0,0,0,1,0,1,1,3560,2440]
["6000-192",0,0,0,1,0,1,0,2580,3420]
["6000-193",0,0,0,1,0,0,4,5380,620]
["6000-194",0,0,0,1,0,0,3,4400,1600]
["6000-195",0,0,0,1,0,0,2,3420,2580]
["6000-196",0,0,0,1,0,0,1,2440,3560]
["6000-197",0,0,0,1,0,0,0,1460,4540]
["6000-198",0,0,0,0,5,0,0,5700,300]
["6000-199",0,0,0,0,4,1,0,5680,320]
["6000-200",0,0,0,0,4,0,1,5540,460]
["6000-201",0,0,0,0,4,0,0,4560,1440]
["6000-202",0,0,0,0,3,2,0,5660,340]
["6000-203",0,0,0,0,3,1,1,5520,480]
["6000-204",0,0,0,0,3,1,0,4540,1460]
["6000-205",0,0,0,0,3,0,2,5380,620]
["6000-206",0,0,0,0,3,0,1,4400,1600]
["6000-207",0,0,0,0,3,0,0,3420,2580]
["6000-208",0,0,0,0,2,3,0,5640,360]
["6000-209",0,0,0,0,2,2,1,5500,500]
["6000-210",0,0,0,0,2,2,0,4520,1480]
["6000-211",0,0,0,0,2,1,2,5360,640]
["6000-212",0,0,0,0,2,1,1,4380,1620]
["6000-213",0,0,0,0,2,1,0,3400,2600]
["6000-214",0,0,0,0,2,0,3,5220,780]
["6000-215",0,0,0,0,2,0,2,4240,1760]
["6000-216",0,0,0,0,2,0,1,3260,2740]
["6000-217",0,0,0,0,2,0,0,2280,3720]
["6000-218",0,0,0,0,1,4,0,5620,380]
["6000-219",0,0,0,0,1,3,1,5480,520]
["6000-220",0,0,0,0,1,3,0,4500,1500]
["6000-221",0,0,0,0,1,2,2,5340,660]
["6000-222",0,0,0,0,1,2,1,4360,1640]
["6000-223",0,0,0,0,1,2,0,3380,2620]
["6000-224",0,0,0,0,1,1,3,5200,800]
["6000-225",0,0,0,0,1,1,2,4220,1780]
["6000-226",0,0,0,0,1,1,1,3240,2760]
["6000-227",0,0,0,0,1,1,0,2260,3740]
["6000-228",0,0,0,0,1,0,4,5060,940]
["6000-229",0,0,0,0,1,0,3,4080,1920]
["6000-230",0,0,0,0,1,0,2,3100,2900]
["6000-231",0,0,0,0,1,0,1,2120,3880]
["6000-232",0,0,0,0,1,0,0,1140,4860]
["6000-233",0,0,0,0,0,5,0,5600,400]
["6000-234",0,0,0,0,0,4,1,5460,540]
["6000-235",0,0,0,0,0,4,0,4480,1520]
["6000-236",0,0,0,0,0,3,2,5320,680]
["6000-237",0,0,0,0,0,3,1,4340,1660]
["6000-238",0,0,0,0,0,3,0,3360,2640]
["6000-239",0,0,0,0,0,2,3,5180,820]
["6000-240",0,0,0,0,0,2,2,4200,1800]
["6000-241",0,0,0,0,0,2,1,3220,2780]
["6000-242",0,0,0,0,0,2,0,2240,3760]
["6000-243",0,0,0,0,0,1,4,5040,960]
["6000-244",0,0,0,0,0,1,3,4060,1940]
["6000-245",0,0,0,0,0,1,2,3080,2920]
["6000-246",0,0,0,0,0,1,1,2100,3900]
["6000-247",0,0,0,0,0,1,0,1120,4880]
["6000-248",0,0,0,0,0,0,6,5880,120]
["6000-249",0,0,0,0,0,0,5,4900,1100]
["6000-250",0,0,0,0,0,0,4,3920,2080]
["6000-251",0,0,0,0,0,0,3,2940,3060]
["6000-252",0,0,0,0,0,0,2,1960,4040]
["6000-253",0,0,0,0,0,0,1,980,5020]