NOAA_C_Depth_Intensity

Sheet visibility: visible.

Back to workbook

Stored values and formulas are shown below. Cached formula results are source snapshots and have not been recalculated.

Cell	Stored value or cached result	Formula
A1	Time (hours)
B1	NOAA_C (inch per inch of precipitation)
C1	NOAA_C (In/hr per inch of precipitation)
A2	0
B2	0
C2	0
A3	0.1
B3	0.00128
C3	0.0128
A4	0.2
B4	0.00231
C4	0.0103
A5	0.3
B5	0.00335
C5	0.0104
A6	0.4
B6	0.00441
C6	0.0106
A7	0.5
B7	0.00547
C7	0.0106
A8	0.6
B8	0.00654
C8	0.0107
A9	0.7
B9	0.00763
C9	0.0109
A10	0.8
B10	0.00872
C10	0.0109
A11	0.9
B11	0.00982
C11	0.011
A12	1
B12	0.01093
C12	0.0111
A13	1.1
B13	0.01206
C13	0.0113
A14	1.2
B14	0.01319
C14	0.0113
A15	1.3
B15	0.01433
C15	0.0114
A16	1.4
B16	0.01548
C16	0.0115
A17	1.5
B17	0.01665
C17	0.0117
A18	1.6
B18	0.01782
C18	0.0117
A19	1.7
B19	0.019
C19	0.0118
A20	1.8
B20	0.02019
C20	0.0119
A21	1.9
B21	0.0214
C21	0.0121
A22	2
B22	0.02261
C22	0.0121
A23	2.1
B23	0.02383
C23	0.0122
A24	2.2
B24	0.02506
C24	0.0123
A25	2.3
B25	0.02631
C25	0.0125
A26	2.4
B26	0.02756
C26	0.0125
A27	2.5
B27	0.02882
C27	0.0126
A28	2.6
B28	0.03009
C28	0.0127
A29	2.7
B29	0.03137
C29	0.0128
A30	2.8
B30	0.03267
C30	0.013
A31	2.9
B31	0.03397
C31	0.013
A32	3
B32	0.03528
C32	0.0131
A33	3.1
B33	0.0366
C33	0.0132
A34	3.2
B34	0.03793
C34	0.0133
A35	3.3
B35	0.03927
C35	0.0134
A36	3.4
B36	0.04062
C36	0.0135
A37	3.5
B37	0.04199
C37	0.0137
A38	3.6
B38	0.04336
C38	0.0137
A39	3.7
B39	0.04474
C39	0.0138
A40	3.8
B40	0.04613
C40	0.0139
A41	3.9
B41	0.04753
C41	0.014
A42	4
B42	0.04894
C42	0.0141
A43	4.1
B43	0.05036
C43	0.0142
A44	4.2
B44	0.05179
C44	0.0143
A45	4.3
B45	0.05324
C45	0.0145
A46	4.4
B46	0.05469
C46	0.0145
A47	4.5
B47	0.05615
C47	0.0146
A48	4.6
B48	0.05762
C48	0.0147
A49	4.7
B49	0.0591
C49	0.0148
A50	4.8
B50	0.06059
C50	0.0149
A51	4.9
B51	0.06209
C51	0.015
A52	5
B52	0.0636
C52	0.0151
A53	5.1
B53	0.06512
C53	0.0152
A54	5.2
B54	0.06665
C54	0.0153
A55	5.3
B55	0.06819
C55	0.0154
A56	5.4
B56	0.06974
C56	0.0155
A57	5.5
B57	0.0713
C57	0.0156
A58	5.6
B58	0.07287
C58	0.0157
A59	5.7
B59	0.07445
C59	0.0158
A60	5.8
B60	0.07604
C60	0.0159
A61	5.9
B61	0.07764
C61	0.016
A62	6
B62	0.07925
C62	0.0161
A63	6.1
B63	0.0809
C63	0.0165
A64	6.2
B64	0.08259
C64	0.0169
A65	6.3
B65	0.08432
C65	0.0173
A66	6.4
B66	0.08609
C66	0.0177
A67	6.5
B67	0.0879
C67	0.0181
A68	6.6
B68	0.08975
C68	0.0185
A69	6.7
B69	0.09164
C69	0.0189
A70	6.8
B70	0.09356
C70	0.0192
A71	6.9
B71	0.09553
C71	0.0197
A72	7
B72	0.09754
C72	0.0201
A73	7.1
B73	0.09959
C73	0.0205
A74	7.2
B74	0.10168
C74	0.0209
A75	7.3
B75	0.1038
C75	0.0212
A76	7.4
B76	0.10597
C76	0.0217
A77	7.5
B77	0.10818
C77	0.0221
A78	7.6
B78	0.11042
C78	0.0224
A79	7.7
B79	0.11271
C79	0.0229
A80	7.8
B80	0.11503
C80	0.0232
A81	7.9
B81	0.1174
C81	0.0237
A82	8
B82	0.11981
C82	0.0241
A83	8.1
B83	0.12225
C83	0.0244
A84	8.2
B84	0.12474
C84	0.0249
A85	8.3
B85	0.12726
C85	0.0252
A86	8.4
B86	0.12982
C86	0.0256
A87	8.5
B87	0.13243
C87	0.0261
A88	8.6
B88	0.13507
C88	0.0264
A89	8.7
B89	0.13776
C89	0.0269
A90	8.8
B90	0.14048
C90	0.0272
A91	8.9
B91	0.14324
C91	0.0276
A92	9
B92	0.14605
C92	0.0281
A93	9.1
B93	0.149
C93	0.0295
A94	9.2
B94	0.1521
C94	0.031
A95	9.3
B95	0.15536
C95	0.0326
A96	9.4
B96	0.15876
C96	0.034
A97	9.5
B97	0.16231
C97	0.0355
A98	9.6
B98	0.16602
C98	0.0371
A99	9.7
B99	0.16987
C99	0.0385
A100	9.8
B100	0.17387
C100	0.04
A101	9.9
B101	0.17803
C101	0.0416
A102	10
B102	0.18233
C102	0.043
A103	10.1
B103	0.18678
C103	0.0445
A104	10.2
B104	0.19139
C104	0.0461
A105	10.3
B105	0.19614
C105	0.0475
A106	10.4
B106	0.20104
C106	0.049
A107	10.5
B107	0.2061
C107	0.0506
A108	10.6
B108	0.21173
C108	0.0563
A109	10.7
B109	0.21793
C109	0.062
A110	10.8
B110	0.22471
C110	0.0678
A111	10.9
B111	0.23206
C111	0.0735
A112	11
B112	0.23999
C112	0.0793
A113	11.1
B113	0.24899
C113	0.09
A114	11.2
B114	0.25907
C114	0.1008
A115	11.3
B115	0.27022
C115	0.1115
A116	11.4
B116	0.28245
C116	0.1223
A117	11.5
B117	0.2955
C117	0.1305
A118	11.6
B118	0.31572
C118	0.2022
A119	11.7
B119	0.337
C119	0.2128
A120	11.8
B120	0.36618
C120	0.2918
A121	11.9
B121	0.40669
C121	0.4051
A122	12
B122	0.4766
C122	0.6991
A123	12.1
B123	0.59331
C123	1.1671
A124	12.2
B124	0.63382
C124	0.4051
A125	12.3
B125	0.663
C125	0.2918
A126	12.4
B126	0.68428
C126	0.2128
A127	12.5
B127	0.7045
C127	0.2022
A128	12.6
B128	0.71755
C128	0.1305
A129	12.7
B129	0.72978
C129	0.1223
A130	12.8
B130	0.74093
C130	0.1115
A131	12.9
B131	0.75101
C131	0.1008
A132	13
B132	0.76001
C132	0.09
A133	13.1
B133	0.76794
C133	0.0793
A134	13.2
B134	0.77529
C134	0.0735
A135	13.3
B135	0.78207
C135	0.0678
A136	13.4
B136	0.78827
C136	0.062
A137	13.5
B137	0.7939
C137	0.0563
A138	13.6
B138	0.79896
C138	0.0506
A139	13.7
B139	0.80386
C139	0.049
A140	13.8
B140	0.80861
C140	0.0475
A141	13.9
B141	0.81322
C141	0.0461
A142	14
B142	0.81767
C142	0.0445
A143	14.1
B143	0.82197
C143	0.043
A144	14.2
B144	0.82613
C144	0.0416
A145	14.3
B145	0.83013
C145	0.04
A146	14.4
B146	0.83398
C146	0.0385
A147	14.5
B147	0.83769
C147	0.0371
A148	14.6
B148	0.84124
C148	0.0355
A149	14.7
B149	0.84464
C149	0.034
A150	14.8
B150	0.8479
C150	0.0326
A151	14.9
B151	0.851
C151	0.031
A152	15
B152	0.85395
C152	0.0295
A153	15.1
B153	0.85676
C153	0.0281
A154	15.2
B154	0.85952
C154	0.0276
A155	15.3
B155	0.86224
C155	0.0272
A156	15.4
B156	0.86493
C156	0.0269
A157	15.5
B157	0.86757
C157	0.0264
A158	15.6
B158	0.87018
C158	0.0261
A159	15.7
B159	0.87274
C159	0.0256
A160	15.8
B160	0.87526
C160	0.0252
A161	15.9
B161	0.87775
C161	0.0249
A162	16
B162	0.88019
C162	0.0244
A163	16.1
B163	0.8826
C163	0.0241
A164	16.2
B164	0.88497
C164	0.0237
A165	16.3
B165	0.88729
C165	0.0232
A166	16.4
B166	0.88958
C166	0.0229
A167	16.5
B167	0.89182
C167	0.0224
A168	16.6
B168	0.89403
C168	0.0221
A169	16.7
B169	0.8962
C169	0.0217
A170	16.8
B170	0.89832
C170	0.0212
A171	16.9
B171	0.90041
C171	0.0209
A172	17
B172	0.90246
C172	0.0205
A173	17.1
B173	0.90447
C173	0.0201
A174	17.2
B174	0.90644
C174	0.0197
A175	17.3
B175	0.90836
C175	0.0192
A176	17.4
B176	0.91025
C176	0.0189
A177	17.5
B177	0.9121
C177	0.0185
A178	17.6
B178	0.91391
C178	0.0181
A179	17.7
B179	0.91568
C179	0.0177
A180	17.8
B180	0.91741
C180	0.0173
A181	17.9
B181	0.9191
C181	0.0169
A182	18
B182	0.92075
C182	0.0165
A183	18.1
B183	0.92236
C183	0.0161
A184	18.2
B184	0.92396
C184	0.016
A185	18.3
B185	0.92555
C185	0.0159
A186	18.4
B186	0.92713
C186	0.0158
A187	18.5
B187	0.9287
C187	0.0157
A188	18.6
B188	0.93026
C188	0.0156
A189	18.7
B189	0.93181
C189	0.0155
A190	18.8
B190	0.93335
C190	0.0154
A191	18.9
B191	0.93488
C191	0.0153
A192	19
B192	0.9364
C192	0.0152
A193	19.1
B193	0.93791
C193	0.0151
A194	19.2
B194	0.93941
C194	0.015
A195	19.3
B195	0.9409
C195	0.0149
A196	19.4
B196	0.94238
C196	0.0148
A197	19.5
B197	0.94385
C197	0.0147
A198	19.6
B198	0.94531
C198	0.0146
A199	19.7
B199	0.94676
C199	0.0145
A200	19.8
B200	0.94821
C200	0.0145
A201	19.9
B201	0.94964
C201	0.0143
A202	20
B202	0.95106
C202	0.0142
A203	20.1
B203	0.95247
C203	0.0141
A204	20.2
B204	0.95387
C204	0.014
A205	20.3
B205	0.95526
C205	0.0139
A206	20.4
B206	0.95664
C206	0.0138
A207	20.5
B207	0.95801
C207	0.0137
A208	20.6
B208	0.95938
C208	0.0137
A209	20.7
B209	0.96073
C209	0.0135
A210	20.8
B210	0.96207
C210	0.0134
A211	20.9
B211	0.9634
C211	0.0133
A212	21
B212	0.96472
C212	0.0132
A213	21.1
B213	0.96603
C213	0.0131
A214	21.2
B214	0.96733
C214	0.013
A215	21.3
B215	0.96863
C215	0.013
A216	21.4
B216	0.96991
C216	0.0128
A217	21.5
B217	0.97118
C217	0.0127
A218	21.6
B218	0.97244
C218	0.0126
A219	21.7
B219	0.97369
C219	0.0125
A220	21.8
B220	0.97494
C220	0.0125
A221	21.9
B221	0.97617
C221	0.0123
A222	22
B222	0.97739
C222	0.0122
A223	22.1
B223	0.9786
C223	0.0121
A224	22.2
B224	0.97981
C224	0.0121
A225	22.3
B225	0.981
C225	0.0119
A226	22.4
B226	0.98218
C226	0.0118
A227	22.5
B227	0.98335
C227	0.0117
A228	22.6
B228	0.98452
C228	0.0117
A229	22.7
B229	0.98567
C229	0.0115
A230	22.8
B230	0.98681
C230	0.0114
A231	22.9
B231	0.98794
C231	0.0113
A232	23
B232	0.98907
C232	0.0113
A233	23.1
B233	0.99018
C233	0.0111
A234	23.2
B234	0.99128
C234	0.011
A235	23.3
B235	0.99237
C235	0.0109
A236	23.4
B236	0.99346
C236	0.0109
A237	23.5
B237	0.99453
C237	0.0107
A238	23.6
B238	0.99559
C238	0.0106
A239	23.7
B239	0.99665
C239	0.0106
A240	23.8
B240	0.99769
C240	0.0104
A241	23.9
B241	0.99872
C241	0.0103
A242	24
B242	1
C242	0.0128