Item

Daily Checklist

Scenario 1 : Excel BQ prepared in different elements at different sheets

1

Unmerged & unhide all columns, rows & sheets

2

Remove unnecessary rows & columns for each sheets

3

Checking any Lump Sum item which don’t have qty;

  1. Need to key in Qty as “1”
  2. Need to move Amount to “Rate” column

4

Import into BuildSpace and check the Amount whether tally with Excel file

Scenario 2 : Excel BQ prepared in different Bills at different sheets

1

Click on the “Bill” (sheet)

2

Save as CSV-Comma Delimited format and rename as “Bill No” such as 1

3

Open CSV file

  1. Delete unnecessary columns 

4

Copy to another new sheet

5

Back to first sheet

  1. Delete unnecessary rows such as page total, Cont’ heads & collection pages 
  2. Double check the Lump Sum items which don’t have Qty;
  1. Need to key in Qty as “1”
  2. Need to move Amount to “Rate” column
  1. Delete other elements

6

Back to second sheet;

  1. Delete first element
  2. Copy to another new sheet

7

Repeat step 5 & 6 until complete

8

Save as file into Excel format

9

Import into BuildSpace and check the Amount whether tally with Excel file