tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814834d1674628964-formula-to-list-birthday-per-month-book1-21-
Sheet: Sheet1

Bitrh Date | Month | Day | Age | [NAME] |  |  | January |  | Month | January
2022-01-03 00:00:00 |  |  |  | Name Surname 01 |  | Day | Name
2004-05-30 00:00:00 |  |  |  | Name Surname 02
2007-02-13 00:00:00 |  |  |  | Name Surname 03 |  |  |  |  | Day | [NAME]
1981-07-07 00:00:00 |  |  |  | Name Surname 04 |  |  |  |  | 1900-01-03 00:00:00 | Name Surname 01
1976-06-24 00:00:00 |  |  |  | Name Surname 05 |  |  |  |  | 1900-01-12 00:00:00 | Name Surname 08
2004-06-08 00:00:00 |  |  |  | Name Surname 06 |  |  |  |  | 1900-01-14 00:00:00 | Name Surname 35
2015-08-21 00:00:00 |  |  |  | Name Surname 07 |  |  |  |  | 1900-01-16 00:00:00 | Name Surname 19
1987-01-12 00:00:00 |  |  |  | Name Surname 08 |  |  |  |  | 1900-01-21 00:00:00 | Name Surname 47
1985-06-11 00:00:00 |  |  |  | Name Surname 09 |  |  |  |  | Grand Total
2020-11-19 00:00:00 |  |  |  | Name Surname 10
2012-10-28 00:00:00 |  |  |  | Name Surname 11
2002-06-20 00:00:00 |  |  |  | Name Surname 12
2017-04-08 00:00:00 |  |  |  | Name Surname 13
1987-02-05 00:00:00 |  |  |  | Name Surname 14
2015-07-13 00:00:00 |  |  |  | Name Surname 15
1959-03-02 00:00:00 |  |  |  | Name Surname 16
1964-11-13 00:00:00 |  |  |  | Name Surname 17
1985-10-22 00:00:00 |  |  |  | Name Surname 18
1998-01-16 00:00:00 |  |  |  | Name Surname 19
1963-06-29 00:00:00 |  |  |  | Name Surname 20
1971-05-15 00:00:00 |  |  |  | Name Surname 21
1939-12-19 00:00:00 |  |  |  | Name Surname 22
2013-02-13 00:00:00 |  |  |  | Name Surname 23
1996-04-25 00:00:00 |  |  |  | Name Surname 24
2019-08-30 00:00:00 |  |  |  | Name Surname 25
1960-12-27 00:00:00 |  |  |  | Name Surname 26
1962-07-18 00:00:00 |  |  |  | Name Surname 27
2021-05-27 00:00:00 |  |  |  | Name Surname 28
1988-10-26 00:00:00 |  |  |  | Name Surname 29
1981-06-12 00:00:00 |  |  |  | Name Surname 30
2001-04-18 00:00:00 |  |  |  | Name Surname 31
2005-10-24 00:00:00 |  |  |  | Name Surname 32
2021-04-21 00:00:00 |  |  |  | Name Surname 33
2018-02-26 00:00:00 |  |  |  | Name Surname 34
1973-01-14 00:00:00 |  |  |  | Name Surname 35
1992-07-28 00:00:00 |  |  |  | Name Surname 36
1968-06-13 00:00:00 |  |  |  | Name Surname 37
2016-06-01 00:00:00 |  |  |  | Name Surname 38
2015-03-03 00:00:00 |  |  |  | Name Surname 39
1993-05-07 00:00:00 |  |  |  | Name Surname 40
1994-05-20 00:00:00 |  |  |  | Name Surname 41
1977-07-08 00:00:00 |  |  |  | Name Surname 42
1982-07-22 00:00:00 |  |  |  | Name Surname 43
1987-04-13 00:00:00 |  |  |  | Name Surname 44
1990-09-04 00:00:00 |  |  |  | Name Surname 45
1995-12-06 00:00:00 |  |  |  | Name Surname 46
1998-01-21 00:00:00 |  |  |  | Name Surname 47
1973-03-10 00:00:00 |  |  |  | Name Surname 48
1978-05-26 00:00:00 |  |  |  | Name Surname 49
Spreadsheet: 686438d1594628771-find-lookup-value-from-other-worksheet-ip-address
Sheet: Sheet1

Location | Region | Type | IP add Start | IP add End
Building 1 | North | CONVENT | 10.143.13.1 | 10.143.13.120
Building 2 | East | CONVENT | 10.148.30.1 | 10.148.30.254
Building 3 | South | CONVENT | 10.143.12.1 | 10.143.12.120
Building 4 | West | CONVENT | 10.150.16.1 | 10.150.16.254
Building 5 | West | CONVENT | 10.143.2.1 | 10.143.2.120
Building 6 | West | CONVENT | 10.143.11.128 | 10.143.11.255
Building 7 | West | CONVENT | 10.143.8.1 | 10.143.8.120
Building 8 | South | CONVENT | 10.143.16.128 | 10.143.16.255
Building 9 | South | CONVENT | 10.143.4.1 | 10.143.4.120
Building 10 | East | CONVENT | 10.143.7.128 | 10.143.7.255
Spreadsheet: 179004d1346984587-need-help-reorganizing-and-matching-data-entries-example-spreadsheet-result
Sheet: counselor_download

Last Name | First Name | College | App Attribute #1 | App Attribute #2
Dullop | [NAME] | H | 2 | Y |  | Name |  | First |  |  | Second |  |  | Third |  |  | Fourth |  |  | Fifth |  |  | Sixth |  |  | Seventh
Dullop | [NAME] | F | 4 | N |  | Dullop | [NAME]
Dullop | [NAME] | E | 4 | Y |  | Handell | [NAME]
Dullop | [NAME] | B | 4 | Y |  | Hurt | Cathy
Dullop | [NAME] | A | 2 | Y |  | [NAME] | Karin
Dullop | [NAME] | G | 4 | Y |  | Robins | [NAME]
Dullop | [NAME] | D | 4 | Y |  | Rogers | Timothy
Handell | [NAME] | D | 4 | Y |  | [NAME] | [NAME]
Handell | [NAME] | G | 4 | Y |  | Sanchez | [NAME]
Handell | [NAME] | C | 4 | Y |  | Smith | Sara
Handell | [NAME] | A | 2 | Y |  | Smith | Elvin
Handell | [NAME] | B | 4 | Y |  | And on
[NAME] | Karin | A | 2 | Y
Robins | [NAME] | A | 2 | N
Rogers | Timothy | A | 2 | Y
Sanchez | [NAME] | C | 4 | Y
Sanchez | [NAME] | G | 4 | N
Smith | Sara | A | 2 | Y
Smith | Sara | B | 4 | Y
Smith | Sara | C | 4 | Y
Smith | Sara | D | 4 | Y
Smith | Sara | E | 4 | Y
Smith | Elvin | A | 2 | Y
Spreadsheet: 867647d1714466049-need-attendace-sheet-for-saleman-visited-diffrent-regions-with-different-items-mega-matrix-aligw
Sheet: Sheet1

 |  | Salesman | Items | Region
 |  | Salesman101 | Item-1 | REG-1
 |  | Salesman101 | Item-2 | REG-3
 |  | Salesman101 | Item-3 | REG-3
 |  | Salesman111 | Item-1 | [NAME]
 |  | Salesman111 | Item-2 | REG-3
 |  | Salesman111 | Item-3 | REG-1
 |  | Salesman111 | Item-4 | REG-3
 |  | Salesman111 | Item-5 | REG-3
 |  | Salesman111 | Item-6 | [NAME]
 |  | Salesman111 | Item-7 | REG-3
 |  | Salesman111 | Item-8 | REG-5
 |  | Salesman111 | Item-9 | [NAME]
 |  | Salesman121 | Item-1 | REG-7
 |  | Salesman121 | Item-2 | REG-7
 |  | Salesman131 | Item-1 | REG-9
 |  | Salesamn141 | Item-1 | REG-10
 |  | Salesman141 | Item-2 | REG-10
 | Items | REG-1 | [NAME] | REG-3 | REG-4 | REG-5 | [NAME] | REG-7 | REG-8 | REG-9 | REG-10
Salesman101 | Item-1 | 0.3333333333333333
Salesman101 | Item-2 |  |  | 0.3333333333333333
Salesman101 | Item-3 |  |  | 0.3333333333333333
Salesman111 | Item-1 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-2 |  |  | 0.1111111111111111
Salesman111 | Item-3 | 0.1111111111111111
Salesman111 | Item-4 |  |  | 0.1111111111111111
Salesman111 | Item-5 |  |  | 0.1111111111111111
Salesman111 | Item-6 |  |  |  |  |  | 0.1111111111111111
Salesman111 | Item-7 |  |  | 0.1111111111111111
Salesman111 | Item-8 |  |  |  |  | 0.1111111111111111
Salesman111 | Item-9 |  |  |  |  |  | 0.1111111111111111
Salesman121 | Item-1 |  |  |  |  |  |  | 0.5
Salesman121 | Item-2 |  |  |  |  |  |  | 0.5
Salesman131 | Item-1 |  |  |  |  |  |  |  |  | 1
Salesamn141 | Item-1 |  |  |  |  |  |  |  |  |  | 1
Salesman141 | Item-2 |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Samir 

Dr.[NAME]03/2016 |  |  |  |  | Comments
Consultation | 19200
Delivery | 10000
Total Revenue
Clinics Fees 5%
Net Revenue
Dr. Percentage Consultation 50% | 9120
Dr. [NAME] 70% | 6650
Nifty Test (1,000 SR for co from each case) | 19300 |  |  |  | Discount is on doctor
Dr. [NAME] | 15300
Lab Referal | 0
Lab Referal 10%
Rania Compensation&Benefits Allowances | 2650 |  |  |  | 100 SR every new patient above 500 SR … 100 for each nifty test, 500 sr for each delivery.. Every time she attends 250 SR  ( to be covered 50-50 with patient,except nifty amount is all on doctor)
Net Payment
 |  |  | Doctor [NAME] ……………
Spreadsheet: 740359d1626291962-function-to-convert-numbers-in-to-binary-numbers-test1
Sheet: Sheet1

Table A |  |  |  |  |  | TableB
6 | 8 | 7 | 4566 |  |  | 2 | 2 | 1 | 2122 |  |  | Objective
7 | 568 | 19 | 8 |  |  | 1 | 122 | 11 | 2 |  |  | [NAME] all data from Table A to binary numbers 1 or 2
2 | 89 | 33 | 12 |  |  | 2 | 21 | 11 | 12 |  |  | Given
4 | 1236 | 3 | 4 |  |  | 2 | 1212 | 1 | 2 |  |  | Table has numbers 1 to 9
279 | 56 | 33 |  |  |  | 211 | 12 | 11 |  |  |  | Function to [NAME] all even numbers to 2 and all odd numbers to 1
1267 | 237 |  |  |  |  | 1221 | 211 |  |  |  |  | 1 will remain 1
167 | 26 | 33 |  |  |  | 121 | 22 | 11 |  |  |  | 2 will remain2
 | 345 | 137 | 8 |  |  |  | 121 | 111 | 2 |  |  | 3 will be converted to1
5 | 359 | 1 | 25 |  |  | 1 | 111 | 1 | 21 |  |  | 4 will be converted to 2
 | 15 | 379 | 26 |  |  |  | 11 | 111 | 22 |  |  | 5 will be converted to 1
247 | 16 | 33 |  |  |  | 221 | 12 | 11 |  |  |  | 6 will be converted to 2
57 | 368 | 37 |  |  |  | 11 | 122 | 11 |  |  |  | 7 will be converted to 1
 |  |  |  |  |  |  |  |  |  |  |  | 8 will be converted to 2
 |  |  |  |  |  |  |  |  |  |  |  | 9 will be converted to 1
 |  |  |  |  |  |  |  |  |  |  |  | Current method used
 |  |  |  |  |  |  |  |  |  |  |  | Select data in table A
 |  |  |  |  |  |  |  |  |  |  |  | Control+F
 |  |  |  |  |  |  |  |  |  |  |  | in find selction put "3" and select Replace put "1" and click "all"
 |  |  |  |  |  |  |  |  |  |  |  | repeat above replacing 3 by 4,5,6,7,8,9
Spreadsheet: 587036d1534797761-adding-data-to-new-sheets-from-main-sheet-example
Sheet: Pear

Pear | Dodge | Miami
Pear | BMW | Tusla | 468
Pear | Ford | Miami | 346
Pear | Chevy | Tusla | 235
Pear | Dodge | Bangor | 6
Pear | Dodge | Bangor | 357
Pear | GMC | New York City | 4
Spreadsheet: 270790d1381663652-index-match-with-date-range-criteria-tracking-form-formula
Sheet: Doc List

Latest version of Doc? | ID1 | ID2 |  |  | Doc |  | Type | [NAME] | Doc # | M amounts replaced by… | Date Replaced | GDN |  |  | Document Total Cost | [NAME] | Exp | Total | [NAME]
Yes | 512 | 512 |  |  | P512-1 |  | TB Fixed | TB WO | 79 |  |  | P512-1 |  |  | 5845.2
Yes | 308 | 128 |  |  | P308-128-0 |  | TB Fixed | TB WO | 72 | 72C2 | 2013-07-07 00:00:00 | P308-128 |  |  | 469648.83
Yes | 308 | 128 |  |  | P308-128-1 |  | TB Fixed | TB CR | 72C1 |  |  | P308-128 |  |  | 0
Yes | 308 | 128 |  |  | P308-128-2 |  | TB Fixed | TB CR | 72C2 | 72C3 | 2013-09-16 00:00:00 | P308-128 |  |  | 60930.01
Yes | 308 | 128 |  |  | P308-128-3 |  | TB Fixed | TB CR | 72C3 |  |  | P308-128 |  |  | 14776.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These formulas will be adjusted to reflect just the additional amounts on the CR doc types instead of the total
Spreadsheet: 1305aee5-2454-4427-9c7f-1ae08e992ba0
Sheet: 2 Membership Impact

2 | Membership Impact:  Experience positive growth in membership in the chapter over the previous year. [REQUIRED]
 |  | Grow membership by at least 1 |  |  | [NAME] | 75
 |  | Grow membership by at least 1% |  |  | Silver | 100
 |  | Grow membership by at least 13% |  |  | Gold | 200
 | Identify the Benchmark
 |  | What specific steps will the chapter take to grow membership in the chapter?
 | Plan Acheivement
 | Evaluate Success
 |  | Benchmark:
 |  | This year:
 |  |  | Growth (members):
 |  |  | Growth Percentage:
 |  | What actions were successful or unsuccessful in achieving growth?
 | Reflect on Achievement
 |  | What should the chapter change next year to achieve maximum growth?
 | Plan for Next Year
Spreadsheet: 266693d1379699490-formula-for-value-by-date-and-find-number-count-with-word-on-multiple-sheets-setup-exception-tracking-by-ae-example
Sheet: Lisa

Date | Company | Broker | Processor | [NAME]. Last | Loan # (Last 5) | Exception reason | Exceptions | Submissions | Exception %
2013-03-31 00:00:00 |  |  |  |  |  |  | 0 | 40
2013-04-17 00:00:00 | The Westside Mortgage Group | [NAME] | [NAME] | Weich | 37221 | paystub >30 & assets >45 | 1 | 48
2013-05-06 00:00:00 | The Westside Mortgage Group | [NAME] | [NAME] | Saul | 38306 | asset stmt missing pages
2013-05-13 00:00:00 | Giant Realty | [NAME] | [NAME] | Luu | 38829 | subject lease agreements
2013-05-30 00:00:00 | MaxReal | [NAME] | [NAME] | [NAME] | 39267 | missing 2yrs W2s
2013-05-30 00:00:00 | MaxReal Cupertino | [NAME] | [NAME] | Kopikare | 39281 | paystub >30 | 4 | 38
2013-06-03 00:00:00 | MaxReal | [NAME] | LuQiao | Nguyen | 39314 | missing prelim
2013-06-03 00:00:00 | The Westside Mortgage Group | [NAME] | [NAME] | Trobbe | 39253 | assets >45
2013-06-05 00:00:00 | MaxReal | [NAME] | [NAME] | [NAME] | 39386 | missing 2012 W2
2013-06-11 00:00:00 | MaxReal Cupertino | [NAME] | [NAME] | He | 39514 | missing prelim
2013-06-13 00:00:00 | The Westside Mortgage Group | [NAME] | [NAME] | Myles | 39576 | paystubs >30, 2 mos assets (Jumbo)
2013-06-18 00:00:00 | MaxReal | [NAME] | Minh Tran | [NAME] | 39655 | missing 2012 W2
2013-06-25 00:00:00 | MaxReal | [NAME] | [NAME] | [NAME] | 39852 | missing asset stmt
2013-06-28 00:00:00 | [NAME] Lending | [NAME] | [NAME] | [NAME] | 39942 | pay stub >30
2013-06-28 00:00:00 | The Westside Mortgage Group | [NAME] | [NAME] | [NAME] | 39934 | missing 2012 W2s
2013-06-28 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | 39900 | prelim & asset >45 | 10 | 32
2013-07-08 00:00:00 | The Westside Mortgage Group | [NAME] | [NAME] | Bitner | 40077 | missing 4506T
2013-07-24 00:00:00 | MaxReal | [NAME] | Le Tran | Engineer | 40443 | paystubs>30 & assets>45
2013-07-31 00:00:00 | Giant Realty Corporation | [NAME] | [NAME] | [NAME] | 40439 | missing asset pages | 3 | 34
2013-08-14 00:00:00 | [NAME] Lending | [NAME] | [NAME] | Trivedi | 40828 | missing asset stmt
2013-08-26 00:00:00 | Giant Realty, Inc. | [NAME] | [NAME] | Wang | 40870 | assets >45 | 2 | 44
2013-09-12 00:00:00 | [NAME] Lending | [NAME] | [NAME] | Varghese | 41255 | 1008 & TIL, missing W2s
Spreadsheet: 765521d1643372718-i-want-to-count-the-occurrences-of-unique-values-within-a-group-test_sheet_for_froum
Sheet: Sheet1

 | Group | ID |  |  |  |  |  | Unique values | Count of Unique Values within Group
 | Applejuice | 10 |  |  |  |  |  | 10
 | Applejuice | 11 |  |  |  |  |  | 11
 | Applejuice | 12 |  |  |  |  |  | 12
 | Applejuice | 12 |  |  |  |  |  | 13
 | Applejuice | 12
 | Applejuice | 11
 | Applejuice | 10
 | Applejuice | 10
 | Oranges | 13 |  |  |  |  |  | 10
 | Oranges | 10 |  |  |  |  |  | 11
 | Oranges | 10 |  |  |  |  |  | 12
 | Oranges | 12 |  |  |  |  |  | 13
 | Oranges | 12
 | Oranges | 13
 | Bananamilk | 11 |  |  |  |  |  | 10
 | Bananamilk | 11 |  |  |  |  |  | 11
 | Bananamilk | 11 |  |  |  |  |  | 12
 | Bananamilk | 11 |  |  |  |  |  | 13
 | Bananamilk | 11
 | Bananamilk | 12
 | Bananamilk | 10
 | Bananamilk | 13
 |  |  |  | Applejuice | Oranges | Bananamilk
 |  |  | 10 | 3 | 2 | 1
 |  |  | 11 | 2 | 0 | 5
 |  |  | 12 | 3 | 2 | 1
 |  |  | 13 | 0 | 2 | 1
 |  |  |  | 10 | 11 | 12 | 13
 |  |  | Applejuice | 3 | 2 | 3 | 0
 |  |  | Oranges | 2 | 0 | 2 | 2
 |  |  | Bananamilk | 1 | 5 | 1 | 1
Spreadsheet: jeff_dasovich__14084__Undercollection recovery rate analysis
Sheet: A-10

Tariff Analysis for Enron
 |  | A-10 (Primary Voltage)
 |  | Summer | Winter
Customer Charge ($/month) | $/Mo | 75 | 75
Facilities Charge ($/kW-mo) | $/kW-mo | 5.5 | 1.65
Demand Charge
Peak | $/kW-mo | 0 | 0
Part-Peak | $/kW-mo | 0 | 0
Off-Peak | $/kW-mo | 0 | 0
Energy Charge
Peak | $/kWh | 0.08915
Part-Peak | $/kWh | 0.08915 | 0.07279
Off-Peak | $/kWh | 0.08915 | 0.07279
Months in Season |  | 6 | 6 |  |  | Annual Load (MWh)
Load Factors |  |  |  |  |  | Summer | Winter | Total
Peak |  | 0.7 | 0.7
Part-Peak |  | 0.5 | 0.5
Off-Peak |  | 0.5 | 0.5
 |  |  |  |  | Total
Demand | MW | 0.1 | 0.1
Hours/period |  |  |  |  | Class [NAME] |  | MWh
Peak |  |  | 0
Part-Peak
Off-Peak
Total
Average Charges
Customer Charge ($/month) | $/mo
Facilities Charge ($/kW-mo) | $/mo
Demand Charge
Peak | $/mo
Part-Peak | $/mo
Off-Peak | $/mo
Energy Charge
Peak | $/mo
Part-Peak | $/mo
Off-Peak | $/mo
Total | $/mo
Average Rate | $/MWh
Average annual rate | $/MWh
Rate Multipliers/adders | $/MWh | 10 | 10
Current Rate | $/MWh
Average Annual Rate | $/MWh
Total Rate
Non-Gen Rate
[NAME]
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-8-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 270125d1381395170-conditional-formating-on-column-and-highlight-row-0a228
Sheet: Blad1

 | [NAME] | column2 | column3 | column4 |  | Testing column-delete it!!
 | 1 | blabla
 | 2 | test1
 | 3 | test3
 | 4 | test4
 | 5
 | 6
 | 8
 | 5
 | 5
 | 3 | test3
 | 5
 | 4 | test4
 | 2 | test1
 | 1 | blabla
 | 7
 | 8
 | 5
 | 6
 | 4 | test4
 | 2 | test1
 | 5
Spreadsheet: 791924d1660661262-change-many-column-in-one-row-i-have-to-use-something-else-than-transpose-tablenew
Sheet: Sheet1

Day | Time | 01-05-2022 | 02-05-2022 |  |  |  | Day | Time | Staff
 | Time 1 | 0 | 0 |  |  |  | 01-05-2022 | Time 1 | 0 | Day 1, 1st of May
 | Time 2 | 0 | 0 |  |  |  | 01-05-2022 | Time 2 | 0
 | Time 3 | 0 | 0 |  |  |  | 01-05-2022 | Time 3 | 0
 | Time 4 | 0 | 0 |  |  |  | 01-05-2022 | Time 4 | 0
 | Time 5 | 0 | 0 |  |  |  | 01-05-2022 | Time 5 | 0
 | Time 6 | 3 | 6 |  |  |  | 01-05-2022 | Time 6 | 3
 | Time 7 | 5 | 11 |  |  |  | 01-05-2022 | Time 7 | 5
 | Time 8 | 2 | 17 |  |  |  | 01-05-2022 | Time 8 | 2
 | Time 9 | 2 | 2 |  |  |  | 01-05-2022 | Time 9 | 2
 | Time 10 | 0 | 3 |  |  |  | 01-05-2022 | Time 10 | 0
 | Time 11 | 2 | 0 |  |  |  | 01-05-2022 | Time 11 | 2
 | Time 12 | 0 | 0 |  |  |  | 01-05-2022 | Time 12 | 0
 | Time 13 | 0 | 1 |  |  |  | 01-05-2022 | Time 13 | 0
 | Time 14 | 3 | 2 |  |  |  | 01-05-2022 | Time 14 | 3
 | Time 15 | 2 | 3 |  |  |  | 01-05-2022 | Time 15 | 2
 | Time 16 | 2 | 2 |  |  |  | 01-05-2022 | Time 16 | 2
 | Time 17 | 2 | 0 |  |  |  | 01-05-2022 | Time 17 | 2
 | Time 18 | 0 | 0 |  |  |  | 01-05-2022 | Time 18 | 0
 | Time 19 | 0 | 0 |  |  |  | 01-05-2022 | Time 19 | 0
 | Time 20 | 6 | 0 |  |  |  | 01-05-2022 | Time 20 | 6
 | Time 21 | 0 | 0 |  |  |  | 01-05-2022 | Time 21 | 0
 | Time 22 | 3 | 3 |  |  |  | 01-05-2022 | Time 22 | 3
 | Time 23 | 0 | 0 |  |  |  | 01-05-2022 | Time 23 | 0
 | Time 24 | 2 | 7 |  |  |  | 01-05-2022 | Time 24 | 2
 |  |  |  |  |  |  | 02-05-2022 | Time 1 | 0 | Day 2, 2nd of May
 |  |  |  |  |  |  | 02-05-2022 | Time 2 | 0
I have this tabe, day 1 in column C, day 2 in column D etc., coloured blue |  |  |  |  |  |  | 02-05-2022 | Time 3 | 0
I want to change it like yellow column and rows. |  |  |  |  |  |  | 02-05-2022 | Time 4 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 5 | 0
My task is change blue table to the yellow one. |  |  |  |  |  |  | 02-05-2022 | Time 6 | 6
 |  |  |  |  |  |  | 02-05-2022 | Time 7 | 11
My table has many days |  |  |  |  |  |  | 02-05-2022 | Time 8 | 17
 |  |  |  |  |  |  | 02-05-2022 | Time 9 | 2
 |  |  |  |  |  |  | 02-05-2022 | Time 10 | 3
 |  |  |  |  |  |  | 02-05-2022 | Time 11 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 12 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 13 | 1
 |  |  |  |  |  |  | 02-05-2022 | Time 14 | 2
 |  |  |  |  |  |  | 02-05-2022 | Time 15 | 3
 |  |  |  |  |  |  | 02-05-2022 | Time 16 | 2
 |  |  |  |  |  |  | 02-05-2022 | Time 17 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 18 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 19 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 20 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 21 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 22 | 3
 |  |  |  |  |  |  | 02-05-2022 | Time 23 | 0
 |  |  |  |  |  |  | 02-05-2022 | Time 24 | 7
Spreadsheet: 456553d1460941633-formula-to-sort-columns-instead-of-using-the-sort-button-sortingformula
Sheet: Sheet1

Original Item | Original Number |  | Sorted Item | Sorted Number |  | Example Sorted Item | Example Sorted Number
[NAME] | 22.2 |  |  |  |  | item3 | 111
item2 | 33.2 |  |  |  |  | item10 | 111
item3 | 111 |  |  |  |  | item8 | 55
item4 | 32.1 |  |  |  |  | [NAME] | 44
[NAME] | 32 |  |  |  |  | item6 | 39
item6 | 39 |  |  |  |  | item2 | 33.2
[NAME] | 44 |  |  |  |  | item9 | 33
item8 | 55 |  |  |  |  | item4 | 32.1
item9 | 33 |  |  |  |  | [NAME] | 32
item10 | 111 |  |  |  |  | [NAME] | 22.2
Spreadsheet: 846181d1697468351-multiply-value-from-the-drop-down-list-to-a-cell-quote-worksheet-draft-1-
Sheet: MQ

Board | Flooring | Rooms: | Extra: | Brd Size: | LM | PC | Caulking | 22.5 Deg
Skirting | Floating | B2 | BIL | 170-230 | 23 | 5
Trim | Floating | B2 | BIR |  | 56 | 6
Trim |  | Back Passage | Storage
 |  | Billard Table Room | WIL |  | 40
 |  | Dining | WIR
 |  | Hall
 |  | Kitchen
 |  | Lounge |  |  | 15
Skirting | Tile | MB |  |  |  |  |  |  |  |  |  |  | =IF(OR(E4="65-67"))*INDEX(Data!$E$7:F23)
 | Floating | Office
 |  | Pantry
 |  | Passage
 |  | Play Room
 |  | Sculary
 |  | Sitting
 |  | Threater
 |  | Total:
 |  | Total LM according to Profile
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 07 Oct 19 - 12 Oct 19

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2019-10-07 00:00:00 | 2019-10-08 00:00:00 | 2019-10-09 00:00:00 | 2019-10-10 00:00:00 | 2019-10-11 00:00:00 | 2019-10-12 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 07/10/2019 - 12/10/2019
Dameon | ✓ | ✓ | ✓ | ✓ | *** |  | 0.2 | 0.8 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | *** |  | 0.2 | 0.8 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | *** | ✓ |  | 0.2 | 0.8 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ❌ |  | 0.2 | 0.8 |  | [NAME] | ❌
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Nathan | ✓
[NAME] | A/L | A/L | A/L | A/L | A/L |  |  |  |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Daniel - Jaydee Roofing |  | ✓ |  | ✓ |  |  |  |  |  | Daniel - Jaydee Roofing | ✓
Sharn - Valley Art Roofing |  |  |  |  |  |  |  |  |  | Sharn - Valley Art Roofing
Edge Protection [NAME] |  |  | 07/10/2019 - 12/10/2019 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 07/10/2019 - 12/10/2019
Northlink |  |  | ✓ |  |  |  |  |  |  | Dameon | ❌
[NAME] |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
Blum |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Bunnings |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Stanbury |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Antigua |  |  | ✓ |  |  |  |  |  |  | Harley | ✓
Move |  |  | *** |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | N/A
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Daniel - Jaydee Roofing | ❌
 |  |  |  |  |  |  |  |  |  | Sharn - Valley Art Roofing
Spreadsheet: 735048d1622664787-need-to-get-quarter-wise-value-specific-cost-example123
Sheet: Sheet1

Service PO | PO Validity Start | PO Validity End | PO value (USD) | PO Month | [NAME] | JAS'19 | OND'19 | JFM'20
93455444 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | 2879.3289 |  |  |  |  | 0  - "not fall as per Po start & end Date" |  | 2019-04-01 00:00:00 |  |  | 2019-04-01 00:00:00 | 1
454444343 | 2020-02-06 00:00:00 | 2020-02-06 00:00:00 | 9671.56800364959 |  |  |  |  |  |  |  |  |  |  | 1
44444444 | 2020-07-01 00:00:00 | 2020-12-31 00:00:00 | 13781.98807401486 |  |  |  |  |  |  |  |  |  |  | 1
55454545 | 2020-08-26 00:00:00 | 2020-08-26 00:00:00 | 11855 |  |  |  |  |  |  |  |  |  |  | 2
345555444 | 2020-10-01 00:00:00 | 2020-12-31 00:00:00 | 5200.467203540903 |  |  |  |  |  |  |  |  |  |  | 2
77666666 | 2019-08-13 00:00:00 | 2019-08-13 00:00:00 | 31814.2872 |  |  |  |  |  |  |  |  |  |  | 2
23434343 | 2019-08-11 00:00:00 | 2019-08-11 00:00:00 | 32615.72508760061 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 2021-01-31 00:00:00 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4