В MS Excel, при создании сводной таблицы, есть интересный функционал, когда в строках необходимо сгруппировать некоторые позиции по принадлежности к чему-то общему. Например, яблоки, груши - это фрукты, а огурцы и помидоры - это овощи. Выглядит это в сводной таблице вот таким образом (обратите внимание на кнопки со значком минус прямо в ячейке):
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAATIAAAEyCAYAAAB5xlzFAAAgAElEQVR4Xu2dCdyN1fbHVze5RShTZawMyTwrZMo8C0lRlDKGTEUpczJPlSIqJCIyZJ5D5spQisyREKk03dv/fHf/573nPc70vu85z3nOOWt/Pj7d+55n2Pu39vN71lp7P+t3zaVLl/4WV/v6668lf/78/E9tioAioAhEFQLXKJFFlb20s4qAIuAFgUREpggpAoqAIhCNCCQisltuucW2Mbz8aivp23mmbffTG0UHAj/88INkyZIlOjqrvQyIgF32VCILaAo9wE4E7Jr4do4pnu9llz2VyOJ5ljlw7HZNfAcOPSa7ZJc9lchicvpE76DsmvjRi1B09dwue9pGZD/99JOkT58+wQqaI4uuCWlXb+2a+HaNJ97vY5c9bSEySOz8+fNyxx13KJF5mdlffvmljBw5UurUqSPNmzeP67lv18SPFMi9e/c2zwLt2muvlUyZMkmtWrWkatWqkepSWO9rlz3DTmQWiYGWEpn3OfP222/Lzp075YYbbpARI0bINddcE9bJ5eSL2zXxI4UBRFakSBGpX7++/Pnnn/LFF1/I7NmzpVOnTlK6dOlIdSts97XLnmElMncSUyLzPlf+85//SLdu3aRx48ZmQvft21fy5s0btonl9AvbNfEjhQNEBmG1aNEioQsDBgyQHDlySLt27SLVrbDd1y57ho3IPElMicz7XNmzZ4+8/vrrMmHCBBk3bpyZ0K1atQrbxHL6he2a+JHCwRuRDR48WHLlyiWPPfZYpLoVtvvaZc+wEJk3ElMi8z5XILE//vjDeGWrV6+WJUuWyOjRo03+JB6bXRM/Uti6Exne+KeffiozZ86Ufv36Sc6cOSPVrbDd1y57hpzIfJGYEtnVc+W3336T7t27S+vWraVChQpy4cIF6dWrl/To0UMKFy4ctsnl5AvbNfEjhQFE9uOPP8q//vUvgchoLPDUrl07Ul0K633tsmdIicwfiSmRXT1ftm7dKtOmTTMhZdq0ac0BgwYNkmzZssVkviSYJ8auiR9MX8JxDERWqFAhqVu3riGyU6dOGY+MF1ksrljbZc+QEVkgElMiu/qxgMD27t0r119/fcKPhJnXXXedjB8/3vw33ppdEz9SuHrLkS1dulQ+/vhjefXVVyPVrbDd1y57hoTIgiExJbLEc+Xy5csmhGT1qmTJkgk/8ne8so4dO8bkcnygJ8auiR+oH+H63RuRLVq0SNauXWs881hrdtkzxUQWLIkpkSWeokzc999/30zeNGnSJPpx2LBhkiFDBuncuXOszeuA47Fr4gfsSJgOcN9H9vfff8vx48eFfYT33HOPtGzZMkx3jdxl7bJniogsKSSmRJZ4Mr388suGrNgI6dk2bNgg7733ngkv3cPOyE1H++5s18S3b0SJ7+S+s5+EPzv7y5UrJw0aNIjJVIJd9kw2kSWVxJTIIvXoRNd97Zr40YVK9PbWLnsmi8iSQ2JKZNE7Ge3suV0T384xxfO97LJnsogsFIbR6hehQDH2rmHXxI895Jw5IrvsqUTmTPvHba/smvhxC7DNA7fLnkpkNhtWb+cfAbsmvtrBHgTssmciIps2r6c9o/v/u7R7cKyt99ObKQKKQGwiEDGPDKZ23wgam/DqqJKKwI4dO6RMmTJJPU2PdygCdtlTicyhEyBeu2XXxI9XfO0et132VCKz27J6P78I2DXx1Qz2IGCXPZXI7LGn3iVIBOya+EF2Rw9LIQJ22VOJLIWG0tNDi4BdEz+0vdar+ULALnummMiOHj0qo0aNkkaNGkmNGjWCtqgm+4OGKq4OtGvixxWoERysXfZMEZEdOnRIxo4dK1euXDFf7iuRRXDGxMit7Zr4MQKX44dhlz2TTWTffPONIbFq1arJ9u3bDYkpkTl+Xjm+g3ZNfMcDESMdtMueySYy6igdOXJEKleuLJQmqVmzphJZjEy+SA7DrokfyTHG073tsmeyiczdGEpk8TQ1wztWuyZ+eEehV7cQsMueSmQ65xyFgF0T31GDjuHO2GVPJbIYnkTRODS7Jn40YhONfbbLnkpk0Tg7YrjPdk38GIbQUUOzy55KZI4yu3bGromvSNuDgF32TBGRWUrJzz33nFSvXt38Q1DhmmuuCYiSbogNCFFcHmDXxI9LcCMwaLvsmSIie/zxx6+Cpk2bNlKpUqWAkCmRBYQoLg+wa+LHJbgRGLRd9kwRkaUEFyWylKAXu+faNfFjF0FnjcwueyqROcvucd8buyZ+3ANtEwB22VOJzCaD6m2CQ8CuiR9cb/SolCJglz2VyFJqKT0/pAjYNfFD2mm9mE8E7LKnEplOQkchYNfEd9SgY7gzdtkzEZGxdcLOZm3fsPOeei9FQBGIPQTUI4s9m0b1iOx6g0c1SFHUebvsqUQWRZMiHrpq18SPByydMEa77KlE5gRrax8SELBr4ivk9iBglz2VyOyxp94lSATsmvhBdkcPSyECdtlTiSyFhtLTQ4uAXRM/tL3Wq/lCwC57JpvI/v77b1m6dKls2LBBfv31VylQoIA8/PDDkilTpqCsqp8oBQVT3B1k18SPO2AjNGC77JlsIlu2bJmsWrVK+HA8Q4YMMnfuXLl8+bK89NJLWv0iQpMmFm5r18SPBayiYQx22TPZREad/iZNmkj58uUNnidOnDAkNnz4cMmaNWtAjNUjCwhRXB5g18SPS3AjMGi77JksIiOsPHz4sNxxxx1y7bXXGnhOnz4tzz//vAwcOFBy5swZEDIlsoAQxeUBdk38uAQ3AoO2y57JIjJveCxZssSEmqNHj5ZUqVIFhEyJLCBEcXmAXRM/LsGNwKDtsmdIiOzs2bMyYMAAE2oGK9KrRBaBWRUFt7Rr4kcBFDHRRbvsmWIiI8H/8ssvS7Zs2aRz585BJfqxkBJZTMzTkA/Crokf8o7rBb0iYJc9U0Rkv//+u4wcOVLImfXp00f+/e9/B21OJbKgoYqrA+2a+HEFagQHa5c9k01kVK4YP3688az69esn6dKlSxJcSmRJgituDrZr4scNoBEeqF32TBaR4YFNnTpV9u/fL08//bTcfPPNBi7Uk9KnT5+wkukPQyWyCM8wh97eronv0OHHXLfssmeyiOzQoUMybNgwQ1yQmntr1aqVVKtWLaBBlMgCQhSXB9g18eMS3AgM2i57JovIQoGHElkoUIy9a9g18WMPOWeOyC57KpE50/5x2yu7Jn7cAmzzwO2ypxKZzYbV2/lHwK6Jr3awBwG77KlEZo899S5BImDXxA+yO3pYChGwy55KZCk0lJ4eWgTsmvih7bVezRcCdtkzoipKN+W6W2eAIqAIxDgC54/sC/sII+qRKZGF3b56A0Ug4gjcmfmGsPdBiSzsEOsNFIH4RkCJLL7tH1WjD1X4kOmOwlE1bu1sYASUyAJjpEc4BAGIrEyZMinqDYlhJbIUQejIk5XIHGkW7ZQ3BJTIdF74QsDxRLZ+/XpZsWKFXLp0SXLnzm1UlIIpc82A+UTJSvaf+e6UVCiWT9KkSSt7j/2QCI8a9xaXbw99LfOWrZcSpcvqbHEoAuEisos/XpBB/XrJqmVLxPVhrxQtUUqe6fuilC73j1ZEtLeFH8yWnp2eMIUWtuw9LJmzBNa7cNKYd27bIg81qCEffLzO5/PpaCLbunWrzJw5U9q2bWuKKi5evFi++eYbIz4SbKlrJTInTcmU9SUcREZBghb1q8uendukXuNmkuq662TF4oVyX7Xq8tr02SnrsEPObvfwA7Ju1XLTm5eGj5FHn+jgkJ4F142333xVBj/f26+j4WgiGzp0qBQrVkzq169vRvzTTz9J9+7dpX///kaUJFBTjywQQtH1uyeR/fHHHwEHkDp16kTHeObIvty/V+pXKSc16zWU199+3xz7/ZnTpoDnTTdnDHh9px9w6eJFKVswtxQpXlL2frZbipUoLXOXrnF6txP17/keXeT9GdOil8jOnDkjGTNmFGsy/vzzz9K1a1dTuz9XrlwBjZFcIsPgr44ZLtu2bDL3qFj5fhk4YpxkzJRZvjt5Qob07yOfrF9rSgwVLlZC+vQfLMVKljbH5smSJqFfhLF3FSwkzw0YlhCm+Lv277//JgVzZEwU/u7ZuV2a1akipcreayagt2OYrA/UqiRnXQ+gFTafPnXS9HPH1s1y/tz/QunDP/zqFbcL589J/95dZeOaVS6vJJU0efBh6fPiEKnoCsd/vHDhqnOWrN9mCKB+k+ZSskw5mfraeDnvCuXrP9BcBo8c7yKC6805V678KuNfGSKENxcv/ih58uaXHv0GyP216prffzj7vdxT6A655bZssuWLQ+Zvz3RoK4s/nCt9B74sT3TsmnBvTyLr27dvwDlAiXT35klkWzauk9ZN68mdrn7NWbLa2Ni9Hf7moNQsX0LyFSgoyzftND9ZodoDD7WSkRPfTLB7leq1zHFzXA/dDS7bj3/zHblw7pyMHPKikNooVLS4DB09UfLedfUm7WDsGmjueQNjzsy3pd8znaT/0JGywWXbTetc//YclNuy50g4nDmb1L7/fPknM64VSz4ydr0zbz55qksPady8pbluMLhZY65Vv5HkzX+3zJ05Xf788w/jGfcfMlKuc72EHmvewPWsJSbeDbu/lBw5cycarqM9Mvee4o3NmTPH5L2YwJBIoJYcIiteqoyZuBfO/yC16zeR71yEsHHtSgFsQo0dn26W3l2elAqV/6mHtmDOe3L9DdfLtv1HDfBMirQ3ppNWjz8lF10EMH/OTFdRyIzy6f4jpq6av2snl8jIf/Bwuef/WjasKdu3fmL6CdnOnPam/PLzZfFGZFTirecipW++OmAm9M2uh3nl0kUy+6MVrpBkmVF5nzV9ijB5GRfjIzwh5/ivf/3LPBSVqtUwE+7EsaPSvmtPQ+60Ng82dD08q11kd4/cXbiILHeFbRDrpGmzpE6DJlcR2ca1q6Rti0aGWJZt3GFCPat588jQOfXVkA0M5JHRl4rF88sfrpLq4Acxt2nfWe66u1DQDyQHWi+wvPkLyD0VKxkihsx5ydRu0Fh+unTRhHcFChaWpRu2X9Vlb7b3tGuguecNB0gasl6/64B5Sb3Yp5t5sT7ZuXsiIuP/JKXvFsF42nXiWzOlbsMHkkRk3Dt7zlxm7oERhD1g+Fhp/UR7mf3OWzLJ5VTwIuDlmvXW26T90z0lw003RR+Rbd++XSZPnmwqw/bo0SMob4xReiMyf+RnJft/vHDePAA8sDzkZQrkdHkWV2TfsXOJKtPixTzcuLacOHpEdhw8bh4EJrS7d/GI6/fPdu0wnhIPvb9r//XXn0n2yNas+Fg6tW0pf/35ZyIiK5wrs/GG9h0/JzfckEbKF80r35/+ziuR8VblGvdUrCyzFiwzEDFuS0+U/1+pZAE5deK4bP78G7k1W/YEzzC1KwTbuvdbVxh2sxzY+7k0qHavZMl6iyFuiI0Jj1e6ZN02M/49O7ZJs7pVJVfuO2Tdzv2JiGzVlj3SvF41OXhgv0x7f6FUvr9mInN5y5ERXnojM28kxsW8bb+YN/tdlzfazZAZjfzr8PGTzYMTjGdhERnjw87XX3+DvDZuhIweOiDhBchLrHyRPHL2+zOy46vjV3l+nkTmy64WIN7mnufcPvfDWXPPO/PdZbxJ7M884MX20erNiYgsKX3fv/czadO8oVe75sx9u6zfeSAo3KwxQ/jbDhyVdK7nmxdoxzYPJeBGJx+sd7/s2r41ekNLC2lIhDBz48aNsm3bNhk0aJBkzpw4BPBGUN6IjDe8e7jCeYQCF3/8MRFQTOCd27Ya409/Y6LrjXpJdn19MiFvYr2BmQDkVqrX+SeP5+6RMWmXLpwnPfq+lOgN6OvaN6RJY4jMW/MWWn7iIpVaFUpInYZN5N2pkxMRWZ+u7WX+7BkmpC1Z9h7jUfnyyCaOGibjXOFf5x7Pufr6otf7+yIydy/wv//9rxTIlsGQIAQ6/Y1J5mHGixv4yriE696d42ZDGjzQHEto6d4aNm0hYydPv6ofvpL9nmTmi8R8ERl/56FfMPc9l+f6hpw8fswQDf1LCpFB/F+fuWz6/d7bU02ojleBd0GrfV9p4/WudBF2Hhe5uDd3IvNnV2uO8V/PuecJ2LtvTZaBz/WQ5g8/Jh279zI/t3u4qVmhX7t9r+S+I0/CnE1K31cs/SigXXlhBwrJvXmhrFCy+FKu/H3ynisioMUMkbkbqHfv3nL//fdL7dq1vT5w7n9MTmhZxPW26t6+jSxbvOCq6+88eEJuzpjJ/H3E4P5m8n80733JffudsmjtFvMmds+RcRxeXctHHzfu/H/++svvtdOkTWuIzJ1syXvxgHkS2Y3p0ksNF3mSQ/twxUYpmS9bIiKDIIb2f1bemfJaonF4Cy0njX5Zxg4fLJ2fedaVv/IeqgVDZH+6vCNIigds//HzMvX18TJqyEuJHmY6YxEZeP7lwgQiA6dmLVu7XirT5Y8/fpfZi1Zetf3B36qlRWbkT/0pbQXaEMsLq4LLa/n1119k/4nzxgsN9EBa5JIUMvBFZIHs6m/ueU5YiwC8PSi8sHhxJafvKz9eZOzq6wWFXfEYA+EWF0RGToxEbbdu3eTWW281gPNw9uzZ06xiVq9ePSxE9oPLi8K1rVStpitBOkJy5rpdapQvbnI/GCh9+gyuPW0XE0KDJx9pKmtXLpP5yzcI+TX30JIH8tmuHWTR/Dny3sLlJl/i79oWkbl7Ob6S/ZDd3y4PiAeeUMFzkeDAvi+kae3KkilzFlmwcpM0ql7BZ2hpufNl761orkdj5e4WVz7Car6IjLD1i6NnDXltWr/ahBz5Xfkl8lubN6yVR5vVN3khFgfIaxJm0y9voSXJ/gkjh8n4EUOkfKWqMmP+0kQ2DrT9AjLzzIl5ThJPIsNLnefyXB9+rJ3JcULG5QrdbpL1hNHWYgTh8tZ935oxkG986dnu4pnsDwWR+bMrL0J/c899rCz23FfiLsl6y62JvOELLk+J5L/74gVzNil9J1+FXYNJGfjDLVgiw0PDU2Oxixe6t+boZP+oUaPMlotHHnnE5W2kkeXLl8u+fftMaJkhQ4awEBnJ3/atmxu3u0r1mq4l6z3y+e4dhkQhMlbn3nnzNantCudSXZvK5S3NcsX2GWTdjv0mxncPLS//dMkkt9lw+fGGHXLs6Ld+r50UImPw7Tp1Myt7nhOCfFnjGhWFrQVTZs2XajXr+M2R8YDUrVxWDn39lVStUduMZ8mCD8y5JGBpvoiM39hEzIoc5xCij3vjbWnwwIPmvLYtGpvFEiZggUKFzSoXnuyr099zLaY0virZ7558h4DZnGq1QEQWcEK4DvAkMos4sXcl196xA3u/MPkYVvnaPNXZXBLPghATHPGYPl70oclJhoPI/NmVVUJ/c899/FNeHSfDB/STh1o/LkPHTEoETdXSheT4sSOul81O10unoJmzSSEyvElfyX5rEScY3IIlMiIkFk9YWKh8fw3p0vPq1WpHExnbLebOnSt79+51Pay/S548eaRFixaSI8f/lo79Td7khJZso3ih59OyxJXbgjwfbvOk6+2cxkwKiIw80CuDXpC1K5a6+vSHeYghk7sLFTFdcQ8tSYSz3aBTj2fNSg7n+rt2UogML4w3FIlSzwlBmPja2FfkwVZtXMv9/0xif8l+fuct+2y3DmbLCfmhB1o8It37vJCwauiLyLg/q3J4peDV1XXOQ63bJpjlt9+umPzbgjmzjDfBMn2v5wcZUqB5235BqPva2JFSyTVpJ78zJ6xExkrs5AmjZemCefLddyeNB/Nkl2cSbRrFu32+R2ezCJH3rgImBO/eoY1Z4XTffpFUMnCfu5YN/dkVkvc399yvhwd+8Mv98vacj8wijnsbP2Koy/MdmpBKSA6RWdtqSHtYdu3Zb2DCthruFwi3YInsm6++lG7tH3Utqh2VYq6oh20tRBruzdFEFswbNlgiS+m19PzECHibhOHGKBweWbj7rNe3BwElMntwjrm7KJHFnEmjekBKZFFtvsh1Xoksctjrna9GQIlMZ0XUIKCFFaPGVLZ3VInMdsj1hoqAIhBqBGwnMvYb2dn2XPlnD5o2RUARiF0EiqY+FfbBRVR8pGTJkmEfoN5AEVAEIodARHQtb7nlFttGzD4yJTLb4NYbKQIRQUCJLCKw600VAUUglAgokYUSTb2WIqAIRAQBJbKIwK43VQQUgVAiEFVE9u2338qwYcPkiSeekHvv9f4FvCc4ocqR/fbbb67ihDdIWleZHb7/1KYIKAL2ILBz586rtEwpsIqqmtWihsgoz0KxPIgJRaWUEBmDhpT8lXvhfhRztMRglcjsmbR6F0XAE4FZs2ZJq1at5MknnzT6HZRRKl68uCkeEXVENnv2bDl58qRLmOBPqVq1aoqJ7O6775Ybb7zR56zB6/ryyy+VyPS5UgQijACKaUOGDHEJnFz0WborKjyyr776SiZOnGhqkL3++uumOmxKPbKUENmkSZPkxRdflHMudZyWLVvKq6++6qoMaykGXZHnn3/eaHHi1ZUvX14mTJggefPmlUOHDkm+fPmkffv2hpDfe+89o0NQoUIFr39nrBhowYIF0rBhQzOdOPfNN9+UDz/8UJo0aRLhKaa3VwTCj8CDDz4oa9askfPnz/u8meOJjPAO0mjQoIFUqlTJMHMkiQwkb7/9dqlVq5Yp8njs2DHp06ePvPLKKwbkGjVqyOrVq6VOnTrmuPfff9/k1SDj06dPG8KiEbLiWT7++OOmoJ23v69du1Y6depkXGiuQ2FH9uAhYsG1AlVCDf8U0zsoAuFHoGjRoiY6otYdJcyrVasmY8eOldtu+1/1YscT2dtvv21cSkR5aaEkMhTLjxw5cpUlEP6FWLyFlgD53XffmVj9888/N7F6lixZ5OzZs7J+/XpDTvXq1ZMlS5aY686bN0+aN28u06dPl4oVK5rr3uSSsTpx4kRCaGt5ap5//9FVaRVjcU9ygxiLa3Ts2FFeey1xHf7wTye9gyIQGQSefvppYaEvf/78smvXLtm0aZOUK1dOtm7dmiAJ6Wgi++KLL2TKlCmGvKyy1pEmMvdVS6q9QjKIZ1y+fNn0Fak6b+3ZZ5+Vdu3aGSK76667jIdmNYvIPP/O77jVH3zwgSxbtswoSKFhsGXLlqBD68hMPb2rIhA+BCAx5CEpeV+o0D/ao44mMojh008/TaStaGkt4qmwihmoedt+waBTkiOztl+QAyM3RmjIqub48eONMAr5O8Jg94biE+W5k0pkS5cuNUIr5MYgMEJtPEltikC8IkA6hgiHFA5pJscTGQ8tno57I6SCKO65556gxUc8v7VMCZERp9MnKnisWrVKatasKUWKFBG8R4iGxD3/cH8tJXTGwXYPX56XP48Mby9nzn/Egdk3g9SZP2XteJ3cOu7YRYBni2eM54lFMrwwQk12MVjqao72yLyZJpShZXK2X9AnXFvIEVEUVlLY5/Lwww+b7j7wwANmlZHVShL6Bw4cEJL2/MuWLVuSPTKu2atXLxk9erS5/uHDh+XOO++M3VmrI1ME3BBYsWKF0a/lecNB2Lx5s+zevVv69esnQ4cOTTgyboksuRtiWTEhPJwxY4ZL3zK9sMeFlUWr/fLLL9K3b19DchcuXBAWDh577DEhR8bCQlJDS8ttLlu2rDHkJ598ohNdEYgbBFBOY0fAO++8YxbIcuXKZdI3HTp0SIh4HB9ahsJa3nJk6GR6NisMdP872xwgq0g39q2xcsOeM3Jl2hQBRSAxAlHnkSXVgKH61jKp9w3l8QULFjQh5ZkzZ+Tmm28O5aX1WopATCCgROZwM5JbY2WG8JQ9ddoUAUXgagSUyHRWKAKKQNQjoEQW9SbUASgCikBEiExVlHTiKQKKQKgRUBWlUCOq11MEFAFbEYiIR6YqSrbaWG+mCMQ8AkpkMW9iHaAiEPsIKJHFvo11hIpAzCOgRBbzJtYBKgKxj4DjiYyyPXxXxX+txvdWVIEIpjlxZz+g830m/7WzUbG2TZs2QWNnZ9/0XoqALwSoeEHVGSrBWI2Cpnv27En4/44nMj7LGTx4sPlntXTp0sl1110XlOWdSGTU6h8zZowgc2VnUyKzE229V6gQoAgpZbsopGi1zJkzJ+hk8DfHExklOygbTd3+5DQnEhlVXufPn69ElhyD6jlxh8DChQtNyR5/EYzjiezjjz825TuSW/UhkkQGWaGohEAJb5Q33njDhHVz5swRymTT2IqC14nrTGkgqsxSFXfbtm1SokQJ4z5zDQo1Uj+N6pjUZKNaR9OmTY0QCYpKNEqeUGiud+/epl4TjaJ01HKiqix6Aq1btzbHocSEV/vCCy9It27dzLFUueU8+oEbz/GoV2XPnt387quP3v5OKSPSARSftBr35O8qnBJ3XJSiAQ8fPtzMYyIZX83xRPbWW2/JZ599Zh5YaogVK1ZMmjVrlsit9IdSpIjs+++/N7WTCIkbN25sau4T19P/Z555xhSHo4w1ZbIp203JbARNkIArVaqUKYtN49g8efJI9erV5dSpU2bslPNBWYmPyLt06SKIlEBKqDohEUc1TWqa0/D+KPyIW05o+euvv5q3G6W4edM999xzpm8Ur6MoJKSLQk2mTJnMfxFYgVT5GsNXH739HdWnRx55xLyEKChJu++++wRFHOTztCkCwSJAXnfx4sWGA9DuqFu3rpnX7iW2HE9kX3/9tVFRwiuAlHgoKVboXszQiUQG+VoeFQTm3iAfvC73HBlkgGdkycr5GhNkQykfCB488MDWrVtniInrQowQHWWAUXfCq8IbxPAQGWImI0aMSLg8v1FxFk/Jkt0qUKCA+R2vjFwEXhXVbn310dvf8e4gaFICkDHKU5Az46ZIpDZFIFgEiEaYP1aJa54TXvYolFnN8UTmOVg8GQoN8lbHQwvUIuWRETry5qCO/0MPPSRPPfWUlC5d2nTXF5GNGzfOrIf/JsAAACAASURBVNC6N7wtwk1CbOqUQ+qIkeBN0SipTZkfPD8IHuOi5IRiE6SHlwfRcZy3ZD+hKuW4mRyU60YVyr0hsIJLzxggLG999PV3xkJojEdHiIreAhJ72hSBlCDA3CfyoEAqC3+0qCMyQhXEN4ibs2bNGhCPSBEZHcMVhkRQfJk9e7a8++67hiyCJTLCQEJRvCLOKVy4sMlhEUZaRIan9dFHHxkPDdFg8KG+P/p/hHYQFTk4QkNvREZ/wAj3nfzZ/v37r1oRRvwEgksqkeF9IRQDAT/66KOG2PH8tCkCKUGAfBnPBXnfvHnzRieR4WaSf5kwYUIimThfwESSyNz7BGGwHwaNSspWIy7qGVp6ejsrV6405IQXZul6kiMj5LOIjNwXoSuaAAihEFYePHjQEEirVq3MW8sqyOhJZHiNiJ42bNjQLKYgkQfxVq5c2SucSSUyLsI1ye/RLzQLrNxfSiaynhvfCEybNs0Idp87d05Sp07tfCLDIyH5zUNJwhtvgxU13uw84MG0SBEZbw32ikFaeGaEZnhHeFTocY4aNcooK7GCB5F4IwnCaHIBEBG5LFY7ScBDNBaRgQEhJSSG14fKOQ2RE8aOp8bqJg0iw5sjzINQCM+ZFIR75MmoQou4CaEsYsHk+fidvCQhanKIDM+ZVVdEW9xXMIOxnR6jCJBa4dkhuoAHeK46duxoFqncxbAdHVpCAIhwrl+/3rAvyWve7jzI3sRCvJk9UkSGiC9AQz68NYjp8SIhAwi5QYMGxkNp1KiRUYgh3+ct/4SnhTfD7xiQMI8VHCTnrNa1a1dzDVZKuT6NLRjcD9ysPAJERuJ90aJFhrAgL7aEWGLCbMsgbCcUZgLhTTEGCI6WHCJj0YE+E1YTumpTBJKCAFED85itOzwvzFmcAyIIdw5wNJElZcC+jo0UkYWi77FwDXQJCYfJ06VNmzYWhqRjcCACSmQONEosdYk9dGwXwcvTpgiECwElsnAhq9c1G3gJBdasWSMVK1ZURBSBsCGgRBY2aPXCioAiYBcCSmR2Ia33UQQUgbAhEBEis1tFiY+X+cRGmyKgCMQmAnbV9rvm0qVLfwMh306q+EhsTiYdlSIQKQQi4pEpkUXK3HpfRSA2EVAii0276qgUgbhCQIksrsytg1UEYhMBJbLYtKuOShGIKwSiisj4AHrv3r3me0B2iwfTQvmJ0i+//CJ818i3ilSg4HvE5DbX4of5CNaqF8bH3Hz/yHeP1DDjI3FtikC8I0Clm5YtW3qFgbp8fHdMixoiozgfH47yETOVIoNt3oiMQfMRtlUCxNu1KCh45cqVRNs2+ICb6qoUSKRoYUpqa1Euh4oQNFRiqDZB1QnKk1DiR4ksWAvrcbGMALXspkyZYirIWA1nhkKjVIm2yqZHBZHhvSCSQSVUvt1LSvNFZFR2QMzDV6N6BeVt3PefUXVj48aNxiukyGFKGqWgKU+CR4anyZf8VJHFaEpkKUFWz411BHAkKBxKmSvKyUeNR4angofUq1evoMv3WMYMFZFBfHhOVqPQIYURqftFSRGKJlISmpI75cqVMyVw8BwtLb6ZM2eaMjaUxKG+GKEp4SSVVyG1mjVrXlWvi7IllN7RpggoAv8gwHe7VikvyntZzfEeGSElNbNy585tigcitoGAhlXiNpCBQ0VklKN54oknzIfQkBHFDCn2BpHR8NwQ+qB4Im5wUomMMSLzRv0uCA/lIULZYHOBgXDQ3xWBWECAoqqoflGPzz06czSRQQiWPiJlmwkFSbRTq5ta9Vb5Z38G8kdkXAevx7NBUhCUZ2hJ3gpiBTTc20OHDpnjbrrpJlMs0QpV8dySSmT0gQoRmzdv1tAyFp44HUPIEUAkh5QOzyfPrvunjo4mMrwT5MR69uyZkOAnAU9CnJWMKlWqBATLDiIjUe8ediqRBTSLHqAIJBmBJ598UqZOnWoWxdg94N4cTWSW50XHrXLNdB4vDfXs5s2bBwQjVKElN/LlkSmRBTSDHqAIpAiBs2fPmvQSOw1wcNz5gAs7mshQAML7grisXBSCJNSdR16sQoUKAcGJBJFR1hlxWvJ5CIuyIommY+fOnX0m+xkIStzsJeNfMGMLOHg9QBGIEQTYOzpo0CCz/Qq5Q8/maCKjs2xHsBLgrPLNnz/fJP0ZFKragVokiIw+WaucbNpD2h0ZOFY2fa1acg6ScSghIaZbu3Zt6d+/f6Dh6e+KQMwjQDopV65cZgM6eWlvK/mOJzK2XcydO1cQe2XLQtGiRc1qYTCJfiwcyg2xwYaW3BcpNfaFseesYMGCRhINomLvmLftF5yDOC65PzYBsoUDUgtGhDjmZ7IOMK4RYEWfza+oJ6E05q05nshSakFvREbI6tm8ycuxaoo3pU0RUAScjUBcEpmzTaK9UwQUgaQioESWVMT0eEVAEXAcAkpkjjOJdkgRUASSioASWVIR0+MVAUXAcQhEhMjsVlHac+VWxwGvHVIEFIHQIlA09anQXtDL1VRFKewQ6w0UgfhFICIemaooxe+E05ErAuFAQIksHKjqNRUBRcBWBJTIbIVbb6YIKALhQECJLByo6jUVAUXAVgQcTWR8IDps2DCvgCDcQbHFQC2UKkqB7mX37wUKFDBVMocPH273rfV+ioCtCFBCfsyYMXL69GkpVaqUqUlWrFixhD44msj41vHixYuJFFT4En7o0KGmHDRyaoGaElkghPR3RcDZCMyaNUs6duxoRHrQwRg8eLCppEy9QjQvaI4mMm/wLl26VNauXWtk2ZJbxsfZZgu+d+qRBY+VHhm9COCwUA6LCjK077//3tT62759e4LKWVQR2X/+8x+jpITiUJ06dYKyTCQ9sj179hjwN23aZOr5I0yCwIhVaSNnzpxGWAVlGN421FujBplVxjfQ755EhhpTv379ZMaMGabkEWIoEydOlOzZsweFlR6kCDgRga+//lp4FtCipVGPMHPmzNEnB2eBCyFQo2vUqFGSJk2aoDCPJJFRyTZPnjxGvgr1pWbNmhm5uBYtWpi+58iRQ1KlSmU0O1EYX7hwoVFOQrEJsg70uyeRIRp87NgxGTt2rGTKlMn89/PPPzeCKXZ/TRGUcfQgRSCJCOCN9e7dWw4fPmwqKVtOQdR4ZOTLECKh8ioFCoNtkSQyzz5CNMi74X1ZREbJbvcFDRKZjBEdTIjM3+/uREYBR4pOovzE32l4Zby5Vq1alUhoOFjs9DhFwEkIzJkzxxQmZUP98uXLpXjx4gndixoi++KLL8xKBSt0WbJkCRrfSBIZpXnpM/LuVH1l4YJYH8/LIrIOHToYj8xqbdq0MUlMkpkQmb/f3YkMTxWCt5Kf1vWosItwMBNAmyIQzQhcvnzZqJWhpPT++++bKsxIw9GihshGjhwpadOmNSVvk9IiRWSIpLA8jEfUpUsXo8dH/oo8mD8io4w3giXr1q3zSmTuv7sTGSs7rORSLpt7uDfyC54ElxQM9VhFwGkIoKhE6Wty5lFDZOR9Bg4caIggWIVxC/hIEdnKlSulVq1axguz9AXIkRHu+SKy//73v5I/f36pV6+e8eQ8PTLP392J7ODBgyYkhQArV67stHmn/VEEkoUAOTHUxRDmtlImiPjwckZdrVu3btFDZKzssVIBkSW1RYrIdu/ebTbuITSCaAnxPcl3SMadyFiJmTRpkllZZIWR4/GqIGyIzN/vnsl+FJpIgEKCaG3iek+bNk3w1jJmzJhU6PR4RcARCNSoUcNsueD5IMdMdMaCGOkmtmFEhUcGgbGFgZCSZHZSW6SIjH6yAskqJWTEhj7eIosXL5YFCxaYYUBU999/vxw5ckR27dpl4n2Or1ixYlC/exLZ77//Luj/TZ8+3Uhn4aGhAwjBaVMEohUBOICVymXLlgkpGxwDdi4UKVIkYUhRkyNLrhEiSWSB+uwtme9+TqDfA11ff1cE4gUBJbIIWjoQUQX6PYJd11srAo5CQIksguYIRFSBfo9g1/XWioCjEFAic5Q5tDOKgCKQHASUyJKDmp6jCCgCjkIgIkRm93d/fGxepkwZRwGvnVEEFIHQIQCR2dFURckOlPUeikCcIhARj0xVlOJ0tumwFYEwIaBEFiZg9bKKgCJgHwJKZPZhrXdSBBSBMCGgRBYmYPWyioAiYB8Cjicy6mnNmzdPdu7cKaw+8r0ltbUo6RNMc+onSnwzxrdiDRo0kHHjxgUzlIgfoxoBETdB3HeAascVKlQwxRXcVdQcT2RUSqVc8xNPPCGpU6eWd955x5RxturaB7KsElkghIL/XYkseKz0yNAjgIJaiRIlTJFSqrpEFZFBWGg3omNJQ9CDsjevv/66IbZAzalEFqjfTvxdicyJVomfPlF7bN++fQKhUQ0nqoiMDiPWYRULpAYRodirr76aoKriz5SRJLKkqiDddtttMmXKFPnoo49MKV88T8rytG3b1gwxkEqSqjbFz0MdbyNdv369cWiIzuADqi5HFZERSlKvCzbGA8MTQ3moe/fuQdkykkSWVBUkisRRBRYBYogbkZLRo0cLclh33nmnBFJJUtWmoKaEHhRlCFCrn3wyUomkmKhHFnVERlL8lVdekRMnThj48VIocRtsxdNIE1mwKkiMDSLDA0UtikZJX2TvIDRyA0lVSVLVpih7YrW7XhFo166dnD59WhDnpkUdkbFKiVQaYhpNmzY1nhi1uxnUgAED5Prrrw9o+kgTWbAqSBaR4Wk+99xzCeO66aabzFj5GiKQSpKqNgWcDnpAlCEAeeEMkBsj9RKVREbtekKrwYMHJ6hl46HhVuJisgwbqDmNyHypIAUiMiTw/KkkQfqq2hRoNujv0YYAcx45Q3dlMLZk4dQULFjQ6FLQHL39wiIyvDJLZICEd+fOnU0C3Kpt7884TiIyfypIgYisTp06flWSVLUp2h5R7W8wCJAfQ3jEvTVv3twk+olQLC/N0UQGaZHgy5o1qzz44INy7bXXmhU91LSHDBkihF2BWqSJLCkqSJC1r9CSv/tTSTp69KiqNgWaDPp7TCAQdTkyUD9z5ozZ2Y/6NuETSkPoQyLQGUyLNJH5U0ny3JcViMgCqSSpalMwM0KPiXYEopLIUgp6pInMM9mf0vGk5PxAGgCBfk/JvfVcRSCcCDg6tAzFwJXI/odiIKIK9Hso7KHXUATCgYASWThQ/f9rOo0YAvUn0O9hhEovrQikCAElshTBpycrAoqAExBQInOCFbQPioAikCIEIkJkqqKUIpvpyYqAIuCBgKoo6ZRQBBSBqEcgIh6ZqihF/bzRASgCjkJAicxR5tDOKAKKQHIQUCJLDmp6jiKgCDgKASUyR5lDO6MIKALJQSAqiGz37t3ywQcfyPnz5+X222835WwoIx1Mi+TO/mD6l5RjPvnkE6lUqZJs2bLFFJcLpvHhPR+uozr1888/ez3lr7/+MmVS/v3vf5ty2toUAachQGl7tDpOnjxpqsWOGjVKypcvn9BNxxPZgQMHZMKECUIdL8o9r1mzxtQeomos1VMDNW9Exvk83P7ES6h5hMhBmTJlAt3Ctt/Hjx9vqmNs3bpVicw21PVGkUYAjQ7KuFMluVy5cjJjxgxTCYcqONmyZTPdczyRjRw50nhfaFnSqOnVp08fqV+/vlSpUiUgxr6I7O6775Ybb7zR5/l4LwDlJCJ76qmnjDiJEllAs+sBMYQAzz/P4+HDh02J+0GDBhlRHp4FymBHBZEhOkItMvdqsFSNZXD8PVALFZHVqFFD1q5dK4sXL5a6deua27Zv317efPNNWbhwoTRq1Mh4cM8//7ygxYlHh+uLN5k3b15zPCFh7969hVDZPYSbOHGiqXrr7/yaNWvKqlWrEg0XURZCbcSLqc+2YcMGueaaa6RWrVrmvlSVdQ8tcc3RAzh37py0bNnSKFFRLtxbaBloLIFw198VgVAggG7F7Nmzhe+ALUnIN954Q6gqYz03UUFk1K+HxFDkpv39999GfIRB8XAHaqEiMgRBKa/NG4A3AZ4hBR+pkUYFS8JUyG716tVCNVcIBkk3clNfffWVUKI7f/78wlcNVLakoivqSJAcpXzx/PydDzlCVuQIyBHiUlN/jOKSeJeME12DY8eOmWsjPDJ//vwEIgMn+gTJLV++3ByHZ0uI7o3I/PUlWJX3QLbR3xWBpCDAM3fo0CHz/FDDH2lInqmoIDLYePv27SZGpvDgihUrjAf08ssvGyIJ1PwRGcUa8Wo8G8Ub8+XLlyi0vHTpkhEA4R8kQHiHxwW5TZ06VdDdq1q1qtSrV0+WLFliLklBSMryTp8+3ag/NWzYUAYOHGi8IsZRu3ZtI/3Wr1+/gOe3adPGlPbevHnzVaElHhaJ+nTp0hlSwhPDo/rll1+MEhP5QH7/7rvvjGuONmDx4sXNcWfPnr2KyAKNhb5oUwTsRoAEPxENUQfP3OOPP57QBcfnyHggcSVhXxJ8GTJkMKID7oPwB2ioiIx7NGnSxJAouTO8KERRWHzAOxw7dqz06NHDa1fwnMjp3XfffUZkFO+K8Jg4H08P/YFA5w8fPtwnkXHTgwcPyqZNm+TUqVNGwPjixYsmhMR78ly15M0GsUF61EQnvHRftQymL3ZPYr2fIrBx40ZB59aKNEj1WCuXjicyy3yEZjyY5HVeeOEF430E00IVWnIvtoCQl2P18N133zUeDqEe4eKYMWOkZ8+ecu+995otEu4NzwvBXQQTIECrsYz86aefmtXXQOezsOHNI8PjItScM2fOVXAwdhY0PImM/B3kxYuBHBrhujuRBdOXYLDXYxSBcCCwYMECkzqxoiHuETVEhmdGjojQzX3/SCCgQklk9IHQsnDhwoaAWIjAe6GRyCeXxz88I9xfGudAJDRWXontMUKePHmM9LulzRnM+Xh07CXjn7X4gYeIpwhZ4okRFqMFQMjsTmSQJd4XpMuiAflFiBRP1zNHFkxfAuGuvysCoUCANAhOANqWLGDRSDeRJyPh//rrr5u/RQWR4THgiUEKxMhJaaEkMu4LoOxjoW3btk3Kli2b0B0IircFREvynj1wuL/8g/zIk2XOnNkQGLkqVl5ZxLCk7vydj5eH8TAi14e4UJhCVYpwlUUDFhl27dpl+sUihDuR0Un24JQsWVLmzp1rNhfPmjXLXNNbsj9QX5JiAz1WEUguAsxj5iwvXHLMPCs8AwjxkKfmt6ghMpLnrMQRUgaT4HcHLdQbYpctW2a2X+BRsYLi3kius6IKUVy4cMF4R0i4kSMjjCtdunSCBwQ50yA28lsQW6Dz0flk28S3335rSAmDQo6spBL24vl16tTJhN0QvjuRkcdjAQMSTp8+vSFBjqV5I7JAfUnuxNTzFIGkIkDel/wz+WgIDCFq9pJZ2zGihsiSOvBARPbTTz9ddUkrFHT/AbLhoQ9FGzFihCE0azMrRAEpsS/N07MLxf30GopAPCEQFaFlSgzilG8tye/hBZGwx5v68ccfTYKe8JI8gL/PpVIyfj1XEYgHBJTIbLIyK4UQGSHg6dOnzR6u6tWrmwUM63sxm7qit1EEYg4BJbKYM6kOSBGIPwSUyOLP5jpiRSDmEIgIkdmtorTnyq0xZzgdkCKgCCRGoGjqU2GH5BrXt4pmvwEfSqv4SNjx1hsoAnGFQEQ8MiWyuJpjOlhFIOwIKJGFHWK9gSKgCIQbASWycCOs11cEFIGwI6BEFnaI9QaKgCIQbgQcS2RHjx41SimUkKZaqdX4LpBvGfnUhw9KS5UqZT58tipMeALmlJ394TZkSq9P9VgKJg4YMCCll9LzFYGwIEBJd6q2UJgUER735kgi42NsyuNQ7YLvEd2JjMJqFDakCgU1tKjgQLlnz4FZg1QiC25OKZEFh5MeFRkEcFyo7kKlZrjB8URG+Wk6ypftlLiGxCwio6IEVR169epl6tTT+NwHwQ/+UZFCPbLkTTQlsuThpmeFHwHq70FiVGvhE7+uXbs6n8iOHz9uigJSTA3SwpW0iIx69Xhg1CZzr1YBiVEXjDDUSURGuenOnTvLokWLTBkfvEjEPvAk+UdJHarG0jj25ptvNvXMqC+WknMheURbPv74Y6MfQNkTrosYCvenKiz1xlBVsgo7WsLHlElBGYr+UTaJ4pE0zkFbgD4T3qNPgIpN9uzZze8UbuQ3qudSdJKKHugQalMEUorAnj17jFLYk08+aQR08MYc75G5D9qTyKjVTYE1BDzcGw8POTJ0H51EZFS6oGQQxEuNMOrzo1xEcbhARJaSc6kQS1lwiKpo0aKGTCkVTtlrvF1eFhR3BEe8WxoThGMQQ6GII5VnIUPqr1HEEeJDdIXzqYHGf6naAWHxpQaESE01KnaSt0S+S5siEGoEYoLIKCSIt4Zn4N5ee+01k/h/+umnHUNkeCXU7+e/lO1xb1YhQ18eGUSX3HPx5iAyKs8ibkzDI8Rbda971qxZM6O9yW8WkaFHQN00q91zzz1G3Z1ikRAiuUmuTWMMFIWkbDbVcCEyvDc8Pm2KQLgQiAkiiyaP7K233jIeImRBWJkUIqMMdXLPtYiM/6K8RLPk3SxBX/5GVVn0Nsk/WETmuWqJUhXluiEoVoZRXnJvjA0xFbQIIDI0A6ijrk0RCBcCMUFkPHQ8ON5yZHgFPLyeLVKrloSRxPTknFKlSpUkImNRI7nnhpLIIC/wg+BQaqLUNiGxe6MwJASnRBauR1ev645ATBCZt1XLM2fOmFCTfwhwOIXILCUiq7S1Z7/IVxGGkb+iQRjoEZCU57+oJCXn3FARGdqXqDgj+NC+fXuzSrxu3TqzCOOtKZEp4diBQFQRGfkuGslmqqjyj4QyK5Vvv/22Eetw30dGIt2XOG6kPDL6T56LvXAkwClljTo6yX5WWEmgI6rAvjhCNPJQGzZskA8//NB4lik5lzxWckJLvC1WIknU4/XiVZIXI0+GiAoeMQsrd911l3z22Wfmd1aRSfIrkdnxGMfvPcjJ0nBW2H7BP1I21u4FR26I9aYiTnjDahoDotY9SXSn7+yHRAkRV6xYYbZWQL6ok0MYKCExJpaVIQbU1Anl+JoBEkrJucklsmeeecYk/yEsyIs+WWLDhMgoo0+fPt3oDeCh8fKA4GhKZPFLMnaM3Js40JQpU0yul+ZIIgslMJH0yEI5Dr2WIqAI+EZAiUxnhyKgCEQ9AkpkUW9CHYAioAgokekcUAQUgahHQIks6k2oA1AEFIGIEJndKkqsbrJhVpsioAjEJgIQmR1NVZTsQFnvoQjEKQIR8chURSlOZ5sOWxEIEwJKZGECVi+rCCgC9iGgRGYf1nonRUARCBMCSmRhAlYvqwgoAvYh4Fgi86WiZEET6HfruEh+ogS41Bm3a0XF17RxSj/sm9Z6p1hCgEosFFzg20pKwFepUsUUL8idO3fCMB1JZP5UlOh5oN/djRhJIqN22pgxY8yH4ZFsTulHJDHQe0cvApS7mjBhgqm2cttttxktD57rXbt2Obf6hT8VJUwR6HdPc0WSyHiLUNU20kTmlH5E76OkPY8kAnheVI2hegwNrYjixYsbLrBqEDrOI/OnosQgAv3uFCKjJA/lhnCLaWw5oQgkakSoE7377rtGmAShDmqAlSxZ0hyXHAUkVGZQktq0aZMRGKEM0pAhQ8zbKrn9iOTE1XsrAhYCf//9t1CklBp+VnViauQVLFjQ1MRDIYzmOCJzN6GnipKneQP9zvGR8siI5anvtXv3blm6dKkpAodb3Lx5c2MAFI6yZctman5R358y0tQAS44CEvdB05MClBRrRFhk8uTJRikpuf3QR0kRcCoCKH2hD3Hy5MkEHQklsjBaq0uXLqYApBVaIvaBx0WhRfQ6rVaoUCFBsQhCS44CkucQkG6jkCPXoyWnH2GERS+tCCQbAfLj6KUSarprWyqRJRvSwCd6EggqyUiuIfuePn36hAu0bdvWeG7E/smp7krFVlZxEOSl8ixeWP369Y02pTciC6YfgUenRygC9iKAVitaFoSVlIR3rxqrRBZGW9hBZIjqkidAY5L7FS5c2AixkE9QIgujcfXStiLwyy+/SLVq1YScGSI4adOmTXR/JbIwmgPBYJSQPENLRG3JZ1kN8kHE1wotkyIcsnLlSqlVq5bxwjJkyGAuSY4MbQOLyJLTjzDCopdWBJKEwJ9//mkEp4k2Nm/eLFmyZLnqfEcSmT8VJUYQ6Hf3UUYq2U8fBg4caMRE1q5dK6dPnzbSak2bNpV9+/YZlSKS/2zyIzFPsp+EfVJDS0JSVj5RlyLPxkrp2LFjjWybRWTJ6UeSZpoerAiECQE8MDRVV69ebeYzCl80wkp2AliasY4kMn8qSgwi0O9OIbITJ06YNwkK340aNTLSb9b2ixkzZpjtF2y7YLNf6dKlTbeTSmSc8+yzzxoyvOGGG6Rjx46CaO7ixYuNRiYtOf0I07zUyyoCSUIAD6xixYqGuCA198bKv6UL60giS9JIAxwcSY8slOPQaykCioBvBJTIdHYoAopA1COgRBb1JtQBKAKKgBKZzgFFQBGIegSUyKLehDoARUARiAiR2a2itOfKrWppRUARiHEEiqY+FfYRRlRF6aZcd4d9gHoDRUARiCwCd2a+IewdUCILO8R6A0UgvhFQIotv++voFYGYQECJLCbMqINQBOIbASWyAPbn284jh7+Rs2dOy48XzkvRkqUlZ67b43vW6OgVAYch4Egi86WSxPdWVFzdsGGDUMKGbxMp55wpUyavsPKJkmey//SpkzJp9HBZt2qZXHAR0223ZZfaDZtIx269Jf3/V5CwLjb7nbdkzMsD5cL5cwnXHzp6kjz06ONhN2OV0gUle87cMn3OQhnwbA9Z+MFs2X3olFx/ffiTmmEfnN5AEfBAgPn9bNf2Urb8fTJj/tKEX/d+tlsa16iY6Ogb06WXz789k+hvjiMyfypJy5YtE8rg8OE4ZWvmzp0rly9flpdeeilRoTVrXmMrOAAACpBJREFUhJ5EdmDfF/Jo07ouz+qCVL6/ltyZN598tmu77Nm5XXLfkUfeX7xKst7yz3YNgO3Z6Qm55dbbpHqd+pIpc1ZzjwceekRyuAgm3K3rk4/K0oXzEm5TtEQpWbByU7hvq9dXBGxHYOa0N2XAc8+YD8PLV6qaiMg+mve+9Oj4uDzU2vXMuyof8wwWLFxU6jVu5lwiC6SSRJ3+Jk2aSPny5c0gqOwAiQ0fPlyyZs16lQHciYwQsVaFkiZM7D90pLR5qrM5HvBeera7zJo+RarXridvzPjA/K1yqbuNeMiSdZ/KTTdntN24f/7xhyxbvMDV30Nya7bsUr9xU0l7Yzrb+6E3VATCicAbE0bLiMH9JWOmzCby8SSyMS8PklfHDJfPDp+RdG6VlT375CiPzJ9KEuRy+PBhueOOO4yYB406XygIUXOL8jWezZ3IVi9fKu1bN5c8+e6SFZt3J/LgLrtK6lQolk9++fmyrN91QH6/ckVqVSwlTz3dQ344+72sWPKRpEmTRjp06yVt23cxtznz3SlzTvacuWTj7q/M3/Lfms7USzv8w6/m/1ctU1iOH/1WNuz+0nhxv//+mxTMkdF1rbSy99gP5phLrqKID9SqZHJw/M3XMU1rV5bvT3+XcJ77WIO5bum7chhP1LOt3LJHsuXIKeNfGWK80IsXf5Q8efNLj34D5P5adc3h3tz7dp26Sd+BL4dzjuu14wCB18aNkE1rV0ufF4dIszpVriKyp59oJVs2rZNdX/vf8OooInO3WzAqSUuWLDGh5ujRoxOKrLlfw53IXhn0grw5cYxxUYeOmXTVFGlRv7rs3LZFRr/2lnk7tG3RyPUGyCC5ct8uxUuXlWWLFpg3xisTJkuzlo+GjMgIXyEQi9y8kVKvzu1kwdz3EhFgICLzvO6k0S+bvCKe58+Xf5JWjz9lPDwICdd907rVUrLMPXJ34SKyfPFCOX/uB5k0bZbUadAkgcgIsxs/+LC5ddl7K0qV6rXi4FHTIdqBwLEjh6Va2SJXEVndymXk8NcH5fob0kjq1Knl3vuqyAtDRiSkgKy+RS2RnT17VgYMGGBCzRo1anjF2p3I+j3TWebMnC6dezwnPfq+eNXxnR9/2DzALw4b5Ur63ySQR6bMWWTTZwddslPXy5aN66R103pyV8FC8vGGHSEhsjUrPpZObVvKX65yvr6IbN2q5dLhsRaJjvHsvCf5ebuudU6lkgXk1Injsvnzb0zI+sn6NfJY8wZmXEvWbRM+IduzY5s0q1vVReJ3yLqd+xOIrHipMjJ/+QY75rXeI84Q8EVkA/v2cEU1R+SOPPlk3+d7ZMenm4V5OG/Z+kRRVVQSGQl+FLTRhqRKpLuiii+PjDiceDwYj4yH+ZkObc2CwLT3/6m0apFFKpewx4ETF+SH78+kKLT8xEUktSqUkDquFdN3p072SmQcU+e+UlKjbgMhIeoekvryyHxd1xeR4dqPHjrAeGgDXxmXcNm7c9wsf/z+u+z46rghPlaOlMjijF1sHK4vIvPsAmmYz3fvlOWbdkm+Av/7/DDqiOx318M1cuRIk5Dv06dPgkinN8zdPTK8lKdaNZO8+QvI8k92JSI/Qq0KxfKbkGu9ywP53pWvItS8r2p1eXvuokREBml+deqinPvhbLKJjOXjGq6VUFZLP1yxUUrmy3YVkbkfgxdUKn/2gETm77q+iOz18SNl1JCXpPUT7WXA8LFXEdnOgyfk5PFjSmQ2PtTxeKtgiezZbh1k3nvvmpVNFgaiMrQkkY6GIwSF7Fm6dP5X8TxXLWuWLyFHvz1kHlgeXBqEOPj5XvLOlNelWs06MmXWfFdt/StSpkBuV0x+nWz+4pDZu2WFloWKFpdFa7akKLTEq/vbtSI6e9FKKVysRKIFAHfPz9cxvkJLf9f1RWSbN6yVR5vVlwIFC8uS9dsMwX+2a4ewuKChZTxSSmTG7IvIvjqwT+66u5CZl6RgWIQ7ceyIeS6zZL3FuUTmSyWJHk+dOtUoDiFxhpo2jQEieGutZPoKLfn7/i8+c+W56pqVwqo1apu4Gzd11/at5qFlH9ktt2UzlyDcIuwqVKRYomT/dJeHVsnlqVmrlmyiJWFOG+da+WPLhpWDmzZ5olx0Cejye636jQQSZNWSZq36eea3rP/PMU927i7PDRjmdSXTfZzu5/i6ri8i4+9tWzSWjWtXSqmy90qBQoXNKi0e56vT35Pa9Rtrjiwyz3Zc3PUnl2D1wnmz5cfz52XCyKGuvZ35pXW7DlK0eCmXQM8laftgQ/PclC53r2sxbqt5hjt17yM9nx+QCB/HhZa+VJLIhw0bNsyrokqrVq2MgKdn87az/+SJYzJx1Muycc1Ks7P/Vhdx1arXSDo986xrv9g/5EiDUCeMHCYfvPeOWcHL69q2wRJx5ftrmt8tIgt2tvV+YZC07dDFEBle2Nyla8wigi8iK+b6FApiTZ3630ETmb/r+iMyPFBIeMGcWS4l9Itmo3Cv5wcZD5Vmbb/QHFmw1tbjgkXg8DcHhUjJs3V2PY9dej1n8tofvj9LvvvupGTLntM4AA+3aXdVXtxxRBYsAMEc543IgjkvlMcsWfCBdHvqMYHI2IemTRFQBEKPgBJZ6DFNdEUlsjADrJdXBFwIKJGFeRpYRDZy0pvyQItWYb6bXl4RiE8ElMji0+46akUgphBQIospc+pgFIH4RMB2IrNbRUnFR+JzYuuo4wuB80f2hX3AERUfKVmyZNgHqDeILgTs0kGMLlSit7d22VOJLHrnSEz23K6JH5PgOXBQdtlTicyBxo/nLtk18eMZYzvHbpc9lcjstKreKyACdk38gB3RA0KCgF32VCILibn0IqFCwK6JH6r+6nX8I2CXPZNMZL5UlBjO+vXrZcWKFa5vAi9J7ty5jYqStzLXHMsnSprs18fAEwG7Jr4ibw8CdtkzSUTmT0Vp69atMnPmTGnbtq0pqrh48WJBsATxkVSpUl2FmhKZPRMp2u5i18SPNlyitb922TNoIgukojR06FApVqyY1K9f32D+k0s0pHv37tK/f38jSuLZlMiidWqGt992TfzwjkKvbiFglz2DJjJ/Kkp0+syZM5IxY0YjQkD7+eefpWvXrqZ2f65cuZTIdG4HhYBdEz+ozuhBKUbALnsGTWTuIwqkooQ3NmfOHJMH69u3r0+BXs2RpXiexNwF7Jr4MQecQwdklz1DTmTbt2+XyZMnm8qwPXr08OqNgbmGlg6deRHull0TP8LDjJvb22XPkBPZFZeALmHmxo0bZdu2bTJo0CDJnDmzhpZxM3VTNlC7Jn7KeqlnB4uAXfYMOZF5hqD333+/1K5dW4ksWMvH+XF2Tfw4h9m24dtlz5AQGTkxtCy7desmt956qwGJuvo9e/Y0q5jVq1dXIrNt6kT3jeya+NGNUvT03i57JonIfKkooZY0atQos+XikUcecWk8ppHly5fLvn37TGiZwaVm5Nk0RxY9k9HOnto18e0cUzzfyy57JonIfKkoVapUyWy3mDt3ruzdu9elLPS75MmTR1q0aCE5cuTwakclsnie3r7HbtfEV/TtQcAueyaJyEI5dCWyUKIZO9eya+LHDmLOHold9vw/LaSjlvpWEGQAAAAASUVORK5CYII=)
LibreOffice Calc до сегодняшнего дня такое не поддерживал и соответсвенно криво открывал сводные таблицы MS Excel, где такой функционал использовался. И при пересохранении в XLSX формат также сводная портилась и уже MS Excel документ показывал криво.
Вот так таблица, показанная выше, выглядит в LibreOffice 7.5 (обратите внимание, что группировка теперь выглядит, как два отдельных столбца, и кнопки в ячейках пропали):
Dennis Francis из компании Collabora написал патч, который указанный выше функционал добавляет в LibreOffice 7.6. Теперь при открытии в LibreOffice файла XLSX, в котором есть сводная таблица с компактным структурированным видом, такая сводная отображается корректно:
Как и всегда, когда добавляется что-то сложное в проект, добавленный функционал не лишен недостатков (которые я очень надеюсь, будут исправлены):
- При сохранении такого файла XLSX в формат ODS пропадают значки для сворачивания/раскрытия структуры. Я сначала думал, что пропадают совсем, потом оказалось, что если сразу после открытия файла ODS обновить сводную таблицу, то значки появятся и сводная будет работать корректно. При этом пересохранение в XLSX формат работает нормально.
- Невозможно создать такой вид сводной таблицы с нуля в LibreOffice. В MS Excel такой вид создается автоматически, если вы более одного поля добавляете в область строк в настройках макета сводной таблицы. В LibreOffice я не нашел, как такое сделать даже вручную.
- В контекстном меню отсутствуют пункты Свернуть/Развернуть и Свернуть все/Развернуть все для такой структуры сводной. Но это не ошибка никакая конечно, это надо добавить просто.
- Ещё я видел, что кнопки Свернуть/Развернуть в LibreOffice иногда перекрывают текст в ячейке сводной, но тут надо найти подходящий файл, возможно дело в кириллице.