Saturday, September 19, 2009

Thursday, September 17, 2009

Sunday, September 6, 2009

Functional Specification

Mac Personal Care Product Private Ltd

we are Ahmadabad based sales agency of Mac personal care private ltd. We have sale team of 20 person and sales over product in main cities of Gujarat.

Our products are...

  • Herbal soap
  • Shampoo
  • Toothpaste
  • Face-wash
  • Skin cream
At present we are using phone to place order now we want to make it online.

Our requirements are...
  • There should be log in screen so only authorized person can put order
  • Order form should be design that so it cover all info about retailer(e.g. name, address, phone no) and also about order(e.g. product, quantity, price, ordered date, due date).
  • Stock form contain list of all good and it automatically update inventory as order is placed
  • Stock form can be updated daily by area manager
  • If order is more than inventory than it should not accept order and this out of stock condition should be mailed to Ahmadabad office.
  • Report can be generated every month
  • All products are available only in one quantity pack

Thursday, August 27, 2009

Example-19

Zoho Assignment(Netsalary)

here netslary=salary+comm-tax
tax taken 15%

Zoho Assignment(concat)

here firstname and lastname join to get fullname by using concate function

Zoho assignment(join)

here first column indicate name of employee and second shows corresponding manager

Zoho Assignment(group concat)

Zoho Assignment(maths function)

here functions like sum, avg, min, max, count are used

Thursday, July 23, 2009

Wednesday, July 22, 2009

Future Clinic

Now a days, India is suffering from low density of medical treatment centers. Though there are many health-care centers have been set up, there are still many difficulties in providing quality medical treatment. Medical treatment should be hand reach service to form a healthy society.

Technology can be useful to complete this objective. Many researches are going on and one of the solution is concept of virtual check up center. It is equipped with video conference equipment, some medical devices and a nurse. This nullifies the time and money required in traveling of both patient as well as doctor. The biggest advantage is that specialized doctors would be available at anytime anywhere. We hope to see this dream come true soon.