tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 268089d1380421860-index-and-match-frequency-problem-peepingtom
Sheet: Sheet1

Bin | Sector 1 | Sector 2 | Sector 3 | Sector 4 | Sector 5 | Sector 6 | Sector 7 |  |  | Bin | Sector | 34
11 | 13 | 16 | 34 | 22 | 23 | 24 | 20 |  |  | 11 | 3
16 | 66 | 73 | 18 | 11 | 19 | 20 | 29 |  |  | 16 | 3
11 | 26 | 21 | 34 | 33 | 20 | 31 | 30 |  |  | 11 | 7
Spreadsheet: 820988d1678375335-data-selection-using-drop-down-options-book1-andyd1234-
Sheet: Summary

 | Start |  |  | End |  |  | Movement
 | 103 |  |  | 303
 | Qty | Value |  | Qty | Value |  | Qty | Value
No of sales orders | 10 | 976500 |  | 11 | 1039500 |  | 1 | 63000
Status
Won
Lost
In Process
Spreadsheet: 688918d1596022570-averageif-array-for-multiple-variables-excelforumexample
Sheet: ComparisonSheet

[NAME] | 10 | Include Hotels? | Yes
Include Delegate Rates? | No | Capacity <=? | 80
Row Labels | CompetitionCharge | Library Charge
Library 1
Room1 | 23.28 | 39
Room2 |  | 19
Room3 |  | 17
Room4 |  | 11
[NAME]
Room1 |  | 40
Room2 |  | 19
Room3 |  | 15
Room4 |  | 15
Room5 |  | 15
Library 3
Room1 |  | 22
Room2 |  | 17
Room3 |  | 11
Spreadsheet: 845659d1697076796-matching-up-run-number-with-date-and-time-in-one-cell-bbphotos76-tracker-test
Sheet: Route Calculator

 |  | Dispatch Date/Time | SACBOL
 | 1
Spreadsheet: 02389d1c-d165-4da5-984a-8783b32e48cb
Sheet: New Courses 

C &I Meeting Date | New Course Title | Date Approved by AA | Date of BOT Approval | Date submitted to CO | CCC Inventory Number | UC TCA Date Submitted | CSU Sta submitted
2012-11-14 00:00:00 | Political Science 104 | 2012-12-12 00:00:00 | 2013-01-14 00:00:00 | 2013-02-25 00:00:00
2012-11-14 00:00:00 | Political Science 104 Prerequisite | 2012-12-12 00:00:00 | 2013-01-14 00:00:00 | 2013-02-25 00:00:00
2012-12-12 00:00:00 | MATH 131 | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | MATH Prerequisite | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | [NAME] 202 | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | ADMJ Prerequisite | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | ECT 162 | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | ECT 162 Prerequiasite | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | MOA 180 | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | MOA 180  Prerequiasite | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | HIT 184 | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
2012-12-12 00:00:00 | HIT 184 Prerequiasite | 2013-01-30 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00
Spreadsheet: mark_taylor__25054__105657 - O&M 063001
Sheet: Headcount - 105655

 | ENRON NORTH AMERICA
 | ENA - Legal Executive (105655)
 | HEADCOUNT AS OF 06-30-01
Employee | Co | Team | Job Title | Headcount
HAEDICKE,MARK E | 413 | ENA - Legal | Managing Director | 1
 |  |  | Total | 1
ELBERTSON, JANETTE | 413 | ENA - Legal | Other  Non-commercial | 1
 |  |  | Total | 1
 |  |  | Total for 105655
Spreadsheet: jeff_dasovich__14197__PS_3
Sheet: 8.13a

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sidbury, Dennis
8.13(a) |  |  |  |  |  |  |  |  |  |  |  |  |  | E204-2
Objective:  Determine most EOQ and total (minimum) cost. |  |  |  |  |  |  |  |  |  |  |  |  |  | Problem Set #3
 |  | Annual demand |  | 1500 | given |  |  |  |  |  |  |  |  | Ch. 8, #8.13(a) only, 8.15 (a)-(d) only, 8.19
 |  | Minimum order |  | 1 | Constraint |  |  |  |  |  |  |  |  | (2 of 3)
 |  | Maximum order |  | 499 | Constraint |  |  |  |  |  |  |  |  | Date Due:  4/13/00
 |  | Cost per Unit |  | 35 | given
 |  | Cost per Order |  | 20 | given
 |  | Holding Cost |  | 0.2 | given
 |  | Order Quantity |  | 92.58259954114708 | <====Changing Cell #1
 |  | Purchasing Cost |  |  | Cost x demand
 |  | Cost of Ordering |  |  | Demand/Order Quantity*Cost per Order
 |  | Inventory Cost |  |  | Avg. Inv. * Cost per unit * Holding Cost
 |  | Total Cost |  |  | <====Target Cell #1
 |  | Annual demand |  | 1500 | given
 |  | Minimum order |  | 500 | Constraint
 |  | Maximum order |  | 999 | Constraint
 |  | Cost per Unit |  | 33 | given
 |  | Cost per Order |  | 20 | given
 |  | Holding Cost |  | 0.2 | given
 |  | Order Quantity |  | 500 | <====Changing Cell #2
 |  | Purchasing Cost |  |  | Cost x demand
 |  | Cost of Ordering |  |  | Demand/Order Quantity*Cost per Order
 |  | Inventory Cost |  |  | Avg. Inv. * Cost per unit * Holding Cost
 |  | Total Cost |  |  | <====Target Cell #2
 |  | Annual demand |  | 1500 | given
 |  | Minimum order |  | 1000 | Constraint
 |  | Maximum order |  |  | Constraint
 |  | Cost per Unit |  | 31 | given
 |  | Cost per Order |  | 20 | given
 |  | Holding Cost |  | 0.2 | given
 |  | Order Quantity |  | 1000 | <====Changing Cell #3
 |  | Purchasing Cost |  |  | Cost x demand
 |  | Cost of Ordering |  |  | Demand/Order Quantity*Cost per Order
 |  | Inventory Cost |  |  | Avg. Inv. * Cost per unit * Holding Cost
 |  | Total Cost |  |  | <====Target Cell #3 - this is the optimal solution
 |  |  |  |  | (i.e. cost is the lowest of all three scenarios)
Spreadsheet: 123302d1317535443-multiple-if-function-weekly-bills-
Sheet: Sheet1

Row Labels | Sum of Amount
Qtr1 | 4809.679999999978
GST E | -96583.61000000002
GST I | 10045.53
OWNERS DRAW | 91347.76
Qtr3 | -3395.476363636364
GST E | -55069.63636363637
GST I | 51674.16
Qtr4 | -60757.96000000001
GST E | -36952.27
GST I | 91099.65
OWNERS DRAW | -114905.34
Grand Total | -59343.7563636364
Spreadsheet: 888838d1739440185-instead-of-dropdown-selecting-single-need-all-lists-output-tenure-test_v3
Sheet: Bill

Orignal Tenure | Loan Date | New Tenure | Monthly Interest  % | Loan Amount | Orignal Installment |  | 1 | Paid Installment | Late Fee Paid | Total Intrest Paid | Need to Pay | Balance
Installment Paid Date | Suppose to Pay Date | Tenure | Paid Installment | Balance Installment | Instalment | Reducing Pricipal | Interest | Late Intrest Days | Intrest Late Fee | [NAME] | Balance
Spreadsheet: 481640d1474560657-vlook-up-across-2-tables-is-it-possible-481637d1474560068-vlook-up-across-2-tables-is-it-possible-excess-lookup
Sheet: Sheet1

Policy Year | Claim Type | Excess
2013 | Liability
2013 | Liability
2013 | Liability
2013 | Liability
2014 | Liability
2014 | Liability
2015 | Property
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Liability
2015 | Property
Spreadsheet: 886633d1736711158-convert-to-date-mm-dd-yyyy-date-format
Sheet: Sheet1

Birth Date
17/07/1977
15/06/1975
14/01/1980
24/02/1982
1973-08-11 00:00:00
22/01/1986
1974-06-08 00:00:00
1993-05-07 00:00:00
1971-01-04 00:00:00
1995-07-08 00:00:00
13/04/1979
1979-05-06 00:00:00
1958-01-01 00:00:00
13/09/1988
19/01/1985
16/02/1978
1987-10-07 00:00:00
25/02/1974
1982-11-11 00:00:00
1992-07-11 00:00:00
1996-01-01 00:00:00
1998-10-06 00:00:00
1986-04-06 00:00:00
21/09/1980
1987-09-07 00:00:00
23/12/1979
1992-08-07 00:00:00
1992-03-04 00:00:00
18/12/1983
14/08/1984
30/08/1983
1984-01-05 00:00:00
1990-03-06 00:00:00
1973-01-01 00:00:00
1991-01-12 00:00:00
25/01/1989
17/07/1993
14/04/1986
1988-06-11 00:00:00
21/03/1985
1984-09-03 00:00:00
18/12/1989
1984-03-03 00:00:00
1989-01-07 00:00:00
1979-07-05 00:00:00
17/12/1989
30/09/2000
1988-01-10 00:00:00
22/10/1991
13/09/1993
1982-08-06 00:00:00
22/10/1990
1996-02-01 00:00:00
1979-06-12 00:00:00
1989-01-01 00:00:00
19/06/1987
1976-02-01 00:00:00
23/12/1978
21/06/1998
1990-08-06 00:00:00
27/02/1987
18/03/1985
20/12/1981
1981-01-01 00:00:00
25/04/1989
1962-10-10 00:00:00
1989-10-10 00:00:00
1972-01-01 00:00:00
1967-10-09 00:00:00
27/07/1989
20/06/1990
1973-01-01 00:00:00
1986-06-07 00:00:00
1997-10-02 00:00:00
16/01/1978
13/04/1996
20/02/1992
1992-07-09 00:00:00
1973-02-01 00:00:00
18/02/1998
1980-10-09 00:00:00
1994-05-08 00:00:00
1990-01-05 00:00:00
17/06/1988
26/12/1991
1991-11-12 00:00:00
1998-08-07 00:00:00
31/07/1971
1989-01-01 00:00:00
30/11/1998
1995-11-06 00:00:00
17/07/1987
21/05/2003
16/07/2002
25/05/1990
27/03/1992
31/08/1987
1982-09-09 00:00:00
24/11/1978
23/07/1969
1973-01-01 00:00:00
1976-12-11 00:00:00
1989-10-12 00:00:00
13/04/1978
Spreadsheet: 692543d1598424553-allocate-value-on-fifo-basis-book2-2-
Sheet: Sheet1

 | Date | Consumption | Allocation based on oldest to newest date
 |  |  | 50 | This value can be zero/positive/negative
 | 2020-01-31 00:00:00 | 10 |  |  |  |  |  |  |  | 1
 | 2020-03-01 00:00:00 | -200 |  |  |  |  |  |  |  | 2
 | 2020-03-28 00:00:00 | 100 |  |  |  |  |  |  |  | 3
 | 2020-03-13 00:00:00 | 150 |  |  |  |  |  |  |  | 4
 | 2018-05-01 00:00:00 | -50 |  |  |  |  |  |  |  | 5
 | 2020-01-20 00:00:00 | 0 |  |  |  |  |  |  |  | 6
 | 2020-02-03 00:00:00 | 15 |  |  |  |  |  |  |  | 7
 | 2020-02-29 00:00:00 | -50 |  |  |  |  |  |  |  | 8
 | 2020-04-07 00:00:00 | -400 |  |  |  |  |  |  |  | 9
 | 2020-04-05 00:00:00 | 600 |  |  |  |  |  |  |  | 10
 | 2020-01-26 00:00:00 | 0 |  |  |  |  |  |  |  | 11
 | 2020-02-22 00:00:00 | 5 |  |  |  |  |  |  |  | 12
 | 2020-03-01 00:00:00 | 100 |  |  |  |  |  |  |  | 13
 | 2020-03-28 00:00:00 | 300 | 70 | manually adjusted |  |  |  |  |  | 14
 |  | Check |  | should be zero
Spreadsheet: 861597d1709486253-sum-of-values-using-dynamic-references-and-2-conditions-ivka-tracker
Sheet: Sheet1

 | Product Codes
 | BMR1 | [NAME]. | BY1 | [NAME]. | ROS1 | [NAME]. | BSK1 | [NAME].
 | 1 | LB111 | 1 | [NAME] | - | - | 3 | [NAME]
 | 2 | LB111 | - | - | 2 | LB116 | 3 | LB118
 | 3 | LB112 | 5 | [NAME] | - | - | 2 | [NAME]
 | Product Code | [NAME]. | Total
 | BMR1 | LB111 |  |  |  | SUM of the Values if Product Code & Batch Nr. Are Matching
 | BMR1 | LB112
 | BY1 | [NAME]
 | BY1 | LB116
 | BSK1 | [NAME]
 | BSK1 | LB118
Spreadsheet: 129122d1321458299-excel-2007-formula-without-sundays-customer-returns-response-time
Sheet: Nov 2011

 |  |  |  |  | 2012-11-01 00:00:00
 | Company | NC # | Customer | Part # | Job# | Date Issued | Date Received | Date Due | Date Completed | Days to Process |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-13 00:00:00 | Sunday
1 | AAA | 23538 | [NAME] | 12345 D | 24623 | 2011-11-08 00:00:00 | 2011-11-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-20 00:00:00 | Sunday
2 | AAA | 23556 | [NAME] | 12345 D | 23814 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-24 00:00:00 | Holiday
3 | AAA | 23540 | [NAME] | 12345 D | 21877 | 2011-11-08 00:00:00 | 2011-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-25 00:00:00 | Holiday
4 | AAA | 23543 | [NAME] | 12345 D | 23798 | 2011-11-08 00:00:00 | 2011-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-26 00:00:00 | Holiday
5 | AAA | 23539 | [NAME] | 12345 D | 21876 | 2011-11-08 00:00:00 | 2011-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-27 00:00:00 | Sunday
6 | AAA | 23541 | [NAME] | 12345 C | 22021 | 2011-11-08 00:00:00 | 2011-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-04 00:00:00 | Sunday
7 | AAA | 23557 | [NAME] | 12345 D | 22028 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-11 00:00:00 | Sunday
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-18 00:00:00 | Sunday
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-24 00:00:00 | Holiday
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-25 00:00:00 | Sunday
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-26 00:00:00 | Holiday
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 220175d1363089874-accessing-data-in-different-worksheets-by-referencing-from-a-master-worksheet-copy-of-test-1
Sheet: DAX

Date | Close | High | Low
2013-03-08 00:00:00 | 1551.18 | 1552.48 | 1542.94 |  |  |  |  |  |  | System1Buy | BUY
2013-03-07 00:00:00 | 1544.26 | 1545.78 | 1541.46 |  |  |  |  |  |  | System2Buy | BUY
2013-03-06 00:00:00 | 1541.46 | 1545.25 | 1538.11 |  |  |  |  |  |  | System1Sell | False
2013-03-05 00:00:00 | 1539.79 | 1543.47 | 1525.2 |  |  |  |  |  |  | System2Sell | False
2013-03-04 00:00:00 | 1525.2 | 1525.27 | 1512.29
2013-03-01 00:00:00 | 1518.2 | 1519.99 | 1501.48
2013-02-28 00:00:00 | 1514.68 | 1525.34 | 1514.46
2013-02-27 00:00:00 | 1515.99 | 1520.08 | 1494.88
2013-02-26 00:00:00 | 1496.94 | 1498.99 | 1485.01
2013-02-25 00:00:00 | 1487.85 | 1525.84 | 1487.85
2013-02-22 00:00:00 | 1515.6 | 1515.64 | 1502.42
Spreadsheet: thomas_martin__39694__NG_9_Martin
Sheet: Sheet1

 | Trader Performance Summary - North America Traders
 | For Period: 1/2/2001 through 9/28/2001
 |  |  |  |  | Annualized | Ave. Daily | Annualized | Daily | Total amt. | Total amt. | Best | Worst | Ave. | Ave.
 | Desk |  | Trader |  | VAR | VAR | STD P&L | STD P&L | $ made | $ loss | Day | Day | Win | loss
 | Storage | NG | C_Weldon2 |  | 101.8239677851661 | 6.439913171934712 | 117.6053524199943 | 7.438015573479545 | 170 | -98 | 66 | -56 | 15.45454545454546 | -14
 | Waha | NG | D_Farmer |  | 917.1636159323502 | 58.00652026764245 | 626.1114403527137 | 39.59876441206466 | 1529.777527199366 | -1420.800290802465 | 277 | -222 | 28.32921346665492 | -39.46667474451293
 | Texas Firm | NG | E_Bass |  | 21468.45859649707 | 1357.78454035905 | 15635.03815532208 | 988.8466374891048 | 86777.5808342 | -42014.8942602 | 4067.278865699999 | -2706 | 774.7998288767857 | -560.198590136
 | Storage | NG | J_Schwieger |  | 31089.27773125727 | 1966.258568806503 | 21798.07954851857 | 1378.63159981707 | 95569.71113949997 | -53499.8816686 | 4910.9184279 | -6279 | 853.300992316964 | -713.3317555813334
 | Gulf 2 | NG | [NAME] |  | 2942.10104443955 | 186.0748081357849 | 2793.257053696806 | 176.6610876002631 | 10718.62432257362 | -7552.026504985461 | 563.6390874499998 | -1287.0068752 | 100.174059089473 | -94.40033131231826
 | TOTAL MARTIN | NG | T_Martin |  | 27410.92907818701 | 1733.619373368213 | 20578.87024740778 | 1301.522033097627 | 96108.68542873736 | -43162.01953152331 | 6780 | -7655 | 828.5231502477359 | -607.9157680496241
Spreadsheet: 09e60850-5096-4b36-b0b4-3e2398e4ac00
Sheet: Sheet1

Table 6--U.S. textile imports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Oct. | Nov. | Dec. | Dec.
Item | 2013 | 2013 | 2013 | 2012
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 246434.795 | 227964.522 | 235852.838 | 219435.181
Cotton | 55665.934 | 50703.626 | 52152.356 | 46700.87
Linen | 20482.191 | 16760.444 | 17255.552 | 19382.952
Wool | 3997.229 | 3620.656 | 3689.622 | 3358.762
Silk | 501.34 | 555.852 | 607.164 | 529.848
Manmade | 165788.101 | 156323.944 | 162148.144 | 149462.749
Apparel: | 1066601.97 | 844869.987 | 790700.426 | 790893.1270000001
Cotton | 593803.937 | 482087.56 | 440634.091 | 451946.669
Linen | 7965.445 | 6401.589 | 6217.246 | 7010.917
Wool | 35837.727 | 21423.432 | 17267.296 | 16110.126
Silk | 8336.442 | 7338.622 | 7267.923 | 7282.568
Manmade | 420658.419 | 327618.784 | 319313.87 | 308542.847
Home furnishings: | 290871.764 | 243087.017 | 218321.394 | 193737.573
Cotton | 146816.304 | 119829.417 | 119996.504 | 106733.187
Linen | 1055.327 | 1178.674 | 1240.108 | 986.727
Wool | 369.787 | 313.7 | 667.676 | 258.593
Silk | 217.804 | 435.608 | 678.299 | 147.569
Manmade | 142412.542 | 121329.618 | 95738.807 | 85611.497
Floor coverings: | 68628.54699999999 | 67092.72499999999 | 63642.874 | 60398.113
Cotton | 8702.954 | 7919.63 | 8002.148 | 7205.327
Linen | 16249.221 | 17131.055 | 15050.845 | 14811.735
Wool | 10612.525 | 9822.629 | 9757.444 | 10405.418
Silk | 1986.839 | 1661.74 | 2068.22 | 1796.64
Manmade | 31077.008 | 30557.671 | 28764.217 | 26178.993
Total imports: 2/ | 1672915.846 | 1383312.843 | 1308747.833 | 1264806.479
Cotton | 805224.104 | 660725.435 | 620942.007 | 612768.141
Linen | 45752.184 | 41471.761 | 39763.761 | 42192.33
Wool | 50821.744 | 35184.459 | 31382.816 | 30149.962
Silk | 11042.424 | 9991.822 | 10621.605 | 9756.625
Manmade | 760075.39 | 635939.366 | 606037.644 | 569939.421
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 2/12/14.
Spreadsheet: 84181d1284157876-excel-2007-selecting-cells-from-find-box-copy-of-sample-1-
Sheet: Sheet1

 |  |  |  | Person 1 |  |  | Person 2 |  |  | Person 3 |  |  | Person 4 |  | Person 5 | Person 6
Question | 2008 Mean | 2009 Mean | 2010 Mean | 2008 | 2009 | 2010 | 2008 | 2009 | 2010 | 2008 | 2009 | 2010 | 2008 | 2009 | 2009 | 2008 | 2009 | 2010
Group 1 | 7 | 8.666666666666666 | 8.25 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Question 1 | 12 | 13.66666666666667 | 13.25 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Question 2 | 17 | 18.66666666666667 | 18.25 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
Group 2 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Question 1 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Question 2 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Question 3 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Group 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
question 1 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
[NAME] | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Question 3 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Question 4 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
Question 5 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
Group 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Question 1 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Question 2 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Question 3 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Scheduled | Measured | Scheduled | Measured
1 |  |  | 36313 | 20788
2 |  |  | 52453 | 52799
3 |  |  | 61926 | 62645
4 |  |  | 115920 | 119975
5 |  |  | 33175 | 35138
6 |  |  | 30377 | 34457
7 |  |  | 30969 | 34739
8 |  |  | 31300 | 34860
9 |  |  | 31300 | 38560
10 |  |  | 31300 | 10215
11 |  |  | 44800 | 43755
12 |  |  | 41300 | 40672
13 |  |  | 41300 | 40723
14 |  |  | 41300 | 46252
15 |  |  | 46300 | 44413
16 |  |  | 37006 | 36865
17 |  |  | 36300 | 36206
18 |  |  | 31300 | 33399
19 |  |  | 52965 | 52990
20 |  |  | 44500 | 44890
21 |  |  | 24235 | 26725
22 |  |  | 30067 | 31489
23 |  |  | 51880 | 53291
24 |  |  | 43245 | 42568
25 |  |  | 49450 | 49407
26 |  |  | 36300 | 36573
27 |  |  | 36300 | 36032
28 |  |  | 36300 | 36108
29 |  |  | 36300 | 37114
30 |  |  | 35191 | 33878
31 |  |  | 51300 | 48613
index
2001-04-30 00:00:00 |  |  |  |  | 351737.93
2001-05-31 00:00:00
Spreadsheet: 680615d1591111681-simplest-way-to-count-the-unique-number-of-license-plates-minus-all-the-zeros-example
Sheet: What I would like to get

Table 1 |  |  |  |  | Table 2
Local | Operação | Sub-Operação | Nº viaturas |  |  | Operação | Sub-Operação | Consumo de energia (litros) | [NAME] percorrida (VK)
 |  |  | 2018-12-01 00:00:00 |  | Coruche | ABAPOR | SPOA | 85712.4 | 280395
Coruche | ABAPOR | SPOA | 4 |  |  |  | Distribuição | 23364.69 | 57301
 |  | Distribuição | 1 |  |  |  | Transferências SPOA | 57557.14 | 161984
 |  | Transferências SPOA | 1 |  |  | ETSA LOG | [NAME] | 2530.47 | 44200
 | ETSA LOG | [NAME] | 2 |  |  |  | T.Pessoal | 4363.98 | 74596
 |  | T. Pessoal | 2 |  |  | ITS | Bovinos | 411007.91 | 1371164
 | ITS | Bovinos | 18 |  |  |  | Matadouros | 152409.87 | 447915
 |  | Matadouros | 6 |  |  |  | Ovinos | 36940.68 | 302270
 |  | Ovinos | 4 |  |  |  | Suinos | 59456.27 | 195253
 |  | Suinos | 3 |  |  |  | Transferências ACOS | 30878.76 | 84187
 |  | Transferências ACOS | 1 |  |  |  | Transferências ITS | 23850.08 | 72221
 |  | Transferências ITS | 1 |  |  |  | [NAME] | 9900.99 | 37867
 |  | [NAME] | 3 |  |  | SEBOL | Sangue | 30298.92 | 80012
 | SEBOL | Sangue | 1 |  |  |  | Matadouros | 2936.11 | 10424
 |  | Matadouros | 0 |  |  |  | Transferências Sangue | 19216.78 | 50526
 |  | Transferências Sangue | 1 |  | Loures | ABAPOR | SPOA | 49004.41 | 210345
Loures | ABAPOR | SPOA | 8 |  |  | ETSA LOG | [NAME] | 294.8 | 5657
 | ETSA LOG | [NAME] | 0 |  |  |  | T. Pessoal | 5120.42 | 85403
 |  | T. Pessoal | 2 |  |  | SEBOL | Oficina | 6307.57 | 13969
 | SEBOL | Distribuição | 0 |  |  |  | Matadouros | 122353.26 | 359817
 |  | Matadouros | 6 |  |  | ITS | Matadouros | 2500.58 | 6464
 |  | Oficina | 1 |  | Tunes | ABAPOR | SPOA | 20144.21 | 104520
 | ITS | Matadouros | 0 |  | VNG | ABAPOR | SPOA | 93344.82 | 366988
Tunes | ABAPOR | SPOA | 4 |  |  | ETSA LOG | [NAME] | 370.25 | 225
VNG | ABAPOR | SPOA | 7 |  |  |  | T. Pessoal | 8238.02 | 124883
 | ETSA LOG | [NAME] | 4 |  |  | ITS | Matadouros | 38504.96 | 112613
 |  | T. Pessoal | 4 |  |  | SEBOL | Matadouros | 59731.5 | 165940
 | ITS | Matadouros | 3 |  |  |  | Sangue | 8169.58 | 21430
 | SEBOL | Matadouros | 5 |  |  |  | Talhos | 73492.42 | 319003
 |  | Sangue | 1 |  |  |  | Transferências Fiais | 35277.44 | 94996
 |  | Talhos | 6 |  |  |  | [NAME] | 144681.96 | 462728
 |  | Transferências Fiais | 2 |  | TOTAL |  |  | 1617961 | 5725296
 |  | [NAME] | 3
Total |  |  | 104
Spreadsheet: f5116fb7-497a-4129-bb6f-6de494810593
Sheet: Sheet1

HPT Teaching Allocation - School to complete the information below and send to HR to produce the HPT contract | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
School name | HPT Name | HPT Job Title | Contract Start Date | Contract End Date | Hourly rate (only complete if higher than standard rate, where approved by the Faculty Manager) | Teaching Delivery (enter total hours of teaching delivery or leave blank) | Teaching Preparation (enter total hours of teaching preparation or leave blank) | Assessment (enter total hours of teaching assessment or leave blank) | Related duties (enter total hours of any related duties or leave blank) | Specify the related duties from this list: Essay Tutorials, Meetings, Student queries, Student feedback, Support, Training, Other (if other, specify) | Total contracted Hours  (enter total contracted hours if the breakdown of hours has not been provided) | Any additional information (e.g. specific course information to go on the contract, keep brief)
Spreadsheet: 41043d1239482207-summing-column-with-exception-excelextract
Sheet: Insider Processor

FLORIDA
Name | ID | Gross Profit | Light | Tax | Debit | Net Profit
Avis | 1223 | 15000 | 350 | 55 | 30 | 14565
Go West | 35555 | 5000 | 150 | 55 | 30 | 4765
Discount Center | 45454 | 3489 | 200 | 55 | 30 | 3204
Collectables | 45433 | 80033 | 7000 | 55 | 30 | 72948
Shimmer | 75533 | 42000 | 4000 | 55 | 30 | 37915
Truck Stop | 65633 | 34444 | 3000 | 55 | 30 | 31359
The Reef | 76687 | 4000 | 135 | 55 | 30 | 3780
TOTAL |  | 183966 | 14835 | 385 | 210 | 168536
Spreadsheet: 126996d1320095311-copying-vlookup-across-multiple-columns-forum
Sheet: Sheet2

a | 1 | 2 | 3 |  |  | a
b | 4 | 5 | 6 |  |  | b
c | 7 | 8 | 9
d | 10 | 11 | 12
e | 13 | 14 | 15