Skip to main content

Bulk Sample Sheet Creation

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

image.png

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

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


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


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

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

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

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

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

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

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

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

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

image.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 Collection sheet in the sample bulk sheet

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

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

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

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