tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 778686d1651224520-building-a-dynamic-formula-to-simplify-relations-substitute-len-excel-simplify-relations_substitute_len_countif_search
Sheet: Sheet1

 |  | Can someone guide me in the right direction… to go from yellow to green, with a dynamic (in-between) formula in blue
 |  |  |  | Helper Cells |  | (LEN($B6)-LEN(SUBSTITUTE($B6;E$5;"")))/LEN(E$5)
 | Relations between people | [NAME] |  | Anna | [NAME] | Casper | Dirk | Eva | [NAME] | Gerard | Hilde | Isabel |  | Group of relations
 | Anna-Dirk, [NAME], Casper-Fiona | ?? |  |  |  |  |  |  |  |  |  |  |  | [NAME], Casper-Fiona
 | [NAME], Isabel-Boris, Eva-Isabel, [NAME], Dirk-Boris, Eva-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Boris-Dirk, Fiona-Eva, [NAME], Dirk-Hilde |  |  |  |  |  |  |  |  |  |  |  |  | Boris-Dirk-Hilde, [NAME]
 | Isabel-Anna, Eva-Boris, Hilde-Casper, Isabel-Gerard, Fiona-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | Isabel-Anna-Gerard, Eva-Boris, Hilde-Casper, Fiona-Dirk
 | Dirk-Casper, Fiona-Eva, [NAME], Dirk-Hilde, [NAME], Fiona-Hilde |  |  |  |  |  |  |  |  |  |  |  |  | Dirk-Casper-Hilde-Fiona-Isabel-Gerard-Eva
 | [NAME], Isabel-Anna, Eva-Hilde, Dirk-Casper |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Eva-Hilde, Dirk-Casper
 | Eva-Isabel, Eva-Dirk |  |  |  |  |  |  |  |  |  |  |  |  | Eva-Isabel-Dirk
 | …
 | [NAME], [NAME], Casper-Eva, Isabel-Fiona |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 | Sample DATA in [B6:B14] |  |  | List of 9 People: |  |  |  |  |  |  |  |  |  | I Hardcoded the preferred FORMAT in [O6:O14]
 |  | I've been stuck on this (seemingly simple) dynamic formula-problem, for over 2 years now (since 2019)…
Spreadsheet: 141872d1329491758-sumifs-across-multiple-worksheets-monthly-sheet
Sheet: ASISTENCIA

Modalidad | Nombre de Alumno | Apellido | [NAME] | Clases [NAME] | Horas | Porcentaje de asistencia
PRIVADA | JENNIFER | SOTO
PRIVADA | DIEGO | GRANADOS
STARTER | DANIEL | LANYON
STARTER | FABIOLA | MALDONADO
STARTER | ROBERTO | DONOSO
Spreadsheet: 788357d1658416004-sumifs-or-countifs-on-multiple-rows-and-columns-holiday-planner-for-testing
Sheet: Team Annual Leave

 | Deductions |  |  | Leave
Name | SICK LEAVE | OTHER | OVERTIME | PLANNED ANNUAL LEAVE | UNPLANNED ANNUAL LEAVE | TOTAL ANNUAL LEAVE BOOKED/TAKEN | ANNUAL LEAVE LEFT | ANNUAL LEAVE ENTITLEMENT
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 | Holiday
 | Unplanned Holiday
 | 1/2 Holiday
 | Sick
 | 1/2 Sick
 | Other - Unpaid give details
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 1/2 Bank Holiday
 | Bank Holiday
Spreadsheet: 467890d1467036755-setting-the-solver-properly-201606_mode-le-simplifie-
Sheet: results_by_clusters

Cluster | Variable 1 | Variable 2 | Variable 3 | Variable 4 | Variable 5 | Variable 6 | Variable 7 | Variable 8 | Variable 9 | Variable 10 | Variable 11 | Variable 12 | Variable 13
1 | 16700 | 500 |  |  | 100 | 110000 |  |  | 0 | 10 | 200
2 | 14500 | 1000 |  |  | 250 | 250000 |  |  | 0 | 5 | 100
3 | 83000 | 2500 |  |  | 550 | 300000 |  |  | 0 | 10 | 700
4 | 140000 | 6873 |  |  | 1400 | 700000 |  |  | 0 | 30 | 2000
5 | 420000 | 13227 |  |  | 3400 | 1800000 |  |  | 0 | 90 | 4000
6 | 830000 | 37000 |  |  | 8000 | 2500000 |  |  | 0 | 250 | 20000
7 | 1320000 | 49000 |  |  | 14000 | 3400000 |  |  | 0 | 500 | 19000
8 | 1700000 | 64000 |  |  | 18000 | 5000000 |  |  | 0 | 2000 | 50000
Total |  |  |  |  |  |  |  |  | 0
Cluster | Variable 1 | Variable 2 | Variable 3 | Variable 4 | Variable 5 | Variable 6 | Variable 7 | Variable 8 | Variable 9 | Variable 10 | Variable 11 | Variable 12 | Variable 13 | Variable 14
1 |  |  |  | 0.02994011976047904 |  | 110000 |  |  | 0 | 1 | 90 |  |  |  | adjustment equation
2 |  |  |  | 0.06896551724137931 |  | 250000 |  |  | 0 | 1 | 87 |  |  |  | adjustment equation
3 |  |  |  | 0.03012048192771084 |  | 300000 |  |  | 0 | 17 | 700 |  |  |  | adjustment equation
4 |  |  |  | 0.04909285714285714 |  | 700000 |  |  | 0 | 27 | 1300 |  |  |  | adjustment equation
5 |  |  |  | 0.03149285714285714 |  | 1800000 |  |  | 0 | 88 | 4000 |  |  |  | adjustment equation
6 |  |  |  | 0.04457831325301205 |  | 2500000 |  |  | 0 | 241 | 10000 |  |  |  | adjustment equation
7 |  |  |  | 0.03712121212121212 |  | 3400000 |  |  | 0 | 480 | 19000 |  |  |  | adjustment equation
8 |  |  |  | 0.03764705882352941 |  | 5000000 |  |  | 0 | 1812 | 50000 |  |  |  | adjustment equation
Total |  |  |  | 0.04049975686309182 |  |  |  |  |  |  |  |  |  | -
1 | fonction à maximiser
 | Cell M30 - sum of rows of Variable 12 |  |  |  |  |  | Cluster | Equation | R^2
 |  |  |  |  |  |  | 1 | y = 0.0196x - 2.1226 | 0.90362 |  | 0.0196 | -2.12
 |  |  |  |  |  |  | 2 | y = 0.014x - 1.585 | 0.98749 |  | 0.014 | -1.585
 |  |  |  |  |  |  | 3 | y = 0.0096x - 1.1889 | 0.9933 |  | 0.0096 | -1.1889
 |  |  |  |  |  |  | 4 | y = 0.0058x - 0.6645 | 0.99425 |  | 0.0058 | -0.6645
 |  |  |  |  |  |  | 5 | y = 0.0046x - 0.5637 | 0.99281 |  | 0.0046 | -0.5637
 |  |  |  |  |  |  | 6 | y = 0.0057x - 0.8221 | 0.96397 |  | 0.0057 | -0.82
 |  |  |  |  |  |  | 7 | y = 0.0039x - 0.6414 | 0.85533 |  | 0.0039 | -0.6414
 |  |  |  |  |  |  | 8 | y = 0.0024x - 0.3525 | 0.95644 |  | 0.0024 | -0.35
2 | constraints
 |  | Upper bound |  |  | Upper bound |  |  | Lower bound
 | V1 | [NAME] |  | V3 | [NAME] |  | V3 | Min V3 |  | Variable 13 | target variable 13
 |  | Lower bound
 | Variable 5 | Min variable 5
Spreadsheet: 54473d1254455242-loan-calculator-framework-extra-repayments-multiple-loans-loans-sample
Sheet: Car Loan

Period | Extra Repayments | Interest | Repayments/Year | Number of Repayments | [NAME] | [NAME] | Principle Payment | Interest Payment | Final Repayment | Principle
0 |  | 0.1 | 26 |  |  |  |  |  |  | 20000
 | 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
 | 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
 | 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
Spreadsheet: chris_germany__1978__Ponderosa Pine Est Imbalance0502
Sheet: Sheet1

Ponderosa Pine Energy Cleburne Plant
TXU Lone Star Pipeline
May, 2002
Estimated Usages*
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
RECEIVED | 34517 | 34650 | 34650 | 34650 | 34650 | 34650 | 34650 | 44550 | 44550 | 44550
DELIVERED | 46582.503 | 38779 | 39407 | 40571 | 43385 | 38488 | 38749 | 42525 | 39764 | 42788
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
RECEIVED | 39600 | 39600 | 39600 | 34650 | 34650 | 0 | 0 | 0 | 0 | 0
DELIVERED | 41388 | 35996 | 37133 | 40162 | 43913 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
*These numbers are based on estimates and are subject to change
Spreadsheet: 887526d1737749619-due-dates-formula-for-month-end-close-calendar-month-end-close-due-dates-012325-philipsfn-
Sheet: Copy

Revenue Month End Closing Schedule
 | Day - Quarter | Day | Due Date | Frequency
 | 15th | -15 |  | Monthly |  |  | Day 1 of Feb Close |  |  | Day 1 of Mar Close | 2024-03-01 00:00:00 |  | Holidays
 | 15th | -15 |  | Monthly |  |  | Day 2 of Feb Close |  |  |  |  |  | 2024-02-17 00:00:00
 | 20th | -20 |  | Monthly |  |  | Day 3 of Feb Close |  |  |  |  |  | 2024-03-17 00:00:00
 | D -10 to -5 | -10 |  | Monthly |  |  | Day 4 of Feb Close
 | D -10 to -5 | -5 |  | Monthly
 | D -10 to -5 | -10 |  | Quarterly |  |  | 2/1/25 is a Saturday so needs to be excluded
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly |  |  | For Quarterly items we need to only use the working days of the Quarter excluding Saturday, Sundays and Holidays.
 | D-1 | -1 |  | Monthly |  |  | March close schedule is on the third tab
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Monthly
 | D-1 | -1 |  | Quarterly
 | D1 | 1 |  | Monthly
 | D1 | 1 |  | Monthly
 | D1 | 1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | -1 |  | Monthly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D1 | 1 |  | Quarterly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | 1 |  | Quarterly
 | D 1 | 1 |  | Quarterly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D 1 | -1 |  | Monthly
 | D2 | 2 |  | Monthly
 | D2 | 2 |  | Monthly
 | D2 | 2 |  | Quarterly
 | D2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D 2 | 2 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 2 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Monthly
 | D3 | 3 |  | Quarterly
 | D3/D4 | 4 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Monthly
 | D6 | 6 |  | Quarterly
 | D6 | 6 |  | Monthly
 | D6 - D9 | 6 |  | Quarterly
 | D6 - D9 | 6 |  | Quarterly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 9 |  | Monthly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 8 |  | Monthly
 | D 6 | 6 |  | Monthly
 | D6 - D9 | 8 |  | Monthly
 | D 6 | 6 |  | Quarterly
 | D6 - D9 | 8 |  | Quarterly
 | D 6 | 6 |  | Quarterly
 | D 6 | 6 |  | Quarterly
 | D 8 | 8 |  | Quarterly
 | D10 | 10 |  | Quarterly
 | D10 | 10 |  | Quarterly
 | D11 | 11 |  | Monthly
 | D20+ | 20 |  | Quarterly
 | D20+ | 20 |  | Quarterly
 | D20+ | 20 |  | Quarterly
Spreadsheet: 868631d1715321514-return-value-from-cols-and-rows-us-states-workdays-for-a-given-period-example4
Sheet: Working (2)

Period
2024-04-01 00:00:00
2024-04-30 00:00:00
Name |  |  |  |  | State | Workdays in month of Prov. State
Ahmed, [NAME] |  |  |  |  | IL
Aibak, Haneen
Albors, [NAME]
[NAME], [NAME]
Alphonse, [NAME]
[NAME], [NAME]
Aref, [NAME]
Bahrami, [NAME]
Barck, Tawna
Bhama, [NAME]
Bhasin, [NAME]
[NAME], [NAME]
Brainard, Meredith
Brown, Miariesha
Bryant, Nichell
Bunal, [NAME]
[NAME], [NAME]
Cartier, [NAME]
Catrell, [NAME]
Cha, [NAME]
Chambers, [NAME]
Chheda, Neel
[NAME], [NAME]
[NAME], [NAME]
Conte, [NAME]
Cortes, Frances
Cribley, Iryna
Cruz, [NAME]
Culver, Tori
[NAME], [NAME]
Dadhania, Akruti
Danner, Kimberly
[NAME], [NAME]
Denor, [NAME]
DeWire, [NAME]
Dhaliwal, Navdeep
Dhaliwal, Rajandeep
Dockendorf, Salome
[NAME], Cecily
Dupre, [NAME]
Duvall, Charlotte
[NAME], [NAME]
Estes, [NAME]
Fagbemi, Olumide
[NAME], [NAME]
Fletcher, Yukari
[NAME], [NAME]
Fox, Nikolous
[NAME], [NAME]
[NAME], [NAME]
[NAME], Elissa
Fricks, [NAME]
Gallaway, Rebecca
Gandia, Victoria
Gates, Shaleena
Gayles, Keyona
Gilliver, [NAME]
Go, [NAME]
Golez, Pauline
Goodman, [NAME]
Gorazd, [NAME]
Grandhi, [NAME]
[NAME], [NAME]
Gross, Amanda
Guirguis, [NAME]
[NAME], [NAME]
Haberbush, [NAME]
Hall, Charlene
Hamblen, [NAME]
Hartwig-Mullally, Corinna
Heard, [NAME]
[NAME], Grayce
[NAME], [NAME]
Hoener, [NAME]
Holloway, Micahl
[NAME], [NAME]
Homolka, Saydee
Hooper, [NAME]
[NAME], [NAME]
[NAME], Sheriva
Iredia, [NAME]
Ivy, Mellissa
Jacks, [NAME]
Jelks, [NAME]
[NAME], [NAME]
Joachim, Carthia
Jobe, [NAME]
[NAME], [NAME]
[NAME], [NAME]
[NAME], Olivia
[NAME], [NAME]
Jones, [NAME]
Jones, [NAME]
[NAME], [NAME]
Kam, [NAME]
Kamau, [NAME]
[NAME], [NAME]
[NAME], Gibril
Kaur, Jasdeep
[NAME], Rajwinder
Kaur, Ramandeep
Kemper, Malinda
Keya, Dominic
Khavshaba, Elena
Klein, [NAME]
Kwon, [NAME]
Lambie, Ianthe
[NAME], [NAME]
Liauw, Shannon
Lopez, Heather
Louis, Makenson
Macadangdang, Cesar
Manoharan, Arun
McCalister, Kenzi
McKenzie, [NAME]
Medina, [NAME]
Mershon, Sharelle
Milford, Danielle
Monk-Beckley, [NAME]
[NAME], [NAME]
Montgomery, Autumn
Moonat, Ashish
Mote, [NAME]
Mudey, Yonis
Mussa, Zaina
Myers, [NAME]
Nebrija, Kristine
[NAME], [NAME]
[NAME], [NAME]
Njenga, [NAME]
[NAME], [NAME]
[NAME], [NAME]
Ocfemia, Rommel
Oke, Adenike
Oliveira, Adrienne
[NAME], [NAME]
[NAME], [NAME]
Panlasigui, Leonico
[NAME], [NAME]
Parker, Selby
Patrito, Gina
Patton, Miciah
Petiote, Fredely
Pribble, [NAME]
Quetgles, Tabatha
Quinones, Angelica
Raney, Tiffany
Reed, [NAME]
Richards, Shirmel
Rook, Jodi
Rozul, Laisa
[NAME], Soheila
Sanchious, Felecia
Sandhu, [NAME]
[NAME], [NAME]
[NAME], [NAME]
Schutz, [NAME]
Sharma, Aishwarya
Shepherd, Tess
Sherrill, [NAME]
Shillcutt, Kayla
Shuff, Lorelei
Singh, Supriya
Smith, [NAME]
Soames, Garrett
[NAME], Leo
Swint, [NAME]
[NAME], [NAME]
Taleghani, Masoud
[NAME], [NAME]
[NAME], [NAME]
Tran, Mi
Tran, [NAME]
Trino, [NAME]
Troeh, [NAME]
[NAME], [NAME]
Udo, Bernarde
Urraca, Priscila
[NAME], Donis
Watts, [NAME]
White, [NAME]
Wilkins, Denita
Wilson, Cawonda
Windsor, Patrice
Witherspoon, Fabienne
[NAME], [NAME]
[NAME], [NAME]
0
[NAME], [NAME]
Spreadsheet: daren_farmer__5017__HPLN0313
Sheet: Sheet1

HPLN0310.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - March 10-12, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-03-13 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 755417d1636843695-need-a-standard-deviation-question-answered-question
Sheet: Sheet1

SAMPLE NUMBERS
2500
3400
2150
3475
3338
1950
3538
2775
3200
3400
3050
2500
2013
2988
3538
3400
2425
2013
2500
2638
2575
2425
2638
3613
2988
2988
2988
2913
3888
2288
2638
2913
4450
3475
3050
2713
2288
3338
3888
3200 |  |  |  | MEAN
3125 |  |  |  | STANDARD DEVIATION
3400 |  |  |  | STANDARD DEVIATON - ERROR
2363 |  |  |  |  | LOWER | UPPER | FREQUENCY | PERCENT
2713 |  |  |  | STANDARD DEVIATION 1
3750 |  |  |  | STANDARD DEVIATION 2
2575 |  |  |  | STANDARD DEVIATION 3
2913
3750
2575
3400
Spreadsheet: 176706d1346078057-indexing-with-duplicates-issue-copy-of-department-position-status-working-file-2
Sheet: Claims

Claims | Claims
 | Filled Positions |  |  |  |  |  |  |  |  |  |  |  |  | Open Positions
 | Title | Location | Category |  | Hiring Manager | Number of Openings | Number Filled | Date Activated | Date Filled | Start Date | Business Days to Offer | Comments |  |  | Title | Location | Category | Hiring Manager | Created Date | Age | Comments
Spreadsheet: 200563d1355648874-trying-to-make-vertical-horizontal-flip-but-how-example
Sheet: Curve

Month | Planed Value | Actual Value | Planned% | Actual %
Spreadsheet: 750408d1633441827-automating-color-coding-and-trend-help-needed-data-color-coding-request
Sheet: 7-8-2016

 | ServiceNow Data Accuracy
 | Computers
 |  | Assigned to | Asset Function | [NAME] | Model | Acquisition Method | Computers not reporting Inventory | Cost
 | Total Records | 48940 | 48940 | 48940 | 48940 | 48940 | 48940 | 48940
 | Missing Data Records | 1100 | 0 | 4500 | 485 | 1000 | 1351 | 720
 | Percentage of Missing Data
 | Server-(storage, Disk, Server)
 |  | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 2401 | 2401 | 2401 | 2401 | 2401 | 2401
 | Missing Records | 221 | 0 | 1886 | 597 | 1150 | 2347
 | Percentage of Missing Data
 | Network Gear
 |  | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 7287 | 7287 | 7287 | 7287 | 7287 | 7287
 | Missing Records | 188 | 677 | 7002 | 96 | 4746 | 7269
 | Percentage of Missing Data
 | US Cycle Count 6-17-2016
 | State | In transit available | In stock available | In stock used | Pending repair | Data Retention
 | Total Records | 325 | 145 | 868 | 13 | 89
 | Missing Records | 325 | 145 | 868 | 13 | 89
 | [NAME] |  | 1 | 1 | 1 | 1
 | Asset Reconciliation 2016 |  | Remediated Records
 | 30+ Day Audits/Site Asset Reconciliation |  | 7104
 | VMware |  | 3422
 | WebServer, AppServer, Disk, ETC |  | 5812
 | Total Infrastructure Asset Record Clean up
 | Duplicates based on Serial Number | 2016-06-22 00:00:00 | 2016-09-08 00:00:00
 | Comptuers | 187 | 0
 | Servers | 7225 | 454
 | Network Gear | 600 | 593
Spreadsheet: 697578d1601412485-nested-if-statement-with-greater-or-less-than-a-negative-number-testforhelp
Sheet: Sheet1

LINE SEGMENT | P/S_On | P/S_Off | Depol/Native | Criteria Met? | MILEPOST | STATION NUMBER | END_STATION | FEET | Observations | Notes | YEAR
201520_ROL_GER_24 | -1.657 | -1.234
201520_ROL_GER_24 | -1.654 | -1.232
201520_ROL_GER_24 | -0.875 | -0.67
201520_ROL_GER_24 | -1.654 | -1.232
201520_ROL_GER_24 | -1.654 | -1.232
Spreadsheet: 34556d1231868979-vlookup-to-pull-data-from-two-sheets-into-a-summary-inventory-compare
Sheet: 2007

Details | [NAME] | Square Feet | Year
Cherry- Flooring - FAS - Standard | 2.5 | 77 | 2007
Cherry- Flooring - FAS - Standard | 3.5 | 841 | 2007
Cherry- Flooring - FAS - Standard | 4.5 | 963 | 2007
Cherry- Flooring - FAS - Standard | 10.5 | 552 | 2007
Walnut - Flooring - 1 Com - Worn Edge | 2.5 | 493 | 2007
Walnut - Flooring - 1 Com - Worn Edge | 3.5 | 508 | 2007
Walnut - Flooring - 1 Com - Worn Edge | 4.5 | 605 | 2007
Walnut - Flooring - 1 Com - Worn Edge | 7.5 | 627 | 2007
Walnut - Flooring - 1 Com - Worn Edge | 9.5 | 724 | 2007
Cherry - Flooring - Rustic - Standard | 4.5 | 442 | 2007
Cherry - Flooring - Rustic - Standard | 5.5 | 816 | 2007
Cherry - Flooring - Rustic - Standard | 6.5 | 62 | 2007
Cherry - Flooring - Rustic - Standard | 7.5 | 75 | 2007
Cherry - Flooring - Rustic - Standard | 8.5 | 1018 | 2007
Cherry - Flooring - Rustic - Standard | 9.5 | 105 | 2007
Cherry - Flooring - Rustic - Standard | 10.5 | 863 | 2007
Maple - Flooring - Select - Standard | 4.5 | 66 | 2007
Maple - Flooring - Select - Standard | 5.5 | 157 | 2007
Maple - Flooring - Select - Standard | 6.5 | 525 | 2007
Maple - Flooring - Select - Standard | 7.5 | 207 | 2007
Maple - Flooring - Select - Standard | 8.5 | 557 | 2007
Maple - Flooring - Select - Standard | 9.5 | 351 | 2007
Maple - Flooring - Select - Standard | 10.5 | 856 | 2007
Hickory - Flooring - 1 Com - Worn Edge | 2.5 | 736 | 2007
Hickory - Flooring - 1 Com - Worn Edge | 3.5 | 1095 | 2007
Hickory - Flooring - 1 Com - Worn Edge | 4.5 | 149 | 2007
Spreadsheet: 39019d1237235179-lookup-reference-help-backmatch-examples
Sheet: Sheet1

2009-01-02 00:00:00 | 2009-01-03 00:00:00 | 2009-01-04 00:00:00 | 2009-01-05 00:00:00 | 2009-01-06 00:00:00 | 2009-01-07 00:00:00 |  | largest | BackMatch
143 | 56 | 606 | 268 | 471 | 435 |  | 606 | 2009-01-04 00:00:00
736 | 174 | 628 | 675 | 279 | 712 |  | 736 | 2009-01-02 00:00:00
189 | 66 | 126 | 506 | 808 | 418 |  | 808 | 2009-01-06 00:00:00
155 | 436 | 77 | 456 | 68 | 125 |  | 456 | 2009-01-05 00:00:00 |  | Range you are testing
77 | 28 | 21 | 297 | 682 | 470 |  | 682 | 2009-01-06 00:00:00 |  | Value you are trying to match
805 | 808 | 119 | 905 | 932 | 598 |  | 932 | 2009-01-06 00:00:00 |  | Range of Dates
836 | 21 | 526 | 724 | 520 | 510 |  | 836 | 2009-01-02 00:00:00
226 | 275 | 152 | 335 | 718 | 566 |  | 718 | 2009-01-06 00:00:00
76 | 923 | 409 | 114 | 464 | 913 |  | 923 | 2009-01-03 00:00:00
618 | 56 | 718 | 149 | 515 | 541 |  | 718 | 2009-01-04 00:00:00
698 | 256 | 989 | 868 | 267 | 452 |  | 989 | 2009-01-04 00:00:00
2009-01-01 00:00:00 | 2009-01-02 00:00:00 | 2009-01-03 00:00:00 | 2009-01-04 00:00:00 | 2009-01-05 00:00:00 | 2009-01-06 00:00:00 | 2009-01-07 00:00:00 | 2009-01-08 00:00:00 | 2009-01-09 00:00:00 | Largest | BackMatch
711 | 321 | 312 | 941 | 118 | 974 | 812 | 110 | 39 | 974 | 2009-01-06 00:00:00
3 | 602 | 958 | 887 | 450 | 770 | 510 | 690 | 360 | 958 | 2009-01-03 00:00:00
23 | 931 | 825 | 129 | 929 | 399 | 529 | 420 | 794 | 931 | 2009-01-02 00:00:00
381 | 145 | 135 | 772 | 447 | 611 | 372 | 487 | 445 | 772 | 2009-01-04 00:00:00
982 | 171 | 966 | 304 | 960 | 500 | 646 | 14 | 914 | 982 | 2009-01-01 00:00:00
394 | 704 | 3 | 298 | 523 | 695 | 382 | 448 | 475 | 704 | 2009-01-02 00:00:00
625 | 945 | 469 | 259 | 652 | 899 | 847 | 309 | 929 | 945 | 2009-01-02 00:00:00
609 | 974 | 73 | 573 | 769 | 660 | 230 | 272 | 32 | 974 | 2009-01-02 00:00:00
481 | 216 | 64 | 937 | 522 | 153 | 99 | 935 | 686 | 937 | 2009-01-04 00:00:00
459 | 730 | 847 | 88 | 587 | 689 | 960 | 398 | 243 | 960 | 2009-01-07 00:00:00
677 | 369 | 125 | 618 | 237 | 332 | 103 | 677 | 974 | 974 | 2009-01-09 00:00:00
Spreadsheet: 04ac40d8-7e78-4352-97ce-9873fa4e62e3
Sheet: 4.2(NS) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(NS): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | NS - Natural Science
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | na | na | na | na
Notes:
Spreadsheet: 885274d1734730351-filter-lists-for-forum
Sheet: Account

Date | NW Type | NW Description (Who) | NW Value (Amount) | Tag | Chq # | CiB? | Transact ID | AccTotal |  | Notes 1 | Notes 2 | DocLink
2025-01-01 00:00:00 | D/D | Club Systems SaaS (Club V1) Q1 | -778.5 | ITClubV1 | N |  |  |  |  |  |  | https://d.docs.live.net/0dd51a63f509eb65/OneDrive%20Woodland/EGC/Finance/EGC%20Finance%20Documents/Club%20V1%202025%20DD%20Schedule.pdf
2025-04-01 00:00:00 | D/D | Club Systems SaaS (Club V1) Q2 | -667.5 | ITClubV1 | N |  |  |  |  |  |  | https://d.docs.live.net/0dd51a63f509eb65/OneDrive%20Woodland/EGC/Finance/EGC%20Finance%20Documents/Club%20V1%202025%20DD%20Schedule.pdf
2025-07-01 00:00:00 | D/D | Club Systems SaaS (Club V1) Q3 | -778.5 | ITClubV1 | N |  |  |  |  |  |  | https://d.docs.live.net/0dd51a63f509eb65/OneDrive%20Woodland/EGC/Finance/EGC%20Finance%20Documents/Club%20V1%202025%20DD%20Schedule.pdf
2025-10-01 00:00:00 | D/D | Club Systems SaaS (Club V1) Q4 | -667.5 | ITClubV1 | N |  |  |  |  |  |  | https://d.docs.live.net/0dd51a63f509eb65/OneDrive%20Woodland/EGC/Finance/EGC%20Finance%20Documents/Club%20V1%202025%20DD%20Schedule.pdf