tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 728416d1618436630-new-guy-with-formula-question-2-values-return-a-third-excel-formula-help
Sheet: DropDowns

Counts | UPSs | EBCs
0 | 120v | 120v
1 | GXT5-1000LVRT2UXL | GXT5-EBC36VRT2U
2 | GXT5-1500LVRT2UXL | GXT5-EBC48VRT2U
3 | GXT5-2000LVRT2UXL | GXT5-EBC48VRT2U
4 | GXT5-3000LVRT2UXL | GXT5-EBC72VRT2U
5
6 | 208v | 208v
7 | GXT5-5000MVRT4UXLN | GXT5-EBC144VRT2U
8 | GXT5-6000MVRT4UXLN | GXT5-EBC144VRT2U
9 | GXT5-8000MVRT6UXLN | GXT5-EBC288VRT4U
10 | GXT5-10KMVRT6UXLN | GXT5-EBC288VRT4U
11 | GXT5-15KMVRT11UXLN | GXT5-EBC288VRT4U (x2)
12 | GXT5-20KMVRT11UXLN | GXT5-EBC288VRT4U (x2)
13
14
15
16
17
18
19
20
Spreadsheet: 101075d1299236594-match-prices-within-a-range-moreorlessvlookup
Sheet: Ark1

 |  | c3 (price) |  |  |  |  | c8 (price)
1 | 710101 | 224067.87 | OK | 224067.47 | 1 | 710101 | 224067.47 |  |  | 0
1 | 710104 | -28294.54 | DIFF | 0 | 1 | 710301 | -5683634.98
1 | 710301 | -5683634.98 | OK | -5683634.98 | 1 | 710303 | -0.01
1 | 710303 | 0.01 | OK | -0.01 | 1 | 710304 | 670429774.61
1 | 710304 | 670429774.61 | OK | 670429774.61 | 1 | 710305 | -33022238.49
1 | 710305 | -33022238.59 | OK | -33022238.49 | 2 | 710101 | -16119169.5
1 | 710306 | 12438221.02 | DIFF | 0 | 2 | 710301 | 12545889.64
2 | 710101 | -16119169.5 | OK | -16119169.5 | 2 | 710303 | 2
2 | 710104 | -95321371.04 | DIFF | 0 | 2 | 710304 | 261760.37
2 | 710301 | 12545889.64 | OK | 12545889.64 | 3 | 710305 | 141380799.99
2 | 710303 | 2 | OK | 2 | 3 | 710306 | -8841017.03
2 | 710304 | 261760.37 | OK | 261760.37 | 3 | 710307 | -9702907.81
3 | 710305 | 141380799.99 | OK | 141380799.99 | 6 | 710308 | 1.08
3 | 710306 | -8841017.03 | OK | -8841017.03 | 6 | 710309 | 57139182.9
3 | 710307 | -9702907.81 | OK | -9702907.81 | 6 | 710310 | -3349319.96
6 | 710308 | 1.08 | OK | 1.08 | 6 | 710311 | 16605949.12
6 | 710309 | 57139182.9 | OK | 57139182.9 | 10 | 710101 | 34175021.25
6 | 710310 | -3349319.96 | OK | -3349319.96 | 13 | 710101 | -12438221.3
6 | 710311 | 16605949.12 | OK | 16605949.12 | 13 | 710340 | 9022307.48
10 | 710101 | 34175021.25 | OK | 34175021.25
13 | 710101 | -12438221.3 | OK | -12438221.3
13 | 710340 | 9022307.48 | OK | 9022307.48
 |  | I need a function which enables me to check if two sets of data is identical. Look at my attached example.
 |  | funcA should match the price in column C with the price in column H if the number from column A are identical with the number from column F.
 |  | It should evaluate the price within a range of +/-1.00 (fx: the function will positively match the prices in row 2, because the difference between 224,067.87 and 224,067.47 are less than +/-1.00).
 |  | If the function are able to find a positive match, it should return "OK"
 |  | If the function are NOT able to find a positive match, it should return "DIFF"
 |  | Likewise, [NAME] should match the price in column H with the price in column C if the number from column F are identical with the number from column A.
 |  | It should consider the same criteria as funcA.
 |  | I sincerely appreciate your time. I know this is a challenging task!
 |  | In advance, thank you!
 |  | BR
 |  | Tobias
Spreadsheet: 158611d1338318476-use-a-list-as-a-filter-sample
Sheet: lists

Code
193200000X
193400000X
101Y00000X
101YA0400X
101YM0800X
101YP1600X
101YP2500X
101YS0200X
102L00000X
103G00000X
103GC0700X
103K00000X
103T00000X
103TA0400X
103TA0700X
103TB0200X
103TC0700X
103TC1900X
103TC2200X
103TE1000X
103TE1100X
103TF0000X
103TF0200X
103TH0004X
103TH0100X
103TM1700X
103TM1800X
103TP0016X
103TP0814X
103TP2700X
103TP2701X
103TR0400X
103TS0200X
103TW0100X
104100000X
1041C0700X
1041S0200X
106H00000X
171M00000X
207P00000X
207PE0004X
207PH0002X
207PP0204X
207Q00000X
207QA0000X
207QA0401X
207QA0505X
207QB0002X
207QG0300X
207QH0002X
207R00000X
207RA0000X
207RA0401X
207RB0002X
207RC0000X
207RC0200X
207RG0300X
207RH0000X
207RH0002X
207RH0003X
207RH0005X
207RI0011X
207RI0200X
207RP1001X
207RR0500X
207RX0202X
207T00000X
207Y00000X
207YP0228X
207YX0901X
207YX0905X
208000000X
2080A0000X
2080C0008X
2080H0002X
2080I0007X
2080N0001X
2080P0006X
2080P0008X
2080P0201X
2080P0202X
2080P0203X
2080P0204X
2080P0205X
2080P0206X
2080P0207X
2080P0208X
2080P0210X
2080P0214X
2080P0216X
2080S0010X
2080S0012X
2080T0002X
2080T0004X
208100000X
2081H0002X
2081N0008X
2081P0004X
2081P0010X
2081P2900X
2081S0010X
2084A0401X
2084B0002X
2084B0040X
2084D0003X
2084F0202X
2084H0002X
2084N0008X
2084N0400X
2084N0402X
2084N0600X
2084P0005X
2084P0015X
2084P0800X
2084P0802X
2084P0804X
2084P0805X
2084P2900X
2084S0010X
2084S0012X
2084V0102X
208600000X
2086H0002X
2086S0102X
2086S0105X
2086S0120X
2086S0122X
2086S0127X
2086S0129X
2086X0206X
208D00000X
208G00000X
208M00000X
225100000X
2251C2600X
2251E1200X
2251E1300X
2251G0304X
2251H1200X
2251H1300X
2251N0400X
2251P0200X
2251S0007X
2251X0800X
225400000X
225C00000X
225X00000X
225XF0002X
225XG0600X
225XM0800X
225XN1300X
225XP0019X
225XP0200X
231H00000X
235500000X
235Z00000X
237600000X
237700000X
251B00000X
251C00000X
251E00000X
251G00000X
251J00000X
251K00000X
251S00000X
251T00000X
252Y00000X
253Z00000X
261Q00000X
261QA0600X
261QA0900X
261QA3000X
261QC0050X
261QC1500X
261QD1600X
261QE0002X
261QE0700X
261QH0700X
261QM0801X
261QM0850X
261QM0855X
261QM1100X
261QM1101X
261QM1102X
261QM1103X
261QM1300X
261QM2800X
261QM3000X
261QP0904X
261QP0905X
261QP2000X
261QP2300X
261QP2400X
261QR0400X
261QR0401X
261QR0404X
261QR0405X
261QR0800X
261QS1000X
261QU0200X
261QV0200X
261QX0100X
261QX0200X
261QX0203X
273100000X
273R00000X
273Y00000X
275N00000X
276400000X
281P00000X
281PC2000X
282E00000X
282J00000X
282N00000X
282NC0060X
282NC2000X
282NR1301X
282NW0100X
283Q00000X
283X00000X
283XC2000X
284300000X
286500000X
2865C1500X
2865M2000X
2865X1600X
287300000X
302F00000X
302R00000X
305R00000X
305S00000X
310400000X
3104A0625X
3104A0630X
310500000X
311Z00000X
311ZA0620X
313M00000X
314000000X
3140N1450X
315D00000X
315P00000X
320600000X
320700000X
320800000X
320900000X
322D00000X
323P00000X
324500000X
3245S0500X
376G00000X
385H00000X
385HR2050X
385HR2055X
385HR2060X
385HR2065X
Spreadsheet: 117979d1313324863-question-on-conditional-formula-location
Sheet: Sheet1

 |  | loc a | loc b | loc c | loc d | loc e | some location somewhere | [NAME] | loc h | loc 1 | loc j
 | 1 | yes | no | maybe | yes | no | yes | yes | no | maybe | yes | [NAME] a,loc d,some location somewhere,[NAME],loc j
 | 2 | maybe | yes | maybe | no | no | yes | maybe | yes | maybe | no | loc b,some location somewhere,loc h
 | 3 | no | maybe | yes | yes | maybe | no | no | maybe | yes | yes | loc c,loc d,loc 1,loc j
 | 4 | no | maybe | maybe | no | maybe | yes | no | maybe | maybe | no | some location somewhere
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-15

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-15 00:00:00
 |  |  | Monitoring Well #: | MW-15 |  |  |  | Well Depth: | 8.72 |  | ft |  |  | Screened/Open Interval: | 2-9' |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 5.5 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 3.47 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 11:15 | x |  | 6.47 | NA | 19.11 | NA | 1494 | NA | 1.23 | NA | -69.4 | NA | 35.1 | NA | 220 | 3.73
 | 11:20 | x |  | 6.48 |  | 19.26 |  | 1481 |  | 0.92 |  | -65 |  | 26.8 |  | 220 | 3.82
 | 11:25 | x |  | 6.49 |  | 19.64 |  | 1454 |  | 0.46 |  | -63.5 |  | 5.59 |  | 220 | 3.91
 | 11:30 | x |  | 6.49 |  | 19.65 |  | 1455 |  | 0.44 |  | -62.3 |  | 3.37 |  | 220 | 3.97
 | 11:35 | x |  | 6.49 |  | 19.66 |  | 1456 |  | 0.44 |  | -61.7 |  | 3.24 |  | 220 | 3.99
 | 11:40 | x |  | 6.49 |  | 19.65 |  | 1458 |  | 0.43 |  | -63.6 |  | 3.19 |  | 220 | 4.03
 | 11:45 |  | x | 6.49 | 0 | 19.65 | 0 | 1465 | 7 | 0.41 | -0.02 | -60.8 | -2.8 | 2.87 | -0.32 | 220 | 4.13
 | Comments:
 |  | Purge start: |  |  | 11:10:00 |  |  | Sample time: |  | 11:42:00
 |  | Purge end: |  |  | 11:40:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 684144d1593172031-how-to-display-negative-time-in-days-hh-mm-format-leave_card_example
Sheet: Leave

 |  |  | Leave Request & Log |  |  |  |  | Leave year:
 |  |  | Before first use, select and enter your details, leave entitlement and the length of your work day on the Configuration page. Hover over blue shaded boxes for more information about the box and it's contents.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
 |  |  | Name |  |  |  |  |  |  | Leave entitlement
 |  |  | Section |  |  |  |  |  |  | Leave start date
 |  |  | Team |  |  |  |  |  |  | Leave end date
 |  |  | Service |  |  |  |  |  |  | Standard day (hrs:mins)
 |  |  | Directorate
 |  |  |  |  |  | Hours | Days
 |  |  | Carried forward from previous year
 |  |  | Balance from previous sheet |  |  |  |  |  |  |  |  |  |  | Hours | Days
 |  |  |  |  |  |  |  |  |  | Current leave remaining
 |  |  | Leave entitlement
 |  |  | Starting balance
 |  |  | First date booked | Last date booked | Number of days booked | Additional/ other hours | Total time booked | Type of leave |  | Annual leave remaining |  |  | Approved by manager |  | Checked by Support Services
 |  |  |  |  |  |  |  |  |  | Hours | Days |  | Initials | Date | Date
 |  |  | Annual leave taken |  |  |  | Annual leave remaining:
 |  |  | Flexi leave taken
 |  | [NAME]  v1.2  05/20
Spreadsheet: 739283d1625613185-assign-unique-project-code-project-id-assigner
Sheet: Sheet1

Customer | Assigned ID | Required ID
ConstructionTech |  | const
Buildalot |  | build
Core |  | core0
Salamanda |  | salam
ABC |  | abc00
Core |  | core1
abcd |  | abcd0
salamanda India |  | [NAME]
Construction Limited |  | cons0
Spreadsheet: 840099d1692427355-copy-all-data-to-a-summary-sheet-on-a-per-date-basis-copy-of-new-microsoft-excel-worksheet
Sheet: DAILY OUTPUT MONITORING

 |  |  | DATE: 17th AUGUST 2023
[NAME] | CARTON WEIGHT (KG) | TOTAL CTNS | TOTAL WEIGHT
[NAME] 3 X 5KG | 15
[NAME] 20 X 500G | 10
[NAME] 15 X 700G | 10.5
[NAME] BULK 20KG | 20
SAVELOY SAUSAGE 4 X 5KG | 20
SAVELOY SAUSAGE 20X 500G | 10
SAVELOY SAUSAGE 15 X 700G | 10.5
SAVELOY SAUSAGE BULK 20KG | 20
 |  | TOTAL OUTPUT = |  | KGs
[NAME] | CARTON WEIGHT (KG) | TOTAL CTNS | TOTAL WEIGHT
LAMB FLAP 20 X 500G | 10
LAMB FLAP 15 X 700G | 10.5
LAMB FORES 4 X 5KG | 20
SAW DUST
 |  | TOTAL OUTPUT = |  | KGs
REMARK: WATER PRESSURE SOWN
Spreadsheet: 72411d1273088602-formula-for-multiple-if-statements-and-lookup-functions-sample
Sheet: Purchase Output

GFE Box 4 - Title Services & Lender’s Title Insurance
 | Title Services: |  |  |  |  |  |  | <<< Price determined by purchase or refinance selection
 | Lender's Title Insurance: |  |  |  |  |  |  | <<< Price determined by purchase or refinance selection. Calculation needed if refinance selected.
 | Total for GFE Box 4:
GFE Box 5 – Owner’s Title Insurance
 | Owner's Title Insurance:
 | Total for GFE Box 5:
GFE Box 7 – Government Recording Charges
 | Deed: |  |  |  |  |  |  | <<< always charged
 | Deed of Trust: |  |  |  |  |  |  | <<< only should show and apply if they selected 'Yes' to Loan question
 | Power of Attorney: |  |  |  |  |  |  | <<< only should show and apply if they selected 'Yes' to Power of Attorney question
 | Total for GFE Box 7:
GFE Box 8 – Transfer & Recordation Taxes
 | Total for GFE Box 8:
 | Breakdown of Taxes
 |  |  | Buyer | [NAME] | Total
 | County Transfer Tax:
 | State Transfer Tax:
 | State Recordation Tax:
 | Total Taxes:
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 48553 | 48599 | 29955 | 31842
2 | 44345 | 43773 | 29721 | 32000
3 | 44746 | 43773 | 29848 | 32000
4 | 48479 | 46658 | 29716 | 28940
5 | 48094 | 46773 | 29861 | 29000
6 | 49751 | 46764 | 31678 | 28994
7 | 48463 | 46655 | 31065 | 28927
8 | 48116 | 46773 | 31104 | 29000
9 | 46559 | 46773 | 29773 | 29000
10 | 46494 | 46773 | 30204 | 29000
11 | 48443 | 46773 | 29276 | 29000
12 | 44817 | 46773 | 28248 | 29000
13 | 45318 | 46682 | 28386 | 28943
14 | 46538 | 46773 | 28082 | 29000
15 | 46426 | 55757 | 28025 | 33498
16 | 40341 | 46773 | 31976 | 29000
17 | 37121 | 35773 | 34451 | 40000
18 | 38013 | 35773 | 35719 | 40000
19 | 40596 | 41381 | 32643 | 36341
20 | 39379 | 41794 | 31976 | 34012
21 | 41476 | 41654 | 28663 | 26883
22 | 45837 | 45000 | 29873 | 35665
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  | 2417637.89 |  | -1908689.58
2001-07-22 00:00:00
Spreadsheet: chris_stokley__3915__0301 EES
Sheet: PGES

PGES ISO Settlement 03/01/2001 - 03/31/2001
 |  | EPMI Charges To Customers
Trans Type | (All)
 |  |  | Data
Customer | ID | Desc. | Expense | Revenue | Total | Volume
PGES | 111 | Spinning Reserve due ISO | -139537.3920604801 | 342301.1487831975 | 202763.7567227174 | -3023.093970489992
 | 112 | Non -Spinning Reserve due [NAME] | -208342.6605248341 | 404259.33997177 | 195916.6794469358 | -3453.77530491145
 | 114 | Replacement Reserves Due ISO | -2750818.087114156 | 3233920.686783384 | 483102.5996692339 | -2306.012080911333
 | 115 | Regulation UP due ISO | -275791.2877542349 | 434371.1591044647 | 158579.8713502293 | -1663.141613020395
 | 116 | Regulation Down Due ISO | -99511.50728859717 | 163032.2585063859 | 63520.75121778854 | -1493.962044027663
 | 204 | Congestion DA Refund | 0 | 0.0005 | 0.0005 | 0
 | 403 | Load Deviation | -35122583.82793307 | 35575847.87133269 | 453264.043399614 | -1862.364507952181
 | 406 | UFE | -941372.8677149586 | 947921.88472817 | 6549.017013212781 | 14646.96736196355
 | 487 | Allocation Excess Cost for IE | -42845415.93 | 45845033.78 | 2999617.850000008 | -10722.65956965093
 | 521 | Control Area Services Charge | -44629.874 | 65940.22514 | 21310.35114000001 | -52488.52869377191
 | 522 | Inter-Zonal Scheduling Charge | 0 | 11016.69506 | 11016.69506 | -49402.22
 | 523 | Market Operations Charge | -133802.8151 | 161825.0838803293 | 28022.26878032926 | -29466.10851289258
 | 1010 | Neutrality Adj | -136623.9641635833 | 240823.21395015 | 104199.2497865667 | -117158.8708000001
 | 1011 | AS Rational Buyer Adj. | -691966.7221 | 498103.496 | -193863.2261000002 | -674373.0108999998
 | 1030 | No Pay Market Refund | -34941.54530000001 | 9365.680900000003 | -25575.86440000001 | -249405.6158
 | 1210 | Existing Contract Neu Adj | -106328.6136 | 45514.2288 | -60814.38480000004 | -2027454.7158
 | 1302 | Supplemental Reactive Energy | -0.0854 | 104.577 | 104.4916 | -34084.5366
Grand Total |  |  | -83531667.18005392 | 87979381.33044057 | 4447714.150386635 | -3243711.648835666
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 1

TABLE 1
USE A SEPARATE SHEET FOR METRO & COUNTY
[NAME]
Population | 1990 | Present Year | Five Year Projection
 |  |  | 1 | 2 | 3 | 4 | 5
Population by Age Group
Under - 17
18 - 34
35 - 54
55 - 74
75 - Older
% Distribution by Age Group
Under - 17
18 - 34
35 - 54
55 - 74
75 - Older
Median Age
Households
Number
Median Household Income
Household Income Distribution
Under - $35,000
$35,001 - $50,000
$50,001 - $75,000
$75,001 - Above
 |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Net Migration Last Five Years Available
Workforce Education Attainment (25 - 64 Years of Age) | Percentage %
Under - 12 Years
12 Years Only
12 - 15 Years
Some College
Associate Degrees
Subtotal
College Graduates
16 Years - More
16 Years Only
Total
Spreadsheet: 57256d1257372720-excel-2007-comparing-cells-to-find-best-results-tech-monthly-report-oct-beta
Sheet: Week 5

 |  |  |  | WEEK 5
 | Technician |  |  |  | Work Comp % | QC Pass % | CDV/HSI Jobs | Activation Attemtps | [NAME] | VOD Attempts
 | 1 |  |  |  |  |  | 7 | 5
 | 2 | [NAME] |  |  |  |  | 0 | 0
 | 3 | [NAME] |  |  |  |  | 4 | 3
 | 4 | [NAME] |  |  |  |  | 1 | 0
 | 5 | [NAME] |  |  |  |  | 5 | 2
 | 6 | [NAME] |  |  |  |  | 9 | 6
 | 7 | [NAME] |  |  |  |  | 8 | 5
 | 8 | [NAME] |  |  |  |  | 8 | 3
 | 9 | [NAME] |  |  |  |  | 9 | 9
 | 10 | [NAME] |  |  |  |  | 6 | 3
 | 11 | [NAME] |  |  |  |  | 2 | 2
 | 12 | [NAME] |  |  |  |  | 8 | 6
 | 13 | [NAME] |  |  |  |  | 0 | 0
 | 14 | [NAME] |  |  |  |  | 4 | 3
 | 15 | [NAME] |  |  |  |  | 0 | 0
 | 16 | [NAME] |  |  |  |  | 0 | 0
 | 17 | [NAME] |  |  |  |  | 2 | 0
 | 18 | 0
 | 19 | 0
 | 20 | 0
 | 21 | 0
 | 22 | 0
 | 23 | 0
 | 24 | 0
 | 25 | 0
Spreadsheet: 882806d1731279690-distribute-students-evenly-and-only-once-in-repeating-sessions-according-to-wishes-wishes-reading-day-norwegianteacher-
Sheet: Round 1

08.45 - 09.20
name | grade | which wish |  | ID | name | grade | which wish
[NAME]
Hans
ole
[NAME]
Stacy
Spreadsheet: 104217d1301870121-excel-2008-solved-sum-of-values-in-a-column-based-on-values-in-a-different-column-countif-unique
Sheet: Sheet1

[NAME] | 2800 | 700 | 34 | 37 | Hookah |  | Hookah | Open Circ | Surf Supply | Rebreather
Brett | 3000 | 700 | 35 | 35 | Open Circ |  | 1 | 3 | 2 | 2
[NAME] | 3200 | 650 | 37 | 36 | Open Circ
Suzie | 2900 | 650 | 41 | 31 | Rebreather
[NAME] | 3000 | 700 | 42 | 40 | Surf Supply
[NAME] | 3000 | 800 | 45 | 31 | Rebreather
[NAME] | 2900 | 550 | 47 | 33 | Surf Supply
[NAME] | 2000 | 800 | 48 | 13 | Open Circ
[NAME] | 3000 | 800 | 48 | 31 | Open Circ |  | OR LIKE THIS
Nathan | 3100 | 600 | 48 | 34 | Open Circ |  | 3
Spreadsheet: 57469d1257637802-pivot-table-trouble2
Sheet: Sheet1

Fault Desc | Total Causes
[6659] MCP 18A E-Stop Pushed | 2
[6660] Panel 18A1 E-Stop Pushed | 2
[6661] MCP 1A E-Stop Pushed | 1
[6662] MCP 1B E-Stop Pushed | 7
[6665] MCP 18A Stop | 45
[6666] Panel 18A1 Stop | 4
[6667] MCP 1A Stop | 15
[6668] MCP 1B Stop | 55
[6669] MCP 1C Stop | 65
[6670] MCP 18A Disconnect Open | 5
[6693] Motor 18A4 Not Running | 3
[6698] CDLR After Reintroduction Not Running B18 | 1
[6734] Turn Table 1 Not In Position Fault | 24
[6735] Turn Table 1 Run Too Long | 2
[6736] Turn Table 2 Not In Position Fault | 3
[6739] Door 9 Lane 1 Transfer Not Down | 1
[6746] Jam at MCC Guard Conveyor 18A04 | 7
[6748] B18 Auto Swing Gate Not Ok to Close | 4
[6755] Motor 18A2 Jammed | 26
[6757] Motor 18A3 Jammed | 3
[6758] Motor 18A4 Jammed | 5
[6759] Motor 18A5 Jammed | 11
In this example, I need my formula to report the sum of the total number of causes
that have the text "18A" in the fault descrition.
Spreadsheet: 109782d1306535485-excel-2007-vlookup-multiple-values-vlookup-multiple
Sheet: Sheet2

[NAME] | LAGCO INC.
Total Count
 |  |  | 2nd Option
Row # | Project |  | Project
Spreadsheet: 0950cdef-781c-46e8-ad9c-d2cc5f56fa35
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 27. LEASE FINANCE COMMITMENTS, Summary:Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total lease finance commitments ; |  |  | Original | A2414208C | 1975-10-01 00:00:00 | 2010-10-01 00:00:00 | 421 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Seasonally Adjusted | A2414207A | 1975-10-01 00:00:00 | 2010-10-01 00:00:00 | 421 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Trend | A2414206X | 1975-10-01 00:00:00 | 2010-10-01 00:00:00 | 421 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 773757d1648036754-duplicate-and-look-up-workbook
Sheet: Pivot Table

Site | Project
Multi Sites | Project 10
 | Project 6
Site A | Project 1
 | Project 5
 | Project 6
 | Project 9
Site C | Project 10
 | Project 3
 | Project 4
 | Project 6
 | Project 7
Site D | Project 10
 | Project 6
 | Project 8
Grand Total
Spreadsheet: 725010d1616499871-daily-sales-spreadsheet-month-target-2021-22
Sheet: 2021 QTR4

Monthly Target | 2022-01-01 00:00:00 |  |  |  |  |  | HIDE ME |  | 2022-02-01 00:00:00 |  |  |  |  |  |  | 2022-03-01 00:00:00
31150 |  |  |  |  |  |  | Holidays
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | 2022-01-01 00:00:00 | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  | 2491 |  |  |  |  |  |  |  | 2491 |  |  |  |  |  |  | 2491
 |  |  | 2553 |  |  |  |  |  |  |  | 2553 |  |  |  |  |  |  | 2553
TOTAL |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Spreadsheet: 881147d1729078585-distribution-of-items-based-on-actual-value-should-be-exact-excel-forum-actual-total-number-remains-
Sheet: Sheet1

 |  |  |  |  |  | Time (Hours) | Total Number of Items
 |  |  |  |  |  |  | Actual | Adjusted
 |  |  |  |  |  | 7 |  |  | <---- | we can retain the numbers here
 |  |  |  |  |  | 1 |  |  |  | or round down or round up..
 |  |  |  |  |  | 5 |  |  |  | so that the total in green is always equal to user entry value
 |  |  |  |  |  | 6 |  |  |  | in this example is user entry is 20
 |  |  |  |  |  | 4
 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 20 |  |  | <--- this should also be 20
 |  |  |  |  |  |  | this will change based on user entry value | should be always equal to the total ACTUAL
 |  |  |  |  |  |  |  | meaning this should also be 20 based on the ACTUAL
Spreadsheet: 680466d1591035928-sumifs-calculation-for-cumulative-annual-wages-sample-file-1
Sheet: Taxes

 | Year | Month | Monthly After Deductions | Cum Annual After Deductions | Annual Rate | Monthly Rate | Tax | NI | SLC | Pension | Total Deductions
 | 2019 | 11 |  |  | 20000
 | 2019 | 12 |  |  | 22000
 | 2020 | 1 |  |  | 22000
 | 2020 | 2 |  |  | 24000
 | 2020 | 3 |  |  | 24000
 | 2020 | 4 |  |  | 26000
 | 2020 | 5 |  |  | 28000
Spreadsheet: 48687d1247925936-selecting-values-based-on-conditions-value-test
Sheet: Sheet1

Raw Sugar | Quantity (MT) | U. Price (SR) | Total Price (SR) | 2009-05-01 00:00:00 |  |  |  | 2009-05-01 00:00:00
 |  |  |  |  |  |  |  | 2009-06-01 00:00:00
 |  |  |  |  |  |  |  | 2009-07-01 00:00:00
Opening Stock | 93768 | 1433.47
Purchasing and Transfers
Total Receiving
Adjustments and Others
Total Adj.
Total Available
Issue
To WIP
Total Issue
Closing Stock
Spreadsheet: 80971d1281227155-comparing-data-in-two-columns-countif_multiplecriteria-
Sheet: Sheet1

 |  | Place1 | Place2 | Place3 | Place4 | [NAME] | Place6 | Place7 | Place8 | Place9 | Place10
Place1 | 0 | 0 | 2 | 2 | 1 | 1 | 2 | 3 | 3 | 1 | 0
Place2 | 1
Place3 | 1
Place4 | 1
[NAME] | 0
Place6 | 0
Place7 | 0
Place8 | 0
Place9 | 0
Place10 | 0
Place1 | 0
Place2 | 0
Place3 | 0
Place4 | 0
[NAME] | 1
Place6 | 1
Place7 | 1
Place8 | 1
Place9 | 1
Place10 | 0
Place1 | 0
Place2 | 1
Place3 | 0
Place4 | 0
[NAME] | 0
Place6 | 1
Place7 | 1
Place8 | 1
Place9 | 0
Place10 | 0
Place1 | 0
Place2 | 0
Place3 | 1
Place4 | 0
[NAME] | 0
Place6 | 0
Place7 | 1
Place8 | 1
Place9 | 0
Place10 | 0
Spreadsheet: 9db975bd-26a0-4207-8caa-c9c53135e413
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
42255923 | 2014-07-11 16:33:27 | ALLIES | 1 | 6 | 2 | 24393 | GDA13 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
42256065 | 2014-07-11 16:45:45 | AXIS | 0 | 1 | 6 | 24393 | GDA13 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
42272003 | 2014-07-12 19:27:23 | AXIS | 0 | 5 | 6 | 377160 | docsteve | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42272552 | 2014-07-12 20:02:26 | ALLIES | 0 | 5 | 6 | 377160 | docsteve | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42273027 | 2014-07-12 20:20:39 | AXIS | 1 | 6 | 3 | 1600049 | player1600049 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith