tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 54127d1254153782-excel-2007-no-selection-on-vlookup-on-range-lookup-true-case07_alslezak_2
Sheet: Sales Summary

NewLeaf Paper
Summary Information
 | Sales Summary
 |  | COUNT | TOTAL | AVERAGE
 | Composition
 | Wirebound
 | Executive
 | Memo
 | Total Sales by Category
 |  | In State | Out of State
 | Priority Shipping |  |  |  |  | Criteria
 | Standard Shipping |  |  |  |  | Priority In State |  |  | Priority Out of State
 |  |  |  |  |  | Shipping | In State |  | Shipping | In State
 |  |  |  |  |  | P | Y |  | P | N
 | Average Sale by Category
 |  | In State | Out of State |  |  | Standard In State |  |  | Standard Out of State
 | Priority Shipping |  |  |  |  | Shipping | In State |  | Shipping | In State
 | Standard Shipping |  |  |  |  | S | Y |  | S | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 691bb10g5028ddd029
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wh!ohavwg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Al Slezak
Spreadsheet: 846777d1697918212-count-number-of-unique-values-in-a-column-example-57-ans
Sheet: Sheet1

2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-18 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-19 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-20 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
2023-10-21 00:00:00
Spreadsheet: 455992d1460585376-new-to-excel-time-difference-issue-can-anyone-help-example-001
Sheet: Sheet1

Team Name | [NAME] | Days In | Sun 20 Mar 16 | Mon 21 Mar 16 | Tue 22 Mar 16 | Wed 23 Mar 16 | Thu 24 Mar 16 | Fri 25 Mar 16 | Sat 26 Mar 16 | Total Hrs
Team SF 1 | 2 |  | 07:00:00 | 14:30:00 |  | 14:30:00 |  | 05:00:00 | 14:30:00
 |  |  | 19:00:00 | 21:30:00 |  | 19:00:00 |  | 10:00:00 | 19:30:00 |  |  | Total Hours
Team SF 2 | 1 |  | 02:30:00 | 04:00:00 |  | 04:00:00 | 04:00:00 | 02:30:00 | 14:00:00 |  |  | Average Hours
 |  |  | 08:00:00 | 08:00:00 |  | 12:30:00 | 08:00:00 | 06:30:00 | 19:00:00 |  |  | Average Paid Breaks
Team SF 3 | 3 |  | 02:30:00 | 04:30:00 | 04:00:00 | 04:30:00 |  | 05:00:00 | 04:00:00 |  |  | Average Days in
 |  |  | 08:00:00 | 08:30:00 | 08:00:00 | 10:30:00 |  | 12:30:00 | 12:30:00 |  |  | Difference Breaks
Team SF 4 | 2 |  | 03:30:00 | 03:30:00 | 14:30:00 | 22:30:00 |  |  | 04:00:00 |  |  | Difference Days In
 |  |  | 08:00:00 | 08:00:00 | 19:30:00 | 07:30:00 |  |  | 12:30:00 |  |  | Difference Hours
Team SF 5 | 1 |  | 03:30:00 | 03:30:00 | 03:30:00 |  | 04:30:00 | 04:30:00 | 15:30:00
 |  |  | 08:00:00 | 08:00:00 | 08:00:00 |  | 12:30:00 | 08:30:00 | 20:30:00
Team SF 6 | 1 |  | 03:30:00 | 02:30:00 | 03:30:00 |  | 04:30:00 | 04:30:00 | 03:30:00
 |  |  | 08:30:00 | 07:30:00 | 08:30:00 |  | 12:30:00 | 08:30:00 | 08:00:00
Team SF 7 | 4 |  | 14:30:00 | 14:00:00 |  | 10:00:00 | 14:30:00 | 13:00:00 | 15:00:00
 |  |  | 21:30:00 | 20:00:00 |  | 19:00:00 | 19:30:00 | 20:00:00 | 19:00:00
Team SF 8 | 1 |  | 03:30:00 | 02:30:00 | 03:30:00 | 14:30:00 | 12:00:00 |  | 13:00:00
 |  |  | 07:30:00 | 07:30:00 | 08:30:00 | 19:30:00 | 19:00:00 |  | 18:30:00
Team SF 9 | 1 |  | 14:00:00 | 07:00:00 |  | 04:00:00 | 04:30:00 | 01:00:00
 |  |  | 18:30:00 | 19:00:00 |  | 08:00:00 | 08:30:00 | 06:30:00
Team SF 10 | 2 |  | 04:00:00 | 07:30:00 |  | 04:00:00 | 15:00:00 | 14:00:00
 |  |  | 08:00:00 | 19:30:00 |  | 12:30:00 | 19:30:00 | 19:30:00
Team SF 11 | 3 |  |  | 07:00:00 | 07:00:00 | 14:00:00 | 16:30:00 | 10:00:00
 |  |  |  | 19:00:00 | 19:00:00 | 19:00:00 | 20:30:00 | 19:30:00
Team SF 12 | 3 |  |  | 13:00:00 | 14:30:00 | 14:00:00 | 14:00:00 |  | 04:30:00
 |  |  |  | 23:00:00 | 20:00:00 | 19:00:00 | 20:00:00 |  | 12:00:00
Team SF13 | 2 |  |  | 07:00:00 |  | 02:30:00 | 15:30:00 | 15:30:00 | 13:00:00
 |  |  |  | 19:00:00 |  | 08:00:00 | 19:30:00 | 20:00:00 | 23:30:00
Team SF 14 | 4 |  |  | 04:30:00 | 16:00:00 |  | 04:00:00 | 09:00:00
 |  |  |  | 12:30:00 | 02:30:00 |  | 12:30:00 | 19:00:00
Team SF 15 | 3 |  | 07:00:00 | 04:30:00 | 02:30:00 |  | 13:00:00 |  | 10:00:00
 |  |  | 11:00:00 | 12:30:00 | 08:00:00 |  | 19:30:00 |  | 19:00:00
Team SF 16 | 2 |  | 04:30:00 | 03:30:00 | 01:00:00 |  | 02:30:00 |  | 02:30:00
 |  |  | 08:30:00 | 11:00:00 | 08:00:00 |  | 07:30:00 |  | 08:00:00
Team SF 17 | 3 |  |  | 13:00:00 | 06:30:00 | 12:00:00 | 14:00:00 |  | 02:30:00
 |  |  |  | 19:00:00 | 18:30:00 | 20:00:00 | 19:30:00 |  | 08:00:00
Team SF 18 | 3 |  |  | 04:30:00 | 22:30:00 |  | 04:30:00 | 09:00:00
 |  |  |  | 12:30:00 | 07:30:00 |  | 08:30:00 | 19:00:00
Spreadsheet: 708902d1608063945-text-on-value-field-but-including-blank-spaces-dax
Sheet: DAX Result

See | Etiquetas de columna
Etiquetas de fila | Type A | Type B | Type C | Type D | Total general
Point 1 | Need Upgrade |  |  |  | Need Upgrade
Point 10 |  | Needs Renovation |  |  | Needs Renovation
Point 4 |  |  |  | Need Upgrade | Need Upgrade
Point 5 | Needs Renovation |  |  |  | Needs Renovation
Point 6 | Buy new one |  |  |  | Buy new one
Point 7 |  |  |  | Buy new one | Buy new one
Point 8 |  | Needs Renovation |  |  | Needs Renovation
Point 9 |  |  | Buy new one |  | Buy new one
Spreadsheet: 740819d1626608678-drop-down-list-with-few-independent-column-drop-down-list-with-indepentend-name
Sheet: Sheet1

 |  | D1 | D2 | D3 | D4 | D5 | D6 |  |  |  | D | [NAME]
 |  | Name A1 | Ben1 | F45 | Cha | Pech | Boy
 |  | [NAME] | Ben2 | F46 | Data | Men | Girl
 |  | Name A3 | [NAME] | F47 |  | Women | Bay
 |  | Name A4 | Ben4 | F48 |  |  | little
 |  | Name A5 | Ben5 | F49 |  |  | Sister
 |  | Name A6 |  | F50
 |  | Name A7 |  | F51
 |  | Name A8
 |  | Name A9
Spreadsheet: 128676d1321193513-conditional-formatting-using-formulas-book1-modified
Sheet: Sheet1

 |  | a1 | b1 | c1 | d1 | e1 | f1
 |  | 0 | 12 | 160 | 0 | 24 | 1
 |  | 0 | 1 | 27 | 1 | 2 | 1
 |  | 0 | 1 | 16 | 1 | 30 | 9
 |  | 0 | 2 | 14 | 1 | 7 | 33
 |  | 0 | 1 | 10 | 1 | 11 | 1
 |  | 0 | 4 | 4 | 4 | 1 | 1
 |  | 0 | 0 | 0 | 0 | 1 | 1
 |  | 0 | 0 | 0 | 0 | 1 | 1
 |  | 0 | 0 | 0 | 0 | 1 | 1
 |  | 0 | 0 | 0 | 0 | 12 | 88
 |  | 0 | 0 | 0 | 0 | 2 | 28
 |  | 0 | 0 | 0 | 0 | 1 | 27
 |  | 0 | 0 | 0 | 0 | 1 | 8
 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0
 | averages per column | 11 | 4 | 11 | 6 | 8 | 21
Spreadsheet: 646567d1571916322-help-to-count-cells-on-sheets-with-changing-names-example-1
Sheet: 2710

 |  |  | ROTA W/E: | 2019-10-27 00:00:00
LAST EDIT: | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
SITE 1
0600-1800
1800-0600
SITE 2
SAT 1200-1800 -SUN 0600-1200 |  |  |  |  |  | E NAME | E NAME
1800-0600 |  |  |  |  |  | F NAME
SITE 3
2000-0800 | C NAME | C NAME | C NAME | C NAME | D NAME | D NAME | C NAME
SITE 4
2000-0800 | B NAME | B NAME | B NAME | B NAME | B NAME | B NAME | B NAME
SITE 5
 | 2100-0700 | 2100-0700 | 2100-0700 | 2100-0700 | 1700-0700 | 1900-0900 | 1900-0700
 |  |  |  |  | A NAME | A NAME | A NAME
Spreadsheet: 787745d1657996955-lookup-and-provide-latest-price-for-month-based-criteria-lookup-match-issue_excel
Sheet: Comparison

 |  |  |  |  | ***WOULD LIKE TO GET THE PRICE FROM DATA SHEET (COLUMN K) IN THE BELOW TABLE - THE LATEST PRICE FOR THAT MONTH***
 |  |  |  | Years | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month updated |  | PY | Pricing |  | Var
 |  |  |  | <1/1/2021 | 2021 |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  | 2021 | 2022 | 2021 | 2nd last | Latest
Country | Customer Name | Product Segment | Item Description |  | Jan | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Month | Month | Price | Price | Price | % change | Customer #
CA | OLD Reinhart - LaCr | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz
CA | OLD Reinhart - LaCr | FCD | 70213002 - IMA Oatmeal Rsn 1oz
CA | OLD Reinhart - LaCr | FCD | 70213003 - IMA Peanut Btr 1oz
CA | OLD Reinhart - LaCr | FCD | 70213027 - IMA Double Choc 1.5oz
CA | OLD Rein - Shaw | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz
CA | OLD Rein - Shaw | FCD | 70213002 - IMA Oatmeal Rsn 1oz
CA | OLD Rein - Shaw | FCD | 70213003 - IMA Peanut Btr 1oz
CA | OLD Rein - Shaw | FCD | 70213027 - IMA Double Choc 1.5oz
CA | PC | FCD | 70110434 - Wht Choc Mac 8lbx4
CA | QMCS | FCD | 7000962- Wht Choc Mac 3oz
CA | QMCS | FCD | Flag 7000961 - Choc Chunk 3oz
CA | RDP Foodservice | FCD | 7000761 - Choc Chunk 1.5oz
CA | Rein FS | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz
CA | Rein FS | FCD | 70213002 - IMA Oatmeal Rsn 1oz
CA | Rein FS | FCD | 70213003 - IMA Peanut Btr 1oz
CA | Rein FS | FCD | 70213027 - IMA Double Choc 1.5oz
CA | Sy - DET | FCD | 7000110 - Oatmeal Rsn 2oz
CA | Sy - DET | FCD | 7000160 - Double Choc 2oz
CA | Sy - DET | FCD | Flag 70A0108 - Sugar 2oz
CA | Sy - GR | BCS | 7000612 - Choc Chunk Bkd 1.35oz
USA | [NAME] |  | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US
USA | [NAME] |  | FG Ns 16ozx12 Choc Chip Lovers BNB
Spreadsheet: 164627d1340822453-excel-formula-using-if-to-get-one-of-two-true-results-or-false-results-12-13-budget
Sheet: Student Worker Limits

Student Workers | Total Hours | Total Days | Exceeded?
Spreadsheet: 740182d1626213536-countif-not-working-with-true-criterion-functional-detailed-cs-schedule-sample
Sheet: Saturday

 | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00:00 |  |  |  |  | Attendance
 | 7:00a | 7:15a | 7:30a | 7:45a | 8:00a | 8:15a | 8:30a | 8:45a | 9:00a | 9:15a | 9:30a | 9:45a | 10:00a | 10:15a | 10:30a | 10:45a | 11:00a | 11:15a | 11:30a | 11:45a | 12:00p | 12:15p | 12:30p | 12:45p | 1:00p | 1:15p | 1:30p | 1:45p | 2:00p | 2:15p | 2:30p | 2:45p | 3:00p | 3:15p | 3:30p | 3:45p | 4:00p | 4:15p | 4:30p | 4:45p | 5:00p | 5:15p | 5:30p | 5:45p | 6:00p | 6:15p | 6:30p | 6:45p | NA | A | UA | T
Talk Agents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
Total staffed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Staff needed
Number of Calls
Spreadsheet: 584718d1533339970-excel-filling-one-table-with-data-from-another-table-copy-of-d-ploiements-clients-erex-
Sheet: Data

Nom du client | [NAME] | Client Existant | Commercial | Revendeur | Adresse | Ville | Fournisseur | Type d'accès | Débit | NB de paires | Zone Tarifaire | [NAME] | [NAME] | Type Modem | [NAME] | Ariane | IP Publique dédiée | Nb Ip publiques | Adresse [NAME] | Facturation Equipements | Audit | Date Audit | Resultat Audit | Facturation Audit | Date commande | Référence Fournisseur | Date [NAME] | Numéro de suivi transporteur | [NAME] | Coût port | Date [NAME] | RDV Installation | Date convenue | Date effective  [NAME] | Date [NAME] | [NAME]
Client 1 | En cours | NON | ID | ADER | 9 avenue de l Industrie | [NAME] | Orange | SDSL | 4Mbts | 2 | [NAME] |  | En preparation |  |  |  |  |  |  | A faire | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | A faire | 2018-07-26 00:00:00 | 0043UJA9 | 2018-07-10 00:00:00 |  |  |  |  |  |  |  |  | A FAIRE
Client 2 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | Fibre | 10Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043SZN3 | 2018-05-05 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 3 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | SDSL | 4Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TEK1 | 2010-08-01 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 4 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | ADSL | 10Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TFB6 | 2018-09-04 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 5 | En cours | NON | TR | Ouest Consulting | ZA de l Espérance | Quessoy | Orange | Fibre | 4Mbts |  | [NAME] |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-18 00:00:00 | 0043TCP3 | 2018-07-06 00:00:00 |  |  |  |  |  | 2018-09-12 00:00:00 |  |  | A FAIRE
Client 6 | En cours | NON | TR | UnifyTelecom | 20 rue ANDRE DESSAUX | Fleury les Aubrais | Orange | Fibre | 100Mbts |  |  | [NAME] | Prêt |  | Partielle | fcecda40fddf |  |  |  | Inclus | NON |  |  |  | 2018-04-11 00:00:00 | 0043BZB2 | 2018-07-24 00:00:00 | 1ZW52F356894961686 |  | 14.22 | 2018-07-25 00:00:00 |  | 23 et 27/07/2018 |  |  | A FAIRE
Client 7 | En cours | NON | AVH |  | 9Bis Avenue de Iena | Paris | Orange | SDSL | 4Mbts | 1 | [NAME] |  |  |  |  |  |  |  |  | Inclus | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | Inclus | 2018-07-26 00:00:00 | 0043UGL3 |  |  |  |  |  |  |  |  |  | A FAIRE
Client 8 | En cours | NON | AVH |  | 9Bis Avenue de Iena | Paris | Orange | SDSL | 4Mbts | 1 | [NAME] |  |  |  |  |  |  |  |  | Inclus | OUI | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | Inclus | 2018-07-25 00:00:00 | 0043UKM4
Client 9 | En cours | NON | ID | Hexacom | 999 Chemin de Sauvecanne | Bouc Bel Air | Orange | SDSL | 4Mbts | 4 |  |  |  |  |  |  |  |  |  |  | NON |  |  |  | 2018-07-23 00:00:00 | 0043EEL8 F59070230718 |  |  |  |  | 2018-08-06 00:00:00 |  | 2018-08-06 00:00:00
Spreadsheet: 864106d1711425918-counts-number-of-dates-falls-in-the-month-date-count
Sheet: Sheet1

Description | Date check #1 | Date check #2 | Date check #2 | Date check #3
PC 1 | 2024-03-21 00:00:00 | 2024-04-17 00:00:00
Table | 2023-12-18 00:00:00 | 2024-01-03 00:00:00 | 2024-02-01 00:00:00 | 2024-03-11 00:00:00
Screen | 2024-02-27 00:00:00 | 2024-04-11 00:00:00
Machine 1 | 2024-01-06 00:00:00 | 2024-02-27 00:00:00 | 2024-03-11 00:00:00 | 2024-04-17 00:00:00
Result
2023-12-01 00:00:00 | 1
2024-01-01 00:00:00 | 2
2024-02-01 00:00:00 | 3
2024-03-01 00:00:00 | 3
2024-04-01 00:00:00 | 3
Spreadsheet: 05e41bd9-353f-4021-8d1a-638f59e092c1
Sheet: LIBR

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | LIBR 100 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
3 | LIBR 110 | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 832929d1686672732-help-required-on-countifs-formula-formula-support
Sheet: LAT_LON

 |  |  |  | 72510038 |  |  | 2023-05-31 14:38:00
Project ID | Project Name | Site Name | Site_Id | Task ID | Task Name | User ID | Task Actual | Latitude | Longitude | Hide_Site_Location | modifiedTime | Site Geofence status | geofence_range | Onsite
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510038 | TRM Ready | 7952 | 2023-05-31 14:38:00 | 30.542409 | 47.804346 | 0 | 2023-05-31 14:29:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510038 | TRM Ready | 7952 | 2023-05-31 14:38:00 | 33.312578 | 44.3447809 | 0 | 2023-05-31 14:34:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510038 | TRM Ready | 7952 | 2023-05-31 14:38:00 | 33.312578 | 44.3447809 | 0 | 2023-05-31 14:38:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510038 | TRM Ready | 7952 | 2023-05-31 14:38:00 | 30.542409 | 47.804346 | 0 | 2023-05-31 14:39:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510070 | Site RFA | 7952 | 2023-05-31 20:07:00 | 30.542409 | 47.804346 | 0 | 2023-05-31 14:29:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510070 | Site RFA | 7952 | 2023-05-31 20:07:00 | 33.312578 | 44.3447809 | 0 | 2023-05-31 14:34:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510070 | Site RFA | 7952 | 2023-05-31 20:07:00 | 33.312578 | 44.3447809 | 0 | 2023-05-31 14:38:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510070 | Site RFA | 7952 | 2023-05-31 20:07:00 | 30.542409 | 47.804346 | 0 | 2023-05-31 14:39:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510072 | Quality Assessment | 5450 | 2023-05-31 18:43:00 | 30.542409 | 47.804346 | 0 | 2023-05-31 14:29:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510072 | Quality Assessment | 5450 | 2023-05-31 18:43:00 | 33.312578 | 44.3447809 | 0 | 2023-05-31 14:34:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510072 | Quality Assessment | 5450 | 2023-05-31 18:43:00 | 33.312578 | 44.3447809 | 0 | 2023-05-31 14:38:00 | Blocking | 300 | 1
PR-0000112 | IQ_MEA ME ZAIN CT Iraq | 5000 | 172488 | 72510072 | Quality Assessment | 5450 | 2023-05-31 18:43:00 | 30.542409 | 47.804346 | 0 | 2023-05-31 14:39:00 | Blocking | 300 | 1
Spreadsheet: 779600d1651892575-way-to-hide-certain-dates-when-date-is-in-another-field-sample
Sheet: Sheet1

Dates - Week One |  |  |  |  |  |  | Dates - Week Two
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2023-05-01 00:00:00
Holiday Dates
2022-04-15 00:00:00 | Good Friday
2022-04-16 00:00:00 | Saturday before Easter Sunday
2022-04-17 00:00:00 | Easter Sunday
2022-04-18 00:00:00 | Easter Monday
2022-04-25 00:00:00 | Anzac Day
2022-06-13 00:00:00 | Queen's Birthday
Spreadsheet: 81912d1282036753-link-selected-cells-in-new-sequence-dummy-timetable
Sheet: Timetable

0800-0900 | 1d   CANCELLED |  | 1d | 6c |  | 1d |  | 1d EXCURSION | 6c |  | 1d   HOLIDAY |  | 1d | 6c |  | 1d |  | 1d | 6c |  | 1d |  | 1d | 6c |  | 1d |  | 1d | 6c |  | 1d   GRADES |  | 1d | 6c
0900-1000 | 1d   CANCELLED |  |  | 6c | 1d | 1d |  |  | 6c | 1d TEST | 1d   HOLIDAY |  |  | 6c | 1d | 1d |  |  | 6c | 1d WATCH FILM | 1d |  |  | 6c | 1d TEST | 1d |  |  | 6c | 1d | 1d   GRADES |  |  | 6c | 1d
1000-1100 |  |  | 5b | 2a | 6c |  |  | 5b | 2a | 6c |  |  | 5b | 2a | 6c |  |  | 5b | 2a | 6c |  |  | 5b | 2a | 6c |  |  | 5b | 2a | 6c |  |  | 5b | 2a | 6c
1100-1200 | 2a |  |  |  | 6c | 2a TEST |  |  |  | 6c | 2a HOLIDAY |  |  |  | 6c | 2a |  |  |  | 6c | 2a TEST |  |  |  | 6c | 2a |  |  |  | 6c | 2a |  |  |  | 6c
1200-1300 |  | 5b |  |  |  |  | 5b |  |  |  |  | 5b |  |  |  |  | 5b |  |  |  |  | 5b |  |  |  |  | 5b |  |  |  |  | 5b
1300-1400
1400-1500 | 4f | 2a | 6c | 5b | 5b | 4f | 2a | 6c CANCELLED | 5b | 5b | 4f HOLIDAY | 2a | 6c | 5b | 5b | 4f | 2a | 6c | 5b | 5b | 4f | 2a | 6c CANCELLED | 5b | 5b | 4f | 2a | 6c | 5b | 5b | 4f | 2a | 6c | 5b | 5b
15-00-1600 | 6c | 2a |  |  | 5b | 6c | 2a |  |  | 5b | 6c HOLIDAY | 2a |  |  | 5b | 6c | 2a |  |  | 5b | 6c | 2a |  |  | 5b | 6c | 2a |  |  | 5b | 6c | 2a |  |  | 5b
Spreadsheet: 797871d1664200303-convert-the-xx-xx-xxx-text-onto-numbers-for-sum-up-2022-09-26-oeldere-vs2-tapkatapka-question
Sheet: _PRD_ VMI Report #all plants# R

Vendor | Current Date | Plant | Plant Description | Material | Material Description | Requirements Date | Requirement Quantity | Open Order Qty | Order unit | Purchase Order(s) | Purchasing group | Purch.group name | Plant status | Plant status description | MRP-Area | MRP-Area description
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 05.09.2022 | 4.265,009 | 0 | DKG |  | 102 | 4265.009
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 12.09.2022 | 7.506,489 | 130.000,000 | DKG | [PHONE]-000010 | 102 | 7506.489
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 19.09.2022 | 21.307,508 | 130.000,000 | DKG | [PHONE]-000010 | 102 | 21307.508
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 26.09.2022 | 28.006,023 | 0 | DKG |  | 102 | 28006.023
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 03.10.2022 | 33.280,574 | 0 | DKG |  | 102 | 33280.574
905937 | 08.09.2022 | P003 | Ontex Eeklo (Eutima) | G1.431 | FF U RAY JLDE ECF 8% 508/1511 FSC | 10.10.2022 | 40.241,789 | 0 | DKG |  | 102 | 40241.789
4,265.009 | #N/A