Results 1 to 2 of 2

Thread: Weightometer Calibration

  1. #1
    SELECT person.id, person.forumCount, person.blogCount, person.publicationCount, job.position AS position, company.id AS companyId, cn.title AS company, cn.suffix AS companySuffix, company.eDirId AS eDirId, profileQuality, name.prefix, name.firstName, name.middleName, name.lastName, name.suffix, IF(ISNULL(cimage.image_id) OR ISNULL(b.expirationDt), 3, cimage.image_id) AS cImageId, IF(ISNULL(image.image_id), 1, image.image_id) AS imageId, IF(EXISTS (SELECT startDate FROM job j WHERE j.person_id = person.id AND ISNULL(deleted)), PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM (SELECT startDate FROM job j WHERE j.person_id = person.id AND ISNULL(deleted) ORDER BY startDate ASC LIMIT 1))), 0) AS experience, (SELECT SUBSTRING_INDEX(GROUP_CONCAT(title ORDER BY (tag_map.forumCount+tag_map.blogCount) DESC, (tag.forumCount+tag.blogCount+tag.searchingCount+tag.knowhowCount+tag.interestsCount+tag.organisationsCount) DESC),",",3) FROM tag_map LEFT JOIN tag ON tag.id = tag_id WHERE person_id = person.id AND TYPE = "searching" AND ISNULL(tag_map.deleted)) AS searchingTitles, (SELECT SUBSTRING_INDEX(GROUP_CONCAT((tag_map.forumCount+tag_map.blogCount) ORDER BY (tag_map.forumCount+tag_map.blogCount) DESC, (tag.forumCount+tag.blogCount+tag.searchingCount+tag.knowhowCount+tag.interestsCount+tag.organisationsCount) DESC),",",3) FROM tag_map LEFT JOIN tag ON tag.id = tag_id WHERE person_id = person.id AND TYPE = "searching" AND ISNULL(tag_map.deleted)) AS searchingCounts, (SELECT SUBSTRING_INDEX(GROUP_CONCAT(title ORDER BY (tag_map.forumCount+tag_map.blogCount) DESC, (tag.forumCount+tag.blogCount+tag.searchingCount+tag.knowhowCount+tag.interestsCount+tag.organisationsCount) DESC),",",3) FROM tag_map LEFT JOIN tag ON tag.id = tag_id WHERE person_id = person.id AND TYPE = "knowhow" AND ISNULL(tag_map.deleted)) AS knowhowTitles, (SELECT SUBSTRING_INDEX(GROUP_CONCAT((tag_map.forumCount+tag_map.blogCount) ORDER BY (tag_map.forumCount+tag_map.blogCount) DESC, (tag.forumCount+tag.blogCount+tag.searchingCount+tag.knowhowCount+tag.interestsCount+tag.organisationsCount) DESC),",",3) FROM tag_map LEFT JOIN tag ON tag.id = tag_id WHERE person_id = person.id AND TYPE = "knowhow" AND ISNULL(tag_map.deleted)) AS knowhowCounts FROM person LEFT JOIN name ON (person.id = name.person_id AND ISNULL(name.deleted)) LEFT JOIN job ON (person.id = job.person_id AND job.main = 1 AND ISNULL(job.deleted)) LEFT JOIN `com_bulk-online_edir`.company ON (company.id = company_id) LEFT JOIN `com_bulk-online_edir`.name cn ON (company.id = cn.company_id) AND cn.type = "main" AND ISNULL(cn.deleted) LEFT JOIN `com_bulk-online_edir`.image_company_map cimage ON (company.id = cimage.company_id AND ISNULL(cimage.deleted)) LEFT JOIN `com_bulk-online_edir`.balance b ON b.id = (SELECT id FROM `com_bulk-online_edir`.balance WHERE company_id = company.id AND expirationDt > NOW() ORDER BY insertedDt DESC LIMIT 1) LEFT JOIN image_person_map AS image ON (person.id = image.person_id AND image.type = "person" AND ISNULL(image.deleted)) WHERE person.forum_userId = "14551" LIMIT 1;

    Weightometer Calibration

    Hello All,

    I require your help with weightometer calibration through bulk testing. I want to install a mechanism that will manipulate the conveyor belt to off-load material while performing the bulk test. A system of cylinders and controls would be ideal. Need help with picturing the concept.

    What I require is some ideas on were to start. pictures, websites and design manuals.

    Thanks all for the help.

  2. #2
    SELECT person.id, person.forumCount, person.blogCount, person.publicationCount, job.position AS position, company.id AS companyId, cn.title AS company, cn.suffix AS companySuffix, company.eDirId AS eDirId, profileQuality, name.prefix, name.firstName, name.middleName, name.lastName, name.suffix, IF(ISNULL(cimage.image_id) OR ISNULL(b.expirationDt), 3, cimage.image_id) AS cImageId, IF(ISNULL(image.image_id), 1, image.image_id) AS imageId, IF(EXISTS (SELECT startDate FROM job j WHERE j.person_id = person.id AND ISNULL(deleted)), PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()), EXTRACT(YEAR_MONTH FROM (SELECT startDate FROM job j WHERE j.person_id = person.id AND ISNULL(deleted) ORDER BY startDate ASC LIMIT 1))), 0) AS experience, (SELECT SUBSTRING_INDEX(GROUP_CONCAT(title ORDER BY (tag_map.forumCount+tag_map.blogCount) DESC, (tag.forumCount+tag.blogCount+tag.searchingCount+tag.knowhowCount+tag.interestsCount+tag.organisationsCount) DESC),",",3) FROM tag_map LEFT JOIN tag ON tag.id = tag_id WHERE person_id = person.id AND TYPE = "searching" AND ISNULL(tag_map.deleted)) AS searchingTitles, (SELECT SUBSTRING_INDEX(GROUP_CONCAT((tag_map.forumCount+tag_map.blogCount) ORDER BY (tag_map.forumCount+tag_map.blogCount) DESC, (tag.forumCount+tag.blogCount+tag.searchingCount+tag.knowhowCount+tag.interestsCount+tag.organisationsCount) DESC),",",3) FROM tag_map LEFT JOIN tag ON tag.id = tag_id WHERE person_id = person.id AND TYPE = "searching" AND ISNULL(tag_map.deleted)) AS searchingCounts, (SELECT SUBSTRING_INDEX(GROUP_CONCAT(title ORDER BY (tag_map.forumCount+tag_map.blogCount) DESC, (tag.forumCount+tag.blogCount+tag.searchingCount+tag.knowhowCount+tag.interestsCount+tag.organisationsCount) DESC),",",3) FROM tag_map LEFT JOIN tag ON tag.id = tag_id WHERE person_id = person.id AND TYPE = "knowhow" AND ISNULL(tag_map.deleted)) AS knowhowTitles, (SELECT SUBSTRING_INDEX(GROUP_CONCAT((tag_map.forumCount+tag_map.blogCount) ORDER BY (tag_map.forumCount+tag_map.blogCount) DESC, (tag.forumCount+tag.blogCount+tag.searchingCount+tag.knowhowCount+tag.interestsCount+tag.organisationsCount) DESC),",",3) FROM tag_map LEFT JOIN tag ON tag.id = tag_id WHERE person_id = person.id AND TYPE = "knowhow" AND ISNULL(tag_map.deleted)) AS knowhowCounts FROM person LEFT JOIN name ON (person.id = name.person_id AND ISNULL(name.deleted)) LEFT JOIN job ON (person.id = job.person_id AND job.main = 1 AND ISNULL(job.deleted)) LEFT JOIN `com_bulk-online_edir`.company ON (company.id = company_id) LEFT JOIN `com_bulk-online_edir`.name cn ON (company.id = cn.company_id) AND cn.type = "main" AND ISNULL(cn.deleted) LEFT JOIN `com_bulk-online_edir`.image_company_map cimage ON (company.id = cimage.company_id AND ISNULL(cimage.deleted)) LEFT JOIN `com_bulk-online_edir`.balance b ON b.id = (SELECT id FROM `com_bulk-online_edir`.balance WHERE company_id = company.id AND expirationDt > NOW() ORDER BY insertedDt DESC LIMIT 1) LEFT JOIN image_person_map AS image ON (person.id = image.person_id AND image.type = "person" AND ISNULL(image.deleted)) WHERE person.forum_userId = "215" LIMIT 1;
    Would it not make more sense to simply stop the material from coming onto the belt during the calibration.

    We simply stop the feed, let the material on the belt clear past the scale, stop the belt and hang a set of calibration weights on the scale frame to calibrate. Then start the belt and calibrate the scale and reverse the process and start up again.

    What method of calibration are you using?

Similar Threads

  1. Draft Survey vs Weightometer vs Weighbridge
    By Author in forum Bulk Ports & Shipping
    Replies: 8
    Last Post: 7th July 2013, 5:17
  2. XRF Calibration
    By vladimirnikolic in forum Research & Development
    Replies: 0
    Last Post: 29th December 2005, 12:52
  3. Filter Calibration Standards
    By Author in forum New Products, New Orders
    Replies: 0
    Last Post: 21st October 2005, 13:28
  4. Calibration of Particle Analyzer
    By yossi in forum Particle Characterization & Analysis
    Replies: 1
    Last Post: 27th March 2005, 18:24
  5. Draft Survey vs Weightometer vs Weighbridge
    By Author in forum Weighing, Dosing & Proportioning
    Replies: 0
    Last Post: 21st April 2002, 20:24

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Single Sign On provided by vBSSO