tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 173663d1344634979-sorting-grouped-data-in-excel-book1-ily2-oeldere-
Sheet: Current Situation

 | Status |  | RREA  Contact
 | Closed |  | Altobello
 | Closed |  | Altobello
 | Closed |  | Altobello
 | IN CONTRACT |  | Altobello
 | Closed |  | Baum
 | Closed |  | Baum
 | PROPOSALS |  | Baum
 | PROPOSALS |  | Baum
 | RETAINED |  | Baum
 | Closed |  | Baum/Owen
 | Closed |  | Baum/Owen
 | Closed |  | Baum/Owen
 | Closed |  | Baum/Owen
 | IN CONTRACT |  | Baum/Owen
 | PROPOSALS |  | Baum/Owen
 | PROPOSALS |  | Baum/Owen
 | PROPOSALS |  | Baum/Owen
 | PROPOSALS |  | Baum/Owen
 | RETAINED |  | Baum/Owen
 | RETAINED |  | Baum/Owen
 | RETAINED |  | Baum/Owen
 | Closed |  | Baum/Seter
 | AFFILIATE DIRECT |  | Bell
 | AFFILIATE DIRECT |  | Bell
 | Closed |  | Bell
 | Closed |  | Bell
 | IN CONTRACT |  | Bell
 | PROPOSALS |  | Bell
 | RETAINED |  | Bell/Pepe
 | PROPOSALS - THIRD PARTY FINANCE / QUOTES |  | Bode
 | RETAINED - THIRD PARTY ASSIGNMENTS |  | Bode
 | AFFILIATE DIRECT |  | Cortez
 | AFFILIATE DIRECT |  | Cortez
 | AFFILIATE DIRECT |  | Cortez
 | Closed |  | Cortez
 | Closed |  | Cortez
 | Closed |  | Cortez
 | IN CONTRACT |  | Cortez
 | IN CONTRACT |  | Cortez
 | PROPOSALS |  | Cortez
 | PROPOSALS |  | Cortez
 | PROPOSALS |  | Cortez
 | PROPOSALS |  | Cortez
 | RETAINED |  | Cortez
 | RETAINED |  | Cortez
 | RETAINED |  | Cortez
Spreadsheet: eric_saibi__9715__Market briefs
Sheet: Sheet1

Market Brief | Monday, January 7
Stocks | Close | Change | % Change
DJIA | 10197.05 | -62.69000000000051 | -0.006110291293931475
DJ 15 Util. | 296.27 | 2.099999999999966 | 0.007138729306183383
NASDAQ | 2037.11 | -22.27000000000021 | -0.01081393429090319
S&P 500 | 1164.89 | -7.619999999999891 | -0.006498878474383921
Market Vols | Close | Change | % Change
AMEX (000) | 141033 | -25803 | -0.1546608645616054
NASDAQ (000) | 2111444 | -92331 | -0.0418967453573981
NYSE (000) | 1305237 | -207832 | -0.1373579129570429
Commodities | Close | Change | % Change
Crude Oil (Feb) | 21.42 | 0.02000000000000313 | 0.0009345794392524826
Heating Oil (Feb) | 0.5705 | -0.01539999999999997 | -0.02628434886499397
Nat. Gas (Henry) | 2.27 | -0.004999999999999893 | -0.002197802197802151
Propane (Feb) | 30.25 | -0.6499999999999986 | -0.02103559870550157
Palo Verde (Feb) | 24.75 | 0 | 0
COB (Feb) | 24.75 | 0 | 0
PJM (Feb) | 27.55 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 1.928 | 0.008000000000000007 | 0.004166666666666671
Canada $ | 1.598 | 0.001000000000000112 | 0.0006261740763933074
Germany Dmark | 2.189 | 0.004999999999999893 | 0.00228937728937724
Euro | 0.8934 | -0.002000000000000002 | -0.002233638597274963
Japan ¥en | 131 | 0.09999999999999432 | 0.0007639419404124852
Mexico NP | 9.15 | -0.01999999999999957 | -0.002181025081788394
[NAME] | 0.6951 | 0.00340000000000007 | 0.00491542576261395
Foreign Indices | Close | Change | % Change
Arg MerVal | 343.22 | 0 | 0
[NAME]. | 3385.3 | 11 | 0.003259935394007646
[NAME] | 14378.59 | 46.67000000000007 | 0.003256367604619623
Can TSE 300 | 7870.3 | 37.0600000000004 | 0.004731120200581165
Germany DAX | 5232.22 | -86.50999999999931 | -0.0162651610440837
[NAME] | 11892.64 | 190.49 | 0.01627820528706262
Japan Nikkei 225 | 10942.36 | 70.8700000000008 | 0.006518885635731698
[NAME] | 6565.44 | -46.64000000000033 | -0.007053756155400468
UK FTSE 100 | 5293.6 | -30.19999999999982 | -0.005672639843720616
Source:  Yahoo!, TradingDay.com and NYMEX.com
Spreadsheet: 266148d1379512785-i-need-to-bump-data-from-two-different-spreadsheets-2013
Sheet: sheet1

PO_DANIELLE_OM_MFG_PURCHASES | 2359
Unit | PO | PO Date | Vndr SetID | Vendor | Line | Mfg ID | Mfg Itm ID | Item | Description | PO Qty | Price
A | 1579300 | 2013-09-20 00:00:00 | AHS | 92369 | 1 | 2299 | TRC1 | 949328 | ITEM 12 | 1 | 1039.64
A | 1579300 | 2013-09-18 00:00:00 | AHS | 92369 | 2 | 2299 | LLB22 | 930734 | ITEM 14 | 4 | 272.2
C | 1952496 | 2013-09-06 00:00:00 | AHS | 92369 | 8 | 2299 | PDS15 | 25553 | ITEM 17 | 1 | 118
Spreadsheet: 837000d1689778758-if-string-appears-in-array-add-header-name-excel-formula-example-6-
Sheet: Query_Table1

store | employee | ID | Manager
abc | ash | 1 | [NAME]
abc | ton | 2 | [NAME]
abc | [NAME] | 3 | [NAME]
abc | joy | 4 | [NAME]
abc | [NAME] | 5 | [NAME]
abc | alec | 6 | [NAME]
abc | jor | 7 | [NAME]
abc | [NAME] | 8 | [NAME]
[NAME] | ash | 9 | [NAME]
[NAME] | ton | 10 | [NAME]
[NAME] | [NAME] | 11 | [NAME]
[NAME] | alec | 14 | [NAME]
[NAME] | jor | 15 | [NAME]
[NAME] | [NAME] | 16 | [NAME]
[NAME] | ton | 26 | [NAME]
[NAME] | [NAME] | 27 | [NAME]
lmn | joy | 12 | Karrie
lmn | [NAME] | 13 | Karrie
hij | ash | 17 | [NAME]
hij | ton | 18 | [NAME]
hij | [NAME] | 19 | [NAME]
hij | joy | 20 | [NAME]
hij | [NAME] | 21 | [NAME]
zab | alec | 22 | [NAME]
zab | jor | 23 | [NAME]
zab | [NAME] | 24 | [NAME]
zab | ash | 25 | [NAME]
zab | joy | 28 | [NAME]
zab | [NAME] | 29 | [NAME]
uvw | alec | 30 | [NAME]
uvw | jor | 31 | [NAME]
uvw | [NAME] | 32 | [NAME]
uvw | ash | 33 | [NAME]
uvw | ton | 34 | [NAME]
uvw | [NAME] | 35 | [NAME]
fgh | joy | 36 | Karrie
fgh | [NAME] | 37 | Karrie
fgh | alec | 38 | Karrie
fgh | jor | 39 | Karrie
fgh | [NAME] | 40 | Karrie
fgh | ash | 41 | Karrie
fgh | ton | 42 | Karrie
yza | [NAME] | 43 | [NAME]
yza | joy | 44 | [NAME]
yza | [NAME] | 45 | [NAME]
yza | alec | 46 | [NAME]
mno | jor | 47 | [NAME]
pqr | [NAME] | 48 | [NAME]
pqr | ash | 49 | [NAME]
pqr | ton | 50 | [NAME]
pqr | [NAME] | 51 | [NAME]
pqr | joy | 52 | [NAME]
mno | [NAME] | 53 | [NAME]
pqr | alec | 54 | [NAME]
pqr | jor | 55 | [NAME]
mno | [NAME] | 56 | [NAME]
pqr |  |  | [NAME]
Spreadsheet: 546466d1510063667-vlookup-with-random-gaps-in-rows-hard-to-explain-see-attached-sheet-loolup1
Sheet: Sheet1

Part A | Part B | Length | Quantity | 1 |  |  |  |  | Part A | Part B | Length | Quantity
 |  |  |  |  |  |  |  |  | 8 | 9 | 21 | 2
 |  |  |  |  |  |  |  |  | 9 | 10 | 22 | 1
 |  |  |  |  |  |  |  |  | 13 | 14 | 15 | 2
 |  |  |  |  |  |  |  |  | 19 | 20 | 21 | 2
 |  |  |  |  |  |  |  |  | 20 | 21 | 21 | 4
 |  |  |  |  |  |  |  |  | 21 | 22 | 21 | 1
 |  |  |  |  |  |  |  |  | 22 | 23 | 21 | 2
 |  |  |  |  |  |  |  |  | 29 | 30 | 26 | 3
 |  |  |  |  |  |  |  |  | 36 | 43 | 27 | 4
 |  |  |  |  |  |  |  |  | 43 | 44 | 29 | 4
 |  |  |  |  |  |  |  |  | 37 | 38 | 15 | 1
 |  |  |  |  |  |  |  |  | 38 | 39 | 17 | 3
 |  |  |  |  |  |  |  |  | 66 | 68 | 22 | 1
 |  |  |  |  |  |  |  |  | 68 | 69 | 22 | 1
 |  |  |  |  |  |  |  |  | 69 | 70 | 22 | 2
 |  |  |  |  |  |  |  |  | 71 | 72 | 30 | 4
 |  |  |  |  |  |  |  |  | 68 | 69 | 22 | 1
 |  |  |  |  |  |  |  |  | 69 | 70 | 22 | 2
 |  |  |  |  |  |  |  |  | 68 | 69 | 22 | 1
 |  |  |  |  |  |  |  |  | 69 | 70 | 22 | 2
Spreadsheet: 93429d1293011055-calculate-the-sum-of-items-in-one-column-if-condition-other-column-true-book1
Sheet: Sheet1

Category | Value | Is cat. 1? | Is cat. 2? | Is cat. 3?
1 | 10 | 10
2 | 20 |  | 20
3 | 50 |  |  | 50
2 | 100 |  | 100 |  |  |  | Total Cat. 1 | 10
2 | 70 |  | 70 |  |  |  | Total Cat. 2 | 270
2 | 80 |  | 80 |  |  |  | Total Cat. 3 | 10
Spreadsheet: 06bf2b5e-c722-41f2-9f4f-f1d4052eec8f
Sheet: Introduction

 | This  spreadsheet accompanies the U.S. GAAP Financial Reporting Taxonomy v2013 DRAFT Release Notes (August 31, 2012):
 | Below is the link to the worksheet which lists the elements by change made.
 |  |  | Appendix | No. of Elements
 |  |  | Appendix 1: Data Type Changes | 5
 |  |  | Appendix 2: Balance Type Changes | 0
 |  |  | Appendix 3: Deprecated Items | 621
 |  |  | Appendix 3: Undeprecated Items | 7
 |  |  | Appendix 4: Label Changes | 540
 |  |  | Appendix 5: Reference Changes | 110
 |  |  | Appendix 6: Definition Changes | 1138
 |  |  | Appendix 7: New Elements | 653
 |  |  | Appendix 8: Deleted Elements | 357
Spreadsheet: 701489d1603794468-vlookup-to-different-sheet-bid-progress
Sheet: Asbestos VLOOKUP

 |  |  | = Signed School |  | = Confirmed project
 |  |  | = NOT yet signed |  | = Confirmed RESUBMIT
 |  |  | = NOT signed but progress |  | = Confirmed RESUBMIT - Phase 2 part written
 |  |  |  |  | = Confirmed RESUBMIT - TENDERED
 |  |  |  |  | = TBC
 |  |  |  |  | = Awaiting Appeal / Resubmit
 |  |  |  |  | = Awaiting Appeal / Resubmit TENDERED
ROW | APPLICATION DETAILS
 |  |  |  |  |  |  |  |  | Existing R&D Surveys |  |  |  | (Need back by the Friday 16th Oct) |  |  |  |  |  |  | Ideally both at same time
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] normal hrs see quote for w'end hrs |  | Qualserve Quote
DO NOT DELETE | Bid Writer | Lead | School | code | Bid | code | Est £ | New Asbstos Brief Required / Not Required or Previously Done | Bid Resubmit   (Existing R&D Survey Exists Specific to the Bid) | Report Ref (Bid Writer to Check Sufficient) | Asbestos Brief Complete and passed onto ST | Asbestos Brief Issued to WES & Qualserve | Normal Hrs | Weekend Hrs | Normal Hrs | Weekend Hrs | Instruction Given to (WES or Qualserve) | School October half-term holidays (1 WEEK) Week Comencinjg | Appointment discussed / agreed with School | Date Survey Booked in For | Roofing Survey Date
1 |  |  |  |  |  |  |  | Done | Yes | CARTWRIGHT BLOCK ONLY LK - LP17 00281 (Nov 2017) | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-10-26 00:00:00
 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
3 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding |  |  |  |  |  |  | 2020-10-26 00:00:00
4 |  |  |  |  |  |  |  | Yes | N/A | N/A | outstanding
Spreadsheet: 01443798-0985-4e9d-a0b3-0fc611b9c378
Sheet: by country

Users | Population | Users per 1,000,000 residents | Country
1 | 65000 |  | Bermuda
1 | 80000 |  | Isle of Man
48 | 4326700 |  | New Zealand
46 | 4839600 |  | Norway
3 | 319246 |  | Iceland
83 | 9316256 |  | Sweden
538 | 61634599 |  | United Kingdom
189 | 21939000 |  | Australia
33 | 4459300 |  | Ireland
3 | 413627 |  | Malta
243 | 33809000 |  | Canada
39 | 5519441 |  | Denmark
50 | 7459900 |  | Israel
1807 | 307690000 |  | United States
95 | 16551237 |  | Netherlands
27 | 5347277 |  | Finland
35 | 7745900 |  | Switzerland
9 | 2047009 |  | Slovenia
41 | 10754528 |  | Belgium
5 | 1340415 |  | Estonia
29 | 8355260 |  | Austria
10 | 4987600 |  | Singapore
142 | 82002000 |  | Germany
5 | 3349872 |  | Lithuania
3 | 2257300 |  | Latvia
13 | 10627250 |  | Portugal
12 | 10031208 |  | Hungary
25 | 21498616 |  | Romania
13 | 11257285 |  | Greece
12 | 10476543 |  | Czech Republic
41 | 38100700 |  | Poland
64 | 65073482 |  | France
5 | 5413548 |  | Slovakia
1 | 1339000 |  | Trinidad
7 | 9850000 |  | Serbia
1 | 1409000 |  | Qatar
5 | 7606551 |  | Bulgaria
2 | 3230100 |  | Armenia
4 | 7008900 |  | Hong Kong
25 | 49320500 |  | South Africa
1 | 2048620 |  | Macedonia
2 | 4224000 |  | Lebanon
2 | 4435056 |  | Croatia
27 | 60157214 |  | Italy
14 | 40134425 |  | Argentina
16 | 45929476 |  | Spain
1 | 2985000 |  | Kuwait
1 | 3361000 |  | Uruguay
1 | 3567500 |  | Moldova
2 | 7466000 |  | Honduras
4 | 16976000 |  | Chile
10 | 46029281 |  | Ukraine
6 | 28310000 |  | Malaysia
15 | 71517100 |  | Turkey
2 | 10090000 |  | Dominican Republic
28 | 141882000 |  | Russia
31 | 191990000 |  | Brazil
1 | 6349000 |  | Paraguay
20 | 127540000 |  | Japan
12 | 107550697 |  | Mexico
1 | 10327800 |  | Tunisia
6 | 63389730 |  | Thailand
2 | 23069345 |  | Taiwan
1 | 14027000 |  | Guatemala
2 | 29132013 |  | Perú
1 | 14805000 |  | Cambodia
2 | 30747000 |  | Iraq
69 | 1170150000 |  | India
4 | 77279837 |  | Egypt
1 | 20238000 |  | [NAME]
1 | 21906000 |  | Syria
2 | 45117683 |  | Colombia
4 | 92226600 |  | Philippines
1 | 25721000 |  | Saudi Arabia
1 | 28501797 |  | Venezuela
1 | 31602540 |  | Morocco
5 | 167676000 |  | Pakistan
2 | 74196000 |  | Iran
1 | 39802000 |  | Kenya
1 | 48333000 |  | South Korea
1 | 66020000 |  | Congo
1 | 85789573 |  | Vietnam
2 | 229965000 |  | Indonesia
1 | 162221000 |  | Bangladesh
6 | 1333500000 |  | China
Spreadsheet: 126645d1319805811-pivot-table-has-2-fridays-instead-of-1-comprehensive-data-analysis
Sheet: PIVOT TABLE

Row Labels | Average of Amount
Gross CRA Select Page Visits | 66505.42857142857
Use of Site Page Hits | 45.42857142857143
Unique Web Sessions | 127619.5714285714
Total Delivered Request Transaction | 92712.85714285714
Total Connects - Ineligible States | 0
Total Connects - Eligible States | 81227.57142857143
Tot Unfulfilled Online Transactions | 21652.42857142857
Tot Succ Transactions | 27463.42857142857
Tot No Requests Returned | 43597
Submit Counts | 66505.42857142857
State Ineligible-Landing | 0
State Ineligible from Order | 0
State Eligible-Landing | 78236.57142857143
State Eligible from [NAME] | 2991
Select TransUnion | 40548.42857142857
Select Phone Source | 2735.428571428572
Select Mail Source | 796.2857142857143
Select Experian | 42512.14285714286
[NAME] | 43149.71428571428
Select any 2 CRA | 4766.285714285715
Select any 1 CRA | 34307.57142857143
Select all 3 CRA | 27456.71428571429
Security Policy Page Hits | 140
Request Process Vol | 66530.57142857143
Request Form Page Hits | 81227.57142857143
Progress Page Hits | 49115.85714285714
Progress Next Button | 26116.14285714286
Privacy Policy Page Hits | 160.2857142857143
Order Source Page Hits | 3917.857142857143
Ineligible Page Hits | 0
Gross Web Sessions | 133299.2857142857
Gross Landing Page Hits | 140724.7142857143
Gross Help Page Hits | 10674.28571428571
FAQ Page Hits | 7094.571428571428
Contact Us Page Hits | 3234
Tot Unfulfilled Transunion | 11089
Tot Unfulfilled Experian | 6337.142857142857
Tot Unfulfilled Equifax | 4226.285714285715
Tot TransUnion | 29111.85714285714
Tot Succ TransUnion | 4420.857142857143
Tot Succ Experian | 10093.14285714286
Tot Succ Equifax | 12949.42857142857
Tot Experian | 31121.28571428571
Tot Equifax | 32479.71428571429
Grand Total | 33383.93506493507
Spreadsheet: drew_fossum__8874__01_19_00StanH_mtg_final
Sheet: 1 qtr SummaryTW

 | Enron Transportation & Storage - Marketing
 | First Quarter Forecast
 | As of 1/14/00
 | Millions of Dollars
 | [NAME]
 |  |  |  | Jan | Feb | March | Total
 | Error in plan |  |  | -0.027 | -0.026 | -0.027 |  |  | Duplication (Bayless ctrc)
 | Unsubscribed |  |  | -0.05 |  |  |  |  | (9,000/d EOT-WOT & 25,000/d SLaPl-Bl)
 | Interim resubscription |  |  |  | -0.1 | -0.11 |  |  | Ctrc exp end of Jan - short-term rate $.05 vs. $12 (49,475/d EOT-WOT)
 | El Paso Field Services |  |  | -0.039 | -0.03625 | -0.03875 |  |  | Interconnect delayed on EPFS side
 | Southwest Gas |  |  | -0.01 | -0.01 | -0.01 |  |  | Pending FERC approval on SWGas side
 | Enhanced Firm Backhaul |  |  |  |  | -0.01 |  |  | Pending FERC approval
 | Market Center Service |  |  | -0.01
 | Interim resubscription |  |  |  |  | -0.02 |  |  | Ctrc exp end of Feb - short-term rate $.06 vs. $.10 (15,000/d BL-TH)
 | Subscribed at higher rates and volumes |  |  | 0.04 | 0.04 | 0.04 |  |  | Limited Term Firm,Texaco, Southern
 | 30-day deals and Daily FT |  |  | 0.08
 | [NAME]. |  |  | 0.3
 | TOTAL MARGIN
 | Fuel  Price [NAME] |  |  | 0 | -0.1 | -0.1 |  |  | Price variance only, could be offset with increased volumes
 | Total Transwestern
Spreadsheet: 87201d1287057063-use-a-variable-as-a-cell-address-variable-as-a-cell-address
Sheet: Sheet1

English | French
English1 | French1 |  |  | English | The French | Is it Correct? | Correct Answer if you're wrong | Hold Question (Blank for Next Question) | Question Code
English2 | French2 |  |  |  |  |  |  | 1
English3 | French3
English4 | French4
English5 | French5
English6 | French6
English7 | French7
English8 | French8
English9 | French9
English10 | French10
English11 | French11
English12 | French12
English13 | French13
English14 | French14
English15 | French15
English16 | French16
English17 | French17
English18 | French18
English19 | French19
English20 | French20
English21 | French21
English22 | French22
English23 | French23
English24 | French24
English25 | French25
English26 | French26
English27 | French27
English28 | French28
English29 | French29
English30 | French30
Spreadsheet: darrell_schoolcraft__7353__imball0201
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -492632 | -494656
2 | -501900 | -485325
3 | -540213 | -539549
4 | -472917 | -473220
5 | -501953 | -499242
6 | -549512 | -560014
7 | -525598 | -521371
8 | -534270 | -531085
9 | -607985 | -606773
10 | -588011 | -634161
11 | -603183 | -611815
12 | -599978 | -580516
13 | -586866 | -580516
14 | -573809 | -573034
15 | -541773 | -542075
16 | -554650 | -567930
17 | -534042 | -533662
18 | -560683 | -561288
19 | -565794 | -575734
20 | -566988 | -568953
21 | -539935 | -542926
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 104420
2002-01-21 00:00:00
CBS Dollars
 |  |  | 331917
Spreadsheet: 798356d1664443119-create-summary-sheet-on-multiple-values-and-criteria-29092022-sample-file-for-excel-forum
Sheet: Branch 2

 | Opening | Dep | closing
furniture | 1500 | 300
Computer | 2000 | 200
Computer
furniture
Computer
furniture
Spreadsheet: 813271d1673629703-how-insert-rows-copy-row-and-transpose-to-column-how-to-transpose
Sheet: Sheet1

Raw data |  |  |  |  |  | Desired output
20221431 | QTEN | TS-EN Stage | 152
 | 70002 | BIN_REQ_DATA | 106
 | QSTS | OS-TS Stage | 183
 | 50004 | Open/Short - Open (Neg) | 822
 | QScratchSF | OB-Scratches(SF) | 298
 | QGTkG | GT - Mod Thickness Out | 194
Spreadsheet: 677807d1589535861-countifs-help-manhole-table-etaf
Sheet: Surface Manhole

Just the number, formatted for S
Need to be in Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | imported granular fill
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | size
M/H Ref. | Cover | Invert | M/H Dp. | M/H Type | M/H | Largest Pipe | Backdrop | Raisng Pieces | 1000mm | 750mm | 500mm | Manhole depth outstanding less 150mm each cover slab and cover |  |  |  |  |  |  |  | M/H |  | E.O. |  | E.O |  | E.O |  | E.O |  | E.O |  | E.O |  | E.O. |  | E.O |  | Volume of Spoil
 |  |  |  |  | Ø |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rate |  | Type 4 |  | G.R.P |  | Larger Cover |  | A.M.P.S. |  | Ladder |  | Hydrobrake |  | Penstock |  | Ext. Sewer
 |  |  | (m) |  | (m) |  | (Ø x nr) |  |  |  |  |  |  |  |  |  |  |  |  |  | 83 |  | 83 | Hand railings | 83 |  | 83 |  | 83 |  | 83 |  | 83 |  | 83 |  | 83
1 | 3 | 1.63 |  |  | 1200
2 | 3 | 1.45 |  |  | 1200
34 | 3 | 1 |  |  | 1500
5 | 3 | 0.98 |  |  | 1200
6 | 3 | 0.5 |  |  | 1500
7 | 3 | 0.55 |  |  | 1800
8 | 3 | 0.45 |  |  | 2100
9 | 3 | 1 |  |  | 2100
10 | 3 | 0.6 |  |  | 2400
11 | 3 | 1.1 |  |  | 2100
12 | 3 | 0.3 |  |  | 1500
13 | 3 | 0.8 |  |  | 2400
Spreadsheet: 35971d1233706784-index-match-product-mix-comparison
Sheet: Week of 26

ID | Name | Net Revenue
33 | Open Food | 74.05
37 | small paper plate | 62.76
38 | large paper plate | 115.69
39 | large to go | 741.78
40 | small to go | 132.77
41 | Dry Fruit | 1.68
42 | china plate | 110.74
47 | Gyro | 340
52 | [NAME] | 1.75
62 | Small Soup Cup | 9.28
71 | Extra Avocado | 0.5
74 | Vegan Sun Cakes | 8.4
75 | Pacific Rim | 2095.65
80 | 22oz Soup | 24.75
81 | Taqueria2 | 1892.1
87 | Dressing | 5.95
90 | Vegan Special | 609
92 | [NAME] | 87.5
100 | Broiler Special | 925.65
101 | [NAME] Special | 31.5
102 | Exhibition | 1380
103 | Exhibition Chicken | 11.9
105 | Panini | 15
106 | Panini w/side salad | 304.75
107 | [NAME] | 227.55
108 | Sushi made to order | 786.5
110 | Entree | 2162.75
111 | Entree Feature | 1482.7
113 | Grab & Go Salad | 138
114 | Side Vegetable | 100
116 | [NAME] | 707.75
126 | Izze Soda | 5.6
127 | Gatorade | 1.4
128 | [NAME] | 9.8
130 | Rockstar | 5.25
131 | Pizza Special | 327.75
137 | Bawls Energy | 3.5
138 | Pomegranate Juice | 6.3
140 | [NAME] | 2.1
141 | LaBrea Roll | 10.5
152 | NewTree Chocolate | 4.2
153 | [NAME] | 1814.25
154 | seaweed | 4.2
155 | Jelly Beans | 3.15
156 | Milk 1/2 Pint | 12
167 | Minute [NAME] | 4.5
168 | Minute [NAME]) | 40
169 | Brownies | 3.3
171 | small paper plate Deli | 13.84
172 | [NAME] | 6.96
173 | small to go [NAME] | 12.88
174 | large paper plate Deli | 166.64
175 | Large Soup Cup Deli | 11.36
176 | large to go [NAME] | 200.64
177 | china plate [NAME] | 4.72
193 | Half Grapefruit | 0.75
194 | Whole Grapefruit | 3.75
196 | Edemame | 2
199 | One Taco | 20
200 | Cheese Pizza | 38
201 | [NAME] | 15.75
202 | Pizza with meat | 227.85
203 | Deep Dish Pizza | 88
204 | Bruschetta | 194.75
205 | [NAME] | 12.5
207 | Meat Pizza | 508.25
208 | Seafood Pizza | 14.25
209 | [NAME] to order | 9.5
212 | Cheese Quesadilla | 31.5
213 | Deluxe Quesadilla | 195
214 | [NAME] | 61.75
300 | 12oz Soup | 324
301 | 16oz Soup | 380
302 | 12oz Chili | 2.4
304 | Roll/Bread | 57
305 | Bread Bowl | 3
400 | Avocado | 2
401 | Bacon Cheese Burger | 15
402 | [NAME] | 20
403 | Broadcom Burger | 273
405 | [NAME] Sandwich | 171
407 | Club Sandwich | 52.25
409 | Fries | 98.75
410 | Garden Burger | 38
411 | Grilled Cheese | 42.5
412 | Ham & Cheese Sandwich | 40
413 | Hamburger | 51
414 | Cheeseburger | 36.8
419 | Onion Rings | 19.2
420 | [NAME] | 4
421 | Sliced Tomato | 1.05
422 | [NAME] | 97.75
500 | Whole Fruit | 145.5
505 | Pudding | 14
507 | Large [NAME] | 14
508 | Small Yogurt Parfait | 6.75
510 | [NAME] | 29.7
511 | Gourmet Chips | 27.5
512 | Regular Chips | 80.85
513 | Cheesecake | 17.5
520 | Monster Cookies | 19.6
521 | Ms. Mays | 2
522 | Nut Bread's and Cookie Bars | 3.75
526 | Energy Bars | 4.2
802 | Soy Milk | 1.8
Spreadsheet: 86585d1286531099-compare-two-values-in-separate-columns-feil
Sheet: DIPS v. OF

Invoiceno | Amount | (Ikke)overført | [NAME] | Basisvaluta | Overført beløp
1017430 | 295 | overført | 1010015 | 294 | #N/A
1017432 | 295 | overført | 1015361 | 884 | #N/A
1017434 | 295 | overført | 1015362 | 740 | #N/A
1007016K | -295 | overført | 1016471 | 295 | #N/A
1009003K | -370 | overført | 1017430 | 295 | #N/A
1009009K | -75 | overført | 1017432 | 295 | #N/A
1009031K | -295 | overført | 1017434 | 295 | #N/A
1009074K | -25 | overført | 1007016K | -295 | OK
1009086K | -294 | ikke overført | 1009003K | -370 | OK
 |  |  | 1009009K | -75 | OK
 |  |  | 1009031K | -295 | OK
 |  |  | 1009074K | -5 | FEIL BELØP
Spreadsheet: 122245d1316694138-using-sumif-to-show-win-loss-when-1-team-plays-4-others-nfl-example5
Sheet: Sheet1

 | Table 1 is ok |  |  |  |  |  |  |  | These columns will run to include the whole season
Table 1 |  | Wins | Loss | Home Win | Home Loss | Road Win | Road Loss
 |  |  |  |  |  |  |  |  | Week 3
 | Jacksonville | 3 | 1 | 1 | 1 | 2 | 0 |  | Jacksonville | 24 | 21 | Carolina
 | Tampa Bay | 3 | 1 | 2 | 1 | 1 | 0 |  | Tampa Bay | 28 | 7 | Cincinatti
 | Atlanta | 4 | 0 | 1 | 0 | 3 | 0 |  | Atlanta | 30 | 16 | Buffalo
 | Denver | 0 | 4 | 0 | 3 | 0 | 1 |  | Denver | 3 | 9 | New Orleans
 | Carolina | 2 | 2 | 1 | 1 | 1 | 1
 | Cincinatti | 0 | 4 | 0 | 2 | 0 | 2 |  | Week 12
 | Buffalo | 2 | 2 | 0 | 1 | 2 | 1 |  | Carolina | 20 | 10 | Cincinatti
 | New Orleans | 2 | 2 | 2 | 0 | 0 | 2 |  | Jacksonville | 42 | 35 | Tampa Bay
 |  |  |  |  |  |  |  |  | Buffalo | 19 | 22 | New Orleans
 |  |  |  |  |  |  |  |  | Atlanta | 13 | 9 | Denver
 |  |  |  |  |  |  |  |  | Week 16
 |  |  |  |  |  |  |  |  | Atlanta | 6 | 3 | Jacksonville
 |  |  |  |  |  |  |  |  | Cincinatti | 28 | 35 | Tampa Bay
 |  |  |  |  |  |  |  |  | New Orleans | 19 | 22 | Carolina
 |  |  |  |  |  |  |  |  | Buffalo | 13 | 9 | Denver
 | In table 2 I just want to pick out the wins and losses where Jacksonville and Carolina play each other |  |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | New Orleans | 6 | 10 | Jacksonville
Table 2 | Table 2 is ok |  |  |  |  |  |  |  | Cincinatti | 28 | 35 | Tampa Bay
 |  |  |  |  |  |  |  |  | Carolina | 19 | 22 | Atlanta
 |  |  |  |  |  |  |  |  | Buffalo | 13 | 9 | Denver
 | Carolina | Wins | Loss
 | Jacksonville | 1 | 0
 | As table 2 but Jacksonville need to play Atlanta, New Orleans, Tampa Bay & Carolina.
Table 3 | Table 3 is ok |  |  |  |  |  |  |  |  |  |  | Table 4 | As table 3 but Jacksonville only need to play Atlanta & Carolina. The code for table 3 doesn't work because
 |  |  |  |  |  |  |  |  |  |  |  |  | the cells aren't next to each other. So table 4 should read like this
 | Atlanta |  |  |  |  |  |  |  |  |  |  |  | Atlanta
 | New Orleans |  |  |  |  |  |  |  |  |  |  |  | New Orleans
 | Tampa Bay |  |  |  |  |  |  |  |  |  |  |  | Tampa Bay
 | Carolina | Wins | Loss |  |  |  |  |  |  |  |  |  | Carolina | Wins | Loss
 | Jacksonville | 3 | 1 |  |  |  |  |  |  |  |  |  | Jacksonville | 1 | 1