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). Rotten Tomatoes scores are listed for films that won Best Actress, Actor, and/or Screenplay. Directions 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). Rows at the bottom calculate the % of nominated films and Best Picture winners watched by year, by decade, and all-time. Statistics 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. Only 12% of Best Actress winning roles were in films that won Best Picture vs. 29% for Best Actor winners. 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). 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. 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).

本电子表格可帮助用户追踪其观影进度，涵盖1928年至2019年间（对应第1至第92届奥斯卡金像奖颁奖典礼）获得最佳影片（Best Picture）提名、斩获最佳女主角（Best Actress）/男主角（Best Actor）奖以及最佳原创剧本（Best Original Screenplay）/最佳改编剧本（Best Adapted Screenplay）奖的影片。针对斩获最佳女主角、男主角及/或剧本类奖项的影片，表格中一并列出其烂番茄（Rotten Tomatoes）评分。
使用说明：在影片左侧列中输入'X'，即可标记已观看该影片。若该影片同时斩获最佳女主角、男主角或剧本类奖项，则对应工作表的相关单元格将自动填入'X'（若尚未观看该影片，关联单元格将显示'0'）。若奖项归属影片未同时获得最佳影片提名，则需手动输入'X'（未手动操作时单元格将保持空白）。
表格底部的行将按年度、十年周期以及累计统计已观看提名影片与最佳影片获奖者的占比。
统计数据：74%的最佳女主角获奖角色出自获得最佳影片提名的影片，而最佳男主角获奖角色的这一占比为78%。仅12%的最佳女主角获奖角色出自斩获最佳影片的影片，对应最佳男主角获奖角色的占比为29%。斩获最佳改编剧本奖的影片同时斩获最佳影片奖的情况共出现38次；斩获最佳原创剧本奖的影片同时斩获最佳影片奖的情况共18次，不足最佳改编剧本类别的一半。32%的最佳原创剧本获奖影片未获得最佳影片提名，而未获得最佳影片提名的最佳改编剧本获奖影片仅占5%。最佳原创剧本与最佳改编剧本获奖影片的平均烂番茄评分均为90%。带有最佳女主角获奖角色的影片平均烂番茄评分为86%，而带有最佳男主角获奖角色的影片平均评分为89%。