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.
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
Rules sheet
From the rule 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
Rule
Note: The total in the last row should not be copied and pasted into 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.
Click this link for the headings
Holiday
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.
Click this link for the headings
Classification
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.
Click this link for the headings
Engine result
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.
Click this link for the headings
monthly balance
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.
Click this link for the headings
sp rank
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.
Click this link for the headings
collection
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.
Click this link for the headings
smeb person in charge cl
Paste only the copied Values without Headings in the columns of the Collection 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 link for the headings
budget gaiho
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 this link for the headings
budget unit
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 link for the headings
not 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
No Comments