tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18902__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 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
 | 2001-03-17 00:00:00 |  | 237.03 | 39120 | 176.44 | 8200
 | 2001-03-16 00:00:00 |  | 238.66 | 44720 | 176.44 | 8200
 | 2001-03-15 00:00:00 |  | 190.53 | 14720 | 144.42 | 7600
 | 2001-03-14 00:00:00 |  | 177.21 | 17120 | 139.11 | 8840
 | 2001-03-13 00:00:00 |  | 178.33 | 18000 | 141.6 | 9400
 | 2001-03-12 00:00:00 |  | 207.12 | 14000 | 167.55 | 6200
 | 2001-03-11 00:00:00 |  |  |  |  |  | 167.57 | 18000
 | 2001-03-10 00:00:00 |  | 189.97 | 30000 | 155.94 | 17200
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
Spreadsheet: 727324d1617836807-formula-multi-page-and-columns-commissions-test
Sheet: Agents

Agent Name | Jan | Feb | March | April | May | June | July | August | Sept | October | November | December |  | Jan | Feb | March | April | May | June | July | August | Sept | October | November | December
Scott  B |  | 104
[NAME] | 15
[NAME] | 176 | 16 | 16
[NAME] | 112 | 128
[NAME]
Barb Z
[NAME] | 64 | 57
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 50

कार्यक्रम PROGRAM |  |  | व्यापार तर्त्त OPERATIONAL ASPECTS OF TRADE FINANCE | PROG CODE
 |  |  |  | IT1832
तर्षर् समूह/JOB FAMILY |  |  | FOREIGN EXCHANGE
उद्देश्य/OBJECTIVE |  |  | TO  ENHANCE  AWARENESS  ON  TRADE  FINANCE  PRODUCTS, TECHNIQUES   ADOPTED   AND   ADVANCED   OPERATIONAL GUIDELINES IN HANDLING TRADE FINANCE
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration – Entry Test. Overview of FEMA - Current account and Capital account transactions. Foreign Trade Policy and the role of DGFT and Customs. Role of FEDAI.
 | II | RBI notifications / directions under FEMA - Exports of Goods and Services - Imports of Goods and Services.
 | III | International Payment terms - Advance remittance - Open account – Collections  -  Letter  of  Credits  and  Role  of  [NAME].  Related  FEDAI Rules. Brief on AML, FATF, OFAC sanctions, and TBML.
 | IV | Hedging currency risk: Forward contracts. EEFC & DDA.
Day 2 | I | Guidelines  and  procedure  on  Export  finance,  Due  diligence  while extending  credit  (Fund  based/non-fund-based  limits)  facility  & monitoring (FEMA & Credit risk), Sanction terms & conditions, Export Credit - Rupee & Foreign Currency entire life cycle, Pre – Shipment, Post  Shipment,  Gold  Card  Scheme,  Interest  Equalization  Scheme, Crystallisation.
 | II
 | III | Guidelines  and  procedure  on  Import  finance,  Due  diligence  while extending  credit  (Fund  based/non-fund-based  limits)  facility  & monitoring (FEMA & Credit risk), Sanction terms & conditions, Import LCs, Short-term trade credits - Buyer's & supplier's credit, FCLR.
 | IV
Day 3 | I | Important ICC  provisions  with  caselets  on:  INCO  Terms  2020; UCP 600; URC 522; URDG 758; ISBP745; ISP98.
 | II | Modalities  of  EDPMS  &  IDPMS.  Organizational  Structure  –  GTPC  – FX4U.
 | III | ECGC – ECIB – obligation of bank, claim procedures and ECGC Policies in general
 | IV | Marketing    of    banking    services    and    customer    relationship management,  Customer  scoping  and  importance  of  cross-selling. Conducting sales calls / mock sales calls, Feedback & Valediction.
Spreadsheet: f722f5ca-ebe0-485f-9963-39ce7d2cadba
Sheet: Sheet1

Commercial Construction Permits | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Entries made in the last 7 day(s)
Permit |  | Permit Type |  |  | Date Recorded | [NAME] | Job Address | Project |  | Contractor |  | Est Value
14-2335 |  | Commercial Interior |  |  | 2014-09-23 00:00:00 | 132 | 9600 PARKSIDE DR KNOXVILLE 37922 | JEWELRY TV HALLWAY MEZZANINE |  | Americas [NAME], Inc Dba Jewelry Tv |  | 24000
14-1461 |  | Commercial Addition |  |  | 2014-09-23 00:00:00 |  | 6948 MAYNARDVILLE PIKE KNOXVILLE TN 37918 | HOME FEDERAL BANK COVERED ATM ADDITION |  | [NAME] |  | 13000
14-2691 |  | Sign |  |  | 2014-09-23 00:00:00 |  | 6807 PLEASANT RIDGE RD KNOXVILLE TN 37921 | NORTHGATE PARTS MOBILE HOME & HVAC |  | Signco, Inc. |  | 8000
14-2729 |  | Sign |  |  | 2014-09-25 00:00:00 | 125 | 1204 E GOVERNOR JOHN SEVIER HWY KNOXVILLE TN 37920 | NORTHSTAR CHURCH |  | Southern Signs |  | 4000
14-2693 |  | Commercial Interior |  |  | 2014-09-25 00:00:00 | 063 | 522 [NAME] HWY STRAWBERRY PLAINS TN 37871 | PRICE LESS FOODS |  | Jones Builders Llc |  | 30000
14-2278 |  | Commercial Accessory Structure |  |  | 2014-09-26 00:00:00 | 029 | 6126 E EMORY RD | EMORY VALLEY BAPTIST CHURCH PICNIC SHELTER |  | Emory Valley Missionary Baptist Church |  | 2074
14-2680 |  | Commercial Interior |  |  | 2014-09-26 00:00:00 | 090 | 7811 #1 OAK RIDGE HWY KNOXVILLE TN 37931 | SENOR CACTUS MEXICAN GRILL |  | [NAME] |  | 22000
14-2742 |  | Sign |  |  | 2014-09-29 00:00:00 |  | 7229 [NAME] HWY POWELL TN 37849 | QUALITY POOLS |  | Neon Service Company |  | 2000
 | Total |  | 8 |  |  |  |  |  |  | Sum | 105074
Spreadsheet: 695919d1600464127-excell-criteria-help-combine-numbers
Sheet: Sheet2

Length
1964 |  |  |  |  |  |  |  |  |  |  | 5915 |  | 5934 |  | 5958
970 |  |  |  | From value: |  | 5900 |  |  |  |  | 1367 |  | 1990 |  | 1367
715 |  |  |  | To value: |  | 6000 |  |  |  |  | 1367 |  | 631 |  | 2300
468 |  |  |  |  |  |  |  |  |  |  | 2300 |  | 1964 |  | 1990
881 |  |  |  |  |  |  |  |  |  |  | 881 |  | 468 |  | 301
2124 |  |  |  |  |  |  |  |  |  |  |  |  | 881
1455
2124
 |  | 1455
2122
 |  | 1367
 |  | 2300
1990
468
 |  | 881
2124
1455
2122
1367
2300
 |  | 1990
 |  | 631
 |  | 1964
970
715
 |  | 468
 |  | 881
2124
1603
1885
 |  | 1367
 |  | 2300
 |  | 1990
2299
1902
759
 |  | 301
675.2
742
588.8
649
633.6
697
631
Spreadsheet: 77879d1278381288-excel-2007-excel-to-record-values-on-a-weekly-basis-finance
Sheet: Currency XR

Pieniadze |  |  |  |  |  | Dewizy
Nazwa | Symbol | Kupno | Sprzedaż | Spread |  | Nazwa | Symbol | Kupno | Sprzedaż | Spread
Euro | 1 EUR | 3.9867 | 4.2333 | 0.2466 |  | Euro | 1 EUR | 3.999 | 4.221 | 0.222
Dolar amerykański | 1 USD | 3.1863 | 3.3834 | 0.1971 |  | Dolar amerykański | 1 USD | 3.1962 | 3.3735 | 0.1773
Dolar australijski | 1 AUD | 2.6764 | 2.8419 | 0.1655 |  | Dolar australijski | 1 AUD | 2.6846 | 2.8336 | 0.149
Dolar kanadyjski | 1 CAD | 2.9901 | 3.1751 | 0.185 |  | Dolar kanadyjski | 1 CAD | 2.9994 | 3.1658 | 0.1664
[NAME] szwajcarski | 1 CHF | 2.9892 | 3.1741 | 0.1849 |  | [NAME] szwajcarski | 1 CHF | 2.9985 | 3.1649 | 0.1664
Korona czeska | 1 CZK | 0.1561 | 0.1658 | 0.0097 |  | Korona czeska | 1 CZK | 0.1566 | 0.1653 | 0.0087
Korona duńska | 1 DKK | 0.535 | 0.5681 | 0.0331 |  | Korona duńska | 1 DKK | 0.5367 | 0.5665 | 0.0298
Funt brytyjski | 1 GBP | 4.8143 | 5.1121 | 0.2978 |  | Funt brytyjski | 1 GBP | 4.8292 | 5.0972 | 0.268
Forint węgierski | 100 HUF | 1.3594 | 1.5025 | 0.1431 |  | Forint węgierski | 100 HUF | 1.3737 | 1.4882 | 0.1145
[NAME] japoński | 100 [NAME] | 3.6312 | 3.8558 | 0.2246 |  | [NAME] japoński | 100 [NAME] | 3.6424 | 3.8446 | 0.2022
Lit litewski | 1 LTL | 1.1308 | 1.2499 | 0.1191 |  | Lit litewski | 1 LTL | 1.1427 | 1.238 | 0.0953
Korona norweska | 1 NOK | 0.4945 | 0.5251 | 0.0306 |  | Korona norweska | 1 NOK | 0.496 | 0.5236 | 0.0276
Korona szwedzka | 1 SEK | 0.4139 | 0.4395 | 0.0256 |  | Korona szwedzka | 1 SEK | 0.4152 | 0.4382 | 0.023
Korona estońska | 1 EEK | 0.2496 | 0.2758 | 0.0262 |  | Korona estońska | 1 EEK | 0.2522 | 0.2732 | 0.021
Łat łotewski | 1 LVL | 5.5102 | 6.0902 | 0.58 |  | Łat łotewski | 1 LVL | 5.5682 | 6.0322 | 0.464
Spreadsheet: 126040d1319487848-formula-problem-fsc-masterlist
Sheet: PREMIER

3.35 | 0.285
 | 0.285
 | 0.285
 | 0.285
 | 0.285
 | 0.29
 | 0.29
 | 0.29
 | 0.29
 | 0.29
 | 0.295
 | 0.295
 | 0.295
 | 0.295
 | 0.295
 | 0.3
 | 0.3
 | 0.3
 | 0.3
 | 0.3
 | 0.305
 | 0.305
 | 0.305
 | 0.305
 | 0.305
 | 0.31
 | 0.31
 | 0.31
 | 0.31
 | 0.31
 | 0.315
 | 0.315
 | 0.315
 | 0.315
 | 0.315
 | 0.32
 | 0.32
 | 0.32
 | 0.32
 | 0.32
 | 0.325
 | 0.325
 | 0.325
 | 0.325
 | 0.325
 | 0.33
 | 0.33
 | 0.33
 | 0.33
 | 0.33
 | 0.335
 | 0.335
 | 0.335
 | 0.335
 | 0.335
 | 0.34
 | 0.34
 | 0.34
 | 0.34
 | 0.34
 | 0.345
 | 0.345
 | 0.345
 | 0.345
 | 0.345
 | 0.35
Spreadsheet: 30804c6f-1b91-42fe-ba78-93439b1026b8
Sheet: Sheet1

Unnamed: 0 | COMMERCIAL VALUATIONS for | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | FIRE SPRINKLER WORKSHEET
 | Job Address:
 |  | USE | SQ. FT. |  | VALUE |  |  |  | VALUATION*
 |  | EXISTING NON-SPRINKLED BUILDING
 |  | ASSEMBLY |  | X | 152.63 |  |  | = | 0
 |  | BUSINESS |  | X | 117.17 |  |  | = | 0
 |  | EDUCATION  K-12 |  | X | 146.52 |  |  | = | 0
 |  | FACTORY |  | X | 76.15 |  |  | = | 0
 |  | HAZARDIOUS |  | X | 90.13 |  |  | = | 0
 |  | INSTITUTAL |  | X | 150.12 |  |  | = | 0
 |  | MERCANTILE |  | X | 97.19 |  |  | = | 0
 |  | RESIDENTIAL,  HOTEL |  | X | 125.32 |  |  | = | 0
 |  | STORAGE |  | X | 69.57 |  |  | = | 0
 |  | UTILITY |  | X | 53.15 |  |  | = | 0
 |  | TOTAL EXISTING VALUE |  |  |  | TOTAL A |  | = | 0
 |  | FACTORED EXISTING VALUE | 0 | X | 0.25 | TOTAL B |  | = | 0
 |  | FACTORED EXISTING VALUE FOR |  |  |  |  |  | =
 |  | ASSEMBLIES ONLY | 0 | X | 0.1 | TOTAL C |  | = | 0
 |  | NEW CONSTRUCTION/ADDITION
 |  | ASSEMBLY |  | X | 152.63 |  |  | = | 0
 |  | BUSINESS |  | X | 117.17 |  |  | = | 0
 |  | EDUCATION  K-12 |  | X | 146.52 |  |  | = | 0
 |  | FACTORY |  | X | 76.15 |  |  | = | 0
 |  | HAZARDIOUS |  | X | 90.13 |  |  | = | 0
 |  | INSTITUTAL |  | X | 150.12 |  |  | = | 0
 |  | MERCANTILE |  | X | 97.19 |  |  | = | 0
 |  | RESIDENTIAL,  HOTEL |  | X | 125.32 |  |  | = | 0
 |  | STORAGE |  | X | 69.57 |  |  | = | 0
 |  | UTILITY |  | X | 53.15 |  |  | = | 0
 |  |  |  |  |  | TOTAL D |  | = | 0
 |  | REMODELED AREAS, includes work requiring permit per  IBC as amended.
 |  | ASSEMBLY |  | X | 152.63 | X | 0.3 | = | 0
 |  | BUSINESS |  | X | 117.17 | X | 0.3 | = | 0
 |  | EDUCATION  K-12 |  | X | 146.52 | X | 0.3 | = | 0
 |  | FACTORY |  | X | 76.15 | X | 0.3 | = | 0
 |  | HAZARDIOUS |  | X | 90.13 | X | 0.3 | = | 0
 |  | INSTITUTAL |  | X | 150.12 | X | 0.3 | = | 0
 |  | MERCANTILE |  | X | 97.19 | X | 0.3 | = | 0
 |  | RESIDENTIAL,  HOTEL |  | X | 125.32 | X | 0.3 | = | 0
 |  | STORAGE |  | X | 69.57 | X | 0.3 | = | 0
 |  | UTILITY |  | X | 53.15 | X | 0.3 | = | 0
 |  |  |  |  |  | TOTAL E |  | = | 0
 |  | TOTAL NEW AND [NAME], (D+E) |  |  |  | TOTAL F |  | = | 0
 | IF F >B FIRE SPRINKLERS WILL BE REQUIRED
 | 0
 | ASSEMBLIES ONLY   IF F >C FIRE SPRINKLERS WILL BE REQUIRED
 | 0
 | IF TOTAL F >50% of TOTAL A
 | 0
 | * Values are based on the ICC Building Safety Journal, Jan-Feb 2010. |  |  |  |  |  | locked, revised 6/10/2010
 | The scope of work and related square footages provided are subject to field verification.  Where discrepancies are encountered by the inspector, work shall stop and a new worksheet shall be completed, inclusive of the entire known scope of work.  Sprinklers shall be installed if indicated on the revised worksheet.
Spreadsheet: 37779d1235785807-excel-2007-if-and-or-formulae-formulae1
Sheet: if and 1

No | Day | Date | Time | Category | Race | Horse No | Horse | Age | Sex | Form | Distance | Class | Track Conditions | Race Type | Field 8 - 14 | Barrier 1 - 8 (<1400) | Barrier 1 - 12 (>1400) | Weight | Days since Last race | Distance Increase + | Distance Decrease - | Last Start - Track Conditions | SORT
3 | Fri | 30/5/2008 | 14.5 | Gallops | 6 | 3 | Show No Mercy | 3 | G | .-4321x | 1400 | R70 | H | Gallop | 10 | 7 | 0 | 99 | 107 | 0 | 50 | F
4 | Fri | 30/5/2008 | 19.37 | Trots | 4 | 6 | Cammander Steel | 2 | C | -322 | 1700 | Juv | F | Mobile Pace | 8 | 0 | 0 | 0 | 14 | 0 | 500 | F
5 | Fri | 30/5/2008 | 20.45 | Trots | 6 | 13 | Pasi | 4 | G | 212812 | 2200 | 1-2w | F | Trot | 16 | 0 | 0 | 0 | 15 | 0 | 500 | F
6 | Fri | 30/5/2008 | 21.09 | Trots | 7 | 8 | London Legend | 8 | G | 70x052 | 1950 | 3+w | F | Gallop | 8 | 0 | 0 | 99 | 15 | 0 | 0 | F
7 | Fri | 30/5/2008 | 21.19 | Trots | 7 | 7 | Maheer Skipper | 3 | C | x51421 | 2200 | 2-3w | S | Mobile Pace | 15 | 0 | 14 | 0 | 15 | 0 | 0 | F
8 | Fri | 30/5/2008 | 21.43 | Trots | 8 | 7 | Malosi | 3 | G | 7x1121 | 2600 | 1-2w | F | Gallop | 12 | 0 | 0 | 99 | 8 | 900 | 0 | S
9 | Fri | 30/5/2008 | 21.53 | Trots | 8 | 1 | Top Tempo | 4 | M | x17133 | 2700 | 4-5w | F | Pace | 12 | 0 | 0 | 0 | 10 | 0 | 0 | F
10 | Fri | 30/5/2008 | 22.17 | Trots | 9 | 8 | Idid it Myway | 5 | G | x1001D | 2600 | 3+w | F | Gallop | 10 | 0 | 0 | 0 | 14 | 0 | 0 | F
11 | Fri | 30/5/2008 | 22.52 | Trots | 10 | 2 | Eden Burst | 4 | G | 242441 | 2700 | 1-2w | F | Mobile Pace | 12 | 0 | 0 | 99 | 7 | 0 | 0 | F
Spreadsheet: 104121d1301762862-nested-if-statement-test
Sheet: Metro West Portal Accruals

MW Region 2011 1st Qtr Accurals Portal PO's |  |  |  |  |  |  | 0 | 81364.96 | 81364.96 | 33837.96 | 47527
P.O. Number | Order number | Amount | Project Description | Original or FCO Scope | Work Completion Date |  | Accrual SAP Data - Totals | Difference | Accrual Amount | Final SAP Data - Totals | Final Difference | Accrual Reversals
[PHONE] | TD384961 | 33957.62 | 25 - Plant Betterment 350 - Gateway 4KV | FCO | 2011-01-05 00:00:00 |  | 0 | 33957.62 | 33957.62 | 8837.96 | 25119.66 | 25119.66
[PHONE] | TD385468 | 28169.6 | 25 - Plant Betterment 350 - Gateway 4KV | SCOPE | 2011-01-05 00:00:00 |  | 0 | 28169.6 | 28169.6 | 0 | 28169.6 | 28169.6
[PHONE] | TD439165 | 19237.74 | 23 - Scott Brackets - Trochu 16KV | FCO | 2011-01-06 00:00:00 |  | 0 | 19237.74 | 19237.74 | 25000 | -5762.259999999998 | 19237.74
Spreadsheet: 781610d1653442322-better-way-count-text-entries-specific-columns-multiple-sheets-thanks-sample-data-copy-1-
Sheet: Summary

 |  |  |  |  | Assume all sheets are the same structure
 |  |  |  |  | Then use 1st as a base
 |  | Tech 1 | Tech 2 | Tech 3 |  |  | Tech Feature 1 Status | Tech Feature 2 Status | Tech Feature 3 Status | Tech Feature 4 Status | Tech Feature 5 Status
 | Reviewing
 | In Development
 | [NAME]
 | Blcoked
 | No Interest
Spreadsheet: 267872d1380258641-listing-question-losguapos1_with-count-ans
Sheet: Sheet1

 | Day 1 |  |  | Day 2 |  |  | Day 3 |  |  | Day 4 |  |  | Day 5
Student 1 |  |  |  |  |  |  | 16,84
Student 2 |  |  |  | 16,84 |  |  |  |  |  |  |  |  |  |  |  |  | Day 1 | Day 2 | Day 3 | Day 4 | Day 5
Student 3 | 16,83 |  |  |  |  |  | 16,33 |  | 16,25
Student 4
Student 5 | 16,84 | 16,84 | 16,58 |  |  |  |  |  |  |  |  |  |  | 16,32 | 16,88
Student 6 |  |  |  | 16,84 | 13,84
Student 7 |  |  |  |  |  |  |  |  |  | 13,84 |  |  | 16,84 | 13,84
Student 8
Student 9 | 15,87 | 16,88 |  |  |  |  | 17,85
Student 10
Student 11 |  |  |  | 16,84 |  |  |  |  |  |  | 16,84 |  | 16,87
Student 12 |  |  |  | 18,84 |  |  |  |  |  |  |  |  | 16,84
Student 13 |  |  |  |  |  |  |  |  |  |  |  |  | 18,84
Student 14 |  |  |  |  |  |  | 20,85 |  |  |  |  |  |  |  |  |  | Array formula is used.[NAME] can be dragged.
Student 15 |  |  |  |  |  |  |  |  |  |  |  | 16,88 |  |  |  |  | ( After entering formula Press Ctrl+Shift+Enter [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name will be listed If 16 is available in any column of day.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No repetition of Name on same day
Spreadsheet: 773652d1647975569-tabulating-data-for-specific-dates-copy
Sheet: Summary

 | A120
Date | OK | NOK | NOK %
2022-02-28 00:00:00
2022-03-01 00:00:00
2022-03-02 00:00:00
2022-03-03 00:00:00
2022-03-04 00:00:00
2022-03-05 00:00:00
2022-03-06 00:00:00
2022-03-07 00:00:00
2022-03-08 00:00:00
2022-03-09 00:00:00
2022-03-10 00:00:00
2022-03-11 00:00:00
2022-03-12 00:00:00
2022-03-13 00:00:00
2022-03-14 00:00:00
2022-03-15 00:00:00
2022-03-16 00:00:00
2022-03-17 00:00:00
2022-03-18 00:00:00
2022-03-19 00:00:00
2022-03-20 00:00:00
2022-03-21 00:00:00
2022-03-22 00:00:00
AVG.
Spreadsheet: 671267d1586335475-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: WAGES SHEET

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
WEEKLY SUMMARY SHEET |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEKLY SUMMARY SHEET |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WAGE
PERIOD |  | FROM: |  |  |  | TO: |  |  |  |  |  | NO.: | 1/2 | PERIOD |  | FROM: |  |  |  | TO: |  |  |  |  |  | NO.: | 2/2 |  | EMPLOYEE | TOTALS
NO. | EMPLOYEE | MON | TUES | WED | THU | FRI | SAT | SUN | F/R | O/T | SUN | VL | SL | NO. | EMPLOYEE | MON | TUES | WED | THU | FRI | SAT | SUN | F/R | O/T | SUN | VL | SL |  |  | O/T | O/T SUNDAYS | VL | SL
12 |  | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  | 12 |  | 5 | 5 | 5 | 5 | 5
11 |  | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  | 11 |  | 5 | 5 | 5 | 5 | 5
14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
33 |  | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  | 33 |  | 5 | 5 | 5 | 5 | 5
37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
53 |  |  |  |  |  |  |  |  |  |  |  |  |  | 53
54 |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
50 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
51 |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
52 |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
55 |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
26 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
47 |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
Spreadsheet: 376585d1423655170-calculating-file-intervals-from-300-to-300-volumes
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of files | Interval | Folder's number
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 101
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 269
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
Spreadsheet: 686088d1594356389-modify-formula-to-exclude-paid-fee-sample
Sheet: Sheet1

Invoice Date | Client Number | First Name | Last Name | Lead Source | Invoice Total | Payment Total | Open Balance | Photographer Name | Sales Representative | Assistant | Booker | Make-Up Artist | [NAME] | Invoice Status | Invoice Classification | Session Type | State | Units | Units2 | Units3 | <1000 | <1 | Open | Month | Week | Day | Duplicate | 10% or 150 | Selected? | Column1 | UF4 | UF | Column2 | Session Type |  |  |  | Qualification Status | Balancing |  |  |  | 0 | 0 | 0 |  |  | Qualification
2020-06-24 00:00:00 | 200179581NAV | Parker | Nave | MS_20_2_S | 300 | 300 | 0 | None | Rivy | None | Rivy | None | Photographed | Paid Fee | Session Deposit  Fee |  | NSW | 0 | 1 | 0 | 1 | 0 | 0 | June '20 | 157 | Wednesday | 1 |  | 0 | 1 | 0 | 0 | 1
2020-06-24 00:00:00 | 200178792FOR | Raissa | [NAME] | MS_20_2_S | 1680 | 1680 | 0 | None | Joecille | None | Joecille | None | Photographed | Paid Fee | Session Deposit  Fee |  | NSW | 0 | 1 | 0 | 0 | 0 | 0 | June '20 | 157 | Wednesday | 1 |  | 0 | 1 | 0 | 0 | 1
2020-06-24 00:00:00 | 300181605TAG | [NAME] | Tagiloa | MS_20_2_M | 389 | 389 | 0 | None | Rose | None | Rose | None | Booked | Paid Fee | Booking Fee |  | VIC | 0 | 1 | 0 | 1 | 0 | 0 | June '20 | 157 | Wednesday | 1 |  | 0 | 1 | 0 | 0 | 1
2020-06-24 00:00:00 | 300183072SIN | Manasvi | Singh | Multi-Step Enquiry | 1769 | 1769 | 0 | None | Jade | None | Jade | None | Booked | Paid Fee | Booking Fee |  | VIC | 0 | 1 | 0 | 0 | 0 | 0 | June '20 | 157 | Wednesday | 1 |  | 0 | 1 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(P2="No Sale",1,IF(O2="Paid Fee",0,IF(AND(G344)>=(F2*10%)),1,"NC"))
Spreadsheet: 330515d1404772135-summing-across-multiple-sheets-by-specific-name-vlookup-june_template-trivia-scorecard
Sheet: Week2

TEAM NAME: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | TOTAL |  |  |  | Cumulative
Stepdads | 7 | 7 | 6 | 7 | 5 | 16 | 24
I'm Here For The Beer | 3 | 5 | 4 | 5 | 3 | 10 | 30
The Horribles | 3 | 3 | 2 | 2 | 6 | 8 | 24
Quechee Quirks | 5 | 6 | 7 | 4 | 6 | 14 | 0
[NAME] | 2 | 3 | 4 | 5 | 5 | 0 | 19
Becky & Geoff | 7 | 3 | 6 | 6 | 7 | 0 | 0
HAL | 5 | 2 | 3 | 4 | 2 | 8 | 0
Danites | 5 | 4 | 5 | 4
[NAME] |  |  | 3 | 5 | 2
[NAME] | 4
Spreadsheet: 2d63aa9a-7481-443e-a0ac-63516ba44283
Sheet: Sheet1

UIP range | # of clans
0 | 4
0-0.05 | 0
0.05-0.1 | 1
0.1-0.15 | 1
0.15-0.2 | 4
0.2-0.25 | 5
0.25-0.3 | 2
0.3-0.35 | 3
0.35-0.4 | 2
0.4-0.45 | 2
0.45-0.5 | 7
0.5-0.55 | 2
0.55-0.6 | 5
0.6-0.65 | 1
0.65-0.7 | 3
0.7-0.75 | 1
0.75-0.8 | 2
0.8-0.85 | 1
0.85-0.9 | 0
0.9-0.95 | 0
0.95-1 | 4
UIP value of each clan was assigned to 10 intervals (0-0.1; 0.1-0.2; 0.2-0.3; …0.9-1).
Spreadsheet: 169755d1343051276-formula-across-multiple-sheets-salary-july-2012
Sheet: Mar

Sr. No. | Name | Designation | CTC | P.M. Salary | Ac/No. | Pay | Hold
1 | [NAME] | RM | 120000 |  | xxx3833 |  | 0
2 | [NAME] | RM | 120000 |  | [NAME] |  | 10000
3 | Zee | Sr. RM | 240000 |  | xxx6698 |  | 0
4 | Stanley | Team Leader | 360000 |  | xxx6871 |  | 0
5 | Ria | RM | 120000 |  | xxx8721 |  | 0
6 | [NAME] | RM | 120000 |  | xxx8751 |  | 0
7 | Nargis | RM | 120000 |  | xxx3581 |  | 0
8 | Leah | Sr. RM | 180000 |  | xxx9989 |  | 0
 | New Joinees |  |  | Resigned
 | 0 |  |  | 0
Spreadsheet: 780451d1652457599-getting-an-error-code-when-trying-to-add-more-conditions-columns-to-an-if-statement-calendar-draft
Sheet: 3 Events Per Day Monthly View

2022 | <-- Manually type the year | Test A
June | <-- Select the month from the drop down menu
Spreadsheet: 232309d1367384920-society-scoring-system-template-society-scoring-system-template
Sheet: northampton

 |  |  | Am Results |  |  |  |  |  |  |  | Pm Results
 | Name          H/caps |  | Front 9 | Back 9 | Total | Points |  |  | Name         H/caps |  | Front 9 | Back 9 | Total | Points
Leaders in red
 | Team Ball   S Walmsley, B Fearnley, M Squire, P Hargrieves  70 points
 | Handicap change  P Hargrieves, 10   C Allpress 19