Progress Tracker: Oscars Best Picture, Actress, Actor, Screenplay Winners for 1928 - 2019.

This spreadsheet allows users to track their progress watching films nominated for Best Picture, Best Actress/Actor winners, and Best Original/Adapted Screenplay winners from 1928-2019 (spanning from the 1st to the 92rd Academy Awards ceremonies). <br>Rotten Tomatoes scores are listed for films that won Best Actress, Actor, and/or Screenplay. <br><br>Directions<br>Enter an 'X' in the column to the left of the movie to indicate you have watched the movie. If the movie also won Best Actress/Actor/Screenplay awards, an 'X' will be auto-populated on the corresponding sheets (the associated cell will display a '0' if the movie has not yet been watched). If those awards went to a movie not also nominated for Best Picture, you will need to enter an 'X' in manually (the cell will be blank otherwise). <br>Rows at the bottom calculate the % of nominated films and Best Picture winners watched by year, by decade, and all-time.<br>Statistics<br>74% of Best Actress winning roles were in films that were nominated for Best Picture. 78% of Best Actor winning roles were in films nominated for Best Picture. <br>Only 12% of Best Actress winning roles were in films that won Best Picture vs. 29% for Best Actor winners.<br>The film that won Best Adapted Screenplay also won Best Picture 38 times. The film that won Best Original Screenplay also won Best Picture 18 times (less than half of the total for Best Adapted Screenplay). <br>32% of Best Original Screenplay winners were not nominated for Best Picture. Only 5% of the Best Adapted Screenplay winners did not receive a nomination for Best Picture. <br>The average Rotten Tomatoes score for Best Original Screenplay and Best Adapted Screenplay is the same - 90%. The average Rotten Tomatoes score for movies with Best Actress winning roles is 86% (v. 89% for Best Actor winning roles). <br>

本电子表格可帮助用户追踪其观影进度，涵盖1928年至2019年间（对应第1至92届奥斯卡金像奖颁奖典礼）获得最佳影片、最佳女主角/男主角奖项，以及最佳原创剧本、最佳改编剧本奖项的提名影片与获奖影片。烂番茄（Rotten Tomatoes）评分已收录于获得最佳女主角、男主角及/或剧本奖项的影片条目下。

操作指引
请在影片左侧列中输入字符'X'，以标记您已观看该影片。若该影片同时斩获最佳女主角、男主角或剧本奖项，则对应工作表的相关单元格将自动填充'X'；若您尚未观看该影片，对应单元格将显示'0'。若获奖影片未同时获得最佳影片提名，则需您手动输入'X'；未手动标记的情况下单元格将保持空白。
表格底部的行将按年度、年代及全时段统计已观影的提名影片与最佳影片获奖影片占比。

统计数据
74%的最佳女主角获奖角色出自获得最佳影片提名的影片，而最佳男主角获奖角色的这一占比为78%。仅12%的最佳女主角获奖角色出自斩获最佳影片的影片，对应最佳男主角获奖角色的占比则为29%。
有38部同时斩获最佳改编剧本与最佳影片奖项的影片，另有18部同时斩获最佳原创剧本与最佳影片奖项的影片，后者数量不足最佳改编剧本获奖影片的一半。
32%的最佳原创剧本获奖影片未获得最佳影片提名，而未获得最佳影片提名的最佳改编剧本获奖影片占比仅为5%。
最佳原创剧本与最佳改编剧本获奖影片的平均烂番茄（Rotten Tomatoes）评分均为90%。出演过获最佳女主角奖项影片的演员，其参演影片的平均烂番茄评分为86%，而获最佳男主角奖项影片的对应平均评分为89%。