tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708892d1608060006-look-up-the-nth-value-in-a-column-for-instance-the-2nd-number-tablelookup
Sheet: Sheet1

 |  |  |  |  |  |  |  | Table 1
 |  |  |  |  |  |  |  | 11
 |  |  | Find: | 2 |  |  |  | 16
 |  |  | Result: |  | <-- This should return 16 |  |  | 3
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 9
 |  |  | Find: | 3.75 |  |  |  | -2
 |  |  | Result: |  | <-- This should return 4 |  |  | 3
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 11
Spreadsheet: 141263d1329178207-need-a-date-filter-that-shows-only-the-earliest-and-latest-results-in-a-year-period-sort_date_problem_02132012
Sheet: Problem

Employee Name | Work Date
[NAME] | 2011-01-01 00:00:00
[NAME] | 2011-01-02 00:00:00
[NAME] | 2011-01-03 00:00:00
[NAME] | 2011-01-04 00:00:00
[NAME] | 2011-01-05 00:00:00
[NAME] | 2011-01-06 00:00:00
[NAME] | 2011-01-07 00:00:00
[NAME] | 2011-01-08 00:00:00
[NAME] | 2011-01-09 00:00:00
[NAME] | 2011-01-10 00:00:00
[NAME] | 2011-01-11 00:00:00
[NAME] | 2011-01-12 00:00:00
[NAME] | 2011-01-03 00:00:00
[NAME] | 2011-01-04 00:00:00
[NAME] | 2011-01-05 00:00:00
[NAME] | 2011-01-06 00:00:00
[NAME] | 2011-01-07 00:00:00
[NAME] | 2011-01-08 00:00:00
[NAME] | 2011-01-09 00:00:00
[NAME] | 2011-01-10 00:00:00
[NAME] | 2011-01-20 00:00:00
[NAME] | 2011-01-23 00:00:00
Emily | 2011-03-01 00:00:00
Emily | 2011-03-02 00:00:00
Emily | 2011-03-03 00:00:00
Emily | 2011-03-04 00:00:00
Emily | 2011-03-05 00:00:00
Emily | 2011-03-06 00:00:00
Emily | 2011-03-07 00:00:00
Emily | 2011-03-08 00:00:00
Emily | 2011-03-09 00:00:00
Emily | 2011-03-10 00:00:00
Emily | 2011-03-11 00:00:00
Spreadsheet: 830999d1685351891-match-and-sum-match-and-sum
Sheet: Sheet2

Case1
Magh | Ma-45 | [NAME] |  |  |  |  | 64
Magh | Ma-49 | [NAME] |  |  |  |  | 75
Magh | Ma-54 | [NAME] |  |  |  |  | 88
Case2
Magh | Ma-45 | [NAME] |  |  |  |  |  |  | 64 |  |  |  | 500
Magh | Ma-49 | [NAME] |  |  |  |  |  |  | 75 |  |  |  | 300
Magh | Ma-54 | [NAME] |  |  |  |  |  |  | 88 |  |  |  | 450
Spreadsheet: 704202d1605439474-formula-retrieving-data-from-other-worksheet-when-changing-month-_01-_02-_03-in-a-cell-exampleforformula
Sheet: Data_CB

CB
Item | UOM | QTY/T_01 | TOT.QTY_01 | [NAME] | TOT.AMT_01 | COST/T_01 | QTY/T_02 | TOT.QTY_02 | RATE_02 | TOT.AMT_02 | COST/T_02 | QTY/T_03 | TOT.QTY_03 | RATE_03 | TOT.AMT_03 | COST/T_03 | QTY/T_04 | TOT.QTY_04 | RATE_04 | TOT.AMT_04 | COST/T_04 | QTY/T_05 | TOT.QTY_05 | RATE_05 | TOT.AMT_05 | COST/T_05 | QTY/T_06 | TOT.QTY_06 | RATE_06 | TOT.AMT_06 | COST/T_06 | QTY/T_07 | TOT.QTY_07 | RATE_07 | TOT.AMT_07 | COST/T_07 | QTY/T_08 | TOT.QTY_08 | [NAME] | TOT.AMT_08 | COST/T_08 | QTY/T_09 | TOT.QTY_09 | RATE_09 | TOT.AMT_09 | COST/T_09 | QTY/T_10 | TOT.QTY_10 | RATE_10 | TOT.AMT_10 | COST/T_10 | QTY/T_11 | TOT.QTY_11 | RATE_11 | TOT.AMT_11 | COST/T_11 | QTY/T_12 | TOT.QTY_12 | RATE_12 | TOT.AMT_12 | COST/T_12 | QTY/T_YTD | TOT.QTY_YTD | RATE_YTD | TOT.AMT_YTD | COST/T_YTD
Electricity | KWH | 40 | 3500000 | 0.06 | 210000 | 2.4 | 42 | 3750000 | 0.062 | 232500 | 2.6
NG
CG
BFG
…
Spreadsheet: 49a96a59-be5b-4a3e-88d3-beb51c080a14
Sheet: Sheet1

Weekly Registration and Comparison Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME] -- Mid-date Day
Please consider the following information when examining the data below:
For Spring 2009, registration began 11/4/08 and classes started 1/20/09
For Spring 2010, registration began 11/3/09 and classes will start 1/19/10
 | College Credit Hours
 | Current |  | Compared to |  |  | Compared to
 | Term |  | Same Time Last Year |  |  | Spring 200901 10th Day
Spring | 2010-03-15 00:00:00 |  | 2009-03-16 00:00:00 | % of 2009 |  | 2009-02-03 00:00:00 | % of 2009
Quad Cities Campus | 43155.5 |  | 39213.5 | 1.100526604358193 |  | 39908 | 1.081374661721961
East Campus | 9270.5 |  | 9188.5 | 1.008924198726669 |  | 9375.5 | 0.9888005973014773
District | 52426 |  | 48402 | 1.083137060452047 |  | 49283.5 | 1.063763734312701
 | College Credit Headcount
 | Current |  | Compared to |  |  | Compared to
 | Term |  | Same Time Last Year |  |  | Spring 200901 10th Day
Spring | 2010-03-15 00:00:00 |  | 2009-03-16 00:00:00 | % of 2009 |  | 2009-02-03 00:00:00 | % of 2009
Quad Cities Campus | 4902 |  | 4406 | 1.112573763050386 |  | 4302 | 1.139470013947001
East Campus | 866 |  | 802 | 1.079800498753117 |  | 812 | 1.066502463054187
District | 5768 |  | 5208 | 1.10752688172043 |  | 5114 | 1.12788423934298
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Accounting

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Client Services/Benefits Delivery
Activity Name | Accounting
Activity Description / Purpose | The process of providing the appropriate services and benefits to clients/customers…arranging homecare, medical transportation, daycare and employment activities
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Send provider application for certification
Process application
[NAME] check
Certify Provider
Send Provider Notice of Certification
Distribute Certified Provider List
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 813425d1673741997-bring-multiple-cells-into-one-based-on-a-match-names-and-model-numbers-1-
Sheet: Sheet1

Name | Model Number | Sub type | Type | Generate here
Adam | 855 | 1
[NAME] | 855 | 3
Yolanda | 855 | 6 | Primary
[NAME] | 890 | 1
[NAME] | 891 | 4 | Primary
[NAME] | 891 | 55
Victoria | 891 | 70
Shane | 905 | 9
[NAME] | 907 | 10
Kimberly | 912 | 14
[NAME] | 934 | 2
[NAME] | 934 | 3
[NAME] | 934 | 7 | Primary
[NAME] | 934 | 8
Mario | 934 | 17
[NAME] | 987 | 21
[NAME] | 988 | 20
Zachary | 988 | 25 | Primary
Xavier | 989 | 29
Spreadsheet: 79d49aff-e87b-48c2-826a-2d0b0db43352
Sheet: Hoja1

Comisiones | 5000 | 4900 | 4000 | 3900 | 3000 | 2900 | 2000
 |  |  |  |  |  |  |  | Se tienen pagos por comisiones así:
 |  |  |  |  |  |  |  | 6000, 5000, 4500, 3900, 3000, 2900
 |  |  |  |  |  |  |  | En una tabla indicar.
Vendedor | [NAME] | Posición |  |  |  |  |  | Si es mayor o igual a 5000, primer lugar
Juan | 5000 |  |  |  |  |  |  | Entre 4000 y 4900, segundo lugar
[NAME] | 6500 |  |  |  |  |  |  | Entre 3000 y 3900, tercer lugar
Lina | 4200 |  |  |  |  |  |  | Entre 2000 y 2900 cuarto lugar
Ana | 3800
[NAME] | 2400
Andrés | 1500
Catalina | 1999
Jorge | 1700
Claudia | 2100
Spreadsheet: 814532d1674473152-copy-project-data-to-respective-tabs-ef1601_extract_to_sheets
Sheet: Sheet1

Project | Data field 1 | Data field 2 | Data field 3 | Data field 4 | Data field 5 |  | Helper
A | 1274 | 1225 | 3960 | 1450 | 2895
A | 7197 | 1130 | 3171 | 417 | 2772
A | 6040 | 9946 | 7271 | 2208 | 5109
A | 8153 | 2282 | 9714 | 4079 | 8061
A | 1241 | 7381 | 3811 | 5903 | 8985
B | 4889 | 5698 | 5301 | 4380 | 9062
B | 2970 | 8025 | 6926 | 771 | 8977
B | 9828 | 3140 | 9537 | 6618 | 9578
B | 2330 | 6398 | 5892 | 5444 | 8525
B | 324 | 7746 | 8531 | 9589 | 2768
C | 8105 | 7907 | 4673 | 595 | 2459
C | 5274 | 2412 | 5285 | 5238 | 580
C | 9146 | 7062 | 9859 | 2551 | 4902
D | 1155 | 9133 | 7672 | 9527 | 6859
D | 3440 | 5245 | 7139 | 4815 | 9601
D | 3531 | 525 | 825 | 5261 | 8723
E | 8521 | 8520 | 6964 | 3690 | 5594
E | 1992 | 1255 | 1573 | 7380 | 2022
E | 4315 | 7161 | 6850 | 4084 | 350
E | 3373 | 4802 | 7093 | 3859 | 336
E | 6721 | 6712 | 8320 | 9323 | 7304
Spreadsheet: chris_germany__2124__DecCohCHOICE-ENA
Sheet: Dec 31

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-31 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1170 |  | 1170 |  | 67694 |  |  |  |  |  | 15 | 1 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 2 | 18
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 12456 |  | 12456 |  | 67694 |  |  |  |  |  | 15 | 3 | 15 |  |  | 15
 |  |  |  |  |  |  |  |  | 587 |  | 587 |  | 68918 | 0 |  |  |  |  | 18 | 4 | 18 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 5 | 18 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 4964 |  | 4964 |  | 67694 |  |  |  |  |  | 16 | 6 | 16 |  |  | 22
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 | 0 |  |  |  |  | 17 | 7 | 17 |  |  | 15
 |  |  |  |  |  |  |  |  | 1272 |  | 1272 |  | 68915 | 0 |  |  |  |  | 18 | 8 | 18 |  |  | 14
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 | 0 |  |  |  |  | 17 | 9 | 17 |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 15 | 20 |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 22275 |  | 22275 |  | 67694 |  |  |  |  |  | 17 | 35 | 17 |  |  | 17
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 | 0 |  |  |  |  | 18 | 39 | 18 |  |  | 17
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68915 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68918 | 0 |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2698 |  | 2698 |  | 67694 | 1 |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 2983 |  | 2983 |  | 67694 |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 0.7
 |  |  |  |  |  |  |  |  | 98 |  | 98 |  | 68916 | 0
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 19765 |  | 19765 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3185 |  | 3185 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3947 |  | 3947 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4957 |  | 4957 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1680 |  | 1680 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 54 |  | 54 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 10c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, December 21 weekly snapshot, by product type and major currency (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 87975d1287855721-formula-issue-multiple-rows-referencing-one-row-copying-book-row
Sheet: form

Contract: 02078-SWP-01-CN-PM
Highway:
County:
ITEM |  |  |  |  |  |  |  |  | AMOUNT
ITEM NO. | ITEM CODE | S.P. NO. |  | UNIT BID PRICE ONLY - WRITTEN IN WORDS |  | UNIT | [NAME]. [NAME] |  |  | DEPT USE ONLY
0100 | 2002 | 002 |  | PREPARING ROW |  | STA | 162.3 |  |  | 1
 |  |  |  | 2 | Dollars |  |  | $ | 324.6
 |  |  | and | 0 | Cents
0104 | 2001 |  |  | REMOVING CONC (PAV) |  | SY | 14888 | $ | 133992 | 2
 |  |  |  | 9 | Dollars
 |  |  | and | 0 | Cents
0 | 0 | 0 |  | 0 |  | 0 | 0 |  |  | 0
 |  |  |  | 2 | Dollars |  |  | $ | 0
 |  |  | and | 0 | Cents
0 | 0 | 0 |  | 0 |  | 0 | 0 | $ | 0 | 0
 |  |  |  | 0 | Dollars
 |  |  | and | 0 | Cents
Spreadsheet: 0b0128a6-913a-4909-ab74-049b37c20b74
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688900625 | Meredith Andrews | Open Up The Heavens | 2014-10-14 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | NYP
Word Records | 80688901523 | Meredith Andrews | [NAME] | 2014-11-11 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | NYP
Word Records | 80688874223 | Meredith Andrews | Strong God | 2013-06-09 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688873721 | Meredith Andrews | Pieces | 2013-04-23 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688873622 | Meredith Andrews | Not For A Moment (After All) | 2013-05-07 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688806323 | Meredith Andrews | In Your Arms | 2010-04-06 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688754228 | Meredith Andrews | [NAME] | 2008-04-29 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688806224 | Meredith Andrews | Only To Be Yours | 2010-04-20 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688806125 | Meredith Andrews | Come Home | 2010-04-20 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688806026 | Meredith Andrews | How Great Is The Love | 2010-04-06 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688776626 | Meredith Andrews | New Song We Sing, The | 2008-09-09 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688754327 | Meredith Andrews | You Invite Me In | 2008-09-09 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Spreadsheet: 152974d1335653092-excel-2007-nested-sumifs-or-excel-test-2_ron_v1a
Sheet: Test

 | 99999 | 75757 | 12321 | 12323 | 12345 | 99908
Total S |  |  |  |  |  |  |  | [NAME] needed to search row 1 "Data" for ID Number then to return Totals from "Data" by matching  column A  "Data" based on certain characteristic listed below.
Total B
Total A |  |  |  |  |  |  |  | Total S | [NAME]
Total C |  |  |  |  |  |  |  | Total B | A102
Total D |  |  |  |  |  |  |  | Total A | A103
Total E |  |  |  |  |  |  |  | Total C | A104
 |  |  |  |  |  |  |  | Total D | A105
 | 99999 | 75757 | 12321 | 12323 | 12345 | 99908 |  | Total E | A106
Total S
Total B
Total A | 50 | 75 | -500 | 25 | 100
Total C | 45 | 10 | 753 | 99.99 | 100
Total D | 90 | 70 | 950 | 780 | 200
Total E | 1 | 1 | 1 | 1 | 1
Spreadsheet: chris_stokley__3870__0201 EES
Sheet: PGES

PGES ISO Settlement 02/01/2001 - 02/28/2001
 |  | EPMI Charges To Customers
Trans Type | (All)
 |  |  | Data
Customer | ID | Desc. | Expense | Revenue | Total | Volume
PGES | 111 | Spinning Reserve due ISO | -173175.0981496202 | 890256.7031590602 | 717081.6050094402 | -8940.513814038439
 | 112 | Non -Spinning Reserve due [NAME] | -20614.8657 | 385444.0704693818 | 364829.2047693817 | -10556.47333223605
 | 114 | Replacement Reserves Due ISO | -563893.6298349597 | 971121.1151292732 | 407227.4852943131 | -3264.04055997042
 | 115 | Regulation UP due ISO | -49114.92147140389 | 526202.1594597728 | 477087.2379883688 | -4552.570101481078
 | 116 | Regulation Down Due ISO | -28065.21580000001 | 249368.0029898642 | 221302.787189864 | -4013.13546554658
 | 403 | Load Deviation | -3766188.36505 | 6947147.920566668 | 3180959.555516666 | -21340.52260132801
 | 406 | UFE | -153305.8498846228 | 295398.1166097728 | 142092.2667251501 | -989.200766195186
 | 487 | Allocation Excess Cost for IE | -1354136.51 | 10474286.48 | 9120149.969999999 | -44909.94
 | 521 | Control Area Services Charge | 0 | 62448.68141999996 | 62448.68141999996 | -153814.4863000001
 | 522 | Inter-Zonal Scheduling Charge | 0 | 29424.07619000001 | 29424.07619000001 | -131946.53
 | 523 | Market Operations Charge | -44125.69340000001 | 102945.3814964328 | 58819.68809643279 | -61850.36667607902
 | 1010 | Neutrality Adj | -443029.3130187664 | 601981.6583220833 | 158952.3453033165 | -297368.8284999999
 | 1011 | AS Rational Buyer Adj. | -521537.6865000001 | 123801.2914 | -397736.3950999998 | -2124456.353900002
 | 1030 | No Pay Market Refund | -117250.7369 | 2156.845400000001 | -115093.8915000001 | -370875.297108624
 | 1062 | Distribution of Preempted Non | -29.9627 | 0 | -29.9627 | -732.2484000000001
 | 1064 | Distrib of Preempted RR | -187.4585 | 0 | -187.4585 | -2886.1378
 | 1210 | Existing Contract Neu Adj | -154690.8375 | 182386.5204 | 27695.6829 | -2198735.904400001
 | 1302 | Supplemental Reactive Energy | -0.026 | 275.6715 | 275.6455 | -73724.845
Grand Total |  |  | -7389346.170409373 | 21844644.69451231 | 14455298.52410293 | -5514957.394725502
Spreadsheet: 217576d1362111140-searching-inside-cell-text-sherif
Sheet: Sheet1

EMP.NO | NOTE
400 | [NAME] HAS 4560 SHARES | 4560
420 | I GAVE 230 BOX TO JACK AND 2000 SHEETS TO MAGY | 230
5922 | 400.20 l.e paid to 5922 | 7890
4560 | 400 l.e paid  to 5933
7890
1007
 | in the grren cells the formula pick number 400 from the cell because it is in the column a
 | which is not correct because it is apart of decimal number ,so is there any way to neglect the number that contain decimal ?
Spreadsheet: 177966d1346572301-extracting-only-unique-invoice-numbers-verkooptest
Sheet: Print

 | Factuurnr.: | 20102661 | I will like to have only unique numbers |  |  |  |  |  |  |  |  | Row Labels
 |  |  | -Just refresh the pivot before you select unique number from the drop down :) |  |  |  |  |  |  |  |  | 20102661
 |  |  |  |  |  |  |  |  |  |  |  | 20102662
 |  |  |  |  |  |  |  |  |  |  |  | 20102663
 |  |  |  |  |  |  |  |  |  |  |  | 20102664
Artikelnummer | Omschrijving | Aantal | PrijsPS | BTW | Factuurbedrag |  |  |  |  |  |  | 20102665
 |  |  |  |  |  |  |  |  |  |  |  | 20102666
 |  |  |  |  |  |  |  |  |  |  |  | 20102667
 |  |  |  |  |  |  |  |  |  |  |  | 20102668
 |  |  |  |  |  |  |  |  |  |  |  | 20102669
 |  |  |  |  |  |  |  |  |  |  |  | 20102670
 |  |  |  |  |  |  |  |  |  |  |  | 20102671
 |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Omzet 0% | total sold on [0%] |  |  | Subtotaal
Omzet 6% | total sold on [6%] |  |  | BTW
Omzet 19% | total sold on [19%] |  |  | Totaal
 | I will like to have total amount sold for 0%,6% and 19%
Spreadsheet: brad_mckay__1418__BradMcKayVAC
Sheet: Off_Duty_report_20011212_133058

Name | Pernr | Leave as of | Vacation Taken | Family
McKay, Bradley T | 502887 | 2001-12-11 00:00:00 | 0 | 0
 | [NAME] Holiday | Vac Carry Over | [NAME] | Vac Balance
 | 0 | 40 | 160 | 116
 | Plus Discr Holiday (8 hours) |  |  | Total | 124
 | You have 15 1/2 days of vacation.
Spreadsheet: 10100372-619b-4bc7-8379-41f4b52ca6b3
Sheet: FORMA 2 

 | ფორმა N2
ფინანსური შედეგების შესახებ ანგარიში
დასახელება |  | __________31 დეკემბერი (საანგარიშო წელი) | __________31 დეკემბერი (საანგარიშო წლის წინა წელი)
010 | [NAME]
020 | შემოსავლები
030 | გადასახადები
040 | სოციალური შენატანები
050 | გრანტები
060 | სხვა შემოსავლები
070 | ა. ქონებასთან დაკავშირებული შემოსავლები
080 | [NAME] და მომსახურების რეალიზაცია
090 | გ. სანქციები, ჯარიმები, საურავები
100 | [NAME] ტრანსფერები, გარდა გრანტებისა
110 | [NAME] არაკლასიფიცირებული შემოსავლები
120 | [NAME] შემოსულობა
130 | ხარჯები
140 | [NAME]
150 | საქონელი და მომსახურება
160 | ძირითადი კაპიტალის მოხმარება
170 | პროცენტი
180 | სუბსიდიები
190 | გრანტები
200 | სოციალური უზრუნველყოფა
210 | სხვა ხარჯები
220 | [NAME] გადასახდელი
230 | [NAME]
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 49839 | 42521
2 | 58661 | 61095
3 | 57956 | 59505
4 | 62170 | 61574
5 | 63269 | 58996
6 | 62745 | 62359
7 | 66886 | 73126
8 | 66326 | 65213
9 | 63811 | 63118
10 | 60111 | 59591
11 | 64319 | 64464
12 | 64945 | 63665
13 | 64939 | 64464
14 | 63062 | 63411
15 | 56053 | 59448
16 | 62374 | 63447
17 | 61677 | 61277
18 | 60811 | 60711
19 | 60896 | 60711
20 | 60946 | 60636
21 | 61474 | 63821
22 | 48657 | 48609
23 | 59613 | 60860
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 0
2001-08-23 00:00:00
CBS Volume
 |  |  | 53363
Spreadsheet: 803757d1667666266-need-an-alternative-to-vlookup-that-returns-all-values-found-spa-lista-de-estabelecimentos-dsavrlvt-29_07_2022
Sheet: Secção IV

[NAME]. 1069/2009 [NAME]
NCV (Approval Number) | Nome (Name) | Concelho (Municipality) | Categoria (Category) | Atividade (Activity) | Espécies / Produtos (Species / Products) | [NAME] (Associated Activities)
 | CASO – Centro de Abate de Suínos do [NAME], [NAME] | Mafra | 3 | Unidade de processamento [NAME] Animal(PROCP) | FATF, PAP | SPONA(AAUPA)
 | CARMONTI – Indústria de Carnes do Montijo, SA | Montijo | 3 | Unidade de processamento [NAME] Animal(PROCP) | FATF, PAP | SPONA(AAUPA)
 | Narciso Dias & Filhos, Lda. | Peniche | 3 | Unidade de processamento [NAME] Animal(PROCP) | FATF, PAP | SPONA(AAUPA), [NAME])
 | COMAVE DO [NAME] e [NAME], [NAME] | Ferreira do Zêzere | 2 | Unidade de processamento [NAME] Animal(PROCP) | MBM | I(STORP)
 | INTERAVES-S. A. | Alenquer | 2 | Unidade de processamento [NAME] Animal(PROCP) | MBM
 | SEBOL - Comércio e Indústria de Sebo, S.A. | Loures | 3 | Unidade de processamento [NAME] Animal(PROCP) | RAW | I(STORP), II(STORP*), [NAME]), [NAME])
 | Biovegetal - Combustíveis Biológicos e Vegetais, S.A. | Vila [NAME] | 3 | Unidade de processamento de produção de biodiesel(OBIODP) | BIOD | I(STORP), SPOA(AAUPV), [NAME])
 | ITS - Industria [NAME], S.A. | Coruche | 1 | Unidade de processamento [NAME] Animal(PROCP) | RAW | I(STORP), III(COMB), II(STORP*)
 | SEBOL - Comércio e Indústria de Sebo, S.A. | Coruche | 2 | Unidade de processamento [NAME] Animal(PROCP) |  |  |  |  |  | Não existe na coluna D da folha "SPA"
 | PENTACOELHO - Abate e Comercialização de Coelhos, S.A. | Bombarral | 3 | Unidade de processamento [NAME] Animal(PROCP) | A, L | SPONA(AAUPA), [NAME])
 | AVIBOM AVÍCOLA, S.A. | Torres Vedras | 3 | Unidade de processamento de produção de biodiesel(OBIODP)/Unidade de processamento [NAME] Animal(PROCP) | A/ A | SPONA(AAUPA)
 | MARINHAVE - Sociedade Agro-Avícola, S.A. | Benavente | 2 | Unidade de processamento [NAME] Animal(PROCP) | RAW | I(STORP), [NAME])
 | Sovena Oilseeds Portugal, S.A. | Almada | 3 | Unidade de processamento de produção de biodiesel(OBIODP) | UCO | AGRO Secção II - Óleos e gorduras(10413, 10414), IMPAA(AAIPR), SPOA(AAUPV)
 | [NAME], S.A. | Torres Novas | 3 | Unidade de processamento de produção de biodiesel(OBIODP) | FATOT, UCO | SPOA(AAUPV)
 | Componatura, Lda. | Chamusca | 2 | Unidade de processamento [NAME] Animal(PROCP) | RAW | VI(BIOGP), [NAME])
Atividades:
Unidade de processamento [NAME] Animal(PROCP)
Unidade de processamento de produção de biodiesel (OBIODP)