tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216639d1361828964-if-condition-to-date-cells-with-concatenation-of-two-text-cells-results
Sheet: Results

 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 852705d1702653203-need-formula-for-price-comparison-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORMULA REQUIRED |  |  | FORMULA REQUIRED |  |  | FORMULA REQUIRED
[NAME] |  |  | VENDOR 1 |  |  |  | VENDOR 2 |  |  |  | VENDOR 3 |  |  |  |  | VENDOR 4 |  |  |  | VENDOR 5 |  |  |  | 1st Option |  |  | 2nd Option |  |  | 3rd Option
[NAME] | REQ. QTY |  | MIN RATE | TOTAL | TAX | AVAILABILITY | MIN RATE | TOTAL | TAX | AVAILABILITY | MIN RATE | DISC. | TOTAL | TAX | AVAILABILITY | MIN RATE | TOTAL | TAX | AVAILABILITY | MIN RATE | TOTAL | TAX | AVAILABILITY | MIN RATE | AVAILABILITY | VENDOR | MIN RATE | AVAILABILITY | VENDOR | MIN RATE | AVAILABILITY | VENDOR
A | 10 |  | 97 |  | 0 | READY STOCK | 0 |  | 0 | 1 WEEK | 102 | 0.1 |  | 0 | 3~4 DAYS | 0 |  | 0 | NOT QUOTED | 105 |  | 0 | NOT QUOTED
B | 25 |  | 102 |  | 0 | 2~3 DAYS | 100 |  | 0 | READY STOCK | 95 | 0.06 |  | 0 | READY STOCK | 110 |  | 0 | READY STOCK | 102 |  | 0 | READY STOCK
Spreadsheet: 23340d1212749106-returning-multiple-values-abc
Sheet: Sheet1

1 | jan
1 | feb
1 | [NAME]
1 | apr
2 | may
2 | jun
2 | jul
2 | aug
2 | sep
3 | oct
3 | nov
3 | dec
3 | jan
3 | feb
4 | [NAME]
4 | apr
4 | may
4 | jun
4 | jul
Spreadsheet: 858457d1707147040-counting-the-controls-passed-failed-sample_file
Sheet: OutPut

Month | Jan'24 |  |  | Feb'24
 | Pass | Fail | Not Completed | Pass | Fail | Not Completed
[NAME] | 2 |  |  | 2
User 2 |  | 2 |  |  | 2
User 3 | 1 |  | 1 | 1 |  | 1
Spreadsheet: 817536d1676305968-locking-cell-after-input-triggered-result-example
Sheet: Sheet1

19th Jan 23 | 20th Jan 23 | 21st Jan 23 | 22nd Jan 23 | Approved | Print Ready | PDFA Ready
 |  | pdfa ready
 |  | print ready | approved
 |  |  | v1 proofed
 |  |  |  |  |  |  |  | Approved
 |  |  |  |  |  |  |  | Print Ready
 |  |  |  |  |  |  |  | PDFA Ready
Spreadsheet: 347c914e-2da4-4a08-bea7-be2f709def9b
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
LPSBF | Test | LPSBF | Lipase, Body Fluid | Lipase, BF | Colorimetric Rate Reaction |  |  |  | 1 | mL | Container/Tube: Sterile container [NAME]: 1 mL Collection Instructions: Centrifuge to remove any cellular material. Additional Information: Indicate specimen source. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Spinal fluid | Not applicable | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 83690 |  |  |  |  | Rochester
LPSBF | [NAME] | BODYFL | Body Fluid |  |  |  | Frozen | 90 days
LPSBF | Order Question | FLD7 | [NAME] |  | Plain Text
LPSBF | Result | LPBF | Lipase, BF | Lipase, BF | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 15212-4 | Triacylglycerol lipase:CCnc:Pt:Body fld:Qn:
LPSBF | Result | FLD7 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6 | Fluid:Type:Pt:Body fld:Nom:
Spreadsheet: 113618d1309457757-return-value-once-sum-is-greater-than-a-certain-number-demo
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | When the sum of the row goes above 1 it returns the corresponding value in row A
0.1 | 0.05 | 0.2 | 0.4 | 0.15 | 0.1 | 0.5 | 0.1 | 0.15 | 0.2 | 0.1 | 0.2 |  | 6
0.05 | 0.2 | 0.4 | 0.15 | 0.1 | 0.5 | 0.1 | 0.15 | 0.2 | 0.1 | 0.2 | 0.2 |  | 7
0.2 | 0.4 | 0.15 | 0.1 | 0.5 | 0.1 | 0.15 | 0.2 | 0.1 | 0.2 | 0.3 | 0.1 |  | 5
Spreadsheet: sally_beck__33870__Appendices November
Sheet: Appendix 1

Broker quotes for end of November 2000 |  |  | GBP/MWh | GBP/MWh |  | GBP/MWh | GBP/MWh |  | PV Volume MWH | Over / (Under) valued
 |  |  | Bid | Offer | Mid | Enron Curve | Difference | % Diff |  | GBP
PH Energy Analysts | Wint 00 | Baseload | 21.3 | 21.45 |  | 21.39 |  |  | -2176592
PH Energy Analysts | Summ 01 | Baseload | 18 | 18.1 |  | 18.07 |  |  | 1550337
PH Energy Analysts | Wint 01 | Baseload | 21.7 | 21.8 |  | 21.74 |  |  | -364303
PH Energy Analysts | Summ 02 | Baseload | 17.5 | 17.7 |  | 17.59 |  |  | -1328347
PH Energy Analysts | Wint 02 | Baseload | 21.45 | 21.7 |  | 21.5 |  |  | -1169597
PH Energy Analysts | Summ 03 | Baseload | 17.5 | 17.6 |  | 17.53 |  |  | -1708848
 |  |  |  |  |  |  |  | Total
Spreadsheet: 230352d1366739946-drop-down-list-window-vlookup-table-for-extra-charge
Sheet: Sheet1

Customer No | Charge | Plus Extra |  |  |  |  | CustList | Extra %
Customer1 |  |  | <<Look at this formula |  |  |  | Customer1 | 0.1 | << This is the Lookup List
Customer2 |  |  |  |  |  |  | Customer2 | 0 | <<To see who gets charged etra
Customer3 |  |  |  |  |  |  | Customer3 | 0.05
Customer4 |  |  |  |  |  |  | Customer4 | 0.2
Customer5 |  |  |  |  |  |  | Customer5 | 0.02
Customer1
Customer2
Customer3
Customer4
Customer5
Spreadsheet: 192525d1352448266-autoselection-on-a-combo-box-auto-select-on-combo-box
Sheet: Sheet1

2012-07-09 00:00:00 | morrisions |  | food shopping
2012-07-10 00:00:00 | paypal |  | Electrical
2012-08-09 00:00:00 | amazon |  | Online shopping
2012-08-09 00:00:00 | morrisons fuel |  | Feul
2012-08-22 00:00:00 | b&Q |  | Tools
2012-08-22 00:00:00 | morrisions feul |  | Feul
2012-09-24 00:00:00 | paypal |  | Ebay
2012-09-25 00:00:00 | PC world |  | Electrical
2012-09-27 00:00:00
2012-10-01 00:00:00
2012-10-02 00:00:00
2012-10-03 00:00:00
Spreadsheet: 36795d1234744631-copy-formula-from-top-row-skeleton-scores
Sheet: Main data

Scores
 | Rank | Avg | Total | Week 1 |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  | Week 5 |  |  |  |  |  |  | Week 6 |  |  |  |  |  |  | Week 6 |  |  |  |  |  |  | Week 7 |  |  |  |  |  |  | Week 8 |  |  |  |  |  |  | Week 9 |  |  |  |  |  |  | Week 10
 |  |  |  | 2009-01-28 00:00:00
Group 1
Name 1 |  |  |  | 1
Name 2 |  |  |  | 2
Name 3 |  |  |  | 3
Name 4 |  |  |  | 4
Name 5 |  |  |  | 5
Name 6 |  |  |  | 6
Name 7 |  |  |  | 7
Name 8 |  |  |  | 8
Name 9 |  |  |  | 9
Name 10 |  |  |  | 10
Name 11 |  |  |  | 1
Group 2
Name 12 |  |  |  | 2
Name 13 |  |  |  | 3
Name 14 |  |  |  | 4
Name 15 |  |  |  | 5
Name 16 |  |  |  | 6
Name 17 |  |  |  | 7
Name 18 |  |  |  | 8
Name 19 |  |  |  | 9
Name 20 |  |  |  | 10
Name 21 |  |  |  | 2
Group 3
Name 22 |  |  |  | 1
Name 23 |  |  |  | 2
Name 24 |  |  |  | 3
Name 25 |  |  |  | 4
Name 26 |  |  |  | 5
Name 27 |  |  |  | 6
Name 28 |  |  |  | 3
Name 29 |  |  |  | 4
Name 30 |  |  |  | 5
Name 31 |  |  |  | 6
Name 32 |  |  |  | 7
Name 33 |  |  |  | 8
Name 34 |  |  |  | 9
Group 4
Name 35 |  |  |  | 1
Name 36 |  |  |  | 2
Name 37 |  |  |  | 3
Name 38 |  |  |  | 4
Name 39 |  |  |  | 5
Name 40 |  |  |  | 6
Group 5
Name 41 |  |  |  | 1
Name 42 |  |  |  | 2
Name 43 |  |  |  | 3
Name 44 |  |  |  | 4
Group 6
Name 45 |  |  |  | 1
Name 46 |  |  |  | 2
Name 47 |  |  |  | 3
Spreadsheet: 439cf837-bd60-4395-89e4-35aee7eaa768
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Financial Report
 |  | All Manufacturing: U.S. Total
 |  | Not Seasonally Adjusted Net Sales, Receipts, and Operating Revenues [Millions of Dollars]
 |  | Period: 2000 to 2013
 |  | Data Extracted on: August 29, 2014 (8:27 am)
Period | Value
Q1-2000
Q2-2000
Q3-2000
Q4-2000 | 1128790
Q1-2001 | 1082233
Q2-2001 | 1116597
Q3-2001 | 1062443
Q4-2001 | 1033734
Q1-2002 | 994073
Q2-2002 | 1071574
Q3-2002 | 1068667
Q4-2002 | 1082128
Q1-2003 | 1072017
Q2-2003 | 1096910
Q3-2003 | 1109436
Q4-2003 | 1118800
Q1-2004 | 1145872
Q2-2004 | 1248717
Q3-2004 | 1250976
Q4-2004 | 1288495
Q1-2005 | 1258442
Q2-2005 | 1352179
Q3-2005 | 1384246
Q4-2005 | 1416600
Q1-2006 | 1397414
Q2-2006 | 1485624
Q3-2006 | 1467143
Q4-2006 | 1432485
Q1-2007 | 1405836
Q2-2007 | 1526484
Q3-2007 | 1539399
Q4-2007 | 1588312
Q1-2008 | 1566418
Q2-2008 | 1724172
Q3-2008 | 1682270
Q4-2008 | 1401261
Q1-2009 | 1196693
Q2-2009 | 1253821
Q3-2009 | 1305867
Q4-2009 | 1353446
Q1-2010 | 1349210
Q2-2010 | 1461717
Q3-2010 | 1463507
Q4-2010 | 1481530
Q1-2011 | 1532484
Q2-2011 | 1657405
Q3-2011 | 1650561
Q4-2011 | 1645072
Q1-2012 | 1648177
Q2-2012 | 1689523
Q3-2012 | 1656755
Q4-2012 | 1673633
Q1-2013 | 1626424
Q2-2013 | 1704304
Q3-2013 | 1704936
Q4-2013 | 1709417
Spreadsheet: 718535d1613170250-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 22

 |  |  | Date | 2021-02-22 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 10:00:00 | 22:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 013b6081-6d33-444f-913f-e1c989b88ce1
Sheet: Instructions

 | Recipient Report Instructions |  |  |  | Version: | 1.8
 | Instructions:
 | You are submitting a report for a Grant or Loan award.
 | Instruction | Required Worksheets
 | If you are a Prime Recipient who is submitting a report or reports on behalf of your Sub Recipient, you must fill out these worksheets (see the tabs at the bottom of the screen): | Prime Recipient
 |  | Sub Recipients
 |  | Vendors (optional)
 | If you are a Prime Recipient who is not submitting a report or reports on behalf of your Sub Recipient, you must fill out these worksheets (see the tabs at the bottom of the screen): | Prime Recipient
 |  | Vendors (optional)
 | If you are a Sub Recipient who is submitting a report, you must fill out these worksheets (see the tabs at the bottom of the screen):  NOTE: For Sub Recipient reporting for self, the DUNS numbers populated in the "Sub Recipient DUNS Number" field on the "Sub Recipients" tab must all be the same regardless of the Sub Award Numbers. | Sub Recipients
 |  | Vendors (optional)
 | Note: If entering Sub Recipients and/or Vendors in your report, you must enter one Sub Recipient Award or Vendor per numbered row. Do not leave a blank row between entries.
 | Notes
 | Potential Question |  | Answer
 | Not all of my text is showing up when I enter values a narrative field. For example, when entering text for the Project Description field. |  | This is a limitation of Excel. Although each cell holds up to 32,767 characters, Excel only displays 1,024 characters in the cell itself. To view all of the text you've entered for a given field, click on the cell in question and the text will display in the formula bar at the top of the screen.
 | When I try to select a value from a drop-down menu, the text is too small to read. How to I make it bigger? |  | Check to make sure you're viewing the workbook at 100% zoom. If your zoom is set to less than 100%, this can cause the text in the drop-down menus to appear very small.
 | I don't know which CFDA to use. |  | A list of CFDA Codes applicable to Recovery Act reporting can be found on the Downloads page at FederalReporting.gov. You can also access this list via https://www.cfda.gov/index?s=program&tab=searchresults&mode=list&_filt=rec&cck=1&au=&ck=.
 | I'm not sure what each of the data elements mean. |  | You can either click on each cell for instructional text or reference the Data Model document published on [NAME]
 | I have more than 400 Sub Recipients or Vendors to add, but the spreadsheet looks like it is limited to 400. |  | You can continue to add additional Sub Recipients and Vendors beyond the #400 line provided for you, however the special formatting and data validations which are provided for the first 400 Sub Recipients or Vendor entries will not be present. This is done to keep the file size of the template from growing excessievly large. Data validation will be performed once your report is uploaded on FederalReporting.gov.
Spreadsheet: 172473d1344235852-multiple-drop-down-list-book1
Sheet: Sheet3

Range | 1 | 2
 | Sun | Jan
 | Mon | Feb
 | Tue | Mar
 | Wed | Apr
 | Thu | May
 | Fri | Jun
 | Sat | Jul
 |  | Aug
 |  | Sep
 |  | Oct
 |  | Nov
 |  | Dec
Spreadsheet: 878159d1725188282-consolidation-of-marks-excel-help
Sheet: Consolidation

 |  | Level | Name | Mark
 |  | A1
 |  | A2
 |  | A5
 |  | A7
 |  | F1
 |  | F2
 |  | F3
 |  | F4
 |  | F6
 |  | F9
Spreadsheet: 40036d1238356834-countif-sin90-report
Sheet: Summary

Team 1 | Jobs Closed | Sin 7 | % | Sin 90 | % | SOS | % | New Installs | % | Former | % | Upgrades | %
ASGA001032 | 192
ASGA001053 | 196
ASGA001066 | 179
ASGA001129 | 139
ASGA001151 | 32
ASGA001177 | 120
ASGA001180 | 54
ASGA001183 | 147
ASGA001188 | 79
ASGA001190 | 226
ASGA001204 | 189
ASGA001214 | 131
ASGA001216 | 140
ASGA001236 | 33
34
148
114
6
Spreadsheet: 586884d1534709311-formula-add-the-largest-sequence-of-only-consecutive-positive-numbers-from-a4-a20-sum-of-largest-run-of-pos-numbers-using-helper
Sheet: Sheet1

Numbers | Helper |  | Answer
134
544
-41
-97
434
789
344
871
-45
97
59
91
Spreadsheet: phillip_m_love__30154__9903_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 32341331 | 51294159
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 20542796 | 33990434
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 52884127 | 85284593
 | Purchases:
6 |  | 3rd Party / Inter Enron | -31298286 | -48084677
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -21837526 | -35920688
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 288145 | 450360
 | Total Purchases: |  | -52847667 | -83555005
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 60725 | 91517
14 |  | Cash Out | -76114 | -116426.2506987598
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -15389 | -24909.25069875982
 | Storage:
17 |  | Injection (Sales to Stg) | 15222 | 21478
18 |  | W/D (Purchase from Stg) | -36293 | -54451
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -36293 | -54451
 | Total Storage: |  | -21071 | -32973
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | -288145 | -450360
 | Transport Expense:
24 |  | Commodity | 0 | -286994
25 |  | Demand | 0 | -2881984
 | Total Transport Expense: |  | 0 | -3168978
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 559245
31 |  | Prior Month Book Balance | 0 | 133064
 |  | Total MTM Income | 0 | 692309
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -1361513
34 |  | Originations | 0 | 203189
35 |  | Broker Fees | 0 | -13105
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 1610995
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 273537
 |  | TOTAL
Spreadsheet: 813512d1673830393-xirr-fail-cash-flows-alternate-between-positive-and-negative-sample-xirr-alternative_v2
Sheet: Sheet1

 | XIRR |  |  | <-- Since the cashflows are not consistent, I used the XIRR formula. However, I'm certain my IRR is not 232554%!
 | Total Cash inflows |  |  | My challenge is to create an Excel formula that gives me a correct IRR for the cashflows in this sample
 | Total Cash outflows
 | Net cashflow
 |  |  | 2022-12-31 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00
 |  | Cash flow | -595444.7990000006 | 0 | 0 | 0 | 0 | 4011719.831712753 | 4011719.831712753 | 3993507.720601642 | 3993507.720601642 | 969378.6338802048 | -542685.909480514 | -542685.909480514 | -1531200.536932863 | 1223967.212841158 | 724824.9926842048 | 721150.0169424198 | 218314.7089458418 | -1298674.001158807 | -2099642.583906689 | -2607444.57881063 | -2613645.440863275 | -1580593.395260599 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1565320.399075799 | 15876677.70528755 | 5292225.901762514
Spreadsheet: louise_kitchen__24093__NEWCO HEADCOUNT NAMES
Sheet: IT

IT Management |  | ok
[NAME] | [NAME]
Giselle James | Admin, Sr. | 2
[NAME] | Consultant, Tech
[NAME] | Consultant, Tech
[NAME] "[NAME] | Consultant, Tech
[NAME] | Consultant, Tech
[NAME] | Consultant, Tech
[NAME] | Consultant, Tech
[NAME] | Consultant, Tech | 7
[NAME] | Director
[NAME] | Director
Iain [NAME] | Director
[NAME] | Director
[NAME] | Director
[NAME] | Director
[NAME] | Director
Pablo Pissanetzky | Director
Ramesh [NAME] | Director
Stacey Ramsay | Director
[NAME] | Director | 11
Chip Brewer | Manager
[NAME] | Manager
[NAME] | Manager
[NAME] | Manager
[NAME] | Manager
[NAME] | Manager
[NAME] | Manager
[NAME] | Manager
[NAME] | Manager
Mable Tang | Manager
[NAME] | Manager
[NAME] | Manager
Nilay Basu | Manager
[NAME] | Manager
[NAME] | Manager
Sundar Chitradurga | Manager | 16
[NAME] | Spec
[NAME] | Spec
Arun Balasundaram | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
Huan "Eddie" Zhang | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
Piyush [NAME] | Spec
Pylyp Motuzko | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
[NAME] | Spec
Sudheer Kannantha | Spec
[NAME] | Spec
Suvinay Sinha | Spec
Tuyet-Mai Nguyen | Spec
[NAME] | Spec
Vjayanand Gadhavi | Spec | 29
[NAME] | Sr. Director
[NAME] | Sr. Director
[NAME] | Sr. Director
[NAME] | Sr. Director
[NAME] | Sr. Director
[NAME] | Sr. Director
[NAME] | Sr. Director
[NAME] | Sr. Director | 8
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
Bhupesh Nagar | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
Jaikishore Bharathi | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
Moyez [NAME] | Sr. Spec
[NAME] | Sr. Spec
Narasim Kasaru | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
Rennu Varghese | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
[NAME] | Sr. Spec
Zhuoming [NAME] | Sr. Spec | 60
[NAME] | Staff
[NAME] | Staff | 2
[NAME] | Tech, Consultant
[NAME] | Tech, Consultant
[NAME] | Tech, Consultant | 3
[NAME] | Technoligist | 1
[NAME] | Vice Pres | 1
 | TOTAL
Spreadsheet: 758648d1638982532-sumif-get-value-from-different-row-example
Sheet: Planif_Prod (2)

 |  |  | Machine | S1
 |  |  | [NAME] | 57
 |  |  | Auger 3 | 55
 |  |  |  | Prévisions
Produit | MP | Ligne Prod | Data Stream | S1
1000 | MR1000 | [NAME] | Hist / Fcst | 20
 |  |  | [NAME] | 45
 |  |  | Ajustement
 |  |  | Production réelle | 45
 |  |  | Stock projeté
1600 | MR1600 | [NAME] | Hist / Fcst | 20
 |  |  | [NAME] | 12
 |  |  | Ajustement
 |  |  | Production réelle | 12
 |  |  | Stock projeté
34 | MR11245 | Auger 3 | Hist / Fcst | 20
 |  |  | [NAME] | 12
 |  |  | Ajustement
 |  |  | Production réelle | 30
 |  |  | Stock projeté
45 | MR1189 | Auger 3 | Hist / Fcst | 20
 |  |  | [NAME] | 12
 |  |  | Ajustement
 |  |  | Production réelle | 25
 |  |  | Stock projeté
Spreadsheet: 850724d1701111630-alternative-to-groupby-alternative-to-groupby-unique-and-sumifs
Sheet: Sheet1

 | Dynamic Array Output |  |  |  | Desired Result
 |  | A | 10 |  | North | A | 24 |  |  |  | A
 | South | A | 11 |  | South | A | 26 |  |  | South | A
 | East | A | 12 |  | East | A | 28 |  |  | East | A
 | West | A | 13 |  | West | A | 33 |  |  | West | A
 | North | A | 14 |  | North | B | 52 |  |  | North | B
 | South | A | 15 |  | South | B | 64 |  |  | South | B
 | East | A | 16 |  | East | B | 71 |  |  | East | B
 | West | A | 20 |  | West | B | 78 |  |  | West | B
 | North | B | 22
 | South | B | 24
 | East | B | 26
 | West | B | 28
 | North | B | 30
 | South | B | 40
 | East | B | 45
 | West | B | 50
Spreadsheet: 58930d1259206421-counting-orders-book2-1-
Sheet: Profits

Item | Quantity | Quantity In Inventory | Quantity In Mart | Total Cost | Cost Per Unit | Amount Sold | Price Sold At | Total Revenue | Profits Per Item | Amount Of Supply Missing
Cookies | 36 | 14 | 3 | 9.36 |  |  | 1
Cheez-It | 36 | 20 | 2 | 8.19 |  |  | 1
Lays Pack | 50 | 8 | 6 | 10.99 |  |  | 1
Poland Spring | 32 | 4 | 6 | 4.49 |  |  | 1
 | Total Profits |  |  | Total Cost |  |  | Total [NAME]
 |  |  |  | Total Stolen