# Create Sample Bulk sheet # Bulk Sample Sheet ### **Bulk Sample Sheet Creation** This original SME sales result sheet has many required sheets for a bulk sample sheet. To create the bulk sample sheet, the data values ​​of the required columns must be copied and pasted separately from the sheet. [http://srr.lalco.la/](http://srr.lalco.la/) Note: Do not change column headers for any reason Make sure the dates are in the correct format **No need to add data for below mentioned sheets.** - Currency\_rate - sales results report old - broker - gs200 - call data - plan bo - sales plan **Rules sheet** From the rule sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. B - W Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/MTCimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/MTCimage.png) Note: The total in the last row should not be copied and pasted in the rule sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/VuQimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/VuQimage.png) Paste only the copied Values ​​without Headings in the columns of the rule sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/urzimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/urzimage.png) **holiday sheet** From the rule sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. Y- AA Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/Ah8image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/Ah8image.png) Paste only the copied Values ​​without Headings in the columns of the holiday sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/sm8image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/sm8image.png) **Classification sheet** From the rule sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. AB/ AC/ AD/ AG/ AH Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/Etoimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/Etoimage.png) Paste only the copied Values ​​without Headings in the columns of the classification sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/TfOimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/TfOimage.png) **Engine result sheet** From the rule sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. AE Column [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/W8Iimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/W8Iimage.png) Paste only the copied Values ​​without Headings in the columns of the engine result sheet in the sample bulk sheet **stf** From the stf sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. A- AM Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/DJsimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/DJsimage.png) Paste only the copied Values ​​without Headings in the columns of the stf sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/8tKimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/8tKimage.png) **gaiho staff list** From the gaiho staff list sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. S/ CX - DD / DO - DU Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/5ffimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/5ffimage.png) Paste only the copied Values ​​without Headings in the columns of the gaiho staff list sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/b7Jimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/b7Jimage.png) **sales result report old** The sales result report old sheet is not in the original SME Sales result sheet. therefore copy only the values ​​except the headings in the following columns from the sample sheet in SRR Upload. A- AM Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/Km3image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/Km3image.png) [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/GUrimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/GUrimage.png) Paste only the copied Values ​​without Headings in the columns of the sales result report old sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/Lj8image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/Lj8image.png) **Monthly balance** From the monthly balanc sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. A- AB /AG - AU / AX - AZ / BD - BF / BI- BL / BW / BX /CM/ CT / CU / DP/ DQ / DW /DX / EA /EB Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/Y7kimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/Y7kimage.png) Paste only the copied Values ​​without Headings in the columns of the monthly balance sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/odximage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/odximage.png) **Payment list** From the Payment list sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. G-N /Q /Z- AG /AJ/AV-BD Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/9eVimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/9eVimage.png) Paste only the copied Values ​​without Headings in the columns of the Payment list sheet in the sample bulk sheet. [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/dIUimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/dIUimage.png) **Broker** From the broker sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. Columns A-AL except column AA [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/L6rimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/L6rimage.png) Paste only the copied Values ​​without Headings in the columns of the broker sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/f9mimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/f9mimage.png) **sp rank** From the sp rank sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. C-K Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/VuOimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/VuOimage.png) Paste only the copied Values ​​without Headings in the columns of the sp rank sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/MCSimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/MCSimage.png) **gs200** From the gs200 sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. A - AW / AS/AT/AU/AV/AW Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/EDDimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/EDDimage.png) Paste only the copied Values ​​without Headings in the columns of the engine result sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/r1rimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/r1rimage.png) **Call data** From the Call data sheet (200-3-3-1) in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. G/H/ M - Q /S/T Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/GEnimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/GEnimage.png) Paste only the copied Values ​​without Headings in the columns of the Call data sheet in the sample bulk sheet M/N/P/Q/R/T/U AS/AT/AV/AW/AX/AZ/BA/BC/BD/BE/BG/BH/BJ/BK/BN/BO/BP/BQ/BR/BS/BT/BU/BV/BW/ [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/ifximage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/ifximage.png) **Collection** From the Collection sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. B- BZ Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/u1Bimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/u1Bimage.png) Paste only the copied Values ​​without Headings in the columns of the Collection sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/Ywoimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/Ywoimage.png) **smeb person in charge cl** From the Collection sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. A /C /E / G /I Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/419image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/419image.png) Paste only the copied Values ​​without Headings in the columns of the Collection sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/A7wimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/A7wimage.png) **request route** From the request route sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. A/B /D-H/J/M/O/P/Q/R/S/V-Z/AC/AD/AE/AF [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/Atyimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/Atyimage.png) Paste only the copied Values ​​without Headings in the columns of the request route sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/F9ximage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/F9ximage.png) **planBO** From the planBO sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. Columns A-K /M /O- V / W-AE AJ/ AF/AG/AH/AK except for column L [ ![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/LJ7image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/LJ7image.png) Paste only the copied Values ​​without Headings in the columns of the planBO sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/UN5image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/UN5image.png) **increase list** From the increase list sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. A/B/C/O / Q / AF /AL /AP /AQ / AR /AS Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/mjlimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/mjlimage.png) Paste only the copied Values ​​without Headings in the columns of the increase list sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/zp6image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/zp6image.png) **dormant** From the dormant sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. A - AV / BI / BY-CE [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/s0Nimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/s0Nimage.png) Paste only the copied Values ​​without Headings in the columns of the dormant sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/IT6image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/IT6image.png) **ddt0705** From the ddt0705 sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. L / O-V / AC / AI / except for column R/W [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/uM6image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/uM6image.png) Paste only the copied Values ​​without Headings in the columns of the ddt0705 sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/rZuimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/rZuimage.png) **ddt0805** From the ddt0805 sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. L/O-Y except for column R/T/W [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/9t8image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/9t8image.png) Paste only the copied Values ​​without Headings in the columns of the ddt0805 sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/3uWimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/3uWimage.png) **budget gaiho** From the budget gaiho sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. I /V/W/X/Y Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/teBimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/teBimage.png) Paste only the copied Values ​​without Headings in the columns of the budget gaiho sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/ag1image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/ag1image.png) **budget unit** From the budget unit sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. H /AW/AX/AY/AZ / BB / BD/BE/BG /BH /BI/BJ/BK /BM /BO/BP /BR/BS/BT/BU/BV /BX/ BZ/CA/CD/CE/CF/CG/CI/CK /CL/CN/CO/CP/CQ/CR Columns [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/ryWimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/ryWimage.png) Paste only the copied Values ​​without Headings in the columns of the budget unit sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/kkIimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/kkIimage.png) **Sales Plan** From the Daily (Unit) sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. Columns - D / I-AL / BG - BL [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-12/scaled-1680-/image.png)](http://wiki.lalco.la/uploads/images/gallery/2024-12/image.png) Paste only the copied Values ​​without Headings in the columns of the sales plan sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-12/scaled-1680-/FYLimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-12/FYLimage.png) **not pay last month** From the not pay last month sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns. Columns A- AD/AE/AG /AH/ AP-AL except for column U/AA [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/0mKimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/0mKimage.png) Paste only the copied Values ​​without Headings in the columns of the not pay last month sheet in the sample bulk sheet [![image.png](http://wiki.lalco.la/uploads/images/gallery/2024-11/scaled-1680-/3IZimage.png)](http://wiki.lalco.la/uploads/images/gallery/2024-11/3IZimage.png) Sample bulk files can be found at the following link [Sample bulk sheets](https://drive.google.com/drive/folders/1PjNEmiS305fN6nsGqBJLpV2ebZhSQzdi?usp=drive_link)