4 WorkbookView::show_horizontal_scrollbar TRUE 4 WorkbookView::show_vertical_scrollbar TRUE 4 WorkbookView::show_notebook_tabs TRUE 4 WorkbookView::do_auto_completion TRUE 4 WorkbookView::is_protected FALSE Ratios Average Sizes screenres Ratios 3 4 1 Print_Area Ratios!$A$1:$IV$65536 A1 Sheet_Title "Ratios" A1 d_then_r portrait na_letter 251.998500 345.744001 Default 7.086614 top-left fill 7.086614 1 TRUE 1 y-origin 1 Ratios!$A$1:$A$5 Ratios!$C$1:$C$5 5.669291 7.086614 7.086614 TRUE 0.84722068993329136 0.019627198878994612 0.1309032264824265 0.20542645330584053 1 4:3 1.33 =sum(screenres!I3:I65) 5:4 1.25 =sum(screenres!J3:J65) 16:10 1.6 =sum(screenres!K3:K65) 16:9 1.78 =sum(screenres!L3:L65) Other =1-sum(C1:C4) Average Sizes 3 5 1 Print_Area 'Average Sizes'!$A$1:$IV$65536 A1 Sheet_Title "Average Sizes" A1 d_then_r portrait na_letter Sum of resolutions =round(sum(screenres!F3:screenres!F65),1) Taking into acount percentages =round(B2/sum(screenres!B63:screenres!B3),1) =sqrt(4*B3/3) =sqrt(3*B3/4) =1024*768 Percentage larger than 1024 =C3/1024-1 screenres 13 138 1 Print_Area screenres!$A$1:$IV$65536 A1 Sheet_Title "screenres" A1 d_then_r portrait na_letter 2008-02-12 through 2008-03-13 Screen Resolution Visits Horz Vert Area User Area Ratio 1.3 Ratio 1.25 Ratio 1.6 Ratio 1.78 Odd-ball Rotated 1024x768 0.2944 =left(A3,find("x",A3)-1) =right(A3,len(A3)-find("x",A3)) =C3*D3 =B3*E3 =round(C3/D3,2) =if(G3<1,round(1/G3,2),G3) =if(H3=1.33,B3,0) =if(H3=1.25,B3,0) =if(H3=1.6,B3,0) =if(or(H3=1.78,H3=1.77),B3,0) =if(sum(I3:L3)=0,H3,"") =if(G3=H3,0,B2) 1280x1024 0.2456 1280x800 0.156 1680x1050 0.0735 1440x900 0.0701 1152x864 0.0257 1920x1200 0.0237 800x600 0.0232 1600x1200 0.0216 1400x1050 0.021 1280x768 0.0126 1280x960 0.0093 800x480 0.0023 1280x720 0.0023 1360x768 0.0022 1280x854 0.0013 2560x1024 0.0011 640x480 0.001 2560x1600 0.001 1920x1080 0.0007 1152x768 0.0007 320x396 0.0007 1366x768 0.0006 1600x1024 0.0005 1024x1280 0.0005 1600x900 0.0003 1024x600 0.0003 3200x1200 0.0002 1440x960 0.0002 1360x1024 0.0002 1344x840 0.0002 240x320 0.0002 832x624 0.0002 1920x1440 0.0002 960x600 0.0002 1536x960 0.0002 1200x1600 0.0002 1152x870 0.0002 1152x720 0.0002 800x5000 0.0001 3360x1050 0.0001 2048x768 0.0001 2048x1536 0.0001 320x240 0.0001 1124x644 0.0001 1440x1024 0.0001 1050x1680 0.0001 1300x1300 0.0001 3840x1200 0.0001 1792x1344 0.0001 1600x1000 0.0001 3840x1024 0.0001 1024x640 0.0001 1600x1050 0.0001 1800x1440 0.0001 2960x1050 0.0001 1200x900 0.0001 1152x900 0.0001 1688x964 0.0001 1120x840 0.0001 1200x1920 0.0001 576x460 0.0001 768x1024 0.0001