1.1.0.1HxcAlertButtonSymbol • љ[ternalCm8(ёeoЈZw ƒ xcBackgroundSymbolцskinNameeкeffectBottom№g№н2ш2xcStackAreaChartSymbolpёЈЭяvbgHeightєj J№xБяhрѓАБяxcAreaChartSymbolhe иB№hLˆu_ZeffectRight^ underlinexcFilledRadarChartSymbolДnm Pд@Ийё …=xТёАТёa chartTypefexcRadarChartSymbol Behavior№u[p0№џџџџDpE№ xcLineChartSymbolhС chartSubTitleg Ф Enable Full AutomatixcStackColumnChartSymbolli!ЃАЊ ˆЃ ˆq ˜Д 0Ж Ь АО PР €У јЗ xh€м т шС аа 0ю xcBubbleChartSymbol0њя ѓ   Enable Full Automatic ScalingxcStackBarChartSymbolE chartSubTitleИ 0€ЬFО L@˜ЮяМxcPieChartSymboleПbkgAdvancedTilingOptions@Dё З Enable FxcXYChartSymbol  љ[retchMakШн№bяРRw0ьяin y ИбяhаяxcComboChartSymbolв№u[adџџџџL˜УBlИУBЫ chartSubTitlxcColumnChartSymbol; lineWeight ?˜ ёјFѕ=№u[x2џџџџDp ёxcBarChartSymbolhієичяє @Y№ ёя€s^щ0єˆ9јя№u[adџџџџxcCheckBoxSymbolnshSkin№malertMethoda introTimexcListBoxSymbolї№u[feџџџџDSёЂ@lЃBшlistStretchTilinxcFilterSymbolВtitleXShiftЖ0ИOД Ј„і@єИN_Љ(‡іИЕOЏ xcComboBoxSymbolonsТ2ˆ2Р chartSubTitleg;valueTextForxcDialSymbolrў effectLeft ђш GиЛO№ displayKey є љ[xcDualSliderSymbol€ иыO FJи+_… colors_aryљvSpacingxcEllipseSymbol*Y@№?. Appearance" insertIntoxcExternalComponentSymbolxiI№u[x2џџџџDА=ј иiIј?№Р№xcGaugeSymbolџˆrKиЏKOаЮKАбKnlё№u[feиГK`гKџџџџGxrKhдKlxcGridSymbolrЭрKšLУVerdanaР K№›LЦsizeK;А]L(œLxcProgressBarHSymbolorЖ€tLPОLДЈ|=Јƒ]Њ €ЩR@ШRbЏш|=„]­xcSliderHSymbolУ artEnabledKЧstretchType!;`ћо(п Ку@п8SуШPуxcInputTextSymbol  иhRXaS˜b™™Щ? Appearancez$@š™™™™™Й?xcTextAreaInputSymbolу customScrollBarGutterColorлЈ{Lˆ“LxcLabelCompSymbol"DŸPmLиgX  ёяРj=Шr^’xцO˜fX№u[stˆnOџџџџxcLineSymbolVEdgeD@i@DР@Џ@EdgЈz=8cL№`LArt & BackgrxcLineSymbolDWi@@@Џ@D@x?јˆЕO@ГOArt & BackgrxcMapAfricaByCountrySymbol ћ  FPџџџџpPixcMapAsiaByCountrySymbolЭ шc№š_јwXxQСalertMethodХxcMapCaliforniaByCountySymbol ѕ ш§Cа-Pш§C0ОQщalertMethodxcMapCentralAmericaByCountrySymbol ШxcPlaySliderGutterEffecxcMapEuropeByCountrySymbol;$@š™™™™™Й?? alertType3 xcMapNorthAmericaByCountrySymbol CxcPlaySliderGutterEffecxcMapSouthAmericaByCountrySymbol „ Xu[–иOЖQka љ љ[ius.xcCxcMapUnitedStatesByStateSymbol Ч introStyle;аlSаlSxcMapWorldByContinentSymbolо№™TЈЄTм@›T0zTxzTб Font ColorxcMenuSymbolonsG underline@ PЛ dataValuesП P P8 P џaМxcPlayNormalSymbolБ№u[eCш,WџџџџEаƒUrАUЊalertMethodxcPlaySelectorSymbolr b]АћN&x§C˜Tx§C UˆSоverticalxcPushButtonSymbolrcа defaultSimpleTilingOptions Ш defaultSxcRadioButtonSetSymbolŠtop leftt ŽpxcScrollBarThumbBotxcRectangleSymbol) (h].R_0sU№qUUИCо " xcScrollBarScroxcRemoteScenarioSymbol™formats_ary0x000000‘№u[dXxcScenarioSymboleb>XhŽR` ш1XP2XX(b–e@X@;N[№u[x2џџџџxcSpinnerSymbolfplayTime[ZPKX7]№$_H˜]џџџ^numSubTicksxcTableNewSymbolr ~ displayStatusЈ2q Font Color2uЊXуяxcTrendIconSymbolrmDТ№П№П@Ÿ@@Ÿ@ontш{=№9] 7]OtherFScrollEditSymboltа&Gа&GnFScrollBoxSymbolЮ`O`OРxcUrlButtonSymbollJ№u[feџџџџD€й]l€#^ CxcCalendarDoxcValueDisplaySymboll:.2ˆ28 ш§CPF_ш§Cˆq_< hШ]АЧ]Xmb1xcProgressBarVSymbolor“&2(Ъ]‘ Д]АC_рЕ]9UH\_• шД]РД]EbŠxcSliderVSymbolEx§CPœTx§CћUЈbоЙ8Ў]a_ М]7U[_Н `Д]ЈГ]ИBbВxcAccordionMenuSymbolК Pѕё љQPѕёSЊ хxKjrmМ˜[jXOj8NjxcCalendarSymbolor=x§Cшпjx§C{UјYm1№u[˜сjџџџџDШџj рjxcExternalSlideShowSymbol(‹jШЗjЦ Х displayKey9 top centerxcSliderMenuSymbol\ x)d o˜}oјUjPselectedYearj`уjK тjИьjxcFishEyeMenuSymbolD„@@р@@Ÿ@рŸ@шNjmˆmSelectorxcSourceDataSymbolхm0}jƒ №m`mи’o€уmр}j† XmШm(“oћxcConnectionLightSymbol { xcInputTextEffectTopxcListBuilderSymbol buttonDownAdvancedTilingOptions_obj  xcLoginSymbolbjhtitleXShiftlvertical` HсцАўцРд№e xcPeopleListSymbol refreshAuto  displayKey Xu[Ž“ё фxcTickerSymbol stretch3H fчfчfчud№u[ˆ*xџџџџxcXMLSOAPDataSymbolD ШwИxшЭwр(x ИјSelectorsColorlors.xcXMLDataSymbol›mouse clickŸuseCustomButtonDownColorxcXML2003DataSymbolI ИШU€[wO ˜{˜{L XАVЈ[wBxcXMLSOAPDatf im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1 im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1  im19.xlsSheet1 ! im19.xlsSheet1 " im19.xlsSheet1 # im19.xlsSheet1 $ im19.xlsSheet1 % im19.xlsSheet1 & im19.xlsSheet1 ' im19.xlsSheet1 ( im19.xlsSheet1 ) im19.xlsSheet1 * im19.xlsSheet1+ im19.xlsSheet1, im19.xlsSheet1- im19.xlsSheet1. im19.xlsSheet1/ im19.xlsSheet10 im19.xlsSheet11 im19.xlsSheet12 im19.xlsSheet13 im19.xlsSheet14 im19.xlsSheet15 im19.xlsSheet16 im19.xlsSheet17 im19.xlsSheet18 im19.xlsSheet19 im19.xlsSheet1: im19.xlsSheet1; im19.xlsSheet1< im19.xlsSheet1= im19.xlsSheet1> im19.xlsSheet1? im19.xlsSheet1@ im19.xlsSheet1A im19.xlsSheet1B im19.xlsSheet1C im19.xlsSheet1D im19.xlsSheet1E im19.xlsSheet1F im19.xlsSheet1G im19.xlsSheet1H im19.xlsSheet1I im19.xlsSheet1J im19.xlsSheet1K im19.xlsSheet1L im19.xlsSheet1M im19.xlsSheet1N im19.xlsSheet1O im19.xlsSheet1P im19.xlsSheet1Q im19.xlsSheet1R im19.xlsSheet1S im19.xlsSheet1T im19.xlsSheet1U im19.xlsSheet1V im19.xlsSheet1W im19.xlsSheet1X im19.xlsSheet1Y im19.xlsSheet1Z im19.xlsSheet1[ im19.xlsSheet1\ im19.xlsSheet1] im19.xlsSheet1^ im19.xlsSheet1_ im19.xlsSheet1` im19.xlsSheet1a im19.xlsSheet1b im19.xlsSheet1c im19.xlsSheet1d im19.xlsSheet1e im19.xlsSheet1f im19.xlsSheet1g im19.xlsSheet1h im19.xlsSheet1i im19.xlsSheet1j im19.xlsSheet1k im19.xlsSheet1l im19.xlsSheet1m im19.xlsSheet1n im19.xlsSheet3o im19.xlsSheet3p im19.xlsSheet3q im19.xlsSheet3r im19.xlsSheet3s im19.xlsSheet3t im19.xlsSheet3u im19.xlsSheet3v im19.xlsSheet3w im19.xlsSheet3x im19.xlsSheet3y im19.xlsSheet3z im19.xlsSheet3{ im19.xlsSheet3| im19.xlsSheet3} im19.xlsSheet3~ im19.xlsSheet3 im19.xlsSheet3€ im19.xlsSheet3 im19.xlsSheet3 ‚ im19.xlsSheet3 ƒ im19.xlsSheet3 „ im19.xlsSheet3 … im19.xlsSheet3 † im19.xlsSheet3 ‡ im19.xlsSheet3 ˆ im19.xlsSheet3 ‰ im19.xlsSheet3 Š im19.xlsSheet3 ‹ im19.xlsSheet3 Œ im19.xlsSheet3  im19.xlsSheet3 Ž im19.xlsSheet3  im19.xlsSheet3  im19.xlsSheet3 ‘ im19.xlsSheet3 ’ im19.xlsSheet3 “ im19.xlsSheet3 ” im19.xlsSheet3 • im19.xlsSheet3 – im19.xlsSheet3 — im19.xlsSheet3 ˜ im19.xlsSheet3 ™ im19.xlsSheet3 š im19.xlsSheet3 › im19.xlsSheet3 œ im19.xlsSheet3  im19.xlsSheet3 ž im19.xlsSheet3 Ÿ im19.xlsSheet3  im19.xlsSheet3Ё im19.xlsSheet3Ђ im19.xlsSheet3Ѓ im19.xlsSheet3Є im19.xlsSheet3Ѕ im19.xlsSheet3І im19.xlsSheet3Ї im19.xlsSheet3Ј im19.xlsSheet3Љ im19.xlsSheet3Њ im19.xlsSheet3Ћ im19.xlsSheet3Ќ im19.xlsSheet3­ im19.xlsSheet3Ў im19.xlsSheet3Џ im19.xlsSheet3А im19.xlsSheet3Б im19.xlsSheet3В im19.xlsSheet3Г im19.xlsSheet3Д im19.xlsSheet3Е im19.xlsSheet3Ж im19.xlsSheet3З im19.xlsSheet3И im19.xlsSheet3Й im19.xlsSheet3К im19.xlsSheet3Л im19.xlsSheet3М im19.xlsSheet3Н im19.xlsSheet3О im19.xlsSheet3П im19.xlsSheet3Р im19.xlsSheet3С im19.xlsSheet3Т im19.xlsSheet3У im19.xlsSheet3Ф im19.xlsSheet3Х im19.xlsSheet3Ц im19.xlsSheet3Ч im19.xlsSheet3Ш im19.xlsSheet3Щ im19.xlsSheet3Ъ im19.xlsSheet3Ы im19.xlsSheet3Ь im19.xlsSheet3Э im19.xlsSheet3Ю im19.xlsSheet3Я im19.xlsSheet3а im19.xlsSheet3б im19.xlsSheet3в im19.xlsSheet3г im19.xlsSheet3д im19.xlsSheet3е im19.xlsSheet3ж im19.xlsSheet3з im19.xlsSheet3и im19.xlsSheet3й im19.xlsSheet3к im19.xlsSheet2л im19.xlsSheet2м im19.xlsSheet2н im19.xlsSheet2о im19.xlsSheet2п im19.xlsSheet2р im19.xlsSheet2с im19.xlsSheet2т im19.xlsSheet2у im19.xlsSheet2ф im19.xlsSheet2х im19.xlsSheet2ц im19.xlsSheet2ч im19.xlsSheet2ш im19.xlsSheet2щ im19.xlsSheet2ъ im19.xlsSheet2ы im19.xlsSheet2ь im19.xlsSheet2э im19.xlsSheet2 ю im19.xlsSheet2 я im19.xlsSheet2 № im19.xlsSheet2 ё im19.xlsSheet2 ђ im19.xlsSheet2 ѓ im19.xlsSheet2 є im19.xlsSheet2 ѕ im19.xlsSheet2 і im19.xlsSheet2 ї im19.xlsSheet2 ј im19.xlsSheet2 љ im19.xlsSheet2 њ im19.xlsSheet2 ћ im19.xlsSheet2 ќ im19.xlsSheet2 § im19.xlsSheet2 ў im19.xlsSheet2 џ im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2   im19.xlsSheet2   im19.xlsSheet2   im19.xlsSheet2  im19.xlsSheet2  im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2 im19.xlsSheet2  im19.xlsSheet2! im19.xlsSheet2" im19.xlsSheet2# im19.xlsSheet2$ im19.xlsSheet2% im19.xlsSheet2& im19.xlsSheet2' im19.xlsSheet2( im19.xlsSheet2) im19.xlsSheet2* im19.xlsSheet2+ im19.xlsSheet2, im19.xlsSheet2- im19.xlsSheet2. im19.xlsSheet2/ im19.xlsSheet20 im19.xlsSheet21 im19.xlsSheet22 im19.xlsSheet23 im19.xlsSheet24 im19.xlsSheet25 im19.xlsSheet26 im19.xlsSheet27 im19.xlsSheet28 im19.xlsSheet29 im19.xlsSheet2: im19.xlsSheet2; im19.xlsSheet2< im19.xlsSheet2= im19.xlsSheet2> im19.xlsSheet2? im19.xlsSheet2@ im19.xlsSheet2A im19.xlsSheet2B im19.xlsSheet2C im19.xlsSheet2D im19.xlsSheet2E im19.xlsSheet2F im19.xlsSheet1G im19.xlsSheet1H im19.xlsSheet1I im19.xlsSheet1J im19.xlsSheet1K im19.xlsSheet1L im19.xlsSheet1 M im19.xlsSheet1 N im19.xlsSheet1 O im19.xlsSheet1 P im19.xlsSheet1 Q im19.xlsSheet1R im19.xlsSheet1S im19.xlsSheet1T im19.xlsSheet1U im19.xlsSheet1V im19.xlsSheet1W im19.xlsSheet1X im19.xlsSheet1Y im19.xlsSheet1Z im19.xlsSheet1[ im19.xlsSheet1\ im20.xlsSheet1] im25.xlsSheet1^ im25.xlsSheet1_ im25.xlsSheet1` im25.xlsSheet1a im25.xlsSheet1b im25.xlsSheet1c im33.xlsSheet1d im33.xlsSheet1e+llopлмw}x~yz€{›ЇœЈЉžЊŸЋГПДРЕСЖТЗУущфъхыцьчэ   + ,!-".#/]]^_`_^^ddeeSheet1Sheet2Sheet3џџџџP im37.xlsSheet1String Crystal Xcelsius Best Practices Crystal Xcelsius Best Practices im37.xlsSheet1StringContext Switching ExampleContext Switching Example im37.xlsSheet1String.sharing common component for two sets of data.sharing common component for two sets of data im37.xlsSheet1Number00 im37.xlsSheet1String<-- Toggle Button<-- Toggle Button im37.xlsSheet1StringBB im37.xlsSheet1String <-- Scenario <-- Scenario im37.xlsSheet1Number11 im37.xlsSheet1Number22 im37.xlsSheet1Number33 im37.xlsSheet1Number44 im37.xlsSheet1Number55 im37.xlsSheet1Number66 im37.xlsSheet1Number11 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Company X - Scenario BCompany X - Scenario B im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Week 1Week 1 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Week 2Week 2 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Week 3Week 3 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Week 4Week 4 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Week 5Week 5 im37.xlsSheet1Number22 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Sales revenueSales revenue im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))28502850 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))30033003 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))29172917 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))27632763 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))27982798 im37.xlsSheet1 Number33 im37.xlsSheet1 String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Other income with adjustmentsOther income with adjustments im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))55 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))1010 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))1515 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))1515 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))2525 im37.xlsSheet1 Number44 im37.xlsSheet1 String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C)) TOTAL REVENUE TOTAL REVENUE im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))28552855 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))30133013 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))29322932 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))27782778 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))28232823 im37.xlsSheet1 Number55 im37.xlsSheet1 String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Cost of salesCost of sales im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))25312531 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))26722672 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))25002500 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))24502450 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))26722672 im37.xlsSheet1 Number66 im37.xlsSheet1 String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Selling expensesSelling expenses im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))2020 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))2222 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))2222 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))2222 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))2222 im37.xlsSheet1 Number77 im37.xlsSheet1 String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C)) GROSS PROFITS GROSS PROFITS im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))304304 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))319319 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))410410 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))306306 im37.xlsSheet1 Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))129129 im37.xlsSheet1Number88 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C)) OPERATING EXPENSES OPERATING EXPENSES im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number99 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))$General and administrative expenses$General and administrative expenses im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))3535 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4040 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4040 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4141 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4040 im37.xlsSheet1Number1010 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Other operating expensesOther operating expenses im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number1111 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C)) TOTAL OPERATING EXPENSES TOTAL OPERATING EXPENSES im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))3535 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4040 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4040 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4141 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4040 im37.xlsSheet1Number1212 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C)) OTHER INCOME AND EXPENSES OTHER INCOME AND EXPENSES im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number1313 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Other expenseOther expense im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4747 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))6666 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))6666 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))6666 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))6666 im37.xlsSheet1Number1414 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C)))Extraordinary items, net of income taxes)Extraordinary items, net of income taxes im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))00 im37.xlsSheet1Number1515 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))$ TOTAL OTHER INCOME AND EXPENSES$ TOTAL OTHER INCOME AND EXPENSES im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))4747 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))6666 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))6666 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))6666 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))6666 im37.xlsSheet1Number1616 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C)) INCOME BEFORE TAXES INCOME BEFORE TAXES im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))222222 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))213213 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))304304 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))199199 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))2323 im37.xlsSheet1Number1717 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))Income tax expenseIncome tax expense im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))88.80000000000001188.8 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))85.20000000000000385.2 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))121.60000000000001121.6 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))79.60000000000000979.6 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))9.20000000000000119.2 im37.xlsSheet1Number1818 im37.xlsSheet1String^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C)) NET INCOME NET INCOME im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))133.19999999999999133.2 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))127.8127.8 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))182.39999999999998182.4 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))119.39999999999999119.4 im37.xlsSheet1Number^=IF(R5C1="A",INDEX(Sheet2!R6C1:Sheet2!R23C6,RC1,R6C),INDEX(Sheet3!R6C1:Sheet3!R23C6,RC1,R6C))13.79999999999999913.8 im37.xlsSheet1 im37.xlsSheet2StringCompany X - Scenario ACompany X - Scenario A im37.xlsSheet2StringWeek 1Week 1 im37.xlsSheet2StringWeek 2Week 2 im37.xlsSheet2StringWeek 3Week 3 im37.xlsSheet2StringWeek 4Week 4 im37.xlsSheet2StringWeek 5Week 5 im37.xlsSheet2StringSales revenueSales revenue im37.xlsSheet2Number2750 $2,750.00 im37.xlsSheet2Number3000 $3,000.00 im37.xlsSheet2Number3200 $3,200.00 im37.xlsSheet2Number3400 $3,400.00 im37.xlsSheet2Number3765 $3,765.00 im37.xlsSheet2String Other income Other income im37.xlsSheet2Number15$15.00 im37.xlsSheet2Number42$42.00 im37.xlsSheet2Number19$19.00 im37.xlsSheet2Number65$65.00 im37.xlsSheet2Number115 $115.00 im37.xlsSheet2 String TOTAL REVENUE TOTAL REVENUE im37.xlsSheet2 Number=SUM(R[-2]C:R[-1]C)2765 $2,765.00 im37.xlsSheet2 Number=SUM(R[-2]C:R[-1]C)3042 $3,042.00 im37.xlsSheet2 Number=SUM(R[-2]C:R[-1]C)3219 $3,219.00 im37.xlsSheet2 Number=SUM(R[-2]C:R[-1]C)3465 $3,465.00 im37.xlsSheet2 Number=SUM(R[-2]C:R[-1]C)3880 $3,880.00 im37.xlsSheet2 StringCost of salesCost of sales im37.xlsSheet2 Number2560 $2,560.00 im37.xlsSheet2 Number2700 $2,700.00 im37.xlsSheet2 Number2672 $2,672.00 im37.xlsSheet2 Number2930 $2,930.00 im37.xlsSheet2 Number3000 $3,000.00 im37.xlsSheet2 StringSelling expensesSelling expenses im37.xlsSheet2 Number20$20.00 im37.xlsSheet2 Number33$33.00 im37.xlsSheet2 Number44$44.00 im37.xlsSheet2 Number50$50.00 im37.xlsSheet2 Number60$60.00 im37.xlsSheet2 String GROSS PROFITS GROSS PROFITS im37.xlsSheet2 Number=R[-3]C-R[-2]C-R[-1]C185 $185.00 im37.xlsSheet2 Number=R[-3]C-R[-2]C-R[-1]C309 $309.00 im37.xlsSheet2 Number=R[-3]C-R[-2]C-R[-1]C503 $503.00 im37.xlsSheet2 Number=R[-3]C-R[-2]C-R[-1]C485 $485.00 im37.xlsSheet2 Number=R[-3]C-R[-2]C-R[-1]C820 $820.00 im37.xlsSheet2 String OPERATING EXPENSES OPERATING EXPENSES im37.xlsSheet2String$General and administrative expenses$General and administrative expenses im37.xlsSheet2Number40$40.00 im37.xlsSheet2Number47$47.00 im37.xlsSheet2Number49$49.00 im37.xlsSheet2Number55$55.00 im37.xlsSheet2Number60$60.00 im37.xlsSheet2StringOther operating expensesOther operating expenses im37.xlsSheet2Number10$10.00 im37.xlsSheet2Number12$12.00 im37.xlsSheet2Number14$14.00 im37.xlsSheet2Number14$14.00 im37.xlsSheet2Number17$17.00 im37.xlsSheet2String TOTAL OPERATING EXPENSES TOTAL OPERATING EXPENSES im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)50$50.00 im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)59$59.00 im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)63$63.00 im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)69$69.00 im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)77$77.00 im37.xlsSheet2String OTHER INCOME AND EXPENSES OTHER INCOME AND EXPENSES im37.xlsSheet2StringOther expenseOther expense im37.xlsSheet2Number47$47.00 im37.xlsSheet2Number60$60.00 im37.xlsSheet2Number66$66.00 im37.xlsSheet2Number70$70.00 im37.xlsSheet2Number72$72.00 im37.xlsSheet2String)Extraordinary items, net of income taxes)Extraordinary items, net of income taxes im37.xlsSheet2Number0$0.00 im37.xlsSheet2Number0$0.00 im37.xlsSheet2Number0$0.00 im37.xlsSheet2Number0$0.00 im37.xlsSheet2Number0$0.00 im37.xlsSheet2String$ TOTAL OTHER INCOME AND EXPENSES$ TOTAL OTHER INCOME AND EXPENSES im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)47$47.00 im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)60$60.00 im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)66$66.00 im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)70$70.00 im37.xlsSheet2Number=SUM(R[-3]C:R[-1]C)72$72.00 im37.xlsSheet2String INCOME BEFORE TAXES INCOME BEFORE TAXES im37.xlsSheet2Number=R[-9]C-R[-5]C-R[-1]C88$88.00 im37.xlsSheet2Number=R[-9]C-R[-5]C-R[-1]C190 $190.00 im37.xlsSheet2Number=R[-9]C-R[-5]C-R[-1]C374 $374.00 im37.xlsSheet2Number=R[-9]C-R[-5]C-R[-1]C346 $346.00 im37.xlsSheet2Number=R[-9]C-R[-5]C-R[-1]C671 $671.00 im37.xlsSheet2StringIncome tax expenseIncome tax expense im37.xlsSheet2Number =0.4*R[-1]C35.200000000000003$35.20 im37.xlsSheet2Number =0.4*R[-1]C76$76.00 im37.xlsSheet2Number =0.4*R[-1]C149.59999999999999 $149.60 im37.xlsSheet2Number =0.4*R[-1]C138.40000000000001 $138.40 im37.xlsSheet2Number =0.4*R[-1]C268.40000000000003 $268.40 im37.xlsSheet2String NET INCOME NET INCOME im37.xlsSheet2Number=R[-2]C-R[-1]C52.799999999999997$52.80 im37.xlsSheet2Number=R[-2]C-R[-1]C114 $114.00 im37.xlsSheet2Number=R[-2]C-R[-1]C224.40000000000001 $224.40 im37.xlsSheet2Number=R[-2]C-R[-1]C207.59999999999999 $207.60 im37.xlsSheet2Number=R[-2]C-R[-1]C402.59999999999997 $402.60 im37.xlsSheet3StringCompany X - Scenario BCompany X - Scenario B im37.xlsSheet3StringWeek 1Week 1 im37.xlsSheet3StringWeek 2Week 2 im37.xlsSheet3StringWeek 3Week 3 im37.xlsSheet3StringWeek 4Week 4 im37.xlsSheet3StringWeek 5Week 5 im37.xlsSheet3StringSales revenueSales revenue im37.xlsSheet3Number28502850 im37.xlsSheet3Number30033003 im37.xlsSheet3Number29172917 im37.xlsSheet3Number27632763 im37.xlsSheet3Number27982798 im37.xlsSheet3StringOther income with adjustmentsOther income with adjustments im37.xlsSheet3Number55 im37.xlsSheet3Number1010 im37.xlsSheet3Number1515 im37.xlsSheet3Number1515 im37.xlsSheet3Number2525 im37.xlsSheet3 String TOTAL REVENUE TOTAL REVENUE im37.xlsSheet3 Number=SUM(R[-2]C:R[-1]C)28552855 im37.xlsSheet3 Number=SUM(R[-2]C:R[-1]C)30133013 im37.xlsSheet3 Number=SUM(R[-2]C:R[-1]C)29322932 im37.xlsSheet3 Number=SUM(R[-2]C:R[-1]C)27782778 im37.xlsSheet3 Number=SUM(R[-2]C:R[-1]C)28232823 im37.xlsSheet3 StringCost of salesCost of sales im37.xlsSheet3 Number25312531 im37.xlsSheet3 Number26722672 im37.xlsSheet3 Number25002500 im37.xlsSheet3 Number24502450 im37.xlsSheet3 Number26722672 im37.xlsSheet3 StringSelling expensesSelling expenses im37.xlsSheet3 Number2020 im37.xlsSheet3 Number2222 im37.xlsSheet3 Number2222 im37.xlsSheet3 Number2222 im37.xlsSheet3 Number2222 im37.xlsSheet3 String GROSS PROFITS GROSS PROFITS im37.xlsSheet3 Number=R[-3]C-R[-2]C-R[-1]C304304 im37.xlsSheet3 Number=R[-3]C-R[-2]C-R[-1]C319319 im37.xlsSheet3 Number=R[-3]C-R[-2]C-R[-1]C410410 im37.xlsSheet3 Number=R[-3]C-R[-2]C-R[-1]C306306 im37.xlsSheet3 Number=R[-3]C-R[-2]C-R[-1]C129129 im37.xlsSheet3 String OPERATING EXPENSES OPERATING EXPENSES im37.xlsSheet3String$General and administrative expenses$General and administrative expenses im37.xlsSheet3Number3535 im37.xlsSheet3Number4040 im37.xlsSheet3Number4040 im37.xlsSheet3Number4141 im37.xlsSheet3Number4040 im37.xlsSheet3StringOther operating expensesOther operating expenses im37.xlsSheet3Number00 im37.xlsSheet3Number00 im37.xlsSheet3Number00 im37.xlsSheet3Number00 im37.xlsSheet3Number00 im37.xlsSheet3String TOTAL OPERATING EXPENSES TOTAL OPERATING EXPENSES im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)3535 im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)4040 im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)4040 im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)4141 im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)4040 im37.xlsSheet3String OTHER INCOME AND EXPENSES OTHER INCOME AND EXPENSES im37.xlsSheet3StringOther expenseOther expense im37.xlsSheet3Number4747 im37.xlsSheet3Number6666 im37.xlsSheet3Number6666 im37.xlsSheet3Number6666 im37.xlsSheet3Number6666 im37.xlsSheet3String)Extraordinary items, net of income taxes)Extraordinary items, net of income taxes im37.xlsSheet3Number00 im37.xlsSheet3Number00 im37.xlsSheet3Number00 im37.xlsSheet3Number00 im37.xlsSheet3Number00 im37.xlsSheet3String$ TOTAL OTHER INCOME AND EXPENSES$ TOTAL OTHER INCOME AND EXPENSES im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)4747 im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)6666 im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)6666 im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)6666 im37.xlsSheet3Number=SUM(R[-3]C:R[-1]C)6666 im37.xlsSheet3String INCOME BEFORE TAXES INCOME BEFORE TAXES im37.xlsSheet3Number=R[-9]C-R[-5]C-R[-1]C222222 im37.xlsSheet3Number=R[-9]C-R[-5]C-R[-1]C213213 im37.xlsSheet3Number=R[-9]C-R[-5]C-R[-1]C304304 im37.xlsSheet3Number=R[-9]C-R[-5]C-R[-1]C199199 im37.xlsSheet3Number=R[-9]C-R[-5]C-R[-1]C2323 im37.xlsSheet3StringIncome tax expenseIncome tax expense im37.xlsSheet3Number =0.4*R[-1]C88.80000000000001188.8 im37.xlsSheet3Number =0.4*R[-1]C85.20000000000000385.2 im37.xlsSheet3Number =0.4*R[-1]C121.60000000000001121.6 im37.xlsSheet3Number =0.4*R[-1]C79.60000000000000979.6 im37.xlsSheet3Number =0.4*R[-1]C9.20000000000000119.2 im37.xlsSheet3String NET INCOME NET INCOME im37.xlsSheet3Number=R[-2]C-R[-1]C133.19999999999999133.2 im37.xlsSheet3Number=R[-2]C-R[-1]C127.8127.8 im37.xlsSheet3Number=R[-2]C-R[-1]C182.39999999999998182.4 im37.xlsSheet3Number=R[-2]C-R[-1]C119.39999999999999119.4 im37.xlsSheet3Number=R[-2]C-R[-1]C13.79999999999999913.81IMDateSeparator/ IMDayCodedIMDecimalSeparator.IMGeneralFormatNameGeneral IMHourCodeh IMMinuteCodem IMMonthCodemIMSABBREVDAYNAME1MonIMSABBREVDAYNAME2TueIMSABBREVDAYNAME3WedIMSABBREVDAYNAME4ThuIMSABBREVDAYNAME5FriIMSABBREVDAYNAME6SatIMSABBREVDAYNAME7SunIMSABBREVMONTHNAME1JanIMSABBREVMONTHNAME10OctIMSABBREVMONTHNAME11NovIMSABBREVMONTHNAME12DecIMSABBREVMONTHNAME2FebIMSABBREVMONTHNAME3MarIMSABBREVMONTHNAME4AprIMSABBREVMONTHNAME5MayIMSABBREVMONTHNAME6JunIMSABBREVMONTHNAME7JulIMSABBREVMONTHNAME8AugIMSABBREVMONTHNAME9Sep IMSDAYNAME1Monday IMSDAYNAME2Tuesday IMSDAYNAME3 Wednesday IMSDAYNAME4 Thursday IMSDAYNAME5Friday IMSDAYNAME6 Saturday IMSDAYNAME7SundayIMSMONTHNAME1JanuaryIMSMONTHNAME10OctoberIMSMONTHNAME11 NovemberIMSMONTHNAME12 DecemberIMSMONTHNAME2 FebruaryIMSMONTHNAME3MarchIMSMONTHNAME4AprilIMSMONTHNAME5MayIMSMONTHNAME6JuneIMSMONTHNAME7JulyIMSMONTHNAME8AugustIMSMONTHNAME9 September IMSecondCodesIMThousandsSeparator,IMTimeSeparator: IMYearCodeyџџџџ1IMDateSeparator/ IMDayCodedIMDecimalSeparator.IMGeneralFormatNameGeneral IMHourCodeh IMMinuteCodem IMMonthCodemIMSABBREVDAYNAME1MonIMSABBREVDAYNAME2TueIMSABBREVDAYNAME3WedIMSABBREVDAYNAME4ThuIMSABBREVDAYNAME5FriIMSABBREVDAYNAME6SatIMSABBREVDAYNAME7SunIMSABBREVMONTHNAME1JanIMSABBREVMONTHNAME10OctIMSABBREVMONTHNAME11NovIMSABBREVMONTHNAME12DecIMSABBREVMONTHNAME2FebIMSABBREVMONTHNAME3MarIMSABBREVMONTHNAME4AprIMSABBREVMONTHNAME5MayIMSABBREVMONTHNAME6JunIMSABBREVMONTHNAME7JulIMSABBREVMONTHNAME8AugIMSABBREVMONTHNAME9Sep IMSDAYNAME1Monday IMSDAYNAME2Tuesday IMSDAYNAME3 Wednesday IMSDAYNAME4 Thursday IMSDAYNAME5Friday IMSDAYNAME6 Saturday IMSDAYNAME7SundayIMSMONTHNAME1JanuaryIMSMONTHNAME10OctoberIMSMONTHNAME11 NovemberIMSMONTHNAME12 DecemberIMSMONTHNAME2 FebruaryIMSMONTHNAME3MarchIMSMONTHNAME4AprilIMSMONTHNAME5MayIMSMONTHNAME6JuneIMSMONTHNAME7JulyIMSMONTHNAME8AugustIMSMONTHNAME9 September IMSecondCodesIMThousandsSeparator,IMTimeSeparator: IMYearCodey xcExternalComponentSymbolxcExternalComponentSymbol_12_˜У •ˆе_8п_ ‹˜е_р`‰Је_ШќИе_а§А',$0M<2@Ÿ@@Ÿ@i@i@ externalFile embedџџџџ fileName(C:\DOCUME~1\LORENA~1\LOCALS~1\Temp\im21џџџџ clipName embed_65310џџџџ pathNameeC:\Documents and Settings\Loren Abdulezer\My Documents\data\Excel\xcelsiusFiles\ETC2006Copyright.jpgџџџџbgTypejpgџџџџbgWidthi@џџџџ bgHeighti@џџџџbgColorџџџџџџџbgBGџџџџџџџџblockMouseEventsџџџџ transparencydџџџџdisplayStatusdisplayStatusџџџџџџџџџџџџ displayKey displayKey1џџџџџџџџџџџџ introStyleNoneџџџџ introTimeš™™™™™Щ?џџџџ skinNameaqua1џџџџ Active PageoursscalexcRectangleSymbolxcRectangleSymbol_172`2: о н €: шЧ,h/г вЌ2з22P: Aь1@Ÿ@@Ÿ@i@i@ showBorderџџџџ lineColorџџџџlineThicknessџџџџ lineAlphadџџџџ fillStyle fillStylenoneџџџџnonesolidlinearradialџџџџ colors_ary0џџџџџ1џџџџџџџџџџ alphas_ary0dџџџџ12џџџџџџџџpositions_ary0џџџџ1џџџџџџџџџ rotation2џџџџ displayKey displayKey1џџџџџџџџџџџџdisplayStatusdisplayStatusџџџџџџџџџџџџ introStyleNoneџџџџ introTimeš™™™™™Щ?џџџџ Active PagexcRectangleSymbolxcRectangleSymbol_9€0-˜i№n3 2Ќ2 72p2P0-54 Ш0-˜ioP2XHМ>f.@Ÿ@@Ÿ@i@i@ showBorderџџџџ lineColorџџџџlineThicknessџџџџ lineAlphadџџџџ fillStyle fillStylenoneџџџџnonesolidlinearradialџџџџ colors_ary0€€@џџџџ1€€@џџџџџџџџ alphas_ary0(џџџџ1(џџџџџџџџpositions_ary0џџџџ1џџџџџџџџџ rotationgџџџџ displayKey displayKey1џџџџџџџџџџџџdisplayStatusdisplayStatusџџџџџџџџџџџџ introStyleNoneџџџџ introTimeš™™™™™Щ?џџџџ Active PagexcUrlButtonSymbolxcUrlButtonSymbol_11[› рЊZ2 Ÿ 2 2Teœ([’ а€/˜L1™@Р|@о8v@’ak@urlurl#http://www.xcelsius.com/?kbid=1036џџџџџџџџџџџџ windowName_blankџџџџshowArtџџџџlabellabelObtain Crystal XcelsiusџџџџџџџџџџџџlabelTextFormatfontVerdanaџџџџsizeџџџџcolorџџџџboldџџџџitalicџџџџ underlineџџџџџџџџlabelAlignmentlabelAlignmentcenterџџџџcenterleftrightџџџџuseCustomColorџџџџupUseCustomColorџџџџdownUseCustomColorџџџџ customColorџџџџџџџdownCustomColorў=џџџџdisplayStatusdisplayStatusџџџџџџџџџџџџ displayKey displayKey1џџџџџџџџџџџџ introStyleNoneџџџџ introTimeš™™™™™Щ?џџџџupStretchType stretch3HџџџџupSimpleTilingOptions_obj horizontalџџџџ verticalџџџџџџџџupStretchTilingOptions_obj defaultLeftџџџџ defaultTopџџџџdefaultMiddleHorizontalџџџџdefaultMiddleVerticalџџџџdefaultBottomџџџџ defaultRightџџџџ colorLeftџџџџ colorTopџџџџcolorMiddleHorizontalџџџџcolorMiddleVerticalџџџџ colorBottomџџџџ colorRightџџџџ overlayLeftџџџџ overlayTopџџџџoverlayMiddleHorizontalџџџџoverlayMiddleVerticalџџџџoverlayBottomџџџџ overlayRightџџџџџџџџupAdvancedTilingOptions_objtextureVerticalџџџџtextureHorizontalџџџџ effectLeftџџџџ effectTopџџџџeffectMiddleHorizontalџџџџeffectMiddleVerticalџџџџ effectBottomџџџџ effectRightџџџџџџџџdownStretchType stretch3HџџџџdownSimpleTilingOptions_obj horizontalџџџџ verticalџџџџџџџџdownStretchTilingOptions_obj defaultLeftџџџџ defaultTopџџџџdefaultMiddleHorizontalџџџџdefaultMiddleVerticalџџџџdefaultBottomџџџџ defaultRightџџџџ colorLeftџџџџ colorTopџџџџcolorMiddleHorizontalџџџџcolorMiddleVerticalџџџџ colorBottomџџџџ colorRightџџџџ overlayLeftџџџџ overlayTopџџџџoverlayMiddleHorizontalџџџџoverlayMiddleVerticalџџџџoverlayBottomџџџџ overlayRightџџџџџџџџdownAdvancedTilingOptions_objtextureHorizontalџџџџtextureVerticalџџџџ effectLeftџџџџ effectTopџџџџeffectMiddleHorizontalџџџџeffectMiddleVerticalџџџџ effectBottomџџџџ effectRightџџџџџџџџdownFontColorџџџџ skinNameaqua1џџџџ triggerCell triggerCellџџџџџџџџџџџџ triggerAllџџџџ Active PagexcUrlButtonSymbolxcUrlButtonSymbol_13Z€СZЈ2Ы94O–Ћ ЈСZ­ ТZ њ0i_aryА рЊZ2Œ€/Œ(L1™@Р|@о8v@’ak@urlurl%http://www.xcelsiusbestpractices.comџџџџџџџџџџџџ windowName_blankџџџџshowArtџџџџlabellabel Crystal Xcelsius Best PracticesџџџџџџџџџџџџlabelTextFormatfontVerdanaџџџџsizeџџџџcolorџџџџboldџџџџitalicџџџџ underlineџџџџџџџџlabelAlignmentlabelAlignmentcenterџџџџcenterleftrightџџџџuseCustomColorџџџџupUseCustomColorџџџџdownUseCustomColorџџџџ customColorџџџџџџџdownCustomColorў=џџџџdisplayStatusdisplayStatusџџџџџџџџџџџџ displayKey displayKey1џџџџџџџџџџџџ introStyleNoneџџџџ introTimeš™™™™™Щ?џџџџupStretchType stretch3HџџџџupSimpleTilingOptions_obj horizontalџџџџ verticalџџџџџџџџupStretchTilingOptions_obj defaultLeftџџџџ defaultTopџџџџdefaultMiddleHorizontalџџџџdefaultMiddleVerticalџџџџdefaultBottomџџџџ defaultRightџџџџ colorLeftџџџџ colorTopџџџџcolorMiddleHorizontalџџџџcolorMiddleVerticalџџџџ colorBottomџџџџ colorRightџџџџ overlayLeftџџџџ overlayTopџџџџoverlayMiddleHorizontalџџџџoverlayMiddleVerticalџџџџoverlayBottomџџџџ overlayRightџџџџџџџџupAdvancedTilingOptions_objtextureVerticalџџџџtextureHorizontalџџџџ effectLeftџџџџ effectTopџџџџeffectMiddleHorizontalџџџџeffectMiddleVerticalџџџџ effectBottomџџџџ effectRightџџџџџџџџdownStretchType stretch3HџџџџdownSimpleTilingOptions_obj horizontalџџџџ verticalџџџџџџџџdownStretchTilingOptions_obj defaultLeftџџџџ defaultTopџџџџdefaultMiddleHorizontalџџџџdefaultMiddleVerticalџџџџdefaultBottomџџџџ defaultRightџџџџ colorLeftџџџџ colorTopџџџџcolorMiddleHorizontalџџџџcolorMiddleVerticalџџџџ colorBottomџџџџ colorRightџџџџ overlayLeftџџџџ overlayTopџџџџoverlayMiddleHorizontalџџџџoverlayMiddleVerticalџџџџoverlayBottomџџџџ overlayRightџџџџџџџџdownAdvancedTilingOptions_objtextureHorizontalџџџџtextureVerticalџџџџ effectLeftџџџџ effectTopџџџџeffectMiddleHorizontalџџџџeffectMiddleVerticalџџџџ effectBottomџџџџ effectRightџџџџџџџџdownFontColorџџџџ skinNameaqua1џџџџ triggerCell triggerCellџџџџџџџџџџџџ triggerAllџџџџ Active PagexcUrlButtonSymbolxcUrlButtonSymbol_15ъџџџC‚ рЊZ2ъџџџF‡ (Ю њаЭI„2(2>Lљ”*€/>L1™@Р|@о8v@’ak@urlurlVhttp://www.xcelsiusbestpractices.com/landingZone/articleReprints.html#ArticleReprintsџџџџџџџџџџџџ windowName_blankџџџџshowArtџџџџlabellabel Obtain files for this dashboardџџџџџџџџџџџџlabelTextFormatfontVerdanaџџџџsizeџџџџcolorџџџџboldџџџџitalicџџџџ underlineџџџџџџџџlabelAlignmentlabelAlignmentcenterџџџџcenterleftrightџџџџuseCustomColorџџџџupUseCustomColorџџџџdownUseCustomColorџџџџ customColorџџџџџџџdownCustomColorў=џџџџdisplayStatusdisplayStatusџџџџџџџџџџџџ displayKey displayKey1џџџџџџџџџџџџ introStyleNoneџџџџ introTimeš™™™™™Щ?џџџџupStretchType stretch3HџџџџupSimpleTilingOptions_obj horizontalџџџџ verticalџџџџџџџџupStretchTilingOptions_obj defaultLeftџџџџ defaultTopџџџџdefaultMiddleHorizontalџџџџdefaultMiddleVerticalџџџџdefaultBottomџџџџ defaultRightџџџџ colorLeftџџџџ colorTopџџџџcolorMiddleHorizontalџџџџcolorMiddleVerticalџџџџ colorBottomџџџџ colorRightџџџџ overlayLeftџџџџ overlayTopџџџџoverlayMiddleHorizontalџџџџoverlayMiddleVerticalџџџџoverlayBottomџџџџ overlayRightџџџџџџџџupAdvancedTilingOptions_objtextureVerticalџџџџtextureHorizontalџџџџ effectLeftџџџџ effectTopџџџџeffectMiddleHorizontalџџџџeffectMiddleVerticalџџџџ effectBottomџџџџ effectRightџџџџџџџџdownStretchType stretch3HџџџџdownSimpleTilingOptions_obj horizontalџџџџ verticalџџџџџџџџdownStretchTilingOptions_obj defaultLeftџџџџ defaultTopџџџџdefaultMiddleHorizontalџџџџdefaultMiddleVerticalџџџџdefaultBottomџџџџ defaultRightџџџџ colorLeftџџџџ colorTopџџџџcolorMiddleHorizontalџџџџcolorMiddleVerticalџџџџ colorBottomџџџџ colorRightџџџџ overlayLeftџџџџ overlayTopџџџџoverlayMiddleHorizontalџџџџoverlayMiddleVerticalџџџџoverlayBottomџџџџ overlayRightџџџџџџџџdownAdvancedTilingOptions_objtextureHorizontalџџџџtextureVerticalџџџџ effectLeftџџџџ effectTopџџџџeffectMiddleHorizontalџџџџeffectMiddleVerticalџџџџ effectBottomџџџџ effectRightџџџџџџџџdownFontColorџџџџ skinNameaqua1џџџџ triggerCell triggerCellџџџџџџџџџџџџ triggerAllџџџџ Active PagexcRadioButtonSetSymbolxcRadioButtonSetSymbol_10oуџ^ИтџŒтџКJсџdWZroоџ Т 0Ir„„ FgТВ@‡@Т’@ЬŽ@/displayStatusdisplayStatusџџџџџџџџџџџџ selectIdxџџџџmenuOrientationmenuOrientation horizontalџџџџ vertical horizontalџџџџ showTitleџџџџtitletitleџџџџџџџџџџџџtitleTextPropsfontVerdanaџџџџsizeџџџџcolor333џџџџ underlineџџџџboldџџџџitalicџџџџџџџџtitlePositiontitlePosition top leftџџџџ top centerrightleft top left top right bottom leftbottom center bottom rightџџџџ titleXshiftџџџџ titleYshiftџџџџ showLabelsџџџџlabelslabels0Aџџџџ1BџџџџџџџџџџџџlabelFormatџџџџlabelTextPropsfontVerdanaџџџџsizeџџџџcolorџџџџ underlineџџџџboldџџџџitalicџџџџџџџџ labelFormat0 numFormatџџџџџџџџџџџџlabelPositionlabelPositionrightџџџџrightleft top left top center top right bottom leftbottom center bottom rightџџџџ labelXshiftџџџџ labelYshiftџџџџvaluesvalues 0radiobutton value1џџџџ1radiobutton value2џџџџ2radiobutton value3џџџџ3radiobutton value4џџџџ4radiobutton value5џџџџџџџџџџџџџџџџretInforetInfolabelџџџџ positionlabelvaluerowscolumns status listџџџџshowBackgroundџџџџbackgroundProps fillColorџџџџџџџxMarginџџџџyMarginџџџџџџџџbackgroundTransdџџџџbkgStretchTypestretchџџџџbkgSimpleTilingOptions verticalџџџџ horizontalџџџџџџџџbkgStretchTilingOptionsleftџџџџtopџџџџmiddleHorizontalџџџџmiddleVerticalџџџџbottomџџџџrightџџџџџџџџbkgAdvancedTilingOptionstextureVerticalџџџџtextureHorizontalџџџџhighlightLeftџџџџ highlightTopџџџџhighlightMiddleHorizontalџџџџhighlightMiddleVerticalџџџџhighlightBottomџџџџhighlightRightџџџџ shadowLeftџџџџ shadowTopџџџџshadowMiddleHorizontalџџџџshadowMiddleVerticalџџџџ shadowBottomџџџџ shadowRightџџџџџџџџ dataValues dataValues0Bџџџџ0radiobutton value1џџџџџџџџ Sheet1!$A$5l@ dataValues0џџџџ updateOn updateOn mouse clickџџџџ mouse click mouse overџџџџ menuExpandedџџџџ soundEnabledџџџџ introStylenoneџџџџ introTimeš™™™™™Щ?џџџџ displayKey displayKey1џџџџџџџџџџџџ buttonSizeџџџџitemSeparationџџџџuseCustomColorџџџџ defaultColorљљљџџџџ selectColorєŽџџџџ ignoreBlanksџџџџdefaultStretchTypesimpleџџџџdefaultSimpleTilingOptions verticalџџџџ horizontalџџџџџџџџdefaultStretchTilingOptionsleftџџџџtopџџџџmiddleHorizontalџџџџmiddleVerticalџџџџbottomџџџџrightџџџџџџџџdefaultAdvancedTilingOptionstextureVerticalџџџџtextureHorizontalџџџџ effectLeftџџџџ effectTopџџџџeffectMiddleHorizontalџџџџeffectMiddleVerticalџџџџ effectBottomџџџџ effectRightџџџџџџџџselectStretchTypesimpleџџџџselectSimpleTilingOptions verticalџџџџ horizontalџџџџџџџџselectStretchTilingOptionsleftџџџџtopџџџџmiddleHorizontalџџџџmiddleVerticalџџџџbottomџџџџrightџџџџџџџџselectAdvancedTilingOptionstextureVerticalџџџџtextureHorizontalџџџџ effectLeftџџџџ effectTopџџџџeffectMiddleHorizontalџџџџeffectMiddleVerticalџџџџ effectBottomџџџџ effectRightџџџџџџџџ skinNameaqua1џџџџ Active PagexcColumnChartSymbolxcColumnChartSymbol_7;ЃU;ЃU;ЃU;ЃU;ЃU;ЃU;ЃU;ЃU;ЃU;ЃU;ЃU;ЃUќ›U;ЃUќш/>ишМ@\В@шЌ@\Ђ@p chartTypecolumnџџџџ chartTitle chartTitleCompany X - Scenario Bџџџџ=SUM(R[-3]C:R[-1]C) Sheet1!$B$7@ chartTitle%chartTitleFormatџџџџChartTitleTextFormatfontVerdanaџџџџsizeџџџџcolorџџџџ underlineџџџџboldџџџџitalicџџџџџџџџchartTitleFormat numFormatџџџџџџџџchartSubTitlechartSubTitle Sheet1!$B$26џџџџ=SUM(R[-3]C:R[-1]C) Sheet1!$B$26^@ chartSubTitle'chartSubTitleFormatџџџџchartSubTitleTextFormatfontVerdanaџџџџsizeџџџџcolor@@@џџџџ underlineџџџџboldџџџџitalicџџџџџџџџchartSubTitleFormat numFormatџџџџџџџџchartTitleAligncenterџџџџchartTitleProps showBorderџџџџ borderColor333џџџџ borderWeightџџџџ showFillџџџџ fillColorяяяџџџџџџџџ showTitlesџџџџ chartMargin џџџџcategoryLabelscategoryLabels0Week 11Week 22Week 33Week 44Week 50џџџџџџџџSheet1!$C$7:$G$7@categoryLabels0@categoryLabels1@categoryLabels2@categoryLabels3@categoryLabels4(categoryLabelsFormatџџџџcategoryLabelsFormat0 numFormatџџџџџџџџ1 numFormatџџџџџџџџ2 numFormatџџџџџџџџ3 numFormatџџџџџџџџ4 numFormatџџџџџџџџ0 numFormatџџџџџџџџџџџџ seriesNames seriesNames0Company X - Scenario B0 Series 1џџџџџџџџ@ seriesNames0џџџџ%seriesNamesFormatџџџџseriesNamesFormat0 numFormatџџџџџџџџ0 numFormatџџџџџџџџџџџџ dataValues dataValues 00:џџџџ1:џџџџ2:џџџџ3:џџџџ4:џџџџџџџџ0:џџџџџџџџ`@ dataValues00a@ dataValues01b@ dataValues02c@ dataValues03_@ dataValues04џџџџ&џџџџџџџџџџџџvalueFormatџџџџ showValuesџџџџvalueTextFormatfontVerdanaџџџџsize џџџџcolorџџџџ underlineџџџџboldџџџџitalicџџџџџџџџ valueFormat 00 numFormatџџџџџџџџ1 numFormatџџџџџџџџ2 numFormatџџџџџџџџ3 numFormatџџџџџџџџ4 numFormatџџџџџџџџџџџџ0 numFormatџџџџџџџџџџџџshowXAxisTitleџџџџXAxisTitleTextFormatfontVerdanaџџџџsizeџџџџcolor™™™џџџџ underlineџџџџboldџџџџitalicџџџџџџџџ XAxisTitle XAxisTitleџџџџџџџџXAxisTitleFormatџџџџXAxisTitleFormat numFormatџџџџџџџџ showXAxisџџџџ XAxisColor™™™џџџџ XAxisWeightџџџџshowXAxisLabelsџџџџXAxisTextFormatfontVerdanaџџџџsize џџџџcolor@@@џџџџ underlineџџџџboldџџџџitalicџџџџџџџџ XAxisFormat numFormatџџџџџџџџshowYAxisTitleџџџџYAxisTitleTextFormatfontVerdanaџџџџsizeџџџџcolor™™™џџџџ underlineџџџџboldџџџџitalicџџџџџџџџ YAxisTitle YAxisTitleџџџџџџџџYAxisTitleFormatџџџџYAxisTitleFormat numFormatџџџџџџџџ showYAxisџџџџ YAxisColor™™™џџџџ YAxisWeightџџџџshowYAxisMajorTicksџџџџshowYAxisMinorTicksџџџџshowYAxisLabelsџџџџYAxisTextFormatfontVerdanaџџџџsize џџџџcolor@@@џџџџ underlineџџџџboldџџџџitalicџџџџџџџџ YAxisFormat numFormatџџџџџџџџplotAreaProps showBorderџџџџ borderColor333џџџџ borderWeightџџџџ showFillџџџџ fillColorпппџџџџџџџџshowYAxisMajorџџџџYAxisMajorWeightџџџџYAxisMajorColorЬЬЬџџџџshowYAxisMinorџџџџYAxisMinorWeightџџџџYAxisMinorColorщщщџџџџ numMajorџџџџ numMinorџџџџ autofocus autofocusfullџџџџfullgrowthoffџџџџminYџџџџmaxY@@џџџџzoomOutџџџџzoomInY@џџџџfixedLabelWidthџџџџ labelUnitAbv thousandsKџџџџ millionsMџџџџ b