[数据处理]
自由表中如何计算某个项目的当年实收保费占整个实收保.....
yhdata_ruby
显示全部楼层
发表于 2022-10-12 17:24:46
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABM8AAAFOCAYAAACRwzoUAAAgAElEQVR4nO3df3DcZX4n+Lda5jeMM4lRAhOMY+yJJw4hNZPUZLyuw8paTK4mOZLMYdexu5Z1ayXHFr6524EyExdmbZcTKJjdI1CZy0l7ttga9mw2deGSqctgKvZUKLJOdnKZEN0owRDhyeAbWRni4feApfuju6XuVn+llixZtnm9qiis1re/36cb98P3effneZ62Lz73wvh4GrQlaXjwmssuyT/7qZtySXup8WgAAAAAuCD9H3/1Uk699W79g+Mp52NJlrS1tWV8anw2RXuplDNj47nyklLa2ua/oQAAAABwrl1xyZIk7xb+vtReai0Ju6y9lMsvaRecAQAAAHDRuGHp1dPOtCz94BWXpW2GROyqS5fk5264NktaDNoAAAAA4ELwsx9ZlqWXX1r4+9LHP/JDufrSJYUB2iVL2nPThz+U5UuvSknZGQAAAAAXkfZSW/6rG384V196SdPft70/Njb+wndey+B3/jHffeudnEkylvEsaWvLZUva85EPXZmNK6/P5Uvaz23LAQAAAOAcGE/y0nffyNe/fSojb76T98fGMjY+nkvb29M2Pj4+fmZsPGfGx3PqzXdy7Nun8t23381P/fCHc3PHh7OkVLLDJgAAAAAXtbHx8bw/Np5/eOvd/Nm3TuXE997MLT/y4SxJyuVp7WnL9R+6Mj/03cvy/ffP5Kd++AdVmwEAAAAUGB8fn9XjMylaUmumtepboa0zP15qa8ul7W35kauvyA9fc0VG3non65Z3lMOziSdVDmxra7O+GQAAAEAT1RCn8d+Nv5+Ntra2Kc9rDHfmEkxp6+zb2tZWzsiSZEmpVB+eAQAAANBcbahT/+f63zf+uRW1AU71z21t4xPhT7Pfa+u5aavwDAAAAGAGjQHP2Nj4xJ/HM14Y9szGZLhT/nNbyrMD29raUipNHtMY+mjrwrZVeAYAAAAwjWpoMzY2VhfwjI2PZWxsfOLx+Q55SqVSSqW2lNpKGR9vS6nUNvF4UdCjrfPfVuEZAAAAwAxqK6PGxsdy5sxYxsYq/x6fDHlqpx7OVrUaaiLkaSulvb2UUmk87e2lZKyUUiktVXNp6/y1VXgGAAAAUGAy3BmrC3jef//9lEqlXH3VlWlvL83LLpON1x0bG8tbb7+TM2fOlB9sTzJWSlvbZIhUe11tnb+21hKeAQAAAEyjtvqpGvBcfvlluezSSxfsmm1tbWlvb881V1+VN996eyLoaWtvy9jYeEql5gvca+v8t7W0YK0BAAAAuIA17v5YXotrLKVSaUEDnkZXXXlF2traylValamMzdqnrfPf1kR4BgAAADCt2nW5zpwZy5VXXH7O23DlFZdXFtEfnxLu1NLW2WmlraZtAgAAAExjfDwZz/hEhVKpVFSL9M08/vu/ld9sePQ3fuKJ3P3RhgdH/zg9zx3IV+se7Mwf/HJPPtHkzKVSqVKh1Zbx9lIK8qhZtPXNfP1r9+WXXjtd8PvpffzDX8h/uvVjaRZ3zX9bp/HW8Tzxtd/Kfe8mn+74Qr60blXTNhVppa0LFp6Nfv3J/Nv/7ffy/NdfyRtJrr7xE1n32V/Lv77zE1m2UBcFAAAAmEeNU/lm2j0ySXLJzdm9dDL9WHVNs2Ouyy8s68y6JIOnj+TQe9Ofsjq9cLxUqmtT4yL8rbf1qnxi/a78zjP35V+9+14+dWVnfuHK6duQM6P5o9deyPHLtuZL65sHZwvT1mJ//ReP5L53y2/eV0ceyX/4u/81vT/W+vOL2lprAcKz0Rz9N7+ee/7wleTqG3Prr3ZnxWUn8/VnjuaZf/vrOfqH3fnd/dtz82Xzf2UAAACA+Ta5sH0Kq6jqXP2L6V3/semPWfqxbF7/sXzrz3fn8RmCs8l21P4znmS6RfhbaGv7tfnln/1n+epzB/L8mRvzC5/6+dzQXnRwuVLtgdyU//1npztugdq6gGZq6wKseXYyX//Df8itX/hyjhz9vXzxN7Zn++d/Mwe++n/lt3/1xnz/bwfyb/7j38z/ZQEAAAAWWNH6XXPxrT/fnV/89ku54cP35MtL5//aLR2/7Ofz736iMze8eyB3PffNvFNw2DsvHMh//1ryGz9xT36hhSmFC9LWJn7y4/fkwcsuSXJJPt1xT/7FLKrOWr32AoRn1+S23/2DfPGzP576qsRlWbf913Jrklee+esMz/+FAQAAAOZNbahSO71wPtQFZ+t/Kh9qIaFp1oZmUw1n29bLP9qTB5ctzV+89jvp/9s3px7wnT/O//zSsdyw7HO5+6NXtXTOhWrrFFeuypb/+t/n1V/+99k/y/XOWmlrsiDh2Yrc/Ilmk3mTXHN9rk+Svx3O6/N/YQAAAIB5NbtgZ2nWLuvM7qUzlJGd/OPsqgnOlrYnHUs7s3vZx9JxFu06mxDqJz+1K79z2Vv5zf/3QJ5/q+YXZ07l9//iQJ6/bGu+9KlVczr3fLd1ive+n9Onvz8vp2rWrsXZbfO6H8qli3JhAAAAgIVyfTrX96RzpsOu+/ns/6cfz+krfyBLK2uH3fDTPeld6OZNp/3a/PKtvfnTZ34nd/35z+cbt1bWbHvpD/Ov3v14vnzbzOucLYrv/HH+pz89kENJfvTKrfm9fzr/7VyAyrNp/M3XczTJpZ+6OSvO6YUBAAAAziPXTAZn540rl+aGJKem/GJpPjTTTpyL5K+HvpxDlT///VtfztMLsE7YOQzPXs0fPP54TubG/NpnPxGbbQIAAABwNpZeXrt7wbJcuwAh3zkKz17N0X+zPbv/9NJ86oHHsvXHz81VAQAAABbdmcVuwMXrhp/5Qv5g2Zp86pI12f0TX8jm6+b/Ggu/5tno1/PYPdsz8NeX5tYvPJnf/KXrF/ySAAAAAOfeP+b44ImMLF2edT/6A0nKu2p+duS6/C/rfy3rptlH4Ft/uT9/9MbH8gvrfy43nKPWXhTafyCfWP8b+b0FvMSCVp69/sKBbP1vfj0DwzfnX+//g3zxsytM1wQAAAAuGG1tbWlra2vx6JP5oxcfyX/70skk5eDsF7/9Ujqu/rmsvXr6Z46cPpIHRr+ZkbNo1+zaeu5c6G1doPDs3Qz/3ufzSz2PZ/hTX8h/+urv5s6br1mYSwEAAAAsgNoQpRqqtBb4vDcRnN3w4Xvy5fU/NS+bAzRrQ/XPc29rE6f/zzzxwis5/d4F0Na3jueJ//tf5vrf/5fpef543pnntiYLFJ69+gf35M7f+tOsuPvL+eoXP5sVys0AAACAi0BLIc9rj857cDZ57fFZHj8by3P7Tbfl9ryU+166Px/7yv+Qu14amuU5aq+9kG0t++u/eCT3vftekvfy1ZFH8h/+bvbnmKmt87/m2etfzRd3/2nyq7+d393646ZpAgAAABe0clVSJv6Z2Xs5leW5PV/PoT/9enL1p9P70w1rwJ/8z+l76ZsTPx5/o5V21LaleUNm39ZaV+WGm/95vnTzP8/ul76ax4cOpf/dk0nWzPZE56Ct82emts57eDZ69A/ztST/3afXCc4AAACAC1q1Kqk6ra9UKmV8fLyFSqkT6X/tRPmPZ34uvWkIz17/Zh4YPdJyO8bHx1MqlVIqlZpOfzy7tk7VcdOns+emT+fzf/+fc+iF47PKeM5lW3/y4/fkwa/9Vu57N/l0xz35Fz82q6e31tbx8fG6urQ/eeU7efX1t/IrH7sxl7bPflbnC1/8mfT8x+TqGz+a66d7Z3/xC3nyzptnfX4AAACAc2F8fDzj4+MZGxvLmTNjef/Mmbz33vu55uor094+T3MxW3TmzJm88ebbWbKkPUva29PePhn4tLW1aes8t/XP/n40L4z8Y3p/5qMLMG2z4o1X/jZ/O90BJxfqygAAAADzZ7I6qi3t7aW89fY7uebqq85pG9548+2USuU2TLfAvrbOf1vnPTy7+fP/Jf/l8/N9VgAAAIBzqxqkVKcTltpKKZXGc+bMmbz51tu56sorzkk73nzr7bS1pTy9sK1+emHjVENtnd+2JguxYQAAAADARaRcHZWMj5crpJLydL/X33gzV15xed16WfOlOq3xjTfLAU97ZUphtVJrumoubZ3ftgrPAAAAAArUhimlUlsyVkoqy3KNjY3l9Tfeytj4WGUdr8l10uZ6requj9VqqPKUwlJ5La7Kz5PHNVuEX1vnu63CMwAAAIAZTK7PlWSslLb2toxVApixscmQJ8lZhTzlf2ei6qpUapuYUlgNfGaqxtLW+W2r8AwAAABgGtUdIkulUmWdrvGMjY2nbbwtpbbxjLeX5j3kaWtrS1vaasKl+qqo6aZCauv8tlV4BgAAADCDatBTDVdKpSRpKwx3Zhv01IY2jWFP9bGZwihtXZi2Cs8AAAAAWtAYxFRDn8lAZ/L3ZxPyND7WahClrQvTVuEZAAAAwCxMt/h9krpKqrM570yPz+Wc2jrz442EZwAAAABzsBAB0kLR1rkrLcpVAQAAAOACIDwDAAAAgALCMwAAAAAoIDwDAAAAgAIzbhhw8uTJc9EOAAAAAFhU11133ZTHWtpts9kTAc53J0+e1H8BFyT9F3Ah04cBF6qiAjLTNgEAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAosWewGAAAAcHF4+73386033813R15b7KY0NT4+niRpa2vz8wX8MyyUf/ze27nuuqmPtxSenTx5cr7bA3BO6L+AC5X+C7gQvfnemZx6+71847v6MODCtL7JYy2FZ0uXLp3npgAsvNOnT+u/gAuS/gu4UI2/815eH30j33tvLEm1SqhtMZsEcNZM2wQAAGBetLUl7aXy0tqXL1mSm37gyiy97JJFbhXAzJ7/9ncLfyc8AwAAYF4sKbXlslK50uySUltuXHpVfuSqyxe5VQAzE54BAACw4NrSliWV8KytrS2XtLXlsvbSIrcK4OzoxQAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAAACggPAMAAAAAAoIzwAAADgPDWWgZ2+OjLZy6EC27j2SZoeOHtmbrQND89044ANEeAYwo9Ec2duT2d5zjR7ZW38TNzSQrT0Daek0o0eyt9VjW2lHTeOHBnoW4Qay/B5ubfUGuNkZmt74zuKmGj6Qqp+9WfQns+mrWmnBXAatjW0YPZK9rX7WL7r+EwBYbEsWuwEA579luXn9ygw8tDfLH74/ncvmdpahY0eTDTuypoVjR194Li9tuCNrMpoje+/NwMvTHLxySx65vzPLkvKg8d4n8tKUgx7K1qPFP3fu2J/uNeWB4YNHG5/bog07cqC72aurvIZsyX1bnsuD9w7kuv3dBe/DUAZ6HsqRhkc7d+xPd+cd6ex5KHuXP5z7O5dVzvtQjmzYkQNz/G8CF7uhgXsz8PLK3LTyaB4c+GTBZ7TWaI48dTQ3bXm4pb6qFctuXp+bnqj97M7e6AvP5aWV63NXC09frP4TALh4Cc8AqgoHTpMG7u3JwJRHV6a7EqoNDfTkwTQLkYZy7GjSuaOl6CwvPPdyOu9Yk1Tq1goHZ0MD2fpUzc/LOnP//s6Gl7U395y4Y6JN9W0sDy5PVI5d070/B7qLmlV+f5bPaqBYCcMmgrXOPJK9uadnIPc1DdDWpHv//nRnKAM9TzWElWvSvWND9h4bzWiWZdnoC3nu5Q25736jVmimHIZvqHzWyp/FGQOs0Rfy3MvJSy/fm61PtHKVav/XQlD1RPNz3rSl3KbRI3tzz3PrJ8OsyUblhedezk3r78rM2dni9Z/AQnm54P6r7GwC7NEje/Ol3DXnYB/44BCeAdTZUBDqFCmHPDMZPfJUuZrqoZ4pVVVJ6qsfhr6SgWzJI2dxI3jPE40j2BkqJ2Y+a4586bmsf3h/y5V31XZ07tifAxnI1p5j5fe28/4cuG4gW3t6Wr/hHRrI1oeqDT6ae2ra/mDP0cz+vxtczKpBVu3nYk269+/IQM+92ZviAG3oK+WAvDGTHhroyVMtVI7NdhA7NNCTGXvQoa+UQ7nCQK/mdZ6X/Sdwdia/pJxP5S8YVqZzx/yeF7g4Cc8AmhkayNanltdXQIweyd57T+SOWYc0Q/nKEy9PndbY9HzlKVPJljk3ffTEy3UD2MZBb3F13DSvYKBcUXLTC6PpnOnutVrBt3JLHtl/f+X9686BHeWFfB+5vzPL1nTnwP5PZqCnJ1trb4obq//u7clAVqZ7y/L6gHHK9dR+QFml2nPlljyyv/Hzsibd+x/Okb33ZutzTT5PQwN58MSWPFJUfTqrNjRWjlaqtO6YbYVIpU+c8vkvuMZ52H8C59DLT+SenvqU/aYtD+euukcml5OY2k8CNCc8A6ha1pn791f+vKY7B+5oqI4aPdFkSueadO+/f9rTTlSdnTiZ0aypCeNO5KWVyxsGr5UKi5X15zhSVLGWJCtrB4qjOXkiOXK08fjGio3GSoriyq3RI3tz7JM70nn0oRmnJ01OE9s/9VxrunOg7q2qTNEcPZK99/ZkYMOOHOiuTJsaGsjWh05MhmpDA4XTNYCy6pqFnTv250BhtrMsnffvz81H9uaenidqgqKhDDx0It0Pd89xIFk+b9madO+/oxyOb5ic4niiyZTONd37M20PWu0TcyKjSU3/eTInsjyfXNbk2POo/wTOsYIv2kaPTP5h771PJFsezgFTNYFZEJ4BFKmpjhrYsT/dSdIYds3oRI49l3Q/vCMn7n0qL4x2TlRJjJ48kSz/ZH0lxUMn0rlhZY40pFR1A9zaaovGNXsqA9jqNKJmVRJTHpuucmtooLwWyJrRifCqPK1pedPB4uSaac0X/m9Ufl1T1xkaOnY0ycpkdDSjy5b5VhhmcGRvTwaW78iBHceydbqwaMLKSr9UCbg+eSwnttyV7hzJ3p6itR+bTJssqgithOOfHOjJ1oEdlX5hZZbP8sN87NjRdO54OMufujfHhrqzptrpTPny4TzsP4FZmmbtxGZrnhX2PwWOPpStJ7bkkf373VcAsyY8A2hQP02nPAAs/2IuZ1uez9zfnWUZzZGVL+e5iWmP1QWwa27fRk8mW+7KZ/KlmsFfbTVHE1Oquepfx4MntuSRhsWL1nTvz4HyAZPriDXbBXRoIFuPfTIHusvtnWhRzZplMw2cm8/+mpwu8ZmmpRrlzRWSlzPw0L3lgW/zlwhUTIY+a3Jgf+0nZobpkhOf0zXldc5Gk2aVVK2uedY45X2iv5lbB5pPdperWIeWJwPHhtJdSc+Gjh1Nlu+oq0Q7r/pPYM5aWTuxvMHILE9cuCs4wMyEZwB1RrPsM/tzx1d6srWnfgA5evJEkuVzPO+ydN6xIQNPvZDRzs7KTpErs/6umoHoss50d06dWtC0AqTJN7CT00trnzd17Y96zacbzbiuz5ruHNjfXb557XliFjek5YH8c+unmS4xdCxHVq7MTS8n67csz8BDA/nkjjRdx6T2dQCLb3TZZ3Lgjq9M3RBk9GTOpgdd85ktueneYxnqXpM1zXYvPo/6T+ACUlkm4sAMS3AACM8A6izLsmXJsu79OfCZI9nbMzCxoP/oiZeT5Xe0VOo/sWPbyvWTD675TLpzb7505Lqsf+6JvLRhR+6f7mTLGqYzDg1k67Gk8+iJnFiZrL+rceepmoXCd2zIPY0bHkxtZJPpRpVztBiGLeu8Pwc6y4HY1r2TVWjNd6yrUbNr3k1baqtZygt+37R+S5a//Fxy82fSveWFLDt5olzldlfypcomC6lWwtz8gmlTkGTaKU/NpnIuQBXGsnIHmgP7P1OeSnpH7ZqRy3NHKx3oRFVXTSi+rDN3bOjJgwOfzH2p9HPTNX1R+k/gwjTXWB/4IBGeAVQUBT4P9tSuDN24UHRZXQB09KHcs2FHHtnyVMOUgmXpvGtLnrv3oQxkQ+67v/VB6+iRvbnnxB050J0MHD2R9XfdlXxpb47UDQBrpkoOTV1ef+ZpV+XB44lZL6Jbv07QhBYG5kMDPalbcmjoKxl4eUPuu/+6HHuicu7O8pkPdCYZGphY52hiImntRg/wgdbss9jaLpfVzQaq6vu9qiZrniU1wXaTSq+G0K7peSvTv5OUK0yfqgRYD9UftqZ7Rzp7HsqDWZnuh1tf5+jc9J/AeadSSbp8x/58puiQkyfqv+gEKCA8A6goV1E1+021mmOmKTrVqUTlQerolDKPoQxMDC6P5qkjn2lhINZYCVZdN2hZOu+/K0f29mTr8laqR8q7yC3/5HTXq1nfbbEsW57OLTdnTUZzrMmva9c5Gq37xUAG0j3jGilAc5ObfTTXSnjUuPFHVfWLienXMRrNkedenvwiYkqANZoje6ubkLycga8MpXPGD/y57D+B80LtEg8rJzcHGD3Z/PDqrAKAmQjPAKYzsf7NhnRvOZEHe3qSNE41rCoOnyaq2iYGcZWpjk8UL4xbfk7S/fD+HGg6ZqtUmQwNZGvPU+l+uKaKonEh7KGvlKdyVapAJne5nM2bcQ5U1i1qiMbKhgby4NGV6X64+UD3yFNH0n1/88E7sBgmp5F2btmSEw/1ZGtSsNFIQQVrMjmNc+WWPLK//LyhgZ5s7Snqiz+g/SdcJI60tGNwplSMlXfqbv5F57Kb1+emJ5rNHii+rwCoJTwDaKJ2Cmfnjv2pzrAszyAcykBPZfrSjFMTT+Qre3tyJFvyyP77awaL1YHiUAZ6erK1yc1ecSVcgzXdOdB0EFepukhSvpncXzn/aLni4uXq4wu04PXR5lNcG920ZeZjqlPKOnfsT7PCl9FyWcjs2wgXi+kWyE+ar3mWpDxwbFz/ax7bsmFHDtR3oBka6KlUhszc/xwb6MmDR2v7r7JypVz1S4ipr+GC7z/hA2yuu21OW0HbuA4iwCy1jY+Pj9c+8CevfCevvv5WfuVjN+bS9lJOnjyZpUuXLlb7AObs9OnTs+q/atf8KapmaNTadKRzqGEAPWO7qsfPGAJOrofW8vty4o7W1jxrOhVsKAM9T2X5w/fn5hf25p4nlk8dpE4sKl523vw3gHkw2/5roc04bbP289i0sqyJlvufc2TB+k/4YHnrvTP5s299J988/U4+dNkl6bxhWa6/5orFbhbAjL70/5SLJz7/T34ySXLsW6fyV995Lb0/81HhGXDxOt8GnwCt0n8BFyrhGXChmi48Ky1mwwAAAADgfCY8AwAAAIACwjMAAAAAKCA8AwAAAIACwjMAAAAAKCA8AwAAAIACwjMAAAAAKCA8AwAAAIACSxa7AQAAAFwc3h8byztnxpMkZ8bG873vv59L33p3kVsFcHaEZwAAAMyLM+PjeefMWJLk+2fG8jfffSOvLDHhCbiwtRSenT59eqHbAbAg9F/AhUr/BVyI3nzvTC5rb0uSvDc2llffeHuRWwRw9loKz6677rqFbgfAvDt58qT+C7gg6b+AC9WHvv9eTrxxIj/24WsWuykAs/buu82nmZu2CQAAwLy4pL091115aW5etmyxmwIwa6Ojo00fF54BAAAwLy5tL+UHL1uSH776isVuCsCsjb3ePCazciMAAAAAFBCeAQAAAEAB4RkAAAAAFBCeAQAAAEAB4RkAAAAAFBCeAQAAAEAB4RkAAAAAFBCeAQAAAEAB4RkAAAAAFBCeAQAAAEAB4RkAAAAAFDivwrPBvs3ZeXhkNs9I3+bN6Ruc+puRwzuzaefhzOZsZ92ewb5s2tyXqc0ZyTM7Z/vagPPd9P3MYPo278wzi/yxHzm8s6DvGckzO1to32BfNm3enE0Ffe1s2nGxv1cjh3dW3qvFfy0AcKEZ7NucTbO+2SiPszZtnstz59Mcx3sjh7NzHu6zgIW3ZLEbMHJ4Zx7N57Kvq6PxF9m5fTh3HuzN2qInDz6fw9mYByYOGEzf5j3JroPpvWVDVvcfzV+OdOW2jqITzG97Bp9/Ntm4a/L3g33ZtCd54GBvfnrDqvQf/UZGuroyi+YA563BPN2fbHus+pku9z/D2x6b2n8k5T7k0eRz+2r7gJE8s3N7+o+3cLmNu3Kot7A3LNTRdWdWbN6evusPpvbpg33b079iVw5NaWpjmzbmgYMHi/vhllys71X5dRyu/rhqWx4/uE8fDwum3A98bUNB33G+Gjmcndv7s2JXfd8CnL2J/0fva+XD1XD/MdiXTXuerfn9xjxQHeu1+LkdObwzdw/fmUO9186l9emrXKOl5he2aTB9m5/MjY/tmxz3DvZl057hbKt9DDgrCxueDfZl05Mr8vi+ZoFRddCxKl3bTmVkyhG35NaN/dm9+dnCgVBjWDVy+MmaMK0rd27sz+6nB3NbS3cqZ9uewTz/bNK1a6I1eebJmvZ13Zmu/j15erDLjROcr6bcRDVaNXETUu5vjifbN6c/STVkWte3OZv6duVQb92J07e9P9m4LadGko6G7qWrpRuzub6otendtTGbnjyc26t98WBfdj+7MQ8cbHbRjty272Buqxy3aU/Dr6d5j1YXhGEX73u1Nr0HD6a3et2jTdpSkPbN9Drg/DVTkF0z+DxnTZrFgLKZ6QbQF7DBvs15ckVNvyzE46Izkm8PJ6s3XFv3WFHIPti3J4c37sqhro7ycc+vyOMHD2Yyb9qc3TsrY9eOruzbNZxNe/qyrrA/qH45uDaZy3ynkVcznJ5w1qcAABUPSURBVFW5tS53qykGqbvoSJ55tD/Z9tjk45XP9ItJklXZVnv42t48vm1n7n70cH666VgcmK1FqTybGFA0hFCnag/q6MhtvQdz2+2Hs3P7nmx6tnGwMZjnn11V6azKPz/dfzyrt31uonNbe/u2rN6+J33rWhhsnW17Bp/P4VXb8vjEz0+n//iqbPvcRGty+7ZVuXvaDhhYVGt78/i24dzdv2L6gdPI4TzavyIPHNw39ZjegzmUJDUTuAf7yjdBRd8qHt6zebJ6qcjGmZtf38Spwc3dm/vrft69uTpYXDW7byZXbZvypchg3+Y82bwhH+z3asqXLeWb+ldm10Q4j9QE7KkMNjOHas+a6vyzuyea5YCy2fOnG0CfVdsqOrqy72DXfJypBfXh5uraF99SGAAXq8axY0du663/XJbHjjUzl9benm2rtufJw7c3r3YdfD6HV23I4+cimRr5Rr52fGPu3Fe92GTfd+iWb2Tn9qNTntKheAPm1bkPz0YOp/w5Pzhl8LG292D2VX+ofAu4ettj2XfwYPlG5vnB9K5dWznNkzm88c6JaTQjh58sh1e1HdvETcLO4m8d56U95SqzrjurN17ln1dve6zunB1d+/LA8DzfkAHzqqPrc9l2dPu0n9PBp8vf3E+pP+3bnN2NRVnbN5f//ezmcmVskwHLglVTNQm5pipXZtRcrGbQWTYRHK3alsfvnF0TLur3akq1yvHJ0G3jrjy+Yg7tAGZnDgPKei0MoC8gI4cfTX+25fGDt+Qvd27P1xoPmCkMgPNM4xdcE/cBtfcrx7dnU3/S9T9uy/Bv1z82URU/p6CrY5qldxrHf83V3+/UzmCYfF0vbt+c/mzMA7uS3dX7isqXhdXXO/KNo3lx450190U1X2QUFr2tzbqNqRtDA3N37sOzwm/fGqYBbNyVQwd7MzJS7g3WTlQoJNUqs4nqgokArMnAp1qyun1nUtdZVSpL5qM9g0+n/3hSPcvEjUuTm5K1vY9l287tuXtnBGhwXurIbZ/blq9t78+jh29pOrhY23sw1x7emU17Jm/mVm97LHemeOpidd3EZhaimmrOavrE8g1fQ4g12DfjKer62Iv5vVrbm0MHezPx/4vUB3AjMzYU5lN1qtKu3Hp0T/m+ZCJsnjrVsjaInlo9Vjl+Re1jLU6BrH3+dNerjA/L4fxkP9M4UC7sJ6pXmtOA8uxU368Hsie7n60dnDcE6tXK05HD2bn9aG59bF9u6yie9lr0Hs2m4rWja18OdSXFL366MADOL+UlETZMric6cjg7t29O366D6V3blX0Hb5k6RfOfNHks5eV+Vm94bNq/8yPfOJoXV23I52qLH65fkRwfzqmk/rnV4H6aTGqibz048cHOpuqYtGtfDt1S2zeUDzl0cF2TaZsj+cujx9M13cUKXLtiVXL01Yxkrc87nKXF2zBgSnXDqmx77OCUBZk7Ghe8SXX9nKrJhRaLbio6uvbl0PV92bS9Lx852JumyznOuT2Vtc0mmtNXGTQW3ZCUb+o+0rc5d/ddP6dFrYEFNlG1+mieuaX5gKWja18eT3WR2PLnuIVcqfEsddOfzi/ldRznw0X/Xo18I187nmTVYjcEkhf7n8ytdfcvlTVdN9YsqF0ZgO6shD5r121M9jyfwd61lYWyK3+nj9c8Nvh8DmdFHphx9NXC9XoP5tC6ZtM2B/P08J2TA82Rw9m5feomHpPmPqCcTrMB9BTP7snzuw5Ortk4cjg79wzXzGQYTF/Tfq6xL5tcn2lKmNlswD0Po9/CMADOK42bDSXpqKxpPetKqvLaaCvWTfM3frAvd/cfT9euho1/rl2R1Tmab48ka2t+MVhu3LRLfDzZuGZqpfLza98YyW2zqvw8lVeOr8qNc9iTwOcd5s85D8+aTtVJkhxP/8Ri0o3qdz55tH9Ftm1L+ofLQdrwxo3Jns3ZVHTRVdvy+L7eHDpY+XniW7mzb8/I4UfTv2JbtqU/r2Qkzzw5nK6Nye7Nm4taU/6Gsq6SDjjvrO3NAxs3Z3cldG/1Fu3F/vI0geYqJVFNpka2bhZrbh3vn7J2V+E5Gx6Z/JJiOE/u7Mud+1p/Dzpq+tjpXCzv1eDT1fYdzaM7G3cJhXNs4511f+cnlrWoTZ86uvK5bUdzd7X6aO26dOXJicFhuZprY7qeHZ587NXhpK7Cq7mWrlf47LXprd1ApOOW3Loq+dqrDaPWCXMfUBYqGkA3WrUtt9e+GaeG82JW5M6JJzW8lsLLba+frTCvA+4CBWEAnFdGXs1wjudws/HYPFeYl8eDq5ou45OO6zN1FYby+mm3PjbNB+jUcF7MszVrpk5aveEsGzwb167I6sx5JyWgxjkPz9b2Vr6lq0zLuXOmQWnj9J1Tw1mxqzc//erOJOVB2r4k6e1tes5mO6DNZ3tODa/IA7235Ns7k/K3ieVV0srNqa+0mPh2cbrzA+eNtb2PZdvw9uzuW1dXJVofupc3EMmqbdm2osWpiBNTI5tMg2rWF027c/E05rKOV7kR5WqOjRtz+Nln8+Lx49m9ubLd+Wyunw/Ce1W+ge7amBx+9nhezPHcvXk4DxRVOcMCW72i/m/eqeHjWb3hc1P+bnfcsiGr+6vVCNfmxlXHJ8KZU8PH07VuX9Zlc578xkhu60rLFV6tXW861d3Pa17TORpoTjuAbrTi+vrXUQm4dm9+dsappjUXrFyvpu9pYcA9ZZOTgl3pCzUNA+B8tNA739Ysu1A4a6jJsxrW3i7U0r0FcKFYvGmbSVJwczBVzdcLa3vTm2Tk1SaHnRrOi6tWnMWAZfbtWdtbXu/m202bc3zKTSxwIenIbXduTP+eJ/PM7ZOhTTV0bwzIB/taqVxq1LzKdUpftGr6/eKmtHxK9VezNYySZG16D+6rf/Lg0+UbyXXDOVxZ8+zaw5Xtzme5YcDF/l5Vb6AfX1GpttnXlVN9m7O7b50NA7iA1K6DdX2ef3Zj1vUma7MxLz75jYzckhnX9pkP1VCoa9fBHKpZq23hv3Sc2wC6XnU65mD6NjcsVN7UYPr2PJuuZsuOzDDgbrW6Fy5oHddnRfrz/GBvFmat+6L/1zce9mqGk9xY87yWvky4dkVWHz8PNh45NTzH6n2g0cKEZ9WFUbeVRw5/2bc5/U23MW/h24RpFo6ecuirw8mKdVNvNhq/HSw0n+0pnlu/4nrfP8CFoTy4adw5dzotTUWs0zC1sLCaahbNrkx1XLHrYG5/tbLY7r6uifUWN+2sGZhNud7kgK4jkwv2TAzWZr9YWaEL/r2a2KxmbfKNyVNWN5SxYQDng2tXrMqLTaZLVtf1qn7FN1EZNjicwxvXpTdJ1q5L1/Hnc+pU8uLGdS1Vf7R6vanKA9LV2x6bdkfd+dfiALpla9N78GBuP7xz2mmqg32VdeEaL3kuBtxTwgA4H1V2itzTl3V1s4r68pe39E7z+ejIR1YkLw7X1rmWH6ubAl5Z8P+BfTN87hunZFe/YJypu+i4Jbeu6k//o4fz0zVh+GBfX9I73Xjz2tw4Zbp6uTr4lTksXDby6nAybd8LtGrJ+2fOZEl7+/yetaMr+w5eX94pJJnmhmQOlWeFyjtwdu2a+canbie4hWrP4NPpP74xD9gPAC5QI3lmZ2VwM4s1ZlrdQbJu2k0r1VRJ7t7cX7cbW2G7H+3Pixt3Zd/aqVW6axvXW+zoyr5dfdm0eXP53Ne+muHKczM43XWmaUFhH1vvgn+vMpxs+1x5F+fpLgOLqKPrznT176nfpGjkcB5tXNerMtDbvSfp2lVdrOva3Ljq2ezek6zedvv8Xm/KultTB7wjhx9N//Hppm3ObUBZVwnbygC6lengg33pS29Lwd/I4Z2VnYybHDznAfcsTFmfDc5Pa3sP5oFsrv///MZdM1Zerr19W1ZvLy8VUb3XmBLsTzNFunYqdGP41MqunWUduW3fY8nO7XVrqq7e9lj2TfOsyVkP5S8Yy/cy5f6xf9YbJZRnQmXFnaaOwjxYcuLV72TlDdcvwKnXpvexbRl++vrsK7yTmL9Kr8G+PeUpMw0nOzXcZC/wQvPVnslqlfpzncors2kOsGjKg7YWvpEsH5ydT1+f2cxoLJx20+r6i4VNqW93x/XFcwcndnTr7c2hXcmmyre7+2Za5Lpgcf3VrcyWvNjeq5ku/GxlnbcGZlxx7qxN78Fdyebav4vN1vUqT93M8RVZt7bxseTWW1oderV4vequeds3p796/9W7K101z1u9bVe2rdozzbTNuQwoG6ZctTCAbnWwfHjP5sm12oqmXlaCxOT4lGtWB8lzG3C3TiUK56spX1qlZn3qpgp24p5YL7XmoVs2ZHV/TVXn2t4cOjjTDU+lIra6jmNlQ487DzbrDZq1ZYadwpu0M2netim7IrdynsrO6a0UlwAzW/K919/Ka997PR/+0DXzf/aOrhkGYfNT6VVe4HVjHpiyTkV56uTqDfW3B8VrRcxHe2q2aG+sqBh5NcNZlVvdrcD5rWa3teluN04NHy+HI8Pb8vi+tTk13YzG2jUnBvuyac/0fU1xXzT9DpJT+re169J1fE/BTpKrylMOk8qN2rRNqnna1EHhYN/mVGdLNutjP7Dv1ZSFvMtTxF5p8enQuukGaeWphDMNE5t9dmdaX6vZYLfV600dFDd5Xlfta5r6Gmc/oDyVV45vnAwIZxxAj+Tbw6ty6+2THUnT1zzdeeraUTTIrXvC9APulhSdoyEMgA+KamD/9GBua3WKdnUm0b6Oyo/lavVFiaIqm5I8efj21jYkSc3ux7IzmBdLPnTNlfn/Rr67MOHZjOah0muwrxKcTa5Bs3N7/+TAa1XN9t/noD0Ta1hUS30bdkSazdpJwGKYrBydacrft4dTNzXw1JRTNQQ/1Ruulr7tnObKh3dmU3+zMtZmYVFrg9immoVEa3tzqEn5w9reg9NURVz871Vh6DD1yNy2r9XkDZjRbAeUI69muLqmW0tO5ZVsyO0Xy71bQxgAHyTV6tadK1rYEXfkcHZW1oCdzNqbfVlwrnTkts9ty9e2b0/f9TMtS5HKF8Gp380XOCtt//Da98b/7u9P5hM/+dEkyZ+88p28+vpb+ZWP3ZhL20s5efJkrrvuukVuJsDszb7/qtlxzdbiwCJy/zULNRt/nNvNBi4w3ifOIX0YcKGq7b+OfetU/uo7r6X3Zz6aJcl42pJ874238qGrr1zcVgIsouri1EnzNb2SaRa5B2BxFK73Qx3vEwDM2ZKkLeOL3QqA88BMa/sAAADwwVOqVp4BAAAAAPVKKs8AAAAAoDmVZwAAAABQQOUZAAAAABRQeQYAAAAABVSeAQAAAEABlWcAAAAAUEDlGQAAAAAUWNJK5dnJkyfPSWMA5pv+C7hQ6b+AC5k+DLiYLLnqyitmrDxbunTpOWkMwHw6ffq0/gu4IOm/gAuZPgy4UJ0+fbrp46Uk1jwDAAAAgCZKSax5BgAAAABNqDwDAAAAgAIqzwAAAACggMozAAAAACig8gwAAAAACqg8AwAAAIACKs8AAAAAoIDKMwAAAAAooPIMAAAAAAqoPAMAAACAAirPAAAAAKCAyjMAAAAAKKDyDAAAAAAKqDwDAAAAgAIqzwAAAACggMozAAAAACig8gwAAAAACqg8AwAAAIACKs8AAAAAoIDKMwAAAAAooPIMAAAAAAqoPAMAAACAAirPAAAAAKCAyjMAAAAAKKDyDAAAAAAKqDwDAAAAgAIqzwAAAACggMozAAAAACig8gwAAAAACqg8AwAAAIACKs8AAAAAoIDKMwAAAAAoUDpz5ozKMwAAAABoovTm2++kLcmS9tJitwUAAAAAziul106/nssvvzRXXnH5YrcFAAAAAM4rpTfffic3/EjHYrcDAAAAAM47S679wR/INVdfOe1Bp0+fPkfNAZhf+i/gQqX/Ai5k+jDgYrLkR3/k2mkPuO66685RUwAAAADg/GKXAAAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAoIDwDAAAAgALCMwAAAAAo8P8DjpwIunapw90AAAAASUVORK5CYII=)
一列用于计算合计,一列用于计算占比,你按照我这个去写试试 |
|
|
|
|
yhdata_cGxQ0JdB
显示全部楼层
发表于 2022-10-12 17:39:50
合计那列没有问题。
但是占比计算就不对,如图。
是否left这种形式不对呢? 第几列还有其他方式表示吗? |
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 17:48:07
|
|
|
|
yhdata_cGxQ0JdB
显示全部楼层
发表于 2022-10-12 17:52:10
|
|
|
|
yhdata_cGxQ0JdB
来自手机
显示全部楼层
发表于 2022-10-12 18:19:46
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 18:24:06
|
|
|
|
yhdata_cGxQ0JdB
显示全部楼层
发表于 2022-10-13 09:26:27
cell(ridx,cidx-2)/cell(ridx,cidx-1)这个可以搞定。
但是不需要的那列需要在自由表中隐藏,没有找到在哪里设置呢? 8.5.2版本有可以设置某列不显示隐藏这个功能吗? |
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-13 09:35:25
|
|
|
|