searchindex.js

Search.setIndex({docnames:["AnalyzeCategory","Copyright","Definitions","Functions","Generalfeatures","Introduction","Knownissues","ModelCategory","PlanCategory","SimulateCategory","Storage and Collaboration","index","valQ"],envversion:{"sphinx.domains.c":1,"sphinx.domains.changeset":1,"sphinx.domains.citation":1,"sphinx.domains.cpp":1,"sphinx.domains.javascript":1,"sphinx.domains.math":2,"sphinx.domains.python":1,"sphinx.domains.rst":1,"sphinx.domains.std":1,sphinx:56},filenames:["AnalyzeCategory.rst","Copyright.rst","Definitions.rst","Functions.rst","Generalfeatures.rst","Introduction.rst","Knownissues.rst","ModelCategory.rst","PlanCategory.rst","SimulateCategory.rst","Storage and Collaboration.rst","index.rst","valQ.rst"],objects:{},objnames:{},objtypes:{},terms:{"break":4,"case":[4,7,8],"default":[3,4,7,8],"export":[4,10],"function":[7,9,11],"import":4,"new":[4,8,10,11],"null":7,"return":[3,4,7],"switch":[3,4],"true":3,"while":8,ABS:3,Adding:7,But:7,Eye:7,For:[4,7,8],NOT:3,One:4,Ops:7,Such:4,The:[0,1,2,3,4,6,7,8,9,10,12],There:[4,7,8],These:[4,7],Using:[7,8],With:[0,4,7,8],Yes:7,abbrevi:7,abil:0,abl:[0,4,7,8,12],about:[2,5,11],abov:[2,4,7,8,12],absolut:[0,3,7,8],accent:7,accept:3,access:[4,6,10],accompani:1,accord:7,account:7,accur:1,achiev:[4,7],across:[0,8,10],act:3,action:[7,8],activ:[4,7],actual:[4,7,8],add:[3,7,8,10],added:[4,6,7],adding:7,addit:[2,4,8,10],adjust:[4,8],ads:7,advanc:[0,4,10],affect:4,after:[4,7,8,10],again:8,against:[3,7],aggreg:[4,8],alert:7,all:[0,1,3,4,7,8,10],all_period:3,alloc:11,allow:[0,3,4,7,10],along:[7,8,10,12],alreadi:[7,9],also:[0,3,4,7,8,10],altern:7,alwai:7,amber:7,among:4,amount:[4,8],analys:[0,4,5],analysi:[10,11],analyz:[11,12],ani:[1,3,4,6,7,8],anoth:[1,3,7,10],anywher:4,app:[4,5],appear:[4,7,8],append:8,appli:[4,7,8],applic:1,appropri:[0,7,8],apr:[5,7,8],april:8,area:[4,7],argument:3,arithmet:3,around:4,arrai:3,arrow:[4,7],ascend:7,ask:4,aspect:4,assign:7,assum:[4,10],assumpt:[4,7],attent:4,audit:10,aug:5,august:4,authent:10,automat:7,avail:[4,7],averag:[3,4,7],averageexneg:3,averageexzero:3,averageexzeroneg:3,axi:4,back:[4,7,8],background:7,bad:7,band:7,bar:[4,7,8],base:[0,3,4,7,8],baselin:[3,4,7,10],baslin:10,becaus:8,becom:[4,7],been:[0,1,4,6,7,8,9,10],befor:[7,8],begin:7,beginn:7,being:[4,7],below:[0,2,4,5,6,7,8,9,12],benchmark:[2,7],better:4,between:[0,1,3,7,10],beverag:7,beyond:4,billion:7,blog:[4,7],blue:4,bold:7,book:1,borrow:7,both:[0,4,7],bottom:4,box:7,branch:4,brows:7,budget:[4,5,7,11],build:7,busi:[2,5],button:[4,7,8],cab:7,calc:7,calcul:[2,3,4,7,8],call:[4,7],can:[0,2,3,4,5,7,8,9,10],canada:7,cannot:[0,7],canva:[4,9,10],capabl:4,capac:4,captur:[7,10],care:[2,5],cascad:7,cash:3,categor:7,categori:[3,7,12],cell:8,certain:[4,8],chang:[1,2,3,4,5,7,8,10],charact:7,chart:[4,7],check:[3,4,7],checkbox:0,child:[7,8],children:[2,3,4,7,8],choic:[4,7],choos:[0,4,7,8],chosen:8,chri:10,chronolog:10,cleric:1,click:[0,4,7,8,10],close:4,cmprinc:3,collabor:11,collaps:[7,11],collect:[2,4],color:4,column:[4,7,8],com:[4,7],comma:7,comment:[8,10],common:[4,7,9],compani:[1,4],compar:[0,4,5],comparison:[3,4,7,8,10],complet:[4,7,8],complex:[3,4],compon:[4,11],composit:7,compound:4,concept:4,conceptu:[2,5],concurr:7,condit:3,conduct:11,configur:[4,8],confirm:7,conjunct:4,connect:10,connector:7,consid:7,consist:4,constant:[3,4,7,8],constraint:[7,11],consum:4,consumpt:4,contain:[1,4,7],content:[7,11],context:[4,8],contextu:11,continu:7,contribut:4,convert:7,copi:[4,7,8,10],copper:7,copyright:11,corner:[4,8],correspond:[3,7,8],cost:[2,4,7,8],count:[3,7],countri:1,creat:[0,3,4,8,10],credenti:10,criteria:7,critic:4,csv:10,cumipmt:3,cumprinc:3,cumul:[3,4,7],current:[3,4,5,6,7,8],current_period_index:3,current_seri:3,current_series_id:3,curser:4,custom:[0,7,9,12],dark:7,data:[0,8,10,11],datasourc:8,date:[4,5],dec:[7,8],decemb:[4,8],decid:[7,8],decim:7,decor:7,decreas:7,dedic:10,defin:[4,7],definit:[4,11],delet:[4,7,8,10],delta:8,demo:[4,7],denot:[4,7,9],depart:4,depend:4,deriv:[2,7],descend:7,describ:4,descript:[3,4,6,7],design:[1,4,7],desir:[4,7],desktop:10,detail:[4,7,8,12],deviant:7,devic:[4,6],diagram:4,did:4,diesel:4,differ:[0,4,7,8,9,12],differenti:7,dimens:7,direct:4,directli:[2,4,7,8],disabl:7,discount:3,displai:[0,8,10,11],divid:7,document:[1,4,6,11],doesn:[4,6],don:4,done:[4,7,9,10],dot:4,doubl:[7,8],down:[0,7,11],download:[0,4,7,10],drag:[4,7],drill:11,driver:[2,5,7,9,11],drop:[0,4,7],dropdown:7,dual:7,dure:7,dynam:4,each:[4,7,9],edit:[4,7,8],editor:[4,8],effect:7,effici:5,effort:1,eginn:7,either:[0,4,8],electron:1,element:7,els:4,empti:[7,8],enabl:[6,7],end:[4,7,8],end_index:3,end_period:3,ensur:[1,6,8],enter:[7,8],entir:[4,7,8,10],entri:7,equal:8,equat:4,equival:4,error:1,etc:4,evalu:3,even:6,everi:[1,4],exactli:7,exampl:[4,7,8],excel:[0,3,4,10],except:7,exclud:3,exclus:3,exist:[4,7,8,10],exit:7,exp:3,expand:[7,8,11],expens:7,experi:3,explain:[7,9],explan:3,explor:7,expos:7,express:[1,3,4],extend:7,extract:4,factor:4,fall:7,fals:3,fast:4,favor:[4,7],featur:[0,7,9,10,11],feb:7,fed:10,field:[0,7,12],figur:[4,7,8,9,12],file:[0,4],fill:7,filter:[0,7,8,11],financ:7,find:[4,7],first:[3,4,7,10],fiscal:7,five:7,fix:[4,8],flow:[3,7],focu:4,focus:4,follow:[4,7],font:[4,7],footer:[7,8],foreach:3,forecast:[4,5,7,8],foreign:1,form:[1,7,8],format:[1,4,8],formula:[4,7],four:12,friendli:3,from:[3,4,8,10,12],fuction:3,fuel:4,full:[4,7,8],further:[4,7,8,10],futur:[3,4,7],gain:4,gener:[2,9,10,11],get:[3,7,8,11],given:[3,4,7],global:7,going:[4,5],good:7,grain:4,graph:7,green:[4,7],grei:4,grid:7,gross:7,growth:[4,7],guess:3,guid:[4,11],half:4,hand:4,has:[0,1,4,6,7,8,9,10,12],have:[4,7,8],header:7,held:1,help:[7,10,11],henc:7,here:[4,7],herein:1,hidden:7,hide:[4,7],hierarchi:[2,4,7,8],higher:4,highlight:[4,7,8],hint:7,his:7,histori:[10,11],hit:4,hold:[4,8],horizont:7,hour:[4,7],hover:[4,7],how:[4,7],howev:[0,4],http:[4,7],icon:[4,7,8,10],identifi:[4,7],ids:7,iii:7,immedi:[2,4],impact:[4,8],implement:4,improv:4,inc:1,includ:[1,4,7],incom:[3,7],increas:[4,7,8],index:3,indic:[4,7,8],individu:4,industri:7,influenc:[2,5],inform:[2,7,8,11],inherit:7,initi:7,input:[7,8,11,12],instanc:4,instantli:[7,10],instead:4,instruct:[7,11],interest:[3,7],interfac:6,intern:[1,3],interv:4,introduc:0,introduct:11,invest:[3,7],involv:5,ipad:4,iphon:4,ipmt:3,irr:3,irrespect:8,issu:11,item:[3,4,7],iter:3,its:[1,3,7,8],jan:[4,7,8],json:7,jul:5,jump:4,just:4,keep:4,kei:[2,7,11],know:4,known:11,kpi:[2,5,11],label:[3,4],languag:1,larg:[4,8],largest:3,last:[4,7],lastli:10,lastnperiod:3,latest:[4,7],law:1,least:[4,7],left:[4,7,9],legend:4,let:[4,7,8,10],letter:7,level:[2,4,7,9,10],leverag:5,lie:7,light:7,like:[0,1,4,7],limit:[4,11],line:[4,7],link:[2,4,5,7],list:[4,6,7,12],litr:4,littl:4,load:[7,8],loan:3,locat:[4,7],lock:[4,7,8],log:[3,10],logarithm:3,logical_test1:3,logical_test2:3,logical_test:3,login:10,logo:1,look:[0,4,8],loss:4,made:[1,4,8,10],mai:[1,3,4,5,7],main:[4,7],maintain:7,major:5,make:[4,10],manag:[2,5],mandatori:7,mani:[3,4],manner:4,manual:[1,4,7],map:[4,7],mar:[7,8],march:7,match:[3,7],materi:[1,4],mathemat:[2,5],max:3,maximum:[4,7],mean:[1,3,4,7],meant:5,measur:7,mechan:1,medium:7,member:7,mention:1,menu:[4,7,8],messag:7,met:3,method:[4,7,8],metric:[4,7],microsoft:[2,3,4,5,7],middl:4,mill:4,million:7,min:3,mine:[4,7],minim:[4,7],minimum:7,minor:5,mode:[4,7],model:[0,2,3,5,8,10,11,12],modifi:8,month:[4,7,8],monthli:[0,4,8],more:[1,7,11],morri:10,most:4,mous:4,move:4,much:4,multipl:4,multipli:7,multiyear:4,must:1,name:[1,3,4,7,8,10,12],natur:4,navig:[4,9],necessarili:4,need:[7,8],neg:[3,4,7],neither:7,net:[3,4,7],network:4,newli:8,next:7,node:[0,2,3,8,9,10,11],none:7,nor:7,normal:7,note:[0,4,7],noth:4,notic:1,nov:5,novemb:4,now:[4,7,8],nper:3,npv:3,number:[0,3,4,8],observ:[4,7],offer:[4,5],offic:10,often:[2,4],onc:[4,8,10],one:[0,1,2,3,4,7],onli:[3,4,8],onlin:6,onward:[4,8],open:[8,11],oper:[2,4,5,7,8],opportun:4,option:[0,3,4,7,8,9,10,12],orang:4,order:[7,10],origin:4,other:[0,1,4,7,11],our:[4,7,8],out:[4,7],outsid:7,over:4,overal:[4,8],overcapac:4,overwrit:[4,7,8],overwritten:4,own:7,owner:1,ownership:1,page:[0,4,7],pai:4,paid:3,pair:7,pan:11,pane:[4,7],panel:[4,9,12],parallel:4,paramet:7,parent:[2,3,7],part:[1,4,7,10],parti:1,particular:[4,7,8],particularli:[4,8],past:[4,7,10],patch:5,patent:11,payment:3,pct:[4,7],pdf:7,pen:4,pencil:4,pend:1,per:[3,4,7],percentag:[4,8],perform:[0,4,8],period:[0,3,7,8,11],period_index:3,period_mon:7,permiss:1,person:7,physic:4,pinch:[4,6],place:7,plan:[0,4,7,11,12],pleas:7,pmt:3,point:[4,6],poor:7,pop:[4,7,8],popup:[7,8],posit:[3,4],possibl:[0,4,8],post:4,pow:3,power:[0,2,3,4,7,10],prefer:7,prefix:7,present:[3,8],preview:7,previous:4,price:[4,5,7],primari:[4,7,8],princip:3,print:1,prior:[7,8],proce:7,process:4,product:[1,2,4,7],profit:[4,7],project:7,prompt:7,properti:[1,4],proprietari:1,protect:1,provid:[4,7],provis:1,purpos:[1,4],queri:[7,10],quick:4,rais:3,rang:7,rate:[3,4],ratio:7,read:11,real:[4,5],realis:7,realiti:4,reason:4,recalcul:4,recent:7,recogn:3,record:1,red:[4,7],redirect:4,redistribut:8,refer:[2,3,4,7],referenc:7,reflect:[6,7],refresh:[8,10],regist:1,reimport:7,relat:[2,4],relationship:[5,8],releas:[0,4,5,7,8],remain:[4,7],renam:8,render:7,rent:8,reorder:[4,7],replac:7,replic:4,report:4,repres:[4,7,9],reproduc:1,requir:[4,7,8,10],reserv:1,reset:[4,8],respect:[1,4],respons:1,restor:8,result1:3,result2:3,result:[0,3,4,7,8],result_n:3,retain:[1,7,8],revenu:[4,7,8],rewrit:8,ribbon:7,right:[1,4,7,8,9],roll:[4,8],root:[3,7],row:[7,8],rule:[4,7],run:[0,10],runtim:4,ryan:10,sai:4,salari:7,sale:[4,7,8],same:[0,4,7,10],save:[7,10,11],scale:[4,8],scenario:[5,7,10,11],scratch:[7,8],screen:[4,7,8,12],screenshot:[4,7,10],scroll:[4,7],search:[7,8],second:[7,10],secondari:4,section:[4,7,8,9,12],see:[4,7,8,9,10,12],seen:4,select:[0,3,4,7,8,10],sensit:0,separ:7,septemb:4,seri:[0,3,4,8,10,11],server:4,servic:[0,1,10],set:[3,4,8,11],sever:[0,7],share:4,shot:7,should:[4,7,11],show:[0,4,7],shown:[0,4,5,7,8],sibl:8,side:4,sign:3,significantli:4,sim:4,sim_period:3,similar:[4,7,8],similarli:[4,7],simpl:4,simplifi:4,simul:[3,5,10,11,12],sinc:7,singl:7,size:7,slide:4,slider:[4,6,7],small:7,smallest:3,smith:10,softwar:1,sold:7,solut:1,some:4,sound:1,sourc:[4,7,10],space:7,spark:7,sparklin:7,sparklingwater_grosssal:7,special:[4,7],specif:[4,7],specifi:3,spous:7,spouse1:7,spread:8,spreadsheet:4,sqrt:3,squar:3,stakehold:[2,5],standard:[4,7],start:[4,7,8],start_index:3,start_period:3,state:[1,6],statu:[4,7],step:[7,8],still:4,storag:11,store:10,structur:[7,8],style:7,sub:[7,11],subject:1,submit:8,subscript:7,subtract:7,success:10,suffix:7,sum:[3,4,7],support:[3,4,6,7,8],sync:10,synchron:10,syntax:3,system:7,tab:[4,11,12],tabl:[4,5,7,8],take:7,taken:7,target:4,technic:[4,7],templat:[4,7],term:7,text:[4,7],tgt:3,than:4,thei:[4,7],them:[4,7,10],therefor:[1,4],thi:[1,2,3,4,6,7,8,10,11],thing:[2,4,5],third:4,thousand:7,three:[4,7],threshold:7,through:[7,10],throughput:4,till:[7,8],time:[0,4,5,6,8,10],titl:[1,4,7],to1:7,tonn:4,toolbar:7,tooltip:4,top:[0,4,7,8,10],total:[7,8],total__cost:7,touch:6,trace:8,track:[4,10],trademark:11,tradit:3,translat:1,transmit:1,treat:1,treati:1,tree:[2,9,11],trend:[4,7,8],trillion:7,turn:8,tutori:7,two:[0,3,4,7,9],type:[3,7,8],typic:[4,7],under:[1,4,7,10],undergo:7,underli:[4,7],underscor:7,understand:[7,11,12],unformat:4,uniqu:[2,7],unit:[1,2],unless:8,unlik:4,unlock:[7,8],upcom:[0,12],updat:[4,6,7,8],uplo:7,upload:[7,10],upon:7,upper:4,upto:7,url:[4,7,10],use:[4,5,7],used:[4,7,8],useful:[4,7,8],user:[0,3,4,5,6,7,8,10],usernam:10,using:[0,4,7,8],usual:7,util:7,valid:5,valq:[2,3,7,9,10],valu:[0,2,3,5,7,8,9,10,11],value1:3,value2:3,value_if_fals:3,value_if_tru:3,value_n:3,vari:4,variabl:4,varianc:11,variat:4,variou:[1,4],veri:7,versa:[4,7],version:[0,4,5,6,7],vertic:7,via:7,vice:[4,7],video:4,view:[0,7,11],visibl:7,visual:[1,2,7,9,12],visualis:2,volum:[4,5],wai:[2,4,5,7],want:4,water:7,waterfal:[4,7],web:[7,10],weight:[4,7,8],well:[1,4,7],were:[0,4,8],what:[2,11],wheel:4,when:[0,4,6,7,8],where:[4,7,9],whether:[3,7],which:[0,3,4,5,7,8,9],white:[4,7],who:[10,11],widget:[2,7,11],window:[4,6,7,10],wish:4,within:[1,6,10],without:[1,3,4,7,8],work:[4,6],workapc:10,workspac:10,world:4,wors:4,would:[4,7,8],write:[4,6,7],written:[1,7],xml:[4,7],xor:3,year:[4,7],yellow:[4,7,8],you:[0,1,3,4,7,8,12],your:[3,4,7],ytd:4,zero:[3,7,8],zoom:[6,7,11]},titles:["Analyze Tab","Copyright","Definitions","List of Formulas and Functions","General Features of valQ Custom Visual","Introduction","Known Issues and Limitations","Model Tab","Plan Tab","Simulate Tab","Storage and Collaboration","Welcome to valQ Custom Visual for Microsoft Power BI!","valQ in Power BI"],titleterms:{"export":7,"function":[3,4],"import":7,"new":7,"static":3,AND:3,Adding:8,about:4,addit:7,advanc:7,aggreg:7,alloc:8,analysi:[0,4],analyz:0,budget:8,busi:7,canva:7,collabor:10,collaps:4,color:7,compon:5,condit:7,conduct:4,configur:7,constraint:4,contextu:4,contribut:7,copyright:1,creat:7,custom:[4,5,11],data:[4,7],definit:[2,7],displai:[4,7],document:5,down:4,drill:4,driver:4,dynam:7,editor:7,excel:7,expand:4,featur:[4,8],file:7,filter:4,financ:3,format:[3,7],formula:3,from:7,gener:[4,7],get:4,guid:5,help:4,histori:[5,8],identifi:3,inform:[1,4],input:4,instruct:4,introduct:5,issu:6,kei:4,known:6,kpi:[4,7],label:7,licens:7,limit:6,list:3,logic:3,manag:7,math:3,microsoft:[1,11],model:[4,7],more:4,navig:7,node:[4,7],note:8,number:7,onli:7,open:[4,7],other:[3,8],pan:4,panel:7,patent:1,percentag:7,perform:7,period:4,plan:8,power:[1,5,11,12],properti:7,quick:7,rang:3,read:[5,7],registr:7,sampl:7,save:4,scale:7,scenario:[4,8],secondari:7,seri:7,set:7,should:5,simpl:7,simul:[4,7,9],sort:7,storag:10,sub:4,tab:[0,7,8,9],theme:7,thi:5,time:7,trademark:1,tree:[4,7],understand:[4,8],valq:[4,5,11,12],valu:4,varianc:[0,4,7],view:[4,8],visual:[4,5,11],welcom:11,what:[4,5],who:5,widget:4,writeback:7,zoom:4}})