tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 680501d1591054379-reconfigure-table-results-client-detail-form-responses
Sheet: Form responses 1

STEP 1: RAW DATA
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B. | Number of dependents | Dependent name | Dependent no. 1 | Dependent no. 2 | Dependent no. 3 | Dependent no. 4 | Dependent no. 5
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00 | 2 |  | [NAME] | Ava
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00 | 0
[EMAIL] | Sabrena | King | [PHONE] | Text Message |  | 2 |  | [NAME] | [NAME]
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00 | 2 |  | [NAME] | Tyler
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00 | 0
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00 | 1 |  | [NAME]
STEP 2: ADD BLANK ROW BASED ON CELL VALUE [COLUMN G - NUMBER OF DEPENDANTS]
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B. | Number of dependents | Dependent name | Dependent no. 1 | Dependent no. 2 | Dependent no. 3 | Dependent no. 4 | Dependent no. 5
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00 | 2 |  | [NAME] | Ava
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00 | 0
[EMAIL] | Sabrena | King | [PHONE] | Text Message |  | 2 |  | [NAME] | [NAME]
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00 | 2 |  | [NAME] | Tyler
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00 | 0
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00 | 1 |  | [NAME]
STEP 3: DESIRED OUTPUT
Email address | First name | Last name | Mobile no. | Appointment notification(s) preference | D.O.B.
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message | 1977-10-21 00:00:00
[EMAIL] | [NAME] | Smith | [PHONE] | Text Message
[EMAIL] | Ava | Smith | [PHONE] | Text Message
[EMAIL] | Grace | Swanne | [PHONE] | Text Message | 2000-08-13 00:00:00
[EMAIL] | Sabrena | King | [PHONE] | Text Message
[EMAIL] | Scarlet | King | [PHONE] | Text Message
[EMAIL] | [NAME] | King | [PHONE] | Text Message
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message | 1981-07-17 00:00:00
[EMAIL] | [NAME] | Smith | [PHONE] | [NAME] and Text Message
[EMAIL] | Tyler | Smith | [PHONE] | [NAME] and Text Message
[EMAIL] | [NAME] | Jones | [PHONE] | Text Message | 2015-12-25 00:00:00
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message | 1980-08-18 00:00:00
[EMAIL] | [NAME] | Deanes | [PHONE] | Text Message
Spreadsheet: 0845f0ba-cb65-4cad-9dac-24399eff0521
Sheet: Sheet1

Project Number | Project Name | ESTIMATED START * | ESTIMATED COMPLETION *
2012-2013
1078 | Grand - Baseline/Citrus Edge | 2013-04-01 00:00:00 | 2013-06-01 00:00:00
1096 | Amelia Ave/Route 66 - Left Turn Phasing | 2013-04-01 00:00:00 | 2013-08-01 00:00:00
1112 | Well 1 Destruction | 2013-04-01 00:00:00 | 2013-06-01 00:00:00
1123 | Citywide Street Resurfacing, Phase 1 | 2012-11-01 00:00:00 | 2013-01-01 00:00:00
1127 | Police Department AC System | 2013-04-01 00:00:00 | 2013-06-01 00:00:00
1128 | La Fetra Center Parking Lot Repave | 2013-04-01 00:00:00 | 2013-05-01 00:00:00
1129 | Traffic Management Center | 2012-09-01 00:00:00 | 2013-02-01 00:00:00
1130 | Citywide Street Resurfacing, Phase 2 | March 2013 | 2013-04-01 00:00:00
1131 | Library Elevator Piston Replacement | 2013-05-01 00:00:00 | 2013-06-01 00:00:00
1132 | Gladstone Park Restroom Renovation | 2013-04-01 00:00:00 | 2013-06-01 00:00:00
1133 | [NAME] and Sidewalk Replacement | 2013-04-01 00:00:00 | 2013-06-01 00:00:00
1134 | Slurry Seal Program | March 2013 | 2013-04-01 00:00:00
1135 | Marketplace Existing TS Relocation | March 2013 | 2013-08-01 00:00:00
* Estimated dates only, dependent on contract award and contractor start dates.
Spreadsheet: 847867d1698699461-conditional-formatting-of-referenced-cells-conditional-formatting-example
Sheet: Sheet2

 |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | YTD
Item 1 |  |  | 100 | 65 | 12 | 98 | 100 | 65 | 12 | 12 | 0 | 0 | 0 | 0
Item 2 |  |  | 100 | 12 | 62 | 98 | 100 | 65 | 12 | 18 | 0 | 0 | 0 | 0
Item 3
Spreadsheet: 746812d1631040587-add-values-across-different-sheets-excelforum-sample
Sheet: Week 3

6451 | Apples | 3 |  | Apollo French Polony 125g
7042 | Chicken Chunks 12 X 600g | 13 |  | Apollo French Polony 1kg
8001 | Apollo French Polony 125g | 23 |  | Apollo French Polony 2.5kg
8001 | Apollo French Polony 125g | 33 |  | Apollo French Polony 250g
8001 | Apollo French Polony 125g | 43 |  | Apollo French Polony 2kg
8001 | Apollo French Polony 125g | 53 |  | Apollo French Polony 500g
8001 | Apollo French Polony 125g | 63 |  | Apollo French Polony 750g
8001 | Apollo French Polony 125g | 73 |  | Apollo French Polony Long 2.5kg
8001 | Apollo French Polony 125g | 83 |  | Apollo French Polony Long 3Kg
8001 | Apollo French Polony 125g | 93 |  | Apollo Polony New 125g
8001 | Apollo French Polony 125g | 103 |  | Apollo Polony New 1kg
8001 | Apollo French Polony 125g | 113 |  | Apollo Polony New 2.5kg
8001 | Apollo French Polony 125g | 123 |  | Apollo Polony New 250g
8001 | Apollo French Polony 125g | 133 |  | Apollo Polony New 2kg
8001 | Apollo French Polony 125g | 143 |  | Apollo Polony New 500g
8001 | Apollo French Polony 125g | 153 |  | Apollo Polony New 750g
8001 | Apollo French Polony 125g | 163 |  | [NAME]
8001 | Apollo French Polony 125g | 173 |  | Bacon & Cheese Griller 400g
8001 | Apollo French Polony 125g | 183 |  | Bacon Catering 1kg
8001 | Apollo French Polony 125g | 193 |  | Bacon Catering 200g
8001 | Apollo French Polony 125g | 203 |  | Bacon Cheese Griller 800 G
8001 | Apollo French Polony 125g | 213 |  | Bacon Chips 1kg
8001 | Apollo French Polony 125g | 223 |  | Bacon Chips 200g
8001 | Apollo French Polony 125g | 233 |  | Bacon Prime Cut 1kg
8001 | Apollo French Polony 125g | 243 |  | Bacon Prime Cut 200g
8002 | Apollo French Polony 250g | 253 |  | Bacon Rindless Back 1kg
8002 | Apollo French Polony 250g | 263 |  | Bacon Rindless Back 200g
8002 | Apollo French Polony 250g | 273 |  | Bacon Sasuage 800g
8002 | Apollo French Polony 250g | 283 |  | Bacon Streaky 1kg
8002 | Apollo French Polony 250g | 293 |  | Bacon Streaky 200g
Spreadsheet: 97365d1296579670-possible-countif-percentage
Sheet: Sheet1

E15 | E
[NAME] | M
O12 | O
EE15 | E
MMFDMM | M
Spreadsheet: 152121d1335269016-unconsolodating-data-expanding-discounts
Sheet: Discounts

Pgroup | Disc
AA1 | -10
AA2 | -23
AA3 | -33
AA4 | -45
AA5 | -56
AA6 | -68
AA7 | -50
AA8 | -40
AA9 | -30
AA10 | -20
AA11 | -10
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 173464 | 176394
2 | 177420 | 188500
3 | 173750 | 172558
4 | 189185 | 195274
5 | 184869 | 181847
6 | 191676 | 192336
7 | 214250 | 217025
8 | 196255 | 195210
9 | 199789 | 197970
10 | 196513 | 203483
11 | 190798 | 188209
12 | 199342 | 208493
13 | 209774 | 206540
14 | 230821 | 227895
15 | 200667 | 215379
16 | 201563 | 211642
17 | 204380 | 221578
18 | 175953 | 170000
19 | 187798 | 175000
20 | 192800 | 192648
21 | 206330 | 212027
22 | 209500 | 205536
23 | 199462 | 199399
24 | 199184 | 199221
25 | 203753 | 200522
26 | 200807 | 199996
27 | 201555 | 200810
28 | 204461 | 202551
29 | 161106 | 162371
30 | 164958 | 164466
31 | 164990 | 164867
2000-11-30 00:00:00 |  |  | 0
2000-12-31 00:00:00
Spreadsheet: a81cfcf5-6526-430b-a1b9-f9ee62e45faf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7413 | 9830 | Viktoriia | Kachan | UKR | 0 | 00:21:06 | 00:00:00 | 01:02:57 | 00:00:29 | 00:37:00 | 1 | 02:01:31
7413 | 11887 | Agnieszka | Cieslak | POL | 0 | 00:22:52 | 00:00:00 | 01:01:11 | 00:00:34 | 00:38:23 | 2 | 02:03:00
7413 | 53569 | Stefania | Ion | [NAME] | 0 | 00:21:09 | 00:00:00 | 01:09:12 | 00:00:43 | 00:42:37 | 3 | 02:13:41
7413 | 9842 | Cigdem | Gulgec | TUR | 0 | 00:23:58 | 00:00:00 | 01:09:01 | 00:00:40 | 00:44:23 | 4 | 02:18:02
7413 | 18753 | Monika | Mikova | BUL | 0 | 00:22:09 | 00:00:00 | 01:12:28 | 00:00:40 | 00:44:33 | 5 | 02:19:50
7413 | 72789 | [NAME] | Irmak | TUR | 0 | 00:25:46 | 00:00:00 | [NAME] | 00:00:57 | 00:46:40 | 6 | 02:20:37
Spreadsheet: 28bb3cdf-73de-4095-87aa-6161985c6331
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | SINGLE FAMILY VALUATION/
 | FIRE SPRINKLER WORKSHEET 2001.1
 | Job Address:
 | A | USE | SQ. FT. |  | VALUE |  |  |  | VALUATION*
 |  | EXISTING NON-SPRINKLED BUILDING
 |  | LIVABLE / CONDITIONED AREA |  | X | 103.92 |  |  | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 39.44 |  |  | = | 0
 |  |  |  |  |  | TOTAL A |  | = | 0
 | B | GARAGE |  | X | 39.44 |  |  | = | 0
 |  | CARPORT |  | X | 39.44 |  |  | = | 0
 |  | COVERED PATIO |  | X | 39.44 |  |  | = | 0
 |  |  |  |  |  | TOTAL B |  | = | 0
 | C | TOTAL EXISTING VALUE, (A+B) |  |  |  | TOTAL C |  | = | 0
 | D | FACTORED EXISTING VALUE | 0 | X | 0.25 | TOTAL D |  | = | 0
 | E | NEW CONSTRUCTION/ADDITION
 |  | LIVABLE / CONDITIONED AREA |  | X | 103.92 |  |  | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 39.44 |  |  | = | 0
 |  |  |  |  |  | TOTAL E |  | = | 0
 | F | GARAGE |  | X | 39.44 |  |  | = | 0
 |  | CARPORT |  | X | 39.44 |  |  | = | 0
 |  | COVERED PATIO |  | X | 39.44 |  |  | = | 0
 |  |  |  |  |  | TOTAL F |  | = | 0
 | G | REMODELED AREAS, includes work requiring permit per  IRC 105.2 amended.
 |  | LIVABLE / CONDITIONED AREA |  | X | 103.92 | X | 0.3 | = | 0
 |  | GARAGE |  | X | 39.44 | X | 0.3 | = | 0
 |  | CARPORT |  | X | 39.44 | X | 0.3 | = | 0
 |  | COVERED PATIO |  | X | 39.44 | X | 0.3 | = | 0
 |  | BASEMENT - UNFINISHED |  | X | 39.44 | X | 0.3 | = | 0
 |  |  |  |  |  | TOTAL G |  | = | 0
 | H | TOTAL NEW AND [NAME], (E+F+G) |  |  |  | TOTAL H |  | = | 0
 | IF H >D FIRE SPRINKLERS WILL BE REQUIRED
 | 0
 | IF TOTAL H >50% of TOTAL C
 | 0
 | * Values are based on the ICC Building Safety Journal, May 2012. |  |  |  |  |  | revised 5/22/2011.
 | The scope of work and related square footages provided are subject to field verification.  Where discrepancies are encountered by the inspector, work shall stop and a new worksheet shall be completed, inclusive of the entire known scope of work.  Sprinklers shall be installed if indicated on the revised worksheet.
Spreadsheet: benjamin_rogers__1017__loss insurance
Sheet: Sheet1

Teco/Mosbacher Delmarva Project
Potential Insurance Loss Analysis
Enron 1st loss - $/kw |  |  |  | 50
Enron pro-rata loss |  |  |  | 0.1
Project size - MW |  |  |  | 315
Developed cost - $/kw |  |  |  | 550
Debt - $/kw |  |  |  | 375
Residual/minimum value assumption - $/kw |  |  |  | 100
Term - yrs. |  |  |  | 20
[NAME] |  |  |  | 0.09
Enron first loss - $/kw |  |  |  | 50
Enron pro-rata loss |  |  |  | 0.1
All figures in $/kw
 |  |  |  |  | [NAME] |  | Equity
 |  | Residual | [NAME] | Enron | Insurance |  | Book |  | Net
Year | Debt | Value | Loss | Loss | Loss |  | Basis | Debt | Equity
1 | 375
2 | 367.6700718719141
3 | 359.6804502123004
4 | 350.9717626033215
5 | 341.4792931095344
6 | 331.1325013613065
7 | 319.8544983557381
8 | 307.5614750796686
9 | 294.1620797087528
10 | 279.5567387544546
11 | 263.6369171142695
12 | 246.2843115264678
13 | 227.3699714357639
14 | 206.7533407368967
15 | 184.2812132751314
16 | 159.7865943418073
17 | 133.087459704484
18 | 103.9854029498016
19 | 72.26416108719775
20 | 37.68800745695958
21
22
23
24
25
26
27
28
29
30
Spreadsheet: 1cf75831-227c-46ee-839a-b784e2e2b3ad
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
 | Time Series Workbook
 | 5206.0 Australian National Accounts: National Income, Expenditure and Product
 | Table 19. Social Assistance Benefits Payments, Current prices
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
General government - National ;  Health ; |  |  | Original | A2301964W | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Sickness benefits ; |  |  | Original | A2301965X | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Benefits to ex-servicemen and their dependants ; |  |  | Original | A2301966A | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Permanent disablement benefits ; |  |  | Original | A2301967C | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Old age benefits ; |  |  | Original | A2301968F | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Unemployment benefits ; |  |  | Original | A2301969J | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Family and child benefits ; |  |  | Original | A2301970T | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Other ; |  |  | Original | A2301971V | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Total social security ; |  |  | Original | A2301972W | 1961-09-01 00:00:00 | 2009-12-01 00:00:00 | 194 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Other social assistance benefit payments ; |  |  | Original | A2301973X | 1959-09-01 00:00:00 | 2009-12-01 00:00:00 | 202 | $ Millions | DERIVED | Quarter | 3
General government - National ;  Total personal benefits payments ; |  |  | Original | A2301974A | 1959-09-01 00:00:00 | 2009-12-01 00:00:00 | 202 | $ Millions | DERIVED | Quarter | 3
General government - State and local ;  Total personal benefits payments ; |  |  | Original | A2301975C | 1959-09-01 00:00:00 | 2009-12-01 00:00:00 | 202 | $ Millions | DERIVED | Quarter | 3
General government ;  Total personal benefits payments ; |  |  | Original | A2301976F | 1959-09-01 00:00:00 | 2009-12-01 00:00:00 | 202 | $ Millions | DERIVED | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 77896d1278400993-sum-in-accordance-to-another-cell-sales-analysis
Sheet: MAT

SALES
 | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAC | Accumulated | YTD
FY 2010 | 333333 | 222222 | 111111 | 50000 | 100000 | 200000 | 250000
FY 2011 | 851997.45 | 446263.43
FY 2011 B
Spreadsheet: 79342d1279632741-trying-to-copy-workbooks-to-new-folder-while-retaining-relative-links-between-workboo-july-sound-and-light-show
Sheet: July 27

 | SOUND and LIGHT SHOW
 | Number of Day Tours |  | Money Taken for Day Tours |  |  |  |  |  |  |  |  |  |  |  | No of Paxe
 | Name of Customer | No. of Paxe | Contact Details | Time | Booked by | Price | Paid | Heard from |  | Prepaid Paxe |  |  |  |  |  |  |  |  |  | Count if
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Money Taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepaid
Spreadsheet: andy_zipper__483__11_26_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 52 | 150 | 250 | 69 | 115.1 | 3.01 | 2001-11-26 13:51:00
 | HU F2 | 53 | 650 | 750 | 53.8 | 62.1 | 1.93 | 2001-11-26 13:51:00
 | HU G2 | 54 | 930 | 1020 | 52.4 | 57.5 | 1.87 | 2001-11-26 13:51:00
 | [NAME] | 54 | 1100 | 1225 | 51.8 | 57.7 | 1.86 | 2001-11-26 13:51:00
 | [NAME] | 61 | 1250 | 1400 | 45.7 | 51.2 | 1.86 | 2001-11-26 13:51:00
 | [NAME] | 61 | 1400 | 1550 | 45.8 | 50.7 | 1.85 | 2001-11-26 13:51:00
 | [NAME] | 61 | 1500 | 1650 | 44.7 | 49.2 | 1.8 | 2001-11-26 13:51:00
 | HU N2 | 61 | 1525 | 1675 | 42.4 | 46.6 | 1.71 | 2001-11-26 13:51:00
 | [NAME] | 61 | 1540 | 1700 | 40.1 | 44.3 | 1.62 | 2001-11-26 13:51:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: daren_farmer__5964__WC580reveff061200
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/12/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-12 00:00:00 | WC 580 | 28517 | 0 |  |  | 20145
1st of month DBQ = 20145/d
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.
Spreadsheet: 869036d1715704649-sumif-_conditioned-of-performance-sumif_cond_values-_-with-matching-columns_glenn
Sheet: Glenn_offered Solution

=[NAME] "F" | =[NAME] "G" | =[NAME]" | =[NAME] "BH"
Group | Members | # | Value, €
Group5 | Jan | yes | 2
Group2 | [NAME] | yes | 112
Group3 | Volker | 0 | 1
Group2 | Maria | 0 | 1
Group1 | [NAME] | 0 | 25
Group2 | [NAME] | yes | 50
Group3 | [NAME] | 0 | 60
Group4 | Katha | yes | 75
Group3 | [NAME] | yes | 15
Group4 | Holger | 0 | 12
Group1 | Anto | yes | 250
Group4 | Bernd | 0 | 4
Group3 | [NAME] | 0 | 85 |  | Amont of groups, in which specs "sent" are exceeding 50% with their value the total  specs value of the group
Group5 | Anna | yes | 60 |  | "3" | expected result
Group5 | Caroline | 0 | 20
Group1 | Alla | 0 | 75
Group2 | [NAME] | 0 | 38
Group3 | [NAME] | 0 | 42
Group3 | Tizian | yes | 120
Group4 | Vitus | 0 | 250
Group4 | Niklas | yes | 10
Group4 | [NAME] | yes | 100
Group1 | Xavier | 0 | 0 | Challenge:
Group1 | Oxana | 0 | 4 | -count amount of Groups (not members) which have SENT out a specification (column "C"=yes), however only THEN, when the total money value (within this particular group) of specificaitons [NAME] are equal or exceeding 50% of the total specification's VALUE (column "D") of this particular group.
Group5 | Cam | 0 | 90 | -Example on "Group 3": total specifications "sent" - 135€ out of 323€ of the whole group. Since it equals to LESS than 50% (135/323), => "Group 3" should not be counted for the final result.
Group5 | Uzay | 0 | 10 | - please in case if there are no entries in columns "Specification" and "Value, €", the result should be Zero , and not "1".
Group5 | Atakan | yes | 180
Group2 | [NAME] | yes | 300
Group6 | Vasja | 0 | 0 | PS  - Members are not important for this logic, names entries are just put for demo reasons
Group6 | Petja | 0 | 0
Group6 | Asja | 0 | 0
Spreadsheet: 835376d1688545979-count-cell-with-different-date-and-year-exist-count-cell-with-different-date-and-year-exist-aligw
Sheet: Sheet1

Received Date |  |  | this is the data
 |  |  |  | RESULT I WANT |  | AliGW | AliGW 2
2022-01-03 00:00:00 |  |  |  | 2022-01-31 00:00:00 | 6
2022-01-03 00:00:00 |  |  |  |  | 4
2022-01-05 00:00:00 |  |  |  |  | 2
2022-01-05 00:00:00 |  |  |  |  | 5
2022-01-20 00:00:00 |  |  |  |  | 4
2022-01-20 00:00:00 |  |  |  | 2023-01-31 00:00:00 | 6
2022-02-01 00:00:00 |  |  |  |  | 4
2022-02-01 00:00:00 |  |  |  |  | 2
2022-02-15 00:00:00 |  |  |  |  | 5
2022-02-20 00:00:00 |  |  |  |  | 4
2022-03-04 00:00:00
2022-03-05 00:00:00
2022-04-04 00:00:00
2022-04-05 00:00:00
2022-04-06 00:00:00
2022-04-07 00:00:00
2022-05-05 00:00:00
2022-05-06 00:00:00
2022-05-07 00:00:00
2022-05-08 00:00:00
2023-01-03 00:00:00
2023-01-03 00:00:00
2023-01-05 00:00:00
2023-01-05 00:00:00
2023-01-20 00:00:00
2023-01-20 00:00:00
2023-02-01 00:00:00
2023-02-01 00:00:00
2023-02-15 00:00:00
2023-02-20 00:00:00
2023-03-04 00:00:00
2023-03-05 00:00:00
2023-04-04 00:00:00
2023-04-05 00:00:00
2023-04-06 00:00:00
2023-04-07 00:00:00
2023-05-05 00:00:00
2023-05-06 00:00:00
2023-05-07 00:00:00
2023-05-08 00:00:00
Spreadsheet: 90983d1290666729-macro-pops-up-when-certain-value-is-entered-sale-tracker
Sheet: Database

Agent Name | Agent ID | Customer Name | Address | Plan Taken
Ghislain Salomon | 3155 |  |  | High End
[NAME] | 6519 |  |  | Low End
[NAME] | 6549 |  |  | Mid End
César Édouard | 3218 |  |  | Low End
[NAME] | 6498 |  |  | Mid End
[NAME] | 9878 |  |  | Low End
Spreadsheet: e3f21f3a-8732-4706-9efb-5ed8c3dfb0e3
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
CELY | Test | CELY | Celery, IgE | Celery, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CELY | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CELY | Result | CELY | Celery, IgE | Celery, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6065-7
Spreadsheet: 749664d1632950660-looking-for-help-with-a-calculation-between-2-fields-hours-per-week
Sheet: Weekly Workload

Weekly schedule |  |  |  | Hours to do work |  |  | Total Hours worked
Name | Job |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | Shed |  | Shed | 2 | 1
[NAME] | House |  | House | 1 | 1
[NAME] | Shed
[NAME] | House
[NAME] | Shed
Spreadsheet: 217108d1361986966-match-and-sum-with-date-range-neagtive-values-find-and-sum-shafiqe-oeldere-
Sheet: Sheet1

 |  |  | Date Range |  |  | Date Date | A | B | C |  | Kgs
 |  |  | 2013-02-01 00:00:00 | 2013-02-27 00:00:00 |  | 2013-02-02 00:00:00 | 0.03 | 0.04 |  |  | 100
 |  |  |  |  |  | 2013-02-03 00:00:00 | 0.03 | 0.02 |  |  | 100
 |  |  |  |  |  | 2013-01-01 00:00:00 | 0.03 | 0.04 |  |  | 100
 |  |  |  |  | Output
 |  |  |  |  | See the variance  only for negative % column  J than match the data date with ragne date and sum the kg
 |  |  |  |  | result will be
Spreadsheet: 203133d1356948474-relational-study-book3
Sheet: Sheet1

Participant | [NAME] | Cloze | Vocabulary | Reading | PTS | ITP1 | ITP2 | [NAME] | PSIS | IS
Participant 1 | 7 | 8 | 4 | 1 | 20 | 11 | 8 | 0 | 4 | 19
Participant 2 | 26 | 12 | 17 | 5 | 60 | 12 | 6 | 7 | 5 | 18
Participant 3 | 7 | 8 | 6 | 1 | 22 | 5 | 11 | 0 | 1 | 16
Participant 4 | 12 | 9 | 3 | 0 | 24 | 11 | 5 | 6 | 3 | 16
Participant 5 | 12 | 10 | 6 | 2 | 30 | 9 | 11 | 0 | 4 | 20
Participant 6 | 18 | 10 | 7 | 3 | 38 | 9 | 5 | 1 | 1 | 14
Spreadsheet: 683753d1592925463-create-uniqe-data-without-blank-cell-name
Sheet: Sheet1

Input | Output
Name | Result |  |  | Please, without vb & helper column
Name1 | Name1
[NAME] | [NAME] |  | Name | =Sheet1!$A$3:$A$13
Name3 | Name3
Name1 | Name4
 | Name5
Nmae4 | Name6
Name5
Name3
Name6
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Urea

Raw Material |  | Urea
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 202.23
Total