tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 80447d1280670126-automatic-updating-sample-workbook-complete-
Sheet: OIF

Authorized Position | First Name | Last Name | Last 4 SSN | Status | Provider | Date Attended MRAP-U (FSR/RR/Instructors Only) | CRC Completion Date | Arrival in Country Date | Country | Location | R&R Start | R&R End | Date of Physical | Remarks | Tour End Date | Renew/Extend Y/N | 90-Day Loss
IT Coordinator | [NAME] | Addai | 3387 | Duty | JLI | N/A | 13-May-05 | 2007-05-15 00:00:00 | Iraq | PM FWD HQ | 2010-08-06 00:00:00 | 2010-08-22 00:00:00 | N/A |  | 2011-09-20 00:00:00
SPAWAR C4I FSR | Antoine | [NAME] |  | Duty | EMA |  |  | 2005-05-16 00:00:00 | Iraq | Balad |  |  |  |  | 2011-09-20 00:00:00
Sustainment Mechanic | [NAME] | Brackett |  | Duty | RRAD |  |  | 2004-05-17 00:00:00 | Iraq | Balad |  |  |  |  | 2011-09-20 00:00:00
Material Handler | Dallas | [NAME] |  | Duty | JLI | N/A |  | 2004-05-18 00:00:00 | Iraq | PM FWD HQ |  |  |  |  | 2011-09-20 00:00:00
Material Handler | [NAME] | Collie | 7679 | Duty | JLI | N/A | 27-Oct-07 | 2004-05-19 00:00:00 | Iraq | Liberty |  |  | 2007-10-01 00:00:00 |  | 2011-09-20 00:00:00 | YES
Regional [NAME] | Dwight | Freeney |  | TDY | [NAME] |  |  | 2004-05-20 00:00:00 | Iraq | Mosul |  |  |  | Shocker | 2011-09-20 00:00:00
Material Handler | [NAME] | Garcon |  | TDY | JLI |  |  | 2004-05-21 00:00:00 | Iraq | PM FWD HQ |  |  |  | Speicher | 2011-09-20 00:00:00
Material Handler | [NAME] | [NAME] |  | Duty | JLI |  |  | 2004-05-22 00:00:00 | Iraq | Al Asad |  |  |  |  | 2011-09-20 00:00:00
SPAWAR C4I FSR | [NAME] | Hayden | 2676 | Duty | EMA | N/A | N/A | 2004-05-23 00:00:00 | Iraq | Al Asad |  |  | N/A |  | 2011-09-20 00:00:00 | NO
FSR | [NAME] | [NAME] |  | Duty | BAE |  |  | 2004-05-24 00:00:00 | Iraq | Tallil |  |  |  |  | 2011-09-20 00:00:00
Supply Tech | [NAME] | [NAME] | 6124 | TDY | JLI | N/A | N/A | 2004-05-25 00:00:00 | Iraq | Balad |  |  | N/A | Liberty | 2011-09-20 00:00:00 | Yes
SPAWAR C4I FSR | [NAME] | [NAME] |  | Duty | EMA |  |  | 2004-05-26 00:00:00 | Iraq | Tallil |  |  |  |  | 2011-09-20 00:00:00
Deputy Program Manager | Peyton | Manning |  | Duty | JLI |  |  | 2004-05-27 00:00:00 | Iraq | PM FWD HQ |  |  |  |  | 2011-09-20 00:00:00
Regional [NAME] | [NAME] | Mathis |  | Duty | [NAME] |  |  | 2004-05-28 00:00:00 | Iraq | Q-West |  |  |  |  | 2011-09-20 00:00:00
FSR | [NAME] | Muir |  | Duty | BAE |  |  | 2004-05-29 00:00:00 | Iraq | Liberty |  |  |  |  | 2011-09-20 00:00:00 | No
SPAWAR C4I FSR | Jerraud | Powers |  | Duty | EMA |  |  | 2004-05-30 00:00:00 | Iraq | Liberty |  |  |  |  | 2011-09-20 00:00:00 | No
SPAWAR C4I FSR | [NAME] | Sanders |  | R&R | EMA |  |  | 2004-05-31 00:00:00 | Iraq | Speicher | 2010-07-25 00:00:00 | 2010-08-10 00:00:00 |  |  | 2011-09-20 00:00:00
LOG Assistant [NAME] | [NAME] | Saturday |  | Duty | JLI |  |  | 2004-06-01 00:00:00 | Iraq | Tallil |  |  |  |  | 2011-09-20 00:00:00
Sustainment Mechanic | Clint | Session |  | Duty | RRAD |  |  | 2004-06-02 00:00:00 | Iraq | Speicher |  |  |  |  | 2011-09-20 00:00:00
Material Handler | [NAME] | Wayne |  | Duty | JLI |  |  | 2004-06-03 00:00:00 | Iraq | PM FWD HQ |  |  |  |  | 2011-09-20 00:00:00
Spreadsheet: 721990d1614978064-xlookup-to-replace-vlookup-in-complex-problem-xlookup-problem
Sheet: MultiCondition

 |  |  |  | Start Year | Grade | Role | Savings Produced
 |  |  |  | 2013 | A | Analyst | 174291
First Name | Surname | Uniqe Reference |  | 2014 | D | Vice President | 224534
[NAME] | [NAME] | 11547 |  | 2013 | C | Vice President | 204394
Smith | [NAME] | 34343 |  | 2013 | B | Associate Vice President | 278178
[NAME] | [NAME] | 75365 |  | 2013 | D | Director | 370746
[NAME] | [NAME] | 93564 |  | 2014 | A | Analyst | 163583
 |  |  |  | 2014 | B | Associate Vice President | 270746
Lookup the person in the criteria in the table above |  |  |  | 2013 | A | Analyst | 122575
 |  |  |  | 2014 | D | Director | 221802
Criteria
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
Look up the Savings Produced for a Director of Grade D who started in 2014.
Criteria
2014
D
Director
Spreadsheet: 196250d1353933455-2-questions-how-to-remove-exponents-how-to-remove-trailing-0s-thanks-binary-conversion-in-progress
Sheet: formula's

Original value of f = | 0.26 | 1
Position (from left to right) | Fraction | Fraction as a decimal | Is f larger or smaller than the fraction | Value of f |  |  | Work done | New Value of f | Bit value
#1 | 1/2 | 0.5 |  | 0.26
#2 | 1/4 | 0.25
#3 | 1/8 | 0.125
#4 | 1/16 | 0.0625
#5 | 1/32 | 0.03125
#6 | 1/64 | 0.015625
#7 | 1/128 | 0.0078125
#8 | 1/256 | 0.00390625
#9 | 1/512 | 0.001953125
#10 | 1/1024 | 0.0009765625
#11 | 1/2048 | 0.00048828125
#12 | 1/4096 | 0.000244140625
#13 | 1/8192 | 0.000112208258527828
#14 | 1/16384 | 6.103515625e-05
#15 | 1/32768 | 3.0517578125e-05
#16 | 1/65536 | 1.52587890625e-05
#17 | 1/131072 | 7.62939453125e-06
#18 | 1/262144 | 3.814697265625e-06
#19 | 1/524288 | 1.9073486328125e-06
#20 | 1/1048576 | 9.5367431640625e-07
#21 | 1/2097152 | 4.76837158203125e-07
#22 | 1/4194304 | 2.38418579101562e-07
#23 | 1/8388608 | 1.19209289550781e-07
Spreadsheet: 805759d1668894966-search-tab-for-specific-text-then-offset-from-the-cell-containing-that-text-example
Sheet: Fund 2

 |  |  |  |  |  | Transaction Links | Dates | 2022-12-31 00:00:00
 |  |  |  |  |  |  | Data Item #1 | 0 | 15.79406798303513 | 0 | 12.02696160904184 | 0 | 9.0708878866431 | 0 | 6.863773803763817
 |  |  |  |  |  |  | Data Item #2 | 44.8603510012435 | 0 | 347.6235113173682 | 0 | 405.3267549995409 | 0 | 535.3426486190533 | 0
 |  |  |  |  |  |  | Data Item #3 | 16.9717985794918 | -0.2724007463668224 | 115.2618323596076 | -0.1379489060178438 | 147.6010541127549 | -4.408003067933979 | 193.8373405654178 | -0.8706283115778692
 |  |  |  |  |  |  | Data Item #4 | 1.985216101994193 | -0.1411398990551287 | 13.69893118115853 | -0.1074760567868513 | 17.93702417914293 | -0.71903854666564 | 23.56305362191007 | -0.1889322144595941
 |  |  |  |  |  |  |  | 2
Spreadsheet: 703880d1605205470-how-to-reference-a-certain-sheet-in-an-dynamic-averageifs-function-sampleworkbook
Sheet: 2

Depth (ft) | Column A | Column B | Column C
0 | 76 | 101 | 126
5 | 77 | 102 | 127
10 | 78 | 103 | 128
15 | 79 | 104 | 129
20 | 80 | 105 | 130
25 | 81 | 106 | 131
30 | 82 | 107 | 132
35 | 83 | 108 | 133
40 | 84 | 109 | 134
45 | 85 | 110 | 135
50 | 86 | 111 | 136
55 | 87 | 112 | 137
60 | 88 | 113 | 138
65 | 89 | 114 | 139
70 | 90 | 115 | 140
75 | 91 | 116 | 141
80 | 92 | 117 | 142
85 | 93 | 118 | 143
90 | 94 | 119 | 144
95 | 95 | 120 | 145
100 | 96 | 121 | 146
105 | 97 | 122 | 147
110 | 98 | 123 | 148
115 | 99 | 124 | 149
120 | 100 | 125 | 150
Spreadsheet: 718930d1613415211-single-formula-conditional-formatting-for-3-criteria-tsm-schedule
Sheet: Sheet1

 | Customer | Frequency | Last TSM
 | Customer 2 | Monthly | 2020-03-10 00:00:00
 | Customer 3 | Monthly | 2020-10-10 00:00:00
 | Customer 1 | Monthly | 2021-02-10 00:00:00
 | Customer 4 | Quarterly | 2020-04-29 00:00:00
 | Customer 6 | Quarterly | 2020-01-22 00:00:00
 | Customer 7 | Quarterly | 2020-08-12 00:00:00
 | Customer 5 | Quarterly | 2020-12-11 00:00:00
 | Customer 14 | Quarterly | 2021-01-15 00:00:00
 | Customer 13 | Quarterly | 2021-02-10 00:00:00
 | Customer 8 | Semi-Anually | 2020-01-28 00:00:00
 | Customer 9 | Semi-Anually | 2020-11-01 00:00:00
 | Customer 15 | Semi-Anually | 2021-02-01 00:00:00
 | Customer 11 | Anually | 2020-03-11 00:00:00
 | Customer 12 | Anually | 2020-08-12 00:00:00
 | Customer 10 | Anually | 2020-10-10 00:00:00
 | Total
Spreadsheet: 126299d1319624249-issue-with-setting-up-a-formula-with-more-than-one-condition-ge-report-august-2011-final-test
Sheet: Summary Page

STATEMENT OF MATTERS FOR GE BUSINESSES
PAN EUROPEAN MATTERS
01 January to 31 August 2011
SUMMARY
 | 194361.1
Overall non-S&S related sums total | 9858.07
TOTAL (£) | 204219.17
BREAKDOWN | UK | Germany | Spain | Italy | France | Holland
Commercial Finance | 0 | 255.9 | 20486.54 | 0 | 0 | 0
Consumer Finance | 0 | 6264.89 | 0 | 0 | 0 | 0
Corporate | 0 | 27642.74 | 0 | 14021.59 | 0 | 0
Healthcare | 0 | 0 | 0 | 0 | 0 | 0
Industrial | 21808.97 | 33744.92 | 20486.54 | 0 | 5356.75 | 0
Infrastructure | 36105.24000000001 | 0 | 0 | 0 | 0 | 0
NBC Universal | 0 | 535.64 | 0 | 890.05 | 6936.349999999999 | 30169.59
TOTALS(£) | 57914.21000000001 | 68444.09 | 40973.08 | 14911.64 | 12293.1 | 30169.59
OVERALL TOTAL(£) |  |  |  |  |  |  |  | 224705.71
Key to Category of Work column
1. Redundancies
2. Negotiated Terminations
3. Individual Labour and Employment Litigation
4. Works Councils and/or Union applications
5. Special Projects (including cross border work)
6. General Day to Day Advice
Notes
1. For the purposes of this Statement of Matters, 1 Euro = 0.7877 British Pounds. All fees in euros were converted into pounds using this rate.
2. All fees are inclusive of VAT
Spreadsheet: 65176d1265894699-multi-level-bill-of-material-717631_neorez
Sheet: detail formulas

 | formula |  |  |  | Yellow 13 ink |  |  | formula |  |  | Intermediat calculation |  |  |  | Yellow 13 ink |  |  |  |  | 4
Yellow 13 ink | ingredients | % | Count | Cum. | ingredients | % |  | ingredients | % |  | ingredients | % |  |  | ingredients | % |  |  |  | Products
6 | Yellow 13 Base | 0.55 | 8 | 0 | IA 10 | 0.02 |  | Yellow 13 Base | 0.55 |  | Pigment Yellow 13 | 0.11 |  |  | Pigment Yellow 13 | 0.11 |  |  |  | Yellow 13 ink
1 | Varnish 4347 | 0.32 | 4 | 8 | [NAME] | 0.0264 |  | Varnish 4347 | 0.32 |  | [NAME] | 0.165 |  |  | [NAME] | 0.357 |  |  |  | Yellow 13 Base
 | IA 10 | 0.02 | 0 | 12 | Acetate | 0.1603344 |  | IA 10 | 0.02 |  | DBP | 0.011 |  |  | DBP | 0.011 |  |  |  | Varnish 4347
 | [NAME] | 0 | 0 | 12 | Ethanol | 0.2275655999999999 |  | [NAME] | 0 |  | S 22000 | 0.0011 | 0.55 |  | S 22000 | 0.0011
 | Acetate | 0.09 | 0 | 12 | Pigment Yellow 13 | 0.11 |  | Acetate | 0.09 |  | S 54000 | 0.006600000000000001 |  |  | S 54000 | 0.0066
 | Ethanol | 0.01999999999999991 | 0 | 12 | [NAME] | 0.357 |  | Ethanol | 0.01999999999999991 |  | [NAME] | 0.0264 |  |  | [NAME] | 0.0264
 |  |  |  |  | DBP | 0.011 |  |  |  |  | Acetate | 0.033 |  |  | Acetate | 0.1337
 |  |  |  |  | S 22000 | 0.0011 |  |  |  |  | Ethanol | 0.1968999999999999 |  |  | Ethanol | 0.2542
 |  |  |  |  | S 54000 | 0.006600000000000001 |  |  |  |  | [NAME] | 0.192 |  |  | U-347 | 0.08
 |  |  |  |  | U-347 | 0.08 |  |  |  |  | U-347 | 0.08 | 0.32 |  | IA 10 | 0.02
 |  |  |  |  |  |  |  |  |  |  | Acetate | 0.01066560000000003
 |  |  |  |  |  |  |  |  |  |  | Ethanol | 0.0373344
 |  |  |  |  |  |  |  |  |  |  | IA 10 | 0.02
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0.13
 |  |  |  |  |  |  |  |  |  |  | Acetate | 0.09
 |  |  |  |  |  |  |  |  |  |  | Ethanol | 0.01999999999999991
 |  |  | 12 | 12 |  | 0.9999999999999999 |  |  | 1 |  |  | 0.9999999999999999 |  |  |  | 1
Yellow 13 Base | Pigment Yellow 13 | 0.11 | 0
Yellow 13 Base | [NAME] | 0.165 | 0
Yellow 13 Base | DBP | 0.011 | 0
Yellow 13 Base | S 22000 | 0.0011 | 0 |  |  |  |  | Result |  |  |  | Calculation
Yellow 13 Base | S 54000 | 0.006600000000000001 | 0 |  |  |  |  |  |  |  |  |  |  |  | Result
Yellow 13 Base | [NAME] | 0.0264 | 0
Yellow 13 Base | Acetate | 0.033 | 0
Yellow 13 Base | Ethanol | 0.1968999999999999 | 0
Varnish 4347 | [NAME] | 0.192 | 0
Varnish 4347 | U-347 | 0.08 | 0
Varnish 4347 | Ethanol | 0.01066560000000003 | 0
Varnish 4347 | Acetate | 0.0373344 | 0
[NAME]. | 10
Spreadsheet: 854517d1704362553-trying-to-use-unique-function-to-create-tracker-trial-sheet
Sheet: Pivot

ENTITY | ([NAME])
[NAME] | Count of Session 1 | Count of Session 3 | Count of Session 2 | Count of NAME
Finance | 5 | 5 | 5 | 5
Front Office | 15 | 5 | 15 | 15
Nurses | 136 | 140 | 136 | 140
Physician | 27 |  |  | 27
Total Geral | 183 | 150 | 156 | 187
Spreadsheet: 875581d1722188877-how-to-make-index-work-after-drag-solved-test
Sheet: януари

№ | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | APPLE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST
Spreadsheet: 1ce0661f-00af-4a17-a1e7-3edaeac2c52e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-03-27 09:29:27.540000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.875 | 102.75 | 102.625 | 102.25
4.625 | 102.151 | 102.026 | 101.901 | 101.526 |  | Note: | Refer To Price [NAME]
4.5 | 101.212 | 101.087 | 100.962 | 100.587 |  |  | For all Price Adjs
4.375 | 100.293 | 100.168 | 100.043 | 99.418
4.25 | 99.715 | 99.59 | 99.465 | 98.84
4.125 | 98.884 | 98.759 | 98.634 | 98.009
4 | 97.866 | 97.741 | 97.616 | 96.991
3.875 | 96.817 | 96.692 | 96.567 | 95.942
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.311 | 102.186 | 102.061 | 101.686
3.75 | 101.956 | 101.831 | 101.706 | 101.331
3.625 | 101.551 | 101.426 | 101.301 | 100.926
3.5 | 100.976 | 100.851 | 100.726 | 100.101
3.375 | 100.221 | 100.096 | 99.971 | 99.346
3.25 | 99.417 | 99.292 | 99.167 | 98.542 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-04-10 09:29:27.540000
30 DAY | 2014-04-25 09:29:27.540000
45 DAY | 2014-05-10 09:29:27.540000
60 DAY | 2014-05-25 09:29:27.540000
90 DAY | 2014-06-24 09:29:27.540000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 694558d1599678307-contact-center-kpis-example-data
Sheet: Tool Usage

Network ID | First Name | Tool Usage
B7869681 |  | 93
C7859132 |  | 88.2
D7586974 |  | 91.7
P7870486 |  | 87.5
B7869681 |  | 100
C7859132 |  | 73.7
D7586974 |  | 79.2
[NAME] |  | 82.4
P7870486 |  | 100
W7869556 |  | 83.3
B7869681 |  | 89.5
C7859132 |  | 85.3
D7586974 |  | 93.8
[NAME] |  | 91.3
P7870486 |  | 100
W7869556 |  | 71.4
B7869681 |  | 96.4
C7859132 |  | 81.8
D7586974 |  | 92.9
[NAME] |  | 84.6
P7870486 |  | 100
W7869556 |  | 81.3
[NAME] |  | 88.9
B7869681 |  | 93.1
C7859132 |  | 92
D7586974 |  | 93.3
[NAME] |  | 93.3
P7870486 |  | 100
B7869681 |  | 100
C7859132 |  | 100
P7870486 |  | 100
W7869556 |  | 88.24
C7859132 |  | 88.89
M5602701 |  | 75
[NAME] |  | 85.71
W7869556 |  | 94.44
Spreadsheet: kevin_ruscitti__20263__PLRates 05-01
Sheet: PEPL

ACA
GRI
FIRM TRANSPORT (FT)
 |  | Comm | Fuel
Gathering Charge |  | 0.0016 | 0.0044
Field Zone |  | Comm | Fuel |  |  | Reciprocal
 |  | 0.0195 | 0.0088 | (Fld zone to Haven)
Market Zone
Access Charge |  | 0.0003
 |  |  | Fuel Rate | Reciprocal |  | Fuel Rate | Reciprocal
[NAME] |  | Comm | [NAME] to downstream [NAME] |  |  | (from Haven)
Zn 1-100 |  | 0.0024 |  |  |  | 0.0044
Zn 101-200 |  | 0.005 |  |  |  | 0.0088
Zn 201-300 |  | 0.0075 |  |  |  | 0.0132
[NAME] |  | 0.01 |  |  |  | 0.0176
Zn 401-500 |  | 0.0125 |  |  |  | 0.022
Zn 501-600 |  | 0.015 |  |  |  | 0.0264
Zn 601-700 |  | 0.0175 |  |  |  | 0.0308
Zn 701-800 |  | 0.02 |  |  |  | 0.0352
Zn 801-900 |  | 0.0225 |  |  |  | 0.0396
Zn 901-1000 |  | 0.025 |  |  |  | 0.044
INTERRUPTIBLE TRANSPORT (IT)
Gathering Charge |  | 0.2882
Field Zone |  | Comm |  | ***Fuel same as FT rates
 |  | 0.1766 |  | Minimun commodity rates equate to FT rates
Market Zone
Access Charge |  | 0.094
Zn 1-100 |  | 0.0222
Zn 101-200 |  | 0.0444
Zn 201-300 |  | 0.0666
[NAME] |  | 0.0888
Zn 401-500 |  | 0.111
Zn 501-600 |  | 0.1332
Zn 601-700 |  | 0.1554
Zn 701-800 |  | 0.1776
Zn 801-900 |  | 0.1998
Zn 901-1000 |  | 0.222
Effective: April 1,2000
Spreadsheet: kate_symes__18309__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-17 00:00:00 |  | 238.07 | 27808 | 156.7 | 11200
 | 2001-04-16 00:00:00 |  | 286.52 | 25008 | 213.36 | 10232
 | 2001-04-15 00:00:00 |  |  |  |  |  | 213.36 | 30696
 | 2001-04-14 00:00:00 |  | 268.4 | 18720 | 236.7 | 9400
 | 2001-04-13 00:00:00 |  | 268.4 | 18720 | 236.7 | 9400
 | 2001-04-12 00:00:00 |  | 341.1 | 29680 | 318.17 | 10400
 | 2001-04-11 00:00:00 |  | 348.15 | 35136 | 310.12 | 10400
 | 2001-04-10 00:00:00 |  | 326.44 | 32608 | 301.85 | 13000
 | 2001-04-09 00:00:00 |  | 268.28 | 26320 | 225.55 | 9800
 | 2001-04-08 00:00:00 |  |  |  |  |  | 225.55 | 29400
 | 2001-04-07 00:00:00 |  | 258.22 | 28320 | 196.69 | 9000
 | 2001-04-06 00:00:00 |  | 258.22 | 28320 | 196.69 | 9000
 | 2001-04-05 00:00:00 |  | 301.84 | 30864 | 235.95 | 8200
 | 2001-04-04 00:00:00 |  | 278.15 | 35376 | 204.75 | 9232
 | 2001-04-03 00:00:00 |  | 245.99 | 21936 | 136.34 | 7512
 | 2001-04-02 00:00:00 |  | 228.71 | 17360 | 140.68 | 5000
 | 2001-04-01 00:00:00 |  |  |  |  |  | 142.24 | 15000
 | 2001-03-31 00:00:00 |  | 181.02 | 24000 | 93.46 | 3640
 | 2001-03-30 00:00:00 |  | 181.94 | 20800 | 93.46 | 3640
 | 2001-03-29 00:00:00 |  | 178.38 | 28864 | 87.16 | 10496
 | 2001-03-28 00:00:00 |  | 142.39 | 35120 | 78.18 | 4400
 | 2001-03-27 00:00:00 |  | 140.58 | 29520 | 76.2 | 4000
 | 2001-03-26 00:00:00 |  | 266.09 | 24560 | 155.06 | 6160
 | 2001-03-25 00:00:00 |  |  |  |  |  | 153.65 | 16680
 | 2001-03-24 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-23 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-22 00:00:00 |  | 294.15 | 12720 | 177.94 | 7200
 | 2001-03-21 00:00:00 |  | 406.47 | 10320 | 234.87 | 5400
 | 2001-03-20 00:00:00 |  | 391.63 | 25920 | 261.33 | 9000
 | 2001-03-19 00:00:00 |  | 362.59 | 19760 | 274.08 | 10440
 | 2001-03-18 00:00:00 |  |  |  |  |  | 262.23 | 32520
Spreadsheet: 783271d1654700183-itemized-sum-of-data-by-a-specific-date-excel-query
Sheet: Summary

 | Item Code | Quantity Total | Go Live | Current SIW | SIS (+10) | Quantity Received
 | Item 1 | 30624 | 2022-09-23 00:00:00 | 2022-08-29 00:00:00
 | Item 2 | 30990 | 2022-09-23 00:00:00 | 2022-09-19 00:00:00
 | Item 3 | 15168 | 2022-11-16 00:00:00 | 2022-10-24 00:00:00
 | Item 4 | 20070 | 2022-11-01 00:00:00 | 2022-08-29 00:00:00
 | Item 5 | 15498 | 2022-10-05 00:00:00 | 2022-09-05 00:00:00
 | Item 6 | 40432 | 2022-10-05 00:00:00 | 2022-07-11 00:00:00
 | Item 7 | 10032 | 2022-10-05 00:00:00 | 2022-09-05 00:00:00
 | Item 8 | 43695 | 2022-10-19 00:00:00 | 2022-08-15 00:00:00
 | Column G to pull through how much stock will have been received by the date in column F using the data from "data" tab
Spreadsheet: 165439d1341233834-highlight-when-a-duplicate-exists-within-7-days-raid_database_v6
Sheet: Sheet1

NHS Number | Date | Day | Arrival  A & E (24hr clock) | Referral Time (24hr clock) | Time Elapsed | Assessed (Yes / No) | Assessment Time (24hr clock) | [NAME] (24hr clock) | Total time | DSH as primary attendance | Offered follow up | Attended follow up | Attended within last 7 days | Breach Details | Staff Member(s) | Comments
1234567890 | 2012-01-12 00:00:00
1234678901 | 2012-01-13 00:00:00
1234567890 | 2012-01-01 00:00:00
1234567890 | 2012-01-18 00:00:00
Spreadsheet: 779198d1651618087-formula-to-sum-number-based-on-multiple-dynamic-drop-down-criteria-sample-11
Sheet: Dashboard

 | Select Period | Region | Manager | Building
 | March 2022 | East | [NAME] | 114 - Building C
 |  | Current Month | YTD | Last Year YTD
 | Description | Actual | Actual | Actual LY YTD
 | Revenue |  |  |  |  | [NAME] WITH FORMULAS IN YELLOW
 | Expenses |  |  |  |  | do I need to use aggregate? So when using "All" it excludes the errors?
 |  |  |  |  |  | * For the YTD, I tried having it find the current period and counting backwards but I can't get it all to come together.
 | Example 1: WHAT IT SHOULD BE |  |  |  |  |  |  | Example 2: WHAT IT SHOULD BE
 | Select Period | Region | Manager | Building |  |  |  | Select Period | Region | Manager | Building
 | March 2022 | East | [NAME] | 114 - Building C |  |  |  | February 2022 | All_Regions | All_Mgrs | All_Buildings
 |  | Current Month | YTD | Last Year YTD |  |  |  |  | Current Month | YTD | Last Year YTD
 | Description | Actual | Actual | Actual LY YTD |  |  |  | Description | Actual | Actual | Actual LY YTD
 | Revenue | 139600.355415 | 414969.4906560001 | 68593.643052 |  |  |  | Revenue | 351659.9372940001 | 1193402.763459 | 313403.9428229998
 | Expenses | 370487.3361360001 | 1097765.647254 | 44028.976992 |  |  |  | Expenses | 987314.6358420001 | 2942594.413224 | -72576.54819
Spreadsheet: 803964d1667825991-extracting-data-from-excel-tables-sales-control
Sheet: Bank 1

 | Bank 1
 | Date | Nane | I.D Number | Transaction description2 | Invoice | Reference | Debit | Credits | Balance
 | 2022-11-01 00:00:00 |  |  | Opening Balance |  |  |  |  | 100
 | 2022-11-05 00:00:00 | Abi | A002 | Sales |  | 23 | 3000
 | 2022-11-05 00:00:00 | Bigboy | A003 | Sales |  | 24 | 2000
 | 2022-11-07 00:00:00 | Bern | A005 | Purchase |  | 100 |  | 300
 | 2022-11-07 00:00:00 | Rose | A001 | Sales |  |  | 500
 | 2022-11-08 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000
 | 2022-11-09 00:00:00 | ADAM | A008 | Rent |  | 102 |  | 500
 | 2022-11-09 00:00:00 | [NAME] | A006 | Purchase |  | 103 |  | 300
 | 2022-11-10 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000
Spreadsheet: 01d93c69-5e6c-4dbc-becd-f9d3219ac6f9
Sheet: Population Total

Plot | Number of Earthworms | Number of Earthworms
1 | 2
2 | 5 | Mean | 8.3
3 | 6 | Standard Error | 1.211518789692417
4 | 6 | Median | 8
5 | 7 | Mode | 6
6 | 9 | Standard Deviation | 3.831158803518562
7 | 10 | Sample Variance | 14.67777777777778
8 | 11 | Kurtosis | -0.2697873574317189
9 | 12 | Skewness | 0.1576775704804083
10 | 15 | Range | 13
Population Size (N): | 200 | Minimum | 2
[NAME] (n): | 10 | Maximum | 15
Estimated Variance: |  | Sum | 83
with fpc: |  | Count | 10
w/o fpc: |  | Confidence Level(95.0%) | 2.740645902364495
Estimated Std. Error: |  | Population Total:
with fpc: |  | Population Total Bound:
w/o fpc: |  | with fpc:
 |  | w/o fpc:
Spreadsheet: 810274d1671643608-formula-to-add-multiple-cells-into-one-cell-with-semicolon-added-after-every-entry-combining-all-values-into-one-cell-example
Sheet: Sheet1

Order #
01131340
01140877
01119876
01137540
01139856
01141800
01137539
01141801
04141780
01136567
01141263
01131345
01137402
01099654
04137781
01140554
01140439
01130450
01137366
01127162
04141181
04139714
01117087
01141479
Spreadsheet: 585739d1533920330-transpose-or-not-to-transpose-how-to-change-my-table-to-a-list-format-request-form
Sheet: NEW

REGION | COUNTRY | GROUP | PRODUCT NAME | PRODUCT CODE | QUANTITY
EUROPE | UK | A | PENCIL | CODE34 | 10
EUROPE | UK | A | NOTEBOOK | CODE45 | 5
EUROPE | UK | A | BAG | [NAME] | 6
INDIA | INDIA | B | PENCIL | CODE34 | 45
INDIA | INDIA | B | NOTEBOOK | CODE45 | 34
INDIA | INDIA | B | BAG | [NAME] | 2