tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 119334d1314325173-formula-to-return-the-values-in-the-attached-sheet-sheet1dates
Sheet: Sheet2

Current month or not | Emp ID | Name | Date
Current Month | 205028 | Y |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 |  |  |  |  |  | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 |  |  |  |  |  | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Current Month | 205028 | Y
Spreadsheet: 881919d1730156749-incremental-copy-of-cell-ref-rf-bubble-incremental-copy-of-cell-ref-tms
Sheet: Sheet1

 | 10 | C1 |  |  | 5 | [NAME]
 |  | C2 |  |  |  | G2
 |  | [NAME] |  |  |  | G3
 |  | C4 |  |  |  | G4
 |  | C5 |  |  |  | G5
 |  | C6 |  |  |  | G6
 |  | C7 |  |  |  | G7
 |  | C8 |  |  |  | G8
 |  | C9 |  |  |  | G9
 |  | C10 |  |  |  | G10
 |  | C11 |  |  |  | G11
 |  | C12 |  |  |  | G12
 |  | C13 |  |  |  | G13
 |  | C14 |  |  |  | G14
 |  | C15 |  |  |  | [NAME]
 |  | C16 |  |  |  | [NAME]
 |  | C17 |  |  |  | G17
 |  | C18 |  |  |  | G18
 |  | C19 |  |  |  | G19
 |  | C20 |  |  |  | G20
 |  | C21 |  |  |  | G21
 |  | C22 |  |  |  | G22
 |  | C23 |  |  |  | G23
 |  | C24 |  |  |  | [NAME]
 |  | C25 |  |  |  | G25
 |  | C26 |  |  |  | G26
 |  | C27 |  |  |  | G27
 |  | C28 |  |  |  | G28
 |  | C29 |  |  |  | G29
 |  | C30 |  |  |  | G30
 |  | C31 |  |  |  | G31
 |  | C32 |  |  |  | G32
 |  | C33 |  |  |  | G33
 |  | C34 |  |  |  | G34
 |  | C35 |  |  |  | G35
 |  | C36 |  |  |  | G36
 |  | C37 |  |  |  | G37
 |  | C38 |  |  |  | G38
 |  | C39 |  |  |  | G39
 |  | C40 |  |  |  | G40
 |  | C41 |  |  |  | G41
 |  | C42 |  |  |  | G42
 |  | C43 |  |  |  | [NAME]
 |  | C44 |  |  |  | G44
 |  | C45 |  |  |  | G45
 |  | C46 |  |  |  | G46
 |  | C47 |  |  |  | G47
 |  | C48 |  |  |  | G48
 |  | C49 |  |  |  | G49
 |  | C50 |  |  |  | G50
Spreadsheet: 862978d1710525367-calendar-formulas-and-conditional-formatting-annual-calendar-dj
Sheet: March

 |  |  |  |  |  |  |  |  | MAR
 | NOTES
Spreadsheet: 24955d1216016706-excel-2007-merging-stock-test-merging
Sheet: 4

shop1 |  | shop2 |  | shop3 |  | shop4 |  | shop5 |  | Total Sale. | Total Inventory. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 5
Sale. | Inventory. | Sale. | Inventory. | Sale. | Inventory. | Sale. | Inventory. | Sale. | Inventory. |  |  | inv to sale |  |  |  |  | is error |  |  |  |  | inv to sale without error |  |  |  |  | shop2 | shop3 | shop4 | shop5 |  |  |  |  | shop1 | shop3 | shop4 | shop5 |  |  |  |  | shop1 | shop2 | shop4 | shop5 |  |  |  |  | shop1 | shop2 | shop3 | shop5 |  |  |  |  | shop1 | shop2 | shop3 | shop4 |  |  |  |  | Must check every change |  |  |  |  |  |  |  |  |  | arrangement shops 1,2,3… |  |  |  |  |  |  |  |  |  | TO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FROM
31 | 1 | 6 | 0 | 1 | 4 | 18 | 5 | 9 | 1 | 65 | 11 | 0.03225806451612903 | 0 | 4 | 0.2777777777777778 | 0.1111111111111111 | 0 | 0 | 0 | 0 | 0 | 0.03225806451612903 | 0 | 4 | 0.2777777777777778 | 0.1111111111111111 | shop2 | shop3 | shop4 | shop5 | 0 | 1.2 | 0 | 0 | shop1 | shop3 | shop4 | shop5 | 0 | 1.2 | 0 | 0 | shop1 | shop2 | shop4 | shop5 | 0 | 0 | 0 | 0 | shop1 | shop2 | shop3 | shop5 | 0 | 0 | 1.2 | 0 | shop1 | shop2 | shop3 | shop4 | 0 | 0 | 1.2 | 0 | shop2 | 0 | shop2 | 0.03225806451612903 | shop2 | 0.1111111111111111 | shop2 | 0.2777777777777778 | shop2 | 4 | shop1 | 0 | shop2 | 0 | shop3 | 0 | shop4 | 0 | shop5 | 0 | to | shop1 | 0 | to | shop2 | 1.2 | to | shop3 | 0 | to | shop4 | 0 | to | shop5 | 0 | shop2 | shop3 | shop1 | shop1 | shop1 | shop2 to shop1 | 0 | shop3 to shop2 | 1.2 | shop1 to shop3 | 0 | shop1 to shop4 | 0 | shop1 to shop5 | 0
 |  | 0 | 5 | 1 | 4 | 0 | 5 | 1 | 4 | 2 | 18
19 | 21 | 19 | 11 | 8 | 12 | 37 | 24 | 36 | 34 | 119 | 102
2 | 1 | 0 | 5 | 0 | 5 | 0 | 3 | 5 | 8 | 7 | 22
 |  | 1 | 4 | 0 | 5 | 0 | 5 | 0 | 5 | 1 | 19
 |  | 0 | 5 | 1 | 4 | 2 | 3 | 1 | 4 | 4 | 16
 |  | 0 | 5 | 1 | 4 | 0 | 5 | 0 | 5 | 1 | 19
1 | 5 | 2 | 8 | 0 | 5 | 6 | 13 | 5 | 10 | 14 | 41
21 | 6 | 8 | 2 | 2 | 8 | 14 | 7 | 13 | 2 | 58 | 25
Spreadsheet: sally_beck__34369__FallonDelaneyrpt
Sheet: Piper

Retain - Piper
GIS ID | Formatted Name | Company Name | Job Title | [NAME] | Level1 Full Name | Level2 [NAME] | Level3 [NAME] | Level4 [NAME] | Company
90006871 | BERNAL CARRILLO, CARMEN L | ENRON NET WORKS LLC(CNEN) | CLERK | SPILLER, TINA D | WHALLEY, [NAME] | PIPER, GREGORY | SPILLER, TINA | BERNAL CARRILLO, CARMEN | Estate
90006849 | SPILLER, TINA D | ENRON NET WORKS LLC(CNEN) | ASST EXEC | PIPER, GREGORY F | WHALLEY, [NAME] | PIPER, GREGORY | SPILLER, TINA |  | Estate
90013007 | PIPER, GREGORY F | ENRON NET WORKS LLC(CNEN) | PRESIDENT & CEO | WHALLEY, [NAME] | WHALLEY, [NAME] | PIPER, GREGORY |  |  | Estate
 |  |  |  | 3
Spreadsheet: 547933d1510814926-find-specific-multiple-texts-and-define-it-example03
Sheet: canapone's

Text | OK | changed the dot to coma, and entered as an array formula | canapone's original formula | changed the dot to coma, and entered as normal formula | canapone's formula with added "fruits" | changed the dot to coma, added "fruits", changed the row area | intended result
[NAME] |  |  |  |  |  |  | Poison!
Watermelon Grape Strawbery |  |  |  |  |  |  | Watermelon Grape
Bread Melon Cherry Acid |  |  |  |  |  |  | Poison!
Grape Pineapple Plum Mercury |  |  |  |  |  |  | Poison!
Juice Melon Strawberry |  |  |  |  |  |  | Juice | < i forgot, there's "Juice", beside "Cake" and "Bread"
*the intended result without the need to hide column
Spreadsheet: b1dd15d9-df4f-4c45-b9d6-240c965cea02
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43492652 | 2014-10-08 16:11:47 | AXIS | 1 | 4 | 3 | 1563531 | muras_alex | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
43492734 | 2014-10-08 16:25:36 | ALLIES | 1 | 4 | 3 | 1563531 | muras_alex | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
Spreadsheet: 814397d1674340614-returning-a-random-value-from-a-specific-list-without-immediate-duplicates-test-hd
Sheet: Sheet1

 | A1 | A2 | B1 | B2 | C1 | C2 | D1 | D2 | E1 | E2 |  | Person | Option 1 | Option 2 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
1 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  | A1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
2 |  |  |  |  |  |  | X | X | P |  |  |  |  |  |  |  | A2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
3 |  |  |  |  | P |  | X | X | X | X |  |  |  |  |  |  | B1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
4 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  | B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
5 |  |  |  |  |  |  | P |  | X | X |  |  |  |  |  |  | C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
6 |  |  |  |  |  |  | X | X |  | P |  |  |  |  |  |  | C2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G
7 |  |  |  |  |  | P | X | X | X | X |  |  |  |  |  |  | D1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
8 |  |  |  |  |  |  | X | X | P |  |  |  |  |  |  |  | D2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
9 | P |  |  |  | X | X | X | X | X | X |  |  |  |  |  |  | E1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J
10 |  | P |  |  |  |  | X | X | X | X |  |  |  |  |  |  | E2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
11 |  |  |  |  |  | P | X | X | X | X
12 |  |  |  | P |  |  | X | X | X | X
13 | P |  |  |  |  |  | X | X | X | X
14 |  | P |  |  | X | X | X | X | X | X |  |  |  |  |  |  |  |  | A1 | A2 | B1 | B2 | C1 | C2 | D1 | D2 | E1 | E2
15 |  |  |  | P | X | X | X | X | X | X |  |  |  |  |  |  |  | A1
16 |  |  |  |  |  |  | P |  | X | X |  |  |  |  |  |  |  | A2
17 | P |  |  |  | X | X | X | X | X | X |  |  |  |  |  |  |  | B1
18 |  |  |  |  |  |  | X | X |  | P |  |  |  |  |  |  |  | B2
19 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  |  | C1
20 |  |  |  |  | P |  | X | X | X | X |  |  |  |  |  |  |  | C2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E2
Spreadsheet: 268410d1380628376-formula-to-auto-hyper-link-using-lookup-auto-hyperlink-required
Sheet: Jobs

enter valid quote reference to raise new job
Jobs
Job Reference | Quote reference | Location | Description | link
 | 3600
 | 3601
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO74030

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 404 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20734 |  | Asset Binders |  |  |  |  |  | Z0074030
 |  | EnSerCo LLC (Conemsco) |  |  |  | 01/01/97 | 12/31/98
 |  | EnSerCo LLC (Capstar/Brazeal) |  |  |  | 01/01/97 | 12/31/98
 |  | EnSerCo LLC (Paradigm) |  |  |  | 01/01/97 | 12/31/98
 |  | Rocksprings Energy |  |  |  | 01/01/94 | 12/31/96
 |  | Grand Gulf Working Interest |  |  |  | 01/01/95 | 12/31/96
 |  | Coda Energy |  |  |  | 01/01/96 | 12/31/97
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: 799843d1665346319-paye-tax-tax-calculations-soulfulneo-
Sheet: Tax Calculations

Tax Calculations
I am trying to breakdown my payslip so I can manually calculate how much I will get paid from work every 4 weeks.  I work shifts so my income isn't fixed.  The calculation below is based on £1,828.10 this pay day, but in 4 weeks times, this amount will be £1,276.04.  The formula will need to calculate what I earn based on Hours Worked x Hourly Rate and then the relevant Pension, Tax and N.I deductions to give actual pay every 4 weeks.
Personal Allowance |  | 12630 |  | [NAME] |  | 10.1
Tax Code |  | 1263L |  | Hours Worked |  | 181
Name | Amount | [NAME] | Result | Notes
Income | 1828.1 |  |  | Income is [NAME] (181) x Hourly Rate (£10.10) = £1,828.10
Pension | 91.41 |  |  | Pension is 5% of Income (£1,828.10) = £91.41
Taxable | 765.16 |  |  | I'm unsure how to calculate this, but this should be an amount based on my earning and allowance so that tax can be calculated on this amount.  An online calculator gives £765.16, but unsure how to use a formula for this?
Tax | 153.03 |  |  | Tax is 20% of the Taxable amount (£765.16)
N.I | 113.96 |  |  | N.I is 0% of Income up to £968, and then 13.25% from £968 £1,828.10 (Income) - £968 (0%) = £860.10.  13.25% of £860.10 = £113.96.
Pay | 1469.55 |  |  | Pay is Income (£1,828.10) - Pension (£91.41) - Tax (£153.03) - N.I (£113.96) = £1,469.70
Ref: https://www.thesalarycalculator.co.uk/hourly.php
 |  | Yearly | Four Weekly | Daily
Gross Income |  | 23765.3 | 1828.1 | 91.41
Pension Deductions |  | 1188.27 | 91.41 | 4.57
Taxable Income |  | 9947.03 | 765.16 | 38.26
Tax |  | 1989.41 | 153.03 | 7.65
National Insurance |  | 1483.38 | 114.11 | 5.71
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: SWo

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 807301d1669835422-trying-to-write-nested-xlookup-formula-that-searches-2-sheets-then-returns-cell-or-blank-nestedxlookupformula
Sheet: Sheet2

I.D. # | Machine | Backup Machine
1077995 |  | HH1
1127898 |  | HH2
1127899 |  | HH1
1128683 |  | HH2
1128762 |  | HH1
1129158 |  | HH2
1129806 |  | HH1
1129807 |  | HH2
1129808
1130138 |  | HH2
1223345 |  | HH3
Spreadsheet: 29818d1224940871-merging-content-from-two-spreadsheets-systemscollectsample
Sheet: Sheet2

Customer Name | Exchange | IR Service | Website not apart of competitive matrix
1ST CAPITAL BANK | OTC |  | http://www.1stcapitalbank.com/investRel.asp
40/86 ADVISORS | NYSE |  | http://www.4086.com/
51JOB,INC./XPRN CHINA | NASDAQ | Shareholder.com
8X8 INC | NASDAQ | Thomson
[NAME] | NYSE | Thomson
A. SCHULMAN, INC. | NASDAQ |  | http://www.aschulman.com/investor_relations.asp
A.M. Castle & Co. | AMEX |  | http://www.amcastle.com/investors.aspx
A.O. SMITH | NYSE | Shareholder.com
A.T. CROSS COMPANY/FD | AMEX |  | http://www.cross.com/investorservices/investorrelations.aspx?cat_name=Investor+Relations
AAA ENERGY, INC. | OTC |  | http://www.aaaenergy.com/
AAR | NYSE | Thomson
[NAME] | NYSE | Thomson
ABATIX CORP | OTC |  | http://www.abatix.com/Default.aspx?Page=customer&file=customer/abatix/customerpages/aboutus/investor/index.html
ABAXIS, INC. | NASDAQ | Thomson
ABBOTT LABORATORIES | NYSE | Thomson
ABERCROMBIE & FITCH | NYSE | Thomson
ABOVENET COMMUNICATIONS, INC. | OTC |  | http://www.abovenet.com/about/investors.html
ACACIA AUTOMOTIVE INC. | OTC |  | http://www.acacia.bz/investors/investors.htm
ACCESS INTEGRATED TECHNOLOGIES INC | NASDAQ | Shareholder.com
ACCESS PHARMACEUTICALS | OTC |  | [NAME]
ACCESS WORLDWIDE | OTC |  | http://www.accessww.com/in_ov.html
ACCO BRANDS CORPORATION | NYSE | Shareholder.com
ACCOUNTABILITIES INC. | OTC |  | [NAME]
ACCTON TECHNOLOGY/XPRN HK | TPE |  | http://www.accton.com/about/background.htm
Spreadsheet: 676472d1588820045-select-dates-when-first-and-last-occurrence-of-a-value-below-date-row-occurs-workday-ranges
Sheet: Sheet1

 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00
worker 1 | 24 | 24 | 24 | 24 |  |  |  |  |  | 24 | 24 | 24 | 24 |  |  | 24 | 24 | 24 |  |  |  |  | 24 | 24 | 24 | 24
worker 2 |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  | 24
 | Worker 1 |  | Worker 2
 | Start | End | Start | End
workdays range 1
workdays range 2
workdays range 3
workdays range 4
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
Spreadsheet: 743446d1628513910-sort-and-align-2-tables-upload-forum
Sheet: Page 2

Subnet | CIDR | Status | Container | Parent
10.217.0.0 | /24 | In-Use/Deployed | WRBNCAPC05 | 10.217.0.0/17
10.217.1.0 | /24 | In-Use/Deployed | CTECOLTA02 | 10.217.0.0/17
10.217.3.0 | /24 | In-Use/Deployed | WRBNCAPC06 | 10.217.0.0/17
10.217.4.128 | /25 | In-Use/Deployed | WRBNOLMN11 | 10.217.0.0/17
10.217.5.128 | /25 | In-Use/Deployed | WRBNOLMN08 | 10.217.0.0/17
10.217.6.0 | /24 | In-Use/Deployed | WRBNRPCC01 | 10.217.0.0/17
10.217.8.0 | /25 | In-Use/Deployed | WRBNOLMN01 | 10.217.0.0/17
10.217.8.128 | /25 | In-Use/Deployed | WRBNOLMN05 | 10.217.0.0/17
10.217.9.0 | /25 | In-Use/Deployed | WRBNOLMN06 | 10.217.0.0/17
10.217.9.128 | /25 | In-Use/Deployed | [NAME] | 10.217.0.0/17
10.217.10.0 | /25 | In-Use/Deployed | HOLTOLMN01 | 10.217.0.0/17
10.217.10.128 | /25 | In-Use/Deployed | WRBNOLMN02 | 10.217.0.0/17
10.217.11.0 | /25 | In-Use/Deployed | HOLTOLMN02 | 10.217.0.0/17
10.217.11.128 | /25 | In-Use/Deployed | WRBNOLMN03 | 10.217.0.0/17
10.217.12.0 | /25 | In-Use/Deployed | HOLTOLMN03 | 10.217.0.0/17
10.217.12.128 | /25 | In-Use/Deployed | WRBNOLMN07 | 10.217.0.0/17
10.217.13.0 | /25 | In-Use/Deployed | HOLTOLMN04 | 10.217.0.0/17
10.217.13.128 | /25 | In-Use/Deployed | WRBNOLTA01 | 10.217.0.0/17
Spreadsheet: 775248d1648936578-formula-to-divide-text-in-4-columns-or-less-query-to-divide-address-in-4-columns
Sheet: Text to columns

 | Address | Line 1 | Line 2 | Line 3 | Line 4
 | 006, B Block, [NAME],[NAME],, BSK 3rd Stage, Near Bharat Gas, Bangalore 560085 | 006, B Block | [NAME],[NAME] | BSK 3rd Stage, Near Bharat Gas | Bangalore 560085
 | 006, B Block, [NAME], Bangalore 560085 | 006, B Block | ITI Layout | Bangalore 560085
 | 006, B Block, [NAME],[NAME],, BSK 3rd Stage,, Bangalore 560085 | 006, B Block, ITI Layout | Kathriguppe, BSK 3rd Stage | Bangalore 560085
 | 006, B Block,, BSK 3rd Stage, Near Bharat Gas, Bangalore 560085 | 006, B Block | BSK 3rd Stage | Near Bharat Gas | Bangalore 560085
 | 006, [NAME], Bangalore 560085 | 006, ITI Layout | Bangalore 560085
Spreadsheet: abd749bc-f0b8-4a81-b44a-88ef3d502215
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (11 Entries):
 | 2 Embedded systems 2.2 Development tools, hardware 2.2.11 Development tools, hardware, miscellaneous
No. | Company | Country | City | [NAME] | Hall/Booth
1 | [NAME] | Germany | Rechberghausen | 73098 | A3.125
2 | CoSynth GmbH & Co. [NAME] | Germany | Oldenburg | 26121 | A5.560/16
3 | Densitron Display Solutions | United Kingdom | London | EC4N 6AE | [NAME]
4 | Digi-Key Corporation | USA | Thief River Falls | MN 56701 | A5.576
5 | EMC electro mechanical components Vertriebs GmbH | Germany | Idstein | 65510 | A6.A22
6 | Euro Instruments s.r.l. | Italy | Chiari (BS) | 25032 | A1.615
7 | GÖPEL electronic GmbH | Germany | Jena | 07745 | A1.351
8 | Ironwood Electronics Inc. | USA | Brunsville | MN 55337 | A6.A22
9 | PHYTEC Messtechnik GmbH | Germany | [NAME] | 55129 | A6.612
10 | RS Components GmbH | Germany | Mörfelden-Walldorf | 64546 | A4.117
11 | Texas Instruments Deutschland GmbH | Germany | Freising | 85350 | A4.420
Spreadsheet: 774361d1648426077-calculating-due-installment-dates-based-on-duration-number-of-instalments-qoutation-creator-eba
Sheet: Wizard

 |  |  |  |  |  |  |  |  | contract renew
 |  |  |  |  |  |  |  | Building Name | OBY20 | اسم المبنى
 |  |  |  |  |  |  |  | unit number | 1003 | [NAME]
 |  |  |  |  |  |  |  | unit type |  | نوع الوحده
 |  |  |  |  |  |  |  | contract type |  | نوع العقد
 |  |  |  |  |  |  |  | Contract Start | 2021-01-06 00:00:00 | [NAME]
 |  |  |  |  |  |  |  | Contract Expiry | 2022-02-22 00:00:00 | انتهاء العقد
 |  |  |  |  |  |  |  | Contract value | 46000 | [NAME]
 |  |  |  |  |  |  |  | Security deposit |  | التأمين
 |  |  |  |  |  |  |  | Payments | 4 | الدفعات
 |  |  |  |  |  |  |  | VAT payment | in advance مقدما | [NAME]
 |  |  |  |  |  |  |  | payment method | cheque | طريقه الدفع
 |  |  |  |  |  |  |  | tenant name |  | اسم المستأجر
 |  |  |  |  |  |  |  |  | Get qoutation
Spreadsheet: 143841d1330595465-populating-data-in-one-sheet-from-another-project-tracking
Sheet: Engineering

 |  | JUMP TO | ACCOUNT MANAGEMENT | PURCHASING | PRODUCTION PLANNING
ENGINEERING
Part Link Code | Part Number | Issue Level | Description | Model | Drawing Received | Estimated BOM Date | Actual BOM Date | Initial Drawing Issue Date | ISIR Revision Level | ISIR Date Internal | ISIR Customer Approved | Production Drawing Issue Date | No of Circuits | Labour Time | Similar To
Spreadsheet: 40833d1239218761-consecutive-positive-numbers-book3_apr8
Sheet: Sheet1

0 | 0 | 0 | 0 | 0 | [NAME] | Min Neg
2 | 1 | 0 | 0 | 0 | 11 | -10
1 | 2 | 0 | 0 | 0
4 | 3 | 0 | 7 | 0
-1 | 0 | 1 | 0 | 0
-9 | 0 | 2 | 0 | -10
1 | 1 | 0 | 0 | 0
2 | 2 | 0 | 0 | 0
8 | 3 | 0 | 11 | 0
-3 | 0 | 1 | 0 | 0
-5 | 0 | 2 | 0 | -8
Spreadsheet: 738108d1624849665-all-cells-in-row-follow-lead-a-column-cell-explination-workbook-1-ans
Sheet: Attendance sheet

Name |  | Shift | Day 1 | Day 2 | Day 3 | Day 4
 | 2 |  | P | A | P | P |  |  | This is the attendance sheet that is populated from the roster list.  I use an index formula to pull the names off the roster and sort them by shift.
 | 3 |  | P | P | P | P
 | 4
 | 5 |  | P | P | P | A |  |  | As each day arrives someone goes in and puts in a P for present or an A for abcent depending on if the person has come to work that day or not.
 | 6
 | 7 |  | P | P | P | A
 | 8
 | 9 |  | P | P | P | P
 | 10
 | 11
 | 12
 | 13
 | 14 |  | A | P | P | P |  |  | [NAME] now the attendence names are not in alphbetical order and no one has been fired or quite and no one has been hired so the list is accurate.
 | 15 |  | P | P | P | P
 | 16
 | 17 |  | P | A | P | P
 | 18
 | 19 |  | A | P | P | A
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27 |  | P | P | P | A
 | 28
 | 29
 | 30
 | 31 |  | P | P | P | P
 | 32
 |  |  |  |  |  |  |  |  |  | Please look at tab "[NAME] sheet adjusted"
Spreadsheet: 186751d1350194708-get-the-data-from-two-different-sheets-book1
Sheet: DayNight

 |  | Emp No | Emp Name | 8-9 AM | 10-11 AM | 12-2 PM | 4-5 PM | 8-9 PM | 12-1 AM | 4-5 AM
 |  |  |  | Break Fast | Brunch | Lunch | [NAME] | Dinner | Snacks | Morning Tea
Shift A | Day | 2012002 | SHANKAR KUNDAR
Shift A | Day | 2012005 | SUDHEER KUMAR
Shift A | Day | 2012020 | PRAKASH KUNDAR
Shift A | Day | 2012119 | RATHUL
Shift A | Day | 2013038 | FEDER EKKA
Shift A | Day | 2013037 | ANTONIS TIRKEY
Shift A | Day | 2012055 | RAJU
Shift A | Day | 2012009 | TIPPANNA
Shift A | Day | 2013041 | [NAME]
Shift B | Night | 2012003 | GOPAL SHRIYAN
Shift B | Night | 2012038 | PRABHAKAR
Shift B | Night | 2012035 | [NAME]
Shift B | Night | 2012071 | DEEPAK TIGGAL
Shift B | Night | 2012075 | SATHISH KERKETTA
Shift B | Night | 2012143 | SANDEEP BACK
Shift B | Night | 2012022 | [NAME]