Bulk Sample Sheet
Bulk Sample Sheet CreationBG
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
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
Note: The total in the last row should not be copied and pasted in 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.
Y- AA Columns
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.
AB/ AC/ AD/ AG/ AH 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.
AE 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.
A- AM Columns
Paste only the copied Values without Headings in the columns of the stf 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.
S/ CX - DD / DO - DU Columns
Paste only the copied Values without Headings in the columns of the gaiho staff list sheet in the sample bulk sheet
sales result report old
The sales result report old sheet is not in the original SME Sales result sheet. therefore copy only the values except the headings in the following columns from the sample sheet in SRR Upload.
A- AM Columns
Paste only the copied Values without Headings in the columns of the sales result report old 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.
A- AB /AG - AU / AX - 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
Payment list
From the Payment list sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
G-N /Q /Z- AG /AJ/AV-BD Columns
Paste only the copied Values without Headings in the columns of the Payment list sheet in the sample bulk sheet.
Broker
From the broker sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
Columns A-AL except column AA
Paste only the copied Values without Headings in the columns of the broker 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.
C-K Columns
Paste only the copied Values without Headings in the columns of the sp rank sheet in the sample bulk sheet
gs200
From the gs200 sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
A - AW / AS/AT/AU/AV/AW Columns
Paste only the copied Values without Headings in the columns of the engine result sheet in the sample bulk sheet
Call data
From the Call data sheet (200-3-3-1) in the original SME Sales result sheet, copy only the values except the headings in the following columns.
G/H/ M - Q /S/T Columns
Paste only the copied Values without Headings in the columns of the Call data sheet in the sample bulk sheet
M/N/P/Q/R/T/U
AS/AT/AV/AW/AX/AZ/BA/BC/BD/BE/BG/BH/BJ/BK/BN/BO/BP/BQ/BR/BS/BT/BU/BV/BW/
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
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.
A /C /E / G /I Columns
Paste only the copied Values without Headings in the columns of the Collection sheet in the sample bulk sheet
request route
From the request route sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
A/B /D-H/J/M/O/P/Q/R/S/V-Z/AC/AD/AE/AF
Paste only the copied Values without Headings in the columns of the request route sheet in the sample bulk sheet
planBO
From the planBO sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
Columns A-K /M /O- V / W-AE AJ/ AF/AG/AH/AK except for column L
Paste only the copied Values without Headings in the columns of the planBO sheet in the sample bulk sheet
increase list
From the increase list sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
A/B/C/O / Q / AF /AL /AP /AQ / AR /AS Columns
Paste only the copied Values without Headings in the columns of the increase list sheet in the sample bulk sheet
dormant
From the dormant sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
A - AV / BI / BY-CE
Paste only the copied Values without Headings in the columns of the dormant sheet in the sample bulk sheet
ddt0705
From the ddt0705 sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
L / O-V / AC / AI / except for column R/W
Paste only the copied Values without Headings in the columns of the ddt0705 sheet in the sample bulk sheet
ddt0805
From the ddt0805 sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
L/O-Y except for column R/T/W
Paste only the copied Values without Headings in the columns of the ddt0805 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.
I /V/W/X/Y 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.
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
Paste only the copied Values without Headings in the columns of the budget unit sheet in the sample bulk sheet
Sales Plan
From the Daily (Unit) sheet in the original SME Sales result sheet, copy only the values except the headings in the following columns.
Columns - D / I-AL / BG - BL
Paste only the copied Values without Headings in the columns of the sales plan 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.
Columns A- AD/AE/AG /AH/ AP-AL except for column U/AA
Paste only the copied Values without Headings in the columns of the not pay last month sheet in the sample bulk sheet
Sample bulk files can be found at the following link
Sample bulk sheets
No Comments