tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738605d1625148107-cumulative-sum-and-if-preorder-examples
Sheet: Sheet1

Example 1. |  |  |  |  |  | Example 2. |  |  |  |  |  | Example 3. |  |  |  |  |  | Example 4.
internal_no | order_qty | preo_qty | new_OQ |  |  | internal_no | order_qty | preo_qty | new_OQ |  |  | internal_no | order_qty | preo_qty | new_OQ |  |  | internal_no | order_qty | preo_qty | new_OQ
BO [PHONE] | 5 |  | 5 |  |  | BO [PHONE] | 5 |  | 5 |  |  | BO [PHONE] | 5 |  | 5 |  |  | BO [PHONE] | 5 |  | 5
BO [PHONE] | 5 |  | 5 |  |  | BO [PHONE] | 5 |  | 5 |  |  | BO [PHONE] | 5 |  | 5 |  |  | BO [PHONE] | 5 |  | 5
BO [PHONE] | 0 | 20 | 20 |  |  | BO [PHONE] | 0 |  | 0 |  |  | BO [PHONE] | 0 | 10 | 10 |  |  | BO [PHONE] | 0 | 10 | 10
BO [PHONE] | 5 | 20 | 0 |  |  | BO [PHONE] | 5 | 2 | 5 |  |  | BO [PHONE] | 5 | 10 | 0 |  |  | BO [PHONE] | 5 | 10 | 0
BO [PHONE] | 0 | 20 | 0 |  |  | BO [PHONE] | 0 | 2 | 0 |  |  | BO [PHONE] | 0 | 10 | 0 |  |  | BO [PHONE] | 0 | 10 | 0
BO [PHONE] | 5 | 20 | 0 |  |  | BO [PHONE] | 5 | 2 | 5 |  |  | BO [PHONE] | 5 | 10 | 0 |  |  | BO [PHONE] | 5 | 10 | 0
BO [PHONE] | 5 | 20 | 0 |  |  | BO [PHONE] | 5 | 2 | 5 |  |  | BO [PHONE] | 5 | 10 | 5 |  |  | BO [PHONE] | 5 | 10 | 5
BO [PHONE] | 5 | 20 | 0 |  |  | BO [PHONE] | 5 | 2 | 5 |  |  | BO [PHONE] | 5 | 20 | 20 |  |  | BO [PHONE] | 5 | 2 | 5
BO [PHONE] | 0 | 20 | 0 |  |  | BO [PHONE] | 0 | 2 | 0 |  |  | BO [PHONE] | 0 | 20 | 0 |  |  | BO [PHONE] | 0 | 2 | 0
BO [PHONE] | 5 | 20 | 5 |  |  | BO [PHONE] | 5 | 2 | 5 |  |  | BO [PHONE] | 5 | 20 | 0 |  |  | BO [PHONE] | 5 | 2 | 5
BO [PHONE] | 0 | 20 | 0 |  |  | BO [PHONE] | 0 | 2 | 0 |  |  | BO [PHONE] | 0 | 20 | 0 |  |  | BO [PHONE] | 0 | 2 | 0
BO [PHONE] | 5 | 20 | 5 |  |  | BO [PHONE] | 5 | 2 | 5 |  |  | BO [PHONE] | 5 | 20 | 0 |  |  | BO [PHONE] | 5 | 2 | 5
BO [PHONE] | 0 | 20 | 0 |  |  | BO [PHONE] | 0 | 2 | 0 |  |  | BO [PHONE] | 0 | 20 | 0 |  |  | BO [PHONE] | 0 | 2 | 0
BO [PHONE] | 5 | 20 | 5 |  |  | BO [PHONE] | 5 | 2 | 5 |  |  | BO [PHONE] | 5 | 20 | 0 |  |  | BO [PHONE] | 5 | 2 | 5
BO [PHONE] | 5 | 20 | 5 |  |  | BO [PHONE] | 5 | 2 | 5 |  |  | BO [PHONE] | 5 | 20 | 5 |  |  | BO [PHONE] | 5 | 2 | 5
Total |  |  |  |  |  | Total |  |  |  |  |  | Total |  |  |  |  |  | Total
Spreadsheet: 600222d1543530090-diasplay-values-based-on-date-end-of-shift-example
Sheet: Form Submissions

Timestamp | Shift | 0000 | 0700 | 1900
2018-11-01 00:00:00 | Day | 150 | 100
2018-11-01 00:00:00 | Night |  |  | 135
2018-11-02 00:00:00 | Day | 140 | 155
2018-11-02 00:00:00 | Night |  |  | 100
2018-11-03 00:00:00 | Day | 130 | 185
2018-11-03 00:00:00 | Night |  |  | 200
2018-11-04 00:00:00 | Day | 111 | 125
2018-11-04 00:00:00 | Night |  |  | 300
Spreadsheet: 104178d1301833221-keep-raw-of-maximum-value-keep-maximum-value
Sheet: Sheet1

shipper | Responsible | Value
4 YOU CLOTHING LTD | Hossain, [NAME] | 1
786 GARMENTS & TEXTILES | [NAME], [NAME] | 1
A & A TROUSERS LTD | [NAME], [NAME] | 1
A G DRESSES LTD | Zahir, [NAME] | 1
A J SUPER GARMENTS LTD | [NAME], Binoy Krishna | 2
A K M KNITWEAR LTD | Hossain, [NAME] | 1
A K M KNITWEAR LTD | [NAME], [NAME] | 3
A M DESIGN LTD | Barman, Nilmani | 1
A M DESIGN LTD | [NAME], [NAME] | 2
A PLUS INDUSTRIES LTD | Barman, Nilmani | 1
A T S APPARELS LTD | Awal, [NAME] | 1
A T S APPARELS LTD | [NAME], [NAME] | 2
A T S APPARELS LTD | Zahir, [NAME] | 1
Spreadsheet: 56940d1257128024-merging-data-from-two-sheets-excelhelp
Sheet: Sheet1

Country | [State] | [Area] | [Pcode]
Australia | ACT | [NAME] | 2617
Australia | ACT | Canberra | 2601
Australia | NSW | Bilambil | 2486
Australia | NSW | Brookvale | 2100
Australia | NSW | Caringbah | 2229
Australia | NSW | Copacabana | 2251
Australia | NSW | EmuPlains | 2750
Spreadsheet: 767411b1-76fc-4d80-9356-3427997b2184
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 4/25/2014 12:07:17 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 159710d1338823590-lookup-in-split-ranges-as-in-one-20120604-copy
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Segment1 | Segment2 | Segment3 | Segment4 |  | Segment1 | Segment2 | Segment3
Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product1 | Product2 | Product3 | Product4 | TOTAL1 | Product5 | Product6 | Product7 | TOTAL2
686 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19768.32 | 150986.9338653869 | 253.4546031823052 | 96690.43465604144 | 247930.8231246107 |  | 21948.80357057933 | 351771.192225989 | 373719.9957965683
5005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23552.64 | 109475.1240116674 | 4366.923363763268 |  | 113842.0473754307 | 2528.696383630736 | 3052.035901321763 |  | 5580.732284952499
Spreadsheet: 751986d1634494348-needing-help-with-matching-ir-rollup-12oct21
Sheet: Parts Req'd

NIIN | QTY
000045033 | 1
007744602 | 3
016212974 | 1
010602531 | 1
010428880 | 1
005704060 | 1
007334704 | 1
007334704 | 1
000501239 | 5
001003883 | 1
007732138 | 1
007732138 | 2
001879550 | 3
006797951 | 1
006797951 | 1
006825822 | 2
000529480 | 2
009595878 | 1
009595878 | 1
001004471 | 1
000137258 | 1
009960716 | 3
009960716 | 1
008088355 | 1
008088355 | 1
005704057 | 1
000000079 | 1
000880552 | 4
015062715 | 2
002932336 | 20
002933336 | 14
005417839 | 4
Spreadsheet: louise_kitchen__22633__SepQTD Orig w notes Faith
Sheet: Canada

Canada
For the Quarter Ended September 30
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Davies |  | Power |  | Canada |  | 50200000
Sangwine |  | Gas |  | Canada |  | 479509
[NAME] |  | Gas |  | Canada |  | 370641
Burnham |  | Gas |  | Canada |  | 298111
[NAME] |  | Gas |  | Canada |  | 238257
Oh |  | Gas |  | Canada |  | 154878
Le Dain |  | Gas |  | Canada |  | 130849
Hrap |  | Gas |  | Canada |  | 76203
Laporte |  | Gas |  | Canada |  | 4021
Tycholiz |  | Gas |  | Canada |  | 917
Total
Spreadsheet: daren_farmer__5981__hpl0616
Sheet: Sheet1

HPLN0616.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC) |  |  |  |  |  | REVISION #1
SUBJECT:  NOMINATIONS - Effective June 16, 2000
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-16 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 25
Enron (FM) |  | HPL - Katy (DBND) |  | HPL | 0 | 5
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 0 | 1.4 | *
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Oasis Turbine |  | Empire | 9.35 | 7.95 | *
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: jeff_dasovich__14083__ENRON2
Sheet:  ORA

ORA (PG&E)
RESOURCE TYPE | ELECTRICITY GENERATION (GWH) | REVENUE REQUIREMENT ($ MILLIONS) | AVERAGE COST ($/MWH)
QF | 22323 |  | 80
Fossil | 1526 |  | 113
Hydro | 12409 | 184000
[NAME] | 17208 |  | 35
Other Purchases | 8301 |  | 42
SUBTOTAL UTILITY GENERATION
CDWR Purchases |  |  | 80
TOTAL GENERATION
Ancillary Services Uplift |  |  | 10
Fully Loaded Procurement Costs at Generation
Fully Loaded Procurement Costs at Meter
Generation Component in Retail Rates |  |  | 70
Necessary Rate Increase (Decrease)
Retail Sales at Meter | 82300
Retail Sales at Generation
WAPA & CCSF Sales @ Generation
TOTAL SYSTEM LOAD
Utility Generation
NET SHORT
ORA (SCE)
RESOURCE TYPE | ELECTRICITY GENERATION (GWH) | REVENUE REQUIREMENT ($ MILLIONS) | AVERAGE COST ($/MWH)
QF | 26100 |  | 80.2
Coal | 10562 | 210290
Hydro | 4790 | 52100
Nuclear | 19355 | 720110
SUBTOTAL UTILITY GENERATION
CDWR Purchases |  |  | 80
TOTAL GENERATION
Ancillary Services Uplift |  |  | 10
Fully Loaded Procurement Costs at Generation
Fully Loaded Procurement Costs at Meter
Generation Component in Retail Rates |  |  | 75
Necessary Rate Increase (Decrease)
NET SHORT CALCULATION
Retail Sales at Meter | 84000
Retail Sales at Generation
Utility Generation
Net Short
Footnote:
Replaced ORA's assumption for DWR weighted-average portfolio cost, included an estimate for ancillary services, and assume no Direct Access Load.
Spreadsheet: 822616d1679446174-problem-with-countif-index-and-sequence-book1
Sheet: Sheet1

Code | Result | Sum
52443 | A1 | 21
53018 | DS | 20 |  | A1 | #[NAME]!
52590 | DS | 20 |  | A1 | #[NAME]!
12259 | DS | 20 |  | CS | #[NAME]!
52992 | CS | 18 |  | A1 | #[NAME]!
52680 | DS | 18 |  | A1 | #[NAME]!
2486 | DS | 18 |  | CS | #[NAME]!
52009 | A1 | 17 |  | A1 | #[NAME]!
52719 | DS | 14 |  | DS | #[NAME]!
52062 | CS | 12 |  | CS | #[NAME]!
52452 | A1 | 11
52999 | DS | 11
53151 | A1 | 38
52038 | A1 | 23
52324 | A1 | 36
52625 | A1 | 22
52174 | A1 | 34
52633 | A1 | 28
11905 | CS | 34
52813 | A1 | 29
53075 | A1 | 25
52008 | A1 | 33
53590 | A1 | 33
52659 | A1 | 29
53276 | CS | 32
53478 | DS | 27
52272 | A1 | 32
52781 | DS | 32
52254 | DS | 26
53399 | CS | 32
Spreadsheet: 143321d1330365690-multiple-lines-of-similar-data-to-one-single-line-multi-line
Sheet: Sheet1

Name | Reg Time | Disch Time | Diag Code | Help Column | Name | Reg | Disch | Diag Code
[NAME] | 2010-10-01 00:00:00 | 2010-10-02 00:00:00 | 401.1
[NAME] | 2010-10-01 00:00:00 | 2010-10-02 00:00:00 | 402.1
[NAME] | 2010-10-01 00:00:00 | 2010-10-02 00:00:00 | 403.1
Patient 1 | 2012-02-27 00:00:00 | 2012-02-27 00:00:00 | 401.1
Patient 1 | 2012-02-27 00:00:00 | 2012-02-27 00:00:00 | 402.1
Patient 1 | 2012-02-27 00:00:00 | 2012-02-27 00:00:00 | 403.1
Patient 2 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 401.1
Patient 2 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 402.1
Patient 2 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 403.1
Spreadsheet: 680295d1590922666-calculate-months-withing-1st-and-2nd-half-of-the-year-depeding-on-changable-date-calculate-months-in-1st-and-2nd-half-of-the-year
Sheet: Sheet1

From | To |  |  | Year | 2021 | 2022 | 2023 | 2024 | 2025 | 2026
2021-06-01 00:00:00 | 2025-05-31 00:00:00 |  |  | Month 1st half of the year |  |  |  |  |  |  | This is how the result should look like
 |  |  |  | months 2nd half of the year
The dates can be changed by the user
Spreadsheet: d4cd4aef-4e5b-418f-a491-c7631b94e4b6
Sheet: Sheet1

M&MIII FSM Toll Free Numbers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Field Service Manager (Maintenance)
 | Contract Area | Contract Area States | Company Name | Toll-Free Number
 | 3A | IL | PK Management | [PHONE]
 | 4A | IN, KY | PK Management | [PHONE]
 | 5A | NC, SC | PK Management | [PHONE]
 | 6A | MS, AL | PK Management | [PHONE]
 | 6B | TN | PK Management | [PHONE]
 | 7A | GA | A2Z Field Services | [PHONE]
 | 8A | FL, PR, VI | CWIS | [PHONE]
 | 1D | CO, NM, TX (North), UT | Sigma Construction | [PHONE] ext. 3
 |  | CO, NM, TX (North), UT | AMS | [PHONE]
 | 2D | AR, KS, LA, MO, OK, TX (South) | A2Z Field Services | [PHONE]
 |  | AR, KS, LA, MO, OK, TX (South) | AMS | [PHONE]
 |  | AR, KS, LA, MO, OK, TX (South) | Cityside HNH | [PHONE]
 | 4D | WI, IA, NE, SD | Sentinel Field Services | [PHONE]
 | 5D | WY, MT, ND, MN | Sentinel Field Services | [PHONE]
 | 3S | AZ | CWIS | [PHONE]
 | 4S | ID, NV | PK Management | [PHONE]
 | 5S | CA, HI, Guam | Sentinel Field Services | [PHONE]
 | 6S | OR, WA, AK | Sentinel Field Services | [PHONE]
 | 1P | MI | A-Son’s | [PHONE]
 |  | MI | Sigma Construction | [PHONE] ext. 4
 |  | MI | AMS | [PHONE]
 |  | MI | Inspection Experts | [PHONE]
 | 2P | DC, DE, MD, PA, OH, VA, WV | A2Z Field Services | [PHONE]
 |  | DC, DE, MD, PA, OH, VA, WV | Cityside HNH | [PHONE]
 |  | DC, DE, MD, PA, OH, VA, WV | Innotion | [PHONE]
 | 3P | CT, MA, ME, NH, NJ, NY, RI, VT | A-Son’s | [PHONE]
 |  | CT, MA, ME, NH, NJ, NY, RI, VT | AMS | [PHONE]
 |  | CT, MA, ME, NH, NJ, NY, RI, VT | Cooper-CitiWest JV | [PHONE]
 |  |  |  | Revised 3-26-14
Spreadsheet: 217861d1362233770-help-how-to-display-passport-and-visa-almost-expired-dates-to-another-sheet-sample
Sheet: DATABASE

SR. No. | EMP. ID | Name of EMP. | Nationality | Passport No. | [NAME] | Salary | Sponsor | Designation | Joining Date | Joining Date | [NAME]
1 | EMP 1 | Employee 1 |  |  | 2012-11-13 00:00:00 | 2200 | DTC | SUPERVISOR | ------- | 2008-11-01 00:00:00 | 2013-12-18 00:00:00
2 | EMP 2 | Employee 2 |  |  | 2012-11-14 00:00:00 | 2200 | DTC | SUPERVISOR | ------- | 2008-11-01 00:00:00 | 2014-01-13 00:00:00
3 | EMP 3 | Employee 3 |  |  | 2012-11-15 00:00:00 | 2500 | GET | STORE KEEPER | ------- | 2008-11-01 00:00:00 | 2013-08-13 00:00:00
4 | EMP 4 | Employee 4 |  |  | 2012-11-16 00:00:00 | 1100 | DTC | MASON | ------- | 2008-11-01 00:00:00 | 2014-02-16 00:00:00
5 | EMP 5 | Employee 5 |  |  | 2012-11-17 00:00:00 | 1200 | DTC | MASON | ------- | 2008-12-27 00:00:00 | 2014-01-13 00:00:00
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 10 - Table 2

HILA-Ex esults |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume total ('000 hl) | 4709.974397759946 | -516.247892 | 0 | 508.6576734999695 | 4702.384179259916 | -0.001611520118589227 | 0.1212901396410436
Beer volume ('000 hl) | 1888.452469340004 | -421.8964456699998 | 0 | 242.8946176999953 | 1709.450641369999 | -0.09478757388718606 | 0.1656224609082169
CSD volume ('000 hl) | 2821.521928419943 | -94.35144633000019 | 0 | 265.7630557999731 | 2992.933537889916 | 0.06075147165911399 | 0.09745010718813149
Net revenue | 438.278 | -103.639 | -37.85600123065217 | 58.57300123065217 | 355.356 | -0.1891995491446069 | 0.17503339787249
Net revenue/hl | 93.05315973871198 | -13.25801822426551 | -8.05038461077209 | 3.824568454154559 | 75.56932535782894 | -0.1878908188607099 | 0.04792984111021523
[NAME] | -290.65 | 69.621 | 25.1099479273807 | -36.11394792738074 | -232.033 | -0.2016755547909856 | 0.1633900887547821
[NAME]/hl | -61.70946494703506 | 9.00478816460209 | 5.339833363281821 | -1.97884930238196 | -49.34369272153312 | -0.2003869622936356 | 0.03754599066323335
Gross profit | 147.628 | -34.01800000000001 | -12.74605330327147 | 22.45905330327143 | 123.323 | -0.164636789768879 | 0.1976855321122386
Gross margin | 0.3368364371471989 |  | 0 | 0 | 0.347040714100789 | 100 | 70
SG&A excl. deprec.&amort. | -239.176 | 67.547 | 19.55680226780214 | -21.5458022678021 | -173.618 | -0.2740994079673547 | 0.1255370728012288
SG&A deprec.&amort. | -32.665 | 7.051 | 2.730209801931972 | -2.674209801931974 | -25.558 | -0.2175723251186285 | 0.1044042243277885
SG&A total | -271.841 | 74.598 | 22.2870120697341 | -24.22001206973408 | -199.176 | -0.2673069919548561 | 0.1227927585249366
Other operating income/expenses | 2.262 | -2.011 | 0.2994932636480065 | -2.608493263648007 | -2.058 | nm | nm
Normalized EBIT | -121.951 | 38.56899999999998 | 9.840452030110644 | -4.36945203011065 | -77.91100000000002 | 0.3611286500315698 | -0.05240282111379736
Normalized EBIT margin | -0.2782503342627281 |  | 0 | 0 | -0.2192477402942402 | 590 | 260
Normalized EBITDA | -67.65700000000001 | 29.319 | 5.349907486656122 | -3.464907486656108 | -36.453 | 0.4612087441063011 | -0.09037788843069818
Normalized EBITDA margin | -0.1543700573608532 |  | 0 | 0 | -0.1025816364434539 | 520 | 80
Spreadsheet: 543692d1508513582-sub-total-how-to-get-customer-name-and-other-text-columns-subtotal_question
Sheet: Sub Total

Customer | Customer Name | Rep | Region | Invoice | Invoice Date | Invoice Balance | Past due
200060 | Customer 1 | MS | NA | 1600000391 | 2017-06-30 00:00:00 | 235.08 | 0
200060 | Customer 1 | MS | NA | 1600000420 | 2017-07-31 00:00:00 | 530.14 | 0
200060 | Customer 1 | MS | NA |  |  | 113639.72 | 0
200065 | Customer 2 | MS | 1516 | 97022624 | 2017-10-04 00:00:00 | 3575.72 | 3575.72
200065 | Customer 2 |  |  |  |  | 3575.72 | 3575.72
200069 | Customer 3 | MS |  | 1400001036 | 2015-12-12 00:00:00 | -7418.46 | 0
200069 | Customer 3 | MS |  | 1400001530 | 2016-06-15 00:00:00 | -1097.46 | 0
200069 | Customer 3 | MS | 1516 | 97022046 | 2017-09-18 00:00:00 | 185715 | 185715
200069 | Customer 3 | MS | 1516 | 97022047 | 2017-09-18 00:00:00 | 715016.88 | 715016.88
200069 | Customer 3 | MS | 1516 | 97022049 | 2017-09-18 00:00:00 | 206990.83 | 206990.83
200069 | Customer 3 | MS | 1516 | 97022051 | 2017-09-18 00:00:00 | 1360.28 | 1360.28
200069 | Customer 3 | MS | 1516 | 97022054 | 2017-09-18 00:00:00 | 36592.98 | 36592.98
200069 | Customer 3 | MS | 1516 | 97022080 | 2017-09-19 00:00:00 | 1784.16 | 1784.16
200069 | Customer 3 | MS | 1516 | 97022810 | 2017-10-13 00:00:00 | 1489.51 | 1489.51
200069 | Customer 3 | MS | 1516 | 97022897 | 2017-10-17 00:00:00 | 185715 | 185715
200069 | Customer 3 | MS | 1516 | 97022898 | 2017-10-17 00:00:00 | 715016.88 | 715016.88
200069 | Customer 3 | MS | 1516 | 97022899 | 2017-10-17 00:00:00 | 206990.83 | 206990.83
200069 | Customer 3 | MS | 1516 | 97022900 | 2017-10-17 00:00:00 | 51868.36 | 51868.36
200069 | Customer 3 |  |  |  |  | 2300024.79 | 2308540.71
Spreadsheet: 127403d1320338115-help-when-vlookups-just-arent-enough-data-test-sheet
Sheet: What it should look like

Item ID Number | Activity Description | Project X Link
0100-100A | Activity 1
0100-100B | Activity 2 | 00LCC/23[B], 2900/078[A]
0100-100C | Activity 3
0100-100D | Activity 4
0100-101A | Activity 5
0100-101B | Activity 6
0100-101C | Activity 7
0100-101D | Activity 8
0200-074A | Activity 9 | 00LCC/24[A]
0200-074B | Activity 10
0200-074C | Activity 11
0200-074D | Activity 12
0200-075A | Activity 13 | 00LCC/24[A], 0500/002[B]
0200-075B | Activity 14
1100-392A | Activity 15
1100-392B | Activity 16
1100-392C | Activity 17
1100-392D | Activity 18 | 1100/010[E]
1100-395A | Activity 19
1100-395B | Activity 20
1100-395C | Activity 21 | 2900/077[A]
1100-395D | Activity 22
1112-102A | Activity 23 | 2900/079[A]
1112-102B | Activity 24 | 1100/010[D]
1112-102C | Activity 25 | 1100/010[D], 5000/052[C]
1112-102D | Activity 26 | 0500/002[A]
1300-305A | Activity 27 | 00LCC/02[A]
1300-305B | Activity 28
1300-305C | Activity 29
1300-305D | Activity 30
1300-395A | Activity 31 | 00LCC/03[C]
1300-395B | Activity 32
1300-395C | Activity 33
1300-395D | Activity 34
5000-234A | Activity 35 | 00LCC/23[A]
5000-234B | Activity 36
5000-234C | Activity 37
5000-234D | Activity 38
5100105A | Activity 39
5100105B | Activity 40
5100105C | Activity 41 | 0500/002[B]
0600105A | Activity 42 | 00LCC/24[A]
0600105B | Activity 43
Spreadsheet: 546337d1509992157-problem-with-solver-maxsharpe
Sheet: max sharpe (3)

Asset | Volat | Rend | Pesi
EMTS LYX GLOBAL BONDS | 0.02687 | 0.06689 | 0.3302777262969326
Old Mut [NAME] Abs Ret | 0.03751 | 0.08129 | 0.233376372024032
Nordea-1 Stable Ret BP Acc | 0.03399 | 0.07069 | 0.1959044068419687
Pimco Income Hdg | 0.0318 | 0.0751 | 0.2404414948370666
 |  |  |  |  | 2.9e-06 | 7e-07 | 7e-07 | 1.7e-06
 |  |  |  |  | 7e-07 | 5.6e-06 | 1.3e-06 | 0
 |  |  |  |  | 7e-07 | 1.3e-06 | 4.6e-06 | 1.1e-06
 |  |  |  |  | 1.7e-06 | 0 | 1.1e-06 | 4e-06
Media
varianza
SD
[NAME]
fattore molt | 2.7
[NAME]
Spreadsheet: 690704d1597241818-remove-duplication-in-possible-combination-of-3-digits-combinations-with-3-digits
Sheet: Sheet1

Combo Sheet
Chosen No |  | 1st Combo |  | 2nd Combo |  | 3rd Combo |  | 4th Combo |  | 5th Combo |  | 6th Combo |  | Helper
456
454
985
432
123
363
454
454
363
333
445
Spreadsheet: 165670d1341316092-vlookup-multiple-return-values-in-same-cell-vlookup-multiple-return-values-in-same-cell
Sheet: Sheet1

Result
Caltex SA | [NAME]
Total SA | [NAME]
Data
Caltex SA | [NAME]
Caltex SA | [NAME]
Caltex SA | [NAME]
Caltex SA | [NAME]
Caltex SA | Clive
Total SA | Marius
Total SA | Hennie
Total SA | justin
Total SA | [NAME]
Total SA | Claudia
Spreadsheet: 68461d1269000291-inserting-rows-per-new-entry-test23-1-
Sheet: Sheet1 (2)

 | Name | Age | Location | Student # | Team | Color | Animal |  |  | Name | Age | Location | Student # | Team | Color | Animal
 | Eagle | 25 | Beach | 11111 | Fire | Red | Tiger |  |  |  |  |  |  | Fire | Red | Tiger
 | [NAME] | 25 | Town | 22222 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 | Pao | 23 | Office | 33333 | Water | Blue | Shark |  |  |  |  |  |  | Water | Blue | Shark
 | Carol | 25 | Airplane | 44444 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 | [NAME] | 25 | Beach | 55555 | Earth | [NAME] | Elephant |  |  |  |  |  |  | Earth | [NAME] | Elephant
 | Von | 22 | Office | 66666 | Earth | [NAME] | Elephant |  |  |  |  |  |  | Earth | [NAME] | Elephant
 |  |  |  |  | Earth | [NAME] | Elephant |  |  |  |  |  |  | Earth | [NAME] | Elephant
 |  |  |  |  | Earth | [NAME] | Elephant |  |  |  |  |  |  | Earth | [NAME] | Elephant
 |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Wind | White | [NAME] |  |  |  |  |  |  | Wind | White | [NAME]
 |  |  |  |  | Wind | White | [NAME] |  |  |  |  |  |  | Wind | White | [NAME]
 |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Heart | Pink | [NAME] |  |  |  |  |  |  | Heart | Pink | [NAME]
 |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Sand | Black | Bird |  |  |  |  |  |  | Sand | Black | Bird
 |  |  |  |  | Sand | Black | Bird |  |  |  |  |  |  | Sand | Black | Bird
 |  |  |  |  | Sand | Black | Bird |  |  |  |  |  |  | Sand | Black | Bird
Spreadsheet: 05b19c25-55b8-4c6d-843a-98d8d65a4555
Sheet: SOC

2010 Standard Industry Classification Major Groups
Each occupation in the SOC is placed within one of these 23 major groups:
11-0000 Management Occupations
13-0000 Business and Financial Operations Occupations
15-0000 Computer and Mathematical Occupations
17-0000 Architecture and Engineering Occupations
19-0000 Life, Physical, and Social Science Occupations
21-0000 Community and Social Services Occupations
23-0000 Legal Occupations
25-0000 Education, [NAME], and [NAME]
27-0000 Arts, Design, Entertainment, Sports, and Media Occupations
29-0000 Healthcare Practitioners and Technical Occupations
31-0000 Healthcare Support Occupations
33-0000 Protective Service Occupations
35-0000 Food Preparation and Serving Related Occupations
37-0000 Building and Grounds Cleaning and Maintenance Occupations
39-0000 Personal Care and Service Occupations
41-0000 Sales and Related Occupations
43-0000 Office and Administrative Support Occupations
45-0000 Farming, Fishing, and Forestry Occupations
47-0000 Construction and Extraction Occupations
49-0000 Installation, [NAME], and Repair Occupations
51-0000 Production Occupations
53-0000 Transportation and Material Moving Occupations
55-0000 Military Specific Occupations