Masters
Parameters
Test Masters
New Material
Edit Material
Master Equipment
Customers
Rate Master
Inward-Outward
Equipment Movement
Pre- Sales
Inquiry Management
Quotation
Old Quotation
New Quotation
Core
Testing
Create New Job
Requisition (SRF)
Test Result
Report Approvals
Delivery Challan
Old Delivery Challan
Update Delived Details
DispatchedReports
Print - Material Wise
Print - Job Wise
Report -Scan & Store
Store Second Copy
Accounts
Customer Block/Unblock
Promotional Offers
Proforma Invoice
Old Proforma Invoice
Advance Reciepts
Invoice
Old Invoice
Reciept & Adjustment
Old Reciepts
Invoice Report
MIS Reports
Sample Collection report
Planning Report
Job Register
Customers
Proforma Sales
Sales
Collection
Outstanding
Tested Material
Profit & Loss
Customer Wise SOA
Site Wise SOA
Test Wise Order MIS
Site Wise Outstanding (Gross)
Quality Documents
Calibration Status
Administration
User Managment
Taxes
System Properties
Qualcon Laboratories Private Limited
is
Sign out
Mix Calculation Sheet
New Table
×
Manage Mix Table formats
No. Of Rows
No. Of Columns
Table Code
Table Name
Column Ratio
Display on report
Yes
No
Alignment
Save
Guidelines for formula...
To access particular cell in formula: [Table_Code,RowNo,ColNo]
To access test result from other certificate: [#Table_Description,Seq#]. Where Table_Description is the table heading given at the time of recording test results of the test report and Seq is the unique sequence code of the parameter defined in manage parameter. To access this feature you need to insert certificate No. of the reference test report while recording Mix trial results.
To access client Data from the Inward FIR, [$Code$], where code is case sensitive and could be one of the following:
GRADE
, for accessing grade
IDNO
, for accessing Identification number of the sample.
WORKABILITY
, for accessing workability details.
RETENTION
, for accessing retention method.
MIX_DETAILS
, for accessing mix information.
BATCH_NO
, for accessing batch details.
BITUMEN_PERCENT
, for accessing bitument percent.
NO_OF_BOREHOLES
, for accessing number of boreholes.
AVAILABILITY_OF_WATER
, for accessing water availability.
PROPOSED_STRUCTURE
, for accessing propsed structure.
NO_OF_STORIED_OF_BUILDING
, for accessing For accessing number of basements.
NO_OF_BASEMENT_IF_ANY
, for accessing number of basements.
NAME_OF_STRUCTURAL_DESIGNER
, for accessing structural designer.
NAME_OF_ARCHITECT
, for accessing architect
MAKE
, for accessing make of the sample.
Use '`' (key below escape) symbol to for double quotes. for differentiating non numeric value.