# 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

**Need to add data for the sheets mentioned below one by one**

- staff list
- advance recording
- monthly balance
- collection
- smeb person in charge cl
- budget gaiho
- budget unit
- gaiho staff list
- max
- not pay last month
- rules
- holiday
- classification
- engine result
- SP Rank
- cumulative performance for curr
- srr daily win and lose
- summary ddt ratio early repayme
- net increase
- real estate collataral
- srr three month col data
- srr three month deposit cc data

**Rules sheet**   
  
From the rule sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[Rule](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=532292939#gid=532292939)  
[![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 into the rule sheet

[![rules.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/rules.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/rules.png)

Paste only the copied Values ​​without Headings in the columns of the rule sheet in the sample bulk sheet

**holiday sheet** From the rule sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[Holiday](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=710379517#gid=710379517)

[![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

  
[![holiday.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/holiday.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/holiday.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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[Classification](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=349059117#gid=349059117)

[![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

[![classification.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/classification.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/classification.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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[Engine result](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1384805093#gid=1384805093)

[![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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
[stf](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=2003039935#gid=2003039935)</span>  
  
[![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

[![staff list.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/staff-list.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/staff-list.png)

**Advance Recording** From the Advance Recording sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[advance recording](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=555543761#gid=555543761)

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/image.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/image.png)

Paste only the copied Values ​​without Headings in the columns of the Advance Recording sheet in the sample bulk sheet

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/O5aimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/O5aimage.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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[gaiho](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1157779189#gid=1157779189)

[![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

[![gaiho.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/gaiho.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/gaiho.png)

**max**

From the max sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following table columns.

It has tables  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[max](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=408413221#gid=408413221)

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/twmimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/twmimage.png)

Paste only the copied Values ​​without Headings in the columns of the max sheet in the sample bulk sheet

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/EIKimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/EIKimage.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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[monthly balance](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1757726473#gid=1757726473)

[![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

[![monthly balance.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/monthly-balance.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/monthly-balance.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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[sp rank](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1345044554#gid=1345044554)

[![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

[![sp rank.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/sp-rank.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/sp-rank.png)

**Collection**

From the Collection sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[collection](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=85557805#gid=85557805)

[![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

[![collection.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/collection.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/collection.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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>  
[ smeb person in charge cl](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1528088026#gid=1528088026)

[![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

[![smeb person.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/smeb-person.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/smeb-person.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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
[ budget gaiho](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1078143303#gid=1078143303)  
</span>

[![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

[![Budget Gaiho.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/budget-gaiho.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/budget-gaiho.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.   
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
</span><span style="color: rgb(53, 152, 219);">[budget unit](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1285345609#gid=1285345609)</span>

[![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

[![Budget Unit.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/budget-unit.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/budget-unit.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.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
</span>[not pay last month ](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=273721591#gid=273721591)

[![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

[![not pay last month.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/not-pay-last-month.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/not-pay-last-month.png)

**cumulative performance for curr**

From the cumulative performance for curr sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings</span>**<span style="color: rgb(53, 152, 219);">  
</span>**[cumulative performance for curr](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1618796402#gid=1618796402)  
(Summary sheet row- 625, column P,Q,R)

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/Nliimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/Nliimage.png)

Paste only the copied Values ​​without Headings in the columns of the **cumulative performance for curr** sheet in the sample bulk sheet

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/SOximage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/SOximage.png)

**Net Increase**   
From the Net Increase sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
</span>[net increase](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=279943669#gid=279943669)  
(Summary sheet Row 689, 693, column D to R)

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/1QRimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/1QRimage.png)

Paste only the copied Values ​​without Headings in the columns of the Net Increase sheet in the sample bulk sheet

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/ClKimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/ClKimage.png)

 **Summary DDT**   
   
From the Summary DDT sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
</span>[Summary DDT](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=646411132#gid=646411132)  
(Summary sheet Row 650, 652, 654, 656, 658, column D to G)

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/Hdyimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/Hdyimage.png)

  
Paste only the copied Values ​​without Headings in the columns of the Summary DDT sheet in the sample bulk sheet

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/kZHimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/kZHimage.png)

 **srr daily win and lose**   
Summary sheet Row- 2592 to 2674, column - C , DA, DD, DH  
From the **srr daily win and lose** sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
[srr daily win and lose](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=693972817#gid=693972817)  
</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/97Cimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/97Cimage.png)

Paste only the copied Values ​​without Headings in the columns of the **srr daily win and lose sheet in the sample bulk sheet

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/Eyaimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/Eyaimage.png)

 **Real Estate**

From the Real Estate sheet in the sample bulk sheet, copy &amp; paste only the values ​​except the headings in all columns. [![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/34Mimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/34Mimage.png)

##### **srr three month col data** 

Summary sheet Row- 4773 to 4807 , Column- B, CO,CP , DE,DF , DU,DV  
From the **srr three month col data** sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
[srr three month col data ](https://docs.google.com/spreadsheets/d/1Oci5QGgkEyrzrfs2djD1_YAUEDIzVdeez9U9x1gkzvg/edit?gid=1519419539#gid=1519419539)  
</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/MVIimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/MVIimage.png)

  
Paste only the copied Values ​​without Headings in the columns of the **srr three month col data sheet in the sample bulk sheet

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/PdDimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/PdDimage.png)

#####  **srr three month deposit cc data**

Summary sheet Row - 4815 to 4821, Column- B, AI,AJ, AN,AO, AS,AT

From the **srr three month deposit cc data** sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.  
<span style="color: rgb(53, 152, 219);">Click this link for the headings  
[srr three month deposit cc data](#bkmrk-srr-three-month-depo)  
</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/cziimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/cziimage.png)

<span style="color: rgb(0, 0, 0);">Paste only the copied Values ​​without Headings in the columns of the **srr three month deposit cc data sheet in the sample bulk sheet  
</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/3IPimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/3IPimage.png)

<span style="color: rgb(0, 0, 0);">  
  
</span>

Finally Upload create a zip file containing all sheets within one folder

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2025-06/scaled-1680-/4kTimage.png)](http://wiki.lalco.la/uploads/images/gallery/2025-06/4kTimage.png)