tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883079d1731569953-counting-a-data-based-on-criteria-2-or-more-counting-a-data-based-on-criteria-2-or-more-
Sheet: Sheet1

Cage's | MPS FARM 1 | MPS FARM 2 |  |  | Expected result
GD03 | 0.5423941636003846 | 0.4576058363996154 |  |  | GA |  | GB |  | GC |  | [NAME] |  | GE
GD02 | 0.2787592286414414 | 0.7212407713585586 |  |  | <50% | >50% | <50% | >50% | <50% | >50% | <50% | >50% | <50% | >50%
GD01 | 0.2891547101478829 | 0.7108452898521171 |  | FARM 1
GA01 | 0.3228768940155138 | 0.6771231059844861 |  | FARM 2
GA07 | 0.6367368670137246 | 0.3632631329862754
GA11 | 0.4353989146427532 | 0.5646010853572468
GB05 | 0.578764136131611 | 0.4212358638683889
GC01 | 0.728821373501631 | 0.2711786264983689
GA03 | 0 | 1
GA04 | 0.6426552409242721 | 0.3573447590757279
GC02 | 0.715924716055859 | 0.2840752839441411
GD08 | 0.3124677361516667 | 0.6875322638483333
GA08 | 0.1958423125804185 | 0.8041576874195815
GA10 | 0.2801943925820167 | 0.7198056074179833
GB01 | 0.3540424314144063 | 0.6459575685855937
GE02 | 0.9211849436064683 | 0.07881505639353173
GE03 | 0.466971122797306 | 0.533028877202694
GE04 | 0 | 1
GA12 | 0.3496976807147369 | 0.650302319285263
GB03 | 0 | 1
GC12 | 0.3536249103299857 | 0.6463750896700143
GA09 | 0.3395973256113646 | 0.6604026743886353
GB07 | 0 | 1
GB08 | 0.6524544582209428 | 0.3475455417790572
GB09 | 0.3554154248606684 | 0.6445845751393315
GB10 | 0.6346005456753933 | 0.3653994543246067
GB11 | 0.3636559995452737 | 0.6363440004547263
GB12 | 0.3449795936774223 | 0.6550204063225777
GA02 | 0.3571279800647153 | 0.6428720199352848
GA06 | 0.3533279202471976 | 0.6466720797528024
GB04 | 0 | 1
Grand Total | 0.3808603555727438 | 0.6191396444272561
Spreadsheet: 713768d1610921627-how-to-convert-h-mm-ss-into-mins-excel-forum
Sheet: Sheet1

 |  | time
 | 1 | 3 days, 22:58:00
 | 2 | 4 days, 1:17:00
 | 3 | 4 days, 5:22:00
 | 4 | 4 days, 0:04:00
 | 5 | 4 days, 1:06:00
 | 6 | 4 days, 1:11:00
 | 7 | 4 days, 4:09:00
 | 8 | 4 days, 0:00:00
 | 9 | 3 days, 23:22:00
 | 10 | 3 days, 23:09:00
 | 11 | 3 days, 23:15:00
 | 12 | 3 days, 23:21:00
 | 13 | 3 days, 22:16:00
 | 14 | 4 days, 2:00:00
 | 15 | 4 days, 2:23:00
 | 16 | 3 days, 22:15:00
 | 17 | 3 days, 23:24:00
 | 18 | 4 days, 0:07:00
Spreadsheet: 731373d1620312134-defining-a-pivot-table-column-in-a-sumif-formula-sample-data
Sheet: Sum IF

Sum IF
All fruit | Count IF | SUMIF |  |  |  | Fruits mentioned
Apple |  |  |  |  |  | Fruits unmentioned
[NAME]
Avocado
[NAME]
[NAME]
Blackberry
Blackcurrant
Blueberry
Currant
[NAME]
Cherimoya
Clementine
Date
[NAME]
Durian
Eggplant
Elderberry
[NAME]
Gooseberry
Grape
Grapefruit
Guava
Huckleberry
Jackfruit
Jambul
Kiwi fruit
Kumquat
Legume
Lemon
Lime
Lychee
Mango
Mangostine
Melon
Cantaloupe
Honeydew melon
Watermelon
Rock melon
Nectarine
Orange
Peach
Pear
[NAME] pear or [NAME] pear
Pitaya
Physalis
Plum/prune (dried plum)
Pineapple
Pomegranate
Raisin
[NAME]
Western raspberry (blackcap)
Rambutan
Redcurrant
Salal berry
Satsuma
Star fruit
[NAME]
Tangerine
Tomato
Ugli fruit
Watermelon
Ziziphus mauritiana
Spreadsheet: 815619d1675091446-compare-two-pair-of-cells-function-usage-rede-coletora-de-esgoto2
Sheet: CÁLCULOS DE VAZÃO

 | [NAME] | 735 | Unid.
 | [NAME] por lote | 5 | [NAME]
 | Consumo per Capita | 200 | l/hab.dia
 | Coeficiente de retorno | 0.8
 | K1 | 1.2
 | K2 | 1.5
 | Taxa de Infiltração | 0.0005 | L/m
 | Comprimento da Rede | 5329.74 | m
 | Cálculo das vazões e verificação da rede
 |  | [NAME] | Fim de plano
 | Vazões | 0.816 | 6.084 | (l/s)
 | Vazão Distribuida |  |  | (L/s*m)
 | Taxa de Infiltração |  |  | (L/s*m)
 | Taxa de Contribuição Linear |  |  | (L/s*m)
 | Verificação
Spreadsheet: 867331d1714147168-i-am-trying-to-convert-portion-of-pokerstake-file-to-nearly-same-as-pokertake-platform-book100-west123-
Sheet: Pivot Table

status | [NAME]
seller-name | Sum of Combine percentage and value
[NAME] | 131.94
MendigoMod | 31.67
googleQAQ | 24.15
IchoFan | 20.18
Ainwin7 | 15.23
k0nfig | 13.25
saku_baba | 9.45
Itaaaaa | 1.49
a scientist | 1.46
Grand Total | 248.82
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 3

 | November 1 | November 8 | November 15 | 2013-11-22 00:00:00 | November 29
Total Interest Rate* | 16455 | 17829 | 12193 | 16121 | 11858
Cleared** | 11461 | 12964 | 8282 | 11354 | 10325
Uncleared | 4994 | 4865 | 3911 | 4767 | 1533
Total Cross-Currency | 566 | 861 | 646 | 817 | 223
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 566 | 861 | 646 | 817 | 223
Total Credit | 7874 | 8113 | 7494 | 13918 | 4729
Cleared | 4334 | 4793 | 4300 | 6302 | 2918
Uncleared | 3540 | 3320 | 3194 | 7616 | 1811
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 24894 | 26803 | 20333 | 30856 | 16810
Weekly total, swap ticket volumes by asset class and cleared status (number of new trades), all products, tenors, and participant types. For cleared swaps, this table reflects the creation of only one of the two swaps that results from the clearing process. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared 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: 138145d1327529941-solved-need-to-return-a-specified-cell-based-on-the-highest-value-in-a-range-test-worksheet
Sheet: Reference Checks

 | REFERENCE CHECKS
 |  | Refereces Checked?   Yes           No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference Score: |  |  |  |  | 3
 |  | Refereces Checked?   Yes           No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference Score: |  |  |  |  | 4
 |  | Refereces Checked?   Yes           No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference Score: |  |  |  |  | 4
 |  | Refereces Checked?   Yes           No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference Score: |  |  |  |  | 4
 |  | Refereces Checked?   Yes           No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference Score: |  |  |  |  | 4
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-09

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-09 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: 822967d1679618658-replace-repetitive-formulas-with-lambda-sample-replace-individual-formulas-with-lambda
Sheet: Sheet1

Statement | Serial | Position | Serial
2018 08 10
2018 08 10 | 2018 08 10 - 02
2018 08 10 | 2018 08 10 - 03
2018 08 10 | 2018 08 10 - 04
2018 08 10 | 2018 08 10 - 05
2018 08 10 | 2018 08 10 - 06
2018 09 11 | 2018 09 11 - 01
2018 09 11 | 2018 09 11 - 02
2018 09 11 | 2018 09 11 - 03
2018 09 11 | 2018 09 11 - 04
2018 09 11 | 2018 09 11 - 05
2018 09 11 | 2018 09 11 - 06
2018 09 11 | 2018 09 11 - 07
2018 09 11 | 2018 09 11 - 08
2018 09 11 | 2018 09 11 - 09
2018 10 11 | 2018 10 11 - 01
2018 10 11 | 2018 10 11 - 02
2018 10 11 | 2018 10 11 - 03
2018 10 11 | 2018 10 11 - 04
2018 10 11 | 2018 10 11 - 05
2018 10 11 | 2018 10 11 - 06
2018 10 11 | 2018 10 11 - 07
2018 10 11 | 2018 10 11 - 08
2018 10 11 | 2018 10 11 - 09
2018 10 11 | 2018 10 11 - 10
2018 10 11 | 2018 10 11 - 11
2018 11 09 | 2018 11 09 - 01
2018 11 09 | 2018 11 09 - 02
2018 11 09 | 2018 11 09 - 03
2018 11 09 | 2018 11 09 - 04
2018 11 09 | 2018 11 09 - 05
2018 11 09 | 2018 11 09 - 06
2018 11 09 | 2018 11 09 - 07
2018 11 09 | 2018 11 09 - 08
2018 11 09 | 2018 11 09 - 09
Spreadsheet: 6447897a-dc76-4df8-8394-e17065fee2a5
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Merch | 679143058683 | Family Force 5 | Heather Charcoal Worn Bling Logo For Retail Xlarge Unisex | 2014-08-05 | T-Shirt | Na | 14.99 | N | Available
Merch | 679143058676 | Family Force 5 | Heather Charcoal Worn Bling Logo For Retail Large Unisex | 2014-08-05 | T-Shirt | Na | 14.99 | N | Available
Merch | 679143058669 | Family Force 5 | Heather Charcoal Worn Bling Logo For Retail Medium Unisex | 2014-08-05 | T-Shirt | Na | 14.99 | N | Available
Merch | 679143058638 | Family Force 5 | Black Let It Be Love Spray Paint For Retail Xlarge Unisex | 2014-08-05 | T-Shirt | Na | 14.99 | N | Available
Merch | 679143058621 | Family Force 5 | Black Let It Be Love Spray Paint For Retail Large Unisex | 2014-08-05 | T-Shirt | Na | 14.99 | N | Available
Merch | 679143058614 | Family Force 5 | Black Let It Be Love Spray Paint For Retail Medium Unisex | 2014-08-05 | T-Shirt | Na | 14.99 | N | Available
Spreadsheet: 871030d1717492667-get-weekly-customer-list-from-a-prognosis-sheet-kopie-van-kopie-van-planning
Sheet: week sheet

week | 26 |  | if I fill in a weeknumber here, I would like the customers who ordered in that week to be indicated below here, including how much of each they ordered
Name | Groot | Klein
Spreadsheet: 158355d1338199059-copy-values-on-certain-date-daily-readings
Sheet: Sheet4

2012-05-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | U1 Mwhrs | u1 fg lb | u1 lf lbs | u1a starts | u1a cycles | u1a run hrs | u1a fg hrs | u1a lf hrs | u1b starts | u1b cycle | u1b run hrs | u1b fg hrs | u1b lf hrs | U2 Mwhrs | u2 fg lb | u2 lf lbs | u2a starts | u2a cycles | u2a run hrs | u2a fg hrs | u2a lf hrs | u2b starts | u2b cycle | u2b run hrs | u2b fg hrs | u2b lf hrs | [NAME] | u3 fg lb | u3 lf lbs | u3a starts | u3a cycles | u3a run hrs | u3a fg hrs | u3a lf hrs | u3b starts | u3b cycle | u3b run hrs | u3b fg hrs | u3b lf hrs
 | Unit 1 |  |  | Unit 2 |  |  | Unit 3 |  |  |  | 2012-05-01 00:00:00
 | MWhrs |  |  | MWhrs |  |  | MWhrs |  |  |  | 2012-05-02 00:00:00
 | FG Lbs |  |  | FG Lbs |  |  | FG Lbs |  |  |  | 2012-05-03 00:00:00
 | LF LBS |  |  | LF LBS |  |  | LF LBS |  |  |  | 2012-05-04 00:00:00
 | Water |  |  | Water |  |  | Water |  |  |  | 2012-05-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-06 00:00:00
 |  | U1A |  |  | U2A |  |  | U3A |  |  | 2012-05-07 00:00:00
 | Starts |  |  | Starts |  |  | Starts |  |  |  | 2012-05-08 00:00:00
 | Cycles |  |  | Cycles |  |  | Cycles |  |  |  | 2012-05-09 00:00:00
 | Run HRS |  |  | Run HRS |  |  | Run HRS |  |  |  | 2012-05-10 00:00:00
 | FG Hrs |  |  | FG Hrs |  |  | FG Hrs |  |  |  | 2012-05-11 00:00:00
 | LF hrs |  |  | LF hrs |  |  | LF hrs |  |  |  | 2012-05-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-13 00:00:00
 |  | U1B |  |  | U2B |  |  | U3B |  |  | 2012-05-14 00:00:00
 | Starts |  |  | Starts |  |  | Starts |  |  |  | 2012-05-15 00:00:00
 | Cycles |  |  | Cycles |  |  | Cycles |  |  |  | 2012-05-16 00:00:00
 | Run HRS |  |  | Run HRS |  |  | Run HRS |  |  |  | 2012-05-17 00:00:00
 | FG Hrs |  |  | FG Hrs |  |  | FG Hrs |  |  |  | 2012-05-18 00:00:00
 | LF hrs |  |  | LF hrs |  |  | LF hrs |  |  |  | 2012-05-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2012-05-31 00:00:00
Spreadsheet: 2987313a-baac-4340-8858-4ff06b080bca
Sheet: XMLheader

MINNESOTA COMMON COURSE CATALOGUE (MCCC)
Local Course Index K-12
XML Header Element Definitions and Characteristics
as of 0/23/2012
NOTES: | File submission validation will occur at time of file upload.  [NAME] may be rejected at this point in the load process.
 | Database validations will occur after the file load is successful.  Errors will be sent to user via email.
 | minOccurs default is one (1)
 | The submission process is a replacement process.  All records in the db for a site will be replaced by the corresponing site records in the current submission.
HeaderType2
ELEMENT NAME | DEFINITION | TYPE | LEN | REQ | PERMITTED VALUES |  | FILE SUBMISSION VALIDATION | SOFT ERROR VALIDATIONS
UnitNumber | MDE 4-digit district number | [NAME] | 4 | Y |  | 0-9 | • File will be rejected if unit number is not valid in MDE-Org for submission year.   • File will be rejected if value is not permitted. | n/a
UnitType | MDE 2-digit district type. | [NAME] | 2 | Y |  | 0-9 | • File will be rejected if the unit type is not valid in MDE-Org for submission year.   • File will be rejected if value is not permitted. | n/a
Year | The year number representing this school year. For the 10-11 school year, this value should be 2011 | [NAME] | 4 | Y |  | 0-9 | File will be rejected if  • this field is null or if value is not permitted. | n/a
Spreadsheet: 196817d1354116553-webimport-daily-updated-table-with-variable-number-of-objects-sample2
Sheet: OVERVIEW29-11

CARD | CURRENT | DIFFERENCE | 2012-11-28 00:00:00 | 2012-11-27 00:00:00 | 2012-11-26 00:00:00 | 2012-11-25 00:00:00
AAA | 0.55
AAB | 0.6
[NAME] |  |  | 2.25 | 2.25
Army of the Damned | 2.4 |  | 2.4 | 2.35
[NAME] | 1.45 |  | 1.45 | 1.45
Champion of the Parish | 1.1 |  | 1.1 | 1.15
Clifftop Retreat | 2.55 |  | 2.55 | 2.45
Essence of the Wild | 1.1 |  | 1.1 | 1.1
[NAME] | 19.2 |  | 19.2 | 18.5
Gavony Township | 1.1 |  | 1.1 | 1.05
Geist of Saint Traft | 24.75 |  | 24.75 | 25.5
Grimgrin Corpse-Born | 1.45 |  | 1.45 | 1.4
Grimoire of the Dead | 1.4 |  | 1.4 | 1.35
Hinterland Harbor | 3.1 |  | 3.1 | 3.05
Isolated Chapel | 3.3 |  | 3.3 | 3.35
[NAME] of the Veil | 22.5 |  | 22.5 | 22.25
Mikaeus the Lunarch | 3.6 |  | 3.6 | 4
Mirror-Mad Phantasm | 1 |  | 1 | 0.96
[NAME] | 11 |  | 11 | 11.1
Past in Flames | 5.5 |  | 5.5 | 5.7
Reaper from the [NAME] | 1.3 |  | 1.3 | 1.25
Runechanter's Pike | 0.78 |  | 0.78 | 0.7
Sever the Bloodline | 0.62 |  | 0.62 | 0.58
Skaab Ruinator | 1.15 |  | 1.15 | 1.2
[NAME] | 6.95 |  | 6.95 | 7.05
Stromkirk Noble | 1.5 |  | 1.5 | 1.65
[NAME] | 3.1 |  | 3.1 | 3.1
Tree of Redemption | 2.15 |  | 2.15 | 2.1
Woodland Cemetery | 2.85 |  | 2.85 | 3.2
Spreadsheet: 866473d1713379754-grouping-data-values-in-one-column-based-on-another-column-picture-included-to-explain-powerpivotconcatenatex
Sheet: Sheet1

Animal | Color |  | Row Labels | Colors
Cat | Black |  | Cat | Black, White, [NAME]
Cat | White |  | Monkey | Purple, Red, Black, Brown
Cat | Ginger
Monkey | Purple
Monkey | Red
Monkey | Black
Monkey | [NAME]
Spreadsheet: 840188d1692541433-transforming-database-with-formulas-transforming-database-with-formula
Sheet: Transoformed Base

 | Date |  | Dr |  | Our ref. |  |  | Currency code |  | Cr | Amount
 |  | AeroConnections | 148000 | Trade and other receivables | 20003686 | AC121020M | 24320016 | USD | 311000 | Trade and other payables | 26121.69
 | 2022-01-01 00:00:00 | AeroConnections | 2305-03-17 00:00:00 | Trade and other receivables | 20004159 | INV AC-10220 | 24320017 | USD | 2751-06-27 00:00:00 | Trade and other payables | 1914-02-14 20:09:36
 | 2022-01-01 00:00:00 | Unknown | 3942-06-23 00:00:00 | General and administrative expenses | 10009597 | ა/ფ ეა-72 7944925,ელ0599623125 | 31023166 | GEL | 2521-07-02 00:00:00 | Plant and equipment | 1899-12-29 09:36:00
Spreadsheet: 812313d1673052035-roster-calculations-trying-to-count-number-of-weeks-worked-calendar
Sheet: Total Hours and Weeks

 |  | Number of classes |  |  |  |  |  |  |  |  |  |  |  |  | Hours after 8pm weekdays and all day Saturday are multipled by 1.25
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
800 | Teacher 1
800 | Teacher 2
480 | Teacher 3
800 | Teacher 4
800 | Teacher 5
800 | Teacher 6
 |  | Number of classes |  |  |  |  |  |  |  |  |  |  |  |  | Hours after 8pm weekdays and all day Saturday are multipled by 1.25
Start time
End time |  |  |  |  |  |  |  |  |  |  | Annual tally
Hours required | Teacher |  |  |  |  |  |  |  |  |  | Total hours | Total weeks | Hours remaining | Actual hours | Unsociable hours
800 | Teacher 1
800 | Teacher 2
480 | Teacher 3
800 | Teacher 4
800 | Teacher 5
800 | Teacher 6
Spreadsheet: 839211d1691752862-finding-value-with-2-criteria-attachment2
Sheet: tab1

 | 2023-08-21 00:00:00
 | 1
 |  |  |  |  |  |  | How to show that there double values or error?
 |  |  |  |  |  |  | CELL F1 must be "B"
 | ma | di | wo | do | vr |  | Show the value of column 1 by matching, number (cell [NAME]), day (cell F7) and weeknumber (cell B2).
 |  |  |  | 2023-08-21 00:00:00
 |  |  |  | ma | di | wo | do | vr
Column 1 | Column 2 | Column 3
A | aaaaa | zzz
B | bbbbb | ww |  | 1 |  |  |  | 1
C | [NAME] | qqq |  | 1
D | ddd | rrr
E | eee | ttt
F | ffff | ttt
G | gggg | yy
Spreadsheet: 329935d1404461343-adding-times-over-24-hours-w-dates-adding-times-ans
Sheet: Sheet1

[NAME]in Time | Check-in Date | Total Time for Customer | [NAME] Time | [NAME] Date
08:50:00 | 2014-01-11 00:00:00 | 9:25:00
14:07:00 | 2014-01-12 00:00:00 | 3:00:00
15:07:00 | 2014-01-13 00:00:00 | 1 day, 0:00:00
16:07:00 | 2014-01-14 00:00:00 | 5:00:00
17:07:00 | 2014-01-15 00:00:00 | 1 day, 12:00:00
Spreadsheet: 868015d1714730920-why-is-this-not-working-test
Sheet: Act24

Test |  |  |  |  |  |  |  | 5 | 4 | 5 |  | 4 | 5 | 4
Profit & Loss Account |  |  |  | 3.5 |  | 3.8 | 3.8 |  |  | 4.5 | 3.8 | 3.8 | 4.2 | 2.8
2024-12-31 00:00:00
 |  |  | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2023 | 2022 | 2021 | 2020 | 2019
 |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Projections | Projections | Projections | Projections | Projections | Projections
 |  |  | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | Total | Total | Total | Total | Total | Total | Period | YTD
 |  |  | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £
Turnover
FC | 0 | FC |  | -2466.97 | 153858.32
EF | 0.55 | EF | 359208.88 | 487649.91 | 508157.26 | 449191.2293478262 | 449191.2293478262 | 548629.5580917876 | 486437.6338768117 | 548801.4330917876 | 486437.6338768117 | 473964.8740338166 | 548457.6830917876 | 344424.7756038647
S | 0
T | 0.15 |  | 117247.71 | 81103.22 | 91751.14 | 122506.6989130435 | 122506.6989130435 | 149626.2431159421 | 132664.8092391304 | 149673.1181159421 | 132664.8092391304 | 129263.1474637681 | 149579.3681159421 | 93934.02971014493
E | 0
A | 0.15 |  | 35403.11 | 50760.22 | 65383.23 | 122506.6989130435 | 122506.6989130435 | 149626.2431159421 | 132664.8092391304 | 149673.1181159421 | 132664.8092391304 | 129263.1474637681 | 149579.3681159421 | 93934.02971014493
D | 0.15 |  | 124261.23 | 147747.49 | 154560.85 | 122506.6989130435 | 122506.6989130435 | 149626.2431159421 | 132664.8092391304 | 149673.1181159421 | 132664.8092391304 | 129263.1474637681 | 149579.3681159421 | 93934.02971014493
Other incl accrued income adj |  |  | -20965.68 | 6280.63 | -9839.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 755769
Spreadsheet: 705707d1606264892-receiving-error-when-doing-a-simple-date-and-time-subtraction-excel-help
Sheet: Case Advanced Find View

Created On | Modified On | Column1
2020-11-02 06:06:59 | 2020-11-02 06:10:32
2020-11-02 06:08:56 | 2020-11-02 06:58:09
2020-11-02 06:11:21 | 2020-11-02 06:20:18
2020-11-02 06:14:49 | 2020-11-02 07:11:48
2020-11-02 06:17:05 | 2020-11-02 06:22:42
2020-11-02 06:18:22 | 2020-11-02 07:20:13
2020-11-02 06:26:24 | 2020-11-02 06:26:24
2020-11-02 06:27:04 | 2020-11-02 08:09:18
2020-11-02 06:29:03 | 2020-11-02 08:05:15
2020-11-02 06:35:50 | 2020-11-02 08:20:19
2020-11-02 06:41:32 | 2020-11-02 09:00:27
2020-11-02 06:58:13 | 2020-11-02 06:58:13
2020-11-02 07:15:57 | 2020-11-02 10:53:13
2020-11-02 07:18:20 | 2020-11-02 07:20:13
2020-11-02 07:42:26 | 2020-11-02 08:05:51
2020-11-02 08:03:59 | 2020-11-02 08:04:26
2020-11-02 08:04:30 | 2020-11-02 08:44:08
2020-11-02 08:05:40 | 2020-11-02 08:18:45
2020-11-02 08:07:30 | 2020-11-02 10:50:03
2020-11-02 08:09:33 | 2020-11-02 10:00:59
2020-11-02 08:09:57 | 2020-11-02 08:09:57
2020-11-02 08:10:50 | 2020-11-02 10:06:16
2020-11-02 08:13:28 | 2020-11-02 08:13:28
2020-11-02 08:18:02 | 2020-11-02 11:28:12
2020-11-02 08:22:40 | 2020-11-02 09:24:04
2020-11-02 08:26:14 | 2020-11-02 14:31:16
2020-11-02 08:27:24 | 2020-11-10 14:31:11
2020-11-02 08:29:18 | 2020-11-02 14:44:29
Spreadsheet: 756683d1637695689-help-with-in-and-out-times-in-excel-data-example
Sheet: Sheet1

 | First name | Last name | Event timestamp | Access point |  | Names | Earliest | Latest
 | [NAME] | Pan | 2021-11-16 08:47:22 | Virtual Gate - In
 | [NAME] | Pan | 2021-11-17 00:27:26 | Virtual Gate - Out |  | [NAME]
 | Billy | [NAME] | 2021-11-16 08:27:48 | Virtual Gate - In |  | [NAME]
 | Billy | [NAME] | 2021-11-16 18:35:03 | Virtual Gate - Out
 | [NAME] | Early | 2021-11-16 07:46:46 | Virtual Gate - In
 | [NAME] | Early | 2021-11-16 08:41:05 | Virtual Gate - Out
 | [NAME] | Early | 2021-11-16 10:00:32 | Virtual Gate - In
 | [NAME] | Early | 2021-11-16 12:39:52 | Virtual Gate - Out
 | [NAME] | Early | 2021-11-16 21:17:08 | Virtual Gate - In
 | [NAME] | Early | 2021-11-16 22:11:34 | Virtual Gate - Out
Spreadsheet: 217117d1361988794-if-function-help-algebra
Sheet: Sheet1

1 |  | a
 |  | b
 |  | c
 |  | d
 |  | e
 |  | f
 |  | g
 |  | h
 |  | i
 |  | j
 |  | k
 |  | l
 |  | m
 |  | n
 |  | o
 |  | p
 |  | q
 |  | r
 |  | s
 |  | t
 |  | u
 |  | v
 |  | w
 |  | x
 |  | y
 |  | z