tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 823793d1680140603-excel-formula-to-calculate-duration-based-on-three-activity-levels-with-reset-for-each-cha-book1
Sheet: Sheet1

 | Duration | Level | Sum Duration
1 | 00:15:00 | 1
 | 00:16:00 | 2
 | 00:17:00 | 2
 | 00:15:00 | 2
 | 00:16:00 | 2
 | 00:15:00 | 2
 | 00:15:00 | 2
 | 00:18:00 | 2
 | 00:15:00 | 2
 | 00:17:00 | 2
 | 00:15:00 | 2
 | 00:15:00 | 2
 | 00:15:00 | 2
 | 00:15:00 | 3
 | 00:15:00 | 3
 | 00:15:00 | 2
 | 00:15:00 | 3
 | 00:15:00 | 1
 | 00:15:00 | 1
 | 00:15:00 | 2
Spreadsheet: darron_c_giron__7905__LincolnLS
Sheet: 2002

 |  | Lincoln LS Sport
 |  | Invoice | MSRP |  | TMV
 | Base | 34983 | 38075 |  | 35590
 | [NAME] | 874 | 1005 |  | 900
 | All-Season Package | 640 | 735 |  | 659
 | Destination | 610 | 610 |  | 610
 | Over Invoice | 500 |  |  | 0
 | Tax
 | Title | 100 |  |  | 100
 | License | 50 |  |  | 50
 | Ford Citibank | -417 |  |  | -417
 | Driver Edge Citibank | -1118 |  |  | -1118
 | Down Payment | -2200 |  |  | -2200
 | Payment
 | Interest Rate | 0.07 |  |  | 0.07
 | Months | 60 |  |  | 60
Spreadsheet: john_griffith__15919__11_14_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 20 | 55 | 65 | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 20 | 255 | 265 | 55.9 | 58.1 | 0.72 | 2001-11-14 10:23:00
 | CL G2 | 20.5 | 355 | 370 | 52.7 | 54.9 | 0.69 | 2001-11-14 10:23:00
 | CL H2 | 20.5 | 410 | 440 | 50.5 | 54.3 | 0.68 | 2001-11-14 10:23:00
 | CL J2 | 20.5 | 460 | 490 | 49.7 | 52.9 | 0.66 | 2001-11-14 10:23:00
 | CL K2 | 20.5 | 510 | 540 | 49 | 51.9 | 0.65 | 2001-11-14 10:23:00
 | CL M2 | 20.5 | 530 | 560 | 47 | 49.7 | 0.62 | 2001-11-14 10:23:00
 | CL N2 | 20.5 | 550 | 580 | 45.1 | 47.6 | 0.6 | 2001-11-14 10:23:00
 | CL Q2 | 20.5 | 555 | 585 | 42.8 | 45.1 | 0.57 | 2001-11-14 10:23:00
 | CL U2 | 20.5 | 560 | 590 | 41 | 43.3 | 0.54 | 2001-11-14 10:23:00
 | [NAME] | 20.5 | 562 | 592 | 39.1 | 41.2 | 0.52 | 2001-11-14 10:23:00
 | CL X2 | 20.5 | 565 | 595 | 37.6 | 39.7 | 0.5 | 2001-11-14 10:23:00
 | [NAME] | 20.5 | 570 | 600 | 36.6 | 38.6 | 0.48 | 2001-11-14 10:23:00
 | CL M3 | 20.5 | 565 | 595 | 30.5 | 32.2 | 0.4 | 2001-11-14 10:23:00
 | CL Z3 | 20.5 | 565 | 595 | 27.1 | 28.5 | 0.36 | 2001-11-14 10:23:00
Spreadsheet: sally_beck__36247__East PG&E
Sheet: East PG&E

 |  | Deal | Physical/ | 2001 |  | 2002 |  | 2003 |  | 2004
Portfolio | Counterparty | Cat Code | Financial | Peak Prc PL | OPeak Prc PL | Peak Prc PL | OPeak Prc PL | Peak Prc PL | OPeak Prc PL | Peak Prc PL | OPeak Prc PL | Total
EAST | PGEENEPOWLP | CMDTY | Financial | -1955874.44 | 346004.18 | -1042961.72 |  | 1086250.53 |  |  |  | -1566581.46
EAST | PGEENEPOWLP | CMDTY | Physical | 40087899.8 | -2921937.8 | 10840813.89 | -6961551.28 | 399698.16 | -8263440.84 | 808197.61 | -7876522.07 | 26113157.48
EAST | PGEENEPOWLP | CPCTY | Physical | 4354836.49 | 2178030.19 | 584166.47 | 292077.34 |  |  |  |  | 7409110.49
Grand Total: |  |  |  | 42486861.85 | -397903.43 | 10382018.64 | -6669473.94 | 1485948.68 | -8263440.84 | 808197.61 | -7876522.07 | 31955686.51
Spreadsheet: 77072d1277505435-calculating-commissions-commission_sample-1-
Sheet: JOE GOLDMAN

 | MONTH: |  |  | 2010-06-01 00:00:00
 | ACCOUNT EXECUTIVE: |  |  | ACCOUNT EXECUTIVE
 |  |  |  |  |  |  |  | GOAL ISSUE #1 |  | 2586.19 | 2000
 | 2009 ISSUE #1 SALES: |  |  | 2417 |  |  |  | GOAL ISSUE #2 |  | 2140 | 2000
 | 2009 ISSUE #2 SALES: |  |  | 2000 |  |  |  | TOTAL GOAL: |  |  | 4000
 |  |  |  |  |  |  |  | SALES ISSUE #1 |  |  | 2000 | 1
 |  |  |  |  |  |  |  | SALES ISSUE #2 |  |  | 2400 | 1.2
 | Sales For the Month: |  |  |  |  |  |  | TOTAL SALES: |  |  | 4400 | 1.1
 |  | Below sales goal: | 0.06
 |  | At goal to 109.9% | 0.08 |  |  |  |  | PERCENT CHG: |  |  | 0.6
 |  | 110% of goal or higher | 0.1
 |  |  |  |  |  |  |  | PAYMENTS RECEIVED: |  |  | 1000
 |  |  |  |  |  |  |  | INCENTIVE PAYMENT PERCENTAGE: |  | #N/A |  | 0.1
 |  |  |  |  |  |  |  | TOTAL INCENTIVE: |  | 0 |  | 440
 |  |  |  |  |  |  |  | SIGNED BY:
 |  |  |  |  |  |  |  | MANAGER:
 |  |  |  |  |  |  |  | DEPARTMENT HEAD:
Spreadsheet: dan_hyvl__4697__LA Dept of Water & Power Master Physical 03282001
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-03-28 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Los Angeles Dept. of Water & Power | CONTACT: | Mr. [NAME]
ADDRESS: | 10322 Sunland Blvd. | TITLE:
 | Sunland, CA 91040 | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | 10000000 | 25000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp.
LIMIT in $[NAME]
Incorporation State: |  | Oregon
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | X | X
-Below = | A2 (see Note 1 below) | BBB- (See Note 1 below)
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-EBITDA/Interest
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 10000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:  X
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS | 1.  Debt rating for Los Angeles Dept. of Water & Power is Moody's rating on Power System
 | Revenue Bonds, 2001 Series A.  Debt rating for Enron is Standard & Poor's underlying credit
 | rating.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: 158889d1338430010-looking-up-an-id-in-another-worksheet-and-return-multiple-values-into-one-cell-copy-of-testdata
Sheet: Cards

Card ID | Purchases (comma separated)
ZE04GAZ01A
[NAME]
ZE04GAZ01Z
ZE04GAZ01D
ZE04GAZ01E
ZE04GAY02A
[NAME]
ZE05GAY01A
[NAME]
ZE05F0401G
ZE05F0501A
ZE05F0501G
ZE05F0501Z
ZE05F0801A
[NAME]
ZE06F0102G
ZE06F0102Z
ZE06F1P01A
ZE06F1P01G
ZE06F1P01Z
Spreadsheet: benjamin_rogers__928__PJM Operational Summaries
Sheet: 02-21-02

2002-02-21 08:00:38
 | Operations Summary for Today's Forecast Peak
A | Internal Scheduled Capacity | 39361
B | Scheduled Tie Flows | 2973
C | Capacity Adjustments | 0
D | Total Scheduled Capability | 42335
E | PJM Load Forecast | 34000
F | Operating Reserve | 8335
G | Unscheduled Capacity | 8829
 | Scheduled Tie Flow Breakdown
H | APS | 1778
I | FE | 722
J | NYPP | 95
K | VP | 378
L | Total | 2973
M | Forecast Eastern Transfer Limit | 5700
N | Forecast Central Transfer Limit | 3900
O | Forecast Western Transfer Limit | 5500
 | Previous Periods Operation Summary
 |  | Day | Evening | Midnight
P | Hour | 900 | 1900 | 400
Q | PJM  [NAME] | 32300 | 34500 | 23500
R | Actual  Load | 32654 | 34068 | 23579
S | West Dispatch Rate ($/MWhr) | 17.94 | 24.54 | 14.55
T | East Dispatch Rate ($/MWhr) | 17.94 | 24.54 | 14.55
Spreadsheet: 680832d1591214630-formula-to-pull-data-from-another-sheet-sum
Sheet: D

20 | Gross | FICA | Mcare | Fed Tax | State Tax | Net
2020-01-15 00:00:00 | 7494.48 | 464.64 | 108.66 | 422 | 113 | 6380.91
2020-01-20 00:00:00 | 1000 |  |  | 12 | 10
2020-01-31 00:00:00 | 9871.86 | 612.05 | 143.15 | 555 | 172 | 8382.760000000002
2020-02-15 00:00:00 | 8068.22 | 500.21 | 116.99 | 503 | 145 | 6798.52
2020-02-29 00:00:00 | 9341.630000000003 | 579.18 | 135.46 | 485 | 146 | 7975.990000000002
2020-03-15 00:00:00 | 9469.83 | 587.11 | 137.33 | 558 | 193 | 7924.390000000002
2020-03-31 00:00:00 | 9023.33 | 559.42 | 130.83 | 397 | 128 | 7808.08
2020-04-15 00:00:00 | 7696.11 | 477.15 | 111.59 | 515 | 186 | 6386.370000000001
2020-04-30 00:00:00 | 11560.69 | 716.77 | 167.6499999999999 | 674 | 282 | 9630.269999999999
2020-05-15 00:00:00 | 9577.61 | 593.8 | 138.88 | 540 | 220 | 8004.930000000001
2020-05-31 00:00:00 | 12313.25 | 763.41 | 178.55 | 627 | 288 | 10416.29
Spreadsheet: 711821d1609931390-repeat-a-row-multiple-times-sample-file
Sheet: Sheet1

[NAME] | Name | UserId | Department | Role | Region | DBM Code | State | S Code | Dealership Location | Vertical
36971 | Deependra Kumar | 34882 | Aftermarket | ASM | WEST | 8400 | MAHARASHTRA | 1S3054 | Satara | Common
36971 | Deependra Kumar | 34882 | Aftermarket | ASM | WEST | 8401 | MAHARASHTRA | 1S3323 | Karad | Common
37018 | [NAME] | 34940 | Aftermarket | CSM | WEST | 8400 | MAHARASHTRA | 1S3054 | Satara | Common
37018 | [NAME] | 34940 | Aftermarket | CSM | WEST | 8401 | MAHARASHTRA | 1S3323 | Karad | Common
Spreadsheet: 867347d1714160825-failed-if-function-pasta1
Sheet: Planilha1

 |  |  |  |  |  |  | 15000
 |  | 1500 | 0 | 0 | 0 | 0
 |  | 0 | 500 | 0 | 0 | 0 |  |  | How can I solve the SE formula when I don't
 |  | 0 | 0 | 0 | 0 | 0 |  |  | there is no value in columns C and D the condition fails, the account is not realized correctly, it does not continue with the balance.
 |  | 2500 | 0 | 0 | 0 | 0 |  |  | Can you solve this problem?
 |  | 0 | 0 | 0 | 0 | 0
 |  | 3500 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 8000 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 155866d1337090104-sum-function-not-totalling-properly-book1
Sheet: Sheet1

Supervisor | Employee | Week 1 Sales | Week 2 Sales | Total Sales
Rich | [NAME] | 0 | 0 | 0
Rich | Mark | 3 | 1 | 4
Rich | [NAME] | 3 | 0 | 3
RIch | [NAME] | 3 | 1 | 4
Rich | Jon | 2 | 2 | 4
Rich | [NAME] | 1 | 1 | 2
Rich | [NAME] | 1 | 0 | 1
Rich | Enrique | 0 | 0 | 0
[NAME] | [NAME] | 2 | 3 | 5
[NAME] | [NAME] | 1 | 7 | 8
[NAME] | [NAME] | 0 | 4 | 4
[NAME] | [NAME] | 2 | 5 | 7
[NAME] | [NAME] | 1 | 1 | 2
[NAME] | [NAME] | 0 | 2 | 2
[NAME] | Sanchez | 0 | 4 | 4
[NAME] | [NAME] | 0 | 0 | 0
[NAME] | [NAME] | 0 | 4 | 4
[NAME] | Greg | 0 | 0 | 0
[NAME] | [NAME] | 3 | 3 | 6
[NAME] | [NAME] | 1 | 5 | 6
[NAME] | Micah | 2 | 4 | 6
[NAME] | Haley | 5 | 5 | 10
[NAME] | [NAME] | 3 | 1 | 4
[NAME] | Sonia | 2 | 0 | 2
 |  | 26 | 51 | 81
Spreadsheet: 31433d1227266659-multiple-results-in-sheet-1-one-complex-formula-in-sheet-2-example2
Sheet: Sheet2

Formula1 | 28782 |  | List of values
Formula2 | 1.474358974358974 |  | 0.1 | 111 |  |  | The formulas shown here are just as an example
Formula3 | 28780.52564102564 |  | 0.2 | 222 |  |  | The real formulas are far more advanced
Formula4 | 1554 |  | 0.3 | 333
Formula5 (sum) | 30334.52569225068 |  | 0.4 | 444
 |  |  | 0.5 | 555
 |  |  | 0.6 | 666
 |  |  | 0.7 | 777
 |  |  | 0.8 | 888
 |  |  | 0.9 | 999
 |  |  | 1 | 1110
 |  |  | 1.1 | 1221
 |  |  | 1.2 | 1332
 |  |  | 1.3 | 1443
 |  |  | 1.4 | 1554
 |  |  | 1.5 | 1665
 |  |  | 1.6 | 1776
 |  |  | 1.7 | 1887
 |  |  | 1.8 | 1998
 |  |  | 1.9 | 2109
 |  |  | 2 | 2220
Spreadsheet: 622ff9c9-079e-4b0c-96bc-37ec06a4ffe1
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. USTD) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. USTD) | PSY | USTD | USTD | USTD | USTD | USTD | USTD
Discipline codes:  USTD = 9900                                    (4 digits) | 4200 | 9900 | 9900 | 9900 | 9900 | 9900 | 9900
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for USTD 2323 = 0200    Local Code for USTD1201 = 1115 and USTD1101 = 1101 Local Code for USTD (Freshmen Seminar) = 1125 Local Code for USTD (Students Majoring in Math or Science) = 1150 Local Code for USTD (Career Dev.) = 1190                           (4 digits)
Long (L)  Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 746943d1631121840-if-or-isnumber-search-excel-if-or-isnumber-search-query
Sheet: Sheet1

 | Orange | [NAME] | Apple | Avocado
2021-09-06 00:00:00 | AMU | off | AMU | 0900-2130 GRHx
2021-09-07 00:00:00 | AMU | off | OFF | 0900-2130 GRHx
2021-09-08 00:00:00 | Study leave | Study leave | Study leave | 0900-2130 GRHx
2021-09-09 00:00:00 | off | SPA | (day in lieu) | 0900-2130 GRHx
Spreadsheet: 546890d1510246683-combining-18-columns-into-5-columns-testdata
Sheet: Sheet1

actual data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wanted format (have tried to work it out but subject 2 is not giving expected results)
NAME | ENGLISH | FRENCH | MATHS | ADD MATHS | ENGLISH LIT | FRENCH LIT | SOCIOLOGY | [NAME] | ACCOUNTS | ART | TRAVEL N TOURISN | COMPUTER | PHYSICS | CHEMISTRY | BIOLOGY | DC | DT | ENTERPRISE | PHYSICAL EDUCATION | BUSINESS ST | AL |  | subject 1 marks | subject 1 name | subject 2 marks | subject 2name | subject 3 marks | subject 3 name | subject 4 marks | subject 4 name | subject 5 marks | subject 5 name
AUCHOYBUR [NAME] | 57 | 62 | 41 | 12 | 56 |  | 20 | 53 | 58 |  |  |  |  |  |  |  |  |  |  | 80
[NAME] | 53 | 44 | 26 |  |  | 56 |  |  | 31 |  |  | 32 | 14 | 11
[NAME] | 59 | 65 | 33 | 9 |  |  |  |  |  | 86 |  |  | 27 | 30 |  | 72
[NAME] Farook | 66 | 62 | 79 | 75 |  |  | 45 |  |  |  |  | 62 | 80 | 73 |  |  |  |  |  |  | 45
[NAME] | 53 | 47 | 15 | 6 |  |  |  | 17 | 34 | 56 |  |  |  |  |  |  | 29
[NAME] | 59 | 46 | 42 | 12 |  |  |  |  |  | 44 |  |  | 45 | 25 |  | 67
DHOOCHOO Hrithik | 61 | 62 | 76 | 61 |  |  |  |  |  | 59 |  |  | 46 | 62 |  | 68
DOOKHEE Dohish Datch | 47 | 50 | 27 |  |  | 5 |  |  | 33 |  | 19 |  |  |  |  | 46 |  |  | 47
FURCHEE Bhargavsingh | 48 | 53 | 22 | 13 |  |  |  |  |  |  |  | 15 | 23 | 17 | 17
GOOROODOYAL [NAME] | 62 | 55 | 48 | 21 |  |  |  |  |  | 63 |  |  | 60 | 48 |  |  | 82
[NAME] | 56 | 65 | 23 | 4 |  |  |  |  |  |  |  | 28 | 40 | 34 | 43
[NAME] | 59 | 71 | 18 | 4 |  |  |  |  |  |  |  | 21 | 24 | 12 |  |  | 56
KUTOAROO Dari Haid | 53 | 47 | 17 | 4 | 47 |  |  |  |  |  |  |  | 20 | 10 |  |  | 27
L'ESPAR [NAME] | 46 | 57 | 50 | 21 |  |  |  |  |  |  |  | 38 | 40 | 42 |  | 46
MOONEESAWMY Ezhumalai O. | 75 | 58 | 75 | 40 |  | 56 |  |  |  |  |  |  | 40 | 32 |  |  | 91 |  |  |  | 74
MUNEERAM Usdave | 58 | 54 | 60 | 40 |  |  |  |  | 40 | 53 | 66 |  |  |  |  |  |  |  |  | 52
NOWBUTH [NAME] | 58 | 64 | 64 | 20 |  |  |  |  |  | 46 |  |  | 40 | 20 |  | 86
PANDOO [NAME] | 62 | 65 | 20 | 3 |  |  |  |  |  | 64 |  |  | 50 | 23 |  |  | 92
PICOT [NAME] | 58 | 77 | 56 | 46 |  |  |  |  |  | 60 |  |  | 71 | 38 |  |  | 82
POINEN Parvesh | 66 | 70 | 87 | 78 |  |  | 80 |  | 75 |  |  |  | 55 |  |  | 86
[NAME] | 66 | 58 | 52 | 25 |  |  |  |  |  |  |  | 57 | 60 | 37 |  |  | 76
RAMGOOLAM Sharvyn | 60 | 71 | 70 | 53 |  |  |  |  |  |  |  | 57 | 34 | 36 |  | 73
RUNGASAMY Krishna | 61 | 81 | 86 | 54 |  |  |  |  |  |  |  | 68 | 55 | 62 |  | 89
RUNGASAMY Neel | 54 | 61 | 32 | 14 |  |  |  |  |  |  |  | 57 | 26 | 29 |  |  |  |  | 50
SEETLOO [NAME] | 79 | 40 | 94 | 63 |  |  |  |  |  | 56 |  | 78 | 68 | 66 |  |  |  |  |  |  | 84
SOOBARAH Rohunsingh | 69 | 76 | 74 | 25 |  |  |  |  |  |  |  | 45 | 60 | 28 |  |  | 85
TAJOO [NAME] | 47 | 61 | 43 | 15 |  |  |  |  |  |  |  | 43 | 20 | 39 | 33
TARACHAND Tooshar Rohit | 67 | 77 | 88 | 75 |  |  |  |  |  |  |  | 69 | 60 | 76 | 86
THANDROYEN Tirougen Krishiven     ® | 47 | 61 | 86 | 23 |  |  |  |  |  |  |  | 42 | 30 | 14 |  | 98
Spreadsheet: 832918d1686668231-how-to-return-a-value-in-a-column-when-a-match-is-found-in-a-below-array-lookup-v3-multi-worksheet
Sheet: WORKSHEET 2

 | ALL | [NAME] | [NAME] | [NAME] | [NAME]
2023-06-05 00:00:00
2023-06-06 00:00:00 | Polish | Polish
2023-06-07 00:00:00 | Vacuum |  |  | Vacuum
2023-06-08 00:00:00
2023-06-09 00:00:00 | Mop |  | Mop
2023-06-10 00:00:00 | [NAME] |  |  |  | [NAME] |  |  | Notes
 |  |  |  |  |  |  |  | Col A - Dates that task is assigned to
 |  |  |  |  |  |  |  | Row 1 - Names of Team Member is assign too
 |  |  |  |  |  |  |  | [NAME] tasks are unique i.e. they are not duplicated so when the search function finds the task it doesn't need to consider duplicates
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
Positive = due [NAME]
Negative = due operator
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | index
El Paso |  |  |  | Volumetric | [NAME] |  |  |  |  |  |  |  |  | SJ
PG&E |  |  |  | Volumetric | [NAME] |  |  |  |  |  |  |  |  | AVG
NGPL |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Duke |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | This balance is cashed out every month $214,357 is the 11/30/00 balance
[NAME] |  |  |  | Volumetric | Hernandez
Lonestar |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
PG&E TX |  |  |  | Dollar Valued | [NAME] | This balance is cashed out every month
Receivable imbalances
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Northwest |  |  |  | Volumetric | [NAME]
Pan-Alberta-shipper |  |  | 2000-11-30 00:00:00 | Dollar Valued | [NAME] | no payback to date
EOG |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 25 May 20 - 30 May 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-05-25 00:00:00 | 2020-05-26 00:00:00 | 2020-05-27 00:00:00 | 2020-05-28 00:00:00 | 2020-05-29 00:00:00 | 2020-05-30 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 25/05/2020 - 30/05/2020
Dameon |  |  |  |  |  |  |  |  |  | Dameon
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Harley |  |  |  |  |  |  |  |  |  | Harley
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Nathan |  |  |  |  |  |  |  |  |  | Nathan
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Tyson |  |  |  |  |  |  |  |  |  | Tyson
Will |  |  |  |  |  |  |  |  |  | Will
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
Edge Protection [NAME] |  |  | 25/05/2020 - 30/05/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 25/05/2020 - 30/05/2020
Laminex |  |  |  |  |  |  |  |  |  | Dameon
Wilson |  |  |  |  |  |  |  |  |  | [NAME]
Canterbury Linen Services |  |  |  |  |  |  |  |  |  | [NAME]
8 Cable Street |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Harley
 |  |  |  |  |  |  |  |  |  | [NAME]
Incidents/Accidents/Near Misses - Site |  |  | Type |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Nathan
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Tyson
 |  |  |  |  |  |  |  |  |  | Will
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
*** Means received but had to ask for it
❌   Means did not get one at all
Spreadsheet: 810862d1672138982-formula-to-establish-unused-components-s666-pq-establish-unused-components
Sheet: Sheet1

Part | Fabricated with | StatusA |  | Part | Fabricated with | StatusA | StatusB
2003004 | W100378 | INACTIVE |  | 2003004 | W100378 | INACTIVE | ACTIVE
2003004 | W142008 | INACTIVE |  | 2003004 | W125085 | INACTIVE | INACTIVE
2003004 | W125085 | INACTIVE |  | 2003004 | W135023 | INACTIVE | INACTIVE
2003004 | W135023 | INACTIVE |  | 2003004 | W142008 | INACTIVE | INACTIVE
2003007 | W100378 | ACTIVE |  | 2003007 | W100378 | ACTIVE | ACTIVE
2003007 | W500603 | ACTIVE |  | 2003007 | W178314 | ACTIVE | ACTIVE
2003007 | W178314 | ACTIVE |  | 2003007 | W500603 | ACTIVE | ACTIVE
Spreadsheet: 781277d1653127985-obtain-the-numbers-of-a-list-depending-the-name-distribui-o-de-pe-as
Sheet: MARIA CARMO

 |  |  | MARIA DO CARMO
 |  |  | Nª PEÇA | DESCRIÇÃO | VALOR
Spreadsheet: 775839d1649344884-drop-down-menu-with-no-blanks-tendina
Sheet: fonte

NOME | ALIMENTO |  | CON DATI PREIMPOSTATI |  |  |  |  | CON DATI NON [NAME] (da nascondere) |  |  |  |  | SOLUZIONE
Pippo | mela | Pluto
Pippo | pera | Topolino
Pippo | banana | Gastone
Pluto | fragola
Topolino | pera
Pluto | ribes
Topolino | ananas
Gastone | ciliegia
Spreadsheet: 151431d1334916557-help-left-right-mid-function-sample-test
Sheet: Sheet4

Reference | MID() |  | VALUE()
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000.10" | 242000.1 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
242000 | 242000 |  | 242000
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A
242000 | 242000 |  | 242000
"£242,000" | 242000 |  | #N/A
"£242,000" | 242000 |  | #N/A