tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 832481d1686349462-lookup-to-return-values-if-asterix-is-present-test-21-
Sheet: Format Data

Todays Date | Schedule | Colour | Name | Address
 |  | blue | [NAME] | 13 Fiddle St, Couch, Italy
 |  | yellow | [NAME] | 312 Carpet Road, Furniture, Germany
 |  | orange | July Jules | 31 Television Road, Watching, England
 |  | red | [NAME] | 543 Stove Street, Kitchen, Ireland
This is how I would like it to look - so only rows with an asterix are selected and there are no gaps between rows. Note "Todays Date" Is only populated if there is an asterix. B to E is a table (doesn’t include A):
Todays Date | Schedule | Colour | Name | Address
 | ID_21321 | Mon, 01-May-2023, from 09:00 to 11:00 | blue | [NAME] | 13 Fiddle St, Couch, Italy
 | ID_42133 | [NAME], 12-May-2023, from 13:00 to 15:00 | yellow | [NAME] | 312 Carpet Road, Furniture, Germany
 | ID_12322 | Tue, 09-May-2023, from 10:00 to 15:00 | orange | July Jules | 31 Television Road, Watching, England
 | ID_54324 | Mon, 22-May-2023, from 11:00 to 16:00 | red | [NAME] | 543 Stove Street, Kitchen, Ireland
 | Table auto increases if more rows have *
 |  | apple | blue | Tue | 2023-05-01 00:00:00 | Yes | 09:00:00 | 11:00:00 | [NAME] | 13 Fiddle St, Couch, Italy
 | 42133 | orange | yellow | Sun | 2023-05-12 00:00:00 | No | 13:00:00 | 15:00:00 | [NAME] | 312 Carpet Road, Furniture, Germany
 | 12322 | kiwi | orange | Thur | 2023-05-09 00:00:00 | No | 10:00:00 | 15:00:00 | July Jules | 31 Television Road, Watching, England
 | 54324 | mango | red | Sun | 2023-05-22 00:00:00 | No | 11:00:00 | 16:00:00 | [NAME] | 543 Stove Street, Kitchen, Ireland
Spreadsheet: 150571d1334605791-using-variables-to-find-values-in-a-different-worksheet-sample_sheet_excelforum
Sheet: ref_table

ref_var column |  | value needed column |  |  | ref_var column |  | value needed column |  |  | ref_var column |  | value needed column
1.2 | 1.0047 | 1.21 | 3.11 |  | 6 | 1.0237 | 6.14 | 15.84 |  | 10.8 | 1.0434 | 11.26 | 29.06
1.25 | 1.0049 | 1.26 | 3.24 |  | 6.05 | 1.0239 | 6.19 | 15.98 |  | 10.85 | 1.0436 | 11.32 | 29.2
1.3 | 1.005 | 1.31 | 3.37 |  | 6.1 | 1.0241 | 6.25 | 16.11 |  | 10.9 | 1.0438 | 11.37 | 29.34
1.35 | 1.0052 | 1.36 | 3.5 |  | 6.15 | 1.0243 | 6.3 | 16.25 |  | 10.95 | 1.044 | 11.43 | 29.48
1.4 | 1.0054 | 1.41 | 3.63 |  | 6.2 | 1.0245 | 6.35 | 16.38 |  | 11 | 1.0442 | 11.48 | 29.62
1.45 | 1.0056 | 1.46 | 3.76 |  | 6.25 | 1.0247 | 6.4 | 16.52 |  | 11.05 | 1.0444 | 11.54 | 29.77
1.5 | 1.0058 | 1.51 | 3.89 |  | 6.3 | 1.0249 | 6.46 | 16.65 |  | 11.1 | 1.0446 | 11.59 | 29.91
Spreadsheet: 85843d1285868142-excel-2007-sum-of-unique-items-sumofuniqueitemsexample
Sheet: Sum

Fruits | Sum of Unique Codes
[NAME]
Apple
Grape
Orange
[NAME]
Spreadsheet: 598954d1542806596-value-help-book1-formula-cant-calculate-because-of-value-error
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How can I solve this?
 |  |  | 100
 |  |  | 2
 |  |  | 12
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Spreadsheet: 717210d1612531458-sumif-ignoring-duplicates-if-exist-during-lookup-test
Sheet: Sheet1

 |  |  |  |  | Desired Result
 |  |  | Lookup |  | 1st | 2nd
 |  |  | 42420 | 2801 |  | 4634
 |  |  | 42486 | 11007 |  | 63
 |  |  | 42486 | 19263 | 0 | 0
 |  |  | 43063 | 89081 |  | 264
 |  |  | 43063 | 97760 |  | 0
 |  |  | 43063 | 89599 |  | 0
Spreadsheet: 765131d1643187880-sum-in-diferent-sheets-with-condition-book1
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  |  |  |  | sheet 1 |  |  |  |  | sheet 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 2020-01-01 00:00:00 | a | 100 |  | 2021 | 2020-01-01 00:00:00 | a | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 2020-02-05 00:00:00 | s | 125 |  | 2021 | 2020-02-05 00:00:00 | s | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | 2021-02-03 00:00:00 | d | 150 |  | 2020 | 2021-02-03 00:00:00 | d | 18.5
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | 2021-03-05 00:00:00 | r | 200 |  | 2020 | 2021-03-05 00:00:00 | r | 35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 2021-07-08 00:00:00 | f | 300 |  | 2021 | 2021-07-08 00:00:00 | f | 75
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 2022-02-10 00:00:00 | t | 400 |  | 2021 | 2022-02-10 00:00:00 | t | 125
 |  |  |  |  |  |  |  |  |  |  |  |  | ???
Spreadsheet: 845594d1697040860-sheet-1-lookup-table-in-sheet-2-formula-help-quote-assistance
Sheet: Quote

 |  |  |  |  |  |  |  | [NAME]
[NAME] |  | 1*Additional sockets |  |  |  |  |  | LOCATION - MAIN BEDROOM
 |  |  |  |  |  |  |  | PROJECT - 2X ADDITIONAL SOCKETS - NEXT TO BED
 |  |  |  |  |  |  | No | STEPS
Chase | 1m | cable | 1 | capping | 1 | 2g metal back box | 1 | Menu | Qty |  | COST | From Menu - look up each item in PRICES - find the price - multiply by qty and add to total - for each menu - displays all totals combined
 |  |  |  |  |  |  |  | [NAME] | 1 |  |  |  |  | This would mean look up would find (3+4.50+3+1+3+1.50+7.50+4.50+3+3+1+4) = £39
 |  |  |  |  |  |  | 2 | Menu | Qty |  | LABOUR | TOTAL
 |  |  |  |  |  |  |  | 2.5mm | 3 |  | 2.5 | From Prices - looks up labour cost (e2) - multiples by L12 - this should find (3*2.5) = £7.5
 |  |  |  |  |  |  | 3 | Menu | Qty
 |  |  |  |  |  |  |  | Chase | 1 |  | QUOTE TOTAL
 |  |  |  |  |  |  | 4 | Menu | Qty |  | Sum(M9+)M12 = 46.5
 |  |  |  |  |  |  |  | Capping | 1
 |  |  |  |  |  |  | 5 | Menu | Qty
 |  |  |  |  |  |  |  | 2g Socket | 1
 |  |  |  |  |  |  | 6 | Menu | Qty
 |  |  |  |  |  |  |  | 2g Metal BB | 1
 |  |  |  |  |  |  | 7 | Menu | Qty
 |  |  |  |  |  |  |  | Chase | 2.5
 |  |  |  |  |  |  | 8 | Menu | Qty
 |  |  |  |  |  |  |  | 2.5mm | 3
 |  |  |  |  |  |  | 9 | Menu | Qty
 |  |  |  |  |  |  |  | Capping | 3
 |  |  |  |  |  |  | 10 | Menu | Qty
 |  |  |  |  |  |  |  | 2g Socket | 1
 |  |  |  |  |  |  | 11 | Menu | Qty
 |  |  |  |  |  |  |  | 2g Metal BB | 1
 |  |  |  |  |  |  | 12 | Menu | Qty
 |  |  |  |  |  |  |  | IT&Cert | 1
Spreadsheet: 886494d1736514787-count-up-of-the-number-of-inputs-someone-has-done-danj19-1
Sheet: Price

ND - 24 Hour
Zone | [NAME] | Half Pallet | Full Pallet
Local | 22.92 | 27.09 | 35.43
2 | 37.23 | 38.92 | 44.71
3 | 37.23 | 39.48 | 47.51
4 | 39.48 | 41.74 | 51.04
5 | 39.48 | 45.14 | 54.02
6 | 41.33 | 46.95 | 53.22
7 | 42.32 | 48.54 | 60.53
8 | 47.68 | 54.19 | 58.65
9 | 47.15 | 49.89 | 55.11
10 | 46.83 | 50.8 | 55.65
11 | 48.54 | 57.59 | 62.71
12 | 49.53 | 59.86 | 62.71
13 | 55.32 | 64.37 | 67.05
14 | 48.54 | 57.59 | 67.05
15 | 55.32 | 64.37 | 67.05
16 | 58.64 | 62.47 | 63.51
17 | 82.48 | 82.48 | 91.94
18 | 60.83 | 67.39 | 67.39
19 | 93.15 | 93.79 | 105.1
20 | N/A | 71.85 | 81.46
21 | N/A | 75.12 | 86.43
22 | N/A | 81.14 | 92.17
23 | N/A | 75.12 | 92.08
24 | N/A | 80.77 | 80.77
25 | N/A | 86.43 | 86.43
26 | N/A | 114.71 | 126.02
27 | N/A | 120.37 | 120.37
28 | N/A | 126.02 | 159.45
29 | N/A | 131.68 | 131.68
30 | N/A | 148.65 | 148.65
31 | N/A | 182.59 | 182.59
32 | N/A | N/A | N/A
33 | N/A | N/A | N/A
EC - 48 Hour
Zone | Eco Half Pallet Price | Eco Full Pallet Price
Local | 26.05 | 32.3
2 | 35.52 | 38.73
3 | 35.52 | 40.45
4 | 36.08 | 43.17
5 | 37.78 | 43.17
6 | 40.62 | 43.44
7 | 40.62 | 50.22
8 | 46.27 | 47.83
9 | 44.96 | 48.28
10 | 46.27 | 48.28
11 | 46.83 | 52.4
12 | 47.82 | 52.4
13 | 53.63 | 63.25
14 | 46.83 | 56.73
15 | 53.63 | 63.25
16 | 57 | 57.21
17 | 63.8 | 76.43
18 | 64.66 | 64.66
19 | 75.4 | 86.43
20 | N/A | N/A
21 | 75.12 | 86.43
22 | N/A | N/A
23 | 75.12 | 92.08
24 | N/A | N/A
25 | N/A | N/A
26 | 114.71 | 126.02
27 | N/A | N/A
28 | N/A | N/A
29 | N/A | N/A
30 | N/A | N/A
31 | N/A | N/A
32 | 74.94 | 86.98
33 | 91.82 | 99.91
Spreadsheet: 97987d1297096910-extract-number-to-a-different-cell-aranechan
Sheet: Sheet1

8974123719 | 8 | 9 | 7 | 4 | 1 | 2 | 3 | 7 | 1 | 9
9865 |  |  |  |  |  |  | 9 | 8 | 6 | 5
524693 |  |  |  |  | 5 | 2 | 4 | 6 | 9 | 3
16 |  |  |  |  |  |  |  |  | 1 | 6
Spreadsheet: ed4a1ccd-7747-4298-b8db-c28ffcedfe11
Sheet: CAGNY PR - Operating EPS FY

GAAP to Non-GAAP Reconciliation
Diluted Earnings per Share to Operating EPS
For the Twelve Months Ended December 31,
([NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Growth
 | 2011 |  | As Reported (GAAP) |  | Integration Program Costs (1) |  | Acquisition-Related Costs (2) and Financing Fees (3) |  | U.S. Health Care Legislation Impact on Deferred Taxes |  | Spin-off Costs (4) |  | Operating (Non-GAAP) |  | Currency |  | Operating [NAME] (Non-GAAP) |  |  | As Reported EPS Growth (GAAP) |  | Operating EPS Growth (Non-GAAP) |  | Operating Constant Fx EPS Growth (Non-GAAP)
 | Diluted EPS
 | -  Continuing operations |  | 1.99 |  | 0.28 |  | 0 |  | 0 |  | 0.02 |  | 2.29 |  | -0.06 |  | 2.23 |  |  | 0.382 |  | 0.134 |  | 0.104
 | -  Discontinued operations |  | 0
 | -  Net earnings attributable to Kraft Foods |  | 1.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.167
 | 2010
 | Diluted EPS
 | -  Continuing operations |  | 1.44 |  | 0.29 |  | 0.21 |  | 0.08 |  | 0 |  | 2.02 |  | 0 |  | 2.02
 | -  Discontinued operations |  | 0.9500000000000002
 | -  Net earnings attributable to Kraft Foods |  | 2.39
 | (1)  Integration Program costs are defined as the costs associated with combining the Kraft Foods and Cadbury businesses, and are separate from those costs
 | associated with the acquisition.  Integration Program costs were $521 million, or $497 million after-tax including certain tax costs associated with the integration of Cadbury,
 | for the twelve months ended December 31, 2011, as compared to $657 million, or $497 million after-tax for the twelve months ended December 31, 2010.
 | (2)  Acquisition-related costs include transaction advisory fees, U.K. stamp taxes and the impact of the Cadbury inventory revaluation.
 | (3)  Acquisition-related financing fees include hedging and foreign currency impacts associated with the Cadbury acquisition and
 | other fees associated with the Cadbury bridge facility.
 | (4)  Spin-off costs include transaction fees and other costs associated with the proposed spin-off of the North American grocery business.
Spreadsheet: daren_farmer__6636__CES - April
Sheet: TOMC

Purchase
 | From Kerr McGee
 | At Matagorda Island 587
 | At GDA Tetco STX+.01
Sale
 | Transported from the terminus of Tomcat
 |  | into HPL (Mtr 14940)
Term
 | Thru 4/00. Contract is being renegotiated
Deals
 | P-141125
 | S-144230
Other
 | [NAME] at CES will be moving to Kerr McGee
 |  | She will continue to handle the noms on TOMC
 |  | She will notify us of any changes/issues
 |  | [NAME]
 | Anadarko operated MI 587
 |  | [NAME] [PHONE]
 | Current volumes are about 2000 MMBtu/d
Spreadsheet: 751595d1634203923-if-cells-collumns-match-add-up-collumn-d-and-paste-result-to-other-sheet-example01
Sheet: Sheet1

Poz | No | name | vnt | Ilgis | angl01 | angl02 | Bounding  Box  Length | Bounding  Box Width | Sheet  Metal  Thickness | MATERIA L
 |  |  | 32 |  |  |  | 800 | 400 | 9 | UPM [NAME]
 |  |  | 2 |  |  |  | 80 | 100 | 9 | UPM [NAME]
 |  |  | 1 |  |  |  | 800 | 400 | 9 | UPM [NAME]
 |  |  | 3 |  |  |  | 80 | 100 | 9 | UPM [NAME]
 |  |  | 51 |  |  |  | 530 | 300 | 9 | UPM [NAME]
 |  |  | 32 |  |  |  | 800 | 400 | 9 | UPM [NAME]
 |  |  | 7 |  |  |  | 700 | 90 | 9 | UPM [NAME]
Spreadsheet: 852188d1702291736-extracting-and-compiling-data-from-a-spreadsheet-with-many-blank-cells-test-for-gs-aligw
Sheet: Sheet1

Aisle / Wave
 | Volume | Density | Picker | Volume | Density | Picker | Volume | Density | Picker
2/3 | 1234 | 56 | [NAME] | 46 | 1 |  | 0 | 0
4/5 | 57 | 1 |  | 27 | 3 |  | 0 | 0
6/7 | 245 | 2.4 |  | 354 | 5.9 | [NAME] | 0 | 0
8/9 | 89 | 5 |  | 142 | 4 |  | 0 | 0
10/11 | 1 | 1 |  | 0 | 0 |  | 57 | 4.6 | [NAME]
 | 1234 | 56 | [NAME]
6/7 | 354 | 5.9 | [NAME]
10/11 | 57 | 4.6 | [NAME]
Spreadsheet: 120462d1315316086-searching-and-merging-data-book2
Sheet: Sheet1

Sheet 1
[NAME] | [NAME] | [EMAIL]
[NAME] | [NAME] | [EMAIL]
[NAME] | [NAME] | [EMAIL]
[NAME] | [NAME] | [EMAIL]
[NAME] | [NAME] | [EMAIL]
[NAME] | Carol | [EMAIL]
Sheet 2
[NAME] | [NAME] | (insert appropriate email)
[NAME] | [NAME] | (insert appropriate email)
[NAME] | Carol | (insert appropriate email)
Spreadsheet: df317251-fa2f-4e6a-89a2-e84b4b7a9941
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3837 | 12238 | Connie | Naulls | AUS | 0 | 00:55:31 | 00:01:19 | 01:55:25 | 00:01:30 | 00:29:25 | 1 | 03:23:14
Spreadsheet: 103653d1301397900-remove-duplicate-values-in-an-index-return-lc_reviewv2tester
Sheet: DataPulls

OFFSET($A$1,0,0,COUNT($A:$A),1)
 |  | TO | Clin | Subclin
 |  | 1 | 1 | 0
 |  | 2 | 2 | 1
 |  | 3 | 3 | 2
 |  | 4 |  | 3
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
Spreadsheet: 127246d1320252154-pivot-table-report-help-test-2-ccm-reporting-sumproduct
Sheet: data entry

ID | Reporting Quarter | Reporting Period | Target | Site |  |  |  | P 1
984 | Q 1 | P 1 | Yes | A |  |  |  | P 2
654 | Q 1 | P 1 | Yes | A |  |  |  | P 3
7546 | Q 1 | P 1 | NO | A
5324 | Q 2 | P 1 | Yes | A
35234 | Q 2 | P 2 | Yes | A
523423 | Q 2 | P 3 | Yes | A
235 | Q 3 | P 1 | Yes | A
Reporting Period | Yes | No | Total
P 1
P 2
P 3
Total
Spreadsheet: 296142d1391989965-entering-data-in-one-sheet-to-go-directly-to-another-sheet-property-maintenance-example-tms
Sheet: Properties

Property | Address 1 | Address 2 | Address 3 | Zip code | Work to be done
1 | 891 Crystal Springs Road | Hillsborough | USA | 94010 | paint interior
2 | 384 Delfern Dr | Los Angeles | USA | 90077 | paint exterior
3 | 939 Scuttle Hole Road | [NAME] | USA | 11976 | repair wall
4 | 491 Hayground Road | [NAME] | USA | 11976 | fix hole in roof
5 | 26880 Pacific Coast Hwy | Malibu | USA | 90265 | general maintenance; see list
6 | 493 Rose Hill Road | [NAME] | USA | 11976 | landscape garden; see list
Spreadsheet: 164346d1340730474-excel-2007-coping-rows-from-multiple-workbooks-based-on-cell-values-rome-s207-log-2012
Sheet: Rome

2012 S207 log |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quarter | Q1 | Q2 | Q3 | Q4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quarter |  |  | Date Range | 3/31/2012 T | 6/30/2012 U | 9/30/2012 V | 12/31/2012 W |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  |  |  |  | Q1 Fees | Q2 Fees | [NAME] | [NAME] | Total:
S207 # | Filed | Received | Days total/status | Customer | Requested by | S207 Group | [NAME] to: | Fees |  | WO# | Model | S/N | Modification Request |  | Classification |  |  | Date Code |  |  |  |  |  | Group totals |  |  |  |  |  | Q1 Days | Q2 Days | [NAME] | Q4 Days
1675335 | 2012-04-16 00:00:00 | 2012-04-16 00:00:00 |  | Boeing | [NAME] | SI | Sales | 90 |  | NF120004732 | 560-OPC30TT | 560-12-A13255 | Install lift limit with bypass.
1684388 | 2012-04-24 00:00:00 | 2012-04-28 00:00:00 |  | Delta | [NAME] | SV | Customer |  |  |  | 425-C40TT | 425-11-32472 | Request to install Operator Extended Backrest that is modified to reach 64" vs. 60.7" (Same as S207 41591).
1680134 | 2012-04-24 00:00:00 | 2012-04-28 00:00:00 |  | US Air | Snoopy | SV | Customer |  | 65 |  | DSS-C35TT | S350-01476-97 | Customer requests authorization and part numbers to install LED work lights on the mast. Note: This truck does not have high speed aux.
1682026 | 2012-04-26 00:00:00 | 2012-05-02 00:00:00 |  | Delta | Linus | SO | Ga Sales | 90 | 65 | NF120008946 | 750-R35TT | 750-12-BA32252 | Change to Fwd. steering
1683963 | 2012-04-30 00:00:00 | 2012-05-23 00:00:00 |  | TWA | [NAME] | SV | Customer |  |  | NA | 537-CSR30T | 537-93-00584 | Customer requires authorization only to install [NAME] Pro 2.5# ABC fire extinguisher. See attached picture.
1685798 | 2012-05-02 00:00:00 | 2012-05-04 00:00:00 |  | Boeing | [NAME] | SO | Customer | 90 | 65 | NF120009392 NF120009393 | 540-OPC30TT | 540-12-C13616, 540-12-C13617 | #1: Add 10A aux power hookup kit pn 1092612/001. #2: Add Absopulse DC to DC converter model DCW 100-20FTRC-R0623. #3: [NAME] latitude toughbook model e6400 xfr.
1685863 | 2012-05-02 00:00:00 | 2012-05-02 00:00:00 |  | Boeing | [NAME] | SV | Customer |  |  | NF120009471 | 560-OPC30TT | 560-06-A01677 | Add operator sidegate switch kit on 114-900-SGD/KIT.
1688381 | 2012-05-07 00:00:00 |  |  | TWA | Linus | SO | Customer | 90 | 65 |  | 740-R35TT | 740-07-CB08491 | We need authorization only to add Shockswitch impact monitor system.
Spreadsheet: 843243d1695144248-different-number-of-periods-and-days-calculated-from-a-fixed-period-with-varying-years-different-number-of-periods-and-days_2
Sheet: Period

Period | Start |  | End
# | Day-Month-Year |  | Day-Month-Year
 |  | Cell names |  | Cell names
1 | 2021-04-02 00:00:00 | days_before_21 | 2021-04-01 00:00:00 | days_after_21
2 | 2022-04-02 00:00:00 | days_before_22 | 2022-04-01 00:00:00 | days_after_22
3 | 2023-04-02 00:00:00 | days_before_23 | 2023-04-01 00:00:00 | days_after_23
4 | 2024-04-02 00:00:00 | days_before_24 | 2024-04-01 00:00:00 | days_after_24
5 | 2025-04-02 00:00:00 | days_before_25 | 2025-04-01 00:00:00 | days_after_25
6 | 2026-04-02 00:00:00 | days_before_26 | 2026-04-01 00:00:00 | days_after_26
7 | 2027-04-02 00:00:00 | days_before_27 | 2027-04-01 00:00:00 | [NAME]
8 | 2028-04-02 00:00:00 | days_before_28 | 2028-04-01 00:00:00 | days_after_28
9 | 2029-04-02 00:00:00 | days_before_29 | 2029-04-01 00:00:00 | days_after_29
10 | 2030-04-02 00:00:00 | days_before_30 | 2030-04-01 00:00:00 | days_after_30
Spreadsheet: 701243d1603653628-productivity-tracker-how-can-i-work-out-a-running-average-that-considers-days-off-sampleproductivity
Sheet: Sheet1

 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00 | 2020-01-09 00:00:00 | 2020-01-10 00:00:00 | 2020-01-13 00:00:00 | 2020-01-14 00:00:00 | 2020-01-15 00:00:00 | 2020-01-16 00:00:00
Task | Minutes | Minutes | Minutes | Minutes | Minutes | Minutes | Minutes | Minutes | Minutes | Minutes | Minutes
Total Time (Hours) | 6.5 | 6 | 5.521 | 4.326424 | 3.0468475 | 5 | 0 | 0 | 6.7889798654 | 5.98894654 | 3.1216546512
Total Availability (Hours) | 7 | 7 | 7 | 5 | 3.5 | 7 | 0 | 0 | 7 | 7 | 3.5
Productivity %
Productivity % Per Week ([NAME])
Spreadsheet: 292243d1390531987-populate-table-from-database-with-2-conditions-book1
Sheet: Pivot

 |  | Locations | (All)
 |  | Conditions | Min | [NAME] | Avg
 |  | A | 0 | 5 | 0.9777777777777777
 |  | B | 0 | 6 | 1.51219512195122
 |  | C | 0 | 1 | 0.2380952380952381
 |  | Grand Total | 0 | 6 | 1.037383177570093
Spreadsheet: 866200d1713173642-titles-association-with-by-products-titles-association
Sheet: Φύλλο1

titles association table |  |  |  |  |  | τελικος πινακας
titles | byproduct | Quantity |  |  |  | titles | Quantity | byproduct | Quantity |  | in the frame is the final paper to be printed
συρταρι 1 | α | 1 |  |  |  | συρταρι 1 | 2 | a | 2
συρταρι 1 | β | 2 |  |  |  |  |  | b | 4
συρταρι 1 | γ | 1 |  |  |  |  |  | c | 2
συρταρι 1 | δ | 1 |  |  |  |  |  | d | 2
συρταρι 2 | q1 | 1 |  |  |  | συρταρι 2 | 5 | q1 | 5
συρταρι 2 | c | 2 |  |  |  |  |  | c | 10
συρταρι 2 | v | 1 |  |  |  |  |  | v | 5
Spreadsheet: 768687d1645083848-get-a-certain-data-across-a-row-but-within-the-range-of-a-merged-cell-data-from-merged-cell-ans
Sheet: Sheet1

Team A | a | 12
 | b | 34
 | c | 67
 | d | 23
 | Total
Team B | a | 12
 | b | 766
 | c | 3
 | d | 90
 | Total
 | Team B
Spreadsheet: 858757d1707322582-help-sumif-multiple-tabs-example1
Sheet: February Group

 | Name | Reference | Recall 1 | Recall 2 | Recall 3 | Successful Recall Date |  |  |  | Month Summary
 | Individual 15 | 04321 |  |  |  | 2024-05-01 00:00:00 |  |  |  |  |  | ( what results should show)
 | Individual 16 | 04322 |  |  |  | 2024-02-01 00:00:00 |  |  |  | Done Totals |  | 4 | (colum G, cells with a date)
 | Individual 17 | 04323
 | Individual 18 | 04324 |  |  |  |  |  |  |  | Outstanding Totals |  | 9 | (colum G, cells without a date)
 | Individual 19 | 04325
 | Individual 20 | 04326 |  |  |  | 2024-03-05 00:00:00
 | Individual 21 | 04327 |  |  |  | 2024-01-05 00:00:00
 | Individual 22 | 04328
 | Individual 23 | 04329
 | Individual 24 | 04330
 | Individual 25 | 04331
 | Individual 26 | 04332
 | Individual 27 | 04333
Spreadsheet: 749972d1633124610-data-is-not-transposing-book1
Sheet: Table1

Column1 | Attribute | Value
Q1 | R1 | 0.46783533917267
Q1 | R2 | 0.187575565716215
Q1 | R3 | 0.552558249228956
Q1 | R4 | 0.4436310457607
Q1 | R5 | 0.358815147586684
Q2 | R1 | 0.476867307086963
Q2 | R2 | 0.200256639997524
Q2 | R3 | 0.749306790517075
Q2 | R4 | 0.206739911408869
Q2 | R5 | 0.762618790748178
Q3 | R1 | 0.679318654126954
Q3 | R2 | 0.898629334808851
Q3 | R3 | 0.980475061508036
Q3 | R4 | 0.799328385123244
Q3 | R5 | 0.609527403049417
Q4 | R1 | 0.449345818198404
Q4 | R2 | 0.296126848040091
Q4 | R3 | 0.698960374525249
Q4 | R4 | 0.221188554385761
Q4 | R5 | 0.22680607256622
Q5 | R1 | 0.0502943972958849
Q5 | R2 | 0.365014779339361
Q5 | R3 | 0.285969285295807
Q5 | R4 | 0.763550126024676
Q5 | R5 | 0.988869675814098
Q6 | R1 | 0.480304271379405
Q6 | R2 | 0.84544973527621
Q6 | R3 | 0.233949626869995
Q6 | R4 | 0.767449072496473
Q6 | R5 | 0.0233482473310719
Q7 | R1 | 0.718393786309168
Q7 | R2 | 0.997157488955863
Q7 | R3 | 0.596263692495783
Q7 | R4 | 0.582823733330796
Q7 | R5 | 0.392482616065312
Q8 | R1 | 0.394966404821193
Q8 | R2 | 0.980348304951804
Q8 | R3 | 0.144722097578243
Q8 | R4 | 0.840050893822256
Q8 | R5 | 0.932078573908
Q9 | R1 | 0.555194633558157
Q9 | R2 | 0.651911910908476
Q9 | R3 | 0.280004395508052
Q9 | R4 | 0.886292054545315
Q9 | R5 | 0.552107433753716
Q10 | R1 | 0.325909117186121
Q10 | R2 | 0.0645866498717198
Q10 | R3 | 0.304838998327514
Q10 | R4 | 0.527292736814845
Q10 | R5 | 0.897554082009489
Q11 | R1 | 0.75730852166229
Q11 | R2 | 0.349065415231499
Q11 | R3 | 0.995922849355372
Q11 | R4 | 0.560550776298929
Q11 | R5 | 0.327436925459369
Q12 | R1 | 0.274260752506416
Q12 | R2 | 0.302123501049065
Q12 | R3 | 0.18822143486308
Q12 | R4 | 0.921605553746383
Q12 | R5 | 0.0793464800556507
Q13 | R1 | 0.845494337118837
Q13 | R2 | 0.852405904119265
Q13 | R3 | 0.933726762775104
Q13 | R4 | 0.025157442353512
Q13 | R5 | 0.668039471576648
Q14 | R1 | 0.328580383710044
Q14 | R2 | 0.606148230239031
Q14 | R3 | 0.942965797479091
Q14 | R4 | 0.389446789858226
Q14 | R5 | 0.61638601498837
Q15 | R1 | 0.826814684599467
Q15 | R2 | 0.0113355663313659
Q15 | R3 | 0.450679460047951
Q15 | R4 | 0.284416483453329
Q15 | R5 | 0.95763979224319
Q16 | R1 | 0.532877596580127
Q16 | R2 | 0.320317497617027
Q16 | R3 | 0.718280933569493
Q16 | R4 | 0.122225693220212
Q16 | R5 | 0.751757442567494
Q17 | R1 | 0.553112187644161
Q17 | R2 | 0.573525924090554
Q17 | R3 | 0.587729067136177
Q17 | R4 | 0.327807409160958
Q17 | R5 | 0.371436695635344
Q18 | R1 | 0.137218248241165
Q18 | R2 | 0.989595221405253
Q18 | R3 | 0.284198170398027
Q18 | R4 | 0.0879474377384535
Q18 | R5 | 0.898495173554313
Q19 | R1 | 0.490628514118326
Q19 | R2 | 0.881911403408743
Q19 | R3 | 0.966001084042007
Q19 | R4 | 0.612430253564778
Q19 | R5 | 0.823619092129139
Spreadsheet: 713594d1610819243-translating-multiple-column-index-to-other-work-sheets-film-tester-1-
Sheet: Genre

[NAME] | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
Gangster
Comedy
Rom-Com
Western
Romance
Sci-Fi
Historical
Action
Horror
Drama
Animated
Superhero
Thriller
Musical
Fantasy
Heist
[NAME]