create account

Calculates Employee Salary in Query Creation on LibreOffice Base by darsondrew

View this thread on: hive.blogpeakd.comecency.com
· @darsondrew · (edited)
$0.30
Calculates Employee Salary in Query Creation on LibreOffice Base
![canok.png](https://steemitimages.com/DQmfDjdkXyuaJnVnPudq5LeaTx1wLWhDCx5eriVcUY5DQQi/canok.png)

<a href="https://www.google.co.id/search?q=Libreoffice+logo&source=lnms&tbm=isch&sa=X&ved=0ahUKEwip-aKQ08baAhVLro8KHdINB7YQ_AUICigB&biw=1366&bih=662#imgrc=ErK5M0Iu0fo5VM:">Source Image</a>

LibreOffice is a powerful office suite – its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. LibreOffice includes several applications that make it the most powerful Free and Open Source office suite on the market: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector graphics and flowcharts), Base (databases), and Math (formula editing). <a href="https://www.libreoffice.org/discover/libreoffice/">More Information</a>


#### What Will I Learn?
In the video I give an explanation how to looking value in LibreOffice base.

- You will learn to create a Query.
- You will learn how to calculate the employees' daily salary
- You will learn how to calculate the employees' weekly salary
- You will learn how to calculate the employees' monthly salary
- You will learn how to create a new Record
- You will learn how to using `*` Function in calculate a value.

#### What is LibreOffice Database?
LibreOffice Base is a LibreOffice application component that works to create and manipulate a structured database.

Based on LibreOffice's official website, LibreOffice base can be explained as below.
> Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.

#### What is LibreOffice Base Report?
A report is a Writer text document that can show your data in an organized order and formatting. In LibreOffice Base, you have a choice to create a report either manually using drag-and-drop in the Report Builder window, or semi-automatic by following a series of dialogs in the Report Wizard.
<a href="https://help.libreoffice.org/Common/Creating_Reports">Source</a>

Or you can read <a href="https://id.wikipedia.org/wiki/LibreOffice_Base">Wikipedia</a> for more information.

#### Requirements
- System Requirements : Program Install Support Install and Uninstall
- System Requirements : No special requirements.
- OS Support : Windows (XP, 2003, Vista, 7, 8 and 10) GNU/Linux (x86 and x86-64, RPM and DEB based Linux distributions) Mac OS X (x86-64 only)

#### Information
- Website & Download : https://www.libreoffice.org/ 
- Type : Office suite software
- License : MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[9]
- Operating System : Linux, Windows, macOS,[5] FreeBSD, OpenBSD,[6] NetBSD, Android (Viewer)
- Platform : IA-32, x86-64, ARMel, ARMhf, MIPS, MIPSel, PowerPC, Sparc, S390, S390x, IA-64 (additional Debian platforms)[7]

#### Difficulty
Intermediate

#### Description
LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. In the video below, I explain how to calculate a value. you can see the Video i attached below.

#### Little additional explanation
![first.PNG](https://cdn.utopian.io/posts/0881e10addfd81db9fe4eea8490e4de80ce9first.PNG)
In the photo above, I have a Record called "Hourly Wage" whose content is the hourly employee wage.

![second.PNG](https://cdn.utopian.io/posts/e3ff386d391a64ca17d36e41426bb3fc3475second.PNG)
In the photo above, to find the amount of daily salary of the employee, I use the way `Rp.25000 * 12`, Working hours of employees in a day is 12 hours.

![third.PNG](https://cdn.utopian.io/posts/f33e3202078141fca48b96db180b3ebfaabcthird.PNG)
In the photo above, to find the number of employees weekly salary, I use the way `Rp.25000 * 12 * 6`, Working hours of employees in a week is 6 days.

![fourth.PNG](https://cdn.utopian.io/posts/9f0d35c8bc1bb5c2f09de18135cfdc04272ffourth.PNG)
In the photo above, to find the monthly salary amount of employees, I use the way `Rp.25000 * 12 * 6 * 4`, Employee's Working Hours in a Month is 4 weeks.

#### Video Tutorial
https://youtu.be/3Zj_UmzRgTE

#### Curriculum
- <a href="https://utopian.io/utopian-io/@darsondrew/limit-the-record-for-creating-query-on-libreoffice-base">Limit the record for creating Query on LibreOffice Base</a>
- <a href="https://utopian.io/utopian-io/@darsondrew/how-to-looking-for-a-blank-value-and-mark-it-on-libreoffice-base">How to Looking for a blank value and mark it on LibreOffice Base</a>
- <a href="https://utopian.io/utopian-io/@darsondrew/continue-to-grouping-data-report-on-libreoffice-base">LibreOffice Continue to Grouping data Report on LibreOffice Base</a>

- <a href="https://utopian.io/utopian-io/@darsondrew/how-to-create-report-on-libreoffice">How to connect a table to creating Report on LibreOffice Base</a>

However I have made some Video Tutorials how to use Apache OpenOffice, you can see it below :
- <a href="https://utopian.io/utopian-io/@darsondrew/how-to-use-relationship-form-and-table-using-openoffice-base">Apache Open Office learn to create relationship on OpenOffice Base</a>
- <a href="https://utopian.io/utopian-io/@darsondrew/using-mail-merge-on-openoffice-calc">Apache OpenOffice learn to use Mail Merge</a>
- <a href="https://utopian.io/utopian-io/@darsondrew/tutorial-looks-for-the-ceiling-floor-roundup-and-rounddown-values-in-the-openoffice-calc">Apache OpenOffice Formula learning (1)</a>
- <a href="https://utopian.io/utopian-io/@darsondrew/tutorial-looks-for-the-inc-odd-and-trunc-values-in-the-openoffice-calc">Apache OpenOffice Formula learning (2)</a>
- <a href="https://utopian.io/@darsondrew">And if you want to know more of tutorials you can directly see on my profile</a>



<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@darsondrew/calculates-employee-salary-in-query-creation-on-libreoffice-base">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>
👍  , , , , , , , , , , ,
properties (23)
authordarsondrew
permlinkcalculates-employee-salary-in-query-creation-on-libreoffice-base
categoryutopian-io
json_metadata"{"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":14021280,"name":"core","full_name":"LibreOffice/core","html_url":"https://github.com/LibreOffice/core","fork":false,"owner":{"login":"LibreOffice"}},"pullRequests":[],"platform":"github","type":"video-tutorials","tags":["utopian-io","video","tutorial","libreoffice"],"users":["darsondrew"],"links":["https://steemitimages.com/DQmfDjdkXyuaJnVnPudq5LeaTx1wLWhDCx5eriVcUY5DQQi/canok.png","https://cdn.utopian.io/posts/0881e10addfd81db9fe4eea8490e4de80ce9first.PNG","https://cdn.utopian.io/posts/e3ff386d391a64ca17d36e41426bb3fc3475second.PNG","https://cdn.utopian.io/posts/f33e3202078141fca48b96db180b3ebfaabcthird.PNG","https://cdn.utopian.io/posts/9f0d35c8bc1bb5c2f09de18135cfdc04272ffourth.PNG"],"image":["https://steemitimages.com/DQmfDjdkXyuaJnVnPudq5LeaTx1wLWhDCx5eriVcUY5DQQi/canok.png","https://cdn.utopian.io/posts/0881e10addfd81db9fe4eea8490e4de80ce9first.PNG","https://cdn.utopian.io/posts/e3ff386d391a64ca17d36e41426bb3fc3475second.PNG","https://cdn.utopian.io/posts/f33e3202078141fca48b96db180b3ebfaabcthird.PNG","https://cdn.utopian.io/posts/9f0d35c8bc1bb5c2f09de18135cfdc04272ffourth.PNG"],"moderator":{"account":"buckydurddle","time":"2018-04-24T17:53:54.934Z","pending":false,"reviewed":false,"flagged":true},"questions":null,"score":null,"total_influence":null,"staff_pick":null,"config":{"questions":[{"question":"How many substantial concepts does this tutorial address?","question_id":"vtuts-1","answers":[{"answer":"4-5 substantial concepts covered in the tutorial.","answer_id":"vtuts-1-a-1","value":10},{"answer":"2-3 substantial concepts covered in the tutorial.","answer_id":"vtuts-1-a-2","value":7},{"answer":"1 substantial concept covered in the tutorial.","answer_id":"vtuts-1-a-3","value":2},{"answer":"More than 5 substantial concepts covered in the tutorial.","answer_id":"vtuts-1-a-4","value":0}]},{"question":"How informative is the content included alongside the video?","question_id":"vtuts-2","answers":[{"answer":"Exceptionally good text and, when applicable, images for concepts covered.","answer_id":"vtuts-2-a-1","value":20},{"answer":"Thorough text and, if applicable, images for concepts covered.","answer_id":"vtuts-2-a-2","value":18},{"answer":"Minimal text and images.","answer_id":"vtuts-2-a-3","value":10},{"answer":"No or very little text and images.","answer_id":"vtuts-2-a-4","value":0}]},{"question":"Is the video clearly prepared and structured?","question_id":"vtuts-3","answers":[{"answer":"Both the presenter and the video are exceptionally organized, structured and presented","answer_id":"vtuts-3-a-1","value":20},{"answer":"Presenter is prepared and video concepts are structured.","answer_id":"vtuts-3-a-2","value":16},{"answer":"Presenter has moments when he/she seems unprepared and/or the content seems to be unstructured.","answer_id":"vtuts-3-a-3","value":8},{"answer":"Presenter seems unprepared and/or video is unstructured.","answer_id":"vtuts-3-a-4","value":0}]},{"question":"Does the contributor provide supplementary resources, such as code and sample files in the contribution post or a GitHub repository?","question_id":"vtuts-4","answers":[{"answer":"Contributor provided exceptional supplementary resources.","answer_id":"vtuts-4-a-1","value":5},{"answer":"Contributor provided good supplementary resources.","answer_id":"vtuts-4-a-2","value":4},{"answer":"Contributor provided minimal supplementary resources.","answer_id":"vtuts-4-a-3","value":1.5},{"answer":"No supplementary resources were provided.","answer_id":"vtuts-4-a-4","value":0}]},{"question":"How would you describe the sound quality of the video?","question_id":"vtuts-5","answers":[{"answer":"Sound quality is excellent and sounds professionally produced.","answer_id":"vtuts-5-a-1","value":10},{"answer":"The sound is clear and understandable with complimenting background music / sounds.","answer_id":"vtuts-5-a-2","value":8},{"answer":"Low quality of sound and/or mildly distracting background noise.","answer_id":"vtuts-5-a-3","value":3},{"answer":"Distracting background noise and/or very low quality recording.","answer_id":"vtuts-5-a-4","value":0}]},{"question":"Does the presenter speak clearly and is easy to understand?","question_id":"vtuts-6","answers":[{"answer":"Yes, presenter’s speech is highly engaging and professional.","answer_id":"vtuts-6-a-1","value":10},{"answer":"Yes, the voice-over is easy to understand.","answer_id":"vtuts-6-a-2","value":8},{"answer":"Only some of the voice-over was comprehensible.","answer_id":"vtuts-6-a-3","value":4},{"answer":"The voice-over was impossible to understand / not included at all.","answer_id":"vtuts-6-a-4","value":0}]},{"question":"Are the title of the tutorial and the concepts being covered present on the video in text overlay form?","question_id":"vtuts-7","answers":[{"answer":"Title and concepts covered are present in the video at all times in a non-disruptive way.","answer_id":"vtuts-7-a-1","value":5},{"answer":"Title and concepts covered appear temporarily when they are addressed.","answer_id":"vtuts-7-a-2","value":4.5},{"answer":"Only the title is presented and the concepts shown are not addressed in overlay text.","answer_id":"vtuts-7-a-3","value":2},{"answer":"Neither title nor concepts covered are presented in the video text overlay.","answer_id":"vtuts-7-a-4","value":0}]},{"question":"How would you describe the formatting, language and overall presentation of the post?","question_id":"c-1","answers":[{"answer":"The quality of the post is fantastic.","answer_id":"c-1-a-1","value":10},{"answer":"The post is of very good quality.","answer_id":"c-1-a-2","value":7},{"answer":"The post is poorly written and/or formatted, but readable.","answer_id":"c-1-a-3","value":3},{"answer":"The post is really hard to read and the content is barely understandable.","answer_id":"c-1-a-4","value":0}]},{"question":"How would you rate the overall value of this contribution on the open source community and ecosystem?","question_id":"c-2","answers":[{"answer":"This contribution brings great and impactful value, and can be used for applications outside the specific project.","answer_id":"c-2-a-1","value":20},{"answer":"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.","answer_id":"c-2-a-2","value":18},{"answer":"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.","answer_id":"c-2-a-3","value":11},{"answer":"This contribution adds no value to the open source community and ecosystem or the specific project.","answer_id":"c-2-a-4","value":0}]}]}}"
created2018-04-24 10:16:30
last_update2018-04-24 17:54:03
depth0
children2
last_payout2018-05-01 10:16:30
cashout_time1969-12-31 23:59:59
total_payout_value0.248 HBD
curator_payout_value0.053 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length6,286
author_reputation5,566,025,736,606
root_title"Calculates Employee Salary in Query Creation on LibreOffice Base"
beneficiaries
0.
accountutopian.pay
weight1,500
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id51,840,534
net_rshares50,854,740,871
author_curate_reward""
vote details (12)
@buckydurddle ·
@darsondrew I am rejecting this contribution because the level of complexity of your topics is too low. These functions are covered a numerous places throughout the Internet and is easily accessible to the average user. In the future I suggest avoiding functions of these sorts when doing contributions. 

Your future contributions need to focus on UNIQUE functionality of an Open Source project which are not easily learned by the average user. LibreOffice is VERY well documented throughout the Internet. So doing any contributions on a well documented project can be risky. 

If you have a topic you are considering for a contribution you can ask me or any mod for advice before you begin working. 

On another point, much of your text is copied (and sourced) from other websites. We ask that you try to create as much original content as possible for your submissions. 


----------------------------------------------------------------------
Need help? Write a ticket on https://support.utopian.io.
Chat with us on [Discord](https://discord.gg/uTyJkNm).

**[[utopian-moderator]](https://utopian.io/moderators)**
properties (22)
authorbuckydurddle
permlinkre-darsondrew-calculates-employee-salary-in-query-creation-on-libreoffice-base-20180424t180535099z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"}
created2018-04-24 18:05:36
last_update2018-04-24 18:05:36
depth1
children0
last_payout2018-05-01 18:05:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,116
author_reputation101,965,608,464,038
root_title"Calculates Employee Salary in Query Creation on LibreOffice Base"
beneficiaries
0.
accountutopian.pay
weight1,500
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id51,912,033
net_rshares0
@resteemable ·
**Your Post Has Been Featured on @Resteemable!** <br> Feature any Steemit post using resteemit.com! <br> **How It Works:** <br> 1. Take Any Steemit URL <br> 2. Erase `https://` <br> 3. Type `re`<br> Get Featured Instantly & Featured Posts are voted every 2.4hrs <br>[Join the Curation Team Here](https://goo.gl/forms/4sr0InoTxcyPRQSj2) | [Vote Resteemable for Witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=resteemable&approve=1)
👎  
properties (23)
authorresteemable
permlinkre-resteemable-calculates-employee-salary-in-query-creation-on-libreoffice-base-20180424t131643610z
categoryutopian-io
json_metadata""
created2018-04-24 13:16:45
last_update2018-04-24 13:16:45
depth1
children0
last_payout2018-05-01 13:16:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length453
author_reputation711,299,530,826
root_title"Calculates Employee Salary in Query Creation on LibreOffice Base"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id51,867,400
net_rshares-4,452,752,971
author_curate_reward""
vote details (1)