倉儲(chǔ)平面動(dòng)態(tài)圖(EXCEL貨位管理)

1、數(shù)據(jù)區(qū)排位貨位庫存量占存比率出貨量出貨比率存貨類別101A013530.169624281110.200777788B B01A025430.260923467380.068734738C C01A03530.0254676683200.578818848A A01A045340.2565987694000.72352356A A01A055430.2609234675100.922492539A A01A060060.010852853C C01A073780.1816373314600.832052094A A01A088930.42910618100C C01A098870.426223

2、0492000.36176178B B01A103780.1816373313500.633083115A A01B018930.4291061813500.633083115A A01B0220.0009610443500.633083115A A01B037890.3791318893500.633083115A A01B0450.002402613500.633083115A A01B053870.1859620293500.633083115A A01B0630.0014415663500.633083115A A01B077830.3762487573500.633083115A A

3、01B08180.0086493973500.633083115A A01B09190.0091299193500.633083115A A01B10200.0096104413500.633083115A A01C01210.0100909633500.633083115A A01C02220.0105714853500.633083115A A01C03230.0110520073500.633083115A A01C04240.0115325293500.633083115A A01C05250.0120130513500.633083115A A01C06260.01249357335

4、00.633083115A A01C07270.0129740953500.633083115A A01C08280.0134546173500.633083115A A01C09290.0139351393500.633083115A A01C10300.014415661130.023514516C C01D01310.014896183110.019896898C C01D02320.015376705240.043411414C C01D03330.015857227110.019896898C C01D04340.016337749150.027132133C C01D05350.0

5、16818271220.039793796C C01D06360.017298793220.039793796C C01D07370.01777931540.007235236C C01D0850.00240261230.041602605C C01D09390.01874036290.052455458C C01D10400.01922088250.009044044C C202A01410.01970140450.009044044C C02A02420.02018192650.009044044C C02A03430.02066244800C C02A04440.0211429750.0

6、09044044C C02A05450.02162349250.009044044C C02A06460.02210401450.009044044C C02A07470.02258453650.009044044C C02A08480.02306505850.009044044C C02A09490.0235455850.009044044C C02A10500.02402610250.009044044C C02B01510.02450662450.009044044C C02B02520.02498714650.009044044C C02B03530.02546766850.00904

7、4044C C02B04540.0259481950.009044044C C02B05550.02642871200C C02B06560.02690923450.009044044C C02B07570.027389756250.045220222C C02B08580.02787027850.009044044C C102B09590.028350850.009044044C C02B10600.028831322250.045220222C C02C01610.029311844280.050646649C C02C02620.02979236650.009044044C C02C03

8、630.03027288850.009044044C C02C04640.030753411250.045220222C C02C05650.031233933440.079587592C C02C06660.03171445550.009044044C C02C07670.03219497750.009044044C C02C08680.032675499550.099484489C C02C09690.03315602150.009044044C C02C10700.03363654350.009044044C C02D01710.03411706550.009044044C C02D02

9、720.03459758750.009044044C C02D03730.035078109450.0813964C C02D04740.03555863150.009044044C C02D05750.0360391533400.614995026A A02D06760.0365196753400.614995026A A02D07770.0370001973400.614995026A A02D08780.0374807193400.614995026A A02D09790.0379612413400.614995026A A02D10800.0384417633400.614995026

10、A A303A01810.0389222853400.614995026A A03A02820.0394028073400.614995026A A03A03830.0398833293400.614995026A A03A04840.0403638513400.614995026A A03A05850.0408443733400.614995026A A03A06860.0413248953400.614995026A A03A07870.0418054173400.614995026A A03A08880.0422859393400.614995026A A203A09890.042766

11、4613400.614995026A A03A10900.04324698450.009044044C C03B01910.04372750650.009044044C C03B02920.04420802850.009044044C C03B03930.0446885550.009044044C C03B04940.04516907250.009044044C C03B05950.04564959450.009044044C C03B06960.04613011650.009044044C C03B07970.04661063850.009044044C C03B08980.04709116

12、50.009044044C C03B09990.04757168250.009044044C C03B101000.04805220450.009044044C C03C011010.04853272650.009044044C C03C021020.04901324850.009044044C C03C031030.0494937750.009044044C C03C041040.04997429250.009044044C C03C051050.05045481450.009044044C C03C061060.05093533650.009044044C C03C071070.05141

13、585850.009044044C C03C081080.0518963850.009044044C C03C091090.05237690250.009044044C C03C101100.05285742450.009044044C C03D011110.05333794650.009044044C C03D021120.05381846850.009044044C C03D031130.0542989950.009044044C C03D041140.05477951250.009044044C C03D051150.055260035550.099484489C C03D061160.

14、055740557550.099484489C C03D071170.056221079550.099484489C C03D081180.056701601550.099484489C C303D091190.057182123550.099484489C C03D101200.057662645550.099484489C C404A011210.058143167550.099484489C C04A021220.058623689550.099484489C C04A031230.059104211550.099484489C C04A041240.059584733550.09948

15、4489C C04A051250.060065255550.099484489C C04A061260.060545777550.099484489C C04A071270.061026299550.099484489C C04A081280.061506821550.099484489C C04A091290.061987343550.099484489C C04A101300.062467865550.099484489C C04B011310.062948387550.099484489C C04B021320.063428909550.099484489C C04B031330.063

16、909431550.099484489C C04B041340.064389953550.099484489C C04B051350.064870475550.099484489C C04B061360.065350997550.099484489C C04B071370.065831519550.099484489C C04B081380.066312041550.099484489C C04B091390.066792563550.099484489C C04B101400.067273085550.099484489C C04C011410.067753608550.099484489C

17、 C04C021420.06823413550.099484489C C04C031430.068714652550.099484489C C04C041440.069195174550.099484489C C04C051450.069675696550.099484489C C04C061460.070156218550.099484489C C04C071470.07063674550.099484489C C04C081480.071117262550.099484489C C304C091490.071597784550.099484489C C04C101500.072078306

18、550.099484489C C04D011510.072558828550.099484489C C04D021520.07303935550.099484489C C04D031530.073519872550.099484489C C04D041540.074000394550.099484489C C04D051550.074480916550.099484489C C04D061560.074961438550.099484489C C04D071570.07544196550.099484489C C04D081580.075922482550.099484489C C04D091

19、590.076403004550.099484489C C04D101600.076883526550.099484489C C505A011610.077364048550.099484489C C05A021620.07784457550.099484489C C05A031630.078325092550.099484489C C05A041640.07880561450.009044044C C05A051650.07928613650.009044044C C05A061660.07976665850.009044044C C05A071670.08024718150.0090440

20、44C C05A081680.08072770350.009044044C C05A091690.08120822550.009044044C C05A101700.08168874750.009044044C C05B011710.08216926950.009044044C C05B021720.082649791880.159175183C C05B031730.083130313880.159175183C C05B041740.083610835880.159175183C C05B051750.084091357880.159175183C C05B061760.084571879

21、880.159175183C C05B071770.085052401880.159175183C C05B081780.085532923880.159175183C C405B091790.086013445880.159175183C C05B101800.086493967880.159175183C C05C011810.086974489880.159175183C C05C021820.087455011880.159175183C C05C031830.087935533880.159175183C C05C041840.088416055880.159175183C C05C

22、051850.088896577880.159175183C C05C061860.089377099880.159175183C C05C071870.089857621880.159175183C C05C081880.090338143880.159175183C C05C091890.090818665880.159175183C C05C101900.091299187880.159175183C C05D011910.091779709880.159175183C C05D021920.092260232880.159175183C C05D031930.092740754880.

23、159175183C C05D041940.093221276880.159175183C C05D051950.093701798880.159175183C C05D061960.09418232880.159175183C C05D071970.094662842880.159175183C C05D081980.095143364880.159175183C C05D091990.095623886880.159175183C C05D102000.096104408880.159175183C C606A012010.09658493880.159175183C C06A022020

24、.097065452880.159175183C C06A032030.097545974880.159175183C C06A042040.098026496880.159175183C C06A052050.098507018880.159175183C C06A062060.09898754880.159175183C C06A072070.099468062880.159175183C C06A082080.099948584880.159175183C C506A092090.100429106880.159175183C C06A102100.100909628880.159175

25、183C C06B012110.10139015880.159175183C C06B022120.101870672880.159175183C C06B032130.102351194880.159175183C C06B042140.102831716880.159175183C C06B0500880.159175183C C06B0600880.159175183C C06B0700880.159175183C C06B0800880.159175183C C06B0900880.159175183C C06B1000880.159175183C C06C0100880.159175

26、183C C06C0200880.159175183C C06C0300880.159175183C C06C0400880.159175183C C06C0500880.159175183C C06C0600880.159175183C C06C0700880.159175183C C06C082280.10955902550.009044044C C06C092290.11003954750.009044044C C06C102300.11052006950.009044044C C06D012310.11100059150.009044044C C06D022320.1114811135

27、0.009044044C C06D032330.11196163550.009044044C C06D042340.11244215750.009044044C C06D052350.11292267950.009044044C C06D062360.11340320100C C06D072370.11388372300C C06D0860.00288313200C C606D092390.11484476700C C06D102400.11532528900C C707A012410.11580581150.009044044C C07A022420.11628633350.00904404

28、4C C07A032430.116766856990.179072081C C07A042440.117247378990.179072081C C07A052450.1177279990.179072081C C07A062460.118208422990.179072081C C07A072470.118688944990.179072081C C07A082480.119169466990.179072081C C07A092490.119649988990.179072081C C07A102500.12013051990.179072081C C07B012510.120611032

29、990.179072081C C07B022520.121091554990.179072081C C07B032530.121572076990.179072081C C07B042540.122052598990.179072081C C07B052550.12253312990.179072081C C07B062560.123013642990.179072081C C07B072570.123494164990.179072081C C07B082580.123974686990.179072081C C07B092590.124455208990.179072081C C07B10

30、2600.12493573990.179072081C C07C012610.125416252990.179072081C C07C022620.125896774990.179072081C C07C032630.126377296990.179072081C C07C042640.126857818990.179072081C C07C052650.12733834990.179072081C C07C062660.127818862990.179072081C C07C072670.128299384990.179072081C C07C082680.128779906990.1790

31、72081C C607C092690.129260429990.179072081C C07C102700.129740951990.179072081C C07D012710.130221473990.179072081C C07D022720.130701995990.179072081C C07D032730.131182517990.179072081C C07D042740.131663039990.179072081C C07D052750.132143561990.179072081C C07D062760.132624083990.179072081C C07D072770.1

32、33104605990.179072081C C07D082780.133585127990.179072081C C07D092790.134065649990.179072081C C07D102800.134546171990.179072081C C808A012810.135026693990.179072081C C08A022820.135507215990.179072081C C08A032830.135987737990.179072081C C08A042840.136468259990.179072081C C08A052850.136948781990.1790720

33、81C C08A0610.000480522990.179072081C C08A0710.000480522990.179072081C C08A0810.000480522990.179072081C C08A0910.000480522990.179072081C C08A102900.139351391990.179072081C C08B012910.139831913990.179072081C C08B022920.140312435990.179072081C C08B032930.140792957990.179072081C C08B0429401

34、79072081C C08B052950.141754002990.179072081C C08B062960.142234524990.179072081C C08B072970.142715046990.179072081C C08B082980.143195568990.179072081C C708B092990179072081C C08B103000.144156612990.179072081C C08C013010009044044C C08C023020009044044C C08C033030.1

35、4559817850.009044044C C08C043040.146078750.009044044C C08C053050009044044C C08C063060009044044C C08C073070009044044C C08C083080009044044C C08C093090.1484813150.009044044C C08C103100009044044C C08D013110009044044C C08D02312

36、0009044044C C08D033130009044044C C08D043140.1508839250.009044044C C08D053150009044044C C08D063160009044044C C08D073170009044044C C08D083180.1528060082220.401555576B B08D093190.153286532220.401555576B B08D103200.1537670532220.401555576B

37、 B909A013210.1542475752220.401555576B B09A023220.1547280972220.401555576B B09A033230.1552086192220.401555576B B09A043240.1556891412220.401555576B B09A053250.1561696632220.401555576B B09A063260.1566501852220.401555576B B09A073270.1571307072220.401555576B B09A083280.1576112292220.401555576B B809A09329

38、0.1580917512220.401555576B B09A103300.1585722732220.401555576B B09B013310.1590527952220.401555576B B09B023320.1595333172220.401555576B B09B033330.1600138392220.401555576B B09B043340.1604943612220.401555576B B09B053350.1609748832220.401555576B B09B063360.1614554052220.401555576B B09B073370.1619359272

39、220.401555576B B09B083380.1624164492220.401555576B B09B093390.1628969712220.401555576B B09B103400.1633774932220.401555576B B09C013410.1638580152220.401555576B B09C023420.1643385372220.401555576B B09C033430.1648190592220.401555576B B09C043440.1652995812220.401555576B B09C053450.1657801042220.40155557

40、6B B09C063460.1662606262220.401555576B B09C073470.1667411482220.401555576B B09C083480.167221672220.401555576B B09C093490.1677021922220.401555576B B09C103500.1681827142220.401555576B B09D013510.1686632362220.401555576B B09D023520.1691437582220.401555576B B09D033530.169624282220.401555576B B09D043540.

41、1701048022220.401555576B B09D053550.1705853242220.401555576B B09D063560.1710658462220.401555576B B09D073570.1715463682220.401555576B B09D083580.172026892220.401555576B B909D093590.1725074122220.401555576B B09D103600.1729879342220.401555576B B1010A013610.1734684562220.401555576B B10A023620.1739489782

42、220.401555576B B10A033630401555576B B10A043640.1749100222220.401555576B B10A053650.1753905442220.401555576B B10A063660.1758710662220.401555576B B10A073670.1763515882220.401555576B B10A083680.176832112220.401555576B B10A093690.1773126322220.401555576B B10A103700.1777931542220.401555576B

43、B10B013710.1782736772220.401555576B B10B023720.1787541992220.401555576B B10B033730.1792347212220.401555576B B10B043740.1797152432220.401555576B B10B053750.1801957652220.401555576B B10B063760.1806762872220.401555576B B10B073770.1811568092220.401555576B B10B083780.1816373312220.401555576B B10B093790.1

44、821178532220.401555576B B10B103800.1825983752220.401555576B B10C013810.1830788972220.401555576B B10C023820.1835594192220.401555576B B10C033830.1840399412220.401555576B B10C043840.1845204632220.401555576B B10C053850.1850009852220.401555576B B10C063860009044044C C10C073870009

45、044044C C10C083880009044044C C910C093890009044044C C10C103900009044044C C10D013910009044044C C10D023920009044044C C10D033930009044044C C10D043940009044044C C10D053950009044044C C10D063960.19028672

46、850.009044044C C10D073970.1907672550.009044044C C10D083980.19124777250.009044044C C10D093990.19172829450.009044044C C10D104000.19220881650.009044044C C1111A014010.19268933850.009044044C C11A024020.1931698650.009044044C C11A034030.19365038250.009044044C C11A044040.19413090450.009044044C C11A054050.19

47、461142650.009044044C C11A064060.19509194850.009044044C C11A074070.1955724750.009044044C C11A084080.19605299250.009044044C C11A094090.19653351450.009044044C C11A104100.19701403650.009044044C C11B014110.19749455850.009044044C C11B024120.197975082220.401555576B B11B034130.1984556022220.401555576B B11B0

48、44140.1989361242220.401555576B B11B054150.1994166462220.401555576B B11B064160.1998971682220.401555576B B11B074170.200377692220.401555576B B11B084180.2008582122220.401555576B B1011B094190.2013387342220.401555576B B11B104200.2018192562220.401555576B B11C014210.2022997782220.401555576B B11C024220.20278

49、03012220.401555576B B11C034230.2032608232220.401555576B B11C044240.2037413452220.401555576B B11C054250.2042218672220.401555576B B11C064260.2047023892220.401555576B B11C074270.2051829112220.401555576B B11C084280.2056634332220.401555576B B11C094290.2061439552220.401555576B B11C104300.2066244772220.401

50、555576B B11D014310.2071049992220.401555576B B11D024320.2075855212220.401555576B B11D034330.2080660432220.401555576B B11D044340.20854656520.003617618C C11D054350.20902708720.003617618C C11D064360.20950760920.003617618C C11D074370.20998813120.003617618C C11D084380.21046865320.003617618C C11D094390.210

51、94917520.003617618C C11D104400.21142969720.003617618C C1212A014410.21191021920.003617618C C12A024420.21239074120.003617618C C12A034430.21287126320.003617618C C12A044440.21335178520.003617618C C12A054450.21383230720.003617618C C12A064460.21431282920.003617618C C12A074470.21479335120.003617618C C12A08

52、4480.21527387420.003617618C C1112A094490.21575439620.003617618C C12A104500.21623491820.003617618C C12B014510.2167154420.003617618C C12B024520.21719596220.003617618C C12B034530.21767648420.003617618C C12B044540.21815700620.003617618C C12B054550.21863752820.003617618C C12B064560.2191180520.003617618C

53、C12B074570.21959857220.003617618C C12B084580.22007909420.003617618C C12B094590.22055961620.003617618C C12B104600.22104013820.003617618C C12C014610.2215206620.003617618C C12C024620.22200118220.003617618C C12C034630.22248170420.003617618C C12C044640.22296222620.003617618C C12C054650.22344274820.003617

54、618C C12C064660.2239232720.003617618C C12C074670.22440379220.003617618C C12C084680.22488431420.003617618C C12C094690.22536483620.003617618C C12C104700.22584535820.003617618C C12D014710.2263258820.003617618C C12D024720.22680640220.003617618C C12D034730.22728692520.003617618C C12D044740.22776744720.00

55、3617618C C12D054750.22824796920.003617618C C12D064760.22872849120.003617618C C12D074770.22920901320.003617618C C12D084780.22968953520.003617618C C1212D094790.23017005720.003617618C C12D104800.23065057920.003617618C C1313A014810.23113110120.003617618C C13A024820.23161162320.003617618C C13A034830.2320

56、9214520.003617618C C13A044840.23257266720.003617618C C13A054850.23305318920.003617618C C13A064860.23353371120.003617618C C13A074870.23401423320.003617618C C13A084880.23449475520.003617618C C13A094890.23497527720.003617618C C13A104900.23545579920.003617618C C13B014910.23593632120.003617618C C13B02492

57、0.23641684320.003617618C C13B034930.23689736520.003617618C C13B044940.23737788720.003617618C C13B054950.23785840920.003617618C C13B064960.23833893120.003617618C C13B074970.23881945320.003617618C C13B084980.23929997520.003617618C C13B094990.23978049820.003617618C C13B105000.2402610220.003617618C C13C

58、015010.24074154220.003617618C C13C025020.24122206420.003617618C C13C035030.24170258620.003617618C C13C045040.24218310820.003617618C C13C055050.2426636320.003617618C C13C065060.24314415220.003617618C C13C075070.24362467420.003617618C C13C085080.24410519620.003617618C C1213C095090.24458571820.00361761

59、8C C13C105100.2450662420.003617618C C13D015110.24554676220.003617618C C13D025120.24602728420.003617618C C13D035130.24650780620.003617618C C13D045140.24698832820.003617618C C13D055150.2474688520.003617618C C13D065160.24794937220.003617618C C13D075170.24842989420.003617618C C13D085180.24891041620.0036

60、17618C C13D095190.24939093820.003617618C C13D105200.2498714620.003617618C C1414A015210.25035198220.003617618C C14A025220.25083250420.003617618C C14A035230.25131302620.003617618C C14A045240.25179354920.003617618C C14A055250.25227407120.003617618C C14A065260.25275459320.003617618C C14A075270.253235115