`
`
`
`
`
`Background
`
`very book has to start somewhere. Tllll chapter stem
`from square one by introducing you to the concept ola
`spreadsheet. Also Included is I lot of Interesting tacky-mind
`information about Excel and “orbital
`
`What is Excel?
`category ofspreadsheets. Enclal i; one of selveral spreadsheet
`mediates that you can run on your PC. fitters Include 1-2-3
`and Quettro Pm.
`
`- MM [including Excel) 1: I highly interactive
`mmpiflerpmgramflafleonstmofacoflecfimotrm and
`columns die-played onscreen In a ecrollehle mallow. The
`Intersection oi each row and wiume 1: allied e cur—it which
`an hold anumber. it text string. or a Ion-null that perform:
`= calculation by using one or more other oella. Coming and
`moungcellaend medlfytog lot-molest: month a.
`
` A Bit ofI hope to explain why in this book.
`
`
`
`- spreadsheet can be served in e file for leter use or discarded
`- erfihuemedlta Intended pup-ase'l'hueflstn a
`-. preeflsheet can be formatted in earloue wear: and printed for
`are-copy reference. 111 addifien. ermine of numerical cells can
`tuned to [meme chute and nape.
`
`-
`
`' ereoetsignifieantadvamageolandeetreoleepreefieheetie
`-t the ioro‘mles recdculete their new“: "we change my of
`I e cells that meyuae. he a result, efleryrou set uproot
`. pleadshget by defining i'ornaulas, you can use this "model“ to
`-
`Iore difiermt poeeihllltlee. with new little eddltlonel effort.
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 1 of 5
`Exhibit 2004/ Page 1 of 5
`
`
`
`
`
`
`E...
`
`I '
`
`prflhnm:
`ruminant:
`
`-
`
`l our-
`
`I.
`
`figur- i-1: The Office Assistant pops up to provide help when needed.
`
`Built-in Functions
`Est-eel includes an enonnous collection of built-in functions that you can use Ln your
`iotrauias. [n auntiilon to common functions. such as SUM and AVEMC-E, you can
`choose Functions that perform sophisticated operations that otherwise are oilflcuit
`or Impossible to do. For example. the CDRREL function calculates the correlation
`coefficient for two sets of data. 1i'ou also can develop other functions by using the
`we. macro language [it's not as dlEfloult as you may think}.
`
`Customirable Toolbars
`Exeel's toolbon— groups ot‘ buttons representlng commends—are real time-Savers.
`enaoung you to perform common commands without. using the menu. 1i'ou can
`customize your toolbars as adding buttons for tasks that you do most often. To find
`out what a button does. drag the mouse over a toolbar button and pause for a
`second. Excel pops up a brief description oi the button.
`
`Beginning with Excel 9?. the menu bar at the top of the screen is actuallyr a toolbar.
`As such. you can easily customize it or even those it to a dlflerent location on the
`SHEER.
`
`lFlexlble Text sansling
`Although Excel'e forte is number crunching. it‘s not too shabby at handling text.
`the can tonnat or orient test that you put in cells. You also can insert text boxes
`
`{which you can mote and resizej anywhere on your worksheet.
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 2 of 5
`Exhibit 2004/ Page 2 of 5
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`
`Excel in the ml}r spreadsheet that enables you Easily tn [cm-nut main-Mun!
`characters mm: a cell. For turnple. if a cell contains bent. 3m nan snake one letter
`
`you tn monthly and nugmnnt a wide assortment net graph types. You can Insert a
`chart anywhere. in amt-lent nrr plant It on a special chart sheet.
`
`Integrated Mapping
`Exnnl's mapplng feature ints you display your data in the form at a anagraphlc map
`{see Figure 1-3}. For mple. ycru can mil}! create an. nfirnflhl'e map that shuws
`you: nomparry’: sales volume by state.
`
`bold war a different cn-lnr. Enters aha-ting {natures — among the best available In any spreadsheet— Enable
`gem-Inland 'M‘I‘J‘l. nnlv n im- mnuse didss.
`
`I
`
`figur- 1-3: This map
`
`'u._.'..'l
`
`I
`
`Drawing Tools
`Eucnl Enduring an “talent set of :irnvnng tool: that ennhles y'nu In create
`ammve dtaa'rams and basic draw-tugs dEI-nclly on your worlnlhnet or chart. Fur
`mph. you can Include a BMW: flow diagram along with your numerical anally-nu.
`
`
`
`
`
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 3 of 5
`Exhibit 2004/ Page 3 of 5
`
`
`
`
`gram -— In cIudlng Excel — is that you can use formulas
`to create dynamic models that instantly recalculate when you
`change values in cells to which the formulas refer. When you
`change 1values in cells in a systematic manner and observe the
`fleets on specific formula cells. you're performing a type of
`teller-if a11alysis.What-it analysis is the process of asking quesa
`tions such asr “What if the interest rate on the loan changes to
`3.5 rather than 9i] percent?“ or “What if we raise the prices of
`our products by 5 percent?"
`
`
`
`'
`
`._:.
`
`
`
`;f--rforming
`readsheet
`
`at-If Analysis
`
`
`One of the most appealing aspects of a spreadsheet pro
`
`
`.r.pjl."--:':~".'-_-..-_--'
`
`
`
`-'-1251-34,4:'-".-_:
`
`
`
`
`ti you set up your spreadsheet properly. answering such ques»
`tions is a matter ol plugging In new values and observing the
`*
`results of the recalculation. Excel provides useful tools to
`
`assist you in your what-[E endeavors.
`
`
`What-If Example
`
`_
`:-§'_'.'_
`
`
`
`--I.r_.|'.-
`
`.
`
`Figure 26-1 shows a spreadsheet that calculates inlorn'iation
`pertaining to a mortgage loan. The worksheet is dltdded into
`two sections: the input cells and the result cells. Column D
`shows the formulas stored in column C.
`
`'t‘.1th this worksheet. you can easilyr answer the inllowlng
`what—if questions:
`
`1* What it] can negotiate a tower purchase price on the
`property?
`
`}rfii
`
`+ 1ails-alt ii the lender requires a Ell-percent down payment?
`4- What III can get a sores:- mortgage?
`
`+ What it the interest rate decreases to 7.5 percent?
`
`
`
`_r'l'"
`is)
`
`+
`
`_"+ ”+1
`
`+
`
`In Wellhew'
`
`_. awn-tat seeps
`
`Types swans;
`Analysis
`
`Manuel What-ti
`firmly-sis ,
`
`Macro-Assisted
`Wh‘et-lthnolysis
`
`.-
`
`-
`
`-
`
`cleanse Dee "tastes
`
`. using Scenario
`Manager
`ScenaridManager I
`-_ Limitohons;
`
`+ es +
`
`
`IPR 2018-00044
`IPR 2018-00044
`Exhibit 2004/ Page 4 of 5
`Exhibit 2004/ Page 4 of 5
`
`
`
`
`' I
`
`gfrom Excel:- Changes inh-ie
`_
`source are rd’leclefl eutori-iaficallyi This asualiy pmdufiés befier ream i
`than the Bin-lap option. Double-click the object after pasting ittoyfl
`—':
`fhe source data in Ekeei.
`:
`A bitmap om thaigehmifiae famethg from ensue. chime '-
`-suurce are refl‘ecteé autum‘afically. Danie-did: ther object afier
`r;
`ittoedittheuurceéa‘kainflcel.
`'
`I
`A table that isfermatted as the en‘ginai Excei range: Use this form:
`when you expect to publish-the docummt as a Web page.
`
`A linked:6pr meapdudes the angel iqqfiamng. 'Duuhlfifick =-
`ohied afterpasting he editthe soqrce age in Excel.
`A Word table that is icrmatted es the
`aigina! Ezra! range. Changs it
`the source ae reflected automatically
`Text (m: a uhlenfiat eprrespunds :1}sz HmmeWe.
`from Excel ismt' hinge-fled. Changes in the seam: aye reflected
`
`2'
`
`[
`
`_-
`
`Miceosifi line!
`Woriisl'eet Ghiert
`Furrnarhed Text
`(RTFJ
`Urifflfl'ratted ”rec;
`
`Picture
`
`Bin-nap
`
`HTML Fame!
`
`._
`
`-.
`
`_
`.
`
`'
`
`+ TExtdocuments fmm ntherproduete: such as wart procrassors
`_ + Drawings or pictures from dher profit-Mt!
`' + Iniemation from special 01E server éfiblieations. filth as Microsoft Equal! Ii}.
`|
`' _+ Sound files
`
`+ Vida: or animationiiies
`
`“I I'
`
`I
`
`E
`
`.
`‘
`
`.
`'. Most of thg major Wind-awe appiiatlans support OLE. Youcan embed an abject inc.
`your document in eithernf two wets:
`
`
`
`
`
`IPR 2018-00044
`PR 2018-00044
`Exhibit 2004/ Page 5 of 5
`Exhibit 2004/ Page 5 of 5
`
`
`
Accessing this document will incur an additional charge of $.
After purchase, you can access this document again without charge.
Accept $ Charge
Still Working On It
This document is taking longer than usual to download. This can happen if we need to contact the court directly to obtain the document and their servers are running slowly.
Give it another minute or two to complete, and then try the refresh button.
A few More Minutes ... Still Working
It can take up to 5 minutes for us to download a document if the court servers are running slowly.
Thank you for your continued patience.
This document could not be displayed.
We could not find this document within its docket. Please go back to the docket page and check the link. If that does not work, go back to the docket and refresh it to pull the newest information.
Your account does not support viewing this document.
You need a Paid Account to view this document. Click here to change your account type.
Your account does not support viewing this document.
Set your membership
status to view this document.
With a Docket Alarm membership, you'll
get a whole lot more, including:
- Up-to-date information for this case.
- Email alerts whenever there is an update.
- Full text search for other cases.
- Get email alerts whenever a new case matches your search.
One Moment Please
The filing “” is large (MB) and is being downloaded.
Please refresh this page in a few minutes to see if the filing has been downloaded. The filing will also be emailed to you when the download completes.
Your document is on its way!
If you do not receive the document in five minutes, contact support at support@docketalarm.com.
Sealed Document
We are unable to display this document, it may be under a court ordered seal.
If you have proper credentials to access the file, you may proceed directly to the court's system using your government issued username and password.
Access Government Site
