Spreadsheet Element Sharing through Synchronization

6SUHDGVKHHW(OHPHQW6KDULQJWKURXJK6\QFKURQL]DWLRQ



0DVVLPR0DUHVFD &,3,±8QLYRI*HQRYD,WDO\DQG,&6,%HUNHOH\&$ PDVVLPRPDUHVFD#XQLJHLW 3LHUSDROR%DJOLHWWR &,3,±8QLYRI*HQRYD,WDO\ SEDJOLHWWR#FLSLXQLJHLW   Abstract²:H FRQVLGHU WKH FDVH RI VSUHDGVKHHW EDVHG

ZRUNJURXS FROODERUDWLRQ LQ ZKLFK XVHUV FRRSHUDWH WKURXJK VSUHDGVKHHWV :KLOH VSUHDGVKHHW H[FKDQJH WKURXJK HPDLO DQG VKDUHG GLUHFWRULHV LV VWLOO WKH PRVW FRPPRQ ZD\ WR VKDUH GDWD VSUHDGVKHHWVKDULQJLQWKH&ORXGLVUDSLGO\VSUHDGLQJOHYHUDJLQJ WKH HYROXWLRQ RI RIILFH WRROV WRZDUG GHORFDOL]HG V\VWHP RYHU WKH &ORXG,QWKLVSDSHUZHREVHUYHWKDWVSUHDGVKHHWVKDULQJWKURXJK GHORFDOL]DWLRQ GRHV QRW VXSSRUW LQIRUPDWLRQ FRQILGHQWLDOLW\ DQG LQWURGXFH WKH FRQFHSW RI VSUHDGVKHHW VKDULQJ WKURXJK V\QFKURQL]DWLRQLQZKLFKERWKSURFHVVLQJDQGVWRUDJHPDLQWDLQ WKHLUORFDOL]DWLRQLQWKHXVHUV\VWHPVZKLOHD&ORXGSODWIRUPWDNHV FDUHRIV\QFKURQL]DWLRQ)LQDOO\ZHIRFXVRQ6SUHDGVKHHW(OHPHQW 6\QFKURQL]DWLRQ LQ ZKLFK V\QFKURQL]DWLRQ ZRUNV DW WKH FHOO JUDQXODULW\UDWKHUWKDQDWWKHILOHJUDQXODULW\DQGVKRZVRPHXVH FDVHVWKHGHPRQVWUDWHLWVVXSHULRULW\

Keywords—spreadsheets; collaboration; sharing , ,1752'8&7,21 6SUHDGVKHHWVDUHSUREDEO\WKHEHVWNQRZQIRUPRI(QG8VHU 3URJUDPPLQJ>@>@7KHKXJHQXPEHURIVSUHDGVKHHWXVHUVDQG SURJUDPPHUV>@GHPRQVWUDWHVWKHKLJKLPSDFWRIVSUHDGVKHHW UHVHDUFKDQGPRWLYDWHVDQHQJLQHHULQJDSSURDFK>@5HFHQWO\ VSUHDGVKHHWVKDYHHYROYHGIURPSHUVRQDORIILFHWRROVDLPHGDW LPSURYLQJSHRSOHSURGXFWLYLW\WRHQWHUSULVHOHYHOWRROVDLPHGDW VXSSRUWLQJ ZRUNJURXS FROODERUDWLRQ >@ >@ DQG GLVWULEXWHG DQDO\WLFV >@ ,Q ZRUNJURXS FROODERUDWLRQ XVHUV HQWHU GDWD GHULYLQJ IURP ORFDO DFWLYLWLHV PDNH VXFK GDWD RI SDUW RI LW DYDLODEOH WR RWKHU XVHUV DQG FRPELQH WKH GDWD REWDLQHG IURP RWKHU XVHUV ZLWK ORFDO GDWD 7KH IDFW WKDW VSUHDGVKHHWEDVHG ZRUNJURXS FROODERUDWLRQ KDV EHFRPH D GRPLQDQW SDUDGLJP LV GHPRQVWUDWHG E\ WKH FRPPRQ SUDFWLFH RI H[FKDQJLQJ VSUHDGVKHHWDWWDFKPHQWVRYHUHPDLO+RZHYHUVXFKDSUDFWLFH KDVQRWEHHQHQJLQHHUHGVRIDULQSDUWLFXODUXVHUVFRQWUROWDEOH H[FKDQJHXSGDWHPDQXDOO\WKURXJKFRS\SDVWHDWWDFKWRHPDLO H[WUDFWIURPHPDLO RSHUDWLRQV 8QVXSHUYLVHG GDWD VKDULQJ DQG FLUFXODWLRQ RIWHQ OHDGV WR HUURUV RU DW WKH YHU\ OHDVW WR LQFRQVLVWHQFLHVGDWDORVVHVDQGSUROLIHUDWLRQRIPXOWLSOHFRSLHV WKHVRFDOOHG³0XOWLSOH9HUVLRQVRIWKH7UXWK´

7R LPSURYH VSUHDGVKHHWEDVHG :RUNJURXS &ROODERUDWLRQ WKHPDMRU,7FRPSDQLHVHJ0LFURVRIWDQG*RRJOHEXWDOVR SER[=RKRDQGRWKHUVKDYHLQWURGXFHGWKHVKDULQJSDUDGLJP >@>@ZKLFKOHYHUDJHV&ORXGFRPSXWLQJWKURXJKWKH6RIWZDUH DVD6HUYLFHSDUDGLJP8QIRUWXQDWHO\VXFKDSDUDGLJPGRHVQRW SURYLGHWKHIXQFWLRQDOLWLHVWKDWDV\VWHPVXSSRUWLQJZRUNJURXS FROODERUDWLRQ PXVW SURYLGH ,Q SDUWLFXODU LW LV QRW FRPSDWLEOH ZLWK LQIRUPDWLRQ FRQILGHQWLDOLW\ DV SURFHVVLQJ WDNHV SODFH LQ &ORXGVHUYHUVZKLFKLPSOLHVWKDWVSUHDGVKHHWV PXVWUHVLGHLQ VXFKVHUYHUVLQWKHFOHDU(QWHUSULVHVDQGSURIHVVLRQDOXVHUVWHQG WRUHMHFWVXFKDVROXWLRQEHFDXVHWKH\RSHUDWHRQVHQVLWLYHGDWD

2Q WKH FRQWUDU\ WKH 6WRUDJH DV D 6HUYLFH SDUDGLJP LV FRPSDWLEOH ZLWK FRQILGHQWLDOLW\ DV DSSURSULDWH HQFU\SWLRQ V\VWHPVFDQLQVXODWHWKHHQWHUSULVHWUXVWHGHQYLURQPHQWIURPWKH H[WHUQDOVWRUDJHVHUYLFHDQGJXDUDQWHHWKDWQRGDWDLQWKHFOHDU HYHUH[LWVWKHWUXVWHGHQYLURQPHQW+RZHYHULWGRHVQRWIXOO\ VXSSRUWVKDULQJDVWKHLQWHUIDFHH[SRVHGE\WKHH[WHUQDO6WRUDJH 6HUYLFHLVW\SLFDOO\WKDWRID)LOH0DQDJHPHQW6\VWHPDQGDVD FRQVHTXHQFHRQO\ZRUNVDWWKHILOHJUDQXODULW\

,Q WKH SDSHU ZH SURSRVH D QHZ VROXWLRQ WR VSUHDGVKHHW VKDULQJ EDVHG RQ 6SUHDGVKHHW 6\QFKURQL]DWLRQ 7KH SURSRVHG VROXWLRQ OHDYHV SURFHVVLQJ LQ WKH XVHU GHVNWRS ZKLFK LV D SUHUHTXLVLWHWRJXDUDQWHHFRQILGHQWLDOLW\,WDOVROHDYHVVWRUDJHLQ WKHXVHUDGPLQLVWUDWLYHGRPDLQVDQGWDNHVDGYDQWDJHRID&ORXG VHUYHU WR PDLQWDLQ WKH XVHU VSUHDGVKHHWV V\QFKURQL]HG7KH GLVWLQFWLYHIHDWXUHRIWKHSURSRVHGVROXWLRQLVWKDWLWGRHVQRWXVH ³ILOH´DVDQDWRPLFVKDULQJHOHPHQW2QWKHFRQWUDU\LWXVHVD ILQHU JUDLQ XQLW RI GDWD FDOOHG 6SUHDGVKHHW (OHPHQW ZKLFK FRUUHVSRQGVWRDFHOOUDQJHDWDEOHRUDZRUNVKHHWDVDQDWRPLF VWRUDJHHOHPHQW

6SUHDGVKHHWV LQWHUDFW ZLWK HDFK RWKHU RYHU D YLUWXDO VSDFH DQG VKDUH 6SUHDGVKHHW (OHPHQWV 6SUHDGVKHHW LQWHUDFWLRQ LV VXSSRUWHGE\DVSUHDGVKHHWSODWIRUPH[WHQVLRQLQSDUWLFXODUZH KDYHGHYHORSHGD0LFURVRIW([FHO$GGLQDQGE\D&ORXGVHUYHU

7KH SDSHU SURFHHGV DV IROORZV ,Q VHFWLRQ ,, ZH GHVFULEH VSUHDGVKHHW VKDULQJ WKURXJK GHORFDOL]DWLRQ LQ 6HFWLRQ ,,, ZH LQWURGXFH 6SUHDGVKHHW 6KDULQJ WKURXJK 6\QFKURQL]DWLRQ ZKLOH LQ6HFWLRQ,9ZHIRFXVRQ6SUHDGVKHHW(OHPHQW6KDULQJWKURXJK 6\QFKURQL]DWLRQ 7KHQ LQ 6HFWLRQ 9 ZH SUHVHQW D VWUXFWXUHG FROODERUDWLRQIUDPHZRUNEDVHGRQ6SUHDGVKHHW(OHPHQW6KDULQJ FDOOHG6SUHDGVKHHW2YHUOD\LQ6HFWLRQ9,ZHSUHVHQWVRPHXVH FDVHV ZKLOH LQ 6HFWLRQ 9,, GHVFULEH WKH IHHGEDFN WKDW ZH REWDLQHGIURPDVHWRISLORWV)LQDOO\LQ6HFWLRQ9,,,ZHSURYLGH DFRQFOXGLQJUHPDUN

,, 635($'6+((76+$5,1*7+528*+'(/2&$/,=$7,21 3HRSOHWUDGLWLRQDOO\FROODERUDWHE\H[FKDQJLQJVSUHDGVKHHWV WKURXJK HPDLO RU VKDUHG GLUHFWRULHV 7KH IDFW WKDW VSUHDGVKHHW RSHUDWLRQ LH VSUHDGVKHHW FUHDWLRQ HGLWLQJ DQG VDYLQJ LV GHFRXSOHG IURP VSUHDGVKHHW H[FKDQJH OHDGV WR HUURUV DQG LQFRQVLVWHQFLHV

6SUHDGVKHHW EDVHG FROODERUDWLRQ KDV UHFHQWO\ HYROYHG WR VSUHDGVKHHWVKDULQJZKLFKLQWHJUDWHVVSUHDGVKHHWRSHUDWLRQDQG VSUHDGVKHHWH[FKDQJHDQGVRUHGXFHVHUURUVDQGLQFRQVLVWHQFLHV 6KDULQJ GLUHFWO\ OHYHUDJHV &ORXG &RPSXWLQJ WR EH SUHFLVH ZKLOH WKH SULPDU\ JRDOV RI &ORXG &RPSXWLQJ DUH VWRUDJH GHORFDOL]DWLRQ 6WRUDJH DV D 6HUYLFH DQG SURFHVVLQJ GHORFDOL]DWLRQ 6RIWZDUH DV D 6HUYLFH LW LV WUXH WKDW D VLGH

EHQHILWRI&ORXG&RPSXWLQJLVWKHVXSSRUWRIVKDUHGDFFHVVWRD GHORFDOL]HGUHVRXUFH :KHQVKDULQJLVEDVHGRQ6WRUDJHDVD6HUYLFH)LJWKH GDWDPRYHVWRWKH&ORXGZKLOHSURFHVVLQJUHPDLQVLQWKHXVHU V\VWHPV6XFKDQRUJDQL]DWLRQSUHVHUYHVIXOOFRPSDWLELOLW\ZLWK GHVNWRSVSUHDGVKHHWRSHUDWLRQDVWKH6SUHDGVKHHW3ODWIRUPLH WKH SURJUDP WKDW RSHUDWHV RQ VSUHDGVKHHWV HJ 0LFURVRIW ([FHOVWLOOUXQVLQWKHGHVNWRS7KH&ORXGVWRUDJHH[SRVHVD )LOH 6\VWHP LQWHUIDFH WR WKH DSSOLFDWLRQ SURJUDPV DQG LQ SDUWLFXODU WR WKH 6SUHDGVKHHW 3ODWIRUP RYHU WKH QHWZRUN 6KDULQJOHYHUDJHVWKHILOHORFNLQJFDSDELOLW\W\SLFDOO\SURYLGHG E\)LOH6\VWHPV

+RZHYHU 6RIWZDUH DV D 6HUYLFH UDWKHU WKDQ 6WRUDJH DV D 6HUYLFHLVWKHPRVWFRPPRQSDUDGLJPIRUVSUHDGVKHHWVKDULQJ ,WVGLIIXVLRQGHULYHVIURPWKHIDFWWKDWERWK*RRJOH'RFVDQG 0LFURVRIW 2IILFH  XVH LW 7KH HYROXWLRQIURP 6WRUDJH DV D 6HUYLFH WR 6RIWZDUH DV D 6HUYLFH FDQ EH VHHQ DV D WZRVWHS SURFHVV7KHILUVWVWHSVKRZQLQ)LJ2OHDGVWRDV\VWHPZKLFK GLIIHUVIURPWKH6WRUDJHDVD6HUYLFHSDUDGLJPLQWKHIDFWWKDW WKH6SUHDGVKHHW3ODWIRUPVUXQLQWKH&ORXGUDWKHUWKDQLQWKH XVHUGHVNWRSVDQGWKDWVSUHDGVKHHWRSHUDWLRQLVRUJDQL]HGDVD :HE $SSOLFDWLRQ LQ ZKLFK WKH EURZVHU SURYLGHV WKH XVHU LQWHUIDFHZKHUHDVWKH6SUHDGVKHHW3ODWIRUPSURYLGHVSURFHVVLQJ



)LJ6SUHDGVKHHW6KDULQJ6WRUDJHDVD6HUYHU

7KHVHFRQGVWHSVKRZQLQ)LJOHDGVWRDV\VWHPLQZKLFK D VLQJOH 6SUHDGVKHHW 3ODWIRUP UHSODFHV WKH VHSDUDWH XVHU 6SUHDGVKHHW 3ODWIRUPV 7KH VLQJOH 6SUHDGVKHHW 3ODWIRUP PDQDJHVGDWDVKDULQJDWWKHDSSOLFDWLRQOHYHOUDWKHUWKDQDWWKH )LOH6\VWHPOHYHO

7KH ³6RIWZDUH DV D 6HUYLFH´SDUDGLJP ZHOO PDWFKHV WKH EXVLQHVVPRGHORIWKRVHFRPSDQLHVOLNH*RRJOHWKDWSURYLGH IUHH VHUYLFHV LQ H[FKDQJH RI XVHU LQIRUPDWLRQ 7KH IDFW WKDW SURFHVVLQJWDNHVSODFHLQWKH&ORXGLVDWHFKQLFDOMXVWLILFDWLRQRI WKHIDFWWKDWWKHGDWDPXVWUHDFKWKH&ORXGLQWKHFOHDUDQGWKDW DVDFRQVHTXHQFHWKHFRPSDQ\WKDWRSHUDWHVWKH&ORXGVHUYHU FDQORRNDWWKHGDWD$VDFRQVHTXHQFHDVLJQLILFDQWZHDNQHVV RIVSUHDGVKHHWVKDULQJWKURXJK³6RIWZDUHDVD6HUYLFH´LVWKDW VXFKDVROXWLRQGRHVQRWVXSSRUWLQIRUPDWLRQFRQILGHQWLDOLW\   )LJ6SUHDGVKHHW6KDULQJIURP6WRUDJHDVD6HUYLFHWR6RIWZDUHDV D6HUYLFH  

)LJ  6SUHDGVKHHW VKDULQJ 6RIWZDUH DV D 6HUYLFH RQ D VLQJOH 6SUHDGVKHHW3ODWIRUP

$ VHFRQG ZHDNQHVV LV WKDW WKH *UDSKLFDO 8VHU ,QWHUIDFH SURYLGHGE\:HE$SSOLFDWLRQVFDQQRWEHWKHVDPHDVWKHRQH

86(5



86(5



& / 2 8 '

)LOH6\VWHP



6SUHDGVKHHW 3ODWIRUP )LOH6\VWHP 3ULPLWLYHV 6SUHDGVKHHW



3ODWIRUP



)LOH6\VWHP



3ULPLWLYHV



1HWZRUN

1HWZRUN

)LOH6\VWHP 3ULPLWLYHV +70/



86(5



86(5



)LOH6\VWHP



3ULPLWLYHV



& / 2 8 '

)LOH6\VWHP



%URZVHU %URZVHU



6SUHDGVKHHW



3ODWIRUP



6SUHDGVKHHW



3ODWIRUP



+70/



+70/



86(5



_86(5

_

& / 2 8 '

)LOH6\VWHP



%URZVHU )LOH6\VWHP 3ULPLWLYHV %URZVHU



6SUHDGVKHHW



3ODWIRUP



+70/



1HWZRUN

SURYLGHGE\VWDQGDORQHDSSOLFDWLRQVPDLQO\EHFDXVHWKHODWHQF\ LQWURGXFHGE\WKHQHWZRUNGRHVQRWDOORZREWDLQLQJWKHVDPH ORRNDQGIHHOWKDWORFDOSURFHVVLQJDOORZVREWDLQLQJ,QDGGLWLRQ &ORXG EDVHG VSUHDGVKHHW SODWIRUPV GR QRW RIIHU FRPSOHWH EDFNZDUGFRPSDWLELOLW\ZLWKGHVNWRSVSUHDGVKHHWSODWIRUPVDQG LQSDUWLFXODUZLWKWKHGHVNWRSYHUVLRQRI0LFURVRIW([FHOZKLFK LVE\IDUWKHPRVWSHUYDVLYHVSUHDGVKHHWSODWIRUPLQWKHZRUOG ,QWHUHVWLQJO\ WKLV OLPLWHG FRPSOLDQFH DSSOLHV QRW RQO\ WR *RRJOHDVRQHZRXOGH[SHFWEXWDOVRWR0LFURVRIW2IILFHLQWKH &ORXG

,,, 635($'6+((76+$5,1*7+528*+6<1&+521,=$7,21 )LOH 6\QFKURQL]DWLRQ LV D GLIIHUHQW ZD\ WR REWDLQ VKDULQJ 7KHLGHDLQWKLVFDVHLVWRKDYHWKHVSUHDGVKHHWVUHVLGHLQWKH XVHU)LOH6\VWHPDQGWKH6SUHDGVKHHW3ODWIRUPUXQLQWKHXVHU V\VWHPDVLWXVHGWRKDSSHQLQWKHSUH&ORXGGD\VDQGWRFRXQW RQDQH[WHUQDO)LOH6\QFKURQL]DWLRQ3ODWIRUPLPSOHPHQWHGDVD &ORXGVHUYLFHWRV\QFKURQL]HVSUHDGVKHHWV)LJ  )LJ6SUHDGVKHHW6\QFKURQL]DWLRQ

6XFK D )LOH 6\QFKURQL]DWLRQ 3ODWIRUP LV RUJDQL]HG DV D &OLHQW6HUYHU V\VWHP WKH VHUYHU FRPSRQHQW LGHQWLILHG DV WKH 6\QF&RRUGLQDWRULQ)LJUXQVLQWKH&ORXGZKHUHDVWKHFOLHQW FRPSRQHQWVLGHQWLILHGDV/RFDO6\QF$JHQWVLQ)LJUXQLQ WKH XVHU V\VWHPV 7KH XVHUV PXVW FRQILJXUH WKH )LOH 6\QFKURQL]DWLRQ3ODWIRUPWRJLYHLWWKHDSSURSULDWHDFFHVVULJKWV WRRSHUDWHRQWKHORFDO)LOH6\VWHP

(YHQ LQ WKH FDVH LQ ZKLFK VKDULQJ LV VXSSRUWHG E\ V\QFKURQL]DWLRQ D ORFNLQJ PHFKDQLVP PXVW EH SURYLGHG WR KDQGOHDFFHVVFRQIOLFWVLHWKHVLPXOWDQHRXVDWWHPSWRIWZRRU PRUH XVHUV WR XSGDWH D VKDUHG VSUHDGVKHHW %HIRUH RSHQLQJ D VSUHDGVKHHW WKH 6SUHDGVKHHW 3ODWIRUP PXVW DVN WKH )LOH 6\QFKURQL]DWLRQ3ODWIRUPWKHDSSURSULDWHSHUPLVVLRQWRRSHQLW $W WKH UHFHSWLRQ RI VXFK D UHTXHVW WKH )LOH 6\QFKURQL]DWLRQ

3ODWIRUPFKHFNVZKHWKHUWKHVSUHDGVKHHWLVXQORFNHGDQGLILW LV LW ORFNV LW 7KHQ RSHQLQJ DQG RSHUDWLRQ FDQ SURFHHG $QDORJRXVO\ D VSUHDGVKHHW FORVH RSHUDWLRQ ILUVW DFWLYDWHV V\QFKURQL]DWLRQ LH WKH DXWRPDWLF DOLJQPHQW RI DOO WKH VSUHDGVKHHW FRSLHV ZLWK WKH FORVLQJ VSUHDGVKHHW DQG WKHQ XQORFNVWKHVSUHDGVKHHW

7KH DGYDQWDJHV RI VSUHDGVKHHW VKDULQJ WKURXJK V\QFKURQL]DWLRQRYHUVSUHDGVKHHWVKDULQJWKURXJKGHORFDOL]DWLRQ DUH PDLQO\ FRQFHUQHG ZLWK FRQILGHQWLDOLW\ 7KH 6SUHDGVKHHW 6\QFKURQL]DWLRQ 3ODWIRUP PD\ WDNH DGYDQWDJH RI HQGWRHQG DV\PPHWULF FU\SWRJUDSK\ WR JXDUDQWHH WKDW WKH VKDUHG VSUHDGVKHHWVQHYHUOHDYHWKHSULYDWHXVHUGRPDLQLQWKHFOHDU

,Q SDUWLFXODU WKH /RFDO 6\QF $JHQW RI WKH XVHU WKDW KDV XSGDWHG D VSUHDGVKHHW SHUIRUPV WKH IROORZLQJ VHTXHQFH RI RSHUDWLRQV

)RUHDFKUHPRWHVSUHDGVKHHWWREHV\QFKURQL]HG  LWJHQHUDWHVDV\PPHWULFHQFU\SWLRQNH\

 LW HQFU\SWV WKH VSUHDGVKHHW WKURXJK VXFK D NH\ XVLQJ V\PPHWULFFU\SWRJUDSK\

 LWLQFOXGHVWKHNH\LQDFHUWLILFDWH

 LWHQFU\SWVVXFKDFHUWLILFDWHXVLQJWKHSXEOLFNH\RIWKH WDUJHWXVHUXVLQJDV\PPHWULFFU\SWRJUDSK\

 LW FUHDWHV D GDWD EXQGOH WKDW LQFOXGHV WKH HQFU\SWHG FHUWLILFDWHDQGWKHHQFU\SWHGVSUHDGVKHHW  LWVHQGVWKHGDWDEXQGOHWRWKH6\QFK&RRUGLQDWRUDQG WKURXJKLWWRWKHDSSURSULDWH/RFDO6\QF$JHQWV  ,WLVZRUWKQRWLFLQJWKDWVKDULQJWKURXJKV\QFKURQL]DWLRQDOVR DSSOLHVWRWKH6WRUDJHDVD6HUYLFHSDUDGLJPZLWKWKHGLIIHUHQFH WKDW ZKHQ XVLQJ WKH 6WRUDJH DV D 6HUYLFH SDUDGLJP WKH VSUHDGVKHHWVUHVLGHLQWKH&ORXGVWRUDJHUDWKHUWKDQLQWKHXVHU )LOH6\VWHP &RQVLGHULQJWKDWWREHSURWHFWHGIURPXQDXWKRUL]HGDFFHVV ERWKIURPXVHUVDQGIURPWKH&ORXGRSHUDWRUVSUHDGVKHHWVPXVW EHVWRUHGLQWKH&ORXGLQHQFU\SWHGIRUPWRRSHQDVSUHDGVKHHW WKH6SUHDGVKHHW3ODWIRUPZKLFKUXQVLQWKHXVHUGHVNWRSODSWRS PXVWSHUIRUPWKHIROORZLQJVHTXHQFHRIRSHUDWLRQV  LWUHTXHVWVH[FOXVLYHDFFHVVWRWKHVSUHDGVKHHWIURPWKH &ORXGVWRUDJH  LWGRZQORDGVWKHVSUHDGVKHHWDQG  LWGHFU\SWVWKHVSUHDGVKHHW 7KHQDWFORVLQJWKH6SUHDGVKHHW3ODWIRUPPXVWSHUIRUPWKH IROORZLQJVHTXHQFHRIRSHUDWLRQV  LWHQFU\SWVWKHXSGDWHGVSUHDGVKHHW  LWXSORDGVLWWRWKH&ORXGVWRUDJHDQG  LWUHOHDVHVWKHH[FOXVLYHDFFHVVWRWKHVSUHDGVKHHW $Q HQGWRHQG PHFKDQLVP IRU NH\ PDQDJHPHQW PXVW EH SURYLGHGWRKDYHWKH&ORXGVWRUDJHSOD\WKHUROHRIDSDVVLYH UHSRVLWRU\ RI HQFU\SWHG VSUHDGVKHHWV ,W IROORZV WKDW ZKHQ FRQILGHQWLDOLW\ LV D UHTXLUHPHQW WKH 6WRUDJH DV D 6HUYHU SDUDGLJPGRHVQRWDXWRPDWLFDOO\VXSSRUWVVKDULQJDVLWGRHVLI FRQILGHQWLDOLW\LVQRWDUHTXLUHPHQW $VIDUDV6RIWZDUHDVD6HUYLFHLVFRQFHUQHGVLPSO\WKHUHLV QRZD\WRJXDUDQWHHLQIRUPDWLRQFRQILGHQWLDOLW\DVVSUHDGVKHHWV PXVWUHVLGHLQWKH&ORXGVHUYHULQWKHFOHDUWREHSURFHVVHGE\ WKH6SUHDGVKHHW3ODWIRUPUXQQLQJLQWKH&ORXG

86(5



6\QF&RRUGLQDWRU

86(5



& / 2 8 '

6SUHDGVKHHW 3ODWIRUP

1HWZRUN

)LOH



6\VWHP



/RFDO6\QF$JHQW 6SUHDGVKHHW



3ODWIRUP



)LOH



6\VWHP



/RFDO6\QF$JHQW



,9 635($'6+((7(/(0(176+$5,1*7+528*+ 6<1&+521,=$7,21 )LOH6\QFKURQL]DWLRQGRHVQRWH[KLELWDQ\VSUHDGVKHHWDZDUH IXQFWLRQDOLW\:HVHHWKDWDVDOLPLWDWLRQFRQVLGHULQJWKDWYHU\ RIWHQLQZRUNJURXSFROODERUDWLRQLWKDSSHQVWKDWXVHUVZLVKWR VKDUHRQO\SDUWRIWKHLUVSUHDGVKHHWV)RUH[DPSOH8VHU$PD\ ZDQWWRVKDUHDUDQJHZLWK8VHU%DQGDQRWKHUUDQJHZLWK8VHU &ZKLOH8VHU&LVQRWVXSSRVHGWRVHHWKHUDQJHVKDUHGZLWK8VHU %7KHILOHJUDQXODULW\SUHYHQWVVXFKDSRVVLELOLW\XQOHVV8VHU$ FUHDWHVFRSLHVRIWKHUDQJHVWREHVKDUHGLQGLIIHUHQWILOHVDQG VKDUHVVXFKILOHV7KLVLVDQXQDFFHSWDEOHEXUGHQIRUXVHUVZKR PD\HQGXSPDNLQJPLVWDNHVXVLQJREVROHWHGDWDYHUVLRQVHWF 7KH SRLQW WKHUHIRUH LV WR PLJUDWH IURP ILOH JUDQXODULW\ WR 6SUHDGVKHHW(OHPHQWJUDQXODULW\LHIURP)LOH6\QFKURQL]DWLRQ WR6SUHDGVKHHW(OHPHQW6\QFKURQL]DWLRQZKHUHD6SUHDGVKHHW (OHPHQWLVDFHOOUDQJHDWDEOHRUDZRUNVKHHW:HUHPLQGWKDW DFHOOUDQJHLVDIL[HGVL]HDUUD\RIFHOOVDWDEOHLVDYDULDEOHVL]H OLVW RI UHFRUGV ZKLOH D ZRUNVKHHW LV D FRPSOHWH VKHHW WKDW LQFOXGHVFHOOUDQJHVWDEOHVDQGFKDUWV

6SUHDGVKHHW (OHPHQW 6\QFKURQL]DWLRQ UHTXLUHV WKDW V\QFKURQL]DWLRQ PXVW EH VSUHDGVKHHWDZDUH LH PDQDJHG E\ WKH6SUHDGVKHHW3ODWIRUPUDWKHUWKDQE\WKH)LOH6\VWHPDVLW KDSSHQV LQ )LOH 6\QFKURQL]DWLRQ :H WKHQ SURSRVH WKDW 6SUHDGVKHHW3ODWIRUPVPXVWEHHPSRZHUHGWKURXJKWKHDGGLWLRQ RIDQHZVRIWZDUHFRPSRQHQWWKDWWDNHVFDUHRIV\QFKURQL]DWLRQ )LJLOOXVWUDWHVWKHPDLQHOHPHQWVRIWKHSURSRVHGVROXWLRQ

7KH HPSRZHUHG 6SUHDGVKHHW 3ODWIRUPV SDUWLFLSDWH LQ D YLUWXDO VSDFH FDOOHG WKH 6SUHDGVKHHW 6SDFH ZKLFK VXSSRUWV WDEXODUGDWDH[FKDQJHDQGV\QFKURQL]DWLRQ2YHUVXFKDVSDFH VSUHDGVKHHWVFRQQHFWWRHDFKRWKHUV\QFKURQL]HDQGH[FKDQJH LQIRUPDWLRQ

6\QFKURQL]DWLRQ LV LPSOHPHQWHG DV IROORZV D VSUHDGVKHHW XVHUJUDQWVUHDGDFFHVVULJKWVRQD6SUHDGVKHHW(OHPHQWWRDVHW RIXVHUVFDOOHGWKHWDUJHWXVHUVDQGVXFKXVHUVGLVSOD\DQLPDJH RIVXFKD6SUHDGVKHHW(OHPHQWLQWKHLUVSUHDGVKHHWV7KDQNVWR 6SUHDGVKHHW (OHPHQW 6\QFKURQL]DWLRQ DQ\ XSGDWH LQ D 6SUHDGVKHHW(OHPHQWUHVXOWVLQWRDQXSGDWHLQWKH6SUHDGVKHHW (OHPHQWLPDJHV

6SUHDGVKHHW (OHPHQW V\QFKURQL]DWLRQ VXSSRUWV FURVV VSUHDGVKHHWUHIHUHQFHVLHWKHSRVVLELOLW\IRUDVSUHDGVKHHWWR UHIHUHQFH D FHOO RI DQRWKHU VSUHDGVKHHW RYHUFRPLQJ DOO WKH VHFXULW\ EDUULHUV WKDW RSHUDWH DW WKH V\VWHP OHYHO 6SUHDGVKHHW XVHUV DUH VR DEOH WR VKDUH GDWD E\ PDQDJLQJ WKH VSUHDGVKHHW DFFHVVULJKWDWWKHDSSOLFDWLRQOHYHO

A. Functionalities to support Spreadsheet Element Sharing through Synchronization

:HFDOOViewWKHZLQGRZWKDWWKHRZQHURIDVSUHDGVKHHW RSHQVRQD6SUHDGVKHHW(OHPHQWE\JUDQWLQJUHDGDFFHVVULJKWV RQLWDQGZHFDOOImageWKHFRS\RIDUHPRWH9LHZGLVSOD\HGLQ DVSUHDGVKHHW

6SUHDGVKHHW (OHPHQW 6\QFKURQL]DWLRQ LV EDVHG RQ WZR IXQFWLRQDOLWLHVUHVSHFWLYHO\FDOOHGExposeDQGJoinExposeLV WKHIXQFWLRQDOLW\WKURXJKZKLFKDVSUHDGVKHHWFUHDWHVD9LHZ ZKHUHDVJoinLVWKHIXQFWLRQDOLW\WKURXJKZKLFKDVSUHDGVKHHW FUHDWHV DQ ,PDJH RI D 9LHZ ExposeJoin FUHDWH D SHUPDQHQW DV\PPHWULFFRQQHFWLRQIURPDVRXUFHVSUHDGVKHHWLHWKHRQH

WKDWH[SRVHVWKH9LHZWRWKHWDUJHWVSUHDGVKHHWVLHWKHRQHV WKDW LQFOXGH ,PDJHV RI WKH H[SRVHG 9LHZ 7KH ³SHUPDQHQW´ DGMHFWLYH GHQRWHV WKH IDFW WKDW WKH 9LHZ,PDJH UHODWLRQVKLS UHPDLQV DFWLYH XQWLO LW LV H[SOLFLWO\ UHPRYHG ZKHUHDV WKH ³DV\PPHWULF´ DGMHFWLYH GHQRWHV WKH IDFW WKDW WKH WZR VSUHDGVKHHWVSOD\GLIIHUHQWUROHVQDPHO\WKHVRXUFHVSUHDGVKHHW RZQV WKH 6SUHDGVKHHW (OHPHQW ZKHUHDV ,PDJHV DUH MXVW UHDG RQO\ FRSLHV RI WKH 6SUHDGVKHHW (OHPHQWV $Q\ XSGDWH LQ D 6SUHDGVKHHW(OHPHQWDSSHDUVLQWKHFRUUHVSRQGLQJ9LHZDQGDV DFRQVHTXHQFHLQWKHFRUUHVSRQGLQJ,PDJHV   )LJ6SUHDGVKHHW(OHPHQW6\QFKURQL]DWLRQ 7KUHHDVSHFWVGHVHUYHDGHHSHUGHVFULSWLRQ

x )RUPDWV DQG 6W\OHV 9LHZV DQG ,PDJHV SUHVHUYH 6SUHDGVKHHW (OHPHQW IRUPDWV DQG VW\OHV 7KH ,PDJHV DSSHDU LQ WKH VDPH ZD\ DV WKH 9LHZV WR ZKLFK WKH\ DUH FRQQHFWHG

x )RUPXODV YV 9DOXHV 9LHZV DQG ,PDJHV PXVW EH DEOH WR LQFOXGHERWKYDOXHVDQGIRUPXODV

x 8SGDWHSROLF\8SRQWKHXSGDWHRID6SUHDGVKHHW(OHPHQW H[SRVHGDVD9LHZLWLVH[SHFWHGWKDWWKHXSGDWHDSSHDUVLQ WKHFRUUHVSRQGLQJ,PDJHV7KHWLPHDWZKLFKWKDWKDSSHQV GHSHQGV RQ KRZ WKH VRXUFH DQG WKH WDUJHW VSUHDGVKHHWV KDYHFRQILJXUHGRSHUDWLRQ%RWKExposeDWWKHVRXUFHDQG JoinDWWKHWDUJHWFDQEHFRQILJXUHGHLWKHULQPDQXDOPRGH RULQDXWRPDWLFPRGHDVLQGLFDWHGLQWKHWDEOHEHORZ   0DQXDO $XWRPDWLF Expose 9LHZ XSGDWH WDNHV SODFH XSRQ DQ H[SOLFLW FRPPDQGLVVXHGE\WKH H[SRVLQJXVHU 9LHZXSGDWHWDNHVSODFHDWWKH XSGDWH RI WKH FRUUHVSRQGLQJ 6SUHDGVKHHW(OHPHQW Join ,PDJH 5HIUHVK WDNHV SODFH XSRQ DQ H[SOLFLW FRPPDQGLVVXHGE\WKH MRLQLQJXVHU ,PDJH UHIUHVK WDNHV SODFH DW WKH XSGDWH RI WKH FRUUHVSRQGLQJ9LHZ

&/28'

 /RFDO6\QFK



$JHQW



86(5



&HQWUDO6\QFK$JHQW

86(5

 6SUHDGVKHHW 3ODWIRUP

1HWZRUN

)LOH



6\VWHP



/RFDO6\QFK $JHQW 6SUHDGVKHHW



3ODWIRUP



_)LOH

_

6\VWHP



9 635($'6+((729(5/$<

7KH GLVWLQFWLYH IHDWXUH RI 6SUHDGVKHHW (OHPHQW 6\QFKURQL]DWLRQ LV WKDW LW DOORZV VSUHDGVKHHW XVHUV WR H[SRVH SDUWVRIWKHLUVSUHDGVKHHWVWRRWKHUXVHUV6R8VHU$FDQH[SRVH DFHOOUDQJHWR8VHU%ZKRLQWXUQH[SRVHVDWDEOHWR8VHU& ZKRGRHVQRWKDYHDFFHVVWR8VHU$GDWD ,WLVLPPHGLDWHWRREVHUYHWKDWIURPWKHDSSOLFDWLRQSRLQWRI YLHZ6SUHDGVKHHW(OHPHQWV\QFKURQL]DWLRQLVVFDODEOHZKHUHDV 6SUHDGVKHHW6\QFKURQL]DWLRQLVQRW)LJVKRZVDZRUNJURXS FROODERUDWLRQVFKHPHUHSUHVHQWHGDVDGLUHFWHGJUDSKLQZKLFK VHYHUDOVSUHDGVKHHWVVKDUHV6SUHDGVKHHW(OHPHQWV:HFDOOVXFK DVFKHPHD6SUHDGVKHHW2YHUOD\ $6SUHDGVKHHW2YHUOD\FDQEHDVVRFLDWHGWRDJUDSK,WFDQ EHFUHDWHGWKURXJKDJUDSKLFDOFUHDWLRQHQYLURQPHQWLQZKLFK WKH JUDSK QRGHV DQG HGJHV KDYH SURSHUWLHV (DFK QRGH FRUUHVSRQGLQJ WR D VSUHDGVKHHW LV DVVRFLDWHG WR D VHW RI SURSHUWLHVWKDWLQFOXGHVWKHRZQHULGHQWLILHUZKLOHHDFKHGJHLV DVVRFLDWHGWRDVHWRISURSHUWLHVWKDWLQFOXGHVDGHVFULSWLRQRIWKH 6SUHDGVKHHW(OHPHQWWKDWWKHVRXUFHXVHUH[SRVHVWRWKHWDUJHW XVHU 9, 635($'6+((729(5/$<86(&$6(6 7KHIROORZLQJXVHFDVHVKHOSWRXQGHUVWDQGKRZ6SUHDGVKHHW 2YHUOD\V FDQ EH DSSOLHG LQ UHDO VLWXDWLRQV 7KH ILUVW XVH FDVH FDOOHG3URGXFW/LVW'LVWULEXWLRQLVFRQFHUQHGZLWKWKHVLWXDWLRQ LQ ZKLFK D SURGXFW OLVW PDQDJHU PDLQWDLQV D SURGXFW OLVW LQ D FHQWUDO VSUHDGVKHHW RU LQ D 6RIWZDUH 3ODWIRUP DQG PDNHV WKH UHJLRQDOSURGXFWOLVWVDYDLODEOHWRWKHUHJLRQDOPDQDJHUV

7KH UHJLRQDO PDQDJHUV GLVSOD\ WKHLU UHJLRQDO SURGXFW OLVWV DQGFUHDWHSHUVRQDODQDO\VHVDQGSUHVHQWDWLRQV$VWKHUHJLRQDO PDQDJHU VSUHDGVKHHWV DQG WKH FHQWUDO VSUHDGVKHHW FRQVWDQWO\ PDLQWDLQ DOLJQPHQW WKH UHJLRQDO DUHD SHUVRQDO DQDO\VHV DQG SUHVHQWDWLRQVDXWRPDWLFDOO\IROORZWKHHYROXWLRQRIWKHSURGXFW OLVWHJSURGXFWSULFHYDULDWLRQDYDLODELOLW\HWF

7KH VHFRQG XVH FDVH FDOOHG %XGJHW &RQVROLGDWLRQ LV FRQFHUQHG ZLWK WKH VLWXDWLRQ LQ ZKLFK D 0DQDJLQJ 'LUHFWRU 0' RI D FRPSDQ\ SUHSDUHV WKH JOREDO FRPSDQ\ EXGJHW E\ LQWHJUDWLQJWKHEXGJHWVRIGLIIHUHQWGHSDUWPHQWV7KH0'ILUVW FUHDWHVD%XGJHW)RUPDQGPDNHVLWDYDLODEOHWRWKH'HSDUWPHQW 'LUHFWRUV '' ZKR LQVWDOO LW LQ WKHLU VSUHDGVKHHWV WKXV WULJJHULQJLWVH[SRVLWLRQDVD9LHZGLUHFWHGWRWKH0'

7KH0'MRLQVWKH''9LHZVGLVSOD\VWKH,PDJHVRIDOOWKH '' EXGJHW )RUPV DQG FUHDWHV WKH HQWLUH FRPSDQ\ EXGJHW E\ LQWHJUDWLQJWKHFRUUHVSRQGLQJHOHPHQWVRIWKH'')RUPV7KH 0'FDQEURZVHWKHGHSDUWPHQWEXGJHWVDQGWKHWRWDOEXGJHWDQG DVNWKH''VWRPDNHXSGDWHVZKHQQHFHVVDU\FRXQWLQJRQWKH IDFWWKDWVXFKXSGDWHVLPPHGLDWHO\DSSHDULQWKH0'ZRUNVKHHW DQGDIIHFWWKHJOREDOFRPSDQ\EXGJHW$WWKHHQGRIWKHSURFHVV WKH0'XQMRLQVWKH9LHZVDQGIUHH]HVWKHILQDOEXGJHW

7KH WKLUG XVH FDVH FDOOHG )DFW 7DEOH 3URFHVVLQJ LV FRQFHUQHGZLWKWKHVLWXDWLRQLQZKLFKDGDWDVRXUFHH[SRVHVD )DFW7DEOHWKDWLQFOXGHVDVHTXHQFHRIWUDQVDFWLRQVDQGJURZV RYHU WLPH DV QHZ WUDQVDFWLRQV RFFXU 7KH 9LHZ FRQVLVWV RI D G\QDPLFQXPEHURIURZVHDFKRIZKLFKLQFOXGHVDWLPHVWDPS DQGDVHWRIYDOXHVUHODWHGWRWKHSDUDPHWHUVRIWKHWUDQVDFWLRQ $Q RSHUDWRU SURFHVVHV WKH 9LHZ XVLQJ VSUHDGVKHHW IRUPXODV SLYRWWDEOHVRU9%$FRGHWRH[WUDFWVXEWDEOHVDQGRUWRFUHDWH

G\QDPLF GDVKERDUGV DQG FDOFXODWH G\QDPLF .H\ 3HUIRUPDQFH ,QGLFDWRUVWREHH[SRVHGWRXVHUVIRUIXUWKHUSURFHVVLQJ   )LJ6RIWZDUH'HILQHG6SUHDGVKHHW2YHUOD\ 9,,(;3(5,0(176 :HGHYHORSHGDWHVWV\VWHPDQGPDGHLWDYDLODEOHDVDIUHH VHUYLFH RYHU WKH ,QWHUQHW ZZZVSUHDGVKHHWVSDFHQHW IRU 0LFURVRIW([FHO7KHSODWIRUPLQFOXGHVD6SUHDGVKHHW&OLHQWDQG D&ORXG6HUYHU,QDGGLWLRQLWRIIHUVD:HE6HUYLFH,QWHUIDFHIRU WKRVHZKRZDQWWRLPSOHPHQWDFRQQHFWRUDQGDPDQDJHPHQW FRQVROH 7KH6SUHDGVKHHW&OLHQWH[SORLWV&20([FHO$GGLQDQG& WHFKQRORJ\,WRIIHUVDVWDQGDUGULEERQLQWHUIDFHWKURXJKZKLFK 0LFURVRIW([FHOXVHUVFDQDFWLYDWHWKHV\QFKURQL]DWLRQVHUYLFHV 7KH &ORXG 6HUYHU H[SORLWV 2SHQ 6RXUFH -DYD WHFKQRORJ\ DQG UXQV LQ WKH $PD]RQ (& &ORXG 7KH :HE 6HUYLFH ,QWHUIDFH DOORZV DSSOLFDWLRQ GHYHORSHUV WR FUHDWH VRIWZDUH SODWIRUP FRQQHFWRUV XVLQJ VWDQGDUG LQWHUIDFHV EDVHG RQ 5(67 :HE 6HUYLFHV DQG -621 GDWD IRUPDW )LQDOO\ WKH 0DQDJHPHQW &RQVROHDOORZVXVHUVWRFRQILJXUHWKHV\QFKURQL]DWLRQVHUYLFH

:HUDQVHYHUDOILHOGH[SHULPHQWVLQODUJHVPDOOFRPSDQLHV DQGSXEOLFDGPLQLVWUDWLRQV7KHIROORZLQJOLVWVXPPDUL]HVWKH LQGLFDWLRQV WKDW ZH REWDLQHG IURP VXFK H[SHULPHQWV DQG WKDW FRQWULEXWHG WR WKH GHYHORSPHQW DQG WR WKH HQJLQHHULQJ RI WKH SODWIRUP:HFODVVLI\VXFKLQGLFDWLRQLQIRXUFDWHJRULHVQDPHO\ LQGLFDWLRQVUHODWHGWRWKH6SUHDGVKHHW&OLHQWLQGLFDWLRQVUHODWHG WR WKH &ORXG 6HUYHU LQGLFDWLRQV UHODWHG WR 2SHUDWLRQ $GPLQLVWUDWLRQ DQG 0DQDJHPHQW DQG LQGLFDWLRQV UHODWHG WR IXQFWLRQDOLWLHV

A. Indications related to the Spreadsheet Client

x ,QVWDOODWLRQ 7KH 6SUHDGVKHHW &OLHQW PXVW EH LQVWDOOHGXQLQVWDOOHGXVLQJVWDQGDUGSURFHGXUHVDQGZLWKQR DGPLQLVWUDWRUSULYLOHJHV

x )LUHZDOO3UR[\ WUDYHUVDO 7KH 6SUHDGVKHHW &OLHQW PXVW LQFOXGH DSSURSULDWH SURFHGXUHV WR FRQQHFW WR WKH &ORXG 6HUYHU IURP SULYDWH QHWZRUNV SURWHFWHG E\ ILUHZDOOV DQG SUR[LHVLQDWUDQVSDUHQWZD\

B. Indications related to the Cloud Server

x 3XEOLF &ORXG VHUYHU 6FDODELOLW\ LPSRVHV WKDW WKH SXEOLF &ORXG 6HUYHU PXVW SOD\ WKH UROH RI D 9LHZ URXWHU $OO RSHUDWLRQVLQSDUWLFXODUFRPSUHVVLRQDQGHQFU\SWLRQPXVW

WDNHSODFHLQWKH6SUHDGVKHHW&OLHQWVZKHUHDVQRRSHUDWLRQ PXVWWDNHSODFHLQWKH&ORXG6HUYHU

x 3ULYDWH &ORXG VHUYHU 7R VXSSRUW IXOO GDWD SULYDF\ WKH 6SUHDGVKHHW6HUYHUPXVWEHGHSOR\DEOHLQHQWHUSULVHGDWD FHQWHUVDQGSULYDWHDGPLQLVWUDWLRQGRPDLQVLQVWHDGRIXVLQJ WKHSXEOLFVHUYLFHDYDLODEOHLQWKH&ORXG

C. Indications related to Operation, Administration and Management

x 0DQDJHPHQW &RQVROHV $ VHW RI PDQDJHPHQW FRQVROHV WDLORUHG WR WKH GLIIHUHQW XVHU UROHV PXVW SURYLGH WKH DSSURSULDWHWRROVIRU9LHZ,PDJHPDQDJHPHQWDVZHOODV IRU 62 PDQDJHPHQW XVHU PDQDJHPHQW DQG SHUIRUPDQFH PDQDJHPHQW

x 0RQLWRULQJ7KH&ORXG3ODWIRUPPXVWORJWKH6SUHDGVKHHW &OLHQW SUHVHQFH LH DFWLYDWLRQ DQG UHDFKDELOLW\ WKH 6SUHDGVKHHW &OLHQW DFWLYLW\ LH 9LHZ ([SRVHV -RLQV 8SGDWHV DQG ,PDJH 5HIUHVKHV DQG WKH &ORXG 6HUYHU $FWLYLW\$OOWKHHYHQWVDSSURSULDWHO\WLPHVWDPSHGPXVW IHHGERWKWUDGLWLRQDOWH[WXDOORJVDQGOLYHGDVKERDUGVIRU WKHGLIIHUHQWXVHUUROHV

D. Indications related to functionalities

x 9HUVLRQLQJ$VPDQXDOV\QFKURQL]DWLRQDOORZVH[SRVHUV ERWK VSUHDGVKHHWV DQG VRIWZDUH SODWIRUPV WR FUHDWH VXFFHVVLYHYHUVLRQVRIWKHVDPHGDWDDPHFKDQLVPWRWUDFN WKH GDWD YHUVLRQV DQG WR QDYLJDWH RYHU VXFK YHUVLRQV LV PDQGDWRU\

x 6HQG5HFHLYH3LORWXVHUVUHTXHVWHGDVLPSOHIXQFWLRQDOLW\ WR VHQGUHFHLYH VSUHDGVKHHW HOHPHQWV WRIURP RWKHU XVHUV ZLWKRXW OHDYLQJ WKH VSUHDGVKHHW $OWKRXJK VXFK D IXQFWLRQDOLW\VHHPVWREHDOUHDG\FRYHUHGE\HPDLOXVHUV SRLQWHGRXWWKDWLWVGLUHFWVXSSRUWLQVSUHDGVKHHWVIDFLOLWDWHV SHRSOH FROODERUDWLRQ DQG HOLPLQDWHV WKH HUURUV GXH WR FXWSDVWHVZLWFKWRHPDLOHWF

x 2WKHUIXQFWLRQDOLWLHV7ZRDGGLWLRQDOIXQFWLRQDOLWLHVEDVHG RQ VSUHDGVKHHW V\QFKURQL]DWLRQ DUH FXUUHQWO\ XQGHU LQYHVWLJDWLRQ6XFKDGGLWLRQDOIXQFWLRQDOLWLHVQRWLQFOXGHG LQWKHFXUUHQWSLORWLQFOXGH o 6HOHFWLYH-RLQWRMRLQRQO\DURZRID9LHZRIDWDEOH LQVWHDGRIMRLQLQJWKHHQWLUHWDEOH6XFKDIXQFWLRQDOLW\ ZDVSURSRVHGWRVXEVFULEHWRDQLWHPRIDOLVWHJD VWRFNUHFRUGLQDVWRFNUHFRUGOLVW

o %LGLUHFWLRQDO6KDUH WR VXSSRUW VLPXOWDQHRXV VSUHDGVKHHW HOHPHQW FRHGLWLQJ 6XFK D IXQFWLRQDOLW\ GRHV QRW GLIIHU IURP WKH RQH RIIHUHG E\ *RRJOH 6SUHDGVKHHWDQG=RKREXWLWLVEDVHGRQ6SUHDGVKHHW (OHPHQW 6\QFKURQL]DWLRQ DQG DV D FRQVHTXHQFH VXSSRUWVLQIRUPDWLRQFRQILGHQWLDOLW\



9,,, &21&/86,21

,Q WKLV SDSHU ZH KDYH LQWURGXFHG 6SUHDGVKHHW (OHPHQW 6\QFKURQL]DWLRQ WR VXSSRUW VSUHDGVKHHW VKDULQJ 6SUHDGVKHHW (OHPHQW6\QFKURQL]DWLRQHQDEOHVWKHFUHDWLRQRIDYLUWXDOVSDFH IRUVSUHDGVKHHWEDVHGFROODERUDWLRQ7KHSDSHUVWDUWVIURPWKH IDFW WKDW &ORXG EDVHG VKDULQJ GRHV QRW VXSSRUW LQIRUPDWLRQ FRQILGHQWLDOLW\ZKLOHV\QFKURQL]DWLRQEDVHGVKDULQJGRHV,WWKHQ

IRFXVHV RQ 6SUHDGVKHHW (OHPHQW VKDULQJ DQG LQWURGXFHV 6SUHDGVKHHW 2YHUOD\V LH VRIWZDUH GHILQHG V\VWHPV RI V\QFKURQL]HGVSUHDGVKHHWV,WILQDOO\SUHVHQWVVRPH6SUHDGVKHHW 2YHUOD\ XVH FDVHV DQG UHSRUWV WKH IHHGEDFN REWDLQHG LQ ILHOG H[SHULPHQWV   >@ 1DUGL%$$6PDOO0DWWHURI3URJUDPPLJ3HUVSHFWLYHVRQ(QG 8VHU&RPSXWLQJ0,73UHVV >@ .R$-$QUDKDP5%HFNZLWK/%ODFNZHOO$%XUQHWW10(UZLJ 0 6FDIILGL & /DZUDQFH - /LHEHUPDQ + 0\HUV % 5RVVRQ 0 % 5RWKHUPHO*6KDZ0DQG:LHGHQEHFN67KH6WDWHRIWKH$UWLQ (QG8VHU6RIWZDUH(QJLQHHULQJ$&0&RPSXWLQJ6XUYH\V9ROSS  >@ 6FDIILGL&6KDZ0DQG0\HUV%(VWLPDWLQJWKHQXPEHURI(QG 8VHUVDQG(QG8VHU3URJUDPPHUV3URF,(((6\PS9LVXDO/DQJXDJHV DQG+XPDQ&HQWULF&RPSXWLQJ9/+&&¶SS >@ (UZLJ66RIWZDUH(QJLQHHULQJIRU6SUHDGVKHHWV,(((6RIWZDUH 9RO1SS

>@ *URVVPDQ 7  6SUHDGVKHHW (QJLQHHULQJ $ 5HVHDUFK )UDPHZRUN 3URF (XURSHDQ 6SUHDGVKHHW 5LVNV ,QWHUHVW *URXS 6\PSRVLXP &DUGII :DOHV-XO\

>@ 0DQJLDQWH60DUHVFD05RQFDUROR/6SUHDG&RPSSODWIRUP$ QHZSDUDGLJPIRUGLVWULEXWHGVSUHDGVKHHWFROODERUDWLRQDQGFRPSRVLWLRQ 3URF WK ,QWHUQDWLRQDO &RQIHUHQFH RQ &ROODERUDWLYH &RPSXWLQJ 1HWZRUNLQJ$SSOLFDWLRQVDQG:RUNVKDULQJ3LWWVEXUJK3$86$ >@ )LVKHU''H/LQH5&]HUZLQVNL0'UXFNHU6,QWHUDFWLRQVZLWK

%LJ'DWD$QDO\WLFV$&0,QWHUDFWLRQV9RO;,;0D\-XQH >@ *RRJOH*RRJOH'RFVKWWSZZZJRRJOHFRPGRFV

>@ 0LFURVRIW  0LFURVRIW ([FHO 2QOLQH KWWSVRIILFHOLYHFRPVWDUW([FHODVS[