tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeff_dasovich__14022__sdg&e prices
Sheet: dasovich

Company Name | Year | Residential Rate $/MWh | Commercial Rate $/MWh | Industrial Rate $/MWh | Pub Str & Hwy Lt $/MWh | Total Retail Rate $/MWh | Wholesale Rate $/MWh | Average Elec Rate $/MWh
San Diego Gas & Electric Co. | 1989 | 99.57 | 81.92 | 68.16 | 99.81 | 85.78 | 35.98 | 82.29
San Diego Gas & Electric Co. | 1990 | 100.73 | 83.95 | 70.21 | 105.35 | 87.35 | 37.44 | 84.85
San Diego Gas & Electric Co. | 1991 | 106.15 | 89.82 | 74.51 | 108.55 | 92.69 | 36.35 | 89.98
San Diego Gas & Electric Co. | 1992 | 107.8 | 90.11 | 73.63 | 101.43 | 93.08 | 24.42 | 90.26
San Diego Gas & Electric Co. | 1993 | 108.14 | 92.61 | 72.17 | 97.88 | 93.76 | 31.96 | 89.71
San Diego Gas & Electric Co. | 1994 | 110.32 | 97.21 | 74.75 | 95.08 | 97.42 | 30.22 | 94.25
San Diego Gas & Electric Co. | 1995 | 110.76 | 98.29 | 74.98 | 96.28 | 97.69 | 23.01 | 95.84
San Diego Gas & Electric Co. | 1996 | 108.92 | 96.62 | 73.14 | 94.59 | 95.94 | 20.4 | 93
San Diego Gas & Electric Co. | 1997 | 111.74 | 98.02 | 74.35 | 88.91 | 97.9 | 23.68 | 81.05
San Diego Gas & Electric Co. | 1998 | 101.38 | 94.29 | 75.14 | 89.7 | 93.36 | 21.88 | 90.39
Spreadsheet: 795006d1662461716-right-forumla-in-vlookup-error-urmarire-porci-2022
Sheet: IUNIE 2.0

NR | DATA TAIERE | NR CAP | LOT | GREUTATE VIU | MEDIE VIU | GREUTATE CARCASA | GREUTATE ORGANE |  | DATA | AVIZE | CARC CLF | TRANS CLF | ORG CLF | CARC MRC | TRANS MRC | ORG  MRC | CARC CRH | TRANS CRH | ORG CRH
1 | 2022-06-16 00:00:00 | 5 | 313 | 567 |  | 448 | 21.4 |  |  | 521-522 | 268.76 |  | 11.4 |  |  |  | 179.17 |  | 10
2 | 2022-06-18 00:00:00 | 5 | 314 | 575 |  | 454 | 21.7 |  |  | 523-525 |  |  | 7.25 |  |  | 7.25 |  |  | 7.25
3 | 2022-06-20 00:00:00 | 7 | 315 |  |  |  | 28.8 |  |  | 526-528
4 | 2022-06-23 00:00:00 | 10 | 316 | 1145 |  |  | 42 |  |  | 529-531 |  |  |  |  |  |  | 407 |  | 18.9
5 | 2022-06-24 00:00:00 | 3 | 317 | 356 |  |  | 14.5 |  |  | 532 | 281.2 |  | 14.5
6 | 2022-06-28 00:00:00 | 4 | 318 | 480 |  |  | 16.2 |  |  | 533-535 |  |  | 8.1 |  |  | 4 | 94.8 |  | 4
7 | 2022-06-30 00:00:00 | 5 | 319 | 604 |  |  | 21.6
Total
Spreadsheet: 880526d1728319353-trying-to-use-the-correlation-between-multiple-variable-ranges-to-solve-for-x-cap-rate-correlation
Sheet: Sheet1

 |  | Weight |  | Best | Worst |  | Actual #1 | Actual #2 | Actual #3 | Actual #4
 |  | 0.75 | A | 20 | 5 |  | 10 | - | - | -
 |  | 0.25 | B | $0 | 215 |  | 70 | - | - | -
 |  |  | X | 0.055 |  |  | 0.06 | - | - | -
 |  |  |  | Example
 |  |  | A | 17
 |  |  | B | 125
 |  |  | X | ???
Spreadsheet: 66640d1267270296-linking-data-to-different-tabs-in-excel-staff-5
Sheet: employee 2

employee 2
task | date
Spreadsheet: 5c7afb84-8d28-4cde-af01-0db83fd7935a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259961 | 25148 | [NAME] | Mosquera | USA | 3 | 00:15:56 | 00:04:04 | [NAME] | 00:02:30 | 00:20:36 | 1 | 01:29:12
259961 | 30439 | Joleen | Hakker | NED | 4 | 00:20:12 | 00:04:18 | 00:38:46 | 00:02:47 | 00:24:29 | 2 | 01:30:31
259961 | 65445 | Marleide | [NAME] | BRA | 1 | 00:19:14 | 00:05:13 | 01:11:29 | [NAME] | 00:27:22 | 3 | 02:06:36
259961 | 51375 | [NAME] | Walsh | USA | 2 | 00:16:22 | 00:03:21 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 270041d1381349917-formula-to-add-the-above-number-cell-until-it-finds-0-example-2
Sheet: 08-10-2013 TUE

 |  |  |  |  |  | D | 1.4 | 4.5 | 8.5 |  | 0.4 | 3.5 | 7.5 | 10 | 10
 |  |  |  |  |  | B | 1.8 | 3.6 | 4.5 |  | 0.8 | 2.6 | 3.5
 |  |  |  |  |  | B | 2.5 | 3.4 | 2.75 |  | 1.5 | 2.4 | 1.75
 |  |  |  |  |  | D | 2 | 3.4 | 3.8 |  | 1 | 2.4 | 2.8
 |  |  |  |  |  | D | 2.38 | 3.25 | 3.1 |  | 1.38 | 2.25 | 2.1
 |  |  |  |  |  | B | 4.2 | 3.5 | 1.91 |  | 3.2 | 2.5 | 0.91
 |  |  |  |  |  | B | 2.2 | 3.3 | 3.4 |  | 1.2 | 2.3 | 2.4
 |  |  |  |  |  | B | 1.17 | 7 | 17 |  | 0.17 | 6 | 16
 |  |  |  |  |  | M | 6 | 3.75 | 1.62 |  | 5 | 2.75 | 0.62
 |  |  |  |  |  | B | 4.33 | 3.6 | 1.83 |  | 3.33 | 2.6 | 0.83
 |  |  |  |  |  | B | 1.25 | 5.5 | 13 |  | 0.25 | 4.5 | 12
 |  |  |  |  |  | M | 2.9 | 3.4 | 2.4 |  | 1.9 | 2.4 | 1.4
 |  |  |  |  |  | B | 1.5 | 4.33 | 6.5 |  | 0.5 | 3.33 | 5.5
 |  |  |  |  |  | B | 1.29 | 5.5 | 11 |  | 0.29 | 4.5 | 10
 |  |  |  |  |  | D | 2.25 | 3.4 | 3.2 |  | 1.25 | 2.4 | 2.2
Spreadsheet: 218249d1362408734-transfer-data-from-one-format-to-another-test2
Sheet: Sheet1

patient | BP1 | BP2 | BP3 | BP4 | BP5 | BP6
test | 68.4330429172872 | 13.51675843187451 | 11.37028682425402 | 7.409494809951269 |  |  |  | 1997-08-03 00:00:00 | 1997-05-21 00:00:00 | 1998-09-06 00:00:00 | 1999-04-14 00:00:00
a2 | 55.37188683051394 | 59.64576538230583 | 6.357276157220824 | 64.8563980881697 | 39.54958804192092 | 75.01204837192941 |  | 1995-07-16 00:00:00 | 1996-03-07 00:00:00 | 1997-04-05 00:00:00 | 1998-11-08 00:00:00 | 1999-11-03 00:00:00 | 2000-01-19 00:00:00
a3 | 35.00036954866236 | 65.6816980885118 | 17.19727071759054 | 64.35386538042238 |  |  |  | 1995-07-04 00:00:00 | 1995-04-16 00:00:00 | 1995-01-27 00:00:00 | 1995-01-07 00:00:00
a4 | 41.68205974390654 | 16.80967838939377 |  |  |  |  |  | 1995-09-22 00:00:00 | 1996-08-23 00:00:00
a5 | 48.67874955559051 | 78.87760947265129 | 19.24119885964105 | 38.11649637496561 |  |  |  | 1996-11-17 00:00:00 | 1997-08-04 00:00:00 | 1998-12-19 00:00:00 | 1999-12-20 00:00:00
a6 | 35.83530418663113 | 49.69366593933504 | 14.77142052193823 | 72.9264971296947 | 29.03379351185601 | 40.05140021807772 |  | 1995-07-04 00:00:00 | 1995-03-20 00:00:00 | 1997-10-22 00:00:00 | 1998-09-14 00:00:00 | 1999-02-23 00:00:00 | 2000-10-21 00:00:00
a7 | 19.5862132852789 | 17.56938202633975 | 7.248534909166509 | 39.40248288758312 |  |  |  | 1995-05-16 00:00:00 | 1996-11-06 00:00:00 | 1997-10-21 00:00:00 | 1998-06-02 00:00:00
[NAME] | 60.98039959773267 | 27.48057852843163 | 79.1342300532435 | 22.27310008321055 |  |  |  | 1995-01-02 00:00:00 | 1995-02-27 00:00:00 | 1995-02-11 00:00:00 | 1995-02-14 00:00:00
a9 | 32.81296468193332 |  |  |  |  |  |  | 1995-06-27 00:00:00
a10 | 75.94262441017216 | 59.99582494239938 | 3.806962501948448 | 58.47627194576297 |  |  |  | 1999-02-27 00:00:00 | 2000-10-02 00:00:00 | 2001-01-02 00:00:00 | 2002-12-03 00:00:00
Spreadsheet: 35385d1232992489-excel-2007-dropdown-different-sums-possible-p47-2009
Sheet: Sheet4

Mēneši | Dzīvokļu nr | Iedzīvotāji | Dzīvokļa platība | [NAME] sk | Īres maksa | Dzīvnieki | Šķūnīši | [NAME]
[NAME] | 1 | [NAME] | 56.7 | 3 | 0.45 | 0 | 1 | 0
[NAME] | 2 | Viktors Kļementjevs | 30 | 1 | 1.2 | 0 | 0 | 1
Marts | 4 | [NAME] | 83.5 | 4 | 1.2 | 1 | 0 | 1
Aprīlis | 6 | Aivars Kacars | 44 | 3 | 0.45 | 0 | 0 | 0
Maijs | 8 | Vladislavs Vilcāns | 43.5 | 2 | 1.2 | 0 | 1 | 1
Jūnijs | 10 | [NAME] | 67.8 | 4 | 1.2 | 0 | 1 | 1
[NAME] | 12 | [NAME] | 72.3 | 1 | 0.45 | 0 | 0 | 0
Augusts | 13 | [NAME] | 39.9 | 3 | 1.2 | 1 | 1 | 1
[NAME] | 14 | [NAME] | 91.4 | 3 | 0.45 | 0 | 0 | 0
[NAME] | 15 | [NAME] | 57.5 | 2 | 1.2 | 0 | 1 | 0
Novembris | 16 | 16. tukšs | 54.8 | 0 | 0 | 0 | 0 | 0
Decembris | 18 | [NAME] | 107.8 | 3 | 0.45 | 0 | 0 | 1
 | 19 | [NAME] | 27.1 | 1 | 1.2 | 0 | 0 | 0
 | 21 | [NAME] | 56.6 | 4 | 1.2 | 0 | 1 | 1
 | 22 | [NAME] | 27.1 | 1 | ??? | 0 | 0 | 0
 | 25 | 25. tukšs | 79.7 | 0 | 0 | 0 | 0 | 0
 | 4a | [NAME] | 37.2 | 1 | 1.2 | 0 | 1 | 0
 | 5a | Milda Čemere | 66.7 | 2 | 1.2 | 0 | 0 | 0
 | 6a | [NAME] | 34.9 | 1 | 1.2 | 0 | 0 | 0
 | 7a | Nadežda [NAME] | 37.2 | 1 | 1.2 | 0 | 0 | 0
 | 8a | [NAME] | 65.9 | 5 | 1.2 | 1 | 1 | 1
 | 9a | [NAME] | 34.9 | 2 | 1.2 | 0 | 0 | 0
Spreadsheet: 679638d1590552558-lookup-based-on-2-criteria-lookup-example
Sheet: Template

ID | Name | 85000.AB.3000 | 85000.AZ.3000 | 90000.AB.3000 | 90000.AZ.3000
12345 | [NAME], [NAME]
98765 | Doe, [NAME]
24680 | [NAME], [NAME]
13579 | [NAME], [NAME]
13579 | [NAME], [NAME]
12390 | Nicole, Amber
Spreadsheet: 871200d1717593982-show-chart-based-on-a-cell-value-indirect-formula-sample
Sheet: Data

 | [NAME] |  | Goal |  | Number of Call Ins |  |  |  | Break Ins |  |  |  | Planner KPI |  |  |  |  |  | [NAME]
 | Week 1 |  | 0.8 |  | Week 1 |  | 2 |  | Week 1 |  | 5 |  | Week 1 |  | 0.6 |  |  |  | Number of Call Ins
 | Week 2 |  | 0.8 |  | Week 2 |  | 2 |  | Week 2 |  | 5 |  | Week 2 |  | 0.6 |  |  |  | Break Ins
 | Week 3 |  | 0.8 |  | Week 3 |  | 2 |  | Week 3 |  | 5 |  | Week 3 |  | 0.6 |  |  |  | Planner KPI
 | Week 4 |  | 0.8 |  | Week 4 |  | 2 |  | Week 4 |  | 5 |  | Week 4 |  | 0.6 |  |  |  | Break In WO % Hrs
 | Week 5 |  | 0.8 |  | Week 5 |  | 2 |  | Week 5 |  | 5 |  | Week 5 |  | 0.6 |  |  |  | Stock Out Parts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EDT
 | Break-In W/O % hrs |  | Goal |  | #stock out parts |  |  |  | EDT |  |  |  | Break In Hours |  |  |  |  |  | Break In Hours
 | Week 1 |  | 0.2 |  | Week 1 |  | 0.6 |  | Week 1 |  | 0.02 |  | Week 1 |  | 5 |  |  |  | RSCH WO
 | Week 2 |  | 0.2 |  | Week 2 |  | 0.6 |  | Week 2 |  | 0.02 |  | Week 2 |  | 5 |  |  |  | Hourly KPI
 | Week 3 |  | 0.2 |  | Week 3 |  | 0.6 |  | Week 3 |  | 0.02 |  | Week 3 |  | 5 |  |  |  | Vibration Route Adherence
 | Week 4 |  | 0.2 |  | Week 4 |  | 0.6 |  | Week 4 |  | 0.02 |  | Week 4 |  | 5 |  |  |  | Oil Analysis Route Adherence
 | Week 5 |  | 0.2 |  | Week 5 |  | 0.6 |  | Week 5 |  | 0.02 |  | Week 5 |  | 5 |  |  |  | Lube Grease Route Adherance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Preventative Maintenance Execution On Time
 | RSCH WO |  |  |  |  |  |  |  | Hourly KPI's |  |  |  |  |  |  |  |  |  | PM/PD Follow Up Work Order Execution within 100 Days
 | Week 1 |  | 5 |  |  |  |  |  | Week 1 |  | 0.6 |  |  |  |  |  |  |  | Safety Audits
 | Week 2 |  | 5 |  |  |  |  |  | Week 2 |  | 0.6
 | Week 3 |  | 5 |  |  |  |  |  | Week 3 |  | 0.6
 | Week 4 |  | 5 |  |  |  |  |  | Week 4 |  | 0.6
 | Week 5 |  | 5 |  |  |  |  |  | Week 5 |  | 0.6
 | Vibration Route Adherence |  |  |  | Oil Analsis Route Adherence |  |  |  | Lube Grease Route Adherance |  |  |  | Preventive Maintenance Execution On time
 | Week 1 |  | 1 |  | Week 1 |  | 1 |  | Week 1 |  | 1 |  | Week 1 |  | 0.95
 | Week 2 |  | 1 |  | Week 2 |  | 1 |  | Week 2 |  | 1 |  | Week 2 |  | 0.95
 | Week 3 |  | 1 |  | Week 3 |  | 1 |  | Week 3 |  | 1 |  | Week 3 |  | 0.95
 | Week 4 |  | 1 |  | Week 4 |  | 1 |  | Week 4 |  | 1 |  | Week 4 |  | 0.95
 | Week 5 |  | 1 |  | Week 5 |  | 1 |  | Week 5 |  | 1 |  | Week 5 |  | 0.95
 | PM/PD Follow Up work Execution with in 100 days |  |  |  |  |  |  |  | Safety
 | Week 1 |  | 0.85 |  |  |  |  |  | Week 1 |  | 4
 | Week 2 |  | 0.85 |  |  |  |  |  | Week 2 |  | 4
 | Week 3 |  | 0.85 |  |  |  |  |  | Week 3 |  | 4
 | Week 4 |  | 0.85 |  |  |  |  |  | Week 4 |  | 4
 | Week 5 |  | 0.85 |  |  |  |  |  | Week 5 |  | 4
Spreadsheet: 54383d1254359889-using-names-to-locate-info-book1
Sheet: Sheet1

SCHOOL A | vs. | GF | GA | O% | win# |  | PTS | SOG | 150 | Rank | #N/A | SOR | Blow out | Shut out | FIFA | Style | Wins | Losses | Ties | Win % | Win#
 | SCHOOL B | 1 | 2 | 10 | 1 | L | 0 | 1 | 150 | 48 | 1.369127516778524 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0
SCHOOL B | vs. | GF | GA | O% | win# |  | PTS | SOG | 150 | Rank | #N/A | SOR | Blow out | Shut out | FIFA | Style | Wins | Losses | Ties | Win % | Win#
 | SCHOOL A | 2 | 1 | 0 | 0 | W | 5 | 1 | 150 | 12 | 1.852348993288591 | 1 | 0 | 0 | 9.261744966442953 | 5 | 1 | 0 | 0 | 10 | 1
Spreadsheet: 674804d1588020083-sum-data-based-on-a-gl-code-and-month-in-year-book1
Sheet: Snapshot

 | MONTH | 2020-03-31 00:00:00
 |  |  |  | Var | % | Comments
200 | Sales1 | 100000 | 200000 |  |  | OFFSET Formula
210 | Sales2 | 200000 | 100000 |  |  | OFFSET Formula
211 | Sales3 | 300000 | 0 |  |  | OFFSET Formula
212 | Sales4 | 400000 | 200000 |  |  | OFFSET Formula
213 | Sales5 | 500000 | 300000 |  |  | OFFSET Formula
214 | Sales6 | 600000 | 45000 |  |  | OFFSET Formula
215 | Sales7 | 700000 | 450000 |  |  | OFFSET Formula
220 | Sales8 | 800000 | 800000 |  |  | OFFSET Formula
405 | Sales9 | 900000 | 1500000 |  |  | OFFSET Formula
 | Income
 | Direct Costs
 | Operating Profit
 | Overhead
 | Expense
 | Net Profit
 | Other Income
 | Bank Revaluations
 | Unrealised Currency Gains
 | Realised Currency Gains
 | Profit before Tax
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 32539 | 31400
2 | 32516 | 31400
3 | 39547 | 36521
4 | 37821 | 33628
5 | 35429 | 38484
6 | 39523 | 38484
7 | 40822 | 38500
8 | 41242 | 38499
9 | 39629 | 37100
10 | 39802 | 37879
11 | 39852 | 38499
12 | 18864 | 24382
13 | 34489 | 35457
14 | 40193 | 39600
15 | 40662 | 38879
16 | 38470 | 39600
17 | 40314 | 39600
18 | 40863 | 39600
19 | 39065 | 39600
20 | 40407 | 39600
21 | 42088 | 36760
22 | 41031 | 35000
23 | 40034 | 35000
24 | 41568 | 35000
25 | 31257 | 37000
26 | 38281 | 37000
27 | 33326 | 37000
28
29
30
31
2001-07-31 00:00:00 |  |  | -38120.6
2001-08-27 00:00:00
CBS Volume
 |  |  | -2104
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 4

 | October 25 | November 1 | November 8 | 2013-11-22 00:00:00 | November 22
Total Interest Rate* | 21930 | 32909 | 35658 | 24385 | 32242
SDs and MSPs** | 8267 | 13277 | 13773 | 10361 | 13030
Other | 13663 | 19632 | 21885 | 14024 | 19212
Total Cross-Currency | 704 | 1132 | 1722 | 1292 | 1634
SDs and MSPs | 444 | 802 | 1115 | 866 | 1022
Other | 260 | 330 | 607 | 426 | 612
Total Credit | 15616 | 15747 | 16225 | 14988 | 27836
SDs and MSPs | 8707 | 8815 | 9221 | 8117 | 13284
Other | 6909 | 6932 | 7004 | 6871 | 14552
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 38250 | 49788 | 53605 | 40665 | 61712
Weekly total, swap ticket volumes by asset class and participant type (number of new trades), all products and tenors, cleared and uncleared. For cleared swaps, the creation of each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, each trade is attributed to both swap counterparties. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Ticket Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 126987d1320093009-countif-on-mismatch-data-countifsample
Sheet: Data

region | Group | fromDate | provName | ShortName
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | Birdsall, [NAME]
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | [NAME], [NAME]
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | [NAME], [NAME]
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | Birdsall, [NAME]
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | Birdsall, [NAME]
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | [NAME], [NAME]
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | Birdsall, [NAME]
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | [NAME], [NAME]
EAST | MEDICAL GROUP | 2010-06-01 00:00:00 | [NAME], [NAME]
EAST | MEDICAL GROUP | 2010-04-01 00:00:00 | [NAME], [NAME]
Spreadsheet: 840185d1692540811-transforming-database-with-formulas-transforming-database-with-formula_3
Sheet: Though Case

2022-01-25 00:00:00 | შპს ამს ტექნიკს | 741023 | General and administrative expenses | 4083 |  | 20004664 | 102 | Purchase invoice | ა/ფ ეა-74 3235478,ინვ.25/01-3 | მომზადების კურსი საავიაციო უშიშროების საკითხებში |  | GEL | 170.62 | 0 | 170.62 | 170.62 |  | 001CC001 | 1/25/2022 |  | 2022-01-25 00:00:00 |  | 25000014 |  |  |  | Expense account |  |  | 0 | 0 | 0 |  |  | ქსოვრელი ნანა | [NAME] | Transaction originates from E-Account
2022-01-25 00:00:00 | TAX creditor | 333100 | Trade and other payables | 5 |  | 20004664 | 102 | Purchase invoice | ა/ფ ეა-74 3235478,ინვ.25/01-3 | 4083 / შპს ამს ტექნიკს |  | GEL | 30.71 | 0 | 30.71 | 30.71 |  | 001CC001 | 1/25/2022 |  | 2022-01-25 00:00:00 |  | 25000014 |  |  |  | Creditor account |  |  | 0 | 0 | 0 |  |  | ქსოვრელი ნანა | [NAME] | Transaction originates from E-Account
2022-01-25 00:00:00 | შპს ამს ტექნიკს | 741023 | General and administrative expenses | 4083 |  | 20004664 | 102 | Purchase invoice | ა/ფ ეა-74 3235478,ინვ.25/01-3 | მომზადების კურსი საავიაციო უშიშროების საკითხებში |  | GEL | 170.62 | 0 | 170.62 | 170.62 |  | 001CC001 | 1/25/2022 |  | 2022-01-25 00:00:00 |  | 25000014 |  |  |  | Expense account |  |  | 0 | 0 | 0 |  |  | ქსოვრელი ნანა | [NAME] | Transaction originates from E-Account
2022-01-25 00:00:00 | TAX creditor | 333100 | Trade and other payables | 5 |  | 20004664 | 102 | Purchase invoice | ა/ფ ეა-74 3235478,ინვ.25/01-3 | 4083 / შპს ამს ტექნიკს |  | GEL | 30.71 | 0 | 30.71 | 30.71 |  | 001CC001 | 1/25/2022 |  | 2022-01-25 00:00:00 |  | 25000014 |  |  |  | Creditor account |  |  | 0 | 0 | 0 |  |  | ქსოვრელი ნანა | [NAME] | Transaction originates from E-Account
2022-01-25 00:00:00 | შპს ამს ტექნიკს | 741023 | General and administrative expenses | 4083 |  | 20004664 | 202 | Purchase invoice | ა/ფ ეა-74 3235478,ინვ.25/01-3 | მომზადების კურსი საავიაციო უშიშროების საკითხებში |  | GEL | 170.62 | 0 | 170.62 | 170.62 |  | 001CC001 | 1/25/2022 |  | 2022-01-25 00:00:00 |  | 25000014 |  |  |  | Expense account |  |  | 0 | 0 | 0 |  |  | ქსოვრელი ნანა | [NAME] | Transaction originates from E-Account
2022-01-25 00:00:00 | TAX creditor | 333100 | Trade and other payables | 5 |  | 20004664 | 202 | Purchase invoice | ა/ფ ეა-74 3235478,ინვ.25/01-3 | 4083 / შპს ამს ტექნიკს |  | GEL | 30.72 | 0 | 30.72 | 30.72 |  | 001CC001 | 1/25/2022 |  | 2022-01-25 00:00:00 |  | 25000014 |  |  |  | Creditor account |  |  | 0 | 0 | 0 |  |  | ქსოვრელი ნანა | [NAME] | Transaction originates from E-Account
2022-01-25 00:00:00 | შპს ამს ტექნიკს | 311000 | Trade and other payables | 4083 |  | 20004664 | 0 | Purchase invoice | ა/ფ ეა-74 3235478,ინვ.25/01-3 | მომზადების კურსი საავიაციო უშიშროების საკითხებში |  | GEL | 0 | 604 | -604 | -604 |  | 001CC001 | 1/25/2022 |  | 2022-01-25 00:00:00 |  | 25000014 |  |  |  | Creditor account |  |  | 0 | 0 | 0 |  |  | ქსოვრელი ნანა | [NAME] | Transaction originates from E-Account
Spreadsheet: 81233d1281475162-dynamic-column-update-dynamic-column-update
Sheet: TRANSFERRED INFO

Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Spreadsheet: 677969d1589639745-power-query-extract-data-from-cells-to-build-a-table-of-data-for-analysis-book3
Sheet: Sheet1

REPORT 040
Date 06.05.2020 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9
SECTION 1
Executive Summary |  |  | G | Board are happy
Executive Summary |  |  | G | Everything on track
SECTION 2
Issue |  | Description |  |  |  |  |  | Status
1 |  | Section 2, Text 1 |  |  |  |  |  | A
2 |  | Section 2, Text 2 |  |  |  |  |  | A
3 |  | Section 2, Text 3 |  |  |  |  |  | A
SECTION 3
 | Description
 |  |  |  |  | For info | For action
1 | Section 3, Text 1 |  |  |  |  | Accounts
SECTION 4 |  |  |  |  |  |  | Status
Section 4, Text 1 |  |  |  |  |  |  | G
Section 4, Text 2 |  |  |  |  |  |  | G
Section 4, Text 3 |  |  |  |  |  |  | G
Section 4, Text 4 |  |  |  |  |  |  | G
SECTION 5
Section 5, Text 1
Section 5, Text 2
SECTION 6
Section 6, Text 1
Section 6, Text 2
Section 6, Text 3
SECTION 7
Section 7, Text 1
Section 7, Text 2
Section 7, Text 3
Section 7, Text 4
SECTION 8
Section 8, Text 1
Section 8, Text 2
Section 8, Text 3
SECTION 9
Recommendation 1 | Section 9, Text 1 | Status | A
Section 9, Text 2
Section 9, Text 3
Section 9, Text 4
Section 9, Text 5
Section 9, Text 6
Recommendation 2 | Section 9, Text 7 | Status | A
Section 9, Text 8
Section 9, Text 9
Section 9, Text 10
Section 9, Text 11
Section 9, Text 12
Section 9, Text 13
Section 9, Text 14
Section 9, Text 15
Recommendation 3 | Section 9, Text 16 | Status | A
Section 9, Text 17
Section 9, Text 18
Section 9, Text 19
Section 9, Text 20
Section 9, Text 21
Section 9, Text 22
Section 9, Text 23
Section 9, Text 24
Spreadsheet: 599124d1542870854-compare-four-columns-and-list-common-values-in-fifth-column-book1-for-upload-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  | Value 1 | Value 2 | Value 3 | Value 4 | Common Values
 |  |  |  |  |  |  |  | 6 | 1 | 5 | 2 |  |  | In column [NAME] and thereafter  I want all the  common values from Value 1, Value 2, Value 3  and Value 4. The value figure only if it is there in all four columns. The no of values in each column will vary depending upon other function
 |  |  |  |  |  |  |  | 7 | 2 | 11 | 7
 |  |  |  |  |  |  |  | 12 | 3 | 19 | 12
 |  |  |  |  |  |  |  | 13 | 4 | 20 | 17
 |  |  |  |  |  |  |  | 18 | 5 | 32 | 22
 |  |  |  |  |  |  |  | 19 | 6 | 38 | 27
 |  |  |  |  |  |  |  | 25 | 7 | 12 | 32
 |  |  |  |  |  |  |  | 26 | 8 | 37 | 37
 |  |  |  |  |  |  |  | 31 | 9 |  | 42 |  |  | How ARRAY formula is entered
 |  |  |  |  |  |  |  | 32 | 10 |  | 47
 |  |  |  |  |  |  |  | 37 | 11 |  | 52 |  |  | [NAME] in the cell.
 |  |  |  |  |  |  |  | 38 | 12 |  | 57 |  |  | Press F2
 |  |  |  |  |  |  |  | 44 | 13 |  |  |  |  | Hold Shift+ [NAME] and hit Enter key.
 |  |  |  |  |  |  |  | 45 | 14 |  |  |  |  | Now  the formula is surrounded by {} by excel.
 |  |  |  |  |  |  |  | 50 | 15
 |  |  |  |  |  |  |  | 51 | 16
 |  |  |  |  |  |  |  | 56 | 37
 |  |  |  |  |  |  |  | 57 | 18
 |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  | 31
Spreadsheet: 136211d1326473786-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration-4-
Sheet: Site 2

Employee Number | Name |  |  |  |  |  |  |  | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Total Bi-Weekly Hours
Spreadsheet: 216597d1361819256-if-and-vlookup-problem-level-3-tracking-for-anita-protected
Sheet: Unit 17S

Name | Surname | P1 | P2 | P3 | P4 | M1 | M2 | M3 | D1 | D2 | D3 | Final Grade | Final Points Value