tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__23061__0111MarginRequirements
Sheet: Template

FUTURES MARGIN REQUIREMENTS
2001-11-27 00:00:00
2001-11-26 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | OTE | Initial Margin
ABN-Amro Inc |  |  |  | 0
ADM INVESTOR |  |  |  | 0
BANK ONE |  |  |  | 0
CARR FUTURES (NG) |  |  |  | 0
CARR FUTURES INC. |  |  |  | 0
CREDIT SUISSE FIRST BOSTON |  |  |  | 0
EDF MAN
FIMAT |  |  |  | 0 |  |  |  | 1
HSBC - US$ |  |  |  | 0
HSBC - Canadian | 0 |  |  | 0
JP Morgan |  |  |  | 0
[NAME] |  |  |  | 0
PARIBAS |  |  |  | 0
PRUDENTIAL SI |  |  |  | 0
REFCO, INC |  |  |  | 0
R J O'BRIEN |  |  |  | 0
SAUL STONE & COMPANY |  |  |  | 0
SMITH BARNEY, INC |  |  |  | 0
SMITH BARNEY, INC  (Financial) |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0
Smith Barney
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: bb35b185-c0e6-4d78-a86f-a201b24fe971
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TAMV | Test | TAMV | Thermoactinomyces vulgaris, IgG Antibodies, Serum | Thermoactinomyces vulgaris, [NAME] | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | 0-12 years: < or =6.6 mg/L 13-18 years: < or =11.0 mg/L >18 years: < or =23.9 mg/L | Monday through Friday; 9 a.m.-8 p.m. | Same day/1 day | 4 days | 1 | 86671 |  |  |  |  | Rochester
TAMV | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TAMV | Result | TAMV | Thermoactinomyces vulgaris, [NAME] | Thermoactinomyces vulgaris, [NAME] | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 34190-9 | Thermoactinomyces vulgaris Ab.[NAME]:MCnc:Pt:Ser:Qn:
Spreadsheet: 754773d1636493202-searching-a-value-different-tabs-using-some-conditionals-planilha-de-transporte-2022-1-
Sheet: CALCULO GERAL

 |  | VALOR PROCURADO | SEARCHED VALUE
 |  | CONDICIONAIS | CONDITIONALS
 |  | LOCAL | VEÍCULO
ORIGIN | SAÍDA | SP | IVECO | VAN
ARRIVE | CHEGADA | SÃO PAULO - SP
 |  | DATA |  | O USUÁRIO VAI SELECIONAR 03 OPÇÕES (TIPO DE VEÍCULO / FILIAL DE ORIGEM / DESTINO) E INFORMAR AS DATAS
CHARGE | CARGA | 2021-12-05 00:00:00 |  | THE USER WILL SELECT 03 OPTIONS (TYPE OF VEHICLE - TRUCK / BRANCH ORIGIN / DESTINY ) AND INFORM DATES
DISCHARGE | DESCARGA | 2021-12-05 00:00:00 |  | A CONDICIONAL DA DATA SÓ VAI DEFINIR A QUANTIDADE DE VIAGENS QUE SERÃO REALIZADAS
 |  |  |  | SE FOR NO MESMO DIA VAI CONSIDERAR 2 PERNAS E SE NÃO FOR VAI CONSIDERAR 4 PERNAS (NOMENCLATURA PARA CADA VIAGEM DO CAMINHÃO)
 |  |  |  | THE CONDITIONAL DATE WILL DEFINY ONLY THE QUANTITY OF TRAVELS THAT WILL BE MAKED
 |  |  |  | IF IT'S ON THE SAME DAY, WILL CONSIDER 2 LEGS AND IF DON'T, IT WILL CONSIDER 4 LEGS (LEGS IS THE NOMENCLATURE TO EACH TRAVEL OF THE TRUCK)
COST | CUSTO |  | O VALOR SERÁ BUSCADO [NAME] O LOCAL DE SAÍDA FOR SP, O VALOR SERÁ PUXADO DA ABA SP LEVANDO EM CONTA A INFORMAÇÃO DE DATA, SE FOREM DIFERENTES PUXA UM VALOR, SE IGUAIS PUXAM OUTRO
SELL | VENDA |  | [NAME] O VALOR COM A MARGEM DE LUCRO JÁ EMBUTIDA
 |  |  | THE VALUE WILL BE SEARCHED IN THE CORRESPONDENT TABS - IF THE LOCAL OF ORIGIN IS SP, THE VALUE WILL BE PULLED OUT FROM THE TAB SP, CONSIDERING THE INFORMATION OF DATE, IF THEY ARE DIFFERENT, PULLS A VALUE, IF EQUAL, PULLS ANOTHER
 |  |  | HERE WE'LL PRESENT THE VALUE WITH THE PROFIT MARGE ALREADY INSERT
Spreadsheet: fd48eb8b-7949-49c7-9be0-72413282924d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  |  |  |  |  | Table 25 | Household by type and number of persons 15 years old or more
 |  |  |  |  |  |  | September 2010 |  |  |  |  |  |  |  |  |  | (Ten thousand households)
 |  |  |  |  |  |  | Type of household |  | Total | Number of persons 15 years old or more in household
 |  |  |  |  |  |  |  |  |  | Average number of persons 15 years old or more in household (persons)
 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 persons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | or more
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
2500 | 85090 |  | 1 |  |  |  | Total | 1 | 5116 | 2.13 | 1617 | 2078 | 791 | 462 | 117 | 40 | 10
2500 | 85090 |  | 1 |  |  |  | Two-or-more-person household | 2 | 3554 | 2.62 | 55 | 2078 | 791 | 462 | 117 | 40 | 10
2500 | 85090 |  | 1 |  |  |  | Relative household | 3 | 3549 | 2.63 | 55 | 2073 | 791 | 462 | 117 | 40 | 10
2500 | 85090 |  | 1 |  |  |  | Nuclear family household | 4 | 2950 | 2.4 | 55 | 1996 | 601 | 269 | 27 | 1 | 0
2500 | 85090 |  | 1 |  |  |  | Other relative household | 5 | 599 | 3.75 | - | 77 | 190 | 193 | 90 | 39 | 9
2500 | 85090 |  | 1 |  |  |  | Non-relative household | 6 | 5 | 2.02 | - | 5 | 0 | - | - | - | -
2500 | 85090 |  | 1 |  |  |  | One-person household | 7 | 1562 | 1 | 1562 | - | - | - | - | - | -
Spreadsheet: theresa_staab__39643__Independent email
Sheet: Summary

 |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  |  | Verification Date:
 |  | Enron North America Corp. |  |  | Independent Production Company, Inc. | 2001-12-06 00:00:00
 |  |  |  |  | Bank: U.S. Bank National Association
 |  |  |  |  | ABA:  102000021 | Due Date:
 |  |  |  |  | Acct:  [PHONE] | 2001-12-26 00:00:00
 |  |  |  |  | Contact:  [NAME]
 |  |  |  |  | Tel:  (303) 595-8829 X27 | Payment Method:
 |  | Contact:  [NAME] |  |  |  | Wire
 |  | Tel:  (303) 575-6485 |  |  |  | Terms:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | Fax: (303) 595-3653 | 25th of month following production
2001-12-06 14:22:26.160000
Delivery Period: | Contract # | Meter # / Meter Name
2001-11-01 00:00:00 | 96023736 | 0814015-Independent 47N73WSec.9
 | Index | Discount / Premium | Price/MMBtu | Mcf Quantity | MMBtu Quantity | Amount Due
11/01/01 - 11/30/01 | CIG GD | -0.4112 | 1.339716258357922 | 78849.78305044443 | 73882 | 98980.9166
11/01/01 - 11/30/01 | IF NGPL-Midcont. | -0.6558 | 2.3842 | 298539.9510365701 | 279731 | 666934.6502
11/01/01 - 11/30/01 | IF CIG - Rockies | -0.4182 | 2.1218 | 16851.7104892466 | 15790 | 33503.222
11/01/01 - 11/30/01 |  | Fuel Loss | $             0.00 | 18674.55542373889 | 17498 | $                                        0.00
Total |  |  |  | 412916 | 386901 | 799418.7888
 | Hanover Compression Charges |  |  |  |  | 0
 | Facility Fee |  |  |  |  | -15000
 | Field Services Fee |  |  |  |  | 0
Prior Month Adjustments
 |  |  |  |  | Adjustment | 0
 |  |  | TOTAL PAYMENT
Spreadsheet: 218551d1362498062-returning-value-in-row-based-on-critieria-excel-example
Sheet: Sheet1

 |  | $0 to $50K | $51K to $100K | $101K to $150K | $151K to $200K | $201K to $250K | $251K to $300K | $301K to $350K | $351K to $400K | $401K to $450K | $451K to $500K | $501K to $550K | $551K to $600K | $601K to $650K | $651K to $700K | $701K to $750K | $751K to $800K | $801K to $850K | $851K to $900K | $901K to $950K | $951K to $1M | $1M to $1.05M | $1.05M to $1.1M | $1.1M to $1.15M | $1.15M to $1.2M | $1.2M to $1.25M | $1.25M to $1.3M | $1.3M to $1.35M | $1.35M to $1.4M | $1.4M to $1.45M | $1.45M to $1.5M | $1.5M to $1.55M | $1.55M to $1.6M | $1.6M to $1.65M | $1.65M to $1.7M | $1.7M to $1.75M | $1.75M to $1.8M | $1.8M to $1.85M | $1.85M to $1.9M | $1.9M to $1.95M | $1.95M to $2M | $2M or More
 | Starting Median Price of Top 10% of SFN Home Sales | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total
 | $251K to $300K | 384 | 0 | 0 | 0 | 0 | 408 | 596 | 669 | 702 | 728 | 742 | 756 | 762 | 763 | 764 | 764 | 764 | 765 | 765 | 767 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768 | 768
Spreadsheet: 779082d1651579460-how-change-vba-to-formula-and-functions-non-vba-calendar-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holidays | Pub Holiday Description
 |  | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | New Year's Day
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  |  |  |  |  | 2022-03-21 00:00:00 | Human Rights Day
 |  |  | 2022-05-31 00:00:00 | 2022-06-01 00:00:00 | 2022-06-02 00:00:00 | 2022-06-03 00:00:00 | 2022-06-04 00:00:00 | 2022-06-05 00:00:00 |  |  |  |  |  |  | 2022-04-15 00:00:00 | Good Friday
 |  | 2022-06-06 00:00:00 | 2022-06-07 00:00:00 | 2022-06-08 00:00:00 | 2022-06-09 00:00:00 | 2022-06-10 00:00:00 | 2022-06-11 00:00:00 | 2022-06-12 00:00:00 |  |  |  |  |  |  | 2022-04-17 00:00:00 | Easter Sunday
 |  | 2022-06-13 00:00:00 | 2022-06-14 00:00:00 | 2022-06-15 00:00:00 | Youth Day | 2022-06-17 00:00:00 | 2022-06-18 00:00:00 | 2022-06-19 00:00:00 |  |  |  |  |  |  | 2022-04-18 00:00:00 | Family Day
 |  | 2022-06-20 00:00:00 | 2022-06-21 00:00:00 | 2022-06-22 00:00:00 | 2022-06-23 00:00:00 | 2022-06-24 00:00:00 | 2022-06-25 00:00:00 | 2022-06-26 00:00:00 |  |  |  |  |  |  | 2022-04-27 00:00:00 | Freedom Day
 |  | 2022-06-27 00:00:00 | 2022-06-28 00:00:00 | 2022-06-29 00:00:00 | 2022-06-30 00:00:00 | 2022-07-01 00:00:00 | 2022-07-02 00:00:00 | 2022-07-03 00:00:00 |  |  |  |  |  |  | 2022-05-02 00:00:00 | Workers' Day
 |  | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 | 2022-07-06 00:00:00 | 2022-07-07 00:00:00 | 2022-07-08 00:00:00 | 2022-07-09 00:00:00 | 2022-07-10 00:00:00 |  |  |  |  |  |  | 2022-06-16 00:00:00 | Youth Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-18 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-08-09 00:00:00 | National Women's Day
 |  | Public Holidays | Pub Holiday Description |  |  |  |  |  |  |  |  |  |  |  | 2022-09-24 00:00:00 | Heritage Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-16 00:00:00 | Day of Reconciliation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-25 00:00:00 | Christmas Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-26 00:00:00 | Day of Goodwill
Spreadsheet: 328398d1403886940-solver-error-in-maximizing-a-correlation-coefficient-y-index-index-correlations-excelforum
Sheet: S. IMD+Y

 | Y |  |  |  | S. IMD |  |  |  |  | CORRELATION (rank):
 |  |  |  |  | S. IMD Score | Rank | Standard Rank | Standard Score |  | Correlation (score):
 |  |  |  |  |  |  |  |  |  | [NAME]:
 |  |  |  |  |  |  |  |  |  |  |  | `
 |  |  |  |  | NOTE: [NAME]. scored countries as highest score being most well off (Y is the opposite). Rank was constructed similar to the Y index with least well off country (lowest score) given rank=1.
 |  |  |  |  | Standard score constructed with average-observeration in order to compensate for oppositely constructed scores.
Spreadsheet: 737471d1624435247-calculate-cell-value-based-on-time-and-day-sample-40-ans
Sheet: Sheet1

Column 1 | Start Date | Day | Person 1 | (Person 2) | Start Time | Finish Time | Total duration | End Date | End Day | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | CP | NON CP | CP - Intened | NON CP Intened
 | 2021-04-27 00:00:00 | Tuesday | Person 1 | Person 4 | 10:30:00 | 16:00:00 | 5.5 | 2021-04-27 00:00:00 | Tuesday | 1 | 1 | Yes |  | DP |  |  | 4.5 | 1
 | 2021-04-27 00:00:00 | Tuesday | Person 2 | Person 5 | 10:30:00 | 14:00:00 | 3.500000000000001 | 2021-04-27 00:00:00 | Tuesday | 1 | 1 | Yes |  | DP |  |  | 3.5 | 0
 | 2021-04-29 00:00:00 | Thursday | Person 3 | Person 5 | 13:00:00 | 14:00:00 | 1.000000000000002 | 2021-04-29 00:00:00 | Thursday | 1 | 1 | Yes |  | DP |  |  | 1 | 0
 | 2021-05-04 00:00:00 | Tuesday | Person 3 | Person 5 | 09:30:00 | 14:00:00 | 4.500000000000002 | 2021-05-04 00:00:00 | Tuesday | 1 | 1 | Yes |  | DP |  |  | 4.5 | 0
 | 2021-05-11 00:00:00 | Tuesday | Person 3 | Person 5 | 11:00:00 | 16:30:00 | 5.5 | 2021-05-11 00:00:00 | Tuesday | 1 | 1 | Yes |  | DP |  |  | 4 | 1.5
Spreadsheet: 824566d1680677631-adding-name-from-one-spreadsheet-to-another-spreadsheet-only-if-it-doesnt-already-exist-name-to-name-test
Sheet: MASTER

TEE BOX | NCGA HDCP # | PLAYER                       (+2/3 for blues)
W | 11680664 | ABLE
W | 1239641 | BRAD
B | 8450703 | CHRIS
B | 10748018 | DAVE
B | 11114788 | [NAME]
W | 11637304 | FRED
B | 11620923 | GREG
B | 9683463 | HANK
 |  |  |  | I am going to add "MIKE" and "ISAAC" to this spreadsheet. I need [NAME] to get added to the YEARS PLAYED spreadsheet and then the cell in column D needs to add an "x". Since [NAME] is already on the YEARS PLAYED spreadsheet, I just need the cell in column D to add the "x".
Spreadsheet: 680195d1590852302-index-match-for-less-than-match-type-index-match_match-type
Sheet: Sheet1

 |  | 2020-05-31 00:00:00 | 2020-04-30 00:00:00 | 2020-03-31 00:00:00 | 2020-02-29 00:00:00 | 2020-01-31 00:00:00
djnc | haha | 12 | 34 | 56 | 98 | 85
oinc | hehe | 78 | 89 | 910 | 54 | 52
wsnc | hoho | 1112 | 1314 | 1516 | 321 | 63
 |  | Index Match |  | [NAME]
Greather than
criteria 1 | haha
criteria 2 | 2020-04-01 00:00:00
Exact
criteria 1 | haha
criteria 2 | 2020-03-31 00:00:00
Less than
criteria 1 | haha
criteria 2 | djnc
criteria 3 | 2020-03-30 00:00:00
Spreadsheet: a1f7911e-ffd9-4093-9eca-1fba242b7d57
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Authorizing contracts for 2009 Community Development Block Grant
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax) |  |  |  |  |  |  |  |  |  | General Fund
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY2008-09 |  |  | FY2009-10
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | x | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY2008-09 |  |  | FY2009-10
 | General Fund |  |  |  | 0
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | x | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 184173d1349174032-people-change-can-the-graph-change-with-them-864746
Sheet: Sheet1

 | Driver ID | Speeding Events | Distance(km) | [NAME] Speed(kph) | Month
 | Anomi | 1 | 116.4 | 113 | July
 | [NAME] | 6 | 1005.8 | 113 | July
 | [NAME] | 95 | 5211.1 | 121 | July
 | [NAME] | 9 | 1148.6 | 121 | July
 | [NAME] | 40 | 2380.7 | 134 | July
 | [NAME] | 166 | 3256 | 135 | July
 | Melvin | 22 | 2121.6 | 117 | July
 | [NAME] | 4 | 139.9 | 126 | July
 | [NAME] | 13 | 2064.1 | 122 | July
 | [NAME] | 0 | 62 | 100 | July
 | Anomi | 12 | 2033.6 | 134 | August
 | [NAME] | 1 | 722.4 | 116 | August
 | [NAME] | 25 | 5329.7 | 119 | August
 | [NAME] | 3 | 2998 | 129 | August
 | [NAME] | 10 | 2576.2 | 135 | August
 | Melvin | 0 | 2155.4 | 129 | August
 | [NAME] | 9 | 3156.4 | 127 | August
 | [NAME] | 0 | 2499 | 114 | August
 | [NAME] | 2 | 2010.6 | 119 | August
 | Anomi | 1 | 1124.1 | 122 | September
 | [NAME] | 0 | 1676.6 | 114 | September
 | Duane Poore | 0 | 137.4 | 109 | September
 | [NAME] | 3 | 1421.5 | 108 | September
 | [NAME] | 23 | 4929.9 | 121 | September
 | [NAME] | 3 | 2286.6 | 122 | September
 | [NAME] | 6 | 2547.1 | 129 | September
 | Melvin | 3 | 2066.2 | 116 | September
 | [NAME] | 1 | 1704.1 | 116 | September
 | [NAME] | 1 | 1789.3 | 116 | September
 | [NAME] | 5 | 1907.4 | 117 | September
 | UNKNOWN | 2 | 797.8 | 108 | September
 | [NAME] | 0 | 57.9 | 114 | September
Spreadsheet: 848249d1699008190-formula-to-capture-attendance-login-shift-adherence
Sheet: Login Logout Data

Agent Name | Agent ID | Split/Skill | Date | [NAME] | Logout Time | Off Hours (Calculated)
A | 1234 | 1981 | 2023-09-27 00:00:00 | 10:20:00 | 17:34:00
A | 1234 | 1981 | 2023-09-27 00:00:00 | 17:59:00 | 18:32:00
A | 1234 | 1981 | 2023-09-27 00:00:00 | 18:32:00 | 20:32:00
A | 1234 | 1981 | 2023-09-28 00:00:00 | 12:07:00 | 15:25:00
A | 1234 | 1981 | 2023-09-28 00:00:00 | 16:35:00 | 18:42:00
A | 1234 | 1981 | 2023-09-28 00:00:00 | 19:09:00 | 19:11:00
C | 2345 | 1982 | 2023-09-27 00:00:00 | 17:41:00 | 19:39:00
C | 2345 | 1982 | 2023-09-27 00:00:00 | 19:41:00 | 21:55:54
C | 2345 | 1983 | 2023-09-27 00:00:00 | 22:41:58 | 02:30:00
D | 6789 | 1984 | 2023-09-27 00:00:00 | 10:24:00 | 14:01:58
D | 6789 | 1985 | 2023-09-27 00:00:00 | 15:35:32 | 17:45:00
D | 6789 | 1981 | 2023-09-27 00:00:00 | 18:53:28 | 20:42:00
E | 1000 | 1982 | 2023-09-27 00:00:00 | 10:28:00 | 11:42:18
E | 1000 | 1982 | 2023-09-27 00:00:00 | 13:35:00 | 17:50:00
E | 1000 | 1982 | 2023-09-27 00:00:00 | 18:23:00 | 22:44:00
Spreadsheet: 701655d1603877355-how-to-add-sumifs-formula-to-express-time-value-example-answerded-sumifs
Sheet: Lookup tabels

POSITIONS | SHIFT START AND FINISH STANDARD HOURS |  | SHIFT TIMES REQUIRED VARIANCES TO OPENING/CLOSING TIMES |  |  |  |  | AWARD RATES as at | dd-mmm-yy
 | Start (24-hour format) | Finish (24-hour format) | Start (hh:[NAME]) | Start details | End (hh:[NAME]) | End details |  | SECTION | RATE | SELECT RATE TYPE | H - Hourly D - Daily
Zone Manager |  |  | 03:00:00 | Before External Doors | 01:30:00 | Post Show |  | Manager | 1650 | D
Security Manager |  |  | 03:00:00 | Before External Doors | 02:00:00 | Post Show |  | Supervisor | 56 | H
Control Room Manager |  |  | 03:00:00 | Before External Doors | 02:00:00 | Post Show |  | Control Room | 56 | H
Control Room |  |  | 01:30:00 | Before External Doors | 01:30:00 | Post Show |  | Security Guard | 52 | H
Supervisor |  |  | 01:30:00 | Before External Doors | 01:00:00 | Post Show |  | Control Room Manager | 1650 | D
Supervisor Early Start |  |  | 03:00:00 | Before External Doors | 01:00:00 | Post Show
Security Guard |  |  | 01:00:00 | Before External Doors | 00:45:00 | Post Show
Security Guard Suites |  |  | 01:00:00 | Before External Doors | 01:30:00 | Post Show
Security Guard Early Start |  |  | 02:30:00 | Before External Doors | 00:45:00 | Post Show
Security Guard Early Finish |  |  | 01:00:00 | Before External Doors | 06:00:00 | Post Shift Start
Security Guard - Backstage |  |  | 03:30:00 | Before External Doors | 01:30:00 | Post Show
F&B Security |  |  | 01:00:00 | Before External Doors | 01:00:00 | Post Show
Spreadsheet: 728387d1618423053-consolidation-of-tables-table-consolidation
Sheet: Table consolidation

Table 1 |  |  |  | Table 2 |  |  |  | Table 3 |  |  |  | Table 4
A: | Data |  |  | A: | Sometimes data, if data in B |  |  | A: | Blank |  |  | A: | Data from A in Table 1 and Table 2, sorted in ascending order
B: | Blank |  |  | B: | Data |  |  | B: | Sometimes data, if data in C |  |  | B: | Data from B in Table 2 and Table 2, sorted in ascending order
C: | Blank |  |  | C: | Blank |  |  | C: | Data |  |  | C: | Data from C in Table 2, sorted in ascending order
A | B | C |  | A | B | C |  | A | B | C |  | A | B | C |  | A | B | C
8 |  |  |  | 5 | 6 |  |  |  |  | 10 |  | 1 | 2 |  |  |  | 2
5 |  |  |  |  | 9 |  |  |  | 6 | 7 |  | 5 | 6 | 7 |  | 5 | 6 | 7
 |  |  |  | 1 | 2 |  |  |  | 3 | 4 |  | 5 | 6 | 13 |  | 5 | 6 | 13
 |  |  |  | 5 | 11 |  |  |  | 6 | 13 |  | 5 | 11 | 12 |  | 5 | 11 | 12
 |  |  |  |  | 3 |  |  |  | 11 | 12 |  | 5 | 14 |  |  | 5 | 14
 |  |  |  | 5 | 14 |  |  |  | 15 | 17 |  | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 17 |  |  | 15 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10
General: |  |  |  |  |  |  |  |  |  |  |  | Line two (5, 6, 7) is a merge of line 1 in Table 2 (5, 6, blank) and line 2 in Table 3 (blank, 6, 7)
A single A can point to many [NAME] which again can point to many [NAME]. |  |  |  |  |  |  |  |  |  |  |  | Line three  (5, 6, 13) is a merge of line 1 in Table 2 (5, 6, blank) and line 4 in Table 3 (blank, 6, 13)
A single C can point to only one B which again can point to only one A. |  |  |  |  |  |  |  |  |  |  |  | Line four (5, 11, 12) is a merge of line 4 in Table 2 (5, 11, blank) and line 5 in Table 3 (blank, 11, 12)
[NAME] should work with both text entries and number entries. |  |  |  |  |  |  |  |  |  |  |  | Line 2, 3, 4 and 5 absorbes line 2 in Table 1
 |  |  |  |  |  |  |  |  |  |  |  | Line 7 absorbes line 5 of table 2
Spreadsheet: 152320d1335346070-how-to-create-win-or-lose-statment-with-specific-out-come-book1
Sheet: Sheet1

 |  | Here is what i have so far.
 |  | I have created
 |  | 10 rows of
 |  | =TEXT(RANDBETWEEN(0,1),"""Heads"";;""Tails"""). Every time
 |  | 4 heads in
 |  | a row apear
 |  | it counts as
 |  | a win. How
 |  | would that be
 |  | put in an
 |  | if stament to
 |  | have win or
 |  | lose appearor is there another formula. there another formula.