LO Spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	P	Q	R	S	T	U	V	W	X	Z
1	Total Revenue: Corresponding to 12-month Period	$ 3,000,000.00	<-- $3M is the current sales projection for 2025.
2	Science Revenue %	50%
3	Math Revenue %	50%
4	Revenue Share: % Allocated to Games	40%		Science											Math
5	Math Quiz Game Playtime %	18%					Physical Sciences		Life Sciences		Earth / Space Sciences		General Sciences		Kindergarten	1st Grade	2nd Grade	3rd Grade	4th Grade	5th Grade	6th Grade	7th Grade	8th Grade	Other Math Topics
6	Science Quiz Game Playtime %	20%					Physical Sciences		Life Sciences		Earth / Space Sciences		General Sciences
7	My New Game's Average Rating*	4.0	Median is 4.0	Kindergarten	1st Grade	2nd Grade	Elementary	Middle	Elementary	Middle	Elementary	Middle	Elementary	Middle
8	Corresponding 12-month Period	January - December 2025		$ 13	$ 55	$ 145	$ 396	$ 1,185	$ 387	$ 700	$ 589	$ 427	$ 570	$ 549	$ 110	$ 181	$ 40	$ 248	$ 283	$ 609	$ 925	$ 929	$ 176	$ 549
9	Recommended Default Revenue for this 12-month Period	$ 3,000,000.00		$ 59	$ 47	$ 162	$ 334	$ 800	$ 423	$ 366	$ 790	$ 980	$ 493	$ 715	$ 33	$ 285	$ 71	$ 64	$ 201	$ 317	$ 723	$ 167	$ 125	$ 191
10	Choose a Subject Area	Science		$ 555	$ 76	$ -	$ 507	$ 1,481	$ 498	$ 448	$ 1,152	$ 605			$ 84	$ 100	$ 215		$ 115	$ 846	$ 608	$ 737	$ 231	$ 623
11	Choose a Grade Level	Middle		$ 235	$ 39	$ 19	$ 522	$ 344	$ 218	$ 959		$ 496			$ 58					$ 961	$ 799	$ 285	$ 381	$ 86
12	Top 5 Available Middle Science LOs for a 4 Rating			$ 36	$ 9	$ 67	$ 563	$ 505	$ 511	$ 155		$ 1,103			$ 793							$ 334	$ 201	$ 265
13	Plate Tectonics	$2,060	Plate Tectonics	$ 286	$ 8	$ 5		$ 230	$ 199	$ 250		$ 730			$ 8							$ 601	$ 185	$ 88
14	Genes and Traits	$1,784	Genes and Traits	$ 47	$ 33	$ 174		$ 1,539		$ 100		$ 1,458											$ 130	$ 464
15	Effects of Temperature and Pressure on State	$1,539	Effects of Temperature and Pressure on State	$ -	$ 5	$ 42		$ 919		$ 760		$ 774											$ 116	$ 158
16	Equal and Opposite Reactions: Newton's Third Law	$1,528	Equal and Opposite Reactions: Newton's Third Law	$ -	$ 2	$ 7		$ 869		$ 965		$ 639											$ 372	$ 331
17	Fossil Record	$1,458	Fossil Record	$ -	$ 4	$ 592		$ 1,231		$ 460	$ 666	$ 250											$ 494
18				$ -	$ 45	$ 1,412		$ 402		$ 552	$ 1,425	$ 328											$ 115	$ 73
19	*Average Rating = (Teacher Rating + Student Rating) / 2			$ 4	$ 89	$ 72	$ 952	$ 1,528	$ 1,559	$ 1,243	$ 662	$ 2,060			$ 67	$ 131	$ 633	$ 1,174	$ 714	$ 944	$ 726	$ 11	$ 959	$ 195
20	**The underlying data reflects playtime from August 1st 2024 -- July 31st 2025			$ -		$ 105	$ 132	$ 347	$ 332	$ 1,372	$ 950	$ 650			$ 6	$ 150	$ 331	$ 460	$ 791	$ 859	$ 94	$ 266	$ 358	$ 50
21	This spreadsheet allows a game developer to estimate how games will perform in different LO's and different competition scenarios based on past performance. Of course just because one LO had twice as much playtime as a different LO LAST YEAR doesnt mean the same will happen THIS YEAR, or that position 2 in an LO with 5 games will earn 26% of the playtime on average again, but we believe presenting this data can still help you make decisions about where to claim slots and invest time. NONE of these numbers should be taken as guarantees, or even accurate estimates. They are averages from the past year. You need to make your own decisions about time and money investments. Change Cells B1 and B7 to create a scenario. Cells and colors will update to the right, corresponding to the LO codes in the LO Code Sheet. The number in each LO cell to the right corresponds to the projected revenue generated in a year by a new game with a teacher rating in cell B8 in that LO. The table of averages is below. As we grow, our revenue will grow, and you can adjust the projected revenue in cell B1. For example, we plan to have $5.175M in revenue Jan 2024 - Dec 2024, so you can put in 5,175,000 into cell B1 to see the projected earnings in the 2024 calendar year. We have been growing revenue every year, so the amount paid out will grow each year as well. You can input higher values in B1 to see early projections for future years, based on today's historical LO data. To see all the available topics in table format, navigate to the tab "SEE LO NAMES AND SLOT AVAILABILITY HERE" If you would like to view a demo of how to use this spreadsheet, view here: https://drive.google.com/file/d/1IfK12fSAmAd7QcmiYXjaTd8V69_NJJhv/view						$ 86	$ 1,215	$ -	$ 676	$ 282	$ 1,785			$ 147	$ 160	$ 106	$ 352	$ 287	$ 183	$ 258	$ 181	$ 357	$ 36
22							$ 120	$ 1,195	$ 318	$ 1,208	$ 368	$ 299				$ 193	$ 192	$ 703	$ 430	$ 164	$ 295	$ 374	$ 593	$ 335
23							$ 765	$ 747	$ 39	$ 1,256	$ 258	$ 987					$ 210	$ 74	$ 554	$ 128	$ 1,235	$ 724	$ 470	$ 8
24								$ 382		$ 1,421		$ 911					$ 27	$ 222	$ 143	$ 620	$ 249		$ 358	$ 187
25							$ 222	$ 1,024		$ 207		$ 654					$ 664	$ 69	$ 458	$ 618	$ 225		$ 361	$ 248
26							$ 374	$ 555	$ 395	$ 1,784		$ 477					$ 938	$ 344	$ 558	$ 524	$ 529		$ 839	$ 52
27							$ 1,040	$ 446	$ 807	$ 1,727		$ 545					$ 99	$ 324			$ 729		$ 489	$ 297
28							$ 79	$ 297	$ 449	$ 195	$ 296	$ 726					$ 467	$ 105			$ 466		$ 112	$ 168
29							$ 1,050	$ 142	$ 142	$ 396	$ 279	$ 386						$ 356			$ 371		$ 313	$ 266
30							$ 270	$ 629	$ 786	$ 618	$ 547	$ 498						$ 767						$ 312
31							$ 117	$ 923	$ 219	$ 338		$ 534			$ 180	$ 104	$ 313	$ 394	$ 242	$ 235	$ 926	$ 236	$ 584	$ 48
32							$ 562	$ 965	$ 184	$ 146		$ 374				$ 319	$ 241	$ 462	$ 338	$ 448	$ 1,180	$ 207	$ 112	$ 131
33								$ 208	$ 645	$ 695		$ 725				$ 261	$ 265	$ 191	$ 346	$ 593	$ 997	$ 253	$ 197	$ -
34								$ 396	$ 510	$ 496		$ 1,260				$ 221	$ 339		$ 245	$ 684	$ 628	$ 797	$ 168	$ 134
35								$ 297		$ 698						$ 400	$ 533		$ 479	$ 211	$ 464	$ 921	$ 35	$ 93
36							$ 714	$ 780		$ 446						$ 124	$ 218		$ 252	$ 2,675	$ 152	$ 97
37							$ 456	$ 1,329									$ 264			$ 550	$ 239	$ 98
38							$ 633	$ 608									$ 267			$ 1,236	$ 295	$ 407
39							$ 39	$ 750							$ 122		$ 69	$ 219	$ 322	$ 2,962	$ 276	$ 424
40								$ 854							$ 146			$ 463	$ 428	$ 262	$ 614
41								$ 720							$ 52			$ 145	$ 470	$ 605	$ 527
42								$ 702							$ 288			$ 358	$ 429	$ 237	$ 689
43															$ 338			$ 130	$ 826	$ 272	$ 124
44															$ 84			$ 54	$ 729	$ 139	$ 966	$ 683	$ 123
45															$ 106			$ 670	$ 157	$ 434	$ 207	$ 284	$ 404
46																			$ 579	$ 102	$ 1,518	$ 718
47																			$ 270	$ 266	$ 1,185	$ 271
48																			$ 355	$ 432	$ 1,376	$ 346
49																			$ 234	$ 153	$ 418	$ 1,318
50																			$ 213		$ 208	$ 77	$ 475
51															$ 436	$ 141	$ -	$ 560	$ 362	$ 637	$ 140	$ 82	$ 355
52															$ 44	$ 34	$ 92	$ 214	$ 415	$ 208	$ 266	$ 149	$ 231
53															$ 278	$ 280	$ 445	$ 281	$ 1,059	$ 383	$ 589	$ 53	$ 299
54															$ 1,029	$ 196	$ 535	$ 106	$ 1,842		$ 54	$ 163
55															$ 149	$ 566		$ 581	$ 518		$ 159	$ 131
56																$ 655		$ 202			$ 805	$ 165
57																$ 475		$ 731			$ 210	$ 138
58																$ 434		$ 945				$ 65
59																		$ 181				$ 203
60																						$ 106
61
62		Ranked Position of a Game
63	Num games in LO	First	Second	Third	Fourth	Fifth	Sixth	Seventh	Eigth	Ninth	Tenth
64	1	100%	0%	0%	0%	0%	0%	0%	0%	0%	0%
65	2	77%	23%	0%	0%	0%	0%	0%	0%	0%	0%
66	3	63%	26%	11%	0%	0%	0%	0%	0%	0%	0%
67	4	56%	27%	13%	5%	0%	0%	0%	0%	0%	0%
68	5	50%	26%	14%	7%	3%	0%	0%	0%	0%	0%
69	6	51%	25%	13%	7%	3%	1%	0%	0%	0%	0%
70	7	44%	23%	14%	9%	6%	4%	1%	0%	0%	0%
71	8	44%	22%	13%	9%	6%	4%	2%	1%	0%	0%
72	9	40%	21%	13%	9%	6%	5%	3%	2%	1%	0%
73	10	39%	20%	13%	9%	6%	5%	4%	2%	1%	1%
74	11	35%	19%	13%	9%	7%	5%	4%	2%	1%	1%
75	12	37%	19%	13%	9%	7%	5%	4%	2%	1%	1%
76	13	38%	21%	13%	8%	6%	5%	4%	2%	1%	1%
77	14	37%	21%	13%	9%	6%	5%	4%	2%	1%	1%
78	15	32%	21%	14%	10%	6%	5%	4%	2%	1%	1%
79	Example: In an LO with 5 games, the second best rated game earned 26% on average last year (cell shaded in blue)
80
81
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459