{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Control","Workflow","Input","No_Issue","Conflicts","Conflicts_Solved"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Control","index":0,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,4,11,4],[4,2,6,4]]}
["Fair Random Distribution of Items to Collectors"]
[]
["Collectors",5]
["Items",10]
["Distribution Type",7,"1 = Distribute according to request count, 2 = Distribute according to total value, 3 = Random sort of conflicts + distribution (count), 4 = Random sort of conflicts + distribution (total value), 5 = equal chances, 6 = Like 3 but small count wins, 7 = Like 1 but start with equal chances and reduce them when an item is won"]
[]
[]
[null,null,"We simulate this",null,"We do it for real"]
[]
[null,null,null,null,"Press button \"Create tab Input\", overwrite tab Input with your real data and create a safety copy of this file."]
[]
[]
[]
[null,null,null,null,null,null,null,"Collector 1","Collector 2","Collector 3","Collector 4","Collector 5"]
[null,null,null,null,null,null,"Item requests with conflicts [count]",3,1,3,3,6]
[null,null,null,null,null,null,"Open requests after distribution [count]",0,1,2,1,3]
[null,null,null,null,null,null,"Item requests with conflicts [total value]",1810,950,2010,1160,5850]
[null,null,null,null,null,null,"Open requests after distribution [total value]",0,950,600,620,2540]

{"sheet":"Workflow","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Message"]
[]
[null,null,null,null,"EVER: BERND-CAPTIVA\\earso 07.12.2023 08:19:47 [Start_Log] - Logging started with Fair_Random_Distribution_of_Items_v0.2"]
[null,null,null,null,"EVER: BERND-CAPTIVA\\earso 07.12.2023 08:19:47 [Start_Log] - Windows (64-bit) NT 10.00 / Microsoft Windows 11 Home 10.0.22000 and Microsoft Excel [Excel 2021/365] (64-bit) 16.014332 (191029)"]
[null,null,null,null,"INFO: BERND-CAPTIVA\\earso 07.12.2023 08:19:47 [Start_Log] - Application ThousandsSeparator '.', DecimalSeparator ',', use system separators"]
[null,null,null,null,"INFO: BERND-CAPTIVA\\earso 07.12.2023 08:19:47 [Start_Log] - App.Internl ThousandsSeparator '.', DecimalSeparator ',', ListSeparator ';'"]
[null,null,null,null,"INFO: BERND-CAPTIVA\\earso 07.12.2023 08:19:47 [Start_Log] - App.Internl xlCountryCode '49', xlCountrySetting '49'"]
[null,null,null,null,"INFO: BERND-CAPTIVA\\earso 07.12.2023 08:19:47 [Start_Log] - VBAProject References: Visual Basic For Applications, Microsoft Excel 16.0 Object Library, OLE Automation, Microsoft Office 16.0 Object Library"]
[null,null,null,null,"EVER: BERND-CAPTIVA\\earso 07.12.2023 08:19:49 [End_Log] - Logging finished with Fair_Random_Distribution_of_Items_v0.2"]

{"sheet":"Input","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Items","Est. Value","There are this many","Collector 1 wants","Collector 2 wants","Collector 3 wants","Collector 4 wants","Collector 5 wants"]
["Item 1",240,1,3,0,2,0,0]
["Item 2",870,1,0,0,0,0,0]
["Item 3",390,1,0,2,0,0,0]
["Item 4",850,1,0,3,0,0,0]
["Item 5",360,1,0,0,3,3,0]
["Item 6",1410,2,0,0,1,0,2]
["Item 7",400,1,0,0,0,0,0]
["Item 8",180,1,0,0,0,1,1]
["Item 9",950,3,1,1,0,0,3]
["Item 10",620,1,2,0,0,2,0]

{"sheet":"No_Issue","index":3,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Items","Est. Value","There are this many","Collector 1 wants","Collector 2 wants","Collector 3 wants","Collector 4 wants","Collector 5 wants"]
["Item 2",870,1,0,0,0,0,0]
["Item 3",390,1,0,1,0,0,0]
["Item 4",850,1,0,1,0,0,0]
["Item 7",400,1,0,0,0,0,0]

{"sheet":"Conflicts","index":4,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Items","Est. Value","There are this many","Collector 1 wants","Collector 2 wants","Collector 3 wants","Collector 4 wants","Collector 5 wants","Random Sort Key"]
["Item 9",950,3,1,1,0,0,3,0.78213870525360096]
["Item 6",1410,2,0,0,1,0,2,0.74741578102111805]
["Item 5",360,1,0,0,1,1,0,0.68406230211257901]
["Item 8",180,1,0,0,0,1,1,0.61393493413925104]
["Item 1",240,1,1,0,1,0,0,0.19063341617584201]
["Item 10",620,1,1,0,0,1,0,0.16174370050430301]

{"sheet":"Conflicts_Solved","index":5,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Items","Est. Value","There are this many","Collector 1 wants","Collector 2 wants","Collector 3 wants","Collector 4 wants","Collector 5 wants"]
["Item 9",950,3,1,0,0,0,2]
["Item 6",1410,2,0,0,1,0,1]
["Item 5",360,1,0,0,0,1,0]
["Item 8",180,1,0,0,0,1,0]
["Item 1",240,1,1,0,0,0,0]
["Item 10",620,1,1,0,0,0,0]