tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b1cc7c80-7615-44ee-b65e-def9559b8a78
Sheet: DOSEN PENGAMPU  

NAMA DOSEN PENGAMPU PLPG TAHAP I
GUGUS UKSW SALATIGA
No | NIA | Nama
x |  | Pimpinan UNNES
0 |  | Panitia
1 | [PHONE] | Dr. [NAME],M.Si
2 | [PHONE] | [NAME], [NAME]., [NAME]
3 | [PHONE] | Prof. Dr. [NAME], M.Pd
4 | [PHONE] | [NAME], S.Pd, M.Si
5 | [PHONE] | Mawardi, S.Pd., M.Pd.
6 | [PHONE] | Dra. [NAME], M.Pd
7 | [PHONE] | [NAME], Drs., M.Si
8 | [PHONE] | Susiyanto, Drs., [NAME]
9 | [PHONE] | Dr. [NAME], [NAME].
10 | [PHONE] | Prof. Dr. Sutriyono, M.Sc
11 | [PHONE] | [NAME], Drs., [NAME]
12 | [PHONE] | Prof.[NAME], Ph.D
13 | [PHONE] | [NAME], Drs., [NAME]
14 | [PHONE] | Entri Sulistari G, Dra., M.Si
15 | [PHONE] | [NAME], [NAME]., [NAME]
16 | [PHONE] | Drs. [NAME] CH.D. Mirakaho, M.Si
17 | [PHONE] | Dr. [NAME], M.Si
18 | [PHONE] | [NAME], S.Pd.,M.Si
19 |  | Drs. [NAME], M.Pd
20 |  | Drs. Suroso,[NAME]
21 |  | [NAME],S.Pd.[NAME]
22 |  | Wahyudi,S.Pd.[NAME]
23 |  | [NAME],S.Si,M.Pd
24 |  | Drs. [NAME], M.Pd
25 |  | Dra. Sulistyowati,M.Sc.
26 |  | Drs. [NAME],M.Si
27 |  | [NAME],S.Pd.[NAME]
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: SoCal

 | 10487 |  | 56697
Day | Scheduled | Measured | Scheduled | Measured
1 | 810400 | 811178
2 | 798377 | 817950
3 | 810400 | 810147
4 | 819200 | 819990
5 | 819169 | 790215
6 | 779999 | 787806
7 | 764470 | 759227
8 | 668435 | 698398
9 | 667373 | 671567
10 | 625441 | 626989
11 | 649239 | 661026
12 | 627344 | 662954
13 | 724592 | 674556
14 | 805114 | 747120
15 | 805204 | 811143
16 | 804000 | 804547
17 | 805600 | 778899 | 20000 | 22550
18 | 811200 | 813902 | 20000 | 20370
19 | 807200 | 811066 | 8800 | 8940
20 | 778465 | 764057 | 30000 | 30285
21 | 810035 | 799478 | 20000 | 20314
22 | 796855 | 818407 | 30000 | 30403
23 | 800945 | 808470 | 50000 | 51046
24 | 812800 | 813669 | 30000 | 30058
25 | 806398 | 809786 | 30000 | 29992
26 | 807200 | 789041 | 30000 | 29950
27 | 792137 | 794358
28 | 752672 | 753693
29 | 809154 | 810826 | 50000 | 51254
30 | 795156 | 791139 | 30000 | 17856
31 | 806720 | 804887 | 30000 | 29796
2001-04-30 00:00:00 |  |  |  |  | 39224
2001-05-31 00:00:00
Spreadsheet: 70056d1270719616-nested-if-statement-trouble-example-formula-problem-sample
Sheet: MAIN

Maturity | Yrs to Maturity | Loan / Bond | Currency | Base Interp. Libor / gove
2012-03-31 00:00:00 | 1.980821917808219 | Loan | EUR | 0.014075625
2012-03-31 00:00:00 | 1.980821917808219 | Bond | EUR | 0.008748750000000001
2014-03-31 00:00:00 | 3.980821917808219 | Loan | EUR | 0.020773125
2013-03-31 00:00:00 | 2.980821917808219 | Loan | GBP | 0.020609875
2014-03-31 00:00:00 | 3.980821917808219 | Loan | EUR | 0.020773125
2014-11-19 00:00:00 | 4.619178082191781 | Loan | EUR | 0.0225525
2014-07-01 00:00:00 | 4.232876712328767 | Bond | EUR | 0.017525
Spreadsheet: 377007d1423767259-calculate-the-home-win-streak-for-a-team-home-win-streak
Sheet: Sheet1

 |  |  | Home Away |  | Home | Visitor | W/L |  | Win streak | Home Win Streak | Results
 |  |  | vs |  | 90 | 95
 |  |  | @ |  | 114 | 108
 |  |  | @ |  | 82 | 101
 |  |  | @ |  | 100 | 102
 |  |  | @ |  | 110 | 101
 |  |  | vs |  | 118 | 111 |  |  |  |  | 1
 |  |  | @ |  | 122 | 121
 |  |  | vs |  | 127 | 94 |  |  |  |  | 2
 |  |  | vs |  | 97 | 106
 |  |  | vs |  | 90 | 92
 |  |  | @ |  | 78 | 91
 |  |  | vs |  | 93 | 110
 |  |  | vs |  | 106 | 74 |  |  |  |  | 1
 |  |  | vs |  | 113 | 87 |  |  |  |  | 2
 |  |  | vs |  | 109 | 97 |  |  |  |  | 3
 |  |  | vs |  | 111 | 108 |  |  |  |  | 4
 |  |  | @ |  | 90 | 87
 |  |  | @ |  | 105 | 91
 |  |  | @ |  | 110 | 88
 |  |  | vs |  | 105 | 101 |  |  |  |  | 5
 |  |  | @ |  | 94 | 103
 |  |  | @ |  | 114 | 119
 |  |  | vs |  | 97 | 88 |  |  |  |  | 6
 |  |  | vs |  | 98 | 127
 |  |  | vs |  | 95 | 91 |  |  |  |  | 1
 |  |  | vs |  | 105 | 91 |  |  |  |  | 2
 |  |  | vs |  | 125 | 104 |  |  |  |  | 3
 |  |  | @ |  | 91 | 101
 |  |  | @ |  | 98 | 89
 |  |  | vs |  | 80 | 103
 |  |  | @ |  | 101 | 109
 |  |  | vs |  | 80 | 96
 |  |  | @ |  | 91 | 87
 |  |  | vs |  | 90 | 109
 |  |  | @ |  | 92 | 95
 |  |  | vs |  | 93 | 105
 |  |  | @ |  | 94 | 112
 |  |  | @ |  | 84 | 103
 |  |  | @ |  | 100 | 107
 |  |  | @ |  | 109 | 102
 |  |  | @ |  | 126 | 121
 |  |  | vs |  | 108 | 94 |  |  |  |  | 1
 |  |  | vs |  | 106 | 92 |  |  |  |  | 2
 |  |  | vs |  | 129 | 90 |  |  |  |  | 3
 |  |  | vs |  | 108 | 98 |  |  |  |  | 4
 |  |  | @ |  | 103 | 95
 |  |  | vs |  | 99 | 94 |  |  |  |  | 5
 |  |  | vs |  | 101 | 90 |  |  |  |  | 6
 |  |  | @ |  | 106 | 90
 |  |  | vs |  | 97 | 84 |  |  |  |  | 7
 |  |  | vs |  | 105 | 94 |  |  |  |  | 8
 |  |  | @ |  | 99 | 103
 |  |  | vs |  | 120 | 105 |  |  |  |  | 9
 |  |  | vs |  | 113 | 93 |  |  |  |  | 10
Spreadsheet: 96627d1295982382-data-massage-problem
Sheet: Good Data

First Name | Last Name | Address | City | State | Zip
[NAME] | Doe | 1122 Nice Street | Pleasantville | FL | 00000
[NAME] | Jones | 1122 Nice Street | Pleasantville | FL | 00000
[NAME] | Guns | 1122 Nice Street | Pleasantville | FL | 00000
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 3

 | Jan 4 | Jan 11 | Jan 18 | Jan 25 | Feb 1
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2307181 | 2360139 | 2354931 | 2371959 | 2375235
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 862900d1710474869-dynamic-lookup-that-omits-blank-rows-in-the-results-geddbconundrum
Sheet: Result1

 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 199025d1355040958-rank-on-two-different-criteria-sample
Sheet: Sheet1

Entry | Division | Category | Name | Score | Score | Score | Net Score | Rank
1 | A | Yes | White | 55 | 34 | 67 |  | 3 | Yes
2 | A | No | Black | 44 | 34 | 65 |  | 4 | No
3 | A | No | Red | 55 | 56 | 54 |  | 3 | No
4 | A | No | Yellow | 44 | 43 | 44 |  | 5 | No
5 | A | No | [NAME] | 55 | 67 | 45 |  | 2 | No
6 | A | Yes | Green | 66 | 76 | 57 |  | 1 | Yes
7 | A | No | White | 78 | 54 | 65 |  | 1 | No
8 | A | Yes | Orange | 76 | 56 | 65 |  | 2 | Yes
Spreadsheet: daren_farmer__5475__hpl0913
Sheet: Sheet1

HPLN0913.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 13, 2000
 |  |  |  |  |  | ** Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-09-13 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 60  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 213440d1360518373-help-needed-is-a-check-list-possible-book5
Sheet: Sheet1

Item Codes | Checked (TRUE/FALSE) |  |  |  |  |  |  |  | Checked off list
aa | 0 |  |  |  |  |  |  |  | bb
bb | 1 |  |  |  |  |  |  |  | gg
cc | 0 |  |  |  |  |  |  |  | dd
dd | 1 |  |  |  |  |  |  |  | hh
ee | 0
ff | 0
gg | 1
hh | 1
ii | 0
jj | 0
kk | 0
ll | 0
Spreadsheet: 594498d1539797950-mutiply-rows-if-date-columns-equal-to-a-full-year-calculate-with-full-year
Sheet: Blank Tab Sht (2)

Prepared by: | [NAME] |  |  |  | Date:
Region Name: | [NAME] |  | ` |  | Tel#:
 |  |  |  |  | CSO
[NAME]: | ME |  |  |  | Case Number
 |  |  |  |  | NCP: SSN
CP Name: |  |  |  |  | [NAME]: |  |  |  |  | Date of last payment on this review:
Principle | Interest |  | Penalty
 | Calculation Period  Begin Date   End Date |  |  | Pay  Freq | Pmts Due | Current  Ob. Amt. | Amount |  | Arrears |  | Amt.Subject Int & Pen | Interest (1%) | Penalty (.5%) | Total Amount  Due
 |  |  |  |  |  |  | Due | Paid | [NAME]. +/- | Principle
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
9064 | 1997-02-01 00:00:00 |  | 1997-12-31 00:00:00
 | 1998-01-01 00:00:00 |  | 1998-01-31 00:00:00
 | 1998-02-01 00:00:00 |  | 1998-02-28 00:00:00
 | 1998-03-01 00:00:00 |  | 1998-03-31 00:00:00
 | 1998-04-01 00:00:00 |  | 1998-04-30 00:00:00
 | 1998-05-01 00:00:00 |  | 1998-05-31 00:00:00
 | 1998-06-01 00:00:00 |  | 1998-06-30 00:00:00
 | 1998-07-01 00:00:00 |  | 1998-07-31 00:00:00
 | 1998-08-01 00:00:00 |  | 1998-08-31 00:00:00
 | 1998-09-01 00:00:00 |  | 1998-09-30 00:00:00
 | 1998-10-01 00:00:00 |  | 1998-10-31 00:00:00
 | 1998-11-01 00:00:00 |  | 1998-11-30 00:00:00
 | 1998-12-01 00:00:00 |  | 1998-12-31 00:00:00
 | 1999-01-01 00:00:00 |  | 1999-01-31 00:00:00
 | 1999-02-01 00:00:00 |  | 1999-02-28 00:00:00 |  |  |  |  | 964.14
 |  |  |  | Total Weeks
 |  |  |  |  |  |  |  |  | Account Summary
 |  |  |  |  |  |  |  |  | Beginning  Balance | OB Due | -Payments | Interest | Penalty | = Total  Amount Due
Prepared by: | [NAME] |  |  |  | Date:
Region Name: | [NAME] |  | ` |  | Tel#:
 |  |  |  |  | CSO
[NAME]: | ME |  |  |  | Case Number
 |  |  |  |  | NCP: SSN
CP Name: |  |  |  |  | [NAME]: |  |  |  |  | Date of last payment on this review:
Principle | Interest |  | Penalty
 | Calculation Period  Begin Date   End Date |  |  | Pay  Freq | Pmts Due | Current  Ob. Amt. | Amount |  | Arrears |  | Amt.Subject Int & Pen | Interest (1%) | Penalty (.5%) | Total Amount  Due
 |  |  |  |  |  |  | Due | Paid | [NAME]. +/- | Principle
 | 1999-03-01 00:00:00 |  | 1999-03-31 00:00:00 |  |  |  |  | 26.14
 | 1999-04-01 00:00:00 |  | 1999-04-30 00:00:00 |  |  |  |  | 18.87
 | 1999-05-01 00:00:00 |  | 1999-05-31 00:00:00 |  |  |  |  | 56.28
 | 1999-06-01 00:00:00 |  | 1999-06-30 00:00:00 |  |  |  |  | 44.64
 | 1999-07-01 00:00:00 |  | 1999-07-31 00:00:00 |  |  |  |  | 55.8
 | 1999-08-01 00:00:00 |  | 1999-08-31 00:00:00 |  |  |  |  | 25.34
 |  |  |  | Total Weeks
 |  |  |  |  |  |  |  |  | Account Summary
 |  |  |  |  |  |  |  |  | Beginning  Balance | OB Due | -Payments | Interest | Penalty | = Total  Amount Due
Spreadsheet: danny_mccarty__4661__XTRANSCO - Economics
Sheet: CF

PERIOD
Gross revenues | $
Revenues share | $
Net revenues | $
Direct cost | $
Marginal contribution | $
OPEX | $
EBITDA | $
Depreciation | $
EBIT | $
Interests | $
Taxes | $ | 0.34
Net Income | $
Interests | $
Investment in working capital | $
Capex | $
Initial Development Cost
Depreciation | $
Free Cash Flow | $
Running NPV | 0.15 | 0.03
IRR
Gross revenues | %
Revenues share | %
Net revenues | %
Direct cost | %
Marginal contribution | %
OPEX | %
EBITDA | %
Gross revenues | $/Unit
Revenues share | $/Unit
Net revenues | $/Unit
Direct cost | $/Unit
Marginal contribution | $/Unit
OPEX | $/Unit
EBITDA | $/Unit
Gross revenues | $[NAME]
Revenues share | $[NAME]
Net revenues | $[NAME]
Direct cost | $[NAME]
Marginal contribution | $[NAME]
OPEX | $[NAME]
EBITDA | $[NAME]
Spreadsheet: 66b1ea0c-c3a9-4e20-841c-90c6b7b6b6cb
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HCCAD | Test | HCCAD | Hepatitis C Virus Antibody Screen for Cadaveric or Hemolyzed Specimens, Serum | HCV Ab Cadaver/Hemolyzed Screen, S | HCCAD/87858: Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Plastic vial [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Negative | Monday, Wednesday, Friday; Varies | 1 day | 4 days | 1 | 86803 |  |  |  |  | Rochester
HCCAD | [NAME] | SERUM | Serum |  |  |  | Frozen | 30 days
HCCAD | Result | 87858 | HCV Ab Cadaver/Hemolyzed Screen, S | HCV Ab Cadaver/Hemolyzed Screen, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13955-0 | Hepatitis C virus Ab:ACnc:Pt:Ser:Ord:EIA
Spreadsheet: 870371d1716900875-regarding-copying-different-rows-in-excel-and-pasting-in-different-columns-excel-forums
Sheet: Sheet1

Gold Back Chain | 2 | 6.01 | A1 need to copied in HIJKL | B1 need to copied to h6 | C1 need to copied to L6
Gold besari | 489 | 84.09 | A2 need to copied to NOPQR | B2 need to copied to n6 | C2 need to copied to R6
Gold Chain 10GM | 2 | 20.11 | A3 neee to copied to TUVWX | B3 need to copied to t6 | [NAME] need to copied to x6 |  | Month |  | June |  |  |  | Month |  | June |  |  |  | Month |  | June
Gold Chain 12GM | 5 | 60.28 | 1. Page will be landscape
Gold Chain 16GM | 5 | 80.22 | 2. Per page 6 separate boxes will b there |  |  |  | Qty |  | Date | Less/Add | Actual |  | Qty |  | Date | Less/Add | Actual |  | Qty |  | Date | Less/Add | Actual
Gold Chain 24GM | 3 | 72.16 | 3. Left side values need to paste automatically in the right side empty columns
Gold chain 2GM | 2 | 4.23
Gold Chain 4GM | 5 | 20.47
Gold Chain 6GM | 5 | 30.08
Gold chain 8GM | 11 | 88.61
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: ACRL1

ACRL Statistics Questions 1-7, 2009-2010
Question | Measure | Total FY10 | Notes
Question 1 | [NAME] held June 30, 2010 |  | Add 50,098 to last year's total with the following footnote: ""E-books not previously counted have been added to [NAME]. The number of e-books added totals 50,098, of which 4,480 are NetLibrary titles, 44,573 are government publications, and 1,045 are miscellaneous."
Question 1b.i | [NAME] added - Gross | — | —
 | Serials (from Acquisitions Unit) | 2125 | Govt. Pubs not included.
 | Monographs (from Acquisitions Unit) | 11533 | Govt. Pubs not included.
Question 1b.ii | [NAME] withdrawn during year | — | —
 | Serials (from Acquisitions Unit) | 11999 | Govt. Pubs not included.
 | Monographs (from Acquisitions Unit) | 728 | Govt. Pubs not included.
Question 2 | Titles held June 30, 2010 | 916575 | Footnote: Includes branches."
Question 3 | Number of monographic volumes purchased | 7634 | Footnote: "Includes 1 purchased e-book on the ScienceDirect platform.
Question 4 | Basis of volume count is: | Physical | —
Question 5a | Number of serial titles currently purchased | — | —
Question 5a.i | Electronic (deduplicated) | 23671 | —
Question 5a.ii | Print (and other format) serials purchased | 721
Question 5a | 5a.i + 5a.ii
Question 5b | Number of serial titles current received but not purchased | —
Question 5b.i | Consortial | 7040
Question 5b.ii | Freely accessible | 19525
Question 5b.iii | Exchanges, gifts, etc. | 53
Question 5b.iv | Government documents | — | Provided by Govt. Pubs.
Question 5 | Total serials received: (a + b) | —
Question 6 | Government documents are included in count of Current Serials? | Yes
Question 7 | Microform units | —
 | Serials (from Acquisitions Unit) | 55
Spreadsheet: 77858d1278355033-excel-2007-averaging-no-blanks-and-no-zeros-over-several-sheets-test-monthly-1
Sheet: WK1 Wed

 | Monthly Total
 | Desktop |  | Network |  |  |  | Install | Add |  |  | Total
 | Opened |  | Opened
 | Closed |  | Closed
 | Backlog |  | Backlog
 | Frozen |  | Frozen
 | Active Install Tickets |  | 25
 | Install Tickets Frozen |  | 63
 | Install Tickets in Responded |  | 45
 |  |  |  |  |  | Fred
Spreadsheet: 843408d1695249644-intercompany-parent-child-comparison-test-62-
Sheet: Intercompany

Parent | ARC | 492088 | Parent
 | OLP | 562306 | BFR
 | CON | 853434
 | BFR | 400580
 | BLA | 10135
 | KFR | 117158
 | WFR | 820861
 | WMB | 433720
 | CPY | 17243
ARC | Parent | 582822
 | OLP | 398313
BFR | Parent | 922768
 | BLA | 38875
 | KFR | 327788
BLA | BFR | 261613
CPY | Parent | 773797
CON | Parent | 195935
KFR | Parent | 318826
 | WFR | 251057
OLP | Parent | 94056
 | ARC | 508830
WFR | Parent | 181762
 | KFR | 939574
 | WMB | 940392
WMB | Parent | 686766
Spreadsheet: 720769d1614280236-formula-to-identify-consecutive-month-of-gp-write-down-testbook
Sheet: Dashboard

Financially Challenge Project
 |  |  |  |  |  | Company | 17 |  |  |  |  |  |  |  | Company | 10
# | Contract # | Project Name | Last Month/Year of GP Write Down | Total GP Write Down |  |  |  |  | # | Contract # | Project Name | Last Month/Year of GP Write Down | Total GP Write Down
1 |  | Project B | January 2021 | -430164.16 |  |  |  |  | 1 | 1017013 | Project B | January 2021 | -430164.16
2 | 1718088. | Project A | October 2020 | -305694.98 |  |  |  |  | 2 | 1016030 | Project C | December 2020 | -3922.19
3 | 1718130. | Project D | December 2020 | -5294.5 |  |  |  |  | 3
4 | 1720085. |  | December 2020 | -4953.42 |  |  |  |  | 4
5 | 1016030. |  | December 2020 | -3922.190000000002 |  |  |  |  | 5
 | Using the GP History tab, looking for multiple GP reductions within the last 6 months.
 | Would need to reference column H for the company number.
 | Would then just sum the total GP write down (Column K) during the last 6 months.
 | Should list the largest GP write down first.
Spreadsheet: 782866d1654355914-formula-with-data-segmentation-help-a-brazilian-2022-06-03-oeldere2-pjuliocesar-seller-with-date-base
Sheet: SALES

 |  |  | Fill only with list, having all representatives, in the case "JULIO OR MURILO"
 |  |  | Fill only with list of cities. But conditional! That is, if the Representative was [NAME], the options for the cities will be those referring to [NAME], that is: Matinho or Grandes Lagos
 | DATA | SELLER | CITY | SALES
 | 2022-02-02 00:00:00 | JULIO | Grandes Lagos | 6
 | 2022-02-02 00:00:00 | JULIO | Matinho | 10
 | 2022-02-16 00:00:00 | JULIO | Grandes Lagos | 15
 | 2022-02-16 00:00:00 | JULIO | Matinho | 1
 | 2022-02-16 00:00:00 | JULIO | Grandes Lagos | 6
 | 2022-02-16 00:00:00 | JULIO | Matinho | 6
 | 2022-01-15 00:00:00 | MURILO | Curitiba | 3
 | 2022-01-15 00:00:00 | MURILO | Forteleza | 10
 | 2022-01-15 00:00:00 | MURILO | Curitiba | 11
 | 2022-01-15 00:00:00 | MURILO | Forteleza | 8
 | 2022-02-02 00:00:00 | MURILO | Curitiba | 10
 | 2022-02-16 00:00:00 | MURILO | Forteleza | 10
Spreadsheet: 852150d1702246295-excel-formula-to-extract-data-from-salary-sheet-to-payslip-match-payslip-adjustedgcb
Sheet: Payslip

 | Kindly asking for excel formula to extract data on the salary sheet to the Payslip sheet as
 | shown below. Where there is no amount the formula should leave out the naration e.g. Pension
 | on Doroth salary there is zero and pension is not included in the payslip. Thank you.
 | NB Select month and Employee name from the drop down list
 | Desired solution
 | PAYSLIP
 | 2023-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | January
 | Month | February |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  | April
 | Employee Name | [NAME] |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  | July
 | Eearnings | USD | ZWL |  |  | Deductions | USD | ZWL |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  | September
 | Over time | 45 | 150000 |  |  | NEC | 90 | 0 |  |  |  |  | October
 | Benefits | 0 | 90000 |  |  | PAYE |  | 45566.79296121158 |  |  |  |  | November
 | Bonus | 0 | 300000 |  |  | Aids Levy | 0.3834742802422658 | 1367.003788836347 |  |  |  |  | December
 |  |  |  |  |  | Net Pay | 96.83404971168221 | 493111.2032499521
 | Total | 245 | 540000 |  |  | Total | 232.2175239919245 | 540045
Spreadsheet: b03e09f1-25f6-4673-8f9a-3bd9daa2c63a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Adjustable-Volume Pipette Calibration | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  | Reference: ISO 8655-6:2002 (E)
Analyst: |  |  |  |  |  | Test Conditions |  |  |  | Begin
Date of Calibration: |  |  |  |  |  | Barometric pressure, kPa or mbar
Calibration due date: |  |  |  |  |  | Relative Humidity, %
Pipet manufacturer: |  |  |  |  |  | Ambient temp., degrees C
Serial/ID number: |  |  |  |  |  | Test liquid temp., degrees C
Volume range: |  |  |  |  |  | Z correction factor
Location of use:
Leak Test |  |  |  | Balance check |  |  |  |  |  | Weight | Units | Reading | Tolerance | Pass/Fail
Time begin: |  |  |  | Balance manufacturer
Time end: |  |  |  | Serial Number
Pass/Fail |  |  |  | Location of use
 |  |  |  | Weight set serial #
Pipet Calibration
Dial setting: |  |  | units: |  | Dial setting: |  |  | units: |  | Dial setting: |  |  | units:
Time begin: |  |  |  |  | Time begin: |  |  |  |  | Time begin:
Replicate | Mass | Units |  | Volume | Replicate | Mass | Units |  | Volume | Replicate | Mass | Units |  | Volume (V)
m1 |  |  |  |  | m1 |  |  |  |  | m1
m2 |  |  |  |  | m2 |  |  |  |  | m2
m3 |  |  |  |  | m3 |  |  |  |  | m3
m4 |  |  |  |  | m4 |  |  |  |  | m4
m5 |  |  |  |  | m5 |  |  |  |  | m5
m6 |  |  |  |  | m6 |  |  |  |  | m6
m7 |  |  |  |  | m7 |  |  |  |  | m7
m8 |  |  |  |  | m8 |  |  |  |  | m8
m9 |  |  |  |  | m9 |  |  |  |  | m9
m10 |  |  |  |  | m10 |  |  |  |  | m10
Mean mass |  |  |  |  | Mean mass |  |  |  |  | Mean mass
Time end: |  |  |  |  | Time end: |  |  |  |  | Time end:
Mean vol. |  |  |  |  | Mean vol. |  |  |  |  | Mean vol.
% RE |  |  |  |  | % RE |  |  |  |  | % RE
RE tolerance |  |  |  |  | RE tolerance |  |  |  |  | RE tolerance
s |  |  |  |  | s |  |  |  |  | s
%CV |  |  |  |  | %CV |  |  |  |  | %CV
[NAME] tolerance |  |  |  |  | [NAME] tolerance |  |  |  |  | [NAME] tolerance
PASS/FAIL |  |  |  |  | PASS/FAIL |  |  |  |  | PASS/FAIL
A leak test may be performed by filling the pipette tip with distilled or deionized water to the maximum nominal volume and placing the pipette on a vibration-free stand. Observe the meniscus in the tip for 1 minute. After 1 minute, there should be no visible droplet formation at the tip. If there are no signs of droplet formation, proceed with the calibration check. If droplet formation is observed, successful maintenance and corrective action must be taken or the pipette must not be used.
Complete green-shaded cells only (obtain Z Corr. Factor from Table 1 on Sheet 2). The spreadsheet will populate all unshaded cells for you. Obtain RE and CV tolerances from the
pipettor manufacturer's specifications. Use appropriate ASTM 1 or 2 tolerances for the balance checks (refer to sheet 3). If dial setting (volume) is in ml, mass should be recorded in
grams. If dial setting (volume) is in μl, mass should be recorded in milligrams.
COMMENTS/CORRECTIVE ACTION:
Spreadsheet: 163744d1340439338-help-matching-data-in-sheet1-based-on-data-on-sheet2-excel-pphg-oeldere-
Sheet: Sheet1

Hotel Code | Guest Name | Membership Status | Hotelname
ANBKK1 | Guest 1 | Gold
00AN | Guest 2 | Gold
ANAUH1 | Guest 3 | Silver
ANMLE1 | Guest 4 | [NAME]
00DC | Guest 5 | Gold
DC | Guest 6 | [NAME]
LONDON | Guest 7 | [NAME]
WDC | Guest 8 | Silver
00FH | Guest 9 | [NAME]
DKAALAAL | Guest 10 | [NAME]
NOSTAALS | Guest 11 | [NAME]
SESTOAMA | Guest 12 | Silver
[NAME] | Guest 13 | Gold
AX1ABPLAT | Guest 14 | Silver
AX1ACPLAT | Guest 15 | Silver
AX1ADPLAT | Guest 16 | [NAME]