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 one by onebelow.

• 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.
ClickB this- linkW for the headingsColumns
Rule

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

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.
ClickY- thisAA link for the headings
HolidayColumns

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

Classification sheet

From the rule sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.
ClickAB/ thisAC/ linkAD/ forAG/ theAH headings
Classification
Columns

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

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.
ClickAE this link for the headings
Engine result
Column

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

this link for the headings
stf

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

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.
Click this link for the headings
advance recording

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

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.
Click this link for the headings
gaiho

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

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
Click this link for the headings
max

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

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.
ClickA- thisAB link/AG for- theAU headings
monthly/ balanceAX - AZ / BD - BF / BI- BL / BW / BX /CM/ CT / CU / DP/ DQ / DW /DX / EA /EB Columns

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

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.
ClickC-K this link for the headings
sp rank
Columns

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

Collection

From the Collection sheet in the original SME Sales result sheet, copy only the values ​​except the headings in the following columns.
ClickB- thisBZ link for the headings
collection
Columns

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

 

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.
ClickA this/C link/E for/ theG headings
/I smeb person in charge cl
Columns

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

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

this

 linkI for/V/W/X/Y the headings
 budget gaiho
Columns

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

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.

Click

H this/AW/AX/AY/AZ link/ forBB the/ headings
budgetBD/BE/BG unit/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

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

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

this

Columns linkA- AD/AE/AG /AH/ AP-AL except for thecolumn headings
notU/AA pay last month 

 Paste only the copied Values ​​without Headings in the columns of the not pay last month sheet in the sample bulk sheet

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.
Click this link for the headings
cumulative performance for curr
(Summary sheet row- 625, column P,Q,R)

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

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.
Click this link for the headings
net increase
(Summary sheet Row 689, 693, column D to R)

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

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.
Click this link for the headings
Summary DDT
(Summary sheet Row 650, 652, 654, 656, 658, column D to G)

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

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.
Click this link for the headings
srr daily win and lose

 

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

Real Estate

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

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

Sample bulk sheets