tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 107986d1305108079-isblank-plus-if-plus-complicated-average-isblank_if
Sheet: Sheet1

I started with manual input |  |  |  | I then wanted to extract an automatic calculation |  |  |  |  |  |  |  | and then the problem ran into the following
 |  |  |  | that gave me a cost that but this does not take into account previous cost
Position | Open |  |  | Position | Open | Cost | Adjust col D to number |  |  |  |  | Position | Open | Cost | Adjust col D to number
Flat | 1400 |  |  | Flat | 1400 | 1400 |  |  |  |  |  | Flat | 1400 | 1400
Long 1 | 1405 |  |  | Long 1 | 1405 | 1405 | 1 |  |  |  |  | Long 1 | 1405 | 1405 | 1
Long 1-1/2 | 1395 |  |  | Long 1-1/2 | 1395 | 1395 | 1.5 |  |  |  |  | Long 1-1/2 | 1395 | 1395 | 1.5
Long 2 | 1410 |  |  | Long 2 | 1410 | 1410 | 2 |  |  |  |  | Long 1 | 1400 | 1400 | 1
Long 3 | 1425 |  |  | Long 3 | 1425 | 1425 | 3 |  |  |  |  | Flat | 1390 | 1390
Long 4 | 1426 |  |  | Long 4 | 1426 | 1426 | 4 |  |  |  |  | short 1 | 1395 | 1395
Long 5 | 1423 |  |  | Long 5 | 1423 | 1423 | 5 |  |  |  |  | short 2 | 1386 | 1386
Long 6 | 1440 |  |  | Long 6 | 1440 | 1440 | 6 |  |  |  |  | short 1 | 1395 | 1395
 |  |  |  |  |  |  |  |  |  |  |  | Because the criteria
 |  |  |  | But Cell F4 should be blank |  |  |  |  |  |  |  | short in Col Position has been added I did not
 |  |  |  |  |  |  |  |  |  |  |  | know how to incorporate this
 |  |  |  |  |  |  |  |  |  |  |  | as IF statement has already used up
 |  |  |  |  |  |  |  |  |  |  |  | 7 Ifs
 |  |  |  |  |  |  |  |  |  |  |  | end result looked for
NOTE: |  |  |  |  |  |  |  |  |  |  |  | Position | Open | Cost | Adjust col D to number
position can be Flat or Long 1 through Long 9 inclusive or short 1 through short 6 inclusive |  |  |  |  |  |  |  |  |  |  |  | Flat | 1400
If necessary I can do away with the -1/2s as perhaps that complicates |  |  |  |  |  |  |  |  |  |  |  | Long 1 | 1405 | 1405 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Long 1-1/2 | 1395 | 1401.6 | 1.5
 |  |  |  |  |  |  |  |  |  |  |  | Long 1 | 1400 | 1401.6 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Flat | 1390
 |  |  |  |  |  |  |  |  |  |  |  | short 1 | 1395 | 1395 | 1
 |  |  |  |  |  |  |  |  |  |  |  | short 2 | 1386 | 1390.5 | 2
 |  |  |  |  |  |  |  |  |  |  |  | short 1 | 1395 | 1390.5 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | this sorts out the cost Col returning a blank if the Position
 |  |  |  |  |  |  |  |  |  |  |  | Column is Flat
 |  |  |  |  |  |  |  |  |  |  | 2 | This sorts out the Average of Cost taking into account previous
 |  |  |  |  |  |  |  |  |  |  |  | Cost
 |  |  |  |  |  |  |  |  |  |  | 3 | Note that on a reduction of position the Cost remains at the
 |  |  |  |  |  |  |  |  |  |  |  | previous high cost
 |  |  |  |  |  |  |  |  |  |  | 4 | Thi sorts out the incorporation of position whether long or short
Spreadsheet: 847455d1698368562-help-with-formula-to-print-text-from-one-column-if-other-columns-have-certain-text-sample1-stryped-
Sheet: Spreadsheet 1

Area | Position | Shift | Name
B-End | Operator | 1 | [NAME]
B-End | Operator | 1 | Jones
A-End | Supervisor | 3 | Felix
C=End | Operator | 2 | Smith
B-End | Operator | 2 | [NAME]
C-End | Manager | 1 | Milam
A-End | Supervisor | 1 | [NAME]
B-End | Supervisor | 1 | Dandy
B-End | Supervisor | 3 | Colby
Spreadsheet: 268708d1380746653-help-to-amend-sumproduct-formula-to-minus-depending-on-entry-in-another-column-test-page
Sheet: Sheet3

Aberdeen | North East |  | 1 | SNS |  |  |  | 75 | Cst Internal
Ayr | Central Belt West |  | 4 | Single Phase down |  |  |  | 72 | [NAME]
CENT.EAST | Central Belt East |  | 5 |  |  |  |  | 77 | GS11
CENT.WEST | Central Belt West |  | 6 |  |  |  |  | 76 | Metering
Borders | Central Belt West |  | 7 |  |  |  |  | 99 | Misc
Cumbernauld | Central Belt West |  | 8 |  |  |  |  | 1 | January
Buchan | North East |  | 9 |  |  |  |  | 2 | February
Dingwall | Highland |  | 10 | Fire |  |  |  | 3 | March
Dumfries | Central Belt West |  | 11 | Intermit |  |  |  | 4 | April
Dumbarton | Central Belt West |  | 12 | Voltage comp |  |  |  | 5 | May
Dunblane | Tayside & Central |  | 13 | Alarm |  |  |  | 6 | June
Dundee | Tayside & Central |  | 14 | Other |  |  |  | 7 | July
[NAME] | Argyll & West |  | 15 | Recon |  |  |  | 8 | August
East Kilbride | Central Belt West |  | 16 | PP1 |  |  |  | 9 | September
Edinburgh | Central Belt East |  | 17 | Mtr |  |  |  | 10 | October
Elgin/Huntly | North East |  | 18 | PP2 |  |  |  | 11 | November
Fife | Central Belt East |  | 19 | PP3 |  |  |  | 12 | December
Falkirk | Central Belt East |  | 20 | PP4
[NAME] | Argyll & West |  | 21 | PP5
Greater Glasgow | Central Belt West |  | 22 | PP6
Inverness | Highland |  | 23 | Tree on Line
Kilmarnock | Central Belt West |  | 24 | Explosion
Lanark | Central Belt West |  | 25 | Do not use
Oban | Argyll & West |  | 26 | Emergency
[NAME] | [NAME] |  | 27 | Arcing OHL
Paisley | Central Belt West |  | 28 | Arcing Other
Perth | Tayside & Central |  | 29 | Install Problem
Shetland | Shetland |  | 30 | CALLBACK
[NAME] | Argyll & West |  | 31 | GAS
Western Isles | Western Isles |  | 33 | PSI QUERY
Wick | Highland |  | 34 | HEAT
 |  |  | 35 | ELI
 |  |  | 36 | SOB
 |  |  | 37 | [NAME]
Spreadsheet: 828165d1683274954-get-spilling-counts-ranks-get_spilling_rank
Sheet: Feuil1

type |  |  |  |  |  |  |  | type |  | rank copy down (works) |  | rank spilling (does not work)
A
A |  |  |  |  |  |  |  | A |  |  |  | #REF!
B |  |  |  |  |  |  |  | B |  |  |  | #REF!
B |  |  |  |  |  |  |  | B |  |  |  | #REF!
B |  |  |  |  |  |  |  | B |  |  |  | #REF!
C |  |  |  |  |  |  |  | C |  |  |  | #REF!
C |  |  |  |  |  |  |  | C |  |  |  | #REF!
Spreadsheet: 680954d1591277052-summarise-data-using-formulas-example
Sheet: Result

Temporary difference
Depreciation
Unrealised exchange loss
Provision for obsolete stock
Provision for bad & doubtful debt
Provision for restructuring cost-Jnr
Provision for restructuring cost-Snr
Non temporary difference
Depreciation on [NAME] asset
Penalties, fines & non-recoverable taxes
Lease interest expense
Temporary difference
Profit on disposal of PPE
Non temporary difference
Total
Spreadsheet: sally_beck__35477__projected 2002 budget saving
Sheet: Sheet1

Enron America's Projected Cost Savings
Salaries |  | 2237916
Benefits & Tax |  | 553884
Subtotal
Assocaties |  | 864000
Analysis |  | 280800
Contractors |  | 300000
Logistics Trip |  | 100000
Employee expense |  | 150000
[NAME]
Total Savings
Spreadsheet: 32550d1228757443-vlookup-or-if-statements-widgets-gidgets-lidgets
Sheet: Sheet1

Widgets | 3 | 9
Gidgets | 6 | 9
lidgets | 5 | 10 | < -- found first exact match.
widgets | gidgets | lidgets | Field1
1 | 3 | 5 | 10
7 | 5 | 5 | 7
4 | 3 | 7 | 8
3 | 6 | 5 | 9
6 | 1 | 2 | 3
Spreadsheet: 698714d1602144546-vlookup-to-be-variable-by-month-example
Sheet: Mar-21

date | 2021-03-01 00:00:00 |  |  |  |  | 2021-03-02 00:00:00 |  |  |  |  | 2021-03-03 00:00:00 |  |  |  |  | 2021-03-04 00:00:00 |  |  |  |  | 2021-03-05 00:00:00
item | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5
person 1 | 6 | 7 | 6 | 7 | 6 | 1 | 2 | 2 | 1 | 2 | 7 | 8 | 7 | 8 | 7 | 6 | 7 | 6 | 7 | 6 | 4 | 5 | 5 | 6 | 5
person 2 | 2 | 3 | 2 | 3 | 2 | 4 | 5 | 5 | 6 | 5 | 3 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 3 | 2 | 8 | 7 | 3 | 3 | 2
person 3 | 0 | 1 | 0 | 1 | 0 | 1 | 5 | 7 | 1 | 2 | 2 | 3 | 2 | 3 | 2 | 6 | 7 | 6 | 7 | 6 | 4 | 3 | 1 | 7 | 6
person 4 | 2 | 3 | 2 | 3 | 2 | 3 | 4 | 3 | 7 | 8 | 0 | 1 | 0 | 1 | 0 | 2 | 3 | 2 | 3 | 2 | 3 | 2 | 2 | 1 | 3
person 5 | 6 | 7 | 6 | 7 | 6 | 2 | 3 | 2 | 8 | 7 | 2 | 3 | 2 | 3 | 2 | 0 | 1 | 0 | 1 | 0 | 2 | 1 | 6 | 7 | 6
person 6 | 2 | 3 | 2 | 3 | 2 | 4 | 5 | 5 | 6 | 5 | 1 | 2 | 1 | 2 | 1 | 2 | 3 | 2 | 3 | 2 | 4 | 5 | 5 | 6 | 5
person 7 | 0 | 1 | 0 | 1 | 0 | 8 | 7 | 3 | 3 | 2 | 3 | 4 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 8 | 7 | 3 | 3 | 2
person 8 | 2 | 3 | 2 | 3 | 2 | 4 | 3 | 1 | 7 | 6 | 2 | 3 | 5 | 2 | 8 | 7 | 8 | 7 | 8 | 7 | 4 | 3 | 1 | 7 | 6
person 9 | 1 | 2 | 1 | 2 | 1 | 3 | 2 | 2 | 1 | 3 | 5 | 6 | 6 | 5 | 3 | 3 | 4 | 3 | 4 | 3 | 3 | 2 | 2 | 1 | 3
person 10 | 7 | 8 | 7 | 8 | 7 | 2 | 1 | 6 | 7 | 6 | 1 | 2 | 2 | 1 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 1 | 6 | 7 | 6
person 11 | 3 | 4 | 3 | 4 | 3 | 2 | 1 | 6 | 5 | 6 | 4 | 5 | 5 | 6 | 5 | 0 | 1 | 0 | 1 | 0 | 1 | 7 | 6 | 4 | 3
person 12 | 2 | 3 | 2 | 3 | 2 | 7 | 1 | 2 | 1 | 2 | 1 | 5 | 7 | 1 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 1 | 3 | 3 | 2
person 13 | 0 | 1 | 0 | 1 | 0 | 1 | 2 | 1 | 4 | 5 | 7 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 8 | 7 | 6 | 6 | 5
person 14 | 2 | 3 | 2 | 3 | 2 | 4 | 5 | 4 | 2 | 1 | 7 | 8 | 4 | 5 | 4 | 7 | 8 | 7 | 1 | 2 | 3 | 5 | 9 | 2 | 1
person 15 | 1 | 2 | 1 | 2 | 1 | 3 | 3 | 2 | 5 | 4 | 8 | 7 | 3 | 3 | 2 | 4 | 7 | 8 | 7 | 8 | 2 | 0 | 3 | 4 | 3
Spreadsheet: 3f3da7d2-3395-498b-98c2-30f6fd1cec64
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Dec. | Jan. | Feb. |  | Feb.
Region/country | 2013 | 2014 | 2014 |  | 2013
 | 1,000 pounds 1/
North America | 126147.956 | 107336.796 | 131188.644 |  | 132256.313
Canada | 2650.07 | 2570.917 | 2776.455 |  | 2724.511
Costa Rica | 352.284 | 172.569 | 428.077 |  | 788.641
Dominican Republic | 4836.861 | 4233.296 | 6321.39 |  | 6358.245
El Salvador | 21454.375 | 13589.676 | 18437.802 |  | 18308.671
Guatemala | 7625.182 | 6276.437 | 7713.495 |  | 7761.34
Haiti | 9870.263 | 9064.227 | 12604.372 |  | 12292.378
Honduras | 26406.457 | 17422.389 | 25633.969 |  | 28209.277
Mexico | 38215.884 | 39282.197 | 40392.66 |  | 42105.729
Nicaragua | 14719.551 | 14634.486 | 16875.057 |  | 13652.658
South America | 4038.24 | 4215.851 | 3900.089 |  | 3865.94
Colombia | 1637.477 | 1502.693 | 1418.382 |  | 1663.199
Peru | 2208.495 | 2471.179 | 2275.102 |  | 2020.194
Europe | 11844.843 | 11265.47 | 10655.707 |  | 10037.095
Germany | 1002.564 | 950.001 | 840.506 |  | 958.4
Italy | 1783.291 | 1648.907 | 1595.817 |  | 1448.906
Portugal | 1198.517 | 1648.164 | 1006.264 |  | 1107.773
Turkey | 5260.313 | 4620.221 | 4605.378 |  | 4480.481
Turkmenistan | 658.693 | 482.257 | 357.391 |  | 87.912
Asia | 464528.488 | 561645.752 | 476444.298 |  | 521706.8
Bahrain | 1638.068 | 1535.24 | 1459.818 |  | 1331.887
Bangladesh | 35791.506 | 53167.288 | 45753.328 |  | 51746.584
Cambodia | 14151.178 | 16278.375 | 17975.687 |  | 17091.386
China | 204402.039 | 241662.517 | 193916.879 |  | 229485.161
Hong Kong | 724.772 | 971.004 | 528.673 |  | 811.289
India | 60226.036 | 66381.362 | 56884.756 |  | 58861.543
Indonesia | 20361.075 | 28858.744 | 25226.922 |  | 29632.134
Israel | 625.84 | 1107.747 | 976.901 |  | 792.455
Japan | 1119.785 | 1049.012 | 954.557 |  | 914.717
Jordan | 4517.307 | 4749.102 | 4238.894 |  | 4332.655
Malaysia | 2608.321 | 2899.899 | 2687.118 |  | 2963.467
Pakistan | 52410.165 | 65480.212 | 54487.941 |  | 52624.61
Philippines | 3506.532 | 4236.087 | 4101.079 |  | 4892.683
South Korea | 5127.101 | 7692.49 | 4264.708 |  | 5039.854
Sri Lanka | 7204.405 | 8706.686 | 7937.006 |  | 6420.051
Taiwan | 1970.411 | 2345.505 | 2028.388 |  | 2471.331
Thailand | 5810.107 | 6103.222 | 4964.064 |  | 6658.897
United Arab Emirates | 735.266 | 416.968 | 513.155 |  | 422.773
Vietnam | 41098.262 | 47625.531 | 47058.465 |  | 44717.441
Oceania | 17.797 | 82.472 | 34.704 |  | 10.305
Africa | 14364.683 | 15670.1 | 12188.945 |  | 11443.885
Egypt | 7415.911 | 8820.115 | 6488.507 |  | 6835.211
Kenya | 2076.901 | 1977.613 | 1687.477 |  | 1250.237
[NAME] | 2009.654 | 2645.941 | 1960.549 |  | 1522.063
[NAME] | 1366.258 | 926.684 | 1034.7 |  | 726.662
World 2/ | 620942.007 | 700216.441 | 634412.386 |  | 679320.418
 |  |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update:  04/11/14.
Spreadsheet: eric_saibi__9972__111501
Sheet: Trinidad 06

Owner Name |  | TXU Electric
Station Name |  | Trinidad Power Station
Unit Name |  | Unit 06
NERC Region |  | ERCOT
State |  | TX
Fuel Type |  | Natural Gas / Fuel Oil
Capacity |  | 239 MW
Start Date |  | 2001-10-19 00:00:00
End Date |  | 2001-11-18 00:00:00
Prv. Start Date |  | 2001-10-19 00:00:00
Prv. End Date |  | 2001-11-15 00:00:00
Comments |  | Control Upgrade / Boiler Work
SIC |  | 4911
Plant ID |  | 1000538
Unit ID |  | 1008669
Outage ID |  | 12034
Spreadsheet: 583058d1532206224-using-if-function-across-separate-tables-items-and-transactions
Sheet: Sheet1

 | Order ID | Item | Device
 | M3VMP1NNRXKJ0 | Appe
 | M3VMP1NNRXKJ0 | Pear
 | M3VMP1NNRXKJ0 | Bannana
 | V0AYZ14YVRCCR | Meat
 | V0AYZ14YVRCCR | Cheese
 | Z0K8EP92C31AP | Chocolate
 | KCFZBMNGDENC0 | Pear
 | KCFZBMNGDENC0 | Cheese
 | What It should be
 | Order ID | Device | Item
 | M3VMP1NNRXKJ0 | Store 1 | Appe
 | M3VMP1NNRXKJ0 | Store 1 | Pear
 | M3VMP1NNRXKJ0 | Store 1 | Bannana
 | V0AYZ14YVRCCR | Store 2 | Meat
 | V0AYZ14YVRCCR | Store 2 | Cheese
 | Z0K8EP92C31AP | Store 3 | Chocolate
 | KCFZBMNGDENC0 | Store 1 | Pear
 | KCFZBMNGDENC0 | Store 1 | Cheese
Spreadsheet: 492629d1481186407-i-need-to-create-a-dropdown-box-that-will-move-data-to-another-sheet-davy-quotes-template
Sheet: Sheet3

- Quotes
Date | Time | Company | Name | Telephone | Account/Cash | Description
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
 |  |  |  |  |  |  | dropdown box to remove data
Spreadsheet: 78749d1279067293-excel-2007-is-it-possible-to-return-an-array-using-hlookup-excel-hlookup-help
Sheet: Sheet1

 | date
input: | 2010-04-01 00:00:00
 | name
output:
 |  | Sales by day (sales numbers are never identical)
 | 2010-04-01 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-05 00:00:00
[NAME] | 1 | 2 | 3 | 4
jake | 2 | 3 | 4 | 5
bob | 3 | 6 | 5 | 8
[NAME] | 4 | 9 | 6 | 9
kat | 5 | 8 | 7 | 3
[NAME] | 6 | 7 | 8 | 5
What I would like to do is change the INPUT:date to whatever date I want, and have hlookup return the correct arrays for MAX and MATCH, so I don't have to manually change the formula if I want a new date.
Obviously I can do this easily by using FILTER DATA or PIVOT TABLES, but this particular forumula is required or a larger project
Spreadsheet: 216030d1361561983-permutations-3-columns-permuation-sheet
Sheet: Sheet1

1
Cum: | 27 | 9 | 3
Count: | 3 | 3 | 3
 | Item1 | Item2 | Item3
 | HL1 | DL1 | DL1.1
 | HL2 | DL2 | DL2.1
 | HL3 | DL3 | DL3.1
 | HL4
# | Permutations
1 | HL1 | DL1 | DL1.1
2 | HL1 | DL1 | DL2.1
3 | HL1 | DL1 | DL3.1
4 | HL1 | DL2 | DL1.1
5 | HL1 | DL2 | DL2.1
6 | HL1 | DL2 | DL3.1
7 | HL1 | DL3 | DL1.1
8 | HL1 | DL3 | DL2.1
9 | HL1 | DL3 | DL3.1
10 | HL2 | DL1 | DL1.1
11 | HL2 | DL1 | DL2.1
12 | HL2 | DL1 | DL3.1
13 | HL2 | DL2 | DL1.1
14 | HL2 | DL2 | DL2.1
15 | HL2 | DL2 | DL3.1
16 | HL2 | DL3 | DL1.1
17 | HL2 | DL3 | DL2.1
18 | HL2 | DL3 | DL3.1
19 | HL3 | DL1 | DL1.1
20 | HL3 | DL1 | DL2.1
21 | HL3 | DL1 | DL3.1
22 | HL3 | DL2 | DL1.1
23 | HL3 | DL2 | DL2.1
24 | HL3 | DL2 | DL3.1
25 | HL3 | DL3 | DL1.1
26 | HL3 | DL3 | DL2.1
27 | HL3 | DL3 | DL3.1
Spreadsheet: 03dbe0c4-a774-485a-b7a8-661fb6dc16e9
Sheet: 2012 math grade 5

[NAME] |  | Total Number | [NAME]
Grade 5 |  |  | Inconclusive | Exploring | Emerging | Developing | Novice | No Score
2010 | All Students | 629 | 14 | 15 | 19 | 37 | 10 | 5
2011 |  | 673 | 14 | 14 | 19 | 39 | 10 | 4
2012 | All Students | 641 | 16 | 17 | 19 | 33 | 10 | 5
 | Black or African American | 41 | 7 | 22 | 15 | 39 | 15 | 2
 | Hispanic or Latino | 205 | 13 | 18 | 22 | 34 | 9 | 5
 | White | 349 | 19 | 15 | 17 | 33 | 11 | 5
 | Two or more races | 21 | 14 | 33 | 19 | 29 |  | 5
 | Minority | 292 | 11 | 20 | 22 | 33 | 9 | 5
 | English Learners | 97 | 14 | 23 | 23 | 29 | 4 | 7
 | Free/Reduced Lunch | 344 | 12 | 17 | 20 | 37 | 10 | 4
 | Female | 240 | 15 | 18 | 20 | 34 | 8 | 4
 | Male | 398 | 16 | 16 | 19 | 33 | 11 | 6
Spreadsheet: 156240d1337239562-manage-data-using-macro-send-out
Sheet: output 1

Zone | Code | name | dealer | workshop
E | 11 | a | 2 | 2
S | 13 | b | 3 | 0
S | 12 | c | 1 | 1
N | 34 | d | 1 | 0
W | 45 | e | 1 | 0
W | 32 | f | 0 | 1
Spreadsheet: 843351d1695222620-copying-over-date-in-separate-sheet-with-new-rows-book1
Sheet: Sheet2

 | D | P | I | N
2023-09-20 00:00:00 | QQ | WW | EE | 1
2023-09-20 00:00:00 | AA | SS | DD | 2
2023-09-20 00:00:00 | ZZ | XX | CC | 3
2023-09-21 00:00:00 | WWW | EEE | RRR | 11
2023-09-21 00:00:00 | SSS | DDD | FFF | 55
2023-09-21 00:00:00 | GGG | HHH | KKK | 77
2023-09-22 00:00:00 | RRRR | FFFF | DDDD | 66
Spreadsheet: 713677d1610878475-how-can-i-make-calculations-on-specific-rows-book1-1-
Sheet: Sheet1

 |  |  |  | Maybe???
1 | 10 | 1
2 | 9 | 2
3 | 8 | 4
4 | 7 | 7
5 | 6 | 11
6 | 5 | 16
7 | 4 | 22
8 | 3 | 29
9 | 2 | 37
10 | 1 | 46
Spreadsheet: 325001d1402598998-need-help-pulling-column-headers-based-on-table-values-not-max-or-min-excel-forum-file-test
Sheet: Data_Sender by Receiver

SOURCE DATA FILE
 |  | Receiver
 | Total by Sender | Chemicals | Metals | Liquids
Sender
Division A |  | 186196 | 0 | 0
Division B |  | 0 | 0 | 411380
Division C |  | 0 | 58500 | 0
Division D |  | 0 | 142699 | 1738252
FINISHED PRODUCT that I would like to be formula driven
Sender | Receiver | Amount
Division A | Chemicals | 186196
Division B | Liquids | 411380
Division C | Metals | 58500
Division D | Metals | 142699
Division D | Liquids | 1738252
Spreadsheet: 685904d1594256440-removing-duplicates-based-on-multiple-values-book1
Sheet: Sheet1

Column1 | Column2 | Column3 |  |  | 1 | [NAME] | Contact | Donor
1 | [NAME] | Contact |  |  | 2 | [NAME] | Contact | Donor | Staff
1 | [NAME] | Donor |  |  | 3 | [NAME] |  | Donor | Staff
2 | [NAME] | Donor
2 | [NAME] | Contact |  |  |  | I want it to look like this ^^
2 | [NAME] | Staff
3 | [NAME] | Staff
3 | [NAME] | Donor
Looks like this ^^
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: TOTAL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - CONSOLIDATED VARIANCE
COMPANY:  ALL
REGION: ALL
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 014c3ce4-a049-4d98-8656-6a2fa7609577
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | AGEs 125: Sample (Experimental Groups)
 | State | Control | Treatment | Pure Control | Training Control | Total
 | Chiapas | 51 | 60 | 66 | 42 | 219
 | Guerrerro | 45 | 35 | 8 | 18 | 106
 | Puebla | 18 | 25 | 21 | 18 | 82
 | Yucatan | 11 | 5 | 5 | 2 | 23
 | Total | 125 | 125 | 100 | 80 | 430
 | Notes:
 | Pure control and training control groups were included in the sample for the last two rounds (2009 and 2010)
 | AGEs 125: Collection Dates
 | State | Baseline | 1st Follow-Up | 2nd Follow-Up | 3rd Follow-Up
 |  | 2007 | 2008 | 2009 | 2010
 | Chiapas | 10/12/07 - 11/21/07 | 07/01/08 - 12/01/08 | 01/11/10 - 02/05/10 | 05/17/10 - 06/11/10
 | Guerrerro | 10/15/07 - 11/20/07 | 06/09/08 - 07/17/08 | 01/13/10 - 02/09/10 | 05/19/10 - 06/15/10
 | Puebla | 10/09/07 - 10/18/07 | 06/09/08 - 06/17/08 | 01/18/10 - 02/12/10 | 05/19/10 - 06/15/10
 | Yucatan | 10/17/07 - 10/30/07 | 06/03/08 - 06/13/08 | 01/18/10 - 02/12/10 | 05/24/10 - 06/18/10
 | Notes:
 | The responsibles for the baseline and first follow-up collections of data were teachers working for each State Education Minister.
 | A survey firm, named INSAD, was hired to organized the second and third collections of data. This firm was also responsible for training the enumerators.
 | The 2nd follow-up collection of data was carried out until 2010 due to the swine flu epidemic, which caused the closure of all schools at the end of school year 2008-2009.
Spreadsheet: 769856d1645709991-formula-to-determine-overdue-dates-with-an-either-or-condition-cf-overdue-incomplete-aligw
Sheet: Sheet1

Job Number | Job Status | Due Date
1 | Complete | 2022-02-18 00:00:00
2 | Started | 2022-02-18 00:00:00
3 |  | 2022-02-19 00:00:00
4 | Complete | 2022-02-19 00:00:00
5 | Referred | 2022-02-20 00:00:00
6 |  | 2022-02-20 00:00:00
7 | Referred | 2022-02-21 00:00:00
8 | Started | 2022-02-21 00:00:00
9 |  | 2022-02-22 00:00:00
10 | Complete | 2022-02-22 00:00:00
11 | Referred | 2022-02-23 00:00:00
12 |  | 2022-02-23 00:00:00
13 | Complete | 2022-03-01 00:00:00
14 | Started | 2022-03-01 00:00:00
15 |  | 2022-03-02 00:00:00
16 | Referred | 2022-03-02 00:00:00
Spreadsheet: 88428d1288261411-rearranging-data-example
Sheet: Start

Name Parent | Name Child 1 | Name Child 2 | Name Child 3 | Text Child 1 | Text Child 2 | Text Child 3
Parent 1 | abc | def | ghi | rst | uvw | xyz
Parent 2 | jkl | - | - | opq | - | -
etc.
Spreadsheet: 155222d1336731888-calculating-the-plane-of-a-physical-object-bestfit_data_results3
Sheet: Sheet1

 | Probe # | X | Y | Z | Differential
 | 14 | -185.95 | 1.54 | -0.0903 | 0.0905514805514461
 | 15 | -106.58 | 11.45 | 0 | -0.07787581437695659
 | 16 | 30.38 | 11.68 | 0.0285 | -0.2593189075366647
 | 17 | 97.24 | 11.68 | -0.2881 | -0.01750244290170241
 | 18 | 189.1 | -56.27 | -0.6207 | 0.1393395695335547
 | 19 | 191.01 | -142.63 | -0.8096 | 0.2333097312766821
 | 21 | 174.23 | -264.83 | -0.7395 | 0.05067518655058637
 | 23 | 106.28 | -337.86 | -0.5756 | -0.1156925618660139
 | 24 | 30.38 | -353.42 | -0.4078 | -0.2153170531445666
 | 25 | -93.88 | -353.42 | -0.3936 | -0.09053177154687844
 | 26 | -195.48 | -337.92 | -0.6162 | 0.2623625834605133
 | Tolerance |  |  | 0.5 | NG
 | Min | 191.01 | 11.68 | 0.0285 | -0.2593189075366647
 | [NAME] | -195.48 | -353.42 | -0.8096 | 0.2623625834605133
 | Calculated plane | 0.001074494912853088 | -0.00111850500312959 | -0.2093891380313675
 |  | -0.00111850500312959 | 0.001074494912853088 | -1 | -0.2093891380313675
 |  | -0.001118503657798249 | 0.001074493620456829 | -0.9999987972057901 | -0.2093888861793246
 | Faltness |  |  |  | 0.5216814909971781
 |  | OK |  | NG