Skip to main content

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/

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.

  • 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

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

Note: The total in the last row should not be copied and pasted in the rule sheet

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.
Y- AA Columns

image.png


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

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.
AB/ AC/ AD/ AG/ AH Columns

image.png

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

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.
AE Column

image.png

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

engine result.png

stf

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

image.png

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

staff list.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.

image.png

Paste only the copied Values ​​without Headings in the columns of the gaiho staff list sheet in the sample bulk sheet

gaiho.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

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

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.
C-K Columns

image.png

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

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.
B- BZ Columns

image.png

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

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.
A /C /E / G /I Columns

image.png

Paste only the copied Values ​​without Headings in the columns of the smeb person in charge cl sheet in the sample bulk sheet

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.

 I /V/W/X/Y Columns

image.png

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

Budget Unit.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

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

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.

Columns A- AD/AE/AG /AH/ AP-AL except for column U/AA 

image.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

Real Estate

From the Real Estate sheet in the sample bulk sheet, copy & paste only the values ​​except the headings in all columns.


Sample bulk sheets

Back to top