Spreadsheet: 839160d1691702579-bom-creation-levels-parent-child-relationships-sample-data-large-bom
Sheet: Sheet1

Part ID | Parent Assembly | Assembly | Level | Sort
470-8691392_REV_N06 | 0 | 0 | 1
8822621_REV_R1 | 0 | 60 | 2
8822487_REV_R1 | 0 | 92 | 2
8822493_REV_R1 | 0 | 93 | 2
8822494_REV_R0 | 0 | 94 | 2
8822622_REV_R0 | 0 | 107 | 2
8775626_REV_R0 | 0 | 139 | 2
8775636_REV_N03_RL | 0 | 140 | 2
8775638_REV_N03_RL | 0 | 141 | 2
8775727_REV_N02 | 0 | 142 | 2
8822490_REV_R0 | 0 | 305 | 2
8822495_REV_R0 | 0 | 306 | 2
8822502_REV_R0 | 0 | 307 | 2
[NAME] | 0 | 321 | 2
8822625_REV_R1 | 0 | 322 | 2
[NAME] | 0 | 401 | 2
8775689_REV_N02 | 0 | 408 | 2
8775689_REV_N02 | 0 | 409 | 2
8775623_REV_N06 | 0 | 1 | 2
8775639_REV_N01 | 1 | 4 | 3
8775642_REV_N02 | 1 | 6 | 3
8775643_REV_N01 | 1 | 7 | 3
8775644_REV_N01 | 1 | 8 | 3
8775645_REV_N01 | 1 | 9 | 3
8775646_REV_N01 | 1 | 10 | 3
8775648_REV_N01-GDRL002 | 1 | 11 | 3
8775649_REV_N01-GDRL002 | 1 | 12 | 3
8775650_REV_N01 | 1 | 13 | 3
8775651_REV_N02 | 1 | 14 | 3
8775653_REV_N01 | 1 | 15 | 3
8775655_REV_N01 | 1 | 16 | 3
8775659_REV_N01-GDRL002 | 1 | 17 | 3
8775661-1_REV_N02 | 1 | 19 | 3
8775677_REV_N01 | 1 | 20 | 3
8775687_REV_N01-GDRL002 | 1 | 22 | 3
8775688_REV_N03 | 1 | 23 | 3
8775689_REV_N02 | 1 | 24 | 3
8775696_REV_N02 | 1 | 27 | 3
8775697_REV_N02 | 1 | 28 | 3
8775699_REV_N03 | 1 | 29 | 3
8775701_REV_N03 | 1 | 31 | 3
8775702_REV_N02-GDRL001 | 1 | 32 | 3
8775704_REV_N02 | 1 | 34 | 3
8775705_REV_N02 | 1 | 35 | 3
8775709_REV_N02 | 1 | 39 | 3
8775710_REV_N02 | 1 | 40 | 3
8775713_REV_N03 | 1 | 43 | 3
8775715_REV_N01-GDRL001 | 1 | 45 | 3
8775623-61_REV_A | 1 | 53 | 3
8775623-62_REV_A | 1 | 54 | 3
8775691_REV_N01 | 1 | 386 | 3
8775692_REV_N01 | 1 | 387 | 3
8775698_REV_N02 | 1 | 388 | 3
8775726_REV_N02 | 1 | 389 | 3
8775661-2_REV_N02 | 1 | 402 | 3
8775746_REV_N01 | 1 | 420 | 3
8775747_REV_N01 | 1 | 421 | 3
8775635_REV_N08 | 1 | 2 | 3
8775635-12_REV_N07 | 2 | 271 | 4
8775635-13_REV_N07 | 2 | 272 | 4
8775637_REV_N08 | 1 | 3 | 3
8775635-12_REV_N07 | 3 | 356 | 4
8775635-13_REV_N07 | 3 | 357 | 4
8775640_REV_N04 | 1 | 5 | 3
8775660_REV_N02 | 1 | 18 | 3
8775660-1_REV_A | 18 | 143 | 4
8775660-2_REV_A | 18 | 144 | 4
8775660-3_REV_A | 18 | 145 | 4
8775679_REV_N01 | 1 | 21 | 3
8775679-1_REV_A | 21 | 146 | 4
8775679-2_REV_A | 21 | 147 | 4
8775694_REV_N04 | 1 | 25 | 3
8775694-1_REV_A | 25 | 148 | 4
8775694-2_REV_A | 25 | 149 | 4
8775694-3_REV_A | 25 | 150 | 4
8775694-4_REV_A | 25 | 151 | 4
8775694-5_REV_A | 25 | 152 | 4
8775694-7_REV_A | 25 | 153 | 4
8775694-6_REV_A | 25 | 415 | 4
8775695_REV_N02 | 1 | 26 | 3
8775695-1_REV_A | 26 | 154 | 4
8775695-2_REV_A | 26 | 155 | 4
8775695-3_REV_A | 26 | 156 | 4
8775700_REV_N02 | 1 | 30 | 3
8775700-3_REV_N02 | 30 | 157 | 4
8775703_REV_N02 | 1 | 33 | 3
8775703-1_REV_A | 33 | 403 | 4
8775703-2_REV_A | 33 | 404 | 4
8775706_REV_N04 | 1 | 36 | 3
8775706-1_REV_A | 36 | 160 | 4
8775706-2_REV_A | 36 | 161 | 4
8775706-3_REV_A | 36 | 162 | 4
8775706-3_REV_B | 36 | 426 | 4
8775707_REV_N02 | 1 | 37 | 3
8775707-2_REV_A | 37 | 164 | 4
8775708_REV_N03 | 1 | 38 | 3
8775708-1_REV_A | 38 | 166 | 4
8775708-2_REV_A | 38 | 167 | 4
8775711_REV_N04 | 1 | 41 | 3
8775711-1_REV_A | 41 | 168 | 4
8775711-2_REV_A | 41 | 169 | 4
8775712_REV_N04 | 1 | 42 | 3
8775712-1_REV_A | 42 | 170 | 4
8775712-2_REV_A | 42 | 171 | 4
8775714_REV_N02 | 1 | 44 | 3
8775714-1_REV_A | 44 | 172 | 4
8775717_REV_N03 | 1 | 46 | 3
8775717-1_REV_A | 46 | 173 | 4
8775717-2_REV_A | 46 | 406 | 4
8775717-3_REV_A | 46 | 407 | 4
8775718_REV_N03 | 1 | 47 | 3
8775718-1_REV_A | 47 | 174 | 4
8775718-2_REV_A | 47 | 413 | 4
8775718-3_REV_A | 47 | 414 | 4
8775719_REV_N04 | 1 | 48 | 3
8775719-3_REV_A | 48 | 175 | 4
8775719-1_REV_A | 48 | 410 | 4
8775719-2_REV_A | 48 | 411 | 4
8775719-4_REV_A | 48 | 412 | 4
8775720_REV_N04 | 1 | 49 | 3
8775720-1_REV_A | 49 | 397 | 4
8775720-2_REV_A | 49 | 398 | 4
8775720-3_REV_A | 49 | 399 | 4
8775720-4_REV_A | 49 | 400 | 4
8775721_REV_N02 | 1 | 50 | 3
8775721-1_REV_A | 50 | 176 | 4
8775721-2_REV_A | 50 | 177 | 4
8775724_REV_N02 | 1 | 51 | 3
8775724-1_REV_A | 51 | 178 | 4
8775724-2_REV_A | 51 | 405 | 4
8775725_REV_N02 | 1 | 52 | 3
8775725-1_REV_A | 52 | 393 | 4
8775725-2_REV_A | 52 | 394 | 4
8775753_REV_N04 | 1 | 55 | 3
8775753-8-TB2A_REV_A | 55 | 336 | 4
8775753-9_REV_N04 | 55 | 337 | 4
8775753-8-TB2B_REV_A | 55 | 417 | 4
8822620_REV_R0 | 0 | 56 | 2
8822620-1_REV_R0 | 56 | 395 | 3
8822620-2_REV_R0 | 56 | 396 | 3
8822240_REV_R4 | 0 | 57 | 2
8822240-1_REV_A | 57 | 300 | 3
8822240-2_REV_B | 57 | 301 | 3
8822240-3_REV_B | 57 | 302 | 3
8822240-4_REV_B | 57 | 303 | 3
8822240-5_REV_B | 57 | 304 | 3
8822326-1_REV_R0 | 0 | 61 | 2
8822327_REV_R0 | 61 | 63 | 3
8822328_REV_R0 | 61 | 64 | 3
8822505_REV_R0 | 61 | 65 | 3
8822506_REV_R0 | 61 | 66 | 3
8822507_REV_R0 | 61 | 67 | 3
8822508_REV_R0 | 61 | 68 | 3
8822509_REV_R0 | 61 | 69 | 3
8822514_REV_R0 | 61 | 72 | 3
8775647_REV_R0 | 61 | 73 | 3
8822513_REV_R0 | 61 | 418 | 3
8822269-1_REV_R0 | 61 | 62 | 3
A125121212Q21F | 62 | 181 | 4
8822510_REV_R0 | 61 | 70 | 3
8822510-1_REV_R0 | 70 | 183 | 4
8822511_REV_R3 | 61 | 71 | 3
8822511-1_REV_B | 71 | 184 | 4
8822511-2_REV_B | 71 | 185 | 4
8822511-3_REV_B | 71 | 186 | 4
8822326-2_REV_R0 | 0 | 74 | 2
8822327_REV_R0 | 74 | 76 | 3
8822328_REV_R0 | 74 | 77 | 3
8822505_REV_R0 | 74 | 78 | 3
8822506_REV_R0 | 74 | 79 | 3
8822507_REV_R0 | 74 | 80 | 3
8822508_REV_R0 | 74 | 81 | 3
8822509_REV_R0 | 74 | 82 | 3
8822514_REV_R0 | 74 | 85 | 3
8775647_REV_R0 | 74 | 86 | 3
8822513_REV_R0 | 74 | 419 | 3
8822269-2_REV_R0 | 74 | 75 | 3
A125121212Q21F | 75 | 187 | 4
8822510_REV_R0 | 74 | 83 | 3
8822510-1_REV_R0 | 83 | 189 | 4
8822511_REV_R3 | 74 | 84 | 3
8822511-1_REV_B | 84 | 190 | 4
8822511-2_REV_B | 84 | 191 | 4
8822511-3_REV_B | 84 | 192 | 4
8822354_REV_R1 | 0 | 87 | 2
8822354-1_REV_A | 87 | 88 | 3
8822354-2_REV_A | 87 | 89 | 3
8822354-3_REV_A | 87 | 90 | 3
8822354-4_REV_A | 87 | 91 | 3
8822618_REV_R3 | 0 | 95 | 2
8822618-1_REV_B | 95 | 308 | 3
8822618-2_REV_A | 95 | 309 | 3
8822618-4_REV_B | 95 | 310 | 3
8822618-5_REV_A | 95 | 311 | 3
8822618-6_REV_A | 95 | 312 | 3
8822618-3_REV_B | 95 | 313 | 3
8822619_REV_R3 | 0 | 101 | 2
8822619-1_REV_B | 101 | 314 | 3
8822619-2_REV_A | 101 | 315 | 3
8822619-4_REV_B | 101 | 316 | 3
8822619-5_REV_A | 101 | 317 | 3
8822619-6_REV_A | 101 | 318 | 3
8822619-3_REV_B | 101 | 319 | 3
8822315_REV_N06 | 0 | 108 | 2
8822317_REV_R3 | 108 | 110 | 3
8822318_REV_R0 | 108 | 111 | 3
8822319_REV_R0 | 108 | 112 | 3
8822321_REV_R0 | 108 | 113 | 3
[NAME] | 108 | 114 | 3
8822504_REV_R0 | 108 | 115 | 3
8822320_REV_R0 | 108 | 392 | 3
8822316_REV_R4 | 108 | 109 | 3
8691427_REV_R0 | 0 | 116 | 2
8691422_REV_R0 | 116 | 327 | 3
8775641_REV_N07 | 5 | 138 | 4
8775641-SUB10_REV_B | 138 | 213 | 5
8775641-2_REV_A | 213 | 215 | 6
8775641-3_REV_A | 213 | 216 | 6
8775641-19_REV_A | 213 | 220 | 6
8775641-20_REV_A | 213 | 221 | 6
8775641-31_REV_A | 213 | 222 | 6
8775641-SUB5_REV_A | 213 | 214 | 6
8775641-27_REV_A | 214 | 374 | 7
8775641-28_REV_A | 214 | 375 | 7
8775641-30_REV_A | 214 | 376 | 7
8775641-SUB7_REV_A | 213 | 217 | 6
8775641-6_REV_A | 217 | 229 | 7
8775641-11_REV_A | 217 | 230 | 7
8775641-16_REV_A | 217 | 231 | 7
8775641-29_REV_A | 217 | 232 | 7
8775641-SUB8_REV_B | 213 | 218 | 6
8775641-9_REV_B | 218 | 264 | 7
8775641-22_REV_A | 218 | 265 | 7
8775641-36_REV_A | 218 | 266 | 7
8775641-SUB9_REV_B | 213 | 219 | 6
8775641-9_REV_B | 219 | 267 | 7
8775641-21_REV_A | 219 | 268 | 7
8775641-36_REV_A | 219 | 269 | 7
8775641-SUB3_REV_A | 217 | 226 | 7
8775641-7_REV_A | 226 | 235 | 8
8775641-14_REV_A | 226 | 236 | 8
8775641-SUB4_REV_A | 217 | 227 | 7
8775641-12_REV_A | 227 | 259 | 8
8775641-13_REV_A | 227 | 260 | 8
8775641-SUB6_REV_A | 217 | 228 | 7
8775641-8_REV_A | 228 | 261 | 8
8775641-17_REV_A | 228 | 262 | 8
8775641-18_REV_A | 228 | 263 | 8
8775641-SUB1_REV_A | 226 | 233 | 8
8775641-1_REV_A | 233 | 237 | 9
8775641-4_REV_A | 233 | 238 | 9
8775641-5_REV_A | 233 | 239 | 9
8775641-15_REV_A | 233 | 240 | 9
8775641-23_REV_A | 233 | 241 | 9
8775641-24_REV_A | 233 | 242 | 9
8775641-25_REV_A | 233 | 243 | 9
8775641-26_REV_A | 233 | 244 | 9
8775641-32_REV_A | 233 | 245 | 9
8775641-33_REV_A | 233 | 246 | 9
8775641-35_REV_A | 233 | 247 | 9
8775641-SUB2_REV_A | 226 | 234 | 8
8775641-1_REV_A | 234 | 248 | 9
8775641-4_REV_A | 234 | 249 | 9
8775641-5_REV_A | 234 | 250 | 9
8775641-15_REV_A | 234 | 251 | 9
8775641-23_REV_A | 234 | 252 | 9
8775641-24_REV_A | 234 | 253 | 9
8775641-25_REV_A | 234 | 254 | 9
8775641-26_REV_A | 234 | 255 | 9
8775641-32_REV_A | 234 | 256 | 9
8775641-33_REV_A | 234 | 257 | 9
8775641-34_REV_A | 234 | 258 | 9
8775635-SUB5_REV_A | 2 | 270 | 4
8775635-3_REV_A | 270 | 275 | 5
8775635-SUB3_REV_A | 270 | 273 | 5
8775635-7_REV_A | 273 | 344 | 6
8775635-SUB4_REV_A | 270 | 274 | 5
8775635-2_REV_A | 274 | 279 | 6
8775635-9_REV_A | 274 | 280 | 6
8691428_REV_R0 | 116 | 325 | 3
8691418-GSM_REV_A | 325 | 338 | 4
8691429-GSM_REV_A | 325 | 339 | 4
8691430-GSM_REV_A | 325 | 340 | 4
8691431-GSM_REV_A | 325 | 341 | 4
8691413_REV_R1 | 116 | 326 | 3
8691414-GSM_REV_A | 326 | 332 | 4
8691415-GSM_REV_A | 326 | 333 | 4
8691416-GSM_REV_A | 326 | 334 | 4
8775635-SUB1_REV_A | 273 | 342 | 6
8775635-1_REV_A | 342 | 350 | 7
8775635-11_REV_A | 342 | 351 | 7
8775635-10_REV_A | 342 | 352 | 7
8775635-8_REV_B | 342 | 391 | 7
8775635-SUB2_REV_B | 273 | 343 | 6
8775635-5_REV_B | 343 | 353 | 7
8775635-6_REV_A | 343 | 354 | 7
8775637-SUB5_REV_A | 3 | 355 | 4
8775637-3_REV_A | 355 | 360 | 5
8775637-SUB3_REV_A | 355 | 358 | 5
8775637-7_REV_A | 358 | 365 | 6
8775637-SUB4_REV_A | 355 | 359 | 5
8775637-2_REV_A | 359 | 361 | 6
8775637-9_REV_A | 359 | 362 | 6
8775637-SUB1_REV_A | 358 | 363 | 6
8775637-1_REV_A | 363 | 371 | 7
8775637-10_REV_A | 363 | 372 | 7
8775637-11_REV_A | 363 | 373 | 7
8775637-8_REV_B | 363 | 390 | 7
8775637-SUB2_REV_B | 358 | 364 | 6
8775637-5_REV_B | 364 | 369 | 7
8775637-6_REV_A | 364 | 370 | 7
8822316_GSM_REV_A | 109 | 377 | 4
8822316-1_REV_A | 377 | 378 | 5
8822316-2_REV_A | 377 | 379 | 5
8822316-3_REV_A | 377 | 380 | 5
8822316-4_REV_A | 377 | 381 | 5
8822316-5_REV_A | 377 | 382 | 5
8822316-6_REV_A | 377 | 383 | 5
8822316-7_REV_A | 377 | 384 | 5
8822316-8_REV_A | 377 | 385 | 5
8775707-GSM_REV_A | 37 | 422 | 4
8775707-1_REV_A | 422 | 423 | 5
8775707-2_REV_A | 422 | 424 | 5
8775707-3_REV_A | 422 | 425 | 5