What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

Recent content by dreadstar

  1. D

    PLDT Prepaid Home WIFI

    Guys ano bang for the buck ngayon pldt / smart prepaid wifi promo best for online schooling ng mga bata? TIA
  2. D

    Abs-cbn tv plus

    Re: ABS CBN Tv Plus No CNN Philippines yet?
  3. D

    anong best OS sayo?

    Linux mint user here
  4. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. If I supplied only the goods without service (installation) then the ewt is 1%. I will issue a Sales Invoice and you will give me a 2307 representing the deducted 1% tax. If I supplied both goods and service...
  5. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @romcel11 Thank you! Your solution works great. I just had to improve on it using a Nested IF for a 4 item drop down menu (improved your 2 items list menu). Yes the Total represents the whole purchase order. Different...
  6. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. Thank you for the help. No I dont need this ASAP. If you look at the attached file, I can put a value for TOTAL and excel would compute the other 3 variables (BASE, VAT and EWT) automatically. However, take for example...
  7. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. Not sure what circularly referenced means but only one variable (out of the 4) should a value be inputed and the excel sheet should compute the other 3 variables. Yes these are procurement prices. Normally I have the...
  8. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. Question mga masters. I have this accounting formula that I want to input into excel. Total = Base + VAT wherein the formulas are: Total = Base + Basex0.12 Base = Total / 1.12 VAT = Basex0.12 EWT = Basex0.02 Normally...
  9. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @themonyo Thanks! Hopefully hopefully some others may give another way / option.
  10. D

    true power of MS excel. update: PowerBI

    Re: MS excel reportings, presentations, and vba helping thre Need help again from the awesome guys here. Attached sample file below. Just want to do some simple automation. In the "Clear Row?" field, if I enter "Y", I want it to clear the data of the next 4 cells in the same row. Can this...
  11. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @themonyo and @puuts Thank you so much! Both your suggestions worked great! :praise:
  12. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. @puuts Thank you for the quick reply and assistance. Attached is the requested sample file (simplified since I have over a hundred entries). On the OCT sheet I would like to enter a new entry for the date Oct 12. Its...
  13. D

    true power of MS excel. update: PowerBI

    Re: MS excel formula, programming, analysis, presentation and tutorials. Need help po on an excel project. I have an excel file I use as a bookkeeping journal of my startup company's VAT reporting to BIR every month. The columns I have are date, TIN, company_name, address1, address2...
  14. D

    ACCOUNTANCY! - The OFFICIAL THREAD -

    Any bookkeeping app for andoid phone anyone can recommend for the monthly VAT reportings? Lahat kasi sa play store cannot handle VAT. On the phone most of the time hence its more practical to find a mobile app altho I am currently using an excel sheet sa computer.
  15. D

    Computer repair (post your pc problems) we can help you

    Looking for printer technician mandaluyong area near SM Light Mall. Need to service and reset epson T13 printer.
Back
Top Bottom