TAGS

Recent Posts

Archives

Your Complete Guide to Data Entry Shortcuts in Oracle Planning and Budgeting Cloud Service (PBCS)
Posted on February 7, 2018
Author: Garrett Buckley, Performance Architects

Data entry is a laborious and time-consuming activity, pervasive throughout virtually every company’s planning and budgeting cycles. Users entering data via simple forms in Oracle Planning and Budgeting Cloud Service (PBCS) can utilize the following shortcuts to save time during the data entry process. Simply enter one of the following commands in the desired data cell and press “Enter” on your keyboard. It is important to note that these commands are only available when accessing simple forms via web browser and are not supported in Smart View.

K
Entering the “K” command in a data cell will take the preceding cell value and convert it into thousands.
Example: “7K” = 7,000 

M
Entering the “M” command in a data cell will take the preceding cell value and convert it into millions.
Example: “7M” = 7,000,000

“Add” or +
Entering the “Add” or + command in a data cell will take the preceding cell value and add the number you enter to it.
Example1: “100Add70” = 170
Example2: “100+70” = 170

“Sub” or ~
Entering the “Sub” or ~ command in a data cell will take the preceding cell value and subtract it by the number you enter.
Example1: “100Sub10” = 90
Example2: “100~10” = 90

“Percent” or “per”
Entering the “Percent” or “per” command in a data cell will take the preceding cell value and multiply it by the percentage you enter.
Example1: “100Percent10” = 10
Example2: “100per10” = 10 

“Increase” or “inc”
Entering the “Increase” or “inc” command in a data cell will take the preceding cell value and increase it by the percentage you enter.
Example1: “200Increase10” = 220
Example2: “200inc10” = 220 

“Decrease” or “dec”
Entering the “Decrease” or “dec” command in a data cell will take the preceding cell value and decrease it by the percentage you enter.
Example1: “200Decrease10” = 180
Example2: “200dec10” = 180

“Power” or “pow”
Entering the “Power” or “pow” command in a data cell will make the number you enter an exponent of the preceding cell value.
Example1: “100Power2” = 10,000
Example2: “100pow2” = 10,000 

“gr”
Entering the “gr” command in a data cell will take the preceding cell value and grow it by the percentage you enter.
Example: “200gr50” = 300

Have any other shortcuts that might benefit others in the PBCS community?  Please leave a comment below with your suggestions!

Share
© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Leave a Reply

Your email address will not be published. Required fields are marked *