tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32174d1228266886-create-new-list-codetransfer
Sheet: Sheet1

B
 | A | [NAME] | Bob10
 | A | Ant2 | Bob20
 | B | Ant3 | Bob30
 | B | Ant4 | Bob40
 | C | Ant5 | Bob50
 | C | Ant6 | Bob60
 | A | Ant7 | Bob70
 | C | Ant8 | Bob80
 | F | [NAME] | Bob90
 | C | Ant10 | Bob100
 | E | Ant11 | Bob110
 | E | [NAME] | Bob120
 | D | Ant13 | Bob130
 | B | Ant14 | Bob140
 | A | Ant15 | Bob150
Spreadsheet: 46d139a2-2ff7-44e0-8da1-dacbe57f3e6b
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/12/2012 | Men's Basketball | at Gonzaga | 12:00 AM | L, 50-84
11/22/2012 | Men's Basketball | vs. Marist ([NAME], Fla.) | 12:00 AM | W, 87-44
11/23/2012 | Men's Basketball | vs. [NAME] (Lake [NAME], Fla.) | 12:00 AM | L, 60-63
11/25/2012 | Men's Basketball | vs. Oklahoma (Lake [NAME], Fla.) | 12:00 AM | L, 70-77
11/28/2012 | Men's Basketball | VMI | 12:00 AM | W, 94-69
12/05/2012 | Men's Basketball | vs. [NAME] (Charleston, W.Va.) | 12:00 AM | W, 69-59
12/08/2012 | Men's Basketball | [NAME] | 12:00 AM | W, 68-67
12/11/2012 | Men's Basketball | at Duquesne | 12:00 AM | L, 56-60
12/15/2012 | Men's Basketball | vs. Michigan (Brooklyn, N.Y.) | 12:00 AM | L, 66-81
12/19/2012 | Men's Basketball | Oakland | 12:00 AM | W, 76-71
12/22/2012 | Men's Basketball | Radford | 12:00 AM | W, 72-62
12/30/2012 | Men's Basketball | Eastern Kentucky | 12:00 AM | W, 74-67
01/05/2013 | Men's Basketball | Oklahoma * | 12:00 AM | L, 57-67
01/09/2013 | Men's Basketball | at Texas * | 12:00 AM | W, 57-53
01/12/2013 | Men's Basketball | Kansas State * | 12:00 AM | L, 64-65
[NAME] | Men's Basketball | at Iowa State * | 12:00 AM | L, 67-69
01/19/2013 | Men's Basketball | at Purdue | 12:00 AM | L, 52-79
[NAME] | Men's Basketball | TCU * | 12:00 AM | W, 71-50
01/26/2013 | Men's Basketball | at Oklahoma State * | 12:00 AM | L, 66-80
01/28/2013 | Men's Basketball | Kansas * | 12:00 AM | L, 56-61
02/02/2013 | Men's Basketball | at Texas Tech * | 12:00 AM | W, 77-61
[NAME] | Men's Basketball | Texas * | 12:00 AM | W, 60-58
02/09/2013 | Men's Basketball | at TCU * | 12:00 AM | W, 63-50
02/13/2013 | Men's Basketball | at Baylor * | 12:00 AM | L, 60-80
02/16/2013 | Men's Basketball | Texas Tech * | 12:00 AM | W, 66-64
02/18/2013 | Men's Basketball | at Kansas State * | 12:00 AM | L, 61-71
02/23/2013 | Men's Basketball | Oklahoma State * | 12:00 AM | L, 57-73
02/27/2013 | Men's Basketball | Baylor * | 12:00 AM | L, 62-65
03/02/2013 | Men's Basketball | at Kansas * | 12:00 AM | L, 65-91
03/06/2013 | Men's Basketball | at Oklahoma * | 12:00 AM | L, 70-83
03/09/2013 | Men's Basketball | Iowa State * | 12:00 AM | L, 74-83
03/13/2013 | Men's Basketball | vs. Texas Tech (Big 12 Championship) | 12:00 AM | L, 69-71
Spreadsheet: 682741d1592308417-engineer-project-allocation-app-sanitised-tracker
Sheet: Admin

 | Skill Category |  | Category | Skill |  | Active |  |  | Manager | Acronym |  | Requestor [NAME]
 | Network |  | Network | Routing |  | True |  |  | Manager 1 | M1 |  | Requestor List | No of Dist Val | Dr-Dn List | Work Package | No of Dist Val
 | Storage |  | Network | Switching |  | False |  |  | Manager 2 | M2
 | Backup |  | Infra Automation Engineer | Cheff
 | Infra Automation Engineer |  | Infra Automation Engineer | vRA/vRO
 | Infra Engineer |  | Infra Automation Engineer | Ansible
 |  |  | Infra Automation Engineer | Terraform
 |  |  | Infra Engineer | Vmware
 |  |  | Storage | Nimble
 |  |  | Backup | Veeam
 |  |  | Storage | NetApp (FAS/AFF)
 |  |  | Storage | XP Arrays
 |  |  | Storage | Cisco Director
 |  |  | Storage | Brocade Director
 |  |  | Storage | DataDomain
Spreadsheet: 122850d1317206538-combo-box-cell-link-showing-wrong-date-hidemarkedcols-1-
Sheet: HideColumns

 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | <= dont worry about this, but this workbook works when you select date from here (offcourse formulas in row1 must be changed). But i need this to work another workbook and i dont have a idea what this is : D combo box or what?
 |  |  |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00
 |  |  |  | 33 | 22 | 55 | 85 | 7 | 72 | 74 | 80 | 42 | 54 | 33 | 3
 |  |  |  | 46 | 69 | 56 | 83 | 51 | 93 | 33 | 62 | 84 | 68 | 54 | 71
 |  |  |  | 95 | 95 | 50 | 49 | 1 | 43 | 98 | 95 | 29 | 68 | 38 | 3
 |  |  |  | 28 | 61 | 58 | 3 | 1 | 11 | 51 | 7 | 39 | 73 | 89 | 57
 |  |  |  | 64 | 53 | 41 | 11 | 44 | 25 | 50 | 8 | 36 | 88 | 19 | 13
 |  |  |  |  |  |  | 2011-01-30 00:00:00 | 30
 |  | Date list is in another sheet. If you can figure this hole workbook to work, i really be thankful
 |  | You select date from combo box or maybe in date and time picker. Get that date to another cell. Use that cell with formulas in row 1. If date is bigger than selected date and you press "Hide Marked", those bigger dates hide. I think that macro is working
Spreadsheet: 826485d1682032044-formula-to-format-source-data-correctly-for-pivot-table-arrange-data
Sheet: Sheet1

Channels | Metric | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
A | Acc | 3.748517647058824 | 4.241317647058824 | 4.475105882352942 | 5.642917647058824 | 4.090729411764706 | 4.206682352941177 | 3.265505882352941 | 3.178917647058824 | 3.273035294117647 | 5.615435294117647 | 4.991623529411766 | 4.376470588235295
A | Co | 339.9851294117647 | 281.6391529411765 | 242.9885176470588 | 230.3528470588236 | 298.1033411764706 | 286.2432941176471 | 172.2136470588235 | 190.5101176470588 | 214.5668705882353 | 209.9673411764706 | 205.5523764705883 | 179.8517647058823
B | Acc | 162.0459294117647 | 145.4446117647059 | 162.8469647058824 | 207.4407529411765 | 151.1322352941177 | 145.0106352941177 | 155.0496 | 152.8162823529412 | 138.3985882352941 | 141.4072470588235 | 139.6066823529412 | 125.0601411764706
B | Co | 1294.911811764706 | 1615.616 | 3898.079341176471 | 3242.091011764706 | 2598.659576470588 | 2469.454305882353 | 258.0962823529412 | 252.8301176470588 | 3126.504470588236 | 1646.648564705883 | 266.3850352941176 | 289.8896
D | Acc | 4.182870588235295 | 2.612517647058824 | 4.733458823529412 | 6.904470588235295 | 3.28884705882353 | 2.200564705882353 | 2.188517647058823 | 2.401694117647059 | 1.945223529411765 | 2.100329411764706 | 1.718211764705883 | 4.565741176470588
D | Co | 327.675105882353 | 285.4122352941177 | 317.6946823529412 | 265.4598588235294 | 203.639905882353 | 197.2638117647059 | 151.8380235294118 | 161.7310117647059 | 192.3546352941177 | 177.9460705882353 | 98.06936470588236 | 190.1224470588236
P | Acc | 2.205364705882353 | 1.843670588235294 | 4.297411764705883 | 8.805270588235294 | 2.662494117647059 | 2.152376470588236 | 2.096564705882353 | 2.025035294117647 | 2.214023529411765 | 5.864376470588237 | 3.281129411764706 | 2.882164705882353
P | Co | 228.1243294117647 | 252.6168470588236 | 286.4133647058824 | 226.6336 | 170.2283294117647 | 320.6768000000001 | 131.7891764705882 | 131.8292705882353 | 144.8857411764706 | 187.8960941176471 | 166.4242823529412 | 150.0530823529412
S | Acc | 65.79585882352941 | 64.8676705882353 | 67.68960000000001 | 59.53477647058824 | 57.73618823529412 | 50.77261176470589 | 60.58870588235295 | 42.49750588235294 | 44.87416470588236 | 55.84009411764707 | 56.50588235294119 | 54.17148235294118
S | Co | 2274.3216 | 2503.367152941177 | 2650.508235294118 | 3294.021552941176 | 3098.877458823529 | 2942.629835294118 | 2902.415247058824 | 2256.301929411765 | 2695.356141176471 | 2754.327529411765 | 2934.914823529412 | 2448.182211764706
Months | Channels | Acc | Co
Spreadsheet: 885365d1734874245-using-if-to-calculate-chainage-chainage-conversion
Sheet: Sheet2

 | Odometer (m) |  |  |  |  | Datum
 | 0
 | 21 |  |  |  |  | 34 | 1320 | 178.4
 | 34
 | 50
 | 97
 | 106
 | 111
 | 118
 | 125
 | 148
 | 155
 | 172
 | 178.4
 | 183.6
 | 190
 | 202
 | 205
 | 210
 | 217
 | 223
 | 227
 | 235
 | 237
 | 259
 | 261
 | 273
 | 300
 | 302
 | 343
 | 347
 | 354
 | 365
 | 366
 | 368
 | 372
 | 374
 | 380
 | 385
 | 387
 | 396
 | 399
 | 403
 | 406
 | 414
 | 423
 | 436
 | 444
 | 469
 | 482
 | 501
 | 507
 | 512
 | 580
Spreadsheet: 0fc939c3-2713-4931-8a88-707ee3d527bb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  | Northwest
Mon. Games 1 thru 12 |  |  |  | 10:30        # 1
[NAME]. Games 13 thru 24 |  |  | #9 | West gym | #14
Wed. Games 25 thru 30 |  |  | Mon. | Southwest | [NAME].
 |  | #17 | 5:00 /West |  | 10:30 /West | #21
 |  |  |  | [NAME]
 |  |  |  | 12:00        #3
 |  |  |  | Main gym
 |  | [NAME]. |  | [NAME] |  | [NAME].
 | #27  Wed. | 1:30 /Main |  |  |  | 5:00 /Main | Wed.   #30
 | 12:00 /Main |  |  | Haltom |  |  | 3:00 /Main
 |  |  |  | 1:30          #5
 |  |  | #11 | West gym | #15
 |  |  | Mon. | [NAME] | [NAME].
 |  |  | 6:30 /Main |  | 12:00 /Main
 |  |  |  | Little Elm
 |  |  |  | 3:00           #7
 |  |  |  | Main gym
 |  |  |  | Boswell
CONSOLATION |  | #25   Wed. |  |  |  | Wed.   #29 |  | CHAMPIONS
 |  | 10:30 /Main |  |  |  | 1:30 /Main
 | Consolation |  |  | L.D. Bell |  |  | 3rd Place
 | 3rd Place |  |  | 10:30         #2
 |  |  | #10 | Main gym | #13
 |  |  | Mon. | FW Christian | [NAME].
 |  | #19 | 5:00 /Main |  | 10:30 /Main | #23
 |  |  |  | [NAME]
 |  |  |  | 12:00        #4
 |  |  |  | West gym
 |  | [NAME]. |  | [NAME] |  | [NAME].
 |  | 3:00 /Main |  |  |  | 6:30 /Main
 |  |  |  | Richland
 |  |  |  | 1:30           #6
 |  |  | #12 | Main gym | #16
 |  |  | Mon. | Western Hills | [NAME].
 |  |  | 6:30 /West |  | 12:00 /West
 |  |  |  | Abilene
 |  |  |  | 3:00          #8
 |  |  |  | West gym
 |  |  |  | Arlington
 | BRONZE DIVISION |  |  |  |  | SILVER DIVISION
 | Loser 9    (18 |  |  |  |  | Loser 13  (22
 | [NAME]. 1:30 /West | #26 |  |  |  | [NAME]. 5:00 /West | #28
 | Loser 10 |  |  |  |  | Loser 14
 |  | Wed. |  |  |  |  | Wed.
 |  | 10:30 /West | 5th Place |  |  |  | 12:00 /West | 5th Place
 | Loser 11  (20 |  |  |  |  | Loser 15  (24
 | [NAME]. 3:00 /West |  |  |  |  | [NAME]. 6:30 /West
 | Loser 12 |  |  |  |  | Loser 16
 |  |  |  | BOTTOM TEAM / HOME TEAM AND WEAR LIGHT UNIFORM
Spreadsheet: 102957d1300826148-formula-precedent-changes-isnt-changing-value-design-20shear-20wall-1-
Sheet: Sheet1

inputs |  |  | Horizontal shear Reinforcement |  |  |  | Vertical Shear Reinforcement |  |  |  | Required # of bars | Provide Area (in2) | Area Difference | C (in) | et   provided | f  check |  | ASTM STANDARD REINFORCING BARS
Fy (psi) | 60000 |  | Av/S (in2/in) |  |  |  | ρt |  |  |  |  |  |  |  |  |  |  | Bar Size,no | D (in) | A (in2) | Weight (lb/ft)
F'c (psi) | 3000 |  |  |  |  |  | ρl |  |  |  |  |  |  |  |  |  |  | 3 | 0.375 | 3 | 0.376
h (in) | 8 |  | Spacing |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0.5 | 0.2 | 0.668
Hw (ft) | 12 |  | No 3. (in) |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 5 | 0.625 | 0.31 | 1.043
Lw (ft) | 8 |  | No 4. (in) |  |  |  | Smin (in) |  |  |  |  |  |  |  |  |  |  | 6 | 0.75 | 0.44 | 1.502
Vu (kips) | 200 |  | No 5. (in) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0.875 | 0.6 | 2.044
l | 1 |  |  |  |  |  | Flexure Design |  |  |  |  |  |  |  |  |  |  | 8 | 1 | 0.79 | 2.67
Mu |  |  | [NAME] |  |  |  | Mu (k') |  |  |  |  |  |  |  |  |  |  | 9 | 1.128 | 1 | 3.4
b1 |  |  | Smin (in) |  |  |  | Assume f | 0.9 |  |  |  |  |  |  |  |  |  | 10 | 1.27 | 1.27 | 4.303
 |  |  |  |  |  |  | Rn (psi) |  |  |  |  |  |  |  |  |  |  | 11 | 1.41 | 1.56 | 5.313
Calculate d |  |  |  |  |  |  | ρ |  |  |  |  |  |  |  |  |  |  | 14 | 1.693 | 2.25 | 7.6
d (in) |  |  | ρt >0.0025 check/comparison |  |  |  | Asreq (in2) |  |  |  |  |  |  |  |  |  |  | 18 | 2.257 | 4 | 13.6
 |  |  | No 3. @ | 6 | in
Calculate fVn |  |  | ρt
fVn (kips) |  |  | ρt>0.0025
Spreadsheet: 751341d1634053793-dynamic-workbook-name-with-a-named-range-analysis
Sheet: Sheet1

 | [NAME] | SourceData.xlsx
 | This works |  | Not working |  | Not Working |  | Not working
 | =SourceData.xlsx!idcol |  | =INDIRECT(C2 & "!idcol") |  | =INDIRECT(mysource & "!idcol") |  | =INDIRECT(mysource & "!" & idcol)
Spreadsheet: 729020d1618858236-identifying-all-unique-combinations-example
Sheet: Sheet1

 | Scenario |  |  |  | Result
 | Responsible Sector | Program Inventory |  |  | Responsible Sector | Program Inventory
 | Low Carbon Energy Sector | Lower Carbon Transportation |  |  | Low Carbon Energy Sector | Lower Carbon Transportation
 | Low Carbon Energy Sector | Lower Carbon Transportation |  |  | Low Carbon Energy Sector | Clean Energy Technology Policy, Research and Engagement
 | Low Carbon Energy Sector | Clean Energy Technology Policy, Research and Engagement |  |  | Canadian Forest Service | Forest Climate Change
 | Low Carbon Energy Sector | Clean Energy Technology Policy, Research and Engagement |  |  | Canadian Forest Service | Pest Risk Management
 | Canadian Forest Service | Forest Climate Change |  |  | Canadian Forest Service | Clean Energy Technology Policy, Research and Engagement
 | Canadian Forest Service | Forest Climate Change
 | Canadian Forest Service | Pest Risk Management
 | Canadian Forest Service | Clean Energy Technology Policy, Research and Engagement
 | Low Carbon Energy Sector | Lower Carbon Transportation
 | Canadian Forest Service | Pest Risk Management
Spreadsheet: 118181d1313508571-vloookup-help-index-and-match-example
Sheet: Index

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0
 | 5 | 8 | 9 | 8 | 5 | 8 | 7 | 5 | 9 | 6
 | 7 | 4 | 7 | 1 | 9 | 8 | 8 | 9 | 3 | 5 |  | Row | 4
 | 7 | 9 | 2 | 6 | 4 | 7 | 3 | 8 | 9 | 8 |  | Column | 4
 | 1 | 6 | 6 | 8 | 7 | 1 | 1 | 4 | 2 | 3
 | 2 | 9 | 1 | 6 | 1 | 6 | 5 | 7 | 6 | 2
 | 6 | 8 | 9 | 7 | 7 | 9 | 1 | 6 | 7 | 4
 | 2 | 1 | 9 | 4 | 8 | 5 | 4 | 6 | 2 | 5
 | 6 | 2 | 8 | 1 | 7 | 8 | 7 | 2 | 8 | 6
 | 2 | 3 | 7 | 4 | 3 | 8 | 5 | 8 | 6 | 5
 | 3 | 1 | 4 | 8 | 7 | 9 | 5 | 10 | 6 | 2
 |  |  |  |  |  |  |  |  |  |  |  | Lookup value | 3
 | A | B | C | D | E | F | G | H | I | J |  |  |  |  | Error!!!!
A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0
B | 5 | 8 | 9 | 8 | 5 | 8 | 7 | 5 | 9 | 6
C | 7 | 4 | 7 | 1 | 9 | 8 | 8 | 9 | 3 | 5 |  | Row | A
D | 7 | 9 | 2 | 6 | 4 | 7 | 3 | 8 | 9 | 8 |  | Column | A
E | 1 | 6 | 6 | 8 | 7 | 1 | 1 | 4 | 2 | 3
F | 2 | 9 | 1 | 6 | 1 | 6 | 5 | 7 | 6 | 2
G | 6 | 8 | 9 | 7 | 7 | 9 | 1 | 6 | 7 | 4
H | 2 | 1 | 9 | 4 | 8 | 5 | 4 | 6 | 2 | 5
I | 6 | 2 | 8 | 1 | 7 | 8 | 7 | 2 | 8 | 6
J | 2 | 3 | 7 | 4 | 3 | 8 | 5 | 8 | 6 | 5
Spreadsheet: 759072d1639290542-transpose-data-table-arrange-1-row-into-multiple-row-column-data-convert
Sheet: Sheet1

 | Input |  | Output
 | Address |  |  | Credit | Points | Spacing
 | Credit |  | 1bf21d14a13450D | 298 | 1 | 2
 | Points |  | 410ee7e49810221 | 298 | 0 | 0
 | Spacing |  | 5968954AAD06deF | 358 | 0 | 0
 | 1bf21d14a13450D |  | 55c5B237fF4f97F | 29 | 0 | 0
 | 298 |  | Ad460a6e69C306b | 298 | 0 | 0
 | 1 |  | 81Ef9C628405Eea | 537 | 0 | 0
 | 2 |  | 422d9b701828A44 | 298 | 0 | 0
 | 410ee7e49810221 |  | 798AA306d4b65D1 | 59 | 0 | 0
 | 298 |  | 6249a6CA6a2F4DF | 298 | 0 | 0
 | 0 |  | dd2C7354F585b4B | 328 | 0 | 0
 | 0 |  | c59dcf5Ab3c173c | 298 | 0 | 0
 | 5968954AAD06deF |  | 254F1fcCC4110A6 | 328 | 0 | 0
 | 358 |  | Becd1E2Fb6e2ab5 | 1851 | 0 | 0
 | 0
 | 0
 | 55c5B237fF4f97F
 | 29
 | 0
 | 0
 | Ad460a6e69C306b
 | 298
 | 0
 | 0
 | 81Ef9C628405Eea
 | 537
 | 0
 | 0
 | 422d9b701828A44
 | 298
 | 0
 | 0
 | 798AA306d4b65D1
 | 59
 | 0
 | 0
 | 6249a6CA6a2F4DF
 | 298
 | 0
 | 0
 | dd2C7354F585b4B
 | 328
 | 0
 | 0
 | c59dcf5Ab3c173c
 | 298
 | 0
 | 0
 | 254F1fcCC4110A6
 | 328
 | 0
 | 0
 | Becd1E2Fb6e2ab5
 | 1851
 | 0
 | 0
Spreadsheet: 112657d1308707488-code-required-for-merging-data-from-one-worksheet-to-another-data-merge-and-addition
Sheet: Pricing Sheet

Excel Macro to Copy Records to Next Blank Row on Another Worksheet
I want to be able to add data to this page in column a then it will insert into sheet 1 (see sheet 1)
 | MATERIAL |  |  |  |  | LABOUR |  |  |  |  | SELL PRICE
[NAME] | Qty | Price | Material Cost | %Mat MARGIN | TOTAL MAT | No. Men | [NAME] | LABOUR COST | LABOUR MARGIN | TOTAL LAB
mango |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  | [NAME]
plum |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  | [NAME]
banana |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  | [NAME]
stat |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  | [NAME]
sr |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
 |  |  | 0 |  | 0 |  |  | 0 |  | 0 | 0
Hourly Rate Cost |  |  | Material Cost | 0 | Material Marg/Rev |  |  | 0 | [NAME] | Material Sell | 0
Hourly Rate Sell |  |  | Labour Cost | 0 | [NAME] |  |  | 0 | [NAME] | [NAME] | 0
 |  |  | Job Cost | 0 | Job Marg/Rev |  |  | 0 | [NAME] | Job Sell | 0
 |  |  | Job Total Hours |  |  |  |  |  |  | Forcast Margin | 0
 |  |  |  |  |  |  |  |  |  | GST | 0
SELL PRICE INCLUDING G.S.T |  | 0
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 29133166 | 65082233
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 11210462 | 26302673
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 40343628 | 91384906
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -29181304 | -63616985
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -11097128 | -26059696
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 247791 | 549122
 | Total Purchases: |  | -40030641 | -89127559
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 27934 | 61436
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -340850 | -774256
 | Total Imbalances: |  | -312916 | -712820
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 4703 | 9867
18 |  | W/D (Purchase from Stg) | -4862 | -11007
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -4862 | -11007
 | Total Storage: |  | -159 | -1140
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 88 | 185.8836231492802
 |  |  | 0 | 0
23 | Fuel: |  | -247791 | -549122
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -95535
25 |  | Demand | 0 | -1444318.11
 | Total Transport Expense: |  | 0 | -1539853.11
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 2053660
31 |  | Prior Month Book Balance | 0 | -1968884
 |  | Total MTM Income | 0 | 84776
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 3114351
34 |  | Originations | 0 | 620
35 |  | Broker Fees | 0 | -18952
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -197864
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 187792d1350582410-combining-data-in-columns-into-one-row-sample
Sheet: Sheet1

Product | Position | Make | Model | Year | Year End
MPN | Back | Make | Model | 1997
MPN | Back | Make | Model | 1998
MPN | Back | Make | Model | 1999
MPN | Back | Make | Model | 2000
MPN | Back | Make | Model | 2001
MPN | Back | Make | Model | 2002
MPN | Back | Make | Model | 1997
MPN | Back | Make | Model | 1998
MPN | Back | Make | Model | 1999
MPN | Back | Make | Model | 2001
MPN | Back | Make | Model | 2002
Spreadsheet: 138789d1327908333-min-if-sample
Sheet: Sheet1

392 | 11026 |  | 482 | 10491
392 | 11149 |  | 483 | 9378
392 | 11272 |  | 514 | 9363
392 | 11508 |  | 537 | 9936
392 | 11621 |  | 737 | 9769
392 | 11734 |  | 811 | 9522
392 | 11847 |  | 941 | 8838
392 | 11960
392 | 12073
392 | 12329
392 | 12462
392 | 11117
392 | 11240
392 | 11363
392 | 11599
392 | 11712
392 | 11825
392 | 11938
392 | 12051
392 | 12164
392 | 12420
392 | 12553
482 | 10491
482 | 10614
482 | 10865
482 | 10987
482 | 11109
482 | 11231
482 | 11353
482 | 11475
482 | 11597
482 | 11719
482 | 11815
482 | 11973
482 | 12387
482 | 12879
482 | 12131
482 | 12259
482 | 12515
482 | 12643
482 | 12761
482 | 12997
483 | 9378
483 | 9474
483 | 9570
483 | 9666
483 | 9762
483 | 9858
483 | 9954
483 | 10050
483 | 10146
483 | 10242
483 | 10338
483 | 9966
483 | 10077
483 | 10188
483 | 10299
483 | 10410
483 | 10521
483 | 10632
483 | 10743
483 | 10854
483 | 11324
483 | 11465
514 | 10554
514 | 10652
514 | 11366
514 | 9363
514 | 9481
514 | 9599
514 | 9717
514 | 9835
514 | 9953
514 | 10071
514 | 10479
514 | 10598
514 | 10717
514 | 10836
514 | 10064
514 | 10162
514 | 10260
514 | 10358
514 | 10456
514 | 10750
514 | 10848
514 | 11196
537 | 9936
537 | 10008
537 | 10080
537 | 10363
537 | 10436
537 | 10508
537 | 10580
537 | 10653
537 | 10725
537 | 11030
537 | 11052
537 | 10244
537 | 10316
537 | 10388
537 | 10671
537 | 10744
537 | 10816
537 | 10888
537 | 10961
537 | 11033
537 | 11338
537 | 11360
737 | 9769
737 | 9871
737 | 9973
737 | 10075
737 | 10177
737 | 10279
737 | 10381
737 | 10483
737 | 10585
737 | 10687
737 | 10789
737 | 10277
737 | 10379
737 | 10481
737 | 10583
737 | 10685
737 | 10787
737 | 10889
737 | 10991
737 | 11093
737 | 11195
737 | 11297
811 | 11074
811 | 11202
811 | 11330
811 | 11458
811 | 11586
811 | 11714
811 | 11842
811 | 11970
811 | 12098
811 | 12226
811 | 9598
811 | 9686
811 | 9774
811 | 9934
811 | 10036
811 | 10138
811 | 10240
811 | 10342
811 | 10444
811 | 10714
811 | 10844
811 | 9522
811 | 9609
811 | 9696
811 | 9854
811 | 9957
811 | 10060
811 | 10163
811 | 10266
811 | 10369
811 | 10579
811 | 10690
941 | 8838
941 | 8955
941 | 9072
941 | 9189
941 | 9306
941 | 9423
941 | 9540
941 | 10698
941 | 10894
941 | 11244
941 | 11374
941 | 10140
941 | 10292
941 | 10444
941 | 10596
941 | 10110
941 | 10208
941 | 10306
941 | 10404
941 | 10502
941 | 10600
941 | 10796
1151 | 11464
1151 | 11575
1151 | 11675
1151 | 11775
1151 | 11875
1151 | 11975
1151 | 12076
1151 | 12176
1151 | 12276
1151 | 12376
1151 | 12447
1652 | 16024
1652 | 16236
1652 | 16457
Spreadsheet: 839366d1691887831-formula-to-determine-export-incentive-tax-rate-exoprt-incentives
Sheet: Sheet1

Kindly asking for excel formula to determine export tax incentive rate (row 17) based on percentage of export (row16)
Export tax incentives
% of export products | Tax rate
30%-40% | 0.2
41%-50% | 0.175
51% an above | 0.15
Desired solution
Year | 2011 | 2012 | 2013 | 2014
Sales | 140000 | 296000 | 408000 | 508000
Costs of Sales | 86400 | 189600 | 259200 | 259200
Gross Profit
Expenses | 36000 | 37800 | 39690 | 39690
Taxable Income
Export sales - units % | 0.303030303030303 | 0.4615384615384616 | 0.375 | 0.6
Export tax incentives rate | 0.2 | 0.175 | 0.2 | 0.51