tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 119212d1314272435-populating-sheets-from-entered-data-test
Sheet: DATA

 | order number |  | 123456 | <<< information entered
 | style code |  | AA1AA111 | <<< information entered
 | colour |  | BLACK | <<< information entered
 | size type |  | A | <<< information entered
 | A | XS | S | M | L | XL | XXL | XXXL
 | B | 26 | 28 | 30 | 32 | 34 | 36 | 38
 | C | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | D | OS | 3 | 4 | 5 | 6 | 7 | 8
 | BOX
 | 1 |  | 10 |  |  |  |  |  | <<< information entered
 | 2 |  | 9 |  |  |  |  |  | <<< information entered
 | 3 |  |  | 10 |  |  |  |  | <<< information entered
 | 4 |  |  | 10 |  |  |  |  | <<< information entered
 | 5 |  |  | 10 |  |  |  |  | <<< information entered
 | 6 |  |  | 8 |  |  |  |  | <<< information entered
 | 7 |  |  |  | 10 |  |  |  | <<< information entered
 | 8 |  |  |  | 10 |  |  |  | <<< information entered
 | 9 |  |  |  | 7 |  |  |  | <<< information entered
 | 10 |  |  |  |  | 10 |  |  | <<< information entered
 | 11 |  |  |  |  | 9 |  |  | <<< information entered
 | 12 |  | 5 | 5 |  |  |  |  | <<< information entered
 | 13 |  |  |  | 8 | 2 |  |  | <<< information entered
 | 14
 | 15
 | 16
 | 17
 | 18 |  | This spreadsheet is trying to create labels for boxes (sheets 1+) depending on the data entered into this sheet
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 36 | 58
Cap/Floor | 0 | 221
Debt Option | 0 | 0
Exotic | 0 | 0
Fixed-Fixed | 0 | 42 | 42
Fixed-Float | 12895 | 2851
FRA | 16 | 122
Inflation | 0 | 235
OIS | 17 | 136
Swaption | 0 | 1200
TOTAL
Spreadsheet: 113823d1309706258-pull-column-from-one-sheet-to-another-affiliated-new-order-book
Sheet: Oil Isle

Order | Item # | UPC # | Name | Cost | % |  | # of Items | SRP
 | 93673 | 0-71611-93855 | PENNZOIL 2-CYCLE ENGINE OIL - 16 oz - SNGL |  | 0.25
 | 94263 | 0-71153-00203 | STP BRAKE FLUID |  | 0.25
 | 93643 | 9-71153-78573 | STP-GAS TREATMENT - 5.25 oz |  | 0.25
 | 34320 | DON'T REORDER | MAGNUM ATF TYPE A TRANS F - QT |  | 0.25
 | 93714 | 0-80565-30901 | CAM2 ATF MULTI D/M TRANS F - QT |  | 0.25
 | 93416 | 0-46087-00017 | BARS LEAK RADIATOR STOP L. - .75 oz |  | 0.25
 | 34366 | 0-15400-82141 | SF CHARCOAL BRIQUETS - 8.3 lbs |  | 0.25
 | 89636 | 0-77071-03407 | LF BAIT BUCKET FOAM 8 QT - 12 EA |  | 0.25
 | 89639 | 0-77071-17449 | LF FOAM CHEST AMERICAN FL - 12 EA |  | 0.25
 | 93865 | 0-79567-11005 | WD-40 AEROSOL SMART STRAW |  | 0.25
 | 84830 | 0-24291-14832 | SC HOSE CLAMP ASTD |  | 0.25
 | 93472 | 0-44549-81005 | BLITZ GAS CAN ENVIRO CARB |  | 0.25
 | 94930 | 0-70792-73027 | HH FUNNEL 1/2 PINT |  | 0.25
 | 93434 | 0-74245-07455 | PENN FIX-A-FLAT W/HOSE 6P |  | 0.25
 |  |  | [NAME]
 |  |  | Quacker State Advance Durability 5W-30
 |  |  | Penzoil Grenplus 80W-90 Grease Lubricant
 |  |  | Mystic Super Heavy Duty Eng Oil Senthetic Blend
 |  |  | Phillips Trop Artic 10W-40
 |  |  | STP Power Steering
 |  |  | [NAME]
 |  |  | Gojo Natural Orange
 |  |  | Mystic JT6 NO 2
1 |  |  | [NAME] Starting Fluid
 |  |  | Pyroil De Icer
 |  |  | Armorall Orginal Protected Wipes
 |  |  | Citgo Transgard multi purpose ATF
 |  |  | Fram CA 6366
 |  |  | gojo Natural Orange
 |  |  | [NAME]
 |  |  | Kingford
 |  |  | Wrap on fiber glass
 |  |  | [NAME]
 |  |  | Machanics Air Force Time Inflation
 |  |  | Super-X Tire Inflation
 |  |  | Parade Lighter Fluid
 |  |  | Kingsford Match Light
Spreadsheet: 07b355d0-0503-4614-b032-ebbabc743218
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  |  | Ending
August 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 |  |  |  | 1,000 short tons
2010/11 | 341.601 | 6098.1 | 0 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/121 | 617.563 | 5370 | 71.601 | 6059.164 |  | 2400 | 132.58 | 3107.584 | 5640.164 | 419
2012/132 | 419 | 5810 | 100 | 6329 |  | 2600 | 300 | 2939 | 5839 | 490
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-09-17 13:39:35.330000
Spreadsheet: 723507d1615741378-i-was-asked-to-use-vlookup-and-sum-functions-to-calculate-the-market-share-of-an-item-market-share
Sheet: Sheet1

 |  | Calculate the market share of  "Product A" in May'15 from sales data given below?
 |  | (Please use vlookup and sum formulas)
 |  |  | Sales in units
 |  | PRODUCTS | 2015-01-16 00:00:00 | 2015-02-16 00:00:00 | 2015-03-16 00:00:00 | 2015-04-16 00:00:00 | 2015-05-16 00:00:00 | 2015-06-16 00:00:00 | 2015-07-16 00:00:00 | 2015-08-16 00:00:00 | 2015-09-16 00:00:00 | 2015-10-16 00:00:00 | 2015-11-16 00:00:00 | 2015-12-16 00:00:00
 |  | Product A | 11 | 7 | 240 | 251 | 177 | 279 | 37 | 45 | 165 | 125 | 26 | 149
 |  | Product B | 226 | 63 | 18 | 119 | 226 | 32 | 213 | 175 | 42 | 131 | 150 | 34
 |  | Product C | 32 | 196 | 248 | 300 | 15 | 167 | 177 | 120 | 27 | 33 | 269 | 125
 |  | Product D | 49 | 212 | 17 | 183 | 188 | 28 | 64 | 17 | 143 | 37 | 126 | 283
 |  | Product E | 128 | 182 | 146 | 12 | 28 | 35 | 176 | 38 | 217 | 227 | 241 | 88
 |  | Product H | 300 | 293 | 151 | 69 | 165 | 37 | 80 | 87 | 8 | 12 | 42 | 122
 |  | Product I | 138 | 72 | 188 | 132 | 12 | 257 | 184 | 223 | 93 | 118 | 98 | 179
 |  | Product J | 110 | 161 | 109 | 253 | 279 | 104 | 41 | 16 | 1 | 57 | 165 | 207
 |  | [NAME] | 278 | 239 | 205 | 278 | 147 | 84 | 111 | 201 | 118 | 276 | 188 | 122
 |  | Product L | 176 | 139 | 209 | 168 | 52 | 68 | 37 | 207 | 45 | 18 | 23 | 184
 |  | Product M | 60 | 85 | 296 | 220 | 9 | 262 | 182 | 91 | 255 | 22 | 287 | 91
 |  | Product N | 153 | 110 | 233 | 292 | 125 | 15 | 134 | 36 | 260 | 276 | 126 | 113
 |  | Product O | 155 | 185 | 82 | 134 | 60 | 284 | 38 | 157 | 126 | 73 | 116 | 19
 |  | Product P | 262 | 13 | 136 | 8 | 10 | 91 | 115 | 163 | 8 | 34 | 178 | 201
 |  | Product Q | 129 | 159 | 204 | 276 | 223 | 76 | 133 | 38 | 80 | 78 | 238 | 121
 |  | Product R | 25 | 255 | 172 | 53 | 232 | 277 | 183 | 275 | 158 | 20 | 145 | 273
 | Answer:
Spreadsheet: 780588d1652576652-help-wanted-removing-false-return-when-linked-cell-is-blank-false-excel-problem-help-required-copy
Sheet: AC Materials

ASPHALT MATERIALS COST |  |  |  |  |  |  | ALL Materials - Grouped By Establishment
ESTABLISHMENT No. | AC PAY ITEMS | AREA (M2) | DEPTH (MM) | AC TYPE | TONNES |  | Grouped By Establishment | Tonnes | No. of Shifts | Tonnes Per Shift | Total ($) | $[NAME]
 |  |  |  |  |  |  | ONE |  | 1
 |  |  |  |  |  |  | TWO |  | 1
 |  |  |  |  |  |  | THREE |  | 1
 |  |  |  |  |  |  | FOUR |  | 1
 |  |  |  |  |  |  | FIVE |  | 1
 |  |  |  |  |  |  | SIX |  | 1
 |  |  |  |  |  |  | SEVEN |  | 2
 |  |  |  |  |  |  | EIGHT |  | 2
 |  |  |  |  |  |  | NINE |  | 0
 |  |  |  |  |  |  | TEN |  | 0
 |  |  |  |  |  |  |  |  | DG=2.4 / OG=1.8 / SMA=2.3 / GG=2.3 / SLAG=2.5
 |  | EXBIN CALCULATOR
ESTABLISHMENT No. | PAY ITEM | PLANT LOCATION | MIX TYPE | BINDER | SPEC | AREA     (m2) | DEPTH (MM) | DENSITY | TONNES | EXBIN BASE RATE | SASOL | OTHER | TRANSFER RATE | MARGIN | AC MATERIAL COSTS | SHIFT TYPE | MARGIN |  | RATE PER TONNE
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
 |  |  |  |  |  |  |  | TOTAL:
 |  | CARTAGE CALCULATOR
ESTABLISHMENT No. | PAY ITEM | PLANT LOCATION | MIX TYPE | SUBURB |  | DISTANCE |  | TONNES | TRUCK TYPE | NUMBER OF LOADS | TOLLS EACH WAY | CARTAGE RATE |  | SHIFT TYPE | MARGIN | CARTAGE COSTS |  | CARTAGE GROUPED BY ESTABLISHMENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Establish Number | Tonnes | Total Sum | Rate Per Tonne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | One
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Two
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Three
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Four
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Five
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Six
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Seven
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Eight
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Nine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ten
 |  |  |  |  |  |  | TOTAL: |  |  |  |  | TOTAL:
TACK COAT CALCULATOR
ESTABLISHMENT No. | PAY ITEMS | LAYER | REQUIRED? |  | QUANTITY         (m2) | NUMBER OF LITRES |  | RATE | TOTAL
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  | Wearing Course |  |  |  |  |  | 1.5
 |  |  |  |  | TOTAL: |  |  | TOTAL:
Spreadsheet: 836658d1689569496-sum-formula-error-fornightly-pay-calculation-copy
Sheet: Tax LSE

ATO Schedule 5 - Lump Sum E Tax - Method B(ii)
Employee Pay Info | Total Lump Sum E (LSE) Amount to be paid | 0
 | YTD Taxable Gross | 0
 | Number of pays in YTD | 0
Step 1: | Average Earnings YTD (YTD Taxable Gross/Pays YTD)
Step 2: | Tax on Average Earnings YTD (Tax on Step 1) | 0
Step 3: | Total Lump Sum E Payments/pays in the year (LSE $/26)
Step 4: | [NAME] to Average Earnings (Step 3 + Step 1)
Step 5: | Tax on Amount in Step 4 | 0
Step 6: | Subtract Amount in Step 2 from Step 5
Step 7: | Multiply Amount in Step 6 by number of pays in the year (26)
Step 8: | n/a
Step 9: | Multiply Lump Sum E by 47% (Maximum tax amount that can be deducted)
Step 10: | Use the lesser amount in Step 7 and 9 as tax on Lump Sum payment
 | Tax on Lump Sum  E - Method B (ii)
Spreadsheet: 598751d1542702125-multiple-column-lookup-multi-column-lookup-match-1-
Sheet: Sheet1

Date | ValueA | ID | ValueB | ID | [NAME] | ID
2018-11-01 00:00:00 | 33.2 | M94 | 5 | [NAME] | 20.1 | M97
2018-11-01 00:00:00 | 32.1 | M98 | 8 | M100 | 19.2 | M101
2018-11-01 00:00:00 | 31.2 | M120 | 10 | M122 | 23.6 | M123
2018-12-01 00:00:00 | 30.1 | M94 | 5.2 | [NAME] | 20.4 | M97
2018-12-01 00:00:00 | 31.6 | M98 | 8.5 | M100 | 19.8 | M101
2018-12-01 00:00:00 | 32.8 | M120 | 10.4 | M122 | 24.1 | M123
ID | Description | 2018-11-01 00:00:00 | 2018-12-01 00:00:00
Section 1
M94 | ValueA
M95
[NAME] | ValueB
M97 | [NAME]
Section 2
M98 | ValueA
M99
M100 | ValueB
M101 | [NAME]
Spreadsheet: 683503d1592795246-adding-data-to-a-table-on-basis-of-dropdown-selection-sample
Sheet: Sheet1

 | Comm Plans/Profiles | 5
 | Quality of Service Type
 |  | [NAME]
 | Quality of Service Type
 | Comm Plans/Profiles | Quality of Service Type
 |  | Data 1 | [NAME]
 |  | Data 3 | [NAME]
 |  | Data 1 | [NAME]
 |  | Data 4 | Polo
Spreadsheet: 103419d1301155743-calculations-help-columnrowexample
Sheet: Sheet1

 |  | 3 | 4 | 5 | 6 | 7
 |  | 0.3333333333333333 | 0.25 | 0.2 | 0.1666666666666667 | 0.1428571428571428
 |  | 0.1111111111111111 | 0.0625 | 0.04000000000000001 | 0.02777777777777778 | 0.02040816326530612
 |  | 0.03703703703703703 | 0.015625 | 0.008000000000000002 | 0.004629629629629629 | 0.002915451895043731
 |  | 0.01234567901234568 | 0.00390625 | 0.001600000000000001 | 0.0007716049382716049 | 0.0004164931278633902
 |  | 0.004115226337448559 | 0.0009765625 | 0.0003200000000000002 | 0.0001286008230452675 | 5.949901826619859e-05
 |  | 0.001371742112482853 | 0.000244140625 | 6.400000000000004e-05 | 2.143347050754458e-05 | 8.499859752314083e-06
 |  | 0.0004572473708276177 | 6.103515625e-05 | 1.280000000000001e-05 | 3.572245084590763e-06 | 1.214265678902012e-06
Spreadsheet: sally_beck__35054__sap status
Sheet: Sheet1

Balance Sheet Reconciliation Status Report
As of:  May 26, 2000
Responsible Party | Enron Entity | Account Name | Number of Counterparties | Balance Per GL 4/30/00 | Balance Per Subledger 4/30/00 | Difference between G/L and [NAME] | Balance > 90 Days | Proposed Write-offs as of 5/26/00 | Account [NAME] as of 5/26/00 | $$ Change | Item Count Change | Item Count > 90 Days | Comments
 | Co. 12 - HPLC
[NAME] | 1420-100-21774 |  |  |  |  |  | 84819.32
[NAME] (Contractors) | [PHONE] |  |  |  |  |  |  |  |  |  |  | 849 | Acct. balances being reconciled by Gen. [NAME]. and [NAME]. Ops
[NAME] | [PHONE]
[NAME] | 1420-100-21771 |  |  |  |  |  | 1798758.7 |  |  |  |  | 250
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  |  | 13
[NAME] | [PHONE]
 | [PHONE]
 | [PHONE]
 | 2320-100-21772 |  |  |  |  |  | 0
 | [PHONE] |  |  |  |  |  | -980672.64
 |  | Totals for Co. 12
 | Co. 16 - ENA
[NAME] | [PHONE]
 | 1420-100-21771 |  |  |  |  |  | 25299694.21
[NAME] | [PHONE]
 | 2320-100-000088888 |  |  |  |  |  |  |  |  |  |  | 3004
 | 2320-100-000099999
 | [PHONE] |  |  |  |  |  |  |  |  |  |  | 5511
 | 2320-100-21772
 | [PHONE]
 | [PHONE]
[NAME] | 2320-600-00004
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  |  | 620
[NAME] | 2320-601-00004
 |  | Total for Co. 16
 | Co. 51 - Panhandle
 | [PHONE] |  |  |  |  |  |  | -178479.1 |  |  |  | 1
 |  | Totals for Co.51
 | Co.54- [NAME]
[NAME] | [PHONE] |  |  |  |  |  |  | -7701.5 |  |  |  | 1
 | [PHONE]
 |  | Totals for Co. 54
 | Co. 78 - HPLR
 | [PHONE] |  |  |  |  |  |  | -3838.22 |  |  |  | 950
 | 1420-100-21771 |  |  |  |  |  | 428247.52 |  |  |  |  | 95
[NAME] | [PHONE]
 | 1420-400-21771
 | [PHONE]
 | [PHONE] |  |  |  |  |  |  |  |  |  |  | 13100
 | [PHONE] |  |  |  |  |  | 2725635.71
 | 2320-100-21772 |  |  |  |  |  | 313740.34
 | [PHONE] |  |  |  |  |  | -19270.03
[NAME] | [PHONE]
[NAME] | 2320-400-21772
[NAME] | 2320-400-21774
[NAME] | [PHONE]
 |  | Totals for Co. 78
 | Co. 488 - Louisiana Gas Mktg.
 | [PHONE]
 | 1420-100-21771 |  |  |  |  |  | 2568887.39 |  |  |  |  | 38
[NAME] | [PHONE]
 | [PHONE]
 | [PHONE]
 | [PHONE] |  |  |  |  |  |  |  |  |  |  | 75
[NAME] | [PHONE] |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 2320-400-21772
[NAME] | [PHONE]
 |  | Totals for Co. 488
 | Co. 495 - Louisiana Gas P/L
[NAME] | [PHONE] |  | 6 |  |  |  |  | 19433
 |  | Totals for Co. 495
 | Co. 496 - Louisiana Resources P/L
[NAME] | [PHONE] |  |  |  |  |  |  | -1250
 | 1420-100-21771
[NAME] | 1420-100-21774
[NAME] | [PHONE]
 | [PHONE]
 |  | Totals for Co. 496
 |  | Grand totals for All Companies
Spreadsheet: 39210d1237398706-vlookup-formula-signuplisting-5-
Sheet: ACC

ACC | Total Attendees: | 4 |  |  |  |  |  |  |  |  | Summary
Clive Ward-Able | Management |  |  |  | Location: | Orlando, Florida
Ewan Robson | RML |  |  |  | Date: | 2009-03-29 00:00:00
[NAME] | RML |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | Med Comm |  |  |  | Tier 1 Meeting:
 |  |  |  |  | Committed:
 |  |  |  |  | Booth:
 |  |  |  |  | [NAME]: | 1 | Management
 |  |  |  |  |  | 1 | Medical Communications
 |  |  |  |  |  | 0 | Medical Directors
 |  |  |  |  |  | 0 | Medical Information
 |  |  |  |  |  | 2 | RMLs
 |  |  |  |  | Hotel Information:
 |  |  |  |  | Links:
Spreadsheet: 757303d1638184169-trying-to-get-xlookup-to-look-at-2-tables-headwalls
Sheet: Surface Manhole

Depth Range | Value | M/H Ref. | Cover | Invert | Depth to Soffit | M/H Ø (m)
1.5 |  | 101 | 132.637 | 131.212 |  | 1800
2 |  | 102 | 132.82 | 130.959 |  | Headwall 450
2 |  | 103 | 131.996 | 130.204 |  | 1500
2 |  | 104 | 131.774 | 129.841 |  | 2100
3.25 |  | 105 | 127.584 | 124.435 |  | 2100
4.75 |  | 106 | 128.979 | 124.356 |  | 2700
3 |  | 107 | 127.225 | 124.262 |  | 2700
2.25 |  | 108 | 126.246 | 124.213 |  | Headwall 150
1.75 |  | 109 | 125.86 | 124.188 |  | Headwall 750
Spreadsheet: darrell_schoolcraft__7418__ONEOKRECAP2002
Sheet: Feb 02

INTERNAL REPORT ONLY |  |  | FEBRUARY ONEOK IMBALANCE SUMMARY |  |  |  |  |  |  |  | POI 420 |  | 78109 |  | POI 78108 |  | POI 78107 |  | 65, 62867,61491 | POI 71410 |  | POI 61491
 | SUBLETTE | HOLCOMB | HUGOTON |  | BUSHTON PVR |  | MULLINVILLE |  | BUSHTON PROD. |  | DELHI BEAVER |  | ELLIS CO #1/#2 |  | WWD CO #1 |  | CLARK CO #1 |  | HEMPHILL/CANADIAN |  |  |  |  | ONEOK
 | 103132 | 103134 | TOTAL DEVIATION |  | 103135 |  | 103133 |  | 103138 |  | 106901 |  | 107444 |  | 107445 |  | 107446 |  | 108308 | 108307 |  | 108309 |  | TOTAL DEVIATION |  |  | SUBLETTE | HOLCOMB | HUGO | PVR | MULL | BUSHTON | D.BVR | ELL 1 | WWD 1 | CLK 1 | HEMP/CAN |  |  |  |  |  |  |  |  |  | ONEOK
2002-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103132 | 103134 | TOTAL | 103135 | 103133 | 103138 | 106901 | 107444 | 107445 | 107446 | 104307 |  |  |  |  |  |  |  |  |  | TOTAL DEVIATION
(EST) BEGINNING BALANCE | 173672 | -391832 |  |  | 75970 |  | 8232 |  | -13589 |  | -1578 |  | 33819 |  | -10206 |  | 4848 |  | -8521 | 18139 |  | -22219
2002-02-01 00:00:00 | -4415 | -3487 |  |  | 5386 |  | -154 |  | -86 |  | 172 |  | 368 |  | -281 |  | 9 |  | 558 | -1084 |  | 0
2002-02-02 00:00:00 | 1583 | -3284 |  |  | 6785 |  | -146 |  | -67 |  | 322 |  | 538 |  | -100 |  | 18 |  | 85 | -1069 |  | 0
2002-02-03 00:00:00
2002-02-04 00:00:00
2002-02-05 00:00:00
2002-02-06 00:00:00
2002-02-07 00:00:00
2002-02-08 00:00:00
2002-02-09 00:00:00
2002-02-10 00:00:00
2002-02-11 00:00:00
2002-02-12 00:00:00
2002-02-13 00:00:00
2002-02-14 00:00:00
2002-02-15 00:00:00
2002-02-16 00:00:00
2002-02-17 00:00:00
2002-02-18 00:00:00
2002-02-19 00:00:00
2002-02-20 00:00:00
2002-02-21 00:00:00
2002-02-22 00:00:00
2002-02-23 00:00:00
2002-02-24 00:00:00
2002-02-25 00:00:00
2002-02-26 00:00:00
2002-02-27 00:00:00
2002-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
VOLUME ADJ. | 0 | -69 |  |  | 0 |  | -60 |  | 273 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0
December CUMULATIVE
EST ENDING BALANCE
 |  |  |  |  |  |  |  |  |  |  | BAD DAS
 |  |  | 3161324
 |  |  | 3162595
Spreadsheet: 868696d1715352302-nested-array-query-fail-alternatives-nested_array-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORMULA
Query Criteria (filter array result) |  |  |  |  | Query Data |  |  |  |  | expected return
a1 |  |  |  |  | a1 | a1-d1 | a1-z1 |  |  | a1 | a1-d1 | a1-z1 |  |  |  | a1-d1 | a1-z1 |  |  | a1-d1 | a1-z1
a3 |  |  |  |  | a1 | [NAME] | [NAME] |  |  | a1 | [NAME] | [NAME] |  |  | a1 | [NAME] | [NAME] |  | a1 | [NAME] | [NAME]
a5 |  |  |  |  | a1 | a1-d3 | [NAME] |  |  | a1 | a1-d3 | [NAME] |  |  | a1 | a1-d3 | [NAME] |  | a1 | a1-d3 | [NAME]
 |  |  |  |  | a2 | a2-d1 | a2-z1 |  |  | a3 | a3-d1 | a3-z1 |  |  | a3 | a3-d1 | a3-z1 |  | a3 | a3-d1 | a3-z1
 |  |  |  |  | a3 | a3-d1 | a3-z1 |  |  | a3 | a3-d2 | [NAME] |  |  | a3 | a3-d2 | [NAME] |  | a3 | a3-d2 | [NAME]
 |  |  |  |  | a3 | a3-d2 | [NAME] |  |  | a5 | a5-d1 | a5-z1 |  |  | a5 | a5-d1 | a5-z1 |  | a5 | a5-d1 | a5-z1
 |  |  |  |  | a4 | a4-d1 | a4-z1
 |  |  |  |  | a4 | [NAME] | a4-z2
 |  |  |  |  | a5 | a5-d1 | a5-z1
using byrow/lambda |  |  |  |  | using filter only
Spreadsheet: 168040d1342196292-sum-hours-by-indicated-date-sum-hours-by-date
Sheet: Sheet1

Job | 2012-01-15 00:00:00 | 2012-01-31 00:00:00 | 2012-02-15 00:00:00 | 2012-02-29 00:00:00 | 2012-03-15 00:00:00 | 2012-03-31 00:00:00 | 2012-04-15 00:00:00 | 2012-04-30 00:00:00 | 2012-05-15 00:00:00 | 2012-05-31 00:00:00 | 2012-06-15 00:00:00 | 2012-06-30 00:00:00 | 2012-07-15 00:00:00 | 2012-07-31 00:00:00 | 2012-08-15 00:00:00 | 2012-08-31 00:00:00 | 2012-09-15 00:00:00 | 2012-09-30 00:00:00 | 2012-10-15 00:00:00 | 2012-10-31 00:00:00 | 2012-11-15 00:00:00 | 2012-11-30 00:00:00 | 2012-12-15 00:00:00 | 2012-12-31 00:00:00 | Total | Job | Actual
Cost of Sale |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] A Estates LLC Cost of Sale | 2012-04-15 00:00:00
Hours - Cost of Sale |  |  | 8 |  |  |  |  | 6.5 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours - Cost of Sale
Spreadsheet: 757460d1638278103-how-to-combine-data-from-mutiple-sheets-and-generate-a-report-natraj-yarn-stock-fresh-copy
Sheet: Copy of YARN REPORT

DATE | YARN IN BILL | CODE TYPE | MOVEMENT | YARN CODES | INVOICE NO./CHALLAN NO. | PARTY NAME | YARN CODE | YARN | WEFT STOCK | WARP STOCK | WEFT IN | WARP IN | WEFT OUT | WARP OUT | TYPE | YARN UQC | PO NO.
Spreadsheet: 716387d1612191699-formula-to-look-up-2-columns-of-data-and-return-data-from-another-worksheet-cost-calculator
Sheet: Pricing

Part No. | Product Description | Package Type | Weight (g) | Post Cost
ABC | Part ABC | LL | 300 | 2
DEF | Part DEF | RM | 750 | 2.5
GHI | Part GHI | OS | 2000 | 18
JKL | Part JKL | P | 5050 | 6
Spreadsheet: 887722d1738054684-merging-data-from-multiple-workbooks-sorting-alphabetically-creating-new-workbooks-workbook-example-2-to-merge
Sheet: P2 Tricky Words

Rm | Surname | First Name | Tricky Words Read / Locate
 |  |  | the | to | I | no | go
2 | Circle | [NAME] | 1 | 1 | 1 | 1 | 1
2 | Square | Immy | 1 | 1 | 1 | 1 | 1
2 | Hexagon | [NAME] | 1 | 1 | 1 | 1 | 1
2 | Rectangle | [NAME] | 1 | 1 | 1 | 1 | 1
2 | Triangle | [NAME] | 1 | 1 | 1 | 1 | 1
2 | Rhombus | [NAME] | 1 | 1 | 1 | 1 | 1
2 | Star | April | 1 | 1 | 1 | 1 | 1
2 | Octagon | [NAME] | 1 | 1 | 1 | 1 | 1
2 | Decagon | Sonya | 1 | 1 | 1 | 1 | 1
2 | Cube | Michelle | 1 | 1 | 1 | 1 | 1
2 | Cylinder | [NAME] | 1 | 1 | 1 | 1 | 1
Spreadsheet: martin_cuilla__25348__Bowl2000
Sheet: possible

favorite | underdog
Spreadsheet: 0755eb77-70af-4336-81e3-9d3ef9ce7863
Sheet: Sheet1

ยอดโอนเข้าบัญชี สาขาเพชรบุรี | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
หลักฐานการโอนเงินจัดสรร OPD [NAME] เดือน ตุลาคม2555 - มิถุนายน 2556
วันที่ .................................................. |  |  | ขอส่งเช็คเพื่อโอนเงินเข้าบัญชีเงินฝากของสถานพยาบาลเครือข่าย
ถึง ธนาคารเพื่อการเกษตรและสหกรณ์การเกษตร |  |  | ของโรงพยาบาลพระจอมเกล้า จังหวัดเพชรบุรี
จากโรงพยาบาลพระจอมเกล้า จังหวัดเพชรบุรี |  |  | ในวันที่.................................................................…
กระทรวงสาธารณสุข |  |  | เช็คธนาคารเพื่อการเกษตรและสหกรณ์การเกษตร สาขาเพชรบุรี
จังหวัดเพชรบุรี |  |  | ตามรายละเอียดดังนี้
ลำดับ | ชื่อสถานพยาบาล | [NAME] | งวดที่1 - 3 เดือน ตุลาคม2555 - มิถุนายน 2556
1 | ศูนย์บริการสาธารณสุข | 004-2-37205-7 | 124164.53
2 | [NAME] 8 | 004-2-36654-5 | 211067.86
 | รวมทั้งสิ้น |  | 335232.39
 |  |  | ลงชื่อ …………………………………
 |  |  | (นางสาวศิริพร ศรนารายณ์)
 |  |  | นักวิชาการเงินและบัญชีชำนาญการ
ธนาคารเพื่อการเกษตรและสหกรณ์การเกษตร สาขาเพชรบุรี ได้รับเช็คและโอนเงินเข้าบัญชีเงินฝากตามรายชื่อข้างต้น
ในวันที่……………………………………….
 |  | ลงชื่อ……………………………………………..
 |  | (……………………………………………….)
 |  | ตำแหน่ง……………………………………………….