tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729703d1619273741-how-to-check-and-count-two-column-content-simultaneously-aptitude-comparision-report
Sheet: FINAL

SL NO | USN | NAME | Pre-Assessment Score  (Out of 60) | Post Assessment Score  (Out of 60)
1 | 4CB17IS036 | PRATHAM SHEKAR S | ABSENT | 18
2 | 4CB18IS001 | [NAME] | 4 | ABSENT
3 | 4CB18IS002 | ANANYA ASHOK NAIK | 17 | 12
4 | 4CB18IS003 | ANANYA NANDA NAIK | 35 | 31
5 | 4CB18IS004 | ANUSHA B | 14 | 17
6 | 4CB18IS005 | ARCHANA ANANT SHANBHAG | 27 | 17
7 | 4CB18IS006 | ASHIKA S | 23 | ABSENT
8 | 4CB18IS007 | ASHMITHA SHENOY | 36 | 28
9 | 4CB18IS008 | SIRISH MAHADEVA BHAT | 40 | 30
10 | 4CB18IS009 | CHAITHRA V | 30 | ABSENT
11 | 4CB18IS010 | CHANDAN C RAO | 35 | 31
12 | 4CB18IS011 | CHARITRA RAO | 30 | 24
13 | 4CB18IS013 | DEEKSHA K | 29 | 21
14 | 4CB18IS014 | DHANYA HANUMANTHA NAIK | 35 | 11
15 | 4CB18IS015 | DHRITHI | 15 | 22
16 | 4CB18IS016 | DIVYARAJ K M | 13 | 19
17 | 4CB18IS017 | HARSHINI | 18 | ABSENT
18 | 4CB18IS018 | [NAME] | 18 | ABSENT
19 | 4CB18IS019 | K ASHWINI A SHENOY | 38 | 25
20 | 4CB18IS020 | KASAL [NAME] | 27 | 26
21 | 4CB18IS021 | KAUSHIK N S | 37 | ABSENT
22 | 4CB18IS022 | KRISHNA | 35 | 24
23 | 4CB18IS023 | MIHIR PRASHANTH SHETTY | 36 | 24
24 | 4CB18IS024 | NAVYA A | 19 | 17
25 | 4CB18IS025 | NAYAK TANMAY TARAK | 40 | 30
26 | 4CB18IS026 | NEHA KISHOR MUDHOL | 36 | 25
27 | 4CB18IS027 | [NAME] | 23 | 17
28 | 4CB18IS028 | NITHIN KAMATH | 22 | 16
29 | 4CB18IS030 | POOJA NARAYANA DUGGURU | 17 | 22
30 | 4CB18IS031 | QAMRATH AKTHAR SHEIKH | 36 | 19
31 | 4CB18IS032 | RASHMITHA | 23 | 31
32 | 4CB18IS033 | RIYA NATHASHA FERNANDES | 23 | 24
33 | 4CB18IS034 | SAMEEKSHA SHETTY | 36 | 28
34 | 4CB18IS035 | SHALMA AISHAL RODRIGUES | 42 | 34
35 | 4CB18IS036 | SHALMA PREETHI DSOUZA | 17 | 22
36 | 4CB18IS037 | SHIVALI | 25 | 18
37 | 4CB18IS038 | SHIVANI PURUSHOTHAM | 23 | 32
38 | 4CB18IS039 | SHREYA | 18 | 28
39 | 4CB18IS040 | SHREYAS | 18 | 24
40 | 4CB18IS042 | SNEHA PRABHU | 26 | 29
41 | 4CB18IS043 | SNEHA S | 43 | 29
42 | 4CB18IS044 | SRIRAKSHA SHETTY | 24 | 23
43 | 4CB18IS045 | SURABHI T | 17 | 20
44 | 4CB18IS046 | SUSHMITHA P SUVARNA | 8 | 37
45 | 4CB18IS047 | SWEEKRITHA . JEEVANDAS HEGDE | 18 | 30
46 | 4CB18IS048 | THUSHAR S KULAL | 23 | 28
47 | 4CB18IS049 | TRUPTI SURESH DESHBHANDARI | 33 | 24
48 | 4CB18IS050 | U RAMANATH N PAI | 15 | 28
49 | 4CB18IS051 | UDBHAV U | 22 | 23
50 | 4CB18IS052 | VARSHITHA | 15 | 19
51 | 4CB18IS053 | VIDYASHREE | 15 | 22
52 | 4CB18IS054 | VINDYA SANIL | ABSENT | 19
53 | 4CB18IS055 | VISHWA | 21 | 22
54 | 4CB18IS056 | VRUSHAB BANAJAWAD | 24 | 25
55 | 4CB18IS057 | [NAME] | 15 | 22
56 | 4CB19IS400 | TUSHARA NAIK | 31 | 13
 |  |  | COUNT | PERCENTAGE
 |  | TOTAL NO OF STUDENTS | 56
 |  | NUMBER OF IMPROVED  STUDENT COUNT | 22
 |  | NUMBER OF NOT IMPROVED  STUDENT COUNT | 24
 |  | ABSENTEES COUNT FOR  PRE-ASSESSMENT | 2
 |  | ABSENTEES COUNT FOR  POST ASSESSMENT | 6
Spreadsheet: phillip_m_love__30650__9906_OA
Sheet: EAST-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-EAST
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 827560d1682837321-minif-and-maxif-values-in-range-help-max-min-profit-example-1-1-
Sheet: Sheet1

year | month | Date | Open | High | Low | Close | Volume | volatility | 9 EMA | crossover | trade signal | [NAME] profit | [NAME] loss
2023 | 3 | 45002 | 24.93 | 25.51 | 24.1 | 24.57 | 201770300 | 0.0565583634175692 | 23.24948121859947 | long | entry/exit
2023 | 3 | 45005 | 24.43 | 24.92 | 23.889999 | 24.83 | 164178000 | 0.04216131805157602 | 23.56558497487958 | long
2023 | 3 | 45006 | 25.309999 | 26 | 24.93 | 25.879999 | 135145100 | 0.04227578199430194 | 24.02846777990366 | long
2023 | 3 | 45007 | 25.709999 | 26.959999 | 24.65 | 24.68 | 237918100 | 0.08984827265065243 | 24.15877422392293 | long
2023 | 3 | 45008 | 25.6 | 26.610001 | 24.879999 | 25.559999 | 196497200 | 0.06757820312499996 | 24.43901917913835 | long
2023 | 3 | 45009 | 25.440001 | 25.84 | 24.84 | 25.82 | 169794700 | 0.03930817455549628 | 24.71521534331067 | long
2023 | 3 | 45012 | 25.99 | 26.26 | 25.059999 | 25.290001 | 136795600 | 0.04617164293959217 | 24.83017247464854 | long
2023 | 3 | 45013 | 25.139999 | 25.139999 | 24.290001 | 24.870001 | 118020700 | 0.03381058209270411 | 24.83813817971883 | long
2023 | 3 | 45014 | 25.76 | 26.370001 | 25.57 | 26.23 | 119365300 | 0.03105593944099371 | 25.11651054377507 | long
2023 | 3 | 45015 | 26.82 | 27.09 | 26.49 | 26.940001 | 130150000 | 0.0223713646532439 | 25.48120863502006 | long
2023 | 3 | 45016 | 27 | 28.32 | 26.91 | 28.26 | 126571300 | 0.05222222222222223 | 26.03696690801605 | long
2023 | 4 | 45019 | 27.68 | 28.120001 | 27.33 | 28.059999 | 125116300 | 0.0285404985549133 | 26.44157332641284 | long
2023 | 4 | 45020 | 28.16 | 28.43 | 27.42 | 27.780001 | 116090400 | 0.0358664772727272 | 26.70925886113028 | long
2023 | 4 | 45021 | 27.469999 | 27.52 | 26.41 | 26.889999 | 129137000 | 0.0404077189809872 | 26.74540688890422 | long
2023 | 4 | 45022 | 26.459999 | 27.559999 | 26.110001 | 27.43 | 120960300 | 0.05479962414208711 | 26.88232551112338 | short | entry/exit
2023 | 4 | 45026 | 26.639999 | 27.379999 | 26.17 | 27.370001 | 118528800 | 0.04542038458785227 | 26.9798606088987 | short
2023 | 4 | 45027 | 27.360001 | 27.370001 | 26.700001 | 26.84 | 104260800 | 0.02448830319852686 | 26.95188848711896 | long | entry/exit
2023 | 4 | 45028 | 27.34 | 27.49 | 26 | 26.129999 | 174019300 | 0.05449890270665685 | 26.78751058969517 | long
2023 | 4 | 45029 | 26.530001 | 27.74 | 26.49 | 27.629999 | 123761500 | 0.04711647014261326 | 26.95600827175614 | short | entry/exit
Spreadsheet: 327920d1403721724-weighted-average-with-two-criteria-weighted-average-with-two-criteria
Sheet: Sheet1

Year | Amt. On hand | Cost/Unit
2011 | 55 | 0
2011 | 0.585 | 0
2009 | 0.9999999 | 85.1705
2010 | 3.9999996 | 59.3731
2010 | 0.45 | 41.6014
2010 | 0.08 | 41.6014
2010 | 1 | 41.6014
2010 | 1 | 41.6014
2010 | 2.42 | 41.6014
2011 | 49.999995 | 58.5319
2011 | 1.6666665 | 58.5319
2011 | 23465.84 | 48.5279
2011 | 20.78 | 48.5279
2011 | 0.42 | 48.5279
2011 | 0 | 48.5279
2011 | 44 | 48.5279
2011 | 0 | 0
Spreadsheet: 58848d1259112233-lookup-my-version-pcstandings-2009-early-2
Sheet: T&Pprint

TEAMS AND PLAYERS
 | OURS |  | TEAM B |  | TEAM C
 | TEAM A BAR |  | TEAM B BAR |  | TEAM C BAR
 | TEAM A - CAPTAIN |  | TEAM B - PLAYER 1 |  | TEAM C - PLAYER 1
 | TEAM A - PLAYER 2 |  | TEAM B - PLAYER 2 |  | TEAM C - PLAYER 2
 | TEAM A - PLAYER 3 |  | TEAM B - PLAYER 3 |  | TEAM C - PLAYER 3
 | TEAM A - PLAYER 4 |  | TEAM B - PLAYER 4 |  | TEAM C - PLAYER 4
 | TEAM A - PLAYER 5 |  | TEAM B - PLAYER 5 |  | TEAM C - PLAYER 5
 | TEAM A - SUB 1 |  | TEAM B - SUB 1 |  | TEAM C - SUB 1
 | TEAM A - SUB 2 |  | TEAM B - SUB 2 |  | TEAM C - SUB 2
 | TEAM A - SUB 3 |  | TEAM B - SUB 3 |  | TEAM C - SUB 3
 | TEAM D |  | TEAM E |  | TEAM F
 | TEAM D BAR |  | TEAM E BAR |  | TEAM F BAR
 | TEAM D - PLAYER 1 |  | TEAM E - PLAYER 1 |  | TEAM F - PLAYER 1
 | TEAM D - PLAYER 2 |  | TEAM E - PLAYER 2 |  | TEAM F - PLAYER 2
 | TEAM D - PLAYER 3 |  | TEAM E - PLAYER 3 |  | TEAM F - PLAYER 3
 | TEAM D - PLAYER 4 |  | TEAM E - PLAYER 4 |  | TEAM F - PLAYER 4
 | TEAM D - PLAYER 5 |  | TEAM E - PLAYER 5 |  | TEAM F - PLAYER 5
 | TEAM D - SUB 1 |  | TEAM E - SUB1 |  | TEAM F - SUB1
 | TEAM D - SUB 2 |  | TEAM E - SUB2 |  | TEAM F - SUB2
 | TEAM D - SUB 3 |  | TEAM E - SUB3 |  | TEAM F - SUB3
 | TEAM G |  | TEAM H |  | TEAM I
 | TEAM G BAR |  | TEAM H BAR |  | TEAM I BAR
 | TEAM G - PLAYER 1 |  | TEAM H - PLAYER 1 |  | TEAM I - PLAYER 1
 | TEAM G - PLAYER 2 |  | TEAM H - PLAYER 2 |  | TEAM I - PLAYER 2
 | TEAM G - PLAYER 3 |  | TEAM H - PLAYER 3 |  | TEAM I - PLAYER 3
 | TEAM G - PLAYER 4 |  | TEAM H - PLAYER 4 |  | TEAM I - PLAYER 4
 | TEAM G - PLAYER 5 |  | TEAM H - PLAYER 5 |  | TEAM I - PLAYER 5
 | TEAM G - SUB 1 |  | TEAM H - SUB 1 |  | TEAM I - SUB 1
 | TEAM G - SUB 2 |  | TEAM H - SUB 2 |  | TEAM I - SUB 2
 | TEAM G - SUB 3 |  | TEAM H - SUB 3 |  | TEAM I - SUB 3
 | TEAM J |  | TEAM K |  | TEAM L
 | TEAM J BAR |  | TEAM K BAR |  | TEAM L BAR
 | TEAM J - PLAYER 1 |  | TEAM K - PLAYER 1 |  | TEAM L - PLAYER 1
 | TEAM J - PLAYER 2 |  | TEAM K - PLAYER 2 |  | TEAM L - PLAYER 2
 | TEAM J - PLAYER 3 |  | TEAM K - PLAYER 3 |  | TEAM L - PLAYER 3
 | TEAM J - PLAYER 4 |  | TEAM K - PLAYER 4 |  | TEAM L - PLAYER 4
 | TEAM J - PLAYER 5 |  | TEAM K - PLAYER 5 |  | TEAM L - PLAYER 5
 | TEAM J - SUB 1 |  | TEAM K - SUB 1 |  | TEAM L - SUB 1
 | TEAM J - SUB 2 |  | TEAM K - SUB 2 |  | TEAM L - SUB 2
 | TEAM J - SUB 3 |  | TEAM K - SUB 3 |  | TEAM L - SUB 3
Spreadsheet: 342836d1409696050-event-calendar-with-recurring-event-140902_-calendar-of-events-2014-_-test
Sheet: Event Calendar - NOV

 |  |  |  | EVENT CALENDAR
 |  |  |  |  |  | ENTER MONTH: | November
 |  |  |  |  |  | ENTER YEAR: | 2014
 |  |  |  |  |  | ENTER START DAY: | Sunday
 | TO EVENT LIST >>
Spreadsheet: 827465d1682703144-sumifs-with-two-column-array-and-or-logic-sumifs-test
Sheet: Sheet1

Cost | [NAME] | [NAME]
10 | 90210 | 95678
11 | 95678 | 90210
12 | 80564 | 90210
13 | 62012 | 96634
14 | 33549 | 53312
15 | 66536 | 74884
16 | 47448 | 86134
17 | 59876 | 56483
18 | 95678 | 65413
19 | 90210 | 66879
20 | 90210 | 95678
What I'm trying to do |  |  |  |  | [NAME] | Result Notes
Sum if [NAME] = 90210 or 95678 |  |  |  |  |  | correct, using SUMIFS formula with 1 column
Sum if [NAME] = (90210 or 95678) AND [NAME] = (90210 or 95678) |  |  |  |  |  | should be "$41" (rows 2,3 and 12 are correct)
Sum if [NAME] = (90210 or 95678) AND [NAME] = (90210 or 95678) |  |  |  |  |  | correct, uses semi-colon instead of comma on Column array separator. Sometimes works, sometimes doesn’t.
Sum if [NAME] <> (90210 or 95678) AND [NAME] <> (90210 or 95678) |  |  |  |  |  | should be "$75" (rows 5-9 are correct)
Sum if [NAME] <> (90210 or 95678) AND [NAME] <> (90210 or 95678) |  |  |  |  |  | should be "$75", uses semi-colon instead of comma on Column array separator (rows 5-9 are correct)
Sum if [NAME] = (90210 or 95678) AND [NAME] <> (90210 or 95678) |  |  |  |  |  | should be "$37" (rows 10-11 are correct)
Sum if [NAME] = (90210 or 95678) AND [NAME] <> (90210 or 95678) |  |  |  |  |  | should be "$37", uses semi-colon instead of comma on Column array separator (rows 10-11 are correct)
Spreadsheet: 22962d1212171624-search-for-a-file-and-bring-back-data-to-master-spreadsheet-job-cost-summary
Sheet: Job Cost Summary

 |  |  | Materials-Steel & Misc |  |  |  | Materials-Joist & Deck |  |  |  | Fabrication Labor |  |  |  | Erection Labor |  |  |  | Subcontractors |  | Equipment Rental |  | Detailing |  |  |  | Detailing - Outside Contract
 | Latest | Project | Bid |  | Actual |  | Bid |  | Actual |  | Bid |  | Actual |  | Bid |  | Actual |  | Bid | Actual | Bid | Actual | Bid |  | Actual |  | Bid | Actual
Job # | Date | Name | Weight | Cost | Weight | Cost | Weight | Cost | Weight | Cost | Man Hrs | Cost | Man Hrs | Cost | Man Hrs | Cost | Man Hrs | Cost | Cost | Cost | Cost | Cost | Man Hrs | Cost | Man Hrs | Cost | Cost | Cost
4754 | 05/14/2008 07:56:32 AM | 4754  - Leander Elem School #19 |  |  | 145116 | 93393 |  |  | 0 | 52140 |  |  | 624.75 | 11672 |  |  | 2733.75 | 59868 |  | 11850 |  | 26333 |  |  | 153.5 | 3900 |  | 1800
4844 | 05/14/2008 07:57:17 AM | 4844  - Pflugerville First Bapt Church |  |  | 200 | 210 |  |  | GENERAL COSTS | Fabrication Labor |  |  | 1 | 100 |  |  | 105 |  |  | Erection Labor |  | G & A Labor |  |  | Materials-Steel & Misc | Materials-Joist & Deck |  | Subcontractors
4875
4884
4890
4900
4902
4903
4906
4907
4908
4909
4911
4913
Spreadsheet: 48292d1247526472-transposing-a-table-book10a
Sheet: Sheet1

Name: | Field | Original Tbl.
ABC | A
ABC | B
ABC | E
ABC | C
ABC | D
DEF | D
DEF | C
GHI | B
JKL | F
MNO | A
MNO | C
MNO | G
PQR | D
 |  |  |  |  |  |  |  | Hand typed Requested Tbl.
Name: | Field | Field | Field | Field | Field |  |  | Name: | Field | Field | Field | Field | Field
ABC | A | B | E | C | D |  |  | ABC | A | B | E | C | D
DEF | D | C |  |  |  |  |  | DEF | D | C
GHI | B |  |  |  |  |  |  | GHI | B
JKL | F |  |  |  |  |  |  | JKL | F
MNO | A | C | G |  |  |  |  | MNO | A | C | G
PQR | D |  |  |  |  |  |  | PQR | D
Hand typed Names
Spreadsheet: 115269d1310902293-changing-line-colour-when-entering-specific-text-example
Sheet: Sheet1

Business Unit | Sector | Contract name | Bid Manager | Open or Closed | Contract Value | Date Responded | Notes | Support Required | Link to Text | Feedback
B1 |  | WE1 | [NAME] | Closed |  | 3rd December | Started late as waiting for call with the [NAME] Manager
B2 | Civil Engineering | WE4 | [NAME] | Closed |  | 3rd December | EMP was a big response in itself | Lucinda
B1 |  | WE2 | [NAME] | Open | £175m  (£25m for 7 years)
B2 |  | WE6 | [NAME] | Closed | £20m approx. - bidding to be on a framework as well | 15th November | [NAME] supported this | [NAME]
Spreadsheet: 38360d1236526504-dynamic-formula-demand-calender
Sheet: Week

 | WEEKLY SUMMARY
 |  |  |  |  |  |  | WEEK | 6
 |  |  |  |  |  |  | YEAR | 09
 |  |  |  |  |  |  |  |  |  | TOTAL |  |  | [NAME] | [NAME] | [NAME]
 | INVENTORY |  | MON | TUE | WED | THU | FRI | SAT | SUN | TOTAL | TOTAL | TOTAL | BOB v FOR | FOR v BUD | [NAME]
 | 196 | ROOMS |  |  |  |  |  |  |  | BOB | FOR | BUD
 | BUSINESS ON THE                   BOOKS | ROOMS SOLD
 |  | OCC%
 |  | ADR
 |  | ROOMS REVENUE
 |  | REVPAR
Spreadsheet: 95551d1295136940-check-box-disable-dependent-on-another-cell-exmple-order-form
Sheet: Sheet1

 | Front End - visable to user |  |  |  | Back End - hidden from user
 | pick a pudding! | do you want custard? | Do you want Ice ream? |  | Pudding Number | [NAME]? | Ice Cream?
 |  |  |  |  | 1 | False | False
 | [NAME] bit i cant figure out!......... Use can select a pudding and elect to have custard or ice cream - customer should be able to select icecream with every pudding but can not have custard with puddings 5,6,7 & 8, additionally the user can only select one or the other.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True
 | select your choice
 | apple crumble
 | apple pie
 | jam rollypolly
 | ice cream
 | fruit salad
 | strawberrys
 | plain ice cream
Spreadsheet: michelle_lokay__26627__imbalsumm0102
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 |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock |  |  |  |  |  |  |  | NTXPH
PNM |  |  |  | Dollar Valued | [NAME] | payback being made
Amoco Abo |  |  |  | Dollar Valued | [NAME] | payback being made
[NAME] |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
PG&E TX |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Receivable imbalances
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Duke |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
[NAME] |  |  |  | Volumetric | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 48

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
48 | 2007-02-16 00:00:00 | 7.7 | 0.45 | 2.5 | 1.1 | 1.3 | 2.8 |  |  |  | 4.5 |  | 1.370320319406298 | 1.1 | 0.1 | 7 |  |  |  |  | 0.2
Well #48 | 2013-10-11 00:00:00 | 7.8 | 0.7 | 3.65 | 1.56 | 1.5 | 4 |  |  | 0.8 | 1.9 |  | 1 | 2.1 | 0.04 | 4.4 |  | <0.10 | <0.02 |  | 0.6
Well 48 | 2016-04-04 00:00:00 | 8.01 | 1.037 | 6.44 | 2.69 | 2.3 | 3.866597394293022 | 3.866597394293022 | 0 | 0.765 | 6.2305 | 665.6 | 1.08 | 2.37 | 0.028 | 4.79747 | 0.017 | 0 | 0 | 0
Well 48 | 2017-05-03 00:00:00 | 7.87 | 0.913 | 5.88 | 2.36 | 2.26 | 3.940532331548237 | 3.940532331548237 | 0 | 0.711 | 5.3825 | 584 | 1.11 | 2.43 | 0.062 | 4.7533 | 0 | 0.078 | 0 | 0.011
[NAME] | 2018-05-29 00:00:00 | 8.08 | 0.73 | 4.61 | 1.93 | 2.06 |  | 4.066421549036848 | 0 | 0.613 | 2.699 | 467.2 |  |  | 0.027 | 3.498 | 0.024 | 0 | 0 | 0.001
Spreadsheet: 194532d1353228642-sum-and-coutnifs-sum-and-countifs
Sheet: Sheet1

 |  |  | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-01 00:00:00
 |  |  | 346 | 342 | 392 | 385 | 0 | 34 | 35 | 123 | 343 | 4566 | 0 | 535 | 34 | 36
 |  |  | (a) SUM formula that will count only weekdays and exclude weekends
 |  |  | (b) COUNTIFS formula that will count only weekdays and exclude weekends, and exclude if the value is "0"
Spreadsheet: 376253d1423533425-find-value-that-doesnt-match-and-bring-back-column-heading-find-value-that-doesnt-match-and-index-column-heading-1-ndmv2
Sheet: Year 2

PersID | PosCode | Org1 | Org2 | Org3 | Non-Matching Value from Year 1 |  |  |  |  |  | PersID | PosCode | Org1 | Org2 | Org3
1001 | 21 | 8 | A1 | SS1
1002 | 21 | 9 | A2 | DW4
1003 | 22 | 11 | B3 | D34
1004 | 23 | 12 | B2 | AQ1
1005 | 23 | 22 | C1 | SS2
 |  | Excel Question:
 |  | For each row in year 2, How do I find the value that doesn’t match year 1 values and bring back the column heading?
 |  | Here the values that are different to year 1 are highlighted in red
 |  |  |  |  | =INDEX(H2:H100,MATCH(TRUE,H2:H100>0,0))
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 |  | -115
2 | -4125
3 |  | -4
4 | -24674
5 | -62427 | -29082
6 | -88065 | -70000
7 | -97069 | -108756
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -352223
2001-08-06 00:00:00
CBS Volume
 |  |  | -150667
Spreadsheet: 883336d1731954826-use-the-other-formula-instead-of-vlookup-formula-file-a-vehile-ecel-help-forum-5
Sheet: data

date | epi# | name | design | slip no. | date | date end | start time | end time | type | reg# | make | capacity | start reading | end reading | Total | PLACE | PURPOSE
2024-11-12 00:00:00 | 0001-01 | Mr.[NAME] | Director | x | 12.11.2024 |  | 11:05:00 |  | Van | ABC-1234 | [NAME] | 800cc | 6800 | 6810 |  | Godown | Site visit
2024-11-11 00:00:00 | 0001-10 | Mr.[NAME] | Manager | y | 11.11.2024 |  | 11:40:00 | 16:40:00 | Toyota [NAME] | LED-8556 | Toyota | 3000CC | 115056 | 115080 |  | Factory | Check the material
Spreadsheet: 600550d1543840340-help-i-want-vlookup-to-add-up-categorised-spending-by-date-sample
Sheet: Sheet1

 |  |  | Date | Change in balance
 |  |  | 2018-12-01 00:00:00 | 5,33+12,22+60
 |  |  | 2018-12-02 00:00:00 | 0 |  |  |  |  |  | Category A |  |  |  |  | Category B |  |  |  |  | Category C
 |  |  | 2018-12-03 00:00:00 | 4.2
 |  |  | 2018-12-04 00:00:00 | 0 |  |  |  |  |  | Date | Sum |  |  |  | Date | Sum |  |  |  | Date | Sum
 |  |  | 2018-12-05 00:00:00 | 0 |  |  |  |  |  | 2018-12-01 00:00:00 | 5.33 |  |  |  | 2018-12-01 00:00:00 | 12.22 |  |  |  | 2018-12-01 00:00:00 | 60
 |  |  | 2018-12-06 00:00:00 | 2,2+50 |  |  |  |  |  | 2018-12-03 00:00:00 | 4.2 |  |  |  | 2018-12-06 00:00:00 | 2.2 |  |  |  | 2018-12-06 00:00:00 | 50
 |  |  | 2018-12-07 00:00:00
 |  |  | 2018-12-08 00:00:00
 |  |  | 2018-12-09 00:00:00
 |  |  | 2018-12-10 00:00:00
 |  |  | 2018-12-11 00:00:00
 |  |  | 2018-12-12 00:00:00
 |  |  | 2018-12-13 00:00:00
 |  |  | 2018-12-14 00:00:00
 |  |  | 2018-12-15 00:00:00
 |  |  | 2018-12-16 00:00:00
 |  |  | 2018-12-17 00:00:00
 |  |  | 2018-12-18 00:00:00
 |  |  | 2018-12-19 00:00:00
 |  |  | 2018-12-20 00:00:00
 |  |  | 2018-12-21 00:00:00
 |  |  | 2018-12-22 00:00:00
 |  |  | 2018-12-23 00:00:00
 |  |  | 2018-12-24 00:00:00
 |  |  | 2018-12-25 00:00:00
 |  |  | 2018-12-26 00:00:00
 |  |  | 2018-12-27 00:00:00
 |  |  | 2018-12-28 00:00:00
 |  |  | 2018-12-29 00:00:00
 |  |  | 2018-12-30 00:00:00
 |  |  | 2018-12-31 00:00:00
Spreadsheet: 195259d1353461300-look-up-the-lowest-price-from-column-k-for-each-item-named-in-column-a-price-list
Sheet: GRATEFUL BREAD 

Desc | Pack | Size |  | Unit | Unit Counted | Unit Price | Case $ | Measurement | Total number of OZ per case | Price per. OZ/EA
BURGER (EGG) | 1 | 1 | EA | BG | EA |  | 0.45 | SCALE OZ
CIABATTA 4X4 | 1 | 1 | EA | BG | CS |  | 0.5 | SCALE OZ
CIABATTA LOAF LG | 1 | 1 | EA | BG | EA |  | 2.95 | SCALE OZ
CUBANS, HOGIES | 1 | 1 | EA | BG | EA |  | 0.4 | SCALE OZ
FOCACCIA, TOMATO ONION | 1 | 1 | EA | BG | EA |  | 18.5 | SCALE OZ
LAVASH, BLACK PEPPER | 1 | 1 | EA | BG | EA |  | 27.5 | SCALE OZ
WHOLE WHEAT BREAD | 1 | 1 | EA | BG | CS |  | 4.5 | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ
 |  |  |  |  | CS |  |  | SCALE OZ