tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1b5ee447-4fe6-44e4-81af-0774100d949b
Sheet: Sheet1

Last Name | First Name
[NAME] | [NAME]
Bailey | [NAME]
Bishop | [NAME]
Bishop | [NAME]
[NAME] | [NAME]
Burke | [NAME]
Camp | Constance
Chamblin | [NAME]
Coulter | Kelly
Cragg | [NAME]
Crump | [NAME]
Cryan | Travis
[NAME] | [NAME]
[NAME] | Holly
[NAME] | Ute
[NAME] | [NAME]
Gaskins | [NAME]
Heinen | [NAME]
Hill | Melvin
[NAME] | [NAME]
Killar | Celeste
Leath | [NAME]
Mackey | [NAME]
[NAME] | Kimberly
Morse | [NAME]
Parrish | [NAME]
Placino | Marv
Reed | [NAME]
Rodriguez | Selina
Ruane | [NAME]
Singer | [NAME]
Stokes | Tory
Tart | [NAME]
Teague | Heather
[NAME] | Colby
Spreadsheet: 86693d1286646576-stop-cell-from-calculating-and-save-value-october-2010-2-
Sheet: ORIGINAL

 |  | DAILY ACCOUNT BALANCES
 |  | For The Month Of: OCTOBER 2010
AS OF | 2010-10-09 00:00:00
 | CHECKS HELD |  | 44051
Work Day # | Date | CASH Balance | AVAIL CASH       = Col C + D5
 |  | 66696 | 110747
1 | 2010-10-01 00:00:00 | 420102 | 464153
2 | 2010-10-04 00:00:00 | 497666 | 541717
3 | 2010-10-05 00:00:00 | 77754 | 121805
4 | 2010-10-06 00:00:00 | 231078 | 275129
5 | 2010-10-07 00:00:00 | 120003 | 164054
6 | 2010-10-08 00:00:00 | 564333 | 608384
7 | 2010-10-11 00:00:00 | 0 | 44051
8 | 2010-10-12 00:00:00 | 0 | 44051
9 | 2010-10-13 00:00:00 | 0 | 44051
10 | 2010-10-14 00:00:00 | 0 | 44051
11 | 2010-10-15 00:00:00 | 0 | 44051
12 | 2010-10-18 00:00:00 | 0 | 44051
13 | 2010-10-19 00:00:00 | 0 | 44051
14 | 2010-10-20 00:00:00 | 0 | 44051
15 | 2010-10-21 00:00:00 | 0 | 44051
16 | 2010-10-22 00:00:00 | 0 | 44051
17 | 2010-10-25 00:00:00 | 0 | 44051
18 | 2010-10-26 00:00:00 | 0 | 44051
19 | 2010-10-27 00:00:00 | 0 | 44051
20 | 2010-10-28 00:00:00 | 0 | 44051
21 | 2010-10-29 00:00:00 | 0 | 44051
Spreadsheet: 74117d1274717988-excel-2007-need-a-formula-to-search-specific-worksheet-sample
Sheet: 6

SKU # | [NAME] | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE |  | Total
12456 | Chicken | 12 | 2010-05-15 00:00:00
Spreadsheet: 813679d1673918888-aggregate-values-to-a-table-from-a-data-set-with-a-specific-value-aggregate-1-
Sheet: ServiceNow import

ColA | ColB | ColC | ColD
 |  |  | INC2061265
 |  |  | INC2063535
 |  | OpenIncident | INC2064351
 |  | OpenIncident
 |  |  | INC1976642
 |  |  | INC1994551
 |  |  | INC2008551
 |  |  | INC2012167
 |  | OpenIncident | [NAME]
 |  |  | INC2018393
 |  |  | INC2019474
 |  |  | INC2029625
 |  |  | INC2033423
 |  |  | INC2037025
 |  | OpenIncident | INC2042424
 |  | OpenIncident | INC2043839
 |  |  | INC2044746
 |  |  | INC2062559
 |  |  | REQ2917031
 |  |  | REQ2988452
 |  | OpenRequest | REQ3051041
 |  | OpenRequest | REQ3074099
 |  |  | REQ2738452
 |  |  | [NAME]
 |  |  | REQ2946406
 |  |  | REQ2977292
 |  |  | REQ3021411
 |  | OpenRequest | REQ3076895
 |  |  | [NAME]
 |  |  | REQ2726456
 |  |  | REQ2727977
 |  |  | REQ2728937
Spreadsheet: 0fa571b0-303f-4a70-8f3d-027f20c3acce
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-10-11 09:37:27.370000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.657 | 101.532 | 101.407 | 101.032 |  | and are added to price quote
4.375 | 101.15 | 101.025 | 100.9 | 100.525
4.25 | 100.332 | 100.207 | 100.082 | 99.707 |  | Note: | Refer To Price [NAME]
4.125 | 99.911 | 99.786 | 99.661 | 99.286 |  |  | For all Price Adjs
4 | 99.442 | 99.317 | 99.192 | 98.567
3.875 | 98.841 | 98.716 | 98.591 | 97.966
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.154 | 101.029 | 100.904 | 100.529
3.75 | 100.599 | 100.474 | 100.349 | 99.974
3.625 | 100.164 | 100.039 | 99.914 | 99.539
3.5 | 99.824 | 99.699 | 99.574 | 99.199
3.375 | 99.373 | 99.248 | 99.123 | 98.498
3.25 | 98.825 | 98.7 | 98.575 | 97.95
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-25 09:37:27.370000
30 DAY | 2011-11-09 09:37:27.370000
45 DAY | 2011-11-24 09:37:27.370000
60 DAY | 2011-12-09 09:37:27.370000
90 DAY | 2012-01-08 09:37:27.370000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 479334d1473325826-sync-data-between-two-sheets-including-new-rows-that-are-added-example-workbook
Sheet: Sheet1

PRODUCT CODE | [NAME] | MISC INFO | MISC INFO | RETAIL PRICE | DISTRIBUTOR PRICE | TRADE PRICE | OTHER PRICE | OTHER PRICE
code 1 | description | info | info | 1.99 | 123 | 0.99 | 123 | 123
code 2 | description | info | info | 2.99 | 123 | 1.99 | 123 | 123
code 3 | description | info | info | 3.99 | 123 | 2.99 | 123 | 123
code 4 | description | info | info | 4.99 | 123 | 3.99 | 123 | 123
I need any new rows added on this sheet to automatically add to Sheet 2
Spreadsheet: 735825d1623196109-extract-unique-values-from-a-range-extract-unique-values-from-a-range
Sheet: Sheet1

1 | s | 3
1 | 3 | x |  |  | d | d | d | d | d | d | d | d
d | e | 4
g | g | 1
e | g | d
2 | 4 | 1
d | q | z
Spreadsheet: 46931d1245852938-looking-up-the-oldest-in-a-list-of-names-probleem-max_min
Sheet: max_min

 |  | Name | Age
 |  | Jan | 15 |  |  | Name | Oldest | Youngest | Average
 |  | Marcel | 25 |  |  | Jan | 31 | 15 | 23
 |  | [NAME] | 65 |  |  | Marcel | 60 | 25 | 42.5
 |  | Joop | 18 |  |  | [NAME] | 65 | 65 | 65
 |  | [NAME] | 43 |  |  | Joop | 18 | 18 | 18
 |  | [NAME] | 52 |  |  | [NAME] | 43 | 21 | 32
 |  | [NAME] | 74 |  |  | [NAME] | 52 | 15 | 33.5
 |  | Yves | 12 |  |  | [NAME] | 74 | 52 | 63
 |  | Tristan | 5 |  |  | Yves | 75 | 12 | 43.5
 |  | France | 40 |  |  | Tristan | 23 | 5 | 14
 |  | Helga | 43 |  |  | France | 80 | 40 | 60
 |  | Sabine | 47 |  |  | Helga | 43 | 43 | 43
 |  | [NAME] | 43 |  |  | Sabine | 47 | 5 | 26
 |  | Jan | 31 |  |  | [NAME] | 55 | 43 | 49
 |  | Marcel | 60
 |  | [NAME] | 21
 |  | [NAME] | 15
 |  | Tristan | 23
 |  | Sabine | 5
 |  | [NAME] | 55
 |  | [NAME] | 52
 |  | France | 80
 |  | Yves | 75
Spreadsheet: 449407d1457138573-breaks-lunch-counter-copy-of-breakscounterv2-3-ndm
Sheet: Sheet2

DATE | NAME | FIRST BREAK | LUNCH | SECOND BREAK
2016-03-03 00:00:00 | Name 1 | 13:30:00 | 15:45:00
2016-03-03 00:00:00 | Name 2 | 14:55:00 | 11:30:00
2016-03-03 00:00:00 | Name 3 | 15:30:00 | 09:01:00 | 16:45:00
2016-03-03 00:00:00 | Name 4 | 23:50:00 | 14:50:00
2016-03-03 00:00:00 | Name 5
2016-03-03 00:00:00 | Name 6
2016-03-03 00:00:00 | Name 7
2016-03-03 00:00:00 | Name 8
2016-03-03 00:00:00 | Name 9
2016-03-03 00:00:00 | Name 10
2016-03-03 00:00:00 | Name 11
2016-03-03 00:00:00 | Name 12
2016-03-03 00:00:00 | Name 13
2016-03-03 00:00:00 | Name 14
2016-03-03 00:00:00 | Name 15
2016-03-03 00:00:00 | Name 16 | 10:13:00 | 12:00:00 | 14:30:00
Spreadsheet: 275282d1383431366-how-can-i-sum-up-values-corresponding-to-a-specific-serial-number-inksured-2nd-attempt-1
Sheet: Transaction Details

Date | Roll No. | Name | No. of Prints | Paper | Color/ B&W | Rate | Due | Paid | Balance |  | sumif | sumproduct
 | 2013048 |  | 5 | Regular | Colour |  |  | 15
 | 2013052 |  | 15 | Bond | B&W |  |  | 50
 | 2013021 |  | 10 | [NAME] | Colour |  |  | 400
 | 2013047 |  | 5 | Glossy A4 | B&W |  |  | 110
 | 2013048 |  | 5 | Regular | B&W |  |  | 10
 | 2013007 |  | 10 | Regular | B&W |  |  | 15
 | 2013052 |  | 10 | Bond | Colour |  |  | 70
 | 2013092 |  | 40 | Regular | B&W |  |  | 80
 | 2013048 |  | 30 | Glossy A4 | Colour |  |  | 1000
 | 2013002 |  | 10 | Regular | Colour
 | 2013007 |  | 5 | Regular | B&W |  |  | 10
 | 2013002 |  | 10 | Regular | Colour
 | 2013002 |  | 10 | Bond | Colour |  |  | 30
 | 2013002 |  | 10 | Glossy A4 | B&W |  |  | 150
 | 2013048 |  | 5 | [NAME] | Colour |  |  | 200
 |  |  |  |  |  |  |  |  |  | subtotal (use filter)
Date | Roll No. | Name | No. of Prints | Paper | Color/ B&W | Rate | Due | Paid | Balance
 | 2013048 |  | 5 | Regular | Colour |  |  | 15
 | 2013052 |  | 15 | Bond | B&W |  |  | 50
 | 2013021 |  | 10 | [NAME] | Colour |  |  | 400
 | 2013047 |  | 5 | Glossy A4 | B&W |  |  | 110
 | 2013048 |  | 5 | Regular | B&W |  |  | 10
 | 2013007 |  | 10 | Regular | B&W |  |  | 15
 | 2013052 |  | 10 | Bond | Colour |  |  | 70
 | 2013092 |  | 40 | Regular | B&W |  |  | 80
 | 2013048 |  | 30 | Glossy A4 | Colour |  |  | 1000
 | 2013002 |  | 10 | Regular | Colour
 | 2013007 |  | 5 | Regular | B&W |  |  | 10
 | 2013002 |  | 10 | Regular | Colour
 | 2013002 |  | 10 | Bond | Colour |  |  | 30
 | 2013002 |  | 10 | Glossy A4 | B&W |  |  | 150
 | 2013048 |  | 5 | [NAME] | Colour |  |  | 200
pivot table:
Row Labels | Name | Sum of Balance
2013002 | ABHIJIT KUNDU | 180
2013007 | ABIRBIRA SAMAL | 5
2013021 | AKSHITA SHARMA | 50
2013047 | ANUBHAV MALIK | -10
2013048 | ANUJ KUMBHAT | 85
2013052 | ASHAJYOTI PARIDA | -15
2013092 | DHRUV PAHWA | 0
Grand Total |  | 295
Spreadsheet: 169444d1342845535-look-up-2-value-and-return-1-data-look-up-2-cells-value-return-1-data
Sheet: Sheet1

Model | 4 Pole | [NAME]
 | kW | Inlet | Outlet
50*32-160 | 0.55 | 50 | 32
50*32-200 | 0.55 | 50 | 32
50*32-200 | 0.75 | 50 | 32
50*32-200 | 1.1 | 50 | 32
65*50-160 | 0.55 | 65 | 50
65*50-160 | 0.75 | 65 | 50
65*40-200 | 0.55 | 65 | 40
65*40-200 | 0.75 | 65 | 40
65*40-200 | 1.1 | 65 | 40
65*40-200 | 1.5 | 65 | 40
 | Model | kW | expected return data
Input field | 65*50-160 | 0.55 | 65
Spreadsheet: 112175d1308306118-data-validation-of-unique-values-data-validation
Sheet: Validation

Name
N1 | B1 | Validation
N2
N3
N1
N2
N3
B1
B1
A
A
Spreadsheet: 163142d1340204898-creating-a-dynamic-pivot-graph-data-pulled-from-severa-tabs-updated-weekly-dummy-file-pge-project
Sheet: Metro

dummy | A | dummy | dummy | B | C | F | G | dummy | dummy | dummy
x | metro 1a | x | x | metro 1b | metro 1c | metro 1f | metro 1g | x | x | x
x | metro 2a | x | x | metro 2b | metro 2c | metro 2f | metro 2g | x | x | x
x | metro 3a | x | x | metro 3b | metro 3c | metro 3f | metro 3g | x | x | x
x | metro 4a | x | x | metro 4b | metro 4c | metro 4f | metro 4g | x | x | x
Spreadsheet: 727612d1617980952-date-in-cells-as-criteria-range-in-sumifs-but-formula-is-not-picking-it-based-on-criteria-sales-by-product-montly-3-
Sheet: Summary

 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00
Forno Toscano Margherita - Anthrocite
Forno Toscano [NAME]
Forno Toscano Margherita - Stainless
Margherita Gas Oven Anthracite
[NAME]
Margherita Gas [NAME]
Forno [NAME]
Forno [NAME]
Forno Toscano Marinara - Stainless
Forno [NAME]
Forno Toscano Mangia Fuoco - Red
Forno Toscano Mangiafuoco - Stainless
Mangiafuoco Gas Anthracite
Forno Toscano Mangiafuoco GAS Red
Forno Toscano Mangiafuoco Gas Stainless
Spreadsheet: 719434d1613662554-drag-on-indirect-columns-esempio-1-
Sheet: BBB

AAA | BBB
 | Nome | Pro | + | - | TOT
 | F5 | M777 | 100 | 20
 | Totali
Spreadsheet: 129890d1321963846-automatically-format-only-those-month-cells-that-are-3-months-ahead-of-chosen-month-111122-example-conditional-formatting-month
Sheet: Sheet1

Launch month | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
 | January | February | March | April | May | June | July | August | September | October | November | December
April
I want to make it look like this if one picks April as a launch month
Launch month | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
 | January | February | March | April | May | June | July | August | September | October | November | December
April
I want to make it look like this if one picks November  as a launch month
Launch month | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
 | January | February | March | April | May | June | July | August | September | October | November | December
November
Launch month | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 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
Spreadsheet: 172813d1344345606-string-of-text-representing-an-array-in-one-cell-vlookup-each-item-create-new-string-example-data-1-
Sheet: Sheet1

Model / Part No | ID | Related Products by Code | Related Products by ID (14:10:12:23 etc)
E11060C | 1 | E11070C, E882615, E882921, E882923, E882924, E11090, E11085, E11092, X000159 | X000159
E11070C | 2 | E11060C, E882615, E882921, E882923, E882924, E11090, E11085, E11092, X000159 | X000159
E11085 | 3 | E11060C, E11070C, E11090, E11092, E87420, E87055, E85118 | 1:2:4:5:22:21:15
E11090 | 4 | E11060C, E11070C, E11085, E11092, E87420, E87055, E85118 | 1:2:3:5:22:21:15
E11092 | 5 | E11060C, E11070C, E11085, E11090, E87420, E87055, E85118 | 1:2:3:4:22:21:15
E13104 | 6 | E13200, E13115, E13125, E13111, E13108, E13220, E13240, E85301, E85300, E85323, E85302, E85315 | 12:10:11:8:7:13:14:17:16:20:18:19
E13108 | 7 | E13200, E13104, E13115, E13200, E13111, E13220, E13240, E85301, E85300, E85323, E85302, E85315 | 12:6:10:12:8:13:14:17:16:20:18:19
E13111 | 8 | E13200, E13104, E13115, E13200, E13108, E13220, E13240, E85301, E85300, E85323, E85302, E85315 | 12:6:10:12:7:13:14:17:16:20:18:19
[NAME] | 9 | E13200, E13115, E13125, E13111, E13108, E13220, E13240, E85301, E85300, E85323, E85302, E85315 | 12:10:11:8:7:13:14:17:16:20:18:19
E13115 | 10 | E13200, E13104, E13125, E13111, E13108, E13220, E13240, E85301, E85300, E85323, E85302, E85315 | 12:6:11:8:7:13:14:17:16:20:18:19
E13125 | 11 | E13200, E13104, E13115, E13111, E13108, E13220, E13240, E85301, E85300, E85323, E85302, E85315 | 12:6:10:8:7:13:14:17:16:20:18:19
E13200 | 12 | E13220, E13104, E13115, E13111, E13108, E13125, E13240, E85301, E85300, E85323, E85302, E85315 | 13:6:10:8:7:11:14:17:16:20:18:19
E13220 | 13
E13240 | 14
E85118 | 15
E85300 | 16
E85301 | 17
E85302 | 18
E85315 | 19
E85323 | 20
E87055 | 21
E87420 | 22
E882615 | 23
E882921 | 24
E882923 | 25
E882924 | 26
Spreadsheet: 168468d1342465390-excel-2007-conditional-formatting-with-icons-sets-and-4-scenarios-financial-dashboard
Sheet: Financial Dashboard

 | ASSETS
2012-01-01 00:00:00 | 180000000 |  | Budget or Better
2012-02-01 00:00:00
2012-03-01 00:00:00 |  |  | < Budget & < Variance
2012-04-01 00:00:00
2012-05-01 00:00:00 |  |  | YTD Variance > or = 25%
2012-06-01 00:00:00
2012-07-01 00:00:00 |  |  | [NAME] or = 10%
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
 | ASSETS
 | 10% V TO BUD
JAN Low
JAN Budget
JAN High
Feb Low
Feb Budget
Feb High
[NAME]
[NAME]
[NAME]
Apr Low
Apr Budget
Apr High
May Low
May Budget
May Hight
[NAME]
[NAME]
[NAME]
Jul Low
Jul Budget
Jul High
Aug Low
Aug Budget
Aug High
Sep Low
Sep Budget
Sep High
Oct Low
Oct Budget
Oct High
Nov Low
Nov Budget
Nov High
Dec Low
Dec Budget
Dec High
 | 163015000
 | 163113000
 | 163250000
 | 163375000
 | 163516000
 | 163649000
 | 163801000
 | 163951000
 | 164093000
 | 164253000
 | 164394000
 | 164558000
Spreadsheet: 100740d1299001499-index-match-and-return-adjacent-cell-or-workaround-costs-and-rates-example
Sheet: Rate Card

Terms> | UK |  |  | Europe |  |  | USA
Suppliers | Price | Per | Min. Hire | Price | Per | Min Hire | Price | Per | Min.Hire
SupplierA | 20 | Day | 100 | 30 | Day | 150 | Etc. | Etc. | Etc.
SupplierB | 175 | Week | 350 | 200 | Week | 350 | Etc. | Etc. | Etc.
Spreadsheet: 808454d1670478175-task-required-based-on-frequency-occurrence-hd-1
Sheet: Sheet1

Room | Start date | End date |  | Rooms to be cleaned today
1 | 2022-11-24 00:00:00 | 2022-12-05 00:00:00
2 | 2022-11-25 00:00:00 | 2022-12-07 00:00:00
3 | 2022-11-26 00:00:00 | 2022-12-09 00:00:00
4 | 2022-11-26 00:00:00 | 2022-12-07 00:00:00
5 | 2022-11-27 00:00:00 | 2022-12-11 00:00:00
6 | 2022-11-28 00:00:00 | 2022-12-13 00:00:00
7 | 2022-11-29 00:00:00 | 2022-12-15 00:00:00
8 | 2022-11-30 00:00:00 | 2022-12-17 00:00:00
9 | 2022-12-01 00:00:00 | 2022-12-19 00:00:00
10 | 2022-12-02 00:00:00 | 2022-12-21 00:00:00
11 | 2022-12-03 00:00:00 | 2022-12-23 00:00:00
12 | 2022-12-04 00:00:00 | 2022-12-25 00:00:00
13 | 2022-12-04 00:00:00 | 2022-12-07 00:00:00
14 | 2022-12-05 00:00:00 | 2022-12-27 00:00:00
15 | 2022-12-06 00:00:00 | 2022-12-29 00:00:00
16 | 2022-12-07 00:00:00 | 2022-12-31 00:00:00
17 | 2022-12-08 00:00:00 | 2023-01-02 00:00:00
18 | 2022-12-09 00:00:00 | 2023-01-04 00:00:00
19 | 2022-11-16 00:00:00 | 2022-12-02 00:00:00
20 | 2022-11-17 00:00:00 | 2022-12-03 00:00:00
21 | 2022-11-18 00:00:00 | 2022-12-04 00:00:00
22 | 2022-11-19 00:00:00 | 2022-12-05 00:00:00
23 | 2022-11-20 00:00:00 | 2022-12-06 00:00:00
24 | 2022-11-16 00:00:00 | 2022-12-07 00:00:00
25 | 2022-11-17 00:00:00 | 2022-12-08 00:00:00
26 | 2022-11-18 00:00:00 | 2022-12-09 00:00:00
27 | 2022-11-19 00:00:00 | 2022-12-10 00:00:00
28 | 2022-11-20 00:00:00 | 2022-12-11 00:00:00
Spreadsheet: 64052d1264909056-employees-project-report-summary-explain-new
Sheet: John

Here where the description is the employees will be putting the name of the project that they are working on and every week they will be using a different spreadsheet (some examples are displayed below) They will be located between A13:A18 in all worksheets and workbooks. | in this column the employee will put the amount of hours that had to spent on Monday on the projects | in this column the employee will put the amount of hours that had to spent Tuesday on the projects | in this column the employee will put the amount of hours that had to spent On Wedn on the projects | in this column the employee will put the amount of hours that had to spent on thursday on the projects | in this column the employee will put the amount of hours that had to spent on Friday on the projects | In the final colom will be the total of the amount of hours that was spent for a project for a week. This sum will be located ONLY on G13:G18 in all the worksheets and workbooks
[NAME]
Description |  |  |  |  |  | Total
 | Hours | Hours | Hours | Hours | Hours
 | Monday | Tuesday | Wednesday | Thursday | Friday
CR001 | 2 |  | 2 |  | 1 | 5 | this number in cell G13 tells us that [NAME] spent 5 hours in total on project CR001 for this week
CR004 | 3 | 3 | 2 | 3 | 4 | 15 | this number in cell G14 tells us that [NAME] spent 15 hours in total on project CR004 for this week
 |  |  |  |  |  | 0
CR005 |  | 2 |  | 1 | 2 | 5 | this number in cell G16 tells us that [NAME] spent 5 hours in total on project [NAME] for this week
CR002 | 3 | 1.5 | 2 | 1 |  | 7.5 | this number in cell G17 tells us that [NAME] spent 7.5 hours in total on project CR002 for this week
CR010 |  | 1 | 2 | 1 | 1 | 5 | this number in cell G18 tells us that [NAME] spent 5 hours in total on project [NAME] for this week
Spreadsheet: 94082d1293908439-summery-on-each-change-rqed-output
Sheet: REQUIRED OUTPUT

NAME | GRADE | ITEM | RATE | BANKER
FORGE INFOSYS | A1 | 200 | 4521 | AMINO AMRO
FORGE INFOSYS | A1 | 200 | 4521 | AMINO AMRO
FORGE INFOSYS | A1 | 50 | 2455 | AMINO AMRO
FORGE INFOSYS | A1 | 10 | 2455 | AMINO AMRO
FORGE INFOSYS | A1 | 60 | 2455 | AMINO AMRO
FORGE INFOSYS | A2 | 20 | 4521 | AMINO AMRO
FORGE INFOSYS | A2 | 20 | 4521 | AMINO AMRO
FRNACIS CEMENT CO | A1 | 30 | 5000 | ROYAL BANK
FRNACIS CEMENT CO | A2 | 30 | 5000 | ROYAL BANK
FRNACIS CEMENT CO | A1 | 50 | 3200 | ROYAL BANK
FRNACIS CEMENT CO | A1 | 100 | 3200 | ROYAL BANK
FRNACIS CEMENT CO | A1 | 180 | 3200 | ROYAL BANK
FRNACIS CEMENT CO | A2 | 50 | 2155 | ROYAL BANK
FRNACIS CEMENT CO | A2 | 50 | 2155 | ROYAL BANK
FRNACIS CEMENT CO | A2 | 100 | 2155 | ROYAL BANK
HIMALYA STEEL CEMENT | A1 | 100 | 3300 | USA BANK
HIMALYA STEEL CEMENT | A1 | 200 | 3300 | USA BANK
HIMALYA STEEL CEMENT | A1 | 200 | 3300 | USA BANK
HIMALYA STEEL CEMENT | A1 | 100 | 3300 | USA BANK
HIMALYA STEEL CEMENT | A1 | 600 | 3300 | USA BANK
HIMALYA STEEL CEMENT | A3 | 300 | 4000 | USA BANK
HIMALYA STEEL CEMENT | A3 | 300 | 4000 | USA BANK
ICCHAMANI SUPPLIER | A3 | 100 | 3200 | ROYAL BANK
ICCHAMANI SUPPLIER | A3 | 100 | 3200 | ROYAL BANK
K K INFOSYS | A1 | 100 | 3000 | ROYAL BANK
K K INFOSYS | A1 | 200 | 3000 | ROYAL BANK
K K INFOSYS | A1 | 300 | 3000 | ROYAL BANK
K K INFOSYS | A2 | 300 | 4000 | ROYAL BANK
K K INFOSYS | A2 | 100 | 4000 | ROYAL BANK
K K INFOSYS | A2 | 200 | 4000 | ROYAL BANK
K K INFOSYS | A2 | 600 | 4000 | ROYAL BANK
LUKAS STEEL | A1 | 300 | 3000 | USA BANK
LUKAS STEEL | A1 | 100 | 3000 | USA BANK
LUKAS STEEL | A1 | 200 | 3000 | USA BANK
LUKAS STEEL | A1 | 600 | 3000 | USA BANK
REQUIRED OUTPUT IS SUM OF ITEMS ON CHANGE OF EACH NAME ,GRADE AND RATE AS SHOWN IN YELLOW STRIP
Spreadsheet: 794287d1661964599-create-list-from-data-on-other-sheets-compile
Sheet: Blue Team

First Name | Last Name | ID | [NAME]
Rachel | Smith | 4179 | 1x
[NAME] | Hyatt | 5112 | 2x
[NAME] | Fry | 9636 | 2x
Adam | West | 2287 | 2x
[NAME] | Crow | 5133 | 3x
[NAME] | Servo | 1010 | 1x
Joel | Hodgson | 9999 | 2x
Spreadsheet: 777442d1650381766-how-can-you-give-back-a-value-when-it-might-not-be-the-first-to-be-shown-question-ellen
Sheet: question

name | items | tag |  |  | result | tag
ellen | 1 |  |  |  | ellen | [NAME]
ellen | 2 | [NAME] |  |  | [NAME] | blie
[NAME] | 3 | blie |  |  | Bianca | bloe
[NAME] | 4 |  |  |  | emiel | blue
Bianca | 5
Bianca | 6 | bloe
emiel | 7 | blue
emiel | 8