Google

Author Topic: Excel (formula)  (Read 8350 times)

0 Members and 1 Guest are viewing this topic.

pig_noypi

  • FARM MANAGER
  • Full Member
  • *
  • Posts: 109
    • View Profile
Excel (formula)
« on: June 15, 2007, 05:07:42 PM »
sir nemo,
             dito ko na lang pala tanung yung problema ko sa excel censya na ngayon ko lang nakita na may topic pala regarding sa software.
              panu po pag calender ang ginamit kong formula instead na number/numeral katulad doon sa excel nyo like sa date ng breeding X 114 days=date of farrowing, yun po bang calendar ay eksakto ang bilang kahit magkakaiba ng bilang sa isang buwan? di may 28, 30, 31 days o puro 30 days lang

salamat po uli
pig_noypi


nemo

  • Veterinarian
  • Administrator
  • Hero Member
  • *****
  • Posts: 7835
    • View Profile
    • swine raising
Re: Excel (formula)
« Reply #1 on: June 15, 2007, 08:09:20 PM »
eksakto po ang bilang ng excel, 114 days siya at bahala na ang software magadjust kapg 30 days lang ang buwan na yun at ang sumunod ay 31 or 28. Basta input mo lang ang date then automatic siya na magbibilang sa kalendaryo.
Merry Christmas...
 To order the swine manual email us at piggery@gmail.com. Sales from the manuals covers for the maintenance of this site


pig_noypi

  • FARM MANAGER
  • Full Member
  • *
  • Posts: 109
    • View Profile
Re: Excel (formula)
« Reply #2 on: June 16, 2007, 06:35:37 AM »
sir nemo,
             anu at panu po yung formula ng calendar pagginamit ko na sa excel? let say : date of breed + 114 days = farrowing date

thank you
pig_noypi

nemo

  • Veterinarian
  • Administrator
  • Hero Member
  • *****
  • Posts: 7835
    • View Profile
    • swine raising
Re: Excel (formula)
« Reply #3 on: June 16, 2007, 10:53:14 AM »
Bale ito po yun formula na ginamit ko    =IF(D7>1,D7+114,"") where as cell D7 ay yung cell kung saan ko ilalagay yun date ng bulog then automatic na mag aadd siya ng 114 days from this specific date para makuha yun farrowing date. So yun formula na yan nakalagay sa ibang cell. Sa example na excel ko ito yung formula na nakalagay sa cell J7 or farrowing date cell.

Bale sa excel na yan lagay mo lang yung date breed/date mated ang araw kelan ang bulog then automatic na siyang magcompute
Merry Christmas...
 To order the swine manual email us at piggery@gmail.com. Sales from the manuals covers for the maintenance of this site

pig_noypi

  • FARM MANAGER
  • Full Member
  • *
  • Posts: 109
    • View Profile
Re: Excel (formula)
« Reply #4 on: September 04, 2009, 05:32:33 PM »
doc,

pls help me anu po formula sa excel paggusto ko malaman ang current age ng isang tao ngayon base sa kanyang birthdate, gusto ko pong malaman ang age nya bay nunber of Year, Month, at day

ex.   Dec. 01, 1980 = birthdate
       Sep. 04, 2009 = current date
-----------------------------------
Year =     Month =       Day =


thanks po

Online23

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Excel (formula)
« Reply #5 on: September 25, 2009, 03:28:58 PM »
try mo ito pare

Code: [Select]
http://www.exceltip.com/st/Working_Out_a_Person's_Age_in_Microsoft_Excel/634.html

nemo

  • Veterinarian
  • Administrator
  • Hero Member
  • *****
  • Posts: 7835
    • View Profile
    • swine raising
Re: Excel (formula)
« Reply #6 on: September 25, 2009, 08:30:27 PM »
thanks for this.

Andami ko din kasi nalalagpasan sa forum....

Yun iba di ko na nababasa dahil natatabunan na.
Merry Christmas...
 To order the swine manual email us at piggery@gmail.com. Sales from the manuals covers for the maintenance of this site

Online23

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Excel (formula)
« Reply #7 on: September 26, 2009, 09:56:37 AM »
no problem ah..

omnicron0312

  • Newbie
  • *
  • Posts: 16
    • View Profile
Re: Excel (formula)
« Reply #8 on: September 30, 2010, 04:23:57 PM »
Doc nemo, pwede po ba mahingi ang excel file?

eto po ang email address: willow.holiday@hotmail.com

maraming salamat po.

laguna_piglets

  • Full Member
  • ***
  • Posts: 246
    • View Profile
    • Laguna Piglets Multiply Site
Re: Excel (formula)
« Reply #9 on: February 06, 2011, 01:08:22 AM »
doc nemo  pwde po pasend sa email namin sa ginagamit nyo pong excel sa recording ng inyong sows... 
mdyo mahina ako sa paggamit ng excel lalo na sa formulating... salamat po
Continuous stocks of piglets
Calamba, Laguna


E-MAIL & ADD us on FACEBOOK:   laguna_piglets@yahoo.com

 

< >

Privacy Policy