Spreadsheet: 847977d1698803535-redistribute-percentage-set-to-a-fixed-a-column-and-row-total-dhong8817-book1
Sheet: Sheet1 (2)

 | Daily 2_2 | region1 | region2 | region3 | region4 | region5 | region6 | region7 | region8 | Grand Total | Target  Percentage
 | Product 1 | 0.05140128538776334 | 0.008776565135286764 | 0.008582348737503687 | 0.00716516867369337 | 0.01435268318265647 | 0.01247234749452377 | 0 | 0.002985057260325355 |  | 0.1057354473455248
 | Product 2 | 0.00101568725016099 | 1.435422619271978e-05 | 2.345313818970968e-05 | 0.002458058931979474 | 0.0009246462841443232 | 0 | 0 | 0 |  | 0.004436203660252819
 | Product 3 | 0.003953888316373271 | 0 | 0.00980080391858369 | 0.1167281630274155 | 0 | 0 | 0 | 0 |  | 0.1304828468311815
 | Product 4 | 0.003511703611863154 | 0.003585055460418489 | 0.01083611141377231 | 0.02146671802399036 | 0.002981336073815601 | 0 | 0 | 0 |  | 0.04238092727527514
 | Product 5 | 0.04113613227319255 | 0.01275677036908844 | 0.009654150654451204 | 0.007400747169408828 | 0.01472984700986123 | 0.007893905384585845 | 0 | 0.00478779281401259 |  | 0.09835933688409278
 | Product 6 | 0.004103702624318282 | 0.0009597662064577503 | 9.97373182309566e-07 | 0.0001707251574648313 | 0.001683466920574578 | 0 | 0 | 0 |  | 0.00691865745526695
 | Product 7 | 0.04108380987848281 | 0.006557759458809212 | 0.001234030312019123 | 0.001319061543383063 | 0.003908520635358252 | 0.005614010407570609 | 0.001472798720030901 | 0 |  | 0.06118998753410695
 | Product 8 | 0.006688504688066419 | 0.001455679619279538 | 1.003417276378609e-06 | 1.013836830571695e-05 | 0.001491994503838382 | 0.0009963003440606145 | 0 | 0 |  | 0.01064362474271113
 | Product 9 | 0.007718775463974707 | 0.0009845605268577417 | 7.377851283925442e-06 | 0.0003498327247764713 | 0.0009706959687085482 | 0.0005179629818142808 | 0.0007128141814537011 | 0 |  | 0.01126201600063806
 | Product 10 | 0.004976244809740704 | 0.0008361284766213184 | 1.000216540588774e-06 | 8.537841100561414e-06 | 0.0006908778758180973 | 0 | 0 | 0 |  | 0.006512787802365763
 | Product 11 | 0.008697641451596589 | 0.001791228471673224 | 1.056146656092569e-05 | 0.0002347910276823021 | 0.003065412765456701 | 0.0004416456529712577 | 0 | 0 |  | 0.01424128459720378
 | Product 12 | 0.03251002297031746 | 0.006943531588831673 | 0.002593204368103769 | 0.02322828124767748 | 0.007142524520774248 | 0.00519331895144161 | 0.002236524208458943 | 0 |  | 0.07984740447206076
 | Product 13 | 0.02220511786653856 | 0.005750168125567202 | 0.003542362579139201 | 0.008023849248628043 | 0.00538625768839178 | 0.005891493771517619 | 0.001585896181974442 | 0 |  | 0.05238514192410795
 | Product 14 | 0.009871449066248312 | 0.003253399750171679 | 5.16965049056658e-05 | 0.0008381820072130021 | 0.002997963422524679 | 0.0008887793871231261 | 0 | 0 |  | 0.01790147391800914
 | Product 15 | 0.0008922719276075646 | 0.0002470858692497731 | 9.79155341301298e-07 | 1.029393007391694e-06 | 0.0002012048971917546 | 6.671251714462008e-05 | 0 | 0 |  | 0.001409289387413713
 | Product 16 | 0.002752517412934102 | 0 | 0 | 0.005366564140425517 | 0.0001062891005845553 | 0 | 0 | 0 |  | 0.00822536017846971
 | Product 17 | 0.004655908181476029 | 8.63527796993811e-05 | 2.704778167051271e-06 | 0.006571094747427931 | 3.964413426792535e-05 | 0 | 0 | 0 |  | 0.01135570680676753
 | Product 18 | 0.0135926124415458 | 0.002096420702950448 | 5.790868158032661e-05 | 1.822773997591552e-05 | 0.000161488821339127 | 0.0001396354737068589 | 0 | 0 |  | 0.01606629748938991
 | Product 19 | 0.01295241822872448 | 0.002872500196257317 | 0.0005616909740895808 | 0.000178565577802435 | 0.002902294931026302 | 4.121220348362823e-06 | 0 | 0 |  | 0.01947159498557894
 | Product 20 | 0.0002336451122903156 | 0 | 0 | 3.260677245718089e-05 | 0 | 0 | 0 | 0 |  | 0.0002662046134316532
 | Product 21 | 0.0150040564406596 | 0.00134695496499026 | 0.02158452895381368 | 0.006305771201384806 | 0.0006486784896064817 | 0.006070929517882886 | 0 | 0 |  | 0.05096089952770841
 | Product 22 | 0.02635112427836709 | 0.006495056458666154 | 0.001142132941223984 | 0.0008730272833038933 | 0.003649109580787928 | 0.000656686642271438 | 0 | 0 |  | 0.0391671394358775
 | Product 23 | 0.03110407376745664 | 0.008638784485608854 | 0.01229036149345359 | 0.01045571217237684 | 0.003834591130107051 | 0.0048937552188591 | 0 | 0 |  | 0.07121728076171556
 | Product 24 | 0.05748111568731169 | 0.008053296125152612 | 0.01675425505321594 | 6.007055156985665e-06 | 0.002706980076962683 | 0.004771179454239039 | 0 | 0 |  | 0.08977283627711717
 | Product 25 | 0.02962015792485104 | 0.008454011125062581 | 0.003021976974402812 | 0.002144632295267558 | 0.003557168000238149 | 0.002087340484386454 | 0 | 0 |  | 0.04888528938625501
 | Product 26 | 0.0007198455846687821 | 0 | 0 | 9.855307112839662e-07 | 0 | 0 | 0 | 0 |  | 0.0007207042115110304
 | Product 27 | 0.0001843961730908054 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0.0001842564959664085
 | Grand Total |  |  |  |  |  |  |  |  | 0.9999999999999991 | 1
 | Target Percentage | 0.4344180078898995 | 0.09195536807775406 | 0.1017555947617047 | 0.2213564037826813 | 0.07813360790925562 | 0.05860010021030566 | 0.006008029370419013 | 0.007772887997979601 | 1