tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153710d1336022173-how-do-i-sumif-a-date-range-using-rows-not-columns-cashflow-statement
Sheet: Monthly

 |  | Opening Balance | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | Closing Balance
 | Cash on Hand (Beginning of month)
 | CASH RECEIPTS
 | Cash Sales
 | EFTPOS Sales
 | TOTAL CASH RECEIPTS
 | CASH PAID OUT
 | Tonkin
 | Decosti
 | Discount Packaging
 | Coca Cola Amatil
 | Juice
 | Chicken
 | Fresh Vegetables
 | Other (Specify)
 | Other (Specify)
 | Other (Specify)
 | Wages
 | Rent
 | Repairs & maintenance
 | Advertising
 | Telephone
 | Utilities (Electricity)
 | Utilities (Gas)
 | Utilities (Water/Waste)
 | Miscellaneous (Specify)
 | Miscellaneous (Specify)
 | SUBTOTAL
 | [NAME]'s Withdrawal
 | TOTAL CASH PAID OUT
 | CASH POSITION (End of month)
Spreadsheet: joe_parks__15064__BridgeDPR0625
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1495.384188699996 | 6650.384188699996 | 11941.3841887
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1495.384188699996 | 6650.384188699996 | 11941.3841887
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 686861d1594836761-xlookup-boolean-fail-xlookup-example
Sheet: Lookup

Code | Level Start | Start date | End date
AAA8790O | L1 | 2020-10-31 00:00:00 | 2021-08-10 00:00:00
AFSTSS000 | L1 | 2020-11-01 00:00:00 | 2021-08-11 00:00:00
DTDHDJD0 | L1 | 2020-11-02 00:00:00 | 2021-08-12 00:00:00
FSFSGSG0 | L1 | 2020-11-03 00:00:00 | 2021-08-13 00:00:00
DPD20005 | Higher | 2020-11-04 00:00:00 | 2021-08-14 00:00:00
DD14DSD7 | L1 | 2020-11-05 00:00:00 | 2021-08-15 00:00:00
GGDG0000 | L1 | 2020-11-06 00:00:00 | 2021-08-16 00:00:00
DD14DSD7 | L2 | 2020-11-07 00:00:00 | 2021-08-17 00:00:00
DD28DSD7 | L3 | 2020-11-08 00:00:00 | 2021-08-18 00:00:00
DD28DSD7 | [NAME] | 2020-11-09 00:00:00 | 2021-08-19 00:00:00
FDGDGGD | L1 | 2020-11-10 00:00:00 | 2021-08-20 00:00:00
GDGHDD0 | L1 | 2020-11-11 00:00:00 | 2021-08-21 00:00:00
Spreadsheet: 109524d1306353237-excel-randomize-text-example2
Sheet: Sheet1

Items: | Gender |  | Hobby | Hobby2 |  | Haircolor1 | Haircolor2
 | I am a man. |  | I like to drive in my car. | My hobby is driving in my car |  | I have black hair | My hair is black
 | I am a woman. |  | I like to go sailing. | I live to go sailing on my boat |  | I have white hair | My hair is white.
 |  |  | I like to draw. | I find my peace in drawing art
 |  |  | I like to drink a lot. | I just like to buy beer and drink all day
Product 1
Gender = man |  |  |  | dit is een standaard zin %%
Hobby = Drawing
Haircolor = Black
Product 2
Gender = Woman
Hobby = Sailing
Haircolor = White
Now we need to create 2 unique pieces of tekst for these 2 products. We need to say if it is a man or woman. We need to fill i a hobby and a haircolor. (1 of the 2 methods the way it was written.)
So we can get the following:
Product 1:
I am a man. I like to draw. My hair is black.
I am a man. I find my peace in drawing art. My hair is black.
product 2:
I am a woman. I like to go sailing. I have white hair.
I am a woman. I live to go sailing in my boat. My hair is white.
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk14

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 779869d1652161783-index-match-three-drop-down-criteria-index-match-three-drop-down-criteria-aligw
Sheet: Data Val

People | Event 1: | Event 2:
Person A | Column 7 | Column 7
Person B | Column 8 | Column 8
Person C | Column 9 | Column 9
Person D | Column 10 | Column 10
Person E | Column 11 | Column 11
Person F | Column 12 | Column 12
Person G | Column 13 | Column 13
Person H | Column 14 | Column 14
Person I
Person J
Person K
Person L
Spreadsheet: 829987d1684598245-formulas-question-for-cumulative-value-sumif
Sheet: Sheet1

Year | Value |  | "Total = $" & sumif(B2:B29,>year(today()),A2:A29)
2050
2049
2048
2047
2046
2045
2044
2043
2042
2041
2040
2039
2038
2037
2036
2035
2034
2033
2032
2031
2030
2029
2028
2027
2026
2025
2024
2023
Spreadsheet: 7cf1bb57-f5bb-4a8b-99e3-af77653a7fe6
Sheet: 1b. Questionnaire (cont)

ANNUAL REPORT FOR THE PERIOD ENDED: |  |  |  |  |  |  | p. 1b
 |  |  |  |  |  |  |  |  |  |  |  | GAAP
QUESTIONNAIRE (continued) |  |  |  |  |  |  |  |  |  |  |  | Mod. GAAP
 |  |  |  |  |  |  |  |  |  |  |  | SAP
 |  |  |  |  |  |  |  |  |  |  |  | Mod. SAP
7. | Has the company changed its plan of operation during the year? If so, provide a brief description and the date it was filed with the Department.  Attach additional sheets as necessary.
8. | Did the captive insurer have its board meeting in the State of South Carolina?
 | On what date did the captive insurer have its board meeting?
9. | Please select the method of accounting utilized by the captive insurer:
 | Is this the same method used by the captive in its last annual report filing?
10. | Have all assets been valued in accordance with GAAP or SAP as applicable? If no, provide explanation:
11. | Does the Captive's Independent CPA firm provide any services other than the Captive's annual audit to either the Captive or the Captive's Parent?
 | If Yes, please describe the services provided:
12. | Does the Approved Actuary who certifies the adequacy of the Captive's reserves as of year-end also compute the monthly or quarterly reserves for the Captive?
13. | Has the Captive changed either its Independent Auditor or Approved Actuary since the previous year?
 | If yes, what was the reason for the change?
14. | What is the largest "net" amount insured in any one risk:
 | Per occurrence? |  |  | Aggregate?
15. | Has the "net" aggregate increased over last year's?
 | If yes, by what amount?
 | Please provide the reason(s) for the increase:
16. | Have losses been discounted?
 | If yes, what interest rate was used:
 | What was the total amount of the discount:
17. | Were any of the assets of the company pledged as collateral at any time during the year?  (Ignore assets pledged as security for ceding insurers)
 | If yes, attach a description of the transactions as a supplement to this filing.
Spreadsheet: hunter_shively__12748__EnovateDPR0128
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | 202.4834610799983 | 60.53075130000239 | -64.77216996000307 | 320.1888979100012
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: 0eb12c28-1d3f-41d7-b77d-5717f00bc9da
Sheet: Fall 2015

Hamline University [NAME] for Fall 2015
 |  | 2015-09-09 00:00:00 | 2015-09-30 00:00:00 | 2015-10-28 00:00:00 | 2015-11-18 00:00:00 | 2015-12-12 00:00:00
4 credits | 4A | 9/9-12/12 |  |  |  | End of Term | 1 start
3 credits | 3A | 9/9-11/17 |  |  |  |  | 2 starts
3 credits | 3B |  | 9/30-12/12
2 credits | 2A | 9/9-10/27 |  |  |  |  | 3 starts
2 credits | 2B |  | 9/30-11/17
2 credits | 2C |  |  | 10/28-12/12
1 credit | 1A | 9/9-9/29 |  |  |  |  | 4 starts
1 credit | 1B |  | 9/30-10/27
1 credit | 1C |  |  | 10/28-11/17
1 credit | 1D |  |  |  | 11/18-12/12
 |  |  |  |  |  |  | 10 total starts
4 credits = | 14-15 class sessions
3 credits = | 10-12 class sessions
2 credits = | 7-8 class sessions
1 credit = | 3-5 class sessions
Spreadsheet: 42e4a3b4-aac3-4d15-8f0d-8c7fb6f01dd4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29
本省及び法務局管内別　訟務事件の実施件数（平成23年3月）
本          省  法 務 局 管 内 |  |  | 総　　　　　 数 |  |  | 単 独 及 び 下 級 庁 と 共 同 |  |  |  |  |  |  |  |  |  |  |  | 上　級　庁　と　共　同
 |  |  |  |  |  | 計 |  |  | 申 立 準 備 事 件 |  |  | 本　訴　事　件 |  |  | 本 訴 以 外 の 事 件 |  |  | 計 |  |  | 申 立 準 備 事 件 |  |  | 本　訴　事　件 |  |  | 本 訴 以 外 の 事 件
 |  |  | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済
 | 総数 |  | 1489 | 1817 | 12334 | 1393 | 1548 | 11059 | 340 | 321 | 325 | 702 | 832 | 9937 | 351 | 395 | 797 | 96 | 269 | 1275 | 0 | 2 | 7 | 86 | 253 | 1243 | 10 | 14 | 25
 | 本省 |  | 105 | 125 | 1307 | 105 | 125 | 1307 | 0 | 0 | 0 | 105 | 125 | 1210 | 0 | 0 | 97 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 札幌法務局管内 |  | 65 | 68 | 750 | 59 | 63 | 712 | 17 | 17 | 22 | 25 | 23 | 665 | 17 | 23 | 25 | 6 | 5 | 38 | 0 | 0 | 0 | 6 | 5 | 38 | 0 | 0 | 0
 | 仙台法務局管内 |  | 58 | 70 | 750 | 55 | 67 | 713 | 11 | 17 | 11 | 27 | 27 | 674 | 17 | 23 | 28 | 3 | 3 | 37 | 0 | 0 | 0 | 3 | 2 | 36 | 0 | 1 | 1
 | 東京法務局管内 |  | 467 | 539 | 3367 | 425 | 465 | 2874 | 83 | 70 | 80 | 227 | 287 | 2437 | 115 | 108 | 357 | 42 | 74 | 493 | 0 | 1 | 3 | 36 | 68 | 478 | 6 | 5 | 12
 | 名古屋法務局管内 |  | 130 | 148 | 1188 | 127 | 137 | 1103 | 23 | 31 | 14 | 60 | 59 | 1014 | 44 | 47 | 75 | 3 | 11 | 85 | 0 | 0 | 0 | 3 | 9 | 83 | 0 | 2 | 2
 | 大阪法務局管内 |  | 295 | 387 | 2058 | 275 | 340 | 1796 | 61 | 88 | 74 | 135 | 163 | 1613 | 79 | 89 | 109 | 20 | 47 | 262 | 0 | 0 | 3 | 20 | 44 | 257 | 0 | 3 | 2
 | 広島法務局管内 |  | 84 | 130 | 1035 | 75 | 105 | 879 | 20 | 16 | 13 | 35 | 54 | 842 | 20 | 35 | 24 | 9 | 25 | 156 | 0 | 1 | 1 | 8 | 23 | 152 | 1 | 1 | 3
 | 高松法務局管内 |  | 134 | 63 | 593 | 131 | 58 | 566 | 90 | 26 | 89 | 23 | 22 | 460 | 18 | 10 | 17 | 3 | 5 | 27 | 0 | 0 | 0 | 3 | 5 | 26 | 0 | 0 | 1
 | 福岡法務局管内 |  | 151 | 287 | 1286 | 141 | 188 | 1109 | 35 | 56 | 22 | 65 | 72 | 1022 | 41 | 60 | 65 | 10 | 99 | 177 | 0 | 0 | 0 | 7 | 97 | 173 | 3 | 2 | 4
Spreadsheet: 848742d1699383403-find-the-matching-range-in-column-excel1
Sheet: Feuil1

Date ("until…") | Position 1 | Position 2
2021-07-08 00:00:00 | 1000 | 1500
2022-07-06 00:00:00 | 2000 | 2500
2023-07-05 00:00:00 | 3000 | 3500
2024-07-04 00:00:00 | 4000 | 4500
 |  | [NAME] to find the corresponding amount, according to date in A12 and position in B12.
2022-10-14 00:00:00 | Position 1 | ?
 |  | The expected result is 3000 because date in A12 is higher or equal to A4 and lower than A5, and the criterion is Position 1
Spreadsheet: 81814d1281971381-data-validation-list-with-condition-data_validation-revised
Sheet: Sheet1

 | Regions | Firms
 | AS | Standard Chartered
 | AS | Tata
 | AS | TNT |  |  |  | Row Labels
 | EU | Toyota |  |  |  | AF
 | AS | UBS |  |  |  | Bain & Company
 | AS | Unilever |  |  |  | BASF
 | EU | UPS |  |  |  | Bayer
 | AS | Wipro |  |  |  | BayernLB
 | AS | World Bank |  |  |  | AS
 | DE | A.T. Kearney |  |  |  | Bertelsmann
 | DE | ABB |  |  |  | BKW
 | EU | Accenture |  |  |  | Standard Chartered
 | DE | adidas Group |  |  |  | Tata
 | DE | [NAME] |  |  |  | TNT
 | DE | Allianz |  |  |  | UBS
 | DE | Arthur D. Little |  |  |  | Unilever
 | DE | Audi |  |  |  | Wipro
 | DE | Auswärtiges Amt |  |  |  | World Bank
 | DE | AXA
 | AF | Bain & Company
 | AF | BASF
 | AF | Bayer
 | AF | BayernLB
 | DE | BCG
 | DE | [NAME]
 | AS | Bertelsmann
 | DE | [NAME]
 | AS | BKW
 | DE | BMW
 | DE | Boehringer Ingelheim
 | DE | Booz & Co.
Spreadsheet: 38157d1236274478-sorting-keep-surrounding-data-intact-sample
Sheet: Sheet1

Item # | Description | Vendor | Location | Comments | Net Cost | [NAME]
1 | Wood bench w/plaque | Better Lumber /Bench | TBD | See [NAME]60I | 835
 |  | Smithfield /Plaque |  | Plaque | 220
 |  |  |  | Shipping | 143
 |  |  |  | Total | 1198 | 1500
2 | Tree w/plaque | Gracie /Tree | TBD | See info sheet | 550
 |  | Smithfield /Plaque | TBD | [NAME]"       1 letter per SI | 362
 |  |  |  | Total | 912 | 1000
3 | Study Circle | [NAME] | Siena/SSU | See article | 20000 | 25000
Spreadsheet: 55162d1255303809-change-bacground-color-copy-of-tracking-board-clean
Sheet: TRACKING BOARD

 | CURRENT DATE:  Sept. 27, 2009 | 2009-10-10 00:00:00
 | CRITICAL CARE HOLD |  |  | LIFESTAR I | MOUNTAINS |  |  | VALLEY
 |  |  |  | N431UT |  | IN SERVICE
 | 10/11/2009@ 03:45 per PPC
 | TRAUMA |  |  | [NAME] | MOUNTAINS |  |  | VALLEY
 | SCC |  |  | [NAME] |  | IN SERVICE
 | CCM
 | CARDIAC
 |  |  |  | [NAME] | MOUNTAINS |  |  | VALLEY
 | VASCULAR
 |  |  |  | N408UT |  | IN SERVICE
 | THORACIC
 | PEDIATRIC
 |  |  |  | [NAME] | MOUNTAINS |  |  | VALLEY
 | [NAME]
 |  |  |  | N407UT |  | IN SERVICE
 | 1st MAINTENANCE
 | 2nd MAINTENANCE
 | MEDICAL
 | AVIATION
 | ADMIN
 | CREW
Spreadsheet: 96499531-1458-43a4-a707-9c94baaf76db
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Deutsche Post DHL - Interim Report H1 2010
January to June 2010
Net liquidity
€m | 31 Dec. 2009 | 30 June 2010
Non-current financial liabilities | 6699 | 6701
+ Current financial liabilities | 740 | 786
 | 7439 | 7487
- Cash and cash equivalents | 3064 | 2065
- Current financial assets | 1894 | 1671
- Long-term deposits1) | 120 | 120
- Positive fair value of non-current financial derivatives1) | 805 | 2284
 | 5883 | 6140
- Financial liabilities to [NAME] minority shareholders | 23 | 27
- Mandatory exchangeable [NAME]) | 2670 | 2732
- Collateral for the put option2) | 1200 | 1223
+ Net effect from measurement of Postbank derivatives3) | 647 | 2100
 | 3246 | 1882
Net liquidity (-)/net debt (+) | -1690 | -535
1) Reported in non-current financial assets in the balance sheet.
2) Reported in non-current financial liabilities in the balance sheet.
3) Reported in non-current financial assets and liabilities in the balance sheet.
Spreadsheet: 72163d1272893839-drag-down-a-formula-over-blank-cells-book4
Sheet: Sheet1

Date | Code |  | Date | Value |  | Date | Value
2002-01-01 00:00:00 | aa |  | 2002-01-01 00:00:00 |  |  | 2002-01-01 00:00:00 | 0
2002-01-02 00:00:00 |  |  | 2002-01-02 00:00:00 |  |  | 2002-01-02 00:00:00 | 2
2002-01-03 00:00:00 |  |  | 2002-01-03 00:00:00 |  |  | 2002-01-03 00:00:00 | 4
2002-01-04 00:00:00 |  |  | 2002-01-04 00:00:00 |  |  | 2002-01-04 00:00:00 | 6
2002-01-05 00:00:00 |  |  | 2002-01-05 00:00:00 |  |  | 2002-01-05 00:00:00 | 8
2002-01-06 00:00:00 |  |  | 2002-01-06 00:00:00 |  |  | 2002-01-06 00:00:00 | 10
2002-01-07 00:00:00 |  |  | 2002-01-07 00:00:00 |  |  | 2002-01-07 00:00:00 | 12
2002-01-08 00:00:00 |  |  | 2002-01-08 00:00:00 |  |  | 2002-01-08 00:00:00 | 14
2002-01-09 00:00:00 |  |  | 2002-01-09 00:00:00 |  |  | 2002-01-09 00:00:00 | 16
2002-01-10 00:00:00 | bb |  | 2002-01-10 00:00:00 |  |  | 2002-01-10 00:00:00 | 13.5
2002-01-11 00:00:00 |  |  | 2002-01-11 00:00:00 |  |  | 2002-01-11 00:00:00 | 15
2002-01-12 00:00:00 |  |  | 2002-01-12 00:00:00 |  |  | 2002-01-12 00:00:00 | 16.5
2002-01-13 00:00:00 |  |  | 2002-01-13 00:00:00 |  |  | 2002-01-13 00:00:00 | 18
2002-01-14 00:00:00 |  |  | 2002-01-14 00:00:00 |  |  | 2002-01-14 00:00:00 | 19.5
2002-01-15 00:00:00 |  |  | 2002-01-15 00:00:00 |  |  | 2002-01-15 00:00:00 | 21
2002-01-16 00:00:00 | cc |  | 2002-01-16 00:00:00 |  |  | 2002-01-16 00:00:00 | MISS
2002-01-17 00:00:00 |  |  | 2002-01-17 00:00:00 |  |  | 2002-01-17 00:00:00 | MISS
2002-01-18 00:00:00 |  |  | 2002-01-18 00:00:00 |  |  | 2002-01-18 00:00:00 | MISS
Initial information |  |  | My attempt (doesn't work because the result should be equal to the ones in the blue column) |  |  | expected result
Spreadsheet: 732792d1621244678-how-to-exclude-values-in-a-rolling-forecast-sample-file-2
Sheet: Sheet1

MOQ | IOQ | Item volume (m3) | FC RU1 | FC RU2 | FC RU3 | [NAME] | FC RU5 | FC RU6 | FC RU7 | FC RU8 | FC RU9 | FC RU10 | FC RU11 | FC RU12 | FC RU13 | FC RU14 |  | FC RU1 | FC RU2 | FC RU3 | [NAME] | FC RU5 | FC RU6 | FC RU7 | FC RU8 | FC RU9 | FC RU10 | FC RU11 | FC RU12
1 | 1 | 0.066744 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
1 | 1 | 0.1966734 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0
10 | 10 | 0.08 | 6 | 6 | 7 | 6 | 6 | 6 | 4 | 4 | 3 | 2 | 1 | 2 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | without surplus | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | with surplus | 2 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |  | <- surplus
Spreadsheet: 700073d1602935463-rank-top-10-by-summed-group-values-fragan
Sheet: Feuil2

GROUP | Value | Number of sales
A | 50 | 69 |  |  | TOP K | 4
A | 33 | 28 |  |  |  |  | k=4 so i should print only 4 top groups by value
B | 51 | 24
A | 68 | 25
B | 91 | 2 |  |  |  |  | Desired Result :
A | 39 | 97 |  |  |  |  |  | GROUP | Value | Number of Sales
B | 68 | 35
C | 70 | 146
E | 89 | 71
A | 64 | 68
B | 45 | 5
D | 72 | 73
Z | 21 | 57
E | 22 | 56
A | 93 | 89
B | 79 | 77
D | 46 | 87
C | 43 | 86
A | 7 | 27
B | 51 | 18
C | 97 | 2
A | 83 | 69
Z | 7 | 12
B | 8 | 67
C | 3 | 92
S | 56 | 13
A | 37 | 85
T | 32 | 45
Spreadsheet: 720864d1614336173-extract-entire-row-when-condition-is-met-and-create-a-funnel-between-the-tabs-example-1-
Sheet: Database

Internal ID | City | Region | Potential?
245-01 | GVA | GE | yes
245-02 | LSN | VD | no
245-03 | FBG | FR | no
245-04 | GVZ | FR | yes
245-05 | ZRC | ZH | yes
246-06 | ZUG | ZG | no
246-07 | AGH | TG | yes
246-08 | WZT | ZH
Spreadsheet: 110550d1307155486-vlookup-results-cannot-be-summed-sample2
Sheet: Summary

Department | Category | Item | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD
All | Guest Loyalty & Behavior | Number of Completed Surveys | 70 | 86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 156
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
All | Guest Loyalty & Behavior | Overall Experience | #N/A | 81.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
All | Guest Loyalty & Behavior | Likely to Recommend | #N/A | 81.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
All | Guest Loyalty & Behavior | Likely to Return to Hotel | #N/A | 83.26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
All | Guest Loyalty & Behavior | Likely to Return to Brand | #N/A | 80.70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
All | Guest Loyalty & Behavior | Value Relative to Price Paid | #N/A | 71.51 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 852800d1702747029-how-to-join-the-text-of-several-cells-with-a-single-comma-sample-data1
Sheet: Foaie1

 |  | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Field 8 | Field 9 | Result
1 | DINING1 |  | pears |  |  |  | grapes
2 | DINING2 |  |  | lemon apple |  | pears |  |  |  | cherries |  |  | !!!!! In the "Result" column marked with yellow_I would like to join the words from the "Field 1...9" columns_but each word separated from the other by a comma.
3 | DINING3 | oranges |  | pears
4 | DINING4
5 | [NAME] |  |  |  | grapes |  |  |  | pears | cherries
6 | DINING6 |  |  | cherries
7 | DINING7 | pears
8 | DINING8 |  |  |  | oranges
9 | DINING9 |  |  |  | pears
10 | DINING10 |  |  |  |  |  |  | pears
11 | DINING11 |  | oranges
12 | DINING12 |  |  |  |  | grapes
13 | DINING13 |  |  |  |  |  |  | oranges
14 | DINING14 | grapes
15 | [NAME] |  |  |  |  |  |  |  |  | oranges
16 | DINING16 |  | pears
17 | DINING17 |  |  |  | lemon |  | pears
18 | DINING18 |  | cherries |  |  |  |  |  |  | pears
19 | DINING19 |  |  |  |  |  |  |  | pears
20 | DINING20 |  |  | grapes