tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 33765d1230548302-problem-buidling-if-statement-excel-help-forum
Sheet: Analysis Table

Month-Year |  | Maintenance | Maintenance | Maintenance | Maintenance
 | Total Audits | Open | Closed | Overdue | Extended
2007-12-31 00:00:00 |  | #N/A | #N/A
2008-01-07 00:00:00 |  | #N/A | #N/A
2008-01-14 00:00:00 |  | #N/A | #N/A
2008-01-21 00:00:00 |  | #N/A | #N/A
2008-01-28 00:00:00 |  | #N/A | #N/A
2008-02-04 00:00:00 |  | #N/A | #N/A
2008-02-11 00:00:00 |  | #N/A | #N/A
2008-02-18 00:00:00 |  | #N/A | #N/A
2008-02-25 00:00:00 |  | #N/A | #N/A
2008-03-03 00:00:00 |  | #N/A | #N/A
2008-03-10 00:00:00 |  | #N/A | #N/A
2008-03-17 00:00:00 |  | #N/A | #N/A
2008-03-24 00:00:00 |  | #N/A | #N/A
2008-03-31 00:00:00 |  | #N/A | #N/A
2008-04-07 00:00:00 |  | #N/A | #N/A
2008-04-14 00:00:00 |  | #N/A | #N/A
2008-04-21 00:00:00 |  | #N/A | #N/A
28/04/2008 |  | #N/A | #N/A
 |  |  |  |  | Chart Value
1-2008 | 17 | 0
2-2008 | 0 |  |  |  |  | 0
3-2008 | 0
4-2008 | 0
5-2008 | 0
6-2008 | 0
7-2008 | 0
8-2008 | 0
9-2008 | 0
10-2008 | 0
11-2008 | 0
12-2008 | 0
1-2009 | 0
2-2009 | 0
3-2009 | 0
4-2009 | 0
5-2009 | 0
6-2009 | 0
7-2009 | 0
8-2009 | 0
9-2009 | 0
10-2009 | 0
11-2009 | 0
12-2009 | 0
1-2010 | 0
2-2010 | 0
3-2010 | 0
4-2010 | 0
5-2010 | 0
6-2010 | 0
7-2010 | 0
8-2010 | 0
9-2010 | 0
10-2010 | 0
11-2010 | 0
12-2010 | 0
Spreadsheet: 775347d1649053625-merge-worksheets-into-one-book1_pq
Sheet: Sheet1

Year | Emp Dept ID | First Name | Last Name | Area | Performance
2021 | 1 | [NAME] | Amber | Customer Support | 30
2021 | 2 | [NAME] | Toi | Data | 15
2021 | 3 | [NAME] | Pane | Customer Support | 90
2021 | 4 | [NAME] | Pan | International | 99
2021 | 5 | [NAME] | [NAME] | Data | 10
Spreadsheet: 872938d1719399103-calculate-total-for-a-group-test-calc
Sheet: Sheet1

GROUP BY | [NAME] | Yield | Sum
Test 1 | A | 0.33 | 0.43
Test 1 | B | 0.1 | 0.43
Test 2 | C | 0.49 | 0.55
Test 2 | D | 0.06 | 0.55
Test 3 | E | 0.34 | 0.5
Test 3 | F | 0.08 | 0.5
Test 3 | G | 0.08 | 0.5
Spreadsheet: 84497d1284550320-excel-2007-vat-code-credit-note-log
Sheet: Sheet1

CREDIT NOTE LOG
Company Name | Credit Number | Part Number | Qty | Unit Cost | VAT Code | VAT | Total Credit Cost
Sample | 0 | 0 | 10 | 10
Spreadsheet: 168338d1342410147-formula-to-calculate-if-employee-is-working-on-each-half-hour-rota
Sheet: Calculation

Time | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00 | 1900-01-01 00:30:00 | 1900-01-01 01:00:00 | 1900-01-01 01:30:00 | 1900-01-01 02:00:00
[NAME]
[NAME]
[NAME]
Total Workers
Spreadsheet: 863876d1711271055-google-sheet-function-to-excel-2016-function-stock-portfolio-tracking-spreadsheet-11
Sheet: Ref

Stock Category | Transaction Category | REIT Category | Price [NAME] | USD to SGD
Dividend | Buy | Hospitality | 0.02
Growth | Sell | Industrial
Special Situation | Div | Healthcare
Value | Split | Apartment
Watch | Fee | Commercial
 |  | Retail
Spreadsheet: 483525d1475696893-carton-of-250-help-copamzorder
Sheet: BOL

 | [NAME] of Lading
SHIPPER |  | RECEIVER
Customer: | DTX International Inc. | BOL#:
Carrier: |  | WH #:
Shipper: | DTX International Inc. | Consignee:
Address |  | Address:
City, State, ZIP: |  | City, State, ZIP:
Contact: | [NAME] | Contact:
Phone: | [PHONE] | Telephone:
Ship Date: |  | Delivery Date:
Pkgs # | Description of Goods |  |  | SKIDS | WEIGHT
 | Appointment ID:
 | Appointment Date:
 | Appointment Time:
 | Appointment Dock:
 | Amazon FBA/PO Number:
RECEIVED, subject to the classifications and tariffs in effect on the date of the issue of this Bill of Lading, the property described above is in apparent good order except as noted (contents and condition of contents of packages unknown), marked, consigned, and destined as indicated above which said carrier (the word carrier being understood throughout this contract as meaning any person or corporation in posession of the property under the contract) agrees to carry to its usual place of delivery at said destination, if on its route, otherwise to deliver to another carrier on the route to said destination. It is mutually agreed as to each carrier of all or any of said property over all or any portion of said route to destination and as to each party at any time interested in all or any said property that every service to be performed hereunder shall be subject to all the bill of lading terms and conditions in the governing classification on the date of shipment.
The Property described above is received in apparent good order, except as noted. |  | Freight Charges are: Collect
Receiver Signature:
NOTES:
Spreadsheet: 491649d1480586228-sort-array-formula-results-in-descending-order-sort-array-formula-results-in-descending-order
Sheet: PS_DROP DOWN LISTS DATA

MANUFACTURE LOCATION |  | DEILVERY TYPE |  | DRIVER |  | TRANSPORT |  | DELIVERY No. |  | CLIENT LIST |  | JOB LIST |  | DELIVERY COUNT  (BY JOB) |  | TRANSPORT (DATE SPECIFIC)
SITE 1 |  | DELIVERY |  | Driver 1 |  | Vehicle 1 |  | DEL 1
SITE 2 |  | SITE |  | Driver 2 |  | Vehicle 2 |  | DEL 2
ALL OUTSOURSE |  | CLIENT COLLECT |  | Driver 3 |  | Vehicle 3 |  | DEL 3
 |  | OTHER |  | Driver 4 |  | Vehicle 4 |  | DEL 4 |  |  |  |  |  |  |  |  |  |  |  | =OFFSET(PRICELIST!$A$5,0,0,COUNTA(PRICELIST!$A$5:$A$202))
 |  | COLLECTION |  | Driver 5 |  | Vehicle 5 |  | DEL 5 |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(INDEX(RANGE,MATCH(0,COUNTIF($A$3:A3,RANGE),0)),"")
 |  |  |  | Driver 6 |  | Vehicle 6 |  | DEL 6 |  |  |  |  |  |  |  |  |  |  |  | =OFFSET(CALCSHEET!$A$4, 0, 0, COUNT(IF(CALCSHEET!$A$4:$A$50="", "", 1)), 1)
 |  |  |  | Driver 7 |  | Vehicle 7 |  | DEL 7
 |  |  |  | Driver 8 |  | Vehicle 8 |  | DEL 8 |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(INDEX(TYPE,MATCH(0,COUNTIF($B$3:B3,TYPE)+(RANGE<>$A$1),0)),"")
 |  |  |  |  |  |  |  | DEL 9
 |  |  |  |  |  |  |  | DEL 10
 |  |  |  |  |  |  |  | DEL 11
 |  |  |  |  |  |  |  | DEL 12
 |  |  |  |  |  |  |  | DEL 13
 |  |  |  |  |  |  |  | DEL 14
 |  |  |  |  |  |  |  | DEL 15
Spreadsheet: d0ce5d6e-b50a-41dc-959f-9cfec290d6a4
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | To authorize the issuance of $45 million Sanitary Sewer System Revenue Bonds.
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | √ | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | This legislation will be used to authorize the development of financing for various improvements to the City's sanitary sewer
 | system through the issuance of tax-exempt sanitary sewer bonds, Series 2006A in the principal amount not to exceed
 | $45 million.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | √ | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | √ | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | √ | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: bg

Biggins. Clive |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 746066d1630482967-getting-the-total-amount-of-lunch-hours-between-2-different-dates-and-times-sample-lunchtime-calculator-ans
Sheet: Sheet1

Lunchtime totals calculator |  |  |  |  |  |  |  |  |  | *Working Days reference | Lunchtime-fixed | Work-Time | Hours
 |  | FORMULA |  |  |  |  |  |  |  | Monday Start | 13:00:00 | lower | 08:00:00
Start date | End date | Total lunchtime taken | Total lunchtime taken |  |  |  |  |  |  | Monday Finish | 14:00:00 | upper | 17:00:00
23/07/2021 8:00:00 | 28/07/2021 14:00:00 |  | 05:30:00 |  |  |  |  |  |  | Tuesday Start | 13:00:00
23/07/2021 8:00:00 | 2021-07-23 14:00:00 |  |  |  |  |  |  |  |  | Tuesday Finish | 14:00:00
23/07/2021 8:00:00 | 2021-07-23 16:00:00 |  |  |  |  |  |  |  |  | Wednesday Start | 13:00:00
23/07/2021 8:00:00 | 2021-07-24 14:00:00 |  |  |  |  |  |  |  |  | Wednesday Finish | 14:00:00
23/07/2021 8:00:00 | 2021-07-29 14:00:00 |  |  |  |  |  |  |  |  | Thursday Start | 13:00:00
23/07/2021 8:00:00 | 2021-07-23 10:00:00 |  |  |  |  |  |  |  |  | Thursday Finish | 14:00:00
23/07/2021 8:00:00 | 2021-07-23 12:00:00 |  |  |  |  |  |  |  |  | Friday Start | 12:15:00
2021-07-23 15:00:00 | 2021-07-23 17:00:00 |  |  |  |  |  |  |  |  | Friday Finish | 14:45:00
2021-07-27 15:00:00 | 2021-07-30 17:00:00
2021-07-22 15:00:00 | 2021-07-29 17:00:00
Spreadsheet: 147987d1333064380-if-text-in-cell-equals-text-in-another-cell-highlight-both-same-color-example-roster-comparison
Sheet: Sheet1

EMPLOYEE ROSTER |  |  |  |  | Company Training
Full Name | Last Name | First Name |  |  | Last Name | First Name
[NAME], [NAME] | [NAME] | [NAME] |  |  | [NAME] | [NAME]
[NAME], [NAME] | [NAME] | [NAME] |  |  | [NAME] | [NAME]
Jones, Amanda | Jones | Amanda |  |  | Jones | Amanda
Sanders, [NAME] | Sanders | [NAME] |  |  | Saunders | [NAME]
Smith, [NAME] | Smith | [NAME] |  |  | Smith | Fred
[NAME], [NAME] | Smith | John |  |  | Smith | Zach
Spreadsheet: 820730d1678272839-candidate-wise-need-formula-to-join-the-category-and-sum-it-candidate-wise-need-formula-to-join-the-category-and-sum-it
Sheet: Sheet2

 |  |  |  | Answer I need
Count of bbb
Name of the Candidate | bbb | Total |  | Name of the candidate | bb - is Category | sum
Haresh | [NAME] | 1
 | Helper | 3
 | Electrician | 3
 | Welder | 1
 | [NAME] | 1 |  | Haresh
Jayesh | [NAME] | 3
 | Ac Mechanic | 3
 | [NAME] | 2
 | [NAME] | 3
 | [NAME] | 6
 | Helper | 8
 | Mechanic | 9
 | Electrician | 1
 | Welder | 6
 | Assistant Mechanic | 2 |  | Jayesh
Mahesh | Denter | 1
 | Electrician | 1
 | Assistant Mechanic | 1
 | [NAME] | 1 |  | Mahesh
Rajesh | Painter | 1
 | [NAME] | 2 |  | Rajesh
Grand Total |  | 59
Spreadsheet: b398b057-8799-4ebc-9dda-5358ae7be937
Sheet: Sheet1

Table S4. Sequence of primers used for cloning 3'UTR of miR-34a target genes. | Unnamed: 1 | Unnamed: 2
3'UTR | Forward Primer | [NAME]
CDK4 | ATGACTCGAGGCAATGGAGTGGCTGCCATGGAAGGAAG | ATGAGCGGCCGCGACCATTATTTCTTTGTTTTGTTTTTCCT
ACSM3 | ATGACTCGAGAGTTGTTTCATTAATTACCATATCTATAAAAC | ATGAGCGGCCGCGGAGGAATTTGCCAAATATTTTATTTCAAAA
AGBL5 | ATGACTCGAGTAATGCCTTTATGTTCAAGCCCAGGATATAG | ATGAGCGGCCGCGGATTTTTCCAAACAACTTTTATTTCCT
AXL | ATGACTCGAGGACAACCCTCCACCTGGTACTCCCTCTC | ATGAGCGGCCGCGTTGATATACAAAGTTTTATGTGACCTGAG
CCNG2 | ATGACTCGAGAAATCTGATTGTTCTGTCAGAATTTATATTTAC | ATGAGCGGCCGCGTGTTTTAAAGTTCATTCTTTATTCTGTTAATACA
FOXP1 | ATGACTCGAGCTATCGGGGCGGGCCAACCCCGAGAATG | ATGAGCGGCCGCCAAAAGTTCAATAGTTTTGACACTCCCCAT
MAD2L2 | ATGACTCGAGGGGGGCACCTGCCACCCCACTGATG | ATGAGCGGCCGCCAGCCCAGCCCTTGGGGCCCCTTT
PCYOX1L | ATGACTCGAGGGGCTCTAGGGAGAGCCTGGGAACTTTCATC | ATGAGCGGCCGCCAAAAGGAATGAAAAGGGCTTTTAC
PDRG1 | ATGACTCGAGGACTCAAGAACCAAGATGGGGGACCAGC | ATGAGCGGCCGCGCTATTCATTCATTCAGCTAACATTTATTGA
PSMD5 | ATGACTCGAGTTTCTTCTAGAGCTCATGTAG | ATGAGCGGCCGCACTTATGAAATGAAAATAATGATTTACAAA
RBBP4 | [NAME] | ATGAGCGGCCGCAACTTTAATGCATTTTATTTAACCCAACACATAT
ARAF | ATGACTCGAGGGCCCCGCCCAAGCCACCAGGGAGCCAATC | ATGAGCGGCCGCAAACAAGCAAAGGCCCAGCAGAATTCTGTGCTTC
MEK1 | ATGACTCGAGAGTGTTTGGGAAGCAACAAAGAGCGAGT | ATGAGCGGCCGCATTTCATAGTATATTTATTAGAATAAGA
MET | ATGACTCGAGTGCTAGTACTATGTCAAAGCAACAGTCCAC | ATGAGCGGCCGCCACTTTACTTTAATTGCATGATTTATC
CCND3 | ATGACTCGAGCCAGGAACCACACCACATCTAAG | ATGAGCGGCCGCTCATCTTTATTACAGTAGGATGATGGTC
MCM2 | ATGACTCGAGGGCCCTATGCCATCCATAA | ATGAGCGGCCGCAAAAATTAAAACTACAGAAACCAAACC
MCM4 | ATGACTCGAGAAGCCTTGTGAGCAAGGAAG | ATGAGCGGCCGCAAGAAAGGCTCTAGCCCTTTACCA
MCM5 | ATGACTCGAGGTCGCGCCGCCTCACTGGACTC | ATGAGCGGCCGCACCTGAACACACCGTGGCTTTAT
[NAME] | ATGACTCGAGGCCCCAGACTCTGCCTCTGCAC | ATGAGCGGCCGCGCCACATGAGCAAGCTTGGGTGCT
PLK1 | ATGACTCGAGTAGCTGCCCTCCCCTCCGGACTGGTG | ATGAGCGGCCGCGAATATTCACATCTGTTTAATGTGCA
[NAME] | ATGACTCGAGGTGGGTTTTCTCTAGCTAATTCATATCT | ATGAGCGGCCGCGGCTTTAGAGGTAATTGCTTTCATATAC
Spreadsheet: 703461d1605009848-countif-range-of-cells-contains-text-from-column-a-countif-range-2-
Sheet: Hoja1

 | One way | Another way |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Javier |  |  |  |  | Alboraya 0 - 0 Alzira | [NAME]
Mario |  |  |  |  | 13 Javier (P) | 1 Chover (P)
Dídac |  |  |  |  | 2 Mario | 2 Mario
PEPE |  |  |  |  | 3 Dídac | 3 Dídac  75'
[NAME] |  |  |  |  | 4 PEPE | 4 PEPE | [NAME] fff
6 Victor |  |  |  |  | 5 Savall (C) | 5 Savall (C)
 |  |  |  |  | 6 Victor | 6 Victor | [NAME] | [NAME] | [NAME]
 |  |  |  |  | 7 Sergio  85' | 7 Sergio
 |  |  |  |  | 8 Israel  71' | 8 Israel  56' |  | 88 Mario
 |  |  |  |  | 9 [NAME]  71' | 9 [NAME]  67'
 |  |  |  |  | 10 Iker  75' | 10 Iker  75'
 |  |  |  |  | 11 Victor | 11 Victor
 |  |  |  |  | Suplentes | Suplentes
 |  |  |  |  |  | [NAME] "A"
 |  |  |  |  | 1 Chover | 12 Diego
 |  |  |  |  | 12 Diego | 13 Javier
 |  |  |  |  | 14 [NAME]75' | 14 Francesc
 |  |  |  |  | 15 Francesc | 15 Adrian  56'
 |  |  |  |  | 16 Adrian  71' | 16 Mario  67'
 |  |  |  |  | 17 Mario  85' | 17 [NAME]
 |  |  |  |  | 18 Miguel  71' | 18 [NAME]75'
 |  |  |  |  |  | 19 Sergio  75'
 |  |  |  |  |  | 20 Lucas
Spreadsheet: 680013d1590745580-formula-to-take-data-from-horizontal-row-book4
Sheet: SHIP

[NAME] | MODEL / SZ | 2 | 3 | 4 | 5 | 6 | 7 | Total
1234 | AAAA |  | 3 | 3 | 3
2345 | BBB | 1 |  | 2 | 2 |  | 2
3456 | CCC | 2 | 2 | 2 | 2 | 2 | 2
Spreadsheet: mike_carson__27604__KOCH
Sheet: Sheet1

 | Power for delivery
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 16 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 18.7 |  | 1
 | Comed | -100 | 19.65 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 13.25 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Total
 |  |  |  |  |  | Net AMT
Spreadsheet: 783825d1655180017-raffle-entries-book1-mgnsllvn-
Sheet: Sheet1

Names | Entries | Cumulative |  | Names | Random
Test Tester | 2 |  |  |  |  |  | Winner:
[NAME] | 4
Megan Test | 1
Spreadsheet: 851552d1701770334-problem-with-2-functions-maps
Sheet: MAPS

 |  | [NAME] | [NAME] | JACK
 | JAN | 115 | 74 | 145 |  | NAME | [NAME]
 | FEB | 136 | 151 | 141 |  | MONTH | MAR
 | MAR | 191 | 30 | 95 |  | RESULT
 | APR | 52 | 191 | 96
 | MAY | 160 | 113 | 156
Spreadsheet: 374089d1422651202-easy-question-if-and-or-error-example-workbook-ndm
Sheet: Sheet1

 |  | IF YOU ARE UNHAPPY WITH THE SUGGESTED INCREASE, COMPLETE ONE OF THE BELOW COLUMNS - NOT BOTH
Current Salary | Suggested Increase Amount | Proposed Increase Amount | Proposed Increase % |  | New Salary
23000 | 100 |  | 0.04
45000 | 1700 | 2000
16000 | 400
1250000 | 2000
Spreadsheet: 843908d1695732213-calculate-departure-date-and-time-based-on-required-arrival-date-and-time-driver-etd
Sheet: Sheet1

MILEAGE RANGE TO DESTINATION | CALCULATION | ESTIMATED TIME OF DEPARTURE
< 350 | TRANSIT + 4 | No formula needed
351 - 650 | 24 | No formula needed
651 - 1200 | TRANSIT + 14 - 24
1201 - 1800 | TRANSIT + 24 - 24
> 1801 | TRANSIT + 34 - 24
*Transit = number of hours in travel time to destination
*24 represents 1 day. It is subtracted as many times as necessary until a number below 24 is reached.
For ex: A driver is going to Canada which is over 1801 miles away. Transit time is approximately 40 hours. The calculation is as follows:
 | 40 + 34 = 74 approximate hours a driver needs to leave to arrive at the customer at the required day and time.
 | 74 - 24 (1 day) = 50
 | 50 - 24 (1 day) = 26
 | 26 - 24 (1 day) = 2
Based on the above calculation, the driver would need to leave 3 days and 2 hours prior to required delivery day and time.
Transit times a retrieved from a separate spreadsheet containing customer information. I suppose a column should be added to input the destination? Which would then calculate estimated time of departure?
Spreadsheet: 65250d1265929285-working-in-between-13-workbooks-need-to-combine-specified-value-2009-totals
Sheet: 2009 Parts & Labor Totals

Machine # | Machine Description | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2009 Total
5208 | Bigger Machinery
32164 | Biggest Machinery
940135 | Big Machinery
Spreadsheet: 850879d1701191456-help-calculating-leads-needed-in-a-year-by-month-leads-example
Sheet: Sheet2

Growth | 0.08
Target | 50
 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
Correct Answer ------------->>>>>>>>>>> |  |  | 2.635
Spreadsheet: 757739d1638443077-search-for-any-text-from-multiple-cells-within-multiple-cells-sample-with-formula
Sheet: Sheet1

Name1 | [NAME] | Name3 | Name4 | Name5 | Name6 | Email1 | Email2 | Email3 | Email4 | Email5 | Email6 | Result
[NAME] | Doe | 1 |  |  |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | Yes
[NAME] | M | Doe |  |  |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | Yes
[NAME] | Bi | Fred | Said | None | Yes | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | No
Julie | L | Some | Thing | Special |  | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | No
Ellie | Is | Last | Good | Mai | 12 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | No
Ellie
 | Is | Last | Good | Mai | 12 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] |  |  |  | Is | Last | Good | Mai | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | johndoe | johnd | someone | no | 1234
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
Spreadsheet: 822596d1679432466-golf-gross-and-net-plus-skin-calculation-kga-golf-tournament-gross-and-net-ranking-plus-skins
Sheet: SKINS

PAYOUT (X) |  |  |  | SKINS (IF PLAYED) |  |  |  |  |  | SKINS WINNERS |  | TOTAL $ WON (NO CARRY) | TOTAL $ WON (CARRY)
 |  |  |  |  |  |  |  |  | With Carry? | NO | YES
TOTAL PLAYERS |  |  |  | TOTAL PLAYERS |  |  | TOTAL NUMBER OF CARRIED SKINS WON
$ PER PLAYER |  | 10 |  | $ PER PLAYER |  | 10 |  |  | ARNY |  | 3
TOTAL MONEY PRIZE |  |  |  | TOTAL MONEY PRIZE |  |  |  |  | CHAI |  | 2
PERCENTAGE |  | AMOUNT |  | TOTAL SKINS - NO CARRY |  |  |  |  | GOSALL |  | 2
% GROSS | 1 |  |  | TOTAL SKINS - CARRY
% NET | 0.5 |  |  | HOLE | CARRY - Y/N | HOLE WINNER
GROSS - 1ST | 0.8 |  |  | #1
GROSS - 2ND | 0.2 |  |  | #2
GROSS - 3RD | 0 |  |  | #3
GROSS - 4TH | 0 |  |  | #4
NET - 1ST | 0.8 |  |  | #5
NET - 2ND | 0.2 |  |  | #6
NET - 3RD | 0 |  |  | #7
NET - 4TH | 0 |  |  | #8
 |  |  |  | #9
 |  |  |  | #10
 |  |  |  | #11
 |  |  |  | #12
 |  |  |  | #13 |  |  |  |  | TOTAL
 |  |  |  | #14 |  |  |  |  | $ PER SKIN
 |  |  |  | #15
 |  |  |  | #16
 |  |  |  | #17
 |  |  |  | #18
Spreadsheet: 199552d1355248882-conditional-filter-ranges-and-display-corresponding-details-in-2nd-worksheet-and-menu-preparin-query-worksheet
Sheet: Sheet1

THIS IS THE QUERY REGARDING SHEET 1
A |  | A | B | C | D | E | F
B |  | C | A | C | A | D | D
C |  | A | A | D | E | F | F
D |  | D | E | D | B | E | D
E |  | A | A | F | A | B | E
F
 |  |  | No of A | No of B | No of C | No of D | No of E | No of F
 |  | 1
1 | THIS DATA IS IN WORK SHEET  1
2 | IN THIS DATA SHOULD BE FILTERED AND FILTERED DATA FOR ITEM NO 'E' ITS CORRESPONDING DETAILS IN OTHER CELLS SHOULD APPEAR IN WORKSHEET NO.2
I HAVE COPIED A FORMAT IN SHEET NO2.
1 | CAN ANY ONE ADVICE HOW TO MAKE THIS
2 | THERE ARE OVER 70 WORK SHEETS ATTACHED TO MENU
3 | BUT WHEN YOU OPEN THE WORKBOOK ONLY THIS SHEET i.e. ONLY MENU WORK SHEET
 | IS DISPLAYED HOW IS THIS ACHIEVED.
4 | OR IS THERE ANY OTHER METHOD THIS FORMAT CAN BE ACHIEVED IN EXCEL.
THANKS IN ADVANCE
HARISH RAJ
Spreadsheet: 725559d1616747202-staff-attendance-data-copy-of-attendance-ans
Sheet: Report_20210315T112801

Raw data |  |  |  | Raw data |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Date |  |  |  | User |  |  |  | id | date | id+date | time | date |  |  |  | Staff | Date | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
2021-03-01 11:01:13 |  |  |  | X05024(Maria)
2021-03-01 12:12:05 |  |  |  | X05024(Maria)
2021-03-01 15:02:08 |  |  |  | X05024(Maria)
2021-03-01 17:42:24 |  |  |  | X05024(Maria)
2021-03-01 19:06:32 |  |  |  | X05024(Maria)
2021-03-02 10:22:25 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | time highlighted in green wrongly capture next day data
2021-03-02 10:23:02 |  |  |  | X05024(Maria)
2021-03-02 10:33:56 |  |  |  | X05024(Maria)
2021-03-02 10:46:16 |  |  |  | X05024(Maria)
2021-03-02 15:24:37 |  |  |  | X05024(Maria)
2021-03-02 15:31:59 |  |  |  | X05024(Maria)
2021-03-02 17:52:44 |  |  |  | X05024(Maria)
2021-03-02 18:36:15 |  |  |  | X05024(Maria)
2021-03-01 08:30:56 |  |  |  | R09999(Peter)
2021-03-01 08:32:58 |  |  |  | R09999(Peter)
2021-03-01 09:18:06 |  |  |  | R09999(Peter)
2021-03-01 13:49:43 |  |  |  | R09999(Peter)
2021-03-01 16:57:45 |  |  |  | R09999(Peter)
2021-03-01 17:47:28 |  |  |  | R09999(Peter)
2021-03-01 17:48:15 |  |  |  | R09999(Peter)
2021-03-01 18:08:42 |  |  |  | R09999(Peter)
2021-03-02 08:31:02 |  |  |  | R09999(Peter)
2021-03-02 08:33:08 |  |  |  | R09999(Peter)
2021-03-02 08:49:53 |  |  |  | R09999(Peter)
2021-03-02 09:23:00 |  |  |  | R09999(Peter)
2021-03-02 09:26:43 |  |  |  | R09999(Peter)
2021-03-02 09:57:08 |  |  |  | R09999(Peter)
2021-03-02 09:57:56 |  |  |  | R09999(Peter)
2021-03-02 10:06:15 |  |  |  | R09999(Peter)
2021-03-02 10:12:43 |  |  |  | R09999(Peter)
2021-03-02 14:27:29 |  |  |  | R09999(Peter)
2021-03-02 18:09:59 |  |  |  | R09999(Peter)