NOAA_D_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_D (inch per inch of precipitation)
C1	NOAA_D (In/hr per inch of precipitation)
A2	0
B2	0
C2	0
A3	0.1
B3	0.0011
C3	0.011
A4	0.2
B4	0.0022
C4	0.011
A5	0.3
B5	0.00332
C5	0.0112
A6	0.4
B6	0.00445
C6	0.0113
A7	0.5
B7	0.00559
C7	0.0114
A8	0.6
B8	0.00674
C8	0.0115
A9	0.7
B9	0.0079
C9	0.0116
A10	0.8
B10	0.00907
C10	0.0117
A11	0.9
B11	0.01025
C11	0.0118
A12	1
B12	0.01145
C12	0.012
A13	1.1
B13	0.01265
C13	0.012
A14	1.2
B14	0.01387
C14	0.0122
A15	1.3
B15	0.0151
C15	0.0123
A16	1.4
B16	0.01634
C16	0.0124
A17	1.5
B17	0.01759
C17	0.0125
A18	1.6
B18	0.01885
C18	0.0126
A19	1.7
B19	0.02012
C19	0.0127
A20	1.8
B20	0.0214
C20	0.0128
A21	1.9
B21	0.0227
C21	0.013
A22	2
B22	0.024
C22	0.013
A23	2.1
B23	0.02532
C23	0.0132
A24	2.2
B24	0.02665
C24	0.0133
A25	2.3
B25	0.02799
C25	0.0134
A26	2.4
B26	0.02934
C26	0.0135
A27	2.5
B27	0.0307
C27	0.0136
A28	2.6
B28	0.03207
C28	0.0137
A29	2.7
B29	0.03346
C29	0.0139
A30	2.8
B30	0.03485
C30	0.0139
A31	2.9
B31	0.03626
C31	0.0141
A32	3
B32	0.03767
C32	0.0141
A33	3.1
B33	0.0391
C33	0.0143
A34	3.2
B34	0.04054
C34	0.0144
A35	3.3
B35	0.04199
C35	0.0145
A36	3.4
B36	0.04345
C36	0.0146
A37	3.5
B37	0.04493
C37	0.0148
A38	3.6
B38	0.04641
C38	0.0148
A39	3.7
B39	0.04791
C39	0.015
A40	3.8
B40	0.04941
C40	0.015
A41	3.9
B41	0.05093
C41	0.0152
A42	4
B42	0.05246
C42	0.0153
A43	4.1
B43	0.054
C43	0.0154
A44	4.2
B44	0.05555
C44	0.0155
A45	4.3
B45	0.05711
C45	0.0156
A46	4.4
B46	0.05869
C46	0.0158
A47	4.5
B47	0.06027
C47	0.0158
A48	4.6
B48	0.06187
C48	0.016
A49	4.7
B49	0.06347
C49	0.016
A50	4.8
B50	0.06509
C50	0.0162
A51	4.9
B51	0.06672
C51	0.0163
A52	5
B52	0.06836
C52	0.0164
A53	5.1
B53	0.07001
C53	0.0165
A54	5.2
B54	0.07167
C54	0.0166
A55	5.3
B55	0.07335
C55	0.0168
A56	5.4
B56	0.07503
C56	0.0168
A57	5.5
B57	0.07673
C57	0.017
A58	5.6
B58	0.07843
C58	0.017
A59	5.7
B59	0.08015
C59	0.0172
A60	5.8
B60	0.08188
C60	0.0173
A61	5.9
B61	0.08362
C61	0.0174
A62	6
B62	0.08537
C62	0.0175
A63	6.1
B63	0.08717
C63	0.018
A64	6.2
B64	0.08901
C64	0.0184
A65	6.3
B65	0.0909
C65	0.0189
A66	6.4
B66	0.09283
C66	0.0193
A67	6.5
B67	0.0948
C67	0.0197
A68	6.6
B68	0.09682
C68	0.0202
A69	6.7
B69	0.09888
C69	0.0206
A70	6.8
B70	0.10099
C70	0.0211
A71	6.9
B71	0.10314
C71	0.0215
A72	7
B72	0.10534
C72	0.022
A73	7.1
B73	0.10758
C73	0.0224
A74	7.2
B74	0.10987
C74	0.0229
A75	7.3
B75	0.1122
C75	0.0233
A76	7.4
B76	0.11458
C76	0.0238
A77	7.5
B77	0.117
C77	0.0242
A78	7.6
B78	0.11946
C78	0.0246
A79	7.7
B79	0.12197
C79	0.0251
A80	7.8
B80	0.12453
C80	0.0256
A81	7.9
B81	0.12712
C81	0.0259
A82	8
B82	0.12977
C82	0.0265
A83	8.1
B83	0.13246
C83	0.0269
A84	8.2
B84	0.13519
C84	0.0273
A85	8.3
B85	0.13796
C85	0.0277
A86	8.4
B86	0.14079
C86	0.0283
A87	8.5
B87	0.14365
C87	0.0286
A88	8.6
B88	0.14656
C88	0.0291
A89	8.7
B89	0.14952
C89	0.0296
A90	8.8
B90	0.15252
C90	0.03
A91	8.9
B91	0.15556
C91	0.0304
A92	9
B92	0.15865
C92	0.0309
A93	9.1
B93	0.1619
C93	0.0325
A94	9.2
B94	0.1653
C94	0.034
A95	9.3
B95	0.16887
C95	0.0357
A96	9.4
B96	0.17259
C96	0.0372
A97	9.5
B97	0.17647
C97	0.0388
A98	9.6
B98	0.18051
C98	0.0404
A99	9.7
B99	0.1847
C99	0.0419
A100	9.8
B100	0.18906
C100	0.0436
A101	9.9
B101	0.19357
C101	0.0451
A102	10
B102	0.19824
C102	0.0467
A103	10.1
B103	0.20307
C103	0.0483
A104	10.2
B104	0.20805
C104	0.0498
A105	10.3
B105	0.2132
C105	0.0515
A106	10.4
B106	0.2185
C106	0.053
A107	10.5
B107	0.22396
C107	0.0546
A108	10.6
B108	0.23
C108	0.0604
A109	10.7
B109	0.23662
C109	0.0662
A110	10.8
B110	0.24382
C110	0.072
A111	10.9
B111	0.2516
C111	0.0778
A112	11
B112	0.25995
C112	0.0835
A113	11.1
B113	0.26933
C113	0.0938
A114	11.2
B114	0.27972
C114	0.1039
A115	11.3
B115	0.29113
C115	0.1141
A116	11.4
B116	0.30356
C116	0.1243
A117	11.5
B117	0.317
C117	0.1344
A118	11.6
B118	0.3351
C118	0.181
A119	11.7
B119	0.35415
C119	0.1905
A120	11.8
B120	0.38028
C120	0.2613
A121	11.9
B121	0.41654
C121	0.3626
A122	12
B122	0.47909
C122	0.6255
A123	12.1
B123	0.58346
C123	1.0437
A124	12.2
B124	0.61972
C124	0.3626
A125	12.3
B125	0.64585
C125	0.2613
A126	12.4
B126	0.6649
C126	0.1905
A127	12.5
B127	0.683
C127	0.181
A128	12.6
B128	0.69644
C128	0.1344
A129	12.7
B129	0.70887
C129	0.1243
A130	12.8
B130	0.72028
C130	0.1141
A131	12.9
B131	0.73067
C131	0.1039
A132	13
B132	0.74005
C132	0.0938
A133	13.1
B133	0.7484
C133	0.0835
A134	13.2
B134	0.75618
C134	0.0778
A135	13.3
B135	0.76338
C135	0.072
A136	13.4
B136	0.77
C136	0.0662
A137	13.5
B137	0.77604
C137	0.0604
A138	13.6
B138	0.7815
C138	0.0546
A139	13.7
B139	0.7868
C139	0.053
A140	13.8
B140	0.79195
C140	0.0515
A141	13.9
B141	0.79693
C141	0.0498
A142	14
B142	0.80176
C142	0.0483
A143	14.1
B143	0.80643
C143	0.0467
A144	14.2
B144	0.81094
C144	0.0451
A145	14.3
B145	0.8153
C145	0.0436
A146	14.4
B146	0.81949
C146	0.0419
A147	14.5
B147	0.82353
C147	0.0404
A148	14.6
B148	0.82741
C148	0.0388
A149	14.7
B149	0.83113
C149	0.0372
A150	14.8
B150	0.8347
C150	0.0357
A151	14.9
B151	0.8381
C151	0.034
A152	15
B152	0.84135
C152	0.0325
A153	15.1
B153	0.84444
C153	0.0309
A154	15.2
B154	0.84748
C154	0.0304
A155	15.3
B155	0.85048
C155	0.03
A156	15.4
B156	0.85344
C156	0.0296
A157	15.5
B157	0.85635
C157	0.0291
A158	15.6
B158	0.85921
C158	0.0286
A159	15.7
B159	0.86204
C159	0.0283
A160	15.8
B160	0.86481
C160	0.0277
A161	15.9
B161	0.86754
C161	0.0273
A162	16
B162	0.87023
C162	0.0269
A163	16.1
B163	0.87288
C163	0.0265
A164	16.2
B164	0.87547
C164	0.0259
A165	16.3
B165	0.87803
C165	0.0256
A166	16.4
B166	0.88054
C166	0.0251
A167	16.5
B167	0.883
C167	0.0246
A168	16.6
B168	0.88542
C168	0.0242
A169	16.7
B169	0.8878
C169	0.0238
A170	16.8
B170	0.89013
C170	0.0233
A171	16.9
B171	0.89242
C171	0.0229
A172	17
B172	0.89466
C172	0.0224
A173	17.1
B173	0.89686
C173	0.022
A174	17.2
B174	0.89901
C174	0.0215
A175	17.3
B175	0.90112
C175	0.0211
A176	17.4
B176	0.90318
C176	0.0206
A177	17.5
B177	0.9052
C177	0.0202
A178	17.6
B178	0.90717
C178	0.0197
A179	17.7
B179	0.9091
C179	0.0193
A180	17.8
B180	0.91099
C180	0.0189
A181	17.9
B181	0.91283
C181	0.0184
A182	18
B182	0.91463
C182	0.018
A183	18.1
B183	0.91638
C183	0.0175
A184	18.2
B184	0.91812
C184	0.0174
A185	18.3
B185	0.91985
C185	0.0173
A186	18.4
B186	0.92157
C186	0.0172
A187	18.5
B187	0.92327
C187	0.017
A188	18.6
B188	0.92497
C188	0.017
A189	18.7
B189	0.92665
C189	0.0168
A190	18.8
B190	0.92833
C190	0.0168
A191	18.9
B191	0.92999
C191	0.0166
A192	19
B192	0.93164
C192	0.0165
A193	19.1
B193	0.93328
C193	0.0164
A194	19.2
B194	0.93491
C194	0.0163
A195	19.3
B195	0.93653
C195	0.0162
A196	19.4
B196	0.93813
C196	0.016
A197	19.5
B197	0.93973
C197	0.016
A198	19.6
B198	0.94131
C198	0.0158
A199	19.7
B199	0.94289
C199	0.0158
A200	19.8
B200	0.94445
C200	0.0156
A201	19.9
B201	0.946
C201	0.0155
A202	20
B202	0.94754
C202	0.0154
A203	20.1
B203	0.94907
C203	0.0153
A204	20.2
B204	0.95059
C204	0.0152
A205	20.3
B205	0.95209
C205	0.015
A206	20.4
B206	0.95359
C206	0.015
A207	20.5
B207	0.95507
C207	0.0148
A208	20.6
B208	0.95655
C208	0.0148
A209	20.7
B209	0.95801
C209	0.0146
A210	20.8
B210	0.95946
C210	0.0145
A211	20.9
B211	0.9609
C211	0.0144
A212	21
B212	0.96233
C212	0.0143
A213	21.1
B213	0.96374
C213	0.0141
A214	21.2
B214	0.96515
C214	0.0141
A215	21.3
B215	0.96654
C215	0.0139
A216	21.4
B216	0.96793
C216	0.0139
A217	21.5
B217	0.9693
C217	0.0137
A218	21.6
B218	0.97066
C218	0.0136
A219	21.7
B219	0.97201
C219	0.0135
A220	21.8
B220	0.97335
C220	0.0134
A221	21.9
B221	0.97468
C221	0.0133
A222	22
B222	0.976
C222	0.0132
A223	22.1
B223	0.9773
C223	0.013
A224	22.2
B224	0.9786
C224	0.013
A225	22.3
B225	0.97988
C225	0.0128
A226	22.4
B226	0.98115
C226	0.0127
A227	22.5
B227	0.98241
C227	0.0126
A228	22.6
B228	0.98366
C228	0.0125
A229	22.7
B229	0.9849
C229	0.0124
A230	22.8
B230	0.98613
C230	0.0123
A231	22.9
B231	0.98735
C231	0.0122
A232	23
B232	0.98855
C232	0.012
A233	23.1
B233	0.98975
C233	0.012
A234	23.2
B234	0.99093
C234	0.0118
A235	23.3
B235	0.9921
C235	0.0117
A236	23.4
B236	0.99326
C236	0.0116
A237	23.5
B237	0.99441
C237	0.0115
A238	23.6
B238	0.99555
C238	0.0114
A239	23.7
B239	0.99668
C239	0.0113
A240	23.8
B240	0.99779
C240	0.0111
A241	23.9
B241	0.9989
C241	0.0111
A242	24
B242	1
C242	0.011