Tinkering Around!


 

This implies as bridge supply voltage decreases even minutely, the o/p voltage increases, almost doubles.

 

 

  1. WITH SENSOR CONNECTED BETWEEN 9B , 7B & 5B
  1. Before connecting sensor, adjust HV to about 2 V. connect sensor and adjust HV pot such that voltage between 9B & 7B is 2 V
  2. Connect meter between B/A 4(+) and B/A6(-) and adjust zero pot such that meter reads zero. If reading is negative, turn zero pot clockwise to increase
  3. The useful meter reading range is from 0 to 1 V
  4. 0 is 0% LEL and 1 V is 100% on which OR LED should light up. Adjust A1 , A2 to light up at 0.2 v and 0.6 v respectively.

 

 

 

  1. Expt2:

VHV =2 V between 9B & 7B

VA1=6.76 V (setpoint for A1 using A1 pot) (voltage at pin 2 of IC5B)

VA2= 6.90 V(setpoint for A2 using A2 pot) (voltage at pin6 of IC5B)

V5B= 1 V (measured) (signal voltage)

Voutput (IC3B pin 7 buffer voltage)= 6.13 V

 

OR setpoint= 7.12 V (pin9 of IC5D)(OR opamp)

Ref voltage for IC3C = 6.2 V (pin4 o/p of IC2)

 

 

13. Typical Repair case of AE-4103

In this card, on pressing READ button, FAULT will come, otherwise, PILOT glows without problem. When bench testing, it was also damaging the sensor, though, in control room rack, sensor was not damaged, but FAULT used to come on pressing read.

Solution

The NOR gate IC CD4001 was malfunctioning. The logic was all ok. However, current was leaking to adjacent gates. Therefore, when read button was pressed, 12 V should appear on the o/p pin of gate, instead 8 V was appearing and voltage at other pins were also changing due to internal current leak inside the IC and subsequent loading of the output (the o/p is designed to source only 6.8 ma of current max). This was varying the control voltage at the SMPS IC , hence high voltages were appearing on the output (instead of set 2 volts) and damaging the sensor. Replaced the IC, card works ok now.

 

 

Modified on by MANOJ CHERUKAT

find out if someone is on or off in 14 days on/off

MANOJ CHERUKAT Tags:  on/off days checker vba 14 excel 5 Comments 404 Views

Often it happens that people at home or office want to know whether a person would be on duty or off duty for planning a work or a function at  home etc. 

This software has been developed using Visual basic for applications (VBA) and runs in MS-Excel. Macros will have to be enabled for the file for this software to work.The software takes two inputs:-

(a) The date when the person has joined the shift ( to be entered in B1 cell)

(b) The date when his availability is to be ascertained. (to be entered in B4 cell)

 

After entering this data, click anywhere on the sheet, the result will be displayed in B7 cell and the full shift schedule starting from the date he has joined the shift to the test date period would be available in cell A10 onwards. Presently this will work for people in 14 days on/off shift.

click_here to download the file! Please note that macros have to be made enabled in order for this to work.

Welker Probe (Automatic Insertion Instrument Regulator IRA-4SS)

MANOJ CHERUKAT 244 Views

Welker Probe (Automatic Insertion Instrument Regulator IRA-4SS)

 Welker probe is a tool to sample gas from a pipeline and to present to the Gas Chromatograph system at specified pressure. It has safety features like a pressure release valve which vents excess pressure in case of wrong pressure setting, thus, saving the expensive Chromatograph equipment.

The details of the  welker probe can be found here. The manual to install and retract the probe can be found here

Welker is fitted on top of the Gas line carrying high pressure gas through a flanged socket with Ball valve . The socket is  welded on the pipeline. The ball valve must never be closed during the operation of the sample probe as significant portion of the probe is inserted into the gas line. closing the valve will damage the probe. The Probe has to be retracted from the line before closing the ball valve.

A write-up with pictures can be found here explaining the working of the probe .

 

Troubleshooting:

  1. Sample pressure drops below the preset value to 20 psi to about 3 psi

One reason is choke in the mesh of seat retainer (15) due to solid particles like chemicals and sludge accumulating. Remove the probe as per the removal instructions, and clean the mesh

 

  1. Sample pressure reduces even if the mesh is clean

This happened once because spring (14) lost its tension, it was not apparent but comparing the height to a new spare spring showed about one turn elongation. The spring was changed and sample pressure returned to 20 psi.

 

Modified on by MANOJ CHERUKAT

Understanding the Fisher 3582 positioner

MANOJ CHERUKAT Tags:  fisher instrumentation positioner 3582 242 Views

Fisher 3 that the travel pin remains perpendicular to connector arm during this process


2. tighten the cap nut and re-check the the arm at mid-travel position, if the zero degree marks don't align, repeat the procedure.

 

(b) For special travel pin setting (when travel pin setting greater than total actuator travel):-


The arm will not rotate 30 degrees in one direction as the valve is stroked and therefore the 30 degree marks will fall short of aligning with case index marks. only 

thing, the 'gap' between the index marks on the case and rotary shaft arm should be same in both directions (i.e., while stroking to 0 and 100%). If gap is not the 

same, adjust the pin position as described above to make it same.

 

3. WORKING


Working is as explained in the video and pg 32 in the datasheet. The valve positioner can be used in direct and reverse options. 


4. BEAM ALIGNMENT

 
The beam is leveled at the factory prior to shipment. Once the beam is leveled, no additional leveling should be required unless the
beam pivot pin or the bellows assembly pivot pin are changed, the bellows assembly or range spring (to increase the range from 3-15 psi to 6-30 psi) are replaced, or 

the valve positioner is changed to split range operation.


Names of important components to understand the Alignment:-
see fig-15 
Rotary shaft arm (), nozzle lock nut (), nozzle (), flapper assembly (), follower assembly locknut(),follower assembly (),bellows assembly locknut(),bellows pivot pin

(),beam pivot pin locknut(), beam pivot pin().

procedure for beam alignment given in pg 29 in datasheet.

 

5. CALIBRATION

procedure for calibration given in pg 31 in datasheet, the procedure in brief is given below:- see the actual pic:- positioner-photo

1. Keep the flapper assy at position 6 on the scale and stroke to 50 % of stem travel. if the stem does not match the 50% range, adjust the nozzle and tighten the 

nozzle lock nut.

2. When valve is stroked to zero and if the actuator does not move to the proper end of travel, loosen the nozzle lock nut and adjust the nozzle for zero.

3. When valve is stroked to 100% and if actuator does not move to proper end of travel, adjust the flapper assembly to higher value on the scale to reach 100% or if 

the actuator is already reaching 100% at a lower signal value (say 90% input),then adjust flapper assy to lower value on the scale.

4. If span is adjusted, then re-check for zero adjustment 

5. The positioner will fully vent or pressurize the actuator to supply pressure at the ends of actuator travel when the positioner is
calibrated correctly. Failure to properly calibrate the positioner may result in reduced seat loading


6. MAINTENANCE

6.1 Changing the range spring (pg 36 in datasheet) see FIG-21

The device can operate for supply pressure 3-15 psi and 6-30 psi. The higer range operation (6-30 psi) can be done by changing the range spring.(pg 36 in datasheet)

6.2 Adjusting the flapper pivot (pg 38 in datasheet) fig-20

If the flapper is touching the support or if need is felt to adjust the flapper, all you have to do is to loosen the two nuts (19C) which are marked by paint, push the 

ear (19K) slightly such that the flapper does not touch the support and tighten the two nuts (19C). For more details, follow instruction in page 38 in datasheet

6.3 Replacing the nozzle O ring (pg 38 in datasheet)

 

Modified on by MANOJ CHERUKAT

Well handing over during shift change using Excel Graphics

MANOJ CHERUKAT 366 Views

Well handing over during shift change using Excel Graphics

                   The changes made to a well like changing the bean size or bypassing the hi-lo valve or even closing the well are generally recorded in the shift register and verbally communicated to the taking-over shift. A small excel application can do this graphically thereby providing  color coded representation of the various activities carried out on the well.

 salient features:-

  1. Database driven, what ever changes are done to a well, are captured in a database which can be queried. MS access database is used as backend.
  2. The excel graphics are driven from the database, so that each time the excel file is opened, it automatically picks the latest changes from the database and same is displayed in the graphics.
  3. Single snapshot view of all the wells with a excel sheet dedicated to one area.
  4. As it is database driven, the database can be web-enabled so that the real time data can be seen at base-office/SAM's end.

Process:-

The person doing the updation does using a form like this:-

https://myspace.ongc.co.in/files/form/anonymous/api/library/720a78d9-3962-4d25-bc90-102c820740bc/document/c54f6af1-2868-41d4-9842-c21b98556291/version/189eb384-4564-45fe-9b99-48f9793ed65f/media/well_status_form.jpg

 

The excel file containing the graphics looks like this:-

https://myspace.ongc.co.in/files/form/anonymous/api/library/720a78d9-3962-4d25-bc90-102c820740bc/document/fcfe71de-601f-4f31-bddc-4f94d59c6102/version/c9493f9c-79e3-4b98-8e6e-5fc5b0e76db9/media/well_status_excel_scr.jpg

This is the legend page for the graphics:-

https://myspace.ongc.co.in/files/form/anonymous/api/library/720a78d9-3962-4d25-bc90-102c820740bc/document/e6e3cee1-68f5-4cc6-98b4-7ead3aa9691e/version/1a84e116-579e-4001-ae74-4291162f9907/media/excel_scr_legend.jpg

 

To try it out:-

  1. Download the access database here:-  https://myspace.ongc.co.in/files/form/anonymous/api/library/720a78d9-3962-4d25-bc90-102c820740bc/document/1cf91514-7a1a-4c74-a2d0-237b64fe30df/version/49f42619-67a2-4f73-bac4-75ccaccb725f/media/well_details.mdb
  2. Then, save it to a convenient location like say C:\test. Avoid locations like mydocuments or desktop.
  3. Open control panel, administrative tools, odbc data sources (32 bit), in system dsn tab, click add , select “driver do Microsoft access (*.mdb) “, click finish, takes you to next page called ODBC  Microsoft access setup.
  4. In Data source name , give well_proj. No other name.  Click on select and browse for your access .mdb file in the directory  you have copied say (c:\test). Click ok to accept.
  5. Now your DSN (data source name) is ready.
  6. Next, download the excel file from here:- https://myspace.ongc.co.in/files/form/anonymous/api/library/720a78d9-3962-4d25-bc90-102c820740bc/document/c35191f4-c356-4f8a-a668-7db9a69386ba/version/c757eeb9-1f33-4136-aeed-dc2c7f0a72ed/media/test_ado.xlsm
  7. Copy it to c:\test. Open the file and enable the macros if it asks you to. Now you can see the graphics. To change a well status, press ctrl +a to launch a form, click on any well, and change its status. Click ok
  8. Now click on another sheet, say LEGEND and click back to the sheet you were viewing, the changes you made to the form would have been updated to the graphics.

 

Learning:-

  1. Updating and manipulating Excel Graphics elements using data stored in Database. The graphic elements like shapes can be manipulated, their text changed, their background colors and orientation changed using code.

 

 

Modified on by MANOJ CHERUKAT

consolidating data from different excel file to a report

MANOJ CHERUKAT 2 Comments 493 Views

Copying data from multiple excel files and integrating into a single excel file with a few clicks

Introduction

Sometimes, there is a requirement of collating information from different excel files into a single report. For example, it can be something like  reading some entries from  a DPR prepared for each day of the month and then collating the information in a single report.  This snapshot can give an executive summary and gives a bird’s eye view of the various trends which may be visibly evident.

 

The figure below shows such a picture, imagine if a hundred files are there, from where the data shown in the positions is to be copy, pasted. The preparation of such reports, say, a monthly report is bit tedious with the user having to open, close, copy, paste multiple entries and which can be error prone, unless multiple level of checking is done.  

 http://myspace.ongc.co.in/files/app/file/69e85663-d020-4d20-83a3-277643d60727

Ideally, if your job involves making such ‘monthly’ reports, then, it is about time you have a system with a frontend user interface which can be used to enter data and prepare reports  and a backend database where the data is stored. However, it requires software development effort to customize and not easily available.

Therefore, the solution presented here would meet the requirement by staying within the excel platform. The solution presented is actually a ‘Macro ‘written in Microsoft Visual basic for application inside the excel environment.

 

Salient Features

A screen-shot of the macro is shown here which can be launched from excel. All the steps are labelled in the screen shot.

http://myspace.ongc.co.in/files/app/file/c1af28c3-7f57-4e71-a9bb-bc2ce1a8b7ed

  1. Enter the drive (Ex, C, D etc) where the files are stored and then double click anywhere on the form.
  2. All the folders contained in the form are listed. Double click on the folder of your interest, the corresponding path is listed in #3 and all the files are listed in #4.  However, folders like C:\users and desktop can’t be accessed. Their content can be copied to any new folder in the drive and then proceed further.
  3. Select the Path in #3 and select the file in #4. Immediately you can see the full path shown in #5.
  4. Enter the starting row of the excel file report in #6. The report will start appearing from this row onwards. For example, we have written 4. The rows above this row, you can put other information like heading etc.
  5. In #7, enter the cell-column pairs separated by comma. For example, if you want to copy an entry from cell B5 to cell B4, from B6 to C4, from D7 to D4, from E7 to E4 and A2 to F4, the cell-column pairs would be written as: b5-b,b6-c,d7-d,e7-e,a2-f

 

Notice, that in the destination cell, only the column# is given (b5-b). The row number remains the same as given in step #4.

 

  1. Click on the filename in #4 and then click #9. Repeat the process with all the files in the folder. all the information would be available in C:\test1\test.xlsx
  2. Now open the directory C:\test1\test.xlsx , the complete information to be copied as per step #5 is available as shown below:-

http://myspace.ongc.co.in/files/app/file/77e1d388-9ac1-47fc-a6c2-abbe4c8ccbd2

The excel file can be downloaded here, copy some source files to a directory in the C drive and then use the application.

http://myspace.ongc.co.in/files/form/anonymous/api/library/720a78d9-3962-4d25-bc90-102c820740bc/document/f9e20874-fcad-4a76-89ff-f2844b31650e/media/anoop_project_generic_version_pub.xlsm

Technical Learning :


1. testing the presence of directory
if len(Dir("C:\test1",vbDirectory)=0 then directory does not exist

2. creating a directory
mkDir("directory_path)

3. checking if a file is there or not
filecheck=Dir("C:\test1\test.xlsx")
if filecheck <> "test.xlsx" then file not there

4. creating an excel file using code

Dim ExcelApp as Excel.Application
Dim ExcelWorkbook As Excel.Workbook
Set ExcelWorkbook = ExcelApp.Workbooks.Add
Set ExcelSheet = ExcelWorkbook.Worksheets(1)
ExcelWorkbook.SaveAs "C:\test1\test.xlsx"

ExcelWorkbook.Close savechanges:=False
ExcelApp.Quit
Set ExcelApp = Nothing
Set ExcelWorkbook = Nothing
Set ExcelSheet = Nothing

5. developed code for detecting and removing space (or any ascii char) in a string

6.developed code for extracting source and destination cells from a combination of source-destination cells seperated by comma and then routing the source cells to source array and destination cells to destination array.

 

 

Modified on by MANOJ CHERUKAT

Working of Fuel Guage

MANOJ CHERUKAT Tags:  guage fuel 4 Comments 354 Views

A fuel guage has two units, the guage in the dashboard and the unit at the tank side as shown in figure. The tank unit is like a Rheostat whose one terminal is connected to ground and the other to the terminal marked T on the Guage. As float position moves downward (tank empty), the resistance becomes low and as float moves upward (full tank), the resistance becomes high. This arrangement  can also be reverse (empty tank-high Resistance, Full tank--> Low resistance).

The battery positive is connected to terminal B on the guage and the ground to  terminal marked ground. 12V and 6V guages exist. 

Two coils at 90 degree orientation are arranged (one between T & G in left to right  and other between T & B  in up -down direction). The pointer is attached to a magnet pivoted at the centre, which rotates as magnetic field generated by coils changes. One coil tries to move the magnet to Full position while the other tries to move the magnet to Empty position. When the magnet rotates,so does the pointer.

In old cars, the B connection is through the ignition key. So, turning the key to on, only shows the fuel level

Troubleshooting:-

Assuming the guage to be type where full tank indicates high resistance, following are trouble-shooting tips

1. Guage Always Reads full.

Disconnect the tank connection. Connect the T terminal to Ground, if the guage should move to empty, indicates good guage and disconnected wire to tank side or disconnected ground wire at tank side. If connecting T terminal to ground does not make the guage go empty, then guage is faulty.

2. Guage Always reads empty

Disconnected B or G terminal at Guage.

image

Document Management System

MANOJ CHERUKAT 227 Views

 A Document management system to catalog various types of reports. System allots a unique serial number based on type of report for easy cataloging of reports. 

Facility to search report based on multiple search parameters like type of report, year of generation, source of generation. Keyword search facility also available.

Sytem made with open-source technologies like PHP running on Apache Web-server and using open-source Post-gre SQL database and running on Debian-6 Linux OS.

Some screen-shots are given below:-image

image

 

 

 

 

 

 

 

 

 

  Seven Thousand Records Catalogued. The area where catalogued records are stored is shown below:-

 image image

 

 

 

 

 

 

 

 

 

An additional Module can scan CD/DVD and ingest all file names in a database. A unique serial number generated for CD/DVD for easy retrieval and identification. Search can identify a particular file stored in the soft-copy form in the CD/DVD.

 

Modified on by MANOJ CHERUKAT

Optical Fibre Cabling

MANOJ CHERUKAT 241 Views

1. For cabling involving trenching through GI, ensure before making estimates and BQ stage that the required dia pipe can be threaded for making connections etc. Local markets and plumbers generally have 1 inch die for threading 1 inch pipes.

2. GI Pipes come in classification of class A , B, C etc depending on quality. marked by  YELLOW, BLUE and RED  bands on the pipe in increasing order of pipe guage. Choose wisely.

3. Splicing Pigtails is easier and require less skill than fitting LC connectors onto optical fibre

 

 

SE/LVD/HVD SCSI and how to diffrentiate

MANOJ CHERUKAT 261 Views

Quick reference

SE-> Single Ended SCSI

HVD-> High Voltage Differential

LVD-> Low Voltage Differential

 

The voltage between the DIFFSENSE pin (#16) and Ground Pin (pin 50) can give an idea about the SCSI type from the SCSI peripheral under test. In a 68 pin SCSI Female connector, Pin # 16 is DIFFSENSE ( in HVD and LVD/MSE devices, whereas it is ground in SE devices)

For differentiating between  devices :-

measure voltage between pin #50 (GND) and pin # 16

If voltage > 2.4 volts, then it is HVD.

If  voltage < 0.5 V, it is SE

If 0.7 v < voltage < 1.9 v, it is LVD/MSE

 

The 50 pin Amphenol Male connector (centronics type) has pin #11 as Diffsense and Pin #16 as ground. (for M4 9 track drives round-reel)

Reading 9 track tape drive

MANOJ CHERUKAT 210 Views

Oh legacy! 

1. First set the block size to variable 

mt -f /dev/stx setblk 0

2. rewind the tape

mt -f /dev/stx rewind

 

3. copy the files using input block size =512 (still don't know how to find out the ibs? any idea?)

dd if=/dev/stx of=/myfate ibs=512 count=3 // imagining a file to be occupying 3 blocks of 512 bytes. write a loop to copy all files.

 

 

 

Tape Rewinds on Read

MANOJ CHERUKAT Tags:  tape san rscn 3592e05 2 Comments 232 Views

A 3592E05 drive using the dual ports  is connected as shown:-

image

The problem encountered was that each time a read job was fired to the tapedrive from the workstation, the tape used to rewind itself after copying a few files. Upon removing the connection to the SAN switch to the tape drive, the copy job completed without any problem.

Diagnosis : RSCN (Redundant State Change Notification) propogating in the SAN was rewinding the tape drive.The problem was due to addition of tape drive to the the SAN without 'zoning'. Zoning restricts such 'broadcast' events.

Solution: Opened the SAN switch through Cisco works, no zone found between the server and tape drive. Created a zone between the server and tape drive and reconnected the cables.   Fired the copy job and everything worked as it should work.

Lesson: Don't put orphaned tape drives on the SAN.

Resurrecting Old SGI workstations to run Linux

MANOJ CHERUKAT 2 Comments 267 Views

Reuse of SGI O2

1. Introduction

 

4.9 DATABASE BACKUP

 

PostgreSQL provides a utility called pg_dump to create a full backup of the database.

 

# pg_dump web filename.bkp

 

 

This command backs up the web database to filename.bkp. This is all that is required to regenerate the complete database and its table structure and the data.

 

 

5. SHIFT ALLOWANCE CALCULATION SYSTEM

 

To put the database deployed on SGI O2 to test, we developed a small application to calculate shift allowance of the shift personnel manning the 24X7 shift in the data centre.

The application was written in classic asp and used the database setup above using ODBC to connect to it.

 

 image

 

The shift personnel had to login to the system and mark the shift he was performing. (morning, evening or night)

 

image 

 

 

 

 

 

 

At the end of a shift schedule, a complete report can be obtained by three mouse clicks for the all the operations personnel which results in saving a lot of time and effort compared to manually making an excel sheet.

 

 

 

 

 

 

 

 

 

 

 

 

 

image 

 

Fig: Consolidated statement of shifts performed by personnel of CS(H/w)-GEOPIC

 

6. ICECAST STREAMING SERVER4

 

A streaming server is a server which streams music and audio content over a network. The setup below shows how streaming server works:-

 image

 

 

 

The ICES player, icecast2 and Apache webserver all run on a single O2. The client on the network can connect to the webserver on port 8000 using a web-browser. This opens the icecast interface and clicking on a playlist can listen to streaming music over the network

This plays in standard media players like vlc or winamp.

image 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Fig: ICECAST2 interface

  

7. Conclusion

 

It has been our endeavor to illustrate that old workstations can be reused for scaled down and custom applications. These applications run smoothly within the available limited computing resources. Besides, these workstations can be used very effectively for imparting training on linux and its applications to students.

Modified on by MANOJ CHERUKAT

    • 1