📄 onlineexecl.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0044)http://www.irows.com/xo/EditSheet.do?id=1713 -->
<HTML><HEAD><TITLE>- iRows</TITLE>
<META http-equiv=content-type content="text/html; charset=UTF-8"><LINK
href="OnlineExecl.files/xo.css" type=text/css rel=stylesheet>
<SCRIPT src="OnlineExecl.files/xo.js" type=text/javascript></SCRIPT>
<SCRIPT src="OnlineExecl.files/model.js" type=text/javascript></SCRIPT>
<SCRIPT src="OnlineExecl.files/shui.js" type=text/javascript></SCRIPT>
<SCRIPT src="OnlineExecl.files/edit.js" type=text/javascript></SCRIPT>
<SCRIPT src="OnlineExecl.files/drag.js" type=text/javascript></SCRIPT>
<LINK href="image/favicon.ico" rel="shortcut icon">
<META content="MSHTML 6.00.2800.1522" name=GENERATOR></HEAD>
<BODY>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR id=fw_header>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%"
background=OnlineExecl.files/head_bg.png border=0>
<TBODY>
<TR>
<TD vAlign=top><IMG height=50 src="OnlineExecl.files/head_l.png"
width=15><A href="http://www.irows.com/xo/Welcome.do"><IMG
title=iRows.com height=40 alt=iRows.com
src="OnlineExecl.files/logo.png" width=100 align=top
border=0></A></TD>
<TD align=right><A class=headlink
href="http://www.irows.com/xo/SignIn.do">Sign in</A> | <A
class=headlink
href="http://www.irows.com/xo/Registration.do">Register</A> | <A
class=headlink
href="http://www.irows.com/xo/SearchSheets.do">Search</A> | <A
class=headlink href="http://www.irows.com/xo/About.do">About
iRows</A> | <A class=headlink
href="http://www.irows.com/xo/Feedback.do">Contact us</A> | <A
class=headlink href="http://www.irows.com/xo/News.do">What's new</A>
| <A class=headlink
onclick="mainhelp('http://www.irows.com/xo/HelpFAQ.do');return false"
href="http://www.irows.com/xo/EditSheet.do?id=1713#">Help</A> </TD>
<TD align=right width=15><IMG height=50
src="OnlineExecl.files/head_r.png"
width=15></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=top>
<TD><SPAN class=h1></SPAN><BR><IMG height=6
src="OnlineExecl.files/s.png" width=1><BR>
<SCRIPT type=text/javascript>var DS_canSave = falsevar DS_signedIn = falsevar DS_isOwner = falsevar DS_viewToAll = truevar DS_name = "Sales Demo"var DS_tags = "samples chart"var DS_label = ""var DS_desc = "Homepage sample sheet"var DS_isNew = falsevar DS_isDraft = falsevar DS_ownerId = "irows"</SCRIPT>
<SPAN class=docname id=docname> </SPAN> <SPAN id=author>by
irows</SPAN>
<TABLE class=menu_tb id=menu_tb cellSpacing=0 cellPadding=0
width="100%" border=0>
<TBODY>
<TR vAlign=top>
<TD>
<TABLE cellPadding=2 border=0>
<TBODY>
<TR vAlign=top>
<TD class=menu_opt onmousedown="PM_file();return false"
id=menu_file
onmouseover="this.className='menu_opt_on';PM_over_file()"
onmouseout="this.className='menu_opt'" noWrap>File</TD>
<TD class=menu_opt onmousedown="PM_edit();return false"
id=menu_edit
onmouseover="this.className='menu_opt_on';PM_over_edit()"
onmouseout="this.className='menu_opt'" noWrap>Edit</TD>
<TD class=menu_opt onmousedown="PM_format();return false"
id=menu_format
onmouseover="this.className='menu_opt_on';PM_over_format()"
onmouseout="this.className='menu_opt'" noWrap>Format</TD>
<TD class=menu_opt onmousedown="PM_insert();return false"
id=menu_insert
onmouseover="this.className='menu_opt_on';PM_over_insert()"
onmouseout="this.className='menu_opt'" noWrap>Insert</TD>
<TD class=menu_opt onmousedown="PM_data();return false"
id=menu_data
onmouseover="this.className='menu_opt_on';PM_over_data()"
onmouseout="this.className='menu_opt'" noWrap>Data</TD>
<TD class=menu_opt onmousedown="PM_colab();return false"
id=menu_colab
onmouseover="this.className='menu_opt_on';PM_over_colab()"
onmouseout="this.className='menu_opt'"
noWrap>Collaborate</TD>
<TD class=menu_opt onmousedown="PM_publish();return false"
id=menu_publish
onmouseover="this.className='menu_opt_on';PM_over_publish()"
onmouseout="this.className='menu_opt'"
noWrap>Publish</TD></TR></TBODY></TABLE></TD>
<TD></TD>
<TD align=right>
<TABLE cellPadding=2 border=0>
<TBODY>
<TR vAlign=center>
<TD noWrap><SPAN id=saveinfo>view only </SPAN></TD>
<TD noWrap><INPUT class=btn id=btndone title="Save and return" style="DISPLAY: none" onclick=onDone() type=button value=Done>
</TD>
<TD noWrap><INPUT class=btn id=btncancel onclick=onCancel() type=button value=Close>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<SCRIPT type=text/javascript>var winsize = getWindowSize()var w = Math.max(600, winsize.width - 80)var h = Math.max(300, winsize.height - 200)document.getElementById("menu_tb").style.width=w+"px"var SHUI_BASE = ''var initCmd = "Mc(M,{col:1,width:103});Mv(M,{row:2,col:1,type:\'text\',text:Mu(\'ABC%20Corp\'),value:Mu(\'ABC%20Corp\'),color:Mu(\'%23000000\'),bgcolor:Mu(\'%23ccccff\'),style:\'b\'});Mv(M,{row:4,col:1,type:\'null\',text:\'\',value:\'\',color:Mu(\'%23ffffff\'),bgcolor:Mu(\'%233366ff\')});Mv(M,{row:4,col:2,type:\'text\',text:Mu(\'%202004\'),value:Mu(\'%202004\'),color:Mu(\'%23ffffff\'),bgcolor:Mu(\'%233366ff\'),align:\'right\',style:\'b\'});Mv(M,{row:4,col:3,type:\'text\',text:Mu(\'%202005\'),value:Mu(\'%202005\'),color:Mu(\'%23ffffff\'),bgcolor:Mu(\'%233366ff\'),align:\'right\',style:\'b\'});Mv(M,{row:4,col:4,type:\'text\',text:\'Growth\',value:\'Growth\',color:Mu(\'%23ffffff\'),bgcolor:Mu(\'%233366ff\'),align:\'right\',style:\'b\'});Mv(M,{row:5,col:1,type:\'text\',text:\'Q1\',value:\'Q1\',color:Mu(\'%23ffff33\'),bgcolor:Mu(\'%233366ff\'),style:\'b\'});Mv(M,{row:5,col:2,type:\'number\',text:\'300000\',value:300000,pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%24300%2C000\')});Mv(M,{row:5,col:3,type:\'number\',text:\'400000\',value:400000,pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%24400%2C000\')});Mv(M,{row:5,col:4,type:\'number\',text:Mu(\'%3DC5/B5-1\'),value:0.33333333333333326,color:Mu(\'%23660000\'),bgcolor:Mu(\'%23ffffff\'),pattern:Mu(\'n%3Ay02%25-\'),formattedValue:Mu(\'33.33%25\'),requires:[{row:5,col:3},{row:5,col:2}]});Mv(M,{row:6,col:1,type:\'text\',text:\'Q2\',value:\'Q2\',color:Mu(\'%23ffff33\'),bgcolor:Mu(\'%233366ff\'),style:\'b\'});Mv(M,{row:6,col:2,type:\'number\',text:\'380000\',value:380000,pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%24380%2C000\')});Mv(M,{row:6,col:3,type:\'number\',text:\'363000\',value:363000,pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%24363%2C000\')});Mv(M,{row:6,col:4,type:\'number\',text:Mu(\'%3DC6/B6-1\'),value:-0.044736842105263186,color:Mu(\'%23660000\'),bgcolor:Mu(\'%23ffffff\'),pattern:Mu(\'n%3Ay02%25-\'),formattedValue:Mu(\'-4.47%25\'),requires:[{row:6,col:3},{row:6,col:2}]});Mv(M,{row:7,col:1,type:\'text\',text:\'Q3\',value:\'Q3\',color:Mu(\'%23ffff33\'),bgcolor:Mu(\'%233366ff\'),style:\'b\'});Mv(M,{row:7,col:2,type:\'number\',text:\'280000\',value:280000,pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%24280%2C000\')});Mv(M,{row:7,col:3,type:\'number\',text:\'480000\',value:480000,pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%24480%2C000\')});Mv(M,{row:7,col:4,type:\'number\',text:Mu(\'%3DC7/B7-1\'),value:0.7142857142857142,color:Mu(\'%23660000\'),bgcolor:Mu(\'%23ffffff\'),pattern:Mu(\'n%3Ay02%25-\'),formattedValue:Mu(\'71.43%25\'),requires:[{row:7,col:3},{row:7,col:2}]});Mv(M,{row:8,col:1,type:\'text\',text:\'Q4\',value:\'Q4\',color:Mu(\'%23ffff33\'),bgcolor:Mu(\'%233366ff\'),style:\'b\'});Mv(M,{row:8,col:2,type:\'number\',text:\'200000\',value:200000,pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%24200%2C000\')});Mv(M,{row:8,col:3,type:\'number\',text:\'510000\',value:510000,pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%24510%2C000\')});Mv(M,{row:8,col:4,type:\'number\',text:Mu(\'%3DC8/B8-1\'),value:1.55,color:Mu(\'%23660000\'),bgcolor:Mu(\'%23ffffff\'),pattern:Mu(\'n%3Ay02%25-\'),formattedValue:Mu(\'155.00%25\'),requires:[{row:8,col:3},{row:8,col:2}]});Mv(M,{row:9,col:1,type:\'text\',text:Mu(\'Year%20Total\'),value:Mu(\'Year%20Total\'),color:Mu(\'%23ffff33\'),bgcolor:Mu(\'%233366ff\'),style:\'bi\'});Mv(M,{row:9,col:2,type:\'number\',text:Mu(\'%3Dsum%28B5%3AB8%29\'),value:1160000,color:Mu(\'%23660000\'),bgcolor:Mu(\'%23cc9933\'),pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%241%2C160%2C000\'),requires:[{startRow:5,startCol:2,endRow:8,endCol:2}]});Mv(M,{row:9,col:3,type:\'number\',text:Mu(\'%3Dsum%28C5%3AC8%29\'),value:1753000,color:Mu(\'%23660000\'),bgcolor:Mu(\'%23cc9933\'),pattern:Mu(\'n%3Ay00%24-\'),formattedValue:Mu(\'%241%2C753%2C000\'),requires:[{startRow:5,startCol:3,endRow:8,endCol:3}]});Mv(M,{row:9,col:4,type:\'number\',text:Mu(\'%3DC9/B9-1\'),value:0.5112068965517242,color:Mu(\'%23660000\'),bgcolor:Mu(\'%23cc9933\'),pattern:Mu(\'n%3Ay02%25-\'),style:\'b\',formattedValue:Mu(\'51.12%25\'),requires:[{row:9,col:3},{row:9,col:2}]});Mi(M,{row:1,col:5,offX:9,offY:8,chart:\'columns\',fromRow:4,fromCol:1,toRow:8,toCol:3,incols:true,legend:true,d3:true,title:Mu(\'Our%20Sales\'),titlex:\'Quarter\',titley:\'Sales\'});"tableUI = new SheetUI(initCmd, DS_ownerId)tableUI.sheetSize = { width: w - 16 - 2, height:h }tableUI.generateSheet()</SCRIPT>
<INPUT id=id type=hidden value=1713 name=id>
<FORM id=export action=Export.do method=post><INPUT id=exp_id
type=hidden value=1713 name=id> <INPUT id=exp_owner type=hidden
name=ownerId> <INPUT id=exp_data type=hidden name=data> <INPUT
id=exp_name type=hidden name=name> <INPUT id=exp_type type=hidden
name=type> </FORM>
<DIV id=espop
style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; DISPLAY: none; Z-INDEX: 100; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; POSITION: absolute">
<TABLE cellSpacing=0 cellPadding=2 bgColor=#f7f7f7 border=0>
<TBODY>
<TR>
<TD id=espopb></TD></TR>
<TR>
<TD>
<TD><IMG id=espopbtm height=1 src="OnlineExecl.files/s.png"
width=1></TD></TR></TD></TBODY></TABLE></DIV><IMG id=dlgbg
style="DISPLAY: none; Z-INDEX: 100; FILTER: alpha(opacity=50); POSITION: absolute"
src="OnlineExecl.files/dlg_gp.png"> <IMG id=dlgtitlehnd
style="DISPLAY: none; Z-INDEX: 102; CURSOR: move; POSITION: absolute"
height=12 src="OnlineExecl.files/s.png">
<DIV id=dlg
style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; DISPLAY: none; Z-INDEX: 101; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid; POSITION: absolute">
<TABLE cellSpacing=0 cellPadding=2 bgColor=#f6f6f6 border=0>
<TBODY>
<TR class=dlghd>
<TD id=dlgtitle></TD>
<TD><IMG onmousedown=closeModalDlg() title=Close height=12
src="OnlineExecl.files/dlg_close.png" width=12
align=right></TD></TR>
<TR>
<TD id=dlgb></TD></TR></TBODY></TABLE></DIV>
<SCRIPT type=text/javascript>var name = "Sales Demo" if (name == "") name = "New data sheet"document.title = name + " - iRows" document.getElementById("docname").innerHTML = namewindow.setTimeout('checkDraftSave()', autosaveTime)window.setTimeout('sessionKeepAlive()', sessionKeepAliveTime)window.onresize = onResize</SCRIPT>
</TD>
<TD> </TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD height=10></TD></TR>
<TR bgColor=#c0c0c0>
<TD height=1></TD></TR>
<TR>
<TD height=10></TD></TR>
<TR id=fw_footer>
<TD class=footer>Copyright © 2006 iRows.com . All rights reserved. <A
href="http://www.irows.com/xo/Terms.do">Terms of service</A> <A
href="http://www.irows.com/xo/Privacy.do">Privacy policy</A> <A
href="http://www.irows.com/xo/Feedback.do">Send us feedback</A> <A
href="http://www.irows.com/xo/SearchSheets.do">Search</A> <A
href="http://www.irows.com/xo/About.do">About iRows</A> <A
href="http://www.irows.com/xo/Press.do">Press</A> <A
href="http://www.irows.com/xo/News.do">What's new</A>
</TD></TR></TBODY></TABLE></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -