tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 192895d1352614540-combining-of-3-pivot-tables-datas-into-1-how-sales-datas
Sheet: Plant-3

 | Plant | G/L Code | Doc.No. | Pstng Date | Material Group | Qty | Amount | D/C
 | HHHU | QA10101110 | 92766574 | 01.10.2012 | PPRADRSCC | -45 | -1805897.7 | H
 | HHHU | QA10101110 | 92766575 | 01.10.2012 | SPRADRSCC | -20 | -772750.2 | H
 | HHHU | QA10101110 | 92766576 | 01.10.2012 | PPRADRSCC | -35 | -1407528.85 | H
 | HHHU | QA10101110 | 92766577 | 01.10.2012 | SPRADRSCC | -19 | -735709.64 | H
 | HHHU | QA10101110 | 92766577 | 01.10.2012 | SPRADRSCC | -11 | -425937.16 | H
 | HHHU | QA10101110 | 92766578 | 01.10.2012 | PPRADRSCC | -24 | -982125.84 | H
 | HHHU | QA10101140 | 92766574 | 01.10.2012 | PPRADRSCC |  | -41355 | H
 | HHHU | QA10101140 | 92766575 | 01.10.2012 | SPRADRSCC |  | -18380 | H
 | HHHU | QA10101140 | 92766576 | 01.10.2012 | PPRADRSCC |  | -29190 | H
 | HHHU | QA10101140 | 92766577 | 01.10.2012 | SPRADRSCC |  | -15846 | H
 | HHHU | QA10101140 | 92766577 | 01.10.2012 | SPRADRSCC |  | -9174 | H
 | HHHU | QA10101140 | 92766578 | 01.10.2012 | PPRADRSCC |  | -2016 | H
 | HHHU | QA10101140 | 92766579 | 01.10.2012 | PPRADRSCC |  | -18825 | H
 | HHHU | QA10101145 | 92766574 | 01.10.2012 | PPRADRSCC |  | -839.7 | H
 | HHHU | QA10101145 | 92766575 | 01.10.2012 | SPRADRSCC |  | -359.6 | H
 | HHHU | QA10101145 | 92766576 | 01.10.2012 | PPRADRSCC |  | -653.1 | H
 | HHHU | QA10101145 | 92766577 | 01.10.2012 | SPRADRSCC |  | -341.62 | H
 | HHHU | QA10101145 | 92766577 | 01.10.2012 | SPRADRSCC |  | -197.78 | H
 | HHHU | QA10101145 | 92766578 | 01.10.2012 | PPRADRSCC |  | -461.04 | H
 | HHHU | QA10101145 | 92766579 | 01.10.2012 | PPRADRSCC |  | -279.9 | H
Spreadsheet: 721775d1614858896-dynamic-sheet-reference-in-formula-index-match-usinf-indirect-formula-error-example-sheet
Sheet: Tax Analysis by Entity

 | 2018 Income Statement | Entity | Company 1 | Company 2
 |  | Year | 2018 | 2018
 | Revenue | Income from the activity |  |  |  | INDEX(INDIRECT("'"&B$2&"'!"&"$B$9:$AO$256"),MATCH('Tax Analysis by Entity'!$C4,'2018 Income Statement'!$B$9:$B$256,0),MATCH('Tax Analysis by Entity'!D$2,INDIRECT("'"&B$2&"'!"&"$B$8:$AO$8"),0))
 | Cost of sales | Cost of sales
 | Gross profit | Margin on Contracts
 | Research and Development expenses | Research and Development expenses
 | Sales and marketing expenses | Sales and marketing expenses
 | General and administrative expenses | General and administrative expenses
 | Other costs | Other costs
 | Restructuring costs | Restructuring costs
 | Net income from operations | Operating income
 | Financial expenses | Financial expense total
 | Financial income | Financial income total
 | Net finance costs
 | Share of results of joint ventures and associates (equity method) | Share of P&L in affiliates Equity Method
 | Profit before taxation | Profit before taxation
 | Income tax expense | Income Tax
 | Profit after taxation from Continuing and Discontinued operations
 | Attributable to non-controlling interests | Minority Interest
 | Attributable to BU Mining shareholders | Net income, group share
Spreadsheet: cc082c76-2f9c-4375-83d0-354add6645a1
Sheet: Sheet1

Academic Integrity Referral Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Option I:  Informal
Within 10 calendar days of the observation or discovery of the violation, an informal meeting between the faculty member/administrator and student should take place to resolve the issue.  If no resolution agreement is reached, the faculty member/administrator should initiate an Option II Referral within 10 calendar days after that meeting.  Please refer to the Academic Integrity Policy for further details.
Student Being Referred |  |  |  | Faculty/Administrator Making Referral
Name: |  |  |  | Name:
Local Address: |  |  |  | Department:
 |  |  |  | Dept. Address:
Banner #: |  |  |  | E-mail:
E-mail: |  |  |  | Phone:
Local Phone:
Date of Referral |  | Date/Time of Alleged Violation |  | Course Number, [NAME], and Section Alleged Violation Occurred
Alleged Violation  (include reference from Academic Integrity Policy)
Resolution Agreement (attach additional page if necessary)
Signatures
We have participated in a meeting to resolve the academic violation described in this referral.  We fully accept the conditions of the resolution agreement as defined.
Referring Person(s) |  |  |  | Referred Student
 |  |  |  | My signature indicates that I agree to the terms
Signature |  |  | date | of the resolution agreement and, thus, I waive
 |  |  |  | my right to appeal this resolution.
Signature |  |  | date
Signature |  |  | date | Signature |  |  | date
Distribution by referring person(s):
Original: | Referring Person(s)
Copy: | Referred Student
This is an informal resolution and not does become a part of the student's permanent record.
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 17

 | Income tax and social contribution |  | 3Q10 | 3Q11 | YTD 10 | YTD 11
 | R$ million
 | Profit before tax |  | 2343.548 | 2324.634 | 6520.441 | 7236.575
 | Adjustment on taxable basis
 |  | Non-taxable net financial and other income | -137.583 | 30.918 | -380.646 | -173.215
 |  | Goverment grants (VAT) | -88.3 | -98.584 | -260.028 | -286.042
 |  | Share of results of associates | -0.074 | -0.119 | -0.027 | -0.228
 |  | Hedging results | 0.303 | -13.305 | 5.268000000000001 | 0
 |  | Expenses not deductible for tax purposes | 55.026 | -11.99 | 148.127 | 96.172
 |  |  | 2172.92 | 2231.554 | 6033.135 | 6873.262
 |  | Aggregated weighted nominal tax rate | 0.3272 | 0.3244 | 0.3281 | 0.3256
 |  | Taxes – nominal rate | -710.979 | -723.916 | -1979.471 | -2237.934
 | Adjustment on tax expense
 |  | Incentives related to income taxes | 36.556 | -1.214 | 127.606 | 209.73
 |  | Tax benefit - interest on shareholders' equity | 95.474 | 111.06 | 299.576 | 361.957
 |  | Tax benefit - amortization on tax books | 31.476 | 30.188 | 95.71600000000001 | 90.565
 |  | Withholding tax and other income | -29.632 | -37.025 | -87.185 | -76.838
 |  | Non-deductible losses - foreign operations | -10.514 | -8.276 | -25.138 | -23.741
 |  | Income tax provision reversal | 80.424 | 0.73 | 64.76 | -47.133
 |  | Other tax adjustments | -8.681149999999997 | 7.656 | -9.848149999999997 | 142.391
 |  | Income tax and social contribution expense | -515.87615 | -620.797 | -1513.98415 | -1581.003
 |  | Effective tax rate | 0.2201261292706614 | 0.2670515014406569 | 0.2321904530690485 | 0.2184739327651548
Spreadsheet: 99ae44b0-8fbe-449c-8768-2eb6a7fa8e7d
Sheet: Hardware

 |  | Replacement Hardware Price Sheet
 | CI Number | Hardware Product | Number of Licenses | COTS or Proprietary | Purchase Cost |  |  |  |  |  |  |  |  | Annual Maintenance Fee*
 |  |  |  |  | Total Cost | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021 | Total Cost | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 | Total
Spreadsheet: 8b18ec97-aed6-49c4-a690-6afb29a6bc84
Sheet: S & U 

Sources and Uses
Pursuant to Sections 223(f), 223(a)(7), 223(d) and 232(i)
Project Name:
Project Number:
Program Type:
SOURCES | HUD Insured Loan | 0
 | Existing Replacement Reserves to Transfer | 0
 | Cash/Letter of Credit | 0
 | Interest Rate Premium | 0
 | Other (Describe) | 0
 | Other (Describe) | 0
 | TOTAL
USES
 | HUD ELIGIBLE COSTS
 | Existing Indebtedness or Purchase Price | 0
 | Prepayment Penalty | 0
 | Initial Deposit to the Reserve for Replacement | 0
 | Existing Replacement Reserves to Transfer | 0
 | Estimate of Repair Cost (Critical & Non Critical) | 0
 | Appraisal (incl. update) | 0
 | Phase I ESA / HUD 4128 | 0
 | PCNA | 0
 | Financing/Placement Fee | 0 | 0
 | Lender Legal | 0
 | Borrower Legal | 0
 | Title & Recording | 0
 | HUD Inspection Fee | 0
 | First Year MIP | 0 | 0
 | HUD Exam Fee | 0 | 0
 | Survey | 0
 | Additional Other Fees (Describe) | 0
 | Other (Describe) | 0
 | Other (Describe) | 0
 | TOTAL HUD ELIGIBLE COSTS
 | NON-ELIGIBLE COSTS
 | Initial Operating Deficit Escrow | 0
 | Special Escrow - Debt Service Reserve | 0
 | Repair Completion Assurance Escrow | 0
 | Other (Describe) | 0
 | Other (Describe) | 0
 | TOTAL ADDITIONAL COSTS
 | TOTAL COSTS
Spreadsheet: 816627d1675755731-sum-by-year-book2
Sheet: G Journal

Inv | Date | Decription | Debit | Credit | Debit |  | 2023
 | 2022-10-31 00:00:00 | 45/1938 | Saleem | Rental Income | 1450
 | 2022-10-31 00:00:00 | 45/1941 | Saleem | Rental Income | 1180
 | 2022-10-31 00:00:00 | 45/1937 | Falcon Tailors | Rental Income | 2020
 | 2022-10-31 00:00:00 | 45/1934 | PK Stores | Rental Income | 4600
 | 2022-10-31 00:00:00 | 45/1938 | Cable TV | Rental Income | 1130
 | 2022-10-31 00:00:00 | 45/1944 | Shafeeq | Rental Income | 2500
 | 2022-10-31 00:00:00 | bal bf | Cash In Bank |  | 11516
 | 2022-10-31 00:00:00 | bank rent | Co-Operative Bank | Rental Income | 24662
 | 2022-11-01 00:00:00 | rent rec oct | Cash In Hand | Saleem | 1450
 | 2022-11-01 00:00:00 | rent rec oct | Cash In Hand | Falcon Tailors | 2020
 | 2023-11-01 00:00:00 | naseem | Shareholder | Cash In Bank | 15000
 | 2023-11-01 00:00:00 | zainu | Shareholder | Cash In Bank | 15000
 | 2023-12-01 00:00:00 | salma | Shareholder | Cash In Bank | 15000
 | 2024-04-01 00:00:00 | land tax | [NAME] | Cash In Hand | 140
 | 2023-11-01 00:00:00 | bank chrg | [NAME] | Cash In Hand | 12
 | 2023-11-01 00:00:00 | [NAME] exp maint | Maintenanace | Cash In Hand | 100
 | 2023-12-01 00:00:00 | cash dep | Cash In hand | cash in bank | 16338
 | 2024-04-01 00:00:00 | 45/1938 | Saleem | Rental Income | 1450
 | 2023-11-01 00:00:00 | 45/1941 | Saleem | Rental Income | 1180
 | 2023-11-01 00:00:00 | 45/1937 | Falcon Tailors | Rental Income | 2020
Spreadsheet: 103602d1301345967-automated-shipping-estimator-daily_rates-1-
Sheet: UPS CWT Tier 6

 |  |  |  |  |  |  |  |  | 2011 Rates
 | Domestic
 | UPS Hundredweight Service Tier 6
 | Guaranteed Delivery Service Options
 | UPS Next Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 124 | 125 | 126
 | 100 Lbs. or more | 1.51 | 2.24 | 3.52 | 3.95 | 4.34 | 4.51 | 4.72 | 4.9 | 4.6 | 4.98
 | UPS Next Day Air Saver |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 132 | 133 | 134 | 135 | 136 | 137 | 138 | Service Not Available
 | 100 Lbs. or more | 1.24 | 1.99 | 3.36 | 3.75 | 3.92 | 4.12 | 4.34
 | UPS 2nd Day Air A.M. |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 242 | 243 | 244 | 245 | 246 | 247 | 248 | Service Not Available
 | 100 Lbs. or more | 1.03 | 1.16 | 1.48 | 2.18 | 3.26 | 3.7 | 3.82
 | UPS 2nd Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 224 | 225 | 226
 | 100 Lbs. or more | 0.86 | 0.98 | 1.27 | 1.84 | 2.97 | 3.28 | 3.41 | 3.48 | 3.17 | 3.88
 | UPS 3 Day Select |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | 200 to 499 Lbs. | 40.85 | 48.7 | 57.05 | 67.6 | 118.75 | 155.5 | 173.45
 | 500 to 999 Lbs. | 39.8 | 47.35 | 55.45 | 67.15 | 115.55 | 151.15 | 168.6
 | 1,000 Lbs. or more | 41.65 | 49.25 | 57.7 | 70.05 | 120.4 | 157.35 | 175.5
 | [NAME] |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 200 to 499 Lbs. | 29.35 | 37.1 | 41.4 | 49.05 | 61.95 | 71.55 | 83.1 | 225.35 | 225.35 | 263.25
 | 500 to 999 Lbs. | 27.45 | 34.75 | 38.75 | 45.75 | 57.8 | 66.95 | 77.45 | 208.9 | 208.9 | 243.3
 | 1,000 Lbs. or more | 28.15 | 35.4 | 39.6 | 46.7 | 59.2 | 68.3 | 79.25 | 213 | 213 | 248.55
 | Minimum Charges
 | UPS 3 Day Select Zones |  |  | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | Minimum Charge |  |  | 49.5 | 49.5 | 49.5 | 49.5 | 49.5 | 49.5 | 49.5
 | [NAME] |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | Minimum Charge |  |  | 44.75 | 44.75 | 47.5 | 47.5 | 47.5 | 47.5 | 47.5 | 300 | 300 | 325
Spreadsheet: tracy_geaccone__40311__EREC IC 0907
Sheet: Co 359 Invoice

 |  | INVOICE
 | Enron Capital and Trade Resources, Inc.
 | 1400 Smith Street
 | Houston, Texas 77002
 | Intercompany billing for prior month data
To: Enron Expat Services - Co. 359 |  | 3/2000
Description |  | Amount
1)  Analyst and Associate Administration
Indirect Costs
Total Analyst and Associate Administration
2)  Human Resources
Indirect Cost
Total Human Resources
3)  Legal
Indirect Cost
Total Legal Allocations
4)  Information Technology
Indirect Cost
Total Information Technology
 | Subtotal
 | Sales Tax
 | Shipping & Handling
 | TOTAL DUE
Spreadsheet: 845469d1696968161-how-to-count-number-of-rows-in-a-table-and-give-a-conditional-result-in-other-cell-test
Sheet: Form

 | GTIN | 87654567898765
 | 1.   [NAME] with Rework | AAAA
 | Note - Fully decommissioned with the potential  to rework and reuse [NAME] again.
 | 2.    Full Batch Decommissioning without Rework
 | Note - Fully decommissioned without the possibility of rework (Batch ID is made in-active and cannot be used again)
 | 3.    Partial Batch Decommissioning
 | Note - Only complete 1 of the 6 options for the higher level of hierarchy that is required (child objects will be decommissioned when parent is decommissioned). For PODA that will always be Item Level due to there being no aggregation to higher levels. Also ensure that the same quantity of serial numbers or SSCC numbers are listed at the end of this form.
 |  |  |  | Quantity
 |  |  |  | 20
 |  | [NAME] for Decommissioning
 |  | DESTROYED
 |  | ID | Name
 |  |  | XYZ
 | numbers to be decommissioned | Quantity
 | 201409570
 | 201409723 | DECLARATION
 | 201409943
 | 201409721
 | 201409427
 | 201409427
 | 201409427
 | 201409427
 | 201409427
 | 201409427
 | 201409427
 | 201409427
 | 201409427
 | 201409894
 | 201410100
 | 201410310
 | 201410118
 | 201410045
 | 201410518
 | 201410432
Spreadsheet: 116153d1311629196-pulling-specific-data-pulling-specific-data
Sheet: Sheet1

Filed 1 | Filed 2 | Filed 3 | X Enties |  | Total X Count
10 | 100 |  | 11 |  | 7
11 | 101 | X | 13
12 | 102 |  | 17
13 | 103 | X | 18
14 | 104 |  | 22
15 | 105 |  | 26
16 | 106 |  | 29
17 | 107 | X
18 | 108 | X
19 | 109
20 | 110
21 | 111
22 | 112 | X
23 | 113
24 | 114
25 | 115
26 | 116 | X
27 | 117
28 | 118
29 | 119 | X
30 | 120
Spreadsheet: 390c134f-7b29-4238-a2d2-647625346ef9
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 5/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
June | 7.41 | 6.7 | 7.13 | 6.54 | 9.18 | 8.31 | 9.26 | 7.78
July | 7.1 | 7.93 | 6.77 | 7.79 | 10.2 | 8.6 | 8.45 | 8.53
August | 7.59 | 8.04 | 7.27 | 7.92 | 10.2 | 7.7 | 8.28 | 8.27
September | 7.54 | 8.27 | 7 | 8.25 | 10.8 | 7.74 | 8.09 | 8.38
October | 7.27 | 8.38 | 6.53 | 8.33 | 9.6 | 7.61 | 8.19 | 8.56
November | 7.3 | 8.46 | 6.44 | 8.38 | 10.3 | 8.16 | 8.43 | 8.65
December | 7.2 | 8.29 | 6.41 | 8.15 | 10.3 | 8.31 | 8.25 | 8.46
January | 7.05 | 8.12 | 6.57 | 8.01 | 8.84 | 8.24 | 8.09 | 8.33
February | 7.1 | 7.97 | 6.68 | 7.87 | 8.98 | 8.19 | 8.01 | 8.1
March | 7.2 | 7.78 | 6.7 | 7.62 | 8.39 | 8.12 | 8.04 | 7.95
April | 7.11 | 7.52 | 6.47 | 7.31 | 9.22 | 7.76 | 7.96 | 7.8
May | 6.67 |  | 6.42 |  | 8.95 |  | 7.93
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 5/14/2013
Spreadsheet: 709291d1608233961-help-needed-with-solver-output-investment-portfolio-rebalancing-calculator
Sheet: Rebalancing Calculator

 |  |  |  |  |  |  |  |  |  |  | Contribution Amount |  | 2500
 | INPUT CELLS |  |  |  |  |  |  |  |  |  | Current Total Value
 |  |  |  |  |  |  |  |  |  |  | New Total Value (after new purchases)
 | BEFORE |  |  |  |  |  |  |  |  |  | HOW MUCH TO BUY |  |  |  |  |  |  | AFTER
 | ETF Name | Ticker | # Units Held | Current  Price of One Unit | Dollar Value | % of Portfolio | Desired % Allocation of Portfolio | Allocation Upper Limit | Allocation Lower Limit |  | Ticker | Amount to Purchase ($) (Solver Output Cells) | # of Units to Purchase | # of Units to [NAME] (Rounded Down) | New Additional $ Purchased | New Total $ Value |  | New % of Portfolio | Desired % of Portfolio | % Away from Ideal Allocation
 | Fund A | A | 82 | 83.92 |  |  | 0.25 | 0.275 | 0.225 |  |  | 200
 | Fund B | B | 75 | 39.31 |  |  | 0.1 | 0.11 | 0.09 |  |  | 0
 | Fund C | C | 127 | 38.14 |  |  | 0.175 | 0.19 | 0.16 |  |  | 100
 | Fund D | D | 130 | 37.74 |  |  | 0.175 | 0.19 | 0.16 |  |  | 100
 | Fund E | E | 72 | 37.48 |  |  | 0.1 | 0.11 | 0.09 |  |  | 200
 | Fund F | F | 82 | 35.42 |  |  | 0.1 | 0.11 | 0.09 |  |  | 0
 | Fund G | G | 164 | 17.35 |  |  | 0.1 | 0.11 | 0.09 |  |  | 0
Spreadsheet: 139103d1328076079-nested-if-statement-with-index-and-match-within-vanguard-template
Sheet: Sheet2

 | Products
 | [NAME]
 | [NAME]
 | Brampton
 | Operation
 | Manual
 | Hard Wired
 | Remote
 | Control
 | Wall switch uno - hard wired | 15
 | Wall switch duo - hard wired | 20
 | Telis RTS 1 channel | 85
 | Telis RTS 5 channel | 135
 | Telis 16 - pure | 185
 | Telis 16 - silver | 205
 | [NAME] | 200
 | [NAME] | 215
 | Sensor
 | Wind sensor - hard wired (inc. switch) | 290
 | Wind sensor - RTS (inc. 1 channel remote) | 225
 | Wind sensor - RTS (inc. 5 channel remote) | 265
 | Sun and wind sensor - hard wired (inc. switch) | 310
 | Sun and wind sensor - RTS (inc. 1 channel remote) | 275
 | Sun and wind sensor - RTS (inc. 5 channel remote) | 315
 | Material
 | Category 3
 | Category 4
 | Category 5
 | Category 8
 | Category 9
 | Category 11
 | Beam
a | 50 x 50 | 47
b | 100 x 50 | 47
c | 150 x 50 | 95
d | 200 x 50 | 105
e | 250 x 50 | 125
Spreadsheet: 877066d1723735288-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024-bvj-
Sheet: Sheet1

ASSEMBLY MARK NUMBER | SL.NO | BUILDING REF. | PRIORITY | LEVEL | ASSEMBLY NAME | QTY | GROSS WEIGHT | DELIVERY | ERECTION | REMARKS | Delivery Weight | Erection Weight |  |  |  |  |  | Count of Delivery  Weight | Count of Install Weight
QLGF-C2001 | 1 | A | PRIORITY-1A | GF | COLUMN | 1 | 200.1 |  |  |  |  |  |  |  | Row Labels | Sum of QTY | Sum of GROSS WEIGHT | Count of Delivery Weight | Count of Erection Weight | Sum of Install Weight
QLGF-C2002 | 2 | A | PRIORITY-1A | GF | COLUMN | 2 | 512.6 |  |  | Part assembly 1/2 |  |  |  |  | A
QLGF-C2002 | 3 | A | PRIORITY-1B | GF | COLUMN |  |  |  |  | Part assembly 2/2 |  |  |  |  | PRIORITY-1A
QLGF-C2003 | 4 | A | PRIORITY-1B | GF | COLUMN | 1 | 205.6 |  |  |  |  |  |  |  | GF
QLGF-BM2003 | 5 | A | PRIORITY-1B | GF | FLOOR_BEAM | 1 | 181 |  |  |  |  |  |  |  | COLUMN | 3 | 712.7 | 2 | 2
QLGF-BM2004 | 6 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  |  |  | Part assembly 1/3 |  |  |  |  | PRIORITY-1B
QLGF-BM2004 | 7 | A | PRIORITY-2A | GF | FLOOR_BEAM |  |  |  |  | Part assembly 2/3 |  |  |  |  | GF
QLGF-BM2004 | 8 | A | PRIORITY-2A | GF | FLOOR_BEAM | 1 | 205.7 |  |  | Part assembly 3/3 |  |  |  |  | COLUMN | 3 | 205.6 | 2 | 2
QLGF-HB2005 | 9 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 203.6 |  |  |  |  |  |  |  | FLOOR_BEAM | 1 | 181 | 1 | 1
QLGF-HB2009 | 10 | A | PRIORITY-2A | GF | HORIZONTAL BRACING | 1 | 200.1 |  |  |  |  |  |  |  | PRIORITY-2A
QL-1-VB2001 | 11 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 906.1 |  |  |  |  |  |  |  | GF
QL-1-VB2002 | 12 | A | PRIORITY-2B | LEVEL-1 | VERTICAL BRACING | 1 | 1137.6 |  |  |  |  |  |  |  | FLOOR_BEAM | 3 | 205.7 | 3 | 3
QL-1-BM2002 | 13 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 |  |  |  | Part assembly 2/2 |  |  |  |  | HORIZONTAL BRACING | 2 | 403.7 | 2 | 2
QL-1-BM2002 | 14 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 673.6 |  |  | Part assembly 1/2 |  |  |  |  | PRIORITY-2B
QL-1-BM2003 | 15 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 525 |  |  |  |  |  |  |  | LEVEL-1
QL-1-BM2004 | 16 | A | PRIORITY-2C | LEVEL-1 | FLOOR_BEAM | 1 | 483.6 |  |  |  |  |  |  |  | VERTICAL BRACING | 2 | 2043.7 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIORITY-2C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVEL-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLOOR_BEAM | 4 | 1682.2 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 18 | 5434.6 | 16 | 16
Spreadsheet: 539544d1506230051-transfer-bespoke-data-to-different-workbooks-test-sheet-2
Sheet: Sellers

 |  |  | AB policy total
 |  |  | CD policy
 |  |  | EF policy total
 | Adviser Name | Date sold | AB £ | AB pol no | CD Price | CD policy no | Ef Price | Ef policy no. | I/P
Spreadsheet: 221441d1363552741-looking-up-two-fields-and-giving-me-the-date-date-name-number
Sheet: Sheet1

 |  | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00
 | gary |  |  | 2
 | [NAME] |  | 2
 | [NAME]
 | [NAME] | 2 |  | 2
 | Name | number |  | Date
 | gary | 2
 | [NAME] | 2
 | [NAME] | 2
Spreadsheet: 542696d1508014544-matching-dates-and-summing-test-g-ac
Sheet: C

Week | UPV
1 | 721 |  | This is sum of week 1, which is date range Jan 2 - Jan 8
2 | 770 |  | This is sum of week 2, which is date range Jan 9 - 15
3 | 819
4 | 868
5 | 1267 |  | This is sum of week 5, which is date range Jan 30 - Feb 5
6 | 1456
7 | 1505
8 | 1554
9 | 1963
10 | 2156
Spreadsheet: 251ea2d1-c912-4717-989d-2f022ddca398
Sheet: CTE Contact Minutes (HS only)

 |  |  |  |  |  | Minutes
TECHNICAL EDUCATION CONTACT MINUTES |  |  |  |  | Period | In Class
 |  |  |  |  | 0
Important: Calculations for contact minutes are based on the school's official bell |  |  |  | 1
schedule entered on the Building Schedule tab. |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
NAME OF SCHOOL |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
Seminar Time Calculator (calculates automatically) |  |  |  | 9
Daily Average Number of Minutes |  |  |  | 10
Periods in full time student schedule |  |  |  | 11
Computed Seminar Time |  |  |  | 12
 |  |  |  |  | Sem
 |  |  |  | Audited
Course Name | Teacher | 16 Digit Course Code | Period | Enrollment | Time | Total
 | .
 |  |  |  | Total minutes
Seminar (if applicable) |  |  | Sem
Total CTE minutes
Spreadsheet: 124474d1318431985-identifying-duplicates-and-their-frequency-sample
Sheet: Sheet1

State | Value | Times Values Appears |  | Intermediate |  |  |  | Poor Results
AL | a-1 | 2
AL | a-2 | 2 |  | Count of Times Values Appears |  |  |  | Count of Times Values Appears
AL | a-5 | 2 |  | State | Value | Total |  | State | Times Values Appears | Total
AL | a-2 | 2 |  | AL | a-1 | 2 |  | AL | 1 | 1
AL | a-1 | 2 |  |  | a-2 | 2 |  |  | 2 | 6
AL | [NAME] | 3 |  |  | a-3 | 1 |  |  | 3 | 3
AL | a-3 | 1 |  |  | [NAME] | 3 |  | AL Total |  | 10
AL | [NAME] | 3 |  |  | a-5 | 2 |  | MN | 1 | 2
AL | [NAME] | 3 |  | AL Total |  | 10 |  |  | 2 | 2
AL | a-5 | 2 |  | MN | a-0 | 1 |  |  | 3 | 6
MN | [NAME] | 2 |  |  | a-6 | 3 |  | MN Total |  | 10
MN | a-7 | 3 |  |  | a-7 | 3 |  | SD | 1 | 1
MN | [NAME] | 2 |  |  | a-8 | 1 |  |  | 2 | 2
MN | a-8 | 1 |  |  | [NAME] | 2 |  |  | 3 | 3
MN | a-6 | 3 |  | MN Total |  | 10 |  |  | 4 | 4
MN | a-6 | 3 |  | SD | a-10 | 1 |  | SD Total |  | 10
MN | a-6 | 3 |  |  | a-11 | 3 |  | Grand Total |  | 30
MN | a-7 | 3 |  |  | a-12 | 2
MN | a-7 | 3 |  |  | a-15 | 4
MN | a-0 | 1 |  | SD Total |  | 10
SD | a-10 | 1 |  | Grand Total |  | 30
SD | a-12 | 2
SD | a-15 | 4 |  | Expected Results
SD | a-15 | 4 |  | State | Times Values Appears | Total
SD | a-11 | 3 |  | AL | 1 | 1
SD | a-12 | 2 |  |  | 2 | 3
SD | a-11 | 3 |  |  | 3 | 1
SD | a-15 | 4 |  | MN | 1 | 2
SD | a-15 | 4 |  |  | 2 | 1
SD | a-11 | 3 |  |  | 3 | 2
 |  |  |  | SD | 1 | 1
 |  |  |  |  | 2 | 1
 |  |  |  |  | 3 | 1
 |  |  |  |  | 4 | 1